</thead>
  <tbody>
    <tr class="<?php 
echo $class;
?>
"> 
      <td width="6%" align="center"><font color="#0FA40B"><strong><?php 
echo $kdgiat;
?>
</strong></font></td>
      <td colspan="3" align="left"><font color="#0FA40B"><strong><?php 
echo nm_giat($kdgiat);
?>
</strong></font></td>
      <td width="12%" align="right"><font color="#0FA40B"><strong><?php 
echo number_format(real_giat_spm($th, $kdsatker, $kdgiat), "0", ",", ".");
?>
</strong></font></td>
    </tr>
    <?php 
if (mysql_num_rows(mysql_query("SHOW TABLES LIKE '" . $table_1 . "'")) == 1 and mysql_num_rows(mysql_query("SHOW TABLES LIKE '" . $table_2 . "'")) == 1) {
    $sql = "select sum(totnilmak) as real_giat from {$table_1} WHERE thang='{$th}' AND kdsatker='{$kdsatker}' and kdgiat='{$kdgiat}' group by kdgiat";
    $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;
        ?>
Exemplo n.º 2
0
</strong></td>
      <td width="7%" align="center"><strong><?php 
        echo number_format(($real_satker_spm - $real_satker_sp2d) / $col[1][$k] * 100, "2", ",", ".");
        ?>
</strong></td>
      <td width="7%" align="center"><a href="index.php?p=631&kdsatker=<?php 
        echo $col[0][$k];
        ?>
" title="Grafik Realisasi"><img src="css/images/chart.jpg" border="0" width="16" height="16"></a></td>
    </tr>
    <?php 
        $kdsatker = $col[0][$k];
        $sql = "select KDGIAT, sum(JUMLAH) as pagu_giat from d_item WHERE KDDEPT = '{$kddept}' AND KDUNIT = '{$kdunit}' AND THANG = '{$th}' AND KDSATKER = '{$kdsatker}' GROUP BY KDGIAT ORDER BY KDGIAT";
        $aGiat = mysql_query($sql);
        while ($Giat = mysql_fetch_array($aGiat)) {
            $real_giat_spm = real_giat_spm($th, $kdsatker, $Giat['KDGIAT']);
            $real_giat_sp2d = real_giat_sp2d($th, $kdsatker, $Giat['KDGIAT']);
            ?>
    <tr class="<?php 
            echo $class;
            ?>
"> 
      <td align="center" valign="top"><font color="#0000FF"><?php 
            echo $Giat['KDGIAT'];
            ?>
</font></td>
      <td align="left" valign="top"><font color="#0000FF"><?php 
            echo nm_giat($Giat['KDGIAT']);
            ?>
</font></td>
      <td align="right" valign="top"><font color="#0000FF"><?php