/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = SopSalesHeader::find(); // add conditions that should always apply here $dataProvider = new ActiveDataProvider(['query' => $query]); $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, 'TGL' => $this->TGL, 'STT_DEFAULT' => $this->STT_DEFAULT, 'SOP_TYPE' => $this->sopNm, 'BOBOT_PERCENT' => $this->BOBOT_PERCENT, 'TARGET_MONTH' => $this->TARGET_MONTH, 'TARGET_DAY' => $this->TARGET_DAY, 'TTL_DAYS' => $this->TTL_DAYS, 'CREATE_AT' => $this->CREATE_AT]); $query->andFilterWhere(['like', 'KATEGORI', $this->KATEGORI])->andFilterWhere(['like', 'TARGET_UNIT', $this->TARGET_UNIT])->andFilterWhere(['like', 'CREATE_BY', $this->CREATE_BY]); return $dataProvider; }
/** * Finds the SopSalesHeader model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return SopSalesHeader the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = SopSalesHeader::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
} elseif ($value[$key]['FIELD'] == 'SCORE_RSLT') { $attDinamik[] = ['class' => 'kartik\\grid\\EditableColumn', 'attribute' => $value[$key]['FIELD'], 'label' => $value[$key]['label'], 'filterType' => $value[$key]['filterType'], 'filter' => $value[$key]['filter'], 'filterOptions' => ['style' => 'background-color:rgba(' . $value[$key]['filterwarna'] . '); align:center'], 'hAlign' => 'right', 'vAlign' => 'middle', 'noWrap' => true, 'group' => $value[$key]['GRP'], 'format' => $value[$key]['FORMAT'], 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => $value[$key]['FIELD'], 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => 'rgba(' . $value[$key]['warna'] . ')']], 'contentOptions' => ['style' => ['text-align' => $value[$key]['align'], 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]]; } else { $attDinamik[] = ['attribute' => $value[$key]['FIELD'], 'label' => $value[$key]['label'], 'filterType' => $value[$key]['filterType'], 'filter' => $value[$key]['filter'], 'filterOptions' => ['style' => 'background-color:rgba(' . $value[$key]['filterwarna'] . '); align:center'], 'hAlign' => 'right', 'vAlign' => 'middle', 'noWrap' => true, 'group' => $value[$key]['GRP'], 'format' => $value[$key]['FORMAT'], 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => $value[$key]['FIELD'], 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => 'rgba(' . $value[$key]['warna'] . ')']], 'contentOptions' => ['style' => ['text-align' => $value[$key]['align'], 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']]]; } } /*GRID VIEW BASE*/ $detail_sop = GridView::widget(['id' => 'sop-detail-idxy', 'dataProvider' => $dataProvider_detail, 'columns' => $attDinamik, 'pjax' => true, 'pjaxSettings' => ['options' => ['enablePushState' => false, 'id' => 'sop-detail-idxy']], 'panel' => ['heading' => '<h3 class="panel-title" style="font-family: verdana, arial, sans-serif ;font-size: 9pt;">Detail</h3>', 'type' => 'info'], 'toolbar' => [['content' => detailtombol($detail_id)]], 'summary' => false, 'hover' => true, 'responsive' => true, 'responsiveWrap' => true]); ?> <!-- HEADER !--> <div class="row" style="font-family: verdana, arial, sans-serif ;font-size: 8pt;padding-bottom:20px;"> <div class="col-sm-6"> <?php echo Yii::$app->controller->renderPartial('sop_detailexpand', ['model_header' => $model_detail = SopSalesHeader::find()->where(['ID' => $detail_id])->one()]); ?> </div> </div> <div class="row" style="font-family: verdana, arial, sans-serif ;font-size: 8pt;padding-bottom:20px;"> <!-- HEADER !--> <div class="col-md-12"> <?php echo $detail_sop; ?> </div> </div>