public function actionAudit() { $model = new CommoditySearchForm(); $model->load(Yii::$app->request->post()); $query = (new Query())->select(Commodity::tableName() . '.*')->from(Commodity::tableName())->leftJoin(CommodityOrderTemplet::tableName(), CommodityOrderTemplet::tableName() . '.cid = ' . Commodity::tableName() . '.id')->where('1=1'); if (!empty($model->shop)) { $query->andWhere('shop=:shop', [':shop' => $model->shop]); } if (!empty($model->commodity)) { $query->andWhere('commodity_id like :commodity_id', [':commodity_id' => '%' . $model->commodity . '%']); } if (!empty($model->sku)) { $query->andWhere('sku=:sku', [':sku' => $model->sku]); } if (!empty($model->btime)) { $query->andWhere(Commodity::tableName() . '.create_time >= :create_time', [':create_time' => $model->btime]); } if (!empty($model->etime)) { $query->andWhere(Commodity::tableName() . '.create_time <= :create_time', [':create_time' => $model->etime]); } $query->andWhere('statu = 0'); $query->orderBy(Commodity::tableName() . '.create_time desc'); $query->groupBy(Commodity::tableName() . '.id'); $pages = new Pagination(['totalCount' => $query->count(), 'pageSize' => '20']); $query->limit($pages->limit)->offset($pages->offset); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => false]); $audit_json = array(); foreach (Commodity::$Audits as $key => $value) { $enarray = ['value' => $key, 'text' => $value]; array_push($audit_json, $enarray); } $audit_json = json_encode($audit_json); return $this->render('audit', ['model' => $model, 'dataProvider' => $dataProvider, 'pages' => $pages, 'audit_json' => $audit_json]); }