inc/browse/batch.php

   1 <?php
   2
   3 $browser = new Browser("Posted Batches");
   4 $browser->AddColumn( 'batchcode', 'Batch', 'center' );
   5 // $browser->AddColumn( 'batchtype', 'Type' );
   6 $browser->AddColumn( 'documentcount', 'Documents' );
   7 $browser->AddColumn( 'description', 'Description' );
   8 $browser->AddColumn( 'total', 'Total', 'right', '%0.2lf', 'COALESCE(total,0.0)' );
   9 $browser->AddColumn( 'updatedby', 'Updated By' );
  10
  11 $browser->SetJoins( "batch b LEFT JOIN usr u ON u.user_no = b.operatorcode" );
  12
  13 $browser->AddOrder( 'batchcode', 'DESC', 1 );
  14
  15 $rowurl = '/view.php?t=batch&id=%d';
  16 $browser->RowFormat( "<tr onclick=\"window.location='$rowurl';\" title=\"Click to Display Batch Detail\" class=\"r%d\">\n", "</tr>\n", 'batchcode', '#even' );
  17 $browser->SetLimit(300);
  18 $browser->DoQuery();
  19
  20 $c->page_title = "Browse Posted Batches";
  21
  22 $page_elements[] = $browser;