/**
* 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));
}
