civitest.module.sample

<?php

function civitest_civicrm_pre( $op, $objectName, $objectId, &$objectRef ) {
    // Sample implementation of pre hook on line item row create. Available as of 4.1 beta3
    if ( $objectName == 'LineItem' && $op == 'create' ) {
        //if text type field and quantity is greater than 5, let's apply a discount
        if ( $objectRef['html_type'] == 'Text' &&
             $objectRef['qty'] > 5 ) {

            //5% discount
            $discount = 1 - 0.05;

            $objectRef['unit_price'] = $objectRef['unit_price'] * $discount;
            $objectRef['line_total'] = $objectRef['line_total'] * $discount;

            //we would also need to update the total amount
            //we know the table impacted with $objectRef['entity_table']
            //and the contrib/event id with $objectRef['entity_id']
        }
    }
}

function civitest_civicrm_post( $op, $objectName, $objectId, &$objectRef ) {
    // only interested in the profile object and create operation for now
    if ( $objectName != 'Profile' || ( $op != 'create' && $op != 'edit' ) ) {
        // send it to custom hook
        return false;
    }

    // send an email to the user and cc administrator
    // with a welcome message
    civicrm_initialize( true );

    require_once 'CRM/Utils/Mail.php';

    $params         = array( );
    $fromName       = 'My Org Administrator';
    $fromEmail      = 'info@example.org';
    $params['from'] = '"' . $fromName . '" <' . $fromEmail . '>';

    $params['toEmail']     = $objectRef['email-1'];
    $params['toName']      = "{$objectRef['first_name']} {$objectRef['last_name']}";
    $params['subject']     = "Thank you for supporting My Org";
    $params['cc']          = 'myorg@example.org';
    $objectValues          = print_r( $objectRef, true );
    $params['text'] = "
Dear $toName:

Thank you for your show of support. The details u signed up with are:

$objectValues

Regards

My Org Team
";

    CRM_Utils_Mail::send( $params );
}

function civitest_civicrm_custom( $op, $groupID, $entityID, &$params ) {
    if ( $op != 'create' && $op != 'edit' ) {
        return;
    }

    // this is the custom group i am interested in updating when the row is updated
    if ( $groupID != 1 ) {
        return;
    }

    $tableName = CRM_Core_DAO::getFieldValue( 'CRM_Core_DAO_CustomGroup',
                                              $groupID,
                                              'table_name' );
    $sql = "
UPDATE $tableName
SET    random_code_data_3 = 23
WHERE  entity_id = $entityID
";
    CRM_Core_DAO::executeQuery( $sql,
                                CRM_Core_DAO::$_nullArray );
}

/**
 * Get the permissioned where clause for the user
 *
 * @param int $type the type of permission needed
 * @param  array $tables (reference ) add the tables that are needed for the select clause
 * @param  array $whereTables (reference ) add the tables that are needed for the where clause
 * @param int    $contactID the contactID for whom the check is made
 *
 * @return string the group where clause for this user
 * @access public
 */
function civitest_civicrm_aclWhereClause( $type, &$tables, &$whereTables, &$contactID, &$where ) {
    if ( ! $contactID ) {
        return;
    }

    $permissionTable = 'civicrm_value_permission';
    $regionTable     = 'civicrm_value_region';
    $fields          = array( 'electorate' => 'Integer',
                              'province'   => 'Integer',
                              'branch'     => 'Integer' );

    // get all the values from the permission table for this contact
    $keys = implode( ', ', array_keys( $fields ) );
    $sql = "
SELECT $keys
FROM   {$permissionTable}
WHERE  entity_id = $contactID
";
    $dao = CRM_Core_DAO::executeQuery( $sql );
    if ( ! $dao->fetch( ) ) {
        return;
    }

    $tables[$regionTable] = $whereTables[$regionTable] =
        "LEFT JOIN {$regionTable} regionTable ON contact_a.id = regionTable.entity_id";

    $clauses = array( );
    foreach( $fields as $field => $fieldType ) {
        if ( ! empty( $dao->$field ) ) {
            if ( strpos( CRM_Core_DAO::VALUE_SEPARATOR, $dao->$field ) !== false ) {
                $value = substr( $dao->$field, 1, -1 );
                $values = explode( CRM_Core_DAO::VALUE_SEPARATOR, $value );
                foreach ( $values as $v ) {
                    $clauses[] = "regionTable.{$field} = $v";
                }
            } else {
                if ( $fieldType == 'String' ) {
                    $clauses[] = "regionTable.{$field} = '{$dao->$field}'";
                } else {
                    $clauses[] = "regionTable.{$field} = {$dao->$field}";
                }
            }
        }
    }

    if ( ! empty( $clauses ) ) {
        if ( ! empty( $where )  ) {
            $where .= ' AND (' . implode( ' OR ', $clauses ) . ')';
        } else {
            $where .= ' (' . implode( ' OR ', $clauses ) . ')';
        }
    }
}

function civitest_civicrm_dashboard( $contactID, &$contentPlacement ) {
    // REPLACE Activity Listing with custom content
    $contentPlacement = 3;
    return array( 'Custom Content' => "Here is some custom content: $contactID",
                  'Custom Table' => "
<table>
<tr><th>Contact Name</th><th>Date</th></tr>
<tr><td>Foo</td><td>Bar</td></tr>
<tr><td>Goo</td><td>Tar</td></tr>
</table>
",
                  );
}

function civitest_civicrm_buildAmount( $pageType,
                                      &$form,
                                      &$amount ) {


    //sample to modify priceset fee
    $priceSetId = $form->get( 'priceSetId' );
    if ( !empty( $priceSetId ) ) {
        $feeBlock =& $amount;

        //lets do check for event/contribution.
        if ( !in_array( $pageType, array( 'contribution', 'event' ) ) ||
             !is_array( $feeBlock ) ||
             empty( $feeBlock ) ) {
            return;
        }

        //in case of event we get eventId,
        //so lets apply hook for eventId = 1
        if ( $pageType == 'event' && $form->_eventId != 1 ) {
            return;
        }

        //in case of contrbution
        //for online case we get page id so we could apply for specific
        if ( $pageType == 'contribution' ) {
            if ( !in_array( get_class( $form ), array( 'CRM_Contribute_Form_Contribution',
                                                       'CRM_Contribute_Form_Contribution_Main') ) ) {
                return;
            }
        }

        //start modifying price set fee.
        foreach ( $feeBlock as &$fee ) {
            if ( !is_array( $fee['options'] ) ) {
                continue;
            }
            foreach ( $fee['options'] as &$option ) {
                //for sample lets modify first option from all fields.
                $option['amount'] = 100;
                $option['label']  = ts( 'Power of hooks' );
                break;
            }
        }
    }
    //done w/ priceset sample.

    // only modify the contributon page with id = 1
    if ( $pageType != 'contribution' ||
         $form->_id != 1 ) {
       return;
    }

    // lets add an arbitrary amount here, just to show folks
    // the power of a hook :)
    $amount[1000] = array( 'value'    => 400,
                           'label'     => 'Hook',
                           'amount_id' => 1000 );


    // now lets get a bit more ambitious
    // *GOAL*: lets plan to give 20% discount to students
    $membershipType  = 'Student';
    $discountPercent = 20;

    // get the membership-type-id for the membership-type
    $membershipTypeId = CRM_Core_DAO::getFieldValue( 'CRM_Member_DAO_MembershipType',
                                                     $membershipType,
                                                     'id',
                                                     'name' );

    // get the logged in user id
    $session = CRM_Core_Session::singleton();
    $userID  = $session->get( 'userID' );

    if ( $userID ) {
        // check if logged in user has 'Student' membership
        require_once 'CRM/Member/BAO/Membership.php';
        $membership = CRM_Member_BAO_Membership::getContactMembership( $userID, $membershipTypeId, null );

        // If logged in contact is a member as on today, modify the amount
        // to reflect the discount.
        if ( CRM_Utils_Array::value( 'is_current_member', $membership ) ) {
            foreach ( $amount as $amountId => $amountInfo ) {
                $amount[$amountId]['value'] = $amount[$amountId]['value'] -
                    ceil($amount[$amountId]['value'] * $discountPercent / 100);
                $amount[$amountId]['label'] = $amount[$amountId]['label'] .
                    "\t - with {$discountPercent}% discount (for $membershipType)";
            }
        }
    }
}

function civitest_civicrm_aclGroup( $type, $contactID, $tableName, &$allGroups, &$currentGroups ) {
    // only process saved search
    if ( $tableName != 'civicrm_saved_search' ) {
        return;
    }

    hrd_initialize( );

    $currentGroups = $allGroups;

    if ( ! CRM_Core_Permission::check( 'access secure contacts' ) ) {
        unset( $currentGroups[HRD_SECURE_GROUP_ID] );
    }

    $currentGroups = array_keys( $currentGroups );
}

function civitest_civicrm_tabs( &$tabs, $contactID ) {

    // unset the contribition tab
    unset( $tabs[1] );

    // lets rename the contribution tab with a differnt name and put it last
    // this is just a demo, in the real world, you would create a url which would
    // return an html snippet etc
    $url = CRM_Utils_System::url( 'civicrm/contact/view/contribution',
                                  "reset=1&snippet=1&force=1&cid=$contactID" );
    $tabs[] = array( 'id'    => 'mySupercoolTab',
                     'url'   => $url,
                     'title' => 'Contribution Tab Renamed',
                     'weight' => 300 );
}

function civitest_civicrm_enableDisable( $recordBAO, $recordID, $isActive ) {
     // create an activity for enable/disable relationship type
     if ( $recordBAO == 'CRM_Contact_BAO_RelationshipType' ) {
         $session = CRM_Core_Session::singleton( );
         $uid     = $session->get('userID');
         if( $uid ) {
             $params = array( 'activity_type_id'   => 1,
                              'source_contact_id'  => $uid,
                              'status_id'          => 2,
                              'activity_date_time' => date('YmdHis')
                              );
             if( $isActive ) {
                 $params['subject'] = ts('Enabled relationship type.');
             } else {
                 $params['subject'] = ts('Disabled relationship type.');
             }
             civicrm_api('activity', 'create', $params);
         }
     }
 }

function civitest_civicrm_tokens( &$tokens ) {
    $tokens['contribution'] =
        array(
              'contribution.amount'                    => 'Amount of contribution',
              'contribution.date'                      => 'Date of contribution',
              'contribution.total_last_year'           => 'Total amount contributed last year',
              'contribution.date_of_first'             => 'Date of first contribution',
              'contribution.largest_this_year'         => 'Largest this Year Contribution Amount',
              'contribution.date_of_largest_this_year' => 'Largest this Year Contribution Date',
              'contribution.average'                   => 'Average Contribution Amount',
              'contribution.largest'                   => 'Largest Contribution' );
}

function civitest_civicrm_tokenValues( &$values,
                                       &$contactIDs,
                                       $dontCare,
                                       $tokens,
                                       $context ) {
    if ( is_array( $contactIDs ) ) {
        $contactIDString = implode( ',', array_values( $contactIDs ) );
    }

    $query = "
SELECT sum( total_amount ) as total_amount,
       contact_id,
       max( receive_date ) as receive_date
FROM   civicrm_contribution
WHERE  contact_id IN ( $contactIDString )
AND    is_test = 0
GROUP BY contact_id
";

    $dao = CRM_Core_DAO::executeQuery( $query );
    while ( $dao->fetch( ) ) {
        if ( ! array_key_exists( $dao->contact_id, $values ) ) {
            $values[$dao->contact_id] = array( );
        }
        $values[$dao->contact_id]['contribution.amount'] = $dao->total_amount;
        $values[$dao->contact_id]['contribution.date'  ] = $dao->receive_date;
    }
}

// example of token that does not depend on contactID
// and using the new format
function civitest_civicrm_tokenValues( &$values,
                                       &$contactIDs,
                                       $dontCare,
                                       $tokens,
                                       $context ) {
    if ( isset( $tokens['views'] ) ) {
        static $_cache = null;

        if ( ! $_cache ) {
            $_cache = array( );
            foreach( $tokens['views'] as $token ) {
                $_cache[$token] = CALL_YOUR_OWN_FUNCTION_TO_RENDER_THIS_VIEW( $token );
            }
        }

        foreach( $contactIDs as $cid ) {
            foreach( $tokens['views'] as $token ) {
                $values[$cid]["views.{$token}"] = $_cache[$token];
            }
        }
    }
}

function civitest_civicrm_pageRun( &$page ) {
    // You can assign variables to the template using:
    // $page->assign( 'varName', $varValue );
    // in your template, {$varName} will output the contents of $varValue
    // you should customize your template if doing so

    $page->assign( 'varName', 'This is a variable assigned by the hook' );
}

/*
 * The hook_nodeapi implementation to set the node title to that of event title.
 * Could also be used set the title to anything we want.
 *
 */
function civicrm_nodeapi(&$node, $op, $teaser = NULL, $page = NULL) {
    if ($op == 'load' && $node->type == 'event') {
        $node->title = civicrm_cck_event_field_values('title', $node->field_title[0]['value']);
    }
}

/*
 * The function to pull out event data from civicrm for cck fields related to event.
 *
 */
function civicrm_cck_event_field_values($field, $index = null) {
    static $eventInfo;
    if ( ! $eventInfo ) {
        if ( ! civicrm_initialize( ) ) {
            return;
        }
        $params    = array( );
        $eventInfo = civicrm_api('event', 'get', $params );
    }

    if ( strpos($_GET['q'], 'edit') ||
         strpos($_GET['q'], 'add')  ) {
        $isAppend = true;
    }
    if ( isset( $index ) ) {
        $isAppend = false;
    }

    $retArray = array( );
    switch( $field ) {
    case 'when':
        foreach ( $eventInfo as $info ) {
            $str = "{$info['start_date']} >  through > {$info['end_date']}";
            $retArray[] = $isAppend ? ("{$info['title']}:: " . $str) : $str;
        }
        break;

    case 'location':
        foreach ( $eventInfo as $info ) {
            $params = array( 'entity_id' => $info['id'],'entity_table' => 'civicrm_event');
            require_once 'CRM/Core/BAO/Location.php';
            $values['location'] = CRM_Core_BAO_Location::getValues( $params, true );
            $str = $values['location']['address'][1]['display'];
            $retArray[] = $isAppend ? ("{$info['title']}:: " . $str) : $str;
        }
        break;

    case 'register_link':
        foreach ( $eventInfo as $info ) {
            $str = '<a href="' .
                CRM_Utils_System::url( 'civicrm/event/register',
                                       "id={$info['id']}&reset=1", true ) .
                '">&raquo; Register Now</a>';
            $retArray[] = $isAppend ? ("{$info['title']}:: " . $str) : $str;
        }
        break;

    case 'feeblock' :
        require_once 'CRM/Core/BAO/Discount.php';
        require_once 'CRM/Core/OptionGroup.php';
        foreach ( $eventInfo as $info ) {
            $discountId = CRM_Core_BAO_Discount::findSet( $info['id'], 'civicrm_event' );
            if ( $discountId ) {
                CRM_Core_OptionGroup::getAssoc( CRM_Core_DAO::getFieldValue( 'CRM_Order_DAO_Discount',
                                                                             $discountId, 'option_group_id' ),
                                                $feeBlock, true, 'id' );
            } else {
                CRM_Core_OptionGroup::getAssoc( "civicrm_event.amount.{$info['id']}", $feeBlock, true );
            }

            $feeLabels = array();
            foreach ( $feeBlock as $block ) {
                $feeLabels[] = $block['label'] . "  $" . $block['value'];
            }
            $str  = '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;' . implode($feeLabels, '<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;');
            $retArray[] = $isAppend ? ("{$info['title']}:: " . $str) : $str;
        }
        break;

    default:
        foreach ( $eventInfo as $info ) {
            if ( isset($info[$field]) ) {
                $str = $info[$field];
                $retArray[] = $isAppend ? ("{$info['title']}:: " . $str) : $str;
            }
        }
    }
    return empty($retArray) ? array() : isset($index) ? $retArray[$index] : $retArray;
}

function civitest_civicrm_customFieldOptions( $fieldID, &$options ) {
    if ( $fieldID == 1 ) {
        $options['Rocks'] = t( 'Hooks Rock' );
        unset( $options['Edu'] );
    } else if ( $fieldID == 2 ) {
        $options['H'] = t(' Hook me' );
        unset( $options['S'] );
    }
}

/**
 * The hook_searchTasks is implemented to display the list of actions allowed after doing a search
 * More examples are shown to call this hook
 *
 * @param string $$objectType specifies the component
 * @param array  $tasks       the list of actions
 *
 * @access public
 */
function civitest_civicrm_searchTasks( $objectType, &$tasks ) {
    if ( $objectType == 'contact' ) {
        $tasks[100] = array( 'title'  => t( 'Contact Hook Action Task' ),
                             'class'  => 'CRM_Contact_Form_Task_HookSample',
                             'result' => false );
    }
    if ( $objectType == 'contribution' ) {
        $tasks[102] = array( 'title'  => t( 'Contribution Hook Action Task' ),
                             'class'  => 'CRM_Contribute_Form_Task_SearchTaskHookSample',
                             'result' => false );
    }
    if ( $objectType == 'membership' ) {
        $tasks[103] = array( 'title'  => t( 'Member Hook Action Task' ),
                             'class'  => 'CRM_Member_Form_Task_SearchTaskHookSample',
                             'result' => false );
    }
    if ( $objectType == 'pledge' ) {
        $tasks[104] = array( 'title'  => t( 'Pledge Hook Action Task' ),
                             'class'  => 'CRM_Pledge_Form_Task_SearchTaskHookSample',
                             'result' => false );
    }
    if ( $objectType == 'event' ) {
        $tasks[105] = array( 'title'  => t( 'Event Hook Action Task' ),
                             'class'  => 'CRM_Event_Form_Task_SearchTaskHookSample',
                             'result' => false );
    }
    if ( $objectType == 'case' ) {
        $tasks[106] = array( 'title'  => t( 'Case Hook Action Task' ),
                             'class'  => 'CRM_Case_Form_Task_SearchTaskHookSample',
                             'result' => false );
    }
    if ( $objectType == 'grant' ) {
        $tasks[107] = array( 'title'  => t( 'Grant Hook Action Task' ),
                             'class'  => 'CRM_Grant_Form_Task_SearchTaskHookSample',
                             'result' => false );
    }
    if ( $objectType == 'activity' ) {
        $tasks[108] = array( 'title'  => t( 'Activity Hook Action Task' ),
                             'class'  => 'CRM_Activity_Form_Task_SearchTaskHookSample',
                             'result' => false );
    }
}

function civitest_civicrm_validateForm( $formName, &$fields, &$files, &$form, &$errors ) {
    // sample implementation
    if ( $formName == 'CRM_Contact_Form_Contact' ) {
       // ensure that external identifier is present and valid
       $externalID = CRM_Utils_Array::value( 'external_identifier', $fields );
       if ( ! $externalID ) {
          $errors['external_identifier'] = ts( 'External Identifier is a required field' );
       } else {
   require_once "CRM/Utils/Rule.php";
   if ( ! CRM_Utils_Rule::integer( $externalID ) ) {
     $errors['external_identifier'] = ts( 'External Identifier is not an integer' );
   }
       }
    }
    return;

}

function civitest_civicrm_pageRun( &$page ) {
    // we are only interested in profile pages with gid = 1 and have a valid contact id
    if ( $page->getVar( '_name' ) != 'CRM_Profile_Page_View' ||
         $page->getVar( '_gid' ) != 1 ||
         ! CRM_Utils_Rule::positiveInteger( $page->getVar( '_id' ) ) ) {
        return;
    }

    // get all relationships of
    require_once 'CRM/Contact/BAO/Relationship.php';
    $relationships = CRM_Contact_BAO_Relationship::getRelationship( $page->getVar( '_id' ) );

    // if you want to filter and display only certain relationship, you can do so before assigninng to
    // smarty. Do a CRM_Core_Error::debug( $relationships ) to see all the fields
    $page->assign( 'relationships', $relationships );

    // in addition to this, you also need to customize: templates/CRM/Profile/Page/View.tpl
    // check: http://wiki.civicrm.org/confluence/display/CRMDOC/Customize+Built-in,+Profile,+Contribution+and+Event+Registration+Screens
    // some sample tpl code is included here, modify as needed
    /**
{if $relationships}
<table>
<tr>
  <th>Name</th>
  <th>Relation</th>
  <th>Country</th>
</tr>
{foreach from=$relationships item=relation}
<tr>
  <td>{$relation.name}</td>
  <td>{$relation.relation}</td>
  <td>{$relation.country}</td>
</tr>
{/foreach}
</table>
{/if}
    **/

}

function civitest_civicrm_eventDiscount( &$form, &$params ) {
   require_once 'CRM/Utils/Money.php';

    // we only are interested in event id 1
    if ( $form->getVar( '_eventId' ) != 1 ) {
        return;
    }

    $numParticipants = 0;
    foreach ( $params as $key => $value ) {
        if ( isset( $params[$key]['amount'] ) &&
             $params[$key]['amount'] > 0 ) {
            $numParticipants++;
        }
    }

    // Set discount rule (Example: if more than 1 participant, 5% additional discount per paying participant, upto a max of 50%)
    if ( $numParticipants > 1 ) {
        $discountPercentage = $numParticipants * 5;

        if ( $discountPercentage > 50 ) {
            $discountPercentage = 50;
        }

        $totalDiscount = 0;
        foreach ( $params as $key => $value ) {
            if ( CRM_Utils_Array::value( 'amount', $params[$key] ) > 0 ) {
                $discount = round( ( $params[$key]['amount'] * $discountPercentage ) / 100.0 );
                $totalDiscount += $discount;
                $params[$key]['discountAmount']  = $discount;
                $discountDisplay = CRM_Utils_Money::format( $discount, null, null );
                // Set discount info added to participant.fee_level and contribution.amount_level
                $params[$key]['discountMessage'] = " (discount: $discountDisplay)";
            }
        }

        $totalDiscountDisplay = CRM_Utils_Money::format( $totalDiscount, null, null );
        // Set the message to show on confirmation page, thank-you page and receipt
        $params[0]['discount'] =
            array( 'message' => "a discount of $totalDiscountDisplay has been applied to the total amount",
                   'applied' => true );
    }
}


/**
 * buildForm hook sample
 *
 * we want the custom date to be today's date. custom_3 is marriage date
 * in the sample data
 */
function civitest_civicrm_buildForm( $formName, &$form ) {

    if ( $formName == 'CRM_Contact_Form_Contact' ) {
        $defaults['custom_3_-1'] = date('m/d/Y');
        $form->setDefaults( $defaults );
    }

    // enable tracking feature
    if ( ( $formName == 'CRM_Contribute_Form_Contribution_Main' ||
           $formName == 'CRM_Contribute_Form_Contribution_Confirm' ||
           $formName == 'CRM_Contribute_Form_Contribution_ThankYou' ) &&
         $form->getVar( '_id' ) == 1 ) { // use  CONTRIBUTION PAGE ID here
        // use the custom field ID and custom field label here
        $trackingFields = array( 'custom_4' => 'Campaign',
                                 'custom_5' => 'Appeal',
                                 'custom_6' => 'Fund' );
        $form->assign( 'trackingFields', $trackingFields );
    }

}

/**
 * buildForm hook that would allow contacts to renew only existing memberships.
 */
function civitest_civicrm_buildForm( $formName, &$form ) {
    if ( $formName == 'CRM_Contribute_Form_Contribution_Main' ) {
        if ( is_array( $form->_membershipBlock ) ) {
            //get logged in contact
            $session   = CRM_Core_Session::singleton();
            $contactID = $session->get('userID');

            //check for existing membership
            $query = "SELECT membership_type_id
                      FROM civicrm_membership
                      WHERE membership_type_id IN ( {$form->_membershipBlock['membership_types']} )
                         AND civicrm_membership.contact_id = {$contactID}";
            $dao = CRM_Core_DAO::executeQuery( $query );

            $membershipTypeID = null;
            while ( $dao->fetch( ) ) {
                $membershipTypeID = $dao->membership_type_id;
            }

            if ( $membershipTypeID ) {
                $form->freeze(array('selectMembership'));
                $defaults['selectMembership'] = $membershipTypeID;
                $form->setDefaults( $defaults );
            }
        }
    }
}

function civitest_civicrm_mailingGroups( &$form, &$groups, &$mailings ) {
    unset( $groups[4] );
    $mailings[1] = 'This Mailing does not exist';
}

function _civitest_discountHelper( $eventID, $discountCode ) {
    $sql = "
SELECT v.id as id, v.value as value, v.weight as weight
FROM   civicrm_option_value v,
       civicrm_option_group g
WHERE  v.option_group_id = g.id
AND    v.name = %1
AND    g.name = %2

";
    $params = array( 1 => array( $discountCode              , 'String' ),
                     2 => array( "event_discount_{$eventID}", 'String' ) );
    $dao = CRM_Core_DAO::executeQuery( $sql, $params );
    if ( $dao->fetch( ) ) {
        // ensure discountPercent is a valid numeric number <= 100
        if ( $dao->value &&
             is_numeric( $dao->value ) &&
             $dao->value >= 0 &&
             $dao->value <= 100 &&
             is_numeric( $dao->weight ) ) {
            return array( $dao->id, $dao->value, $dao->weight );
        }
    }
    return array( null, null, null );

}

function civitest_civicrm_buildForm( $formName, &$form ) {
    if ( $formName == 'CRM_Event_Form_Registration_Register' &&
         $form->getVar( '_eventId' ) == 3 ) {
        $form->addElement( 'text', 'discountCode', ts( 'Discount Code' ) );
  // in template use
  // {$form.discountCode.label}&nbsp;{$form.discountCode.html}

        // also assign to template
        $template = CRM_Core_Smarty::singleton( );
        $beginHookFormElements = $template->get_template_vars( 'beginHookFormElements' );
        if ( ! $beginHookFormElements ) {
            $beginHookFormElements = array( );
        }
        $beginHookFormElements[] = 'discountCode';
        $form->assign( 'beginHookFormElements', $beginHookFormElements );

        $discountCode = CRM_Utils_Request::retrieve( 'discountCode', 'String', $form, false, null, $_REQUEST );
        if ( $discountCode ) {
            $defaults = array( 'discountCode' => $discountCode );
            $form->setDefaults( $defaults );
        }
    }
}

/*
 * Give random discounts for event signup.
 *
 * Warning : while implementing this hook, another post process hook
 *         : also need implementing to make sure code is only used for
 *         : the number of times that's allowed to.
 */
function civitest_civicrm_buildAmount( $pageType,
                                       &$form,
                                       &$amount ) {

    $eventID = $form->getVar( '_eventId' );
    if ( $pageType != 'event' ||
         $eventID != 3 ) {
        return;
    }

    $discountCode = CRM_Utils_Request::retrieve( 'discountCode', 'String', $form, false, null, $_REQUEST );
    if ( ! $discountCode ) {
        return;
    }

    list( $discountID, $discountPercent, $discountNumber ) = _civitest_discountHelper( $eventID, $discountCode );
    if ( $discountNumber <= 0 ) {
        // no more discount left
        return;
    }

    foreach ( $amount as $amountId => $amountInfo ) {
        $amount[$amountId]['value'] = $amount[$amountId]['value'] -
            ceil($amount[$amountId]['value'] * $discountPercent / 100);
        $amount[$amountId]['label'] = $amount[$amountId]['label'] .
            "\t - with {$discountPercent}% discount";
    }
}

/*
 * The hook updates the random code used with event signup.
 */
function civitest_civicrm_postProcess( $class, &$form ) {
    $eventID = $form->getVar( '_eventId' );
    if ( ! is_a($form, 'CRM_Event_Form_Registration_Confirm') ||
         $eventID != 3 ) {
        return;
    }

    $discountCode = CRM_Utils_Request::retrieve( 'discountCode', 'String', $form, false, null, $_REQUEST );
    if ( ! $discountCode ) {
        return;
    }

    list( $discountID, $discountPercent, $discountNumber ) = _civitest_discountHelper( $eventID, $discountCode );
    if ( ! $discountID ||
         $discountNumber <= 0 ||
         $discountNumber == 123456789 ) {
        return;
    }

    $query = "
UPDATE civicrm_option_value v
SET    v.weight = v.weight - 1
WHERE  v.id = %1
AND    v.weight > 0
";
    $params = array( 1 => array( $discountID, 'Integer' ) );

    CRM_Core_DAO::executeQuery( $query, $params );
}

/**
 * Sample hook to add more actions for Create New
 */
function civitest_civicrm_links( $op, $objectName, $objectId, &$links, &$mask ) {
    if ( $op == 'create.new.shorcuts' ) {
      // add link to create new profile
      $links[] = array( 'url'   => '/civicrm/admin/uf/group?action=add&reset=1',
                        'title' => ts('New Profile'),
                        'ref'   => 'new-profile');
    }
}

function civitest_civicrm_membershipTypeValues( &$form, &$membershipTypeValues ) {
    $membershipTypeValues[1]['name']        = 'General (50% discount)';
    $membershipTypeValues[1]['minimum_fee'] = '50.00';

    $membershipTypeValues[2]['name']        = 'Student (50% discount)';
    $membershipTypeValues[2]['minimum_fee'] = '25.00';
}

function civitest_civicrm_summary( $contactID, &$content, &$contentPlacement ) {
    // REPLACE default Contact Summary with your customized content
    $contentPlacement = 3;
    $content = "
<table>
<tr><th>Hook Data</th></tr>
<tr><td>Data 1</td></tr>
<tr><td>Data 2</td></tr>
</table>
";

}

function civitest_civicrm_contactListQuery( &$query, $name, $context, $id ) {
    // This example limits contacts in my contact reference field lookup to a specific group

    // Connect the hook to your Contact Reference custom field using the field ID (field id is 4 in this case)
    if ( $context == 'customfield' &&
         $id == 4 ) {
        // Now construct the query to select only the contacts we want
        // The query must return two columns - contact sort_name, and contact id
        $query = "
SELECT c.sort_name, c.id
FROM civicrm_contact c, civicrm_group_contact cg
WHERE c.sort_name LIKE '$name%'
AND   cg.group_id IN ( 4 )
AND   cg.contact_id = c.id
AND   cg.status = 'Added'
ORDER BY c.sort_name ";
    }

}

/**
 * Hook implementation for altering payment parameters before talking to a payment processor back end.
 *
 * @param string $paymentObj
 *    instance of payment class of the payment processor invoked (e.g., 'CRM_Core_Payment_Dummy')
 * @param array &$rawParams
 *    array of params as passed to to the processor
 * @params array  &$cookedParams
 *     params after the processor code has translated them into its own key/value pairs
 * @return void
 */
function civitest_civicrm_alterPaymentProcessorParams( $paymentObj,
                                                       &$rawParams,
                                                       &$cookedParams ) {
    $mode = $paymentObj->getVar('_mode');
    $type = $paymentObj->getVar('_paymentProcessor');
    $processorType = $type['payment_processor_type'];
    if ( $paymentObj instanceof CRM_Core_Payment_Dummy ) {
        $employer   = empty($rawParams['custom_1']) ? '' : $rawParams['custom_1'];
        $occupation = empty($rawParams['custom_2']) ? '' : $rawParams['custom_2'];
        $cookedParams['custom'] = "$employer|$occupation";

    } else if ( $paymentObj instanceof CRM_Core_Payment_AuthorizeNet ) {
        //Actual translation for one application:
        //Employer > Ship to Country (x_ship_to_country)
        //Occupation > Company (x_company)
        //Solicitor > Ship-to First Name (x_ship_to_first_name)
        //Event > Ship-to Last Name (x_ship_to_last_name)
        //Other > Ship-to Company (x_ship_to_company)

        $cookedParams['x_ship_to_country']   = $rawParams['custom_1'];
        $cookedParams['x_company']           = $rawParams['custom_2'];
        $cookedParams['x_ship_to_last_name'] = $rawParams['accountingCode']; //for now
        $country_info = da_core_fetch_country_data_by_crm_id($rawParams['country-1']);
        $cookedParams['x_ship_to_company']   = $country_info['iso_code'];
    } else if( $paymentObj instanceof CRM_Core_Payment_PayPalImpl && $processorType == 'PayPal' ) {
        // Website Pro  Checkout
        $obj   = $paymentObj->getVar('_paymentForm');
        $value = $obj->getVar('_values');
        $id    = $value['id'];
        if ( $value['event']['id'] ) {
            $id =  $value['event']['id'];
        }

        $cookedParams['desc'] = $rawParams['description'];
        $cookedParams['custom'] = $id;

    } elseif ( $paymentObj instanceof CRM_Core_Payment_PayPalImpl && $processorType == 'PayPal_Express' ) {

        // Express  Checkout
        $cookedParams['desc']   = $rawParams['eventName'];
        $cookedParams['custom'] = $rawParams['eventId'];
    }
}

function civitest_civicrm_customFieldOptions($fieldID, &$options, $detailedFormat = false ) {
    if ( $fieldID == 1 || $fieldID == 2 ) {
        if ( $detailedFormat ) {
            $options['fake_id_1'] = array( 'id'    => 'fake_id_1',
                                           'value' => 'XXX',
                                           'label' => 'XXX' );
            $options['fake_id_2'] = array( 'id'    => 'fake_id_2',
                                           'value' => 'YYY',
                                           'label' => 'YYY' );
        } else {
            $options['XXX'] = 'XXX';
            $options['YYY'] = 'YYY';
        }
    }
}

function civitest_civicrm_config( &$config ) {
    $civitestRoot = dirname( __FILE__ ) . DIRECTORY_SEPARATOR;

    // fix php include path
    $include_path = $civitestRoot . PATH_SEPARATOR . get_include_path( );
    set_include_path( $include_path );

    // fix template path
    $templateDir = $civitestRoot . 'templates' . DIRECTORY_SEPARATOR;
    $template = CRM_Core_Smarty::singleton( );
    array_unshift( $template->template_dir, $templateDir );
}

function custom_ts( $string, $params = array( ) ) {
    $string = str_replace( 'Participant', 'Delegate', $string );

    static $i18n = null;
    if ( ! $i18n ) {
        $i18n = CRM_Core_I18n::singleton();
    }
    return $i18n->crm_translate( $string, $params );
}

/**
 * You want a contribution page with exactly one amount and you
 * you want to set all the values fixed and not give the user
 * any choice
 */
function civitest_civicrm_buildForm( $formName, &$form ) {
    if ( $formName == 'CRM_Contribute_Form_Contribution_Main' &&
         $form->getVar( '_id' ) == 1 ) {
        // 358 is the "option value id" of the only  value in the amount table,
        // you can get this id, by doing a view source on the HTML
        $defaults = array( 'amount'   => 358,
                           'is_recur' => 1,
                           'frequency_interval' => 1,
                           'frequency_unit' => 'month',
                           'installments' => 12 );
        $form->setDefaults( $defaults );

        // also freeze these elements
        $elementNames = array_keys( $defaults );
        foreach ( $elementNames as $element ) {
            $elm =& $form->getElement( $element );
            $elm->freeze( );
        }
    }
}

function civitest_civicrm_caseSummary($caseID) {
    /* Quick way to test what some results look like.
    return array('some_unique_id' => array( 'label' => ts('Some Date'),
                                    'value' => '2009-02-11',
                                   ),
                 'some_other_id' => array( 'label' => ts('Some String'),
                                    'value' => ts('Coconuts'),
                                   ),
                 );
*/

/*
For styling put this in css/extras.css:

#caseSummary {display: table;}
#modrtw {display: table-row; border: 1px solid #999999; width: 200px;}
#mcstat {display: table-row; border: 1px solid #999999; border-left: 0; width: 200px;}
#caseSummary label {display: table-cell;}
#caseSummary div {display: table-cell; padding-left: 5px; padding-right: 5px;}
  */

    // More realistic example, but will return nothing unless you have these activities in your database.
    // TIP: Put these queries into methods in a custom class. You will likely want to re-use them elsewhere, such as in a CiviReport.

    // This query finds the earliest date of return to modified duties in a workplace disability case.
    $params = array( 1 => array( $caseID, 'Integer' ) );
    $sql = "SELECT min(activity_date_time) as mindate
FROM civicrm_activity a
INNER JOIN civicrm_case_activity ca on a.id=ca.activity_id
LEFT OUTER JOIN civicrm_option_group og on og.name='activity_type'
LEFT OUTER JOIN civicrm_option_value ov on
(og.id=ov.option_group_id AND ov.name='Return to modified duties')
WHERE ca.case_id=%1
AND ov.value=a.activity_type_id
LIMIT 1";
    $modrtw = CRM_Core_DAO::singleValueQuery( $sql, $params );

    // This query returns the current status of the medical consent as determined by
    // the presence or absence of related activities.
    $sql = "SELECT CASE WHEN count(received.case_id) > 0 THEN 'Received'
WHEN count(sent.case_id) > 0 AND DATEDIFF(CURRENT_TIMESTAMP, sent.activity_date_time) > 14 THEN 'Overdue'
WHEN count(sent.case_id) > 0 THEN 'Sent'
ELSE 'Not Sent'
END
FROM
(SELECT ca.case_id, a1.activity_date_time FROM civicrm_activity a1
INNER JOIN civicrm_case_activity ca on a1.id=ca.activity_id
LEFT OUTER JOIN civicrm_option_group og on og.name='activity_type'
LEFT OUTER JOIN civicrm_option_value ov on
(og.id=ov.option_group_id AND ov.name='Send Consent Letter')
WHERE ca.case_id=%1
AND ov.value=a1.activity_type_id
LIMIT 1
) AS sent

LEFT OUTER JOIN

(SELECT ca2.case_id FROM civicrm_activity a2
INNER JOIN civicrm_case_activity ca2 on a2.id=ca2.activity_id
LEFT OUTER JOIN civicrm_option_group og2 on og2.name='activity_type'
LEFT OUTER JOIN civicrm_option_value ov2 on
(og2.id=ov2.option_group_id AND ov2.name='File Received Consent')
WHERE ca2.case_id=%1
AND ov2.value=a2.activity_type_id
LIMIT 1
) AS received
ON received.case_id=sent.case_id";

    $mcstat = CRM_Core_DAO::singleValueQuery( $sql, $params );

    return array('modrtw' => array( 'label' => ts('Mod RTW:'),
                                    'value' => $modrtw,
                                   ),
                 'mcstat' => array( 'label' => ts('Consent Status:'),
                                    'value' => ts($mcstat),
                                   ),
                 );
}

function civitest_civicrm_optionValues( &$values, $name ) {
    if ( $name == 'activity_status' ) {
        unset( $values[5] );
    } else if ( $name == 'case_activity_type' ) {
        unset( $values['standard_timeline'] );
    }
}

/**
 * use the mail alter hook to inject raffle ticket numbers for participants
 * this is not complete, IMO and i'd also store the raffle ticket numbers in a
 * DB table to be on the safe side
 */
function civitest_civicrm_alterMailParams( &$params ) {

    if ( $params['groupName'] == 'msg_tpl_workflow_event' &&
         $params['valueName'] == 'event_online_receipt' ) {

        $smarty =  CRM_Core_Smarty::singleton( );
        $values =& $smarty->get_template_vars( );
        $vars = array( 'lineItem', 'participantID', 'contactID' );
        foreach ( $vars as $varName ) {
            $$varName = CRM_Utils_Array::value( $varName, $values, null );
        }

        // return if no lineitems in event registration
        if ( ! $lineItem ||
             ! is_array( $lineItem ) ) {
            return;
        }

        // check for price field. the raffle id is 1 (in my test case)
        define( 'RAFFLE_PRICE_FIELD_ID', 1 );
        foreach ( $lineItem as $priceSet => $itemValues ) {
            foreach ( $itemValues as $itemID => $itemValue ) {
                if ( $itemValue['price_field_id'] != RAFFLE_PRICE_FIELD_ID ) {
                    continue;
                }

                $rafflePrefix = "{$contactID}_{$participantID}_";
                $raffleString = array( );
                $raffleCount  = 0;
                switch ( $itemValue['label'] ) {
                case 'One':
                    $raffleCount = 1;
                    break;

                case 'Five':
                    $raffleCount = 5;
                    break;

                case 'Ten':
                    $raffleCount = 10;
                    break;

                }
                for ( $i = 1 ; $i <= $raffleCount; $i++ ) {
                    $raffleString[] = $rafflePrefix . $i;
                }
                if ( ! empty( $raffleString ) ) {
                    $raffleString = implode( ', ', $raffleString );
                    $params['text'] .= "

===========================================================
Event Raffle Ticket Numbers
===========================================================

Thank you for buying raffle tickets.  Your ticket numbers are:$raffleString. Good luck!

";
                    $htmlSnippet = "
<center>
 <table width=\"620\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"crm-event_receipt\" style=\"font-family: Arial, Verdana, sans-serif; text-align: left;\">

  <tr>
   <td>
    <table style=\"border: 1px solid #999; margin: 1em 0em 1em; border-collapse: collapse; width:100%;\">
     <tr>
      <th colspan=\"2\" style=\"text-align: left; padding: 4px; border-bottom: 1px solid #999; background-color: #eee;\">
       Event Raffle Ticket Numbers      </th>
     </tr>
     <tr>
      <td colspan=\"2\" style=\"padding: 4px; border-bottom: 1px solid #999;\">
       Thank you for buying raffle tickets.  Your ticket numbers are:$raffleString. Good luck!
      </td>
     </tr>
    </table>
   </td>
  </tr>
 </table>
</center>

</body>
";

                    $params['html'] = str_replace( "</body>",
                                                   $htmlSnippet,
                                                   $params['html'] );
                }
            }
        }
    }
}

function civitest_civicrm_navigationMenu( &$params ) {

    //  Get the maximum key of $params
    $maxKey = ( max( array_keys($params) ) );

    $params[$maxKey+1] = array (
                       'attributes' => array (
                                              'label'      => 'Custom Menu Entry',
                                              'name'       => 'Custom Menu Entry',
                                              'url'        => null,
                                              'permission' => null,
                                              'operator'   => null,
                                              'separator'  => null,
                                              'parentID'   => null,
                                              'navID'      => $maxKey+1,
                                              'active'     => 1
                                              ),
                       'child' =>  array (
                                          '1' => array (
                                                        'attributes' => array (
                                                                               'label'      => 'Custom Child Menu',
                                                                               'name'       => 'Custom Child Menu',
                                                                               'url'        => 'http://www.testlink.com',
                                                                               'permission' => 'access CiviContribute
',
                                                                               'operator'   => null,
                                                                               'separator'  => 1,
                                                                               'parentID'   => $maxKey+1,
                                                                               'navID'      => 1,
                                                                               'active'     => 1
                                                                                ),
                                                        'child' => null
                                                        ) ) );
}

/**
 * This hook allows modification of the data used to perform merging of duplicates.
 * @param string $type the type of data being passed (cidRefs|eidRefs|relTables|sqls)
 * @param array $data  the data, which depends on the value of $type:
 *      'relTables':
 *          an array of tables used for asking user which elements to merge,
 *          as used at civicrm/contact/merge; each table in the array has this format:
 *                'rel_table_UNIQUE-TABLE-NICKNAME' => array(
 *                    'title'  => ts('TITLE'),
 *                    'tables' => array('TABLE-NAME' [, ...]),
 *                    'url'    => CRM_Utils_System::url(PATH, QUERY),
 *                )
 *      'sqls':
 *          a one-dimensional array of SQL statements to be run in the final merge operation;
 *          These SQL statements are run within a single transaction.
 *      'cidRefs':
 *          an array of tables and their fields referencing civicrm_contact.contact_id explicitely;
 *          each table in the array has this format:
 *                'TABLE-NAME' => array('COLUMN-NAME' [, ...])
 *      'eidRefs':
 *          an array of tables and their fields referencing civicrm_contact.contact_id with entity_id;
 *          each table in the array has this format:
 *                'TABLE-NAME' => array('entity_table-COLUMN-NAME' => 'entity_id-COLUMN-NAME')
 *      'batch':
 *          an array of migration info that will be transfered from other-contact to main-contact during a
 *          batch merge process. fields_in_conflict could be modified / resolved here.
 * @param int $mainId  contact_id of the contact that survives the merge (only when $type == 'sqls')
 * @param int $otherId contact_id of the contact that will be absorbed and deleted (only when $type == 'sqls')
 * @param array $tables when $type is "sqls", an array of tables as it may have been handed to the calling function
 *
 * @access public
 */

function civitest_civicrm_merge ( $type, &$data, $mainId = NULL, $otherId = NULL, $tables = NULL ) {

    switch ($type) {
        case 'relTables':
            // Allow user to decide whether or not to merge records in `civitest_foo` table
            $data['rel_table_foo'] = array(
                'title'  => ts('Foos'),                 // Title as shown to user for this type of data
                'tables' => array('civitest_foo'),      // Name of database table holding these records
                'url'    => CRM_Utils_System::url('civicrm/civitest/foo', 'action=browse&cid=$cid'),
                                                        // URL to view this data for this contact,
                                                        // in this case using CiviCRM's native URL utility
                                                        // NOTE: '$cid' will be replaced with correct
                                                        // CiviCRM contact ID.
            );
        break;

        case 'cidRefs':
            // Add references to civitest_foo.contact_id, and civitest_foo.foo_id, both of which
            // are foreign keys to civicrm_contact.id.  By adding this to $data, records in this
            // table will be automatically included in the merge.
            $data['civitest_foo'] = array('contact_id', 'foo_id');
        break;

        case 'eidRefs':
            // Add references to civitest_bar table, which is keyed to civicrm_contact.id
            // using `bar_entity_id` column, when `entity_table` is equal to 'civicrm_contact'. By
            // adding this to $data, records in this table will be automatically included in
            // the merge.
            $data['civitest_bar'] = array('entity_table' => 'bar_entity_id');
        break;

        case 'sqls':
            // Note that this hook can be called twice with $type = 'sqls': once with $tables
            // and once without. In our case, SQL statements related to table `civicrm_foo`
            // will be listed in $data when $tables is set; SQL statements related to table
            // `civicrm_bar` will be listed in $data when $tables is NOT set.  The deciding
            // factor here is that `civicrm_foo` was referenced above as part of the 'relTables'
            // data, whereas `civicrm_bar` was not.
            if ($tables) {
                // Nothing to do in our case. In some cases, you might want to find and
                // modify existing SQL statements in $data.
            } else {
                // Nothing to do in our case. In some cases, you might want to find and
                // modify existing SQL statements in $data.
            }
        break;

        case 'batch':
            // $data is an array of migration info that will be transfered from other-contact to main-contact during a
            // batch merge process. fields_in_conflict could be modified / resolved here.
            // $data['fields_in_conflict'] could be looked into and filled with proper values which will help
            // resolve conflict & allow batch merge process to run without any problems / conflicts.
        break;
    }
}

/**
 * This hook provides a way to override the default privacy behavior for notes.
 * $node['privacy'] is an integer, by default either 0 meaning no privacy, or 1
 * meaning the note is displayed to author only.
 * @param array $note (reference) Associative array of values for this note
 */
function civitest_civicrm_notePrivacy (&$note) {

    /* CiviCRM will check for existence of $note['notePrivacy_hidden'].
     *
     * If this value is not set, CiviCRM will show or display the note
     * based on the default, which is to count a note as private if it has
     * any non-zero value in $note['privacy'], and then to display private
     * notes only to the note author.
     *
     * If this value is set, CiviCRM will hide the note if the value is
     * TRUE, and display the note if the value is FALSE.
     */

    if ($note['privacy']) {
        if ($my_business_rules_say_so) {
            $note['notePrivacy_hidden'] = TRUE;
        } else {
            $note['notePrivacy_hidden'] = FALSE;
        }
    }
}

/* a ready to use module is available at  http://github.com/tttp/civi_export */
function civitest_civicrm_export( $exportTempTable, $headerRows, $sqlColumns, $exportMode ) {
    $writeHeader = true;
    $offset = 0;
    $limit  = 200;

    $query = "
SELECT *
FROM   $exportTempTable
";
    require_once 'CRM/Core/Report/Excel.php';
    while ( 1 ) {
        $limitQuery = $query . "
LIMIT $offset, $limit
";
        $dao = CRM_Core_DAO::executeQuery( $limitQuery );

        if ( $dao->N <= 0 ) {
            break;
        }

        $componentDetails = array( );
        while ( $dao->fetch( ) ) {
            $row = array( );

            foreach ( $sqlColumns as $column => $dontCare ) {
                $row[$column] = $dao->$column;
            }

            $componentDetails[] = $row;
        }
        CRM_Core_Report_Excel::writeHTMLFile( "Export_Records", $headerRows,
                                             $componentDetails, null, $writeHeader );
        $writeHeader = false;
        $offset += $limit;
    }

    CRM_Utils_System::civiExit( );
}


/*
 * import hook allows you to interact with the import data post process
 * this example retrieves a special column (tag_import) with pipe-separated tags and
 * create/tags the imported contact record to a predefined tagset (id=296)
 */

function civitest_civicrm_import( $object, $usage, &$objectRef, $params ) {

    if ( $object != 'Contact' &&
         $usage  != 'process' ) {
        return;
    }

  //during import, accept special tag_import column for processing
  $cType           = $objectRef->_contactType;
  $dupeType        = $objectRef->_onDuplicate;
  $contactID       = $params['contactID'];
  $importID        = $params['importID'];
  $importTempTable = $params['importTempTable'];
  $fields          = $params['fields'];

  require_once 'CRM/Core/DAO.php';
  $sqlTags = "SELECT tag_import
        FROM $importTempTable
        WHERE _id = $importID;";
  $taglist = CRM_Core_DAO::singleValueQuery( $sqlTags );

  if ( $taglist ) {

    require_once 'api/api.php';
    require_once 'CRM/Core/BAO/EntityTag.php';

    $keywords = array();
    $keywords = explode( '|', $taglist );

    foreach ( $keywords as $keyword ) {
      $params = array( 'name' => $keyword, 'parent_id' => '296', 'version' => 3 ); //import tags to tagset with id 296

      //lookup tag; create new if nonexist
      $tag = civicrm_api( 'Tag', 'get', $params );
      if ( civicrm_error( $tag ) ) {
          $tag = civicrm_api( 'Tag', 'create', $params );
          $tagid = $tag['id'];
      } else {
          $tagid = $tag['id'];
      }

      //only add tag to contact if not already present
      $entityTags = CRM_Core_BAO_EntityTag::getTag($contactID);
      if ( !in_array($tagid, $entityTags) ) {
          $entityParams = array( 'tag_id' => $tagid, 'contact_id' => $contactID, 'version' => 3 );
          $entityTag = civicrm_api( 'EntityTag', 'create', $entityParams );
      }
    }
  }
}

/**
 *  alterAPIPermissions() hook allows you to change the permissions checked when doing API 3 calls.
 */
function civitest_civicrm_alterAPIPermissions($entity, $action, &$params, &$permissions)
{
    // skip permission checks for contact/create calls
    // (but keep the ones for email, address, etc./create calls)
    // note: unsetting the below would require the default ‘access CiviCRM’ permission
    $permissions['contact']['create'] = array();

    // enforce ‘view all contacts’ check for contact/get, but do not test ‘access CiviCRM’
    $permissions['contact']['get'] = array('view all contacts');

    // add a new permission requirement for your own custom API call
    // (if all you want to enforce is ‘access CiviCRM’ you can skip the below altogether)
    $permissions['foo']['get'] = array('access CiviCRM', 'get all foos');

    // allow everyone to get info for a given event; also – another way to skip permissions
    if ($entity == 'event' and $action == 'get' and $params['title'] == 'CiviCon 2038') {
        $params['check_permissions'] = false;
    }
}

/**
*This hook allows User to customize the actions on contact summary page .
*where contribution,note,and rel are some key to action in $actions array.
*/

function civitest_civicrm_summaryActions( &$actions, $contactID = NULL ) {
    $customizeActions = array('contribution', 'note', 'rel');
    foreach( $actions as $key => $value ) {
        if ( in_array( $key, $customizeActions ) ) {
            unset( $actions[$key] );
        }
    }
}

function civitest_civicrm_searchColumns( $objectName, &$headers,  &$values, &$selector ) {

    if ( $objectName == 'Contact' ) {
        // Lets move a few header around, and overwrite stuff we dont need

        // move email to postal slot
        $headers[5] = $headers[7];

        // move phone to country slot
        $headers[6] = $headers[8];

        // lets change the title of the last two columns to fields we need
        $headers[7]['name'] = 'Source';
        unset( $headers[7]['sort'] );

        $headers[8]['name'] = 'Job Title';
        unset( $headers[8]['sort'] );

        foreach ( $values as $id => $value ) {
            $result = civicrm_api( 'Contact', 'GetSingle',
                                   array( 'version' => 3,
                                          'id' => $value['contact_id'],
                                          'return.contact_source' => 1,
                                          'return.job_title' => 1 ) );

            // store this value so it gets passed to the template
            $values[$id]['source'] = $result['contact_source'];
            $values[$id]['job_title'] = $result['job_title'];
        }

        // remember to modify CRM/Contact/Form/Selector.tpl to see the changes
    }

    if ( $objectName == 'Contribute' ) {
        // rename type to total amount
        foreach ( $headers as $id => $header ) {
            if ( $header['name'] == 'Type' ) {
                $headers[$id]['name'] = 'Total';
                unset( $headers[$id]['sort'] );
            }
        }

        foreach ( $values as $id => $value ) {
            $sql = "
                                                                                                              SELECT SUM(total_amount)
                                                                                                              FROM   civicrm_contribution
                                                                                                              WHERE  contact_id = %1
                                                                                                              ";
            $values[$id]['total'] = CRM_Core_DAO::singleValueQuery( $sql,
                                                                    array( 1 => array( $value['contact_id'],
                                                                                       'Integer' ) ) );
            // this is cheating, but allows us NOT to modify the template
            // override the values that we are not using
            $values[$id]['financial_type'] = $values[$id]['total'];
        }
    }

}

/*
 * Implements hook_civicrm_buildStateProvinceForCountry().
 *
 * Reorder the dublin states so that Dublin is at the top and dublin sub
 * states are ordered nicely.
 */
function civitest_civicrm_buildStateProvinceForCountry( $countryID, &$states ) {
    // First separate out the Dublin options.
    $topStates = array();
    foreach ($states as $key => $value) {
        if (preg_match('/Dublin/', $value)) {
            $topStates[$key] = $value;
        } else {
            $otherStates[$key] = $value;
        }
    }
    ksort($topStates);
    $states = $topStates + $otherStates;
}

function civitest_civicrm_dupeQuery( $obj, $type, &$query ) {
    //don't run these during user account/contact creation
    if( $obj->noRules || $type != 'table')
        return;

    if ( $obj->name=='My Dedupe Rule Group Name' ) {
        //first unset existing queries
        $query = array();

        //now set threshold to match our revised rule
        $obj->threshold = 5;

        if ( empty($obj->params) ) {
            //set new query when doing an internal dedupe (finding duplicate contacts)
            $query['civicrm_contact.last_name.5'] = "
SELECT t1.id id1, t2.id id2, 5 weight
FROM   civicrm_contact t1
INNER JOIN civicrm_contact t2 ON ( t1.first_name = t2.first_name AND
                                   t1.last_name = t2.last_name AND
                                 IFNULL(t1.middle_name,0) = IFNULL(t2.middle_name,0) AND
                                 IFNULL(t1.suffix_id,0) = IFNULL(t2.suffix_id,0) )
INNER JOIN civicrm_address a1 on t1.id=a1.contact_id
INNER JOIN civicrm_address a2 on t2.id=a2.contact_id AND
                                 a1.postal_code = a2.postal_code AND
                                 a1.street_address = a2.street_address
WHERE t1.contact_type = 'Individual'
  AND t2.contact_type = 'Individual'
  AND t1.id < t2.id
  AND t1.last_name IS NOT NULL
  AND t1.first_name IS NOT NULL
  AND a1.postal_code IS NOT NULL
  AND a1.street_address IS NOT NULL
";
        }
    }
}

/**
 * Hook implementations to get the display name of the
 * shared address field
 *
 */

/*
 * Define the hook name
 */
function civitest_civicrm_tokens( &$tokens ) {
    $tokens['sharedAddress'] = array( 'sharedAddress.orgName' => 'Shared Address Name' );
}


/*
 * Retrieve the values for the org names if this contact ID is linked
 * to another address via the shared addres scheme (which uses a pointer in
 * the civicrm_address table: master_id to point to the real address
 */
function civitest_civicrm_tokenValues( &$values, &$contactIDs ) {
    if ( is_array( $contactIDs ) ) {
        $contactIDString = ' ( ' . implode( ',', array_values( $contactIDs ) ) . ' ) ';
        $single = false;
    } else {
        $contactIDString = "( $contactIDs )";
        $single = true;
    }

    $query = "
SELECT     slave.id as contact_id, master.display_name as org_name
FROM       civicrm_contact master
INNER JOIN civicrm_address addressMaster ON addressMaster.contact_id = master.id
INNER JOIN civicrm_address addressSlave ON addressSlave.master_id = addressMaster.id
INNER JOIN civicrm_contact slave  ON addressSlave.contact_id = slave.id
WHERE      slave.id IN $contactIDString
";

    $dao = CRM_Core_DAO::executeQuery( $query );
    while ( $dao->fetch( ) ) {
        if ( empty( $dao->org_name ) ) {
            continue;
        }

        if ( $single ) {
            $value =& $values;
        } else {
            if ( ! array_key_exists( $dao->contact_id, $values ) ) {
                $values[$dao->contact_id] = array( );
            }
            $value =& $values[$dao->contact_id];
        }

        $value['sharedAddress.orgName'] = $dao->org_name;
    }
}


function civitest_civicrm_emailProcessorContact( $email, $contactID, &$result ) {
    require_once 'CRM/Utils/Mail/Incoming.php';

    // first split the email into name and domain
    // really simple, definitely wrong implementation
    list( $mailName, $mailDomain ) = CRM_Utils_System::explode( '@', $email, 2 );

    // we are doing all our checks based on mailDomain, so if empty
    // return and let EmailProcessor do its own thing
    if ( empty( $mailDomain ) ) {
        return;
    }

    define( 'FILE_TO_ORG_ALWAYS_TAG', 'MyTag1' );
    $orgID = _civitest_find_org_with_tag( FILE_TO_ORG_ALWAYS_TAG, $mailDomain );
    if ( $orgID ) {
        $result = array( 'contactID' => $orgID,
                         'action'    => CRM_Utils_Mail_Incoming::EMAILPROCESSOR_OVERRIDE );
        return;
    }

    // if we already have a match, we will
    // return and let EmailProcessor do its own thing
    if ( $contactID ) {
        return;
    }

    // Orgs with this tag will have same-domain emails filed on them only if it
    // passes through the ALWAYS tag check without finding a match, AND it does
    // not match an individual.
    define( 'FILE_TO_ORG_INDIVIDUAL_UNMATCHED_TAG', 'MyTag2' );
    $orgID = _civitest_find_org_with_tag( FILE_TO_ORG_INDIVIDUAL_UNMATCHED_TAG, $mailDomain );
    if ( $orgID ) {
        $result = array( 'contactID' => $orgID,
                         'action'    => CRM_Utils_Mail_Incoming::EMAILPROCESSOR_OVERRIDE );
        return;
    }

    $result = array( 'action'    => CRM_Utils_Mail_Incoming::EMAILPROCESSOR_CREATE_INDIVIDUAL );

    return;
}

function _civitest_find_org_with_tag( $tagName, $emailDomain ) {
    $sql = "
SELECT     o.id
FROM       civicrm_contact o
INNER JOIN civicrm_entity_tag et ON ( et.entity_table = 'civicrm_contact' AND et.entity_id = o.id )
INNER JOIN civicrm_tag         t ON ( et.tag_id = t.id )
INNER JOIN civicrm_email       e ON ( e.contact_id = o.id )
WHERE      t.name = %1
AND        e.email LIKE %2
";

    $params = array( 1 => array( $tagName         , 'String' ),
                     2 => array( "%{$emailDomain}", 'String' ) );
    return CRM_Core_DAO::singleValueQuery( $sql, $params );
}

/**
 * From the forum topic: http://forum.civicrm.org/index.php/topic,22430.0.html
 * This has come up a few times and i felt compelled to investigate and scratch the itch.
 * Here is a sample implementation of the ACL hook that suppresses profiles in the my account page
 * Note that none of the roles involved can have the global profile view or edit permssion
 * since those permissions trump the ACL. Also for sanity sake, these profiles
 * should probably be restricted only to the My Account scenario:
 */
function civitest_civicrm_aclGroup( $type, $contactID, $tableName, &$allGroups, &$currentGroups ) {
    if ( $tableName != 'civicrm_uf_group' ) {
        return;
    }

    global $user;
    $userRoles = $user->roles;

    // based on the above value, choose which profile
    // to retain for this user
    // role name => profile name
    $allProfiles = array( 'member'    => 'Member Profile',
                          'supporter' => 'Supporter Profile',
                          'major'     => 'Major Donor Profile',
                          'real big'  => 'Real Big Donor Profile'
                          );

    // first find the ids of all the profiles
    $profileIDs = array( );
    foreach ( $allProfiles as $roleName => $profileName ) {
        $profileIDs[$profileName] = array_search( $profileName, $allGroups );
    }

    foreach ( $allProfiles as $roleName => $profileName ) {
        if ( array_search( $roleName, $userRoles ) !== false ) {
            unset( $profileIDs[$profileName] );
        }
    }

    $currentGroups = array_diff( array_keys  ( $allGroups ),
                                 array_values( $profileIDs ) );
}

/**
 * An optimized version to speed up the contact autocomplete for large DB's
 * does not obey the settings from the UI. Does name check followed by email
 * if needed. Adds email + city to output if they exist
 */
function civitest_civicrm_contactListQuery( &$query, $name, $context, $id ) {
    // if other params are passed, the return without any changes
    if ( $_GET['context'] != 'navigation' ) {
        return;
    }

    // we are ignoring limit currently
    //create temp table for storing result set
    $randomNum = md5( uniqid( ) );
    $quickSearchTempTable = "civicrm_temp_quick_search_{$randomNum}";
    $sql = "CREATE TEMPORARY TABLE {$quickSearchTempTable} (
            contact_id int unsigned,
            data varchar(255),
            PRIMARY KEY ( contact_id )
        ) ENGINE=HEAP DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
        ";

    CRM_Core_DAO::executeQuery( $sql );

    // find the match from contact table
    $sql = "
        SELECT id, sort_name
        FROM civicrm_contact
        WHERE sort_name LIKE '$name%'
        AND is_deleted = 0
        ORDER BY sort_name LIMIT 0, 10";

    $dao = CRM_Core_DAO::executeQuery( $sql );
    $result = array();
    while ( $dao->fetch() ) {
        $result[$dao->id] = $dao->sort_name;
    }

    // if matches found less than 10, try to match from email table
    if ( $dao->N < 10 ) {
        // find the match from email table
        $sql = "
            SELECT contact_id, email
            FROM civicrm_email
            WHERE email LIKE '$name%'
            ORDER BY email LIMIT 0, 10";

        $dao = CRM_Core_DAO::executeQuery( $sql );
        while ( $dao->fetch() ) {
            if ( !array_key_exists( $dao->contact_id, $result ) ) {
                $result[$dao->contact_id] = $dao->email;
            }
        }
    }

    // find email addresses, cities for these contacts
    $ids = array();
    foreach($result as $id => $value) { $ids[] = $id; }
    $ids = implode(", ", $ids);
    $sql = "
        SELECT civicrm_contact.id, civicrm_email.email, civicrm_address.city
        FROM civicrm_contact, civicrm_email, civicrm_address
        WHERE civicrm_contact.id = civicrm_email.contact_id
        AND civicrm_contact.id = civicrm_address.contact_id
        AND civicrm_email.is_primary = 1
        AND civicrm_address.is_primary = 1
        AND civicrm_contact.id IN ( $ids )";
    $dao = CRM_Core_DAO::executeQuery( $sql );
    while($dao->fetch()) {
        $result[$dao->id] .= " :: ".$dao->email." :: ".$dao->city;
    }

    // insert into temp table
    if ( !empty( $result ) ) {
        foreach( $result as $cid => $value ) {
            $value = addslashes($value);
            $insertSQL[] = "( {$cid}, '{$value}' )";
        }
        $insertValues = implode( ',', $insertSQL );
        $sql = "INSERT INTO {$quickSearchTempTable}
                (contact_id, data )
                VALUES
                {$insertValues}
                ";
        CRM_Core_DAO::executeQuery( $sql );
    }

    // return final query
    $query = "SELECT data, contact_id as id
        FROM {$quickSearchTempTable}";

}

function civitest_civicrm_alterContent( &$content,
                                        $context,
                                        $tplName,
                                        &$object ) {
    // u can modify the content programmatically
    // similar to as described in this blog post
    // http://civicrm.org/blogs/dave-greenberg/now-its-easier-add-custom-behaviors-templates
}

// this example has been contributed by graylin kim from NYSS
function civitest_civicrm_triggerInfo(&$triggers, $tableName=NULL) {
    $triggers[] = array(
        'table' => 'civicrm_contact',
        'event' => array('update', 'insert'),
        'when'  => 'after',
        'variables' => "
            DECLARE norm_first_name VARCHAR(255);
            DECLARE norm_middle_name VARCHAR(255);
            DECLARE norm_last_name VARCHAR(255);
            DECLARE norm_household_name VARCHAR(255);
            DECLARE norm_organization_name VARCHAR(255);",
        'sql' => "
            SET norm_first_name = BB_NORMALIZE(NEW.first_name);
            SET norm_middle_name = BB_NORMALIZE(NEW.middle_name);
            SET norm_last_name = BB_NORMALIZE(NEW.last_name);
            SET norm_household_name = BB_NORMALIZE(NEW.household_name);
            SET norm_organization_name = BB_NORMALIZE(NEW.organization_name);

            INSERT INTO shadow_contact
            (contact_id, first_name, middle_name, last_name, suffix_id, birth_date, gender_id, contact_type, household_name, organization_name)
            VALUES (NEW.id, norm_first_name, norm_middle_name, norm_last_name, NEW.suffix_id, NEW.birth_date, NEW.gender_id, NEW.contact_type, norm_household_name, norm_organization_name)
            ON DUPLICATE KEY UPDATE
            first_name=norm_first_name,
            middle_name=norm_middle_name,
            last_name=norm_last_name,
            suffix_id=NEW.suffix_id,
            birth_date=NEW.birth_date,
            gender_id=NEW.gender_id,
            contact_type=NEW.contact_type,
            household_name=norm_household_name,
            organization_name=norm_organization_name;"
    );

    $triggers[] = array(
        'table' => 'civicrm_address',
        'event' => array('update','insert'),
        'when'  => 'after',
        'variables' => "
            DECLARE norm_supplemental_address_1 VARCHAR(255);
            DECLARE norm_supplemental_address_2 VARCHAR(255);
            DECLARE norm_street_address VARCHAR(255);
            DECLARE norm_postal_code VARCHAR(255);
            DECLARE norm_city VARCHAR(255);",
        'sql' => "
            SET norm_supplemental_address_1 = BB_NORMALIZE_ADDR(NEW.supplemental_address_1);
            SET norm_supplemental_address_2 = BB_NORMALIZE_ADDR(NEW.supplemental_address_2);
            SET norm_street_address = BB_NORMALIZE_ADDR(NEW.street_address);
            SET norm_postal_code = IFNULL(NEW.postal_code,'');
            SET norm_city = IFNULL(NEW.city,'');

            INSERT INTO shadow_address
                        (address_id, contact_id, street_address, postal_code, city, country_id, state_province_id, supplemental_address_1, supplemental_address_2)
                 VALUES (NEW.id, NEW.contact_id, norm_street_address, norm_postal_code, norm_city, NEW.country_id, NEW.state_province_id, norm_supplemental_address_1, norm_supplemental_address_2)
                 ON DUPLICATE KEY UPDATE
                        street_address=norm_street_address,
                        postal_code=norm_postal_code,
                        city=norm_city,
                        country_id=NEW.country_id,
                        state_province_id=NEW.state_province_id,
                        supplemental_address_1=norm_supplemental_address_1,
                        supplemental_address_2=norm_supplemental_address_2;"
    );

    $triggers[] = array(
        'table' => 'civicrm_contact',
        'event' => 'delete',
        'when'  => 'after',
        'sql'   => 'DELETE FROM shadow_contact WHERE contact_id=OLD.id;'
    );

    $triggers[] = array(
        'table' => 'civicrm_address',
        'event' => 'delete',
        'when'  => 'after',
        'sql'   => 'DELETE FROM shadow_address WHERE address_id=OLD.id;'
    );
}

function civitest_civicrm_alterReportVar($varType, &$var, &$form) {
  $formName = get_class($form);
  if ( $formName == 'CRM_Report_Form_Campaign_SurveyDetails' ) {
    if ( $varType == 'columns' ) {
      $var['civicrm_contribution'] = 
        array(
              'dao' => 'CRM_Contribute_DAO_Contribution',
              'fields' =>
              array(
                    'receive_date' => 
                    array('title' => ts('last contribution date'),
                          ),
                    'total_amount' => 
                    array('title' => ts('last contri Amount'),
                          ),
                    ),
              'grouping' => 'survey-activity-fields',
              );
    } else if ( $varType == 'sql' ) {
      $params = $form->getVar( '_params' );
      if ( CRM_Utils_Array::value('receive_date', $params['fields']) || CRM_Utils_Array::value('total_amount', $params['fields']) ) {
        $var->_from .= "LEFT JOIN civicrm_contribution {$form->_aliases['civicrm_contribution']} ON ({$form->_aliases['civicrm_contribution']}.id = (select id from civicrm_contribution con where con.contact_id = {$form->_aliases['civicrm_contact']}.id ORDER BY con.receive_date DESC LIMIT 1 ))\n";
      }
    }
  }
}