PHP real_giat_triwulan示例

示例#1

文件： laporan_triwulan_akun_giat.php 项目： abbeet/server39

      <td width="7%" align="center" valign="top"><?php 
        echo number_format($real_satker_sdtriwulan / $col[1][$k] * 100, "2", ",", ".");
        ?>
</strong></td>
      <td align="right" valign="top"><strong><?php 
        echo number_format($col[1][$k] - $real_satker_sdtriwulan, "0", ",", ".");
        ?>
</strong></td>
    </tr>
	<?php 
        $kdsatker = $col[0][$k];
        $sql = "select a.KDGIAT, sum(a.jumlah) as pagu_giat, b.kdunitkerja from {$table} a LEFT OUTER JOIN m_kegiatan b ON ( a.KDGIAT = b.kdgiat and a.THANG = b.th )  WHERE a.THANG = '{$th}' and a.KDSATKER = '{$kdsatker}' group by a.KDGIAT order by b.kdunitkerja";
        //	$sql = "select KDGIAT, sum(jumlah) as pagu_giat from $table  WHERE THANG = '$th' AND KDSATKER = '$kdsatker' group by KDGIAT";
        $aGiat = mysql_query($sql);
        while ($Giat = mysql_fetch_array($aGiat)) {
            $real_giat_triwulan = real_giat_triwulan($th, $col[0][$k], $Giat['KDGIAT'], $kdtriwulan);
            $real_giat_sdtriwulan = real_giat_sdtriwulan($th, $col[0][$k], $Giat['KDGIAT'], $kdtriwulan);
            ?>
    <tr class="<?php 
            echo $class;
            ?>
">
      <td align="left" valign="top"><?php 
            if ($Giat['kdunitkerja'] != $kdunitkerja) {
                ?>
<font color="#0000FF"><?php 
                echo strtoupper(nm_unit($Giat['kdunitkerja']));
                ?>
</font><?php 
            }
            ?>

示例#2

文件： laporan_triwulan_total.php 项目： abbeet/server39

</strong></td>
      <td width="7%" align="center" valign="top"><strong><?php 
        echo number_format($real_satker_sdtriwulan / $col[2][$k] * 100, "2", ",", ".");
        ?>
</strong></td>
      <td align="right" valign="top"><strong><?php 
        echo number_format($col[2][$k] - $real_satker_sdtriwulan, "0", ",", ".");
        ?>
</strong></td>
    </tr>
    <?php 
        $kdsatker = $col[1][$k];
        $sql = "select a.THANG, a.KDGIAT, sum(a.jumlah) as pagu_giat, b.kdunitkerja from {$table} a LEFT OUTER JOIN m_kegiatan b ON ( a.KDGIAT = b.kdgiat and a.THANG = b.th )  WHERE a.THANG = '{$th}' and a.KDSATKER = '{$kdsatker}' group by a.KDGIAT order by b.kdunitkerja";
        $aGiat = mysql_query($sql);
        while ($Giat = mysql_fetch_array($aGiat)) {
            $real_giat_triwulan = real_giat_triwulan($th, $kdsatker, $Giat['KDGIAT'], $kdtriwulan);
            $real_giat_sdtriwulan = real_giat_sdtriwulan($th, $kdsatker, $Giat['KDGIAT'], $kdtriwulan);
            $renc_giat_sdtriwulan = renc_giat_sdtriwulan($th, $kdsatker, $Giat['KDGIAT'], $kdtriwulan);
            ?>
    <tr class="<?php 
            echo $class;
            ?>
">
      <td align="left" valign="top"><?php 
            if ($Giat['kdunitkerja'] != $kdunitkerja) {
                ?>
<font color="#0000FF"><?php 
                echo strtoupper(nm_unit($Giat['kdunitkerja']));
                ?>
</font><?php 
            }