<?php
	if ($searchindex=="") {
		 $searchindex="kw";
	}
	$kw=stripslashes($kw);	$kw=addslashes($kw);
	if ($kw=="") {
		html_dialog("","กรุณาใส่ข้อความสำหรับสืบค้น");
		die;
	}
	//$s="select * from index_db where 1 and $searchindex like '$kw%' or $searchindex like '%$kw%' ";
	$tmps= ssql($kw,"$searchindex");
	$s="select * from index_db where 1 $tmps ";
	if ($acadtoviewLIMIT!="") {
		$s.=$acadtoviewLIMIT;
	}
	
	$s_foryengine=$s;
	$centclicked=floor($centclicked);
	if ($centclicked!=0) {
		$temp_yeardiff=floor(($centclicked)-54);
		$s.=" and ( idxyea like '%Created|$centclicked%' or  idxyea like '%Created|".floor($temp_yeardiff-3)."%' ) ";
	}
	$yiclicked=floor($yiclicked);
	if ($yiclicked!=0) {
		$s.=" and ( idxyea like '%Created|$yiclicked%' or  idxyea like '%Created|".floor(($yiclicked)-543)."%' ) ";
	}
	//echo $s;
	$showcase=tmqp($s,"index.php?mode=searching&kw=$kw");
	index_sepper(getlang("ผลการค้นหา::l::Search results"));
			
	if (tmq_num_rows($showcase)!=0) {
if (barcodeval_get("webpage-o-showsearchyearfilter")=="yes") {
///////////////////////start y engine
$ye=tmq($s_foryengine);
$ydb=Array();
$ydbcent=Array();
while ($yer=tmq_fetch_array($ye)) {
	//printr($yer);
	$ykey=explode('Created|',$yer[idxyea]);
	$ykey=$ykey[1];
	$ykey=explode('|',$ykey);
	$ykey=$ykey[0];
	$ykey=str_replace('?','',$ykey);
	//echo $ykey."- ";
	if (floor($ykey)==0 || floor($ykey)>3000) {
		continue;
	}
	if (floor($ykey)<2100) {
		$ykey+=0; // change mode to thai y here
	}
	$ydb[$ykey]=floor($ydb[$ykey])+1;
	$ykeycent=floor($ykey/10);
	//echo "[".($ykey/10)."=$ykeycent] ";
	$ydbcent[$ykeycent]=floor($ydbcent[$ykeycent])+1;
}
ksort($ydb);
ksort($ydbcent);
//printr($ydb);
//printr($ydbcent);
if (count($ydbcent)>0) {
?><TABLE cellpadding=3 cellspacing=0  width=100% style="margin-top: 8"><style>
.fucesedtab {
	border: 1 solid #D98D00;
	border-bottom-width:0;
	background-color: #FFE9BF;
}
.unfucesedtab {
	border: 0 solid #D98D00;
	border-bottom-width:1;
	background-color: #FFF2D9;
}
.tab_fucesedtab {
	border: 0 solid #D98D00;
	border-bottom-width:1
}
</style>
<TR>
	<TD class=tab_fucesedtab style="width: 100; ">&nbsp;</TD><?

@reset($ydbcent);
while (list($k,$v)=each($ydbcent)) {
	?><TD align=center <?
	if ($centclicked==$k) { echo " class=fucesedtab "; } else { echo " class=unfucesedtab "; }
	?>><nobr>&nbsp;<A style="font-weight: bold;" <?if ($v>0) { echo "HREF";}?>="index.php?mode=searching&kw=<? echo $kw?>&searchcate=<? echo $searchcate;?>&centclicked=<? echo $k;?>">ช่วงปี <? echo $k?>0</A>&nbsp;</nobr><BR>
	<FONT style="font-size: 13"><? echo number_format($v);?> รายการ</FONT></TD>
	<TD class=tab_fucesedtab >&nbsp;</TD><?
}
?><TD class=tab_fucesedtab style="width: 100%" >&nbsp;</TD>
</TR>
</TABLE><?
@reset($ydbcent);
if ($centclicked=="") {
	list($k,$v)=each($ydbcent)	;
	$centclicked=$k;
}

?><TABLE cellpadding=3 cellspacing=0 width=100% style="margin-top:8">
<TR>
	<TD class=tab_fucesedtab style="width: 100">&nbsp;</TD><?
/*if ($yiclicked=="") {
	list($k,$v)=each($ydb)	;
	$yiclicked=$k;
}*/
@reset($ydbcent);
for ($yi=0;$yi<=9;$yi++) {
	$thiskey=($centclicked*10+$yi);
	?><TD align=center <?
	if ($yiclicked==$thiskey) { echo " class=fucesedtab "; } else { echo " class=unfucesedtab "; }
	?>><nobr>&nbsp;<A style="font-weight: bold; font-size: 14" <?if ($ydb[$thiskey]>0) { echo "HREF";}?>="index.php?mode=searching&kw=<? echo $kw?>&searchcate=<? echo $searchcate;?>&yiclicked=<? echo ($thiskey)?>&centclicked=<? echo $centclicked;?>">ปี <? echo ($thiskey)?></A>&nbsp;</nobr><BR>
	<FONT style="font-size: 13"><? echo number_format($ydb[$thiskey]);?> รายการ</FONT></TD>
	<TD class=tab_fucesedtab >&nbsp;</TD><?
}
?><TD class=tab_fucesedtab style="width: 100%" >&nbsp;</TD>
</TR>
</TABLE><?
	
}
/////////////////////end y engine
}
		?><TABLE  width=100% border=0 class=mediabox cellpadding=0 cellspacing=0>
		<TR>
			<TD><?
		while ($r=tmq_fetch_array($showcase)) {
			show_mediaicon_long(barcodeval_get("webpage-dspctrl-searchresult"),$r[mid],"show","yes",80,150,"yes");
		}
		
		?></TD>
		</TR>
<?
		echo "$_pagesplit_btn_var";	
		?>
		
		</TABLE><?
	} else {
	echo "<BR>";
		html_dialog("",getlang("ไม่พบรายการที่ตรงกับเงื่อนไขของการค้นหา::l::No results"));
	}
?>