| | |
| | | @ApiModelProperty(value = "商家评分") |
| | | private String merchantGrade; |
| | | |
| | | @TableField(exist = false) |
| | | @ApiModelProperty(value = "商家商品数量") |
| | | private String goodNum; |
| | | |
| | | @ApiModelProperty(value = "商家积分") |
| | | private String merchantIntegral; |
| | | |
| | |
| | | (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, |