/** * Method to determine if the condition is valid * * @param CRM_Civirules_EventData_EventData $eventData * @return bool */ public function isConditionValid(CRM_Civirules_EventData_EventData $eventData) { $isConditionValid = FALSE; $contact_id = $eventData->getContactId(); /* * retrieve count of contributions for donor grouped by extracted YMD from receive_date */ $query = 'SELECT COUNT(DISTINCT CONCAT(EXTRACT(YEAR FROM receive_date), EXTRACT(MONTH FROM receive_date), EXTRACT(DAY FROM receive_date))) AS distinctDates FROM civicrm_contribution WHERE contact_id = %1 AND civicrm_contribution.contribution_status_id = %2'; $params = array(1 => array($contact_id, 'Positive'), 2 => array(CRM_Civirules_Utils::getContributionStatusIdWithName('Completed'), 'Positive')); $periodStartDate = CRM_CivirulesConditions_Utils_Period::convertPeriodToStartDate($this->conditionParams); $periodEndDate = CRM_CivirulesConditions_Utils_Period::convertPeriodToEndDate($this->conditionParams); if ($periodStartDate) { $query .= " AND DATE(`receive_date`) >= '" . $periodStartDate->format('Y-m-d') . "'"; } if ($periodEndDate) { $query .= " AND DATE(`receive_date`) <= '" . $periodEndDate->format('Y-m-d') . "'"; } $dao = CRM_Core_DAO::executeQuery($query, $params); if ($dao->fetch()) { switch ($this->conditionParams['operator']) { case 1: if ($dao->distinctDates != $this->conditionParams['no_of_days']) { $isConditionValid = TRUE; } break; case 2: if ($dao->distinctDates > $this->conditionParams['no_of_days']) { $isConditionValid = TRUE; } break; case 3: if ($dao->distinctDates >= $this->conditionParams['no_of_days']) { $isConditionValid = TRUE; } break; case 4: if ($dao->distinctDates < $this->conditionParams['no_of_days']) { $isConditionValid = TRUE; } break; case 5: if ($dao->distinctDates <= $this->conditionParams['no_of_days']) { $isConditionValid = TRUE; } break; default: if ($dao->distinctDates == $this->conditionParams['no_of_days']) { $isConditionValid = TRUE; } break; } } return $isConditionValid; }
/** * Method to determine if the condition is valid * * @param CRM_Civirules_TriggerData_TriggerData $triggerData * @return bool */ public function isConditionValid(CRM_Civirules_TriggerData_TriggerData $triggerData) { $isConditionValid = FALSE; $contribution = $triggerData->getEntityData('Contribution'); /* * retrieve count of completed contributions for donor where recurring_contribution_id is not empty */ $query = 'SELECT COUNT(*) AS recurringContributions FROM civicrm_contribution WHERE contact_id = %1 AND civicrm_contribution.contribution_recur_id > %2 AND contribution_status_id = %3'; $params = array(1 => array($contribution['contact_id'], 'Positive'), 2 => array(0, 'Positive'), 3 => array(CRM_Civirules_Utils::getContributionStatusIdWithName('Completed'), 'String')); $dao = CRM_Core_DAO::executeQuery($query, $params); if ($dao->fetch()) { switch ($this->conditionParams['operator']) { case 1: if ($dao->recurringContributions != $this->conditionParams['no_of_recurring']) { $isConditionValid = TRUE; } break; case 2: if ($dao->recurringContributions > $this->conditionParams['no_of_recurring']) { $isConditionValid = TRUE; } break; case 3: if ($dao->recurringContributions >= $this->conditionParams['no_of_recurring']) { $isConditionValid = TRUE; } break; case 4: if ($dao->recurringContributions < $this->conditionParams['no_of_recurring']) { $isConditionValid = TRUE; } break; case 5: if ($dao->recurringContributions <= $this->conditionParams['no_of_recurring']) { $isConditionValid = TRUE; } break; default: if ($dao->recurringContributions == $this->conditionParams['no_of_recurring']) { $isConditionValid = TRUE; } break; } } return $isConditionValid; }
/** * Method to build the where Clauses and related Params * * @param array $contribution * @access protected */ protected function buildWhereClauses($contribution) { $this->whereClauses[] = 'contribution_status_id = %1'; $this->whereParams[1] = array(CRM_Civirules_Utils::getContributionStatusIdWithName('Completed'), 'Integer'); $this->whereClauses[] = 'is_test = %2'; $this->whereParams[2] = array(0, 'Integer'); $this->whereClauses[] = 'contact_id = %3'; $this->whereParams[3] = array($contribution['contact_id'], 'Integer'); $index = 3; if (!empty($this->conditionParams['amount'])) { $index++; $this->whereClauses[] = 'total_amount ' . $this->setOperator($this->conditionParams['amount_operator']) . ' %' . $index; $this->whereParams[$index] = array($this->conditionParams['amount'], 'Money'); } if (!empty($this->conditionParams['financial_type'])) { $index++; $this->whereClauses[] = 'financial_type_id = %' . $index; $this->whereParams[$index] = array($this->conditionParams['financial_type'], 'Integer'); } }