37PuUPB5

1DELETE FROM menumst WHERE menu_no='1600' AND menu_refno1='1l-30' AND menu_refno2='root';/*Hotel Level 1*/
2INSERT INTO menumst(menu_no, menu_level, menu_refno1, menu_refno2, menu_page_no, menu_name, menu_name1, menu_htmlspecial, menu_sorting, menu_activation, menu_groups_allow, activation_flag, activation_default) 
3VALUES('1600', '1', '1l-30', 'root', NULL,'{stxtMenuHotel}', '{stxtMenuHotel}', NULL, '1l-30', '', '0,1,2,3,4,5,6,7,8,9,10', '1', '0');
4
5DELETE FROM menumst WHERE menu_no='1600' AND menu_refno1='2l-30' AND menu_refno2='1l-30';/*Hotel Master Level 2*/
6INSERT INTO menumst(menu_no, menu_level, menu_refno1, menu_refno2, menu_page_no, menu_name, menu_name1, menu_htmlspecial, menu_sorting, menu_activation, menu_groups_allow, activation_flag, activation_default) 
7VALUES('1600', '2', '2l-30', '1l-30', NULL,'{stxtMenuMasterFile}', '{stxtMenuMasterFile}', NULL, '2l-30', '', '0,1,2,3,4,5,6,7,8,9,10', '1', '0');
8
9DELETE FROM menumst WHERE menu_no='1600' AND menu_refno1='3l-160-30' AND menu_refno2='2l-30';/*Hotel Master Level 3*/
10INSERT INTO menumst(menu_no, menu_level, menu_refno1, menu_refno2, menu_page_no, menu_name, menu_name1, menu_htmlspecial, menu_sorting, menu_activation, menu_groups_allow, activation_flag, activation_default) 
11VALUES('1600', '3', '3l-160-30', '2l-30', 'master_hotelmst_list.php','{stxtMenuHotel}', '{stxtMenuHotel}', '<a {nllauthACC_IMAGELINK_ACCOUNTMST_ADDMASTERLINK} style=`cursor:hand` onclick=`javascript:parent.parent.changeframe(this.name1,this.name2)` name1=`master_hotelmst_maint.php` name2=`{stxtMenuHotel}` ><img alt=`{stxtMenuHotel}` width=`12` height=`12` src=`image/add5.jpg`></a><a style=`cursor:hand` onclick=`javascript:parent.parent.changeframe(this.name1,this.name2)` name1=`master_hotelmst_list.php` name2=`{stxtMenuHotel}` ><em>{stxtMenuList}</em></a><a style=`cursor:hand` onclick=`javascript:parent.parent.changeframe(this.name1,this.name2)` name1=`modules/xeersoft_dynamic/xeersoft_inv_report_qr.php?menu=1&qrID=2222&page=../../menu_dynamic.php%253Fmenu_no=1230%2526menu_key=1|-123%2526menu_name=Area` name2=`Hotel` >|<em>{stxtAdvancedList123}</em></a>', '3l-30', '', '0,1,2,3,4,5,6,7,8,9,10', '1', '0');
12
13
14SELECT * FROM xeersoft_batch_parameters WHERE id=1500;
15SELECT * FROM xeersoft_batch_parameters WHERE id=10 AND TYPE=4;
16
17DELETE FROM xeersoft_batch_parameters WHERE id = '1500' && TYPE = '2';
18INSERT INTO xeersoft_batch_parameters (id, TYPE, sequence, sort, NAME, innertype, description, compulsary, FUNCTION, option1, option2, option3, option4, user_option, active, xbp_groups_allow, xbp_users_allow, xbp_users_deny) VALUES (1500,2,1,10,'Hotel Code','View','Hotel Code',0,'unset($param);$param["arg1"]=$hotel_code;','hotel_code',NULL,NULL,NULL, NULL,NULL,NULL,NULL, NULL);
19INSERT INTO xeersoft_batch_parameters (id, TYPE, sequence, sort, NAME, innertype, description, compulsary, FUNCTION, option1, option2, option3, option4, user_option, active, xbp_groups_allow, xbp_users_allow, xbp_users_deny) VALUES (1500,2,2,20,'Hotel Name1','View','Hotel Name1',0,'unset($param);$param["arg1"]=$hotel_name1;','hotel_name1',NULL,NULL,NULL, NULL,NULL,NULL,NULL, NULL);
20INSERT INTO xeersoft_batch_parameters (id, TYPE, sequence, sort, NAME, innertype, description, compulsary, FUNCTION, option1, option2, option3, option4, user_option, active, xbp_groups_allow, xbp_users_allow, xbp_users_deny,xbp_tables) VALUES (1500,2,3,30,'Hotel State','View','Hotel State',0,'unset($param);$param["arg1"]=$stte_name1;','stte_name1',NULL,NULL,NULL, NULL,NULL,NULL,NULL, NULL,'statemst');
21INSERT INTO xeersoft_batch_parameters (id, TYPE, sequence, sort, NAME, innertype, description, compulsary, FUNCTION, option1, option2, option3, option4, user_option, active, xbp_groups_allow, xbp_users_allow, xbp_users_deny) VALUES (1500,2,4,40,'Hotel Category','View','Hotel Category',0,'unset($param);$param["arg1"]=$hotel_category;','hotel_category',NULL,NULL,NULL, NULL,NULL,NULL,NULL, NULL);
22INSERT INTO xeersoft_batch_parameters (id, TYPE, sequence, sort, NAME, innertype, description, compulsary, FUNCTION, option1, option2, option3, option4, user_option, active, xbp_groups_allow, xbp_users_allow, xbp_users_deny) VALUES (1500,2,5,50,'Hotel Off Tel','View','Hotel Off Tel',0,'unset($param);$param["arg1"]=$hotel_off_tel;','hotel_off_tel',NULL,NULL,NULL, NULL,NULL,NULL,NULL, NULL);
23
24INSERT INTO xeersoft_batch_parameters (id, TYPE, sequence, sort, NAME, innertype, description, compulsary, FUNCTION, option1, option2, option3, option4, user_option, active, xbp_groups_allow, xbp_users_allow, xbp_users_deny) VALUES (1500,2,6,60,'Total','View','Total',0,'unset($param);$param["arg1"]=$total;','total',NULL,NULL,NULL, NULL,NULL,NULL,NULL, NULL);
25
26
27DELETE FROM xeersoft_batch_parameters WHERE id=1500 AND TYPE=4;
28INSERT INTO `xeersoft_batch_parameters` (id,TYPE,sequence,sort,NAME,innertype,description,compulsary,FUNCTION,option1,option2,option3,option4,active,xbp_groups_allow,xbp_users_allow,xbp_users_deny, redirect_location) VALUES (1500, '4', 1, 10, 'HotelListing', '', 'Hotel Listing', 0, 
29" DROP TABLE IF EXISTS {tmpTable0} ;
30DROP TABLE IF EXISTS {tmpTable1} ;
31CREATE TEMPORARY TABLE {tmpTable1}
32SELECT hotel_no,hotel_code as hotel_code, hotel_name1 as hotel_name1, hotel_off_tel as hotel_off_tel, COUNT(hotel_state)as total, hotel_state, hotel_category, {strGroup_SQLName_Group1}
33/*dynTable_statemst_col*/
34FROM hotelmst
35/*dynTable_statemst_join*/
36{strWhere} GROUP BY {strGroup_SQLGroup_Group1};
37CREATE TEMPORARY TABLE finaltable SELECT {strGroup_SQLGroup_Group1}, {str_viewColumns} FROM {tmpTable1}; 
38; ", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, "../../menu_dynamic.php?menu_no=1600&menu_key=1l-30&menu_name={stxtMenuHotel}");
39
40DELETE FROM xeersoft_batch_parameters WHERE TYPE=1 AND id = 1500;
41INSERT INTO `xeersoft_batch_parameters`(id,TYPE,sequence,sort,NAME,innertype,description,compulsary,FUNCTION,option1,option2,option3,option4,active,xbp_groups_allow,xbp_users_allow,xbp_users_deny) VALUES(1500,"1",1,10,"HotelCodeFrom","Selectbox","Hotel From",0,"select hotel_code, concat(hotel_code,': ',hotel_name1) from hotelmst order by hotel_code asc ;","HotelCodeFrom","hotelmst.hotel_code >='$HotelCodeFrom'",NULL,NULL,NULL,NULL,NULL,NULL);
42INSERT INTO `xeersoft_batch_parameters`(id,TYPE,sequence,sort,NAME,innertype,description,compulsary,FUNCTION,option1,option2,option3,option4,active,xbp_groups_allow,xbp_users_allow,xbp_users_deny) VALUES(1500,"1",2,20,"HotelCodeTo","Selectbox","Hotel To",0,"select hotel_code, concat(hotel_code,': ',hotel_name1) from  hotelmst order by hotel_code desc ;","HotelCodeTo","hotelmst.hotel_code <= '$HotelCodeTo'",NULL,NULL,NULL,NULL,NULL,NULL);
43INSERT INTO `xeersoft_batch_parameters`(id,TYPE,sequence,sort,NAME,innertype,description,compulsary,FUNCTION,option1,option2,option3,option4,active,xbp_groups_allow,xbp_users_allow,xbp_users_deny,xbp_tables) VALUES(1500,"1",3,30,"StateCodeFrom","Selectbox","{stxtStateFrom}",0,"select stte_code, concat(stte_code,': ',stte_name1) from statemst order by stte_code asc ;","StateCodeFrom","statemst.stte_code >='$StateCodeFrom'",NULL,NULL,NULL,NULL,NULL,NULL,'statemst');
44INSERT INTO `xeersoft_batch_parameters`(id,TYPE,sequence,sort,NAME,innertype,description,compulsary,FUNCTION,option1,option2,option3,option4,active,xbp_groups_allow,xbp_users_allow,xbp_users_deny,xbp_tables) VALUES(1500,"1",4,40,"StateCodeTo","Selectbox","{stxtStateTo}",0,"select stte_code, concat(stte_code,': ',stte_name1) from  statemst order by stte_code desc ;","StateCodeTo","statemst.stte_code <= '$StateCodeTo'",NULL,NULL,NULL,NULL,NULL,NULL,'statemst');
45INSERT INTO `xeersoft_batch_parameters`(id,TYPE,sequence,sort,NAME,innertype,description,compulsary,FUNCTION,option1,option2,option3,option4,active,xbp_groups_allow,xbp_users_allow,xbp_users_deny) VALUES(1500,"1",5,50,"HotelCategoryFrom","Selectbox","Category From",0,"select hotel_category from hotelmst order by hotel_category asc ;","HotelCategoryFrom","hotelmst.hotel_category >='$HotelCategoryFrom'",NULL,NULL,NULL,NULL,NULL,NULL);
46INSERT INTO `xeersoft_batch_parameters`(id,TYPE,sequence,sort,NAME,innertype,description,compulsary,FUNCTION,option1,option2,option3,option4,active,xbp_groups_allow,xbp_users_allow,xbp_users_deny) VALUES(1500,"1",6,60,"HotelCategoryTo","Selectbox","Category To",0,"select hotel_category from  hotelmst order by hotel_category desc ;","HotelCategoryTo","hotelmst.hotel_category <= '$HotelCategoryTo'",NULL,NULL,NULL,NULL,NULL,NULL);
47
48INSERT INTO `xeersoft_batch_parameters` (`id`, `type`, `sequence`, `sort`, `name`, `innertype`, `description`, `compulsary`, `function`, `option1`, `option2`, `option3`, `option4`, `user_option`, `width`, `active`, `xbp_groups_allow`, `xbp_users_allow`, `xbp_users_deny`, `xbp_tables`, `redirect_location`) VALUES('1500','1','7','70','HotelSelection','multipleselectbox','Hotel','0',"select hotel_no, concat(hotel_code,': ',hotel_name1) from hotelmst order by hotel_no asc ;",'HotelSelection','(hotel_no IN ($HotelSelection) OR hotel_no IS NULL or hotel_no =\'\')',NULL,NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL);
49INSERT INTO `xeersoft_batch_parameters` (`id`, `type`, `sequence`, `sort`, `name`, `innertype`, `description`, `compulsary`, `function`, `option1`, `option2`, `option3`, `option4`, `user_option`, `width`, `active`, `xbp_groups_allow`, `xbp_users_allow`, `xbp_users_deny`, `xbp_tables`, `redirect_location`) VALUES('1500','1','8','80','StateSelection','multipleselectbox','{stxtState}','0',"select stte_no, concat(stte_code,': ',stte_name1) from statemst order by stte_no asc ;",'StateSelection','(stte_no IN ($StateSelection) OR stte_no IS NULL or stte_no =\'\')',NULL,NULL,NULL,'0','0',NULL,NULL,NULL,'statemst',NULL);
50INSERT INTO `xeersoft_batch_parameters` (`id`, `type`, `sequence`, `sort`, `name`, `innertype`, `description`, `compulsary`, `function`, `option1`, `option2`, `option3`, `option4`, `user_option`, `width`, `active`, `xbp_groups_allow`, `xbp_users_allow`, `xbp_users_deny`, `xbp_tables`, `redirect_location`) VALUES('1500','1','9','90','HotelCategory','multipleselectbox','Category','0',"select hotel_category from hotelmst order by hotel_category asc ;",'CategorySelection','(hotel_category IN ($CategorySelection) OR hotel_category IS NULL or hotel_category =\'\')',NULL,NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL);
51
52
53DELETE FROM xeersoft_batch_parameters WHERE id=1500 AND TYPE=7 ;
54INSERT INTO `xeersoft_batch_parameters` (id,TYPE,sequence,NAME,innertype,description,compulsary,FUNCTION,option1,option2,option3,option4,active,xbp_groups_allow,xbp_users_allow,xbp_users_deny) 
55VALUES (1500, '7', 1, 'hotelmst', 'Tables', 'hotelmst', 0, 'dynTable_statemst_col== ,concat(statemst.stte_code,\' : \',statemst.stte_name1)AS stte_name1;;;dynTable_statemst_join== LEFT JOIN statemst ON hotelmst.hotel_state = statemst.stte_no ', '','', '', '', 0, NULL, NULL, NULL);
56
57DELETE FROM xeersoft_batch_parameters WHERE id=1500 AND TYPE=9 ;
58INSERT INTO `xeersoft_batch_parameters` (id,TYPE,sequence,sort,NAME,innertype,description,compulsary,FUNCTION,option1,option2,option3,option4,active,xbp_groups_allow,xbp_users_allow,xbp_users_deny,xbp_tables) 
59VALUES (1500, 9, 1,1, 'State', 'GroupBy', 'State', 0, 'hotel_state', '','', '', '', 1, NULL, NULL, NULL,'statemst');
60INSERT INTO `xeersoft_batch_parameters` (id,TYPE,sequence,sort,NAME,innertype,description,compulsary,FUNCTION,option1,option2,option3,option4,active,xbp_groups_allow,xbp_users_allow,xbp_users_deny,xbp_tables) 
61VALUES (1500, 9, 2,20, 'Category', 'GroupBy', 'Category', 0, 'hotel_category', '','', '', '', 1, NULL, NULL, NULL,'hotelmst');
62INSERT INTO `xeersoft_batch_parameters` (id,TYPE,sequence,sort,NAME,innertype,description,compulsary,FUNCTION,option1,option2,option3,option4,active,xbp_groups_allow,xbp_users_allow,xbp_users_deny,xbp_tables) 
63VALUES (1500, 9, 3,30, 'Hotel', 'GroupBy', 'Hotel', 0,'hotel_code,,hotel_name1', '','', '', '', 1, NULL, NULL, NULL,'hotelmst');
64INSERT INTO `xeersoft_batch_parameters` (id,TYPE,sequence,sort,NAME,innertype,description,compulsary,FUNCTION,option1,option2,option3,option4,active,xbp_groups_allow,xbp_users_allow,xbp_users_deny,xbp_tables) 
65VALUES (1500, 9, 4,40, 'Hotel Code', 'GroupBy', 'Hotel Code', 0,'hotel_code', '','', '', '', 1, NULL, NULL, NULL,'hotelmst');
66INSERT INTO `xeersoft_batch_parameters` (id,TYPE,sequence,sort,NAME,innertype,description,compulsary,FUNCTION,option1,option2,option3,option4,active,xbp_groups_allow,xbp_users_allow,xbp_users_deny,xbp_tables) 
67VALUES (1500, 9, 5,50, 'Hotel Name', 'GroupBy', 'Hotel Name', 0,'hotel_name1', '','', '', '', 1, NULL, NULL, NULL,'hotelmst');
68
69
70DELETE FROM xeersoft_batch_parameters WHERE TYPE=5 AND id =1500;
71INSERT INTO `xeersoft_batch_parameters` (id, TYPE, sequence, NAME, innertype, description, compulsary, FUNCTION, option1, option2, option3, option4, active, xbp_groups_allow, xbp_users_allow, xbp_users_deny) VALUES(1500, "5", 1, "Group By", "Group", "", 1, " Hotel State=hotelmst.hotel_name1","Group1", NULL,NULL,NULL,NULL,NULL,NULL,NULL); 
72
73
74ALTER TABLE hotelmst ADD COLUMN hotel_sys_last_mod_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Last Modified Date|||' ; 
75ALTER TABLE hotelmst ADD COLUMN hotel_sys_last_mod_user INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last Modified User|||SELECT user_login FROM usermst WHERE user_no="{field_no}" LIMIT 1' ; 
76ALTER TABLE hotelmst ADD COLUMN hotel_sys_delete_flag CHAR(1) NOT NULL DEFAULT 0 COMMENT 'Delete Flag|||' ;