Finished offers

1 files changed, 66 insertions, 5 deletions

diff --git a/include/home.php b/include/home.php
index f30c8bc..f47f541 100644
--- a/include/home.php
+++ b/include/home.php
@@ -34,7 +34,7 @@ require('header.php');
         </div>
         <!-- /.row -->
         <div class="row">
-            <div class="col-lg-4 col-md-4 col-sm-6">
+            <div class="col-lg-3 col-md-3 col-sm-6">
                 <?php
                 $count = count(BusinessAdmin::getOfferIds($_pdo, array("`accepted` = 0")));
                 ?>
@@ -59,7 +59,7 @@ require('header.php');
                     </a>
                 </div>
             </div>
-            <div class="col-lg-4 col-md-4 col-sm-6">
+            <div class="col-lg-3 col-md-3 col-sm-6">
                 <?php
                 $count = count(BusinessAdmin::getOfferIds($_pdo, array("`accepted`=1", "`start_date` <= CURDATE()", "`end_date` >= CURDATE()")));
                 ?>
@@ -84,7 +84,32 @@ require('header.php');
                     </a>
                 </div>
             </div>
-            <div class="col-lg-4 col-md-4 col-sm-6">
+            <div class="col-lg-3 col-md-3 col-sm-6">
+                <?php
+                $count = count(BusinessAdmin::getOfferIds($_pdo, array("`accepted`=1", "`end_date` <= CURDATE()", "`invoice_date` IS NULL OR `invoice_date`='1970-01-01'")));
+                ?>
+                <div class="panel panel-<?=($count==0 ? 'primary' : ($count < 3) ? 'green' : ($count < 5 ? 'yellow' : 'red'))?>">
+                    <div class="panel-heading">
+                        <div class="row">
+                            <div class="col-xs-3">
+                                <i class="fa fa-clock-o fa-5x"></i>
+                            </div>
+                            <div class="col-xs-9 text-right">
+                                <div class="huge"><?=$count?></div>
+                                <!--<div>Active offers</div>-->
+                            </div>
+                        </div>
+                    </div>
+                    <a href="#panel-finished-offers">
+                        <div class="panel-footer">
+                            <span class="pull-left" title="Offers that have been finished but for which no invoice has been sent yet">Finished offers</span>
+                            <span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
+                            <div class="clearfix"></div>
+                        </div>
+                    </a>
+                </div>
+            </div>
+            <div class="col-lg-3 col-md-3 col-sm-6">
                 <?php
                 $count = count(BusinessAdmin::getOfferIds($_pdo, array("`invoice_date` > '1970-01-01'", "`invoice_date`<=CURDATE()", "`payment_received` <= '1970-01-01' OR `payment_received` IS NULL")));
                 ?>
@@ -112,7 +137,7 @@ require('header.php');
         </div>
         <!-- /.row -->
         <div class="row">
-            <div class="col-lg-6 col-md-8">
+            <div class="col-lg-4 col-md-6">
                 <div class="panel panel-default" id="panel-active-offers">
                     <div class="panel-heading">
                         <i class="fa fa-tasks fa-fw"></i> Currently active offers
@@ -154,7 +179,43 @@ require('header.php');
                 </div>
                 <!-- /.panel -->
             </div>
-            <div class="col-lg-6 col-md-4">
+            <div class="col-lg-4 col-md-6">
+                <div class="panel panel-default" id="panel-finished-offers">
+                    <div class="panel-heading" title="Offers that have been finished but for which no invoice has been sent yet">
+                        <i class="fa fa-clock-o fa-fw"></i> Finished offers
+                    </div>
+                    <!-- /.panel-heading -->
+                    <div class="panel-body">
+                        <table class="table table-bordered table-striped">
+                            <thead>
+                                <tr>
+                                    <th>#</th>
+                                    <th>Contact</th>
+                                    <th>Offer ended</th>
+                                </tr>
+                            </thead>
+                            <tbody>
+                                <?php
+                                $offers = BusinessAdmin::getOffers($_pdo, array("`accepted`=1", "`end_date` <= CURDATE()", "`invoice_date` IS NULL OR `invoice_date`='1970-01-01'"));
+                                foreach ($offers as $offer) {
+                                    echo "<tr>";
+                                    echo "<td>{$offer->getId()}</td>";
+                                    echo "<td>{$offer->getContact()->getClient()->getName()}</td>";
+                                    echo "<td>".BusinessAdmin::formatDate($offer->getEndDate(), false)."</td>";
+                                    echo "</tr>";
+                                }
+                                if (count($offers) == 0) {
+                                    echo "<tr><td colspan='3'>There are no currently active offers.</td></tr>";
+                                }
+                                ?>
+                            </tbody>
+                        </table>
+                    </div>
+                    <!-- /.panel-body -->
+                </div>
+                <!-- /.panel -->
+            </div>
+            <div class="col-lg-4 col-md-6">
                 <div class="panel panel-default" id="panel-open-invoices">
                     <div class="panel-heading">
                         <i class="fa fa-circle-o-notch fa-fw"></i> Currently open invoices