| | |
| | | @ApiModelProperty(value = "商家类型名称") |
| | | private String merchantTypeName; |
| | | |
| | | @ApiModelProperty(value = "商家评分") |
| | | private String merchantGrade; |
| | | |
| | | @ApiModelProperty(value = "商家积分") |
| | | private String merchantIntegral; |
| | |
| | | @PostMapping("/unmount") |
| | | public R VolunteerIntegralMerchantUnmount(@RequestBody VolunteerIntegralMerchantVO vimVO) |
| | | { |
| | | vimVO.setGoodType("1"); |
| | | return vtService.VolunteerIntegralMerchantUnmount(vimVO); |
| | | } |
| | | |
| | |
| | | @ApiModelProperty(value = "商家类型名称") |
| | | private String merchantTypeName; |
| | | |
| | | @TableField(exist = false) |
| | | @ApiModelProperty(value = "商家评分") |
| | | private String merchantGrade; |
| | | |
| | | @ApiModelProperty(value = "商家积分") |
| | | private String merchantIntegral; |
| | | |
| | |
| | | (select su.phone from sys_user as su where su.user_id=volunteer_merchant.user_id) as merchantPhone, |
| | | (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, |
| | | service_call, |
| | | merchant_content, |
| | | merchant_url, |
| | |
| | | and (volunteer_merchant.name like concat('%',#{name},'%')) |
| | | </if> |
| | | </where> |
| | | order by creation_time desc |
| | | order by merchantGrade desc,creation_time desc |
| | | </select> |
| | | |
| | | <insert id="insertData"> |