[Summary view] [Print] [Text view]

   1  <?php
   2      require_once ("PHPReportMaker.php");
   3  
   4      $sParms = 
   5      "<ROW>".
   6      "<COL ALIGN='RIGHT' CELLCLASS='HEADER'>from</COL>".
   7      "<COL TYPE='EXPRESSION' CELLCLASS='HEADER' TEXTCLASS='BOLD' COLSPAN='4'>\$this->getParameter('from')</COL>".
   8      "</ROW>".
   9      "<ROW>".
  10      "<COL ALIGN='RIGHT' CELLCLASS='HEADER'>till</COL>".
  11      "<COL TYPE='EXPRESSION' CELLCLASS='HEADER' TEXTCLASS='BOLD' COLSPAN='4'>\$this->getParameter('till')</COL>".
  12      "</ROW>";
  13  
  14      $sGroup = 
  15      "<GROUP EXPRESSION='city'>".
  16      "<HEADER>".
  17      "<ROW><COL CELLCLASS='HEADER' TEXTCLASS='BOLD' TYPE='EXPRESSION' COLSPAN='50'>\$this->getValue('city')</COL></ROW>".
  18      "</HEADER>".
  19      "<FIELDS>".
  20      "<ROW>".
  21      "<COL TYPE='FIELD' CELLCLASSEVEN='EVEN' CELLCLASSODD='ODD' SUPPRESS='TRUE'>name</COL>".
  22      "<COL TYPE='FIELD' CELLCLASSEVEN='EVEN' CELLCLASSODD='ODD'>type</COL>".
  23      "<COL TYPE='FIELD' CELLCLASSEVEN='EVEN' CELLCLASSODD='ODD'>item</COL>".
  24      "<COL TYPE='FIELD' CELLCLASSEVEN='EVEN' CELLCLASSODD='ODD' NUMBERFORMATEX='2' ALIGN='RIGHT'>value</COL>".
  25      "</ROW>".
  26      "</FIELDS>".
  27      "<FOOTER>".
  28      "<ROW>".
  29      "<COL CELLCLASS='FOOTER' ALIGN='RIGHT' COLSPAN='3'>total</COL>".
  30      "<COL TYPE='EXPRESSION' CELLCLASS='FOOTER' TEXTCLASS='BOLD' NUMBERFORMATEX='2'>\$this->getSum('value')</COL>".
  31      "</ROW>".
  32      "</FOOTER>".
  33      "</GROUP>";
  34  
  35      $sDoc =
  36      "<DOCUMENT>".
  37      "<FOOTER>".
  38      "<ROW>".
  39      "<COL CELLCLASS='FOOTER' TEXTCLASS='BOLD' ALIGN='RIGHT' COLSPAN='3'>GRAND TOTAL</COL>".
  40      "<COL TYPE='EXPRESSION' CELLCLASS='FOOTER' TEXTCLASS='BOLD' NUMBERFORMATEX='2'>\$this->getSum('value')</COL>".
  41      "</ROW>".
  42      "</FOOTER>".
  43      "</DOCUMENT>";
  44  
  45      $oRpt = new PHPReportMaker();
  46      $oRpt->setUser("taq");
  47      $oRpt->setPassword("******");
  48      $oRpt->setSQL("select * from sales order by city,name");
  49      $oRpt->setDatabaseInterface("mysql");
  50      $oRpt->setDatabase("phpreports");
  51      $oRpt->setParameters(array("from"=>"today","till"=>"tomorrow"));
  52      $oRpt->createFromTemplate("Template report","template.xml",$sParms,$sDoc,$sGroup);
  53      $oRpt->run();
  54  ?>