RPT092.php
3.45 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
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
<?php
//*****************************************************************************
//*
//* プログラム名：営業日報
//* プログラムID：RPT092.php
//* 機能 ：コメント登録
//* 作成者 ：
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
//***************************
//* インクルードファイル
//***************************
include("include/session_start.inc");
include("include/SessionChk.inc");
include("./include/dbcon.inc"); //ＤＢ接続
include("inc/subRepURI.inc");
$strSQL="";
//番号設定
$strSQL="select comm_seq from eigyo_comm_tbl where seq = ".$com_seq." order by comm_seq DESC";
$recObj=pg_exec($strSQL);
if($recObj==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if (pg_numrows($recObj) > 0){
$objNo = pg_fetch_object($recObj, 0);
$intNo=($objNo->comm_seq) +1;
}else{
$intNo=1;
}
//コメント新規作成
$strSQL = "insert into eigyo_comm_tbl (seq, comm_seq, syain_cd, comment, comm_date) ";
$strSQL .= "values(".$com_seq.", ".$intNo.", '".$PHP_SYAIN_CD."', '".addslashes($com_area)."', '".date("YmdHi")."')";
$recObj=pg_exec($strSQL);
if($recObj==false){
echo("SQL実行に失敗しました(INSERT)");
exit;
}
//営業報告元データアップデート時間更新
$strSQLUp = "UPDATE eigyo_memo_tbl SET " ;
$strSQLUp .= "update = '".date("YmdHis")."' ";
$strSQLUp .= "WHERE seq = ".$com_seq;
$objRecUp = pg_exec($strSQLUp);
if($objRecUp==false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
//*** ファイルアップロード ***//
$strTempPath="./temp/".$PHP_FOLDER_NAME."/RPT/";
if ($_FILES["upComFile".$com_seq]["name"] !=""){
$upfile_name = $com_seq."-".$intNo."-1";
$upfile_name_jp = $_FILES["upComFile".$com_seq]["name"];
$UpLoad_File = $strTempPath.$upfile_name;
move_uploaded_file($_FILES["upComFile".$com_seq]["tmp_name"] , $UpLoad_File);
$strSQL = "INSERT INTO common_file_tbl ";
$strSQL .= " (";
$strSQL .= " type, ";
$strSQL .= " seq1, ";
$strSQL .= " seq2, ";
$strSQL .= " seq3, ";
$strSQL .= " seq4, ";
$strSQL .= " seq5, ";
$strSQL .= " file_seq, ";
$strSQL .= " file_name, ";
$strSQL .= " file_name_org, ";
$strSQL .= " file_comm, ";
$strSQL .= " file_yobi1, ";
$strSQL .= " file_yobi2, ";
$strSQL .= " file_yobi3 ";
$strSQL .= " )";
$strSQL .= " VALUES(";
$strSQL .= " 'RPT', ";
$strSQL .= " ".$com_seq.", ";
$strSQL .= " ".$intNo.", ";
$strSQL .= " 0, ";
$strSQL .= " 0, ";
$strSQL .= " 0, ";
$strSQL .= " 1, ";
$strSQL .= " '".$upfile_name."', ";
$strSQL .= " '".$upfile_name_jp."', ";
$strSQL .= " '', ";
$strSQL .= " '', ";
$strSQL .= " '', ";
$strSQL .= " '' ";
$strSQL .= " )";
$objRec = pg_exec($strSQL);
if($objRec == false){
echo("SQL実行に失敗しました(INSERT)");
exit;
}
}
//未読復活
$strSQL = "UPDATE peigyou_tbl SET read_flg=0 WHERE seq = ".$com_seq;
$recObj=pg_exec($strSQL);
if($recObj==false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
?>
<!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></TITLE>
<SCRIPT LANGUAGE="JAVASCRIPT">
<!--
function load_screen(){
document.e_gru.action = "RPT001.php";
document.e_gru.method="POST";
document.e_gru.submit();
return false;
}
-->
</SCRIPT>
</HEAD>
<BODY onLoad="return load_screen();">
<form name="e_gru">
</form>
</BODY>
</HTML>