sql = "select t3.PRODNAME as label,ifnull(t1.Nums1,0)-ifnull(t2.Nums2,0) as value from "
+" (select sum(a.num) Nums1,PRODUCTS_ID from jxc_t_outbound_detailed a"
+" LEFT JOIN jxc_t_outbound_info b on a.OUTBOUND_ID=b.ID"
+" where left(d.TIME,7)='2016-05' GROUP BY PRODUCTS_ID"
+" ) t1 "
+" left join (select sum(c.num) Nums2,PRODUCTS_ID from jxc_t_outbound_revise_detailed c"
+" LEFT JOIN jxc_t_outbound_revise d on c.OUTBOUND_REVISE_ID=d.ID"
+" where left(d.TIME,7)='2016-05'"
+" GROUP BY PRODUCTS_ID"
+" ) t2 on t1.PRODUCTS_ID=t2.PRODUCTS_ID"
+" LEFT JOIN jxc_t_products t3 ON t1.PRODUCTS_ID=t3.ID"
+" order by value LIMIT 10";
中where left(d.TIME,7)='2016-05'怎么修改呀!按本周来表示!
public static String getThisWeek() {
Calendar c = Calendar.getInstance();
int dayofweek = c.get(Calendar.DAY_OF_WEEK) - 1;
if (dayofweek == 0)
dayofweek = 7;
c.add(Calendar.DATE, -dayofweek + 1);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
return sdf.format(c.getTime())+7;
}
这是获得本周的代码!怎么把sql和这段代码链接起来呀!