public function search($params, $id) { $query = DetailList::find()->where(['KD_RIB' => $id]); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { //return $dataProvider; //$dataProvider->query->where('0=1'); return $dataProvider; } // $query->andFilterWhere(['like', 'KD_RIB', $this->KD_RO]) // ->andFilterWhere(['like', 'r0001.KD_CORP', $this->getAttribute('corp.CORP_NM')]) // ->andFilterWhere(['like', 'EMP_NM', $this->EMP_NM]) // ->andFilterWhere(['like', 'u0002a.DEP_NM', $this->getAttribute('dept.DEP_NM')]); // if($this->CREATED_AT!=''){ // $date_explode = explode(" - ", $this->CREATED_AT); // $date1 = trim($date_explode[0]); // $date2= trim($date_explode[1]); // $query->andFilterWhere(['between','CREATED_AT', $date1,$date2]); // } return $dataProvider; }
public function actionListAll($kd, $term_id, $cust_kd) { $model = new DetailList(); if ($model->load(Yii::$app->request->post())) { $model->TERM_ID = $term_id; $model->KD_RIB = $kd; $model->save(); return $this->redirect(['/purchasing/request-term/edit?kd=' . $model->KD_RIB]); } else { return $this->renderAjax('list_store', ['model' => $model, 'items' => self::aryData_Customers($cust_kd), 'list_store' => self::aryData_invest($term_id)]); } }