Yii Framework Forum: Rii - Report Generator Tool - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Rii - Report Generator Tool Don't you think that php need a decent tool to create reports? Rate Topic: ***** 1 Votes

#1 User is offline   lynshelmanscott 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 6
  • Joined: 07-August 09
  • Location:Venezuela

Posted 25 February 2012 - 08:21 PM

Hi everyone, Don't you think that php need a decent tool to create reports? I came from a vb6/delphi/asp.net/java environment,.. and the only thing I really miss when I'm working with php is a good tool to build reports.. every language I have mention before count with amazing tools like active report/crystal report/birt/jasper report/etc.. I use for php TCPDF lib but let's face it! is a hell.. :(

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..! B)
0

#2 User is offline   lynshelmanscott 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 6
  • Joined: 07-August 09
  • Location:Venezuela

Posted 26 February 2012 - 02:07 AM

Some Features:

  • 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

0

#3 User is offline   Joblo 

  • Master Member
  • PipPipPipPip
  • Yii
  • Group: Members
  • Posts: 685
  • Joined: 12-September 10
  • Location:Austria

Posted 26 February 2012 - 06:49 PM

I agree.
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.
0

#4 User is offline   lynshelmanscott 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 6
  • Joined: 07-August 09
  • Location:Venezuela

Posted 27 February 2012 - 08:58 AM

View PostJoblo, on 26 February 2012 - 06:49 PM, said:

But the missing reporting tool is not an Yii issue.


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?
0

#5 User is offline   Jimlam 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 195
  • Joined: 17-March 12

Posted 11 June 2012 - 03:01 PM

Hi,

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
0

#6 User is offline   Joblo 

  • Master Member
  • PipPipPipPip
  • Yii
  • Group: Members
  • Posts: 685
  • Joined: 12-September 10
  • Location:Austria

Posted 11 June 2012 - 04:20 PM

There's another extension to integrate Jasper reports (iReport) with PHP: jasphp.
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.
0

#7 User is offline   juanmf 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 1
  • Joined: 01-November 12

Posted 01 November 2012 - 05:04 PM

Hi,

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:
github.com/juanmf/sfPlugins/tree/master/reportPlugin

Here is the HowTo create templates with Word:
github.com/juanmf/sfPlugins/blob/master/reportPlugin/doc/HowToReport.pdf?raw=true

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.
Juan
0

#8 User is offline   Kinetik 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 11
  • Joined: 22-June 11
  • Location:East Java, Indonesia

Posted 13 November 2012 - 01:20 PM

Reporting feature in Yii is one of thousands feature every web developer has been dreaming of. I'm sure this feature will be a solution for every Yii-application.

Thanks for great effort and amazing framework!
-= Good things come to those who wait =-
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

2 User(s) are reading this topic
0 members, 2 guests, 0 anonymous users