From 4f49b16079b27d7ce633619e4cddfdf2bffbc952 Mon Sep 17 00:00:00 2001 From: cashmere Date: Fri, 4 Sep 2026 09:05:24 +0200 Subject: initial commit --- src/tkt.c | 1926 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 1926 insertions(+) create mode 100644 src/tkt.c (limited to 'src/tkt.c') diff --git a/src/tkt.c b/src/tkt.c new file mode 100644 index 0000000..3bac718 --- /dev/null +++ b/src/tkt.c @@ -0,0 +1,1926 @@ +/* +** Copyright (c) 2007 D. Richard Hipp +** +** This program is free software; you can redistribute it and/or +** modify it under the terms of the Simplified BSD License (also +** known as the "2-Clause License" or "FreeBSD License".) + +** This program is distributed in the hope that it will be useful, +** but without any warranty; without even the implied warranty of +** merchantability or fitness for a particular purpose. +** +** Author contact information: +** drh@hwaci.com +** http://www.hwaci.com/drh/ +** +******************************************************************************* +** +** This file contains code used render and control ticket entry +** and display pages. +*/ +#include "config.h" +#include "tkt.h" +#include + +/* +** The list of database user-defined fields in the TICKET table. +** The real table also contains some addition fields for internal +** use. The internal-use fields begin with "tkt_". +*/ +static int nField = 0; +static struct tktFieldInfo { + char *zName; /* Name of the database field */ + char *zValue; /* Value to store */ + char *zAppend; /* Value to append */ + char *zBsln; /* "baseline for $zName" if that field exists*/ + unsigned mUsed; /* 01: TICKET 02: TICKETCHNG */ +} *aField; +#define USEDBY_TICKET 01 +#define USEDBY_TICKETCHNG 02 +#define USEDBY_BOTH 03 +#define JCARD_ASSIGN ('=') +#define JCARD_APPEND ('+') +#define JCARD_PRIVATE ('p') +static u8 haveTicket = 0; /* True if the TICKET table exists */ +static u8 haveTicketCTime = 0; /* True if TICKET.TKT_CTIME exists */ +static u8 haveTicketChng = 0; /* True if the TICKETCHNG table exists */ +static u8 haveTicketChngRid = 0; /* True if TICKETCHNG.TKT_RID exists */ +static u8 haveTicketChngUser = 0;/* True if TICKETCHNG.TKT_USER exists */ +static u8 useTicketGenMt = 0; /* use generated TICKET.MIMETYPE */ +static u8 useTicketChngGenMt = 0;/* use generated TICKETCHNG.MIMETYPE */ +static int nTicketBslns = 0; /* number of valid "baseline for ..." */ + + +/* +** Compare two entries in aField[] for sorting purposes +*/ +static int nameCmpr(const void *a, const void *b){ + return fossil_strcmp(((const struct tktFieldInfo*)a)->zName, + ((const struct tktFieldInfo*)b)->zName); +} + +/* +** Return the index into aField[] of the given field name. +** Return -1 if zFieldName is not in aField[]. +*/ +static int fieldId(const char *zFieldName){ + int i; + for(i=0; i=0 ){ + aField[i].mUsed |= USEDBY_TICKETCHNG; + continue; + } + if( nField%10==0 ){ + aField = fossil_realloc(aField, sizeof(aField[0])*(nField+10) ); + } + aField[nField].zBsln = 0; + aField[nField].zName = fossil_strdup(zFieldName); + aField[nField].mUsed = USEDBY_TICKETCHNG; + nField++; + } + db_finalize(&q); + qsort(aField, nField, sizeof(aField[0]), nameCmpr); + noRegularMimetype = 1; + for(i=0; i=0 ){ + aField[j].zValue = fossil_strdup(zVal); + }else if( memcmp(zName, "tkt_", 4)==0 && Th_Fetch(zName, &size)==0 ){ + /* TICKET table columns that begin with "tkt_" are always safe */ + Th_Store(zName, zVal); + } + free(zRevealed); + } + Th_Store("tkt_mage", human_readable_age(db_column_double(&q, 2))); + Th_Store("tkt_cage", human_readable_age(db_column_double(&q, 3))); + } + db_finalize(&q); + for(i=0; izTicketUuid); + tktid = db_last_insert_rowid(); + } + blob_zero(&sql1); + blob_zero(&sql2); + blob_zero(&sql3); + blob_append_sql(&sql1, "UPDATE OR REPLACE ticket SET tkt_mtime=:mtime"); + if( haveTicketCTime ){ + blob_append_sql(&sql1, ", tkt_ctime=coalesce(tkt_ctime,:mtime)"); + } + aUsed = fossil_malloc_zero( nField ); + for(i=0; inField; i++){ + const char * const zName = p->aField[i].zName; + const char * const zBaseName = zName[0]=='+' ? zName+1 : zName; + j = fieldId(zBaseName); + if( j<0 ) continue; + aUsed[j] = 1; + if( aField[j].mUsed & USEDBY_TICKET ){ + if( zName[0]=='+' ){ + blob_append_sql(&sql1,", \"%w\"=coalesce(\"%w\",'') || %Q", + zBaseName, zBaseName, p->aField[i].zValue); + /* when appending keep "baseline for ..." unchanged */ + }else{ + blob_append_sql(&sql1,", \"%w\"=%Q", zBaseName, p->aField[i].zValue); + if( aField[j].zBsln ){ + blob_append_sql(&sql1,", \"%w\"=%d", aField[j].zBsln, rid); + } + } + } + if( aField[j].mUsed & USEDBY_TICKETCHNG ){ + blob_append_sql(&sql2, ",\"%w\"", zBaseName); + blob_append_sql(&sql3, ",%Q", p->aField[i].zValue); + } + if( strcmp(zBaseName,"mimetype")==0 ){ + const char *zMimetype = p->aField[i].zValue; + /* "mimetype" is a regular column => these two flags must be 0 */ + assert(!useTicketGenMt); + assert(!useTicketChngGenMt); + mimetype_tkt = mimetype_tktchng = parse_mimetype( zMimetype ); + } + } + blob_append_sql(&sql1, " WHERE tkt_id=%d", tktid); + if( useTicketGenMt ){ + blob_append_literal(&sql1, " RETURNING mimetype"); + } + db_prepare(&q, "%s", blob_sql_text(&sql1)); + db_bind_double(&q, ":mtime", p->rDate); + db_step(&q); + if( useTicketGenMt ){ + mimetype_tkt = parse_mimetype( db_column_text(&q,0) ); + if( !useTicketChngGenMt ){ + mimetype_tktchng = mimetype_tkt; + } + } + db_finalize(&q); + blob_reset(&sql1); + if( blob_size(&sql2)>0 || haveTicketChngRid || haveTicketChngUser ){ + int fromTkt = 0; + if( haveTicketChngRid ){ + blob_append_literal(&sql2, ",tkt_rid"); + blob_append_sql(&sql3, ",%d", rid); + } + if( haveTicketChngUser && p->zUser ){ + blob_append_literal(&sql2, ",tkt_user"); + blob_append_sql(&sql3, ",%Q", p->zUser); + } + for(i=0; irDate); + db_step(&q); + if( useTicketChngGenMt ){ + mimetype_tktchng = parse_mimetype( db_column_text(&q, 0) ); + /* substitute NULL with a value generated within another table */ + if( !useTicketGenMt ){ + mimetype_tkt = mimetype_tktchng; + }else if( mimetype_tktchng==MT_NONE ){ + mimetype_tktchng = mimetype_tkt; + }else if( mimetype_tkt==MT_NONE ){ + mimetype_tkt = mimetype_tktchng; + } + } + db_finalize(&q); + } + blob_reset(&sql2); + blob_reset(&sql3); + fossil_free(aUsed); + if( rid>0 ){ /* extract backlinks */ + for(i=0; inField; i++){ + const char *zName = p->aField[i].zName; + const char *zBaseName = zName[0]=='+' ? zName+1 : zName; + j = fieldId(zBaseName); + if( j<0 ) continue; + if( aField[j].mUsed & USEDBY_TICKETCHNG ){ + backlink_extract(p->aField[i].zValue, mimetype_tktchng, + rid, BKLNK_TICKET, p->rDate, + /* existing backlinks must have been + * already deleted by the caller */ 0 ); + }else{ + /* update field's data with the most recent values */ + Blob *cards = fields + j; + struct jCardInfo card = { + fossil_strdup(p->aField[i].zValue), + mimetype_tkt, rid, p->rDate + }; + if( blob_size(cards) && zName[0]!='+' ){ + struct jCardInfo *x = (struct jCardInfo *)blob_buffer(cards); + struct jCardInfo *end = x + blob_count(cards,struct jCardInfo); + for(; x!=end; x++){ + fossil_free( x->zValue ); + } + blob_truncate(cards,0); + } + blob_append(cards, (const char*)(&card), sizeof(card)); + } + } + } + return tktid; +} + +/* +** Returns non-zero if moderation is required for ticket changes and ticket +** attachments. +*/ +int ticket_need_moderation( + int localUser /* Are we being called for a local interactive user? */ +){ + /* + ** If the FOSSIL_FORCE_TICKET_MODERATION variable is set, *ALL* changes for + ** tickets will be required to go through moderation (even those performed + ** by the local interactive user via the command line). This can be useful + ** for local (or remote) testing of the moderation subsystem and its impact + ** on the contents and status of tickets. + */ + if( fossil_getenv("FOSSIL_FORCE_TICKET_MODERATION")!=0 ){ + return 1; + } + if( localUser ){ + return 0; + } + return g.perm.ModTkt==0 && db_get_boolean("modreq-tkt",0)==1; +} + +/* +** Rebuild an entire entry in the TICKET table +*/ +void ticket_rebuild_entry(const char *zTktUuid){ + char *zTag = mprintf("tkt-%s", zTktUuid); + int tagid = tag_findid(zTag, 1); + Stmt q; + Manifest *pTicket; + int tktid, i; + int createFlag = 1; + Blob *fields; /* array of blobs; each blob holds array of jCardInfo */ + + fossil_free(zTag); + getAllTicketFields(); + if( haveTicket==0 ) return; + tktid = db_int(0, "SELECT tkt_id FROM ticket WHERE tkt_uuid=%Q", zTktUuid); + if( tktid!=0 ) search_doc_touch('t', tktid, 0); + if( haveTicketChng ){ + db_multi_exec("DELETE FROM ticketchng WHERE tkt_id=%d;", tktid); + } + db_multi_exec("DELETE FROM ticket WHERE tkt_id=%d", tktid); + tktid = 0; + fields = blobarray_new( nField ); + db_multi_exec("DELETE FROM backlink WHERE srctype=%d AND srcid IN " + "(SELECT rid FROM tagxref WHERE tagid=%d)",BKLNK_TICKET, tagid); + db_prepare(&q, "SELECT rid FROM tagxref WHERE tagid=%d ORDER BY mtime",tagid); + while( db_step(&q)==SQLITE_ROW ){ + int rid = db_column_int(&q, 0); + pTicket = manifest_get(rid, CFTYPE_TICKET, 0); + if( pTicket ){ + tktid = ticket_insert(pTicket, rid, tktid, fields); + manifest_ticket_event(rid, pTicket, createFlag, tagid); + manifest_destroy(pTicket); + } + createFlag = 0; + } + db_finalize(&q); + search_doc_touch('t', tktid, 0); + /* Extract backlinks from the most recent values of TICKET fields */ + for(i=0; izValue ); + backlink_extract(x->zValue,x->mimetype, + x->rid,BKLNK_TICKET,x->mtime,0); + fossil_free( x->zValue ); + } + } + blob_truncate(cards,0); + } + blobarray_delete(fields,nField); +} + + +/* +** Create the TH1 interpreter and load the "common" code. +*/ +void ticket_init(void){ + const char *zConfig; + Th_FossilInit(TH_INIT_DEFAULT); + zConfig = ticket_common_code(); + Th_Eval(g.interp, 0, zConfig, -1); +} + +/* +** Create the TH1 interpreter and load the "change" code. +*/ +int ticket_change(const char *zUuid){ + const char *zConfig; + Th_FossilInit(TH_INIT_DEFAULT); + Th_Store("uuid", zUuid); + zConfig = ticket_change_code(); + return Th_Eval(g.interp, 0, zConfig, -1); +} + +/* +** An authorizer function for the SQL used to initialize the +** schema for the ticketing system. Only allow +** +** CREATE TABLE +** CREATE INDEX +** CREATE VIEW +** DROP INDEX +** DROP VIEW +** +** And for objects in "main" or "repository" whose names +** begin with "ticket" or "fx_". Also allow +** +** INSERT +** UPDATE +** DELETE +** +** But only for tables in "main" or "repository" whose names +** begin with "ticket", "sqlite_", or "fx_". +** +** Of particular importance for security is that this routine +** disallows data changes on the "config" table, as that could +** allow a malicious server to modify settings in such a way as +** to cause a remote code execution. +** +** Use the "fossil test-db-prepare --auth-ticket SQL" command to perform +** manual testing of this authorizer. +*/ +static int ticket_schema_auth( + void *pNErr, + int eCode, + const char *z0, + const char *z1, + const char *z2, + const char *z3 +){ + switch( eCode ){ + case SQLITE_DROP_VIEW: + case SQLITE_CREATE_VIEW: + case SQLITE_CREATE_TABLE: { + if( sqlite3_stricmp(z2,"main")!=0 + && sqlite3_stricmp(z2,"repository")!=0 + ){ + goto ticket_schema_error; + } + if( sqlite3_strnicmp(z0,"ticket",6)!=0 + && sqlite3_strnicmp(z0,"fx_",3)!=0 + ){ + goto ticket_schema_error; + } + break; + } + case SQLITE_DROP_INDEX: + case SQLITE_CREATE_INDEX: { + if( sqlite3_stricmp(z2,"main")!=0 + && sqlite3_stricmp(z2,"repository")!=0 + ){ + goto ticket_schema_error; + } + if( sqlite3_strnicmp(z1,"ticket",6)!=0 + && sqlite3_strnicmp(z0,"fx_",3)!=0 + ){ + goto ticket_schema_error; + } + break; + } + case SQLITE_INSERT: + case SQLITE_UPDATE: + case SQLITE_DELETE: { + if( sqlite3_stricmp(z2,"main")!=0 + && sqlite3_stricmp(z2,"repository")!=0 + ){ + goto ticket_schema_error; + } + if( sqlite3_strnicmp(z0,"ticket",6)!=0 + && sqlite3_strnicmp(z0,"sqlite_",7)!=0 + && sqlite3_strnicmp(z0,"fx_",3)!=0 + ){ + goto ticket_schema_error; + } + break; + } + case SQLITE_SELECT: + case SQLITE_FUNCTION: + case SQLITE_REINDEX: + case SQLITE_TRANSACTION: + case SQLITE_READ: { + break; + } + default: { + goto ticket_schema_error; + } + } + return SQLITE_OK; + +ticket_schema_error: + if( pNErr ) *(int*)pNErr = 1; + return SQLITE_DENY; +} + +/* +** Activate the ticket schema authorizer. Must be followed by +** an eventual call to ticket_unrestrict_sql(). +*/ +void ticket_restrict_sql(int * pNErr){ + db_set_authorizer(ticket_schema_auth,(void*)pNErr,"Ticket-Schema"); +} +/* +** Deactivate the ticket schema authorizer. +*/ +void ticket_unrestrict_sql(void){ + db_clear_authorizer(); +} + + +/* +** Recreate the TICKET and TICKETCHNG tables. +*/ +void ticket_create_table(int separateConnection){ + char *zSql; + + db_multi_exec( + "DROP TABLE IF EXISTS ticket;" + "DROP TABLE IF EXISTS ticketchng;" + ); + zSql = ticket_table_schema(); + ticket_restrict_sql(0); + if( separateConnection ){ + if( db_transaction_nesting_depth() ) db_end_transaction(0); + db_init_database(g.zRepositoryName, zSql, 0); + }else{ + db_multi_exec("%s", zSql/*safe-for-%s*/); + } + ticket_unrestrict_sql(); + fossil_free(zSql); +} + +/* +** Repopulate the TICKET and TICKETCHNG tables from scratch using all +** available ticket artifacts. +*/ +void ticket_rebuild(void){ + Stmt q; + ticket_create_table(1); + db_begin_transaction(); + db_prepare(&q,"SELECT tagname FROM tag WHERE tagname GLOB 'tkt-*'"); + while( db_step(&q)==SQLITE_ROW ){ + const char *zName = db_column_text(&q, 0); + int len; + zName += 4; + len = strlen(zName); + if( len<20 || !validate16(zName, len) ) continue; + ticket_rebuild_entry(zName); + } + db_finalize(&q); + db_end_transaction(0); +} + +/* +** COMMAND: test-ticket-rebuild +** +** Usage: %fossil test-ticket-rebuild TICKETID|all +** +** Rebuild the TICKET and TICKETCHNG tables for the given ticket ID +** or for ALL. +*/ +void test_ticket_rebuild(void){ + db_find_and_open_repository(0, 0); + if( g.argc!=3 ) usage("TICKETID|all"); + if( fossil_strcmp(g.argv[2], "all")==0 ){ + ticket_rebuild(); + }else{ + const char *zUuid; + zUuid = db_text(0, "SELECT substr(tagname,5) FROM tag" + " WHERE tagname GLOB 'tkt-%q*'", g.argv[2]); + if( zUuid==0 ) fossil_fatal("no such ticket: %s", g.argv[2]); + ticket_rebuild_entry(zUuid); + } +} + +/* +** For trouble-shooting purposes, render a dump of the aField[] table to +** the webpage currently under construction. +*/ +static void showAllFields(void){ + int i; + @
+ @

Database fields:

    + for(i=0; iaField[%d(i)].zName = "%h(aField[i].zName)"; + @ originally = "%h(aField[i].zValue)"; + @ currently = "%h(PD(aField[i].zName,""))"; + if( aField[i].zAppend ){ + @ zAppend = "%h(aField[i].zAppend)"; + } + @ mUsed = %d(aField[i].mUsed); + } + @
+} + +/* +** WEBPAGE: tktview +** URL: tktview/HASH +** +** View a ticket identified by the name= query parameter. +** Other query parameters: +** +** tl Show a timeline of the ticket above the status +*/ +void tktview_page(void){ + const char *zScript; + char *zFullName; + const char *zUuid = PD("name",""); + int showTimeline = P("tl")!=0; + + login_check_credentials(); + if( !g.perm.RdTkt ){ login_needed(g.anon.RdTkt); return; } + if( g.anon.WrTkt || g.anon.ApndTkt ){ + style_submenu_element("Edit", "%R/tktedit/%T", PD("name","")); + } + if( g.perm.Hyperlink ){ + style_submenu_element("History", "%R/tkthistory/%T", zUuid); + if( g.perm.Read ){ + style_submenu_element("Check-ins", "%R/tkttimeline/%T?y=ci", zUuid); + } + } + if( g.anon.NewTkt ){ + style_submenu_element("New Ticket", "%R/tktnew"); + } + zFullName = db_text(0, + "SELECT tkt_uuid FROM ticket" + " WHERE tkt_uuid GLOB '%q*'", zUuid); + if( g.anon.ApndTkt && g.anon.Attach ){ + style_submenu_element("Attach", "%R/attachadd?target=%T&from=%R/tktview/%t", + zFullName, zUuid); + } + if( P("plaintext") ){ + style_submenu_element("Formatted", "%R/tktview/%s", zUuid); + }else{ + style_submenu_element("Plaintext", "%R/tktview/%s?plaintext", zUuid); + } + style_set_current_feature("tkt"); + style_header("View Ticket"); + if( showTimeline ){ + int tagid = db_int(0,"SELECT tagid FROM tag WHERE tagname GLOB 'tkt-%q*'", + zUuid); + if( tagid ){ + tkt_draw_timeline(tagid, "a"); + @
+ }else{ + showTimeline = 0; + } + } + if( !showTimeline && g.perm.Hyperlink ){ + style_submenu_element("Timeline", "%R/info/%T", zUuid); + } + if( g.thTrace ) Th_Trace("BEGIN_TKTVIEW
\n", -1); + ticket_init(); + initializeVariablesFromCGI(); + getAllTicketFields(); + initializeVariablesFromDb(); + zScript = ticket_viewpage_code(); + if( P("showfields")!=0 ) showAllFields(); + if( g.thTrace ) Th_Trace("BEGIN_TKTVIEW_SCRIPT
\n", -1); + safe_html_context(DOCSRC_TICKET); + Th_Render(zScript); + if( g.thTrace ) Th_Trace("END_TKTVIEW
\n", -1); + + if( zFullName ){ + char * z = mprintf( + "

Attachments:

", + zFullName + ); + attachment_list(zFullName, z, 1); + fossil_free(z); + } + + builtin_fossil_js_bundle_or("dom", "storage", NULL); + builtin_request_js("fossil.page.ticket.js"); + builtin_fulfill_js_requests(); + + style_finish_page(); +} + +/* +** TH1 command: append_field FIELD STRING +** +** FIELD is the name of a database column to which we might want +** to append text. STRING is the text to be appended to that +** column. The append does not actually occur until the +** submit_ticket command is run. +*/ +static int appendRemarkCmd( + Th_Interp *interp, + void *p, + int argc, + const char **argv, + int *argl +){ + int idx; + + if( argc!=3 ){ + return Th_WrongNumArgs(interp, "append_field FIELD STRING"); + } + if( g.thTrace ){ + Th_Trace("append_field %#h {%#h}
\n", + TH1_LEN(argl[1]), argv[1], TH1_LEN(argl[2]), argv[2]); + } + for(idx=0; idx=nField ){ + Th_ErrorMessage(g.interp, "no such TICKET column: ", argv[1], argl[1]); + return TH_ERROR; + } + aField[idx].zAppend = mprintf("%.*s", argl[2], argv[2]); + return TH_OK; +} + +/* +** Write a ticket into the repository. +** Upon reassignment of fields try to delta-compress an artifact against +** all artifacts that are referenced in the corresponding zBsln fields. +*/ +static int ticket_put( + Blob *pTicket, /* The text of the ticket change record */ + const char *zTktId, /* The ticket to which this change is applied */ + const char *aUsed, /* Indicators for fields' modifications */ + int needMod /* True if moderation is needed */ +){ + int result; + int rid; + manifest_crosslink_begin(); + rid = content_put_ex(pTicket, 0, 0, 0, needMod); + if( rid==0 ){ + fossil_fatal("trouble committing ticket: %s", g.zErrMsg); + } + if( nTicketBslns ){ + int i, s, buf[8], nSrc=0, *aSrc=&(buf[0]); + if( nTicketBslns > count(buf) ){ + aSrc = (int*)fossil_malloc(sizeof(int)*nTicketBslns); + } + for(i=0; i 0 ) aSrc[nSrc++] = s; + } + } + if( nSrc ) content_deltify(rid, aSrc, nSrc, 0); + if( aSrc!=&(buf[0]) ) fossil_free( aSrc ); + } + if( needMod ){ + moderation_table_create(); + db_multi_exec( + "INSERT INTO modreq(objid, tktid) VALUES(%d,%Q)", + rid, zTktId + ); + }else{ + db_add_unsent(rid); + db_multi_exec("INSERT OR IGNORE INTO unclustered VALUES(%d);", rid); + } + result = (manifest_crosslink(rid, pTicket, MC_NONE)==0); + assert( blob_is_reset(pTicket) ); + if( !result ){ + result = manifest_crosslink_end(MC_PERMIT_HOOKS); + }else{ + manifest_crosslink_end(MC_NONE); + } + return result; +} + +/* +** Subscript command: submit_ticket +** +** Construct and submit a new ticket artifact. The fields of the artifact +** are the names of the columns in the TICKET table. The content is +** taken from TH variables. If the content is unchanged, the field is +** omitted from the artifact. Fields whose names begin with "private_" +** are concealed using the db_conceal() function. +*/ +static int submitTicketCmd( + Th_Interp *interp, + void *pUuid, + int argc, + const char **argv, + int *argl +){ + char *zDate, *aUsed; + const char *zUuid; + int i; + int nJ = 0, rc = TH_OK; + Blob tktchng, cksum; + int needMod; + + if( !cgi_csrf_safe(2) ){ + @

Error: Invalid CSRF token.

+ return TH_OK; + } + if( !captcha_is_correct(0) ){ + @

Error: Incorrect security code.

+ return TH_OK; + } + zUuid = (const char *)pUuid; + blob_zero(&tktchng); + zDate = date_in_standard_format("now"); + blob_appendf(&tktchng, "D %s\n", zDate); + free(zDate); + aUsed = fossil_malloc_zero( nField ); + for(i=0; i0 && fossil_isspace(zValue[nValue-1]) ){ nValue--; } + if( ((aField[i].mUsed & USEDBY_TICKETCHNG)!=0 && nValue>0) + || memcmp(zValue, aField[i].zValue, nValue)!=0 + ||(int)strlen(aField[i].zValue)!=nValue + ){ + if( memcmp(aField[i].zName, "private_", 8)==0 ){ + zValue = db_conceal(zValue, nValue); + blob_appendf(&tktchng, "J %s %s\n", aField[i].zName, zValue); + aUsed[i] = JCARD_PRIVATE; + }else{ + blob_appendf(&tktchng, "J %s %#F\n", aField[i].zName, nValue, zValue); + aUsed[i] = JCARD_ASSIGN; + } + nJ++; + } + } + } + if( *(char**)pUuid ){ + zUuid = db_text(0, + "SELECT tkt_uuid FROM ticket WHERE tkt_uuid GLOB '%q*'", P("name") + ); + }else{ + zUuid = db_text(0, "SELECT lower(hex(randomblob(20)))"); + } + *(const char**)pUuid = zUuid; + blob_appendf(&tktchng, "K %s\n", zUuid); + blob_appendf(&tktchng, "U %F\n", login_name()); + md5sum_blob(&tktchng, &cksum); + blob_appendf(&tktchng, "Z %b\n", &cksum); + if( nJ==0 ){ + blob_reset(&tktchng); + goto finish; + } + needMod = ticket_need_moderation(0); + if( g.zPath[0]=='d' ){ + const char *zNeedMod = needMod ? "required" : "skipped"; + /* If called from /debug_tktnew or /debug_tktedit... */ + @
+ @

Ticket artifact that would have been submitted:

+ @ 
%h(blob_str(&tktchng))
+ @ 
Moderation would be %h(zNeedMod).
+ @
+ @
+ }else{ + if( g.thTrace ){ + Th_Trace("submit_ticket {\n
\n%h\n
\n" + "}
\n", + blob_str(&tktchng)); + } + ticket_put(&tktchng, zUuid, aUsed, needMod); + rc = ticket_change(zUuid); + } + finish: + fossil_free( aUsed ); + return rc; +} + + +/* +** WEBPAGE: tktnew +** WEBPAGE: debug_tktnew +** +** Enter a new ticket. The tktnew_template script in the ticket +** configuration is used. The /tktnew page is the official ticket +** entry page. The /debug_tktnew page is used for debugging the +** tktnew_template in the ticket configuration. /debug_tktnew works +** just like /tktnew except that it does not really save the new ticket +** when you press submit - it just prints the ticket artifact at the +** top of the screen. +*/ +void tktnew_page(void){ + const char *zScript; + char *zNewUuid = 0; + int uid; + + login_check_credentials(); + if( !g.perm.NewTkt ){ login_needed(g.anon.NewTkt); return; } + if( P("cancel") ){ + cgi_redirect("home"); + } + style_set_current_feature("tkt"); + style_header("New Ticket"); + ticket_standard_submenu(T_ALL_BUT(T_NEW)); + if( g.thTrace ) Th_Trace("BEGIN_TKTNEW
\n", -1); + ticket_init(); + initializeVariablesFromCGI(); + getAllTicketFields(); + initializeVariablesFromDb(); + if( g.zPath[0]=='d' ) showAllFields(); + form_begin(0, "%R/%s", g.zPath); + if( P("date_override") && g.perm.Setup ){ + @ + } + zScript = ticket_newpage_code(); + Th_Store("private_contact", ""); + if( g.zLogin && g.zLogin[0] ){ + uid = db_int(0, "SELECT uid FROM user WHERE login=%Q", g.zLogin); + if( uid ){ + char * zEmail = + db_text(0, "SELECT find_emailaddr(info) FROM user WHERE uid=%d", + uid); + if( zEmail ){ + Th_StoreUnsafe("private_contact", zEmail); + fossil_free(zEmail); + } + } + } + Th_StoreUnsafe("login", login_name()); + Th_Store("date", db_text(0, "SELECT datetime('now')")); + Th_CreateCommand(g.interp, "submit_ticket", submitTicketCmd, + (void*)&zNewUuid, 0); + if( g.thTrace ) Th_Trace("BEGIN_TKTNEW_SCRIPT
\n", -1); + if( Th_Render(zScript)==TH_RETURN && !g.thTrace && zNewUuid ){ + if( P("submitandnew") ){ + cgi_redirect(mprintf("%R/tktnew/%s", zNewUuid)); + }else{ + cgi_redirect(mprintf("%R/tktview/%s", zNewUuid)); + } + return; + } + captcha_generate(0); + @ + if( g.thTrace ) Th_Trace("END_TKTVIEW
\n", -1); + style_finish_page(); +} + +/* +** WEBPAGE: tktedit +** WEBPAGE: debug_tktedit +** +** Edit a ticket. The ticket is identified by the name CGI parameter. +** /tktedit is the official page. The /debug_tktedit page does the same +** thing except that it does not save the ticket change record when you +** press submit - it instead prints the ticket change record at the top +** of the page. The /debug_tktedit page is intended to be used when +** debugging ticket configurations. +*/ +void tktedit_page(void){ + const char *zScript; + int nName; + const char *zName; + int nRec; + + login_check_credentials(); + if( !g.perm.ApndTkt && !g.perm.WrTkt ){ + login_needed(g.anon.ApndTkt || g.anon.WrTkt); + return; + } + zName = P("name"); + if( P("cancel") ){ + cgi_redirectf("tktview/%T", zName); + } + style_set_current_feature("tkt"); + style_header("Edit Ticket"); + if( zName==0 || (nName = strlen(zName))<4 || nName>HNAME_LEN_SHA1 + || !validate16(zName,nName) ){ + @ Not a valid ticket id: "%h(zName)" + style_finish_page(); + return; + } + nRec = db_int(0, "SELECT count(*) FROM ticket WHERE tkt_uuid GLOB '%q*'", + zName); + if( nRec==0 ){ + @ No such ticket: "%h(zName)" + style_finish_page(); + return; + } + if( nRec>1 ){ + @ %d(nRec) tickets begin with: + @ "%h(zName)" + style_finish_page(); + return; + } + if( g.thTrace ) Th_Trace("BEGIN_TKTEDIT
\n", -1); + ticket_init(); + getAllTicketFields(); + initializeVariablesFromCGI(); + initializeVariablesFromDb(); + if( g.zPath[0]=='d' ) showAllFields(); + form_begin(0, "%R/%s", g.zPath); + @ + zScript = ticket_editpage_code(); + Th_StoreUnsafe("login", login_name()); + Th_Store("date", db_text(0, "SELECT datetime('now')")); + Th_CreateCommand(g.interp, "append_field", appendRemarkCmd, 0, 0); + Th_CreateCommand(g.interp, "submit_ticket", submitTicketCmd, (void*)&zName,0); + if( g.thTrace ) Th_Trace("BEGIN_TKTEDIT_SCRIPT
\n", -1); + if( Th_Render(zScript)==TH_RETURN && !g.thTrace && zName ){ + cgi_redirect(mprintf("%R/tktview/%s", zName)); + return; + } + captcha_generate(0); + @ + if( g.thTrace ) Th_Trace("BEGIN_TKTEDIT
\n", -1); + style_finish_page(); +} + +/* +** Check the ticket table schema in zSchema to see if it appears to +** be well-formed. If everything is OK, return NULL. If something is +** amiss, then return a pointer to a string (obtained from malloc) that +** describes the problem. +*/ +char *ticket_schema_check(const char *zSchema){ + char *zErr = 0; + int rc; + sqlite3 *db; + rc = sqlite3_open(":memory:", &db); + if( rc==SQLITE_OK ){ + rc = sqlite3_exec(db, zSchema, 0, 0, &zErr); + if( rc!=SQLITE_OK ){ + sqlite3_close(db); + return zErr; + } + rc = sqlite3_exec(db, "SELECT tkt_id, tkt_uuid, tkt_mtime FROM ticket", + 0, 0, 0); + if( rc!=SQLITE_OK ){ + zErr = mprintf("schema fails to define valid a TICKET " + "table containing all required fields"); + }else{ + rc = sqlite3_exec(db, "SELECT tkt_id, tkt_mtime FROM ticketchng", 0,0,0); + if( rc!=SQLITE_OK ){ + zErr = mprintf("schema fails to define valid a TICKETCHNG " + "table containing all required fields"); + } + } + sqlite3_close(db); + } + return zErr; +} + +/* +** Draw a timeline for a ticket with tag.tagid given by the tagid +** parameter. +** +** If zType[0]=='c' then only show check-ins associated with the +** ticket. For any other value of zType, show all events associated +** with the ticket. +*/ +void tkt_draw_timeline(int tagid, const char *zType){ + Stmt q; + char *zFullUuid; + char *zSQL; + zFullUuid = db_text(0, "SELECT substr(tagname, 5) FROM tag WHERE tagid=%d", + tagid); + if( zType[0]=='c' ){ + zSQL = mprintf( + "%s AND event.objid IN " + " (SELECT srcid FROM backlink WHERE target GLOB '%.4s*' " + "AND srctype=0 " + "AND '%s' GLOB (target||'*')) " + "ORDER BY mtime DESC", + timeline_query_for_www(), zFullUuid, zFullUuid + ); + }else{ + zSQL = mprintf( + "%s AND event.objid IN " + " (SELECT rid FROM tagxref WHERE tagid=%d" + " UNION" + " SELECT CASE srctype WHEN 2 THEN" + " (SELECT rid FROM tagxref WHERE tagid=backlink.srcid" + " ORDER BY mtime DESC LIMIT 1)" + " ELSE srcid END" + " FROM backlink" + " WHERE target GLOB '%.4s*'" + " AND '%s' GLOB (target||'*')" + " UNION SELECT attachid FROM attachment" + " WHERE target=%Q) " + "ORDER BY mtime DESC", + timeline_query_for_www(), tagid, zFullUuid, zFullUuid, zFullUuid + ); + } + db_prepare(&q, "%z", zSQL/*safe-for-%s*/); + www_print_timeline(&q, + TIMELINE_ARTID | TIMELINE_DISJOINT | TIMELINE_GRAPH | TIMELINE_NOTKT | + TIMELINE_REFS, + 0); + db_finalize(&q); + fossil_free(zFullUuid); +} + +/* +** WEBPAGE: tkttimeline +** URL: /tkttimeline/TICKETUUID +** +** Show the change history for a single ticket in timeline format. +** +** Query parameters: +** +** y=ci Show only check-ins associated with the ticket +*/ +void tkttimeline_page(void){ + char *zTitle; + const char *zUuid; + int tagid; + char zGlobPattern[50]; + const char *zType; + + login_check_credentials(); + if( !g.perm.Hyperlink || !g.perm.RdTkt ){ + login_needed(g.anon.Hyperlink && g.anon.RdTkt); + return; + } + zUuid = PD("name",""); + zType = PD("y","a"); + if( zType[0]!='c' ){ + if( g.perm.Read ){ + style_submenu_element("Check-ins", "%R/tkttimeline/%T?y=ci", zUuid); + } + }else{ + style_submenu_element("Timeline", "%R/tkttimeline/%T", zUuid); + } + style_submenu_element("History", "%R/tkthistory/%s", zUuid); + style_submenu_element("Status", "%R/info/%s", zUuid); + if( zType[0]=='c' ){ + zTitle = mprintf("Check-ins Associated With Ticket %h", zUuid); + }else{ + zTitle = mprintf("Timeline Of Ticket %h", zUuid); + } + style_set_current_feature("tkt"); + style_header("%z", zTitle); + + sqlite3_snprintf(6, zGlobPattern, "%s", zUuid); + canonical16(zGlobPattern, strlen(zGlobPattern)); + tagid = db_int(0, "SELECT tagid FROM tag WHERE tagname GLOB 'tkt-%q*'",zUuid); + if( tagid==0 ){ + @ No such ticket: %h(zUuid) + style_finish_page(); + return; + } + tkt_draw_timeline(tagid, zType); + style_finish_page(); +} + +/* +** WEBPAGE: tkthistory +** URL: /tkthistory/TICKETUUID +** +** Show the complete change history for a single ticket. Or (to put it +** another way) show a list of artifacts associated with a single ticket. +** +** By default, the artifacts are decoded and formatted. Text fields +** are formatted as text/plain, since in the general case Fossil does +** not have knowledge of the encoding. If the "raw" query parameter +** is present, then the undecoded and unformatted text of each artifact +** is displayed. +** +** Reassignments of a field of the TICKET table that has a corresponding +** "baseline for ..." companion are rendered as unified diffs. +*/ +void tkthistory_page(void){ + Stmt q; + char *zTitle; + const char *zUuid; + int tagid; + int nChng = 0; + Blob *aLastVal = 0; /* holds the last rendered value for each field */ + + login_check_credentials(); + if( !g.perm.Hyperlink || !g.perm.RdTkt ){ + login_needed(g.anon.Hyperlink && g.anon.RdTkt); + return; + } + zUuid = PD("name",""); + zTitle = mprintf("History Of Ticket %h", zUuid); + style_submenu_element("Status", "%R/info/%s", zUuid); + if( g.perm.Read ){ + style_submenu_element("Check-ins", "%R/tkttimeline/%s?y=ci", zUuid); + } + style_submenu_element("Timeline", "%R/tkttimeline/%s", zUuid); + if( P("raw")!=0 ){ + style_submenu_element("Decoded", "%R/tkthistory/%s", zUuid); + }else if( g.perm.Admin ){ + style_submenu_element("Raw", "%R/tkthistory/%s?raw", zUuid); + } + style_set_current_feature("tkt"); + style_header("%z", zTitle); + + tagid = db_int(0, "SELECT tagid FROM tag WHERE tagname GLOB 'tkt-%q*'",zUuid); + if( tagid==0 ){ + @ No such ticket: %h(zUuid) + style_finish_page(); + return; + } + if( P("raw")!=0 ){ + @

Raw Artifacts Associated With Ticket %h(zUuid)

+ }else{ + @

Artifacts Associated With Ticket %h(zUuid)

+ getAllTicketFields(); + if( nTicketBslns ){ + aLastVal = blobarray_new(nField); + } + } + db_prepare(&q, + "SELECT datetime(mtime,toLocal()), objid, uuid, NULL, NULL, NULL" + " FROM event, blob" + " WHERE objid IN (SELECT rid FROM tagxref WHERE tagid=%d)" + " AND blob.rid=event.objid" + " UNION " + "SELECT datetime(mtime,toLocal()), attachid, uuid, src, filename, user" + " FROM attachment, blob" + " WHERE target=(SELECT substr(tagname,5) FROM tag WHERE tagid=%d)" + " AND blob.rid=attachid" + " ORDER BY 1", + tagid, tagid + ); + for(nChng=0; db_step(&q)==SQLITE_ROW; nChng++){ + Manifest *pTicket; + const char *zDate = db_column_text(&q, 0); + int rid = db_column_int(&q, 1); + const char *zChngUuid = db_column_text(&q, 2); + const char *zFile = db_column_text(&q, 4); + if( nChng==0 ){ + @
    + } + if( zFile!=0 ){ + const char *zSrc = db_column_text(&q, 3); + const char *zUser = db_column_text(&q, 5); + @ + @

  1. + if( zSrc==0 || zSrc[0]==0 ){ + @ Delete attachment "%h(zFile)" + }else{ + @ Add attachment + @ "%z(href("%R/artifact/%!S",zSrc))%s(zFile)" + } + @ [%z(href("%R/artifact/%!S",zChngUuid))%S(zChngUuid)] + @ (rid %d(rid)) by + hyperlink_to_user(zUser,zDate," on"); + hyperlink_to_date(zDate, ".

    "); + }else{ + pTicket = manifest_get(rid, CFTYPE_TICKET, 0); + if( pTicket ){ + @ + @

  2. Ticket change + @ [%z(href("%R/artifact/%!S",zChngUuid))%S(zChngUuid)] + @ (rid %d(rid)) by + hyperlink_to_user(pTicket->zUser,zDate," on"); + hyperlink_to_date(zDate, ":"); + @

    + if( P("raw")!=0 ){ + Blob c; + content_get(rid, &c); + @ 
    +          @ %h(blob_str(&c))
+          @
    + blob_reset(&c); + }else{ + ticket_output_change_artifact(pTicket, "a", nChng, aLastVal); + } + } + manifest_destroy(pTicket); + } + @
    3. + } + db_finalize(&q); + if( nChng ){ + @
+ } + style_finish_page(); + if( aLastVal ) blobarray_delete(aLastVal, nField); +} + +/* +** Return TRUE if the given BLOB contains a newline character. +*/ +static int contains_newline(Blob *p){ + const char *z = blob_str(p); + while( *z ){ + if( *z=='\n' ) return 1; + z++; + } + return 0; +} + +/* +** The pTkt object is a ticket change artifact. Output a detailed +** description of this object. +** +** If `aLastVal` is not NULL then render selected fields as unified diffs +** and update corresponding elements of that array with values from `pTkt`. +*/ +void ticket_output_change_artifact( + Manifest *pTkt, /* Parsed artifact for the ticket change */ + const char *zListType, /* Which type of list */ + int n, /* Which ticket change is this */ + Blob *aLastVal /* Array of the latest values for the diffs */ +){ + int i; + if( zListType==0 ) zListType = "1"; + getAllTicketFields(); + @
    + for(i=0; inField; i++){ + const char *z = pTkt->aField[i].zName; + const char *zX = z[0]=='+' ? z+1 : z; + const int id = fieldId(zX); + const char *zValue = pTkt->aField[i].zValue; + const size_t nValue = strlen(zValue); + const int bLong = nValue>50 || memchr(zValue,'\n',nValue)!=NULL; + /* zValue is long enough to justify a
    */ + const int bCanDiff = aLastVal && id>=0 && aField[id].zBsln; + /* preliminary flag for rendering via unified diff */ + int bAppend = 0; /* zValue is being appended to a TICKET's field */ + int bRegular = 0; /* prev value of a TICKET's field is being superseded*/ + @
  1. \ + if( id<0 ){ + @ Untracked field %h(zX): + }else if( aField[id].mUsed==USEDBY_TICKETCHNG ){ + @ %h(zX): + }else if( n==0 ){ + @ %h(zX) initialized to: + }else if( z[0]=='+' && (aField[id].mUsed&USEDBY_TICKET)!=0 ){ + @ Appended to %h(zX): + bAppend = 1; + }else{ + if( !bCanDiff ){ + @ %h(zX) changed to: \ + } + bRegular = 1; + } + if( bCanDiff ){ + Blob *prev = aLastVal+id; + Blob val = BLOB_INITIALIZER; + if( nValue ){ + blob_init(&val, zValue, nValue+1); + val.nUsed--; /* makes blob_str() faster */ + } + if( bRegular && nValue && blob_buffer(prev) && blob_size(prev) ){ + Blob d = BLOB_INITIALIZER; + DiffConfig DCfg; + construct_diff_flags(1, &DCfg); + DCfg.diffFlags |= DIFF_HTML | DIFF_LINENO; + text_diff(prev, &val, &d, &DCfg); + @ %h(zX) changed as: + @ %s(blob_str(&d)) + @
    2. + blob_reset(&d); + }else{ + if( bRegular ){ + @ %h(zX) changed to: + } + if( bLong ){ + @ 
    +          @ %h(zValue)
+          @
    + }else{ + @ "%h(zValue)" + } + } + if( blob_buffer(prev) && blob_size(prev) && !bAppend ){ + blob_truncate(prev,0); + } + if( nValue ) blob_appendb(prev, &val); + blob_reset(&val); + }else{ + if( bLong ){ + @ 
    +        @ %h(zValue)
+        @
    + }else{ + @ "%h(zValue)" + } + } + } + @
+} + +/* +** COMMAND: ticket* +** +** Usage: %fossil ticket SUBCOMMAND ... +** +** Run various subcommands to control tickets +** +** > fossil ticket show (REPORTTITLE|REPORTNR) ?TICKETFILTER? ?OPTIONS? +** +** Options: +** -l|--limit LIMITCHAR +** --quote +** -R|--repository REPO +** +** Run the ticket report, identified by the report format title +** used in the GUI. The data is written as flat file on stdout, +** using TAB as separator. The separator can be changed using +** the -l or --limit option. +** +** If TICKETFILTER is given on the command line, the query is +** limited with a new WHERE-condition. +** example: Report lists a column # with the uuid +** TICKETFILTER may be [#]='uuuuuuuuu' +** example: Report only lists rows with status not open +** TICKETFILTER: status != 'open' +** +** If --quote is used, the tickets are encoded by quoting special +** chars (space -> \\s, tab -> \\t, newline -> \\n, cr -> \\r, +** formfeed -> \\f, vtab -> \\v, nul -> \\0, \\ -> \\\\). +** Otherwise, the simplified encoding as on the show report raw page +** in the GUI is used. This has no effect in JSON mode. +** +** Instead of the report title it's possible to use the report +** number; the special report number 0 lists all columns defined in +** the ticket table. +** +** > fossil ticket list fields +** > fossil ticket ls fields +** +** List all fields defined for ticket in the fossil repository. +** +** > fossil ticket list reports +** > fossil ticket ls reports +** +** List all ticket reports defined in the fossil repository. +** +** > fossil ticket set TICKETUUID (FIELD VALUE)+ ?--quote? +** > fossil ticket change TICKETUUID (FIELD VALUE)+ ?--quote? +** +** Change ticket identified by TICKETUUID to set the values of +** each field FIELD to VALUE. +** +** Field names as defined in the TICKET table. By default, these +** names include: type, status, subsystem, priority, severity, foundin, +** resolution, title, and comment, but other field names can be added +** or substituted in customized installations. +** +** If you use +FIELD, the VALUE is appended to the field FIELD. You +** can use more than one field/value pair on the command line. Using +** --quote enables the special character decoding as in "ticket +** show", which allows setting multiline text or text with special +** characters. +** +** > fossil ticket add FIELD VALUE ?FIELD VALUE .. ? ?--quote? +** +** Like set, but create a new ticket with the given values. +** +** > fossil ticket history TICKETUUID +** +** Show the complete change history for the ticket +** +** Note that the values in set|add are not validated against the +** definitions given in "Ticket Common Script". +*/ +void ticket_cmd(void){ + int n; + const char *zUser; + const char *zDate; + const char *zTktUuid; + + /* do some ints, we want to be inside a check-out */ + db_find_and_open_repository(0, 0); + user_select(); + + zUser = find_option("user-override",0,1); + if( zUser==0 ) zUser = login_name(); + zDate = find_option("date-override",0,1); + if( zDate==0 ) zDate = "now"; + zDate = date_in_standard_format(zDate); + zTktUuid = find_option("uuid-override",0,1); + if( zTktUuid && (strlen(zTktUuid)!=40 || !validate16(zTktUuid,40)) ){ + fossil_fatal("invalid --uuid-override: must be 40 characters of hex"); + } + + /* + ** Check that the user exists. + */ + if( !db_exists("SELECT 1 FROM user WHERE login=%Q", zUser) ){ + fossil_fatal("no such user: %s", zUser); + } + + if( g.argc<3 ){ + usage("add|change|list|set|show|history"); + } + n = strlen(g.argv[2]); + if( n==1 && g.argv[2][0]=='s' ){ + /* set/show cannot be distinguished, so show the usage */ + usage("add|change|list|set|show|history"); + } + if(( strncmp(g.argv[2],"list",n)==0 ) || ( strncmp(g.argv[2],"ls",n)==0 )){ + if( g.argc==3 ){ + usage("list fields|reports"); + }else{ + n = strlen(g.argv[3]); + if( !strncmp(g.argv[3],"fields",n) ){ + /* simply show all field names */ + int i; + + /* read all available ticket fields */ + getAllTicketFields(); + for(i=0; i4 ){ + zFilterUuid = g.argv[4]; + } + rptshow( zRep, zSep, zFilterUuid, tktEncoding ); + } + }else{ + /* add a new ticket or update an existing ticket */ + enum { set,add,history,err } eCmd = err; + int i = 0; + Blob tktchng, cksum; + char *aUsed; + + /* get command type (set/add) and get uuid, if needed for set */ + if( strncmp(g.argv[2],"set",n)==0 || strncmp(g.argv[2],"change",n)==0 || + strncmp(g.argv[2],"history",n)==0 ){ + if( strncmp(g.argv[2],"history",n)==0 ){ + eCmd = history; + }else{ + eCmd = set; + } + if( g.argc==3 ){ + usage("set|change|history TICKETUUID"); + } + zTktUuid = db_text(0, + "SELECT tkt_uuid FROM ticket WHERE tkt_uuid GLOB '%q*'", g.argv[3] + ); + if( !zTktUuid ){ + fossil_fatal("unknown ticket: '%s'!",g.argv[3]); + } + i=4; + }else if( strncmp(g.argv[2],"add",n)==0 ){ + eCmd = add; + i = 3; + if( zTktUuid==0 ){ + zTktUuid = db_text(0, "SELECT lower(hex(randomblob(20)))"); + } + } + /* none of set/add, so show the usage! */ + if( eCmd==err ){ + usage("add|fieldlist|set|show|history"); + } + + /* we just handle history separately here, does not get out */ + if( eCmd==history ){ + Stmt q; + int tagid; + + if( i != g.argc ){ + fossil_fatal("no other parameters expected to %s!",g.argv[2]); + } + tagid = db_int(0, "SELECT tagid FROM tag WHERE tagname GLOB 'tkt-%q*'", + zTktUuid); + if( tagid==0 ){ + fossil_fatal("no such ticket %h", zTktUuid); + } + db_prepare(&q, + "SELECT datetime(mtime,toLocal()), objid, NULL, NULL, NULL" + " FROM event, blob" + " WHERE objid IN (SELECT rid FROM tagxref WHERE tagid=%d)" + " AND blob.rid=event.objid" + " UNION " + "SELECT datetime(mtime,toLocal()), attachid, filename, " + " src, user" + " FROM attachment, blob" + " WHERE target=(SELECT substr(tagname,5) FROM tag WHERE tagid=%d)" + " AND blob.rid=attachid" + " ORDER BY 1 DESC", + tagid, tagid + ); + while( db_step(&q)==SQLITE_ROW ){ + Manifest *pTicket; + const char *zDate = db_column_text(&q, 0); + int rid = db_column_int(&q, 1); + const char *zFile = db_column_text(&q, 2); + if( zFile!=0 ){ + const char *zSrc = db_column_text(&q, 3); + const char *zUser = db_column_text(&q, 4); + if( zSrc==0 || zSrc[0]==0 ){ + fossil_print("Delete attachment %s\n", zFile); + }else{ + fossil_print("Add attachment %s\n", zFile); + } + fossil_print(" by %s on %s\n", zUser, zDate); + }else{ + pTicket = manifest_get(rid, CFTYPE_TICKET, 0); + if( pTicket ){ + int i; + + fossil_print("Ticket Change by %s on %s:\n", + pTicket->zUser, zDate); + for(i=0; inField; i++){ + Blob val; + const char *z; + z = pTicket->aField[i].zName; + blob_set(&val, pTicket->aField[i].zValue); + if( z[0]=='+' ){ + fossil_print(" Append to "); + z++; + }else{ + fossil_print(" Change "); + } + fossil_print("%h: ",z); + if( blob_size(&val)>50 || contains_newline(&val)) { + fossil_print("\n "); + comment_print(blob_str(&val),0,4,-1,get_comment_format()); + }else{ + fossil_print("%s\n",blob_str(&val)); + } + blob_reset(&val); + } + } + manifest_destroy(pTicket); + } + } + db_finalize(&q); + return; + } + /* read all given ticket field/value pairs from command line */ + if( i==g.argc ){ + fossil_fatal("empty %s command aborted!",g.argv[2]); + } + getAllTicketFields(); + /* read command-line and assign fields in the aField[].zValue array */ + while( i