|
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/gov_news2/ |
Upload File : |
<?
session_start();
ob_start();
include("../../config/config.inc.php");
include("../../common/function.php");
$save_dir = "../../upload/govnews/";
function randigit($numchar){
$frchar = array("a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z") ;
$ran_digit ="";
for ($ii = 0 ; $ii < $numchar ; $ii++ ){
$ran_digit .= $frchar[rand(1,26)] ;
}
return $ran_digit ;
} ## END function
// query for intializing...
$sql1 = "SELECT * FROM kpi_detail WHERE id='$cat_id' and sub_id='$sub_id'";
$query1 = mysql_query($sql1) or die(mysql_error());
$nrows = mysql_num_rows($query1);
$rs = mysql_fetch_assoc($query1);
if ($_POST) {
$sql = "INSERT INTO kpi_detail(id,title,detail) VALUES ('$cat_id','$title','$detail')";
$sdetail ="detail".$sub_id;
if ($nrows) { if ($sub_id) { $sql = "UPDATE kpi_detail SET title='$title',detail='".$_POST[$sdetail]."' WHERE id='$cat_id' AND sub_id='$sub_id'"; } }
// count for file upload
for($i=0;$i<count($file1);$i++){
if (!empty($file1[$i])){
#----------------------------------------------------------------------------------- find file extension
$today = date("ymd");
$arrfileext = explode("." , $file1_name[$i]) ;
$nmcount = count($arrfileext) -1;
$file1ext = $arrfileext[$nmcount];
$server_filename = $today.randigit(5).".".$file1ext;
$save_path = "../../upload/govnews/". $server_filename;
if (!( is_dir($save_dir) )){ Rmkdir($save_dir); } ######## สร้าง folder ตามบัตรประชาชน ในกรณีที่ยังไม่มีไม่มี
if (copy( $file1[$i] , $save_path )){
if(PHP_OS=='Linux'){ chmod("$path/".$save_dir, 0777); }
if (!$sub_id) { $q = mysql_query("show table status from $dbname like 'kpi_detail'") or die(mysql_error()); $sub_id = mysql_result($q, 0, 'Auto_increment'); }
$sqlins = " INSERT INTO kpi_detail_file ( `id`,`sub_id`,`filename`,`detail`) VALUES ('$cat_id','$sub_id','$server_filename','$subject_text[$i]')";
$result = mysql_db_query($dbname , $sqlins) ;
if (mysql_errno() != 0){ echo "<hr> Line".__LINE__. " ข้อความระบบ :: ".mysql_error() ."<br><br> "; }
}else{
print "<br><br><center> " . filesize($file1) . "ไม่สามารถอัฟโหลดไฟล์ได้ เนื่องจากไม่มีการเลือกไฟล์ <br><br>";
print "";
print "<center> <a href='#' onclick='history.go(-1)'>ย้อนกลับ</a> <center><HR>";
print("Local File: $file1 <BR>\n");
print("Name: $file1_name <BR>\n");
print("Size: $file1_size <BR>\n");
print("Type: $file1_type <BR>\n");
print("<HR>");
} ######## if ($file1[$i] != ""){
}// end for($i=0;$i<count($file1);$i++){
$query = mysql_query($sql) or die(mysql_error());
echo "<center>บันทึกข้อมูลแล้ว</center>";
echo "<META HTTP-EQUIV='Refresh' CONTENT='1;URL=$PHP_SELF?cat_id=$cat_id&sub_id=$sub_id'>";
exit();
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>พรบ. ข้อมูลข่าวสาร</title>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<link href="../../common/style.css" type="text/css" rel="stylesheet">
<style type="text/css">
<!--
body {
margin-left: 4px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
-->
</style>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="../../common/fckeditor/fckeditor.js"></script>
<script type="text/javascript">
function funcClone() {
$("#newNode").slideDown();
$("#clickTable").toggle();
}
</script>
<script type="text/javascript"><!--
var gFiles = 0;
function addFile() {
var subS = "แหล่งเงิน";
var budgetS = "จำนวนเงิน";
var li = document.createElement('li');
li.setAttribute('id', 'file-' + gFiles);
li.innerHTML = 'ชื่อไฟล์ : <input type="file" name="file1[]" size="30"><br/>รายละเอียด : <input type="text" name="subject_text[]" size="27"><span onclick="removeFile(\'file-' + gFiles + '\')" style="cursor:pointer;"> <img src=../../images/profile_expanded.gif border=0></span>';
document.getElementById('files-root').appendChild(li);
gFiles++;
}
function removeFile(aId){
var obj = document.getElementById(aId);
obj.parentNode.removeChild(obj);
}
-->
</script>
</head>
<body bgcolor="#A3B2CC">
<? /* if($nrows) { while($rs = mysql_fetch_assoc($query1)) { /* start while */ ?>
<br>
<? if (($act=="add")||($act=="edit")) { ?>
<form action="<?=$PHP_SELF;?>?cat_id=<?=$cat_id;?>&sub_id=<?=$rs[sub_id];?>" method="post" enctype="multipart/form-data" name="form<?=$cat_id;?><?=$rs[sub_id];?>">
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#000000">
<tr>
<td><table width="100%" border="0" align="center" cellpadding="2" cellspacing="1">
<tr>
<th colspan="2" align="left" bgcolor="#AEBCD2">รายละเอียด</th>
</tr>
<tr>
<td width="20%" align="right" valign="top" bgcolor="#F3F5F8">หัวข้อ : </td>
<td width="80%" align="center" valign="top" bgcolor="#F3F5F8">
<input name="title" type="text" id="title" style="width:98%;" value="<?=$rs[title];?>"> </td>
</tr>
<tr>
<td align="right" valign="top" bgcolor="#F3F5F8">รายละเอียด : </td>
<td valign="top" bgcolor="#F3F5F8">
<script type="text/javascript">
var sBasePath = '../../common/fckeditor/';
var oFCKeditor<?=$rs[sub_id];?> = new FCKeditor( 'detail<?=$rs[sub_id];?>' ) ;
oFCKeditor<?=$rs[sub_id];?>.BasePath = sBasePath ;
oFCKeditor<?=$rs[sub_id];?>.ToolbarSet = 'Basic' ;
oFCKeditor<?=$rs[sub_id];?>.Value = '<?=eregi_replace("\n","",eregi_replace(chr(13),"",$rs[detail]));?>' ;
oFCKeditor<?=$rs[sub_id];?>.Create();
</script> </td>
</tr>
<tr>
<td align="right" valign="top" bgcolor="#F3F5F8">ไฟล์แนบ : </td>
<td align="left" valign="top" bgcolor="#F3F5F8">
<?
$sqlxxx = "SELECT * FROM kpi_detail_file WHERE id='$cat_id' AND sub_id='$sub_id' ORDER BY main_id ASC";
$queryxxx = mysql_query($sqlxxx);
$nrowsxxx = mysql_num_rows($queryxxx);
while($rsxxx = mysql_fetch_assoc($queryxxx)) {
?> <?=$rsxxx[detail]?><font color="#999999">(<?=$rsxxx[filename];?>)</font> <a href="#"><img src="../../images/del.png" border="0" /></a><br/><?
}
?>
<br/>
<span style="cursor:pointer;" onClick="addFile()">เพิ่มไฟล์ <img src="../../images/profile_collapsed.gif" border="0"></span>
<ul id="files-root">
<li>ชื่อไฟล์ : <input type="file" name="file1[]" size="30"><br/>รายละเอียด : <input type="text" name="subject_text[]" size="27"></li>
<?
/* if(($action == "edit")){
$strSQL_e = "SELECT * FROM sml_budget WHERE epm_id='$epm_id' and type_budget='5' ";
$Result_e = mysql_query($strSQL_e);
$nn=0;
while($Rse = mysql_fetch_assoc($Result_e)){
echo "<li id='file-".$nn."'>
<input type=\"text\" name=\"subject_sEdit[$nn]\" size=\"50\" value='$Rse[text_budget]'> จำนวนเงิน<input name=\"budget_sEdit[]\" type=\"text\" size=\"10\" value='$Rse[budget_list]'> <span onclick=\"removeFile('file-".$nn."')\" style=\"cursor:hand;\"><img src=../images/profile_expanded.gif border=0></span><br>";
echo "<input type='hidden' name='runid_e[$nn]' value='$Rse[runid]'></li>";
$nn++;
}
}*/
?>
</ul>
</td>
</tr>
<tr>
<td colspan="2" align="center" valign="top" bgcolor="#F3F5F8">
<input name="Submit2" type="submit" class="epm_button" value="จัดเก็บข้อมูล">
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<br/>
<? } else { ?>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#000000" id="clickTable">
<tr>
<td align="left" valign="middle"><table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" id="clickTable">
<tr>
<td width="80%" align="left" valign="middle" bgcolor="#AEBCD2"> </td>
<td width="20%" align="left" valign="middle" bgcolor="#AEBCD2"><a href="<?=$PHP_SELF;?>?act=add&cat_id=<?=$cat_id;?>"><img src="../../images_sys/nolines_plus.gif" alt="+" width="18" height="18" border="0" align="middle">เพิ่มหัวข้อใหม่</a></td>
</tr>
<?
$sql1 = "SELECT * FROM kpi_detail WHERE id='$cat_id'";
$query1 = mysql_query($sql1) or die(mysql_error());
while($rs = mysql_fetch_assoc($query1)) {
?>
<tr>
<td height="8" colspan="2" align="left" valign="middle" bgcolor="#F3F5F8"><?=$rs[title];?>
<a href="<?=$PHP_SELF;?>?act=edit&cat_id=<?=$cat_id;?>&sub_id=<?=$rs[sub_id];?>"><img src="../../images/edit.png" border="0" /></a>
<a href="<?=$PHP_SELF;?>?act=del"><img src="../../images/del.png" border="0" /></a>
</td>
</tr>
<? } ?>
</table></td>
</tr>
</table>
<? } ?>
</body>
</html>