DAT001.php
3.82 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
<?php
//*****************************************************************************
//*
//* プログラム名：資料集
//* プログラムID：DAT001.php
//* 機能 ：閲覧
//* 作成者 ：E.Ishida
//*
//*****************************************************************************
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');
$strDBinc="include/dbcon.inc";
include($strDBinc);
include("inc/header.inc");
include("inc/DAT001.inc");
//**** メニュー ****//
include("menu_opacity.php");
//**** ＤＢ接続 ****//
$strDBinc="include/dbcon.inc";
include($strDBinc);
$strTempPath="temp/".$PHP_FOLDER_NAME."/siryou/";
$strSQL="";
$objRecSet="null";
$strSQLData="";
$objRecData="null";
$rowcnt=0;
//自分の所属を取得
$strSQL_s = "SELECT syozoku_cd ".
"FROM syozoku_tbl " .
"WHERE syain_cd ='$PHP_SYAIN_CD' ";
$objRec_s = pg_exec($strSQL_s);
if($objRec_s==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
for ($intSyozoku=0; $intSyozoku < pg_numrows($objRec_s); $intSyozoku++){
$objSyozoku = pg_fetch_object($objRec_s, $intSyozoku);
if ($intSyozoku==0){
$strJoken= " and (send_bumon =0 or send_bumon = " .$objSyozoku->syozoku_cd ;
}else{
$strJoken=$strJoken. " or send_bumon=".$objSyozoku->syozoku_cd ;
}
}
if (pg_numrows($objRec_s) > 0){
$strJoken=$strJoken. ") ";
}else{
$strJoken= " and (send_bumon =0)";
}
//資料集情報取得
$strSQLData="Select * From mst_siryo,siryo_tbl " .
"Where mst_siryo.ctg_no=siryo_tbl.ctg_no " .$strJoken.
" Order by mst_siryo.disp_rank,siryo_tbl.up_date DESC,siryo_tbl.up_time DESC";
$rsResult = pg_exec($pg_con,$strSQLData);
if($rsResult==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$strCtgNoWk="";
for ($inti=0 ; $inti<pg_numrows($rsResult) ; $inti++) {
$filename[$inti]=pg_result($rsResult,$inti,"filename");
$filename_jp[$inti]=pg_result($rsResult,$inti,"filename_jp");
$strFileNm[$inti]=LINE_BR($filename_jp,34);
$comment[$inti]=LINE_BR(pg_result($rsResult,$inti,"comment"),36);
$strSql2 = "SELECT name_kj_sei,name_kj_mei FROM syain_tbl ".
"WHERE syain_cd = '".pg_result($rsResult,$inti,"syain_cd")."'";
$rsResult2 = pg_exec($pg_con,$strSql2);
$syainname[$inti]=pg_result($rsResult2,0,"name_kj_sei")." ".pg_result($rsResult2,0,"name_kj_mei");
$ctg_No_wk = pg_result($rsResult,$inti,"ctg_no");
$ctg_name[$inti] = pg_result($rsResult,$inti,"ctg_name");
$send_bumon= pg_result($rsResult,$inti,"send_bumon");
$up_date[$inti] = pg_result($rsResult,$inti,"up_date");
$up_time[$inti] = pg_result($rsResult,$inti,"up_time");
$seq[$inti] = pg_result($rsResult,$inti,"seq");
//送信者の部門名取得
if ($send_bumon==0){
$strSendBumon="全部門";
}else{
$strSendSql="SELECT bumon_name ".
"FROM mst_bumon " .
"WHERE syozoku_cd =$send_bumon" ;
//echo $strSendSql;
$objSend = pg_exec($strSendSql);
if($objSend==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$objSendBumon = pg_fetch_object($objSend, 0);
$strSendBumon=$objSendBumon->bumon_name;
}
if ($strCtgNoWk != $ctg_No_wk) {
$strSqlCnt="Select siryo_tbl.seq From siryo_tbl Where mst_siryo.ctg_no=siryo_tbl.ctg_no and siryo_tbl.ctg_no= ".$ctg_No_wk .$strJoken;
$objSqlCnt = pg_exec($strSqlCnt);
$objCtgCnt[$inti] = pg_numrows($objSqlCnt);
}else{
}
$strCtgNoWk = $ctg_No_wk;
}
$o_smarty->assign('objCtgCnt',$objCtgCnt);
$o_smarty->assign('ctg_name',$ctg_name);
$o_smarty->assign('filename_jp',$filename_jp);
$o_smarty->assign('filename',$filename);
$o_smarty->assign('up_date',$up_date);
$o_smarty->assign('up_time',$up_time);
$o_smarty->assign('comment',$comment);
$o_smarty->assign('seq',$seq);
$o_smarty->assign('strTempPath',$strTempPath);
$o_smarty->display('DAT001.tpl');
?>