public function searchDataWargaRW($params, $id) { $query = Warga_data::find()->where('STATUS<>3 AND RW=' . $id)->orderBy(['RT' => 'SORT_ASC', 'RUMAH_NO' => 'SORT_ASC']); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 200]]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['ID' => $this->ID, 'RUMAH_NO' => $this->RUMAH_NO, 'RUMAH_STT' => $this->RUMAH_STT, 'JUMLAH_ANGOTA' => $this->JUMLAH_ANGOTA]); $query->andFilterWhere(['like', 'RT', $this->RT])->andFilterWhere(['like', 'KK_NM', $this->KK_NM])->andFilterWhere(['like', 'RUMAH_BLOCK', $this->RUMAH_BLOCK])->andFilterWhere(['like', 'TLP_RUMAH', $this->TLP_RUMAH])->andFilterWhere(['like', 'TLP_KANTOR', $this->TLP_KANTOR])->andFilterWhere(['like', 'TLP_HP', $this->TLP_HP]); return $dataProvider; }
public function actionIndex($id) { $searchModel = new Warga_dataSearch(); if ($id == 11) { //RW $modelRslt = Warga_data::find()->where('STATUS<>3 AND RW=' . $id)->one(); $model = $modelRslt != '' ? $modelRslt : '0'; $dpDataProvider = $searchModel->searchDataWargaRW(Yii::$app->request->queryParams, $id); } else { //RT $modelRslt = Warga_data::find()->where('STATUS<>3 AND RT=' . $id)->one(); $model = $modelRslt != '' ? $modelRslt : '0'; $dpDataProvider = $searchModel->searchDataWargaRT(Yii::$app->request->queryParams, $id); } if ($id == 1 or $id == 2 or $id == 3 or $id == 4 or $id == 11) { return $this->render('index', ['id' => $id, 'model' => $model, 'searchModel' => $searchModel, 'dpDataProvider' => $dpDataProvider]); } else { /*NO DATA*/ return $this->render('indexNoData'); } }
/** * Finds the Warga_data model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param string $id * @return Warga_data the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Warga_data::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }