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`;