| リビジョン | 17 (tree) |
|---|---|
| 日時 | 2017-08-23 06:26:48 |
| 作者 |  derekwildstar |
- Commit temporário: implementando getRelatedIssues
trunk/server/index.php (diff)| @@ -143,4 +143,53 @@ | ||
| 143 | 143 | return getStatusColor($aStatusId,0); |
| 144 | 144 | } |
| 145 | 145 | } |
| 146 | + | |
| 147 | +function getRelatedIssues($aIssueId) { | |
| 148 | + global $configurations; | |
| 149 | + | |
| 150 | + $query = <<<EOS | |
| 151 | +select brt.relationship_type as relationship | |
| 152 | + , if (but.id <> brt.destination_bug_id,brt.destination_bug_id,brt.source_bug_id) as issue | |
| 153 | + , (select but2.status from mantis_bug_table but2 where but2.id = issue) as status | |
| 154 | + , (select but2.handler_id from mantis_bug_table but2 where but2.id = issue) as handler | |
| 155 | + , (select prt2.name from mantis_bug_table but2 join mantis_project_table prt2 on but2.project_id = prt2.id where but2.id = issue) as project | |
| 156 | + , (select but2.summary from mantis_bug_table but2 where but2.id = issue) as summary | |
| 157 | + , brt.destination_bug_id | |
| 158 | + , brt.destination_bug_id | |
| 159 | + from mantis_bug_relationship_table brt | |
| 160 | + join mantis_bug_table but on brt.source_bug_id = but.id or brt.destination_bug_id = but.id | |
| 161 | + where but.id = $aIssueId | |
| 162 | +EOS; | |
| 163 | + | |
| 164 | + $result = ""; | |
| 165 | + | |
| 166 | + if (($connection = mysql_connect($configurations->getDbHostName(),$configurations->getDbUserName(),$configurations->getDbPassword())) | |
| 167 | + && (mysql_select_db($configurations->getDbDataBase(),$connection)) | |
| 168 | + && ($dataset = mysql_query($query,$connection))) { | |
| 169 | + while ($record = mysql_fetch_object($dataset)) { | |
| 170 | + /* | |
| 171 | + $result .= $record->id . "=" | |
| 172 | + . $record->ProjectName . "¬" | |
| 173 | + . $record->Summary . "¬" | |
| 174 | + . $record->TargetVersion . "¬" | |
| 175 | + . $record->Status . "¬" | |
| 176 | + . $record->LastUpdated . "¬" | |
| 177 | + . $record->Reporter . "¬" | |
| 178 | + . returnsToBR($record->Description) . "¬" | |
| 179 | + . returnsToBR($record->StepsToReproduce) . "¬" | |
| 180 | + . returnsToBR($record->AdditionalInformation) . "\n"; | |
| 181 | + */ | |
| 182 | + } | |
| 183 | + } | |
| 184 | + return $result; | |
| 185 | + | |
| 186 | +/* | |
| 187 | + define( 'BUG_DUPLICATE', 0 ); | |
| 188 | + define( 'BUG_RELATED', 1 ); | |
| 189 | + define( 'BUG_DEPENDANT', 2 ); | |
| 190 | + define( 'BUG_BLOCKS', 3 ); | |
| 191 | + define( 'BUG_HAS_DUPLICATE', 4 ); | |
| 192 | + | |
| 193 | +*/ | |
| 194 | +} | |
| 146 | 195 | ?> |
| \ No newline at end of file |
