[08/12/2022 11:01:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_local_supplier.php],INSERT INTO psa_users set updated='2022-08-12 11:01:28' ,lname='' ,fname='samyak' ,mname='' ,email='' ,phone='7047902791' ,time_zone_offset='0' ,enable_dst='' ,id='samyak' ,pass='43687d8e7802895efce60ccbaac9c702' ,hash='2984b54e7daaaf73f72712cddd011b8f' ,groups='6,7' ,active='Y' ,expiration='' ,branch_id='' ,can_debug='' ,allow_book_under_cancellation='' ,allow_cancellation_after_voucher='' ,all_bookings='' ,user_type='supplier' ,site_id='' ;
[08/12/2022 11:01:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_local_supplier.php],INSERT INTO psa_pass_recover (question, answer, id) VALUES ('', '', '2984b54e7daaaf73f72712cddd011b8f');


[08/12/2022 11:01:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1660302103','43.239.53.130');
[08/12/2022 11:02:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1660302124','43.239.53.130');
[08/12/2022 11:07:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO bookings SET agent_id = '8' , service_type = 'hotel' , reservation_id = '2005' , display_currency_code = 'INR' , created_datetime='2022-08-12 11:07:20' , create_date='2022-08-12 11:07:20' , created_by ='tfg' , sales_manager_id ='' , consultant_id = 'tfg' , backoffice_user = 'tfg', city_id='Dubai', country_id='138', leader_title='Mr', leader_first_name='samyak', leader_last_name='jain', nationality='Indian', site_id='0', supplier_profile_id='3', comment_contract='', supplier_cancellation_policy='', special_remark='', source_type='localsystem', booking_type='offline', booking_branch_id='1', service_type_detail='ADAGIO APART HOTEL PREMIUM DUBAI AL BARSHA';
[08/12/2022 11:07:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3170'
        ;
[08/12/2022 11:07:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into bookings_details set booking_id ='3170' , hotel_id='19623' , hotel_name='ADAGIO APART HOTEL PREMIUM DUBAI AL BARSHA' , hotel_address1='Off Sharaf DG Metro Station, Sheikh Zayed Road, Al ' , hotel_phone='0097145017555' , hotel_rating='5.0';
[08/12/2022 11:07:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3170', booking_detail_id = '1270', 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:"100";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:3:"100";}}' ,native_room_rate_total = '100' ,display_room_rate_total = '100' ,number_of_rooms = '1';
[08/12/2022 11:07:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3170', booking_detail_id = '1270', salutations = 'Mr', room = '', rid = '1880', first_name = 'samyak', last_name = 'jain' ,age = '';
[08/12/2022 11:07:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='214',voucher_id='',voucher_hashcode='',native_currency_code='INR',cancellation_policy='Cancellation or charges made on/after 09-08-2022 will be subject to FULL CHARGE.',supplier_cancellation_policy='',applied_multiplier='1',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-08-12 11:07:20',service_date='2022-08-12',check_out_date='2022-08-13',display_room_rate= '100',display_discount='0',native_room_rate= '100',native_discount='0',additional_charge='',expiration_date= '2022-08-09 05:30:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='3170';
[08/12/2022 11:07:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings set  parent_agent_id='8', sub_agent_rate='', agent_rate='100', applicable_service_tax='', agent_markup='0', supplier_rate='100' where id='3170';
[08/12/2022 11:07:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1',supplier_id= 'S000000249',arrival_date='2022/08/12',departure_date='2022/08/13',rate_code='~',total_rooms= '1',total_adults= '1',total_children= '0',total_infants= '0' where booking_id ='3170';
[08/12/2022 11:07:20], [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
        ('','','3170','confirmed','2022-08-12 11:07:20','confirmed by tfg','tfg','43.239.53.130','tfg','','');
[08/12/2022 11:09:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3170','samyak.jain@qtechsoftware.com');
[08/12/2022 11:09:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3170','samyak.jain@qtechsoftware.com');
[08/12/2022 11:09:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into email_logs SET `subject`= ' TFG103170 /  Booking Confirmed ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 36592 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-08-12 11:09:57';
