Initial commit

1 files changed, 274 insertions, 0 deletions

diff --git a/include/home.php b/include/home.php
new file mode 100644
index 0000000..0be5f7e
--- /dev/null
+++ b/include/home.php
@@ -0,0 +1,274 @@
+<?php
+/**
+ * BusinessAdmin: administrative software for small companies
+ * Copyright (C) 2015 Camil Staps (ViviSoft)
+ * 
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ * 
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU General Public License for more details.
+ * 
+ * You should have received a copy of the GNU General Public License
+ * along with this program.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+require_once('index.php');
+require('header.php');
+?>
+
+<div id="wrapper">
+
+    <?php require('nav.php'); ?>
+    
+    <div id="page-wrapper">
+        <div class="row">
+            <div class="col-lg-12">
+                <h1 class="page-header">Welcome</h1>
+            </div>
+            <!-- /.col-lg-12 -->
+        </div>
+        <!-- /.row -->
+        <div class="row">
+            <div class="col-lg-4 col-md-4 col-sm-6">
+                <?php
+                $count = count(BusinessAdmin::getOfferIds($_pdo, array("`accepted` = 0")));
+                ?>
+                <div class="panel panel-<?=($count==0 ? 'primary' : 'yellow')?>">
+                    <div class="panel-heading">
+                        <div class="row">
+                            <div class="col-xs-3">
+                                <i class="fa fa-briefcase fa-5x"></i>
+                            </div>
+                            <div class="col-xs-9 text-right">
+                                <div class="huge"><?=$count?></div>
+                                <!--<div>Unaccepted offers</div>-->
+                            </div>
+                        </div>
+                    </div>
+                    <a href="<?=constants::url_external?>offers">
+                        <div class="panel-footer">
+                            <span class="pull-left">Unaccepted 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-4 col-md-4 col-sm-6">
+                <?php
+                $count = count(BusinessAdmin::getOfferIds($_pdo, array("`accepted`=1", "`start_date` <= CURDATE()", "`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-tasks 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-active-offers">
+                        <div class="panel-footer">
+                            <span class="pull-left">Active 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-4 col-md-4 col-sm-6">
+                <?php
+                $count = count(BusinessAdmin::getOfferIds($_pdo, array("`invoice_date` > '1970-01-01'", "`payment_received` <= '1970-01-01' OR `payment_received` IS NULL")));
+                ?>
+                <div class="panel panel-<?=($count==0 ? 'primary' : 'yellow')?>">
+                    <div class="panel-heading">
+                        <div class="row">
+                            <div class="col-xs-3">
+                                <i class="fa fa-circle-o-notch fa-5x"></i>
+                            </div>
+                            <div class="col-xs-9 text-right">
+                                <div class="huge"><?=$count?></div>
+                                <!--<div>Open invoices</div>-->
+                            </div>
+                        </div>
+                    </div>
+                    <a href="#panel-open-invoices">
+                        <div class="panel-footer">
+                            <span class="pull-left">Open invoices</span>
+                            <span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
+                            <div class="clearfix"></div>
+                        </div>
+                    </a>
+                </div>
+            </div>
+        </div>
+        <!-- /.row -->
+        <div class="row">
+            <div class="col-lg-6 col-md-8">
+                <div class="panel panel-default" id="panel-active-offers">
+                    <div class="panel-heading">
+                        <i class="fa fa-tasks fa-fw"></i> Currently active offers
+                    </div>
+                    <!-- /.panel-heading -->
+                    <div class="panel-body">
+                        <?php
+                        $offers = BusinessAdmin::getOffers($_pdo, array("`accepted`=1", "`start_date` <= CURDATE()", "`end_date` >= CURDATE()", "`invoice_date` IS NULL OR `invoice_date` = '1970-01-01'"));
+                        $list = array();
+                        foreach ($offers as $offer) {
+                            $start = BusinessAdmin::formatDate($offer->getStartDate(), false);
+                            $end = BusinessAdmin::formatDate($offer->getEndDate(), false);
+                            $since = mktime(0,0,0,date("n"),date("j"),date("Y")) - $offer->getStartDate();
+                            $total = $offer->getEndDate() - $offer->getStartDate();
+                            $percentage = ($total == 0) ? 100 : round($since / $total * 100);
+
+                            // We want to sort on percentage (DESC) and secondly end date (ASC) so start date (DESC)
+                            $list[str_pad($percentage, 3, '0', STR_PAD_LEFT) . $offer->getStartDate()] = array(
+                                'start' => $start,
+                                'end' => $end,
+                                'id' => $offer->getId(),
+                                'contactClientName' => $offer->getContact()->getClient()->getName(),
+                                'percentage' => $percentage
+                            );
+                        }
+                        krsort($list, SORT_STRING);
+                        foreach ($list as $item) {
+                            echo "<p>#{$item['id']} to {$item['contactClientName']} ({$item['start']} - {$item['end']})<span class='pull-right text-muted'>{$item['percentage']}% complete</span></p>
+                                <div class='progress progress-striped active'>
+                                    <div class='progress-bar progress-bar-".($item['percentage'] < 60 ? 'info' : ($item['percentage'] < 80 ? 'warning' : 'danger'))."' style='width:{$item['percentage']}%;' aria-valuemax='100' aria-valuemin='0' aria-valuenow='{$item['percentage']}' role='progressbar'></div>
+                                </div>";
+                        }
+                        if (count($list) == 0) {
+                            echo "There are no currently active offers.";
+                        }
+                        ?>
+                    </div>
+                    <!-- /.panel-body -->
+                </div>
+                <!-- /.panel -->
+            </div>
+            <div class="col-lg-6 col-md-4">
+                <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
+                    </div>
+                    <div class="panel-body table-responsive">
+                        <table class="table table-bordered table-striped">
+                            <thead>
+                                <tr>
+                                    <th>#</th>
+                                    <th>Contact</th>
+                                    <th>Invoice sent</th>
+                                </tr>
+                            </thead>
+                            <tbody>
+                                <?php
+                                $offers = BusinessAdmin::getOffers($_pdo, array("`invoice_date` > '1970-01-01'", "`payment_received` <= '1970-01-01' OR `payment_received` IS NULL"));
+                                if (count($offers) == 0) {
+                                    echo "<tr><td colspan='3'>There are no currently open invoices.</td></tr>";
+                                } else {
+                                    foreach ($offers as $offer) {
+                                        echo "<tr>";
+                                        echo "<td>{$offer->getId()}</td>";
+                                        echo "<td>{$offer->getContact()->getClient()->getName()}</td>";
+                                        echo "<td>".BusinessAdmin::formatDate($offer->getInvoiceDate(), false)."</td>";
+                                        echo "</tr>";
+                                    }
+                                }
+                                ?>
+                            </tbody>
+                        </table>
+                    </div>
+                    <!-- /.panel-body -->
+                </div>
+                <!-- /.panel -->
+            </div>
+        </div>
+        <!-- /.row -->
+        <div class="row">
+            <div class="col-lg-12">
+                <div class="panel panel-default" id="panel-timeline">
+                    <div class="panel-heading">
+                        <i class="fa fa-clock-o fa-fw"></i> Timeline
+                    </div>
+                    <!-- /.panel-heading -->
+                    <div class="panel-body">
+                        <ul class="timeline">
+                            <?php
+                            $offers = BusinessAdmin::getOffers($_pdo);
+                            $list = array();
+                            $sort_list = array();
+                            foreach ($offers as $offer) {
+                                $temp = array(
+                                    'id' => $offer->getId(), 
+                                    'contact' => $offer->getContact()->getName(),
+                                    'assignments' => '',
+                                    'assignments_header' => ''
+                                );
+                                foreach ($offer->getAssignments() as $assignment) {
+                                    $temp['assignments'] .= "<b>{$assignment->getTitle()}</b><br/><span class='smaller'>(".constants::invoice_valuta."{$assignment->calculate(assignment::SUBTOTAL)} excl. VAT, ".constants::invoice_valuta."{$assignment->calculate(assignment::TOTAL)} incl. VAT)</span><br/><p>{$assignment->getDescription()}</p>";
+                                    $temp['assignments_header'] .= "<b>{$assignment->getTitle()}</b><br/><span class='smaller'>(".constants::invoice_valuta."{$assignment->calculate(assignment::SUBTOTAL)} excl. VAT, ".constants::invoice_valuta."{$assignment->calculate(assignment::TOTAL)} incl. VAT)</span><br/>";
+                                }
+                                $list[] = array_merge($temp, array('type' => 'start', 'time' => $offer->getStartDate(), 'description' => 'Offer started'));
+                                $sort_list[] = $offer->getStartDate() . $offer->getId() . 0;
+                                $list[] = array_merge($temp, array('type' => 'end', 'time' => $offer->getEndDate(), 'description' => 'Offer ended'));
+                                $sort_list[] = $offer->getEndDate() . $offer->getId() . 1;
+                                if ($offer->getInvoiceDate() > 0) {
+                                    $list[] = array_merge($temp, array('type' => 'invoice', 'time' => $offer->getInvoiceDate(), 'description' => 'Invoice sent'));
+                                    $sort_list[] = $offer->getInvoiceDate() . $offer->getId() . 2;
+                                    if ($offer->getPaymentReceived() > 0) {
+                                        $list[] = array_merge($temp, array('type' => 'payment_received', 'time' => $offer->getPaymentReceived(), 'description' => 'Payment received'));
+                                        $sort_list[] = $offer->getPaymentReceived() . $offer->getId() . 3;
+                                    }
+                                }
+                            }
+                            array_multisort($sort_list, SORT_DESC, $list);
+                            foreach ($list as $item) {
+                                if ($item['time'] > time()) {
+                                    continue;
+                                }
+                                echo "<li" . ($item['type'] != 'start' ? ' class="timeline-inverted"' : '') . ">";
+                                switch ($item['type']) {
+                                    case 'start':             echo "<div class='timeline-badge info' title='{$item['description']}'><i class='fa fa-circle-o-notch'></i></div>"; break;
+                                    case 'end':               echo "<div class='timeline-badge primary' title='{$item['description']}'><i class='fa fa-circle-o'></i></div>"; break;
+                                    case 'invoice':           echo "<div class='timeline-badge warning' title='{$item['description']}'><i class='fa fa-check-circle-o'></i></div>"; break;
+                                    case 'payment_received':  echo "<div class='timeline-badge success' title='{$item['description']}'><i class='fa fa-eur'></i></div>"; break;
+                                }
+                                echo "<div class='timeline-panel'>";
+                                echo "<div class='timeline-heading'><h4 class='timeline-title'>#{$item['id']} to {$item['contact']}: {$item['description']}</h4><p><small class='text-muted'><i class='fa fa-clock-o fa-fw'></i> ".BusinessAdmin::formatDate($item['time'],false,true,true)."</small></p></div>";
+                                switch ($item['type']) {
+                                    case 'start':             echo "<div class='timeline-body'>{$item['assignments']}</div>"; break;
+                                    default:                  echo "<div class='timeline-body'>{$item['assignments_header']}</div>";
+                                }
+                                echo "</div>";
+                                echo "</li>";
+                            }
+                            if (count($list) == 0) {
+                                echo '<li class="timeline-inverted">
+                                        <div class="timeline-badge info"><i class="fa fa-check-circle-o"></i></div>
+                                        <div class="timeline-panel">
+                                            <div class="timeline-heading"><h4 class="timeline-title">Welcome to BusinessAdmin!</div>
+                                            <div class="timeline-body">When you start adding projects, a timeline will appear here.</div>
+                                        </div>
+                                    </li>';
+                            }
+                            ?>
+                        </ul>
+                    </div>
+                    <!-- /.panel-body -->
+                </div>
+                <!-- /.panel -->
+            </div>
+        </div>
+    </div>
+    <!-- /#page-wrapper -->
+
+</div>
+<!-- /#wrapper -->
\ No newline at end of file