public function actionList() { $page = isset($_GET['page']) ? intval($_GET['page']) : 1; $model = new Discount(); $organID = Commonmodel::getOrganID(); //$organID=Yii::app()->user->id; $criteria = new CDbCriteria(); //查询条件 $criteria->addCondition("UserID=:userID and OrganID=:organID "); $criteria->params[':userID'] = Yii::app()->user->id; $criteria->params[':organID'] = $organID; //搜索条件 if ($_GET) { $search['title'] = $_GET['title']; $search['type'] = $_GET['type']; $search['status'] = $_GET['status']; $begintime = strtotime($_GET['dates']); $search['dates'] = strtotime("{$_GET['dates']}+ 1 day"); if ($search) { if ($search['title']) { $criteria->addSearchCondition('Title', "{$search['title']}", "AND"); } if (!empty($search['status']) || $search['status'] == 0) { $criteria->addSearchCondition('Status', "{$search['status']}", "AND"); } if (!empty($search['type']) || $search['type'] == 0) { $criteria->addSearchCondition("Type", "{$search['type']}", "AND"); } if (!empty($search['dates'])) { $criteria->addBetweenCondition('CreateTime', $begintime, $search['dates'], "AND"); } } } $criteria->order = "CreateTime DESC,ID DESC"; $count = $model->count($criteria); // //分页类调用 $pages = new CPagination($count); // //每页显示的行数 $pages->pageSize = $_GET['rows']; $pages->applyLimit($criteria); $model = $model->findAll($criteria); // $model=$model->findAll('Status=:status',array(':status'=>'0')); $data = array(); foreach ($model as $key => $value) { $data[$key]['ID'] = $value['ID']; $data[$key]['Title'] = $value["Title"]; $data[$key]['Content'] = $value['Content']; // $data[$key]['Type'] = $value['Type']; $data[$key]['TypeID'] = $value['Type']; switch ($value['Type']) { case 0: $data[$key]['Type'] = '抵扣券'; break; case 1: $data[$key]['Type'] = '折扣券'; break; case 2: $data[$key]['Type'] = '其他'; break; } if ($value['Type'] == 0) { $data[$key]['Rate'] = !empty($value['Rate']) ? $value['Rate'] : '无'; $data[$key]['Rate2'] = '减现' . $value['Rate'] . '元'; } if ($value['Type'] == 1) { $data[$key]['Rate'] = !empty($value['Rate']) ? $value['Rate'] : '无 '; $data[$key]['Rate2'] = '打' . $value['Rate'] . '折'; } if ($value['Type'] == 2) { $data[$key]['Rate'] = $value['Rate']; } $data[$key]['StartTime'] = date('Y/m/d H:i:s', $value['StartTime']); $data[$key]['EndTime'] = date('Y/m/d H:i:s', $value['EndTime']); $data[$key]['CreateTime'] = date('Y/m/d H:i:s', $value['CreateTime']); //$data[$key]['Rate']=$value['Rate']; $data[$key]['EffectTime'] = date('Y/m/d', $value['StartTime']) . '-' . date('Y/m/d', $value['EndTime']); if ($value['Status'] == 2) { if ($value['EndTime'] < time()) { $d = Discount::model()->updateByPk($value['ID'], array("Status" => 1)); } } switch ($value['Status']) { case 0: $data[$key]['Status'] = '未开启'; break; case 1: $data[$key]['Status'] = '已关闭'; break; case 2: $data[$key]['Status'] = '已开启'; break; } } $rs = array('total' => $count, 'rows' => !empty($data) ? $data : array()); echo json_encode($rs); }