Cactiusers.org

Hi All,
I have added some code to the code published by Jimmy under the forum http://cactiusers.org/forums/topic645.html to allow report plugin to send weekly and monthly report.
For Weekly report it will send report on every Monday and for Monthly it will send report on the date of 1st of every month.
I attached only 2 files that I made the amendment. For the rest of the file please retrived from the above forum

For those users who want to just do a slight modification on the SQL table, you can run this in mysql

mysql> ALTER TABLE reports ADD freq VARCHAR(1) NOT NULL DEFAULT 'd';

Note that this command is for those who is following the above forum. As for the reports.sql file, please do not use it unless your want to discard the old SQL table in the report0.1b.

Still in testing progress

Hi Jimmy,
I discovered a bug on the reports.php. Whenever you create new report and add new report to it for the "inline png", the url will be /plugins/reports/reports.php?report=$id instead of /plugins/reports/reports.php?report=1 or other no. It seems that the hostid is not posted to the URL.
Resulting that the text and graph created are not given the correct hostid. THis does not apply for clicking the edit the exisiting report. it only happens when you create a new report.
I found that this line is injected from reports.php, under template add
if ($id) {
Header('Location: reports_edit.php?report=$id');
exit;
What should I do?

regards

poly,

This looks like a good addition to the Reports plugin, I will test out later today.

A feature for this plugin which I would like to see is the ability to add a graphic/logo to the report, any ideas how to do it?

I'm going to post it over on the Feature Request forum, while I try and work it out myself.

Argon0

Hi Jimmy,
I found the bug and solved. Now I dont have the problem in adding text and graph to the new report. I have updated the report.php in the above attached.

Regards

So, Poly, what we need to do is replace reports.php and setup.php in the reports plugin directory, then run the sql query you mention above?

Am I right?

Any help you can give me with adding a logo to the reports?

Argon0

Hi,
Yes that replacing the 2 files would do. Note that Jimmy has made changes to the database tables as from ver 0.1b. If you are using the latest version from the above mentioned forum. Just need to execute the command mentioned above to alter the current table.
As for the logo, I dont have the idea where to modify. However, I will take note of it.

regards

Well I've worked out how to "hard code" it into the PDF and the Preview reports:

Preview:



PDF:



What I need to do now is work out how to get the variable $logo defined from the web interface/wizard - worked out how to add an entry to the drop down list, and get it to mirror the text input....

Maybe there is some easy way of not making the graphs stretch across the whole page when generating the PDF? It would just make the report look better I think.

/Carl

I'm sure there must be the variables for the PDF -> IMAGE command must include a sizing factor, as well as as justification...

I shall dig...

FPDF is the extension being used...

More info over here ===> http://www.fpdf.org/

YUp, it is possible you just have to decide how wide you want the images to be and specify it in the functions.php file - on the line



(which is, I think, line 251), the width is specified in the 4th variable - i.e. if you wanted it to be 200 units wide (now I don't know what units it uses, by default it will use 72dpi.....): $pdf->Image($fn, 1, $ypos, 200, 0, 'PNG');

Argon0

Thanks!

Had to work with the image size and the pdf dpi size a bit to get a good crisp image, but now it works lika a charm.

Also read a bit on the FPDF page, and there are lots of cool things you can do there

/Carl

What image size did you use?

It's not completely crisp, but it's ok. I'm finding it hard to understand how it all goes together. If I define the graph to 200x600, and I set the $pdf->Image hight dpi to 100, I think my graph should be around 2 inches, but it is not.

Or if I want a crisp picture, I would like 300 dpi, but setting the graph hight to 600 will not result in a roughly 1 inch high image.


Anyway, I use graph hight 200, width 600. I have also made a change to make spacing better between the graphs with these settings:

$h = ($h[1] / 4.50);

and finaly:

$pdf->Image($fn, 11, $ypos, 140, 0, 'PNG');

I get 3 graphs per page with these settings with one row of font size 10 text above.

/Carl

Does the 140 refer to DPI? or a percentage or ?