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>
