public function bookATableMerchant()
{
$merchant_id = Yii::app()->functions->getMerchantID();
$params = array('merchant_id' => $merchant_id, 'number_guest' => isset($this->data['number_guest']) ? $this->data['number_guest'] : '', 'date_booking' => isset($this->data['date_booking']) ? $this->data['date_booking'] : '', 'booking_time' => isset($this->data['booking_time']) ? $this->data['booking_time'] : '', 'booking_name' => isset($this->data['booking_name']) ? $this->data['booking_name'] : '', 'email' => isset($this->data['email']) ? $this->data['email'] : '', 'mobile' => isset($this->data['mobile']) ? $this->data['mobile'] : '', 'booking_notes' => isset($this->data['booking_notes']) ? $this->data['booking_notes'] : '', 'date_created' => date('c'), 'ip_address' => $_SERVER['REMOTE_ADDR'], 'status' => isset($this->data['status']) ? $this->data['status'] : '', 'viewed' => 2);
$command = Yii::app()->db->createCommand();
if (isset($this->data['id']) && is_numeric($this->data['id'])) {
unset($params['date_created']);
$params['date_modified'] = date('c');
$res = $command->update('{{bookingtable}}', $params, 'booking_id=:booking_id', array(':booking_id' => addslashes($this->data['id'])));
if ($res) {
$this->code = 1;
$this->msg = Yii::t("default", 'Booking updated.');
} else {
$this->msg = Yii::t("default", "ERROR: cannot update");
}
} else {
if ($res = $command->insert('{{bookingtable}}', $params)) {
$this->details = Yii::app()->db->getLastInsertID();
//dump($this->details);
$this->code = 1;
$this->msg = Yii::t("default", 'Booking added.');
} else {
$this->msg = Yii::t("default", 'ERROR. cannot insert data.');
}
}
$this->details = 3;
//dump($this->data);
if (isset($this->data['send_email'])) {
if ($this->code == 1 || $this->data['send_email'] == 1) {
$tp1 = Yii::app()->functions->getOption("merchant_booking_approved_tpl", $merchant_id);
$tp2 = Yii::app()->functions->getOption("merchant_booking_denied_tpl", $merchant_id);
$subject = Yii::app()->functions->getOption("merchant_booking_subject", $merchant_id);
$sender = Yii::app()->functions->getOption("merchant_booking_sender", $merchant_id);
$to = $this->data['email'];
$subject = empty($subject) ? "Booking Table" : $subject;
if (empty($tp1)) {
$tp1 = EmailTPL::bookingApproved();
}
if (empty($tp2)) {
$tp2 = EmailTPL::bookingDenied();
}
$h = '';
$h .= '<table border="0">';
$h .= '<tr>';
$h .= '<td>' . Yii::t("default", "Number Of Guests") . '</td>';
$h .= '<td>: ' . $params['number_guest'] . '</td>';
$h .= '</tr>';
$h .= '<tr>';
$h .= '<td>' . Yii::t("default", "Date Of Booking") . '</td>';
$h .= '<td>: ' . $params['date_booking'] . '</td>';
$h .= '</tr>';
$h .= '<tr>';
$h .= '<td>' . Yii::t("default", "Time") . '</td>';
$h .= '<td>: ' . $params['booking_time'] . '</td>';
$h .= '</tr>';
$h .= '<tr>';
$h .= '<td>' . Yii::t("default", "Name") . '</td>';
$h .= '<td>: ' . $params['booking_name'] . '</td>';
$h .= '</tr>';
$h .= '<tr>';
$h .= '<td>' . Yii::t("default", "Email") . '</td>';
$h .= '<td>: ' . $params['email'] . '</td>';
$h .= '</tr>';
$h .= '<tr>';
$h .= '<td>' . Yii::t("default", "Mobile") . '</td>';
$h .= '<td>: ' . $params['mobile'] . '</td>';
$h .= '</tr>';
$h .= '<tr>';
$h .= '<td>' . Yii::t("default", "Message") . '</td>';
$h .= '<td>: ' . $params['booking_notes'] . '</td>';
$h .= '</tr>';
$h .= '</table>';
if ($this->data['status'] == "approved") {
$template = Yii::app()->functions->smarty("customer-name", $params['booking_name'], $tp1);
$template = Yii::app()->functions->smarty("message", $this->data['message'], $template);
$template = Yii::app()->functions->smarty("booking-information", $h, $template);
} elseif ($this->data['status'] == "denied") {
$template = Yii::app()->functions->smarty("customer-name", $params['booking_name'], $tp2);
$template = Yii::app()->functions->smarty("message", $this->data['message'], $template);
$template = Yii::app()->functions->smarty("booking-information", $h, $template);
}
if (!sendEmail($to, $sender, $subject, $template)) {
$this->details = 2;
} else {
$this->details = 1;
}
}
}
}
?>
/merchant/tablebooking/Do/settings" class="uk-button"><i class="fa fa-cog"></i> <?php
echo Yii::t("default", "Settings");
?>
</a>
</div>
<div class="spacer"></div>
<?php
$merchant_id = Yii::app()->functions->getMerchantID();
$merchant_booking_alert = Yii::app()->functions->getOption("merchant_booking_alert", $merchant_id);
$tp1 = Yii::app()->functions->getOption("merchant_booking_approved_tpl", $merchant_id);
$tp2 = Yii::app()->functions->getOption("merchant_booking_denied_tpl", $merchant_id);
if (empty($tp1)) {
$tp1 = EmailTPL::bookingApproved();
}
if (empty($tp2)) {
$tp2 = EmailTPL::bookingDenied();
}
$subject = Yii::app()->functions->getOption("merchant_booking_subject", $merchant_id);
$sender = Yii::app()->functions->getOption("merchant_booking_sender", $merchant_id);
$merchant_booking_receiver = Yii::app()->functions->getOption("merchant_booking_receiver", $merchant_id);
$merchant_booking_tpl = Yii::app()->functions->getOption("merchant_booking_tpl", $merchant_id);
if (empty($merchant_booking_tpl)) {
$merchant_booking_tpl = EmailTPL::bookingTPL();
}
$merchant_booking_receive_subject = Yii::app()->functions->getOption("merchant_booking_receive_subject", $merchant_id);
$days = Yii::app()->functions->getDays();
$max_booked = Yii::app()->functions->getOption("max_booked", $merchant_id);
if (!empty($max_booked)) {
