PRJ996.php
3.39 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
<?php
//*****************************************************************************
//*
//* プログラム名：プロジェクト管理
//* プログラムID：PRJ996.php
//* 機能 ：表示順変更
//* 作成者 ：
//*
//*****************************************************************************
header( "Content-type: text/html; charset=EUC-JP");
include("inc/session_start.inc");
include("inc/SessionChk.inc");
$strDBinc="include/dbcon.inc";
include($strDBinc);
if($sseq == 0){
//タスク
$strSQL = "select * from prj_task_tbl where seq = ".$seq." and task_sub_seq = ".$sseq." order by disp_rank";
$objRec = pg_exec($strSQL);
if($objRec == false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if(pg_numrows($objRec) > 1){
for($i=0;$i<pg_numrows($objRec);$i++){
$objftc = pg_fetch_object($objRec, $i);
if($objftc->task_seq == $tseq){
$A_rank = $objftc->disp_rank;
$A_seq = $objftc->seq;
$A_tseq = $objftc->task_seq;
$A_sseq = $objftc->task_sub_seq;
if($mode==0){
if($i > 0){
$objftcB = pg_fetch_object($objRec, $i-1);
}else{
exit;
}
}else if($mode==1){
if($i < (pg_numrows($objRec)-1)){
$objftcB = pg_fetch_object($objRec, $i+1);
}else{
exit;
}
}
$B_rank = $objftcB->disp_rank;
$B_seq = $objftcB->seq;
$B_tseq = $objftcB->task_seq;
$B_sseq = $objftcB->task_sub_seq;
$strSQL = "update prj_task_tbl set disp_rank = ".$B_rank;
$strSQL .= " where seq = ".$A_seq." and task_seq = ".$A_tseq." and task_sub_seq = ".$A_sseq;
$objRecR = pg_exec($strSQL);
if($objRecR == false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
$strSQL = "update prj_task_tbl set disp_rank = ".$A_rank;
$strSQL .= " where seq = ".$B_seq." and task_seq = ".$B_tseq." and task_sub_seq = ".$B_sseq;
$objRecR = pg_exec($strSQL);
if($objRecR == false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
}
}
}
}else{
//サブタスク
$strSQL = "select * from prj_task_tbl where seq = ".$seq." and task_seq = ".$tseq." and task_sub_seq <> 0 order by disp_rank";
$objRec = pg_exec($strSQL);
if($objRec == false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if(pg_numrows($objRec) > 1){
for($i=0;$i<pg_numrows($objRec);$i++){
$objftc = pg_fetch_object($objRec, $i);
if($objftc->task_sub_seq == $sseq){
$A_rank = $objftc->disp_rank;
$A_seq = $objftc->seq;
$A_tseq = $objftc->task_seq;
$A_sseq = $objftc->task_sub_seq;
if($mode==0){
if($i > 0){
$objftcB = pg_fetch_object($objRec, $i-1);
}else{
exit;
}
}else if($mode==1){
if($i < (pg_numrows($objRec)-1)){
$objftcB = pg_fetch_object($objRec, $i+1);
}else{
exit;
}
}
$B_rank = $objftcB->disp_rank;
$B_seq = $objftcB->seq;
$B_tseq = $objftcB->task_seq;
$B_sseq = $objftcB->task_sub_seq;
$strSQL = "update prj_task_tbl set disp_rank = ".$B_rank;
$strSQL .= " where seq = ".$A_seq." and task_seq = ".$A_tseq." and task_sub_seq = ".$A_sseq;
$objRecR = pg_exec($strSQL);
if($objRecR == false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
$strSQL = "update prj_task_tbl set disp_rank = ".$A_rank;
$strSQL .= " where seq = ".$B_seq." and task_seq = ".$B_tseq." and task_sub_seq = ".$B_sseq;
$objRecR = pg_exec($strSQL);
if($objRecR == false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
}
}
}
}
?>