<?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>
<?php
echo iThxp("Name", 'name', $page, $sortby, $smode, $keyw);
?>
<?php
if (!$stocktaking) {
?>
<td class="xtdh" style="text-align:left">Options</td><?php
}
?>
</tr>
<?php
$n = $nps;
$rc = 1;
$k = 1;
$rh = $cover ? 'height="100px"' : '';
while ($r = dbFAx($t)) {
if ($n >= $nps && $n < $npl) {
if ($rc == 0) {
$rc = 1;
} else {
$rc = 0;
}
?>
<tr id="xrow<?php
echo $r['dcid'];
?>
" class="xxr<?php
echo $rc;
?>
" <?php
echo $rh;
<?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];
?>
<tr id="reb_reference<?php
echo $b;
?>
" style="display:none"></tr>
<?php
}
}
?>
</table><input type="hidden" id="ceb_reference" value="0"/>
<div id="aeb_reference" style="margin:9px 0 15px 0"><a class="linkl11" href="javascript:addEntry('reference',0)">Add reference...</a></div>
</td></tr>
</table>
<?php
$tia = dbSel("*", "emp_ainfo", "W/empid='{$dcid}'");
$empai = dbFAx($tia);
?>
<table class="stable" cellspacing="0" cellpadding="2px" width="875px">
<tr><td> </td><td colspan="2"></td></tr> <!-- Separator -->
<tr height="30px" valign="top"><td width="20px"><b>I.</b></td><td colspan="2"><strong>Additional Information</strong></td></tr><?php
$rwidth = "width:838px";
$ailbl = array('', 'Are you born again Christian? (If yes mention the approximate date):', 'Please give us the details of your rebirth and its effects upon your life:', 'Write your statement of faith:', 'Write your concepts and opinions regarding the Holy Trinity:', 'What is your philosophy regarding Christian Education:');
for ($i = 1; $i < count($ailbl); $i++) {
?>
<tr><td> </td><td colspan="2"><?php
echo $ailbl[$i];
?>
</td></tr>
<tr><td> </td><td colspan="2"><?php
echo iText('ainfo' . $i, $empai['info' . $i], $rwidth);
?>
<?php
$mid = gets('mid');
$sql = "SELECT * FROM joshr.employee WHERE `nip`='{$mid}' LIMIT 0,1";
//echo $sql;
$t = dbQsql($sql);
$ndata = dbNRow($t);
$mtype = '';
if ($ndata > 0) {
$mtype = 's';
}
if ($mtype != '') {
$r = dbFAx($t);
if ($mtype == 's') {
?>
<style type="text/css">
#pf_photo {
border:4px solid #ffffff;
width:60px;
box-shadow: 0px 2px 5px rgba(0, 0, 0, .25);
}
.mem_info tr td{
font:12px 'Segoe UI',Verdana,Tahoma;
color:#444;
}
.mem_info tr{
height:20px;
}
</style>
<script type="text/javascript" language="javascript">
function getBookLookup(){
// current view
$ct_bg = "folderico.png";
$ct_title = "Edit Profile";
function tdLabel($a, $s = "", $w = "150px", $cs = 0)
{
$s = $s == "L" ? "text-align:left" : $s;
return "<td width=\"" . $w . "\"" . ($cs == 0 ? "" : " colspan=\"" . $cs . "\"") . " align=\"right\" style=\"padding-right:6px;" . $s . "\">{$a}:</td>";
}
// Global Variables
$mstr_marital = MstrGet("mstr_marital");
$mstr_religion = MstrGet("mstr_religion");
$mstr_family = MstrGet("mstr_family");
// Preprocessing Variables
$dcid = gets('nid');
$t = dbSel("*", "employee", "W/ dcid='{$dcid}'");
$empp = dbFAx($t);
?>
<html><head>
<?php
require_once VWDIR . 'style.php';
require_once SYDIR . 'preferences.php';
?>
<style type="text/css">.preftbl{border-radius:2px;padding:1px;border-collapse:collapse}.preftbl tr{border:1px solid #d0d0d0; height:16px;background:#ffffff}.preftbl td{font:11px 'Segoe UI', Tahoma, sans-serif;color:#303942}.preftbl tr:hover{background:#e4ecf7}.prefdel{border:none;width:15px;height:15px;background:url('<?php
echo IMGR;
?>
pfr_del0.png')center no-repeat;cursor:pointer}.prefdel:hover{background:url('<?php
echo IMGR;
?>
pfr_del1.png')center no-repeat}.prefopt{visibility:hidden;width:100px}.preftbl tr:hover .prefopt{visibility:visible}</style>
<script type="text/javascript" src="jsscript/jquery.js"></script>
<table class="xtable" border="0" cellspacing="0" width="<?php
echo $tablew;
?>
">
<tr>
<td class="xtdh" width="30px" style="text-align:left"></td>
<td class="xtdh" width="180px">Title</td>
<td class="xtdh" width="120px">Book number</td>
<td class="xtdh" width="120px">Call number</td>
</tr>
<?php
$n = $nps;
$rc = 1;
$m = 1;
$rh = $cover ? 'height="100px"' : '';
while ($k = dbFAx($t)) {
if ($rc == 0) {
$rc = 1;
} else {
$rc = 0;
}
$r = mysql_fetch_array(mysql_query("SELECT * FROM book WHERE dcid='" . $k['book'] . "' LIMIT 0,1"));
$y = mysql_query("SELECT * FROM catalog WHERE dcid='" . $r['catalog'] . "' LIMIT 0,1");
$f = mysql_fetch_array($y);
?>
<tr id="xrow<?php
echo $r['dcid'];
?>
" class="xxr<?php
echo $rc;
?>
function dbSFAx($sel, $tbl, $filter = "")
{
return dbFAx(dbSel($sel, $tbl, $filter));
}
