|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /var/www/html/pathumthani_eoffice/application/agenda/ |
Upload File : |
<?
//=========================================
// Select document type where status is '1'
// @author Kridsada Satakarn
// @date 2009/06/20
// @return a array of list document type where status is '1'
//=
session_start();
include("../../config/config.inc.php");
include("function/function.php");
include("function.listfile.php");
$sql="select varvalue from eoffice_config where appid='14' and modual_name='meeting_report' and varname='approve'";
//echo $sql;
$result =mysql_db_query($dbname,$sql);
$row=mysql_fetch_array($result );
$approveshow=$row[varvalue];
function selectFiles($sub_id, $id_type)
{
$path = "attach_file/temp/";
$add_cond = "";
if($id_type >= 0)
{
$add_cond = " AND id_type = ". $id_type;
}
$arr = array();
$sql = "SELECT
tbl_attach_file.attach_file,
tbl_attach_file.run_id,
tbl_attach_file.comment
FROM
tbl_attach_file
WHERE
tbl_attach_file.id_attach_file = '$sub_id' $add_cond order by run_id ASC";
$query = mysql_query($sql);
if($rs = mysql_fetch_array($query))
{
$arrfile= $rs[attach_file];
$arrcomment=( $rs[comment]=="")?$arrfile:$rs[comment];
return "<a href=\"download.php?path=$path$arrfile&filename=$arrfile\" target='fdownload' >".$arrcomment."</a>";
}else{
return "-";
}
}
//========================================
//===========================================
/**
* Recursively delete a directory
*
* @param string $dir Directory name
* @param boolean $deleteRootToo Delete specified top-level directory as well
*/
function delDIR($dir, $deleteRootToo)
{
if(!$dh = @opendir($dir))
{
return;
}
while (false !== ($obj = readdir($dh)))
{
if($obj == '.' || $obj == '..')
{
continue;
}
if (!@unlink($dir . '/' . $obj))
{
delDIR($dir.'/'.$obj, true);
}
}
closedir($dh);
if ($deleteRootToo)
{
@rmdir($dir);
}
return;
}
//===========================================
// Variable
//===========================================
/*function selectDocType()
{
$arr = array();
$sql = "SELECT
tbl_main_menu.id_menu,
tbl_main_menu.name_menu
FROM
tbl_main_menu
WHERE
tbl_main_menu.status_menu = '1'
ORDER BY tbl_main_menu.id_menu ASC";
$query = mysql_query($sql);
while($rs = mysql_fetch_assoc($query))
{
$arr[$rs[id_menu]] = $rs[name_menu];
}
return $arr;
}*/
$docType = selectDocType();
$month_arr=array('','มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฏาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม');
$smonth_arr=array('','ม.ค.','ก.พ.','มี.ค.','เม.ย.','พ.ค.','มิ.ย.','ก.ค.','ส.ค.','ก.ย.','ต.ค.','พ.ย.','ธ.ค.');
$folder = "attach_file/";
$path_temp = "attach_file/agenda/";
//===================================================================================================
if($_POST)
{
$time_start = $_POST[formhh1]. ":" . $_POST[formmm1]. ":00";
$time_end = $_POST[formhh2]. ":" . $_POST[formmm2]. ":00";
$conf=$_POST[conf];
if($_POST[hAction] == "ADD")
{
$strSQL_in = "INSERT INTO tbl_subject(subject, main, noorder, date_create, meeting_date, time_start, time_end,location, detail, status_sub, org_owner, org_phone)VALUES('$subject', '$chair_main', '$noorder', '$date_create', '$meeting_date', '$time_start', '$time_end','$location','$detail', '$status','$org_owner','$org_phone')";
$Result_in = mysql_db_query($dbname,$strSQL_in);
$last = mysql_insert_id();
if($conf){
$sql="Update tbl_subject set confirm='$xtype', confirmby='$_SESSION[session_staffid]' where id_sub='$last'";
mysql_query($sql);
$sql="insert into tbl_subject_approve(id_subject,approve_type,comment_detail,comment_by,comment_date) values('$last','$conf','','$_SESSION[session_staffid]',NOW())";
mysql_query($sql);
}
$rs = true;
//echo "<pre>";
//print_r($_POST);
//exit();
// mkdir("$folder/$last");
$arr_tempfile = $_POST[tempfile];
// $arr_file = explode(";",$_POST[hListFiles]);
// $arr_doctype = explode(";",$_POST[hDocType]);
// $length = count($arr_timestamp);
if($_POST[tempfile]){
foreach($arr_tempfile as $key=>$values)
{
// $up_file = @copy("$folder_temp$arr_timestamp[$i]$arr_file[$i]", "attach_file/$last/$arr_file[$i]");
// if($up_file)
// {
// $del_file = @unlink("$folder_temp$arr_timestamp[$i]$arr_file[$i]");
//0=idtype
//1=filename
//2=comment
$arr_file= explode(":",$values);
$sql = "INSERT INTO tbl_attach_file(id_attach_file, id_type, attach_file, status_file,comment) VALUES ('$last', '$arr_file[0]', '$arr_file[1]', 'Y','$arr_file[2]')";
$rs = mysql_db_query($dbname,$sql);
// }
}
}
if($Result_in && $rs)
{
echo "
<script language=\"javascript\">
location.href='report_index.php?action=Sreport&id_menu=$id_menu&name_menu=$name_menu';
</script>
";
exit();
}else{
}
}else if($_POST[hAction] == "EDIT")
{
$strSQL_update = "UPDATE tbl_subject SET subject='$subject', main='$chair_main', noorder='$noorder', date_create='$date_create', meeting_date='$meeting_date', time_start='$time_start' , time_end='$time_end', location='$location', detail='$detail', status_sub=$status, org_owner='$org_owner', org_phone='$org_phone',confirm='$conf' WHERE id_sub='$id_up'";
$Result_update = mysql_db_query($dbname,$strSQL_update);
if($Result_update)
{
echo "
<script language=\"javascript\">
location.href='report_index.php?action=Sreport&id_menu=$id_menu&name_menu=$name_menu&page=$page';
</script>
";
exit();
}
}
}
//------------------ลบรายการ -----------------
if($action == "DEL_DATA"){
// ลบไฟล์
delDIR("$folder$id", true);
/*
$strSQL = "SELECT * FROM tbl_attach_file WHERE id_attach_file='$id'";
$Result = mysql_db_query($dbname,$strSQL);
while($Rs = mysql_fetch_object($Result)){
$strSQL1 = "SELECT * FROM tbl_attach_file WHERE attach_file LIKE '%$Rs->attach_file%'";
$Result1 = mysql_db_query($dbname,$strSQL1);
$num_r = mysql_num_rows($Result1);
if($num_r == 1){
$del_file = $folder_img.$Rs->attach_file;
@unlink($del_file);
}
}
*/
//ลบข้อมุลในตารางไฟล์แนบ
$strSQL2 = "DELETE FROM tbl_attach_file WHERE id_attach_file='$id'";
$Result2 = mysql_db_query($dbname,$strSQL2);
// ลบรายการ subject
$strSQL3 = "DELETE FROM tbl_subject WHERE id_sub='$id'";
$Result3 = mysql_db_query($dbname,$strSQL3);
if($Result3){
echo "
<script language=\"javascript\">
location.href='report_index.php?action=Sreport&id_menu=$id_menu&name_menu=$name_menu';
</script>
";
exit();
}
}
?>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<LINK href="common/style.css" rel=stylesheet>
<script language='javascript' src='daily_popcalendar.js'></script>
<script language='javascript' src='displayelement.js'></script>
<script language='javascript' src='sorttable.js'></script>
<script language='javascript' src='jquery.js'></script>
<script language="javascript">
var approveshow='<?=$approveshow?>';
function confirmdel(){
if(!confirm('ต้องการลบข้อมูลหรือไม่')){ return false}
}
function genXHR()
{
var xmlHttp=null;
try{
// Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
}catch (e){
// Internet Explorer
try{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}catch (e){
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
function showLoading()
{
var div = document.getElementById("divUpload");
div.innerHTML = "<img src=\"images/indicator.gif\" border=\"0\" > กำลังอัพโหลดไฟล์";
}
function findIndex(arr, str)
{
var index = -1;
if(arr.length > 0)
{
for(i = 0; i < arr.length ; i++)
{
if(arr[i] == str)
{
index = i;
}
}
}
return index;
}
function getSelTxt(sel, val)
{
var str = "";
for(var i=0; i < sel.length ; i++)
{
if(sel.options[i].value == val)
{
str = sel.options[i].text;
break;
}
}
return str;
}
function delFile(action, filename, timestamp, rid, id_sub)
{
if(!confirm('ต้องการลบรูปหรือไม่')){ return false}
var hLF = document.getElementById("hListFiles");
var hDT = document.getElementById("hDocType");
var hTS = document.getElementById("hTimeStamp");
var divList = document.getElementById("divListFiles");
var selDocType = window.frames['uploadtarget'].document.getElementById('selDocType');
j=genXHR();
j.onreadystatechange=function()
{
if (j.readyState==4 || j.readyState=="complete")
{
var result = j.responseText;
if(result != "")
{
if(action == "DEL_TEMP")
{
var path_temp = "attach_file/temp/";
var arr_lf = hLF.value.split(";");
var arr_ts = hTS.value.split(";");
var arr_dt = hDT.value.split(";");
var index = findIndex(arr_lf, result);
arr_lf.splice(index, 1);
arr_ts.splice(index, 1);
arr_dt.splice(index, 1);
divList.innerHTML = "";
var show = "";
var doc_type = "";
for(var i = 0; i< arr_lf.length-1 ; i++)// length - 1 เพราะว่า hLF.value มี ; อยู่สุดท้ายอีกหนึ่งตัว
{
doc_type = getSelTxt(selDocType, arr_dt[i]);
str_add = "<a href=\"download.php?path=" +path_temp + arr_ts[i] + arr_lf[i] + "&filename=" + arr_lf[i] +"\" target='fdownload' >" + arr_lf[i]+"</a><a href=\"#\" onclick=\"delFile('DEL_TEMP', '" + arr_lf[i] +"', '" + arr_ts[i] + "', '-1', '-1')\" ><img src=\"images/delete.gif\" width=\"15\" height=\"15\" alt=\"ลบไฟล์\" border=\"0\" ></a><BR><!--t" + arr_dt[i] + "-->";
if(show.search("<!--t" + arr_dt[i] + "-->") != -1)
{
show = show.replace("<!--t" + arr_dt[i] + "-->" , str_add);
}else
{
show += "<b>" + doc_type + "</b><BR>" + str_add;
}
}
divList.innerHTML = show;
hLF.value = arr_lf.join(";");
hTS.value = arr_ts.join(";");
hDT.value = arr_dt.join(";");
}else if(action == "DEL")
{
upListFile("del",'', '', rid, id_sub,id_sub, rid )
}
}
}
}
j.open("GET","ajax_delfile.php?action=" + action + "&filename=" + filename + "×tamp=" + timestamp + "&rid=" + rid + "&id_sub=" + id_sub);
j.send(null);
}
function upListFile(action,filename, path, id_sub, id_type,filenameorg, rid )
{
$('#divUpload').empty();
if(action=="add"){
str ="<div id=\"sub_"+id_sub+"\"><a href=\"download.php?path="+path+"&filename="+filename+"\" target=\"fdownload\" >"+filenameorg+"</a>\n";
str +="<a href=\"#\"onclick=\"delFile('DEL', '"+filename+"','' , '"+id_sub+"' ,'"+ id_type+"')\"><img src=\"images/delete.gif\"width=\"15\" height=\"15\" alt=\"ลบไฟล์\" border=\"0\"></a></div>\n";
str +="<input name=\"tempfile[]\" type=\"hidden\" value=\""+id_type+":"+filename+":"+filenameorg+"\" />";
$('#mode_'+id_type).append(str)
if(id_type==3&&approveshow=="on"){
strbut="<input name=\"confirm\" type=\"button\" onclick =\"formE.conf.value=1\" value=\"รับรองการประชุม\" style=\"font-size:12px;width:150px;height:20px\"/>";
$('#button').empty().append(strbut) ;
}
}else if(action=="del"){
$('#sub_'+id_sub).remove()
var d=document.getElementById('mode_'+id_type).getElementsByTagName('div')
if(id_type==3)
{
if(!d){
$('#conf').val(0);
$('#button').empty();
}else{
if(d.length==0){
$('#conf').val(0);
$('#button').empty();
}
}
}
}
}
</script>
<style type="text/css">
.page {
font : 9px tahoma;
font-weight : bold;
color : #0280D5;
padding : 1px 3px 1px 3px;
}
.pagelink {
font : 9px tahoma;
font-weight : bold;
color : #000000;
text-decoration : underline;
padding : 1px 3px 1px 3px;
}
.go {
BORDER: #59990e 1px solid;
PADDING-RIGHT: 0.38em;
PADDING-LEFT: 0.38em;
FONT-WEIGHT: bold;
FONT-SIZE: 105%;
BACKGROUND: url(../hr3/hr_report/images/hdr_bg.png) #6eab26 repeat-x 0px -90px;
FLOAT: left;
PADDING-BOTTOM: 0px;
COLOR: #fff;
MARGIN-RIGHT: 0.38em;
PADDING-TOP: 0px;
HEIGHT: 1.77em
}
#bf .go {
FLOAT: none
}
.go:hover {
BORDER: #3f8e00 1px solid;
BACKGROUND: url(../hr3/hr_report/images/hdr_bg.png) #63a218 repeat-x 0px -170px;
}
.q {
BORDER-RIGHT: #5595CC 1px solid;
PADDING-RIGHT: 0.7em;
BORDER-TOP: #5595CC 1px solid;
PADDING-LEFT: 0.7em;
FONT-WEIGHT: normal; FONT-SIZE: 105%;
FLOAT: left;
PADDING-BOTTOM: 0px;
MARGIN: 0px 0.38em 0px 0px;
BORDER-LEFT: #5595CC 1px solid;
WIDTH: 300px;
PADDING-TOP: 0.29em;
BORDER-BOTTOM: #5595CC 1px solid;
HEIGHT: 1.39em
}
.tabberlive .tabbertab {
background-color:#FFFFFF;
height:200px;
}
</style>
<style type="text/css">
<!--
.header1 { font-family:"MS Sans Serif", Tahoma, Arial;
font-size:1em;
font-weight:bold;
color: #FFFFFF;
}
.main { font-family:"MS Sans Serif", Tahoma, Arial;
font-size:0.8em;
color:#FF0000;
font-weight:bold;
}
.normal { font-family:"MS Sans Serif", Tahoma, Arial;
font-size:0.8em;
}
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.style1 {color: #FF0000}
-->
</style>
<script language="javascript">
function popWindow(url, w, h){
var popup = "Popup";
if(w == "") w = 550;
if(h == "") h = 450;
var newwin = window.open(url, popup,'location=0,status=no,scrollbars=no,resizable=yes,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
</script>
</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0" style="filter:progid:DXImageTransform.Microsoft.Gradient(GradientType=0, StartColorStr='#144C85', EndColorStr='#ffffff');">
<tr>
<td align="center" valign="top" bgcolor="#000000">
<?
$action = "Sreport" ;
if($action == "Sreport"){
//---------------------------------start function ---------------------------------------------
function devidepage($total, $kwd , $sqlencode ){
$per_page = 11;
$page_all = $total;
global $page,$id_menu,$name_menu;
if($total >= 1){
$table = "<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">";
$table = $table."<tr align=\"right\">";
$table = $table."<td width=\"80%\" align=\"left\" height=\"30\"> ";
if($page_all <= $per_page){
$min = 1;
$max = $page_all;
} elseif($page_all > $per_page && ($page - 5) >= 2 ) {
$min = $page - 5;
$max = (($page + 5) > $page_all) ? $page_all : $page + 5;
} else {
$min = 1;
$max = $per_page;
}
if($min >= 4){
$table .= "<a href=\"?action=Sreport&id_menu=$id_menu&name_menu=$name_menu&page=1&displaytype=people".$kwd."\"><u><font color=\"black\">หน้าแรก</font></u></a> ";
}
for($i=$min;$i<=$max;$i++){
$i = str_pad($i, 2, "0", STR_PAD_LEFT);
if($i != $page){
$table .= "<a href=\"?action=Sreport&id_menu=$id_menu&name_menu=$name_menu&page=".$i."&displaytype=people". $kwd."\"><span class=\"pagelink\">".$i."</span></a>";
} else {
$table .= "<span class=\"page\">".$i."</span>";
}
}
if(($page + 5) <= $page_all){
$table .= " <a href=\"?action=Sreport&id_menu=$id_menu&name_menu=$name_menu&page=".$page_all."&displaytype=people". $kwd."\"><u><font color=\"black\">หน้าสุดท้าย</font></u></a>";
}
if($page_all > 1){
$table .= " <a href=\"?action=Sreport&id_menu=$id_menu&name_menu=$name_menu&page=".($page_all+1)."&displaytype=people". $kwd."\"><u><font color=\"black\">แสดงทั้งหมด</font></u></a>";
}
# $table .= " <a href=\"search_excel.php?page=$sqlencode\"><u><font color=\"black\">ส่งออกรูปแบบ MS Excel </font></u></a>";
unset($max,$i,$min);
$table = $table."</td>";
$table = $table."<td width=\"20%\">จำนวนทั้งหมด <b>".number_format($page_all, 0, "", ",")."</b> หน้า </td>";
$table = $table."</tr>";
$table = $table."</table>";
}
return $table;
}
//--------------------------------------end function -----------------------------------------
//--------------------------แบ่งหน้า----------------
$page = (!isset($page) || $page <= 0) ? 1 : $page ;
$e = (!isset($e) || $e == 0) ? 20 : $e ;
$i = (!isset($page) || ($page == 1)) ? 0 : ($page - 1) * $e ;
$strSQL = "SELECT * FROM tbl_subject WHERE id_menu='$id_menu'";
$Result = mysql_db_query($dbname,$strSQL);
$all= @mysql_num_rows($Result);
$allpage = ceil($all / $e);
$sumpage = (($i + $e) >= $all) ? $all : ($i + $e) ;
$xpage=$allpage +1;
if($page <= $allpage){
$strSQL1 = "SELECT tbl_subject.*, org_staffgroup.groupname as owner FROM tbl_subject LEFT JOIN org_staffgroup ON tbl_subject.org_owner = org_staffgroup.gid ORDER BY meeting_date DESC , date_create DESC LIMIT $i, $e";
}else if($page == $xpage){
$strSQL1 = "SELECT tbl_subject.*, org_staffgroup.groupname as owner FROM tbl_subject LEFT JOIN org_staffgroup ON tbl_subject.org_owner = org_staffgroup.gid ORDER BY meeting_date DESC , date_create DESC";
}else{
$strSQL1 = "SELECT tbl_subject.*, org_staffgroup.groupname as owner FROM tbl_subject LEFT JOIN org_staffgroup ON tbl_subject.org_owner = org_staffgroup.gid ORDER BY meeting_date DESC , date_create DESC LIMIT $i, $e";
}
$Result1 = mysql_db_query($dbname,$strSQL1);
#echo " $strSQL1 ";
$search_sql = $strSQL1 ;
$num_row = mysql_num_rows($Result1);
$i=0;
while($Rs1= mysql_fetch_assoc($Result1))
{
$show_id[$i] = $Rs1[id_sub];
$show_subject[$i] = $Rs1[subject];
$show_main[$i] = $Rs1[main];
if($Rs1[meeting_date]!="0000-00-00"){
$datearr=explode("-",$Rs1[meeting_date]);
$date =($datearr[2]*1)." ". $smonth_arr[$datearr[1]+0]." ".$datearr[0];
}
else{
$date="";
}
$show_meeting_date[$i] = $date;
$t1_arr=explode(":",$Rs1[time_start]);
$t1=($t1_arr[0]+0).":".$t1_arr[1] ." น. ";
if($Rs1[time_end]!=$Rs1[time_end]){
$t1_arr=explode(":",$Rs1[time_end]);
$t1.=" - ".($t1_arr[0]+0).":".$t1_arr[1] ." น. ";
}
$show_time[$i] = $t1;
$show_location[$i] = $Rs1[location];
$show_owner[$i] = $Rs1[owner];
$sql = "SELECT
tbl_attach_file.id_type, Count(tbl_attach_file.id_type) as num
FROM
tbl_attach_file
WHERE
tbl_attach_file.id_attach_file = '$Rs1[id_sub]'
GROUP BY
tbl_attach_file.id_type";
$qr = mysql_query($sql);
$arr_temp = array();
while($rs = mysql_fetch_assoc($qr))
{
$arr_temp[$rs[id_type]] = $rs[num];
}
$show_doc[$i] = $arr_temp;
$i++;
}
?>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td width="17%" align="left" valign="middle" bgcolor="#E6ECF7"><b> <?=$name_menu?></b></td>
</tr>
<?
//==========================================================
// Create report table
//==========================================================
$rowspan = 2;
$colspan = count($docType);
echo '<table width="100%" border="0" cellspacing="1" cellpadding="3">';
echo '<tr>
<td width="4%" rowspan="'.$rowspan.'" align="center" bgcolor="#B0C6E6">ลำดับ</td>
<td width="19%" rowspan="'.$rowspan.'" align="center" bgcolor="#B0C6E6">ชื่อการประชุม</td>
<td width="15%" rowspan="'.$rowspan.'" align="center" bgcolor="#B0C6E6">ประธานการประชุม</td>
<td width="9%" rowspan="'.$rowspan.'" align="center" bgcolor="#B0C6E6">วันที่ประชุม</td>
<td width="6%" rowspan="'.$rowspan.'" align="center" bgcolor="#B0C6E6">เวลา</td>
<td width="14%" rowspan="'.$rowspan.'" align="center" bgcolor="#B0C6E6">สถานที่</td>
<td width="13%" rowspan="'.$rowspan.'" align="center" bgcolor="#B0C6E6">หน่วยงานเจ้าของเรื่อง</td>
<td colspan="'.$colspan.'" align="center" bgcolor="#B0C6E6">เอกสารประกอบการประชุม</td>';
echo'</tr>';
echo '<tr>';
foreach($docType as $key => $value)
{
echo '<td align="center" bgcolor="#B0C6E6">'.$value.'</td>';
}
echo '</tr>';
$n=0;
for($j=0;$j<count($show_subject);$j++)
{
$bg_color = ($n%2)?'#F1F1F1':'FFFFFF';$n++;
$order = ($page == $allpage+1)? $n :((($page-1) * $e) + $n);
echo '<tr bgcolor="'.$bg_color.'">
<td align="center">'.$order.'</td>
<td align="left">'.$show_subject[$j].' </td>
<td align="left">'.$show_main[$j].'</td>
<td align="center">'.$show_meeting_date[$j].'</td>
<td align="center">'.$show_time[$j].'</td>
<td align="left">'.$show_location[$j].'</td>
<td align="left">'.$show_owner[$j].'</td>';
$arr_temp = $show_doc[$j];
foreach($docType as $key => $value)
{
if($arr_temp[$key]!==""){
$num_doc = ($arr_temp[$key] > 1)? "<a href=\"#\" onClick=\"popWindow('pop_file.php?idsub=".$show_id[$j]. "&id_type=".$key . "' , '300' , '" . (30*($arr_temp[$key])) . "')\">". $arr_temp[$key]. "รายการ</a>" :selectFiles($show_id[$j],$key);
}else{
$num_doc = "-";
}
echo '<td align="center">'.$num_doc.'</td>';
}
echo "</tr>";
}
echo '</table>';
?>
<tr>
<td bgcolor="#FFFFFF">
<? $sqlencode = urlencode($search_sql) ; ?>
<?=devidepage($allpage, $keyword ,$sqlencode )?> </td>
</tr>
</table>
<?
}
//===========================================================
// End Sreport
//===========================================================
?> </td>
</tr>
</table>
</body>
</html>