| 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/auditor/ |
Upload File : |
<?php
require '../koneksi.php';
session_start();
if (!isset($_SESSION["loginauditor"])) {
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);
include "../phpqrcode/qrlib.php";
$sesinidn = $_SESSION["nidn"];
$queryauditor = "SELECT * FROM ami_admin WHERE nidn = '$sesinidn'";
$resultauditor = mysqli_query($conn, $queryauditor);
$rowauditor = mysqli_fetch_assoc($resultauditor);
$num_rowsauditor = mysqli_num_rows($resultauditor);
$id_ami = $_GET["id_ami"];
$queryami = "SELECT
ami_ami.id_ami,
ami_ami.id_prodi,
ami_ami.id_auditor_ketua,
ami_jenjang.jenjang as nm_jenjang,
ami_prodi.prodi,
ami_prodi.kaprodi,
ami_auditor.auditor,
ami_siklus.id_siklus,
ami_siklus.tahun,
ami_fakultas.fakultas,
ami_prodi.telp,
ami_ami.tgl_rtm,
ami_ami.tgl_selesai
FROM
ami_ami,
ami_prodi,
ami_auditor,
ami_siklus,
ami_fakultas,
ami_jenjang
WHERE
ami_prodi.id_prodi = ami_ami.id_prodi AND
ami_auditor.id_auditor = ami_ami.id_auditor_ketua AND
ami_siklus.id_siklus = ami_ami.id_siklus AND
ami_fakultas.id_fakultas = ami_ami.id_fakultas AND
ami_jenjang.id_jenjang = ami_prodi.jenjang AND
ami_ami.id_ami = $id_ami";
$resultami = mysqli_query($conn, $queryami);
$rowami = mysqli_fetch_assoc($resultami);
$id_prodiqr = $rowami['id_prodi'];
$id_auditorqr = $rowami['id_auditor_ketua'];
$id_kpl = $_GET["id_kpl"];
$querykpl = "SELECT
ami_ami.id_ami as kpl_idami,
ami_ami.id_auditor_ketua as kpl_idkpl,
ami_auditor.auditor as kpl_auditor,
ami_auditor.telp as kpl_telp,
ami_fakultas.fakultas as kpl_fakultas
FROM
ami_ami, ami_auditor, ami_fakultas
WHERE
ami_auditor.id_auditor = ami_ami.id_auditor_ketua AND
ami_fakultas.id_fakultas = ami_auditor.id_fakultas AND
ami_ami.id_ami = $id_ami AND
ami_auditor.id_auditor = $id_kpl";
$resultkpl = mysqli_query($conn, $querykpl);
$rowkpl = mysqli_fetch_assoc($resultkpl);
$id_agt1 = $_GET["id_agt1"];
$queryagt1 = "SELECT
ami_ami.id_ami as agt1_idami,
ami_ami.id_anggota1 as agt1_idagt1,
ami_auditor.auditor as agt1_auditor,
ami_auditor.telp as agt1_telp,
ami_fakultas.fakultas as agt1_fakultas
FROM
ami_ami, ami_auditor, ami_fakultas
WHERE
ami_auditor.id_auditor = ami_ami.id_anggota1 AND
ami_fakultas.id_fakultas = ami_auditor.id_fakultas AND
ami_ami.id_ami = $id_ami AND
ami_auditor.id_auditor = $id_agt1";
$resultagt1 = mysqli_query($conn, $queryagt1);
$rowagt1 = mysqli_fetch_assoc($resultagt1);
$id_agt2 = $_GET["id_agt2"];
$queryagt2 = "SELECT
ami_ami.id_ami as agt2_idami,
ami_ami.id_anggota2 as agt2_idagt2,
ami_auditor.auditor as agt2_auditor,
ami_auditor.telp as agt2_telp,
ami_fakultas.fakultas as agt2_fakultas
FROM
ami_ami, ami_auditor, ami_fakultas
WHERE
ami_auditor.id_auditor = ami_ami.id_anggota2 AND
ami_fakultas.id_fakultas = ami_auditor.id_fakultas AND
ami_ami.id_ami = $id_ami AND
ami_auditor.id_auditor = $id_agt2";
$resultagt2 = mysqli_query($conn, $queryagt2);
$rowagt2 = mysqli_fetch_assoc($resultagt2);
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">
<title>Laporan AMI Prodi <?php echo $rowami['prodi'] ?></title>
<style>
@media print {
.hide {
display: none;
}
}
</style>
</head>
<body>
<div class="container">
<div>
<br><br><br><br><br><br><br><br><br><br><br><br><br><br>
<div class="text-center pt-5">
<img src="../images/<?php echo $rowsetting["logo"] ?>" width="25%">
</div>
<br><br><br>
<div class="row">
<div class="col-md-8">
<div class="table-responsive">
<table class="table">
<tbody>
<tr>
<td width="10%"> </td>
<td>Jenjang</td>
<td>: <?php echo $rowami['jenjang'] ?></td>
</tr>
<tr>
<td> </td>
<td>Program Studi</td>
<td>: <?php echo $rowami['prodi'] ?></td>
</tr>
<tr>
<td> </td>
<td>Ketua Program Studi</td>
<td>: <?php echo $rowami['kaprodi'] ?></td>
</tr>
<tr>
<td> </td>
<td>Ketua Tim Auditor</td>
<td>: <?php echo $rowkpl['kpl_auditor'] ?></td>
</tr>
<tr>
<td> </td>
<td>Anggota Auditor</td>
<td>: <?php echo $rowagt1['agt1_auditor'] ?></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td>:
<?php if ($id_agt2 == 0) { ?>
<?php } else { ?>
<?php echo $rowagt2['agt2_auditor'] ?>
<?php } ?>
</td>
</tr>
<tr>
<td> </td>
<td>Siklus / Tahun</td>
<td>: <?php echo $rowami['id_siklus'] ?> / <?php echo $rowami['tahun'] ?></td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<br><br><br><br><br><br><br><br><br><br><br><br>
<h1 class="text-center"><?php echo $rowami['tahun'] ?></h1>
<br><br><br><br>
</div>
<div class="row">
<div class="col-md-12">
<h2 class="text-center">LAPORAN AUDIT MUTU INTERNAL<br>PROGRAM STUDI <span class="text-uppercase"><?php echo $rowami['prodi'] ?></span><br>SIKLUS KE-<?php echo $rowami['id_siklus'] ?> TAHUN <?php echo $rowami['tahun'] ?></h2>
<br><br>
<h5>A. PENDAHULUAN</h5><br>
  <b>1. Identitas Auditee</b><br><br>
<table width="100%">
<tr>
<td width="5%"> </td>
<td width="25%">Fakultas</td>
<td>: <?php echo $rowami['fakultas'] ?></td>
</tr>
<tr>
<td> </td>
<td>Program Studi</td>
<td>: <?php echo $rowami['prodi'] ?></td>
</tr>
<tr>
<td> </td>
<td>Kepala Program Studi</td>
<td>: <?php echo $rowami['kaprodi'] ?></td>
</tr>
<tr>
<td> </td>
<td>Telpon</td>
<td>: <?php echo $rowami['telp'] ?></td>
</tr>
</table>
<br>
  <b>2. Identitas Auditor</b><br><br>
<table width="100%">
<tr>
<td width="5%"> </td>
<td width="25%">Ketua Auditor</td>
<td>: <?php echo $rowkpl['kpl_auditor'] ?></td>
</tr>
<tr>
<td> </td>
<td>Fakultas</td>
<td>: <?php echo $rowkpl['kpl_fakultas'] ?></td>
</tr>
<tr>
<td> </td>
<td>Telpon</td>
<td>: <?php echo $rowkpl['kpl_telp'] ?></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>Anggota 1</td>
<td>: <?php echo $rowagt1['agt1_auditor'] ?></td>
</tr>
<tr>
<td> </td>
<td>Fakultas</td>
<td>: <?php echo $rowagt1['agt1_fakultas'] ?></td>
</tr>
<tr>
<td> </td>
<td>Telpon</td>
<td>: <?php echo $rowagt1['agt1_telp'] ?></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>Anggota 2</td>
<td>:
<?php if ($id_agt2 == 0) { ?>
<?php } else { ?>
<?php echo $rowagt2['agt2_auditor'] ?>
<?php } ?>
</td>
</tr>
<tr>
<td> </td>
<td>Fakultas</td>
<td>:
<?php if ($id_agt2 == 0) { ?>
<?php } else { ?>
<?php echo $rowagt2['agt2_fakultas'] ?>
<?php } ?>
</tr>
<tr>
<td> </td>
<td>Telpon</td>
<td>:
<?php if ($id_agt2 == 0) { ?>
<?php } else { ?>
<?php echo $rowagt2['agt2_telp'] ?>
<?php } ?>
</td>
</tr>
</table>
<br><br>
<h5>B. TUJUAN AUDIT</h5>
<ol>
<li>Untuk memeriksa kesesuaian atau ketidaksesuaian pelaksanaan standar yang telah ditetapkan.</li>
<li>Untuk menyiapkan laporan kepada Teraudit (Auditee) sebagai dasar perbaikan mutu selanjutnya.</li>
<li>Untuk memberikan kesempatan Teraudit memperbaiki Sistem Penjaminan Mutu.</li>
<li>Untuk membantu Instansi/Program Studi mempersiapkan diri dalam rangka Audit Ekternal atau Akreditasi.</li>
</ol>
<br><br>
<h5>C. MANFAAT</h5>
<p>Rekomendasi/manfaat langsung Audit Mutu Internal (AMI) secara langsung adalah diperoleh rekomendasi peningkatan Mutu Pendidikan Tinggi.</p>
<br>
<h5>D. LINGKUP AUDIT</h5><br>
<p>1. Standar Penelitian</p>
<ol type="a">
<li>Standar Hasil Penelitian</li>
<li>Standar Isi Penelitian</li>
<li>Standar Proses Penelitian</li>
<li>Standar Penilaian Penelitian</li>
<li>Standar Peneliti</li>
<li>Standar Sarana dan Prasarana Penelitian</li>
<li>Standar Pengelolaan Penelitian</li>
<li>Standar Pendanaan dan Pembiayaan Penelitian</li>
</ol>
<p>2. Standar Pengabdian Kepada Masyarakat</p>
<ol type="a">
<li>Standar Hasil PkM</li>
<li>Standar Isi PkM</li>
<li>Standar Proses PkM</li>
<li>Standar Penilaian PkM</li>
<li>Standar Pengabdi</li>
<li>Standar Sarana dan Prasarana PkM</li>
<li>Standar Pengelolaan PkM</li>
<li>Standar Pendanaan dan Pembiayaan PkM</li>
</ol>
<p>3. Luaran dan Publikasi</p>
<br><br>
<?php
$querymekanisme = "SELECT * FROM ami_mekanisme WHERE id_ami = '$id_ami'";
$resultmekanisme = mysqli_query($conn, $querymekanisme);
$rowmekanisme = mysqli_fetch_assoc($resultmekanisme);
$num_rowsmekanisme = mysqli_num_rows($resultmekanisme);
?>
<h5>E. MEKANISME</h5>
<table class="table table-sm table-bordered">
<tr>
<th width=4% class="text-center">No</th>
<th>Mekanisme Yang Dilakukan</th>
<th>Ket</th>
</tr>
<tr>
<td align="center">1</td>
<td>Pembukaan dan pertemuan dengan Kaprodi</td>
<td>
<?php if (empty($rowmekanisme['id_ami'])) { ?>
Belum Diisi
<?php } else { ?>
<?php echo $rowmekanisme['question1'] ?>
<?php } ?>
</td>
</tr>
<tr>
<td align="center">2</td>
<td>Pertemuan dengan Staf dan Dosen</td>
<td>
<?php if (empty($rowmekanisme['id_ami'])) { ?>
Belum Diisi
<?php } else { ?>
<?php echo $rowmekanisme['question2'] ?>
<?php } ?>
</td>
</tr>
<tr>
<td align="center">3</td>
<td>Pertemuan dengan Karyawan</td>
<td>
<?php if (empty($rowmekanisme['id_ami'])) { ?>
Belum Diisi
<?php } else { ?>
<?php echo $rowmekanisme['question3'] ?>
<?php } ?>
</td>
</tr>
<tr>
<td align="center">4</td>
<td>Pertemuan dengan Mahasiswa</td>
<td>
<?php if (empty($rowmekanisme['id_ami'])) { ?>
Belum Diisi
<?php } else { ?>
<?php echo $rowmekanisme['question4'] ?>
<?php } ?>
</td>
</tr>
<tr>
<td align="center">5</td>
<td>Pertemuan dengan Alumni/Pengguna Lulusan</td>
<td>
<?php if (empty($rowmekanisme['id_ami'])) { ?>
Belum Diisi
<?php } else { ?>
<?php echo $rowmekanisme['question5'] ?>
<?php } ?>
</td>
</tr>
<tr>
<td align="center">6</td>
<td>Penyampaian temuan dan penutup</td>
<td>
<?php if (empty($rowmekanisme['id_ami'])) { ?>
Belum Diisi
<?php } else { ?>
<?php echo $rowmekanisme['question6'] ?>
<?php } ?>
</td>
</tr>
</table>
<br><br>
<?php
$queryaudit = "SELECT
ami_audit.id_ami,
ami_standar.standar,
ami_standar.isi,
ami_kts.kts,
ami_audit.uraian,
ami_audit.tindakan,
ami_audit.target,
ami_audit.status
FROM
ami_audit, ami_standar , ami_kts
WHERE
ami_standar.id_standar = ami_audit.id_standar AND
ami_kts.id_kts = ami_audit.id_kts AND
ami_audit.id_ami = $id_ami
ORDER BY ami_standar.isi ASC
";
$resultaudit = mysqli_query($conn, $queryaudit);
$num_rowsaudit = mysqli_num_rows($resultaudit);
?>
<h5>F. TEMUAN AUDIT</h5>
<p>1. Tindak Sesuaian</p>
<table class="table table-sm table-bordered">
<thead>
<tr class="text-center">
<th>No</th>
<th>Standar</th>
<th>Butir Standar</th>
<th>KTS</th>
<th>Uraian Ketidak Sesuaian</th>
<th>Tindak Perbaikan</th>
<th>Target Waktu Penyelesaian</th>
</tr>
</thead>
<tbody>
<?php $no = 1;
while ($rowaudit = mysqli_fetch_assoc($resultaudit)) { ?>
<tr>
<td class="text-center"><small><?php echo $no ?></small></td>
<td><small><?php echo $rowaudit['standar'] ?></small></td>
<td><small><?php echo $rowaudit['isi'] ?></small></td>
<td class="text-center"><small><?php echo $rowaudit['kts'] ?></small></td>
<td><small><?php echo $rowaudit['uraian'] ?></small></td>
<td><small><?php echo $rowaudit['tindakan'] ?></small></td>
<td><small><?php echo $rowaudit['target'] ?></small></td>
</tr>
<?php $no++;
} ?>
</tbody>
</table>
<table class="table table-sm table-bordered">
<tr>
<td>Tanggal RTM :</td>
<td>Auditor : <b><?php echo $rowkpl['kpl_auditor'] ?></b></td>
<td>Auditee : <b><?php echo $rowami['kaprodi'] ?></b></td>
</tr>
<tr class="text-center">
<td><b><?php echo $rowami['tgl_rtm'] ?></b></td>
<?php
Qrcode::png("http://spmi.stikesbpi.ac.id/data-ami.php?id_ami=$id_ami&&id_user=$id_prodiqr", "../images/qrcode/image$id_prodiqr.png", "L", 4, 5);
Qrcode::png("http://spmi.stikesbpi.ac.id/data-ami.php?id_ami=$id_ami&&id_user=$id_auditorqr", "../images/qrcode/image$id_auditorqr.png", "L", 4, 5);
?>
<td>
<?php echo "<img src='../images/qrcode/image$id_prodiqr.png' width='100'>" ?>
</td>
<td>
<?php echo "<img src='../images/qrcode/image$id_auditorqr.png' width='100'>" ?>
</td>
</tr>
</table>
<br>
<?php
$queryaudits = "SELECT
ami_audit.id_ami,
ami_standar.standar,
ami_standar.isi,
ami_kts.kts,
ami_audit.uraian,
ami_audit.tindakan,
ami_audit.target,
ami_audit.status
FROM
ami_audit, ami_standar , ami_kts
WHERE
ami_standar.id_standar = ami_audit.id_standar AND
ami_kts.id_kts = ami_audit.id_kts AND
ami_audit.id_ami = $id_ami
ORDER BY ami_standar.isi ASC
";
$resultaudits = mysqli_query($conn, $queryaudits);
$num_rowsaudits = mysqli_num_rows($resultaudits);
?>
<p>2. Tindak Lanjut Perbaikan</p>
<table class="table table-sm table-bordered">
<thead>
<tr class="text-center">
<th>No</th>
<th>Standar</th>
<th>Butir Standar</th>
<th>KTS</th>
<th>Uraian Ketidak Sesuaian</th>
<th>Tindak Perbaikan</th>
<th>Target Waktu Penyelesaian</th>
<th>Status</th>
</tr>
</thead>
<tbody>
<?php $noa = 1;
while ($rowaudits = mysqli_fetch_assoc($resultaudits)) { ?>
<tr>
<td class="text-center"><small><?php echo $noa ?></small></td>
<td><small><?php echo $rowaudits['standar'] ?></small></td>
<td><small><?php echo $rowaudits['isi'] ?></small></td>
<td class="text-center"><small><?php echo $rowaudits['kts'] ?></small></td>
<td><small><?php echo $rowaudits['uraian'] ?></small></td>
<td><small><?php echo $rowaudits['tindakan'] ?></small></td>
<td><small><?php echo $rowaudits['target'] ?></small></td>
<td class="text-center"><b><?php echo $rowaudits['status'] ?></b></td>
</tr>
<?php $noa++;
} ?>
</tbody>
</table>
<table class="table table-sm table-bordered">
<tr>
<td>Tanggal Selesai :</td>
<td>Auditor : <b><?php echo $rowkpl['kpl_auditor'] ?></b></td>
<td>Auditee : <b><?php echo $rowami['kaprodi'] ?></b></td>
</tr>
<tr class="text-center">
<td><b><?php echo $rowami['tgl_selesai'] ?></b></td>
<?php
Qrcode::png("http://spmi.stikesbpi.ac.id/data-ami.php?id_ami=$id_ami&&id_user=$id_prodiqr", "../images/qrcode/image$id_prodiqr.png", "L", 4, 5);
Qrcode::png("http://spmi.stikesbpi.ac.id/data-ami.php?id_ami=$id_ami&&id_user=$id_auditorqr", "../images/qrcode/image$id_auditorqr.png", "L", 4, 5);
?>
<td>
<?php echo "<img src='../images/qrcode/image$id_prodiqr.png' width='100'>" ?>
</td>
<td>
<?php echo "<img src='../images/qrcode/image$id_auditorqr.png' width='100'>" ?>
</td>
</tr>
</table>
<br><br>
<?php
$querykesimpulan = "SELECT
ami_standar.standar,
SUM(ami_kts.kts = 'Mayor') AS mayor,
SUM(ami_kts.kts = 'Minor') AS minor,
SUM(ami_kts.kts = 'Observasi') AS observasi
FROM
ami_standar,
ami_kts,
ami_audit
WHERE
ami_standar.id_standar = ami_audit.id_standar AND
ami_kts.id_kts = ami_audit.id_kts AND
ami_audit.id_ami = $id_ami
GROUP BY ami_standar.standar;";
$resultkesimpulan = mysqli_query($conn, $querykesimpulan);
$num_rowskesimpulan = mysqli_num_rows($resultkesimpulan);
$querykes = "SELECT * FROM ami_kesimpulan WHERE id_ami = $id_ami";
$resultkes = mysqli_query($conn, $querykes);
$rowkes = mysqli_fetch_assoc($resultkes);
$num_rowskes = mysqli_num_rows($resultkes);
?>
<h5>G. KESIMPULAN AUDIT</h5>
<p>Tim Auditor menyimpulkan :</p>
<ol type="a">
<li>Sistem dokumen cukup lengkap untuk mendukung pelaksanaan Sistem Penjaminan Mutu Internal dan Pengelolaan Mutu Program Studi (Jawaban :
<b>
<?php if (empty($rowkes['id_kesimpulan'])) { ?>
Belum di isi
<?php } else { ?>
<?php if ($rowkes['ckp_lengkap'] == "Lainnya") { ?>
<?php echo $rowkes['sebutkan'] ?>
<?php } else { ?>
<?php echo $rowkes['ckp_lengkap'] ?>
<?php } ?>
<?php } ?>
</b>)
</li>
<li>Rekap temuan sebagai berikut :</li>
</ol>
<table class="table table-sm table-bordered text-center">
<thead>
<tr>
<th>No</th>
<th>Standar</th>
<th>Mayor</th>
<th>Minor</th>
<th>Observasi</th>
</tr>
</thead>
<tbody>
<?php $nob = 1;
$tmayor = 0;
$tminor = 0;
$tobservasi = 0;
while ($rowkesimpulan = mysqli_fetch_assoc($resultkesimpulan)) {
$tmayor += $rowkesimpulan['mayor'];
$tminor += $rowkesimpulan['minor'];
$tobservasi += $rowkesimpulan['observasi'];
?>
<tr>
<td><?php echo $nob ?></td>
<td><?php echo $rowkesimpulan['standar'] ?></td>
<td><?php echo $rowkesimpulan['mayor'] ?></td>
<td><?php echo $rowkesimpulan['minor'] ?></td>
<td><?php echo $rowkesimpulan['observasi'] ?></td>
</tr>
<?php
$nob++;
} ?>
</tbody>
<tfoot>
<tr>
<th colspan="2">Total</th>
<th><?php echo $tmayor ?></th>
<th><?php echo $tminor ?></th>
<th><?php echo $tobservasi ?></th>
</tr>
</tfoot>
</table>
</div>
</div>
<button onclick="window.print()" class="hide btn btn-primary">Print</button>
<div class="hide"><br><br><br></div>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>
</body>
</html>