$query->_element['mailing_id'] = 1;
// base table is contact, so join recipients to it
- $query->_tables['civicrm_mailing_recipients'] = $query->_whereTables['civicrm_mailing_recipients'] =
- " INNER JOIN civicrm_mailing_recipients ON civicrm_mailing_recipients.contact_id = contact_a.id ";
+ $query->_tables['civicrm_mailing_recipients'] = $query->_whereTables['civicrm_mailing_recipients']
+ = " INNER JOIN civicrm_mailing_recipients ON civicrm_mailing_recipients.contact_id = contact_a.id ";
$query->_tables['civicrm_mailing'] = $query->_whereTables['civicrm_mailing'] = 1;
// get mailing name
if (!empty($query->_returnProperties['mailing_name'])) {
- $query->_select['mailing_name'] = "civicrm_mailing.name as mailing_name";
+ $query->_select['mailing_name'] = "civicrm_mailing.name as mailing_name";
$query->_element['mailing_name'] = 1;
}
// get mailing subject
if (!empty($query->_returnProperties['mailing_subject'])) {
- $query->_select['mailing_subject'] = "civicrm_mailing.subject as mailing_subject";
+ $query->_select['mailing_subject'] = "civicrm_mailing.subject as mailing_subject";
$query->_element['mailing_subject'] = 1;
}
// get mailing status
if (!empty($query->_returnProperties['mailing_job_status'])) {
- $query->_tables['civicrm_mailing_job'] = $query->_whereTables['civicrm_mailing_job'] =
- " LEFT JOIN civicrm_mailing_job ON civicrm_mailing_job.mailing_id = civicrm_mailing.id AND civicrm_mailing_job.parent_id IS NULL AND civicrm_mailing_job.is_test != 1 ";
- $query->_select['mailing_job_status'] = "civicrm_mailing_job.status as mailing_job_status";
+ $query->_tables['civicrm_mailing_job'] = $query->_whereTables['civicrm_mailing_job']
+ = " LEFT JOIN civicrm_mailing_job ON civicrm_mailing_job.mailing_id = civicrm_mailing.id AND civicrm_mailing_job.parent_id IS NULL AND civicrm_mailing_job.is_test != 1 ";
+ $query->_select['mailing_job_status'] = "civicrm_mailing_job.status as mailing_job_status";
$query->_element['mailing_job_status'] = 1;
}
// mailing job end date / completed date
if (!empty($query->_returnProperties['mailing_job_end_date'])) {
- $query->_tables['civicrm_mailing_job'] = $query->_whereTables['civicrm_mailing_job'] =
- " LEFT JOIN civicrm_mailing_job ON civicrm_mailing_job.mailing_id = civicrm_mailing.id AND civicrm_mailing_job.parent_id IS NULL AND civicrm_mailing_job.is_test != 1 ";
- $query->_select['mailing_job_end_date'] = "civicrm_mailing_job.end_date as mailing_job_end_date";
+ $query->_tables['civicrm_mailing_job'] = $query->_whereTables['civicrm_mailing_job']
+ = " LEFT JOIN civicrm_mailing_job ON civicrm_mailing_job.mailing_id = civicrm_mailing.id AND civicrm_mailing_job.parent_id IS NULL AND civicrm_mailing_job.is_test != 1 ";
+ $query->_select['mailing_job_end_date'] = "civicrm_mailing_job.end_date as mailing_job_end_date";
$query->_element['mailing_job_end_date'] = 1;
}
*
* @return array|null
*/
- static function defaultReturnProperties($mode,
+ public static function defaultReturnProperties(
+ $mode,
$includeCustomFields = TRUE
) {
'mailing_job_end_date' => 1,
'contact_type' => 1,
'contact_sub_type' => 1,
- 'mailing_recipients_id' => 1
+ 'mailing_recipients_id' => 1,
);
}
return $properties;
return;
case 'mailing_name':
- $value = strtolower( addslashes( $value ) );
- if ( $wildcard ) {
+ $value = strtolower(addslashes($value));
+ if ($wildcard) {
$value = "%$value%";
- $op = 'LIKE';
+ $op = 'LIKE';
}
$query->_where[$grouping][] = "LOWER(civicrm_mailing.name) $op '$value'";
- $query->_qill[$grouping][] = "Mailing Namename $op \"$value\"";
+ $query->_qill[$grouping][] = "Mailing Namename $op \"$value\"";
$query->_tables['civicrm_mailing'] = $query->_whereTables['civicrm_mailing'] = 1;
$query->_tables['civicrm_mailing_recipients'] = $query->_whereTables['civicrm_mailing_recipients'] = 1;
return;
'civicrm_mailing_event_bounce',
'bounce_type_id',
ts('Bounce type(s)'),
- CRM_Core_PseudoConstant::get('CRM_Mailing_Event_DAO_Bounce', 'bounce_type_id', array('keyColumn' => 'id', 'labelColumn' => 'name'))
+ CRM_Core_PseudoConstant::get('CRM_Mailing_Event_DAO_Bounce', 'bounce_type_id', array(
+ 'keyColumn' => 'id',
+ 'labelColumn' => 'name',
+ ))
);
return;
$query->_tables['civicrm_mailing_recipients'] = $query->_whereTables['civicrm_mailing_recipients'] = 1;
$query->_where[$grouping][] = " civicrm_mailing_job.status = '{$value}' ";
- $query->_qill[$grouping][] = "Mailing Job Status IS \"$value\"";
+ $query->_qill[$grouping][] = "Mailing Job Status IS \"$value\"";
}
return;
}
}
/**
- * Add all the elements shared between Mailing search and advnaced search
+ * Add all the elements shared between Mailing search and advnaced search.
*
*
* @param CRM_Core_Form $form
* @return void
- * @static
*/
public static function buildSearchForm(&$form) {
// mailing selectors
'Complete' => 'Complete',
'Scheduled' => 'Scheduled',
'Running' => 'Running',
- 'Canceled' => 'Canceled'
+ 'Canceled' => 'Canceled',
);
$form->addElement('select', 'mailing_job_status', ts('Mailing Job Status'), $mailingJobStatuses, FALSE);
* @param $row
* @param int $id
*/
- public static function searchAction(&$row, $id) {}
+ public static function searchAction(&$row, $id) {
+ }
/**
* @param $tables
if (is_array($value)) {
$query->_where[$grouping][] = "$tableName.$fieldName $op (" . implode(',', $value) . ")";
- $query->_qill[$grouping][] = "$fieldTitle $op ". implode(', ', array_intersect_key($valueTitles, array_flip($value)));
+ $query->_qill[$grouping][] = "$fieldTitle $op " . implode(', ', array_intersect_key($valueTitles, array_flip($value)));
}
else {
$query->_qill[$grouping][] = $fieldTitle . ' - ' . $valueTitles[$value];
$query->_tables['civicrm_mailing_recipients'] = $query->_whereTables['civicrm_mailing_recipients'] = 1;
$query->_tables[$tableName] = $query->_whereTables[$tableName] = 1;
}
+
}