V7 {FRAMEWORK USER} and Joomla

This site is best viewed in a modern browser with JavaScript enabled.

patgaytx

In the v7 docs, it says I can: $q->external_user = "USERID"; to get the user and then call {FRAMEWORK USER} in the SQL.
I'm using Joomla and Reportico 4.6 and would like to move to v7. Can you tell me how I can accomplish this without having the Joomla module?

patgaytx

Any ideas?

peterdeed

Hi there... apologies for very late response...

Here is the answer .. after installing the v7 package you should be able to do exactly mentioned above but the way to do it is
- go to reportico top level folder copy start.php to say user.php
- edit user.php and uncomment/change line

$reportico->external_user = "<CURRENT USER>";

$reportico->external_user = "joomla user";

or if you are passing in a user like "https://..../reportico/user.php?user=5 you can use

$reportico->external_user = $_REQUEST["user"];

in your report use sql like as follows -
```
SELECT x
FROM  y
WHERE 1 = 1  
and user = {FRAMEWORK_USER}
```

So now you can use reportico against your joomla database for a given user...

Hope that helps let me know and ill try to be more responsive!!!

patgaytx

How about if I want to take the userid of the user who is currently logged in to Joomla? In your example above, you say "joomla user" and I'm assuming that means the user that is entered between the quotes, but that won't work to show me information that belongs to the {FRAMEWORK USER} and only that user. How do I accomplish that?

peterdeed

well assuming that say the passed external iser is say user id 33 for example then it should generate an sql like

SELECT x
FROM  y
WHERE 1 = 1  
and user = 33

Im not sure im answering your question

patgaytx

peterdeed How do I get the "33" to be substituted? I know {FRAMEWORK USER} is supposed to be that number, but at the very beginning of the post, you say:
- go to reportico top level folder copy start.php to say user.php
- edit user.php and uncomment/change line

$reportico->external_user = "<CURRENT USER>";
to

$reportico->external_user = "joomla user";

How do I get user.php to figure out what exteranl_user="joomla user"; should be? Specifically, how to I get this to determine external_user="33"; if 33 is the user id of the user that is currently logged in on Joomla? In Joomla I can
use:

$user =& JFactory::getUser();
$user->get('id');

What I can't figure out is how to get the output of the get('id') into the SQL that Reportico will create?