</div>
<div class="panel-body">
<div class="table-responsive">
<table class="table table-striped table-bordered table-hover">
<thead>
<tr>
<th>#</th>
<th>Ime</th>
<th>Br. telefona</th>
<th>Mesec</th>
<th>Vremenski period</th>
<th>Cena</th>
</tr>
</thead>
<tbody>
<?php
/***************************************************************************************************************************/
$last_ten_debits = ViewDebit::getAll("WHERE debit_status = 1 ORDER BY debit_id DESC LIMIT 10");
foreach ($last_ten_debits as $debit) {
echo "<tr>\n <td>{$debit->card_number}</td>\n <td>{$debit->name} {$debit->surname}</td>\n <td>{$debit->phone}</td>\n <td>{$debit->mounth}</td>\n <td>{$debit->price_name}</td>\n <td>{$debit->price} rsd</td>\n </tr>";
}
/*********************************************************************************************************************************/
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- End Kitchen Sink -->
<?php
$all_view_debits = ViewDebit::getAll("WHERE debit_status=1 ORDER BY debit_id DESC");
//debit_status = 1
$all_view_paid_debits = ViewDebit::getAll("WHERE debit_status=0 ORDER BY debit_id ASC");
//debit_status = 0
$active_debit = ViewDebit::getSum("SUM(price) as all_debits", "WHERE debit_status=1");
$all_paid_debits = ViewDebit::getSum("SUM(price) as all_debits", "WHERE debit_status=0");
$all_d = ViewDebit::getSum("SUM(price) as all_debits");
?>
<div><button onclick="printPage()">Stampaj</button></div>
<h2>Pregled dugovanja </h2>
<div class="row">
<!-- start not paid debits -->
<div class="col-md-3 col-sm-12 col-xs-12">
<div class="panel panel-primary text-center no-boder bg-color-red">
<div class="panel-body">
<i class="fa fa-bar-chart-o fa-5x"></i>
<h3>
<?php
/*****************************************************************************/
foreach ($active_debit as $active_debits) {
echo $active_debits->all_debits . " rsd";
}
/******************************************************************************/
?>
</h3>
</div>
<div class="panel-footer back-footer-red">
Nenaplacena dugovanja
