Пример #1
0
 /**
  * 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];
     /*
      * 200 = Sales
      */
     if (!in_array($model->reff_type, [200])) {
         return;
     }
     $sales = MSales::findOne($model->reff_id);
     $salesDtls = ArrayHelper::index($sales->salesDtls, 'product_id');
     // change total qty for reff document
     /* @var $purcDtl \biz\core\sales\models\SalesDtl */
     foreach ($model->goodsMovementDtls as $detail) {
         $salesDtl = $salesDtls[$detail->product_id];
         $salesDtl->total_release += $detail->qty;
         $salesDtl->save(false);
     }
     $complete = true;
     foreach ($salesDtls as $salesDtl) {
         if ($salesDtl->total_release != $salesDtl->qty) {
             $complete = false;
             break;
         }
     }
     if ($complete) {
         $sales->status = MSales::STATUS_COMPLETE_RELEASE;
         $sales->save(false);
     } elseif ($sales->status == MSales::STATUS_DRAFT) {
         $sales->status = MSales::STATUS_PARTIAL_RELEASE;
         $sales->save(false);
     }
 }
Пример #2
0
 public function behaviors()
 {
     $behaviors = parent::behaviors();
     return array_merge([['class' => 'mdm\\converter\\DateConverter', 'attributes' => ['Date' => 'date']], ['class' => 'mdm\\converter\\RelatedConverter', 'attributes' => ['nmCustomer' => [[Customer::className(), 'id' => 'customer_id'], 'name']]]], $behaviors);
 }
Пример #3
0
 /**
  * @param  array                           $data
  * @param  \biz\core\accounting\models\Invoice $model
  * @return \biz\core\accounting\models\Invoice
  * @throws UserException
  */
 public function createFromSales($data, $model = null)
 {
     $ids = (array) $data['id_sales'];
     $vendors = Sales::find()->select('id_customer')->distinct()->column();
     if (count($vendors) !== 1) {
         throw new UserException('Vendor harus sama');
     }
     // invoice for GI
     $released = GoodsMovement::find()->select('id_movement')->where(['type_reff' => GoodsMovement::TYPE_SALES, 'reff_id' => $ids])->column();
     $invoiced = InvoiceDtl::find()->select('reff_id')->where(['type_reff' => InvoiceDtl::TYPE_SALES_GI, 'reff_id' => $released])->column();
     $new = array_diff($released, $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');
     }])->where(['hdr.type_reff' => GoodsMovement::TYPE_SALES, 'hdr.reff_id' => $new])->groupBy('hdr.id_movement')->indexBy('id_movement')->asArray()->all();
     unset($data['id_sales']);
     $data['id_vendor'] = reset($vendors);
     $data['invoice_type'] = MInvoice::TYPE_OUT;
     $details = [];
     foreach ($new as $id) {
         $details[] = ['type_reff' => InvoiceDtl::TYPE_SALES_GI, 'reff_id' => $id, 'trans_value' => $values[$id]['jml']];
     }
     // Invoice for discount
     $completed = Sales::find()->select(['id_sales', 'discount'])->andWhere(['status' => Sales::STATUS_RELEASED, 'id_sales' => $ids])->andWhere(['<>', 'discount', null])->asArray()->indexBy('id_sales')->all();
     $invoiced = InvoiceDtl::find()->select('reff_id')->where(['type_reff' => InvoiceDtl::TYPE_SALES_DISCOUNT, 'reff_id' => array_keys($completed)])->column();
     $new = array_diff(array_keys($completed), $invoiced);
     foreach ($new as $id) {
         $details[] = ['type_reff' => InvoiceDtl::TYPE_SALES_DISCOUNT, 'reff_id' => $id, 'trans_value' => -$completed['discount']];
     }
     $data['details'] = $details;
     $model = $this->create($data, $model);
     $model = $this->post('', [], $model);
     return $model;
 }
Пример #4
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getSales()
 {
     return $this->hasOne(Sales::className(), ['id' => 'sales_id']);
 }