[08/04/2020 10:45:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/special_request.php],INSERT INTO `special_request` (`name` ,`status`) VALUES ('Special Request Changes','A');
[08/04/2020 10:45:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/special_request.php],UPDATE special_request SET status='I' WHERE specialrequest_id=?;
[08/04/2020 10:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/special_request.php],UPDATE special_request SET status='A' WHERE specialrequest_id= ?;
[08/04/2020 10:46:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent_category.php],UPDATE agent_categories SET status='D' WHERE id= '5';
[08/04/2020 10:46:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent_category.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 10:46:25',`log_type`= 'Agent Category Mapping',`sql_query`= 'UPDATE agent_categories SET status=\&#039;D\&#039; WHERE id= \&#039;5\&#039;',`log_description`= 'A Manual Agent Category Mapping has been Deleted',`ip`= '45.120.147.56';
[08/04/2020 10:51:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into email_logs SET `subject`= 'TFG102786 Proforma',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 34080 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/resend_email.php?action=send_custom_booking_email',create_date= '2020-08-04 10:51:03';
[08/04/2020 10:52:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent_category.php],UPDATE agent_categories SET status='D' WHERE id= '5';
[08/04/2020 10:52:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent_category.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 10:52:18',`log_type`= 'Agent Category Mapping',`sql_query`= 'UPDATE agent_categories SET status=\&#039;D\&#039; WHERE id= \&#039;5\&#039;',`log_description`= 'A Manual Agent Category Mapping has been Deleted',`ip`= '45.120.147.56';
[08/04/2020 10:53:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT INTO history_bookings set history_booking_id ='2792', reservation_id ='QTECH2020071675', agent_id ='25', itenirary_id ='4', confirmation_number ='', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='', leader_title ='Ms', leader_first_name ='Snehal', leader_last_name ='Test1', city_id ='Mumbai', country_id ='106', display_room_rate ='3.070', native_room_rate ='200.000', display_discount ='0.000', native_discount ='0.000', native_currency_code ='INR', additional_charge ='0.000', cancellation_policy ='', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='0', status_date ='2020-08-04 07:38:52', create_date ='2020-08-04 07:38:52', source_type ='misc', expiration_date ='2020-08-07 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='misc', service_type_detail ='Breakfast', native_rate ='', display_rate ='', agent_rate ='3.070', 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 ='0.01533', applied_markup ='0', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='0', wh_agent_markup ='0.000', basecurrency_multiplier ='1', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='0.01533', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1', wh_agent_currency_multiplier ='1.000', modified_datetime ='2020-08-04 :10:53:42', modified_by ='tfg', service_date ='2020-08-08', display_currency_code ='USD', created_datetime ='2020-08-04 10:53:42', sub_agent_rate ='0.000', created_by ='tfg', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='150.129.30.134';
[08/04/2020 10:53:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT INTO history_misc_bookings SET  old_ref_id ='511', history_booking_id='2792', service_name='Breakfast', title='Ms', first_name='Snehal', last_name='Test1', email_id='', internal_reference='', no_of_adults='0', no_of_child='0', country='106', city='Mumbai', book_for='Misc', no_of_services='1', from_date='2020-08-08', to_date='2020-08-08', preferred_time='Full Day', instructions='', supplier_id='S000000068';
[08/04/2020 10:53:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],UPDATE bookings SET reservation_id = 'QTECH2020071675' ,agent_id = '25' ,backoffice_user = 'tfg' ,city_id = 'Mumbai' ,country_id = '106' ,leader_title = 'Ms' ,leader_first_name = 'Snehal' ,leader_last_name = 'Test1' ,nationality = 'Indian' ,display_room_rate = '3.07' ,native_discount = '0' ,display_discount = '0' ,display_currency_code = 'USD' ,native_room_rate = '200.00' ,native_currency_code = 'INR' ,current_status = 'confirmed' ,status_date = '2020-08-04 10:53:42' ,create_date = '2020-08-04 10:53:42' ,source_type = 'misc' ,service_type = 'misc' ,consultant_id = 'tfg' ,sales_manager_id = '' ,applied_multiplier = '0.01533' ,basecurrency_multiplier = '1' ,basecurrency_multiplier_native = '0.01533' ,agent_currency_multiplier = '1' ,created_datetime = '2020-08-04 10:53:42' ,created_by = 'tfg' ,ip_addr = '60.254.42.39' ,booking_type= 'offline', applied_markup = '0' ,agent_markup = '0' ,supplier_rate = '200.00' ,agent_rate = '3.07' ,parent_agent_id = '25' ,booking_branch_id = '1' ,service_type_detail = 'Breakfast' ,unit_type = 'Per Room/Per Night' ,unit = '1' ,unit_rate = '150/0' ,check_out_date = '2020-08-09' ,service_date = '2020-08-09' WHERE id= '2792' ;
[08/04/2020 10:53:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],UPDATE misc_bookings SET booking_id = '2792' ,service_name = 'Breakfast' ,country = '106' ,title = 'Ms' ,first_name = 'Snehal' ,last_name = 'Test1' ,city = 'Mumbai' ,book_for = 'Misc' ,no_of_services = '1' ,from_date = '2020-08-09' ,to_date = '2020-08-09' ,service_tax_id = '4' ,sub_service_id = '3' ,hotel_id = '' ,no_of_adults = '' ,no_of_child = '' ,no_of_infant = '' ,supplier_adult_rate = '200.000' ,supplier_child_rate = '' ,supplier_infant_rate = '' ,agent_adult_rate = '3.070' ,agent_child_rate = '' ,agent_infant_rate = '' ,supplier_id  = 'S000000068' WHERE mid= '439' ;
[08/04/2020 10:53:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],DELETE FROM passangers WHERE booking_id='2792';
[08/04/2020 10:53:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2792','confirmed','2020-08-04 10:53:43','Offline Addtional Service Booking by tfg','tfg','60.254.42.39','tfg','','');
[08/04/2020 10:56:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into email_logs SET `subject`= 'Invoice :2020/364',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 26388 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/resend_email.php?action=send_custom_booking_email',create_date= '2020-08-04 10:56:31';
