/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = ClnStaff::find();
$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;
}
$query->andFilterWhere(['STAFF_ID' => $this->STAFF_ID, 'TITLE_GEN_NO' => $this->TITLE_GEN_NO]);
$query->andFilterWhere(['like', 'FIRST_NAME', $this->FIRST_NAME])->andFilterWhere(['like', 'LAST_NAME', $this->LAST_NAME])->andFilterWhere(['like', 'GENDER', $this->GENDER])->andFilterWhere(['like', 'BIRTH_DATE', $this->BIRTH_DATE])->andFilterWhere(['like', 'STAFF_TYPE', $this->STAFF_TYPE])->andFilterWhere(['like', 'CREATE_BY', $this->CREATE_BY])->andFilterWhere(['like', 'CREATE_DATE', $this->CREATE_DATE])->andFilterWhere(['like', 'LAST_UPD_BY', $this->LAST_UPD_BY])->andFilterWhere(['like', 'LAST_UPD_DATE', $this->LAST_UPD_DATE]);
$query->with = array('clnTitle');
//jointable
return $dataProvider;
}
/**
* Finds the ClnStaff model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return ClnStaff the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = ClnStaff::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public function getClnStaff()
{
return $this->hasOne(ClnStaff::className(), ['STAFF_ID' => 'STAFF_ID']);
}
use kartik\grid\GridView;
/* @var $this yii\web\View */
/* @var $searchModel app\models\ClnTranInjRespSearch */
/* @var $dataProvider yii\data\ActiveDataProvider */
$this->title = Yii::t('app', 'Cln Tran Inj Resps');
$this->params['breadcrumbs'][] = $this->title;
?>
<div class="cln-tran-inj-resp-index">
<?php
echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => ['TRAN_INJ_RESP_ID', 'STAFF_ID', ['attribute' => 'clnStaff.STAFF_TYPE', 'vAlign' => 'middle', 'value' => function ($model, $key, $index, $widget) {
$staff_type_desc = ['D' => 'แพทย์', 'P' => 'นักกายภาพบำบัด', 'N' => 'พยาบาล'];
return $staff_type_desc[$model->STAFF_TYPE];
}, 'filterType' => GridView::FILTER_SELECT2, 'filter' => ['D' => 'แพทย์', 'P' => 'นักกายภาพบำบัด', 'N' => 'พยาบาล'], 'filterWidgetOptions' => ['pluginOptions' => ['allowClear' => true]], 'filterInputOptions' => ['placeholder' => '']], ['attribute' => 'STAFF_ID', 'value' => 'clnStaff.FIRST_NAME', 'filterType' => GridView::FILTER_SELECT2, 'filter' => ArrayHelper::map(\app\models\ClnStaff::find()->all(), 'STAFF_ID', 'FIRST_NAME'), 'filterWidgetOptions' => ['pluginOptions' => ['allowClear' => true, 'width' => '100%']], 'filterInputOptions' => ['placeholder' => '']], 'CREATE_BY', 'CREATE_DATE', 'TRAN_INJ_GEN_NO', ['class' => 'kartik\\grid\\ActionColumn', 'template' => '{update} {delete}', 'headerOptions' => ['width' => '20%', 'class' => 'activity-view-link'], 'contentOptions' => ['class' => 'padding-left-5px'], 'buttons' => ['update' => function ($url, $model, $key) {
return Html::a('<span class="glyphicon glyphicon-pencil"></span>', '#', ['class' => 'modal-cln-tran-inj-resp-button', 'title' => Yii::t('yii', 'Update'), 'data-value' => 'index.php?r=clntraninjresp/update&id=' . $key]);
}, 'delete' => function ($url, $model, $key) {
return Html::a('<span class="glyphicon glyphicon-trash"></span>', '#', ['class' => 'delete-cln-tran-inj-resp-button', 'title' => Yii::t('yii', 'Delete'), 'data-value' => 'index.php?r=clntraninjresp/delete&id=' . $key]);
}]], ['class' => 'kartik\\grid\\CheckboxColumn', 'headerOptions' => ['class' => 'kartik-sheet-style']]], 'toolbar' => [['content' => Html::a('<i class="glyphicon glyphicon-plus"></i>', '#', ['class' => 'btn btn-success modal-cln-tran-inj-resp-button', 'title' => Yii::t('yii', 'View'), 'data-value' => 'index.php?r=clntraninjresp/create&tran_inj_gen_no=8']) . ' ' . Html::a('<i class="glyphicon glyphicon-repeat"></i>', ['grid-demo'], ['data-pjax' => 0, 'class' => 'btn btn-default', 'title' => 'Reset Grid'])], '{export}', '{toggleData}'], 'export' => ['fontAwesome' => true], 'bordered' => true, 'striped' => true, 'condensed' => true, 'responsive' => true, 'hover' => true, 'showPageSummary' => true, 'panel' => ['heading' => 'รายการประเภทโครงการ', 'type' => GridView::TYPE_PRIMARY], 'persistResize' => false, 'export' => false]);
?>
</div>
<?php
Modal::begin(['id' => 'modal-cln-tran-inj-resp', 'size' => 'modal-lg']);
echo "<div id = 'modal-cln-tran-inj-resp-content'></div>";
Modal::end();
$script = <<<JS
PNotify.prototype.options.styling = "bootstrap3";
