public function actionClosingPeriodExecution()
{
uJournal::model()->updateAll(array('state_id' => 3, 'updated_date' => time(), 'updated_id' => Yii::app()->user->id), 'state_id !=4 AND yearmonth_periode = ' . Yii::app()->settings->get("System", "cCurrentPeriod"));
$this->transferNewPeriod();
$_nextPeriod = sParameter::cBeginDateAfter(Yii::app()->settings->get("System", "cCurrentPeriod"));
Yii::app()->settings->set("System", "cCurrentPeriod", $_nextPeriod, $toDatabase = true);
}
public function actionClosingPeriodExecution()
{
uJournal::model()->updateAll(array('state_id' => 3, 'updated_date' => time(), 'updated_by' => Yii::app()->user->id), 'state_id !=4 AND yearmonth_periode = ' . Yii::app()->settings->get("System", "cCurrentPeriod"));
$_curPeriod = Yii::app()->settings->get("System", "cCurrentPeriod");
$_nextPeriod = sParameter::cBeginDateAfter(Yii::app()->settings->get("System", "cCurrentPeriod"));
$models = tBalanceSheet::model()->findAll('yearmonth_periode = ' . $_curPeriod);
foreach ($models as $model) {
if ($model->account->getTypeValue() == 1) {
$sql = 'INSERT INTO t_balance_sheet (parent_id, yearmonth_periode, type_balance_id, remark, budget, beginning_balance,debit,credit,end_balance) VALUES (' . $model->parent_id . ',' . $_nextPeriod . ', 1, \'Automated posted\', 0,' . $model->end_balance . ',0,0,' . $model->end_balance . ')';
} else {
$sql = 'INSERT INTO t_balance_sheet (parent_id, yearmonth_periode, type_balance_id, remark, budget, beginning_balance,debit,credit,end_balance) VALUES (' . $model->parent_id . ',' . $_nextPeriod . ', 1, \'Automated posted\', 0,0,0,0,0)';
}
$command = Yii::app()->db->createCommand($sql);
$command->execute();
tBalanceSheet::model()->updateAll(array('type_balance_id' => 2), 'yearmonth_periode = ' . $_curPeriod);
}
$_nextPeriod = sParameter::cBeginDateAfter(Yii::app()->settings->get("System", "cCurrentPeriod"));
Yii::app()->settings->set("System", "cCurrentPeriod", $_nextPeriod, $toDatabase = true);
Yii::app()->user->setFlash('success', '<strong>Great!</strong> Closing Period has been successful...');
$this->redirect(array('index'));
}
