?>
<style type="text/css">
body{
font-size: 13px;
}
</style>
<?php
$no = 1;
foreach ($model2 as $data) {
$transport = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $data->id_personil . ' and kat_biaya_id=1')->one();
$taksi = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $data->id_personil . ' and kat_biaya_id=2')->one();
$uhr = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $data->id_personil . ' and kat_biaya_id=4')->one();
$saku = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $data->id_personil . ' and kat_biaya_id=5')->one();
$rep = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $data->id_personil . ' and kat_biaya_id=8')->one();
$inap = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $data->id_personil . ' and kat_biaya_id=6')->one();
?>
<table>
<tr>
<td>
<h5 align="left"><img src="<?php
echo Url::to(['/images/logo_bp.png']);
?>
" width="60px"/></h5>
</td>
<td style="font-weight: bold;">
<b> BADAN PENGAWAS TENAGA NUKLIR </b><br/>
public function actionTambahluar($id)
{
$model = new SimpelPersonil();
$model2 = $this->findModel($id);
$model3 = new SimpelRincianBiaya();
if ($_POST) {
$model->id_kegiatan = $model2->id_kegiatan;
$model->tingkat_id = $_POST['SimpelPersonil']['tingkat_id'];
$model->pegawai_id = $_POST['SimpelPersonil']['pegawai_id'];
$model->tgl_penugasan = $_POST['SimpelPersonil']['tgl_penugasan'];
$model->tgl_berangkat = $_POST['SimpelKeg']['tgl_mulai'];
$model->tgl_kembali = $_POST['SimpelKeg']['tgl_selesai'];
$model->no_sp = $_POST['SimpelPersonil']['no_sp'];
$model->pejabat = $_POST['SimpelPersonil']['pejabat'];
$model->uang_makan = $_POST['SimpelPersonil']['uang_makan'];
$model->angkutan = $_POST['SimpelPersonil']['angkutan'];
if ($model->save()) {
$data = count($_POST['rows']);
for ($i = 1; $i <= $data; $i++) {
$model3 = new SimpelRincianBiaya();
$model3->id_kegiatan = $model2->id_kegiatan;
$model3->personil_id = $model->getId();
$model3->kat_biaya_id = $_POST['kat_biaya_id' . $i];
$model3->harga_satuan = $_POST['satuan' . $i];
$model3->volume = $_POST['volume' . $i];
$model3->label = $_POST['label' . $i];
$model3->jml = $_POST['jml' . $i];
$model3->uraian_rincian = $_POST['uraian' . $i];
$model3->bukti_kwitansi = $_POST['bukti_kwitansi' . $i];
$model3->save();
}
}
return $this->redirect(['create', 'id' => $model2->id_kegiatan]);
} else {
return $this->renderAjax('input_luar_negri', ['model' => $model, 'model2' => $model2]);
}
}
public function actionLuar($id)
{
$model = $this->findModel($id);
$model2 = \backend\models\SimpelKeg::find()->where('id_kegiatan=' . $model->id_kegiatan)->one();
if ($_POST) {
// print_r($_POST);
// die();
$model->pegawai_id = $_POST['SimpelPersonil']['pegawai_id'];
$model->tingkat_id = $_POST['SimpelPersonil']['tingkat_id'];
$model->tgl_penugasan = $_POST['SimpelPersonil']['tgl_penugasan'];
$model->tgl_berangkat = $_POST['SimpelPersonil']['tgl_berangkat'];
$model->tgl_kembali = $_POST['SimpelPersonil']['tgl_kembali'];
$model->no_sp = $_POST['SimpelPersonil']['no_sp'];
$model->pejabat = $_POST['SimpelPersonil']['pejabat'];
$model->uang_makan = $_POST['SimpelPersonil']['uang_makan'];
$model->angkutan = $_POST['SimpelPersonil']['angkutan'];
if ($model->save()) {
$data = count($_POST['rows']);
for ($i = 1; $i <= $data; $i++) {
$model3 = SimpelRincianBiaya::findOne($_POST['id_rincian_biaya' . $i]);
$model3->id_kegiatan = $model2->id_kegiatan;
$model3->kat_biaya_id = $model3->kat_biaya_id;
$model3->harga_satuan = $_POST['satuan' . $i];
$model3->bukti_kwitansi = $_POST['bukti_kwitansi' . $i];
$model3->volume = $_POST['volume' . $i];
$model3->jml = $_POST['jml' . $i];
$model3->uraian_rincian = $_POST['uraian_rincian' . $i];
$model3->save();
}
// die();
}
return $this->redirect(['/simpel-keg/create', 'id' => $model->id_kegiatan]);
} else {
switch ($model2->negara) {
case "1":
return $this->renderAjax('input', ['model' => $model, 'model2' => $model2]);
case "2":
return $this->renderAjax('input_luar', ['model' => $model, 'model2' => $model2]);
break;
}
}
}
<th rowspan="2">Lama </th>
<th colspan="6"><center>Biaya</center></th>
</tr>
<tr>
<th width="100">Transport </th>
<th width="100" >Taksi</th>
<th width="100">Uang Harian</th>
<th width="100" rowspan="1">Representatif </th>
<th width="100" rowspan="1">Penginapan </th>
<th width="100" rowspan="1">Jumlah </th>
</tr>
<?php
$no = 1;
foreach ($models as $data) {
$biaya = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $data->id_personil . ' and kat_biaya_id in (1,2,4,8,6)')->all();
$count = Yii::$app->db->createCommand("SELECT sum(jml) from simpel_rincian_biaya where personil_id='" . $data->id_personil . "' and kat_biaya_id in (1,2,4,8,6) ")->queryScalar();
?>
<tr>
<td align="center"><?php
echo $no;
?>
</td>
<td align="left">
<?php
echo $data->no_sp;
?>
<br/>
<?php
<tr>
<td>Jumlah DL Hari Kerja</td>
<td valign="top">:</td>
<td><?php
echo $key->uang_makan;
?>
Hari</td>
</tr>
</tbody></table>
</td>
<td style="width:9000%;">
<?php
$data = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $key->id_personil . ' and kat_biaya_id in(11,12,13,14,15,16) ')->all();
?>
<table style="width:100%">
<tbody>
<?php
foreach ($data as $rin) {
?>
<tr>
<td style="width:40%;"><?php
echo $rin->biaya->nama;
?>
</td>
<td valign="top">:</td>
<td>
Rp .<?php
if (!empty($rin->kat_biaya_id)) {
</colgroup><tbody>
<tr valign="top">
<td width="7%" style="border-top: 2px solid black; font-weight: bold; text-align: center; border-bottom: 2px solid black; border-left: 2px solid black; border-right: none; padding-top: 0.04in; padding-bottom: 0.04in; padding-left: 0.04in; padding-right: 0in">
<p align="center">No</p>
</td>
<td width="70%" style="border-top: 2px solid black; font-weight: bold; text-align: center; border-bottom: 2px solid black; border-left: 2px solid black; border-right: none; padding-top: 0.04in; padding-bottom: 0.04in; padding-left: 0.04in; padding-right: 0in">
<p align="center">Uraian</p>
</td>
<td width="22%" style="border: 2px solid black; font-weight: bold; text-align: center; padding: 0.04in">
<p align="center">Jumlah</p>
</td>
</tr>
</tbody>
<tbody>
<?php
$rincian = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $mode->id_personil . ' and bukti_kwitansi=2')->all();
$n = 1;
foreach ($rincian as $key) {
?>
<tr valign="top">
<td valign="top" width="7%" style="border-top: none; text-align:center; border-bottom: none; border-left: 2px solid black; border-right: none; padding-top: 0in; padding-bottom: 0in; padding-left: 0.04in; padding-right: 0in">
<p align="center"><?php
echo $n;
?>
</p> <br/><br/>
</td>
<td valign="top" width="70%" style="border-top: none; border-bottom: none; border-left: 2px solid black; border-right: none; padding-top: 0in; padding-bottom: 0in; padding-left: 0.04in; padding-right: 0in">
<p style="padding-top:-30px;">
<?php
echo $key->label;
?>
<tr>
<td>Jumlah DL Hari Kerja</td>
<td valign="top">:</td>
<td><?php
echo $key->uang_makan;
?>
Hari</td>
</tr>
</tbody></table>
</td>
<td style="width:9000%;">
<?php
$data = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $key->id_personil . ' and kat_biaya_id in(1,2,3,4,5,6,7,8,9) ')->all();
?>
<table style="width:100%">
<tbody>
<?php
foreach ($data as $rin) {
?>
<tr>
<td style="width:60%;"><?php
echo $rin->biaya->nama;
?>
</td>
<td valign="top">:</td>
<td>
Rp .<?php
if (!empty($rin->kat_biaya_id)) {
public function Jml($id)
{
$personil = \backend\models\SimpelPersonil::find();
$rincian = \backend\models\SimpelRincianBiaya::find();
$daftar = \backend\models\SimpelDafKatBiaya::find();
return $id;
}
break;
break;
}
?>
<br/>
</td>
<td valign="top" width="22%" style="text-align:center;border-top: none; border-bottom: none; border-left: 2px solid black; border-right: 2px solid black; padding: 0in 0.04in">
<p style="font-weight: bold;">
Rp.
<?php
switch ($key->kat_biaya_id) {
case '1':
echo '<u>' . number_format($key->jml, 0, ",", ".") . '</u>';
$rinc = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $data->id_personil . ' and bukti_kwitansi=1 and kat_biaya_id in (2,3) ')->all();
foreach ($rinc as $ke) {
echo "<br/>";
echo 'Rp. ' . number_format($ke->jml, 0, ",", ".");
echo "<br/>";
}
break;
default:
echo number_format($key->jml, 0, ",", ".");
break;
}
?>
</p>
</td>
<td valign="top" width="22%" style="text-align:center;border-top: none; border-bottom: none; border-left: 2px solid black; border-right: 2px solid black; padding: 0in 0.04in">
<tr style="background-color:#4e95f4;">
<td>No</td>
<td align="center">Kategori Pembiayian</td>
<td align="center">Bukti Kwitansi </td>
<td align="center">Volume </td>
<td align="center">Pagu</td>
<td align="center">%</td>
<td align="center">Harga Satuan</td>
<td align="center">Jumlah</td>
<td align="center">Uraian</td>
</tr>
<tbody id="container">
<!-- nanti rows nya muncul di sini -->
<?php
$no = 1;
$input = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $model->id_personil)->all();
foreach ($input as $ke) {
switch ($ke->kat_biaya_id) {
case "1":
echo '1';
break;
case "2":
echo '1';
break;
}
?>
<tr>
<td width="5%">
<?php
echo $no;
<th align="center" width="100">Tiket</th>
<th align="center" width="100" >Asuransi</th>
<th align="center" width="100">Airport tax </th>
</tr>
<?php
$no = 1;
foreach ($model2 as $data) {
$tiket = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $data->id_personil . ' and bukti_kwitansi in(1,2) and kat_biaya_id=13')->one();
$asuransi = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $data->id_personil . ' and bukti_kwitansi in(1,2) and kat_biaya_id=11')->one();
$tax = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $data->id_personil . ' and bukti_kwitansi in(1,2) and kat_biaya_id=12')->one();
$lumpsum = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $data->id_personil . ' and bukti_kwitansi in(1,2) and kat_biaya_id=14')->one();
$lumpsum1 = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $data->id_personil . ' and bukti_kwitansi in(1,2) and kat_biaya_id=15')->one();
$lumpsum2 = \backend\models\SimpelRincianBiaya::find()->where('personil_id=' . $data->id_personil . ' and bukti_kwitansi in(1,2) and kat_biaya_id=16')->one();
$jab = MyHelper::Pangkat($data->pegawai->gol_id);
?>
<tr>
<td rowspan="3" align="center"><?php
echo $no;
?>
</td>
<td rowspan="3" align="left">
<?php
echo $data->pegawai->nama;
?>
<br/>
NIP. <?php
echo $data->pegawai->nip;