I have continued work on ticket assignment. Tickets can now be assigned by
administrators. Users have a "My Tickets" report, and an Assigned column now
exists in the ticket listings. I would like to give users the ability to assign
and unassign themselves. What does everybody think?
diff -rupN fossil_src_orig/src/schema.c fossil/src/schema.c
--- fossil_src_orig/src/schema.c 2010-03-18 10:20:53.000000000 -0400
+++ fossil/src/schema.c 2010-05-09 11:15:12.108214371 -0400
@@ -171,10 +171,33 @@ const char zRepositorySchema1[] =
@ datetime(tkt_mtime) AS ''mtime'',
@ type,
@ status,
+@ assignedto,
@ subsystem,
@ title
@ FROM ticket');
@
+@ INSERT INTO reportfmt(title,cols,sqlcode) VALUES('My Tickets','#ffffff Key:
+@ #f2dcdc Active
+@ #e8e8e8 Review
+@ #cfe8bd Fixed
+@ #bde5d6 Tested
+@ #cacae5 Deferred
+@ #c8c8c8 Closed','SELECT
+@ CASE WHEN status IN (''Open'',''Verified'') THEN ''#f2dcdc''
+@ WHEN status=''Review'' THEN ''#e8e8e8''
+@ WHEN status=''Fixed'' THEN ''#cfe8bd''
+@ WHEN status=''Tested'' THEN ''#bde5d6''
+@ WHEN status=''Deferred'' THEN ''#cacae5''
+@ ELSE ''#c8c8c8'' END AS ''bgcolor'',
+@ substr(tkt_uuid,1,10) AS ''#'',
+@ datetime(tkt_mtime) AS ''mtime'',
+@ type,
+@ status,
+@ assignedto,
+@ subsystem,
+@ title
+@ FROM ticket WHERE assignedto=user()');
+@
@ -- Some ticket content (such as the originators email address or contact
@ -- information) needs to be obscured to protect privacy. This is achieved
@ -- by storing an SHA1 hash of the content. For display, the hash is
@@ -358,6 +381,7 @@ const char zRepositorySchema2[] =
@ priority TEXT,
@ severity TEXT,
@ foundin TEXT,
+@ assignedto TEXT,
@ private_contact TEXT,
@ resolution TEXT,
@ title TEXT,
diff -rupN fossil_src_orig/src/tktsetup.c fossil/src/tktsetup.c
--- fossil_src_orig/src/tktsetup.c 2010-03-18 10:20:53.000000000 -0400
+++ fossil/src/tktsetup.c 2010-05-09 10:56:31.412964471 -0400
@@ -289,6 +289,17 @@ static const char zDefaultNew[] =
@ affect the operation of the product?</td>
@ </tr>
@
+@ <th1>
+@ if {[hascap a]} {
+@ html "<tr>"
+@ html "<td align='right'>Assigned To:"
+@ html "<input type='text' name='assignedto' value=''>"
+@ html "</td>"
+@ html "<td>Should this issue be assigned to a particular developer?</td>"
+@ html "</tr>"
+@ }
+@ </th1>
+@
@ <tr>
@ <td align="right">EMail:
@ <input type="text" name="private_contact" value="$<private_contact>"
size="30">
@@ -377,8 +388,11 @@ static const char zDefaultView[] =
@ </td></tr>
@ <tr><td align="right">Severity:</td><td bgcolor="#d0d0d0">
@ $<severity>
-@ </td>
-@ <td align="right">Priority:</td><td bgcolor="#d0d0d0">
+@ </td></tr>
+@ <tr><td align="right">Assigned:</td><td bgcolor="#d0d0d0">
+@ $<assignedto>
+@ </td></tr>
+@ <tr><td align="right">Priority:</td><td bgcolor="#d0d0d0">
@ $<priority>
@ </td></tr>
@ <tr><td align="right">Subsystem:</td><td bgcolor="#d0d0d0">
-----Original Message-----
From: "Gour" <[email protected]>
Sent: Thursday, May 6, 2010 11:41am
To: [email protected]
Subject: Re: [fossil-users] ticket assignment
_______________________________________________
fossil-users mailing list
[email protected]
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
On Thu, 6 May 2010 11:30:05 -0400
>>>>>> "Erik" == Erik Lechak wrote:
Erik> Thumbs up from me. I would like to see an "assigned-to" feature
Erik> added to Fossil. It would be great if it was available right out
Erik> of the box.
+1
Sincerely,
Gour
--
Gour | Hlapicina, Croatia | GPG key: F96FF5F6
----------------------------------------------------------------
_______________________________________________
fossil-users mailing list
[email protected]
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
