PHP CRM_Contact_BAO_Group::getGroupList方法代码示例

 /**
  * This function is a wrapper for ajax group selector
  *
  * @param  array   $params associated array for params record id.
  *
  * @return array   $groupList associated array of group list
  * @access public
  */
 public function getGroupListSelector(&$params)
 {
     // format the params
     $params['offset'] = ($params['page'] - 1) * $params['rp'];
     $params['rowCount'] = $params['rp'];
     $params['sort'] = CRM_Utils_Array::value('sortBy', $params);
     // get groups
     $groups = CRM_Contact_BAO_Group::getGroupList($params);
     // add total
     $params['total'] = CRM_Contact_BAO_Group::getGroupCount($params);
     // format params and add links
     $groupList = array();
     if (!empty($groups)) {
         foreach ($groups as $id => $value) {
             $groupList[$id]['group_id'] = $value['id'];
             $groupList[$id]['group_name'] = $value['title'];
             $groupList[$id]['group_description'] = CRM_Utils_Array::value('description', $value);
             $groupList[$id]['group_type'] = CRM_Utils_Array::value('group_type', $value);
             $groupList[$id]['visibility'] = $value['visibility'];
             $groupList[$id]['links'] = $value['action'];
             $groupList[$id]['org_info'] = $value['org_info'];
             $groupList[$id]['class'] = $value['class'];
         }
         return $groupList;
     }
 }

 /**
  * wrapper for ajax group selector.
  *
  * @param array $params
  *   Associated array for params record id.
  *
  * @return array
  *   associated array of group list
  *   -rp = rowcount
  *   -page= offset
  * @todo there seems little reason for the small number of functions that call this to pass in
  * params that then need to be translated in this function since they are coding them when calling
  */
 public static function getGroupListSelector(&$params)
 {
     // format the params
     $params['offset'] = ($params['page'] - 1) * $params['rp'];
     $params['rowCount'] = $params['rp'];
     $params['sort'] = CRM_Utils_Array::value('sortBy', $params);
     // get groups
     $groups = CRM_Contact_BAO_Group::getGroupList($params);
     //skip total if we are making call to show only children
     if (empty($params['parent_id'])) {
         // add total
         $params['total'] = CRM_Contact_BAO_Group::getGroupCount($params);
         // get all the groups
         $allGroups = CRM_Core_PseudoConstant::allGroup();
     }
     // format params and add links
     $groupList = array();
     if (!empty($groups)) {
         foreach ($groups as $id => $value) {
             $groupList[$id]['group_id'] = $value['id'];
             $groupList[$id]['count'] = $value['count'];
             $groupList[$id]['group_name'] = $value['title'];
             // append parent names if in search mode
             if (empty($params['parent_id']) && !empty($value['parents'])) {
                 $groupIds = explode(',', $value['parents']);
                 $title = array();
                 foreach ($groupIds as $gId) {
                     $title[] = $allGroups[$gId];
                 }
                 $groupList[$id]['group_name'] .= '<div class="crm-row-parent-name"><em>' . ts('Child of') . '</em>: ' . implode(', ', $title) . '</div>';
                 $value['class'] = array_diff($value['class'], array('crm-row-parent'));
             }
             $value['class'][] = 'crm-entity';
             $groupList[$id]['class'] = $value['id'] . ',' . implode(' ', $value['class']);
             $groupList[$id]['group_description'] = CRM_Utils_Array::value('description', $value);
             if (!empty($value['group_type'])) {
                 $groupList[$id]['group_type'] = $value['group_type'];
             } else {
                 $groupList[$id]['group_type'] = '';
             }
             $groupList[$id]['visibility'] = $value['visibility'];
             $groupList[$id]['links'] = $value['action'];
             $groupList[$id]['org_info'] = CRM_Utils_Array::value('org_info', $value);
             $groupList[$id]['created_by'] = CRM_Utils_Array::value('created_by', $value);
             $groupList[$id]['is_parent'] = $value['is_parent'];
         }
         return $groupList;
     }
 }

/**
 * Functions below this ship commented out. Uncomment as required.
 *
/**
 * Implements hook_civicrm_preProcess().
 *
 * @link http://wiki.civicrm.org/confluence/display/CRMDOC/hook_civicrm_preProcess
 *
function metrics_civicrm_preProcess($formName, &$form) {
}
*/
function metrics_metrics_collate(&$data)
{
    /********[ Relationships ] ********/
    $sql = "SELECT COUNT(*) FROM civicrm_relationship";
    $total =& CRM_Core_DAO::singleValueQuery($sql);
    $data[] = array("type" => "relationships", "data" => $total);
    /********[ Activities ] ********/
    $sql = "SELECT COUNT(*) FROM civicrm_activity";
    $total =& CRM_Core_DAO::singleValueQuery($sql);
    $data[] = array("type" => "activities", "data" => $total);
    /********[ Tags ] ********/
    $sql = "SELECT name,COUNT(*) as total FROM civicrm_entity_tag LEFT JOIN civicrm_tag on (civicrm_entity_tag.tag_id = civicrm_tag.id) WHERE civicrm_entity_tag.entity_table = 'civicrm_contact' GROUP BY tag_id";
    $dao =& CRM_Core_DAO::executeQuery($sql);
    $totals = array();
    while ($dao->fetch()) {
        $totals[$dao->name] = $dao->total;
    }
    $data[] = array("type" => "tags", "data" => $totals);
    /********[ Groups ] ********/
    $params = array();
    $groups = CRM_Contact_BAO_Group::getGroupList($params);
    $totals = array();
    foreach ($groups as $group) {
        $totals[$group['title']] = $group['count'];
    }
    $data[] = array("type" => "groups", "data" => $totals);
    /********[ Mail ] ********/
    $mail = array();
    $sql = "SELECT COUNT(*) FROM civicrm_mailing_recipients";
    $mail['total_messages'] =& CRM_Core_DAO::singleValueQuery($sql);
    $sql = "SELECT COUNT(*) FROM (SELECT contact_id FROM civicrm_mailing_recipients GROUP BY contact_id)a";
    $mail['unique_recipients'] =& CRM_Core_DAO::singleValueQuery($sql);
    $sql = "SELECT COUNT(*) FROM civicrm_mailing_event_trackable_url_open";
    $mail['click_throughs'] =& CRM_Core_DAO::singleValueQuery($sql);
    $sql = "SELECT COUNT(*) FROM civicrm_mailing_event_opened";
    $mail['opens'] =& CRM_Core_DAO::singleValueQuery($sql);
    $sql = "SELECT COUNT(*) FROM civicrm_mailing_event_bounce";
    $mail['bounces'] =& CRM_Core_DAO::singleValueQuery($sql);
    $data[] = array("type" => "mailings", "data" => $mail);
    /********[ Registered Visits ] ********/
    /********[ Events ] ********/
    $totals = array();
    $sql = "SELECT COUNT(*) FROM civicrm_participant";
    $totals["total_participants"] =& CRM_Core_DAO::singleValueQuery($sql);
    $sql = "SELECT COUNT(*) FROM (SELECT contact_id FROM civicrm_participant GROUP BY contact_id)a";
    $totals["unique_participants"] =& CRM_Core_DAO::singleValueQuery($sql);
    $sql = "SELECT COUNT(*) FROM civicrm_event WHERE is_template = 0";
    $totals["total"] =& CRM_Core_DAO::singleValueQuery($sql);
    $data[] = array("type" => "events", "data" => $totals);
    /********[ Cases ] ********/
    $sql = "SELECT civicrm_option_value.name,civicrm_option_value.value\nFROM civicrm_option_value LEFT JOIN civicrm_option_group ON (option_group_id = civicrm_option_group.id)\nWHERE civicrm_option_group.name = 'case_status'";
    $dao =& CRM_Core_DAO::executeQuery($sql);
    $status = array();
    while ($dao->fetch()) {
        $status[$dao->value] = $dao->name;
    }
    $sql = "SELECT status_id,COUNT(*) as total FROM civicrm_case WHERE is_deleted <> 1 GROUP BY status_id";
    $dao =& CRM_Core_DAO::executeQuery($sql);
    $totals = array();
    while ($dao->fetch()) {
        $totals[$status[$dao->status_id]] = $dao->total;
    }
    $data[] = array("type" => "cases", "data" => $totals);
    /********[ Languages ] ********/
    $total = 1;
    $domain = new CRM_Core_DAO_Domain();
    $domain->find(TRUE);
    if ($domain->locales) {
        $total = substr_count($domain->locales, "_");
    }
    $data[] = array("type" => "languages", "data" => $total);
}