[07/31/2020 06:00:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/31/2020 06:00:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '1' ,status = '1' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[07/31/2020 06:00:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '6' ,status = '' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[07/31/2020 06:00:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '3' ,status = '1' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[07/31/2020 06:00:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '2' ,status = '1' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[07/31/2020 06:00:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '4' ,status = '' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[07/31/2020 06:00:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '5' ,status = '1' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[07/31/2020 06:00:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-31 06:00:35',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 1 ,status = \&#039;1\&#039; ,priority = \&#039;0.00\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;0.00\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;0\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 6 ,status = \&#039;\&#039; ,priority = \&#039;0.00\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;0.00\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;0\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 3 ,status = \&#039;1\&#039; ,priority = \&#039;0.00\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;0.00\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;0\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 2 ,status = \&#039;1\&#039; ,priority = \&#039;0.00\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;0.00\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;0\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 4 ,status = \&#039;\&#039; ,priority = \&#039;0.00\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;0.00\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;0\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 5 ,status = \&#039;1\&#039; ,priority = \&#039;0.00\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;0.00\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;0\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-25 ## supplier_id- 1 ## company_name - Contracted Hotels ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '60.254.44.39';
[07/31/2020 06:00:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3452', `entity`='Agents', `value`='25' ;
[07/31/2020 06:01:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],DELETE FROM agent_localsupplier_settings WHERE agent_id=25;
[07/31/2020 06:01:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_localsupplier_settings (agent_id,supplier_id,status,percentage) VALUES ('25','S000000216','2','2');
[07/31/2020 06:01:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/manage_documents.php],INSERT INTO business_documents SET entity_id = '25',document_type = 'sasa',entity_type = 'agent',display_filename = 'index.jpg',disk_filename  = 'e7ecfd2f8a095a29f0a5d041d7349b16e94e4f7791af5629ce8c097bd0dd20bb.jpg',create_date_time  = '2020/07/31',mime_type  = 'image/jpeg',backoffice_user  = 'tfg';
[07/31/2020 06:01:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-07-31 06:01:45',login_attempt=0 where id = '25';
[07/31/2020 06:01:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PhpTest', user_type = 'A', branch_id = '1', login_datetime = '2020-07-31 06:01:45', ip = '60.254.44.39', action = 'Login' ;
[07/31/2020 06:01:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cal_hashcode=CONCAT(cal_hashcode, 'I') ,status='I',modify_date='2'25'2'25'-'25'7-31 '25'6:'25'1:57' WHERE id= ? and status='A';
[07/31/2020 06:01:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-31 06:01:57',`log_type`= 'Agent Deactived',`sql_query`= 'UPDATE agents SET cal_hashcode=CONCAT(cal_hashcode, \&#039;I\&#039;) ,status=\&#039;I\&#039;,modify_date=\&#039;2\&#039;25\&#039;2\&#039;25\&#039;-\&#039;25\&#039;7-31 \&#039;25\&#039;6:\&#039;25\&#039;1:57\&#039; WHERE id= ? and status=\&#039;A\&#039;',`log_description`= 'Agent 25 updated For  - status=A&modify_date=2020-07-30+13%3A28%3A35&cal_hashcode=476520ab9097d152b556a829c3be8fa3417c66e1e7fa6dcebf80f4876620909d changed to - status=I&modify_date=2020-07-31+06%3A01%3A57&cal_hashcode=476520ab9097d152b556a829c3be8fa3417c66e1e7fa6dcebf80f4876620909dI',`ip`= '60.254.44.39';
[07/31/2020 06:01:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3453', `entity`='Agents', `value`='25' ;
[07/31/2020 06:03:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cal_hashcode='c75f141da141291d9'25''25'eb8d6181a3bae833b8df17bac32ca99e1f41bb83656a1' ,expiry_date = '2'25'2'25'-1'25'-29 '25'6:'25'3:32',status='A',modify_date='2'25'2'25'-'25'7-31 '25'6:'25'3:32'  WHERE id= ? ;
[07/31/2020 06:03:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],update agents set last_login_date = '2020-07-31 06:03:32',login_attempt=0 where id = '25';
[07/31/2020 06:03:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-31 06:03:32',`log_type`= 'Agent Activated',`sql_query`= 'UPDATE agents SET cal_hashcode=\&#039;c75f141da141291d9\&#039;25\&#039;\&#039;25\&#039;eb8d6181a3bae833b8df17bac32ca99e1f41bb83656a1\&#039; ,expiry_date = \&#039;2\&#039;25\&#039;2\&#039;25\&#039;-1\&#039;25\&#039;-29 \&#039;25\&#039;6:\&#039;25\&#039;3:32\&#039;,status=\&#039;A\&#039;,modify_date=\&#039;2\&#039;25\&#039;2\&#039;25\&#039;-\&#039;25\&#039;7-31 \&#039;25\&#039;6:\&#039;25\&#039;3:32\&#039;  WHERE id= ? ',`log_description`= 'Agent 25 updated For  - status=I&modify_date=2020-07-31+06%3A01%3A57&last_login_date=2020-07-31+06%3A01%3A45&cal_hashcode=476520ab9097d152b556a829c3be8fa3417c66e1e7fa6dcebf80f4876620909dI changed to - status=A&modify_date=2020-07-31+06%3A03%3A32&last_login_date=2020-07-31+06%3A03%3A32&cal_hashcode=c75f141da141291d900eb8d6181a3bae833b8df17bac32ca99e1f41bb83656a1',`ip`= '60.254.44.39';
[07/31/2020 06:03:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3454', `entity`='Agents', `value`='25' ;
[07/31/2020 06:05:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into email_logs SET `subject`= 'Registration Acknowledgement - Agent ID - 25 The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 20416 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,snehal.valanju@qtechsoftwrae.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/resend_email.php?action=agent_registration_email&agent_id=25',create_date= '2020-07-31 06:05:10';
[07/31/2020 06:05:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into email_logs SET `subject`= 'Login Details - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 15776 characters]',to_email_id= 'snehal.valanju@qtechsoftwrae.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/resend_email.php?action=agent_confirmation_email&agent_id=25',create_date= '2020-07-31 06:05:18';
[07/31/2020 06:06:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access_agent.php],DELETE FROM report_access where psa_user_id='25';
[07/31/2020 06:06:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access_agent.php],INSERT INTO report_access SET psa_user_id='25',report_function_name='customer_statement';

[07/31/2020 06:12:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/sub_agent.php],insert into email_logs SET `subject`= 'Registration Acknowledgement - Agent ID 26 The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 10128 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,snehal.valanju@qtechsoftware.com,snehal.valanju@qtechsoftwrae.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/sub_agent.php?branch_search=&consultant_search=&agent_type_search=&country_srch=&agency_name_search=&username_search=PhpTest&status_search=&person_name_search=&search=agent&country_search=&city_search=&currency_search=&rate_profile_search=&email_search=&agency_id_search=',create_date= '2020-07-31 06:12:28';
[07/31/2020 06:12:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-07-31 06:12:35',login_attempt=0 where id = '26';
[07/31/2020 06:12:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-07-31 06:12:35' where id = '25';
[07/31/2020 06:12:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'SubUser', user_type = 'A', branch_id = '1', login_datetime = '2020-07-31 06:12:35', ip = '60.254.44.39', action = 'Login' ;


[07/31/2020 06:13:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3455', `entity`='Agents', `value`='26' ;
[07/31/2020 06:13:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into email_logs SET `subject`= 'Agent Changed Password - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 9000 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/agent.php',create_date= '2020-07-31 06:13:33';
[07/31/2020 06:14:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/customer_category_markup.php],INSERT INTO agent_category_markup_settings SET service_type= 'Hotel',hotel_category_id= '5',agent_category_id= '5',markup= '1',created_by = 'tfg',created_at = '2020-07-31 06:07:42';
[07/31/2020 06:14:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/customer_category_markup.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-31 06:14:42',`log_type`= 'Customer Category Markup Mapping',`sql_query`= 'select count(*) as count from agent_category_markup_settings where service_type = \&#039;Hotel\&#039; and agent_category_id =  \&#039;\&#039; and hotel_category_id= \&#039;5\&#039;1 ',`log_description`= 'A Customer Category Markup Mapping has been done',`ip`= '60.254.44.39';
[07/31/2020 06:15:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/customer_category_markup.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-31 06:15:37',`log_type`= 'Customer Category Markup Mapping',`sql_query`= 'UPDATE agent_category_markup_settings SET markup= \&#039;2.00\&#039;,updated_at= \&#039;2020-07-31 06:07:37\&#039;,updated_by= \&#039;tfg\&#039; WHERE id= \&#039;52\&#039;',`log_description`= 'A Manual Customer Category Markup Mapping has been edited.  updated For  -   ---- changed to - ',`ip`= '60.254.44.39';
[07/31/2020 06:17:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/customer_category_markup.php],INSERT INTO agent_category_markup_settings SET service_type= 'Hotel',hotel_category_id= '5',agent_category_id= '1',markup= '2',created_by = 'tfg',created_at = '2020-07-31 06:07:34';
[07/31/2020 06:17:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/customer_category_markup.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-31 06:17:34',`log_type`= 'Customer Category Markup Mapping',`sql_query`= 'select count(*) as count from agent_category_markup_settings where service_type = \&#039;Hotel\&#039; and agent_category_id =  \&#039;\&#039; and hotel_category_id= \&#039;5\&#039;1 ',`log_description`= 'A Customer Category Markup Mapping has been done',`ip`= '60.254.44.39';
[07/31/2020 06:19:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/customer_category_markup.php],DELETE from agent_category_markup_settings WHERE id='53';
[07/31/2020 06:19:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/customer_category_markup.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-31 06:19:00',`log_type`= 'Customer Category Markup Mapping',`sql_query`= 'DELETE from agent_category_markup_settings WHERE id=\&#039;53\&#039;',`log_description`= 'A Manual Customer Category Markup Mapping has been Deleted',`ip`= '60.254.44.39';
[07/31/2020 06:40:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_message.php],insert into email_logs SET `subject`= 'Message Acknowledgment - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 4772 characters]',to_email_id= 'otramsmessages@thefabulousgetaway.com',cc= 'snehal.valanju@qtechsoftwrae.com',bcc= '',status= 'Success',page_url= '/tms/add_message.php',create_date= '2020-07-31 06:40:58';
[07/31/2020 06:41:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_message.php],UPDATE msg_message set msg_subject= 'UAT Testing',message= 'Hi Agent,
Please make sure you clear all your payments.
--
Regards,',modify_datetime= '2020-07-31 06:41:07' Where id ='12';
[07/31/2020 06:41:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_message.php],UPDATE msg_message set msg_subject= 'UAT Testing',message= 'Hi Agent,
Please make sure you clear all your payments.
--
Regards,',modify_datetime= '2020-07-31 06:41:07' Where id ='12';
[07/31/2020 06:42:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/message_inbox.php],UPDATE msg_message set receiver_view_count=1 WHERE id= ?;
[07/31/2020 06:42:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_message.php],insert into email_logs SET `subject`= 'Message Acknowledgment - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 4752 characters]',to_email_id= 'otramsmessages@thefabulousgetaway.com',cc= 'snehal.valanju@qtechsoftwrae.com',bcc= '',status= 'Success',page_url= '/tms/add_message.php',create_date= '2020-07-31 06:42:44';
[07/31/2020 06:48:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscriber_list.php], Insert into subscriber_lists(name, from_name, reply_to_email, created, created_by) values('UATGroup', 'Snehal', 'snehal.valanju@qtechsoftware.com', '2020-07-31 06:48:04', '2020-07-31 06:48:04'_by);
[07/31/2020 06:48:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscriber_list.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-31 06:48:04',`log_type`= 'Insert Subscriber List',`sql_query`= ' Insert into subscriber_lists(name, from_name, reply_to_email, created, created_by) values(:name, :from_name, :reply_to_email, :created, :created_by)',`log_description`= 'Subscriber List has been added',`ip`= '60.254.44.39';
[07/31/2020 06:48:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscriber_list.php], UPDATE subscriber_lists SET  name= 'UATGroupOfTesters', from_name= 'Snehal', reply_to_email= 'snehal.valanju@qtechsoftware.com', modified= '2020-07-31 06:48:36', modified_by= '2020-07-31 06:48:36'_by WHERE id= '1';
[07/31/2020 06:48:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/subscriber_list.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-31 06:48:36',`log_type`= 'Update Subscriber List',`sql_query`= ' UPDATE subscriber_lists SET  name= :name, from_name= :from_name, reply_to_email= :reply_to_email, modified= :modified, modified_by= :modified_by WHERE id= :id',`log_description`= 'Subscriber List has been updated',`ip`= '60.254.44.39';
