[05/22/2024 12:20:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],update agents set login_attempt='0',expiry_date='2024-08-20 12:20:10',password= 'c75f28325cfa028ea13872f977a29e0e87c99a4f390fe260f24d7e1f05fb8d75'  where id = '7861';
[05/22/2024 12:20:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-22 12:20:10',`log_type`= 'Change Password',`sql_query`= '',`log_description`= 'MoonlightAgent Password updated',`ip`= '43.239.53.130';
[05/22/2024 12:20:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into user_log_link Set `user_logs_id`='1', `entity`='Agents', `value`='7861' ;
[05/22/2024 12:20:10], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO mails_error_log set mailfrom='rohan.vartak@qtechsoftware.com',mailsubject='Agent Changed Password - Astra Bookings',mailbody='
&lt;!DOCTYPE html PUBLIC \&quot;-//W3C//DTD XHTML 1.0 Transitional//EN\&quot; \&quot;http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\&quot;&gt; 
&lt;html xmlns=\&quot;http://www.w3.org/1999/xhtml\&quot;&gt;
&lt;head&gt;
&lt;meta http-equiv=\&quot;Content-Type\&quot; content=\&quot;text/html; charset=utf-8\&quot; /&gt;
&lt;title&gt;:: Astra Bookings :: &lt;/title&gt;

&lt;style type=\&quot;text/css\&quot;&gt;
@import url(https://fonts.googleapis.com/css?family=PT+Sans:400,400italic,700,700italic);
&lt;/style&gt;

&lt;/head&gt;
&lt;body style=\&quot;background:#EEEEEE;font-family: \&#039;PT Sans\&#039;, sans-serif;margin-top:0px;\&quot;&gt;
		&lt;div style=\&quot;background:#EEEEEE;padding:10px 0px;\&quot;&gt;
		&lt;table width=\&quot;700\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;background:#ffffff;font-size:13px;margin:0px auto;padding:0px 0px;border-collapse: collapse;\&quot;&gt;
	&lt;tr&gt;
		&lt;td&gt;
			&lt;table cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width:100%;\&quot;&gt;
				&lt;tr&gt;
					&lt;td style=\&quot;width:320px;padding:20px 0px 10px 35px;\&quot;&gt; 
						&lt;img src=\&quot;https://beta.astrabookings.com/project_folder/astra/images/astra_logo.png\&quot; alt=\&quot;ASTRA LOGO\&quot; &gt;					
					&lt;/td&gt;
	
					&lt;td valign=\&quot;top\&quot; style=\&quot;width:320px;padding:20px 25px 10px 0px;text-align:right;\&quot;&gt; 
						&lt;span style=\&quot;color:#000000;font-size:17px;font-weight:600;text-align:right;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; Astra Bookings &lt;/span&gt;
						&lt;br&gt;
						&lt;span style=\&quot;color:#043144;font-size:13px;text-align:right;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
						Sweifieh, Saeed Al Mufti St, Building #3&lt;br/&gt;Amman - Jordan P.O&lt;br/&gt;Box:619 Amman 11953, Jordan.&lt;br/&gt;             	
	             				Tel: +962 6 580 0050&lt;br/&gt;
						Email : &lt;a href=\&quot;mailto:rohan.vartakk@qtechsoftware.com\&quot; style=\&quot;color: #043144; text-decoration: none;\&quot;&gt;rohan.vartakk@qtechsoftware.com&lt;/a&gt; &lt;br/&gt;
						https://beta.astrabookings.com/
					 	&lt;/span&gt;
					&lt;/td&gt;
					&lt;td style=\&quot;width:10px;padding:20px 0px;text-align:right;\&quot;&gt;
						 &lt;img src=\&quot;https://beta.astrabookings.com/project_folder/astra/images/emails/email_header.jpg\&quot; /&gt;
					&lt;/td&gt;
				&lt;/tr&gt;
			&lt;/table&gt;
		&lt;/td&gt;
	&lt;/tr&gt;	
&lt;/table&gt;
		&lt;table width=\&quot;700\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;background:#ffffff;font-size:13px;margin:0px auto;\&quot;&gt;					
			&lt;tr&gt;
				&lt;td&gt;
					&lt;table width=\&quot;630\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;background:#ffffff;font-size:13px;margin:0px auto;padding:0px 0px;border-collapse: collapse;\&quot;&gt;
						&lt;tr&gt;
							&lt;td&gt;
								&lt;table cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width: 100%;margin: 0px auto;padding: 0px 0px;background:#3D4C5F url(\&#039;https://beta.astrabookings.com/project_folder/astra/images/emails/bg.jpg\&#039;) no-repeat top center;height: 108px;background-size: 100% 100%;\&quot;&gt;
									&lt;tr&gt;
										&lt;td style=\&quot;font-size:20px;color:#fff;font-weight:600;text-transform: inherit;padding:10px;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; Greetings from Astra Bookings Registration Team,&lt;/td&gt;
									&lt;/tr&gt;
								&lt;/table&gt;
							&lt;/td&gt;
						&lt;/tr&gt;
						&lt;tr&gt;
							&lt;td&gt;
								&lt;table cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width:100%;margin:0px auto;font-size:13px;padding:0px 0px;\&quot;&gt;
									&lt;tr&gt;
										&lt;td valign=\&quot;top\&quot; style=\&quot;text-align:left;font-size:14px;color:#023145;padding:10px 0px 5px 0px;\&quot;&gt; 
											&lt;span style=\&quot;text-transform:capitalize;font-weight:900;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Dear Moonlight&lt;/span&gt;&lt;br&gt;
										&lt;/td&gt;
									&lt;/tr&gt;
								&lt;/table&gt;
							&lt;/td&gt;
						&lt;/tr&gt;
						&lt;tr&gt;
							&lt;td&gt;
								&lt;table style=\&quot;width:100%;margin:0px auto; border-bottom:0; font-size:13px; color:#15394b;padding:8px 0;\&quot;&gt;
									&lt;tr&gt;
										&lt;td style=\&quot;font-style:italic;padding:0px;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
											As Reference to your Change of Password !!!!   
										&lt;/td&gt;                                 
									&lt;/tr&gt;
								&lt;/table&gt;
							&lt;/td&gt;
						&lt;/tr&gt;
						&lt;tr&gt;
							&lt;td&gt;
								&lt;table style=\&quot;width:100%;margin:0px auto; border-bottom:0; font-size:13px; color:#15394b;padding:0px;\&quot;&gt;
									&lt;tr&gt;
										&lt;td style=\&quot;padding:5px 0px;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Your password has been changed. You can log in using your new password.&lt;/td&gt;
									&lt;/tr&gt;
								&lt;/table&gt;
							&lt;/td&gt;
						&lt;/tr&gt;
						&lt;tr&gt;
							&lt;td&gt;
								&lt;table style=\&quot;width:100%;margin:0px auto; border-bottom:0; font-size:13px; color:#15394b;padding:0px;\&quot;&gt;
									&lt;tr&gt;
										&lt;td style=\&quot;padding:5px 0px;font-size: 11px;color:#023246;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
											We welcome your suggestions to serve you better, write back to us on &lt;a href=\&quot;mailto:rohan.vartakk@qtechsoftware.com\&quot; style=\&quot;color:#00a6da; text-decoration:underline;\&quot;&gt;rohan.vartakk@qtechsoftware.com&lt;/a&gt;
										&lt;/td&gt;
									&lt;/tr&gt;
								&lt;/table&gt;
							&lt;/td&gt;
						&lt;/tr&gt;
						

&lt;tr&gt;
	&lt;td&gt;
		&lt;table cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width: 100%; font-size: 10px; margin: 0px auto; padding: 8px 0px;color:#023246;border-top:1px solid #CFD4D7;\&quot;&gt;
			&lt;tr&gt;
				&lt;td style=\&quot;padding:10px 0px 5px 0px;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
					Our Support team is always ready to assist you. Please contact us on &lt;a href=\&quot;mailto:rohan.vartakk@qtechsoftware.com\&quot; style=\&quot;color: #00a6da; text-decoration: none;\&quot;&gt;rohan.vartakk@qtechsoftware.com&lt;/a&gt; for any assistance or feedback
				&lt;/td&gt;
			&lt;/tr&gt;
		&lt;/table&gt;
	&lt;/td&gt;
&lt;/tr&gt;					&lt;/table&gt;
				&lt;/td&gt;
			&lt;/tr&gt;
		&lt;/table&gt;
	&lt;/div&gt;
	&lt;/body&gt;

&lt;/html&gt;

',mailto='godrey.pereira@qtechsoftware.com',mailcc='',mailbcc='',mailattachment='',reason='Could not execute: /usr/sbin/sendmail -t -i',date_time='2024-05-22 12:20:10';
[05/22/2024 12:21:54], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php],UPDATE suppliers SET company_name= 'Expedia' ,supplier_code= 'expedia',first_name= 'Qtech' ,middle_name= '',last_name= 'Qtech' ,address= '' ,city= '64440' ,pincode= '' ,country= '106' ,
		phone= '' ,mobile= '787678867878' ,email= 'bhavesh.gurav@qtechsoftware.co' ,b2b_availability_timeout= '0' ,b2c_availability_timeout= '0' ,
		time_zone_offset= '0' ,enable_dst= '' ,username= '' ,password= '' ,validity_start='--',validity_end='--',
		commission = '' ,allow_go='1', search_time_out = '60000' ,book_now_timeout = '600000',accounting_id= '',load_data= '',supplier_folder = 'e1',original_source = '',allow_switch_payment = '0' WHERE id= '64';
[05/22/2024 12:21:54], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-22 12:21:54',`log_type`= 'edit Supplier',`sql_query`= 'UPDATE suppliers SET company_name= \&#039;Expedia\&#039; ,supplier_code= \&#039;expedia\&#039;,first_name= \&#039;Qtech\&#039; ,middle_name= \&#039;\&#039;,last_name= \&#039;Qtech\&#039; ,address= \&#039;\&#039; ,city= \&#039;64440\&#039; ,pincode= \&#039;\&#039; ,country= \&#039;106\&#039; ,
		phone= \&#039;\&#039; ,mobile= \&#039;787678867878\&#039; ,email= \&#039;bhavesh.gurav@qtechsoftware.co\&#039; ,b2b_availability_timeout= \&#039;0\&#039; ,b2c_availability_timeout= \&#039;0\&#039; ,
		time_zone_offset= \&#039;0\&#039; ,enable_dst= \&#039;\&#039; ,username= \&#039;\&#039; ,password= \&#039;\&#039; ,validity_start=\&#039;--\&#039;,validity_end=\&#039;--\&#039;,
		commission = \&#039;\&#039; ,allow_go=\&#039;1\&#039;, search_time_out = 60000 ,book_now_timeout = 600000,accounting_id= \&#039;\&#039;,load_data= \&#039;\&#039;,supplier_folder = \&#039;e1\&#039;,original_source = ,allow_switch_payment = \&#039;0\&#039; WHERE id= \&#039;64\&#039;',`log_description`= 'Supplier editedexpedia',`ip`= '43.239.53.130';
[05/22/2024 12:22:04], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php],UPDATE suppliers SET company_name= 'Expedia Package' ,supplier_code= 'expediapackage',first_name= 'Qtech' ,middle_name= '',last_name= 'Qtech' ,address= '' ,city= 'DXB-1' ,pincode= '' ,country= 'AE' ,
		phone= '' ,mobile= '787678867878' ,email= 'nisha@qtechsoftware.com' ,b2b_availability_timeout= '' ,b2c_availability_timeout= '' ,
		time_zone_offset= '0' ,enable_dst= '' ,username= '' ,password= '' ,validity_start='--',validity_end='--',
		commission = '' ,allow_go='1', search_time_out = '60000' ,book_now_timeout = '600000',accounting_id= '',load_data= '',supplier_folder = 'e1p',original_source = '',allow_switch_payment = '0' WHERE id= '65';
[05/22/2024 12:22:04], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-22 12:22:04',`log_type`= 'edit Supplier',`sql_query`= 'UPDATE suppliers SET company_name= \&#039;Expedia Package\&#039; ,supplier_code= \&#039;expediapackage\&#039;,first_name= \&#039;Qtech\&#039; ,middle_name= \&#039;\&#039;,last_name= \&#039;Qtech\&#039; ,address= \&#039;\&#039; ,city= \&#039;DXB-1\&#039; ,pincode= \&#039;\&#039; ,country= \&#039;AE\&#039; ,
		phone= \&#039;\&#039; ,mobile= \&#039;787678867878\&#039; ,email= \&#039;nisha@qtechsoftware.com\&#039; ,b2b_availability_timeout= \&#039;\&#039; ,b2c_availability_timeout= \&#039;\&#039; ,
		time_zone_offset= \&#039;0\&#039; ,enable_dst= \&#039;\&#039; ,username= \&#039;\&#039; ,password= \&#039;\&#039; ,validity_start=\&#039;--\&#039;,validity_end=\&#039;--\&#039;,
		commission = \&#039;\&#039; ,allow_go=\&#039;1\&#039;, search_time_out = 60000 ,book_now_timeout = 600000,accounting_id= \&#039;\&#039;,load_data= \&#039;\&#039;,supplier_folder = \&#039;e1p\&#039;,original_source = ,allow_switch_payment = \&#039;0\&#039; WHERE id= \&#039;65\&#039;',`log_description`= 'Supplier editedexpediapackage',`ip`= '43.239.53.130';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '24' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '64' ,status = '1' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '20' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '62' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '81' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '78' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 12:22:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-22 12:22:54',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 62 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7861 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7861 ## supplier_id- 65 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7861 ## supplier_id- 20 ## company_name - Hotelbeds ## supplier_code-hotelbeds  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[05/22/2024 12:25:48], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php],UPDATE suppliers SET company_name= 'Darina' ,supplier_code= 'darina',first_name= 'Gajendra' ,middle_name= '',last_name= 'Singh' ,address= 'Mumbai' ,city= '68837' ,pincode= '' ,country= '112' ,
		phone= '' ,mobile= '1234567890' ,email= 'gajendra.rapurohit@qtechsoftware.com' ,b2b_availability_timeout= '' ,b2c_availability_timeout= '' ,
		time_zone_offset= '5.5' ,enable_dst= '' ,username= '' ,password= '' ,validity_start='--',validity_end='--',
		commission = '' ,allow_go='0', search_time_out = '60000' ,book_now_timeout = '600000',accounting_id= 'darina',load_data= '',supplier_folder = 'darina',original_source = '',allow_switch_payment = '0' WHERE id= '80';
[05/22/2024 12:25:48], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-22 12:25:48',`log_type`= 'edit Supplier',`sql_query`= 'UPDATE suppliers SET company_name= \&#039;Darina\&#039; ,supplier_code= \&#039;darina\&#039;,first_name= \&#039;Gajendra\&#039; ,middle_name= \&#039;\&#039;,last_name= \&#039;Singh\&#039; ,address= \&#039;Mumbai\&#039; ,city= \&#039;68837\&#039; ,pincode= \&#039;\&#039; ,country= \&#039;112\&#039; ,
		phone= \&#039;\&#039; ,mobile= \&#039;1234567890\&#039; ,email= \&#039;gajendra.rapurohit@qtechsoftware.com\&#039; ,b2b_availability_timeout= \&#039;\&#039; ,b2c_availability_timeout= \&#039;\&#039; ,
		time_zone_offset= \&#039;5.5\&#039; ,enable_dst= \&#039;\&#039; ,username= \&#039;\&#039; ,password= \&#039;\&#039; ,validity_start=\&#039;--\&#039;,validity_end=\&#039;--\&#039;,
		commission = \&#039;\&#039; ,allow_go=\&#039;0\&#039;, search_time_out = 60000 ,book_now_timeout = 600000,accounting_id= \&#039;darina\&#039;,load_data= \&#039;\&#039;,supplier_folder = \&#039;darina\&#039;,original_source = ,allow_switch_payment = \&#039;0\&#039; WHERE id= \&#039;80\&#039;',`log_description`= 'Supplier editeddarina',`ip`= '43.239.53.130';
[05/22/2024 12:26:08], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php],UPDATE suppliers SET company_name= 'Paximum' ,supplier_code= 'paximum',first_name= 'Gajendra' ,middle_name= '',last_name= 'Singh' ,address= 'Mumbai' ,city= '68837' ,pincode= '123456' ,country= '112' ,
		phone= '' ,mobile= '1234567890' ,email= 'gajendra.rapurohit@qtechsoftware.com' ,b2b_availability_timeout= '' ,b2c_availability_timeout= '' ,
		time_zone_offset= '5.5' ,enable_dst= '' ,username= '' ,password= '' ,validity_start='--',validity_end='--',
		commission = '' ,allow_go='0', search_time_out = '60000' ,book_now_timeout = '600000',accounting_id= 'paximum',load_data= '',supplier_folder = 'paximum',original_source = '',allow_switch_payment = '0' WHERE id= '81';
[05/22/2024 12:26:08], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-22 12:26:08',`log_type`= 'edit Supplier',`sql_query`= 'UPDATE suppliers SET company_name= \&#039;Paximum\&#039; ,supplier_code= \&#039;paximum\&#039;,first_name= \&#039;Gajendra\&#039; ,middle_name= \&#039;\&#039;,last_name= \&#039;Singh\&#039; ,address= \&#039;Mumbai\&#039; ,city= \&#039;68837\&#039; ,pincode= \&#039;123456\&#039; ,country= \&#039;112\&#039; ,
		phone= \&#039;\&#039; ,mobile= \&#039;1234567890\&#039; ,email= \&#039;gajendra.rapurohit@qtechsoftware.com\&#039; ,b2b_availability_timeout= \&#039;\&#039; ,b2c_availability_timeout= \&#039;\&#039; ,
		time_zone_offset= \&#039;5.5\&#039; ,enable_dst= \&#039;\&#039; ,username= \&#039;\&#039; ,password= \&#039;\&#039; ,validity_start=\&#039;--\&#039;,validity_end=\&#039;--\&#039;,
		commission = \&#039;\&#039; ,allow_go=\&#039;0\&#039;, search_time_out = 60000 ,book_now_timeout = 600000,accounting_id= \&#039;paximum\&#039;,load_data= \&#039;\&#039;,supplier_folder = \&#039;paximum\&#039;,original_source = ,allow_switch_payment = \&#039;0\&#039; WHERE id= \&#039;81\&#039;',`log_description`= 'Supplier editedpaximum',`ip`= '43.239.53.130';
[05/22/2024 12:26:32], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php],UPDATE suppliers SET company_name= 'TBO Holidays - Json' ,supplier_code= 'tboholidays',first_name= 'Gajendra' ,middle_name= '',last_name= 'singh' ,address= '' ,city= '64440' ,pincode= '432121' ,country= '106' ,
		phone= '453452352134' ,mobile= '1122334455' ,email= 'gajendra.rajpurohit@qtechsoftware.com' ,b2b_availability_timeout= '60' ,b2c_availability_timeout= '' ,
		time_zone_offset= '5.5' ,enable_dst= '' ,username= '' ,password= '' ,validity_start='--',validity_end='--',
		commission = '' ,allow_go='0', search_time_out = '60000' ,book_now_timeout = '600000',accounting_id= '',load_data= '',supplier_folder = 'tboholidays',original_source = '',allow_switch_payment = '0' WHERE id= '75';
[05/22/2024 12:26:32], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-22 12:26:32',`log_type`= 'edit Supplier',`sql_query`= 'UPDATE suppliers SET company_name= \&#039;TBO Holidays - Json\&#039; ,supplier_code= \&#039;tboholidays\&#039;,first_name= \&#039;Gajendra\&#039; ,middle_name= \&#039;\&#039;,last_name= \&#039;singh\&#039; ,address= \&#039;\&#039; ,city= \&#039;64440\&#039; ,pincode= \&#039;432121\&#039; ,country= \&#039;106\&#039; ,
		phone= \&#039;453452352134\&#039; ,mobile= \&#039;1122334455\&#039; ,email= \&#039;gajendra.rajpurohit@qtechsoftware.com\&#039; ,b2b_availability_timeout= \&#039;60\&#039; ,b2c_availability_timeout= \&#039;\&#039; ,
		time_zone_offset= \&#039;5.5\&#039; ,enable_dst= \&#039;\&#039; ,username= \&#039;\&#039; ,password= \&#039;\&#039; ,validity_start=\&#039;--\&#039;,validity_end=\&#039;--\&#039;,
		commission = \&#039;\&#039; ,allow_go=\&#039;0\&#039;, search_time_out = 60000 ,book_now_timeout = 600000,accounting_id= \&#039;\&#039;,load_data= \&#039;\&#039;,supplier_folder = \&#039;tboholidays\&#039;,original_source = ,allow_switch_payment = \&#039;0\&#039; WHERE id= \&#039;75\&#039;',`log_description`= 'Supplier editedtboholidays',`ip`= '43.239.53.130';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '67' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '24' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '64' ,status = '1' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '34' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '20' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '62' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '81' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '78' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '69' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '68' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '74' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '35' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '70' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '59' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '32' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '58' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '56' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '57' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '61' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '63' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '54' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '45' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:26:51], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-22 12:26:51',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 62 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7861 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '64' ,status = '1' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '65' ,status = '' ,priority = '7' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '69' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '68' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '74' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '35' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '70' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '59' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '32' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '58' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '56' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '57' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '61' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '63' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '54' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:29:12], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7861',supplier_id = '45' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 12:29:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-22 12:29:13',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7861\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7861 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
