<?
include("../inc/config.inc.php");


head();
$_REQPERM="ticket-ticketlist";
mn_lib();
$tbname=" ticket";
//printr($selectlist);
$now=time();


$c[2][text]="กำหนดรหัสผ่าน";
$c[2][field]="ticketid";
$c[2][fieldtype]="text";
$c[2][descr]="";
$c[2][defval]=substr(randid(),-3);

$c[9][text]="for_mid";
$c[9][field]="for_mid";
$c[9][fieldtype]="addcontrol";
$c[9][descr]="";
$c[9][defval]=$mid;

$c[10][text]="for_ftid";
$c[10][field]="for_ftid";
$c[10][fieldtype]="addcontrol";
$c[10][descr]="";
$c[10][defval]=$ftid;

$c[14][text]="dt_create";
$c[14][field]="dt_create";
$c[14][fieldtype]="addcontrol";
$c[14][descr]="";
$c[14][defval]=time();

$c[15][text]="วันหมดอายุ";
$c[15][field]="dt_expire";
$c[15][fieldtype]="date";
$c[15][descr]="";
$c[15][defval]=time()+(60*60*24*4);

$c[16][text]="ถูกใช้ไปแล้ว";
$c[16][field]="usecount";
$c[16][fieldtype]="readonlytext";
$c[16][descr]="";
$c[16][defval]=0;

$c[17][text]="dt_create";
$c[17][field]="dt_create";
$c[17][fieldtype]="addcontrol";
$c[17][descr]="";
$c[17][defval]=time();

$c[18][text]="บันทึก";
$c[18][field]="note";
$c[18][fieldtype]="longtext";
$c[18][descr]="";
$c[18][defval]="";

$c[19][text]="เพิ่มข้อมูลโดย";
$c[19][field]="dt_create";
$c[19][fieldtype]="autoofficer";
$c[19][descr]="";
$c[19][defval]=$useradminid;

$c[22][text]="ประวัติการใช้";
$c[22][field]="log";
$c[22][fieldtype]="readonlytext";
$c[22][descr]="";
$c[22][defval]="";



//dsp

$dsp[2][text]="รายละเอียดไฟล์";
$dsp[2][field]="memid";
$dsp[2][width]="30%";
$dsp[2][filter]="module:local_detail";

$dsp[3][text]="อยู่ในรายการ";
$dsp[3][field]="id";
$dsp[3][width]="70%";
$dsp[3][filter]="module:local_mdname";

function local_mdname($wh) {
	$add="";
	$now=time();
	if ($wh[dt_expire]<$now) {
		$add="<B style='color:red'>หมดอายุแล้ว</B>";
	}
	return "<B>รหัส $wh[ticketid]</B><BR> ".marc_gettitle($wh[for_mid])." $add <BR><A HREF='../index.php?mode=viewrecord&mid=$wh[for_mid]' class=a_btn target=_blank>ดูรายละเอียด</A> : <A HREF='../login.upload/index.php?mid=$wh[for_mid]' class=a_btn target=_blank>รายละเอียดไฟล์แนบ</A><BR>$wh[note]";
}

function local_detail($wh) {
	$wh=tmq("select * from media_ftitems where id ='$wh[for_ftid]' ");
	$wh=tmq_fetch_array($wh);
	if (strlen($wh[filename])>20) {
		$add='..';
	}
	//printr($wh);
	$ico=index_fticon($wh,40,40,"return");
	if ($wh[uploadtype]=="url") {
		 $link= "<a href=\"$wh[filename]\" target=_blank class=smaller2>".substr($wh[filename],0,20)."$add</a>";
	} else {
		 $link= "<a href=\"$dcrURL/_fulltext/$wh[mid]/$wh[filename]\" target=_blank class=smaller2>".substr($wh[filename],0,20)."$add</a>";
	}
	return "<TABLE width=100%>
	<TR valign=top>
		<TD width=50>$ico</TD>
		<TD>$link</TD>
	</TR>
	</TABLE>";

}

?><TABLE width=900 align=center>
<FORM METHOD=POST ACTION="index.php">
	<TR>
	<TD align=center>ค้นหา <INPUT TYPE="text" NAME="kw" value="<? echo $kw?>"> <INPUT TYPE="submit" value="ค้นหา"> 
	<?
	if ($kw!="") {
		echo " <A HREF='index.php'>แสดงทั้งหมด</A>";
	}
	?></TD>
</TR>
</FORM>
</TABLE><?
if ($mid!="") {
	 		$limit=" for_mid='$mid'  ";
} else {
   $limit=" 1 "                     ;
 }

if ($kw!="") {
	$limit=" 1 and note like '%$kw%' or ticketid='$kw' ";
}
fixform_tablelister($tbname," $limit ",$dsp,"no","yes","yes","mid=$mid",$c,"id desc");


foot();
?>