function buatKode($tabel, $inisial)
{
//Mencari nama dan panjang kolom pertama (kode)
$hsl1 = querydb("SELECT * FROM {$tabel} LIMIT 1");
$klm1 = mysqli_fetch_field_direct($hsl1, 0);
//$hsl1 = $msysqli->query("SELECT * FROM $tabel LIMIT 1");
//$klm1 = $hsl1->fetch_fields_direct(0);
$klmNama1 = $klm1->name;
$klmLenght1 = $klm1->length;
$hsl22 = querydb("SELECT max(" . $klmNama1 . ") FROM " . $tabel);
//$hsl22 = querydb($qry2);
$row = arraydb($hsl22);
if (empty($row[0])) {
$angka = 0;
} else {
$angka = substr($row[0], strlen($inisial));
//$angka = $row[0];;
}
$angka = $angka + 1;
$angka = strval($angka);
//Membuat angka 0 untuk mengisi digit yang kosong
$tmp = "";
for ($i = 1; $i <= $klmLenght1 - strlen($inisial) - strlen($angka); $i++) {
$tmp = $tmp . "0";
}
return $inisial . $tmp . $angka;
//return $klmLenght1;
}
while ($rek = arraydb($hsl)) {
if ($rek['status'] == "Y") {
$klsBaris = "";
$stat = "<span class='label label-success'>Sudah Dikembalikan</span>";
} else {
if ($rek['status'] == "T") {
$klsBaris = "danger";
$stat = "<span class='label label-danger'>Sedang Dipinjam</span>";
} else {
$klsBaris = "warning";
$stat = "<span class='label label-warning'>Sudah Dibooking</span>";
}
}
$qri2 = "SELECT * FROM alat WHERE id_alat = '{$rek['id_alat']}'";
$hsl2 = querydb($qri2);
while ($rek2 = arraydb($hsl2)) {
echo "<tr class=\"{$klsBaris}\">";
echo "<td align='center'>" . $c . "</td>";
echo "<td align='center'>" . $rek['id_peminjaman'] . "</td>";
echo "<td align='center'>" . $rek['id_alat'] . "</td>";
echo "<td align='center'>" . $rek2['nama_alat'] . "</td>";
echo "<td align='center'>" . $rek['no_identitas'] . "</td>";
echo "<td align='center'>" . $rek['nama_peminjam'] . "</td>";
echo "<td align='center'>" . $rek['kategori_peminjam'] . "</td>";
echo "<td align='center'>" . $rek['kegiatan'] . "</td>";
echo "<td align='center'>" . $rek['waktu_peminjaman'] . "</td>";
echo "<td align='center'>" . $rek['durasi'] . "</td>";
echo "<td align='center'>" . $stat . "</td>";
echo "<td align='center'><a href='peminjaman_edit.php?idPeminjaman={$rek['id_peminjaman']}' class=\"btn btn-warning btn-xs btnUbahPeminjaman\" data-val=\"{$rek['id_peminjaman']}\" data-toggle=\"tooltip\" data-placement=\"top\" title=\"Edit Data\"><span class=\"glyphicon glyphicon-pencil\"></span></a></td>";
echo "<td align='center'><button class=\"btn btn-danger btn-xs btnHapusPeminjaman\" data-val=\"{$rek['id_peminjaman']}\" data-toggle=\"tooltip\" data-placement=\"top\" title=\"Hapus Data\" ><span class=\"glyphicon glyphicon-remove\"></span></button></td>";
echo "<tr>";
</div><!-- /.navbar-collapse -->
</div><!--- /continer -->
</nav><!-- /navbar -->
<div class="container-fluid">
<?php
require_once "dbconnect/dbconnect.php";
opendb();
if (isset($_POST['checkUser'])) {
if ($_POST['checkUser'] == "1a1") {
$qry = "SELECT password FROM administrator where username='******'";
$hsl = querydb($qry);
$jml_data = numrows($hsl);
if ($jml_data < 1) {
echo "<h3><center>Login Gagal</center></h3>";
} else {
$rek = arraydb($hsl);
if ($_POST["pwd"] == $rek["password"]) {
setcookie("LOGEE", "LOGOGO", time() + 300, "/");
echo "<h3><center>Login Berhasil</center></h3>";
} else {
echo "<h3><center>Login Unsuccesful</center></h3>";
}
}
} else {
echo "<h3><center>Login Unsuccesful</center></h3>";
}
} else {
echo "<h3><center>Login Unsuccesful</center></h3>";
}
echo "<center><br>Redirecting in 5 seconds...<br></center>";
header('Refresh: 5; URL=http://localhost/aPPLe/home.php');
<?php
/*if(session_status()!==2)session_start();//>=php 5.4
if(!isset($_SESSION['SES_LOGIN'])){
header('location:../home');
}*/
require_once "dbconnect/dbconnect.php";
require_once "functions.php";
opendb();
$kode = buatKode("peminjaman", "");
if (isset($_POST['tambahPeminjaman'])) {
$idAlat = trim($_POST['idAlat']);
//cari data item barang
$qri = "SELECT * FROM alat WHERE id_alat='{$idAlat}'";
$res = querydb($qri);
$rek = arraydb($res);
$namaAlat = $rek['nama_alat'];
}
?>
<div class="panel panel-primary alert alert-dissmisable alert-info" id="panelBarangTambah">
<div class="panel-heading"><span class="glyphicon glyphicon-plus"></span> TAMBAH DATA PEMINJAMAN
<div type="button" class="close" data-dismiss="alert">×</div>
</div>
<div class="panel-body">
<form class="form-horizontal" action="" method="post" name="formPeminjaman" id="formPeminjaman" target="" enctype="multipart/form-data" >
<div class="form-group form-group-sm">
<label for="idPeminjaman" class="col-sm-3 control-label pad-right-zero">Kode :</label>
<div class="col-sm-5">
<input type="text" class="form-control input-sm" value="<?php
<th>Kategori</th>
<th>Status</th>
<th colspan="2" align="center">Pilihan</th>
</tr>
<?php
$c = 1;
if (isset($_POST['key'])) {
$key = $_POST['key'];
$keys = $key . "%";
$qri = "SELECT * FROM alat WHERE nama_alat LIKE '" . $keys . "'";
$hsl = querydb($qri);
} else {
$qri = "SELECT * FROM alat ORDER BY id_alat ASC LIMIT {$posisi}, {$batas}";
$hsl = querydb($qri);
}
while ($rek = arraydb($hsl)) {
if ($rek['ketersediaan'] == "Y") {
$klsBaris = "";
$stat = "<span class='label label-info'>Tersedia</span>";
} else {
$klsBaris = "danger";
$stat = "<span class='label label-danger'>Tidak Tersedia</span>";
}
echo "<tr class=\"{$klsBaris}\">";
echo "<td align='center'>" . $c . "</td>";
echo "<td align='center'>" . $rek['id_alat'] . "</td>";
echo "<td align='left'>" . $rek['nama_alat'] . "</td>";
echo "<td align='center'>" . $rek['lokasi'] . "</td>";
echo "<td align='center'>" . $rek['kondisi'] . "</td>";
echo "<td align='center'>" . $rek['kategori'] . "</td>";
echo "<td align='center'>" . $stat . "</td>";
<?php
include "header.php";
include "/libchart/libchart/classes/libchart.php";
require_once "dbconnect/dbconnect.php";
opendb();
//Menentukan batas, cek halaman dan posisi data
$count = arraydb(querydb("\n\t\t\tselect * from (\n\n\t\t\t(select count(*) as nlaptop from alat natural join peminjaman \n\n\t\t\twhere lower(kategori)='laptop') a\n\n\t\t\tjoin\n\n\t\t\t(select count(*) as nsound from alat natural join peminjaman \n\n\t\t\twhere lower(kategori)='sound') as b\n\n\t\t\tjoin\n\n\t\t\t(select count(*) as nproyektor from alat natural join peminjaman \n\n\t\t\twhere lower(kategori)='proyektor') as c\n\n\t\t\tjoin\n\n\t\t\t(select count(*) as nlain from alat natural join peminjaman) as d\n\t\t\t)\t\t\t\t\t\t\n\t\t\t"));
$chart = new PieChart();
$nlain = $count['nlain'] - $count['nlaptop'] - $count['nproyektor'] - $count['nsound'];
$dataSet = new XYDataSet();
$dataSet->addPoint(new Point("Sound (" . $count['nsound'] . ")", $count['nsound']));
$dataSet->addPoint(new Point("Proyektor (" . $count['nproyektor'] . ")", $count['nproyektor']));
$dataSet->addPoint(new Point("Laptop (" . $count['nlaptop'] . ")", $count['nlaptop']));
$dataSet->addPoint(new Point("Misc (" . $nlain . ")", $nlain));
$chart->setDataSet($dataSet);
$chart->setTitle("Statistik Umum Peminjaman Barang");
$chart->render("generated/Peminjaman.png");
?>
<center><img alt="Pie chart" src="generated/Peminjaman.png" style="border: 1px solid gray;"/></center>
<script>
$('li:disabled').prop('disabled',true);
</script>
<?php
include "footer.php";
<a class="btn btn-default btn-sm" id="btnPeminjamanTambah" href="pemeliharaan_addpage.php?kategori=4">Proyektor</a>
<a class="btn btn-default btn-sm" id="btnPeminjamanTambah" href="pemeliharaan_addpage.php?kategori=5">Lain-lain</a></p>
<div class="table-responsive">
<table class="table table-striped table-bordered table-condensed table-hover">
<tr>
<th>No.</th>
<th>ID Alat</th>
<th>Nama Alat</th>
<th>Kategori</th>
<th>Kondisi</th>
<th>Status</th>
<th></th>
</tr>
<?php
$c = 1;
while (($rek = arraydb($hsl)) && $c <= 7) {
if ($rek['ketersediaan'] == "Y") {
$klsBaris = "";
$stat = "<span class='label label-info'>Available</span>";
} else {
$klsBaris = "danger";
$stat = "<span class='label label-danger'>Not Available</span>";
}
echo "<tr class=\"{$klsBaris}\">";
echo "<td align='center'>" . $c . "</td>";
echo "<td align='center'>" . $rek['id_alat'] . "</td>";
echo "<td align='left'>" . $rek['nama_alat'] . "</td>";
echo "<td align='center'>" . $rek['kategori'] . "</td>";
echo "<td align='center'>" . $rek['kondisi'] . "</td>";
echo "<td align='center'>" . $stat . "</td>";
echo "<td align='center'><button class=\"btn btn-danger btn-xs btnTambahPemeliharaan\" data-val=\"{$rek['id_alat']}\" data-toggle=\"tooltip\" data-placement=\"top\" title=\"Tambah Alat Rusak\"><span class=\"glyphicon glyphicon-list-alt\"></span></button></td>";
<?php
include "header.php";
include "/libchart/libchart/classes/libchart.php";
require_once "dbconnect/dbconnect.php";
opendb();
//Menentukan batas, cek halaman dan posisi data
$count = arraydb(querydb("\n\t\t\tselect * from (\n\n\t\t\t(select count(*) as nmahasiswa from peminjaman \n\n\t\t\twhere lower(kategori_peminjam)='mahasiswa') as a\n\n\t\t\tjoin\n\n\t\t\t(select count(*) as ndosen from peminjaman \n\n\t\t\twhere lower(kategori_peminjam)='dosen') as b\n\n\t\t\tjoin\n\n\t\t\t(select count(*) as nluar from peminjaman \n\n\t\t\twhere lower(kategori_peminjam)='luar') as c\n\n\t\t\t);\t\t\n\t\t\t"));
$chart = new PieChart();
$dataSet = new XYDataSet();
$dataSet->addPoint(new Point("Dosen (" . $count['ndosen'] . ")", $count['ndosen']));
$dataSet->addPoint(new Point("Mahasiswa (" . $count['nmahasiswa'] . ")", $count['nmahasiswa']));
$dataSet->addPoint(new Point("Luar (" . $count['nluar'] . ")", $count['nluar']));
$chart->setDataSet($dataSet);
$chart->setTitle("Statistik Umum Peminjam Barang");
$chart->render("generated/Peminjam.png");
?>
<center><img alt="Pie chart" src="generated/Peminjam.png" style="border: 1px solid gray;"/></center>
<script>
$('li:disabled').prop('disabled',true);
</script>
<?php
include "footer.php";
<?php
session_start();
if (!isset($_SESSION['SES_LOGIN'])) {
header('location:home');
//echo "<script>document.location.href='home'</script>";
}
require_once "library/inc.connection.php";
require_once "library/inc.library.php";
opendb();
//cari data toko
$qri = "SELECT * FROM ma_toko";
$res = querydb($qri);
$rec = arraydb($res);
$namaToko = $rec['nm_toko'];
//cari data user
$_SESSION['SES_LOGIN'] ? $user_id = trim($_SESSION['SES_LOGIN']) : ($user_id = "");
$_SESSION['USER_LEVEL'] ? $levelAkses = trim($_SESSION['USER_LEVEL']) : ($levelAkses = "");
?>
<!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">
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
<title><?php
echo $namaToko;
?>
</title>
<link rel="icon" href="img/favicon.ico" type="image/x-icon">
opendb();
//data:{ubahBarang:'',kdBarang:kdBarang},
if (isset($_GET['idPemeliharaan'])) {
$idPemeliharaan = $_GET['idPemeliharaan'];
//cari data item barang
$qri = "SELECT * FROM pemeliharaan WHERE id_kerusakan='{$idPemeliharaan}'";
$res = querydb($qri);
$rek = arraydb($res);
$idAlat = $rek['id_alat'];
$startBroken = $rek['start_broken'];
$startRepair = $rek['start_repair'];
$finishRepair = $rek['finish_repair'];
//cari data alat
$qri2 = "SELECT nama_alat FROM alat WHERE id_alat='{$idAlat}'";
$res2 = querydb($qri2);
$rek2 = arraydb($res2);
$namaAlat = $rek2['nama_alat'];
}
include "header.php";
?>
<div class="panel panel-primary alert alert-dissmisable alert-warning" id="panelEditPeminjaman">
<div class="panel-heading"><span class="glyphicon glyphicon-plus"></span> UBAH DATA PEMELIHARAAN
</div>
<div class="panel-body">
<form class="form-horizontal" action="pemeliharaan_proses.php?idPemeliharaan=<?php
echo $idPemeliharaan;
?>
" method="post" name="formPemeliharaan" id="formPemeliharaan" target="" enctype="multipart/form-data" >
<div class="form-group form-group-sm">
echo "<option value='Hilang' selected>HILANG</option>";
} else {
echo "<option value='Hilang'>HILANG</option>";
}
}
?>
</select>
</div>
</div>
<div class="form-group form-group-sm">
<label for="ketersediaan" class="col-sm-3 control-label pad-right-zero">Ketersediaan :</label>
<div class="col-sm-5">
<select class="form-control" name="txtKetersediaan" id="txtKetersediaan" required>
<option value="">---Pilih---</option>
<?php
while ($rek4 = arraydb($res4)) {
if ($ketersediaan == 'Y') {
echo "<option value='Y' selected>Tersedia</option>";
} else {
echo "<option value='Y'>Tersedia</option>";
}
if ($ketersediaan == 'T') {
echo "<option value='T' selected>Tidak Tersedia</option>";
} else {
echo "<option value='T'>Tidak Tersedia</option>";
}
}
?>
</select>
</div>
</div>
