9c77dc1794e0885d85417037b5e49dc0fa1c9154 max Fri Dec 13 06:27:44 2019 -0800 adding link to geneReviews page from geneReviews track, suggested by Anna, no redmine (yet) diff --git src/hg/hgc/geneReviewsClick.c src/hg/hgc/geneReviewsClick.c index 65708c4..f207b20 100644 --- src/hg/hgc/geneReviewsClick.c +++ src/hg/hgc/geneReviewsClick.c @@ -1,33 +1,49 @@ /* geneReviewsClick - hgc code to display geneReviews track item detail page */ /* Copyright (C) 2014 The Regents of the University of California * See README in this or parent directory for licensing information. */ #include "common.h" #include "hgc.h" #include "geneReviewsClick.h" void doGeneReviews(struct trackDb *tdb, char *itemName) /* generate the detail page for geneReviews */ { struct sqlConnection *conn = hAllocConn(database); -//char *table = tdb->table; +char *table = tdb->table; int start = cartInt(cart, "o"); int num = 4; genericHeader(tdb, itemName); - genericBedClick(conn, tdb, itemName, start, num); + //removed genericBedClick(conn, tdb, itemName, start, num) and copied from there this more customized code + + char query[512]; + char **row; + struct bed *bed; + boolean hasBin = TRUE; + struct sqlResult *sr; + + sqlSafef(query, sizeof query, "select * from %s where name = '%s' and chrom = '%s' and chromStart = %d", + table, itemName, seqName, start); + sr = sqlGetResult(conn, query); + while ((row = sqlNextRow(sr)) != NULL) + { + bed = bedLoadN(row+hasBin, num); + printf("<B>Link to Gene Review:</B> <a href='https://www.ncbi.nlm.nih.gov/books/NBK1116/?term=%s' target=_blank>%s</a><BR>\n", bed->name, bed->name); + printPos(bed->chrom, bed->chromStart, bed->chromEnd, NULL, TRUE, bed->name); + } prGeneReviews(conn, itemName); printf("<BR>"); printTrackHtml(tdb); hFreeConn(&conn); } void prGeneReviews(struct sqlConnection *conn, char *itemName) /* print GeneReviews associated to this item Note: this print function has been replaced by addGeneReviewToBed.pl which print the same information to the field 5 of bigBed file */ { struct sqlResult *sr; char **row; char query[512];