<?php $sql = "select KDOUTPUT, sum(TOTNILMAK) as real_output from {$table} WHERE THANG='{$th}' and KDSATKER='{$kdsatker}' and KDGIAT='{$kdgiat}' and KDOUTPUT = '{$kdoutput}' group by KDOUTPUT order by KDOUTPUT"; $aOutput = mysql_query($sql); while ($Output = mysql_fetch_array($aOutput)) { ?> <tr class="<?php echo $class; ?> "> <td align="center"><font color="#FF0000"><?php echo $kdgiat . '.' . $Output['KDOUTPUT']; ?> </font></td> <td colspan="5" align="left"><font color="#FF0000"><?php echo nm_output_th($th, $kdgiat . $kdoutput); ?> </font></td> <td align="right"><font color="#FF0000"><?php echo number_format($Output['real_output'], "0", ",", "."); ?> </font></td> </tr> <?php $sql = "select NOSPM,TGSPM,NOSP2D,TGSP2D, sum(TOTNILMAK) as real_spm from {$table} WHERE THANG='{$th}' and KDSATKER='{$kdsatker}' and KDOUTPUT='{$kdoutput}' group by concat(NOSPM,NOSP2D) order by NOSPM,TGSPM"; $aSPM = mysql_query($sql); while ($SPM = mysql_fetch_array($aSPM)) { ?> <tr class="<?php echo $class; ?>
$aGiat = mysql_query($sql); $Giat = mysql_fetch_array($aGiat); $sql = "select kdoutput, sum(totnilmak) as real_output from {$table_1} WHERE thang='{$th}' and kdsatker='{$kdsatker}' and kdgiat='{$kdgiat}' group by kdoutput order by kdoutput"; $aOutput = mysql_query($sql); while ($Output = mysql_fetch_array($aOutput)) { ?> <tr class="<?php echo $class; ?> "> <td align="center"><font color="#FF0000"><?php echo $kdgiat . '.' . $Output['kdoutput']; ?> </font></td> <td colspan="3" align="left"><font color="#FF0000"><?php echo nm_output_th($th, $kdgiat . $Output['kdoutput']); ?> </font></td> <td align="right"><font color="#FF0000"><?php echo number_format($Output['real_output'], "0", ",", "."); ?> </font></td> </tr> <?php $sql = "select nospm,tgspm, sum(totnilmak) as real_spm from {$table_1} WHERE thang = '{$th}' and kdsatker = '{$kdsatker}' and kdoutput = '{$Output['kdoutput']}' group by nospm order by nospm "; $aSPM = mysql_query($sql); while ($SPM = mysql_fetch_array($aSPM)) { ?> <tr class="<?php echo $class; ?>
$sql = "select KDOUTPUT, sum(JUMLAH) as pagu_output from d_item WHERE KDDEPT = '{$kddept}' AND KDUNIT = '{$kdunit}' AND THANG = '{$th}' and KDSATKER = '{$kdsatker}' AND KDGIAT = '{$Giat['KDGIAT']}' GROUP BY KDOUTPUT ORDER BY KDOUTPUT"; $aOutput = mysql_query($sql); while ($Output = mysql_fetch_array($aOutput)) { $real_output_spm = real_output_spm($th, $kdsatker, $Giat['KDGIAT'], $Output['KDOUTPUT']); $real_output_sp2d = real_output_sp2d($th, $kdsatker, $Giat['KDGIAT'], $Output['KDOUTPUT']); ?> <tr class="<?php echo $class; ?> "> <td align="center" valign="top"><font color="#993333"><?php echo $Output['KDOUTPUT']; ?> </font></td> <td align="left" valign="top"><font color="#993333"><?php echo nm_output_th($th, $Giat['KDGIAT'] . $Output['KDOUTPUT']); ?> </font></td> <td align="right" valign="top"><font color="#993333"><?php echo number_format($Output['pagu_output'], "0", ",", "."); ?> </font></td> <td align="right" valign="top"><font color="#993333"><?php echo number_format($real_output_spm, "0", ",", "."); ?> <?php if ($real_output_spm != 0) { ?> <br> <a href="index.php?p=627&kdsatker=<?php echo $kdsatker;
</tr> <?php $sql = "select KDOUTPUT, sum(JUMLAH) as pagu_output, sum(RPHBLOKIR) as blokir_output from {$table} WHERE THANG='{$th}' and KDSATKER='{$kdsatker}' and KDGIAT='{$kdgiat}' group by KDOUTPUT"; $aOutput = mysql_query($sql); while ($Output = mysql_fetch_array($aOutput)) { ?> <tr class="<?php echo $class; ?> "> <td align="center"><font color="#FF0000"><?php echo $Output['KDOUTPUT']; ?> </font></td> <td colspan="2" align="left"><font color="#FF0000"><?php echo nm_output_th($th, $kdgiat . $Output['KDOUTPUT']); ?> </font></td> <td align="right"><font color="#FF0000"><?php echo number_format($Output['pagu_output'], "0", ",", "."); ?> </font></td> <td align="right"><font color="#FF0000"><?php echo number_format($Output['blokir_output'], "0", ",", "."); ?> </font></td> </tr> <?php $sql = "select KDSOUTPUT, sum(JUMLAH) as pagu_soutput, sum(RPHBLOKIR) as blokir_soutput from {$table} WHERE THANG='{$th}' and KDSATKER='{$kdsatker}' and KDGIAT='{$kdgiat}' and KDOUTPUT='{$Output['KDOUTPUT']}' group by KDSOUTPUT"; $aSOutput = mysql_query($sql); while ($SOutput = mysql_fetch_array($aSOutput)) {
} ?> <table width="551" cellspacing="1" class="admintable"> <tr> <td width="115" class="key">Kegiatan</td> <td width="427"><textarea name="" cols="70" rows="2" readonly><?php echo nm_giat($value[3]); ?> </textarea></td> </tr> <tr> <td class="key">Output</td> <td><textarea readonly="readonly" cols="70" rows="3"><?php echo nm_output_th($value[1], $value[3] . $value[4]); ?> </textarea></td> </tr> <tr> <td> </td> <td> <form name="form" method="post" action="index.php?p=<?php echo $_GET['p']; ?> "> <div class="button2-right"> <div class="prev"> <a onclick="Back('index.php?p=<?php echo $p_next;
} ?> <tr class="<?php echo $class; ?> "> <td align="center"><?php echo $k + 1; ?> </td> <td align="center"><?php echo $col[1][$k]; ?> </td> <td align="left"><?php echo nm_output_th($th, $kdgiat . $col[1][$k]); ?> </td> <td align="center"><?php echo $col[2][$k] . ' ' . sat_output_th($th, $kdgiat . $col[1][$k]); ?> </td> <td align="right"><?php echo number_format($col[4][$k], "0", ",", "."); ?> </td> <td align="center" valign="top"> <a href="index.php?p=453&u=<?php echo $u; ?> &g=<?php