edMTjNHa

1SELECT * FROM xeersoft_batch_parameters WHERE id=1500;
2SELECT * FROM xeersoft_batch_parameters WHERE id=10 AND TYPE=4;
3
4DELETE FROM xeersoft_batch_parameters WHERE id = '1500' && TYPE = '2';
5INSERT 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);
6INSERT 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);
7INSERT 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');
8INSERT 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);
9INSERT 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);
10
11INSERT 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);
12
13
14DELETE FROM xeersoft_batch_parameters WHERE id=1500 AND TYPE=4;
15INSERT 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, 
16" DROP TABLE IF EXISTS {tmpTable0} ;
17DROP TABLE IF EXISTS {tmpTable1} ;
18
19CREATE TEMPORARY TABLE {tmpTable1} 
20SELECT hotel_no,hotel_code as hotel_code, hotel_name1 as hotel_name1,hotel_name2 as hotel_name2, hotel_state as hotel_state, hotel_sorting as hotel_sorting, hotel_flag as hotel_active, hotel_status as hotel_status, hotel_userdefine1 as userdefine1, hotel_userdefine2 as userdefine2,hotel_userdefine3 as userdefine3,
21hotel_userdefine4 as userdefine4,hotel_userdefine5 as userdefine5,hotel_userdefine6 as userdefine6, hotel_userdefine7 as userdefine7, hotel_userdefine8 as userdefine8,
22hotel_userdefine9 as userdefine9,hotel_userdefine10 as userdefine10
23/*dynTable_statemst_col*/
24FROM hotelmst
25/*dynTable_statemst_join*/		
26{strWhere};
27CREATE TEMPORARY TABLE finaltable SELECT {str_viewColumns} FROM {tmpTable1}  
28; ", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, "../../menu_dynamic.php?menu_no=1600&menu_key=1l-30&menu_name={stxtMenuHotel}");
29
30DELETE FROM xeersoft_batch_parameters WHERE TYPE=1 AND id = 1500;
31INSERT 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);
32INSERT 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);
33INSERT 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');
34INSERT 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');
35INSERT 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);
36INSERT 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);
37
38INSERT 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);
39INSERT 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);
40INSERT 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);
41
42
43DELETE FROM xeersoft_batch_parameters WHERE id=1500 AND TYPE=7 ;
44INSERT 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) 
45VALUES (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);
46
47DELETE FROM xeersoft_batch_parameters WHERE id=1500 AND TYPE=9 ;
48INSERT 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) 
49VALUES (1500, 9, 1,1, 'State', 'GroupBy', 'State', 0, 'hotel_state', '','', '', '', 1, NULL, NULL, NULL,'statemst');
50INSERT 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) 
51VALUES (1500, 9, 2,20, 'Category', 'GroupBy', 'Category', 0, 'hotel_category', '','', '', '', 1, NULL, NULL, NULL,'hotelmst');
52INSERT 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) 
53VALUES (1500, 9, 3,30, 'Hotel', 'GroupBy', 'Hotel', 0,'hotel_code,,hotel_name1', '','', '', '', 1, NULL, NULL, NULL,'hotelmst');
54INSERT 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) 
55VALUES (1500, 9, 4,40, 'Hotel Code', 'GroupBy', 'Hotel Code', 0,'hotel_code', '','', '', '', 1, NULL, NULL, NULL,'hotelmst');
56INSERT 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) 
57VALUES (1500, 9, 5,50, 'Hotel Name', 'GroupBy', 'Hotel Name', 0,'hotel_name1', '','', '', '', 1, NULL, NULL, NULL,'hotelmst');
58
59
60DELETE FROM xeersoft_batch_parameters WHERE TYPE=5 AND id =1500;
61INSERT 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); 
62
63
64ALTER TABLE hotelmst ADD COLUMN hotel_sys_last_mod_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Last Modified Date|||' ; 
65ALTER 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' ; 
66ALTER TABLE hotelmst ADD COLUMN hotel_sys_delete_flag CHAR(1) NOT NULL DEFAULT 0 COMMENT 'Delete Flag|||' ;