inc/browse/accountgroups.php

   1 <?php
   2
   3 include_once("classEditor.php");
   4
   5 $editrow = new Editor("Account Group", "accountgroup" );
   6 $editrow->SetSubmitName( 'saverow' );
   7 if ( $editrow->IsSubmit() ) {
   8   $editrow->SetWhere( "accountgroupcode=".qpg($_POST['editgroup']));
   9   $editrow->Write();
  10   if ( $_POST['accountgroupcode'] != $_POST['editgroup'] ) {
  11     $qry = new PgQuery("UPDATE chartofaccount SET accountgroupcode=? WHERE accountgroupcode = ?", $_POST['accountgroupcode'], $_POST['editgroup'] );
  12     $qry->Exec('accountgroups');
  13     $editrow->GetRecord( "accountgroupcode=".qpg($_POST['accountgroupcode']));
  14   }
  15   unset($_GET['editgroup']);
  16 }
  17
  18
  19 function edit_row( $row_data ) {
  20   global $editrow;
  21
  22   $rowsubmittype = ($row_data->accountgroupcode == '' ? 'Add' : 'Save');
  23   $form_url = preg_replace( '#&(edit|del)seq=\d+#', '', $_SERVER['REQUEST_URI'] );
  24
  25   $template = <<<EOTEMPLATE
  26   <td class="left">##accountgroupcode.input.8##<input type="hidden" name="id" value="##accountgroupcode.value##"><input type="hidden" name="editgroup" value="##accountgroupcode.value##"></td>
  27   <td class="left">##name.input.30##</td>
  28   <td class="left">##sequencecode.input.4##</td>
  29   <td class="left">##creditgroup.checkbox##</td>
  30   <td class="left">##grouptype.input.1##</td>
  31   <td class="left">##$rowsubmittype.submit##</td>
  32
  33 EOTEMPLATE;
  34
  35   $editrow->Layout( $template );
  36   $editrow->Title("");
  37   if ( $row_data->accountgroupcode == '' ) {
  38     $editrow->Initialise( (array) $row_data );
  39   }
  40   else
  41     $editrow->SetRecord( $row_data );
  42
  43   return $editrow->Render();
  44 }
  45
  46
  47 $browser = new Browser("Accounts");
  48 $browser->AddColumn( 'accountgroupcode', 'A/C Group' );
  49 $browser->AddColumn( 'name', 'Name' );
  50 $browser->AddColumn( 'sequencecode', 'Seq' );
  51 $browser->AddColumn( 'creditgroup', 'Cr?' );
  52 $browser->AddColumn( 'grouptype', 'Type' );
  53 $browser->SetJoins( 'accountgroup' );
  54 if ( isset($_GET['editgroup']) ) {
  55   $browser->RowFormat( "<tr class=\"r%d\">\n", "</tr>\n", '#even' );
  56 }
  57 else {
  58   $rowurl = '/browse.php?t=chartofaccounts&accountgroup=%s';
  59   $browser->RowFormat( "<tr onclick=\"window.location='$rowurl';\" class=\"r%d\">\n", "</tr>\n", 'accountgroupcode', '#even' );
  60 }
  61
  62 $edit_link = "<a href=\"/browse.php?t=accountgroups&editgroup=##accountgroupcode##\" class=\"submit\">Edit</a>";
  63 $del_link  = "<a href=\"/browse.php?t=accountgroups&delgroup=##accountgroupcode##\" class=\"submit\">Del</a>";
  64 $browser->AddColumn( 'action', 'Action', 'center', '', "'$edit_link&nbsp;$del_link'" );
  65
  66 $browser->SetOrdering( 'sequencecode' );
  67
  68 @include_once("menus_accounts.php");
  69
  70 if ( isset($_GET['delgroup']) ) {
  71   $qry = new PgQuery("DELETE FROM accountgroup WHERE accountgroupcode=? AND NOT EXISTS(SELECT 1 FROM chartofaccount WHERE chartofaccount.accountgroupcode = accountgroup.accountgroupcode)", $_GET['delgroup'] );
  72   $qry->Exec('accountgroups');
  73 }
  74 if ( isset($_GET['editgroup']) ) {
  75   $browser->MatchedRow('accountgroupcode', $_GET['editgroup'], 'edit_row');
  76 }
  77 else {
  78   $extra_row = array( 'accountgroupcode' => '' );
  79   $browser->MatchedRow('accountgroupcode', '', 'edit_row');
  80   $extra_row = (object) $extra_row;
  81   $browser->AddRow($extra_row);
  82 }
  83
  84 $page_elements[] = $browser;