From d9db49d45b605343f4e22d9c2ff102fe633f8075 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Thu, 21 Dec 2017 13:34:26 -0500
Subject: [PATCH] Update dbversion and work on invoice.

Working on printable invoices.
Adding new total field to the line items table.
To be used for holding the amount times the qty.
---
 classes/billingSupport.php                    |   2 +-
 index.php                                     |   2 +-
 models/admin/billing/invoices.php             |   4 +-
 ..._V0.0.4.sql => create_database_V0.0.5.sql} |   1 +
 setup/databaseScripts/dbVersions.php          |   1 +
 .../update_database_V0.0.5.sql                |   9 ++
 views/admin/billing/invoiceStore.html         | 144 +++++++++++++-----
 7 files changed, 119 insertions(+), 44 deletions(-)
 rename setup/databaseScripts/{create_database_V0.0.4.sql => create_database_V0.0.5.sql} (99%)
 create mode 100644 setup/databaseScripts/update_database_V0.0.5.sql

diff --git a/classes/billingSupport.php b/classes/billingSupport.php
index 3df6d56..2eb965f 100644
--- a/classes/billingSupport.php
+++ b/classes/billingSupport.php
@@ -457,7 +457,7 @@ class GlmBillingSupport
         // echo '<pre>$invoice: ' . print_r( $invoice, true ) . '</pre>';
         $line_items = $this->getLineItemsForInvoice( $invoice_id );
         // echo '<pre>$line_items: ' . print_r( $line_items, true ) . '</pre>';
-        // echo '<pre>$this->config: ' . print_r( $this->config['settings'], true ) . '</pre>';
+        // echo '<pre>$this->config: ' . print_r( $this->config, true ) . '</pre>';
         $account = $this->getAccountById( $invoice['account'] );
         // echo '<pre>$account: ' . print_r( $account, true ) . '</pre>';
 
diff --git a/index.php b/index.php
index 3546b29..3e0f1b9 100644
--- a/index.php
+++ b/index.php
@@ -38,7 +38,7 @@
  *  version from this plugin.
  */
 define('GLM_MEMBERS_BILLING_PLUGIN_VERSION', '0.0.1');
-define('GLM_MEMBERS_BILLING_PLUGIN_DB_VERSION', '0.0.4');
+define('GLM_MEMBERS_BILLING_PLUGIN_DB_VERSION', '0.0.5');
 
 // This is the minimum version of the GLM Members DB plugin require for this plugin.
 define('GLM_MEMBERS_BILLING_PLUGIN_MIN_MEMBERS_REQUIRED_VERSION', '2.8.0');
diff --git a/models/admin/billing/invoices.php b/models/admin/billing/invoices.php
index e834ea6..0e6903c 100644
--- a/models/admin/billing/invoices.php
+++ b/models/admin/billing/invoices.php
@@ -173,6 +173,7 @@ class GlmMembersAdmin_billing_invoices extends GlmDataInvoices
                                 'name'           => $_REQUEST['line_item_name'][$line_item],
                                 'amount'         => $_REQUEST['line_item_amount'][$line_item],
                                 'quantity'       => $_REQUEST['line_item_qty'][$line_item],
+                                'total'          => (float)$_REQUEST['line_item_qty'][$line_item] * (float)$_REQUEST['line_item_amount'][$line_item],
                             ),
                             array(
                                 '%d',
@@ -180,6 +181,7 @@ class GlmMembersAdmin_billing_invoices extends GlmDataInvoices
                                 '%s',
                                 '%s',
                                 '%d',
+                                '%d'
                             )
                         );
                     }
@@ -257,7 +259,7 @@ class GlmMembersAdmin_billing_invoices extends GlmDataInvoices
             break;
 
         case 'delete':
-            // Need to remove any line items for the invoice alse
+            // Need to remove any line items for the invoice also
             // $invoices = $this->deleteTransactions($this->invoice_id);
 
             if ($invoices) {
diff --git a/setup/databaseScripts/create_database_V0.0.4.sql b/setup/databaseScripts/create_database_V0.0.5.sql
similarity index 99%
rename from setup/databaseScripts/create_database_V0.0.4.sql
rename to setup/databaseScripts/create_database_V0.0.5.sql
index 83b78c2..791c908 100644
--- a/setup/databaseScripts/create_database_V0.0.4.sql
+++ b/setup/databaseScripts/create_database_V0.0.5.sql
@@ -80,6 +80,7 @@ CREATE TABLE {prefix}line_items (
     name TEXT NOT NULL,                                    -- line item name
     amount DECIMAL(8,2) DEFAULT '0.00',                    -- line item amount per item
     quantity INT DEFAULT 1,                                -- quantity
+    total DECIMAL(8,2) DEFAULT '0.00',                     -- line item total
     recurring BOOLEAN DEFAULT '0',                         -- true/false if recurring
     recurrence INT NULL DEFAULT 0,                         -- recurrence type
     PRIMARY KEY (id)
diff --git a/setup/databaseScripts/dbVersions.php b/setup/databaseScripts/dbVersions.php
index 499a3e1..ba4fb64 100644
--- a/setup/databaseScripts/dbVersions.php
+++ b/setup/databaseScripts/dbVersions.php
@@ -18,5 +18,6 @@ $glmMembersBillingDbVersions = array(
     '0.0.2' => array('version' => '0.0.2', 'tables' => 11),
     '0.0.3' => array('version' => '0.0.3', 'tables' => 12),
     '0.0.4' => array('version' => '0.0.4', 'tables' => 12),
+    '0.0.5' => array('version' => '0.0.5', 'tables' => 12),
 );
 
diff --git a/setup/databaseScripts/update_database_V0.0.5.sql b/setup/databaseScripts/update_database_V0.0.5.sql
new file mode 100644
index 0000000..c8b2a66
--- /dev/null
+++ b/setup/databaseScripts/update_database_V0.0.5.sql
@@ -0,0 +1,9 @@
+-- Gaslight Media Billing Database
+-- File Created: 12/21/2017
+-- Database Version: 0.0.5
+--
+-- To permit each query below to be executed separately,
+-- all queries must be separated by a line with four dashes
+
+-- Add fields for line_items total
+ALTER TABLE {prefix}line_items ADD total DECIMAL(8,2) DEFAULT '0.00'                     -- line item total
diff --git a/views/admin/billing/invoiceStore.html b/views/admin/billing/invoiceStore.html
index 4c79a2a..42f19c0 100644
--- a/views/admin/billing/invoiceStore.html
+++ b/views/admin/billing/invoiceStore.html
@@ -2,7 +2,8 @@
     <head>
         <style>
             #container-table {
-                border: solid lightgrey 1px;
+                /* border: solid lightgrey 1px; */
+                font-size: 16px;
             }
             #container-table .line-items {
                 border-collapse: collapse;
@@ -13,42 +14,80 @@
             #container-table .line-items tr td {
                 /* border: solid green 1px; */
             }
+            @media print{
+                @page {
+                    size: A4;
+                    margin: 0.5cm;
+                }
+                .wrap > h2 {
+                    display: none;
+                }
+                .nav-tab-wrapper, #adminmenu, #adminmenuback, #adminmenuwrap,
+                .update-nag, .glm-copyright, #wpfooter
+                {
+                    display: none;
+                }
+                body {
+                    background-color: none;
+                }
+                #glm-admin-content-container {
+                    margin: 0;
+                    border: 0 !important;
+                    background-color: none;
+                }
+                #container-table {
+                    width: 90%;
+                    page-break-after: avoid;
+                    page-break-inside: avoid;
+                }
+                #wpcontent, #wrap {
+                    margin: 0;
+                    page-break-after: avoid;
+                    page-break-inside: avoid;
+                }
+            }
         </style>
     </head>
     <body>
-        <table id="container-table" width="800">
+        <table id="container-table" width="600" cellspacing="0" cellpadding="0">
             <tr>
-                <td>LOGO<!-- Logo --></td>
-                <td width="120">
-                    <table width="100%">
-                        <tr>
-                            <th align="right"> Date: </th>
-                            <td align="right"> {$invoice.transaction_time|date_format:"%D"} </td>
-                        </tr>
-                        <tr>
-                            <th align="right"> Billing #: </th>
-                            <td align="right"> {$invoice.account} </td>
-                        </tr>
-                    </table>
-
+                <td>{if $settings.company_logo}<img src="{$glmPluginMediaUrl}/images/medium/{$settings.company_logo}">{/if}</td>
+                <td width="160">
+                    <h1>INVOICE</h1>
                     <!-- Invoice date/memberbilling# --></td>
             </tr>
             <tr>
-                <td colspan="2">
+                <td>
                     <!-- Billing Invoice Settings -->
-                    {$settings.company_name}<br>
+                    <b>{$settings.company_name}</b></b><br>
                     {if $settings.company_name2}{$settings.company_name2}<br>{/if}
                     {if $settings.company_addr1}{$settings.company_addr1}<br>{/if}
                     {if $settings.company_addr2}{$settings.company_addr2}<br>{/if}
                     {if $settings.company_city}{$settings.company_city} {$settings.company_state}, {$settings.company_zip}<br>{/if}
                     {if $settings.company_phone}{$settings.company_phone}<br>{/if}
                     {if $settings.company_email}{$settings.company_email}<br>{/if}
-                    {if $settings.company_url}{$settings.company_url}<br>{/if}
+                </td>
+                <td width="150" valign="top">
+                    <table width="100%">
+                        <tr>
+                            <th align="right"> Date: </th>
+                            <td align="right"> {$invoice.transaction_time|date_format:"%D"} </td>
+                        </tr>
+                        <tr>
+                            <th align="right"> Account #: </th>
+                            <td align="right"> {$account.id} </td>
+                        </tr>
+                        <tr>
+                            <th align="right"> Invoice #: </th>
+                            <td align="right"> {$invoice.id} </td>
+                        </tr>
+                    </table>
                 </td>
             </tr>
+            <tr><td colspan="2"></td></tr>
             <tr>
                 <td colspan="2">
-                    <strong>Bill To:</strong><br>
+                    <h4>Bill To:</h4>
                     {if $account.billing_name2}{$account.billing_name2}<br>{/if}
                     {if $account.billing_addr1}{$account.billing_addr1}<br>{/if}
                     {if $account.billing_addr2}{$account.billing_addr2}<br>{/if}
@@ -58,74 +97,97 @@
                     <!-- Billing Settings -->
                 </td>
             </tr>
+            <tr><td colspan="2">&nbsp;</td></tr>
             <tr>
                 <td colspan="2">
                     <table class="line-items" width="100%">
                         <thead>
                             <tr>
-                                <th>Date</th>
-                                <th>Description</th>
-                                <th>Qty</th>
-                                <th>Amount</th>
+                                <th align="left">Date</th>
+                                <th align="left">Qty</th>
+                                <th>&nbsp;</th>
+                                <th align="left">Description</th>
+                                <th align="right">Rate</th>
+                                <th align="right">Amount</th>
+                            </tr>
+                            <tr>
+                                <td colspan="6"><hr></td>
                             </tr>
                         </thead>
                         <tbody>
                             {foreach $line_items as $item}
                                 <tr>
-                                    <td align="right" width="80">{$invoice.transaction_time|date_format:"%D"}</td>
-                                    <td align="center">{$item.name}</td>
-                                    <td align="right" width="10">{$item.quantity}</td>
-                                    <td align="right" width="60">{$item.amount}</td>
+                                    <td align="left" width="70">{$invoice.transaction_time|date_format:"%D"}</td>
+                                    <td align="right" width="20">{$item.quantity}</td>
+                                    <td align="right" width="10">&nbsp;</td>
+                                    <td align="left">{$item.name}</td>
+                                    <td align="right" width="60">${$item.amount|string_format:"%.2f"}</td>
+                                    <td align="right" width="60">${$item.total|string_format:"%.2f"}</td>
                                 </tr>
                             {/foreach}
+                            <tr><td colspan="6"><hr></td></tr>
+                            <tr>
+                                <td colspan="5" align="right">Total Amount</td>
+                                <td width="70" align="right">${$invoice.balance|string_format:"%.2f"}</td>
+                            </tr>
                         </tbody>
                     </table>
                 </td>
             </tr>
+            <tr><td colspan="2">&nbsp;</td></tr>
             <tr>
-                <td colspan="2">
-                    Payment Terms: blah blah blah
-                </td>
+                <th colspan="2" align="left">
+                    Payment Terms:
+                </th>
             </tr>
+            <tr><td colspan="2"><hr></td></tr>
             <tr>
-                <td colspan="2" align="center">Please return Coupon Below with Payment</td>
+                <td colspan="2">
+                    Membership dues need to be paid by October 1st.
+                </td>
             </tr>
+            <tr><td colspan="2">&nbsp;</td></tr>
             <tr>
-                <td colspan="2"><hr></td>
+                <td colspan="2" align="center" style="font-size: 12px;">Please return Coupon Below with Payment</td>
             </tr>
+            <tr><td colspan="2"><hr></td></tr>
             <tr>
                 <td colspan="2">
                     <table width="100%">
                         <tr>
                             <td>
+                                <span style="color:red">Make checks payable to:</span><br>
                     {$settings.company_name}<br>
                     {if $settings.company_name2}{$settings.company_name2}<br>{/if}
-                    {if $settings.company_addr1}{$settings.company_addr1}<br>{/if}
-                    {if $settings.company_addr2}{$settings.company_addr2}<br>{/if}
+                    {if $settings.company_addr1}{$settings.company_addr1},{/if}
+                    {if $settings.company_addr2}{$settings.company_addr2},{/if}
                     {if $settings.company_city}{$settings.company_city} {$settings.company_state}, {$settings.company_zip}<br>{/if}
-                    {if $settings.company_phone}{$settings.company_phone}<br>{/if}
+                    {if $settings.company_phone}{$settings.company_phone} -{/if}
                     {if $settings.company_email}{$settings.company_email}<br>{/if}
-                    {if $settings.company_url}{$settings.company_url}<br>{/if}
-                    <br>
+                    <br><br>
                     {if $account.billing_name2}{$account.billing_name2}<br>{/if}
                     {if $account.billing_addr1}{$account.billing_addr1}<br>{/if}
                     {if $account.billing_addr2}{$account.billing_addr2}<br>{/if}
                     {if $account.billing_city}{$account.billing_city} {$account.billing_state}, {$account.billing_zip}<br>{/if}
                     {if $account.billing_phone}{$account.billing_phone}<br>{/if}
                             </td>
-                            <td width="200" valign="top">
+                            <td width="220" valign="top">
                                 <table>
                                     <tr>
                                         <th align="right">Please Pay:</th>
-                                        <td align="right">{$invoice.balance}</td>
+                                        <td align="right">${$invoice.balance|string_format:"%.2f"}</td>
                                     </tr>
                                     <tr>
                                         <th align="right">Payment Amount:</th>
                                         <td align="right"><input type="text" size="5"></td>
                                     </tr>
                                     <tr>
-                                        <th align="right"> Billing #: </th>
-                                        <td align="right"> {$invoice.account} </td>
+                                        <th align="right"> Account #: </th>
+                                        <td align="right"> {$account.id} </td>
+                                    </tr>
+                                    <tr>
+                                        <th align="right"> Invoice #: </th>
+                                        <td align="right"> {$invoice.id} </td>
                                     </tr>
                                 </table>
                             </td>
-- 
2.17.1