| 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($_GET["ID"])) {
$sql = "delete from anggota_penelitian 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_penelitian 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($_GET["editID"])) {
$sql = "SELECT * FROM usulan_penelitian 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'];
$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_penelitian set aktif = 0");
$sql = "update usulan_penelitian 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["reviewer"])) $reviewer = $_POST["reviewer"];
if(isset($_POST["id"])) $id = $_POST["id"];
$tbField[0] = "reviewer";
$tbIsi[0] = "'".$reviewer."'";
if(isset($_POST["Koreksi"])) {
$compileSet = compile_array2($tbField,$tbIsi);
$sql = "update usulan_penelitian 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 Penelitian</h6>
</div>
<div class="card-body">
<form class="user" action="dashboard.php?DetPenelitian" 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 Penelitian</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 Penelitian</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 Penelitian</td>
<td>
<input value="<?php echo $skema;?>" name="skema" type="text" class="form-control" id="skema" placeholder="">
</td>
</tr>
<tr>
<td>Biaya Penelitian</td>
<td>
<input value="<?php echo $biaya;?>" name="biaya" type="number" class="form-control" id="biaya" placeholder="">
</td>
</tr>
<tr>
<td>Topik Penelitian</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="">
</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>
<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">Reviewer</h6>
</div>
<div class="card-body">
<form class="user" action="dashboard.php?ReviewerPenelitian" 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%">Pilih Reviewer</td>
<td width="70%">
<input value="<?php echo $id;?>" name="id" type="hidden">
<select name="reviewer" class="form-control" id="reviewer">
<?php
$sql = "SELECT * FROM user_login where user_profile = 'REVIEWER' order by user_id desc";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
?>
<option value="<?php echo $row["user_id"];?>"><?php echo $row["user_fullname"] ;?></option>
<?php } } ?>
</select>
</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>
<form class="user" action="dashboard.php?DetPenelitian&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 Penelitian</h6>
</div>
<div class="card-body">
<div class="table-responsive">
<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_penelitian a left join peneliti b on a.id_peneliti = b.id where id_penelitian = ".$_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?DetPenelitian&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 Penelitian</h6>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
<thead>
<tr>
<th>Judul</th>
<th>Keterangan</th>
<th>Files</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Judul</th>
<th>Keterangan</th>
<th>Files</th>
</tr>
</tfoot>
<tbody>
<?php
$sql = "SELECT * FROM files_penelitian where id_penelitian = ".$_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>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</form>
<?php }else{ ?>
<form class="user" action="dashboard.php?DetPenelitian" 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>Set</th>
<th>NO</th>
<th>Tanggal</th>
<th>Judul</th>
<th>Reviewer</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Set</th>
<th>NO</th>
<th>Tanggal</th>
<th>Judul</th>
<th>Reviewer</th>
</tr>
</tfoot>
<tbody>
<?php
$sql = "SELECT * FROM usulan_penelitian a left join user_login b on a.reviewer = b.user_id order by id desc";
$result = mysqli_query($conn, $sql);
$no = 0;
if(mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
?>
<tr>
<td>
<!--a class="btn btn-primary btn-danger" href="dashboard.php?Penelitian&deleteID=<?php echo $row['id'];?>"><i class="fas fa-trash"></i></a-->
<a class="btn btn-primary btn-warning" href="dashboard.php?ReviewerPenelitian&editID=<?php echo $row['id'];?>"><i class="fas fa-edit"></i></a>
</td>
<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 } ?>