<?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
