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