/**
* Creates a new Car4 model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$model = new Car4();
if ($model->load(Yii::$app->request->post())) {
$uploaded = UploadedFile::getInstance($model, 'myfile');
// $uploaded = UploadedFile::getInstances($model, 'myfile');
if (!empty($uploaded)) {
$upfiles = time() . "." . $uploaded->getExtension();
if ($uploaded->saveAs('../../uploads/' . $upfiles)) {
// $handle = fopen('../../uploads/' . $upfiles, 'r');
}
// echo $handle;
// return;
$filename = '../../uploads/' . $upfiles;
$excelfile = \PHPExcel_IOFactory::identify($filename);
$objReader = \PHPExcel_IOFactory::createReader($excelfile);
$objfile = $objReader->load($filename);
$sheet = $objfile->getSheet(0);
$rowcount = $sheet->getHighestRow();
$columncount = $sheet->getHighestColumn();
$result = 0;
for ($row = 0; $row <= $rowcount; $row++) {
$rowdata = $sheet->rangeToArray('A' . $row . ':' . $columncount . $row, NULL, TRUE, FALSE);
if ($row == 1) {
continue;
}
$name = $rowdata[0][2];
$gen = explode("/", $name);
if ($name == '') {
continue;
}
// echo $rowdata[0][2].'<BR />';
// foreach ($gen as $x){echo $x.'<BR />';}
// echo $gen[0] . ' ' . $gen[1] . ' ' . $gen[2];
//if($row>1){return;}
$model2 = new \backend\Models\Car4();
$model2->brand = $gen[0];
$model2->gen = $gen[1];
$model2->o1 = isset($gen[2]) ? $gen[2] : '';
$model2->o2 = isset($gen[3]) ? $gen[3] : '';
$model2->o3 = isset($gen[4]) ? $gen[4] : '';
$model2->o4 = isset($gen[5]) ? $gen[5] : '';
$model2->o5 = isset($gen[6]) ? $gen[6] : '';
if ($model2->save()) {
$result++;
}
}
}
if ($result > 0) {
return $this->redirect(['index']);
}
} else {
return $this->render('create', ['model' => $model]);
}
}
/**
* Creates a new Car4 model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$model = new Car4();
if ($model->load(Yii::$app->request->post())) {
//$uploaded = UploadedFile::getInstance($model, 'myfile');
$uploaded = UploadedFile::getInstances($model, 'myfile');
if (!empty($uploaded)) {
$x = 0;
foreach ($uploaded as $xfiles) {
$x++;
$file = "F" . $x . "." . $xfiles->getExtension();
$xfile[] = $file;
$xfiles->saveAs('../../uploads/' . $file);
}
foreach ($xfile as $m) {
$filename = '../../uploads/' . $m;
$excelfile = \PHPExcel_IOFactory::identify($filename);
$objReader = \PHPExcel_IOFactory::createReader($excelfile);
$objfile = $objReader->load($filename);
$sheet = $objfile->getSheet(0);
$rowcount = $sheet->getHighestRow();
$columncount = $sheet->getHighestColumn();
$result = 0;
for ($row = 0; $row <= $rowcount; $row++) {
$rowdata = $sheet->rangeToArray('A' . $row . ':' . $columncount . $row, NULL, TRUE, FALSE);
if ($row <= 2) {
continue;
}
$name = $rowdata[0][2];
//$gen = explode("/", $name);
$gen = explode(" ", $name);
if ($name == '') {
continue;
}
// echo $rowdata[0][2].'<BR />';
// foreach ($gen as $x){echo $x.'<BR />';}
// echo $gen[0] . ' ' . $gen[1] . ' ' . $gen[2];
//if($row>1){return;}
$model2 = new \backend\Models\Car4();
$model2->brand = $rowdata[0][1];
$model2->gen = $rowdata[0][2];
$model2->o1 = isset($gen[1]) ? $gen[1] : '';
$model2->o2 = isset($gen[2]) ? $gen[2] : '';
$model2->o3 = isset($gen[3]) ? $gen[3] : '';
$model2->o4 = isset($gen[4]) ? $gen[4] : '';
$model2->o5 = isset($gen[5]) ? $gen[5] : '';
$model2->o6 = isset($gen[6]) ? $gen[6] : '';
$model2->o7 = isset($gen[7]) ? $gen[7] : '';
$model2->o8 = isset($gen[8]) ? $gen[8] : '';
$model2->o9 = isset($gen[9]) ? $gen[9] : '';
$model2->o10 = isset($gen[10]) ? $gen[10] : '';
$model2->o11 = isset($gen[11]) ? $gen[11] : '';
$model2->o12 = isset($gen[12]) ? $gen[12] : '';
$model2->o13 = isset($gen[13]) ? $gen[13] : '';
$model2->o14 = isset($gen[14]) ? $gen[14] : '';
$model2->o15 = isset($gen[15]) ? $gen[15] : '';
$model2->o16 = isset($gen[16]) ? $gen[16] : '';
$model2->o17 = isset($gen[17]) ? $gen[17] : '';
$model2->o18 = isset($gen[18]) ? $gen[18] : '';
$model2->o19 = isset($gen[19]) ? $gen[19] : '';
$model2->o20 = isset($gen[20]) ? $gen[20] : '';
$model2->year = (string) $rowdata[0][23];
$model2->id = (string) $rowdata[0][24];
$model2->close = (string) $rowdata[0][25];
$model2->open = (string) $rowdata[0][26];
$model2->tabain = (string) $rowdata[0][27];
$model2->mile = (string) $rowdata[0][28];
$model2->serialbox = (string) $rowdata[0][29];
$model2->serialmachine = (string) $rowdata[0][30];
$model2->arena = (string) $rowdata[0][31];
$model2->datearena = (string) $rowdata[0][32];
$model2->detail = (string) $rowdata[0][33];
$model2->pricevat = (string) $rowdata[0][34];
if ($model2->save()) {
$result++;
}
}
unlink($filename);
// echo '
// <div class="progress">
// <div class="progress-bar" role="progressbar" aria-valuenow="60" aria-valuemin="0" aria-valuemax="100" style="width: 60%;">
//60%
// </div>
// </div>
// '
// ;
}
// $upfiles = time() . "." . $uploaded->getExtension();
// if ($uploaded->saveAs('../../uploads/' . $upfiles)) {
// $handle = fopen('../../uploads/' . $upfiles, 'r');
// }
// echo $handle;
// return;
}
if ($result > 0) {
$session = new Session();
$session->open();
$session->setFlash('msg', 'บันทึกข้อมูลเรียบร้อย');
return $this->redirect(['index']);
}
} else {
return $this->render('create', ['model' => $model]);
}
}