CiviCRM Community Forums (archive)

Hi,

I'm developing a Joomla website that has custom requirements as below; and all the process needs to be done on the front-end by end-user

1) The owner of the website should have members under it. I think this should be done by creating a "contribue" page for signing up for membership.
2) The membership should be different type. e.g. gold, silver, etc.
3) Critical: Member can also have other members and a member has to pay while singing up for total of all members under it. (e.g. if $100 is for gold membership, so for three members: it's $300) Not sure how to create hierarchy here. and as I think it needs to be dynamic, so while singing up can add as many members and eventually pay fees accordingly.
4) Events Registration: need to have different prices;
    1) Gold members
    2) Silver members
    3) for non-members (non-users) can directly register for event.
5) Member can login to site and update their details plus their members' details

I have tried my three days solving these problems with no luck, appreciated if someone can help here.

Thank you.

Hi sachuit,

The owner of the website should have members under it. I think this should be done by creating a "contribue" page for signing up for membership.

Yes you can make contribution page for membership signup.

The membership should be different type. e.g. gold, silver, etc.

You can easily add/edit memberships types ( civicrm/admin/member/membershipType&reset=1 ).

#3 not sure what u want exactly but I would like to suggest you to take a look @ priceset ( priceset with field having count )

Events Registration: need to have different prices;   

This can be done by implementing hook_civicrm_buildAmount.

Hello,

I have been able to differentiate the prices for events using their weight, but fees must be entered in the same weight order as membership weight order. e.g. Membership weight order; gold, silver then the fees for events must be gold, silver, general.

Not sure if it's the correct solution, new ideas are most welcome. Below is code I came up with;

/*
Parameters
    * $pageType - is this a 'contribution' or 'event'
    * $form - reference to the form object
    * $amount - the amount structure to be displayed
*/
function joomla_civicrm_buildAmount( $pageType, &$form, &$amount )
{
   if ($pageType == 'event')
   {
      $session =& CRM_Core_Session::singleton();
      $userID  = $session->get( 'userID' );
      $event_id = $_GET['id'];
      $t = "civicrm_event.amount.".$event_id;
      $event_qry = "SELECT cov.label, cov.value FROM civicrm_option_value cov, civicrm_option_group cog, civicrm_event ce
            WHERE
               cov.option_group_id = cog.id AND
               cog.name = '{$t}' AND
               ce.id = $event_id";
      $event_res = mysql_query($event_qry);

      require_once 'CRM/Member/BAO/Membership.php';
      $ft_allMembershipTypes = getMembershipTypes();
      
      if ( $userID ) {
         $membership = CRM_Member_BAO_Membership::getContactMembership( $userID, null, null );
         if ( CRM_Utils_Array::value( 'is_current_member', $membership ) )
         {
            foreach ($ft_allMembershipTypes as $index => $ft_allMember)
            {
               if ($ft_allMember['id'] == $membership['membership_type_id'])
               {
                  foreach ($amount as $amountId => $amountInfo)
                  {
                     if ($ft_allMember['id'] != $amountInfo['weight'])
                     {
                        unset($amount[$amountId]);
                     }
                     else
                     {
                        $form->_values['event']['default_fee_id'] = $amountInfo['amount_id'];
                        $amount[$amountId]['label'] = "";
                        //foreach ($ft_allMembershipTypes as $index => $ft_allMember)
                        while ($row = mysql_fetch_array($event_res))
                        {
                           $amount[$amountId]['label'] .= "<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * $ {$row['value']} for {$row['label']}";
                        }
                     }
                  }
               }
            }
         }
      }
      else
      {
         foreach ( $amount as $amountId => $amountInfo ) {
            if ($amountInfo['weight'] == 3)
            {
               $amount[$amountId]['label'] = "";
               //foreach ($ft_allMembershipTypes as $index => $ft_allMember)
               while ($row = mysql_fetch_array($event_res))
               {
                  $amount[$amountId]['label'] .= "<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * $ {$row['value']} for {$row['label']}";
               }
            }
            else
               unset($amount[$amountId]);
         }
      }
   }
}

function getMembershipTypes($public = true)
{
   $membershipTypes = array();
   $membershipType = & new CRM_Member_DAO_MembershipType( );
   $membershipType->is_active = 1;
   if (  $public ) {
      $membershipType->visibility = 'Public';
   }
   $membershipType->find();
   $c = 0;
   while ( $membershipType->fetch() ) {
      $membershipTypes[$c]['id'] = $membershipType->id;
      $membershipTypes[$c]['name'] = $membershipType->name;
      $c++;
   }
   return $membershipTypes;
}

Thank you all.