/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = PaymentModel::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
$query->where('1=0');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'date' => $this->date, 'type' => $this->type, 'payment_method' => $this->payment_method, 'status' => $this->status, 'created_at' => $this->created_at, 'created_by' => $this->created_by, 'updated_at' => $this->updated_at, 'updated_by' => $this->updated_by]);
$query->andFilterWhere(['like', 'number', $this->number]);
return $dataProvider;
}
/**
* 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]);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getPayments()
{
return $this->hasMany(Payment::className(), ['id' => 'payment_id'])->viaTable('payment_dtl', ['invoice_id' => 'id']);
}
/**
* Finds the Payment model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Payment the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Payment::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
/**
* 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]);
}
<div class="row">
<div class="col-md-6">
<div class="form-group field-sales-value required">
<label class="control-label">Value</label>
<input type="text" style="width:40%;" readonly="" class="form-control" id="payment-value">
</div>
<table class="table table-striped">
<thead>
<tr>
<th><?php
echo Html::dropDownList('', null, Payment::enums('METHOD_'), ['class' => 'form-control', 'id' => 'inp-payment-method']);
?>
</th>
<th><input class="form-control" id="inp-payment-value"></th>
<th><a class="btn" id="add-payment"><span class="glyphicon glyphicon-plus"></span></a></th>
</tr>
</thead>
</table>
</div>
<div class="col-md-6">
<div class="form-group field-sales-value required">
<label class="control-label">Total</label>
<input type="text" style="width:40%;" readonly="" class="form-control" id="payment-total">
</div>
<table class="table table-striped">
<?php
echo TabularInput::widget(['id' => 'payment-grid', 'allModels' => $payments, 'model' => Payment::className(), 'tag' => 'tbody', 'itemOptions' => ['tag' => 'tr'], 'itemView' => '_payment_detail', 'clientOptions' => []]);
?>
</table>
</div>
</div>
/**
* @return \yii\db\ActiveQuery
*/
public function getPayment()
{
return $this->hasOne(Payment::className(), ['id' => 'payment_id']);
}
