/**
* Handler for Good Movement created.
* It used to update stock
* @param \biz\core\base\Event $event
*/
public function goodsMovementApplied($event)
{
/* @var $model MGoodsMovement */
$model = $event->params[0];
/*
* 100 = Purchase
*/
if (!in_array($model->reff_type, [100])) {
return;
}
$purchase = MPurchase::findOne($model->reff_id);
$purchaseDtls = ArrayHelper::index($purchase->purchaseDtls, 'product_id');
// change total qty for reff document
/* @var $purcDtl \biz\core\purchase\models\PurchaseDtl */
foreach ($model->goodsMovementDtls as $detail) {
$purcDtl = $purchaseDtls[$detail->product_id];
$purcDtl->total_receive += $detail->qty;
$purcDtl->save(false);
}
$complete = true;
foreach ($purchaseDtls as $purcDtl) {
if ($purcDtl->total_receive != $purcDtl->qty) {
$complete = false;
break;
}
}
if ($complete) {
$purchase->status = MPurchase::STATUS_PROCESS;
$purchase->save(false);
} elseif ($purchase->status == MPurchase::STATUS_DRAFT) {
$purchase->status = MPurchase::STATUS_PROCESS;
$purchase->save(false);
}
}
/**
*
* @param array $data
* @param \biz\core\accounting\models\Invoice $model
* @return biz\core\accounting\models\Invoice
* @throws UserException
*/
public function createFromPurchase($data, $model = null)
{
$ids = (array) $data['id_purchase'];
$vendors = Purchase::find()->select('id_supplier')->distinct()->column();
if (count($vendors) !== 1) {
throw new UserException('Vendor harus sama');
}
// invoice for GR
$received = GoodsMovement::find()->select('id_movement')->where(['type_reff' => GoodsMovement::TYPE_PURCHASE, 'reff_id' => $ids])->column();
$invoiced = InvoiceDtl::find()->select('reff_id')->where(['type_reff' => InvoiceDtl::TYPE_PURCHASE_GR, 'reff_id' => $received])->column();
$new = array_diff($received, $invoiced);
$values = GoodsMovement::find()->select(['hdr.id_movement', 'jml' => 'sum(dtl.qty*dtl.trans_value)'])->from(GoodsMovement::tableName() . ' hdr')->joinWith(['goodsMovementDtls' => function ($q) {
$q->from(GoodsMovementDtl::tableName() . ' dtl');
}])->andWhere(['hdr.type_reff' => GoodsMovement::TYPE_PURCHASE, 'hdr.reff_id' => $new])->groupBy('hdr.id_movement')->indexBy('id_movement')->asArray()->all();
unset($data['id_purchase']);
$data['id_vendor'] = reset($vendors);
$data['invoice_type'] = MInvoice::TYPE_IN;
$details = [];
foreach ($new as $id) {
$details[] = ['type_reff' => InvoiceDtl::TYPE_PURCHASE_GR, 'reff_id' => $id, 'trans_value' => $values[$id]['jml']];
}
// Invoice for Global discount
// get complete received purchase that invoiced yet :D
$completed = Purchase::find()->select(['id_purchase', 'discount'])->andWhere(['status' => Purchase::STATUS_RECEIVED, 'id_purchase' => $ids])->andWhere(['<>', 'discount', null])->asArray()->indexBy('id_purchase')->all();
$invoiced = InvoiceDtl::find()->select('reff_id')->where(['type_reff' => InvoiceDtl::TYPE_PURCHASE_DISCOUNT, 'reff_id' => array_keys($completed)])->column();
$new = array_diff(array_keys($completed), $invoiced);
foreach ($new as $id) {
$details[] = ['type_reff' => InvoiceDtl::TYPE_PURCHASE_DISCOUNT, 'reff_id' => $id, 'trans_value' => -$completed['discount']];
}
$data['details'] = $details;
$model = $this->create($data, $model);
$model = $this->post('', [], $model);
return $model;
}
public function behaviors()
{
$behaviors = parent::behaviors();
return array_merge($behaviors, [['class' => 'mdm\\converter\\DateConverter', 'attributes' => ['Date' => 'date']], ['class' => 'mdm\\converter\\RelatedConverter', 'attributes' => ['nmSupplier' => [[Supplier::className(), 'id' => 'supplier_id'], 'name']]]]);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getPurchase()
{
return $this->hasOne(Purchase::className(), ['id' => 'purchase_id']);
}
