<h1>Detail Pengadaan #<?php
echo $model->ID_PENGADAAN;
?>
</h1>
<?php
$this->widget('bootstrap.widgets.TbGridView', array('id' => 'pengadaan-grid', 'type' => TbHtml::GRID_TYPE_HOVER, 'dataProvider' => $model->search(), 'template' => "{items}\n{pager}", 'columns' => array(array('header' => 'No', 'value' => '$this->grid->dataProvider->pagination->currentPage*$this->grid->dataProvider->pagination->pageSize + $row+1'), array('name' => 'No Po', 'value' => '$data->NO_PO'), array('name' => 'Tgl Pengadaan', 'value' => '$data->TGL_PENGADAAN'), array('name' => 'Permintaan', 'value' => '$data->PERMINTAAN'), array('name' => 'Nama Toko', 'value' => '$data->NAMA_TOKO'), array('name' => 'No Telp', 'value' => '$data->NO_TLP'), array('name' => 'Harga Total', 'value' => '$data->HARGA_TOTAL'))));
?>
<?php
$this->renderPartial('/relasiPengadaanSparepart/view', array('model' => RelasiPengadaanSparepart::model(), "id" => $model->ID_PENGADAAN));
echo "Setuju?";
echo TbHtml::submitButton('SETUJU', array('submit' => array("setuju", "id" => $model->ID_PENGADAAN), 'color' => TbHtml::BUTTON_COLOR_PRIMARY));
/**
* 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 RelasiPengadaanSparepart the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = RelasiPengadaanSparepart::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
<?php
Yii::app()->clientScript->registerScript('search', "\n\$('.search-button').click(function(){\n\t\$('.search-form').toggle();\n\treturn false;\n});\n\$('.search-form form').submit(function(){\n\t\$('#sparepart-grid').yiiGridView('update', {\n\t\tdata: \$(this).serialize()\n\t});\n\treturn false;\n});\n");
?>
<h1>Daftar Spareparts</h1>
<?php
$this->widget('bootstrap.widgets.TbGridView', array('id' => 'sparepart-grid', 'type' => TbHtml::GRID_TYPE_HOVER, 'dataProvider' => $model->search(), 'filter' => $model, 'columns' => array(array('header' => 'No', 'value' => '$this->grid->dataProvider->pagination->currentPage*$this->grid->dataProvider->pagination->pageSize + $row+1'), array('name' => 'NAMA_BARANG', 'header' => 'Nama Barang'), array('header' => 'Harga Satuan', 'value' => '$data->HARGA_SATUAN'), array('header' => 'Stok', 'value' => '$data->STOK'), array('header' => 'Aksi', 'type' => 'raw', 'value' => 'CHtml::link(\'pilih\', array(\'sparepart/insert\', \'id\'=>$data->ID_SPAREPART,\'peng\'=>$_GET[\'id\']))')), 'emptyText' => TbHtml::linkButton("Buat Nama Sparepart Baru", array("submit" => array("sparepart/create", "id" => $_GET["id"]), "color" => TbHtml::BUTTON_COLOR_INFO))));
?>
<p></p>
<?php
$id_2 = $_GET['id'];
$this->renderPartial('/relasiPengadaanSparepart/view', array('model' => RelasiPengadaanSparepart::model(), "id" => $id_2));
?>
<?php
$isi = Yii::app()->db->createCommand()->select('COUNT(*)')->from('relasi_pengadaan_sparepart')->where('ID_PENGADAAN=:ID_PENGADAAN', array(':ID_PENGADAAN' => $id_2))->queryScalar();
if ($isi != NULL) {
echo "Sudah selesai?";
echo TbHtml::submitButton('LANJUT', array('submit' => array("Pengadaan/lanjut", "id" => $id_2), 'color' => TbHtml::BUTTON_COLOR_PRIMARY));
}
public function actionSetuju($id)
{
$model = $this->loadModel($id);
$relasi = RelasiPengadaanSparepart::model()->findAllByAttributes(array('ID_PENGADAAN' => $id));
foreach ($relasi as $rel) {
$stok = Yii::app()->db->createCommand()->select('STOK')->from('sparepart')->where('ID_SPAREPART=:ID_SPAREPART', array(':ID_SPAREPART' => $rel->ID_SPAREPART))->queryScalar();
if ($stok == NULL) {
$stok = $rel->JUMLAH;
} else {
$stok = $stok + $rel->JUMLAH;
}
Sparepart::model()->updateByPk($rel->ID_SPAREPART, array("STOK" => $stok));
}
Pengadaan::model()->updateByPk($id, array("STATUS" => "DISETUJUI KEUANGAN"));
$this->redirect(array('admin'));
}
public function actionInsert($id, $peng)
{
$isi = Yii::app()->db->createCommand()->select('COUNT(*)')->from('relasi_pengadaan_sparepart')->where('ID_PENGADAAN=:ID_PENGADAAN AND ID_SPAREPART=:ID_SPAREPART', array(':ID_PENGADAAN' => $peng, ':ID_SPAREPART' => $id))->queryScalar();
$idrel = Yii::app()->db->createCommand()->select('ID_RELASI')->from('relasi_pengadaan_sparepart')->where('ID_PENGADAAN=:ID_PENGADAAN AND ID_SPAREPART=:ID_SPAREPART', array(':ID_PENGADAAN' => $peng, ':ID_SPAREPART' => $id))->queryScalar();
$total = Yii::app()->db->createCommand()->select('HARGA_TOTAL')->from('pengadaan')->where('ID_PENGADAAN=:ID_PENGADAAN', array(':ID_PENGADAAN' => $peng))->queryScalar();
if ($isi == 0) {
Yii::app()->db->createCommand()->insert('relasi_pengadaan_sparepart', array('ID_PENGADAAN' => $peng, 'ID_SPAREPART' => $id));
$harga = Yii::app()->db->createCommand()->select('HARGA_SEMENTARA')->from('relasi_pengadaan_sparepart')->where('ID_PENGADAAN=:ID_PENGADAAN', array(':ID_PENGADAAN' => $peng))->queryScalar();
if ($total == NULL) {
$total = $harga;
} else {
if ($total != NULL) {
$total = $total + $harga;
}
}
} else {
if ($isi > 0) {
RelasiPengadaanSparepart::model()->updateByPk($idrel, array('ID_PENGADAAN' => $peng, 'ID_SPAREPART' => $id));
}
}
Pengadaan::model()->updateByPk($peng, array("HARGA_TOTAL" => $total));
$this->redirect(array('sparepart/admin', 'id' => $peng));
}
