/**
* IMPORT DATA EXCEL
* TYPE : 3= stock-salespo /SELL OUT Distributor.
* @return mixed
* @author piter [ptr.nov@gmail.com]
*/
public function actionIndex()
{
$username = Yii::$app->user->identity->username;
$user_id = ['USER_ID' => $username];
$paramFile = Yii::$app->getRequest()->getQueryParam('id');
if ($paramFile) {
self::setDataImport($paramFile);
} else {
//DELETE STOCK GUDANG | SO_TYPE=1
$cmd_clear = Yii::$app->db_esm->createCommand("\n\t\t\t\t\tDELETE FROM so_t2_tmp_file WHERE USER_ID='" . $username . "' AND SO_TYPE=3;\n\t\t\t");
$cmd_clear->execute();
}
//echo $paramCari;
$model = new UserFileSalesPo();
/*IMPORT VALIDATION*/
$searchModel = new TempDataSearch($user_id);
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
/*VIEW IMPORT*/
$searchModelViewImport = new ImportViewSearch();
$dataProviderViewImport = $searchModelViewImport->search(Yii::$app->request->queryParams);
//echo $this->actionExport_format();
//print_r($dataProvider->getModels());
return $this->render('index', ['getArryFile' => $dataProvider, 'fileName' => $paramFile, 'gvValidateArrayDataProvider' => $dataProvider, 'searchModelValidate' => $searchModel, 'modelFile' => $model, 'searchModelViewImport' => $searchModelViewImport, 'dataProviderViewImport' => $dataProviderViewImport]);
}
/**
* Lists all ImportView models.
* @return mixed
*/
public function actionIndex()
{
$searchModel = new ImportViewSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]);
}
/**
* IMPORT DATA EXCEL
* @return mixed
* @author piter [ptr.nov@gmail.com]
*/
public function actionIndex()
{
$paramFile = Yii::$app->getRequest()->getQueryParam('id');
//echo $paramCari;
$model = new UserFile();
$username = Yii::$app->user->identity->username;
$user_id = ['USER_ID' => $username];
/*IMPORT VALIDATION*/
$searchModel = new TempDataSearch($user_id);
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
/*VIEW IMPORT*/
$searchModelViewImport = new ImportViewSearch();
$dataProviderViewImport = $searchModelViewImport->search(Yii::$app->request->queryParams);
//echo $this->actionExport_format();
return $this->render('index', ['getArryFile' => $this->getArryFile($paramFile), 'fileName' => $paramFile, 'gvColumnAryFile' => $this->gvColumnAryFile(), 'gvValidateColumn' => $this->gvValidateColumn(), 'gvValidateArrayDataProvider' => $dataProvider, 'searchModelValidate' => $searchModel, 'modelFile' => $model, 'gvRows' => $this->gvRows(), 'searchModelViewImport' => $searchModelViewImport, 'dataProviderViewImport' => $dataProviderViewImport]);
}
public function actionExport_datagudang()
{
$searchModelViewImport = new ImportViewSearch();
$dataProvidergudang = $searchModelViewImport->searchViewHistoryGudang(Yii::$app->request->queryParams);
$dpGudang = $dataProvidergudang->getModels();
$aryData = [];
foreach ($dpGudang as $key => $value) {
$aryData[] = ['TGL' => $value['TGL'], 'NM_BARANG' => $value['NM_BARANG'], 'SO_QTY' => $value['SO_QTY'], 'UNIT_BARANG' => $value['UNIT_BARANG'], 'kartonqty' => $value['kartonqty'], 'beratunit' => $value['beratunit'], 'HARGA_DIS' => $value['HARGA_DIS'], 'subtotaldist' => $value['subtotaldist'], 'disNm' => $value['disNm'], 'USER_ID' => $value['USER_ID']];
}
$dataProviderAllDataImport = new ArrayDataProvider(['allModels' => $aryData, 'pagination' => ['pageSize' => 10]]);
$modelDataExport = $dataProviderAllDataImport->getModels();
//print_r($modelDataExport);
$excel_data = Postman4ExcelBehavior::excelDataFormat($modelDataExport);
$excel_title = $excel_data['excel_title'];
$excel_ceils = $excel_data['excel_ceils'];
$excel_content = [['sheet_name' => 'STOCK-GUDANG', 'sheet_title' => [['DATE', 'BARANG', 'QTY_PCS', 'UNIT_BARANG', 'QTY_KARTON', 'BERAT_GRAM', 'HARGA_DIS', 'SUB_TOTAL', 'DISTRIBUTOR', 'USER_ID']], 'ceils' => $excel_ceils, 'freezePane' => 'A2', 'headerColor' => Postman4ExcelBehavior::getCssClass("header"), 'headerStyle' => [['TGL' => ['align' => 'center'], 'NM_BARANG' => ['align' => 'center'], 'SO_QTY' => ['align' => 'center'], 'UNIT_BARANG' => ['align' => 'center'], 'kartonqty' => ['align' => 'center'], 'beratunit' => ['align' => 'center'], 'HARGA_DIS' => ['align' => 'center'], 'subtotaldist' => ['align' => 'center'], 'disNm' => ['align' => 'center'], 'USER_ID' => ['align' => 'center']]], 'contentStyle' => [['DATE' => ['align' => 'center'], 'BARANG' => ['align' => 'left'], 'QTY_PCS' => ['align' => 'right'], 'UNIT_BARANG' => ['align' => 'center'], 'QTY_KARTON' => ['align' => 'right'], 'BERAT_GRAM' => ['align' => 'right'], 'HARGA_DIS' => ['align' => 'right'], 'SUB_TOTAL' => ['align' => 'right'], 'DISTRIBUTOR' => ['align' => 'left'], 'USER_ID' => ['align' => 'center']]], 'oddCssClass' => Postman4ExcelBehavior::getCssClass("odd"), 'evenCssClass' => Postman4ExcelBehavior::getCssClass("even")]];
$excel_file = "ImportDataGudang";
$this->export4excel($excel_content, $excel_file, 0);
}
