<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
?> <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/>
<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;