Esempio n. 1
0
        echo number_format($real_satker_sdbulan / $col[1][$k] * 100, "2", ",", ".");
        ?>
</strong></td>
      <td align="right" valign="top"><strong><?php 
        echo number_format($col[1][$k] - $real_satker_sdbulan, "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_bulan = real_giat_bulan($th, $col[0][$k], $Giat['KDGIAT'], $kdbulan);
            $real_giat_sdbulan = real_giat_sdbulan($th, $col[0][$k], $Giat['KDGIAT'], $kdbulan);
            ?>
    <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 
            }
            ?>
</td>
$pagu_9 = $Giat['JML09'] / 1000000000;
$pagu_10 = $Giat['JML10'] / 1000000000;
$pagu_11 = $Giat['JML11'] / 1000000000;
$pagu_12 = $Giat['JML12'] / 1000000000;
$real_1 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 1) / 1000000000;
$real_2 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 2) / 1000000000;
$real_3 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 3) / 1000000000;
$real_4 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 4) / 1000000000;
$real_5 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 5) / 1000000000;
$real_6 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 6) / 1000000000;
$real_7 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 7) / 1000000000;
$real_8 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 8) / 1000000000;
$real_9 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 9) / 1000000000;
$real_10 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 10) / 1000000000;
$real_11 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 11) / 1000000000;
$real_12 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 12) / 1000000000;
switch ($bl) {
    case 1:
        $sbx_grafik_2 = array($real_1);
        break;
    case 2:
        $sbx_grafik_2 = array($real_1, $real_2);
        break;
    case 3:
        $sbx_grafik_2 = array($real_1, $real_2, $real_3);
        break;
    case 4:
        $sbx_grafik_2 = array($real_1, $real_2, $real_3, $real_4);
        break;
    case 5:
        $sbx_grafik_2 = array($real_1, $real_2, $real_3, $real_4, $real_5);
Esempio n. 3
0
        $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_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 1) / $Giat['pagu_giat'] * 100;
            $real_giat_bulan_2 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 2) / $Giat['pagu_giat'] * 100;
            $real_giat_bulan_3 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 3) / $Giat['pagu_giat'] * 100;
            $real_giat_bulan_4 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 4) / $Giat['pagu_giat'] * 100;
            $real_giat_bulan_5 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 5) / $Giat['pagu_giat'] * 100;
            $real_giat_bulan_6 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 6) / $Giat['pagu_giat'] * 100;
            $real_giat_bulan_7 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 7) / $Giat['pagu_giat'] * 100;
            $real_giat_bulan_8 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 8) / $Giat['pagu_giat'] * 100;
            $real_giat_bulan_9 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 9) / $Giat['pagu_giat'] * 100;
            $real_giat_bulan_10 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 10) / $Giat['pagu_giat'] * 100;
            $real_giat_bulan_11 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 11) / $Giat['pagu_giat'] * 100;
            $real_giat_bulan_12 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 12) / $Giat['pagu_giat'] * 100;
            $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="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']);
Esempio n. 4
0
      <td width="7%" align="center" valign="top"><strong><?php 
        echo number_format($real_satker_sdbulan / $col[2][$k] * 100, "2", ",", ".");
        ?>
</strong></td>
      <td align="right" valign="top"><strong><?php 
        echo number_format($col[2][$k] - $real_satker_sdbulan, "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_bulan = real_giat_bulan($th, $kdsatker, $Giat['KDGIAT'], $kdbulan);
            $real_giat_sdbulan = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], $kdbulan);
            $renc_giat_sdbulan = renc_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], $kdbulan);
            ?>
    <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 
            }
            ?>
Esempio n. 5
0
        $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_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 1) / 1000000;
            $real_giat_bulan_2 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 2) / 1000000;
            $real_giat_bulan_3 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 3) / 1000000;
            $real_giat_bulan_4 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 4) / 1000000;
            $real_giat_bulan_5 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 5) / 1000000;
            $real_giat_bulan_6 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 6) / 1000000;
            $real_giat_bulan_7 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 7) / 1000000;
            $real_giat_bulan_8 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 8) / 1000000;
            $real_giat_bulan_9 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 9) / 1000000;
            $real_giat_bulan_10 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 10) / 1000000;
            $real_giat_bulan_11 = real_giat_sdbulan($th, $kdsatker, $Giat['KDGIAT'], 11) / 1000000;
            $real_giat_bulan_12 = real_giat_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="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']);
$pagu_9 = $Giat['JML09'] / $Giat['RPHPAGU'] * 100;
$pagu_10 = $Giat['JML10'] / $Giat['RPHPAGU'] * 100;
$pagu_11 = $Giat['JML11'] / $Giat['RPHPAGU'] * 100;
$pagu_12 = $Giat['JML12'] / $Giat['RPHPAGU'] * 100;
$real_1 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 1) / $Giat['RPHPAGU'] * 100;
$real_2 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 2) / $Giat['RPHPAGU'] * 100;
$real_3 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 3) / $Giat['RPHPAGU'] * 100;
$real_4 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 4) / $Giat['RPHPAGU'] * 100;
$real_5 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 5) / $Giat['RPHPAGU'] * 100;
$real_6 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 6) / $Giat['RPHPAGU'] * 100;
$real_7 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 7) / $Giat['RPHPAGU'] * 100;
$real_8 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 8) / $Giat['RPHPAGU'] * 100;
$real_9 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 9) / $Giat['RPHPAGU'] * 100;
$real_10 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 10) / $Giat['RPHPAGU'] * 100;
$real_11 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 11) / $Giat['RPHPAGU'] * 100;
$real_12 = real_giat_sdbulan($th, $kdsatker, $kdgiat, 12) / $Giat['RPHPAGU'] * 100;
switch ($bl) {
    case 1:
        $sbx_grafik_2 = array($real_1);
        break;
    case 2:
        $sbx_grafik_2 = array($real_1, $real_2);
        break;
    case 3:
        $sbx_grafik_2 = array($real_1, $real_2, $real_3);
        break;
    case 4:
        $sbx_grafik_2 = array($real_1, $real_2, $real_3, $real_4);
        break;
    case 5:
        $sbx_grafik_2 = array($real_1, $real_2, $real_3, $real_4, $real_5);