/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Machine::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(['like', 'TerminalID', $this->TerminalID])->andFilterWhere(['like', 'MESIN_NM', $this->MESIN_NM])->andFilterWhere(['like', 'MESIN_SN', $this->MESIN_SN])->andFilterWhere(['like', 'CAB_ID', $this->CAB_ID]);
return $dataProvider;
}
* === REKAP =========================
* Key-FIND : AttDinamik-Clalender
* @author ptrnov [piter@lukison.com]
* @since 1.2
* ===================================
*/
$attDinamik = [];
$hdrLabel1 = [];
//$hdrLabel2=[];
$getHeaderLabelWrap = [];
/*
* Terminal ID | Mashine
* Colomn 1
*/
$attDinamik[] = ['attribute' => 'TerminalID', 'label' => 'Source Machine', 'hAlign' => 'right', 'vAlign' => 'middle', 'filter' => $aryMachine, 'filterOptions' => ['style' => 'background-color:rgba(240, 195, 59, 0.4); align:center;', 'vAlign' => 'middle'], 'value' => function ($model) {
$nmMachine = Machine::find()->where(['TerminalID' => $model['TerminalID']])->one();
return $nmMachine != '' ? $nmMachine['MESIN_NM'] : 'Unknown';
}, 'noWrap' => true, 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => '20px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => 'rgba(240, 195, 59, 0.4)']], 'contentOptions' => ['style' => ['text-align' => 'left', 'width' => '20px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']], 'pageSummaryOptions' => ['style' => ['text-align' => 'right', 'width' => '20px', 'font-family' => 'tahoma', 'font-size' => '8pt', 'text-decoration' => 'underline', 'font-weight' => 'bold', 'border-left-color' => 'transparant', 'border-left' => '0px']]];
$hdrLabel1[] = ['content' => 'Employee Data', 'options' => ['noWrap' => true, 'colspan' => 2, 'class' => 'text-center info', 'style' => ['text-align' => 'center', 'width' => '20px', 'font-family' => 'tahoma', 'font-size' => '8pt', 'background-color' => 'rgba(0, 95, 218, 0.3)']]];
/*
* Employe name
* Colomn 2
*/
$attDinamik[] = ['attribute' => 'EMP_NM', 'label' => 'Employee', 'hAlign' => 'right', 'vAlign' => 'middle', 'filterOptions' => ['style' => 'background-color:rgba(240, 195, 59, 0.4); align:center;', 'vAlign' => 'middle'], 'noWrap' => true, 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => '10px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt', 'background-color' => 'rgba(240, 195, 59, 0.4)']], 'contentOptions' => ['style' => ['text-align' => 'left', 'width' => '10px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '8pt']], 'pageSummaryOptions' => ['style' => ['text-align' => 'right', 'width' => '10px', 'font-family' => 'tahoma', 'font-size' => '8pt', 'text-decoration' => 'underline', 'font-weight' => 'bold', 'border-left-color' => 'transparant', 'border-left' => '0px']]];
foreach ($dataProviderField as $key => $value) {
$i = 2;
$kd = explode('.', $key);
if ($key != 'EMP_NM' and $key != 'TerminalID' and $kd[0] != 'OTIN' and $kd[0] != 'OTOUT') {
if ($kd[0] == 'IN') {
$lbl = 'IN';
} elseif ($kd[0] == 'OUT') {
use kartik\grid\GridView;
use yii\helpers\Url;
use yii\widgets\Pjax;
use yii\bootstrap\Modal;
use yii\bootstrap\ActiveForm;
use kartik\tabs\TabsX;
use yii\helpers\Json;
use yii\web\Response;
use yii\helpers\ArrayHelper;
use yii\web\Request;
use kartik\daterange\DateRangePicker;
use yii\db\ActiveRecord;
use yii\data\ArrayDataProvider;
use kartik\date\DatePicker;
use lukisongroup\hrd\models\Machine;
$aryMachine = ArrayHelper::map(Machine::find()->all(), 'TerminalID', 'MESIN_NM');
//print_r($dataProvider->getModels());
//print_r($searchModelRo);
$gvTest1 = '';
/* $gvTest1= GridView::widget([
'id'=>'gv-test1',
'dataProvider' => $dataProvider1,
'pjax'=>true,
'pjaxSettings'=>[
'options'=>[
'enablePushState'=>false,
'id'=>'gv-test1',
],
],
'summary'=>false,
'hover'=>true, //cursor select
public function getMachines()
{
return $this->hasOne(Machine::className(), ['TerminalID' => 'TerminalID']);
}
