CiviCRM Community Forums (archive)

Hi,

No idea what happened to your karma to drop, but that's certainly not the criteria to decide if I'll answer a post, nor is that one for others in the community. On the other hand posting on a week-end and going all "No one will tell me, but apparently it is stopping ANYONE from answering my questions, and that is WRONG" conspiracy theory 3 minutes after your post is unlikely to motivate contributors to jump in

ESR is providing some useful tips on how to seek for help, you might want to read it http://www.catb.org/~esr/faqs/smart-questions.html

Moreover, put as the subject what is your problem. Finding someone that is going to tell you who developed the CCK node contact reference is not your problem, and no matter who wrote it, might not be the person that will help you solving your problem

Ok, let's rewind shall we?

Can you start by explain what you're trying to achieve, what do you mean by print, what are the criteria to fetch addresses ? Not sure I understood based from the code you posted (eg what is the contact_id= 7 hardcoded ?) nor how you plan to use it.

Anyway, I would suggest you to use the api instead of going directly at the mysql layer, your code will be much more robust (and easier to maintain).

i'd suggest to start fresh on a new thread.

X+

Thanks so much Xavier!

First- regarding using the "API".  I have never used an API and have no idea how to use one.  The learning curve simply terrifies me.   Is it easy?  How would I even learn how to use it?  I have absolutely no clue how I would learn about using the API.  I don't even know where the API is, and the term has always scared me since I tried to figure out the PayPal SOAP/XML api  and couldn't figure it out.  No one's ever given me any good instruction about APIs.

Second, I didn't realize that you can't tell what I'm trying to achieve.  I'll try to be really clear and explain what I've tried.

The Special Olympics holds training/practices for the athletes.  The practices get posted and placed on a calendar, as do competitions.  This is not a problem in Drupal.  However, the Practice node content page should list the location ADDRESS, not just the name.  With the current accessiblity of CiviCRM in the node, I ONLY can get a contact reference, which displays ONLY the name of the location on the Practice screen.  Also it's a link to the CiviCRM contact screen and I don't really want that screen exposed to Anonymous users because of the secondary tabs and extra information that's exposed.

So the Practice Listing reads like this:

Oakland Aquatics

Sport
Aquatics

Head Coach
Coach To Be Announced   <--link to CiviCRM contact (not desired but not an issue in this case)

Practice Location
Live Oak Memorial Pool  <--link to CiviCRM contact (not desired)

Dates

Repeats every week until Tue Jun 21 2011 except Mon Mar 28 2011.
Sat, 03/26/2011 - 10:00am
Sat, 04/02/2011 - 10:00am
Sat, 04/09/2011 - 10:00am
Sat, 04/16/2011 - 10:00am
Sat, 04/23/2011 - 10:00am
Sat, 04/30/2011 - 10:00am
Sat, 05/07/2011 - 10:00am
Sat, 05/14/2011 - 10:00am
Sat, 05/21/2011 - 10:00am
Sat, 05/28/2011 - 10:00am
Sat, 06/04/2011 - 10:00am
Sat, 06/11/2011 - 10:00am
Sat, 06/18/2011 - 10:00am

And it SHOULD show the address also, like this, ideally:

Oakland Aquatics

Sport
Aquatics

Head Coach
Coach To Be Announced

Practice Location
Live Oak Memorial Pool
1055 MacArthur Boulevard
Oakland, CA  94610

Dates

Repeats every week until Tue Jun 21 2011 except Mon Mar 28 2011.
Sat, 03/26/2011 - 10:00am
Sat, 04/02/2011 - 10:00am
Sat, 04/09/2011 - 10:00am
Sat, 04/16/2011 - 10:00am
Sat, 04/23/2011 - 10:00am
Sat, 04/30/2011 - 10:00am
Sat, 05/07/2011 - 10:00am
Sat, 05/14/2011 - 10:00am
Sat, 05/21/2011 - 10:00am
Sat, 05/28/2011 - 10:00am
Sat, 06/04/2011 - 10:00am
Sat, 06/11/2011 - 10:00am
Sat, 06/18/2011 - 10:00am

Note that the calendar module creates an automatic link, so I cannot redirect this to a page made from a node View mixed with a Civi View. When I use DEVEL's Execute Php Code tool, I can get the address, perfectly, when I submit this code:

db_set_active('cividb');

$data = db_query('SELECT DISTINCTROW street_address, supplemental_address_1, city, county_id, civicrm_state_province.abbreviation, postal_code FROM civicrm_address INNER JOIN civicrm_state_province ON state_province_id = civicrm_state_province.id WHERE is_primary =1 AND contact_id =7') or die(mysql_error());

 while($info = mysqli_fetch_array( $data ))
 {
 Print $info['street_address']."\n";
 if ($info['supplemental_address_1']) {Print $info['supplemental_address_1']."\n";};
 Print $info['city'].", ".$info['abbreviation']."  ".$info['postal_code']."\n";
 }

db_set_active('default');

This code works in that screen, within the databse, within Drupal.

I have successfully stored this code in the Content Template now, replacing "=7" with the node variable:

<?php
db_set_active('cividb');

$sql = "SELECT DISTINCTROW street_address, supplemental_address_1, city, county_id, civicrm_state_province.abbreviation, postal_code FROM civicrm_address INNER JOIN civicrm_state_province ON state_province_id = civicrm_state_province.id WHERE is_primary =1 AND contact_id =".print $node->field_prac_location[0]['contact_id'];

$data = db_query($sql) or die(mysql_error());

 while($info = mysqli_fetch_array( $data ))
 {
 Print $info['street_address']."\n";
 if ($info['supplemental_address_1']) {Print $info['supplemental_address_1']."\n";};
 Print $info['city'].", ".$info['abbreviation']."  ".$info['postal_code']."\n";
 }

db_set_active('default');
?>

But when I run this it simply adds the number 7 to the screen, not the address:

Oakland Aquatics

Sport
Aquatics

Head Coach
Coach To Be Announced

Practice Location
Live Oak Memorial Pool

7

Dates

Repeats every week until Tue Jun 21 2011 except Mon Mar 28 2011.
Sat, 03/26/2011 - 10:00am
Sat, 04/02/2011 - 10:00am
Sat, 04/09/2011 - 10:00am
Sat, 04/16/2011 - 10:00am
Sat, 04/23/2011 - 10:00am
Sat, 04/30/2011 - 10:00am
Sat, 05/07/2011 - 10:00am
Sat, 05/14/2011 - 10:00am
Sat, 05/21/2011 - 10:00am
Sat, 05/28/2011 - 10:00am
Sat, 06/04/2011 - 10:00am
Sat, 06/11/2011 - 10:00am
Sat, 06/18/2011 - 10:00am

7 *IS* the contact ID, so it's just printing the node variable correctly but ignoring all my other php.

I am also trying this in node-practice.tpl.php but Drupal 6 seems to be ignoring the custom module.

If the aPI method is pretty easy to learn, it'd be great to see a no-brainer tutorial, if one exists.

Thanks so much Xavier!  Yes, I tend to be a bit paranoid because Don Lobo yelled at me the VERY first day I was here, saying that I did several things wrong.  I'm not a perfect person, just a good geek.

I don't think I ever heard or seen lobo yelled, and believe me, I screwed up my fair share of code in civi Both in the forums and in real life, he genuinely tries to help and understand that we don't have his knowledge of the software.

As for the API, that's fairly simple since api v3

http://civicrm.org/API_version_3
http://wiki.civicrm.org/confluence/display/CRMDOC40/CiviCRM+Public+APIs

Try using (assuming you have updated to civicrm 3.4) /civicrm/ajax/doc  (choose address, get)

$results=civicrm_api("Address","get", array ('version' =>'3', 'contact_id' =>'7'));

Also, we're at CiviCRM 3.3.6 and I'm scared of trying to upgrade during this high development time and screw everything up.  What do you think- it's a super-easy upgrade?  Thanks again.

If you go to the link Xavier posted there is also instructions to backport api v3 to 3.3.6 or earlier - that is a no risk option (actually - the instructions might be on this board somewhere - you basically just get the latest version of api.php & the v3 folder out of the CiviCRM code base)

You can use the code given in any module but you may need to add

    if ( ! civicrm_initialize( ) ) {
        return;
    }

first to ensure it can find the api.php file

Thank you Eileen.  I hope I can work through it.  But it's like visiting Mars.

When you write "you can use in any module" you mean node templates as well?  I'm not sure where modules bgin and end- I didn't think a template was a module.

I'll try that backport.  I guess you're both implying that I do NOT want to use V2.

Thanks, we'll see how this goes.

So this is probably what I'll code then?

  if ( ! civicrm_initialize( ) ) {
        return;

        require_once 'api/api.php';   <!-- <- does all my code go inside these brackets so that it won't run if there's no civicrn_initialize? -->

        $contid = $node->field_prac_location[0]['contact_id']
        $results=civicrm_api("Address","get", array ('version' =>'2', 'contact_id' =>$contid));
        Print $results[street_address];
    }

Or is it like this?

  if ( ! civicrm_initialize( ) ) {
        return;
    }

        require_once 'api/api.php';   <!-- <- does all my code go inside these brackets so that it won't run if there's no civicrn_initialize? -->

        $contid = $node->field_prac_location[0]['contact_id']
        $results=civicrm_api("Address","get", array ('version' =>'2', 'contact_id' =>$contid));
        Print $results[street_address];

But then it seems like the code will still run regardless of the result of the function call to initialize.  Or maybe nothing else on the page will render.

When I tried the require once in the DEVEL code tester, it never worked. 

But thanks again!

Thanks, and I just checked my api folder- there's no actual api.php in there!  So no wonder the require_once didn't work!  Now I'm off to do the backport.