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 loadModel($pk1, $pk2)
{
$model = sParameter::model()->find(array('condition' => 'type = "' . $pk1 . '" AND code = ' . $pk2));
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
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'));
}
<?php
$form = $this->beginWidget('BootActiveForm', array('id' => 't-account-form', 'type' => 'horizontal', 'enableAjaxValidation' => false));
?>
<?php
echo $form->errorSummary($model);
?>
<?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();
?>
public function system_reff()
{
$_state = null;
if ($this->state_id != 1) {
$_state = " (" . sParameter::item("cStatus", $this->state_id) . ")";
}
$_format = $this->system_ref . $_state;
return $_format;
}
<?php
$this->breadcrumbs = array('Parameter' => array('index'), 'Manage');
?>
<div class="page-header">
<h1><?php
echo CHtml::image(Yii::app()->request->baseUrl . '/images/icon/ms_dos_batch_file.png');
?>
Data Parameter</h1>
</div>
<?php
$this->widget('DropDownRedirect', array('data' => sParameter::items3("Any"), 'url' => $this->createUrl($this->route, array_merge($_GET, array('type' => '__value__'))), 'select' => isset($_GET['type']) ? $_GET['type'] : "(ALL)"));
?>
<?php
//$this->widget('bootstrap.widgets.BootGridView', array(
$this->widget('ext.groupgridview.GroupGridView', array('extraRowColumns' => array('type'), 'id' => 'parameter-grid', 'dataProvider' => $model->search($type), 'itemsCssClass' => 'table table-striped table-bordered', 'template' => '{items}{pager}', 'columns' => array(array('class' => 'bootstrap.widgets.BootButtonColumn', 'template' => '{updated}{delete}', 'deleteButtonUrl' => 'Yii::app()->createUrl("/sParameter/delete",array("pk1"=>$data->type,"pk2"=>$data->code))', 'buttons' => array('updated' => array('label' => 'Update', 'url' => 'Yii::app()->createUrl("/sParameter/update",array("pk1"=>$data->type,"pk2"=>$data->code,"asDialog"=>1,"gridId"=>$this->grid->id))', 'click' => 'function(){$("#cru-frame").attr("src",$(this).attr("href")); $("#cru-dialog").dialog("open"); return false;}'))), 'code', 'name')));
?>
<hr />
<?php
$this->widget('bootstrap.widgets.BootTabbable', array('type' => 'tabs', 'tabs' => array(array('label' => 'Existing Parameter', 'content' => $this->renderPartial("_formE", array("model" => $modelParameter), true), 'active' => true), array('label' => 'New Parameter', 'content' => $this->renderPartial("_form", array("model" => $modelParameter), true)))));
?>
<?php
//--------------------- begin new code --------------------------
// add the (closed) dialog for the iframe
$this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => 'cru-dialog', 'options' => array('title' => 'Update Detail', 'autoOpen' => false, 'modal' => true, 'width' => '70%', 'height' => '550')));
?>
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 = 3;
//Reset
$_total = 0;
$_subtotal = 0;
$_grandtotal = 0;
$_grandtotalA = 0;
$_grandtotalP = 0;
$_totalLast = 0;
$_subtotalLast = 0;
$_grandtotalLast = 0;
$_grandtotalALast = 0;
$_grandtotalPLast = 0;
//Print/Preview Report
foreach ($model1 as $mmm) {
if ($mmm->id == 2) {
//pasiva
$_s = $_s + 3;
$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 + 3, 4, '');
$this->Cell($w[0], 4, $mod->account_concat());
$this->SetX($this->x0);
$_mod = $mod->balancesheet(array('condition' => 'yearmonth_periode =' . $periode_date));
$_periode_date_last = sParameter::cBeginDateBefore($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) {
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));
$_mLast = $m->balancesheet(array('condition' => 'yearmonth_periode =' . $_periode_date_last));
if (isset($_m->end_balance)) {
$_balance = number_format($_m->end_balance, 0, ',', '.');
$_mmLast = isset($_mLast->end_balance) ? $_mLast->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 ($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));
$_nLast = $n->balancesheet(array('condition' => 'yearmonth_periode =' . $_periode_date_last));
if (isset($_n->end_balance)) {
$_balance = number_format($_n->end_balance, 0, ',', '.');
$_nnLast = isset($_nLast->end_balance) ? $_nLast->end_balance : 0;
$_balanceLast = number_format($_nnLast, 0, ',', '.');
$_total = $_total + $_n->end_balance;
$_subtotal = $_subtotal + $_n->end_balance;
$_grandtotal = $_grandtotal + $_n->end_balance;
$_totalLast = $_totalLast + $_nnLast;
$_subtotalLast = $_subtotalLast + $_nnLast;
$_grandtotalLast = $_grandtotalLast + $_nnLast;
} else {
$_balance = 0;
$_balanceLast = 0;
}
if ($n->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();
}
///LAST
}
}
}
if ($mod->childs && $mod->childsCount >= 2) {
$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);
}
if ($mod->childs) {
$_total = 0;
$_totalLast = 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->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->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] + 20, 4, number_format($_grandtotalLast, 0, ',', '.'), 0, 0, 'R', true);
$this->Cell($w[1], 4, '');
$this->Ln(8);
if ($mmm->id == 1) {
//Aktiva
$_grandtotalA = $_grandtotal;
$_grandtotalALast = $_grandtotalLast;
} else {
$_grandtotalP = $_grandtotalP + $_grandtotal;
$_grandtotalPLast = $_grandtotalPLast + $_grandtotalLast;
}
$_grandtotal = 0;
$_grandtotalLast = 0;
}
if ($mmm->id == 2) {
//Pasiva
$_s = $_s + 3;
$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->Cell($w[1] + 20, 4, number_format($_grandtotalPLast, 0, ',', '.'), 0, 0, 'R', true);
$this->Ln();
}
}
}
<?php
Yii::app()->clientScript->registerScript('myCap' . $data->id, "\n\n\t\t\$('#myCap'+{$data->id}).click(function(){\n\t\t\$(this).slideUp();\n\t\t\$.ajax({\n\t\ttype : 'get',\n\t\turl : \$(this).attr('href'),\n\t\tdata: '',\n\t\tsuccess : function(r){\n\t\t\$('#mydialog').dialog('open');\n\t\t\$('#list-'+{$data->id}).slideUp('slow');\n\t\tsetTimeout(\"\$('#mydialog').dialog('close') \",1200);\n}\n})\n\t\treturn false;\n});\n\n\n\t\t");
?>
<div id="list-<?php
echo $data->id;
?>
" class="well">
<b><?php
echo CHtml::encode($data->system_ref);
if ($data->state_id != 1) {
echo " (" . sParameter::item("cStatus", $data->state_id) . ")";
}
?>
</b>
<?php
echo CHtml::link('detail<i class="icon-chevron-right"></i>', '#', array('class' => 'hide-info' . $data->id));
?>
<br />
<br />
<div class="list<?php
echo $data->id;
?>
" style="display: none">
function pRequestR1($id)
{
$this->myheader4($id);
$criteria = new CDbCriteria();
$criteria->compare('parent_id', $id);
$models = aPorderDetail::model()->findAll($criteria);
$_counter = 1;
$_countert = 1;
$_totalc = 0;
$_totals = 0;
$w = array(6, 65, 40, 10, 10, 20, 20, 25, 15, 10, 10, 10, 10, 20);
$x = $this->GetX();
$y = $this->GetY();
foreach ($models as $mod) {
$this->SetFont('Arial', '', 8);
$x0 = $this->GetX();
$y0 = $this->GetY();
$this->Cell($w[0], 4, number_format($_countert, 0, ',', '.'), 'L', 0, 'R');
$y1 = $this->GetY();
$this->MultiCell($w[1], 4, aBudget::model()->findByPk($mod->budget_id)->code . " " . $mod->description, 'LB');
$y2 = $this->GetY();
$yH = $y2 - $y1;
$yC = $this->GetY();
$this->SetXY($x0, $y0);
$this->Cell($w[0], $yH, '', 'LB');
//Garis samping
$this->SetXY($x + $w[0] + $w[1], $yC - $yH);
$this->Cell($w[2], $yH, $mod->user, 'LB');
$this->Cell($w[3], $yH, $mod->uom, 'LB');
$this->Cell($w[4], $yH, $mod->qty, 'LB', 0, 'R');
$this->Cell($w[5], $yH, '', 'LB', 0, 'R');
$this->Cell($w[6], $yH, sParameter::cDateDisplay(strtotime($mod->need_date)), 'LB', 0, 'R');
$this->Cell($w[7], $yH, '', 'LB', 0, 'R');
$this->Cell($w[8], $yH, '', 'LB', 0, 'R');
$this->Cell($w[9], $yH, '', 'LB', 0, 'R');
$this->Cell($w[10], $yH, '', 'LB', 0, 'R');
$this->Cell($w[11], $yH, '', 'LB', 0, 'R');
$this->Cell($w[12], $yH, '', 'LB', 0, 'R');
$this->Cell($w[13], $yH, '', 'LBR', 0, 'R');
$this->Ln();
$_totalc = $_totalc + $mod->qty;
$_totals = $_totals + aBudget::model()->findByPk($mod->budget_id)->amount;
$_counter++;
$_countert++;
//if ($_counter==34) {
// $this->AddPage();
// $this->myheader4($id);
// $_counter = 1;
//}
}
//Closure line
$this->Cell(array_sum($w), 0, '', 'T');
$this->Ln(2);
$this->SetFont('Arial', 'B', 8);
$this->Cell($w[0], 5, '', 'TLB');
$this->Cell($w[1], 5, 'T O T A L', 'TLB', 0, 'C');
$this->Cell($w[2], 5, '', 'TLB');
$this->Cell($w[3], 5, '', 'TLB');
$this->Cell($w[4], 5, number_format($_totalc, 0, ',', '.'), 'TLBR', 0, 'R');
$this->Cell($w[5], 5, '', 'TLBR', 0, 'R');
$this->Cell($w[6], 5, '', 'TLB');
$this->Cell($w[7], 5, '', 'TLB');
$this->Cell($w[8], 5, '', 'TLB');
$this->Cell($w[9], 5, '', 'TLB');
$this->Cell($w[10], 5, '', 'TLB');
$this->Cell($w[11], 5, '', 'TLB');
$this->Cell($w[12], 5, '', 'TLB');
$this->Cell($w[13], 5, '', 1);
$this->Ln(10);
$this->SetFont('Arial', '', 8);
$this->Cell(30, 6, 'Keterangan:');
$this->Ln(4);
$this->Cell(0, 6, aPorder::model()->findByPk($mod->parent_id)->remark);
$this->Ln(14);
$this->SetFont('Arial', '', 10);
$this->Cell($w[0], 6, '', 'LT');
$this->Cell($w[1], 6, 'Requested By', 'TR', 0, 'C');
$this->Cell($w[2], 6, '', 'T', 0, 'C');
$this->Cell($w[3], 6, '', 'T', 0, 'C');
$this->Cell($w[4], 6, '', 'T', 0, 'C');
$this->Cell($w[5], 6, '', 'T', 0, 'C');
$this->Cell($w[6], 6, '', 'T', 0, 'C');
$this->Cell($w[7], 6, 'Acknowledge By:', 'T', 0, 'C');
$this->Cell($w[8], 6, '', 'T', 0, 'C');
$this->Cell($w[9], 6, '', 'T', 0, 'C');
$this->Cell($w[10], 6, '', 'T', 0, 'C');
$this->Cell($w[11], 6, '', 'T', 0, 'C');
$this->Cell($w[12], 6, '', 'T', 0, 'C');
$this->Cell($w[13], 6, '', 'TR', 0, 'C');
$this->Ln();
$this->Cell($w[0], 18, '', 'L');
$this->Cell($w[1], 18, '', 'R');
$this->Cell($w[2], 18);
$this->Cell($w[3], 18);
$this->Cell($w[4], 18);
$this->Cell($w[5], 18);
$this->Cell($w[6], 18);
$this->Cell($w[7], 18);
$this->Cell($w[8], 18);
$this->Cell($w[9], 18);
$this->Cell($w[10], 18);
$this->Cell($w[11], 18);
$this->Cell($w[12], 18);
$this->Cell($w[13], 18, '', 'R');
$this->Ln();
$this->Cell($w[0], 6, '', 'L');
$this->Cell($w[1], 6, 'Silvia Theresia', 'R', 0, 'C');
$this->Cell($w[2], 6, '', 0, 0, 'C');
$this->Cell($w[3], 6, '', 0, 0, 'C');
$this->Cell($w[4] + $w[5], 6, 'Hadi Sutanto', 0, 0, 'C');
$this->Cell($w[6], 6, '', 0, 0, 'C');
$this->Cell($w[7], 6, '', 0, 0, 'C');
$this->Cell($w[8], 6, '', 0, 0, 'C');
$this->Cell($w[9] + $w[10] + $w[11], 6, 'Indra W. Antono', 0, 0, 'C');
$this->Cell($w[12], 6, '', 0, 0, 'C');
$this->Cell($w[13], 6, '', 'R', 'C');
$this->Ln(3);
$this->SetFont('Arial', '', 8);
$this->Cell($w[0], 6, '', 'LB');
$this->Cell($w[1], 6, 'Office Support Manager', 'BR', 0, 'C');
$this->Cell($w[2], 6, '', 'B', 0, 'C');
$this->Cell($w[3], 6, '', 'B', 0, 'C');
$this->Cell($w[4] + $w[5], 6, 'Fin & Acc Deputy Director', 'B', 0, 'C');
$this->Cell($w[6], 6, '', 'B', 0, 'C');
$this->Cell($w[7], 6, '', 'B', 0, 'C');
$this->Cell($w[8], 6, '', 'B', 0, 'C');
$this->Cell($w[9] + $w[10] + $w[11], 6, 'Marketing Director', 'B', 0, 'C');
$this->Cell($w[12], 6, '', 'B', 0, 'C');
$this->Cell($w[13], 6, '', 'BR', 'C');
$this->Ln();
$this->SetFont('Arial', 'BI', 8);
$this->Cell(0, 6, aPorder::model()->findByPk($mod->parent_id)->no_ref . " ", 0, 0, 'R');
$this->Ln();
}
<?php
$this->breadcrumbs = array('Notification' => array('index'), 'Manage');
Yii::app()->clientScript->registerScript('search', "\n\t\t\$('.search-button').click(function(){\n\t\t\$('.search-form').toggle();\n\t\treturn false;\n});\n\t\t\$('.search-form form').submit(function(){\n\t\t\$.fn.yiiGridView.update('sNotification-grid', {\n\t\tdata: \$(this).serialize()\n});\n\t\treturn false;\n});\n\t\t");
?>
<div class="page-header">
<h1>
<?php
echo CHtml::image(Yii::app()->request->baseUrl . '/images/icon/preferences_desktop_notification.png');
?>
Notification Manager
</h1>
</div>
<?php
$this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => 'advancedsearch_dialog', 'options' => array('title' => 'Advanced Search', 'width' => 'auto', 'autoOpen' => false)));
$this->renderPartial('_search', array('model' => $model));
$this->endWidget('zii.widgets.jui.CJuiDialog');
?>
<div class="mymenu">
<?php
echo CHtml::link('Add New', array('create'));
echo CHtml::label(' | ', '#');
echo CHtml::link('Search', '#', array('onclick' => '$("#advancedsearch_dialog").dialog("open"); return false;'));
?>
</div>
<?php
$this->widget('bootstrap.widgets.BootGridView', array('id' => 'sNotification-grid', 'dataProvider' => $model->search(), 'itemsCssClass' => 'table table-striped table-bordered', 'template' => '{items}{pager}', 'columns' => array(array('class' => 'CButtonColumn', 'template' => '{view}{update}{delete}{archive}', 'buttons' => array('archive' => array('label' => 'archive', 'url' => 'Yii::app()->createUrl("sNotification/markarchive", array("id"=>$data->id))', 'visible' => '$data->read_id != 6'))), array('name' => 'type_id', 'value' => 'sParameter::item("cNotifType",$data->type_id)', 'filter' => sParameter::items("cNotifType")), 'broadcast_code', array('name' => 'sender_date', 'value' => '$data->sender_date'), array('name' => 'sender_id', 'value' => 'sUser::model()->findName($data->sender_id)', 'filter' => sUser::model()->allUsers()), array('name' => 'receiver_date', 'value' => '$data->receiver_date'), array('name' => 'receiver_id', 'value' => 'sUser::model()->findName($data->receiver_id)', 'filter' => sUser::model()->allUsers('all')), array('name' => 'category_id', 'value' => 'sParameter::item("cCategory",$data->category_id)', 'filter' => sParameter::items("cCategory")), array('name' => 'long_desc', 'filter' => false), array('name' => 'read_id', 'value' => 'sParameter::item("cRead",$data->read_id)', 'filter' => sParameter::items("cRead")))));
<?php
$this->widget('zii.widgets.jui.CJuiDatePicker', array('model' => $model, 'attribute' => 'end_date', 'options' => array('showAnim' => 'fold', 'dateFormat' => 'dd-mm-yy'), 'htmlOptions' => array('style' => 'height:28px;')));
?>
</div>
</div>
<div class="control-group">
<?php
echo $form->labelEx($model, 'reminder', array('class' => 'control-label'));
?>
<div class="controls">
<?php
$this->widget('zii.widgets.jui.CJuiDatePicker', array('model' => $model, 'attribute' => 'reminder', 'options' => array('showAnim' => 'fold', 'dateFormat' => 'dd-mm-yy'), 'htmlOptions' => array('style' => 'height:28px;')));
?>
</div>
</div>
<?php
echo $form->dropDownListRow($model, 'status_id', sParameter::items("cStatusTask"));
echo $form->dropDownListRow($model, 'priority_id', sParameter::items("cPriority"));
echo $form->dropDownListRow($model, 'category_id', sParameter::items("cTaskCategory"));
echo $form->textAreaRow($model, 'notes', array('rows' => 3, 'class' => 'span4'));
?>
<div class="form-actions">
<?php
echo CHtml::htmlButton('<i class="icon-ok"></i> Submit', array('class' => 'btn', 'type' => 'submit'));
?>
</div>
<?php
$this->endWidget();
<?php
$form = $this->beginWidget('BootActiveForm', array('id' => 'parameter-form', 'type' => 'horizontal', 'enableAjaxValidation' => false));
?>
<?php
echo $form->dropDownListRow($model, 'type', sParameter::items2("ALL"));
?>
<?php
echo $form->textFieldRow($model, 'code');
?>
<?php
echo $form->textFieldRow($model, 'name', array('class' => 'span3'));
?>
<div class="form-actions">
<?php
echo CHtml::htmlButton($model->isNewRecord ? '<i class="icon-ok"></i> Create' : '<i class="icon-ok"></i> Save', array('class' => 'btn', 'type' => 'submit'));
?>
</div>
<?php
$this->endWidget();
<?php
$form = $this->beginWidget('BootActiveForm', array('id' => 'c-jemaat-form', 'type' => 'horizontal', 'enableAjaxValidation' => false));
?>
<?php
echo $form->errorSummary($model);
?>
<?php
echo $form->textFieldRow($model, 'branch_code', array('class' => 'span3'));
echo $form->dropDownListRow($model, 'structure_id', sParameter::items("cStructure"));
echo $form->textFieldRow($model, 'name', array('class' => 'span3'));
echo $form->textFieldRow($model, 'address', array('class' => 'span3'));
echo $form->textFieldRow($model, 'address2', array('class' => 'span3'));
echo $form->textFieldRow($model, 'address3', array('class' => 'span3'));
echo $form->textFieldRow($model, 'address4', array('class' => 'span3'));
?>
<?php
/*
<?php echo $form->labelEx($model,'propinsi_id'); ?>
<?php
echo $form->dropDownList($model,'propinsi_id',sKabupatenPropinsi::items("Any"),
array(
'empty'=>'select Propinsi:',
'ajax' => array(
'type'=>'POST',
'url'=>CController::createUrl('/m1/aOrganization/kabupatenUpdate'),
'update'=>'#'.CHtml::activeId($model,'kabupaten_id'),
<?php
$this->breadcrumbs = array('Account Payable' => array('index'), $model->system_ref);
$this->menu = array(array('label' => 'Home', 'url' => array('/mAccpayable/')), array('label' => 'Approval', 'url' => array('/mAccpayable/', 'id' => 1)), array('label' => 'Payment', 'url' => array('/mAccpayable/', 'id' => 2)), array('label' => 'Paid', 'url' => array('/mAccpayable/', 'id' => 3)), array('label' => 'Show All', 'url' => array('/mAccpayable/', 'id' => 0)), array('label' => 'Print', 'url' => array('print', 'id' => $model->id)));
$this->menu1 = bPorder::getTopUpdated(1);
$this->menu2 = bPorder::getTopCreated(1);
//$this->menu3=uJournal::getTopRelated($model->user_ref);
?>
<div class="page-header">
<h1>
Account Payable:
<?php
echo $model->system_ref;
if ($model->state_id != 1) {
echo " (" . sParameter::item("cStatus", $model->state_id) . ")";
}
?>
</h1>
</div>
<?php
$this->widget('bootstrap.widgets.BootDetailView', array('data' => $model, 'attributes' => array('input_date', 'yearmonth_periode', 'user_ref', 'system_ref', 'remark')));
?>
<br />
<?php
echo $this->renderPartial('/uJournal/_viewDetail', array('id' => $model->id));
?>
?>
<?php
echo $form->dropDownListRow($model, 'receiver_id', sUser::model()->allUsers());
?>
<?php
echo $form->dropDownListRow($model, 'category_id', sParameter::items("cCategory"));
?>
<?php
echo $form->textAreaRow($model, 'long_desc', array('class' => 'span6', 'rows' => 6));
//$this->widget('application.extensions.tinymce.ETinyMce',
// array('name'=>'html','model'=>$model,'attribute'=>'long_desc'));
?>
<?php
echo $form->dropDownListRow($model, 'read_id', sParameter::items("cRead"));
?>
<div class="form-actions">
<?php
echo CHtml::htmlButton('<i class="icon-ok"></i> Send', array('class' => 'btn', 'type' => 'submit'));
?>
</div>
<?php
$this->endWidget();
<?php
$form = $this->beginWidget('BootActiveForm', array('id' => 't-account-form', 'type' => 'horizontal', 'enableAjaxValidation' => false));
?>
<?php
//echo $form->errorSummary($model);
?>
<?php
echo $form->dropDownListRow($model, 'haschild_id', sParameter::items("cHasChild"));
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' => 'span4', 'rows' => 3));
//echo $form->dropDownListRow($model,'currency_id',sParameter::items("cCurrency","*inherited*"));
echo $form->textFieldRow($model, 'beginning_balance', array('class' => 'span3', 'hint' => 'This field must be filled, otherwise record cannot be saved..'));
//echo $form->dropDownListRow($model,'state_id',sParameter::items("cStatus","*inherited*"));
?>
<div class="form-actions">
<?php
echo CHtml::htmlButton($model->isNewRecord ? '<i class="icon-ok"></i> Create' : '<i class="icon-ok"></i> Save', array('class' => 'btn', 'type' => 'submit'));
?>
</div>
<?php
$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);
}
}
<?php
echo $model->sender_ref;
?>
</h1>
</div>
<div class="row-fluid">
<div class="span12">
<div class="well">
<h4><span class="icon fam-note"></span>
<?php
echo sUser::model()->findName($model->sender_id) . ' to ' . sUser::model()->findName($model->receiver_id);
?>
|
<?php
echo sParameter::item("cCategory", $model->category_id);
?>
</h4>
<br />
<?php
echo $model->long_desc;
?>
<h6>
<?php
echo Yii::app()->dateFormatter->format("dd-MM-yyyy HH:mm", $model->sender_date);
?>
</h6>
<?php
$comment = sNotificationDetail::model()->findAll(array('condition' => 'parent_id = ' . $model->id));
echo $form->textFieldRow($model, 'begindate');
?>
<?php
echo $form->textFieldRow($model, 'enddate');
?>
<?php
/*
$this->widget('ext.monthpicker.MonthPicker', array(
'model'=>$model,
'name'=>'begindate',
));
*/
?>
<?php
echo $form->dropDownListRow($model, 'type_report_id', array('1' => 'Summary Style', '2' => 'Detail Style'));
?>
<?php
echo $form->dropDownListRow($model, 'post_id', sParameter::items("cStatus", 2));
?>
<div class="form-actions">
<?php
echo CHtml::htmlButton('<i class="icon-ok"></i> Report', array('class' => 'btn', 'type' => 'submit'));
?>
</div>
<?php
$this->endWidget();
<div class="comment">
<div class="author">
<b><?php
echo sParameter::item("cCategory", $data->category_id);
?>
</b>
</div>
<div class="time">
<?php
echo CHtml::encode($data->sender_date, 1);
?>
</div>
<div class="content">
<?php
echo CHtml::encode($data->long_desc);
?>
</div>
</div>
<?php
$this->breadcrumbs = array('Event Management' => array('index'), $model->id);
?>
<div class="page-header">
<h1>
<?php
echo $model->issue;
?>
</h1>
</div>
<?php
$this->widget('ext.JuiButtonSet.JuiButtonSet', array('items' => array(array('label' => 'List View', 'icon-position' => 'left', 'url' => array('admin')), array('label' => 'Update', 'icon-position' => 'left', 'url' => array('update', 'id' => $model->id))), 'htmlOptions' => array('style' => 'clear: both;')));
?>
<?php
//$this->widget('bootstrap.widgets.BootDetailView', array(
$this->widget('ext.XDetailView', array('ItemColumns' => 2, 'data' => $model, 'attributes' => array(array('name' => 'event_id', 'value' => sParameter::item("cEvent", $model->event_id)), 'id', array('name' => 'category_id', 'value' => sParameter::item("cEventCat", $model->category_id)), 'issue', 'person_incharge', 'todo', 'progress', 'incomplete_exp', 'remark')));
function pRequestR2($id)
{
$this->myheader4($id);
$criteria = new CDbCriteria();
$criteria->compare('parent_id', $id);
$criteria->compare('tcredit>', 0);
$criteria->order = 'periode_date, id';
$models = aBudgetDetail::model()->findAll($criteria);
$_counter = 1;
$_countert = 1;
$_totalc = 0;
$_totals = 0;
$w = array(8, 25, 50, 30, 30, 30, 40, 50);
//Saldo Awal
$criteria1 = new CDbCriteria();
$criteria1->compare('parent_id', $id);
$criteria1->compare('tdebt>', 0);
$criteria1->order = 'periode_date, id';
$modelt = aBudgetDetail::model()->find($criteria1);
$this->SetFont('Arial', '', 8);
$this->Cell($w[0], 6, $_counter, 'LB', 0, 'R');
$this->Cell($w[1], 6, $modelt->input_date, 'LB');
$this->Cell($w[2], 6, $modelt->no_ref, 'LB');
$this->Cell($w[3], 6, $modelt->periode_date, 'LB');
$this->Cell($w[4], 6, '', 'LB', 0, 'R');
$this->SetFont('Arial', 'B', 8);
$this->Cell($w[5], 6, number_format($modelt->tdebt, 0, ',', '.'), 'LB', 0, 'R');
$this->Cell($w[6], 6, '', 'LB');
$this->SetFont('Arial', '', 8);
$this->Cell($w[7], 6, $modelt->remark, 'LBR');
$this->Ln();
//End of Saldo Awal
$_counter++;
foreach ($models as $mod) {
$this->SetFont('Arial', '', 8);
$this->Cell($w[0], 6, $_counter, 'LB', 0, 'R');
$this->Cell($w[1], 6, $mod->input_date, 'LB');
$this->Cell($w[2], 6, $mod->no_ref, 'LB');
$this->Cell($w[3], 6, sParameter::BulanTahun1($mod->periode_date), 'LB');
$this->Cell($w[4], 6, number_format($mod->tcredit, 0, ',', '.'), 'LB', 0, 'R');
$this->Cell($w[4], 6, number_format($mod->balance, 0, ',', '.'), 'LB', 0, 'R');
$this->Cell($w[6], 6, aPorder::model()->issuerBy((int) $mod->prequest_id), 'LB');
$this->Cell($w[7], 6, $mod->remark, 'LBR');
$this->Ln();
$_totalc = $_totalc + $mod->tcredit;
$_counter++;
$_countert++;
//if ($_counter==34) {
// $this->AddPage();
// $this->myheader4($id);
// $_counter = 1;
//}
}
//Closure line
$this->Cell(array_sum($w), 0, '', 'T');
$this->Ln(2);
$w = array(8, 25, 50, 30, 30, 30, 40, 50);
$this->SetFont('Arial', 'B', 8);
$this->Cell($w[0], 6, '', 1);
$this->Cell($w[1], 6, '', 1, 0, 'C');
$this->Cell($w[2], 6, '', 1, 0, 'C');
$this->Cell($w[3], 6, '', 1, 0, 'C');
$this->Cell($w[4], 6, number_format($_totalc, 0, ',', '.'), 1, 0, 'R');
$this->Cell($w[5], 6, number_format($mod->balance, 0, ',', '.'), 1, 0, 'R');
$this->Cell($w[6], 6, '', 1, 0, 'C');
$this->Cell($w[7], 6, '', 1, 0, 'C');
$this->Ln();
/* $this->SetFont('Arial','',8);
$this->Cell(30,6,'Keterangan');
$this->Ln();
$this->Cell(0,6,aBudgetDetail::model()->findByPk($mod->parent_id)->remark);
$this->Ln(10);
$this->SetFont('Arial','',10);
$this->Cell($w[0],6,'','LT');
$this->Cell($w[1],6,'Requested By','TR',0,'C');
$this->Cell($w[2],6,'','T',0,'C');
$this->Cell($w[3],6,'','T',0,'C');
$this->Cell($w[4],6,'','T',0,'C');
$this->Cell($w[5],6,'','T',0,'C');
$this->Cell($w[6],6,'','T',0,'C');
$this->Cell($w[7],6,'Acknowledge By:','T',0,'C');
$this->Cell($w[8],6,'','T',0,'C');
$this->Cell($w[9],6,'','T',0,'C');
$this->Cell($w[10],6,'','T',0,'C');
$this->Cell($w[11],6,'','T',0,'C');
$this->Cell($w[12],6,'','T',0,'C');
$this->Cell($w[13],6,'','TR',0,'C');
$this->Ln();
$this->Cell($w[0],18,'','L');
$this->Cell($w[1],18,'','R');
$this->Cell($w[2],18);
$this->Cell($w[3],18);
$this->Cell($w[4],18);
$this->Cell($w[5],18);
$this->Cell($w[6],18);
$this->Cell($w[7],18);
$this->Cell($w[8],18);
$this->Cell($w[9],18);
$this->Cell($w[10],18);
$this->Cell($w[11],18);
$this->Cell($w[12],18);
$this->Cell($w[13],18,'','R');
$this->Ln();
$this->Cell($w[0],6,'','L');
$this->Cell($w[1],6,'Silvia Theresia','R',0,'C');
$this->Cell($w[2],6,'',0,0,'C');
$this->Cell($w[3],6,'',0,0,'C');
$this->Cell($w[4]+$w[5],6,'Hadi Sutanto',0,0,'C');
$this->Cell($w[6],6,'',0,0,'C');
$this->Cell($w[7],6,'',0,0,'C');
$this->Cell($w[8],6,'',0,0,'C');
$this->Cell($w[9]+$w[10]+$w[11],6,'Indra W. Antono',0,0,'C');
$this->Cell($w[12],6,'',0,0,'C');
$this->Cell($w[13],6,'','R','C');
$this->Ln(3);
$this->SetFont('Arial','',8);
$this->Cell($w[0],6,'','LB');
$this->Cell($w[1],6,'Office Support Manager','BR',0,'C');
$this->Cell($w[2],6,'','B',0,'C');
$this->Cell($w[3],6,'','B',0,'C');
$this->Cell($w[4]+$w[5],6,'Fin & Acc Deputy Director','B',0,'C');
$this->Cell($w[6],6,'','B',0,'C');
$this->Cell($w[7],6,'','B',0,'C');
$this->Cell($w[8],6,'','B',0,'C');
$this->Cell($w[9]+$w[10]+$w[11],6,'Marketing Director','B',0,'C');
$this->Cell($w[12],6,'','B',0,'C');
$this->Cell($w[13],6,'','BR','C');
$this->Ln();
$this->SetFont('Arial','BI',8);
$this->Cell(0,6,aBudgetDetail::model()->findByPk($mod->parent_id)->no_ref . " ",0,0,'R');
$this->Ln();
*/
}
$form = $this->beginWidget('BootActiveForm', array('id' => 'user-module-form', 'type' => 'horizontal', 'enableAjaxValidation' => false));
?>
<?php
echo $form->errorSummary($model);
?>
<?php
echo $form->textFieldRow($model, 'username', array('class' => 'span3'));
?>
<?php
echo $form->passwordFieldRow($model, 'password', array('class' => 'span3'));
?>
<?php
echo $form->dropDownListRow($model, 'default_group', aOrganization::model()->getRootList());
?>
<?php
echo $form->dropDownListRow($model, 'status_id', sParameter::items("cStatusP"));
?>
<div class="form-actions">
<?php
echo CHtml::htmlButton($model->isNewRecord ? '<i class="icon-ok"></i> Create' : '<i class="icon-ok"></i> Save', array('class' => 'btn', 'type' => 'submit'));
?>
</div>
<?php
$this->endWidget();
<?php
echo $form->textFieldRow($model, 'input_date');
?>
<?php
echo $form->textFieldRow($model, 'no_ref', array('class' => 'span3'));
echo $form->textFieldRow($model, 'periode_date');
?>
<?php
echo $form->dropDownListRow($model, 'budgetcomp_id', aBudget::mainComponent(), array());
?>
<?php
echo $form->textAreaRow($model, 'remark', array('rows' => 2, 'cols' => 50));
?>
<?php
echo $form->dropDownListRow($model, 'issuer_id', sParameter::items("cIssuer"));
$this->widget('ext.appendo.JAppendo', array('id' => 'repeateEnum', 'model' => $model, 'viewName' => '_detailPorder', '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();
<?php
$this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => 'mydialog', 'options' => array('title' => 'Sick, Absence, Leave', 'autoOpen' => false, 'modal' => true)));
echo 'Day Status Complete...';
$this->endWidget('zii.widgets.jui.CJuiDialog');
?>
<?php
//$this->renderPartial('_formAbsence', array('model'=>$modelAbsence));
?>
<hr />
<?php
$this->widget('bootstrap.widgets.BootMenu', array('type' => 'pills', 'stacked' => false, 'items' => array(array('label' => '<< Previous Month', 'url' => Yii::app()->createUrl("/m1/cAbsence/view", array("id" => $model->id, "month" => $month - 1))), array('label' => sParameter::BulanTahun(date("Ym", strtotime(date("Y-m", strtotime($month . " month")) . "-01"))), 'url' => Yii::app()->createUrl("/m1/cAbsence/view", array("id" => $model->id, "month" => $month))), array('label' => 'Next Month >>', 'url' => Yii::app()->createUrl("/m1/cAbsence/view", array("id" => $model->id, "month" => $month + 1))))));
?>
<?php
$this->widget('bootstrap.widgets.BootGridView', array('id' => 'cpersonalia-absence-grid', 'dataProvider' => gPersonAbsence::model()->search((int) $model->id, $month), 'template' => '{items}', 'itemsCssClass' => 'table table-striped table-bordered', 'template' => '{items}{pager}{summary}', 'columns' => array(array('class' => 'BootButtonColumn', 'template' => '{sakit}{alpha}{permission}', 'buttons' => array('sakit' => array('label' => 'Sakit', 'imageUrl' => Yii::app()->request->baseUrl . '/images/icon/sakit.png', 'url' => 'Yii::app()->createUrl("/m1/cAbsence//setSakit", array("id"=>$data->id))', 'options' => array('ajax' => array('type' => 'GET', 'url' => "js:\$(this).attr('href')", 'success' => 'js:function(data){$("#mydialog").dialog("open");
$.fn.yiiGridView.update("cpersonalia-absence-grid", {
data: $(this).serialize()
});
}'))), 'alpha' => array('label' => 'Absence', 'imageUrl' => Yii::app()->request->baseUrl . '/images/icon/alpha.png', 'url' => 'Yii::app()->createUrl("/m1/cAbsence//setAlpha", array("id"=>$data->id))', 'options' => array('ajax' => array('type' => 'GET', 'url' => "js:\$(this).attr('href')", 'success' => 'js:function(data){$("#mydialog").dialog("open");
$.fn.yiiGridView.update("cpersonalia-absence-grid", {
data: $(this).serialize()
});
}'))), 'permission' => array('label' => 'Update', 'imageUrl' => Yii::app()->request->baseUrl . '/images/icon/ijin.png', 'url' => '$this->grid->controller->createUrl("/CAbsence/updateAbsence", array("id"=>$data->id,"pid"=>$data->parent_id,"asDialog"=>1,"gridId"=>$this->grid->id))', 'click' => 'function(){$("#cru-frame").attr("src",$(this).attr("href")); $("#cru-dialog").dialog("open"); return false;}'))), array('name' => 'cdate', 'value' => '$data->cdate'), array('name' => 'realpattern_id', 'value' => '$data->timeBlock->code'), array('header' => 'Sched In', 'value' => 'Yii::app()->dateFormatter->formatDateTime($data->timeBlock->in,null,"medium")'), array('header' => 'Sched Out', 'value' => 'Yii::app()->dateFormatter->formatDateTime($data->timeBlock->out,null,"medium")'), array('name' => 'in', 'value' => 'Yii::app()->dateFormatter->formatDateTime($data->in,null,"medium")'), array('name' => 'out', 'value' => 'Yii::app()->dateFormatter->formatDateTime($data->out,null,"medium")'), array('header' => 'In Status', 'value' => '$data->lateIn'), array('header' => 'Out Status', 'value' => '$data->EarlyOut'), 'remark', array('name' => 'daystatus1_id', 'value' => '$data->daystatus1_id == 0 ? "" : $data->dayCategory->name'))));
?>
<?php
?>
</td>
<td><?php
echo CHtml::textField('text[]', '');
?>
</td>
</tr>
<?php
} else {
?>
<?php
for ($i = 0; $i < sizeof($model->account_properties); ++$i) {
?>
<tr>
<td><?php
echo CHtml::dropDownList('account_properties[]', $model->account_properties[$i], sParameter::itemsOther("cAccProperties"));
?>
</td>
<td><?php
echo CHtml::dropDownList('value[]', $model->value[$i], array('0' => '*Inherited*', '1' => 'Set Yes (or Set No Child)', '2' => 'Has Child'));
?>
</td>
<td><?php
echo CHtml::textField('text[]', $model->text[$i], array());
?>
</td>
</tr>
<?php
}
?>
<?php
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 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();
}
}
