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();
}
<div class="page-header">
<h1>
<?php
echo CHtml::image(Yii::app()->request->baseUrl . '/images/icon/payment.png');
?>
Approval Form
</h1>
</div>
<?php
//----- begin new code --------------------
if (empty($_GET['asDialog'])) {
//$this->widget('bootstrap.widgets.BootDetailView', array(
$this->widget('ext.XDetailView', array('ItemColumns' => 2, 'data' => $model, 'attributes' => array(array('label' => 'Entity', 'value' => $model->organization->name), 'input_date', 'af_date', 'no_ref', 'periode_date', array('label' => 'Budget Component', 'value' => $model->budgetcomp->name), 'approved_date', 'remark', array('label' => 'Issued By', 'value' => $model->issuer->name), array('label' => 'Payment Status', 'value' => $model->payment->name), 'payment_date')));
}
//----- end new code --------------------
?>
<?php
$this->widget('bootstrap.widgets.BootGridView', array('id' => 'aPorder-detail-grid', 'dataProvider' => aPorderDetail::model()->search($_GET['id']), 'itemsCssClass' => 'table table-striped table-bordered', 'template' => '{items}{pager}', 'columns' => array(array('class' => 'BootButtonColumn', 'template' => '{payment}', 'buttons' => array('payment' => array('label' => 'Paid', 'url' => 'Yii::app()->createUrl("/m1/aApprovalForm/updateDetailPaid", array("id"=>$data->id))', 'visible' => '$data->detail_payment_id ==1', 'options' => array('ajax' => array('type' => 'GET', 'url' => "js:\$(this).attr('href')", 'success' => 'js:function(data){
$.fn.yiiGridView.update("aPorder-detail-grid", {
data: $(this).serialize()
});
}'))))), array('header' => 'Department', 'value' => 'isset($data->department) ? $data->department->name : "ALL"'), array('header' => 'Budget SubComp.', 'value' => '$data->budget->code .". ".$data->budget->name'), 'description', array('value' => '$data->amountf()', 'name' => 'amount', 'htmlOptions' => array('style' => 'text-align: right; padding-right: 5px;')), array('header' => 'Total', 'value' => '$data->totalf()', 'name' => 'amount', 'htmlOptions' => array('style' => 'text-align: right; padding-right: 5px;')), array('header' => 'Payment', 'value' => '$data->payment->name'))));
?>
<br />
<b> Total: <?php
echo $model->sum_pof();
?>
</b>
public function actionUpdateDetailPaid($id)
{
aPorderDetail::model()->updateByPk((int) $id, array('detail_payment_id' => 3));
}
?>
<div class="page-header">
<h1>
<?php
echo CHtml::image(Yii::app()->request->baseUrl . '/images/icon/cash.png');
?>
<?php
echo "PO: " . $model->no_ref;
?>
</h1>
</div>
<?php
//----- begin new code --------------------
if (empty($_GET['asDialog'])) {
//$this->widget('bootstrap.widgets.BootDetailView', array(
$this->widget('ext.XDetailView', array('ItemColumns' => 2, 'data' => $model, 'attributes' => array(array('label' => 'Entity', 'value' => $model->organization->name), 'input_date', 'af_date', 'no_ref', 'periode_date', array('label' => 'Budget Component', 'value' => $model->budgetcomp->name), 'approved_date', 'remark', array('label' => 'Issued By', 'value' => $model->issuer->name), array('label' => 'Payment Status', 'value' => $model->payment->name), 'payment_date')));
}
//----- end new code --------------------
?>
<?php
$this->widget('bootstrap.widgets.BootGridView', array('id' => 'aPorder-detail-grid', 'dataProvider' => aPorderDetail::model()->search($_GET['id']), 'itemsCssClass' => 'table table-striped table-bordered', 'template' => '{items}{pager}', 'columns' => array(array('class' => 'BootButtonColumn', 'template' => '{my_delete}', 'buttons' => array('my_delete' => array('label' => '<i class="icon-trash"></i', 'url' => 'Yii::app()->createUrl("/m1/aPorder/deleteDetail", array("id"=>$data->id))', 'visible' => '$data->po->approved_date == null'))), array('header' => 'Department', 'value' => 'isset($data->department) ? $data->department->name : "ALL"'), array('header' => 'Budget SubComp.', 'value' => '$data->budget->code .". ".$data->budget->name'), 'description', array('value' => '$data->amountf()', 'name' => 'amount', 'htmlOptions' => array('style' => 'text-align: right; padding-right: 5px;')), array('header' => 'Total', 'value' => '$data->totalf()', 'name' => 'amount', 'htmlOptions' => array('style' => 'text-align: right; padding-right: 5px;')))));
?>
<br />
<b> Total: <?php
echo $model->sum_pof();
?>
</b>
function report($id, $pro_id)
{
$criteria = new CDbCriteria();
$criteria->order = 'code';
$criteria->compare('department_id', $pro_id);
$criteria->compare('parent_id', $id);
//$criteria->compare('amount!',0);
$criteria->addNotInCondition('id', array(193, 119, 164, 198));
$models = aBudget::model()->findAll($criteria);
$this->myheader($id, $pro_id);
//$w=array(15,40,23,23,23,23,23,23);
$w = array(15, 60, 23, 23, 23, 23, 23, 23);
$this->SetFont('Arial', '', 8);
foreach ($models as $model) {
$_amount = $model->amount;
$_real = aBudget::model()->allComponent($model->id, 2012, 1);
$_paid = aBudget::model()->allComponentPaid($model->id, 2012, 1);
$_unpaid = $_real - $_paid;
$_endBalance = isset($model->end_balance) ? $model->end_balance->balance : $_amount;
$this->SetFont('Arial', 'B', 8);
$this->Cell($w[0] + $w[1], 6, $model->code . ". " . $model->name, 'LT');
$this->Cell($w[2], 6, '', 'T');
$this->Cell($w[3], 6, number_format($_amount, 0, ',', '.'), 'TLR', 0, 'R');
$this->Cell($w[4], 6, '', 'T', 0, 'R');
//$this->Cell($w[5],6,number_format($_paid,2,',','.'),'T',0,'R');
//$this->Cell($w[6],6,number_format($_unpaid,2,',','.'),'T',0,'R');
//$this->Cell($w[5],6,'','T',0,'R');
//$this->Cell($w[6],6,'','T',0,'R');
$this->Cell($w[7], 6, number_format($_endBalance, 0, ',', '.'), 'TLR', 0, 'R');
$this->Ln();
$_total = 0;
foreach ($model->ch as $mod) {
$this->SetFont('Arial', '', 6);
$this->Cell($w[0] + $w[1], 4, ' ' . $mod->name, 'L');
$this->Cell($w[2], 4, '');
$this->Cell($w[3], 4, number_format($mod->amount, 0, ',', '.'), 'LR', 0, 'R');
$crit = new CDbCriteria();
$crit->with = array('po_detail');
$crit->condition = 'approved_date is not null';
$crit->compare('po_detail.budget_id', $mod->id);
$modelT1 = aPorderDetail::model()->countBySql('
SELECT SUM(a.amount) AS total
FROM a_porder_detail a INNER JOIN a_porder b ON a.parent_id = b.id
WHERE b.approved_date IS NOT NULL
GROUP BY a.budget_id
HAVING a.budget_id =
' . $mod->id);
$this->Cell($w[4], 4, number_format($modelT1, 0, ',', '.'), 0, 0, 'R');
$_balance1 = $mod->amount - $modelT1;
//$this->Cell($w[5],4,'',0,0,'R');
//$this->Cell($w[6],4,'',0,0,'R');
$this->Cell($w[7], 4, number_format($_balance1, 0, ',', '.'), 'LR', 0, 'R');
$this->Ln();
$_total = $_total + $modelT1;
foreach ($mod->ch as $m) {
$this->SetFont('Arial', '', 6);
$this->Cell($w[0] + $w[1], 4, ' ' . $m->name, 'L');
$this->Cell($w[2], 4, '');
$this->Cell($w[3], 4, number_format($m->amount, 0, ',', '.'), 'LR', 0, 'R');
$modelT2 = aPorderDetail::model()->countBySql('
SELECT SUM(a.amount) AS total
FROM a_porder_detail a INNER JOIN a_porder b ON a.parent_id = b.id
WHERE b.approved_date IS NOT NULL
GROUP BY a.budget_id
HAVING a.budget_id =
' . $m->id);
$this->Cell($w[4], 4, number_format($modelT2, 0, ',', '.'), 0, 0, 'R');
$_balance2 = $m->amount - $modelT2;
//$this->Cell($w[5],4,'',0,0,'R');
//$this->Cell($w[6],4,'',0,0,'R');
$this->Cell($w[7], 4, number_format($_balance2, 0, ',', '.'), 'LR', 0, 'R');
$this->Ln();
$_total = $_total + $modelT2;
if ($this->GetY() >= 250) {
$this->Cell(array_sum($w) - 46, 4, '', 'T');
$this->AddPage();
$this->myheader($id, $pro_id);
}
}
if ($this->GetY() >= 250) {
$this->Cell(array_sum($w) - 46, 4, '', 'T');
$this->AddPage();
$this->myheader($id, $pro_id);
}
}
//*
$this->SetFont('Arial', 'B', 6);
$this->Cell($w[0] + $w[1], 4, 'Check Balance', 'L');
$this->Cell($w[2], 4, '');
$this->Cell($w[3], 4, '', 'L');
$this->Cell($w[4], 4, number_format($_total, 0, ',', '.'), 'L', 0, 'R');
$_checkbalance = $model->amount - $_total;
//$this->Cell($w[5],4,'',0,0,'R');
//$this->Cell($w[6],4,'',0,0,'R');
$this->Cell($w[7], 4, number_format($_checkbalance, 0, ',', '.'), 'LR', 0, 'R');
$this->Ln();
//*/
$this->Cell(array_sum($w) - 46, 4, '', 'T');
$this->Ln(1);
}
}
public function actionDeleteDetail($id)
{
$model = aPorderDetail::model()->with('po')->findByPk($id);
if ($model->po->approved_date == null) {
$model->delete();
}
$this->redirect(array('/aPorder/view', 'id' => $model->parent_id));
}
