public function isConditionValid(CRM_Civirules_EventData_EventData $eventData) { $contactId = $eventData->getContactId(); $entityData = $eventData->getEntityData('ContributionSoft'); $contacts = array(); $query = $this->conditionParams['smart_group_query']; if (!empty($query)) { $subQueries = explode(';', $query); // To run only first and select statement in query string if (!empty($subQueries) && !preg_match('/^(insert|update|delete|create|drop|replace)/i', $subQueries[0])) { CRM_Core_Error::debug_var('CiviRules::Custom Query Contact Condition Query', $subQueries[0]); CRM_Core_Error::debug_var('CiviRules::Custom Query Contact Condition Param Contribution', $entityData['contribution_id']); $dao = CRM_Core_DAO::executeQuery('SELECT ' . $subQueries[0], array(1 => array($entityData['contribution_id'], 'Int'))); while ($dao->fetch()) { $contacts[] = $dao->contact_id; } } } CRM_Core_Error::debug_var('CiviRules::Custom Query Contact Condition Contacts', $contacts); if (!empty($contacts)) { $eventData->setConditionOutputData('ContributionSoft', $contacts); return TRUE; } else { return FALSE; } }
/** * Method to check if the condition is valid, will check if the contact * has an activity of the selected type * * @param object CRM_Civirules_EventData_EventData $eventData * @return bool * @access public */ public function isConditionValid(CRM_Civirules_EventData_EventData $eventData) { $ActivityContact = $eventData->getEntityData('ActivityContact'); if ($ActivityContact['record_type_id'] == $this->conditionParams['record_type_id']) { return true; } return false; }
/** * Method to check if the condition is valid, will check if the contact * has an activity of the selected type * * @param object CRM_Civirules_EventData_EventData $eventData * @return bool * @access public */ public function isConditionValid(CRM_Civirules_EventData_EventData $eventData) { $activity = $eventData->getEntityData('Activity'); if ($activity['activity_type_id'] == $this->conditionParams['activity_type_id']) { return true; } return false; }
public function isConditionValid(CRM_Civirules_EventData_EventData $eventData) { $groupContact = $eventData->getEntityData('GroupContact'); if ($groupContact['group_id'] == $this->conditionParams['group_id']) { return true; } return false; }
public function isConditionValid(CRM_Civirules_EventData_EventData $eventData) { $contribution = $eventData->getEntityData('Contribution'); if ($contribution['contribution_status_id'] == $this->conditionParams['contribution_status_id']) { return true; } return false; }
/** * Returns value of the field * * @param object CRM_Civirules_EventData_EventData $eventData * @return mixed * @access protected */ protected function getFieldValue(CRM_Civirules_EventData_EventData $eventData) { $contribution = $eventData->getEntityData('Contribution'); if (isset($contribution['total_amount'])) { return (double) $contribution['total_amount']; } return (double) 0.0; //undefined birth date }
/** * Returns the value of the field for the condition * For example: I want to check if age > 50, this function would return the 50 * * @param object CRM_Civirules_EventData_EventData $eventData * @return * @access protected * @abstract */ protected function getFieldValue(CRM_Civirules_EventData_EventData $eventData) { $entity = $this->conditionParams['entity']; $field = $this->conditionParams['field']; $data = $eventData->getEntityData($entity); if (isset($data[$field])) { return $this->normalizeValue($data[$field]); } return null; }
/** * Returns an array with parameters used for processing an action * * @param array $params * @param object CRM_Civirules_EventData_EventData $eventData * @return array $params * @access protected */ protected function alterApiParameters($params, CRM_Civirules_EventData_EventData $eventData) { //this function could be overridden in subclasses to alter parameters to meet certain criteraia $params['contact_id'] = $eventData->getContactId(); $entityData = $eventData->getEntityData('ContributionSoft'); // Alter Params if contribution soft event is happening if (!empty($entityData)) { $params['contact_id'] = $eventData->getConditionOutputData('ContributionSoft'); } return $params; }
/** * 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; $recurring = $eventData->getEntityData('ContributionRecur'); if ($this->conditionParams['end_date'] == 0 && empty($recurring['end_date'])) { $isConditionValid = TRUE; } if ($this->conditionParams['end_date'] == 1 && !empty($recurring['end_date'])) { $isConditionValid = TRUE; } return $isConditionValid; }
/** * 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; $contribution = $eventData->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 determine if the condition is valid * * @param CRM_Civirules_EventData_EventData $eventData * @return bool */ public function isConditionValid(CRM_Civirules_EventData_EventData $eventData) { $isConditionValid = FALSE; $contribution = $eventData->getEntityData('Contribution'); switch ($this->conditionParams['operator']) { case 0: if ($contribution['financial_type_id'] == $this->conditionParams['financial_type_id']) { $isConditionValid = TRUE; } break; case 1: if ($contribution['financial_type_id'] != $this->conditionParams['financial_type_id']) { $isConditionValid = TRUE; } break; } return $isConditionValid; }
/** * 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; $this->buildWhereClauses($eventData->getEntityData('Contribution')); if (!empty($this->whereClauses)) { $query = 'SELECT COUNT(*) as countContributions FROM civicrm_contribution WHERE ' . implode(' AND ', $this->whereClauses); $dao = CRM_Core_DAO::executeQuery($query, $this->whereParams); if ($dao->fetch()) { switch ($this->conditionParams['count_operator']) { case 1: if ($dao->countContributions != $this->conditionParams['no_of_contributions']) { $isConditionValid = TRUE; } break; case 2: if ($dao->countContributions > $this->conditionParams['no_of_contributions']) { $isConditionValid = TRUE; } break; case 3: if ($dao->countContributions >= $this->conditionParams['no_of_contributions']) { $isConditionValid = TRUE; } break; case 4: if ($dao->countContributions < $this->conditionParams['no_of_contributions']) { $isConditionValid = TRUE; } break; case 5: if ($dao->countContributions <= $this->conditionParams['no_of_contributions']) { $isConditionValid = TRUE; } break; default: if ($dao->countContributions == $this->conditionParams['no_of_contribution']) { $isConditionValid = TRUE; } break; } } } return $isConditionValid; }
/** * Method is mandatory and checks if the condition is met * * @param CRM_Civirules_EventData_EventData $eventData * @return bool * @access public */ public function isConditionValid(CRM_Civirules_EventData_EventData $eventData) { $contactId = $eventData->getContactId(); $contributionParams = array('contact_id' => $contactId); $countContributions = civicrm_api3('Contribution', 'getcount', $contributionParams); switch ($countContributions) { case 0: return TRUE; break; case 1: $existingContribution = civicrm_api3('Contribution', 'Getsingle', array('contact_id' => $contactId)); $eventContribution = $eventData->getEntityData('Contribution'); if ($eventContribution['contribution_id'] == $existingContribution['contribution_id']) { return TRUE; } break; default: return FALSE; break; } }
/** * Method processAction to execute the action * * @param CRM_Civirules_EventData_EventData $eventData * @access public * */ public function processAction(CRM_Civirules_EventData_EventData $eventData) { $contribution = $eventData->getEntityData('Contribution'); $actionParams = $this->getActionParameters(); switch ($actionParams['thank_you_radio']) { case 1: if (!empty($actionParams['number_of_days'])) { $thankYouDate = new DateTime(); $thankYouDate->modify('+' . $actionParams['number_of_days'] . ' day'); } break; case 2: $thankYouDate = new DateTime($actionParams['thank_you_date']); break; default: $thankYouDate = new DateTime(); break; } $params = array('id' => $contribution['id'], 'thankyou_date' => $thankYouDate->format('Ymd')); try { civicrm_api3('Contribution', 'Create', $params); } catch (CiviCRM_API3_Exception $ex) { } }
/** * Method to get the field data * * @param object CRM_Civirules_EventData_EventData $eventData * @return mixed|null * @access protected */ protected function getFieldData(CRM_Civirules_EventData_EventData $eventData) { $entity = $this->getEntity(); $data = $eventData->getEntityData($entity); $field = $this->getField(); if (isset($data[$field])) { return $this->transformFieldData($data[$field]); } return null; }