/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model = new ListPenjualan(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['ListPenjualan'])) { $model->attributes = $_POST['ListPenjualan']; if ($model->save()) { $this->redirect(array('view', 'id' => $model->id_list_penjualan)); } } $this->render('create', array('model' => $model)); }
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 actionCreateKeteranganExisting($id, $keterangan) { $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'])) { if ($_POST['Obat']['jumlah'] == 0) { $this->redirect(array('CreateKeteranganExisting', 'id' => $id, 'keterangan' => $keterangan)); } $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; $model3->keterangan = $keterangan; 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('CreateKeteranganExisting', 'id' => $id, 'keterangan' => $keterangan)); } $this->render('createKeteranganExisting', array('model' => $model, 'model2' => $model2, 'id' => $id, 'keterangan' => $keterangan)); }