<?php
/* @var $this PerjalananController */
/* @var $model Perjalanan */
?>
<?php
Yii::app()->clientScript->registerScript('search', "\r\n\$('.search-button').click(function(){\r\n\t\$('.search-form').toggle();\r\n\treturn false;\r\n});\r\n\$('.search-form form').submit(function(){\r\n\t\$('#material-grid').yiiGridView('update', {\r\n\t\tdata: \$(this).serialize()\r\n\t});\r\n\treturn false;\r\n});\r\n");
?>
<h1>Buat PO Perjalanan Baru - Step 4 : Finalisasi Proses PO - <?php
echo $model->iDKENDARAAN->NOPOL;
?>
</h1>
<?php
$this->renderPartial('/relasi_po/view3', array('model' => RelasiPo::model(), "id" => $model->ID_PERJALANAN));
?>
<div class="form">
<?php
$form = $this->beginWidget('CActiveForm', array('id' => 'perjalanan-form', 'enableAjaxValidation' => false));
?>
<p class="note">Kolom dengan tanda <span class="required">*</span> harus diisi.</p>
<?php
echo $form->errorSummary($model);
?>
<div class="row">
<?php
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer $id the ID of the model to be loaded
* @return RelasiPo the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = RelasiPo::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
<?php
/* @var $this Relasi_poController */
/* @var $model RelasiPo */
$this->breadcrumbs = array('Relasi Pos' => array('index'), $model->ID_RELASI_PO);
$model2 = Perjalanan::model()->findByPk($id);
?>
<h1>Daftar Tujuan PO Perjalanan # <?php
echo $id . " - " . $model2->iDKENDARAAN->NOPOL;
?>
</h1>
<?php
$this->widget('bootstrap.widgets.TbGridView', array('id' => 'relasi_po-grid', 'type' => TbHtml::GRID_TYPE_HOVER, 'dataProvider' => $model->search2($id), 'template' => "{items}\n{pager}", 'columns' => array(array('header' => 'No', 'value' => '$this->grid->dataProvider->pagination->currentPage*$this->grid->dataProvider->pagination->pageSize + $row+1'), array('name' => 'Tujuan', 'value' => '$data->iDONGKOS->TUJUAN', 'footer' => "Total Ritase: "), array('name' => 'Ongkos', 'value' => '$data->iDONGKOS->HARGA', 'footer' => RelasiPo::model()->hitungtotalongkos($model->search2($id)->getData())), array('header' => 'Aksi', 'type' => 'raw', 'value' => 'CHtml::link(\'batal\', array(\'relasi_po/batal\', \'id\'=>$data->ID_RELASI_PO,\'perj\'=>$_GET[\'id\']))'))));
<?php
/* @var $this Relasi_poController */
/* @var $model RelasiPo */
$this->breadcrumbs = array('Relasi Pos' => array('index'), $model->ID_RELASI_PO);
$model2 = Perjalanan::model()->findByPk($id);
?>
<h1>Daftar Tujuan PO Perjalanan # <?php
echo $id . " - " . $model2->iDKENDARAAN->NOPOL;
?>
</h1>
<?php
$this->widget('bootstrap.widgets.TbGridView', array('id' => 'relasi_po-grid', 'type' => TbHtml::GRID_TYPE_HOVER, 'dataProvider' => $model->search2($id), 'template' => "{items}\n{pager}", 'columns' => array(array('header' => 'No', 'value' => '$this->grid->dataProvider->pagination->currentPage*$this->grid->dataProvider->pagination->pageSize + $row+1'), array('name' => 'Tujuan', 'value' => '$data->iDONGKOS->TUJUAN', 'footer' => "Total Ritase + Tambahan: "), array('name' => 'Jenis', 'value' => function ($data, $row) {
if ($data->iDONGKOS->JENIS_ONGKOS == 0) {
return "Utama";
} else {
if ($data->iDONGKOS->JENIS_ONGKOS == 1) {
return "Tambahan";
}
}
}), array('name' => 'Ongkos', 'value' => '$data->iDONGKOS->HARGA', 'footer' => RelasiPo::model()->hitungtotalongkos($model->search2($id)->getData())), array('header' => 'Aksi', 'type' => 'raw', 'value' => function ($data, $row) {
if ($data->iDONGKOS->JENIS_ONGKOS == 0) {
return "";
} else {
if ($data->iDONGKOS->JENIS_ONGKOS == 1) {
return CHtml::link('batal', array('relasi_po/batal2', 'id' => $data->ID_RELASI_PO, 'perj' => $_GET['id']));
}
}
}))));
<?php
/* @var $this Relasi_poController */
/* @var $model RelasiPo */
$this->breadcrumbs = array('Relasi Pos' => array('index'), $model->ID_RELASI_PO);
$model2 = Perjalanan::model()->findByPk($id);
?>
<h1>Daftar Tujuan PO Perjalanan # <?php
echo $id . " - " . $model2->iDKENDARAAN->NOPOL;
?>
</h1>
<?php
$this->widget('bootstrap.widgets.TbGridView', array('id' => 'relasi_po-grid', 'type' => TbHtml::GRID_TYPE_HOVER, 'dataProvider' => $model->search2($id), 'template' => "{items}\n{pager}", 'columns' => array(array('header' => 'No', 'value' => '$this->grid->dataProvider->pagination->currentPage*$this->grid->dataProvider->pagination->pageSize + $row+1'), array('name' => 'Tujuan', 'value' => '$data->iDONGKOS->TUJUAN', 'footer' => "Total Ritase + Tambahan: "), array('name' => 'Jenis', 'value' => function ($data, $row) {
if ($data->iDONGKOS->JENIS_ONGKOS == 0) {
return "Utama";
} else {
if ($data->iDONGKOS->JENIS_ONGKOS == 1) {
return "Tambahan";
}
}
}), array('name' => 'Ongkos', 'value' => '$data->iDONGKOS->HARGA', 'footer' => RelasiPo::model()->hitungtotalongkos($model->search2($id)->getData())))));
public function actionInsert2($id, $perj)
{
$isi = Yii::app()->db->createCommand()->select('COUNT(*)')->from('relasi_po')->where('ID_PERJALANAN=:ID_PERJALANAN AND ID_ONGKOS=:ID_ONGKOS', array(':ID_PERJALANAN' => $perj, ':ID_ONGKOS' => $id))->queryScalar();
$idrel = Yii::app()->db->createCommand()->select('ID_RELASI_PO')->from('relasi_po')->where('ID_PERJALANAN=:ID_PERJALANAN AND ID_ONGKOS=:ID_ONGKOS', array(':ID_PERJALANAN' => $perj, ':ID_ONGKOS' => $id))->queryScalar();
$ritase = Yii::app()->db->createCommand()->select('TAMBAHAN')->from('perjalanan')->where('ID_PERJALANAN=:ID_PERJALANAN', array(':ID_PERJALANAN' => $perj))->queryScalar();
if ($isi == 0) {
Yii::app()->db->createCommand()->insert('relasi_po', array('ID_PERJALANAN' => $perj, 'ID_ONGKOS' => $id));
$harga = Yii::app()->db->createCommand()->select('HARGA')->from('ongkos')->where('ID_ONGKOS=:ID_ONGKOS', array(':ID_ONGKOS' => $id))->queryScalar();
if ($ritase == NULL) {
$ritase = $harga;
} else {
if ($ritase != NULL) {
$ritase = $ritase + $harga;
}
}
} else {
if ($isi > 0) {
RelasiPo::model()->updateByPk($idrel, array('ID_PERJALANAN' => $perj, 'ID_ONGKOS' => $id));
}
}
Perjalanan::model()->updateByPk($perj, array("TAMBAHAN" => $ritase));
$this->redirect(array('perjalanan/create3', 'id' => $perj));
}
