<?
;
     include("../inc/config.inc.php"); 
	 head();
	 $_REQPERM="weboption-showcaseall";
	 mn_lib();
pagesection(getlang("เลือกวัสดุเข้า Showcase::l::Add record. to showcase"));

?>
<TABLE class=table_border width=780 align=center>
<FORM METHOD=POST ACTION="h_showcase.selectmedia.php">
<TR>
	<TD class=table_head colspan=2><? echo getlang("กรุณากรอกข้อมูลของไอเทมวัสดุเพื่อสืบค้น::l::Please enter some information to search");?></TD></TR>
<TR>
<TR>
	<TD class=table_head><? echo getlang("Keyword");?> </TD>
	<TD class=table_td><INPUT TYPE="text" NAME="kw" ID="kw" value="<? echo $kw?>"> <? echo getlang("Field");?> 
	<?
	frm_genlist("kwtype","select * from index_ctrl order by name","fid","name",$dbname,"no",$kwtype);
	?></TD>
</TR>
<TR>
	<TD class=table_td colspan=2> 
	<INPUT TYPE="checkbox" NAME="onlyonshowcase" value="yes" style="border-width: 0" 
	<? if ($onlyonshowcase=="yes") { echo "checked";}?>> <? echo getlang("แสดงเฉพาะรายการที่อยู่ใน Showcase ของหน่วยงาน ::l::Only on campuses' showcase");?> <BR>
	<? echo getlang("แสดงเฉพาะหน่วยงาน ::l::Only on campuses");?> 
	<?
	frm_libsite("onlylibsite",$onlylibsite);
	?></TD>
</TR>
<TR>
	<TD class=table_td colspan=2 align=center>
	<INPUT TYPE="submit" value=" OK "> <A HREF="h_showcase.selectmedia.php"><?echo getlang("แสดงทั้งหมด::l::Show all")?></A></TD>
</TR>
</FORM><SCRIPT LANGUAGE="JavaScript">
<!--
	getobj('kw').select();
//-->
</SCRIPT>
</TABLE>
<?
 //dsp


$dsp[1][text]="วัสดุ::l::Material Info";
$dsp[1][field]="mid";
$dsp[1][filter]="module:localmedia";
$dsp[1][width]="80%";


function localmedia($wh) {

	$s="";
	$s.="<TABLE width=100%>
	<TR>
		<TD class=table_head><nobr>".getlang("ชื่อเรื่อง::l::Title")."</nobr></TD>
		<TD class=table_head>".marc_gettitle($wh[mid])."</TD>
	</TR>
	<TR>
		<TD class=table_head width=100><nobr>".getlang("โดย::l::By")."</nobr></TD>
		<TD class=table_td>".get_library_name($wh[useradminid])." , ".get_libsite_name($wh[LIBSITE])."</TD>
	</TR>
	<TR>
		<TD class=table_td colspan=2 align=right>
		 <b><a href='../dublin.php?ID=$wh[mid]' target=_blank>".getlang("ดูรายละเอียด::l::View in detail")."</a> ::
		  <a href='index.php?addthis=$wh[mid]' style='color:darkred;'>".getlang("เลือกรายการนี้::l::Select this media")."</a></b></TD>
	</TR>
	";
	$s.="
	</TABLE>";
	
	return $s;
}

$tbname="index_db";

$limit=" 1 ";
if ($kw!="" && $kwtype!="") {
	$limit.=" and $kwtype like '%$kw%' ";
}

if ($onlyonshowcase=="yes") {
	$limit.=" and webpageshowcase = 'yes' ";
}

if ($onlylibsite!="") {
	$limit.=" and LIBSITE = '$onlylibsite' ";
}

//echo "[$limit]";

		$limit.=" and webpageshowcaseall  <> 'yes' ";

$o[addlink][] = "index.php::".getlang("กลับไป Showcase::l::Back to Showcase")."::_self";

fixform_tablelister($tbname," $limit ",$dsp,"no","no","no","onlylibsite=$onlylibsite&kw=$kw&kwtype=$kwtype&onlyonshowcase=$onlyonshowcase",$c,"",$o);
//*,REPLACE(bcode, ',', '') as bcode2 

foot();
?>