CON142.php
4.94 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
147
148
149
150
151
152
153
154
155
<?php
//*****************************************************************************
//*
//* プログラム名：進捗単位情報DB設定処理（表示順位・削除）
//* プログラムID：CON142
//* 機能 ：進捗単位情報をDB設定する
//* 作成者 ：石田 英治
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("include/session_start.inc");
include("include/SessionChk.inc");
include("include/dbcon.inc");
$bumon = addslashes($bumon);
$intGmflg=0;
$strBumonArray=split("＜///＞",$bumon);
$strSyozokuCode=$strBumonArray[0];
$strBumonName=$strBumonArray[1];
//表示順位の最大値、最小値を取得
$strSql = "SELECT MAX(disp_rank) as maxValue,MIN(disp_rank) as minValue FROM mst_prj_tbl";
$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 unit_seq, progress_unit, disp_rank FROM mst_prj_tbl WHERE unit_seq=$strSyozokuCode";
$rsResult = pg_exec($pg_con,$strSql);
//最小値の場合処理なし
if (pg_result($rsResult,0,"disp_rank")==$intDispRankMinValue) {
break;
}
//部門マスタの全レコード抽出
$strSql = "SELECT unit_seq, progress_unit, disp_rank FROM mst_prj_tbl 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,"unit_seq");
$strSqlUp = "UPDATE mst_prj_tbl SET ";
$strSqlUp .= "disp_rank= $intDispWork ";
$strSqlUp .= "WHERE unit_seq = $intSyozokuWork";
$intDispWork = pg_result($rsResult2,$i,"disp_rank");
$intSyozokuWork = pg_result($rsResult2,$i-1,"unit_seq");
$strSqlDown = "UPDATE mst_prj_tbl SET ";
$strSqlDown .= "disp_rank = $intDispWork ";
$strSqlDown .= "WHERE unit_seq = $intSyozokuWork";
$rsResult = pg_exec($pg_con,$strSqlUp);
$rsResult = pg_exec($pg_con,$strSqlDown);
break;
}
}
break;
case "down":
//選択された部門のレコードを抽出
$strSql = "SELECT unit_seq, progress_unit, disp_rank FROM mst_prj_tbl WHERE unit_seq=$strSyozokuCode";
$rsResult = pg_exec($pg_con,$strSql);
//最大値の場合処理なし
if (pg_result($rsResult,0,"disp_rank")==$intDispRankMaxValue) {
break;
}
//部門マスタの全レコード抽出
$strSql = "SELECT unit_seq, progress_unit, disp_rank FROM mst_prj_tbl 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,"unit_seq");
$strSqlUp = "UPDATE mst_prj_tbl SET ";
$strSqlUp .= "disp_rank= $intDispWork ";
$strSqlUp .= "WHERE unit_seq = $intSyozokuWork";
$intDispWork = pg_result($rsResult2,$i,"disp_rank");
$intSyozokuWork = pg_result($rsResult2,$i+1,"unit_seq");
$strSqlDown = "UPDATE mst_prj_tbl SET ";
$strSqlDown .= "disp_rank = $intDispWork ";
$strSqlDown .= "WHERE unit_seq = $intSyozokuWork";
$rsResult = pg_exec($pg_con,$strSqlUp);
$rsResult = pg_exec($pg_con,$strSqlDown);
break;
}
}
break;
case "dell":
//$strSql = "DELETE FROM mst_bumon WHERE syozoku_cd=$strSyozokuCode";
//$rsResult = pg_exec($pg_con,$strSql);
$strSQL = "SELECT unit_seq ".
" from prj_task_tbl " .
" Where unit_seq=$strSyozokuCode";
//echo $strSQL;
//exit;
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if (pg_numrows($objRecSet) > 0){
$intGmflg=1;
}else{
$strSql = "delete from mst_prj_tbl WHERE unit_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 = "CON144.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="bumon" value="<?php echo $strSyozokuCode ?>">
<?php
}
?>
</form>
</BODY>
</HTML>