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

if ($mode=="") {
	$mode="table";
}

		$sdbs=tmq("select * from library_modules where code='stat-view-stat_$db' ");
		if (tmq_num_rows($sdbs)==0) {
			die("library_modules where code='stat-view-stat_$db'");
		}
		$sdbs=tmq_fetch_array($sdbs);
		$sdb["view_cate"][name]=getlang($sdbs[name]);
		$sdb["view_cate"][headmode]="mediacate";
		$sdb["view_libsite"][name]=getlang($sdbs[name]);
		$sdb["view_libsite"][headmode]="libsite";
		$sdb["upupdate_libsite"][name]=getlang($sdbs[name]);
		$sdb["upupdate_libsite"][headmode]="libsite";
		$sdb["view_day"][name]=getlang($sdbs[name]);
		$sdb["view_day"][headmode]="day";
		$sdb["lib_login"][name]=getlang($sdbs[name]);
		$sdb["lib_login"][headmode]="librarian";
		$sdb["up_update"][name]=getlang($sdbs[name]);
		$sdb["up_update"][headmode]="librarianlibsite";


				
		$_REQPERM=$sdbs[code];
		$tbl="stat_$db";
        mn_lib();
		pagesection($sdb["checkout_member_libsite"][name],"stats");
		
		//autoclear
			 $autoclear=tmq("select id FROM `$tbl` order by id desc limit $_STATCENTER_MAXRECORD,1 ",false);
			 $autoclear=tmq_fetch_array($autoclear);
			 $autoclear=floor($autoclear[id]);
			 if ($autoclear!=0) {
			 		tmq("delete from $tbl where id<$autoclear ",false);
			 }		
			 
		if ($yrtoclearstat!="" && library_gotpermission("stat-candelete")) {
			 tmq("delete from $tbl where yea='$yrtoclearstat' ");
		}
?>
<TABLE width=620 align=center cellspacing=0 class=table_border>

<TR valign=top>
<TD width=50% class=table_head><?
echo getlang("กำลังดูข้อมูล::l::Displaying stat.");
?></TD>
<TD class=table_td><?
$dspname=getlang($sdb[$db][name]);
			$dspname=str_replace('[ROOMWORD]',$_ROOMWORD,$dspname);
			$dspname=str_replace('[FACULTYWORD]',$_FACULTYWORD,$dspname);
echo $dspname;
?></TD>
</TR>
</TABLE><BR>
<?
$tmp[detail]="1";
$tmp[table]="2";
$addquery="";

$tabstr=$tmp[$mode]."::b::".getlang("สถิติละเอียด::l::Detailed style").",thestat.php?db=$db&mode=detail&$addquery";
$tabstr.="::".getlang("ตารางความถี่::l::Frequency Table").",thestat.php?db=$db&mode=table&$addquery";
html_xptab($tabstr);


if ($mode=="detail") {
	include("thestat.detail.php");
}

if ($mode=="table") {
	//USEYEA
	$start=time()-(60*60*24*30*10);
	$end=time();
	$alllen=Array();
	for ($dtrun=$start;$dtrun<=$end;$dtrun+=(60*60*24)) {
			$thisy=date("Y",$dtrun);
			$thism=date("n",$dtrun);
			$alllen[]="$thisy-$thism";
	}
	$alllen=array_unique($alllen);
	$alllen=array_slice($alllen,-6) ;
	$alllen=array_reverse($alllen);
	while (list($dtrunk,$dtrunv)=each($alllen)) {
	  $data=split('-',$dtrunv);
		$USEYEA=$data[0];
		$USEMON=$data[1];
		include("thestat.table.php");	
		echo "<br />
";		
	}
	html_dialog("Warning",getlang("ระบบสถิติจะแสดงรายละเอียดแบบตารางย้อนหลังเพียง 6 เดือนเท่านั้น::l::Only last 6 month will display on table style"));
}

if (library_gotpermission("stat-candelete")) {
	 ?><br />
<br />

	 <table border="0" cellpadding="0" cellspacing="0" width=780 align=center class=table_border>
<form action="<? echo $PHP_SELF?>" method="post" onsubmit="return confirm('Please Confirm');">
<input type="hidden" name="db" value="<? echo $db;?>" />
<tr><td class=table_head><? echo getlang("เคลียร์สถิติ::l::Clear Stat.");?></td>
<td class=table_td>
<select name="yrtoclearstat"><?
for($y=$_MSTARTY;$y<=$_MENDY;$y++) {
	echo "<option value='".($y-543)."'>$y";
}
?></select> <input type="submit" value="Clear"><?

?></td>
</tr>
</form>
</table>
	 <?
}
                foot();
?>