[Summary view] [Print] [Text view]

   1  <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
   2  <!DOCTYPE REPORT SYSTEM "PHPReport.dtd">
   3  <REPORT MARGINWIDTH="5" MARGINHEIGHT="5">
   4     <TITLE>Sales Report</TITLE>
   5     <BACKGROUND_COLOR>#FFFFFF</BACKGROUND_COLOR>
   6      <CSS>sales.css</CSS>
   7      <SQL>select CITY,NAME,TYPE,ITEM,VALUE from sales order by CITY,NAME,TYPE,ITEM</SQL>
   8      <CONNECTION>localhost</CONNECTION>
   9      <INTERFACE>mysql</INTERFACE>
  10      <DATABASE>phpreports</DATABASE>
  11      <NO_DATA_MSG>No data was found, check your query</NO_DATA_MSG>
  12      <DOCUMENT>
  13          <FOOTER>
  14              <ROW>
  15                  <COL COLSPAN="2" CELLCLASS="FOOTER" TEXTCLASS="BOLDRED" ALIGN="RIGHT">GRAND TOTAL</COL>
  16                  <COL CELLCLASS="FOOTER" TEXTCLASS="BOLDRED" TYPE="EXPRESSION" ALIGN="RIGHT" NUMBERFORMATEX="2">$this->getSum("VALUE")</COL>
  17              </ROW>
  18          </FOOTER>
  19      </DOCUMENT>
  20     <PAGE BORDER="0" SIZE="30" CELLSPACING="0" CELLPADDING="3">
  21          <HEADER>
  22              <ROW>
  23                  <COL CELLCLASS="HEADER" COLSPAN="3">
  24                      <XHTML>
  25                          <TABLE BORDER="0" CELLPADDING="2" CELLSPACING="0" WIDTH="100%">
  26                              <TR>
  27                                  <TD CLASS="HEADER">
  28                                      <b>JOHN DOE ENTERPRISES</b>
  29                                  </TD>
  30                                  <TD ROWSPAN="2" CLASS="HEADER" style="background:#A0A0A0;color:#FFFFFF;" ALIGN="CENTER">
  31                                          powered by<br/><b>phpreports</b>
  32                                  </TD>
  33                              </TR>
  34                              <TR>
  35                                  <TD CLASS="HEADER">
  36                                      <b>SALES REPORT</b>
  37                                  </TD>
  38                              </TR>
  39                              <TR>
  40                                  <TD COLSPAN="3"><HR/></TD>
  41                              </TR>
  42                          </TABLE>
  43                      </XHTML>
  44                  </COL>
  45              </ROW>    
  46          </HEADER>
  47          <FOOTER>
  48              <ROW>
  49                  <COL ALIGN="RIGHT" CELLCLASS="FOOTER" COLSPAN="2">page total</COL>
  50                  <COL TYPE="EXPRESSION" CELLCLASS="FOOTER" TEXTCLASS="BOLD" ALIGN="RIGHT" NUMBERFORMATEX="2">$this->getSum("VALUE")</COL>
  51              </ROW>    
  52              <ROW>
  53                  <COL ALIGN="RIGHT" COLSPAN="3" TYPE="EXPRESSION" CELLCLASS="FOOTER">"page number ".$this->getPageNum()</COL>
  54              </ROW>
  55          </FOOTER>
  56      </PAGE>
  57      <GROUPS>
  58          <GROUP NAME="city" EXPRESSION="CITY" REPRINT_HEADER_ON_PAGEBREAK="TRUE" PAGEBREAK="TRUE">
  59              <HEADER>
  60                  <ROW>
  61                      <COL ALIGN="RIGHT" CELLCLASS="HEADER" WIDTH="50"><LINK TYPE="STATIC" TARGET="_blank" TITLE="explain of what is a city">http://www.whatisacity.com</LINK>city:</COL>
  62                      <COL TYPE="EXPRESSION" CELLCLASS="HEADER" TEXTCLASS="BOLD" COLSPAN="2"><BOOKMARK TYPE="EXPRESSION" CELLCLASS="CITY" TEXTCLASS="BOOKMARK_TEXT">$this->getValue("CITY")</BOOKMARK>$this->getValue("CITY")</COL>
  63                  </ROW>
  64              </HEADER> 
  65              <FOOTER>
  66                  <ROW>
  67                      <COL COLSPAN="3" CELLCLASS="FOOTER"></COL>
  68                  </ROW>
  69                  <ROW>
  70                      <COL ALIGN="RIGHT" TYPE="EXPRESSION" CELLCLASS="FOOTER" COLSPAN="2">"total of ".$this->getValue("CITY")</COL>
  71                      <COL TYPE="EXPRESSION" CELLCLASS="FOOTER" TEXTCLASS="BOLD" ALIGN="RIGHT" NUMBERFORMATEX="2">$this->getSum("VALUE")</COL>
  72                  </ROW>
  73                  <ROW>
  74                      <COL COLSPAN="3" CELLCLASS="FOOTER"></COL>
  75                  </ROW>
  76              </FOOTER>
  77              <GROUP NAME="customer" EXPRESSION="NAME" RESET_SUPPRESS_ON_PAGEBREAK="TRUE" REPRINT_HEADER_ON_PAGEBREAK="TRUE">
  78                  <HEADER>
  79                      <ROW>
  80                          <COL CELLCLASS="HEADER" ALIGN="RIGHT" WIDTH="50">customer:</COL>
  81                          <COL CELLCLASS="HEADER" TEXTCLASS="BOLD" TYPE="EXPRESSION" COLSPAN="2"><LINK TYPE="EXPRESSION" TARGET="_blank" TITLE="click here to check info about the customer">"http://localhost/getcustomerinfo.php?name=".$this->getValue("NAME")</LINK>$this->getValue("NAME")</COL>
  82                      </ROW>
  83                      <ROW>
  84                          <COL CELLCLASS="HEADER" TEXTCLASS="BOLD" ALIGN="LEFT">type</COL>
  85                          <COL CELLCLASS="HEADER" TEXTCLASS="BOLD" ALIGN="LEFT">title</COL>
  86                          <COL CELLCLASS="HEADER" TEXTCLASS="BOLD" ALIGN="RIGHT">$</COL>
  87                      </ROW>
  88                  </HEADER>
  89                  <FIELDS>
  90                      <ROW>
  91                          <COL TYPE="FIELD" CELLCLASSEVEN="EVEN" CELLCLASSODD="ODD" ALIGN="LEFT" SUPPRESS="TRUE">TYPE</COL>
  92                          <COL TYPE="FIELD" CELLCLASSEVEN="EVEN" CELLCLASSODD="ODD" ALIGN="LEFT">ITEM</COL>
  93                          <COL TYPE="FIELD" CELLCLASSEVEN="EVEN" CELLCLASSODD="ODD" ALIGN="RIGHT">VALUE</COL>
  94                      </ROW>
  95                  </FIELDS>
  96                  <FOOTER>
  97                      <ROW>
  98                          <COL ALIGN="RIGHT" TYPE="EXPRESSION" CELLCLASS="FOOTER" COLSPAN="2">"total of ".$this->getValue("NAME")</COL>
  99                          <COL TYPE="EXPRESSION" CELLCLASS="FOOTER" TEXTCLASS="BOLD" ALIGN="RIGHT" NUMBERFORMATEX="2">$this->getSum("VALUE")</COL>
 100                      </ROW>
 101                      <ROW>
 102                          <COL COLSPAN="3" TYPE="EXPRESSION" CELLCLASS="FOOTER" TEXTCLASS="BOLD" ALIGN="RIGHT">($this->getSum("VALUE")>200?"*** Free shipping bonus!***":"Regular shipping charging")</COL>
 103                      </ROW>
 104                  </FOOTER>
 105              </GROUP>    
 106          </GROUP>
 107      </GROUPS>
 108  </REPORT>