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(); }