Пример #1
0
 /**
  *
  * @param  array $params Required field warehouse_id, product_id, qty
  * Optional field app, reff_id, uom_id, item_value
  * @return boolean
  * @throws UserException
  */
 public function updateStock($params)
 {
     $stock = MProductStock::findOne(['warehouse_id' => $params['warehouse_id'], 'product_id' => $params['product_id']]);
     if (isset($params['uom_id'])) {
         $qty_per_uom = ProductUom::find()->select('isi')->where(['product_id' => $params['product_id'], 'uom_id' => $params['uom_id']])->scalar();
         if ($qty_per_uom === false) {
             throw new NotFoundException("Uom '{$params['uom_id']}' not found for product '{$params['product_id']}'");
         }
     } else {
         $qty_per_uom = 1;
     }
     if (!$stock) {
         $stock = new MProductStock(['warehouse_id' => $params['warehouse_id'], 'product_id' => $params['product_id'], 'qty' => 0]);
     }
     // update cogs
     if (isset($params['price']) && $params['price'] !== '') {
         $params['qty_per_uom'] = $qty_per_uom;
         $this->updateCogs($params);
     }
     $stock->qty = $stock->qty + $params['qty'] * $qty_per_uom;
     if ($stock->canSetProperty('logParams')) {
         $logParams = ['mv_qty' => $params['qty'] * $qty_per_uom];
         foreach (['app', 'reff_id'] as $key) {
             if (isset($params[$key]) || array_key_exists($key, $params)) {
                 $logParams[$key] = $params[$key];
             }
         }
         $stock->logParams = $logParams;
     }
     if (!$stock->save()) {
         throw new UserException(implode(",\n", $stock->firstErrors));
     }
     return true;
 }
Пример #2
0
 /**
  *
  * @param  StockOpname      $opname
  * @param  MStockAdjustment $model
  * @return mixed
  * @throws \Exception
  */
 public function createFromOpname($opname, $model = null)
 {
     // info product
     $currentStocks = ProductStock::find()->select(['product_id', 'qty_stock'])->where(['warehouse_id' => $opname->warehouse_id])->indexBy('product_id')->asArray()->all();
     $isiProductUoms = [];
     foreach (ProductUom::find()->asArray()->all() as $row) {
         $isiProductUoms[$row['product_id']][$row['uom_id']] = $row['isi'];
     }
     // ***
     $data = ['warehouse_id' => $opname->warehouse_id, 'adjustment_date' => date('Y-m-d'), 'reff_id' => $opname->id, 'description' => "Stock adjustment from stock opname no \"{$opname->opname_num}\"."];
     $details = [];
     foreach ($opname->stockOpnameDtls as $detail) {
         $cQty = $currentStocks[$detail->product_id] / $isiProductUoms[$detail->product_id][$detail->uom_id];
         $details[] = ['product_id' => $detail->product_id, 'uom_id' => $detail->uom_id, 'qty' => $detail->qty - $cQty];
     }
     $data['details'] = $details;
     return $this->create($data, $model);
 }