public function emailinvoiceJsonAction()
{
$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')));
}
$model = new RM_Reservations();
$reservation = $model->find($reservationID)->current();
if ($reservation == null) {
return array('data' => array('success' => false, 'error' => RM_Environment::getInstance()->getTranslation(RM_Environment::TRANSLATE_ERRORS)->_('Admin.Reservation.Edit', 'WrongReservationID')));
}
$emailBody = RM_Reservations::getInvoice($reservation);
$mail = new Zend_Mail('UTF-8');
$mail->setBodyHtml($emailBody);
$config = new RM_Config();
$mail->setFrom($config->getValue('rm_config_administrator_email'), $config->getValue('rm_config_email_settings_fromname'));
$confirm = $this->_getParam('rm_reservation_edit_send_invoice_confirm', 0);
if ($confirm) {
$userModel = new RM_Users();
$user = $userModel->getByReservation($reservation);
if ($user !== null) {
$mail->addTo($user->email, $user->first_name . ' ' . $user->last_name);
}
}
$extraAddresses = $this->_getParam('rm_reservation_edit_send_invoice_email', '');
$extraAddresses = explode(',', $extraAddresses);
//Here could be a multiple emails to send invoice to
foreach ($extraAddresses as $address) {
$mail->addTo($address);
}
$mail->setSubject(RM_Environment::getInstance()->getTranslation(RM_Environment::TRANSLATE_MAIN)->_('Admin.Reservations.Edit', 'InvoiceForReservation') . $reservation->id);
try {
$mail->send();
return array('data' => array('success' => true));
} catch (Exception $e) {
return array('data' => array('success' => false, 'msg' => $e->getMessage()));
}
}
/**
* 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);
}
