feat(product): 添加产品列表查询功能

liyong

10 天以前 099e8a366eb8e69601371229d4ff4acad725e463

feat(product): 添加产品列表查询功能

 src/main/java/com/ruoyi/stock/dto/StockInventoryDto.java

@@ -43,4 +43,30 @@

    @ApiModelProperty("父ID")
    private  Long parentId;

    /**
     * 产品图片
     */
//    @Excel(name = "产品图片")
    private String url;

    /**
     * 高度
     */
    private String height;

    /**
     * 每件数量/支
     */
    private String boxNum;

    /**
     * 单价(美元)/件
     */
    private String dollarPrice;

    /**
     * 单价(元)/件
     */
    private String taxInclusiveUnitPrice;
}

 src/main/resources/mapper/stock/StockInventoryMapper.xml

@@ -64,7 +64,12 @@
        pm.model,
        si.remark,
        pm.unit,
        p.product_name
        p.product_name,
        pm.url,
        pm.height,
        pm.box_num,
        pm. dollar_price,
        pm.tax_inclusive_unit_price
        from stock_inventory si
        left join product_model pm on si.product_model_id = pm.id
        left join product p on pm.product_id = p.id