Controller
shopList = shopService.queryStoreEmp(new QueryWrapper<RetailShop>()
.select("sh_emp_id,sh_emp_name,sum(sh_sellamount) as sh_sellamount,sum(sh_sellmonery) as sh_sellmonery," +
"(sum(sh_sellmonery) - sum(sh_costmonery)) as sh_maoli_sum,sum(bea_money) as bea_money,be_photo")
.eq("a.ei_id", emp.getEi_id()).eq("sh_si_id", emp.getSi_id())
.apply("DATE_FORMAT( sh_selldate, '%Y%m' ) = DATE_FORMAT( CURDATE( ) , '%Y%m' )")
.groupBy("sh_emp_id").orderByDesc("bea_money","sh_sellamount","sh_sellmonery","sh_maoli_sum"));
service
List<RetailShop> queryStoreEmp(QueryWrapper wrapper);
serviceImpl
@Override
public List<RetailShop> queryStoreEmp(QueryWrapper wrapper) {