Annotation of ETA/issuesList.php3, revision 1.3
1.1 frystyk 1: <script language="php">
2: $this = 'issuesList.php3';
1.2 frystyk 3: require ('funcs.phi');
4: $domain = getDomain();
5: require ($domain.'config.phi');
1.1 frystyk 6:
7:
8: # -------------------- get table data --------------------
9:
1.3 ! eric 10: list($w3cdb, $fora) = makeQuery($w3cdb, "SELECT issues.forum FROM issues WHERE issues.forum LIKE '$domain%/%' GROUP BY issues.forum ORDER BY issues.forum");
! 11:
1.1 frystyk 12: list($w3cdb, $result) = formatQuery($w3cdb,
1.2 frystyk 13: "SELECT issues.id,issues.forum,issues.category,issues.priority,issues.created,creatorUri.uri,issues.state,issues.summary,issues.description,ownerUri.uri,issues.o_result,issues.o_notes,issues.o_effort FROM issues,uris AS identifier,contacts AS creatorContact,uris AS creatorUri,contacts AS ownerContact,uris AS ownerUri",
1.3 ! eric 14: "identifier.id=issues.id AND issues.creator=creatorContact.id AND creatorContact.email=creatorUri.id AND issues.owner=ownerContact.id AND ownerContact.email=ownerUri.id AND issues.forum LIKE '$domain%' AND issues.forum NOT LIKE '$domain%/%'");
1.1 frystyk 15:
16:
17: # -------------------- render copyright notice --------------------
18:
19: </script><!--
1.3 ! eric 20: # @(#) $Id: issuesList.php3,v 1.2 1999/05/13 16:51:32 frystyk Exp $
1.1 frystyk 21: #
22: # Copyright © 1995-1998 World Wide Web Consortium, (Massachusetts
23: # Institute of Technology, Institut National de Recherche en
24: # Informatique et en Automatique, Keio University). All Rights
25: # Reserved. This program is distributed under the W3C's Software
26: # Intellectual Property License. This program is distributed in the hope
27: # that it will be useful, but WITHOUT ANY WARRANTY; without even the
28: # implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR
29: # PURPOSE. See W3C License http://www.w3.org/Consortium/Legal/ for more
30: # details.
31: --><script language="php">
32:
33:
34: # -------------------- pre templates --------------------
35:
36: $W3C_TITLE = "List Issues";
37: $W3C_AUTHOR = "forum@w3.org";
38: $W3C_DATE = "today";
39: $W3C_NAVBAR = '
1.2 frystyk 40: [<a href="'.formatRef('issuesList.php3', array()).'">List All Issues</a>] |
41: [<a href="'.formatRef('eventsList.php3', array()).'">List All Events</a>] |
42: [<a href="'.formatRef('linksList.php3', array()).'">List All Relationships</a>] |
43: [<a href="'.formatRef('contactsList.php3', array()).'">List All Contacts</a>] |
1.1 frystyk 44: [<a href=".">ETA</a>] |
1.2 frystyk 45: [<a href="'.formatRef('help.php3', array()).'">Help</a>]';
1.1 frystyk 46:
47: include ('pre-template.tpl');
48:
1.3 ! eric 49:
! 50: # -------------------- orient user --------------------
1.1 frystyk 51:
52: </script>
53:
54: <p align="left">An issue is the document, bug, request, annotation, discussion item,
55: or anything else that you want to track using ETA.</p>
56:
1.3 ! eric 57: <script language="php">
! 58:
! 59: if (mysql_num_rows($fora)) {
! 60:
! 61: echo "<p>Available sub-forums: [";
! 62:
! 63:
! 64: # -------------------- render fora --------------------
! 65:
! 66: $firstDomain = $domain;
! 67: while ($row = mysql_fetch_row($fora)) {
! 68: $T_FORUM_NAME = $row[0]; if ($T_FORUM_NAME == '') $T_FORUM_NAME = '<root>';
! 69: $oldDomain = $domain; $domain=$row[0];
! 70: $R_FORUM_NAME = '<a href="'.formatRef('issuesList.php3', array()).'">'.$T_FORUM_NAME.'</a>';
! 71: echo " $R_FORUM_NAME ";
! 72: }
! 73: echo "]</p>\n";
! 74: $domain = $firstDomain;
! 75: }
! 76:
! 77:
! 78: # -------------------- render table head --------------------
! 79:
! 80: </script>
! 81:
1.1 frystyk 82: <table border="1" cellspacing="0" width="100%">
83: <caption></caption>
84: <tbody>
85: <tr>
1.2 frystyk 86: <th><a href="<?php echo formatChain($this, array('order'=>'issues.category'))?>">Category</a></th>
87: <th><a href="<?php echo formatChain($this, array('order'=>'issues.priority'))?>">Priority</a></th>
88: <th><a href="<?php echo formatChain($this, array('order'=>'issues.created'))?>">Created on</a></th>
89: <th><a href="<?php echo formatChain($this, array('order'=>'creatorUri.uri'))?>">Created by</a></th>
90: <th><a href="<?php echo formatChain($this, array('order'=>'issues.state'))?>">Current State</a></th>
91: <th><a href="<?php echo formatChain($this, array('order'=>'issues.summary'))?>">Summary</a></th>
92: <th><a href="<?php echo formatChain($this, array('order'=>'ownerUri.uri'))?>">Assigned to</a></th>
93: <th><a href="<?php echo formatChain($this, array('order'=>'issues.o_result'))?>">Resolution</a></th>
94: <th><a href="<?php echo formatChain($this, array('order'=>'issues.o_effort'))?>">Estimated time to resolve</a></th>
1.1 frystyk 95: </tr>
96: <script language="php">
97:
98:
99: # -------------------- render data --------------------
100:
101: while ($row = mysql_fetch_row($result)) {
102: $T_issues_id = $row[0];
1.2 frystyk 103: $T_FORUM_NAME = $row[1]; if ($T_FORUM_NAME == '') $T_FORUM_NAME = '<root>';
104: $oldDomain = $domain; $domain=$row[1];
105: $R_FORUM_NAME = '<a href="'.formatRef('issuesList.php3', array()).'">'.$T_FORUM_NAME.'</a>';
106: $domain = $oldDomain;
1.1 frystyk 107: # category,priority,creator,state,summary,description,owner,o_result,o_notes,o_effort
1.2 frystyk 108: $T_CATEGORY_NAME = $issues_categories[$row[2]];
109: $R_CATEGORY_NAME = '<a href="'.formatRef('issues.php3', array('issues_id'=>$T_issues_id)).'">'.$T_CATEGORY_NAME.'</a>';
110: $T_PRIORITY_NAME = $issues_priorities[$row[3]];
111: $T_CREATED = $row[4];
112: $T_CRETOR_EMAIL = $row[5];
113: $T_STATE_NAME = $issues_states[$row[6]];
114: $T_SUMMARY = $row[7];
115: $T_DESCRIPTION = $row[8];
116: $T_ASSIGNED = $row[9];
117: $T_RESULT = $row[10];
118: $T_NOTES = $row[11];
119: $T_EFFORT = $row[12];
1.1 frystyk 120: </script>
1.3 ! eric 121: <tr><!-- td><?php echo $R_FORUM_NAME?></td -->
1.2 frystyk 122: <td><?php echo $R_CATEGORY_NAME?></td>
1.1 frystyk 123: <td><?php echo $T_PRIORITY_NAME?></td>
124: <td><?php echo $T_CREATED?></td>
125: <td><?php echo $T_CRETOR_EMAIL?><?php echo $lookupEmail?></td>
126: <td><?php echo $T_STATE_NAME?></td>
127: <td><?php echo $T_SUMMARY?></td>
128: <td><?php echo $T_ASSIGNED?></td>
129: <td><?php echo $T_RESULT?></td>
130: <td><?php echo $T_EFFORT?> minutes</td>
131: </tr>
132: <?php
133: } ?>
134: </tbody>
135: </table>
1.2 frystyk 136: <p align="center">[ <a href="<?php echo formatRef('issues.php3', array('editing'=>1, 'nextAction'=>'add'))?>">Add New Issue</a> ]</p>
1.1 frystyk 137:
138: <script language="php">
139:
140: # -------------------- post templates --------------------
141:
142: include ('post-template.tpl');
143: </script>
144: </body>
145: </html>
Webmaster