inc/browse/bankaccounts.php

   1 <?php
   2 include_once("classWidgets.php");
   3
   4 /**
   5 * Add some widgets onto the top of the browser
   6 */
   7 $widget = new Widget();
   8 $widget->AddField( 'active', 'log1' );
   9 $widget->ReadWrite();
  10 $widget->Defaults( array('active' => 't' ) );
  11 $widget->Layout( '<table> <tr> <th>Status:</th> <td>##active.checkbox##</td> <td>##Show.submit##</td> </tr></table>' );
  12 $page_elements[] = $widget;
  13
  14 $show_active = ($widget->Record->{'active'} == 't');
  15
  16 $browser = new Browser("Browse Bank Accounts");
  17
  18 $browser->AddColumn( 'bankaccountcode', 'Bank' );
  19 $browser->AddColumn( 'accountname', 'Account Name' );
  20 $browser->AddColumn( 'bankbranchname', 'Branch Name' );
  21 $browser->AddColumn( 'bankname', 'Bank Name' );
  22 $browser->AddColumn( 'bankaccount', 'Bank Account' );
  23 $browser->AddColumn( 'companycode', 'Company', 'center' );
  24 $browser->AddColumn( 'accountcode', 'Account' );
  25 $browser->SetJoins( "bankaccount" );
  26 if ( $show_active == 't' ) {
  27   $browser->AndWhere( "active" );
  28 }
  29 $browser->SetOrdering( 'bankaccountcode', 'DESC', 1 );
  30 $rowurl = '/view.php?t=bankaccount&id=%s';
  31 $browser->RowFormat( "<tr onclick=\"window.location='$rowurl';\" title=\"Click to Display Bank Account Detail\" class=\"r%d\">\n", "</tr>\n", 'bankaccountcode', '#even' );
  32
  33 $page_elements[] = $browser;
  34
  35 $related_menu->AddOption("New Bank Account","/edit.php?t=bankaccount","Create a new bank account", false, 3100);