class CRM_Event_BAO_Participant extends CRM_Event_DAO_Participant {
/**
- * static field for all the participant information that we can potentially import
+ * Static field for all the participant information that we can potentially import
*
* @var array
* @static
static $_importableFields = NULL;
/**
- * static field for all the participant information that we can potentially export
+ * Static field for all the participant information that we can potentially export
*
* @var array
* @static
static $_exportableFields = NULL;
/**
- * static array for valid status transitions rules
+ * Static array for valid status transitions rules
*
* @var array
* @static
}
/**
- * takes an associative array and creates a participant object
+ * Takes an associative array and creates a participant object
*
* the function extract all the params it needs to initialize the create a
* participant object. the params array could contain additional unused name/value
*
* @param array $params (reference ) an assoc array of name/value pairs
*
- * @internal param array $ids the array that holds all the db ids
- *
- * @return object CRM_Event_BAO_Participant object
+ * @return CRM_Event_BAO_Participant object
* @access public
* @static
*/
}
/**
- * takes an associative array and creates a participant object
+ * Takes an associative array and creates a participant object
*
* @param array $params (reference ) an assoc array of name/value pairs
*
- * @internal param array $ids the array that holds all the db ids
- *
- * @return object CRM_Event_BAO_Participant object
+ * @return CRM_Event_BAO_Participant object
* @access public
* @static
*/
INNER JOIN civicrm_event event ON ( event.id = participant.event_id )
{$whereClause}";
- $eventFullText = ts('This event is full!!!');
+ $eventFullText = ts('This event is full.');
$participants = CRM_Core_DAO::executeQuery($query, $eventParams);
while ($participants->fetch()) {
//oops here event is full and we don't want waiting count.
{$whereClause}";
$eventMaxSeats = NULL;
- $eventFullText = ts('This event is full !!!');
+ $eventFullText = ts('This event is full.');
$participants = CRM_Core_DAO::executeQuery($query, $eventParams);
while ($participants->fetch()) {
if ($participants->event_full_text) {
* with total participant count that field going to carry.
*
* @param int $eventId event id.
- * @param array $skipParticipantIds
+ * @param array $skipParticipantIds an array of participant ids those we should skip.
* @param bool $considerCounted
* @param bool $considerWaiting
* @param bool $considerTestParticipants
*
- * @internal param array $skipParticipants an array of participant ids those we should skip.
- * @internal param int $isTest would you like to consider test participants.
- *
* @return array $optionsCount an array of each option id and total count
* @static
* @access public
}
/**
- * combine all the importable fields from the lower levels object
+ * Combine all the importable fields from the lower levels object
*
* @param string $contactType
* @param bool $status
}
/**
- * combine all the exportable fields from the lower levels object
+ * Combine all the exportable fields from the lower levels object
*
* @return array array of exportable Fields
* @access public
}
/**
- * function to get the event name/sort name for a particular participation / participant
+ * Get the event name/sort name for a particular participation / participant
*
* @param int $participantId id of the participant
* @param array $input an assosiative array of name /value pairs
* from other function
*
- * @return object CRM_Contribute_BAO_Contribution object
+ * @return CRM_Contribute_BAO_Contribution object
* @access public
* @static
*/
}
/**
- * fix the event level
+ * Fix the event level
*
* When price sets are used as event fee, fee_level is set as ^A
* separated string. We need to change that string to comma
}
/**
- * get the additional participant ids.
+ * Get the additional participant ids.
*
* @param int $primaryParticipantId primary partycipant Id
* @param boolean $excludeCancel do not include participant those are cancelled.
*
- * @param null $oldStatusId
+ * @param int $oldStatusId
*
* @return array $additionalParticipantIds
* @static
* Function for update primary and additional participant status
*
* @param int $participantID primary participant's id
- * @param $oldStatusID
- * @param null $newStatusID
+ * @param int $oldStatusID
+ * @param int $newStatusID
* @param bool $updatePrimaryStatus
*
- * @internal param int $statusId status id for participant
- * return void
- *
- * @return bool
+ * @return bool|void
* @access public
* @static
*/
* @param int $participantIds array of participant ids
* @param int $statusId status id for participant
* @param bool $updateRegisterDate
- * @params boolean $updateRegisterDate way to track when status changed.
*
- * return void
+ * @return void
*
* @access public
* @static
}
/**
- * Function to send mail and create activity
+ * Send mail and create activity
* when participant status changed.
*
* @param int $participantId participant id.
}
/**
- * get participant status change message.
+ * Get participant status change message.
*
- * @param $participantId
+ * @param int $participantId
* @param $statusChangeTo
- * @param $fromStatusId
+ * @param int $fromStatusId
*
* @return string
* @access public
}
/**
- * get event full and waiting list message.
+ * Get event full and waiting list message.
*
- * @param $eventId
- * @param null $participantId
+ * @param int $eventId
+ * @param int $participantId
*
* @return string
* @access public
}
/**
- * check for whether participant is primary or not
+ * Check for whether participant is primary or not
*
- * @param $participantId
+ * @param int $participantId
*
* @return true if participant is primary
* @access public
}
/**
- * get additional participant Ids for cascading with primary participant status
+ * Get additional participant Ids for cascading with primary participant status
*
* @param int $participantId participant id.
* @param int $oldStatusId previous status
}
/**
- * Function to get participant record count for a Contact
- *
- * @param $contactID
+ * Get participant record count for a Contact
*
- * @internal param int $contactId Contact ID
+ * @param int $contactID
*
* @return int count of participant records
* @access public
}
/**
- * Function to get participant ids by contribution id
+ * Get participant ids by contribution id
*
* @param int $contributionId Contribution Id
* @param bool $excludeCancelled Exclude cancelled additional participant
*
- * @return int $participantsId
+ * @return array $participantsId
* @access public
* @static
*/
}
/**
- * Function to get additional Participant edit & view url .
+ * Get additional Participant edit & view url .
*
- * @param $participantIds
- *
- * @internal param array $paticipantIds an array of additional participant ids.
+ * @param array $participantIds an array of additional participant ids.
*
* @return array of Urls.
* @access public
}
/**
- * to create trxn entry if an event has discount.
+ * To create trxn entry if an event has discount.
*
* @param int $eventID event id
* @param array $contributionParams contribution params.
}
/**
- * Function to delete participants of contact
+ * Delete participants of contact
*
* CRM-12155
*
}
/**
- * @param $params
- * @param $participantId
- * @param $contributionId
+ * @param array $params
+ * @param int $participantId
+ * @param int $contributionId
* @param $feeBlock
- * @param $lineItems
+ * @param array $lineItems
* @param $paidAmount
- * @param $priceSetId
+ * @param int $priceSetId
*/
static function changeFeeSelections($params, $participantId, $contributionId, $feeBlock, $lineItems, $paidAmount, $priceSetId) {
$contributionStatuses = CRM_Contribute_PseudoConstant::contributionStatus(NULL, 'name');
$partiallyPaidStatusId = array_search('Partially paid', $contributionStatuses);
- $pendngRefundStatusId = array_search('Pending refund', $contributionStatuses);
+ $pendingRefundStatusId = array_search('Pending refund', $contributionStatuses);
$previousLineItems = CRM_Price_BAO_LineItem::getLineItems($participantId, 'participant');
CRM_Price_BAO_PriceSet::processAmount($feeBlock,
$params, $lineItems
unset($insertLines[$previousLineItem['price_field_value_id']]);
// for updating the line items i.e. use-case - once deselect-option selecting again
if ($previousLineItem['line_total'] != $submittedLineItems[$previousLineItem['price_field_value_id']]['line_total']) {
- $updateLines[$previousLineItem['price_field_value_id']]['qty'] = $submittedLineItems[$previousLineItem['price_field_value_id']]['qty'];
- $updateLines[$previousLineItem['price_field_value_id']]['line_total'] = $submittedLineItems[$previousLineItem['price_field_value_id']]['line_total'];
+ $updateLines[$previousLineItem['price_field_value_id']] = $submittedLineItems[$previousLineItem['price_field_value_id']];
+ $updateLines[$previousLineItem['price_field_value_id']]['id'] = $id;
}
}
}
INNER JOIN civicrm_financial_item fi
ON (li.id = fi.entity_id AND fi.entity_table = 'civicrm_line_item')
SET li.qty = 0,
- li.line_total = 0.00
+ li.line_total = 0.00,
+ li.tax_amount = NULL
WHERE (li.entity_table = 'civicrm_participant' AND li.entity_id = {$participantId}) AND
(price_field_value_id NOT IN ({$submittedFieldValues}))
";
// gathering necessary info to record negative (deselected) financial_item
$updateFinancialItem = "
- SELECT fi.*, SUM(fi.amount) as differenceAmt, price_field_value_id
+ SELECT fi.*, SUM(fi.amount) as differenceAmt, price_field_value_id, financial_type_id, tax_amount
FROM civicrm_financial_item fi LEFT JOIN civicrm_line_item li ON (li.id = fi.entity_id AND fi.entity_table = 'civicrm_line_item')
WHERE (li.entity_table = 'civicrm_participant' AND li.entity_id = {$participantId})
GROUP BY li.entity_table, li.entity_id, price_field_value_id
$updateFinancialItemInfoDAO = CRM_Core_DAO::executeQuery($updateFinancialItem);
$trxn = CRM_Core_BAO_FinancialTrxn::getFinancialTrxnId($contributionId, 'ASC', TRUE);
$trxnId['id'] = $trxn['financialTrxnId'];
+ $invoiceSettings = CRM_Core_BAO_Setting::getItem(CRM_Core_BAO_Setting::CONTRIBUTE_PREFERENCES_NAME, 'contribution_invoice_settings');
+ $taxTerm = CRM_Utils_Array::value('tax_term', $invoiceSettings);
$updateFinancialItemInfoValues = array();
while ($updateFinancialItemInfoDAO->fetch()) {
// INSERT negative financial_items
$updateFinancialItemInfoValues['amount'] = - $updateFinancialItemInfoValues['amount'];
CRM_Financial_BAO_FinancialItem::create($updateFinancialItemInfoValues, NULL, $trxnId);
+ // INSERT negative financial_items for tax amount
+ if ($previousLineItems[$updateFinancialItemInfoValues['entity_id']]['tax_amount']) {
+ $updateFinancialItemInfoValues['amount'] = - ($previousLineItems[$updateFinancialItemInfoValues['entity_id']]['tax_amount']);
+ $updateFinancialItemInfoValues['description'] = $taxTerm;
+ if ($updateFinancialItemInfoValues['financial_type_id']) {
+ $updateFinancialItemInfoValues['financial_account_id'] = CRM_Contribute_BAO_Contribution::getFinancialAccountId($updateFinancialItemInfoValues['financial_type_id']);
+ }
+ CRM_Financial_BAO_FinancialItem::create($updateFinancialItemInfoValues, NULL, $trxnId);
+ }
}
// if submitted and difference is 0 add a positive entry again
elseif (in_array($updateFinancialItemInfoValues['price_field_value_id'], $submittedFieldValueIds) && $updateFinancialItemInfoValues['differenceAmt'] == 0) {
$updateFinancialItemInfoValues['amount'] = $updateFinancialItemInfoValues['amount'];
CRM_Financial_BAO_FinancialItem::create($updateFinancialItemInfoValues, NULL, $trxnId);
+ // INSERT financial_items for tax amount
+ if ($updateFinancialItemInfoValues['entity_id'] == $updateLines[$updateFinancialItemInfoValues['price_field_value_id']]['id'] &&
+ isset($updateLines[$updateFinancialItemInfoValues['price_field_value_id']]['tax_amount'])
+ ) {
+ $updateFinancialItemInfoValues['amount'] = $updateLines[$updateFinancialItemInfoValues['price_field_value_id']]['tax_amount'];
+ $updateFinancialItemInfoValues['description'] = $taxTerm;
+ if ($updateLines[$updateFinancialItemInfoValues['price_field_value_id']]['financial_type_id']) {
+ $updateFinancialItemInfoValues['financial_account_id'] = CRM_Contribute_BAO_Contribution::getFinancialAccountId($updateLines[$updateFinancialItemInfoValues['price_field_value_id']]['financial_type_id']);
+ }
+ CRM_Financial_BAO_FinancialItem::create($updateFinancialItemInfoValues, NULL, $trxnId);
+ }
}
}
}
if (!empty($updateLines)) {
foreach ($updateLines as $valueId => $vals) {
+ if (isset($vals['tax_amount'])) {
+ $taxAmount = $vals['tax_amount'];
+ }
+ else {
+ $taxAmount = "NULL";
+ }
$updateLineItem = "
UPDATE civicrm_line_item li
SET li.qty = {$vals['qty']},
- li.line_total = {$vals['line_total']}
+ li.line_total = {$vals['line_total']},
+ li.tax_amount = {$taxAmount},
+ li.unit_price = {$vals['unit_price']},
+ li.label = '{$vals['label']}'
WHERE (li.entity_table = 'civicrm_participant' AND li.entity_id = {$participantId}) AND
(price_field_value_id = {$valueId})
";
foreach ($insertLines as $valueId => $lineParams) {
$lineParams['entity_table'] = 'civicrm_participant';
$lineParams['entity_id'] = $participantId;
+ $lineParams['contribution_id'] = $contributionId;
$lineObj = CRM_Price_BAO_LineItem::create($lineParams);
}
else {
$updatedAmount = $params['amount'];
}
- self::recordAdjustedAmt($updatedAmount, $paidAmount, $contributionId);
+ if (strlen($params['tax_amount']) != 0) {
+ $taxAmount = $params['tax_amount'];
+ }
+ else {
+ $taxAmount = "NULL";
+ }
+ self::recordAdjustedAmt($updatedAmount, $paidAmount, $contributionId, $taxAmount);
$fetchCon = array('id' => $contributionId);
$updatedContribution = CRM_Contribute_BAO_Contribution::retrieve($fetchCon, CRM_Core_DAO::$_nullArray, CRM_Core_DAO::$_nullArray);
// insert financial items
// ensure entity_financial_trxn table has a linking of it.
$prevItem = CRM_Financial_BAO_FinancialItem::add($lineObj, $updatedContribution);
+ if (isset($lineObj->tax_amount)) {
+ CRM_Financial_BAO_FinancialItem::add($lineObj, $updatedContribution, TRUE);
+ }
}
// update participant fee_amount column
$partUpdateFeeAmt['id'] = $participantId;
+ foreach ($lineItems as $lineValue) {
+ if ($lineValue['price_field_value_id']) {
+ $line[$lineValue['price_field_value_id']] = $lineValue['label'] . ' - '. $lineValue['qty'];
+ }
+ }
+
+ $partUpdateFeeAmt['fee_level'] = implode(', ', $line);
$partUpdateFeeAmt['fee_amount'] = $params['amount'];
self::add($partUpdateFeeAmt);
/**
* @param $updatedAmount
* @param $paidAmount
- * @param $contributionId
+ * @param int $contributionId
*/
- static function recordAdjustedAmt($updatedAmount, $paidAmount, $contributionId) {
+ static function recordAdjustedAmt($updatedAmount, $paidAmount, $contributionId, $taxAmount = NULL) {
$balanceAmt = $updatedAmount - $paidAmount;
$contributionStatuses = CRM_Contribute_PseudoConstant::contributionStatus(NULL, 'name');
$partiallyPaidStatusId = array_search('Partially paid', $contributionStatuses);
- $pendngRefundStatusId = array_search('Pending refund', $contributionStatuses);
+ $pendingRefundStatusId = array_search('Pending refund', $contributionStatuses);
$completedStatusId = array_search('Completed', $contributionStatuses);
$updatedContributionDAO = new CRM_Contribute_BAO_Contribution();
-
+ $skip = FALSE;
if ($balanceAmt) {
if ($balanceAmt > 0 && $paidAmount != 0) {
$contributionStatusVal = $partiallyPaidStatusId;
}
elseif ($balanceAmt < 0 && $paidAmount != 0) {
- $contributionStatusVal = $pendngRefundStatusId;
+ $contributionStatusVal = $pendingRefundStatusId;
}
elseif ($paidAmount == 0) {
- $contributionStatusVal = $completedStatusId;
+ //skip updating the contribution status if no payment is made
+ $skip = TRUE;
$updatedContributionDAO->cancel_date = 'null';
$updatedContributionDAO->cancel_reason = NULL;
}
-
// update contribution status and total amount without trigger financial code
// as this is handled in current BAO function used for change selection
$updatedContributionDAO->id = $contributionId;
- $updatedContributionDAO->contribution_status_id = $contributionStatusVal;
+ if (!$skip) {
+ $updatedContributionDAO->contribution_status_id = $contributionStatusVal;
+ }
$updatedContributionDAO->total_amount = $updatedAmount;
+ $updatedContributionDAO->tax_amount = $taxAmount;
$updatedContributionDAO->save();
$ftDetail = CRM_Core_BAO_FinancialTrxn::getBalanceTrxnAmt($contributionId);
}
/**
- * @param $participantId
+ * @param int $participantId
* @param $activityType
*
* @throws CRM_Core_Exception
}
CRM_Activity_BAO_Activity::create($activityParams);
}
+
+ /**
+ * Get options for a given field.
+ * @see CRM_Core_DAO::buildOptions
+ *
+ * @param String $fieldName
+ * @param String $context : @see CRM_Core_DAO::buildOptionsContext
+ * @param Array $props : whatever is known about this dao object
+ *
+ * @return Array|bool
+ */
+ public static function buildOptions($fieldName, $context = NULL, $props = array()) {
+ $params = array('condition' => array());
+
+ if ($fieldName == 'status_id' && $context != 'validate') {
+ // Get rid of cart-related option if disabled
+ // FIXME: Why does this option even exist if cart is disabled?
+ if (!CRM_Core_BAO_Setting::getItem(CRM_Core_BAO_Setting::EVENT_PREFERENCES_NAME, 'enable_cart')) {
+ $params['condition'][] = "name <> 'Pending in cart'";
+ }
+ }
+
+ return CRM_Core_PseudoConstant::get(__CLASS__, $fieldName, $params, $context);
+ }
}
projects / civicrm-core.git / blobdiff