DROP TABLE IF EXISTS `ad_items`;
CREATE TABLE `ad_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `type` int(3) DEFAULT NULL COMMENT '分類，1首頁推廣,2列表頁推廣',
  `sku_id` varchar(60) DEFAULT NULL COMMENT '展示的產品',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8;

@Data
@AllArgsConstructor
@NoArgsConstructor
//MyBatisPlus表映射註解
@TableName(value = "ad_items")
public class AdItems implements Serializable{

    @TableId(type = IdType.AUTO)
    private Integer id;
    private String name;
    private Integer type;
    private String skuId;
    private Integer sort;
}

public interface AdItemsMapper extends BaseMapper<AdItems> {
}

public interface SkuService extends IService<Sku> {
    /**
     * 根據推廣產品分類ID查詢Sku列表
     * @param id
     * @return
     */
    List<Sku> typeSkuItems(Integer id);
}

@Service
public class SKuServiceImpl extends ServiceImpl<SkuMapper, Sku> implements SkuService {

    @Resource
    private AdItemsMapper adItemsMapper;

    @Resource
    private SkuMapper skuMapper;


    @Override
    public List<Sku> typeSkuItems(Integer id) {
        //1.查詢當前分類下的所有列表資訊
        QueryWrapper<AdItems> adItemsQueryWrapper = new QueryWrapper<AdItems>();
        adItemsQueryWrapper.eq("type",id);
        List<AdItems> adItems = adItemsMapper.selectList(adItemsQueryWrapper);

        //2.根據推廣列表查詢產品列表資訊
        List<String> skuids = adItems.stream().map(adItem->adItem.getSkuId()).collect(Collectors.toList());
        return skuids==null || skuids.size()<=0? null : skuMapper.selectBatchIds(skuids);
    }
}

@RestController
@RequestMapping(value = "/sku")
public class SkuController {
    @Autowired
    private SkuService skuService;

    /****
     * 根據推廣分類查詢推廣產品列表
     *
     */
    @GetMappingpublic List<Sku> typeItems(@RequestParam(value = "id")Integer id){
        //查詢
        List<Sku> skus = skuService.typeSkuItems(id);
        return skus;
    }
}