[10/20/2020 07:42:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO room_rates (room_rate_code,rate_group,hotel_id,supplier_id,date_from,date_to,room_class,room_basis,ip_addr,room_type,view_basis,edit_time_stamp,weekend,rate_profile,entered_by,inventory_class_id,status,weekday_rate,weekend_rate,currency,minstay,availability,time_limit,checkin_block_for,exclude_countries,exclude_residence,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory,stay_note) values ('53773@S000000241@2020-10-21@2020-10-21@@1039@1@1@@@0','21-10-2020~21-10-2020','53773','S000000241','2020-10-21','2020-10-21','1039','1','60.254.42.133','0','0','fe0f9a9f26bce93bea6ea2cfe00e7660','Sa,Su','1','Supplier','132','A','91.500','91.500','AED','3','0','0','0','','','0','cf3973528ea82e6a351549b68184a5ed','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0','');
[10/20/2020 07:42:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('1929843');
[10/20/2020 07:42:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-20 07:42:31',`log_type`= 'Rates',`sql_query`= '',`log_description`= 'Inserted Rates For RateGainOne Rate:- 0 Room Category :- Standard - Single, Extrabed - 1 (Bed & Breakfast) Market :- All Market From:- 21-10-2020 To:- 25-11-2020',`ip`= '60.254.42.133',`username`= 'tfg',`user_id`= 'S000000241';
[10/20/2020 07:42:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3763', `entity`='Hotels', `value`='53773' ;
[10/20/2020 07:42:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3763', `entity`='Suppliers', `value`='S000000241' ;
[10/20/2020 07:42:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3763', `entity`='Inventory', `value`='132' ;
[10/20/2020 07:42:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3763', `entity`='Room', `value`='1039' ;
[10/20/2020 07:42:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3763', `entity`='Market', `value`='1' ;
[10/20/2020 07:42:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO room_rates (room_rate_code,rate_group,hotel_id,supplier_id,date_from,date_to,room_class,room_basis,ip_addr,room_type,view_basis,edit_time_stamp,weekend,rate_profile,entered_by,inventory_class_id,status,weekday_rate,weekend_rate,currency,minstay,availability,time_limit,checkin_block_for,exclude_countries,exclude_residence,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory,stay_note) values ('53773@S000000241@2020-10-22@2020-10-22@@1039@1@1@@@0','22-10-2020~22-10-2020','53773','S000000241','2020-10-22','2020-10-22','1039','1','60.254.42.133','0','0','65659e7dd28e10afb0fcd00a91dac10c','Sa,Su','1','Supplier','132','A','92.500','92.500','AED','3','0','0','0','','','0','6e34d92a22408c650408023f84e87dc7','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-10-23@2020-10-23@@1039@1@1@@@0','23-10-2020~23-10-2020','53773','S000000241','2020-10-23','2020-10-23','1039','1','60.254.42.133','0','0','e1dfba6ff611c27a5cb29d703b65d09a','Sa,Su','1','Supplier','132','A','93.500','93.500','AED','3','0','0','0','','','0','1695889c1461b6c975ef1968653f48df','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-10-24@2020-10-24@@1039@1@1@@@0','24-10-2020~24-10-2020','53773','S000000241','2020-10-24','2020-10-24','1039','1','60.254.42.133','0','0','90ac254a5e264c4cf13aa3905ce26cd0','Sa,Su','1','Supplier','132','A','94.500','94.500','AED','3','0','0','0','','','0','10d810639cacb1a1831b853eece2854b','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-10-25@2020-10-25@@1039@1@1@@@0','25-10-2020~25-10-2020','53773','S000000241','2020-10-25','2020-10-25','1039','1','60.254.42.133','0','0','6dc0955d3fcaa6dc9493a61e408ba614','Sa,Su','1','Supplier','132','A','95.500','95.500','AED','3','0','0','0','','','0','1502bd7dda5bec7172f52963550e4aa5','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-10-26@2020-10-26@@1039@1@1@@@0','26-10-2020~26-10-2020','53773','S000000241','2020-10-26','2020-10-26','1039','1','60.254.42.133','0','0','d36cb7054e021edea4f76b9cbdfc513f','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','80a7bff8ea5e77eb44aec61a1059b2f5','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-10-27@2020-10-27@@1039@1@1@@@0','27-10-2020~27-10-2020','53773','S000000241','2020-10-27','2020-10-27','1039','1','60.254.42.133','0','0','78dd8a116786567ace052120468cef2a','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','7ce65affc602482bf10750eeea339d03','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-10-28@2020-10-28@@1039@1@1@@@0','28-10-2020~28-10-2020','53773','S000000241','2020-10-28','2020-10-28','1039','1','60.254.42.133','0','0','1e06f9771870b1e792f8ae1b0ec6c808','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','bc3c9a1c27d38f9f0e8c2ac1e5044dce','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-10-29@2020-10-29@@1039@1@1@@@0','29-10-2020~29-10-2020','53773','S000000241','2020-10-29','2020-10-29','1039','1','60.254.42.133','0','0','b7df5f38d85ddbc812dfc4dbed23c184','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','b26cda874bb8a53289a399de74b52e1e','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-10-30@2020-10-30@@1039@1@1@@@0','30-10-2020~30-10-2020','53773','S000000241','2020-10-30','2020-10-30','1039','1','60.254.42.133','0','0','fb2f501f52e28327de381cb5bb845a5b','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','8e934a92033abb9cbb7cb3f074ece00a','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-10-31@2020-10-31@@1039@1@1@@@0','31-10-2020~31-10-2020','53773','S000000241','2020-10-31','2020-10-31','1039','1','60.254.42.133','0','0','899399528125f7f3acc15c0eba015dde','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','1f500a1343d5ed62545b043f8d7a972b','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-01@2020-11-01@@1039@1@1@@@0','01-11-2020~01-11-2020','53773','S000000241','2020-11-01','2020-11-01','1039','1','60.254.42.133','0','0','2c2355db8d18c234776a9d6251486a5a','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','02e695274bcca74c1cb19af5a7840dec','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-02@2020-11-02@@1039@1@1@@@0','02-11-2020~02-11-2020','53773','S000000241','2020-11-02','2020-11-02','1039','1','60.254.42.133','0','0','5a4161a6efc0c5164993bbcb3238e9f2','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','1','a7e7172be298e5a1c2d78eba0ed2c649','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-03@2020-11-03@@1039@1@1@@@0','03-11-2020~03-11-2020','53773','S000000241','2020-11-03','2020-11-03','1039','1','60.254.42.133','0','0','b655f69cee910923d520c894070c9ea0','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','2d41facc82d57ca59f5bfa7add4fca68','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-04@2020-11-04@@1039@1@1@@@0','04-11-2020~04-11-2020','53773','S000000241','2020-11-04','2020-11-04','1039','1','60.254.42.133','0','0','7a404cc9708dd927c67aa66f7e8d5b07','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','1','7302010f9419163706e48bfef0a71877','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-05@2020-11-05@@1039@1@1@@@0','05-11-2020~05-11-2020','53773','S000000241','2020-11-05','2020-11-05','1039','1','60.254.42.133','0','0','9630cb96ba9f0276abd1637cdacf7f45','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','deb16c7e9c42965ac8584055d24e5ebd','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-06@2020-11-06@@1039@1@1@@@0','06-11-2020~06-11-2020','53773','S000000241','2020-11-06','2020-11-06','1039','1','60.254.42.133','0','0','272580a9c3a535dc9113d3c3c03db762','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','1','d369bfb1471d35edef57be86010899f2','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-07@2020-11-07@@1039@1@1@@@0','07-11-2020~07-11-2020','53773','S000000241','2020-11-07','2020-11-07','1039','1','60.254.42.133','0','0','31952af614ffa685c337867f8940e792','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','20','0','0','','','0','9504414106578ad253fb838af4b444b1','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-08@2020-11-08@@1039@1@1@@@0','08-11-2020~08-11-2020','53773','S000000241','2020-11-08','2020-11-08','1039','1','60.254.42.133','0','0','5226b6e4f469d679266ce4714603deff','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','20','0','0','','','1','e5808603177da9f7be145be9cd56ad66','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-09@2020-11-09@@1039@1@1@@@0','09-11-2020~09-11-2020','53773','S000000241','2020-11-09','2020-11-09','1039','1','60.254.42.133','0','0','9e7476954e061d47921cad6de8c3bf24','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','7c6bdb665216c20ea9f4334d61bd2208','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-10@2020-11-10@@1039@1@1@@@0','10-11-2020~10-11-2020','53773','S000000241','2020-11-10','2020-11-10','1039','1','60.254.42.133','0','0','7cb529fb1cd858455044cb2ac696ee19','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','1','071c965b8be8e3ae0a3b99935c175147','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-11@2020-11-11@@1039@1@1@@@0','11-11-2020~11-11-2020','53773','S000000241','2020-11-11','2020-11-11','1039','1','60.254.42.133','0','0','13991da7108d9c5669fbb368cde1aba9','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','37339a459ad3cc4f9be84e0ac8ed3450','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-12@2020-11-12@@1039@1@1@@@0','12-11-2020~12-11-2020','53773','S000000241','2020-11-12','2020-11-12','1039','1','60.254.42.133','0','0','eea8258d1e1b14853bef801bae77c13a','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','1','9f9d4f2604c911033b945466ee61fe5a','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-13@2020-11-13@@1039@1@1@@@0','13-11-2020~13-11-2020','53773','S000000241','2020-11-13','2020-11-13','1039','1','60.254.42.133','0','0','23ac83e785a0b0f3c1faed3c103e53c5','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','1340b62d4c339b286e07a05df4645ad7','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-14@2020-11-14@@1039@1@1@@@0','14-11-2020~14-11-2020','53773','S000000241','2020-11-14','2020-11-14','1039','1','60.254.42.133','0','0','aa1e48878636dfc18fdeee5093f453fb','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','20','0','0','','','1','c0e6aeb6c2f54d7b66438d3b31a6cda8','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-15@2020-11-15@@1039@1@1@@@0','15-11-2020~15-11-2020','53773','S000000241','2020-11-15','2020-11-15','1039','1','60.254.42.133','0','0','2c57aa09f3701ae6eee76a866fc33808','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','20','0','0','','','0','a2cf4e82f10787c87a93e41b77d3c2bc','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-16@2020-11-16@@1039@1@1@@@0','16-11-2020~16-11-2020','53773','S000000241','2020-11-16','2020-11-16','1039','1','60.254.42.133','0','0','62b56e34ddefef33f1bddf5542ffea3e','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','ebb6ee27df3864071d18621c5e274f96','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-17@2020-11-17@@1039@1@1@@@0','17-11-2020~17-11-2020','53773','S000000241','2020-11-17','2020-11-17','1039','1','60.254.42.133','0','0','23ec7fca78e0ff1201eb50bcced14458','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','ff945d466ddd2fa8270bc19523072e05','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-18@2020-11-18@@1039@1@1@@@0','18-11-2020~18-11-2020','53773','S000000241','2020-11-18','2020-11-18','1039','1','60.254.42.133','0','0','2fbeb1e077eb106668afad9bffd619fc','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','3dd66feca53736799715d948ce6ad8d6','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-19@2020-11-19@@1039@1@1@@@0','19-11-2020~19-11-2020','53773','S000000241','2020-11-19','2020-11-19','1039','1','60.254.42.133','0','0','684e9d93603ad066a99a5eba997c17f8','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','6e8f77ba3f43b157135be0e3bc148811','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-20@2020-11-20@@1039@1@1@@@0','20-11-2020~20-11-2020','53773','S000000241','2020-11-20','2020-11-20','1039','1','60.254.42.133','0','0','e53facbbb678b25acc125363504ac8bb','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','d1f772c567d71c67419d9e4272d0107a','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-21@2020-11-21@@1039@1@1@@@0','21-11-2020~21-11-2020','53773','S000000241','2020-11-21','2020-11-21','1039','1','60.254.42.133','0','0','131a5248913d47ae2bc3a7d49ac07301','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','b207bf3a437cb2e6a9af3bf843be923a','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-22@2020-11-22@@1039@1@1@@@0','22-11-2020~22-11-2020','53773','S000000241','2020-11-22','2020-11-22','1039','1','60.254.42.133','0','0','d5708f976a5fffe16627cf2514aa8225','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','30999938d9a0fc44d75dbeb0b0d5813a','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-23@2020-11-23@@1039@1@1@@@0','23-11-2020~23-11-2020','53773','S000000241','2020-11-23','2020-11-23','1039','1','60.254.42.133','0','0','495484ecfb7962d9086d0c4b6cad308b','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','bdba7e441e4e24b540a9fff7b114dc5a','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-24@2020-11-24@@1039@1@1@@@0','24-11-2020~24-11-2020','53773','S000000241','2020-11-24','2020-11-24','1039','1','60.254.42.133','0','0','7d5156c1ba4e39ae19c328fa21ab3e21','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','10','0','0','','','0','7197397a454c9e224c2b14104ce15e45','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0',''),('53773@S000000241@2020-11-25@2020-11-25@@1039@1@1@@@0','25-11-2020~25-11-2020','53773','S000000241','2020-11-25','2020-11-25','1039','1','60.254.42.133','0','0','7d80de16bf6d0ed64a34725f4793f145','Sa,Su','1','Supplier','132','A','100.000','100.000','AED','3','1','0','0','','','0','d1901bea366b123b5fe8b1bcbf01ddd1','2020-10-19 09:47:47','2020-10-19','Supplier','Supplier','2020-10-20','2020-10-20 07:42:31','Supplier','0','');
[10/20/2020 07:42:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('1929844','1929845','1929846','1929847','1929848','1929849','1929850','1929851','1929852','1929853','1929854','1929855','1929856','1929857','1929858','1929859','1929860','1929861','1929862','1929863','1929864','1929865','1929866','1929867','1929868','1929869','1929870','1929871','1929872','1929873','1929874','1929875','1929876','1929877','1929878');
[10/20/2020 07:50:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],DELETE FROM tax_configuration WHERE id = ?;
[10/20/2020 07:50:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],DELETE FROM tax_consumed_location WHERE tax_config_id = ?;
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_request_logs SET quotation_id='QTECHCD00093', request_detail='a%3A25%3A%7Bs%3A6%3A%22action%22%3Bs%3A22%3A%22insertQuotationService%22%3Bs%3A14%3A%22bookingSession%22%3Bs%3A32%3A%22fcdad2c2832c14ec21e4177effcd8fcb%22%3Bs%3A17%3A%22agent_suggest_box%22%3Bs%3A37%3A%22Qtech+%5BCD0009-arvind%5D+%5BArvind-Pandey%5D%22%3Bs%3A12%3A%22search_agent%22%3Bs%3A1%3A%229%22%3Bs%3A13%3A%22sel_countries%22%3Bs%3A3%3A%22132%22%3Bs%3A23%3A%22total_quotation_to_book%22%3Bs%3A1%3A%222%22%3Bs%3A37%3A%22quotation_booking_unique_session_code%22%3Bs%3A32%3A%22fcdad2c2832c14ec21e4177effcd8fcb%22%3Bs%3A14%3A%22quotation_name%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A12%3A%22QTECHCD00093%22%3Bs%3A11%3A%22ServiceDate%22%3Bs%3A10%3A%2215-10-2020%22%3Bs%3A18%3A%22sel_booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A11%3A%22selCurrency%22%3Bs%3A3%3A%22INR%22%3Bs%3A15%3A%22sel_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A13%3A%22reservationId%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22sel_hotel_quotation%22%3Bs%3A4%3A%221894%22%3Bs%3A10%3A%22salutation%22%3Bs%3A2%3A%22Ms%22%3Bs%3A10%3A%22first_name%22%3Bs%3A6%3A%22Ankita%22%3Bs%3A9%3A%22last_name%22%3Bs%3A3%3A%22Rao%22%3Bs%3A18%3A%22countryOfResidence%22%3Bs%3A3%3A%22106%22%3Bs%3A12%3A%22BookingNotes%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22customerAddress%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22bookquotation%22%3Ba%3A1%3A%7Bs%3A5%3A%22hotel%22%3Ba%3A2%3A%7Bs%3A23%3A%2215-10-2020%5E%3A%5E16-10-2020%22%3Ba%3A1%3A%7Bi%3A53699%3Ba%3A1%3A%7Bi%3A0%3Ba%3A43%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A5%3A%2253699%22%3Bs%3A12%3A%22service_name%22%3Bs%3A20%3A%22Marino+Beach+Colombo%22%3Bs%3A11%3A%22CheckInDate%22%3Bs%3A10%3A%2215-10-2020%22%3Bs%3A12%3A%22CheckOutDate%22%3Bs%3A10%3A%2216-10-2020%22%3Bs%3A9%3A%22NoOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221893%22%3Bs%3A10%3A%22service_id%22%3Bs%3A5%3A%2253699%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000071%22%3Bs%3A7%3A%22city_id%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A10%3A%22country_id%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A14%3A%22nationality_id%22%3Bs%3A3%3A%22106%22%3Bs%3A11%3A%22nationality%22%3Bs%3A6%3A%22Indian%22%3Bs%3A14%3A%22booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A22%3A%22rate_description_field%22%3Bs%3A458%3A%22%255B%255B%257B%2522date%2522%253A%25222020-10-15%2522%252C%2522supplier_rate%2522%253A%2522100.00%2522%252C%2522supplier_rate_in_agent_currency%2522%253A%2522100.00%2522%252C%2522applied_markup%2522%253A%25227%2522%252C%2522applied_markup_amount%2522%253Anull%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522agent_rate%2522%253A%2522107.00%2522%252C%2522supplier_commission%2522%253Anull%252C%2522supplier_commission_amount%2522%253Anull%252C%2522profit%2522%253Anull%252C%2522supplier_currency%2522%253A%2522INR%2522%252C%2522agent_currency%2522%253A%2522INR%2522%257D%255D%255D%22%3Bs%3A15%3A%22userDescription%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22specialRemark%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22room_category_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A50%3A%22Cilantro+Suite+-+Triple%2C+Extrabed+-+3+%28Full+Board%29%22%3B%7Ds%3A15%3A%22room_basis_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A10%3A%22Full+Board%22%3B%7Ds%3A16%3A%22NoOfRoomsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A17%3A%22noOfAdultsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A16%3A%22noOfChildPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3B%7Ds%3A20%3A%22inventory_room_class%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A14%3A%22Cilantro+Suite%22%3B%7Ds%3A16%3A%22room_category_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22620%22%3B%7Ds%3A10%3A%22room_basis%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%223%22%3B%7Ds%3A12%3A%22room_type_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22room_type_code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A47%3A%221%7E%7E%7E51%7E%7E%7E620%7E%7E%7E3%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3B%7Ds%3A14%3A%22room_type_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22single%22%3B%7Ds%3A14%3A%22room_child_age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A17%3A%22passenger_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A10%3A%22salutation%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Ankita%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22Rao%22%3B%7Ds%3A3%3A%22age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A16%3A%22baseSupplierRate%22%3Bs%3A3%3A%22100%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A1%3A%227%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A3%3A%22107%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A3%3A%22107%22%3Bs%3A11%3A%22supplierFoc%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22agentFoc%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%222%22%3B%7D%7D%7Ds%3A23%3A%2224-11-2020%5E%3A%5E25-11-2020%22%3Ba%3A1%3A%7Bi%3A53699%3Ba%3A1%3A%7Bi%3A1%3Ba%3A43%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A5%3A%2253699%22%3Bs%3A12%3A%22service_name%22%3Bs%3A20%3A%22Marino+Beach+Colombo%22%3Bs%3A11%3A%22CheckInDate%22%3Bs%3A10%3A%2224-11-2020%22%3Bs%3A12%3A%22CheckOutDate%22%3Bs%3A10%3A%2225-11-2020%22%3Bs%3A9%3A%22NoOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221894%22%3Bs%3A10%3A%22service_id%22%3Bs%3A5%3A%2253699%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000071%22%3Bs%3A7%3A%22city_id%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A10%3A%22country_id%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A14%3A%22nationality_id%22%3Bs%3A3%3A%22106%22%3Bs%3A11%3A%22nationality%22%3Bs%3A6%3A%22Indian%22%3Bs%3A14%3A%22booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A22%3A%22rate_description_field%22%3Bs%3A458%3A%22%255B%255B%257B%2522date%2522%253A%25222020-11-24%2522%252C%2522supplier_rate%2522%253A%2522200.00%2522%252C%2522supplier_rate_in_agent_currency%2522%253A%2522200.00%2522%252C%2522applied_markup%2522%253A%25227%2522%252C%2522applied_markup_amount%2522%253Anull%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522agent_rate%2522%253A%2522214.00%2522%252C%2522supplier_commission%2522%253Anull%252C%2522supplier_commission_amount%2522%253Anull%252C%2522profit%2522%253Anull%252C%2522supplier_currency%2522%253A%2522INR%2522%252C%2522agent_currency%2522%253A%2522INR%2522%257D%255D%255D%22%3Bs%3A15%3A%22userDescription%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22specialRemark%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22room_category_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A58%3A%22Colonial+Manssion+-+01+-+Double%2C+Extrabed+-+0+%28Half+Board%29%22%3B%7Ds%3A15%3A%22room_basis_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A10%3A%22Half+Board%22%3B%7Ds%3A16%3A%22NoOfRoomsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A17%3A%22noOfAdultsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A16%3A%22noOfChildPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3B%7Ds%3A20%3A%22inventory_room_class%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A22%3A%22Colonial+Manssion+-+01%22%3B%7Ds%3A16%3A%22room_category_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22653%22%3B%7Ds%3A10%3A%22room_basis%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3B%7Ds%3A12%3A%22room_type_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22room_type_code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A48%3A%221%7E%7E%7E142%7E%7E%7E653%7E%7E%7E2%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3B%7Ds%3A14%3A%22room_type_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22single%22%3B%7Ds%3A14%3A%22room_child_age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A17%3A%22passenger_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A10%3A%22salutation%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Ankita%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22Rao%22%3B%7Ds%3A3%3A%22age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A16%3A%22baseSupplierRate%22%3Bs%3A3%3A%22200%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A3%3A%22200%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A1%3A%227%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A3%3A%22214%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A3%3A%22214%22%3Bs%3A11%3A%22supplierFoc%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22agentFoc%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%223%22%3B%7D%7D%7D%7D%7Ds%3A19%3A%22total_package_adult%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22total_package_child%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22total_selling_price%22%3Bs%3A3%3A%22321%22%3B%7D', create_date='2020-10-20 07:51:41';
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1603180301','43.250.210.76');
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO bookings SET agent_id = '9' , service_type = 'hotel' , reservation_id = '1817' , display_currency_code = 'INR' , created_datetime='2020-10-20 07:51:41' , create_date='2020-10-20 07:51:41' , created_by ='tfg' , sales_manager_id ='' , consultant_id = 'tfg' , backoffice_user = 'tfg' , itenirary_id = '2' , sequence = '2', city_id='Colombo', country_id='132', leader_title='Ms', leader_first_name='Ankita', leader_last_name='Rao', nationality='Indian', site_id='0', supplier_profile_id='1', comment_contract='', supplier_cancellation_policy='', special_remark='', source_type='localsystem', booking_type='offline', booking_branch_id='1', service_type_detail='Marino Beach Colombo', country_of_residence='106';
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3023'
        ;
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into bookings_details set booking_id ='3023' , hotel_id='53699' , hotel_name='Marino Beach Colombo' , hotel_address1='' , hotel_phone='' , hotel_rating='5.0';
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_room_detail set booking_id = '3023', booking_detail_id = '1164', room_type_code = '1~~~51~~~620~~~3~~~~~~~~~71100~~~0~~~S000000071', room_name = 'single', meal_basis = 'Full Board', room_category = 'Cilantro Suite', room_type_description = 'Cilantro Suite - Full Board', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";d:107;}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:6:"100.00";}}' ,native_room_rate_total = '100' ,display_room_rate_total = '107' ,number_of_rooms = '1';
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE bookings SET confirmation_number='',itenirary_id ='2',sequence ='2',voucher_id='',voucher_hashcode='',native_currency_code='INR',cancellation_policy='',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='7',consultant_id='tfg',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='0.01533'_native,agent_currency_multiplier='1.00000',current_status='confirmed',status_date='2020-10-20 07:51:41',service_date='2020-10-15',check_out_date='2020-10-16',display_room_rate= '107',display_discount='',native_room_rate= '100',native_discount='',additional_charge='0',expiration_date= '2020-10-20 00:00:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='3023';
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],update bookings set  parent_agent_id='9', sub_agent_rate='', agent_rate='107', applicable_service_tax='', agent_markup='7', supplier_rate='100' where id='3023';
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],update bookings_details set total_nights='1', supplier_id= 'S000000071',arrival_date='2020/10/15',departure_date='2020/10/16',rate_code='~', total_rooms= '1', total_adults= '1', total_children= '0', total_infants= '0' where booking_id ='3023';
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3023','confirmed','2020-10-20 07:51:41','confirmed by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO passangers (booking_id,booking_detail_id,rid,room,salutations,first_name,last_name,passenger_type,age) values ('3023','1164','1748','0','Ms','Ankita','Rao','adult','');
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_search_log SET booking_id='3023', request_details='a%3A4%3A%7Bs%3A10%3A%22booking_id%22%3Bs%3A4%3A%223023%22%3Bs%3A12%3A%22post_details%22%3Ba%3A45%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A5%3A%2253699%22%3Bs%3A12%3A%22service_name%22%3Bs%3A20%3A%22Marino+Beach+Colombo%22%3Bs%3A11%3A%22CheckInDate%22%3Bs%3A10%3A%2215-10-2020%22%3Bs%3A12%3A%22CheckOutDate%22%3Bs%3A10%3A%2216-10-2020%22%3Bs%3A9%3A%22NoOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221893%22%3Bs%3A10%3A%22service_id%22%3Bs%3A5%3A%2253699%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000071%22%3Bs%3A7%3A%22city_id%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A10%3A%22country_id%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A14%3A%22nationality_id%22%3Bs%3A3%3A%22106%22%3Bs%3A11%3A%22nationality%22%3Bs%3A6%3A%22Indian%22%3Bs%3A14%3A%22booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A22%3A%22rate_description_field%22%3Bs%3A458%3A%22%255B%255B%257B%2522date%2522%253A%25222020-10-15%2522%252C%2522supplier_rate%2522%253A%2522100.00%2522%252C%2522supplier_rate_in_agent_currency%2522%253A%2522100.00%2522%252C%2522applied_markup%2522%253A%25227%2522%252C%2522applied_markup_amount%2522%253Anull%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522agent_rate%2522%253A%2522107.00%2522%252C%2522supplier_commission%2522%253Anull%252C%2522supplier_commission_amount%2522%253Anull%252C%2522profit%2522%253Anull%252C%2522supplier_currency%2522%253A%2522INR%2522%252C%2522agent_currency%2522%253A%2522INR%2522%257D%255D%255D%22%3Bs%3A15%3A%22userDescription%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22specialRemark%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22room_category_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A50%3A%22Cilantro+Suite+-+Triple%2C+Extrabed+-+3+%28Full+Board%29%22%3B%7Ds%3A15%3A%22room_basis_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A10%3A%22Full+Board%22%3B%7Ds%3A16%3A%22NoOfRoomsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A17%3A%22noOfAdultsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A16%3A%22noOfChildPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3B%7Ds%3A20%3A%22inventory_room_class%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A14%3A%22Cilantro+Suite%22%3B%7Ds%3A16%3A%22room_category_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22620%22%3B%7Ds%3A10%3A%22room_basis%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%223%22%3B%7Ds%3A12%3A%22room_type_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22room_type_code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A47%3A%221%7E%7E%7E51%7E%7E%7E620%7E%7E%7E3%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3B%7Ds%3A14%3A%22room_type_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22single%22%3B%7Ds%3A14%3A%22room_child_age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A17%3A%22passenger_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A10%3A%22salutation%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Ankita%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22Rao%22%3B%7Ds%3A3%3A%22age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A16%3A%22baseSupplierRate%22%3Bs%3A3%3A%22100%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A1%3A%227%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A3%3A%22107%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A3%3A%22107%22%3Bs%3A11%3A%22supplierFoc%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22agentFoc%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22quotation_info%22%3Bs%3A13783%3A%22a%253A21%253A%257Bs%253A11%253A%2522arrivaltime%2522%253Bi%253A1618099200%253Bs%253A13%253A%2522date_selected%2522%253Bs%253A24%253A%252215%252F10%252F2020%2B--%2B16%252F10%252F2020%2522%253Bs%253A15%253A%2522selected_nights%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522hotel_id%2522%253Bs%253A5%253A%252253699%2522%253Bs%253A14%253A%2522local_hotel_id%2522%253Bs%253A5%253A%252253699%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A14%253A%2522propertyRating%2522%253Bs%253A3%253A%25225.0%2522%253Bs%253A10%253A%2522hotel_info%2522%253Ba%253A1%253A%257Bs%253A11%253A%2522localsystem%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A8%253A%2522RateInfo%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522100.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A6%253A%2522107.00%2522%253B%257D%257D%257Ds%253A25%253A%2522RateBreakUpDetailsCompact%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A12%253A%257Bs%253A4%253A%2522date%2522%253Bs%253A10%253A%25222020-10-15%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A6%253A%2522107.00%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A6%253A%2522107.00%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A47%253A%25221%257E%257E%257E51%257E%257E%257E620%257E%257E%257E3%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A20%253A%2522MARINO%2BBEACH%2BCOLOMBO%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522620%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25223%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A10%253A%2522Full%2BBoard%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A49%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2B%2BFull%2BBoard%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A50%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2B%2528Full%2BBoard%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A37%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2522%253Bs%253A14%253A%2522non_refundable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A15%253A%2522class_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522search_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A47%253A%25221%257E%257E%257E51%257E%257E%257E620%257E%257E%257E3%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A1%253A%257Bs%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25221.58%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25225.42%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25225.42%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522107%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25221%2522%253Bs%253A13%253A%2522supplier_data%2522%253Ba%253A5%253A%257Bs%253A7%253A%2522hotelId%2522%253Bs%253A25%253A%252253699----------S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253B%257Ds%253A11%253A%2522tax_details%2522%253Ba%253A4%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A3%253A%25221.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25221.58%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25225.42%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%257D%257Ds%253A7%253A%2522address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A8%253A%2522latitude%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522longitude%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522numberOfRooms%2522%253Bi%253A1%253Bs%253A11%253A%2522totalAdults%2522%253Bi%253A1%253Bs%253A13%253A%2522totalChildren%2522%253Bi%253A0%253Bs%253A13%253A%2522selected_city%2522%253Bs%253A5%253A%252271100%2522%253Bs%253A16%253A%2522selected_country%2522%253Bs%253A3%253A%2522132%2522%253Bs%253A20%253A%2522selected_nationality%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A20%253A%2522selected_country_res%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A2184%253A%2522Colombo%2B%2528%252Fk%253F%253Fl%253Fmbo%253F%252F%253B%2BSinhala%253A%2B%253F%253F%253F%253F%252C%2Bromanized%253A%2BKolamba%252C%2Bpronunciation%2B%255B%253Fk%253Fl%253Fmb%253F%255D%253B%2BTamil%253A%2B%253F%253F%253F%253F%253F%253F%253F%253F%252C%2Bromanized%253A%2BKo%253Fumpu%252C%2BTamil%2Bpronunciation%253A%2B%255Bko%253Fumbu%255D%2529%2Bis%2Bthe%2Bcommercial%2Bcapital%255B3%255D%2Band%2Blargest%2Bcity%2Bof%2BSri%2BLanka%2Bby%2Bpopulation.%2BAccording%2Bto%2Bthe%2BBrookings%2BInstitution%252C%2BColombo%2Bmetropolitan%2Barea%2Bhas%2Ba%2Bpopulation%2Bof%2B5.6%2Bmillion%252C%255B4%255D%255B5%255D%255B6%255D%255B7%255D%2Band%2B752%252C993%255B2%255D%2Bin%2Bthe%2Bcity%2Bproper.%2BIt%2Bis%2Bthe%2Bfinancial%2Bcentre%2Bof%2Bthe%2Bisland%2Band%2Ba%2Bpopular%2Btourist%2Bdestination.%255B8%255D%2BIt%2Bis%2Blocated%2Bon%2Bthe%2Bwest%2Bcoast%2Bof%2Bthe%2Bisland%2Band%2Badjacent%2Bto%2Bthe%2BGreater%2BColombo%2Barea%2Bwhich%2Bincludes%2BSri%2BJayawardenepura%2BKotte%252C%2Bthe%2Blegislative%2Bcapital%2Bof%2BSri%2BLanka%2Band%2BDehiwala-Mount%2BLavinia.%2BColombo%2Bis%2Boften%2Breferred%2Bto%2Bas%2Bthe%2Bcapital%2Bsince%2BSri%2BJayawardenepura%2BKotte%2Bis%2Bwithin%2Bthe%2Burban%2Barea%2Bof%252C%2Band%2Ba%2Bsuburb%2Bof%252C%2BColombo.%2BIt%2Bis%2Balso%2Bthe%2Badministrative%2Bcapital%2Bof%2Bthe%2BWestern%2BProvince%2Band%2Bthe%2Bdistrict%2Bcapital%2Bof%2BColombo%2BDistrict.%2BColombo%2Bis%2Ba%2Bbusy%2Band%2Bvibrant%2Bplace%2Bwith%2Ba%2Bmixture%2Bof%2Bmodern%2Blife%2Band%2Bcolonial%2Bbuildings%2Band%2Bruins.%255B9%255D%250D%250A%250D%250ADue%2Bto%2Bits%2Blarge%2Bharbour%2Band%2Bits%2Bstrategic%2Bposition%2Balong%2Bthe%2BEast-West%2Bsea%2Btrade%2Broutes%252C%2BColombo%2Bwas%2Bknown%2Bto%2Bancient%2Btraders%2B2%252C000%2Byears%2Bago.%255Bcitation%2Bneeded%255D%2BIt%2Bwas%2Bmade%2Bthe%2Bcapital%2Bof%2Bthe%2Bisland%2Bwhen%2BSri%2BLanka%2Bwas%2Bceded%2Bto%2Bthe%2BBritish%2BEmpire%2Bin%2B1815%252C%255B10%255D%2Band%2Bits%2Bstatus%2Bas%2Bcapital%2Bwas%2Bretained%2Bwhen%2Bthe%2Bnation%2Bbecame%2Bindependent%2Bin%2B1948.%2BIn%2B1978%252C%2Bwhen%2Badministrative%2Bfunctions%2Bwere%2Bmoved%2Bto%2BSri%2BJayawardenepura%2BKotte%252C%2BColombo%2Bwas%2Bdesignated%2Bas%2Bthe%2Bcommercial%2Bcapital%2Bof%2BSri%2BLanka.%250D%250A%250D%250ALike%2Bmany%2Bcities%252C%2BColombo%255C%2526%2523039%253Bs%2Burban%2Barea%2Bextends%2Bwell%2Bbeyond%2Bthe%2Bboundaries%2Bof%2Ba%2Bsingle%2Blocal%2Bauthority%252C%2Bencompassing%2Bother%2Bmunicipal%2Band%2Burban%2Bcouncils%2Bsuch%2Bas%2BSri%2BJayawardenepura%2BKotte%2BMunicipal%2BCouncil%252C%2BDehiwala%2BMount%2BLavinia%2BMunicipal%2BCouncil%252C%2BKolonnawa%2BUrban%2BCouncil%252C%2BKaduwela%2BMunicipal%2BCouncil%2Band%2BKotikawatte%2BMulleriyawa%2BPradeshiya%2BSabha.%2BThe%2Bmain%2Bcity%2Bis%2Bhome%2Bto%2Ba%2Bmajority%2Bof%2BSri%2BLanka%255C%2526%2523039%253Bs%2Bcorporate%2Boffices%252C%2Brestaurants%2Band%2Bentertainment%2Bvenues.%255B11%255D%2BFamous%2Blandmarks%2Bin%2BColombo%2Binclude%2BGalle%2BFace%2BGreen%252C%2BViharamahadevi%2BPark%252C%2BBeira%2BLake%252C%2BColombo%2BRacecourse%252C%2BPlanetarium%252C%2BUniversity%2Bof%2BColombo%252C%2BMount%2BLavinia%2Bbeach%252C%2BNelum%2BPokuna%2BTheatre%252C%2BColombo%2BLotus%2BTower%2Bas%2Bwell%2Bas%2Bthe%2BNational%2BMuseum.%2B%2522%253Bs%253A11%253A%2522hotel_image%2522%253Bs%253A249%253A%2522https%253A%252F%252Falpha.otrams.thefabulousgetaway.com%252F%252Fcpfv3%252Fimages%252F%253Fimage%253DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5Njg1OF9tYWluX21haW4mIzAzOTtzX2ltYWdlcy5qcGVn%2522%253Bs%253A18%253A%2522quotation_selected%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522100.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A6%253A%2522107.00%2522%253B%257D%257D%257Ds%253A25%253A%2522RateBreakUpDetailsCompact%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A12%253A%257Bs%253A4%253A%2522date%2522%253Bs%253A10%253A%25222020-10-15%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A6%253A%2522107.00%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A6%253A%2522107.00%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A47%253A%25221%257E%257E%257E51%257E%257E%257E620%257E%257E%257E3%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A20%253A%2522MARINO%2BBEACH%2BCOLOMBO%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522620%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25223%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A10%253A%2522Full%2BBoard%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A49%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2B%2BFull%2BBoard%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A50%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2B%2528Full%2BBoard%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A37%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2522%253Bs%253A14%253A%2522non_refundable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A15%253A%2522class_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522search_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A47%253A%25221%257E%257E%257E51%257E%257E%257E620%257E%257E%257E3%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A1%253A%257Bs%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25221.58%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25225.42%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25225.42%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522107%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25221%2522%253Bs%253A13%253A%2522supplier_data%2522%253Ba%253A5%253A%257Bs%253A7%253A%2522hotelId%2522%253Bs%253A25%253A%252253699----------S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253B%257Ds%253A11%253A%2522tax_details%2522%253Ba%253A4%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A3%253A%25221.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25221.58%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25225.42%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%22%3Bs%3A18%3A%22inventory_class_id%22%3Bs%3A4%3A%22%2751%27%22%3B%7Ds%3A15%3A%22request_details%22%3Ba%3A71%3A%7Bs%3A13%3A%22check_in_date%22%3Bs%3A10%3A%2215-10-2020%22%3Bs%3A14%3A%22check_out_date%22%3Bs%3A10%3A%222020-10-16%22%3Bs%3A11%3A%22action_name%22%3Bs%3A10%3A%22add_sector%22%3Bs%3A11%3A%22total_night%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22agent_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A8%3A%22agent_id%22%3Bs%3A1%3A%229%22%3Bs%3A17%3A%22agent_selected_id%22%3Bs%3A1%3A%229%22%3Bs%3A17%3A%22total_native_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A18%3A%22total_display_rate%22%3Bs%3A3%3A%22107%22%3Bs%3A13%3A%22sel_countries%22%3Bs%3A3%3A%22132%22%3Bs%3A24%3A%22sel_country_of_residence%22%3Bs%3A3%3A%22106%22%3Bs%3A8%3A%22sel_city%22%3Bs%3A5%3A%2271100%22%3Bs%3A10%3A%22sel_hotels%22%3Bs%3A5%3A%2253699%22%3Bs%3A11%3A%22hotel_phone%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22sel_booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A11%3A%22arrive_date%22%3Bs%3A10%3A%2215-10-2020%22%3Bs%3A11%3A%22depart_date%22%3Bs%3A10%3A%2216-10-2020%22%3Bs%3A19%3A%22confirmation_number%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22sel_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22sel_salutations%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A14%3A%22sel_first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Ankita%22%3B%7Ds%3A13%3A%22sel_last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22Rao%22%3B%7Ds%3A14%3A%22leader_address%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22rdSupplierType%22%3Bs%3A1%3A%22L%22%3Bs%3A12%3A%22sel_supplier%22%3Bs%3A10%3A%22S000000071%22%3Bs%3A20%3A%22sel_supplierProfileL%22%3Bs%3A1%3A%221%22%3Bs%3A21%3A%22sel_currencies_online%22%3Bs%3A3%3A%22INR%22%3Bs%3A21%3A%22display_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A22%3A%22supplier_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A25%3A%22agent_currency_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A16%3A%22txt_agent_markup%22%3Bs%3A1%3A%227%22%3Bs%3A23%3A%22basecurrency_multiplier%22%3Bd%3A0.01533%3Bs%3A30%3A%22basecurrency_multiplier_native%22%3Bd%3A0.01533%3Bs%3A10%3A%22txt_markup%22%3Bs%3A1%3A%227%22%3Bs%3A12%3A%22room_type_id%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_rooms%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%221%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22total_pax%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22room_type%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A13%3A%22single_room_1%22%3B%7Ds%3A25%3A%22single_room_1_description%22%3Bs%3A14%3A%22Cilantro+Suite%22%3Bs%3A18%3A%22single_room_1_code%22%3Bs%3A47%3A%221%7E%7E%7E51%7E%7E%7E620%7E%7E%7E3%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3Bs%3A24%3A%22single_room_1_room_basis%22%3Bs%3A10%3A%22Full+Board%22%3Bs%3A29%3A%22single_room_1_room_basis_desc%22%3Bs%3A10%3A%22Full+Board%22%3Bs%3A29%3A%22single_room_1_number_of_rooms%22%3Bs%3A1%3A%221%22%3Bs%3A25%3A%22single_room_1_native_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22100.00%22%3B%7Ds%3A40%3A%22single_room_1_native_supplier_commission%22%3BN%3Bs%3A47%3A%22single_room_1_native_supplier_commission_amount%22%3BN%3Bs%3A26%3A%22single_room_1_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A107%3B%7Ds%3A30%3A%22single_room_1_sub_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A107%3B%7Ds%3A29%3A%22single_room_1_wh_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A107%3B%7Ds%3A15%3A%22native_discount%22%3Bi%3A0%3Bs%3A16%3A%22display_discount%22%3Bi%3A0%3Bs%3A17%3A%22additional_charge%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22expiration_date%22%3Bs%3A19%3A%2220%2F10%2F2020+00%3A00%3A00%22%3Bs%3A19%3A%22cancellation_policy%22%3Bs%3A0%3A%22%22%3Bs%3A28%3A%22supplier_cancellation_policy%22%3Bs%3A0%3A%22%22%3Bs%3A6%3A%22remark%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22special_comment%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22supplier_type%22%3Bs%3A7%3A%22offline%22%3Bs%3A14%3A%22reservation_id%22%3Bs%3A4%3A%221817%22%3Bs%3A12%3A%22leader_phone%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22email_id%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22sequence%22%3Bs%3A1%3A%222%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%222%22%3Bs%3A20%3A%22is_quote_fit_booking%22%3Bs%3A1%3A%221%22%3Bs%3A21%3A%22fetch_booking_details%22%3Bb%3A1%3Bs%3A28%3A%22strip_room_class_description%22%3Bb%3A1%3B%7Ds%3A17%3A%22quotation_details%22%3Bs%3A13783%3A%22a%253A21%253A%257Bs%253A11%253A%2522arrivaltime%2522%253Bi%253A1618099200%253Bs%253A13%253A%2522date_selected%2522%253Bs%253A24%253A%252215%252F10%252F2020%2B--%2B16%252F10%252F2020%2522%253Bs%253A15%253A%2522selected_nights%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522hotel_id%2522%253Bs%253A5%253A%252253699%2522%253Bs%253A14%253A%2522local_hotel_id%2522%253Bs%253A5%253A%252253699%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A14%253A%2522propertyRating%2522%253Bs%253A3%253A%25225.0%2522%253Bs%253A10%253A%2522hotel_info%2522%253Ba%253A1%253A%257Bs%253A11%253A%2522localsystem%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A8%253A%2522RateInfo%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522100.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A6%253A%2522107.00%2522%253B%257D%257D%257Ds%253A25%253A%2522RateBreakUpDetailsCompact%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A12%253A%257Bs%253A4%253A%2522date%2522%253Bs%253A10%253A%25222020-10-15%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A6%253A%2522107.00%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A6%253A%2522107.00%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A47%253A%25221%257E%257E%257E51%257E%257E%257E620%257E%257E%257E3%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A20%253A%2522MARINO%2BBEACH%2BCOLOMBO%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522620%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25223%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A10%253A%2522Full%2BBoard%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A49%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2B%2BFull%2BBoard%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A50%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2B%2528Full%2BBoard%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A37%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2522%253Bs%253A14%253A%2522non_refundable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A15%253A%2522class_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522search_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A47%253A%25221%257E%257E%257E51%257E%257E%257E620%257E%257E%257E3%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A1%253A%257Bs%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25221.58%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25225.42%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25225.42%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522107%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25221%2522%253Bs%253A13%253A%2522supplier_data%2522%253Ba%253A5%253A%257Bs%253A7%253A%2522hotelId%2522%253Bs%253A25%253A%252253699----------S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253B%257Ds%253A11%253A%2522tax_details%2522%253Ba%253A4%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A3%253A%25221.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25221.58%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25225.42%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%257D%257Ds%253A7%253A%2522address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A8%253A%2522latitude%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522longitude%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522numberOfRooms%2522%253Bi%253A1%253Bs%253A11%253A%2522totalAdults%2522%253Bi%253A1%253Bs%253A13%253A%2522totalChildren%2522%253Bi%253A0%253Bs%253A13%253A%2522selected_city%2522%253Bs%253A5%253A%252271100%2522%253Bs%253A16%253A%2522selected_country%2522%253Bs%253A3%253A%2522132%2522%253Bs%253A20%253A%2522selected_nationality%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A20%253A%2522selected_country_res%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A2184%253A%2522Colombo%2B%2528%252Fk%253F%253Fl%253Fmbo%253F%252F%253B%2BSinhala%253A%2B%253F%253F%253F%253F%252C%2Bromanized%253A%2BKolamba%252C%2Bpronunciation%2B%255B%253Fk%253Fl%253Fmb%253F%255D%253B%2BTamil%253A%2B%253F%253F%253F%253F%253F%253F%253F%253F%252C%2Bromanized%253A%2BKo%253Fumpu%252C%2BTamil%2Bpronunciation%253A%2B%255Bko%253Fumbu%255D%2529%2Bis%2Bthe%2Bcommercial%2Bcapital%255B3%255D%2Band%2Blargest%2Bcity%2Bof%2BSri%2BLanka%2Bby%2Bpopulation.%2BAccording%2Bto%2Bthe%2BBrookings%2BInstitution%252C%2BColombo%2Bmetropolitan%2Barea%2Bhas%2Ba%2Bpopulation%2Bof%2B5.6%2Bmillion%252C%255B4%255D%255B5%255D%255B6%255D%255B7%255D%2Band%2B752%252C993%255B2%255D%2Bin%2Bthe%2Bcity%2Bproper.%2BIt%2Bis%2Bthe%2Bfinancial%2Bcentre%2Bof%2Bthe%2Bisland%2Band%2Ba%2Bpopular%2Btourist%2Bdestination.%255B8%255D%2BIt%2Bis%2Blocated%2Bon%2Bthe%2Bwest%2Bcoast%2Bof%2Bthe%2Bisland%2Band%2Badjacent%2Bto%2Bthe%2BGreater%2BColombo%2Barea%2Bwhich%2Bincludes%2BSri%2BJayawardenepura%2BKotte%252C%2Bthe%2Blegislative%2Bcapital%2Bof%2BSri%2BLanka%2Band%2BDehiwala-Mount%2BLavinia.%2BColombo%2Bis%2Boften%2Breferred%2Bto%2Bas%2Bthe%2Bcapital%2Bsince%2BSri%2BJayawardenepura%2BKotte%2Bis%2Bwithin%2Bthe%2Burban%2Barea%2Bof%252C%2Band%2Ba%2Bsuburb%2Bof%252C%2BColombo.%2BIt%2Bis%2Balso%2Bthe%2Badministrative%2Bcapital%2Bof%2Bthe%2BWestern%2BProvince%2Band%2Bthe%2Bdistrict%2Bcapital%2Bof%2BColombo%2BDistrict.%2BColombo%2Bis%2Ba%2Bbusy%2Band%2Bvibrant%2Bplace%2Bwith%2Ba%2Bmixture%2Bof%2Bmodern%2Blife%2Band%2Bcolonial%2Bbuildings%2Band%2Bruins.%255B9%255D%250D%250A%250D%250ADue%2Bto%2Bits%2Blarge%2Bharbour%2Band%2Bits%2Bstrategic%2Bposition%2Balong%2Bthe%2BEast-West%2Bsea%2Btrade%2Broutes%252C%2BColombo%2Bwas%2Bknown%2Bto%2Bancient%2Btraders%2B2%252C000%2Byears%2Bago.%255Bcitation%2Bneeded%255D%2BIt%2Bwas%2Bmade%2Bthe%2Bcapital%2Bof%2Bthe%2Bisland%2Bwhen%2BSri%2BLanka%2Bwas%2Bceded%2Bto%2Bthe%2BBritish%2BEmpire%2Bin%2B1815%252C%255B10%255D%2Band%2Bits%2Bstatus%2Bas%2Bcapital%2Bwas%2Bretained%2Bwhen%2Bthe%2Bnation%2Bbecame%2Bindependent%2Bin%2B1948.%2BIn%2B1978%252C%2Bwhen%2Badministrative%2Bfunctions%2Bwere%2Bmoved%2Bto%2BSri%2BJayawardenepura%2BKotte%252C%2BColombo%2Bwas%2Bdesignated%2Bas%2Bthe%2Bcommercial%2Bcapital%2Bof%2BSri%2BLanka.%250D%250A%250D%250ALike%2Bmany%2Bcities%252C%2BColombo%255C%2526%2523039%253Bs%2Burban%2Barea%2Bextends%2Bwell%2Bbeyond%2Bthe%2Bboundaries%2Bof%2Ba%2Bsingle%2Blocal%2Bauthority%252C%2Bencompassing%2Bother%2Bmunicipal%2Band%2Burban%2Bcouncils%2Bsuch%2Bas%2BSri%2BJayawardenepura%2BKotte%2BMunicipal%2BCouncil%252C%2BDehiwala%2BMount%2BLavinia%2BMunicipal%2BCouncil%252C%2BKolonnawa%2BUrban%2BCouncil%252C%2BKaduwela%2BMunicipal%2BCouncil%2Band%2BKotikawatte%2BMulleriyawa%2BPradeshiya%2BSabha.%2BThe%2Bmain%2Bcity%2Bis%2Bhome%2Bto%2Ba%2Bmajority%2Bof%2BSri%2BLanka%255C%2526%2523039%253Bs%2Bcorporate%2Boffices%252C%2Brestaurants%2Band%2Bentertainment%2Bvenues.%255B11%255D%2BFamous%2Blandmarks%2Bin%2BColombo%2Binclude%2BGalle%2BFace%2BGreen%252C%2BViharamahadevi%2BPark%252C%2BBeira%2BLake%252C%2BColombo%2BRacecourse%252C%2BPlanetarium%252C%2BUniversity%2Bof%2BColombo%252C%2BMount%2BLavinia%2Bbeach%252C%2BNelum%2BPokuna%2BTheatre%252C%2BColombo%2BLotus%2BTower%2Bas%2Bwell%2Bas%2Bthe%2BNational%2BMuseum.%2B%2522%253Bs%253A11%253A%2522hotel_image%2522%253Bs%253A249%253A%2522https%253A%252F%252Falpha.otrams.thefabulousgetaway.com%252F%252Fcpfv3%252Fimages%252F%253Fimage%253DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5Njg1OF9tYWluX21haW4mIzAzOTtzX2ltYWdlcy5qcGVn%2522%253Bs%253A18%253A%2522quotation_selected%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522100.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A6%253A%2522107.00%2522%253B%257D%257D%257Ds%253A25%253A%2522RateBreakUpDetailsCompact%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A12%253A%257Bs%253A4%253A%2522date%2522%253Bs%253A10%253A%25222020-10-15%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A6%253A%2522107.00%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A6%253A%2522107.00%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A47%253A%25221%257E%257E%257E51%257E%257E%257E620%257E%257E%257E3%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A20%253A%2522MARINO%2BBEACH%2BCOLOMBO%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522620%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25223%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A10%253A%2522Full%2BBoard%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A49%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2B%2BFull%2BBoard%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A50%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2B%2528Full%2BBoard%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A37%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2522%253Bs%253A14%253A%2522non_refundable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A15%253A%2522class_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522search_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A47%253A%25221%257E%257E%257E51%257E%257E%257E620%257E%257E%257E3%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A1%253A%257Bs%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25221.58%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25225.42%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25225.42%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522107%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25221%2522%253Bs%253A13%253A%2522supplier_data%2522%253Ba%253A5%253A%257Bs%253A7%253A%2522hotelId%2522%253Bs%253A25%253A%252253699----------S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253B%257Ds%253A11%253A%2522tax_details%2522%253Ba%253A4%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A3%253A%25221.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25221.58%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25225.42%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%22%3B%7D', create_date='2020-10-20 07:51:41';;
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3023','confirmed','2020-10-20 07:51:41','Quotation Id - QTECHCD00093 created on behalf of Agent - Arvind Pandey(9) by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3023','confirmed','2020-10-20 07:51:41','Enquiry Id - 404 created on behalf of Agent - Arvind Pandey(9) by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO bookings SET agent_id = '9' , service_type = 'hotel' , reservation_id = '1817' , display_currency_code = 'INR' , created_datetime='2020-10-20 07:51:41' , create_date='2020-10-20 07:51:41' , created_by ='tfg' , sales_manager_id ='' , consultant_id = 'tfg' , backoffice_user = 'tfg' , itenirary_id = '3' , sequence = '3', city_id='Colombo', country_id='132', leader_title='Ms', leader_first_name='Ankita', leader_last_name='Rao', nationality='Indian', site_id='0', supplier_profile_id='1', comment_contract='', supplier_cancellation_policy='', special_remark='', source_type='localsystem', booking_type='offline', booking_branch_id='1', service_type_detail='Marino Beach Colombo', country_of_residence='106';
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3024'
        ;
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into bookings_details set booking_id ='3024' , hotel_id='53699' , hotel_name='Marino Beach Colombo' , hotel_address1='' , hotel_phone='' , hotel_rating='5.0';
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_room_detail set booking_id = '3024', booking_detail_id = '1165', room_type_code = '1~~~142~~~653~~~2~~~~~~~~~71100~~~0~~~S000000071', room_name = 'single', meal_basis = 'Half Board', room_category = 'Colonial Manssion - 01', room_type_description = 'Colonial Manssion - 01 - Half Board', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";d:214;}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:6:"200.00";}}' ,native_room_rate_total = '200' ,display_room_rate_total = '214' ,number_of_rooms = '1';
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE bookings SET confirmation_number='',itenirary_id ='3',sequence ='3',voucher_id='',voucher_hashcode='',native_currency_code='INR',cancellation_policy='',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='7',consultant_id='tfg',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='0.01533'_native,agent_currency_multiplier='1.00000',current_status='confirmed',status_date='2020-10-20 07:51:41',service_date='2020-11-24',check_out_date='2020-11-25',display_room_rate= '214',display_discount='',native_room_rate= '200',native_discount='',additional_charge='0',expiration_date= '2020-10-20 00:00:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='3024';
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],update bookings set  parent_agent_id='9', sub_agent_rate='', agent_rate='214', applicable_service_tax='', agent_markup='7', supplier_rate='200' where id='3024';
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],update bookings_details set total_nights='1', supplier_id= 'S000000071',arrival_date='2020/11/24',departure_date='2020/11/25',rate_code='~', total_rooms= '1', total_adults= '1', total_children= '0', total_infants= '0' where booking_id ='3024';
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3024','confirmed','2020-10-20 07:51:41','confirmed by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO passangers (booking_id,booking_detail_id,rid,room,salutations,first_name,last_name,passenger_type,age) values ('3024','1165','1749','0','Ms','Ankita','Rao','adult','');
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_search_log SET booking_id='3024', request_details='a%3A4%3A%7Bs%3A10%3A%22booking_id%22%3Bs%3A4%3A%223024%22%3Bs%3A12%3A%22post_details%22%3Ba%3A45%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A5%3A%2253699%22%3Bs%3A12%3A%22service_name%22%3Bs%3A20%3A%22Marino+Beach+Colombo%22%3Bs%3A11%3A%22CheckInDate%22%3Bs%3A10%3A%2224-11-2020%22%3Bs%3A12%3A%22CheckOutDate%22%3Bs%3A10%3A%2225-11-2020%22%3Bs%3A9%3A%22NoOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221894%22%3Bs%3A10%3A%22service_id%22%3Bs%3A5%3A%2253699%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000071%22%3Bs%3A7%3A%22city_id%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A10%3A%22country_id%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A14%3A%22nationality_id%22%3Bs%3A3%3A%22106%22%3Bs%3A11%3A%22nationality%22%3Bs%3A6%3A%22Indian%22%3Bs%3A14%3A%22booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A22%3A%22rate_description_field%22%3Bs%3A458%3A%22%255B%255B%257B%2522date%2522%253A%25222020-11-24%2522%252C%2522supplier_rate%2522%253A%2522200.00%2522%252C%2522supplier_rate_in_agent_currency%2522%253A%2522200.00%2522%252C%2522applied_markup%2522%253A%25227%2522%252C%2522applied_markup_amount%2522%253Anull%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522agent_rate%2522%253A%2522214.00%2522%252C%2522supplier_commission%2522%253Anull%252C%2522supplier_commission_amount%2522%253Anull%252C%2522profit%2522%253Anull%252C%2522supplier_currency%2522%253A%2522INR%2522%252C%2522agent_currency%2522%253A%2522INR%2522%257D%255D%255D%22%3Bs%3A15%3A%22userDescription%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22specialRemark%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22room_category_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A58%3A%22Colonial+Manssion+-+01+-+Double%2C+Extrabed+-+0+%28Half+Board%29%22%3B%7Ds%3A15%3A%22room_basis_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A10%3A%22Half+Board%22%3B%7Ds%3A16%3A%22NoOfRoomsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A17%3A%22noOfAdultsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A16%3A%22noOfChildPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3B%7Ds%3A20%3A%22inventory_room_class%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A22%3A%22Colonial+Manssion+-+01%22%3B%7Ds%3A16%3A%22room_category_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22653%22%3B%7Ds%3A10%3A%22room_basis%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3B%7Ds%3A12%3A%22room_type_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22room_type_code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A48%3A%221%7E%7E%7E142%7E%7E%7E653%7E%7E%7E2%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3B%7Ds%3A14%3A%22room_type_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22single%22%3B%7Ds%3A14%3A%22room_child_age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A17%3A%22passenger_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A10%3A%22salutation%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Ankita%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22Rao%22%3B%7Ds%3A3%3A%22age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A16%3A%22baseSupplierRate%22%3Bs%3A3%3A%22200%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A3%3A%22200%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A1%3A%227%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A3%3A%22214%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A3%3A%22214%22%3Bs%3A11%3A%22supplierFoc%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22agentFoc%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%223%22%3Bs%3A14%3A%22quotation_info%22%3Bs%3A13905%3A%22a%253A21%253A%257Bs%253A11%253A%2522arrivaltime%2522%253Bi%253A1904860800%253Bs%253A13%253A%2522date_selected%2522%253Bs%253A24%253A%252224%252F11%252F2020%2B--%2B25%252F11%252F2020%2522%253Bs%253A15%253A%2522selected_nights%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522hotel_id%2522%253Bs%253A5%253A%252253699%2522%253Bs%253A14%253A%2522local_hotel_id%2522%253Bs%253A5%253A%252253699%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A14%253A%2522propertyRating%2522%253Bs%253A3%253A%25225.0%2522%253Bs%253A10%253A%2522hotel_info%2522%253Ba%253A1%253A%257Bs%253A11%253A%2522localsystem%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A8%253A%2522RateInfo%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522200.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A6%253A%2522214.00%2522%253B%257D%257D%257Ds%253A25%253A%2522RateBreakUpDetailsCompact%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A12%253A%257Bs%253A4%253A%2522date%2522%253Bs%253A10%253A%25222020-11-24%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A6%253A%2522214.00%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A6%253A%2522214.00%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E142%257E%257E%257E653%257E%257E%257E2%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A20%253A%2522MARINO%2BBEACH%2BCOLOMBO%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522653%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25222%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A10%253A%2522Half%2BBoard%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A57%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2B%2BHalf%2BBoard%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A58%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2B%2528Half%2BBoard%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A45%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2522%253Bs%253A14%253A%2522non_refundable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A15%253A%2522class_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522search_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A17%253A%25227.000000000000001%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E142%257E%257E%257E653%257E%257E%257E2%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A1%253A%257Bs%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25223.16%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A17%253A%25227.000000000000001%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A5%253A%252210.84%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25225.42%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522214%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522200%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25221%2522%253Bs%253A13%253A%2522supplier_data%2522%253Ba%253A5%253A%257Bs%253A7%253A%2522hotelId%2522%253Bs%253A25%253A%252253699----------S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253B%257Ds%253A11%253A%2522tax_details%2522%253Ba%253A4%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A3%253A%25221.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25223.16%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25225.42%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%257D%257Ds%253A7%253A%2522address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A8%253A%2522latitude%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522longitude%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522numberOfRooms%2522%253Bi%253A1%253Bs%253A11%253A%2522totalAdults%2522%253Bi%253A1%253Bs%253A13%253A%2522totalChildren%2522%253Bi%253A0%253Bs%253A13%253A%2522selected_city%2522%253Bs%253A5%253A%252271100%2522%253Bs%253A16%253A%2522selected_country%2522%253Bs%253A3%253A%2522132%2522%253Bs%253A20%253A%2522selected_nationality%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A20%253A%2522selected_country_res%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A2184%253A%2522Colombo%2B%2528%252Fk%253F%253Fl%253Fmbo%253F%252F%253B%2BSinhala%253A%2B%253F%253F%253F%253F%252C%2Bromanized%253A%2BKolamba%252C%2Bpronunciation%2B%255B%253Fk%253Fl%253Fmb%253F%255D%253B%2BTamil%253A%2B%253F%253F%253F%253F%253F%253F%253F%253F%252C%2Bromanized%253A%2BKo%253Fumpu%252C%2BTamil%2Bpronunciation%253A%2B%255Bko%253Fumbu%255D%2529%2Bis%2Bthe%2Bcommercial%2Bcapital%255B3%255D%2Band%2Blargest%2Bcity%2Bof%2BSri%2BLanka%2Bby%2Bpopulation.%2BAccording%2Bto%2Bthe%2BBrookings%2BInstitution%252C%2BColombo%2Bmetropolitan%2Barea%2Bhas%2Ba%2Bpopulation%2Bof%2B5.6%2Bmillion%252C%255B4%255D%255B5%255D%255B6%255D%255B7%255D%2Band%2B752%252C993%255B2%255D%2Bin%2Bthe%2Bcity%2Bproper.%2BIt%2Bis%2Bthe%2Bfinancial%2Bcentre%2Bof%2Bthe%2Bisland%2Band%2Ba%2Bpopular%2Btourist%2Bdestination.%255B8%255D%2BIt%2Bis%2Blocated%2Bon%2Bthe%2Bwest%2Bcoast%2Bof%2Bthe%2Bisland%2Band%2Badjacent%2Bto%2Bthe%2BGreater%2BColombo%2Barea%2Bwhich%2Bincludes%2BSri%2BJayawardenepura%2BKotte%252C%2Bthe%2Blegislative%2Bcapital%2Bof%2BSri%2BLanka%2Band%2BDehiwala-Mount%2BLavinia.%2BColombo%2Bis%2Boften%2Breferred%2Bto%2Bas%2Bthe%2Bcapital%2Bsince%2BSri%2BJayawardenepura%2BKotte%2Bis%2Bwithin%2Bthe%2Burban%2Barea%2Bof%252C%2Band%2Ba%2Bsuburb%2Bof%252C%2BColombo.%2BIt%2Bis%2Balso%2Bthe%2Badministrative%2Bcapital%2Bof%2Bthe%2BWestern%2BProvince%2Band%2Bthe%2Bdistrict%2Bcapital%2Bof%2BColombo%2BDistrict.%2BColombo%2Bis%2Ba%2Bbusy%2Band%2Bvibrant%2Bplace%2Bwith%2Ba%2Bmixture%2Bof%2Bmodern%2Blife%2Band%2Bcolonial%2Bbuildings%2Band%2Bruins.%255B9%255D%250D%250A%250D%250ADue%2Bto%2Bits%2Blarge%2Bharbour%2Band%2Bits%2Bstrategic%2Bposition%2Balong%2Bthe%2BEast-West%2Bsea%2Btrade%2Broutes%252C%2BColombo%2Bwas%2Bknown%2Bto%2Bancient%2Btraders%2B2%252C000%2Byears%2Bago.%255Bcitation%2Bneeded%255D%2BIt%2Bwas%2Bmade%2Bthe%2Bcapital%2Bof%2Bthe%2Bisland%2Bwhen%2BSri%2BLanka%2Bwas%2Bceded%2Bto%2Bthe%2BBritish%2BEmpire%2Bin%2B1815%252C%255B10%255D%2Band%2Bits%2Bstatus%2Bas%2Bcapital%2Bwas%2Bretained%2Bwhen%2Bthe%2Bnation%2Bbecame%2Bindependent%2Bin%2B1948.%2BIn%2B1978%252C%2Bwhen%2Badministrative%2Bfunctions%2Bwere%2Bmoved%2Bto%2BSri%2BJayawardenepura%2BKotte%252C%2BColombo%2Bwas%2Bdesignated%2Bas%2Bthe%2Bcommercial%2Bcapital%2Bof%2BSri%2BLanka.%250D%250A%250D%250ALike%2Bmany%2Bcities%252C%2BColombo%255C%2526%2523039%253Bs%2Burban%2Barea%2Bextends%2Bwell%2Bbeyond%2Bthe%2Bboundaries%2Bof%2Ba%2Bsingle%2Blocal%2Bauthority%252C%2Bencompassing%2Bother%2Bmunicipal%2Band%2Burban%2Bcouncils%2Bsuch%2Bas%2BSri%2BJayawardenepura%2BKotte%2BMunicipal%2BCouncil%252C%2BDehiwala%2BMount%2BLavinia%2BMunicipal%2BCouncil%252C%2BKolonnawa%2BUrban%2BCouncil%252C%2BKaduwela%2BMunicipal%2BCouncil%2Band%2BKotikawatte%2BMulleriyawa%2BPradeshiya%2BSabha.%2BThe%2Bmain%2Bcity%2Bis%2Bhome%2Bto%2Ba%2Bmajority%2Bof%2BSri%2BLanka%255C%2526%2523039%253Bs%2Bcorporate%2Boffices%252C%2Brestaurants%2Band%2Bentertainment%2Bvenues.%255B11%255D%2BFamous%2Blandmarks%2Bin%2BColombo%2Binclude%2BGalle%2BFace%2BGreen%252C%2BViharamahadevi%2BPark%252C%2BBeira%2BLake%252C%2BColombo%2BRacecourse%252C%2BPlanetarium%252C%2BUniversity%2Bof%2BColombo%252C%2BMount%2BLavinia%2Bbeach%252C%2BNelum%2BPokuna%2BTheatre%252C%2BColombo%2BLotus%2BTower%2Bas%2Bwell%2Bas%2Bthe%2BNational%2BMuseum.%2B%2522%253Bs%253A11%253A%2522hotel_image%2522%253Bs%253A249%253A%2522https%253A%252F%252Falpha.otrams.thefabulousgetaway.com%252F%252Fcpfv3%252Fimages%252F%253Fimage%253DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5Njg1OF9tYWluX21haW4mIzAzOTtzX2ltYWdlcy5qcGVn%2522%253Bs%253A18%253A%2522quotation_selected%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522200.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A6%253A%2522214.00%2522%253B%257D%257D%257Ds%253A25%253A%2522RateBreakUpDetailsCompact%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A12%253A%257Bs%253A4%253A%2522date%2522%253Bs%253A10%253A%25222020-11-24%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A6%253A%2522214.00%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A6%253A%2522214.00%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E142%257E%257E%257E653%257E%257E%257E2%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A20%253A%2522MARINO%2BBEACH%2BCOLOMBO%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522653%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25222%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A10%253A%2522Half%2BBoard%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A57%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2B%2BHalf%2BBoard%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A58%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2B%2528Half%2BBoard%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A45%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2522%253Bs%253A14%253A%2522non_refundable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A15%253A%2522class_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522search_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A17%253A%25227.000000000000001%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E142%257E%257E%257E653%257E%257E%257E2%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A1%253A%257Bs%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25223.16%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A17%253A%25227.000000000000001%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A5%253A%252210.84%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25225.42%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522214%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522200%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25221%2522%253Bs%253A13%253A%2522supplier_data%2522%253Ba%253A5%253A%257Bs%253A7%253A%2522hotelId%2522%253Bs%253A25%253A%252253699----------S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253B%257Ds%253A11%253A%2522tax_details%2522%253Ba%253A4%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A3%253A%25221.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25223.16%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25225.42%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%22%3Bs%3A18%3A%22inventory_class_id%22%3Bs%3A5%3A%22%27142%27%22%3B%7Ds%3A15%3A%22request_details%22%3Ba%3A71%3A%7Bs%3A13%3A%22check_in_date%22%3Bs%3A10%3A%2224-11-2020%22%3Bs%3A14%3A%22check_out_date%22%3Bs%3A10%3A%222020-11-25%22%3Bs%3A11%3A%22action_name%22%3Bs%3A10%3A%22add_sector%22%3Bs%3A11%3A%22total_night%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22agent_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A8%3A%22agent_id%22%3Bs%3A1%3A%229%22%3Bs%3A17%3A%22agent_selected_id%22%3Bs%3A1%3A%229%22%3Bs%3A17%3A%22total_native_rate%22%3Bs%3A3%3A%22200%22%3Bs%3A18%3A%22total_display_rate%22%3Bs%3A3%3A%22214%22%3Bs%3A13%3A%22sel_countries%22%3Bs%3A3%3A%22132%22%3Bs%3A24%3A%22sel_country_of_residence%22%3Bs%3A3%3A%22106%22%3Bs%3A8%3A%22sel_city%22%3Bs%3A5%3A%2271100%22%3Bs%3A10%3A%22sel_hotels%22%3Bs%3A5%3A%2253699%22%3Bs%3A11%3A%22hotel_phone%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22sel_booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A11%3A%22arrive_date%22%3Bs%3A10%3A%2224-11-2020%22%3Bs%3A11%3A%22depart_date%22%3Bs%3A10%3A%2225-11-2020%22%3Bs%3A19%3A%22confirmation_number%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22sel_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22sel_salutations%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A14%3A%22sel_first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Ankita%22%3B%7Ds%3A13%3A%22sel_last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22Rao%22%3B%7Ds%3A14%3A%22leader_address%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22rdSupplierType%22%3Bs%3A1%3A%22L%22%3Bs%3A12%3A%22sel_supplier%22%3Bs%3A10%3A%22S000000071%22%3Bs%3A20%3A%22sel_supplierProfileL%22%3Bs%3A1%3A%221%22%3Bs%3A21%3A%22sel_currencies_online%22%3Bs%3A3%3A%22INR%22%3Bs%3A21%3A%22display_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A22%3A%22supplier_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A25%3A%22agent_currency_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A16%3A%22txt_agent_markup%22%3Bs%3A1%3A%227%22%3Bs%3A23%3A%22basecurrency_multiplier%22%3Bd%3A0.01533%3Bs%3A30%3A%22basecurrency_multiplier_native%22%3Bd%3A0.01533%3Bs%3A10%3A%22txt_markup%22%3Bs%3A1%3A%227%22%3Bs%3A12%3A%22room_type_id%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_rooms%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%221%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22total_pax%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22room_type%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A13%3A%22single_room_1%22%3B%7Ds%3A25%3A%22single_room_1_description%22%3Bs%3A22%3A%22Colonial+Manssion+-+01%22%3Bs%3A18%3A%22single_room_1_code%22%3Bs%3A48%3A%221%7E%7E%7E142%7E%7E%7E653%7E%7E%7E2%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3Bs%3A24%3A%22single_room_1_room_basis%22%3Bs%3A10%3A%22Half+Board%22%3Bs%3A29%3A%22single_room_1_room_basis_desc%22%3Bs%3A10%3A%22Half+Board%22%3Bs%3A29%3A%22single_room_1_number_of_rooms%22%3Bs%3A1%3A%221%22%3Bs%3A25%3A%22single_room_1_native_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22200.00%22%3B%7Ds%3A40%3A%22single_room_1_native_supplier_commission%22%3BN%3Bs%3A47%3A%22single_room_1_native_supplier_commission_amount%22%3BN%3Bs%3A26%3A%22single_room_1_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A214%3B%7Ds%3A30%3A%22single_room_1_sub_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A214%3B%7Ds%3A29%3A%22single_room_1_wh_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A214%3B%7Ds%3A15%3A%22native_discount%22%3Bi%3A0%3Bs%3A16%3A%22display_discount%22%3Bi%3A0%3Bs%3A17%3A%22additional_charge%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22expiration_date%22%3Bs%3A19%3A%2220%2F10%2F2020+00%3A00%3A00%22%3Bs%3A19%3A%22cancellation_policy%22%3Bs%3A0%3A%22%22%3Bs%3A28%3A%22supplier_cancellation_policy%22%3Bs%3A0%3A%22%22%3Bs%3A6%3A%22remark%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22special_comment%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22supplier_type%22%3Bs%3A7%3A%22offline%22%3Bs%3A14%3A%22reservation_id%22%3Bs%3A4%3A%221817%22%3Bs%3A12%3A%22leader_phone%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22email_id%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22sequence%22%3Bs%3A1%3A%223%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%223%22%3Bs%3A20%3A%22is_quote_fit_booking%22%3Bs%3A1%3A%221%22%3Bs%3A21%3A%22fetch_booking_details%22%3Bb%3A1%3Bs%3A28%3A%22strip_room_class_description%22%3Bb%3A1%3B%7Ds%3A17%3A%22quotation_details%22%3Bs%3A13905%3A%22a%253A21%253A%257Bs%253A11%253A%2522arrivaltime%2522%253Bi%253A1904860800%253Bs%253A13%253A%2522date_selected%2522%253Bs%253A24%253A%252224%252F11%252F2020%2B--%2B25%252F11%252F2020%2522%253Bs%253A15%253A%2522selected_nights%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522hotel_id%2522%253Bs%253A5%253A%252253699%2522%253Bs%253A14%253A%2522local_hotel_id%2522%253Bs%253A5%253A%252253699%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A14%253A%2522propertyRating%2522%253Bs%253A3%253A%25225.0%2522%253Bs%253A10%253A%2522hotel_info%2522%253Ba%253A1%253A%257Bs%253A11%253A%2522localsystem%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A8%253A%2522RateInfo%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522200.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A6%253A%2522214.00%2522%253B%257D%257D%257Ds%253A25%253A%2522RateBreakUpDetailsCompact%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A12%253A%257Bs%253A4%253A%2522date%2522%253Bs%253A10%253A%25222020-11-24%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A6%253A%2522214.00%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A6%253A%2522214.00%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E142%257E%257E%257E653%257E%257E%257E2%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A20%253A%2522MARINO%2BBEACH%2BCOLOMBO%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522653%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25222%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A10%253A%2522Half%2BBoard%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A57%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2B%2BHalf%2BBoard%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A58%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2B%2528Half%2BBoard%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A45%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2522%253Bs%253A14%253A%2522non_refundable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A15%253A%2522class_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522search_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A17%253A%25227.000000000000001%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E142%257E%257E%257E653%257E%257E%257E2%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A1%253A%257Bs%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25223.16%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A17%253A%25227.000000000000001%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A5%253A%252210.84%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25225.42%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522214%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522200%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25221%2522%253Bs%253A13%253A%2522supplier_data%2522%253Ba%253A5%253A%257Bs%253A7%253A%2522hotelId%2522%253Bs%253A25%253A%252253699----------S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253B%257Ds%253A11%253A%2522tax_details%2522%253Ba%253A4%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A3%253A%25221.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25223.16%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25225.42%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%257D%257Ds%253A7%253A%2522address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A8%253A%2522latitude%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522longitude%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522numberOfRooms%2522%253Bi%253A1%253Bs%253A11%253A%2522totalAdults%2522%253Bi%253A1%253Bs%253A13%253A%2522totalChildren%2522%253Bi%253A0%253Bs%253A13%253A%2522selected_city%2522%253Bs%253A5%253A%252271100%2522%253Bs%253A16%253A%2522selected_country%2522%253Bs%253A3%253A%2522132%2522%253Bs%253A20%253A%2522selected_nationality%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A20%253A%2522selected_country_res%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A2184%253A%2522Colombo%2B%2528%252Fk%253F%253Fl%253Fmbo%253F%252F%253B%2BSinhala%253A%2B%253F%253F%253F%253F%252C%2Bromanized%253A%2BKolamba%252C%2Bpronunciation%2B%255B%253Fk%253Fl%253Fmb%253F%255D%253B%2BTamil%253A%2B%253F%253F%253F%253F%253F%253F%253F%253F%252C%2Bromanized%253A%2BKo%253Fumpu%252C%2BTamil%2Bpronunciation%253A%2B%255Bko%253Fumbu%255D%2529%2Bis%2Bthe%2Bcommercial%2Bcapital%255B3%255D%2Band%2Blargest%2Bcity%2Bof%2BSri%2BLanka%2Bby%2Bpopulation.%2BAccording%2Bto%2Bthe%2BBrookings%2BInstitution%252C%2BColombo%2Bmetropolitan%2Barea%2Bhas%2Ba%2Bpopulation%2Bof%2B5.6%2Bmillion%252C%255B4%255D%255B5%255D%255B6%255D%255B7%255D%2Band%2B752%252C993%255B2%255D%2Bin%2Bthe%2Bcity%2Bproper.%2BIt%2Bis%2Bthe%2Bfinancial%2Bcentre%2Bof%2Bthe%2Bisland%2Band%2Ba%2Bpopular%2Btourist%2Bdestination.%255B8%255D%2BIt%2Bis%2Blocated%2Bon%2Bthe%2Bwest%2Bcoast%2Bof%2Bthe%2Bisland%2Band%2Badjacent%2Bto%2Bthe%2BGreater%2BColombo%2Barea%2Bwhich%2Bincludes%2BSri%2BJayawardenepura%2BKotte%252C%2Bthe%2Blegislative%2Bcapital%2Bof%2BSri%2BLanka%2Band%2BDehiwala-Mount%2BLavinia.%2BColombo%2Bis%2Boften%2Breferred%2Bto%2Bas%2Bthe%2Bcapital%2Bsince%2BSri%2BJayawardenepura%2BKotte%2Bis%2Bwithin%2Bthe%2Burban%2Barea%2Bof%252C%2Band%2Ba%2Bsuburb%2Bof%252C%2BColombo.%2BIt%2Bis%2Balso%2Bthe%2Badministrative%2Bcapital%2Bof%2Bthe%2BWestern%2BProvince%2Band%2Bthe%2Bdistrict%2Bcapital%2Bof%2BColombo%2BDistrict.%2BColombo%2Bis%2Ba%2Bbusy%2Band%2Bvibrant%2Bplace%2Bwith%2Ba%2Bmixture%2Bof%2Bmodern%2Blife%2Band%2Bcolonial%2Bbuildings%2Band%2Bruins.%255B9%255D%250D%250A%250D%250ADue%2Bto%2Bits%2Blarge%2Bharbour%2Band%2Bits%2Bstrategic%2Bposition%2Balong%2Bthe%2BEast-West%2Bsea%2Btrade%2Broutes%252C%2BColombo%2Bwas%2Bknown%2Bto%2Bancient%2Btraders%2B2%252C000%2Byears%2Bago.%255Bcitation%2Bneeded%255D%2BIt%2Bwas%2Bmade%2Bthe%2Bcapital%2Bof%2Bthe%2Bisland%2Bwhen%2BSri%2BLanka%2Bwas%2Bceded%2Bto%2Bthe%2BBritish%2BEmpire%2Bin%2B1815%252C%255B10%255D%2Band%2Bits%2Bstatus%2Bas%2Bcapital%2Bwas%2Bretained%2Bwhen%2Bthe%2Bnation%2Bbecame%2Bindependent%2Bin%2B1948.%2BIn%2B1978%252C%2Bwhen%2Badministrative%2Bfunctions%2Bwere%2Bmoved%2Bto%2BSri%2BJayawardenepura%2BKotte%252C%2BColombo%2Bwas%2Bdesignated%2Bas%2Bthe%2Bcommercial%2Bcapital%2Bof%2BSri%2BLanka.%250D%250A%250D%250ALike%2Bmany%2Bcities%252C%2BColombo%255C%2526%2523039%253Bs%2Burban%2Barea%2Bextends%2Bwell%2Bbeyond%2Bthe%2Bboundaries%2Bof%2Ba%2Bsingle%2Blocal%2Bauthority%252C%2Bencompassing%2Bother%2Bmunicipal%2Band%2Burban%2Bcouncils%2Bsuch%2Bas%2BSri%2BJayawardenepura%2BKotte%2BMunicipal%2BCouncil%252C%2BDehiwala%2BMount%2BLavinia%2BMunicipal%2BCouncil%252C%2BKolonnawa%2BUrban%2BCouncil%252C%2BKaduwela%2BMunicipal%2BCouncil%2Band%2BKotikawatte%2BMulleriyawa%2BPradeshiya%2BSabha.%2BThe%2Bmain%2Bcity%2Bis%2Bhome%2Bto%2Ba%2Bmajority%2Bof%2BSri%2BLanka%255C%2526%2523039%253Bs%2Bcorporate%2Boffices%252C%2Brestaurants%2Band%2Bentertainment%2Bvenues.%255B11%255D%2BFamous%2Blandmarks%2Bin%2BColombo%2Binclude%2BGalle%2BFace%2BGreen%252C%2BViharamahadevi%2BPark%252C%2BBeira%2BLake%252C%2BColombo%2BRacecourse%252C%2BPlanetarium%252C%2BUniversity%2Bof%2BColombo%252C%2BMount%2BLavinia%2Bbeach%252C%2BNelum%2BPokuna%2BTheatre%252C%2BColombo%2BLotus%2BTower%2Bas%2Bwell%2Bas%2Bthe%2BNational%2BMuseum.%2B%2522%253Bs%253A11%253A%2522hotel_image%2522%253Bs%253A249%253A%2522https%253A%252F%252Falpha.otrams.thefabulousgetaway.com%252F%252Fcpfv3%252Fimages%252F%253Fimage%253DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5Njg1OF9tYWluX21haW4mIzAzOTtzX2ltYWdlcy5qcGVn%2522%253Bs%253A18%253A%2522quotation_selected%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522200.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A6%253A%2522214.00%2522%253B%257D%257D%257Ds%253A25%253A%2522RateBreakUpDetailsCompact%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A12%253A%257Bs%253A4%253A%2522date%2522%253Bs%253A10%253A%25222020-11-24%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A6%253A%2522214.00%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A6%253A%2522214.00%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E142%257E%257E%257E653%257E%257E%257E2%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A20%253A%2522MARINO%2BBEACH%2BCOLOMBO%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522653%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25222%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A10%253A%2522Half%2BBoard%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A57%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2B%2BHalf%2BBoard%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A58%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2B%2528Half%2BBoard%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A45%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2522%253Bs%253A14%253A%2522non_refundable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A15%253A%2522class_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522search_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A17%253A%25227.000000000000001%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E142%257E%257E%257E653%257E%257E%257E2%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A1%253A%257Bs%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25223.16%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A17%253A%25227.000000000000001%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A5%253A%252210.84%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25225.42%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522214%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522200%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25221%2522%253Bs%253A13%253A%2522supplier_data%2522%253Ba%253A5%253A%257Bs%253A7%253A%2522hotelId%2522%253Bs%253A25%253A%252253699----------S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253B%257Ds%253A11%253A%2522tax_details%2522%253Ba%253A4%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A3%253A%25221.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25223.16%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25225.42%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%22%3B%7D', create_date='2020-10-20 07:51:41';;
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3024','confirmed','2020-10-20 07:51:41','Quotation Id - QTECHCD00093 created on behalf of Agent - Arvind Pandey(9) by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3024','confirmed','2020-10-20 07:51:41','Enquiry Id - 404 created on behalf of Agent - Arvind Pandey(9) by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='booked' where unique_id='QTECHCD00093';
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_bookings SET booking_id='3023',q_id='QTECHCD00093',enquiry_id='404',quote_id='1893',backoffice_user='tfg',agent_id='9',create_date='2020-10-20 07:51:41',booked_from='agent_quote_itemized';
[10/20/2020 07:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_bookings SET booking_id='3024',q_id='QTECHCD00093',enquiry_id='404',quote_id='1894',backoffice_user='tfg',agent_id='9',create_date='2020-10-20 07:51:41',booked_from='agent_quote_itemized';
[10/20/2020 07:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='testbooking',status_date='2020-10-20 07:52:01',current_status='vouchered',voucher_hashcode='a64ba2ba9348aa7a78f024f507e407e0757683023',vouchered_by ='tfg' where id='3023';
[10/20/2020 07:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='3023',config_key='VOUCHER_DATE', config_value='2020-10-20 07:52:01',create_date='2020-10-20 07:52:01';
[10/20/2020 07:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO autogenerator_invoice_number (id, number) VALUES ('','1603180321');
[10/20/2020 07:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/387' where id='3023' and is_invoiced!='yes';
[10/20/2020 07:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('107'),   credit_value= credit_value-('107') ,  cd_credit_usage=cd_credit_usage+('107') , cd_credit_value=cd_credit_value-('107')  WHERE id = '9';
[10/20/2020 07:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '9',credit_value= '19967.000',credit_usage= '80033.000',credit_limit= '100000',receipt_id= '',amount= '107',booking_id='3023',booking_cost= '107',receipt_allocation= '',balance= '107',ip='43.250.210.76',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-10-20 07:10:01';
[10/20/2020 07:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='INR',supplier_price='100',supplier_type='offline',supplier_id='S000000071',acc_type='purchase',accounting_multiplier='0.01533',booking_id='3023',booking_log='Booking Vouchered',type='Sale',create_date='2020-10-20 07:52:01',account_invoice='2020/387',particulars='';
[10/20/2020 07:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO `bookings_tax` (`booking_id`, `tax_id`, `tax_value`, `tax_amount`, `tax_type` ,`tax_percent`, `branch_id`, `acc_type` , `transaction`, `transaction_id`, `entity` )
                VALUES ('3023','1','100.000','13.04347826087','IP','15','1','purchase','booking_rate_info','1488','supplier');
[10/20/2020 07:52:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/387',acc_export='1' where bid='1488';
[10/20/2020 07:52:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='107',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='3023',booking_log='Booking Vouchered',type='Sale',create_date='2020-10-20 07:52:01',account_invoice='2020/387',particulars='';
[10/20/2020 07:52:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1489;
[10/20/2020 07:52:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1489',booking_id= '3023',invoice_number= '2020/387',service_type= 'hotel',booking_type= 'offline',service_name= 'Marino Beach Colombo',type= 'sale',room_type= 'single',quantity_room= '1',from_date= '2020/10/15',to_date= '2020/10/16',quantity= '1',price= '107',total_price= '107';
[10/20/2020 07:52:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO `bookings_tax` (`booking_id`, `tax_id`, `tax_value`, `tax_amount`, `tax_type` ,`tax_percent`, `branch_id`, `acc_type` , `transaction`, `transaction_id`, `entity` )
                VALUES ('3023','4','107.000','13.95652173913','OP','15','1','sale','booking_rate_info','1489','agent');
[10/20/2020 07:52:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/387',acc_export='1' where bid='1489';
[10/20/2020 07:52:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/387',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 26508 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,arvind.pandey@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-20 07:52:03';
[10/20/2020 07:52:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3023','vouchered-invoiced','2020-10-20 07:52:03',' by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 07:52:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3023',booking_detail_id ='3023',agent_id ='9',is_sub_agent ='N',parent_id ='',display_commission ='7',display_currency ='INR',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 7 %',create_date ='2020-10-20 07:52:03';
[10/20/2020 07:52:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3023',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/20/2020 07:52:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3023','vouchered','2020-10-20 07:52:03','Vouchered By tfg by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 07:52:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG103023 /  Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 26968 characters]',to_email_id= 'arvind.pandey@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= 'jignesh@qtechsoftware.com',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-20 07:52:05';
[10/20/2020 07:52:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3023','arvind.pandey@qtechsoftware.com');
[10/20/2020 07:52:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3023','jignesh@qtechsoftware.com');
[10/20/2020 07:52:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3023','ankita.rao@qtechsoftware.com');
[10/20/2020 07:52:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='testbooking',status_date='2020-10-20 07:52:05',current_status='vouchered',voucher_hashcode='2dcd5f5e56e3bf654d0e715f0a6d5134366043024',vouchered_by ='tfg' where id='3024';
[10/20/2020 07:52:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='3024',config_key='VOUCHER_DATE', config_value='2020-10-20 07:52:05',create_date='2020-10-20 07:52:05';
[10/20/2020 07:52:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/387' where id='3024' and is_invoiced!='yes';
[10/20/2020 07:52:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('214'),   credit_value= credit_value-('214') ,  cd_credit_usage=cd_credit_usage+('214') , cd_credit_value=cd_credit_value-('214')  WHERE id = '9';
[10/20/2020 07:52:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '9',credit_value= '19753.000',credit_usage= '80247.000',credit_limit= '100000',receipt_id= '',amount= '214',booking_id='3024',booking_cost= '214',receipt_allocation= '',balance= '214',ip='43.250.210.76',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-10-20 07:10:05';
[10/20/2020 07:52:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='INR',supplier_price='200',supplier_type='offline',supplier_id='S000000071',acc_type='purchase',accounting_multiplier='0.01533',booking_id='3024',booking_log='Booking Vouchered',type='Sale',create_date='2020-10-20 07:52:05',account_invoice='2020/387',particulars='';
[10/20/2020 07:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/387',acc_export='1' where bid='1490';
[10/20/2020 07:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='214',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='3024',booking_log='Booking Vouchered',type='Sale',create_date='2020-10-20 07:52:05',account_invoice='2020/387',particulars='';
[10/20/2020 07:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1491;
[10/20/2020 07:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1491',booking_id= '3024',invoice_number= '2020/387',service_type= 'hotel',booking_type= 'offline',service_name= 'Marino Beach Colombo',type= 'sale',room_type= 'single',quantity_room= '1',from_date= '2020/11/24',to_date= '2020/11/25',quantity= '1',price= '214',total_price= '214';
[10/20/2020 07:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0zMDI0PGJyPkludm9pY2Ugbm86LTIwMjAvMzg3PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-20 07:52:06';
[10/20/2020 07:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php], insert into email_trigger set  subject ='The Fabulous Getaway Tax Dispute',  message='For Following booking Tax is not inserted<br>BookingId:-3024<br>Invoice no:-2020/387<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2020-10-20 07:52:06', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[10/20/2020 07:52:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/387',acc_export='1' where bid='1491';
[10/20/2020 07:52:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/387',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 28276 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,arvind.pandey@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-20 07:52:08';
[10/20/2020 07:52:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3024','vouchered-invoiced','2020-10-20 07:52:08',' by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 07:52:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3024',booking_detail_id ='3024',agent_id ='9',is_sub_agent ='N',parent_id ='',display_commission ='14',display_currency ='INR',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 7 %',create_date ='2020-10-20 07:52:08';
[10/20/2020 07:52:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3024',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/20/2020 07:52:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3024','vouchered','2020-10-20 07:52:08','Vouchered By tfg by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 07:52:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG103024 /  Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 26360 characters]',to_email_id= 'arvind.pandey@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= 'jignesh@qtechsoftware.com',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-20 07:52:09';
[10/20/2020 07:52:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3024','arvind.pandey@qtechsoftware.com');
[10/20/2020 07:52:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3024','jignesh@qtechsoftware.com');
[10/20/2020 07:52:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3024','ankita.rao@qtechsoftware.com');
[10/20/2020 07:56:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],INSERT INTO `tax_configuration` (`branch_country`, `branch_state`, `valid_from`, `valid_to`, `supplier_registered`,`supplier_country`,`supplier_type` , `service`, `sub_service`, `exempted`,`consumed`,`has_consumed_location`, `type`,`system`, `input_tax_id`, `input_tax_amt`,`output_tax_id`, `output_tax_amt`,`created_by`,`created_on`,`branch`) VALUES ('132','', '2020-10-21', '2050-12-31', '1', '0','external', '1', '', '0','IB' , '0' , 'IN', 'b2b', '0', '', '4', '3.5','tfg','2020-10-20 07:56:45','');
[10/20/2020 07:56:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-20 07:56:45',`log_type`= 'Tax Configuration',`sql_query`= 'INSERT INTO `tax_configuration` (`branch_country`, `branch_state`, `valid_from`, `valid_to`, `supplier_registered`,`supplier_country`,`supplier_type` , `service`, `sub_service`, `exempted`,`consumed`,`has_consumed_location`, `type`,`system`, `input_tax_id`, `input_tax_amt`,`output_tax_id`, `output_tax_amt`,`created_by`,`created_on`,`branch`) VALUES (\&#039;132\&#039;,\&#039;\&#039;, \&#039;2020-10-21\&#039;, \&#039;2050-12-31\&#039;, \&#039;1\&#039;, \&#039;0\&#039;,\&#039;external\&#039;, \&#039;1\&#039;, \&#039;\&#039;, \&#039;0\&#039;,\&#039;IB\&#039; , \&#039;0\&#039; , \&#039;IN\&#039;, \&#039;b2b\&#039;, \&#039;0\&#039;, \&#039;\&#039;, \&#039;4\&#039;, \&#039;3.5\&#039;,\&#039;tfg\&#039;,\&#039;2020-10-20 07:56:45\&#039;,\&#039;\&#039;)',`log_description`= 'Tax Configuration added',`ip`= '43.250.210.76';
[10/20/2020 07:56:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],INSERT INTO `tax_configuration` (`branch_country`, `branch_state`, `valid_from`, `valid_to`, `supplier_registered`,`supplier_country`,`supplier_type` , `service`, `sub_service`, `exempted`,`consumed`,`has_consumed_location`, `type`,`system`, `input_tax_id`, `input_tax_amt`,`output_tax_id`, `output_tax_amt`,`created_by`,`created_on`,`branch`) VALUES ('132','', '2020-10-21', '2050-12-31', '1', '0','internal', '1', '', '0','IB' , '0' , 'IN', 'b2b', '0', '', '4', '3.5','tfg','2020-10-20 07:56:45','');
[10/20/2020 07:56:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-20 07:56:45',`log_type`= 'Tax Configuration',`sql_query`= 'INSERT INTO `tax_configuration` (`branch_country`, `branch_state`, `valid_from`, `valid_to`, `supplier_registered`,`supplier_country`,`supplier_type` , `service`, `sub_service`, `exempted`,`consumed`,`has_consumed_location`, `type`,`system`, `input_tax_id`, `input_tax_amt`,`output_tax_id`, `output_tax_amt`,`created_by`,`created_on`,`branch`) VALUES (\&#039;132\&#039;,\&#039;\&#039;, \&#039;2020-10-21\&#039;, \&#039;2050-12-31\&#039;, \&#039;1\&#039;, \&#039;0\&#039;,\&#039;internal\&#039;, \&#039;1\&#039;, \&#039;\&#039;, \&#039;0\&#039;,\&#039;IB\&#039; , \&#039;0\&#039; , \&#039;IN\&#039;, \&#039;b2b\&#039;, \&#039;0\&#039;, \&#039;\&#039;, \&#039;4\&#039;, \&#039;3.5\&#039;,\&#039;tfg\&#039;,\&#039;2020-10-20 07:56:45\&#039;,\&#039;\&#039;)',`log_description`= 'Tax Configuration added',`ip`= '43.250.210.76';
[10/20/2020 07:56:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],INSERT INTO `tax_configuration` (`branch_country`, `branch_state`, `valid_from`, `valid_to`, `supplier_registered`,`supplier_country`,`supplier_type` , `service`, `sub_service`, `exempted`,`consumed`,`has_consumed_location`, `type`,`system`, `input_tax_id`, `input_tax_amt`,`output_tax_id`, `output_tax_amt`,`created_by`,`created_on`,`branch`) VALUES ('132','', '2020-10-21', '2050-12-31', '1', '0','substitute', '1', '', '0','IB' , '0' , 'IN', 'b2b', '0', '', '4', '3.5','tfg','2020-10-20 07:56:45','');
[10/20/2020 07:56:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-20 07:56:45',`log_type`= 'Tax Configuration',`sql_query`= 'INSERT INTO `tax_configuration` (`branch_country`, `branch_state`, `valid_from`, `valid_to`, `supplier_registered`,`supplier_country`,`supplier_type` , `service`, `sub_service`, `exempted`,`consumed`,`has_consumed_location`, `type`,`system`, `input_tax_id`, `input_tax_amt`,`output_tax_id`, `output_tax_amt`,`created_by`,`created_on`,`branch`) VALUES (\&#039;132\&#039;,\&#039;\&#039;, \&#039;2020-10-21\&#039;, \&#039;2050-12-31\&#039;, \&#039;1\&#039;, \&#039;0\&#039;,\&#039;substitute\&#039;, \&#039;1\&#039;, \&#039;\&#039;, \&#039;0\&#039;,\&#039;IB\&#039; , \&#039;0\&#039; , \&#039;IN\&#039;, \&#039;b2b\&#039;, \&#039;0\&#039;, \&#039;\&#039;, \&#039;4\&#039;, \&#039;3.5\&#039;,\&#039;tfg\&#039;,\&#039;2020-10-20 07:56:45\&#039;,\&#039;\&#039;)',`log_description`= 'Tax Configuration added',`ip`= '43.250.210.76';
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='3024', agent_id ='9', itenirary_id ='3', sequence = '3', confirmation_number ='', payment_confirmation_no ='', voucher_id ='testbooking', voucher_hashcode ='2dcd5f5e56e3bf654d0e715f0a6d5134366043024', email_id ='', leader_title ='Ms', leader_first_name ='Ankita', leader_last_name ='Rao', city_id ='Colombo', country_id ='132', display_room_rate ='214.000', native_room_rate ='200.000', native_currency_code ='INR', additional_charge ='0.000', cancellation_policy ='', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='0', status_date ='2020-10-20 07:52:05', create_date ='2020-10-20 07:51:41', source_type ='localsystem', expiration_date ='2020-10-20 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='Marino Beach Colombo', native_rate ='', display_rate ='', agent_rate ='214.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='200.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='7', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='7', wh_agent_markup ='0.000', basecurrency_multiplier ='0.01533', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='0.01533', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2020-10-20 07:57:45', modified_by ='tfg', display_currency_code ='INR', created_datetime ='2020-10-20 07:57:45', sub_agent_rate ='0.000', discount_to_sub ='0', created_by ='tfg', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='';
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='1165', old_reff_id ='527', booking_id ='3024', supplier_id ='S000000071', total_nights ='1', arrival_date ='2020/11/24', departure_date ='2020/11/25', hotel_id ='53699', hotel_name ='Marino Beach Colombo', hotel_address1 ='', hotel_phone ='', hotel_rating ='5.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '6336', old_reff_id = '527', booking_id = '3024', booking_detail_id = '1165', salutations = 'Ms', room = '0', rid = '1749', first_name = 'Ankita', last_name = 'Rao' ,passenger_type = 'adult' ,age = '';
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '1749', old_reff_id = '527', booking_id = '3024', booking_detail_id = '1165', room_type_code = '1~~~142~~~653~~~2~~~~~~~~~71100~~~0~~~S000000071', room_name = 'single', room_type_description = 'Colonial Manssion - 01 - Half Board', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";d:214;}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:6:"200.00";}}' ,native_room_rate_total = '200' ,display_room_rate_total = '214' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3024', booking_detail_id = '1165', room_type_code = '1~~~142~~~653~~~2~~~~~~~~~71100~~~0~~~S000000071', room_name = 'single', meal_basis = 'Half Board', room_type_description = 'Colonial Manssion - 01 - Half Board', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"214";s:13:"whNightlyRate";s:0:"";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:6:"200.00";}}' ,native_room_rate_total = '200' ,display_room_rate_total = '214' ,number_of_rooms = '1';
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3024', booking_detail_id = '1165', salutations = 'Ms', room = '', rid = '1750', first_name = 'Ankita', last_name = 'Rao' ,age = '';
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='',native_currency_code='INR',display_currency_code='INR',cancellation_policy='                                ',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='7',agent_markup='7',consultant_id='tfg',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='0.01533'_native,agent_currency_multiplier='1.00000',service_type_detail='Marino Beach Colombo',current_status='vouchered',status_date='2020-10-20 07:57:45',service_date='2020-11-24',check_out_date='2020-11-25',display_room_rate= '214',display_discount='0.000',modified_datetime='2020-10-20 07:57:45',modified_by ='tfg',native_room_rate='200',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Ms',leader_first_name='Ankita',leader_last_name='Rao',nationality ='Indian',accounts_processed ='0',booking_type ='offline',agent_ref_no ='',supplier_profile_id ='1',expiration_date= '2020-10-20 00:00:00',source_type='localsystem',leader_phone='',admin_note='',comment_contract='' WHERE id='3024';
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-20 07:57:45',`log_type`= 'Accounts Data Added',`sql_query`= '',`log_description`= 'Accounts Only : Data Added by \&#039;tfg\&#039; From IP \&#039;43.250.210.76\&#039; for booking \&#039;3024\&#039;',`ip`= '43.250.210.76';
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings set  parent_agent_id='9', sub_agent_rate='', agent_rate='214', agent_markup='7', supplier_rate='200', wh_sub_agent_rate='', discount_to_sub='', wh_agent_rate='' where id='3024';
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'S000000071' , total_rooms= '1', arrival_date='2020/11/24', departure_date='2020/11/25', rate_code='~', hotel_address1='', hotel_name='Marino Beach Colombo', hotel_phone='' where booking_id ='3024';
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3024','vouchered','2020-10-20 07:57:45','Booking Modified by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1491;
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO accounts_invoice_transaction SET bid= '1491',booking_id= '3024',invoice_number= '2020/387',service_type= 'hotel',booking_type= 'offline',service_name= 'Marino Beach Colombo',type= 'sale',room_type= 'single',quantity_room= '1',from_date= '2020/11/24',to_date= '2020/11/25',quantity= '1',price= '214',total_price= '214';
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update booking_rate_info set acc_export='0' WHERE booking_id='3024' AND (acc_type='purchase' OR  acc_type='sale');
[10/20/2020 07:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update booking_currency_multiplier set multiplier='1.00000' where booking_id='3024' and from_currency='INR' and to_currency='INR';
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='3024', agent_id ='9', itenirary_id ='3', sequence = '3', confirmation_number ='', payment_confirmation_no ='', voucher_id ='testbooking', voucher_hashcode ='2dcd5f5e56e3bf654d0e715f0a6d5134366043024', email_id ='', leader_title ='Ms', leader_first_name ='Ankita', leader_last_name ='Rao', city_id ='Colombo', country_id ='132', display_room_rate ='214.000', native_room_rate ='200.000', native_currency_code ='INR', additional_charge ='0.000', cancellation_policy ='                                ', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='0', status_date ='2020-10-20 07:57:45', create_date ='2020-10-20 07:51:41', source_type ='localsystem', expiration_date ='2020-10-20 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='Marino Beach Colombo', native_rate ='', display_rate ='', agent_rate ='214.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='200.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='7', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='7', wh_agent_markup ='0.000', basecurrency_multiplier ='0.01533', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='0.01533', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2020-10-20 07:57:46', modified_by ='tfg', display_currency_code ='INR', created_datetime ='2020-10-20 07:57:46', sub_agent_rate ='0.000', discount_to_sub ='', created_by ='tfg', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='';
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='1165', old_reff_id ='528', booking_id ='3024', supplier_id ='S000000071', total_nights ='1', arrival_date ='2020/11/24', departure_date ='2020/11/25', hotel_id ='53699', hotel_name ='Marino Beach Colombo', hotel_address1 ='', hotel_phone ='', hotel_rating ='5.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '6337', old_reff_id = '528', booking_id = '3024', booking_detail_id = '1165', salutations = 'Ms', room = '0', rid = '1750', first_name = 'Ankita', last_name = 'Rao' ,passenger_type = 'adult' ,age = '';
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '1750', old_reff_id = '528', booking_id = '3024', booking_detail_id = '1165', room_type_code = '1~~~142~~~653~~~2~~~~~~~~~71100~~~0~~~S000000071', room_name = 'single', room_type_description = 'Colonial Manssion - 01 - Half Board', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"214";s:13:"whNightlyRate";s:0:"";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:6:"200.00";}}' ,native_room_rate_total = '200' ,display_room_rate_total = '214' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3024', booking_detail_id = '1165', room_type_code = '1~~~142~~~653~~~2~~~~~~~~~71100~~~0~~~S000000071', room_name = 'single', meal_basis = 'Half Board', room_type_description = 'Colonial Manssion - 01 - Half Board', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"214";s:13:"whNightlyRate";s:0:"";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:6:"200.00";}}' ,native_room_rate_total = '200' ,display_room_rate_total = '214' ,number_of_rooms = '1';
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3024', booking_detail_id = '1165', salutations = 'Ms', room = '', rid = '1751', first_name = 'Ankita', last_name = 'Rao' ,age = '';
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='',native_currency_code='INR',display_currency_code='INR',cancellation_policy='                                ',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='7',agent_markup='7',consultant_id='tfg',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='0.01533'_native,agent_currency_multiplier='1.00000',service_type_detail='Marino Beach Colombo',current_status='vouchered',status_date='2020-10-20 07:57:46',service_date='2020-11-24',check_out_date='2020-11-25',display_room_rate= '214',display_discount='0.000',modified_datetime='2020-10-20 07:57:46',modified_by ='tfg',native_room_rate='200',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Ms',leader_first_name='Ankita',leader_last_name='Rao',nationality ='Indian',accounts_processed ='0',booking_type ='offline',agent_ref_no ='',supplier_profile_id ='1',expiration_date= '2020-10-20 00:00:00',source_type='localsystem',leader_phone='',admin_note='',comment_contract='' WHERE id='3024';
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-20 07:57:46',`log_type`= 'Accounts Data Added',`sql_query`= '',`log_description`= 'Accounts Only : Data Added by \&#039;tfg\&#039; From IP \&#039;43.250.210.76\&#039; for booking \&#039;3024\&#039;',`ip`= '43.250.210.76';
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings set  parent_agent_id='9', sub_agent_rate='', agent_rate='214', agent_markup='7', supplier_rate='200', wh_sub_agent_rate='', discount_to_sub='', wh_agent_rate='' where id='3024';
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'S000000071' , total_rooms= '1', arrival_date='2020/11/24', departure_date='2020/11/25', rate_code='~', hotel_address1='', hotel_name='Marino Beach Colombo', hotel_phone='' where booking_id ='3024';
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3024','vouchered','2020-10-20 07:57:46','Booking Modified by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1491;
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO accounts_invoice_transaction SET bid= '1491',booking_id= '3024',invoice_number= '2020/387',service_type= 'hotel',booking_type= 'offline',service_name= 'Marino Beach Colombo',type= 'sale',room_type= 'single',quantity_room= '1',from_date= '2020/11/24',to_date= '2020/11/25',quantity= '1',price= '214',total_price= '214';
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update booking_rate_info set acc_export='0' WHERE booking_id='3024' AND (acc_type='purchase' OR  acc_type='sale');
[10/20/2020 07:57:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update booking_currency_multiplier set multiplier='1.00000' where booking_id='3024' and from_currency='INR' and to_currency='INR';
[10/20/2020 07:58:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET agency_name= 'Qtech',other_language_agency_name= '',accounting_id= '12345',auto_voucher_bookings = '1',outstanding_limit = '0',accounting_name= '',first_name= 'Arvind',middle_name= '',last_name= 'Pandey',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '100000',credit_limit= '100000',credit_distribution= '0',temp_credit_limit= '',address= 'Goregaon',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '0',enable_dst= '',branch_id='1',phone= '91-69849879',mobile= '91-8898423090',fax= '',currency= '4',email= 'ankita.rao@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '1',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_voucher= '1',allow_book_under_cancellation='1',modify_date='2020-10-20 07:58:56',consultant_id= 'nitinalpha',agency_email= '',acc_name= 'ARVIND ACCOUNT',acc_email= 'ankita.rao@qtechsoftware.com',acc_phone= '',man_name= 'JIGNESH SONI',man_email= 'ankita.rao@qtechsoftware.com',man_phone= '',res_name= 'ARVIND',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '',agent_category= '2',can_show_hotels= '' WHERE id= '9';
[10/20/2020 07:58:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-20 07:58:56',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;Qtech\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_id= \&#039;12345\&#039;,auto_voucher_bookings = \&#039;1\&#039;,outstanding_limit = \&#039;0\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Arvind\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;Pandey\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;100000\&#039;,credit_limit= \&#039;100000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;Goregaon\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;0\&#039;,enable_dst= 0,branch_id=\&#039;1\&#039;,phone= \&#039;91-69849879\&#039;,mobile= \&#039;91-8898423090\&#039;,fax= \&#039;\&#039;,currency= \&#039;4\&#039;,email= \&#039;ankita.rao@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= 1,debug= \&#039;1\&#039;,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= \&#039;\&#039;,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= \&#039;1\&#039;,allow_book_under_cancellation=\&#039;1\&#039;,modify_date=\&#039;2020-10-20 07:58:56\&#039;,consultant_id= \&#039;nitinalpha\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;ARVIND ACCOUNT\&#039;,acc_email= \&#039;ankita.rao@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;JIGNESH SONI\&#039;,man_email= \&#039;ankita.rao@qtechsoftware.com\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;ARVIND\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= \&#039;\&#039;,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0,agent_category= \&#039;2\&#039;,can_show_hotels= 0 WHERE id= \&#039;9\&#039;',`log_description`= 'Agent 9 updated For  - email=arvind.pandey%40qtechsoftware.com&modify_date=2020-10-17+08%3A27%3A40&acc_email=arvind.pandey%40qtechsoftware.com&man_email=jignesh%40qtechsoftware.com changed to - email=ankita.rao%40qtechsoftware.com&modify_date=2020-10-20+07%3A58%3A56&acc_email=ankita.rao%40qtechsoftware.com&man_email=ankita.rao%40qtechsoftware.com',`ip`= '43.250.210.76';
[10/20/2020 07:58:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3769', `entity`='Agents', `value`='9' ;
[10/20/2020 07:58:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'9' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[10/20/2020 07:58:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into  agent_credit_log SET agent_id= '9',credit_value= '19753.000',credit_usage= '80247.000',credit_limit= '100000',receipt_id= '',amount= '',ip='43.250.210.76',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by tfg',create_date='2020-10-20 07:10:56';
[10/20/2020 07:58:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET currency= '4',branch_id= '1',consultant_id= 'nitinalpha',sales_manager_id= '',profile= '', auto_voucher_bookings = '1', outstanding_limit = '0', agent_type= 'CC' WHERE parent_agent= '9';
