</tr>
<?php
$n = 0;
$rc = 1;
$k = 1;
while ($h = mysql_fetch_array($t)) {
if ($rc == 0) {
$rc = 1;
} else {
$rc = 0;
}
$r = mysql_fetch_array(mysql_query("SELECT * FROM book WHERE dcid='" . $h['book'] . "' LIMIT 0,1"));
$m = mysql_fetch_array(mysql_query("SELECT name FROM " . DB_HRD . " WHERE nip='" . $h['member'] . "' LIMIT 0,1"));
$y = mysql_query("SELECT * FROM catalog WHERE dcid='" . $r['catalog'] . "' LIMIT 0,1");
$f = mysql_fetch_array($y);
$day = diffDay($h['date2']);
if ($day < 0) {
$cl = 'style="color:#ff0000"';
} else {
if ($day < 2) {
$cl = 'style="color:#0000ff"';
} else {
$cl = "";
}
}
$cl = '';
$dtt = fftgl($h['date2']);
if ($day == 0) {
$dd = "Today";
} else {
if ($day == -1) {
$s='<span style="color:red">'.$s.'</span>';
}
} else {
$telat=diffDay($r['tanggal3'],$r['tanggal2']);
//if($telat>0)$telat='<br/><span style="color:#ff9000">Terlambat: '.$telat.' hari</span>';
//else $telat="";
}
//Status
$xtable->td($s,110);
$xtable->td($r['status']==1?'Dipinjam':'Dikembalikan',80);
//Tgl Dikembalikan
$xtable->td(fftgl($r['tanggal3']),110);
if($r['status']==0){
$telat=diffDay($r['tanggal3'],$r['tanggal2']);
if($telat<=0)
$telat='-';
//$s=$telat;
}
$xtable->td(($r['telat']==0?'-':$r['telat'].' hari'),60);
//$xtable->td($r['telat1'],60);
$xtable->td($r['keterangan']==''?' ':nl2br($r['keterangan']));
if($r['status']==1){
$s='<button class="btn" onclick="sirkulasi_pengembalian_item_form(\'uf\','.$r['replid'].')" title="Kembaliakan item ini."><div class="bi_inb"> </div></button>~30';
} else {
$s=' ';
}
$xtable->opt($r['replid'],$s);
$anggota = $res['pegawai'].'<br>No ID :'.$res['idmember'];
}
$tgl2 = isset($res['pengembalian'])?tgl_indo6($res['pengembalian']):'';
$tgl3 = isset($res['dikembalikan'])?tgl_indo6($res['dikembalikan']):' ';
// var_dump($res);exit();
//tgl pengembalian
$tgl_pengembalian=fftgl($tgl2);
if($res['status']!=0){
$lewat=diffDay($res['pengembalian']);
if($lewat<0 && $res['status']!=0){
$tgl_pengembalian='<span style="color:red">'.$tgl_pengembalian.'</span>';
}
} else {
$telat=diffDay($tgl3,$tgl2);
// if($telat>0)$telat='<br/><span style="color:#ff9000">Terlambat: '.$telat.' hari</span>';
// else $telat="";
}
// //tgl dikembalikan
if(isset($res['telat'])>0){
$tgl_dikembalikan='<span style="color:red">'.fftgl($tgl3).'</span>';
} else {
$tgl_dikembalikan=fftgl($tgl3);
}
// if ($res['status']==1) {
$btn = '<td>
<button data-hint="ubah" class="button" onclick="kembalikan('.isset($res['replid']).');">
<i class="icon-enter on-left"></i>
</button>
$dbtable='pus_peminjaman';
$fform=new fform($fmod,$opt,$cid,'Data pengembalian');
$fform->globalkey='0';
$inp=app_form_gpost('tanggal1','tanggal2','keterangan');
$inp['member']=gpost('member_id');
$inp['mtipe']=gpost('member_tipe');
if($opt=='a'||$opt=='u'||$opt=='d'){ $q=false; $ec=0;
if($opt=='a'){ // add
$tanggal3=date("Y-m-d");
$t=mysql_query("SELECT * FROM pus_tpjm WHERE ssid='$ssid'");
while($r=mysql_fetch_array($t)){
$t1=mysql_query("SELECT buku,tanggal2 FROM pus_peminjaman WHERE replid='".$r['peminjaman']."' LIMIT 0,1");
$r1=mysql_fetch_array($t1);
$telat=diffDay($r1['tanggal2']);
$telat=$telat<0?-$telat:0;
$q=dbUpdate($dbtable,array('status'=>0,'tanggal3'=>$tanggal3,'telat'=>$telat),"replid='".$r['peminjaman']."'");
if($q){
dbUpdate("pus_buku",array('status'=>1),"replid='".$r1['buku']."'");
dbDel("pus_tpjm","replid='".$r['replid']."'");
}
}
}
else if($opt=='u') { // edit
$q=dbUpdate($dbtable,$inp,"replid='$cid'");
}
else if($opt=='d'){ // delete
$q=dbDel($dbtable,"replid='$cid'");
$q=dbDel("sar_pengembalian_barang","pengembalian='$cid'");
}
$date2 = ftgl($r['date2']);
// 1. Status reminder get employee status
$t1 = mysql_query("SELECT * FROM emp_status WHERE empid='" . $r['dcid'] . "' AND active='Y' LIMIT 0,1");
if (mysql_num_rows($t1) > 0) {
$status = mysql_fetch_array($t1);
$tglmulai = $status['date1'];
$tglhabis = $status['date2'];
$idstatus = $status['status'];
// 2. Get status reminder setup
$t2 = mysql_query("SELECT * FROM mstr_status WHERE dcid='{$idstatus}'");
$rem = mysql_fetch_array($t2);
$reminder = $rem['reminder'];
// $tglreminder=date("Y-m-d",strtotime("-".$reminder." day"));
// 3. Hitung selisih hari
// $diff=diffDay($tglhabis,$tglreminder);
$sisa = diffDay($tglhabis);
// 4. Cek apakah mau habis?
if ($sisa <= $reminder) {
?>
<tr id="p_employee<?php
echo $r['dcid'];
?>
" class="xr<?php
echo $rc;
?>
">
<td width="30px" align="center"><?php
echo $n + 1;
?>
</td>
<td <?php
<?php
$tpf = mysql_query("SELECT * FROM emp_status WHERE empid='" . $r['dcid'] . "' ORDER BY dcid DESC");
if (mysql_num_rows($tpf) > 0) {
$rpf = mysql_fetch_array($t);
if (intval($r['status']) < 2) {
$dc = "";
} else {
$cs = EmpGetCStatus($r['dcid']);
$dd = diffDay($cs['date2']);
$dt = abs($dd) > 1 ? "s" : "";
$dt = abs($dd) . " Day" . $dt;
$dt .= $dd < 0 ? " over" : " remaining";
$dr = MstrGetReminder("status", $cs['status']);
$dc = $dd <= $dr ? " <span class=\"sfont\" style=\"color:#ff0000\"><b>(" . $dt . ")</b></span>" : "";
}
?>
<div class="sfont" style="padding:5px 0 5px 0;background:#ededff;">
<b><?php
echo $r['fname'];
?>
's current status: <?php
echo "<span style=\"color:#" . ($r['status'] != 0 ? "008000\">" . $mstr_status[$r['status']] : "ff0000\">No Status") . "</span>" . $dc;
?>
</b>
</div><br/>
<div class="sfont" style="height:24px">Employee status history:</div>
<table class="tablex" border="0" cellspacing="1px" width="600px">
<tr class="tablexhead">
<th style="text-align:left">Status</th>
<th>Period</th>
<th style="text-align:left">Position</th>
</td>
<td width="70px" align="center"><?php
echo $rpf['jenis'];
?>
</td>
<td width="100px"><?php
echo $rpf['penyelenggara'];
?>
</td>
<td width="120px"><?php
echo $rpf['tempat'];
?>
</td>
<td width="160px" align="center"><?php
echo ftgl($rpf['tanggal1']);
if (diffDay($rpf['tanggal1'], $rpf['tanggal2']) > 1) {
echo " s/d " . ftgl($rpf['tanggal2']);
}
?>
</td>
<td width="120px"><?php
echo $rpf['peserta'];
?>
</td>
<td width="60px" align="center">
<button class="btnedit" title="Edit data training" onclick="editTrain(<?php
echo $rpf['dcid'];
?>
)"></button>
<button class="btndel" title="Hapus data training" onclick="delTrain(<?php
echo $rpf['dcid'];
's Document<?php
echo $npf > 1 ? "s" : "";
?>
:</b>
</div><br/>
<table class="tablex" border="0" cellspacing="1px">
<tr class="tablexhead">
<th>Document</th>
<th>Validity</th>
<th>Document Status</th>
<th style="text-align:center">Option</th>
</tr>
<?php
$is = 0;
while ($rpf = mysql_fetch_array($tpf)) {
$dd = diffDay($rpf['date2']);
$active = $dd < 0 ? "Expired" : "Valid";
?>
<tr>
<td width="160px"><?php
echo $mstr_document[$rpf['docid']];
?>
</td>
<td width="220px"><?php
echo ftgl($rpf['date1']);
?>
to <?php
echo ftgl($rpf['date2']);
?>
</td>
<td width="120px"><?php
<tr>
<td><div style="<?php
echo SFONT12;
?>
color:<?php
echo CDARK;
?>
;margin-top:4px">Due date</div></td>
<td><div style="<?php
echo SFONT12;
?>
color:<?php
echo CDARK;
?>
;margin-top:4px">: <?php
$dd = diffDay($r['date2']);
if ($dd < 0) {
echo '<span style="color:#ff0000">' . fftgl($r['date2']) . ' ( ' . abs($dd) . ' day' . ($dd < -1 ? 's' : '') . ' over )</span>';
} else {
if ($dd == 0) {
echo '<span style="color:#0000ff">' . fftgl($r['date2']) . ' ( Today )</span>';
} else {
echo '<span style="color:#008000">' . fftgl($r['date2']) . '</span>';
}
}
?>
</div></td>
</tr>
<?php
$fine = 0;
$status = 0;
$fform->reg['btnlabel_u_n']='Tidak';
$fform->reg['btnlabel_d_y']=' Ya ';
$fform->title_style='background:#00c804;color:#fff;height:18px !important;padding:5px 10px 10px 10px !important;margin-bottom:5px';
$fform->head();
$db=new xdb("pus_peminjaman");
$db->field('pus_peminjaman:*','pus_buku:barkode','pus_katalog:judul');
$db->join('buku','pus_buku');
$db->joinother('pus_buku','katalog','pus_katalog','replid');
$db->where("pus_peminjaman.replid='$cid'");
$t=$db->query();
$r=mysql_fetch_array($t);
//$tglsekarang = date("Y-m-d");
$denda = diffDay(date("Y-m-d"),$r['tanggal2']);
//$denda1 = diffDay($r['tanggal2'],$r['tanggal1']);
if ($denda == 0){
$tdenda = 0;
}else {
$tdenda = $denda * 200;
}
$fform->fc('Kembalikan item berikut ini?');
$fform->fr('Judul','<b>'.buku_judul($r['judul']).'</b>');
$fform->fr('Barkode','<b>'.$r['barkode'].'</b>');
$fform->fr('Denda','<b>'.$tdenda.'</b>');
hiddenval('buku_id',$r['buku']);
hiddenval('status',0);
hiddenval('tanggal3',date("Y-m-d"));
