public function actionIndex() { $this->_seoTitle = '我要去上课 - 课程汇总'; $criteria = new CDbCriteria(); //根据分类查找课程信息 $cat = Yii::app()->request->getParam('cat'); $city = Yii::app()->request->getParam('city'); $sex = Yii::app()->request->getParam('sex'); //课程分类 $catalogs = Catalog::getMenu(); if (!empty($city)) { $criteria->addCondition("city = '{$city}'"); } if (!empty($cat)) { $criteria->addCondition("catalog_id = '{$cat}'"); } if (!empty($sex)) { $criteria->addCondition("sex = '{$sex}'"); } $criteria->addCondition("check_status = :check_status"); $criteria->params[':check_status'] = 1; //分页 $count = Lesson::model()->count($criteria); $pager = new CPagination($count); $pager->pageSize = 5; $pager->applyLimit($criteria); $lessons = Lesson::model()->findAll($criteria->addCondition("check_status = 1")); $this->render('index', array('lessons' => $lessons, 'count' => $count, 'pager' => $pager, 'cat' => $cat, 'sex' => $sex, 'catalogs' => $catalogs, 'city' => $city, 'food' => $_GET['food'])); }
/** * Lists all models. */ public function actionIndex() { $this->_seoTitle = '我要去上课 - 名师库'; $criteria = new CDbCriteria(); //根据分类查找导师信息 $cat = Yii::app()->request->getParam('cat'); $district = Yii::app()->request->getParam('district'); //$areas = Area::model()->findAll(); $city = Yii::app()->request->getParam('city'); if (!empty($city)) { $criteria->addCondition("t.city = '{$city}'"); } if (!empty($cat)) { $criteria->addCondition("t.catalog_id = '{$cat}'"); } if (!empty($district)) { $criteria->addCondition("t.district = '{$district}'"); } //导师分类 $catalogs = Catalog::getMenu(); if (!empty($_GET['sort'])) { switch ($_GET['sort']) { case 'id': $criteria->order = 't.id DESC'; break; case 'review': $criteria->order = 't.review DESC'; break; case 'popularity': $criteria->order = 't.popularity DESC'; break; } } else { $criteria->order = 't.popularity DESC'; } //导师搜索 $nameStripTags = strip_tags(Yii::app()->request->getParam('name')); $name = addslashes($nameStripTags); if (!empty($name)) { $teacherName = '%' . $name . '%'; $criteria->addCondition("t.name like '{$teacherName}'"); } //分页 $count = Teacher::model()->count($criteria); $pager = new CPagination($count); $pager->pageSize = 5; $pager->applyLimit($criteria); $teachers = Teacher::model()->findAll($criteria); $this->render('index', array('teachers' => $teachers, 'city' => $city, 'count' => $count, 'pager' => $pager, 'cat' => $cat, 'catalogs' => $catalogs, 'name' => $name, 'sort' => $_GET['sort'])); }
<!--/*==========================▼site-category▼=========================*/--> <nav class="site-category" role="navigation"> <div class="container"> <h3 class="clear-m"> <small>Category</small> <span>课程分类</span> </h3> <!--课程分类--> <ul class="list-unstyled clearfix col-xs-offset-1 text-center category" role="list"> <?php $catalogs = Catalog::getMenu(); ?> <?php foreach ($catalogs as $catalog) { ?> <li role="listitem"> <a href="<?php echo Yii::app()->createUrl('lesson', array('cat' => $catalog->id)); ?> " title="<?php echo $catalog->catalog_name; ?> "><?php echo $catalog->catalog_name; ?> </a> </li> <?php } ?>