function myHeader($acc_id, $begin_date, $end_date) { $this->y0 = $this->GetY(); //$this->Image('css/LOGO.jpg',15,7,30); $this->SetY($this->y0); $this->SetFont('Arial', 'B', 12); $this->Cell(0, 5, Yii::app()->name, 0, 0, 'R'); $this->Ln(); $this->Cell(190, 0, '', 'B'); $this->Ln(); $this->SetFont('Arial', 'B', 12); $this->Cell(0, 8, 'JOURNAL VOUCHER LIST', '', 0, 'C'); $this->Ln(); $this->Cell(190, 0, '', 'B'); $this->Ln(); $this->SetFont('Arial', '', 10); $this->Cell(25, 4, 'Account No', 'L'); $this->SetFont('Arial', 'B', 10); $this->Cell(0, 4, ': ' . tAccount::model()->findByPk($acc_id)->account_concat(), 'R'); $this->Ln(); $this->SetFont('Arial', '', 10); $this->Cell(25, 4, 'Periode: ', 'L'); $this->SetFont('Arial', 'B', 10); $this->Cell(0, 4, ': ' . $begin_date . " to " . $end_date, 'R'); $this->Ln(); $this->Cell(190, 0, '', 'B'); $this->Ln(8); }
$results = $index->find($term); $query = Zend_Search_Lucene_Search_QueryParser::parse($term); $this->render('/sParameter/search', compact('results', 'term', 'query')); } } /** * Search index creation */ public function actionCreate() { $index = new Zend_Search_Lucene(Yii::getPathOfAlias('application.' . $this->_indexFiles), true); $posts = tAccount::model()->findAll(); foreach ($posts as $post) { $doc = new Zend_Search_Lucene_Document(); $doc->addField(Zend_Search_Lucene_Field::Text('account_no', CHtml::encode($post->account_no), 'utf-8'));
function myHeader($acc_id, $begin_date, $end_date) { $this->y0 = $this->GetY(); //$this->Image('css/LOGO.jpg',15,7,30); $this->SetY($this->y0); $this->SetFont('Arial', 'B', 12); $this->Cell(0, 5, Yii::app()->name, 0, 0, 'R'); $this->Ln(); $this->Cell(190, 0, '', 'B'); $this->Ln(); $this->SetFont('Arial', 'B', 12); $this->Cell(0, 8, 'JOURNAL VOUCHER LIST', '', 0, 'C'); $this->Ln(); $this->Cell(190, 0, '', 'B'); $this->Ln(); $this->SetFont('Arial', '', 10); $this->Cell(25, 4, 'Account No', 'L'); $this->SetFont('Arial', 'B', 10); $this->Cell(0, 4, ': ' . tAccount::model()->findByPk($acc_id)->account_concat(), 'R'); $this->Ln(); $this->SetFont('Arial', '', 10); $this->Cell(25, 4, 'Periode: ', 'L'); $this->SetFont('Arial', 'B', 10); $this->Cell(0, 4, ': ' . $begin_date . " to " . $end_date, 'R'); $this->Ln(); $this->Cell(190, 0, '', 'B'); $this->Ln(8); $w = array(7, 18, 14, 33, 18, 18, 70, 15); //Header $this->SetFont('Arial', '', 8); $this->Cell($w[0], 8, 'No.', 1, 0, 'R'); $this->Cell($w[1], 8, 'Date', 1); $this->Cell($w[2], 8, 'Period', 1); $this->Cell($w[3], 8, 'No. Ref', 1); $this->Cell($w[4], 8, 'Debit', 1); $this->Cell($w[5], 8, 'Credit', 1); $this->Cell($w[6], 8, 'User Remark', 1); $this->Cell($w[7], 8, 'Status', 1); $this->Ln(); $this->Cell(array_sum($w), 1, '', 'TB'); $this->Ln(1); }
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(); }
function report($periode_date, $report_id) { $this->myheader($periode_date, $report_id); $w = array(100, 20); $_s = 5; $_subtotal = 0; $criteria = new CDbCriteria(); $criteria->with = array('cashbank', 'entity'); $criteria->order = 'account_no'; $models = tAccount::model()->findAll($criteria); $this->SetFont('Arial', 'B', 8); $this->Cell($w[0], 4, 'Account Cash Bank, Beginning Balance'); $this->SetX($this->x0); $this->Ln(); foreach ($models as $model) { $this->SetFont('Arial', '', 8); $this->Cell($_s, 4, ''); $this->Cell($w[0], 4, $model->account_concat()); $this->SetX($this->x0); $_model = $model->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date)); if (isset($_model->end_balance)) { $_balance = number_format($_model->end_balance, 0, ',', '.'); $_subtotal = $_subtotal + $_model->end_balance; } else { $_balance = 0; } $this->Cell($w[1], 4, $_balance, 0, 0, 'R'); $this->Ln(); } $this->SetFont('Arial', 'B', 8); //$this->Cell($_s,4,''); $this->Cell($w[0], 4, 'TOTAL ' . $model->account_name); $this->SetX($this->x0); $this->Cell($w[1], 4, number_format($_subtotal, 0, ',', '.'), 'T', 0, 'R'); $this->Ln(5); $model = $this->penerimaan(); }
<?php $this->breadcrumbs = array('Chart of Accounts' => array('index'), 'Create'); $this->menu = array(array('label' => 'Home', 'url' => array('index'))); $this->menu1 = tAccount::getTopUpdated(); $this->menu2 = tAccount::getTopCreated(); ?> <div class="page-header"> <h1>Create New Root Account</h1> </div> <?php echo $this->renderPartial('_formroot', array('model' => $model));
'options'=>array('icons'=>'js:{secondary:"ui-icon-extlink"}'), )); ?> </p> <br/> */ ?> <?php $this->widget('DropDownRedirect', array('data' => tAccount::accountDetail(), 'url' => $this->createUrl($this->route, array_merge($_GET, array('acc' => '__value__'))), 'select' => isset($_GET['acc']) ? $_GET['acc'] : "ALL")); echo CHtml::link('Refresh', $this->createUrl($this->route, $_GET)); ?> <br /> <?php if (isset($_GET['acc'])) { if ($_GET['acc'] != null) { echo "<b><p style='display: block;margin: 5px 0;padding: 2px;background-color: yellow;'>"; echo "Current Filter : " . tAccount::model()->findByPk((int) $_GET['acc'])->account_name; echo "</p></b>"; echo "</br>"; } } ?> </b> <?php $this->widget('zii.widgets.CListView', array('dataProvider' => $dataProvider, 'template' => '{items}', 'itemView' => '_view')); ?>
?> </td> <td><?php echo CHtml::textField('user_remark[]', '', array()); ?> </td> </tr> <?php } else { ?> <?php for ($i = 0; $i < sizeof($model->account_no_id); ++$i) { ?> <tr> <td><?php echo CHtml::dropDownList('account_no_id[]', $model->account_no_id[$i], tAccount::item(), array()); ?> </td> <td><?php echo CHtml::textField('debit[]', $model->debit[$i], array()); ?> </td> <td><?php echo CHtml::textField('credit[]', $model->credit[$i], array()); ?> </td> <td><?php echo CHtml::textField('user_remark[]', $model->user_remark[$i], array()); ?> </td> </tr>
?> Print List Journal </h1> </div> <?php $form = $this->beginWidget('BootActiveForm', array('id' => 'allocation-form', 'type' => 'horizontal', 'enableAjaxValidation' => false)); ?> <?php echo $form->errorSummary($model); ?> <?php echo $form->dropDownListRow($model, 'account_no_id', tAccount::item()); ?> <?php echo $form->textFieldRow($model, 'begindate'); ?> <?php echo $form->textFieldRow($model, 'enddate'); ?> <?php /* $this->widget('ext.monthpicker.MonthPicker', array( 'model'=>$model, 'name'=>'begindate', ));
echo CHtml::image(Yii::app()->request->baseUrl . '/images/icon/bank.png'); ?> Cash and Bank </h1> </div> <?php $this->widget('DropDownRedirect', array('data' => tAccount::cashBankAccount("ALL"), 'url' => $this->createUrl($this->route, array_merge($_GET, array('pid' => '__value__'))), 'select' => isset($_GET['pid']) ? $_GET['pid'] : "(ALL)", 'htmlOptions' => array('class' => 'span4'))); ?> <?php if (isset($_GET['pid'])) { if ((int) $_GET['pid'] != 0) { echo "<b><p style='display: block;margin: 5px 0;padding: 2px;background-color: yellow;'>"; echo "Filter By: " . tAccount::model()->findByPk((int) $_GET['pid'])->account_name; echo "</p></b>"; } } ?> <div id="posts"> <?php foreach ($dataProvider as $data) { ?> <div class="post"> <?php echo $this->renderPartial('/uJournal/_view', array('data' => $data)); ?> </div> <?php
<li class="nav-header">Cash and Bank</li> </ul> <?php $this->widget('bootstrap.widgets.BootMenu', array('type' => 'list', 'items' => uJournal::getTopUpdated(2))); ?> <br /> <ul class="nav nav-list"> <li class="nav-header">PO (Unapproved)</li> </ul> <?php $this->widget('bootstrap.widgets.BootMenu', array('type' => 'list', 'items' => bPorder::getTopUnApprovedPO())); ?> <br /> <ul class="nav nav-list"> <li class="nav-header">PO (Unpaid)</li> </ul> <?php $this->widget('bootstrap.widgets.BootMenu', array('type' => 'list', 'items' => bPorder::getTopUnPaidPO())); ?> <br /> <ul class="nav nav-list"> <li class="nav-header">Chart Of Account</li> </ul> <?php $this->widget('bootstrap.widgets.BootMenu', array('type' => 'list', 'items' => tAccount::getTopUpdated())); ?> <br />
<?php $Hierarchy = tAccount::model()->findAll(array('condition' => 'parent_id = 0')); foreach ($Hierarchy as $Hierarchy) { $models = tAccount::model()->findByPk($Hierarchy->id); $items[] = $models->getTree(); } $this->beginWidget('CTreeView', array('id' => 'module-tree', 'url' => array('/tAccount/ajaxFillTree'))); $this->endWidget();
function report($periode_date, $report_id) { $this->myheader($periode_date, $report_id); $w = array(100, 20); $model1 = tAccountMain::model()->with('account_list')->findAll('type_id= 2'); $_s = 3; //Reset $_total = 0; $_subtotal = 0; $_grandtotal = 0; $_grandtotalI = 0; $_grandtotalH = 0; $_grandtotalE = 0; $_totalLast = 0; $_subtotalLast = 0; $_grandtotalLast = 0; $_grandtotalILast = 0; $_grandtotalHLast = 0; $_grandtotalELast = 0; //Print/Preview Report foreach ($model1 as $mmm) { foreach ($mmm->account_list as $mm) { $model2 = tAccount::model()->findByPk((int) $mm->parent_id); $this->SetFont('Arial', 'B', 8); if ($mmm->id == 2) { $this->Cell(5, 4, ''); } $this->Cell($w[0], 4, $model2->account_concat()); $this->SetX($this->x0); $this->Cell($w[1], 4, ''); $this->Ln(); foreach ($model2->childs as $model) { if ($model->childs) { $this->SetFont('Arial', 'B', 8); } else { $this->SetFont('Arial', '', 8); } $this->Cell($_s, 4, ''); $this->Cell($w[0], 4, $model->account_concat()); $this->SetX($this->x0); $_model = $model->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date)); $_periode_date_last = sParameter::cBeginDateBefore($periode_date); $_modelLast = $model->balancesheet(array('condition' => 'yearmonth_periode =' . $_periode_date_last)); if (isset($_model->end_balance)) { $_balance = number_format($_model->end_balance, 0, ',', '.'); $_mmodelLast = isset($_modelLast->end_balance) ? $_modelLast->end_balance : 0; $_balanceLast = number_format($_mmodelLast, 0, ',', '.'); $_subtotal = $_subtotal + $_model->end_balance; $_grandtotal = $_grandtotal + $_model->end_balance; $_subtotalLast = $_subtotalLast + $_mmodelLast; $_grandtotalLast = $_grandtotalLast + $_mmodelLast; } else { $_balance = 0; $_balanceLast = 0; } if ($model->childs) { $this->Cell($w[1], 4, '', 0, 0, 'R'); } else { $this->Cell($w[1], 4, $_balance, 0, 0, 'R'); $this->Cell($w[1] + 20, 4, $_balanceLast, 0, 0, 'R'); } $this->Ln(); if ($model->childs) { foreach ($model->childs as $mod) { if ($mod->childs) { $this->SetFont('Arial', 'B', 8); } else { $this->SetFont('Arial', '', 8); } $this->Cell($_s + 3, 4, ''); $this->Cell($w[0], 4, $mod->account_concat()); $this->SetX($this->x0); $_mod = $mod->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date)); $_modLast = $mod->balancesheet(array('condition' => 'yearmonth_periode =' . $_periode_date_last)); if (isset($_mod->end_balance)) { $_balance = number_format($_mod->end_balance, 0, ',', '.'); $_mmodLast = isset($_modLast->end_balance) ? $_modLast->end_balance : 0; $_balanceLast = number_format($_mmodLast, 0, ',', '.'); $_subtotal = $_subtotal + $_mod->end_balance; $_grandtotal = $_grandtotal + $_mod->end_balance; $_subtotalLast = $_subtotalLast + $_mmodLast; $_grandtotalLast = $_grandtotalLast + $_mmodLast; } else { $_balance = 0; $_balanceLast = 0; } if ($mod->childs) { $this->Cell($w[1], 4, '', 0, 0, 'R'); } else { $this->Cell($w[1], 4, $_balance, 0, 0, 'R'); $this->Cell($w[1] + 20, 4, $_balanceLast, 0, 0, 'R'); } $this->Ln(); if ($mod->childs) { foreach ($mod->childs as $m) { $this->SetFont('Arial', '', 8); $this->Cell($_s + 10, 4, ''); $this->Cell($w[0], 4, $m->account_concat()); $this->SetX($this->x0); $_m = $m->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date)); $_mLast = $m->balancesheet(array('condition' => 'yearmonth_periode =' . $_periode_date_last)); $_mmLast = isset($_mLast->end_balance) ? $_mLast->end_balance : 0; if (isset($_m->end_balance)) { $_balance = number_format($_m->end_balance, 0, ',', '.'); $_balanceLast = number_format($_mmLast, 0, ',', '.'); $_total = $_total + $_m->end_balance; $_subtotal = $_subtotal + $_m->end_balance; $_grandtotal = $_grandtotal + $_m->end_balance; $_totalLast = $_totalLast + $_mmLast; $_subtotalLast = $_subtotalLast + $_mmLast; $_grandtotalLast = $_grandtotalLast + $_mmLast; } else { $_balance = 0; $_balanceLast = 0; } if ($m->childs) { $this->Cell($w[1], 4, '', 0, 0, 'R'); } else { $this->Cell($w[1], 4, $_balance, 0, 0, 'R'); $this->Cell($w[1] + 20, 4, $_balanceLast, 0, 0, 'R'); } $this->Ln(); } } if ($mod->childs) { $this->SetFont('Arial', 'B', 8); $this->Cell($_s + 3, 4, ''); $this->Cell($w[0], 4, 'TOTAL ' . $mod->account_name); $this->SetX($this->x0); $this->Cell($w[1], 4, number_format($_total, 0, ',', '.'), 'T', 0, 'R'); $this->Cell($w[1], 4, '', ''); $this->Cell($w[1], 4, number_format($_totalLast, 0, ',', '.'), 'T', 0, 'R'); $this->Ln(5); $_total = 0; $_totalLast = 0; if ($this->GetY() >= 250) { $this->AddPage(); $this->myheader($periode_date, $report_id); } } } } if ($model->childs && $model->childsCount >= 2) { $this->SetFont('Arial', 'B', 8); $this->Cell($_s, 4, ''); $this->Cell($w[0], 4, 'TOTAL ' . $model->account_name); $this->SetX($this->x0); $this->Cell($w[1], 4, number_format($_subtotal, 0, ',', '.'), 'T', 0, 'R'); $this->Cell($w[1], 4, '', 0); $this->Cell($w[1], 4, number_format($_subtotalLast, 0, ',', '.'), 'T', 0, 'R'); $this->Ln(5); } $_subtotal = 0; $_subtotalLast = 0; if ($this->GetY() >= 250) { $this->AddPage(); $this->myheader($periode_date, $report_id); } } $this->SetFont('Arial', 'B', 8); if ($mmm->id == 2) { $this->Cell(5, 4, ''); } $this->Cell($w[0], 4, 'TOTAL ' . $model2->account_name); $this->SetX($this->x0 + 20); $this->Cell($w[1], 4, number_format($_grandtotal, 0, ',', '.'), 0, 0, 'R'); $this->Cell($w[1] + 20, 4, number_format($_grandtotalLast, 0, ',', '.'), 0, 0, 'R'); $this->Cell($w[1], 4, ''); $this->Ln(8); if ($mmm->id == 3) { //income $_grandtotalI = $_grandtotal; $_grandtotalILast = $_grandtotalLast; } elseif ($mmm->id == 4) { //HPP $_grandtotalH = $_grandtotal; $_grossprofit = $_grandtotalI - $_grandtotalH; $_grandtotalHLast = $_grandtotalLast; $_grossprofitLast = $_grandtotalILast - $_grandtotalHLast; } else { //Expenses $_grandtotalE = $_grandtotal; $_netprofit = $_grossprofit - $_grandtotalE; $_grandtotalELast = $_grandtotalLast; $_netprofitLast = $_grossprofitLast - $_grandtotalELast; } $_grandtotal = 0; $_grandtotalLast = 0; } if ($mmm->id == 4) { //GROSS PROFIT //$_s=$_s+3; $this->SetFont('Arial', 'B', 8); $this->Cell(array_sum($w), 4, 'GROSS PROFIT', 'T'); $this->SetX($this->x0 + 20); $this->Cell($w[1], 4, number_format($_grossprofit, 0, ',', '.'), 'T', 0, 'R'); $this->Cell($w[1], 4, ''); $this->Cell($w[1], 4, number_format($_grossprofitLast, 0, ',', '.'), 'T', 0, 'R'); $this->Ln(8); } } $_s = $_s + 3; $this->SetFont('Arial', 'B', 8); $this->Cell(array_sum($w), 4, 'INCOME OPERATION', 'T'); $this->SetX($this->x0 + 20); $this->Cell($w[1], 4, number_format($_netprofit, 0, ',', '.'), 'T', 0, 'R'); $this->Cell($w[1] + 20, 4, number_format($_netprofitLast, 0, ',', '.'), 'T', 0, 'R'); $this->Ln(8); //Other Income and Other Expenses $model1 = tAccountMain::model()->with('account_list')->findAll('type_id= 3'); $_grandtotalOI = 0; $_grandtotalOE = 0; $_netprofitFinal = 0; $_grandtotalOILast = 0; $_grandtotalOELast = 0; $_netprofitFinalLast = 0; foreach ($model1 as $mmm) { foreach ($mmm->account_list as $mm) { $model2 = tAccount::model()->findByPk((int) $mm->parent_id); $this->SetFont('Arial', 'B', 8); if ($mmm->id == 2) { $this->Cell(5, 4, ''); } $this->Cell($w[0], 4, $model2->account_concat()); $this->SetX($this->x0); $this->Cell($w[1], 4, ''); $this->Ln(); foreach ($model2->childs as $model) { if ($model->childs) { $this->SetFont('Arial', 'B', 8); } else { $this->SetFont('Arial', '', 8); } $this->Cell($_s, 4, ''); $this->Cell($w[0], 4, $model->account_concat()); $this->SetX($this->x0); $_model = $model->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date)); $_periode_date_last = sParameter::cBeginDateBefore($periode_date); $_modelLast = $model->balancesheet(array('condition' => 'yearmonth_periode =' . $_periode_date_last)); if (isset($_model->end_balance)) { $_balance = number_format($_model->end_balance, 0, ',', '.'); $_mmodelLast = isset($_modelLast->end_balance) ? $_modelLast->end_balance : 0; $_balanceLast = number_format($_mmodelLast, 0, ',', '.'); $_subtotal = $_subtotal + $_model->end_balance; $_grandtotal = $_grandtotal + $_model->end_balance; $_subtotalLast = $_subtotalLast + $_mmodelLast; $_grandtotalLast = $_grandtotalLast + $_mmodelLast; } else { $_balance = 0; $_balanceLast = 0; } if ($model->childs) { $this->Cell($w[1], 4, '', 0, 0, 'R'); } else { $this->Cell($w[1], 4, $_balance, 0, 0, 'R'); $this->Cell($w[1] + 20, 4, $_balanceLast, 0, 0, 'R'); } $this->Ln(); if ($model->childs) { foreach ($model->childs as $mod) { if ($mod->childs) { $this->SetFont('Arial', 'B', 8); } else { $this->SetFont('Arial', '', 8); } $this->Cell($_s + 3, 4, ''); $this->Cell($w[0], 4, $mod->account_concat()); $this->SetX($this->x0); $_mod = $mod->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date)); $_modLast = $mod->balancesheet(array('condition' => 'yearmonth_periode =' . $_periode_date_last)); $_mmodLast = isset($_modLast->end_balance) ? $_modLast->end_balance : 0; if (isset($_mod->end_balance)) { if ($mod->reverse) { $_balanceR = -$_mod->end_balance; $_balanceRLast = -$_mmodLast; } else { $_balanceR = $_mod->end_balance; $_balanceRLast = $_mmodLast; } $_balance = number_format($_balanceR, 0, ',', '.'); $_subtotal = $_subtotal + $_balanceR; $_grandtotal = $_grandtotal + $_balanceR; $_balanceLast = number_format($_balanceRLast, 0, ',', '.'); $_subtotalLast = $_subtotalLast + $_balanceRLast; $_grandtotalLast = $_grandtotalLast + $_balanceRLast; } else { $_balance = 0; $_balanceLast = 0; } if ($mod->childs) { $this->Cell($w[1], 4, '', 0, 0, 'R'); } else { $this->Cell($w[1], 4, $_balance, 0, 0, 'R'); $this->Cell($w[1] + 20, 4, $_balanceLast, 0, 0, 'R'); } $this->Ln(); if ($mod->childs) { foreach ($mod->childs as $m) { $this->SetFont('Arial', '', 8); $this->Cell($_s + 10, 4, ''); $this->Cell($w[0], 4, $m->account_concat()); $this->SetX($this->x0); $_m = $m->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date)); $_mLast = $m->balancesheet(array('condition' => 'yearmonth_periode =' . $_periode_date_last)); $_mmLast = isset($_mLast->end_balance) ? $_mLast->end_balance : 0; if (isset($_m->end_balance)) { if ($mod->reverse) { $_balanceR = -$_m->end_balance; $_balanceRLast = -$_mmLast; } else { $_balanceR = $_m->end_balance; $_balanceRLast = $_mmLast; } $_balance = number_format($_balanceR, 0, ',', '.'); $_total = $_total + $_balanceR; $_subtotal = $_subtotal + $_balanceR; $_grandtotal = $_grandtotal + $_balanceR; $_balanceLast = number_format($_balanceRLast, 0, ',', '.'); $_totalLast = $_totalLast + $_balanceRLast; $_subtotalLast = $_subtotalLast + $_balanceRLast; $_grandtotalLast = $_grandtotalLast + $_balanceRLast; } else { $_balance = 0; $_balanceLast = 0; } if ($m->childs) { $this->Cell($w[1], 4, '', 0, 0, 'R'); } else { $this->Cell($w[1], 4, $_balance, 0, 0, 'R'); $this->Cell($w[1], 4, $_balanceLast, 0, 0, 'R'); } $this->Ln(); } } if ($mod->childs) { $this->SetFont('Arial', 'B', 8); $this->Cell($_s + 3, 4, ''); $this->Cell($w[0], 4, 'TOTAL ' . $mod->account_name); $this->SetX($this->x0); $this->Cell($w[1], 4, number_format($_total, 0, ',', '.'), 'T', 0, 'R'); $this->Cell($w[1], 4, '', 0); $this->Cell($w[1], 4, number_format($_totalLast, 0, ',', '.'), 'T', 0, 'R'); $this->Ln(5); $_total = 0; } } } if ($model->childs && $model->childsCount >= 2) { $this->SetFont('Arial', 'B', 8); $this->Cell($_s, 4, ''); $this->Cell($w[0], 4, 'TOTAL ' . $model->account_name); $this->SetX($this->x0); $this->Cell($w[1], 4, number_format($_subtotal, 0, ',', '.'), 'T', 0, 'R'); $this->Cell($w[1], 4, '', 0); $this->Cell($w[1], 4, number_format($_subtotalLast, 0, ',', '.'), 'T', 0, 'R'); $this->Ln(5); } if ($_grandtotalOI == 0) { //other Income $_grandtotalOI = $_subtotal; $_grandtotalOILast = $_subtotalLast; } else { //Expenses $_grandtotalOE = $_subtotal; $_grandtotalOELast = $_subtotalLast; } $_subtotal = 0; $_subtotalLast = 0; } $this->SetFont('Arial', 'B', 8); if ($mmm->id == 2) { $this->Cell(5, 4, ''); } $this->Cell($w[0], 4, 'TOTAL ' . $model2->account_name); $this->SetX($this->x0 + 20); $this->Cell($w[1], 4, number_format($_grandtotal, 0, ',', '.'), 0, 0, 'R'); $this->Cell($w[1], 4, ''); $this->Cell($w[1], 4, number_format($_grandtotalLast, 0, ',', '.'), 0, 0, 'R'); $this->Ln(8); $_grandtotalOIE = $_grandtotal; $_grandtotal = 0; $_grandtotalOIELast = $_grandtotalLast; $_grandtotalLast = 0; } $_netprofitFinal = $_netprofit + $_grandtotalOIE; $_netprofitFinalLast = $_netprofitLast + $_grandtotalOIELast; //$_s=$_s+3; $this->SetFont('Arial', 'B', 8); $this->Cell(array_sum($w), 4, 'NET INCOME', 'T'); $this->SetX($this->x0 + 20); $this->Cell($w[1], 4, number_format($_netprofitFinal, 0, ',', '.'), 'T', 0, 'R'); $this->Cell($w[1], 4, ''); $this->Cell($w[1], 4, number_format($_netprofitFinalLast, 0, ',', '.'), 'T', 0, 'R'); $this->Ln(8); } }
<li class="nav-header">Cash and Bank</li> </ul> <?php $this->widget('bootstrap.widgets.BootMenu', array('type' => 'list', 'items' => uJournal::getTopUpdated(2), 'htmlOptions' => array('style' => 'font-size:12px; '))); ?> <br /> <ul class="nav nav-list"> <li class="nav-header">PO (Unapproved)</li> </ul> <?php $this->widget('bootstrap.widgets.BootMenu', array('type' => 'list', 'items' => vPorder::getTopUnApprovedPO(), 'htmlOptions' => array('style' => 'font-size:12px; '))); ?> <br /> <ul class="nav nav-list"> <li class="nav-header">PO (Unpaid)</li> </ul> <?php $this->widget('bootstrap.widgets.BootMenu', array('type' => 'list', 'items' => vPorder::getTopUnPaidPO(), 'htmlOptions' => array('style' => 'font-size:12px; '))); ?> <br /> <ul class="nav nav-list"> <li class="nav-header">Chart Of Account</li> </ul> <?php $this->widget('bootstrap.widgets.BootMenu', array('type' => 'list', 'items' => tAccount::getTopUpdated(), 'htmlOptions' => array('style' => 'font-size:12px; '))); ?> <br />
?> </td> <td><?php echo CHtml::textField('amount[]', '', array('maxlength' => 15)); ?> </td> </tr> <?php } else { ?> <?php for ($i = 0; $i < sizeof($model->budget_id); ++$i) { ?> <tr> <td><?php echo CHtml::dropDownList('budget_id[]', $model->budget_id[$i], tAccount::item()); ?> </td> <td><?php echo CHtml::textField('description[]', $model->description[$i], array()); ?> </td> <td><?php echo CHtml::textField('qty[]', $model->qty[$i], array('maxlength' => 15)); ?> </td> <td><?php echo CHtml::textField('amount[]', $model->amount[$i], array('maxlength' => 15)); ?> </td> </tr>
?> <?php echo $form->dropDownListRow($model, 'haschild_id', sParameter::items("cHasChild"), array('disabled' => !empty($model->hasJournal), 'hint' => 'Dropdown will disabled automatically when this account already has journal voucher on current period')); echo $form->textFieldRow($model, 'account_no', array('class' => 'span3')); echo $form->textFieldRow($model, 'account_name', array('class' => 'span3')); echo $form->textAreaRow($model, 'short_description', array('class' => 'span5', 'rows' => 3)); //echo $form->dropDownListRow($model,'currency_id',sParameter::items("cCurrency","*inherited*")); //echo $form->dropDownListRow($model,'state_id',sParameter::items("cStatus","*inherited*")); ?> <?php $this->widget('ext.appendo.JAppendo', array('id' => 'repeateEnum', 'model' => $model, 'viewName' => '_accountProperties', 'labelDel' => 'Remove Row')); ?> <div class="form-actions"> <?php echo CHtml::htmlButton('<i class="icon-ok"></i>' . $model->isNewRecord ? 'Create' : 'Save', array('class' => 'btn', 'type' => 'submit')); ?> </div> <?php $this->endWidget(); ?> <hr /> <h3>Sibling Account</h3> <?php $this->widget('bootstrap.widgets.BootGridView', array('id' => 't-account-grid', 'dataProvider' => tAccount::model()->searchSibling($model->parent_id, $model->id), 'itemsCssClass' => 'table table-striped table-bordered', 'template' => '{items}{pager}', 'columns' => array(array('name' => 'account_no', 'type' => 'raw', 'value' => 'CHtml::link($data->account_no. ". ".$data->account_name,Yii::app()->createUrl("tAccount/view",array("id"=>$data->id)))'), array('name' => 'haschild_id', 'value' => 'isset($data->haschild) ? $data->haschild->childName->name : "Not Set"'), array('header' => 'Type Account', 'value' => '$data->getRoot()'), array('header' => 'Currency', 'value' => '$data->getCurrency()'), array('header' => 'Status', 'value' => '$data->getState()'))));
?> <div class="control-group"> <?php echo $form->labelEx($model, 'payment_date', array('class' => 'control-label')); ?> <div class="controls"> <?php $this->widget('zii.widgets.jui.CJuiDatePicker', array('model' => $model, 'value' => CTimestamp::formatDate('yyyy-MM-dd', $model->payment_date), 'attribute' => 'payment_date', 'options' => array('showAnim' => 'fold', 'dateFormat' => 'dd-mm-yy', 'minDate' => '-20', 'maxDate' => '+1M +10D'), 'htmlOptions' => array())); ?> </div> </div> <?php echo $form->dropDownListRow($model, 'payment_source_id', tAccount::cashbankAccount()); ?> <?php echo $form->dropDownListRow($model, 'payment_type_id', array('1' => 'Cash', '2' => 'Cheque/Giro')); ?> <?php echo $form->textAreaRow($model, 'description', array('rows' => 2, 'class' => 'span5')); ?> <?php echo $form->textFieldRow($model, 'amount', array('class' => 'span3')); ?> <div class="control-group">
public function actionJournalPayment() { if (isset($_POST['journal_id'])) { $total = 0; $m_ref = array(); foreach ($_POST['journal_id'] as $a => $val) { $model = vPorder::model()->findByPk((int) $val); $total = $total + $model->sum_po; $m_ref[] = $model->system_ref; if ($model->journal_state_id == 3) { Yii::app()->user->setFlash("error", "<strong>Error!</strong> This PO already journalled..."); $this->redirect(array('/m2/mAccpayable', 'id' => 3)); } else { vPorder::model()->updateByPk((int) $val, array('journal_state_id' => 3)); } } $modelHeader = new uJournal(); $modelHeader->input_date = Yii::app()->dateFormatter->format("dd-MM-yyyy", time()); $modelHeader->yearmonth_periode = Yii::app()->settings->get("System", "cCurrentPeriod"); $modelHeader->remark = implode($m_ref, " "); $modelHeader->entity_id = sUser::model()->getGroup(); //default group $modelHeader->module_id = 3; //AP $modelHeader->journal_type_id = 2; //Payment $modelHeader->state_id = 1; $modelHeader->created_by = Yii::app()->user->id; $modelHeader->created_date = time(); $modelHeader->save(); //Create System_ref $_ref = "AP-" . $modelHeader->yearmonth_periode . "-" . str_pad($modelHeader->id, 5, "0", STR_PAD_LEFT); $modelHeader->updateByPk((int) $modelHeader->id, array('system_ref' => $_ref)); $modelDetail = new uJournalDetail(); $modelDetail->parent_id = $modelHeader->id; $_inventory = tAccount::model()->with('hutang')->find('hutang.mvalue=1')->id; $modelDetail->account_no_id = $_inventory; $modelDetail->debit = $total; $modelDetail->credit = 0; $modelDetail->user_remark = implode($m_ref, " "); $modelDetail->save(); $modelPayment = vPorderPayment::model()->findAll('parent_id = ' . $model->id); foreach ($modelPayment as $payment) { $modelDetail = new uJournalDetail(); $modelDetail->parent_id = $modelHeader->id; $modelDetail->account_no_id = $payment->payment_source_id; $modelDetail->debit = 0; $modelDetail->credit = $payment->amount; $modelDetail->user_remark = implode($m_ref, " "); $modelDetail->save(); } //in case ada selisih if ($payment->amount != $total) { $modelDetail = new uJournalDetail(); $modelDetail->parent_id = $modelHeader->id; $_inventory = tAccount::model()->with('hutang')->find('hutang.mvalue=1')->id; $modelDetail->account_no_id = $_inventory; $modelDetail->debit = $payment->amount - $total; $modelDetail->credit = 0; $modelDetail->user_remark = 'Correction: ' . implode($m_ref, " "); $modelDetail->save(); } Yii::app()->user->setFlash("success", "<strong>Great!</strong> Payment Journal created succesfully..."); $this->render('viewJournal', array('model' => $modelHeader)); } else { $this->redirect(array('/m2/mAccpayable')); } }
public function netprofit($periode_date) { $model1 = tAccountMain::model()->with('account_list')->findAll('type_id= 2'); $_s = 5; //Reset $_total = 0; $_subtotal = 0; $_grandtotal = 0; $_grandtotalI = 0; $_grandtotalH = 0; $_grandtotalE = 0; foreach ($model1 as $mmm) { foreach ($mmm->account_list as $mm) { $model2 = tAccount::model()->findByPk((int) $mm->parent_id); foreach ($model2->childs as $model) { $_model = $model->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date)); if (isset($_model->end_balance)) { $_balance = number_format($_model->end_balance, 0, ',', '.'); $_subtotal = $_subtotal + $_model->end_balance; $_grandtotal = $_grandtotal + $_model->end_balance; } else { $_balance = 0; } if ($model->childs) { foreach ($model->childs as $mod) { $_mod = $mod->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date)); if (isset($_mod->end_balance)) { $_balance = number_format($_mod->end_balance, 0, ',', '.'); $_subtotal = $_subtotal + $_mod->end_balance; $_grandtotal = $_grandtotal + $_mod->end_balance; } else { $_balance = 0; } if ($mod->childs) { foreach ($mod->childs as $m) { $_m = $m->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date)); if (isset($_m->end_balance)) { $_balance = number_format($_m->end_balance, 0, ',', '.'); $_total = $_total + $_m->end_balance; $_subtotal = $_subtotal + $_m->end_balance; $_grandtotal = $_grandtotal + $_m->end_balance; } else { $_balance = 0; } } } if ($mod->childs) { $_total = 0; } } } $_subtotal = 0; } if ($mmm->id == 3) { //income $_grandtotalI = $_grandtotal; } elseif ($mmm->id == 4) { //HPP $_grandtotalH = $_grandtotal; $_grossprofit = $_grandtotalI - $_grandtotalH; } else { //Expenses $_grandtotalE = $_grandtotal; $_netprofit = $_grossprofit - $_grandtotalE; } $_grandtotal = 0; } } //Other Income and Other Expenses $model1 = tAccountMain::model()->with('account_list')->findAll('type_id= 3'); $_grandtotalOI = 0; $_grandtotalOE = 0; $_netprofitFinal = 0; foreach ($model1 as $mmm) { foreach ($mmm->account_list as $mm) { $model2 = tAccount::model()->findByPk((int) $mm->parent_id); foreach ($model2->childs as $model) { $_model = $model->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date)); if (isset($_model->end_balance)) { $_balance = number_format($_model->end_balance, 0, ',', '.'); $_subtotal = $_subtotal + $_model->end_balance; $_grandtotal = $_grandtotal + $_model->end_balance; } else { $_balance = 0; } if ($model->childs) { foreach ($model->childs as $mod) { $_mod = $mod->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date)); if (isset($_mod->end_balance)) { if ($mod->reverse) { $_balanceR = -$_mod->end_balance; } else { $_balanceR = $_mod->end_balance; } $_balance = number_format($_balanceR, 0, ',', '.'); $_subtotal = $_subtotal + $_balanceR; $_grandtotal = $_grandtotal + $_balanceR; } else { $_balance = 0; } if ($mod->childs) { foreach ($mod->childs as $m) { $_m = $m->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date)); if (isset($_m->end_balance)) { if ($mod->reverse) { $_balanceR = -$_m->end_balance; } else { $_balanceR = $_m->end_balance; } $_balance = number_format($_balanceR, 0, ',', '.'); $_total = $_total + $_balanceR; $_subtotal = $_subtotal + $_balanceR; $_grandtotal = $_grandtotal + $_balanceR; } else { $_balance = 0; } } } if ($mod->childs) { $_total = 0; } } } if ($_grandtotalOI == 0) { //other Income $_grandtotalOI = $_subtotal; } else { //Expenses $_grandtotalOE = $_subtotal; } $_subtotal = 0; } $_grandtotalOIE = $_grandtotal; $_grandtotal = 0; } $_netprofitFinal = $_netprofit + $_grandtotalOIE; } return $_netprofitFinal; }
<?php if (isset($model->getparent->getparent->getparent->account_name)) { $this->breadcrumbs = array($model->getparent->getparent->getparent->account_name => array('view', 'id' => $model->getparent->getparent->getparent->id), $model->getparent->getparent->account_name => array('view', 'id' => $model->getparent->getparent->id), $model->getparent->account_name => array('view', 'id' => $model->getparent->id), $model->account_name); } elseif (isset($model->getparent->getparent->account_name)) { $this->breadcrumbs = array($model->getparent->getparent->account_name => array('view', 'id' => $model->getparent->getparent->id), $model->getparent->account_name => array('view', 'id' => $model->getparent->id), $model->account_name); } elseif (isset($model->getparent->account_name)) { $this->breadcrumbs = array($model->getparent->account_name => array('view', 'id' => $model->getparent->id), $model->account_name); } else { $this->breadcrumbs = array($model->account_name); } $this->menu = array(array('label' => 'Home', 'icon' => 'home', 'url' => array('/m2/tAccount')), array('label' => 'Update', 'icon' => 'edit', 'url' => array('update', 'id' => $model->id)), array('label' => 'Delete', 'icon' => 'remove', 'url' => '#', 'linkOptions' => array('submit' => array('delete', 'id' => $model->id), 'confirm' => 'Are you sure you want to delete this item?'), 'visible' => empty($model->hasJournal))); $this->menu1 = tAccount::getTopUpdated(); $this->menu2 = tAccount::getTopCreated(); $this->menu3 = tAccount::getTopRelated($model->account_name); ?> <div class="page-header"> <h1> <?php echo CHtml::image(Yii::app()->request->baseUrl . '/images/icon/tree_diagramm_new.png'); ?> <?php echo $model->account_no . ". " . $model->account_name; ?> </h1> </div> <?php if ($model->haschild->mvalue == 2) { $this->widget('bootstrap.widgets.BootTabbable', array('type' => 'tabs', 'tabs' => array(array('label' => 'Detail', 'content' => $this->renderPartial("_tabDetail", array("model" => $model, "modelAccount" => $modelAccount), true), 'active' => true), array('label' => 'Entity', 'content' => $this->renderPartial("_tabEntity", array("model" => $model, 'modelEntity' => $modelEntity), true)), array('label' => 'Sub Account', 'content' => $this->renderPartial("_tabSub", array("model" => $model), true)), array('label' => 'Linked Module', 'content' => $this->renderPartial("_tabModule", array("model" => $model), true)))));
<?php $result = tAccount::model()->findAll(); $_oldvalue = 0; $_val = 0; echo '<ul>'; foreach ($result as $row) { if ($row->parent_id == $_oldvalue) { $_val = $_val + 1; echo '<li>' . $_val . " " . $row->account_name . '</li>'; } else { $_val = $_val - 1; echo '<li>' . $_val . " " . $row->account_name . '</li>'; } $_oldvalue = $row->id; } echo '</ul>';
<?php $this->breadcrumbs = array('Chart of Accounts'); $this->menu = array(array('label' => 'Home', 'url' => array('/tAccount')), array('label' => 'Create New Root Account', 'url' => array('create')), array('label' => 'Print List', 'url' => array('printList'))); $this->menu1 = tAccount::getTopUpdated(); //$this->menu2=tAccount::getTopCreated(); ?> <div class="pull-right"> <?php $this->renderPartial('_search', array('model' => $model)); ?> </div> <div class="page-header"> <h1><?php echo CHtml::image(Yii::app()->request->baseUrl . '/images/icon/tree_diagramm_new.png'); ?> Chart of Accounts</h1> </div> <?php //$this->widget('zii.widgets.CListView', array( //$this->widget('ext.bootstrap.widgets.BootListView', array( // 'dataProvider'=>$dataProvider, // 'itemView'=>'_view', //)); ?> <?php //$this->renderPartial('_view',array(
function report($periode_date, $report_id) { $this->myheader($periode_date, $report_id); $w = array(130, 20); $model1 = tAccountMain::model()->with('account_list')->findAll('type_id = 1'); $_labarugi = tAccount::labarugiDitahan($periode_date); $_s = 5; //Reset $_total = 0; $_subtotal = 0; $_grandtotal = 0; $_grandtotalA = 0; $_grandtotalP = 0; //Print/Preview Report foreach ($model1 as $mmm) { if ($mmm->id == 2) { //pasiva $_s = $_s + 5; $this->SetFont('Arial', 'B', 8); $this->Cell($w[0], 4, $mmm->name); $this->Cell($w[1], 4, ''); $this->Ln(); } foreach ($mmm->account_list as $mm) { $model2 = tAccount::model()->findByPk((int) $mm->parent_id); $this->SetFont('Arial', 'B', 8); if ($mmm->id == 2) { $this->Cell(5, 4, ''); } $this->Cell($w[0], 4, $model2->account_concat()); $this->SetX($this->x0); $this->Cell($w[1], 4, ''); $this->Ln(); foreach ($model2->childs as $model) { $this->SetFont('Arial', 'B', 8); $this->Cell($_s, 4, ''); $this->Cell($w[0], 4, $model->account_concat()); $this->SetX($this->x0); $this->Cell($w[1], 4, ''); $this->Ln(); if ($model->childs) { foreach ($model->childs as $mod) { if ($mod->childs) { $this->SetFont('Arial', 'B', 8); } else { $this->SetFont('Arial', '', 8); } $this->Cell($_s + 5, 4, ''); $this->Cell($w[0], 4, $mod->account_concat()); $this->SetX($this->x0); $_mod = $mod->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date)); if (isset($_mod->end_balance)) { $_balance = number_format($_mod->end_balance, 0, ',', '.'); $_subtotal = $_subtotal + $_mod->end_balance; $_grandtotal = $_grandtotal + $_mod->end_balance; } else { $_balance = 0; } if ($mod->childs) { $this->Cell($w[1], 4, '', 0, 0, 'R'); } else { /* if (isset($mod->accmain) && $mod->accmain->mvalue ==8) { $this->Cell($w[1],4,number_format($_labarugi,0,',','.'),0,0,'R'); $_total=$_total+$_labarugi; $_subtotal=$_subtotal+$_labarugi; $_grandtotal=$_grandtotal+$_labarugi; } else */ $this->Cell($w[1], 4, $_balance, 0, 0, 'R'); } $this->Ln(); if ($mod->childs) { foreach ($mod->childs as $m) { if ($m->childs) { $this->SetFont('Arial', 'B', 8); } else { $this->SetFont('Arial', '', 8); } $this->Cell($_s + 10, 4, ''); $this->Cell($w[0], 4, $m->account_concat()); $this->SetX($this->x0); $_m = $m->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date)); if (isset($_m->end_balance)) { $_balance = number_format($_m->end_balance, 0, ',', '.'); $_total = $_total + $_m->end_balance; $_subtotal = $_subtotal + $_m->end_balance; $_grandtotal = $_grandtotal + $_m->end_balance; } else { $_balance = 0; } if ($m->childs) { $this->Cell($w[1], 4, '', 0, 0, 'R'); } else { /* if (isset($m->accmain) && $m->accmain->mvalue ==8) { $this->Cell($w[1],4,number_format($_labarugi,0,',','.'),0,0,'R'); $_total=$_total+$_labarugi; $_subtotal=$_subtotal+$_labarugi; $_grandtotal=$_grandtotal+$_labarugi; } else */ $this->Cell($w[1], 4, $_balance, 0, 0, 'R'); } $this->Ln(); if ($m->childs) { ////////////////LAST foreach ($m->childs as $n) { if ($n->childs) { $this->SetFont('Arial', 'B', 8); } else { $this->SetFont('Arial', '', 8); } $this->Cell($_s + 15, 4, ''); $this->Cell($w[0], 4, $n->account_concat()); $this->SetX($this->x0); $_n = $n->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date)); if (isset($_n->end_balance)) { $_balance = number_format($_n->end_balance, 0, ',', '.'); $_total = $_total + $_n->end_balance; $_subtotal = $_subtotal + $_n->end_balance; $_grandtotal = $_grandtotal + $_n->end_balance; } else { $_balance = 0; } if ($n->childs) { $this->Cell($w[1], 4, '', 0, 0, 'R'); } else { /* if (isset($n->accmain) && $n->accmain->mvalue ==8) { $this->Cell($w[1],4,number_format($_labarugi,0,',','.'),0,0,'R'); $_total=$_total+$_labarugi; $_subtotal=$_subtotal+$_labarugi; $_grandtotal=$_grandtotal+$_labarugi; } else */ $this->Cell($w[1], 4, $_balance, 0, 0, 'R'); } $this->Ln(); } ///LAST } } } if ($mod->childs && $mod->childsCount >= 2) { $this->SetFont('Arial', 'B', 8); $this->Cell($_s + 5, 4, ''); $this->Cell($w[0], 4, 'TOTAL ' . $mod->account_name); $this->SetX($this->x0); $this->Cell($w[1], 4, number_format($_total, 0, ',', '.'), 'T', 0, 'R'); $this->Ln(5); } if ($mod->childs) { $_total = 0; } if ($this->GetY() >= 250) { $this->AddPage(); $this->myheader($periode_date, $report_id); } } } $this->SetFont('Arial', 'B', 8); $this->Cell($_s, 4, ''); $this->Cell($w[0], 4, 'TOTAL ' . $model->account_name); $this->SetX($this->x0 + 20); $this->Cell($w[1], 4, number_format($_subtotal, 0, ',', '.'), 'T', 0, 'R'); $this->Ln(5); $_subtotal = 0; if ($this->GetY() >= 250) { $this->AddPage(); $this->myheader(); } } $this->SetFillColor(224, 224, 224); $this->SetFont('Arial', 'B', 8); if ($mmm->id == 2) { $this->Cell(5, 4, ''); } $this->Cell($w[0], 4, 'TOTAL ' . $model2->account_name, 0, 0, 'L', true); $this->SetX($this->x0 + 20); $this->Cell($w[1], 4, number_format($_grandtotal, 0, ',', '.'), 0, 0, 'R', true); $this->Cell($w[1], 4, ''); $this->Ln(8); if ($mmm->id == 1) { //Aktiva $_grandtotalA = $_grandtotal; } else { $_grandtotalP = $_grandtotalP + $_grandtotal; } $_grandtotal = 0; } if ($mmm->id == 2) { //Pasiva $_s = $_s + 5; $this->SetFont('Arial', 'B', 8); $this->Cell($w[0], 4, $mmm->name, 0, 0, 'L', true); $this->SetX($this->x0 + 20); $this->Cell($w[1], 4, number_format($_grandtotalP, 0, ',', '.'), 0, 0, 'R', true); $this->Ln(); } } }
<?php echo $form->labelEx($model, 'input_date', array('class' => 'control-label')); ?> <div class="controls"> <?php $this->widget('zii.widgets.jui.CJuiDatePicker', array('model' => $model, 'id' => 'g2', 'value' => CTimestamp::formatDate('yyyy-MM-dd', $model->input_date), 'attribute' => 'input_date', 'options' => array('showAnim' => 'fold', 'dateFormat' => 'dd-mm-yy', 'minDate' => '-20', 'maxDate' => '+1M +10D'), 'htmlOptions' => array())); ?> </div> </div> <?php //echo $form->dropDownListRow($model,'yearmonth_periode',array(Yii::app()->settings->get("System", "cCurrentPeriod")=>Yii::app()->settings->get("System", "cCurrentPeriod"))); ?> <?php echo $form->dropDownListRow($model, 'var_account', tAccount::cashBankAccount()); echo $form->textFieldRow($model, 'cb_receiver', array('class' => 'span3')); echo $form->textAreaRow($model, 'remark', array('class' => 'span5', 'rows' => 3)); ?> <?php $this->widget('ext.appendo.JAppendo', array('id' => 'repeateEnum1', 'model' => $model, 'viewName' => '_detailJournal', 'labelDel' => 'Remove Row')); ?> <div class="form-actions"> <?php echo CHtml::htmlButton('<i class="icon-ok"></i> Save Expense', array('class' => 'btn', 'type' => 'submit')); ?> </div> <?php
'options'=>array( 'showAnim'=>'fold', 'dateFormat'=>'yymm', ), 'htmlOptions'=>array( ), )); ?> </div> </div> */ ?> <?php echo $form->dropDownListRow($model, 'budgetcomp_id', tAccount::purchasingAccount()); ?> <?php echo $form->dropDownListRow($model, 'supplier_id', cSupplier::items()); ?> <?php echo $form->textAreaRow($model, 'remark', array('rows' => 2, 'class' => 'span5')); ?> <?php $this->widget('ext.appendo.JAppendo', array('id' => 'repeateEnum', 'model' => $model, 'viewName' => '_detailPorderGeneral', 'labelDel' => 'Remove Row')); ?> <div class="form-actions">