OwlCyberSecurity - MANAGER

Edit File: index-out.log

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` ✅ Server running: http://testtwo.onebox.pk:2001 ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '5' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTQ2NTYxMSwiZXhwIjoxNzUxNTUyMDExfQ.jRX6RHxR58JlzVrUKhcun5jmjvQg6b8rZIrEuCMabLk Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; 🔍 Received empNo: EMP001 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; ЁЯзк loginUser called with: { EmpNo: 'EMP002', password: '1234@', captcha: '3' } ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: '1234@', captcha: '12' } ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: '1234@', captcha: '8' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi ЁЯзк loginUser called with: { EmpNo: 'EMP005', password: 'A1@786', captcha: '8' } ЁЯзк loginUser called with: { EmpNo: 'EMP005', password: 'A1@786', captcha: '12' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP005'; ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '4' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTQ3MzM2OSwiZXhwIjoxNzUxNTU5NzY5fQ.V3WM4fGIw-Hq4sgWCzRz9QjLV-ZDDOaBfpFH7kzA3J8 Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; 🔍 Received empNo: EMP001 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; 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` ✅ Server running: http://testtwo.onebox.pk:2001 ЁЯзк loginUser called with: { EmpNo: 'EMP002', password: '1234@', captcha: '5' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; 🔍 Checking password for user: EMP002 🔑 Hashed password from DB: $2b$10$6xY6lNsr6aLn/2T208xB6ubLbK3FdCar996SGrJ5g13j.0I4p7LZi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMiIsInJvbGUiOiJlbnRyeSIsImlhdCI6MTc1MTQ3MzY5NiwiZXhwIjoxNzUxNTYwMDk2fQ.hoeSqf9JjdR_GcQ28_hGMAGZYPNt-7ydkM0FQas6M5o Sequelize: Executing (default): SELECT COUNT(*) as total FROM Leaves Sequelize: Executing (default): ALTER TABLE Leaves AUTO_INCREMENT = 1 Sequelize: Executing (default): SHOW TABLE STATUS LIKE 'Leaves' 🔍 Received empNo: EMP002 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; Sequelize: Executing (default): UPDATE `employee` SET `AvailedLeaveCL`=?,`AvailedBalancedOfCL`=? WHERE `EmployeeId` = ? Sequelize: Executing (default): INSERT INTO `Leaves` (`LeaveID`,`LeaveDate`,`EmployeeName`,`EmpNo`,`EmpStatus`,`Department`,`Designation`,`LeaveType`,`LeavePurpose`,`NoOfDaysRequired`,`ImmediateOfficer`,`GeneralManager`,`LeaveStatus`) VALUES (DEFAULT,?,?,?,?,?,?,?,?,?,?,?,?); ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '20' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTQ3MzgzNCwiZXhwIjoxNzUxNTYwMjM0fQ.pwUn2w751edrZ-WeoXSV5XgSZKzVo-1uuXtd3zrEWf4 Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; 🔍 Received empNo: EMP001 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; ЁЯзк loginUser called with: { EmpNo: 'EMP003', password: 'securepassword123', captcha: '12' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP003'; 🔍 Checking password for user: EMP003 🔑 Hashed password from DB: $2b$10$IZGUy1J7.5wW8WgPI5nobuyYSpDa95aR5WACJL6NOIpBslMdPsS22 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMyIsInJvbGUiOiJlbnRyeSIsImlhdCI6MTc1MTQ3Mzg5MywiZXhwIjoxNzUxNTYwMjkzfQ.FFZ0KU2ySlF1qUmdt4Gm1CU8CP1-rliInBFA3cfPQX0 Sequelize: Executing (default): SELECT COUNT(*) as total FROM Leaves Sequelize: Executing (default): SHOW TABLE STATUS LIKE 'Leaves' 🔍 Received empNo: EMP003 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP003'; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP003'; Sequelize: Executing (default): UPDATE `employee` SET `AvailedLeaveCL`=?,`AvailedBalancedOfCL`=? WHERE `EmployeeId` = ? Sequelize: Executing (default): INSERT INTO `Leaves` (`LeaveID`,`LeaveDate`,`EmployeeName`,`EmpNo`,`EmpStatus`,`Department`,`Designation`,`LeaveType`,`LeavePurpose`,`NoOfDaysRequired`,`ImmediateOfficer`,`GeneralManager`,`LeaveStatus`) VALUES (DEFAULT,?,?,?,?,?,?,?,?,?,?,?,?); 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` ✅ Server running: http://testtwo.onebox.pk:2001 ЁЯзк loginUser called with: { EmpNo: 'EMP002', password: '1234@', captcha: '8' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; 🔍 Checking password for user: EMP002 🔑 Hashed password from DB: $2b$10$6xY6lNsr6aLn/2T208xB6ubLbK3FdCar996SGrJ5g13j.0I4p7LZi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMiIsInJvbGUiOiJlbnRyeSIsImlhdCI6MTc1MTUzMjI5MiwiZXhwIjoxNzUxNjE4NjkyfQ.kT6XWN1EKO7l8TC1Bj9KWzuWYIAWcxTtQTX3Y4v-5Ao Sequelize: Executing (default): SELECT COUNT(*) as total FROM Leaves 🔍 Received empNo: EMP002 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; Sequelize: Executing (default): SHOW TABLE STATUS LIKE 'Leaves' ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '19' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTUzMjM4OSwiZXhwIjoxNzUxNjE4Nzg5fQ.l9Dmul949ox40u5HJFii8p8ZkU8-TRjCBGdLr6OzuPk Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `yearlyleave` AS `YearlyLeave`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` ORDER BY `Employee`.`EmployeeId` DESC LIMIT 1; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; 🔍 Received empNo: EMP001 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '14' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTUzMjU2MCwiZXhwIjoxNzUxNjE4OTYwfQ._QMGEKk4c1UyetmHhUkzdCAdRAuhLSQVOQHERH4NwIk Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; 🔍 Received empNo: EMP001 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `yearlyleave` AS `YearlyLeave`; ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '14' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTUzMjU5MSwiZXhwIjoxNzUxNjE4OTkxfQ.WVhpPACsHBsA-44Ey1HO-bjhSCx1Hnshq3E3YCy4c60 Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; 🔍 Received empNo: EMP001 Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `yearlyleave` AS `YearlyLeave`; ЁЯзк loginUser called with: { EmpNo: 'rwltza', password: 'juvgwg', captcha: 'utgopu' } ЁЯзк loginUser called with: { EmpNo: 'rwltza', password: 'juvgwg', captcha: 'utgopu' } ЁЯзк loginUser called with: { EmpNo: 'zjnnnq', password: 'juvgwg', captcha: 'utgopu' } ЁЯзк loginUser called with: { EmpNo: 'zjnnnq', password: 'juvgwg', captcha: 'utgopu' } ЁЯзк loginUser called with: { EmpNo: 'zjnnnq', password: 'juvgwg', captcha: 'utgopu' } ЁЯзк loginUser called with: { EmpNo: 'zjnnnq', password: 'juvgwg', captcha: 'utgopu' } ЁЯзк loginUser called with: { EmpNo: 'zjnnnq', password: 'juvgwg', captcha: 'utgopu' } ЁЯзк loginUser called with: { EmpNo: 'zjnnnq', password: 'juvgwg', captcha: 'utgopu' } ЁЯзк loginUser called with: { EmpNo: 'twkhqn', password: 'juvgwg', captcha: 'utgopu' } ЁЯзк loginUser called with: { EmpNo: 'twkhqn', password: 'juvgwg', captcha: 'utgopu' } ЁЯзк loginUser called with: { EmpNo: 'twkhqn', password: 'juvgwg', captcha: 'utgopu' } ЁЯзк loginUser called with: { EmpNo: 'twkhqn', password: 'juvgwg', captcha: 'utgopu' } ЁЯзк loginUser called with: { EmpNo: 'twkhqn', password: 'juvgwg', captcha: 'zoxrmc' } ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '10' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTUzNzUwNiwiZXhwIjoxNzUxNjIzOTA2fQ.YU1O3NG20vnaVkGEPoDLoyKynLBcIV7an-cWyykn-0w Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; 🔍 Received empNo: EMP001 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` ORDER BY `Employee`.`EmployeeId` DESC LIMIT 1; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `yearlyleave` AS `YearlyLeave`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; ЁЯзк loginUser called with: { EmpNo: 'EMP002', password: '1234@', captcha: '11' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; 🔍 Checking password for user: EMP002 🔑 Hashed password from DB: $2b$10$6xY6lNsr6aLn/2T208xB6ubLbK3FdCar996SGrJ5g13j.0I4p7LZi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMiIsInJvbGUiOiJlbnRyeSIsImlhdCI6MTc1MTUzNzU3NywiZXhwIjoxNzUxNjIzOTc3fQ.JlDkf4LxB6GeYehGQloy7ZGXae8NU75KC-HH2jthuWY Sequelize: Executing (default): SELECT COUNT(*) as total FROM Leaves Sequelize: Executing (default): SHOW TABLE STATUS LIKE 'Leaves' 🔍 Received empNo: EMP002 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; ЁЯзк loginUser called with: { EmpNo: 'jytiul', password: 'gzkzof', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'jytiul', password: 'gzkzof', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'jytiul', password: 'gzkzof', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'gzkzof', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'gzkzof', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'gzkzof', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'gzkzof', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'zlbbam', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'zlbbam', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'zlbbam', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'zlbbam', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'zlbbam', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'zlbbam', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'zlbbam', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'zlbbam', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'zlbbam', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'zlbbam', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'zlbbam', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'fwmcvd', captcha: 'sxgtow' } ЁЯзк loginUser called with: { EmpNo: 'xvxcku', password: 'fwmcvd', captcha: 'sxgtow' } 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` ✅ Server running: http://testtwo.onebox.pk:2001 ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '7' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTU0NzM2MiwiZXhwIjoxNzUxNjMzNzYyfQ.8THsxQgzAFCCfwg5e-GZIbtqYxrPKV6PtiPPPNnTffo Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; 🔍 Received empNo: EMP001 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `yearlyleave` AS `YearlyLeave`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` ORDER BY `Employee`.`EmployeeId` DESC LIMIT 1; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `yearlyleave` AS `YearlyLeave`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '12' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTU1MDE2NywiZXhwIjoxNzUxNjM2NTY3fQ.Kkh7ozHU8ij8tTe9YxaojjlDGyHshDVcBPzTws_VIq8 Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; 🔍 Received empNo: EMP001 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `yearlyleave` AS `YearlyLeave`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` ORDER BY `Employee`.`EmployeeId` DESC LIMIT 1; ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '9' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTU1MDIyNSwiZXhwIjoxNzUxNjM2NjI1fQ.1N-em-wmqJbX1gzJv4Uw_-8SBeiyfqK9RECyssKnUBo Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; 🔍 Received empNo: EMP001 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 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` ✅ Server running: http://testtwo.onebox.pk:2001 ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '10' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTU1MjI0NywiZXhwIjoxNzUxNjM4NjQ3fQ.jaX-WqgPkWwN3SZVyvaXX98xM5n3wDRnF53_3bdDM0Q ЁЯзк loginUser called with: { EmpNo: 'EMP002', password: '1234@', captcha: '5' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; 🔍 Checking password for user: EMP002 🔑 Hashed password from DB: $2b$10$6xY6lNsr6aLn/2T208xB6ubLbK3FdCar996SGrJ5g13j.0I4p7LZi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMiIsInJvbGUiOiJlbnRyeSIsImlhdCI6MTc1MTU1MjI4OSwiZXhwIjoxNzUxNjM4Njg5fQ.vjRPfBLJa8CjrZN-vfCIIokrNz_xIk4AmyRBr_5wrVE Sequelize: Executing (default): SELECT COUNT(*) as total FROM Leaves 🔍 Received empNo: EMP002 Sequelize: Executing (default): SHOW TABLE STATUS LIKE 'Leaves' 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` ✅ Server running: http://testtwo.onebox.pk:2001 ЁЯзк loginUser called with: { EmpNo: 'EMP002', password: '1234', captcha: '12' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; 🔍 Checking password for user: EMP002 🔑 Hashed password from DB: $2b$10$6xY6lNsr6aLn/2T208xB6ubLbK3FdCar996SGrJ5g13j.0I4p7LZi ЁЯзк loginUser called with: { EmpNo: 'EMP002', password: '1234@', captcha: '11' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; 🔍 Checking password for user: EMP002 🔑 Hashed password from DB: $2b$10$6xY6lNsr6aLn/2T208xB6ubLbK3FdCar996SGrJ5g13j.0I4p7LZi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMiIsInJvbGUiOiJlbnRyeSIsImlhdCI6MTc1MTg3NDY2NSwiZXhwIjoxNzUxOTYxMDY1fQ.QN_SNzq7K_JT5sr0_Kq_kdTWLTj0DWEUqFYASBAseXM Sequelize: Executing (default): SELECT COUNT(*) as total FROM Leaves Sequelize: Executing (default): SHOW TABLE STATUS LIKE 'Leaves' 🔍 Received empNo: EMP002 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; ЁЯзк loginUser called with: { EmpNo: 'EMP004', password: 'securepassword123', captcha: '2' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP004'; 🔍 Checking password for user: EMP004 🔑 Hashed password from DB: $2b$10$IZGUy1J7.5wW8WgPI5nobuyYSpDa95aR5WACJL6NOIpBslMdPsS22 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwNCIsInJvbGUiOiJlbnRyeSIsImlhdCI6MTc1MTg3NDczMCwiZXhwIjoxNzUxOTYxMTMwfQ.QpuwKaj1pBw7iBWSoZMhGmh-B9TIFDv8fihiiKJxwtM Sequelize: Executing (default): SELECT COUNT(*) as total FROM Leaves Sequelize: Executing (default): SHOW TABLE STATUS LIKE 'Leaves' 🔍 Received empNo: EMP004 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP004'; ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '18' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTg3NDc1NywiZXhwIjoxNzUxOTYxMTU3fQ.8jaJa006dugpZmB86bBpUErEO6ipUFGa21meKAr7t38 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` ✅ Server running: http://testtwo.onebox.pk:2001 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '12' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTg3ODAwNSwiZXhwIjoxNzUxOTY0NDA1fQ.u8O9-hnThtYNoSpmnrVDH4FAqiRnWnKCGf0MtBTRJ6Y Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; 🔍 Received empNo: EMP001 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '14' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTg3ODA4NSwiZXhwIjoxNzUxOTY0NDg1fQ.omUJ9cnLQeq6KxGjZOLibXlDfpN6RPBJD98Fx-DVBoc Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; 🔍 Received empNo: EMP001 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `yearlyleave` AS `YearlyLeave`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): UPDATE `Leaves` SET `LeaveID`=?,`LeaveDate`=?,`EmployeeName`=?,`EmpNo`=?,`EmpStatus`=?,`Department`=?,`Designation`=?,`LeaveType`=?,`LeavePurpose`=?,`NoOfDaysRequired`=?,`ImmediateOfficer`=?,`GeneralManager`=?,`LeaveStatus`=? WHERE `LeaveID` = ? Sequelize: Executing (default): UPDATE `Leaves` SET `LeaveID`=?,`LeaveDate`=?,`EmployeeName`=?,`EmpNo`=?,`EmpStatus`=?,`Department`=?,`Designation`=?,`LeaveType`=?,`LeavePurpose`=?,`NoOfDaysRequired`=?,`ImmediateOfficer`=?,`GeneralManager`=?,`LeaveStatus`=? WHERE `LeaveID` = ? Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '2'; Sequelize: Executing (default): DELETE FROM `Leaves` WHERE `LeaveID` = 2 Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '15' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTg3ODczNSwiZXhwIjoxNzUxOTY1MTM1fQ.YKHVmbvFNWpa8lxm0elxiOVp4m0KMuZ4jX8pAh55uJc Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; 🔍 Received empNo: EMP001 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): UPDATE `Leaves` SET `LeaveID`=?,`LeaveDate`=?,`EmployeeName`=?,`EmpNo`=?,`EmpStatus`=?,`Department`=?,`Designation`=?,`LeaveType`=?,`LeavePurpose`=?,`NoOfDaysRequired`=?,`ImmediateOfficer`=?,`GeneralManager`=?,`LeaveStatus`=? WHERE `LeaveID` = ? 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` ✅ Server running: http://testtwo.onebox.pk:2001 ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '6' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTk2NjMyNSwiZXhwIjoxNzUyMDUyNzI1fQ.6UBbAAtQgrEay3EbvofBqqjoepbjFxYrhUfGJqUNmog Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; 🔍 Received empNo: EMP001 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `yearlyleave` AS `YearlyLeave`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): UPDATE `Leaves` SET `LeaveID`=?,`LeaveDate`=?,`EmployeeName`=?,`EmpNo`=?,`EmpStatus`=?,`Department`=?,`Designation`=?,`LeaveType`=?,`LeavePurpose`=?,`NoOfDaysRequired`=?,`ImmediateOfficer`=?,`GeneralManager`=?,`LeaveStatus`=? WHERE `LeaveID` = ? Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `yearlyleave` AS `YearlyLeave`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; ЁЯзк loginUser called with: { EmpNo: 'EMP002', password: '1234@', captcha: '15' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; 🔍 Checking password for user: EMP002 🔑 Hashed password from DB: $2b$10$6xY6lNsr6aLn/2T208xB6ubLbK3FdCar996SGrJ5g13j.0I4p7LZi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMiIsInJvbGUiOiJlbnRyeSIsImlhdCI6MTc1MTk2NjM3NywiZXhwIjoxNzUyMDUyNzc3fQ.vWxt6FA0A5LbiYhdLx_wEgEXSFvXyr6PcDhxmCG0u84 Sequelize: Executing (default): SELECT COUNT(*) as total FROM Leaves Sequelize: Executing (default): SHOW TABLE STATUS LIKE 'Leaves' 🔍 Received empNo: EMP002 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '13' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTk2NjQ2NywiZXhwIjoxNzUyMDUyODY3fQ.7981d7yzOhCLwab-ELGjfo60DLMgfMQ26nFDgwY6ZfY 🔍 Received empNo: EMP001 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` ORDER BY `Employee`.`EmployeeId` DESC LIMIT 1; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; ЁЯзк loginUser called with: { EmpNo: 'EMP001', password: 'A1@786', captcha: '11' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; 🔍 Checking password for user: EMP001 🔑 Hashed password from DB: $2b$10$.d9gFZ18iVE8BHNssOfnxOr05JgeoJR/jvateui42H5DeyIAlT/Hi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMSIsInJvbGUiOiJhZG1pbiIsImlhdCI6MTc1MTk2NzIzMywiZXhwIjoxNzUyMDUzNjMzfQ.oHGjIDAyHCFR9NiM98Ei9xRbC-wdcsbIaBOpCFJeipQ Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; 🔍 Received empNo: EMP001 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP001'; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `yearlyLeaveID`, `EmployeeId`, `LeaveID`, `periodOfDuty`, `leaveAtCredit`, `leaveAvailed`, `startDate`, `endDate`, `balanceLeave`, `remarks` FROM `yearlyleave` AS `YearlyLeave`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave` WHERE `Leave`.`LeaveID` = '1'; Sequelize: Executing (default): DELETE FROM `Leaves` WHERE `LeaveID` = 1 Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee`; Sequelize: Executing (default): SELECT `LeaveID`, `LeaveDate`, `EmployeeName`, `EmpNo`, `EmpStatus`, `Department`, `Designation`, `LeaveType`, `LeavePurpose`, `NoOfDaysRequired`, `ImmediateOfficer`, `GeneralManager`, `LeaveStatus` FROM `Leaves` AS `Leave`; ЁЯзк loginUser called with: { EmpNo: 'EMP002', password: '1234@', captcha: '17' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; 🔍 Checking password for user: EMP002 🔑 Hashed password from DB: $2b$10$6xY6lNsr6aLn/2T208xB6ubLbK3FdCar996SGrJ5g13j.0I4p7LZi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMiIsInJvbGUiOiJlbnRyeSIsImlhdCI6MTc1MTk2NzU2NSwiZXhwIjoxNzUyMDUzOTY1fQ.6dnzRcKMFTaUh2ELva_2YwC43a4z3yfJz5PM1no9BPw Sequelize: Executing (default): SELECT COUNT(*) as total FROM Leaves Sequelize: Executing (default): ALTER TABLE Leaves AUTO_INCREMENT = 1 Sequelize: Executing (default): SHOW TABLE STATUS LIKE 'Leaves' 🔍 Received empNo: EMP002 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; ЁЯзк loginUser called with: { EmpNo: 'EMP002', password: '1234@', captcha: '19' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; 🔍 Checking password for user: EMP002 🔑 Hashed password from DB: $2b$10$6xY6lNsr6aLn/2T208xB6ubLbK3FdCar996SGrJ5g13j.0I4p7LZi 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwMiIsInJvbGUiOiJlbnRyeSIsImlhdCI6MTc1MTk2ODQzOCwiZXhwIjoxNzUyMDU0ODM4fQ.w5-oCV15JTCqs1XKBEBOAs_c46XZiCFRCUUqiT53kfw Sequelize: Executing (default): SELECT COUNT(*) as total FROM Leaves Sequelize: Executing (default): ALTER TABLE Leaves AUTO_INCREMENT = 1 Sequelize: Executing (default): SHOW TABLE STATUS LIKE 'Leaves' 🔍 Received empNo: EMP002 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP002'; ЁЯзк loginUser called with: { EmpNo: 'EMP004', password: 'securepasswork123', captcha: '5' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP004'; 🔍 Checking password for user: EMP004 🔑 Hashed password from DB: $2b$10$IZGUy1J7.5wW8WgPI5nobuyYSpDa95aR5WACJL6NOIpBslMdPsS22 ЁЯзк loginUser called with: { EmpNo: 'EMP004', password: 'securepassword123', captcha: '7' } Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP004'; 🔍 Checking password for user: EMP004 🔑 Hashed password from DB: $2b$10$IZGUy1J7.5wW8WgPI5nobuyYSpDa95aR5WACJL6NOIpBslMdPsS22 🔐 Token generated: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbXBObyI6IkVNUDAwNCIsInJvbGUiOiJlbnRyeSIsImlhdCI6MTc1MTk2OTAyNCwiZXhwIjoxNzUyMDU1NDI0fQ.3hPjnFrN8b3wJOhJmCz-c4b9bASuuJHAiUVB-KcrWYU Sequelize: Executing (default): SELECT COUNT(*) as total FROM Leaves Sequelize: Executing (default): ALTER TABLE Leaves AUTO_INCREMENT = 1 Sequelize: Executing (default): SHOW TABLE STATUS LIKE 'Leaves' 🔍 Received empNo: EMP004 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP004'; 🔍 Received empNo: EMP004 Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP004'; Sequelize: Executing (default): SELECT `EmployeeId`, `EmpNo`, `EmployeeName`, `password`, `role`, `AvailedLeaveCL`, `AvailedLeaveML`, `AvailedBalancedOfCL`, `AvailedBalancedOfML`, `DateOfJoining` FROM `employee` AS `Employee` WHERE `Employee`.`EmpNo` = 'EMP004'; Sequelize: Executing (default): INSERT INTO `yearlyleave` (`yearlyLeaveID`,`EmployeeId`,`LeaveID`,`periodOfDuty`,`leaveAtCredit`,`leaveAvailed`,`startDate`,`endDate`,`balanceLeave`,`remarks`) VALUES (DEFAULT,?,?,?,?,?,?,?,?,?); Sequelize: Executing (default): INSERT INTO `Leaves` (`LeaveID`,`LeaveDate`,`EmployeeName`,`EmpNo`,`EmpStatus`,`Department`,`Designation`,`LeaveType`,`LeavePurpose`,`NoOfDaysRequired`,`ImmediateOfficer`,`GeneralManager`,`LeaveStatus`) VALUES (DEFAULT,?,?,?,?,?,?,?,?,?,?,?,?);