function where()
{
parent::where();
$params = array('name' => 'HRJobContract_Summary');
CRM_Core_DAO::commonRetrieve('CRM_Core_DAO_CustomGroup', $params, $cGrp);
$params = array('name' => 'Final_Termination_Date', 'custom_group_id' => $cGrp['id']);
CRM_Core_DAO::commonRetrieve('CRM_Core_DAO_CustomField', $params, $cField);
$dbAlias = $this->_columns[$cGrp['table_name']]['fields']["custom_{$cField['id']}"]['dbAlias'];
if (!$this->isFieldSelected($this->_columns[$cGrp['table_name']])) {
$whereClauses[] = "({$dbAlias} >= CURDATE() OR {$dbAlias} IS NULL)";
}
$params = array('name' => 'Initial_Join_Date', 'custom_group_id' => $cGrp['id']);
CRM_Core_DAO::commonRetrieve('CRM_Core_DAO_CustomField', $params, $cField);
$dbAlias = $this->_columns[$cGrp['table_name']]['fields']["custom_{$cField['id']}"]['dbAlias'];
$addWhereClauses = "({$this->_aliases['civicrm_hrjobcontract']}.is_primary IS NULL AND {$dbAlias} IS NOT NULL AND {$dbAlias} <= CURDATE())";
if (!empty($this->_params['current_employee_value'])) {
$whereClauses[] = "(({$this->_aliases['civicrm_hrjobcontract']}.is_primary = 1 OR {$this->_aliases['civicrm_hrjobcontract']}.is_primary IS NULL) AND ({$this->_aliases['civicrm_hrjobcontract_details']}.period_start_date IS NOT NULL AND {$this->_aliases['civicrm_hrjobcontract_details']}.period_start_date <= CURDATE()))";
$this->_where = str_replace("AND ( hrjobcontract_civireport.current_employee = 1 )", '', $this->_where);
}
$whereClauses[] = "{$this->_aliases['civicrm_contact']}.contact_type = 'Individual'";
$where = implode(' AND ', $whereClauses);
if ($this->_where == "WHERE ( 1 )") {
$this->_where = $where;
} else {
$this->_where .= " AND {$where}";
}
}
function where()
{
parent::where();
list($offset, $rowCount) = $this->limit();
$this->_limit = NULL;
$tempClause = $offset && $rowCount ? "AND temp.id BETWEEN {$offset} AND {$rowCount}" : null;
$this->_where .= " AND (log_action != 'Initialization') {$tempClause}";
}
function where($includeTemp = TRUE)
{
parent::where();
$this->_where .= "\n AND cdntax_c.id IS NULL AND {$this->_aliases['civicrm_contact']}.is_deleted = 0\n ";
if ($includeTemp && $this->_useEligibilityHooks) {
$this->_where .= "\n AND cdntax_t.contribution_id IS NOT NULL\n ";
} else {
$this->_where .= "\n AND {$this->_aliases['civicrm_contribution']}.contribution_status_id = 1\n AND {$this->_aliases['civicrm_financial_type']}.is_deductible = 1\n AND ({$this->_aliases['civicrm_contribution']}.total_amount - COALESCE({$this->_aliases['civicrm_contribution']}.non_deductible_amount,0)) > 0\n ";
}
}
public function where()
{
parent::where();
// Handle calculated end date. This can come from one of two sources:
// Either there is a specified end date for the end_date field
// Or, we calculate the end date based on the start date +
// installments * intervals using the mysql date_add function, along
// with the interval unit (e.g. DATE_ADD(start_date, INTERVAL 12 * 1 MONTH)
$date_suffixes = array('relative', 'from', 'to');
while (list(, $suffix) = each($date_suffixes)) {
$isBreak = FALSE;
// Check to see if the user wants to search by calculated date.
if (!empty($this->_params['calculated_end_date_' . $suffix])) {
// The calculated date field is in use - spring into action
// Gather values
$relative = CRM_Utils_Array::value("calculated_end_date_relative", $this->_params);
$from = CRM_Utils_Array::value("calculated_end_date_from", $this->_params);
$to = CRM_Utils_Array::value("calculated_end_date_to", $this->_params);
$end_date_db_alias = $this->_columns['civicrm_contribution_recur']['filters']['end_date']['dbAlias'];
$end_date_type = $this->_columns['civicrm_contribution_recur']['filters']['end_date']['type'];
$start_date_type = $this->_columns['civicrm_contribution_recur']['filters']['start_date']['type'];
$frequency_unit_db_alias = $this->_columns['civicrm_contribution_recur']['filters']['frequency_unit']['dbAlias'];
$frequency_interval_db_alias = $this->_columns['civicrm_contribution_recur']['filters']['frequency_interval']['dbAlias'];
$installments_db_alias = $this->_columns['civicrm_contribution_recur']['filters']['installments']['dbAlias'];
$start_date_db_alias = $this->_columns['civicrm_contribution_recur']['filters']['start_date']['dbAlias'];
// The end date clause is simple to construct
$end_date_clause = $this->dateClause($end_date_db_alias, $relative, $from, $to, $end_date_type, NULL, NULL);
// NOTE: For the calculation based on installment, there doesn't
// seem to be a way to include the interval unit (e.g. month,
// date, etc) as a field name - so we have to build a complex
// OR statement instead.
$this->_where .= 'AND (' . $this->dateClause("DATE_ADD({$start_date_db_alias}, INTERVAL {$installments_db_alias} * COALESCE({$frequency_interval_db_alias},1) month)", $relative, $from, $to, $start_date_type, NULL, NULL);
$this->_where .= " AND {$frequency_unit_db_alias} = 'month' ) OR \n";
$this->_where .= '(' . $this->dateClause("DATE_ADD({$start_date_db_alias}, INTERVAL {$installments_db_alias} * COALESCE({$frequency_interval_db_alias},1) day)", $relative, $from, $to, $start_date_type, NULL, NULL);
$this->_where .= " AND {$frequency_unit_db_alias} = 'day' ) OR \n";
$this->_where .= '(' . $this->dateClause("DATE_ADD({$start_date_db_alias}, INTERVAL {$installments_db_alias} * COALESCE({$frequency_interval_db_alias}, 1) week)", $relative, $from, $to, $start_date_type, NULL, NULL);
$this->_where .= " AND {$frequency_unit_db_alias} = 'week' ) OR \n";
$this->_where .= '(' . $this->dateClause("DATE_ADD({$start_date_db_alias}, INTERVAL {$installments_db_alias} * COALESCE({$frequency_interval_db_alias}, 1) year)", $relative, $from, $to, $start_date_type, NULL, NULL);
$this->_where .= " AND {$frequency_unit_db_alias} = 'year' )\n AND (({$end_date_db_alias} IS NOT NULL AND {$end_date_clause})\n OR ({$installments_db_alias} IS NOT NULL))\n";
$isBreak = TRUE;
}
if (!empty($this->_params['contribution_processed_date_' . $suffix])) {
$relative = CRM_Utils_Array::value("contribution_processed_date_relative", $this->_params);
$from = CRM_Utils_Array::value("contribution_processed_date_from", $this->_params);
$to = CRM_Utils_Array::value("contribution_processed_date_to", $this->_params);
$this->_where .= " AND contribution_civireport.id IN (SELECT MAX(cc.id) FROM civicrm_contribution cc WHERE cc.contribution_status_id = 1 AND (" . $this->dateClause("DATE(cc.receive_date)", $relative, $from, $to, CRM_Utils_Type::T_DATE, NULL, NULL) . " ) GROUP BY cc.contribution_recur_id)";
$isBreak = TRUE;
}
if (!empty($isBreak)) {
break;
}
}
}
public function where()
{
// reset where clause as its called multiple times, every time insert sql is built.
$this->_whereClauses = array();
parent::where();
$this->_where .= " AND (entity_log_civireport.log_action != 'Initialization')";
}
function where()
{
parent::where();
$this->_where .= " AND {$this->_aliases['civicrm_contribution']}.is_test = 0 ";
}
function where()
{
parent::where();
$this->_where .= " AND (entity_log_civireport.log_action != 'Initialization')";
}
function where()
{
parent::where();
if (empty($this->_where)) {
//$this->_where = "WHERE (value_direct_debit_details_civireport.amount IS NOT NULL)";
} else {
//$this->_where .= " AND (value_direct_debit_details_civireport.amount IS NOT NULL)";
}
}
function where()
{
parent::where();
$this->_where .= " AND {$this->_aliases['civicrm_mailing']}.sms_provider_id IS NULL";
}
function where()
{
parent::where();
if (empty($this->_where)) {
$this->_where = "WHERE value_gift_aid_submission_civireport.amount IS NOT NULL";
} else {
$this->_where .= " AND value_gift_aid_submission_civireport.amount IS NOT NULL";
}
}
public function where()
{
$this->_whereClauses[] = "{$this->_aliases['civicrm_membership']}.is_test = 0 AND\n {$this->_aliases['civicrm_contact']}.is_deleted = 0";
parent::where();
}
function where()
{
parent::where();
$op = CRM_Utils_Array::value("sector_op", $this->_params);
if ($op) {
$field['dbAlias'] = "`civicrm_entity_tag`.`tag_id`";
$clause = $this->whereClause($field, $op, CRM_Utils_Array::value("sector_value", $this->_params), CRM_Utils_Array::value("sector_min", $this->_params), CRM_Utils_Array::value("sector_max", $this->_params));
if ($clause) {
$this->_where .= " AND " . $clause;
}
}
$activity_type = CRM_Core_OptionGroup::getValue('activity_type', 'Business Programme', 'name');
$this->_where .= " AND {$this->_aliases['civicrm_activity']}.activity_type_id = '" . $activity_type . "'";
$this->_where .= " AND {$this->_aliases['civicrm_activity']}.is_deleted = 0 AND {$this->_aliases['civicrm_activity']}.is_current_revision = 1";
}
function where()
{
$this->_whereClauses[] = "{$this->_aliases['civicrm_membership']}.is_test = 0";
parent::where();
}
/**
* The WHERE of the report query.
*/
public function where()
{
if (!count($this->_params['gid_value'])) {
$this->_whereClauses[] = "({$this->_aliases['civicrm_event']}.id IS NOT NULL OR {$this->_aliases['civicrm_event2']}.id is not null)";
}
parent::where();
}
function where()
{
parent::where();
$this->_where .= " AND (log_action != 'Initialization')";
$clauses = array();
foreach ($this->_columns as $tableName => $table) {
if (array_key_exists('filters', $table)) {
foreach ($table['filters'] as $fieldName => $field) {
$clause = null;
if (CRM_Utils_Array::value('type', $field) & CRM_Utils_Type::T_DATE) {
$relative = CRM_Utils_Array::value("{$fieldName}_relative", $this->_params);
$from = CRM_Utils_Array::value("{$fieldName}_from", $this->_params);
$to = CRM_Utils_Array::value("{$fieldName}_to", $this->_params);
if ($relative || $from || $to) {
$clause = $this->dateClause($field['name'], $relative, $from, $to, $field['type']);
}
} else {
$op = CRM_Utils_Array::value("{$fieldName}_op", $this->_params);
if ($op) {
$clause = $this->whereClause($field, $op, CRM_Utils_Array::value("{$fieldName}_value", $this->_params), CRM_Utils_Array::value("{$fieldName}_min", $this->_params), CRM_Utils_Array::value("{$fieldName}_max", $this->_params));
}
}
if (!empty($clause)) {
$clauses[] = $clause;
$this->_where = "WHERE " . implode(' AND ', $clauses);
}
}
}
}
}
