/** * Creates a new GoodsMovement model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate($type = null) { $model = new GoodsMovement(); $model->type = $type; $model->description = $type == GoodsMovement::TYPE_RECEIVE ? 'Penerimaan Pembelian' : 'Pengeluaran Manual'; $model->date = date('Y-m-d'); if ($model->load(Yii::$app->request->post())) { $model->status = GoodsMovement::STATUS_DRAFT; $transaction = Yii::$app->db->beginTransaction(); try { $model->items = Yii::$app->request->post('GoodsMovementDtl', []); if ($model->save()) { $transaction->commit(); return $this->redirect(['view', 'id' => $model->id]); } } catch (\Exception $exc) { $transaction->rollBack(); throw $exc; } $transaction->rollBack(); } return $this->render('create', ['model' => $model]); }
public function adjustStock() { $gm = new GoodsMovement(['warehouse_id' => $this->warehouse_id, 'type' => GoodsMovement::TYPE_RECEIVE, 'date' => date('Y-m-d'), 'reff_type' => self::REFF_SELF, 'reff_id' => $this->id, 'description' => 'stock opname adjustment', 'status' => GoodsMovement::STATUS_RELEASED]); //$gm->items->scenario = GoodsMovementDtl::SCENARIO_ADJUSTMENT; $query = (new \yii\db\Query())->select(['p.id', 'selisih' => 'COALESCE(o.qty,0)-COALESCE(s.qty,0)'])->from(['p' => '{{%product}}'])->innerJoin(['s' => '{{%product_stock}}'], '[[s.product_id]]=[[p.id]] and [[s.warehouse_id]]=:whse', [':whse' => $this->warehouse_id])->leftJoin(['o' => '{{%stock_opname_dtl}}'], '[[o.product_id]]=[[p.id]] and [[o.opname_id]]=:opid', [':opid' => $this->id])->where('COALESCE(o.qty,0)<>COALESCE(s.qty,0)'); $items = []; foreach ($query->all() as $row) { $items[] = ['product_id' => $row['id'], 'qty' => $row['selisih'], 'uom_id' => 1]; } $gm->items = $items; if ($gm->save()) { return true; } print_r($gm->firstErrors); return false; }
public function actionCreateReceipt($type, $id, $desc = null) { $model = new GoodsMovement(['reff_type' => $type, 'reff_id' => $id, 'description' => $desc]); if (($reff = $model->updateFromReceipt()) !== false) { list($reffModel, $reff) = $reff; } else { throw new NotFoundHttpException('The requested page does not exist.'); } if ($type == GoodsMovement::REFF_TRANSFER) { $model->vendor_id = 12; $model->vendor_name = 'Internal'; } $model->date = date('Y-m-d'); $model->type = GoodsMovement::TYPE_RECEIVE; if ($model->load(Yii::$app->request->post())) { $model->status = GoodsMovement::STATUS_DRAFT; $transaction = Yii::$app->db->beginTransaction(); try { $model->items = Yii::$app->request->post('GoodsMovementDtl', []); if ($model->save()) { $transaction->commit(); return $this->redirect(['view', 'id' => $model->id]); } } catch (\Exception $exc) { $transaction->rollBack(); throw $exc; } $transaction->rollBack(); } return $this->render('create', ['model' => $model, 'reffModel' => $reffModel, 'reff' => $reff]); }