人人开源 mybatis-plus map集合

Controll

 @RestController
@RequestMapping("bu/buwage")
public class BuWageController extends AbstractController {

//根据结算日期和机构ID，加载当前要处理的合同列表
    @RequestMapping("/queryAgencyContractByYMAgencyId")
    public R queryAgencyContractByYMAgencyId(@RequestParam Map<String, Object> params) {
        System.out.println(params.get("payoffYearMonth"));

        params.put("userId", getUserId());

        //查询列表数据
        List<Map> list = buWageService.queryAgencyContractByYMAgencyId(params);

        List<Map<Long, String>> listAgency = new ArrayList<Map<Long, String>>();
        for (Map obj : list) {
            Map map = new HashMap<Long, String>();
            map.put("buWageId", obj.get("wage_id"));
            map.put("payoffId", obj.get("payoff_id"));
            map.put("agencyContractId", obj.get("agency_contract_id"));
            map.put("contractNumber", obj.get("contract_number"));
            map.put("contractStartDate", obj.get("contract_start_date"));
            map.put("contractEndDate", obj.get("contract_end_date"));
            map.put("contractPeriod", obj.get("contract_period"));
            map.put("createTime", obj.get("create_time"));
            listAgency.add(map);
        }
        return R.ok().put("list", listAgency);
    }


}

Service

   public interface BuWageService extends IService<BuWageEntity> {

 //根据结算日期和机构ID，加载当前要处理的合同列表
    List<Map> queryAgencyContractByYMAgencyId(Map<String, Object> params);

}

Impl

   
@Service("buWageService")
public class BuWageServiceImpl extends ServiceImpl<BuWageDao, BuWageEntity> implements BuWageService {

 @Override
    public List<Map> queryAgencyContractByYMAgencyId(Map<String, Object> params) {
        return baseMapper.queryAgencyContractByYMAgencyId(params);
    }

}

Dao

@Mapper
public interface BuWageDao extends BaseMapper<BuWageEntity> {
   
    //根据结算日期和机构ID，加载当前要处理的合同列表
    List<Map> queryAgencyContractByYMAgencyId( Map<String, Object> params);

   
}

Mapper

    <!--返回list<MAP> 由结算月份和机构ID查询当前月可能的多个合同 ，也就是同一月可能签了多个合同-->
    <select id="queryAgencyContractByYMAgencyId" resultType="map">

        SELECT bp.id AS wage_id, b.create_time, bp.payoff_id  ,bp.agency_contract_id, hac.contract_number, hac.contract_start_date, hac.contract_end_date, hac.contract_period FROM  bu_wage bp
          LEFT JOIN bu_payoff b ON b.id = bp.payoff_id
          LEFT JOIN hr_agency_contract hac ON hac.id = bp.agency_contract_id
        WHERE bp.payoff_year_month = #{payoffYearMonth} AND  bp.agency_id = #{agencyId}

    </select>