public function actionBatal2($id, $perj) { $models = Perjalanan::model()->findByPk($perj); $model = $this->loadModel($id); $ritasebaru = $models->TAMBAHAN - $model->iDONGKOS->HARGA; Perjalanan::model()->updateByPk($perj, array("TAMBAHAN" => $ritasebaru)); $this->loadModel($id)->delete(); $this->redirect(array('perjalanan/create3', 'id' => $perj)); // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser }
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)); }
<?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\']))'))));
/** * 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 Perjalanan the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Perjalanan::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }