CON146.php
4.69 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
145
146
<?php
//*****************************************************************************
//*
//* プログラム名：かてごりDB設定処理（表示順位・削除）
//* プログラムID：CON146
//* 機能 ：かてごりをDB設定する
//* 作成者 ：石田 英治
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("include/session_start.inc");
include("include/SessionChk.inc");
include("include/dbcon.inc");
$intGmflg=0;
$strSyozokuCode=$ctg;
//表示順位の最大値、最小値を取得
$strSql = "SELECT MAX(disp_rank) as maxValue,MIN(disp_rank) as minValue FROM mst_prj_category";
$rsResult = pg_exec($pg_con,$strSql);
$intDispRankMaxValue = pg_result($rsResult,0,"maxValue");
$intDispRankMinValue = pg_result($rsResult,0,"minValue");
switch ($up_down_flg) {
case "up":
//選択された部門のレコードを抽出
$strSql = "SELECT ctg_seq, ctg_name, disp_rank FROM mst_prj_category WHERE ctg_seq=$strSyozokuCode";
$rsResult = pg_exec($pg_con,$strSql);
//最小値の場合処理なし
if (pg_result($rsResult,0,"disp_rank")==$intDispRankMinValue) {
break;
}
//部門マスタの全レコード抽出
$strSql = "SELECT ctg_seq, ctg_name, disp_rank FROM mst_prj_category ORDER BY disp_rank";
$rsResult2 = pg_exec($pg_con,$strSql);
$intRsCnt = pg_numrows($rsResult2);
for ($i = 1 ; $i <= $intRsCnt-1 ; $i++) {
if (pg_result($rsResult,0,"disp_rank") == pg_result($rsResult2,$i,"disp_rank")) {
$intDispWork = pg_result($rsResult2,$i-1,"disp_rank"); //１つ前レコードの表示順位
$intSyozokuWork = pg_result($rsResult2,$i,"ctg_seq");
$strSqlUp = "UPDATE mst_prj_category SET ";
$strSqlUp .= "disp_rank= $intDispWork ";
$strSqlUp .= "WHERE ctg_seq = $intSyozokuWork";
$intDispWork = pg_result($rsResult2,$i,"disp_rank");
$intSyozokuWork = pg_result($rsResult2,$i-1,"ctg_seq");
$strSqlDown = "UPDATE mst_prj_category SET ";
$strSqlDown .= "disp_rank = $intDispWork ";
$strSqlDown .= "WHERE ctg_seq = $intSyozokuWork";
$rsResult = pg_exec($pg_con,$strSqlUp);
$rsResult = pg_exec($pg_con,$strSqlDown);
break;
}
}
break;
case "down":
//選択された部門のレコードを抽出
$strSql = "SELECT ctg_seq, ctg_name, disp_rank FROM mst_prj_category WHERE ctg_seq=$strSyozokuCode";
$rsResult = pg_exec($pg_con,$strSql);
//最大値の場合処理なし
if (pg_result($rsResult,0,"disp_rank")==$intDispRankMaxValue) {
break;
}
//部門マスタの全レコード抽出
$strSql = "SELECT ctg_seq, ctg_name, disp_rank FROM mst_prj_category ORDER BY disp_rank";
$rsResult2 = pg_exec($pg_con,$strSql);
$intRsCnt = pg_numrows($rsResult2);
for ($i = 0 ; $i <= $intRsCnt-2 ; $i++) {
if (pg_result($rsResult,0,"disp_rank") == pg_result($rsResult2,$i,"disp_rank")) {
$intDispWork = pg_result($rsResult2,$i+1,"disp_rank"); //１つ後レコードの表示順位
$intSyozokuWork = pg_result($rsResult2,$i,"ctg_seq");
$strSqlUp = "UPDATE mst_prj_category SET ";
$strSqlUp .= "disp_rank= $intDispWork ";
$strSqlUp .= "WHERE ctg_seq = $intSyozokuWork";
$intDispWork = pg_result($rsResult2,$i,"disp_rank");
$intSyozokuWork = pg_result($rsResult2,$i+1,"ctg_seq");
$strSqlDown = "UPDATE mst_prj_category SET ";
$strSqlDown .= "disp_rank = $intDispWork ";
$strSqlDown .= "WHERE ctg_seq = $intSyozokuWork";
$rsResult = pg_exec($pg_con,$strSqlUp);
$rsResult = pg_exec($pg_con,$strSqlDown);
break;
}
}
break;
case "dell":
$strSQL = "SELECT ctg_seq ".
" from prj_ctg_tbl " .
" Where ctg_seq=$strSyozokuCode";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if (pg_numrows($objRecSet) > 0){
$intGmflg=1;
}else{
$strSql = "delete from mst_prj_category WHERE ctg_seq=$strSyozokuCode";
$rsResult = pg_exec($pg_con,$strSql);
break;
}
}
header("Content-type: text/html; charset=EUC-JP");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=EUC-JP">
<META http-equiv="Content-Style-Type" content="text/css">
<link rel="stylesheet" type="text/css" href="basefont.css">
<TITLE>ｅ-グル 設定</TITLE>
<SCRIPT LANGUAGE="JAVASCRIPT">
<!--
function load_screen(intGmflg){
if (intGmflg==1){
document.e_gru.action = "CON148.php";
}
else{
document.e_gru.action = "CON140.php";
}
document.e_gru.method="POST";
document.e_gru.submit();
}
-->
</SCRIPT>
</HEAD>
<BODY onLoad="return load_screen(<?php echo $intGmflg; ?>);">
<form name="e_gru">
<?php
if ($intGmflg==1){
?>
<input type="hidden" name="strSyozokuCode" value="<?php echo $strSyozokuCode ?>">
<?php
}else{
?>
<input type="hidden" name="ctg" value="<?php echo $strSyozokuCode ?>">
<?php
}
?>
</form>
</BODY>
</HTML>