/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Sot2::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(['ID' => $this->ID, 'TGL' => $this->TGL, 'UNIT_QTY' => $this->UNIT_QTY, 'UNIT_BERAT' => $this->UNIT_BERAT, 'SO_TYPE' => $this->SO_TYPE, 'SO_QTY' => $this->SO_QTY, 'HARGA_PABRIK' => $this->HARGA_PABRIK, 'HARGA_DIS' => $this->HARGA_DIS, 'HARGA_SALES' => $this->HARGA_SALES, 'HARGA_LG' => $this->HARGA_LG]); $query->andFilterWhere(['like', 'CUST_KD_ALIAS', $this->CUST_KD_ALIAS])->andFilterWhere(['like', 'KD_DIS', $this->KD_DIS])->andFilterWhere(['like', 'USER_ID', $this->USER_ID])->andFilterWhere(['like', 'KD_BARANG_ALIAS', $this->KD_BARANG_ALIAS])->andFilterWhere(['like', 'NM_BARANG', $this->NM_BARANG])->andFilterWhere(['like', 'UNIT_BARANG', $this->UNIT_BARANG])->andFilterWhere(['like', 'NOTED', $this->NOTED]); return $dataProvider; }
public function actionSendFix() { $username = Yii::$app->user->identity->username; $data_view = Yii::$app->db_esm->createCommand("\n\t\t\t#CALL ESM_SALES_IMPORT_TEMP_view('STOCK','" . $username . "')\n\t\t\tSELECT ID,TGL,ITEM_ID_ALIAS,ITEM_NM,QTY_PCS,HARGA_PCS,QTY_UNIT,DIS_REF,DIS_REF_NM,SO_TYPE,POS,USER_ID\n\t\t\tFROM so_t2_tmp_file\t\t\t\n\t\t\tWHERE USER_ID='" . $username . "' AND SO_TYPE=1\n\t\t")->queryAll(); \Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; if (Yii::$app->request->isAjax && $data_view) { $viewDataProvider = new ArrayDataProvider(['key' => 'ID', 'allModels' => $data_view, 'pagination' => ['pageSize' => 1000]]); $dataImport = $viewDataProvider->allModels; // print_r($viewDataProvider->allModels); // die(); //Validation column $sttValidationColumn = 0; $sttValidationDataReady = 0; foreach ($dataImport as $key => $value) { if ($value['TGL'] == 'NotSet' or $value['ITEM_ID_ALIAS'] == 'NotSet' or $value['ITEM_NM'] == 'NotSet' or $value['QTY_PCS'] == 'NotSet' or $value['DIS_REF'] == 'NotSet' or $value['HARGA_PCS'] == '') { $sttValidationColumn = 1; } $countDataSot2 = Sot2::find()->where(['SO_TYPE' => 1, 'TGL' => $value['TGL'], 'KD_BARANG_ALIAS' => $value['ITEM_ID_ALIAS']])->count(); if ($countDataSot2 != 0) { $sttValidationDataReady = $countDataSot2; } } //print_r($sttValidationColumn); //die(); if ($sttValidationColumn != 1) { if ($sttValidationDataReady == 0) { foreach ($dataImport as $key => $value) { //$cmd->reset(); $tgl = date_format(date_create($value['TGL']), "Y-m-d"); $cust_kd = $value['CUST_KD_ALIAS']; $item_kd = $value['ITEM_ID_ALIAS']; $item_qty = $value['QTY_PCS']; $item_price = $value['HARGA_PCS']; $dis_id = $value['DIS_REF']; $import_live = Yii::$app->db_esm->createCommand("CALL ESM_SALES_IMPORT_LIVE_create(\n\t\t\t\t\t\t\t\t\t\t\t\t'STOCKG_GUDANG','" . $tgl . "','" . $cust_kd . "','" . $item_kd . "','" . $item_qty . "','" . $item_price . "','WEB_IMPORT','" . $dis_id . "','" . $username . "'\n\t\t\t\t\t\t\t\t\t\t\t)"); $import_live->execute(); } $rslt = 'sukses'; } else { $rslt = 'datasudahada'; } } else { $rslt = 'validasi'; } //return true; } else { //return $this->redirect(['index']); //return false; $rslt = 'nodata'; } //return $this->redirect(['index']); return $rslt; }
/** * Finds the Sot2 model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param string $id * @return Sot2 the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Sot2::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
return '<li>' . Html::a('<span class="fa fa-search-plus fa-dm"></span>' . Yii::t('app', 'Image Start'), ['/master/schedule-detail/img1', 'id' => $model->ID], ['id' => 'img1-id', 'data-toggle' => "modal", 'data-target' => "#img1-visit"]) . '</li>' . PHP_EOL; }, 'view2' => function ($url, $model, $key) { return '<li>' . Html::a('<span class="fa fa-search-plus fa-dm"></span>' . Yii::t('app', 'Image End'), ['/master/schedule-detail/img2', 'id' => $model->ID], ['id' => 'img2-id', 'data-toggle' => "modal", 'data-target' => "#img2-visit"]) . '</li>' . PHP_EOL; }], 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => '10px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '9pt', 'background-color' => 'rgba(74, 206, 231, 1)']], 'contentOptions' => ['style' => ['text-align' => 'center', 'width' => '10px', 'height' => '10px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '9pt']]]; /*GRIDVIEW EXPAND*/ $attDinamik[] = ['class' => 'kartik\\grid\\ExpandRowColumn', 'width' => '50px', 'value' => function ($model, $key, $index, $column) { return GridView::ROW_COLLAPSED; }, 'detail' => function ($model, $key, $index, $column) { $dataInventory = Yii::$app->db_esm->createCommand("CALL ERP_CUSTOMER_VISIT_inventory('" . $model->TGL . "','" . $model->CUST_ID . "','" . $model->USER_ID . "')")->queryAll(); $inventoryProvider = new ArrayDataProvider(['allModels' => $dataInventory, 'pagination' => ['pageSize' => 50]]); /*INFO*/ $modelInfo = $model; /*INVENTORY*/ //Sot2Search //$modelInvntory =Sot2::find()->where('TGL="'.$model->TGL.'" AND CUST_KD="'.$model->CUST_ID.'" AND USER_ID="'.$model->USER_ID.'"')->All(); $modelInvntory = Sot2::find()->where('TGL="' . $model->TGL . '" AND USER_ID="' . $model->USER_ID . '"')->All(); //$modelInvntory =Sot2::find()->where('USER_ID="'.$model->USER_ID.'"')->all(); //$modelImage =CustomerVisitImage::find()->where('ID="'.$model->ID.'"')->One(); $aryDataProvider = new ArrayDataProvider(['key' => 'ID', 'allModels' => $modelInvntory]); /*IMAGE VISIT*/ $searchModel = new CustomerVisitImageSearch(['ID_DETAIL' => '' . $model->ID . '']); $dataProviderImage = $searchModel->search(Yii::$app->request->queryParams); return Yii::$app->controller->renderPartial('indexExpand', ['cust_id' => $model->ID, 'modelInfo' => $modelInfo, 'dataProviderInventory' => $aryDataProvider, 'searchModelImage' => $searchModel, 'inventoryProvider' => $inventoryProvider, 'dataProviderImage' => $dataProviderImage]); }, 'headerOptions' => ['class' => 'kartik-sheet-style'], 'expandOneOnly' => false, 'headerOptions' => ['style' => ['text-align' => 'center', 'width' => '10px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '9pt', 'background-color' => 'rgba(74, 206, 231, 1)']], 'contentOptions' => ['style' => ['text-align' => 'center', 'width' => '10px', 'height' => '10px', 'font-family' => 'tahoma, arial, sans-serif', 'font-size' => '9pt']]]; /*GRIDVIEW ARRAY ROWS*/ foreach ($gvHeadColomn as $key => $value[]) { $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']]]; } /*STATUS RADIUS*/ $attDinamik[] = ['attribute' => 'sttKoordinat', 'label' => 'STATUS', 'filter' => $SttFilter, 'filterOptions' => ['style' => 'background-color:rgba(249, 215, 100, 1); align:center'], 'hAlign' => 'right', 'vAlign' => 'middle', 'value' => function ($model) { return statusRadius($model);