We now want to make a real report with the data we have. Actually, we will change the data a little, and add some more data lines and one more column.
| Your new data |
|
| The new column will be used to split some of the results according with its store location in our 'finance like report'. And we want to know how much was sold in both places. |
| The new HTML template |
|
| Besides the block named 'values' we now added a new one, called b_location. That block will be repeated once for each different location values. Note that we dont have a b_location column, but one named location. That b_ prefix is added by the Report class to avoid conflict within the template block processing. You dont have to change that prefix, but must be aware of that change since is made by the Report class every time you add headers or sub-headers to your data. One last block was added, the totals is a standard block used by the Report class to put the results of columns sums. It must be inside the b_location block in this case, since there are sums for each different location. Note that the tags inside the totals block have the same name as the tags above it. |
And we have changed the report to the code bellow, adding the definition for the fields 'inserted' and 'value' of our data:
<?php
/**
* php Report lesson 3
*
* (c) 2004 Sebastiao Rocha A. Neto
*/
require_once("../src/Report.php");
// Read the array
require_once("array-2.php");
// Create the report
$report =& new Report($list, ".", "lesson-3.htm");
// Set column types
$types = array ( 'inserted' => 'date', 'value' => 'money');
$report->setVariableType($types);
// Uncomment bellow to change the Currency simbol.
// $report->setCurrencySymbol('$');
// Change bellow if you dont want to use european style for dates
//$report->europeanstyle = false;
// Define columns where we want total
$sums = array ( 'qtd' => true, 'value' => true);
$report->setTotals($sums);
// Define wich column should be used as header
$report->setTitle('location', 0);
// Uncoment bellow if you need debug the template processing
//$report->debug = true;
// Prepare the data
$report->makeReport();
// Show it
$report->show();
?>
To see the result click here.
Nice hum? But our report is wrong! We forgot to multiply the
quantity by price of goods sold for each line! The total reported for each store
is completly wrong. To fix that we need to multiply qtd*value and create a new
column to place the result, and then add the result.
To have a new column we need to modify the template and open space for it and change the php code to to the math for us:
| The new HTML template |
|
| Note that the only change made was the new column. We could have used the same number of columns if we wanted. We could have replaced the the tag {value} to {subtotal}. That should work too. |
| The new php code for the right report: |
|
| We have used the method setExpression to get the job done. The first argument is the name of the new field, the second is the math expression to be used. Note that you can use any function here, php functions or user defined ones. The last argument is the field type. If omitted the type will be the default type, that is a string. |
To see the result click here.