[08/10/2020 06:37:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set login_attempt ='1'  where id = '25';
[08/10/2020 06:37:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],insert into invalid_login SET ip='103.104.226.130', username='PhpTest',create_date='2020-08-10 06:37:35',referrer='http://uat.tfg.otrams.net/',type='agents';
[08/10/2020 06:38:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set login_attempt ='2'  where id = '25';
[08/10/2020 06:38:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],insert into invalid_login SET ip='45.120.147.56', username='PhpTest',create_date='2020-08-10 06:38:11',referrer='http://uat.tfg.otrams.net/index.php?Msg=1',type='agents';
[08/10/2020 06:40:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-08-10 06:40:01',login_attempt=0 where id = '25';
[08/10/2020 06:40:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PhpTest', user_type = 'A', branch_id = '1', login_datetime = '2020-08-10 06:40:01', ip = '45.120.147.56', action = 'Login' ;
[08/10/2020 06:44:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '45.120.147.56' , city = 'Mumbai' , arrival_date='2020/08/27',  departure_date='2020/08/27',  nights='1',  create_date='2020-08-10 :06:44:40',  nationality='106',  additional_markup='',  selected_currency='USD',  service_type='transfer',  total_adult='1',  total_children='',  site_id = '' ;
[08/10/2020 06:44:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1597041887','103.104.226.130');
[08/10/2020 06:45:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1597041909','45.120.147.56');
[08/10/2020 06:45:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],INSERT INTO bookings set reservation_id='1749',agent_id='25',backoffice_user='tfg',itenirary_id='',confirmation_number='',comment_contract='Bhandardara Lake is one of the most amazing and highly favorite camping and picnic spots for the lovers of nature. Located near Igatpuri in the Western Ghats of India, it is a hotspot of tourism for its natural beauty and the attractions nearby like the many hills, waterfalls, Wilson dam, and Arthur Lake. This camp by the lake is a great place to stay and enjoy a getaway in the lap of nature. Compl.',special_remark='',city_id='Mumbai',country_id='',display_room_rate='9.66',display_currency_code='USD',native_room_rate='500',consultant_id='nitinalpha',native_currency_code='INR',cancellation_policy='Cancellation Charges will be applicable if cancelled after 11-Aug-2020 14:00 hrs.<BR>Late Amendment Charges may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B>  Cancellation Charges of 2.41 USD applicable if cancelled after 27-Jul-2020 14:00 hrs.<br> Cancellation Charges of 0.1 USD applicable if cancelled after 11-Aug-2020 14:00 hrs.<br> Cancellation Charges of 3.86 USD applicable if cancelled after 16-Aug-2020 14:00 hrs.<br> Cancellation Charges of 4.83 USD applicable if cancelled after 21-Aug-2020 14:00 hrs.<br> Cancellation Charges of 7.73 USD applicable if cancelled after 24-Aug-2020 14:00 hrs.<br>',current_status='on_request',booking_status='1',nationality='',create_date='2020-08-10 06:45:27',status_date='2020-08-10 06:45:27',source_type='localtransfer',supplier_profile_id='',expiration_date='2020-08-11 14:00:00',native_rate='0',display_rate='0',wh_display_rate='0',applied_multiplier='0.01533',applied_markup='26',agent_markup='26',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='0.01533',admin_booked='0',service_date='2020-08-27',check_out_date='2020-08-27',agent_currency_multiplier='1.00000',ip_addr='45.120.147.56',site_id='0',leader_phone='',email_id='',sub_user_id='',sales_manager_id='otrams',booking_branch_id='1',site_url = 'http://uat.tfg.otrams.net/', service_type='transfer';
[08/10/2020 06:45:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],update bookings set  parent_agent_id='25', sub_agent_rate='0', agent_rate='9.66', applicable_service_tax='0', supplier_rate='500', original_source='', uid='f8d7226f86bf6b906439b54367f17e44' where id='2811';
[08/10/2020 06:45:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],insert into transfer_bookings  set booking_id='2811',gtaToken='',city_code='64440',transfer_date='2020-08-27',language_code='E',pickup='H',pickup_code='',dropoff='A',dropoff_code='',no_of_pass='1',pick_up_time='.',dropoff_time='',item_code='203',item_content='Mumbai Darshan',sel_arr_from='',flight_number='',terminal_details='',dest_terminal_details='',dropoff_to_hotel='A',dropoff_station='',dropoff_station_train='',dropoff_station_destination='',dest_flight_no='',flight_destination='',dropoff_port_shipname='',dropoff_port_shipcompany='',dropoff_port_shipdestination='',pickup_acc_address1='',pickup_acc_address2='',pickup_acc_city='',pickup_acc_country='',pickup_acc_postcode='',pickup_acc_phone='',dropoff_acc_address1='',dropoff_acc_address2='',dropoff_acc_city='',dropoff_acc_country='',dropoff_acc_postcode='',dropoff_acc_phone='',dropoff_other_address1='',dropoff_other_address2='',dropoff_other_country='',dropoff_other_postcode='',dropoff_other_phone='',Error='',Item_Confirm_Ref='',airport_arriving_from='',arriving_flight_number='',pickup_station_arriving_from='',pickup_station_train_name='',pickup_station_arriving_station='',pickup_port_arriving_from='',pickup_port_ship_name='',pickup_port_shipping_company='',pickup_other_address1='',pickup_other_address2='',pickup_other_country='',pickup_other_postcode='',pickup_other_phone='',country_code='106',tariff_code='9703087f6e88bc8943496f87eb83b5ba',supplier_id='S000000068',pickup_from_hotel='',dropoff_airport_name='',transfer_condition='Bhandardara Lake is one of the most amazing and highly favorite camping and picnic spots for the lovers of nature. Located near Igatpuri in the Western Ghats of India, it is a hotspot of tourism for its natural beauty and the attractions nearby like the many hills, waterfalls, Wilson dam, and Arthur Lake. This camp by the lake is a great place to stay and enjoy a getaway in the lap of nature. Compl.',vehicle_type='2', charge_applied_type='Private' ,travel_duration='4 hr 0 mins ';
[08/10/2020 06:45:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2811','on_request','2020-08-10 06:45:27','Transfer Booking on_request','25','45.120.147.56','','','');
[08/10/2020 06:45:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],insert into transfer_vehicles (booking_id,vehicle_code,vehicle_name,max_luggage,max_passenger,sel_passenger,lead_name,vehicle_native_price,native_price,display_price,native_surcharge,display_surcharge,wh_display_price,wh_surcharge,no_of_adult,adult_rate,no_of_child,lead_phone) values ('2811','2','CAR ','3','2','1','Mr Sanket Desai','500','500','9.66','','','','','1','0','0','');
[08/10/2020 06:45:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],update bookings set leader_first_name = 'Mr Sanket Desai' where id = '2811';
[08/10/2020 06:45:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],update xmllogs set reservation_id='2811' where agent_logs_id='386' and source_type='localtransfer';
[08/10/2020 06:45:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],insert into email_logs SET `subject`= ' TFG302811/  Booking On Request ',from_email_id= '',body= '[encoded data, 40120 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,nitin@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking_transfer.php',create_date= '2020-08-10 06:45:28';
[08/10/2020 06:45:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],insert into email_logs SET `subject`= ' TFG302811/  Booking On Request ',from_email_id= '',body= '[encoded data, 40120 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking_transfer.php',create_date= '2020-08-10 06:45:28';
[08/10/2020 06:45:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking_transfer.php],insert into email_logs SET `subject`= ' TFG302811/  Booking On Request ',from_email_id= '',body= '[encoded data, 27748 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking_transfer.php',create_date= '2020-08-10 06:45:28';
