		SET
		booking_branch_id= '31'
		WHERE
		id='510'
		;
[03/05/2024 10:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('510','3291','S000000001','1','2','0','-','','','4','TAJ QTECH','mumbai','1234567890','4.0','1','2024/04/15','2024/04/16','','https://baysantravel.astrabookings.com/project_folder/astra//images/imagenotavailable.jpg');
[03/05/2024 10:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '510', booking_detail_id = '1', room_type_code = '2~~~1~~~1~~~2~~~~~~~~~64440~~~0~~~S000000001', room_name = 'double', room_type_description = 'Delux  -Room Only : 2 Pax ', display_nightly_rates = 'a:1:{i:0;a:5:{s:18:"displayNightlyRate";i:110;s:15:"pricing_profile";a:9:{s:8:"range_id";s:2:"82";s:4:"from";s:1:"0";s:2:"to";s:7:"1000000";s:6:"amount";i:110;s:7:"percent";s:5:"10.00";s:8:"currency";N;s:10:"profile_id";s:2:"12";s:18:"without_mul_amount";s:4:"0.00";s:16:"check_mul_amount";i:0;}s:16:"promotionDisplay";s:0:"";s:25:"displayNightlyRateDisplay";s:218:"Supplier Name - localsupplier(travelclick - S000000001), Rate - 100 USD, Currency Multiplier (USD-USD) - 1.00000 Markup in % - 10.00%, Markup Amount - 0, , Markup Amount in SAR - 0.00,Supplier Commission-0 #localsystem";s:13:"whNightlyRate";d:137.5;}}', native_nightly_rates = 'a:1:{i:0;a:4:{s:19:"O_nativeNightlyRate";i:100;s:17:"nativeNightlyRate";i:100;s:9:"free_sale";s:2:"no";s:14:"Discount/Offer";a:7:{s:4:"code";s:0:"";s:4:"Name";s:0:"";s:7:"S_Value";s:0:"";s:5:"Value";i:0;s:12:"Display_Name";s:0:"";s:10:"Offer_Note";N;s:10:"Offer_Type";N;}}}', native_room_rate_total = '100', wh_room_rate_total = '137.5', display_room_rate_total = '110', number_of_rooms = '1';
[03/05/2024 10:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '510', booking_detail_id = '1', rid = '227', room = '0', salutations = 'Mr', first_name = 'deepak', last_name = 'trivedi', passenger_type = 'adult', age = '';
[03/05/2024 10:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '510', booking_detail_id = '1', rid = '227', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[03/05/2024 10:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', cancellation_policy = 'Amendment of Dates, Room Category, Passenger Names are considered as Cancel and Rebook by most of the Hotels.
        Any Changes in initial booking may be denied by the supplier or may result in extra charges.
        Confirmation of amendment requests is subject to availablity and rates at the time of amendment.<br><Br><Br><B><U>Detailed Cancellation Policy:</U></B> <br/> Cancellation Charges of 1.38 USD applicable if cancelled after 14-Apr-2024 03:00 hrs.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2024-04-14 00:00:00', comment_contract = '', consultant_id = 'Ayman', sales_manager_id = '0', admin_booked = '0', email_id = 'deepak.trivedi@qtechsoftware.com', leader_phone = '123456789', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = '', backoffice_user = 'Ayman', customer_id = '', applied_multiplier='1.00000', free_sale='',  wh_applied_markup='25.0',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='25.0',  wh_agent_rate='137.5',  wh_sub_agent_rate='0',  wh_parent_agent_id='7866',  wh_agent_id='7866',  wh_basecurrency_multiplier_native='1.00000',  wh_basecurrency_multiplier='1.00000',  site_id='20',  applied_markup='10',  agent_markup='10',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7863',  sub_agent_rate='0',  agent_rate='110',  applicable_service_tax='0',  supplier_rate='100',  uid='43bd2cf4115d40bda5cba6208895322b'  where id='510';
[03/05/2024 10:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='510';
[03/05/2024 10:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('510','','');
[03/05/2024 10:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('3291','510','confirmed','2024-03-05 10:25:36','Booking confirmed . Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[03/05/2024 10:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('510','2024-04-14 03:00:00','2024-04-14 03:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1','1.38','0','2024-03-05 10:25:36','1.38');
[03/05/2024 10:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO bookings_applicable_offer set  oid= '',  offer_type_code= '',  booking_id= '510',  room_id= '2~~~1~~~1~~~2~~~~~~~~~64440~~~0~~~S000000001',  room_name= 'double',  supplier_id= 'S000000001',  agent_id= '',  applied_native_discount= '0',  original_native_rate= '100',  native_rate= '100',  promotion_text= '',  offer_disc_type= '',  offer_disc_value= '',  offer_disc_currency= '',  create_date= '2024-03-05 10:25:36' ;
[03/05/2024 10:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set confirmation_number='',itenirary_id='510' where reservation_id='3291' and id ='510';
[03/05/2024 10:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE room_rates SET availability = availability-1,consumed_inventory = consumed_inventory+1 WHERE hotel_id = '4' and inventory_class_id = '1' and supplier_id = 'S000000001' and date_from = '2024-04-15';
[03/05/2024 10:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update supplement_rate set inventory = '0' where supplement_rate_id = '2';
[03/05/2024 10:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO mails_error_log set mailfrom='SUPPLIER_BOOKING_EMAIL',mailsubject=' HTL00510 /  Booking Inprocess-booking ',mailbody=' 
&lt;!doctype html&gt;
&lt;html&gt;
&lt;head&gt;

&lt;style&gt;
@import url(https://fonts.googleapis.com/css?family=PT+Sans:400,400italic,700,700italic);
font{
  color:#00b5ed !important;
}
&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 class=\&quot; logo_1 tbl_78 tbl_75 tbl_90\&quot; 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 15px;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 class=\&quot;widt_10\&quot; style=\&quot;width:320px;padding:20px 0px 10px 35px;\&quot;&gt; 
                 &lt;img class=\&quot;logo_1\&quot; src=\&quot;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravellogo.png\&quot; style=\&quot; background: none;width: 200px;padding: 10px;border-radius: 5px;\&quot;/&gt;            
               &lt;/td&gt;
               &lt;td class=\&quot;widt_80\&quot; 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;text-transform: capitalize;\&quot;&gt; Baysan Tourism Services &lt;/span&gt;
                  &lt;br&gt;
                  &lt;span style=\&quot;color:#1a222f;font-size:13px;text-align:right;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                      Casalanges Dahra Area, Tripoli, Libya  
                     &lt;br/&gt;                
                        Tel : &lt;br/&gt;
                        Email : &lt;a href=\&quot;mailto:gajendra.rajpurohit@qtechsoftware.com\&quot; style=\&quot;color: #1a222f; text-decoration: none;\&quot;&gt;gajendra.rajpurohit@qtechsoftware.com&lt;/a&gt; &lt;br/&gt;
                     https://baysantravel.astrabookings.com/                  &lt;/span&gt;
               &lt;/td&gt;
            &lt;/tr&gt;
                  &lt;/table&gt;
      &lt;/td&gt;
   &lt;/tr&gt; 
&lt;/table&gt;  
  &lt;table align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width:700px;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:#622956 url(\&#039;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravel/emails/bg.jpg\&#039;) no-repeat top center;height: 108px;background-size: 100% 100%;\&quot;&gt;
                                  &lt;tr&gt;
                    &lt;td style=\&quot;padding: 15px;\&quot;&gt;&lt;img src=\&quot;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravel/emails/cancelled.png\&quot;&gt;&lt;/td&gt;
                    &lt;td style=\&quot;padding-right:15px;font-size:20px;color:#fff;font-weight:600;text-transform: inherit;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; Your booking HTL00510) status is &lt;span style=\&quot;color:#f33838;\&quot;&gt;Inprocess Booking&lt;/span&gt;&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:#000000;padding:15px 0px 5px 5px;\&quot;&gt; 
                    &lt;span style=\&quot;font-weight:900;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;
                      Dear travelclick,                     &lt;/span&gt; 
                  &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;width:75%;text-align:left;font-size:14px;color:#000000;padding:15px 0px 5px 0px;float:left;\&quot;&gt; 
                    &lt;img src=\&quot;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravel/4.0.list.png\&quot; alt=\&quot;Rating\&quot; title=\&quot;Rating\&quot;/&gt; &lt;br&gt;
                    &lt;span style=\&quot;text-transform:uppercase;font-weight:900;\&quot;&gt;TAJ QTECH &lt;/span&gt; &lt;br&gt;
                    &lt;span style=\&quot;font-style:italic;text-align:left;font-size:13px;color:#000000;padding-top:5px;text-transform:normal;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                       Mumbai,    Mumbai,   India                       Tel: 1234567890                    &lt;/span&gt;
                  &lt;/td&gt;
                  &lt;td valign=\&quot;top\&quot; style=\&quot;width:25%;text-align:right;font-size:13px;color:#000000;padding:15px 0px 5px 0px;text-transform:uppercase;font-weight:900;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                    Booking ID  &lt;br&gt;
                    &lt;span style=\&quot;text-align:right;font-size:13px;color:#000000;padding-top:5px;text-transform:uppercase;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                    HTL00510
                    &lt;/span&gt;
                  &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%; padding:0px 0px;margin-bottom:10px;\&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;border:1px solid #D8E1E6;padding:0px;border-bottom: 0;font-size:14px;\&quot;&gt;
                      &lt;tr style=\&quot;background:#F5F6F8;\&quot;&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:25%;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Confirmation No. :
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;width:25%;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                                  &lt;/td&gt;
                                                  &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:25%;border-bottom:1px solid #D8E1E6;\&quot;&gt; 
                            &nbsp;
                          &lt;/td&gt;
                          &lt;td style=\&quot;text-align:left;padding:12px;width:25%;border-bottom:1px solid #D8E1E6;\&quot;&gt; 
                            &nbsp;
                          &lt;/td&gt;
                                              &lt;/tr&gt;
                                            &lt;tr style=\&quot;background:#ffffff;\&quot;&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px 12px 0px 12px;font-weight:600;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Check In:
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px 12px 0px 12px;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          15/04/2024
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px 12px 0px 12px;font-weight:600;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Check Out:
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px 12px 0px 12px;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          16/04/2024
                        &lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;tr style=\&quot;background:#FFFFFF;\&quot;&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Date of booking :
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          05/03/2024
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                           No. of Nights:
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;color:#000000;padding:12px;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          1
                        &lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;tr style=\&quot;background:#F5F6F8;\&quot;&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:25%;border-bottom:1px solid #D8E1E6;border-top:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Destination :
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;width:25%;border-bottom:1px solid #D8E1E6;border-top:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          mumbai
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;color:#000000;padding:12px;font-weight:600;width:25%;border-bottom:1px solid #D8E1E6;border-top:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Booking Amount. :
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;color:#000000;padding:12px;width:25%;border-bottom:1px solid #D8E1E6;border-top:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                                  USD 0.000
                                                &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%;background:#622956;margin:0px auto;padding:8px;font-size:14px;color:#fff;margin-top:10px;\&quot;&gt;
                      &lt;tr&gt;
                        &lt;td style=\&quot;padding:5px;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          &lt;b&gt;Room 1:&lt;/b&gt; Delux  -Room Only : 2 Pax 
                        &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%;border:1px solid #D8E1E6;border-bottom:0; padding:0px;font-size:14px;color:#000000;\&quot;&gt;
                      &lt;tr&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:20%;vertical-align:top;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                        Guests:
                        &lt;/td&gt;
                        &lt;td&gt; 
                          &lt;table style=\&quot;font-size: 14px;padding:12px\&quot;&gt;
                            &lt;tr&gt;
                                                                                          &lt;td width=\&quot;40%\&quot; style=\&quot;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;
                                1) Mr. Deepak Trivedi                               &lt;/td&gt;
                                                                                                                        &lt;td width=\&quot;40%\&quot; style=\&quot;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;
                                2) Mr. Tbaa Tbaa                               &lt;/td&gt;
                                                          &lt;/tr&gt;
                            &lt;tr&gt;
                                                                                        &lt;/tr&gt;
                          &lt;/table&gt;
                        &lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;tr&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:20%;vertical-align:top;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                        Nationality:
                        &lt;/td&gt;
                        &lt;td width=\&quot;40%\&quot; style=\&quot;font-family: \&#039;PT Sans\&#039;, sans-serif;padding:12px;font-size: 14px\&quot;&gt; 
                          Emirati
                        &lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;tr&gt;
                        &lt;td colspan=\&quot;2\&quot; style=\&quot;padding:12px;font-size:15px;font-weight:600;color:#000000;border-top:1px solid #000000;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Room 1Rate per night
                        &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;margin-bottom:10px;\&quot;&gt;               
                      &lt;tr&gt;
                        &lt;td&gt; 
                          &lt;table style=\&quot;background:#622956;color:#fff;text-align:center;font-size:12px;width:100%;\&quot;&gt;
                              &lt;tr&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;mon&lt;/td&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;tue&lt;/td&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;wed&lt;/td&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;thu&lt;/td&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;fri&lt;/td&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;sat&lt;/td&gt;
                                &lt;td WIDTH=\&quot;90\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;sun&lt;/td&gt;
                              &lt;/tr&gt;
                                                                                                                         &lt;tr style=\&quot;font-weight: bold;\&quot;&gt;
                                                                 
                                                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;50\&quot; style=\&quot;background:#cc64b8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;
                                &lt;span style=\&quot;color:#fff;\&quot;&gt;15 APR\&#039;24&lt;/span&gt;&lt;br/&gt;&lt;img style=\&quot;margin:0 0 10px 0;\&quot; src=\&quot;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravel/date.png\&quot;&gt;&lt;br/&gt;USD  100.00
                                &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:1px solid #D8E1E6;border-bottom:1px solid #D8E1E6; font-size:13px; color:#000000;\&quot;&gt;
                            &lt;tr&gt;
                              &lt;td style=\&quot;text-align:right;font-style:italic;padding:5px;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                Total Per Room                      
                              &lt;/td&gt;                                 
                              &lt;td style=\&quot;text-align:right;color:#000000;padding:5px;width:20%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                USD 100.000
                              &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;tr&gt;
                  &lt;td&gt;
                    &lt;table cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width:100%;border:1px solid #D8E1E6; border-bottom:0; font-size:13px; color:#000000;border-collapse: collapse;\&quot;&gt; 
                                                                  &lt;tr style=\&quot;background:#f2f4f5;\&quot;&gt;
                        &lt;td style=\&quot;text-align:right;font-style:italic;padding:12px;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Payment Gateway Charges           
                        &lt;/td&gt;                                 
                        &lt;td style=\&quot;text-align:right;color:#000000;padding:12px;width:20%;font-weight:bold;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          USD 0.000
                        &lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;tr style=\&quot;background:#ffffff;\&quot;&gt;
                        &lt;td style=\&quot;text-align:right;font-style:italic;padding:12px;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Total Charges                    
                        &lt;/td&gt;                                 
                        &lt;td style=\&quot;text-align:right;color:#000000;padding:12px;width:20%;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                                  USD 100.000
                                                &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;\&quot;&gt;                
                      &lt;tr&gt;
                        &lt;td&gt; 
                          &lt;table cellspacing=\&quot;3\&quot; style=\&quot;background:#622956;color:#fff;text-align:center;font-size:12px;width:100%;\&quot;&gt;
                            &lt;tr&gt;
                            &lt;td WIDTH=\&quot;157\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;background:#b1439c;text-transform:uppercase;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Date&lt;/td&gt;
                            &lt;td WIDTH=\&quot;157\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;background:#b1439c;text-transform:uppercase;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Total Inventory Alloted&lt;/td&gt;
                            &lt;td WIDTH=\&quot;157\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;background:#b1439c;text-transform:uppercase;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Inventory Available Now&lt;/td&gt;
                            &lt;td WIDTH=\&quot;157\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;background:#b1439c;text-transform:uppercase;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Inventory Consumed&lt;/td&gt;
                            &lt;/tr&gt;
                                                          &lt;tr style=\&quot;font-weight: bold;\&quot;&gt;
                              &lt;td height=\&quot;50\&quot; style=\&quot;background:#cc64b8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;15-Apr-2024&lt;/td&gt;
                              &lt;td height=\&quot;50\&quot; style=\&quot;background:#cc64b8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;20&lt;/td&gt;
                              &lt;td height=\&quot;50\&quot; style=\&quot;background:#cc64b8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;19&lt;/td&gt;
                              &lt;td height=\&quot;50\&quot; style=\&quot;background:#cc64b8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;1&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;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;\&quot;&gt;
                      &lt;tr&gt;
                        &lt;td style=\&quot;text-align:left;font-size:18px;color:#000000;padding:20px 0px 10px 0px;font-weight:600; border-bottom:1px solid #B7CDD8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Booking Terms and Conditions
                        &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: 14px; margin: 0px auto; padding: 8px 0px;color:#023246;border-top:1px solid #B7CDD8;\&quot;&gt;
                                            &lt;tr&gt;
                        &lt;td style=\&quot;padding:5px 0px;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Booking payable by&lt;strong style=\&quot;color:#fe1a1a;\&quot;&gt;&lt;/strong&gt; as per reservation details; Please collect all extras directly from clients prior to departure.
                        &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: 14px; margin: 0px auto; padding: 8px 0px;color:#023246;\&quot;&gt;
                                                                                          &lt;tr&gt;
                          &lt;td style=\&quot;padding:5px 0px;font-family: \&#039;PT Sans\&#039;, sans-serif;font-size:14px;\&quot;&gt; 
                            EXTRANET_BOOKING_TERMS
                          &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;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:#1a222f;border-top:1px solid #ddd;\&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:sujay.raut@qtechsoftware.com\&quot; style=\&quot;color: #1a222f; text-decoration: none;\&quot;&gt;sujay.raut@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='bhavesh.gurav@qtechsoftware.com',mailcc='',mailbcc='',mailattachment='',reason='Invalid address:  (punyEncode) SUPPLIER_BOOKING_EMAIL',date_time='2024-03-05 10:25:36';
[03/05/2024 10:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='510',status='1' where reservation_id='3291' and booking_id ='0';
[03/05/2024 10:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='510' where agent_logs_id='85' and source_type='localsystem';
[03/05/2024 10:25:39], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('510','sujay.raut@qtechsoftware.com');
[03/05/2024 10:25:39], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO mails_error_log set mailfrom='SUPPLIER_BOOKING_EMAIL',mailsubject=' HTL00510 /  Booking Inprocess-booking ',mailbody=' 
&lt;!doctype html&gt;
&lt;html&gt;
&lt;head&gt;

&lt;style&gt;
@import url(https://fonts.googleapis.com/css?family=PT+Sans:400,400italic,700,700italic);
font{
  color:#00b5ed !important;
}
&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 class=\&quot; logo_1 tbl_78 tbl_75 tbl_90\&quot; 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 15px;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 class=\&quot;widt_10\&quot; style=\&quot;width:320px;padding:20px 0px 10px 35px;\&quot;&gt; 
                 &lt;img class=\&quot;logo_1\&quot; src=\&quot;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravellogo.png\&quot; style=\&quot; background: none;width: 200px;padding: 10px;border-radius: 5px;\&quot;/&gt;            
               &lt;/td&gt;
               &lt;td class=\&quot;widt_80\&quot; 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;text-transform: capitalize;\&quot;&gt; Baysan Tourism Services &lt;/span&gt;
                  &lt;br&gt;
                  &lt;span style=\&quot;color:#1a222f;font-size:13px;text-align:right;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                      Casalanges Dahra Area, Tripoli, Libya  
                     &lt;br/&gt;                
                        Tel : &lt;br/&gt;
                        Email : &lt;a href=\&quot;mailto:gajendra.rajpurohit@qtechsoftware.com\&quot; style=\&quot;color: #1a222f; text-decoration: none;\&quot;&gt;gajendra.rajpurohit@qtechsoftware.com&lt;/a&gt; &lt;br/&gt;
                     https://baysantravel.astrabookings.com/                  &lt;/span&gt;
               &lt;/td&gt;
            &lt;/tr&gt;
                  &lt;/table&gt;
      &lt;/td&gt;
   &lt;/tr&gt; 
&lt;/table&gt;  
  &lt;table align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width:700px;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:#622956 url(\&#039;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravel/emails/bg.jpg\&#039;) no-repeat top center;height: 108px;background-size: 100% 100%;\&quot;&gt;
                                  &lt;tr&gt;
                    &lt;td style=\&quot;padding: 15px;\&quot;&gt;&lt;img src=\&quot;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravel/emails/cancelled.png\&quot;&gt;&lt;/td&gt;
                    &lt;td style=\&quot;padding-right:15px;font-size:20px;color:#fff;font-weight:600;text-transform: inherit;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; Your booking HTL00510) status is &lt;span style=\&quot;color:#f33838;\&quot;&gt;Inprocess Booking&lt;/span&gt;&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:#000000;padding:15px 0px 5px 5px;\&quot;&gt; 
                    &lt;span style=\&quot;font-weight:900;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;
                      Dear travelclick,                     &lt;/span&gt; 
                  &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;width:75%;text-align:left;font-size:14px;color:#000000;padding:15px 0px 5px 0px;float:left;\&quot;&gt; 
                    &lt;img src=\&quot;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravel/4.0.list.png\&quot; alt=\&quot;Rating\&quot; title=\&quot;Rating\&quot;/&gt; &lt;br&gt;
                    &lt;span style=\&quot;text-transform:uppercase;font-weight:900;\&quot;&gt;TAJ QTECH &lt;/span&gt; &lt;br&gt;
                    &lt;span style=\&quot;font-style:italic;text-align:left;font-size:13px;color:#000000;padding-top:5px;text-transform:normal;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                       Mumbai,    Mumbai,   India                       Tel: 1234567890                    &lt;/span&gt;
                  &lt;/td&gt;
                  &lt;td valign=\&quot;top\&quot; style=\&quot;width:25%;text-align:right;font-size:13px;color:#000000;padding:15px 0px 5px 0px;text-transform:uppercase;font-weight:900;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                    Booking ID  &lt;br&gt;
                    &lt;span style=\&quot;text-align:right;font-size:13px;color:#000000;padding-top:5px;text-transform:uppercase;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                    HTL00510
                    &lt;/span&gt;
                  &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%; padding:0px 0px;margin-bottom:10px;\&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;border:1px solid #D8E1E6;padding:0px;border-bottom: 0;font-size:14px;\&quot;&gt;
                      &lt;tr style=\&quot;background:#F5F6F8;\&quot;&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:25%;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Confirmation No. :
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;width:25%;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                                  &lt;/td&gt;
                                                  &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:25%;border-bottom:1px solid #D8E1E6;\&quot;&gt; 
                            &nbsp;
                          &lt;/td&gt;
                          &lt;td style=\&quot;text-align:left;padding:12px;width:25%;border-bottom:1px solid #D8E1E6;\&quot;&gt; 
                            &nbsp;
                          &lt;/td&gt;
                                              &lt;/tr&gt;
                                            &lt;tr style=\&quot;background:#ffffff;\&quot;&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px 12px 0px 12px;font-weight:600;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Check In:
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px 12px 0px 12px;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          15/04/2024
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px 12px 0px 12px;font-weight:600;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Check Out:
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px 12px 0px 12px;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          16/04/2024
                        &lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;tr style=\&quot;background:#FFFFFF;\&quot;&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Date of booking :
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          05/03/2024
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                           No. of Nights:
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;color:#000000;padding:12px;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          1
                        &lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;tr style=\&quot;background:#F5F6F8;\&quot;&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:25%;border-bottom:1px solid #D8E1E6;border-top:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Destination :
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;width:25%;border-bottom:1px solid #D8E1E6;border-top:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          mumbai
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;color:#000000;padding:12px;font-weight:600;width:25%;border-bottom:1px solid #D8E1E6;border-top:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Booking Amount. :
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;color:#000000;padding:12px;width:25%;border-bottom:1px solid #D8E1E6;border-top:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                                  USD 0.000
                                                &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%;background:#622956;margin:0px auto;padding:8px;font-size:14px;color:#fff;margin-top:10px;\&quot;&gt;
                      &lt;tr&gt;
                        &lt;td style=\&quot;padding:5px;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          &lt;b&gt;Room 1:&lt;/b&gt; Delux  -Room Only : 2 Pax 
                        &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%;border:1px solid #D8E1E6;border-bottom:0; padding:0px;font-size:14px;color:#000000;\&quot;&gt;
                      &lt;tr&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:20%;vertical-align:top;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                        Guests:
                        &lt;/td&gt;
                        &lt;td&gt; 
                          &lt;table style=\&quot;font-size: 14px;padding:12px\&quot;&gt;
                            &lt;tr&gt;
                                                                                          &lt;td width=\&quot;40%\&quot; style=\&quot;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;
                                1) Mr. Deepak Trivedi                               &lt;/td&gt;
                                                                                                                        &lt;td width=\&quot;40%\&quot; style=\&quot;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;
                                2) Mr. Tbaa Tbaa                               &lt;/td&gt;
                                                          &lt;/tr&gt;
                            &lt;tr&gt;
                                                                                        &lt;/tr&gt;
                          &lt;/table&gt;
                        &lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;tr&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:20%;vertical-align:top;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                        Nationality:
                        &lt;/td&gt;
                        &lt;td width=\&quot;40%\&quot; style=\&quot;font-family: \&#039;PT Sans\&#039;, sans-serif;padding:12px;font-size: 14px\&quot;&gt; 
                          Emirati
                        &lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;tr&gt;
                        &lt;td colspan=\&quot;2\&quot; style=\&quot;padding:12px;font-size:15px;font-weight:600;color:#000000;border-top:1px solid #000000;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Room 1Rate per night
                        &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;margin-bottom:10px;\&quot;&gt;               
                      &lt;tr&gt;
                        &lt;td&gt; 
                          &lt;table style=\&quot;background:#622956;color:#fff;text-align:center;font-size:12px;width:100%;\&quot;&gt;
                              &lt;tr&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;mon&lt;/td&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;tue&lt;/td&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;wed&lt;/td&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;thu&lt;/td&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;fri&lt;/td&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;sat&lt;/td&gt;
                                &lt;td WIDTH=\&quot;90\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;sun&lt;/td&gt;
                              &lt;/tr&gt;
                                                                                                                         &lt;tr style=\&quot;font-weight: bold;\&quot;&gt;
                                                                 
                                                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;50\&quot; style=\&quot;background:#cc64b8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;
                                &lt;span style=\&quot;color:#fff;\&quot;&gt;15 APR\&#039;24&lt;/span&gt;&lt;br/&gt;&lt;img style=\&quot;margin:0 0 10px 0;\&quot; src=\&quot;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravel/date.png\&quot;&gt;&lt;br/&gt;USD  110.00
                                &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:1px solid #D8E1E6;border-bottom:1px solid #D8E1E6; font-size:13px; color:#000000;\&quot;&gt;
                            &lt;tr&gt;
                              &lt;td style=\&quot;text-align:right;font-style:italic;padding:5px;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                Total Per Room                      
                              &lt;/td&gt;                                 
                              &lt;td style=\&quot;text-align:right;color:#000000;padding:5px;width:20%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                USD 100.000
                              &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;tr&gt;
                  &lt;td&gt;
                    &lt;table cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width:100%;border:1px solid #D8E1E6; border-bottom:0; font-size:13px; color:#000000;border-collapse: collapse;\&quot;&gt; 
                                                                  &lt;tr style=\&quot;background:#f2f4f5;\&quot;&gt;
                        &lt;td style=\&quot;text-align:right;font-style:italic;padding:12px;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Payment Gateway Charges           
                        &lt;/td&gt;                                 
                        &lt;td style=\&quot;text-align:right;color:#000000;padding:12px;width:20%;font-weight:bold;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          USD 0.000
                        &lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;tr style=\&quot;background:#ffffff;\&quot;&gt;
                        &lt;td style=\&quot;text-align:right;font-style:italic;padding:12px;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Total Charges                    
                        &lt;/td&gt;                                 
                        &lt;td style=\&quot;text-align:right;color:#000000;padding:12px;width:20%;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                                  USD 100.000
                                                &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;\&quot;&gt;                
                      &lt;tr&gt;
                        &lt;td&gt; 
                          &lt;table cellspacing=\&quot;3\&quot; style=\&quot;background:#622956;color:#fff;text-align:center;font-size:12px;width:100%;\&quot;&gt;
                            &lt;tr&gt;
                            &lt;td WIDTH=\&quot;157\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;background:#b1439c;text-transform:uppercase;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Date&lt;/td&gt;
                            &lt;td WIDTH=\&quot;157\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;background:#b1439c;text-transform:uppercase;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Total Inventory Alloted&lt;/td&gt;
                            &lt;td WIDTH=\&quot;157\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;background:#b1439c;text-transform:uppercase;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Inventory Available Now&lt;/td&gt;
                            &lt;td WIDTH=\&quot;157\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;background:#b1439c;text-transform:uppercase;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Inventory Consumed&lt;/td&gt;
                            &lt;/tr&gt;
                                                          &lt;tr style=\&quot;font-weight: bold;\&quot;&gt;
                              &lt;td height=\&quot;50\&quot; style=\&quot;background:#cc64b8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;15-Apr-2024&lt;/td&gt;
                              &lt;td height=\&quot;50\&quot; style=\&quot;background:#cc64b8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;20&lt;/td&gt;
                              &lt;td height=\&quot;50\&quot; style=\&quot;background:#cc64b8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;19&lt;/td&gt;
                              &lt;td height=\&quot;50\&quot; style=\&quot;background:#cc64b8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;1&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;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;\&quot;&gt;
                      &lt;tr&gt;
                        &lt;td style=\&quot;text-align:left;font-size:18px;color:#000000;padding:20px 0px 10px 0px;font-weight:600; border-bottom:1px solid #B7CDD8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Booking Terms and Conditions
                        &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: 14px; margin: 0px auto; padding: 8px 0px;color:#023246;border-top:1px solid #B7CDD8;\&quot;&gt;
                                            &lt;tr&gt;
                        &lt;td style=\&quot;padding:5px 0px;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Booking payable by&lt;strong style=\&quot;color:#fe1a1a;\&quot;&gt;&lt;/strong&gt; as per reservation details; Please collect all extras directly from clients prior to departure.
                        &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: 14px; margin: 0px auto; padding: 8px 0px;color:#023246;\&quot;&gt;
                                                                                          &lt;tr&gt;
                          &lt;td style=\&quot;padding:5px 0px;font-family: \&#039;PT Sans\&#039;, sans-serif;font-size:14px;\&quot;&gt; 
                            EXTRANET_BOOKING_TERMS
                          &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;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:#1a222f;border-top:1px solid #ddd;\&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:Sujay.raut@qtechsoftware.com\&quot; style=\&quot;color: #1a222f; text-decoration: none;\&quot;&gt;Sujay.raut@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='bhavesh.gurav@qtechsoftware.com',mailcc='',mailbcc='',mailattachment='',reason='Invalid address:  (punyEncode) SUPPLIER_BOOKING_EMAIL',date_time='2024-03-05 10:25:39';
[03/05/2024 10:25:40], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('510','branch@email.com');
[03/05/2024 10:25:40], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO mails_error_log set mailfrom='SUPPLIER_BOOKING_EMAIL',mailsubject=' HTL00510 /  Booking Inprocess-booking ',mailbody=' 
&lt;!doctype html&gt;
&lt;html&gt;
&lt;head&gt;

&lt;style&gt;
@import url(https://fonts.googleapis.com/css?family=PT+Sans:400,400italic,700,700italic);
font{
  color:#00b5ed !important;
}
&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 class=\&quot; logo_1 tbl_78 tbl_75 tbl_90\&quot; 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 15px;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 class=\&quot;widt_10\&quot; style=\&quot;width:320px;padding:20px 0px 10px 35px;\&quot;&gt; 
                 &lt;img class=\&quot;logo_1\&quot; src=\&quot;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravellogo.png\&quot; style=\&quot; background: none;width: 200px;padding: 10px;border-radius: 5px;\&quot;/&gt;            
               &lt;/td&gt;
               &lt;td class=\&quot;widt_80\&quot; 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;text-transform: capitalize;\&quot;&gt; Baysan Tourism Services &lt;/span&gt;
                  &lt;br&gt;
                  &lt;span style=\&quot;color:#1a222f;font-size:13px;text-align:right;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                      Casalanges Dahra Area, Tripoli, Libya  
                     &lt;br/&gt;                
                        Tel : &lt;br/&gt;
                        Email : &lt;a href=\&quot;mailto:gajendra.rajpurohit@qtechsoftware.com\&quot; style=\&quot;color: #1a222f; text-decoration: none;\&quot;&gt;gajendra.rajpurohit@qtechsoftware.com&lt;/a&gt; &lt;br/&gt;
                     https://baysantravel.astrabookings.com/                  &lt;/span&gt;
               &lt;/td&gt;
            &lt;/tr&gt;
                  &lt;/table&gt;
      &lt;/td&gt;
   &lt;/tr&gt; 
&lt;/table&gt;  
  &lt;table align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width:700px;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:#622956 url(\&#039;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravel/emails/bg.jpg\&#039;) no-repeat top center;height: 108px;background-size: 100% 100%;\&quot;&gt;
                                  &lt;tr&gt;
                    &lt;td style=\&quot;padding: 15px;\&quot;&gt;&lt;img src=\&quot;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravel/emails/cancelled.png\&quot;&gt;&lt;/td&gt;
                    &lt;td style=\&quot;padding-right:15px;font-size:20px;color:#fff;font-weight:600;text-transform: inherit;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; Your booking HTL00510) status is &lt;span style=\&quot;color:#f33838;\&quot;&gt;Inprocess Booking&lt;/span&gt;&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:#000000;padding:15px 0px 5px 5px;\&quot;&gt; 
                    &lt;span style=\&quot;font-weight:900;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;
                      Dear travelclick,                     &lt;/span&gt; 
                  &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;width:75%;text-align:left;font-size:14px;color:#000000;padding:15px 0px 5px 0px;float:left;\&quot;&gt; 
                    &lt;img src=\&quot;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravel/4.0.list.png\&quot; alt=\&quot;Rating\&quot; title=\&quot;Rating\&quot;/&gt; &lt;br&gt;
                    &lt;span style=\&quot;text-transform:uppercase;font-weight:900;\&quot;&gt;TAJ QTECH &lt;/span&gt; &lt;br&gt;
                    &lt;span style=\&quot;font-style:italic;text-align:left;font-size:13px;color:#000000;padding-top:5px;text-transform:normal;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                       Mumbai,    Mumbai,   India                       Tel: 1234567890                    &lt;/span&gt;
                  &lt;/td&gt;
                  &lt;td valign=\&quot;top\&quot; style=\&quot;width:25%;text-align:right;font-size:13px;color:#000000;padding:15px 0px 5px 0px;text-transform:uppercase;font-weight:900;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                    Booking ID  &lt;br&gt;
                    &lt;span style=\&quot;text-align:right;font-size:13px;color:#000000;padding-top:5px;text-transform:uppercase;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                    HTL00510
                    &lt;/span&gt;
                  &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%; padding:0px 0px;margin-bottom:10px;\&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;border:1px solid #D8E1E6;padding:0px;border-bottom: 0;font-size:14px;\&quot;&gt;
                      &lt;tr style=\&quot;background:#F5F6F8;\&quot;&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:25%;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Confirmation No. :
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;width:25%;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                                  &lt;/td&gt;
                                                  &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:25%;border-bottom:1px solid #D8E1E6;\&quot;&gt; 
                            &nbsp;
                          &lt;/td&gt;
                          &lt;td style=\&quot;text-align:left;padding:12px;width:25%;border-bottom:1px solid #D8E1E6;\&quot;&gt; 
                            &nbsp;
                          &lt;/td&gt;
                                              &lt;/tr&gt;
                                            &lt;tr style=\&quot;background:#ffffff;\&quot;&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px 12px 0px 12px;font-weight:600;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Check In:
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px 12px 0px 12px;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          15/04/2024
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px 12px 0px 12px;font-weight:600;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Check Out:
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px 12px 0px 12px;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          16/04/2024
                        &lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;tr style=\&quot;background:#FFFFFF;\&quot;&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Date of booking :
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          05/03/2024
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                           No. of Nights:
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;color:#000000;padding:12px;width:25%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          1
                        &lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;tr style=\&quot;background:#F5F6F8;\&quot;&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:25%;border-bottom:1px solid #D8E1E6;border-top:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Destination :
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;width:25%;border-bottom:1px solid #D8E1E6;border-top:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          mumbai
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;color:#000000;padding:12px;font-weight:600;width:25%;border-bottom:1px solid #D8E1E6;border-top:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Booking Amount. :
                        &lt;/td&gt;
                        &lt;td style=\&quot;text-align:left;color:#000000;padding:12px;width:25%;border-bottom:1px solid #D8E1E6;border-top:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                                  USD 0.000
                                                &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%;background:#622956;margin:0px auto;padding:8px;font-size:14px;color:#fff;margin-top:10px;\&quot;&gt;
                      &lt;tr&gt;
                        &lt;td style=\&quot;padding:5px;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          &lt;b&gt;Room 1:&lt;/b&gt; Delux  -Room Only : 2 Pax 
                        &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%;border:1px solid #D8E1E6;border-bottom:0; padding:0px;font-size:14px;color:#000000;\&quot;&gt;
                      &lt;tr&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:20%;vertical-align:top;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                        Guests:
                        &lt;/td&gt;
                        &lt;td&gt; 
                          &lt;table style=\&quot;font-size: 14px;padding:12px\&quot;&gt;
                            &lt;tr&gt;
                                                                                          &lt;td width=\&quot;40%\&quot; style=\&quot;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;
                                1) Mr. Deepak Trivedi                               &lt;/td&gt;
                                                                                                                        &lt;td width=\&quot;40%\&quot; style=\&quot;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;
                                2) Mr. Tbaa Tbaa                               &lt;/td&gt;
                                                          &lt;/tr&gt;
                            &lt;tr&gt;
                                                                                        &lt;/tr&gt;
                          &lt;/table&gt;
                        &lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;tr&gt;
                        &lt;td style=\&quot;text-align:left;padding:12px;font-weight:600;width:20%;vertical-align:top;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                        Nationality:
                        &lt;/td&gt;
                        &lt;td width=\&quot;40%\&quot; style=\&quot;font-family: \&#039;PT Sans\&#039;, sans-serif;padding:12px;font-size: 14px\&quot;&gt; 
                          Emirati
                        &lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;tr&gt;
                        &lt;td colspan=\&quot;2\&quot; style=\&quot;padding:12px;font-size:15px;font-weight:600;color:#000000;border-top:1px solid #000000;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Room 1Rate per night
                        &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;margin-bottom:10px;\&quot;&gt;               
                      &lt;tr&gt;
                        &lt;td&gt; 
                          &lt;table style=\&quot;background:#622956;color:#fff;text-align:center;font-size:12px;width:100%;\&quot;&gt;
                              &lt;tr&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;mon&lt;/td&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;tue&lt;/td&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;wed&lt;/td&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;thu&lt;/td&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;fri&lt;/td&gt;
                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;sat&lt;/td&gt;
                                &lt;td WIDTH=\&quot;90\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;font-family: \&#039;PT Sans\&#039;, sans-serif;background:#b1439c;text-transform:uppercase;\&quot;&gt;sun&lt;/td&gt;
                              &lt;/tr&gt;
                                                                                                                         &lt;tr style=\&quot;font-weight: bold;\&quot;&gt;
                                                                 
                                                                &lt;td WIDTH=\&quot;85\&quot; height=\&quot;50\&quot; style=\&quot;background:#cc64b8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;
                                &lt;span style=\&quot;color:#fff;\&quot;&gt;15 APR\&#039;24&lt;/span&gt;&lt;br/&gt;&lt;img style=\&quot;margin:0 0 10px 0;\&quot; src=\&quot;https://baysantravel.astrabookings.com/project_folder/astra/images/baysantravel/date.png\&quot;&gt;&lt;br/&gt;USD  100.00
                                &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:1px solid #D8E1E6;border-bottom:1px solid #D8E1E6; font-size:13px; color:#000000;\&quot;&gt;
                            &lt;tr&gt;
                              &lt;td style=\&quot;text-align:right;font-style:italic;padding:5px;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                Total Per Room                      
                              &lt;/td&gt;                                 
                              &lt;td style=\&quot;text-align:right;color:#000000;padding:5px;width:20%;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                USD 100.000
                              &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;tr&gt;
                  &lt;td&gt;
                    &lt;table cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; border=\&quot;0\&quot; style=\&quot;width:100%;border:1px solid #D8E1E6; border-bottom:0; font-size:13px; color:#000000;border-collapse: collapse;\&quot;&gt; 
                                                                  &lt;tr style=\&quot;background:#f2f4f5;\&quot;&gt;
                        &lt;td style=\&quot;text-align:right;font-style:italic;padding:12px;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Payment Gateway Charges           
                        &lt;/td&gt;                                 
                        &lt;td style=\&quot;text-align:right;color:#000000;padding:12px;width:20%;font-weight:bold;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          USD 0.000
                        &lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;tr style=\&quot;background:#ffffff;\&quot;&gt;
                        &lt;td style=\&quot;text-align:right;font-style:italic;padding:12px;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Total Charges                    
                        &lt;/td&gt;                                 
                        &lt;td style=\&quot;text-align:right;color:#000000;padding:12px;width:20%;border-bottom:1px solid #D8E1E6;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                                                  USD 100.000
                                                &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;\&quot;&gt;                
                      &lt;tr&gt;
                        &lt;td&gt; 
                          &lt;table cellspacing=\&quot;3\&quot; style=\&quot;background:#622956;color:#fff;text-align:center;font-size:12px;width:100%;\&quot;&gt;
                            &lt;tr&gt;
                            &lt;td WIDTH=\&quot;157\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;background:#b1439c;text-transform:uppercase;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Date&lt;/td&gt;
                            &lt;td WIDTH=\&quot;157\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;background:#b1439c;text-transform:uppercase;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Total Inventory Alloted&lt;/td&gt;
                            &lt;td WIDTH=\&quot;157\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;background:#b1439c;text-transform:uppercase;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Inventory Available Now&lt;/td&gt;
                            &lt;td WIDTH=\&quot;157\&quot; height=\&quot;20px\&quot; style=\&quot;padding: 3px 0;background:#b1439c;text-transform:uppercase;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;Inventory Consumed&lt;/td&gt;
                            &lt;/tr&gt;
                                                          &lt;tr style=\&quot;font-weight: bold;\&quot;&gt;
                              &lt;td height=\&quot;50\&quot; style=\&quot;background:#cc64b8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;15-Apr-2024&lt;/td&gt;
                              &lt;td height=\&quot;50\&quot; style=\&quot;background:#cc64b8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;20&lt;/td&gt;
                              &lt;td height=\&quot;50\&quot; style=\&quot;background:#cc64b8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;19&lt;/td&gt;
                              &lt;td height=\&quot;50\&quot; style=\&quot;background:#cc64b8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt;1&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;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;\&quot;&gt;
                      &lt;tr&gt;
                        &lt;td style=\&quot;text-align:left;font-size:18px;color:#000000;padding:20px 0px 10px 0px;font-weight:600; border-bottom:1px solid #B7CDD8;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Booking Terms and Conditions
                        &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: 14px; margin: 0px auto; padding: 8px 0px;color:#023246;border-top:1px solid #B7CDD8;\&quot;&gt;
                                            &lt;tr&gt;
                        &lt;td style=\&quot;padding:5px 0px;font-family: \&#039;PT Sans\&#039;, sans-serif;\&quot;&gt; 
                          Booking payable by&lt;strong style=\&quot;color:#fe1a1a;\&quot;&gt;&lt;/strong&gt; as per reservation details; Please collect all extras directly from clients prior to departure.
                        &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: 14px; margin: 0px auto; padding: 8px 0px;color:#023246;\&quot;&gt;
                                                                                          &lt;tr&gt;
                          &lt;td style=\&quot;padding:5px 0px;font-family: \&#039;PT Sans\&#039;, sans-serif;font-size:14px;\&quot;&gt; 
                            EXTRANET_BOOKING_TERMS
                          &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;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:#1a222f;border-top:1px solid #ddd;\&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:sujay.raut@qtechsoftware.com\&quot; style=\&quot;color: #1a222f; text-decoration: none;\&quot;&gt;sujay.raut@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='bhavesh.gurav@qtechsoftware.com',mailcc='',mailbcc='',mailattachment='',reason='Invalid address:  (punyEncode) SUPPLIER_BOOKING_EMAIL',date_time='2024-03-05 10:25:40';
[03/05/2024 10:26:38], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:26:38' WHERE id= '625';
[03/05/2024 10:26:41], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:26:41' WHERE id= '625';
[03/05/2024 10:26:41], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7866' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/04/15' , departure_date = '2024/04/16' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-03-05 10:26:41' , site_id = '20' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[03/05/2024 10:26:42], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:26:42' WHERE id= '625';
[03/05/2024 10:26:42], [file name :-/home/otrams/public_html/beta/call.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', '2024-03-05 10:26:42', '', 'e0d4f923381c349079cd0a58172ed41427744a7e296b2c5f813db723982e0bf0', '86');
[03/05/2024 10:26:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=e0d4f923381c349079cd0a58172ed41427744a7e296b2c5f813db723982e0bf0&xml_user_id=7863&db_caching=1&web_service=no'
        , http_hit_time = '2024-03-05 10:26:42.560'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.099'
        , error_description = ''
        , memory_used = '9327800'
        WHERE id = '47280';
[03/05/2024 10:26:42], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '2',
        request_path = '/xml_all.php?userid=7863&sessionid=e0d4f923381c349079cd0a58172ed41427744a7e296b2c5f813db723982e0bf0',
        duration = '0.141',
        merge_duration = '0.000',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '7.58',
        system_load_5_min = '6.81',
        system_load_15_min = '5.66',
        system_memory_usage = '91.02',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '86') + '2547816',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '86';
[03/05/2024 10:26:43], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:26:43' WHERE id= '625';
[03/05/2024 10:26:53], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:26:53' WHERE id= '625';
[03/05/2024 10:26:53], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:26:53' WHERE id= '625';
[03/05/2024 10:26:53], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1709634413','43.239.53.130');
[03/05/2024 10:30:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='510', agent_id ='7863', itenirary_id ='', confirmation_number ='', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='', leader_title ='Mr', leader_first_name ='deepak', leader_last_name ='trivedi', city_id ='mumbai', country_id ='106', display_room_rate ='110.000', native_room_rate ='100.000', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='', supplier_cancellation_policy ='', current_status ='inprocess-booking', booking_status ='1', status_date ='2024-03-05 10:25:36', create_date ='2024-03-05 10:25:36', source_type ='localsystem', expiration_date ='0000-00-00 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='0.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='0.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='', admin_booked ='0', emailed_status ='0', applied_multiplier ='', applied_markup ='', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='', wh_agent_markup ='0.000', basecurrency_multiplier ='1', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='1', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1', wh_agent_currency_multiplier ='1.000', modified_datetime ='2024-03-05 10:30:02', modified_by ='v3alpha', display_currency_code ='USD', created_datetime ='2024-03-05 10:30:02', sub_agent_rate ='0.000', created_by ='v3alpha', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Emirati', ip_addr ='';
[03/05/2024 10:30:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='219', old_reff_id ='66', booking_id ='510', supplier_id ='S000000001', total_nights ='1', arrival_date ='2024/04/15', departure_date ='2024/04/16', hotel_id ='4', hotel_name ='TAJ QTECH', hotel_address1 ='mumbai', hotel_phone ='1234567890', hotel_rating ='4.0', rate_code ='', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[03/05/2024 10:30:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '437', old_reff_id = '66', booking_id = '510', booking_detail_id = '1', salutations = 'Mr', room = '0', rid = '227', first_name = 'deepak', last_name = 'trivedi' ,passenger_type = 'adult' ,age = '';
[03/05/2024 10:30:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '438', old_reff_id = '66', booking_id = '510', booking_detail_id = '1', salutations = 'Mr', room = '0', rid = '227', first_name = 'TBAA', last_name = 'TBAA' ,passenger_type = 'adult' ,age = '';
[03/05/2024 10:30:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[03/05/2024 10:30:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '227', old_reff_id = '66', booking_id = '510', booking_detail_id = '1', room_type_code = '2~~~1~~~1~~~2~~~~~~~~~64440~~~0~~~S000000001', room_name = 'double', room_type_description = 'Delux  -Room Only : 2 Pax ', display_nightly_rates = 'a:1:{i:0;a:5:{s:18:"displayNightlyRate";i:110;s:15:"pricing_profile";a:9:{s:8:"range_id";s:2:"82";s:4:"from";s:1:"0";s:2:"to";s:7:"1000000";s:6:"amount";i:110;s:7:"percent";s:5:"10.00";s:8:"currency";N;s:10:"profile_id";s:2:"12";s:18:"without_mul_amount";s:4:"0.00";s:16:"check_mul_amount";i:0;}s:16:"promotionDisplay";s:0:"";s:25:"displayNightlyRateDisplay";s:218:"Supplier Name - localsupplier(travelclick - S000000001), Rate - 100 USD, Currency Multiplier (USD-USD) - 1.00000 Markup in % - 10.00%, Markup Amount - 0, , Markup Amount in SAR - 0.00,Supplier Commission-0 #localsystem";s:13:"whNightlyRate";d:137.5;}}' ,native_nightly_rates = 'a:1:{i:0;a:4:{s:19:"O_nativeNightlyRate";i:100;s:17:"nativeNightlyRate";i:100;s:9:"free_sale";s:2:"no";s:14:"Discount/Offer";a:7:{s:4:"code";s:0:"";s:4:"Name";s:0:"";s:7:"S_Value";s:0:"";s:5:"Value";i:0;s:12:"Display_Name";s:0:"";s:10:"Offer_Note";N;s:10:"Offer_Type";N;}}}' ,native_room_rate_total = '100' ,display_room_rate_total = '110' ,wh_room_rate_total = '137.5' ,number_of_rooms = '1';
[03/05/2024 10:30:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[03/05/2024 10:30:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[03/05/2024 10:30:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '510', booking_detail_id = '219', room_type_code = '2~~~1~~~1~~~2~~~~~~~~~64440~~~0~~~S000000001', room_name = 'double', room_type_description = 'Delux  -Room Only : 2 Pax ', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"100";s:13:"whNightlyRate";s:3:"100";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:3:"100";}}' ,native_room_rate_total = '100' ,display_room_rate_total = '100' ,number_of_rooms = '1';
[03/05/2024 10:30:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '510', booking_detail_id = '219', salutations = 'Mr', room = '', rid = '228', first_name = 'deepak', last_name = 'trivedi' ,age = '';
[03/05/2024 10:30:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '510', booking_detail_id = '219', salutations = 'Mr', room = '1', rid = '228', first_name = 'TBAA', last_name = 'TBAA' ,age = '';
[03/05/2024 10:30:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='123456',voucher_id='',voucher_hashcode='',native_currency_code='USD',display_currency_code='USD',cancellation_policy='						
											',supplier_cancellation_policy='',applied_multiplier='1',applied_markup='',agent_markup='',consultant_id='v3alpha',basecurrency_multiplier='1',basecurrency_multiplier_native='1'_native,agent_currency_multiplier='1',current_status='confirmed',status_date='2024-03-05 10:30:02',service_date='2024-04-15',check_out_date='2024-04-16',display_room_rate= '100',display_discount='0',modified_datetime='2024-03-05 10:30:02',modified_by ='v3alpha',native_room_rate='100',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='deepak',leader_last_name='trivedi',nationality ='Emirati',booking_type ='online',supplier_profile_id ='19',expiration_date= '2024-03-31 10:29:11',source_type='localsystem',free_sale='yes',special_comment='',admin_note='',comment_contract='' WHERE id='510';
[03/05/2024 10:30:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='100', agent_markup='', supplier_rate='100', wh_sub_agent_rate='', wh_agent_rate='100' where id='510';
[03/05/2024 10:30:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'S000000001' , total_rooms= '1', arrival_date='2024/04/15', departure_date='2024/04/16', rate_code='~', hotel_address1='mumbai', hotel_name='TAJ QTECH', hotel_phone='1234567890' where booking_id ='510';
[03/05/2024 10:30:02], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','510','confirmed','2024-03-05 10:30:02','Booking Modified by v3alpha','v3alpha','43.239.53.130','v3alpha','','');
[03/05/2024 10:30:04], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into temp(booking_id,mail_send_to)values('510','sujay.raut@qtechsoftware.com');
[03/05/2024 10:30:04], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into temp(booking_id,mail_send_to)values('510','sujay.raut@qtechsoftware.com');
[03/05/2024 10:30:25], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:30:25' WHERE id= '625';
[03/05/2024 10:30:31], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:30:31' WHERE id= '625';
[03/05/2024 10:30:59], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:30:59' WHERE id= '625';
[03/05/2024 10:33:21], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:33:21' WHERE id= '591';
[03/05/2024 10:33:25], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:33:25' WHERE id= '591';
[03/05/2024 10:33:25], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/11' , departure_date = '2024/04/12' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-03-05 10:33:25' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:33:26' WHERE id= '591';
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/05_03_2024/request_availability_Gajendra_87_1709634806_90.json', 'e1p/05_03_2024/response_availability_Gajendra_87_1709634806_90.json', 'e1p/05_03_2024/response_header_availability_Gajendra_87_1709634806_90.json', 'expediapackage', '2024-03-05 10:33:26', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '87');
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-05 10:33:26.376'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.224'
        , error_description = ''
        , memory_used = '2125984'
        WHERE id = '47281';
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.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', 'e1/05_03_2024/request_availability_Gajendra_87_1709634806_77.json', 'e1/05_03_2024/response_availability_Gajendra_87_1709634806_77.json', 'e1/05_03_2024/response_header_availability_Gajendra_87_1709634806_77.json', 'expedia', '2024-03-05 10:33:26', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '87');
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-05 10:33:26.377'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.270'
        , error_description = ''
        , memory_used = '2125440'
        WHERE id = '47282';
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__1_10_33_26_1709634806.xml', 'd1/05_03_2024/response_availability_Gajendra__1_10_33_26_1709634806.xml', 'd1/05_03_2024/response_header_availability_Gajendra__1_10_33_26_1709634806.xml', 'dotw', '2024-03-05 10:33:26', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '87');
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__7_10_33_26_1709634806.xml', 'd1/05_03_2024/response_availability_Gajendra__7_10_33_26_1709634806.xml', 'd1/05_03_2024/response_header_availability_Gajendra__7_10_33_26_1709634806.xml', 'dotw', '2024-03-05 10:33:26', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '87');
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=1&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:33:26.376'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.299'
        , error_description = ''
        , memory_used = '2333080'
        WHERE id = '47283';
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=7&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:33:26.376'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.302'
        , error_description = ''
        , memory_used = '2332864'
        WHERE id = '47284';
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__3_10_33_26_1709634806.xml', 'd1/05_03_2024/response_availability_Gajendra__3_10_33_26_1709634806.xml', 'd1/05_03_2024/response_header_availability_Gajendra__3_10_33_26_1709634806.xml', 'dotw', '2024-03-05 10:33:26', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '87');
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=3&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:33:26.376'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.334'
        , error_description = ''
        , memory_used = '2333080'
        WHERE id = '47285';
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__6_10_33_26_1709634806.xml', 'd1/05_03_2024/response_availability_Gajendra__6_10_33_26_1709634806.xml', 'd1/05_03_2024/response_header_availability_Gajendra__6_10_33_26_1709634806.xml', 'dotw', '2024-03-05 10:33:26', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '87');
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=6&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:33:26.376'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.356'
        , error_description = ''
        , memory_used = '2332864'
        WHERE id = '47286';
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__8_10_33_26_1709634806.xml', 'd1/05_03_2024/response_availability_Gajendra__8_10_33_26_1709634806.xml', 'd1/05_03_2024/response_header_availability_Gajendra__8_10_33_26_1709634806.xml', 'dotw', '2024-03-05 10:33:26', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '87');
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__0_10_33_26_1709634806.xml', 'd1/05_03_2024/response_availability_Gajendra__0_10_33_26_1709634806.xml', 'd1/05_03_2024/response_header_availability_Gajendra__0_10_33_26_1709634806.xml', 'dotw', '2024-03-05 10:33:26', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '87');
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__2_10_33_26_1709634806.xml', 'd1/05_03_2024/response_availability_Gajendra__2_10_33_26_1709634806.xml', 'd1/05_03_2024/response_header_availability_Gajendra__2_10_33_26_1709634806.xml', 'dotw', '2024-03-05 10:33:26', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '87');
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=8&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:33:26.376'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.380'
        , error_description = ''
        , memory_used = '2332864'
        WHERE id = '47287';
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=2&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:33:26.376'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.382'
        , error_description = ''
        , memory_used = '2332864'
        WHERE id = '47289';
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=0&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:33:26.376'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.382'
        , error_description = ''
        , memory_used = '2333080'
        WHERE id = '47288';
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__4_10_33_26_1709634806.xml', 'd1/05_03_2024/response_availability_Gajendra__4_10_33_26_1709634806.xml', 'd1/05_03_2024/response_header_availability_Gajendra__4_10_33_26_1709634806.xml', 'dotw', '2024-03-05 10:33:26', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '87');
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__5_10_33_26_1709634806.xml', 'd1/05_03_2024/response_availability_Gajendra__5_10_33_26_1709634806.xml', 'd1/05_03_2024/response_header_availability_Gajendra__5_10_33_26_1709634806.xml', 'dotw', '2024-03-05 10:33:26', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '87');
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=4&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:33:26.376'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.394'
        , error_description = ''
        , memory_used = '2333080'
        WHERE id = '47290';
[03/05/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=5&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:33:26.376'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.396'
        , error_description = ''
        , memory_used = '2332864'
        WHERE id = '47291';
[03/05/2024 10:33:27], [file name :-/home/otrams/public_html/beta/call.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', 'e1/05_03_2024/request_availability_Gajendra_87_1709634806_93.json', 'e1/05_03_2024/response_availability_Gajendra_87_1709634806_93.json', 'e1/05_03_2024/response_header_availability_Gajendra_87_1709634806_93.json', 'expedia', '2024-03-05 10:33:27', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '87');
[03/05/2024 10:33:28], [file name :-/home/otrams/public_html/beta/call.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', 'e1/05_03_2024/request_availability_Gajendra_87_1709634806_40.json', 'e1/05_03_2024/response_availability_Gajendra_87_1709634806_40.json', 'e1/05_03_2024/response_header_availability_Gajendra_87_1709634806_40.json', 'expedia', '2024-03-05 10:33:28', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '87');
[03/05/2024 10:33:28], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/05_03_2024/request_availability_Gajendra_87_1709634806_72.json', 'e1p/05_03_2024/response_availability_Gajendra_87_1709634806_72.json', 'e1p/05_03_2024/response_header_availability_Gajendra_87_1709634806_72.json', 'expediapackage', '2024-03-05 10:33:28', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '87');
[03/05/2024 10:33:28], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/05_03_2024/request_availability_Gajendra_87_1709634806_22.json', 'e1p/05_03_2024/response_availability_Gajendra_87_1709634806_22.json', 'e1p/05_03_2024/response_header_availability_Gajendra_87_1709634806_22.json', 'expediapackage', '2024-03-05 10:33:28', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '87');
[03/05/2024 10:33:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-05 10:33:26.377'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.313'
        , error_description = ''
        , memory_used = '159729304'
        WHERE id = '47292';
[03/05/2024 10:33:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-05 10:33:26.377'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.321'
        , error_description = ''
        , memory_used = '166978776'
        WHERE id = '47295';
[03/05/2024 10:33:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-05 10:33:26.376'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.426'
        , error_description = ''
        , memory_used = '190650160'
        WHERE id = '47293';
[03/05/2024 10:33:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-05 10:33:26.377'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.526'
        , error_description = ''
        , memory_used = '198988928'
        WHERE id = '47294';
[03/05/2024 10:33:29], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '706',
        request_path = '/xml_all.php?userid=7873&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a',
        duration = '3.835',
        merge_duration = '0.003',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '2.52',
        system_load_5_min = '3.50',
        system_load_15_min = '4.56',
        system_memory_usage = '92.53',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '87') + '2457160',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '87';
[03/05/2024 10:33:30], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:33:30' WHERE id= '591';
[03/05/2024 10:33:31], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:33:31' WHERE id= '591';
[03/05/2024 10:33:32], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:33:32' WHERE id= '591';
[03/05/2024 10:34:08], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:34:08' WHERE id= '591';
[03/05/2024 10:34:08], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/11' , departure_date = '2024/04/12' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-03-05 10:34:08' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[03/05/2024 10:34:09], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:34:09' WHERE id= '591';
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__4_10_34_09_1709634849.xml', 'd1/05_03_2024/response_availability_Gajendra__4_10_34_09_1709634849.xml', 'd1/05_03_2024/response_header_availability_Gajendra__4_10_34_09_1709634849.xml', 'dotw', '2024-03-05 10:34:10', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '88');
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=4&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:34:09.797'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.326'
        , error_description = ''
        , memory_used = '2332832'
        WHERE id = '47296';
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__5_10_34_09_1709634849.xml', 'd1/05_03_2024/response_availability_Gajendra__5_10_34_09_1709634849.xml', 'd1/05_03_2024/response_header_availability_Gajendra__5_10_34_09_1709634849.xml', 'dotw', '2024-03-05 10:34:10', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '88');
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__7_10_34_09_1709634849.xml', 'd1/05_03_2024/response_availability_Gajendra__7_10_34_09_1709634849.xml', 'd1/05_03_2024/response_header_availability_Gajendra__7_10_34_09_1709634849.xml', 'dotw', '2024-03-05 10:34:10', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '88');
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=5&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:34:09.797'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.337'
        , error_description = ''
        , memory_used = '2333048'
        WHERE id = '47297';
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=7&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:34:09.797'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.338'
        , error_description = ''
        , memory_used = '2332896'
        WHERE id = '47298';
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__3_10_34_09_1709634849.xml', 'd1/05_03_2024/response_availability_Gajendra__3_10_34_09_1709634849.xml', 'd1/05_03_2024/response_header_availability_Gajendra__3_10_34_09_1709634849.xml', 'dotw', '2024-03-05 10:34:10', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '88');
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=3&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:34:09.797'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.344'
        , error_description = ''
        , memory_used = '2333048'
        WHERE id = '47299';
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.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', 'e1/05_03_2024/request_availability_Gajendra_88_1709634849_82.json', 'e1/05_03_2024/response_availability_Gajendra_88_1709634849_82.json', 'e1/05_03_2024/response_header_availability_Gajendra_88_1709634849_82.json', 'expedia', '2024-03-05 10:34:10', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '88');
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__6_10_34_09_1709634849.xml', 'd1/05_03_2024/response_availability_Gajendra__6_10_34_09_1709634849.xml', 'd1/05_03_2024/response_header_availability_Gajendra__6_10_34_09_1709634849.xml', 'dotw', '2024-03-05 10:34:10', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '88');
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__1_10_34_09_1709634849.xml', 'd1/05_03_2024/response_availability_Gajendra__1_10_34_09_1709634849.xml', 'd1/05_03_2024/response_header_availability_Gajendra__1_10_34_09_1709634849.xml', 'dotw', '2024-03-05 10:34:10', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '88');
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-05 10:34:09.798'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.350'
        , error_description = ''
        , memory_used = '2125824'
        WHERE id = '47300';
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=6&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:34:09.797'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.351'
        , error_description = ''
        , memory_used = '2332832'
        WHERE id = '47301';
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=1&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:34:09.797'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.355'
        , error_description = ''
        , memory_used = '2332832'
        WHERE id = '47302';
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__0_10_34_09_1709634849.xml', 'd1/05_03_2024/response_availability_Gajendra__0_10_34_09_1709634849.xml', 'd1/05_03_2024/response_header_availability_Gajendra__0_10_34_09_1709634849.xml', 'dotw', '2024-03-05 10:34:10', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '88');
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=0&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:34:09.797'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.361'
        , error_description = ''
        , memory_used = '2332832'
        WHERE id = '47303';
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/05_03_2024/request_availability_Gajendra_88_1709634849_17.json', 'e1p/05_03_2024/response_availability_Gajendra_88_1709634849_17.json', 'e1p/05_03_2024/response_header_availability_Gajendra_88_1709634849_17.json', 'expediapackage', '2024-03-05 10:34:10', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '88');
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-05 10:34:09.798'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.370'
        , error_description = ''
        , memory_used = '2126024'
        WHERE id = '47304';
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__8_10_34_10_1709634850.xml', 'd1/05_03_2024/response_availability_Gajendra__8_10_34_10_1709634850.xml', 'd1/05_03_2024/response_header_availability_Gajendra__8_10_34_10_1709634850.xml', 'dotw', '2024-03-05 10:34:10', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '88');
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.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', 'd1/05_03_2024/request_availability_Gajendra__2_10_34_10_1709634850.xml', 'd1/05_03_2024/response_availability_Gajendra__2_10_34_10_1709634850.xml', 'd1/05_03_2024/response_header_availability_Gajendra__2_10_34_10_1709634850.xml', 'dotw', '2024-03-05 10:34:10', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '88');
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=8&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:34:09.798'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.378'
        , error_description = ''
        , memory_used = '2333048'
        WHERE id = '47305';
[03/05/2024 10:34:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=dotw&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=2&total_request=9&web_service=no'
        , http_hit_time = '2024-03-05 10:34:09.797'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.379'
        , error_description = ''
        , memory_used = '2332832'
        WHERE id = '47306';
[03/05/2024 10:34:11], [file name :-/home/otrams/public_html/beta/call.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', 'e1/05_03_2024/request_availability_Gajendra_88_1709634849_22.json', 'e1/05_03_2024/response_availability_Gajendra_88_1709634849_22.json', 'e1/05_03_2024/response_header_availability_Gajendra_88_1709634849_22.json', 'expedia', '2024-03-05 10:34:11', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '88');
[03/05/2024 10:34:11], [file name :-/home/otrams/public_html/beta/call.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', 'e1/05_03_2024/request_availability_Gajendra_88_1709634849_5.json', 'e1/05_03_2024/response_availability_Gajendra_88_1709634849_5.json', 'e1/05_03_2024/response_header_availability_Gajendra_88_1709634849_5.json', 'expedia', '2024-03-05 10:34:11', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '88');
[03/05/2024 10:34:12], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/05_03_2024/request_availability_Gajendra_88_1709634849_89.json', 'e1p/05_03_2024/response_availability_Gajendra_88_1709634849_89.json', 'e1p/05_03_2024/response_header_availability_Gajendra_88_1709634849_89.json', 'expediapackage', '2024-03-05 10:34:12', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '88');
[03/05/2024 10:34:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-05 10:34:09.798'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.758'
        , error_description = ''
        , memory_used = '176176800'
        WHERE id = '47307';
[03/05/2024 10:34:12], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/05_03_2024/request_availability_Gajendra_88_1709634849_89.json', 'e1p/05_03_2024/response_availability_Gajendra_88_1709634849_89.json', 'e1p/05_03_2024/response_header_availability_Gajendra_88_1709634849_89.json', 'expediapackage', '2024-03-05 10:34:12', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '88');
[03/05/2024 10:34:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-05 10:34:09.798'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.865'
        , error_description = ''
        , memory_used = '177197544'
        WHERE id = '47308';
[03/05/2024 10:34:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-05 10:34:09.798'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.128'
        , error_description = ''
        , memory_used = '184335600'
        WHERE id = '47309';
[03/05/2024 10:34:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-05 10:34:09.798'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.147'
        , error_description = ''
        , memory_used = '184980536'
        WHERE id = '47310';
[03/05/2024 10:34:13], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '730',
        request_path = '/xml_all.php?userid=7873&sessionid=4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a',
        duration = '4.445',
        merge_duration = '0.003',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '1.91',
        system_load_5_min = '3.20',
        system_load_15_min = '4.41',
        system_memory_usage = '92.05',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '88') + '2457064',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '88';
[03/05/2024 10:34:14], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:34:14' WHERE id= '591';
[03/05/2024 10:34:14], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:34:14' WHERE id= '591';
[03/05/2024 10:34:16], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:34:16' WHERE id= '591';
[03/05/2024 10:37:09], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:37:09' WHERE id= '591';
[03/05/2024 10:37:09], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:37:09' WHERE id= '591';
[03/05/2024 10:37:09], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1709635029','43.239.53.130');
[03/05/2024 10:37:09], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/05_03_2024/request_valuation_Gajendra_88_1709635029_41.json', 'e1p/05_03_2024/response_valuation_Gajendra_88_1709635029_41.json', 'e1p/05_03_2024/response_header_valuation_Gajendra_88_1709635029_41.json', 'expediapackage', '2024-03-05 10:37:09', '', '4feef6fd805e087e6303c39e692841a4b117741fb7731e893d241efb2ad3b00a', '88');
[03/05/2024 10:51:55], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-05 10:51:55' WHERE id= '591';
