src/hg/hgc/t2g.c 1.3

Index: src/hg/hgc/t2g.c
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/hgc/t2g.c,v
retrieving revision 1.2
retrieving revision 1.3
diff -b -B -U 1000000 -r1.2 -r1.3
--- src/hg/hgc/t2g.c	20 May 2010 19:14:15 -0000	1.2
+++ src/hg/hgc/t2g.c	20 May 2010 20:56:37 -0000	1.3
@@ -1,149 +1,145 @@
 /* t2g.c - display details of text2genome stuff */
 
 #include "common.h"
 #include "jksql.h"
 #include "hdb.h"
 #include "hgc.h"
 #include "trackDb.h"
 #include "web.h"
 #include "hash.h"
 
 void printPubmedLink(char* pmid) 
 {
-    printf("<A HREF=\"http://www.ncbi.nlm.nih.gov/pubmed/%s\">PubMed</A>", pmid);
+    printf("<B>PubMed:</B>&nbsp;<A HREF=\"http://www.ncbi.nlm.nih.gov/pubmed/%s\" TARGET=_blank>%s</A><BR>\n", pmid, pmid);
 }
 
 void printPmcLink(char* pmcId) 
 {
-    printf("<A HREF=\"http://www.ncbi.nlm.nih.gov/pmc/articles/PMC%s/?tool=pubmed\">PubmedCentral</A>", pmcId);
+    printf("<B>PubMed&nbsp;Central:</B>&nbsp;<A HREF=\"http://www.ncbi.nlm.nih.gov/pmc/articles/PMC%s/?tool=pubmed\" TARGET=_blank>%s</A><BR>\n", pmcId, pmcId);
 }
 
 void printT2gLink(char* pmcId) 
 {
-    printf("<A HREF=\"http://kumiho.smith.man.ac.uk/bergman/text2genome/inspector.cgi?pmcId=%s\">text2genome</A>", pmcId);
+    printf("<B>Text2Genome:</B>&nbsp;<A HREF=\"http://kumiho.smith.man.ac.uk/bergman/text2genome/inspector.cgi?pmcId=%s\" TARGET=_blank>%s</A><BR>\n", pmcId, pmcId);
 }
 
 void printLinks(char* pmid, char* pmcId) 
 {
-    printf("Links: ");
-    printf("<SMALL>");
     printT2gLink(pmcId);
-    printf(", ");
     printPubmedLink(pmid);
-    printf(", ");
     printPmcLink(pmcId);
-    printf("</SMALL><P>");
+    printf("<BR>\n");
 }
 
 char* printArticleInfo(struct sqlConnection *conn, struct trackDb* tdb, char* item) 
 /* Header with information about paper, return documentId */
 {
     char query[512];
     char* articleTable = hashMustFindVal(tdb->settingsHash, "articleTable");
 
     safef(query, sizeof(query), "SELECT pmid, pmcId, title,authors, abstract FROM %s WHERE displayId='%s'", articleTable, item);
     struct sqlResult *sr = sqlGetResult(conn, query);
     char **row;
     char *docId=0;
     if ((row = sqlNextRow(sr)) != NULL)
 	{
 	printLinks(row[0], row[1]);
 	printf("<b>%s</b><p>", row[2]);
 	printf("<small>%s</small><p>", row[3]);
 	printf("<small>%s</small>", row[4]);
         docId = row[1];
 	}
     sqlFreeResult(&sr);
     return docId;
 }
 
 void printSeqInfo(struct sqlConnection* conn, struct trackDb* tdb,  char* docId) {
     /* print table of sequences */
     char query[512];
     char* sequenceTable = hashMustFindVal(tdb->settingsHash, "sequenceTable");
     safef(query, sizeof(query), "SELECT seqId, sequence FROM %s WHERE pmcId='%s'", sequenceTable, docId);
     struct sqlResult *sr = sqlGetResult(conn, query);
     char **row;
 
     webNewSection("Sequences in article");
 	webPrintLinkTableStart();
     while ((row = sqlNextRow(sr)) != NULL)
 	{
         webPrintLinkCell(row[1]);
         webPrintLinkTableNewRow();
         //printf("%s<br>", row[1]);
 	}
 	webPrintLinkTableEnd();
 
     sqlFreeResult(&sr);
     printTrackHtml(tdb);
 }
 
 void doT2gDetails(struct trackDb *tdb, char *item)
 /* text2genome.org custom display */
 {
 char versionString[256];
 char dateReference[256];
 char headerTitle[512];
 char **row = NULL;
 char query[512];
 struct sqlResult *sr = NULL;
 struct sqlConnection *conn = hAllocConn(database); // where the heck does "database" come from?
 safef(query, sizeof(query), "select chrom,chromStart,chromEnd,strand from %s "
       "where name = '%s'", tdb->table, item);
 sr = sqlGetResult(conn, query);
 row = sqlNextRow(sr);
 char *chr = cloneString(row[0]);
 int start = sqlUnsigned(row[1]);
 int end = sqlUnsigned(row[2]);
 char strand[2];
 strand[0] = row[3][0];
 strand[1] = (char)NULL;
 sqlFreeResult(&sr);
 
 /* see if hgFixed.trackVersion exists */
 boolean trackVersionExists = hTableExists("hgFixed", "trackVersion");
 
 if (trackVersionExists)
     {
     char query[256];
     safef(query, sizeof(query), "select version,dateReference from hgFixed.trackVersion where db = '%s' AND name = 't2g' order by updateTime DESC limit 1", database);
     struct sqlResult *sr = sqlGetResult(conn, query);
     char **row;
 
     /* in case of NULL result from the table */
     versionString[0] = 0;
     while ((row = sqlNextRow(sr)) != NULL)
 	{
 	safef(versionString, sizeof(versionString), "version %s",
 		row[0]);
 	safef(dateReference, sizeof(dateReference), "%s",
 		row[1]);
 	}
     sqlFreeResult(&sr);
     }
 else
     {
     versionString[0] = 0;
     dateReference[0] = 0;
     }
 
 if (versionString[0])
     safef(headerTitle, sizeof(headerTitle), "%s - %s", item, versionString);
 else
     safef(headerTitle, sizeof(headerTitle), "%s", item);
 
 genericHeader(tdb, headerTitle);
-
-printPos(chr, start, end, strand, TRUE, item);
+printPos(chr, start, end, strand, FALSE, item);
 freeMem(chr);
-char* docId=0;
-docId = printArticleInfo(conn, tdb, item);
+
+char* docId = printArticleInfo(conn, tdb, item);
+
 
 if (docId!=0) 
 {
     printSeqInfo(conn, tdb, docId);
 }
 hFreeConn(&conn);
 }