[10/28/2020 12:03:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE quotation_settings SET email_template_data = 'a%3A2%3A%7Bs%3A14%3A%22email_template%22%3Ba%3A24%3A%7Bs%3A6%3A%22action%22%3Bs%3A19%3A%22updateEmailTemplate%22%3Bs%3A7%3A%22is_ajax%22%3Bs%3A4%3A%22true%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A13%3A%22QTECHCA002227%22%3Bs%3A8%3A%22agent_id%22%3Bs%3A2%3A%2222%22%3Bs%3A6%3A%22themes%22%3Bs%3A1%3A%224%22%3Bs%3A10%3A%22categories%22%3Bs%3A1%3A%223%22%3Bs%3A13%3A%22sel_theme_img%22%3Bi%3A0%3Bs%3A18%3A%22selected_theme_img%22%3Bs%3A153%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fgroups%2Femail%2Fthemes%2FRDT%2FWildlife%2FWildlife+-+Shehan+-+Elephant+and+baby.JPG%22%3Bs%3A10%3A%22banner_img%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A5%3A%2282246%22%3Bi%3A1%3Bs%3A5%3A%2271100%22%3B%7Ds%3A22%3A%22banner_images_box_imgs%22%3Ba%3A6%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3Bi%3A1%3Bs%3A0%3A%22%22%3Bi%3A2%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_142909.png%22%3Bi%3A3%3Bs%3A0%3A%22%22%3Bi%3A4%3Bs%3A0%3A%22%22%3Bi%3A5%3Bs%3A0%3A%22%22%3B%7Ds%3A13%3A%22highlight_img%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A5%3A%2282246%22%3Bi%3A1%3Bs%3A5%3A%2271100%22%3B%7Ds%3A25%3A%22highlight_images_box_imgs%22%3Ba%3A6%3A%7Bi%3A0%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_140636.png%22%3Bi%3A1%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_142841.png%22%3Bi%3A2%3Bs%3A0%3A%22%22%3Bi%3A3%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_051712.png%22%3Bi%3A4%3Bs%3A0%3A%22%22%3Bi%3A5%3Bs%3A0%3A%22%22%3B%7Ds%3A141%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fgroups%2Femail%2Fthemes%2FRDT%2FCulture%2FCulture_-_Devaka_-_Sigirya_jpg%22%3Bs%3A2%3A%22on%22%3Bs%3A119%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_142909_png%22%3Bs%3A2%3A%22on%22%3Bs%3A119%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_140636_png%22%3Bs%3A2%3A%22on%22%3Bs%3A119%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_142841_png%22%3Bs%3A2%3A%22on%22%3Bs%3A119%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_051712_png%22%3Bs%3A2%3A%22on%22%3Bs%3A13%3A%22setPresetText%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22servicewisedate%22%3Bs%3A0%3A%22%22%3Bs%3A22%3A%22quotation_special_note%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22sel_banner_img%22%3Ba%3A6%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3Bi%3A1%3Bs%3A1%3A%221%22%3Bi%3A2%3Bs%3A1%3A%222%22%3Bi%3A3%3Bs%3A1%3A%223%22%3Bi%3A4%3Bs%3A1%3A%224%22%3Bi%3A5%3Bs%3A1%3A%225%22%3B%7Ds%3A17%3A%22sel_highlight_img%22%3Ba%3A6%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3Bi%3A1%3Bs%3A1%3A%221%22%3Bi%3A2%3Bs%3A1%3A%222%22%3Bi%3A3%3Bs%3A1%3A%223%22%3Bi%3A4%3Bs%3A1%3A%224%22%3Bi%3A5%3Bs%3A1%3A%225%22%3B%7Ds%3A153%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fgroups%2Femail%2Fthemes%2FTFG%2FWildlife%2FWildlife_-_Shehan_-_Elephant_and_baby_JPG%22%3Bs%3A2%3A%22on%22%3Bs%3A153%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fgroups%2Femail%2Fthemes%2FRDT%2FWildlife%2FWildlife_-_Shehan_-_Elephant_and_baby_JPG%22%3Bs%3A2%3A%22on%22%3B%7Ds%3A14%3A%22service_images%22%3Ba%3A2%3A%7Bs%3A12%3A%22hotel_images%22%3BN%3Bs%3A11%3A%22tour_images%22%3BN%3B%7D%7D',preset_text_fields = 'a%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A5%3A%22label%22%3Bs%3A19%3A%22Nicolas+pretext+New%22%3Bs%3A11%3A%22description%22%3Bs%3A12197%3A%22%3Cspan+style%3D%22font-family%3A+Calibri%3B+font-weight%3A+bold%3B%22%3E%3Cfont+size%3D%222%22%3EFlight+schedule%3A%3C%2Ffont%3E%3C%2Fspan%3E%3Cbr+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cbr+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EArrival%3A%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+To+be+advised%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2Ffont%3E%3C%2Fspan%3E%3Cspan+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3C%2Fspan%3E%3Cbr+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EDeparture%3A%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+To+be+advised%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2Ffont%3E%3C%2Fspan%3E%3Cbr+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cbr+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B+font-weight%3A+bold%3B%22%3E%3Cfont+size%3D%222%22%3EPackage+includes%3A%3C%2Ffont%3E%3C%2Fspan%3E%3Cbr+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cdiv+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cul%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EMeals+as+mentioned+above%26nbsp%3B%3Cbr%3E%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3E3+rooms+at+all+properties%3Cbr%3E%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3ETransport+in+a+private+air+conditioned%26nbsp%3B+micro+van+with+the+services+of+an+english+speaking+chauffeur+guide%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3ETrain+ride+from+Peradeniya+to+Hatton+%28+Strictly+subject+to+availability%29%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3C%2Ful%3E%3C%2Fdiv%3E%3Cbr+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B+font-weight%3A+bold%3B%22%3E%3Cfont+size%3D%222%22%3EEntrances+fees%3A%3C%2Ffont%3E%3C%2Fspan%3E%3Cbr+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cul+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3ESigiriya%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EPolonnaruwa%26nbsp%3B%3Cbr%3E%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EDambulla+cave+temple%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3E1+Game+drive+in+Udawalawe+National+park%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EElephant+Transit+home%3Cbr%3E%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EKandy+Temple%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3ETea+factory+visit+with+Resident+Planter%3Cbr%3E%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EWhale+watching+in+Mirrissa+%E2%80%93+join+in%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EHistory+%26amp%3B+architecture+walk+around+Galle+Fort+-+join+in%3C%2Ffont%3E%3Cbr%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EMillenium+Elephant+foundation+with+lunch%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EColombo%27s+Cultural+walk+-+Join+in%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3C%2Ful%3E%3Cbr+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B+font-weight%3A+bold%3B%22%3E%3Cfont+size%3D%222%22%3EAll+applicable+taxes+including+VAT%3C%2Ffont%3E%3C%2Fspan%3E%3Cbr+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cbr+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3EComplementary+Amenities%3A%3C%2Fspan%3E%3Cbr%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+Welcome+pack%3Cbr%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+Sim+card+on+request%3Cbr%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+Welcome+dinner+at+ministry+of+Crab+%28Main+course+Dessert+Water%29%3Cbr%3E%3C%2Ffont%3E%3C%2Fspan%3E%3Cdiv+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EIn-Vehicle%3A+We+strive+to+deliver+the+best+possible+%E2%80%98in-vehicle+experience%E2%80%99+%E2%80%93+our+vehicles+are+equipped+with+a+TRAVEL+KIT+which+includes+comfortable+cushions%2C+sanitizers%2C+mosquito+repellent%2C+wet+wipes%2C+etc%E2%80%A6+Our+vehicles+carry+a+dongle+%2F+WIFI+and+a+folder+containing+a+good+map+as+well+a+very+detailed+Booking+Information+document.+We+are+constantly+improving+the+information+we+provide+for+clients+to+make+the+most+of+their+trip.%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fdiv%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3E%3Cbr%3E%26nbsp%3B%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3EPackage+Excludes%3A%3C%2Fspan%3E%3Cbr%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+ETA+Mandatory+VISA+on+Arrival.%3Cbr%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+International+or+domestic+flights.%3Cbr%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+Travel+insurance.%3Cbr%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+Expenses+of+any+personal+nature.%3Cbr%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+Tips%2Fgratuities+and+porterage.%3Cbr%3E%3C%2Ffont%3E%3C%2Fspan%3E%3Cdiv+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+Any+other+services+not+specified+above.%3Cbr%3E%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fdiv%3E%3Cdiv+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cbr%3E%3Cfont+size%3D%222%22%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3E%3C%2Fspan%3E%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fdiv%3E%3Cdiv+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3E%3C%2Fspan%3E%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fdiv%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ENotes%3A%3C%2Fspan%3E%3Cbr%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+All+drive+times+are+approximate+and+subject+to+change%3Cbr%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+Transport+price+includes+accommodation+for+the+chauffeur+guide%3Cbr%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+All+prices+are+inclusive+of+tax+and+service+charges%3Cbr%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+All+reservations+subject+to+availability+at+time+of+booking%3Cbr%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+The+standard+check-out+time+in+Sri+Lanka+is+12+noon%3Cbr%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B+Interconnecting+Rooms+or+rooms+next+to+each+other+will+be+requested+for+%26amp%3B+strictly+subject+to+availability+at+time+of+check+in.+this+is+at+discretion+of+hotel.%3Cbr%3E%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3EPAYMENT+SCHEDULES%3A%3C%2Fspan%3E%3Cbr%3E%28i%29+Upon+receipt+of+Travel+Voucher%3A+30+per+cent+of+cost.%3Cbr%3E%28ii%29+Not+less+than+six+weeks+before+departure%3A+100+per+cent+of+cost.%3Cbr%3E%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ENotes%3A%3C%2Fspan%3E%3Cbr%3E%28i%29+Payments+are+required+within+seven+days%2C+except+where+circumstances+dictate+that+we+request+otherwise.%3Cbr%3E%28ii%29+Suppliers+may+demand+stricter+payment+terms+on+some+bookings.+These+occasions+will+always+be+advised+to+you+before+booking+and+stated+on+your+Travel+Voucher.+Individual+cancellation+terms+will+always+be+stated.%3Cbr%3E%28iii%29+Credit-card+payments+are+subject+to+an+additional+charge+of+1+per+cent.+This+contributes+to+our+credit-card+costs+and+helps+to+reduce+our+basic+prices.+There+are+no+charges+for+use+of+debit+cards.%3Cbr%3E%28iv%29+Customers+must+pay+all+bank+charges+in+the+case+of+a+bank+transfer.+Failure+to+do+so+will+invalidate+your+booking+and+will+bring+a+further+charge+to+cover+bank+charges%3Cbr%3E%28v%29+There+will+be+no+additional+postage+fees%2C+booking+fees+or+other+hidden+charges.+Exchange+rates+are+based+on+live+on-day+rates+at+time+of+booking+and+are+not+subject+to+change.%3Cbr%3E%28vi%29+Late+payments+risk+cancellation.%3Cbr%3E%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ECANCELLATION+BY+US%3A%3C%2Fspan%3E%3Cbr%3EWe+are+committed+to+high+levels+of+professionalism+to+protect+your+booking.+But+we+reserve+the+right+to+cancel+your+booking+in+any+incidence+of+Force+Majeure+%28see+clause+below%29.+In+this+event+we+will+return+all+recoverable+costs+and%2C+wherever+possible%2C+offer+an+alternative+booking+of+comparable+type+and+quality+for+your+consideration.+We+cannot+be+held+liable+for+any+incidental+expenses+that+you+may+incur+during+arrangements+for+a+booking+that+is+subsequently+cancelled+by+us.%3Cbr%3E%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ECANCELLATION+BY+YOU%3A%3C%2Fspan%3E%3Cbr%3E%3C%2Ffont%3E%3C%2Fspan%3E%3Cul+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EIn+event+of+cancellation%2C+in+whole+or+part%2C+we+voluntarily+return+all+recoverable+costs%2C+above+and+beyond+the+limits+laid+down+in+our+Booking+Conditions.%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EIn+the+case+of+cancelled+tailor-made+itineraries%2C+we+reserve+the+right+to+levy+additional+admin+costs+of+up+to+8+per+cent+of+total+booking+cost.%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EOther+cancellation+refunds+are+determined+on+a+case-by-case+basis%2C+whether+provided+directly+or+indirectly+by+us.+We+do+not+normally+refund+for+early+checkouts+or+no-shows.%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EAny+individual+wishing+to+cancel+a+booking+must+immediately+notify+their+sales+consultant+by+email%2C+quoting+their+ADFT+number.+The+cancellation+is+timed+from+0900+on+the+next+working+day+to+enable+us+to+contact+Suppliers.+In+the+event+of+a+group+cancellation+%28by+the+tour+leader%29%2C+we+will+hold+each+individual+equally+liable+for+cancellation+costs.%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EAfter+payment+of+deposit%3A+Up+to+100+per+cent+of+deposit.%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3ELess+than+six+weeks+before+departure%3A+Up+to+60+per+cent+of+booking+cost.%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3ELess+than+30+days+before+departure%3A+Up+to+100+per+cent+of+booking+cost.%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EYou+should+check+whether+your+travel+insurance+policy+covers+you+for+refunds.%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3C%2Ful%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3E%3Cbr%3ENOTE%3A+We+offer+additional+guarantees+concerning+refunds+in+the+clause+on+Terrorism+and+Personal+Safety.%3Cbr%3E%3Cbr%3EPS%3A+Note+that+you+need+a+visa%3A+In+order+to+obtain+a+visa+to+enter+Sri+Lanka+you+need+to+go+to+the+following+website.+http%3A%2F%2Fwww.eta.gov.lk%2Fslvisa%2F.+Choose+English+as+the+language+and+then+click+APPLY.+Agree+to+the+terms+and+conditions+and+then+APPLY+FOR+AN+INDIVIDUAL.+They+need+to+fill+in+all+the+mandatory+fields+and+then+pay+a+FEE+of+30+USD+using+their+credit+card.+The+system+is+secure.+It+takes+VISA%2C+MASTER+and+AMEX.%3Cbr%3E%3Cbr%3E%26nbsp%3BSri+Lanka+Immigration+and+Emigration+may+grant+or+issue+a+visa+to+you+if+-%26nbsp%3B%3Cbr%3E%3C%2Ffont%3E%3C%2Fspan%3E%3Cul+style%3D%22font-family%3A+Gotham%2C+%22+helvetica%3D%22%22+neue%22%2C%3D%22%22+helvetica%2C%3D%22%22+arial%2C%3D%22%22+sans-serif%3B%22%3D%22%22%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3E%26nbsp%3BSri+Lanka+Immigration+%26amp%3B+Emigration+is+satisfied+that+you+are+suitable+to+enter+Sri+Lanka.%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3E%26nbsp%3BSri+Lanka+Immigration+%26amp%3B+Emigration+approves+the+purpose+for+which+you+are+entering+Sri+Lanka.%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3E%26nbsp%3BYou+hold+a+passport+valid+for+a+minimum+period+of+six+months+from+the+date+you+arrive+in+Sri+Lanka.%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3E%26nbsp%3BSri+Lanka+Immigration+%26amp%3B+Emigration+is+satisfied+that+you+have+adequate+funds+for+your+maintenance+whilst+in+Sri+Lanka+and+for+the+payment+of+your+return+passage+to+the+country+which+issued+your+passport.%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3Cli%3E%3Cspan+style%3D%22font-family%3A+Calibri%3B%22%3E%3Cfont+size%3D%222%22%3EYou+are+in+possession+of+a+written+assurance+%28ticket%29+to+return+to+the+country+of+domicile+or+a+visa+to+the+next+country+of+destination+if+you+are+a+visit+visa+holder.%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fli%3E%3C%2Ful%3E%22%3Bs%3A2%3A%22id%22%3Bs%3A2%3A%2211%22%3B%7D%7D',updated_by = 'tfg',updated_at = '2020-10-28 12:03:48' where quotation_unique_code = 'QTECHCA002227';

[10/28/2020 12:10:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/forgot_password_supplier.php],update psa_users set pass= ? where id = ? and user_type=? and site_id=?;
[10/28/2020 12:10:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/forgot_password_supplier.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-28 12:10:51',`log_type`= 'Local Supplier Password Changed',`sql_query`= '',`log_description`= 'Local Supplier : RateGainSL Changed_by=tfg',`ip`= '60.254.5.70';
[10/28/2020 12:10:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/forgot_password_supplier.php],insert into email_logs SET `subject`= 'Supplier Forgot Password - The Fabulous Getaway',from_email_id= '',body= '[encoded data, 9140 characters]',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/tms/forgot_password_supplier.php',create_date= '2020-10-28 12:10:51';
[10/28/2020 12:10:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/forgot_password_supplier.php],INSERT INTO mails_error_log set mailfrom='',mailsubject='Supplier Forgot Password - The Fabulous Getaway',mailbody='
&lt;!DOCTYPE html PUBLIC \&quot;-//W3C//DTD XHTML 1.0 Transitional//EN\&quot; \&quot;http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\&quot;&gt;
&lt;html xmlns=\&quot;http://www.w3.org/1999/xhtml\&quot;&gt;
&lt;head&gt;
&lt;meta http-equiv=\&quot;Content-Type\&quot; content=\&quot;text/html; charset=utf-8\&quot; /&gt;
&lt;title&gt;:: The Fabulous Getaway :: &lt;/title&gt;

&lt;style type=\&quot;text/css\&quot;&gt;
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
&lt;/style&gt;

&lt;/head&gt;

&lt;body&gt;
&lt;table width=\&quot;700\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot; align=\&quot;center\&quot; style=\&quot; margin:0 auto; border:1px solid #e8eef1;\&quot;&gt;
&lt;!-- createing new header page by Dilip 27-02-2014 --&gt;
&lt;tr&gt;
    &lt;td valign=\&quot;top\&quot; style=\&quot;border-bottom:1px solid #dce4e7;  padding:0 0 5px 0; height:90px; line-height:0px; background:#fff;\&quot;&gt;
        &lt;table width=\&quot;646\&quot; border=\&quot;0\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot;&gt;
         &lt;tr&gt;
            &lt;td colspan=\&quot;2\&quot; style=\&quot; height:21px;\&quot;&gt;&lt;/td&gt;
         &lt;/tr&gt;
         &lt;tr&gt;
        
            &lt;td rowspan=\&quot;2\&quot; valign=\&quot;top\&quot; style=\&quot;width:500px; padding:0px 0 0 0;\&quot;&gt;
            	    			 &lt;a href=\&quot;#\&quot;&gt;&lt;img src=\&quot;https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/elogo.png\&quot; alt=\&quot;\&quot; style=\&quot;border:0px;height: 70px;\&quot;&gt;&lt;/a&gt;            &lt;/td&gt;
            &lt;td valign=\&quot;top\&quot; style=\&quot; width:146px;color:#636464; font-family:\&#039;Source Sans Pro\&#039;, sans-serif; font-size:12px; text-align:center; padding:0px 0 19px 0;\&quot;&gt;&lt;/td&gt;
         &lt;/tr&gt;
         &lt;tr&gt;
            &lt;td valign=\&quot;top\&quot;&gt;
            	
            &lt;/td&gt;
         &lt;/tr&gt;
        &lt;/table&gt;
    &lt;/td&gt;
&lt;/tr&gt; 
&lt;tr style=\&quot;background:#fff;\&quot;&gt;
   &lt;td style=\&quot;border-bottom:1px solid #dce4e7;\&quot;&gt;
    &lt;table width=\&quot;646\&quot; border=\&quot;0\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot;&gt;
      &lt;tr&gt;
        &lt;td style=\&quot;color:#686f74; font-family:\&#039;Source Sans Pro\&#039;, sans-serif; font-size:12px; text-align:left; width:220px; height:31px;\&quot;&gt;Wednesday, October 28, 2020&lt;/td&gt;
        &lt;td style=\&quot;color:#686f74; font-family:\&#039;Source Sans Pro\&#039;, sans-serif; font-size:12px; text-align:left; width:180px; height:31px;\&quot;&gt;&lt;img src=\&quot;https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/emails/phone.png\&quot; align=\&quot;\&quot; width=\&quot;12\&quot; height=\&quot;18\&quot; style=\&quot;margin-right: 5px;\&quot;/&gt;+94 (0)11 789 5820&lt;br/&gt;
        &lt;td style=\&quot;color:#686f74; font-family:\&#039;Source Sans Pro\&#039;, sans-serif; font-size:12px; text-align:left; width:auto; height:31px;\&quot;&gt;&lt;img src=\&quot;https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/emails/mail.png\&quot; align=\&quot;\&quot; width=\&quot;20\&quot; height=\&quot;14\&quot; style=\&quot;margin-right: 5px;\&quot; /&gt;&lt;a href=\&quot;mailto:reservations@thefabulousgetaway.com\&quot; style=\&quot;color:#686f74; text-decoration:none;\&quot;&gt;reservations@thefabulousgetaway.com&lt;/a&gt;&lt;/td&gt;
      &lt;/tr&gt;
    &lt;/table&gt;    
    &lt;/td&gt;
&lt;/tr&gt;


&lt;tr&gt;
    &lt;td valign=\&quot;top\&quot; style=\&quot;height:94px; background:#ecf1f2; border-top:1px solid #dce4e7; border-bottom:1px solid #d9dfe0;\&quot;&gt;
	       &lt;table width=\&quot;100%\&quot; border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;&gt;
	    		&lt;tr&gt;
		        	&lt;td valign=\&quot;top\&quot; style=\&quot;height:9px; line-height:9px;\&quot;&gt;&lt;img src=\&quot;https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/emails/Hotelbooking_bg.png\&quot; width=\&quot;700\&quot; height=\&quot;9\&quot; border=\&quot;0\&quot; /&gt;&lt;/td&gt;
		      	&lt;/tr&gt;
		      	&lt;tr&gt;
		        	&lt;td&gt;        
			        	&lt;table width=\&quot;650\&quot; border=\&quot;0\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot;&gt;
				        &lt;tr&gt;
				        	&lt;td colspan=\&quot;2\&quot; style=\&quot;height:16px; line-height:16px;\&quot;&gt;&nbsp;&lt;/td&gt;
				        &lt;/tr&gt;
					    &lt;tr&gt;
					      	&lt;td&gt;
					       	  &lt;p style=\&quot;color:#777879; font-family:Arial, Helvetica, sans-serif;\&quot;&gt;Greetings from The Fabulous Getaway Registration Team,&lt;/p&gt;
					       	&lt;/td&gt;
						&lt;tr&gt;
							&lt;td style=\&quot; font-size:14px; color:#404040; font-family: Tahoma, Geneva, sans-serif;\&quot;&gt;&lt;br&gt;Dear RateGainSriLanka ,&lt;br&gt;&lt;/td&gt;
						&lt;/tr&gt;
						&lt;tr&gt;
							&lt;td style=\&quot;line-height:10px;\&quot;&gt;&nbsp;&lt;/td&gt;
						&lt;/tt&gt;
						&lt;tr&gt;
							&lt;td style=\&quot; font-size:18px; color:#404040; font-family: Tahoma, Geneva, sans-serif; font-weight:bold;\&quot;&gt;As Reference to your Request to change password  !!!!  !!!!&lt;/td&gt;
						&lt;/tr&gt;
  				  		&lt;tr&gt;
  				  			&lt;td&gt;&nbsp;&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 width=\&quot;100%\&quot; border=\&quot;0\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot;&gt;
      &lt;tr&gt;
        &lt;td style=\&quot;padding-left:22px; padding-bottom:10px;font-size:13px; color:#404040; font-family: Tahoma, Geneva, sans-serif;\&quot;&gt;&lt;br&gt;Your password has been changed successfully. You can login using your new password.&lt;/td&gt;
        
      &lt;/tr&gt;
     &lt;/table&gt;    
    &lt;/td&gt;
&lt;/tr&gt;

&lt;tr&gt;
    &lt;td valign=\&quot;top\&quot; style=\&quot;background:#f3f6f7; border-top:1px solid #fff; line-height:0px;\&quot;&gt;
         &lt;table style=\&quot;height:52px;\&quot;&gt;
           	&lt;tr&gt;
          		&lt;td valign=\&quot;top\&quot; align=\&quot;left\&quot; style=\&quot;padding:0 0 0 20px ; color:#4d4d4d;font-family:Arial, Helvetica, sans-serif; font-size:13px;height:60px;\&quot; bgcolor=\&quot;#f3f6f7\&quot;&gt;
				        &lt;br&gt;&lt;a href=\&quot;https://alpha.otrams.thefabulousgetaway.com/\&quot; style=\&quot;color:#385c98; text-decoration:none; font-size:13px; color:#777879;\&quot;&gt;We Welcome your Suggestions to Serve you Better, write back to us on  &lt;a href=\&quot;mailto:\&quot; style=\&quot;color:#385c98;;\&quot;&gt;&lt;/a&gt;					       
           		&lt;/td&gt;
           	&lt;/tr&gt;	
         &lt;/table&gt;
	  			&lt;!--  add your detail here --&gt;
	&lt;/td&gt;
&lt;/tr&gt;
   
&lt;tr&gt;
	&lt;td bgcolor=\&quot;#f3f6f7\&quot;&gt;
		&lt;table width=\&quot;95%\&quot; border=\&quot;0\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot; style=\&quot;margin: 0 auto; background: #f3f6f7; /* border-top: 2px solid #e8eef1; */ padding: 0px\&quot; class=\&quot;table_footer\&quot;&gt;
			&lt;tr&gt;
				&lt;td style=\&quot;height: 19px;\&quot;&gt;&lt;/td&gt;
			&lt;/tr&gt;
			&lt;tr&gt;
				&lt;td style=\&quot;padding: 0 0px; line-height: 18px; color: #4d4d4d; font-family: \&#039;Source Sans Pro\&#039;, sans-serif; font-size: 12px; font-weight: normal;\&quot;&gt;Our Support Team is always ready to assist you. Please contact us on &lt;span style=\&quot;color: #435770;\&quot;&gt; &lt;a href=\&quot;mailto:reservations@thefabulousgetaway.com\&quot; style=\&quot;color: #435770; text-decoration: none;\&quot;&gt;reservations@thefabulousgetaway.com&lt;/a&gt;&lt;/span&gt; for any assistance or feedback.
				&lt;/td&gt;
			&lt;/tr&gt;
				&lt;tr&gt;
				&lt;td style=\&quot;padding: 0 0px; line-height: 18px; color: #4d4d4d; font-family: \&#039;Source Sans Pro\&#039;, sans-serif; font-size: 16px; font-weight: bold; text-align: right;\&quot;&gt;Thanking You&nbsp;&lt;/td&gt;
			&lt;/tr&gt;
			&lt;tr&gt;
				&lt;td style=\&quot;padding: 0 0 20px 0px; line-height: 15px; color: #4d4d4d; font-family: \&#039;Source Sans Pro\&#039;, sans-serif; font-size: 12px; font-weight: normal; text-align: right;\&quot;&gt;Registration & Sales Team&nbsp;&lt;br /&gt;The Fabulous Getaway&nbsp;
				&lt;/td&gt;
			&lt;/tr&gt;
			&lt;tr&gt;
				&lt;td style=\&quot;padding: 0 0 17px 0px;  color: #4d4d4d; font-family: \&#039;Source Sans Pro\&#039;, sans-serif; font-size: 12px; font-weight: normal; text-align: right;\&quot;&gt;&lt;a href=\&quot;https://www.thefabulousgetaway.com\&quot; style=\&quot;color: #435770; text-decoration: none; line-height: 18px; padding-left: 20px;\&quot;&gt;https://www.thefabulousgetaway.com&lt;/a&gt;&nbsp;&lt;/td&gt;
			&lt;/tr&gt;
			
		&lt;/table&gt;
	&lt;/td&gt;
&lt;/tr&gt;
      
&lt;/table&gt;
&lt;/body&gt;
&lt;/html&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-10-28 12:10:51';
[10/28/2020 12:28:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '14.97' , weekend_rate= '14.97'  WHERE 1  AND hotel_id= '53777' AND supplier_id= 'S000000243' AND date_from= '2020-11-01' AND date_to= '2020-11-01' AND room_class= '1048' AND room_basis= '1' AND inventory_class_id= '132';
[10/28/2020 12:28:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53777',supplier_id = 'S000000243',inventory_class_id = '132',room_class = '1048',room_basis = '1',date_from = '2020-11-01',weekday_rate = '14.97',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53777/28_10_2020/request_getHotelARIUpdate_12_28_15_1603888095_53777.xml',create_date = '2020-10-28 12:28:15';
[10/28/2020 12:28:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '14.97' , weekend_rate= '14.97'  WHERE 1  AND hotel_id= '53777' AND supplier_id= 'S000000243' AND date_from= '2020-11-02' AND date_to= '2020-11-02' AND room_class= '1048' AND room_basis= '1' AND inventory_class_id= '132';
[10/28/2020 12:28:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53777',supplier_id = 'S000000243',inventory_class_id = '132',room_class = '1048',room_basis = '1',date_from = '2020-11-02',weekday_rate = '14.97',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53777/28_10_2020/request_getHotelARIUpdate_12_28_15_1603888095_53777.xml',create_date = '2020-10-28 12:28:15';
[10/28/2020 12:28:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '14.97' , weekend_rate= '14.97'  WHERE 1  AND hotel_id= '53777' AND supplier_id= 'S000000243' AND date_from= '2020-11-03' AND date_to= '2020-11-03' AND room_class= '1048' AND room_basis= '1' AND inventory_class_id= '132';
[10/28/2020 12:28:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53777',supplier_id = 'S000000243',inventory_class_id = '132',room_class = '1048',room_basis = '1',date_from = '2020-11-03',weekday_rate = '14.97',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53777/28_10_2020/request_getHotelARIUpdate_12_28_15_1603888095_53777.xml',create_date = '2020-10-28 12:28:15';
[10/28/2020 12:28:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '14.97' , weekend_rate= '14.97'  WHERE 1  AND hotel_id= '53777' AND supplier_id= 'S000000243' AND date_from= '2020-11-04' AND date_to= '2020-11-04' AND room_class= '1048' AND room_basis= '1' AND inventory_class_id= '132';
[10/28/2020 12:28:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53777',supplier_id = 'S000000243',inventory_class_id = '132',room_class = '1048',room_basis = '1',date_from = '2020-11-04',weekday_rate = '14.97',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53777/28_10_2020/request_getHotelARIUpdate_12_28_15_1603888095_53777.xml',create_date = '2020-10-28 12:28:15';
[10/28/2020 12:28:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '14.97' , weekend_rate= '14.97'  WHERE 1  AND hotel_id= '53777' AND supplier_id= 'S000000243' AND date_from= '2020-11-05' AND date_to= '2020-11-05' AND room_class= '1048' AND room_basis= '1' AND inventory_class_id= '132';
[10/28/2020 12:28:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53777',supplier_id = 'S000000243',inventory_class_id = '132',room_class = '1048',room_basis = '1',date_from = '2020-11-05',weekday_rate = '14.97',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53777/28_10_2020/request_getHotelARIUpdate_12_28_15_1603888095_53777.xml',create_date = '2020-10-28 12:28:15';
[10/28/2020 12:28:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-28 12:28:15',channel_manager_name= 'rategain',hotel_id= '53777',room_id= '1',room_class_id= '1048',rate_id= '132',start_date= '2020-11-01';
[10/28/2020 12:28:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for The Heritage by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBUaGUgSGVyaXRhZ2UgPGJyPjxicj5CZWxvdyBhcmUgdGhlIGRldGFpbHM8YnI+PGJyPiA8Yj5TdXBwbGllcjwvYj4gOiBSYXRlR2FpblNyaUxhbmthPGJyPiA8Yj5EYXRlIDwvYj4gOiAyMDIwLTEwLTI4IDEyOjI4OjE1PGJyPiA8Yj5Ib3RlbCA8L2I+IDogVGhlIEhlcml0YWdlPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUzNzc3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDI0Mzxicj4gPGI+RGF0ZXMgPC9iPiA6IDIwMjAtMTEtMDEgLCAyMDIwLTExLTAyICwgMjAyMC0xMS0wMyAsIDIwMjAtMTEtMDQgLCAyMDIwLTExLTA1PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-28 12:28:15';
[10/28/2020 12:28:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for The Heritage by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for The Heritage <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSriLanka<br> <b>Date </b> : 2020-10-28 12:28:15<br> <b>Hotel </b> : The Heritage<br> <b>Hotel Code</b> : 53777<br> <b>Supplier ID </b> : S000000243<br> <b>Dates </b> : 2020-11-01 , 2020-11-02 , 2020-11-03 , 2020-11-04 , 2020-11-05<br>',  email_sent ='yes', create_date ='2020-10-28 12:28:15', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/28/2020 12:38:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_local_supplier.php],update  `psa_users` set  `consultant_acc_id` ='', `lname`='', `fname`='RateGainSriLanka', `email`='snehal.valanju@qtechsoftware.com', `time_zone_offset`='0', `phone`='123', `messenger_type`='', `messenger_id`='', `user_description`='', `connection`='', `pass`='413387ee0965694f1b2626aee564b95e', `modify_by`='tfg', `user_type`='supplier', `allow_book_under_cancellation`='', `allow_cancellation_after_voucher`='', `is_booking_email_received`='', `designation`='', `updated`='2020-10-28 12:38:59', `modify_date`='2020-10-28 12:38:59'  where `site_id`='' and `id` ='RateGainSL' ;
[10/28/2020 12:38:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_local_supplier.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-28 12:38:59',`log_type`= 'User',`sql_query`= 'update  `psa_users` set  `consultant_acc_id` =:accounting_id, `lname`=:last_name, `fname`=:first_name, `email`=:email, `time_zone_offset`=:time_zone_offset, `phone`=:phone, `messenger_type`=:messenger_type, `messenger_id`=:messenger_id, `user_description`=:user_description, `connection`=:connection, `pass`=:pass, `modify_by`=:modify_by, `user_type`=:user_type, `allow_book_under_cancellation`=:allow_book_under_cancellation, `allow_cancellation_after_voucher`=:allow_cancellation_after_voucher, `is_booking_email_received`=:is_booking_email_received, `designation`=:designation, `updated`=:updated, `modify_date`=:modify_date  where `site_id`=:site_id and `id` =:user_id ',`log_description`= 'User RateGainSL updated For  - email=&updated=2020-10-27+12%3A54%3A23&is_booking_email_received=1 changed to - email=snehal.valanju%40qtechsoftware.com&updated=2020-10-28+12%3A38%3A59&modify_by=tfg&modify_date=2020-10-28+12%3A38%3A59&is_booking_email_received=',`ip`= '60.254.5.70';

[10/28/2020 12:39:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-10-28 12:39:26',login_attempt=0 where id = '25';
[10/28/2020 12:39:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PhpTest', user_type = 'A', branch_id = '1', login_datetime = '2020-10-28 12:39:26', ip = '60.254.5.70', action = 'Login' ;
[10/28/2020 12:39:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.5.70' , city = 'colombo' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/28' , departure_date = '2020/10/29' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-10-28 12:39:54' , site_id = '' , country_code = '132' , web_service = '' ;
[10/28/2020 12:39:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/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', '2020-10-28 12:39:59', '', 'db251d9d24354b1d28dd8ca97fe63baf6f7f0c22e10b3f8880c5f9d45d915633', '467');
[10/28/2020 12:39:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=db251d9d24354b1d28dd8ca97fe63baf6f7f0c22e10b3f8880c5f9d45d915633&xml_user_id=25&request_no=0&local_hotel_code=35&#039;,&#039;36&#039;,&#039;60&#039;,&#039;61&#039;,&#039;65&#039;,&#039;77&#039;,&#039;53699&#039;,&#039;53700&#039;,&#039;38&#039;,&#039;39&#039;,&#039;99&#039;,&#039;78&#039;,&#039;51821&#039;,&#039;76&#039;,&#039;51811&#039;,&#039;53701&#039;,&#039;51808&#039;,&#039;53725&#039;,&#039;53733&#039;,&#039;51817&#039;,&#039;53770&#039;,&#039;53777&web_service=no&site_id='
, http_hit_time = '2020-10-28 12:39:57.985'
, 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 = '1.350'
, error_description = ''
, memory_used = '7909904'
WHERE id = '3238';
[10/28/2020 12:39:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=db251d9d24354b1d28dd8ca97fe63baf6f7f0c22e10b3f8880c5f9d45d915633',
  duration = '2.270',
  merge_duration = '0.096',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.71',
  system_load_5_min = '1.98',
  system_load_15_min = '2.73',
  system_memory_usage = '92.36',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '467') + '8043720',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '467';
[10/28/2020 12:40:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1603888828','60.254.5.70');
[10/28/2020 12:40:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1603888851','60.254.5.70');
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings SET  source_type = 'localsystem', reservation_id = '1861', create_date = '2020-10-28 12:40:59', agent_id = '25', parent_agent_id = '25', agent_ref_no = '', nationality = 'Indian', city_id = 'colombo', country_id = '132', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '107', display_currency_code = 'USD', native_room_rate = '100', native_currency_code = 'USD', supplier_profile_id = '1', service_type = 'hotel', service_date = '2020/10/28', check_out_date = '2020/10/29', sub_user_id = '', booking_status = '1', leader_title = '', leader_first_name = '', leader_last_name = '', booking_branch_id = '1', expiration_date = '2020-10-28 00:00:00', 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><B><U>Detailed Cancellation Policy:</U></B> <br/> Cancellation Charges of 107 USD applicable if cancelled after 28 Oct 2020 02:40 hrs.', supplier_cancellation_policy = '', status_date = '2020-10-28 12:40:59',  site_url = 'https://alpha.otrams.thefabulousgetaway.com/';
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date) VALUES ('3051','THE HERITAGE','THE HERITAGE','53777','53777','colombo','LOCAL_SUPPLIER',NOW());
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3051'
        ;
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into bookings_details(booking_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,hotel_id,local_hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('3051','S000000243','1','2','0','-','','','53777','53777','THE HERITAGE','Colombo','123456789','4.0','1','2020/10/28','2020/10/29','','https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/imagenotavailable.jpg');
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_room_detail set  booking_id = '3051', booking_detail_id = '1189', room_type_code = '2~~~132~~~1049~~~1~~~~~~~~~71100~~~0~~~S000000243', room_name = 'double', room_type_description = 'Standard  -Bed & Breakfast : 2 Pax <font color=\'red\'>-D</font>', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";i:107;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:197:\"Supplier Name - localsupplier(RateGainSriLanka - S000000243), Rate - 100 USD, Currency Multiplier (USD-USD) - 1.00000 Supplier Commission-0 #localsystem, VAT Markup=7.000%, VAT Markup On Profit=0 %\";}}', 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;}}}', markup = '0', commission = '0', native_room_rate_total = '100', display_room_rate_total = '107', number_of_rooms = '1';
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', current_status = 'confirmed', comment_contract = '', consultant_id = 'nitinalpha', sales_manager_id = 'otrams', admin_booked = '1', email_id = '', leader_phone = '', agent_currency_multiplier = '1.00000', ip_addr = '60.254.5.70', backoffice_user = 'tfg', customer_id = '', applied_multiplier='1.00000', free_sale='',  applied_markup='7',  agent_markup='7',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='25',  sub_agent_rate='0', agent_rate='107',  applicable_service_tax='0',  supplier_rate='100',  original_source='',  uid='74b29b393e8c63155365d7766dc5dbf5'  where id='3051';
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' ,gtaToken = '' , special_request='' where booking_id ='3051';
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings_details set reservation_pushed = '1', channel_manager = 'rategain',room_type_description='' where booking_id = '3051';
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,supplier_charge,agent_charge,lead_time,create_date)  VALUES('3051','2020-10-28 12:40:00','2020-10-28 12:40:00','100','107','0','2020-10-28 12:40:59');
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('3051','','');
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_status (booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('3051','confirmed','2020-10-28 12:40:59','Booking confirmed . Booked by Back Office tfg on behalf of Agent - Snehal  Valanju(CD0025)','25','60.254.5.70','0','25');
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_search_log(booking_id, details)
        VALUES(3051, 'a:30:{s:3:\"_id\";a:1:{s:4:\"$oid\";s:24:\"5f99669f9398a962946f8e9e\";}s:7:\"hotelId\";s:25:\"53777----------S000000243\";s:4:\"name\";s:12:\"THE HERITAGE\";s:14:\"local_hotel_id\";s:5:\"53777\";s:8:\"address1\";s:7:\"Colombo\";s:8:\"latitude\";s:0:\"\";s:9:\"longitude\";s:0:\"\";s:4:\"city\";s:5:\"71100\";s:8:\"location\";s:0:\"\";s:14:\"prefered_hotel\";s:1:\"0\";s:10:\"mlosSlogan\";s:0:\"\";s:16:\"isMlosApplicable\";s:2:\"no\";s:7:\"country\";s:3:\"132\";s:16:\"rateCurrencyCode\";s:3:\"USD\";s:5:\"phone\";s:9:\"123456789\";s:16:\"shortDescription\";s:24:\"No Description Available\";s:11:\"website_url\";s:0:\"\";s:12:\"thumbNailUrl\";s:99:\"https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/imagenotavailable.jpg\";s:10:\"sourceType\";s:11:\"localsystem\";s:10:\"supplierid\";s:10:\"S000000243\";s:12:\"suppliername\";s:16:\"RateGainSriLanka\";s:14:\"propertyRating\";s:3:\"4.0\";s:15:\"specialCategory\";a:1:{i:0;s:1:\"1\";}s:13:\"HotelProperty\";a:1:{s:11:\"localsystem\";a:1:{i:0;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:33:{s:11:\"ratebreakup\";a:4:{s:6:\"markup\";i:0;s:10:\"commission\";i:0;s:18:\"NativeNightlyRates\";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;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";i:107;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:197:\"Supplier Name - localsupplier(RateGainSriLanka - S000000243), Rate - 100 USD, Currency Multiplier (USD-USD) - 1.00000 Supplier Commission-0 #localsystem, VAT Markup=7.000%, VAT Markup On Profit=0 %\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";N;s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"f8110f45bdda7e3106fe9b8ebcd193cb\";s:16:\"number_of_adults\";s:1:\"2\";s:10:\"view_basis\";s:0:\"\";s:13:\"view_basis_id\";s:1:\"0\";s:9:\"available\";i:1;s:9:\"free_sale\";N;s:7:\"minStay\";s:1:\"1\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"USD\";s:20:\"displayRoomTypeRates\";i:107;s:20:\"sortingRoomTypeRates\";i:107;s:19:\"nativeRoomTypeRates\";i:100;s:12:\"offerApplied\";N;s:7:\"room_id\";s:49:\"2~~~132~~~1049~~~1~~~~~~~~~71100~~~0~~~S000000243\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:49:\"2~~~132~~~1049~~~1~~~~~~~~~71100~~~0~~~S000000243\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000243\";s:12:\"supplierName\";s:16:\"RateGainSriLanka\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:0:\"\";s:13:\"room_category\";s:13:\"Standard Room\";s:9:\"room_type\";s:62:\"Standard  -Bed & Breakfast : 2 Pax <font color=\'red\'>-D</font>\";s:14:\"non_refundable\";s:1:\"0\";s:15:\"class_unique_id\";s:17:\"0_0_53777_5333632\";}}s:9:\"available\";i:1;s:15:\"displayRoomRate\";i:107;s:14:\"nativeRoomRate\";i:100;s:9:\"unique_id\";s:37:\"1_53777----------S000000243_3_0_51014\";s:10:\"supplierId\";s:10:\"S000000243\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"USD\";s:18:\"applied_markup_per\";i:7;s:18:\"applied_multiplier\";s:7:\"1.00000\";s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53777----------S000000243\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:12:\"THE HERITAGE\";s:18:\"supp_hotel_address\";s:7:\"Colombo\";s:10:\"supplierId\";s:10:\"S000000243\";}s:8:\"no_class\";i:0;}}}}s:13:\"total_charges\";i:107;s:17:\"propertyAvailable\";i:1;s:8:\"no_class\";i:0;s:18:\"sort_total_charges\";i:107;s:16:\"hotel_name_ascii\";s:12:\"the heritage\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53777----------S000000243\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:12:\"THE HERITAGE\";s:18:\"supp_hotel_address\";s:7:\"Colombo\";s:10:\"supplierId\";s:10:\"S000000243\";}}');
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/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('3051','2020-10-28 12:40:00','2020-10-28 12:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00','100','107','0','2020-10-28 12:40:59','');
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings_details set reservation_pushed = '1', channel_manager = 'rategain',room_type_description='' where booking_id = '3051';
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings_applicable_offer set  oid= '',  offer_type_code= '',  booking_id= '3051',  room_id= '2~~~132~~~1049~~~1~~~~~~~~~71100~~~0~~~S000000243',  room_name= 'double',  supplier_id= 'S000000243',  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= '2020-10-28 12:40:59' ;
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set confirmation_number='',itenirary_id='3051' where  id ='3051';
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE room_rates SET availability = availability-1,consumed_inventory = consumed_inventory+1 WHERE hotel_id = '53777' and inventory_class_id = '132' and supplier_id = 'S000000243' and date_from = '2020-10-28';
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update supplement_rate set inventory = '0' where supplement_rate_id = '1';
[10/28/2020 12:40:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_configuration set  booking_id = '3051', config_key = 'BOOKING OTP', config_value = 'S9z9UzJi';;
[10/28/2020 12:41:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG103051 /  Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 39620 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-10-28 12:41:00';
[10/28/2020 12:41:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3051','snehal.valanju@qtechsoftware.com');
[10/28/2020 12:41:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3051','snehal.valanju@qtechsoftware.com');
[10/28/2020 12:41:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update posted_bookings set booking_id='3051',status='1' where reservation_id='1861' and booking_id ='0';
[10/28/2020 12:41:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update xmllogs set reservation_id='3051' where agent_logs_id='467' and source_type='localsystem';
[10/28/2020 12:41:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='',  profit_percent='',  gross_profit='',  commission_tax='',  booking_id ='3051',  create_date ='2020-10-28 12:41:00', supplier_tax='';
[10/28/2020 12:41:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set voucher_id='Test123',status_date='2020-10-28 12:41:00',current_status='vouchered',voucher_hashcode='6b7fbd9f2d930a9de6b730e922320dbc398663051',vouchered_by ='' where id='3051';
[10/28/2020 12:41:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],Insert into booking_configuration set booking_id='3051',config_key='VOUCHER_DATE', config_value='2020-10-28 12:41:00',create_date='2020-10-28 12:41:00';
[10/28/2020 12:41:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3051','vouchered','2020-10-28 12:41:00','Voucherd by Back Office tfg on behalf of Agent - Snehal  Valanju(CD0025)','25','60.254.5.70','','','');
[10/28/2020 12:41:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG103051 /  Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 27532 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,nitin@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-10-28 12:41:01';
[10/28/2020 12:41:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3051','snehal.valanju@qtechsoftware.com');
[10/28/2020 12:41:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3051','nitin@qtechsoftware.com');
[10/28/2020 12:46:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_local_supplier.php],update  `psa_users` set  `consultant_acc_id` ='', `lname`='', `fname`='RateGainSriLanka', `email`='snehal.valanju@qtechsoftware.com', `time_zone_offset`='0', `phone`='123', `messenger_type`='', `messenger_id`='', `user_description`='', `connection`='', `pass`='413387ee0965694f1b2626aee564b95e', `modify_by`='tfg', `user_type`='supplier', `allow_book_under_cancellation`='', `allow_cancellation_after_voucher`='', `is_booking_email_received`='', `designation`='', `updated`='2020-10-28 12:46:36', `modify_date`='2020-10-28 12:46:36'  where `site_id`='' and `id` ='RateGainSL' ;
[10/28/2020 12:46:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_local_supplier.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-28 12:46:36',`log_type`= 'User',`sql_query`= 'update  `psa_users` set  `consultant_acc_id` =:accounting_id, `lname`=:last_name, `fname`=:first_name, `email`=:email, `time_zone_offset`=:time_zone_offset, `phone`=:phone, `messenger_type`=:messenger_type, `messenger_id`=:messenger_id, `user_description`=:user_description, `connection`=:connection, `pass`=:pass, `modify_by`=:modify_by, `user_type`=:user_type, `allow_book_under_cancellation`=:allow_book_under_cancellation, `allow_cancellation_after_voucher`=:allow_cancellation_after_voucher, `is_booking_email_received`=:is_booking_email_received, `designation`=:designation, `updated`=:updated, `modify_date`=:modify_date  where `site_id`=:site_id and `id` =:user_id ',`log_description`= 'User RateGainSL updated For  - updated=2020-10-28+12%3A38%3A59&modify_date=2020-10-28+12%3A38%3A59 changed to - updated=2020-10-28+12%3A46%3A36&modify_date=2020-10-28+12%3A46%3A36',`ip`= '60.254.5.70';

[10/28/2020 12:48:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.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', '2020-10-28 12:48:31', '', '', '');
[10/28/2020 12:50:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/customer_category_markup.php],INSERT INTO agent_category_markup_settings SET service_type= 'Hotel',hotel_category_id= '1',agent_category_id= '2',markup= '3',created_by = 'tfg',created_at = '2020-10-28 12:10:51';
[10/28/2020 12:50:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/customer_category_markup.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-28 12:50:51',`log_type`= 'Customer Category Markup Mapping',`sql_query`= 'select count(*) as count from agent_category_markup_settings where service_type = \&#039;Hotel\&#039; and agent_category_id =  \&#039;\&#039; and hotel_category_id= \&#039;1\&#039;1 ',`log_description`= 'A Customer Category Markup Mapping has been done',`ip`= '60.254.5.70';
[10/28/2020 12:51:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.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', '2020-10-28 12:51:23', '', '', '');
[10/28/2020 12:53:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.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', '2020-10-28 12:53:23', '', '', '');
