public function search() { $page = Yii::$app->request->get('page', 0); $page = $page < 0 ? 0 : $page - 1; $limit = Yii::$app->request->get('limit', 25); $sorts = json_decode(trim(Yii::$app->request->get('sort')), true); $startDay = Yii::$app->request->get('start_date'); $endDay = Yii::$app->request->get('end_date'); $status = Yii::$app->request->get('status'); $title = Yii::$app->request->get('title'); $query = MaggieActiveSociety::find()->filterWhere(['between', 'date', $startDay, $endDay])->andFilterWhere(['status' => $status])->andFilterWhere(['like', 'title', $title]); $countQuery = clone $query; $pagination = new Pagination(['totalCount' => $countQuery->count(), 'pageSize' => $limit]); if ($sorts != null) { foreach ($sorts as $sort) { $query->addOrderBy([$sort['property'] => $sort['direction'] == 'ASC' ? SORT_ASC : SORT_DESC]); } } else { $query->addOrderBy(['id' => SORT_DESC]); } //var_dump($query);exit; $model = $query->offset($pagination->offset)->limit($limit)->all(); return ['count' => $countQuery->count(), 'model' => $model]; }
public function actionDelete() { if (Yii::$app->user->isGuest) { $this->ajax_return(false, '登录以后才能进行此操作!'); } if (!in_array(Yii::$app->user->identity->getId(), $this->_admin)) { $this->ajax_return(false, '权限不足!'); } $id = intval(Yii::$app->request->getBodyParam('id')); $model = MaggieActiveSociety::findOne($id); if ($model == null) { $this->ajax_return(false, '数据已不存在!'); } if ($model->status == 'ON') { $this->ajax_return(false, '已经确认的活动,无法删除!'); } if ($model->delete()) { $this->ajax_return(true, '操作成功!'); } else { $this->ajax_return(false, '操作失败!'); } }