");
/* Approximate size of input control in characters */
int size = fieldedTableMaxColChars(table, i);
if (size > maxLenField)
size = maxLenField;
/* Print input control getting previous value from cart. Set an id=
* so auto-suggest can find this control. */
char *oldVal = cartUsualString(cart, varName, "");
printf("\n");
else
printf(" value=\"%s\">\n", oldVal);
/* Write out javascript to reset page number to 1 if filter changes */
resetPageNumberOnChange(varName);
/* Set up the auto-suggest list for this filter */
if (suggestHash != NULL)
{
struct slName *suggestList = hashFindVal(suggestHash, field);
if (suggestList != NULL)
{
printSuggestScript(varName, suggestList);
}
}
printf("
\n");
}
printf("
");
}
static void showTableSortingLabelRow(struct fieldedTable *table, struct cart *cart, char *varPrefix,
char *returnUrl)
/* Put up the label row with sorting fields attached. ALso actually sort table. */
{
/* Get order var */
char orderVar[256];
safef(orderVar, sizeof(orderVar), "%s_order", varPrefix);
char *orderFields = cartUsualString(cart, orderVar, "");
char pageVar[64];
safef(pageVar, sizeof(pageVar), "%s_page", varPrefix);
/* Print column labels */
int i;
for (i=0; ifieldCount; ++i)
{
printf("
\n");
}
/* Sort on field */
if (!isEmpty(orderFields))
{
boolean doReverse = FALSE;
char *field = orderFields;
if (field[0] == '-')
{
field += 1;
doReverse = TRUE;
}
fieldedTableSortOnField(table, field, doReverse);
}
}
static void showTableDataRows(struct fieldedTable *table, int pageSize, int maxLenField,
struct hash *tagOutputWrappers, void *wrapperContext)
/* Render data rows into HTML */
{
int count = 0;
struct fieldedRow *row;
boolean isNum[table->fieldCount];
int i;
for (i=0; ifieldCount; ++i)
isNum[i] = fieldedTableColumnIsNumeric(table, i);
for (row = table->rowList; row != NULL; row = row->next)
{
if (++count > pageSize)
break;
printf("
\n");
int fieldIx = 0;
for (fieldIx=0; fieldIxfieldCount; ++fieldIx)
{
char shortVal[maxLenField+1];
char *longVal = emptyForNull(row->row[fieldIx]);
char *val = longVal;
int valLen = strlen(val);
if (maxLenField > 0 && maxLenField < valLen)
{
if (valLen > maxLenField)
{
memcpy(shortVal, val, maxLenField-3);
shortVal[maxLenField-3] = 0;
strcat(shortVal, "...");
val = shortVal;
}
}
if (isNum[fieldIx]) // vacuous, but left it just in case we want to do different stuff to numbers later
printf("
\n");
}
}
static void showTablePaging(struct fieldedTable *table, struct cart *cart, char *varPrefix,
struct fieldedTableSegment *largerContext, int pageSize)
/* If larger context exists and is bigger than current display, then draw paging controls. */
{
/* Handle paging if any */
if (largerContext != NULL) // Need to page?
{
if (pageSize < largerContext->tableSize)
{
int curPage = largerContext->tableOffset/pageSize;
int totalPages = (largerContext->tableSize + pageSize - 1)/pageSize;
char id[256];
if ((curPage + 1) > 1)
{
// first page
safef(id, sizeof id, "%s_first", varPrefix);
printf("⏮", id);
jsOnEventByIdF("click", id,
"$('[name=%s_page]').val('1');\n"
"$('#submit').click();\n"
, varPrefix);
printf(" ");
// prev page
safef(id, sizeof id, "%s_prev", varPrefix);
printf("⏪", id);
jsOnEventByIdF("click", id,
"$('[name=%s_page]').val('%d');\n"
"$('#submit').click();\n"
, varPrefix, (curPage+1)-1);
printf(" ");
}
printf("Displaying page ");
char pageVar[64];
safef(pageVar, sizeof(pageVar), "%s_page", varPrefix);
cgiMakeIntVar(pageVar, curPage+1, 3);
printf(" of %d", totalPages);
if ((curPage + 1) < totalPages)
{
// next page
printf(" ");
safef(id, sizeof id, "%s_next", varPrefix);
printf("⏩", id);
jsOnEventByIdF("click", id,
"$('[name=%s_page]').val('%d');\n"
"$('#submit').click();\n"
, varPrefix, (curPage+1)+1);
// last page
printf(" ");
safef(id, sizeof id, "%s_last", varPrefix);
printf("⏭", id);
jsOnEventByIdF("click", id,
"$('[name=%s_page]').val('%d');\n"
"$('#submit').click();\n"
, varPrefix, totalPages);
}
}
}
}
void webFilteredFieldedTable(struct cart *cart, struct fieldedTable *table,
char *returnUrl, char *varPrefix,
int maxLenField, struct hash *tagOutputWrappers, void *wrapperContext,
boolean withFilters, char *itemPlural,
int pageSize, struct fieldedTableSegment *largerContext, struct hash *suggestHash,
struct facetField **ffArray, char *visibleFacetList,
void (*addFunc)(int))
/* Show a fielded table that can be sorted by clicking on column labels and optionally
* that includes a row of filter controls above the labels .
* The maxLenField is maximum character length of field before truncation with ...
* Pass in 0 for no max */
{
if (strchr(returnUrl, '?') == NULL)
errAbort("Expecting returnUrl to include ? in showFieldedTable\nIt's %s", returnUrl);
if (withFilters || visibleFacetList)
showTableFilterInstructionsEtc(table, itemPlural, largerContext, addFunc, visibleFacetList);
-// Show top bar with quick-deselects for selected facet values
-// as well a clear restriction button that cleans out cdwFile_filter cart var.
-
if (visibleFacetList)
{
- char *where = cartUsualString(cart, "cdwFile_filter", "");
- if (!isEmpty(where))
- {
- // left column
- printf("
\n");
+ // Show top bar with quick-deselects for selected facet values
+ // as well a clear restriction button that cleans out cdwFile_filter cart var.
- printf("Restricting files to where %s. ", where);
+ struct dyString *facetBar = dyStringNew(1024);
- printf(" ");
- printf("");
- jsOnEventById("click", "clearRestrictionButton",
- "$('[name=cdwBrowseFiles_page]').val('1');\n"
- "$('[name=clearRestriction]').val('1');\n"
- "$('#submit').click();\n");
+ char *where = cartUsualString(cart, "cdwFile_filter", "");
- printf(" ");
- }
boolean gotSelected = FALSE;
struct slName *nameList = slNameListFromComma(visibleFacetList);
int f;
for (f = 0; f < table->fieldCount; ++f)
{
struct facetField *field = ffArray[f];
if (slNameInListUseCase(nameList, field->fieldName)) // i.e. is this field a visible facet?
{
if (!field->allSelected)
{
- if (!gotSelected)
- {
- if (isEmpty(where)) // we still need to do this
- {
- // left column
- printf("
\n");
+
struct slName *nameList = slNameListFromComma(visibleFacetList);
int f;
for (f = 0; f < table->fieldCount; ++f)
{
struct facetField *field = ffArray[f];
if (slNameInListUseCase(nameList, field->fieldName)) // i.e. is this field a visible facet?
{
htmlPrintf("
\n");
htmlPrintf("
%s
\n", field->fieldName);
struct facetVal *val;
if (!field->allSelected) // add reset facet link
{
char *op = "reset";
htmlPrintf("
\n");
}
else if (val->selectCount > 0)
{
++valuesNotShown;
}
}
// show "See More" link when facet has lots of values
if (valuesNotShown > 0)
{
char *op = "showAllValues";
htmlPrintf("
\n",
cartSessionVarName(), cartSessionId(cart),
op, field->fieldName, "", valuesNotShown
);
}
// show "See Fewer" link when facet has lots of values
if (field->showAllValues && valuesShown >= FacetFieldLimit)
{
char *op = "showSomeValues";
htmlPrintf("
\n");
// Clicking a checkbox is actually a click on the following link
jsInlineF(
"$(function () {\n"
" $('.cdwFSCheckBox').click(function() {\n"
" this.nextSibling.nextSibling.click();\n"
" });\n"
"});\n");
}
// start right column, if there are two columns
if (visibleFacetList)
printf("
");
if (largerContext != NULL)
showTablePaging(table, cart, varPrefix, largerContext, pageSize);
if (visibleFacetList) // close right column, if there are two columns
printf("
");
printf("
\n"); //close parent container
}
void webSortableFieldedTable(struct cart *cart, struct fieldedTable *table,
char *returnUrl, char *varPrefix,
int maxLenField, struct hash *tagOutputWrappers, void *wrapperContext)
/* Display all of table including a sortable label row. The tagOutputWrappers
* is an optional way to enrich output of specific columns of the table. It is keyed
* by column name and has for values functions of type webTableOutputWrapperType. */
{
webFilteredFieldedTable(cart, table, returnUrl, varPrefix,
maxLenField, tagOutputWrappers, wrapperContext,
FALSE, NULL,
slCount(table->rowList), NULL, NULL, NULL, NULL, NULL);
}
void webTableBuildQuery(struct cart *cart, char *from, char *initialWhere,
char *varPrefix, char *fields, boolean withFilters,
struct dyString **retQuery, struct dyString **retWhere)
/* Construct select, from and where clauses in query, keeping an additional copy of where
* Returns the SQL query and the SQL where expression as two dyStrings (need to be freed) */
{
struct dyString *query = dyStringNew(0);
struct dyString *where = dyStringNew(0);
struct slName *field, *fieldList = commaSepToSlNames(fields);
boolean gotWhere = FALSE;
sqlDyStringPrintf(query, "select %-s from %-s", sqlCkIl(fields), sqlCkIl(from));
if (!isEmpty(initialWhere))
{
sqlDyStringPrintfFrag(where, " where ");
sqlSanityCheckWhere(initialWhere, where);
gotWhere = TRUE;
}
/* If we're doing filters, have to loop through the row of filter controls */
if (withFilters)
{
for (field = fieldList; field != NULL; field = field->next)
{
char varName[128];
safef(varName, sizeof(varName), "%s_f_%s", varPrefix, field->name);
char *val = trimSpaces(cartUsualString(cart, varName, ""));
if (!isEmpty(val))
{
if (gotWhere)
sqlDyStringPrintf(where, " and ");
else
{
sqlDyStringPrintf(where, " where ");
gotWhere = TRUE;
}
if (anyWild(val))
{
char *converted = sqlLikeFromWild(val);
sqlDyStringPrintf(where, "%s like '%s'", field->name, converted);
freez(&converted);
}
else if (val[0] == '>' || val[0] == '<')
{
char *remaining = val+1;
if (remaining[0] == '=')
{
remaining += 1;
}
remaining = skipLeadingSpaces(remaining);
if (isNumericString(remaining))
{
sqlDyStringPrintf(where, "%s ", field->name);
if (val[0] == '>')
sqlDyStringPrintf(where, ">");
if (val[0] == '<')
sqlDyStringPrintf(where, "<");
if (val[1] == '=')
sqlDyStringPrintf(where, "=");
sqlDyStringPrintf(where, "%s", remaining);
}
else
{
warn("Filter for %s doesn't parse: %s", field->name, val);
sqlDyStringPrintf(where, "%s is not null", field->name); // Let query continue
}
}
else
{
sqlDyStringPrintf(where, "%s = '%s'", field->name, val);
}
}
}
}
sqlDyStringPrintf(query, "%-s", where->string); // trust
/* We do order here so as to keep order when working with tables bigger than a page. */
char orderVar[256];
safef(orderVar, sizeof(orderVar), "%s_order", varPrefix);
char *orderFields = cartUsualString(cart, orderVar, "");
if (!isEmpty(orderFields))
{
if (orderFields[0] == '-')
sqlDyStringPrintf(query, " order by %s desc", orderFields+1);
else
sqlDyStringPrintf(query, " order by %s", orderFields);
}
// return query and where expression
*retQuery = query;
*retWhere = where;
}
void webFilteredSqlTable(struct cart *cart, struct sqlConnection *conn,
char *fields, char *from, char *initialWhere,
char *returnUrl, char *varPrefix, int maxFieldWidth,
struct hash *tagOutWrappers, void *wrapperContext,
boolean withFilters, char *itemPlural, int pageSize, struct hash *suggestHash, char *visibleFacetList,
void (*addFunc)(int) )
/* Given a query to the database in conn that is basically a select query broken into
* separate clauses, construct and display an HTML table around results. This HTML table has
* column names that will sort the table, and optionally (if withFilters is set)
* it will also allow field-by-field wildcard queries on a set of controls it draws above
* the labels.
* Much of the functionality rests on the call to webFilteredFieldedTable. This function
* does the work needed to bring in sections of potentially huge results sets into
* the fieldedTable. */
{
struct dyString *query;
struct dyString *where;
webTableBuildQuery(cart, from, initialWhere, varPrefix, fields, withFilters, &query, &where);
char *selectedFacetValues=cartUsualString(cart, "cdwSelectedFieldValues", "");
struct facetField **ffArray = NULL;
struct fieldedTable *table = NULL;
char pageVar[64];
safef(pageVar, sizeof(pageVar), "%s_page", varPrefix);
int page = 0;
struct fieldedTableSegment context;
page = cartUsualInt(cart, pageVar, 0) - 1;
if (page < 0)
page = 0;
context.tableOffset = page * pageSize;
if (visibleFacetList)
{
table = fieldedTableAndCountsFromDbQuery(conn, query->string, pageSize, context.tableOffset, selectedFacetValues, &ffArray, &context.tableSize);
}
else
{
/* Figure out size of query result */
struct dyString *countQuery = sqlDyStringCreate("select count(*) from %-s", sqlCkIl(from));
sqlDyStringPrintf(countQuery, "%-s", where->string); // trust
context.tableSize = sqlQuickNum(conn, countQuery->string);
dyStringFree(&countQuery);
}
if (context.tableSize > pageSize)
{
int lastPage = (context.tableSize-1)/pageSize;
if (page > lastPage)
page = lastPage;
context.tableOffset = page * pageSize;
}
if (!visibleFacetList)
{
sqlDyStringPrintf(query, " limit %d offset %d", pageSize, context.tableOffset);
table = fieldedTableFromDbQuery(conn, query->string);
}
webFilteredFieldedTable(cart, table, returnUrl, varPrefix, maxFieldWidth,
tagOutWrappers, wrapperContext, withFilters, itemPlural, pageSize, &context, suggestHash, ffArray, visibleFacetList, addFunc);
fieldedTableFree(&table);
dyStringFree(&query);
dyStringFree(&where);
}