text: -- phpMyAdmin SQL Dump
  -- version 5.1.1
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Mar 03, 2022 at 07:53 PM
  -- Server version: 10.4.22-MariaDB
  -- PHP Version: 8.1.2
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  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: `pds_db`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `deductions`
  --
  
  CREATE TABLE `deductions` (
    `id` int(11) NOT NULL,
    `emp_id` int(11) NOT NULL,
    `sss` decimal(20,2) NOT NULL,
    `phic` decimal(20,2) NOT NULL,
    `pagibig` decimal(20,2) NOT NULL,
    `others` decimal(20,2) NOT NULL,
    `ca` decimal(20,2) NOT NULL,
    `total_deductions` decimal(20,2) NOT NULL,
    `timestamps` timestamp NOT NULL DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `deductions`
  --
  
  INSERT INTO `deductions` (`id`, `emp_id`, `sss`, `phic`, `pagibig`, `others`, `ca`, `total_deductions`, `timestamps`) VALUES
  (1, 1, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:44'),
  (2, 2, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:44'),
  (3, 3, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:45'),
  (4, 4, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:45'),
  (5, 5, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:45'),
  (6, 6, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:45'),
  (7, 7, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:45'),
  (8, 8, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:46'),
  (9, 9, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:46'),
  (10, 10, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:46'),
  (11, 11, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:46'),
  (12, 12, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:46'),
  (13, 13, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:47'),
  (14, 14, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:47'),
  (15, 15, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:47'),
  (16, 16, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:47'),
  (17, 17, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:47'),
  (18, 18, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:48'),
  (19, 19, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:48'),
  (20, 20, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:49'),
  (21, 21, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:49'),
  (22, 22, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:50'),
  (23, 23, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:50'),
  (24, 24, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:50'),
  (25, 25, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:51'),
  (26, 26, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:51'),
  (27, 27, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:51'),
  (28, 28, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:52'),
  (29, 29, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:52'),
  (30, 30, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:52'),
  (31, 31, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:52'),
  (32, 32, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:52'),
  (33, 33, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:53'),
  (34, 34, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:53'),
  (35, 35, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:53'),
  (36, 36, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:53'),
  (37, 37, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:53'),
  (38, 38, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:54'),
  (39, 39, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:54'),
  (40, 40, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:54'),
  (41, 41, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:55'),
  (42, 42, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:55'),
  (43, 43, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:55'),
  (44, 44, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:56'),
  (45, 45, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:56'),
  (46, 46, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:56'),
  (47, 47, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:56'),
  (48, 48, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:56'),
  (49, 49, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-02-28 22:04:56'),
  (50, 50, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:34'),
  (51, 51, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:34'),
  (52, 52, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:34'),
  (53, 53, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:35'),
  (54, 54, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:35'),
  (55, 55, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:35'),
  (56, 56, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:35'),
  (57, 57, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:35'),
  (58, 58, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:36'),
  (59, 59, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:36'),
  (60, 60, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:36'),
  (61, 61, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:36'),
  (62, 62, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:36'),
  (63, 63, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:36'),
  (64, 64, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:37'),
  (65, 65, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:37'),
  (66, 66, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:37'),
  (67, 67, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:25:37'),
  (68, 68, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:24'),
  (69, 69, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:25'),
  (70, 70, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:25'),
  (71, 71, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:25'),
  (72, 72, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:25'),
  (73, 73, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:25'),
  (74, 74, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:26'),
  (75, 75, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:26'),
  (76, 76, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:26'),
  (77, 77, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:26'),
  (78, 78, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:26'),
  (79, 79, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:26'),
  (80, 80, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:26'),
  (81, 81, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:27'),
  (82, 82, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:27'),
  (83, 83, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:27'),
  (84, 84, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:27'),
  (85, 85, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 15:27:27'),
  (86, 1, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:33'),
  (87, 2, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:33'),
  (88, 3, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:33'),
  (89, 4, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:33'),
  (90, 5, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:34'),
  (91, 6, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:34'),
  (92, 7, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:34'),
  (93, 8, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:34'),
  (94, 9, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:34'),
  (95, 10, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:34'),
  (96, 11, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:34'),
  (97, 12, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:35'),
  (98, 13, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:35'),
  (99, 14, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:35'),
  (100, 15, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:35'),
  (101, 16, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:35'),
  (102, 17, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:35'),
  (103, 18, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:35'),
  (104, 19, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:36'),
  (105, 20, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:36'),
  (106, 21, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:36'),
  (107, 22, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:36'),
  (108, 23, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:36'),
  (109, 24, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:36'),
  (110, 25, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:36'),
  (111, 26, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:37'),
  (112, 27, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:37'),
  (113, 28, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:37'),
  (114, 29, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:37'),
  (115, 30, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:37'),
  (116, 31, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:37'),
  (117, 32, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:38'),
  (118, 33, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:38'),
  (119, 34, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:38'),
  (120, 35, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:38'),
  (121, 36, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:38'),
  (122, 37, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:39'),
  (123, 38, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:40'),
  (124, 39, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:40'),
  (125, 40, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:40'),
  (126, 41, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:40'),
  (127, 42, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:40'),
  (128, 43, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:40'),
  (129, 44, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:41'),
  (130, 45, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:41'),
  (131, 46, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:41'),
  (132, 47, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:41'),
  (133, 48, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:41'),
  (134, 1, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:41'),
  (135, 49, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:41'),
  (136, 2, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:41'),
  (137, 3, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:42'),
  (138, 4, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:42'),
  (139, 5, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:42'),
  (140, 6, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:42'),
  (141, 7, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:42'),
  (142, 8, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:42'),
  (143, 9, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:42'),
  (144, 10, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:43'),
  (145, 11, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:43'),
  (146, 12, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:43'),
  (147, 13, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:43'),
  (148, 14, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:43'),
  (149, 15, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:44'),
  (150, 16, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:44'),
  (151, 17, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:45'),
  (152, 18, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:45'),
  (153, 19, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:45'),
  (154, 1, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:45'),
  (155, 20, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:45'),
  (156, 2, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:45'),
  (157, 21, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:45'),
  (158, 3, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:46'),
  (159, 22, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:46'),
  (160, 4, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:46'),
  (161, 1, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:46'),
  (162, 23, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:46'),
  (163, 5, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:46'),
  (164, 1, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:46'),
  (165, 24, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:46'),
  (166, 2, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:46'),
  (167, 6, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:46'),
  (168, 2, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:47'),
  (169, 25, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:47'),
  (170, 3, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:47'),
  (171, 7, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:47'),
  (172, 3, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:47'),
  (173, 26, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:47'),
  (174, 4, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:47'),
  (175, 8, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:47'),
  (176, 4, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:47'),
  (177, 27, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:47'),
  (178, 5, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:48'),
  (179, 9, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:48'),
  (180, 5, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:48'),
  (181, 6, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:48'),
  (182, 28, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:48'),
  (183, 10, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:48'),
  (184, 6, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:49'),
  (185, 7, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:49'),
  (186, 11, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:49'),
  (187, 29, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:49'),
  (188, 7, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:49'),
  (189, 8, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:49'),
  (190, 30, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:49'),
  (191, 12, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:49'),
  (192, 8, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:49'),
  (193, 9, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:50'),
  (194, 13, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:50'),
  (195, 31, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:50'),
  (196, 9, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:50'),
  (197, 10, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:50'),
  (198, 14, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:50'),
  (199, 32, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:50'),
  (200, 10, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:50'),
  (201, 15, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:50'),
  (202, 11, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:50'),
  (203, 33, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:51'),
  (204, 11, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:51'),
  (205, 16, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:51'),
  (206, 12, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:51'),
  (207, 34, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:52'),
  (208, 12, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:52'),
  (209, 17, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:52'),
  (210, 13, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:52'),
  (211, 13, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:52'),
  (212, 35, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:52'),
  (213, 18, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:52'),
  (214, 14, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:52'),
  (215, 36, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:53'),
  (216, 19, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:53'),
  (217, 14, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:53'),
  (218, 15, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:53'),
  (219, 37, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:53'),
  (220, 15, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:53'),
  (221, 20, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:53'),
  (222, 16, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:53'),
  (223, 16, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:53'),
  (224, 38, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:53'),
  (225, 21, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:53'),
  (226, 17, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:54'),
  (227, 17, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:54'),
  (228, 39, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:54'),
  (229, 22, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:54'),
  (230, 18, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:54'),
  (231, 18, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:54'),
  (232, 40, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:54'),
  (233, 23, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:54'),
  (234, 19, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:54'),
  (235, 19, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:55'),
  (236, 41, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:55'),
  (237, 20, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:55'),
  (238, 24, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:55'),
  (239, 42, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:55'),
  (240, 20, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:55'),
  (241, 21, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:55'),
  (242, 25, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:55'),
  (243, 21, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:55'),
  (244, 43, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:55'),
  (245, 22, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:56'),
  (246, 26, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:56'),
  (247, 22, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:56'),
  (248, 44, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:56'),
  (249, 23, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:57'),
  (250, 27, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:57'),
  (251, 23, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:57'),
  (252, 45, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:57'),
  (253, 24, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:57'),
  (254, 28, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:57'),
  (255, 46, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:57'),
  (256, 24, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:57'),
  (257, 25, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:57'),
  (258, 29, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:57'),
  (259, 47, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:57'),
  (260, 25, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:57'),
  (261, 26, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:57'),
  (262, 30, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:57'),
  (263, 26, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:58'),
  (264, 48, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:58'),
  (265, 31, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:58'),
  (266, 27, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:58'),
  (267, 27, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:58'),
  (268, 49, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:58'),
  (269, 28, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:58'),
  (270, 32, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:58'),
  (271, 28, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:58'),
  (272, 29, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:59'),
  (273, 33, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:59'),
  (274, 29, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:59'),
  (275, 30, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:59'),
  (276, 30, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:59'),
  (277, 34, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:45:59'),
  (278, 31, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:00'),
  (279, 31, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:00'),
  (280, 35, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:00'),
  (281, 32, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:00'),
  (282, 32, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:00'),
  (283, 36, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:00'),
  (284, 33, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:00'),
  (285, 33, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:00'),
  (286, 37, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:00'),
  (287, 34, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:00'),
  (288, 34, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:00'),
  (289, 38, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:00'),
  (290, 35, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:00'),
  (291, 35, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:01'),
  (292, 39, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:01'),
  (293, 36, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:01'),
  (294, 36, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:01'),
  (295, 37, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:01'),
  (296, 40, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:01'),
  (297, 37, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:01'),
  (298, 38, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:01'),
  (299, 38, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:01'),
  (300, 41, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:01'),
  (301, 39, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:01'),
  (302, 42, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:01'),
  (303, 39, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:01'),
  (304, 40, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:02'),
  (305, 43, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:02'),
  (306, 40, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:02'),
  (307, 41, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:02'),
  (308, 41, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:02'),
  (309, 44, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:02'),
  (310, 42, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:02'),
  (311, 45, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:02'),
  (312, 42, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:02'),
  (313, 43, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:03'),
  (314, 46, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:03'),
  (315, 43, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:03'),
  (316, 44, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:03'),
  (317, 47, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:03'),
  (318, 44, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:03'),
  (319, 45, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:03'),
  (320, 45, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:03'),
  (321, 48, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:03'),
  (322, 46, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:03'),
  (323, 46, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:03'),
  (324, 49, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:03'),
  (325, 47, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:04'),
  (326, 47, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:04'),
  (327, 48, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:04'),
  (328, 48, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:04'),
  (329, 49, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:05'),
  (330, 49, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:46:05'),
  (331, 68, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:01'),
  (332, 69, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:01'),
  (333, 70, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:01'),
  (334, 71, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:01'),
  (335, 72, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:01'),
  (336, 73, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:01'),
  (337, 74, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:02'),
  (338, 75, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:02'),
  (339, 76, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:02'),
  (340, 77, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:02'),
  (341, 78, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:02'),
  (342, 79, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:02'),
  (343, 80, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:02'),
  (344, 81, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:03'),
  (345, 82, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:03'),
  (346, 83, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:03'),
  (347, 84, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:03'),
  (348, 85, '120.00', '100.00', '80.00', '0.00', '2000.00', '2300.00', '2022-03-03 18:48:03');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `employees`
  --
  
  CREATE TABLE `employees` (
    `id` int(11) NOT NULL,
    `fullname` varchar(255) NOT NULL,
    `role` varchar(255) NOT NULL,
    `emp_type` varchar(255) NOT NULL,
    `timestamp` datetime NOT NULL DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `employees`
  --
  
  INSERT INTO `employees` (`id`, `fullname`, `role`, `emp_type`, `timestamp`) VALUES
  (1, 'ABAN, ARTHUR ', 'AOM', 'Regular', '2022-03-01 06:04:44'),
  (2, 'AGUINSATAN, ROBERT ANDREW R.', 'TL', 'Regular', '2022-03-01 06:04:44'),
  (3, 'ASI, GLENN JAY', 'IT', 'Regular', '2022-03-01 06:04:45'),
  (4, 'CORTES, EUGENE', 'IT', 'Regular', '2022-03-01 06:04:45'),
  (5, 'EMBLAWA, MARVIN', 'QA', 'Regular', '2022-03-01 06:04:45'),
  (6, 'ENTAL, EDNA M.', 'GUARD', 'Regular', '2022-03-01 06:04:45'),
  (7, 'LUARDO, ALCHON B.', 'SUPPORT', 'Regular', '2022-03-01 06:04:45'),
  (8, 'MANAOIS, JUNE ', 'OM', 'Regular', '2022-03-01 06:04:46'),
  (9, 'OBELIDHON, ANGEL MAE', 'RECRUITMENT', 'Regular', '2022-03-01 06:04:46'),
  (10, 'OMBIGA, ROCHELLE', 'ADMIN', 'Regular', '2022-03-01 06:04:46'),
  (11, 'PERLAS, MICHAEL JOHN', 'TL', 'Regular', '2022-03-01 06:04:46'),
  (12, 'REYES, JAMES BRYAN O.', 'SME', 'Regular', '2022-03-01 06:04:46'),
  (13, 'SOLIS, MARIANNE', 'CLEANER', 'Regular', '2022-03-01 06:04:46'),
  (14, 'TAHIL, MAIMONA', 'ADMIN', 'Regular', '2022-03-01 06:04:47'),
  (15, 'TULLAO, MIERYCKERT', 'QA', 'Regular', '2022-03-01 06:04:47'),
  (16, 'VALENCIA, JUBERT', 'DRIVER', 'Regular', '2022-03-01 06:04:47'),
  (17, 'ABAS, MARYANNE P.', 'AGENT', 'Regular', '2022-03-01 06:04:47'),
  (18, 'ABIERA, RONMIR', 'AGENT', 'Regular', '2022-03-01 06:04:48'),
  (19, 'AMAD, KRISTAL GEAN', 'AGENT', 'Regular', '2022-03-01 06:04:48'),
  (20, 'AVILES, JAN RIZ', 'AGENT', 'Regular', '2022-03-01 06:04:48'),
  (21, 'AYON, KARL JAKE', 'AGENT', 'Regular', '2022-03-01 06:04:49'),
  (22, 'BACLAYAN, JESSA MAE ', 'AGENT', 'Regular', '2022-03-01 06:04:49'),
  (23, 'BARCENA, VENUS', 'AGENT', 'Regular', '2022-03-01 06:04:50'),
  (24, 'BORJA, MARIA KRISTINA', 'AGENT', 'Regular', '2022-03-01 06:04:50'),
  (25, 'COSTAN, LEXCY JEAN ', 'AGENT', 'Regular', '2022-03-01 06:04:51'),
  (26, 'DASOC, ROBERT', 'AGENT', 'Regular', '2022-03-01 06:04:51'),
  (27, 'DIANSAY, EDUARD', 'AGENT', 'Regular', '2022-03-01 06:04:51'),
  (28, 'DOLORES, GRACE', 'AGENT', 'Regular', '2022-03-01 06:04:52'),
  (29, 'GONATO, CRIS ROLDAN', 'AGENT', 'Regular', '2022-03-01 06:04:52'),
  (30, 'JUMAWID, NARLYN', 'AGENT', 'Regular', '2022-03-01 06:04:52'),
  (31, 'LANGINAN, JANISSAS', 'AGENT', 'Regular', '2022-03-01 06:04:52'),
  (32, 'LAWIAN, JEFFREY', 'AGENT', 'Regular', '2022-03-01 06:04:52'),
  (33, 'LIMBAGO, LYNDON ALDOUS', 'AGENT', 'Regular', '2022-03-01 06:04:52'),
  (34, 'LUMOCSO, CHARITY DAWN', 'AGENT', 'Regular', '2022-03-01 06:04:53'),
  (35, 'LUNGAN, ROBBY ', 'AGENT', 'Regular', '2022-03-01 06:04:53'),
  (36, 'MAGALONA, VAL MITCHELLE', 'AGENT', 'Regular', '2022-03-01 06:04:53'),
  (37, 'MAHILUM, KYLE', 'AGENT', 'Regular', '2022-03-01 06:04:53'),
  (38, 'MALUPA, ANA MADEL', 'AGENT', 'Regular', '2022-03-01 06:04:53'),
  (39, 'MONTEALEGRE, VANESSA', 'AGENT', 'Regular', '2022-03-01 06:04:54'),
  (40, 'NOJOR, JERIC S.', 'AGENT', 'Regular', '2022-03-01 06:04:54'),
  (41, 'OMANDAM, RUDELYN', 'AGENT', 'Regular', '2022-03-01 06:04:55'),
  (42, 'OSORIO, JOEY', 'AGENT', 'Regular', '2022-03-01 06:04:55'),
  (43, 'PAGUIDOPON, LAWRENCE CONRAD', 'AGENT', 'Regular', '2022-03-01 06:04:55'),
  (44, 'PRE, CARLOS MECAR JOHN SHADDE', 'AGENT', 'Regular', '2022-03-01 06:04:56'),
  (45, 'SALPOCIAL, CRISTINE JOY I.', 'AGENT', 'Regular', '2022-03-01 06:04:56'),
  (46, 'SATUROS, JAMAICA F.', 'AGENT', 'Regular', '2022-03-01 06:04:56'),
  (47, 'SILVANO, CRYSTAL JADE', 'AGENT', 'Regular', '2022-03-01 06:04:56'),
  (48, 'TARROSA, JOHN LOYD', 'AGENT', 'Regular', '2022-03-01 06:04:56'),
  (49, 'TENEFRANCIA, JAMES ANDREI', 'AGENT', 'Regular', '2022-03-01 06:04:56'),
  (68, 'ALFECHE, STEPHANIE', 'AGENT', 'Sales', '2022-03-03 23:27:24'),
  (69, 'CAHILOG, ERWIN', 'AGENT', 'Sales', '2022-03-03 23:27:25'),
  (70, 'CEBA, JUVELYN', 'AGENT', 'Sales', '2022-03-03 23:27:25'),
  (71, 'DACILLO, CHRISTELLA MAE', 'AGENT', 'Sales', '2022-03-03 23:27:25'),
  (72, 'DIAMAN, AILYN', 'AGENT', 'Sales', '2022-03-03 23:27:25'),
  (73, 'DOMINGO, VINCENT', 'AGENT', 'Sales', '2022-03-03 23:27:25'),
  (74, 'GARBO, CYREEN ROSE VISTAR', 'AGENT', 'Sales', '2022-03-03 23:27:25'),
  (75, 'HADMAN, DIANNE', 'AGENT', 'Sales', '2022-03-03 23:27:26'),
  (76, 'LOYLOY, ALLIEN REY D.', 'AGENT', 'Sales', '2022-03-03 23:27:26'),
  (77, 'NORBE, FRITZY JOY', 'AGENT', 'Sales', '2022-03-03 23:27:26'),
  (78, 'PARCON, GODWIN', 'AGENT', 'Sales', '2022-03-03 23:27:26'),
  (79, 'ROBLES, ARNEL', 'AGENT', 'Sales', '2022-03-03 23:27:26'),
  (80, 'SAGA, DIETHER JOHN', 'AGENT', 'Sales', '2022-03-03 23:27:26'),
  (81, 'SALCEDO, GINA', 'AGENT', 'Sales', '2022-03-03 23:27:26'),
  (82, 'SALUDAGA, JAY', 'AGENT', 'Sales', '2022-03-03 23:27:27'),
  (83, 'SCHUCK, ANDREAN', 'AGENT', 'Sales', '2022-03-03 23:27:27'),
  (84, 'VERTUDAZO, ALJON', 'AGENT', 'Sales', '2022-03-03 23:27:27'),
  (85, 'VILLACORTA, SUNSHINE V.', 'AGENT', 'Sales', '2022-03-03 23:27:27');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `reg_manhour`
  --
  
  CREATE TABLE `reg_manhour` (
    `id` int(11) NOT NULL,
    `emp_id` int(11) NOT NULL,
    `total_worked_hrs` decimal(20,2) NOT NULL,
    `total_nd_hrs` decimal(20,2) NOT NULL,
    `reg_hol_hrs` decimal(20,2) NOT NULL,
    `ot_hrs` decimal(20,2) NOT NULL,
    `spl_hol_hrs` decimal(20,2) NOT NULL,
    `prem_hrs` decimal(20,2) NOT NULL,
    `timestamps` datetime DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `reg_manhour`
  --
  
  INSERT INTO `reg_manhour` (`id`, `emp_id`, `total_worked_hrs`, `total_nd_hrs`, `reg_hol_hrs`, `ot_hrs`, `spl_hol_hrs`, `prem_hrs`, `timestamps`) VALUES
  (1, 1, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:44'),
  (2, 2, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:45'),
  (3, 3, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:45'),
  (4, 4, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:45'),
  (5, 5, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:45'),
  (6, 6, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:45'),
  (7, 7, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:46'),
  (8, 8, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:46'),
  (9, 9, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:46'),
  (10, 10, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:46'),
  (11, 11, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:46'),
  (12, 12, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:46'),
  (13, 13, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:47'),
  (14, 14, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:47'),
  (15, 15, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:47'),
  (16, 16, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:47'),
  (17, 17, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:47'),
  (18, 18, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:48'),
  (19, 19, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:48'),
  (20, 20, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:49'),
  (21, 21, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:49'),
  (22, 22, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:50'),
  (23, 23, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:50'),
  (24, 24, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:51'),
  (25, 25, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:51'),
  (26, 26, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:51'),
  (27, 27, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:52'),
  (28, 28, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:52'),
  (29, 29, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:52'),
  (30, 30, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:52'),
  (31, 31, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:52'),
  (32, 32, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:52'),
  (33, 33, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:53'),
  (34, 34, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:53'),
  (35, 35, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:53'),
  (36, 36, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:53'),
  (37, 37, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:53'),
  (38, 38, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:54'),
  (39, 39, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:54'),
  (40, 40, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:55'),
  (41, 41, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:55'),
  (42, 42, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:55'),
  (43, 43, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:55'),
  (44, 44, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:56'),
  (45, 45, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:56'),
  (46, 46, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:56'),
  (47, 47, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:56'),
  (48, 48, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:56'),
  (49, 49, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-01 06:04:56'),
  (50, 1, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:33'),
  (51, 2, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:33'),
  (52, 3, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:33'),
  (53, 4, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:34'),
  (54, 5, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:34'),
  (55, 6, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:34'),
  (56, 7, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:34'),
  (57, 8, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:34'),
  (58, 9, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:34'),
  (59, 10, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:34'),
  (60, 11, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:35'),
  (61, 12, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:35'),
  (62, 13, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:35'),
  (63, 14, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:35'),
  (64, 15, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:35'),
  (65, 16, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:35'),
  (66, 17, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:35'),
  (67, 18, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:35'),
  (68, 19, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:36'),
  (69, 20, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:36'),
  (70, 21, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:36'),
  (71, 22, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:36'),
  (72, 23, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:36'),
  (73, 24, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:36'),
  (74, 25, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:36'),
  (75, 26, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:37'),
  (76, 27, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:37'),
  (77, 28, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:37'),
  (78, 29, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:37'),
  (79, 30, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:37'),
  (80, 31, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:38'),
  (81, 32, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:38'),
  (82, 33, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:38'),
  (83, 34, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:38'),
  (84, 35, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:38'),
  (85, 36, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:39'),
  (86, 37, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:39'),
  (87, 38, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:40'),
  (88, 39, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:40'),
  (89, 40, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:40'),
  (90, 41, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:40'),
  (91, 42, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:40'),
  (92, 43, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:40'),
  (93, 44, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:41'),
  (94, 45, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:41'),
  (95, 46, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:41'),
  (96, 47, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:41'),
  (97, 48, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:41'),
  (98, 1, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:41'),
  (99, 49, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:41'),
  (100, 2, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:42'),
  (101, 3, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:42'),
  (102, 4, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:42'),
  (103, 5, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:42'),
  (104, 6, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:42'),
  (105, 7, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:42'),
  (106, 8, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:42'),
  (107, 9, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:43'),
  (108, 10, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:43'),
  (109, 11, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:43'),
  (110, 12, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:43'),
  (111, 13, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:43'),
  (112, 14, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:43'),
  (113, 15, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:44'),
  (114, 16, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:45'),
  (115, 17, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:45'),
  (116, 18, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:45'),
  (117, 19, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:45'),
  (118, 1, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:45'),
  (119, 20, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:45'),
  (120, 2, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:45'),
  (121, 21, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:46'),
  (122, 3, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:46'),
  (123, 22, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:46'),
  (124, 4, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:46'),
  (125, 23, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:46'),
  (126, 1, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:46'),
  (127, 5, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:46'),
  (128, 1, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:46'),
  (129, 2, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:46'),
  (130, 24, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:46'),
  (131, 6, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:47'),
  (132, 2, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:47'),
  (133, 3, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:47'),
  (134, 25, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:47'),
  (135, 7, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:47'),
  (136, 3, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:47'),
  (137, 26, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:47'),
  (138, 4, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:47'),
  (139, 8, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:47'),
  (140, 4, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:48'),
  (141, 27, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:48'),
  (142, 5, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:48'),
  (143, 9, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:48'),
  (144, 5, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:48'),
  (145, 6, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:49'),
  (146, 10, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:49'),
  (147, 28, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:49'),
  (148, 6, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:49'),
  (149, 7, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:49'),
  (150, 11, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:49'),
  (151, 29, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:49'),
  (152, 7, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:49'),
  (153, 8, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:49'),
  (154, 12, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:49'),
  (155, 30, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:49'),
  (156, 8, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:49'),
  (157, 9, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:50'),
  (158, 13, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:50'),
  (159, 31, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:50'),
  (160, 9, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:50'),
  (161, 10, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:50'),
  (162, 14, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:50'),
  (163, 32, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:50'),
  (164, 10, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:50'),
  (165, 15, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:51'),
  (166, 11, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:51'),
  (167, 33, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:51'),
  (168, 11, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:51'),
  (169, 16, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:52'),
  (170, 12, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:52'),
  (171, 34, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:52'),
  (172, 12, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:52'),
  (173, 17, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:52'),
  (174, 13, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:52'),
  (175, 35, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:52'),
  (176, 18, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:52'),
  (177, 13, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:52'),
  (178, 14, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:53'),
  (179, 36, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:53'),
  (180, 19, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:53'),
  (181, 14, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:53'),
  (182, 15, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:53'),
  (183, 37, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:53'),
  (184, 15, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:53'),
  (185, 20, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:53'),
  (186, 16, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:53'),
  (187, 38, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:54'),
  (188, 16, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:54'),
  (189, 21, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:54'),
  (190, 17, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:54'),
  (191, 17, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:54'),
  (192, 39, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:54'),
  (193, 22, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:54'),
  (194, 18, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:54'),
  (195, 18, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:54'),
  (196, 40, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:54'),
  (197, 19, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:55'),
  (198, 23, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:55'),
  (199, 19, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:55'),
  (200, 41, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:55'),
  (201, 20, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:55'),
  (202, 24, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:55'),
  (203, 20, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:55'),
  (204, 42, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:55'),
  (205, 21, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:55'),
  (206, 25, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:56'),
  (207, 21, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:56'),
  (208, 43, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:56'),
  (209, 22, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:56'),
  (210, 26, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:57'),
  (211, 22, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:57'),
  (212, 44, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:57'),
  (213, 23, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:57'),
  (214, 27, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:57'),
  (215, 23, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:57'),
  (216, 45, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:57'),
  (217, 24, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:57'),
  (218, 28, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:57'),
  (219, 46, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:57'),
  (220, 24, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:57'),
  (221, 25, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:57'),
  (222, 29, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:57'),
  (223, 47, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:57'),
  (224, 25, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:57'),
  (225, 26, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:58'),
  (226, 30, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:58'),
  (227, 26, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:58'),
  (228, 48, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:58'),
  (229, 27, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:58'),
  (230, 31, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:58'),
  (231, 27, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:58'),
  (232, 49, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:58'),
  (233, 32, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:58'),
  (234, 28, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:58'),
  (235, 28, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:58'),
  (236, 29, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:59'),
  (237, 29, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:59'),
  (238, 33, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:59'),
  (239, 30, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:59'),
  (240, 30, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:59'),
  (241, 34, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:45:59'),
  (242, 31, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:00'),
  (243, 31, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:00'),
  (244, 35, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:00'),
  (245, 32, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:00'),
  (246, 32, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:00'),
  (247, 36, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:00'),
  (248, 33, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:00'),
  (249, 33, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:00'),
  (250, 37, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:00'),
  (251, 34, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:00'),
  (252, 34, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:00'),
  (253, 38, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:01'),
  (254, 35, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:01'),
  (255, 35, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:01'),
  (256, 39, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:01'),
  (257, 36, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:01'),
  (258, 36, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:01'),
  (259, 37, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:01'),
  (260, 37, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:01'),
  (261, 40, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:01'),
  (262, 38, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:01'),
  (263, 41, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:01'),
  (264, 38, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:01'),
  (265, 39, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:02'),
  (266, 42, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:02'),
  (267, 39, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:02'),
  (268, 40, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:02'),
  (269, 40, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:02'),
  (270, 43, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:02'),
  (271, 41, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:02'),
  (272, 41, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:02'),
  (273, 44, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:02'),
  (274, 42, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:02'),
  (275, 42, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:02'),
  (276, 45, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:03'),
  (277, 43, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:03'),
  (278, 43, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:03'),
  (279, 46, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:03'),
  (280, 44, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:03'),
  (281, 44, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:03'),
  (282, 47, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:03'),
  (283, 45, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:03'),
  (284, 45, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:03'),
  (285, 48, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:03'),
  (286, 46, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:03'),
  (287, 46, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:03'),
  (288, 49, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:04'),
  (289, 47, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:04'),
  (290, 47, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:04'),
  (291, 48, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:04'),
  (292, 48, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:04'),
  (293, 49, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:05'),
  (294, 49, '80.00', '60.00', '2.00', '2.00', '0.00', '0.00', '2022-03-04 02:46:05');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `reg_pay`
  --
  
  CREATE TABLE `reg_pay` (
    `id` int(11) NOT NULL,
    `emp_id` int(11) NOT NULL,
    `basic_hrs_pay` decimal(20,2) NOT NULL,
    `nds_pay` decimal(20,2) NOT NULL,
    `allow_pay` decimal(20,2) NOT NULL,
    `dispute` decimal(20,2) NOT NULL,
    `spl_hol_pay` decimal(20,2) NOT NULL,
    `reg_hol_pay` decimal(20,2) NOT NULL,
    `prem_hol_pay` decimal(20,2) NOT NULL,
    `ot_pay` decimal(20,2) NOT NULL,
    `gross_pay` decimal(20,2) NOT NULL,
    `net_pay` decimal(20,2) NOT NULL,
    `pay_sched` date DEFAULT NULL,
    `visibility` tinyint(1) NOT NULL,
    `timestamps` timestamp NOT NULL DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `reg_pay`
  --
  
  INSERT INTO `reg_pay` (`id`, `emp_id`, `basic_hrs_pay`, `nds_pay`, `allow_pay`, `dispute`, `spl_hol_pay`, `reg_hol_pay`, `prem_hol_pay`, `ot_pay`, `gross_pay`, `net_pay`, `pay_sched`, `visibility`, `timestamps`) VALUES
  (1, 1, '0.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:44'),
  (2, 2, '0.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:44'),
  (3, 3, '0.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:45'),
  (4, 4, '0.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:45'),
  (5, 5, '0.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:45'),
  (6, 6, '0.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:45'),
  (7, 7, '0.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:45'),
  (8, 8, '0.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:46'),
  (9, 9, '0.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:46'),
  (10, 10, '0.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:46'),
  (11, 11, '0.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:46'),
  (12, 12, '0.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:46'),
  (13, 13, '0.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:46'),
  (14, 14, '0.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:47'),
  (15, 15, '0.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:47'),
  (16, 16, '0.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:47'),
  (17, 17, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:47'),
  (18, 18, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:48'),
  (19, 19, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:48'),
  (20, 20, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:48'),
  (21, 21, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:49'),
  (22, 22, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:50'),
  (23, 23, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:50'),
  (24, 24, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:50'),
  (25, 25, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:51'),
  (26, 26, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:51'),
  (27, 27, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:51'),
  (28, 28, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:52'),
  (29, 29, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:52'),
  (30, 30, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:52'),
  (31, 31, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:52'),
  (32, 32, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:52'),
  (33, 33, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:52'),
  (34, 34, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:53'),
  (35, 35, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:53'),
  (36, 36, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:53'),
  (37, 37, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:53'),
  (38, 38, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:53'),
  (39, 39, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:54'),
  (40, 40, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:54'),
  (41, 41, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:55'),
  (42, 42, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:55'),
  (43, 43, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:55'),
  (44, 44, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:56'),
  (45, 45, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:56'),
  (46, 46, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:56'),
  (47, 47, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:56'),
  (48, 48, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:56'),
  (49, 49, '0.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '0.00', '0.00', NULL, 1, '2022-02-28 22:04:56'),
  (50, 1, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:33'),
  (51, 2, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:33'),
  (52, 3, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:33'),
  (53, 4, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:33'),
  (54, 5, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:34'),
  (55, 6, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:34'),
  (56, 7, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:34'),
  (57, 8, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:34'),
  (58, 9, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:34'),
  (59, 10, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:34'),
  (60, 11, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:34'),
  (61, 12, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:35'),
  (62, 13, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:35'),
  (63, 14, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:35'),
  (64, 15, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:35'),
  (65, 16, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:35'),
  (66, 17, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:35'),
  (67, 18, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:35'),
  (68, 19, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:36'),
  (69, 20, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:36'),
  (70, 21, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:36'),
  (71, 22, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:36'),
  (72, 23, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:36'),
  (73, 24, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:36'),
  (74, 25, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:36'),
  (75, 26, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:36'),
  (76, 27, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:37'),
  (77, 28, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:37'),
  (78, 29, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:37'),
  (79, 30, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:37'),
  (80, 31, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:37'),
  (81, 32, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:38'),
  (82, 33, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:38'),
  (83, 34, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:38'),
  (84, 35, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:38'),
  (85, 36, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:38'),
  (86, 37, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:39'),
  (87, 38, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:40'),
  (88, 39, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:40'),
  (89, 40, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:40'),
  (90, 41, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:40'),
  (91, 42, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:40'),
  (92, 43, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:40'),
  (93, 44, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:41'),
  (94, 45, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:41'),
  (95, 46, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:41'),
  (96, 47, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:41'),
  (97, 48, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:41'),
  (98, 1, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:41'),
  (99, 49, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:41'),
  (100, 2, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:41'),
  (101, 3, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:42'),
  (102, 4, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:42'),
  (103, 5, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:42'),
  (104, 6, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:42'),
  (105, 7, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:42'),
  (106, 8, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:42'),
  (107, 9, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:42'),
  (108, 10, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:43'),
  (109, 11, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:43'),
  (110, 12, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:43'),
  (111, 13, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:43'),
  (112, 14, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:43'),
  (113, 15, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:43'),
  (114, 16, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:44'),
  (115, 17, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:45'),
  (116, 18, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:45'),
  (117, 19, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:45'),
  (118, 1, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:45'),
  (119, 20, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:45'),
  (120, 2, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:45'),
  (121, 21, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:45'),
  (122, 3, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:45'),
  (123, 22, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:46'),
  (124, 4, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:46'),
  (125, 23, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:46'),
  (126, 1, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:46'),
  (127, 5, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:46'),
  (128, 1, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:46'),
  (129, 2, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:46'),
  (130, 24, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:46'),
  (131, 6, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:46'),
  (132, 2, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:46'),
  (133, 25, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:47'),
  (134, 3, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:47'),
  (135, 7, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:47'),
  (136, 3, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:47'),
  (137, 26, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:47'),
  (138, 4, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:47'),
  (139, 8, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:47'),
  (140, 4, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:47'),
  (141, 27, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:47'),
  (142, 5, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:47'),
  (143, 9, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:47'),
  (144, 5, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:48'),
  (145, 6, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:48'),
  (146, 28, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:48'),
  (147, 10, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:48'),
  (148, 6, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:48'),
  (149, 7, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:49'),
  (150, 11, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:49'),
  (151, 29, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:49'),
  (152, 7, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:49'),
  (153, 8, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:49'),
  (154, 12, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:49'),
  (155, 30, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:49'),
  (156, 8, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:49'),
  (157, 9, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:49'),
  (158, 13, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:49'),
  (159, 31, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:50'),
  (160, 9, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:50'),
  (161, 10, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:50'),
  (162, 14, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:50'),
  (163, 32, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:50'),
  (164, 10, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:50'),
  (165, 11, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:50'),
  (166, 15, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:50'),
  (167, 33, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:50'),
  (168, 11, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:51'),
  (169, 16, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:51'),
  (170, 12, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:51'),
  (171, 34, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:51'),
  (172, 12, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:51'),
  (173, 17, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:52'),
  (174, 13, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:52'),
  (175, 35, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:52'),
  (176, 13, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:52'),
  (177, 18, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:52'),
  (178, 14, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:52'),
  (179, 36, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:53'),
  (180, 19, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:53'),
  (181, 14, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:53'),
  (182, 15, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:53'),
  (183, 37, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:53'),
  (184, 15, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:53'),
  (185, 20, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:53'),
  (186, 16, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:53'),
  (187, 38, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:53'),
  (188, 16, '14400.00', '480.00', '0.00', '0.00', '320.00', '150.00', '150.00', '120.00', '15620.00', '13320.00', '2022-03-15', 0, '2022-03-03 18:45:53'),
  (189, 21, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:53'),
  (190, 17, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:53'),
  (191, 39, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:54'),
  (192, 17, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:54'),
  (193, 22, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:54'),
  (194, 18, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:54'),
  (195, 18, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:54'),
  (196, 40, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:54'),
  (197, 23, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:54'),
  (198, 19, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:54'),
  (199, 41, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:54'),
  (200, 19, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:54'),
  (201, 20, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:55'),
  (202, 24, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:55'),
  (203, 20, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:55'),
  (204, 42, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:55'),
  (205, 21, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:55'),
  (206, 25, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:55'),
  (207, 21, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:55'),
  (208, 43, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:55'),
  (209, 22, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:56'),
  (210, 26, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:56'),
  (211, 44, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:56'),
  (212, 22, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:56'),
  (213, 23, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:57'),
  (214, 27, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:57'),
  (215, 23, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:57'),
  (216, 45, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:57'),
  (217, 24, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:57'),
  (218, 28, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:57'),
  (219, 46, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:57'),
  (220, 24, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:57'),
  (221, 25, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:57'),
  (222, 29, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:57'),
  (223, 47, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:57'),
  (224, 25, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:57'),
  (225, 26, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:57'),
  (226, 30, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:57'),
  (227, 26, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:58'),
  (228, 48, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:58'),
  (229, 31, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:58'),
  (230, 27, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:58'),
  (231, 27, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:58'),
  (232, 49, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:58'),
  (233, 28, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:58'),
  (234, 32, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:58'),
  (235, 28, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:58'),
  (236, 29, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:58'),
  (237, 33, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:58'),
  (238, 29, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:58'),
  (239, 30, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:59'),
  (240, 30, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:59'),
  (241, 34, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:59'),
  (242, 31, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:59'),
  (243, 31, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:45:59'),
  (244, 35, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:00'),
  (245, 32, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:00'),
  (246, 32, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:00'),
  (247, 36, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:00'),
  (248, 33, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:00'),
  (249, 33, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:00'),
  (250, 37, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:00'),
  (251, 34, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:00'),
  (252, 34, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:00'),
  (253, 38, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:00'),
  (254, 35, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:00'),
  (255, 35, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:00'),
  (256, 39, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:01'),
  (257, 36, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:01'),
  (258, 36, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:01'),
  (259, 37, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:01'),
  (260, 40, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:01'),
  (261, 37, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:01'),
  (262, 38, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:01'),
  (263, 41, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:01'),
  (264, 38, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:01'),
  (265, 39, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:01'),
  (266, 42, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:01'),
  (267, 39, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:01'),
  (268, 40, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:02'),
  (269, 43, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:02'),
  (270, 40, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:02'),
  (271, 41, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:02'),
  (272, 44, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:02'),
  (273, 41, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:02'),
  (274, 42, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:02'),
  (275, 42, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:02'),
  (276, 45, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:02'),
  (277, 43, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:02'),
  (278, 43, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:03'),
  (279, 46, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:03'),
  (280, 44, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:03'),
  (281, 44, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:03'),
  (282, 47, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:03'),
  (283, 45, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:03'),
  (284, 45, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:03'),
  (285, 48, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:03'),
  (286, 46, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:03'),
  (287, 46, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:03'),
  (288, 49, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:03'),
  (289, 47, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:03'),
  (290, 47, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:04'),
  (291, 48, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:04'),
  (292, 48, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:04'),
  (293, 49, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:04'),
  (294, 49, '6800.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '120.00', '7770.00', '5470.00', '2022-03-15', 0, '2022-03-03 18:46:05');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `reg_rate`
  --
  
  CREATE TABLE `reg_rate` (
    `id` int(11) NOT NULL,
    `emp_id` int(11) NOT NULL,
    `daily_rate` decimal(20,2) NOT NULL,
    `hrly_rate` decimal(20,2) NOT NULL,
    `hr_rate` decimal(20,2) NOT NULL,
    `allow_hr_rate` decimal(20,2) NOT NULL,
    `nd_rate` decimal(20,2) NOT NULL,
    `timestamps` timestamp NOT NULL DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `reg_rate`
  --
  
  INSERT INTO `reg_rate` (`id`, `emp_id`, `daily_rate`, `hrly_rate`, `hr_rate`, `allow_hr_rate`, `nd_rate`, `timestamps`) VALUES
  (1, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:44'),
  (2, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:45'),
  (3, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:45'),
  (4, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:45'),
  (5, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:45'),
  (6, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:45'),
  (7, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:46'),
  (8, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:46'),
  (9, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:46'),
  (10, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:46'),
  (11, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:46'),
  (12, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:46'),
  (13, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:47'),
  (14, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:47'),
  (15, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:47'),
  (16, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:47'),
  (17, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:47'),
  (18, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:48'),
  (19, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:48'),
  (20, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:49'),
  (21, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:49'),
  (22, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:50'),
  (23, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:50'),
  (24, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:51'),
  (25, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:51'),
  (26, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:51'),
  (27, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:51'),
  (28, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:52'),
  (29, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:52'),
  (30, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:52'),
  (31, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:52'),
  (32, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:52'),
  (33, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:53'),
  (34, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:53'),
  (35, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:53'),
  (36, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:53'),
  (37, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:53'),
  (38, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:54'),
  (39, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:54'),
  (40, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:55'),
  (41, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:55'),
  (42, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:55'),
  (43, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:55'),
  (44, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:56'),
  (45, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:56'),
  (46, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:56'),
  (47, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:56'),
  (48, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:56'),
  (49, 49, '680.00', '85.00', '0.00', '0.00', '5.00', '2022-02-28 22:04:56');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `sales_manhour`
  --
  
  CREATE TABLE `sales_manhour` (
    `id` int(11) NOT NULL,
    `emp_id` int(11) NOT NULL,
    `total_sales` decimal(20,2) NOT NULL,
    `training_days` decimal(20,2) NOT NULL,
    `reg_hol_hrs` decimal(20,2) NOT NULL,
    `total_num_days` decimal(20,2) NOT NULL,
    `spl_hrs` decimal(20,2) NOT NULL,
    `prem_hrs` decimal(20,2) NOT NULL,
    `timestamps` datetime NOT NULL DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `sales_manhour`
  --
  
  INSERT INTO `sales_manhour` (`id`, `emp_id`, `total_sales`, `training_days`, `reg_hol_hrs`, `total_num_days`, `spl_hrs`, `prem_hrs`, `timestamps`) VALUES
  (1, 50, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:34'),
  (2, 51, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:34'),
  (3, 52, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:35'),
  (4, 53, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:35'),
  (5, 54, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:35'),
  (6, 55, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:35'),
  (7, 56, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:35'),
  (8, 57, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:35'),
  (9, 58, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:36'),
  (10, 59, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:36'),
  (11, 60, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:36'),
  (12, 61, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:36'),
  (13, 62, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:36'),
  (14, 63, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:36'),
  (15, 64, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:37'),
  (16, 65, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:37'),
  (17, 66, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:37'),
  (18, 67, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:25:37'),
  (19, 68, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:24'),
  (20, 69, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:25'),
  (21, 70, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:25'),
  (22, 71, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:25'),
  (23, 72, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:25'),
  (24, 73, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:25'),
  (25, 74, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:26'),
  (26, 75, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:26'),
  (27, 76, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:26'),
  (28, 77, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:26'),
  (29, 78, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:26'),
  (30, 79, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:26'),
  (31, 80, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:26'),
  (32, 81, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:27'),
  (33, 82, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:27'),
  (34, 83, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:27'),
  (35, 84, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:27'),
  (36, 85, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-03 23:27:28'),
  (37, 68, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:01'),
  (38, 69, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:01'),
  (39, 70, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:01'),
  (40, 71, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:01'),
  (41, 72, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:01'),
  (42, 73, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:02'),
  (43, 74, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:02'),
  (44, 75, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:02'),
  (45, 76, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:02'),
  (46, 77, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:02'),
  (47, 78, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:02'),
  (48, 79, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:02'),
  (49, 80, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:02'),
  (50, 81, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:03'),
  (51, 82, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:03'),
  (52, 83, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:03'),
  (53, 84, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:03'),
  (54, 85, '80.00', '3.00', '2.00', '10.00', '0.00', '0.00', '2022-03-04 02:48:03');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `sales_pay`
  --
  
  CREATE TABLE `sales_pay` (
    `id` int(11) NOT NULL,
    `emp_id` int(11) NOT NULL,
    `sales_pay` decimal(20,2) NOT NULL,
    `training_pay` decimal(20,2) NOT NULL,
    `allow_pay` decimal(20,2) NOT NULL,
    `dispute` decimal(20,2) NOT NULL,
    `spl_pay` decimal(20,2) NOT NULL,
    `reg_hol_pay` decimal(20,2) NOT NULL,
    `premium_pay` decimal(20,2) NOT NULL,
    `ot_pay` decimal(20,2) NOT NULL,
    `gross_pay` decimal(20,2) NOT NULL,
    `net_pay` decimal(20,2) NOT NULL,
    `pay_sched` date DEFAULT NULL,
    `visibility` tinyint(1) NOT NULL,
    `timestamps` datetime NOT NULL DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `sales_pay`
  --
  
  INSERT INTO `sales_pay` (`id`, `emp_id`, `sales_pay`, `training_pay`, `allow_pay`, `dispute`, `spl_pay`, `reg_hol_pay`, `premium_pay`, `ot_pay`, `gross_pay`, `net_pay`, `pay_sched`, `visibility`, `timestamps`) VALUES
  (1, 50, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', '2022-03-15', 1, '2022-03-03 23:25:34'),
  (2, 51, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:34'),
  (3, 52, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:34'),
  (4, 53, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:35'),
  (5, 54, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:35'),
  (6, 55, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:35'),
  (7, 56, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:35'),
  (8, 57, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:35'),
  (9, 58, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:36'),
  (10, 59, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:36'),
  (11, 60, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:36'),
  (12, 61, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:36'),
  (13, 62, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:36'),
  (14, 63, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:36'),
  (15, 64, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:37'),
  (16, 65, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:37'),
  (17, 66, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:37'),
  (18, 67, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:25:37'),
  (19, 68, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:24'),
  (20, 69, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:25'),
  (21, 70, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:25'),
  (22, 71, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:25'),
  (23, 72, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:25'),
  (24, 73, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:25'),
  (25, 74, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:26'),
  (26, 75, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:26'),
  (27, 76, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:26'),
  (28, 77, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:26'),
  (29, 78, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:26'),
  (30, 79, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:26'),
  (31, 80, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:26'),
  (32, 81, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:27'),
  (33, 82, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:27'),
  (34, 83, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:27'),
  (35, 84, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:27'),
  (36, 85, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 1, '2022-03-03 23:27:27'),
  (37, 68, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:00'),
  (38, 69, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:01'),
  (39, 70, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:01'),
  (40, 71, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:01'),
  (41, 72, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:01'),
  (42, 73, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:01'),
  (43, 74, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:02'),
  (44, 75, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:02'),
  (45, 76, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:02'),
  (46, 77, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:02'),
  (47, 78, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:02'),
  (48, 79, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:02'),
  (49, 80, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:02'),
  (50, 81, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:02'),
  (51, 82, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:03'),
  (52, 83, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:03'),
  (53, 84, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:03'),
  (54, 85, '3500.00', '300.00', '0.00', '0.00', '280.00', '150.00', '120.00', '135.00', '4485.00', '2185.00', NULL, 0, '2022-03-04 02:48:03');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `sales_rate`
  --
  
  CREATE TABLE `sales_rate` (
    `id` int(11) NOT NULL,
    `emp_id` int(11) NOT NULL,
    `training_rate` decimal(20,2) NOT NULL,
    `sales_rate` decimal(20,2) NOT NULL,
    `allow_rate` decimal(20,2) NOT NULL,
    `nd_rate` decimal(20,2) NOT NULL,
    `timestamps` datetime NOT NULL DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `sales_rate`
  --
  
  INSERT INTO `sales_rate` (`id`, `emp_id`, `training_rate`, `sales_rate`, `allow_rate`, `nd_rate`, `timestamps`) VALUES
  (1, 50, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:34'),
  (2, 51, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:34'),
  (3, 52, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:34'),
  (4, 53, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:35'),
  (5, 54, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:35'),
  (6, 55, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:35'),
  (7, 56, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:35'),
  (8, 57, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:35'),
  (9, 58, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:36'),
  (10, 59, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:36'),
  (11, 60, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:36'),
  (12, 61, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:36'),
  (13, 62, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:36'),
  (14, 63, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:36'),
  (15, 64, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:37'),
  (16, 65, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:37'),
  (17, 66, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:37'),
  (18, 67, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:25:37'),
  (19, 68, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:24'),
  (20, 69, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:25'),
  (21, 70, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:25'),
  (22, 71, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:25'),
  (23, 72, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:25'),
  (24, 73, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:25'),
  (25, 74, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:26'),
  (26, 75, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:26'),
  (27, 76, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:26'),
  (28, 77, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:26'),
  (29, 78, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:26'),
  (30, 79, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:26'),
  (31, 80, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:26'),
  (32, 81, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:27'),
  (33, 82, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:27'),
  (34, 83, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:27'),
  (35, 84, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:27'),
  (36, 85, '120.00', '350.00', '100.00', '5.00', '2022-03-03 23:27:27'),
  (37, 68, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:01'),
  (38, 69, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:01'),
  (39, 70, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:01'),
  (40, 71, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:01'),
  (41, 72, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:01'),
  (42, 73, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:01'),
  (43, 74, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:02'),
  (44, 75, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:02'),
  (45, 76, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:02'),
  (46, 77, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:02'),
  (47, 78, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:02'),
  (48, 79, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:02'),
  (49, 80, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:02'),
  (50, 81, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:03'),
  (51, 82, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:03'),
  (52, 83, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:03'),
  (53, 84, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:03'),
  (54, 85, '120.00', '350.00', '100.00', '5.00', '2022-03-04 02:48:03');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE `users` (
    `id` int(11) NOT NULL,
    `emp_id` int(11) NOT NULL,
    `fullname` varchar(255) NOT NULL,
    `username` varchar(255) NOT NULL,
    `password` varchar(255) NOT NULL,
    `init_pass` varchar(255) NOT NULL,
    `timestamps` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `deductions`
  --
  ALTER TABLE `deductions`
    ADD PRIMARY KEY (`id`),
    ADD KEY `emp_id` (`emp_id`);
  
  --
  -- Indexes for table `employees`
  --
  ALTER TABLE `employees`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `reg_manhour`
  --
  ALTER TABLE `reg_manhour`
    ADD PRIMARY KEY (`id`),
    ADD KEY `emp_id` (`emp_id`);
  
  --
  -- Indexes for table `reg_pay`
  --
  ALTER TABLE `reg_pay`
    ADD PRIMARY KEY (`id`),
    ADD KEY `emp_id` (`emp_id`);
  
  --
  -- Indexes for table `reg_rate`
  --
  ALTER TABLE `reg_rate`
    ADD PRIMARY KEY (`id`),
    ADD KEY `emp_id` (`emp_id`);
  
  --
  -- Indexes for table `sales_manhour`
  --
  ALTER TABLE `sales_manhour`
    ADD PRIMARY KEY (`id`),
    ADD KEY `emp_id` (`emp_id`);
  
  --
  -- Indexes for table `sales_pay`
  --
  ALTER TABLE `sales_pay`
    ADD PRIMARY KEY (`id`),
    ADD KEY `emp_id` (`emp_id`);
  
  --
  -- Indexes for table `sales_rate`
  --
  ALTER TABLE `sales_rate`
    ADD PRIMARY KEY (`id`),
    ADD KEY `emp_id` (`emp_id`);
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `deductions`
  --
  ALTER TABLE `deductions`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=349;
  
  --
  -- AUTO_INCREMENT for table `employees`
  --
  ALTER TABLE `employees`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=86;
  
  --
  -- AUTO_INCREMENT for table `reg_manhour`
  --
  ALTER TABLE `reg_manhour`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=295;
  
  --
  -- AUTO_INCREMENT for table `reg_pay`
  --
  ALTER TABLE `reg_pay`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=295;
  
  --
  -- AUTO_INCREMENT for table `reg_rate`
  --
  ALTER TABLE `reg_rate`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;
  
  --
  -- AUTO_INCREMENT for table `sales_manhour`
  --
  ALTER TABLE `sales_manhour`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;
  
  --
  -- AUTO_INCREMENT for table `sales_pay`
  --
  ALTER TABLE `sales_pay`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;
  
  --
  -- AUTO_INCREMENT for table `sales_rate`
  --
  ALTER TABLE `sales_rate`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;
  
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  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 */;
  