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
}
?>
