UPDATE  cw_modules SET module_name = "Project Manager Performance Report",module_type = "DYNAMIC",menu_id = "10",sub_menu_id = "26",module_for = "1,2,3,4,5",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2022-11-24 01:21:35" where module_id = "pm_performance_report";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("73","salary_cost_comparison","Salary Cost Comparison","DYNAMIC","10","29","1,2,3,4,5,8,9,10,11","1,2","1","","","","","1","2022-12-27 01:18:51");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("salary_cost_comparison","salary_cost_comparison");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("salary_cost_comparison","1","1","1","1","1","1","1");
UPDATE  cw_main_menu SET menu_name = "Detailing",menu_for = "1,2,3,4,5",trans_updated_by = "1",trans_updated_date = "2024-07-02 06:21:03" where prime_menu_id = "4";
INSERT INTO cw_main_menu (menu_name, menu_for, menu_sort, trans_created_by, trans_created_date) VALUES ("estimation","1,2,3,4,5,8,9,10,11","8","1","2024-07-02 06:21:28");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("75","project_list","Project List","DYNAMIC","14","","1,2,3,4,5,8,9,10,11","1,2","1","","","","","1","2024-07-02 06:22:21");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("project_list","project_list");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("project_list","1","1","1","1","1","1","1");
UPDATE  cw_main_menu SET menu_sort = "1",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "5";
UPDATE  cw_main_menu SET menu_sort = "2",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "4";
UPDATE  cw_main_menu SET menu_sort = "3",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "14";
UPDATE  cw_main_menu SET menu_sort = "4",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "13";
UPDATE  cw_main_menu SET menu_sort = "5",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "10";
UPDATE  cw_main_menu SET menu_sort = "6",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "12";
UPDATE  cw_main_menu SET menu_sort = "7",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "2";
UPDATE  cw_main_menu SET menu_sort = "8",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "1";
UPDATE  cw_main_menu SET menu_name = "Estimation",menu_for = "1,2,3,4,5,8,9,10,11",trans_updated_by = "1",trans_updated_date = "2024-07-02 06:23:12" where prime_menu_id = "14";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("76","state","State","DYNAMIC","14","","1,2,3,4,5,8,9,10,11","1,2","1","","","","","1","2024-07-05 10:47:19");
UPDATE  cw_modules SET module_name = "",module_type = "",menu_id = "",sub_menu_id = "",module_for = "",show_module = "",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "",trans_updated_by = "1",trans_updated_date = "2024-07-05 10:48:59" where module_id = "";
UPDATE  cw_modules SET module_name = "State",module_type = "DYNAMIC",menu_id = "5",sub_menu_id = "5",module_for = "1,2,3,4,5,8,9,10,11",show_module = "",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-05 10:52:44" where module_id = "state";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("77","state_list","State List","DYNAMIC","14","","1,2,3,4,5,8,9,10,11","1,2","1","","","","","1","2024-07-05 10:53:23");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("state_list","state_list");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("state_list","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "State List",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "",module_for = "1,2,3,4,5,8,9,10,11",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-05 10:55:03" where module_id = "state_list";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("78","city_list","City List","DYNAMIC","14","","1,2,3,4,5,8,9,10,11","1,2","1","","1","","","1","2024-07-05 10:57:44");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("city_list","city_list");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("city_list","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "Category",module_type = "DEV",menu_id = "5",sub_menu_id = "2",module_for = "1,2,3,4,5",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1",trans_updated_by = "1",trans_updated_date = "2024-07-05 11:04:53" where module_id = "category";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("79","market_category","Market Category","DYNAMIC","14","","1,2,3,4,5,8,9,10,11,12,13","1,2","1","","1","","","1","2024-07-05 11:51:08");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("market_category","market_category");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("market_category","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("80","team_list","Team List","DYNAMIC","14","","1,2,3,4,5,8,9,10,11,12,13","1,2","1","","1","","","1","2024-07-05 11:59:15");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("team_list","team_list");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("team_list","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "Project List",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "",module_for = "1,2,3,4,5,8,9,10,11",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-05 04:48:43" where module_id = "project_list";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("81","job_type","Job Type","DYNAMIC","14","","1,2,3,4,5,8,9,10,11,12,13","1,2","1","","1","","","1","2024-07-05 06:47:07");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("job_type","job_type");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("job_type","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("82","est_team_target","Est Team Target","DYNAMIC","14","","1,2,3,4,5,8,9,10,11,12,13","1,2","1","","1","","","1","2024-07-06 01:00:10");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_team_target","est_team_target");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_team_target","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("83","est_time_sheet","Est Time Sheet","DYNAMIC","14","","1,2,3,4,5,8,9,10,11,12,13","1,2","1","","","","","1","2024-07-08 03:50:16");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_time_sheet","est_time_sheet");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_time_sheet","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("84","est_work_type","Est Work Type","DYNAMIC","14","","1,2,3,4,5,8,9,10,11,12,13","1,2","1","","1","","","1","2024-07-08 04:04:02");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_work_type","est_work_type");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_work_type","1","1","1","1","1","1","1");
INSERT INTO cw_sub_menu (map_main_menu, sub_menu_name, sub_menu_sort, trans_created_by, trans_created_date) VALUES ("14","Masters","16","1","2024-07-08 04:13:51");
UPDATE  cw_modules SET module_name = "Est Work Type",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-08 04:14:40" where module_id = "est_work_type";
UPDATE  cw_modules SET module_name = "Est Team Target",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-08 04:14:46" where module_id = "est_team_target";
UPDATE  cw_modules SET module_name = "State List",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-08 04:15:12" where module_id = "state_list";
UPDATE  cw_modules SET module_name = "City List",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-08 04:15:21" where module_id = "city_list";
UPDATE  cw_modules SET module_name = "Market Category",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-08 04:15:40" where module_id = "market_category";
UPDATE  cw_modules SET module_name = "Job Type",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-08 04:15:58" where module_id = "job_type";
UPDATE  cw_modules SET module_name = "Team List",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-08 04:16:10" where module_id = "team_list";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-08 16:16:49" where module_id = "state_list";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-08 16:16:49" where module_id = "city_list";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-08 16:16:49" where module_id = "market_category";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-08 16:16:49" where module_id = "team_list";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-08 16:16:49" where module_id = "job_type";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-08 16:16:49" where module_id = "est_team_target";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-08 16:16:49" where module_id = "project_list";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-08 16:16:49" where module_id = "est_time_sheet";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-08 16:16:49" where module_id = "est_work_type";
UPDATE  cw_modules SET module_name = "Est Time Sheet",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-08 05:02:20" where module_id = "est_time_sheet";
UPDATE  cw_modules SET module_name = "Est Time Sheet",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-08 05:43:57" where module_id = "est_time_sheet";
UPDATE  cw_modules SET module_name = "Est Team Target",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:57:55" where module_id = "est_team_target";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:38" where module_id = "state_list";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:38" where module_id = "city_list";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:38" where module_id = "market_category";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:38" where module_id = "team_list";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:38" where module_id = "job_type";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:38" where module_id = "project_list";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:38" where module_id = "est_team_target";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:38" where module_id = "est_time_sheet";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:38" where module_id = "est_work_type";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:41" where module_id = "state_list";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:41" where module_id = "city_list";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:41" where module_id = "market_category";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:41" where module_id = "team_list";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:41" where module_id = "job_type";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:41" where module_id = "project_list";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:41" where module_id = "est_time_sheet";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:41" where module_id = "est_team_target";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-09 09:58:41" where module_id = "est_work_type";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("85","est_client_name","Est Client Name","DYNAMIC","14","30","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","1","","","1","2024-07-09 03:10:10");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_client_name","est_client_name");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_client_name","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "Job Type",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-09 04:05:21" where module_id = "job_type";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("86","was_list","Work Allocation Sheet","DYNAMIC","14","","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-09 04:16:09");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("was_list","was_list");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("was_list","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "Time Sheet",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-09 04:16:57" where module_id = "est_time_sheet";
UPDATE  cw_modules SET module_name = "Work Type",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-09 04:17:03" where module_id = "est_work_type";
UPDATE  cw_modules SET module_name = "Client Name",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-09 04:17:09" where module_id = "est_client_name";
UPDATE  cw_modules SET module_name = "Team Target",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-09 04:17:16" where module_id = "est_team_target";
UPDATE  cw_modules SET module_name = "Project",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "",module_for = "1,2,3,4,5,8,9,10,11",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-10 12:24:12" where module_id = "project_list";
UPDATE  cw_modules SET module_name = "Work Type",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-10 12:24:47" where module_id = "est_work_type";
UPDATE  cw_modules SET module_name = "Det Work Type",module_type = "DYNAMIC",menu_id = "4",sub_menu_id = "22",module_for = "1,2,3,4,5",show_module = "",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-10 12:24:55" where module_id = "work_type";
UPDATE  cw_modules SET module_name = "Est Work Type",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-10 12:25:02" where module_id = "est_work_type";
UPDATE  cw_modules SET module_name = "Est Team",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-10 12:25:55" where module_id = "team_list";
UPDATE  cw_modules SET module_name = "City",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-10 12:26:15" where module_id = "city_list";
UPDATE  cw_modules SET module_name = "State",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-10 12:26:20" where module_id = "state_list";
UPDATE  cw_modules SET module_name = "Client Name",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-10 12:26:41" where module_id = "est_client_name";
UPDATE  cw_sub_menu SET map_main_menu = "4",sub_menu_name = "Common",trans_updated_by = "1",trans_updated_date = "2024-07-10 12:27:12" where prime_sub_menu_id = "1";
UPDATE  cw_modules SET module_name = "Client",module_type = "DYNAMIC",menu_id = "4",sub_menu_id = "1",module_for = "1,2,3,4,5",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-10 12:27:33" where module_id = "client";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("86","est_other_works","Est Other Works","DYNAMIC","14","30","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","1","","","1","2024-07-10 04:09:12");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_other_works","est_other_works");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_other_works","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "Project",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-11 03:53:20" where module_id = "project_list";
INSERT INTO cw_sub_menu (map_main_menu, sub_menu_name, sub_menu_sort, trans_created_by, trans_created_date) VALUES ("14","Transactions","17","1","2024-07-11 03:53:52");
UPDATE  cw_modules SET module_name = "Time Sheet",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "31",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-11 03:54:09" where module_id = "est_time_sheet";
UPDATE  cw_modules SET module_name = "Est Team Target",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "31",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-11 03:54:45" where module_id = "est_team_target";
UPDATE  cw_modules SET module_name = "Project And Assignment",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-11 03:55:25" where module_id = "project_list";
INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("est_time_sheet","13","and cw_est_time_sheet.employee_code in(^@logged_emp_code@^) and completed_status != 2","1","2024-07-12 04:00:51");
INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("est_time_sheet","14","and cw_est_time_sheet.employee_code in(^@logged_emp_code@^) and completed_status != 2","1","2024-07-12 04:01:29");
INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("est_time_sheet","13","and cw_est_time_sheet.employee_code in (^@logged_emp_code^) and completed_status != 2","1","2024-07-12 04:33:08");
INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("est_time_sheet","6","and cw_est_time_sheet.employee_code in (^@logged_emp_code^) and completed_status != 2","1","2024-07-12 04:33:31");
INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("est_time_sheet","14","and cw_est_time_sheet.employee_code in (^@logged_emp_code^) and completed_status != 2","1","2024-07-12 04:33:36");
UPDATE  cw_form_table_search SET query_module_id = "est_time_sheet",query_for = "13",where_condition = "and cw_est_time_sheet.employee_code in(^@logged_emp_code@^) and  completed_status != 2",trans_updated_by = "1",trans_updated_date = "2024-07-12 04:37:17" where prime_table_id = "20";
UPDATE  cw_form_table_search SET query_module_id = "est_time_sheet",query_for = "13",where_condition = "and cw_est_time_sheet.employee_code in(^@logged_emp_code@^) and  completed_status != 2",trans_updated_by = "1",trans_updated_date = "2024-07-12 04:46:27" where prime_table_id = "20";
UPDATE  cw_form_table_search SET query_module_id = "est_time_sheet",query_for = "6",where_condition = "and cw_est_time_sheet.employee_code in(^@logged_emp_code@^) and  completed_status != 2",trans_updated_by = "1",trans_updated_date = "2024-07-12 04:46:33" where prime_table_id = "21";
UPDATE  cw_form_table_search SET query_module_id = "est_time_sheet",query_for = "14",where_condition = "and cw_est_time_sheet.employee_code in(^@logged_emp_code@^) and  completed_status != 2",trans_updated_by = "1",trans_updated_date = "2024-07-12 04:46:36" where prime_table_id = "22";
UPDATE  cw_modules SET module_name = "Est Work Type",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-13 11:38:50" where module_id = "est_work_type";
UPDATE  cw_modules SET module_name = "Est Work Type",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "",quicklink = "",import_module = "1",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-13 11:39:13" where module_id = "est_work_type";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("87","est_tonnage_approval","Tons Or Revision Hours Approval","DYNAMIC","14","","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-13 01:10:22");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_tonnage_approval","est_tonnage_approval");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_tonnage_approval","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "Tons Or Revision Hours Approval",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "31",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-13 03:34:36" where module_id = "est_tonnage_approval";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("88","iqr_approval","IQR Approval","DYNAMIC","14","31","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-15 04:40:34");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("iqr_approval","iqr_approval");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("iqr_approval","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "Work Allocation Sheet",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "31",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-15 04:41:07" where module_id = "was_list";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:32" where module_id = "state_list";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:32" where module_id = "city_list";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:32" where module_id = "market_category";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:32" where module_id = "team_list";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:32" where module_id = "project_list";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:32" where module_id = "est_time_sheet";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:32" where module_id = "est_team_target";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:32" where module_id = "was_list";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:32" where module_id = "est_other_works";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:32" where module_id = "iqr_approval";
UPDATE cw_modules SET sort = "11",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:32" where module_id = "est_tonnage_approval";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:36" where module_id = "state_list";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:36" where module_id = "city_list";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:36" where module_id = "market_category";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:36" where module_id = "team_list";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:36" where module_id = "project_list";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:36" where module_id = "est_time_sheet";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:36" where module_id = "est_team_target";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:36" where module_id = "est_other_works";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:36" where module_id = "iqr_approval";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:36" where module_id = "was_list";
UPDATE cw_modules SET sort = "11",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:36" where module_id = "est_tonnage_approval";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:40" where module_id = "state_list";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:40" where module_id = "city_list";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:40" where module_id = "market_category";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:40" where module_id = "team_list";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:40" where module_id = "project_list";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:40" where module_id = "iqr_approval";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:40" where module_id = "est_time_sheet";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:40" where module_id = "est_team_target";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:40" where module_id = "est_other_works";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:40" where module_id = "was_list";
UPDATE cw_modules SET sort = "11",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:40" where module_id = "est_tonnage_approval";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:53" where module_id = "state_list";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:53" where module_id = "city_list";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:53" where module_id = "market_category";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:53" where module_id = "team_list";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:53" where module_id = "project_list";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:53" where module_id = "est_time_sheet";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:53" where module_id = "iqr_approval";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:53" where module_id = "est_team_target";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:53" where module_id = "est_other_works";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:53" where module_id = "was_list";
UPDATE cw_modules SET sort = "11",trans_updated_by = "1",trans_updated_date = "2024-07-15 16:41:53" where module_id = "est_tonnage_approval";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:14" where module_id = "state_list";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:14" where module_id = "city_list";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:14" where module_id = "team_list";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:14" where module_id = "market_category";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:14" where module_id = "project_list";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:14" where module_id = "est_time_sheet";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:14" where module_id = "iqr_approval";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:14" where module_id = "est_team_target";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:14" where module_id = "est_other_works";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:14" where module_id = "was_list";
UPDATE cw_modules SET sort = "11",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:14" where module_id = "est_tonnage_approval";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:39" where module_id = "state_list";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:39" where module_id = "city_list";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:39" where module_id = "team_list";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:39" where module_id = "market_category";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:39" where module_id = "est_other_works";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:39" where module_id = "project_list";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:39" where module_id = "est_time_sheet";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:39" where module_id = "iqr_approval";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:39" where module_id = "est_team_target";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:39" where module_id = "was_list";
UPDATE cw_modules SET sort = "11",trans_updated_by = "1",trans_updated_date = "2024-07-16 10:45:39" where module_id = "est_tonnage_approval";
INSERT INTO cw_sub_menu (map_main_menu, sub_menu_name, sub_menu_sort, trans_created_by, trans_created_date) VALUES ("14","Reports","18","1","2024-07-17 11:00:56");
UPDATE  cw_modules SET module_name = "Work Allocation Sheet",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "32",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-17 11:01:12" where module_id = "was_list";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("89","detailed_team","Detailed Team","DYNAMIC","14","30","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","1","","","1","2024-07-17 07:54:13");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("detailed_team","detailed_team");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("detailed_team","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("89","error_log","Error Log","DYNAMIC","14","31","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","1","","","1","2024-07-18 10:44:40");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("error_log","error_log");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("error_log","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("90","qa_checking","QA Checking","DYNAMIC","14","31","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-18 07:06:01");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("qa_checking","qa_checking");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("qa_checking","1","1","1","1","1","1","1");
INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("est_time_sheet","15","and cw_est_time_sheet.employee_code in(^@logged_emp_code@^) and  completed_status != 2","1","2024-07-19 10:42:25");
INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("est_time_sheet","16","and cw_est_time_sheet.employee_code in(^@logged_emp_code@^) and  completed_status != 2","1","2024-07-19 10:42:33");
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:20" where module_id = "state_list";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:20" where module_id = "city_list";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:20" where module_id = "team_list";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:20" where module_id = "market_category";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:20" where module_id = "est_other_works";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:20" where module_id = "project_list";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:20" where module_id = "est_time_sheet";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:20" where module_id = "iqr_approval";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:20" where module_id = "est_team_target";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:20" where module_id = "was_list";
UPDATE cw_modules SET sort = "11",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:20" where module_id = "error_log";
UPDATE cw_modules SET sort = "12",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:20" where module_id = "est_tonnage_approval";
UPDATE cw_modules SET sort = "13",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:20" where module_id = "qa_checking";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:24" where module_id = "state_list";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:24" where module_id = "city_list";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:24" where module_id = "team_list";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:24" where module_id = "market_category";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:24" where module_id = "est_other_works";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:24" where module_id = "project_list";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:24" where module_id = "est_time_sheet";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:24" where module_id = "iqr_approval";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:24" where module_id = "est_team_target";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:24" where module_id = "was_list";
UPDATE cw_modules SET sort = "11",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:24" where module_id = "qa_checking";
UPDATE cw_modules SET sort = "12",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:24" where module_id = "error_log";
UPDATE cw_modules SET sort = "13",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:24" where module_id = "est_tonnage_approval";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:32" where module_id = "error_log";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:32" where module_id = "state_list";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:32" where module_id = "city_list";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:32" where module_id = "team_list";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:32" where module_id = "market_category";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:32" where module_id = "est_other_works";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:32" where module_id = "project_list";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:32" where module_id = "est_time_sheet";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:32" where module_id = "iqr_approval";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:32" where module_id = "est_team_target";
UPDATE cw_modules SET sort = "11",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:32" where module_id = "was_list";
UPDATE cw_modules SET sort = "12",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:32" where module_id = "qa_checking";
UPDATE cw_modules SET sort = "13",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:32" where module_id = "est_tonnage_approval";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:52" where module_id = "error_log";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:52" where module_id = "state_list";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:52" where module_id = "city_list";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:52" where module_id = "team_list";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:52" where module_id = "market_category";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:52" where module_id = "est_other_works";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:52" where module_id = "project_list";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:52" where module_id = "est_time_sheet";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:52" where module_id = "iqr_approval";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:52" where module_id = "qa_checking";
UPDATE cw_modules SET sort = "11",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:52" where module_id = "est_team_target";
UPDATE cw_modules SET sort = "12",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:52" where module_id = "was_list";
UPDATE cw_modules SET sort = "13",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:53:52" where module_id = "est_tonnage_approval";
UPDATE  cw_sub_menu SET sub_menu_sort = "1",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "5";
UPDATE  cw_sub_menu SET sub_menu_sort = "2",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "6";
UPDATE  cw_sub_menu SET sub_menu_sort = "3",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "2";
UPDATE  cw_sub_menu SET sub_menu_sort = "4",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "3";
UPDATE  cw_sub_menu SET sub_menu_sort = "5",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "4";
UPDATE  cw_sub_menu SET sub_menu_sort = "6",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "1";
UPDATE  cw_sub_menu SET sub_menu_sort = "7",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "22";
UPDATE  cw_sub_menu SET sub_menu_sort = "8",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "23";
UPDATE  cw_sub_menu SET sub_menu_sort = "9",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "28";
UPDATE  cw_sub_menu SET sub_menu_sort = "10",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "20";
UPDATE  cw_sub_menu SET sub_menu_sort = "11",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "24";
UPDATE  cw_sub_menu SET sub_menu_sort = "12",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "25";
UPDATE  cw_sub_menu SET sub_menu_sort = "13",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "26";
UPDATE  cw_sub_menu SET sub_menu_sort = "14",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "27";
UPDATE  cw_sub_menu SET sub_menu_sort = "15",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "29";
UPDATE  cw_sub_menu SET sub_menu_sort = "16",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "31";
UPDATE  cw_sub_menu SET sub_menu_sort = "17",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "30";
UPDATE  cw_sub_menu SET sub_menu_sort = "18",trans_updated_by = "1",trans_updated_date = "" where prime_sub_menu_id = "32";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:55:07" where module_id = "error_log";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:55:07" where module_id = "state_list";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:55:07" where module_id = "city_list";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:55:07" where module_id = "team_list";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:55:07" where module_id = "market_category";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:55:07" where module_id = "est_other_works";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:55:07" where module_id = "project_list";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:55:07" where module_id = "est_time_sheet";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:55:07" where module_id = "iqr_approval";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:55:07" where module_id = "qa_checking";
UPDATE cw_modules SET sort = "11",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:55:07" where module_id = "est_team_target";
UPDATE cw_modules SET sort = "12",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:55:07" where module_id = "est_tonnage_approval";
UPDATE cw_modules SET sort = "13",trans_updated_by = "1",trans_updated_date = "2024-07-19 15:55:07" where module_id = "was_list";
UPDATE  cw_modules SET module_name = "Work Allocation Sheet",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "32",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-19 03:55:29" where module_id = "was_list";
UPDATE  cw_sub_menu SET map_main_menu = "14",sub_menu_name = "Reports",trans_updated_by = "1",trans_updated_date = "2024-07-19 03:55:44" where prime_sub_menu_id = "32";
UPDATE  cw_modules SET module_name = "Work Allocation Sheet",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-19 03:56:07" where module_id = "was_list";
UPDATE  cw_modules SET module_name = "Work Allocation Sheet",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "32",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-19 03:56:18" where module_id = "was_list";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("91","estimator_report","Estimator Report","DYNAMIC","14","32","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-19 04:04:41");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("estimator_report","estimator_report");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("estimator_report","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "Estimator TimeSheet Report",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "32",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-19 04:34:51" where module_id = "estimator_report";
UPDATE  cw_modules SET module_name = "Estimator Timesheet Report",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "32",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-19 04:36:40" where module_id = "estimator_report";
UPDATE  cw_main_menu SET menu_name = "Detailer Report",menu_for = "1,2,3,4,5",trans_updated_by = "1",trans_updated_date = "2024-07-19 04:42:21" where prime_menu_id = "10";
INSERT INTO cw_main_menu (menu_name, menu_for, menu_sort, trans_created_by, trans_created_date) VALUES ("Estimator Report","1,2,3,4,5,8,9,10,11,12,13,14,15","9","1","2024-07-19 04:42:31");
UPDATE  cw_main_menu SET menu_sort = "1",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "5";
UPDATE  cw_main_menu SET menu_sort = "2",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "4";
UPDATE  cw_main_menu SET menu_sort = "3",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "14";
UPDATE  cw_main_menu SET menu_sort = "4",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "13";
UPDATE  cw_main_menu SET menu_sort = "5",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "15";
UPDATE  cw_main_menu SET menu_sort = "6",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "10";
UPDATE  cw_main_menu SET menu_sort = "7",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "12";
UPDATE  cw_main_menu SET menu_sort = "8",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "2";
UPDATE  cw_main_menu SET menu_sort = "9",trans_updated_by = "1",trans_updated_date = "" where prime_menu_id = "1";
INSERT INTO cw_sub_menu (map_main_menu, sub_menu_name, sub_menu_sort, trans_created_by, trans_created_date) VALUES ("15","Month Wise Timesheet","19","1","2024-07-19 04:44:24");
UPDATE  cw_modules SET module_name = "Estimator Timesheet Report",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "33",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-19 04:44:38" where module_id = "estimator_report";
UPDATE  cw_modules SET module_name = "Estimator Timesheet",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "33",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-19 04:45:19" where module_id = "estimator_report";
UPDATE  cw_modules SET module_name = "Work Allocation Sheet",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "31",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-19 04:47:03" where module_id = "was_list";
UPDATE  cw_main_menu SET menu_name = "Est Report",menu_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",trans_updated_by = "1",trans_updated_date = "2024-07-20 11:33:57" where prime_menu_id = "15";
UPDATE  cw_main_menu SET menu_name = "Det Report",menu_for = "1,2,3,4,5",trans_updated_by = "1",trans_updated_date = "2024-07-20 11:34:03" where prime_menu_id = "10";
UPDATE  cw_modules SET module_name = "Email Process",module_type = "CUSTOM",menu_id = "2",sub_menu_id = "",module_for = "1,2,3,4,5",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-20 11:35:35" where module_id = "email_process";
UPDATE  cw_modules SET module_name = "Email Campaign",module_type = "CUSTOM",menu_id = "2",sub_menu_id = "",module_for = "1,2,3,4,5",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-20 11:35:43" where module_id = "email_campaign";
UPDATE  cw_modules SET module_name = "Mail Configurations",module_type = "CUSTOM",menu_id = "2",sub_menu_id = "",module_for = "1,2,3,4,5",show_module = "1",quicklink = "employees",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-20 11:35:58" where module_id = "mail_configurations";
UPDATE  cw_modules SET module_name = "SMS Compaign",module_type = "DYNAMIC",menu_id = "2",sub_menu_id = "",module_for = "1,2,3,4,5",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-20 11:36:08" where module_id = "sms_compaign";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("88","estimator_checker_report","Estimator Checker Report","DYNAMIC","15","","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-24 03:57:01");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("estimator_checker_report","estimator_checker_report");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("estimator_checker_report","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "Estimator Checker Report",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "33",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-24 03:57:41" where module_id = "estimator_checker_report";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-24 15:57:57" where module_id = "estimator_report";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-24 15:57:57" where module_id = "estimator_checker_report";
UPDATE  cw_modules SET module_name = "Estimator Report",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "33",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-24 03:58:44" where module_id = "estimator_report";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("89","estimator_partial_checker_report","Estimator Partial Checker Report","DYNAMIC","15","33","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-24 05:32:02");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("estimator_partial_checker_report","estimator_partial_checker_report");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("estimator_partial_checker_report","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("90","estimator_project_manager_report","Estimator Project Manager Report","DYNAMIC","15","33","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-24 06:41:45");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("estimator_project_manager_report","estimator_project_manager_report");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("estimator_project_manager_report","1","1","1","1","1","1","1");
INSERT INTO cw_sub_menu (map_main_menu, sub_menu_name, sub_menu_sort, trans_created_by, trans_created_date) VALUES ("15","Productivity Report","20","1","2024-07-26 09:58:48");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("91","est_prd_report","Est Productivity Report","DYNAMIC","15","34","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-26 09:59:44");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_prd_report","est_prd_report");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_prd_report","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("92","est_prd_chk_report","Est Checker Productivity Report","DYNAMIC","15","34","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-27 05:39:14");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_prd_chk_report","est_prd_chk_report");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_prd_chk_report","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "Est Report",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "33",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-27 05:40:27" where module_id = "estimator_report";
UPDATE  cw_modules SET module_name = "Est Checker Report",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "33",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-27 05:40:34" where module_id = "estimator_checker_report";
UPDATE  cw_modules SET module_name = "Est Partial Checker Report",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "33",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-27 05:40:40" where module_id = "estimator_partial_checker_report";
UPDATE  cw_modules SET module_name = "Est Project Manager Report",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "33",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-27 05:40:47" where module_id = "estimator_project_manager_report";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("93","est_partial_chk_report","Est Partial Checker Report","DYNAMIC","15","34","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-27 05:47:14");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_partial_chk_report","est_partial_chk_report");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_partial_chk_report","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("94","est_pm_prd_report","Est Project Manager Report","DYNAMIC","15","34","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-27 06:24:46");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_pm_prd_report","est_pm_prd_report");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_pm_prd_report","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "Est PM Productivity Report",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "34",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-27 06:29:52" where module_id = "est_pm_prd_report";
UPDATE  cw_modules SET module_name = "Est Partial Checker Prd Report",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "34",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-27 06:30:12" where module_id = "est_partial_chk_report";
UPDATE  cw_modules SET module_name = "Est Partial Checker Productivity Report",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "34",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-27 06:30:48" where module_id = "est_partial_chk_report";
INSERT INTO cw_sub_menu (map_main_menu, sub_menu_name, sub_menu_sort, trans_created_by, trans_created_date) VALUES ("15","other reports","21","1","2024-07-29 10:05:17");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("95","project_report","Project Report","DYNAMIC","15","35","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-29 10:05:49");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("project_report","project_report");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("project_report","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("96","month_cycle","Month Cycle","DYNAMIC","14","30","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","1","","","1","2024-07-29 07:41:45");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("month_cycle","month_cycle");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("month_cycle","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("97","submittal_log","Submittal Log","DYNAMIC","15","35","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-30 05:41:11");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("submittal_log","submittal_log");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("submittal_log","1","1","1","1","1","1","1");
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:42:56" where module_id = "estimator_report";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:42:56" where module_id = "estimator_checker_report";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:42:56" where module_id = "estimator_partial_checker_report";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:42:56" where module_id = "estimator_project_manager_report";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:42:56" where module_id = "est_prd_report";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:42:56" where module_id = "est_prd_chk_report";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:42:56" where module_id = "est_pm_prd_report";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:42:56" where module_id = "est_partial_chk_report";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:42:56" where module_id = "project_report";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:42:56" where module_id = "submittal_log";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:16" where module_id = "estimator_report";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:16" where module_id = "estimator_checker_report";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:16" where module_id = "estimator_project_manager_report";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:16" where module_id = "estimator_partial_checker_report";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:16" where module_id = "est_prd_report";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:16" where module_id = "est_prd_chk_report";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:16" where module_id = "est_pm_prd_report";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:16" where module_id = "est_partial_chk_report";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:16" where module_id = "project_report";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:16" where module_id = "submittal_log";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:33" where module_id = "estimator_report";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:33" where module_id = "estimator_checker_report";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:33" where module_id = "estimator_project_manager_report";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:33" where module_id = "estimator_partial_checker_report";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:33" where module_id = "est_prd_report";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:33" where module_id = "est_pm_prd_report";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:33" where module_id = "est_prd_chk_report";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:33" where module_id = "est_partial_chk_report";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:33" where module_id = "project_report";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-30 17:43:33" where module_id = "submittal_log";
INSERT INTO cw_sub_menu (map_main_menu, sub_menu_name, sub_menu_sort, trans_created_by, trans_created_date) VALUES ("15","Performance Report","22","1","2024-07-30 07:17:11");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("98","est_perform_report","Est Performance Report","DYNAMIC","15","36","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-30 07:18:18");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_perform_report","est_perform_report");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_perform_report","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("99","est_chk_perform_report","Est Checker Performance Report","DYNAMIC","15","36","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-31 02:11:36");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_chk_perform_report","est_chk_perform_report");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_chk_perform_report","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "Est Performance Report IQR",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "36",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-31 02:22:29" where module_id = "est_perform_report";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("100","est_perform_report_co","Est Perform Report CO Team ","DYNAMIC","15","36","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-31 02:23:27");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_perform_report_co","est_perform_report_co");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_perform_report_co","1","1","1","1","1","1","1");
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:25:39" where module_id = "estimator_report";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:25:39" where module_id = "estimator_checker_report";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:25:39" where module_id = "estimator_project_manager_report";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:25:39" where module_id = "estimator_partial_checker_report";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:25:39" where module_id = "est_prd_report";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:25:39" where module_id = "est_pm_prd_report";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:25:39" where module_id = "est_prd_chk_report";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:25:39" where module_id = "est_partial_chk_report";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:25:39" where module_id = "project_report";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:25:39" where module_id = "submittal_log";
UPDATE cw_modules SET sort = "11",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:25:39" where module_id = "est_perform_report";
UPDATE cw_modules SET sort = "12",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:25:39" where module_id = "est_perform_report_co";
UPDATE cw_modules SET sort = "13",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:25:39" where module_id = "est_chk_perform_report";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("101","est_partial_perform_report","Est Partial Performance Report","DYNAMIC","15","36","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-07-31 02:37:50");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_partial_perform_report","est_partial_perform_report");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_partial_perform_report","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "Est Partial Checker Performance ",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "36",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-31 02:40:56" where module_id = "est_partial_perform_report";
UPDATE  cw_modules SET module_name = "Est Checker Performance ",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "36",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-31 02:41:05" where module_id = "est_chk_perform_report";
UPDATE  cw_modules SET module_name = "Est Productivity ",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "34",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-31 02:41:12" where module_id = "est_prd_report";
UPDATE  cw_modules SET module_name = "Est Checker Productivity ",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "34",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-31 02:41:16" where module_id = "est_prd_chk_report";
UPDATE  cw_modules SET module_name = "Est PM Productivity ",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "34",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-31 02:41:20" where module_id = "est_pm_prd_report";
UPDATE  cw_modules SET module_name = "Est Partial Checker Productivity ",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "34",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-31 02:41:27" where module_id = "est_partial_chk_report";
UPDATE  cw_modules SET module_name = "Est Perform CO Team ",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "36",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-31 02:43:30" where module_id = "est_perform_report_co";
UPDATE  cw_modules SET module_name = "Est Performance IQR",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "36",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-31 02:43:37" where module_id = "est_perform_report";
UPDATE  cw_modules SET module_name = "Est Performance CO Team ",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "36",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-31 02:44:02" where module_id = "est_perform_report_co";
UPDATE  cw_modules SET module_name = "Est PM Report",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "33",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-07-31 02:44:48" where module_id = "estimator_project_manager_report";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:12" where module_id = "estimator_report";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:12" where module_id = "est_pm_prd_report";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:12" where module_id = "estimator_checker_report";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:12" where module_id = "estimator_project_manager_report";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:12" where module_id = "estimator_partial_checker_report";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:12" where module_id = "est_prd_report";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:12" where module_id = "est_prd_chk_report";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:12" where module_id = "est_partial_chk_report";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:12" where module_id = "project_report";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:12" where module_id = "submittal_log";
UPDATE cw_modules SET sort = "11",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:12" where module_id = "est_perform_report";
UPDATE cw_modules SET sort = "12",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:12" where module_id = "est_perform_report_co";
UPDATE cw_modules SET sort = "13",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:12" where module_id = "est_chk_perform_report";
UPDATE cw_modules SET sort = "14",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:12" where module_id = "est_partial_perform_report";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:33" where module_id = "estimator_report";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:33" where module_id = "est_pm_prd_report";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:33" where module_id = "estimator_project_manager_report";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:33" where module_id = "estimator_checker_report";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:33" where module_id = "estimator_partial_checker_report";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:33" where module_id = "est_prd_report";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:33" where module_id = "est_prd_chk_report";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:33" where module_id = "est_partial_chk_report";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:33" where module_id = "project_report";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:33" where module_id = "submittal_log";
UPDATE cw_modules SET sort = "11",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:33" where module_id = "est_perform_report";
UPDATE cw_modules SET sort = "12",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:33" where module_id = "est_perform_report_co";
UPDATE cw_modules SET sort = "13",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:33" where module_id = "est_chk_perform_report";
UPDATE cw_modules SET sort = "14",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:33" where module_id = "est_partial_perform_report";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:48" where module_id = "estimator_report";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:48" where module_id = "estimator_project_manager_report";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:48" where module_id = "estimator_checker_report";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:48" where module_id = "estimator_partial_checker_report";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:48" where module_id = "est_prd_report";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:48" where module_id = "est_prd_chk_report";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:48" where module_id = "est_pm_prd_report";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:48" where module_id = "est_partial_chk_report";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:48" where module_id = "project_report";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:48" where module_id = "submittal_log";
UPDATE cw_modules SET sort = "11",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:48" where module_id = "est_perform_report";
UPDATE cw_modules SET sort = "12",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:48" where module_id = "est_perform_report_co";
UPDATE cw_modules SET sort = "13",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:48" where module_id = "est_chk_perform_report";
UPDATE cw_modules SET sort = "14",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:45:48" where module_id = "est_partial_perform_report";
UPDATE cw_modules SET sort = "1",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:46:09" where module_id = "estimator_report";
UPDATE cw_modules SET sort = "2",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:46:09" where module_id = "estimator_project_manager_report";
UPDATE cw_modules SET sort = "3",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:46:09" where module_id = "estimator_checker_report";
UPDATE cw_modules SET sort = "4",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:46:09" where module_id = "estimator_partial_checker_report";
UPDATE cw_modules SET sort = "5",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:46:09" where module_id = "est_prd_report";
UPDATE cw_modules SET sort = "6",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:46:09" where module_id = "est_pm_prd_report";
UPDATE cw_modules SET sort = "7",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:46:09" where module_id = "est_prd_chk_report";
UPDATE cw_modules SET sort = "8",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:46:09" where module_id = "est_partial_chk_report";
UPDATE cw_modules SET sort = "9",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:46:09" where module_id = "project_report";
UPDATE cw_modules SET sort = "10",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:46:09" where module_id = "submittal_log";
UPDATE cw_modules SET sort = "11",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:46:09" where module_id = "est_perform_report";
UPDATE cw_modules SET sort = "12",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:46:09" where module_id = "est_perform_report_co";
UPDATE cw_modules SET sort = "13",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:46:09" where module_id = "est_chk_perform_report";
UPDATE cw_modules SET sort = "14",trans_updated_by = "1",trans_updated_date = "2024-07-31 14:46:09" where module_id = "est_partial_perform_report";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("102","est_pm_performance","Est Pm Performance","DYNAMIC","15","36","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-08-02 07:24:26");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_pm_performance","est_pm_performance");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_pm_performance","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "Est PM Performance",module_type = "DYNAMIC",menu_id = "15",sub_menu_id = "36",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-08-02 07:25:09" where module_id = "est_pm_performance";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("103","ess_sheet","ESS Sheet","DYNAMIC","15","35","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-08-05 12:11:35");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("ess_sheet","ess_sheet");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("ess_sheet","1","1","1","1","1","1","1");
UPDATE  cw_sub_menu SET map_main_menu = "15",sub_menu_name = "Other reports",trans_updated_by = "1",trans_updated_date = "2024-08-05 01:04:18" where prime_sub_menu_id = "35";
INSERT INTO cw_sub_menu (map_main_menu, sub_menu_name, sub_menu_sort, trans_created_by, trans_created_date) VALUES ("15","Appraisal Reports","23","1","2024-08-05 01:05:29");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("104","est_appraisal_report","Est Appraisal Report","DYNAMIC","15","37","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-08-05 01:06:34");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_appraisal_report","est_appraisal_report");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_appraisal_report","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("105","est_chk_appraisal","Est Chk Appraisal Report","DYNAMIC","15","37","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-08-07 07:11:11");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_chk_appraisal","est_chk_appraisal");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_chk_appraisal","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("106","est_partial_chk_appraisal","Est Partial Checker Appraisal Report","DYNAMIC","15","37","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-08-08 01:04:41");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_partial_chk_appraisal","est_partial_chk_appraisal");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_partial_chk_appraisal","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("107","work_load","Work Load","DYNAMIC","14","31","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-08-09 11:02:53");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("work_load","work_load");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("work_load","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("108","price_information","Price Information","DYNAMIC","14","30","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-08-10 09:46:05");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("price_information","price_information");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("price_information","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "Price Information",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "31",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-08-11 12:17:23" where module_id = "price_information";
----------------------------Moved to Live 12Aug2024 -------------------
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("111","est_leaves","Est Employee Leaves","DYNAMIC","14","30","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","","","","","1","2024-08-21 11:01:08");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("est_leaves","est_leaves");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("est_leaves","1","1","1","1","1","1","1");
INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("estimator_report","13","and cw_employees.employee_code in(^@logged_emp_code@^)","1","2024-08-23 10:29:01");
UPDATE  cw_form_table_search SET query_module_id = "estimator_report",query_for = "13",where_condition = "and employee_code in(^@logged_emp_code@^)",trans_updated_by = "1",trans_updated_date = "2024-08-23 10:48:26" where prime_table_id = "27";
INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("estimator_report","14","and employee_code in(^@logged_emp_code@^)","1","2024-08-24 09:41:19");
INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("estimator_report","13","and cw_employees.employee_code in(^@logged_emp_code@^)","1","2024-09-02 06:23:21");
INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("estimator_report","15","and  employee_code in(^@logged_emp_code@^)","1","2024-09-02 06:23:36");
UPDATE  cw_form_table_search SET query_module_id = "estimator_report",query_for = "13",where_condition = "and  employee_code in(^@logged_emp_code@^)",trans_updated_by = "1",trans_updated_date = "2024-09-02 06:23:43" where prime_table_id = "27";
INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("estimator_report","14","	and team in(^@logged_est_team@^)","1","2024-09-02 06:24:24");
INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("estimator_report","16","and team in(^@logged_est_team@^)","1","2024-09-02 06:24:35");
UPDATE  cw_modules SET module_name = "Est Team",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-09-26 10:16:21" where module_id = "team_list";
UPDATE  cw_modules SET module_name = "Est Team",module_type = "DYNAMIC",menu_id = "14",sub_menu_id = "30",module_for = "1,2,3,4,5,8,9,10,11,12,13",show_module = "1",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-09-26 10:23:02" where module_id = "team_list";
UPDATE  cw_modules SET module_name = "Blood Group",module_type = "DYNAMIC",menu_id = "5",sub_menu_id = "5",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15,16",show_module = "",quicklink = "Array",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-11-15 03:08:37" where module_id = "blood_group";
UPDATE  cw_modules SET module_name = "Blood Group",module_type = "DYNAMIC",menu_id = "5",sub_menu_id = "5",module_for = "4",show_module = "",quicklink = "state_listestimator_project_manager_reportbranch",import_module = "",pdf_module = "",custom_module = "",rights_to = "1",trans_updated_by = "1",trans_updated_date = "2024-11-15 03:08:55" where module_id = "blood_group";
UPDATE  cw_modules SET module_name = "Blood Group",module_type = "DYNAMIC",menu_id = "5",sub_menu_id = "5",module_for = "4",show_module = "",quicklink = "blood_groupestimator_project_manager_report",import_module = "",pdf_module = "",custom_module = "",rights_to = "1",trans_updated_by = "1",trans_updated_date = "2024-11-15 03:09:02" where module_id = "blood_group";
UPDATE  cw_modules SET module_name = "Blood Group",module_type = "DYNAMIC",menu_id = "5",sub_menu_id = "5",module_for = "4",show_module = "",quicklink = "state_list,estimator_project_manager_report",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-11-15 03:10:50" where module_id = "blood_group";
UPDATE  cw_modules SET module_name = "Blood Group",module_type = "DYNAMIC",menu_id = "5",sub_menu_id = "5",module_for = "4",show_module = "",quicklink = "state_list",import_module = "",pdf_module = "",custom_module = "",rights_to = "1",trans_updated_by = "1",trans_updated_date = "2024-11-15 03:10:58" where module_id = "blood_group";
INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("blood_group","6","and cw_blood_group.testtime = ^@logged_emp_code@^","1","2024-11-15 03:11:28");
UPDATE  cw_form_table_search SET trans_status = 0 ,trans_deleted_by = "1",trans_deleted_date = "2024-11-15 03:11:32" where prime_table_id = "32";
UPDATE  cw_modules SET module_name = "Employee Master",module_type = "CUSTOM",menu_id = "5",sub_menu_id = "2",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15,16",show_module = "1",quicklink = "Array",import_module = "1",pdf_module = "1",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-11-15 03:11:55" where module_id = "employees";
INSERT INTO cw_main_menu (menu_name, menu_for, menu_sort, trans_created_by, trans_created_date) VALUES ("Goat","1","10","1","2024-11-16 10:44:41");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("112","1232134","Ram","DYNAMIC","13","28","8","2","","Array","","","","1","2024-11-16 10:47:01");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("1232134","1232134");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("1232134","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "Blood Group",module_type = "DYNAMIC",menu_id = "5",sub_menu_id = "5",module_for = "4",show_module = "",quicklink = "state_list",import_module = "",pdf_module = "",custom_module = "",rights_to = "1",trans_updated_by = "1",trans_updated_date = "2024-11-16 04:24:21" where module_id = "blood_group";
UPDATE  cw_modules SET module_name = "Blood Group",module_type = "DYNAMIC",menu_id = "5",sub_menu_id = "5",module_for = "4",show_module = "",quicklink = "state_list",import_module = "",pdf_module = "",custom_module = "1",rights_to = "1",trans_updated_by = "1",trans_updated_date = "2024-11-19 02:46:29" where module_id = "blood_group";
UPDATE  cw_modules SET module_name = "Blood Group",module_type = "DYNAMIC",menu_id = "5",sub_menu_id = "5",module_for = "4",show_module = "",quicklink = "state_list",import_module = "",pdf_module = "",custom_module = "1",rights_to = "1",trans_updated_by = "1",trans_updated_date = "2024-11-19 02:46:48" where module_id = "blood_group";
INSERT INTO cw_main_menu (menu_name, menu_for, menu_sort, trans_created_by, trans_created_date) VALUES ("uuu","2","12","1","2024-11-19 02:47:20");
UPDATE  cw_main_menu SET menu_name = "Detailing",menu_for = "1,2,3,4,5",trans_updated_by = "1",trans_updated_date = "2024-11-19 02:47:46" where prime_menu_id = "4";
INSERT INTO cw_main_menu (menu_name, menu_for, menu_sort, trans_created_by, trans_created_date) VALUES ("Goat","5","10","1","2024-11-19 07:52:25");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("112","1232134","Ram","DYNAMIC","4","1","1","1","1","estimator_project_manager_report","1","","1","1","2024-11-19 07:53:23");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("1232134","1232134");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("1232134","1","1","1","1","1","1","1");
UPDATE  cw_modules SET module_name = "State",module_type = "DYNAMIC",menu_id = "5",sub_menu_id = "5",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "",quicklink = "Array",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-11-19 07:54:49" where module_id = "state";
UPDATE  cw_modules SET module_name = "State",module_type = "DYNAMIC",menu_id = "5",sub_menu_id = "5",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "",quicklink = "Array",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-11-19 07:55:29" where module_id = "state";
UPDATE  cw_modules SET module_name = "Ram",module_type = "DYNAMIC",menu_id = "4",sub_menu_id = "1",module_for = "1",show_module = "1",quicklink = "estimator_project_manager_report",import_module = "",pdf_module = "",custom_module = "1",rights_to = "1",trans_updated_by = "1",trans_updated_date = "2024-11-21 03:28:13" where module_id = "1232134";
UPDATE  cw_modules SET module_name = "Ram",module_type = "DYNAMIC",menu_id = "4",sub_menu_id = "1",module_for = "1",show_module = "",quicklink = "estimator_project_manager_report",import_module = "",pdf_module = "",custom_module = "1",rights_to = "1",trans_updated_by = "1",trans_updated_date = "2024-11-21 03:29:00" where module_id = "1232134";
UPDATE  cw_modules SET module_name = "Employee Master",module_type = "CUSTOM",menu_id = "5",sub_menu_id = "2",module_for = "1",show_module = "1",quicklink = "Array",import_module = "1",pdf_module = "1",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-11-23 10:44:42" where module_id = "employees";
UPDATE  cw_modules SET module_name = "State",module_type = "DYNAMIC",menu_id = "5",sub_menu_id = "5",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-11-23 10:46:18" where module_id = "state";
UPDATE  cw_modules SET module_name = "State",module_type = "DYNAMIC",menu_id = "5",sub_menu_id = "5",module_for = "1,2,3,4,5,8,9,10,11,12,13,14,15",show_module = "",quicklink = "",import_module = "",pdf_module = "",custom_module = "",rights_to = "1,2",trans_updated_by = "1",trans_updated_date = "2024-11-23 10:46:26" where module_id = "state";
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("112","api_call","Api Call","DYNAMIC","5","20","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","Array","","","1","1","2025-01-04 05:29:54");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("api_call","api_call");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("api_call","1","1","1","1","1","1","1");
INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,trans_created_by, trans_created_date) VALUES ("113","cron_status","Cron Status","DYNAMIC","2","","1,2,3,4,5,8,9,10,11,12,13,14,15","1,2","1","Array","","","","1","2025-01-06 11:54:31");
INSERT INTO cw_permissions (permission_id, module_id) VALUES ("cron_status","cron_status");
INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("cron_status","1","1","1","1","1","1","1");