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;
}
function userauth($ID, $PWD, $db_conn)
{
$ID = addslashes($ID);
$sqlcmd = "SELECT * FROM Member WHERE id='{$ID}' AND state<>'N'";
$rs = querydb($sqlcmd, $db_conn);
$retcode = 0;
if (count($rs) > 0) {
$Password = sha1($PWD);
if ($Password == $rs[0]['mpwd']) {
$retcode = 1;
}
}
return $retcode;
}
?>
</div>
<select id='Things'>
<?php
$sqlcmd = "SELECT COUNT(*) AS kind FROM Orders WHERE tno={$tnO}";
$rs = querydb($sqlcmd, $db_conn);
$kind = $rs[0]['kind'];
$sqlcmd = "SELECT * FROM Orders WHERE tno={$tnO}";
$rs = querydb($sqlcmd, $db_conn);
for ($i = 0; $i < $kind; $i++) {
$PNO = $rs[$i]['pno'];
$Amount = $AA = $rs[$i]['amount'];
$sqlcmd = "SELECT * FROM Product WHERE pno={$PNO}";
$Rs = querydb($sqlcmd, $db_conn);
echo "<option>（" . $Amount . "）" . $Rs[0]['pname'] . "</option>";
}
?>
</select>
<?php
}
?>
<div id="gotop" onMouseOver="Over()" onMouseOut="Out()"
onClick="location='<?php
echo $WebHost;
?>
'">˄</div>
</body>
} else {
$errMsg .= "\n\t\t\t\t\t<div class=\"alert alert-danger alert-dismissible\" role=\"alert\">\n\t\t\t\t\t\t<button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-label=\"Close\"><span aria-hidden=\"true\">×</span></button>\n\t\t\t\t\t\tGAGAL !!! Data Tidak Bisa Dirubah, harap ulang input data!\n\t\t\t\t\t</div>\n\t\t\t\t";
}
//convert data menjadi json format
$data = array('msg1' => $errMsg, 'msg2' => '');
echo json_encode($data);
}
if (isset($_POST['hapusBarang'])) {
$errMsg = "";
$idAlat = $_POST['idAlat'];
$qri = "DELETE FROM alat WHERE id_alat='" . $idAlat . "'";
$res = querydb($qri);
if ($res) {
$errMsg .= "<div class=\"alert alert-success alert-dismissible\" role=\"alert\">";
$errMsg .= "<button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-label=\"Close\"><span aria-hidden=\"true\">×</span></button>";
$errMsg .= "SUKSES !!! Data sudah dihapus!!!";
$errMsg .= "</div>";
$qri2 = "DELETE FROM peminjaman WHERE id_alat='" . $idAlat . "'";
$res2 = querydb($qri2);
$qri3 = "DELETE FROM pemeliharaan WHERE id_alat='" . $idAlat . "'";
$res3 = querydb($qri3);
} else {
$errMsg .= "<div class=\"alert alert-danger alert-dismissible\" role=\"alert\">";
$errMsg .= "<button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-label=\"Close\"><span aria-hidden=\"true\">×</span></button>";
$errMsg .= "GAGAL !!! Data tidak bisa dihapus !!!";
$errMsg .= "</div>";
}
//convert data menjadi json format
$data = array('msg1' => $errMsg, 'msg2' => '');
echo json_encode($data);
}
}
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>";
<li><a href="login_form.php"><span class="glyphicon glyphicon-log-out"></span> Login</a></li>
<?php
}
?>
</ul>
</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>";
}
<?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>Lokasi</th>
<th>Kondisi</th>
<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>";
<?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";
<?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";
'>
<table cellpadding="3">
<?php
$PutLine = 0;
foreach ($MRS as $M) {
$PutLine += 1;
$havePIC = 'upload/def.jpg';
$Time = $M['time'];
$USER = $M['id'];
$essay = $M['content'];
$time = getdate($Time);
$timeSTR = "<font color='white'>" . $time['hours'] . ':' . $time['minutes'] . ':' . $time['seconds'] . "</font><BR>" . $time['year'] . '/' . $time['mon'] . '/' . $time['mday'];
$sqlcmd = "SELECT * FROM Member WHERE ID='{$USER}' AND state<>'N'";
$PICRS = querydb($sqlcmd, $db_conn);
if (!empty($PICRS[0]['type'])) {
$TMPSTR = str_pad($PICRS[0]['pic'], 5, "0", STR_PAD_LEFT) . $PICRS[0]['type'];
$havePIC = "upload/{$TMPSTR}";
}
?>
<TR><TD class='Muser' width="15%">
<DIV class="thumb">
<?php
$pic = getimagesize($havePIC);
if ($pic[0] > $pic[1]) {
echo "<img src='{$havePIC}' alt='pic' style='width:99%'/>" . "<BR>";
} else {
echo "<img src='{$havePIC}' alt='pic' style='height:99%'/>" . "<BR>";
}
?>
require_once "dbconnect/dbconnect.php";
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" >
//cari data item barang
$qri = "SELECT * FROM alat WHERE id_alat='{$idAlat}'";
$res = querydb($qri);
$rek = arraydb($res);
$namaAlat = $rek['nama_alat'];
$lokasi = $rek['lokasi'];
$kategori = $rek['kategori'];
$kondisi = $rek['kondisi'];
$ketersediaan = $rek['ketersediaan'];
//cari data kondisi
$qri2 = "SELECT kondisi FROM alat WHERE id_alat='{$idAlat}'";
$res2 = querydb($qri2);
$qri3 = "SELECT kategori FROM alat WHERE id_alat='{$idAlat}'";
$res3 = querydb($qri3);
$qri4 = "SELECT ketersediaan FROM alat WHERE id_alat='{$idAlat}'";
$res4 = querydb($qri4);
}
?>
<div class="panel panel-primary alert alert-dissmisable alert-warning" id="panelBarangTambah">
<div class="panel-heading"><span class="glyphicon glyphicon-plus"></span> UBAH DATA ALAT
<div type="button" class="close" data-dismiss="alert">×</div>
</div>
<div class="panel-body">
<form class="form-horizontal" action="" method="post" name="formBarang" id="formBarang" target="" enctype="multipart/form-data" >
<div class="form-group form-group-sm">
<label for="idAlat" class="col-sm-3 control-label pad-right-zero">ID Alat :</label>
<div class="col-sm-5">
<input type="text" class="form-control input-sm" value="<?php
echo $idAlat;
?>
" id="idAlat" name="idAlat" readonly="readonly">
function getoneRecord($table, $wh, $field = "*", $method = MYSQL_BOTH)
{
/*
get one record
this function return you one or more recor with specific pefix condition
*/
$Q_SELECT = querydb("SELECT {$field} FROM " . $table . " WHERE {$wh} LIMIT 1", 0, "<span style=\"color:#4455ff;\">_getOneRecord()</span>");
if ($reply = @mysqli_fetch_array($Q_SELECT, $method)) {
return $reply;
}
}
