[08/04/2020 11:02:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_note.php],INSERT INTO msg_reminder set message_id= '8',remind_to= 'nitinalpha',remind_datetime= '2020-08-04 12:02:00';
[08/04/2020 11:02:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_note.php],UPDATE msg_note set remind_datetime= '2020-08-04 12:02:00' where id= '8';
[08/04/2020 11:04:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-08-04 11:04:37',login_attempt=0 where id = '25';
[08/04/2020 11:04:37], [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-04 11:04:37', ip = '60.254.42.39', action = 'Login' ;
[08/04/2020 11:05:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.42.39' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/08/04' , departure_date = '2020/08/05' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-08-04 11:05:06' , site_id = '' , country_code = '106' , web_service = '' ;
[08/04/2020 11:05:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-08-04 11:05:10', '', '9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84', '359');
[08/04/2020 11:05:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&web_service=no&site_id='
, http_hit_time = '2020-08-04 11:05:09.472'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '2.949'
, error_description = ''
, memory_used = '8020616'
WHERE id = '2940';
[08/04/2020 11:05:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84',
  duration = '4.595',
  merge_duration = '1.231',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '2.25',
  system_load_5_min = '2.23',
  system_load_15_min = '2.11',
  system_memory_usage = '89.14',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '359') + '8148720',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '359';
[08/04/2020 11:05:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596539138','60.254.42.39');
[08/04/2020 11:05:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.42.39' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/08/04' , departure_date = '2020/08/05' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-08-04 11:05:59' , site_id = '' , country_code = '106' , web_service = '' ;
[08/04/2020 11:06:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-08-04 11:06:02', '', '9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84', '360');
[08/04/2020 11:06:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&web_service=no&site_id='
, http_hit_time = '2020-08-04 11:06:01.400'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.618'
, error_description = ''
, memory_used = '8020992'
WHERE id = '2941';
[08/04/2020 11:06:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84',
  duration = '2.123',
  merge_duration = '0.174',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '2.12',
  system_load_5_min = '2.20',
  system_load_15_min = '2.10',
  system_memory_usage = '89.07',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '360') + '8149136',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '360';
[08/04/2020 11:06:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596539177','60.254.42.39');
[08/04/2020 11:07:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596539263','60.254.42.39');
[08/04/2020 11:12:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],INSERT INTO history_bookings set history_booking_id = '2795', agent_id = '25', parent_agent_id = '25', wh_parent_agent_id = '0', itenirary_id = '2', sequence = '2', confirmation_number = '', payment_confirmation_no = '', voucher_id = '', voucher_hashcode = '', email_id = '', leader_title = 'Ms', leader_first_name = 'Snehal', leader_last_name = 'Valanju', city_id = 'Mumbai', country_id = '106', nationality = 'Indian', display_room_rate = '253.000', native_room_rate = '200.000', native_currency_code = 'USD', display_currency_code = 'USD', additional_charge = '0.000', cancellation_policy = '', supplier_cancellation_policy = '', current_status = 'confirmed', booking_status = '1', status_date = '2020-08-04 06:04:14', create_date = '2020-08-04 06:04:14', source_type = 'localtransfer', expiration_date = '0000-00-00 00:00:00', service_date = '2020-08-09', comment_contract = '', admin_note = '', is_payment_gateway = '0', service_type = 'transfer', service_type_detail = 'Mumbai Darshan', native_rate = '', display_rate = '', applicable_service_tax = '0.000', special_comment = '', special_remark = '', sms_status = '', is_xml = '0', consultant_id = 'tfg', admin_booked = '0', emailed_status = '0', applied_multiplier = '1.00000', applied_markup = '26.5', original_voucher = '', subagent_markup = '', agent_markup = '26.5', agent_rate = '253.000', sub_agent_rate = '0.000', supplier_rate = '200.000', basecurrency_multiplier = '1', basecurrency_multiplier_native = '1', agent_currency_multiplier = '1.00000', created_datetime = '', created_by = 'tfg', modified_datetime = '', modified_by = '', ip_addr = '';
[08/04/2020 11:12:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into history_transfer_bookings  set  old_reff_id  = '512', booking_id = '2795' ,transfer_date = '2020-08-09' ,country_code = '106' ,city_code = '64440' ,pickup = 'H' ,pickup_code = '47832_64440' ,dropoff = 'A' ,dropoff_code = '99' ,no_of_pass = '2' ,pick_up_time = '' ,dropoff_time = '' ,item_content = 'Mumbai Darshan' ,sel_arr_from = 'Mumbai' ,flight_number = '' ,dropoff_to_hotel = '' ,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_country = '' ,pickup_acc_postcode = '' ,pickup_acc_phone = '' ,dropoff_acc_address1 = '' ,dropoff_acc_address2 = '' ,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_from_hotel = '' ,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 = '' ,travel_duration = '4 hr 0 min ' ,supplier_id = 'S000000068' ,supplier_profile= '6',parking_fee = '' ,guide_cost = '' ,driver_tips = '' ,representative_cost = '' ,touristic_entrance = '' ,adult_charge = '' ,child_charge = '' ,tariff_code= '';
[08/04/2020 11:12:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into history_transfer_vehicles set  old_reff_id  = '512',  booking_id  = '2795' , vehicle_code  = '4' , vehicle_name  = 'VAN 6 SEATER' , max_luggage  = '5' , max_passenger  = '4' , sel_passenger  = '2' , no_of_adult  = '2' , no_of_child  = '0' , lead_name  = 'Ms Snehal Valanju' , lead_phone  = '' , adult_rate  = '100' , child_rate  = '0' , parking_fee  = '' , driver_tips  = '' , representative_cost  = '' , guide_cost  = '' , touristic_fee  = '' , vehicle_native_price  = '100' , native_price  = '100' , display_price  = '253' , native_surcharge  = '' , display_surcharge  = '' ;
[08/04/2020 11:12:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],UPDATE bookings SET confirmation_number= '',voucher_id='',voucher_hashcode='',native_currency_code= 'USD',cancellation_policy= '',supplier_cancellation_policy= '',applied_multiplier= '1.00000',applied_markup= '26.5',agent_markup= '26.5',consultant_id= 'tfg',city_id= 'Mumbai',country_id= '106',nationality= 'Indian',service_type_detail= 'Mumbai Darshan',basecurrency_multiplier='1',basecurrency_multiplier_native= '1'_native,agent_currency_multiplier= '1.00000',current_status= 'confirmed',status_date= '2020-08-04 11:12:29',display_room_rate= '253.000',check_out_date= '2020-08-09',service_date= '2020-08-09',native_room_rate= '200.000',display_rate= '',applicable_service_tax= '0.000',native_rate= '',native_discount= '',display_discount= '',modified_datetime= '2020-08-04 11:12:30',modified_by= 'tfg',comment_contract= '',booking_type ='offline',expiration_date= '2020-08-04 11:12:11',source_type= 'localtransfer',supplier_profile_id= '6' WHERE id= '2795';
[08/04/2020 11:12:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],UPDATE bookings SET  sub_agent_rate='0', agent_rate='253.00', applicable_service_tax='0.000', supplier_rate='200', leader_title='Ms', leader_first_name='Shruti', leader_last_name='Valanju', leader_phone='' where id='2795';
[08/04/2020 11:12:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],DELETE FROM bookings_tax WHERE booking_id =2795;
[08/04/2020 11:12:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],UPDATE transfer_bookings SET transfer_date = '2020-08-09',supplier_id = 'S000000068',supplier_profile = '6',charge_applied_type = 'sic basis',country_code = '106',city_code = '64440',item_code = '203',item_content = 'Mumbai Darshan',vehicle_type = '4' ,no_of_pass = '2' where booking_id= '2795';
[08/04/2020 11:12:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],DELETE FROM transfer_vehicles WHERE booking_id ='2795';
[08/04/2020 11:12:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into transfer_vehicles set  booking_id = '2795',vehicle_code = '4' ,vehicle_name = 'VAN 6 SEATER' ,max_passenger = '4' ,max_luggage = '5' , sel_passenger = '2', no_of_adult = '2', no_of_child = '0', lead_name = 'Ms Snehal Valanju', lead_phone = '', adult_rate = '100', child_rate = '0', parking_fee = '0', driver_tips = '0', representative_cost = '0', guide_cost = '0', touristic_fee = '0', vehicle_native_price = '100', native_price = '100', display_price = '253', native_surcharge = '0', display_surcharge = '0', wh_display_price = '', wh_surcharge = '';
[08/04/2020 11:12:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_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
        ('','','2795','confirmed','2020-08-04 11:12:30','Transfer Booking TFG302795 Modified by tfg','tfg','60.254.42.39','tfg','','');
[08/04/2020 11:12:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:12:30',`log_type`= 'Transfer Booking Modified',`sql_query`= 'UPDATE bookings SET  sub_agent_rate=\&#039;0\&#039;, agent_rate=\&#039;253.00\&#039;, applicable_service_tax=\&#039;0.000\&#039;, supplier_rate=\&#039;200\&#039;, leader_title=\&#039;Ms\&#039;, leader_first_name=\&#039;Shruti\&#039;, leader_last_name=\&#039;Valanju\&#039;, leader_phone=\&#039;\&#039; where id=\&#039;2795\&#039;',`log_description`= 'Tranfer Booking Modified Booking_id = TFG302795',`ip`= '60.254.42.39';
[08/04/2020 11:13:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET agency_name= 'QtechPvt',other_language_agency_name= '',accounting_id= '123',auto_voucher_bookings = '0',outstanding_limit = '0',accounting_name= '',first_name= 'Snehal',middle_name= '',last_name= 'Valanju',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '1000',credit_limit= '1000',credit_distribution= '0',temp_credit_limit= '',address= 'MUmbai',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-10',enable_dst= '',branch_id='1',phone= '12-123456789',mobile= '12-22333134345345',fax= '',currency= '6',email= 'snehal.valanju@qtechsoftwrae.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '1',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_voucher= '',allow_book_under_cancellation='1',modify_date='2020-08-04 11:13:32',consultant_id= 'SalesConsultant',agency_email= '',acc_name= 'A',acc_email= 'snehal.valanju@qtechsoftware.com',acc_phone= '',man_name= 'B',man_email= '',man_phone= '',res_name= 'C',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '',agent_category= '',can_show_hotels= '' WHERE id= '25';
[08/04/2020 11:13:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:13:33',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;QtechPvt\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_id= \&#039;123\&#039;,auto_voucher_bookings = \&#039;0\&#039;,outstanding_limit = \&#039;0\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Snehal\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;Valanju\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;1000\&#039;,credit_limit= \&#039;1000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;MUmbai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-10\&#039;,enable_dst= 0,branch_id=\&#039;1\&#039;,phone= \&#039;12-123456789\&#039;,mobile= \&#039;12-22333134345345\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;snehal.valanju@qtechsoftwrae.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= 1,debug= \&#039;1\&#039;,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= \&#039;\&#039;,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= ,allow_book_under_cancellation=\&#039;1\&#039;,modify_date=\&#039;2020-08-04 11:13:32\&#039;,consultant_id= \&#039;SalesConsultant\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;A\&#039;,acc_email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;B\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;C\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= \&#039;\&#039;,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0,agent_category= \&#039;\&#039;,can_show_hotels= 0 WHERE id= \&#039;25\&#039;',`log_description`= 'Agent 25 updated For  - modify_date=2020-07-31+06%3A03%3A32&agent_category=5 changed to - modify_date=2020-08-04+11%3A13%3A32&agent_category=0',`ip`= '60.254.42.39';
[08/04/2020 11:13:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3468', `entity`='Agents', `value`='25' ;
[08/04/2020 11:13:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'25'.'25''25''25' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[08/04/2020 11:13:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '0.000',credit_usage= '1000.000',credit_limit= '1000',receipt_id= '',amount= '',ip='60.254.42.39',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by tfg',create_date='2020-08-04 11:08:33';
[08/04/2020 11:13:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '1',consultant_id= 'SalesConsultant',sales_manager_id= '',profile= '', auto_voucher_bookings = '0', outstanding_limit = '0', agent_type= 'CC' WHERE parent_agent= '25';
[08/04/2020 11:13:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET excluded_countries = '43,97,29' WHERE id= ?;
[08/04/2020 11:14:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into email_logs SET `subject`= 'Registration Acknowledgement - Agent ID - 25 The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 20420 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,snehal.valanju@qtechsoftwrae.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/resend_email.php?action=agent_registration_email&agent_id=25',create_date= '2020-08-04 11:14:16';
[08/04/2020 11:14:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into email_logs SET `subject`= 'Login Details - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 15780 characters]',to_email_id= 'snehal.valanju@qtechsoftwrae.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/resend_email.php?action=agent_confirmation_email&agent_id=25',create_date= '2020-08-04 11:14:25';
[08/04/2020 11:16:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_markup.php],INSERT INTO markup SET service_type='country',service_code='106',period_from='2020-08-04',period_to='2020-08-31',range_group='',status='A',markup='5',supplier_type='supplier_register_yes',supplier_id='S000000054',markup_type='on_sale',create_date='2020-08-04 11:16:24';
[08/04/2020 11:16:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/customer_category_markup.php],DELETE from agent_category_markup_settings WHERE id='1';
[08/04/2020 11:16:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/customer_category_markup.php],DELETE from agent_category_markup_settings WHERE id='2';
[08/04/2020 11:16:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/customer_category_markup.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:16:37',`log_type`= 'Customer Category Markup Mapping',`sql_query`= '',`log_description`= 'A Manual Customer Category Markup Mapping has been multiple deleted',`ip`= '60.254.42.39';
[08/04/2020 11:16:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/customer_category_markup.php],DELETE from agent_category_markup_settings WHERE id='3';
[08/04/2020 11:16:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/customer_category_markup.php],DELETE from agent_category_markup_settings WHERE id='6';
[08/04/2020 11:16:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/customer_category_markup.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:16:52',`log_type`= 'Customer Category Markup Mapping',`sql_query`= '',`log_description`= 'A Manual Customer Category Markup Mapping has been multiple deleted',`ip`= '60.254.42.39';
[08/04/2020 11:17:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscribers.php],Insert into subscribers(email,name, agency_name, country, city, created, created_by) values('snehal.valanju@qtechsoftware.com', 'UATGroupOfTesters', '', '106', '64440', '2020-08-04 11:17:50', '2020-08-04 11:17:50'by );
[08/04/2020 11:17:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscribers.php], Insert into subscriber_list_subscribers SET  subscriber_list_id = '1',  subscriber_id = '2';
[08/04/2020 11:17:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscribers.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:17:50',`log_type`= 'Insert Subscriber',`sql_query`= ' Insert into subscriber_list_subscribers SET  subscriber_list_id = :subscriber_list_id,  subscriber_id = :subscriber_id',`log_description`= 'Subscriber has been added',`ip`= '60.254.42.39';
[08/04/2020 11:18:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/manage_documents.php],INSERT INTO business_documents SET document_type = 'Driver Document',entity_type = 'logistic_driver',display_filename = 'CWGFD2w.png',disk_filename  = '7a6358387b9b85e22c05966c6f06a188d8cff7b292b6715dd112e009b48167bc.png',create_date_time  = '2020/08/04',mime_type  = 'image/png',backoffice_user  = 'tfg';
[08/04/2020 11:18:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/newsletter/movesubscriber.php], Update subscriber_list_subscribers set subscriber_list_id = ? Where subscriber_list_id = ? and subscriber_id = ?;
[08/04/2020 11:18:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscribers.php],Insert into subscribers(email,name, agency_name, country, city, created, created_by) values('snehal.valanju@qtechsoftware.com', 'UATGroupOfTesters', '', '106', '64440', '2020-08-04 11:18:40', '2020-08-04 11:18:40'by );
[08/04/2020 11:18:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscribers.php], Insert into subscriber_list_subscribers SET  subscriber_list_id = '1',  subscriber_id = '3';
[08/04/2020 11:18:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscribers.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:18:40',`log_type`= 'Insert Subscriber',`sql_query`= ' Insert into subscriber_list_subscribers SET  subscriber_list_id = :subscriber_list_id,  subscriber_id = :subscriber_id',`log_description`= 'Subscriber has been added',`ip`= '60.254.42.39';
[08/04/2020 11:19:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/newsletter/movesubscriber.php], Insert into subscriber_lists SET name= 'TestingJam', from_name= '', reply_to_email= '', created= '2020-08-04 11:19:36', created_by= '2020-08-04 11:19:36'_by;
[08/04/2020 11:19:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/newsletter/movesubscriber.php],Insert into subscriber_list_subscribers SET  subscriber_list_id = ?,  subscriber_id = ? ;
[08/04/2020 11:20:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscribers.php], UPDATE subscribers SET  email = 'snehal.valanju@qtechsoftware.com' , name = 'UATGroup' , agency_name = '' , country = '106' , city = '64440' , modified = '2020-08-04 11:20:39' , modified_by = '2020-08-04 11:20:39'by WHERE id= '3';
[08/04/2020 11:20:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscribers.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:20:39',`log_type`= 'Update Subscriber',`sql_query`= ' UPDATE subscribers SET  email = :email , name = :name , agency_name = :agency_name , country = :country , city = :city , modified = :modified , modified_by = :modifiedby WHERE id= :id',`log_description`= 'Subscriber has been updated',`ip`= '60.254.42.39';
[08/04/2020 11:21:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscribers.php], UPDATE subscribers SET  email = 'snehal.valanju@qtechsoftware.com' , name = 'UATGroup' , agency_name = '' , country = '106' , city = '64440' , modified = '2020-08-04 11:21:30' , modified_by = '2020-08-04 11:21:30'by WHERE id= '3';
[08/04/2020 11:21:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscribers.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:21:30',`log_type`= 'Update Subscriber',`sql_query`= ' UPDATE subscribers SET  email = :email , name = :name , agency_name = :agency_name , country = :country , city = :city , modified = :modified , modified_by = :modifiedby WHERE id= :id',`log_description`= 'Subscriber has been updated',`ip`= '60.254.42.39';
[08/04/2020 11:21:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscribers.php],Delete from subscriber_list_subscribers WHERE subscriber_id=? and subscriber_list_id = ?;
[08/04/2020 11:21:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscribers.php],Delete from subscriber_list_subscribers WHERE subscriber_id=? and subscriber_list_id = ?;
[08/04/2020 11:23:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscriber_list.php],Delete from subscriber_lists WHERE id=? ;
[08/04/2020 11:23:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscriber_list.php],Delete from subscriber_list_subscribers WHERE subscriber_list_id = ?;
[08/04/2020 11:23:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/newsletter/duplicateSubscriberList.php], Insert into subscriber_lists SET name= 'Snehal', from_name= '', reply_to_email= '', created= '2020-08-04 11:23:51', created_by= '2020-08-04 11:23:51'_by;
[08/04/2020 11:23:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/newsletter/duplicateSubscriberList.php], Insert into subscriber_list_subscribers ( subscriber_list_id, subscriber_id )   Select 4, subscriber_id from subscriber_list_subscribers Where subscriber_list_id = 2;
[08/04/2020 11:23:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscriber_list.php],Delete from subscriber_lists WHERE id=? ;
[08/04/2020 11:23:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscriber_list.php],Delete from subscriber_list_subscribers WHERE subscriber_list_id = ?;
[08/04/2020 11:24:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscribers.php],Insert into subscribers(email,name, agency_name, country, city, created, created_by) values('ankita.rao@qtechsoftware.com', 'Ankita', '', '106', '64440', '2020-08-04 11:24:43', '2020-08-04 11:24:43'by );
[08/04/2020 11:24:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscribers.php], Insert into subscriber_list_subscribers SET  subscriber_list_id = '2',  subscriber_id = '4';
[08/04/2020 11:24:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscribers.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:24:43',`log_type`= 'Insert Subscriber',`sql_query`= ' Insert into subscriber_list_subscribers SET  subscriber_list_id = :subscriber_list_id,  subscriber_id = :subscriber_id',`log_description`= 'Subscriber has been added',`ip`= '60.254.42.39';
[08/04/2020 11:26:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscriber_list.php], Insert into subscribers (email, name, agency_name, country, city, created, created_by) values ('urvi3@qtech.com', 'urvi3', 'test agency', '106', '64459', '2020-08-04 11:26:21', '2020-08-04 11:26:21'by);
[08/04/2020 11:26:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscriber_list.php], Insert into subscriber_list_subscribers (subscriber_list_id, subscriber_id) values ('4', '5') ;
[08/04/2020 11:26:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscriber_list.php], Insert into subscribers (email, name, agency_name, country, city, created, created_by) values ('urvi4@qtech.com', 'urvi4', 'test agency', '106', '64440', '2020-08-04 11:26:21', '2020-08-04 11:26:21'by);
[08/04/2020 11:26:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscriber_list.php], Insert into subscriber_list_subscribers (subscriber_list_id, subscriber_id) values ('4', '6') ;
[08/04/2020 11:26:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscriber_list.php], Insert into subscribers (email, name, agency_name, country, city, created, created_by) values ('urvi5@qtech.com', 'urvi5', 'test agency', '106', '64447', '2020-08-04 11:26:21', '2020-08-04 11:26:21'by);
[08/04/2020 11:26:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscriber_list.php], Insert into subscriber_list_subscribers (subscriber_list_id, subscriber_id) values ('4', '7') ;
[08/04/2020 11:27:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Insert into campaigns SET name = 'UATGroup', short_description = 'This would be a campaign held for a small group of testers', message_type = 'plain_text', created = '2020-08-04 11:27:27', created_by = 'tfg';
[08/04/2020 11:27:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Insert into campaign_subscriber_lists SET  subscriber_list_id = ? ,  campaign_id = ?;
[08/04/2020 11:27:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:27:27',`log_type`= 'Insert Campaign Name details',`sql_query`= ' Insert into campaign_subscriber_lists SET  subscriber_list_id = ? ,  campaign_id = ?',`log_description`= 'Campaign Name details has been added',`ip`= '60.254.42.39';
[08/04/2020 11:28:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaigns SET from_name = 'Snehal', from_email = 'snehal.valanju@qtechsoftware.com', subject = 'Testing Campaign', reply_to_email = 'snehal.valanju@qtechsoftware.com', footer_details = 'Test', modified = '2020-08-04 11:28:00', modified_by = '2020-08-04 11:28:00'by  Where id = '1';
[08/04/2020 11:28:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:28:00',`log_type`= 'Update Campaign Setup',`sql_query`= ' Update campaigns SET from_name = :from_name, from_email = :from_email, subject = :subject, reply_to_email = :reply_to_email, footer_details = :footer_details, modified = :modified, modified_by = :modifiedby  Where id = :id',`log_description`= 'Campaign Setup has been modified',`ip`= '60.254.42.39';
[08/04/2020 11:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaigns SET message = 'A/B test your email campaigns. A/B testing, also known as split testing, is a way of working out which of two campaign options is the most effective in terms of encouraging opens or clicks. In an A/B test you set up two variations of the one campaign and send them to a small percentage of your total recipients.',content_type = '1', modified = '2020-08-04 11:28:28', modified_by = '2020-08-04 11:28:28'by  Where id = '1';
[08/04/2020 11:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:28:28',`log_type`= 'Update Campaign content',`sql_query`= ' Update campaigns SET message = :message,content_type = :content_type, modified = :modified, modified_by = :modifiedby  Where id = :id',`log_description`= 'Campaign content has been modified',`ip`= '60.254.42.39';
[08/04/2020 11:29:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaigns SET schedule_date = '2020-08-05 05:05:37', schedule_time = '1596603937', time_zone = '-12', status = 'Scheduled', modified = '2020-08-04 11:29:03', modified_by = '2020-08-04 11:29:03'by  Where id = '1';
[08/04/2020 11:29:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:29:03',`log_type`= 'Schedule Campaign',`sql_query`= ' Update campaigns SET schedule_date = :schedule_date, schedule_time = :schedule_time, time_zone = :time_zone, status = :status, modified = :modified, modified_by = :modifiedby  Where id = :id',`log_description`= 'Campaign has been scheduled',`ip`= '60.254.42.39';
[08/04/2020 11:29:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaigns set status = ? Where id = ?;
[08/04/2020 11:29:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaigns set sent_date = ? Where id = ?;
[08/04/2020 11:29:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Insert into campaign_subscribers SET campaign_id = ?, subscriber_id = ?, is_sent = '''1''' ;
[08/04/2020 11:29:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Insert into campaign_subscribers SET campaign_id = ?, subscriber_id = ?, is_sent = '''2''' ;
[08/04/2020 11:29:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Insert into campaign_subscribers SET campaign_id = ?, subscriber_id = ?, is_sent = '''5''' ;
[08/04/2020 11:29:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Insert into campaign_subscribers SET campaign_id = ?, subscriber_id = ?, is_sent = '''6''' ;
[08/04/2020 11:29:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Insert into campaign_subscribers SET campaign_id = ?, subscriber_id = ?, is_sent = '''7''' ;
[08/04/2020 11:29:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaigns set status = ? Where id = ?;
[08/04/2020 11:29:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into email_logs SET `subject`= 'Testing Campaign',from_email_id= 'snehal.valanju@qtechsoftware.com',body= 'QS9CIHRlc3QgeW91ciBlbWFpbCBjYW1wYWlnbnMuIEEvQiB0ZXN0aW5nLCBhbHNvIGtub3duIGFzIHNwbGl0IHRlc3RpbmcsIGlzIGEgd2F5IG9mIHdvcmtpbmcgb3V0IHdoaWNoIG9mIHR3byBjYW1wYWlnbiBvcHRpb25zIGlzIHRoZSBtb3N0IGVmZmVjdGl2ZSBpbiB0ZXJtcyBvZiBlbmNvdXJhZ2luZyBvcGVucyBvciBjbGlja3MuIEluIGFuIEEvQiB0ZXN0IHlvdSBzZXQgdXAgdHdvIHZhcmlhdGlvbnMgb2YgdGhlIG9uZSBjYW1wYWlnbiBhbmQgc2VuZCB0aGVtIHRvIGEgc21hbGwgcGVyY2VudGFnZSBvZiB5b3VyIHRvdGFsIHJlY2lwaWVudHMuPGJyIC8+PGJyIC8+PGJyIC8+PGJyIC8+PGEgaHJlZj0naHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9uZXdzbGV0dGVyL3Vuc3Vic2NyaWJlLnBocD9lbWFpbD1zYW5rZXQuZGVzYWlAcXRlY2hzb2Z0d2FyZS5jb20nPiBVbnN1YnNjcmliZSA8L2E+PC9icj48L2JyPlRlc3Q=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/campaigns.php?&action=campaign_sent&cid=1',create_date= '2020-08-04 11:29:33';
[08/04/2020 11:29:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaign_subscribers set is_sent = ''1'', sent_date_time = ? Where id = ?;
[08/04/2020 11:29:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into email_logs SET `subject`= 'Testing Campaign',from_email_id= 'snehal.valanju@qtechsoftware.com',body= 'QS9CIHRlc3QgeW91ciBlbWFpbCBjYW1wYWlnbnMuIEEvQiB0ZXN0aW5nLCBhbHNvIGtub3duIGFzIHNwbGl0IHRlc3RpbmcsIGlzIGEgd2F5IG9mIHdvcmtpbmcgb3V0IHdoaWNoIG9mIHR3byBjYW1wYWlnbiBvcHRpb25zIGlzIHRoZSBtb3N0IGVmZmVjdGl2ZSBpbiB0ZXJtcyBvZiBlbmNvdXJhZ2luZyBvcGVucyBvciBjbGlja3MuIEluIGFuIEEvQiB0ZXN0IHlvdSBzZXQgdXAgdHdvIHZhcmlhdGlvbnMgb2YgdGhlIG9uZSBjYW1wYWlnbiBhbmQgc2VuZCB0aGVtIHRvIGEgc21hbGwgcGVyY2VudGFnZSBvZiB5b3VyIHRvdGFsIHJlY2lwaWVudHMuPGJyIC8+PGJyIC8+PGJyIC8+PGJyIC8+PGEgaHJlZj0naHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9uZXdzbGV0dGVyL3Vuc3Vic2NyaWJlLnBocD9lbWFpbD1zbmVoYWwudmFsYW5qdUBxdGVjaHNvZnR3YXJlLmNvbSc+IFVuc3Vic2NyaWJlIDwvYT48L2JyPjwvYnI+VGVzdA==',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/campaigns.php?&action=campaign_sent&cid=1',create_date= '2020-08-04 11:29:33';
[08/04/2020 11:29:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaign_subscribers set is_sent = ''2'', sent_date_time = ? Where id = ?;
[08/04/2020 11:29:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into email_logs SET `subject`= 'Testing Campaign',from_email_id= 'snehal.valanju@qtechsoftware.com',body= 'QS9CIHRlc3QgeW91ciBlbWFpbCBjYW1wYWlnbnMuIEEvQiB0ZXN0aW5nLCBhbHNvIGtub3duIGFzIHNwbGl0IHRlc3RpbmcsIGlzIGEgd2F5IG9mIHdvcmtpbmcgb3V0IHdoaWNoIG9mIHR3byBjYW1wYWlnbiBvcHRpb25zIGlzIHRoZSBtb3N0IGVmZmVjdGl2ZSBpbiB0ZXJtcyBvZiBlbmNvdXJhZ2luZyBvcGVucyBvciBjbGlja3MuIEluIGFuIEEvQiB0ZXN0IHlvdSBzZXQgdXAgdHdvIHZhcmlhdGlvbnMgb2YgdGhlIG9uZSBjYW1wYWlnbiBhbmQgc2VuZCB0aGVtIHRvIGEgc21hbGwgcGVyY2VudGFnZSBvZiB5b3VyIHRvdGFsIHJlY2lwaWVudHMuPGJyIC8+PGJyIC8+PGJyIC8+PGJyIC8+PGEgaHJlZj0naHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9uZXdzbGV0dGVyL3Vuc3Vic2NyaWJlLnBocD9lbWFpbD11cnZpM0BxdGVjaC5jb20nPiBVbnN1YnNjcmliZSA8L2E+PC9icj48L2JyPlRlc3Q=',to_email_id= 'urvi3@qtech.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/campaigns.php?&action=campaign_sent&cid=1',create_date= '2020-08-04 11:29:34';
[08/04/2020 11:29:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaign_subscribers set is_sent = ''3'', sent_date_time = ? Where id = ?;
[08/04/2020 11:29:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into email_logs SET `subject`= 'Testing Campaign',from_email_id= 'snehal.valanju@qtechsoftware.com',body= 'QS9CIHRlc3QgeW91ciBlbWFpbCBjYW1wYWlnbnMuIEEvQiB0ZXN0aW5nLCBhbHNvIGtub3duIGFzIHNwbGl0IHRlc3RpbmcsIGlzIGEgd2F5IG9mIHdvcmtpbmcgb3V0IHdoaWNoIG9mIHR3byBjYW1wYWlnbiBvcHRpb25zIGlzIHRoZSBtb3N0IGVmZmVjdGl2ZSBpbiB0ZXJtcyBvZiBlbmNvdXJhZ2luZyBvcGVucyBvciBjbGlja3MuIEluIGFuIEEvQiB0ZXN0IHlvdSBzZXQgdXAgdHdvIHZhcmlhdGlvbnMgb2YgdGhlIG9uZSBjYW1wYWlnbiBhbmQgc2VuZCB0aGVtIHRvIGEgc21hbGwgcGVyY2VudGFnZSBvZiB5b3VyIHRvdGFsIHJlY2lwaWVudHMuPGJyIC8+PGJyIC8+PGJyIC8+PGJyIC8+PGEgaHJlZj0naHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9uZXdzbGV0dGVyL3Vuc3Vic2NyaWJlLnBocD9lbWFpbD11cnZpNEBxdGVjaC5jb20nPiBVbnN1YnNjcmliZSA8L2E+PC9icj48L2JyPlRlc3Q=',to_email_id= 'urvi4@qtech.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/campaigns.php?&action=campaign_sent&cid=1',create_date= '2020-08-04 11:29:34';
[08/04/2020 11:29:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaign_subscribers set is_sent = ''4'', sent_date_time = ? Where id = ?;
[08/04/2020 11:29:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into email_logs SET `subject`= 'Testing Campaign',from_email_id= 'snehal.valanju@qtechsoftware.com',body= 'QS9CIHRlc3QgeW91ciBlbWFpbCBjYW1wYWlnbnMuIEEvQiB0ZXN0aW5nLCBhbHNvIGtub3duIGFzIHNwbGl0IHRlc3RpbmcsIGlzIGEgd2F5IG9mIHdvcmtpbmcgb3V0IHdoaWNoIG9mIHR3byBjYW1wYWlnbiBvcHRpb25zIGlzIHRoZSBtb3N0IGVmZmVjdGl2ZSBpbiB0ZXJtcyBvZiBlbmNvdXJhZ2luZyBvcGVucyBvciBjbGlja3MuIEluIGFuIEEvQiB0ZXN0IHlvdSBzZXQgdXAgdHdvIHZhcmlhdGlvbnMgb2YgdGhlIG9uZSBjYW1wYWlnbiBhbmQgc2VuZCB0aGVtIHRvIGEgc21hbGwgcGVyY2VudGFnZSBvZiB5b3VyIHRvdGFsIHJlY2lwaWVudHMuPGJyIC8+PGJyIC8+PGJyIC8+PGJyIC8+PGEgaHJlZj0naHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9uZXdzbGV0dGVyL3Vuc3Vic2NyaWJlLnBocD9lbWFpbD11cnZpNUBxdGVjaC5jb20nPiBVbnN1YnNjcmliZSA8L2E+PC9icj48L2JyPlRlc3Q=',to_email_id= 'urvi5@qtech.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/campaigns.php?&action=campaign_sent&cid=1',create_date= '2020-08-04 11:29:34';
[08/04/2020 11:29:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaign_subscribers set is_sent = ''5'', sent_date_time = ? Where id = ?;
[08/04/2020 11:29:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaigns set status = ? Where id = ?;
[08/04/2020 11:29:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:29:34',`log_type`= 'Send Campaign',`sql_query`= '',`log_description`= 'Campaign has been sent',`ip`= '60.254.42.39';
[08/04/2020 11:30:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Insert into campaigns SET name = 'Dup of UATGroup', short_description = 'This would be a campaign held for a small group of testers', from_name = 'Snehal', from_email = 'snehal.valanju@qtechsoftware.com', subject = 'Dup of Testing Campaign', reply_to_email = 'snehal.valanju@qtechsoftware.com', footer_details = 'Test', message_type = 'plain_text', message = 'A/B test your email campaigns. A/B testing, also known as split testing, is a way of working out which of two campaign options is the most effective in terms of encouraging opens or clicks. In an A/B test you set up two variations of the one campaign and send them to a small percentage of your total recipients.',content_type = '1', image = '', image_date = ''_date, status = 'Incomplete', created = '2020-08-04 11:30:19', created_by = 'tfg';
[08/04/2020 11:30:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],Insert into campaign_subscriber_lists (campaign_id, subscriber_list_id ) Select 2, subscriber_list_id From campaign_subscriber_lists Where campaign_id = 1;
[08/04/2020 11:30:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:30:19',`log_type`= 'Duplicate Campaign',`sql_query`= ' Insert into campaigns SET name = :name, short_description = :short_description, from_name = :from_name, from_email = :from_email, subject = :subject, reply_to_email = :reply_to_email, footer_details = :footer_details, message_type = :message_type, message = :message,content_type = :content_type, image = :image, image_date = :image_date, status = :status, created = :created, created_by = :createby',`log_description`= 'Campaign Duplicated',`ip`= '60.254.42.39';
[08/04/2020 11:30:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaigns set status = ? Where id = ?;
[08/04/2020 11:30:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaigns set sent_date = ? Where id = ?;
[08/04/2020 11:30:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Insert into campaign_subscribers SET campaign_id = ?, subscriber_id = ?, is_sent = '''1''' ;
[08/04/2020 11:30:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Insert into campaign_subscribers SET campaign_id = ?, subscriber_id = ?, is_sent = '''2''' ;
[08/04/2020 11:30:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Insert into campaign_subscribers SET campaign_id = ?, subscriber_id = ?, is_sent = '''5''' ;
[08/04/2020 11:30:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Insert into campaign_subscribers SET campaign_id = ?, subscriber_id = ?, is_sent = '''6''' ;
[08/04/2020 11:30:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Insert into campaign_subscribers SET campaign_id = ?, subscriber_id = ?, is_sent = '''7''' ;
[08/04/2020 11:30:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaigns set status = ? Where id = ?;
[08/04/2020 11:30:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into email_logs SET `subject`= 'Testing Campaign',from_email_id= 'snehal.valanju@qtechsoftware.com',body= 'QS9CIHRlc3QgeW91ciBlbWFpbCBjYW1wYWlnbnMuIEEvQiB0ZXN0aW5nLCBhbHNvIGtub3duIGFzIHNwbGl0IHRlc3RpbmcsIGlzIGEgd2F5IG9mIHdvcmtpbmcgb3V0IHdoaWNoIG9mIHR3byBjYW1wYWlnbiBvcHRpb25zIGlzIHRoZSBtb3N0IGVmZmVjdGl2ZSBpbiB0ZXJtcyBvZiBlbmNvdXJhZ2luZyBvcGVucyBvciBjbGlja3MuIEluIGFuIEEvQiB0ZXN0IHlvdSBzZXQgdXAgdHdvIHZhcmlhdGlvbnMgb2YgdGhlIG9uZSBjYW1wYWlnbiBhbmQgc2VuZCB0aGVtIHRvIGEgc21hbGwgcGVyY2VudGFnZSBvZiB5b3VyIHRvdGFsIHJlY2lwaWVudHMuPGJyIC8+PGJyIC8+PGJyIC8+PGJyIC8+PGEgaHJlZj0naHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9uZXdzbGV0dGVyL3Vuc3Vic2NyaWJlLnBocD9lbWFpbD1zYW5rZXQuZGVzYWlAcXRlY2hzb2Z0d2FyZS5jb20nPiBVbnN1YnNjcmliZSA8L2E+PC9icj48L2JyPlRlc3Q=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/campaigns.php?action=send_again&cid=1&',create_date= '2020-08-04 11:30:33';
[08/04/2020 11:30:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaign_subscribers set is_sent = ''6'', sent_date_time = ? Where id = ?;
[08/04/2020 11:30:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into email_logs SET `subject`= 'Testing Campaign',from_email_id= 'snehal.valanju@qtechsoftware.com',body= 'QS9CIHRlc3QgeW91ciBlbWFpbCBjYW1wYWlnbnMuIEEvQiB0ZXN0aW5nLCBhbHNvIGtub3duIGFzIHNwbGl0IHRlc3RpbmcsIGlzIGEgd2F5IG9mIHdvcmtpbmcgb3V0IHdoaWNoIG9mIHR3byBjYW1wYWlnbiBvcHRpb25zIGlzIHRoZSBtb3N0IGVmZmVjdGl2ZSBpbiB0ZXJtcyBvZiBlbmNvdXJhZ2luZyBvcGVucyBvciBjbGlja3MuIEluIGFuIEEvQiB0ZXN0IHlvdSBzZXQgdXAgdHdvIHZhcmlhdGlvbnMgb2YgdGhlIG9uZSBjYW1wYWlnbiBhbmQgc2VuZCB0aGVtIHRvIGEgc21hbGwgcGVyY2VudGFnZSBvZiB5b3VyIHRvdGFsIHJlY2lwaWVudHMuPGJyIC8+PGJyIC8+PGJyIC8+PGJyIC8+PGEgaHJlZj0naHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9uZXdzbGV0dGVyL3Vuc3Vic2NyaWJlLnBocD9lbWFpbD1zbmVoYWwudmFsYW5qdUBxdGVjaHNvZnR3YXJlLmNvbSc+IFVuc3Vic2NyaWJlIDwvYT48L2JyPjwvYnI+VGVzdA==',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/campaigns.php?action=send_again&cid=1&',create_date= '2020-08-04 11:30:34';
[08/04/2020 11:30:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaign_subscribers set is_sent = ''7'', sent_date_time = ? Where id = ?;
[08/04/2020 11:30:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into email_logs SET `subject`= 'Testing Campaign',from_email_id= 'snehal.valanju@qtechsoftware.com',body= 'QS9CIHRlc3QgeW91ciBlbWFpbCBjYW1wYWlnbnMuIEEvQiB0ZXN0aW5nLCBhbHNvIGtub3duIGFzIHNwbGl0IHRlc3RpbmcsIGlzIGEgd2F5IG9mIHdvcmtpbmcgb3V0IHdoaWNoIG9mIHR3byBjYW1wYWlnbiBvcHRpb25zIGlzIHRoZSBtb3N0IGVmZmVjdGl2ZSBpbiB0ZXJtcyBvZiBlbmNvdXJhZ2luZyBvcGVucyBvciBjbGlja3MuIEluIGFuIEEvQiB0ZXN0IHlvdSBzZXQgdXAgdHdvIHZhcmlhdGlvbnMgb2YgdGhlIG9uZSBjYW1wYWlnbiBhbmQgc2VuZCB0aGVtIHRvIGEgc21hbGwgcGVyY2VudGFnZSBvZiB5b3VyIHRvdGFsIHJlY2lwaWVudHMuPGJyIC8+PGJyIC8+PGJyIC8+PGJyIC8+PGEgaHJlZj0naHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9uZXdzbGV0dGVyL3Vuc3Vic2NyaWJlLnBocD9lbWFpbD11cnZpM0BxdGVjaC5jb20nPiBVbnN1YnNjcmliZSA8L2E+PC9icj48L2JyPlRlc3Q=',to_email_id= 'urvi3@qtech.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/campaigns.php?action=send_again&cid=1&',create_date= '2020-08-04 11:30:34';
[08/04/2020 11:30:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaign_subscribers set is_sent = ''8'', sent_date_time = ? Where id = ?;
[08/04/2020 11:30:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into email_logs SET `subject`= 'Testing Campaign',from_email_id= 'snehal.valanju@qtechsoftware.com',body= 'QS9CIHRlc3QgeW91ciBlbWFpbCBjYW1wYWlnbnMuIEEvQiB0ZXN0aW5nLCBhbHNvIGtub3duIGFzIHNwbGl0IHRlc3RpbmcsIGlzIGEgd2F5IG9mIHdvcmtpbmcgb3V0IHdoaWNoIG9mIHR3byBjYW1wYWlnbiBvcHRpb25zIGlzIHRoZSBtb3N0IGVmZmVjdGl2ZSBpbiB0ZXJtcyBvZiBlbmNvdXJhZ2luZyBvcGVucyBvciBjbGlja3MuIEluIGFuIEEvQiB0ZXN0IHlvdSBzZXQgdXAgdHdvIHZhcmlhdGlvbnMgb2YgdGhlIG9uZSBjYW1wYWlnbiBhbmQgc2VuZCB0aGVtIHRvIGEgc21hbGwgcGVyY2VudGFnZSBvZiB5b3VyIHRvdGFsIHJlY2lwaWVudHMuPGJyIC8+PGJyIC8+PGJyIC8+PGJyIC8+PGEgaHJlZj0naHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9uZXdzbGV0dGVyL3Vuc3Vic2NyaWJlLnBocD9lbWFpbD11cnZpNEBxdGVjaC5jb20nPiBVbnN1YnNjcmliZSA8L2E+PC9icj48L2JyPlRlc3Q=',to_email_id= 'urvi4@qtech.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/campaigns.php?action=send_again&cid=1&',create_date= '2020-08-04 11:30:34';
[08/04/2020 11:30:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaign_subscribers set is_sent = ''9'', sent_date_time = ? Where id = ?;
[08/04/2020 11:30:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into email_logs SET `subject`= 'Testing Campaign',from_email_id= 'snehal.valanju@qtechsoftware.com',body= 'QS9CIHRlc3QgeW91ciBlbWFpbCBjYW1wYWlnbnMuIEEvQiB0ZXN0aW5nLCBhbHNvIGtub3duIGFzIHNwbGl0IHRlc3RpbmcsIGlzIGEgd2F5IG9mIHdvcmtpbmcgb3V0IHdoaWNoIG9mIHR3byBjYW1wYWlnbiBvcHRpb25zIGlzIHRoZSBtb3N0IGVmZmVjdGl2ZSBpbiB0ZXJtcyBvZiBlbmNvdXJhZ2luZyBvcGVucyBvciBjbGlja3MuIEluIGFuIEEvQiB0ZXN0IHlvdSBzZXQgdXAgdHdvIHZhcmlhdGlvbnMgb2YgdGhlIG9uZSBjYW1wYWlnbiBhbmQgc2VuZCB0aGVtIHRvIGEgc21hbGwgcGVyY2VudGFnZSBvZiB5b3VyIHRvdGFsIHJlY2lwaWVudHMuPGJyIC8+PGJyIC8+PGJyIC8+PGJyIC8+PGEgaHJlZj0naHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9uZXdzbGV0dGVyL3Vuc3Vic2NyaWJlLnBocD9lbWFpbD11cnZpNUBxdGVjaC5jb20nPiBVbnN1YnNjcmliZSA8L2E+PC9icj48L2JyPlRlc3Q=',to_email_id= 'urvi5@qtech.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/campaigns.php?action=send_again&cid=1&',create_date= '2020-08-04 11:30:34';
[08/04/2020 11:30:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaign_subscribers set is_sent = ''10'', sent_date_time = ? Where id = ?;
[08/04/2020 11:30:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Update campaigns set status = ? Where id = ?;
[08/04/2020 11:30:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:30:34',`log_type`= 'Send Newsletter for Campaign',`sql_query`= '',`log_description`= 'Campaign send again',`ip`= '60.254.42.39';
[08/04/2020 11:30:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],Delete from campaigns Where id = ?;
[08/04/2020 11:30:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],Delete from campaign_subscriber_lists Where campaign_id = ?;
[08/04/2020 11:30:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php], Insert into campaigns SET name = 'Dup of UATGroup', short_description = 'This would be a campaign held for a small group of testers', from_name = 'Snehal', from_email = 'snehal.valanju@qtechsoftware.com', subject = 'Dup of Testing Campaign', reply_to_email = 'snehal.valanju@qtechsoftware.com', footer_details = 'Test', message_type = 'plain_text', message = 'A/B test your email campaigns. A/B testing, also known as split testing, is a way of working out which of two campaign options is the most effective in terms of encouraging opens or clicks. In an A/B test you set up two variations of the one campaign and send them to a small percentage of your total recipients.',content_type = '1', image = '', image_date = ''_date, status = 'Incomplete', created = '2020-08-04 11:30:51', created_by = 'tfg';
[08/04/2020 11:30:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],Insert into campaign_subscriber_lists (campaign_id, subscriber_list_id ) Select 3, subscriber_list_id From campaign_subscriber_lists Where campaign_id = 1;
[08/04/2020 11:30:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaigns.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:30:51',`log_type`= 'Duplicate Campaign',`sql_query`= ' Insert into campaigns SET name = :name, short_description = :short_description, from_name = :from_name, from_email = :from_email, subject = :subject, reply_to_email = :reply_to_email, footer_details = :footer_details, message_type = :message_type, message = :message,content_type = :content_type, image = :image, image_date = :image_date, status = :status, created = :created, created_by = :createby',`log_description`= 'Campaign Duplicated',`ip`= '60.254.42.39';
[08/04/2020 11:33:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaign_settings.php], UPDATE newsletter_settings SET  default_sender_name = 'TFG', default_sender_email = 'ankita.rao@qtechsoftware.com', unsubscribe_text = '', default_subject = '', default_reply_to_email = 'ankita.rao@qtechsoftware.com', address_footer_information = '';
[08/04/2020 11:33:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/campaign_settings.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:33:10',`log_type`= 'Update Campaign Setting',`sql_query`= ' UPDATE newsletter_settings SET  default_sender_name = :default_sender_name, default_sender_email = :default_sender_email, unsubscribe_text = :unsubscribe_text, default_subject = :default_subject, default_reply_to_email = :default_reply_to_email, address_footer_information = :address_footer_information',`log_description`= 'Campaign Setting has been updated',`ip`= '60.254.42.39';
[08/04/2020 11:34:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],update agents set ledger_balance = ledger_balance- '6000' where id = '9';
[08/04/2020 11:34:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],delete from receipts WHERE id= ?;
[08/04/2020 11:34:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 11:34:30',`log_type`= 'Agent Receipt Deleted ',`sql_query`= 'delete from receipts WHERE id= ?',`log_description`= 'Receipt No. 4 deleted | Posted for agent id= 9',`ip`= '60.254.42.39';
[08/04/2020 11:34:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],insert into user_log_link Set `user_logs_id`='3485', `entity`='Agents', `value`='9' ;
[08/04/2020 11:40:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO receipts(agent_id,payment_date,particulars,balance_before,amount_received,unadjusted_amount,payment_mode,bank_name,instrument_no,instrument_date,create_date,status,received_by,site_id,currency_code,receipt_type) VALUES ('5', '2020-08-04 00:00:00', 'Test', '', '50', '', '', '', '', '', '2020-08-04 11:40:32', 'A', '', '', '', 'credit_note');
[08/04/2020 11:40:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],update receipts set docNo= 'CN00000002' ,ledger_multiplier = '1.00000' ,currency_code = 'USD' where id = '6';
[08/04/2020 11:40:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],update agents set ledger_balance = '1'5'55.3' where id =  ?;
[08/04/2020 11:40:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO receipts_bookings set booking_id= '23' ,agent_id= '5' ,receipt_id= '6' ,amount_received= '50' ,create_date= '2020-08-04 11:40:33' ,booking_rate_id= '' ,site_id = '';
[08/04/2020 11:40:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],UPDATE agents SET credit_usage=credit_usage+('-50'),   credit_value= credit_value-('-50') ,  cd_credit_usage=cd_credit_usage+('-50') , cd_credit_value=cd_credit_value-('-50')  WHERE id = '5';
[08/04/2020 11:40:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],insert into  agent_credit_log SET agent_id= '5',credit_value= '49994242.600',credit_usage= '5757.400',credit_limit= '50000000',receipt_id= '',amount= '-50',booking_id='23',booking_cost= '2265.5',receipt_allocation= '50.00',balance= '2215.5',ip='60.254.42.39',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Credit Note Added To Booking',note='Credit Note Added To Booking',create_date='2020-08-04 11:08:33';
[08/04/2020 11:40:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],update agents set ledger_balance = '1'5''5'5.3' where id = ?;
[08/04/2020 11:40:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],UPDATE receipts set unadjusted_amount=unadjusted_amount- ? Where id= ?;
[08/04/2020 11:40:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],UPDATE booking_rate_info set  receipt_amount = receipt_amount+50 Where bid= '';
[08/04/2020 11:40:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO bank_account_operation 
			(account_id, amount, currency_code, amount_type, enter_date, 'agent', '6', 'creditnotecreate', 'CSH', '1.00000', '1.00000', '', '')
			VALUES ('5', '50', 'USD', '50'_type, '2020-08-04 11:40:33', :'agent', :'6', :'creditnotecreate', '50'_mode, :'1.00000', :'1.00000', :'', :'');
[08/04/2020 11:40:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],UPDATE bank_account_operation 
		set ledger_balance = (524.40 + 50) where id = '2' and account_id = '5' and account_type='agent' and site_id = '';
[08/04/2020 11:40:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],UPDATE agents SET credit_usage=credit_usage+('50'),   credit_value= credit_value-('50') ,  cd_credit_usage=cd_credit_usage+('50') , cd_credit_value=cd_credit_value-('50')  WHERE id = '5';
[08/04/2020 11:40:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],insert into  agent_credit_log SET agent_id= '5',credit_value= '49994192.600',credit_usage= '5807.400',credit_limit= '50000000',receipt_id= '',amount= '50',booking_id='23',booking_cost= '2265.5',receipt_allocation= '50.00',balance= '2215.5',ip='60.254.42.39',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Receipt Deleted',note='Receipt Deleted',create_date='2020-08-04 11:08:45';
[08/04/2020 11:40:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],update agents set ledger_balance =ledger_balance + '50'  where id = '5';
[08/04/2020 11:40:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],delete from receipts_bookings where receipt_id = ? and booking_id = '23';
[08/04/2020 11:40:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],UPDATE booking_rate_info set  receipt_amount = receipt_amount-50.00 Where bid= '0';
[08/04/2020 11:40:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],update agents set ledger_balance = ledger_balance- '50' where id = '5';
[08/04/2020 11:40:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],delete from receipts WHERE id= ?;
[08/04/2020 11:41:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 5972 characters]',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1',create_date= '2020-08-04 11:41:47';
[08/04/2020 11:41:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 5932 characters]',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1',create_date= '2020-08-04 11:41:47';
[08/04/2020 11:41:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 6060 characters]',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1',create_date= '2020-08-04 11:41:48';
[08/04/2020 11:41:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 5972 characters]',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1',create_date= '2020-08-04 11:41:53';
[08/04/2020 11:41:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 5932 characters]',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1',create_date= '2020-08-04 11:41:53';
[08/04/2020 11:41:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 6060 characters]',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1',create_date= '2020-08-04 11:41:53';
