[09/01/2020 11:03:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO customers SET salutations='Ms',first_name='Ankita', last_name='Test', email='ankita.rao@qtechsoftware.com',address='2-402, Atlanta Center,
Sonawala Road,
Goregaon East
Mumbai - 400063', mobile='7666065659', create_date='2020-09-01 11:03:24';;
[09/01/2020 11:03:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO enquiry SET agent_id = '22', contact_salutation = 'Ms', contact_first_name = 'Ankita', contact_last_name = 'Test', contact_name = 'Ankita Test', email_id = 'ankita.rao@qtechsoftware.com', contact_no = '7666065659', residing_country = '106', currency = 'USD', enquiry_source = 'email', destination = '132', nationality = '106', customer_id = '80', created_by = 'tfg', create_date= '2020-09-01 11:03:24';
[09/01/2020 11:03:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO task SET module_id='391',module='enquiry',task_status='open',status='A',create_date='2020-09-01 11:03:24' ,created_by='tfg', task_priority='medium', task_description='Offline Quotation Enquiry has been added by tfg&lt;br/&gt;Agent : Qtech Ankita [CA0022-Nilesh] [Nilesh-Rao]&lt;br/&gt;Country : Sri Lanka&lt;br/&gt;Selected Currency : USD&lt;br/&gt;';
[09/01/2020 11:04:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.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-09-01 11:04:57', '', '', '');
[09/01/2020 11:17:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],INSERT INTO tax_master (`tax_name`,`tax_value`,`tax_type`,`created_by`,`created_on`) VALUES ('STATUTORY	','3','OP','tfg','2020-09-01 11:17:28');
[09/01/2020 11:17:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-01 11:17:28',`log_type`= 'Tax Master',`sql_query`= 'INSERT INTO tax_master (`tax_name`,`tax_value`,`tax_type`,`created_by`,`created_on`) VALUES (\&#039;STATUTORY	\&#039;,\&#039;3\&#039;,\&#039;OP\&#039;,\&#039;tfg\&#039;,\&#039;2020-09-01 11:17:28\&#039;)',`log_description`= 'Tax Master added for STATUTORY	 value 3 and type OP',`ip`= '43.250.210.87';
[09/01/2020 11:18:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php], UPDATE `tax_configuration` SET
		`branch_country` = '132' ,
		`branch_state` = '' ,
        `branch` = '' ,
		`valid_from` = '2019-04-03' ,
		`valid_to` = '2050-12-31' ,
		`supplier_registered` = '0' ,
		`supplier_country` = '0' ,
        `supplier_type` = 'external' ,
		`service` = '10' ,
		`sub_service` = '' ,
		`exempted` = '0' ,
		`consumed` = 'IB' ,
		`has_consumed_location` = '0' ,
		`type` = 'IN' ,
		`system` = 'b2b' ,
		`input_tax_id` = '0' ,
		`input_tax_amt` = '0' ,
		`output_tax_id` = '6' ,
		`output_tax_amt` = '3' ,
		`updated_by` = 'tfg' ,
		`updated_on` = '2020-09-01 11:18:18'
		WHERE `id` = 4 ;
[09/01/2020 11:18:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-01 11:18:18',`log_type`= 'Tax Configuration',`sql_query`= ' UPDATE `tax_configuration` SET
		`branch_country` = \&#039;132\&#039; ,
		`branch_state` = \&#039;\&#039; ,
        `branch` = \&#039;\&#039; ,
		`valid_from` = \&#039;2019-04-03\&#039; ,
		`valid_to` = \&#039;2050-12-31\&#039; ,
		`supplier_registered` = \&#039;0\&#039; ,
		`supplier_country` = \&#039;0\&#039; ,
        `supplier_type` = \&#039;external\&#039; ,
		`service` = \&#039;10\&#039; ,
		`sub_service` = \&#039;\&#039; ,
		`exempted` = \&#039;0\&#039; ,
		`consumed` = \&#039;IB\&#039; ,
		`has_consumed_location` = \&#039;0\&#039; ,
		`type` = \&#039;IN\&#039; ,
		`system` = \&#039;b2b\&#039; ,
		`input_tax_id` = \&#039;0\&#039; ,
		`input_tax_amt` = \&#039;0\&#039; ,
		`output_tax_id` = \&#039;6\&#039; ,
		`output_tax_amt` = \&#039;3\&#039; ,
		`updated_by` = \&#039;tfg\&#039; ,
		`updated_on` = \&#039;2020-09-01 11:18:18\&#039;
		WHERE `id` = 4 ',`log_description`= 'Tax Configuration updated',`ip`= '43.250.210.87';
[09/01/2020 11:18:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],DELETE FROM tax_consumed_location WHERE tax_config_id=?;
[09/01/2020 11:19:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php], UPDATE `tax_configuration` SET
		`branch_country` = '132' ,
		`branch_state` = '' ,
        `branch` = '' ,
		`valid_from` = '2019-01-01' ,
		`valid_to` = '2050-12-31' ,
		`supplier_registered` = '1' ,
		`supplier_country` = '0' ,
        `supplier_type` = 'internal' ,
		`service` = '10' ,
		`sub_service` = '' ,
		`exempted` = '0' ,
		`consumed` = 'IB' ,
		`has_consumed_location` = '0' ,
		`type` = 'IN' ,
		`system` = 'b2b' ,
		`input_tax_id` = '0' ,
		`input_tax_amt` = '0' ,
		`output_tax_id` = '6' ,
		`output_tax_amt` = '3' ,
		`updated_by` = 'tfg' ,
		`updated_on` = '2020-09-01 11:19:08'
		WHERE `id` = 9 ;
[09/01/2020 11:19:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-01 11:19:08',`log_type`= 'Tax Configuration',`sql_query`= ' UPDATE `tax_configuration` SET
		`branch_country` = \&#039;132\&#039; ,
		`branch_state` = \&#039;\&#039; ,
        `branch` = \&#039;\&#039; ,
		`valid_from` = \&#039;2019-01-01\&#039; ,
		`valid_to` = \&#039;2050-12-31\&#039; ,
		`supplier_registered` = \&#039;1\&#039; ,
		`supplier_country` = \&#039;0\&#039; ,
        `supplier_type` = \&#039;internal\&#039; ,
		`service` = \&#039;10\&#039; ,
		`sub_service` = \&#039;\&#039; ,
		`exempted` = \&#039;0\&#039; ,
		`consumed` = \&#039;IB\&#039; ,
		`has_consumed_location` = \&#039;0\&#039; ,
		`type` = \&#039;IN\&#039; ,
		`system` = \&#039;b2b\&#039; ,
		`input_tax_id` = \&#039;0\&#039; ,
		`input_tax_amt` = \&#039;0\&#039; ,
		`output_tax_id` = \&#039;6\&#039; ,
		`output_tax_amt` = \&#039;3\&#039; ,
		`updated_by` = \&#039;tfg\&#039; ,
		`updated_on` = \&#039;2020-09-01 11:19:08\&#039;
		WHERE `id` = 9 ',`log_description`= 'Tax Configuration updated',`ip`= '43.250.210.87';
[09/01/2020 11:19:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],DELETE FROM tax_consumed_location WHERE tax_config_id=?;
