--
-- Host: localhost    Database: pixlogix_hrm
-- ------------------------------------------------------


--
-- Table structure for table `album_category`
--

CREATE TABLE `album_category` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `album_category`
--


--
-- Table structure for table `album_images`
--

CREATE TABLE `album_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `album_id` bigint(20) unsigned NOT NULL,
  `image_title` varchar(255) NOT NULL,
  `image_file` text NOT NULL,
  `sort_order` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `album_images_album_id_foreign` (`album_id`),
  CONSTRAINT `album_images_album_id_foreign` FOREIGN KEY (`album_id`) REFERENCES `albums` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `album_images`
--


--
-- Table structure for table `albums`
--

CREATE TABLE `albums` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `added_date` date NOT NULL,
  `thumbnail_image_file` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `albums_category_id_foreign` (`category_id`),
  CONSTRAINT `albums_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `album_category` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `albums`
--


--
-- Table structure for table `attendance_logs`
--

CREATE TABLE `attendance_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `entry_type` varchar(255) DEFAULT NULL,
  `check_in` datetime DEFAULT NULL,
  `check_out` datetime DEFAULT NULL,
  `working_hours` time DEFAULT NULL,
  `time_difference` time DEFAULT NULL,
  `break_hours` time DEFAULT NULL,
  `break_timings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`break_timings`)),
  `todos` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`todos`)),
  `status` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `attendance_logs_employee_id_foreign` (`employee_id`),
  CONSTRAINT `attendance_logs_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attendance_logs`
--


--
-- Table structure for table `badges`
--

CREATE TABLE `badges` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `badges`
--


--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `source` varchar(255) NOT NULL,
  `employee_id` bigint(20) unsigned NOT NULL,
  `status` tinyint(1) NOT NULL,
  `updated_by` varchar(255) NOT NULL,
  `created_by` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clients_employee_id_foreign` (`employee_id`),
  CONSTRAINT `clients_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clients`
--


--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `parent` bigint(20) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` VALUES (1,'Human Resource',1,0,'2022-10-04 04:39:15','2022-10-04 04:39:15'),(2,'Technical HR',1,1,'2022-11-01 03:50:53','2022-11-01 03:50:53'),(3,'Development',1,0,'2022-11-04 19:42:15','2022-11-04 19:42:15'),(4,'Frontend + UI/UX',1,0,'2022-11-16 00:50:11','2022-11-16 00:50:11'),(6,'Magento',1,3,'2022-11-16 05:14:35','2022-11-21 21:36:41'),(8,'Frontend',1,0,'2023-08-09 21:16:36','2023-08-09 21:16:36'),(9,'UI/UX',1,0,'2023-08-09 21:17:10','2023-08-09 21:17:10');

--
-- Table structure for table `designations`
--

CREATE TABLE `designations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `designations`
--

INSERT INTO `designations` VALUES (1,'Web Developer',1,'2022-10-04 05:06:15','2022-10-04 05:06:15'),(2,'HR',1,'2022-10-13 07:31:54','2022-10-13 07:31:54'),(3,'Web Designer',1,'2022-11-16 01:08:57','2022-11-25 23:41:35'),(4,'Team Leader',1,'2022-11-17 00:46:49','2022-11-17 00:46:49'),(5,'Project Manager',1,'2022-11-17 00:47:03','2022-11-17 00:47:03'),(8,'Recruiter',1,'2022-11-28 21:15:49','2022-11-28 21:15:49'),(9,'Admin',1,'2023-04-11 05:03:32','2023-04-11 05:03:32');

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `action` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` longtext NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` VALUES (1,'site.created','Your Site has been Created Successfully | {name}','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n<tr>\r\n   <td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n      <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n<tr>\r\n   <td>\r\n      <p>Dear {user_name},</p>\r\n      <p>We are pleased to inform you that your new website has been successfully created!</p>\r\n\r\n      <p>Below are the details of your account:</p>\r\n      <p><strong>Email ID:</strong> {user_email_id}</p>\r\n\r\n       <p>You can set password by clicking following button,</p>\r\n      <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n         <tbody>\r\n            <tr>\r\n               <td align=\"left\">\r\n                  <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                     <tbody>\r\n                        <tr>\r\n                           <td> <a href=\"{reset_password_link}\" target=\"_blank\" style=\"display: inline-block; font-weight: 500; line-height: 1.5; color: #ffffff; text-align: center; vertical-align: middle; cursor: pointer; user-select: none; background-color: #009EF7; border: 1px solid #009EF7; padding: 7px 20px; font-size: 14px; border-radius: 6px; font-family: \'Poppins\', sans-serif; text-decoration: none !important;\">Set Password</a> </td>\r\n                        </tr>\r\n                     </tbody>\r\n                  </table>\r\n               </td>\r\n            </tr>\r\n         </tbody>\r\n      </table>\r\n   </td>\r\n</tr>\r\n<tr>\r\n   <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n</tr>',1,'2022-12-05 23:53:28','2023-05-26 22:02:08'),(2,'site.updated','Your Website Has Been Updated | {name}','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n\r\n<tr>\r\n<td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n    <tr>\r\n                  <td>\r\n                    <p>Dear {user_name},</p>\r\n                    <p>We wanted to inform you that updates have been made to your website.</p>                        \r\n                    <p>Please take a moment to review the changes and ensure everything meets your expectations.</p>\r\n                  </td>\r\n                </tr>\r\n    <tr>\r\n        <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n    </tr>',1,'2022-12-05 23:53:44','2023-05-26 01:29:15'),(3,'site.deleted','Site Removal Alert | {name}','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n\r\n<tr>\r\n<td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n    \r\n\r\n    <tr>\r\n                  <td>\r\n                    <p>Dear {user_name},</p>\r\n                    <p>This mail is to inform you that the company named <strong>\"{name}\"</strong> has been removed from our organization.</p>                        \r\n                  </td>\r\n                </tr>\r\n    \r\n    <tr>\r\n        <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n    </tr>',1,'2022-12-05 23:54:00','2023-05-26 01:31:17'),(4,'user.created','Your HRM account is created | {site_name}','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n\r\n<tr>\r\n<td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n    \r\n     <tr>\r\n                <td class=\"mail-title\" align=\"left\" valign=\"top\">\r\n                    <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><P>Dear {full_name},</p></span>\r\n                </td>\r\n            </tr>\r\n            <tr>\r\n                <td class=\"hide-mobi\" style=\"height:10px;\" height=\"10\"></td>\r\n            </tr>\r\n            <tr>\r\n                <td class=\"mail-title\" align=\"left\" valign=\"top\">\r\n                    <h3 style=\"font-weight:600; color:#181C32; line-height:1.2;  font-size:22px; font-family:\'Poppins\', sans-serif; margin:0;\">Welcome to {site_name}</h3>\r\n                </td>\r\n            </tr>\r\n            <tr>\r\n                <td class=\"hide-mobi\" style=\"height:12px;\" height=\"12\"></td>\r\n            </tr>\r\n            <tr>\r\n                <td align=\"center\" valign=\"top\">\r\n                    <p style=\"margin:0; padding:0; font-family:\'Poppins\', sans-serif; font-weight:normal; color:#181C32; font-size:14px; text-align:left;\">Your HRM account is successfully created. You are requested to add all the necessary information to get your account verified. Once done, your account creation process will be completed.</p>\r\n                </td>\r\n            </tr>\r\n            <tr>\r\n                <td class=\"hide-mobi\" style=\"height:8px;\" height=\"8\"></td>\r\n            </tr>\r\n            <tr>\r\n                <td align=\"center\" valign=\"top\">\r\n                    <p style=\"margin:0; padding:0; font-family:\'Poppins\', sans-serif; font-weight:normal; color:#181C32; font-size:14px; text-align:left;\">For any questions/assistance, please contact the HR Manager.\r\n</p>\r\n                </td>\r\n            </tr>\r\n            <tr>\r\n                <td class=\"hide-mobi\" style=\"height:8px;\" height=\"8\"></td>\r\n            </tr>\r\n            <tr>\r\n                <td align=\"center\" valign=\"top\">\r\n                    <p style=\"margin:0; padding:0; font-family:\'Poppins\', sans-serif; font-weight:normal; color:#181C32; font-size:14px; text-align:left;\">\r\n</p>\r\n                </td>\r\n            </tr>\r\n\r\n            <tr>\r\n                <td align=\"center\" valign=\"top\">\r\n                    <img src=\"{{ asset(\'/assets/media/email/mailer-image.png) }}\" alt=\"\" style=\"max-width:100%; width:214px; margin:0 auto; padding:0;\" class=\"clock-picture\" />\r\n                </td>\r\n            </tr>\r\n\r\n    <tr>\r\n        <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n    </tr>',0,'2022-12-05 23:55:04','2023-05-29 20:51:46'),(5,'user.suspended','Account Suspended | {site_name}','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n\r\n<tr>\r\n<td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n\r\n<tr>\r\n                                        <td>\r\n                                            <p>Your acccount has beed suspended by the Organization due to some reasons. please contact you management for more details.</p>\r\n                                        </td>\r\n                                    </tr>\r\n\r\n<tr>\r\n    <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n</tr>',1,'2022-12-05 23:55:38','2023-05-26 02:29:55'),(6,'user.updated','Account Update | {site_name}','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n\r\n<tr>\r\n<td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n<tr>\r\n                <td class=\"mail-title\" align=\"left\" valign=\"top\">\r\n                    <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><P>Dear {full_name},</p></span>\r\n                </td>\r\n            </tr>\r\n<tr>\r\n                                        <td>\r\n                                            <p style=\"margin:0px;\">Your account has been updated. Please log in to your account using your existing credentials to check and verify the account privileges.</p>\r\n                                        </td>\r\n                                    </tr>\r\n\r\n<tr>\r\n    <td class=\"hide-mobi\" style=\"height:10px;\" height=\"10\"></td>\r\n</tr>',1,'2022-12-05 23:55:52','2023-05-29 20:53:21'),(7,'user.password_updated','Account Password Update Notification | {site_name}','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n\r\n<tr>\r\n<td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n\r\n<tr>\r\n                                        <td>\r\n                                            <p>Dear {name},</p>\r\n                                            <p>Your account password has been recently updated. Please review your account status to ensure everything is in order.</p>\r\n                                            <p> Click here to check your account status. </p>\r\n                                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                                                <tbody>\r\n                                                    <tr>\r\n                                                        <td align=\"left\">\r\n                                                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\"\r\n                                                                cellspacing=\"0\">\r\n                                                                <tbody>\r\n                                                                    <tr>\r\n                                                                        <td><a href=\"http://hrm.pixlogixservice.com/\"\r\n                                                                                target=\"_blank\" style=\"display: inline-block; font-weight: 500; line-height: 1.5; color: #ffffff; text-align: center; vertical-align: middle; cursor: pointer; user-select: none; background-color: #009EF7; border: 1px solid #009EF7; padding: 7px 20px; font-size: 14px; border-radius: 6px; font-family: \'Poppins\', sans-serif; text-decoration: none !important;\">Login</a> </td>\r\n                                                                    </tr>\r\n                                                                </tbody>\r\n                                                            </table>\r\n                                                        </td>\r\n                                                    </tr>\r\n                                                </tbody>\r\n                                            </table>\r\n                                        </td>\r\n                                    </tr>\r\n\r\n<tr>\r\n    <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n</tr>',1,'2022-12-05 23:56:15','2023-05-25 05:39:11'),(8,'employee.created','Your HRM account is created - Pixlogix HRM','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n    <tr>\r\n        <td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n            <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n\r\n            <tr>\r\n          <td class=\"mail-title\" align=\"left\" valign=\"top\">\r\n            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">\r\n              <P>Dear {full_name}, </p>\r\n            </span>\r\n          </td>\r\n        </tr>\r\n        <tr>\r\n          <td class=\"hide-mobi\" style=\"height:10px;\" height=\"10\"></td>\r\n        </tr>\r\n        <tr>\r\n          <td class=\"mail-title\" align=\"left\" valign=\"top\">\r\n            <h3 style=\"font-weight:600; color:#181C32; line-height:1.2;  font-size:22px; font-family:\'Poppins\', sans-serif; margin:0;\">Welcome to Pixlogix Infotech Pvt. Ltd.</h3>\r\n          </td>\r\n        </tr><tr>\r\n          <td class=\"hide-mobi\" style=\"height:12px;\" height=\"12\"></td>\r\n        </tr>\r\n        <tr>\r\n          <td align=\"center\" valign=\"top\">\r\n            <p style=\"margin:0; padding:0; font-family:sans-serif; font-weight:normal; color:#181C32; font-size:14px; text-align:left;\">Your HRM account is successfully created. You are requested to add all the necessary information to get your account verified. Once done, your account creation process will be completed.</p>\r\n          </td>\r\n        </tr>\r\n        <tr>\r\n          <td class=\"hide-mobi\" style=\"height:8px;\" height=\"8\"></td>\r\n        </tr>\r\n        <tr>\r\n          <td align=\"center\" valign=\"top\">\r\n            <p style=\"margin:0; padding:0; font-family:sans-serif; font-weight:normal; color:#181C32; font-size:14px; text-align:left;\">For any questions/assistance, please contact the HR Manager. </p>\r\n          </td>\r\n        </tr>\r\n        <tr>\r\n          <td class=\"hide-mobi\" style=\"height:8px;\" height=\"8\"></td>\r\n        </tr>\r\n        <tr>\r\n          <td>\r\n            <p style=\"margin:0; padding:0; font-family:sans-serif; font-weight:normal; color:#181C32; font-size:14px; text-align:left;\">You can now login and access the services.</p>\r\n          </td>\r\n        </tr>\r\n        <tr>\r\n          <td class=\"hide-mobi\" style=\"height:8px;\" height=\"8\"></td>\r\n        </tr>\r\n        <tbody>\r\n                                                    <tr>\r\n                                                        <td align=\"left\">\r\n                                                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\"\r\n                                                                cellspacing=\"0\">\r\n                                                                <tbody>\r\n                                                                    <tr>\r\n                      <td>\r\n                        <a href=\"http://hrm.pixlogixservice.com/password/reset\" target=\"_blank\" style=\"display: inline-block; font-weight: 500; line-height: 1.5; color: #ffffff; text-align: center; vertical-align: middle; cursor: pointer; user-select: none; background-color: #009EF7; border: 1px solid #009EF7; padding: 7px 20px; font-size: 14px; border-radius: 6px; font-family: \'Poppins\', sans-serif; text-decoration: none !important;\">Set Password</a>\r\n                      </td>\r\n                    </tr>\r\n                                                                </tbody>\r\n                                                            </table>\r\n                                                        </td>\r\n                                                    </tr>\r\n                                                </tbody>\r\n\r\n            \r\n                    <tr>\r\n          <td class=\"hide-mobi\" style=\"height:8px;\" height=\"8\"></td>\r\n        </tr>\r\n        <tr>\r\n          <td align=\"center\" valign=\"top\">\r\n            <p style=\"margin:0; padding:0; font-family:\'Poppins\', sans-serif; font-weight:normal; color:#181C32; font-size:14px; text-align:left;\"></p>\r\n          </td>\r\n        </tr>\r\n            <tr>\r\n                <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n            </tr>',1,'2022-12-05 23:56:36','2023-05-26 01:58:53'),(9,'employee.updated','Your HRM account is updated - Pixlogix HRM','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n                                    \r\n                                            <tr>\r\n                                                <td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n                                                    <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >                    <tr>\r\n                                                            <td class=\"mail-title\" align=\"left\" valign=\"top\">\r\n                                                                <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><P>Dear {full_name},</p></span>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:10px;\" height=\"10\"></td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:12px;\" height=\"12\"></td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td align=\"center\" valign=\"top\">\r\n                                                                <p style=\"margin:0; padding:0;  font-weight:normal; color:#181C32; font-size:14px; text-align:left;\">Your HRM account has been updated. Please check it by logging into your account.</p>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:8px;\" height=\"8\"></td>\r\n                                                        </tr>\r\n							<tr>\r\n                                                            <td align=\"center\" valign=\"top\">\r\n                                                                <p style=\"margin:0; padding:0; font-weight:normal; color:#181C32; font-size:14px; text-align:left;\">For any questions/assistance, please contact the HR Manager.\r\n</p>\r\n                                                            </td>\r\n                                                        </tr>\r\n						<tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:8px;\" height=\"8\"></td>\r\n                                            <tr>',1,'2022-12-09 22:43:08','2023-05-18 23:16:43'),(10,'leave.created','Your leave request is sent - Pixlogix HRM','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n                                    \r\n                                            <tr>\r\n                                                <td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n                                                    <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n                                                        <tr>\r\n                                                            <td class=\"mail-title\" align=\"left\" valign=\"top\">\r\n                                                                <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">Hi {full_name},</span>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:10px;\" height=\"10\"></td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:8px;\" height=\"8\"></td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td align=\"center\" valign=\"top\">\r\n                                                                <p style=\"margin:0; padding:0; font-family:\'Poppins\', sans-serif; font-weight:normal; color:#747784; font-size:14px; text-align:left;\">Your leave request is sent successfully. Please find below the details of your request:</p>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td align=\"left\" valign=\"top\">\r\n                                                                <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" >\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/date.png\" width=\"15\" height=\"15\" height=\"16\"  alt=\"\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Date of leave:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{from_date}<br/>{to_date}</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"border-bottom:1px solid #EEEEEE; height: 6px; \"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"height: 6px;\"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/reason.png\" alt=\"\"  width=\"15\" height=\"17\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Reason of leave:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{reason}</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"border-bottom:1px solid #EEEEEE; height: 6px; \"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"height: 6px;\"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/reason.png\" alt=\"\"  width=\"15\" height=\"17\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Type of leave:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{type} Leave</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n                                                                    \r\n                                                                    \r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"border-bottom:1px solid #EEEEEE; height: 6px; \"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"height: 6px;\"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/leave-days.png\" width=\"15\" height=\"16\" alt=\"\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Leave Days:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{total}</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"border-bottom:1px solid #EEEEEE; height: 6px; \"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"height: 6px;\"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/advance-inform.png\" width=\"15\" height=\"15\" alt=\"\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Advance informed:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{is_informed}</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n                                                                </table>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n                                                        </tr>\r\n                                                       <tr>\r\n                                                            <td align=\"center\" valign=\"top\">\r\n                                                                <p style=\"margin:0; padding:0; font-family:\'Poppins\', sans-serif; font-weight:normal; color:#747784; font-size:14px; text-align:left;\">For any questions/assistance, please contact your Manager or the HR Manager.</p>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n                                                        </tr>',1,'2022-12-19 06:43:59','2023-05-20 04:07:03'),(11,'leave.approved','Your leave request is approved- Pixlogix HRM','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n                                    \r\n                                            <tr>\r\n                                                <td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n                                                    <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n                                                        <tr>\r\n                                                            <td class=\"mail-title\" align=\"left\" valign=\"top\">\r\n                                                                <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">Hi {full_name},</span>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:10px;\" height=\"10\"></td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:8px;\" height=\"8\"></td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td align=\"center\" valign=\"top\">\r\n                                                                <p style=\"margin:0; padding:0; font-family:\'Poppins\', sans-serif; font-weight:normal; color:#747784; font-size:14px; text-align:left;\">Your leave request is approved. Please find below the details of your request:</p>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td align=\"left\" valign=\"top\">\r\n                                                                <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" >\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/date.png\" width=\"15\" height=\"15\" height=\"16\"  alt=\"\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Date of leave:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{from_date}<br/>{to_date}</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"border-bottom:1px solid #EEEEEE; height: 6px; \"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"height: 6px;\"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/reason.png\" alt=\"\"  width=\"15\" height=\"17\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Reason of leave:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{reason}</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"border-bottom:1px solid #EEEEEE; height: 6px; \"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"height: 6px;\"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/reason.png\" alt=\"\"  width=\"15\" height=\"17\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Type of leave:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{type} Leave</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n                                                                    \r\n                                                                    \r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"border-bottom:1px solid #EEEEEE; height: 6px; \"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"height: 6px;\"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/leave-days.png\" width=\"15\" height=\"16\" alt=\"\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Leave Days:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{total}</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"border-bottom:1px solid #EEEEEE; height: 6px; \"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"height: 6px;\"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/advance-inform.png\" width=\"15\" height=\"15\" alt=\"\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Advance informed:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{is_informed}</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"border-bottom:1px solid #EEEEEE; height: 6px; \"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"height: 6px;\"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/advance-inform.png\" width=\"15\" height=\"15\" alt=\"\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Reason for approval:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{comment}</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n                                                                </table>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n                                                        </tr>\r\n                                                       <tr>\r\n                                                            <td align=\"center\" valign=\"top\">\r\n                                                                <p style=\"margin:0; padding:0; font-family:\'Poppins\', sans-serif; font-weight:normal; color:#747784; font-size:14px; text-align:left;\">For any questions/assistance, please contact your Manager or the HR Manager.</p>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n                                                        </tr>',1,'2022-12-19 06:44:13','2023-04-07 22:25:05'),(12,'leave.denied','Your leave request is rejected - Pixlogix HRM','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n                                    \r\n                                            <tr>\r\n                                                <td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n                                                    <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n                                                        <tr>\r\n                                                            <td class=\"mail-title\" align=\"left\" valign=\"top\">\r\n                                                                <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">Hi {full_name},</span>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:10px;\" height=\"10\"></td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:8px;\" height=\"8\"></td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td align=\"center\" valign=\"top\">\r\n                                                                <p style=\"margin:0; padding:0; font-family:\'Poppins\', sans-serif; font-weight:normal; color:#747784; font-size:14px; text-align:left;\">Your leave request is rejected. Please find below the details of your request:</p>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td align=\"left\" valign=\"top\">\r\n                                                                <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" >\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/date.png\" width=\"15\" height=\"15\" height=\"16\"  alt=\"\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Date of leave:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{from_date}<br/>{to_date}</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"border-bottom:1px solid #EEEEEE; height: 6px; \"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"height: 6px;\"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/reason.png\" alt=\"\"  width=\"15\" height=\"17\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Reason of leave:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{reason}</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"border-bottom:1px solid #EEEEEE; height: 6px; \"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"height: 6px;\"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/reason.png\" alt=\"\"  width=\"15\" height=\"17\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Type of leave:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{type} Leave</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n                                                                    \r\n                                                                    \r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"border-bottom:1px solid #EEEEEE; height: 6px; \"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"height: 6px;\"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/leave-days.png\" width=\"15\" height=\"16\" alt=\"\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Leave Days:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{total}</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"border-bottom:1px solid #EEEEEE; height: 6px; \"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"height: 6px;\"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/advance-inform.png\" width=\"15\" height=\"15\" alt=\"\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Advance informed:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{is_informed}</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"border-bottom:1px solid #EEEEEE; height: 6px; \"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"height: 6px;\"></td>\r\n                                                                    </tr>\r\n                                                                    <tr>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><img src=\"http://64.4.160.99/hrm/img/advance-inform.png\" width=\"15\" height=\"15\" alt=\"\" style=\"width:14px;  margin:0 8px 0 0; padding:0;\" class=\"reason-picture\" />Reason for rejection:</span>\r\n                                                                        </td>\r\n                                                                        <td align=\"left\" valign=\"top\">\r\n                                                                            <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{comment}</span>\r\n                                                                        </td>\r\n                                                                    </tr>\r\n                                                                </table>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n                                                        </tr>\r\n                                                       <tr>\r\n                                                            <td align=\"center\" valign=\"top\">\r\n                                                                <p style=\"margin:0; padding:0; font-family:\'Poppins\', sans-serif; font-weight:normal; color:#747784; font-size:14px; text-align:left;\">For any questions/assistance, please contact your Manager or the HR Manager.</p>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n                                                        </tr>',1,'2022-12-19 06:44:28','2023-04-07 22:24:35'),(13,'site.updaterequest','Request to Update Website | {site_name}','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n<tr>\r\n<td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n <tr>\r\n     <td>\r\n         <p>Dear Admin,</p>\r\n         <p><strong>{name}</strong> has requested website update, below are the details.</p>\r\n     </td>\r\n </tr>\r\n <tr>\r\n    <td align=\"left\" valign=\"top\">\r\n       <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n          <tbody>\r\n             <tr>\r\n                <td align=\"left\" valign=\"top\">\r\n                   <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">Email: </span>\r\n                </td>\r\n                <td align=\"left\" valign=\"top\" style=\"padding-left:10px;\">\r\n                   <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{email}</span>\r\n                </td>\r\n             </tr>\r\n             <tr>\r\n                    <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"border-bottom:1px solid #EEEEEE; height: 6px; \"></td>\r\n                </tr>\r\n                <tr>\r\n                    <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"height: 6px;\"></td>\r\n                </tr>\r\n             <tr>\r\n                <td align=\"left\" valign=\"top\">\r\n                   <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">Site: </span>\r\n                </td>\r\n                <td align=\"left\" valign=\"top\" style=\"padding-left:10px;\">\r\n                   <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{site_name}</span>\r\n                </td>\r\n             </tr>\r\n             <tr>\r\n                    <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"border-bottom:1px solid #EEEEEE; height: 6px; \"></td>\r\n                </tr>\r\n                <tr>\r\n                    <td class=\"hide-mobi\" height=\"6\" colspan=\"2\" style=\"height: 6px;\"></td>\r\n                </tr>\r\n             <tr>\r\n                <td align=\"left\" valign=\"top\">\r\n                   <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">Message: </span>\r\n                </td>\r\n                <td align=\"left\" valign=\"top\" style=\"padding-left:10px;\">\r\n                   <span style=\"font-weight:normal; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\">{message}</span>\r\n                </td>\r\n             </tr>\r\n          </tbody>\r\n       </table>\r\n    </td>\r\n </tr>\r\n <tr>\r\n     <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n </tr>',1,'2023-01-13 10:58:11','2023-05-26 22:36:44'),(14,'hr_request.created','Request By: {employee_name} | {site_name}','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n    <tr>\r\n        <td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n            <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n\r\n            <tr>\r\n                                        <td>\r\n                                            <p>Dear {to_name},</p>\r\n                                            <p><strong>You received new {subject} request from {name}, please check your dashboard!</strong></p>\r\n                                             <p> {message}</p>\r\n                                            \r\n                                        </td>\r\n                                    </tr>\r\n            <tr>\r\n                <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n            </tr>',1,'2023-03-05 08:32:22','2023-05-25 04:58:31'),(15,'employee.morningrequest','Reminder: Preserve Your Morning Schedule | {site_name}','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n                                    \r\n                                            <tr>\r\n                                                <td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n                                                    <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n                                                        <tr>\r\n                                                            <td class=\"mail-title\" align=\"left\" valign=\"top\">\r\n                                                                <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><p>Dear {name},</p></span>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:10px;\" height=\"10\"></td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td align=\"center\" valign=\"top\">\r\n                                                                <p style=\"margin:0; padding:0; font-family:\'Poppins\', sans-serif; font-weight:normal; color:#181C32; font-size:14px; text-align:left;\">Please remember the importance of maintaining your morning schedule to ensure smooth operations and effective teamwork. Arriving on time and following your designated schedule allows us to maximize productivity and deliver outstanding results.</p>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:8px;\" height=\"8\"></td>\r\n                                                        </tr>\r\n														<tr>\r\n                                                            <td align=\"center\" valign=\"top\">\r\n                                                                <p style=\"margin:0; padding:0; font-family:\'Poppins\', sans-serif; font-weight:normal; color:#181C32; font-size:14px; text-align:left;\">If you have any questions or need assistance, please reach out to your manager or the HR Manager.\r\n																</p>\r\n                                                            </td>\r\n                                                        </tr>\r\n<tr>\r\n                    <td style=\"height:35px\" height=\"35\"></td>\r\n                </tr>',1,'2023-04-07 06:38:00','2023-05-26 02:01:31'),(16,'employee.newpassword','Reset Password Notification - Pixlogix HRM','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n                                    \r\n                                            <tr>\r\n                                                <td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n                                                    <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n                                                        <tr>\r\n                                                            <td class=\"mail-title\" align=\"left\" valign=\"top\">\r\n                                                                <span style=\"font-weight:600; color:#181C32; font-size:14px; font-family:\'Poppins\', sans-serif;\"><P>Hii there,</p></span>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:10px;\" height=\"10\"></td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td align=\"center\" valign=\"top\">\r\n                                                                <p style=\"margin:0; padding:0; font-family:\'Poppins\', sans-serif; font-weight:normal; color:#181C32; font-size:14px; text-align:left;\">Please note that employees are expected to arrive on or before the official organization timings. Please maintain your morning schedule accordingly.</p>\r\n                                                            </td>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <td class=\"hide-mobi\" style=\"height:8px;\" height=\"8\"></td>\r\n                                                        </tr>\r\n														<tr>\r\n                                                            <td align=\"center\" valign=\"top\">\r\n                                                                <p style=\"margin:0; padding:0; font-family:\'Poppins\', sans-serif; font-weight:normal; color:#181C32; font-size:14px; text-align:left;\">For any questions/assistance, please contact your Manager or the HR Manager.\r\n																</p>\r\n                                                            </td>\r\n                                                        </tr>',0,'2023-05-03 05:28:49','2023-05-18 23:07:17'),(17,'site.requestApproved','Site Update Request : Approved','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n\r\n<tr>\r\n<td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n    <tr>\r\n                  <td>\r\n                    <p>Dear {name},</p>\r\n                    <p>We\'re excited to share that your recent Site Update Request has been granted approval. The changes you proposed have been thoroughly evaluated and are in perfect harmony with our aims to elevate user experience and enhance the functionality of our website and the changes you have are completed.</p>                        \r\n                    <p>Here are the details of your approved request:</p>\r\n\r\n                    <p>Requested Changes: {message}</p>\r\n                  </td>\r\n                </tr>\r\n    <tr>\r\n        <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n    </tr>',1,'2023-08-10 21:05:46','2023-09-21 23:38:22'),(18,'site.requestRejected','Site Update Request : Rejected','<table class=\"table460\" width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#fff\" style=\"mso-table-rspace:0pt; mso-table-lspace:0pt; border-collapse:collapse;\">\r\n\r\n<tr>\r\n<td valign=\"top\" align=\"center\" style=\"padding:32px 32px 0;\">\r\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\r\n    <tr>\r\n                  <td>\r\n                    <p>Dear {name},</p>\r\n                    <p>We regret to inform you that your site update request has not been approved. This decision is based on considerations of compatibility, feasibility, and strategic alignment. We greatly appreciate your initiative and recommend reviewing the feedback provided to enhance future proposals.</p>                       \r\n\r\n                     <p>Thank you for your ongoing support.</p>\r\n                  </td>\r\n                </tr>\r\n    <tr>\r\n        <td class=\"hide-mobi\" style=\"height:35px;\" height=\"35\"></td>\r\n    </tr>',1,'2023-08-11 01:18:21','2023-09-22 01:06:52');

--
-- Table structure for table `employee_documents`
--

CREATE TABLE `employee_documents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `document_id` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `created_by` varchar(255) NOT NULL,
  `updated_by` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `employee_documents_employee_id_foreign` (`employee_id`),
  CONSTRAINT `employee_documents_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `employee_documents`
--


--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `employee_id` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `middle_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `gender` varchar(255) NOT NULL,
  `department_id` bigint(20) unsigned NOT NULL,
  `sub_department_id` bigint(20) unsigned NOT NULL,
  `designation_id` bigint(20) unsigned NOT NULL,
  `level_id` bigint(20) unsigned NOT NULL,
  `report_to` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`report_to`)),
  `role` bigint(20) unsigned NOT NULL,
  `profile_image` text DEFAULT NULL,
  `joining_date` date NOT NULL,
  `company_phone` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `employees_employee_id_unique` (`employee_id`),
  UNIQUE KEY `employees_email_unique` (`email`),
  UNIQUE KEY `employees_slug_unique` (`slug`),
  KEY `employees_department_id_foreign` (`department_id`),
  KEY `employees_sub_department_id_foreign` (`sub_department_id`),
  KEY `employees_designation_id_foreign` (`designation_id`),
  KEY `employees_level_id_foreign` (`level_id`),
  CONSTRAINT `employees_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `employees_designation_id_foreign` FOREIGN KEY (`designation_id`) REFERENCES `designations` (`id`),
  CONSTRAINT `employees_level_id_foreign` FOREIGN KEY (`level_id`) REFERENCES `levels` (`id`),
  CONSTRAINT `employees_sub_department_id_foreign` FOREIGN KEY (`sub_department_id`) REFERENCES `departments` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `employees`
--


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `feedback_points`
--

CREATE TABLE `feedback_points` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `template_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feedback_points`
--


--
-- Table structure for table `feedback_templates`
--

CREATE TABLE `feedback_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `clone_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `department_id` varchar(255) NOT NULL,
  `role_id` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feedback_templates`
--


--
-- Table structure for table `feedbackfilladmin`
--

CREATE TABLE `feedbackfilladmin` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `feedpoint_id` int(11) NOT NULL,
  `self_feedback` varchar(255) NOT NULL,
  `rm_feedback` varchar(255) NOT NULL,
  `management_feedback` varchar(255) NOT NULL,
  `self_feedback_id` int(11) NOT NULL,
  `rm_feedback_id` int(11) NOT NULL,
  `management_feedback_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feedbackfilladmin`
--


--
-- Table structure for table `forget_attendances`
--

CREATE TABLE `forget_attendances` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `attendance_log_id` bigint(20) unsigned NOT NULL,
  `entry_type` varchar(255) NOT NULL,
  `check_in` datetime DEFAULT NULL,
  `check_out` datetime DEFAULT NULL,
  `working_hours` time DEFAULT NULL,
  `time_difference` time DEFAULT NULL,
  `break_hours` time DEFAULT NULL,
  `break_timings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`break_timings`)),
  `reason` text NOT NULL,
  `comment` text DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `approved` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `forget_attendances_employee_id_foreign` (`employee_id`),
  KEY `forget_attendances_attendance_log_id_foreign` (`attendance_log_id`),
  CONSTRAINT `forget_attendances_attendance_log_id_foreign` FOREIGN KEY (`attendance_log_id`) REFERENCES `attendance_logs` (`id`),
  CONSTRAINT `forget_attendances_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `forget_attendances`
--


--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gallery`
--


--
-- Table structure for table `gallerycat`
--

CREATE TABLE `gallerycat` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gallerycat`
--


--
-- Table structure for table `h_r_requests`
--

CREATE TABLE `h_r_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from_employee_id` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `to_employee_id` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `h_r_requests`
--


--
-- Table structure for table `holidays`
--

CREATE TABLE `holidays` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `holidays`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `kra_category`
--

CREATE TABLE `kra_category` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kra_category`
--


--
-- Table structure for table `kra_feedback`
--

CREATE TABLE `kra_feedback` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `point_id` bigint(20) unsigned DEFAULT NULL,
  `feedback_type` varchar(255) NOT NULL,
  `employee_id` bigint(20) unsigned DEFAULT NULL,
  `feedback_points` text NOT NULL,
  `status` smallint(6) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `kra_feedback_point_id_foreign` (`point_id`),
  KEY `kra_feedback_employee_id_foreign` (`employee_id`),
  CONSTRAINT `kra_feedback_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE SET NULL,
  CONSTRAINT `kra_feedback_point_id_foreign` FOREIGN KEY (`point_id`) REFERENCES `kra_points` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kra_feedback`
--


--
-- Table structure for table `kra_points`
--

CREATE TABLE `kra_points` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `template_id` bigint(20) unsigned DEFAULT NULL,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `point_rating` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `kra_points_template_id_foreign` (`template_id`),
  KEY `kra_points_category_id_foreign` (`category_id`),
  CONSTRAINT `kra_points_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `kra_category` (`id`) ON DELETE SET NULL,
  CONSTRAINT `kra_points_template_id_foreign` FOREIGN KEY (`template_id`) REFERENCES `kra_templates` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kra_points`
--


--
-- Table structure for table `kra_templates`
--

CREATE TABLE `kra_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `clone_of` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `departments` varchar(255) NOT NULL,
  `role_level` int(11) NOT NULL,
  `status` smallint(6) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kra_templates`
--


--
-- Table structure for table `kraadmin`
--

CREATE TABLE `kraadmin` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` int(11) NOT NULL,
  `self_disc` varchar(255) NOT NULL,
  `rm_disc` varchar(255) NOT NULL,
  `manage_disc` varchar(255) NOT NULL,
  `self_rate` varchar(255) NOT NULL,
  `rm_rate` varchar(255) NOT NULL,
  `manage_rate` varchar(255) NOT NULL,
  `self_id` int(11) NOT NULL,
  `rm_id` int(11) NOT NULL,
  `manage_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kraadmin`
--


--
-- Table structure for table `kraadminfill`
--

CREATE TABLE `kraadminfill` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` int(11) NOT NULL,
  `self_disc` varchar(255) NOT NULL,
  `rm_disc` varchar(255) NOT NULL,
  `manage_disc` varchar(255) NOT NULL,
  `self_rate` varchar(255) NOT NULL,
  `rm_rate` varchar(255) NOT NULL,
  `manage_rate` varchar(255) NOT NULL,
  `self_id` int(11) NOT NULL,
  `rm_id` int(11) NOT NULL,
  `manage_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kraadminfill`
--


--
-- Table structure for table `krafilladmin`
--

CREATE TABLE `krafilladmin` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` int(11) NOT NULL,
  `point_id` int(11) NOT NULL,
  `self_disc` varchar(255) NOT NULL,
  `rm_disc` varchar(255) NOT NULL,
  `management_disc` varchar(255) NOT NULL,
  `self_rate` varchar(255) NOT NULL,
  `rm_rate` varchar(255) NOT NULL,
  `management_rate` varchar(255) NOT NULL,
  `self_id` int(11) NOT NULL,
  `rm_id` int(11) NOT NULL,
  `management_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `krafilladmin`
--


--
-- Table structure for table `leaves`
--

CREATE TABLE `leaves` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `from_date` date NOT NULL,
  `to_date` date NOT NULL,
  `type` varchar(255) NOT NULL,
  `day_type` varchar(255) NOT NULL,
  `paid_count` double(8,2) NOT NULL,
  `total` double(8,2) NOT NULL,
  `reason` text NOT NULL,
  `is_informed` tinyint(1) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `leaves_employee_id_foreign` (`employee_id`),
  CONSTRAINT `leaves_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `leaves`
--


--
-- Table structure for table `levels`
--

CREATE TABLE `levels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `levels`
--

INSERT INTO `levels` VALUES (2,'Senior',1,'2022-10-13 06:49:37','2022-11-04 18:41:33'),(4,'Junior',1,'2022-10-13 07:30:56','2022-11-04 18:38:23'),(6,'Team Leader',1,'2022-11-16 01:15:23','2022-11-18 23:52:28'),(10,'Trainee',1,'2022-11-28 21:20:57','2022-11-28 21:20:57'),(12,'Intern',1,'2022-11-28 21:21:30','2022-11-28 21:21:30');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2022_08_07_074223_create_sites_table',1),(4,'2022_08_08_203730_create_permission_tables',1),(5,'2022_08_09_175729_create_departments_table',1),(6,'2022_08_09_200934_create_designations_table',1),(7,'2022_08_09_200951_create_levels_table',1),(8,'2022_10_02_165540_create_site_requests_table',1),(9,'2022_11_04_100748_add_status_column_to_sites_table',2),(32,'2022_11_28_012636_create_subscription_plans_table',3),(33,'2022_12_04_122631_create_email_templates_table',4),(34,'2023_01_03_220311_create_site_update_requests_table',5),(60,'2019_08_19_000000_create_failed_jobs_table',6),(61,'2019_12_14_000001_create_personal_access_tokens_table',6),(62,'2022_08_09_204114_create_employees_table',6),(63,'2022_08_12_005051_create_personal_infos_table',6),(64,'2022_08_15_113500_add_slug_to_employees_table',6),(65,'2022_08_15_143958_create_badges_table',6),(66,'2022_08_15_202939_create_holidays_table',6),(67,'2022_08_16_160530_create_timelines_table',6),(68,'2022_08_27_085254_create_h_r_requests_table',6),(69,'2022_10_22_211256_add_certificate_column_to_timelines_table',6),(70,'2022_10_25_091603_create_employee_documents_table',6),(71,'2022_10_30_140444_add_company_phone_column_to_employees_table',6),(72,'2022_11_05_192238_create_attendance_logs_table',6),(73,'2022_11_09_023502_create_forget_attendances_table',6),(74,'2022_11_10_151930_create_leaves_table',6),(75,'2022_11_11_002618_create_partial_leaves_table',6),(76,'2022_11_11_141616_create_clients_table',6),(77,'2022_11_11_165224_create_projects_table',6),(78,'2022_11_12_114400_create_todos_table',6),(79,'2022_11_12_153510_create_worklogs_table',6),(80,'2022_11_12_153525_create_worklog_tasks_table',6),(81,'2022_11_15_172648_create_site_infos_table',6),(82,'2022_11_15_195008_add_total_and_paid_column_to_leaves_table',6),(83,'2023_02_27_113524_create_kra_templates_table',6),(84,'2023_03_01_103756_create_kra_category',6),(85,'2023_03_03_010811_create_krapoints_table',6),(86,'2023_03_06_155648_create_kraadminfill_table',6),(87,'2023_03_07_160046_create_kraadmin_table',6),(88,'2023_03_07_171848_rollback',6),(89,'2023_03_07_172324_drop_kraadminfill_table',6),(90,'2023_03_07_172650_create_krafilladmin_table',6),(91,'2023_03_12_165430_create_feedbackfilladmin_table',6),(92,'2023_03_13_123746_create_gallerycat_table',6),(93,'2023_03_13_123759_create_gallery_table',6),(94,'2023_04_18_134453_add_role_id_to_employees',6),(95,'2023_04_25_121915_add_role_id_to_employees',6),(96,'2023_04_25_124345_create_notification_table',6),(97,'2023_06_06_163256_news_category',6),(98,'2023_06_06_163308_news_list',6),(99,'2023_06_06_174742_album_category',6),(100,'2023_06_06_174850_albums',6),(101,'2023_06_06_175310_album_images',6),(102,'2023_06_19_183527_kra_feedback',6),(103,'2023_06_26_125200_add_old_existing_worklog_table',6),(104,'2023_06_30_180340_add_permitted_user_column_to_project_table',6),(105,'2023_08_28_155924_create_feedback_templates_table',6),(106,'2024_12_18_132038_create_jobs_table',7);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--

INSERT INTO `model_has_permissions` VALUES (31,'App\\Models\\User',1),(32,'App\\Models\\User',41),(33,'App\\Models\\User',5),(33,'App\\Models\\User',40);

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(1,'App\\Models\\User',5),(1,'App\\Models\\User',40),(1,'App\\Models\\User',41),(2,'App\\Models\\User',2),(2,'App\\Models\\User',7),(2,'App\\Models\\User',8),(2,'App\\Models\\User',9),(2,'App\\Models\\User',10),(2,'App\\Models\\User',14),(2,'App\\Models\\User',17),(2,'App\\Models\\User',18),(2,'App\\Models\\User',19),(2,'App\\Models\\User',20),(2,'App\\Models\\User',29),(2,'App\\Models\\User',30),(2,'App\\Models\\User',31),(2,'App\\Models\\User',32),(2,'App\\Models\\User',36),(2,'App\\Models\\User',37),(2,'App\\Models\\User',42),(2,'App\\Models\\User',44),(2,'App\\Models\\User',45),(2,'App\\Models\\User',46),(2,'App\\Models\\User',47),(2,'App\\Models\\User',51),(2,'App\\Models\\User',53),(2,'App\\Models\\User',54),(2,'App\\Models\\User',55),(2,'App\\Models\\User',56),(2,'App\\Models\\User',57),(2,'App\\Models\\User',60),(2,'App\\Models\\User',64),(2,'App\\Models\\User',65),(2,'App\\Models\\User',73),(2,'App\\Models\\User',74),(2,'App\\Models\\User',75),(2,'App\\Models\\User',77),(2,'App\\Models\\User',78),(2,'App\\Models\\User',79),(2,'App\\Models\\User',80),(2,'App\\Models\\User',81),(2,'App\\Models\\User',82),(2,'App\\Models\\User',83),(2,'App\\Models\\User',84),(2,'App\\Models\\User',90),(2,'App\\Models\\User',96),(2,'App\\Models\\User',124),(2,'App\\Models\\User',126),(2,'App\\Models\\User',136),(2,'App\\Models\\User',160),(2,'App\\Models\\User',168),(2,'App\\Models\\User',170),(2,'App\\Models\\User',188),(2,'App\\Models\\User',195),(2,'App\\Models\\User',237),(2,'App\\Models\\User',241),(2,'App\\Models\\User',242),(2,'App\\Models\\User',256),(2,'App\\Models\\User',259),(2,'App\\Models\\User',265),(2,'App\\Models\\User',316),(2,'App\\Models\\User',319),(2,'App\\Models\\User',328),(2,'App\\Models\\User',337),(2,'App\\Models\\User',338),(2,'App\\Models\\User',340),(2,'App\\Models\\User',344),(2,'App\\Models\\User',347),(2,'App\\Models\\User',349),(2,'App\\Models\\User',351),(2,'App\\Models\\User',356),(2,'App\\Models\\User',360),(2,'App\\Models\\User',361),(2,'App\\Models\\User',362),(2,'App\\Models\\User',363),(2,'App\\Models\\User',364),(2,'App\\Models\\User',365),(2,'App\\Models\\User',366),(2,'App\\Models\\User',367),(2,'App\\Models\\User',368),(2,'App\\Models\\User',369),(2,'App\\Models\\User',370),(2,'App\\Models\\User',371),(2,'App\\Models\\User',372),(2,'App\\Models\\User',373),(2,'App\\Models\\User',374),(2,'App\\Models\\User',375),(2,'App\\Models\\User',386),(2,'App\\Models\\User',387),(2,'App\\Models\\User',388),(2,'App\\Models\\User',389),(2,'App\\Models\\User',407),(2,'App\\Models\\User',408),(2,'App\\Models\\User',409),(2,'App\\Models\\User',410),(2,'App\\Models\\User',411),(2,'App\\Models\\User',412),(2,'App\\Models\\User',413),(2,'App\\Models\\User',414),(2,'App\\Models\\User',415),(2,'App\\Models\\User',416),(2,'App\\Models\\User',417),(2,'App\\Models\\User',418),(2,'App\\Models\\User',419),(2,'App\\Models\\User',420),(2,'App\\Models\\User',421),(2,'App\\Models\\User',422),(2,'App\\Models\\User',423),(2,'App\\Models\\User',424),(2,'App\\Models\\User',425),(2,'App\\Models\\User',426),(2,'App\\Models\\User',427),(2,'App\\Models\\User',428),(2,'App\\Models\\User',429),(2,'App\\Models\\User',430),(2,'App\\Models\\User',431),(2,'App\\Models\\User',432),(2,'App\\Models\\User',433),(2,'App\\Models\\User',434),(2,'App\\Models\\User',439),(2,'App\\Models\\User',440),(2,'App\\Models\\User',441),(2,'App\\Models\\User',442),(2,'App\\Models\\User',446),(3,'App\\Models\\User',3),(3,'App\\Models\\User',4),(3,'App\\Models\\User',12),(3,'App\\Models\\User',13),(3,'App\\Models\\User',16),(3,'App\\Models\\User',43),(3,'App\\Models\\User',49),(3,'App\\Models\\User',58),(3,'App\\Models\\User',61),(3,'App\\Models\\User',63),(3,'App\\Models\\User',66),(3,'App\\Models\\User',67),(3,'App\\Models\\User',68),(3,'App\\Models\\User',69),(3,'App\\Models\\User',72),(3,'App\\Models\\User',76),(3,'App\\Models\\User',91),(3,'App\\Models\\User',92),(3,'App\\Models\\User',93),(3,'App\\Models\\User',94),(3,'App\\Models\\User',95),(3,'App\\Models\\User',103),(3,'App\\Models\\User',106),(3,'App\\Models\\User',118),(3,'App\\Models\\User',121),(3,'App\\Models\\User',123),(3,'App\\Models\\User',125),(3,'App\\Models\\User',127),(3,'App\\Models\\User',128),(3,'App\\Models\\User',129),(3,'App\\Models\\User',130),(3,'App\\Models\\User',131),(3,'App\\Models\\User',138),(3,'App\\Models\\User',139),(3,'App\\Models\\User',140),(3,'App\\Models\\User',141),(3,'App\\Models\\User',142),(3,'App\\Models\\User',143),(3,'App\\Models\\User',144),(3,'App\\Models\\User',145),(3,'App\\Models\\User',146),(3,'App\\Models\\User',147),(3,'App\\Models\\User',148),(3,'App\\Models\\User',149),(3,'App\\Models\\User',150),(3,'App\\Models\\User',151),(3,'App\\Models\\User',152),(3,'App\\Models\\User',156),(3,'App\\Models\\User',157),(3,'App\\Models\\User',158),(3,'App\\Models\\User',161),(3,'App\\Models\\User',162),(3,'App\\Models\\User',163),(3,'App\\Models\\User',172),(3,'App\\Models\\User',174),(3,'App\\Models\\User',175),(3,'App\\Models\\User',176),(3,'App\\Models\\User',177),(3,'App\\Models\\User',178),(3,'App\\Models\\User',179),(3,'App\\Models\\User',180),(3,'App\\Models\\User',181),(3,'App\\Models\\User',182),(3,'App\\Models\\User',183),(3,'App\\Models\\User',184),(3,'App\\Models\\User',185),(3,'App\\Models\\User',186),(3,'App\\Models\\User',187),(3,'App\\Models\\User',189),(3,'App\\Models\\User',190),(3,'App\\Models\\User',191),(3,'App\\Models\\User',192),(3,'App\\Models\\User',193),(3,'App\\Models\\User',194),(3,'App\\Models\\User',196),(3,'App\\Models\\User',197),(3,'App\\Models\\User',198),(3,'App\\Models\\User',199),(3,'App\\Models\\User',200),(3,'App\\Models\\User',205),(3,'App\\Models\\User',214),(3,'App\\Models\\User',215),(3,'App\\Models\\User',218),(3,'App\\Models\\User',219),(3,'App\\Models\\User',220),(3,'App\\Models\\User',221),(3,'App\\Models\\User',222),(3,'App\\Models\\User',223),(3,'App\\Models\\User',224),(3,'App\\Models\\User',225),(3,'App\\Models\\User',226),(3,'App\\Models\\User',227),(3,'App\\Models\\User',229),(3,'App\\Models\\User',230),(3,'App\\Models\\User',231),(3,'App\\Models\\User',232),(3,'App\\Models\\User',233),(3,'App\\Models\\User',234),(3,'App\\Models\\User',235),(3,'App\\Models\\User',238),(3,'App\\Models\\User',245),(3,'App\\Models\\User',246),(3,'App\\Models\\User',251),(3,'App\\Models\\User',252),(3,'App\\Models\\User',254),(3,'App\\Models\\User',266),(3,'App\\Models\\User',268),(3,'App\\Models\\User',269),(3,'App\\Models\\User',271),(3,'App\\Models\\User',315),(3,'App\\Models\\User',321),(3,'App\\Models\\User',350),(3,'App\\Models\\User',357),(3,'App\\Models\\User',358),(3,'App\\Models\\User',376),(3,'App\\Models\\User',381),(3,'App\\Models\\User',391),(3,'App\\Models\\User',393),(3,'App\\Models\\User',394),(3,'App\\Models\\User',395),(3,'App\\Models\\User',397),(3,'App\\Models\\User',398),(3,'App\\Models\\User',401),(3,'App\\Models\\User',402),(3,'App\\Models\\User',404),(3,'App\\Models\\User',405),(4,'App\\Models\\User',6),(4,'App\\Models\\User',11),(4,'App\\Models\\User',15),(4,'App\\Models\\User',21),(4,'App\\Models\\User',22),(4,'App\\Models\\User',23),(4,'App\\Models\\User',24),(4,'App\\Models\\User',25),(4,'App\\Models\\User',26),(4,'App\\Models\\User',27),(4,'App\\Models\\User',33),(4,'App\\Models\\User',34),(4,'App\\Models\\User',35),(4,'App\\Models\\User',38),(4,'App\\Models\\User',39),(4,'App\\Models\\User',50),(4,'App\\Models\\User',52),(4,'App\\Models\\User',59),(4,'App\\Models\\User',70),(4,'App\\Models\\User',71),(4,'App\\Models\\User',99),(4,'App\\Models\\User',101),(4,'App\\Models\\User',104),(4,'App\\Models\\User',133),(4,'App\\Models\\User',135),(4,'App\\Models\\User',201),(4,'App\\Models\\User',202),(4,'App\\Models\\User',236),(4,'App\\Models\\User',243),(4,'App\\Models\\User',263),(4,'App\\Models\\User',331),(4,'App\\Models\\User',334),(4,'App\\Models\\User',345),(4,'App\\Models\\User',346),(4,'App\\Models\\User',450),(14,'App\\Models\\User',132),(14,'App\\Models\\User',134),(14,'App\\Models\\User',240),(14,'App\\Models\\User',260),(14,'App\\Models\\User',264),(14,'App\\Models\\User',322),(14,'App\\Models\\User',325),(14,'App\\Models\\User',330),(14,'App\\Models\\User',335),(14,'App\\Models\\User',343),(14,'App\\Models\\User',377),(15,'App\\Models\\User',62),(15,'App\\Models\\User',154),(15,'App\\Models\\User',203),(15,'App\\Models\\User',228),(15,'App\\Models\\User',324),(15,'App\\Models\\User',326),(16,'App\\Models\\User',119),(16,'App\\Models\\User',336),(16,'App\\Models\\User',382),(17,'App\\Models\\User',98),(17,'App\\Models\\User',122),(17,'App\\Models\\User',137),(17,'App\\Models\\User',244),(17,'App\\Models\\User',270),(17,'App\\Models\\User',323),(17,'App\\Models\\User',327),(17,'App\\Models\\User',329),(17,'App\\Models\\User',333),(17,'App\\Models\\User',342),(17,'App\\Models\\User',353),(17,'App\\Models\\User',380),(17,'App\\Models\\User',383),(18,'App\\Models\\User',100),(18,'App\\Models\\User',102),(18,'App\\Models\\User',318),(18,'App\\Models\\User',332),(18,'App\\Models\\User',379),(19,'App\\Models\\User',113),(19,'App\\Models\\User',117),(19,'App\\Models\\User',204),(19,'App\\Models\\User',206),(19,'App\\Models\\User',213),(19,'App\\Models\\User',320),(19,'App\\Models\\User',341),(20,'App\\Models\\User',28),(20,'App\\Models\\User',97),(20,'App\\Models\\User',105),(20,'App\\Models\\User',107),(20,'App\\Models\\User',108),(20,'App\\Models\\User',109),(20,'App\\Models\\User',110),(20,'App\\Models\\User',111),(20,'App\\Models\\User',112),(20,'App\\Models\\User',114),(20,'App\\Models\\User',115),(20,'App\\Models\\User',116),(20,'App\\Models\\User',120),(20,'App\\Models\\User',173),(20,'App\\Models\\User',207),(20,'App\\Models\\User',208),(20,'App\\Models\\User',209),(20,'App\\Models\\User',210),(20,'App\\Models\\User',211),(20,'App\\Models\\User',218),(20,'App\\Models\\User',255),(20,'App\\Models\\User',317),(20,'App\\Models\\User',339),(20,'App\\Models\\User',348),(20,'App\\Models\\User',352),(20,'App\\Models\\User',378),(20,'App\\Models\\User',390),(20,'App\\Models\\User',392),(20,'App\\Models\\User',396),(20,'App\\Models\\User',406);

--
-- Table structure for table `news_category`
--

CREATE TABLE `news_category` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `bg_color` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news_category`
--


--
-- Table structure for table `news_list`
--

CREATE TABLE `news_list` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `date` text NOT NULL,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `description` text NOT NULL,
  `added_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `news_list_category_id_foreign` (`category_id`),
  CONSTRAINT `news_list_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `news_category` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news_list`
--


--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from_id` int(11) NOT NULL,
  `to_id` int(11) NOT NULL,
  `message` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `reference` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification`
--


--
-- Table structure for table `partial_leaves`
--

CREATE TABLE `partial_leaves` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `date` date NOT NULL,
  `from` datetime NOT NULL,
  `to` datetime NOT NULL,
  `reason` text NOT NULL,
  `is_informed` tinyint(1) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `partial_leaves_employee_id_foreign` (`employee_id`),
  CONSTRAINT `partial_leaves_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partial_leaves`
--


--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--

INSERT INTO `password_resets` VALUES ('testsitecreate818@gmail.com','$2y$10$Uo7tcFIxpKKNeFYUNoA33e5I0zhECQSEavP7Rg3TFz5DaqvATacse','2023-08-10 04:06:52'),('jeel.pixlogix@gmail.com','$2y$10$QmB1skWOUdrZ32RUehIpaO20ULzwmpebiM2w4Oc1fyIFJGk2QFTSG','2023-08-10 04:07:54'),('niket.pixlogix@gmail.com','$2y$10$CUe9Mx6jFpeSvWh.gMYLQOqq5A23LS8YhSpDKM/nMnFW55vLAI1Ki','2023-08-10 04:08:25'),('meet@pixlogix.com','$2y$10$VfWngvdSpnsD4RUsOjWDQ.quT23.zC8tgZ5ZHzSogWcUZQ7Y1vZ36','2023-08-10 04:10:42'),('prashant@pixlogix.com','$2y$10$FUy0tRk.CHSOzGAfE9iRf.SsidVMFp1WkNSFdY0b5GUjN.0T499rC','2023-08-10 04:11:03'),('pavas@pixlogix.com','$2y$10$VadVpsl3gA0a3TYXH5/w0.WT5TMIk1YiteDTdcIFETlMX8NPLG6Jm','2023-08-10 04:16:52'),('mahima.pixlogix@gmail.com','$2y$10$SgWbdZKb1JkbRi1ItDKTn.E.fQ9FOv0yYWLBgV0iRFrCI4T.lnRaC','2023-09-05 03:16:05'),('kartikkachan9586@gmail.com','$2y$10$7exRiyp/OoP6pnIhaVLHweeq4lrLAGM6hKlE3/zxrjcY6X9IS7oOC','2023-10-09 20:55:42'),('a@outlook.com','$2y$10$ek2GwvB0Hb13Erk3atLUF.9jQN8x8pjPrPw6lpcoXMLcbKW6lCdhG','2024-01-02 22:26:35'),('cajir93715@bitofee.com','$2y$10$QquPsPZObR34LL9hFymWSOfWY4MeoXR6GWixlSrKp2bbe.3Cf7Vum','2024-02-07 22:32:10'),('hardik.rathod.pixlogix@gmail.com','$2y$10$N3TBgvW9TeKPijeHJqCig.g78YBfPhrUDKLFVfuc0R53o1lIF4jOe','2024-02-13 03:44:00'),('kartik@pixlogix.com','$2y$10$aJb3BfHWurBhxm2zpWm0uegMb8YEVZvUlV7w5ZPsjpOq6r1vnoz0C','2025-01-08 03:31:44'),('nishi@pixlogix.com','$2y$10$3oHaIq8Ywtn7wW.5JExnAesnQFmzWf.525xbQoUQJFbuAtFnEEuMq','2025-06-14 00:09:17');

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL,
  `deletable` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'Create Role','web','Role',1,'2022-10-04 04:52:58','2022-10-04 04:52:58'),(2,'View Role','web','Role',1,'2022-10-04 04:53:04','2022-10-04 04:53:04'),(3,'Edit Role','web','Role',1,'2022-10-04 04:53:15','2022-10-04 04:53:15'),(4,'Delete Role','web','Role',1,'2022-10-04 04:53:23','2022-10-04 04:53:23'),(5,'Create Department','web','Department',1,'2022-10-04 04:53:33','2022-10-04 04:53:33'),(6,'View Department','web','Department',1,'2022-10-04 04:53:46','2022-10-04 04:53:46'),(7,'Edit Department','web','Department',1,'2022-10-04 04:53:53','2022-10-04 04:53:53'),(8,'Delete Department','web','Department',1,'2022-10-04 04:54:01','2022-10-04 04:54:10'),(9,'Create Designation','web','Designation',1,'2022-10-04 04:54:22','2022-10-04 04:54:22'),(10,'View Designation','web','Designation',1,'2022-10-04 04:54:33','2022-10-04 04:54:33'),(11,'Edit Designation','web','Designation',1,'2022-10-04 04:54:40','2022-10-04 04:54:40'),(12,'Delete Designation','web','Designation',1,'2022-10-04 04:54:49','2022-10-04 04:54:49'),(13,'Create Level','web','Level',1,'2022-10-04 04:54:56','2022-10-04 04:54:56'),(14,'View Level','web','Level',1,'2022-10-04 04:55:07','2022-10-04 04:55:07'),(15,'Edit Level','web','Level',1,'2022-10-04 04:55:16','2022-10-04 04:55:16'),(16,'Delete Level','web','Level',1,'2022-10-04 04:55:22','2022-10-04 04:55:22'),(17,'Create Employee','web','Employee',1,'2022-10-04 04:55:29','2022-10-04 04:55:29'),(18,'View Employee','web','Employee',1,'2022-10-04 04:55:36','2022-10-04 04:55:36'),(19,'Create Achievement','web','Achievement',1,'2022-10-04 06:47:23','2022-10-04 06:47:23'),(20,'View Achievement','web','Achievement',1,'2022-10-04 06:47:32','2022-10-04 06:47:32'),(22,'Create Badge','web','Badge',1,'2022-10-04 06:58:54','2022-10-04 06:58:54'),(23,'View Badge','web','Badge',1,'2022-10-04 06:59:01','2022-10-04 06:59:01'),(24,'Edit Badge','web','Badge',1,'2022-10-04 06:59:12','2022-10-04 06:59:12'),(25,'Delete Badge','web','Badge',1,'2022-10-04 06:59:22','2022-10-04 06:59:22'),(26,'Create Holiday','web','Holiday',1,'2022-10-04 09:42:29','2022-10-04 09:42:29'),(27,'View Holiday','web','Holiday',1,'2022-10-04 09:42:36','2022-10-04 09:42:36'),(28,'Edit Holiday','web','Holiday',1,'2022-10-04 09:42:43','2022-10-04 09:42:43'),(29,'Delete Holiday','web','Holiday',1,'2022-10-04 09:42:52','2022-10-04 09:42:52'),(30,'Edit Employee','web','Employee',1,'2022-10-24 05:30:19','2022-10-24 05:30:19'),(31,'All','web','Manage',1,'2022-12-02 03:25:51','2022-12-03 03:25:58'),(32,'Manage Users','web','Manage',1,'2022-11-05 23:24:14','2022-11-05 23:24:14'),(33,'Manage Sites','web','Manage',1,'2022-11-05 23:25:28','2022-11-05 23:25:28'),(39,'View Attendance','web','Attendance',1,'2022-11-10 01:59:19','2022-11-10 01:59:19'),(41,'View Forget Attendance','web','Forget Attendance',1,'2022-11-15 02:37:14','2022-11-15 02:37:14'),(42,'Edit Worklog','web','Worklog',1,'2022-11-15 02:37:31','2022-11-15 02:37:31'),(43,'View Worklog','web','Worklog',1,'2022-11-15 02:37:31','2022-11-15 02:37:31'),(44,'Edit Worklog Request','web','Worklog Request',1,'2022-11-15 02:38:03','2022-11-15 02:38:03'),(45,'View Worklog Request','web','Worklog Request',1,'2022-11-15 02:38:03','2022-11-15 02:38:03'),(47,'View Leave','web','Leave',1,'2022-11-15 02:39:43','2022-11-15 02:39:43'),(48,'View Report','web','Report',1,'2022-11-15 02:40:02','2022-11-15 02:40:02'),(49,'Create Client','web','Client',1,'2022-11-15 02:40:32','2022-11-15 02:40:32'),(50,'Edit Client','web','Client',1,'2022-11-15 02:40:32','2022-11-15 02:40:32'),(51,'View Client','web','Client',1,'2022-11-15 02:40:32','2022-11-15 02:40:32'),(52,'Delete Client','web','Client',1,'2022-11-15 02:40:32','2022-11-15 02:40:32'),(53,'Create Project','web','Project',1,'2022-11-15 02:40:46','2022-11-15 02:40:46'),(54,'Edit Project','web','Project',1,'2022-11-15 02:40:46','2022-11-15 02:40:46'),(55,'View Project','web','Project',1,'2022-11-15 02:40:47','2022-11-15 02:40:47'),(56,'Delete Project','web','Project',1,'2022-11-15 02:40:47','2022-11-15 02:40:47'),(58,'View Site Options','web','Site Options',1,'2022-11-16 03:39:49','2022-11-16 03:39:49'),(59,'View Recent Project','web','Recent Project',1,'2022-11-21 03:20:19','2022-11-21 03:20:19'),(60,'Edit Site Options','web','Site Options',1,'2022-11-21 03:26:47','2022-11-21 03:26:47'),(61,'Edit Achievement','web','Achievement',1,'2022-11-25 21:12:57','2022-11-25 21:12:57'),(67,'Create Email Template','web','Email Template',1,'2022-12-05 22:53:13','2022-12-05 22:53:13'),(68,'Edit Email Template','web','Email Template',1,'2022-12-05 22:57:06','2022-12-05 22:57:06'),(69,'View Email Template','web','Email Template',1,'2022-12-05 22:57:06','2022-12-05 22:57:06'),(72,'Create 54545465465465454','web','54545465465465454',1,'2023-06-29 21:52:25','2023-06-29 21:52:25'),(73,'View 54545465465465454','web','54545465465465454',1,'2023-06-29 21:52:25','2023-06-29 21:52:25'),(75,'Edit 1','web','1',1,'2023-06-29 22:05:03','2023-06-29 22:05:03'),(76,'Edit Edit','web','Edit',1,'2023-06-30 04:13:19','2023-06-30 04:13:19'),(90,'Delete Achievement','web','Achievement',1,'2023-08-01 01:34:03','2023-08-01 01:34:03'),(92,'Create KRA','web','KRA',1,'2024-03-06 22:19:04','2024-03-06 22:19:04'),(93,'Edit KRA','web','KRA',1,'2024-03-06 22:19:04','2024-03-06 22:19:04'),(94,'Delete KRA','web','KRA',1,'2024-03-06 22:19:04','2024-03-06 22:19:04'),(95,'Create Goals','web','Goals',1,'2024-03-06 22:19:40','2024-03-06 22:19:40'),(96,'Edit Goals','web','Goals',1,'2024-03-06 22:19:40','2024-03-06 22:19:40'),(97,'Delete Goals','web','Goals',1,'2024-03-06 22:19:40','2024-03-06 22:19:40'),(98,'Create Feedbacks','web','Feedbacks',1,'2024-03-06 22:19:55','2024-03-06 22:19:55'),(99,'Edit Feedbacks','web','Feedbacks',1,'2024-03-06 22:19:55','2024-03-06 22:19:55'),(100,'Delete Feedbacks','web','Feedbacks',1,'2024-03-06 22:19:55','2024-03-06 22:19:55'),(101,'Create News','web','News',1,'2024-03-06 22:20:09','2024-03-06 22:20:09'),(102,'Edit News','web','News',1,'2024-03-06 22:20:09','2024-03-06 22:20:09'),(103,'Delete News','web','News',1,'2024-03-06 22:20:09','2024-03-06 22:20:09'),(104,'Create Gallery','web','Gallery',1,'2024-03-06 22:20:29','2024-03-06 22:20:29'),(105,'Edit Gallery','web','Gallery',1,'2024-03-06 22:20:29','2024-03-06 22:20:29'),(106,'Delete Gallery','web','Gallery',1,'2024-03-06 22:20:29','2024-03-06 22:20:29'),(107,'View KRA','web','KRA',1,'2024-03-06 22:20:41','2024-03-06 22:20:41'),(108,'View Goals','web','Goals',1,'2024-03-06 22:20:49','2024-03-06 22:20:49'),(109,'View Feedbacks','web','Feedbacks',1,'2024-03-06 22:21:00','2024-03-06 22:21:00'),(110,'View News','web','News',1,'2024-03-06 22:21:08','2024-03-06 22:21:08'),(111,'View Gallery','web','Gallery',1,'2024-03-06 22:21:17','2024-03-06 22:21:17'),(112,'Create Partial Leave','web','Partial Leave',1,'2024-03-07 00:54:36','2024-03-07 00:54:36'),(113,'Edit Partial Leave','web','Partial Leave',1,'2024-03-07 00:54:36','2024-03-07 00:54:36'),(114,'View Partial Leave','web','Partial Leave',1,'2024-03-07 00:54:36','2024-03-07 00:54:36'),(115,'Delete Partial Leave','web','Partial Leave',1,'2024-03-07 00:54:36','2024-03-07 00:54:36');

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--


--
-- Table structure for table `personal_infos`
--

CREATE TABLE `personal_infos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `personal_email` varchar(255) DEFAULT NULL,
  `marital_status` varchar(255) DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `contact_no` varchar(255) DEFAULT NULL,
  `about_me` text DEFAULT NULL,
  `linked_in` varchar(255) DEFAULT NULL,
  `current_address` text DEFAULT NULL,
  `permanent_address` text DEFAULT NULL,
  `blood_group` varchar(255) DEFAULT NULL,
  `hobbies` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`hobbies`)),
  `emergency_contact` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`emergency_contact`)),
  `bank_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`bank_details`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personal_infos_employee_id_foreign` (`employee_id`),
  CONSTRAINT `personal_infos_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_infos`
--


--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `project_id` varchar(255) NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `employee_id` bigint(20) unsigned NOT NULL,
  `delivery_date` date NOT NULL,
  `bench_hours` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`bench_hours`)),
  `total_bench_hours` int(11) NOT NULL DEFAULT 0,
  `given_hours` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`given_hours`)),
  `total_given_hours` int(11) NOT NULL DEFAULT 0,
  `project_health` int(11) NOT NULL DEFAULT 100,
  `sow` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`sow`)),
  `status` varchar(255) NOT NULL DEFAULT 'Pending',
  `updated_by` varchar(255) NOT NULL,
  `created_by` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `projects_client_id_foreign` (`client_id`),
  KEY `projects_employee_id_foreign` (`employee_id`),
  CONSTRAINT `projects_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
  CONSTRAINT `projects_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `projects`
--


--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (1,2),(2,2),(3,2),(4,2),(5,2),(5,4),(6,2),(6,4),(7,2),(7,4),(8,2),(9,2),(9,4),(10,2),(10,4),(11,2),(11,4),(12,2),(13,2),(13,4),(14,2),(14,4),(15,2),(15,4),(16,2),(17,2),(17,4),(18,2),(18,3),(18,4),(18,15),(18,16),(19,2),(19,4),(20,2),(20,3),(20,4),(20,15),(20,16),(22,2),(22,4),(22,20),(23,2),(23,3),(23,4),(23,15),(23,16),(23,20),(24,2),(24,4),(24,20),(25,2),(25,20),(26,2),(26,4),(27,2),(27,3),(27,4),(27,15),(27,16),(28,2),(28,4),(29,2),(29,4),(30,2),(30,3),(30,4),(30,16),(39,2),(39,4),(39,15),(41,2),(41,4),(42,2),(42,3),(42,4),(42,16),(43,2),(43,3),(43,4),(43,14),(43,15),(43,16),(44,2),(44,3),(44,4),(44,16),(45,2),(45,3),(45,4),(45,14),(45,15),(45,16),(47,2),(47,4),(47,14),(47,15),(48,2),(48,4),(48,14),(48,15),(49,2),(49,4),(49,14),(49,15),(50,2),(50,4),(50,14),(50,15),(51,2),(51,4),(51,14),(51,15),(52,2),(52,4),(52,14),(52,15),(53,2),(53,4),(53,14),(53,15),(54,2),(54,4),(54,14),(54,15),(55,2),(55,3),(55,4),(55,14),(55,15),(55,16),(56,2),(56,4),(56,14),(56,15),(58,2),(58,4),(58,14),(59,2),(59,4),(59,15),(60,2),(60,4),(61,2),(61,4),(67,2),(67,4),(68,2),(68,4),(69,2),(69,4),(90,2),(90,3),(90,4),(90,16),(101,2),(101,4),(102,2),(102,4),(103,2),(103,4),(104,2),(104,4),(105,2),(105,4),(106,2),(106,4),(110,2),(110,4),(110,16),(111,2),(111,4),(111,16),(112,4),(113,4),(114,4),(115,4);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `deletable` tinyint(1) NOT NULL DEFAULT 1,
  `role_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Super Admin','web',0,1,'2022-10-04 04:39:15','2022-10-04 04:39:15'),(2,'Admin','web',0,2,'2022-10-04 04:39:15','2022-10-04 04:39:15'),(3,'Employee','web',0,3,'2022-10-04 04:39:15','2022-10-04 04:39:15'),(4,'HR','web',0,4,'2022-10-04 08:20:20','2022-10-04 08:20:20'),(14,'Project Manager','web',0,14,'2022-11-16 00:11:09','2022-11-16 00:11:09'),(15,'Team Leader','web',0,15,'2022-11-17 00:50:42','2022-11-17 00:50:42'),(16,'Test Role','web',0,16,'2022-11-19 00:00:00','2022-11-19 00:00:00'),(17,'HR Pixlogix','web',1,0,'2023-06-29 22:06:06','2023-06-29 22:06:06'),(18,'Project Manager Pixlogix','web',1,0,'2023-07-14 21:16:44','2023-07-14 21:16:51'),(19,'Team Leader Pixlogix','web',1,0,'2023-08-18 21:03:19','2023-08-18 21:03:19'),(20,'Employee Pixlogix','web',1,0,'2023-08-18 21:03:19','2023-08-18 21:03:19');

--
-- Table structure for table `site_infos`
--

CREATE TABLE `site_infos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`value`)),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_infos`
--


--
-- Table structure for table `site_requests`
--

CREATE TABLE `site_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `site_name` varchar(255) NOT NULL,
  `first_name` text NOT NULL,
  `middle_name` text DEFAULT NULL,
  `last_name` text NOT NULL,
  `phone` text NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `message` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_requests`
--


--
-- Table structure for table `site_update_requests`
--

CREATE TABLE `site_update_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `site_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_update_requests`
--

INSERT INTO `site_update_requests` VALUES (11,54,'Plan Upgrade','Need to upgrade Plan',239,NULL,'2023-05-11 04:24:58','2023-05-11 04:24:58'),(15,59,'Upgrade Plan','Hello, We need to upgrade our site plan.',253,NULL,'2023-05-18 02:25:35','2023-05-18 02:25:35'),(16,63,'Plan Upgrade','We want to upgrade site plan',262,NULL,'2023-05-19 01:20:41','2023-05-19 01:20:41'),(17,63,'Plan Upgrade','We want to upgrade site plan',262,NULL,'2023-05-19 01:21:39','2023-05-19 01:21:39'),(47,112,'Plan Upgrade','We want to upgrade site plan from silver to Gold',359,NULL,'2023-05-26 03:14:23','2023-05-26 03:14:23'),(59,39,'Checking where the email goes','If anyone receives this, please take a screenshot & sent to me (HR)',96,NULL,'2023-07-26 06:07:30','2023-08-11 01:09:54');

--
-- Table structure for table `sites`
--

CREATE TABLE `sites` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `slug` text NOT NULL,
  `db_name` varchar(255) NOT NULL,
  `db_password` varchar(255) DEFAULT NULL,
  `db_user` varchar(255) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `message` longtext DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sites_db_name_unique` (`db_name`)
) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sites`
--

INSERT INTO `sites` VALUES (1,'HRM',2,'hrm','pixlogix_37720hrm','$2y$10$xRyG0lIfAUuyQvWs4xooROWLrPpWm5o1vf7WKqSf1vRSEbolUwiZ.','pixlogix_37720hrm',2,NULL,1,'2022-10-04 04:50:47','2023-01-02 05:20:39'),(39,'Pixlogix HRM',96,'pixlogix-hrm','pixlogix_87402pixlogix_hrm','Kj3QAo8c','pixlogix_87402pixlogix_hrm',2,NULL,1,'2023-02-02 22:11:30','2023-05-24 22:13:17'),(113,'Kyle Copeland',360,'veniam-deleniti-eum','pixlogix_93189kyle_copeland','axWg0LOD','pixlogix_93189kyle_copeland',1,NULL,1,'2023-05-26 21:12:20','2023-05-26 21:12:21'),(114,'Hu Barnes',361,'quibusdam-cupiditate','pixlogix_21487hu_barnes','Fi9FKbX3','pixlogix_21487hu_barnes',3,NULL,1,'2023-05-26 21:13:23','2023-05-26 21:13:23'),(115,'Kadeem Dickson',362,'modi-dolore-quas-sun','pixlogix_90348kadeem_dickson','oFzlihVH','pixlogix_90348kadeem_dickson',1,NULL,0,'2023-05-26 21:15:24','2023-05-26 21:15:24'),(116,'Jermaine Atkins',363,'porro-quis-soluta-re','pixlogix_33082jermaine_atkins','oegtfTM3','pixlogix_33082jermaine_atkins',3,NULL,1,'2023-05-26 21:19:10','2023-05-26 21:19:10'),(117,'Oren Aguirre',364,'vel-laboriosam-volu','pixlogix_69481oren_aguirre','Yr616zJV','pixlogix_69481oren_aguirre',1,NULL,1,'2023-05-26 21:45:43','2023-05-26 21:45:43'),(118,'Ahmed Sykes',365,'velit-quis-magna-dol','pixlogix_90113ahmed_sykes','mmEKhGYb','pixlogix_90113ahmed_sykes',1,NULL,1,'2023-05-26 21:46:57','2023-05-26 21:46:58'),(119,'Jeremy Browning',366,'neque-eligendi-qui-e','pixlogix_35474jeremy_browning','GiE7fHo7','pixlogix_35474jeremy_browning',2,NULL,1,'2023-05-26 22:00:06','2023-05-26 22:00:06'),(120,'Alice Barker',367,'ea-dolore-omnis-enim','pixlogix_53443alice_barker','Sx5x1drU','pixlogix_53443alice_barker',1,NULL,1,'2023-05-26 22:03:39','2023-05-26 22:03:39'),(121,'Brandon Berry',368,'est-distinctio-ius','pixlogix_40843brandon_berry','Bl993PnS','pixlogix_40843brandon_berry',1,NULL,1,'2023-05-26 22:04:43','2023-05-26 22:04:43'),(122,'Rhonda Powell',369,'minim-quidem-qui-dol','pixlogix_4406rhonda_powell','4ZoZfUTu','pixlogix_4406rhonda_powell',2,NULL,0,'2023-05-26 22:06:26','2023-05-26 22:06:26'),(123,'Tamara Pugh',370,'cupidatat-debitis-qu','pixlogix_43768tamara_pugh','gRgEpKqK','pixlogix_43768tamara_pugh',1,NULL,1,'2023-05-26 22:08:12','2023-05-26 22:08:12'),(124,'Hakeem Figueroa',371,'sed-nisi-aspernatur','pixlogix_95178hakeem_figueroa','gPbcR186','pixlogix_95178hakeem_figueroa',3,NULL,0,'2023-05-26 22:16:42','2023-05-26 22:16:42'),(125,'Yoshi Bridges',372,'voluptas-dolor-id-at','pixlogix_97663yoshi_bridges','fGnKbCXB','pixlogix_97663yoshi_bridges',1,NULL,1,'2023-05-26 22:25:32','2023-05-26 22:25:32'),(126,'Sheila Calhoun',373,'accusantium-qui-inve','pixlogix_43103sheila_calhoun','7t8BegNi','pixlogix_43103sheila_calhoun',2,NULL,1,'2023-05-26 22:26:11','2023-05-26 22:26:11'),(127,'Rose Little',374,'omnis-eaque-sint-et','pixlogix_91795rose_little','XoNZLH8a','pixlogix_91795rose_little',1,NULL,0,'2023-05-26 22:29:15','2023-05-26 22:29:15'),(142,'Harshad Test',406,'hashad-test','pixlogix_95495harshad_test','eoctGEuq','pixlogix_95495harshad_test',1,NULL,1,'2023-07-27 01:44:49','2023-07-27 01:44:49'),(160,'test clone',434,'test-clone','pixlogix_11378test_clone','SrG59CKc','pixlogix_11378test_clone',1,NULL,1,'2023-08-19 03:01:53','2023-08-19 03:01:53'),(164,'tEst c',442,'test-c','pixlogix_42170test_c','e3I6aI5U','pixlogix_42170test_c',1,NULL,1,'2023-10-09 20:55:42','2023-10-09 20:55:42');

--
-- Table structure for table `subscription_plans`
--

CREATE TABLE `subscription_plans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `plan_details` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_plans`
--

INSERT INTO `subscription_plans` VALUES (1,'Silver',2,1,'2022-11-29 02:31:11','2023-06-28 03:48:33'),(2,'Gold',100,1,'2022-11-29 02:31:18','2023-05-24 22:18:30'),(3,'Bronze',1,1,'2022-12-02 05:58:46','2023-06-28 03:52:13'),(5,'Platinum',500,0,'2023-06-28 04:03:38','2023-06-30 05:11:15');

--
-- Table structure for table `timelines`
--

CREATE TABLE `timelines` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `type` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `from_date` date NOT NULL,
  `to_date` date DEFAULT NULL,
  `badge_id` bigint(20) unsigned DEFAULT NULL,
  `certificate` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `timelines_employee_id_foreign` (`employee_id`),
  KEY `timelines_badge_id_foreign` (`badge_id`),
  CONSTRAINT `timelines_badge_id_foreign` FOREIGN KEY (`badge_id`) REFERENCES `badges` (`id`),
  CONSTRAINT `timelines_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `timelines`
--


--
-- Table structure for table `todos`
--

CREATE TABLE `todos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `project_id` bigint(20) unsigned NOT NULL,
  `description` text NOT NULL,
  `start_from` date NOT NULL,
  `status` varchar(255) NOT NULL,
  `planned_hours` time NOT NULL,
  `delivery_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `todos_employee_id_foreign` (`employee_id`),
  KEY `todos_project_id_foreign` (`project_id`),
  CONSTRAINT `todos_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  CONSTRAINT `todos_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `todos`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` text NOT NULL,
  `middle_name` text DEFAULT NULL,
  `last_name` text NOT NULL,
  `phone` text NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `site_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `remember_token` varchar(100) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `deletable` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=462 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'',NULL,'','','admin','admin@gmail.com',NULL,'$2y$10$c7YC3Cqi4B6iI26JdBcyd.H.hHNkNMECyTvl3Lm7/v4u8CeCHSAoO',0,'wJucbZVvKySS3usWzXlRovJkbz1LewzKIQafPPr10KyAK2YAMvJtMEgFYuRX',1,0,'2022-10-04 04:39:15','2022-10-23 07:09:32'),(2,'HRM',NULL,'Admin','7894561230','HRM Admin','hrm@gmail.com',NULL,'$2y$10$ALzY70RlnENPs4.Qc2RjZOc9BABdGEm229P7POCk/BgUK7q5a9JK6',1,'meDxSWPkopueNULT4Nnvkey87gdGUyg7RUyWHTXcZC1O3pu6vTKSEtQZUlw5',1,0,'2022-10-04 04:50:47','2023-03-08 09:36:54'),(3,'Employee','','last','','Employee  last','employee@gmail.com',NULL,'$2y$10$YsdDPOZ1Ty62Uo9RAMTsTueFOcNDethwu2Sw.ocn/ZqI0QEvoO6aG',1,'t21CTBgBnOa4ONqCSyIHjc8tw5NPsFAq83ncXkTOsPTVx2pyAJGH95m8qofu',1,1,'2022-10-04 06:30:37','2023-01-31 07:58:28'),(5,'Serina','KeithSpears','Estes','1','Serina KeithSpears Estes','mywymewen@mailinator.com',NULL,'$2y$10$YsdDPOZ1Ty62Uo9RAMTsTueFOcNDethwu2Sw.ocn/ZqI0QEvoO6aG',0,'iuG7jb76oFORifrauVUDqRc6hkXsFC8eDY4iw7eR5TWdevUFkEQXUfIKus5p',0,1,'2022-10-04 08:21:28','2023-05-23 23:30:17'),(6,'darshil','N','Bhatt','','darshil N Bhatt','ba1@pixlogix.com',NULL,'$2y$10$/Y0dx/jyshhw4irJQEh9JOy3QN4qk3wuNOLdfXZriSJm3KYHtbPJO',1,NULL,1,1,'2022-10-11 22:37:56','2023-02-24 09:56:57'),(28,'',NULL,'','','Abdul  Zaffars','abdulzaffar@gmail.com',NULL,'$2y$10$XTOwdo/mZ0p34lGQGt5lE.D87khztDs6kL/hN67RGW4Pztk6QaiEG',1,NULL,1,1,'2022-10-31 00:18:55','2023-01-31 07:58:28'),(40,'',NULL,'','','siteadmin','siteadmin@gmail.com',NULL,'$2y$10$RdsCVy9ATkSxHUWfKEs/CeYVsT8ACvL47ouLNPyTawm4JNpjC/.4i',0,NULL,1,1,'2022-11-04 22:14:19','2022-11-04 22:14:19'),(41,'',NULL,'','','Users Admin','usersadmin@gmail.com',NULL,'$2y$10$3Fowp0TeHiM5BXkTsS/76uZruRcxFaKpvB1vcMvzHKtU8ohd.jM7e',0,'WyrCTn3WIKKejSMcgedHTr8u3lO34bgSrek7xBAIglAgZIf5MSBuKQS9XA47',1,1,'2022-11-04 22:59:41','2022-11-04 22:59:41'),(42,'Abdul',NULL,'ZAffar','789456103','Abdul ZAffar','zaffars@pixlogix.com',NULL,'$2y$10$fvc9MfTNzRRGdjg5SzrV1.XeVd6TT7MxQGjXRiVL6rKLmX2jw.ZqS',39,'UEHok2q7Oh0CDaugoGhXNxS2ru4qG07TgUI0AhWAVokAFQnFid8AY8ZHIm3I',1,1,'2022-11-05 20:55:22','2023-03-08 08:50:51'),(63,'',NULL,'','','Aoibhe middle Murtagh','froztech@gmail.com',NULL,'$2y$10$4D1vJ7GIkMna0at3CLvD0.clXwDLN9e/6hVOUnC9BlEHxIX908viO',0,NULL,1,1,'2022-11-17 20:57:48','2022-11-17 20:57:48'),(65,'',NULL,'','','P  M','pm@pm.com',NULL,'$2y$10$zht45BbEviaOZBcA.0R.QO2ZQ.WHfZo.DhoxvkKWD0NhA77h4PO4u',1,NULL,1,1,'2022-11-19 05:03:20','2023-01-31 07:58:28'),(74,'Van der Mark','der','Mark','9876543210','Van der Mark der Mark','mark@domain.com',NULL,'$2y$10$EfIWAbmdkoLddghCRJVi2urXcbdfUlMds79S8SJdTw0oj/M1515Py',28,NULL,1,0,'2022-12-02 00:12:03','2022-12-02 00:12:03'),(76,'',NULL,'','','Sabir  Malek','sabir10.pixlogix@gmail.com',NULL,'$2y$10$wPutW0rW1y/L8WwvuYNs5ObmZ7k7ttkFYLTtcYLErGjE0/uPZjwKi',1,'dVtBuq1bWLQeXOeUTCiqCwVECZaTL0BEbDEHCGR32DoaWsBM1B9O3pQdYMQ4',1,1,'2022-12-07 03:27:26','2023-01-31 07:58:28'),(79,'hbjm',NULL,'jbm','678778','hbjm jbm','nbm@mn.vom',NULL,'$2y$10$xRMWG16XEzPDCoaRnXL5X.Ww93g/DnLoKkIkw2Ua0SC0vuUOmTClG',32,NULL,1,0,'2022-12-25 08:06:27','2022-12-25 08:06:27'),(80,'hbjmjh',NULL,'jbm','678778','hbjmjh jbm','nbhgjhbm@mn.vom',NULL,'$2y$10$qSETN9.AHdZalRWGUEPSj.U/gxLHiXVH9WrlgTgccD7rMLUI./8bC',39,NULL,1,0,'2022-12-25 08:08:41','2023-05-25 04:33:06'),(81,'hbjmjh',NULL,'jbm','678778','hbjmjh jbm','nbhgjhsdbm@mn.vom',NULL,'$2y$10$TiQUVTUKd2Q4iVmX3idTYuIygQbN.DV/sMVKhVNaUA0MP0cd4NEOq',34,NULL,1,0,'2022-12-25 08:10:26','2022-12-25 08:10:26'),(82,'Milan',NULL,'Patel','98765','Milan Patel','milan@restside.com',NULL,'$2y$10$zruAGHGGCDqm13WsgIubH.6S25dNCR2LVS8Pj8h9dO/dE1YRE5Z0y',35,NULL,0,0,'2022-12-27 22:55:27','2022-12-27 22:56:16'),(90,'li',NULL,'ugj','345465767','li ugj','liyisem105@letpays.com',NULL,'$2y$10$oTEPxvA1pGYWsOa87aRGpuD93W0JP7bSL4oQj1l0kYm.7SpGSVh4a',1,NULL,1,1,'2022-12-30 09:22:15','2022-12-30 09:22:15'),(96,'Pixlogix','','HRM','1234567890','Pixlogix  HRM','pixlogix@gmail.com',NULL,'$2y$10$EcQL10vN22HYLPvTt5T5MusnMnEtghASMmGKywp0XNWTtfdm30hnu',39,'bmUEHlKwVZNMqV5ajb3McON76T0fWXEWNq6N7fqvEDpwnrPixZGRzl8ykxfS',1,0,'2023-02-02 22:11:31','2023-05-24 22:13:17'),(99,'Chanda','','Kankasania','9979041567','Chanda  Kankasania','hr@pixlogix.com',NULL,'$2y$10$D55KmhoOijUUGCV0.1kV4u7T7UMO27.v1n0AQXmsVZ2icEI.UgbgS',39,'9KrwBn51bot99bcCNMFSB98N3Y4oPWOK4mp4FVvLNkmZOZ5OvJhCo4I225VJ',1,1,'2023-02-07 05:26:38','2025-04-22 00:32:05'),(100,'',NULL,'','','Milan  Patel','milan@pixlogix.com',NULL,'$2y$10$AfkuslFwEfliC7lSMvvkDusWIPlUl4XVO0WdVHwynhfSeANkb2n8K',39,'RdG2V6fg1FegPhRg2DLH6Tvsrf5IR3MhQ5Hv1bpbxQE1p0ydsuNandO2VlFM',0,1,'2023-02-08 03:48:47','2023-08-08 00:04:14'),(101,'Khushbu','','Parmar','','Khushbu  Parmar','career@pixlogix.com',NULL,'$2y$10$MYzAo3XJhYBXCNMxBvL8cuW8g6xp38Vk7K58.tM3IGZpJYKH2i6v2',39,'CdErzK4Y40mJPmh5z67xnFTEu9s0638b1vdPcDe8nq8ltTUr340DBdbxpLib',1,1,'2023-02-08 04:13:40','2023-08-04 03:19:46'),(102,'',NULL,'','','Bharat  Dangar','bharat@pixlogix.com',NULL,'$2y$10$GOs.ZkoHmZr/n3DOB81eZeJu8Tf3OKDx2Z9oKqKTaO0MD9tI09Dgy',39,'64NFVhyvYl5HsPBuUmij3t8MqBsN7WtUclVHr96RkCehMtQj9dWFM21qpUJ1',0,1,'2023-02-08 04:27:09','2024-01-02 22:32:49'),(103,'vaibhavi',NULL,'patel','1478520369','vaibhavi patel','vaibhavi@pixlogix.com',NULL,'$2y$10$Eevu4esY6nZmo.izqQ0aF.85PRq0enD3CBsklimhWv.AHRXcDzVf6',39,'npJkiUFtSNJuujZs4duSMgp6PiZssZ0jj8KdoLeOKVi7nRrKUyre7XtFgMK6',0,1,'2023-02-08 04:30:34','2023-08-08 00:05:20'),(105,'Parth','','Jogi','','Parth  Jogi','parth.jogi.pixlogix@gmail.com',NULL,'$2y$10$wNT6KJTTV7GzMC4qlGGiFun.Jtu9gIIcMQ61mcHXory7utG5RL00a',39,'kmQjpXn1MRUaOAi5lFLpPjVIYEX80NpkLQPnoEDA4MT9ZkssFGkiKzqOZYoO',0,1,'2023-02-08 04:40:09','2024-07-01 21:56:41'),(106,'Niket','','Garala','7474747474','Niket  Garala','niket.pixlogix@gmail.com',NULL,'$2y$10$8TpFjk2zgfV/jrs/xgpcR.hqpGRamadlm41ZgCZTFHuxmPJqoKSYC',39,'GgVh4VO1hweZWq4Jb7lHKkjMb2wpcOq32hSvP7NIsQrTATa45l7Usjrqr5bA',0,1,'2023-02-08 04:42:49','2024-09-04 04:43:30'),(107,'Ravi','','Jethva','','Ravi  Jethva','ravi@pixlogix.com',NULL,'$2y$10$XDRhjSlAqzRYEDR7OA4DuOZQUJQwJeihT/tXV79OA1lTGDxHTj11i',39,'3j1xcM0e78nSha3FkSghshSryhsLtJOCBKZCX2Apal5HbgQ7BUjlckGKKisk',1,1,'2023-02-08 04:45:41','2023-08-01 22:48:01'),(108,'Neel','','Bhatt','','Neel  Bhatt','neel.pixlogix@gmail.com',NULL,'$2y$10$vaSinmGMp2w9mhLuJtnPn.zLviOW8gUNTYfxoEuOdDKypKICTeDKW',39,'WxSw7O42C64MHbYYIU0rV0arX0caS6t2oNx3JJqEXxnyWm1OBbs1ckGQdwft',1,1,'2023-02-08 04:46:08','2023-05-30 20:35:01'),(109,'Hardik','','Nakum','','Hardik  Nakum','hardik.pixlogix@gmail.com',NULL,'$2y$10$O.ci9aLxfM4E55kx2Peyc.QOz4exrecjYC1UnxXqgA3vHqZ2okyja',39,'XRwAo7Gt1EfQIdqE12WaAM1WBVNdBgRJeUYNkEFUDIGNXgo2atGB4fREo5IZ',0,1,'2023-02-08 04:48:31','2024-06-01 01:09:00'),(110,'Kavya','','Mehta','','Kavya  Mehta','kavya.pixlogix@gmail.com',NULL,'$2y$10$S6ihZAoyUbNvu1QLSXvJK.1iLXVbjij2BaVQCl1ousWqeWjmgQatm',39,'go3tzQrIBojRBVZXXicOqAowkyy4HckVfxaV9ZG8ur3ynh0i5D1padD7uHzt',0,1,'2023-02-08 04:49:00','2024-07-30 03:55:34'),(111,'Sangita','','Galathiya','','Sangita  Galathiya','sangita.pixlogix@gmail.com',NULL,'$2y$10$ISgp6uQpGSIBsq4rQap4/u8Nocx0cmrKu6fukOd.R41WUtNVeRC.m',39,'6kNxEHE3wfOsPfDRojY8PVbCDdDqGH3XWzMJotlXH4JxM4axebfQFZ6AmKqE',1,1,'2023-02-08 04:51:01','2023-09-21 21:00:16'),(112,'Parth','','Shiroya','','Parth  Shiroya','parth.pixlogix@gmail.com',NULL,'$2y$10$LUP2QlzkEjDCgj.wiE0C7O7VD6VuGy2e2Zhrnlvlu5E5ikiRSzl6u',39,'VMmDi6Qbe4SHik77QuiHO8njnqW7P9JqPRSFH0RSyUjTd7hp6M165GAAwfny',1,1,'2023-02-08 04:54:21','2023-08-14 19:21:04'),(113,'',NULL,'','','Chirag  Patel','seo@pixlogix.com',NULL,'$2y$10$Q/3tM9ouRU985xIzqmMfa.KKCDDAXMYYLignGvbFqFdwh9xQNXNA2',39,'FZUvn3CMbseO2pksJNhMD6w5h5Uw28Gt49N4NQuy7msyiZnO0NBvbonZYpEk',0,1,'2023-02-08 20:39:38','2023-09-01 21:49:14'),(114,'',NULL,'','','Ashish  Tiwari','ashish@pixlogix.com',NULL,'$2y$10$AAdwL.e7iLutvEpnCVyskOy/Hj3Rb71Ex8o1JgJdRWOxkKqTkJBY6',39,'k4TOSDirCcEiQS84paLvtGXCRzc3AXZ87Dmp1lGaij8UKRXywcfsNUtkkLfH',1,1,'2023-02-08 20:41:37','2025-04-28 20:08:52'),(115,'',NULL,'','','Reena  Parmar','reena.pixlogix@gmail.com',NULL,'$2y$10$I2gaX8Bqn3Zouotp3CdrHurEsa0UXI8wr7yI0Aqz1pb28.LCgDSy6',39,'9E8BBTL4NnwXry6KEQDL8AJe1qAlX4mYfoFZOGSMK79D4lbz4jdlYA42Sjw7',1,1,'2023-02-08 20:43:31','2023-05-30 19:53:02'),(116,'Km','Preeti','Sharma','','Km Preeti Sharma','priti.pixlogix@gmail.com',NULL,'$2y$10$dzYFbQQUDVOogo/cCx/3RuE1S9XmpdZkyiCIbBeDlEkLEqIvTGyQ.',39,'RCUcnrx8sfDQYmGIknw2AJPoI0l5SbyGcsU56gXuCNpggjVAA466VuN7Elnn',1,1,'2023-02-08 20:45:03','2024-09-13 01:21:23'),(117,'Zeel','','Thacker','','Zeel  Thacker','zeel@pixlogix.com',NULL,'$2y$10$l/.ZH6lYMCOzpXy2yLgqYeVYQqdFS1fPkebOo94x1Nxamb5pvX4Ge',39,'vt5VrlaXciAUNv9EWhQNHOzLL2d4C2kupAD2MZN8qzT7nJG44ZCT5KC46Ep5',1,1,'2023-02-08 20:53:38','2024-06-06 02:15:47'),(118,'',NULL,'','','Aoibhe sfg ZAffar','adminsdds@gmail.coms',NULL,'$2y$10$PJpXp79mrubkmZSolpQBHel58n1KCE4vhRFMnNbhQzkfNDKlStCk6',1,NULL,1,1,'2023-03-03 10:59:11','2023-03-03 10:59:11'),(120,'',NULL,'','','Mukund  Patel','mukund@pixlogix.com',NULL,'$2y$10$OdQXoIvkz/NqjyqE79uvpesxkBq/KbHL/wzmAP9L8QBj0NSebvJG.',39,'57pT7mgLNgRh2Mu1AgrL31Hqtu1p2b6SfxnGPyOnkGLWn8eWrTFat7bGOWBx',0,1,'2023-03-20 21:41:28','2023-05-30 21:14:43'),(135,'aaa','a','dsfs','939393993','aaa a dsfs','abc1111@gmail.com',NULL,'$2y$10$tYfUTHnOYz87MBJ/vQkVg.ENUQIeDBUEHgP7zLrOkbqFxd11DiQh6',39,NULL,1,1,'2023-04-06 04:37:41','2023-04-06 04:37:41'),(136,'bb','vv','bbbb','38383883','bb vv bbbb','vbvb@gmail.com',NULL,'$2y$10$ZkgHTaBLLpo3ZwmqPQeqbO5k2g71kyulsKNhVuU6T52Rnm4RN/SCC',39,NULL,1,1,'2023-04-06 04:38:27','2023-04-06 04:38:27'),(158,'',NULL,'','','mukund p p','mukundp719@gmail.com',NULL,'$2y$10$TAzxaSyIujcfo6KrXHgfS.9kPB8m6lQBo8yOfp9SlU7h76AlABm3q',41,NULL,0,1,'2023-04-11 04:37:11','2023-04-11 23:53:26'),(168,'sdaf','dsfa','sdf','1230456789','sdaf dsfa sdf','sadfsd@dsg.com',NULL,'$2y$10$QE/5ssXzT0A7VSpTcEqqAeT/NrnaiBayL3I1sRn2DV7XSMoG7dVbe',48,NULL,1,0,'2023-04-12 01:55:31','2023-04-12 01:55:31'),(170,'dsfa','dfsasdf','dsds','1047852369','dsfa dfsasdf dsds','dasaa@rstgrsr.com',NULL,'$2y$10$6y.twPKFdgNfspJzE/1kHunXd0s7/yIuxwAxf554gaSEK1JeXX1x2',50,NULL,1,0,'2023-04-12 02:05:16','2023-04-12 02:05:16'),(206,'Divyaraj','','Bheda','','Divyaraj  Bheda','divyaraj@pixlogix.com',NULL,'$2y$10$BQXr5XlWX2vkh1MYkeTd/evVe3j9.47U440mz43a1VrqFeXJ1hFnS',39,'kwzlt2L9L4wYASMlI53Rd7p8sCdTtZ9OR7aROSZgXyMsiU0RiVEbwhCwfcFm',1,1,'2023-04-24 20:27:30','2024-08-02 04:09:08'),(208,'Meet','','Kapadiya','','Meet  Kapadiya','meet@pixlogix.com',NULL,'$2y$10$ak03V3/BeN1g71flnHIjIu6VdnyZuETBnmU6n7QStLLYDMSLiVOj2',39,'QjVJhVkNHuKLtPOmkeOQXoDhV7L4cEJOM3b0lWvOKTZfgfV4MWMLSiPZLOVV',0,1,'2023-04-24 21:10:17','2024-04-12 21:14:03'),(210,'',NULL,'','','Moinuddin  Marfatia','moin@pixlogix.com',NULL,'$2y$10$twT.AKJhcM1Os50leHPy2eZidrGNNXybp4dZ9DVSLGL3B.ykw.ruC',39,NULL,0,1,'2023-04-24 21:15:27','2023-05-30 21:12:19'),(211,'Sabir','','Malek','','Sabir  Malek','sabir.pixlogix@gmail.com',NULL,'$2y$10$U524tIeIZVMQJ1b5ivR/4.aSq3jOddZGdxqAnFJWvzoqQbMmzpeOa',39,'jhYX8ENy7tTRThD0493XIpziUrgBp7mqmI30jW2X6CDhawCjZeSZlcG2Pvsq',1,1,'2023-04-24 21:18:06','2023-09-01 20:25:16'),(213,'Vijay','','Maru','','Vijay  Maru','vijay@pixlogix.com',NULL,'$2y$10$9GoWTR7GxJ229zjhgzC2H.MiC80Vej3FWVhC7Bn4e7KUdIyTKiAgK',39,'Qzj7WHLsEbcLI1SVIrvnHQ7jDbp0D0gCxJsABic5YS70XoODltUaJvs1MGMN',1,1,'2023-04-24 22:26:30','2024-06-06 02:14:38'),(214,'',NULL,'','','Meet  K','meetpatel5393@gmail.com',NULL,'$2y$10$1FXDBY.R4d9CSVKVuKEfd.TjtCgTUYAa/qPkY7OM5pF7EkHVkSaCe',39,'REC8ZIeDaaX84Q4n9X05LmjZL7YLNJSUcsmh2r2NgkQrif8JNEwjR0AqA0QV',1,1,'2023-04-25 01:11:59','2023-05-24 22:13:17'),(218,'',NULL,'','','Sagar  Pandya','sagar@pixlogix.com',NULL,'$2y$10$E8S/H97U2h6hSjT5Vdoy/u4d5IYeAUNLsGcOkLykhtc9AbaUQjUH2',39,'IcYdhCqk5VxDmMuVdcM82Vb5q0uqrn5ywkNqEVztTg4XeQJjfit48RAeZiTM',0,1,'2023-04-26 23:38:04','2023-08-08 00:04:51'),(245,'',NULL,'','','Knox Kevyn Powers Thompson','vagomu@mailinator.com',NULL,'$2y$10$Z.L93k2PGc0rkBQJ87g4Z.xjOVXw8iTnOsDfBJMyPSpGRJzSfcO8q',39,NULL,1,1,'2023-05-11 08:34:16','2023-05-24 22:13:17'),(246,'Cally','Burton Kane','Robbins','','Cally Burton Kane Robbins','newemployee@givmail.com',NULL,'$2y$10$kyrqwG7YnNnTAcWiJT.6/uD0MTm/N/z5joBpst3/I8lpBkeqe6yIe',39,'6goanj5q5j7S22wgSyIBVZX5l6Rux0UO1Ia4u0A5EhWvbKREjIRnhRcsAmDI',0,1,'2023-05-12 01:22:25','2023-05-24 22:07:34'),(251,'user',NULL,'user','74185296177','user user','newuser@getnada.com',NULL,'$2y$10$.2lWkOHaD7yeo8CTf.lL1Oie.D5sBe8QSC7FL/h3eyd7Vv1ZfujjC',0,'8dbghbszRt9woaF5DqkyaL9VDGhCxK0wcbsFdKYtdxfJBglKzc7veBjXpr8b',1,1,'2023-05-15 20:47:33','2023-05-15 20:50:24'),(263,'',NULL,'','','Risa Linda Morton Wood','kypoco@mailinator.com',NULL,'$2y$10$JVrRP2xj1/Vgi41D29s2M.C6wNXMHSnFJN34vBFID6Fu8nzukiQRW',39,NULL,1,1,'2023-05-19 01:26:11','2023-05-24 22:13:17'),(271,'John','_','Doe','748529637525','John _ Doe','employeecreate@gmail.com',NULL,'$2y$10$qzul4GsMyP8OlExZWcsQS.pO7s4mmBJN1dUtMvJi2f21IWgQwd0Hy',1,NULL,1,1,'2023-05-19 03:21:20','2023-05-19 03:26:10'),(315,'',NULL,'','','Amal Naomi Finley Eaton','qonu@mailinator.com',NULL,'$2y$10$27AQYGLQr1yHY3HbTl29DuX/VlMmJGPocDHJZTDU4P3g35nR1fD9u',39,NULL,1,1,'2023-05-24 21:27:36','2023-05-24 21:27:36'),(316,'',NULL,'','','Miranda Dolan Webb Vance','jipoja@getnada.com',NULL,'$2y$10$VWAGW8CW1Dp4xkWcuNEK4uVMUfxwtWi//ZXgwQo3X43Qke9xDy3uG',39,NULL,1,1,'2023-05-24 21:28:50','2023-05-24 22:13:17'),(317,'',NULL,'','','Yasir Karyn Newton Hayes','waralum@mailinator.com',NULL,'$2y$10$XiQRbW7jPzLDiNJns1Fg7uoNzpOvFyxb9OWrG3COOjhCzF.8qYbq2',39,NULL,1,1,'2023-05-24 21:53:24','2023-05-24 22:13:17'),(320,'',NULL,'','','Faith Karleigh Rivera Boyer','zivoqehaf@mailinator.com',NULL,'$2y$10$ttGZTGJYUQrbqo0cINjPc.ngliDj2m02GkZqiQgugiL1ZNTPX5Pv6',39,NULL,1,1,'2023-05-24 22:01:44','2023-05-24 22:13:17'),(321,'',NULL,'','','Cadman Marah Ramsey Rich','sutybocexe@mailinator.com',NULL,'$2y$10$SJ5di9aL5SWwrGR4enx1EeSwNJ3A1AoO5b6lf0DRpSRjs9HOYJhIG',39,NULL,1,1,'2023-05-24 22:05:47','2023-05-24 22:13:17'),(322,'',NULL,'','','Ariana Hamish Bender Holder','cawad@mailinator.com',NULL,'$2y$10$YSvEZK1EWUYeeq8zgCLFKet.IE9cmyPoWyAnhqUK6GEMdYSqVznBO',39,NULL,1,1,'2023-05-24 22:08:05','2023-05-24 22:13:17'),(323,'',NULL,'','','Candace Adria Puckett Cline','jecegepugu@mailinator.com',NULL,'$2y$10$TT0INzMqrQdaWQlttVWz2.KED8Q9dNxUcswLj3N2ws/OvIzv5STty',39,NULL,1,1,'2023-05-24 22:13:22','2023-05-24 22:13:22'),(324,'',NULL,'','','Kristen Ronan Armstrong Bridges','jyzexeka@mailinator.com',NULL,'$2y$10$U1sKmuLXCLSKMDbv9TwHCeBNcCLL9t7BTI/Zz/Fejz.AGYoZGEJqW',39,NULL,1,1,'2023-05-24 22:14:19','2023-05-24 22:14:19'),(325,'',NULL,'','','Scott Marcia Lancaster Bates','mybu@mailinator.com',NULL,'$2y$10$Bx18GRwCgy1wzMkUKQrbReGH85JJ2cdHaxW1Pqk6XRLImtUivrlde',39,NULL,1,1,'2023-05-24 22:17:29','2023-05-24 22:17:29'),(326,'',NULL,'','','Chastity Buffy Delgado Noble','zelovir@vomoto.com',NULL,'$2y$10$pTr6/ZxcaKRCqnEcm3/kQO5DyPG4JXkUj.HIMLSQISB0rQwmz6dZm',39,NULL,1,1,'2023-05-24 22:18:37','2023-05-24 22:18:37'),(327,'',NULL,'','','Inga Elizabeth Ellison Horne','qanugik@getnada.com',NULL,'$2y$10$N8Js8QsIYqiumf3gl1LmqO.50g.Z9icROzLSIGSDualZ/m0f9aGne',39,NULL,1,1,'2023-05-24 22:23:59','2023-05-24 22:23:59'),(328,'',NULL,'','','Steven Allistair Crane Farrell','fyvuqujel@mailinator.com',NULL,'$2y$10$OSicD77fx0pFAKTQqUPhyeHOhR8ERapH7Gmiru.mMOFNpLfiQLj2e',39,NULL,1,1,'2023-05-24 22:25:44','2023-05-24 22:25:44'),(329,'',NULL,'','','Keiko Amela Jacobs Deleon','witerep@getnada.com',NULL,'$2y$10$pbHuZVrIHdJQfwf4fr0pmOZGuStqwPV0k3UKsD2AL42bhWARPcwj6',39,NULL,1,1,'2023-05-24 22:28:33','2023-05-24 22:28:33'),(330,'',NULL,'','','Reece Zeph Kirk Espinoza','puryki@getnada.com',NULL,'$2y$10$JLb9bBwHdk7hpjnVJVAVLOsWw4tXtuN6MrNi2ilgFgpbcvgn5AiQq',39,NULL,1,1,'2023-05-24 22:30:01','2023-05-24 22:30:01'),(331,'',NULL,'','','Malachi Chaim Park Gutierrez','radyhapap@getnada.com',NULL,'$2y$10$S8kKA7lVqklLvQUaaac7AepF1yB4gslaUg0OWegjFYxZAYVi2OF6K',39,NULL,1,1,'2023-05-24 22:31:37','2023-05-24 22:31:37'),(332,'',NULL,'','','Elizabeth Jermaine Bridges Short','qicil@getnada.com',NULL,'$2y$10$jy/8jNEO7NCqbEinWu/dM.1gLPMMeM9BiEuxrrdvsP9ozq8ZjtR9.',39,NULL,1,1,'2023-05-24 22:32:16','2023-05-24 22:32:16'),(333,'',NULL,'','','Cheryl Emma Cantu Stanley','tukyjoli@getnada.com',NULL,'$2y$10$lUbu/6v4pCMcthRQKFhHgu/XoYPuf4MUxYuw3tcK8QGaC./7JBeF2',39,NULL,1,1,'2023-05-24 22:33:23','2023-05-24 22:33:23'),(334,'',NULL,'','','Kerry Yasir Buckley Hopkins','roziq@getnada.com',NULL,'$2y$10$JJpXvPf9CrMcUF3xcZc3XOZmFTaLulbhPrByh9XRzUURjeQKyxMf2',39,NULL,1,1,'2023-05-24 22:34:35','2023-05-24 22:34:35'),(335,'',NULL,'','','Ariana Leo Clarke Russell','lalyna@getnada.com',NULL,'$2y$10$IDWlEijjRAnpnWxoWs4uLOpQHkv9BVBKwQdFRJnOz6JF7hy7kTESu',39,NULL,1,1,'2023-05-24 22:37:36','2023-05-24 22:37:36'),(336,'',NULL,'','','Kimberly Forrest Tyson Melton','bijox@getnada.com',NULL,'$2y$10$2Bll4kZMC9bdqpHyG8kRuO37eM67LvCYsV3Ta.d0DNBV0qRV0/dZy',39,NULL,1,1,'2023-05-24 22:39:11','2023-05-24 22:39:11'),(337,'',NULL,'','','Burton Madonna Burks Lynch','munyxe@getnada.com',NULL,'$2y$10$qULaur2v1MLvXYTtgCyvM.JTxpVfzhv7Jl8hihIEGFlz7t8s/zPf.',39,NULL,1,1,'2023-05-24 22:41:44','2023-05-24 22:41:44'),(338,'',NULL,'','','Zorita Zia Gibson Hernandez','pyluc@getnada.com',NULL,'$2y$10$YOPSk0X3dotlsGFYkgqxz.Mt5eE6Lk0HRuQU8.IYNZvIkSDp1lq3C',39,NULL,1,1,'2023-05-24 22:43:07','2023-05-24 22:43:07'),(339,'',NULL,'','','Christian Raymond Reyes Chan','dozydijic@getnada.com',NULL,'$2y$10$sH5R2luxRp9gBxZxlRV.WuZHs2un4htbGd7tJyYUXUkn7aq7mvmJy',39,NULL,1,1,'2023-05-24 22:58:40','2023-05-24 22:58:40'),(340,'',NULL,'','','Sopoline Dexter Barron Combs','locegoza@getnada.com',NULL,'$2y$10$3v3JqZUN4OAJPb5q9/R89OP5YLA0QnINzqyUXt.T69C34u4fqVQQi',39,NULL,1,1,'2023-05-25 01:08:06','2023-05-25 01:08:06'),(341,'',NULL,'','','Cade Ingrid Schultz Taylor','fyzicoc@getnada.com',NULL,'$2y$10$n6ZE60dBbyaiKFbaKjctheCLBV200K74W/Wb2QUQUrk7T4DMxAZJ2',39,NULL,1,1,'2023-05-25 01:09:35','2023-05-25 01:09:35'),(342,'',NULL,'','','Myles Sylvia Wyatt Shelton','gowoqa@getnada.com',NULL,'$2y$10$ymroAyAXDv1T1ebpuSD3j.bjvhkWLGgRGZOMfO4LSLwiyBY7.zWxi',39,NULL,1,1,'2023-05-25 01:11:51','2023-05-25 01:11:51'),(343,'',NULL,'','','Aretha Ocean Herrera Henry','rewugilyc@getnada.com',NULL,'$2y$10$WU2WdbWux/JXyQhautDFNeM6SIimaqx60kz2/xAWyZLXeZ5Rh.cAy',39,NULL,1,1,'2023-05-25 01:18:34','2023-05-25 01:18:34'),(344,'',NULL,'','','Raya Cherokee Ruiz Watkins','qulojipod@getnada.com',NULL,'$2y$10$Ln.0J4mbIJi0ipdayjKnwuFmCrFOTG3ixDKodnf7Kyp/tEybbRq8O',39,NULL,1,1,'2023-05-25 01:20:52','2023-05-25 01:20:52'),(345,'',NULL,'','','Pascale Gwendolyn Peterson Atkinson','kybahola@getnada.com',NULL,'$2y$10$1PYPhTQtTkv2ZHEUBT7RYOXW7EXe6iSsln4qm0Y3eJAS.xT/i6RtS',39,NULL,1,1,'2023-05-25 01:26:43','2023-05-25 01:26:43'),(346,'John','','Doe','','John  Doe','ruputi@getnada.com',NULL,'$2y$10$SQkHqUVe3hiqG2zazKDNIuP0mA3vuj.WPtpExZUJi7pAmLC8NlfJS',39,'09VUEa1svLGN8w9tjPVrDDKFepXDGaLJXxNJ5RaDH6X2DFOxdpkzWf5fiNJ4',1,1,'2023-05-25 02:31:51','2023-05-25 02:38:56'),(347,'John',NULL,'doe','1233','John doe','rekasevy@getnada.com',NULL,'$2y$10$0OmYQuUJShVJ2.r19evw2.jaGnUcTrdybD7bIWTV4Z4Oe81wzhzYe',1,'E1CuVS8dg0V3xx2gvMPsWk0TQ6tBL680JhoJ38wMuF62gHl1DCqFoMcLPoV1',1,1,'2023-05-25 04:09:54','2023-05-25 05:39:52'),(348,'',NULL,'','','john  cina','jodyze@getnada.com',NULL,'$2y$10$SAA9FVmg6Tk9Jq3.cdkK7uW5pN4eg1GCLkiIod3NUC2pqyOGNkwTK',39,NULL,1,1,'2023-05-25 05:02:57','2023-05-25 05:02:57'),(349,'',NULL,'','','Micah Giacomo Craig Chaney','jybilykob@getnada.com',NULL,'$2y$10$zA/mvDKFBnDLSynYzUJEQeAoS1rVGjSPO6CheUtUj9CMh/o1rK0xi',39,NULL,1,1,'2023-05-25 06:20:05','2023-05-25 06:20:05'),(350,'',NULL,'','','Kendall Risa Boyer Cardenas','rulawira@getnada.com',NULL,'$2y$10$LM73a9FOTU0ZLk0tCXrvr.0sHjYR0O.7mb19Hox7fsML0SRgMEqZu',39,NULL,1,1,'2023-05-25 06:21:08','2023-05-25 06:21:08'),(351,'',NULL,'','','Shaeleigh Damon Aguilar Gates','wefumev@getnada.com',NULL,'$2y$10$Tj5Pa8uhQ40MklUPSsd2X.nzR6b.FvzNgJiolDRASNeo8lZIBugES',39,NULL,1,1,'2023-05-25 06:22:53','2023-05-25 06:22:53'),(352,'Lawrence','Yardley Anthony','Porter','','Lawrence Yardley Anthony Porter','cajuqijo@getnada.com',NULL,'$2y$10$Q6xir84KIs3MUQ/BgRXuc.LAjWim2APV/YfqPUZiEYiFxk0EJ17ke',39,'E80QccKo5CQ8UTzJDK1LrPzOYzAfgYKjpb4UZFOeyTGQ8L6VIGNRI2kDeqhX',1,1,'2023-05-25 06:29:01','2023-05-25 06:36:20'),(353,'',NULL,'','','Emery Candace Fowler Gould','qoras@getnada.com',NULL,'$2y$10$UZo5CassUfcP1PWrtR07YuqrBfzrBvf1o.KxniO7gyLqb1xqo4l3G',39,NULL,1,1,'2023-05-25 06:31:08','2023-05-25 06:31:08'),(360,'Indira','Xerxes Craig','Walter','1','Indira Xerxes Craig Walter','macihoko@getnada.com',NULL,'$2y$10$IXtFjpl/wLgwN4XTH3l84eObz2ecsP/Hv4y4rDbxVziOnZzfVlin.',113,NULL,1,0,'2023-05-26 21:12:21','2023-05-26 21:12:21'),(361,'Brynn','Rae Colon','Dotson','1','Brynn Rae Colon Dotson','kecuzuruw@getnada.com',NULL,'$2y$10$CcoDDlCpcmPlmLmCUwhnJufvEn2Gd2A0jhi2snqgjqv2vMf8b2lVi',114,NULL,1,0,'2023-05-26 21:13:23','2023-05-26 21:13:23'),(362,'Alana','Paul Farmer','Warner','1','Alana Paul Farmer Warner','xorerykil@getnada.com',NULL,'$2y$10$wyy1Eg.6y2.USeLiDvKFpOxg0rEoyhfkgsJdFEDiZsmySN6ajZFai',115,NULL,1,0,'2023-05-26 21:15:24','2023-05-26 21:15:24'),(363,'Ciara','Christian Gentry','Johns','1','Ciara Christian Gentry Johns','xusyr@getnada.com',NULL,'$2y$10$.jiY9nGXPzvPposJhpLqHupBLAN3PPXp3u7b/S8qBoTiXQCvOZrfu',116,NULL,1,0,'2023-05-26 21:19:10','2023-05-26 21:19:10'),(364,'Alexis','Elaine Hancock','Wilson','1','Alexis Elaine Hancock Wilson','xeheso@getnada.com',NULL,'$2y$10$A89TCvyX56PRGsO0woS13.dRF0R5qddv3aGdrxOWoGHZ79dHwTmKq',117,NULL,1,0,'2023-05-26 21:45:43','2023-05-26 21:45:43'),(365,'Gretchen','Lewis Perry','Baker','1','Gretchen Lewis Perry Baker','jimuzogah@getnada.com',NULL,'$2y$10$xRF9NwqSkE5FhgqW0AU4kejxhfeUFjp4BSz/WoOovPoF2O2cJg7Qe',118,NULL,1,0,'2023-05-26 21:46:58','2023-05-26 21:46:58'),(366,'James','Jesse Cameron','Schroeder','1','James Jesse Cameron Schroeder','mililag@getnada.com',NULL,'$2y$10$KMspkOnm6LqAeRM8FhjDtulM9Pr3FhbeVoqvwsfbOInWYl61JBGvi',119,NULL,1,0,'2023-05-26 22:00:06','2023-05-26 22:00:06'),(367,'Shellie','Candice Owens','Leon','1','Shellie Candice Owens Leon','kymyruvi@getnada.com',NULL,'$2y$10$8JzjQHSaYfkvvo7c.SyBJOZhbLCcY9Feo7cisFXrXHpeoUbmCJ8B2',120,NULL,1,0,'2023-05-26 22:03:39','2023-05-26 22:03:39'),(368,'Genevieve','Brielle Sargent','Pacheco','1','Genevieve Brielle Sargent Pacheco','memitu@getnada.com',NULL,'$2y$10$T0z6Z0YOtc44Socmoj4XYOoYQVtZSx/tlM20xAOV/WR9I/wGcGMnm',121,NULL,1,0,'2023-05-26 22:04:43','2023-05-26 22:04:43'),(369,'Idola','Pearl Butler','Tucker','312','Idola Pearl Butler Tucker','tiqeginuc@getnada.com',NULL,'$2y$10$QS5oDbGuaoXAq1M67UFaw.Xi19Z2PXF.ghrWr3GpAd4DTfprVc0bq',122,NULL,1,0,'2023-05-26 22:06:26','2023-05-26 22:06:26'),(370,'Addison','Larissa Greer','Ellison','1','Addison Larissa Greer Ellison','qecis@getnada.com',NULL,'$2y$10$xXf.ysrFYf9GATCc44i96.nEoMBLKz2FnQs6w0xYT2EgLTeGNVdkK',123,NULL,1,0,'2023-05-26 22:08:12','2023-05-26 22:08:12'),(371,'Theodore','Chloe Melendez','Crosby','132','Theodore Chloe Melendez Crosby','jibewygoh@getnada.com',NULL,'$2y$10$HhNszxODbo.PhLI9/YBa0.gfYajuesDbdisMF.Atw8BG2.PKypGg.',124,NULL,1,0,'2023-05-26 22:16:42','2023-05-26 22:16:42'),(372,'Fallon','Debra Benjamin','Mckinney','1','Fallon Debra Benjamin Mckinney','qyhuxavo@getnada.com',NULL,'$2y$10$JAC0Wy75pMIvLDGoz/Ddfu68AHACWp5GtwhFvEMCf9ZrWYDvg/Y9i',125,NULL,1,0,'2023-05-26 22:25:32','2023-05-26 22:25:32'),(373,'Selma','Giacomo Oneill','Hess','1','Selma Giacomo Oneill Hess','jutunomaz@getnada.com',NULL,'$2y$10$l0WDJtl.gWRMY4GHmgkd0.BzmXStx/PsHwlsjd8OIR1ROY69jsWv6',126,NULL,1,0,'2023-05-26 22:26:11','2023-05-26 22:26:11'),(374,'Alfreda','Jonas Jones','Salas','1','Alfreda Jonas Jones Salas','kiriha@mailinator.com',NULL,'$2y$10$A3vG8DNbj28awlmrmxACFet7rPf2LPnOZN00VwHx0Mugh0IfnkCQe',127,NULL,1,0,'2023-05-26 22:29:15','2023-05-26 22:29:15'),(375,'',NULL,'','','Mikayla Aquila Langley Whitley','fetygyku@getnada.com',NULL,'$2y$10$ytoaYLNLxR2c3sU/QAIHJ.YcRvMXJK2Pk7x1m7D5nZM0QmVnF6lo2',39,NULL,1,1,'2023-05-29 20:11:21','2023-05-29 20:11:21'),(376,'',NULL,'','','Karina Latifah Thomas Gates','qataj@getnada.com',NULL,'$2y$10$6t8femvMBBFFo1yx0op8A.d3/PdV047PjjDRnDTj07gYFwDITGLA2',39,NULL,1,1,'2023-05-29 20:13:36','2023-05-29 20:13:36'),(377,'',NULL,'','','Patrick Macaulay Gregory Mckay','cyfuwekar@getnada.com',NULL,'$2y$10$U/K1WAY0CUNvzEm0Fi8DYefn3ntLCf48QF3myPNFr4BH.KQy5.oNW',39,NULL,1,1,'2023-05-29 20:16:34','2023-05-29 20:16:34'),(378,'',NULL,'','','Jessamine Christen Turner Wiley','ricycuc@getnada.com',NULL,'$2y$10$JEQXM0U3cpQFMxhf7pHFbuEbrcI.3FuHov65/3Bo5AeJxBrfkmnpm',39,NULL,1,1,'2023-05-29 20:19:05','2023-05-29 20:19:05'),(380,'',NULL,'','','Brett Elvis Booth Lane','jotedeqyb@mailinator.com',NULL,'$2y$10$56Eb0p0uvmfZZPzswO0FgurxjuAwezN.JzQg.vWKNaUsLRw5/t/ru',39,NULL,1,1,'2023-05-29 20:22:11','2023-05-29 20:22:11'),(381,'',NULL,'','','Simon Karen Wilkerson Burch','zufyhoseg@mailinator.com',NULL,'$2y$10$WQO29Tv5v4ss9fYNtT9ZnurwY3tc7H7xn4EIYRnAdAFEbXQorcsgm',39,NULL,1,1,'2023-05-29 20:23:32','2023-05-29 20:23:32'),(382,'',NULL,'','','Sylvester Flavia English Howe','sodydule@mailinator.com',NULL,'$2y$10$yLuam2h1ePfXBu64B2OzSeviAHHGfXxWHUoS/.zkQKPF8P.TexGfu',39,NULL,1,1,'2023-05-29 20:24:35','2023-05-29 20:24:35'),(383,'',NULL,'','','Alexander Orlando Landry Simon','byfam@mailinator.com',NULL,'$2y$10$Wy36ywC30icaJ4f1l3fCPOkv8NdWOrlW1F2Ok9tK9K5pk14vhnOyu',39,NULL,1,1,'2023-05-29 20:26:25','2023-05-29 20:26:25'),(390,'',NULL,'','','Dignesh  Parmar','dignesh.pixlogix@gmail.com',NULL,'$2y$10$RYVtBr/N8bgLzHG.HEXry..6y5Kcjm343H5FROEml6w3C12kGU/ei',39,'XvrChhz44DlqiTsqn0100VxXr5xlEA2BoQYDIecMob4gljCzl7w8I50sDUW2',0,1,'2023-05-30 21:16:40','2023-08-08 00:03:45'),(391,'Yogita','','Jadeja','','Yogita  Jadeja','yogita@pixlogix.com',NULL,'$2y$10$vGUooZRsb6zklYEW77Ve7OB65tUew4dxSTCGW5WEU1DaIALpLvvi2',39,'AyrKdYFfqXGt6tu7JJJ8qEdc0P4nflxLAcqwS85l4mtmILY4muNZDv89ZJ0e',1,1,'2023-05-30 21:18:28','2024-06-06 02:15:13'),(392,'',NULL,'','','Mihir  Jagada','mihir.jagada.pixlogix@gmail.com',NULL,'$2y$10$QkeA4ITbO4GPJZQb06kWoe4HIRPAhiFD3FnM3pwgTNvXz4pfkiZIO',39,'b3PEZoaZ0w3TPmiVaBHD1rvTNpnT8RDtPR2kRDz3zlUeAcknUWEvii95KZHl',0,1,'2023-05-30 21:32:46','2024-12-03 01:49:17'),(393,'Sonali','','Prajapati','','Sonali  Prajapati','sonali@pixlogix.com',NULL,'$2y$10$DLf044kbL9k/1AUGVl0bl.IGUiv9ogcjIdimI3bw6GOSaeebfG/li',39,'oVNfJh0F5BKLhPh89m43bdjrd4V4JyO6JY4cSHeYNxFVui5cSqCuslBiwP2l',0,1,'2023-06-27 03:31:51','2024-01-03 22:48:16'),(394,'',NULL,'','','Aqil  Badshah','aqil@pixlogix.com',NULL,'$2y$10$ATLBKPJfkQhf.UrqruYXiu0c.0fcpPUl9F2yQaA4Qb48hx0dsu/eS',39,'FOiwWzuDnrJK044rapHjXCxDwDps060zwUZ4hbznTkUTGBIFbt8AnOjCWSr3',0,1,'2023-06-27 03:46:38','2024-01-02 22:40:19'),(395,'',NULL,'','','Pavas  Dave','pavas@pixlogix.com',NULL,'2UXYxBvBEiD8IXKd9jqV9dzSoD4Cd48wOnkxrKcivjXPqzlHh4e1zZlfYHbp',39,'94sKuq7uWPR4gyr5DNsAcOzw24IjnTAfEukDZgqNaicDraRjwKY63QFxleNg',1,1,'2023-06-27 03:59:01','2023-09-12 20:30:41'),(396,'Kartik','','Kacha','','Kartik  Kacha','kartik@pixlogix.com',NULL,'$2y$10$IyEdUYAVorDpgtCghqbSt.5sSoQAzeLeOmy4xnPKymQROz26WWTGS',39,'iLGKgkcBjmW1ONP2fYuAnxVPSuWuw4MbjqlbPQeX8cuEaA3Y7loQPyKhsf4T',1,1,'2023-06-27 04:01:22','2023-12-09 00:56:40'),(397,'',NULL,'','','Dhaval  Prajapati','dhaval.pixlogix@gmail.com',NULL,'$2y$10$PPlKHzrYFEIzVDSiq7prQuwRaYng7SnLJV3HH2z3Dcr8y.7nqyU82',39,'PKuJX3ULXYe9bwaX3yc8aUkN0RHLMYgcx4NF9gX9gH50krYjvtqSrnj2eJ0s',0,1,'2023-06-27 04:03:05','2024-01-12 21:52:57'),(398,'',NULL,'','','Jeel  Kalsariya','jeel.pixlogix@gmail.com',NULL,'$2y$10$WNIEGo1JmC7B5b1CDDwfUuZu.M0buKycFaPiLigkpKHsAXiPtxgoW',39,'p5Ip5RRKjW0aBllVKlhyh8z6ilfG6jYMS20Otejx0949eiUNPriuQMvQar46',0,1,'2023-06-27 04:04:51','2024-02-01 04:33:32'),(401,'',NULL,'','','Prashant  Khanpara','prashant@pixlogix.com',NULL,'$2y$10$2OBpMhr5veY5eVXzPt7Rne6xH201lSewA4HBUEcyOW97Kw7g.dWiO',39,'4cJTOrUVePlE3goUNXa5iVjGzB84ITpJJdYSJ7ipz8Q8jQjubQaMYdzot6QX',0,1,'2023-07-05 04:54:21','2023-09-15 21:03:11'),(402,'',NULL,'','','Brijesh  Gandhi','brijesh@pixlogix.com',NULL,'$2y$10$7TC8V7EvhVgRFzSHzmSo9uYN5Y7/8MLGPr0S.aLIB0zVYfZVCzEqa',39,'DJ3eIGhH2WojqJtQVBJS1sD9LFB1pVAigpO3nYUsBwNKnozKPMKXZVyrAyBA',0,1,'2023-07-07 21:08:08','2023-09-01 21:48:53'),(404,'Kevin','C','Patel','','Kevin C Patel','ba@pixlogix.com',NULL,'$2y$10$U0NfM9MlisKjwbIq639awe//4M0GWAG.peIWilm5Tkml5tnUHPlxm',39,'H7alKRfLPF9fwCXk71k1x50JrlojF65dhrkkRlGMRT0OVBMNch6RLB3SzOzs',0,1,'2023-07-21 22:29:14','2024-07-01 21:43:53'),(405,'Harshad','','Hadiya','','Harshad  Hadiya','harshad.pixlogix@gmail.com',NULL,'$2y$10$gMhf5zA1/Nx67OkxGvFD/e1oZZvYKCjnJoPuEOh7JmtWl.emRhKjW',39,'v38ntMYb7hMAMOkjIUa0qn3bBNxUIOKRMgnpcNRjo0nC7KygMtGg3ZSY740C',1,1,'2023-07-21 22:37:17','2025-06-11 00:05:15'),(406,'Harshad','hhhh','Hadiya','74185296310','Harshad hhhh Hadiya','testsitecreate818@gmail.com',NULL,'$2y$10$H41A3OoKFh2SuLF06uXpVOAo.jkT4JUxPoZ8d27glW41TQiNZK6XW',131,'nm97soQomcIqwDgwXS47XwPh9GODfvqN0RWoe0EsrwtyuwmcF34w9X0vBmNL',1,0,'2023-07-27 01:44:49','2023-07-28 04:48:06'),(436,'Krupa','','Ladani','','Krupa  Ladani','krupa.pixlogix@gmail.com',NULL,'$2y$10$xWf0tEHdQ66evpCbuqSZxezqBxHF9Un5Gj3Bo9fLJwVbx9v/nzTvC',39,'iYBsYVwsdqviWhwpEOkoMbMWcHdcJUmSx14N7ObZYFrMLXVlXDnuJCDqFXtK',1,1,'2023-09-05 03:10:49','2023-09-11 23:01:01'),(438,'Ikramul','','Shekh','','Ikramul  Shekh','ikramul.pixlogix@gmail.com',NULL,'$2y$10$wGl7KWZjpgPBVlh8oXqWr.qu3tobrgeDdP/GH6MG5Nc9JRlfXvEKC',39,'xqs6H88otsXuUSjGNZMz0W0VXiaOW2JsHlvh8SE6eoJAQyqI8oaTTPfbjpue',0,1,'2023-10-07 03:42:51','2024-09-28 01:20:54'),(443,'',NULL,'','','Chirag Manishkumar Jalu','chirag@pixlogix.com',NULL,'$2y$10$ZHxvUsPH99V8TSnhQt7VeO40UjBmMryleyKBMvCrzAVviJr6QjpZm',39,'OxbrGQ02i6eOre6IjlSPeAeemKFR0PrAl4cNQwK1wXBOFNbtYaLWPse1lyjG',0,1,'2023-10-27 03:29:48','2024-04-03 21:54:29'),(444,'Preet','','Soni','','Preet  Soni','preet.pixlogix@gmail.com',NULL,'$2y$10$eclIBkrFmqSOpvv95YzMl.cf2BnpfhCLHZhpS0iFtEvQrjtwS/g8G',39,'2IKmSpNGLxIBjb6pii9YrJNvOtOsgMkM4m248JfdIGGjJdVBklc3AKWmJnN7',1,1,'2023-10-28 21:59:17','2023-12-09 01:05:39'),(445,'Avesh','','Baliwala','','Avesh  Baliwala','avesh.pixlogix@gmail.com',NULL,'$2y$10$zJj7yqdEOQx9hkrzxlMQ/OL7/UpYoV26VpG1NC.xlX.1hRUwPDXR.',39,'TePRHJcJSh7zLcekLL90xLD5WTcRT8VkCylsIbqbR7pIfb5QyR4vJlgaQFCy',0,1,'2023-12-01 21:07:19','2024-04-03 22:17:36'),(446,'Samir','','Bhimbha','','Samir  Bhimbha','info@pixlogix.com',NULL,'$2y$10$M04/9wipmVSx8v16MIGW7.xqotV6t7QeZS/.uNJxjkQGs90dlYjwm',39,'hQclkqkkF7roEb42Qul1APsqDFTek5PlEoFqGSJwSmXn8TAzpsf3Pp1YXVx0',1,1,'2023-12-20 04:51:26','2023-12-20 21:52:26'),(447,'',NULL,'','','Harshil  Mehta','harshil@pixlogix.com',NULL,'$2y$10$AHaBepv94xeD4Ve.jGsxCOngJhNDKmO6p3LMKHwlELaZCRIm9QTSC',39,'sYKfjgDLDinpzxFrkdY0Owa8txJ5cgLr15KiqBB38WzpKbqIS6Jvpfqv6KrO',0,1,'2024-01-02 00:06:13','2025-01-17 21:03:08'),(449,'',NULL,'','','Riddhi  Patel','riddhi@pixlogix.com',NULL,'$2y$10$OswNJzaCvNSEoZZfpIvTEuKGfPdnjc3xHM6Lj0ORHmOlWPRReo8.C',39,'cbFnDPZFq8DhtnrvZM9yY6k47Chx0CB9T9jDjlbFwvoBG4cTzrwvxBGtcJBD',0,1,'2024-02-03 02:50:21','2024-06-01 04:19:30'),(450,'HR','test','Testing','','HR test Testing','cajir93715@bitofee.com',NULL,'$2y$10$rOBLHGHfdD9FcU.cLtMWl.YkQ74BstBaXi.1CYMAgKRPzOChEk7bi',39,'WpuNGqWSzOxQRKWcboFPRWza3oEd89UW9qnhh6xMlRB4ydTr9FItDpzGeG4l',1,1,'2024-02-07 22:32:10','2024-02-08 04:08:27'),(451,'Employee','','Test','','Employee  Test','yehayi8917@alibrs.com',NULL,'$2y$10$NCQkm.WcSdaWlVFmSmQ7nuUwTaBn002QpG73AA20AKVgTKxzFAO3e',39,'UJWg6ErZ5BdUV3mogw3zpofS31CSNbZEmDMjFnLLeQOH0xIc23SoRgCsoFGn',1,1,'2024-02-07 22:33:56','2024-09-12 00:48:40'),(452,'Hardik','','Rathod','','Hardik  Rathod','hardikr@pixlogix.com',NULL,'$2y$10$FjIkoEU3IDiv55V3rCbZuOZmgRVqFzirLCG7muv2EAahHzXLAGemS',39,'6gsZIMqzrIEpMY18spA8KzluXqcylC7AXCwZMQiK4EXV5GCmAxUkmUdUVPXC',0,1,'2024-02-13 03:44:00','2024-06-29 01:53:44'),(453,'',NULL,'','','Kalpesh  Rajora','pc@pixlogix.com',NULL,'$2y$10$Xje6jd4dHar5j3Y1oCeH5ucsaFXe4A7gnpz3YV0AaHDNVBjEXK8o2',39,'xw9UjcabfVNItNfR6ekXuUSrI63M8jGMLL7hQFie5PcnhZfZcleBUlwOjMs5',0,1,'2024-02-20 03:40:39','2024-04-30 00:18:24'),(454,'',NULL,'','','Kevin  Patel','kevin@pixlogix.com',NULL,'$2y$10$jWQvR3gluA1OuHRJIFHzce8W6nrj2HVG2HLGXZLDKEdlmZi/QeXpq',39,'E4BWclajqXCoLtMeXLrX4ynFie6qhhXqexdYcFV857EYPfLo6mcjaJXT9M9P',0,1,'2024-03-23 01:26:07','2024-07-10 01:25:41'),(455,'Deeshit','','Parikh','','Deeshit  Parikh','deeshit@pixlogix.com',NULL,'$2y$10$hK4LF7Lr39F4TpSejwBNSeYcOVQ75MFSGJ5nIQAMzjgHTZohETMFC',39,'A3n5IPsbHsGsMGNCUCCpNiJcRZaNIkW44GtKn3RcUcejRT07p6rKovIXuBKF',1,1,'2024-05-25 02:15:44','2024-12-25 22:14:13'),(456,'Jigar','','Pandya','','Jigar  Pandya','jigar@pixlogix.com',NULL,'$2y$10$oyFHsyQxg3lct9FrLthpeexZpUCDutZRq.cxQ.ngvi9KCEouAR/Q.',39,'2EXvUP9jWVKD9Bccyhbl4t7CUcfOeGDAOdxDgeyFbiGY84cCfXxeiNIsxRnh',0,1,'2024-06-28 23:38:11','2025-03-17 21:00:01'),(457,'Priya','','Bhavsar','','Priya  Bhavsar','priya@pixlogix.com',NULL,'$2y$10$2s5WBwuxtl8nEMzUqXnfjeoB/0exkzZDU57O7BiZGPDU.D9N74SJS',39,'xwBfwFsdpyp3iO026VDTTlqnZnKiRduQBARTjoWVfwEDB4tZaVmFGL2F2VCp',1,1,'2025-01-06 21:21:00','2025-01-07 03:34:53'),(458,'Priyanka','','Jethva','','Priyanka  Jethva','priyanka@pixlogix.com',NULL,'$2y$10$S0qDllSW8H67GDqyVd5ZP.3dCAl.CdDkksJ5AAaIwXLazWj4b3GZq',39,'nIK5PjHh3JiJSx20edIWKr9yGtiERATNYLmrQ9UKMZRln33bU9bXrxXap5yR',1,1,'2025-01-19 00:04:02','2025-01-20 19:57:17'),(459,'Vanita','','Ambaliya','','Vanita  Ambaliya','vanita.pixlogix@gmail.com',NULL,'$2y$10$cTcywpcuM6oq2fteJdWUkeTZToYFCpzh3vwQBBG3KGjFInUJHJRp6',39,'JaN94LikmFv9dQNHc0mng5awGlKB58vkLewIqO9ChktHIcLXW0P3CGtiVEJ9',1,1,'2025-03-08 00:58:12','2025-03-10 21:23:02'),(460,'Prince','','Patel','','Prince  Patel','prince.pixlogix@gmail.com',NULL,'$2y$10$3uGG62dJVy5siFiCDj5j...JEUngLI2D79aOafCBUHyRk4uhtiJZm',39,'OlZSARdiYyAFCJQSjgpXtDKIinoOjOoC3x2tLn8rOq89QmjoyhveI5Q4pSx6',1,1,'2025-04-21 20:20:56','2025-04-22 22:23:19'),(461,'Nishi','','Patel','','Nishi  Patel','nishi@pixlogix.com',NULL,'$2y$10$xW8rO/oviJD4ugwZPdVgg.hoDc3QAx3pGtNGObpJ7g1mki5vJw1Ti',39,NULL,1,1,'2025-06-14 00:09:17','2025-06-14 00:09:17');

--
-- Table structure for table `worklog_tasks`
--

CREATE TABLE `worklog_tasks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `worklog_id` bigint(20) unsigned NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `project_id` bigint(20) unsigned NOT NULL,
  `client_name` varchar(255) NOT NULL,
  `project_name` varchar(255) NOT NULL,
  `scope` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `status` varchar(255) NOT NULL,
  `hours` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `worklog_tasks_employee_id_foreign` (`employee_id`),
  KEY `worklog_tasks_worklog_id_foreign` (`worklog_id`),
  KEY `worklog_tasks_client_id_foreign` (`client_id`),
  KEY `worklog_tasks_project_id_foreign` (`project_id`),
  CONSTRAINT `worklog_tasks_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
  CONSTRAINT `worklog_tasks_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  CONSTRAINT `worklog_tasks_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`),
  CONSTRAINT `worklog_tasks_worklog_id_foreign` FOREIGN KEY (`worklog_id`) REFERENCES `worklogs` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `worklog_tasks`
--


--
-- Table structure for table `worklogs`
--

CREATE TABLE `worklogs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `date` date NOT NULL,
  `total_hours` double(8,2) NOT NULL,
  `time_difference` double(8,2) NOT NULL DEFAULT 0.00,
  `hrm_hours` time NOT NULL DEFAULT '00:00:00',
  `status` tinyint(1) DEFAULT NULL,
  `is_requested` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `worklogs_employee_id_foreign` (`employee_id`),
  CONSTRAINT `worklogs_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `worklogs`
--



