Fossil SCM
also display creation time in /tktview
Commit
814a417b4d2d107115300df33ef46b7d2bdbcf1ac95556c999a1061cc6bdacb2
Parent
7c91416166a7ecb…
2 files changed
+2
-1
+10
-2
+2
-1
| --- src/tkt.c | ||
| +++ src/tkt.c | ||
| @@ -190,11 +190,12 @@ | ||
| 190 | 190 | const char *zName; |
| 191 | 191 | Stmt q; |
| 192 | 192 | int i, n, size, j; |
| 193 | 193 | |
| 194 | 194 | zName = PD("name","-none-"); |
| 195 | - db_prepare(&q, "SELECT datetime(tkt_mtime,toLocal()) AS tkt_datetime, *" | |
| 195 | + db_prepare(&q, "SELECT datetime(tkt_mtime,toLocal()) AS tkt_datetime, " | |
| 196 | + "datetime(tkt_ctime,toLocal()) AS tkt_datetime_creation, *" | |
| 196 | 197 | " FROM ticket WHERE tkt_uuid GLOB '%q*'", |
| 197 | 198 | zName); |
| 198 | 199 | if( db_step(&q)==SQLITE_ROW ){ |
| 199 | 200 | n = db_column_count(&q); |
| 200 | 201 | for(i=0; i<n; i++){ |
| 201 | 202 |
| --- src/tkt.c | |
| +++ src/tkt.c | |
| @@ -190,11 +190,12 @@ | |
| 190 | const char *zName; |
| 191 | Stmt q; |
| 192 | int i, n, size, j; |
| 193 | |
| 194 | zName = PD("name","-none-"); |
| 195 | db_prepare(&q, "SELECT datetime(tkt_mtime,toLocal()) AS tkt_datetime, *" |
| 196 | " FROM ticket WHERE tkt_uuid GLOB '%q*'", |
| 197 | zName); |
| 198 | if( db_step(&q)==SQLITE_ROW ){ |
| 199 | n = db_column_count(&q); |
| 200 | for(i=0; i<n; i++){ |
| 201 |
| --- src/tkt.c | |
| +++ src/tkt.c | |
| @@ -190,11 +190,12 @@ | |
| 190 | const char *zName; |
| 191 | Stmt q; |
| 192 | int i, n, size, j; |
| 193 | |
| 194 | zName = PD("name","-none-"); |
| 195 | db_prepare(&q, "SELECT datetime(tkt_mtime,toLocal()) AS tkt_datetime, " |
| 196 | "datetime(tkt_ctime,toLocal()) AS tkt_datetime_creation, *" |
| 197 | " FROM ticket WHERE tkt_uuid GLOB '%q*'", |
| 198 | zName); |
| 199 | if( db_step(&q)==SQLITE_ROW ){ |
| 200 | n = db_column_count(&q); |
| 201 | for(i=0; i<n; i++){ |
| 202 |
+10
-2
| --- src/tktsetup.c | ||
| +++ src/tktsetup.c | ||
| @@ -496,16 +496,24 @@ | ||
| 496 | 496 | @ if {[info exists tkt_datetime]} { |
| 497 | 497 | @ html $tkt_datetime |
| 498 | 498 | @ } |
| 499 | 499 | @ </th1> |
| 500 | 500 | @ </td> |
| 501 | +@ <td class="tktDspLabel">Created:</td><td class="tktDspValue"> | |
| 502 | +@ <th1> | |
| 503 | +@ if {[info exists tkt_datetime_creation]} { | |
| 504 | +@ html $tkt_datetime_creation | |
| 505 | +@ } | |
| 506 | +@ </th1> | |
| 507 | +@ </td></tr> | |
| 501 | 508 | @ <th1>enable_output [hascap e]</th1> |
| 502 | -@ <td class="tktDspLabel">Contact:</td><td class="tktDspValue"> | |
| 509 | +@ <tr> | |
| 510 | +@ <td class="tktDspLabel">Contact:</td><td class="tktDspValue" colspan="3"> | |
| 503 | 511 | @ $<private_contact> |
| 504 | 512 | @ </td> |
| 513 | +@ </tr> | |
| 505 | 514 | @ <th1>enable_output 1</th1> |
| 506 | -@ </tr> | |
| 507 | 515 | @ <tr><td class="tktDspLabel">Version Found In:</td> |
| 508 | 516 | @ <td colspan="3" valign="top" class="tktDspValue"> |
| 509 | 517 | @ <th1> |
| 510 | 518 | @ set versionlink "" |
| 511 | 519 | @ query "SELECT count(*) AS match FROM tag WHERE tagname = 'sym-$foundin'" { |
| 512 | 520 |
| --- src/tktsetup.c | |
| +++ src/tktsetup.c | |
| @@ -496,16 +496,24 @@ | |
| 496 | @ if {[info exists tkt_datetime]} { |
| 497 | @ html $tkt_datetime |
| 498 | @ } |
| 499 | @ </th1> |
| 500 | @ </td> |
| 501 | @ <th1>enable_output [hascap e]</th1> |
| 502 | @ <td class="tktDspLabel">Contact:</td><td class="tktDspValue"> |
| 503 | @ $<private_contact> |
| 504 | @ </td> |
| 505 | @ <th1>enable_output 1</th1> |
| 506 | @ </tr> |
| 507 | @ <tr><td class="tktDspLabel">Version Found In:</td> |
| 508 | @ <td colspan="3" valign="top" class="tktDspValue"> |
| 509 | @ <th1> |
| 510 | @ set versionlink "" |
| 511 | @ query "SELECT count(*) AS match FROM tag WHERE tagname = 'sym-$foundin'" { |
| 512 |
| --- src/tktsetup.c | |
| +++ src/tktsetup.c | |
| @@ -496,16 +496,24 @@ | |
| 496 | @ if {[info exists tkt_datetime]} { |
| 497 | @ html $tkt_datetime |
| 498 | @ } |
| 499 | @ </th1> |
| 500 | @ </td> |
| 501 | @ <td class="tktDspLabel">Created:</td><td class="tktDspValue"> |
| 502 | @ <th1> |
| 503 | @ if {[info exists tkt_datetime_creation]} { |
| 504 | @ html $tkt_datetime_creation |
| 505 | @ } |
| 506 | @ </th1> |
| 507 | @ </td></tr> |
| 508 | @ <th1>enable_output [hascap e]</th1> |
| 509 | @ <tr> |
| 510 | @ <td class="tktDspLabel">Contact:</td><td class="tktDspValue" colspan="3"> |
| 511 | @ $<private_contact> |
| 512 | @ </td> |
| 513 | @ </tr> |
| 514 | @ <th1>enable_output 1</th1> |
| 515 | @ <tr><td class="tktDspLabel">Version Found In:</td> |
| 516 | @ <td colspan="3" valign="top" class="tktDspValue"> |
| 517 | @ <th1> |
| 518 | @ set versionlink "" |
| 519 | @ query "SELECT count(*) AS match FROM tag WHERE tagname = 'sym-$foundin'" { |
| 520 |