/**
* Get all amount of booking
*
* Remark: The total_amount has been deducted from discount amount.
*/
static function getBookingAmount($id)
{
if (!$id) {
return;
}
$bookingAmount = array('resource_fees' => 0, 'sub_resource_fees' => 0, 'adhoc_charges_fees' => 0, 'discount_amount' => 0, 'total_amount' => 0);
$params = array('id' => $id);
self::retrieve($params, $booking);
$bookingAmount['discount_amount'] = CRM_Utils_Array::value('discount_amount', $booking);
$bookingAmount['total_amount'] = CRM_Utils_Array::value('total_amount', $booking);
$slots = CRM_Booking_BAO_Slot::getBookingSlot($id);
$subSlots = array();
foreach ($slots as $key => $slot) {
$subSlotResult = CRM_Booking_BAO_SubSlot::getSubSlotSlot($slot['id']);
foreach ($subSlotResult as $key => $subSlot) {
$subSlots[$key] = $subSlot;
}
}
$adhocCharges = CRM_Booking_BAO_AdhocCharges::getBookingAdhocCharges($id);
$params = array('booking_id' => $id);
CRM_Booking_BAO_Payment::retrieve($params, $payment);
if (!empty($payment) && isset($payment['contribution_id'])) {
// contribution exit so get all price from line item
/*
$params = array(
'version' => 3,
'id' => $payment['contribution_id'],
);
$result = civicrm_api('Contribution', 'get', $params);
$contribution = CRM_Utils_Array::value($payment['contribution_id'], $result['values'] );
$bookingAmount['total_amount'] = CRM_Utils_Array::value('total_amount', $contribution);
*/
foreach ($slots as $slotId => $slot) {
$params = array('version' => 3, 'entity_id' => $slotId, 'entity_table' => 'civicrm_booking_slot');
$result = civicrm_api('LineItem', 'get', $params);
$lineItem = CRM_Utils_Array::value($result['id'], $result['values']);
$bookingAmount['resource_fees'] += CRM_Utils_Array::value('line_total', $lineItem);
}
foreach ($subSlots as $subSlotId => $subSlots) {
$params = array('version' => 3, 'entity_id' => $subSlotId, 'entity_table' => 'civicrm_booking_sub_slot');
$result = civicrm_api('LineItem', 'get', $params);
$lineItem = CRM_Utils_Array::value($result['id'], $result['values']);
$bookingAmount['sub_resource_fees'] += CRM_Utils_Array::value('line_total', $lineItem);
}
foreach ($adhocCharges as $charges) {
$params = array('version' => 3, 'entity_id' => CRM_Utils_Array::value('id', $charges), 'entity_table' => 'civicrm_booking_adhoc_charges');
$result = civicrm_api('LineItem', 'get', $params);
$lineItem = CRM_Utils_Array::value($result['id'], $result['values']);
$bookingAmount['adhoc_charges_fees'] += CRM_Utils_Array::value('line_total', $lineItem);
}
} else {
foreach ($slots as $id => $slot) {
$bookingAmount['resource_fees'] += CRM_Booking_BAO_Slot::calulatePrice(CRM_Utils_Array::value('config_id', $slot), CRM_Utils_Array::value('quantity', $slot));
}
foreach ($subSlots as $id => $subSlot) {
$bookingAmount['sub_resource_fees'] += CRM_Booking_BAO_Slot::calulatePrice(CRM_Utils_Array::value('config_id', $subSlot), CRM_Utils_Array::value('quantity', $subSlot));
}
foreach ($adhocCharges as $charges) {
$price = CRM_Core_DAO::getFieldValue('CRM_Booking_DAO_AdhocChargesItem', CRM_Utils_Array::value('item_id', $charges), 'price', 'id');
$bookingAmount['adhoc_charges_fees'] += $price * CRM_Utils_Array::value('quantity', $charges);
}
}
return $bookingAmount;
}
static function getSlots()
{
$config = CRM_Booking_BAO_BookingConfig::getConfig();
$bookedColour = CRM_Utils_Array::value('slot_booked_colour', $config);
$provisionalColour = CRM_Utils_Array::value('slot_provisional_colour', $config);
$booking = NULL;
if (!empty($_GET['booking_id'])) {
$bookingId = CRM_Utils_Type::escape($_GET['booking_id'], 'String');
}
$timeshift = CRM_Utils_Type::escape($_GET['timeshift'], 'String');
$from = CRM_Utils_Type::escape($_GET['from'], 'String');
$to = CRM_Utils_Type::escape($_GET['to'], 'String');
$slots = array("data" => array());
$results = CRM_Booking_BAO_Slot::getSlotBetweenDate($from, $to);
foreach ($results as $key => $slot) {
if ($bookingId != CRM_Utils_Array::value('booking_id', $slot)) {
//do not thing
$params = array('id' => CRM_Utils_Array::value('booking_id', $slot));
CRM_Booking_BAO_Booking::retrieve($params, $booking);
$bookingStatus = CRM_Utils_Array::value('status_id', $booking);
$displayName = CRM_Contact_BAO_Contact::displayName(CRM_Utils_Array::value('primary_contact_id', $booking));
$data = array("id" => $key, "start_date" => CRM_Utils_Array::value('start', $slot), "end_date" => CRM_Utils_Array::value('end', $slot), "text" => CRM_Utils_Array::value('booking_id', $slot) . ' : ' . $displayName, "resource_id" => CRM_Utils_Array::value('resource_id', $slot), "configuration_id" => CRM_Utils_Array::value('config_id', $slot), "price" => CRM_Booking_BAO_Slot::calulatePrice($slot['config_id'], $slot['quantity']), "quantity" => CRM_Utils_Array::value('quantity', $slot), "note" => CRM_Utils_Array::value('note', $slot), "readonly" => true, "booking_id" => CRM_Utils_Array::value('booking_id', $slot));
if ($bookingStatus == 1) {
//Provisional, TODO: Fixed to get the value from the name i.e provisional
$data['color'] = $provisionalColour;
} else {
$data['color'] = $bookedColour;
}
array_push($slots['data'], $data);
}
}
echo json_encode($slots);
CRM_Utils_System::civiExit();
}
