[07/25/2020 02:05:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],update agents set ledger_balance = ledger_balance- '1800' where id = '21';
[07/25/2020 02:05:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],delete from receipts WHERE id= ?;
[07/25/2020 02:15:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO receipts_bookings set booking_id= '17' ,agent_id= '5' ,booking_rate_id= '10' ,receipt_id= '2' ,source_type= 'localsystem' ,amount_received= '95.000' ,payment_status= '' ,service_type= 'hotel' ,create_date= '2020-07-25 14:15:55' ,site_id = '';
[07/25/2020 02:15:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],UPDATE agents SET credit_usage=credit_usage+('-95'),   credit_value= credit_value-('-95') ,  cd_credit_usage=cd_credit_usage+('-95') , cd_credit_value=cd_credit_value-('-95')  WHERE id = '5';
[07/25/2020 02:15:55], [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= '2',amount= '-95',booking_id='17',booking_cost= '',receipt_allocation= '95.00',balance= '-95',ip='45.120.147.56',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Receipt Allocated To Booking',note='Receipt Allocated To Booking',create_date='2020-07-25 14:07:55';
[07/25/2020 02:15:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],UPDATE receipts set unadjusted_amount=unadjusted_amount- '95.000' Where id= '2';
[07/25/2020 02:15:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],UPDATE booking_rate_info set  receipt_amount = receipt_amount+(95.000) Where bid= '10' ;
[07/25/2020 02:15:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],update agents set ledger_balance = ledger_balance-'95'  where id = ? ;
[07/25/2020 02:15:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],update booking_rate_info set tax_invoice='1' where acc_type='sale' and bid = '10';
[07/25/2020 02:15:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','17','cancelled','2020-07-25 14:15:55','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','17','cancelled','2020-07-25 14:15:55','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','18','cancelled','2020-07-25 14:15:55','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','18','cancelled','2020-07-25 14:15:55','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','19','cancelled','2020-07-25 14:15:55','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','19','cancelled','2020-07-25 14:15:55','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','20','cancelled','2020-07-25 14:15:55','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','20','cancelled','2020-07-25 14:15:56','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','21','cancelled','2020-07-25 14:15:56','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','21','cancelled','2020-07-25 14:15:56','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','23','vouchered','2020-07-25 14:15:56','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','24','vouchered','2020-07-25 14:15:56','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','27','vouchered','2020-07-25 14:15:56','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','28','vouchered','2020-07-25 14:15:56','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','33','cancelled','2020-07-25 14:15:56','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','33','cancelled','2020-07-25 14:15:56','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','34','vouchered','2020-07-25 14:15:56','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','35','vouchered','2020-07-25 14:15:56','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','40','vouchered','2020-07-25 14:15:56','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','44','cancelled','2020-07-25 14:15:56','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','44','cancelled','2020-07-25 14:15:56','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:15:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','44','cancelled','2020-07-25 14:15:56','Booking Receipt Allocated by id -tfg by tfg','tfg','45.120.147.56','tfg','','');
[07/25/2020 02:18:12], [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, 5976 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-07-25 14:18:12';
[07/25/2020 02:18:12], [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, 5936 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-07-25 14:18:12';
[07/25/2020 02:18:12], [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, 6064 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-07-25 14:18:12';
