/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $products = new Products(); $provider = new Provider(); $prodList = $products->getUseProdList(); $provList = $provider->getProvList(); $model = new Realize(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['provider'])) { $fakturaId = $this->beforeSave($_POST['provider']); $currentDate = date('Y-m-d'); //echo $fakturaId; $transaction = Yii::app()->db->beginTransaction(); try { $messageType = 'warning'; $message = "There are some errors " . count($_POST['product_id']); if ($_POST['product_id']) { for ($i = 0; $i < count($_POST['product_id']); $i++) { $models = new Realize(); $models->faktura_id = $fakturaId; $models->prod_id = $_POST['product_id'][$i]; $models->price = $_POST['price'][$i]; $models->count = $this->changeToFloat($_POST['count'][$i]); if ($models->save()) { $messageType = 'success'; $message = "<strong>Well done!</strong> You successfully create data "; } } } Yii::app()->user->setFlash($messageType, $message); $transaction->commit(); $this->redirect(array('dishes/checkMargin')); } catch (Exception $e) { $transaction->rollBack(); Yii::app()->user->setFlash('error', "{$e->getMessage()}"); //$this->refresh(); } } $this->render('create', array('model' => $model, 'prodList' => $prodList, 'provList' => $provList)); }
public function actionRequest() { $products = new Products(); $provider = new Provider(); $prodList = $products->getUseProdList(); $provList = $provider->getProvList(); $depId = Department::model()->findAll(); $dates = date('Y-m-d H:i:s'); $command = Yii::app()->db->createCommand(); $expense = new Expense(); if (isset($_POST['request'])) { $command->insert('request', array('req_date' => $dates, 'provider_id' => $_POST['provider'])); $lastId = Yii::app()->db->lastInsertID; foreach ($_POST['request'] as $key => $val) { foreach ($val as $keys => $value) { $count = $expense->changeToFloat($value['count']); $command->insert('request_prod', array('request_id' => $lastId, 'prod_id' => $keys, 'depId' => $key, 'count' => $count)); } } $this->redirect(array('view', 'id' => $lastId)); } $this->render('request', array('depId' => $depId, 'prodList' => $prodList, 'provList' => $provList)); }