use yii\helpers\ArrayHelper;
use yii\bootstrap\Modal;
use yii\helpers\Url;
use kartik\select2\Select2;
$session = new Session();
$session->open();
/* @var $this yii\web\View */
/* @var $model backend\models\Saleorderinvoice */
/* @var $form yii\widgets\ActiveForm */
?>
<div class="saleorderinvoice-form">
<?php
$customer = new \backend\models\Customer();
$currency = new \backend\models\Currency();
$invorline = new \backend\models\Saleorderinvoiceline();
?>
<?php
$form = ActiveForm::begin(['id' => 'myform2', 'options' => ['class' => 'form-horizontal', 'enctype' => 'multipart/form-data']]);
?>
<div class="salenoid" <?php
echo "id={$model->recid}";
?>
></div>
<?php
if (!empty($session->getFlash('msgsuccess'))) {
?>
<div class="alert alert-success alert-dismissable" role="alert">
<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button>
<?php
use yii\helpers\Html;
use yii\widgets\DetailView;
/* @var $this yii\web\View */
/* @var $model backend\models\Saleorderinvoice */
$this->title = $model->invoiceno;
$this->params['breadcrumbs'][] = ['label' => 'Saleorderinvoices', 'url' => ['index']];
$this->params['breadcrumbs'][] = $this->title;
?>
<?php
$invline = new \backend\models\Saleorderinvoiceline();
?>
<div class="saleorderinvoice-view">
<h1><?php
echo Html::encode($this->title);
?>
</h1>
<p>
<?php
echo Html::a('Update', ['update', 'id' => $model->recid], ['class' => 'btn btn-primary']);
?>
<?php
echo Html::a('Delete', ['delete', 'id' => $model->recid], ['class' => 'btn btn-danger', 'data' => ['confirm' => 'Are you sure you want to delete this item?', 'method' => 'post']]);
?>
</p>
<?php
echo DetailView::widget(['model' => $model, 'attributes' => ['invoiceno', ['attribute' => 'invoicedate', 'value' => Yii::$app->formatter->asDate($model->invoicedate, 'dd-MM-yyyy')], ['attribute' => 'invcurrency', 'value' => $model->invcurrency ? $model->currencyname->currencycode : ''], 'invcurrencyrate', ['attribute' => 'customerid', 'value' => $model->customerid ? $model->customername->Cus_Name : ''], ['attribute' => 'totalqty', 'value' => number_format($invline->Ordersum($model->recid)) . " Pcs"], ['attribute' => 'totalamt', 'value' => number_format($invline->Usdsum($model->recid)) . " " . $model->currencyname->currencycode], ['attribute' => 'totalthb', 'value' => $model->currencyname->currencycode != 'THB' ? number_format($invline->Usdsum($model->recid) * $model->invcurrencyrate) . " THB" : number_format($invline->Thbsum($model->recid)) . " " . $model->currencyname->currencycode], 'createdate']]);
public function actionUpdate($id)
{
$totalCount = \backend\models\Saleorderinvoiceline::find()->where(['invid' => $id])->count();
$saleincluded = \backend\models\Invoicerefsale::find()->where(['invid' => $id])->all();
$saleincludedcount = \backend\models\Invoicerefsale::find()->where(['invid' => $id])->count();
$pages = new Pagination(['totalCount' => $totalCount, 'pageSize' => 20]);
$searchModel = \backend\models\Saleorderinvoiceline::find()->where(['invid' => $id])->orderBy('recid')->offset($pages->offset)->limit($pages->limit)->all();
$model = $this->findModel($id);
if ($model->load(Yii::$app->request->post())) {
$saledate = $_POST['Saleorderinvoice']['invoicedate'];
$model->invoicedate = date('d/M/Y H:i:s', strtotime($saledate));
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 = $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 {
}
} else {
return $this->render('update', ['model' => $model, 'saleline' => $searchModel, 'pages' => $pages, 'rowcount' => $totalCount, 'saleincluded' => $saleincluded, 'saleincludedcount' => $saleincludedcount]);
}
return $this->render('update', ['model' => $model, 'saleline' => $searchModel, 'pages' => $pages, 'rowcount' => $totalCount, 'saleincluded' => $saleincluded, 'saleincludedcount' => $saleincludedcount]);
}
