function buildQuickForm()
{
$custom = sumfields_get_custom_field_definitions();
$options = array();
$field_options = array();
while (list($k, $v) = each($custom['fields'])) {
$display = $v['display'];
$field_options[$display][$k] = $v['label'];
}
if (count($field_options) == 0) {
// This means neither CiviEvent or CiviContribute are enabled.
$session = CRM_Core_Session::singleton();
$session->setStatus(ts("Summary Fields is not particularly useful if CiviContribute and CiviEvent are both disabled. Try enabling at least one.", array('domain' => 'net.ourpowerbase.sumfields')));
return;
}
// Evaluate the status of form changes and report to the user
$apply_settings_status = sumfields_get_setting('generate_schema_and_data', FALSE);
if (empty($apply_settings_status)) {
$display_status = ts('The settings have never been saved (newly enabled)', array('domain' => 'net.ourpowerbase.sumfields'));
} elseif (!preg_match('/^(scheduled|running|success|failed):([0-9 :\\-]+)$/', $apply_settings_status, $matches)) {
$display_status = ts("Unable to determine status (%1).", array(1 => $apply_settings_status, 'domain' => 'net.ourpowerbase.sumfields'));
} else {
$display_status = NULL;
$status = $matches[1];
$date = $matches[2];
switch ($status) {
case 'scheduled':
$display_status = ts("Setting changes were saved on %1, but not yet applied; they should be applied shortly.", array(1 => $date, 'domain' => 'net.ourpowerbase.sumfields'));
break;
case 'running':
$display_status = ts("Setting changes are in the process of being applied; the process started on %1.", array(1 => $date, 'domain' => 'net.ourpowerbase.sumfields'));
break;
case 'success':
$display_status = ts("Setting changes were successfully applied on %1.", array(1 => $date, 'domain' => 'net.ourpowerbase.sumfields'));
break;
case 'failed':
$display_status = ts("Setting changes failed to apply; the failed attempt happend on %1.", array(1 => $date, 'domain' => 'net.ourpowerbase.sumfields'));
break;
}
}
$this->Assign('display_status', $display_status);
// Evaluate status of the triggers and report to the user.
if (sumfields_get_update_trigger('civicrm_contribution')) {
$contribution_table_trigger_status = 'Enabled';
} else {
$contribution_table_trigger_status = 'Not Enabled';
}
$this->Assign('contribution_table_trigger_status', $contribution_table_trigger_status);
if (sumfields_get_update_trigger('civicrm_participant')) {
$participant_table_trigger_status = 'Enabled';
} else {
$participant_table_trigger_status = 'Not Enabled';
}
$this->Assign('participant_table_trigger_status', $participant_table_trigger_status);
// Add active fields
if (array_key_exists('fundraising', $field_options)) {
$this->Assign('sumfields_active_fundraising', TRUE);
$name = 'active_fundraising_fields';
$label = ts('Fundraising Fields', array('domain' => 'net.ourpowerbase.sumfields'));
$this->addCheckBox($name, $label, array_flip($field_options['fundraising']));
}
if (sumfields_component_enabled('CiviMember') && array_key_exists('membership', $field_options)) {
$this->Assign('sumfields_active_membership', TRUE);
$name = 'active_membership_fields';
$label = ts('Membership Fields', array('domain' => 'net.ourpowerbase.sumfields'));
$this->addCheckBox($name, $label, array_flip($field_options['membership']));
}
if (array_key_exists('event_standard', $field_options)) {
$this->Assign('sumfields_active_event_standard', TRUE);
$name = 'active_event_standard_fields';
$label = ts('Standard Event Fields', array('domain' => 'net.ourpowerbase.sumfields'));
$this->addCheckBox($name, $label, array_flip($field_options['event_standard']));
}
if (array_key_exists('event_turnout', $field_options)) {
$this->Assign('sumfields_active_event_turnout', TRUE);
$name = 'active_event_turnout_fields';
$label = ts('Turnout Event Fields', array('domain' => 'net.ourpowerbase.sumfields'));
$this->addCheckBox($name, $label, array_flip($field_options['event_turnout']));
}
if (sumfields_component_enabled('CiviMember')) {
$this->assign('sumfields_member', TRUE);
$name = 'membership_financial_type_ids';
$label = ts('Membership Financial Types', array('domain' => 'net.ourpowerbase.sumfields'));
$this->addCheckBox($name, $label, array_flip(sumfields_get_all_financial_types()));
$this->addRule($name, ts('%1 is a required field.', array(1 => $label, 'domain' => 'net.ourpowerbase.sumfields')), 'required');
}
if (sumfields_component_enabled('CiviContribute')) {
$this->assign('sumfields_contribute', TRUE);
$name = 'financial_type_ids';
$label = ts('Financial Types', array('domain' => 'net.ourpowerbase.sumfields'));
$this->addCheckBox($name, $label, array_flip(sumfields_get_all_financial_types()));
$this->addRule($name, ts('%1 is a required field.', array(1 => $label, 'domain' => 'net.ourpowerbase.sumfields')), 'required');
}
if (sumfields_component_enabled('CiviEvent')) {
$this->assign('sumfields_event', TRUE);
$name = 'event_type_ids';
$label = ts('Event Types', array('domain' => 'net.ourpowerbase.sumfields'));
$this->addCheckBox($name, $label, array_flip(sumfields_get_all_event_types()));
$this->addRule($name, ts('%1 is a required field.', array(1 => $label, 'domain' => 'net.ourpowerbase.sumfields')), 'required');
$label = ts('Participant Status (attended)', array('domain' => 'net.ourpowerbase.sumfields'));
$name = 'participant_status_ids';
$this->addCheckBox($name, $label, array_flip(sumfields_get_all_participant_status_types()));
$this->addRule($name, ts('%1 is a required field.', array(1 => $label, 'domain' => 'net.ourpowerbase.sumfields')), 'required');
$label = ts('Participant Status (did not attend)', array('domain' => 'net.ourpowerbase.sumfields'));
$name = 'participant_noshow_status_ids';
$this->addCheckBox($name, $label, array_flip(sumfields_get_all_participant_status_types()));
$this->addRule($name, ts('%1 is a required field.', array(1 => $label, 'domain' => 'net.ourpowerbase.sumfields')), 'required');
}
$name = 'when_to_apply_change';
$label = ts('When should these changes be applied?', array('domain' => 'net.ourpowerbase.sumfields'));
$options = array('via_cron' => ts("On the next scheduled job (cron)", array('domain' => 'net.ourpowerbase.sumfields')), 'on_submit' => ts("When I submit this form", array('domain' => 'net.ourpowerbase.sumfields')));
$this->addRadio($name, $label, $options);
$this->addButtons(array(array('type' => 'next', 'name' => ts('Save'), 'spacing' => ' ', 'isDefault' => TRUE), array('type' => 'cancel', 'name' => ts('Cancel'))));
}
/**
* Fix incorrect contributions summary fields.
*
* Find all summary fields with incorrect amounts and fix them. You may need to
* add this as a cron job if you find that you are regularly getting
* inconsistent summaries.
*
*/
function sumfields_fix_inconsistent_summaries()
{
// This means there is no update triggered defined.
if (!($db_trigger_sql = sumfields_get_update_trigger('civicrm_contribution'))) {
$msg = dt("Update trigger is not defined. This might explain inconsistent responses. " . "Rebuilding triggers, this may take a while.");
drush_log($msg, 'error');
CRM_Core_DAO::triggerRebuild();
if (!sumfields_get_update_trigger('civicrm_contribution')) {
$msg = dt("Still can't find trigger after rebuilding. Bailing...");
drush_log($msg, 'error');
return FALSE;
}
}
$ids = sumfields_find_incorrect_total_lifetime_contribution_records();
if ($ids && count($ids) > 0) {
// Just re-initiate everything - who knows what might have gone wrong.
drush_log(dt("Data is wrong. Re-running trigger creation."), 'error');
CRM_Core_DAO::triggerRebuild();
drush_log(dt("Repopulating all data."), 'error');
sumfields_generate_data_based_on_current_data($session = NULL);
return TRUE;
}
}