MDT094.php
2.62 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
<?php
//*****************************************************************************
//*
//* プログラム名：資料集
//* プログラムID：DAT094.php
//* 機能 ：追加
//* 作成者 ：
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("include/session_start.inc");
include("include/SessionChk.inc");
$strDBinc="include/dbcon.inc";
include($strDBinc);
$strTempPath="temp/".$PHP_FOLDER_NAME."/siryou/";
//アップロード
$reg_date=date("Y/m/d");
$reg_time=date("H:i:s");
if ($intFLSeq==0){
$strSql = "SELECT * FROM mysiryo_tbl ORDER BY seq DESC";
$rsRecset = pg_exec($pg_con,$strSql);
$intRsCnt = pg_numrows($rsRecset);
if ($intRsCnt==0) {
$seqNum=1;
}else{
$seqNum=pg_result($rsRecset,0,"seq")+1;
}
}else{
$strSql="SELECT filename FROM mysiryo_tbl WHERE seq = $intFLSeq";
$objRecSet = pg_exec($strSql);
if($objRecSet==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$intRsCnt = pg_numrows($objRecSet);
if ($intRsCnt!=0) {
$objRecData = pg_fetch_object($objRecSet, 0);
$Res = unlink($strTempPath.$objRecData->filename);
}
$strSql = "DELETE FROM mysiryo_tbl WHERE seq = $intFLSeq";
$rsRecset = pg_exec($strSql);
if($objRecSet==false){
echo("SQL実行に失敗しました(delete)");
exit;
}
$seqNum=$intFLSeq;
}
$upfile_name=str_replace(".","/",$upfile_name);
list($strname,$strextension)=split("/",$upfile_name);
$upfile_name="siryo_".$seqNum.".".$strextension;
$file_name_jp=$strname.".".$strextension;
$file = $strTempPath.$upfile_name;
if (@move_uploaded_file($upfile,$file)!=0 ) {
$strSql = "DELETE FROM mysiryo_tbl WHERE filename = '$upfile_name'";
$rsRecset = pg_exec($strSql);
$strSql="INSERT INTO mysiryo_tbl ".
"(seq,folder_seq,filename,filename_jp,syain_cd,up_date,up_time,comment,lock_flg)".
"VALUES($seqNum,$intOya,".
"'$upfile_name','$file_name_jp','$PHP_SYAIN_CD',".
"'$reg_date','$reg_time','".addslashes($comment)."','')";
$varResult = pg_exec($pg_con,$strSql);
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=EUC-JP">
<META http-equiv="Content-Style-Type" content="text/css">
<link rel="stylesheet" type="text/css" href="basefont.css">
<TITLE>ｅ-グル Webメール</TITLE>
<SCRIPT LANGUAGE="JAVASCRIPT">
<!--
function load_screen(){
window.parent.LoadFileList(document.e_gru_F.intOya.value);
return false;
}
-->
</SCRIPT>
</HEAD>
<BODY onLoad="return load_screen();">
<form name="e_gru_F">
<input type="hidden" name="intOya" value="<?php echo $intOya ?>">
</form>
</BODY>
</HTML>