-- phpMyAdmin SQL Dump
-- version 4.9.11
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jul 02, 2024 at 12:52 AM
-- Server version: 8.0.35
-- PHP Version: 7.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `cpplgmp_attendance`
--

-- --------------------------------------------------------

--
-- Table structure for table `leave_card`
--

CREATE TABLE `leave_card` (
  `id` int NOT NULL,
  `plant_id` varchar(11) NOT NULL DEFAULT ' ',
  `firstname` varchar(100) NOT NULL DEFAULT ' ',
  `emp_id` varchar(50) NOT NULL DEFAULT ' ',
  `total_leave` varchar(50) NOT NULL DEFAULT ' ',
  `leave_taken` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT ' ',
  `leave_balance` varchar(50) NOT NULL DEFAULT ' '
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `leave_card`
--

INSERT INTO `leave_card` (`id`, `plant_id`, `firstname`, `emp_id`, `total_leave`, `leave_taken`, `leave_balance`) VALUES
(1, '96', 'Rajan Desai', '73', ' 25', ' ', '25'),
(63, '96', 'Pankaj O Kanani', '133', '25', '5', '20'),
(64, '96', 'Ganesh L. Patil', '278', '25', '1.00', '24.00'),
(65, '96', 'Sanjay C.Patel', '293', '25', '2.00', '21.00'),
(66, '96', 'Anurag M. Khare', '339', '25', NULL, '21.00'),
(67, '96', 'Hardik J. Patel', '349', '25', '1.00', '20.00'),
(68, '96', 'Ashok Ahir', '383', '25', '1.00', '22.00'),
(69, '96', 'Mehul Rana', '402', '25', '2.00', '20.00'),
(70, '96', 'Maruti Ghadge', '556', '25', '4.00', '16.00'),
(71, '96', 'Bhushan Wani', '610', '25', NULL, '22.00'),
(72, '96', 'Mohamad Salim', '628', '25', NULL, '23.00'),
(73, '96', 'Jatin Patel', '634', '25', '1.00', '21.00'),
(74, '96', 'Yatin Patel', '787', '25', '1.00', '23.00'),
(75, '96', 'Vikas Jha', '934', '25', NULL, '21.00'),
(76, '96', 'Mr. Rahul Parmar', '936', '25', '3.00', '20.00'),
(77, '96', 'Amit jain', '1075', '25', '8', '17'),
(78, '96', 'Chintan Ashvinbhai Patel', '1117', '25', '2.00', '22.00'),
(79, '96', 'Banti Kumar Maheshbhai Patel', '1119', '25', '5', '20'),
(80, '96', 'Patel Jigneshbhai', '1136', '25', '3', '22'),
(81, '96', 'Adarsh Kashyap Singh', '1138', '25', '1.00', '10.00'),
(82, '96', 'Pandya Pratik Ashwinkumar', '1156', '25', '2.00', '21'),
(83, '96', 'Milankumar Rameshbhai Patel', '1160', '25', '17.00', '6'),
(84, '96', 'Chetankumar Ramoliya', '1169', '25', '1.00', '19'),
(85, '96', 'Manojkumar Rathod', '1171', '25', '2.00', '22'),
(86, '96', 'Rajendra kumar Dhakar', '1182', '25', NULL, '14'),
(87, '96', 'Avnit Sumanbhai Patel', '1243', '25', '1.00', '23'),
(88, '96', 'Vijay Mohan Borse', '1307', '25', '2.00', '17.00'),
(89, '96', 'Singh Anandkumar Hirasingh', '1309', '25', '4', '21'),
(90, '96', 'Prajapati Tejaskumar Manojbhai', '1324', '25', '3.00', '20.00'),
(91, '96', 'Rajput Krunal Dineshbhai', '1393', '25', '1.00', '18.00'),
(92, '96', 'Bikash Kumar Pradhan', '1403', '25', '3.00', '0.00'),
(93, '96', 'Akshay Nanasaheb Patil', '1408', '25', '3', '-3'),
(94, '96', 'Ankit Kumar', '1409', '25', '2.00', '17.00'),
(95, '96', 'Parmar Harshadkumar', '1411', '25', '4.00', '17.00'),
(96, '96', 'Ganesh Babasaheb Rahane', '1438', '25', '2', '23'),
(97, '96', 'Amol Dilip Shelke', '1443', '25', '3.00', '19.00'),
(98, '96', 'Dewang Harikewalbhai Yadav', '1468', '25', '3', '22'),
(99, '96', 'Abdulla Shaikh', '1471', '25', '23.5', '1.5'),
(100, '96', 'Rimohkumar Gulabbhai Patel', '1499', '25', '2.00', '3.00'),
(101, '96', 'Manish Bhikhubhai Patel', '1502', '25', '2', '-2'),
(102, '96', 'Satish Chand S Tiwari', '1569', '25', '17.5', '-17.5'),
(103, '96', 'Archita Padhihary', '1638', '25', '3.00', '17.00'),
(104, '96', 'Viral Govind Barot', '1639', '25', '6', '19'),
(105, '96', 'Prajapati Chirag', '1642', '25', '1.00', '20.00'),
(106, '96', 'Vikaskumar Kantilal Patel', '1648', '25', '1.00', '20.00'),
(107, '96', 'Patil Riteshkumar Subhashbhai', '1660', '25', '1.00', '16.00'),
(108, '96', 'Patel Bhavin Dilipbhai', '1665', '25', NULL, '17.00'),
(109, '96', 'Rama shankar Pandey', '1673', '25', NULL, '14.00'),
(110, '96', 'Rohit Rajkumar Rameshbhai', '1675', '25', '3.00', '17.00'),
(111, '96', 'Hiteshbhai Manubhai Patel', '1736', '25', '6', '-6'),
(112, '96', 'Abhishek Mani Tripathi', '1756', '25', '2.00', '19.00'),
(113, '96', 'Narendra Kumar Singh', '1758', '25', '4', '21'),
(114, '96', 'Parmar Meghal', '1759', '25', '2', '-2'),
(115, '96', 'Patel Mayurkumar Laxmanbhai', '1805', '25', NULL, '4.00'),
(116, '96', 'Vijay Dinakar Patil', '1821', '25', '4.00', '19.00'),
(117, '96', 'Ajay Kumar', '1823', '25', '2.00', '19.00'),
(118, '96', 'Parth Paragbhai Patel', '1839', '25', '2.00', '18.00'),
(119, '96', 'Bhandari Deepkumar Pankajbhai', '1840', '25', '2.00', '19.00'),
(120, '96', 'Premchand Hawaladar Yadav', '1856', '25', NULL, '24.00'),
(121, '96', 'Shaikh Moin Shaikh Yunus Khatik', '1863', '25', '2.00', '21.00'),
(122, '96', 'Rohit Joshi', '1864', '25', '3.00', '10.00'),
(123, '96', 'Avneesh Kumar', '1868', '25', '7.00', '12.00'),
(124, '96', 'Omprakash Panda', '1869', '25', '0.00', '25.00'),
(125, '96', 'Rahul Madariya', '1883', '25', '0.00', '17.00'),
(126, '96', 'Surekha Dhanraj Wanjari', '1888', '25', '6.00', '16.00'),
(127, '96', 'Rakesh Ravindra Patil', '1894', '25', '4.00', '18.00'),
(128, '96', 'Sumit Sanjay Pol', '1918', '25', '2.00', '19.00'),
(129, '96', 'Rajesh Hariprasad Prajapati', '1927', '25', '0.00', '25.00'),
(130, '96', 'Aditya Kumar Maurya', '1933', '25', '0.00', '12.00'),
(131, '96', 'Prashant Singh', '1935', '25', '1.5', '23.5'),
(132, '96', 'Patel Miraj Shantilal', '1939', '25', '3.00', '18.00'),
(133, '96', 'Avnish Kumar', '1945', '25', '5.5', '19.5'),
(134, '96', 'Truptiben Bharatkumar Tailor', '1970', '25', '0.00', '23.00'),
(135, '96', 'Vivek Kumar Mishra', '1985', '25', '2.00', '16.00'),
(136, '96', 'Patel Jeet Kamleshbhai', '1986', '25', '3.00', '9.00'),
(137, '96', 'Ajay Ananda Kadam', '1987', '25', '8.00', '14.00'),
(138, '96', 'Patel Harsh Mukeshbhai', '1988', '25', '5.00', '9.00'),
(139, '96', 'Tushar Saini', '2007', '25', '0.00', '0.00'),
(140, '96', 'Roshan Lal Gupta', '2021', '25', '0.00', '0.00'),
(141, '96', 'Sundeep Kumar Chudhary', '2022', '25', '0.00', '0.00'),
(142, '96', 'Pal Ketanbhai Patel', '2023', '25', '0.00', '0.00'),
(143, '96', 'Babita Chouhan', '2025', '25', '0.00', '0.00'),
(144, '96', 'Patel Dhrvin Sanjaybhai', '2032', '25', '0.00', '0.00'),
(145, '96', 'Patel Yash Ashokbhai', '2034', '25', '0.00', '0.00'),
(146, '96', 'Bhandari Dipendrakumar Nitinchandra', '2043', '25', '0.00', '0.00'),
(147, '96', 'Sunil Kumar garg', '2069', '25', '0.00', '0.00'),
(148, '96', 'Suresh Kumar', '2070', '25', '0.00', '21.00'),
(149, '96', 'Prafulla Hira Thakur', '2071', '25', '0.00', '0.00'),
(150, '96', 'Rudresh Singh', '2081', '25', '0.00', '0.00'),
(151, '96', 'Devang Ahir', '475', '25', '9.00', '13.00'),
(152, '96', 'JigneshPatel', '772', '25', '7', '18'),
(153, '96', 'Pappu Ram Puniyan', '975', '25', '5', '20'),
(154, '96', 'Dalit Kumar Dhule', '1064', '25', '7.00', '17.00'),
(155, '96', 'Shubham Sunil Padmane', '1096', '25', '6.00', '17.00'),
(156, '96', 'Gaurav Kumar Uttambhai Patel', '1122', '25', '0.00', '24.00'),
(157, '96', 'Mohammad Zafar abdulhaque ansari', '1131', '25', '9', '16'),
(158, '96', 'LAD CHARMI MAHESHBHAI', '1368', '25', '5.00', '17.00'),
(159, '96', 'Sanjesh Kumar', '1388', '25', '13', '12'),
(160, '96', 'Patel Pranavkumar Sureshbhai', '1486', '25', '0.00', '22.00'),
(161, '96', 'Hardikkumar Dipakbhai Patel', '1500', '25', '3.00', '18.00'),
(162, '96', 'Suraj Sharma', '1616', '25', '16.00', '9.00'),
(163, '96', 'PANKAJ SUDHAMSING PAWAR', '1684', '25', '0.00', '25.00'),
(164, '96', 'Bhandari Keval Arvindbhai', '1688', '25', '0.00', '24.00'),
(165, '96', 'Alaykumar Mukeshbhai Patel', '1696', '25', '0.00', '14.00'),
(166, '96', 'Manoj Kumar Yadav', '1700', '25', '9.00', '16.00'),
(167, '96', 'Krupal Khandubhai Patel', '1704', '25', '0.00', '19.00'),
(168, '96', 'Rohit Kumar', '1705', '25', '0.00', '10.00'),
(169, '96', 'Vivek Mahyavanshi', '1717', '25', '3', '22'),
(170, '96', 'PAWAN KUMAR SINGH', '1724', '25', '11.00', '14.00'),
(171, '96', 'Harshad Rajendra Sonawane', '1740', '25', '9.00', '15.00'),
(172, '96', 'Cheitali Ishwarbhai Damania', '1752', '25', '7.00', '3.00'),
(173, '96', 'Rina Pralhad Gharate', '1753', '25', '0.00', '4.00'),
(174, '96', 'Chandan Kumar', '1771', '25', '19.00', '3.00'),
(175, '96', 'Prashant Ramesh Solanki', '1772', '25', '8.00', '15.00'),
(176, '96', 'Patel Siddharth Dipakbhai', '1798', '25', '8.00', '2.00'),
(177, '96', 'Desh Deepak Yadav', '1822', '25', '11.00', '11.00'),
(178, '96', 'Patil Ashish Prabhakar', '1833', '25', '6', '19'),
(179, '96', 'Sujeet Sharma', '1871', '25', '1.00', '24.00'),
(180, '96', 'Dixit Nanubhai Prajapati', '1873', '25', '2.00', '18.00'),
(181, '96', 'Vikas Jaiswal', '1874', '25', '3.00', '5.00'),
(182, '96', 'Kunal Himmatrao Bachhav', '1875', '25', '6.00', '13.00'),
(183, '96', 'Rohit Singh', '1895', '25', '2.00', '22.00'),
(184, '96', 'Vivekanand Pathak', '1898', '25', NULL, '25.00'),
(185, '96', 'Patel Sohilbhai Hitendrabhai', '1902', '25', '1.00', '17.00'),
(186, '96', 'Ashwini Amit Kadam', '1907', '25', '1.00', '12.00'),
(187, '96', 'Patel Feni Manojbhai', '1908', '25', '3', '22'),
(188, '96', 'Patel Harshal Thakorbhai', '1911', '25', '2.00', '22.00'),
(189, '96', 'Ramajor Yadav', '1919', '25', '21.00', '4.00'),
(190, '96', 'MinayKumar Pramodbhai Patel', '1920', '25', '6.00', '18.00'),
(191, '96', 'Jay Kantilal Patel', '1922', '25', '4.00', '20.00'),
(192, '96', 'Patel Prince Dineshbhai', '1923', '25', '1.00', '20.00'),
(193, '96', 'Adarsh R. Anand', '1926', '25', '4.00', '12.00'),
(194, '96', 'Smit Harshadbhai Prajapati', '1931', '25', '5.00', '19.00'),
(195, '96', 'Patel Dishantkumar Kamleshbhai', '1934', '25', '7.00', '14.00'),
(196, '96', 'Ajeet Pal', '1941', '25', '23', '2'),
(197, '96', 'Jainisha Ramesh Patel', '1944', '25', '5', '20'),
(198, '96', 'Rathod Yash Rameshbhai', '1946', '25', '7', '18'),
(199, '96', 'Patel Dharmin Mohanbhai', '1947', '25', '2.00', '23.00'),
(200, '96', 'Hemkant Bapu Rokade', '1956', '25', NULL, '7.00'),
(201, '96', 'Sunil Raghunath Sanap', '1967', '25', '5.00', '17.00'),
(202, '96', 'Pushkal Sharma', '2004', '25', NULL, '17.00'),
(203, '96', 'Pranjal Upadhyay', '2005', '25', '17.00', '0.00'),
(204, '96', 'Patel Abhay Chandubhai', '2010', '25', '2.00', '15.00'),
(205, '96', 'Riya Jayeshbhai Patel', '2011', '25', '4.00', '13.00'),
(206, '96', 'Mikun Swain', '2012', '25', NULL, '17.00'),
(207, '96', 'Vishal Gupta', '2015', '25', NULL, '17.00'),
(208, '96', 'Vishal Singh', '2020', '25', NULL, '0.00'),
(209, '96', 'Parth Rajendra Patel', '2024', '25', NULL, '0.00'),
(210, '96', 'Patel Dishantkumar Narendrabhai', '2030', '25', NULL, '0.00'),
(211, '96', 'Ritik Raj Mishra', '2031', '25', NULL, '0.00'),
(212, '96', 'Vikash Himmat Patil', '2033', '25', NULL, '0.00'),
(213, '96', 'Patil Ajikya Nandkumar', '2044', '25', NULL, '0.00'),
(214, '96', 'Bhavin Ranjitsingh Thakur', '2046', '25', '2', '23'),
(215, '96', 'Jagdish Rameshwar Marathe', '2049', '25', NULL, '0.00'),
(216, '96', 'Ishwar Komalsing Girase', '2050', '25', NULL, '0.00'),
(217, '96', 'Patel Vatsalkumar Ramanbhai', '2051', '25', NULL, '0.00'),
(218, '96', 'Deepak Kumar', '2079', '25', NULL, '0.00'),
(219, '96', 'Supekar Vishal Vasant', '2084', '25', NULL, '0.00'),
(220, '96', 'Sakshi Shivaji Patil', '2085', '25', NULL, '0.00'),
(221, '96', 'Sanjay C.Halpati', '33', '25', '5.00', '1.00'),
(222, '96', 'Santosh V.Patel', '56', '25', NULL, '13.00'),
(223, '96', 'Tarun P Patel', '144', '25', NULL, '20.00'),
(224, '96', 'Chandrakant V Patel', '222', '25', '5.00', '3.00'),
(225, '96', 'Murad Khan', '226', '25', '3.00', '21.00'),
(226, '96', 'Ramchandra Khobragade', '227', '25', '1.00', '20.00'),
(227, '96', 'SHAILESH PATEL', '234', '25', '8.00', '11.00'),
(228, '96', 'Gulab Chandra Yadav', '250', '25', '7.00', '17.00'),
(229, '96', 'Navnit Kumar Sukhai Singh', '282', '25', '2.00', '19.00'),
(230, '96', 'Markandey Singh', '299', '25', NULL, '25.00'),
(231, '96', 'Rahul Kumar Shah', '535', '25', NULL, '12.00'),
(232, '96', 'AshokPatel', '703', '25', '1', '4'),
(233, '96', 'LovelyPrasadSharma', '770', '25', NULL, '0.00'),
(234, '96', 'Divyesh Patel', '1184', '25', '4.00', '8.00'),
(235, '96', 'Prajapati Jigar Jayanti', '1221', '25', '1.00', '8.00'),
(236, '96', 'Surajit Ojha', '1306', '25', '1.00', '18.00'),
(237, '96', 'Ramesh Madhavlal Patel', '1406', '25', '3.00', '18.00'),
(238, '96', 'Sandeep Arjun Chaudhary', '1432', '25', '6.00', '2.00'),
(239, '96', 'Shiv Narayan Yadav', '1476', '25', '15.00', '0.00'),
(240, '96', 'Nabaghana Kar', '1481', '25', '4.00', '14.00'),
(241, '96', 'Shibanarayan Behra', '1483', '25', NULL, '0.00'),
(242, '96', 'Surjit Ojha', '1484', '25', '2.00', '18.00'),
(243, '96', 'Sourav Kumar Sasmal', '1485', '25', '6', '-6'),
(244, '96', 'ROSHAN SINGH', '1494', '25', '1.00', '22.00'),
(245, '96', 'Suraj Paswan', '1582', '25', '3.00', '11.00'),
(246, '96', 'Priy Ranjan Kumar', '1715', '25', '2.00', '20.00'),
(247, '96', 'Ravikant Saini', '1739', '25', '5.00', '0.00'),
(248, '96', 'Uday Sankar Giri', '1742', '25', '2.00', '21.00'),
(249, '96', 'Akhilesh Kumar Rajak', '1757', '25', NULL, '0.00'),
(250, '96', 'Sanajit Ojha', '1760', '25', '1.00', '11.00'),
(251, '96', 'Abhishek Yadav', '1783', '25', '8.00', '0.00'),
(252, '96', 'Avijit Das', '1826', '25', NULL, '12.00'),
(253, '96', 'Ashwani Kumar', '1845', '25', NULL, '6.00'),
(254, '96', 'MD Ehshan Shekh', '1846', '25', '2.5', '-2.5'),
(255, '96', 'Patitapaban Barik', '1848', '25', '2.00', '20.00'),
(256, '96', 'Mukesh', '1850', '25', '6.00', '0.00'),
(257, '96', 'Anuj Thakur', '1851', '25', '6.00', '14.00'),
(258, '96', 'Deepak Kumar Yadav', '1853', '25', '10.00', '2.00'),
(259, '96', 'Sunilbhai Ramanbhai Nayka', '1857', '25', '1.00', '0.00'),
(260, '96', 'Ashish Kumar Sharma', '1889', '25', NULL, '23.00'),
(261, '96', 'Mishrilal Saket', '1890', '25', '25.00', '0.00'),
(262, '96', 'Chetanand Varma', '1892', '25', '9.00', '14.00'),
(263, '96', 'Pawan Nandlal Sen', '1925', '25', '2.00', '17.00'),
(264, '96', 'Suresh Godara', '1937', '25', NULL, '14.00'),
(265, '96', 'Saroj Kumar Patra', '1943', '25', '15.00', '0.00'),
(266, '96', 'Debabrate Mandal', '1949', '25', '1.00', '24.00'),
(267, '96', 'Rahul Ghosh', '1951', '25', '9.00', '12.00'),
(268, '96', 'Subhajit Maiti', '1972', '25', '1.00', '16.00'),
(269, '96', 'Subhashbhai Fakirbhai Patel', '1990', '25', '7.00', '9.00'),
(270, '96', 'Patel Akshaybhai Rameshbhai', '2035', '25', NULL, '0.00'),
(271, '96', 'Satyajit Ojha', '2042', '25', NULL, '0.00'),
(272, '96', 'Sanjay Bhagri', '2048', '25', NULL, '0.00'),
(273, '96', 'Praveen Tiwari', '2058', '25', NULL, '0.00'),
(274, '96', 'Rajesh', '2062', '25', NULL, '0.00'),
(275, '96', 'Bharat Kumar', '2066', '25', NULL, '0.00'),
(276, '96', 'Devanand Sarabjeet Chaurasiya', '2067', '25', NULL, '0.00'),
(277, '96', 'Amit Paswan', '2073', '25', NULL, '0.00'),
(278, '96', 'Manik Kumar Saha', '2074', '25', NULL, '0.00'),
(279, '96', 'Jagdish', '2082', '25', NULL, '0.00'),
(280, '96', 'Meraj Ali', '2083', '25', NULL, '0.00'),
(281, '96', 'Manish kumar', '2086', '25', NULL, '0.00'),
(282, '96', 'Dharmesh Patel', '720', '25', '4', '21'),
(283, '96', 'Pradeepkadam', '742', '25', '4.00', '18.00'),
(284, '96', 'Ramniwas Maury', '1467', '25', NULL, '8.00'),
(285, '96', 'Ankur Dhirenbhai Patel', '1645', '25', '16.00', '1.00'),
(286, '96', 'Vaghamarya Vinodbhai Lahanbhai', '1773', '25', '6', '19'),
(287, '96', 'Munna Thakur', '1884', '25', NULL, '0.00'),
(288, '96', 'Ajay Kumar', '1924', '25', '4.00', '14.00'),
(289, '96', 'Susanta Pal', '1948', '25', '6.00', '5.00'),
(290, '96', 'Amarjeet Bagari', '1959', '25', '12.00', '12.00'),
(291, '96', 'Amarjeet Yadav', '1968', '25', '1.00', '22.00'),
(292, '96', 'Pankaj Singh', '2002', '25', NULL, '17.00'),
(293, '96', 'Ajay Bhagat', '2059', '25', '11.00', '14.00'),
(294, '96', 'Surendra Sethy', '2063', '25', NULL, '0.00'),
(295, '96', 'Rohit Kumar Chaurasiya', '2080', '25', NULL, '0.00'),
(300, '96', 'test ', '0001', '25', '2.5', '22.5'),
(301, '96', '', '', '25', '', '0'),
(302, '96', 'master', 'master', '25', '6', '-6'),
(303, '96', 'Anujbhai ', '2096', '25', '1', '24'),
(304, '96', 'Vatsal', '2115', '25', '3', '22');
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
