|
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 : |
<?
session_start();
include("header_menu.php");
include("../../config/config.inc.php");
include("function/function.php");
$smonth = array("","ม.ค.", "ก.พ.", "มี.ค.", "เม.ย.", "พ.ค.", "มิ.ย.", "ก.ค.", "ส.ค.", "ก.ย.", "ต.ค.", "พ.ย.", "ธ.ค.");
function check_data($id, $type = "type"){
$sql = "SELECT * FROM tbl_config_meeting WHERE type_set='$id' and colump ='$type'";
$result = @mysql_query($sql);
$num1 = @mysql_num_rows($result);
return $num1;
}
?>
<link href="../../common/style.css" rel="stylesheet" type="text/css" />
<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">
function clear_calen(){
document.post.date_create.value = "";
}
function toDisble(rdo)
{
var value = rdo.value;
if(value == "0")
{
document.getElementById("act_start_date").disabled = true;
document.getElementById("button1").disabled = true;
document.getElementById("act_end_date").disabled = true;
document.getElementById("button2").disabled = true;
document.getElementById("act_start_date0").disabled = false;
document.getElementById("button0").disabled = false;
}else if(value == "1")
{
document.getElementById("act_start_date").disabled = false;
document.getElementById("button1").disabled = false;
document.getElementById("act_end_date").disabled = false;
document.getElementById("button2").disabled = false;
document.getElementById("act_start_date0").disabled = true;
document.getElementById("button0").disabled = true;
}
}
</script>
<LINK href="common/style.css" rel=stylesheet>
<?
if ($_SERVER[REQUEST_METHOD] == "POST"){
//if($subject != ""){ $conw = " AND subject LIKE '%$subject%' ";}
if($noorder != ""){ $conw .= " AND noorder LIKE '%$noorder%'";}
if($main!=""){$conw .= " AND main LIKE '%$main%'";}
if($detail != ""){ $conw .= " AND detail LIKE '%$detail%'";}
if($act_start_date0 != ""){ $arr = explode("/",$act_start_date0); $temp_date1 = $arr[2]."-".$arr[1]."-".$arr[0]; $conw .= " AND date_create LIKE '%$temp_date1%'";}
if($act_start_date!="" && $act_end_date!="" ){
$act_start_date=implode("-",array_reverse(explode("/",$act_start_date)));
$act_end_date=implode("-",array_reverse(explode("/",$act_end_date)));
$conw .= " AND date_create>='$act_start_date' AND date_create<='$act_end_date'";
};
$sql_search = "SELECT * FROM tbl_subject WHERE subject LIKE '%$subject%' $conw ";
$result_search = mysql_query($sql_search);
$num1 = @mysql_num_rows($result_search);
}
?><form action="" method="post" enctype="multipart/form-data" name="post" id="post">
<table width="72%" border="0" align="center" cellpadding="1" cellspacing="0" bgcolor="#EEEEEE">
<tr>
<td align="right" bgcolor="#999999">
<table width="100%" border="0" cellpadding="1" cellspacing="0">
<tr>
<td colspan="6" align="left" background="../../images/bg_tr_blue.gif" class="executive_bg"><img src="images/view_backup.gif" width="16" height="16" />ค้นหา</td>
</tr>
<tr>
<td height="20" align="right" class="index2"><strong>หัวข้อการประชุม : </strong></td>
<td width="607" height="20" colspan="5" align="left" class="index2"><label>
<input name="subject" type="text" id="subject" size="70" value="<?=$subject?>">
</label></td>
</tr>
<tr>
<td height="20" align="right" class="index2"><strong>ประธานการประชุม : </strong></td>
<td width="607" height="20" colspan="5" align="left" class="index2"><label>
<input name="main" type="text" id="subject" size="70" value="<?=$main?>">
</label></td>
</tr>
<tr>
<td height="20" align="right" class="index2"><strong>เลขที่หนังสือ : </strong></td>
<td height="20" colspan="5" align="left" class="index2"><label>
<input name="noorder" type="text" id="noorder" size="70" value="<?=$noorder?>">
</label></td>
</tr>
<tr>
<td align="right" class="index2"><strong>รายละเอียด : </strong></td>
<td height="20" colspan="5" align="left" class="index2"><label>
<input name="detail" type="text" id="detail" size="70" value="<?=$detail?>">
</label></td>
</tr>
<tr>
<TD align="right" valign="top" class="index2"><strong>วันที่ : </strong></TD>
<TD align="left" class="index2">
<INPUT type="radio" name="rdodate" id="rdodate" value="0" <?= $chk1 ?> onClick="toDisble(this)" >
<INPUT name="act_start_date0" id="act_start_date0" type="text" onFocus="blur();" size="20" value="<?=$act_start_date0?>" readonly <?= $dis1?>>
<INPUT name="button0" id="button0" type="button" style='font-size:11px; width:80px;' onClick="popUpCalendar(this, form.act_start_date0, 'dd/mm/yyyy')" value='วัน เดือน ปี' <?= $dis1?>> </TD>
</TR>
<TR>
<TD align="right" valign="top" class="index2" ><strong>ระหว่างวันที่ : </strong></TD>
<TD align="left" class="index2">
<INPUT type="radio" name="rdodate" id="rdodate" value="1" <?= $chk2?> onClick="toDisble(this)">
<INPUT name="act_start_date" id="act_start_date" type="text" onFocus="blur();" size="20" value="<?=$txt_act_start_date?>" readonly <?= $dis2?>>
<INPUT name="button1" id="button1" type="button" style='font-size:11px; width:80px;' onClick="popUpCalendar(this, form.act_start_date, 'dd/mm/yyyy')" value='วัน เดือน ปี' <?= $dis2?>>
ถึง
<INPUT name="act_end_date" id="act_end_date" type="text" onFocus="blur();" size="20" value="<?=$txt_act_end_date?>" readonly <?= $dis2?>>
<INPUT name="button2" id="button2" type="button" style='font-size:11px; width:80px;' onClick="popUpCalendar(this, form.act_end_date, 'dd/mm/yyyy')" value='วัน เดือน ปี' <?= $dis2?>> </TD>
</tr>
<tr>
<td height="20" colspan="6" align="center" class="index2"> </td>
</tr
><tr>
<td height="20" colspan="6" align="center" class="index2"><HR color="#eeeeee">
<input name="submit2" type="submit" class="input" style="width:100;" value="ค้นหา" />
<input name="button" type="button" class="input" style="width:100;" onclick="location.href='login_admin.php'" value="กลับหน้าหลัก" /></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<? if($num1 > 0){ ?>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
<tr>
<td bgcolor="#000000"><table width="100%" border="0" cellpadding="3" cellspacing="1">
<tr>
<td width="5%" align="center" bgcolor="#E7E7E7"><strong>ลำดับ</strong></td>
<td width="22%" align="center" bgcolor="#E7E7E7"><strong>ชื่อเรื่อง</strong></td>
<td width="10%" align="center" bgcolor="#E7E7E7"><strong>ประธานการประชุม</strong></td>
<td width="12%" align="center" bgcolor="#E7E7E7"><strong>เลขที่หนังสือ</strong></td>
<td width="19%" align="center" bgcolor="#E7E7E7"><strong>รายละเอียด</strong></td>
<td width="10%" align="center" bgcolor="#E7E7E7"><strong>ลงวันที่</strong></td>
<td width="10%" align="center" bgcolor="#E7E7E7"><strong>ไฟล์แนบ</strong></td>
<td width="12%" align="center" bgcolor="#E7E7E7"><strong>url</strong></td>
</tr>
<?
$n=0;
while($rs = mysql_fetch_assoc($result_search)){
$bg = ($n%2)?'#F1F1F1':'FFFFFF';$n++;
?>
<tr bgcolor="<?=$bg?>">
<td align="center"><?=$n?></td>
<td align="left"><?=$rs[subject]?></td>
<td align="left"><?=$rs[main]?></td>
<td align="left"><?=$rs[noorder]?></td>
<td align="left"><?=$rs[detail]?></td>
<td align="center"><?
$arr_t = explode("-",$rs[date_create]);
if($arr_t[0] != "0000"){
echo intval($arr_t[2]) ." ".$smonth[intval($arr_t[1])]." ". $arr_t[0];
}
?>
</td>
<td align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<?
$strSQL_attach = "SELECT * FROM tbl_attach_file WHERE id_attach_file='".$rs[id_sub]."' AND status_file='Y'";
$Result_attach = mysql_query($strSQL_attach);
while($Rs_a = mysql_fetch_object($Result_attach)){
?>
<tr>
<td align="left">
<?
$comment=($Rs_a->comment =="")?$Rs_a->attach_file :$Rs_a->comment ;
echo "<a href='attach_file/$Rs_a->attach_file' target='_blank'><img src='images/attach.gif' border='0' alt='คลิกเพื่อแสดงไฟล์แนบ'>$comment</a>";?> </td>
</tr>
<?
}
?>
</table>
</td>
<td align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<?
$strSQL_url1 = "SELECT * FROM tbl_url WHERE id_sub='".$rs_s[id_sub]."'";
$Result_url1 = mysql_query($strSQL_url1);
while($Rsu1 = mysql_fetch_object($Result_url1)){
?>
<tr>
<td align="left"><a href="<?=$Rsu1->url?>" target="_blank"><?=$Rsu1->url_name?></a></td>
</tr>
<?
}
?>
</table>
</td>
</tr>
<?
}// end while (){
?>
</table></td>
</tr>
</table>
<?
}else{
if($_SERVER[REQUEST_METHOD] == "POST"){
echo " <center> <b>- ไม่พบรายการที่ค้นหา - </b></center>";
}
}// end if($num1 > 0){
?>