BBS002.php
4.2 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
136
137
138
139
140
141
142
143
144
<?php
//*****************************************************************************
//*
//* プログラム名：掲示板
//* プログラムID：BBS002.php
//* 機能 ：掲示板作成画面
//* 作成者 ：
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
//***************************
//* インクルードファイル
//***************************
include("./include/session_start.inc");
include("./include/SessionChk.inc");
include('./include/smarty.conf');
//***************************
//* 画面制御
//***************************
include('./include/smarty.conf');
include("./include/dbcon.inc"); //ＤＢ接続
$strSQL = "";
$objRecSet = "null";
$strSQLmst = "";
$objRecmst = "null";
//部門情報取得
$strSQLmst = "SELECT syozoku_cd,bumon_name FROM mst_bumon Where del_flg=0 Order by disp_rank";
$objRecmst = pg_exec($strSQLmst);
if($objRecmst==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
//発言者情報取得
$strSQL = "SELECT * FROM syain_tbl,syozoku_tbl,mst_bumon " .
"WHERE syain_tbl.syain_cd='$PHP_SYAIN_CD' and " .
"syozoku_tbl.syain_cd=syain_tbl.syain_cd and " .
"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);
$PhpName_kj_sei = $objData->name_kj_sei;
$PhpName_kj_mei = $objData->name_kj_mei;
for ($intBumon = 0; $intBumon < pg_numrows($objRecSet); $intBumon++) {
$objDatamst = pg_fetch_object($objRecSet, $intBumon);
if ($intBumon == 0){
$strBumonName=$objDatamst->bumon_name;
$strSyozoku_cd="/".$objDatamst->syozoku_cd ."/";
}else{
$strBumonName=$strBumonName.",".$objDatamst->bumon_name;
$strSyozoku_cd=$strSyozoku_cd.$objDatamst->syozoku_cd ."/";
}
}
$objData = pg_fetch_object($objRecSet, 0);
$bumon .='<OPTION value="0">全部門</OPTION>';
for ($intBumon = 0; $intBumon < pg_numrows($objRecmst); $intBumon++) {
$objDatamst = pg_fetch_object($objRecmst, $intBumon);
$bumon .= '<OPTION value="'.$objDatamst->syozoku_cd.'">'.$objDatamst->bumon_name.'</OPTION>';
}
$o_smarty->assign('bumon',$bumon);
//期限
//年
$kigen_y = "<OPTION value='' selected>----年</OPTION>";
for ($i=Date("Y");$i<=Date("Y")+2;$i++) {
$kigen_y .= "<OPTION value='".$i."'>".$i."年</OPTION>";
}
//月
$kigen_m = "<OPTION value='' selected>--月</OPTION>";
for ($i=1;$i<=12;$i++) {
$kigen_m .= "<OPTION value='".sprintf('%02d', $i)."'>".$i."月</OPTION>";
}
//日
$kigen_d = "<OPTION value='' selected>--日</OPTION>";
for ($i=1;$i<=31;$i++) {
$kigen_d .= "<OPTION value='".sprintf('%02d', $i)."'>".$i."日</OPTION>";
}
//時
$kigen_h = "<OPTION value='' selected>--時</OPTION>";
for ($i=8;$i<=23;$i++) {
$kigen_h .= "<OPTION value='".sprintf('%02d', $i)."'>".$i."時</OPTION>";
}
for ($i=0;$i<=7;$i++) {
$kigen_h .= "<OPTION value='".sprintf('%02d', $i)."'>".$i."時</OPTION>";
}
//分
$kigen_i = "<OPTION value='' selected>--分</OPTION>";
for ($i=0;$i<=11;$i++) {
$kigen_i .= "<OPTION value='".sprintf('%02d', $i*5)."'>".($i*5)."分</OPTION>";
}
//デフォルト期限
$strSQLmst = "SELECT default_data FROM mst_default_data Where data_no = 2";
$objRecmst = pg_exec($strSQLmst);
if($objRecmst==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$objDatamst = pg_fetch_object($objRecmst, 0);
$intDefault = (int) $objDatamst->default_data;
if($intDefault >= 30){
$strDefault = " ".($intDefault / 30)." ヶ月";
}else{
$strDefault = " ".($intDefault / 7)." 週間";
}
if ($PHP_MODE_FLG==2){
$PHP_DISABLED_flg=" disabled";
}
$o_smarty->assign('strSyozoku_cd',$strSyozoku_cd);
$o_smarty->assign('kigen_y',$kigen_y);
$o_smarty->assign('kigen_m',$kigen_m);
$o_smarty->assign('kigen_d',$kigen_d);
$o_smarty->assign('kigen_h',$kigen_h);
$o_smarty->assign('kigen_i',$kigen_i);
$o_smarty->assign('PhpName_kj_sei',$PhpName_kj_sei);
$o_smarty->assign('PhpName_kj_mei',$PhpName_kj_mei);
$o_smarty->assign('strDefault',$strDefault);
$o_smarty->assign('strDefault',$strDefault);
if ($PHP_MODE_FLG==2){
$PHP_DISABLED_flg=" disabled";
$o_smarty->assign('PHP_DISABLED',$PHP_DISABLED_flg);
}else{
$o_smarty->assign('PHP_DISABLED',$PHP_DISABLED);
}
$o_smarty->assign('PHP_E_GRU_CAPA_OVER' , $_SESSION["PHP_E_GRU_CAPA_OVER"]);
$o_smarty->display('BBS002.tpl');
?>