request->get(); $query = xhGoods::find(); $status = isset($get['status']) ? $get['status'] : -1; if(isset($get['status']) && $get['status'] != -1){ $query->andWhere(['status' => $get['status']]); } $query->andWhere(['delStatus' => 0]); if(isset($get['goodsName']) && !empty($get['goodsName'])){ $query->andWhere(['like', 'goodsName', $get['goodsName']]); } $query->orderBy('id desc'); $countQuery = clone $query; $count = $countQuery->count(); $page = isset($get['page']) ? $get['page'] : 1; $pageSize = 20; $offset = ($page - 1) * $pageSize; $models = $query->offset($offset)->limit($pageSize)->asArray()->all(); $page = new page($count,$page,$pageSize); $paging = $page->fpage(); return $this->render('list', ['models' => $models,'paging' => $paging,'status' => $status,]); } }