5102 Posts in 1520 Topics by 1116 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 251 Views |
-
Asigning member from one group to a page (has_one)
10 March 2012 at 7:59am
Hi all,
I have a product page which has "has_one" => 'member' .
What i would like to create - is a Tab in CMS where i could list has_one list (radiobuttons) but ONLY WITH MEMBERS from certain group (for example group id =4) .
Basically as I've got around 500 users (and growing) as buyers and only 4-5 as sellers. I knwo how I can show ALL members , however not sure how to strict the list to buyers only.
Any help would be appreciated
-
Re: Asigning member from one group to a page (has_one)
10 March 2012 at 9:25am
Thanks to IRC - adding some query WHERE and JOIN clauses helped :
jus in case someone will be looking for same solution heres my code:
$tablefield = new HasOneComplexTableField(
$this, //controller
'Seller', //name
'Member', //source
array( //fields
'FirstName' => 'First Name',
'Email' => 'Email'
),
'getCMSFields_forPopup', //detail form fields
'"Group_Members"."GroupID" = 4',
'',
'JOIN "Group_Members" ON "Member"."ID" = "Group_Members"."MemberID"'
);
$tablefield->setParentClass('Member');$fields->addFieldToTab( 'Root.Content.Pardavejas', $tablefield );
| 251 Views | ||
|
Page:
1
|
Go to Top |
