[07/03/2024 01:14:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into agents SET admin_id= 'qtech',username= 'test_gajendra',executive_id= '',agency_name= 'qtech',other_language_agency_name= '',first_name= 'Gajendra',middle_name= '',last_name= 'singh',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '30000',credit_limit= '30000',credit_value= '30000',credit_usage='0',temp_credit_limit= '',address= 'test address line',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '5.5',enable_dst= '',branch_id='32',phone= '91-9876543213',mobile= '91-1234567890',fax= '',credit_distribution= '0',currency= '4',email= 'gajendra.rajpurohit@qtechsoftware.com',website= '',password= '140696a95d1eccc972e476083219014c8553cd19f245ce1a04b27ee9b6e52a2f',lead_time= '',debug= '',search_by_multicurrency= '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= '1',markup= '2.0',allow_book_under_cancellation='1',create_date='2024-07-03 13:14:51',modify_date='',consultant_id= 'hotelyards',agency_email= '',expiry_date= '2024-10-01 13:14:51',acc_name= 'DEEPAK',acc_email= 'deepak.trivedi@qtechsoftware.com',acc_phone= '',man_name= '',man_email= '',man_phone= '',res_name= '',res_email= '',res_phone= '',ip_addr= '43.239.53.130',apply_service_tax= 'no',allow_ticketing= '',site_id='21',wh_main_agent='7867',wh_agent='yes',remarks= '',logo='',status='A';
[07/03/2024 01:14:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'7876' , expiry_date = '2'7876'24-1'7876'-'7876'1 13:14:51',cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ? and site_id = '21';
