public function actionCreateid()
{
$session = new Session();
$session->open();
if (\yii::$app->request->isAjax) {
$id = \yii::$app->request->post('invid');
$session['invid'] = $id;
$x;
$count = 0;
foreach ($session['invid'] as $data) {
//
$model = Saleorderline::find()->where(['saleid' => $data])->all();
$model2 = new \backend\models\Saleorderinvoiceline();
foreach ($model as $value) {
$model2 = new \backend\models\Saleorderinvoiceline();
$count += 1;
$model2->invid = $session['invrecid'];
$model2->invline = $count;
$model2->partno = $value->custorderno;
$model2->description = $value->customername;
$model2->quantity = $value->quantity;
$model2->unitprice = $value->unitprice;
$model2->totalamount = $value->totalamount;
$model2->unit = $value->unit;
$model2->saleid = $value->saleid;
$model2->invoiceqty = $value->quantity;
$model2->save();
}
$model3 = new \backend\models\Invoicerefsale();
$model3->invid = $session['invrecid'];
$model3->saleid = $data;
$model3->save();
//cu $x = $data;
}
// foreach ($_POST['sales'] as $data)
// {
// $model2 = new \backend\models\Invoicerefsale();
// $model2->invid =$session['invid'];
// $model2->saleid = $data;
//
// $model2->save();
// }
// return $this->redirect(['saleorderinvoice/update','id'=>$session['invid']]);
return $this->redirect(['saleorderinvoice/update', 'id' => $session['invrecid']]);
// return $count;
} else {
// echo "ess";
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Saleorderline::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
// $query->andFilterWhere([
// 'recid' => $this->recid,
// 'saleid' => $this->saleid,
// 'saleline' => $this->saleline,
// 'quantity' => $this->quantity,
// 'unitprice' => $this->unitprice,
// 'totalamount' => $this->totalamount,
// ]);
$query->orFilterWhere(['like', 'custorderno', $this->globalSearch])->orFilterWhere(['like', 'customername', $this->globalSearch])->orFilterWhere(['like', 'partno', $this->globalSearch]);
return $dataProvider;
}
public function actionDelete($id)
{
if ($this->findModel($id)->delete()) {
$deldetail = Saleorderline::deleteAll('saleid = :saleid', [':saleid' => $id]);
if ($deldetail) {
return $this->redirect(['index']);
}
return $this->redirect(['index']);
}
}
public function actionUpdate($id)
{
$session = new Session();
$session->open();
$totalCount = Saleorderline::find()->where(['saleid' => $id])->count();
$pages = new Pagination(['totalCount' => $totalCount, 'pageSize' => 20]);
$searchModel = Saleorderline::find()->where(['saleid' => $id])->orderBy('recid')->offset($pages->offset)->limit($pages->limit)->all();
$model = $this->findModel($id);
if ($model->load(Yii::$app->request->post())) {
$saledate = $_POST['Saleorder']['saledate'];
$shipdate = $_POST['Saleorder']['shipdate'];
$model->saledate = date('d/M/Y H:i:s', strtotime($saledate));
$model->shipdate = date('d/M/Y H:i:s', strtotime($shipdate));
// $model->shipfrom = $_POST['Saleorder']['shipfrom'];
$model->shipto = isset($session['shipto']) ? $session['shipto'] : '';
$model->saleman = isset($session['salecode']) ? $session['salecode'] : NULL;
$model->createby = $session['userid'];
if ($model->save()) {
$uploaded = UploadedFile::getInstance($model, 'upfile');
$result = 0;
if (!empty($uploaded)) {
// print_r($uploaded);
// return;
$deldetail = Saleorderline::deleteAll('saleid = :saleid', [':saleid' => $id]);
$upfiles = time() . "." . $uploaded->getExtension();
$uploaded->saveAs('../../uploads/' . $upfiles);
// // $uploaded->saveAs();
// // move_uploaded_file($uploaded, '../../uploads/' . $upfiles);
//
$handle = fopen('../../uploads/' . $upfiles, 'r');
// $handle = fopen($uploaded, 'r');
$n = 0;
setlocale(LC_ALL, 'en_US.UTF-8');
while (($fileop = fgetcsv($handle, 1000, ",")) !== false) {
if ($n < 1) {
$n++;
continue;
}
$model2 = new \backend\models\Saleorderline();
$model2->saleid = $model->recid;
$model2->saleline = $fileop[0];
$model2->partno = $fileop[1];
$model2->custorderno = iconv("TIS-620", "UTF-8", $fileop[2]);
$model2->customername = iconv("TIS-620", "UTF-8", $fileop[3]);
$model2->quantity = $fileop[4];
$model2->unitprice = $fileop[5];
$model2->totalamount = $fileop[6];
$model2->unit = 1;
// $model2->partno=$fileop[7];
// 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();
if ($model2->save()) {
$result++;
}
}
fclose($handle);
unlink('../../uploads/' . $upfiles);
if ($result > 0) {
$session = new \yii\web\Session();
$session->open();
$session->setFlash('msgsuccess', 'บันทึกรายการเรียบร้อย');
return $this->redirect(['update', 'id' => $model->recid]);
}
}
}
} else {
return $this->render('update', ['model' => $model, 'saleline' => $searchModel, 'pages' => $pages, 'rowcount' => $totalCount]);
}
return $this->render('update', ['model' => $model, 'saleline' => $searchModel, 'pages' => $pages, 'rowcount' => $totalCount]);
}
/**
* Finds the Saleorderline model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Saleorderline the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Saleorderline::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
