/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = DraftPlan::find()->where('STATUS<>3')->orderBy(['GEO_ID' => SORT_DESC, 'GEO_SUB' => SORT_DESC, 'ODD_EVEN' => SORT_DESC, 'DAY_ID' => SORT_DESC]); // add conditions that should always apply here $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => false]); $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; } // grid filtering conditions $query->andFilterWhere(['ID' => $this->ID, 'GEO_ID' => $this->GeoNm, 'LAYER_ID' => $this->LayerNm, 'DAY_ID' => $this->DAY_ID, 'DAY_VALUE' => $this->DayNm, 'STATUS' => $this->STATUS, 'YEAR' => $this->YEAR, 'ODD_EVEN' => $this->GanjilGenap, 'CREATED_AT' => $this->CREATED_AT, 'UPDATED_AT' => $this->UPDATED_AT, 'CUST_KD' => $this->CUST_KD]); $query->andFilterWhere(['like', 'CUST_KD', $this->CustNm])->andFilterWhere(['like', 'CREATED_BY', $this->CREATED_BY])->andFilterWhere(['like', 'UPDATED_BY', $this->UPDATED_BY]); return $dataProvider; }
$actionClass = 'btn btn-info btn-xs'; $actionLabel = 'Update'; $attDinamik = []; /*GRIDVIEW ARRAY FIELD HEAD*/ $headColomn = [['ID' => 0, 'ATTR' => ['FIELD' => 'SCDL_GROUP', 'SIZE' => '10px', 'label' => 'GROUP CODE', 'align' => 'left', 'warna' => '73, 162, 182, 1', 'grp' => false]], ['ID' => 1, 'ATTR' => ['FIELD' => 'ganjilGenap', 'SIZE' => '20px', 'label' => 'Week', 'align' => 'center', 'warna' => '73, 162, 182, 1', 'grp' => true]], ['ID' => 2, 'ATTR' => ['FIELD' => 'dayNm', 'SIZE' => '20px', 'label' => 'Day Name', 'align' => 'center', 'warna' => '73, 162, 182, 1', 'grp' => true]], ['ID' => 3, 'ATTR' => ['FIELD' => 'geonm', 'SIZE' => '20px', 'label' => 'GROUP_PRN', 'align' => 'center', 'warna' => '73, 162, 182, 1', 'grp' => true]], ['ID' => 4, 'ATTR' => ['FIELD' => 'SUB_GEO', 'SIZE' => '20px', 'label' => 'GEO_SUB', 'align' => 'center', 'warna' => '73, 162, 182, 1', 'grp' => true]], ['ID' => 5, 'ATTR' => ['FIELD' => 'useridNm', 'SIZE' => '20px', 'label' => 'UserName', 'align' => 'center', 'warna' => '73, 162, 182, 1', 'grp' => true]]]; $gvHeadColomnBT = ArrayHelper::map($headColomn, 'ID', 'ATTR'); $attDinamik[] = ['class' => 'kartik\\grid\\SerialColumn', 'width' => '10px', 'header' => 'No.', 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => '10px', 'font-family' => 'verdana, arial, sans-serif', 'font-size' => '9pt', 'background-color' => 'rgba(73, 162, 182, 1)']], 'contentOptions' => ['style' => ['text-align' => 'center', 'width' => '10px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '9pt']]]; /*GRIDVIEW ARRAY ROWS*/ foreach ($gvHeadColomnBT as $key => $value[]) { if ($value[$key]['FIELD'] == 'geonm') { # code... $attDinamik[] = ['attribute' => $value[$key]['FIELD'], 'label' => $value[$key]['label'], 'filterType' => GridView::FILTER_SELECT2, 'filter' => $drop, 'filterWidgetOptions' => ['pluginOptions' => ['allowClear' => true]], 'filterInputOptions' => ['placeholder' => 'Pilih Group'], 'hAlign' => 'right', 'vAlign' => 'middle', 'noWrap' => true, 'group' => true, 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => $value[$key]['SIZE'], 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => 'rgba(' . $value[$key]['warna'] . ')']], 'contentOptions' => ['style' => ['width' => $value[$key]['SIZE'], 'text-align' => $value[$key]['align'], 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]]; } elseif ($value[$key]['FIELD'] == 'ganjilGenap') { $attDinamik[] = ['attribute' => $value[$key]['FIELD'], 'label' => $value[$key]['label'], 'filterType' => GridView::FILTER_SELECT2, 'filter' => $pekan, 'filterWidgetOptions' => ['pluginOptions' => ['allowClear' => true]], 'filterInputOptions' => ['placeholder' => 'Pilih'], 'hAlign' => 'right', 'vAlign' => 'middle', 'noWrap' => true, 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => $value[$key]['SIZE'], 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => 'rgba(' . $value[$key]['warna'] . ')']], 'contentOptions' => ['style' => ['width' => $value[$key]['SIZE'], 'text-align' => $value[$key]['align'], 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]]; } elseif ($value[$key]['FIELD'] == 'dayNm') { $attDinamik[] = ['attribute' => $value[$key]['FIELD'], 'label' => $value[$key]['label'], 'filterType' => GridView::FILTER_SELECT2, 'filter' => DraftPlan::getDay(), 'filterWidgetOptions' => ['pluginOptions' => ['allowClear' => true]], 'filterInputOptions' => ['placeholder' => 'Pilih'], 'hAlign' => 'right', 'vAlign' => 'middle', 'noWrap' => true, 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => $value[$key]['SIZE'], 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => 'rgba(' . $value[$key]['warna'] . ')']], 'contentOptions' => ['style' => ['width' => $value[$key]['SIZE'], 'text-align' => $value[$key]['align'], 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]]; } elseif ($value[$key]['FIELD'] == 'useridNm') { $attDinamik[] = ['attribute' => $value[$key]['FIELD'], 'label' => $value[$key]['label'], 'filterType' => GridView::FILTER_SELECT2, 'filter' => $user, 'filterWidgetOptions' => ['pluginOptions' => ['allowClear' => true]], 'filterInputOptions' => ['placeholder' => 'Pilih'], 'hAlign' => 'right', 'vAlign' => 'middle', 'noWrap' => true, 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => $value[$key]['SIZE'], 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => 'rgba(' . $value[$key]['warna'] . ')']], 'contentOptions' => ['style' => ['width' => $value[$key]['SIZE'], 'text-align' => $value[$key]['align'], 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]]; } else { # code... # code... $attDinamik[] = ['attribute' => $value[$key]['FIELD'], 'label' => $value[$key]['label'], 'filter' => true, 'hAlign' => 'right', 'vAlign' => 'middle', 'noWrap' => true, 'group' => $value[$key]['grp'], 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => $value[$key]['SIZE'], 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => 'rgba(' . $value[$key]['warna'] . ')']], 'contentOptions' => ['style' => ['text-align' => $value[$key]['align'], 'width' => $value[$key]['SIZE'], 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]]; } } /*GRIDVIEW ARRAY ACTION*/ /* $attDinamik[]=[ 'class'=>'kartik\grid\ActionColumn', 'dropdown' => true, 'dropdownOptions'=>['class'=>'pull-left dropup','style'=>['disable'=>true]], 'dropdownButton'=>[ 'class' => $actionClass,
/** * Finds the DraftPlan model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param string $id * @return DraftPlan the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = DraftPlan::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }