public static function getPicCityTourByLocation($location_id)
{
$db = new Application_Model_DbTable_DbFrontend();
$sql = " SELECT pic_title FROM `ldc_picture_location` WHERE location_id={$location_id} AND STATUS=1 AND pic_title!='' ORDER BY id ASC LIMIT 1";
return $db->getGlobalDbRow($sql);
}
function citytourdetailAction()
{
$id = $this->getRequest()->getParam("id");
$db = new Application_Model_DbTable_Dbbookingcitytour();
$this->view->row = $db->getPackageCityTourDetailById($id);
$this->view->photo = $db->getPackagPhotoById($id);
// print_r($db->getPackageCityTourDetailById($id));
$db = new Application_Model_DbTable_DbFrontend();
$this->view->alllocation = $db->getLocatoinTurByPackageId($id);
}
function indexAction()
{
$db = new Application_Model_DbTable_DbFrontend();
// $data = $db->getmenucontact();
// $this->view->showdata= $data;
$this->view->vehicle = $db->getVehicleDiscount();
$this->view->welcome = $db->getAllWelcomenote();
if ($this->getRequest()->isPost()) {
$post = $this->getRequest()->getPost();
if (isset($post["search_vehicle"])) {
$row = $db->getAvailableVehicle($post);
if ($row) {
$session_booking = new Zend_Session_Namespace('booking');
$session_booking->step_one = 1;
$session_booking->pickup_date = $post["pickup_date"];
$session_booking->return_date = $post["return_date"];
$session_booking->pickup_time = $post["pickup_time"];
$session_booking->return_time = $post["return_time"];
$session_booking->pickup_location = $post["pickup_location"];
$session_booking->return_location = $post["return_location"];
$diff = date_diff($post["pickup_date"], $post["return_date"]);
$session_booking->total_day = $diff->format("%a%");
Application_Form_FrmMessage::redirectUrl("/index/booking");
} else {
Application_Form_FrmMessage::message("No Vehicle Available!");
}
}
}
$frmbooks = new Application_Form_FrmBook();
$frmbooking = $frmbooks->getFromBooking();
Application_Model_Decorator::removeAllDecorator($frmbooking);
$this->view->frmbooking = $frmbooks->getFromBooking();
}
