按钮js:

_g().getWidgetByName('report5').gotoPage(1, {

"$fd_agentofpurchaser": "",

}, 'T');

_g().getWidgetByName('report5_c').gotoPage(1, {

"$fd_purchaser": "",

}, 'T');

_g().getWidgetByName("fd_nian_q").reset();

_g().getWidgetByName('fd_xmxz_q').reset();

_g().getWidgetByName('fd_xmqy_q').reset();

SQL:

SELECT    fd_purchaser,    COUNT(*) AS projectCount,    SUM( fd_contract_amount ) AS zhongbiaojine,    ( SELECT SUM( fd_contract_amount ) FROM ekp_database_procurement     WHERE 1=1${if(len(fd_agentofpurchaser) == 0, "", "and fd_agentofpurchaser = '" + fd_agentofpurchaser + "'" )} ${if(len(fd_nian_q) == 0, "", "and YEAR ( fd_dateofaward ) = '" + fd_nian_q + "'" )}${if(len(fd_xmxz_q) == 0, "", "and fd_xiangmuxingzhi = '" + fd_xmxz_q + "'" )} ${if(len(fd_xmqy_q) == 0, "", "and fd_region = '" + fd_xmqy_q + "'" )}    ) as fd_allFROM    ekp_database_procurement WHERE1=1 ${if(len(fd_agentofpurchaser) == 0, "", "and fd_agentofpurchaser = '" + fd_agentofpurchaser + "'" )} ${if(len(fd_nian_q) == 0, "", "and YEAR ( fd_dateofaward ) = '" + fd_nian_q + "'" )}${if(len(fd_xmxz_q) == 0, "", "and fd_xiangmuxingzhi = '" + fd_xmxz_q + "'" )} ${if(len(fd_xmqy_q) == 0, "", "and fd_region = '" + fd_xmqy_q + "'" )}GROUP BY  fd_purchaserORDER BY  SUM(fd_contract_amount) DESC

点击按钮，重置失败，我感觉我写的没问题