client_id; } $ids = implode("','",$rsClients); $ids = "'".$ids."'"; $noOfRows = count(Capsule::select("select d.id from tbldomains d inner join tblclients c on c.id=d.userid where d.userid in (".$ids.") ".$search." ")); if(isset($_REQUEST['page']) && !empty($_REQUEST['page'])){ $page = $_REQUEST['page']; }else{ $page = 1; } if(isset($_REQUEST['filter']) && !empty($_REQUEST['filter'])){ if(empty($_REQUEST['order'])){ $filter = 'asc'; }else{ $filter = $_REQUEST['order']; } } $limit = '10'; $startOfset = ($page-1) * $limit; $domainRows = Capsule::select("select d.id,d.userid,d.domain,d.status,d.expirydate,c.firstname,c.lastname,c.email from tbldomains d inner join tblclients c on c.id=d.userid where d.userid in (".$ids.") ".$search." order by d.expirydate ".$filter." limit ".$startOfset.",".$limit); $totalPage = '0'; if(!empty($noOfRows)){ $totalPage = ceil($noOfRows / 10); } $resellerData = Capsule::table("ResellersCenter_Resellers")->select('id')->where('client_id',$clientId)->first(); $rsId = $resellerData->id; $clientRows = Capsule::select("select c.id,c.firstname,c.lastname,c.email from ResellersCenter_ResellersClients rc inner join tblclients c on c.id=rc.client_id where rc.reseller_id ='".$rsId."' "); $cData = Capsule::table("tblclients")->select('id','firstname','lastname','email')->where('id',$clientId)->first(); $clientRows[] = $cData; ?>

Domains

Search:

select('id')->where('clientid',$domainRow->userid)->where('relid',$domainRow->id)->where('type','1')->first(); ?> 1){ ?>

Customer Name	Domain	Status	Expiry Date	Actions
firstname.' '.$domainRow->lastname; ?> (email; ?>)	domain; ?>	status; ?>	expirydate; ?>	Transfer Domain status=='Active'){ echo "Suspend Domain"; }else{ echo "Unsuspend Domain"; } ?> Update Info Renew Domain DNS Manager
First = 7){ $stPage = $page-7; $enPage = $page+7; if($enPage > $totalPage){ $enPage = $totalPage; $stPage = $totalPage-15; } }else{ $stPage = 1; $enPage = 15; } ?> Last