/**
* Creates a new Sales model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$profile = Yii::$app->profile;
if (!isset($profile->branch_id, $profile->warehouse_id) || $profile->branch_id == '') {
Yii::$app->getSession()->setFlash('_config_return_url', Yii::$app->getRequest()->getUrl());
return $this->redirect(['config']);
}
$model = new Sales();
$model->status = Sales::STATUS_RELEASED;
$model->date = date('Y-m-d');
$model->branch_id = Yii::$app->profile->branch_id;
$model->vendor_id = !isset(Yii::$app->params['default_cust']) ? Sales::DEFAULT_VENDOR : Yii::$app->params['default_cust'];
$model->vendor_name = $model->vendor != null ? $model->vendor->name : '';
$error = false;
$whse = $this->findWarehouse(Yii::$app->profile->warehouse_id);
$payments = [];
if ($model->load(Yii::$app->request->post())) {
$transaction = Yii::$app->db->beginTransaction();
$model->branch_id = $profile->branch_id;
try {
$payments = Helper::createMultiple(Payment::className(), Yii::$app->request->post());
if (!empty($payments)) {
$model->items = Yii::$app->request->post('SalesDtl', []);
if ($model->save()) {
$movement = $model->createMovement(['warehouse_id' => $profile->warehouse_id, 'description' => 'Sales Retail']);
$glHeader = new GlHeader(['status' => GlHeader::STATUS_RELEASED, 'reff_type' => GlHeader::REFF_SALES, 'reff_id' => $model->id, 'date' => date('Y-m-d'), 'branch_id' => $model->branch_id, 'periode_id' => $this->findPeriode(), 'description' => "Sales POS [{$model->number}]"]);
//Create Jurnal
$coa_sales = ['penjualan' => 16, 'persediaan' => 32, 'hpp' => 19, 'diskon' => 18];
$tcogs = 0;
$penjualan = 0;
$diskon = 0;
foreach ($model->items as $item) {
$tcogs += $item->cogs * $item->qty * $item->productUom->isi;
$penjualan += $item->price * $item->qty * $item->productUom->isi;
$diskon += 0.01 * $item->discount * $item->qty * $item->productUom->isi * $item->price;
}
$glDetails = [];
// Hpp(D) Vs Persediaan(K)
$glDetails[] = ['coa_id' => $coa_sales['hpp'], 'amount' => $tcogs];
$glDetails[] = ['coa_id' => $coa_sales['persediaan'], 'amount' => -$tcogs];
if ($movement && $movement->save()) {
$invoice = $movement->createInvoice();
if ($invoice && $invoice->save()) {
/* @var $payment Payment */
$success = true;
$total = 0;
$invoiceTotal = $invoice->value;
$model->reff_type = Sales::REFF_INVOICE;
$model->reff_id = $invoice->id;
$model->save();
$paymentData = ['vendor_id' => $invoice->vendor_id, 'date' => date('Y-m-d'), 'type' => $invoice->type];
$totalPaid = 0;
foreach ($payments as $payment) {
$payment->attributes = $paymentData;
$payment->status = Payment::STATUS_RELEASED;
$payItems = $payment->items;
$payItems[0]->invoice_id = $invoice->id;
if ($invoiceTotal - $total >= $payItems[0]->value) {
$total += $payItems[0]->value;
} else {
$payItems[0]->value = $invoiceTotal - $total;
$total = $invoiceTotal;
}
// payment
$bayar = $payItems[0]->value * (1 - $payment->paymentMethod->potongan);
$glDetails[] = ['coa_id' => $payment->paymentMethod->coa_id, 'amount' => $bayar];
// potongan payment method
$potongan_cc = 0;
if ($payment->paymentMethod->potongan > 0) {
$potongan_cc = $payItems[0]->value * $payment->paymentMethod->potongan;
$glDetails[] = ['coa_id' => $payment->paymentMethod->coa_id_potongan, 'amount' => $potongan_cc];
}
$totalPaid += $bayar + $potongan_cc;
$payment->items = $payItems;
}
// Penjualan(K) Vs [Payment(D) + Diskon(D)]
if ($diskon != 0) {
$glDetails[] = ['coa_id' => $coa_sales['diskon'], 'amount' => $diskon];
}
$glDetails[] = ['coa_id' => $coa_sales['penjualan'], 'amount' => -1 * $penjualan];
if ($invoice->value >= $total) {
foreach ($payments as $i => $payment) {
if (!$payment->save()) {
$success = false;
$firstErrors = $payment->firstErrors;
$error = "Payment {$i}: " . reset($firstErrors);
break;
}
}
if ($success) {
$glHeader->glDetails = $glDetails;
if (!$glHeader->save()) {
$success = false;
$firstErrors = $glHeader->firstErrors;
$error = "Journal: " . reset($firstErrors);
}
}
} else {
$success = false;
//seharusnya muncul cash back jika berlebih, bukan error
$error = 'Kurang bayar';
}
if ($success) {
$transaction->commit();
//return $this->redirect(['create']);
return $this->redirect(['view', 'id' => $model->id]);
}
} else {
if ($invoice) {
$firstErrors = $invoice->firstErrors;
$error = "Invoice: " . reset($firstErrors);
} else {
$error = 'Cannot create invoice';
}
}
} else {
if ($movement) {
$firstErrors = $movement->firstErrors;
$error = "GI: " . reset($firstErrors);
} else {
$error = 'Cannot create GI';
}
}
}
} else {
$error = "Payment can not empty";
}
if ($error !== false) {
$model->addError('related', $error);
}
} catch (\Exception $exc) {
$transaction->rollBack();
throw $exc;
}
$transaction->rollBack();
}
return $this->render('create', ['model' => $model, 'payments' => $payments, 'warehouse' => $whse->name]);
}
/**
* Creates a new Sales model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$profile = Yii::$app->profile;
if (!isset($profile->branch_id, $profile->warehouse_id)) {
return $this->redirect(['config']);
}
$model = new Sales();
$model->status = Sales::STATUS_RELEASED;
$model->date = date('Y-m-d');
$error = false;
$payments = [];
if ($model->load(Yii::$app->request->post())) {
$transaction = Yii::$app->db->beginTransaction();
try {
$payments = Helper::createMultiple(Payment::className(), Yii::$app->request->post());
if (!empty($payments)) {
$model->items = Yii::$app->request->post('SalesDtl', []);
if ($model->save()) {
$movement = $model->createMovement(['warehouse_id' => $profile->warehouse_id]);
if ($movement && $movement->save()) {
$invoice = $movement->createInvoice();
if ($invoice && $invoice->save()) {
/* @var $payment Payment */
$success = true;
$total = 0;
$paymentData = ['vendor_id' => $invoice->vendor_id, 'date' => date('Y-m-d'), 'type' => $invoice->type];
foreach ($payments as $payment) {
$payment->attributes = $paymentData;
$payment->status = Payment::STATUS_RELEASED;
$payItems = $payment->items;
$payItems[0]->invoice_id = $invoice->id;
$total += $payItems[0]->value;
$payment->items = $payItems;
}
if ($invoice->value == $total) {
foreach ($payments as $i => $payment) {
if (!$payment->save()) {
$success = false;
$firstErrors = $payment->firstErrors;
$error = "Payment {$i}: " . reset($firstErrors);
break;
}
}
} else {
$success = false;
$error = 'Total payment tidak sama dengan invoice';
}
if ($success) {
$transaction->commit();
return $this->redirect(['view', 'id' => $model->id]);
}
} else {
if ($invoice) {
$firstErrors = $invoice->firstErrors;
$error = "Invoice: " . reset($firstErrors);
} else {
$error = 'Cannot create invoice';
}
}
} else {
if ($movement) {
$firstErrors = $movement->firstErrors;
$error = "GI: " . reset($firstErrors);
} else {
$error = 'Cannot create GI';
}
}
}
} else {
$error = "Payment can not empty";
}
if ($error !== false) {
$model->addError('related', $error);
}
} catch (\Exception $exc) {
$transaction->rollBack();
throw $exc;
}
$transaction->rollBack();
}
return $this->render('create', ['model' => $model, 'payments' => $payments]);
}
/**
* Creates a new GlHeader model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreateByTemplate()
{
$dPost = Yii::$app->request->post();
$model = new GlHeader();
$model->reff_type = '0';
$model->status = $model::STATUS_RELEASED;
$model->date = date('Y-m-d');
$dPost = Yii::$app->request->post();
$templates = [];
if ($model->load($dPost)) {
$transaction = Yii::$app->db->beginTransaction();
try {
//entri details from templates
$templates = Helper::createMultiple(GlTemplate::className(), $dPost);
$amounts = [];
/* @var $template GlTemplate */
foreach ($templates as $template) {
$amounts[$template->es->code] = $template->amount;
}
$model->addFromTemplate($amounts, true);
if ($model->save()) {
$transaction->commit();
\Yii::$app->getSession()->setFlash('success', $model->number . ' succesfully created');
return $this->redirect(['view', 'id' => $model->id]);
} else {
$errors = $model->firstErrors;
Yii::$app->getSession()->setFlash('error', reset($errors));
$transaction->rollback();
}
} catch (Exception $e) {
$transaction->rollback();
throw $e;
}
}
return $this->render('create-by-template', ['model' => $model, 'templates' => $templates]);
}