New report - Printer expenses

YaKs · 2009-03-03 09:33:14

Hi to all of you,

I like a lot GLPI and I always try to use its features every time I have the chance. the last was after my boss asked me about a report of the printer expenses. The first solution I did was quite straightforward , create a access database with the GLPI tables link to it and then create the following query

SELECT Year([date]) AS [YEAR], Month([date]) AS [MONTH], glpi_type_printers.name AS TYPE, glpi_dropdown_model_printers.name AS MODEL, glpi_dropdown_manufacturer.name AS MANUFACTER, (glpi_tracking.cost_material+glpi_tracking.cost_fixed+glpi_tracking.cost_time) AS COST, glpi_printers.name AS PRINTER, glpi_printers.serial
FROM (((glpi_tracking INNER JOIN glpi_printers ON glpi_tracking.computer = glpi_printers.ID) INNER JOIN glpi_type_printers ON glpi_printers.type = glpi_type_printers.ID) INNER JOIN glpi_dropdown_model_printers ON glpi_printers.model = glpi_dropdown_model_printers.ID) INNER JOIN glpi_dropdown_manufacturer ON glpi_printers.FK_glpi_enterprise = glpi_dropdown_manufacturer.ID
GROUP BY Year([date]), Month([date]), glpi_type_printers.name, glpi_dropdown_model_printers.name, glpi_dropdown_manufacturer.name, glpi_printers.name, glpi_printers.serial, glpi_tracking.cost_time, glpi_tracking.cost_fixed, glpi_tracking.cost_material;

After that from Excel sheet I just read the query and use the pivottable-pivotchart report.
that's all!

Now I was thinking how to integrate this report in GLPI itself. What a pity doesnt have any integrated reporting tool. Is there any plan to add it one? I was checking in sourceforge but I didnt find any good enough...

best regards,
Jose

remi · 2009-03-03 09:39:57

There is a minimal reporting tool : the "reports" plugin.

To add a new report, simply copy one and change the SQL request.
The "simpleReport" function will do the main job.

+

YaKs · 2009-03-03 09:53:55

Hi!
I have my 'plugins' folder empty... should I use the reports in 'front' folder??

thanks!

Last edited by YaKs (2009-03-03 09:55:02)

remi · 2009-03-03 09:57:49

Read : http://www.glpi-project.org/spip.php?article252

+

MHI · 2009-03-04 16:36:19

remi, any chance to get this plugin to work under 0.72, as I get the "Non-existent function(s): plugin_reports_check_config" message with the latest SVN, but probably you haven't worked on that one the last weeks due to other priorities.

remi · 2009-03-04 17:27:37

Yes, there is a chance.

Just need someone to do the job.
But we have some time to do this, 0.72 doesn't exists yet.

+

MHI · 2009-03-04 17:44:24

remi wrote:

0.72 doesn't exists yet.

+

You are right, just thought, as we are coming closer to the release date on the roadmap, that some testing wouldn't harm

Last edited by MHI (2009-03-05 00:33:20)

wawa · 2009-03-04 20:12:16

the plugin will work when we'll have enough time to port it...
I hope before the release of glpi 0.72...

Forum GLPI-Project

Announcement

#1 2009-03-03 09:33:14

New report - Printer expenses

#2 2009-03-03 09:39:57

Re: New report - Printer expenses

#3 2009-03-03 09:53:55

Re: New report - Printer expenses

#4 2009-03-03 09:57:49

Re: New report - Printer expenses

#5 2009-03-04 16:36:19

Re: New report - Printer expenses

#6 2009-03-04 17:27:37

Re: New report - Printer expenses

#7 2009-03-04 17:44:24

Re: New report - Printer expenses

#8 2009-03-04 20:12:16

Re: New report - Printer expenses

Board footer