lidongdong
2023-09-08 6415c7935fc9cffa70b35deecb3a63ae0627698a
修改商家列表没有上架商品数量
2个文件已修改
6 ■■■■■ 已修改文件
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/entity/VolunteerMerchant.java 4 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/VolunteerMerchantMapper.xml 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/entity/VolunteerMerchant.java
@@ -154,6 +154,10 @@
    @ApiModelProperty(value = "商家评分")
    private String merchantGrade;
    @TableField(exist = false)
    @ApiModelProperty(value = "商家商品数量")
    private String goodNum;
    @ApiModelProperty(value = "商家积分")
    private String merchantIntegral;
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/VolunteerMerchantMapper.xml
@@ -41,6 +41,8 @@
        (select su.name from sys_user as su where su.user_id=volunteer_merchant.user_id) as merchantLinkman,
        (select vt.name from volunteer_type as vt where vt.id=volunteer_merchant.merchant_type) as merchantTypeName,
        (SELECT ROUND(AVG(vme.evaluate_grade), 1) FROM volunteer_merchant_evaluate as vme WHERE vme.merchant_id=volunteer_merchant.id) as merchantGrade,
        (select count(vim.id) from volunteer_integral_merchant as vim
            where vim.merchant_id=volunteer_merchant.id and vim.state='1') as goodNum,
        service_call,
        merchant_content,
        merchant_url,