}
}
}
+
+ $stateCountryMap[] = array(
+ 'country' => 'country_id_value',
+ 'state_province' => 'state_province_id_value',
+ 'county' => 'county_id_value'
+ );
+ CRM_Core_BAO_Address::addStateCountryMap($stateCountryMap);
+
$this->assign('filters', $filters);
}
if (CRM_Core_Permission::check('administer Reports') && $this->_add2groupSupported) {
$this->addElement('select', 'groups', ts('Group'),
- array('' => ts('- select group -')) + CRM_Core_PseudoConstant::staticGroup()
+ array('' => ts('Add Contacts to Group')) + CRM_Core_PseudoConstant::nestedGroup(),
+ array('class' => 'crm-select2 crm-action-menu action-icon-plus huge')
);
$this->assign('group', TRUE);
}
- $label = ts('Add These Contacts to Group');
- $this->addElement('submit', $this->_groupButtonName, $label, array('onclick' => 'return checkGroup();'));
+ $this->addElement('submit', $this->_groupButtonName, '', array('style' => 'display: none;'));
$this->addChartOptions();
$this->addButtons(array(
if (!is_array($value)) {
$value = array($value);
}
-
+
$tmp_membership_org_sql_list = implode(', ', $value);
return " {$this->_aliases['civicrm_contact']}.id {$sqlOp} (
SELECT DISTINCT mem.contact_id
- FROM civicrm_membership mem
+ FROM civicrm_membership mem
LEFT JOIN civicrm_membership_status mem_status ON mem.status_id = mem_status.id
- LEFT JOIN civicrm_membership_type mt ON mem.membership_type_id = mt.id
+ LEFT JOIN civicrm_membership_type mt ON mem.membership_type_id = mt.id
WHERE mt.member_of_contact_id IN (".$tmp_membership_org_sql_list.")
AND mt.is_active = '1'
AND mem_status.is_current_member = '1'
AND mem_status.is_active = '1' ) ";
- }
+ }
function whereMembershipTypeClause($field, $value, $op) {
$sqlOp = $this->getSQLOperator($op);
if (!is_array($value)) {
$value = array($value);
}
-
+
$tmp_membership_sql_list = implode(', ', $value);
return " {$this->_aliases['civicrm_contact']}.id {$sqlOp} (
SELECT DISTINCT mem.contact_id
- FROM civicrm_membership mem
- LEFT JOIN civicrm_membership_status mem_status ON mem.status_id = mem_status.id
- LEFT JOIN civicrm_membership_type mt ON mem.membership_type_id = mt.id
+ FROM civicrm_membership mem
+ LEFT JOIN civicrm_membership_status mem_status ON mem.status_id = mem_status.id
+ LEFT JOIN civicrm_membership_type mt ON mem.membership_type_id = mt.id
WHERE mem.membership_type_id IN (".$tmp_membership_sql_list.")
AND mt.is_active = '1'
AND mem_status.is_current_member = '1'
AND mem_status.is_active = '1' ) ";
}
-
+
/**
* @param string $tableAlias
*/