/** * * @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; }