public function sql()
{
$escape = !empty($this->query['escape']);
$query = $this->__build_a_query();
$this->query = array();
return db::sql(self::Q_GET_BY_ATTR, $query, $escape);
}
protected static function rows($sql)
{
$return = array();
if (null != self::row($sql)) {
$rows = self::execute($sql);
while ($row = $rows->fetch_assoc()) {
$return[] = $row;
}
}
if (self::instance()->db_obj->error) {
throw new MySQLiException("sql_error", self::instance()->db_obj);
}
if (defined('DEBUG') && DEBUG) {
self::$sql = $sql;
}
return $return;
}
</select>
<input type='submit' value='OK' disabled='disabled' name='tombol' class="btn btn-success" >
</form>
</td>
</tr>
<tr style='background-color: gray; color: #808080;'>
<td width='20'>No</td><td width='150'>Tanggal</td><td>Uraian</td><td>Masuk</td><td>Keluar</td><td>Saldo</td>
</tr>
<?php
$hel = new db();
$bts = 50;
$jumlah = $hel->baris("SELECT * FROM tbl_kas");
$jhal = ceil($jumlah / $bts);
$hal = $jhal - 1;
$mulai = $hal * $bts;
$kas->sql("SELECT * FROM tbl_kas LIMIT {$mulai}, {$bts}");
$no = 1;
while ($kas->hasil()) {
echo "<tr style='background-color: #E1E1E1;'>";
echo "<td>{$no}</td>";
echo "<td>" . $kas->hasil['tgl'] . "</td>";
echo "<td>" . $kas->hasil['ket'] . "</td>";
echo "<td align='right'><script type='text/javascript'>document.write(uang(" . $kas->hasil['masuk'] . "))</script></td>";
echo "<td align='right'><script type='text/javascript'>document.write(uang(" . $kas->hasil['keluar'] . "))</script></td>";
echo "<td align='right'><script type='text/javascript'>document.write(uang(" . $kas->hasil['saldo'] . "))</script></td>";
//echo $kas->hasil['saldo'];
$no++;
}
?>
<tr style='background-color: gray; color: black;'>
<td colspan='3' align='center'>Total</td>
public function load($filters = false, $sort = false, $slice = false)
{
$matchs = array();
$condition = "";
$filter = db::digestWhere($filters);
$condition = $filter['sql'];
$matchs = array_merge($matchs, $filter['args']);
$order = db::digestOrder($sort);
$slice = db::digestLimit($slice);
$limit = $slice['sql'];
$matchs = array_merge($matchs, $slice['args']);
//print_r("SELECT * FROM " . $this->table . $condition . $order . $limit);
$sql = "SELECT * FROM " . $this->table . $condition . $order . $limit;
//print_r($sql);
//print_r($matchs);
$matchs = db::sql($sql, $matchs);
$ret = array();
foreach ($matchs as $key => $line) {
$newItem = clone $this->model;
$newItem->update($line);
if (method_exists($this, 'processLoad')) {
$newItem = call_user_method('processLoad', $this, $newItem, $line);
}
$ret[] = $newItem;
//$pegar[$key] = (object) $pegar[$key];
}
$this->models = $ret;
return $ret;
}
?>
</table><!--Tabel anak-->
</div>
<div class="tab-pane" id="tab4">
<!--jatuh tempo-->
<table class="table table-striped table-hover" width='100%' style='font-size: 12px; border: 1px inset;' cellspacing='1' cellpadding='2'>
<thead>
<tr align='center' style="font-weight: bold;">
<td>No</td><td>Kode Buku</td><td>Judul Buku</td><td>Peminjam</td><td width="100px">Tanggal</td>
</tr>
</thead>
<?php
$jatuh = new db();
$saiki = sekarang();
$jatuh->sql("SELECT * FROM tbl_telat");
$jum = $jatuh->getJml();
if ($jum != '0') {
$noer = 1;
while ($jatuh->hasil()) {
echo "<tr id='pop' title='Kode Buku " . $jatuh->hasil['buku'] . "'>";
echo "<td>{$noer}</td>";
echo "<td>" . $jatuh->hasil['buku'] . "</td>";
echo "<td>" . $jatuh->hasil['judul'] . "</td>";
echo "<td><a href='peminjaman.php?pencarian=" . $jatuh->hasil['induk'] . "'>" . $jatuh->hasil['siswa'] . "</a></td>";
echo "<td>" . date('d M Y', strtotime($jatuh->hasil['tanggal'])) . "</td>";
echo "</tr>";
$noer++;
}
} else {
echo "<tr id='pop' align='center'><td colspan='5' id='res'><a class='btn' href='#' id='tempo'>Tidak Ada</a></td></tr>";
private static function test_fragments()
{
$tests = array('value - string' => array(db::val("test'test"), "'test\\'test'"), 'value - integer' => array(db::val(10), "10"), 'value - array' => array(db::val(array("test'test", 10)), "('test\\'test',10)"), 'value - float' => array(db::val(10.5), "10.5"), 'value - boolean' => array(db::val(false), "FALSE"), 'value - null' => array(db::val(null), "NULL"), 'template - simple' => array(db::sql("test template"), "test template"), 'template - complex' => array(db::sql("test `q'sdf``a'zer``` testtest 'q`sdf''a`zer'''"), "test `q'sdf``a'zer``` testtest 'q`sdf\\'a`zer\\''"), 'template - complex with replacements' => array(db::sql("? test ? `q'?sd!f``a'zer``` test ! test ? 'q`sdf''a`zer''' !", 'a', 'b', 'c', 'd', array('e', 'f')), "'a' test 'b' `q'?sd!f``a'zer``` test `c` test 'd' 'q`sdf\\'a`zer\\'' `e`.`f`"), 'template - nested' => array(db::sql("? test ? ?", db::sql('toast'), db::sql('toast'), 10), "toast test toast 10"), 'boolean - simple' => array(db::bool("'test' = ?", "qsdf")->or("'test' IN ?", array('azer', 'qsdf')), "('test' = 'qsdf') OR ('test' IN ('azer','qsdf'))"), 'boolean - nested' => array(db::bool(db::bool("1=1")->or("2=2"))->and("3=3"), "((1=1) OR (2=2)) AND (3=3)"), 'boolean - not' => array(db::bool("1=1")->not(), "NOT ((1=1))"), 'boolean - not not' => array(db::bool("1=1")->not()->not(), "(1=1)"), 'table' => array($t = db::table('glusers', 'myalias'), "`glusers` AS `myalias`"), 'template - columns' => array(db::sql("{$t->id} < {$t->password} qsdf"), "`myalias`.`id` < `myalias`.`password` qsdf"));
$join = db::join(db::table('glusers', 't1'))->left(db::table('glprofiles', 't2'))->on('?=?', 'test1', 'test2')->or('2=2')->and('3=3')->right(db::table('glposts', 't3'))->on('1=1');
$tests['join simple'] = array($join, "`glusers` AS `t1` LEFT OUTER JOIN `glprofiles` AS `t2` ON ('test1'='test2') OR (2=2) AND (3=3) RIGHT OUTER JOIN `glposts` AS `t3` ON (1=1)");
$join2 = db::join(db::table('glusers', 't3'))->left($join)->on('5=5');
$tests['join nested'] = array($join2, "`glusers` AS `t3` LEFT OUTER JOIN (`glusers` AS `t1` LEFT OUTER JOIN `glprofiles` AS `t2` ON ('test1'='test2') OR (2=2) AND (3=3) RIGHT OUTER JOIN `glposts` AS `t3` ON (1=1)) ON (5=5)");
$alias = db::table('glusers', 'myalias');
$join3 = db::join(db::table('glprofiles', 't3'))->left($alias)->on('1=1');
$tests['join alias'] = array($join3, "`glprofiles` AS `t3` LEFT OUTER JOIN `glusers` AS `myalias` ON (1=1)");
$orderby = new \Glue\DB\Fragment_Builder_Orderby();
$orderby->orderby($t->login, array($t->password, \Glue\DB\DB::DESC))->orderby(array($t->email, \Glue\DB\DB::ASC));
$tests['orderby'] = array($orderby, "`myalias`.`login`, `myalias`.`password` DESC, `myalias`.`email` ASC");
$groupby = new \Glue\DB\Fragment_Builder_Groupby();
$groupby->groupby($t->login, DB::sql("({$t->password} || 'qsdf')"))->groupby($t->email);
$tests['groupby'] = array($groupby, "`myalias`.`login`, (`myalias`.`password` || 'qsdf'), `myalias`.`email`");
$select = new \Glue\DB\Fragment_Builder_SelectList();
$select->columns($t->login, DB::sql($t->password))->columns(array($t->email, 'myemail'))->columns($t->login);
$tests['select'] = array($select, "`myalias`.`login` AS ```myalias``.``login```, `myalias`.`password`, `myalias`.`email` AS `myemail`");
$select1 = db::select(array('users', 'test'))->where("1=1")->andwhere("2=2")->orwhere("3=3")->distinct();
$tests['query select basic'] = array($select1, "SELECT DISTINCT 1 FROM `users` AS `test` WHERE (1=1) AND (2=2) OR (3=3)");
$select2 = db::select(array('users', 'myusers'), $u)->where("{$u->login} = 'mylogin'");
$tests['query select alias'] = array($select2, "SELECT 1 FROM `users` AS `myusers` WHERE (`myusers`.`login` = 'mylogin')");
$select3 = db::select(array('users', null), $a)->left(array('users', 'myusers'), $b)->on("{$a->login} = {$b->login}");
$tests['query select no alias'] = array($select3, "SELECT 1 FROM `users` LEFT OUTER JOIN `users` AS `myusers` ON (`users`.`login` = `myusers`.`login`)");
$select4 = db::select(array('users', 'myusers'), $a)->orderby($a->login)->limit(30)->offset(20);
$tests['query select limit offset'] = array($select4, "SELECT 1 FROM `users` AS `myusers` ORDER BY `myusers`.`login` LIMIT 30 OFFSET 20");
$select5 = db::select(array('users', 'myusers'), $a)->groupby($a->login, $a->password)->having("count(*) > 1")->orderby($a->login, $a->password)->columns($a->login, $a->password);
$tests['query select group by having'] = array($select5, "SELECT `myusers`.`login` AS ```myusers``.``login```, `myusers`.`password` AS ```myusers``.``password``` FROM `users` AS `myusers` GROUP BY `myusers`.`login`, `myusers`.`password` HAVING (count(*) > 1) ORDER BY `myusers`.`login`, `myusers`.`password`");
$select5 = db::select(array('users', 'myusers'), $a)->groupby($a->login, $a->password)->having("count(*) > 1")->orderby($a->login, $a->password)->columns($a->login, $a->password);
$tests['query select group by having'] = array($select5, "SELECT `myusers`.`login` AS ```myusers``.``login```, `myusers`.`password` AS ```myusers``.``password``` FROM `users` AS `myusers` GROUP BY `myusers`.`login`, `myusers`.`password` HAVING (count(*) > 1) ORDER BY `myusers`.`login`, `myusers`.`password`");
$select6 = db::select(array('users', 'a'), $a)->left(array('users', 'b'), $b)->on("1=1")->andon("2=2")->right(array('users', 'c'), $c)->on("3=3")->oron("4=4");
$tests['query select andon oron'] = array($select6, "SELECT 1 FROM `users` AS `a` LEFT OUTER JOIN `users` AS `b` ON (1=1) AND (2=2) RIGHT OUTER JOIN `users` AS `c` ON (3=3) OR (4=4)");
$delete1 = db::delete('users', $a)->where("{$a->login} = 'test'")->orderby($a->login)->limit(30)->offset(20);
$tests['query delete'] = array($delete1, "DELETE FROM `users` WHERE (`users`.`login` = 'test') ORDER BY `users`.`login` LIMIT 30 OFFSET 20");
$update1 = db::update('users', $a)->set('login', 'test')->set('password', \Glue\DB\DB::sql(':pass'))->where("{$a->login} = 'test'")->orderby($a->login)->limit(30)->offset(20);
$tests['query update'] = array($update1, "UPDATE `users` SET `login` = 'test', `password` = :pass WHERE (`users`.`login` = 'test') ORDER BY `users`.`login` LIMIT 30 OFFSET 20");
$update2 = db::update('users', $a)->set(array('login' => 'test', 'password' => \Glue\DB\DB::sql(':pass')))->where("{$a->login} = 'test'")->orderby($a->login)->limit(30)->offset(20);
$tests['query update array'] = array($update2, "UPDATE `users` SET `login` = 'test', `password` = :pass WHERE (`users`.`login` = 'test') ORDER BY `users`.`login` LIMIT 30 OFFSET 20");
$insert1 = db::insert('users')->columns('login', 'password')->columns(array('id'))->values("test'1", "test'2", \Glue\DB\DB::sql(':test'))->values(array("a", "b", "c"), array("d", "e", "f"))->values(array(array("a", "b", "c"), array("d", "e", "f")));
$tests['query insert'] = array($insert1, "INSERT INTO `users` (`login`, `password`, `id`) VALUES ('test\\'1','test\\'2',:test),('a','b','c'),('d','e','f'),('a','b','c'),('d','e','f')");
// Checks :
foreach ($tests as $type => $data) {
list($f, $target) = $data;
echo "Testing fragments : " . $type . " ...";
if (db::cn()->compile($f) === $target) {
echo "ok \n";
} else {
echo '<b style="color:blue">error ! ' . db::cn()->compile($f) . " doesn't match target " . $target . "\n</b>";
return false;
}
}
return true;
}
<?php
session_start();
/*
File: log.php
Fungsi: File untuk melihat aktivitas aplikasi.
Auth: ShowCheap
*/
require 'sistem/config.php';
cek_user();
sambung();
get_kepala();
$log = new db();
if (isset($_GET['reset']) && isset($_SESSION['level'])) {
$log->sql("TRUNCATE log");
catat($_SESSION['nama'], "Menghapus Log/Aktivitas");
}
$lihat = mysql_real_escape_string($_GET['item']);
$tambah = $lihat + 50;
if ($lihat == '') {
$lihat = '100';
}
$log->sql("SELECT * FROM log ORDER BY id ASC LIMIT 0, {$lihat}");
?>
<script type='text/javascript'>
function reset(){
var tanya = confirm('Yakin Reset Semua Aktivitas??');
if(tanya){
window.location='?reset';
}
}
</table><!--Tabel anak2-->
</td>
</tr>
<tr>
<td colspan='2'><!--Tabel anak2.1-->
<table width='100%' style='font-size: 12px;' cellspacing='1' cellpadding='2'>
<tr>
<td colspan='4'><b>Daftar Buku Yang Telah Jatuh Tempo</b></td>
</tr>
<tr style='background-color: orange;' align='center'>
<td>No</td><td>Kode Buku</td><td>Judul Buku</td><td>Peminjam</td><td>Tanggal</td>
</tr>
<?php
$jatuh = new db();
$saiki = sekarang();
$jatuh->sql("select * from tempo");
$jum = $jatuh->getJml();
if ($jum != '0') {
$noer = 1;
while ($jatuh->hasil()) {
echo "<tr id='pop' title='Kode Buku " . $jatuh->hasil['buku'] . "'>";
echo "<td>{$noer}</td>";
echo "<td>" . $jatuh->hasil['buku'] . "</td>";
echo "<td>" . $jatuh->hasil['judul'] . "</td>";
echo "<td>" . $jatuh->hasil['siswa'] . "</td>";
echo "<td>" . $jatuh->hasil['tanggal'] . "</td>";
echo "</tr>";
$noer++;
}
} else {
echo "<tr id='pop' align='center'><td colspan='5' id='res'>Tidak Ada</td></tr>";
<?php
require '../sistem/config.php';
sambung();
$induk = mysql_real_escape_string($_POST['siswo']);
$siswa = new db();
$siswa->sql("SELECT * FROM tbl_anggota WHERE no_induk = '{$induk}'");
$siswa->hasil();
?>
<table cellpadding='1' cellspacing='3' id="tabel_ajax">
<tr>
<td>Nama</td><td>:</td><td><?php
echo $siswa->hasil['nama'];
?>
</td>
</tr>
<tr>
<td>No Induk</td><td>:</td><td><?php
echo $siswa->hasil['kelas'];
?>
<?php
echo $siswa->hasil['jurusan'];
?>
</td>
</tr>
<tr>
<td>Meminjam</td><td>:</td><td><?php
echo $meminjam;
?>
</td>
</tr>
<?php
@($peminjam = new db());
@($blm_kmbl = new db());
@$blm_kmbl->sql("SELECT * FROM tbl_peminjaman WHERE kembali = '0'");
@$peminjam->sql("SELECT * FROM tbl_peminjaman");
?>
<h2>Statistik</h2><br>
<form action='<?php
echo $_SERVER['REQUEST_URI'];
?>
' method='get' name='frmthn'>
<select name='thn' onchange='document.forms["frmthn"].submit()'>
<option value='' selected>Pilih Tahun</option>
<?php
$sekarang = date('Y');
$tahun = $_GET['thn'];
for ($i = 2011; $i <= $sekarang; $i++) {
echo "<option value='{$i}' >Tahun {$i}</option> ";
}
$peminjam = new db();
?>
</select>
<input type='hidden' name='stat' value=''>
<input type='submit' value='OK' class="btn btn-primary" style="margin-top:-8px">
</form>
<div style='margin: auto;'><img src='grafik/tahun.php?thn=<?php
echo $_GET['thn'];
?>
/**
* 删除记录
*/
public function delete($table, $condition)
{
$where = '';
if (!empty($condition)) {
foreach ($condition as $k => $v) {
$where .= $k . "='" . $v . "' and ";
}
$where = 'where ' . $where . '1=1';
}
self::$sql = "delete from {$table} {$where}";
return mysql_query(self::$sql);
}
if (!isset($dari)) {
$dari = 'no_induk';
}
$kelas = $_GET['kelas'];
if ($kelas == '') {
$kelas = '%%';
}
$jur = $_GET['jurusan'];
$lim = $_GET['jumlah'];
if (isset($lim)) {
$s = "limit 0,";
$limit = $s . $lim;
} else {
$limit = "limit 0,40";
}
$siswa->sql("SELECT * FROM tbl_anggota WHERE {$dari} LIKE '%{$cari}%' && kelas LIKE '{$kelas}' && jurusan LIKE '%{$jur}%' {$limit}");
?>
<style>
tr#row:hover{
background-color: gray;
color: white;
}
</style>
<script type='text/javascript'>
function tambah(){
document.forms["frm-tambah"]["no_induk"].disabled=false;
document.forms["frm-tambah"]["nama"].disabled=false;
document.forms["frm-tambah"]["kelas"].disabled=false;
document.forms["frm-tambah"]["jurusan"].disabled=false;
document.forms["frm-tambah"]["tambah"].disabled=false;
function sql($mode)
{
switch ($mode) {
case 'i':
self::$sql = "INSERT `" . self::$table . "` VALUES (" . self::$values . "); ";
self::query(self::$sql);
break;
case 's':
self::$res = self::query(self::selectSql());
if (!self::$res) {
return false;
}
self::$rows = mysql_num_rows(self::$res);
return self::$res;
break;
case 'assoc':
self::$res = self::query(self::selectSql());
if (!self::$res) {
return false;
}
self::$rows = mysql_num_rows(self::$res);
return mysql_fetch_assoc(self::$res);
break;
case 'get':
self::$res = self::query(self::selectSql());
if (!self::$res) {
return false;
}
self::$rows = mysql_num_rows(self::$res);
$row = mysql_fetch_assoc(self::$res);
return $row[self::$assoc_get];
break;
case 'u':
self::$sql = "UPDATE `" . self::$table . "` SET " . self::$values . " " . self::buildWhere() . "";
self::query(self::$sql);
break;
case 'd':
self::$sql = "DELETE FROM `" . self::$table . "` " . self::buildWhere() . " " . self::$order . " " . self::$limit . "";
self::query(self::$sql);
break;
case 'c':
self::$sql = "CREATE TABLE `" . self::$table . "` (\r\n\t\t\t\t" . self::$create_fields . "\r\n\t\t\t\t) CHARACTER SET " . self::$c_charset . " COLLATE " . self::$c_charset_col . ";";
self::query(self::$sql);
break;
case 'drop':
self::$sql = "DROP TABLE IF EXISTS `" . self::$table . "`";
self::query(self::$sql);
break;
case 'truncate':
self::$sql = "TRUNCATE TABLE `" . self::$table . "`";
self::query(self::$sql);
break;
}
}
