function countStats() { $resultData = array(); $today = date('Y-m-d'); $loadData = Post::get(array('query' => "select count(postid)as totalcount from " . Database::getPrefix() . "post")); $resultData['post']['total'] = $loadData[0]['totalcount']; $loadData = Post::get(array('query' => "select count(postid)as totalcount from " . Database::getPrefix() . "post where DATE(date_added)='{$today}'")); $resultData['post']['today'] = $loadData[0]['totalcount']; $loadData = Post::get(array('query' => "select count(postid)as totalcount from " . Database::getPrefix() . "post where status='1'")); $resultData['post']['published'] = $loadData[0]['totalcount']; $loadData = Post::get(array('query' => "select count(postid)as totalcount from " . Database::getPrefix() . "post where status='0'")); $resultData['post']['pending'] = $loadData[0]['totalcount']; $loadData = Comments::get(array('query' => "select count(commentid)as totalcount from " . Database::getPrefix() . "comments")); $resultData['comments']['total'] = $loadData[0]['totalcount']; $loadData = Comments::get(array('query' => "select count(commentid)as totalcount from " . Database::getPrefix() . "comments where DATE(date_added)='{$today}'")); $resultData['comments']['today'] = $loadData[0]['totalcount']; $loadData = Comments::get(array('query' => "select count(commentid)as totalcount from " . Database::getPrefix() . "comments where status='1'")); $resultData['comments']['approved'] = $loadData[0]['totalcount']; $loadData = Comments::get(array('query' => "select count(commentid)as totalcount from " . Database::getPrefix() . "comments where status='0'")); $resultData['comments']['pending'] = $loadData[0]['totalcount']; $loadData = Contactus::get(array('query' => "select count(contactid)as totalcount from " . Database::getPrefix() . "contactus")); $resultData['contactus']['total'] = $loadData[0]['totalcount']; $loadData = Contactus::get(array('query' => "select count(contactid)as totalcount from " . Database::getPrefix() . "contactus where DATE(date_added)='{$today}'")); $resultData['contactus']['today'] = $loadData[0]['totalcount']; $loadData = Users::get(array('query' => "select count(userid)as totalcount from " . Database::getPrefix() . "users")); $resultData['users']['total'] = $loadData[0]['totalcount']; $loadData = Users::get(array('query' => "select count(userid)as totalcount from " . Database::getPrefix() . "users where DATE(date_added)='{$today}'")); $resultData['users']['today'] = $loadData[0]['totalcount']; return $resultData; }
public function view() { if (!($match = Uri::match('\\/view\\/(\\d+)'))) { Redirect::to(ADMINCP_URL . 'contacts/'); } $postid = $match[1]; $post = array('alert' => ''); $loadData = Contactus::get(array('where' => "where contactid='{$postid}'")); $post = $loadData[0]; System::setTitle('View contact - ' . ADMINCP_TITLE); View::make('admincp/head'); self::makeContents('contactView', $post); View::make('admincp/footer'); }
</li> </ul> <!-- Top Menu Items --> <ul class="nav navbar-right top-nav"> <li class="dropdown"> <a href="#" class="dropdown-toggle" data-toggle="dropdown"><i class="fa fa-envelope"></i> <b class="caret"></b></a> <ul class="dropdown-menu message-dropdown"> <?php $today = date('Y-m-d'); $loadData = Contactus::get(array('limitShow' => 5, 'cacheTime' => 30, 'where' => "where DATE(date_added)='{$today}'", 'orderby' => 'order by contactid desc')); if (isset($loadData[0]['contactid'])) { $li = ''; $total = count($loadData); for ($i = 0; $i < $total; $i++) { $li .= ' <li class="message-preview"> <a href="' . $loadData[$i]['url'] . '"> <div class="media"> <div class="media-body"> <h5 class="media-heading"><strong>' . $loadData[$i]['fullname'] . '</strong> </h5> <p class="small text-muted"><i class="fa fa-clock-o"></i> ' . $loadData[$i]['date_addedFormat'] . '</p> <p>' . substr($loadData[$i]['content'], 0, 50) . '...</p> </div>