Rii - Report Generator Tool Don't you think that php need a decent tool to create reports?
Posted 25 February 2012 - 08:21 PM
What would happen if Yii include a basic Report Helper/Builder that uses AR (in Gii module style)??
Thanks Yii Team for such amazing framework..!
Posted 26 February 2012 - 02:07 AM
- Query Builder -> AR
- Templates -> header, footer, detail (SingleColumn, MultiColumn, Tabular), Sections, page#, title, autor, Etc
- Export -> PDF, Excel, CSV, TXT, XML
- Fields Operations -> Filter, Group, Sort ASC/DESC, Count(), Avg(), Sum(), formatting, (Criteria? Hide: Show)
- Links to Drill-Down
- Embed Graphs / Images / Sub-Reports
Posted 26 February 2012 - 06:49 PM
But the missing reporting tool is not an Yii issue, it's a generally PHP problem.
I didn't found a solutiong since years ... :-(
An effort was PHPJasperXML but still in beta, and seems it will stay in this state.
There exists an Yii-extension for this: ireport
but I don't think it's ready for a production enviroment ...
Still waiting for a real PHP reporting solution, otherwise I think I will use java and jasper report.
Posted 27 February 2012 - 08:58 AM
I partially agree about that, Zend framework in deed stop there, but Yii provide code generators.
If you can generate forms (input) why not reports (output)?..
As I mention before, I can create reports but I want a full object oriented way to do that common task (the Yii way).
$this->widget('rii.widgets.CReportTabular', array( 'dataProvider'=>$model->search(), 'output' => 'pdf', 'orientation' => 'portrait', 'pagination'=>true, 'style' => array( 'mode'=>'embed', 'height'=>320, 'width'=>400, ), 'title'=>'Customer Report', 'template'=>'detail_view', 'columns'=>array( ... <div class="report"> ... </div>
There are a lot of experts in the community; at least one of them may have a solution..!! Or we must accept the limitation of php?
Posted 11 June 2012 - 03:01 PM
I am facing the same problem and am at a loss concerning this report issue. Can anybody please give me a hint how you build reports in php? Also, what is the best way to print documents like invoices, quotations and other various documents that need to be issued to customers in a commercial software? Thanks
Posted 11 June 2012 - 04:20 PM
ericmaicon startet to port the Java-Code to PHP, but it's a lot of work and in alpha state.
I now have installed the 'original' JasperReport Server and iReport and next time I will try the report-handling with the PHP/SOAP-Interface.
Posted 01 November 2012 - 05:04 PM
I agree that PHP doesn't have a decent reporting tool yet. I'm working on an implementation, that at my office several projects are already using and we are happy with the results.
It's based in XSLT to consume your data, that must be given as XML and produces a XSL-FO report. Which get's processed by the proper Renderer class (PDF, HTML, anyone you want to add..). The PDF are perfect thanks to ApacheFOP. All this workflow is handled by the reporting tool. Which you can consume in your PHP client class with 2 lines of code.
As a templating engine, we use MS Word, save docs as Word XML 2003 and process them with a modified version of Word2FO.xsl stylesheets, which instead of rendering an identical FO document, renders an XSLT that, if processed again, with input data XML, generates the XSL-FO report.
So far, it's a symfony 1.4 plugin, we already use an unreleased sf2 bundle. and I plan to make a standalone component soon.
Here you have the project links
Here is the project page:
Here is the HowTo create templates with Word:
Hope you can manage to give it a try, once you installed it it's really easy to use and very powerful.
Cheers, any feedback is welcome.