[08/26/2020 12:15:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],INSERT INTO accounts_webservcie SET project = 'The Fabulous Getaway', public_key = '1598444147', api_key = 'MTU5ODQ0NDE0N0IzMjM1N0VBMzI=', log_path = 'http://uat.tfg.otrams.net/project_folder/tfg_project/protected/account_logs/26_08_2020';
[08/26/2020 12:15:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_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,transaction_type,system_currency_value,roe_multiplier,system_bank_id,system_bank_ref,system_bank_charge,accounting_multiplier)
		VALUES( '0025','2020-08-26 00:00:00','Agent is paying for TFG102824', '', '1000.0000', '1000.0000', 'CSH', '', '', '', '2020-08-26 09:54:34', 'A', 'Accounts Webservice', '0', 'USD', 'receipt', 'CR', '1000', '1.0000000','','','','1.0000000');
[08/26/2020 12:15:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],update receipts set docNo= 'BR-4-08-2020' ,ledger_multiplier = '1.00000' where id = '7';
[08/26/2020 12:15:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],update agents set ledger_balance =ledger_balance + '1'0025''0025''0025''  where id = ?;
[08/26/2020 12:15:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into `user_logs` set `username`= 'Accounts Webservice',`create_date`= '2020-08-26 12:15:49',`log_type`= 'Agent Receipt added',`sql_query`= '',`log_description`= 'Reciept NO. 7 added for Agent 0025',`ip`= '209.236.114.174';
[08/26/2020 12:15:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into user_log_link Set `user_logs_id`='3563', `entity`='Agents', `value`='0025' ;
[08/26/2020 12:15:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],INSERT INTO accounts_webservcie SET project = 'The Fabulous Getaway', public_key = '1598444149', api_key = 'MTU5ODQ0NDE0OUIzMjM1N0VBMzI=', log_path = 'http://uat.tfg.otrams.net/project_folder/tfg_project/protected/account_logs/26_08_2020';
[08/26/2020 12:15:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],INSERT INTO receipts_bookings set booking_id= '2792' ,agent_id= '0025' ,booking_rate_id= '1306' ,receipt_id= '7' ,source_type= 'misc' ,amount_received= '3.0700' ,payment_status= '' ,service_type= 'mISC' ,create_date= '2020-08-26 12:15:42' ,site_id = '';
[08/26/2020 12:15:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE agents SET credit_usage=credit_usage+('-3.07'),   credit_value= credit_value-('-3.07') ,  cd_credit_usage=cd_credit_usage+('-3.07') , cd_credit_value=cd_credit_value-('-3.07')  WHERE id = '25';
[08/26/2020 12:15:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '1446.570',credit_usage= '12553.430',credit_limit= '14000',receipt_id= '7',amount= '-3.07',booking_id='2792',booking_cost= '',receipt_allocation= '3.07',balance= '-3.07',ip='209.236.114.174',user_type='Cron',admin_id='',temp_credit_limit='',log_type='Receipt Allocated To Booking',note='Receipt Allocated To Booking',create_date='2020-08-26 12:08:50';
[08/26/2020 12:15:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE receipts set unadjusted_amount=unadjusted_amount- '3.0700' Where id= '7';
[08/26/2020 12:15:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE booking_rate_info set  receipt_amount = receipt_amount+(3.0700) Where bid= '1306' ;
[08/26/2020 12:15:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],update agents set ledger_balance = ledger_balance-'3.'0025'7'  where id = ? ;
[08/26/2020 12:15:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],update booking_rate_info set tax_invoice='1' where acc_type='sale' and bid = '1306';
[08/26/2020 12:15:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_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
        ('','','2792','vouchered','2020-08-26 12:15:50','Booking Receipt Allocated by id -Booking Receipt Allocated by id - By Auto Cron','','209.236.114.174','','','yes');
