MET034.php
2.04 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
<?php
//*****************************************************************************
//*
//* プログラム名：電子会議室詳細
//* プログラムID：MET034.php
//* 機能 ：電子会議室詳細画面 発言・返信修正部分
//* 作成者 ：
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("include/session_start.inc");
include("include/SessionChk.inc");
include("include/STRING.inc");
include('./include/smarty.conf');
include("inc/mtc_comfunc.inc");
$strDBinc="include/dbcon.inc";
include($strDBinc);
$strSQL = "select kaigi_tbl.speak, kaigi_tbl.stop_flg, kaigi_info_tbl.date_end, kaigi_info_tbl.date_start from kaigi_tbl join kaigi_info_tbl on kaigi_info_tbl.meeting_no = kaigi_tbl.meeting_no ";
$strSQL .= "where kaigi_tbl.meeting_no = ".$mtgNo." and kaigi_tbl.remark_no = ".$remNo." and kaigi_tbl.answer_no = 0 and kaigi_tbl.cp_answer_no = 0 ";
$recData=pg_exec($strSQL);
if($recData==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$ftcData = pg_fetch_object($recData,0);
if($ftcData->date_start > date("YmdH")){
echo "Err/当会議は開催前となっています";
exit;
}
if($ftcData->date_end <= date("YmdH")){
echo "Err/当会議は既に終了しています";
exit;
}
if($ftcData->stop_flg == "1"){
echo "Err/現在、発言は停止されています";
exit;
}
$strSQL = "select kaigi_tbl.speak, kaigi_tbl.stop_flg, kaigi_info_tbl.date_end from kaigi_tbl join kaigi_info_tbl on kaigi_info_tbl.meeting_no = kaigi_tbl.meeting_no ";
$strSQL .= "where kaigi_tbl.meeting_no = ".$mtgNo." and kaigi_tbl.remark_no = ".$remNo." and kaigi_tbl.answer_no = ".$ansNo." and kaigi_tbl.cp_answer_no = ".$cpansNo." ";
$recData=pg_exec($strSQL);
if($recData==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$ftcData = pg_fetch_object($recData,0);
$strSpeak=mtc_rtrim($ftcData->speak);
$o_smarty->assign('mtgNo',$mtgNo);
$o_smarty->assign('intRemNo',$remNo);
$o_smarty->assign('ansmNo',$ansNo);
$o_smarty->assign('cpansmNo',$cpansNo);
$o_smarty->assign('strSpeak',$strSpeak);
$o_smarty->display('MET034.tpl');
?>