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]);
}
