PRJ994.php
3.62 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
<?php
//*****************************************************************************
//*
//* プログラム名：プロジェクト管理
//* プログラムID：PRJ994.php
//* 機能 ：タスク削除
//* 作成者 ：
//*
//*****************************************************************************
header( "Content-type: text/html; charset=EUC-JP");
include("inc/session_start.inc");
include("inc/SessionChk.inc");
include('./include/smarty.conf');
$strDBinc="include/dbcon.inc";
include($strDBinc);
if($sseq == 0){
$strWH = "where seq = ".$seq." and task_seq = ".$tseq;
}else{
$strWH = "where seq = ".$seq." and task_seq = ".$tseq." and task_sub_seq = ".$sseq;
}
//タスク
$strSQL = "delete from prj_task_tbl ".$strWH;
$objRec = pg_exec($strSQL);
if($objRec == false){
echo("SQL実行に失敗しました(DELETE)");
exit;
}
//コメント
$strSQL = "delete from prj_comm_tbl ".$strWH;
$objRec = pg_exec($strSQL);
if($objRec == false){
echo("SQL実行に失敗しました(DELETE)");
exit;
}
//プロジェクト期間再設定
$strSQL = "select min(start_date) as minDate, max(end_date) as maxDate from prj_task_tbl where seq = ".$seq." and start_date <> ''";
$objRec = pg_exec($strSQL);
if($objRec == false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$strStart = pg_result($objRec,0,"minDate");
$strEnd = pg_result($objRec,0,"maxDate");
$strSQL = "update prj_tbl set ";
$strSQL .= "start_date = '".$strStart."', end_date = '".$strEnd."' where seq = ".$seq;
$objRec = pg_exec($strSQL);
if($objRec == false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
//監査状態更新
$strSQL = "update prj_comm_tbl set ";
$strSQL .= "comment = '0' ";
$strSQL .= "where seq = ".$seq." and comm_flg = 3 ";
$objRec = pg_exec($strSQL);
if($objRec == false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
//率２
if($sseq > 0){
$strSQL2 = "select seq, task_seq, task_sub_seq, task_name, task_naiyo, start_date, end_date, unit_seq, progress_max, progress, tanto_list, koshin_date from prj_task_tbl ";
$strSQL2 .= "where seq = ".$seq." and task_seq = ".$tseq." and task_sub_seq > 0";
$objRec2 = pg_exec($strSQL2);
if($objRec2 == false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if(pg_numrows($objRec2) > 0){
$numProg = 0;
for($j=0;$j<pg_numrows($objRec2);$j++){
$objftc2 = pg_fetch_object($objRec2, $j);
//率計算
$numProg = $numProg + $objftc2->progress / $objftc2->progress_max;
}
$newProg = floor($numProg / pg_numrows($objRec2) * 100);
//更新
$strSQL = "update prj_task_tbl set ";
$strSQL .= "progress_max = 100, progress = ".$newProg." ";
$strSQL .= "where seq = ".$seq." and task_seq = ".$tseq." and task_sub_seq = 0";
$objRec = pg_exec($strSQL);
if($objRec == false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
}
}
//率
$strSQL2 = "select seq, task_seq, task_sub_seq, task_name, task_naiyo, start_date, end_date, unit_seq, progress_max, progress, tanto_list, koshin_date from prj_task_tbl ";
$strSQL2 .= "where seq = ".$seq." and task_sub_seq = 0";
$objRec2 = pg_exec($strSQL2);
if($objRec2 == false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if(pg_numrows($objRec2) == 0){
$endFlg = 0;
}else{
$numProg = 0;
for($j=0;$j<pg_numrows($objRec2);$j++){
$objftc2 = pg_fetch_object($objRec2, $j);
//率計算
$numProg = $numProg + $objftc2->progress / $objftc2->progress_max;
}
$strProg[$i] = floor($numProg / pg_numrows($objRec2) * 100);
if(floor($numProg / pg_numrows($objRec2) * 100) == 100){
$endFlg = 1;
}else{
$endFlg = 0;
}
}
//完了状態更新
$strSQL = "update prj_tbl set ";
$strSQL .= "end_flg = ".$endFlg." ";
$strSQL .= "where seq = ".$seq;
$objRec = pg_exec($strSQL);
if($objRec == false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
?>