OwlCyberSecurity - MANAGER

Edit File: LeaveManagementSystem-out.log

✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d';
Sequelize: Executing (default): UPDATE `Leaves` SET `createdAt`=?,`updatedAt`=? WHERE `LeaveID` = ?
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `YearlyLeave` AS `YearlyLeave` ORDER BY `YearlyLeave`.`yearlyLeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `YearlyLeave` AS `YearlyLeave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`Email` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): INSERT INTO `Employee` (`EmployeeId`,`EmployeeName`,`Email`,`Designation`,`Department`,`JoiningDate`,`createdAt`,`updatedAt`) VALUES (?,?,?,?,?,?,?,?);
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`Email` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`Email` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`Email` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `YearlyLeave` AS `YearlyLeave` ORDER BY `YearlyLeave`.`yearlyLeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `YearlyLeave` AS `YearlyLeave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '441a6368-d7a7-4739-b5b8-272a30a24b57';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`Email` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` WHERE `Employee`.`EmployeeId` = '5d07a198-9a09-4606-b778-1e68a5999808';
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`Email` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`Email` DESC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`Email` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`Email` DESC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '441a6368-d7a7-4739-b5b8-272a30a24b57';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '441a6368-d7a7-4739-b5b8-272a30a24b57';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`Email` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `YearlyLeave` AS `YearlyLeave` ORDER BY `YearlyLeave`.`yearlyLeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `YearlyLeave` AS `YearlyLeave`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`Email` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`Email` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = 'c7f59370-42ee-487a-bc53-d41ffc9f1c5f';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`Email` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` WHERE `Employee`.`EmployeeId` = '5d07a198-9a09-4606-b778-1e68a5999808';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`Email` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`Email` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '441a6368-d7a7-4739-b5b8-272a30a24b57';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '441a6368-d7a7-4739-b5b8-272a30a24b57';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '441a6368-d7a7-4739-b5b8-272a30a24b57';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` WHERE `Employee`.`EmployeeId` = '5d07a198-9a09-4606-b778-1e68a5999808';
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '441a6368-d7a7-4739-b5b8-272a30a24b57';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `YearlyLeave` AS `YearlyLeave` ORDER BY `YearlyLeave`.`yearlyLeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `YearlyLeave` AS `YearlyLeave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Submit Leave API hit with body: {
  EmployeeName: 'Iqra',
  Department: 'Marketing ',
  Designation: 'Intern',
  LeaveType: 'Sick',
  StartDate: '2025-06-02T06:15:20.243Z',
  EndDate: '2025-06-02T06:15:00.000Z',
  Reason: 'Fever'
}
Sequelize Create: Executing (default): INSERT INTO `Leaves` (`LeaveID`,`EmployeeId`,`EmployeeName`,`Department`,`Designation`,`LeaveType`,`StartDate`,`EndDate`,`Reason`,`createdAt`,`updatedAt`) VALUES (?,?,?,?,?,?,?,?,?,?,?);
✅ Leave record created: {
  LeaveID: '0fc24597-3ccd-4b99-aa8c-124c86805ae0',
  EmployeeId: null,
  EmployeeName: 'Iqra',
  Department: 'Marketing ',
  Designation: 'Intern',
  LeaveType: 'Sick',
  StartDate: '2025-06-02',
  EndDate: '2025-06-02',
  Reason: 'Fever',
  updatedAt: 2025-06-02T06:16:14.358Z,
  createdAt: 2025-06-02T06:16:14.358Z
}
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employee` ORDER BY `Employee`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employee`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leaves`;
DATA: [
  {
    LeaveID: '0fc24597-3ccd-4b99-aa8c-124c86805ae0',
    EmployeeId: null,
    EmployeeName: 'Iqra',
    Department: 'Marketing ',
    Designation: 'Intern',
    LeaveType: 'Sick',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-06-02T06:16:14.000Z,
    updatedAt: 2025-06-02T06:16:14.000Z
  },
  {
    LeaveID: '441a6368-d7a7-4739-b5b8-272a30a24b57',
    EmployeeId: null,
    EmployeeName: 'Aroosa Shahwar',
    Department: 'IT',
    Designation: 'Intern',
    LeaveType: 'Casual Leave',
    StartDate: '2025-05-29',
    EndDate: '2025-05-30',
    Reason: 'Work',
    createdAt: 2025-05-30T05:57:51.000Z,
    updatedAt: 2025-05-30T05:57:51.000Z
  },
  {
    LeaveID: 'c7f59370-42ee-487a-bc53-d41ffc9f1c5f',
    EmployeeId: null,
    EmployeeName: 'Tehniyat Zahid',
    Department: 'IT',
    Designation: 'Intern ',
    LeaveType: 'Sick Leave',
    StartDate: '2025-05-31',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-05-31T05:37:21.000Z,
    updatedAt: 2025-05-31T05:37:21.000Z
  },
  {
    LeaveID: 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d',
    EmployeeId: null,
    EmployeeName: 'Shahwar',
    Department: 'IT',
    Designation: 'Android Developer',
    LeaveType: 'Casual Leave',
    StartDate: '2025-06-01',
    EndDate: '2025-06-02',
    Reason: "I'm out of town",
    createdAt: 2025-05-30T09:33:41.000Z,
    updatedAt: 2025-05-31T05:51:53.000Z
  },
  {
    LeaveID: 'f1160593-4688-4a30-97cc-0162bb73b3b6',
    EmployeeId: null,
    EmployeeName: 'Ar',
    Department: 'Hk',
    Designation: 'Bn',
    LeaveType: 'Vbj',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Vgh',
    createdAt: 2025-06-02T08:14:50.000Z,
    updatedAt: 2025-06-02T08:14:50.000Z
  }
]
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leaves`;
DATA: [
  {
    LeaveID: '0fc24597-3ccd-4b99-aa8c-124c86805ae0',
    EmployeeId: null,
    EmployeeName: 'Iqra',
    Department: 'Marketing ',
    Designation: 'Intern',
    LeaveType: 'Sick',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-06-02T06:16:14.000Z,
    updatedAt: 2025-06-02T06:16:14.000Z
  },
  {
    LeaveID: '441a6368-d7a7-4739-b5b8-272a30a24b57',
    EmployeeId: null,
    EmployeeName: 'Aroosa Shahwar',
    Department: 'IT',
    Designation: 'Intern',
    LeaveType: 'Casual Leave',
    StartDate: '2025-05-29',
    EndDate: '2025-05-30',
    Reason: 'Work',
    createdAt: 2025-05-30T05:57:51.000Z,
    updatedAt: 2025-05-30T05:57:51.000Z
  },
  {
    LeaveID: 'c7f59370-42ee-487a-bc53-d41ffc9f1c5f',
    EmployeeId: null,
    EmployeeName: 'Tehniyat Zahid',
    Department: 'IT',
    Designation: 'Intern ',
    LeaveType: 'Sick Leave',
    StartDate: '2025-05-31',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-05-31T05:37:21.000Z,
    updatedAt: 2025-05-31T05:37:21.000Z
  },
  {
    LeaveID: 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d',
    EmployeeId: null,
    EmployeeName: 'Shahwar',
    Department: 'IT',
    Designation: 'Android Developer',
    LeaveType: 'Casual Leave',
    StartDate: '2025-06-01',
    EndDate: '2025-06-02',
    Reason: "I'm out of town",
    createdAt: 2025-05-30T09:33:41.000Z,
    updatedAt: 2025-05-31T05:51:53.000Z
  },
  {
    LeaveID: 'f1160593-4688-4a30-97cc-0162bb73b3b6',
    EmployeeId: null,
    EmployeeName: 'Ar',
    Department: 'Hk',
    Designation: 'Bn',
    LeaveType: 'Vbj',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Vgh',
    createdAt: 2025-06-02T08:14:50.000Z,
    updatedAt: 2025-06-02T08:14:50.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leaves`;
DATA: [
  {
    LeaveID: '0fc24597-3ccd-4b99-aa8c-124c86805ae0',
    EmployeeId: null,
    EmployeeName: 'Iqra',
    Department: 'Marketing ',
    Designation: 'Intern',
    LeaveType: 'Sick',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-06-02T06:16:14.000Z,
    updatedAt: 2025-06-02T06:16:14.000Z
  },
  {
    LeaveID: '441a6368-d7a7-4739-b5b8-272a30a24b57',
    EmployeeId: null,
    EmployeeName: 'Aroosa Shahwar',
    Department: 'IT',
    Designation: 'Intern',
    LeaveType: 'Casual Leave',
    StartDate: '2025-05-29',
    EndDate: '2025-05-30',
    Reason: 'Work',
    createdAt: 2025-05-30T05:57:51.000Z,
    updatedAt: 2025-05-30T05:57:51.000Z
  },
  {
    LeaveID: 'c7f59370-42ee-487a-bc53-d41ffc9f1c5f',
    EmployeeId: null,
    EmployeeName: 'Tehniyat Zahid',
    Department: 'IT',
    Designation: 'Intern ',
    LeaveType: 'Sick Leave',
    StartDate: '2025-05-31',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-05-31T05:37:21.000Z,
    updatedAt: 2025-05-31T05:37:21.000Z
  },
  {
    LeaveID: 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d',
    EmployeeId: null,
    EmployeeName: 'Shahwar',
    Department: 'IT',
    Designation: 'Android Developer',
    LeaveType: 'Casual Leave',
    StartDate: '2025-06-01',
    EndDate: '2025-06-02',
    Reason: "I'm out of town",
    createdAt: 2025-05-30T09:33:41.000Z,
    updatedAt: 2025-05-31T05:51:53.000Z
  },
  {
    LeaveID: 'f1160593-4688-4a30-97cc-0162bb73b3b6',
    EmployeeId: null,
    EmployeeName: 'Ar',
    Department: 'Hk',
    Designation: 'Bn',
    LeaveType: 'Vbj',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Vgh',
    createdAt: 2025-06-02T08:14:50.000Z,
    updatedAt: 2025-06-02T08:14:50.000Z
  }
]
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leaves`;
DATA: [
  {
    LeaveID: '0fc24597-3ccd-4b99-aa8c-124c86805ae0',
    EmployeeId: null,
    EmployeeName: 'Iqra',
    Department: 'Marketing ',
    Designation: 'Intern',
    LeaveType: 'Sick',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-06-02T06:16:14.000Z,
    updatedAt: 2025-06-02T06:16:14.000Z
  },
  {
    LeaveID: '441a6368-d7a7-4739-b5b8-272a30a24b57',
    EmployeeId: null,
    EmployeeName: 'Aroosa Shahwar',
    Department: 'IT',
    Designation: 'Intern',
    LeaveType: 'Casual Leave',
    StartDate: '2025-05-29',
    EndDate: '2025-05-30',
    Reason: 'Work',
    createdAt: 2025-05-30T05:57:51.000Z,
    updatedAt: 2025-05-30T05:57:51.000Z
  },
  {
    LeaveID: 'c7f59370-42ee-487a-bc53-d41ffc9f1c5f',
    EmployeeId: null,
    EmployeeName: 'Tehniyat Zahid',
    Department: 'IT',
    Designation: 'Intern ',
    LeaveType: 'Sick Leave',
    StartDate: '2025-05-31',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-05-31T05:37:21.000Z,
    updatedAt: 2025-05-31T05:37:21.000Z
  },
  {
    LeaveID: 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d',
    EmployeeId: null,
    EmployeeName: 'Shahwar',
    Department: 'IT',
    Designation: 'Android Developer',
    LeaveType: 'Casual Leave',
    StartDate: '2025-06-01',
    EndDate: '2025-06-02',
    Reason: "I'm out of town",
    createdAt: 2025-05-30T09:33:41.000Z,
    updatedAt: 2025-05-31T05:51:53.000Z
  },
  {
    LeaveID: 'f1160593-4688-4a30-97cc-0162bb73b3b6',
    EmployeeId: null,
    EmployeeName: 'Ar',
    Department: 'Hk',
    Designation: 'Bn',
    LeaveType: 'Vbj',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Vgh',
    createdAt: 2025-06-02T08:14:50.000Z,
    updatedAt: 2025-06-02T08:14:50.000Z
  }
]
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leaves`;
DATA: [
  {
    LeaveID: '0fc24597-3ccd-4b99-aa8c-124c86805ae0',
    EmployeeId: null,
    EmployeeName: 'Iqra',
    Department: 'Marketing ',
    Designation: 'Intern',
    LeaveType: 'Sick',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-06-02T06:16:14.000Z,
    updatedAt: 2025-06-02T06:16:14.000Z
  },
  {
    LeaveID: '441a6368-d7a7-4739-b5b8-272a30a24b57',
    EmployeeId: null,
    EmployeeName: 'Aroosa Shahwar',
    Department: 'IT',
    Designation: 'Intern',
    LeaveType: 'Casual Leave',
    StartDate: '2025-05-29',
    EndDate: '2025-05-30',
    Reason: 'Work',
    createdAt: 2025-05-30T05:57:51.000Z,
    updatedAt: 2025-05-30T05:57:51.000Z
  },
  {
    LeaveID: 'c7f59370-42ee-487a-bc53-d41ffc9f1c5f',
    EmployeeId: null,
    EmployeeName: 'Tehniyat Zahid',
    Department: 'IT',
    Designation: 'Intern ',
    LeaveType: 'Sick Leave',
    StartDate: '2025-05-31',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-05-31T05:37:21.000Z,
    updatedAt: 2025-05-31T05:37:21.000Z
  },
  {
    LeaveID: 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d',
    EmployeeId: null,
    EmployeeName: 'Shahwar',
    Department: 'IT',
    Designation: 'Android Developer',
    LeaveType: 'Casual Leave',
    StartDate: '2025-06-01',
    EndDate: '2025-06-02',
    Reason: "I'm out of town",
    createdAt: 2025-05-30T09:33:41.000Z,
    updatedAt: 2025-05-31T05:51:53.000Z
  },
  {
    LeaveID: 'f1160593-4688-4a30-97cc-0162bb73b3b6',
    EmployeeId: null,
    EmployeeName: 'Ar',
    Department: 'Hk',
    Designation: 'Bn',
    LeaveType: 'Vbj',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Vgh',
    createdAt: 2025-06-02T08:14:50.000Z,
    updatedAt: 2025-06-02T08:14:50.000Z
  }
]
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` WHERE `Employees`.`EmployeeId` = '5d07a198-9a09-4606-b778-1e68a5999808';
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leaves`;
DATA: [
  {
    LeaveID: '0fc24597-3ccd-4b99-aa8c-124c86805ae0',
    EmployeeId: null,
    EmployeeName: 'Iqra',
    Department: 'Marketing ',
    Designation: 'Intern',
    LeaveType: 'Sick',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-06-02T06:16:14.000Z,
    updatedAt: 2025-06-02T06:16:14.000Z
  },
  {
    LeaveID: '441a6368-d7a7-4739-b5b8-272a30a24b57',
    EmployeeId: null,
    EmployeeName: 'Aroosa Shahwar',
    Department: 'IT',
    Designation: 'Intern',
    LeaveType: 'Casual Leave',
    StartDate: '2025-05-29',
    EndDate: '2025-05-30',
    Reason: 'Work',
    createdAt: 2025-05-30T05:57:51.000Z,
    updatedAt: 2025-05-30T05:57:51.000Z
  },
  {
    LeaveID: 'c7f59370-42ee-487a-bc53-d41ffc9f1c5f',
    EmployeeId: null,
    EmployeeName: 'Tehniyat Zahid',
    Department: 'IT',
    Designation: 'Intern ',
    LeaveType: 'Sick Leave',
    StartDate: '2025-05-31',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-05-31T05:37:21.000Z,
    updatedAt: 2025-05-31T05:37:21.000Z
  },
  {
    LeaveID: 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d',
    EmployeeId: null,
    EmployeeName: 'Shahwar',
    Department: 'IT',
    Designation: 'Android Developer',
    LeaveType: 'Casual Leave',
    StartDate: '2025-06-01',
    EndDate: '2025-06-02',
    Reason: "I'm out of town",
    createdAt: 2025-05-30T09:33:41.000Z,
    updatedAt: 2025-05-31T05:51:53.000Z
  },
  {
    LeaveID: 'f1160593-4688-4a30-97cc-0162bb73b3b6',
    EmployeeId: null,
    EmployeeName: 'Ar',
    Department: 'Hk',
    Designation: 'Bn',
    LeaveType: 'Vbj',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Vgh',
    createdAt: 2025-06-02T08:14:50.000Z,
    updatedAt: 2025-06-02T08:14:50.000Z
  }
]
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leaves`;
DATA: [
  {
    LeaveID: '0fc24597-3ccd-4b99-aa8c-124c86805ae0',
    EmployeeId: null,
    EmployeeName: 'Iqra',
    Department: 'Marketing ',
    Designation: 'Intern',
    LeaveType: 'Sick',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-06-02T06:16:14.000Z,
    updatedAt: 2025-06-02T06:16:14.000Z
  },
  {
    LeaveID: '441a6368-d7a7-4739-b5b8-272a30a24b57',
    EmployeeId: null,
    EmployeeName: 'Aroosa Shahwar',
    Department: 'IT',
    Designation: 'Intern',
    LeaveType: 'Casual Leave',
    StartDate: '2025-05-29',
    EndDate: '2025-05-30',
    Reason: 'Work',
    createdAt: 2025-05-30T05:57:51.000Z,
    updatedAt: 2025-05-30T05:57:51.000Z
  },
  {
    LeaveID: 'c7f59370-42ee-487a-bc53-d41ffc9f1c5f',
    EmployeeId: null,
    EmployeeName: 'Tehniyat Zahid',
    Department: 'IT',
    Designation: 'Intern ',
    LeaveType: 'Sick Leave',
    StartDate: '2025-05-31',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-05-31T05:37:21.000Z,
    updatedAt: 2025-05-31T05:37:21.000Z
  },
  {
    LeaveID: 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d',
    EmployeeId: null,
    EmployeeName: 'Shahwar',
    Department: 'IT',
    Designation: 'Android Developer',
    LeaveType: 'Casual Leave',
    StartDate: '2025-06-01',
    EndDate: '2025-06-02',
    Reason: "I'm out of town",
    createdAt: 2025-05-30T09:33:41.000Z,
    updatedAt: 2025-05-31T05:51:53.000Z
  },
  {
    LeaveID: 'f1160593-4688-4a30-97cc-0162bb73b3b6',
    EmployeeId: null,
    EmployeeName: 'Ar',
    Department: 'Hk',
    Designation: 'Bn',
    LeaveType: 'Vbj',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Vgh',
    createdAt: 2025-06-02T08:14:50.000Z,
    updatedAt: 2025-06-02T08:14:50.000Z
  }
]
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leaves`;
DATA: [
  {
    LeaveID: '0fc24597-3ccd-4b99-aa8c-124c86805ae0',
    EmployeeId: null,
    EmployeeName: 'Iqra',
    Department: 'Marketing ',
    Designation: 'Intern',
    LeaveType: 'Sick',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-06-02T06:16:14.000Z,
    updatedAt: 2025-06-02T06:16:14.000Z
  },
  {
    LeaveID: '441a6368-d7a7-4739-b5b8-272a30a24b57',
    EmployeeId: null,
    EmployeeName: 'Aroosa Shahwar',
    Department: 'IT',
    Designation: 'Intern',
    LeaveType: 'Casual Leave',
    StartDate: '2025-05-29',
    EndDate: '2025-05-30',
    Reason: 'Work',
    createdAt: 2025-05-30T05:57:51.000Z,
    updatedAt: 2025-05-30T05:57:51.000Z
  },
  {
    LeaveID: 'c7f59370-42ee-487a-bc53-d41ffc9f1c5f',
    EmployeeId: null,
    EmployeeName: 'Tehniyat Zahid',
    Department: 'IT',
    Designation: 'Intern ',
    LeaveType: 'Sick Leave',
    StartDate: '2025-05-31',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-05-31T05:37:21.000Z,
    updatedAt: 2025-05-31T05:37:21.000Z
  },
  {
    LeaveID: 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d',
    EmployeeId: null,
    EmployeeName: 'Shahwar',
    Department: 'IT',
    Designation: 'Android Developer',
    LeaveType: 'Casual Leave',
    StartDate: '2025-06-01',
    EndDate: '2025-06-02',
    Reason: "I'm out of town",
    createdAt: 2025-05-30T09:33:41.000Z,
    updatedAt: 2025-05-31T05:51:53.000Z
  },
  {
    LeaveID: 'f1160593-4688-4a30-97cc-0162bb73b3b6',
    EmployeeId: null,
    EmployeeName: 'Ar',
    Department: 'Hk',
    Designation: 'Bn',
    LeaveType: 'Vbj',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Vgh',
    createdAt: 2025-06-02T08:14:50.000Z,
    updatedAt: 2025-06-02T08:14:50.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leaves`;
DATA: [
  {
    LeaveID: '0fc24597-3ccd-4b99-aa8c-124c86805ae0',
    EmployeeId: null,
    EmployeeName: 'Iqra',
    Department: 'Marketing ',
    Designation: 'Intern',
    LeaveType: 'Sick',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-06-02T06:16:14.000Z,
    updatedAt: 2025-06-02T06:16:14.000Z
  },
  {
    LeaveID: '441a6368-d7a7-4739-b5b8-272a30a24b57',
    EmployeeId: null,
    EmployeeName: 'Aroosa Shahwar',
    Department: 'IT',
    Designation: 'Intern',
    LeaveType: 'Casual Leave',
    StartDate: '2025-05-29',
    EndDate: '2025-05-30',
    Reason: 'Work',
    createdAt: 2025-05-30T05:57:51.000Z,
    updatedAt: 2025-05-30T05:57:51.000Z
  },
  {
    LeaveID: 'c7f59370-42ee-487a-bc53-d41ffc9f1c5f',
    EmployeeId: null,
    EmployeeName: 'Tehniyat Zahid',
    Department: 'IT',
    Designation: 'Intern ',
    LeaveType: 'Sick Leave',
    StartDate: '2025-05-31',
    EndDate: '2025-06-02',
    Reason: 'Fever',
    createdAt: 2025-05-31T05:37:21.000Z,
    updatedAt: 2025-05-31T05:37:21.000Z
  },
  {
    LeaveID: 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d',
    EmployeeId: null,
    EmployeeName: 'Shahwar',
    Department: 'IT',
    Designation: 'Android Developer',
    LeaveType: 'Casual Leave',
    StartDate: '2025-06-01',
    EndDate: '2025-06-02',
    Reason: "I'm out of town",
    createdAt: 2025-05-30T09:33:41.000Z,
    updatedAt: 2025-05-31T05:51:53.000Z
  },
  {
    LeaveID: 'f1160593-4688-4a30-97cc-0162bb73b3b6',
    EmployeeId: null,
    EmployeeName: 'Ar',
    Department: 'Hk',
    Designation: 'Bn',
    LeaveType: 'Vbj',
    StartDate: '2025-06-02',
    EndDate: '2025-06-02',
    Reason: 'Vgh',
    createdAt: 2025-06-02T08:14:50.000Z,
    updatedAt: 2025-06-02T08:14:50.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` WHERE `Leaves`.`LeaveID` = '441a6368-d7a7-4739-b5b8-272a30a24b57';
❌ Validation failed, missing required fields: {
  LeaveID: 'L001',
  EmpNo: 'EMP001',
  EmpStatus: 'Regular',
  EmployeeName: 'AROOSA',
  Designation: 'Android Developer',
  Department: 'IT',
  LeaveType: 'Sick',
  NoOfDaysRequired: 2,
  DateOfLeaveFrom: '2025-06-10',
  DateOfLeaveTo: '2025-06-11',
  LeavePurpose: 'High fever',
  DateOfApplied: '2025-06-01',
  LeaveRecommended: 'Manager',
  AvailedLeaveML: 3,
  AvailedLeaveCL: 2,
  AvailedBalanceML: 5,
  AvailedBalanceCL: 4
}
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves`;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` WHERE `Leaves`.`LeaveID` = '5d07a198-9a09-4606-b778-1e68a5999808';
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves`;
❌ Validation failed, missing required fields: {
  LeaveID: 'L002',
  EmpNo: 'EMP002',
  EmpStatus: 'Contract',
  EmployeeName: 'Zara Ahmed',
  Designation: 'HR Manager',
  Department: 'HR',
  LeaveType: 'Casual',
  NoOfDaysRequired: 1,
  DateOfLeaveFrom: '2025-06-05',
  DateOfLeaveTo: '2025-06-05',
  LeavePurpose: 'Personal work',
  DateOfApplied: '2025-06-02',
  LeaveRecommended: 'HR Lead',
  AvailedLeaveML: 1,
  AvailedLeaveCL: 3,
  AvailedBalanceML: 9,
  AvailedBalanceCL: 7
}
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves`;
❌ Validation failed, missing required fields: {
  LeaveID: 'L001',
  EmpNo: 'EMP001',
  EmpStatus: 'Regular',
  EmployeeName: 'Ali Raza',
  Designation: 'Software Engineer',
  Department: 'IT',
  LeaveType: 'Casual',
  NoOfDaysRequired: 2,
  DateOfLeaveFrom: '2025-06-03',
  DateOfLeaveTo: '2025-06-04',
  LeavePurpose: 'Personal reasons',
  DateOfApplied: '2025-06-02',
  LeaveRecommended: 'IT Head',
  AvailedLeaveML: 0,
  AvailedLeaveCL: 1,
  AvailedBalanceML: 10,
  AvailedBalanceCL: 9
}
❌ Validation failed, missing required fields: {
  LeaveID: 'L001',
  EmpNo: 'EMP001',
  EmpStatus: 'Regular',
  EmployeeName: 'Ali Raza',
  Designation: 'Software Engineer',
  Department: 'IT',
  LeaveType: 'Casual',
  NoOfDaysRequired: 2,
  DateOfLeaveFrom: '2025-06-03',
  DateOfLeaveTo: '2025-06-04',
  LeavePurpose: 'Personal reasons',
  DateOfApplied: '2025-06-02',
  LeaveRecommended: 'IT Head',
  AvailedLeaveML: 0,
  AvailedLeaveCL: 1,
  AvailedBalanceML: 10,
  AvailedBalanceCL: 9
}
❌ Validation failed, missing required fields: {
  LeaveID: 'L001',
  EmpNo: 'EMP001',
  EmpStatus: 'Regular',
  EmployeeName: 'Ali Raza',
  Designation: 'Software Engineer',
  Department: 'IT',
  LeaveType: 'Casual',
  NoOfDaysRequired: 2,
  DateOfLeaveFrom: '2025-06-03',
  DateOfLeaveTo: '2025-06-04',
  LeavePurpose: 'Personal reasons',
  DateOfApplied: '2025-06-02',
  LeaveRecommended: 'IT Head',
  AvailedLeaveML: 0,
  AvailedLeaveCL: 1,
  AvailedBalanceML: 10,
  AvailedBalanceCL: 9
}
❌ Validation failed, missing required fields: {
  LeaveID: 'L001',
  EmpNo: 'EMP001',
  EmpStatus: 'Regular',
  EmployeeName: 'Ali Raza',
  Designation: 'Software Engineer',
  Department: 'IT',
  LeaveType: 'Casual',
  NoOfDaysRequired: 2,
  DateOfLeaveFrom: '2025-06-03',
  DateOfLeaveTo: '2025-06-04',
  LeavePurpose: 'Personal reasons',
  DateOfApplied: '2025-06-02',
  LeaveRecommended: 'IT Head',
  AvailedLeaveML: 0,
  AvailedLeaveCL: 1,
  AvailedBalanceML: 10,
  AvailedBalanceCL: 9
}
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `YearlyLeave` AS `YearlyLeave` ORDER BY `YearlyLeave`.`yearlyLeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `YearlyLeave` AS `YearlyLeave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
❌ Validation failed, missing required fields: {
  LeaveID: 'L001',
  EmpNo: 'EMP001',
  EmpStatus: 'Regular',
  EmployeeName: 'Ali Raza',
  Designation: 'Software Engineer',
  Department: 'IT',
  LeaveType: 'Casual',
  NoOfDaysRequired: 2,
  DateOfLeaveFrom: '2025-06-03',
  DateOfLeaveTo: '2025-06-04',
  LeavePurpose: 'Personal reasons',
  DateOfApplied: '2025-06-02',
  LeaveRecommended: 'IT Head',
  AvailedLeaveML: 0,
  AvailedLeaveCL: 1,
  AvailedBalanceML: 10,
  AvailedBalanceCL: 9
}
❌ Validation failed, missing required fields: {
  LeaveID: 'L001',
  EmpNo: 'EMP001',
  EmpStatus: 'Regular',
  EmployeeName: 'John Doe',
  Designation: 'Developer',
  Department: 'IT',
  LeaveType: 'Sick',
  NoOfDaysRequired: 2,
  DateOfLeaveFrom: '2025-06-10',
  DateOfLeaveTo: '2025-06-11',
  LeavePurpose: 'Fever and rest',
  DateOfApplied: '2025-06-01',
  LeaveRecommended: 'Manager',
  AvailedLeaveML: 2,
  AvailedLeaveCL: 3,
  AvailedBalanceML: 5,
  AvailedBalanceCL: 4,
  LeaveStatus: 'Pending'
}
❌ Validation failed, missing required fields: {
  LeaveID: 'L001',
  EmpNo: 'EMP001',
  EmpStatus: 'Regular',
  EmployeeName: 'John Doe',
  Designation: 'Developer',
  Department: 'IT',
  LeaveType: 'Sick',
  NoOfDaysRequired: 2,
  DateOfLeaveFrom: '2025-06-10',
  DateOfLeaveTo: '2025-06-11',
  LeavePurpose: 'Fever and rest',
  DateOfApplied: '2025-06-01',
  LeaveRecommended: 'Manager',
  AvailedLeaveML: 2,
  AvailedLeaveCL: 3,
  AvailedBalanceML: 5,
  AvailedBalanceCL: 4,
  LeaveStatus: 'Pending'
}
❌ Validation failed, missing required fields: {
  LeaveID: 'L001',
  EmpNo: 'EMP001',
  EmpStatus: 'Regular',
  EmployeeName: 'John Doe',
  Designation: 'Developer',
  Department: 'IT',
  LeaveType: 'Sick',
  NoOfDaysRequired: 2,
  DateOfLeaveFrom: '2025-06-10',
  DateOfLeaveTo: '2025-06-11',
  LeavePurpose: 'Fever and rest',
  DateOfApplied: '2025-06-01',
  LeaveRecommended: 'Manager',
  AvailedLeaveML: 2,
  AvailedLeaveCL: 3,
  AvailedBalanceML: 5,
  AvailedBalanceCL: 4,
  LeaveStatus: 'Pending'
}
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmployeeName`, `Department`, `Designation`, `LeaveType`, `StartDate`, `EndDate`, `Reason`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leaves` ORDER BY `Leaves`.`LeaveID` ASC LIMIT 0, 10;
❌ Validation failed, missing required fields: {
  LeaveID: 'L001',
  EmpNo: 'EMP001',
  EmpStatus: 'Regular',
  EmployeeName: 'John Doe',
  Designation: 'Developer',
  Department: 'IT',
  LeaveType: 'Sick',
  NoOfDaysRequired: 2,
  DateOfLeaveFrom: '2025-06-10',
  DateOfLeaveTo: '2025-06-11',
  LeavePurpose: 'Fever and rest',
  DateOfApplied: '2025-06-01',
  LeaveRecommended: 'Manager',
  AvailedLeaveML: 2,
  AvailedLeaveCL: 3,
  AvailedBalanceML: 5,
  AvailedBalanceCL: 4,
  LeaveStatus: 'Pending'
}
✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`createdAt` DESC LIMIT 1;
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize Create: Executing (default): INSERT INTO `Leaves` (`LeaveID`,`EmpNo`,`EmpStatus`,`EmployeeName`,`Designation`,`Department`,`LeaveType`,`NoOfDaysRequired`,`DateOfLeaveFrom`,`DateOfLeaveTo`,`LeavePurpose`,`DateOfApplied`,`LeaveRecommended`,`AvailedLeaveML`,`AvailedLeaveCL`,`AvailedBalanceML`,`AvailedBalanceCL`,`LeaveStatus`,`createdAt`,`updatedAt`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Leave record created: {
  createdAt: 2025-06-03T08:00:33.320Z,
  updatedAt: 2025-06-03T08:00:33.367Z,
  LeaveID: '02',
  EmpNo: 'EMP001',
  EmpStatus: 'Regular',
  EmployeeName: 'John Doe',
  Designation: 'Developer',
  Department: 'IT',
  LeaveType: 'Sick',
  NoOfDaysRequired: 2,
  DateOfLeaveFrom: '2025-06-10',
  DateOfLeaveTo: '2025-06-11',
  LeavePurpose: 'Fever and rest',
  DateOfApplied: '2025-06-01',
  LeaveRecommended: 'Manager',
  AvailedLeaveML: 2,
  AvailedLeaveCL: 3,
  AvailedBalanceML: 5,
  AvailedBalanceCL: 4,
  LeaveStatus: 'Pending'
}
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'EMP001',
    EmpStatus: 'Regular',
    EmployeeName: 'John Doe',
    Designation: 'Software Engineer',
    Department: 'IT',
    LeaveType: 'Sick',
    NoOfDaysRequired: 2,
    DateOfLeaveFrom: '2025-06-10',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'Fever and rest',
    DateOfApplied: '2025-06-01',
    LeaveRecommended: 'Team Lead',
    AvailedLeaveML: 5,
    AvailedLeaveCL: 3,
    AvailedBalanceML: 7,
    AvailedBalanceCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-03T10:09:36.000Z,
    updatedAt: 2025-06-03T10:09:36.000Z
  },
  {
    LeaveID: '02',
    EmployeeId: null,
    EmpNo: 'EMP001',
    EmpStatus: 'Regular',
    EmployeeName: 'John Doe',
    Designation: 'Developer',
    Department: 'IT',
    LeaveType: 'Sick',
    NoOfDaysRequired: 2,
    DateOfLeaveFrom: '2025-06-10',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'Fever and rest',
    DateOfApplied: '2025-06-01',
    LeaveRecommended: 'Manager',
    AvailedLeaveML: 2,
    AvailedLeaveCL: 3,
    AvailedBalanceML: 5,
    AvailedBalanceCL: 4,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-03T08:00:33.000Z,
    updatedAt: 2025-06-03T08:00:33.000Z
  },
  {
    LeaveID: '0fc24597-3ccd-4b99-aa8c-124c86805ae0',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'Iqra',
    Designation: 'Intern',
    Department: 'Marketing ',
    LeaveType: 'Sick',
    NoOfDaysRequired: null,
    DateOfLeaveFrom: null,
    DateOfLeaveTo: null,
    LeavePurpose: null,
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalanceML: 0,
    AvailedBalanceCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-02T06:16:14.000Z,
    updatedAt: 2025-06-02T06:16:14.000Z
  },
  {
    LeaveID: '441a6368-d7a7-4739-b5b8-272a30a24b57',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'Aroosa Shahwar',
    Designation: 'Intern',
    Department: 'IT',
    LeaveType: 'Casual Leave',
    NoOfDaysRequired: null,
    DateOfLeaveFrom: null,
    DateOfLeaveTo: null,
    LeavePurpose: null,
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalanceML: 0,
    AvailedBalanceCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-05-30T05:57:51.000Z,
    updatedAt: 2025-05-30T05:57:51.000Z
  },
  {
    LeaveID: 'c7f59370-42ee-487a-bc53-d41ffc9f1c5f',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'Tehniyat Zahid',
    Designation: 'Intern ',
    Department: 'IT',
    LeaveType: 'Sick Leave',
    NoOfDaysRequired: null,
    DateOfLeaveFrom: null,
    DateOfLeaveTo: null,
    LeavePurpose: null,
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalanceML: 0,
    AvailedBalanceCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-05-31T05:37:21.000Z,
    updatedAt: 2025-05-31T05:37:21.000Z
  },
  {
    LeaveID: 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'Shahwar',
    Designation: 'Android Developer',
    Department: 'IT',
    LeaveType: 'Casual Leave',
    NoOfDaysRequired: null,
    DateOfLeaveFrom: null,
    DateOfLeaveTo: null,
    LeavePurpose: null,
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalanceML: 0,
    AvailedBalanceCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-05-30T09:33:41.000Z,
    updatedAt: 2025-05-31T05:51:53.000Z
  },
  {
    LeaveID: 'f1160593-4688-4a30-97cc-0162bb73b3b6',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'Ar',
    Designation: 'Bn',
    Department: 'Hk',
    LeaveType: 'Vbj',
    NoOfDaysRequired: null,
    DateOfLeaveFrom: null,
    DateOfLeaveTo: null,
    LeavePurpose: null,
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalanceML: 0,
    AvailedBalanceCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-02T08:14:50.000Z,
    updatedAt: 2025-06-02T08:14:50.000Z
  }
]
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'EMP001',
    EmpStatus: 'Regular',
    EmployeeName: 'John Doe',
    Designation: 'Software Engineer',
    Department: 'IT',
    LeaveType: 'Sick',
    NoOfDaysRequired: 2,
    DateOfLeaveFrom: '2025-06-10',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'Fever and rest',
    DateOfApplied: '2025-06-01',
    LeaveRecommended: 'Team Lead',
    AvailedLeaveML: 5,
    AvailedLeaveCL: 3,
    AvailedBalanceML: 7,
    AvailedBalanceCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-03T10:09:36.000Z,
    updatedAt: 2025-06-03T10:09:36.000Z
  },
  {
    LeaveID: '02',
    EmployeeId: null,
    EmpNo: 'EMP001',
    EmpStatus: 'Regular',
    EmployeeName: 'John Doe',
    Designation: 'Developer',
    Department: 'IT',
    LeaveType: 'Sick',
    NoOfDaysRequired: 2,
    DateOfLeaveFrom: '2025-06-10',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'Fever and rest',
    DateOfApplied: '2025-06-01',
    LeaveRecommended: 'Manager',
    AvailedLeaveML: 2,
    AvailedLeaveCL: 3,
    AvailedBalanceML: 5,
    AvailedBalanceCL: 4,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-03T08:00:33.000Z,
    updatedAt: 2025-06-03T08:00:33.000Z
  },
  {
    LeaveID: '0fc24597-3ccd-4b99-aa8c-124c86805ae0',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'Iqra',
    Designation: 'Intern',
    Department: 'Marketing ',
    LeaveType: 'Sick',
    NoOfDaysRequired: null,
    DateOfLeaveFrom: null,
    DateOfLeaveTo: null,
    LeavePurpose: null,
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalanceML: 0,
    AvailedBalanceCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-02T06:16:14.000Z,
    updatedAt: 2025-06-02T06:16:14.000Z
  },
  {
    LeaveID: '441a6368-d7a7-4739-b5b8-272a30a24b57',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'Aroosa Shahwar',
    Designation: 'Intern',
    Department: 'IT',
    LeaveType: 'Casual Leave',
    NoOfDaysRequired: null,
    DateOfLeaveFrom: null,
    DateOfLeaveTo: null,
    LeavePurpose: null,
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalanceML: 0,
    AvailedBalanceCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-05-30T05:57:51.000Z,
    updatedAt: 2025-05-30T05:57:51.000Z
  },
  {
    LeaveID: 'c7f59370-42ee-487a-bc53-d41ffc9f1c5f',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'Tehniyat Zahid',
    Designation: 'Intern ',
    Department: 'IT',
    LeaveType: 'Sick Leave',
    NoOfDaysRequired: null,
    DateOfLeaveFrom: null,
    DateOfLeaveTo: null,
    LeavePurpose: null,
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalanceML: 0,
    AvailedBalanceCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-05-31T05:37:21.000Z,
    updatedAt: 2025-05-31T05:37:21.000Z
  },
  {
    LeaveID: 'eedff698-2d53-4b6b-a4f6-23fe26a84f9d',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'Shahwar',
    Designation: 'Android Developer',
    Department: 'IT',
    LeaveType: 'Casual Leave',
    NoOfDaysRequired: null,
    DateOfLeaveFrom: null,
    DateOfLeaveTo: null,
    LeavePurpose: null,
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalanceML: 0,
    AvailedBalanceCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-05-30T09:33:41.000Z,
    updatedAt: 2025-05-31T05:51:53.000Z
  },
  {
    LeaveID: 'f1160593-4688-4a30-97cc-0162bb73b3b6',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'Ar',
    Designation: 'Bn',
    Department: 'Hk',
    LeaveType: 'Vbj',
    NoOfDaysRequired: null,
    DateOfLeaveFrom: null,
    DateOfLeaveTo: null,
    LeavePurpose: null,
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalanceML: 0,
    AvailedBalanceCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-02T08:14:50.000Z,
    updatedAt: 2025-06-02T08:14:50.000Z
  }
]
Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `YearlyLeave` AS `YearlyLeave` ORDER BY `YearlyLeave`.`yearlyLeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `YearlyLeave` AS `YearlyLeave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'EMP001',
    EmpStatus: 'Regular',
    EmployeeName: 'John Doe',
    Designation: 'Software Engineer',
    Department: 'IT',
    LeaveType: 'Sick',
    NoOfDaysRequired: 2,
    DateOfLeaveFrom: '2025-06-10',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'Fever and rest',
    DateOfApplied: '2025-06-01',
    LeaveRecommended: 'Team Lead',
    AvailedLeaveML: 5,
    AvailedLeaveCL: 3,
    AvailedBalanceML: 7,
    AvailedBalanceCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-03T10:09:36.000Z,
    updatedAt: 2025-06-03T10:09:36.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '01';
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `YearlyLeave` AS `YearlyLeave` ORDER BY `YearlyLeave`.`yearlyLeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `YearlyLeave` AS `YearlyLeave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'EMP001',
    EmpStatus: 'Regular',
    EmployeeName: 'John Doe',
    Designation: 'Software Engineer',
    Department: 'IT',
    LeaveType: 'Sick',
    NoOfDaysRequired: 2,
    DateOfLeaveFrom: '2025-06-10',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'Fever and rest',
    DateOfApplied: '2025-06-01',
    LeaveRecommended: 'Team Lead',
    AvailedLeaveML: 5,
    AvailedLeaveCL: 3,
    AvailedBalanceML: 7,
    AvailedBalanceCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-03T10:09:36.000Z,
    updatedAt: 2025-06-03T10:09:36.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'EMP001',
    EmpStatus: 'Regular',
    EmployeeName: 'John Doe',
    Designation: 'Software Engineer',
    Department: 'IT',
    LeaveType: 'Sick',
    NoOfDaysRequired: 2,
    DateOfLeaveFrom: '2025-06-10',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'Fever and rest',
    DateOfApplied: '2025-06-01',
    LeaveRecommended: 'Team Lead',
    AvailedLeaveML: 5,
    AvailedLeaveCL: 3,
    AvailedBalanceML: 7,
    AvailedBalanceCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-03T10:09:36.000Z,
    updatedAt: 2025-06-03T10:09:36.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'EMP001',
    EmpStatus: 'Regular',
    EmployeeName: 'John Doe',
    Designation: 'Software Engineer',
    Department: 'IT',
    LeaveType: 'Sick',
    NoOfDaysRequired: 2,
    DateOfLeaveFrom: '2025-06-10',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'Fever and rest',
    DateOfApplied: '2025-06-01',
    LeaveRecommended: 'Team Lead',
    AvailedLeaveML: 5,
    AvailedLeaveCL: 3,
    AvailedBalanceML: 7,
    AvailedBalanceCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-03T10:09:36.000Z,
    updatedAt: 2025-06-03T10:09:36.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'EMP001',
    EmpStatus: 'Regular',
    EmployeeName: 'John Doe',
    Designation: 'Software Engineer',
    Department: 'IT',
    LeaveType: 'Sick',
    NoOfDaysRequired: 2,
    DateOfLeaveFrom: '2025-06-10',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'Fever and rest',
    DateOfApplied: '2025-06-01',
    LeaveRecommended: 'Team Lead',
    AvailedLeaveML: 5,
    AvailedLeaveCL: 3,
    AvailedBalanceML: 7,
    AvailedBalanceCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-03T10:09:36.000Z,
    updatedAt: 2025-06-03T10:09:36.000Z
  }
]
✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'EMP001',
    EmpStatus: 'Regular',
    EmployeeName: 'John Doe',
    Designation: 'Software Engineer',
    Department: 'IT',
    LeaveType: 'Sick',
    NoOfDaysRequired: 2,
    DateOfLeaveFrom: '2025-06-10',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'Fever and rest',
    DateOfApplied: '2025-06-01',
    LeaveRecommended: 'Team Lead',
    AvailedLeaveML: 5,
    AvailedLeaveCL: 3,
    AvailedBalanceML: 7,
    AvailedBalanceCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-03T10:09:36.000Z,
    updatedAt: 2025-06-03T10:09:36.000Z
  }
]
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'EMP001',
    EmpStatus: 'Regular',
    EmployeeName: 'John Doe',
    Designation: 'Software Engineer',
    Department: 'IT',
    LeaveType: 'Sick',
    NoOfDaysRequired: 2,
    DateOfLeaveFrom: '2025-06-10',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'Fever and rest',
    DateOfApplied: '2025-06-01',
    LeaveRecommended: 'Team Lead',
    AvailedLeaveML: 5,
    AvailedLeaveCL: 3,
    AvailedBalanceML: 7,
    AvailedBalanceCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-03T10:09:36.000Z,
    updatedAt: 2025-06-03T10:09:36.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'EMP001',
    EmpStatus: 'Regular',
    EmployeeName: 'John Doe',
    Designation: 'Software Engineer',
    Department: 'IT',
    LeaveType: 'Sick',
    NoOfDaysRequired: 2,
    DateOfLeaveFrom: '2025-06-10',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'Fever and rest',
    DateOfApplied: '2025-06-01',
    LeaveRecommended: 'Team Lead',
    AvailedLeaveML: 5,
    AvailedLeaveCL: 3,
    AvailedBalanceML: 7,
    AvailedBalanceCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-03T10:09:36.000Z,
    updatedAt: 2025-06-03T10:09:36.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'EMP001',
    EmpStatus: 'Regular',
    EmployeeName: 'John Doe',
    Designation: 'Software Engineer',
    Department: 'IT',
    LeaveType: 'Sick',
    NoOfDaysRequired: 2,
    DateOfLeaveFrom: '2025-06-10',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'Fever and rest',
    DateOfApplied: '2025-06-01',
    LeaveRecommended: 'Team Lead',
    AvailedLeaveML: 5,
    AvailedLeaveCL: 3,
    AvailedBalanceML: 7,
    AvailedBalanceCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-03T10:09:36.000Z,
    updatedAt: 2025-06-03T10:09:36.000Z
  }
]
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'EMP001',
    EmpStatus: 'Regular',
    EmployeeName: 'John Doe',
    Designation: 'Software Engineer',
    Department: 'IT',
    LeaveType: 'Sick',
    NoOfDaysRequired: 2,
    DateOfLeaveFrom: '2025-06-10',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'Fever and rest',
    DateOfApplied: '2025-06-01',
    LeaveRecommended: 'Team Lead',
    AvailedLeaveML: 5,
    AvailedLeaveCL: 3,
    AvailedBalanceML: 7,
    AvailedBalanceCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-03T10:09:36.000Z,
    updatedAt: 2025-06-03T10:09:36.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '01';
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'EMP001',
    EmpStatus: 'Regular',
    EmployeeName: 'John Doe',
    Designation: 'Software Engineer',
    Department: 'IT',
    LeaveType: 'Sick',
    NoOfDaysRequired: 2,
    DateOfLeaveFrom: '2025-06-10',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'Fever and rest',
    DateOfApplied: '2025-06-01',
    LeaveRecommended: 'Team Lead',
    AvailedLeaveML: 5,
    AvailedLeaveCL: 3,
    AvailedBalanceML: 7,
    AvailedBalanceCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-03T10:09:36.000Z,
    updatedAt: 2025-06-03T10:09:36.000Z
  }
]
Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `YearlyLeave` AS `YearlyLeave` ORDER BY `YearlyLeave`.`yearlyLeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `YearlyLeave` AS `YearlyLeave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`createdAt` DESC LIMIT 1;
Sequelize Create: Executing (default): INSERT INTO `Leaves` (`LeaveID`,`EmpNo`,`EmpStatus`,`EmployeeName`,`Designation`,`Department`,`LeaveType`,`NoOfDaysRequired`,`DateOfLeaveFrom`,`DateOfLeaveTo`,`LeavePurpose`,`DateOfApplied`,`LeaveRecommended`,`AvailedLeaveML`,`AvailedLeaveCL`,`AvailedBalanceML`,`AvailedBalanceCL`,`LeaveStatus`,`createdAt`,`updatedAt`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);
✅ Leave record created: {
  createdAt: 2025-06-11T06:06:58.294Z,
  updatedAt: 2025-06-11T06:06:58.313Z,
  AvailedBalanceML: 0,
  AvailedBalanceCL: 0,
  LeaveID: '02',
  EmpNo: 'E123',
  EmpStatus: 'Regular',
  EmployeeName: 'John Doe',
  Designation: 'Software Engineer',
  Department: 'IT',
  LeaveType: 'Casual',
  NoOfDaysRequired: 3,
  DateOfLeaveFrom: '2025-06-15',
  DateOfLeaveTo: '2025-06-17',
  LeavePurpose: 'Family vacation',
  DateOfApplied: '2025-06-10',
  LeaveRecommended: 'Manager',
  AvailedLeaveML: 2,
  AvailedLeaveCL: 5,
  LeaveStatus: 'Pending'
}
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: []
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceML`, `AvailedBalanceCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`createdAt` DESC LIMIT 1;
Sequelize Create: Executing (default): INSERT INTO `Leaves` (`LeaveID`,`EmpNo`,`EmpStatus`,`EmployeeName`,`Designation`,`Department`,`LeaveType`,`NoOfDaysRequired`,`DateOfLeaveFrom`,`DateOfLeaveTo`,`LeavePurpose`,`DateOfApplied`,`LeaveRecommended`,`AvailedLeaveML`,`AvailedLeaveCL`,`AvailedBalanceML`,`AvailedBalanceCL`,`LeaveStatus`,`createdAt`,`updatedAt`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);
✅ Leave record created: {
  createdAt: 2025-06-11T06:24:20.710Z,
  updatedAt: 2025-06-11T06:24:20.714Z,
  AvailedBalanceML: 0,
  AvailedBalanceCL: 0,
  LeaveID: '01',
  EmpNo: 'E123',
  EmpStatus: 'Regular',
  EmployeeName: 'Aroosa Shahwar',
  Designation: 'Android Developer',
  Department: 'IT',
  LeaveType: 'Casual',
  NoOfDaysRequired: 3,
  DateOfLeaveFrom: '2025-06-15',
  DateOfLeaveTo: '2025-06-17',
  LeavePurpose: 'Family vacation',
  DateOfApplied: '2025-06-10',
  LeaveRecommended: 'IT Specialist',
  AvailedLeaveML: 2,
  AvailedLeaveCL: 5,
  LeaveStatus: 'Pending'
}
✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceOfML`, `AvailedBalanceOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceOfML`, `AvailedBalanceOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceOfML`, `AvailedBalanceOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '5d07a198-9a09-4606-b778-1e68a5999808';
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceOfML`, `AvailedBalanceOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceOfML`, `AvailedBalanceOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceOfML`, `AvailedBalanceOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceOfML`, `AvailedBalanceOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceOfML`, `AvailedBalanceOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceOfML`, `AvailedBalanceOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave`;
✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalanceOfML`, `AvailedBalanceOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave`;
✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'E123',
    EmpStatus: 'Regular',
    EmployeeName: 'Aroosa Shahwar',
    Designation: 'Android Developer',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 3,
    DateOfLeaveFrom: '2025-06-15',
    DateOfLeaveTo: '2025-06-17',
    LeavePurpose: 'Family vacation',
    DateOfApplied: '2025-06-10',
    LeaveRecommended: 'IT Specialist',
    AvailedLeaveML: 2,
    AvailedLeaveCL: 5,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T06:24:20.000Z,
    updatedAt: 2025-06-11T06:24:20.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '01';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'E123',
    EmpStatus: 'Regular',
    EmployeeName: 'Aroosa Shahwar',
    Designation: 'Android Developer',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 3,
    DateOfLeaveFrom: '2025-06-15',
    DateOfLeaveTo: '2025-06-17',
    LeavePurpose: 'Family vacation',
    DateOfApplied: '2025-06-10',
    LeaveRecommended: 'IT Specialist',
    AvailedLeaveML: 2,
    AvailedLeaveCL: 5,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T06:24:20.000Z,
    updatedAt: 2025-06-11T06:24:20.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`createdAt` DESC LIMIT 1;
Sequelize Create: Executing (default): INSERT INTO `Leaves` (`LeaveID`,`EmployeeName`,`Designation`,`Department`,`LeaveType`,`NoOfDaysRequired`,`DateOfLeaveFrom`,`DateOfLeaveTo`,`LeavePurpose`,`AvailedLeaveML`,`AvailedLeaveCL`,`AvailedBalancedOfML`,`AvailedBalancedOfCL`,`LeaveStatus`,`createdAt`,`updatedAt`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);
✅ Leave record created: {
  createdAt: 2025-06-11T07:48:01.831Z,
  updatedAt: 2025-06-11T07:48:01.846Z,
  AvailedLeaveML: 0,
  AvailedLeaveCL: 0,
  AvailedBalancedOfML: 0,
  AvailedBalancedOfCL: 0,
  LeaveID: '02',
  EmpNo: undefined,
  EmpStatus: undefined,
  EmployeeName: 'kxtyqh',
  Designation: 'vijomc',
  Department: 'jhhzqy',
  LeaveType: 'hhkthk',
  NoOfDaysRequired: 13269,
  DateOfLeaveFrom: '2025-06-11',
  DateOfLeaveTo: '2025-06-11',
  LeavePurpose: 'sywwqy',
  DateOfApplied: undefined,
  LeaveRecommended: undefined,
  LeaveStatus: 'Pending'
}
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'E123',
    EmpStatus: 'Regular',
    EmployeeName: 'Aroosa Shahwar',
    Designation: 'Android Developer',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 3,
    DateOfLeaveFrom: '2025-06-15',
    DateOfLeaveTo: '2025-06-17',
    LeavePurpose: 'Family vacation',
    DateOfApplied: '2025-06-10',
    LeaveRecommended: 'IT Specialist',
    AvailedLeaveML: 2,
    AvailedLeaveCL: 5,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T06:24:20.000Z,
    updatedAt: 2025-06-11T06:24:20.000Z
  },
  {
    LeaveID: '02',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'kxtyqh',
    Designation: 'vijomc',
    Department: 'jhhzqy',
    LeaveType: 'hhkthk',
    NoOfDaysRequired: 13269,
    DateOfLeaveFrom: '2025-06-11',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'sywwqy',
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T07:48:01.000Z,
    updatedAt: 2025-06-11T07:48:01.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '01';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'E123',
    EmpStatus: 'Regular',
    EmployeeName: 'Aroosa Shahwar',
    Designation: 'Android Developer',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 3,
    DateOfLeaveFrom: '2025-06-15',
    DateOfLeaveTo: '2025-06-17',
    LeavePurpose: 'Family vacation',
    DateOfApplied: '2025-06-10',
    LeaveRecommended: 'IT Specialist',
    AvailedLeaveML: 2,
    AvailedLeaveCL: 5,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T06:24:20.000Z,
    updatedAt: 2025-06-11T06:24:20.000Z
  },
  {
    LeaveID: '02',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'kxtyqh',
    Designation: 'vijomc',
    Department: 'jhhzqy',
    LeaveType: 'hhkthk',
    NoOfDaysRequired: 13269,
    DateOfLeaveFrom: '2025-06-11',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'sywwqy',
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T07:48:01.000Z,
    updatedAt: 2025-06-11T07:48:01.000Z
  }
]
✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'E123',
    EmpStatus: 'Regular',
    EmployeeName: 'Aroosa Shahwar',
    Designation: 'Android Developer',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 3,
    DateOfLeaveFrom: '2025-06-15',
    DateOfLeaveTo: '2025-06-17',
    LeavePurpose: 'Family vacation',
    DateOfApplied: '2025-06-10',
    LeaveRecommended: 'IT Specialist',
    AvailedLeaveML: 2,
    AvailedLeaveCL: 5,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T06:24:20.000Z,
    updatedAt: 2025-06-11T06:24:20.000Z
  },
  {
    LeaveID: '02',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'kxtyqh',
    Designation: 'vijomc',
    Department: 'jhhzqy',
    LeaveType: 'hhkthk',
    NoOfDaysRequired: 13269,
    DateOfLeaveFrom: '2025-06-11',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'sywwqy',
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T07:48:01.000Z,
    updatedAt: 2025-06-11T07:48:01.000Z
  }
]
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees` ORDER BY `Employees`.`EmployeeId` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Employee` AS `Employees`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`createdAt` DESC LIMIT 1;
Sequelize: Executing (default): INSERT INTO `Leaves` (`LeaveID`,`EmpNo`,`EmpStatus`,`EmployeeName`,`Designation`,`Department`,`LeaveType`,`NoOfDaysRequired`,`DateOfLeaveFrom`,`DateOfLeaveTo`,`LeavePurpose`,`DateOfApplied`,`LeaveRecommended`,`AvailedLeaveML`,`AvailedLeaveCL`,`AvailedBalancedOfML`,`AvailedBalancedOfCL`,`LeaveStatus`,`createdAt`,`updatedAt`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'E123',
    EmpStatus: 'Regular',
    EmployeeName: 'Aroosa Shahwar',
    Designation: 'Android Developer',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 3,
    DateOfLeaveFrom: '2025-06-15',
    DateOfLeaveTo: '2025-06-17',
    LeavePurpose: 'Family vacation',
    DateOfApplied: '2025-06-10',
    LeaveRecommended: 'IT Specialist',
    AvailedLeaveML: 2,
    AvailedLeaveCL: 5,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T06:24:20.000Z,
    updatedAt: 2025-06-11T06:24:20.000Z
  },
  {
    LeaveID: '02',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'kxtyqh',
    Designation: 'vijomc',
    Department: 'jhhzqy',
    LeaveType: 'hhkthk',
    NoOfDaysRequired: 13269,
    DateOfLeaveFrom: '2025-06-11',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'sywwqy',
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T07:48:01.000Z,
    updatedAt: 2025-06-11T07:48:01.000Z
  },
  {
    LeaveID: '03',
    EmployeeId: null,
    EmpNo: 'E01',
    EmpStatus: 'Contract',
    EmployeeName: 'Tehniyat ',
    Designation: 'Web developer ',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 1,
    DateOfLeaveFrom: '2025-06-12',
    DateOfLeaveTo: '2025-06-13',
    LeavePurpose: 'Urgent work',
    DateOfApplied: '2025-06-12',
    LeaveRecommended: 'IT specialist ',
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 5,
    AvailedBalancedOfCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-12T06:15:30.000Z,
    updatedAt: 2025-06-12T06:15:30.000Z
  }
]
Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `YearlyLeave` AS `YearlyLeave` ORDER BY `YearlyLeave`.`yearlyLeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `YearlyLeave` AS `YearlyLeave`;
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'E123',
    EmpStatus: 'Regular',
    EmployeeName: 'Aroosa Shahwar',
    Designation: 'Android Developer',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 3,
    DateOfLeaveFrom: '2025-06-15',
    DateOfLeaveTo: '2025-06-17',
    LeavePurpose: 'Family vacation',
    DateOfApplied: '2025-06-10',
    LeaveRecommended: 'IT Specialist',
    AvailedLeaveML: 2,
    AvailedLeaveCL: 5,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T06:24:20.000Z,
    updatedAt: 2025-06-11T06:24:20.000Z
  },
  {
    LeaveID: '02',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'kxtyqh',
    Designation: 'vijomc',
    Department: 'jhhzqy',
    LeaveType: 'hhkthk',
    NoOfDaysRequired: 13269,
    DateOfLeaveFrom: '2025-06-11',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'sywwqy',
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T07:48:01.000Z,
    updatedAt: 2025-06-11T07:48:01.000Z
  },
  {
    LeaveID: '03',
    EmployeeId: null,
    EmpNo: 'E01',
    EmpStatus: 'Contract',
    EmployeeName: 'Tehniyat ',
    Designation: 'Web developer ',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 1,
    DateOfLeaveFrom: '2025-06-12',
    DateOfLeaveTo: '2025-06-13',
    LeavePurpose: 'Urgent work',
    DateOfApplied: '2025-06-12',
    LeaveRecommended: 'IT specialist ',
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 5,
    AvailedBalancedOfCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-12T06:15:30.000Z,
    updatedAt: 2025-06-12T06:15:30.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'E123',
    EmpStatus: 'Regular',
    EmployeeName: 'Aroosa Shahwar',
    Designation: 'Android Developer',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 3,
    DateOfLeaveFrom: '2025-06-15',
    DateOfLeaveTo: '2025-06-17',
    LeavePurpose: 'Family vacation',
    DateOfApplied: '2025-06-10',
    LeaveRecommended: 'IT Specialist',
    AvailedLeaveML: 2,
    AvailedLeaveCL: 5,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T06:24:20.000Z,
    updatedAt: 2025-06-11T06:24:20.000Z
  },
  {
    LeaveID: '02',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'kxtyqh',
    Designation: 'vijomc',
    Department: 'jhhzqy',
    LeaveType: 'hhkthk',
    NoOfDaysRequired: 13269,
    DateOfLeaveFrom: '2025-06-11',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'sywwqy',
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T07:48:01.000Z,
    updatedAt: 2025-06-11T07:48:01.000Z
  },
  {
    LeaveID: '03',
    EmployeeId: null,
    EmpNo: 'E01',
    EmpStatus: 'Contract',
    EmployeeName: 'Tehniyat ',
    Designation: 'Web developer ',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 1,
    DateOfLeaveFrom: '2025-06-12',
    DateOfLeaveTo: '2025-06-13',
    LeavePurpose: 'Urgent work',
    DateOfApplied: '2025-06-12',
    LeaveRecommended: 'IT specialist ',
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 5,
    AvailedBalancedOfCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-12T06:15:30.000Z,
    updatedAt: 2025-06-12T06:15:30.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '03';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '03';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'E123',
    EmpStatus: 'Regular',
    EmployeeName: 'Aroosa Shahwar',
    Designation: 'Android Developer',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 3,
    DateOfLeaveFrom: '2025-06-15',
    DateOfLeaveTo: '2025-06-17',
    LeavePurpose: 'Family vacation',
    DateOfApplied: '2025-06-10',
    LeaveRecommended: 'IT Specialist',
    AvailedLeaveML: 2,
    AvailedLeaveCL: 5,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T06:24:20.000Z,
    updatedAt: 2025-06-11T06:24:20.000Z
  },
  {
    LeaveID: '02',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'kxtyqh',
    Designation: 'vijomc',
    Department: 'jhhzqy',
    LeaveType: 'hhkthk',
    NoOfDaysRequired: 13269,
    DateOfLeaveFrom: '2025-06-11',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'sywwqy',
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T07:48:01.000Z,
    updatedAt: 2025-06-11T07:48:01.000Z
  },
  {
    LeaveID: '03',
    EmployeeId: null,
    EmpNo: 'E01',
    EmpStatus: 'Contract',
    EmployeeName: 'Tehniyat ',
    Designation: 'Web developer ',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 1,
    DateOfLeaveFrom: '2025-06-12',
    DateOfLeaveTo: '2025-06-13',
    LeavePurpose: 'Urgent work',
    DateOfApplied: '2025-06-12',
    LeaveRecommended: 'IT specialist ',
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 5,
    AvailedBalancedOfCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-12T06:15:30.000Z,
    updatedAt: 2025-06-12T06:15:30.000Z
  }
]
✅ AdminJS running at http://testtwo.onebox.pk:2001/admin
Sequelize: Executing (default): SELECT 1+1 AS result
✅ Database connection established successfully.
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Employee' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Employee`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Leaves' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `Leaves`
Sequelize: Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'YearlyLeave' AND TABLE_SCHEMA = 'oneboxpk_leavemanagement'
Sequelize: Executing (default): SHOW INDEX FROM `YearlyLeave`
✅ Database synced successfully.
Sequelize: Executing (default): SELECT DATABASE() AS db;
🔥 Connected to database: oneboxpk_leavemanagement
Sequelize: Executing (default): SHOW TABLES;
📋 Tables in DB: [ 'Employee', 'Leave', 'Leaves', 'YearlyLeave' ]
Sequelize: Executing (default): SELECT 1 AS test;
✅ Test query result: 1
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'E123',
    EmpStatus: 'Regular',
    EmployeeName: 'Aroosa Shahwar',
    Designation: 'Android Developer',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 3,
    DateOfLeaveFrom: '2025-06-15',
    DateOfLeaveTo: '2025-06-17',
    LeavePurpose: 'Family vacation',
    DateOfApplied: '2025-06-10',
    LeaveRecommended: 'IT Specialist',
    AvailedLeaveML: 2,
    AvailedLeaveCL: 5,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T06:24:20.000Z,
    updatedAt: 2025-06-11T06:24:20.000Z
  },
  {
    LeaveID: '02',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'kxtyqh',
    Designation: 'vijomc',
    Department: 'jhhzqy',
    LeaveType: 'hhkthk',
    NoOfDaysRequired: 13269,
    DateOfLeaveFrom: '2025-06-11',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'sywwqy',
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T07:48:01.000Z,
    updatedAt: 2025-06-11T07:48:01.000Z
  },
  {
    LeaveID: '03',
    EmployeeId: null,
    EmpNo: 'E01',
    EmpStatus: 'Contract',
    EmployeeName: 'Tehniyat ',
    Designation: 'Web developer ',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 1,
    DateOfLeaveFrom: '2025-06-12',
    DateOfLeaveTo: '2025-06-13',
    LeavePurpose: 'Urgent work',
    DateOfApplied: '2025-06-12',
    LeaveRecommended: 'IT specialist ',
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 5,
    AvailedBalancedOfCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-12T06:15:30.000Z,
    updatedAt: 2025-06-12T06:15:30.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '01';
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'E123',
    EmpStatus: 'Regular',
    EmployeeName: 'Aroosa Shahwar',
    Designation: 'Android Developer',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 3,
    DateOfLeaveFrom: '2025-06-15',
    DateOfLeaveTo: '2025-06-17',
    LeavePurpose: 'Family vacation',
    DateOfApplied: '2025-06-10',
    LeaveRecommended: 'IT Specialist',
    AvailedLeaveML: 2,
    AvailedLeaveCL: 5,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Approved',
    createdAt: 2025-06-11T06:24:20.000Z,
    updatedAt: 2025-06-11T06:24:20.000Z
  },
  {
    LeaveID: '02',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'kxtyqh',
    Designation: 'vijomc',
    Department: 'jhhzqy',
    LeaveType: 'hhkthk',
    NoOfDaysRequired: 13269,
    DateOfLeaveFrom: '2025-06-11',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'sywwqy',
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T07:48:01.000Z,
    updatedAt: 2025-06-11T07:48:01.000Z
  },
  {
    LeaveID: '03',
    EmployeeId: null,
    EmpNo: 'E01',
    EmpStatus: 'Contract',
    EmployeeName: 'Tehniyat ',
    Designation: 'Web developer ',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 1,
    DateOfLeaveFrom: '2025-06-12',
    DateOfLeaveTo: '2025-06-13',
    LeavePurpose: 'Urgent work',
    DateOfApplied: '2025-06-12',
    LeaveRecommended: 'IT specialist ',
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 5,
    AvailedBalancedOfCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-12T06:15:30.000Z,
    updatedAt: 2025-06-12T06:15:30.000Z
  }
]
Sequelize: Executing (default): SELECT `LeaveID`, `EmployeeId`, `EmpNo`, `EmpStatus`, `EmployeeName`, `Designation`, `Department`, `LeaveType`, `NoOfDaysRequired`, `DateOfLeaveFrom`, `DateOfLeaveTo`, `LeavePurpose`, `DateOfApplied`, `LeaveRecommended`, `AvailedLeaveML`, `AvailedLeaveCL`, `AvailedBalancedOfML`, `AvailedBalancedOfCL`, `LeaveStatus`, `createdAt`, `updatedAt` FROM `Leaves` AS `Leave` ORDER BY `Leave`.`LeaveID` ASC LIMIT 0, 10;
Sequelize: Executing (default): SELECT count(*) AS `count` FROM `Leaves` AS `Leave`;
DATA: [
  {
    LeaveID: '01',
    EmployeeId: null,
    EmpNo: 'E123',
    EmpStatus: 'Regular',
    EmployeeName: 'Aroosa Shahwar',
    Designation: 'Android Developer',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 3,
    DateOfLeaveFrom: '2025-06-15',
    DateOfLeaveTo: '2025-06-17',
    LeavePurpose: 'Family vacation',
    DateOfApplied: '2025-06-10',
    LeaveRecommended: 'IT Specialist',
    AvailedLeaveML: 2,
    AvailedLeaveCL: 5,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Approved',
    createdAt: 2025-06-11T06:24:20.000Z,
    updatedAt: 2025-06-11T06:24:20.000Z
  },
  {
    LeaveID: '02',
    EmployeeId: null,
    EmpNo: null,
    EmpStatus: null,
    EmployeeName: 'kxtyqh',
    Designation: 'vijomc',
    Department: 'jhhzqy',
    LeaveType: 'hhkthk',
    NoOfDaysRequired: 13269,
    DateOfLeaveFrom: '2025-06-11',
    DateOfLeaveTo: '2025-06-11',
    LeavePurpose: 'sywwqy',
    DateOfApplied: null,
    LeaveRecommended: null,
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 0,
    AvailedBalancedOfCL: 0,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-11T07:48:01.000Z,
    updatedAt: 2025-06-11T07:48:01.000Z
  },
  {
    LeaveID: '03',
    EmployeeId: null,
    EmpNo: 'E01',
    EmpStatus: 'Contract',
    EmployeeName: 'Tehniyat ',
    Designation: 'Web developer ',
    Department: 'IT',
    LeaveType: 'Casual',
    NoOfDaysRequired: 1,
    DateOfLeaveFrom: '2025-06-12',
    DateOfLeaveTo: '2025-06-13',
    LeavePurpose: 'Urgent work',
    DateOfApplied: '2025-06-12',
    LeaveRecommended: 'IT specialist ',
    AvailedLeaveML: 0,
    AvailedLeaveCL: 0,
    AvailedBalancedOfML: 5,
    AvailedBalancedOfCL: 5,
    LeaveStatus: 'Pending',
    createdAt: 2025-06-12T06:15:30.000Z,
    updatedAt: 2025-06-12T06:15:30.000Z
  }
]
Sequelize: Executing (default): SELECT `EmployeeId`, `EmployeeName`, `Email`, `Designation`, `Department`, `JoiningDate`, `createdAt`, `updatedAt` FROM `Employee` AS `Employees`;