PROSES INI AKAN SEKALIGUS MENGUBAH SEMUA HAK AKSES DATA E-MONEV OLEH OPD SESUAI TAHUN TERPILIH.
';
} else if ( $data == "detail" ) {
if ( in_array($mode, ["save","save-all"]) ) {
$hak_renja = Param::Get("Hak_Renja", 0);
$hak_b01 = Param::Get("Hak_Kin_B01", 0);
$hak_b02 = Param::Get("Hak_Kin_B02", 0);
$hak_b03 = Param::Get("Hak_Kin_B03", 0);
$hak_b04 = Param::Get("Hak_Kin_B04", 0);
$hak_b05 = Param::Get("Hak_Kin_B05", 0);
$hak_b06 = Param::Get("Hak_Kin_B06", 0);
$hak_b07 = Param::Get("Hak_Kin_B07", 0);
$hak_b08 = Param::Get("Hak_Kin_B08", 0);
$hak_b09 = Param::Get("Hak_Kin_B09", 0);
$hak_b10 = Param::Get("Hak_Kin_B10", 0);
$hak_b11 = Param::Get("Hak_Kin_B11", 0);
$hak_b12 = Param::Get("Hak_Kin_B12", 0);
if ( $mode=="save" ) {
if ($id == 0) {
$db->Query("INSERT INTO sippd_akses_mon (Tahun,OPDID,UserID) VALUES ('".$tahun."','".$id_opd."','".user_id()."')");
$id = $db->LastInsertID();
}
} else if ( $mode=="save-all" ) {
$db->Query("INSERT INTO sippd_akses_mon (Tahun,OPDID,UserID) SELECT '".$tahun."',OPDID,'".user_id()."' FROM para90_opd WHERE Aktif=1 AND IV=0 AND OPDID NOT IN (SELECT OPDID FROM sippd_akses_mon WHERE Tahun='".$tahun."')");
}
$db->Query("UPDATE sippd_akses_mon SET Hak_Renja='".$hak_renja."',Hak_Kin_B01='".$hak_b01."',Hak_Kin_B02='".$hak_b02."',Hak_Kin_B03='".$hak_b03."',Hak_Kin_B04='".$hak_b04."',Hak_Kin_B05='".$hak_b05."',Hak_Kin_B06='".$hak_b06."',Hak_Kin_B07='".$hak_b07."',Hak_Kin_B08='".$hak_b08."',Hak_Kin_B09='".$hak_b09."',Hak_Kin_B10='".$hak_b10."',Hak_Kin_B11='".$hak_b11."',Hak_Kin_B12='".$hak_b12."',UserID='".user_id()."' WHERE ".($mode=="save"?"MONOPDID='".$id."'":"Tahun='".$tahun."'"));
$db->Query("UPDATE sippd_akses_mon SET Hak_Kin_T1=IF(Hak_Kin_B01+Hak_Kin_B02+Hak_Kin_B03=0,0,1),Hak_Kin_T2=IF(Hak_Kin_B04+Hak_Kin_B05+Hak_Kin_B06=0,0,1),Hak_Kin_T3=IF(Hak_Kin_B07+Hak_Kin_B08+Hak_Kin_B09=0,0,1),Hak_Kin_T4=IF(Hak_Kin_B10+Hak_Kin_B11+Hak_Kin_B12=0,0,1) WHERE ".($mode=="save"?"MONOPDID='".$id."'":"Tahun='".$tahun."'"));
}
$tcari = trim(Param::Get("Cari_OPD"));
$tsql = ($tcari=="") ? "" : " WHERE CONCAT(O.K_OPD,O.N_OPD) LIKE '%".$tcari."%'";
$obj = new Table($db);
$obj->set_query("SELECT O.OPDID,O.K_OPD,O.N_OPD,IFNULL(A.MONOPDID,0) MONOPDID,IFNULL(A.Tahun,'".$tahun."') Tahun,IFNULL(A.Hak_Renja,1) Hak_Renja,CONCAT(IFNULL(A.Hak_Kin_B01,1),IFNULL(A.Hak_Kin_B02,1),IFNULL(A.Hak_Kin_B03,1)) Hak_Kin_T1,CONCAT(IFNULL(A.Hak_Kin_B04,1),IFNULL(A.Hak_Kin_B05,1),IFNULL(A.Hak_Kin_B06,1)) Hak_Kin_T2,CONCAT(IFNULL(A.Hak_Kin_B07,1),IFNULL(A.Hak_Kin_B08,1),IFNULL(A.Hak_Kin_B09,1)) Hak_Kin_T3,CONCAT(IFNULL(A.Hak_Kin_B10,1),IFNULL(A.Hak_Kin_B11,1),IFNULL(A.Hak_Kin_B12,1)) Hak_Kin_T4 FROM (SELECT * FROM para90_opd WHERE Aktif=1 AND IV=0 ORDER BY OPDID) O LEFT JOIN (SELECT * FROM sippd_akses_mon WHERE Tahun='".$tahun."' ORDER BY OPDID) A ON (O.OPDID=A.OPDID)".$tsql);
$obj->add_field("OPDID", "ID", "hid");
$obj->add_field("MONOPDID", "ID", "hid");
$obj->add_field("Tahun", "Tahun", "c");
$obj->add_field("K_OPD", "Kode", "c");
$obj->add_field("N_OPD", "Nama OPD", "awr");
$obj->add_field("Hak_Renja", "Renja", "c", "checkbox");
$obj->add_field("Hak_Kin_T1", "TW 1", "c", "hak_kin_tw1");
$obj->add_field("Hak_Kin_T2", "TW 2", "c", "hak_kin_tw2");
$obj->add_field("Hak_Kin_T3", "TW 3", "c", "hak_kin_tw3");
$obj->add_field("Hak_Kin_T4", "TW 4", "c", "hak_kin_tw4");
$obj->set_field_order("K_OPD", "A");
$obj->add_row_btn("clipboard", "Ubah", "TAksesMonJS.detail_ubah");
$obj->set_func_navi("TAksesMonJS.data_query('detail')");
$ajson[] = $obj->json_table("divDetail");
} else if ( $data == "default") {
$form = new Form($db);
$op_tahun = $form->option("Tahun", "Tahun", $tahun, true, true, tahun_ang("Tahun "), "", "TAksesMonJS.oc_Tahun()");
echo '
';
}
send_json($ajson);
?>