function dbFetch($s,$t,$f=""){ $t=dbSel($s,$t,$f." LIMIT 0,1"); if(dbNRow($t)==1){ $r=dbFA($t); return $r[$s]; }else{ return ''; } }
function MstrGetNextUrut($t, $a, $o = "") { $ts = dbSel("dcid,urut", $t, "O/ urut " . $o); $lid = array(-1, 0, 0); while ($rs = dbFA($ts)) { if ($rs['dcid'] == $a) { $lid[2] = $rs['urut']; return $lid; } $lid[0] = $rs['dcid']; $lid[1] = $rs['urut']; } return $lid; }
function rapor_pelajaran_nilai($pel,$kls,$siswa){ $nilai=0; $bobot=0; $t1=dbSel("*","aka_penilaian","W/pelajaran='$pel' AND kelas='$kls'"); while($r1=dbFA($t1)){ $t2=dbSel("nilai","aka_daftarnilai","W/siswa='$siswa' AND penilaian='".$r1['replid']."'"); //echo $_SESSION['libdb_dbQsql']; while($r2=dbFA($t2)){ $nilai+=$r2['nilai']*$r1['bobot']; } $bobot+=$r1['bobot']; } if($bobot>0){ $nilai=$nilai/$bobot; } else { $nilai=0; } return $nilai; }
$cview = "employee"; // 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>
to <?php echo ftgl($rpf['date2']); ?> </td> <td width="90px"><?php echo $rpf['speaker']; ?> </td> <td width="100px"><?php echo $rpf['participant']; ?> </td> <td width="60px" align="center"><table style="border:none;background:none" cellspacing="0" cellpadding="0"><tr> <?php if ($rpf['file'] != 0) { $tfile = dbSel("file", "emp_files", "W/dcid='" . $rpf['file'] . "'"); if (mysql_num_rows($tfile) > 0) { $rfile = mysql_fetch_array($tfile); ?> <td style="border:none;background:none"> <a class="filebtn" href="<?php echo FLNK . $rfile['file']; ?> " target="_blank" title="Open attachment file"> <div style="background:url('<?php echo IMGR; ?> bi_file.png') no-repeat;width:24px;height:24px"></div> </a></td> <?php } else {
<?php $mstr_author = array(); $t = dbSel("*", "mstr_author", "O/ prefix LIMIT 0,20"); while ($r = dbFA($t)) { $mstr_author[$r['dcid']] = $r['name'] . " (" . $r['prefix'] . ")"; } $mstr_publisher = array(); $t = dbSel("*", "mstr_publisher", "O/ name LIMIT 0,20"); while ($r = dbFA($t)) { $mstr_publisher[$r['dcid']] = $r['name']; } $mstr_class = MstrGetx("mstr_class", "code"); $mstr_language = MstrGet("mstr_language"); $txtWidth = "width:344px"; ?> <script type="text/javascript" language="javascript"> function getBarcode(a){ var b=a.split("/"); E('barcode').value=b[0]; } function getCallNumber(){ var classcode=E('class').value; var author=getSelectedText('author'); var sa=author.indexOf("(")+1; var sb=author.indexOf(")",sa); auth=author.substring(sa,sb); var title=E('title').value.substr(0,1); title=title.toUpperCase(); var callnum=classcode+" "+auth+" "+title; E('tcallnumber').value=callnum;
// Master Publisher $mstr_publisher = array(); $fm = gets('act') == 'edit' ? " WHERE dcid='" . $r['publisher'] . "'" : ""; $t = dbSel("*", "mstr_publisher", $fm . "O/ name LIMIT 0,1"); while ($f = dbFA($t)) { $mstr_publisher[$f['dcid']] = $f['name']; } // Master Class $mstr_class = array(); $t = dbSel("*", "mstr_class", "O/ code"); while ($f = dbFA($t)) { $mstr_class[$f['dcid']] = "(" . $f['code'] . ") " . $f['name']; } // Master Language $mstr_language = array(); $t = dbSel("*", "mstr_language", "O/ code"); while ($f = dbFA($t)) { $mstr_language[$f['dcid']] = $f['name']; } $txtWidth = "width:344px"; ?> <div class="hl1">New catalog:</div> <table cellspacing="0" cellpadding="0" border="0"><tr valign="top"><td> <div class="hl2" style="margin-top:10px;margin-bottom:10px">Bibliographic Informations</div> <table class="stable" cellspacing="0" cellpadding="4px" border="0"> <tr><td width="100px" align="left">Title:</td><td width="370px"><?php echo iText('title', $r['title'], $txtWidth, '', 'onkeyup="sendTitle();vTitle(1);checkBookTitle()"'); ?> </td></tr> <tr id="retitle" style="display:none"><td></td><td><div id="etitle" class="espan">You can't leave this empty.</div></td></tr> <tr><td align="left">Author:</td><td>
<?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!"; }
} else { ?> <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 require_once SYDIR . 'ptrack.php'; $txtWidth = "width:344px"; $t = dbSel("*", "so_history", "W/status='3' ORDER BY dcid DESC LIMIT 0,1"); if (mysql_num_rows($t) > 0) { $r = mysql_fetch_array($t); $btot = mysql_num_rows(mysql_query("SELECT * FROM `book`")); $bdue = mysql_num_rows(mysql_query("SELECT * FROM `" . $r['ntable'] . "`")); //$bcek=mysql_num_rows(mysql_query("SELECT * FROM `".$r['ntable']."cek`")); $bcekY = mysql_num_rows(mysql_query("SELECT * FROM `" . $r['ntable'] . "cek`")); $bcekN = mysql_num_rows(mysql_query("SELECT * FROM `" . $r['ntable'] . "` WHERE cek='N'")); $bcekNY = mysql_num_rows(mysql_query("SELECT * FROM `" . $r['ntable'] . "` WHERE cek='N' AND note!=''")); $bcekNN = mysql_num_rows(mysql_query("SELECT * FROM `" . $r['ntable'] . "` WHERE cek='N' AND note=''")); $bcek = $bcekY + $bcekN; $bcekYp = round($bcekY * 100 / $bcek, 2); $bcekNp = round($bcekN * 100 / $bcek, 2); $buli = mysql_num_rows(mysql_query("SELECT * FROM `" . $r['ntable'] . "new`")); ?> <script type="text/javascript" language="javascript"> function doneChecking(){ //if(confirm('Are you sure book cheking is done and proceed to next step?')){ E('donecekform').submit(); //} } </script> <div style="padding:10px 0 10px 0"> <table id="prog_track" cellspacing="5px" cellpadding="0"><tr> <td> <div class="ptrackbox"> <table cellspacing="0" cellpadding="0"><tr>
if ($y != -1) { $w[$y] = $x - $cw; } for ($i = 0; $i < count($h); $i++) { $pdf->MultiCell($w[$i], 0, $h[$i], 1, $al[$i], 1, 0, '', '', true); } $pdf->Ln(); $pdf->SetTextColor(0); } /* Pre Data Processing */ if (gets('ids') != ALL) { $ids = explode("-", gets('ids')); } else { $ids = array(); $ids[0] = 0; $t = dbSel("dcid", "catalog", "O/ title"); $i = 1; while ($r = dbFA($t)) { $ids[$i++] = $r['dcid']; } } define('dp_Title', 1); define('dp_Callnumber', 2); define('dp_Idnumber', 3); define('dp_Author', 4); define('dp_Publisher', 5); define('dp_Classification', 6); define('dp_Isbn', 7); define('dp_Releasedate', 8); define('dp_Available', 9); $dps = explode("-", gets('dps'));
<?php $t = dbSel("*", "mstr_document", "O/ urut"); $k = 1; $n = dbNRow($t); while ($r = dbFA($t)) { ?> <tr><td width="380px"><?php echo $r['name']; ?> </td><td align="right"> <div class="prefopt"> <?php if ($k != 1) { ?> <input type="button" title="Move up" class="prefup" onclick="m_document('up',<?php echo $r['dcid']; ?> )"/> <?php } ?> <?php if ($k != $n) { ?> <input type="button" title="Move down" class="prefdn" onclick="m_document('dn',<?php echo $r['dcid']; ?> )"/><?php } else { ?> <button style="width:15px;height:15px;border:none;background:none"></button><?php
$t = mysql_query("SELECT aka_siswa.replid,aka_siswa.nama,aka_siswa.nis FROM aka_siswa_kelas LEFT JOIN aka_siswa ON aka_siswa.replid=aka_siswa_kelas.siswa WHERE aka_siswa.nama LIKE '%{$keyw}%' GROUP BY aka_siswa_kelas.siswa"); //dbSel("replid,nama","aka_siswa","W/nama LIKE '%$keyw%'"); $n = mysql_num_rows($t); if ($n > 0) { //log_print('peminjaman_member_cari: get siswa by nama '.$n); if ($n == 1) { $r = mysql_fetch_array($t); //log_print('peminjaman_member_cari: get siswa by nama='.$r['replid']); $mid = $r['replid']; $mnama = $r['nama']; } $mtipe = 1; } //log_print('after siswa nama mid='.$mid); if ($mid == 0 && $mtipe == 0) { $t = dbSel("replid,nama", "hrd_pegawai", "W/nama LIKE '%{$keyw}%'"); $n = mysql_num_rows($t); if ($n > 0) { //log_print('peminjaman_member_cari: get pegawai by nama '.$n); if ($n == 1) { $r = mysql_fetch_array($t); //log_print('peminjaman_member_cari: get pegawai by nama='.$r['replid']); $mid = $r['replid']; $mnama = $r['nama']; } $mtipe = 2; } } //log_print('after pegawai nama mid='.$mid); } echo $mid == 0 ? $mtipe : $mid . "-" . $mtipe . "-" . $mnama;
<?php $t = dbSel("*", "mstr_language", "O/ urut"); $k = 1; $n = dbNRow($t); while ($r = dbFA($t)) { ?> <tr><td width="380px"><?php echo $r['name']; ?> (<?php echo $r['code']; ?> )</td><td align="right"> <div class="prefopt"> <?php if ($k != 1) { ?> <input type="button" title="Move up" class="prefup" onclick="b_language('up',<?php echo $r['dcid']; ?> )"/> <?php } ?> <?php if ($k != $n) { ?> <input type="button" title="Move down" class="prefdn" onclick="b_language('dn',<?php echo $r['dcid']; ?> )"/><?php
<?php $t = dbSel("*", "mstr_traintype", "O/ urut"); $k = 1; $n = dbNRow($t); while ($r = dbFA($t)) { ?> <tr><td width="380px"><?php echo $r['name']; ?> </td><td align="right"> <div class="prefopt"> <?php if ($k != 1) { ?> <input type="button" title="Move up" class="prefup" onclick="m_traintype('up',<?php echo $r['dcid']; ?> )"/> <?php } ?> <?php if ($k != $n) { ?> <input type="button" title="Move down" class="prefdn" onclick="m_traintype('dn',<?php echo $r['dcid']; ?> )"/><?php } else { ?> <button style="width:15px;height:15px;border:none;background:none"></button><?php
<?php require_once MODDIR . 'masterdb.php'; require_once MODDIR . 'control.php'; $lbc = dbFetch("barcode", "book", "O/barcode DESC"); if ($lbc == '') { $lbc = 1; } else { $lbc = intval($lbc) + 1; } $mstr_shelf = array(); $ts = dbSel("dcid,name", "mstr_shelf", "O/ dcid"); while ($l = dbFA($ts)) { $mstr_shelf[$l['dcid']] = $l['name']; } $cla = dbSFA("name,code", "mstr_class", "W/dcid='" . $r['class'] . "'"); $txtWidth = "width:200px"; if (!empty($f['callnumber'])) { $callnum = $f['callnumber']; } else { $callnum = $r['classcode'] . " " . dbFetch("prefix", "mstr_author", "W/dcid='" . $r['author'] . "'") . " " . strtolower(substr(preg_replace("/(\"|\\')/", "", $r['title']), 0, 1)); } $f['nid'] = "0/" . dbFetch("val", "mstr_setting", "W/dcid='4'"); ?> <div class="hl1" style="margin-top:20px">Add book to new catalog:</div> <input type="hidden" id="dcid" name="dcid" value="<?php echo $f['dcid']; ?> " /> <input type="hidden" id="catalog" name="catalog" value="<?php echo $r['dcid'];
<?php $t = dbSel("*", "mstr_position", "O/ urut"); $k = 1; $n = dbNRow($t); while ($r = dbFA($t)) { ?> <tr><td width="380px"><?php echo $r['name']; ?> </td><td align="right"> <div class="prefopt"> <?php if ($k != 1) { ?> <input type="button" title="Move up" class="prefup" onclick="m_position('up',<?php echo $r['dcid']; ?> )"/> <?php } ?> <?php if ($k != $n) { ?> <input type="button" title="Move down" class="prefdn" onclick="m_position('dn',<?php echo $r['dcid']; ?> )"/><?php } else { ?> <button style="width:15px;height:15px;border:none;background:none"></button><?php
<?php $t = dbSel("*", "mstr_marital", "O/ urut"); $k = 1; $n = dbNRow($t); while ($r = dbFA($t)) { ?> <tr><td width="380px"><?php echo $r['name']; ?> </td><td align="right"> <div class="prefopt"> <?php if ($k != 1) { ?> <input type="button" title="Move up" class="prefup" onclick="m_marital('up',<?php echo $r['dcid']; ?> )"/> <?php } ?> <?php if ($k != $n) { ?> <input type="button" title="Move down" class="prefdn" onclick="m_marital('dn',<?php echo $r['dcid']; ?> )"/><?php } else { ?> <button style="width:15px;height:15px;border:none;background:none"></button><?php
<?php $t = dbSel("*", "mstr_level", "O/ urut"); $k = 1; $n = dbNRow($t); while ($r = dbFA($t)) { ?> <tr><td width="380px"><?php echo $r['name']; ?> </td><td align="right"> <div class="prefopt"> <?php if ($k != 1) { ?> <input type="button" title="Move up" class="prefup" onclick="m_level('up',<?php echo $r['dcid']; ?> )"/> <?php } ?> <?php if ($k != $n) { ?> <input type="button" title="Move down" class="prefdn" onclick="m_level('dn',<?php echo $r['dcid']; ?> )"/><?php } else { ?> <button style="width:15px;height:15px;border:none;background:none"></button><?php
<?php $f = mysql_fetch_array($t); $lbc = $f['barcode']; $t = dbSel("*", "catalog", "W/dcid='" . $f['catalog'] . "' LIMIT 0,1"); $r = dbFA($t); $blink = "&act=view&nid=" . $f['catalog']; ?> <div class="hl1">Edit book:</div> <form id="bform" action="<?php echo RLNK; ?> request.php?q=revbook" method="post" enctype="multipart/form-data" style="padding:0;margin:0"> <?php require_once VWDIR . 'p_book_form2.php'; ?> </form>
<?php require_once SYDIR . 'ptrack.php'; $txtWidth = "width:344px"; $t = dbSel("*", "so_history", "W/status='4' LIMIT 0,1"); if (mysql_num_rows($t) > 0) { $r = mysql_fetch_array($t); $ntable = $r['ntable']; $tblid = $r['dcid']; $btot = mysql_num_rows(mysql_query("SELECT * FROM `book`")); $bdue = mysql_num_rows(mysql_query("SELECT * FROM `" . $r['ntable'] . "`")); //$bcek=mysql_num_rows(mysql_query("SELECT * FROM `".$r['ntable']."cek`")); $bcekY = mysql_num_rows(mysql_query("SELECT * FROM `" . $r['ntable'] . "cek`")); $bcekN = mysql_num_rows(mysql_query("SELECT * FROM `" . $r['ntable'] . "` WHERE cek='N'")); $bcek = $bcekY + $bcekN; $bcekYp = round($bcekY * 100 / $bcek, 2); $bcekNp = round($bcekN * 100 / $bcek, 2); $buli = mysql_num_rows(mysql_query("SELECT * FROM `" . $r['ntable'] . "new`")); ?> <div style="padding:10px 0 10px 0"> <table id="prog_track" cellspacing="5px" cellpadding="0"><tr> <td> <div class="ptrackbox"> <table cellspacing="0" cellpadding="0"><tr> <td id="ps1a" class="ptracknumber0" align="center">1</td> <td id="ps1b" class="ptracktext0">Initialize<br/>stock take</td> </tr></table> </div> </td> <td> <div class="ptrackbox">
<?php $t = dbSel("*", "mstr_religion", "O/ urut"); $k = 1; $n = dbNRow($t); while ($r = dbFA($t)) { ?> <tr><td width="380px"><?php echo $r['name']; ?> </td><td align="right"> <div class="prefopt"> <?php if ($k != 1) { ?> <input type="button" title="Move up" class="prefup" onclick="m_religion('up',<?php echo $r['dcid']; ?> )"/> <?php } ?> <?php if ($k != $n) { ?> <input type="button" title="Move down" class="prefdn" onclick="m_religion('dn',<?php echo $r['dcid']; ?> )"/><?php } else { ?> <button style="width:15px;height:15px;border:none;background:none"></button><?php
<?php $t = dbSel("*", "catalog", "O/ `title`"); ?> <table class="xtable" border="0" cellspacing="1px" width="850px"> <tr> <td class="xtdh" style="text-align:center">Cover</td> <?php echo iThxp("Title", 'title', $page, $sortby, $smode, $keyw); ?> <?php echo iThxp("Author", 'author', $page, $sortby, $smode, $keyw); ?> <?php echo iThxp("Publisher", 'publisher', $page, $sortby, $smode, $keyw); ?> <td class="xtdh" style="text-align:center">Availability</td> <td class="xtdh" style="text-align:center">Options</td> </tr> <?php $n = 0; $rc = 1; //$p=Array('title','type','host','place','date1','date2','speaker','participant'); while ($r = dbFAx($t)) { if ($n >= $nps && $n < $npl) { if ($rc == 0) { $rc = 1; } else { $rc = 0; } $date1 = ftgl($r['date1']);
$cid = 0; } appmod_use('aka/tahunajaran', 'aka/pelajaran', 'aka/kelas'); // form Module $fmod = 'sks'; $dbtable = 'aka_sks'; $fform = new fform($fmod, $opt, $cid, 'Kontrak Pelajaran'); $inp = app_form_gpost('tahunajaran', 'pelajaran', 'guru'); $inp['kelas'] = gpost('sks_kelas'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $njam = intval(gpost('njam', 1)); if (gpost('salin') == '1') { $t = dbSel("*", "aka_kelas", "W/tahunajaran='" . $inp['tahunajaran'] . "'"); while ($r = dbFA($t)) { $inp['kelas'] = $r['replid']; for ($i = 0; $i < $njam; $i++) { $q = dbInsert($dbtable, $inp); } } } else { for ($i = 0; $i < $njam; $i++) { $q = dbInsert($dbtable, $inp); } } } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'");
<?php $t = dbSel("*", "so_history", "W/status='1' OR status='2' LIMIT 0,1"); $nso = dbNRow($t); ?> <div class="hl2" style="font-size:16px;margin-bottom:10px;padding-top:20px;">Initialize stock take</div> <?php if ($nso == 0) { ?> <div class="sfont" style="line-height:200%;width:600px;margin-bottom:10px">This application wil guide you through stock take process. Once you initialize a stock take process you may not to initialize another process until current process are finished.</div> <input type="button" class="btnx" value="Start new stock take" onclick="jumpTo('<?php echo RLNK; ?> stockopname.php?tab=init')"/> <?php } else { $r = dbFA($t); $tt = array('1' => 'cek', '2' => 'note', '3' => 'finish'); ?> <div class="sfont" style="line-height:200%;width:600px;margin-bottom:10px">Current stock take process <b>"<?php echo $r['name']; ?> "</b> is not finish yet.</div> <input type="button" class="btnz" value="Continue current stock take" onclick="jumpTo('<?php echo RLNK; ?> stockopname.php?tab=<?php echo $tt[$r['status']]; ?> ')"/> <?php
<?php $opt = gpost('opt'); $val = gpost('v'); if ($opt == 'author') { $t = dbSel("*", "mstr_author", "O/ prefix"); echo '<option value="0" >any author</option>'; while ($r = dbFA($t)) { echo '<option value="' . $r['dcid'] . '" >' . $r['name'] . ' (' . $r['prefix'] . ')</option>'; } } else { if ($opt == 'publisher') { $t = dbSel("*", "mstr_publisher", "O/ name"); echo '<option value="0" >any publisher</option>'; while ($r = dbFA($t)) { echo '<option value="' . $r['dcid'] . '" >' . $r['name'] . '</option>'; } } }
<?php require_once SYDIR . 'ptrack.php'; $txtWidth = "width:344px"; $nid = getsx('nid'); $t = dbSel("*", "so_history", "W/dcid='{$nid}' LIMIT 0,1"); if (mysql_num_rows($t) > 0) { $r = mysql_fetch_array($t); $ntable = $r['ntable']; $tblid = $r['dcid']; $btot = mysql_num_rows(mysql_query("SELECT * FROM `book`")); $bdue = mysql_num_rows(mysql_query("SELECT * FROM `" . $r['ntable'] . "`")); //$bcek=mysql_num_rows(mysql_query("SELECT * FROM `".$r['ntable']."cek`")); $bcekY = mysql_num_rows(mysql_query("SELECT * FROM `" . $r['ntable'] . "cek`")); $bcekN = mysql_num_rows(mysql_query("SELECT * FROM `" . $r['ntable'] . "` WHERE cek='N'")); $bcek = $bcekY + $bcekN; $bcekYp = round($bcekY * 100 / $bcek, 2); $bcekNp = round($bcekN * 100 / $bcek, 2); $buli = mysql_num_rows(mysql_query("SELECT * FROM `" . $r['ntable'] . "new`")); ?> <div style="padding:10px 0 10px 0"> <table id="prog_track" cellspacing="5px" cellpadding="0"><tr> <td> <div class="ptrackbox"> <table cellspacing="0" cellpadding="0"><tr> <td id="ps1a" class="ptracknumber0" align="center">1</td> <td id="ps1b" class="ptracktext0">Initialize<br/>stock take</td> </tr></table> </div> </td> <td>
<?php } } if ($nn == 0) { ?> <div class="sfont" style="color:#008ee8;padding-top:20px;width:430px">There is no book which barcode within range <b><?php echo $keyw; ?> </b>.</div> <?php } } else { // find by title if ($keyw != '') { $bcl = array(); $t = dbSel("barcode", "p_label"); while ($r = dbFA($t)) { $bcl[$r['barcode']] = '1'; } $sql = "SELECT dcid,title FROM catalog WHERE title LIKE '{$keyw} %' OR title LIKE '% {$keyw}' OR title LIKE '% {$keyw} %' OR title='{$keyw}' ORDER BY title"; $q = mysql_query($sql); $n = mysql_num_rows($q); if ($n > 0) { $l = 1; ?> <div class="pfsub">Select book to add to print queue:</div> <div style="width:430px;height:240px;overflow:auto;margin-top:10px"> <table class="stable" border="0" cellspacing="0" width="410px"> <?php $i = 0; while ($f = mysql_fetch_array($q)) {
$t = dbUpdate($dbtable, array('active' => 'N'), "empid='{$dcid}'"); dbInsert($dbtable, array('empid' => $dcid, 'status' => $status, 'date1' => $date1, 'date2' => $date2, 'position' => $position)); dbUpdate("employee", array('status' => $status), "dcid='{$dcid}'"); } else { if ($opt == 'u') { dbUpdate($dbtable, $inp, "dcid='{$cid}'"); } else { if ($opt == 'd') { if ($active == 'Y') { dbUpdate("employee", array('status' => 0), "dcid='{$dcid}'"); } dbDel($dbtable, "dcid='{$cid}'"); } } } $t = dbSel("*", "employee", "W/dcid='{$dcid}' LIMIT 0,1"); $r = dbFA($t); require_once VWDIR . $fmod . '.php'; } else { $sx = str_replace('f', '', $opt); $nobtn = "Cancel"; // Form dimension $fwidth = 330; $lwidth = 100; $iTextFw = "width:" . ($fwidth - $lwidth - 30) . "px"; // Preprocessing form if ($opt == 'uf' || $opt == 'df') { $r = dbSFA("*", $dbtable, "W/dcid='{$cid}'"); $date1 = $r['date1']; $date2 = $r['date2']; } else {
<?php $t = dbSel("*", "mstr_user", "O/ dcid"); $k = 1; $n = dbNRow($t); while ($r = dbFA($t)) { ?> <tr><td width="26px"> <?php if ($r['level'] != 'admin') { ?> <img src="<?php echo IMGR; ?> staff.png" title="Staff"/><?php } else { ?> <img src="<?php echo IMGR; ?> admin.png" title="Admin"/><?php } ?> </td><td width="400px"><b><?php echo $r['alias']; echo $r['level'] == 'admin' ? " (Admin)" : ""; ?> </b> <?php if ($_SESSION['joshr'] == $r['name']) { echo " (current user)";