DAT002.php
2.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
<?php
//*****************************************************************************
//*
//* プログラム名：資料集
//* プログラムID：DAT002.php
//* 機能 ：更新画面
//* 作成者 ：新谷(MTC)
//*
//*****************************************************************************
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("include/input_chk.inc");
include("inc/DAT002.inc");
//**** メニュー ****//
include("menu_opacity.php");
//**** ＤＢ接続 ****//
$strDBinc="include/dbcon.inc";
include($strDBinc);
$strSql = "SELECT * FROM siryo_tbl";
$rsRecset = pg_exec($pg_con,$strSql);
$intRsCnt = pg_numrows($rsRecset);
if ($intRsCnt!=0) {
for ($i = 0 ; $i <= $intRsCnt-1 ; $i++) {
$strChkSTR=$strChkSTR.pg_result($rsRecset,$i,"filename");
}
}
//部門情報取得
$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;
}
//資料集情報取得
$strSQLData="Select * From mst_siryo order by disp_rank";
$rsResult = pg_exec($pg_con,$strSQLData);
if($rsResult==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
for ($intCnt = 0; $intCnt < pg_numrows($rsResult); $intCnt++) {
$folder_no = pg_result($rsResult,$intCnt,"ctg_no");
$folder_name = pg_result($rsResult,$intCnt,"ctg_name");
$folder .= '<OPTION value="'.$folder_no.'">'.$folder_name.'</OPTION>';
}
$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);
$o_smarty->assign('comment',$comment);
$o_smarty->assign('seq',$seq);
$o_smarty->assign('strTempPath',$strTempPath);
$o_smarty->assign('strChkSTR',$strChkSTR);
$o_smarty->assign('folder',$folder);
$o_smarty->display('DAT002.tpl');
?>