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;
?>
Total Tours:
Live Tours:
Inactive Tours:
Total Operator:
Full Access Operator: Inactive Operator:
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');
?>