<?
function html_displayitem($ID,$item = "") {
	global $thaimonstr;
	global $dcrs;
	global $dcrURL;
		pagesection(getlang("รายการสื่อสารสนเทศ::l::Items"));
?>

<? 
  $sql2 ="SELECT *  FROM media_mid where pid=$ID order by inumber,id"; 
//echo $sql2; 
$r2 = tmq($sql2);

echo "<table border=1 bordercolor=666666 cellpadding=0 width=770 align=center bgcolor=666666 cellspacing=1  class=table_border>
<Tr >
	<td width=5% class=table_head><B><nobr>".getlang("ลำดับที่::l::No.")."</B></td>
	<td align=center width=10% class=table_head><B><nobr>".getlang("ประเภท::l::Type")."</B></td>
 	<td align=center width=40% class=table_head colspan=2><B><nobr>".getlang("เลขเรียก::l::CallNumber")."</B>/<B><nobr>".getlang("บาร์โค้ด::l::Barcode")."</B></td>
	<td align=center class=table_head><B><nobr>".getlang("สถานที่::l::Shelf")."</B></td>
  <td align=center class=table_head><B>".getlang("สถานะ::l::Status")."</B></td>
</tr>";

$i2=1;
  while ($r = tmq_fetch_array($r2)) {
	  $mMID=$r[bcode];
//  echo "/ /$row2/ /";
if ($r[bcode]==$item) {
	$bg=" style='background-color:#FFE6E7;' ";
	$star="**";
} else {
	$bg=" style='background-color:white;' ";
	$star="";
}
$rectype=tmq("select * from media_type where code='$r[RESOURCE_TYPE]'  ");
$rectype=tmq_fetch_array($rectype);
if ($rectype[ishide]=='yes') {
	continue;
}
//printr($r);
 echo "<tr >
  <td $bg class=table_td align=right><FONT class=smaller2>$i2.</FONT></td>
	<td $bg class=table_td align=center><img border=0 width=48 height=48 src='";
	if ($r[status]=="reservmat") {
		$usecode="reservmat";
	} else {
		$usecode=$r[RESOURCE_TYPE];
	}
	if (file_exists("$dcrs/_tmp/mediatype/$usecode.png")==true) {
		echo "$dcrURL/_tmp/mediatype/$usecode.png";
	} else {
		echo "$dcrURL/_tmp/mediatype.png";
	}
	echo "' alt='".getlang($rectype[name])."'><BR><FONT class=smaller2>".get_media_type($rectype[code])."</FONT>";
if ($r[status]!="") {
	echo " <BR> <FONT class=smaller2 COLOR='#002F5E'>".getlang("สถานะ::l::Status")."=".get_mid_status($r[status])."</FONT>";
}
  echo " </td>";

$t02=marc_getmidcalln($r[bcode]);
///$t02=marc_getcalln($ID);

$inumber=$r[inumber];
if (trim($inumber)=="ฉ.1") {
	$inumber="";
}
if (trim($inumber)=="ฉ.") {
	$inumber="";
}
if (trim($inumber)=="") {
	$inumber="";
}
echo "<td nowidth=1% nowidth=2 $bg  class=table_td  align=left colspan=2>$t02&nbsp;$inumber&nbsp;$star <BR>";
//echo "<!--	<td $bg class=table_td>$r[tabean] </td>-->";
echo "	<FONT class=smaller2>&nbsp;&nbsp;Barcode: $r[bcode]</FONT> </td>		";
echo "	<td $bg class=table_td  align=center><a href='$dcrURL"."itemplaces.php' >";
echo get_itemplace_name($r[place]);
echo "</a> </td>";

$ecstat=bitem_get_checkoutstr($mMID);
 echo "<TD $bg class=table_td  align=center>";
 echo $ecstat;

 	html_displayrqitem($mMID,$r[place]);

	$hrs=getval("config","timetocirputtoshelf");

  if (floor($r[lastcheckin]+(60*60*$hrs))>time()) {
  	 echo "<br /><font color='#cc3333'><i>*";
  	 echo getlang("เพิ่งรับคืน::l::At circulation desk");
  	 echo "</i></font>";
  }
 echo "</td>";
$i2 +=1;
///////////admin ที่จะลบ
//////////////////////////////////////////////ขอยืมรายการ
///////////////////////////////////////////////จบขอยืม
echo "</tr>";
if (trim($r[note])!="") {
	echo "<tr bgcolor=white  class=table_td><td></td><td colspan=6><B>Note:</B>$r[note]";
	echo "</td></tr>";
}
}
//echo "$i2";

if ($i2==1) {
  echo "<tr	bgcolor=white><td colspan=7 align=center  class=table_td>- ".getlang("ไม่พบข้อมูล::l::No item found")."  - </td></tr>";
}
echo "</table>";
           ?>
</blockqoute><br>

 <?
}
?>