/** * Creates a new Saleorderinvoice model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { $searchModel = \backend\models\Saleorderinvoiceline::find()->where(['invid' => 0]); $model = new Saleorderinvoice(); if ($model->load(Yii::$app->request->post())) { $chkcount = Saleorderinvoice::find()->where(['invoiceno' => $_POST['Saleorderinvoice']['invoiceno']])->count(); if ($chkcount > 0) { // print_r($model->errors); // echo 'Not save'; $session = new Session(); $session->open(); $session->setFlash('modelerror', 'เลขที่ Invoice ซ้ำ'); return $this->render('create', ['model' => $model, 'saleline' => $searchModel, 'rowcount' => 0, 'saleincluded' => null, 'saleincludedcount' => 0]); } $saledate = $_POST['Saleorderinvoice']['invoicedate']; $model->invoicedate = date('d/M/Y H:i:s', strtotime($saledate)); // $model->createby =$session['username']; if ($model->save()) { $uploaded = UploadedFile::getInstance($model, 'upfile'); $result = 0; if (!empty($uploaded)) { $upfiles = time() . "." . $uploaded->getExtension(); $uploaded->saveAs('../../uploads/' . $upfiles); $handle = fopen('../../uploads/' . $upfiles, 'r'); $n = 0; while (($fileop = fgetcsv($handle, 1000, ",")) !== false) { if ($n < 1) { $n++; continue; } $model2 = new \backend\models\Saleorderinvoiceline(); $model2->invid = $model->recid; $model2->invline = $fileop[0]; $model2->partno = $fileop[1]; $model2->description = iconv("TIS-620", "UTF-8", $fileop[2]); $model2->quantity = $fileop[3]; $model2->unitprice = $fileop[4]; $model2->totalamount = $fileop[5]; $model2->unit = 1; if ($model2->save()) { $result++; } } fclose($handle); if ($result > 0) { $session = new \yii\web\Session(); $session->open(); $session->setFlash('msgsuccess', 'บันทึกรายการเรียบร้อย'); return $this->redirect(['update', 'id' => $model->recid]); } } } else { } } return $this->render('create', ['model' => $model, 'saleline' => $searchModel, 'rowcount' => 0, 'saleincluded' => null, 'saleincludedcount' => 0]); }