public function actionIndex()
{
//查询最新的四张首页缩略图
$focusimgs = $this->getPictureFormImg(10,4);
//分配 10条热门产品 （即排序最靠前的十条产品）
$tenhots = Travel::model()->findAll(array(
'select'=>'id,title,current_audlt_price',
'condition'=>'enabled=1',
'order'=>'sort desc',
'limit'=>10,
));
$this->render('index',array(
'tenhots'=>$tenhots,
'focusimgs'=>$focusimgs,
));
}
public function getTravelSome($tid)
{
$model = Travel::model()->findByPk($tid,array('select'=>'id,title,to_addr,daynumber,thumb,current_audlt_price','condition'=>'enabled=1'));
return $model;
}
protected function getOneTravelByPk($id)
{
$model = Travel::model()->findByPk($id);
return $model;
}
private function getTravelInfo($id)
{
$travel = Travel::model()->find(array(
'select'=>'current_audlt_price,current_child_price',
'condition'=>"id=$id",
));
return $travel;
}
private function getTravelMdid()
{
$allArr = array();
$arr = Travel::model()->findAll(array(
'select'=>'to_addr',
'condition'=>'enabled<>0',
));
foreach($arr as $ar){
$temparr = explode(';',$ar['to_addr']);
foreach($temparr as $tempar){
if(array_key_exists($tempar,$allArr)){
$allArr[$tempar] += 1;
}else{
if(!isset($allArr[$tempar])){
$allArr[$tempar] = 1;
}else{
$allArr[$tempar] += 1;
}
}
}
}
return $allArr;
}
public function getTravelName($tid)
{
$model = Travel::model()->find(array('select'=>'title','condition'=>"id=$tid"));
return $model->title;
}
private function loadModel($id)
{
$model=Travel::model()->findByPk($id);
if($model===null){
$this->render('404',array('msg'=>'抱歉，暂时还没有该团!'));
exit;
}
//throw new CHttpException(404,'The requested page does not exist.');
return $model;
}
private function getTravelByPk($id)
{
$model = Travel::model()->find(array(
'select'=>'aduit_price,childen_price',
'condition'=>"id=$id",
));
return array(
'audit_price'=>$model->aduit_price,
'child_price'=>$model->childen_price,
);
}
public function getProductNameByPk($id)
{
$model = Travel::model()->find(array('select'=>'title','condition'=>"id=$id"));
return $model->title;
}
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,
));
}
public function getDayRangeCount($index)
{
$tempArr = $this->dayRangeList();
$ceil = $tempArr[$index][1];
$lower = $tempArr[$index][0];
$count = 0;
if($ceil!=0){
$count = Travel::model()->count(array(
'condition'=>"daynumber>=$lower and daynumber<=$ceil and enabled<>0",
));
}else{
$count = Travel::model()->count(array(
'condition'=>"daynumber>=$lower and enabled<>0",
));
}
return $count;
}
public function getTravelInfoByPk($id)
{
$model = Travel::model()->find(array('select'=>'trackcode,title','condition'=>"id=$id"));
return $model;
}
