<?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!";
<?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>
<?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)) {