Change CB Query Field data on profile-edit and SQL update DB on save.

Hi,

Our GJ Group owners need to maintain extra group related data in tables from other Joomla extensions. It would be nice if they could do all their website changes at one place. So I am looking for a way that my GJ Group owners can check and change these group related values on their CB profile edit.

I don't want to store any kind of this data in any JoomlaPolis (CB and GJ) table. This because some CB users don't own any GJ Group, while there are also users owning 20+ groups. Besides that, group ownership can be changed at any moment by them after deleting their groups or handing over their ownership.

Showing and not saving these values on profile-edit is very easy with a CB Query Field. But how can I make these field values (temporary) editable in the profile-edit mode? So that on profile save (onBeforeUserProfileSaved), a CB Auto Action(s) can execute a SQL update to put the changed data value back in the (non-JoomlaPolis) table field where they reside.

Hope you can help me. It would be so great if users could change all their related personal and group data in their CB profile-edit mode, even when that data reside in tables from other Joomla extensions. For example, so that the sales targets of a group (which value is stored in a Joomla Sales Administration extension), can be changed by the GJ group owners when this manager is editing his/her CB Profile.

With kind regards,
Noa

Create a Custom HTML field then add whatever inputs you want to it using standard HTML. Use onBeforeUserUpdate to apply any server side validation checks you may need. If it fails your validation use the below to throw an error and interrupt the save.

Next use onAfterUserUpdate to store your inputs. All of this you'll need to code yourself using PHP in a Code action. You'll need to access the inputs directly from POST, which you can do using substitutions if you like (e.g. [post_INPUTNAME]).

Thanks for your answer.

Okay, good point, I will try to use a Custom HTML field for the temporary display and edit option on profile-edit.

- But how do I insert the result of a SQL select in that Custom HTML field when onBeforeUserProfileEditDisplay is triggered?

You'll need to access the inputs directly from POST, which you can do using substitutions if you like (e.g. [post_INPUTNAME]).

What do you mean with that? Isn't there an easier way to grep the temporary input in that Custom HTML field and use that in a SQL update statement onAfterUserUpdate?

 - But how do I insert the result of a SQL select in that Custom HTML field when onBeforeUserProfileEditDisplay is triggered?

You'd need to use a Code field in that case and supply whatever PHP you like to render your custom edit field.

What do you mean with that? Isn't there an easier way to grep the temporary input in that Custom HTML field and use that in a SQL update statement onAfterUserUpdate?

The easiest way to get the POST data for your custom inputs is to use substitutions. For example lets say I have a text field with name="group_name" then I can get that using [post_get_name]. So yes you could use a Query action if you wanted to here, but be sure to use format functions to sanitize the data. Example as follows.

Notice the clean format function. This will sanitize it to a string. SQL quotes will automatically be escaped so you shouldn't need to deal with those.