<td>
<?php
echo number_format($arr_rs['MORE1_FM']);
?>
</td>
<td>
<?php
echo number_format($arr_rs['MORE1_TT']);
?>
</td>
</tr>
<?php
}
$dbrpt->Close_Conn();
?>
</table>
<!--contex-->
<ul id="contextMenu" class="dropdown-menu" role="menu" style="display:none" >
<li><a tabindex="-1" href="#">Action</a></li>
<li><a tabindex="-1" href="#">Another action</a></li>
<li><a tabindex="-1" href="#">Something else here</a></li>
<li class="divider"></li>
<li><a tabindex="-1" href="#">Separated link</a></li>
</ul>
<!--contex-->
<!-- jQuery -->
<script src="../../bower_components/jquery/dist/jquery.min.js"></script>
<div class="panel-footer">
<span class="pull-left">View Details</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<!---->
<!---->
<?php
$dbrg = new Database(DB_HOST_TK, DB_USER_TK, DB_PASS_TK, DB_NAME_TK);
$dbrg->Query("select sg.cat_name as ctname,sg.cat_id as ctid,COUNT(sr.cat_id) as cc\r\n\t\t\t\t\t\t\t\t from z42_sys_report_group as sg \r\n\t\t\t\t\t\t\t\t\tLEFT OUTER JOIN z42_sys_report as sr on sg.cat_id=sr.cat_id \r\n\t\t\t\t\t\t\t\t\twhere sr.cat_id='g5' and sr.active='1' order by sr.id");
$rgname = $dbrg->Fetch_array();
$dbrg->Close_Conn();
?>
<div class="col-lg-3 col-md-6">
<div class="panel panel-success">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-area-chart fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div><?php
echo $rgname['ctname'];
?>
</div>
<div class="huge"><?php
echo $rgname['cc'];
?>
&table=<?php
echo $arrreport['source_table_s'];
?>
" target="new"> <?php
echo $arrreport['report_name'];
?>
<i class="fa fa-check"></i></a>
</li>
<!---->
<?php
}
?>
</ul>
</div>
</div><!--/panel-group-->
<!--/panel body-->
<?php
$dbreport->Close_Conn();
}
?>
</body>
</html>
$objResult = $dbc->Fetch_array();
$strThisMonth = $objResult["CountMonth"];
// Last Month //
$dbc->Query(" SELECT SUM(NUM) AS CountMonth FROM daily WHERE DATE_FORMAT(DATE,'%Y-%m') = '" . date('Y-m', strtotime("-1 month")) . "' ");
$objResult = $dbc->Fetch_array();
$strLastMonth = $objResult["CountMonth"];
// This Year //
$dbc->Query(" SELECT SUM(NUM) AS CountYear FROM daily WHERE DATE_FORMAT(DATE,'%Y') = '" . date('Y') . "' ");
$objResult = $dbc->Fetch_array();
$strThisYear = $objResult["CountYear"];
// Last Year //
$dbc->Query(" SELECT SUM(NUM) AS CountYear FROM daily WHERE DATE_FORMAT(DATE,'%Y') = '" . date('Y', strtotime("-1 year")) . "' ");
$objResult = $dbc->Fetch_array();
$strLastYear = $objResult["CountYear"];
//*** Close MySQL ***//
$dbc->Close_Conn();
?>
<div class="table-responsive ">
<table class="table table-hover" >
<tr class="danger">
<td colspan="2"><div align="center">Statistics</div></td>
</tr>
<tr class="info">
<td >Today</td>
<td ><div align="center"><?php
echo number_format($strToday, 0);
?>
</div></td>
</tr>
<tr class="success">
