0, 'OPDID'=>$id_opd, 'Pagu'=>0); if ($id_tm > 0) { $db->Query("SELECT * FROM para90_opd_pagu WHERE Tahun='".$tahun."' AND OPDPAGUID='".$id_tm."'"); if ($db->Next()) $atabel = $db->AllRow(); } $form = new Form($db); $form->option_db("Nama OPD", "OPDID", $atabel['OPDID'], false, false, "para90_opd", array("OPDID","N_OPD"), "Aktif=1", array(0," ")); $form->textbox("Nilai Pagu", "Pagu", $atabel['Pagu'], true, true, "double", "masukkan nilai pagu"); $form->hidden("OPDPAGUID", $atabel['OPDPAGUID']); $form->show(' _OPDID_ _Pagu_ _OPDPAGUID_ '); } else if ( $data == "detail" ) { if ($mode=="save" || $mode=="del") { $sql = new SQL($db); $sql->set_table("para90_opd_pagu"); $sql->add_param("Tahun"); $sql->add_param("OPDID"); $sql->add_param("Pagu"); $sql->add_param_userid(); $sql->add_where("OPDPAGUID"); if ($mode=="save") { if ($id_tm==0) { $sql->InsertDB(); } else $sql->UpdateDB(); } else if ($mode=="del") { $sql->DeleteDB(); } } $tcari = trim(Param::Get("Cari_OPD")); $tsql = ($tcari=="") ? "" : " AND CONCAT(O.K_OPD,O.N_OPD) LIKE '%".$tcari."%'"; $obj = new Table($db); $obj->set_query("SELECT O.*,IFNULL(P.OPDPAGUID,0) OPDPAGUID,IFNULL(P.Pagu,0) Pagu FROM para90_opd O LEFT JOIN (SELECT * FROM para90_opd_pagu WHERE Tahun='".$tahun."' ORDER BY OPDID) P ON (O.OPDID=P.OPDID) WHERE O.Aktif=1 AND O.IV=0".$tsql); //$obj->set_query_footer("SELECT SUM(P.Pagu) Pagu FROM para90_opd_pagu P WHERE P.Tahun='".$tahun."'"); $obj->add_field("OPDPAGUID", "ID", "hidden"); $obj->add_field("OPDID", "ID", "hidden"); $obj->add_field("K_OPD", "Kode", "center"); $obj->add_field("N_OPD", "Nama OPD", "left autowrap"); $obj->add_field("Pagu", "Total Pagu", "right", "rupiah2", "rupiah2"); $obj->set_field_order("K_OPD", "A"); $obj->add_row_btn("description", "Ubah", "TOPDPaguJS.detail_ubah"); $obj->add_row_btn("trash", "Hapus", "TOPDPaguJS.detail_hapus"); $obj->set_func_navi("TOPDPaguJS.data_query('detail')"); $ajson[] = $obj->json_table("divDetail"); } else if ( $data == "default") { $form = new Form($db); $op_tahun = $form->option("Tahun", "Tahun", $_SESSION['__WEB_APP']['RENC_THN'], true, true, tahun_ang("Tahun "), "", "TOPDPaguJS.oc_Tahun()"); echo '
Daftar Akses Data e-Planning
'.$op_tahun.'
 
'; } send_json($ajson); ?>