public function actionIndex() { $travelsM = new Travel; //分配焦点图到页面 $focusmap = $this->getPictureFormImg(6,3); //分配特色团到页面(这里的特色团是flag标记为 1 的产品信息) $teseTuan = $travelsM->findAll(array( 'select'=>'id,title,current_audlt_price', 'condition'=>'flag=1 and enabled=1', 'order'=>'sort desc', 'limit'=>15, )); //分配15个排序最靠前的旅游产品 作为 热门路线 $hottravels = $travelsM->findAll(array( 'select'=>'id,title', 'condition'=>'enabled=1', 'order'=>'sort desc', 'limit'=>15, )); //输出还未结束的特卖信息 $CalModel = new Travelcalendar; $criteria=new CDbCriteria; $criteria->select = "id,tid,aduit_price,date"; $criteria->addCondition('enabled=1'); $criteria->addCondition('flag=1'); $now = time(); $criteria->addCondition("stoptime>$now"); $criteria->order = "starttime asc,updatetime desc"; $count=$CalModel->count($criteria); $pages=new CPagination($count); $pages->pageSize=5; $pages->applyLimit($criteria); $cals = $CalModel->findAll($criteria); $this->render('index',array( 'teseTuan'=>$teseTuan, 'hottravels'=>$hottravels, 'focusmap'=>$focusmap, 'pages'=>$pages, 'travels'=>$cals, )); }
public function actionCanelgo() { $CModel = new Travelcalendar; $criteria=new CDbCriteria; if(isset($_POST['number']) && !empty($_POST['number'])){ $criteria->compare('trackcode',$_POST['number'],true); } if(isset($_POST['name']) && !empty($_POST['name'])){ $name = $_POST['name']; $travelarr = Travel::model()->findAll(array('select'=>'id','condition'=>"title like '%$name%'")); if(empty($travelarr)){ $criteria->addCondition("tid=0"); }else{ foreach($travelarr as $ar){ $criteria->addCondition("tid=".$ar->id,'OR'); } } } if(isset($_POST['start']) && !empty($_POST['start'])){ $start = strtotime($_POST['start']); $criteria->addCondition("date>=$start"); } if(isset($_POST['stop']) && !empty($_POST['stop'])){ $start = strtotime($_POST['stop']); $criteria->addCondition("date<=$start"); } $criteria->addCondition('enabled=0'); //$criteria->addCondition("date<=$now"); //$criteria->condition = "enabled=0"; $count=$CModel->count($criteria); $pages=new CPagination($count); $pages->pageSize=15; $pages->applyLimit($criteria); $calArr = $CModel->findAll($criteria); $this->render('canelgo',array( 'calArr'=>$calArr, 'pages'=>$pages, )); }