public function listJsonAction()
{
$criteria = new RM_Unit_Search_Criteria(array(), true);
$dao = new RM_Units();
$filters = $this->_getParam('filter', array());
$isSelector = $this->_getParam('selector', false);
$showOnlyAvailable = $this->_getParam('showOnlyAvailable', false);
if ($showOnlyAvailable) {
$reservationPeriod = new RM_Reservation_Period(new RM_Date(strtotime($this->_getParam('start_datetime'))), new RM_Date(strtotime($this->_getParam('end_datetime'))));
$unitsReserved = $dao->getReservedUnits($reservationPeriod);
$unitArray = array();
foreach ($unitsReserved as $unit) {
$unitArray[] = $unit->getId();
}
if (count($unitArray) > 0) {
$filters[] = array('field' => "id", 'data' => array('type' => "listin", 'value' => implode(",", $unitArray), 'comparison' => 'notin'));
}
}
if ($this->_getParam('reservationID') !== null) {
$reservationID = $this->_getParam('reservationID');
$reservationModel = new RM_Reservations();
$reservation = $reservationModel->find($reservationID)->current();
if ($reservation !== null) {
$detailsModel = new RM_ReservationDetails();
$details = $detailsModel->getAllByReservation($reservation);
$reservedUnitIDs = array();
foreach ($details as $detail) {
$reservedUnitIDs[] = $detail->unit_id;
}
if (count($reservedUnitIDs) > 0) {
$filters[] = array('field' => "id", 'data' => array('type' => "listin", 'value' => implode(",", $reservedUnitIDs), 'comparison' => 'notin'));
}
}
}
$criteria->filters = $filters;
$units = $dao->getAll($criteria)->toArray();
$criteria->offset = $this->_getParam('start');
$criteria->order = $this->_getParam('sort', 'id') . ' ' . $this->_getParam('dir', 'DESC');
$criteria->count = $this->_getParam('limit');
$total = $dao->getAll($criteria)->count();
$json = new stdClass();
$json->total = $total;
$json->data = $units;
return array('data' => $json);
}
/**
* Returns all saved reservation detail rows
*
* @return Zend_Db_Table_Rowset_Abstract
*/
public function getDetails()
{
$model = new RM_ReservationDetails();
return $model->getAllByReservation($this);
}
/**
* this saves the reservation total amount
*/
public function edittotalJsonAction()
{
$reservationID = $this->_getParam('reservation_id');
if ($reservationID == null) {
return array('data' => array('success' => false, 'error' => RM_Environment::getInstance()->getTranslation(RM_Environment::TRANSLATE_ERRORS)->_('Admin.Reservation.Edit', 'ReservationIDMissed')));
}
$total = $this->_getParam('rm_reservation_edit_edit_total');
$reservationModel = new RM_Reservations();
$reservationDetailsModel = new RM_ReservationDetails();
$reservation = $reservationModel->find($reservationID)->current();
$reservationDetails = $reservationDetailsModel->getAllByReservation($reservation)->current();
$reservationDetails->total_price = $total;
$success = $reservationDetails->save() != 0 ? true : false;
return array('data' => array("success" => $success), 'encoded' => false);
}
/**
* Method that parsed invoice template and returns string
*
* All variable that parsed into invoice.pthml template
* $reservation:
* $reservation.id
* $reservation.user_id
* $reservation.confirmed (Yes, No - translated)
* $reservation.is_read (Yes, No - translated)
* $reservation.creation_datetime (In MySQL format: Y-m-d H:m:s)
* $reservation.modified_datetime (In MySQL format: Y-m-d H:m:s)
* $reservation.notes
* $reservation.tax
* $reservation.paid
* $reservation.due
*
* $customer:
* $customer.id
* $customer.title (Translated)
* $customer.first_name
* $customer.last_name
* $customer.address1
* $customer.address2
* $customer.state
* $customer.city
* $customer.postcode
* $customer.country
* $customer.telephone
* $customer.mobile
* $customer.email
* $customer.username
*
* $details each detail is an $element:
* $element.reservation_id
* $element.unit_id
* $element.start_datetime (In MySQL format: Y-m-d H:m:s)
* $element.end_datetime (In MySQL format: Y-m-d H:m:s)
* $element.total_price
* $element.unit.id
* $element.unit.rating (number)
* $element.unit.published (Yes, No - translated)
* $element.unit.color (hex color)
* $element.unit.(all language db field names that are belong to unit type, for example: name, summary, description)
*
* $text: all text constants in section 'Admin.Invoice' in languages file, for example $text.BookingReference
*
* @param RM_Reservation_Row $reservation
* @return <type>
*/
public static function getInvoice(RM_Reservation_Row $reservation)
{
$translate = RM_Environment::getInstance()->getTranslation(RM_Environment::TRANSLATE_MAIN);
$data = new Dwoo_Data();
$data->assign('invoice', array('date' => date('d/m/Y')));
$config = new RM_Config();
$data->assign('currencysymbol', $config->getCurrencySymbol());
//TODO: resmania - we need to add discounts and coupons here
$reservationArray = $reservation->toArray();
$billing = new RM_Billing();
$priceCharges = $billing->getPrice($reservation->id);
$reservationArray['tax'] = $priceCharges->tax;
$reservationArray['paid'] = $billing->getPaymentsTotal($reservation);
$reservationArray['due'] = abs($priceCharges->total - $billing->getPaymentsTotal($reservation));
$reservationArray['total'] = $priceCharges->total;
$reservationArray['confirmed'] = $reservation->confirmed ? $translate->_('MessageYes') : $translate->_('MessageNo');
$reservationArray['is_read'] = $reservation->is_read ? $translate->_('MessageYes') : $translate->_('MessageNo');
$data->assign('reservation', $reservationArray);
$text = $translate->getSectionMessages('Common.Invoice');
$data->assign('text', $text);
$userModel = new RM_Users();
$user = $userModel->getByReservation($reservation);
if ($user == null) {
$userArray = array();
} else {
$userArray = $user->toArray();
$userArray['title'] = $user->getTitle();
}
$data->assign('customer', $userArray);
$reservationDetailsModel = new RM_ReservationDetails();
$summaryModel = new RM_ReservationSummary();
$details = $reservationDetailsModel->getAllByReservation($reservation);
$arrayDetails = array();
foreach ($details as $detail) {
$arrayDetail = $detail->toArray();
$unit = $detail->findUnit();
$unitArray = $unit->toArray();
$unitArray['id'] = $unit->getId();
$unitArray['published'] = $unitArray->published ? $translate->_('MessageYes') : $translate->_('MessageNo');
// format the start/end dates
$arrayDetail['start_datetime'] = $config->convertDates($arrayDetail['start_datetime'], RM_Config::PHP_DATEFORMAT, RM_Config::JS_DATEFORMAT);
$arrayDetail['end_datetime'] = $config->convertDates($arrayDetail['end_datetime'], RM_Config::PHP_DATEFORMAT, RM_Config::JS_DATEFORMAT);
// extras
$reservationDetailsExtra = $summaryModel->fetchByReservationDetail($detail)->toArray();
foreach ($reservationDetailsExtra as $extra) {
if ($extra['value'] == 0) {
$extra['value'] = "";
}
$unitArray['extras'][] = array("name" => $extra['name'], "value" => $extra['value'], "total_amount" => $extra['total_amount']);
}
$arrayDetail['unit'] = $unitArray;
$arrayDetails[] = $arrayDetail;
}
$data->assign('details', $arrayDetails);
$templateFile = implode(DIRECTORY_SEPARATOR, array(RM_Environment::getConnector()->getRootPath(), 'RM', 'userdata', 'views', 'admin', 'scripts', 'templates', 'invoice.phtml'));
$template = new Dwoo_Template_File($templateFile);
$dwoo = new Dwoo();
return $dwoo->get($template, $data);
}
