CON004_2.php
3.57 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
<?php
//*****************************************************************************
//*
//* プログラム名：就業形態情報DB設定処理（表示順位）
//* プログラムID：CON003_2
//* 機能 ：就業形態情報をDB設定する
//* 作成者 ：
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
//***************************
//* インクルードファイル
//***************************
include("include/session_start.inc");
include("include/SessionChk.inc");
include("include/dbcon.inc");
//表示順位の最大値、最小値を取得
$strSql = "SELECT MAX(disp_rank) as maxValue,MIN(disp_rank) as minValue FROM mst_syuugyou_type";
$rsResult = pg_exec($pg_con,$strSql);
$intDispRankMaxValue = pg_result($rsResult,0,"maxValue");
$intDispRankMinValue = pg_result($rsResult,0,"minValue");
switch ($_POST["up_down_flg"]) {
case "up":
//選択された就業形態のレコードを抽出
$strSql = "SELECT syuugyou_type,type_name,disp_rank FROM mst_syuugyou_type WHERE syuugyou_type=".$_POST["syuugyou_type"];
$rsResult = pg_exec($pg_con,$strSql);
//最小値の場合処理なし
if (pg_result($rsResult,0,"disp_rank")==$intDispRankMinValue) {
break;
}
//就業形態マスタの全レコード抽出
$strSql = "SELECT syuugyou_type,type_name,disp_rank FROM mst_syuugyou_type 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"); //１つ前レコードの表示順位
$intSyuugyouWork = pg_result($rsResult2,$i,"syuugyou_type");
$strSqlUp = "UPDATE mst_syuugyou_type SET ";
$strSqlUp .= "disp_rank= $intDispWork ";
$strSqlUp .= "WHERE syuugyou_type = $intSyuugyouWork";
$intDispWork = pg_result($rsResult2,$i,"disp_rank");
$intSyuugyouWork = pg_result($rsResult2,$i-1,"syuugyou_type");
$strSqlDown = "UPDATE mst_syuugyou_type SET ";
$strSqlDown .= "disp_rank = $intDispWork ";
$strSqlDown .= "WHERE syuugyou_type = $intSyuugyouWork";
$rsResult = pg_exec($pg_con,$strSqlUp);
$rsResult = pg_exec($pg_con,$strSqlDown);
break;
}
}
break;
case "down":
//選択された就業形態のレコードを抽出
$strSql = "SELECT syuugyou_type,type_name,disp_rank FROM mst_syuugyou_type WHERE syuugyou_type=".$_POST["syuugyou_type"];
$rsResult = pg_exec($pg_con,$strSql);
//最大値の場合処理なし
if (pg_result($rsResult,0,"disp_rank")==$intDispRankMaxValue) {
break;
}
//就業形態マスタの全レコード抽出
$strSql = "SELECT syuugyou_type,type_name,disp_rank FROM mst_syuugyou_type 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"); //１つ後レコードの表示順位
$intSyuugyouWork = pg_result($rsResult2,$i,"syuugyou_type");
$strSqlUp = "UPDATE mst_syuugyou_type SET ";
$strSqlUp .= "disp_rank= $intDispWork ";
$strSqlUp .= "WHERE syuugyou_type = $intSyuugyouWork";
$intDispWork = pg_result($rsResult2,$i,"disp_rank");
$intSyuugyouWork = pg_result($rsResult2,$i+1,"syuugyou_type");
$strSqlDown = "UPDATE mst_syuugyou_type SET ";
$strSqlDown .= "disp_rank = $intDispWork ";
$strSqlDown .= "WHERE syuugyou_type = $intSyuugyouWork";
$rsResult = pg_exec($pg_con,$strSqlUp);
$rsResult = pg_exec($pg_con,$strSqlDown);
break;
}
}
break;
}
header("Location: CON004.php");
?>