[05/06/2022 07:02:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into agents SET admin_id= 'Qtech',username= 'Altaf_test',accounting_id= '123',executive_id= '',agency_name= 'Qtech',other_language_agency_name= '',first_name= 'Altaf',middle_name= '',last_name= 'Shaikh',agent_type= 'CS',sort_type= 'price',credit_limit_assigned= '0',credit_limit= '0',credit_value= '0',credit_usage='0',temp_credit_limit= '',address= 'test',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '5.5',enable_dst= '',branch_id='1',phone= '91-9999999999',mobile= '91-9999999999',fax= '',credit_distribution= '0',currency= '4',email= 'altaf.shaikh@qtechsoftware.com',website= '',password= 'f67fdd8b3aa1471c4f154b471472efe69b37c52f68e556335d715da4fb75d2bc',lead_time= '',debug= '1',search_by_multicurrency= '1',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= 'Travel Agent',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '',can_voucher= '1',markup= '',allow_book_under_cancellation='1',create_date='2022-05-06 07:02:10',modify_date='2022-05-06 07:02:10',consultant_id= 'nitinalpha',agency_email= '',expiry_date= '2022-08-04 07:02:10',acc_name= 'ALTAF',acc_email= 'altaf.shaikh@qtechsoftware.com',acc_phone= '',man_name= 'Qtech',man_email= '',man_phone= '',res_name= 'QTECH',res_email= '',res_phone= '',ip_addr= '103.104.226.130',apply_service_tax= 'no',allow_ticketing= '',agent_category= '2',site_id='0',wh_main_agent='',wh_agent='no',remarks= '',logo='',auto_voucher_bookings = '0',outstanding_limit = '0',status='A';
[05/06/2022 07:02:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'29' , cal_hashcode='b9eeb74'29'9915acb'29'cd67'29'ce4921d6dfca73612ac9d7'29'3417'29'87adc9'29'e87411cf' ,cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ? and site_id = ''29'';
[05/06/2022 07:02:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into email_logs SET `subject`= 'Registration Acknowledgement - Agent ID - 29 The Fabulous Getaway',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 21372 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,altaf.shaikh@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/agent.php?branch_search=&consultant_search=&agent_type_search=&country_srch=&agency_name_search=&username_search=&status_search=&person_name_search=&search=&country_search=&city_search=&currency_search=&rate_profile_search=&email_search=&agency_id_search=',create_date= '2022-05-06 07:02:11';
[05/06/2022 07:02:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1651820556','103.104.226.130');
[05/06/2022 07:03:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1651820584','103.104.226.130');
[05/06/2022 07:05:39], [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 = '1983' , display_currency_code = 'INR' , created_datetime='2022-05-06 07:05:39' , create_date='2022-05-06 07:05:39' , created_by ='tfg' , sales_manager_id ='' , consultant_id = 'tfg' , backoffice_user = 'tfg', city_id='Mumbai', country_id='106', leader_title='Mr', leader_first_name='Altaf', leader_last_name='Tester', 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=' Grand Hyatt Mumbai';
[05/06/2022 07:05:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3159'
        ;
[05/06/2022 07:05:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into bookings_details set booking_id ='3159' , hotel_id='47690' , hotel_name=' Grand Hyatt Mumbai' , hotel_address1='' , hotel_phone='' , hotel_rating='';
[05/06/2022 07:05:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3159', booking_detail_id = '1259', 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:4:"6780";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:3:"113";}}' ,native_room_rate_total = '113' ,display_room_rate_total = '6780' ,number_of_rooms = '1';
[05/06/2022 07:05:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3159', booking_detail_id = '1259', salutations = 'Mr', room = '', rid = '1866', first_name = 'Altaf', last_name = 'Tester' ,age = '';
[05/06/2022 07:05:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7787',voucher_id='',voucher_hashcode='',native_currency_code='USD',cancellation_policy='Cancellation or charges made on/after 03-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-05-06 07:05:39',service_date='2022-05-06',check_out_date='2022-05-07',display_room_rate= '6780',display_discount='0',native_room_rate= '113',native_discount='0',additional_charge='',expiration_date= '2022-05-03 05:30:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='3159';
[05/06/2022 07:05:39], [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='6780', applicable_service_tax='', agent_markup='0', supplier_rate='113' where id='3159';
[05/06/2022 07:05:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1',supplier_id= 'S000000057',arrival_date='2022/05/06',departure_date='2022/05/07',rate_code='~',total_rooms= '1',total_adults= '1',total_children= '0',total_infants= '0' where booking_id ='3159';
[05/06/2022 07:05:39], [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
        ('','','3159','confirmed','2022-05-06 07:05:39','confirmed by tfg','tfg','103.104.226.130','tfg','','');
