CiviCRM Community Forums (archive)

Yes, a script would be the right approach. See here:

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

for details about the CiviCRM APIs.

Dave, I added the info to my profile, thank's for pointing that out! I didn't realize there was space for it there. Of course, I'm running two different sites with Civi, one on drupal and one on joomla so that just makes it even more fun!

We do use the drupal roles modules currently, and they work well for what they are meant for. The challenge is that I need to validate membership from outside organizations. For example, we work regularly with outside conferences to get our members discounts. They need a way that they can plug in a persons name and e-mail address and get back the type of membership and whether or not it is current.

I'm thinking along the lines of:
  http://mysite.org/validatemember.php?Dan&Foobar&[email]dfoobar@whereami.org[/email]
which might return:
  Dan Foobar <dfoobar@whereami.org> : Founding Member - Current

As Hershel suggested I will probably just build something using the existing APIs, I was just hoping someone had beat me to it already. I have already done a bit of custom coding that I need to write up one of these days (unfortunately most of it goes directly against the db, not via. the API), this one should at least be fairly straight forward.

I am wondering if something would be possible using the civicrm CCK fields and Views  (OK warning I am new to setting up views :-)

I can create a view that gives a link to the user, their current status, membership type and end date.  So far it makes a page with all users.  How can I use  filters or arguments to  limit the view to the current logged in user?   

I would like to make a block that is displayed that would show the users membership status  when they first log in and  on our membership overview page, since we have three membership type signup pages.

(if this needs to be a new thread let me know)
Thanks!
Merlise

Hi Pete

That would be perfect!  (hopefully it will work if there are multiple memberships/contact).  For historical reasons we have 1, 3, or lifetime memberships and with the addition of sections we do not have any way of forcing members to purchase 2 years of a section of their regular membership expires  in 2 years time.     So while they can navigate to their membership tab having a block on the main page when they log in or on the membership page would be really useful.   Course we are running out of space for blocks so we may need to get a new theme!

best,
Merlise

Thanks!

I'll see about modifying it to our needs, but that is exactly the type of thing that we wanted!     

Chris, thanks for the code!

I just spent a bit of time making it more generic, below is what I am going to be installing shortly in a block on lopsa.org. I also added calls to the API to get the membership type and status to remove the hard-coded values. I also took out the MemType1/2 and employer check code as I don't need that here.

If you are running multiple domains you may have to update the line "$params = array ('domain_id' => 1);" with your domain_id -- there doesn't appear to be a way to get civicrm_membership_types_get() to return a full list of all types, you have to pass it at least one parameter.

civicrm_initialize(TRUE);
require_once 'api/v2/UFGroup.php';
require_once 'api/v2/Contact.php';
require_once 'api/v2/Membership.php';
require_once 'CRM/Contact/BAO/Relationship.php';
echo "<style type='text/css'>";
echo ".lhn { line-height:normal; }";
echo "</style>";

global $user;
//echo '$user->uid:'.$user->uid.'<br>';
if ($user->uid) { // Don't do anything if no uid
  $scontactID = civicrm_uf_match_id_get ($user->uid);
  $contactID = intval($scontactID);
 
  if( $contactID==0) { // if 1
    echo '<p class="lhn">Hmmm you do not have a contact id: '.$scontactID.'<br />Please contact us for more information. uid:'.$user->uid."</p>";
  } else {
    // Get contact name and e-mail
    $params = array ('contact_id' => $contactID);
    $contact = civicrm_contact_get($params);
    $contactName = $contact[$contactID]['display_name'] ." &lt;". $contact[$contactID]['email'] ."&gt;";
    if (!$contactName) { // If no display name, use first/last name
      $contactName = $contact[$contactID]['first_name'] . " ". $contact[$contactID]['last_name'] ." &lt;". $contact[$contactID]['email'] ."&gt;";
    }
    if (!$contactName) { // If no name, use e-mail addr
      $contactName = $contact[$contactID]['email'];
    }
   
    // Get membership types
    $params = array ('domain_id' => 1);
    $result = civicrm_membership_types_get($params);
    $memTypeName = array();
    foreach ($result as $key => $type) {
      $memTypeName[$type['id']] = $type['name'];
    }
   
    // Get membership statuses
    $params = array ();
    $result = civicrm_membership_statuses_get($params);
    $memStatusName = array();
    foreach ($result as $key => $type) {
      $memStatusName[$type['id']] = $type['name'];
    }

    // Get membership info
    $result = civicrm_contact_memberships_get($contactID);
   
    if ( civicrm_error ( $result )) { // if 2
      echo'<p class="lhn">FAILED: '. $result['error_message'] . "</p>";
    } else {
      $RenewUrl = '/civicrm/user?&amp;reset=1';
     
      // Look through all returned memberships
      $MemsCount = $result['record_count'];
      $Memberships = array();
      if( $MemsCount>0) {
$cid = $result[$contactID];
foreach($cid as $key => $mem) {
  //echo "<hr>key=$key<pre>";
  //print_r($mem);
  //echo "</pre>";
  if (! $mem['is_test']) {
    $memStatus = $memStatusName[$mem['status_id']];
    $StatusIsCurrent = ((strcmp($memStatus,'New') == 0) ||
(strcmp($memStatus,'Current') == 0));
    $StatusIsExpired = ((strcmp($memStatus,'Grace') == 0) ||
(strcmp($memStatus,'Expired') == 0));
    $StatusIsPending = ((strcmp($memStatus,'Pending') == 0));
    $ThisEndDate = $mem['membership_end_date'];
    $ThisTypeId = $mem['membership_type_id'];
    $ThisMemId = $mem['membership_id'];
    $BestMembership =& $Memberships[$ThisTypeId];
    if( !isset($BestMembership)) {
      $BestMembership = array();
      $Memberships[$ThisTypeId] =& $BestMembership;
    }
    if( !$BestMembership['Current']) {
      if( !($StatusIsCurrent || $StatusIsExpired)) {
if( $StatusIsPending) {
  $BestMembership['AtLeastOnePending'] = true;
} else
  $BestMembership['SomeOtherStatus'] = $memStatus;
      } else {
if( $StatusIsCurrent) {
  $BestMembership['Current'] = true;
  $BestMembership['EndDate'] = $ThisEndDate;
  $BestMembership['MemId'] = $ThisMemId;
} else {
  if( !isset($BestMembership['EndDate'])) {
    $BestMembership['EndDate'] = $ThisEndDate;
    $BestMembership['MemId'] = $ThisMemId;
  } else if( $ThisEndDate > $BestMembership['EndDate']) {
    $BestMembership['EndDate'] = $ThisEndDate;
    $BestMembership['MemId'] = $ThisMemId;
  }
}
      }
    }
  }
} // end foreach
     
unset($BestMembership);
foreach($Memberships as $MembershipType => $BestMembership) {
  echo "<p class='lhn'>$contactName<br/>\nMember ID: $contactID<br/>";
 
  $MembershipEndDate = $BestMembership['EndDate'];
  if( !isset($MembershipEndDate)) {
    if( isset($BestMembership['AtLeastOnePending']))
      echo 'You have a Pending '.$memTypenme[$MembershipType].' membership - have you sent in your payment?';
    else if( isset($BestMembership['SomeOtherStatus']))
      echo 'You have '.$memTypeName[$MembershipType].' membership status '.$BestMembership['SomeOtherStatus'];
  } else {
    $MEDts = strtotime($MembershipEndDate);
    if( $MEDts)
      $MembershipEndDate = date("jS F Y",$MEDts);
    if( $RenewUrl) {
      $MemId = $BestMembership['MemId'];
      if( $MemId)
$RenewUrl = "/civicrm/contribute/transact&amp;id=$MembershipType&amp;mid=$MemId&amp;reset=1";
    }
    if( isset($BestMembership['Current'])) {
      echo $memTypeName[$MembershipType]." member until $MembershipEndDate.<br/>";
      if( $RenewUrl)
echo "<a href='$RenewUrl' title='Renew now'>Click here to renew</a>.";
    } else {
      echo 'Your '.$memTypeName[$MembershipType].' membership expired on '.$MembershipEndDate.'.<br/>';
      if( $RenewUrl) {
echo "<a href='$RenewUrl' title='Renew now'>Click here to renew</a>.";
      }
    }
  }
  echo "</p>";
} // foreach $Memberships
      } else {
echo '<p class="lhn">You are not a member. If you think you should be, please contact us.</p>';
      } // if count
    } // endif 2
  }  // endif 1
 }
?>


Whizzywhig was the problem!  disabled it for blocks and now the code does evaluate.

Looks like I need to tweak a few things for the most recent  code post  (just posting in case anyone else will use)

1) doesn't display membership status if there is more than one current membership  (need to look more closely at Best Membership)
2) the  renew url is going to arbitrary contribution pages  (we have 3 membership pages and several donation pages - soon to be 1  yeah!!! :-)

In any case  this is a great start! 

Thanks!
m