[06/01/2022 10:23:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3159','altaf.shaikh@qtechsoftware.com');
[06/01/2022 10:23:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3159','ankita.rao@qtechsoftware.com');
[06/01/2022 10:24:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3163','altaf.shaikh@qtechsoftware.com');
[06/01/2022 10:24:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3163','ankita.rao@qtechsoftware.com');
[06/01/2022 10:24:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3160','snehal.valanju@qtechsoftware.com');
[06/01/2022 10:24:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3160','ankita.rao@qtechsoftware.com');
[06/01/2022 10:24:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3163','altaf.shaikh@qtechsoftware.com');
[06/01/2022 10:24:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3163','ankita.rao@qtechsoftware.com');
[06/01/2022 10:36:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/daily_email.php],insert into temp(booking_id,mail_send_to)values('3160','snehal.valanju@qtechsoftware.com');
[06/01/2022 10:36:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/daily_email.php],insert into temp(booking_id,mail_send_to)values('3160','ankita.rao@qtechsoftware.com');
[06/01/2022 10:36:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1654079802','106.194.131.190');
[06/01/2022 10:37:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1654079824','106.194.131.190');
[06/01/2022 10:39:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO bookings SET agent_id = '29' , service_type = 'hotel' , reservation_id = '1994' , display_currency_code = 'INR' , created_datetime='2022-06-01 10:39:41' , create_date='2022-06-01 10:39:41' , created_by ='tfg' , sales_manager_id ='' , consultant_id = 'tfg' , backoffice_user = 'tfg', city_id='Mumbai', country_id='106', leader_title='Mr', leader_first_name='samyak', leader_last_name='jain', nationality='Afghanistan', 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=' Fab Hotel Crawford Inn South Mumbai';
[06/01/2022 10:39:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3164'
        ;
[06/01/2022 10:39:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into bookings_details set booking_id ='3164' , hotel_id='47832' , hotel_name=' Fab Hotel Crawford Inn South Mumbai' , hotel_address1='' , hotel_phone='8770967336' , hotel_rating='';
[06/01/2022 10:39:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3164', booking_detail_id = '1264', room_type_code = '', room_name = 'single', meal_basis = '', room_category = 'Single', room_type_description = 'Single', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";s:3:"300";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:1:"5";}}' ,native_room_rate_total = '5' ,display_room_rate_total = '300' ,number_of_rooms = '1';
[06/01/2022 10:39:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3164', booking_detail_id = '1264', salutations = 'Mr', room = '', rid = '1872', first_name = 'rgf', last_name = 'gdfh' ,age = '';
[06/01/2022 10:39:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='1243333',voucher_id='',voucher_hashcode='',native_currency_code='USD',cancellation_policy='Cancellation or charges made on/after 29-05-2022 will be subject to FULL CHARGE.',supplier_cancellation_policy='',applied_multiplier='60',applied_markup='0',consultant_id='tfg',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='0.01533'_native,agent_currency_multiplier='1',current_status='confirmed',status_date='2022-06-01 10:39:41',service_date='2022-06-01',check_out_date='2022-06-02',display_room_rate= '300',display_discount='0',native_room_rate= '5',native_discount='0',additional_charge='',expiration_date= '2022-05-29 05:30:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='3164';
[06/01/2022 10:39:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings set  parent_agent_id='29', sub_agent_rate='', agent_rate='300', applicable_service_tax='', agent_markup='0', supplier_rate='5' where id='3164';
[06/01/2022 10:39:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1',supplier_id= 'S000000001',arrival_date='2022/06/01',departure_date='2022/06/02',rate_code='~',total_rooms= '1',total_adults= '1',total_children= '0',total_infants= '0' where booking_id ='3164';
[06/01/2022 10:39:41], [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
        ('','','3164','confirmed','2022-06-01 10:39:41','confirmed by tfg','tfg','106.194.131.190','tfg','','');
[06/01/2022 10:40:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3164','altaf.shaikh@qtechsoftware.com');
[06/01/2022 10:40:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3164','ankita.rao@qtechsoftware.com');
[06/01/2022 10:41:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into email_logs SET `subject`= ' TFG103164 /  Booking Confirmed ',from_email_id= 'samyak.jain@qtechsoftware.com',body= '[encoded data, 26276 characters]',to_email_id= 'sanjay.soni@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/resend_email.php?action=send_custom_booking_email',create_date= '2022-06-01 10:41:42';
[06/01/2022 10:42:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3164','altaf.shaikh@qtechsoftware.com');
[06/01/2022 10:42:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3164','ankita.rao@qtechsoftware.com');
[06/01/2022 10:43:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into email_logs SET `subject`= ' TFG103164 /  Booking Confirmed ',from_email_id= 'sanjay.soni@qtechsoftware.com',body= '[encoded data, 26276 characters]',to_email_id= 'samyak.jain@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/resend_email.php?action=send_custom_booking_email',create_date= '2022-06-01 10:43:53';
[06/01/2022 10:46:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3164','altaf.shaikh@qtechsoftware.com');
[06/01/2022 10:46:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3164','ankita.rao@qtechsoftware.com');
[06/01/2022 10:49:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2022-06-01 10:49:12',login_attempt=0 where id = '29';
[06/01/2022 10:49:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'Altaf_test', user_type = 'A', branch_id = '1', login_datetime = '2022-06-01 10:49:12', ip = '106.194.131.190', action = 'Login' ;
[06/01/2022 10:50:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2022-06-01 10:50:42',login_attempt=0 where id = '28';
[06/01/2022 10:50:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'altaf', user_type = 'A', branch_id = '1', login_datetime = '2022-06-01 10:50:42', ip = '106.194.131.190', action = 'Login' ;
[06/01/2022 10:51:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[06/01/2022 10:51:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '28',supplier_id = '1' ,status = '1' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[06/01/2022 10:51:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '28',supplier_id = '6' ,status = '' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[06/01/2022 10:51:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '28',supplier_id = '3' ,status = '' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[06/01/2022 10:51:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '28',supplier_id = '2' ,status = '1' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[06/01/2022 10:51:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '28',supplier_id = '4' ,status = '' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[06/01/2022 10:51:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '28',supplier_id = '5' ,status = '' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[06/01/2022 10:51:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2022-06-01 10:51:10',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = :agent_id,supplier_id = :supplier_id ,status = :status ,priority = :priority ,branch_id = :branch_id,percentage = :percentage,visible_supplier_on_voucher = :visible_supplier_on_voucher,lead_time = :lead_time======INSERT INTO agent_supplier_settings SET agent_id = :agent_id,supplier_id = :supplier_id ,status = :status ,priority = :priority ,branch_id = :branch_id,percentage = :percentage,visible_supplier_on_voucher = :visible_supplier_on_voucher,lead_time = :lead_time======INSERT INTO agent_supplier_settings SET agent_id = :agent_id,supplier_id = :supplier_id ,status = :status ,priority = :priority ,branch_id = :branch_id,percentage = :percentage,visible_supplier_on_voucher = :visible_supplier_on_voucher,lead_time = :lead_time======INSERT INTO agent_supplier_settings SET agent_id = :agent_id,supplier_id = :supplier_id ,status = :status ,priority = :priority ,branch_id = :branch_id,percentage = :percentage,visible_supplier_on_voucher = :visible_supplier_on_voucher,lead_time = :lead_time======INSERT INTO agent_supplier_settings SET agent_id = :agent_id,supplier_id = :supplier_id ,status = :status ,priority = :priority ,branch_id = :branch_id,percentage = :percentage,visible_supplier_on_voucher = :visible_supplier_on_voucher,lead_time = :lead_time======INSERT INTO agent_supplier_settings SET agent_id = :agent_id,supplier_id = :supplier_id ,status = :status ,priority = :priority ,branch_id = :branch_id,percentage = :percentage,visible_supplier_on_voucher = :visible_supplier_on_voucher,lead_time = :lead_time',`log_description`= 'Supplier setting updated  ',`ip`= '106.194.131.190';
[06/01/2022 10:51:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='4206', `entity`='Agents', `value`='28' ;
[06/01/2022 10:52:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '28' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '106.194.131.190' , city = 'dubai' , service_name = '' , service_type = 'hotel' , arrival_date = '2022/06/01' , departure_date = '2022/06/02' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2022-06-01 10:52:25' , site_id = '' , country_code = '138' , web_service = '' ;
[06/01/2022 10:52:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=28&sessionid=3080bc1ef0e5383bee71816df1363cce1a160fc0cfdcdb49c0950b5a675b2dbf',
  duration = '0.262',
  merge_duration = '0.066',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.47',
  system_load_5_min = '1.47',
  system_load_15_min = '1.43',
  system_memory_usage = '94.91',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '12') + '8244304',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '12';
[06/01/2022 10:52:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '28' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '106.194.131.190' , city = 'dubai' , service_name = '' , service_type = 'hotel' , arrival_date = '2022/06/01' , departure_date = '2022/06/02' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2022-06-01 10:52:37' , site_id = '' , country_code = '138' , web_service = '' ;
[06/01/2022 10:52:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=28&sessionid=3080bc1ef0e5383bee71816df1363cce1a160fc0cfdcdb49c0950b5a675b2dbf',
  duration = '0.265',
  merge_duration = '0.058',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.47',
  system_load_5_min = '1.47',
  system_load_15_min = '1.43',
  system_memory_usage = '94.86',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '13') + '8244720',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '13';
[06/01/2022 10:54:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/daily_email.php],insert into temp(booking_id,mail_send_to)values('3164','altaf.shaikh@qtechsoftware.com');
[06/01/2022 10:54:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/daily_email.php],insert into temp(booking_id,mail_send_to)values('3164','ankita.rao@qtechsoftware.com');
[06/01/2022 10:56:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1654080993','106.194.131.190');
[06/01/2022 10:57:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1654081021','106.194.131.190');
