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();
}
