23/07/2024
alter table hrm_mst_tbranch
add column wacatalouge_id varchar(120);

alter table hrm_mst_tbranch
add column wachannel_id varchar(120);

alter table hrm_mst_tbranch
add column waworkspace_id varchar(120);

alter table hrm_mst_tbranch
add column waaccess_token longtext;

alter table hrm_mst_tbranch
add column bird_token varchar(128) default null after wachannel_id;

alter table hrm_mst_tbranch
add column cart_status char(1) default'Y';

alter table hrm_mst_tbranch
add column meta_phone_id varchar(64);

alter table hrm_mst_tbranch
add column waphone_number varchar(24);

alter table hrm_mst_tbranch
add column manager_number varchar(24);

alter table otl_trn_branch2product
add column whatsapp_id varchar(64)  DEFAULT 'null';

alter table otl_trn_branch2product
add column whatsappstock_status char(1) default 'Y';

alter table otl_trn_branch2product
add column whatsappproduct_updatedby varchar(64)DEFAULT NULL;

alter table otl_trn_branch2product
add column stripe_price_gid varchar(240)DEFAULT NULL;

alter table pmr_mst_tproduct
add column stripe_price_gid varchar(240)DEFAULT NULL;

alter table pmr_mst_tproduct
add column whatsappproduct_updatedby varchar(64) DEFAULT NULL;

alter table pmr_mst_tproduct
add column whatsapp_id varchar(64) DEFAULT NULL;

alter table pmr_mst_tproduct
add column whatsappstock_status  char(1) DEFAULT 'Y';

///////////////////////////////////////KOT SCRIPTS//////////////////////////////////////


CREATE TABLE `otl_trn_tkot` (
  `kot_gid` varchar(64) NOT NULL,
  `order_id` varchar(64) NOT NULL,
  `branch_gid` varchar(64) DEFAULT NULL,
  `line_items_total` double DEFAULT '0',
  `kot_tot_price` double DEFAULT '0',
  `customer_phone` varchar(120) DEFAULT NULL,
  `contact_id` varchar(124) DEFAULT NULL,
  `kot_delivery_charges` double DEFAULT '0',
  `source` char(1) DEFAULT NULL,
  `message_id` varchar(124) DEFAULT NULL,
  `order_type` varchar(10) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(64) DEFAULT NULL,
  `payment_status` varchar(64) DEFAULT 'Pending',
  `payment_message` char(1) DEFAULT 'N',
  `manager_message` char(1) DEFAULT 'N',
  `address` varchar(850) DEFAULT NULL,
  `orderstatus` char(1) DEFAULT 'P',
  `order_eta` varchar(20) DEFAULT NULL,
  `eta_time` time DEFAULT NULL,
  `order_instructions` varchar(2048) DEFAULT NULL,
  `salesorder_gid` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`kot_gid`)
) ;

CREATE TABLE `otl_trn_tkotdtl` (
  `kotdtl_gid` varchar(64) NOT NULL,
  `kot_gid` varchar(64) NOT NULL,
  `kot_product_gid` varchar(64) NOT NULL,
  `kot_product_price` double DEFAULT '0',
  `product_quantity` int(10) DEFAULT '0',
  `product_amount` double DEFAULT '0',
  `currency` varchar(5) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`kotdtl_gid`)
);

31/07/2024
delete from adm_mst_tmoduleangular where module_gid='SMRWHPBR';

alter table otl_trn_branch2product
add column whatsapp_price varchar (20) default null;
///////////////////////////////////////KOT SCRIPTS//////////////////////////////////////


CREATE TABLE `otl_trn_tkot` (
  `kot_gid` varchar(64) NOT NULL,
  `order_id` varchar(64) NOT NULL,
  `branch_gid` varchar(64) DEFAULT NULL,
  `line_items_total` double DEFAULT '0',
  `kot_tot_price` double DEFAULT '0',
  `customer_phone` varchar(120) DEFAULT NULL,
  `contact_id` varchar(124) DEFAULT NULL,
  `kot_delivery_charges` double DEFAULT '0',
  `source` char(1) DEFAULT NULL,
  `message_id` varchar(124) DEFAULT NULL,
  `order_type` varchar(10) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(64) DEFAULT NULL,
  `payment_status` varchar(64) DEFAULT 'Pending',
  `payment_link` varchar(240) DEFAULT NULL,
  `payment_message` char(1) DEFAULT 'N',
  `manager_message` char(1) DEFAULT 'N',
  `address` varchar(850) DEFAULT NULL,
  `orderstatus` char(1) DEFAULT 'P',
  `order_eta` varchar(20) DEFAULT NULL,
  `eta_time` time DEFAULT NULL,
  `order_instructions` varchar(2048) DEFAULT NULL,
  `salesorder_gid` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`kot_gid`)
) 

CREATE TABLE `otl_trn_tkotdtl` (
  `kotdtl_gid` varchar(64) NOT NULL,
  `kot_gid` varchar(64) NOT NULL,
  `kot_product_gid` varchar(64) NOT NULL,
  `kot_product_price` double DEFAULT '0',
  `product_quantity` int(10) DEFAULT '0',
  `product_amount` double DEFAULT '0',
  `currency` varchar(5) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`kotdtl_gid`)
) ;

///////////////////t module//////////////////////////////////////////
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`,`shopify_flag`,`k_sref`) VALUES ('KOTFDWAO','KOTWAS','KOTWAO',1,'ems_kot/KotTrnTfrontdeskorders.aspx#',2,NULL,'Front Desk WhatsApp Order Summary','1','','WhatsApp Order','','Front Desk WhatsApp Order Summary','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,'/kot/KotTrnTfrontdeskorders');
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`,`shopify_flag`,`k_sref`) VALUES ('KOTWAO','KOTWAS','KOTWAO',1,'ems_kot/KotTrnWhatsapporders.aspx#',2,NULL,'Whatsapp Order','1','','WhatsApp Order','','WhatsApp Order Summary','','','','N','N',NULL,NULL,NULL,NULL,'Y','',NULL,NULL,'/kot/KotTrnWhatsapporders');


INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('KOTFDWAO','KOTWAS','KOTWAO',1,'ems_kot/KotTrnTfrontdeskorders.aspx#',2,NULL,'Front Desk Whatsapp Orders','1','','WhatsApp Order','','Front Desk WhatsApp Order Summary','','','','N','Y',NULL,NULL,NULL,NULL,'Y','',NULL,NULL,NULL,'/kot/KotTrnTfrontdeskorders\n');
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('KOTWAO','KOTWAS','KOTWAO',1,'ems_kot/KotTrnWhatsapporders.aspx#',2,NULL,'Whatsapp Order','1','','WhatsApp Order','','WhatsApp Order Summary','','','','N','Y',NULL,NULL,NULL,NULL,'Y','',NULL,NULL,NULL,'/kot/KotTrnWhatsapporders');
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SMR','$','SMR',3,'ems_crm/crm_trn_dashboard.aspx#',1,3,'Sales','1','','','E1','Sales','','','','N','Y',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SMRMST','SMR','SMRMST',1002,'ems_crm/crm_transaction.aspx#',2,NULL,'Master','1','../images/Settings.gif','','','Master','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SMRMSTTXDT','SMRMST','SMRMSTTXDT',1305,'ems_crm/crm_mst_productsummary.aspx',3,NULL,'Product','1','../images/ICO_ADDPRODUC_RS.gif','PRODUCT MANAGEMENT','','Product','','','','N','N',NULL,NULL,NULL,NULL,'Y','/smr/SmrMstProductSummary',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SMRSMR','SMR','SMRSMR',1005,'ems_crm/crm_transaction.aspx#',2,NULL,'Sales','1','','','','Sales','','','','N','Y',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SMRWHOR','SMRSMR','SMRWHOR',1601,'ems_crm/crm_trn_whatappordersummary.aspx',3,NULL,'Whatsapp Orders','1',NULL,'Sales',NULL,'Whatsapp Orders',NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','outlet/OtlTrnWhatsAppOrderSummary',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SMRWHPDT','SMRMST','SMRWHPDT',1304,'ems_crm/crm_mst_whatsapproductsummary.aspx',3,NULL,'Whatsapp Product','1','../images/ICO_ADDPRODUC_RS.gif','PRODUCT MANAGEMENT',NULL,'Whatsapp Product',NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/smr/SmrMstWhatsappproductsummary',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SMRWHPPM','SMRMST','SMRWHPPM',1305,'ems_crm/crm_mst_whatsapproductpricemanagement.aspx',3,NULL,'Branch  Management','1',NULL,'PRODUCT MANAGEMENT',NULL,'Branch  Management',NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/smr/SmrMstWhatsappproductpricemanagement',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SYS','$','SYS',1,'ems_system/system_transaction.aspx#',1,3,'Systems','1','','','SERM24050645','Systems','','','','N','Y',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SYSRPT','SYS','SYSRPT',3,'ems_system/system_transaction.aspx#',2,NULL,'Report','1','','','','Report','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SYSRPTEMR','SYSRPT','SYSRPTEMR',3,'ems_system/sys_rpt_employeereport.aspx',3,NULL,'Employee Report','1','../images/ico_employee_summary_RS.gif','','','Employee Report','','','','N','N',NULL,NULL,NULL,NULL,'Y','/system/SysRptEmployeereport',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SYSSET','SYS','SYSSET',1,'ems_system/system_transaction.aspx#',2,NULL,'Settings','1','../images/Settings.gif','SETTINGS','','Settings','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SYSSETCOM','SYSSET','SYSSETCOM',2,'ems_system/sys_mst_company.aspx',3,NULL,'Company','1','../images/ICO_RAISE_INVOICE_RS.png','SETTINGS','','Company','','','','N','N',NULL,NULL,NULL,NULL,'Y','/system/SysMstCompany',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SYSSETMDA','SYSSET','SYSSETMDA',3,'ems_system/sys_mst_moduleassign.aspx',3,NULL,'Module Manager','1','../images/module_icon_RS.gif','SETTINGS','','Module Manager','','','','N','N',NULL,NULL,NULL,NULL,'Y','/system/SysMstModuleManager',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SYSTRN','SYS','SYSTRN',2,'ems_system/system_transaction.aspx#',2,NULL,'Master','1','../images/Settings.gif','SETTINGS','','Master','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SYSTRNBRH','SYSTRN','SYSTRNBRH',2,'ems_system/sys_mst_branchsummary.aspx',3,NULL,'Branch','1','../images/ico_department_RS.gif','ORGANISATION','','Branch','','','','N','N',NULL,NULL,NULL,NULL,'Y','/system/SysMstBranch/',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SYSTRNDES','SYSTRN','SYSTRNDES',4,'ems_system/sys_mst_designationsummary.aspx',3,NULL,'Designation','1','../images/ico_designation_RS.gif','ORGANISATION','','Designation','','','','N','N',NULL,NULL,NULL,NULL,'Y','/system/SysMstDesignation/',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SYSTRNDPT','SYSTRN','SYSTRNDPT',3,'ems_system/sys_mst_departmentsummary.aspx',3,NULL,'Department','1','../images/ico_departmentn_RS.png','ORGANISATION','','Department','','','','N','N',NULL,NULL,NULL,NULL,'Y','/system/SysMstDepartment/',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SYSTRNEMP','SYSTRN','SYSTRNEMP',7,'ems_system/sys_mst_employeesummary.aspx',3,NULL,'Employee','1','../images/ico_add_employee_RS.gif','WORK FORCE','','Employee','','','','N','N',NULL,NULL,NULL,NULL,'Y','/system/SysMstEmployeeSummary',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SYSTRNENT','SYSTRN','SYSTRNENT',0,'ems_system/sys_mst_entitysummary.aspx',3,3,'Entity','1','../images/ico_department_RS.gif','ORGANISATION','','Entity','','','','N','N',NULL,NULL,NULL,NULL,'Y','/system/SysMstEntitySummary',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SYSTRNEPP','SYSTRN','SYSTRNEPP',9,'ems_system/sys_mst_employeeprofile.aspx',3,NULL,'Employee Profile','1','../images/ico_employee_summary_RS.gif','WORK FORCE','','Employee Profile','','','','N','N',NULL,NULL,NULL,NULL,'Y','/hrm/Employeeprofile',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SYSTRNTMP','SYSTRN','SYSTRNTMP',14,'ems_system/sys_mst_templatesummary.aspx',3,NULL,'Template ','1','','','','Template','','','','N','N',NULL,NULL,NULL,NULL,'Y','/system/SysMstTemplate',NULL,NULL,NULL,NULL);

07/08/2024

alter table adm_mst_tcompany
add column key1 varchar(120) DEFAULT NULL;

alter table adm_mst_tcompany
add column key2 varchar(120) DEFAULT NULL;

alter table adm_mst_tcompany
add column payment_gateway varchar(12) DEFAULT NULL;

16/08/2024
1.tmoduleangular -for kot only   

INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SMRMSTTXDG','SMRMST','SMRMSTTXDG',1301,'ems_crm/crm_mst_productgroupsummary.aspx',3,NULL,'Product Group','1','../images/ico_product_group_RS.gif','PRODUCT MANAGEMENT','','Product Group','','','','N','N',NULL,NULL,NULL,NULL,'Y','/smr/SmrMstProductGroup',NULL,NULL,NULL,NULL);


2.tmoduleangular -common for all db 

INSERT INTO `adm_mst_tmoduleangular` (`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`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('SMRHMP','SMRMST','SMRHMP',1307,'ems_crm/crm_mst_homepage.aspx',3,NULL,'Home Page','1',NULL,'Home Page',NULL,'Home Page',NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/auth/HomePage',NULL,NULL,NULL,NULL);

 3.alter table-common for all db

alter table hrm_mst_temployee
add column home_page char(1) Default'N';

27/08/2024-Pathmanaban

alter table otl_trn_tkot
drop column orderstatus;

alter table otl_trn_tkot
add column kitchen_status char(1) default 'P' after address;

alter table otl_trn_tkot
add column order_status varchar(64) default 'PENDING' after branch_gid;

alter table otl_trn_tkot
add column payment_method varchar(64) default 'ONLINE' after order_type;

alter table otl_trn_tkot
drop column payment_status;

alter table otl_trn_tkot
add column payment_status varchar(64) default 'PENDING' after payment_method;

alter table otl_trn_tkotdtl
modify column kotdtl_gid int auto_increment first;