202 lines
7.4 KiB
PHP
202 lines
7.4 KiB
PHP
<?php
|
|
|
|
|
|
include "function.php";
|
|
if (isset($_SESSION['role'])) {
|
|
if ($_SESSION['role'] == 1) {
|
|
header("location: test.php");
|
|
}
|
|
} else {
|
|
header("location:index.php");
|
|
}
|
|
|
|
$querySolusi = mysqli_query($koneksi, "SELECT id_solusi, penyakit, solusi FROM solusi INNER JOIN penyakit ON solusi.id_penyakit = penyakit.id_penyakit");
|
|
|
|
$jumlahPasien = mysqli_query($koneksi, "SELECT COUNT('id_user') as jml_pasien FROM user WHERE role='1'");
|
|
$pasien = mysqli_fetch_assoc($jumlahPasien);
|
|
|
|
$jumlahPenyakit = mysqli_query($koneksi, "SELECT COUNT('id_penyakit') as jml_penyakit FROM penyakit");
|
|
$penyakit = mysqli_fetch_assoc($jumlahPenyakit);
|
|
|
|
$jumlahGejala = mysqli_query($koneksi, "SELECT COUNT('id_gejala') as jml_gejala FROM gejala");
|
|
$gejala = mysqli_fetch_assoc($jumlahGejala);
|
|
|
|
$jumlahSolusi = mysqli_query($koneksi, "SELECT COUNT('solusi') as jml_solusi FROM solusi");
|
|
$solusi = mysqli_fetch_assoc($jumlahSolusi);
|
|
|
|
|
|
?>
|
|
|
|
<!DOCTYPE html>
|
|
<html lang="en">
|
|
|
|
<head>
|
|
<meta charset="UTF-8" />
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
|
|
<title>Dashboard Admin</title>
|
|
<link rel="stylesheet" href="styles.css">
|
|
<link
|
|
rel="stylesheet"
|
|
href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css"
|
|
integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh"
|
|
crossorigin="anonymous"/>
|
|
<link
|
|
href="https://fonts.googleapis.com/css?family=Poppins:300,400,700&display=swap"
|
|
rel="stylesheet"/>
|
|
</head>
|
|
|
|
<body >
|
|
<div class="kiri">
|
|
<section class="logo">
|
|
<img src="gambar/logo_gigi.png" alt="logo" height="70px" />
|
|
</section>
|
|
<div class="sidebar-heading">
|
|
<h5 class="font-weight-bold text-white text-uppercase teks">Data User</h5>
|
|
</div>
|
|
<section class="isi">
|
|
<a class="nav-link" href="indexAdmin.php">
|
|
<span>Data Pasien</span></a>
|
|
</section>
|
|
<section class="isi">
|
|
<a class="nav-link" href="indexPakar.php">
|
|
<span>Data Pakar</span></a>
|
|
</section>
|
|
<div class="sidebar-heading">
|
|
<h5 class="font-weight-bold text-white text-uppercase teks">Gejala & Penyakit</h5>
|
|
</div>
|
|
<section class="isi">
|
|
<a class="nav-link" href="indexPenyakit.php">
|
|
<span>Data Penyakit</span>
|
|
</a>
|
|
</section>
|
|
<section class="isi">
|
|
<a class="nav-link" href="indexGejala.php">
|
|
<span>Data Gejala</span>
|
|
</a>
|
|
</section>
|
|
<div class="sidebar-heading">
|
|
<h5 class="font-weight-bold text-white text-uppercase teks">Solusi</h5>
|
|
</div>
|
|
<section class="isi">
|
|
<a class="nav-link" href="indexSolusi.php">
|
|
<span>Data Solusi</span>
|
|
</a>
|
|
</section>
|
|
<section class="isi">
|
|
<a class="nav-link" href="logout.php">
|
|
<span>Logout</span>
|
|
</a>
|
|
</section>
|
|
</div>
|
|
|
|
<div class="kanan">
|
|
<div class="container-fluid">
|
|
|
|
<!-- Page Heading -->
|
|
<div class="d-sm-flex align-items-center justify-content-between mb-4">
|
|
<h1 class="h3 mb-0 text-gray-800">Dashboard</h1>
|
|
</div>
|
|
|
|
<!-- Content Row -->
|
|
<div class="row">
|
|
|
|
|
|
<div class="col-xl-3 col-md-6 mb-4">
|
|
<div class="card border-left-primary shadow h-100 py-2">
|
|
<div class="card-body">
|
|
<div class="row no-gutters align-items-center">
|
|
<div class="col mr-2">
|
|
<div class="text-xs font-weight-bold text-primary text-uppercase mb-1">Data Pasien</div>
|
|
<div class="h5 mb-0 font-weight-bold text-gray-800"><?= $pasien['jml_pasien']; ?></div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
|
|
<div class="col-xl-3 col-md-6 mb-4">
|
|
<div class="card border-left-success shadow h-100 py-2">
|
|
<div class="card-body">
|
|
<div class="row no-gutters align-items-center">
|
|
<div class="col mr-2">
|
|
<div class="text-xs font-weight-bold text-success text-uppercase mb-1">Data Penyakit</div>
|
|
<div class="h5 mb-0 font-weight-bold text-gray-800"><?= $penyakit['jml_penyakit']; ?></div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="col-xl-3 col-md-6 mb-4">
|
|
<div class="card border-left-info shadow h-100 py-2">
|
|
<div class="card-body">
|
|
<div class="row no-gutters align-items-center">
|
|
<div class="col mr-2">
|
|
<div class="text-xs font-weight-bold text-success text-uppercase mb-1">Data Gejala</div>
|
|
<div class="h5 mb-0 font-weight-bold text-gray-800"><?= $gejala['jml_gejala']; ?></div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="col-xl-3 col-md-6 mb-4">
|
|
<div class="card border-left-warning shadow h-100 py-2">
|
|
<div class="card-body">
|
|
<div class="row no-gutters align-items-center">
|
|
<div class="col mr-2">
|
|
<div class="text-xs font-weight-bold text-success text-uppercase mb-1">Data Solusi</div>
|
|
<div class="h5 mb-0 font-weight-bold text-gray-800"><?= $solusi['jml_solusi']; ?></div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<!-- DataTales Example -->
|
|
<div class="card shadow mb-12" style="width: 80%">
|
|
<div class="card-header py-3">
|
|
<h6 class="m-0 font-weight-bold text-primary">Tabel Data Solusi</h6>
|
|
</div>
|
|
<div class="card-body">
|
|
<a href="tambahSolusi.php" class="btn btn-primary my-2 mt-2">Tambah Data Solusi</a>
|
|
<form method="post" enctype="multipart/form-data">
|
|
<div class="table-responsive">
|
|
<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
|
|
<thead>
|
|
<tr class="d-flex">
|
|
<th class="col-2">Aksi</th>
|
|
<th class="col-1">Id Solusi</th>
|
|
<th class="col-3">Penyakit</th>
|
|
<th class="col-6">Solusi</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php while ($data = mysqli_fetch_assoc($querySolusi)) { ?>
|
|
<tr class="d-flex">
|
|
<td class="col-2">
|
|
<a class="badge badge-pill badge-primary" href="ubahSolusi.php?id_solusi=<?php echo $data["id_solusi"]; ?>">edit</a> |
|
|
<a href="function.php?act=hapusSolusi&id_solusi=<?= $data['id_solusi']; ?>" onclick="return confirm('Yakin ingin menghapus data?');" class="badge badge-pill badge-danger">hapus</a>
|
|
</td>
|
|
<td class="col-1"><?= $data['id_solusi']; ?></td>
|
|
<td class="col-3"><?= $data['penyakit']; ?></td>
|
|
<td class="col-6"><?= $data['solusi']; ?></td>
|
|
</tr>
|
|
<?php } ?>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
|
|
</form>
|
|
</div>
|
|
</div>
|
|
|
|
|
|
</div>
|
|
</div>
|
|
|
|
</body>
|
|
|
|
</html>
|