query("Update tours set tourstatus= '$status', tabstatus='$tabstatus' where tid='$stidch'"); } if(empty($opuserid)) { $myquery="SELECT tours.tid,tours.oid, ,tours.tabstatus,tours.tourname, tours.duration, tours.tourslug,tours.tourtype,tours.tourstatus, tours_price_data.tourprice as price FROM tours, tours_price_data where tours.tid= tours_price_data.tid and tours.oid= tours_price_data.oid order by tours.tid DESC "; } else { if($opuserid!='All'){ $myquery="SELECT tours.tid,tours.oid, tours.tabstatus, tours.tourname,tours.duration, tours.tourslug,tours.tourtype,tours.tourstatus, tours_price_data.tourprice as price FROM tours, tours_price_data where tours.oid= '$opuserid' and tours.tid= tours_price_data.tid order by tours.tid DESC "; } else { $myquery="SELECT tours.tid,tours.oid,tours.tabstatus, tours.tourname, tours.duration, tours.tourslug,tours.tourtype,tours.tourstatus, tours_price_data.tourprice as price FROM tours, tours_price_data where tours.tid= tours_price_data.tid and tours.oid= tours_price_data.oid order by tours.tid DESC "; } } $tourQuery=$conn->query($myquery); $numrows= $tourQuery->num_rows; $like='a:1:{s:8:"operator";b:1;}'; $totalop=array(); $oprinactive=array(); $opactive=array(); $getopertuery=$conn->query("SELECT wpwr_users.ID as userid, wpwr_users.user_nicename as fname FROM wpwr_users JOIN wpwr_usermeta ON wpwr_usermeta.user_id = wpwr_users.ID WHERE meta_value ='$like'"); while($fetchopid= $getopertuery -> fetch_assoc()){ $totalop[]=$fetchopid['userid']; $fullaccess=get_user_meta($fetchopid['userid'],'fullaccess', true); if($fullaccess==0){ //echo $fetchopid['userid']."-->".$fetchopid['fname']."-->".$fullaccess."
"; $oprinactive[]=$fetchopid['userid']; } else{ $opactive[]=$fetchopid['userid']; } } $numoperator=count($totalop); $countInq=$conn->query("select * from enquiryform where oid='$opuserid' and status='0'"); $totalEnq= $countInq->num_rows; if($totalEnq>0): $unread= ''.$totalEnq.' New Enquiry'.''; endif; $countRews=$conn->query("select * from reviews where oid='$opuserid' and approve='1'"); $totalRvs= $countRews->num_rows; if($totalRvs>0): $unreadrws= ''.$totalRvs.' New Reviews'.''; endif; /* Count of Active Tours of */ $activeQuery=$conn->query("SELECT * from tours where tourstatus='1' order by id"); $totalActive= $activeQuery->num_rows; /* Count of inActive Tours of */ $inActiveQuery=$conn->query("SELECT * from tours where tourstatus='0' order by id"); $totalinActive= $inActiveQuery->num_rows; /* Count of all Tours from webscraptours */ $scrapToursQuery=$conn->query("SELECT * from webscraptours"); $totalScrapTours= $scrapToursQuery->num_rows; ?>
query("select * from operator_reservation where oid='$opuserid'"); $fetchtab=$tabQuery -> fetch_assoc(); $checkTours=$conn->query("select * from tours where oid='$opuserid'"); $countmintours= $checkTours->num_rows; $mailsent= get_user_meta($opuserid, 'mailsent', 'true'); ?>
  • Currency :
  • Commission : %
0):?>
Operator Profile
Reviews
My Bookings
My Enquiries
Operator Info
style="opacity: 0.5;" > Add Tours =3) { ?>
=3){?> href="https://dashboard.adventurerepubliq.com/upload-documents/" href="javascript:void(0)/" style="opacity: 0.5;" > Upload Documents & Download Contract
0 Tours fetch_assoc()){ $access= get_user_meta($tourShow['oid'], 'fullaccess', 'true'); $cust_currency= get_user_meta($tourShow['oid'], 'cust_currency', 'true'); $tid=$tourShow['tid']; $tourtype=$tourShow['tourtype']; $operator = get_user_by( 'id', $tourShow['oid'] )->display_name ; if($tourShow['tourname']=='') { $tourname=''; } else { $tourname=$tourShow['tourname']; } if($tourShow['tourtype']=='1'){ $drtype="Days"; } else{ $drtype="HH/MM"; } if($tourShow['tourstatus']==0) { $changeStatus=1; } else { $changeStatus=0; } ?> '; foreach ($items as $item) { if (is_array($item) || is_object($item)) $item = json_encode($item); if ($item === '' || $item === null) continue; $html .= '
  • ' . nl2br(htmlspecialchars((string)$item)) . '
    • '; } $html .= ''; return $html; } } if (!function_exists('render_scrapper_itinerary')) { function render_scrapper_itinerary($value) { if ($value === null || $value === '') return '-'; $items = $value; if (is_string($items)) { $trim = trim($items); $u = @unserialize($trim); if ($u !== false || $trim === 'b:0;') { $items = $u; } else { $d = json_decode($trim, true); if ($d !== null) { $items = $d; } else { return nl2br(htmlspecialchars($trim)); } } } if (!is_array($items)) return nl2br(htmlspecialchars((string)$items)); $html = ''; $idx = 1; foreach ($items as $it) { if (is_object($it)) $it = (array)$it; if (is_array($it)) { $title = $it['title'] ?? $it['day_title'] ?? $it['dayTitle'] ?? $it['heading'] ?? $it['name'] ?? ('Day ' . $idx); $desc = $it['description'] ?? $it['desc'] ?? $it['content'] ?? $it['details'] ?? ''; if (is_array($desc) || is_object($desc)) $desc = json_encode($desc); $html .= '
    ' . htmlspecialchars((string)$title) . ''; if ($desc !== '' && $desc !== null) { $html .= '
    ' . nl2br(htmlspecialchars((string)$desc)) . '
    '; } $html .= '
    '; } else { $html .= '
    Day ' . $idx . ': ' . nl2br(htmlspecialchars((string)$it)) . '
    '; } $idx++; } return $html !== '' ? $html : '-'; } } $scraperQuery=$conn->query("select * from webscraptours where oid='$opuserid' and tranfertour='0'"); while($scrapperTour=$scraperQuery -> fetch_assoc()){ $skipFields = ['tranfertour', 'destination', 'currency', 'termid']; ob_start(); ?>
    Sr No ID Name Operator Name Price Full Access Tour Type Status Update
    No Data
    Duration: View | | Edit Download Contract
    		Yes No Multi Day Day Not Live Live Update Status
    $sVal) { $lk = strtolower($sKey); if (in_array($lk, $skipFields, true)) continue; $isImageField = (bool)preg_match('/(image|img|photo|thumb|picture)/i', $lk); if (!$isImageField) { if (preg_match('/url|link/i', $lk)) continue; if (is_string($sVal) && preg_match('#^https?://#i', trim($sVal))) continue; } $displayKey = $sKey; $displayValue = null; if ($lk === 'decodedestination') { $displayKey = 'Destination'; $displayValue = ($sVal === '' || $sVal === null) ? '-' : nl2br(htmlspecialchars((string)$sVal)); } elseif ($lk === 'tourtype') { $displayKey = 'Tour Type'; $displayValue = ($sVal == '1') ? 'Multi Day Tours' : 'Day Tour'; } elseif ($lk === 'price' || $lk === 'tourprice') { $displayKey = 'Price'; $cur = isset($scrapperTour['currency']) ? $scrapperTour['currency'] : ''; $displayValue = htmlspecialchars(trim($cur . ' ' . $sVal)); } elseif (in_array($lk, ['highlights', 'languages', 'include', 'inclusions', 'exclude', 'exclusions'], true)) { $displayValue = render_scrapper_list($sVal); } elseif ($lk === 'itinerary' || $lk === 'itineraries') { $displayValue = render_scrapper_itinerary($sVal); } elseif ($isImageField) { if (!empty($sVal)) { $displayValue = ''; } } else { $displayValue = ($sVal === '' || $sVal === null) ? '-' : nl2br(htmlspecialchars((string)$sVal)); } if ($displayValue === null) continue; ?>
    - *
    Duration: View
    - Not Live