CiviCRM Community Forums (archive)

Hmm there is not a standard profile you can use as far as I know, and the Drupal Webforms - CiviCRM integration does not help you on Joomla :-)
So unless a Joomla CiviCRM expert has another idea, you would probably use the standard membership profile, and create a civicrm hook (buildForm) to add the kids. I would assume you would find them because they have a certain relationship with the 'head' member? You can use the CiviCRM API to get data from the database. Then use a post or a postProcess hook (one is on the DB action, the other on the form - whatever does the job best for you) to process the additional data with the API. Details on hooks and API can be found here : http://book.civicrm.org/developer

The simplest as far as I am concerned is using the API to retrieve and update data from/to CiviCRM. But I will leave it to experienced Joomla dudes and dudettes :-)

The easiest way is to look at the folder /civicrm/api/v3/examples. You will find examples of PHP usage there. There is also the API explorer (<yoursite>/civicrm/api/explorer) that will assist you in what is possible.
Example of PHP code to create an activity:
    $actParams = array(
        'version'           =>  '3',
        'source_contact_id' =>  '150',
        'target_contact_id' =>  $targetID,
        'activity_type_id'  =>  $actType,
        'status_id'         =>  '2',
        'subject'           =>  $actSubject,
        'details'           =>  $actDetails );
    $actData = civicrm_api( 'Activity', 'Create', $actParams );
    if ( $actData['is_error'] == 1 ) {
        $result['is_error'] = '1';
        $result['error_msg'] = $actData['error_message'];
    } else {
        $result['is_error'] = '0';
        $result['activity_id'] = $actData['id'];
    }


So how do you know they belong together in the first place? Or am I missing something?

Actually I had another brain storm to keep me from having to delve to far into the API docs.  I can simply create an intermediary PHP page to manage the "landing page" for membership renewal or editing, all i need to know is what table holds the linking relationship of Joomla UserID and associated Civicrm Contact ID, then i can query the database for all contacts that are of the same email address of the AUTHENTICATED user -- granted i would have to disallow changing email addresses in the CMS once you create an account, display them with a link(s) of all possible members they "own" then, on the postback of the link it swaps the userid in the civicrm table and loads the appropriate page easy peasy lemon squeezy. 

Anyone know?

David

I did see Eileen's post on the other thread and looked at that one and it seems like it could be useful but I posted some additional questions for her there.  It seems to me however that switching the session just is the 10 lines of code solution to my entire problem and retains all my business logic and makes no core hacks or hooks even necessary for CIVICRM and in my opinion those are always good things in programming projects.   Also I need to allow editing of these "child memberships" from a central login, which that module may not do (I asked in the other thread) What are the specific reasons for not switching user sessions?

Because if I wrote a module to allow for that I'd be done tonight I think.  Is there a way to swap sessions? Or would I have to force a logout of the Joomla CMS and make them login again (validate login before editing another member...would be how i'd sell it)

I can easily have a landing page that says something like:

Your Members
Richard Richardson (MemberID 1000)
Sally Jones (MemberID 500)
Tom Jones (MemberID 1232)
Bill Richardson (MemberID 1533)

and when you click it, the table ids are swapped and joomla logs out the user simply with the code:

$app = JFactory::getApplication();
$app->logout( $user_id );

Then redirects them to my "validate your credentials to continue Editing Member Bill Richardson..." Page

My key question that would have the crux of this project done is:
1) How can I repopulate the CIVICRM Cache Progratically in PHP without logging out and logging back into the CMS?

Also to give you a concept of the impact of the same email address being used for 2 or more contacts (for better or worse) we have over 1000 contacts in our 10000+ membership that a duplicate email, some clubs registered all contacts under their name and have 32 members as their email!! So my desire to allow people to edit these things on their own, and not interfere with our long standing business logic is a high priority, and I've been researching CRMS for two years before I made the decision to switch to this one (its a clear winner) So Id love to keep my business logic and take advantage of this Ferrari at the same time.  I'm not opposed to permissioned relationships but the problem there is, its not realtime.  It requires intervention on our part to setup those relationships which already exist by a duplicate email -- and it happens 10% of the time!  I want to work smarter with CiviCRM not harder so I need realtime access to everything with as little user and administrator interaction as possible.  I need a user to pay for a membership and be able to know their ID immediately (so they can mozy on over to tournament registration and register)  We already have a Tournament Registraion website with a membership checking system API that i have hooked up to CIVICRM to prevent athletes from registering if they don't have a valid membership, so a lot is hinging on the realtime ability to get your memberhsip ID and your ability to edit multiple memberships you "own."

Thank you very much I really appretiate all the help I've been given thus far on the forums!

David

I dont think there is a call to delete the cache for one specific user ID / contact ID. We typically delete caches system wide.

I would say, give your approach a shot and see where it runs into issues, if any. then we can think about whats happening and why

lobo