MIL026.php
2.88 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
//*****************************************************************************
//*
//* プログラム名：Webメール
//* プログラムID：MIL026.php
//* 機能 ：削除処理(1件)
//* 作成者 ：
//*
//*****************************************************************************
header('Content-Type: text/html; charset=EUC-JP');
include("./include/session_start.inc");
include("./include/SessionChk.inc");
include("./include/STRING.inc");
include('./include/dbcon.inc');
$strTempPath="temp/".$PHP_FOLDER_NAME."/mail/";
if ($_POST["view_uid"]!=""){
//添付ファイル名取得
$strSQLtemp = "SELECT ";
$strSQLtemp .= " * ";
$strSQLtemp .= "FROM ";
$strSQLtemp .= " mail_temp_tbl ";
$strSQLtemp .= "WHERE ";
$strSQLtemp .= " syain_cd = '".$_SESSION["PHP_SYAIN_CD"]."' AND ";
$strSQLtemp .= " mail_id = '".addslashes(subRetURI($_POST["view_uid"]))."'";
//echo $strSQLtemp."<hr />";
$objRectemp = pg_exec($strSQLtemp);
if($objRectemp==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
for ($inttmpCnt=0; $inttmpCnt < pg_numrows($objRectemp); $inttmpCnt++){
$objTemp = pg_fetch_object($objRectemp, $inttmpCnt);
$del_file=$_SESSION["PHP_SYAIN_CD"]."-".$objTemp->temp_index."-".$objTemp->mail_id;
//echo $del_file."<hr />";
if(file_exists($strTempPath.$del_file)){
unlink($strTempPath.$del_file);
}
}
//添付メールテーブル削除
$strSQLtmpdel = "DELETE ";
$strSQLtmpdel .= "FROM ";
$strSQLtmpdel .= " mail_temp_tbl ";
$strSQLtmpdel .= "WHERE ";
$strSQLtmpdel .= " syain_cd = '".$_SESSION["PHP_SYAIN_CD"]."' AND ";
$strSQLtmpdel .= " mail_id = '".addslashes(subRetURI($_POST["view_uid"]))."'";
//echo $strSQLtmpdel."<hr />";
$objRectmpdel = pg_exec($strSQLtmpdel);
if($objRectmpdel==false){
echo("SQL実行に失敗しました(delete)");
exit;
}
$strSQLdel = "UPDATE ";
$strSQLdel .= " mail_get_tbl ";
$strSQLdel .= "SET ";
$strSQLdel .= " del_flg = 1, ";
$strSQLdel .= " header = '', ";
$strSQLdel .= " subject = '', ";
$strSQLdel .= " comment = '', ";
$strSQLdel .= " mail_size = '0' ";
$strSQLdel .= "WHERE ";
$strSQLdel .= " syain_cd = '".$_SESSION["PHP_SYAIN_CD"]."' AND ";
$strSQLdel .= " mail_id = '".addslashes(subRetURI($_POST["view_uid"]))."'";
//echo $strSQLdel."<hr />";
$objRecdel = pg_exec($strSQLdel);
if($objRecdel==false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
}
header("Location:MIL020.php");
function subRetURI($prmStr){
$prmStr = str_replace("EgruProPlus", "+", $prmStr);
$prmStr = str_replace("EgruProAnp", "&", $prmStr);
$prmStr = str_replace("EgruProPer", "%", $prmStr);
$prmStr = str_replace("EgruProNum", "#", $prmStr);
$prmStr = str_replace("EgruProSing", "'", $prmStr);
$prmStr = str_replace("EgruProDoub", '"', $prmStr);
$prmStr = str_replace("EgruProDoll", "$", $prmStr);
$prmStr = str_replace("EgruProhyph", "-", $prmStr);
return $prmStr;
}
?>