CB auto action: display fields outside of joomla

krileon
Team Member
OFFLINE
Posts: 68521
Thanks: 9091
Karma: 1434

4 years 4 weeks ago #317318 by krileon

Replied by krileon on topic CB auto action: display fields outside of joomla

with [cb_marketevents] being a GJ event id.
Can I get directly the corresponding GJ event title in the above json without going with a SQL request as it's CB part and how ?

You only stored the event id so no you can't without doing a query to get the title.

For other joomla components, if I want to use CB API and auto actions to get DB table values, I guess that I have to go through a mySQL standard request in the PHP code ? or can I use the query auto actions to output something also in raw or json format ?

As it's PHP you can do whatever PHP code you need to do. Then just be sure to return an array or object in your code with the latest CB Auto Actions build and it'll serialize to JSON for you. A query action only ever outputs a string result of the first row and column so it won't really work unless you handle creating a JSON string in the query. Have added a feature ticket to see if I can make it a little smarter since CB Auto Actions can handle array and object output now.

forge.joomlapolis.com/issues/7890

That feature is a bit more complicated so that won't be something I can push soon.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

activha
OFFLINE
Platinum Member
Posts: 2278
Thanks: 113
Karma: 13

4 years 4 weeks ago - 4 years 4 weeks ago #317319 by activha

Replied by activha on topic CB auto action: display fields outside of joomla

That was quick but just got an error on the installer ;-)

Exception Type: Error
File: /var/www/html/components/com_comprofiler/plugin/user/plug_cbautoactions/install.cbautoactions.php
Line: 243
Message: Class 'CB\Plugin\AutoActions\SystemActions' not found

Maybe just an standard server error from our side, it reinstalled very well at third trial; sorry ...

You only stored the event id so no you can't without doing a query to get the title.

So I may just add a second CB query field to store the title depending on the [cb_marketevents] first query field ?
Is this that simple ?

Last edit: 4 years 4 weeks ago by activha.

Please Log in to join the conversation.

krileon
Team Member
OFFLINE
Posts: 68521
Thanks: 9091
Karma: 1434

4 years 4 weeks ago #317322 by krileon

Replied by krileon on topic CB auto action: display fields outside of joomla

Maybe just an standard server error from our side, it reinstalled very well at third trial; sorry ...

It's because this release stopped duplicating the library files. Our old library usage copied the plugin library files to a main library folder for the autoloader to pick up. CB Auto Actions now just extends the auto loader instead of making a copy. This will cause first install to possible fail if CB Auto Actions is already loaded before installing. Second install will clear it up fine.

So I may just add a second CB query field to store the title depending on the [cb_marketevents] first query field ?
Is this that simple ?

I suppose you could add a query field for that yes. I'd just do it in the PHP though. You've access to CBs API including CBs super global database object. Example as follows.

global $_CB_database;

$_CB_database->setQuery( "SELECT `name` FROM `#__groupjive_groups` WHERE `id` = " . (int) '[cb_marketevents]' );
$groupName	=	$_CB_database->loadResult();

Please Log in to join the conversation.

activha
OFFLINE
Platinum Member
Posts: 2278
Thanks: 113
Karma: 13

4 years 4 weeks ago #317323 by activha

Replied by activha on topic CB auto action: display fields outside of joomla

Absolutely perfect !!

Would the CB API database also access any other joomla data in the tables or is it limited to CB ??

The following user(s) said Thank You: krileon

Please Log in to join the conversation.

krileon
Team Member
OFFLINE
Posts: 68521
Thanks: 9091
Karma: 1434

4 years 4 weeks ago #317325 by krileon

Replied by krileon on topic CB auto action: display fields outside of joomla

You've complete access to Joomla and CB. So you can call Joomla API if you wanted. You can query any database table within your Joomla database using the super global provided above as well. Just be careful with how you pass data to the database or you could end up with SQL injection. Notice in my example I cast the substitution to an integer. Don't allow raw substitution values or anything the user can provide (e.g. from GET, POST, or fields) to reach the database unfiltered.

The following user(s) said Thank You: activha

Please Log in to join the conversation.

activha
OFFLINE
Platinum Member
Posts: 2278
Thanks: 113
Karma: 13

4 years 1 week ago #317827 by activha

Replied by activha on topic CB auto action: display fields outside of joomla

Coming back on this I have some difficulties getting substitutions to work like this :

$_CB_database->setQuery( "SELECT * FROM `#__groupjive_plugin_events` WHERE `id` = " . (int) '[cb_marketevents]' );
$event	=	$_CB_database->loadAssoc();
$eventname = $event['title'] . ': [cb:if user="' . $event['user_id'] . '" usergroup includes "18"][cb:userdata field="cb_marketing_multiplier" user="' . $event['user_id'] . '" /] €[cb:else]2 €[/cb:else][/cb:if]';
return array( 'username' => '[username]', 'user_id' => '[user_id]', 'campagne_id' => '[cb_marketevents]', 'campagne_title' => $eventname);

While this works fine

//$_CB_database->setQuery( "SELECT `title` FROM `#__groupjive_plugin_events` WHERE `id` = " . (int) '[cb_marketevents]' );
//$eventName	=	$_CB_database->loadResult();
//return array( 'username' => '[username]', 'user_id' => '[user_id]', 'campagne_id' => '[cb_marketevents]', 'campagne_title' => $eventName);

It seems like

[cb:if user="' . $event['user_id'] . '" usergroup includes "18"][cb:userdata field="cb_marketing_multiplier" user="' . $event['user_id'] . '" /]

is not substituted

Mind to tell if I made a mistake somewhere ?
$row loads all correct data and user group is correct also

Please Log in to join the conversation.

Moderators: beat, nant, krileon

Time to create page: 0.448 seconds

CB auto action: display fields outside of joomla

Search

Login / Logout

Menu

User Menu