public static function fetchByType($type = 1, $filter, $order, $page = 1) { if ($type != 1 && $type != 2 && $type != 3) { return array(); } $select = self::select(); $select->where('type = ?', $type)->where('status =1'); if ($filter == 1 || $filter == 2) { $select->where('location_type = ?', $filter); } if ($order == 1) { $select->order('adult_dprice desc'); } elseif ($order == 2) { $select->order('adult_dprice asc'); } elseif ($order == 3) { $select->order('sales desc'); } elseif ($order == 4) { $select->order('sales asc'); } $adapter = new Zend_Paginator_Adapter_DbTableSelect($select); $paginator = new Zend_Paginator($adapter); $paginator->setItemCountPerPage(10)->setCurrentPageNumber($page); $data = $paginator->getCurrentItems(); $pages = $paginator->count(); $travels = array(); if (count($data) > 0) { foreach ($data as $da) { $travelModel = new Application_Model_O_Travel(); $travelModel->setId($da->id)->setType($da->type)->setLocation_type($da->location_type)->setAdult_oprice($da->adult_oprice)->setAdult_dprice($da->adult_dprice)->setChild_oprice($da->child_oprice)->setChild_dprice($da->child_dprice)->setArea($da->area)->setSales($da->sales)->setTitle($da->title)->setSubtitle($da->subtitle)->setImg($da->img)->setCtime($da->ctime)->setUtime($da->utime)->setStatus($da->status); array_push($travels, $travelModel); } } $res = array('travels' => $travels, 'pages' => $pages); return $res; }
public static function fetchAll($where = null, $order = null, $limit = null, $offset = null) { $resultSet = self::getDbTable()->fetchAll($where, $order, $limit, $offset); $entries = array(); foreach ($resultSet as $row) { $entry = new Application_Model_O_Travel(); $entry->setId($row->id)->setType($row->type)->setLocation_type($row->location_type)->setAdult_oprice($row->adult_oprice)->setAdult_dprice($row->adult_dprice)->setChild_oprice($row->child_oprice)->setChild_dprice($row->child_dprice)->setArea($row->area)->setSales($row->sales)->setTitle($row->title)->setSubtitle($row->subtitle)->setImg($row->img)->setCtime($row->ctime)->setUtime($row->utime)->setStatus($row->status); $entry->setNew(false); $entries[] = $entry; } return $entries; }
public function asyncajaxAction() { $this->getResponse()->setHeader('Content-Type', 'application/json'); $this->_helper->viewRenderer->setNoRender(true); $this->_helper->layout()->disableLayout(); $params = $this->_getAllParams(); //var_dump($params);exit; // unset($params['controller']); // unset($params['action']); // unset($params['module']); $travel = new Application_Model_O_Travel(); $validate = new Yy_Validate_Value(); if ($validate->isValid($params['id'])) { $travel->setId($params['id']); } else { $travel->setCtime(date('Y-m-d H:i:s')); } if ($validate->isValid($params['type'])) { $travel->setType($params['type']); } if ($validate->isValid($params['location_type'])) { $travel->setLocation_type($params['location_type']); } if ($validate->isValid($params['adult_oprice'])) { $travel->setAdult_oprice($params['adult_oprice']); } if ($validate->isValid($params['adult_dprice'])) { $travel->setAdult_dprice($params['adult_dprice']); } if ($validate->isValid($params['child_oprice'])) { $travel->setChild_oprice($params['child_oprice']); } if ($validate->isValid($params['child_dprice'])) { $travel->setChild_dprice($params['child_dprice']); } if ($validate->isValid($params['area'])) { $travel->setArea($params['area']); } if ($validate->isValid($params['sales'])) { $travel->setSales($params['sales']); } if ($validate->isValid($params['title'])) { $travel->setTitle($params['title']); } if ($validate->isValid($params['subtitle'])) { $travel->setSubtitle($params['subtitle']); } if ($validate->isValid($params['status'])) { $travel->setStatus($params['status']); } try { $travel->save(); $id = $travel->getId(); //保存行程图片 $adapter = new Zend_File_Transfer_Adapter_Http(); $wrdir = Yy_Utils::getWriteDir(); $adapter->setDestination($wrdir); if (!$adapter->receive()) { $messages = $adapter->getMessages(); //echo implode("\n", $messages); } $filename = $adapter->getFileName(); if (is_string($filename)) { $handle = fopen($filename, 'rb'); $img = addslashes(fread($handle, filesize($filename))); fclose($handle); Application_Model_M_Travel::updateImage($id, $img); } $url = '/travel/view?id=' . $id . '&from=add'; $this->redirect($url); } catch (Zend_Db_Exception $e) { $this->redirect('/error?message=' . $e->getMessage()); } }