<th>Rupiah</th> <th>%</th> <th>Rupiah</th> <th>%</th> <th>Detil</th> </tr> </thead> <tbody> <?php if ($xlevel != 3 and $xlevel != 4 and $xlevel != 5 and $xlevel != 6 and $xlevel != 7 and $xlevel != 8) { //----------------------------- $sql = "select sum(NILMAK) as real_menteri from m_spmmak WHERE THANG='$th' AND left(KDAKUN,1) = '5' group by THANG"; $aMenteri = mysql_query($sql); $Menteri = mysql_fetch_array($aMenteri); $pagu_menteri = pagu_menteri($th); $real_menteri_spm = real_menteri_spm($th, $kddept, $kdunit); $real_menteri_sp2d = real_menteri_sp2d($th, $kddept, $kdunit); ?> <tr> <td align="center"><font color="#009933"><strong><?php echo $kddept; ?> </strong></font></td> <td align="left"><font color="#009933"><strong><?php echo strtoupper(nm_unit($kdmenteri)); ?> </strong></font></td> <td align="right"><font color="#009933"><strong><?php echo number_format($pagu_menteri, "0", ",", "."); ?> </strong></font></td> <td align="right"><font color="#009933"><strong><?php
$real_spm = real_satker_spm($th, $kdsatker); break; case 8: $teks_1 = 'Pimpinan'; $teks_2 = nm_unit(substr($xusername, 3, 7)); $kdsatker = kd_satker(substr($xusername, 3, 7)); $pagu = pagu_satker($th, $kdsatker); $real_sp2d = real_satker_sp2d($th, $kdsatker); $real_spm = real_satker_spm($th, $kdsatker); break; case 9: $teks_1 = $xusername; $teks_2 = 'DIREKTORAT JENDERAL KEBUDAYAAN'; $kdsatker = ''; $pagu = pagu_menteri($th); $real_sp2d = real_menteri_sp2d($th, '023', '15'); $real_spm = real_menteri_spm($th, '023', '15'); break; } echo "<strong><font color='#993300' size = '2'> Realisasi Anggaran <br>" . $teks_2 . "</font></strong>"; $sql = "select KDDEPT, KDUNIT from setup_dept "; $aDept = mysql_query($sql); $Dept = mysql_fetch_array($aDept); $kddept = $Dept['KDDEPT']; $kdunit = $Dept['KDUNIT']; if ($kdsatker == '') { $sql = "select sum(RPHPAGU) as RPHPAGU,\r\n\t\t\t\t\tsum(JML01) as JML_1,\r\n\t\t\t\t\tsum(JML01+JML02) as JML_2,\r\n\t\t\t\t\tsum(JML01+JML02+JML03) as JML_3,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04) as JML_4,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05) as JML_5,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06) as JML_6,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07) as JML_7,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08) as JML_8,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09) as JML_9,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09+JML10) as JML_10,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09+JML10+JML11) as JML_11,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09+JML10+JML11+JML12) as JML_12\r\n\t\t\t\t\tfrom d_trktrm WHERE THANG = '{$th}' group by THANG"; } else { $sql = "select sum(RPHPAGU) as RPHPAGU,\r\n\t\t\t\t\tsum(JML01) as JML_1,\r\n\t\t\t\t\tsum(JML01+JML02) as JML_2,\r\n\t\t\t\t\tsum(JML01+JML02+JML03) as JML_3,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04) as JML_4,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05) as JML_5,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06) as JML_6,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07) as JML_7,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08) as JML_8,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09) as JML_9,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09+JML10) as JML_10,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09+JML10+JML11) as JML_11,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09+JML10+JML11+JML12) as JML_12\r\n\t\t\t\t\tfrom d_trktrm WHERE THANG = '{$th}' and KDSATKER = '{$kdsatker}' group by THANG"; } $aGiat = mysql_query($sql);