| Server IP : 101.255.104.117 / Your IP : 101.255.104.117 Web Server : Apache/2.4.34 (Win32) OpenSSL/1.0.2o PHP/5.6.38 System : Windows NT DESKTOP-5B8S0D4 6.2 build 9200 (Windows 8 Professional Edition) i586 User : user ( 0) PHP Version : 5.6.38 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : D:/xampp182/htdocs/silppm/ |
Upload File : |
<?php
$id = "";
$judul = "";
$hp = "";
$skim = "";
$buton = "Simpan";
$proposal = "-";
$topik = "-";
$tgl_usulan = "-";
$biaya = "-";
$skema = "-";
$periode = "-";
$skim = "-";
$nama = "-";
$id_peneliti = "-";
$struktural = "-";
$nilai = "-";
$komentar = "-";
$substansi = "-";
$rab = "-";
$rekom_rab = "-";
if(isset($_SESSION["user-id"])) $idrev = $_SESSION["user-id"];
else $idrev = 0;
if(isset($_GET["ID"])) {
$sql = "delete from anggota_pengabdian where id = ".$_GET["ID"];
if (mysqli_query($conn, $sql)) {
echo "<script>window.alert('Data Sudah Terhapus');</script>";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}
if(isset($_GET["ID2"])) {
$sql = "delete from files_pengabdian where id = ".$_GET["ID2"];
if (mysqli_query($conn, $sql)) {
echo "<script>window.alert('Data Sudah Terhapus');</script>";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}
if(isset($_POST["Tambah"])) {
$sql = "insert into anggota_pengabdian (id_peneliti,id_pengabdian) values (".$_POST["id_peneliti"].",".$_GET["editID"].")";
if (mysqli_query($conn, $sql)) {
echo "<script>window.alert('Anggota Telah Ditambahkan.');</script>";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}
if(isset($_POST["Unggah"])) {
$image_id = time();
$images = $_FILES["fileInput"]["name"];
if($images) {
$rename = explode(".",$images);
if(count($rename) > 1) {
$images = "peng".$image_id.".".$rename[1];
$url = $images;
move_uploaded_file($_FILES["fileInput"]["tmp_name"],"files/" . $images);
}
}
$sql = "insert into files_pengabdian (judul,id_pengabdian,keterangan,tgl,id_user,url) values ('".$_POST["judul"]."',".$_GET["editID"].",'".$_POST["keterangan"]."','".$skr."',".$_SESSION["user-id"].",'".$url."')";
if (mysqli_query($conn, $sql)) {
echo "<script>window.alert('Upload Sukses Ditambahkan.');</script>";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}
if(isset($_GET["editID"])) {
$sql = "SELECT * FROM usulan_pengabdian a left join peneliti b on a.id_peneliti = b.id where a.id = ".$_GET["editID"]." order by a.id desc";
// echo $sql;
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
$id = $_GET["editID"];
$judul = $row['judul'];
$tgl_usulan = $row['tgl_usulan'];
$skim = $row['skim'];
$id_peneliti = $row['id_peneliti'];
$prodi = $row['prodi'];
$periode = $row['periode'];
$biaya = $row['biaya'];
$topik = $row['topik'];
$proposal = $row['proposal'];
$buton = "Koreksi";
$nama = $row['nama'];
$hp = $row['hp'];
$email = $row['email'];
$fungsional = $row['fungsional'];
$struktural = $row['struktural'];
$prodi = $row['prodi'];
$nidn = $row['nidn'];
$nilai = $row['nilai'];
$nilai1 = $row['nilai1'];
$nilai2 = $row['nilai2'];
$nilai3 = $row['nilai3'];
$nilai4 = $row['nilai4'];
$nilai5 = $row['nilai5'];
$nilai6 = $row['nilai6'];
$komentar = $row['komentar'];
$substansi = $row['substansi'];
$rab = $row['rab'];
$rekom_rab = $row['rekom_rab'];
$buton = "Koreksi";
}
}
}
if(isset($_GET["setaktif"])) {
$setz = mysqli_query($conn, "update usulan_pengabdian set aktif = 0");
$sql = "update usulan_pengabdian set aktif = 1 where id = ".$_GET["setaktif"];
if (mysqli_query($conn, $sql)) {
echo "<script>window.alert('Set Aktif');</script>";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}
if(isset($_POST["Simpan"]) || isset($_POST["Koreksi"])) {
if(isset($_POST["nilai"])) $nilai = $_POST["nilai"];
if(isset($_POST["nilai1"])) $nilai1 = $_POST["nilai1"];
if(isset($_POST["nilai2"])) $nilai2 = $_POST["nilai2"];
if(isset($_POST["nilai3"])) $nilai3 = $_POST["nilai3"];
if(isset($_POST["nilai4"])) $nilai4 = $_POST["nilai4"];
if(isset($_POST["nilai5"])) $nilai5 = $_POST["nilai5"];
if(isset($_POST["nilai6"])) $nilai6 = $_POST["nilai6"];
if(isset($_POST["komentar"])) $komentar = $_POST["komentar"];
if(isset($_POST["substansi"])) $substansi = $_POST["substansi"];
if(isset($_POST["id"])) $id = $_POST["id"];
if(isset($_POST["rab"])) $rab = $_POST["rab"];
if(isset($_POST["rekom_rab"])) $rekom_rab = $_POST["rekom_rab"];
$tbField[0] = "nilai";
$tbField[1] = "komentar";
$tbField[2] = "substansi";
$tbField[3] = "rab";
$tbField[4] = "rekom_rab";
$tbField[5] = "nilai1";
$tbField[6] = "nilai2";
$tbField[7] = "nilai3";
$tbField[8] = "nilai4";
$tbField[9] = "nilai5";
$tbField[10] = "nilai6";
$tbIsi[0] = "'".$nilai."'";
$tbIsi[1] = "'".$komentar."'";
$tbIsi[2] = "'".$substansi."'";
$tbIsi[3] = "'".$rab."'";
$tbIsi[4] = "'".$rekom_rab."'";
$tbIsi[5] = "'".$nilai1."'";
$tbIsi[6] = "'".$nilai2."'";
$tbIsi[7] = "'".$nilai3."'";
$tbIsi[8] = "'".$nilai4."'";
$tbIsi[9] = "'".$nilai5."'";
$tbIsi[10] = "'".$nilai6."'";
if(isset($_POST["Koreksi"])) {
$compileSet = compile_array2($tbField,$tbIsi);
$sql = "update usulan_pengabdian set ".$compileSet." where id = ".$id;
$notif = $sum;
}
if (mysqli_query($conn, $sql)) {
echo "<script>window.alert('".$notif."');</script>";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}
?>
<?php if(isset($_POST["Add"]) || isset($_GET["editID"])) { ?>
<div class="container-fluid">
<div class="card shadow mb-4">
<div class="card-header py-3">
<h6 class="m-0 font-weight-bold text-primary"> Data Pengabdian</h6>
</div>
<div class="card-body">
<form class="user" action="dashboard.php?DetPengabdian" accept-charset="utf-8" method="post">
<style>
table td, table th {
padding: 5px; /* cellpadding */
}
</style>
<div class="col m6">
<div class="row">
<div class="input-field col m6 s12">
<table border="0" width="100%" cellspacing="1" cellpadding="1">
<tr>
<td width="30%">Judul Peneliti</td>
<td width="70%">
<input value="<?php echo $judul;?>" name="judul" type="text" class="form-control" id="exampleFirstName" placeholder="Judul">
</td>
</tr>
<tr>
<td>Tanggal Usulan</td>
<td>
<input value="<?php echo $tgl_usulan;?>" name="tgl_usulan" type="date" class="form-control" id="tgl_usulan" placeholder="">
</td>
</tr>
<tr>
<td>Skim Pengabdian</td>
<td>
<input value="<?php echo $skim;?>" name="skim" type="text" class="form-control" id="var" placeholder="nama periode masuk">
</td>
</tr>
<tr>
<td>Periode Pengabdian</td>
<td>
<input value="<?php echo $periode;?>" name="periode" type="text" class="form-control" id="var" placeholder="nama periode masuk">
</td>
</tr>
<tr>
<td>Skema Pengabdian</td>
<td>
<input value="<?php echo $skema;?>" name="skema" type="text" class="form-control" id="skema" placeholder="">
</td>
</tr>
<tr>
<td>Biaya Pengabdian</td>
<td>
<input value="<?php echo $biaya;?>" name="biaya" type="number" class="form-control" id="biaya" placeholder="">
</td>
</tr>
<tr>
<td>Topik Pengabdian</td>
<td>
<input value="<?php echo $topik;?>" name="topik" type="text" class="form-control" id="topik" placeholder="">
</td>
</tr>
<tr>
<td>Program Studi</td>
<td>
<select name="prodi" class="form-control" id="prodi">
<?php
$sql = "SELECT * FROM f_prodi order by id desc";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
?>
<option value="<?php echo $row["prodi"];?>"><?php echo $row["prodi"];?></option>
<?php } } ?>
</select>
</td>
</tr>
<tr>
<td>Proposal</td>
<td>
<input value="<?php echo $proposal;?>" name="proposal" type="text" class="form-control" id="proposal" placeholder="">
</td>
</tr>
<tr>
<td width="30%">Nama Peneliti</td>
<td width="70%">
<input value="<?php echo $id_peneliti;?>" name="id_peneliti" type="hidden">
<input readonly value="<?php echo $nama;?>" name="nama" type="text" class="form-control" id="exampleFirstName" placeholder="Username Feeder">
</td>
</tr>
<tr>
<td>NIDN</td>
<td>
<input readonly value="<?php echo $nidn;?>" name="nidn" type="text" class="form-control" id="nidn" placeholder="">
</td>
</tr>
<tr>
<td>Jabatan Fungsional</td>
<td>
<input readonly value="<?php echo $fungsional;?>" name="fungsional" type="text" class="form-control" id="fungsional" placeholder="">
</td>
</tr>
<tr>
<td>Jabatan Struktural</td>
<td>
<input readonly value="<?php echo $struktural;?>" name="struktural" type="text" class="form-control" id="struktural" placeholder="">
</td>
</tr>
<tr>
<td>No Handphone</td>
<td>
<input readonly value="<?php echo $hp;?>" name="hp" type="text" class="form-control" id="hp" placeholder="">
</td>
</tr>
<tr>
<td>E-mail</td>
<td>
<input readonly value="<?php echo $email;?>" name="email" type="text" class="form-control" id="var" placeholder="nama periode masuk">
</td>
</tr>
<!--tr>
<td> </td>
<td>
<div class="form-group row">
<div class="col-sm-2 mb-3 mb-sm-0">
<button name="<?php echo $buton;?>" type="submit" class="btn btn-primary btn-block"><?php echo $buton;?></button>
</div>
<div class="col-sm-2">
<button name="Cancel" type="submit" class="btn btn-primary btn-block">Cancel</button>
</div>
</div>
</td>
</tr-->
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</form>
<?php
if($profile == "REVIEWER") {
$readonly = "";
}else{
$readonly = "readonly";
}
?>
<div class="container-fluid">
<div class="card shadow mb-4">
<div class="card-header py-3">
<h6 class="m-0 font-weight-bold text-primary">Hasil Review</h6>
</div>
<div class="card-body">
<form class="user" action="dashboard.php?DetPengabdian" accept-charset="utf-8" method="post">
<style>
table td, table th {
padding: 5px; /* cellpadding */
}
</style>
<div class="col m6">
<div class="row">
<div class="input-field col m6 s12">
<table border="0" width="100%" cellspacing="1" cellpadding="1">
<tr>
<td width="60%">Nilai Proposal</td>
<td width="40%">
<input value="<?php echo $id;?>" name="id" type="hidden">
<input value="<?php echo $nilai;?>" <?php echo $readonly;?> name="nilai" type="number" class="form-control" id="exampleFirstName" placeholder="">
</td>
</tr>
<tr>
<td>1. Kemajuan Ketercapaian Luaran Wajib</td>
<td>
<input value="<?php echo $nilai1;?>" <?php echo $readonly;?> name="nilai1" type="number" class="form-control" id="exampleFirstName" placeholder="">
</td>
</tr>
<tr>
<td>2. Kemajuan Ketercapaian Luaran Tambahan</td>
<td>
<input value="<?php echo $nilai2;?>" <?php echo $readonly;?> name="nilai2" type="number" class="form-control" id="exampleFirstName" placeholder="">
</td>
</tr>
<tr>
<td>3. Tingkat Ketercapaian Keberdayaan</td>
<td>
<input value="<?php echo $nilai3;?>" <?php echo $readonly;?> name="nilai3" type="number" class="form-control" id="exampleFirstName" placeholder="">
</td>
</tr>
<tr>
<td>4. Kesesuaian program dengan rencana kegiatan</td>
<td>
<input value="<?php echo $nilai4;?>" <?php echo $readonly;?> name="nilai4" type="number" class="form-control" id="exampleFirstName" placeholder="">
</td>
</tr>
<tr>
<td>5. Integritas, dedikasi, kekompakan dan intensitas tim pelaksana dalam kegiatan di lapangan</td>
<td>
<input value="<?php echo $nilai5;?>" <?php echo $readonly;?> name="nilai5" type="number" class="form-control" id="exampleFirstName" placeholder="">
</td>
</tr>
<tr>
<td>6. Tingkat Partisipasi Sasaran</td>
<td>
<input value="<?php echo $nilai6;?>" <?php echo $readonly;?> name="nilai6" type="number" class="form-control" id="exampleFirstName" placeholder="">
</td>
</tr>
<tr>
<td>Komentar Reviewer</td>
<td>
<input value="<?php echo $komentar;?>" <?php echo $readonly;?> name="komentar" type="text" class="form-control" id="nidn" placeholder="">
</td>
</tr>
<tr>
<td>Substansi</td>
<td>
<input value="<?php echo $substansi;?>" <?php echo $readonly;?> name="substansi" type="text" class="form-control" id="fungsional" placeholder="">
</td>
</tr>
<tr>
<td>Rencana Anggaran Biaya</td>
<td>
<input value="<?php echo $rab;?>" <?php echo $readonly;?> name="rab" type="number" class="form-control" id="struktural" placeholder="">
</td>
</tr>
<tr>
<td>Rekomendasi Pendanaan</td>
<td>
<input value="<?php echo $rekom_rab;?>" <?php echo $readonly;?> name="rekom_rab" type="number" class="form-control" id="hp" placeholder="">
</td>
</tr>
<?php if($profile == "REVIEWER") { ?>
<tr>
<td> </td>
<td>
<div class="form-group row">
<div class="col-sm-6 mb-3 mb-sm-0">
<button name="<?php echo $buton;?>" type="submit" class="btn btn-primary btn-block"><?php echo $buton;?></button>
</div>
<div class="col-sm-6">
<button name="Cancel" type="submit" class="btn btn-primary btn-block">Cancel</button>
</div>
</div>
</td>
</tr>
<?php } ?>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</form>
<form class="user" action="dashboard.php?DetPengabdian&editID=<?php echo $_GET["editID"];?>" enctype="multipart/form-data" accept-charset="utf-8" method="post">
<div class="container-fluid">
<!-- Page Heading -->
<!-- DataTales Example -->
<div class="card shadow mb-4">
<div class="card-header py-3">
<h6 class="m-0 font-weight-bold text-primary">Anggota Pengabdian</h6>
</div>
<div class="card-body">
<div class="table-responsive">
<table width="100%" cellspacing="0">
<tr>
<td>
<div class="form-group row">
<div class="col-sm-6 mb-3 mb-sm-0">
<select name="id_peneliti" class="form-control" id="id_peneliti">
<?php
$sql = "SELECT * FROM peneliti order by id desc";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
?>
<option value="<?php echo $row["id"];?>"><?php echo $row["nidn"]." - ".$row["nama"];?></option>
<?php } } ?>
</select>
</div>
<div class="col-sm-2">
<button name="Tambah" type="submit" class="btn btn-primary btn-block">Tambah Anggota</button>
</div>
</div>
</td>
</tr>
</table>
<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
<thead>
<tr>
<th>Nama</th>
<th>NIDN</th>
<th>Struktural</th>
<th>Keterangan</th>
<th>Hapus</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Nama</th>
<th>NIDN</th>
<th>Struktural</th>
<th>Keterangan</th>
<th>Hapus</th>
</tr>
</tfoot>
<tbody>
<?php
$sql = "SELECT a.id,nama,nidn,struktural FROM anggota_pengabdian a left join peneliti b on a.id_peneliti = b.id where id_pengabdian = ".$_GET["editID"]." order by a.id desc";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
?>
<tr>
<td><?php echo $row['nama'];?></td>
<td><?php echo $row['nidn'];?></td>
<td><?php echo $row['struktural'];?></td>
<td>Anggota</td>
<td>
<a class="btn btn-primary btn-danger" href="dashboard.php?DetPengabdian&editID=<?php echo $_GET["editID"];?>&ID=<?php echo $row['id'];?>"><i class="fas fa-trash"></i></a-->
</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<div class="container-fluid">
<!-- Page Heading -->
<!-- DataTales Example -->
<div class="card shadow mb-4">
<div class="card-header py-3">
<h6 class="m-0 font-weight-bold text-primary">Files Pengabdian</h6>
</div>
<div class="card-body">
<div class="table-responsive">
<table border="0" width="100%" cellspacing="1" cellpadding="1">
<tr>
<td width="30%">Judul</td>
<td width="70%">
<input value="<?php echo $judul;?>" name="judul" type="text" class="form-control" id="judul" placeholder="">
</td>
</tr>
<tr>
<td>Keterangan</td>
<td>
<select name="keterangan" class="form-control" id="keterangan">
<option value="Proposal Penelitian">Proposal Penelitian</option>
<option value="Hasil Penelitian">Hasil Penelitian</option>
</select>
</td>
</tr>
<tr>
<td>Upload Files</td>
<td>
<input name="fileInput" type="file" class="form-control" placeholder="">
</td>
</tr>
<tr>
<td> </td>
<td>
<div class="form-group row">
<div class="col-sm-2 mb-3 mb-sm-0">
<button name="Unggah" type="submit" class="btn btn-primary btn-block">Unggah</button>
</div>
<div class="col-sm-2">
<button name="Cancel" type="submit" class="btn btn-primary btn-block">Cancel</button>
</div>
</div>
</td>
</tr>
</table>
<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
<thead>
<tr>
<th>Judul</th>
<th>Keterangan</th>
<th>Files</th>
<th>Hapus</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Judul</th>
<th>Keterangan</th>
<th>Files</th>
<th>Hapus</th>
</tr>
</tfoot>
<tbody>
<?php
$sql = "SELECT * FROM files_pengabdian where id_pengabdian = ".$_GET["editID"]." order by id desc";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
?>
<tr>
<td><?php echo $row['judul'];?></td>
<td><?php echo $row['keterangan'];?></td>
<td><a href="files/<?php echo $row['url'];?>" target="blank"><?php echo $row['url'];?></a></td>
<td>
<a class="btn btn-primary btn-danger" href="dashboard.php?DetPengabdian&editID=<?php echo $_GET["editID"];?>&ID2=<?php echo $row['id'];?>"><i class="fas fa-trash"></i></a-->
</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</form>
<?php }else{ ?>
<form class="user" action="dashboard.php?DetPengabdian" accept-charset="utf-8" method="post">
<div class="container-fluid">
<!-- Page Heading -->
<!-- DataTales Example -->
<div class="card shadow mb-4">
<div class="card-header py-3">
<h6 class="m-0 font-weight-bold text-primary">DataTables</h6>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
<thead>
<tr>
<th>Detail</th>
<?php if($profile == "REVIEWER") { ?><th>Status</th><?php } ?>
<th>NO</th>
<th>Tanggal</th>
<th>Judul</th>
<th>Reviewer</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Detail</th>
<?php if($profile == "REVIEWER") { ?><th>Status</th><?php } ?>
<th>NO</th>
<th>Tanggal</th>
<th>Judul</th>
<th>Reviewer</th>
</tr>
</tfoot>
<tbody>
<?php
$sql = "SELECT * FROM usulan_pengabdian a left join user_login b on a.reviewer = b.user_id where reviewer = ".$idrev." order by id desc";
$result = mysqli_query($conn, $sql);
$no = 0;$cek = 0;
if(mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
$cek = strlen($row['komentar']);
?>
<tr>
<td>
<!--a class="btn btn-primary btn-danger" href="dashboard.php?Pengabdian&deleteID=<?php echo $row['id'];?>"><i class="fas fa-trash"></i></a-->
<a class="btn btn-primary btn-warning" href="dashboard.php?DetPengabdian&editID=<?php echo $row['id'];?>"><i class="fas fa-comments"></i></a>
</td>
<?php if($profile == "REVIEWER") { ?>
<td>
<?php if($cek > 0) { ?>
<a class="btn btn-primary btn-warning" href="#"><i class="fas fa-check"></i></a>
<?php }else{ ?>
<a class="btn btn-primary btn-danger" href="#"><i class="fas fa-window-close" aria-hidden="true"></i></a>
<?php } ?>
</td>
<?php } ?>
<td><?php echo $no = ($no+1);?></td>
<td><?php echo $row['tgl_usulan'];?></td>
<td><?php echo $row['judul'];?></td>
<td><?php echo $row['user_fullname'];?></td>
</tr>
<?php
}
}
?>
</tbody>
</table>
<hr>
</div>
</div>
</div>
</div>
</form>
<?php } ?>