CiviCRM Community Forums (archive)

I'm running CiviCRM 3.4 On Drupal 6. I would like to add a block (or link) to the user's Drupal account page that would display their membership type as well as expiry date and a "Renew now" link to the appropriate contrib page.

Is their an "easy" way to do this with little or no programming knowledge ?

You could also use views with civicrm views integration to accomplish that.

It's probably really specific to my install, but here is the block I use. If nothing else, you'll need to change the RenewUrl to point to the correct membership contribution page id.

This is based on someone else's code that was posted to the forums a year or so ago, but I didn't keep a reference to it.

<?php
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; font-size: 90%;}";
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'];
    if (!$contactName) { // If no display name, use first/last name
      $contactName = $contact[$contactID]['first_name'] . " ". $contact[$contactID]['last_name'];
    }
    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 for
      
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("j-M-Y",$MEDts);
    if( $RenewUrl) {
      $MemId = $BestMembership['MemId'];
      if( $MemId)
$RenewUrl = "/civicrm/contribute/transact&amp;id=5&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
 }
?>


Here is the version (modded form of the above) that we're using.

It would be good to update this to use api ver 3 rather than 2 but for now it works.

I'm sure it will need updating/customizing in various ways.

Also I used "MyOrg" to stand for your organization's name--you'll either need to change this or re-word things.

I copy & paste this code into a php block in the right sidebar that shows for authenticated users (under drupal you can set blocks to use php code, so it is just a block set to 'php code' and then this code pasted inside).

<?php
global $user;
echo "<p><strong>" . $user->name . "</strong>" . " | " .  t("<a href='/logout'>Log Out</a><br>");
echo t("<a href='/user'>Your account and e-news subscriptions</a><p>");

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';
$userDashboardURL="/civicrm/user?reset=1";
https://MyOrg.org/civicrm/user?reset=1
echo '<div style="padding-right: 5px;padding-left: 5px;border-color: #294D61;border-style:outset;border-width: 1px;">';
echo '<h2 class="title">MyOrg Membership Status</h2>';


echo "<style type='text/css'>";
echo ".lhn { line-height:normal; font-size: 90%;}";
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">This account does not have a membership contact id.<br />Either you are not a MyOrg member, or this account is not properly connected with your MyOrg membership account. Please <a href="/contact">contact us</a> if you feel this is a mistake. Include this info: 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'];
    if (!$contactName) { // If no display name, use first/last name
      $contactName = $contact[$contactID]['first_name'] . " ". $contact[$contactID]['last_name'];
    }
    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">ERROR: '. $result['error_message'] . "</p>";
    } else {
      //$RenewUrl = '/civicrm/user?&amp;reset=1';
      $RenewUrl = '/join';
      
      // Look through all returned memberships
      $MemsCount = $result['record_count'];
      $Memberships = array();
      $MemberSince="";
      if( $MemsCount>0) {
$cid = $result[$contactID];
foreach($cid as $key => $mem) {
  //echo "<hr>key=$key<pre>";
  //print_r($mem);
  //echo "</pre>";
    
    //bhugh - we're going to count test memberships, too
  //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'];
            $ThisMemberSince = $mem['join_date'];
            //echo $ThisMemberSince;
    $ThisTypeId = $mem['membership_type_id'];
    $ThisMemId = $mem['membership_id'];
 
            if ($MemberSince=="") $MemberSince=$ThisMemberSince;
            elseif ($ThisMemberSince<$MemberSince)$MemberSince=$ThisMemberSince;
    
            $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 if test
} // end for
        //we go through all the memberships. The one with the latest expiration date is the controlling one.
unset($BestMembership);
  $lastMembershipEndDate="";
  $start=1;     //make sure at least one membership

foreach($Memberships as $MembershipType => $BestMembership) {
          $MembershipEndDate = $BestMembership['EndDate'];
          //print_r($BestMembership);
          if ($start==1 OR 
              (isset ($MembershipEndDate) && isset ($lastMembershipEndDate) && $MembershipEndDate > $lastMembershipEndDate) OR 
              (isset($MembershipEndDate) && ! isset ($lastMembershipEndDate)  )  
          ) {
                $start=0;
                $lastMembershipEndDate=$MembershipEndDate;  
                $lastBestMembership=$BestMembership;
                $lastMembershipType= $MembershipType;

          }
  } //foreach
        
  $MembershipEndDate = $lastMembershipEndDate;  
  $BestMembership = $lastBestMembership;
  $MembershipType = $lastMembershipType;
  //print_r($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 - payment in process.';
    else if( isset($BestMembership['SomeOtherStatus']))
      echo 'You have '.$memTypeName[$MembershipType].'membership status '.$BestMembership['SomeOtherStatus'];
  } else {
    $MEDts = strtotime($MembershipEndDate);
    if( $MEDts)
      $MembershipEndDate = date("j-M-Y",$MEDts);
            $MEDts = strtotime($MemberSince);
    if( $MEDts)
      $MemberSince = date("j-M-Y",$MEDts);
    if( $RenewUrl) {
      $MemId = $BestMembership['MemId'];
      if( $MemId)
$RenewUrl = "/membership";
    }
    if( isset($BestMembership['Current'])) {
        echo "<br>";
        if (strlen ($MemberSince)>0) echo "Member since $MemberSince<br>";
      echo $memTypeName[$MembershipType]." membership valid thru $MembershipEndDate<br><br> ";
              
      if( $RenewUrl)
echo "<a href='$RenewUrl' title='Renew now'>Click here to renew</a> - or <a href='http://MyOrg.org/donate'>make a donation.</a>";
    } else {
      echo '<br><b>Your '.$memTypeName[$MembershipType].' membership expired on '.$MembershipEndDate.'<b><br><br>';
      if( $RenewUrl) {
echo "<b><a href='$RenewUrl' title='Renew now'>Click here to renew now!</a></b>";
      }
    }
  }
  echo "</p>";
//} // foreach $Memberships
      } else {
echo '<p class="lhn">No membership is associated with this account. Is this an error? Please <a href="/contact">contact us</a>.</p> <p class="lhn"><a href="'.$RenewUrl.'">Click here to join.</a></p>';
      } // if count
    } // endif 2
  }  // endif 1
 }
//echo "<br><br>";
echo "<p class=\"lhn\"><a href=\"$userDashboardURL\">See your contribution summary page.</a></p>";

echo "<p class=\"lhn\"><a href=\"/user\">View/update your account & contact information.</a></p>";

echo "</div>";
?>

We've got a version of the code given by flug and sjthespian  running fairly well.  The only issue we have is with Life Members not showing up and the logs complaining of an undefined index: membership_end_date in eval(0) (line 71) of the php module we created. 
Anyone have a more recent version of the code we might try?  What we have right now is this:

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;
        }