Creation of next-gen admin.pl, admin.pm, and admin.sql systems.

Admin.pm defines the new controller
admin.pl is the direct view-backing software.

POD is not completed, will be provided shortly.

Full UI templates provided for the Reconciliation, Vendor, Customer, and Employee as well. 
UI/  is being delineated by subdirectories for Admin, Vendor, Customer and Employee, to date.

Minor whitespace cleanup.

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1557 4979c152-3d1c-0410-bac9-87ea11338e46

12 files changed, 476 insertions, 0 deletions

diff --git a/UI/Admin/delete_group.html b/UI/Admin/delete_group.html
new file mode 100644
index 00000000..e69de29b
--- /dev/null
+++ b/UI/Admin/delete_group.html
diff --git a/UI/Admin/delete_user.html b/UI/Admin/delete_user.html
new file mode 100644
index 00000000..e69de29b
--- /dev/null
+++ b/UI/Admin/delete_user.html
diff --git a/UI/Admin/edit_group.html b/UI/Admin/edit_group.html
new file mode 100644
index 00000000..11eb98dc
--- /dev/null
+++ b/UI/Admin/edit_group.html
@@ -0,0 +1,13 @@
+<?lsmb import base.html?>
+
+<?lsmb if user.username ?>
+
+    <center><b>Edit User</b></center>
+
+<?lsmb else ?>
+
+    <center><b>Create User</b></center>
+
+<?lsmb endif ?>
+
+<form name="submit_user" action="/admin.pl?"></form>
\ No newline at end of file
diff --git a/UI/Admin/edit_user.html b/UI/Admin/edit_user.html
new file mode 100644
index 00000000..e69de29b
--- /dev/null
+++ b/UI/Admin/edit_user.html
diff --git a/UI/Admin/login.html b/UI/Admin/login.html
new file mode 100644
index 00000000..cf48b6ec
--- /dev/null
+++ b/UI/Admin/login.html
@@ -0,0 +1,11 @@
+<?lsmb include index.html ?>
+
+<?lsmb block 'main'?>
+
+    <div name="login" id="login">
+        
+        
+        
+    </div>
+
+<?lsmb end ?>
\ No newline at end of file
diff --git a/UI/Admin/main.html b/UI/Admin/main.html
new file mode 100644
index 00000000..56f4b2f8
--- /dev/null
+++ b/UI/Admin/main.html
@@ -0,0 +1,55 @@
+<?lsmb block main?>
+<div class="admin">
+    
+    <!-- first, a list of all active users -->
+    
+    <center>
+        <strong><font size="16"> Administration</font></strong>
+    </center>
+    
+    <?lsmb if message?>
+        <strong><font color="red"><?lsmb message?></font></strong>
+    <?lsmb end?>
+    <form name="userlist" method="POST" action="admin.pl">    
+    <table>
+        <tr>
+            <td></td>
+            <td>User ID</td>
+            <td>Username</td>
+            <td>Active</td>
+            <td>Date Added</td>
+        </tr>
+
+    <?lsmb FOREACH user = users.all ?>
+    
+        <tr>
+            <td></td>
+            <td>
+                <a href="/admin.pl?action=edit_user&amp;user=<?lsmb user.id?>">
+                    <?lsmb user.id?>
+                </a>
+            </td>
+            <td>
+                <?lsmb user.username?>
+            </td>
+            <td>
+                <?lsmb user.active?>
+            </td>
+            <td>
+                <?lsmb user.creation_date?>
+            </td>
+            
+        </tr>    
+    <?lsmb end?>
+    </table>
+    
+    <hr/>
+    <div class="buttons">
+        <button name="method" value="new_user">New User</button>
+        <button name="method" value="new_group">New Group</button>
+        <button name="method" value="delete_user">Delete User</button>
+        <button name="method" value="delete_group">Delete Group</button>
+    </div>    
+    </form>
+</div>
+<?end?>
\ No newline at end of file
diff --git a/UI/Customer/customer.html b/UI/Customer/customer.html
new file mode 100644
index 00000000..fd0933ca
--- /dev/null
+++ b/UI/Customer/customer.html
@@ -0,0 +1,139 @@
+<div class="customer">
+    
+    <font size="17"><?lsmb customer.name?></font>
+    
+<form name="customer" method="POST" action="vendor.pl">
+        <table>
+        
+        <tr>
+            <td><b>Shipping Address</b></td>
+            
+            <td><b>Billing Address (if different)</p></td>
+            
+        </tr>
+        
+        <hr/>
+        
+        <?lsmb FOREACH entry = customer.ordered  ?>
+        <tr>
+            <td>
+                <label for="shipping_<?entry?>"><?entry?>:</label>
+                <input id="shipping_<?entry?>" type="textarea" name="shipping_<?entry?>" value="<? customer.entry ?>">
+            </td>
+            <td>
+                <input type="textarea" name="billing_<? entry ?>" value="<? customer.entry ?>">
+            </td>            
+        </tr>
+        <?lsmb end ?>
+        <tr>
+            <td>
+                <label for="startdate">Starting Date:</label>
+                    <input id="startdate" type="textarea" name="startdate" value="<? customer.startdate ?>">
+            </td>
+            <td>
+                <label for="enddate">End date:</label>
+                    <input id="enddate" type="textarea" name="startdate" value="<? customer.enddate ?>">
+            </td>
+        </tr>
+        <tr>
+            <td>
+                <label for"creditlimit">Credit Limit:</label>
+                <input id="creditlimit" name="creditlimit" type="textarea" value="<?customer.creditlimit?>">
+            </td>
+            <td>
+                <label for="terms">Terms:</label>
+                <input id="terms" name="terms" type="textarea" value="<?customer.terms?>"> days
+            </td>
+            <td>
+                <label for="discount">Discount %:</label>
+                <input id="discount" name="discount" type="textarea" value="<?customer.discount?>">                
+            </td>
+        </tr>
+        <tr>
+            
+            <td>
+                <label for="taxnumber">Tax Number/SSN:</label>
+                <input id="taxnumber" name="taxnumber" type="textarea" value="<?customer.taxnumber?>">                
+            </td>
+            <td>
+                <label for"gifi_accno">Subcontract GFI:</label>
+                <input id="gifi_accno" name="gifi_accno" type="textarea" value="<?customer.gifi_accno?>">
+            </td>
+            <td>
+                <label for"sic_code">SIC Code:</label>
+                <input id="sic_code" name="sic_code" type="textarea" value="<?customer.sic_code?>">
+            </td>
+        </tr>
+        
+        <tr>
+            
+            <td></td>
+            <td>
+                <label for"bic">BIC:</label>
+                <input id="bic" name="bic" type="textarea" value="<?customer.bic?>">
+            </td>
+            <td>
+                <label for="iban">IBAN:</label>
+                <input id="iban" name="iban" type="textarea" value="<?customer.iban?>">
+            </td>
+        </tr>
+        
+        <tr>
+            <td>
+                <label for="notes">Notes:</label><br/>
+                <textarea name="notes" rows="3" cols="40" id="notes">
+                    <?customer.notes?>
+                </textarea>
+            </td>
+        </tr>
+
+        <tr>
+            <hr/>
+            <br/>
+            <td>
+                <button class="submit" type="submit" name="action" value="save" accesskey="S" title="Save [Alt-S]">Save</button>
+                </td>
+            <td>
+                <button class="submit" 
+                        type="submit" 
+                        name="action" 
+                        value="ap_transaction" 
+                        accesskey="A" 
+                        title="AP Transaction [Alt-A]">AP Transaction</button>
+                </td>
+            <td>
+                <button class="submit" 
+                        type="submit" 
+                        name="action" 
+                        value="customer_invoice" 
+                        accesskey="I" 
+                        title="customer Invoice [Alt-I]">customer Invoice</button>
+            </td>
+            <td>
+                <button class="submit" 
+                        type="submit" 
+                        name="action" 
+                        value="purchase_order" 
+                        accesskey="O" 
+                        title="Purchase Order [Alt-O]">Purchase Order</button>
+            </td>
+            <td>
+                <button class="submit" 
+                        type="submit" 
+                        name="action" 
+                        value="rfq" 
+                        accesskey="Q" 
+                        title="RFQ [Alt-Q]">RFQ</button>
+            </td>
+            <td>
+                <button class="submit" 
+                        type="submit" 
+                        name="action" 
+                        value="pricelist" 
+                        accesskey="P" 
+                        title="Pricelist [Alt-P]">Pricelist</button>
+            </td>
+        </tr>        
+    </table>
+    </form>
+</div>
\ No newline at end of file
diff --git a/UI/Reconciliation/approved.html b/UI/Reconciliation/approved.html
new file mode 100644
index 00000000..16afc6cc
--- /dev/null
+++ b/UI/Reconciliation/approved.html
@@ -0,0 +1,28 @@
+<div>
+	<center>
+		Bank statement for <?lsmbaccount?> on <?lsmbdate?> has been approved!
+	</center>
+</div>
+
+<table border=0 style="opacity:50%;">
+	
+	<tr>
+		<td>Clear date</td>
+		<td>Transaction Type</td>
+		<td>Our Balance</td>
+		<td>Their Balance</td>
+		<td>Error Corrections</td>
+		<td>Error Code</td>
+	</tr>
+	
+	<?lsmb FOREACH row = records ?>
+		<tr>
+			<td><?lsmb row.clear_time ?></td>
+			<td><?lsmb row.transaction_type ?> </td>
+			<td><?lsmb row.our_balance ?></td>
+			<td><?lsmb row.their_balance?></td>
+			<td><?lsmb row.corrections  ?></td>
+			<td><?lsmb row.errorcode ?></td>
+		</tr>
+	<?lsmb END ?>
+</table>
\ No newline at end of file
diff --git a/UI/Reconciliation/correct.html b/UI/Reconciliation/correct.html
new file mode 100644
index 00000000..e69de29b
--- /dev/null
+++ b/UI/Reconciliation/correct.html
diff --git a/UI/Reconciliation/corrections.html b/UI/Reconciliation/corrections.html
new file mode 100644
index 00000000..bdf7424a
--- /dev/null
+++ b/UI/Reconciliation/corrections.html
@@ -0,0 +1,39 @@
+<table border=0>
+	<tr>
+		<td>Clear date</td>
+		<td>Transaction Type</td>
+		<td>Our Balance</td>
+		<td>Their Balance</td>
+	</tr>
+	<tr>
+		<td><?lsmb entry.clear_time ?></td>
+		<td><?lsmb entry.transaction_type ?> </td>
+		<td><?lsmb entry.our_balance ?></td>
+		<td><?lsmb entry.their_balance?></td>
+	</tr>
+</table>
+
+<?lsmb IF NOT corrections ?>
+Corrections:
+<table border=0>	
+	<?lsmb FOREACH row = corrections ?>
+	<tr>
+		<td>
+			<div>
+				<span><?lsmbrow.user?> at <?lsmbrow.insert_time?></span>
+				<div>
+					<?lsmbrow.reason?>
+				</div>
+			</div>
+		</td>
+	</tr>
+	<?lsmbEND?>
+	
+</table>
+<?lsmbELSE?>
+
+<div>
+	No corrections found.
+</div>
+
+<?lsmbEND?>
\ No newline at end of file
diff --git a/UI/Reconciliation/report.html b/UI/Reconciliation/report.html
new file mode 100644
index 00000000..cd6c8972
--- /dev/null
+++ b/UI/Reconciliation/report.html
@@ -0,0 +1,52 @@
+<center>Reconciliation Report for [% total.account %] for the month of [%total.month%]</center>
+
+<center>
+	[%IF total.errorcode != 0 %]
+	<div style="color:blue; border-style:solid; border-width:1px; border-color: blue;">
+	[%ELSE%]
+	<div style="color:red; border-style:solid; border-width:1px; border-color: blue;">
+	[%END%]
+		Our Balance: total.our_balance | Bank Balance: total.their_balance
+	</div>
+</center>
+
+<center>Report generated by [% total.user %]</center>
+
+[% if recon.error %]
+<div style="border-color:red; border-width:1px; border-style:solid; margin:3px;" >
+	[% recon.error %]	
+</div>
+[%end%]
+
+<table border=0>
+	
+	<tr>
+		<td>Clear date</td>
+		<td>Transaction Type</td>
+		<td>Our Balance</td>
+		<td>Their Balance</td>
+		<td>Error Corrections</td>
+		<td>Error Code</td>
+	</tr>
+	
+	[% FOREACH row = records %]
+		[%IF row.errorcode != 0 %]
+		<tr style="background-color:red;">
+		[% ELSIF row.id = corrected %]
+		<tr style="background-color:yellow;">		
+		[%ELSE%]
+		<tr>
+		[%END%]
+			<td>[% row.clear_time %]</td>
+			<td>[% row.transaction_type %] </td>
+			<td>[% row.our_balance %]</td>
+			<td>[% row.their_balance%]</td>
+			<td>[% row.corrections  %]</td>
+			[% IF row.errorcode > 0 %]
+			<td>[% row.errorcode %] <a href="/reconciliation.pl?corrections&amp;entry=[%row.entry_id%]">View Corrections</a> </td>		
+			[%ELSE%]
+			<td>0</td>
+			[%END%]
+		</tr>
+	[% END %]
+</table>
\ No newline at end of file
diff --git a/UI/Vendor/vendor.html b/UI/Vendor/vendor.html
new file mode 100644
index 00000000..c5753409
--- /dev/null
+++ b/UI/Vendor/vendor.html
@@ -0,0 +1,139 @@
+<div class="vendor">
+    
+    <font size="17"><?lsmb vendor.name?></font>
+    
+<form name="vendor">
+        <table>
+        
+        <tr>
+            <td><b>Shipping Address</b></td>
+            
+            <td><b>Billing Address (if different)</p></td>
+            
+        </tr>
+        
+        <hr/>
+        
+        <?lsmb FOREACH entry = vendor.ordered  ?>
+        <tr>
+            <td>
+                <label for="shipping_<?entry?>"><?entry?>:</label>
+                <input id="shipping_<?entry?>" type="textarea" name="shipping_<?entry?>" value="<? vendor.entry ?>">
+            </td>
+            <td>
+                <input type="textarea" name="billing_<? entry ?>" value="<? vendor.entry ?>">
+            </td>            
+        </tr>
+        <?lsmb end ?>
+        <tr>
+            <td>
+                <label for="startdate">Starting Date:</label>
+                    <input id="startdate" type="textarea" name="startdate" value="<? vendor.startdate ?>">
+            </td>
+            <td>
+                <label for="enddate">End date:</label>
+                    <input id="enddate" type="textarea" name="startdate" value="<? vendor.enddate ?>">
+            </td>
+        </tr>
+        <tr>
+            <td>
+                <label for"creditlimit">Credit Limit:</label>
+                <input id="creditlimit" name="creditlimit" type="textarea" value="<?vendor.creditlimit?>">
+            </td>
+            <td>
+                <label for="terms">Terms:</label>
+                <input id="terms" name="terms" type="textarea" value="<?vendor.terms?>"> days
+            </td>
+            <td>
+                <label for="discount">Discount %:</label>
+                <input id="discount" name="discount" type="textarea" value="<?vendor.discount?>">                
+            </td>
+        </tr>
+        <tr>
+            
+            <td>
+                <label for="taxnumber">Tax Number/SSN:</label>
+                <input id="taxnumber" name="taxnumber" type="textarea" value="<?vendor.taxnumber?>">                
+            </td>
+            <td>
+                <label for"gifi_accno">Subcontract GFI:</label>
+                <input id="gifi_accno" name="gifi_accno" type="textarea" value="<?vendor.gifi_accno?>">
+            </td>
+            <td>
+                <label for"sic_code">SIC Code:</label>
+                <input id="sic_code" name="sic_code" type="textarea" value="<?vendor.sic_code?>">
+            </td>
+        </tr>
+        
+        <tr>
+            
+            <td></td>
+            <td>
+                <label for"bic">BIC:</label>
+                <input id="bic" name="bic" type="textarea" value="<?vendor.bic?>">
+            </td>
+            <td>
+                <label for="iban">IBAN:</label>
+                <input id="iban" name="iban" type="textarea" value="<?vendor.iban?>">
+            </td>
+        </tr>
+        
+        <tr>
+            <td>
+                <label for="notes">Notes:</label><br/>
+                <textarea name="notes" rows="3" cols="40" id="notes">
+                    <?vendor.notes?>
+                </textarea>
+            </td>
+        </tr>
+
+        <tr>
+            <hr/>
+            <br/>
+            <td>
+                <button class="submit" type="submit" name="action" value="save" accesskey="S" title="Save [Alt-S]">Save</button>
+                </td>
+            <td>
+                <button class="submit" 
+                        type="submit" 
+                        name="action" 
+                        value="ap_transaction" 
+                        accesskey="A" 
+                        title="AP Transaction [Alt-A]">AP Transaction</button>
+                </td>
+            <td>
+                <button class="submit" 
+                        type="submit" 
+                        name="action" 
+                        value="vendor_invoice" 
+                        accesskey="I" 
+                        title="Vendor Invoice [Alt-I]">Vendor Invoice</button>
+            </td>
+            <td>
+                <button class="submit" 
+                        type="submit" 
+                        name="action" 
+                        value="purchase_order" 
+                        accesskey="O" 
+                        title="Purchase Order [Alt-O]">Purchase Order</button>
+            </td>
+            <td>
+                <button class="submit" 
+                        type="submit" 
+                        name="action" 
+                        value="rfq" 
+                        accesskey="Q" 
+                        title="RFQ [Alt-Q]">RFQ</button>
+            </td>
+            <td>
+                <button class="submit" 
+                        type="submit" 
+                        name="action" 
+                        value="pricelist" 
+                        accesskey="P" 
+                        title="Pricelist [Alt-P]">Pricelist</button>
+            </td>
+        </tr>        
+    </table>
+    </form>
+</div>
\ No newline at end of file