public function actionCreateExisting($id) { $model = new Jual(); $model2 = new Obat(); $model3 = new ListPenjualan(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Obat'])) { $model->tgltrans = date('Y-m-d'); $model->save(); $model3->id_jual = $id; $id_obat = $_POST['Obat']['id_obat']; $result_nama = Yii::app()->db->createCommand("SELECT nama FROM obat WHERE `id_obat`= '{$id_obat}'")->queryAll(); $nama = $result_nama["0"]["nama"]; $result_harga_satuan = Yii::app()->db->createCommand("SELECT hargajual FROM obat WHERE `id_obat`= '{$id_obat}'")->queryAll(); $harga_satuan = $result_harga_satuan["0"]["hargajual"]; $total_harga = $_POST['Obat']['jumlah'] * $harga_satuan; $model3->nama_obat = $nama; $model3->qty = $_POST['Obat']['jumlah']; $model3->harga_satuan = $harga_satuan; $model3->total = $total_harga; $model3->id_obat = $id_obat; if ($model3->save()) { $this->redirect(array('createExisting', 'id' => $id)); } } $this->render('createExisting', array('model' => $model, 'model2' => $model2, 'id' => $id)); }
public function actionCreate() { $model = new Jual(); $model2 = new Obat(); $model3 = new ListPenjualan(); if (isset($_POST['Obat'])) { if ($_POST['Obat']['jumlah'] == 0) { $this->redirect(array('create')); } $model->tgltrans = date('Y-m-d'); $model->save(); $model3->id_jual = $model->id_jual; $id_obat = $_POST['Obat']['id_obat']; $result_nama = Yii::app()->db->createCommand("SELECT nama FROM obat WHERE `id_obat`= '{$id_obat}'")->queryAll(); $nama = $result_nama["0"]["nama"]; $result_harga_satuan = Yii::app()->db->createCommand("SELECT hargajual FROM obat WHERE `id_obat`= '{$id_obat}'")->queryAll(); $harga_satuan = $result_harga_satuan["0"]["hargajual"]; $total_harga = $_POST['Obat']['jumlah'] * $harga_satuan; $model3->nama_obat = $nama; $model3->qty = $_POST['Obat']['jumlah']; $model3->harga_satuan = $harga_satuan; $model3->total = $total_harga; $model3->id_obat = $id_obat; if ($model3->save()) { $connection_delete = Yii::app()->db; } $connection_delete->createCommand("DELETE FROM dummy_list_obat WHERE id_obat='{$id_obat}'")->execute(); $this->redirect(array('createExisting', 'id' => $model->id_jual)); } $this->render('create', array('model' => $model, 'model2' => $model2)); }
public function tambahJual(Request $request) { $jual = new Jual(); $jual->kodeJual = $request->input('kodeJual'); $jual->save(); }