public function simpan()
{
$this->scenario = 'simpan';
$transaction = $this->dbConnection->beginTransaction();
try {
/*
* Save sekaligus mengubah status dari draft jadi piutang
*/
if ($this->save()) {
$details = ReturPenjualanDetail::model()->findAll("retur_penjualan_id={$this->id}");
foreach ($details as $detail) {
/*
* Untuk setiap item, tambahkan qty ke inventory baru
*/
InventoryBalance::model()->returJual($detail);
}
// Total dari retur penjualan
// Jika nanti ada item lain, misal: Transport, pajak, dll
// ditambahkan di sini
$jumlahReturJual = $this->ambilTotal();
/*
* Create hutang
*/
$hutang = new HutangPiutang();
$hutang->profil_id = $this->profil_id;
$hutang->jumlah = $jumlahReturJual;
$hutang->tipe = HutangPiutang::TIPE_HUTANG;
$hutang->asal = HutangPiutang::DARI_RETUR_JUAL;
$hutang->nomor_dokumen_asal = $this->nomor;
if (!$hutang->save()) {
throw new Exception("Gagal simpan hutang");
}
/*
* Hutang Detail
*/
$hutangDetail = new HutangPiutangDetail();
$hutangDetail->hutang_piutang_id = $hutang->id;
$hutangDetail->keterangan = 'Retur Jual: ' . $this->nomor;
$hutangDetail->jumlah = $jumlahReturJual;
if (!$hutangDetail->save()) {
throw new Exception("Gagal simpan hutang detail");
}
/*
* Simpan hutang_id ke pembelian
*/
if (!ReturPenjualan::model()->updateByPk($this->id, array('hutang_piutang_id' => $hutang->id)) > 1) {
throw new Exception("Gagal simpan hutang_id");
}
$transaction->commit();
return true;
} else {
throw new Exception("Gagal Simpan Retur Penjualan");
}
} catch (Exception $e) {
$transaction->rollback();
throw $e;
}
}
public function modelAsal()
{
switch ($this->asal) {
case InventoryBalance::ASAL_PEMBELIAN:
return Pembelian::model()->find("nomor={$this->nomor_dokumen}");
case InventoryBalance::ASAL_RETURJUAL:
return ReturPenjualan::model()->find("nomor={$this->nomor_dokumen}");
case InventoryBalance::ASAL_SO:
return StockOpname::model()->find("nomor={$this->nomor_dokumen}");
}
}
public function updateStatusDokumenAsal($status)
{
switch ($this->asal) {
case HutangPiutang::DARI_PEMBELIAN:
$model = Pembelian::model()->findByAttributes(array('hutang_piutang_id' => $this->id));
$model->status = $status == HutangPiutang::STATUS_LUNAS ? Pembelian::STATUS_LUNAS : Pembelian::STATUS_HUTANG;
$model->update(array('status'));
break;
case HutangPiutang::DARI_RETUR_BELI:
$model = ReturPembelian::model()->findByAttributes(array('hutang_piutang_id' => $this->id));
$model->status = $status == HutangPiutang::STATUS_LUNAS ? ReturPembelian::STATUS_LUNAS : ReturPembelian::STATUS_PIUTANG;
$model->update(array('status'));
break;
case HutangPiutang::DARI_PENJUALAN:
$model = Penjualan::model()->findByAttributes(array('hutang_piutang_id' => $this->id));
$model->status = $status == HutangPiutang::STATUS_LUNAS ? Penjualan::STATUS_LUNAS : Penjualan::STATUS_PIUTANG;
$model->update(array('status'));
break;
case HutangPiutang::DARI_RETUR_JUAL:
$model = ReturPenjualan::model()->findByAttributes(array('hutang_piutang_id' => $this->id));
$model->status = $status == HutangPiutang::STATUS_LUNAS ? ReturPenjualan::STATUS_LUNAS : ReturPenjualan::STATUS_HUTANG;
$model->update(array('status'));
break;
}
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer $id the ID of the model to be loaded
* @return ReturPenjualan the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = ReturPenjualan::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
