From bf0b5d93e74d8113d655ac16a7f130473d1c91d9 Mon Sep 17 00:00:00 2001
From: Andrew McMillan <andrew@morphoss.com>
Date: Sat, 6 Jun 2009 11:49:03 +1200
Subject: [PATCH] Browse/View/Edit chartofaccount records.

---
 inc/browse/chartofaccounts.php | 50 ++++++++++++++++++++++++++++++++++
 inc/edit/chartofaccount.php    | 61 ++++++++++++++++++++++++++++++++++++++++++
 inc/view/chartofaccount.php    | 46 +++++++++++++++++++++++++++++++
 3 files changed, 157 insertions(+)
 create mode 100644 inc/browse/chartofaccounts.php
 create mode 100644 inc/edit/chartofaccount.php
 create mode 100644 inc/view/chartofaccount.php

diff --git a/inc/browse/chartofaccounts.php b/inc/browse/chartofaccounts.php
new file mode 100644
index 0000000..ca98051
--- /dev/null
+++ b/inc/browse/chartofaccounts.php
@@ -0,0 +1,50 @@
+<?php
+
+require_once('classWidgets.php');
+
+param_to_global('accountgroup', '#^[a-z0-9_-]+$#i'); if (isset($accountgroup) ) $accountgroup = strtoupper($accountgroup);
+
+/**
+* Add some widgets onto the top of the browser
+*/
+$widget = new Widget('accounts');
+$widget->AddField( 'updates', 'char1', "SELECT ' ', '--Show All--' UNION SELECT 'Z', '--No Manual Posting--' UNION SELECT entitytype, description FROM entitytype ORDER BY 1" );
+$widget->ReadWrite();
+$widget->Defaults( array('updates' => ' ' ) );
+$widget->Layout( '<table> <tr> <th>Update to:</th> <td>##updates.select##</td> <td>##Show.submit##</td> </tr></table>' );
+
+$allow_updates = ' ';
+if ( isset($widget->Record->{'updates'}) && preg_match( '#([ACTLPJZ]+)#i', $widget->Record->{'updates'}, $matches) ) $allow_updates = strtoupper($matches[1]);
+
+$page_elements[] = $widget;
+
+
+$browser = new Browser("Chart of Accounts");
+
+if ( !isset($accountgroup) ) $browser->AddColumn( 'accountgroupcode', 'Group', 'left' );
+$browser->AddColumn( 'accountcode', 'Account', 'right', '', "TO_CHAR(accountcode,'FM0009.00')" );
+$browser->AddColumn( 'shortname', 'ShortName' );
+$browser->AddColumn( 'name', 'Name', 'left', '<td class="left" style="width:30em;" title="##alternativecode##">%s</td>', 'chartofaccount.name' );
+$browser->AddHidden( 'alternativecode' );
+$browser->AddColumn( 'updateto', 'Updates' );
+$browser->AddColumn( 'highvolume', 'Volume', 'left', '', "CASE WHEN highvolume THEN 'Yes' ELSE 'No' END" );
+$browser->SetJoins( "chartofaccount LEFT JOIN accountgroup USING ( accountgroupcode )" );
+$rowurl = '/view.php?t=chartofaccount&id=%s';
+$browser->RowFormat( "<tr onclick=\"window.location='$rowurl';\" class=\"r%d\">\n", "</tr>\n", 'accountcode', '#even' );
+$browser->SetOrdering( 'accountcode' );
+
+if ( isset($accountgroup) )   $browser->AndWhere( "accountgroupcode = ".qpg($accountgroup) );
+
+if ( $allow_updates != ' ' ) {
+  if ( $allow_updates != 'Z' )
+    $browser->AndWhere( "updateto ~ '[$allow_updates]'" );
+  else
+    $browser->AndWhere( "updateto IS NULL OR updateto = ''" );
+}
+
+include_once("menus_entityaccount.php");
+
+$rowurl = '/view.php?t=document&id=%s';
+$c->page_title = $browser->Title;
+$browser->DoQuery();
+$page_elements[] = $browser;
diff --git a/inc/edit/chartofaccount.php b/inc/edit/chartofaccount.php
new file mode 100644
index 0000000..06c9dc1
--- /dev/null
+++ b/inc/edit/chartofaccount.php
@@ -0,0 +1,61 @@
+<?php
+
+param_to_global( 'ac', '#^\d+(\.\d{0,2})?$#', 'oldaccountcode', 'ac', 'id' );
+
+// Viewer component for account
+$editor = new Editor("Account", 'chartofaccount');
+$editor->SetLookup("accountgroupcode", "SELECT accountgroupcode, accountgroupcode || ' - ' || name AS description FROM accountgroup ORDER BY sequencecode");
+$editor->SetWhere( "accountcode=$ac");
+
+if ( $editor->IsSubmit() ) {
+  $ac = floatval($_POST['accountcode']);
+  $editor->WhereNewRecord( "accountcode=".floatval($_POST['accountcode']) );
+  $editor->Write();
+  $editor->SetWhere( "accountcode=$ac");
+  $editor->GetRecord();
+}
+else {
+  $editor->GetRecord();
+}
+
+$template = <<<EOTEMPLATE
+##form##
+<table>
+ <tr>
+  <th class="right">Account:</th>
+  <td class="left"><input type="hidden" name="oldaccountcode" value="##accountcode.enc##">##accountcode.input.7##</td>
+ </tr>
+ <tr>
+  <th class="right">Short name:</th>
+  <td class="left">##shortname.input.12##</td>
+ </tr>
+ <tr>
+  <th class="right">Name:</th>
+  <td class="left">##name.input.50##</td>
+ </tr>
+ <tr>
+  <th class="right">Group:</th>
+  <td class="left">##accountgroupcode.select##</td>
+ </tr>
+ <tr>
+  <th class="right">High volume:</th>
+  <td class="left">##highvolume.checkbox##</td>
+ </tr>
+ <tr>
+  <th class="right">Update to:</th>
+  <td class="left">##updateto.input.10##</td>
+ </tr>
+ <tr>
+  <td>&nbsp;</td>
+  <td class="left">##submit##</td>
+ </tr>
+</table>
+</form>
+EOTEMPLATE;
+
+$editor->SetTemplate( $template );
+$editor->SetTitle("Account $ac - " . $editor->Record->{'name'});
+$c->page_title = $editor->Title;
+$page_elements[] = $editor;
+
+include_once("menus_entityaccount.php");
diff --git a/inc/view/chartofaccount.php b/inc/view/chartofaccount.php
new file mode 100644
index 0000000..0432bdb
--- /dev/null
+++ b/inc/view/chartofaccount.php
@@ -0,0 +1,46 @@
+<?php
+
+param_to_global( 'ac', '#^\d+(\.\d{0,2})?$#', 'ac', 'accountcode', 'id' );
+
+// Viewer component for account
+$viewer = new Viewer("Account", 'chartofaccount');
+$viewer->SetWhere( "accountcode=$ac");
+$viewer->GetRecord();
+
+$template = <<<EOTEMPLATE
+<table>
+ <tr>
+  <th class="right">Account:</th>
+  <td class="left">##accountcode.format.%07.2lf##</td>
+ </tr>
+ <tr>
+  <th class="right">Short name:</th>
+  <td class="left">##shortname##</td>
+ </tr>
+ <tr>
+  <th class="right">Name:</th>
+  <td class="left">##name##</td>
+ </tr>
+ <tr>
+  <th class="right">Group:</th>
+  <td class="left"><a href="/view.php?t=accountgroup&id=##accountgroupcode.urlencode##">##accountgroupcode##</a></td>
+ </tr>
+ <tr>
+  <th class="right">High volume:</th>
+  <td class="left">##highvolume##</td>
+ </tr>
+ <tr>
+  <th class="right">Update to:</th>
+  <td class="left">##updateto##</td>
+ </tr>
+</table>
+
+EOTEMPLATE;
+
+$viewer->SetTemplate( $template );
+$viewer->SetTitle("Account $ac - " . $viewer->Record->{'name'});
+$c->page_title = $viewer->Title;
+$page_elements[] = $viewer;
+
+include_once("menus_entityaccount.php");
+
-- 
2.11.4.GIT