|
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/bin/agenda_bkk/ |
Upload File : |
<?
//session_start();
include("../../config/config.inc.php");
include("function/function.php");
$month_arr=array('','มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฏาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม');
$month_s=array('','ม.ค.','ก.พ.','มี.ค.','เม.ย.','พ.ค.','มิ.ย.','ก.ค.','ส.ค.','ก.ย.','ต.ค.','พ.ย.','ธ.ค.');
//if(!isset($session_username)){
//header("Location: login.php");
//}
?>
<html>
<head>
<title><?=$show_title?></title>
<META http-equiv=Content-Type content="text/html; charset=windows-874">
<link href="common/style.css" type="text/css" rel="stylesheet" />
<script language='javascript' src='daily_popcalendar.js'></script>
<script language='javascript' src='displayelement.js'></script>
<style type="text/css">
<!--
body { margin: 0px 0px; padding: 0px 0px}
a:link { color: #005CA2; text-decoration: none}
a:visited { color: #005CA2; text-decoration: none}
a:active { color: #0099FF; text-decoration: underline}
a:hover { color: #0099FF; text-decoration: underline}
.style2 {color: #000000}
-->
a.inmain_link:link,a.inmain_link:visited{
color:#2176A8;
text-decoration:none;
}
a.inmain_link:hover{
color:#B0F3FF;
text-decoration:underline;
}
</style>
<SCRIPT LANGUAGE="JavaScript">
function CheckForm(){
missinginfo = "";
missinginfo1 = "";
if (document.form.subject.value == "") {missinginfo1 += "\n- กรุณากรอก เรื่องร้องเรียน "; }
if (document.form.subject_no_in.value == "") {missinginfo1 += "\n- กรุณากรอก เลขที่หนังสือ "; }
if (document.form.date_start.value == "") {missinginfo1 += "\n- กรุณากรอก วันเริ่มต้น "; }
if (document.form.date_end.value == "") {missinginfo1 += "\n- กรุณากรอก สิ้นสุด "; }
if (missinginfo1 != "") {
missinginfo += "ไม่สามารถบันทึกข้อมูลได้ เนื่องจาก \n";
missinginfo +="_____________________________\n";
missinginfo = missinginfo + missinginfo1 ;
missinginfo += "\n___________________________";
missinginfo += "\nกรุณาตรวจสอบ อีกครั้ง";
alert(missinginfo);
return false;
}
}
</SCRIPT>
<script language="javascript">
function popWindow(url, w, h){
var popup = "Popup";
if(w == "") w = 420;
if(h == "") h = 300;
var newwin = window.open(url, popup,'location=0,status=no,scrollbars=no,resizable=no,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
function popWindow1(url, w, h){
var popup = "Popup";
if(w == "") w = 420;
if(h == "") h = 300;
var newwin = window.open(url, popup,'location=0,status=no,scrollbars=no,resizable=no,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
function popWindow2(url, w, h){
var popup = "Popup";
if(w == "") w = 420;
if(h == "") h = 300;
var newwin = window.open(url, popup,'location=0,status=no,scrollbars=no,resizable=no,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
</script>
<script language="javascript">
function clearselect()
{
document.post.salary_day.disabled=true;
document.post.salary_month.disabled=true;
document.post.salary_year.disabled=true;
document.post.label_date.disabled=true;
if (document.post.salary_day.value!="")
{
document.post.salary_day.value="";
document.post.salary_day.disabled=true;
}
if (document.post.salary_month.value!="")
{
document.post.salary_month.value="";
document.post.salary_month.disabled=true;
}
if (document.post.salary_year.value!="")
{
document.post.salary_year.value="";
document.post.salary_year.disabled=true;
}
if (document.post.label_date.value!="")
{
document.post.label_date.value="";
document.post.label_date.disabled=true;
}
}
</script>
</head>
<body >
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><?
if($action == "Sreport"){
?>
<form action="reportALL.php?action=Sreport&id_menu=<?=$id_menu?>" method="post" name="form1">
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td width="6%">ช่วงเวลา</td>
<td width="19%">
<input name="date_create1" type="text" onFocus="blur();" value="<?=$date_create1?>" size="15" readonly>
<input name="button2" type="button" class="index2" style='font-size:11px; width:80px;' onClick="popUpCalendar(this, form.date_create1, 'yyyy-mm-dd')" value='วันเดือนปี'></td>
<td width="2%">ถึง</td>
<td width="73%">
<input name="date_create2" type="text" onFocus="blur();" value="<?=$date_create2?>" size="15" readonly>
<input name="button2" type="button" class="index2" style='font-size:11px; width:80px;' onClick="popUpCalendar(this, form.date_create2, 'yyyy-mm-dd')" value='วันเดือนปี'></td>
</tr>
<tr>
<td colspan="4" align="left"><label>
<input type="submit" name="Submit" value="แสดงตามช่วงเวลา">
<input type="button" name="btnALL" value="แสดงตามช่วงเวลาทั้งหมด" onClick="location.href='reportALL.php?action=Sreport&date_create1=&date_create2=&id_menu=<?=$id_menu?>'">
</label></td>
</tr>
</table>
</form>
<?
}
?>
</td>
</tr>
</table>
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0" style="filter:progid:DXImageTransform.Microsoft.Gradient(GradientType=0, StartColorStr='#FFFFFF', EndColorStr='#ffffff');">
<tr>
<td valign="top" background="bimg/bg1.gif" style="background-repeat: no-repeat; background-position:right bottom "><table width="100%" border="0" cellspacing="1" cellpadding="2">
<?
if($action == "Sreport"){
// function devidepage($total, $kwd , $sqlencode ){
// $per_page = 11;
// $page_all = $total;
// global $page,$id_menu;
//
// if($total >= 1){
// $table = "<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">";
// $table = $table."<tr align=\"right\">";
// $table = $table."<td width=\"70%\" 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&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&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&page=".$page_all."&displaytype=people". $kwd."\"><u><font color=\"black\">หน้าสุดท้าย</font></u></a>";
// }
//
// if($page_all > 1){
// $table .= " <a href=\"reportALL.php?action=Sreport&id_menu=$id_menu&page=".($page_all+1)."&displaytype=people". $kwd."\" target='_self'><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=\"30%\">จำนวนทั้งหมด <b>".number_format($page_all, 0, "", ",")."</b> หน้า </td>";
// $table = $table."</tr>";
// $table = $table."</table>";
// }
// return $table;
//}
//
//
////--------------------------------------end function -----------------------------------------
if($date_create1 != "" and $date_create2 != ""){
$condit = " AND date_create BETWEEN '$date_create1' AND '$date_create2'";
}else if($date_create1 != "" and $date_create2 == ""){
$arr_d = explode("-",$date_create1);
$condit = " AND date_create like '$arr_d[0]-$arr_d[1]%' ";
}else if($date_create2 != "" and $date_create1 == ""){
$arr_d2 = explode("-",$date_create2);
$condit = " AND date_create like '$arr_d2[0]-$arr_d[1]%'";
}else{
$condit = "";
}
$strSQL1 = "SELECT * FROM tbl_subject WHERE id_menu='$id_menu' AND status_sub='1' $condit ORDER BY date_create DESC";
$Result1 = mysql_db_query($dbname,$strSQL1);
$search_sql = $strSQL1 ;
$num_row = mysql_num_rows($Result1);
$i=0;
while($Rs1= mysql_fetch_object($Result1)){
$txtdate_create[$i] = $Rs1->date_create;
$txtid_sub[$i] = $Rs1->id_sub;
$txtsubject[$i] = $Rs1->subject;
$i++;
}
?>
<?
if($num_row < 1){
?>
<tr>
<td colspan="3" align="left" style="border-top:#0099FF dotted 1px;"> - ไม่พบรายการตามช่วงเวลาที่กำหนด - </td>
</tr>
<?
die;
}
?>
<tr>
<td colspan="3" align="left" style="border-top:#0099FF dotted 1px;"> </td>
</tr>
<?
$n=0;
for($j=0;$j<count($txtid_sub);$j++){
$n++;
?>
<tr>
<td width="20" align="left" valign="top"><?=$n?></td>
<td width="89" align="left" valign="top"><?
if($txtdate_create[$j] != "0000-00-00"){
$arr_r = explode("-",$txtdate_create[$j]);
echo intval($arr_r[2])." ".$month_s[intval($arr_r[1])]." ".$arr_r[0];
}
?></td>
<td align="left" valign="top"><a href="report_view.php?id=<?=$txtid_sub[$j]?>" target="_blank">
<?=$txtsubject[$j]?>
</a>
<?
$dd = date("d");
$mm = date("m");
$yy = date("Y")+543;
$check_dd = $yy."-".$mm."-".$dd;
$arrR = explode("-",$txtdate_create[$j]);
if($arrR[0] == $yy){
if($arrR[1] == $mm){
echo "<img src='images/new.gif' width='24' height='7' border='0' alt='ข่าวใหม่'>";
}else{
echo "";
}
}else{
echo "";
}
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<?
$strSQL2 = "SELECT * FROM tbl_attach_file WHERE id_attach_file='$txtid_sub[$j]' AND status_file='Y'";
$Result2 = mysql_db_query($dbname,$strSQL2);
while($Rs2 = mysql_fetch_object($Result2)){
?>
<tr>
<td align="left" valign="top"><a href="attach_file/<?=$Rs2->attach_file?>" target="_blank"><img src="images/attach.gif" alt="คลิกเพื่อดูไฟล์แนบ" border="0" align="absmiddle">
<?=$Rs2->comment?>
</a></td>
</tr>
<?
}
?>
<?
$strSQL_url = "SELECT * FROM tbl_url WHERE id_sub='$txtid_sub[$j]'";
$Result_url = mysql_db_query($dbname,$strSQL_url);
while($Rs_url = mysql_fetch_object($Result_url)){
?>
<tr>
<td align="left" valign="top"><a href="<?=$Rs_url->url?>" target="_blank"><img src="images/yast_www.png" border="0" alt="เว็บอ้างอิง" width="16" height="16"><?=$Rs_url->url_name?></a></td>
</tr>
<?
}
?>
</table></td>
</tr>
<?
} // end for
?>
<tr>
<td colspan="3" align="left" style="border-top:#0099FF dotted 1px;">
</td>
</tr>
<?
}
?>
</table></td>
</tr>
</table>
</body>
</html>