query("select * from tour_itinerary_maps where tid='$getrID'");
$fetchmaps=$getmaps -> fetch_assoc();
$decodempdata=json_decode($fetchmaps['mapdata']);
$newData=rerderArray($decodempdata, $post_order, true);
$jsondata= json_encode($newData);
$conn->query("UPDATE tour_itinerary_maps SET mapdata='$jsondata' WHERE oid='$getoID' and tid='$getrID'");
//showroutes($getrID, $getoID);
$getmaps=$conn->query("select * from tour_itinerary_maps where oid='$getoID' and tid='$getrID'");
$fetchmaps=$getmaps -> fetch_assoc();
$decodempdata=json_decode($jsondata);
?>
query("select guide_language from tours where tid='$tid'");
$fetchLang=$checklng -> fetch_assoc();
if(!empty($fetchLang['guide_language']))
{
$langid = $fetchLang['guide_language'].",".$_REQUEST["langid"];
}
else
{
$langid = $_REQUEST["langid"];
}
$conn->query("UPDATE tours SET guide_language='$langid' WHERE tid='$tid'");
$arrayData=array_map('intval', explode(',', $langid));
$array = implode("','",$arrayData);
echo get_guidelanguage_chekboxes('guidelanguage', "passval", $fetchLang['guidelanguage'], $tid, $arrayData, $check=0);
}
if(!empty($_REQUEST['dellang'])) {
$removeData=array();
$tid = $_REQUEST["tourid"];
$checklng=$conn->query("select guide_language from tours where tid='$tid'");
$fetchLang=$checklng -> fetch_assoc();
$removeData[]=$_REQUEST['selectID'];
$updateArray=array();
$selected_language=explode(",",$fetchLang['guide_language']);
foreach($selected_language as $ShowData)
{
if(!in_array( $ShowData, $removeData)){
$updateArray[]=$ShowData;
}
}
$List = implode(', ', $updateArray);
$conn->query("UPDATE tours SET guide_language='$List' WHERE tid='$tid'");
$arrayData=array_map('intval', explode(',', $List));
$array = implode("','",$arrayData);
echo get_guidelanguage_chekboxes('guidelanguage', "passval", $fetchLang['guidelanguage'], $tid, $arrayData, $check=0);
}
if(!empty($_REQUEST['priceboxload'])) {
include('db.php');
$tid=$conn -> real_escape_string($_REQUEST['tourid']?? '');
$crval=$conn -> real_escape_string($_REQUEST['crval']?? '');
$oid=$conn -> real_escape_string($_REQUEST['oid']?? '');
echo showPriceTable($tid,$oid);
}
if(!empty($_REQUEST['UpdatePrice'])) {
include('db.php');
$tid=$conn -> real_escape_string($_REQUEST['tourid']?? '');
$price=$conn -> real_escape_string($_REQUEST['price']?? '');
$member=$conn -> real_escape_string($_REQUEST['member']?? '');
$oid=$conn -> real_escape_string($_REQUEST['oid']?? '');
$memberkey=$conn -> real_escape_string($_REQUEST['memberkey']?? '');
$lastkey=$conn -> real_escape_string($_REQUEST['lastkey']?? '');
$lastprice=$conn -> real_escape_string($_REQUEST['lastprice']?? '');
$mainprice=$conn -> real_escape_string($_REQUEST['oneprice']?? '');
$nextkey=$conn -> real_escape_string($_REQUEST['nextkey']?? '');
$priceQuery=$conn->query("select tourprice,priceoption from tours_price_data where tid='$tid'");
$fetchPrice =$priceQuery -> fetch_assoc();
$groupData = $conn->query("SELECT * FROM group_price_data WHERE tid='$tid'");
if ($groupData && $groupData->num_rows > 0) {
$row_cnt = $groupData->num_rows; // ✅ correct usage
$fetchData = $groupData->fetch_assoc(); // now get the data
$array = json_decode($fetchData['price_meta']);
} else {
$row_cnt = 0;
$array = []; // to avoid foreach() on null later
}
;
$i=1;
$decodepriceopt = [];
if (!empty($fetchPrice['priceoption']) && is_string($fetchPrice['priceoption'])) {
$decodepriceopt = json_decode($fetchPrice['priceoption'], false);
}
$perpeson='';
foreach($decodepriceopt as $priceoption) {
$perpeson= $priceoption->perpeson;
break;
}
if($_REQUEST['recheck']==1){
$i=1;
foreach($array as $updatejson){
$updatPrice=$updatejson->price;
$data[]= array ('perperson' =>$i,'price'=> $fetchPrice['tourprice'], 'key'=> $member);
$i++;
}
$encodJson=json_encode($data);
$sqlopdt = "UPDATE group_price_data SET price_meta='$encodJson' WHERE tid='$tid'"; $conn->query($sqlopdt);
}
else{
$i=1;
if($price){
if(!empty($lastkey)){
$fetchData = $groupData->fetch_assoc();
$getarray = [];
if (!empty($fetchData) && !empty($fetchData['price_meta'])) {
$getarray = json_decode($fetchData['price_meta'], true);
}
foreach($getarray as &$a){
$btkey=$lastkey-1;
$perkey= $a['key'];
if($a['perperson']==$btkey){
$perPrice=$a['price'];
}
if($a['key'] == $memberkey){
$a['price'] = $lastprice;
$a['key'] =$memberkey;
}
if($a['perperson'] == $memberkey){
$a['price'] = $lastprice;
$a['key'] =$memberkey;
}
if($lastkey>$memberkey)
{
if($a['perperson']>=$memberkey && $a['perperson']<$lastkey){
$a['price'] = $lastprice;
$a['key'] =$memberkey;
}
}
if($a['key'] == $lastkey){
$perval=$a['key']-1;
if($lastkey==2 && $memberkey==1 ){
$a['price'] = $lastprice;
$a['key'] =$memberkey;
}
else{
if($lastkey==1 && $a['perperson']<=$memberkey) {
$a['price'] = $mainprice;
$a['key'] =$memberkey;
}
elseif($a['perperson']>=$lastkey && $a['perperson'] <$lastkey ){
//echo $memberkey."-->".$lastkey."-->".$a['perperson'];
$a['price'] = $mainprice;
$a['key'] =$memberkey;
}
else{
if($a['perperson']>=1 && $a['perperson']<=$memberkey){
if($memberkey>$lastkey){
$a['price'] = $perPrice;
$a['key'] =$memberkey;
}
else{
if($perPrice==0){
$perPrice=$mainprice;
}
$a['price'] = $perPrice;
$a['key'] =1;
}
}
else{
$a['price'] = $lastprice;
$a['key'] =$memberkey;
}
}
}
}
}
$encodJson=json_encode($getarray);
}
else{
if($member==$memberkey && $lastprice==''){
$data = [];
foreach($array as $updatejson){
if($i==$member || $i>$member){
$updatPrice=$price;
}
elseif($i<$member){
$updatPrice=$updatejson->price;
}
else{
$updatPrice=$fetchPrice['tourprice'];;
}
if($i>=$member){
$data[]= array ('perperson' =>$i,'price'=> $updatPrice, 'key'=> $member);
}
elseif($i<$member){
$data[]= array ('perperson' =>$i,'price'=> $updatPrice, 'key'=> $updatejson->key);
}
else{
$data[]= array ('perperson' =>$i,'price'=> $updatPrice, 'key'=> $i);
}
$i++;
}
$encodJson=json_encode($data);
}
else{
echo "no";
$valkey=array();
$getarray = json_decode($fetchData['price_meta'], true);
$i=2;
foreach($getarray as &$a){
$valkey[$i]=$a['key'];
$i++;
}
$unsortarray=array_unique($valkey);
$sortarray=array_values(array_filter($unsortarray));
$mergval=array();
$maxmergval=array();
foreach($sortarray as $getArray){
if($getArray!=$memberkey )
{
$mergval[]=$getArray;
}
if($getArray!=$memberkey && $getArray>$memberkey)
{
$maxmergval[]=$getArray;
}
}
$minindex= min($mergval);
$maxindex= min($maxmergval);
foreach($getarray as &$a){
$btkey=$nextkey-1;
if($a['perperson']==$btkey){
$perPrice=$a['price'];
}
if($a['price']==$lastprice){
echo "yes";
$a['price']=$price;
}
// if($nextkey==1)
// {
// if($a['perperson']>=1 && $a['perperson']<$memberkey){
// $a['price'] =$mainprice;
// }
// else
// {
// echo "yes";
// if($a['key']==$memberkey && $a['perperson']<= $minindex ){
// $a['price']=$price;
// }
// }
// }
// else{
// if($a['key'] == $memberkey && !($a['key'] < $memberkey)){
// if($nextkey>$memberkey){
// echo $a['key']."-->".$nextkey."-->" .$memberkey."-->".$a['perperson']."
";
// $a['price'] =$price;
// }
// elseif($nextkey<$memberkey){
// echo $a['key']."-->".$nextkey."-->" .$memberkey."-->".$a['perperson']."
";
// if($a['perperson']>=$nextkey && $a['perperson']<$memberkey){
// $a['price'] =$perPrice;
// }
// else {
// echo "sssno";
// $a['price'] =$price;
// }
// }
// else { //$a['price'] =22222;
// }
// }
// }
}
$encodJson=json_encode($getarray);
}
}
$sqlopdt = "UPDATE group_price_data SET price_meta='$encodJson' WHERE tid='$tid'";
$conn->query($sqlopdt);
// if($row_cnt>0){
// $sqlopdt = "UPDATE group_price_data SET price_meta='$encodJson'
// WHERE tid='$tid'";
// $conn->query($sqlopdt);
// }
}
}
sleep(1);
?>
real_escape_string($_REQUEST['oid']);
$transtranporttype=$conn -> real_escape_string($_REQUEST['transtranporttype']);
$trddecp=$conn -> real_escape_string($_REQUEST['trddecp']);
$transname=$conn -> real_escape_string($_REQUEST['transname']);
$imgId=$conn -> real_escape_string($_REQUEST['imgid']);
$sql = "INSERT INTO operator_transport (oid,transname,transports,description,imgId)
VALUES ('$oid', '$transname', '$transtranporttype','$trddecp', '$imgId')";
$conn->query($sql);
echo guide_transport($oid);
}
if (isset($_REQUEST['Action']) && $_REQUEST['Action'] === 'Updatetrasimage') {
$id=$conn -> real_escape_string($_REQUEST['id']);
$oid=$conn -> real_escape_string($_REQUEST['oid']);
$transtranporttype=$conn -> real_escape_string($_REQUEST['transtranporttype']);
$trddecp=$conn -> real_escape_string($_REQUEST['trddecp']);
$imgId=$conn -> real_escape_string($_REQUEST['imgid']);
$transname=$conn -> real_escape_string($_REQUEST['transname']);
$sqlopdt = "UPDATE operator_transport SET
transname='$transname',
transports='$transtranporttype',
description= '$trddecp',
imgId='$imgId'
WHERE id='$id'";
$conn->query($sqlopdt);
echo guide_transport($oid);
}
if(!empty($_REQUEST['transId'])) {
$tid=$conn -> real_escape_string($_REQUEST['transId']);
$oid=$conn -> real_escape_string($_REQUEST['oid']);
$imgid=$conn -> real_escape_string($_REQUEST['imgid']);
$conn->query("DELETE FROM operator_transport WHERE id='$tid'");
$conn->query("DELETE FROM tour_images WHERE imgid='$imgid'");
?>
real_escape_string($_REQUEST['prid']);
$oid=$conn -> real_escape_string($_REQUEST['oid']);
$conn->query("DELETE FROM operator_guide_profile WHERE id='$prid'");
?>
real_escape_string($_REQUEST['checktrstatus']);
$tid=$conn -> real_escape_string($_REQUEST['tid']);
if($checktrstatus=='no'){
$checktrstatus=0;
}
$conn->query("UPDATE tours SET tourstatus='$checktrstatus' WHERE tid='$tid'");
}
if(!empty($_REQUEST['checktrstatus'])) {
$checktrstatus=$conn -> real_escape_string($_REQUEST['checktrstatus']);
$tid=$conn -> real_escape_string($_REQUEST['tid']);
if($checktrstatus=='no'){
$checktrstatus=0;
}
$conn->query("UPDATE tours SET tourstatus='$checktrstatus' WHERE tid='$tid'");
}
if(!empty($_REQUEST['randid']))
{
?>
0){
$result = $conn->query("SELECT * FROM cartSession LEFT JOIN tour_itinerary ON tour_itinerary.tid=cartSession.tid
LEFT JOIN cartuserifo ON cartuserifo.orderid='$orderid' LEFT JOIN customize_trip ON customize_trip.id=cartSession.tid
LEFT JOIN cartAddon ON cartAddon.orderid='$orderid' WHERE cartSession.orderid='$orderid'");
}
else {
$result = $conn->query("SELECT * FROM cartSession LEFT JOIN tour_itinerary ON tour_itinerary.tid=cartSession.tid
LEFT JOIN cartuserifo ON cartuserifo.orderid='$orderid' LEFT JOIN cartAddon ON cartAddon.orderid='$orderid' WHERE cartSession.orderid='$orderid'");
}
$fetchdata=$result -> fetch_assoc();
$opmsg="New booking has been received:";
$tid=$fetchdata['tid'];
$geimages = $conn->query("SELECT * FROM tour_images WHERE tid='$tid'");
echo "SELECT * FROM tour_images WHERE tid='$tid'";
$fetchimages=$geimages -> fetch_assoc();
$allImages=explode (",", $fetchimages['tourimages']);
$checktour=$fetchdata['checktour'];
$totalpax=$fetchdata['adult']+$fetchdata['othcount'];
$jsondestination=json_decode($fetchdata['destination']);
$metatravllerinfo=json_decode($fetchdata['metatravllerinfo']);
$pickupmsg=$metatravllerinfo->pickupmsg;
$customer_dob=$metatravllerinfo->dob;
$customer_country=$metatravllerinfo->nationality;
$gender=$metatravllerinfo->mngender;
$customer_phone=$metatravllerinfo->travelpcc.$metatravllerinfo->mobileno;
$customer_name=$fetchdata['custfname']." " .$fetchdata['custlname'];
$customer_email=$fetchdata['custemail'];
$metacustinfo=json_decode($fetchdata['metacustinfo']);
$opcurrency=$_REQUEST['opcurrency'];
$metacustinfo=json_decode($fetchdata['metacustinfo']);
$jsonothercat=json_decode($fetchdata['othercat']);
$jsontrasadons=json_decode($fetchdata['trasadons']);
$jsonroomsaddon=json_decode($fetchdata['roomsaddon']);
$jsonothaddons=json_decode($fetchdata['othaddons']);
$jsonotherservicemeta=json_decode($fetchdata['otherservicemeta']);
$passport=$metatravllerinfo->passportno;
$passport_start_date=$metatravllerinfo->issuedate;
$passport_end_date=$metatravllerinfo->expiredate;
if($fetchdata['disprice']>0){
$mainprice=$fetchdata['disprice'];
}
else{
$mainprice=$fetchdata['mainprice'];
}
$fnsybol=$fetchdata['custcrncy'];
$totalAdult=str_replace( ',', '', $mainprice) * $fetchdata['adult'];
$promocode=$fetchdata['promocode'];
$promovalue=$fetchdata['promovalue'];
$discountpromo=$fetchdata['discountpromo'];
$oid=$fetchdata['oid'];
$grandtotal=str_replace( ',', '', $fetchdata['grandtotal']);
$totalprice=str_replace( ',', '', $fetchdata['totalprice']);
$promototal=$totalprice-str_replace(',', '', $discountpromo);
$tcsper= $fetchdata['tcsper'];
$tcsval=str_replace( ',', '', $fetchdata['tcsval']);
$tcstotal=str_replace( ',', '', $fetchdata['tcstotal']);
$country=$fetchdata['country'];
?>
Dear ,
You have received a new booking
#
Itinerary
Itinerary Duration Days
Itinerary Date
Country
Start In
End In
Tour Type
Booking Custom
Itinerary Time
Itinerary Member(s)
Special Request/Pickup Details:
Lead Traveller Details:
Name
Date of Birth
Gender
Email
Phone
Passport
Issue Date
Expiry Date
Country
Traveller Details:
typeoftraveller;?>
First Name Last Name Gender
fname;?>
lastname;?>
gender;?>
passportno)):?>
Passport No Issue Date Expiry Date Nationality
passportno;?>
issuedate;?>
endate;?>
nationality;?>
Payment Details:
Particuler Member(s) Price Total
Particuler Quantity Price Total
Adults
price * $othercat->nopax;
if($othercat->nopax>0){?>
title;?>
nopax;?>
price,2);?>
price * $othercat->nopax,2);?>
nopax;
}
if($initialtrans>0){ ?>
Transport Upgrade
trroomprice * $trasadons->nopax;
if($trasadons->nopax>0){?>
trname;?>
nopax;?>
trroomprice,2);?>
trroomprice * $trasadons->nopax,2);?>
nopax;
}
if($totalroomcnt>0){ ?>
Rooms Upgrade
occuppancy=='Shared'){
$roomprice=$roomsaddon->price;
}
else{
$roomprice=$roomsaddon->privateprice;
}
if($roomsaddon->nopax>0){
$getroomtotal= $roomprice * $roomsaddon->nopax;?>
name;?>
nopax;?>
nopax ,2);?>
nopax;
}
if($totalothcnt>0){?>
Tour Addons
serviceid;
if($othaddons->nopax>0) {
$addonlabel='Adult:';
}
$getothtotal= $othaddons->perguest * $othaddons->nopax;
?>
servicename;?>
query("select * from cartothsercat where serviceid='$serviceid' and baskid='$baskid'");
while($getservicemeta=$queryoth -> fetch_assoc()){
$jsonotherservicemeta=json_decode($getservicemeta['otherservicemeta']);
foreach($jsonotherservicemeta as $servicemeta){
$getservicetotal= $servicemeta->price * $servicemeta->nopax;
if($servicemeta->nopax>0) { ?>
itemname;?>
nopax;?>
price,2);?>
price * $servicemeta->nopax,2) ;?>
Inclusive of Taxes
Total Price
Discount(%)
Paid Amount
Paid Amount
0){
//$conn->query("UPDATE cartSession SET bookedstatus='Confirmed' WHERE orderid= '$orderid'");
$mailmsg="Your booking has been confirmed.";
/* Send Email To Client */
$to = $customer_email;
$subject="Booking Confirmed";
$header = "FROM: Adventure Republiq <".$opemail.">\r\n";
$header .= "Cc:info@adventurerepubliq.com \r\n";
$header .= "MIME-Version: 1.0\r\n";
$header .= "Content-type: text/html\r\n";
$retval = mail ($to,$subject,$message,$header);
}
else{
$conn->query("UPDATE cartSession SET bookedstatus='Canceled' WHERE orderid= '$orderid'");
}
}
if (isset($_REQUEST['Action']) && $_REQUEST['Action'] === 'sendchat') {
$oid=$_REQUEST['oid'];
$opemail=$_REQUEST['opemail'];
$uemail=$_REQUEST['uemail'];
$replymsg=$_REQUEST['replymsg'];
$nowdate=date('d-m-Y h:i:s');
$unixDate=strtotime($nowdate);
$uid=$_REQUEST['uid'];
$sql = "INSERT INTO chatbox (oid,uid,email,msg,unixtime,status,sendertype) VALUES ('$oid', '$uid','$uemail','$replymsg','$unixDate','1','2')";
$conn->query($sql);
sleep(2);
$query=$conn->query("select * from chatbox where oid='$oid' and email='$uemail' ");
while($fetchchat=$query -> fetch_assoc()){
if($fetchchat['sendertype']==1):
$typefrom="User";
else:
$typefrom="You";
endif;
if($fetchchat['sendertype']!=''){
?>
:
query($sql);
}
include('chatbox.php');
}
if (isset($_REQUEST['action']) && $_REQUEST['action'] === 'checkseen') {
$uemail=$_REQUEST['uemail'];
$conn->query("UPDATE chatbox SET status='1' WHERE email= '$uemail'");
}
/* Add Primotions */
if (isset($_REQUEST['Action']) && $_REQUEST['Action'] == 'Promotions') {
$prname=$conn -> real_escape_string($_REQUEST['prname']);
$promstatus=$conn -> real_escape_string($_REQUEST['promstatus']);
$valfrom=$conn -> real_escape_string($_REQUEST['valfrom']);
$valto=$conn -> real_escape_string($_REQUEST['valto']);
$descripition=$conn -> real_escape_string($_REQUEST['descripition']);
$terms=$conn -> real_escape_string($_REQUEST['terms']);
$valuetype=$conn -> real_escape_string($_REQUEST['valuetype']);
$oid=$conn -> real_escape_string($_REQUEST['oid']);
$prmtid=$oid."_".uniqid();
$locdatevalfrom = str_replace('/', '-', $valfrom);
$unixvalform =strtotime($locdatevalfrom);
$locdatevalto = str_replace('/', '-', $valto);
$unixvalto =strtotime($locdatevalto);
$prcode = strtoupper(substr($prname, 0, 5)).$valuetype;
$getData=$conn->query("select * from promotion where prcode='$prcode'");
$checknum= $getData->num_rows;
if($checknum==1){
$result=0;
}
else{
$result=1;
$sql = "INSERT INTO promotion (prname,prcode,prmtid,oid,tid,prstatus,valfrom,valto,unixvalfrom,unixvalto,descripition,terms,valuetype) VALUES ('$prname','$prcode', '$prmtid', '$oid', '', '$promstatus', '$valfrom','$valto','$unixvalform','$unixvalto','$descripition','$terms','$valuetype')";
$conn->query($sql);
}
}
/* Open For Edit Primotions */
if (isset($_REQUEST['action']) && $_REQUEST['action'] === 'editpromotions') {
include('edit_promotions.php');
}
/* Assign Primotions */
if (isset($_REQUEST['action']) && $_REQUEST['action'] === 'viewassign') {
$pid=$conn -> real_escape_string($_REQUEST['id']);
$oid=$conn -> real_escape_string($_REQUEST['oid']);
include('assign_promo.php');
}
/* Update Primotions */
if (isset($_REQUEST['Action']) && $_REQUEST['Action'] == 'update_promotions') {
$id=$conn -> real_escape_string($_REQUEST['id']);
$prname=$conn -> real_escape_string($_REQUEST['prname']);
$promstatus=$conn -> real_escape_string($_REQUEST['promstatus']);
$valfrom=$conn -> real_escape_string($_REQUEST['valfrom']);
$valto=$conn -> real_escape_string($_REQUEST['valto']);
$descripition=$conn -> real_escape_string($_REQUEST['descripition']);
$terms=$conn -> real_escape_string($_REQUEST['terms']);
$valuetype=$conn -> real_escape_string($_REQUEST['valuetype']);
$oid=$conn -> real_escape_string($_REQUEST['oid']);
$checktype=$conn -> real_escape_string($_REQUEST['checktype']);
$aboveprice=$conn -> real_escape_string($_REQUEST['aboveprice']);
$belowprice=$conn -> real_escape_string($_REQUEST['belowprice']);
/* From Promotion in Unix */
$locdatevalfrom = str_replace('/', '-', $valfrom);
$unixvalform =strtotime($locdatevalfrom);
$locdatevalto = str_replace('/', '-', $valto);
$unixvalto =strtotime($locdatevalto);
$prcode = strtoupper(substr($prname, 0, 5)).$valuetype;
$conn->query("UPDATE promotion SET prname='$prname',prcode='$prcode', prstatus= '$promstatus', valfrom='$valfrom', valto='$valto', valuetype='$valuetype'
,unixvalfrom='$unixvalform', unixvalto='$unixvalto', descripition='$descripition',terms='$terms', checktype='$checktype', aboveprice='$aboveprice',belowprice='$belowprice' WHERE id= '$id'");
include('viewpromotions.php');
}
/* Update Primotions */
if (isset($_REQUEST['action']) && $_REQUEST['action'] === 'delpromotion') {
$oid=$conn -> real_escape_string($_REQUEST['oid']);
$id=$conn -> real_escape_string($_REQUEST['id']);
$conn->query("DELETE FROM promotion WHERE id='$id'");
$conn->query("DELETE FROM promotion WHERE id='$id'");
include('viewpromotions.php');
}
/* Assign Primotions */
if (isset($_REQUEST['action']) && $_REQUEST['action'] === 'assinpromo') {
$arrayJson=array();
$array=array();
$arraynew=array();
$oid=$conn -> real_escape_string($_REQUEST['oid']);
$pid=$conn -> real_escape_string($_REQUEST['pid']);
$tid=$conn -> real_escape_string($_REQUEST['sentid']);
$checktid=$conn -> real_escape_string($_REQUEST['checktid']);
$locid=$conn -> real_escape_string($_REQUEST['locid']);
$arrayJson[$tid]['tid'] = $tid;
$encodeJson= json_encode($arrayJson);
$getData=$conn->query("select * from assign_promotions where oid='$oid' and pid='$pid'");
$checknum= $getData->num_rows;
if($checknum==0){
$sql = $conn->query("INSERT INTO assign_promotions (tids,pid,oid) VALUES ('$encodeJson', '$pid','$oid')");
}
else{
$newoldjson=array();
$fetchdata=$getData -> fetch_assoc();
if($fetchdata['tids']=='null'){
$encodeJson= json_encode($arrayJson);
$conn->query("UPDATE assign_promotions SET tids='$encodeJson' WHERE pid= '$pid'");
}
else{
$oldjson=json_decode($fetchdata['tids'], true);
if($checktid==1){
$decodempdata=json_decode($fetchdata['tids'], true);
$arr_index = array();
foreach ($decodempdata as $key => $value) {
if ($key == $locid) {
$arr_index[] = $key;
}
}
foreach ($arr_index as $i) {
unset($decodempdata[$i]);
}
$decodempdata = array_values($decodempdata);
$mergejson= json_encode($decodempdata);
$conn->query("UPDATE assign_promotions SET tids='$mergejson' WHERE pid= '$pid'");
}
else{
$newjson=array_merge($arrayJson,$oldjson);
$combinearray=array_merge($arraynew,$array);
$mergejson=json_encode($newjson);
$conn->query("UPDATE assign_promotions SET tids='$mergejson' WHERE pid= '$pid'");
}
}
}
include('assigned_tour_promotions.php');
}
if (isset($_REQUEST['itnr']) && $_REQUEST['itnr'] === 'yes') {
$duration=$conn -> real_escape_string($_REQUEST['duration']);
$oid=$conn -> real_escape_string($_REQUEST['oid']);
$custId=$conn -> real_escape_string($_REQUEST['custid']);
$query = $conn->query("SELECT * from customize_tour_itinerary where custId='$custId' and oid='$oid'");
$row_cnt = $query->num_rows;
$fetchmeta=$query -> fetch_assoc();
// if($row_cnt>0){
// $decodeItiernary = json_decode($fetchmeta['tourinternary']);
// $totalItienery=count($decodeItiernary);
// if($duration>$totalItienery){
// }
// else{
// }
for($i=1;$i<=$duration; $i++){
?>
real_escape_string($_REQUEST['tourname']);
$duration=$conn -> real_escape_string($_REQUEST['duration']);
$content=$conn -> real_escape_string($_REQUEST['content']);
$custId=$conn -> real_escape_string($_REQUEST['custId']);
$oid=$conn -> real_escape_string($_REQUEST['oid']);
$duration=$conn -> real_escape_string($_REQUEST['duration']);
function create_slug($string){
$slug=preg_replace('/[^A-Za-z0-9-]+/', '-', $string);
return $slug;
}
$query = $conn->query("SELECT * from customize_tour_itinerary where custId='$custId' and oid='$oid'");
$row_cnt = $query->num_rows;
$fetchmeta=$query -> fetch_assoc();
$tourslug=strtolower(create_slug($tourname));
/* Add Json Days Itinerary */
$gettitle=$_REQUEST['gettitle'];
$description=$_REQUEST['getdescription'];
$oldItinerary = $fetchmeta['tourinternary'];
$newItinerary = array();
$countData = count($gettitle);
for ($j = 0; $j < $countData; $j++ ) {
if ( $gettitle[$j] != '' ) :
$newItinerary[$j]['gettitle'] = $gettitle[$j];
$newItinerary[$j]['description'] =$_REQUEST['getdescription'][$j];
endif;
}
$converitjson=$conn -> real_escape_string(json_encode($newItinerary));
if($oldItinerary!=$converitjson){
$jsondata=$converitjson;
}
else{
$jsondata=$oldItinerary;
}
if($row_cnt>0){
$conn->query("UPDATE customize_tour_itinerary SET tourname='$tourname', tourslug='$tourslug',tourduration='$duration',tourdetails='$content', tourinternary='$jsondata' WHERE custId='$custId' and oid='$oid'");
}
else{
$conn->query("INSERT INTO customize_tour_itinerary(custid,oid,tourname,tourslug,tourduration,tourdetails,tourinternary)
VALUES ('$custId','$oid','$tourname','$tourslug','$duration','$content','$jsondata')");
}
}
/* Assign Primotions */
if (isset($_REQUEST['Action']) && $_REQUEST['Action'] === 'add_customize_tour_price') {
$custId=$conn -> real_escape_string($_REQUEST['custId']);
$oid=$conn -> real_escape_string($_REQUEST['oid']);
$tourstart=$conn -> real_escape_string($_REQUEST['tourstart']);
$tourend=$conn -> real_escape_string($_REQUEST['tourend']);
$tourprice=$conn -> real_escape_string($_REQUEST['tourprice']);
$tour_includes=$conn -> real_escape_string($_REQUEST['tour_includes']);
$tour_excludes=$conn -> real_escape_string($_REQUEST['tour_excludes']);
$starttime=$conn -> real_escape_string($_REQUEST['starttime']);
$conn->query("UPDATE customize_tour_itinerary SET tourprice='$tourprice', tourstart='$tourstart',tourend='$tourend'
,tour_includes='$tour_includes', tour_excludes='$tour_excludes', starttime='$starttime' WHERE custId='$custId' and oid='$oid'");
}
/* Assign Primotions */
if (isset($_REQUEST['Action']) && $_REQUEST['Action'] === 'update_addinfo_price') {
$custId=$conn -> real_escape_string($_REQUEST['custId']);
$oid=$conn -> real_escape_string($_REQUEST['oid']);
$covid_info=$conn -> real_escape_string($_REQUEST['covid_info']);
$cancel_policy=$conn -> real_escape_string($_REQUEST['cancel_policy']);
$conn->query("UPDATE customize_tour_itinerary SET cancel_policy='$cancel_policy', covid_info='$covid_info',status='1' WHERE custId='$custId' and oid='$oid'");
}
if (isset($_REQUEST['Action']) && $_REQUEST['Action'] === 'delaction') {
$removeData=array();
$delid=$_REQUEST['imgid'];
$tourid=$_REQUEST['tid'];
$formid=$_REQUEST['formid'];
$selectSql = $conn->query("select * from cust_tour_images where tid = '$delid'");
$getRow = $selectSql -> fetch_assoc();
$updateArray=array();
echo $getRow['tourimages'];
$delfile='/wp-content/themes/adventure-republiq/operator/uploads/'.$_REQUEST['imagname'];
$removeData[]=$_REQUEST['imagname'];
$getimgdata=explode(",",$getRow['tourimages']);
foreach($getimgdata as $ShowData)
{
if(!in_array( $ShowData, $removeData)){
$updateArray[]=$ShowData;
}
}
$List = implode(',',$updateArray);
$conn->query("UPDATE cust_tour_images SET tourimages='$List' WHERE tid= '$delid'");
$get_photos=explode(",",$List);
unlink($delfile);
?>
real_escape_string($_REQUEST['oid']);
$tourstart=$conn -> real_escape_string($_REQUEST['tourstart']);
$tourend=$conn -> real_escape_string($_REQUEST['tourend']);
$tourprice=$conn -> real_escape_string($_REQUEST['tourprice']);
// $conn->query("UPDATE customize_tour_itinerary SET status='1' WHERE custId='$custId' and oid='$oid'");
}
if (isset($_REQUEST['Action']) && $_REQUEST['Action'] === 'update_activity') {
$tid=$conn -> real_escape_string($_REQUEST['tid']);
$getData=$conn->query("select * from tours WHERE tid='$tid'");
$fetchmeta=$getData -> fetch_assoc();
/* Add Json tour activity */
$oldactivity = $fetchmeta['touractivty'];
$newactivity = array();
$activity = $_REQUEST['activity'];
$count = count($activity);
for ($i = 0; $i < $count; $i++ ) {
if ( $activity[$i] != '' ) :
$newactivity[$i]['activity'] = stripslashes($activity[$i]);
endif;
}
$converjson=json_encode($newactivity);
if($oldactivity!=$converjson){
$addjsondata=$converjson;
}
else{
$addjsondata=$oldactivity;
}
$sql = "UPDATE tours SET touractivty='$addjsondata' WHERE tid='$tid'";
$conn->query($sql);
}
if (isset($_REQUEST['Action']) && $_REQUEST['Action'] === 'pdfaction') {
$slug = $_REQUEST['tourslug'] ?? ''; // fallback to empty string if not set
echo "slug";
include('print_brocuher.php');
}
$conn->close();
?>
