Пример #1
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = StockOpnameDtlModel::find()->with('products');
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $this->load($params);
     if (!$this->validate()) {
         $query->where('1=0');
         return $dataProvider;
     }
     $query->andFilterWhere(['id_opname' => $this->id_opname, 'id_product' => $this->id_product, 'id_uom' => $this->id_uom, 'qty' => $this->qty]);
     return $dataProvider;
 }
Пример #2
0
 public static function append($id, $data, $model = null)
 {
     /* @var $model MStockOpname */
     $model = $model ?: static::findModel($id);
     $e_name = static::prefixEventName();
     $success = true;
     $model->scenario = MStockOpname::SCENARIO_DEFAULT;
     $model->load($data, '');
     try {
         $transaction = Yii::$app->db->beginTransaction();
         Yii::$app->trigger($e_name . '_append', new Event([$model]));
         $stockOpnameDtls = ArrayHelper::index($model->stockOpnameDtls, 'id_product');
         foreach ($data['details'] as $dataDetail) {
             $index = $dataDetail['id_product'];
             // id_product
             if (isset($stockOpnameDtls[$index])) {
                 $detail = $stockOpnameDtls[$index];
             } else {
                 $detail = new StockOpnameDtl(['id_opname' => $model->id_opname, 'id_product' => $dataDetail['id_product'], 'id_uom' => $dataDetail['id_uom'], 'qty' => 0]);
             }
             $detail->qty += $dataDetail['qty'];
             $success = $success && $detail->save();
             $stockOpnameDtls[$index] = $detail;
             Yii::$app->trigger($e_name . '_append_body', new Event([$model, $detail]));
         }
         if ($success) {
             Yii::$app->trigger($e_name . '_appended', new Event([$model]));
             $transaction->commit();
         } else {
             $transaction->rollBack();
         }
     } catch (\Exception $exc) {
         $transaction->rollBack();
         throw $exc;
     }
     return [$success, $model];
 }
Пример #3
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getStockOpnameDtls()
 {
     return $this->hasMany(StockOpnameDtl::className(), ['id_opname' => 'id_opname']);
 }