@Select("<script>" +
"select cab.brandpre_id,cab.brandpre_num_app,cab.id,cab.brandpre_num_approve,cab.brandpre_moneyamount,cab.pid ,\n" +
"cbp.material_code,cbp.material_identification,cbp.material_name,cbp.price from crm_activity_brandpre cab \n" +
"left join crm_brand_presentation cbp on cab.brandpre_id=cbp.id\n" +
"<where> " +
"cab.dr=0 " +
"<if test='map !=null'>" +
"<choose>" +
"<when test='map.keys.size > 0'>" +
" <foreach collection='map.keys' item='key' open='and' separator='AND'>" +
" cab.${key} like concat('%',#{map[${key}]},'%') " +
" </foreach>" +
"</when>" +
"<otherwise>" +
" and 1=1 " +
"</otherwise>" +
"</choose>" +
"</if>" +
"</where>" +
"LIMIT #{pageindex},#{pagenum} " +
"</script>")
List<ActivityAppBrandpreInfoDO> selectAppBrandpreAll(@Param("pageindex") Integer pageindex,
@Param("pagenum") Integer pagenum, @Param("map") Map<String, String> map);