request; $pageNumber = $request->get('pageNumber', 1); $pageSize = $request->get('pageSize', 10); $category_id = $request->get('id'); $searchBy = $request->get('searchBy',''); $keyword = $request->get('keyword',''); $query = Product::find()->alias('a') ->leftJoin('bit_product_category pc', 'a.category_id = pc.id'); $query->select('a.*,pc.cname'); if(isset($category_id)){ $query->where(['category_id' => $category_id]); } if(!empty($keyword) && !empty($searchBy)){ $query->andFilterWhere(['like', $searchBy, $keyword]); } $result = PaginationHelper::queryPage($query, $pageNumber, $pageSize); return $this->outJson(1, $result); } public function actionDetail() { $id = \Yii::$app->request->get('id',0); $product = Product::find(); $rs = $product->where(['id' => $id])->asArray()->one(); return $this->outJson(1, $rs); } public function actionUpdate() { $request = \Yii::$app->request; $id = $request->post('id',0); if($id){ $model = Product::findOne($id); $model->m_time = time(); }else{ $model = new Product(); $model->c_time = time(); } $model->category_id = $data['category_id'] = $request->post('category_id',0); $model->name = $data['name'] = $request->post('name',''); $model->name1 = $data['name1'] = $request->post('name1',''); $model->name2 = $data['name2'] = $request->post('name2',''); $model->tradetype = $data['tradetype'] = $request->post('tradetype',0); $model->tradecode = $data['tradecode'] = $request->post('tradecode',''); $model->contract = $data['contract'] = $request->post('contract',0); $model->deposit = $data['deposit'] = $request->post('deposit',0); $model->commission = $data['commission'] = $request->post('commission',0); $model->interest = $data['interest'] = $request->post('interest',0); $model->min_amplitude = $data['min_amplitude'] = $request->post('min_amplitude',0); $model->price = $data['price'] = $request->post('price',0); $model->min_trade = $data['min_trade'] = $request->post('min_trade',0); $model->max_trade = $data['max_trade'] = $request->post('max_trade',0); $model->trade_time = $data['trade_time'] = $request->post('trade_time',''); $model->trade_time1 = $data['trade_time1'] = $request->post('trade_time1',''); $model->trade_time2 = $data['trade_time2'] = $request->post('trade_time2',''); $model->settlement_time = $data['settlement_time'] = $request->post('settlement_time',''); $model->settlement_time1 = $data['settlement_time1'] = $request->post('settlement_time1',''); $model->settlement_time2 = $data['settlement_time2'] = $request->post('settlement_time2',''); $model->limit_line = $data['limit_line'] = $request->post('limit_line',''); $model->limit_line1 = $data['limit_line1'] = $request->post('limit_line1',''); $model->limit_line2 = $data['limit_line2'] = $request->post('limit_line2',''); $model->lock_deposit = $data['lock_deposit'] = $request->post('lock_deposit',''); $model->lock_deposit1 = $data['lock_deposit1'] = $request->post('lock_deposit1',''); $model->lock_deposit2 = $data['lock_deposit2'] = $request->post('lock_deposit2',''); $model->unit = $data['unit'] = $request->post('unit',''); $model->unit1 = $data['unit1'] = $request->post('unit1',''); $model->unit2 = $data['unit2'] = $request->post('unit2',''); $model->c_time = $data['c_time'] = $request->post('c_time',0); $model->m_time = $data['m_time'] = $request->post('m_time',0); $model->setAttributes($data); if($model->save()){ return $this->outJson(1, $model->id); } else { return $this->outJson(0, [], '失败'); } } }