52 list = connection.prepareStatement( |
52 list = connection.prepareStatement( |
53 "select issueid, project, p.name as projectname, status, category, subject, i.description, " + |
53 "select issueid, project, p.name as projectname, status, category, subject, i.description, " + |
54 "userid, username, givenname, lastname, mail, " + |
54 "userid, username, givenname, lastname, mail, " + |
55 "created, updated, eta " + |
55 "created, updated, eta " + |
56 "from lpit_issue i " + |
56 "from lpit_issue i " + |
57 "left join lpit_project p on project = projectid " + |
57 "join lpit_project p on project = projectid " + |
58 "left join lpit_user on userid = assignee " + |
58 "left join lpit_user on userid = assignee " + |
59 "where project = ? "+ |
59 "where project = ? "+ |
60 "order by eta asc, updated desc"); |
60 "order by eta asc, updated desc"); |
61 |
61 |
62 listForVersion = connection.prepareStatement( |
62 listForVersion = connection.prepareStatement( |
65 "select issueid, versionid from lpit_issue_resolved_version) "+ |
65 "select issueid, versionid from lpit_issue_resolved_version) "+ |
66 "select issueid, project, p.name as projectname, status, category, subject, i.description, " + |
66 "select issueid, project, p.name as projectname, status, category, subject, i.description, " + |
67 "userid, username, givenname, lastname, mail, " + |
67 "userid, username, givenname, lastname, mail, " + |
68 "created, updated, eta " + |
68 "created, updated, eta " + |
69 "from lpit_issue i " + |
69 "from lpit_issue i " + |
70 "join issue_version using (issueid) "+ |
70 "join lpit_project p on project = projectid " + |
71 "left join lpit_project p on project = projectid " + |
71 "left join issue_version using (issueid) "+ |
72 "left join lpit_user on userid = assignee " + |
72 "left join lpit_user on userid = assignee " + |
73 "where versionid = ? "+ |
73 "where coalesce(versionid,-1) = ? "+ |
74 "order by eta asc, updated desc" |
74 "order by eta asc, updated desc" |
75 ); |
75 ); |
76 |
76 |
77 find = connection.prepareStatement( |
77 find = connection.prepareStatement( |
78 "select issueid, project, p.name as projectname, status, category, subject, i.description, " + |
78 "select issueid, project, p.name as projectname, status, category, subject, i.description, " + |
220 return list(list, project.getId()); |
220 return list(list, project.getId()); |
221 } |
221 } |
222 |
222 |
223 @Override |
223 @Override |
224 public List<Issue> list(Version version) throws SQLException { |
224 public List<Issue> list(Version version) throws SQLException { |
225 return list(listForVersion, version.getId()); |
225 return list(listForVersion, version == null ? -1 : version.getId()); |
226 } |
226 } |
227 |
227 |
228 @Override |
228 @Override |
229 public Issue find(int id) throws SQLException { |
229 public Issue find(int id) throws SQLException { |
230 find.setInt(1, id); |
230 find.setInt(1, id); |