sum数据，同样的sql利用minidao 和工具查出来的不一致

九月

使用minidao的日志打印：
userId:137********__dateStr:2018-06-06 15:29:51__sendflag:R
MiniDao-SQL:select SUM(outprem) redprem from lc_*** WHERE STR_TO_DATE(create_date,'%Y-%m-%d %H:%i:%s') BETWEEN startdate AND enddate
AND userid=:phone AND sendflag=:sendflag
sum:45.32__dateStr:2018-06-06 15:29:51

sql执行情况截图

求指点

admin

minidao 查出来多少

九月

minidao sum出的是45.32，实际应该是 51.50

九月

admin 发表于 2018-6-6 15:39
minidao 查出来多少

minidao sum出的是45.32，实际应该是 51.50

admin

代码贴出来，把日志打出来

九月

admin 发表于 2018-6-6 15:48
代码贴出来，把日志打出来

调用的地方
logger.info("----into --34-getRedpacketReward----userId:"+userId+"__dateStr:"+dateStr+"__sendflag:"+sendflag);
Map<String, BigDecimal> storeInfo = appRedpacketMiniDao.getRedEnvelopesReward(userId, dateStr, sendflag);
String sum=storeInfo.get("redprem")+"";
if (sum.equals("null")) {
        sum="";
}
logger.info("----into --34-getRedpacketReward----sum:"+sum+"__dateStr:"+dateStr);


定义的地方
@Arguments({"phone","pdate","sendflag"})
@Sql("select SUM(outprem) redprem from lc_rptotalpay WHERE STR_TO_DATE(create_date,'%Y-%m-%d %H:%i:%s') BETWEEN startdate AND enddate AND userid=:phone AND sendflag=:sendflag")
Map<String, BigDecimal> getRedEnvelopesReward(String phone,String pdate, String sendflag);

九月

九月 发表于 2018-6-6 15:55
调用的地方
logger.info("----into --34-getRedpacketReward----userId:"+userId+"__dateStr:"+dateStr+" ...

调用的地方
logger.info("----into --34-getRedpacketReward----userId:"+userId+"__dateStr:"+dateStr+"__sendflag:"+sendflag);
Map<String, BigDecimal> storeInfo = appRedpacketMiniDao.getRedEnvelopesReward(userId, dateStr, sendflag);
String sum=storeInfo.get("redprem")+"";
if (sum.equals("null")) {
        sum="";
}
logger.info("----into --34-getRedpacketReward----sum:"+sum+"__dateStr:"+dateStr);


定义的地方
@Arguments({"phone","pdate","sendflag"})
@Sql("select SUM(outprem) redprem from lc_rptotalpay WHERE STR_TO_DATE(create_date,'%Y-%m-%d %H:%i:%s') BETWEEN startdate AND enddate AND userid=:phone AND sendflag=:sendflag")
Map<String, BigDecimal> getRedEnvelopesReward(String phone,String pdate, String sendflag);


日志：
[2018-06-06 15:29:51] [INFO] [com.txsc.app.controller.AppRedpacketController:107] ----into --34-getRedpacketReward----userId:13716837204__dateStr:2018-06-06 15:29:51__sendflag:R
[2018-06-06 15:29:52] [INFO] [org.jeecgframework.minidao.aop.MiniDaoHandler:114] MiniDao-SQL:

select SUM(outprem) redprem from lc_rptotalpay WHERE STR_TO_DATE(create_date,'%Y-%m-%d %H:%i:%s') BETWEEN startdate AND enddate AND userid=:phone AND sendflag=:sendflag
[2018-06-06 15:29:52] [INFO] [com.txsc.app.controller.AppRedpacketController:113] ----into --34-getRedpacketReward----sum:45.32__dateStr:2018-06-06 15:29:51

admin

直接返回long 类型试试

九月

admin 发表于 2018-6-6 16:41
直接返回long 类型试试

还是不行
代码：
@Arguments({"phone","pdate","sendflag"})
        @Sql("select SUM(outprem) redprem from lc_rptotalpay WHERE STR_TO_DATE(create_date,'%Y-%m-%d %H:%i:%s') BETWEEN startdate AND enddate AND userid=:phone AND sendflag=:sendflag")
        Map<String, Long> getRedEnvelopesReward(String phone,String pdate, String sendflag);

日志：
[2018-06-06 18:20:12] [INFO] [com.txsc.app.controller.AppRedpacketController:107] ----into --34-getRedpacketReward----userId:13716837204__dateStr:2018-06-06 18:20:12__sendflag:R
[2018-06-06 18:20:12] [INFO] [org.jeecgframework.minidao.aop.MiniDaoHandler:114] MiniDao-SQL:
select SUM(outprem) redprem from lc_rptotalpay WHERE STR_TO_DATE(create_date,'%Y-%m-%d %H:%i:%s') BETWEEN startdate AND enddate AND userid=:phone AND sendflag=:sendflag
[2018-06-06 18:20:12] [INFO] [com.txsc.app.controller.AppRedpacketController:113] ----into --34-getRedpacketReward----sum:45.32__dateStr:2018-06-06 18:20:12

admin

那就是条件不对，你自己调试看看