public function actionCreate() { $model = new Transactions(); $detailModel = new TransactionDetailSearch(); $detailProvider = $detailModel->search(Yii::$app->request->queryParams); if ($model->load(Yii::$app->request->post())) { $data = Yii::$app->request->post(); $_tanggal = explode("/", $data["Transactions"]["trans_date"]); $transaction_date = $_tanggal[2] . '-' . $_tanggal[1] . '-' . $_tanggal[0]; $transaction_id = $this->_newTrans; // HEADER if (sizeof($data["item"]["code"]) > 0) { $transaction_id = $this->_saveHeader('insert', $transaction_id, $transaction_date, $data["Transactions"]["trans_employee"], array_sum($data["item"]["price"])); for ($i = 0; $i < sizeof($data["item"]["code"]); $i++) { $transactions = $this->_saveDetail($transaction_id, $data["item"]["code"][$i], $data["item"]["qty"][$i], $data["item"]["price"][$i]); } } Yii::$app->session->setFlash('success', 'Transaksi berhasil disimpan'); return $this->redirect(['index']); } else { $employee = Employees::find()->one(); $q = \Yii::$app->db; $rowsDetail = $q->createCommand("SELECT * FROM vtransdetail_init WHERE trans_id='" . $this->_newTrans . "'")->queryAll(); return $this->render('create', ['model' => $model, 'transid' => $this->_newTrans, 'detailModel' => $detailModel, 'detailProvider' => $detailProvider, 'rows' => $rowsDetail]); } }
/** * Lists all TransactionDetail models. * @return mixed */ public function actionIndex() { $searchModel = new TransactionDetailSearch(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]); }