$kdsatker = $col[1][$k]; $sql = "select KDGIAT,sum(JUMLAH) as pagu_giat from {$table} WHERE THANG = '{$th}' and KDSATKER = '{$kdsatker}' group by KDGIAT order by KDGIAT"; $aGiat = mysql_query($sql); while ($Giat = mysql_fetch_array($aGiat)) { $real_giat_bulan_1 = real_giat_spm_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 1) / 1000000; $real_giat_bulan_2 = real_giat_spm_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 2) / 1000000; $real_giat_bulan_3 = real_giat_spm_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 3) / 1000000; $real_giat_bulan_4 = real_giat_spm_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 4) / 1000000; $real_giat_bulan_5 = real_giat_spm_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 5) / 1000000; $real_giat_bulan_6 = real_giat_spm_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 6) / 1000000; $real_giat_bulan_7 = real_giat_spm_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 7) / 1000000; $real_giat_bulan_8 = real_giat_spm_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 8) / 1000000; $real_giat_bulan_9 = real_giat_spm_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 9) / 1000000; $real_giat_bulan_10 = real_giat_spm_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 10) / 1000000; $real_giat_bulan_11 = real_giat_spm_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 11) / 1000000; $real_giat_bulan_12 = real_giat_spm_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 12) / 1000000; $kdgiat = $Giat['KDGIAT']; $sql = "select \tsum(RPHPAGU) as RPHPAGU,\r\n\t\t\t\t\tsum(JML01) as JML01,\r\n\t\t\t\t\tsum(JML01+JML02) as JML02,\r\n\t\t\t\t\tsum(JML01+JML02+JML03) as JML03,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04) as JML04,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05) as JML05,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06) as JML06,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07) as JML07,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08) as JML08,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09) as JML09,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09+JML10) as JML10,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09+JML10+JML11) as JML11,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09+JML10+JML11+JML12) as JML12\r\n\t\t\t\t\tfrom d_trktrm WHERE THANG='{$th}' AND KDSATKER = '{$kdsatker}' AND KDGIAT = '{$kdgiat}' group by KDGIAT"; $aTarik = mysql_query($sql); $Tarik = mysql_fetch_array($aTarik); ?> <tr class="<?php echo $class; ?> "> <td rowspan="2" align="left" valign="top"><?php if ($Giat['kdunitkerja'] != $kdunitkerja) { ?> <font color="#0000FF"><?php echo strtoupper(nm_unit($Giat['kdunitkerja'])); ?>
$sql = "select KDGIAT, sum(JUMLAH) as pagu_giat from {$table} WHERE THANG = '{$th}' and KDSATKER = '{$kdsatker}' group by KDGIAT order by KDGIAT"; $aGiat = mysql_query($sql); while ($Giat = mysql_fetch_array($aGiat)) { $real_giat_bulan_1 = real_giat_spm_bulan($th, $kdsatker, $Giat['KDGIAT'], 1); $real_giat_bulan_2 = real_giat_spm_bulan($th, $kdsatker, $Giat['KDGIAT'], 2); $real_giat_bulan_3 = real_giat_spm_bulan($th, $kdsatker, $Giat['KDGIAT'], 3); $real_giat_bulan_4 = real_giat_spm_bulan($th, $kdsatker, $Giat['KDGIAT'], 4); $real_giat_bulan_5 = real_giat_spm_bulan($th, $kdsatker, $Giat['KDGIAT'], 5); $real_giat_bulan_6 = real_giat_spm_bulan($th, $kdsatker, $Giat['KDGIAT'], 6); $real_giat_bulan_7 = real_giat_spm_bulan($th, $kdsatker, $Giat['KDGIAT'], 7); $real_giat_bulan_8 = real_giat_spm_bulan($th, $kdsatker, $Giat['KDGIAT'], 8); $real_giat_bulan_9 = real_giat_spm_bulan($th, $kdsatker, $Giat['KDGIAT'], 9); $real_giat_bulan_10 = real_giat_spm_bulan($th, $kdsatker, $Giat['KDGIAT'], 10); $real_giat_bulan_11 = real_giat_spm_bulan($th, $kdsatker, $Giat['KDGIAT'], 11); $real_giat_bulan_12 = real_giat_spm_bulan($th, $kdsatker, $Giat['KDGIAT'], 12); $real_giat_sdbulan = real_giat_spm_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 12); $kdgiat = $Giat['KDGIAT']; $sql = "select \tsum(RPHPAGU) as RPHPAGU,\r\n\t\t\t\t\tsum(JML01) as JML01,\r\n\t\t\t\t\tsum(JML02) as JML02,\r\n\t\t\t\t\tsum(JML03) as JML03,\r\n\t\t\t\t\tsum(JML04) as JML04,\r\n\t\t\t\t\tsum(JML05) as JML05,\r\n\t\t\t\t\tsum(JML06) as JML06,\r\n\t\t\t\t\tsum(JML07) as JML07,\r\n\t\t\t\t\tsum(JML08) as JML08,\r\n\t\t\t\t\tsum(JML09) as JML09,\r\n\t\t\t\t\tsum(JML10) as JML10,\r\n\t\t\t\t\tsum(JML11) as JML11,\r\n\t\t\t\t\tsum(JML12) as JML12\r\n\t\t\t\t\tfrom d_trktrm WHERE THANG='{$th}' AND KDSATKER = '{$kdsatker}' AND KDGIAT = '{$kdgiat}' group by KDGIAT"; $aTarik = mysql_query($sql); $Tarik = mysql_fetch_array($aTarik); ?> <tr class="<?php echo $class; ?> "> <td rowspan="2" align="center"><font color="#0000FF"><?php echo $Giat['KDGIAT']; ?> </font></td> <td rowspan="2" align="left" valign="top"><font color="#0000FF"><?php echo nm_giat($Giat['KDGIAT']);