<?php $this->widget('bootstrap.widgets.BootGridView', array('id' => 'u-journal-detail-grid', 'dataProvider' => uJournalDetail::model()->search($id), 'template' => '{items}{pager}', 'itemsCssClass' => 'table table-striped table-bordered', 'columns' => array(array('name' => 'account_no_id', 'type' => 'raw', 'value' => 'CHtml::link($data->account->account_no.". ".$data->account->account_name,Yii::app()->createUrl("/m2/tAccount/view",array("id"=>$data->account->id)))'), array('class' => 'ext.gridcolumns.TotalColumn', 'name' => 'debit', 'output' => 'Yii::app()->indoFormat->number($value)', 'type' => 'raw', 'footer' => true, 'htmlOptions' => array('style' => 'text-align: right; padding-right: 5px;'), 'footerHtmlOptions' => array('style' => 'text-align: right; padding-right: 5px;')), array('class' => 'ext.gridcolumns.TotalColumn', 'name' => 'credit', 'output' => 'Yii::app()->indoFormat->number($value)', 'type' => 'raw', 'footer' => true, 'htmlOptions' => array('style' => 'text-align: right; padding-right: 5px;'), 'footerHtmlOptions' => array('style' => 'text-align: right; padding-right: 5px;')), 'user_remark'))); ?> <?php $this->widget('bootstrap.widgets.BootDetailView', array('data' => uJournal::model()->findByPk((int) $id), 'attributes' => array(array('label' => 'Total', 'value' => Yii::app()->indoFormat->number(uJournal::model()->findByPk((int) $id)->journalSum)), array('label' => 'Check', 'value' => 'WARNING!!! NOT BALANCE... CONTACT DEVELOPER', 'visible' => uJournal::model()->findByPk((int) $id)->journalSum != uJournal::model()->findByPk((int) $id)->journalSumCek))));
public function actionUnposting($id) { $_curPeriod = Yii::app()->settings->get("System", "cCurrentPeriod"); $_lastPeriod = sParameter::cBeginDateBefore(Yii::app()->settings->get("System", "cCurrentPeriod")); $locked = uJournal::model()->updateByPk((int) $id, array('state_id' => 2, 'updated_date' => time(), 'updated_id' => Yii::app()->user->id)); $models = uJournalDetail::model()->with('journal')->findAll(array('condition' => 'parent_id =' . $id)); foreach ($models as $model) { $modelBalanceCurrent = tBalanceSheet::model()->find(array('condition' => 'parent_id =' . $model->account_no_id . ' AND yearmonth_periode = ' . $_curPeriod)); $_debit = $model->debit; $_credit = $model->credit; $_curdebit = $modelBalanceCurrent->debit - $_debit; $_curcredit = $modelBalanceCurrent->credit - $_credit; $_curbalance = $modelBalanceCurrent->end_balance; if ($model->account->getSideValue() == 1 || isset($model->account->reverse)) { //Asset, Expense $_endbalance = $_curbalance - $_debit + $_credit; } else { //Pasiva, Income $_endbalance = $_curbalance - $_credit + $_debit; } $command = Yii::app()->db->createCommand(' UPDATE t_balance_sheet SET debit = ' . $_curdebit . ', credit = ' . $_curcredit . ', end_balance = ' . $_endbalance . ' WHERE yearmonth_periode = ' . $_curPeriod . ' AND parent_id = ' . $model->account_no_id); $command->execute(); } }
public function actionUpdate($id) { $model = new fJournal(); $modelHeader = uJournal::model()->findByPk((int) $id); if ($modelHeader->state_id == 3 or $modelHeader->state_id == 4) { Yii::app()->user->setFlash("error", "<strong>Error!</strong> Journal cannot be edited. It has been posted/locked..."); $this->redirect(array('/m2/uJournal/view', 'id' => $modelHeader->id)); } //$this->performAjaxValidation($model); $_myDebit = 0; $_myCredit = 0; $model->balance = "NOT OK"; if (isset($_POST['account_no_id'])) { $model->attributes = $_POST['fJournal']; $model->account_no_id = $_POST['account_no_id']; $model->debit = $_POST['debit']; $model->credit = $_POST['credit']; $model->user_remark = $_POST['user_remark']; foreach ($model->debit as $_debit) { $_myDebit = $_myDebit + $_debit; } foreach ($model->credit as $_credit) { $_myCredit = $_myCredit + $_credit; } if ($_myDebit == $_myCredit && $_myDebit != 0 && $_myCredit != 0) { $model->balance = "OK"; } else { $model->balance = "NOT OK"; } if ($model->validate()) { $modelHeader->input_date = $_POST['fJournal']['input_date']; $modelHeader->yearmonth_periode = Yii::app()->settings->get("System", "cCurrentPeriod"); $modelHeader->remark = $_POST['fJournal']['remark']; $modelHeader->save(); $t = uJournalDetail::model()->deleteAll(array('condition' => 'parent_id = :id', 'params' => array(':id' => $id))); //delete All Journal $_tdebet = 0; $_tcredit = 0; for ($i = 0; $i < sizeof($model->account_no_id); ++$i) { $modelDetail = new uJournalDetail(); $modelDetail->parent_id = $modelHeader->id; $modelDetail->account_no_id = $model->account_no_id[$i]; if ($model->debit[$i] != null) { $modelDetail->debit = $model->debit[$i]; } else { $modelDetail->debit = 0; } if ($model->credit[$i] != null) { $modelDetail->credit = $model->credit[$i]; } else { $modelDetail->credit = 0; } $modelDetail->user_remark = $model->user_remark[$i]; $modelDetail->save(); } Yii::app()->user->setFlash("success", "<strong>Great!</strong> Journal updated succesfully..."); $this->redirect(array('/m2/uJournal/view', 'id' => $modelHeader->id)); //$this->redirect(array('/m2/uJournal')); } } if (!isset($_POST['account_no_id'])) { $model->input_date = $modelHeader->input_date; $model->yearmonth_periode = Yii::app()->settings->get("System", "cCurrentPeriod"); $model->remark = $modelHeader->remark; $model->system_ref = $modelHeader->system_ref; $model->master_id = $modelHeader->id; $modelDetail = uJournalDetail::model()->findAll(array('condition' => 'parent_id = :id', 'params' => array(':id' => $modelHeader->id))); foreach ($modelDetail as $mm) { $model->account_no_id[] = $mm->account_no_id; $model->debit[] = $mm->debit; $model->credit[] = $mm->credit; $model->user_remark[] = $mm->user_remark; } } $this->render('update', array('model' => $model)); }
<h2>Balance Sheet</h2> <?php $this->widget('bootstrap.widgets.BootGridView', array('id' => 't-account-balance-sum-grid', 'dataProvider' => tBalanceSheet::model()->search($model->id), 'template' => '{items}{pager}', 'itemsCssClass' => 'table table-striped table-bordered', 'columns' => array(array('name' => 'type_balance_id', 'value' => 'sParameter::item("cBalanceType",$data->type_balance_id)'), 'yearmonth_periode', array('name' => 'beginning_balance', 'value' => 'Yii::app()->indoFormat->number($data->beginning_balance)', 'htmlOptions' => array('style' => 'text-align: right; padding-right: 5px;')), array('name' => 'debit', 'value' => 'Yii::app()->indoFormat->number($data->debit)', 'htmlOptions' => array('style' => 'text-align: right; padding-right: 5px;')), array('name' => 'credit', 'value' => 'Yii::app()->indoFormat->number($data->credit)', 'htmlOptions' => array('style' => 'text-align: right; padding-right: 5px;')), array('name' => 'end_balance', 'value' => 'Yii::app()->indoFormat->number($data->end_balance)', 'htmlOptions' => array('style' => 'text-align: right; padding-right: 5px;'))))); ?> <br> <h2> Current Period Journal List: <?php echo Yii::app()->settings->get("System", "cCurrentPeriod"); ?> </h2> <?php $this->widget('bootstrap.widgets.BootGridView', array('id' => 't-account-balance-grid', 'dataProvider' => uJournalDetail::model()->searchByAccount($model->id), 'template' => '{items}{pager}{summary}', 'itemsCssClass' => 'table table-striped table-bordered', 'columns' => array(array('class' => 'BootButtonColumn', 'template' => '{post}', 'buttons' => array('post' => array('label' => '<i class="icon-ok-sign"></i> Post', 'url' => ' Yii::app()->createUrl("/m2/tPosting/posting", array("id"=>$data->journal->id)) ', 'visible' => '$data->journal->state_id ==1 || $data->journal->state_id ==2', 'click' => ' function(){ $.ajax({ type : "get", url : $(this).attr("href"), data: "", success : function(r){ $("#mydialog").dialog("open"); setTimeout(\'$("#mydialog").dialog("close") \',1200); } }) $.fn.yiiGridView.update("t-account-balance-grid", {
protected function afterDelete() { $log = new zArLog(); $log->description = 'User ' . Yii::app()->user->Name . ' deleted ' . get_class($this->Owner) . '[' . $this->system_ref . '].'; $log->action = 'DELETE'; $log->model = get_class($this->Owner); $log->idModel = $this->Owner->getPrimaryKey(); $log->field = ''; $log->creationdate = new CDbExpression('NOW()'); $log->userid = Yii::app()->user->id; $log->save(); uJournalDetail::model()->deleteAll('parent_id = ' . $this->id); return true; }
public function actionUpdate($id) { $model = new fJournal(); $modelHeader = uJournal::model()->findByPk((int) $id); if ($modelHeader->state_id == 3 or $modelHeader->state_id == 4) { Yii::app()->user->setFlash("error", "<strong>Error!</strong> Journal cannot be edited. It has been posted/locked..."); $this->redirect(array('/mCashbank/view', 'id' => $modelHeader->id)); } //$this->performAjaxValidation($model); $_myDebit = 0; $_myCredit = 0; $model->balance = "NOT OK"; if (isset($_POST['account_no_id'])) { $model->attributes = $_POST['fJournal']; $model->validate(); if (isset($_POST['fJournal']['cb_receiver'])) { //Expense $model->input_date = $_POST['fJournal']['input_date']; $model->yearmonth_periode = Yii::app()->settings->get("System", "cCurrentPeriod"); $model->remark = $_POST['fJournal']['remark']; $model->var_account = $_POST['fJournal']['var_account']; $model->account_no_id = $_POST['account_no_id']; $model->debit = $_POST['debit']; $model->credit = $_POST['credit']; $model->user_remark = $_POST['user_remark']; foreach ($model->debit as $_debit) { $_myDebit = $_myDebit + $_debit; } foreach ($model->credit as $_credit) { $_myCredit = $_myCredit + $_credit; } $_myBalance = $_myDebit - $_myCredit; $model->balance = "OK"; if ($model->validate()) { $modelHeader->input_date = $_POST['fJournal']['input_date']; $modelHeader->yearmonth_periode = Yii::app()->settings->get("System", "cCurrentPeriod"); $modelHeader->remark = $_POST['fJournal']['remark']; $modelHeader->user_ref = $_POST['fJournal']['cb_receiver']; $modelHeader->save(); $t = uJournalDetail::model()->deleteAll('parent_id = ' . $id); //delete All Journal Detail $_tdebet = 0; $_tcredit = 0; for ($i = 0; $i < sizeof($model->account_no_id); ++$i) { $modelDetail = new uJournalDetail(); $modelDetail->parent_id = $modelHeader->id; $modelDetail->account_no_id = $model->account_no_id[$i]; if ($model->debit[$i] != null) { $modelDetail->debit = $model->debit[$i]; } else { $modelDetail->debit = 0; } if ($model->credit[$i] != null) { $modelDetail->credit = $model->credit[$i]; } else { $modelDetail->credit = 0; } $modelDetail->user_remark = $model->user_remark[$i]; $modelDetail->save(); } $modelDetail = new uJournalDetail(); $modelDetail->parent_id = $modelHeader->id; $modelDetail->account_no_id = $_POST['fJournal']['var_account']; $modelDetail->debit = 0; $modelDetail->credit = $_myBalance; $modelDetail->system_remark = "Automated by System"; $modelDetail->user_remark = $model->user_remark[0]; $modelDetail->save(); //Create System_ref $_ref = "CB-" . $modelDetail->account->cashbank->mtext . "-" . $modelHeader->yearmonth_periode . "-EXP-" . str_pad($modelHeader->id, 5, "0", STR_PAD_LEFT); $modelHeader->updateByPk((int) $modelHeader->id, array('system_ref' => $_ref)); Yii::app()->user->setFlash("success", "<strong>Great!</strong> Journal updated succesfully..."); $this->redirect(array('/mCashbank/view', 'id' => $modelHeader->id)); //$this->redirect(array('/mCashbank')); } $this->render('create', array('model' => $model)); Yii::app()->end(); } else { //Income $model->input_date = $_POST['fJournal']['input_date']; $model->yearmonth_periode = Yii::app()->settings->get("System", "cCurrentPeriod"); $model->remark = $_POST['fJournal']['remark']; $model->var_account = $_POST['fJournal']['var_account']; $model->account_no_id = $_POST['account_no_id']; $model->debit = $_POST['debit']; $model->credit = $_POST['credit']; $model->user_remark = $_POST['user_remark']; foreach ($model->debit as $_debit) { $_myDebit = $_myDebit + $_debit; } foreach ($model->credit as $_credit) { $_myCredit = $_myCredit + $_credit; } $_myBalance = $_myCredit - $_myDebit; $model->balance = "OK"; if ($model->validate()) { $modelHeader->input_date = $_POST['fJournal']['input_date']; $modelHeader->yearmonth_periode = Yii::app()->settings->get("System", "cCurrentPeriod"); $modelHeader->remark = $_POST['fJournal']['remark']; $modelHeader->user_ref = $_POST['fJournal']['cb_received_from']; $modelHeader->save(); $t = uJournalDetail::model()->deleteAll('parent_id = ' . $id); //delete All Journal $modelDetail = new uJournalDetail(); $modelDetail->parent_id = $modelHeader->id; $modelDetail->account_no_id = $_POST['fJournal']['var_account']; $modelDetail->debit = $_myBalance; $modelDetail->credit = 0; $modelDetail->system_remark = "Automated by System"; $modelDetail->user_remark = $model->user_remark[0]; $modelDetail->save(); //Create System_ref $_ref = "CB-" . $modelDetail->account->cashbank->mtext . "-" . $modelHeader->yearmonth_periode . "-INC-" . str_pad($modelHeader->id, 5, "0", STR_PAD_LEFT); $modelHeader->updateByPk((int) $modelHeader->id, array('system_ref' => $_ref)); $_tdebet = 0; $_tcredit = 0; for ($i = 0; $i < sizeof($model->account_no_id); ++$i) { $modelDetail = new uJournalDetail(); $modelDetail->parent_id = $modelHeader->id; $modelDetail->account_no_id = $model->account_no_id[$i]; if ($model->debit[$i] != null) { $modelDetail->debit = $model->debit[$i]; } else { $modelDetail->debit = 0; } if ($model->credit[$i] != null) { $modelDetail->credit = $model->credit[$i]; } else { $modelDetail->credit = 0; } $modelDetail->user_remark = $model->user_remark[$i]; $modelDetail->save(); } $this->redirect(array('/mCashbank')); } $this->render('create', array('model' => $model)); Yii::app()->end(); } } if (!isset($_POST['account_no_id'])) { $model->input_date = $modelHeader->input_date; $model->yearmonth_periode = $modelHeader->yearmonth_periode; $model->remark = $modelHeader->remark; $model->system_ref = $modelHeader->system_ref; $model->master_id = $modelHeader->id; $modelDetail = uJournalDetail::model()->findAll('parent_id =' . $modelHeader->id); foreach ($modelDetail as $mm) { //if ($model->journal_type_id ==1) { *TODO* PENGECEKAN BALANCE NOT BY REMARKS BUT MY JOURNAL_TYPE_ID if ($mm->system_remark != "Automated by System") { $model->account_no_id[] = $mm->account_no_id; $model->debit[] = $mm->debit; $model->credit[] = $mm->credit; $model->user_remark[] = $mm->user_remark; } else { $model->var_account = $mm->account_no_id; if ($mm->debit != 0) { //Income $model->cb_received_from = $modelHeader->user_ref; } else { $model->cb_receiver = $modelHeader->user_ref; } } } } $this->render('update', array('model' => $model)); }
function report($id) { $this->SetFont('Arial', 'B', 12); $this->Cell(0, 8, 'JOURNAL VOUCHER', '', 0, 'C'); $this->Ln(8); $model = uJournal::model()->findByPk((int) $id); //Header $this->SetFont('Arial', '', 10); $this->Cell(25, 4, 'Voucher No.'); $this->SetFont('Arial', 'B', 10); $this->Cell(50, 4, ': ' . $model->system_ref); $this->Ln(); $this->SetFont('Arial', '', 10); $this->Cell(25, 4, 'Date'); $this->SetFont('Arial', 'B', 10); $this->Cell(60, 4, ': ' . $model->input_date); $this->Ln(); $this->SetFont('Arial', '', 10); $this->Cell(25, 4, 'Periode'); $this->SetFont('Arial', 'B', 10); $this->Cell(60, 4, ': ' . $model->yearmonth_periode); $this->Ln(4); $this->SetFont('Arial', '', 10); $this->Cell(25, 4, 'Description'); $this->Cell(60, 4, ': ' . $model->remark); $this->Ln(6); $w = array(70, 25, 25, 70); //Header $this->SetFont('Arial', 'B', 10); $this->Cell($w[0], 9, 'Account Name', 'LTBR', 0, 'C'); $this->Cell($w[1], 9, 'Debit', 'TBR', 0, 'C'); $this->Cell($w[2], 9, 'Credit', 'TBR', 0, 'C'); $this->Cell($w[3], 9, 'Remark', 'TBR', 0, 'C'); $this->Ln(); $modelD = uJournalDetail::model()->findAll('parent_id = ' . (int) $id); //Detail foreach ($modelD as $mod) { $this->SetFont('Arial', '', 10); $this->Cell($w[0], 5, $mod->account->account_no . ". " . $mod->account->account_name, 'LR'); $this->Cell($w[1], 5, number_format($mod->debit, 0, ',', '.'), 'LR', 0, 'R'); $this->Cell($w[2], 5, number_format($mod->credit, 0, ',', '.'), 'R', 0, 'R'); $this->Cell($w[3], 5, $mod->user_remark, 'R'); $this->Ln(); } $this->SetFont('Arial', 'B', 10); $this->Cell($w[0], 6, 'TOTAL', 'TLR', 0, 'R'); $this->Cell($w[1], 6, number_format($model->journalSum, 0, ',', '.'), 'TLR', 0, 'R'); $this->Cell($w[2], 6, number_format($model->journalSum, 0, ',', '.'), 'TR', 0, 'R'); $this->Cell($w[3], 6, '', 'TR'); $this->Ln(); //Closure line $this->Cell(array_sum($w), 0, '', 'T'); $this->Ln(2); $bilangan = new terbilang(); $this->SetFont('Arial', 'B', 10); $this->Cell(0, 4, 'Say: ' . $bilangan->eja($model->journalSum) . "Rupiah"); $this->Ln(10); $w = array(63, 63, 63); $this->SetFont('Arial', '', 10); $this->Cell($w[0], 6, 'Created By', 'LTR', 0, 'C'); $this->Cell($w[1], 6, 'Approved By', 'TR', 0, 'C'); $this->Cell($w[2], 6, 'Receiver', 'TR', 0, 'C'); $this->Ln(); $this->Cell($w[0], 18, '', 'LR'); $this->Cell($w[1], 18, '', 'R'); $this->Cell($w[2], 18, '', 'R'); $this->Ln(); $this->Cell($w[1], 6, '', 'LBR', 0, 'C'); $this->Cell($w[1], 6, '', 'BR', 0, 'C'); $this->Cell($w[2], 6, $model->user_ref, 'RB', 0, 'C'); $this->Ln(5); $this->SetFont('Arial', '', 10); $this->Cell($w[0], 6, '', 'LBR'); $this->Cell($w[1], 6, '', 'BR', 0, 'C'); $this->Cell($w[2], 6, '', 'BR', 0, 'C'); $this->Ln(); }
function report($acc_id, $begin_date, $end_date) { $this->myHeader($acc_id, $begin_date, $end_date); $criteria = new CDbCriteria(); $criteria->with = array('journalDetail'); $criteria->group = 't.id, module_id, input_date, yearmonth_periode, system_ref, state_id'; $criteria->join = 'INNER JOIN u_journal_detail tt ON t.id = tt.parent_id'; $criteria->compare('tt.account_no_id', $acc_id); $criteria->addBetweenCondition('input_date', Yii::app()->dateFormatter->format('yyyy-MM-dd', $begin_date), Yii::app()->dateFormatter->format('yyyy-MM-dd', $end_date)); $models = uJournal::model()->findAll($criteria); foreach ($models as $model) { //Header $this->SetFont('Arial', '', 10); $this->Cell(25, 4, 'Voucher No.'); $this->SetFont('Arial', 'B', 10); $this->Cell(50, 4, ': ' . $model->system_ref); $this->Ln(); $this->SetFont('Arial', '', 10); $this->Cell(25, 4, 'Date'); $this->SetFont('Arial', 'B', 10); $this->Cell(60, 4, ': ' . $model->input_date); $this->Ln(); $this->SetFont('Arial', '', 10); $this->Cell(25, 4, 'Periode'); $this->SetFont('Arial', 'B', 10); $this->Cell(60, 4, ': ' . $model->yearmonth_periode); $this->Ln(4); $this->SetFont('Arial', '', 10); $this->Cell(25, 4, 'Description'); $this->Cell(60, 4, ': ' . $model->remark); $this->Ln(6); $w = array(70, 25, 25, 70); //Header $this->SetFont('Arial', 'B', 10); $this->Cell($w[0], 9, 'Account Name', 'LTBR', 0, 'C'); $this->Cell($w[1], 9, 'Debit', 'TBR', 0, 'C'); $this->Cell($w[2], 9, 'Credit', 'TBR', 0, 'C'); $this->Cell($w[3], 9, 'Remark', 'TBR', 0, 'C'); $this->Ln(); $modeld = uJournalDetail::model()->findAll('parent_id = ' . $model->id); foreach ($modeld as $mod) { $this->SetFont('Arial', '', 10); $this->Cell($w[0], 5, $mod->account->account_concat(), 'LR'); $this->Cell($w[1], 5, number_format($mod->debit, 0, ',', '.'), 'LR', 0, 'R'); $this->Cell($w[2], 5, number_format($mod->credit, 0, ',', '.'), 'R', 0, 'R'); $this->Cell($w[3], 5, $mod->user_remark, 'R'); $this->Ln(); } $this->SetFont('Arial', 'B', 10); $this->Cell($w[0], 6, 'TOTAL', 'TLR', 0, 'R'); $this->Cell($w[1], 6, number_format($model->journalSum, 0, ',', '.'), 'TLR', 0, 'R'); $this->Cell($w[2], 6, number_format($model->journalSum, 0, ',', '.'), 'TR', 0, 'R'); $this->Cell($w[3], 6, '', 'TR'); $this->Ln(); $this->Cell(array_sum($w), 6, '', 'T'); $this->Ln(8); if ($this->GetY() >= 215) { $this->AddPage(); $this->myHeader($acc_id, $begin_date, $end_date); } } }
public function actionUnposting($id) { $_curPeriod = Yii::app()->settings->get("System", "cCurrentPeriod"); $_lastPeriod = sParameter::cBeginDateBefore(Yii::app()->settings->get("System", "cCurrentPeriod")); $locked = uJournal::model()->updateByPk((int) $id, array('state_id' => 2, 'updated_date' => time(), 'updated_by' => Yii::app()->user->id)); $models = uJournalDetail::model()->with('journal')->findAll(array('condition' => 'parent_id = :id', 'params' => array(':id' => $id))); foreach ($models as $model) { $modelBalanceCurrent = tBalanceSheet::model()->find(array('condition' => 'parent_id = :accid AND yearmonth_periode = :period', 'params' => array(':accid' => $model->account_no_id, ':period' => $_curPeriod))); $_debit = $model->debit; $_credit = $model->credit; $_endbalance = 0; $_curdebit = $modelBalanceCurrent->debit - $_debit; $_curcredit = $modelBalanceCurrent->credit - $_credit; $_curbalance = $modelBalanceCurrent->end_balance; if ($model->account->getSideValue() == 1 || isset($model->account->reverse)) { //Asset, Expense $_endbalance = $_curbalance - $_debit + $_credit; } else { //Pasiva, Income $_endbalance = $_curbalance - $_credit + $_debit; } $command = Yii::app()->db->createCommand(' UPDATE t_balance_sheet SET debit = ' . $_curdebit . ', credit = ' . $_curcredit . ', end_balance = ' . $_endbalance . ' WHERE yearmonth_periode = ' . $_curPeriod . ' AND parent_id = ' . $model->account_no_id); $command->execute(); //LOG $commandLog = Yii::app()->db->createCommand(' INSERT INTO t_balance_sheet_log (journal_id, yearmonth_periode, type_balance_id, remark, budget, account_no_id, beginning_balance,debit,credit,end_balance) VALUES (' . $model->parent_id . ',' . $_curPeriod . ', 1, \'UNPOSTING LOG\', 0,' . $model->account_no_id . ',' . $_curbalance . ',' . $_debit . ',' . $_credit . ',' . $_endbalance . ') '); $commandLog->execute(); } }