<?php
checkauthentication();
$p = $_GET['p'];
$table = "dt_pk";
$field = array("id", "th", "kdunitkerja", "no_sasaran", "nourut_pk", "indikator", "target", "no_iku", "anggaran", "rencana_1", "rencana_2", "rencana_3", "rencana_4", "rencana_aksi_1", "rencana_aksi_2", "rencana_aksi_3", "rencana_aksi_4", "realisasi_1", "realisasi_2", "realisasi_3", "realisasi_4", "hasil_1", "hasil_2", "hasil_3", "hasil_4");
$ed_link = "index.php?p=" . get_edit_link($p);
$del_link = "index.php?p=" . get_delete_link($p);
$th = $_SESSION['xth'];
$xkdunit = $_SESSION['xkdunit'];
$xusername = $_SESSION['xusername'];
$kdsatker = kd_satker($xkdunit);
$xlevel = $_SESSION['xlevel'];
$kdtriwulan = $_REQUEST['kdtriwulan'];
if ($_REQUEST['cari']) {
$kdtriwulan = $_REQUEST['kdtriwulan'];
$xkdunit = $_REQUEST['kdunit'];
}
if ($kdtriwulan == '') {
$bl = date('m');
if ($bl <= 4 and $bl >= 2) {
$kdtriwulan = 1;
}
if ($bl <= 7 and $bl >= 5) {
$kdtriwulan = 2;
}
if ($bl <= 10 and $bl >= 8) {
$kdtriwulan = 3;
}
if ($bl <= 12 and $bl >= 11 or $bl == 1) {
$kdtriwulan = 4;
$kdsatker = substr($xusername, 4, 6);
break;
case 4:
$kdsatker = substr($xusername, 4, 6);
break;
case 5:
$kdsatker = kd_satker(substr($xusername, 3, 7));
break;
case 6:
$kdsatker = substr($xusername, 4, 6);
break;
case 7:
$kdsatker = substr($xusername, 4, 6);
break;
case 8:
$kdsatker = kd_satker(substr($xusername, 3, 7));
break;
case 9:
$kdsatker = '';
break;
}
$sql = "select KDDEPT, KDUNIT from setup_dept ";
$aDept = mysql_query($sql);
$Dept = mysql_fetch_array($aDept);
$kddept = $Dept['KDDEPT'];
$kdunit = $Dept['KDUNIT'];
if ($kdsatker == '') {
$sql = "select sum(RPHPAGU) as RPHPAGU,\r\n\t\t\t\t\tsum(JML01) as JML_1,\r\n\t\t\t\t\tsum(JML01+JML02) as JML_2,\r\n\t\t\t\t\tsum(JML01+JML02+JML03) as JML_3,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04) as JML_4,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05) as JML_5,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06) as JML_6,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07) as JML_7,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08) as JML_8,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09) as JML_9,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09+JML10) as JML_10,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09+JML10+JML11) as JML_11,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09+JML10+JML11+JML12) as JML_12\r\n\t\t\t\t\tfrom d_trktrm WHERE THANG = '{$th}' group by THANG";
} else {
$sql = "select sum(RPHPAGU) as RPHPAGU,\r\n\t\t\t\t\tsum(JML01) as JML_1,\r\n\t\t\t\t\tsum(JML01+JML02) as JML_2,\r\n\t\t\t\t\tsum(JML01+JML02+JML03) as JML_3,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04) as JML_4,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05) as JML_5,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06) as JML_6,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07) as JML_7,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08) as JML_8,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09) as JML_9,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09+JML10) as JML_10,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09+JML10+JML11) as JML_11,\r\n\t\t\t\t\tsum(JML01+JML02+JML03+JML04+JML05+JML06+JML07+JML08+JML09+JML10+JML11+JML12) as JML_12\r\n\t\t\t\t\tfrom d_trktrm WHERE THANG = '{$th}' and KDSATKER = '{$kdsatker}' group by THANG";
}
