@Override
public Collection<ZoneDeliveryModeValueModel> findDeliveryValues(
final DeliveryModeModel mode, final DistrictModel district) {
final StringBuilder strBdr = new StringBuilder();
strBdr
.append("SELECT {dmv.")
.append(ZoneDeliveryModeValueModel.PK)
.append("} ")
.append("FROM {")
.append(ZoneDeliveryModeValueModel._TYPECODE)
.append(" AS dmv}, ")
.append("{")
.append(ZoneModel._TYPECODE)
.append(" AS z}, ")
.append("{")
.append(ZoneDeliveryModeModel._TYPECODE)
.append(" AS zdm}, ")
.append("{")
.append(CurrencyModel._TYPECODE)
.append(" AS cur}, ")
.append("{")
.append(DistrictModel._TYPECODE)
.append(" AS d} ")
.append("WHERE {dmv.")
.append(ZoneDeliveryModeValueModel.CURRENCY)
.append("} = {cur.")
.append(CurrencyModel.PK)
.append("} ")
.append("AND {dmv.")
.append(ZoneDeliveryModeValueModel.DELIVERYMODE)
.append("} = {zdm.")
.append(ZoneDeliveryModeModel.PK)
.append("} ")
.append("AND {dmv.")
.append(ZoneDeliveryModeValueModel.ZONE)
.append("} = {z.")
.append(ZoneModel.PK)
.append("} ")
.append("AND {z.")
.append(ZoneModel.DISTRICT)
.append("} = {d.")
.append(DistrictModel.PK)
.append("} ")
.append("AND {cur.")
.append(CurrencyModel.ISOCODE)
.append("} = 'CNY' ")
.append("AND {d.")
.append(DistrictModel.PK)
.append("} = ?district ")
.append("AND {zdm.")
.append(ZoneDeliveryModeModel.PK)
.append("} = ?mode ")
.append("AND {z.")
.append(ZoneModel.REGION)
.append("} IS NULL ")
.append("AND {z.")
.append(ZoneModel.CITY)
.append("} IS NULL");
final HashMap<String, Object> params = new HashMap<>();
params.put("mode", mode);
params.put("district", district);
final FlexibleSearchQuery fQuery = new FlexibleSearchQuery(strBdr.toString());
fQuery.addQueryParameters(params);
fQuery.setResultClassList(Collections.singletonList(ZoneDeliveryModeValueModel.class));
final SearchResult<ZoneDeliveryModeValueModel> result =
getFlexibleSearchService().search(fQuery);
final Collection<ZoneDeliveryModeValueModel> vs1 = result.getResult();
if (CollectionUtils.isNotEmpty(vs1)) {
return vs1;
} else {
final CityModel city = district.getCity();
final Collection<ZoneDeliveryModeValueModel> vs2 = findDeliveryValues(mode, city);
if (CollectionUtils.isNotEmpty(vs2)) {
return vs2;
} else {
final RegionModel region = city.getRegion();
final Collection<ZoneDeliveryModeValueModel> vs3 = findDeliveryValues(mode, region);
if (CollectionUtils.isNotEmpty(vs3)) {
return vs3;
} else {
return findDeliveryValues(mode);
}
}
}
}
