MET961.php
4.06 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
<?php
//*****************************************************************************
//*
//* プログラム名：電子会議室
//* プログラムID：MET961.php
//* 機能 ：電子会議室.議事録更新
//* 作成者 ：
//*
//*****************************************************************************
include("include/session_start.inc");
include("include/SessionChk.inc");
$strDBinc="include/dbcon.inc";
include($strDBinc);
$strSQL = "update kaigi_info_tbl set minutes = '".addslashes($txtMinutes)."' where meeting_no = ".$mtgNo;
$recData=pg_exec($strSQL);
if($recData==false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
if($mode==1){
//保存
$strURL="MET030.php";
}else{
//回覧
$strSQL = "select theme, measure, meeting_rule, etc,date_start, date_end, chairperson, minutes_maker, minutes, list_spk, list_obs, ";
$strSQL .= "file_name, file_name_jp, notice_flg, opener, mst_kaigi_category.category_name ";
$strSQL .= "from kaigi_info_tbl join mst_kaigi_category on mst_kaigi_category.category_no = kaigi_info_tbl.category_no ";
$strSQL .= "where meeting_no = ".$mtgNo;
$recData=pg_exec($strSQL);
if($recData==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$ftcData = pg_fetch_object($recData,0);
//テーマ・議題・ルール・特記事項・議長フラグ
$strTheme = $ftcData->theme;
$strMeasure = $ftcData->measure;
$strMeeting_rule = $ftcData->meeting_rule;
$strEtc = $ftcData->etc;
//カテゴリ名
$strCTGName = $ftcData->category_name;
//期間
$strDate_start = $ftcData->date_start;
$strDate_end = $ftcData->date_end;
$strDate = (int) substr($strDate_start,0,4);
$strDate .= "年";
$strDate .= (int) substr($strDate_start,4,2);
$strDate .= "月";
$strDate .= (int) substr($strDate_start,6,2);
$strDate .= "日";
$strDate .= (int) substr($strDate_start,8,2);
$strDate .= "時 〜 ";
$strDate .= (int) substr($strDate_end,0,4);
$strDate .= "年";
$strDate .= (int) substr($strDate_end,4,2);
$strDate .= "月";
$strDate .= (int) substr($strDate_end,6,2);
$strDate .= "日";
$strDate .= (int) substr($strDate_end,8,2);
$strDate .= "時";
//発言者
$strSpeaker = $ftcData->list_spk;
//オブザーバ
$strObserver = $ftcData->list_obs;
//議事録
$strMinutes = $ftcData->minutes;
$strSQL = "select name_kj_sei, name_kj_mei from syain_tbl where syain_cd = '".($ftcData->chairperson)."'";
$recData2=pg_exec($strSQL);
if($recData2==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$ftcData2 = pg_fetch_object($recData2,0);
//議長名
$strChairP = ($ftcData2->name_kj_sei).($ftcData2->name_kj_mei);
$strSQL = "select name_kj_sei, name_kj_mei from syain_tbl where syain_cd = '".($ftcData->minutes_maker)."'";
$recData2=pg_exec($strSQL);
if($recData2==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$ftcData2 = pg_fetch_object($recData2,0);
//議事録作成者名
$strMinutesMk = ($ftcData2->name_kj_sei).($ftcData2->name_kj_mei);
//遷移先
$strURL="CIR002.php";
}
?>
<script language="javascript">
function DoSubmit(){
document.e_gru.action = "<?php echo $strURL ?>";
document.e_gru.method="POST";
document.e_gru.submit();
return false;
}
</script>
<body onload="DoSubmit()">
<form name = "e_gru" method="post">
<input name='mtgNo' type="hidden" value="<?php echo $mtgNo ?>">
<input name='mode' type="hidden" value="<?php echo $mode ?>">
<input name='txtTheme' type="hidden" value="<?php echo $strTheme ?>">
<input name='txtMeasure' type="hidden" value="<?php echo $strMeasure ?>">
<input name='txtRule' type="hidden" value="<?php echo $strMeeting_rule ?>">
<input name='txtEtc' type="hidden" value="<?php echo $strEtc ?>">
<input name='txtCTGName' type="hidden" value="<?php echo $strCTGName ?>">
<input name='txtTerm' type="hidden" value="<?php echo $strDate ?>">
<input name='txtSpeaker' type="hidden" value="<?php echo $strSpeaker ?>">
<input name='txtObserver' type="hidden" value="<?php echo $strObserver ?>">
<input name='txtMinutes' type="hidden" value="<?php echo $strMinutes ?>">
<input name='txtChairP' type="hidden" value="<?php echo $strChairP ?>">
<input name='txtMinutesMk' type="hidden" value="<?php echo $strMinutesMk ?>">
</form>
</body>