[12/21/2021 03:27:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/branch.php],update  `psa_branches` set logo='' where id=3;
[12/21/2021 03:30:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/branch.php],update  `psa_branches` set  `branch_name`= 'Red Dot Tours', `email_address`= 'ankita.rao@qtechsoftware.com', `accountant_email_address`= 'ankita.rao@qtechsoftware.com', `location_phone`= '2111111111', `location_addr`= '140 A , Vauxhall Street , 
Colombo 02.
Sri Lanka', `branch_note`= '&lt;div&gt;&lt;span style=&quot;\&quot; \&quot;font-weight:\&quot;&quot;=&quot;&quot; bold;\&quot;=&quot;\&quot; \&quot;&quot;=&quot;&quot;&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;&lt;span style=&quot;\&quot; font-weight:&quot;=&quot;&quot; bold;\&quot;=&quot;&quot;&gt;Flights taravel&lt;/span&gt;&lt;/span&gt; &lt;/span&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;falights \&#039;bsjdjajksj;laks;l aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb&lt;br&gt;&lt;/div&gt;&lt;div&gt;\&#039;a;&lt;/div&gt;&lt;div&gt;\&#039;s;&lt;/div&gt;&lt;div&gt;a&lt;/div&gt;', `bank_address`= '', `location_country`= '132', `location_city`= '71100', `branch_location`= 'colombo', `modify_by`= 'tfg', `modify_date`= '2021-12-21 15:30:55', `updated`= '2021-12-21 15:30:55', `site_id`= '', `logo`= '950dfa24ab9cd0f7f612349886b4c623_branch_logo.jpeg', `txt_tax_no`= '2111111111', `branch_markup`= '0', `is_booking_email_received`= '', `active`='Y'  where `id` = '3' ;
[12/21/2021 03:30:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/branch.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-12-21 15:30:55',`log_type`= 'Branch',`sql_query`= 'update  `psa_branches` set  `branch_name`= :branch_name, `email_address`= :email_address, `accountant_email_address`= :accountant_email_address, `location_phone`= :location_phone, `location_addr`= :location_addr, `branch_note`= :branch_special_note, `bank_address`= :bank_address, `location_country`= :location_country, `location_city`= :location_city, `branch_location`= :branch_location, `modify_by`= :modify_by, `modify_date`= :modify_date, `updated`= :updated, `site_id`= :site_id, `logo`= :logo, `txt_tax_no`= :tax_no, `branch_markup`= :branch_markup, `is_booking_email_received`= :is_booking_email_received, `active`=:active  where `id` = :branch_id ',`log_description`= 'Branch Red Dot Tours updated For  - updated=2021-11-12+11%3A53%3A38&modify_date=2021-11-12+11%3A53%3A38&logo=&branch_note=%26lt%3Bdiv%26gt%3B%26lt%3Bspan+style%3D%26quot%3B%5C%26quot%3B%5C%26quot%3Bfont-weight%3A%5C%26quot%3B%26quot%3B+bold%3B%5C%26quot%3B%3D%26quot%3B%5C%26quot%3B%5C%26quot%3B%26quot%3B%26gt%3B%26lt%3Bspan+style%3D%26quot%3Bfont-weight%3A+bold%3B%26quot%3B%26gt%3B%26lt%3Bspan+style%3D%26quot%3B%5C%26quot%3Bfont-weight%3A%26quot%3B+bold%3B%5C%26quot%3B%3D%26quot%3B%26quot%3B%26gt%3BFlights+taravel%26lt%3B%2Fspan%26gt%3B%26lt%3B%2Fspan%26gt%3B+%26lt%3B%2Fspan%26gt%3B%26lt%3Bbr%26gt%3B%26lt%3B%2Fdiv%26gt%3B%26lt%3Bdiv%26gt%3Bfalights+%5C%26%23039%3Bbsjdjajksj%3Blaks%3Bl+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb%26lt%3Bbr%26gt%3B%26lt%3B%2Fdiv%26gt%3B%26lt%3Bdiv%26gt%3B%5C%26%23039%3Ba%3B%26lt%3B%2Fdiv%26gt%3B%26lt%3Bdiv%26gt%3B%5C%26%23039%3Bs%3B%26lt%3B%2Fdiv%26gt%3B%26lt%3Bdiv%26gt%3Ba%26lt%3B%2Fdiv%26gt%3B changed to - updated=2021-12-21+15%3A30%3A55&modify_date=2021-12-21+15%3A30%3A55&logo=950dfa24ab9cd0f7f612349886b4c623_branch_logo.jpeg&branch_note=%26lt%3Bdiv%26gt%3B%26lt%3Bspan+style%3D%26quot%3B%5C%26quot%3B+%5C%26quot%3Bfont-weight%3A%5C%26quot%3B%26quot%3B%3D%26quot%3B%26quot%3B+bold%3B%5C%26quot%3B%3D%26quot%3B%5C%26quot%3B+%5C%26quot%3B%26quot%3B%3D%26quot%3B%26quot%3B%26gt%3B%26lt%3Bspan+style%3D%26quot%3Bfont-weight%3A+bold%3B%26quot%3B%26gt%3B%26lt%3Bspan+style%3D%26quot%3B%5C%26quot%3B+font-weight%3A%26quot%3B%3D%26quot%3B%26quot%3B+bold%3B%5C%26quot%3B%3D%26quot%3B%26quot%3B%26gt%3BFlights+taravel%26lt%3B%2Fspan%26gt%3B%26lt%3B%2Fspan%26gt%3B+%26lt%3B%2Fspan%26gt%3B%26lt%3Bbr%26gt%3B%26lt%3B%2Fdiv%26gt%3B%26lt%3Bdiv%26gt%3Bfalights+%5C%26%23039%3Bbsjdjajksj%3Blaks%3Bl+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb%26lt%3Bbr%26gt%3B%26lt%3B%2Fdiv%26gt%3B%26lt%3Bdiv%26gt%3B%5C%26%23039%3Ba%3B%26lt%3B%2Fdiv%26gt%3B%26lt%3Bdiv%26gt%3B%5C%26%23039%3Bs%3B%26lt%3B%2Fdiv%26gt%3B%26lt%3Bdiv%26gt%3Ba%26lt%3B%2Fdiv%26gt%3B',`ip`= '43.239.53.130';
[12/21/2021 03:32:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/branch.php],update  `psa_branches` set logo='' where id=1;
[12/21/2021 03:32:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/branch.php],update  `psa_branches` set  `branch_name`= 'Qtech', `email_address`= 'ankita.rao@qtechsoftware.com', `accountant_email_address`= 'ankita.rao@qtechsoftware.com', `location_phone`= '2111111111', `location_addr`= '', `branch_note`= '', `bank_address`= '', `location_country`= '132', `location_city`= '82232', `branch_location`= 'Mumbai', `modify_by`= 'tfg', `modify_date`= '2021-12-21 15:32:44', `updated`= '2021-12-21 15:32:44', `site_id`= '', `logo`= 'cc8544ec7074b4bfb751c0000d4f3477_branch_logo.', `txt_tax_no`= '123456', `branch_markup`= '', `is_booking_email_received`= '', `active`='Y'  where `id` = '1' ;
[12/21/2021 03:32:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/branch.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-12-21 15:32:44',`log_type`= 'Branch',`sql_query`= 'update  `psa_branches` set  `branch_name`= :branch_name, `email_address`= :email_address, `accountant_email_address`= :accountant_email_address, `location_phone`= :location_phone, `location_addr`= :location_addr, `branch_note`= :branch_special_note, `bank_address`= :bank_address, `location_country`= :location_country, `location_city`= :location_city, `branch_location`= :branch_location, `modify_by`= :modify_by, `modify_date`= :modify_date, `updated`= :updated, `site_id`= :site_id, `logo`= :logo, `txt_tax_no`= :tax_no, `branch_markup`= :branch_markup, `is_booking_email_received`= :is_booking_email_received, `active`=:active  where `id` = :branch_id ',`log_description`= 'Branch Qtech updated For  - updated=2020-08-31+08%3A43%3A36&modify_date=2020-08-31+08%3A43%3A36&logo= changed to - updated=2021-12-21+15%3A32%3A44&modify_date=2021-12-21+15%3A32%3A44&logo=cc8544ec7074b4bfb751c0000d4f3477_branch_logo.',`ip`= '43.239.53.130';
[12/21/2021 03:34:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET agency_name= 'Qtech Ankita',other_language_agency_name= '',accounting_id= 'test',auto_voucher_bookings = '0',outstanding_limit = '0',accounting_name= '',first_name= 'Nilesh',middle_name= '',last_name= 'Rao',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '50000000',credit_limit= '50000000',credit_distribution= '0',temp_credit_limit= '',address= 'Atlanta Center',other_language_address= '',city= '71100',pincode= '',country= '132',time_zone_offset= '5.5',enable_dst= '',branch_id='1',phone= '022-4787878787',mobile= '0-914578996',fax= '',currency= '6',email= 'ankita.rao@qtechsofware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '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',allow_book_under_cancellation='1',modify_date='2021-12-21 15:34:17',consultant_id= 'tfg',agency_email= '',acc_name= 'ANKITA',acc_email= 'ankita.rao@qtechsofware.com',acc_phone= '',man_name= '',man_email= '',man_phone= '',res_name= '',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '',agent_category= '1',can_show_hotels= '',logo='1640100857covidlogo.jpeg' WHERE id= '22';
[12/21/2021 03:34:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-12-21 15:34:17',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= :agency_name,other_language_agency_name= :other_language_agency_name,accounting_id= :accounting_id,auto_voucher_bookings = :auto_voucher_bookings,outstanding_limit = :outstanding_limit,accounting_name= :accounting_name,first_name= :first_name,middle_name= :middle_name,last_name= :last_name,agent_type= :agent_type,sort_type= :sort_type,credit_limit_assigned= :credit_limit_assigned,credit_limit= :credit_limit,credit_distribution= :credit_distribution,temp_credit_limit= :temp_credit_limit,address= :address,other_language_address= :other_language_address,city= :city,pincode= :pincode,country= :country,time_zone_offset= :time_zone_offset,enable_dst= :enable_dst,branch_id=\&#039;1\&#039;,phone= :phone,mobile= :mobile,fax= :fax,currency= :currency,email= :email,website= :website,lead_time= :lead_time,search_by_multicurrency= :search_by_multicurrency,debug= :debug,profile= :profile,designation= :designation,iata_status= :iata_status,iata_number= :iata_number,nature_of_business= :nature_of_business,can_book= :can_book,sales_manager_id= :sales_manager_id,comp_reg_no= :comp_reg_no,allow_quotation= :allow_quotation,can_voucher= :can_voucher,allow_book_under_cancellation=\&#039;1\&#039;,modify_date=\&#039;2021-12-21 15:34:17\&#039;,consultant_id= :consultant_id,agency_email= :agency_email,acc_name= :acc_name,acc_email= :acc_email,acc_phone= :acc_phone,man_name= :man_name,man_email= :man_email,man_phone= :man_phone,res_name= :res_name,res_email= :res_email,res_phone= :res_phone,remarks= :remarks,apply_service_tax= :apply_service_tax,allow_ticketing= :allow_ticketing,agent_category= :agent_category,can_show_hotels= :can_show_hotels,logo=\&#039;1640100857covidlogo.jpeg\&#039; WHERE id= :id',`log_description`= 'Agent 22 updated For  - logo=&modify_date=2020-10-16+09%3A37%3A20 changed to - logo=1640100857covidlogo.jpeg&modify_date=2021-12-21+15%3A34%3A17',`ip`= '43.239.53.130';
[12/21/2021 03:34:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='4186', `entity`='Agents', `value`='22' ;
[12/21/2021 03:34:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'22' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[12/21/2021 03:34:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into  agent_credit_log SET agent_id= '22',credit_value= '49503252.380',credit_usage= '496747.620',credit_limit= '50000000',receipt_id= '',amount= '',ip='43.239.53.130',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by tfg',create_date='2021-12-21 15:12:17';
[12/21/2021 03:34:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '1',consultant_id= 'tfg',sales_manager_id= '',profile= '', auto_voucher_bookings = '0', outstanding_limit = '0', agent_type= 'CC' WHERE parent_agent= '22';
