销售表:sale_manager。客户表:customer_manager
根据销售ID连接两个表
部分字段:
销售表
客户表
service层
@Override
public IPage<CustomerVO> findCustomers(Page page, CustomerManager customerManager) {
QueryWrapper<CustomerManager> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("c.del_flag",0)
.like(StringUtil.isNotBlank(customerManager.getCompanyFullname()),"c.company_fullname",customerManager.getCompanyFullname())
.apply("c.sale_id = s.sale_id")
.orderByDesc("c.create_time");
return customerManagerMapper.findCustomer(page,queryWrapper);
}
mapper层
/**
* 动态查询
*/
@Select("SELECT c.customer_id," +
"c.company_fullname," +
"s.sale_name," +
"c.create_time," +
"c.park_id," +
"c.del_flag," +
"c.customer_status" +
" FROM customer_manager c,sale_manager s" +
" ${ew.customSqlSegment}")
IPage<CustomerVO> findCustomer(IPage<CustomerVO> page, @Param("ew")Wrapper wrapper);
结果省略。。。。。。。。。。。。。