示例#1
0
<?php

$nid = getsx('nid');
$t = mysql_query("SELECT * FROM " . DB_HRD . " WHERE nip='{$nid}' LIMIT 0,1");
$f = dbFAx($t);
$member = $f['nip'];
$membername = $r['fname'];
?>
<div class="hl2" style="margin-bottom:6px">Member who wants to return book:</div>
<?php 
require_once VWDIR . 'v_cir_staff_info.php';
require_once VWDIR . 'v_cir_staff_list.php';
?>
</div>
<script type="text/javascript" language="javascript">
<?php 
if ($act == 'loan') {
    ?>
$('document').ready(function(){
	 pqueue('cq',0);
	 E('keyw').focus();
});
<?php 
}
?>
</script>
示例#2
0
<?php

$q = getsx('q');
if ($q == "newcatalog") {
    $a = array('title', 'author', 'author2', 'publisher', 'class', 'classcode', 'isbn', 'release', 'series', 'language', 'cover');
    $inp = array();
    foreach ($a as $k => $v) {
        $inp[$v] = gpost($v);
    }
    if (dbInsert("catalog", $inp)) {
        $dcid = mysql_insert_id();
        echo "T" . $dcid . "~Catalog information has been saved.";
    } else {
        echo 'F0~<span style="colo:#ff0000">Failed to save book information.</span>';
    }
} else {
    if ($q == "editcatalog") {
        $dcid = gpost('dcid');
        $a = array('title', 'author', 'author2', 'publisher', 'class', 'classcode', 'isbn', 'release', 'series', 'language', 'cover');
        $inp = array();
        foreach ($a as $k => $v) {
            $inp[$v] = gpost($v);
        }
        if (dbUpdate("catalog", $inp, "dcid='{$dcid}'")) {
            echo "T" . $dcid . "~Catalog information has been saved.";
        } else {
            echo 'F0~<span style="colo:#ff0000">Failed to save book information.</span>';
        }
    } else {
        if ($q == "addbook") {
            $a = array('catalog', 'barcode', 'nid', 'callnumber', 'shelf', 'source', 'sourceval');
示例#3
0
<?php

session_start();
require_once 'system/config.php';
require_once SYSDIR . 'db.php';
require_once LIBDIR . 'common.php';
$r['ntable'] = getsx('ntable');
?>
<html><head>
<?php 
require_once SYDIR . 'main.php';
require_once MODDIR . 'control.php';
?>
<style type="text/css">
.box1{
	color:#fff;width:76px;margin:0 2px 2px 0;float:left;background:#5595ff;text-align:center
}
.box0{
	color:#999;width:76px;margin:0 2px 2px 0;float:left;background:#f0f0f0;text-align:center
}
</style>
<script type="text/javascript" src="jsscript/jquery.js"></script>
<script type="text/javascript">
function relod(){
	location.reload(true);
	//alert('a');
	//E('box').innerHTML='';
}
</script>
</head><body>
<?php 
示例#4
0
<?php

/* Pre Data Processing */
$loan_limit = dbFetch("val", "mstr_setting", "W/dcid=5");
require_once MODDIR . 'pagelink.php';
$nid = getsx('nid');
$t = mysql_query("SELECT * FROM " . DB_HRD . " WHERE nip='{$nid}' LIMIT 0,1");
$f = dbFAx($t);
$member = dbFAx($t);
// Show
$show = gets('show') == 'all' ? '1' : '0';
// Sorting:
$sortby = getsx('sortby');
$sortmode = getsx('mode');
$sf = false;
$sm = $sortmode == '1' ? " DESC" : "";
if ($sortby == 'shelf') {
    $sql = "SELECT t1.* FROM book t1 JOIN mstr_shelf t2 ON t1.shelf = t2.dcid WHERE catalog='{$nid}' ORDER BY t2.name" . $sm;
    $sf = true;
} else {
    // Sorting fields
    $sfa = array('date2', 'status');
    foreach ($sfa as $k => $v) {
        if ($sortby == $v) {
            $sf = true;
        }
    }
    if ($sf) {
        $sfi = $sortby;
    } else {
        $sfi = $sfa[0];
示例#5
0
        $smode = '1';
    } else {
        $smode = '0';
    }
}
// Queries:
$t = mysql_query($sql);
$ndata = mysql_num_rows($t);
// Paging:
$page_link = RLNK . "book.php?tab=manage";
// number per page
$npp = 20;
// number of page
$nop = ceil($ndata / $npp);
// current page
$page = getsx('page');
if ($page == '') {
    $page = 1;
}
if (intval($page) > $ndata) {
    $page = $ndata;
}
if (intval($page) < 1) {
    $page = 1;
}
// number in page row start
$nps = $npp * ($page - 1);
// number in page row last
$npl = $nps + $npp;
// find item update location
$l = -1;
示例#6
0
<?php

if (session_id() == "") {
    session_start();
}
header('Content-type: image/jpeg');
require_once 'system/config.php';
require_once SYSDIR . 'db.php';
require_once LIBDIR . 'common.php';
$dcid = getsx('id');
$t = dbSel("photo", "emp_photo", "W/empid='{$dcid}'");
if (mysql_num_rows($t) > 0) {
    $r = dbFA($t);
    echo base64_decode($r['photo']);
} else {
    echo "Error!";
}
示例#7
0
<?php

$keyw = trim(getsx('k'));
$npf = 0;
$ids = "ALL";
if ($keyw != '') {
    function src_replace($v)
    {
        global $keyw;
        return preg_replace("/" . $keyw . "/i", "<strong>\$0</strong>", $v);
    }
    function strBC($a)
    {
        $s = strval($a);
        if (strlen($s) < 5) {
            for ($i = strlen($s); $i < 5; $i++) {
                $s = '0' . $s;
            }
        }
        return $s;
    }
    if (preg_match("/^[0-9]+\$/", $keyw)) {
        // find by barcode
        $bcl = array();
        $t = dbSel("barcode", "p_label");
        while ($r = dbFA($t)) {
            $bcl[$r['barcode']] = '1';
        }
        $sql = "SELECT * FROM book WHERE barcode='{$keyw}' LIMIT 0,1";
        $q = mysql_query($sql);
        $n = mysql_num_rows($q);
示例#8
0
"> < </a></td>
		<?php 
        for ($n = 1; $n <= $nop; $n++) {
            ?>
		<td><a class="plink<?php 
            echo $n != $page ? "\" title=\"Go to page {$n}\" href=\"" . pageLinkp($n, getsx('sortby'), getsx('mode'), getsx('q')) : "a";
            ?>
"><?php 
            echo $n;
            ?>
</a></td>
		<?php 
        }
        ?>
		<td><a class="plink<?php 
        echo $page < $nop ? "\" title=\"Go to next page\" href=\"" . pageLinkp($page + 1, getsx('sortby'), getsx('mode'), getsx('q')) : "o";
        ?>
"> > </a></td>
	</tr></table>
	<?php 
    }
    ?>
</td>
</tr></table></div>
<?php 
} else {
    ?>
<div class="sfont" style="padding-top:30px;margin-bottom:20px">There is no stock take process finished</div>
<button type="button" class="btn" value="Back" style="margin-right:6px" onclick="jumpTo('<?php 
    echo RLNK;
    ?>
示例#9
0
function getCPageLinkp()
{
    $pg = getsx('page');
    $sb = getsx('sortby');
    $sm = getsx('mode');
    $q = getsx('q');
    return pageLinkp($pg, $sb, $sm, $q);
}
示例#10
0
<?php

$r['ntable'] = getsx('lst');
$t = mysql_query("SELECT * FROM `" . $r['ntable'] . "cek`");
$i = 0;
$cn = mysql_num_rows($t);
$an = strval($cn);
if (strlen($an) < 10) {
    for ($i = strlen($an); $i < 5; $i++) {
        echo "0";
    }
}
echo $cn;
$k = 0;
while ($f = dbFA($t)) {
    $k++;
    ?>
	<div id="box<?php 
    echo $k;
    ?>
" class="box1"><?php 
    echo $f['barcode'];
    ?>
</div>
<?php 
}
$t = mysql_query("SELECT * FROM `" . $r['ntable'] . "` WHERE cek='N'");
$i = 0;
while ($f = dbFA($t)) {
    ?>
	<div class="box0"><?php