MET002_41.php
2.99 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
<?php
//*****************************************************************************
//*
//* プログラム名：業務報告・指示
//* プログラムID：MET002_41.php
//* 機能 ：発言入力画面
//* 作成者 ：
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
//*****************************************************************************
//* インクルードファイル
//*****************************************************************************
include("include/session_start.inc");
include("include/SessionChk.inc");
include('./include/smarty.conf');
include("./include/dbcon.inc");
//*** 発言者情報取得 ***//
$strSQL = "SELECT ";
$strSQL .= " name_kj_sei, ";
$strSQL .= " name_kj_mei, ";
$strSQL .= " bumon_name ";
$strSQL .= "FROM ";
$strSQL .= " syain_tbl, ";
$strSQL .= " syozoku_tbl, ";
$strSQL .= " mst_bumon ";
$strSQL .= " ";
$strSQL .= "WHERE ";
$strSQL .= " syain_tbl.syain_cd = '$PHP_SYAIN_CD' AND " ;
$strSQL .= " syozoku_tbl.syain_cd = syain_tbl.syain_cd AND ";
$strSQL .= " syozoku_tbl.syozoku_cd = mst_bumon.syozoku_cd ";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$objData = pg_fetch_object($objRecSet, 0);
$name_kj_sei = $objData->name_kj_sei;
$name_kj_mei = $objData->name_kj_mei;
$bumon_name = $objData->bumon_name;
$memo = "";
for($intI=1;$intI<=3;$intI++){
$File_Flg[$intI] = "0";
$File_ID[$intI] = "";
$File_NameOrg[$intI] = "";
$File_NameJp[$intI] = "";
}
if ($seq!=""){
$strSQL = "SELECT * FROM meet_tbl WHERE seq=".$seq;
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$objData = pg_fetch_object($objRec, 0);
$memo = $objData->memo;
//添付ファイル取得
$strSQLF = "SELECT * FROM meet_file_tbl WHERE meet_seq = ".$seq." AND comm_seq = 0 ORDER BY file_seq";
$objRecF = pg_exec($strSQLF);
if($objRecF==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if (pg_numrows($objRecF) > 0){
for($fcnt2=0;$fcnt2<pg_numrows($objRecF);$fcnt2++){
$objF = pg_fetch_object($objRecF, $fcnt2);
$File_Flg[$objF->file_seq] = "1";
$File_ID[$objF->file_seq] = $objF->file_seq;
$File_NameOrg[$objF->file_seq] = $objF->file_org;
$File_Name[$objF->file_seq] = $objF->file_name;
}
}
}
$o_smarty->assign('name_kj_sei' , $name_kj_sei);
$o_smarty->assign('name_kj_mei' , $name_kj_mei);
$o_smarty->assign('bumon_name' , $bumon_name);
$o_smarty->assign('seq' , $seq);
$o_smarty->assign('div_id' , $div_id);
$o_smarty->assign('memo' , $memo);
$o_smarty->assign('File_Flg' , $File_Flg);
$o_smarty->assign('File_ID' , $File_ID);
$o_smarty->assign('File_NameOrg' , $File_NameOrg);
$o_smarty->assign('File_Name' , $File_Name);
$o_smarty->assign('PHP_DISABLED',$PHP_DISABLED);
$o_smarty->assign('PHP_DISABLED_flg',$PHP_DISABLED_flg);
$o_smarty->assign('PHP_E_GRU_CAPA_OVER',$_SESSION["PHP_E_GRU_CAPA_OVER"]);
$o_smarty->display('MET002_4.tpl');
?>