| 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);
$sesinidn = $_SESSION["nidn"];
$queryauditor = "SELECT * FROM ami_auditor WHERE nidn = '$sesinidn'";
$resultauditor = mysqli_query($conn, $queryauditor);
$rowauditor = mysqli_fetch_assoc($resultauditor);
$num_rowsauditor = mysqli_num_rows($resultauditor);
$id_ami = $_GET["id_ami"];
$queryaudit = "
SELECT
ami_audit.id_audit AS id_audit,
ami_standar.standar AS standar,
ami_standar.isi AS isi,
ami_kts.kts AS kts,
ami_audit.uraian AS uraian,
ami_audit.tindakan AS tindakan,
ami_audit.target AS waktu,
ami_audit.status AS status,
ami_audit.tgl_perbaikan AS tgl_perbaikan
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
";
$resultaudit = mysqli_query($conn, $queryaudit);
$num_rowsaudit = mysqli_num_rows($resultaudit);
?>
<!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 | Proses Audit</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"><a href="home.php">Beranda</a></li>
<li class="breadcrumb-item"><a href="home.php">Audit</a></li>
<li class="breadcrumb-item active"><a href="javascript:void(0)">Proses Audit</a></li>
</ol>
</div>
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-header">
<h4 class="card-title">Proses Audit</h4>
</div>
<div class="card-body">
<button type="button" class="btn btn-primary mt-3" onclick="window.location='audit-tambah.php?id_ami=<?php echo $id_ami ?>'">Tambah Data</button>
<button type="button" class="btn btn-secondary mt-3" onclick="window.location='home.php'">Kembali</button>
<hr>
<?php if ($num_rowsaudit == 0) { ?>
<div class="alert alert-warning alert-dismissible fade show">
Data masih kosong...!
</div>
<?php } else { ?>
<div class="table-responsive">
<table id="example6" class="display min-w850 text-center">
<thead>
<tr>
<th>No</th>
<th>Action</th>
<th>Standar</th>
<th>Butir Standar</th>
<th>Temuan KTS</th>
<th>Uraian Ketidak Sesuaian</th>
<th>Tindak Perbaikan</th>
<th>Target Waktu Perbaikan</th>
<th>Perbaikan</th>
</tr>
</thead>
<tbody>
<?php $no = 1;
while ($rowaudit = mysqli_fetch_assoc($resultaudit)) { ?>
<tr>
<td><?php echo $no ?></td>
<td>
<div class="dropdown">
<button type="button" class="btn btn-success light sharp" data-toggle="dropdown">
<svg width="20px" height="20px" viewBox="0 0 24 24" version="1.1">
<g stroke="none" stroke-width="1" fill="none" fill-rule="evenodd">
<rect x="0" y="0" width="24" height="24" />
<circle fill="#000000" cx="5" cy="12" r="2" />
<circle fill="#000000" cx="12" cy="12" r="2" />
<circle fill="#000000" cx="19" cy="12" r="2" />
</g>
</svg>
</button>
<div class="dropdown-menu">
<a class="dropdown-item" href="audit-edit.php?id_audit=<?php echo $rowaudit['id_audit'] ?>">Edit</a>
<a class="dropdown-item" href="audit-delete.php?id_audit=<?php echo $rowaudit['id_audit'] ?>" onClick="return confirm('Apakah anda yakin ingin menghapus data Audit dengan id <?php echo $rowaudit['id_audit'] ?>...?')">Delete</a>
</div>
</div>
</td>
<td><?php echo $rowaudit['standar'] ?></td>
<td><?php echo $rowaudit['isi'] ?></td>
<td><?php echo $rowaudit['kts'] ?></td>
<td><?php echo $rowaudit['uraian'] ?></td>
<td><?php echo $rowaudit['tindakan'] ?></td>
<td><?php echo $rowaudit['waktu'] ?></td>
<td>
<?php if ($rowaudit['status'] == 'Belum Dilaksanakan') { ?>
<span class="badge light badge-warning"><?php echo $rowaudit['status'] ?></span>
<?php } else if ($rowaudit['status'] == 'Sudah Dilaksanakan') { ?>
<span class="badge light badge-success"><?php echo $rowaudit['status'] ?></span><br>
Tanggal :<br><?php echo $rowaudit['tgl_perbaikan'] ?>
<?php } ?>
</td>
</tr>
<?php $no++;
} ?>
</tbody>
<tfoot>
<tr>
<th>No</th>
<th>Action</th>
<th>Standar</th>
<th>Butir Standar</th>
<th>Temuan KTS</th>
<th>Uraian Ketidak Sesuaian</th>
<th>Tindak Perbaikan</th>
<th>Target Waktu Perbaikan</th>
<th>Perbaikan</th>
</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>
<script>
$(document).ready(function() {
$('#example6').DataTable({
"paging": false,
"order": [
[3, "asc"]
]
});
});
</script>
</body>
</html>