SIM0820.php
4.88 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
<?PHP
//*****************************************************************************
//* プログラム名：ユーザ小区分画面
//* プログラムID：SIM0820.php
//* 機能 ：ユーザ小区分画面
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("./inc/session_start.inc");
include("./inc/SessionChk.inc");
include("./inc/dbcon.inc");
include('./inc/smarty.conf');
include("./inc/const.inc");
include("./inc/pagetitle.inc");
include("./inc/pagefooter.inc");
//部門取得
$bumon = $PHP_BUMON_SEQ;
$strSQL = "select * from bunrui_tbl order by disp_rank";
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
for ($intCnt = 0; $intCnt < pg_numrows($objRec); $intCnt++) {
$objData = pg_fetch_object($objRec, $intCnt);
$bSeq[$intCnt] = $objData->bunrui_seq;
$bName[$intCnt] = $objData->bunrui_name;
// $strSqlD = "select * from koumoku_tbl where koumoku_mode = 1 and koumoku_parent = ".$bSeq[$intCnt]." order by disp_rank";
$strSqlD = "SELECT distinct kt.koumoku_seq AS kt_seq, kt.koumoku_name AS kt_name, ";
$strSqlD .= "kt.koumoku_parent AS kt_parent, kt.koumoku_mode AS kt_mode ";
$strSqlD .= "FROM bunrui_tbl AS bt INNER JOIN koumoku_tbl AS kt ON (bt.bunrui_seq = kt.koumoku_parent) ";
$strSqlD .= "INNER JOIN koumoku_tbl AS kt2 ON (kt.koumoku_seq = kt2.koumoku_parent) ";
$strSqlD .= "INNER JOIN kengen_tbl AS ken ON (ken.koumoku_seq = kt2.koumoku_seq) ";
$strSqlD .= "WHERE kt.koumoku_mode = 1 AND kt2.koumoku_mode = 2 AND ken.bumon_seq = ".$bumon." " ;
// $strSqlD .= "ORDER BY bt.disp_rank, kt.disp_rank, kt2.disp_rank";
$objRecD = pg_exec($strSqlD);
if($objRecD==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
for ($j = 0; $j < pg_numrows($objRecD); $j++) {
$objDataD = pg_fetch_object($objRecD, $j);
$kSeq[$intCnt][$j] = $objDataD->kt_seq;
$kMode[$intCnt][$j] = $objDataD->kt_mode;
$kParent[$intCnt][$j] = $objDataD->kt_parent;
$kName[$intCnt][$j] = $objDataD->kt_name;
// $strSqlC = "select * from koumoku_tbl where koumoku_mode = 2 and koumoku_parent = ".$kSeq[$intCnt][$j]." ORDER BY disp_rank";
$strSqlC = "SELECT kt2.koumoku_seq AS kt2_seq, kt2.koumoku_name AS kt2_name, ";
$strSqlC .= "kt2.koumoku_parent AS kt2_parent, kt2.koumoku_mode AS kt2_mode, kt2.shouhizei_flg AS kt2_flg ";
$strSqlC .= "FROM koumoku_tbl AS kt ";
$strSqlC .= "INNER JOIN koumoku_tbl AS kt2 ON (kt.koumoku_seq = kt2.koumoku_parent) ";
$strSqlC .= "INNER JOIN kengen_tbl AS ken ON (ken.koumoku_seq = kt2.koumoku_seq) ";
$strSqlC .= "WHERE kt.koumoku_mode = 1 AND kt2.koumoku_mode = 2 AND kt2.koumoku_parent = ".$kSeq[$intCnt][$j]." AND ken.bumon_seq = ".$bumon." " ;
$strSqlC .= "ORDER BY kt.disp_rank, kt2.disp_rank";
//echo($strSqlC."<BR>");
$objRecC = pg_exec($strSqlC);
if($objRecC==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
for ($k = 0; $k < pg_numrows($objRecC); $k++) {
$objDataC = pg_fetch_object($objRecC, $k);
$cSeq[$intCnt][$j][$k] = $objDataC->kt2_seq;
$cMode[$intCnt][$j][$k] = $objDataC->kt2_mode;
$cParent[$intCnt][$j][$k] = $objDataC->kt2_parent;
$cName[$intCnt][$j][$k] = $objDataC->kt2_name;
$cZeiflg[$intCnt][$j][$k] = $objDataC->kt2_flg;
}
}
}
//HTMLヘッダの書き出し
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; cahrset=euc-jp">
<meta http-equiv="content-style-type" content="text/css">
<meta name="robots" content="noindex, nofollow">
<script type="text/javascript" src="./js/SIM0820.js"></script>
<title><?PHP echo($PHP_SYSNAME); ?></title>
<link rel="stylesheet" href="./templates/SIMmain.css" type="text/css" />
</head>
<?PHP
//タイトル部分の表示
dspTitle($PHP_SYSNAME, $PHP_GROUP_NAME, $PHP_BUMON_NAME, $PHP_USER_NAME, "0820");
//メインHTML部分の表示
//[0]システムURL、[1]HP URL、[2]マニュアルURL、[3]MTC HP URL、[4]マスタメールアドレス、
//[5]期間区分名、[6]大区分名、[7]小区分名、[8]支出名、[9]収入名、[10]消費税率（文字型）
$o_smarty->assign('DEFARR',$DEFARR);
$o_smarty->assign('PHP_SYSNAME',$PHP_SYSNAME);
$o_smarty->assign('PHP_GROUP_NAME',$PHP_GROUP_NAME);
$o_smarty->assign('PHP_BUMON_NAME',$PHP_BUMON_NAME);
$o_smarty->assign('PHP_USER_NAME',$PHP_USER_NAME);
$o_smarty->assign('PHP_USER_ADMIN',$PHP_USER_ADMIN);
$o_smarty->assign('PHP_USER_NYUKIN',$PHP_USER_NYUKIN);
$o_smarty->assign('PHP_USER_SHIKIN',$PHP_USER_SHIKIN);
$o_smarty->assign('bName',$bName);
$o_smarty->assign('bSeq',$bSeq);
$o_smarty->assign('kSeq',$kSeq);
$o_smarty->assign('kMode',$kMode);
$o_smarty->assign('kParent',$kParent);
$o_smarty->assign('kName',$kName);
$o_smarty->assign('cSeq',$cSeq);
$o_smarty->assign('cMode',$cMode);
$o_smarty->assign('cParent',$cParent);
$o_smarty->assign('cName',$cName);
$o_smarty->assign('cZeiflg',$cZeiflg);
$o_smarty->display('SIM0820.tpl');
//フッタ部分の表示
dspFooter($DEFARR[1], $DEFARR[3]);
?>