INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'd93df19f-76f3-4c6f-ad21-e08197562daf',
    '0612778c-0d59-4879-b108-617d5c51501f',
    433563,
    '2024-01-15',
    '2024-01-21',
    '[{\"task\": {\"uuid\": \"421269cd-082f-4dfe-99e4-38c26d90bc13\", \"value\": \"Worked on the CAn module driver.\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"15938288-78a5-49f5-9ea9-42b1f38c90c3\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Jan-19\": {\"uuid\": \"20ad3474-a3ee-4ef7-8493-bca4ca572605\", \"value\": \"08:00\", \"isLocked\": false}, \"Mon-Jan-15\": {\"uuid\": \"22ba5403-7d6d-446b-9c59-bd53c130071c\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jan-20\": {\"uuid\": \"04eddefe-7651-442f-9305-4a44235486eb\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jan-21\": {\"uuid\": \"a835dd5f-0732-4bb0-8f21-25aae92aeb91\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jan-18\": {\"uuid\": \"b9d2f746-08ac-4a85-9ced-b6a2baefea78\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jan-16\": {\"uuid\": \"bdc97c87-5f7f-4650-841f-2f734327e03f\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Jan-17\": {\"uuid\": \"a0e47a33-714b-45d6-b864-3a89a5bbd9dc\", \"value\": \"00:00\", \"isLocked\": true}}]',
    8.00,
    'APPROVED',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'super_user',
    '2024-01-23',
    'Thanks',
    'APPROVED',
    '2024-01-20 13:20:42',
    '0612778c-0d59-4879-b108-617d5c51501f',
    '2024-01-23 00:00:00',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'dafb4518-8119-484a-b791-3daa0289c9be',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    183230,
    '2024-05-20',
    '2024-05-26',
    '[{\"task\": {\"uuid\": \"26c16dd4-3597-458b-89a5-dc6048c627ed\", \"value\": \"Rollout package and FM for EVConnect\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"22ea982c-6cf4-4cc0-98e8-f09d0ee4d2be\", \"value\": \"16:00\", \"isLocked\": false}, \"Fri-May-24\": {\"uuid\": \"491d2cb5-7328-4a0c-a2fd-076dc7b89bd4\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-20\": {\"uuid\": \"b09f77d3-49d4-48da-a29e-f0256c169995\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-25\": {\"uuid\": \"cd0ba915-8b3a-42e1-83b4-a4763d1daa29\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-26\": {\"uuid\": \"eebf2746-5cdf-467a-a459-92e4c2ffca93\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-23\": {\"uuid\": \"ee580556-53bd-4658-9939-29b7dbd9ff22\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-21\": {\"uuid\": \"a73a8c98-98b5-4fff-960a-685ccaea2f5b\", \"value\": \"07:00\", \"isLocked\": true}, \"Wed-May-22\": {\"uuid\": \"27a22f67-ffee-4129-851f-45a8b7642c80\", \"value\": \"09:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"56ac3695-80de-460f-a7f4-5074e6ac5c74\", \"value\": \"Setting update Panel design\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"fb1f1ea2-dec2-43c8-a8cc-f254d14eb663\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-May-24\": {\"uuid\": \"6c5d1e6e-ed4d-4c1a-9c63-9450ef2b4bf3\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-20\": {\"uuid\": \"268abbe4-90a9-44a1-bc31-15b1c84adae4\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-25\": {\"uuid\": \"107248e1-f4bf-4c61-a148-396209ac3e83\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-26\": {\"uuid\": \"a5ecafe3-2e22-4155-a113-224f7396466e\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-23\": {\"uuid\": \"75679829-a1b9-4aa0-84b3-935dc8d2b6d8\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-21\": {\"uuid\": \"5466cece-3d8e-4a96-86c9-a7282201460c\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-22\": {\"uuid\": \"43d51f9e-627e-43f2-9f56-b1b4b7148605\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"5a18c8cd-1bfb-4b13-a8b1-b60bd0197003\", \"value\": \"Setting update Panel for 2.0\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"074ff2d5-1c44-44a6-8c6a-1d8ebd303526\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-May-24\": {\"uuid\": \"ec384d25-3670-4b1a-b5e1-0753a3efab5b\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-20\": {\"uuid\": \"c6ce64ab-ac17-49d2-abaf-e70a6ce1d8d3\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-25\": {\"uuid\": \"8227227a-fe02-40d8-ac5b-e819c6c34a5d\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-26\": {\"uuid\": \"2aecea42-245b-45b0-be9b-542f052c7095\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-23\": {\"uuid\": \"c191cb79-b7e4-4bb2-981e-e9548b4f3d21\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-May-21\": {\"uuid\": \"39044735-99b4-46e0-ab2e-7baaaed0dd07\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-22\": {\"uuid\": \"9fdc6184-1cbc-4c6b-ba73-ce0bb95c577b\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"71e48838-d524-4834-8c32-069175eb2284\", \"value\": \"configuration in OCPP 1.6 and 2.0\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"857335e4-8bb0-4f40-bdb6-3de03d0893aa\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-May-24\": {\"uuid\": \"b30e6695-1023-4cc2-8762-3e0103f23ea9\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-20\": {\"uuid\": \"a5f9354f-1e81-4a15-9bef-a84203cafdc1\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-May-25\": {\"uuid\": \"66690a83-7458-4237-a879-68506a34ae3f\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-26\": {\"uuid\": \"67454a6a-73c6-4873-8e6d-7196f7e861c4\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-23\": {\"uuid\": \"8b32df02-ebbe-42a7-8872-e4e689bf66cd\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-21\": {\"uuid\": \"1757fdb2-4c95-4f54-b5ca-fcb8a4d14ef0\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-22\": {\"uuid\": \"cea013da-f5ca-4ecf-9e02-c47f602781e9\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"20fbdd25-af1b-4ac6-9083-9479aa4227ff\", \"value\": \"Setting update Panel\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"6cdc6d70-b73b-4bcd-b456-097d1b8400a5\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-May-24\": {\"uuid\": \"2eb30425-cd33-49b0-ae83-0d4f3b7d1aa9\", \"value\": \"08:00\", \"isLocked\": true}, \"Mon-May-20\": {\"uuid\": \"4f5e28a4-08b5-4fe4-bfd3-5390ec6a2b41\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-25\": {\"uuid\": \"13c0fc05-a1fc-4fc3-8fbe-bb3622c31d99\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-26\": {\"uuid\": \"5c025dc1-8e5e-4b5e-a5c8-d29f051a1230\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-23\": {\"uuid\": \"44d8cf3f-33cf-4eaf-b1d3-0b1e200ef995\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-21\": {\"uuid\": \"f0120526-dada-4dbf-9f3a-e63fcb3aa561\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-22\": {\"uuid\": \"88f90d3b-3772-4182-82be-988411513c3a\", \"value\": \"00:00\", \"isLocked\": true}}]',
    42.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-05-22 13:02:32',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    '2024-05-28 00:00:00',
    'b7b859f3-e78b-43a6-9752-457104c52024'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'db99839d-7d66-499d-86f3-f771e9118ca4',
    'ac236a3b-3093-4921-b876-d1b23873df93',
    150911,
    '2025-03-31',
    '2025-04-06',
    '[{\"task\": {\"uuid\": \"c6618a90-23d8-481e-930c-b7c0122a9dca\", \"value\": \"Workout RISO module code\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"058397a1-559f-4384-8192-a81220427485\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Apr-04\": {\"uuid\": \"9e3663f0-d729-4a8b-93a8-17221e6365bd\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Mar-31\": {\"uuid\": \"90a07ca4-9b09-43a7-96d3-20cfb2e91bdd\", \"value\": \"08:00\", \"isLocked\": false}, \"Sat-Apr-05\": {\"uuid\": \"6ddb8380-6f50-4c5a-a8a6-6b93628b5372\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Apr-06\": {\"uuid\": \"76f555ec-2b11-4abe-866c-c3afcadb70b8\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Apr-03\": {\"uuid\": \"a77c7742-1097-48b4-862e-5804b5ce36ac\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Apr-01\": {\"uuid\": \"ae59d3ff-c8a6-41e7-9f12-7f661e9548c2\", \"value\": \"00:00\", \"isLocked\": false}, \"Wed-Apr-02\": {\"uuid\": \"95645377-e28b-4a8c-b832-cd0d06d8a6a7\", \"value\": \"00:00\", \"isLocked\": false}}]',
    8.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-03-29 13:58:42',
    'ac236a3b-3093-4921-b876-d1b23873df93',
    NULL,
    'ac236a3b-3093-4921-b876-d1b23873df93'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'dbd0f782-cf88-4c2f-b7ea-9ad3f26de4fa',
    'eca7545f-2c1d-4170-836e-5f863a05db2e',
    648010,
    '2024-12-23',
    '2024-12-29',
    '[{\"task\": {\"uuid\": \"cb36fd60-9fc2-4c6b-af6a-94f02d6282b0\", \"value\": \"Verify modbus rtu response from Docklight and our programâ\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"14ad1175-6deb-497d-b3de-20992dcd5c76\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"8c5f83cd-1b61-4eda-87d0-8b7369bce579\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"f7a7e70c-78cf-4730-a238-87f8b5ed4f2f\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"d501e8b6-c06b-4c89-b276-7eb2a28a1b2a\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"80854d39-fbea-435a-9ffa-f23149114545\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"66099f18-565c-4cda-98a2-e28b59a4cd3a\", \"value\": \"02:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"75034abb-d274-4d54-9a05-2c866c7d9aa2\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"ab4ac9af-63cb-4531-b6e5-7400675eea4a\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"5beae87e-e7ae-4e4f-b17a-d749c326b51f\", \"value\": \"Daily meeting for project discussion\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"ccbfc958-df61-46f3-895f-a3b2e46a6cf8\", \"value\": \"01:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"cb941e72-df88-495b-8ac8-ac892ac40d6e\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"340ea5c6-f4c7-4d62-ac96-da89734e80e5\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"beecfdf7-c94d-46ff-a51f-e8cbd380f0c6\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"a246aed7-f39b-4f27-95a6-37145553f699\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"f9ac6d4e-af0f-422b-81b7-38d868309b12\", \"value\": \"01:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"2ad11786-115d-4364-ab33-f63384f8ea07\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"c2f15ca3-176f-439f-b8a6-5111e9478ce5\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"7901777c-035f-49f9-91c9-78241a3dd048\", \"value\": \"Modify code for getting 16 register value request on modbus rtu \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"ee3fe9a3-2d8a-41f8-97a7-33677e61f15a\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"660df397-b68e-408e-b88c-8cca02a58c1f\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"472e0e88-46cc-4e26-9d70-d87c63fc919a\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"335640c7-2f63-4e14-a1a0-4257214bbabb\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"f82319e0-d7d2-4e14-8524-167ef0304cd9\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"6dcec0ad-316a-40cc-91ec-6ebae5faf93c\", \"value\": \"02:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"37e2b086-d4f8-412a-8402-a83072bdf328\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"500faf4c-1b9e-4bd8-8048-ae29b36ce915\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"820808b3-b6bc-4706-bcdf-db1e00de670a\", \"value\": \"Adding relay gpio for their status on modbus tcp \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"46f42f78-d0d9-44fc-a667-0be56350a1f5\", \"value\": \"01:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"6911dab8-ae1f-47b4-9b3f-4b07103ca96a\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"0f6e25fd-6511-4fa9-b987-62b8f681028b\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"df77a639-76b6-44bf-b98d-b4c1a1be39df\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"9fb0832d-dc3f-439a-8689-3319c010dc75\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"4dbf722a-86c5-4e1b-afbb-2543792937fe\", \"value\": \"01:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"0aa58ec4-6648-4b06-b9ed-dc34cc996d26\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"88ec729c-b685-4fb5-8129-57fba4c158d0\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"ea3170d6-6cf8-4332-b59d-dde53ec9057f\", \"value\": \"Working on Coding standard for MMI Modbus\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"7c953cdb-47ec-4927-9cdc-ce64e91f5a96\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"a0136a3f-79e3-487d-9676-a07d259f51e0\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"e413be19-9a32-4838-ac7f-e19d84de5d57\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"78348fd0-5724-4050-9d57-3cfb39628087\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"c0143d68-ceec-4809-b514-847591ee1c4b\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"03653302-f8ce-4694-92f9-877c43cf0906\", \"value\": \"02:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"2169a155-5137-479d-930d-0b7e9dcc0556\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"2c991247-75a8-4e6b-a533-dfe965eea8ef\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"8b99b141-80ad-459f-b9a5-6bb57171c62b\", \"value\": \"Working on Coding standard for MMI Modbus\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"dec1fcef-3991-483f-8f41-ec2e6f31be74\", \"value\": \"01:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"230ae420-a5b7-49d6-9392-33710f79c902\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"26a90a26-46af-45bc-bef9-ca731355b159\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"f397e9f3-3cf3-4780-8c97-282f95438a4c\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"682cfeed-cde6-4240-acf4-34ce350bd118\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"55145932-40b3-46b5-b25e-cdf239a2efcd\", \"value\": \"01:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"51f35a25-4c57-4446-9a7f-4e13c79b36c7\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"ed6c8da8-e43e-4623-9c6f-09c27b7478f3\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"d44c6b6e-adc8-4962-ba0e-1a743dbb0815\", \"value\": \"Working on Coding standard for MMI Modbus\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"6a8743e2-88df-4d40-ba07-3dbcad143608\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"4b3c12f6-a288-48b5-a250-cedd09b50998\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"89e1a56b-daea-494c-ad69-7a27ce378620\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"34a22db2-c5a2-4f17-8a14-abe1e7507cc0\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"f121eabe-e0fc-453f-aa02-b3f04f3fa30c\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"9c4e6f1d-6e9c-451e-b98a-5ee24be2e144\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"bf646368-e3dc-4294-a0e4-547019b3dfd3\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"0573bcbd-e5a3-459d-be00-392d389b7b7f\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"78e3dd8f-0dcf-4303-a0b0-b2c3121d9386\", \"value\": \"Daily meeting for project discussion\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"02fa74a4-ca12-404f-8f02-01a4a2bfe784\", \"value\": \"01:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"9e6c9d40-cdfc-4afd-82b8-a66c2c158080\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"f273742a-3b8a-47dd-9157-3580a4afa73a\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"d82c5b8b-aefd-4615-be15-feff81c6ff66\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"8e0a56f2-481e-43bf-8df7-6345182ca519\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"f7f1640d-3f49-4422-ac4d-eca0b2fddea4\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"3c8a292a-0ea1-4c7a-a39e-ccc6003e48ef\", \"value\": \"01:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"227166c2-21db-4fc6-a72d-2d721f116712\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"409dbb60-cd62-4241-815a-19267961557d\", \"value\": \"PLC and Server communication with software\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"4d4451a1-7c94-4d06-bce3-ee52bdf57872\", \"value\": \"03:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"8a64065e-c77f-4ab9-9388-7743f97d590d\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"c358226e-a4c0-442d-b635-fde519323e9f\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"4052d50c-ef88-4f7b-aac2-74eea5289e4c\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"da85127d-ecea-46fb-af6b-2238ea836077\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"bca93153-86ac-43b9-ad76-9a155c355974\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"ba575bec-2588-4e48-bbcd-cf1448fbb835\", \"value\": \"03:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"796d0d6f-9911-4846-b1b4-0cd81bd816d8\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"e4323461-e85d-490e-9fad-7723510a49fb\", \"value\": \"Implementing GPIO relay status code for MMI board\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"a2cc6d0d-0edf-425d-98fb-e2a25fd3f12a\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"b8b3ec21-9ffc-4ce2-9cca-6f704e18c1a6\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"1e476fd6-f8c5-4e93-a374-cf1536832867\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"ce970143-a0bd-45da-9fa9-782966847d49\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"37f06485-e78a-44ae-8fed-05456cee452d\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"c644fa2f-9bc8-4771-8d3f-e322af551e0d\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"cdc16537-223a-4d87-a8c7-07cd2b37106f\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"944e0f41-4b42-4482-8164-92b65fa5f615\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"5d57d40a-e07e-4b75-8738-2208dbeb7f67\", \"value\": \"Testing  modbus tcp and rtu with  both the app  \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"6369e856-d2b9-4c65-b2f9-c848f3824d31\", \"value\": \"01:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"6f2e185e-6336-4035-aa00-50c476aa4677\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"5d9f0a20-c16d-44a7-9123-f3e35380eed9\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"c393c66d-8f6e-4be4-ac8c-539c87574061\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"f3794b72-c096-4862-9580-8e0d522f5689\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"78f95b09-b293-4141-957e-013097127623\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"62e6ab85-50ef-401c-93bc-923ea8f2ba75\", \"value\": \"01:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"15b13fcd-d066-4911-8da7-399f6600206c\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"8e5711a1-64c8-43f9-920c-a09ad10cfbd5\", \"value\": \"Understand how to implement relay gpio status.\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"0240a0a4-080e-4226-8db5-287c05447d91\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"290aaacc-be1d-4e34-bfdc-5c7d508cbace\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"5e381880-ed18-431c-b5ed-340610dd9bcc\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"9323e1a2-6d0a-4492-8eaf-f8e74ab6bee6\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"23db3985-65e9-46e8-85aa-46f8fdfc4ff7\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"3c8af7a2-d544-4402-b936-dbb46e560eed\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"17256cb8-ac8b-4c83-85e0-1d2dd9424987\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"21372364-0423-432b-8e8a-c101b9ef843b\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"4b766857-b0bc-4b2e-940a-736573450672\", \"value\": \"Daily meeting for project discussion\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"68098b9f-983e-42d6-93ac-817d58da939c\", \"value\": \"01:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"cdada5db-e2fa-457d-997e-82863dbd4cc6\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"0e8104f8-6813-44a4-b39e-cee6eeb28b57\", \"value\": \"01:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"90c61457-74de-4945-bcea-4f2f726fc25d\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"00171b1a-3c13-47ca-9814-696344e015d2\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"2524bdd7-212e-4338-bf01-e1c2c0419d90\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"3c7d3e18-3710-4cbb-8944-48cfa636086c\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"5cb77a9f-cf8a-4bd4-998a-2974ccc614c1\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"ab722b42-88c6-4361-a224-4ab7fc568f33\", \"value\": \"Make setup of PLC  PPI display getting the temperature  humidity on disp\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"f684fdab-7523-4b90-a6fa-c65f6c158f04\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"5d44731b-2558-4399-ac02-16779e92611d\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"ae65fa93-c6cd-4c80-b117-d00b41c4e0c3\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"8147238b-9004-4d94-8da1-b4ab9716b221\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"4bb401c3-0f89-4a7b-accc-97927fc23cb8\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"71941f1c-3619-4cc3-bb38-dbdb606557d8\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"2272fa2f-e623-4ae7-a3f7-a0e56fefbed7\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"654e13b1-7170-41b6-88f7-dc234e73dd5b\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"13ca285a-14de-48d7-9103-39225a001561\", \"value\": \".Working on sending same request from  display through uart rs232\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"bd205528-303b-40d7-a4b7-e51e42f4a84d\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"28fa8621-e191-4716-bb64-389e4bd80c9c\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"63079e64-b97a-4be7-b886-8b5c957f0114\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"9a8a8302-2051-4729-94cf-6810eb7b0b00\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"a9b28c63-be71-48cd-8748-404e0d481171\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"84f98a6e-b8d6-41dc-b291-a7ad0d6cdad7\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"7ab32dbf-0260-4990-a67f-3c8a3ed7bcfd\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"6edb348b-9f88-4aa1-8a5f-1d0a1e7f8658\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"7d13bf38-90da-4c9e-96e9-f0fe445d4dd9\", \"value\": \"initially we got some issue in MMI usd and make 4 connector for power \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"89608848-7725-4624-8196-79dabb202dde\", \"value\": \"01:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"ac83ba2d-2f5a-4d40-9aa0-d42e9a9cef54\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"dc8217ff-ca13-4e21-bc5b-95bb242f5436\", \"value\": \"01:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"9260ee1c-4bd5-4e9b-9c4a-b05ba808beb0\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"d54c607c-d591-467a-a4fa-c08e21d3c2a0\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"dc4f305a-bf8e-4de7-8305-da55202cf4bd\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"7d60734a-8c98-47fb-a821-e8f112986f3c\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"c0776960-5662-4019-8bb8-ea129af1c6b8\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"ab7d3000-b9c4-45d4-93d8-e86ecc7ce486\", \"value\": \"initially uart transmit - receive not work .after switching gpio 0 to 7 wor\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"1ca08f44-c247-4280-bf71-4235d5e6971b\", \"value\": \"01:00\", \"isLocked\": false}, \"Fri-Dec-27\": {\"uuid\": \"f94aa1b9-bb09-4110-8c6b-9a249bfcde4f\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Dec-23\": {\"uuid\": \"c0beff0d-74fa-41c2-a62a-3de49a36ac8d\", \"value\": \"01:00\", \"isLocked\": true}, \"Sat-Dec-28\": {\"uuid\": \"451047e9-5b6b-44af-ac17-627a5c915575\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Dec-29\": {\"uuid\": \"83012995-eaae-40bc-ae05-20207c361d44\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-26\": {\"uuid\": \"8861aae2-b42e-4f99-a48d-52fe0c875c05\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Dec-24\": {\"uuid\": \"6d11f5cb-8946-4dcd-822c-8b51b66a2c84\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Dec-25\": {\"uuid\": \"877bfc0a-39f2-434a-8a71-441cbe37eb30\", \"value\": \"00:00\", \"isLocked\": true}}]',
    27.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-12-27 02:55:15',
    'eca7545f-2c1d-4170-836e-5f863a05db2e',
    NULL,
    'eca7545f-2c1d-4170-836e-5f863a05db2e'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'dcbfa7d2-b219-4384-9f31-e48ea5e4c6f1',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    527114,
    '2024-06-03',
    '2024-06-09',
    '[{\"task\": {\"uuid\": \"0df1c62a-6aaa-4974-8d21-5cefa586ca4b\", \"value\": \"Candidate Sourcing\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"1e07a3b1-d85b-4c26-b19b-c1f61d926e02\", \"value\": \"11:00\", \"isLocked\": false}, \"Fri-Jun-07\": {\"uuid\": \"6c504b9f-d035-4eb9-a2d4-d780b386c17f\", \"value\": \"03:00\", \"isLocked\": true}, \"Mon-Jun-03\": {\"uuid\": \"3e511aec-7101-46d5-a3b2-54e887e020fb\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Jun-08\": {\"uuid\": \"1a7c2672-db0b-4c7a-bffd-7e6e7bc2fc49\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jun-09\": {\"uuid\": \"a1d0af2a-0002-4990-8596-80b294109725\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jun-06\": {\"uuid\": \"cb07502c-1c8b-4276-9c9e-ac75423316ad\", \"value\": \"02:00\", \"isLocked\": true}, \"Tue-Jun-04\": {\"uuid\": \"b984a76a-91ff-425f-8c7c-27a2cb320de7\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Jun-05\": {\"uuid\": \"2953c8cf-8df2-467d-91f5-ee9b647b0140\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"9a729b92-1b89-419e-9012-39d41d82d71a\", \"value\": \"Interviews Emb Intern\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"49cbf60b-e005-44dc-afde-1b7f7639bf03\", \"value\": \"06:00\", \"isLocked\": false}, \"Fri-Jun-07\": {\"uuid\": \"0b3dbc6c-180d-4738-8ef6-ffafcaddc9c0\", \"value\": \"01:00\", \"isLocked\": true}, \"Mon-Jun-03\": {\"uuid\": \"2da6f11e-d864-40c0-a7d0-fd4a0fc54b70\", \"value\": \"01:00\", \"isLocked\": true}, \"Sat-Jun-08\": {\"uuid\": \"df096172-57da-4fa7-9dfc-b075b671af23\", \"value\": \"01:00\", \"isLocked\": true}, \"Sun-Jun-09\": {\"uuid\": \"fcfd46b8-bc45-4ce9-a1bd-61fe3d2d1ac1\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jun-06\": {\"uuid\": \"2ae814b4-6695-4035-868b-93cbf37dd8a5\", \"value\": \"01:00\", \"isLocked\": true}, \"Tue-Jun-04\": {\"uuid\": \"41c570a5-71b6-457e-8fc2-01028a6a402e\", \"value\": \"01:00\", \"isLocked\": true}, \"Wed-Jun-05\": {\"uuid\": \"9d87cf0d-0d7a-40ea-97b4-0c9b515bd799\", \"value\": \"01:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"8a84648f-38e9-452d-abf3-e205bfff0c6d\", \"value\": \"Core Human Res\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"894bf74f-cf2f-4f67-bb0d-508509101d82\", \"value\": \"14:00\", \"isLocked\": false}, \"Fri-Jun-07\": {\"uuid\": \"15aeba93-f5a4-4118-b3bd-26c0fd27ca1d\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-Jun-03\": {\"uuid\": \"6ee82e88-1509-4adb-8b27-f2e4cb282bd4\", \"value\": \"03:00\", \"isLocked\": true}, \"Sat-Jun-08\": {\"uuid\": \"845e3752-5a55-409a-8ea3-db45a22f27c3\", \"value\": \"02:00\", \"isLocked\": true}, \"Sun-Jun-09\": {\"uuid\": \"f1507b4d-3083-478b-a361-85b0ffa8c081\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jun-06\": {\"uuid\": \"eb339478-5971-47b8-904e-f55645735442\", \"value\": \"02:00\", \"isLocked\": true}, \"Tue-Jun-04\": {\"uuid\": \"a5d8d252-ec11-4daa-8a5a-8d13f01205aa\", \"value\": \"03:00\", \"isLocked\": true}, \"Wed-Jun-05\": {\"uuid\": \"184abfe6-2727-4d64-a770-87a5d3fbf32b\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"8b78a989-8899-4e4f-85b2-897dcfdea612\", \"value\": \"Emp Grievances management\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"610e8d1e-5ef7-4235-823d-308fcb72fc11\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Jun-07\": {\"uuid\": \"b7918d30-a6c8-41ab-85e0-5cc7c2bda657\", \"value\": \"01:00\", \"isLocked\": true}, \"Mon-Jun-03\": {\"uuid\": \"fed23947-076e-4f36-97c9-0222fe26ff7d\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Jun-08\": {\"uuid\": \"10d8d4e1-f530-47d7-87d1-664aac52e2bb\", \"value\": \"01:00\", \"isLocked\": true}, \"Sun-Jun-09\": {\"uuid\": \"260c2ba7-790b-4438-996f-7208c722a307\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jun-06\": {\"uuid\": \"969b09b3-a0c8-44ae-a47b-cec0645ddd02\", \"value\": \"01:00\", \"isLocked\": true}, \"Tue-Jun-04\": {\"uuid\": \"f3425c76-deea-4c18-9922-1630a1f98289\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Jun-05\": {\"uuid\": \"9eecb0f3-5e97-451c-bf20-7d25da521795\", \"value\": \"01:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"3ac3e1a4-9ef1-470e-9d14-8c2bdec72abb\", \"value\": \"Documentations\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"bd0d1ea4-efe4-40b8-a7a9-19db927b2ffd\", \"value\": \"05:00\", \"isLocked\": false}, \"Fri-Jun-07\": {\"uuid\": \"56fba10f-7cb8-4666-8cc1-b27c5a82116b\", \"value\": \"01:00\", \"isLocked\": true}, \"Mon-Jun-03\": {\"uuid\": \"7d270b96-6335-4d17-8b2f-d75b091df637\", \"value\": \"01:00\", \"isLocked\": true}, \"Sat-Jun-08\": {\"uuid\": \"166416b2-4862-49d7-bff6-bf0ae972420b\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jun-09\": {\"uuid\": \"7bc331f5-1434-43e8-a478-cbf087a071d3\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jun-06\": {\"uuid\": \"6bd697a5-4e1b-4730-a826-f99ebc4fa493\", \"value\": \"01:00\", \"isLocked\": true}, \"Tue-Jun-04\": {\"uuid\": \"5a3f2763-5e53-45c0-9a23-9e69d3796f0e\", \"value\": \"01:00\", \"isLocked\": true}, \"Wed-Jun-05\": {\"uuid\": \"e7d56101-70c9-43f7-b505-669e9c965a11\", \"value\": \"01:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"e1c2c8a4-3784-4398-8994-3ef5ffa695c2\", \"value\": \"Campus Empanelment CDAC\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"28be17ff-b9b3-437f-b532-ae5eef4b724f\", \"value\": \"05:00\", \"isLocked\": false}, \"Fri-Jun-07\": {\"uuid\": \"a8fda018-fdd3-4669-9d67-058760518544\", \"value\": \"01:00\", \"isLocked\": true}, \"Mon-Jun-03\": {\"uuid\": \"73504760-dd44-459e-82c6-00aeda9aa2f9\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Jun-08\": {\"uuid\": \"d8bb8649-bf28-47c1-ae65-30f070621efb\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jun-09\": {\"uuid\": \"c739278e-4434-419c-85f4-a476ab482b00\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jun-06\": {\"uuid\": \"09b644ec-8f50-4538-8cd9-e2f20a9c5e3b\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jun-04\": {\"uuid\": \"3c104149-0821-447b-b068-ffa084b76ba3\", \"value\": \"01:00\", \"isLocked\": true}, \"Wed-Jun-05\": {\"uuid\": \"611b577e-e861-4065-8011-eecb0273ffc2\", \"value\": \"01:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"f231caa4-8b30-49fc-b613-7b898719b5e9\", \"value\": \"Website Progress Verification\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"01945364-ba7e-45a6-9778-8af045f70dd6\", \"value\": \"05:00\", \"isLocked\": false}, \"Fri-Jun-07\": {\"uuid\": \"144e8b5e-8690-41c3-a46e-148bcbaa372b\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jun-03\": {\"uuid\": \"b52bd658-1f50-46a7-9e55-09df948f3f93\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Jun-08\": {\"uuid\": \"3f404552-ca79-46ab-800b-0a0470295165\", \"value\": \"01:00\", \"isLocked\": true}, \"Sun-Jun-09\": {\"uuid\": \"d6bb284f-ef73-4226-9588-1f7d65390632\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jun-06\": {\"uuid\": \"e76b01b7-ba8e-4be4-8ab0-2da81eeb3e14\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jun-04\": {\"uuid\": \"04f2e2a0-a7c4-497a-b817-2702a5b11adb\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Jun-05\": {\"uuid\": \"f1aa17ab-b685-491b-a729-f643b0ebb46a\", \"value\": \"00:00\", \"isLocked\": true}}]',
    54.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-06-10 09:18:41',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    NULL,
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'e379d0bd-1d13-43c6-98a2-212f09af5308',
    '0612778c-0d59-4879-b108-617d5c51501f',
    426216,
    '2024-07-08',
    '2024-07-14',
    '[{\"task\": {\"uuid\": \"a582c6fd-811b-46d4-9689-c21ef10877e2\", \"value\": \"Reading the document for LCD screen design. \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"a56818ca-f718-485d-b217-e0af9ef7e961\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Jul-12\": {\"uuid\": \"75905331-9a94-42c0-9bfb-f9aea3cdac18\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jul-08\": {\"uuid\": \"dca8fc74-bcac-4e30-9afc-70e2bb091cbf\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Jul-13\": {\"uuid\": \"33f7d254-fefd-4318-ae6f-9fd0a5bb969a\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jul-14\": {\"uuid\": \"f1558222-4f6d-478d-a457-96a635c7e0bc\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jul-11\": {\"uuid\": \"86a70a01-ce88-41ec-ba6b-9b57cbc95022\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jul-09\": {\"uuid\": \"0d713783-6eb7-44d3-99cc-a9f7aee1ba64\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Jul-10\": {\"uuid\": \"210010e8-64f2-4364-975c-f4fd9dea8c79\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"424d146a-763a-44d5-b437-e6a9502afba7\", \"value\": \"reading the document for LCD screen design.\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"e197357c-456f-4d7c-af15-c8d65dcf3c25\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Jul-12\": {\"uuid\": \"6412b05e-5fa9-48a1-819b-adb6b4be3dec\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jul-08\": {\"uuid\": \"48129b96-0113-4f53-a377-1d79b9365f56\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jul-13\": {\"uuid\": \"739b1acc-2a8c-4342-8d7c-7a3b942cff0d\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jul-14\": {\"uuid\": \"73a67499-2522-43db-bb41-d0ed4309d9c5\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jul-11\": {\"uuid\": \"5f2a4099-f58f-496c-a378-5de436c13f5b\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jul-09\": {\"uuid\": \"b4924152-c25c-4f52-802e-46a7b341b274\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Jul-10\": {\"uuid\": \"88d354ed-e1d5-4a33-82ff-2af29ccde8f7\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"7348760a-54d3-4b7a-a49f-c97ddbfe83dd\", \"value\": \"Understanding the Use of the tool AppWizard for screen design.\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"e06b0ad7-8329-4481-a683-e5b7d360297d\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Jul-12\": {\"uuid\": \"ab91d169-e741-4275-a094-ddcfc789582d\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jul-08\": {\"uuid\": \"aac32dbb-c3cb-43f0-ad21-19bf666601bb\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jul-13\": {\"uuid\": \"4327d70f-ff0c-4eaf-8b69-3df26ca385ea\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jul-14\": {\"uuid\": \"0dd1903d-fe86-4e0e-a2d4-dc88776a0145\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jul-11\": {\"uuid\": \"0401ff30-257c-4e75-bbd6-fbe98539c14f\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jul-09\": {\"uuid\": \"7c48631d-c6ea-4872-9605-24c5a905d019\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Jul-10\": {\"uuid\": \"7e347d59-56ca-423b-b99b-27b1586664c9\", \"value\": \"08:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"528963d5-5933-4c90-a3ba-eb7f89bd6bbd\", \"value\": \"generating sample code of scrren design for different interface. serial stc\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"30700102-5196-45e0-bc66-dde4b042811c\", \"value\": \"16:00\", \"isLocked\": false}, \"Fri-Jul-12\": {\"uuid\": \"eff67392-49ad-4b3a-b345-c33601963c37\", \"value\": \"08:00\", \"isLocked\": true}, \"Mon-Jul-08\": {\"uuid\": \"7049c73a-c58c-413b-b0cf-55a334e150da\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jul-13\": {\"uuid\": \"70cb0665-adda-4409-9b9e-4e62763c6d85\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jul-14\": {\"uuid\": \"a6c2b4bd-5247-4781-8184-c78f269c3786\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jul-11\": {\"uuid\": \"bfb47e9a-bc5f-4d23-976e-345dd33c7065\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-Jul-09\": {\"uuid\": \"632e3ff9-106f-4c90-aa44-d4803ef6bc56\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Jul-10\": {\"uuid\": \"b6fe973b-9243-491b-80fb-d8c7c37a7c39\", \"value\": \"00:00\", \"isLocked\": true}}]',
    40.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-07-19 10:53:46',
    '0612778c-0d59-4879-b108-617d5c51501f',
    NULL,
    '0612778c-0d59-4879-b108-617d5c51501f'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'e4371180-64fb-43bb-b1c7-337a671136f3',
    'f598a09a-6a20-4e8b-9fc6-1167a48a1270',
    839760,
    '2024-01-22',
    '2024-01-28',
    '[{\"task\": {\"uuid\": \"c2030f0e-0ba1-4b91-b25c-431fe6544aeb\", \"value\": \"Fixes for LOG FOLDER CUSTOMER NAME\'s array\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"140e078b-4880-48f4-aac4-228dd92d5088\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Jan-26\": {\"uuid\": \"f4261424-8dc8-4fc0-bc41-2ad85fde2534\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Jan-22\": {\"uuid\": \"03e22099-a236-4d90-83d2-3b29ea023d1b\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jan-27\": {\"uuid\": \"d928266a-8863-4498-8606-bf1cad29b3ec\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jan-28\": {\"uuid\": \"20313938-4b47-48a7-a086-52f7b4c86b0d\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jan-25\": {\"uuid\": \"28c57102-a1f4-4c45-8ec5-595c39b7c0a6\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Jan-23\": {\"uuid\": \"afa8c827-79f9-4a0c-9970-151b94888fab\", \"value\": \"02:00\", \"isLocked\": false}, \"Wed-Jan-24\": {\"uuid\": \"89f1b460-dee5-473f-af8c-7e1ceadc03ab\", \"value\": \"00:00\", \"isLocked\": false}}, {\"task\": {\"uuid\": \"585443f4-fdf5-445b-a43a-3b6a5ffbd34e\", \"value\": \"Fixes for Reset Password and Forgot Password Page\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"fed1b20f-2cc3-4b4e-ac6d-aa8030952214\", \"value\": \"06:00\", \"isLocked\": false}, \"Fri-Jan-26\": {\"uuid\": \"49e62844-b3d6-4788-b092-33f305e50597\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Jan-22\": {\"uuid\": \"320199e4-bd69-432e-be73-54edf61ed9fb\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jan-27\": {\"uuid\": \"713ab818-c662-4366-973c-1ff575ec5654\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jan-28\": {\"uuid\": \"0c4b7e4b-610c-430d-8978-d11ac4c83a13\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jan-25\": {\"uuid\": \"ea8b4406-b5b5-43b1-9998-5ac14bd4a4dc\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Jan-23\": {\"uuid\": \"02ffffde-42fb-4f1b-8c74-9de29d676bbb\", \"value\": \"06:00\", \"isLocked\": false}, \"Wed-Jan-24\": {\"uuid\": \"0f84f007-1a2d-4db4-9764-03f027e29ef2\", \"value\": \"00:00\", \"isLocked\": false}}, {\"task\": {\"uuid\": \"a449bf44-5961-4d28-8346-15a07afda2b6\", \"value\": \"Fixes for Reset Password and Forgot Password Page\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"40c9ac01-1605-491a-87a7-38bcd669b7eb\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Jan-26\": {\"uuid\": \"ef3938a1-8148-4fb5-8236-1a611c856ab0\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Jan-22\": {\"uuid\": \"230d5b52-596a-4c36-8ffd-7ed12f8866ae\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jan-27\": {\"uuid\": \"9a2004b9-7ffd-4e96-a140-5dae09eb47f8\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jan-28\": {\"uuid\": \"81ff63c4-22c3-44ec-83a3-b76fb10e96ce\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jan-25\": {\"uuid\": \"4522a64d-2f59-4de9-b2fc-6f2529a9dcdc\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Jan-23\": {\"uuid\": \"cb1ad528-e37c-45ef-ad97-94036bb963cd\", \"value\": \"02:00\", \"isLocked\": false}, \"Wed-Jan-24\": {\"uuid\": \"447eafe3-f55a-41fa-b5bc-8527ef2fe42d\", \"value\": \"00:00\", \"isLocked\": false}}, {\"task\": {\"uuid\": \"6e4a7766-84ec-493b-8e30-2ef8d0e60942\", \"value\": \"Fixes for ENEL Customer seeder\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"5a487958-fad2-404a-bf2e-fab4db46d3a9\", \"value\": \"01:00\", \"isLocked\": false}, \"Fri-Jan-26\": {\"uuid\": \"415f77a9-059c-4489-a93c-909ac4258dc7\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Jan-22\": {\"uuid\": \"8373d13f-df4a-40d1-b0fd-1d3c1a24ac0a\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jan-27\": {\"uuid\": \"2e78eab1-7236-41e1-9ce6-73d18924161a\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jan-28\": {\"uuid\": \"3a2cc5a8-664f-4651-b62e-28b6d25ce0bd\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jan-25\": {\"uuid\": \"83e30a56-e4e0-44fc-9b8a-bf2b8f92b2fd\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Jan-23\": {\"uuid\": \"0fd32b4f-8198-4e19-bd46-b44409aefeee\", \"value\": \"01:00\", \"isLocked\": false}, \"Wed-Jan-24\": {\"uuid\": \"64da0c55-a461-4911-9d5b-4dc100ac51f7\", \"value\": \"00:00\", \"isLocked\": false}}]',
    11.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-01-24 06:59:19',
    'f598a09a-6a20-4e8b-9fc6-1167a48a1270',
    '2024-01-24 00:00:00',
    'f598a09a-6a20-4e8b-9fc6-1167a48a1270'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'e545a48f-5f70-426e-91bf-b4cc9ee7a444',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    525090,
    '2024-02-19',
    '2024-02-25',
    '[{\"task\": {\"uuid\": \"2a64b645-dc3e-48f6-9ccc-6c40ce05ed93\", \"value\": \"AA-Incremental Difference Query Resolve\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"77e88bc4-b189-454d-9faa-b5d02b646c3a\", \"value\": \"05:00\", \"isLocked\": false}, \"Fri-Feb-23\": {\"uuid\": \"cf558351-f70c-45bf-ba0e-9d14c7fa65c3\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Feb-19\": {\"uuid\": \"c13449be-43fb-4639-8bfb-7a9a4a36f973\", \"value\": \"03:00\", \"isLocked\": true}, \"Sat-Feb-24\": {\"uuid\": \"419c5ef9-9c0f-42dc-94e5-5700a1301e0a\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Feb-25\": {\"uuid\": \"be34179b-f3cc-4cdf-9094-c614b9113b72\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Feb-22\": {\"uuid\": \"5cd8709d-7e7e-46a5-958f-734288972d22\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Feb-20\": {\"uuid\": \"d2bb759b-c42e-4034-a6ba-7a297ac9b069\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Feb-21\": {\"uuid\": \"7f848f07-efec-48f0-b819-30ba28d77656\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"517fe73e-e9b7-46a2-b761-ed0738bd7697\", \"value\": \"Amol Rokade Appraisal Process Initiation\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"24a235fb-5749-4a97-a436-12052ca05521\", \"value\": \"03:00\", \"isLocked\": false}, \"Fri-Feb-23\": {\"uuid\": \"3eadae75-7f9f-43d1-a8c1-10da51bc2f11\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Feb-19\": {\"uuid\": \"bef02ba6-1501-4b39-b4d5-4d8891d19f3c\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Feb-24\": {\"uuid\": \"c177d30e-f763-4f92-8cd3-b53ffa887d87\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Feb-25\": {\"uuid\": \"2e47ca50-75da-4f0c-a643-64521da0d780\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Feb-22\": {\"uuid\": \"0668e6a9-93a6-40a2-97cb-3a03d3ef9dd3\", \"value\": \"02:00\", \"isLocked\": false}, \"Tue-Feb-20\": {\"uuid\": \"4d4022d0-ad51-4615-b84d-55e6ff9f944b\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Feb-21\": {\"uuid\": \"bb86e007-7894-453c-b83e-ad1b64116cf0\", \"value\": \"01:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"603d9041-bbaf-46b2-ae42-6f1515579514\", \"value\": \"Handling Employee Queries\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"ffc02516-e3a3-4c3c-9638-de5064a7f59d\", \"value\": \"05:00\", \"isLocked\": false}, \"Fri-Feb-23\": {\"uuid\": \"cd24302c-6721-47bc-88a4-82e404bcbacd\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Feb-19\": {\"uuid\": \"beb078cf-8779-4567-81ae-637fcf7fde54\", \"value\": \"01:00\", \"isLocked\": true}, \"Sat-Feb-24\": {\"uuid\": \"dcf0249e-07c6-4373-80a8-fdcbe56665cd\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Feb-25\": {\"uuid\": \"e4b14642-04c8-442c-8f89-9a4750881661\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Feb-22\": {\"uuid\": \"ca6289c1-8914-4cb6-9682-0bd35174dd0d\", \"value\": \"02:00\", \"isLocked\": false}, \"Tue-Feb-20\": {\"uuid\": \"9caec0bd-b454-44b6-9134-71c152667126\", \"value\": \"01:00\", \"isLocked\": true}, \"Wed-Feb-21\": {\"uuid\": \"2d28f3c4-1e0a-44e9-9afb-5323c65cd1af\", \"value\": \"01:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"586b168a-dd05-4786-9f2d-0602e02873c5\", \"value\": \"Santosh-Per  diem calculations and Reportings\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"a4fce587-d2b1-4e7c-84b5-24eb97f19565\", \"value\": \"03:00\", \"isLocked\": false}, \"Fri-Feb-23\": {\"uuid\": \"3c854b31-65f6-42ef-afe8-259ac5cdbc0f\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Feb-19\": {\"uuid\": \"1e91baa2-c6f8-4abd-9764-b2b8d5ffb09f\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Feb-24\": {\"uuid\": \"915ae794-323a-4f8c-b3ea-faf9f02bf475\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Feb-25\": {\"uuid\": \"08fd68df-690f-41cc-96ee-58a07281be4d\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Feb-22\": {\"uuid\": \"4e7a1443-8fb3-4601-8d31-7c4fc5ce8a16\", \"value\": \"03:00\", \"isLocked\": false}, \"Tue-Feb-20\": {\"uuid\": \"697eb451-2dca-4652-823b-5c9fd56ee3c9\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Feb-21\": {\"uuid\": \"b158bf60-2f3d-481e-a7ab-4d57faf48dde\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"d37cac7f-2d9f-4e6a-852d-d6c30da77ace\", \"value\": \"Revised Salary accounting report submission to Accounts Department\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"dd441fd1-668d-43b2-97e2-f9c24e8262e2\", \"value\": \"04:00\", \"isLocked\": false}, \"Fri-Feb-23\": {\"uuid\": \"b0f7a0ae-8e0f-4fc6-9262-644ff2c421c8\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Feb-19\": {\"uuid\": \"69e37038-240c-4afa-aa63-9d61aca5dda1\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Feb-24\": {\"uuid\": \"5f9e728b-d1e6-471b-a563-8df648a90ca3\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Feb-25\": {\"uuid\": \"5bbaac8f-1a28-46a9-9266-1ba705c51482\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Feb-22\": {\"uuid\": \"d0575518-dd4c-4f36-b24b-9748088f311d\", \"value\": \"02:00\", \"isLocked\": false}, \"Tue-Feb-20\": {\"uuid\": \"71c26198-c086-430f-be23-e5d01ba2ef0d\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Feb-21\": {\"uuid\": \"ebe1e183-facb-4490-ae1a-fe6c8c1069c5\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"88643094-6e47-4ab0-a1f0-0e23373cce72\", \"value\": \"HR Intern Screenings\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"00157988-b999-4771-93e4-32b625013a63\", \"value\": \"04:00\", \"isLocked\": false}, \"Fri-Feb-23\": {\"uuid\": \"dcec4676-66d0-44e2-8c96-5de0e29bf09e\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Feb-19\": {\"uuid\": \"39beb7e5-cf85-485b-8564-38d77f618576\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Feb-24\": {\"uuid\": \"10bbc6db-7675-412c-91ed-875f61c89383\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Feb-25\": {\"uuid\": \"d5eefff5-e8f7-46e6-8cf3-d6372f335a26\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Feb-22\": {\"uuid\": \"731b3835-d9ce-4f92-adbc-fc39ec2b2813\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Feb-20\": {\"uuid\": \"fb095771-a56f-4fa4-b0a5-083ae21af639\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Feb-21\": {\"uuid\": \"943e6c3d-e094-4674-a883-2a2251b3ace2\", \"value\": \"04:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"b668bceb-a8c0-4c9a-80e3-8cd180d80f10\", \"value\": \"JD Creation\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"e8e725a3-245f-450c-a74f-7be7eb1022b4\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Feb-23\": {\"uuid\": \"137e2d54-d6b5-44f5-8f0b-0415c6c0ea13\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Feb-19\": {\"uuid\": \"909af330-f546-405c-8a48-49740a17a319\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Feb-24\": {\"uuid\": \"2880ea37-3587-4b8f-973c-4906e13c76aa\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Feb-25\": {\"uuid\": \"d8cfb939-3a9a-4384-89dd-f2ccbd4bbc6e\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Feb-22\": {\"uuid\": \"d4789115-5178-4756-ae9d-94008363d90e\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Feb-20\": {\"uuid\": \"25a44abf-be3b-4637-89d9-326d388de4cf\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Feb-21\": {\"uuid\": \"38eb26a0-0631-4dbc-b067-be3ca943b4a0\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"ee7d8e31-45cb-4b6b-a040-a65969ee4eef\", \"value\": \"Vodichron Work\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"fac03bcf-cbae-4968-bf05-441496fa9ebf\", \"value\": \"06:00\", \"isLocked\": false}, \"Fri-Feb-23\": {\"uuid\": \"17d25f83-6832-4aea-872c-34c9817dd39c\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Feb-19\": {\"uuid\": \"b668bdd6-87c9-4642-9146-ad6a4293614a\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Feb-24\": {\"uuid\": \"cd4fb28b-7020-4aeb-8965-577d99d00c9d\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Feb-25\": {\"uuid\": \"e28a4c11-c286-4437-9cf1-4d89f59dd9d0\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Feb-22\": {\"uuid\": \"1fc00961-fb92-4a0c-b9d2-3adca638404a\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Feb-20\": {\"uuid\": \"1f30da07-6d4a-4d2d-b02b-3b8639dc620f\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Feb-21\": {\"uuid\": \"493c22a8-c973-4543-a39a-7036441f5662\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"9349b337-d113-4127-8f28-abd83a79bf89\", \"value\": \"Vodichron Policy Content Creation\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"520e291d-4cd3-4071-b31a-09bf6b6306fe\", \"value\": \"04:00\", \"isLocked\": false}, \"Fri-Feb-23\": {\"uuid\": \"9bfa7e96-e2da-4140-8eeb-e3ad1244eca9\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Feb-19\": {\"uuid\": \"aacf01ab-6159-4ed0-b6af-946c16dce4b0\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Feb-24\": {\"uuid\": \"900381a7-da1b-4495-8454-962c575d3ba1\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Feb-25\": {\"uuid\": \"25791dfb-a235-4930-bdf1-6365c0505427\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Feb-22\": {\"uuid\": \"1fa668e5-9d70-4b21-99ee-2a3bca7fac63\", \"value\": \"02:00\", \"isLocked\": false}, \"Tue-Feb-20\": {\"uuid\": \"ed5cdb02-c0c7-4477-90aa-d93e8ed6089b\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Feb-21\": {\"uuid\": \"2f046baa-785e-4607-ab46-807000d9f91f\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"5ce102cb-17db-4264-a19b-6cdf7305db1d\", \"value\": \"Job portals verifications-Search for relevant platforms\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"11bd4140-7586-46d0-877c-2a619a73aeb5\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Feb-23\": {\"uuid\": \"6ebeea9a-9d64-43b3-bec3-7d386febd9a7\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Feb-19\": {\"uuid\": \"c4b78767-b3fe-41f4-ad20-170df6dbb9d1\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Feb-24\": {\"uuid\": \"8f09684a-ab9d-48a7-99d3-27e78ee0c51a\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Feb-25\": {\"uuid\": \"10968809-141e-4845-a017-302006586e21\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Feb-22\": {\"uuid\": \"48fe45fb-db36-4d41-b52a-c87ee5b58a69\", \"value\": \"02:00\", \"isLocked\": false}, \"Tue-Feb-20\": {\"uuid\": \"dd5a4c9f-8b06-40ea-bf5f-61b79457aa9b\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Feb-21\": {\"uuid\": \"1df7e71a-3a77-46b9-b2a1-948e15e77c24\", \"value\": \"02:00\", \"isLocked\": true}}]',
    44.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-02-22 20:18:31',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    NULL,
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'e7bd7bd7-e5e5-4f32-b547-b0ef44de4a35',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    124270,
    '2024-03-18',
    '2024-03-24',
    '[{\"task\": {\"uuid\": \"bed6fa16-5382-4479-bc56-8f40d07387c4\", \"value\": \"Human Resource-Core Activities\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"1d526c28-6a7d-41e8-b8d5-6cc2204e525d\", \"value\": \"18:00\", \"isLocked\": false}, \"Fri-Mar-22\": {\"uuid\": \"724b012d-6aa6-4e18-ac42-51645075d16e\", \"value\": \"03:00\", \"isLocked\": true}, \"Mon-Mar-18\": {\"uuid\": \"731481d2-1b91-468d-8cd9-86a4c7480de7\", \"value\": \"03:00\", \"isLocked\": true}, \"Sat-Mar-23\": {\"uuid\": \"be81d256-3c1a-452f-9580-25611ea9d488\", \"value\": \"03:00\", \"isLocked\": true}, \"Sun-Mar-24\": {\"uuid\": \"24454197-f71f-4187-958d-240f3dc2a66d\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Mar-21\": {\"uuid\": \"12476fed-cfa1-4325-abb6-94a5884b9920\", \"value\": \"03:00\", \"isLocked\": true}, \"Tue-Mar-19\": {\"uuid\": \"053ca9ba-fbce-4e50-9d75-4aa3d73140c5\", \"value\": \"03:00\", \"isLocked\": true}, \"Wed-Mar-20\": {\"uuid\": \"aa32ef30-f735-4b96-8774-9442462775b5\", \"value\": \"03:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"49a55a17-bddd-4b3e-a9f4-72e38e26d761\", \"value\": \"Accounting Assistance\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"b7965c5c-3d95-4bab-a1f8-f26ce57d0204\", \"value\": \"10:00\", \"isLocked\": false}, \"Fri-Mar-22\": {\"uuid\": \"083b50c5-1766-4b30-9190-20edb8b05279\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-Mar-18\": {\"uuid\": \"87b6cad0-f398-41cd-879f-fa31b3f54026\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Mar-23\": {\"uuid\": \"c93399da-de13-431c-b9b5-715d962e14c2\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Mar-24\": {\"uuid\": \"7bbc4d75-0088-491c-b429-7b8d6cf52255\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Mar-21\": {\"uuid\": \"7813bac3-1bdd-47e0-bc20-40204cba15c2\", \"value\": \"02:00\", \"isLocked\": true}, \"Tue-Mar-19\": {\"uuid\": \"d50513c1-8507-436c-ba78-645bafe3211a\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Mar-20\": {\"uuid\": \"1854f735-bbd0-402a-9c8a-5fbd04e5aa44\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"c7cce7be-3f3a-4e98-a501-d6a2129bd186\", \"value\": \"Recruitments\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"f8f61634-523f-4955-b5b7-6504ab774af4\", \"value\": \"14:00\", \"isLocked\": false}, \"Fri-Mar-22\": {\"uuid\": \"f410d644-b700-42db-a537-07e433dac838\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-Mar-18\": {\"uuid\": \"61d6fbfc-4ca9-43ef-bf5f-49467ffa09c7\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Mar-23\": {\"uuid\": \"0b3c3c14-6ced-46be-858a-3f318050d5a1\", \"value\": \"02:00\", \"isLocked\": true}, \"Sun-Mar-24\": {\"uuid\": \"b9ea1c60-dc30-4fda-8835-6f66bcbdc718\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Mar-21\": {\"uuid\": \"a71d0445-2b96-46ab-86aa-d22583732713\", \"value\": \"03:00\", \"isLocked\": true}, \"Tue-Mar-19\": {\"uuid\": \"9da06ac1-c5ed-4919-a02c-24e8d1e5d9d7\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Mar-20\": {\"uuid\": \"081ada5d-f66e-4ce6-ae83-0a9464512bcc\", \"value\": \"03:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"2a2e04b8-c4ee-4573-8f54-0d65f8d95397\", \"value\": \"Documentations\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"ed6ecaf5-9ef1-4742-a074-f08cd175f944\", \"value\": \"12:00\", \"isLocked\": false}, \"Fri-Mar-22\": {\"uuid\": \"9a8b1b3e-ca9d-436a-ae5d-5dde6b31008f\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-Mar-18\": {\"uuid\": \"87180db7-4257-4d64-ad18-454b2a09716b\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Mar-23\": {\"uuid\": \"d0ac5790-d5b5-494f-bc8f-270e4155e182\", \"value\": \"02:00\", \"isLocked\": true}, \"Sun-Mar-24\": {\"uuid\": \"2ac1ea6d-4119-42cf-a185-843d6a39a2da\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Mar-21\": {\"uuid\": \"079b89b2-dec7-4cc1-88da-a07bde21d16e\", \"value\": \"02:00\", \"isLocked\": true}, \"Tue-Mar-19\": {\"uuid\": \"ad8f7214-0950-455c-bdb2-e862f9ebea0e\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Mar-20\": {\"uuid\": \"9496d6f6-aa5f-4a09-a0ac-e3ff1f8fbde7\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"9cc1ab77-2b9f-4baa-a2f5-97096cbd032d\", \"value\": \"Vodichron\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"241430cb-9b0d-4413-8e0b-64f38be6494d\", \"value\": \"13:00\", \"isLocked\": false}, \"Fri-Mar-22\": {\"uuid\": \"ada40eab-8b6f-4a17-a731-9cf0a8433341\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-Mar-18\": {\"uuid\": \"071c6b1f-b82f-4ad7-9fb7-6ee1211094bf\", \"value\": \"03:00\", \"isLocked\": true}, \"Sat-Mar-23\": {\"uuid\": \"436b2723-e719-4d80-84c2-785be8a88b8a\", \"value\": \"02:00\", \"isLocked\": true}, \"Sun-Mar-24\": {\"uuid\": \"c409e9d5-fc1a-40b9-a8de-e4b09fbbb195\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Mar-21\": {\"uuid\": \"976259a7-0fef-4b8b-9d04-f018382bfce1\", \"value\": \"02:00\", \"isLocked\": true}, \"Tue-Mar-19\": {\"uuid\": \"7f43a2d0-0d23-45f7-9cf6-75c9090047ab\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Mar-20\": {\"uuid\": \"84438d1a-6374-43b9-91be-bb4969067a22\", \"value\": \"02:00\", \"isLocked\": true}}]',
    67.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-03-26 06:50:56',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    NULL,
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'e9855d0f-15e3-4f56-b4de-51aaccb5c12c',
    '0612778c-0d59-4879-b108-617d5c51501f',
    948886,
    '2024-07-01',
    '2024-07-07',
    '[{\"task\": {\"uuid\": \"ec4f19cb-b050-41e1-8ad5-e314b830397e\", \"value\": \"Understanding and taking overview of the LCD display.\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"bde5e62f-16cf-4981-8aa3-4b9fdcbefe84\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Jul-05\": {\"uuid\": \"715b5d06-3014-4930-9034-dad2cbdcaaef\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Jul-01\": {\"uuid\": \"6bdc84d5-d4d2-46c3-a374-f0faa7a083fa\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Jul-06\": {\"uuid\": \"b0698272-72f5-44c4-85d4-e997069737c5\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jul-07\": {\"uuid\": \"0af30e9b-d247-4c95-9397-c3a318782b52\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jul-04\": {\"uuid\": \"8f39e343-7a50-4989-bc82-a36e284858a1\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Jul-02\": {\"uuid\": \"1056c642-be0e-488a-aedf-10a0fc1f8ec6\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Jul-03\": {\"uuid\": \"9100cdc9-861d-42cc-97c4-bbc94d9b7217\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"87017cb3-0ba6-4fce-bb54-7826c049d336\", \"value\": \"Find and study the tools used for the LCD display screen design.\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"91f48838-da81-4276-86e4-ee89e0f7e2fc\", \"value\": \"16:00\", \"isLocked\": false}, \"Fri-Jul-05\": {\"uuid\": \"4c75754e-e1fb-4662-8f81-be23ace02d51\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Jul-01\": {\"uuid\": \"0c813236-da60-4a2d-9eec-e5582d83695d\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jul-06\": {\"uuid\": \"d6ff6ff5-b802-4c60-b892-36d079d87ee0\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jul-07\": {\"uuid\": \"d93d3e02-93cc-4c5a-9ac8-e376a625fb0c\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jul-04\": {\"uuid\": \"d1159cee-cde6-4efa-a426-84dfd5e38667\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Jul-02\": {\"uuid\": \"af20fb15-2e4f-41de-934e-d8ee8c01bb6d\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Jul-03\": {\"uuid\": \"ae106583-cb21-4cbe-8427-27bb3e491371\", \"value\": \"08:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"ff2e475c-467a-4078-bdde-9b88ac4f7d49\", \"value\": \"Created sample code using QE tool for Screen design. understanding Features\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"25bbc891-598a-45fc-be7b-deb788669184\", \"value\": \"16:00\", \"isLocked\": false}, \"Fri-Jul-05\": {\"uuid\": \"d05f6f2b-248a-4340-9248-d3f602f55153\", \"value\": \"08:00\", \"isLocked\": false}, \"Mon-Jul-01\": {\"uuid\": \"96137aaa-8fb0-4275-975c-ea432023ed6d\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jul-06\": {\"uuid\": \"7bba7191-09e5-4ba5-8ddc-310548e84f59\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jul-07\": {\"uuid\": \"7ac8ca69-3cdb-4402-be6e-41028c845360\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jul-04\": {\"uuid\": \"f286e408-50e1-44da-950f-3a09d5174abf\", \"value\": \"08:00\", \"isLocked\": false}, \"Tue-Jul-02\": {\"uuid\": \"44af552a-d4ad-4427-a859-a95856d7103a\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Jul-03\": {\"uuid\": \"33831b0b-26b3-4dbe-bf42-029bf8fe0393\", \"value\": \"00:00\", \"isLocked\": true}}]',
    40.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-07-05 10:10:36',
    '0612778c-0d59-4879-b108-617d5c51501f',
    NULL,
    '0612778c-0d59-4879-b108-617d5c51501f'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'ea965a80-1336-4ae6-9a41-de35d9e496db',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    637112,
    '2025-03-10',
    '2025-03-16',
    '[{\"task\": {\"uuid\": \"f1030a65-529c-4531-bb8d-c9a3304e0bda\", \"value\": \"Setting update panel added provision for different  users and fix issues\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"8e17e8bc-e3d2-49a0-a72a-5f0c9441b626\", \"value\": \"40:00\", \"isLocked\": false}, \"Fri-Mar-14\": {\"uuid\": \"8da2987a-567e-42d9-8349-10897b3f1e59\", \"value\": \"08:00\", \"isLocked\": true}, \"Mon-Mar-10\": {\"uuid\": \"2dec97ec-207c-466e-b613-af05581cdf7e\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Mar-15\": {\"uuid\": \"03061d87-e5d0-4d2e-9868-88e8e125475a\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Mar-16\": {\"uuid\": \"a52fc473-da55-47e9-8284-4689aee1d78a\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Mar-13\": {\"uuid\": \"23765a0c-cac2-4956-ba22-cfc90e15dc83\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-Mar-11\": {\"uuid\": \"ae822d9c-716d-4645-b928-a3207f5f6703\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Mar-12\": {\"uuid\": \"84c4288d-a958-4d05-bf2f-9d4728ceb875\", \"value\": \"08:00\", \"isLocked\": true}}]',
    40.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-03-17 10:19:32',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    NULL,
    'b7b859f3-e78b-43a6-9752-457104c52024'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'eb22c9f5-2a5b-4634-bbfb-34236d2642df',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    765024,
    '2024-07-01',
    '2024-07-07',
    '[{\"task\": {\"uuid\": \"0167532c-2cac-473d-bea8-4723c46ad9c9\", \"value\": \"HR Core \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"68093af2-18b5-4c1a-9478-ecd04433513a\", \"value\": \"12:00\", \"isLocked\": false}, \"Fri-Jul-05\": {\"uuid\": \"7351be4f-c429-45cb-aed4-0ec2b1b3bb1d\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-Jul-01\": {\"uuid\": \"ca9ffb5a-e1bd-4bb9-8463-ce3b533ffa49\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Jul-06\": {\"uuid\": \"10da5e7c-d0fe-4beb-8511-65d115444b33\", \"value\": \"02:00\", \"isLocked\": true}, \"Sun-Jul-07\": {\"uuid\": \"8b3406c9-36f2-4521-9036-d0c596b08c60\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jul-04\": {\"uuid\": \"d3d848ab-f163-4dde-a3d2-18877aa07d64\", \"value\": \"02:00\", \"isLocked\": true}, \"Tue-Jul-02\": {\"uuid\": \"4f451aba-91ae-45be-9316-b574fcc33ea9\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Jul-03\": {\"uuid\": \"b35ef136-6edb-476a-8f0f-14fd229470fb\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"fda09108-1c63-45d2-b388-957e2c9b13c4\", \"value\": \"TDS Computations and salary sheet\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"b2adf778-7477-461d-811c-4750424bc562\", \"value\": \"06:00\", \"isLocked\": false}, \"Fri-Jul-05\": {\"uuid\": \"d4ac88e1-34c7-4b45-af21-4b022a120d93\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jul-01\": {\"uuid\": \"6c740126-366f-4d17-953e-32816014a2cf\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jul-06\": {\"uuid\": \"b5ae1f26-24db-40ec-b968-e0ed07cf321b\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jul-07\": {\"uuid\": \"c928e9e0-a999-4eaf-832a-b728acad6c6e\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jul-04\": {\"uuid\": \"086553a8-983a-4f8f-a944-22ea20578a39\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jul-02\": {\"uuid\": \"ffc883da-6893-4291-b4bf-2f76251ab552\", \"value\": \"03:00\", \"isLocked\": true}, \"Wed-Jul-03\": {\"uuid\": \"7123071b-324c-42d0-8409-476033bc1107\", \"value\": \"03:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"95593f7e-2538-44d0-8f1e-982769ce4dd9\", \"value\": \"ES-Documentations\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"c1bf584d-26ff-4d7b-8591-9e80ad8cfce7\", \"value\": \"12:00\", \"isLocked\": false}, \"Fri-Jul-05\": {\"uuid\": \"40c4743f-4a38-41ad-a90d-a65167c405f5\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-Jul-01\": {\"uuid\": \"97139140-09b3-4ef1-a5eb-c57c9c55f0f0\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Jul-06\": {\"uuid\": \"f27cef58-07df-4a0d-a487-3bb9e364b13a\", \"value\": \"02:00\", \"isLocked\": true}, \"Sun-Jul-07\": {\"uuid\": \"8d6de9ca-8789-41ca-9d77-85470c257e5a\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jul-04\": {\"uuid\": \"44b0bcb3-014d-4f3a-a727-757400b46799\", \"value\": \"02:00\", \"isLocked\": true}, \"Tue-Jul-02\": {\"uuid\": \"45175ef9-38e3-47cc-b716-1387ab090db8\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Jul-03\": {\"uuid\": \"1aa13e9e-aaad-479a-80a0-4099d6f92239\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"ce32b179-2c7f-4646-83c8-73a9cf84ea50\", \"value\": \"Intern Guidelines\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"81909107-f456-4f59-b379-bd3c885e6b76\", \"value\": \"04:00\", \"isLocked\": false}, \"Fri-Jul-05\": {\"uuid\": \"1c0ecb2c-81a2-42f4-ad42-87fa529a6d0b\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jul-01\": {\"uuid\": \"78a3ddd2-7b1c-4e61-b74a-4a4b0362a35b\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Jul-06\": {\"uuid\": \"e2a2fe4b-3327-4f5c-8e20-6223fc0b5d2a\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jul-07\": {\"uuid\": \"d6d363fd-cab0-42d8-be4b-b6ddcb0821ca\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jul-04\": {\"uuid\": \"6c2df460-0cc6-4278-9f56-1b48d2584c4f\", \"value\": \"01:00\", \"isLocked\": true}, \"Tue-Jul-02\": {\"uuid\": \"e265ec9d-b0bd-46bc-98b8-0621868b3fb6\", \"value\": \"01:00\", \"isLocked\": true}, \"Wed-Jul-03\": {\"uuid\": \"dcb7cba4-635f-4444-bd1d-b61a44aa52f1\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"f66e11fe-46ba-4e30-895e-12965b890915\", \"value\": \"Employee Grievances and others\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"b570d23a-667d-46f9-baf5-3e66f78a025d\", \"value\": \"11:00\", \"isLocked\": false}, \"Fri-Jul-05\": {\"uuid\": \"53e166fc-78e3-443f-b406-7e8351f952f5\", \"value\": \"01:00\", \"isLocked\": true}, \"Mon-Jul-01\": {\"uuid\": \"a80c5b7f-c91f-4b0d-98e5-547f2a764774\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Jul-06\": {\"uuid\": \"461944d3-c84f-4ebe-a0ce-1cffa2ef83a2\", \"value\": \"01:00\", \"isLocked\": true}, \"Sun-Jul-07\": {\"uuid\": \"60039449-be81-43ef-aa24-04a991cf0603\", \"value\": \"02:00\", \"isLocked\": true}, \"Thu-Jul-04\": {\"uuid\": \"2290eaec-a31b-46da-b4c1-ea12cdc66a86\", \"value\": \"01:00\", \"isLocked\": true}, \"Tue-Jul-02\": {\"uuid\": \"6dbbdca1-2b20-4ac5-8d27-9cafec577169\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Jul-03\": {\"uuid\": \"ba7125ba-d3a1-4c48-950e-50db850a69d3\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"1c36bb6b-4360-4b3f-a7d4-178bf34681b8\", \"value\": \"Vodichron issue rectification\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"47c8aa6e-ec28-4e68-83cf-25559b2c7a90\", \"value\": \"03:00\", \"isLocked\": false}, \"Fri-Jul-05\": {\"uuid\": \"007afd56-3a49-43be-b656-8fff7d5189d6\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jul-01\": {\"uuid\": \"bc9d1927-d685-4287-8ef8-f92624b3633b\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jul-06\": {\"uuid\": \"25b57dd1-40cb-46f0-80e2-8fd7d650393c\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jul-07\": {\"uuid\": \"c8ed5703-6ea2-4064-8f7f-4cee7d558a0b\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jul-04\": {\"uuid\": \"82b6af2d-6749-4953-9331-d3b3f63cbe77\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jul-02\": {\"uuid\": \"40ed5938-bfac-461c-8a20-557062250c58\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Jul-03\": {\"uuid\": \"db29beec-4dc3-429d-b867-2a856bcf2032\", \"value\": \"01:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"569789cc-aa6b-4c0b-910e-83b6eba4770b\", \"value\": \"HR tool design\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"1582e6d3-bf93-47f3-91ff-b9e5bb7e7ef4\", \"value\": \"06:00\", \"isLocked\": false}, \"Fri-Jul-05\": {\"uuid\": \"18ccd6c0-9e4a-42c7-b3a3-962191d5463c\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jul-01\": {\"uuid\": \"3811d99f-3796-45cb-accc-7bce2a6fab4f\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Jul-06\": {\"uuid\": \"7778ecb4-3cfc-456b-85d5-10a072424646\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jul-07\": {\"uuid\": \"34435c37-861f-4f49-a116-e0775d71ec96\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jul-04\": {\"uuid\": \"cf885034-1e92-46f1-ae34-acd1161b5202\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jul-02\": {\"uuid\": \"449357bb-2164-45ed-8bac-2b69af9ed80e\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Jul-03\": {\"uuid\": \"c9f040b6-ef0f-4f88-b9a8-d69a0ca23008\", \"value\": \"02:00\", \"isLocked\": true}}]',
    54.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-07-11 12:34:11',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    NULL,
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'ebedb437-a385-4ee1-9b9a-49ee511179ed',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    900876,
    '2025-05-26',
    '2025-06-01',
    '[{\"task\": {\"uuid\": \"30208735-ec8d-40c1-9817-c69a5139ed23\", \"value\": \"unit test case for reporting module\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"050f8ca5-4a23-438d-afff-ec9e54c437be\", \"value\": \"34:00\", \"isLocked\": false}, \"Fri-May-30\": {\"uuid\": \"669c2efa-2a7d-4ec7-ae47-bf95d539aaa8\", \"value\": \"08:00\", \"isLocked\": true}, \"Mon-May-26\": {\"uuid\": \"1d169416-e06d-4808-8fab-deccf3d00951\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-31\": {\"uuid\": \"5792f1a8-27ca-4927-9079-786db632ad2a\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jun-01\": {\"uuid\": \"0f6fc738-a033-4fef-9306-81f6aeba785c\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-29\": {\"uuid\": \"d1eacf86-a4d8-41ad-94af-4e121288ef93\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-May-27\": {\"uuid\": \"4e3e3374-42f4-4990-b188-6889da375958\", \"value\": \"09:00\", \"isLocked\": true}, \"Wed-May-28\": {\"uuid\": \"1ca27cb8-b337-4710-8ec5-f9c55249f6ee\", \"value\": \"09:00\", \"isLocked\": true}}]',
    34.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-06-03 13:23:01',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    NULL,
    'b7b859f3-e78b-43a6-9752-457104c52024'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'edb55d25-4f46-4862-86cc-a47f2977129a',
    '0612778c-0d59-4879-b108-617d5c51501f',
    143404,
    '2025-01-13',
    '2025-01-19',
    '[{\"task\": {\"uuid\": \"ddd8a5d0-78d4-403c-9ae0-120d45ba2511\", \"value\": \"correcting and closing the review comment on PRD cap-sense and external spe\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"1d3dddf8-207c-4641-8a7c-42ad248cfd71\", \"value\": \"32:00\", \"isLocked\": false}, \"Fri-Jan-17\": {\"uuid\": \"2d0efc1c-fbf1-42b0-a8f7-c71b66743789\", \"value\": \"08:00\", \"isLocked\": false}, \"Mon-Jan-13\": {\"uuid\": \"aad3b7fe-3e60-4e1d-abd0-5a5027efd7c6\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Jan-18\": {\"uuid\": \"64bcd8e5-5030-40a2-a6f3-b140623574eb\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jan-19\": {\"uuid\": \"921f6887-5eda-4f09-87ec-36ca0d9835ad\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jan-16\": {\"uuid\": \"8e2314fc-8e91-4432-b478-0df5abeba85a\", \"value\": \"08:00\", \"isLocked\": false}, \"Tue-Jan-14\": {\"uuid\": \"cf8f7301-cf27-4a2f-a3f9-06da388e8d55\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Jan-15\": {\"uuid\": \"952949c2-0a81-4de0-8340-44530bb2bcf7\", \"value\": \"00:00\", \"isLocked\": false}}]',
    32.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-01-16 04:25:07',
    '0612778c-0d59-4879-b108-617d5c51501f',
    NULL,
    '0612778c-0d59-4879-b108-617d5c51501f'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'eee586d6-e71a-4a02-92ee-1a1632b91d00',
    'ffd826ce-5585-4a76-9b57-6821a68619e3',
    367208,
    '2024-04-08',
    '2024-04-14',
    '[{\"task\": {\"uuid\": \"c95eb771-df9e-4736-a872-f4379b1064c5\", \"value\": \"Multitasking code with RTOS implimenting debug.c in UART 5\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"0a95dc9a-9877-4e51-b702-6391265d764a\", \"value\": \"09:30\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"a33b8c98-e16e-4a2c-9cb3-32481b1ef4e6\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"735451b0-c0c4-4538-aa5d-1cbd31ebb377\", \"value\": \"09:30\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"df66c7ac-9ded-4770-a3f2-e1fe1e39e468\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"a13a1ab9-b461-40ad-9867-ad7abc26ad05\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"31952fba-dda1-4daf-b214-337197e02fd2\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"398af46c-0544-4388-b3df-6ca1c53a5b26\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"8c96ca64-ab29-46de-a932-2399c673a9b6\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"7aca3430-9859-4b71-b119-a0c34f5c19f6\", \"value\": \"Implimenting debug.c in all the pheripheral and tested it\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"d7aef52b-d05a-4b0b-9ece-51f0a219f90e\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"e334dec7-d4ae-46db-a517-e8c9ea5f0455\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"2052ae7b-9904-4a3c-878d-89d5ea94dd97\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"79d27d15-06df-42f6-8fa4-5e32a80d7e85\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"37ecf039-3eb2-4f91-add0-a5df0b19ae1b\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"113215f7-62f4-480a-afe9-188f9746557b\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"9953c8e2-a769-4fb5-8b44-09af24f41d78\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"7492d6a3-8d36-49bc-ac3b-a153b0fd21fd\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"2f2dd2d1-6226-429f-90f9-2b9f596b46af\", \"value\": \"Sprint4 deliverable cheking and updating\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"33ceb8fb-d558-42bc-9649-583796bea183\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"f2911a97-0425-4c3e-bbe9-f51cfeb48d4d\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"4f53560e-00fb-4427-a681-aa1d6009a9d8\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"a1996ff1-dad0-4937-90cc-e6f11544d045\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"f9843eca-ac42-4bde-86a3-765c22586156\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"c1eb01ac-5d6e-42ed-a32e-a10495255355\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"8241202f-de9e-4acd-be6e-e8e02ecc0d95\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"35f61b62-2c64-4919-a7d2-4e2aae39f1e1\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"e76f3b37-d410-435b-8a19-539a3733e948\", \"value\": \"MOM updated\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"9a74ba82-8afb-410b-b2c0-ea3a48e39d26\", \"value\": \"01:00\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"c3f74fc1-84b3-4762-91db-cb94cd6c6f59\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"9a27d4a1-405b-4c84-839d-10f62ce1ca4b\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"8b4e0287-c99a-4f21-a49a-6b0b28569ad1\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"cc2133d7-c0ce-4f71-abf7-cde86acc2cab\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"019d3317-40dc-4663-90c2-67c474b00ce4\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"72f12173-b7ee-4633-a788-d8f03ba2a293\", \"value\": \"01:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"4bb47400-6242-4811-bd75-d6da5d2d5c60\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"578648e7-4f78-432d-a7a0-8517446ab4fa\", \"value\": \"Code for watchdog timer and tested it in code \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"7331938f-4372-4c1d-8975-ca9504b6868a\", \"value\": \"09:00\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"87b3f3af-2b02-4461-a5e4-c9a0a255ff2c\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"ab94effc-f233-4fa3-bd44-b070430d3633\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"0a1314aa-cad3-4f1b-b90e-afeb30cf8984\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"596f05ed-4ab4-4136-a7e3-e93f874501ec\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"d57c8aad-ae6a-4c13-a557-44133c1846b8\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"7bbbe0ff-1a42-497d-a536-301f351e0cc3\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"a205d864-5f58-4737-b45f-cc59b2bd39f6\", \"value\": \"09:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"4322b4d4-5c30-4b76-bd46-47e56c3bce19\", \"value\": \"code for RS485 transmit and tested \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"3dd3a3e9-45bb-45ca-a2ca-92ddc48d5f0c\", \"value\": \"08:30\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"6dbdfa6c-7197-4420-86eb-4d0added91ca\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"29d340b2-2d88-407d-876a-41f22f231679\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"42086f47-16f0-4bbe-b3c8-3f5c9687ba0a\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"c4578497-a7a5-41af-aa07-6eb1e6a7a61b\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"9c7b28f2-2e21-4f7c-bd4a-3c779b0bf680\", \"value\": \"08:30\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"b9d05b66-0312-4eb6-a2a5-5278d85d73b3\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"b1743aad-79ec-4ede-861b-f1e84c0e9f91\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"67987c80-d747-462f-b930-29ab50fcb0ef\", \"value\": \"code for RS485 receive along with accuracy code worked on excitation curren\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"b271acd4-cad1-462f-b3e6-2893cfb99b58\", \"value\": \"09:30\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"9994f820-4c79-4fc4-8553-94df272ca6ec\", \"value\": \"09:30\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"0b65d95a-f575-4d59-ba36-3512e353b58c\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"88cd0663-2dbd-422a-86c0-bc5921f043b4\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"ae729d08-6460-4ad1-889e-d8e6743e5134\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"2647400f-d789-4855-91ab-f829e33277d4\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"4199489d-7880-4ed9-9d50-9ca94d7a61a1\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"d94f3ec9-02a9-42e0-a157-172008c04d36\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"05fd5de8-1991-4a9d-b919-e3276663a805\", \"value\": \"ADC code with readings along with 485 code \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"1e71cb74-07d0-4bc2-9de7-66e7f5e7a61b\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"708393f9-c9f8-41d6-abe8-028b69b31a5c\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"6fbb0f98-e5b9-48e0-9742-cf71fa36ea7e\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"135a7b61-b177-4a4c-8901-f989b3c85e52\", \"value\": \"08:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"b1ca60d9-a70a-495c-a91e-4d02bcc8883b\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"b8fb8089-7de3-4ede-9084-130925fbce8f\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"bec3333a-5df9-4692-b43e-134cfeb78ff5\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"190bb637-2f1f-41e2-a59b-cbc03ab397c3\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"6423a358-14e1-4b98-b6e7-872283813eb4\", \"value\": \"Multitasking code testing with documentation ADC code with documentation \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"024c70b8-64b6-40ff-ba68-3dd0f55d38b9\", \"value\": \"09:00\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"b5ebbf07-8a22-4ed8-bb8a-f91aa57e0752\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"18f23e97-b78f-4ce2-8dd4-3359a195d119\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"7889beb0-4716-4a2a-a24d-d9ecf1aa5037\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"40e728f3-0ed9-45b0-b4ae-6c28380d70bd\", \"value\": \"09:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"59c110b6-5e83-428c-b4d2-70ff71aa31f4\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"f6e1b75e-ed59-4fa4-8f8a-da17fa63e3b2\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"ae906f06-e0fd-44e4-b23a-3b2415a94503\", \"value\": \"00:00\", \"isLocked\": true}}]',
    64.30,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-04-17 05:12:50',
    'ffd826ce-5585-4a76-9b57-6821a68619e3',
    NULL,
    'ffd826ce-5585-4a76-9b57-6821a68619e3'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'f273add1-b54b-4ce3-b55c-2f74aea25708',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    906262,
    '2024-06-17',
    '2024-06-23',
    '[{\"task\": {\"uuid\": \"b3dfbcb5-eec0-46d4-b888-395c8ec11f93\", \"value\": \"Setting Update Panel\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"b620a552-b5da-4852-9935-348167c69fd1\", \"value\": \"40:00\", \"isLocked\": false}, \"Fri-Jun-21\": {\"uuid\": \"618fa84c-7a3a-40c0-a00f-ef8cfb1af47c\", \"value\": \"08:00\", \"isLocked\": true}, \"Mon-Jun-17\": {\"uuid\": \"3d6308bd-5bbb-4329-984a-d9691863e71d\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Jun-22\": {\"uuid\": \"5b46ecb4-52c8-4bda-a422-df630f8c1803\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jun-23\": {\"uuid\": \"90ea4e3d-b6b7-4d35-ae13-d57813a26c99\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jun-20\": {\"uuid\": \"a33b0109-ca99-4fd9-938e-877ece11943e\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-Jun-18\": {\"uuid\": \"ca922b05-e914-43d5-bb9b-1499e545927f\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Jun-19\": {\"uuid\": \"ff9b1c91-97d9-42a0-9261-c479d83108a7\", \"value\": \"08:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"546e5920-f1d4-46f4-ac45-c1e75bb485e8\", \"value\": \"Firmware Matrix And Rollout package\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"685bc272-b786-4a5c-b47f-0f5275a347ef\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Jun-21\": {\"uuid\": \"f7955770-6a7f-4771-91c3-cee68b8e3c2b\", \"value\": \"01:00\", \"isLocked\": true}, \"Mon-Jun-17\": {\"uuid\": \"f2a8419b-66bc-4103-9271-e73ece54c3dc\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jun-22\": {\"uuid\": \"4de061de-00d9-4847-a8df-fc7efc932c6c\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jun-23\": {\"uuid\": \"549ed307-ccf8-4864-872a-44136f031902\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jun-20\": {\"uuid\": \"ae57f848-9421-4b33-8808-774867a212f3\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jun-18\": {\"uuid\": \"a400e555-0ee0-4dad-9d15-96a744b027ab\", \"value\": \"01:00\", \"isLocked\": true}, \"Wed-Jun-19\": {\"uuid\": \"d325423a-7d75-43ed-800c-a4880aaad6eb\", \"value\": \"00:00\", \"isLocked\": true}}]',
    42.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-06-30 13:43:02',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    NULL,
    'b7b859f3-e78b-43a6-9752-457104c52024'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'f2adda1c-be3f-42b9-a1e3-ee6efa956a4e',
    '0612778c-0d59-4879-b108-617d5c51501f',
    170601,
    '2025-01-06',
    '2025-01-12',
    '[{\"task\": {\"uuid\": \"c3d0b271-9203-4bdf-8d1f-3fb2d9b0fff5\", \"value\": \"Correction and closing the review comment on the PRD are (RTC buzzer LCD)\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"8fff1c0e-d9e3-4e7c-8b00-c1cd20090bfd\", \"value\": \"40:00\", \"isLocked\": false}, \"Fri-Jan-10\": {\"uuid\": \"6cbcd9f4-8964-4a59-b355-fa776d889167\", \"value\": \"08:00\", \"isLocked\": true}, \"Mon-Jan-06\": {\"uuid\": \"ae675430-0136-485d-b784-a98346dfa69c\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Jan-11\": {\"uuid\": \"8d18cd72-34c1-4ab4-a3e8-6d0ed1955a81\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jan-12\": {\"uuid\": \"c1ffb0d2-8971-4623-b053-080d379346ae\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jan-09\": {\"uuid\": \"10a33058-36a7-43d9-bcb5-b0aa0ebeec7d\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-Jan-07\": {\"uuid\": \"a5b64a62-8ef1-4891-920f-faac7e422bb1\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Jan-08\": {\"uuid\": \"d9ea19fb-edb6-48c2-ad15-f5ce0139311c\", \"value\": \"08:00\", \"isLocked\": true}}]',
    40.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-01-16 04:23:27',
    '0612778c-0d59-4879-b108-617d5c51501f',
    NULL,
    '0612778c-0d59-4879-b108-617d5c51501f'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'f63a4ce2-a844-4755-befa-da9ffe61b637',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    44014,
    '2024-07-29',
    '2024-08-04',
    '[{\"task\": {\"uuid\": \"86ff6885-575a-4189-9edd-c05542eb636f\", \"value\": \"Documentations\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"2722321c-9d73-423c-bb4b-824c5075585d\", \"value\": \"10:00\", \"isLocked\": false}, \"Fri-Aug-02\": {\"uuid\": \"f01811b5-863c-4b29-9ea3-f2b58a60e941\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-Jul-29\": {\"uuid\": \"ef850c42-987a-4f97-b33f-6ca1b31ed193\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Aug-03\": {\"uuid\": \"431f17a3-5673-4f70-ab6d-64f1abccc076\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Aug-04\": {\"uuid\": \"f9551c24-8f63-45b1-a198-14746d6aecd2\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Aug-01\": {\"uuid\": \"c014d9c5-95c8-4631-9c73-1e24915f5ce7\", \"value\": \"02:00\", \"isLocked\": true}, \"Tue-Jul-30\": {\"uuid\": \"0ca8160d-ec40-49b7-bca3-fbb0b07bfe49\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Jul-31\": {\"uuid\": \"dfb483ee-e063-4bbf-bc5a-5dad36f85867\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"62d5c7da-0664-4643-a7e2-df9a0df457fd\", \"value\": \"Core HR\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"2326964f-328a-48b7-baa0-a797d860b5e1\", \"value\": \"17:00\", \"isLocked\": false}, \"Fri-Aug-02\": {\"uuid\": \"3d5f7284-6a10-47d5-a61f-447332ca87ce\", \"value\": \"03:00\", \"isLocked\": true}, \"Mon-Jul-29\": {\"uuid\": \"e84f17d1-710b-491f-9fc9-46fa963e5664\", \"value\": \"03:00\", \"isLocked\": true}, \"Sat-Aug-03\": {\"uuid\": \"beaa5580-5130-434d-a783-d902b2e1fe79\", \"value\": \"03:00\", \"isLocked\": true}, \"Sun-Aug-04\": {\"uuid\": \"05b6428d-d4e9-4662-8af4-ff37e7bf3b82\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Aug-01\": {\"uuid\": \"0456f95b-1bed-40c8-82d7-f058425f2ac7\", \"value\": \"03:00\", \"isLocked\": true}, \"Tue-Jul-30\": {\"uuid\": \"10d3bda5-f63f-451c-9a73-2be7b3c34f0b\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Jul-31\": {\"uuid\": \"f016c052-58fc-4f1c-b166-b017d69190ed\", \"value\": \"03:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"390bd32f-a5f7-48e3-a54d-aa9e815c3cf5\", \"value\": \"Employee Grievances handling\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"bc0bc5c1-c829-416c-bae0-0f11cfbe1b6a\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Aug-02\": {\"uuid\": \"a7e65675-c2ec-4c3f-9ceb-9ce07354653c\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jul-29\": {\"uuid\": \"d5feb4a6-400f-4aa1-bbc2-fc452d665bd5\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Aug-03\": {\"uuid\": \"fbb23f68-ac1d-438c-95cb-9f0a49ccc410\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Aug-04\": {\"uuid\": \"cd83c8db-a886-4202-aaac-73318bd89300\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Aug-01\": {\"uuid\": \"7487b283-b352-4b8e-835e-35115e0ca29e\", \"value\": \"02:00\", \"isLocked\": true}, \"Tue-Jul-30\": {\"uuid\": \"1e91bf3a-73c3-4281-bbd5-432a0f56be77\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Jul-31\": {\"uuid\": \"7b38498b-d140-4cb3-9c8b-b8e6f2cf9758\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"219c9b31-50b9-493b-88c8-b43e945144e0\", \"value\": \"Intern KT\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"739dd34f-a5d4-4490-bea3-6d724ca3b93e\", \"value\": \"03:00\", \"isLocked\": false}, \"Fri-Aug-02\": {\"uuid\": \"5ab2b90b-26c4-4c2c-a392-ebc799110009\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jul-29\": {\"uuid\": \"04f958e3-5812-4d17-ba52-910e7985fdcd\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Aug-03\": {\"uuid\": \"e3e47139-a0a6-48e0-9b99-bdb2f73c18b2\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Aug-04\": {\"uuid\": \"faf04cf8-150d-4cdd-9a99-0d4e5fb37452\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Aug-01\": {\"uuid\": \"863a05c9-bdca-44a9-9383-1015968d5113\", \"value\": \"01:00\", \"isLocked\": true}, \"Tue-Jul-30\": {\"uuid\": \"e33a39f0-562c-4403-8c5b-a5a189d8ed0a\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Jul-31\": {\"uuid\": \"0d936341-eda9-476b-ae78-d94a7ee7f46c\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"5d3baceb-27da-40c2-97cd-1a27332be049\", \"value\": \"Organization policy framework\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"d4596df1-0072-4a73-a2f8-02ab827839f9\", \"value\": \"05:00\", \"isLocked\": false}, \"Fri-Aug-02\": {\"uuid\": \"36ab2769-43bd-4d5b-987d-34270ebc7364\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jul-29\": {\"uuid\": \"5bb0b18c-02ec-4c59-8d19-759a99bd25ff\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Aug-03\": {\"uuid\": \"90a7666b-4aea-4aff-8da6-c4c7b5a5a369\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Aug-04\": {\"uuid\": \"d8e81f77-e487-4e9b-84ca-1cdae0044b3a\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Aug-01\": {\"uuid\": \"1278d354-8b0b-4d75-a3e4-fb321bb42c17\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jul-30\": {\"uuid\": \"f0d11290-ec68-42d8-827d-074994f4def7\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Jul-31\": {\"uuid\": \"eee7d62d-a5b4-4f62-bd37-5aecb4632993\", \"value\": \"01:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"8bf149e3-c8ca-42b0-91d8-657d56738d66\", \"value\": \"Report and others\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"ecf91325-cd27-4564-bd4f-2be49e3bcbf4\", \"value\": \"06:00\", \"isLocked\": false}, \"Fri-Aug-02\": {\"uuid\": \"60539963-5c39-43dc-8b8a-db3ab1f32e87\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jul-29\": {\"uuid\": \"8a8026c9-79c6-4786-919c-964734399a65\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Aug-03\": {\"uuid\": \"b65af83d-ad34-4b23-a18f-16cc6b2d8f3e\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Aug-04\": {\"uuid\": \"0d2edc3b-1553-43d9-b980-674efd887abd\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Aug-01\": {\"uuid\": \"717e8dec-bfa6-4139-a98a-95328ee6729b\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jul-30\": {\"uuid\": \"17eb15f0-9303-4d1e-b964-df08e2ad0c90\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Jul-31\": {\"uuid\": \"28019636-9deb-43f1-8272-e42c99714988\", \"value\": \"02:00\", \"isLocked\": true}}]',
    49.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-08-05 07:53:32',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    NULL,
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'f709f74a-63f3-4016-ace7-51661e269470',
    '0612778c-0d59-4879-b108-617d5c51501f',
    120401,
    '2024-04-22',
    '2024-04-28',
    '[{\"task\": {\"uuid\": \"44fcfdc2-48d2-4458-97b9-d0e545e590b7\", \"value\": \"understanding CTSU drivr layer for initial setting.\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"17b2bedc-5abe-4749-86a7-8b463c8272be\", \"value\": \"16:00\", \"isLocked\": false}, \"Fri-Apr-26\": {\"uuid\": \"328ae644-ae10-4152-9e65-8db1b592b2e5\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-22\": {\"uuid\": \"62547ae8-dea8-4a09-b6cd-c8ca58e922cd\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Apr-27\": {\"uuid\": \"93117814-a0db-4824-bdd0-9aa9cfbdfeb3\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-28\": {\"uuid\": \"a32e73b4-3155-426d-9f73-ff5cbc9fbcfe\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-25\": {\"uuid\": \"2ab3dd04-c870-4ab9-bb39-3a642b78631d\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-23\": {\"uuid\": \"cb553210-80d5-40cb-8d2f-111faa6e29c1\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Apr-24\": {\"uuid\": \"b258a8f7-4349-462d-958b-20c4aca51f6d\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"f9c2ede9-48bf-4d50-931b-4f959297378c\", \"value\": \"Understanding CTSU Initial correction process.\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"60bb064d-d5fd-4445-ae75-7e9c86b745d0\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Apr-26\": {\"uuid\": \"3042c99e-91b4-464c-8173-83dfd3285ede\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-22\": {\"uuid\": \"1a198225-9584-421c-b0a4-069fd036462f\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-27\": {\"uuid\": \"4024b806-d128-4180-998a-4e10fe27ad1c\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-28\": {\"uuid\": \"c0676e78-c4fd-468b-9f29-7fc8bcd4d6df\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-25\": {\"uuid\": \"9c288305-9767-4d7b-b75c-ab4e29e5cf62\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-23\": {\"uuid\": \"1aa146fe-17cc-4155-88d9-19a465c80a57\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Apr-24\": {\"uuid\": \"3d825573-6087-4106-9c5e-a8d99465ab2f\", \"value\": \"08:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"ea920360-8bd6-4702-bbf7-1b33c7404a09\", \"value\": \"understanding and making design step document capsense.\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"02dd3f72-b99d-4c4f-a232-99823c33c24d\", \"value\": \"16:00\", \"isLocked\": false}, \"Fri-Apr-26\": {\"uuid\": \"ce8fe647-8857-44e8-8520-d5ed6c1b28f9\", \"value\": \"08:00\", \"isLocked\": true}, \"Mon-Apr-22\": {\"uuid\": \"155834e8-8328-4c7d-ba01-a70f36b4e4a1\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-27\": {\"uuid\": \"d88dd242-d8c5-439d-90f9-50c6b82e034e\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-28\": {\"uuid\": \"ca93febb-a6ff-4985-9ab7-4541d2358942\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-25\": {\"uuid\": \"b052cc8c-a435-4163-baf3-ee48c6de4086\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-Apr-23\": {\"uuid\": \"920f3905-5e14-4426-98fb-8b3b5fa70ce4\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Apr-24\": {\"uuid\": \"50796344-74c3-489c-9342-7c26f70a0f01\", \"value\": \"00:00\", \"isLocked\": true}}]',
    40.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-05-03 07:54:53',
    '0612778c-0d59-4879-b108-617d5c51501f',
    NULL,
    '0612778c-0d59-4879-b108-617d5c51501f'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'f7224a93-646d-49df-bf9c-b90536394a9a',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    603890,
    '2025-01-20',
    '2025-01-26',
    '[{\"task\": {\"uuid\": \"d324934c-adfb-4d94-8765-7ecfcfed4edb\", \"value\": \"CAN Analyzer tool\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"cda098ec-cc9f-4a66-906a-b7b6bae8e2fc\", \"value\": \"32:00\", \"isLocked\": false}, \"Fri-Jan-24\": {\"uuid\": \"d9ebff44-44a5-4290-ae00-34db34309bad\", \"value\": \"08:00\", \"isLocked\": true}, \"Mon-Jan-20\": {\"uuid\": \"2f14d442-54d7-4226-948a-32a5bc4a339f\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Jan-25\": {\"uuid\": \"b4a6ebe0-2ea7-4a8c-bd6c-21ad343ae989\", \"value\": \"08:00\", \"isLocked\": true}, \"Sun-Jan-26\": {\"uuid\": \"699740c9-ffd8-42a2-99dc-7538ec2c4ded\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jan-23\": {\"uuid\": \"42a9b4a1-2e3d-4d7a-b1fe-5eaea89b61cc\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jan-21\": {\"uuid\": \"ac5533d7-b685-4bf0-8ce8-89f9a828684d\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Jan-22\": {\"uuid\": \"c6559bd3-f5cc-4936-840c-885fc00f17cb\", \"value\": \"00:00\", \"isLocked\": true}}]',
    32.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-01-27 07:27:37',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    NULL,
    'b7b859f3-e78b-43a6-9752-457104c52024'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'f80c369e-08b0-43aa-b3e4-fad452d9542c',
    '4dc70b3d-7d22-4d22-ba1e-35be17624c26',
    245597,
    '2025-05-12',
    '2025-05-18',
    '[{\"task\": {\"uuid\": \"426560ec-8d9f-44f9-9f05-d05da3e38f2b\", \"value\": \"Quotation work\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"19a6f0ff-da89-4963-b2af-9328bb3b95f8\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"8f6b987e-841f-48f6-8268-5c4cda6f4744\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"23df4016-98d2-4a16-904a-18b74db2c400\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"0739f986-0313-4b61-a921-9c76241121d4\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"f7436a1d-3e50-4bfd-84a9-a117fdc59d7b\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"a2d26e3d-3d1e-42e6-b67f-088cdacd1d9c\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"1cf456cf-cfd7-4d3c-bb1b-efd017686074\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"c40de271-609f-40ad-99d6-5e0adf64a00a\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"80af8f57-db7f-41ce-95fe-6572d0f664b9\", \"value\": \"Quotation work \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"99aef0b6-7666-4a26-b652-2c9e862000cd\", \"value\": \"05:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"fa906a55-2fe5-41a7-bf6f-b6ffad830682\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"cd88522e-547f-4fb9-840c-e97be98bf7e9\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"84ad7fa4-3b99-48b4-8ca9-8f049c07cf3f\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"cd3baa97-6dd0-44e7-bd28-0bbc6594a001\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"1f591a03-e1a8-4754-9764-4a2e9bc1f57a\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"1a5657b1-3377-4b65-b402-52f0450a4640\", \"value\": \"05:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"f79afdfa-9f60-465d-bf02-ca3426821fea\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"098bcae8-064e-484f-900d-8f0cd54bf3d2\", \"value\": \"template wotk\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"47bb1bcc-c8fe-4757-b9e8-732b5bfd529f\", \"value\": \"03:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"416809e4-3deb-4a70-93f6-ed43681a8883\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"2fac96de-8549-4656-979f-cba8f7e6d8fb\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"e5b4defe-88a5-44e9-a368-52b8fc479266\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"7068b2b6-b425-43b3-846f-54a79aa6d023\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"e53b742c-e534-417e-84ab-2f6f00986a8e\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"1726fa5e-0ddb-404f-90ce-3fc3f5dbcf6d\", \"value\": \"03:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"baf5ab9c-ff1c-4b7a-997f-f3886215e57a\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"b496aad3-cd0f-4a47-948c-b0a955e6cf10\", \"value\": \"purchase order \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"200c97ea-be99-487f-b01d-bfa2c4db39f8\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"908f760d-6c1f-428c-97a2-1b8fb22429c3\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"9321d6ac-7e84-478c-8c1c-09e1e2a8f9af\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"5645746a-89e5-4e89-a7a7-03e18d59ff12\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"50a2559c-fc8a-4ca3-8987-6fe3e9ff84ab\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"5c61a086-5bb3-477f-9201-a8db8501581c\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"396067c5-f5f4-4666-92ad-7db9c2f3c53d\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"853e1bc3-2377-414b-ab48-be7b2eaf68c9\", \"value\": \"08:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"2ca5cc30-5155-4d19-819b-2c34d7a176f4\", \"value\": \"Quotation and order process\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"47fa76cd-7484-465a-b62e-a7c39f927341\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"8df8e31a-add5-4931-9da6-e7879e7913b8\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"23209f42-31ff-4f95-aa3c-27396bd3e2ff\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"aaeba2eb-91fa-4166-a399-2528fea5d308\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"bb55038d-d191-458d-b37a-e86eda0aa76d\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"54c7eed5-d0f1-42fd-b5d2-761e343c70b0\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"22bd47ff-7c93-4e11-828f-bfc2826314d7\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"6fee12ae-3572-4e3b-ac43-38d67c42eef0\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"30dd3f94-51e9-42f7-befa-901e35b0233a\", \"value\": \"flight work process\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"a6a1ebb2-85c1-4c2d-8e2e-8c395f3c7a21\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"7c484000-1483-4653-813e-abc4901f5038\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"a78d11be-e1df-4ac7-b53c-40d3315979e9\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"92cbfb59-96eb-4a32-9413-6ca11d630bb5\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"ef06cdb8-ed39-4683-aedd-829c2cad6ed8\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"75388dd8-028f-4163-aba7-07118f93af51\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"81923e6a-8b77-42cb-9e64-a4920be901f6\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"59676e3a-0152-434b-bd70-8af64c14c95f\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"842332bd-a6b9-4172-8e2c-99786afa727e\", \"value\": \"Expenses work\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"b7568149-bf41-4892-8a90-1badf3b13966\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"a3b59e29-dcde-4c74-bfa5-829cf25f30cf\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"c288e54a-e393-413a-b481-7f6dcc7a8a87\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"0615dfbc-d350-4507-a9bd-d8f6b209938d\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"b84fbef7-a532-4ca6-b79a-c055516f25f6\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"805fcdbd-4d48-4c71-b8df-b7d55cd1d778\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"b606adfa-6b42-4881-8993-1b16f18ceee1\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"c9772ce2-2afc-4f3f-9a15-9896cb577fb2\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"caf87633-94f3-4a10-aff9-9ae18195d494\", \"value\": \"Quotation work\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"6ac10580-efae-48d4-9806-c347f2d1d7fa\", \"value\": \"04:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"9492b6eb-8296-401b-91a2-50dffa6edb7b\", \"value\": \"04:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"1bdc9ebf-df9b-45fe-979f-331b170e109f\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"a79a8ba5-cb4f-4a2b-a2df-0ee6d3af04c0\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"34608971-a989-40d9-8354-032fa0fcae14\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"92967bab-126b-413f-8122-755695b33f10\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"17bebdac-cd77-481d-8f9c-a6de90885731\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"f4aa39f2-2ed2-414d-a5cf-8d64f1830379\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"8ee3c9f5-7d4b-4e7d-a4e3-c2fa660d409e\", \"value\": \"template and quotation work\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"d35fe7ce-f003-4065-89d3-c203f17a6472\", \"value\": \"04:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"79a0f9c8-dd3b-494b-911b-6e1f61bdb128\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"9984f0b7-f314-4717-9ab7-f53e716a4e3f\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"c0a5c127-fc33-42a5-be27-2d37d39d0275\", \"value\": \"04:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"183ebdbf-a5b7-464d-a125-534143431306\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"511b9877-23ac-4f99-84fa-de1fcb163f5d\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"a40f9904-b0cb-4489-bc12-5562769713a3\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"b5c8f471-c58b-407d-99dd-f1722f09f453\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"194a8b81-87e3-494f-a3dc-18095229a947\", \"value\": \"file work \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"0357a125-0e0c-476c-af53-788e99494310\", \"value\": \"04:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"ca72fe2a-ec41-4e18-8233-a41421c1a139\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"c071dfca-7240-441d-b9e0-6dd3e31ed03e\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"2a61a8e1-72e5-4cfb-89cb-78d4c646d2a8\", \"value\": \"04:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"1e4aed22-fccb-49ab-91b6-7ca4d21147f5\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"5530efa7-b425-429c-9a99-af25f8ded9fe\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"1baba9e0-b801-4122-ae7b-9903d47d1d42\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"35c8f400-28b2-4f96-af31-ebda97af9c4f\", \"value\": \"00:00\", \"isLocked\": true}}]',
    48.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-05-20 05:46:58',
    '4dc70b3d-7d22-4d22-ba1e-35be17624c26',
    NULL,
    '4dc70b3d-7d22-4d22-ba1e-35be17624c26'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'f8c7b300-0f52-4106-899b-d7a8a626d50f',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    609700,
    '2025-04-07',
    '2025-04-13',
    '[{\"task\": {\"uuid\": \"b0c116c2-e759-444a-8e65-d6d70ff93ec0\", \"value\": \"write junit test cases for Service package of Reporting\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"2ebadc19-b065-4c6c-8583-4bfc143d56a6\", \"value\": \"33:00\", \"isLocked\": false}, \"Fri-Apr-11\": {\"uuid\": \"30b3774e-7222-45e5-9ba1-1eecd3f88c74\", \"value\": \"09:00\", \"isLocked\": true}, \"Mon-Apr-07\": {\"uuid\": \"6d9cb9ec-9159-477f-8967-7da95de90a03\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Apr-12\": {\"uuid\": \"a224ee25-ac9a-4f8c-8b92-d7d9f7180b57\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-13\": {\"uuid\": \"15cc1d4d-074a-4981-92d7-6eedece04a1a\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Apr-10\": {\"uuid\": \"bdb35629-15e9-460d-aa6b-367117203097\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-Apr-08\": {\"uuid\": \"e5f0e415-141d-4299-aaf1-f48abffc158a\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Apr-09\": {\"uuid\": \"48b51802-4e65-41d2-b557-1204b190c5ac\", \"value\": \"00:00\", \"isLocked\": true}}]',
    33.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-04-14 10:41:54',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    NULL,
    'b7b859f3-e78b-43a6-9752-457104c52024'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'f978771e-5664-42b0-b399-a4262390262f',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    327208,
    '2024-12-16',
    '2024-12-22',
    '[{\"task\": {\"uuid\": \"43880ff9-7536-4e0c-ba4a-fbb6318ac224\", \"value\": \"HR Core\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"a16e4bf3-9bc3-487b-9d27-8f3f35533e23\", \"value\": \"15:00\", \"isLocked\": false}, \"Fri-Dec-20\": {\"uuid\": \"acbff5d0-eb5d-4c7a-ad2d-f89724dcc07b\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-Dec-16\": {\"uuid\": \"b0abe952-fb39-4c8f-a92b-aa5018c8c515\", \"value\": \"04:00\", \"isLocked\": true}, \"Sat-Dec-21\": {\"uuid\": \"930ca2d3-67e2-4aa4-8a61-03169618e4e6\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Dec-22\": {\"uuid\": \"6a5cb4dd-fdc2-4174-a234-813f49be8a3f\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-19\": {\"uuid\": \"a27f9aff-ab17-4a20-9d70-932106e9d0b9\", \"value\": \"02:00\", \"isLocked\": true}, \"Tue-Dec-17\": {\"uuid\": \"85d5e754-2fe1-4360-9557-2242e7d49ff4\", \"value\": \"04:00\", \"isLocked\": true}, \"Wed-Dec-18\": {\"uuid\": \"4ab4bd38-f1d8-4107-ab56-7a88352fa5b0\", \"value\": \"03:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"662cd89a-effc-4408-bf70-2276526cc64d\", \"value\": \"Recruitments process\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"ae14c231-f478-4d35-8a66-de8879456f3d\", \"value\": \"12:00\", \"isLocked\": false}, \"Fri-Dec-20\": {\"uuid\": \"1480244f-4a1c-40cf-8a93-40c9b70c8c10\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-Dec-16\": {\"uuid\": \"20127968-b96f-4039-a2c6-43a1688eb5df\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Dec-21\": {\"uuid\": \"1ddec20b-468a-4008-8459-1959f5a9e72f\", \"value\": \"02:00\", \"isLocked\": true}, \"Sun-Dec-22\": {\"uuid\": \"4263b2f9-e025-4bba-b38a-de1e696d72a1\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-19\": {\"uuid\": \"d46af4d5-21a4-48d7-9b0d-20372dcb0c9a\", \"value\": \"02:00\", \"isLocked\": true}, \"Tue-Dec-17\": {\"uuid\": \"a8efd409-b96e-4d70-a5b3-92b103a6b30b\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Dec-18\": {\"uuid\": \"5535621d-7fa4-49c9-9f63-159f8f3e0e37\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"6e9a3363-5f31-4754-9e6c-eed529af0390\", \"value\": \"Critical Req-work\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"d019f10c-6719-44f7-8729-d82c22029d57\", \"value\": \"11:00\", \"isLocked\": false}, \"Fri-Dec-20\": {\"uuid\": \"25204deb-2eaa-4464-81f2-9f931b141460\", \"value\": \"04:00\", \"isLocked\": true}, \"Mon-Dec-16\": {\"uuid\": \"b3da9ee4-dfe3-4905-8b11-db60b7814e27\", \"value\": \"01:00\", \"isLocked\": true}, \"Sat-Dec-21\": {\"uuid\": \"ca8aeab3-f19f-463d-8633-12ba6006aabf\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Dec-22\": {\"uuid\": \"2486507c-1bd0-4ad0-b63b-428983428374\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-19\": {\"uuid\": \"6c3849c3-fe3d-439c-972f-d8b18c074e9b\", \"value\": \"04:00\", \"isLocked\": true}, \"Tue-Dec-17\": {\"uuid\": \"9fec9e98-e529-4116-ad58-195a08528ea3\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Dec-18\": {\"uuid\": \"3e19e590-c250-45ed-be3c-f2a31eca21d3\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"90f4ee7d-dfd1-4f7b-82d7-96b6bd7169a7\", \"value\": \"Data mng\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"b1320da8-110f-4089-8d16-5019fb4bda94\", \"value\": \"19:00\", \"isLocked\": false}, \"Fri-Dec-20\": {\"uuid\": \"d2fec08f-d2b0-4dbc-ab6c-01c52f5c57cf\", \"value\": \"04:00\", \"isLocked\": true}, \"Mon-Dec-16\": {\"uuid\": \"ed97684a-a970-4f01-9262-802d3fed701f\", \"value\": \"03:00\", \"isLocked\": true}, \"Sat-Dec-21\": {\"uuid\": \"4665873c-d4d5-4575-b858-fa27a635f1c4\", \"value\": \"04:00\", \"isLocked\": true}, \"Sun-Dec-22\": {\"uuid\": \"e459e3d3-6e43-4b90-9b12-095bdda850f2\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-19\": {\"uuid\": \"fe82104d-8fe4-456f-a5b0-ef1681fd60b6\", \"value\": \"04:00\", \"isLocked\": true}, \"Tue-Dec-17\": {\"uuid\": \"b45f6404-d981-47d7-966e-862907b4f943\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Dec-18\": {\"uuid\": \"68d05b47-dfaa-4044-abcb-b920115240d7\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"5d53e9b5-9ae3-43b3-b5d1-c44a508591c7\", \"value\": \"Candidate sourcing\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"722e73a6-24fc-4fc9-80eb-56f993a721e6\", \"value\": \"21:00\", \"isLocked\": false}, \"Fri-Dec-20\": {\"uuid\": \"2289d8f7-d808-4511-b634-e8fb36e68dc4\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-Dec-16\": {\"uuid\": \"be127a72-7a36-4fa1-8b38-18d0ad49ce76\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-Dec-21\": {\"uuid\": \"0936ee19-ddb1-41e9-b1d2-c3167c6e5eda\", \"value\": \"08:00\", \"isLocked\": true}, \"Sun-Dec-22\": {\"uuid\": \"f4c57d26-c19e-4db0-a39e-5f4d94d19dfb\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Dec-19\": {\"uuid\": \"3719682d-f962-4615-bdeb-5b2fdfe48b9e\", \"value\": \"04:00\", \"isLocked\": true}, \"Tue-Dec-17\": {\"uuid\": \"a7eec304-fc9f-4a18-ab93-0fabdf428a28\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Dec-18\": {\"uuid\": \"112c60ea-ef56-40cc-97ca-384d9053fcdc\", \"value\": \"03:00\", \"isLocked\": true}}]',
    78.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-12-23 12:38:10',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    NULL,
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'fc96332c-7be9-4f73-8aeb-5647b0362fdd',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    230778,
    '2024-04-29',
    '2024-05-05',
    '[{\"task\": {\"uuid\": \"66f05c93-2c21-4993-9276-f4854152693b\", \"value\": \"Created Embedded Resource Batch\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"819f4aeb-4a65-4249-b028-8bae4a3f7a69\", \"value\": \"12:00\", \"isLocked\": false}, \"Fri-May-03\": {\"uuid\": \"d6f7e284-47df-4ef2-8a93-30e76c5bc678\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-Apr-29\": {\"uuid\": \"9aaeda56-5c47-4fc3-a1db-c239acaa4e71\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-May-04\": {\"uuid\": \"e5f9c6e3-cae2-4dc2-9ec8-2ed66ed30c4f\", \"value\": \"02:00\", \"isLocked\": true}, \"Sun-May-05\": {\"uuid\": \"6a839811-0ee5-460e-9844-cbe909f3a370\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-02\": {\"uuid\": \"55caaec0-9db3-4bdb-b103-0907bd28c0df\", \"value\": \"02:00\", \"isLocked\": true}, \"Tue-Apr-30\": {\"uuid\": \"7c6e5ce8-0e2a-49f6-9f46-6d2cca1166ea\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-May-01\": {\"uuid\": \"0a3064dc-a05d-4cb0-8a23-318d421aa5ae\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"1f8a954b-e738-4fe2-8933-5b0c73f4ee3a\", \"value\": \"Build task and resource for Website -Punit \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"e559d664-e93b-4f9a-af80-5edeb95d3b0d\", \"value\": \"11:00\", \"isLocked\": false}, \"Fri-May-03\": {\"uuid\": \"16589962-053a-472a-ade4-f2cf9fbdd5eb\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-Apr-29\": {\"uuid\": \"eaaa7fd6-050f-47f2-86de-877d6c78083e\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-May-04\": {\"uuid\": \"79b67535-d566-47b7-90b4-f8f166c08867\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-05\": {\"uuid\": \"05b16598-a945-4753-ab93-bc66ac91d7bb\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-02\": {\"uuid\": \"1434b26a-d13d-414a-aabd-7c50a4655f2d\", \"value\": \"02:00\", \"isLocked\": true}, \"Tue-Apr-30\": {\"uuid\": \"7ac08a3f-3fd2-48d6-b281-6034ce5f1716\", \"value\": \"03:00\", \"isLocked\": true}, \"Wed-May-01\": {\"uuid\": \"89cb8e5c-d637-438c-8f74-9a4fd8e45e65\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"cef0431c-3b4f-4e84-88cd-5c10d7ea1890\", \"value\": \"Core HR responsibilities \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"141e516d-3b54-42ce-a04f-75dfd07c2f8a\", \"value\": \"12:00\", \"isLocked\": false}, \"Fri-May-03\": {\"uuid\": \"5f73f939-53b4-4efc-a67e-b3cb3e76a7fd\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-Apr-29\": {\"uuid\": \"17f6d331-eeb2-4fc2-9ea5-3d9e161d3f5e\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-May-04\": {\"uuid\": \"9ae587a6-3758-4b9d-aa7c-88e5da9c1813\", \"value\": \"02:00\", \"isLocked\": true}, \"Sun-May-05\": {\"uuid\": \"6edf35c8-3a55-485c-a299-65d69a43ba7e\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-02\": {\"uuid\": \"1d8baff0-65dd-48b9-820c-8698508451f5\", \"value\": \"02:00\", \"isLocked\": true}, \"Tue-Apr-30\": {\"uuid\": \"cb248d58-842b-460c-8582-98d402dd41a6\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-May-01\": {\"uuid\": \"c35fa452-3f45-4f09-ac62-0b1c6c3df898\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"a9d4010f-b0d8-4a13-a5b3-34b553a6550e\", \"value\": \"Employee grievances\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"dd1bbfef-dc72-4458-ab06-9e4acbd63890\", \"value\": \"04:00\", \"isLocked\": false}, \"Fri-May-03\": {\"uuid\": \"2d10540d-904e-4e98-aec6-94a21fdee88a\", \"value\": \"01:00\", \"isLocked\": true}, \"Mon-Apr-29\": {\"uuid\": \"dd85abf7-0375-4ff5-86b4-1c3fb61a6e84\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-04\": {\"uuid\": \"4745c5bb-2684-47d9-b29b-c67f761ba0b5\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-05\": {\"uuid\": \"0f5d7d53-a5a3-4bbd-aa6f-3d75fc697665\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-02\": {\"uuid\": \"49faa3b2-0ade-4852-9003-7b8b94b92918\", \"value\": \"01:00\", \"isLocked\": true}, \"Tue-Apr-30\": {\"uuid\": \"f23912cc-13d9-48df-bdcc-0ab81fe5d491\", \"value\": \"01:00\", \"isLocked\": true}, \"Wed-May-01\": {\"uuid\": \"5530768b-e596-4731-ac85-2cbb07ef5797\", \"value\": \"01:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"882f8924-351a-4599-bc14-47dadd4f32bc\", \"value\": \"Embedded Recruitments and Interviews\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"1bad2264-5f97-41ff-b9f0-d2c591287062\", \"value\": \"12:00\", \"isLocked\": false}, \"Fri-May-03\": {\"uuid\": \"99cb7bde-41cb-42bd-875e-e176a8e48f0d\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-Apr-29\": {\"uuid\": \"f39b0466-a153-4ae9-8b84-5f2f70f15348\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-May-04\": {\"uuid\": \"72cb201b-8328-4082-8236-3b7381827c26\", \"value\": \"02:00\", \"isLocked\": true}, \"Sun-May-05\": {\"uuid\": \"364302db-d214-4dfc-ada0-8471b2d22ca1\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-02\": {\"uuid\": \"819a5ba8-340e-4f9a-b153-d5dd0cac3f89\", \"value\": \"02:00\", \"isLocked\": true}, \"Tue-Apr-30\": {\"uuid\": \"3ba4ed0b-9cdd-4e29-b52a-99f8b1fb1433\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-May-01\": {\"uuid\": \"b1dffac3-0544-41f7-aab3-29bb69958173\", \"value\": \"02:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"51db97f3-7b3e-432a-b457-9a5a3b7ef7d0\", \"value\": \"Documentations\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"e15d102f-0c9c-4907-bb56-c4ba487a2ff0\", \"value\": \"04:00\", \"isLocked\": false}, \"Fri-May-03\": {\"uuid\": \"f7e9efaf-59d2-4955-9600-b01624ede78e\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-29\": {\"uuid\": \"51a53583-686f-43c6-9ce2-838197fc0b18\", \"value\": \"02:00\", \"isLocked\": true}, \"Sat-May-04\": {\"uuid\": \"68f0d649-772b-408a-b9c8-ff1b4e836a4b\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-05\": {\"uuid\": \"7cd7223d-3b15-4404-ac9b-854b51601830\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-02\": {\"uuid\": \"1a7fc99c-cc51-4c39-bbb6-5e0830655181\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-30\": {\"uuid\": \"e5439b68-25e6-464f-93e5-26724e41368d\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-May-01\": {\"uuid\": \"a3d6ce45-2aa8-4862-ace7-c2d7f32982f1\", \"value\": \"00:00\", \"isLocked\": true}}]',
    55.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-05-07 13:11:34',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    NULL,
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: employees
# ------------------------------------------------------------

INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '0612778c-0d59-4879-b108-617d5c51501f',
    'Ajay Jagannath Patil',
    'Male',
    '1994-07-11',
    '9823749292',
    'ajaypatil1107@gmail.com',
    'B+',
    'Married',
    'A/P:-KavathePiran, Tal:-Miraj, Dist:- Sangli,pincode-416416',
    'A/P:-KavathePiran, Tal:-Miraj, Dist:- Sangli,pincode-416416',
    'Father',
    '9850862165',
    'Other',
    '9960706800',
    'ES011',
    'ajay@embedsquare.com',
    '2020-04-21',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Software Engineer',
    '91df356db9b83acbfa959c3a8fc4cf6e:ad646a91ab6573720adc29cada2259c4',
    '6368d9086b7c55ea627f90d2f19cf492:c84163af7d35571d51aca860e86e6ec0',
    'BKID0001609',
    '6d6306c0235fe4c4b1283987d06b7f92:fced90a52dbd3091ea6b66c84c4dfbdd',
    '',
    '',
    NULL,
    'Bachelor degree',
    '4',
    '',
    'Engineering',
    NULL,
    '2024-01-11 13:22:51',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2024-01-19 05:08:40',
    '0612778c-0d59-4879-b108-617d5c51501f',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '1dd6938b-e12f-4496-bbfe-c3e6dc3da4ec',
    'Amol Rajendra Rokade',
    'Male',
    '1992-10-21',
    '9518501427',
    'amolrokade121@gmail.com',
    '',
    'Married',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES027',
    'amol@embedsquare.com',
    '2023-02-15',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    NULL,
    '',
    'PHP Developer-Laravel Specialist',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    NULL,
    NULL,
    '',
    'Engineering',
    NULL,
    '2024-01-11 13:07:07',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2024-01-12 06:25:28',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '4af60173-f56f-44fe-a534-25d3a21967df',
    'Poonam Satish Sonawane',
    'Female',
    '1990-08-23',
    '8484088852',
    'poonamsonawane97@yahoo.com',
    'B+',
    'Married',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES042',
    'poonam@embedsquare.com',
    '2025-07-09',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Hr Executive',
    '28b12212d2c22ed9951903126d21c8f7:f9208300f97f9f064c9b018478e144a0',
    '761ada3759025e00b295e2b201eb29d6:276c82f12605c4869a878f9b5feeac3a',
    '',
    'eb67822283a925d680b58045f80de453:f41ae7758793dc8538cf828fc95ca965',
    '6d0e014bafbd505509fbc5af1ea447b0:a72f712d6e06a0ce121410b302ccce9e',
    '',
    NULL,
    NULL,
    NULL,
    NULL,
    'Human Resource',
    NULL,
    '2025-07-14 12:00:14',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    NULL,
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '4dc70b3d-7d22-4d22-ba1e-35be17624c26',
    'Somnath Maheshinkar Rajure',
    'Male',
    '1988-04-23',
    '8600757311',
    'sachin.rajure@gmail.com',
    'AB+',
    'Married',
    'Gandhi chowk, Main road Ausa. Tal,Ausa Dist.Latur',
    'Keshav Nagar,Mataram nagar,near vithal rukmini mandir,Latur Pincode: 413512',
    'Brother',
    '9766111129',
    'Other',
    '8862026393',
    'ES037',
    'sachin@embedsquare.com',
    '2025-04-21',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Operations Executive',
    'ceb480e3c0a2dd2954a23eb70ffc0206:43b81f4a210976707d89e4d709719517',
    '3d6d059890dc05d40d068d7b1ecf39e9:c3b50a7025211d17d1ead9c7ca6368cb',
    'MAHB0000038',
    '56160b6e503a9d4eec62c09ebd9d4915:c6cbcbfbaf886de88f6f41cb9fa4a0b8',
    '9250d747e2d072b97c44e639d8064c47:8b53b49a64fade8af4ae29939c5a644a',
    '',
    NULL,
    'Bachelor degree',
    '13',
    NULL,
    'Finance',
    NULL,
    '2025-04-22 07:26:55',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2025-04-22 08:30:27',
    '4dc70b3d-7d22-4d22-ba1e-35be17624c26',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '4e19b7df-eca2-42a5-85ef-c2e5b0766e08',
    'Shashank S Reddy',
    'Male',
    '1997-11-14',
    '8050055501',
    'shashanksanjeevreddy@gmail.com',
    'O+',
    'UnMarried',
    'Plot number 276/277, Siddha Dhama, Mahaveer Nagar, near Kothari Bhavan, New Jewargi road, Kalaburagi, Karnataka - 585102',
    'E3/17, Girija Shankar Vihar, Gate number 1, opp Bhagirathi Children\'s hospital, Karve Nagar, Kothrud, Pune, Maharashtra 411052',
    'Sister',
    '8618384559',
    'Other',
    '9588653343',
    'ES038',
    'sreddy@embedsquare.com',
    '2025-04-01',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Software Engineer',
    '49145f3b5d75f38854e4700e4f294a1b:ca03a3a181209b456495743110230956',
    'fc335c3319bf912b38917fddde4d0b91:e5ffc9b67ff35d204111b08d17bb6fff',
    '',
    '71f206b9a12559be8be3912f068c5052:7de8cdc36cedd8955b907968173c1d6e',
    'bbe592620b9527ae8cf85cc71fd49d31:8daf572974dadd0cc9992eb8e9db3049',
    '',
    NULL,
    'Master degree',
    '2',
    NULL,
    'Engineering',
    NULL,
    '2025-05-20 09:16:50',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    NULL,
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '53bf67f4-5a40-450f-b160-e1e60f3c27c6',
    'Avinash Biradar',
    'Male',
    '1994-03-01',
    '9545998599',
    'biradaravi2109@gmail.com',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES003',
    'avinash@embedsquare.com',
    '2019-05-06',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Software Engineer',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    NULL,
    NULL,
    NULL,
    'Engineering',
    NULL,
    '2024-01-24 04:30:16',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2024-03-26 06:42:35',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '5bebf1b8-f149-62js-87h3-52540245096b',
    'Uday Dhadve',
    'Male',
    '1986-04-03',
    '+91 2345678901',
    'uday.worx@gmail.com',
    'B+',
    'Married',
    '123 Main St\n123 Main St\n123 Main St',
    '456 Temp St\n123 Main St\n123 Main St',
    '',
    '',
    '',
    '',
    '0000001',
    'uday@embeds2.com',
    '2023-01-15',
    'System Manager',
    'System Manager',
    '50000',
    'Software Engineer',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    'Bachelors in Computer Science',
    '',
    '',
    'Engineering',
    '',
    '2023-12-28 07:12:54',
    'system',
    '2024-01-15 23:05:13',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'Soni Singh',
    'Female',
    '1987-01-09',
    '+919561624129',
    'embedsquarehrd@gmail.com',
    'AB+',
    'Married',
    'Bunglow CD: W-9, \"Sanjukta\"\nC/O Mr. Y K Singh\nIFS \nRanchi',
    'A-106, Siddhi Nisarg, Pune',
    '',
    '',
    '',
    '',
    'ES0001',
    'hr@embedsquare.com',
    '2019-01-13',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Hr Executive',
    'af27dab322e08d6c14dca9e01cd4e731:7a52a346c86288e5caaf6f7b2c9a5916',
    '',
    '',
    '',
    '',
    '',
    NULL,
    'Doctorate or higher',
    '15',
    '',
    'Human Resource',
    NULL,
    '2023-12-30 05:24:14',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2024-12-31 07:43:25',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '9ea4e035-85e0-4e79-85dd-d7af24508391',
    'Shashank B Prajapati',
    'Male',
    '1999-05-11',
    '+919727387043',
    'shashank.spsp14@gmail.com',
    'O+',
    'UnMarried',
    'A-501 Shubhlaxmi Avenue Opp. Bhagwati Farm, Nr. Apollo International School, Tragad Road Chandkheda. Ahmedabad-382470',
    'A-501 Shubhlaxmi Avenue Opp. Bhagwati Farm, Nr. Apollo International School, Tragad Road Chandkheda. Ahmedabad-382470',
    'Other',
    '+91 9727387043',
    'Other',
    '+91 9727387043',
    'ES009',
    'shashank@embedsquare.com',
    '2020-02-12',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Software Engineer',
    '7c7a6139026cf033d7f482878829c1cd:7aa50a0bb616b079d6821d2bc7034105',
    '4fc2f7ca3bdee55f056247caf6a5230d:74b35c80131de707def389cc0a535be4',
    'PUNB0092210',
    'b4929ba89f9af079ff325d44d968bfcd:9f2c5c9682ead2e1073cd815004eecf5',
    '',
    '',
    NULL,
    'Bachelor degree',
    '6',
    NULL,
    'Engineering',
    NULL,
    '2025-02-25 11:45:21',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2025-03-02 14:12:44',
    '9ea4e035-85e0-4e79-85dd-d7af24508391',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '9f0d278b-a2fa-4ac7-803a-fde96534c4ff',
    'Rohit Kakasaheb Jadhav',
    'Male',
    '1993-12-04',
    '',
    'rohitjadhav.dec2@gmail.com',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES041',
    'rohit@embedsquare.com',
    '2025-06-30',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Other',
    '9aa8052ee9998bbce3dbf7cd29461b18:a2a35bc0ef20b05871c84fe043e4a971',
    'b1b2495a7b89801f4395709d5899f38f:d5c33cf05b84d2f9325972981a916eac',
    '',
    '8ee94add502918771ef61e7a9d02ea88:1a141fbf0a33b91adbc7e46528d496d4',
    '997f0c01f06a2700cef23748f03f903b:76006485c362bfe71fe5d4338f66f1ff',
    '',
    NULL,
    NULL,
    NULL,
    NULL,
    'Engineering',
    NULL,
    '2025-07-16 05:29:15',
    '4af60173-f56f-44fe-a534-25d3a21967df',
    NULL,
    '4af60173-f56f-44fe-a534-25d3a21967df',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'ac236a3b-3093-4921-b876-d1b23873df93',
    'Krushna D Chaudhari',
    'Male',
    '1999-01-29',
    '+918623060863',
    'kdchaudhari755@gmail.com',
    'O-',
    'UnMarried',
    '',
    '',
    'Father',
    '8830496720',
    '',
    '',
    'ES035',
    'krishna@embedsquare.com',
    '2024-12-02',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    NULL,
    '',
    'Software Engineer',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    'Master degree',
    '2',
    NULL,
    'Engineering',
    NULL,
    '2025-03-26 10:01:14',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2025-04-22 07:12:21',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'b7b859f3-e78b-43a6-9752-457104c52024',
    'Neha Parmar',
    'Female',
    '1998-05-27',
    '',
    'nehakparmar27@gmail.com',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES026',
    'nehap@embedsquare.com',
    '2023-01-06',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Software Engineer',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    NULL,
    NULL,
    NULL,
    'Engineering',
    NULL,
    '2024-01-24 04:09:54',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2024-03-26 06:43:09',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'Chetan Bidap',
    'Male',
    '1987-01-01',
    '9898989891',
    'cbidap@gmail.com',
    '0',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '0000001',
    'cbidap@embedsquare.com',
    '2020-12-01',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    NULL,
    '',
    'Director',
    '',
    '',
    '',
    NULL,
    '',
    '',
    NULL,
    NULL,
    NULL,
    '',
    'Engineering',
    NULL,
    '2023-12-28 17:57:33',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    NULL,
    '5bebf1b8-f149-62js-87h3-52540245096b',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'e41707fe-ce8f-4156-8ce1-a2d5c8c10070',
    'Alex',
    'Male',
    '1985-01-10',
    '9004085106',
    'alex@gmail.com',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES0091',
    'alex@embedsquare.com',
    '2019-09-11',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    NULL,
    '',
    'Consultant',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    NULL,
    NULL,
    '',
    'Engineering',
    NULL,
    '2024-01-10 07:04:05',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2024-01-18 05:10:11',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'eca7545f-2c1d-4170-836e-5f863a05db2e',
    'Surya Bhushan Prasad Manjhi',
    'Male',
    '1999-03-04',
    '8651989809',
    'manjhi.suryaa@gmail.com',
    'O+',
    'UnMarried',
    '',
    '',
    'Mother',
    '7464001500',
    '',
    '',
    'ES035',
    'surya@embedsquare.com',
    '2024-06-21',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Software Engineer',
    'aad9eaeb66ae143244100ab9e66b63cb:c7b15dc5acfa379688d921313cc6c81a',
    '363c7e8e4866b03332d14c0e8cae33df:b9dbed33f00837af76a2e9ea72ed49dd',
    '',
    'd9310b9f8ec5ad5bc3d8a268ea49d786:6990d5b3932bc2cab05d85ad08b16f39',
    '9c12c8e9b8f168e7ecad5c6837158b92:38d290443e2a009934685b89f229bebb',
    '',
    NULL,
    'Bachelor degree',
    'more than 6 months',
    NULL,
    'Engineering',
    NULL,
    '2024-12-12 11:21:19',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    NULL,
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'f51968aa-f969-47cf-a0ee-51d4f8e1fb6f',
    'Rushikesh Palande',
    'Male',
    '2001-02-07',
    '8459972812',
    'rishikesh.palande07@gmail.com',
    'B+',
    'UnMarried',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES040',
    'rushikesh@embedsquare.com',
    '2025-01-20',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Software Engineer',
    '892ac377c03d798c73c7527a6cc2cd1c:17afc0351015db9a3f873f42b787303e',
    '037b8ada4ca442feba6f25e8fef2c932:b62dfea967621c5a8c8938f08e11efce',
    '',
    'e818db27e3e504d55958a2c076515531:34c038d8189a54f234d1f44f568de9a4',
    'ae5768dec0f42eb794e96f21eb2e7beb:689b069568cf9413b412efda2960a8da',
    '',
    NULL,
    'Master degree',
    '1',
    NULL,
    'Engineering',
    NULL,
    '2025-06-25 11:52:28',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    NULL,
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'f598a09a-6a20-4e8b-9fc6-1167a48a1270',
    'Atul Joshi',
    'Male',
    '1990-07-17',
    '',
    'uniqatul3@gmail.com',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES020',
    'atul@embedsquare.com',
    '2021-10-25',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Senior Software Engineer',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    NULL,
    NULL,
    NULL,
    'Engineering',
    NULL,
    '2024-01-24 04:23:02',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2024-03-26 06:47:44',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'ffd826ce-5585-4a76-9b57-6821a68619e3',
    'Nitin Kumar Upadhyay',
    'Male',
    '1995-07-24',
    '',
    'upadhyay.nitin.247@gmail.com',
    'O+',
    'UnMarried',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES031',
    'nitin@embedsquare.com',
    '2024-01-15',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    NULL,
    '',
    'Software Engineer',
    '4704429df541a50414384355d0b03b1f:dc6ebfb1b5a1c5a18840e495422e9831',
    '1afcedb0ee08e9b6e230742ccd91c98a:d31e0cd7bba4b172b3ac0a0f46fa6310',
    '',
    '5521bf2045dfa30656cfbb983fc0b4bb:50a2727499061dc8d22041c878af23dc',
    'b661a7a613fc37c8f9458904fcead1e5:49cdce2214167c279173b12f61487ef6',
    '',
    NULL,
    NULL,
    NULL,
    '',
    'Engineering',
    NULL,
    '2024-01-15 11:12:32',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    NULL,
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: migrations
# ------------------------------------------------------------

INSERT INTO
  `migrations` (`name`)
VALUES
  ('00001-create-employees-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00002-create-user-tables.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00003-insert-initial-employee.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00004-insert-initial-user.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00005-create-leave-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00006-create-employee-documents.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00007-create-employee-timesheet.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00008-create-employee-leave-allocation.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00009-create-employee-activity-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00010-create-weekly-timesheet-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00011-create-employee-online-status.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00012-create-user-password-reset-request-.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00013-schedule-event-reset-req-expire.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00014-create-holiday-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00015-create-customer-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00016-create-project-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00017-insert-initial-project.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  (
    '00018-create-customer-resource-allocation-table.js'
  );
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00019-create-customer-access-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00020-create-employee-preference-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00021-create-master-data.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00022-insert-initial-fields.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00023-create-survey-config-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00024-create-survey-results-table.js');

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: migrations_lock
# ------------------------------------------------------------

INSERT INTO
  `migrations_lock` (`is_locked`)
VALUES
  (0);

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: org_holidays
# ------------------------------------------------------------

INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '0a4b003b-2bff-45c6-b076-afdc35a34189',
    'Maharashtra Day',
    '2025-05-01 00:00:00',
    2025,
    'IN',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 10:02:22'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '0be20aaa-5506-49c9-848e-4454137e0175',
    'Ganesh Chaturthi',
    '2025-08-27 00:00:00',
    2025,
    'IN',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 10:02:22'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '174f2d9c-2feb-419f-a205-f2b1276d8013',
    'Holi',
    '2025-03-14 00:00:00',
    2025,
    'IN',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 10:02:22'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '1b29b052-b723-4179-bf5b-62fbf2a6ad3b',
    'Mahatma Gandhi Jayanti/ Dussehra',
    '2025-10-02 00:00:00',
    2025,
    'IN',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 10:02:22'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '30a92951-c203-4548-86f5-524123309d8a',
    'Independence Day',
    '2025-08-15 00:00:00',
    2025,
    'IN',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 10:02:22'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '567846ab-474a-4c62-90b1-628feaaf3635',
    'Good Friday',
    '2025-04-18 00:00:00',
    2025,
    'IN',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 10:02:22'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '606aac40-9d0a-4e1b-ba15-aa9bc517f0f6',
    'New Year Day',
    '2024-01-01 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '647416a2-363e-4960-88ec-d89ae16b9590',
    'Rama Navami',
    '2024-04-17 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '6e2dacea-96ab-4881-ab30-f32a42c6c8ff',
    'Diwali',
    '2024-11-01 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '7d11d932-653a-429b-8f07-502a88481eba',
    'Republic Day',
    '2024-01-26 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '8235e09a-f282-490b-bfef-adc13bbe9f6e',
    'Maharashtra day / Labour Day',
    '2024-05-01 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '8921584e-a3ea-4515-8eee-d46551ffb1d4',
    'Guru Nanak Jayanti',
    '2024-11-15 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '8f71cef2-7a2a-4d1f-9ea2-849ab38c6b99',
    'Gudi Padwa',
    '2024-04-09 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '921a0619-f614-4ab6-901a-315bd24cb397',
    'Independence Day',
    '2024-08-15 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '94b124f3-35d6-4ac8-8723-75ac6e6cba54',
    'Navratri',
    '2024-10-11 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    'b3441f9f-25ba-4294-9082-94abd3360fd2',
    'New Year\'s Day',
    '2025-01-01 00:00:00',
    2025,
    'IN',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 10:02:22'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    'bc386fbe-d157-45f1-b6a6-690807b9efaf',
    'Gandhi Jayanti',
    '2024-10-02 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    'c55158be-748d-4686-a911-cd20f56dccfe',
    'Christmas',
    '2024-12-25 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    'c9e8c476-9df2-4416-92dd-d7633d9dc7e7',
    'Holi',
    '2024-03-25 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    'fdc59e46-d62a-41af-9695-c9fdf4a08f6c',
    'Maha Shivratri',
    '2025-02-26 00:00:00',
    2025,
    'IN',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 10:02:22'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: project_resource_allocation
# ------------------------------------------------------------

INSERT INTO
  `project_resource_allocation` (
    `uuid`,
    `allocationCode`,
    `projectId`,
    `customerId`,
    `employeeId`,
    `startDate`,
    `endDate`,
    `role`,
    `customerApprover`,
    `status`,
    `createdBy`,
    `createdAt`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    '291e5628-b121-494d-97f3-9c439dccfa9a',
    'BXBI7A0',
    'X101',
    '7fa1942e-b6f7-4e91-9f18-6003990961ac',
    '53bf67f4-5a40-450f-b160-e1e60f3c27c6',
    '2024-01-01',
    '2024-04-30',
    'Software Engineer',
    1,
    'ACTIVE',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2024-01-25 00:42:15',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2024-01-25 00:42:15'
  );
INSERT INTO
  `project_resource_allocation` (
    `uuid`,
    `allocationCode`,
    `projectId`,
    `customerId`,
    `employeeId`,
    `startDate`,
    `endDate`,
    `role`,
    `customerApprover`,
    `status`,
    `createdBy`,
    `createdAt`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    '53d6ca18-ee67-4f97-bc45-e7bb1ca2bd6a',
    'ZYWRILQ',
    'X101',
    'd5854934-a0ec-4997-ab4b-52a6cbca19fa',
    '1dd6938b-e12f-4496-bbfe-c3e6dc3da4ec',
    '2024-01-01',
    '2024-07-31',
    'PHP Developer-Laravel Specialist',
    1,
    'ACTIVE',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2024-01-31 07:36:43',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 12:32:18'
  );
INSERT INTO
  `project_resource_allocation` (
    `uuid`,
    `allocationCode`,
    `projectId`,
    `customerId`,
    `employeeId`,
    `startDate`,
    `endDate`,
    `role`,
    `customerApprover`,
    `status`,
    `createdBy`,
    `createdAt`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    '5b91456b-35e2-4600-9a10-9de112b03a36',
    'WNMB5G6',
    'X101',
    'af90f00e-c148-4edc-ba09-72781244d87f',
    '9ea4e035-85e0-4e79-85dd-d7af24508391',
    '2025-02-24',
    '2027-02-02',
    'Software Engineer',
    0,
    'ACTIVE',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 12:13:51',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 12:13:51'
  );
INSERT INTO
  `project_resource_allocation` (
    `uuid`,
    `allocationCode`,
    `projectId`,
    `customerId`,
    `employeeId`,
    `startDate`,
    `endDate`,
    `role`,
    `customerApprover`,
    `status`,
    `createdBy`,
    `createdAt`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    'ad018b88-9dfd-47aa-a289-c47addb14e59',
    'EGXXTK4',
    'X101',
    'af90f00e-c148-4edc-ba09-72781244d87f',
    '53bf67f4-5a40-450f-b160-e1e60f3c27c6',
    '2025-02-24',
    '2027-02-01',
    'Software Engineer',
    1,
    'ACTIVE',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 10:53:49',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 10:53:49'
  );
INSERT INTO
  `project_resource_allocation` (
    `uuid`,
    `allocationCode`,
    `projectId`,
    `customerId`,
    `employeeId`,
    `startDate`,
    `endDate`,
    `role`,
    `customerApprover`,
    `status`,
    `createdBy`,
    `createdAt`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    'cdae39f4-8faf-43f1-baf7-6eae884378a2',
    'B01YF4D',
    'X101',
    'd82ff270-9b0a-4316-b850-a7a926d9075c',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    '2024-01-05',
    '2024-07-31',
    'Software Engineer',
    1,
    'ACTIVE',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2024-01-24 09:51:33',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2024-01-24 09:51:33'
  );
INSERT INTO
  `project_resource_allocation` (
    `uuid`,
    `allocationCode`,
    `projectId`,
    `customerId`,
    `employeeId`,
    `startDate`,
    `endDate`,
    `role`,
    `customerApprover`,
    `status`,
    `createdBy`,
    `createdAt`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    'ffa1264a-eec5-4b21-9a2a-6fa6a6b57cbc',
    'Y7IE11T',
    'X101',
    'd5854934-a0ec-4997-ab4b-52a6cbca19fa',
    'f598a09a-6a20-4e8b-9fc6-1167a48a1270',
    '2024-01-01',
    '2024-07-01',
    'Senior Software Engineer',
    1,
    'ACTIVE',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2024-01-31 07:36:04',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 12:32:03'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: projects
# ------------------------------------------------------------

INSERT INTO
  `projects` (
    `uuid`,
    `name`,
    `domain`,
    `description`,
    `location`,
    `status`,
    `projectCode`,
    `labels`,
    `customerId`,
    `priority`,
    `category`,
    `createdAt`,
    `startDate`,
    `endDate`,
    `createdBy`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    'X101',
    'Default System Project',
    'Default Domain',
    'This is a system-generated project for initial setup.',
    'Default Location',
    'INITIATED',
    '',
    '',
    '',
    'NORMAL',
    '',
    '2023-12-28 07:12:54',
    NULL,
    NULL,
    'system_user_id',
    'system_user_id',
    NULL
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: survey_config
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: user_password_reset_request
# ------------------------------------------------------------


