[08/21/2020 07:03:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/ez_settings.php],update psa_branches set branch_currency='USD' where id ='1' limit 1;
[08/21/2020 07:03:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/ez_settings.php],INSERT INTO ez_configuration(`branch_id`,`branch_name`,`currency` ,`system`,`transaction`,`tax`,`discount`,`markup`,`receipt`,`payment_transaction`,`modification`) VALUES ('1','Qtech Pvt Ltd','USD' ,"b2b","SP","Y","Y","Y","Y","Y","DN_CN");
[08/21/2020 07:03:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/ez_settings.php],INSERT INTO `ez_services`(`service`,`fields`)VALUES('Airline','FlightName,FlightNumber,FromCity,ToCity,StartDate,StartTime,JourneyTime,ConnectingFlight,ReservationID');
[08/21/2020 07:03:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/ez_settings.php],INSERT INTO `ez_services`(`service`,`fields`)VALUES('hotel','HotelName,CheckIn,CheckOut,DeadlineDate,ConsultantName,NumberOfNights,RoomType,NoOfRooms');
[08/21/2020 07:03:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/ez_settings.php],INSERT INTO `ez_services`(`service`,`fields`)VALUES('sightseeing','SightseeingName,TotalAdults,TourLanguage,TourDuration,Destination,TourDates');
[08/21/2020 07:03:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/ez_settings.php],INSERT INTO `ez_services`(`service`,`fields`)VALUES('transfer','TransferName,TotalPassengers,Destination,TransferDates');
[08/21/2020 07:04:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE ez_configuration SET accounts_processed = '1'  WHERE branch_name = 'Qtech Pvt Ltd';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  agents set accounts_processed = '1' WHERE id = '1';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  agents set accounts_processed = '1' WHERE id = '4';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  agents set accounts_processed = '1' WHERE id = '8';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  agents set accounts_processed = '1' WHERE id = '9';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  agents set accounts_processed = '1' WHERE id = '12';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  agents set accounts_processed = '1' WHERE id = '15';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  agents set accounts_processed = '1' WHERE id = '18';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  agents set accounts_processed = '1' WHERE id = '20';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  agents set accounts_processed = '1' WHERE id = '22';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  agents set accounts_processed = '1' WHERE id = '23';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  agents set accounts_processed = '1' WHERE id = '24';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  agents set accounts_processed = '1' WHERE id = '25';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  suppliers set accounts_processed = '1' WHERE id = '1';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  suppliers set accounts_processed = '1' WHERE id = '2';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  suppliers set accounts_processed = '1' WHERE id = '3';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  suppliers set accounts_processed = '1' WHERE id = '4';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  suppliers set accounts_processed = '1' WHERE id = '5';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  suppliers set accounts_processed = '1' WHERE id = '6';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000066';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000035';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000003';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000072';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000070';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000078';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000071';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000054';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000088';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000236';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000001';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000002';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000004';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000005';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000006';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000007';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000008';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000009';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000010';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000011';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000012';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000013';
[08/21/2020 07:09:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000014';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000015';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000016';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000017';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000018';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000019';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000020';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000021';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000022';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000023';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000024';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000025';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000026';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000027';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000028';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000029';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000030';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000031';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000032';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000033';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000034';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000036';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000037';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000038';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000039';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000040';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000041';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000042';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000043';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000044';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000045';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000046';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000047';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000048';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000049';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000050';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000051';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000052';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000053';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000055';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000056';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000057';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000058';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000059';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000060';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000061';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000062';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000063';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000064';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000065';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000067';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000068';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000069';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000073';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000074';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000075';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000076';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000077';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000079';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000080';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000081';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000082';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000083';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000084';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000085';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000086';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000087';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000089';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000090';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000091';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000092';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000190';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000191';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000192';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000193';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000194';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000195';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000196';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000197';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000198';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000199';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000200';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000201';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000202';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000203';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000204';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000205';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000206';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000207';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000208';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000209';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000210';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000211';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000212';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000213';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000214';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000215';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000216';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000217';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000218';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000219';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000220';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000221';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000222';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000223';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000224';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000225';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000226';
[08/21/2020 07:09:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000227';
[08/21/2020 07:09:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000228';
[08/21/2020 07:09:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000229';
[08/21/2020 07:09:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000230';
[08/21/2020 07:09:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000231';
[08/21/2020 07:09:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000232';
[08/21/2020 07:09:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000233';
[08/21/2020 07:09:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000234';
[08/21/2020 07:09:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000235';
[08/21/2020 07:09:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000237';
[08/21/2020 07:09:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000238';
[08/21/2020 07:09:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE  supplier set accounts_processed = '1' WHERE SupplierId = 'S000000239';
[08/21/2020 07:09:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE tax_services SET accounts_export = '1'  WHERE FIND_IN_SET(id,'4,53,59');
[08/21/2020 07:24:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/ez_settings.php],update psa_branches set branch_currency='USD' where id ='1' limit 1;
[08/21/2020 07:24:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/ez_settings.php],INSERT INTO ez_configuration(`branch_id`,`branch_name`,`currency` ,`system`,`transaction`,`tax`,`discount`,`markup`,`receipt`,`payment_transaction`,`modification`) VALUES ('1','Qtech Pvt Ltd','USD' ,"b2b","SP","Y","Y","Y","Y","Y","DN_CN");
[08/21/2020 07:24:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/ez_settings.php],INSERT INTO `ez_services`(`service`,`fields`)VALUES('Airline','FlightName,FlightNumber,FromCity,ToCity,StartDate,StartTime,JourneyTime,ConnectingFlight,ReservationID');
[08/21/2020 07:24:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/ez_settings.php],INSERT INTO `ez_services`(`service`,`fields`)VALUES('hotel','HotelName,CheckIn,CheckOut,DeadlineDate,ConsultantName,NumberOfNights,RoomType,NoOfRooms');
[08/21/2020 07:24:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/ez_settings.php],INSERT INTO `ez_services`(`service`,`fields`)VALUES('sightseeing','SightseeingName,TotalAdults,TourLanguage,TourDuration,Destination,TourDates');
[08/21/2020 07:24:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/ez_settings.php],INSERT INTO `ez_services`(`service`,`fields`)VALUES('transfer','TransferName,TotalPassengers,Destination,TransferDates');
[08/21/2020 07:52:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE psa_branches SET acc_export = '1'  WHERE id = '1';
[08/21/2020 07:52:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE psa_branches SET acc_export = '1'  WHERE id = '2';
[08/21/2020 07:52:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE psa_branches SET acc_export = '1'  WHERE id = '3';
[08/21/2020 07:52:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE psa_branches SET acc_export = '1'  WHERE id = '4';
[08/21/2020 07:52:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE psa_branches SET acc_export = '1'  WHERE id = '5';
[08/21/2020 07:52:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE psa_branches SET acc_export = '1'  WHERE id = '6';
[08/21/2020 07:52:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE psa_branches SET acc_export = '1'  WHERE id = '7';
[08/21/2020 07:52:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/v3_accounting_report.php],UPDATE psa_branches SET acc_export = '1'  WHERE id = '8';
