INSERT INTO `jos_app_employeeface` (`id`, `empid`, `date`, `tlfid`, `name`, `title`, `distance`, `fleft`, `fright`, `ftop`, `fbottom`, `imagecrop`, `extras`, `update_status`, `userid`, `delete_status`, `face`, `template`) VALUES
(41, 41, '2025-01-10 05:54:42', '', 'MR MAHESH ANNASO KUSHAPPA-PATIL', '', '', '', '', '', '', '', '', 0, 77, 0, 0x[encoded data, 225132 characters], 0x414d42795077416776443841774f472f4147444450774341524c3841514343394141423650774341565430414148452f4147434450774267416a3841494f382b414d446a76514367657a38410a5948732f4143443750674367704c344134496d2f414f41657677424173623841344c572f414f4178507744417872344134422b2b4143416576774367727a344167415a4141474262506744670a35543841514c732f414343385051444166373441674a7938414b4470765141413672384177413541414b4479765144416a6a384149416f2b41454334507744414e6a7741594b512b414141440a50674267576a384141417241414d427450774267446a344134473438414f42465077416743554141674f692f414343567667436777443441774c452b414f44485077434154373441344d752f0a414b413150774467494430416742472f414d4379507744676c4434415945472b414944727667424136543441494a632b414d434650774141485438413449552b4145412b50774441495438410a77474b39414f433776514467454c384159456d2f4145442b76674367394438414947432f41454455507744416b4c38414143652f4143445450774367677a38416749532f41454277506744670a48723841494c472f4147437576514467446a38416747432f414f4250506741417a4c38415944552f4147414b76774341784c38416f49792f414f423876674167737a3441414f342b4143436b0a507742674e4c34414945592f4141427a76674241414c3841414c692b414d4444766742674c54344177434a414145444976774241517a3841414c36394141435276674341354c38416f4a652f0a4147446350674341764c38417748672f414f4264506742673137384151486d2f4149422f76674367436a3841514f592b414f434d5077416741623841594c572b414d4370507744676862383d0a);

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

--
-- Table structure for table `jos_app_employeeface_locationlog`
--

CREATE TABLE `jos_app_employeeface_locationlog` (
  `id` int NOT NULL,
  `empfaceid` int NOT NULL,
  `orglocation` int NOT NULL,
  `status` int NOT NULL,
  `delete_status` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_app_employeeface_locationlog`
--

INSERT INTO `jos_app_employeeface_locationlog` (`id`, `empfaceid`, `orglocation`, `status`, `delete_status`) VALUES
(5, 2, 1, 1, 0),
(6, 2, 2, 0, 0),
(7, 2, 3, 0, 0),
(8, 2, 4, 1, 0),
(9, 3, 1, 1, 0),
(10, 3, 2, 0, 0),
(11, 3, 3, 0, 0),
(12, 3, 4, 1, 0),
(13, 4, 1, 1, 0),
(14, 4, 2, 0, 0),
(15, 4, 3, 0, 0),
(16, 4, 4, 1, 0),
(17, 5, 1, 1, 0),
(18, 5, 2, 0, 0),
(19, 5, 3, 0, 0),
(20, 5, 4, 1, 0),
(21, 6, 1, 1, 0),
(22, 6, 2, 0, 0),
(23, 6, 3, 0, 0),
(24, 6, 4, 1, 0),
(25, 7, 1, 1, 0),
(26, 7, 2, 0, 0),
(27, 7, 3, 0, 0),
(28, 7, 4, 1, 0),
(29, 8, 1, 1, 0),
(30, 8, 2, 0, 0),
(31, 8, 3, 0, 0),
(32, 8, 4, 1, 0),
(33, 9, 1, 1, 0),
(34, 9, 2, 0, 0),
(35, 9, 3, 0, 0),
(36, 9, 4, 1, 0),
(41, 11, 1, 1, 0),
(42, 11, 2, 0, 0),
(43, 11, 3, 0, 0),
(44, 11, 4, 1, 0),
(45, 12, 1, 1, 0),
(46, 12, 2, 0, 0),
(47, 12, 3, 0, 0),
(48, 12, 4, 1, 0),
(49, 13, 1, 1, 0),
(50, 13, 2, 0, 0),
(51, 13, 3, 0, 0),
(52, 13, 4, 1, 0),
(53, 14, 1, 1, 0),
(54, 14, 2, 0, 0),
(55, 14, 3, 0, 0),
(56, 14, 4, 1, 0),
(57, 15, 1, 1, 0),
(58, 15, 2, 0, 0),
(59, 15, 3, 0, 0),
(60, 15, 4, 1, 0),
(61, 16, 1, 1, 0),
(62, 16, 2, 0, 0),
(63, 16, 3, 0, 0),
(64, 16, 4, 1, 0),
(65, 17, 1, 1, 0),
(66, 17, 2, 0, 0),
(67, 17, 3, 0, 0),
(68, 17, 4, 1, 0),
(69, 18, 1, 1, 0),
(70, 18, 2, 0, 0),
(71, 18, 3, 0, 0),
(72, 18, 4, 1, 0),
(73, 19, 1, 1, 0),
(74, 19, 2, 0, 0),
(75, 19, 3, 0, 0),
(76, 19, 4, 1, 0),
(77, 20, 1, 1, 0),
(78, 20, 2, 0, 0),
(79, 20, 3, 0, 0),
(80, 20, 4, 1, 0),
(81, 21, 1, 1, 0),
(82, 21, 2, 0, 0),
(83, 21, 3, 0, 0),
(84, 21, 4, 1, 0),
(85, 22, 1, 1, 0),
(86, 22, 2, 0, 0),
(87, 22, 3, 0, 0),
(88, 22, 4, 1, 0),
(89, 23, 1, 1, 0),
(90, 23, 2, 0, 0),
(91, 23, 3, 0, 0),
(92, 23, 4, 1, 0),
(97, 25, 1, 1, 0),
(98, 25, 2, 0, 0),
(99, 25, 3, 0, 0),
(100, 25, 4, 1, 0),
(101, 26, 1, 1, 0),
(102, 26, 2, 0, 0),
(103, 26, 3, 0, 0),
(104, 26, 4, 1, 0),
(109, 28, 1, 1, 0),
(110, 28, 2, 0, 0),
(111, 28, 3, 0, 0),
(112, 28, 4, 1, 0),
(113, 24, 1, 1, 0),
(114, 24, 2, 0, 0),
(115, 24, 3, 0, 0),
(116, 24, 4, 1, 0),
(117, 29, 1, 1, 0),
(118, 29, 2, 0, 0),
(119, 29, 3, 0, 0),
(120, 29, 4, 1, 0),
(149, 37, 1, 1, 0),
(150, 37, 2, 0, 0),
(151, 37, 3, 0, 0),
(152, 37, 4, 1, 0),
(153, 31, 1, 1, 0),
(154, 31, 2, 0, 0),
(155, 31, 3, 0, 0),
(156, 31, 4, 1, 0),
(157, 32, 1, 1, 0),
(158, 32, 2, 0, 0),
(159, 32, 3, 0, 0),
(160, 32, 4, 1, 0),
(161, 33, 1, 1, 0),
(162, 33, 2, 0, 0),
(163, 33, 3, 0, 0),
(164, 33, 4, 1, 0),
(165, 34, 1, 1, 0),
(166, 34, 2, 0, 0),
(167, 34, 3, 0, 0),
(168, 34, 4, 1, 0),
(169, 35, 1, 1, 0),
(170, 35, 2, 0, 0),
(171, 35, 3, 0, 0),
(172, 35, 4, 1, 0),
(173, 36, 1, 1, 0),
(174, 36, 2, 0, 0),
(175, 36, 3, 0, 0),
(176, 36, 4, 1, 0),
(177, 38, 1, 1, 0),
(178, 38, 2, 0, 0),
(179, 38, 3, 0, 0),
(180, 38, 4, 1, 0),
(181, 1, 1, 1, 0),
(182, 1, 2, 0, 0),
(183, 1, 3, 0, 0),
(184, 1, 4, 1, 0),
(185, 39, 1, 1, 0),
(186, 39, 2, 0, 0),
(187, 39, 3, 0, 0),
(188, 39, 4, 1, 0),
(189, 40, 1, 1, 0),
(190, 40, 2, 0, 0),
(191, 40, 3, 0, 0),
(192, 40, 4, 1, 0),
(193, 10, 1, 1, 0),
(194, 10, 2, 0, 0),
(195, 10, 3, 0, 0),
(196, 10, 4, 1, 0),
(197, 41, 1, 1, 0),
(198, 41, 2, 0, 0),
(199, 41, 3, 0, 0),
(200, 41, 4, 1, 0),
(201, 30, 1, 1, 0),
(202, 30, 2, 0, 0),
(203, 30, 3, 0, 0),
(204, 30, 4, 1, 0),
(205, 27, 1, 1, 0),
(206, 27, 2, 0, 0),
(207, 27, 3, 0, 0),
(208, 27, 4, 1, 0);

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

--
-- Table structure for table `jos_app_employeeinfo`
--

CREATE TABLE `jos_app_employeeinfo` (
  `id` int NOT NULL,
  `employeeid` int NOT NULL,
  `registerdate` datetime NOT NULL,
  `son` varchar(100) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `pincode` varchar(50) NOT NULL,
  `lat` double NOT NULL,
  `lon` double NOT NULL,
  `dob` date NOT NULL,
  `designation` int NOT NULL,
  `shift_type` varchar(255) NOT NULL,
  `job_type` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `jos_app_employeeinfo`
--

INSERT INTO `jos_app_employeeinfo` (`id`, `employeeid`, `registerdate`, `son`, `phone`, `pincode`, `lat`, `lon`, `dob`, `designation`, `shift_type`, `job_type`) VALUES
(1, 1, '2025-01-08 02:49:26', 'Mr Namdev Dattu Shinde', '9130029554', '', 0, 0, '2025-01-08', 11, '2', 1),
(2, 2, '2025-01-08 02:51:35', 'MR BAJIRAO BABURAO BETKAR', '9890053779', '', 0, 0, '2025-01-08', 2, '2', 1),
(3, 3, '2025-01-08 02:53:29', 'MR HARI BABURAO KHOT', '6362786620', '', 0, 0, '2025-01-08', 3, '1', 1),
(4, 4, '2025-01-08 02:56:31', 'MR ROHIT APPASO NAIK', '9552008212', '', 0, 0, '2025-01-08', 4, '1', 1),
(5, 5, '2025-01-08 02:58:23', 'MR SUSHANT RAYAPPA BANNE', '7798327272', '', 0, 0, '2025-01-08', 5, '1', 1),
(6, 6, '2025-01-08 02:59:50', 'MR SUNIL GUNDU JATHAR', '9731756855', '', 0, 0, '2025-01-08', 5, '1', 1),
(7, 7, '2025-01-08 03:03:46', 'MR NIVAS RAJARAM NAIK', '9741040839', '', 0, 0, '2025-01-08', 5, '1', 1),
(8, 8, '2025-01-08 03:06:36', 'MR EKNATH DAGDU BIRAJE', '9175047716', '', 0, 0, '2025-01-08', 2, '1', 1),
(9, 9, '2025-01-08 03:08:59', 'MR SOMNATH RAJENDRA JADHAV ', '8668392233', '', 0, 0, '2025-01-08', 2, '1', 1),
(10, 10, '2025-01-08 03:16:13', 'MR VISHWAJEET SANJAY KOPARDE ', '9022972691', '', 0, 0, '2025-01-08', 8, '2', 1),
(11, 11, '2025-01-08 03:24:23', 'MR SACHIN VASANT KORAVI', '8605401838', '', 0, 0, '2025-01-08', 3, '1', 1),
(12, 12, '2025-01-08 03:26:10', 'MR VISHANT VASANT LAGARE', '9552015446', '', 0, 0, '2025-01-08', 6, '1', 1),
(13, 13, '2025-01-08 03:28:31', 'MR SACHIN RAMESH PATIL ', '8746823092', '', 0, 0, '2025-01-08', 10, '1', 1),
(14, 14, '2025-01-08 03:30:37', 'MR SOURABH SANJAY KAMBLE', '7499927784', '', 0, 0, '2025-01-08', 11, '1', 1),
(15, 15, '2025-01-08 03:33:13', 'MR VIKAS KUMAR', '7620041742', '', 0, 0, '2025-01-08', 5, '1', 1),
(16, 16, '2025-01-08 03:34:40', 'MR ROHIT ABHAYKUMAR PATIL ', '8152016125', '', 0, 0, '2025-01-08', 3, '1', 1),
(17, 17, '2025-01-08 03:36:18', 'MR KRUSHNAT TUKARAM BANNE', '9901383769', '', 0, 0, '2025-01-08', 6, '1', 1),
(18, 18, '2025-01-08 03:37:57', 'MR SANDIP SHIVAJI CHIKALE', '7875781925', '', 0, 0, '2025-01-08', 2, '1', 1),
(19, 19, '2025-01-08 03:39:06', 'MR BASAVAN RAM', '7821928941', '', 0, 0, '2025-01-08', 3, '1', 1),
(20, 20, '2025-01-08 03:41:54', 'MR SONU RAJ', '9569676005', '', 0, 0, '2025-01-08', 5, '1', 1),
(21, 21, '2025-01-08 03:43:38', 'MR RAJARAM ', '8953355242', '', 0, 0, '2025-01-08', 5, '1', 1),
(22, 22, '2025-01-08 03:46:18', 'MR GIRIJARAM', '7249065008', '', 0, 0, '2025-01-08', 5, '1', 1),
(23, 23, '2025-01-08 03:49:11', 'MR VITTHAL SHANKAR MANE', '7083345690', '', 0, 0, '2025-01-08', 3, '1', 1),
(24, 24, '2025-01-08 03:51:18', 'MRS RANJANA ASHOK GHATAGE', '8888048148', '', 0, 0, '2025-01-08', 5, '1', 1),
(25, 25, '2025-01-08 03:52:45', 'MR KHAKNU', '9172311493', '', 0, 0, '2025-01-08', 5, '1', 1),
(26, 26, '2025-01-08 04:02:17', 'MR SIKANDAR ALLAUDDIN MULTANI', '9325230104', '', 0, 0, '2025-01-08', 9, '2', 1),
(27, 27, '2025-01-21 09:42:43', 'MR VIJAY SHANKAR CHOUGALE ', '8806243331', '', 0, 0, '2025-01-08', 9, '2', 1),
(28, 28, '2025-01-08 04:09:43', 'MR ABHISHEK SHIVAJI SHINDE', '9850590106', '', 0, 0, '2025-01-08', 1, '2', 1),
(29, 29, '2025-01-08 04:21:09', 'MR SHITAL SAMBHAJI KOPARDE ', '9130029553', '', 0, 0, '2025-01-08', 9, '2', 1),
(30, 30, '2025-01-21 09:33:04', 'Mr Suresh', '9595693737', '', 0, 0, '2025-01-08', 3, '1', 1),
(31, 31, '2025-01-10 02:34:49', 'MR SUBHASH NARSU PANDE', '9096973914', '', 0, 0, '2025-01-10', 5, '1', 1),
(32, 32, '2025-01-10 02:36:13', 'MR PARASHURAM BABU MALI', '9886780216', '', 0, 0, '2025-01-10', 2, '1', 1),
(33, 33, '2025-01-10 02:37:27', 'MR MAHADEV BAPU SHIROLE', '8722612157', '', 0, 0, '2025-01-10', 6, '1', 1),
(34, 34, '2025-01-10 02:39:15', 'MR RAJ KUMAR', '7388020155', '', 0, 0, '2025-01-10', 3, '1', 1),
(35, 35, '2025-01-10 02:40:32', 'MR DHARMENDRA KUMAR', '9359608994', '', 0, 0, '2025-01-10', 3, '1', 1),
(36, 36, '2025-01-10 02:41:41', 'MR RAHUL YASHWANT NAIK', '7760963877', '', 0, 0, '2025-01-10', 4, '1', 1),
(37, 37, '2025-01-10 02:43:28', 'MR DEEPAK PRABHAKAR POTDAR ', '8629281026', '', 0, 0, '2025-01-10', 11, '1', 1),
(38, 38, '2025-01-10 03:26:00', 'MR GANESH SANJAY NAIK', '8446037361', '', 0, 0, '2025-01-10', 5, '1', 1),
(39, 39, '2025-01-10 03:31:34', 'MR DILAWAR ALI SANADI', '9921295890', '', 0, 0, '2025-01-10', 12, '1', 1),
(40, 40, '2025-01-10 03:33:41', 'MR WASHIM IMRAN PAILWAN', '8095631640', '', 0, 0, '2025-01-10', 3, '1', 1),
(41, 41, '2025-01-10 05:54:42', 'MR MAHESH ANNASO KUSHAPPA-PATIL', '7020182671', '', 0, 0, '2025-01-10', 8, '2', 1);

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

--
-- Table structure for table `jos_app_employee_configuration_editstatuslog`
--

CREATE TABLE `jos_app_employee_configuration_editstatuslog` (
  `id` int NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `createdby` int NOT NULL,
  `no_late_mark` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `latemarkcut` float NOT NULL,
  `earlymark` int NOT NULL,
  `earlycut` int NOT NULL,
  `shortmark` float NOT NULL,
  `halfday` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `emppflock` int NOT NULL,
  `esicslab` int NOT NULL,
  `configid` int NOT NULL,
  `shiftid` int NOT NULL,
  `min_worktimeshorthr` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `min_worktimehr` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `max_worktimehr` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `early_logouttimemin` int NOT NULL,
  `shortcut` float NOT NULL,
  `update_status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `jos_app_employee_edit_status_log`
--

CREATE TABLE `jos_app_employee_edit_status_log` (
  `id` int NOT NULL,
  `sysdate` datetime NOT NULL,
  `empid` int NOT NULL,
  `name` varchar(500) NOT NULL,
  `empregno` varchar(100) NOT NULL,
  `address` varchar(500) NOT NULL,
  `gender` int NOT NULL,
  `emp_type` varchar(255) NOT NULL,
  `depat` int NOT NULL,
  `designation` int NOT NULL,
  `category` int NOT NULL,
  `dob` date NOT NULL,
  `bloodgroup` varchar(50) NOT NULL,
  `stateid` int NOT NULL,
  `city` varchar(255) NOT NULL,
  `mobno` varchar(50) NOT NULL,
  `status` int NOT NULL,
  `userid` int NOT NULL,
  `uids` int NOT NULL,
  `gid` int NOT NULL,
  `entrydate` datetime NOT NULL,
  `panno` varchar(50) NOT NULL,
  `adhar_no` varchar(255) NOT NULL,
  `pfacc_no` varchar(255) NOT NULL,
  `app_date` date NOT NULL,
  `retire_date` date NOT NULL,
  `bank_details` int NOT NULL,
  `bank_name` varchar(255) NOT NULL,
  `acc_no` varchar(50) NOT NULL,
  `branch_name` varchar(100) NOT NULL,
  `ifsc_code` varchar(50) NOT NULL,
  `ownid` int NOT NULL,
  `photo` varchar(500) NOT NULL,
  `photo_org` varchar(500) NOT NULL,
  `update_status` int NOT NULL DEFAULT '0',
  `user_status` int NOT NULL,
  `orglocation` int NOT NULL DEFAULT '1',
  `gen_salary` int DEFAULT NULL,
  `pf_appli` int NOT NULL,
  `emplock` int NOT NULL,
  `isGeofence` int NOT NULL,
  `geofences` varchar(200) NOT NULL,
  `isLoginGeofence` int NOT NULL,
  `loginGeofences` int NOT NULL,
  `isLogoutGeofence` int NOT NULL,
  `logoutGeofences` int NOT NULL,
  `liveTracking` int NOT NULL,
  `user_reg` int NOT NULL,
  `multiLogin` int NOT NULL,
  `payroll_location` int NOT NULL,
  `addpayroll_location` text NOT NULL,
  `weekoff_type` int NOT NULL,
  `totalweekoff` varchar(255) NOT NULL,
  `uan` varchar(255) NOT NULL,
  `esi` int NOT NULL,
  `esi_no` varchar(255) NOT NULL,
  `ptax` int NOT NULL,
  `ot_config` varchar(255) NOT NULL,
  `payscale` int NOT NULL,
  `image` varchar(255) NOT NULL,
  `visitor_log` int NOT NULL,
  `vehicle_log` int NOT NULL,
  `expense_log` int NOT NULL,
  `face_distance` varchar(255) NOT NULL,
  `face_left` varchar(255) NOT NULL,
  `face_right` varchar(255) NOT NULL,
  `face_top` varchar(255) NOT NULL,
  `face_bottom` varchar(255) NOT NULL,
  `face_imagecrop` varchar(500) NOT NULL,
  `face_extras` longtext NOT NULL,
  `info_registerdate` datetime NOT NULL,
  `info_lat` double NOT NULL,
  `info_lon` double NOT NULL,
  `info_shift_type` varchar(255) NOT NULL,
  `info_job_type` int NOT NULL,
  `add_payscale` int NOT NULL,
  `attendance_reports` int NOT NULL,
  `leave_log` int NOT NULL,
  `lead_log` int NOT NULL,
  `mark_attendance` int NOT NULL,
  `LM_limit` int NOT NULL,
  `subbranch` int NOT NULL,
  `emp_code` int NOT NULL,
  `branch_code` int NOT NULL,
  `esiclock` int NOT NULL,
  `modify_by` int NOT NULL,
  `salary_type` int NOT NULL,
  `deposit_gross` float NOT NULL,
  `visitorview` int NOT NULL,
  `refer_id` text NOT NULL,
  `conf_attedata` int NOT NULL,
  `useraccess` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `jos_app_employee_edit_status_log`
--

INSERT INTO `jos_app_employee_edit_status_log` (`id`, `sysdate`, `empid`, `name`, `empregno`, `address`, `gender`, `emp_type`, `depat`, `designation`, `category`, `dob`, `bloodgroup`, `stateid`, `city`, `mobno`, `status`, `userid`, `uids`, `gid`, `entrydate`, `panno`, `adhar_no`, `pfacc_no`, `app_date`, `retire_date`, `bank_details`, `bank_name`, `acc_no`, `branch_name`, `ifsc_code`, `ownid`, `photo`, `photo_org`, `update_status`, `user_status`, `orglocation`, `gen_salary`, `pf_appli`, `emplock`, `isGeofence`, `geofences`, `isLoginGeofence`, `loginGeofences`, `isLogoutGeofence`, `logoutGeofences`, `liveTracking`, `user_reg`, `multiLogin`, `payroll_location`, `addpayroll_location`, `weekoff_type`, `totalweekoff`, `uan`, `esi`, `esi_no`, `ptax`, `ot_config`, `payscale`, `image`, `visitor_log`, `vehicle_log`, `expense_log`, `face_distance`, `face_left`, `face_right`, `face_top`, `face_bottom`, `face_imagecrop`, `face_extras`, `info_registerdate`, `info_lat`, `info_lon`, `info_shift_type`, `info_job_type`, `add_payscale`, `attendance_reports`, `leave_log`, `lead_log`, `mark_attendance`, `LM_limit`, `subbranch`, `emp_code`, `branch_code`, `esiclock`, `modify_by`, `salary_type`, `deposit_gross`, `visitorview`, `refer_id`, `conf_attedata`, `useraccess`) VALUES
(1, '2025-01-21 15:03:04', 30, 'Mr Suresh', '', 'Kolhapur ', 1, '0', 2, 3, 0, '2025-01-08', '', 0, '0', '9595693737', 0, 77, 0, 26, '2025-01-08 04:39:46', '', '', '', '2025-01-08', '2025-01-21', 0, '', '', '', '', 0, '17363345863456.jpg', '17363345863456.jpg', 0, 0, 1, 1, 1, 0, 0, '', 0, 0, 0, 0, 0, 0, 1, 3, '', 0, '0', '', 0, '', 0, '0', 0, '', 0, 0, 0, '', '', '', '', '', '', '', '2025-01-21 09:33:04', 0, 0, '1', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 350, 0, 0, 0, '', 0, 0),
(2, '2025-01-21 15:12:43', 27, 'MR VIJAY SHANKAR CHOUGALE ', '', 'NANDGAON', 1, '0', 1, 9, 0, '2025-01-08', '', 0, '0', '8806243331', 1, 77, 0, 26, '2025-01-08 04:07:56', '', '', '', '2025-01-08', '0000-00-00', 0, '', '', '', '', 0, '17363326762754.jpg', '17363326762754.jpg', 0, 0, 1, 1, 1, 0, 0, '', 0, 0, 0, 0, 0, 0, 1, 4, '', 0, '0', '', 0, '', 0, '0', 0, '', 0, 0, 0, '', '', '', '', '', '', '', '2025-01-21 09:42:43', 0, 0, '2', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 350, 0, 0, 0, '', 0, 0);

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

--
-- Table structure for table `jos_app_employee_locationlog`
--

CREATE TABLE `jos_app_employee_locationlog` (
  `id` int NOT NULL,
  `app_empid` int NOT NULL,
  `orglocation` int NOT NULL,
  `status` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_app_employee_locationlog`
--

INSERT INTO `jos_app_employee_locationlog` (`id`, `app_empid`, `orglocation`, `status`) VALUES
(5, 2, 1, 1),
(6, 2, 2, 0),
(7, 2, 3, 0),
(8, 2, 4, 1),
(9, 3, 1, 1),
(10, 3, 2, 0),
(11, 3, 3, 0),
(12, 3, 4, 1),
(13, 4, 1, 1),
(14, 4, 2, 0),
(15, 4, 3, 0),
(16, 4, 4, 1),
(17, 5, 1, 1),
(18, 5, 2, 0),
(19, 5, 3, 0),
(20, 5, 4, 1),
(21, 6, 1, 1),
(22, 6, 2, 0),
(23, 6, 3, 0),
(24, 6, 4, 1),
(25, 7, 1, 1),
(26, 7, 2, 0),
(27, 7, 3, 0),
(28, 7, 4, 1),
(29, 8, 1, 1),
(30, 8, 2, 0),
(31, 8, 3, 0),
(32, 8, 4, 1),
(33, 9, 1, 1),
(34, 9, 2, 0),
(35, 9, 3, 0),
(36, 9, 4, 1),
(37, 10, 1, 1),
(38, 10, 2, 0),
(39, 10, 3, 0),
(40, 10, 4, 1),
(41, 11, 1, 1),
(42, 11, 2, 0),
(43, 11, 3, 0),
(44, 11, 4, 1),
(45, 12, 1, 1),
(46, 12, 2, 0),
(47, 12, 3, 0),
(48, 12, 4, 1),
(49, 13, 1, 1),
(50, 13, 2, 0),
(51, 13, 3, 0),
(52, 13, 4, 1),
(53, 14, 1, 1),
(54, 14, 2, 0),
(55, 14, 3, 0),
(56, 14, 4, 1),
(57, 15, 1, 1),
(58, 15, 2, 0),
(59, 15, 3, 0),
(60, 15, 4, 1),
(61, 16, 1, 1),
(62, 16, 2, 0),
(63, 16, 3, 0),
(64, 16, 4, 1),
(65, 17, 1, 1),
(66, 17, 2, 0),
(67, 17, 3, 0),
(68, 17, 4, 1),
(69, 18, 1, 1),
(70, 18, 2, 0),
(71, 18, 3, 0),
(72, 18, 4, 1),
(73, 19, 1, 1),
(74, 19, 2, 0),
(75, 19, 3, 0),
(76, 19, 4, 1),
(77, 20, 1, 1),
(78, 20, 2, 0),
(79, 20, 3, 0),
(80, 20, 4, 1),
(81, 21, 1, 1),
(82, 21, 2, 0),
(83, 21, 3, 0),
(84, 21, 4, 1),
(85, 22, 1, 1),
(86, 22, 2, 0),
(87, 22, 3, 0),
(88, 22, 4, 1),
(89, 23, 1, 1),
(90, 23, 2, 0),
(91, 23, 3, 0),
(92, 23, 4, 1),
(97, 25, 1, 1),
(98, 25, 2, 0),
(99, 25, 3, 0),
(100, 25, 4, 1),
(101, 26, 1, 1),
(102, 26, 2, 0),
(103, 26, 3, 0),
(104, 26, 4, 1),
(109, 28, 1, 1),
(110, 28, 2, 0),
(111, 28, 3, 0),
(112, 28, 4, 1),
(113, 24, 1, 1),
(114, 24, 2, 0),
(115, 24, 3, 0),
(116, 24, 4, 1),
(117, 29, 1, 1),
(118, 29, 2, 0),
(119, 29, 3, 0),
(120, 29, 4, 1),
(149, 37, 1, 1),
(150, 37, 2, 0),
(151, 37, 3, 0),
(152, 37, 4, 1),
(153, 31, 1, 1),
(154, 31, 2, 0),
(155, 31, 3, 0),
(156, 31, 4, 1),
(157, 32, 1, 1),
(158, 32, 2, 0),
(159, 32, 3, 0),
(160, 32, 4, 1),
(161, 33, 1, 1),
(162, 33, 2, 0),
(163, 33, 3, 0),
(164, 33, 4, 1),
(165, 34, 1, 1),
(166, 34, 2, 0),
(167, 34, 3, 0),
(168, 34, 4, 1),
(169, 35, 1, 1),
(170, 35, 2, 0),
(171, 35, 3, 0),
(172, 35, 4, 1),
(173, 36, 1, 1),
(174, 36, 2, 0),
(175, 36, 3, 0),
(176, 36, 4, 1),
(177, 38, 1, 1),
(178, 38, 2, 0),
(179, 38, 3, 0),
(180, 38, 4, 1),
(181, 1, 1, 1),
(182, 1, 2, 0),
(183, 1, 3, 0),
(184, 1, 4, 1),
(185, 39, 1, 1),
(186, 39, 2, 0),
(187, 39, 3, 0),
(188, 39, 4, 1),
(189, 40, 1, 1),
(190, 40, 2, 0),
(191, 40, 3, 0),
(192, 40, 4, 1),
(193, 41, 1, 1),
(194, 41, 2, 0),
(195, 41, 3, 0),
(196, 41, 4, 1),
(197, 30, 1, 1),
(198, 30, 2, 0),
(199, 30, 3, 0),
(200, 30, 4, 1),
(201, 27, 1, 1),
(202, 27, 2, 0),
(203, 27, 3, 0),
(204, 27, 4, 1);

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

--
-- Table structure for table `jos_app_employee_shift_edit_log`
--

CREATE TABLE `jos_app_employee_shift_edit_log` (
  `id` int NOT NULL,
  `shift_id` int NOT NULL,
  `date` datetime NOT NULL,
  `shift` int NOT NULL,
  `shiftname` varchar(100) NOT NULL,
  `shift_type` varchar(250) NOT NULL,
  `shortname` text NOT NULL,
  `in_time` varchar(250) NOT NULL,
  `in_grace` varchar(250) NOT NULL,
  `max_grace` int NOT NULL,
  `out_time` varchar(250) NOT NULL,
  `out_grace` varchar(250) NOT NULL,
  `lunch_time` int NOT NULL,
  `lunch_in` varchar(250) NOT NULL,
  `lunch_in_grace` varchar(250) NOT NULL,
  `lunch_out` varchar(250) NOT NULL,
  `lunch_out_grace` varchar(250) NOT NULL,
  `adminingrace` varchar(200) NOT NULL DEFAULT '0',
  `adminlunchoutgrace` varchar(200) NOT NULL DEFAULT '0',
  `update_status` int NOT NULL DEFAULT '0',
  `user_status` int NOT NULL,
  `indisplaybefore` varchar(200) NOT NULL DEFAULT '0',
  `indisplayafter` varchar(200) NOT NULL DEFAULT '0',
  `outdisplaybefore` varchar(200) NOT NULL DEFAULT '0',
  `outdisplayafter` varchar(200) NOT NULL DEFAULT '0',
  `lindisplaybefore` varchar(200) NOT NULL DEFAULT '0',
  `lindisplayafter` varchar(200) NOT NULL DEFAULT '0',
  `loutdisplaybefore` varchar(200) NOT NULL DEFAULT '0',
  `loutdisplayafter` varchar(200) NOT NULL DEFAULT '0',
  `orglocation` varchar(255) NOT NULL,
  `modify_by` int NOT NULL,
  `min_worktimeshorthr` varchar(255) NOT NULL,
  `min_worktimehr` varchar(255) NOT NULL,
  `max_worktimehr` varchar(255) NOT NULL,
  `early_logouttimemin` int NOT NULL,
  `workhrs` varchar(100) NOT NULL,
  `ot_category` int NOT NULL,
  `lunch_minusinshift` int NOT NULL,
  `lunch_minusinwork` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `jos_app_employee_shift_edit_log`
--

INSERT INTO `jos_app_employee_shift_edit_log` (`id`, `shift_id`, `date`, `shift`, `shiftname`, `shift_type`, `shortname`, `in_time`, `in_grace`, `max_grace`, `out_time`, `out_grace`, `lunch_time`, `lunch_in`, `lunch_in_grace`, `lunch_out`, `lunch_out_grace`, `adminingrace`, `adminlunchoutgrace`, `update_status`, `user_status`, `indisplaybefore`, `indisplayafter`, `outdisplaybefore`, `outdisplayafter`, `lindisplaybefore`, `lindisplayafter`, `loutdisplaybefore`, `loutdisplayafter`, `orglocation`, `modify_by`, `min_worktimeshorthr`, `min_worktimehr`, `max_worktimehr`, `early_logouttimemin`, `workhrs`, `ot_category`, `lunch_minusinshift`, `lunch_minusinwork`) VALUES
(1, 1, '2025-01-29 12:37:35', 2, '', 'WORKERS SHIFT 8.00AM TO 4.30PM', '8am-4.30pm', '08:00 AM', '0-10', 0, '04:30 PM', '0-0', 0, '0', '0-0', '0', '0-0', '0', '0', 0, 0, '0', '0', '0', '0', '0', '0', '0', '0', '1,2,3,4', 76, '', '', '', 0, '08:30', 0, 0, 0),
(2, 2, '2025-01-29 12:38:16', 2, '', 'OFFICE STAFF SHIFT 9.30AM TO 6.00PM', '9.30am-6pm', '09:30 AM', '0-15', 0, '06:00 PM', '0-0', 0, '0', '0-0', '0', '0-0', '0', '0', 0, 0, '0', '0', '0', '0', '0', '0', '0', '0', '1,2,3,4', 76, '', '', '', 0, '08:30', 0, 0, 0),
(3, 1, '2025-01-30 16:45:41', 2, '', 'WORKERS SHIFT 8.00AM TO 4.30PM', '8am-4.30pm', '08:00 AM', '0-10', 0, '04:30 PM', '0-0', 0, '0', '0-0', '0', '0-0', '0', '0', 0, 0, '0', '0', '0', '0', '0', '0', '0', '0', '1,2,3,4', 76, '07:00', '', '', 0, '08:30', 0, 0, 0);

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

--
-- Table structure for table `jos_app_emporderconfig_editlog`
--

CREATE TABLE `jos_app_emporderconfig_editlog` (
  `id` int NOT NULL,
  `orderid` int NOT NULL,
  `date` datetime NOT NULL,
  `empid` int NOT NULL,
  `order` int NOT NULL,
  `modify_by` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `jos_app_empshift`
--

CREATE TABLE `jos_app_empshift` (
  `id` int NOT NULL,
  `date` datetime NOT NULL,
  `shift` int NOT NULL,
  `shiftname` varchar(100) NOT NULL,
  `shift_type` varchar(250) NOT NULL,
  `shortname` text NOT NULL,
  `in_time` varchar(250) NOT NULL,
  `workhrs` varchar(100) NOT NULL,
  `in_grace` varchar(250) NOT NULL,
  `max_grace` int NOT NULL,
  `out_time` varchar(250) NOT NULL,
  `out_grace` varchar(250) NOT NULL,
  `minlt_time` varchar(200) NOT NULL,
  `lunch_time` int NOT NULL,
  `lunch_in` varchar(250) NOT NULL,
  `lunch_in_grace` varchar(250) NOT NULL,
  `lunch_out` varchar(250) NOT NULL,
  `lunch_out_grace` varchar(250) NOT NULL,
  `adminingrace` varchar(200) NOT NULL DEFAULT '0',
  `adminlunchoutgrace` varchar(200) NOT NULL DEFAULT '0',
  `update_status` int NOT NULL DEFAULT '0',
  `user_status` int NOT NULL,
  `indisplaybefore` varchar(200) NOT NULL DEFAULT '0',
  `indisplayafter` varchar(200) NOT NULL DEFAULT '0',
  `outdisplaybefore` varchar(200) NOT NULL DEFAULT '0',
  `outdisplayafter` varchar(200) NOT NULL DEFAULT '0',
  `lindisplaybefore` varchar(200) NOT NULL DEFAULT '0',
  `lindisplayafter` varchar(200) NOT NULL DEFAULT '0',
  `loutdisplaybefore` varchar(200) NOT NULL DEFAULT '0',
  `loutdisplayafter` varchar(200) NOT NULL DEFAULT '0',
  `orglocation` varchar(255) NOT NULL,
  `shifthrs` varchar(100) NOT NULL,
  `cameraonof` int NOT NULL,
  `ot_category` int NOT NULL,
  `lunch_minusinshift` int NOT NULL,
  `lunch_minusinwork` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `jos_app_empshift`
--

INSERT INTO `jos_app_empshift` (`id`, `date`, `shift`, `shiftname`, `shift_type`, `shortname`, `in_time`, `workhrs`, `in_grace`, `max_grace`, `out_time`, `out_grace`, `minlt_time`, `lunch_time`, `lunch_in`, `lunch_in_grace`, `lunch_out`, `lunch_out_grace`, `adminingrace`, `adminlunchoutgrace`, `update_status`, `user_status`, `indisplaybefore`, `indisplayafter`, `outdisplaybefore`, `outdisplayafter`, `lindisplaybefore`, `lindisplayafter`, `loutdisplaybefore`, `loutdisplayafter`, `orglocation`, `shifthrs`, `cameraonof`, `ot_category`, `lunch_minusinshift`, `lunch_minusinwork`) VALUES
(1, '2025-01-08 01:58:52', 2, '', 'WORKERS SHIFT 8.00AM TO 4.30PM', '8am-4.30pm', '08:00 AM', '08:30', '0-10', 0, '04:30 PM', '0-0', '', 0, '0', '0-0', '0', '0-0', '0', '0', 0, 0, '0', '0', '0', '0', '0', '0', '0', '0', '1,2,3,4', '8 hrs, 30min', 0, 0, 0, 0),
(2, '2025-01-08 02:01:30', 2, '', 'OFFICE STAFF SHIFT 9.30AM TO 6.00PM', '9.30am-6pm', '09:30 AM', '08:30', '0-15', 0, '06:00 PM', '0-0', '', 0, '0', '0-0', '0', '0-0', '0', '0', 0, 0, '0', '0', '0', '0', '0', '0', '0', '0', '1,2,3,4', '8 hrs, 30min', 0, 0, 0, 0),
(3, '2025-01-08 04:42:58', 2, '', 'WATCHMAN 8.00PM TO 8.00AM', '', '8:00 pm', '', '0-10', 0, '8:00 am', '0-00', '', 0, '0', '0-0', '0', '0-0', '0', '0', 0, 0, '0', '0', '0', '0', '0', '0', '0', '0', '1,2,3,4', '', 0, 0, 0, 0);

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

--
-- Table structure for table `jos_app_empshiftgroup`
--

CREATE TABLE `jos_app_empshiftgroup` (
  `id` int NOT NULL,
  `name` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `update_status` int NOT NULL,
  `active_status` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `jos_app_empshiftgroup`
--

INSERT INTO `jos_app_empshiftgroup` (`id`, `name`, `update_status`, `active_status`) VALUES
(1, 'With Lunch ', 0, 0),
(2, 'Without Lunch', 0, 1),
(3, 'Night With Lunch', 0, 0),
(4, 'Night Without Lunch', 0, 0),
(5, 'Mutidays ', 0, 1),
(6, 'Midnight ', 0, 1);

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

--
-- Table structure for table `jos_app_empshiftgroup_locationlog`
--

CREATE TABLE `jos_app_empshiftgroup_locationlog` (
  `id` int NOT NULL,
  `shiftgroupid` int NOT NULL,
  `orglocation` int NOT NULL,
  `status` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_app_empshiftgroup_locationlog`
--

INSERT INTO `jos_app_empshiftgroup_locationlog` (`id`, `shiftgroupid`, `orglocation`, `status`) VALUES
(1, 1, 1, 1),
(2, 1, 2, 0),
(3, 1, 3, 0),
(4, 1, 4, 1),
(5, 2, 1, 1),
(6, 2, 2, 0),
(7, 2, 3, 0),
(8, 2, 4, 1),
(9, 3, 1, 1),
(10, 3, 2, 0),
(11, 3, 3, 0),
(12, 3, 4, 1),
(13, 4, 1, 1),
(14, 4, 2, 0),
(15, 4, 3, 0),
(16, 4, 4, 1),
(17, 5, 1, 1),
(18, 5, 2, 0),
(19, 5, 3, 0),
(20, 5, 4, 1),
(21, 6, 1, 1),
(22, 6, 2, 0),
(23, 6, 3, 0),
(24, 6, 4, 1);

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

--
-- Table structure for table `jos_app_empshiftgroup_location_edit_log`
--

CREATE TABLE `jos_app_empshiftgroup_location_edit_log` (
  `id` int NOT NULL,
  `shifttypeid` int NOT NULL,
  `shift_name` varchar(255) NOT NULL,
  `date` datetime NOT NULL,
  `orglocation` varchar(255) NOT NULL,
  `status` int NOT NULL,
  `modify_by` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_app_empshiftgroup_location_edit_log`
--

INSERT INTO `jos_app_empshiftgroup_location_edit_log` (`id`, `shifttypeid`, `shift_name`, `date`, `orglocation`, `status`, `modify_by`) VALUES
(1, 1, 'With Lunch ', '2025-01-08 13:37:07', '1,2,3,4', 0, 76),
(2, 2, 'Without Lunch', '2025-01-08 13:37:16', '1,2,3,4', 0, 76),
(3, 3, 'Night With Lunch', '2025-01-08 13:37:27', '1,2,3,4', 0, 76),
(4, 4, 'Night Without Lunch', '2025-01-08 13:37:38', '1,2,3,4', 0, 76),
(5, 5, 'Mutidays ', '2025-01-08 13:37:48', '1,2,3,4', 0, 76),
(6, 6, 'Midnight ', '2025-01-08 13:37:57', '1,2,3,4', 0, 76);

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

--
-- Table structure for table `jos_app_empshift_locationlog`
--

CREATE TABLE `jos_app_empshift_locationlog` (
  `id` int NOT NULL,
  `shiftid` int NOT NULL,
  `orglocation` int NOT NULL,
  `status` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_app_empshift_locationlog`
--

INSERT INTO `jos_app_empshift_locationlog` (`id`, `shiftid`, `orglocation`, `status`) VALUES
(9, 3, 1, 1),
(10, 3, 2, 0),
(11, 3, 3, 0),
(12, 3, 4, 1),
(25, 2, 1, 1),
(26, 2, 2, 0),
(27, 2, 3, 0),
(28, 2, 4, 0),
(29, 1, 1, 1),
(30, 1, 2, 0),
(31, 1, 3, 0),
(32, 1, 4, 0);

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

--
-- Table structure for table `jos_app_emp_category`
--

CREATE TABLE `jos_app_emp_category` (
  `id` int NOT NULL,
  `designation_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `jos_app_emp_eardeduction`
--

CREATE TABLE `jos_app_emp_eardeduction` (
  `id` int NOT NULL,
  `date` date NOT NULL,
  `systemdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `empid` int NOT NULL,
  `month` int NOT NULL,
  `year` int NOT NULL,
  `component` int NOT NULL,
  `grosspay` float NOT NULL,
  `rateperhr` float NOT NULL,
  `s_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `rateperday` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `salarydate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `jos_app_emp_eardeduction_editlog`
--

CREATE TABLE `jos_app_emp_eardeduction_editlog` (
  `id` int NOT NULL,
  `earid` int NOT NULL,
  `date` date NOT NULL,
  `systemdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `empid` int NOT NULL,
  `month` int NOT NULL,
  `year` int NOT NULL,
  `component` int NOT NULL,
  `grosspay` float NOT NULL,
  `rateperhr` float NOT NULL,
  `s_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `rateperday` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `salarydate` date NOT NULL,
  `modify_by` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `jos_app_emp_gross_pay`
--

CREATE TABLE `jos_app_emp_gross_pay` (
  `id` int NOT NULL,
  `date` date NOT NULL,
  `systemdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `empid` int NOT NULL,
  `orgid` int NOT NULL,
  `month` int NOT NULL,
  `year` int NOT NULL,
  `grosspay` double NOT NULL,
  `rateperhr` float NOT NULL,
  `s_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `rateperday` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `salarydate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `jos_app_emp_gross_pay`
--

INSERT INTO `jos_app_emp_gross_pay` (`id`, `date`, `systemdate`, `empid`, `orgid`, `month`, `year`, `grosspay`, `rateperhr`, `s_type`, `rateperday`, `salarydate`) VALUES
(1, '0000-00-00', '2025-01-31 07:41:23', 1, 1, 12, 2024, 22620, 0, '5', '', '0000-00-00');

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

--
-- Table structure for table `jos_app_emp_gross_pay_editlog`
--

CREATE TABLE `jos_app_emp_gross_pay_editlog` (
  `id` int NOT NULL,
  `grossid` int NOT NULL,
  `date` datetime NOT NULL,
  `systemdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `empid` int NOT NULL,
  `orgid` int NOT NULL,
  `month` int NOT NULL,
  `year` int NOT NULL,
  `grosspay` float NOT NULL,
  `rateperhr` float NOT NULL,
  `s_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `rateperday` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `salarydate` date NOT NULL,
  `modify_by` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `jos_app_emp_payscale_config_grid`
--

CREATE TABLE `jos_app_emp_payscale_config_grid` (
  `id` int NOT NULL,
  `systemdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `date` date NOT NULL,
  `payscaleid` int NOT NULL,
  `payrollorgid` int NOT NULL,
  `payscale_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `gross_pay` int NOT NULL,
  `componenttype_id` int NOT NULL,
  `component_id` int NOT NULL,
  `calculation` int NOT NULL,
  `value_amt` float NOT NULL,
  `percentageof` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `jos_app_emp_payscale_config_grid`
--

INSERT INTO `jos_app_emp_payscale_config_grid` (`id`, `systemdate`, `date`, `payscaleid`, `payrollorgid`, `payscale_name`, `gross_pay`, `componenttype_id`, `component_id`, `calculation`, `value_amt`, `percentageof`) VALUES
(22, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 51, 4, 4, 0, ''),
(23, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 53, 4, 3, 12, '366'),
(24, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 54, 4, 3, 3.25, '369'),
(25, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 28, 5, 0, 0, ''),
(26, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 75, 5, 4, 0, ''),
(27, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 39, 5, 0, 0, ''),
(28, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 369, 5, 0, 0, ''),
(29, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 49, 5, 0, 0, ''),
(30, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 50, 5, 0, 0, ''),
(31, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 55, 5, 0, 0, ''),
(32, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 40, 3, 4, 0, ''),
(33, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 41, 3, 4, 0, ''),
(34, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 60, 3, 4, 0, ''),
(35, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 42, 3, 3, 12, '366'),
(36, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 43, 3, 3, 0.75, '369'),
(37, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 44, 3, 4, 0, ''),
(38, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 48, 3, 4, 0, ''),
(39, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 63, 3, 4, 0, ''),
(40, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 138, 3, 4, 0, ''),
(41, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 29, 2, 3, 100, '28'),
(42, '2025-01-31 07:56:11', '2025-01-31', 1, 1, 'Mr Namdev Dattu Shinde ( December 2024 )', 22620, 366, 2, 2, 14700, '');

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

--
