| 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/siami/fakultas/ |
Upload File : |
<?php
require '../koneksi.php';
session_start();
if (!isset($_SESSION["loginfakultas"])) {
header("Location: ../index.php");
}
$querysetting = "SELECT * FROM ami_setting WHERE id_setting = 1";
$resultsetting = mysqli_query($conn, $querysetting);
$rowsetting = mysqli_fetch_assoc($resultsetting);
$num_rowssetting = mysqli_num_rows($resultsetting);
$sesinidn = $_SESSION["nidn"];
$queryauditor = "SELECT * FROM ami_fakultas WHERE nidn = '$sesinidn'";
$resultauditor = mysqli_query($conn, $queryauditor);
$rowauditor = mysqli_fetch_assoc($resultauditor);
$num_rowsauditor = mysqli_num_rows($resultauditor);
$id_fakultas = $rowauditor['id_fakultas'];
$id_siklus = $_SESSION["id_siklus"];
$queryfile = "SELECT * FROM ami_files_prodi WHERE id_siklus = $id_siklus ORDER BY id_file DESC";
$resultfile = mysqli_query($conn, $queryfile);
$num_rowsfile = mysqli_num_rows($resultfile);
$queryami = "SELECT
ami_ami.id_ami AS id_ami,
ami_audit.id_ami AS audit,
ami_ami.status AS status,
ami_fakultas.fakultas AS fakultas,
ami_prodi.prodi AS prodi,
ami_ami.id_auditor_ketua AS id_auditor,
ami_auditor.auditor AS ketua,
ami_ami.id_anggota1 AS anggota1,
ami_ami.id_anggota2 AS anggota2,
ami_ami.id_siklus AS siklus
FROM
ami_ami
LEFT JOIN ami_audit ON ami_ami.id_ami = ami_audit.id_ami
LEFT JOIN ami_fakultas ON ami_ami.id_fakultas = ami_fakultas.id_fakultas
LEFT JOIN ami_prodi ON ami_ami.id_prodi = ami_prodi.id_prodi
LEFT JOIN ami_auditor ON ami_ami.id_auditor_ketua = ami_auditor.id_auditor
WHERE
ami_ami.id_fakultas = $id_fakultas
AND ami_ami.id_siklus = $id_siklus
GROUP BY ami_ami.id_ami
ORDER BY ami_ami.id_ami DESC";
$resultami = mysqli_query($conn, $queryami);
$num_rowsami = mysqli_num_rows($resultami);
$queryfoto = "SELECT
ami_ami.id_ami,
ami_fakultas.fakultas,
ami_prodi.prodi,
ami_foto.foto
FROM
ami_ami,
ami_foto,
ami_fakultas,
ami_prodi
WHERE
ami_foto.id_ami = ami_ami.id_ami AND
ami_fakultas.id_fakultas = ami_ami.id_fakultas AND
ami_prodi.id_prodi = ami_ami.id_prodi AND
ami_fakultas.id_fakultas = $id_fakultas AND
ami_ami.id_siklus = $id_siklus
ORDER BY
ami_prodi.prodi ASC;";
$resultfoto = mysqli_query($conn, $queryfoto);
$num_rowsfoto = mysqli_num_rows($resultfoto);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width,initial-scale=1">
<title>SIAMI | Beranda Fakultas</title>
<link rel="icon" type="image/png" sizes="16x16" href="../images/<?php echo $rowsetting["favicon"] ?>">
<link href="../vendor/datatables/css/jquery.dataTables.min.css" rel="stylesheet">
<link href="../vendor/bootstrap-select/dist/css/bootstrap-select.min.css" rel="stylesheet">
<link href="../css/style.css" rel="stylesheet">
</head>
<body>
<div id="preloader">
<div class="sk-three-bounce">
<div class="sk-child sk-bounce1"></div>
<div class="sk-child sk-bounce2"></div>
<div class="sk-child sk-bounce3"></div>
</div>
</div>
<div id="main-wrapper">
<?php include('theme-logo.php') ?>
<?php include('theme-header.php') ?>
<?php include('theme-sidebar.php') ?>
<div class="content-body">
<div class="container-fluid">
<div class="page-titles">
<ol class="breadcrumb">
<li class="breadcrumb-item active"><a href="home.php">Beranda</a></li>
</ol>
</div>
<?php if ($rowauditor['niknip'] == null or $rowauditor['telp'] == null) { ?>
<div class="alert alert-warning alert-dismissible fade show">
<strong>Warning!</strong> Mohon maaf Anda belum melengkapi data profile anda, harap segera melengkapi pada menu <a href="profile.php">PROFILE</a>...!
</div>
<?php } ?>
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-header">
<h4 class="card-title">Data Audit Prodi di Fakultas Anda Semua Siklus</h4>
</div>
<div class="card-body">
<?php if ($num_rowsami == 0) { ?>
<div class="alert alert-warning alert-dismissible fade show">
Data masih kosong...!
</div>
<?php } else { ?>
<div class="table-responsive">
<table id="example" class="display min-w850">
<thead>
<tr class="text-center">
<th>No</th>
<th>Status AMI</th>
<th>Informasi Audit</th>
<th>Laporan AMI</th>
</tr>
</thead>
<tbody>
<?php $no = 1;
while ($rowami = mysqli_fetch_assoc($resultami)) { ?>
<tr class="text-center">
<td><?php echo $no ?></td>
<td>
<?php if ($rowami['status'] == 'Proses') { ?>
<span class="badge badge-rounded badge-warning"><?php echo $rowami['status'] ?></span>
<?php } else if ($rowami['status'] == 'Selesai') { ?>
<span class="badge badge-rounded badge-primary"><?php echo $rowami['status'] ?></span>
<?php } ?>
</td>
<td>
Prodi : <u><?php echo $rowami['prodi'] ?></u><br>
Fakultas : <u><?php echo $rowami['fakultas'] ?></u><br>
Ketua Auditor : <u><?php echo $rowami['ketua'] ?></u><br>
Anggota :<br><u>
<?php
$id_anggota1 = $rowami['anggota1'];
$queryagt1 = "SELECT * FROM ami_auditor WHERE id_auditor = $id_anggota1";
$resultagt1 = mysqli_query($conn, $queryagt1);
$rowagt1 = mysqli_fetch_assoc($resultagt1);
echo $rowagt1['auditor'];
?>
</u><br><u>
<?php
$id_anggota2 = $rowami['anggota2'];
$queryagt2 = "SELECT * FROM ami_auditor WHERE id_auditor = $id_anggota2";
$resultagt2 = mysqli_query($conn, $queryagt2);
$rowagt2 = mysqli_fetch_assoc($resultagt2);
if ($id_anggota2 == 0) {
echo "";
} else {
echo $rowagt2['auditor'];
}
?>
</u><br>
Siklus : <span class="badge badge-success"><?php echo $rowami['siklus'] ?></span>
</td>
<td>
<?php if ($rowami['status'] == 'Proses') { ?>
<a href="ami-print.php?id_ami=<?php echo $rowami['id_ami'] ?>&&id_kpl=<?php echo $rowami['id_auditor'] ?>&&id_agt1=<?php echo $rowami['anggota1'] ?>&&id_agt2=<?php echo $rowami['anggota2'] ?>" target="_blank"><span class="badge badge-rounded badge-warning"><i class="fa fa-print"></i> Print Lap AMI</span></a>
<?php } else if ($rowami['status'] == 'Selesai') { ?>
<a href="ami-print-ok.php?id_ami=<?php echo $rowami['id_ami'] ?>&&id_kpl=<?php echo $rowami['id_auditor'] ?>&&id_agt1=<?php echo $rowami['anggota1'] ?>&&id_agt2=<?php echo $rowami['anggota2'] ?>" target="_blank"><span class="badge badge-rounded badge-primary"><i class="fa fa-print"></i> Print Lap AMI</span></a>
<?php } ?>
</td>
</tr>
<?php $no++;
} ?>
</tbody>
<tfoot>
<tr class="text-center">
<th>No</th>
<th>Proses AMI</th>
<th>Informasi Audit</th>
<th>Laporan AMI</th>
</tr>
</tfoot>
</table>
</div>
<?php } ?>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-header">
<h4 class="card-title">Dokumentasi AMI</h4>
</div>
<div class="card-body">
<?php if ($num_rowsfoto == 0) { ?>
<div class="alert alert-warning alert-dismissible fade show">
Data masih kosong...!
</div>
<?php } else { ?>
<div class="table-responsive">
<table class="table table-responsive-md text-center">
<thead>
<tr>
<th>No</th>
<th>Program Studi</th>
<th>Foto</th>
</tr>
</thead>
<tbody>
<?php $nob = 1;
while ($rowfoto = mysqli_fetch_assoc($resultfoto)) { ?>
<tr>
<td><?php echo $nob ?></td>
<td><?php echo $rowfoto['prodi'] ?></td>
<td><a href="../images/foto/<?php echo $rowfoto['foto'] ?>" target="_blank"><img src="../images/foto/<?php echo $rowfoto['foto'] ?>" width="100"></a></td>
</tr>
<?php $nob++;
} ?>
</tbody>
<tfoot>
<tr>
</tr>
</tfoot>
</table>
</div>
<?php } ?>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-header">
<h4 class="card-title">Data Kelengkapan AMI</h4>
</div>
<div class="card-body">
<?php if ($num_rowsfile == 0) { ?>
<div class="alert alert-warning alert-dismissible fade show">
Data masih kosong...!
</div>
<?php } else { ?>
<div class="table-responsive">
<table class="table table-responsive-md text-center">
<thead>
<tr>
<th>No</th>
<th>Judul File</th>
<th>Download</th>
<th>Tanggal Upload</th>
</tr>
</thead>
<tbody>
<?php $noa = 1;
while ($rowfile = mysqli_fetch_assoc($resultfile)) { ?>
<tr>
<td><?php echo $noa ?></td>
<td><?php echo $rowfile['judul'] ?></td>
<td><a href="../files/<?php echo $rowfile['file'] ?>" target="_blank"><span class="badge light badge-success"><i class="fa fa-download"></i> <?php echo $rowfile['file'] ?></span></a></td>
<td><?php echo $rowfile['tgl'] ?></td>
</tr>
<?php $noa++;
} ?>
</tbody>
<tfoot>
<tr>
</tr>
</tfoot>
</table>
</div>
<?php } ?>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include('theme-footer.php') ?>
</div>
<script src="../vendor/global/global.min.js"></script>
<script src="../vendor/bootstrap-select/dist/js/bootstrap-select.min.js"></script>
<script src="../js/custom.min.js"></script>
<script src="../js/deznav-init.js"></script>
<script src="../vendor/datatables/js/jquery.dataTables.min.js"></script>
<script src="../js/plugins-init/datatables.init.js"></script>
</body>
</html>