Example #1
0
<?php

checkauthentication();
$table = "tb_unitkerja";
$field = array("id", "kdunit", "nmunit", "sktunit", "kdsatker");
$err = false;
$p = $_GET['p'];
extract($_POST);
$xusername_sess = $_SESSION['xusername'];
$kddept = setup_kddept_keu();
$kdunitx = setup_kdunit_keu();
$xmenu_p = xmenu_id($p);
$p_next = $xmenu_p->parent;
if (isset($form)) {
    if ($err != true) {
        $lastmodified = now();
        $modifiedby = $xusername_sess;
        $id = $q;
        foreach ($field as $k => $val) {
            $value[$k] = ${$val};
        }
        if ($q == "") {
            //ADD NEW
            $sql = sql_insert($table, $field, $value);
            $rs = mysql_query($sql);
            if ($rs) {
                update_log($sql, $table, 1);
                $_SESSION['errmsg'] = "Input data berhasil!";
            } else {
                update_log($sql, $table, 0);
                $_SESSION['errmsg'] = "Input data gagal!";
Example #2
0
<?php

checkauthentication();
$table = "m_program_outcome";
$err = false;
$p = $_GET['p'];
$th = $_GET['th'];
$kdprogram = $_GET['kdprogram'];
$kddept = setup_kddept_keu();
$kdunit_dipa = setup_kdunit_keu();
$q = $_GET['q'];
if ($q == '') {
    $simpan = 'Tambah';
} else {
    $simpan = 'Simpan';
}
if ($kdprogram == '') {
    $batal = 'Batal';
} else {
    $batal = 'Kembali';
}
extract($_POST);
$xusername_sess = $_SESSION['xusername'];
$kdmenteri = setup_kddept_unit($kode) . '0000';
$xmenu_p = xmenu_id($p);
$p_next = $xmenu_p->parent;
if (isset($form)) {
    if ($err != true) {
        if ($q == "") {
            //ADD NEW
            $sql = "INSERT INTO {$table} VALUE ('','{$th}','{$kddept}','{$kdunit_dipa}','{$kdprogram}','{$kdoutcome}',\r\n\t\t\t\t'{$nmoutcome}','{$kdunitkerja}')";
<?php

checkauthentication();
$p = $_GET['p'];
$cari = $_GET['cari'];
$field = get_field($table);
$ed_link = "index.php?p=" . get_edit_link($p);
$del_link = "index.php?p=" . get_delete_link($p);
$kddept = setup_kddept_keu();
$kdunit = setup_kdunit_keu();
$kdmenteri = setup_kddept_unit() . '20000';
$th = $_SESSION['xth'];
$xlevel = $_SESSION['xlevel'];
$xkdunit = $_SESSION['xkdunit'];
$xusername = $_SESSION['xusername'];
if ($xlevel == 3 or $xlevel == 4 or $xlevel == 5 or $xlevel == 6 or $xlevel == 7 or $xlevel == 8) {
    $kdsatker = kd_satker($xkdunit);
    $sql = "select KDSATKER, sum(JUMLAH) as pagu_satker from d_item WHERE THANG = '{$th}' AND KDDEPT = '{$kddept}' AND KDUNIT = '{$kdunit}' AND KDSATKER = '{$kdsatker}' GROUP BY KDSATKER ORDER BY KDSATKER";
} else {
    $sql = "select KDSATKER, sum(JUMLAH) as pagu_satker from d_item WHERE THANG = '{$th}' AND KDDEPT = '{$kddept}' AND KDUNIT = '{$kdunit}' GROUP BY KDSATKER ORDER BY KDSATKER";
}
$aSatker = mysql_query($sql);
$count = mysql_num_rows($aSatker);
$jmlh = 0;
while ($Satker = mysql_fetch_array($aSatker)) {
    $col[0][] = $Satker['KDSATKER'];
    $col[1][] = $Satker['pagu_satker'];
}
if ($xlevel != 3 and $xlevel != 4 and $xlevel != 5 and $xlevel != 6 and $xlevel != 7 and $xlevel != 8) {
    ?>
<a href="index.php?p=631" title="Grafik Realisasi"><img src="css/images/chart.jpg" border="0" width="16" height="16"></a>
Example #4
0
<?php

checkauthentication();
$p = $_GET['p'];
$cari = $_GET['cari'];
$table = "t_satker";
$field = array("ID", "KDSATKER", "NMSATKER", "KDDEPT", "KDUNIT");
$ed_link = "index.php?p=" . get_edit_link($p);
$del_link = "index.php?p=" . get_delete_link($p);
$kddept = setup_kddept_keu($kode);
$kdunit = setup_kdunit_keu($kode);
#Halaman yang akan ditampilkan untuk pertengahan?
$adjacents = 3;
$query = "SELECT COUNT(*) as num FROM {$table} WHERE KDDEPT = '{$kddept}' AND KDUNIT = '{$kdunit}' AND (NMSATKER LIKE '%{$cari}%' OR KDSATKER LIKE '%{$cari}%' OR KDDEPT LIKE '%{$cari}%' OR KDUNIT LIKE '%{$cari}%') ";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];
#variabel query
$targetpage = "index.php?p={$p}&cari={$cari}";
#nama file  (nama file ini)
$limit = 20;
#berapa yang akan ditampilkan setiap halaman
$pagess = $_GET['pagess'];
if ($pagess) {
    $start = ($pagess - 1) * $limit;
} else {
    $start = 0;
}
#halaman awal
$oList = mysql_query("SELECT * FROM {$table} WHERE KDDEPT = '{$kddept}' AND KDUNIT = '{$kdunit}' AND ( NMSATKER LIKE '%{$cari}%' OR KDSATKER LIKE '%{$cari}%' OR KDDEPT LIKE '%{$cari}%' ) ORDER BY KDSATKER LIMIT {$start}, {$limit}");
$count = mysql_num_rows($oList);
while ($List = mysql_fetch_object($oList)) {