public function labarugiExecution()
{
$_curPeriod = Yii::app()->settings->get("System", "cCurrentPeriod");
$_labarugi = tAccount::netprofit($_curPeriod);
$_lraccount = tAccount::model()->with('accmain')->find('accmain.mvalue=8')->id;
$modelBalanceCurrent = tBalanceSheet::model()->find(array('condition' => 'parent_id =' . $_lraccount . ' AND yearmonth_periode = ' . $_curPeriod));
if ($modelBalanceCurrent == null) {
//New Account on This Period
$sql = 'INSERT INTO t_balance_sheet (parent_id, yearmonth_periode, type_balance_id, remark, budget, beginning_balance,debit,credit,end_balance) VALUES (' . $_lraccount . ',' . $_curPeriod . ', 1, "Automated posted", 0,' . $_labarugi . ',0,0,' . $_labarugi . ')';
} else {
$_labarugi = $_labarugi + $modelBalanceCurrent->beginning_balance;
$sql = 'UPDATE t_balance_sheet SET
debit = 0,
credit = 0,
end_balance = ' . $_labarugi . '
WHERE yearmonth_periode = ' . $_curPeriod . ' AND parent_id = ' . $_lraccount;
}
$command = Yii::app()->db->createCommand($sql);
$command->execute();
}
