Merge remote-tracking branch 'origin/api' into api
 
	
	
	
	
	
	
	
	
	
	
	
	
	
 |  |  | 
 |  |  |     @Override | 
 |  |  |     public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception { | 
 |  |  |         if ("dev".equals(evn)) { | 
 |  |  |             SysUsers sysUsers = sysUsersDao.selectById(1012L); | 
 |  |  |             SysUsers sysUsers = sysUsersDao.selectById(1073L); | 
 |  |  |             request.getSession().setAttribute(MatrixConstance.LOGIN_KEY, sysUsers); | 
 |  |  |             return true; | 
 |  |  |         } | 
 
 |  |  | 
 |  |  |             sum(IFNULL(free_consume, 0)) freeConsume, | 
 |  |  |             sum(IFNULL(proj_percentage, 0)) projCommission | 
 |  |  |         from achieve_new a | 
 |  |  |         left join sys_order b on a.beault_id=b.STAFF_ID and (date_format(b.ORDER_TIME, '%Y-%m-%d') >= date_format(#{startTime}, '%Y-%m-%d') and date_format(#{endTime}, '%Y-%m-%d') >= date_format(b.ORDER_TIME, '%Y-%m-%d')) | 
 |  |  |         where a.beault_id=#{userId} and a.order_type = '订单' | 
 |  |  |         and (date_format(datatime, '%Y-%m-%d') >= date_format(#{startTime}, '%Y-%m-%d') and date_format(#{endTime}, '%Y-%m-%d') >= date_format(datatime, '%Y-%m-%d')) | 
 |  |  |     </select> |