SIM0912.php
3 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
<?PHP
//*****************************************************************************
//* プログラム名：分類更新処理
//* プログラムID：SIM0912.php
//* 機能 ：分類更新処理
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("./inc/session_start.inc");
include("./inc/SessionChk.inc");
include("./inc/dbcon.inc");
$mode = $_GET["mode"];
$seq = $_GET["seq"];
$bName = $_POST["bName"];
$bStart = $_POST["bStart"];
$bEnd = $_POST["bEnd"];
if($mode == "add"){
//新規
//seq設定
$strSQL = "select * from bunrui_tbl order by bunrui_seq desc";
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if(pg_numrows($objRec) > 0){
$objData = pg_fetch_object($objRec, 0);
$newSeq = $objData->bunrui_seq + 1;
//disp_rank
$strSQL2 = "select * from bunrui_tbl order by disp_rank desc";
$objRec2 = pg_exec($strSQL2);
if($objRec2==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if(pg_numrows($objRec2) > 0){
$objData2 = pg_fetch_object($objRec2, 0);
$newRank = pg_numrows($objRec2) + 1;
}
}else{
$newSeq = 1;
$newRank = 1;
}
//INSERT
$strSQL = "insert into bunrui_tbl (bunrui_seq, bunrui_name, bunrui_start, bunrui_end, disp_rank) values(".$newSeq.", '".$bName."', ".$bStart.", ".$bEnd.", ".$newRank.")";
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(INSERT)");
exit;
}
}else if($mode == "edt"){
//修正
$strSQL = "update bunrui_tbl set bunrui_name = '".$bName."', bunrui_start = ".$bStart.", bunrui_end = ".$bEnd." where bunrui_seq = ".$seq;
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
}else if($mode == "up" || $mode == "down"){
if($mode == "up"){ //上へ
$addNum = -1;
}else if($mode == "down"){ //下へ
$addNum = 1;
}
//変更対象の表示順取得
$strSQL = "select * from bunrui_tbl ORDER BY disp_rank";
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
//期間を配列に格納
if(pg_numrows($objRec) > 0){
for ($i = 0; $i < pg_numrows($objRec); $i++) {
$objData[$i] = pg_fetch_object($objRec, $i);
$dspSeq[$i] = $objData[$i]->bunrui_seq;
$dspRnk[$i] = $objData[$i]->disp_rank;
if ($dspSeq[$i] == $seq) {
//自分が何番目かを取得
$ownCnt = $i ;
}
}
}
//変更対象の前or後のデータ更新
$strSQL = "update bunrui_tbl set disp_rank = ".$dspRnk[$ownCnt]." where bunrui_seq = ".$dspSeq[$ownCnt+$addNum];
//デバッグ
//echo($strSQL." ".$dspSeq[$ownCnt]." ".$dspSeq[$ownCnt+$addNum]." ".$dspRnk[$ownCnt]." ".$dspRnk[$ownCnt+$addNum]);
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
//変更対象のデータ更新
$strSQL = "update bunrui_tbl set disp_rank = ".$dspRnk[$ownCnt+$addNum]." where bunrui_seq = ".$dspSeq[$ownCnt];
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
}
header("Location:./SIM0910.php");
exit;
?>