public function actionUpload()
{
$model = new \backend\models\Saleorderline();
if (\Yii::$app->request->post()) {
$uploaded = UploadedFile::getInstance($model, 'upfile');
if (!empty($uploaded)) {
$upfiles = time() . "." . $uploaded->getExtension();
// $uploaded->saveAs('../../uploads/'.$upfiles);
$handle = fopen('../../uploads/' . $upfiles, 'r');
while (($fileop = fgetcsv($handle, 1000, ",")) !== false) {
$model = new \backend\models\Saleorderline();
$model->saleid = 'SO0001';
$model->saleline = $fileop[0];
$model->partno = $fileop[1];
// echo $name."<BR />";
// $age = $fileop[1];
//$location = $fileop[2];
//print_r($fileop);exit();
// $sql = "INSERT INTO details(name, age, location) VALUES ('$name', '$age', '$location')";
// $query = Yii::$app->db->createCommand($sql)->execute();
$model->save();
}
fclose($handle);
}
}
}
use yii\helpers\ArrayHelper;
use kartik\select2\Select2;
$session = new Session();
$session->open();
/* @var $this yii\web\View */
/* @var $model backend\models\Saleorder */
/* @var $form yii\widgets\ActiveForm */
?>
<div class="saleorder-form">
<?php
$customer = new \backend\models\Customer();
$currency = new \backend\models\Currency();
$sale = new \backend\models\Saledata();
$country = new \backend\models\Country();
$saleorline = new \backend\models\Saleorderline();
// Yii::$app->params['uploadPath'] = realpath(Yii::$app->basePath) . '/uploads/icon/';
Yii::$app->params['uploadPath'] = '../../uploads/icon/';
// echo Yii::$app->params['uploadPath'];
?>
<?php
$form = ActiveForm::begin(['id' => 'myform', '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">
<?php
use yii\helpers\Html;
use yii\widgets\DetailView;
/* @var $this yii\web\View */
/* @var $model backend\models\Saleorder */
$this->title = $model->saleno;
$this->params['breadcrumbs'][] = ['label' => 'Saleorders', 'url' => ['index']];
$this->params['breadcrumbs'][] = $this->title;
?>
<?php
$saleline = new \backend\models\Saleorderline();
?>
<div class="saleorder-view">
<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' => ['saleno', ['attribute' => 'saledate', 'value' => Yii::$app->formatter->asDate($model->saledate, 'dd-MM-yyyy')], ['attribute' => 'customer', 'value' => $model->customer ? $model->customername->Cus_Name : ""], ['attribute' => 'saleman', 'value' => $model->saleman ? $model->salename->Sale_Name : ''], 'refno', 'description', ['attribute' => 'shipdate', 'value' => Yii::$app->formatter->asDate($model->shipdate, 'dd-MM-yyyy')], ['attribute' => 'shipfrom', 'value' => $model->shipfrom ? $model->shipfromname->Cry_nameEN : ''], ['attribute' => 'shipto', 'value' => $model->shipto ? $model->shiptoname->Cry_nameEN : ''], 'paymentterm', ['attribute' => 'currency', 'value' => $model->currency ? $model->currencyname->currencycode : ''], ['attribute' => 'totalqty', 'value' => number_format($saleline->Ordersum($model->recid)) . " Pcs"], ['attribute' => 'totalamt', 'value' => number_format($saleline->Usdsum($model->recid)) . " " . $model->currencyname->currencycode], ['attribute' => 'totalthb', 'value' => $model->currencyname->currencycode != 'THB' ? number_format($saleline->Usdsum($model->recid) * $model->currencyrate) . " THB" : number_format($saleline->Thbsum($model->recid)) . " " . $model->currencyname->currencycode], 'currencyrate', 'createdate']]);
?>
</div>
