588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
|
azYear = fossil_realloc(azYear, sizeof(char*)*(n+2));
azYear[n] = fossil_strdup(db_column_text(&q,0));
azYear[n+1] = azYear[n];
if( !isValidYear && fossil_strcmp(zYear,azYear[n])==0 ) isValidYear = 1;
n += 2;
}
db_finalize(&q);
if( !isValidYear ) zYear = azYear[0];
style_submenu_multichoice("y", n/2, (const char**)azYear, 0);
cgi_printf("<br/>");
db_prepare(&q,
"SELECT DISTINCT strftime('%%W',mtime) AS wk, "
" count(*) AS n "
" FROM v_reports "
" WHERE %Q=substr(date(mtime),1,4) "
|
|
>
>
>
>
>
>
|
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
|
azYear = fossil_realloc(azYear, sizeof(char*)*(n+2));
azYear[n] = fossil_strdup(db_column_text(&q,0));
azYear[n+1] = azYear[n];
if( !isValidYear && fossil_strcmp(zYear,azYear[n])==0 ) isValidYear = 1;
n += 2;
}
db_finalize(&q);
if( !isValidYear ){
if( n ){
zYear = azYear[0];
}else{
zYear = db_text("1970","SELECT substr(date('now'),1,4);");
}
}
style_submenu_multichoice("y", n/2, (const char**)azYear, 0);
cgi_printf("<br/>");
db_prepare(&q,
"SELECT DISTINCT strftime('%%W',mtime) AS wk, "
" count(*) AS n "
" FROM v_reports "
" WHERE %Q=substr(date(mtime),1,4) "
|