INSERT INTO `adm_mst_tmodule` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`icon_name`)  VALUES ('COR','$','COR',71,'ems_courier/courier_transaction.aspx#',1,3,'Courier','1','','Courier','E1','Courier','','','','N','Y',NULL,NULL,NULL,NULL,'N',NULL,NULL,NULL);   INSERT INTO `adm_mst_tmodule` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`icon_name`)  VALUES ('CORSET', 'COR', 'CORSET', '1001', 'ems_courier/courier_transaction.aspx#', '2', NULL, 'Settings', '1', '../images/Settings.gif', '', '', 'Settings', '', '', '', 'N', 'N', NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL);   INSERT INTO `adm_mst_tmodule` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`icon_name`)  VALUES ('CORSETCON', 'CORSET', 'CORSETCON', '1002', 'ems_courier/cor_mst_company.aspx', '3', NULL, 'Company', '1', '../images/ico_report_grn_RS.png', 'SETTING', '', 'Company', '', '', '', 'N', 'N', NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL ); INSERT INTO `adm_mst_tmodule` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`icon_name`) VALUES ('CORSETURL', 'CORSET', 'CORSETURL', '1003', 'ems_courier/cor_mst_userrolesummary.aspx', '3', NULL, 'User role', '1', '../images/ICO_RAISE_PR_RS.png', 'SETTING', '', 'User role', '', '', '', 'N', 'N', NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL ); INSERT INTO `adm_mst_tmodule` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`icon_name`) VALUES ('CORSETHCY', 'CORSET', 'CORSETHCY', '1004', 'ems_courier/cor_mst_organisationhierarchy.aspx', '3', NULL, 'Hierarchy', '1', '../images/ICO_RAISE_INVOICE_RS.png', 'SETTING', '', 'Hierarchy', '', '', '', 'N', 'N', NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL ); ----------------------------------------------------------------------------------------------------------- INSERT INTO `adm_mst_tmodule` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`icon_name`) VALUES ('CORMST', 'COR', 'CORMST', '1005', 'ems_courier/courier_transaction.aspx#', '2', NULL, 'Masters', '1', '../images/Settings.gif', '', '', 'Masters', '', '', '', 'N', 'N', NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL ); INSERT INTO `adm_mst_tmodule` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`icon_name`) VALUES ('CORMSTCUS', 'CORMST', 'CORMSTCUS', '1006', 'ems_courier/cor_mst_customersummary.aspx', '3', NULL, 'Customer', '1', '', '', '', 'Customer', '', '', '', 'N', 'N', NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL ); INSERT INTO `adm_mst_tmodule` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`icon_name`) VALUES ('CORMSTCOS', 'CORMST', 'CORMSTCOS', '1007', 'ems_courier/cor_mst_courierservicesummary.aspx', '3', NULL, 'Courier Service', '1', '', '', '', 'Courier Service', '', '', '', 'N', 'N', NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL ); ------------------------------------------------------------------------------------------------------------------------- INSERT INTO `adm_mst_tmodule` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`icon_name`) VALUES ('CORCOM', 'COR', 'CORCOM', '1008', 'ems_courier/courier_management.aspx#', '2', '4', 'Courier Management', '1', '', '', '', 'Courier Management', '', '', '', 'N', 'N', '', NULL, '', NULL, 'Y', '', '', NULL ); INSERT INTO `adm_mst_tmodule` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`icon_name`) VALUES ('CORCOMCOR', 'CORCOM', 'CORCOMCOR', '1009', 'ems_courier/cor_trn_couriersummary.aspx', '3', NULL, 'Courier', '1', NULL, NULL, NULL, 'Courier', NULL, NULL, NULL, 'N', 'N', NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL ); ------------------------------------------------------------------------------------------------------------------------------------------------ INSERT INTO `adm_mst_tmodule` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`icon_name`) VALUES ('CORORT', 'COR', 'CORORT', '1010', 'ems_courier/courier_transaction.aspx#', '2', NULL, 'Reports', '1', '../images/Reports.gif', '', '', 'Reports', '', '', '', 'N', 'N', NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL ); INSERT INTO `adm_mst_tmodule` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`icon_name`) VALUES ('CORORTCGR', 'CORORT', 'CORORTCGR', '1111', 'ems_courier/cor_rpt_consignmentreport.aspx', '3', NULL, 'Consignment Report', '1', NULL, 'REPORT', NULL, 'Consignment Report', NULL, NULL, NULL, 'N', 'N', NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL ); -----------------------------------------------------23-05-2024------------------------------------------------------------------ INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('SSQM2405237593','CSNE','Courier Service name','4','1','N','N','N','N','N','N','','','','2024','N',NULL,NULL,NULL,NULL); CREATE TABLE `cor_mst_tcourierservcice` ( `courierservcice_gid` varchar(16) NOT NULL, `courierservcice_code` varchar(45) DEFAULT NULL, `courierservcice_name` varchar(45) DEFAULT NULL, `courierservcice_desc` varchar(128) DEFAULT NULL, `created_by` varchar(64) DEFAULT NULL, `updated_by` varchar(64) DEFAULT NULL, `created_date` datetime DEFAULT NULL, `updated_date` datetime DEFAULT NULL, PRIMARY KEY (`courierservcice_gid`), KEY `Index_2` (`courierservcice_code`), KEY `Index_3` (`courierservcice_name`) ) ; INSERT INTO `adm_mst_terror` (`error_gid`,`error_code`,`error_message`,`error_type`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('COS230420240001','COR_SUC_001','Courier Service Add successfully !','SUCCESS',NULL,NULL,NULL,NULL); INSERT INTO `adm_mst_terror` (`error_gid`,`error_code`,`error_message`,`error_type`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('COS230420240002','COR_SUC_002','CourierService deleted successfully!','SUCCESS',NULL,NULL,NULL,NULL); INSERT INTO `adm_mst_terror` (`error_gid`,`error_code`,`error_message`,`error_type`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('COS230420240003','COR_SUC_003','Error while deleting CourierService','FAILURE',NULL,NULL,NULL,NULL); INSERT INTO `adm_mst_terror` (`error_gid`,`error_code`,`error_message`,`error_type`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('COS230420240004','COR_SUC_004',' CourierService updated successfully','SUCCESS',NULL,NULL,NULL,NULL); INSERT INTO `adm_mst_terror` (`error_gid`,`error_code`,`error_message`,`error_type`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('COS230420240005','COR_SUC_005','Error while updating CourierService','FAILURE',NULL,NULL,NULL,NULL); CREATE TABLE `cor_mst_tcouriermode` ( `mode_gid` varchar(16) NOT NULL, `mode_code` varchar(45) DEFAULT NULL, `mode_name` varchar(45) DEFAULT NULL, `created_by` varchar(64) DEFAULT NULL, `updated_by` varchar(64) DEFAULT NULL, `created_date` datetime DEFAULT NULL, `updated_date` datetime DEFAULT NULL, PRIMARY KEY (`mode_gid`) ); INSERT INTO `cor_mst_tcouriermode` (`mode_gid`, `mode_code`, `mode_name`) VALUES ('MOD001', 'SUR001', 'Surface'); INSERT INTO `cor_mst_tcouriermode` (`mode_gid`, `mode_code`, `mode_name`) VALUES ('MOD002', 'AIR002', 'Air'); INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('SSQM2405287593','CTMP','Courier Service name','4','1','N','N','N','N','N','N','','','','2024','N',NULL,NULL,NULL,NULL); CREATE TABLE `cor_tmp_tcourierorderdtl` ( `tmpcourierdtl_gid` varchar(64) NOT NULL, `box_length` varchar(64) DEFAULT NULL, `box_weight` varchar(64) DEFAULT NULL, `box_height` varchar(64) DEFAULT NULL, `box_grossweight` varchar(64) DEFAULT NULL, `box_netweight` varchar(64) DEFAULT NULL, `total_box` double DEFAULT '0', `employee_gid` varchar(64) DEFAULT NULL, `created_by` varchar(64) DEFAULT NULL, `created_date` datetime DEFAULT NULL, `updated_by` varchar(64) DEFAULT NULL, `updated_date` datetime DEFAULT NULL, PRIMARY KEY (`tmpcourierdtl_gid`)) ; INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('SSQM2405287594','CRMT','Courier Service Order','4','1','N','N','N','N','N','N','','','','2024','N',NULL,NULL,NULL,NULL); CREATE TABLE `cor_trn_tcourierorder` ( `courierorder_gid` varchar(64) NOT NULL, `courierorder_date` datetime DEFAULT NULL, `invoice_no` varchar(64) DEFAULT NULL, `courierraised_by` varchar(64) DEFAULT NULL, `courier_mode` varchar(64) DEFAULT NULL, `courier_modegid` varchar(64) DEFAULT NULL, `courier_servicegid` varchar(64) DEFAULT NULL, `courier_service` varchar(64) DEFAULT NULL, `customer_gid` varchar(64) DEFAULT NULL, `customer_name` varchar(512) DEFAULT NULL, `customer_city` varchar(512) DEFAULT NULL, `customer_state` varchar(512) DEFAULT NULL, `customer_contact_person` varchar(512) DEFAULT NULL, `customer_contactno` varchar(512) DEFAULT NULL, `customer_address` text, `Tracking_number` varchar(256) DEFAULT NULL, `eway_billnumber` varchar(256) DEFAULT NULL, `courier_remarks` longtext, `invoice_amount` varchar(64) DEFAULT '0.00', `packing_charges` varchar(64) DEFAULT '0.00', `totalgross_weight` varchar(64) DEFAULT '0.00', `totalnet_weight` varchar(64) DEFAULT NULL, `courierorder_status` varchar(32) DEFAULT NULL, `invoice_gid` varchar(64) DEFAULT NULL, `product_images` varchar(1128) DEFAULT NULL, `created_by` varchar(16) DEFAULT NULL, `created_date` datetime DEFAULT NULL, `updated_by` varchar(64) DEFAULT NULL, `updated_date` datetime DEFAULT NULL, `termsandconditions` text, PRIMARY KEY (`courierorder_gid`), KEY `Index_2` (`customer_gid`) ) ; CREATE TABLE `cor_trn_tcourierorderdtl` ( `courierorderdtl_gid` varchar(64) NOT NULL, `courierorder_gid` varchar(64) DEFAULT NULL, `tmpcourierdtl_gid` varchar(64) DEFAULT NULL, `box_length` varchar(64) DEFAULT NULL, `box_weight` varchar(64) DEFAULT NULL, `box_height` varchar(64) DEFAULT NULL, `box_grossweight` varchar(64) DEFAULT NULL, `box_netweight` varchar(64) DEFAULT NULL, `total_box` double DEFAULT '0', `employee_gid` varchar(64) DEFAULT NULL, `created_by` varchar(64) DEFAULT NULL, `created_date` datetime DEFAULT NULL, `updated_by` varchar(64) DEFAULT NULL, `updated_date` datetime DEFAULT NULL, PRIMARY KEY (`courierorderdtl_gid`)) ; INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('SSQM2405287595','CRDL','Courier DTL','4','1','N','N','N','N','N','N','','','','2024','N',NULL,NULL,NULL,NULL); INSERT INTO `adm_mst_terror` (`error_gid`,`error_code`,`error_message`,`error_type`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('COS230420240006','COR_SUC_006',' Courier Dispatched successfully','SUCCESS',NULL,NULL,NULL,NULL); CREATE TABLE `cor_trn_tcourierdelivery` ( `courierdelivery_gid` varchar(64) NOT NULL, `courierorder_gid` varchar(64) DEFAULT NULL, `invoice_no` varchar(64) DEFAULT NULL, `Tracking_number` varchar(64) DEFAULT NULL, `courierorder_date` datetime DEFAULT NULL, `delivered_date` datetime DEFAULT NULL, `delivery_remarks` varchar(64) DEFAULT NULL, `created_by` varchar(64) DEFAULT NULL, `created_date` datetime DEFAULT NULL, `updated_by` varchar(64) DEFAULT NULL, `updated_date` datetime DEFAULT NULL, PRIMARY KEY (`courierdelivery_gid`)) ; INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('SSQM2405287596','CODC','Courier Delivery','4','1','N','N','N','N','N','N','','','','2024','N',NULL,NULL,NULL,NULL); INSERT INTO `adm_mst_terror` (`error_gid`,`error_code`,`error_message`,`error_type`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('COS230420240009','COR_SUC_006','Courier Delivered Successfully','Success',NULL,NULL,NULL,NULL); INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('SSQM240531596','DIRECT','Courier DTL','4','1','N','N','N','N','N','N','','','','2024','N',NULL,NULL,NULL,NULL); INSERT INTO `adm_mst_terror` (`error_gid`,`error_code`,`error_message`,`error_type`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('COS230420240008','COR_SUC_008',' Direct Courier Dispatched successfully','SUCCESS',NULL,NULL,NULL,NULL); INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('SSQM2406303597','CRIM','Courier image','4','1','N','N','N','N','N','N','','','','2024','N',NULL,NULL,NULL,NULL); CREATE TABLE `cor_trn_timgcourierorder` ( `imgcourierorder_gid` varchar(64) NOT NULL, `courierorder_gid` varchar(64) DEFAULT NULL, `product_images` varchar(1128) DEFAULT NULL, `created_by` varchar(64) DEFAULT NULL, `created_date` datetime DEFAULT NULL, `updated_by` varchar(64) DEFAULT NULL, `updated_date` datetime DEFAULT NULL, PRIMARY KEY (`imgcourierorder_gid`)) ; ALTER TABLE cor_mst_tcourierservcice ADD COLUMN air_ratio varchar(256) default null; ALTER TABLE cor_mst_tcourierservcice ADD COLUMN surface_ratio varchar(256) default null; CREATE TABLE `cor_trn_tcourierassignmode` ( `couriermode_gid` varchar(16) NOT NULL DEFAULT '', `mode_gid` varchar(128) DEFAULT NULL, `courierservcice_gid` varchar(128) DEFAULT NULL, `created_by` varchar(64) DEFAULT NULL, `created_date` datetime DEFAULT NULL, `updated_by` varchar(64) DEFAULT NULL, `updated_date` datetime DEFAULT NULL, PRIMARY KEY (`couriermode_gid`) ) ; INSERT INTO `adm_mst_terror` (`error_gid`,`error_code`,`error_message`,`error_type`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('COS230420240009','COR_SUC_009',' Select atleast one Mode !','WARNING',NULL,NULL,NULL,NULL); INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('SSQM2406303598','CRSM','Courier Mode Service','4','1','N','N','N','N','N','N','','','','2024','N',NULL,NULL,NULL,NULL); ALTER TABLE cor_trn_tcourierorder ADD COLUMN in_person varchar(64) default null; ALTER TABLE cor_trn_tcourierorder ADD COLUMN courier_charges VARCHAR(64);