//控制器
public function actionIndex() {
$model = array('platform_id' => '', 't_article_type_id' => '', '_like' => '', 'begin_create_at' => '2016-08-15', 'end_create_at' => date('Y-m-d'),);
$criteria = new CDbCriteria();
$criteria->order = 'id DESC';
#get请求赋值
foreach ($model as $key => $val) {
if (isset($_GET[$key]) && $_GET[$key] !== '' && $_GET[$key] !== 'null')
$model[$key] = $_GET[$key]; //给model赋值
}
#post请求赋值
if (Yii::app()->request->isPostRequest) {
foreach ($model as $key => $val) {
if (isset($_POST[$key]) && $_POST[$key] !== '' && $_POST[$key] !== 'null')
$model[$key] = $_POST[$key]; //给model赋值
}
}
#一般查询
if ($model['platform_id'])
$criteria->compare('platform_id', $model['platform_id']);
if ($model['t_article_type_id'])
$criteria->compare('t_article_type_id', $model['t_article_type_id']);
#like查询
if ($model['_like']) {
$criteria->addCondition('source like :key OR title like :key');
$criteria->params[':key'] = $model['_like'] . '%';
}
#时间查询
$criteria->addCondition("create_at>='" . $model['begin_create_at']." 00:00:00'");
$criteria->addCondition("create_at<'" . date("Y-m-d",strtotime('+1 day', strtotime($model['end_create_at'])))." 00:00:00'" );
//数据导出
if (isset($_GET['export']) && $_GET['export'] == 'exportData') {
$lists = TArticles::model()->findAll($criteria);
$list = array();
$key = 0;
foreach ($lists as $item) {
$list[$key]["文章Id"] = $item['id'];
$_model = Platforms::model()->findByPk($item['platform_id']);
$list[$key]["平台"] = empty($_model) ? "" : $_model["name"];
$_model = TArticleTypes::model()->findByPk($item['t_article_type_id']);
$list[$key]["类型"] = empty($_model) ? "" : $_model["name"];
$list[$key]["来源"] = $item['source'];
$list[$key]["标题"] = $item['title'];
$list[$key]["内容"] = $item['content'];
$list[$key]["创建时间"] = $item['create_at'];
$list[$key]["有效"] = $item['status']==0?"有效":无效;
$key++;
}
Yii::import('ext.ECSVExport');
$csv = new ECSVExport($list);
$content = $csv->toCSV();
Yii::app()->getRequest()->sendFile('data.csv', mb_convert_encoding($content, 'gbk', 'utf-8'), "text/csv", false);
exit;
}
$result = TArticles::model()->count($criteria);
$pager = new CPagination($result);
$pager->pageSize = 15;
$pager->applyLimit($criteria);
$list = TArticles::model()->findAll($criteria);
$this->render('index', compact('model', 'list', 'pager'));
}
//HTML代码
<p class="gap">
<a href="#" title="查询" id="submit" οnclick="$('#queryForm').submit();return false;" class ="btn_fenpei">查询</a>
</p>
<p class="gap"><a href="javascript:void(0)" id="exportData" style="margin-top:3px;" title="数据导出" class="but_sj">数据导出</a></p>
//数据导出
<script type="text/javascript">
$(function() {
//$("#queryForm").append('<p class="gap"><a href="javascript:void(0)" id="exportData" style="margin-top:3px;" title="数据导出" class="but_sj">数据导出</a></p>');
$("#exportData").click(function() {
$('#queryForm').append('<input type="hidden" id="export" name="export" value="exportData" />').submit();
$("#export").remove();
return false;
});
});
</script>