inc/browse/chartofaccounts.php

   1 <?php
   2
   3 require_once('classWidgets.php');
   4
   5 param_to_global('accountgroup', '#^[a-z0-9_-]+$#i'); // if (isset($accountgroup) ) $accountgroup = strtoupper($accountgroup);
   6
   7 print "1\n";
   8 /**
   9 * Add some widgets onto the top of the browser
  10 */
  11 $widget = new Widget('accounts');
  12 $widget->AddField( 'updates', 'char1', "SELECT ' ', '--Show All--' UNION SELECT 'Z', '--No Manual Posting--' UNION SELECT entitytype, description FROM entitytype ORDER BY 1" );
  13 $widget->ReadWrite();
  14 $widget->Defaults( array('updates' => ' ' ) );
  15 $widget->Layout( '<table> <tr> <th>Update to:</th> <td>##updates.select##</td> <td>##Show.submit##</td> </tr></table>' );
  16
  17 $allow_updates = ' ';
  18 if ( isset($widget->Record->{'updates'}) && preg_match( '#([ACTLPJZ]+)#i', $widget->Record->{'updates'}, $matches) ) $allow_updates = strtoupper($matches[1]);
  19
  20 $page_elements[] = $widget;
  21
  22
  23 $browser = new Browser("Chart of Accounts");
  24
  25 if ( !isset($accountgroup) ) $browser->AddColumn( 'accountgroupcode', 'Group', 'left' );
  26 $browser->AddColumn( 'accountcode', 'Account', 'right', '', "TO_CHAR(accountcode,'FM0009.00')" );
  27 $browser->AddColumn( 'shortname', 'ShortName' );
  28 $browser->AddColumn( 'name', 'Name', 'left', '<td class="left" style="width:30em;" title="##alternativecode##">%s</td>', 'chartofaccount.name' );
  29 $browser->AddHidden( 'alternativecode' );
  30 $browser->AddColumn( 'updateto', 'Updates' );
  31 $browser->AddColumn( 'highvolume', 'Volume', 'left', '', "CASE WHEN highvolume THEN 'Yes' ELSE 'No' END" );
  32 $browser->SetJoins( "chartofaccount LEFT JOIN accountgroup USING ( accountgroupcode )" );
  33 $rowurl = '/view.php?t=chartofaccount&id=%s';
  34 $browser->RowFormat( "<tr onclick=\"window.location='$rowurl';\" class=\"r%d\">\n", "</tr>\n", 'accountcode', '#even' );
  35 $browser->SetOrdering( 'accountcode' );
  36
  37 if ( isset($accountgroup) )   $browser->AndWhere( "accountgroupcode = ".qpg($accountgroup) );
  38
  39 if ( $allow_updates != ' ' ) {
  40   if ( $allow_updates != 'Z' )
  41     $browser->AndWhere( "updateto ~ '[$allow_updates]'" );
  42   else
  43     $browser->AndWhere( "updateto IS NULL OR updateto = ''" );
  44 }
  45
  46 include_once("menus_entityaccount.php");
  47
  48 $rowurl = '/view.php?t=document&id=%s';
  49 $c->page_title = $browser->Title();
  50 $browser->DoQuery();
  51 $page_elements[] = $browser;