Get user id for SQL custom field

I'm using event booking for users to register their kids for summer camps. Each user has already entered their child's information on the website and this is stored in a database table. The children are linked to their parent via the current users id

My custom field is just going to be a select list with the children's names. I planned to do this with the SQL custom field type, with the query "SELECT child_name AS value, child_name AS text FROM #__child_master WHERE parent_id = $user_id"

I'm just not sure how to get the current user_id in that sql statement. If it were php I could just do JFactory::getUser()->id, but trying that in my statement didn't work.

Any ideas on how I can do this?

Thanks!

I've submitted code for something similar which was to allow the event id to be used. It could easily be modified to let the user id be used.

If you're up to modification you can edit administrator/components/com_eventbooking/libraries/rad/form/field/sql.php and add a string substitution in. I've set mine up so [EVENT_ID] has the ID substituted into the query, the user id would be just as easy and I've thought about adding it.

FYI we have SQL as a FEE field and the event ID is used in the query. I've got the code working to allow it to be quanity field as well but need to submit that in github.

Yeah if you could send me that code that would be awesome!

This is my raw code, you should only need to change the getOptions() function, I've added some extra stuff, but for what you want you should be able to modify it.

*usual disclaimers*

This worked perfectly, thanks so much!

Hi All

We are in the same situation.

Our association is composed of families with multiple children (twins, triplets ..). In our free activities only the children of each family can be registered, and they are always the same.

We need to know how to find the name of a child by the membership number.

In the sql Query we are testing, we look for the child's name and add the year and month of birth (some activities depend on the child's age)

I do not program in php and I do not know how to modify the sql.zip file that I have added in this post to get current user_id

Our SQL Query we use:

SELECT CONCAT (`cb_hijo1pm1`, ', ', LEFT(`cb_fechapartomultiple1`, 7)) as value, CONCAT (`cb_hijo1pm1`, ', ', LEFT(`cb_fechapartomultiple1`, 7)) as text from `#__comprofiler` WHERE cb_numerodesocio = 1747 ( we need to get here current loged $user_id )

This Query gets this Result: Carolina, 2009-03 ( for example)

With this php (php.zip) we can select from a list, but we can´t add a second line on SQL Query (field default values) (dont work) to make a list from diferents Childs from a family.


We have other problems that we do not know how to solve, but i will open another topic to ask about.


Thanks in advance and sorry for my English

Any help Please?

Sorry. I have been so busy today and could not look at this question and answer. I will look at it on tomorrow (too tired now to look at it)

Tuan

Hello

Please try the solution below:

1. Get this file, unzip it, upload it to administrator/com_eventbooking/libraries\rad\form\field folder

2. Then in the SQL command, you can use the tag [USER_ID] . It will be replaced with ID of the logged in user

Actually, I think there is still problem. That will only works when users to register. When admin view the registration record for example, it will be replaced with ID of admin, so we will still have problem

Need better solution. Will try to have a solution for you on Monday

Regards,

Tuan

Hi Tuan

Thanks for the code. Thats work perfect

SELECT CONCAT (`cb_hijo1pm1`, ', ', LEFT(`cb_fechapartomultiple1`, 7)) as value, CONCAT (`cb_hijo1pm1`, ', ', LEFT(`cb_fechapartomultiple1`, 7)) as text from `#__comprofiler` WHERE user_id = [USER_ID]

Why i cant add a second query line to add another list option? this would be perfect to get all chids from a family in only one list