Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Products: CMS Builder: Plugins & Add-ons:
Include/create hyperlinks from a report query

 
 


MickC
User

Sep 16, 2011, 2:23 AM

Post #1 of 4 (2007 views)
Shortcut
Include/create hyperlinks from a report query Can't Post
I have just bought and installed the Report Builder plug in.

What i want to, is have the report contain a hyperlink to edit the record.

I made a report on out "listings" table, and it shows all records where "approved=No" - this works well.

What i need, is to make a hyperlink out of the results so the editor can click it to go directly to the edit page of that record.

If I could access the php page that the report is on, i could code it in, but I can't seem to find where that page is.
When the report is in the browser, it shows the URL as ..cmsAdmin/admin.php?_pluginName=reportBuilder&_report=4


Jason
Staff / Moderator


Sep 16, 2011, 9:50 AM

Post #2 of 4 (1982 views)
Shortcut
Re: [MickC] Include/create hyperlinks from a report query [In reply to] Can't Post
Hi,

If you go into the plugins folder for report builder and open reportBuilder.php, the HTML that displays the actual report is created in a function called _reportBuilder_displayReport().

It is important to note that unless you put in some conditional statements, any changes you make here will display in ALL reports you create.

Hope this helps get you started.
---------------------------------------------------
Jason Sauchuk - Programmer 
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/ 


MickC
User

Sep 18, 2011, 1:53 AM

Post #3 of 4 (1978 views)
Shortcut
Re: [Jason] Include/create hyperlinks from a report query [In reply to] Can't Post
Thanks Jason,

I have had a go, but cant quite figure out what to change.

All our records have a unique field called "stock_number"
I want users to run any report, which will have a list of units, with stock numbers as part of the report.

But, i want this field in the report,or a button next to the row, that editors can click on to take them straight into the edit page for that record. (otherwise they have to run the report, write the stock numbers down and go back to the listing to edit them.

so for example, i have a report that lists units that are on hire. - in the stock number field, instead of a text sating "U20013" i want this to be a link to " /admin.php?menu=listings&action=edit&num=" then the listing number.

Or a button next to it.


Jason
Staff / Moderator


Sep 19, 2011, 10:02 AM

Post #4 of 4 (1921 views)
Shortcut
Re: [MickC] Include/create hyperlinks from a report query [In reply to] Can't Post
Hi,

Are all of your reports going to be coming from the same section? If not, the trick here will be to get the tableName that this report is being run from.

If you'd like us to customize this plugin to do this for you, please email consulting@interactivetools.com to go over some options.

Hope this helps
---------------------------------------------------
Jason Sauchuk - Programmer 
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/