Merge remote-tracking branch 'origin/master'
6 files modified
32 files added
| | |
| | | and jda.town_street_name like concat('%',#{gridWorkLog.townName},'%') |
| | | </if> |
| | | <if test="gridWorkLog.neiName!=null and gridWorkLog.neiName!=''"> |
| | | and jda.nei_name like concat('%',#{household.neiName},'%') |
| | | and jda.nei_name like concat('%',#{gridWorkLog.neiName},'%') |
| | | </if> |
| | | <if test="gridWorkLog.regionCode!=null and gridWorkLog.regionCode!=''"> |
| | | and jg.community_code like concat('%',#{gridWorkLog.regionCode},'%') |
| | |
| | | |
| | | private final IHouseholdService householdService; |
| | | |
| | | |
| | | /** |
| | | * 住户 详情 |
| | | */ |
| | |
| | | return R.data(householdService.userHandle()); |
| | | } |
| | | |
| | | /** |
| | | * 获取所有住户 |
| | | * @return |
| | | */ |
| | | @GetMapping("/getAllHouseHold") |
| | | public R getAllHouseHold(HouseholdVO household) { |
| | | return R.data(householdService.getAllHouseHold(household)); |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | } |
| | |
| | | */ |
| | | List<HouseholdVO> selectHouseholdPage(IPage page,@Param("household") HouseholdVO household); |
| | | |
| | | /** |
| | | * 获取全部 |
| | | * @param household |
| | | * @return |
| | | */ |
| | | List<HouseholdVO> getAllHouseHold(@Param("household")HouseholdVO household); |
| | | |
| | | |
| | | /** |
| | | * 查询房屋集合信息 |
| | |
| | | * @return |
| | | */ |
| | | List<HouseholdEntity> getNotInsertUserHousehold(); |
| | | |
| | | |
| | | } |
| | |
| | | |
| | | </select> |
| | | |
| | | <select id="getAllHouseHold" resultMap="householdPageAndLabelMap"> |
| | | SELECT |
| | | jh.id, |
| | | jh.house_code, |
| | | jh.NAME, |
| | | jh.phone_number, |
| | | jh.associated_user_id, |
| | | jh.role_type, |
| | | jh.associated_user_name, |
| | | jh.relationship, |
| | | jh.is_primary_contact, |
| | | jh.residential_status, |
| | | jh.birthday, |
| | | jh.id_card, |
| | | jh.hkmt_pass, |
| | | jh.passport, |
| | | ifnull( jh.gender, CASE WHEN substring( jh.id_card, 17, 1 )% 2 = 1 THEN 1 ELSE 0 END ) AS gender, |
| | | jh.ethnicity, |
| | | jh.education, |
| | | jh.hukou_registration, |
| | | jh.work_status, |
| | | employer, |
| | | jh.marital_status, |
| | | jh.card_number, |
| | | jh.other_contact, |
| | | jh.current_address, |
| | | jh.disability_cert, |
| | | jh.party_ember, |
| | | jh.create_user, |
| | | jh.create_time, |
| | | jh.update_user, |
| | | jh.update_time, |
| | | jh.confirm_flag, |
| | | jh.remark, |
| | | jhs.district_name aoiName, |
| | | concat( jhs.building, " ", unit, " ", room ) AS address, |
| | | jda.town_street_name AS townStreetName, |
| | | jda.nei_name AS neiName, |
| | | jg.grid_name |
| | | FROM |
| | | jczz_household jh |
| | | LEFT JOIN jczz_house jhs ON jh.house_code = jhs.house_code and jhs.is_deleted = 0 |
| | | LEFT JOIN jczz_doorplate_address jda ON jda.address_code = jh.house_code |
| | | LEFT JOIN jczz_grid_range jgr on jgr.house_code=jda.address_code |
| | | LEFT JOIN jczz_grid jg on jg.id = jgr.grid_id |
| | | <where> |
| | | <if test="household.userId!=null"> |
| | | AND jg.id IN ( SELECT DISTINCT jgm.grid_id FROM jczz_gridman jgm WHERE jgm.user_id = #{household.userId} |
| | | ) |
| | | </if> |
| | | <if test="household.name!=null and household.name !=''"> |
| | | and jh.name like concat('%',#{household.name},'%') |
| | | </if> |
| | | <if test="household.houseCode!=null and household.houseCode !=''"> |
| | | and jh.house_code = #{household.houseCode} |
| | | </if> |
| | | <if test="household.phoneNumber!=null and household.phoneNumber !=''"> |
| | | and jh.phone_number like concat('%',#{household.phoneNumber},'%') |
| | | </if> |
| | | <if test="household.idCard!=null and household.idCard !=''"> |
| | | and jh.id_card like concat('%',#{household.idCard},'%') |
| | | </if> |
| | | <if test="household.aoiName!=null and household.aoiName !=''"> |
| | | and jhs.district_name like concat('%',#{household.aoiName},'%') |
| | | </if> |
| | | <if test="household.confirmFlag != null "> |
| | | and jh.confirm_flag = #{household.confirmFlag} |
| | | </if> |
| | | <if test="household.townStreetName!=null and household.townStreetName!=''"> |
| | | and jda.town_street_name like concat('%',#{household.townStreetName},'%') |
| | | </if> |
| | | <if test="household.neiName!=null and household.neiName!=''"> |
| | | and jda.nei_name like concat('%',#{household.neiName},'%') |
| | | </if> |
| | | <if test="household.housingRentalId != null "> |
| | | and jh.housing_rental_id = #{household.housingRentalId} |
| | | </if> |
| | | <if test="household.startTime != null and household.startTime != '' and household.endTime != null and household.endTime != '' "> |
| | | AND jh.create_time BETWEEN #{household.startTime} and #{household.endTime} |
| | | </if> |
| | | <if test="household.regionCode!=null and household.regionCode!=''"> |
| | | and jg.community_code like concat('%',#{household.regionCode},'%') |
| | | </if> |
| | | <if test="household.id!=null and household.id!=''"> |
| | | and jh.id = #{household.id} |
| | | </if> |
| | | and jh.is_deleted = 0 |
| | | order by jh.create_time desc |
| | | </where> |
| | | </select> |
| | | |
| | | |
| | | <!--查询房屋集合信息--> |
| | | <select id="selectHouseNodeList" resultType="org.springblade.common.node.TreeStringNode" > |
| | | select jh.house_code as id, |
| | |
| | | * 住户 删除 |
| | | */ |
| | | boolean removeHousehold(String ids); |
| | | |
| | | List<HouseholdVO> getAllHouseHold(HouseholdVO household); |
| | | } |
| | |
| | | userHouseLabelService.remove(wrapper); |
| | | } |
| | | } |
| | | |
| | | @Override |
| | | public List<HouseholdVO> getAllHouseHold(HouseholdVO household) { |
| | | return baseMapper.getAllHouseHold(household); |
| | | } |
| | | } |
| New file |
| | |
| | | package org.springblade.modules.partyOrganization.controller; |
| | | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import io.swagger.annotations.ApiParam; |
| | | import lombok.AllArgsConstructor; |
| | | import org.springblade.core.boot.ctrl.BladeController; |
| | | import org.springblade.core.mp.support.Condition; |
| | | import org.springblade.core.mp.support.Query; |
| | | import org.springblade.core.tool.api.R; |
| | | import org.springblade.core.tool.utils.Func; |
| | | import org.springblade.modules.partyOrganization.entity.PartyOrganization; |
| | | import org.springblade.modules.partyOrganization.service.IPartyOrganizationService; |
| | | import org.springblade.modules.partyOrganization.vo.PartyOrganizationVO; |
| | | import org.springframework.web.bind.annotation.*; |
| | | |
| | | import javax.validation.Valid; |
| | | |
| | | @RestController |
| | | @AllArgsConstructor |
| | | @RequestMapping("partyOrganization/partyOrganization") |
| | | @Api(value = "业委会表", tags = "业委会表接口") |
| | | public class PartyOrganizationController extends BladeController { |
| | | |
| | | private final IPartyOrganizationService partyOrganizationService; |
| | | |
| | | |
| | | /** |
| | | * 党组织 详情 |
| | | */ |
| | | @GetMapping("/detail") |
| | | @ApiOperationSupport(order = 1) |
| | | @ApiOperation(value = "详情", notes = "传入ownersCommittee") |
| | | public R<PartyOrganization> detail(PartyOrganizationVO partyOrganizationVO) { |
| | | PartyOrganization detail = partyOrganizationService.getOne(Condition.getQueryWrapper(partyOrganizationVO)); |
| | | return R.data(detail); |
| | | } |
| | | |
| | | /** |
| | | * 党组织 自定义分页 |
| | | */ |
| | | @GetMapping("/page") |
| | | @ApiOperationSupport(order = 3) |
| | | @ApiOperation(value = "分页", notes = "传入ownersCommittee") |
| | | public R<IPage<PartyOrganizationVO>> page(PartyOrganizationVO PartyOrganizationVO, Query query) { |
| | | IPage<PartyOrganizationVO> pages = partyOrganizationService.getPage(Condition.getPage(query), PartyOrganizationVO); |
| | | return R.data(pages); |
| | | } |
| | | |
| | | /** |
| | | * 党组织 新增 |
| | | */ |
| | | @PostMapping("/save") |
| | | @ApiOperationSupport(order = 4) |
| | | @ApiOperation(value = "新增", notes = "传入ownersCommittee") |
| | | public R save(@Valid @RequestBody PartyOrganization partyOrganization) { |
| | | return R.status(partyOrganizationService.save(partyOrganization)); |
| | | } |
| | | |
| | | /** |
| | | * 党组织 修改 |
| | | */ |
| | | @PostMapping("/update") |
| | | @ApiOperationSupport(order = 5) |
| | | @ApiOperation(value = "修改", notes = "传入ownersCommittee") |
| | | public R update(@Valid @RequestBody PartyOrganization partyOrganization) { |
| | | return R.status(partyOrganizationService.updateById(partyOrganization)); |
| | | } |
| | | |
| | | /** |
| | | * 党组织 新增或修改 |
| | | */ |
| | | @PostMapping("/submit") |
| | | @ApiOperationSupport(order = 6) |
| | | @ApiOperation(value = "新增或修改", notes = "传入ownersCommittee") |
| | | public R submit(@Valid @RequestBody PartyOrganization partyOrganization) { |
| | | return R.status(partyOrganizationService.saveOrUpdate(partyOrganization)); |
| | | } |
| | | |
| | | /** |
| | | * 党组织 删除 |
| | | */ |
| | | @PostMapping("/remove") |
| | | @ApiOperationSupport(order = 7) |
| | | @ApiOperation(value = "逻辑删除", notes = "传入ids") |
| | | public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) { |
| | | return R.status(partyOrganizationService.removeBatchByIds(Func.toLongList(ids))); |
| | | } |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | package org.springblade.modules.partyOrganization.controller; |
| | | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import io.swagger.annotations.ApiParam; |
| | | import lombok.AllArgsConstructor; |
| | | import org.springblade.core.boot.ctrl.BladeController; |
| | | import org.springblade.core.mp.support.Condition; |
| | | import org.springblade.core.mp.support.Query; |
| | | import org.springblade.core.tool.api.R; |
| | | import org.springblade.core.tool.utils.Func; |
| | | import org.springblade.modules.partyOrganization.entity.PartyOrganizationMember; |
| | | import org.springblade.modules.partyOrganization.service.IPartyOrganizationMemberService; |
| | | import org.springblade.modules.partyOrganization.vo.PartyOrganizationMemberVO; |
| | | import org.springframework.web.bind.annotation.*; |
| | | |
| | | import javax.validation.Valid; |
| | | |
| | | @RestController |
| | | @AllArgsConstructor |
| | | @RequestMapping("partyOrganizationMember/partyOrganizationMember") |
| | | @Api(value = "党成员表", tags = "党成员表接口") |
| | | public class PartyOrganizationMemberController extends BladeController { |
| | | |
| | | private final IPartyOrganizationMemberService partyOrganizationMemberService; |
| | | |
| | | |
| | | /** |
| | | * 党组织成员 详情 |
| | | */ |
| | | @GetMapping("/detail") |
| | | @ApiOperationSupport(order = 1) |
| | | @ApiOperation(value = "详情", notes = "传入PartyOrganizationMember") |
| | | public R<PartyOrganizationMember> detail(PartyOrganizationMemberVO partyOrganizationVO) { |
| | | PartyOrganizationMember detail = partyOrganizationMemberService.getOne(Condition.getQueryWrapper(partyOrganizationVO)); |
| | | return R.data(detail); |
| | | } |
| | | |
| | | /** |
| | | * 党组织成员 自定义分页 |
| | | */ |
| | | @GetMapping("/page") |
| | | @ApiOperationSupport(order = 3) |
| | | @ApiOperation(value = "分页", notes = "传入PartyOrganizationMember") |
| | | public R<IPage<PartyOrganizationMemberVO>> page(PartyOrganizationMemberVO PartyOrganizationMemberVO, Query query) { |
| | | IPage<PartyOrganizationMemberVO> pages = partyOrganizationMemberService.getPage(Condition.getPage(query), PartyOrganizationMemberVO); |
| | | return R.data(pages); |
| | | } |
| | | |
| | | /** |
| | | * 党组织成员 新增 |
| | | */ |
| | | @PostMapping("/save") |
| | | @ApiOperationSupport(order = 4) |
| | | @ApiOperation(value = "新增", notes = "传入PartyOrganizationMember") |
| | | public R save(@Valid @RequestBody PartyOrganizationMember PartyOrganizationMember) { |
| | | return R.status(partyOrganizationMemberService.save(PartyOrganizationMember)); |
| | | } |
| | | |
| | | /** |
| | | * 党组织成员 新增 |
| | | */ |
| | | @PostMapping("/add") |
| | | @ApiOperationSupport(order = 4) |
| | | @ApiOperation(value = "新增", notes = "传入PartyOrganizationMember") |
| | | public R add(@Valid @RequestBody PartyOrganizationMemberVO PartyOrganizationMember) { |
| | | return R.status(partyOrganizationMemberService.addVO(PartyOrganizationMember)); |
| | | } |
| | | |
| | | /** |
| | | * 党组织成员 修改 |
| | | */ |
| | | @PostMapping("/update") |
| | | @ApiOperationSupport(order = 5) |
| | | @ApiOperation(value = "修改", notes = "传入PartyOrganizationMember") |
| | | public R update(@Valid @RequestBody PartyOrganizationMember PartyOrganizationMember) { |
| | | return R.status(partyOrganizationMemberService.updateById(PartyOrganizationMember)); |
| | | } |
| | | |
| | | /** |
| | | * 党组织成员 修改 |
| | | */ |
| | | @PostMapping("/edit") |
| | | @ApiOperationSupport(order = 5) |
| | | @ApiOperation(value = "修改", notes = "传入PartyOrganizationMember") |
| | | public R edit(@Valid @RequestBody PartyOrganizationMemberVO PartyOrganizationMember) { |
| | | return R.status(partyOrganizationMemberService.editVO(PartyOrganizationMember)); |
| | | } |
| | | |
| | | /** |
| | | * 党组织成员 新增或修改 |
| | | */ |
| | | @PostMapping("/submit") |
| | | @ApiOperationSupport(order = 6) |
| | | @ApiOperation(value = "新增或修改", notes = "传入PartyOrganizationMember") |
| | | public R submit(@Valid @RequestBody PartyOrganizationMember PartyOrganizationMember) { |
| | | return R.status(partyOrganizationMemberService.saveOrUpdate(PartyOrganizationMember)); |
| | | } |
| | | |
| | | /** |
| | | * 党组织成员 删除 |
| | | */ |
| | | @PostMapping("/remove") |
| | | @ApiOperationSupport(order = 7) |
| | | @ApiOperation(value = "逻辑删除", notes = "传入ids") |
| | | public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) { |
| | | return R.status(partyOrganizationMemberService.removeBatchByIds(Func.toLongList(ids))); |
| | | } |
| | | |
| | | /** |
| | | * 党组织成员 删除 |
| | | */ |
| | | @PostMapping("/delete") |
| | | @ApiOperationSupport(order = 7) |
| | | @ApiOperation(value = "逻辑删除", notes = "传入ids") |
| | | public R delete(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) { |
| | | return R.status(partyOrganizationMemberService.delete(Func.toLongList(ids))); |
| | | } |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | package org.springblade.modules.partyOrganization.entity; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | import org.springblade.core.mp.base.BaseEntity; |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | | |
| | | import java.util.Date; |
| | | |
| | | @Data |
| | | @TableName("jczz_party_organization") |
| | | @EqualsAndHashCode(callSuper = true) |
| | | public class PartyOrganization extends BaseEntity { |
| | | |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | //社区id |
| | | private String areaId; |
| | | |
| | | //组织名称 |
| | | private String organizationName; |
| | | |
| | | //组织类型 |
| | | private String organizationType; |
| | | |
| | | //支部类型 |
| | | private String branchType; |
| | | |
| | | //负责人姓名 |
| | | private String chargePerson; |
| | | |
| | | //负责人手机号 |
| | | private String phone; |
| | | |
| | | //成立日期 |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
| | | private Date establishmentDate; |
| | | |
| | | //图片 |
| | | private String urls; |
| | | |
| | | //排序 |
| | | private String sort; |
| | | |
| | | //简介 |
| | | private String profile; |
| | | |
| | | } |
| New file |
| | |
| | | package org.springblade.modules.partyOrganization.entity; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | import org.springblade.core.mp.base.BaseEntity; |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | | |
| | | import java.util.Date; |
| | | |
| | | @Data |
| | | @TableName("jczz_party_organization_member") |
| | | @EqualsAndHashCode(callSuper = true) |
| | | public class PartyOrganizationMember extends BaseEntity { |
| | | |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | //住户id |
| | | private String householdId; |
| | | |
| | | //党组织id |
| | | private String organizationId; |
| | | |
| | | //党员类型 |
| | | private String partyMemberType; |
| | | |
| | | //党员职务 |
| | | private String partyMemberPost; |
| | | |
| | | //入党日期 |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
| | | private Date joinDate; |
| | | |
| | | //转入日期 |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
| | | private Date transferDate; |
| | | |
| | | //签入社区日期 |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
| | | private Date signInDate; |
| | | |
| | | //是否先锋岗(1、是;2、否) |
| | | private String isPioneer; |
| | | |
| | | //家庭住址 |
| | | private String address; |
| | | |
| | | //图片 |
| | | private String urls; |
| | | |
| | | //排序 |
| | | private String sort; |
| | | |
| | | //简介 |
| | | private String profile; |
| | | |
| | | private String userHouseLabelId; |
| | | } |
| New file |
| | |
| | | package org.springblade.modules.partyOrganization.mapper; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import io.swagger.annotations.ApiParam; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.springblade.core.mp.support.Condition; |
| | | import org.springblade.core.mp.support.Query; |
| | | import org.springblade.core.tool.api.R; |
| | | import org.springblade.core.tool.utils.Func; |
| | | import org.springblade.modules.ownersCommittee.entity.OwnersCommitteeEntity; |
| | | import org.springblade.modules.ownersCommittee.vo.OwnersCommitteeVO; |
| | | import org.springblade.modules.ownersCommittee.wrapper.OwnersCommitteeWrapper; |
| | | import org.springblade.modules.partyOrganization.entity.PartyOrganization; |
| | | import org.springblade.modules.partyOrganization.vo.PartyOrganizationVO; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.PostMapping; |
| | | import org.springframework.web.bind.annotation.RequestBody; |
| | | import org.springframework.web.bind.annotation.RequestParam; |
| | | |
| | | import javax.validation.Valid; |
| | | import java.util.List; |
| | | |
| | | public interface PartyOrganizationMapper extends BaseMapper<PartyOrganization> { |
| | | |
| | | |
| | | List<PartyOrganizationVO> getPage(IPage<PartyOrganizationVO> page, @Param("vo") PartyOrganizationVO partyOrganizationVO); |
| | | } |
| New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="org.springblade.modules.partyOrganization.mapper.PartyOrganizationMapper"> |
| | | |
| | | |
| | | <select id="getPage" resultType="org.springblade.modules.partyOrganization.vo.PartyOrganizationVO"> |
| | | SELECT |
| | | DISTINCT |
| | | jpo.*, |
| | | IFNULL(countTable.memberCount ,0) as memberCount |
| | | FROM |
| | | jczz_party_organization jpo |
| | | LEFT JOIN ( SELECT COUNT(*) memberCount, organization_id FROM jczz_party_organization_member WHERE is_deleted = 0 GROUP BY organization_id ) countTable ON countTable.organization_id = jpo.id |
| | | left join jczz_party_organization_member jpom ON jpom.organization_id = jpo.id |
| | | left join jczz_household jh ON jh.id = jpom.household_id |
| | | WHERE |
| | | jpo.is_deleted = 0 |
| | | |
| | | <if test="vo.organizationName != null and vo.organizationName != ''"> |
| | | AND jpo.organization_name LIKE CONCAT('%',#{vo.organizationName},'%') |
| | | </if> |
| | | <if test="vo.areaId != null and vo.areaId !='' "> |
| | | AND jpo.area_id like concat('%',#{vo.areaId},'%') |
| | | </if> |
| | | <if test="vo.name != null and vo.name != ''"> |
| | | AND(jh.name LIKE CONCAT('%',#{vo.name},'%') OR jpo.charge_person LIKE CONCAT('%',#{vo.name},'%')) |
| | | </if> |
| | | ORDER BY |
| | | jpo.sort ASC |
| | | </select> |
| | | </mapper> |
| New file |
| | |
| | | package org.springblade.modules.partyOrganization.mapper; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.springblade.modules.partyOrganization.entity.PartyOrganization; |
| | | import org.springblade.modules.partyOrganization.entity.PartyOrganizationMember; |
| | | import org.springblade.modules.partyOrganization.vo.PartyOrganizationMemberVO; |
| | | import org.springblade.modules.partyOrganization.vo.PartyOrganizationVO; |
| | | |
| | | import java.util.List; |
| | | |
| | | public interface PartyOrganizationMemberMapper extends BaseMapper<PartyOrganizationMember> { |
| | | |
| | | |
| | | List<PartyOrganizationMemberVO> getPage(IPage<PartyOrganizationMemberVO> page, @Param("vo") PartyOrganizationMemberVO partyOrganizationMemberVO); |
| | | } |
| New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="org.springblade.modules.partyOrganization.mapper.PartyOrganizationMemberMapper"> |
| | | |
| | | |
| | | <select id="getPage" resultType="org.springblade.modules.partyOrganization.vo.PartyOrganizationMemberVO"> |
| | | SELECT |
| | | jpom.*, |
| | | jh.name as houseHoldName, |
| | | jh.phone_number as phoneNumber, |
| | | jh.gender as gender, |
| | | jh.birthday as birthday, |
| | | jh.card_type as cardType, |
| | | jh.id_card as idCard |
| | | FROM jczz_party_organization_member jpom |
| | | LEFT JOIN jczz_household jh ON jpom.household_id = jh.id |
| | | where jpom.is_deleted = 0 |
| | | <if test="vo.organizationId != null and vo.organizationId !='' "> |
| | | AND jpom.organization_id = #{vo.organizationId} |
| | | </if> |
| | | <if test="vo.phoneNumber != null and vo.phoneNumber !='' "> |
| | | AND jh.phone_number LIKE CONCAT('%',#{vo.phoneNumber},'%') |
| | | </if> |
| | | <if test="vo.houseHoldName != null and vo.houseHoldName !='' "> |
| | | AND jh.name LIKE CONCAT('%',#{vo.houseHoldName},'%') |
| | | </if> |
| | | ORDER BY jpom.sort asc |
| | | </select> |
| | | </mapper> |
| New file |
| | |
| | | package org.springblade.modules.partyOrganization.service; |
| | | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.springblade.core.mp.base.BaseService; |
| | | import org.springblade.modules.partyOrganization.entity.PartyOrganization; |
| | | import org.springblade.modules.partyOrganization.entity.PartyOrganizationMember; |
| | | import org.springblade.modules.partyOrganization.vo.PartyOrganizationMemberVO; |
| | | import org.springblade.modules.partyOrganization.vo.PartyOrganizationVO; |
| | | |
| | | import java.util.List; |
| | | |
| | | public interface IPartyOrganizationMemberService extends BaseService<PartyOrganizationMember> { |
| | | IPage<PartyOrganizationMemberVO> getPage(IPage<PartyOrganizationMemberVO> page, PartyOrganizationMemberVO partyOrganizationMemberVO); |
| | | |
| | | Boolean addVO(PartyOrganizationMemberVO partyOrganizationMember); |
| | | |
| | | Boolean editVO(PartyOrganizationMemberVO partyOrganizationMember); |
| | | |
| | | Boolean delete(List<Long> toLongList); |
| | | } |
| New file |
| | |
| | | package org.springblade.modules.partyOrganization.service; |
| | | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.springblade.core.mp.base.BaseService; |
| | | import org.springblade.modules.partyOrganization.entity.PartyOrganization; |
| | | import org.springblade.modules.partyOrganization.vo.PartyOrganizationVO; |
| | | |
| | | public interface IPartyOrganizationService extends BaseService<PartyOrganization> { |
| | | IPage<PartyOrganizationVO> getPage(IPage<PartyOrganizationVO> page, PartyOrganizationVO partyOrganizationVO); |
| | | } |
| New file |
| | |
| | | package org.springblade.modules.partyOrganization.service.impl; |
| | | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.springblade.core.mp.base.BaseServiceImpl; |
| | | import org.springblade.core.tool.utils.DateUtil; |
| | | import org.springblade.modules.house.entity.UserHouseLabelEntity; |
| | | import org.springblade.modules.house.service.IUserHouseLabelService; |
| | | import org.springblade.modules.label.entity.LabelEntity; |
| | | import org.springblade.modules.label.service.ILabelService; |
| | | import org.springblade.modules.partyOrganization.entity.PartyOrganization; |
| | | import org.springblade.modules.partyOrganization.entity.PartyOrganizationMember; |
| | | import org.springblade.modules.partyOrganization.mapper.PartyOrganizationMapper; |
| | | import org.springblade.modules.partyOrganization.mapper.PartyOrganizationMemberMapper; |
| | | import org.springblade.modules.partyOrganization.service.IPartyOrganizationMemberService; |
| | | import org.springblade.modules.partyOrganization.service.IPartyOrganizationService; |
| | | import org.springblade.modules.partyOrganization.vo.PartyOrganizationMemberVO; |
| | | import org.springblade.modules.partyOrganization.vo.PartyOrganizationVO; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.util.List; |
| | | |
| | | @Service |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public class PartyOrganizationMemberServiceImpl extends BaseServiceImpl<PartyOrganizationMemberMapper, PartyOrganizationMember> implements IPartyOrganizationMemberService { |
| | | |
| | | @Autowired |
| | | private IUserHouseLabelService userHouseLabelService; |
| | | |
| | | @Autowired |
| | | private ILabelService labelService; |
| | | |
| | | @Override |
| | | public IPage<PartyOrganizationMemberVO> getPage(IPage<PartyOrganizationMemberVO> page, PartyOrganizationMemberVO partyOrganizationMemberVO) { |
| | | return page.setRecords(baseMapper.getPage(page,partyOrganizationMemberVO)); |
| | | } |
| | | |
| | | @Override |
| | | public Boolean addVO(PartyOrganizationMemberVO partyOrganizationMember) { |
| | | |
| | | UserHouseLabelEntity userHouseLabelEntity = new UserHouseLabelEntity(); |
| | | |
| | | userHouseLabelEntity.setHouseCode(partyOrganizationMember.getHouseCode()); |
| | | userHouseLabelEntity.setLabelId(Long.parseLong(partyOrganizationMember.getPartyMemberType())); |
| | | userHouseLabelEntity.setColor("#30D17C"); |
| | | userHouseLabelEntity.setLableType(1); |
| | | userHouseLabelEntity.setHouseholdId(Long.parseLong(partyOrganizationMember.getHouseholdId())); |
| | | userHouseLabelEntity.setCreateTime(DateUtil.now()); |
| | | |
| | | LabelEntity labelDetail = labelService.getById(partyOrganizationMember.getPartyMemberType()); |
| | | userHouseLabelEntity.setLabelName(labelDetail.getLabelName()); |
| | | |
| | | |
| | | boolean saveUserLabel = userHouseLabelService.save(userHouseLabelEntity); |
| | | |
| | | partyOrganizationMember.setUserHouseLabelId(userHouseLabelEntity.getId().toString()); |
| | | boolean saveMember = save(partyOrganizationMember); |
| | | return saveUserLabel&&saveMember; |
| | | } |
| | | |
| | | @Override |
| | | public Boolean editVO(PartyOrganizationMemberVO partyOrganizationMember) { |
| | | |
| | | UserHouseLabelEntity userHouseLabelEntity = userHouseLabelService.getById(partyOrganizationMember.getUserHouseLabelId()); |
| | | |
| | | |
| | | //更新userhouselabel标签 |
| | | LabelEntity labelDetail = labelService.getById(partyOrganizationMember.getPartyMemberType()); |
| | | userHouseLabelEntity.setLabelName(labelDetail.getLabelName()); |
| | | userHouseLabelEntity.setLabelId(Long.parseLong(partyOrganizationMember.getPartyMemberType())); |
| | | boolean updateLabel = userHouseLabelService.updateById(userHouseLabelEntity); |
| | | |
| | | //更新党员信息 |
| | | boolean updateMember = updateById(partyOrganizationMember); |
| | | |
| | | |
| | | return updateLabel&&updateMember; |
| | | } |
| | | |
| | | @Override |
| | | public Boolean delete(List<Long> toLongList) { |
| | | |
| | | //把userhouselabel中的数据删除 |
| | | List<PartyOrganizationMember> partyOrganizationMembers = listByIds(toLongList); |
| | | |
| | | //循环删除 |
| | | partyOrganizationMembers.forEach(partyOrganizationMember ->{ |
| | | userHouseLabelService.removeById(partyOrganizationMember.getUserHouseLabelId()); |
| | | }); |
| | | |
| | | //删自己 |
| | | return removeBatchByIds(toLongList); |
| | | } |
| | | |
| | | } |
| New file |
| | |
| | | package org.springblade.modules.partyOrganization.service.impl; |
| | | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.springblade.core.mp.base.BaseServiceImpl; |
| | | import org.springblade.core.secure.utils.AuthUtil; |
| | | import org.springblade.modules.partyOrganization.entity.PartyOrganization; |
| | | import org.springblade.modules.partyOrganization.mapper.PartyOrganizationMapper; |
| | | import org.springblade.modules.partyOrganization.service.IPartyOrganizationService; |
| | | import org.springblade.modules.partyOrganization.vo.PartyOrganizationVO; |
| | | import org.springblade.modules.system.entity.Dept; |
| | | import org.springblade.modules.system.service.IDeptService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | @Service |
| | | public class PartyOrganizationServiceImpl extends BaseServiceImpl<PartyOrganizationMapper, PartyOrganization> implements IPartyOrganizationService { |
| | | |
| | | @Autowired |
| | | private IDeptService deptService; |
| | | @Override |
| | | public IPage<PartyOrganizationVO> getPage(IPage<PartyOrganizationVO> page, PartyOrganizationVO partyOrganizationVO) { |
| | | |
| | | Dept dept = deptService.getById(AuthUtil.getDeptId()); |
| | | if (null!=dept){ |
| | | partyOrganizationVO.setAreaId(dept.getRegionCode()); |
| | | } |
| | | return page.setRecords(baseMapper.getPage(page,partyOrganizationVO)); |
| | | } |
| | | } |
| New file |
| | |
| | | package org.springblade.modules.partyOrganization.vo; |
| | | |
| | | import lombok.Data; |
| | | import org.springblade.modules.partyOrganization.entity.PartyOrganization; |
| | | import org.springblade.modules.partyOrganization.entity.PartyOrganizationMember; |
| | | |
| | | @Data |
| | | public class PartyOrganizationMemberVO extends PartyOrganizationMember { |
| | | |
| | | private String houseHoldName; |
| | | |
| | | private String phoneNumber; |
| | | |
| | | private String gender; |
| | | |
| | | private String birthday; |
| | | |
| | | |
| | | |
| | | private String cardType; |
| | | |
| | | private String idCard; |
| | | |
| | | //房屋code |
| | | private String houseCode; |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | package org.springblade.modules.partyOrganization.vo; |
| | | |
| | | import lombok.Data; |
| | | import org.springblade.modules.partyOrganization.entity.PartyOrganization; |
| | | |
| | | @Data |
| | | public class PartyOrganizationVO extends PartyOrganization { |
| | | |
| | | //党员数 |
| | | private Integer memberCount; |
| | | |
| | | //负责人名字或者党成员名字 |
| | | private String name; |
| | | } |
| New file |
| | |
| | | package org.springblade.modules.property.controller; |
| | | |
| | | import com.qiniu.util.Auth; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import io.swagger.annotations.ApiParam; |
| | | import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport; |
| | | import lombok.AllArgsConstructor; |
| | | import javax.validation.Valid; |
| | | import org.springblade.core.mp.support.Condition; |
| | | import org.springblade.core.mp.support.Query; |
| | | import org.springblade.core.secure.utils.AuthUtil; |
| | | import org.springblade.core.tool.api.R; |
| | | import org.springblade.core.tool.utils.Func; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.springblade.modules.property.entity.PropertyCompanyCommentEntity; |
| | | import org.springblade.modules.property.vo.PropertyCompanyCommentVO; |
| | | import org.springblade.modules.property.wrapper.PropertyCompanyCommentWrapper; |
| | | import org.springblade.modules.property.service.IPropertyCompanyCommentService; |
| | | |
| | | /** |
| | | * 物业公司评论表 控制器 |
| | | * |
| | | * @author BladeX |
| | | * @since 2024-01-05 |
| | | */ |
| | | @RestController |
| | | @AllArgsConstructor |
| | | @RequestMapping("blade-propertyCompanyComment/propertyCompanyComment") |
| | | @Api(value = "物业公司评论表", tags = "物业公司评论表接口") |
| | | public class PropertyCompanyCommentController { |
| | | |
| | | private final IPropertyCompanyCommentService propertyCompanyCommentService; |
| | | |
| | | /** |
| | | * 物业公司评论表 详情 |
| | | */ |
| | | @GetMapping("/detail") |
| | | @ApiOperationSupport(order = 1) |
| | | @ApiOperation(value = "详情", notes = "传入propertyCompanyComment") |
| | | public R<PropertyCompanyCommentVO> detail(PropertyCompanyCommentEntity propertyCompanyComment) { |
| | | PropertyCompanyCommentEntity detail = propertyCompanyCommentService.getOne(Condition.getQueryWrapper(propertyCompanyComment)); |
| | | return R.data(PropertyCompanyCommentWrapper.build().entityVO(detail)); |
| | | } |
| | | /** |
| | | * 物业公司评论表 分页 |
| | | */ |
| | | @GetMapping("/list") |
| | | @ApiOperationSupport(order = 2) |
| | | @ApiOperation(value = "分页", notes = "传入propertyCompanyComment") |
| | | public R<IPage<PropertyCompanyCommentVO>> list(PropertyCompanyCommentEntity propertyCompanyComment, Query query) { |
| | | IPage<PropertyCompanyCommentEntity> pages = propertyCompanyCommentService.page(Condition.getPage(query), Condition.getQueryWrapper(propertyCompanyComment)); |
| | | return R.data(PropertyCompanyCommentWrapper.build().pageVO(pages)); |
| | | } |
| | | |
| | | /** |
| | | * 物业公司评论表 自定义分页 |
| | | */ |
| | | @GetMapping("/page") |
| | | @ApiOperationSupport(order = 3) |
| | | @ApiOperation(value = "分页", notes = "传入propertyCompanyComment") |
| | | public R<IPage<PropertyCompanyCommentVO>> page(PropertyCompanyCommentVO propertyCompanyComment, Query query) { |
| | | IPage<PropertyCompanyCommentVO> pages = propertyCompanyCommentService.selectPropertyCompanyCommentPage(Condition.getPage(query), propertyCompanyComment); |
| | | return R.data(pages); |
| | | } |
| | | |
| | | /** |
| | | * 物业公司评论表 新增 |
| | | */ |
| | | @PostMapping("/save") |
| | | @ApiOperationSupport(order = 4) |
| | | @ApiOperation(value = "新增", notes = "传入propertyCompanyComment") |
| | | public R save(@Valid @RequestBody PropertyCompanyCommentEntity propertyCompanyComment) { |
| | | propertyCompanyComment.setCreateUser(AuthUtil.getUserId()); |
| | | return R.status(propertyCompanyCommentService.save(propertyCompanyComment)); |
| | | } |
| | | |
| | | /** |
| | | * 物业公司评论表 修改 |
| | | */ |
| | | @PostMapping("/update") |
| | | @ApiOperationSupport(order = 5) |
| | | @ApiOperation(value = "修改", notes = "传入propertyCompanyComment") |
| | | public R update(@Valid @RequestBody PropertyCompanyCommentEntity propertyCompanyComment) { |
| | | return R.status(propertyCompanyCommentService.updateById(propertyCompanyComment)); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 物业公司评论表 自定义新增或修改 |
| | | */ |
| | | @PostMapping("/saveOrUpdate") |
| | | @ApiOperation(value = "新增", notes = "传入propertyCompanyComment") |
| | | public R saveOrUpdate(@Valid @RequestBody PropertyCompanyCommentVO propertyCompanyComment) { |
| | | propertyCompanyComment.setCreateUser(AuthUtil.getUserId()); |
| | | return R.status(propertyCompanyCommentService.saveOrUpdatePropertyCompanyComment(propertyCompanyComment)); |
| | | } |
| | | |
| | | /** |
| | | * 物业公司评论表 新增或修改 |
| | | */ |
| | | @PostMapping("/submit") |
| | | @ApiOperationSupport(order = 6) |
| | | @ApiOperation(value = "新增或修改", notes = "传入propertyCompanyComment") |
| | | public R submit(@Valid @RequestBody PropertyCompanyCommentEntity propertyCompanyComment) { |
| | | return R.status(propertyCompanyCommentService.saveOrUpdate(propertyCompanyComment)); |
| | | } |
| | | |
| | | /** |
| | | * 物业公司评论表 删除 |
| | | */ |
| | | @PostMapping("/remove") |
| | | @ApiOperationSupport(order = 7) |
| | | @ApiOperation(value = "逻辑删除", notes = "传入ids") |
| | | public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) { |
| | | return R.status(propertyCompanyCommentService.removeByIds(Func.toLongList(ids))); |
| | | } |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | package org.springblade.modules.property.controller; |
| | | |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import io.swagger.annotations.ApiParam; |
| | | import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport; |
| | | import lombok.AllArgsConstructor; |
| | | import javax.validation.Valid; |
| | | import org.springblade.core.mp.support.Condition; |
| | | import org.springblade.core.mp.support.Query; |
| | | import org.springblade.core.tool.api.R; |
| | | import org.springblade.core.tool.utils.Func; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.springblade.modules.property.entity.PropertyCompanyScoreEntity; |
| | | import org.springblade.modules.property.vo.PropertyCompanyScoreVO; |
| | | import org.springblade.modules.property.wrapper.PropertyCompanyScoreWrapper; |
| | | import org.springblade.modules.property.service.IPropertyCompanyScoreService; |
| | | |
| | | /** |
| | | * 物业公司评分表 控制器 |
| | | * |
| | | * @author BladeX |
| | | * @since 2024-01-05 |
| | | */ |
| | | @RestController |
| | | @AllArgsConstructor |
| | | @RequestMapping("blade-propertyCompanyScore/propertyCompanyScore") |
| | | @Api(value = "物业公司评分表", tags = "物业公司评分表接口") |
| | | public class PropertyCompanyScoreController{ |
| | | |
| | | private final IPropertyCompanyScoreService propertyCompanyScoreService; |
| | | |
| | | /** |
| | | * 物业公司评分表 详情 |
| | | */ |
| | | @GetMapping("/detail") |
| | | @ApiOperationSupport(order = 1) |
| | | @ApiOperation(value = "详情", notes = "传入propertyCompanyScore") |
| | | public R<PropertyCompanyScoreVO> detail(PropertyCompanyScoreEntity propertyCompanyScore) { |
| | | PropertyCompanyScoreEntity detail = propertyCompanyScoreService.getOne(Condition.getQueryWrapper(propertyCompanyScore)); |
| | | return R.data(PropertyCompanyScoreWrapper.build().entityVO(detail)); |
| | | } |
| | | /** |
| | | * 物业公司评分表 分页 |
| | | */ |
| | | @GetMapping("/list") |
| | | @ApiOperationSupport(order = 2) |
| | | @ApiOperation(value = "分页", notes = "传入propertyCompanyScore") |
| | | public R<IPage<PropertyCompanyScoreVO>> list(PropertyCompanyScoreEntity propertyCompanyScore, Query query) { |
| | | IPage<PropertyCompanyScoreEntity> pages = propertyCompanyScoreService.page(Condition.getPage(query), Condition.getQueryWrapper(propertyCompanyScore)); |
| | | return R.data(PropertyCompanyScoreWrapper.build().pageVO(pages)); |
| | | } |
| | | |
| | | /** |
| | | * 物业公司评分表 自定义分页 |
| | | */ |
| | | @GetMapping("/page") |
| | | @ApiOperationSupport(order = 3) |
| | | @ApiOperation(value = "分页", notes = "传入propertyCompanyScore") |
| | | public R<IPage<PropertyCompanyScoreVO>> page(PropertyCompanyScoreVO propertyCompanyScore, Query query) { |
| | | IPage<PropertyCompanyScoreVO> pages = propertyCompanyScoreService.selectPropertyCompanyScorePage(Condition.getPage(query), propertyCompanyScore); |
| | | return R.data(pages); |
| | | } |
| | | |
| | | /** |
| | | * 物业公司评分表 新增 |
| | | */ |
| | | @PostMapping("/save") |
| | | @ApiOperationSupport(order = 4) |
| | | @ApiOperation(value = "新增", notes = "传入propertyCompanyScore") |
| | | public R save(@Valid @RequestBody PropertyCompanyScoreEntity propertyCompanyScore) { |
| | | return R.status(propertyCompanyScoreService.save(propertyCompanyScore)); |
| | | } |
| | | |
| | | /** |
| | | * 物业公司评分表 修改 |
| | | */ |
| | | @PostMapping("/update") |
| | | @ApiOperationSupport(order = 5) |
| | | @ApiOperation(value = "修改", notes = "传入propertyCompanyScore") |
| | | public R update(@Valid @RequestBody PropertyCompanyScoreEntity propertyCompanyScore) { |
| | | return R.status(propertyCompanyScoreService.updateById(propertyCompanyScore)); |
| | | } |
| | | |
| | | /** |
| | | * 物业公司评分表 新增或修改 |
| | | */ |
| | | @PostMapping("/submit") |
| | | @ApiOperationSupport(order = 6) |
| | | @ApiOperation(value = "新增或修改", notes = "传入propertyCompanyScore") |
| | | public R submit(@Valid @RequestBody PropertyCompanyScoreEntity propertyCompanyScore) { |
| | | return R.status(propertyCompanyScoreService.saveOrUpdate(propertyCompanyScore)); |
| | | } |
| | | |
| | | /** |
| | | * 物业公司评分表 删除 |
| | | */ |
| | | @PostMapping("/remove") |
| | | @ApiOperationSupport(order = 7) |
| | | @ApiOperation(value = "逻辑删除", notes = "传入ids") |
| | | public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) { |
| | | return R.status(propertyCompanyScoreService.removeByIds(Func.toLongList(ids))); |
| | | } |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | /* |
| | | * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. |
| | | * |
| | | * Redistribution and use in source and binary forms, with or without |
| | | * modification, are permitted provided that the following conditions are met: |
| | | * |
| | | * Redistributions of source code must retain the above copyright notice, |
| | | * this list of conditions and the following disclaimer. |
| | | * Redistributions in binary form must reproduce the above copyright |
| | | * notice, this list of conditions and the following disclaimer in the |
| | | * documentation and/or other materials provided with the distribution. |
| | | * Neither the name of the dreamlu.net developer nor the names of its |
| | | * contributors may be used to endorse or promote products derived from |
| | | * this software without specific prior written permission. |
| | | * Author: Chill 庄骞 (smallchill@163.com) |
| | | */ |
| | | package org.springblade.modules.property.dto; |
| | | |
| | | import org.springblade.modules.property.entity.PropertyCompanyCommentEntity; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | |
| | | /** |
| | | * 物业公司评论表 数据传输对象实体类 |
| | | * |
| | | * @author BladeX |
| | | * @since 2024-01-05 |
| | | */ |
| | | @Data |
| | | @EqualsAndHashCode(callSuper = true) |
| | | public class PropertyCompanyCommentDTO extends PropertyCompanyCommentEntity { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | } |
| New file |
| | |
| | | /* |
| | | * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. |
| | | * |
| | | * Redistribution and use in source and binary forms, with or without |
| | | * modification, are permitted provided that the following conditions are met: |
| | | * |
| | | * Redistributions of source code must retain the above copyright notice, |
| | | * this list of conditions and the following disclaimer. |
| | | * Redistributions in binary form must reproduce the above copyright |
| | | * notice, this list of conditions and the following disclaimer in the |
| | | * documentation and/or other materials provided with the distribution. |
| | | * Neither the name of the dreamlu.net developer nor the names of its |
| | | * contributors may be used to endorse or promote products derived from |
| | | * this software without specific prior written permission. |
| | | * Author: Chill 庄骞 (smallchill@163.com) |
| | | */ |
| | | package org.springblade.modules.property.dto; |
| | | |
| | | import org.springblade.modules.property.entity.PropertyCompanyScoreEntity; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | |
| | | /** |
| | | * 物业公司评分表 数据传输对象实体类 |
| | | * |
| | | * @author BladeX |
| | | * @since 2024-01-05 |
| | | */ |
| | | @Data |
| | | @EqualsAndHashCode(callSuper = true) |
| | | public class PropertyCompanyScoreDTO extends PropertyCompanyScoreEntity { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | } |
| New file |
| | |
| | | package org.springblade.modules.property.entity; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.*; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.fasterxml.jackson.databind.annotation.JsonSerialize; |
| | | import com.fasterxml.jackson.databind.ser.std.ToStringSerializer; |
| | | import lombok.Data; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | | |
| | | /** |
| | | * 物业公司评论表 实体类 |
| | | * |
| | | * @author BladeX |
| | | * @since 2024-01-05 |
| | | */ |
| | | @Data |
| | | @TableName("jczz_property_company_comment") |
| | | @ApiModel(value = "PropertyCompanyComment对象", description = "物业公司评论表") |
| | | public class PropertyCompanyCommentEntity implements Serializable { |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * 主键 |
| | | */ |
| | | @JsonSerialize(using = ToStringSerializer.class) |
| | | @ApiModelProperty("主键id") |
| | | @TableId(value = "id", type = IdType.AUTO) |
| | | private Long id; |
| | | |
| | | /** |
| | | * 物业公司id |
| | | */ |
| | | @ApiModelProperty(value = "物业公司id") |
| | | private Integer propertyCompanyId; |
| | | /** |
| | | * 父级id |
| | | */ |
| | | @ApiModelProperty(value = "父级id") |
| | | private Long parentId; |
| | | /** |
| | | * 评论内容 |
| | | */ |
| | | @ApiModelProperty(value = "评论内容") |
| | | private String content; |
| | | |
| | | /** |
| | | * 评论图片 |
| | | */ |
| | | @ApiModelProperty(value = "评论图片") |
| | | private String imageUrls; |
| | | /** |
| | | * 审核人 |
| | | */ |
| | | @ApiModelProperty(value = "审核人") |
| | | private Long checkUser; |
| | | /** |
| | | * 审核时间 |
| | | */ |
| | | @ApiModelProperty(value = "审核时间") |
| | | private Date checkTime; |
| | | /** |
| | | * 审核状态 |
| | | */ |
| | | @ApiModelProperty(value = "审核状态") |
| | | private Integer checkStatus; |
| | | /** |
| | | * 审核备注 |
| | | */ |
| | | @ApiModelProperty(value = "审核备注") |
| | | private String checkRemark; |
| | | /** |
| | | * 创建人 |
| | | */ |
| | | @JsonSerialize(using = ToStringSerializer.class) |
| | | @ApiModelProperty("创建人") |
| | | @TableField(fill = FieldFill.INSERT) |
| | | private Long createUser; |
| | | |
| | | /** |
| | | * 创建时间 |
| | | */ |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @TableField(fill = FieldFill.INSERT) |
| | | @ApiModelProperty("创建时间") |
| | | private Date createTime; |
| | | |
| | | /** |
| | | * 是否删除 |
| | | */ |
| | | @TableLogic |
| | | @ApiModelProperty("是否已删除 0:否 1:是") |
| | | private Integer isDeleted; |
| | | |
| | | } |
| New file |
| | |
| | | package org.springblade.modules.property.entity; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.*; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.fasterxml.jackson.databind.annotation.JsonSerialize; |
| | | import com.fasterxml.jackson.databind.ser.std.ToStringSerializer; |
| | | import lombok.Data; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * 物业公司评分表 实体类 |
| | | * |
| | | * @author BladeX |
| | | * @since 2024-01-05 |
| | | */ |
| | | @Data |
| | | @TableName("jczz_property_company_score") |
| | | @ApiModel(value = "PropertyCompanyScore对象", description = "物业公司评分表") |
| | | public class PropertyCompanyScoreEntity implements Serializable { |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * 主键 |
| | | */ |
| | | @JsonSerialize(using = ToStringSerializer.class) |
| | | @ApiModelProperty("主键id") |
| | | @TableId(value = "id", type = IdType.AUTO) |
| | | private Long id; |
| | | |
| | | /** |
| | | * 物业公司id |
| | | */ |
| | | @ApiModelProperty(value = "物业公司id") |
| | | private Integer propertyCompanyId; |
| | | /** |
| | | * 评分 |
| | | */ |
| | | @ApiModelProperty(value = "评分") |
| | | private Integer score; |
| | | /** |
| | | * 创建人 |
| | | */ |
| | | @JsonSerialize(using = ToStringSerializer.class) |
| | | @ApiModelProperty("创建人") |
| | | @TableField(fill = FieldFill.INSERT) |
| | | private Long createUser; |
| | | |
| | | /** |
| | | * 创建时间 |
| | | */ |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @TableField(fill = FieldFill.INSERT) |
| | | @ApiModelProperty("创建时间") |
| | | private Date createTime; |
| | | |
| | | /** |
| | | * 是否删除 |
| | | */ |
| | | @TableLogic |
| | | @ApiModelProperty("是否已删除 0:否 1:是") |
| | | private Integer isDeleted; |
| | | |
| | | } |
| New file |
| | |
| | | /* |
| | | * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. |
| | | * |
| | | * Redistribution and use in source and binary forms, with or without |
| | | * modification, are permitted provided that the following conditions are met: |
| | | * |
| | | * Redistributions of source code must retain the above copyright notice, |
| | | * this list of conditions and the following disclaimer. |
| | | * Redistributions in binary form must reproduce the above copyright |
| | | * notice, this list of conditions and the following disclaimer in the |
| | | * documentation and/or other materials provided with the distribution. |
| | | * Neither the name of the dreamlu.net developer nor the names of its |
| | | * contributors may be used to endorse or promote products derived from |
| | | * this software without specific prior written permission. |
| | | * Author: Chill 庄骞 (smallchill@163.com) |
| | | */ |
| | | package org.springblade.modules.property.mapper; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.springblade.modules.property.entity.PropertyCompanyCommentEntity; |
| | | import org.springblade.modules.property.vo.PropertyCompanyCommentVO; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * 物业公司评论表 Mapper 接口 |
| | | * |
| | | * @author BladeX |
| | | * @since 2024-01-05 |
| | | */ |
| | | public interface PropertyCompanyCommentMapper extends BaseMapper<PropertyCompanyCommentEntity> { |
| | | |
| | | /** |
| | | * 自定义分页 |
| | | * |
| | | * @param page |
| | | * @param propertyCompanyComment |
| | | * @return |
| | | */ |
| | | List<PropertyCompanyCommentVO> selectPropertyCompanyCommentPage(IPage page, |
| | | @Param("propertyCompanyComment") PropertyCompanyCommentVO propertyCompanyComment); |
| | | |
| | | |
| | | /** |
| | | * 递归分页查询 |
| | | * @param page |
| | | * @param propertyCompanyComment |
| | | * @return |
| | | */ |
| | | List<PropertyCompanyCommentVO> selectPropertyCompanyCommentPageRec(IPage<PropertyCompanyCommentVO> page, |
| | | @Param("propertyCompanyComment") PropertyCompanyCommentVO propertyCompanyComment); |
| | | } |
| New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="org.springblade.modules.property.mapper.PropertyCompanyCommentMapper"> |
| | | |
| | | <!-- 通用查询映射结果 --> |
| | | <resultMap id="propertyCompanyCommentResultMap" type="org.springblade.modules.property.vo.PropertyCompanyCommentVO" autoMapping="true"> |
| | | <id property="id" column="id"/> |
| | | <collection property="children" column="id" javaType="java.util.List" |
| | | ofType="org.springblade.modules.property.vo.PropertyCompanyCommentVO" |
| | | autoMapping="true" |
| | | select="selectPropertyCompanyCommentByParentId"> |
| | | </collection> |
| | | </resultMap> |
| | | |
| | | <!--自定义分页查询--> |
| | | <select id="selectPropertyCompanyCommentPage" resultType="org.springblade.modules.property.vo.PropertyCompanyCommentVO"> |
| | | select |
| | | jpcc.*, |
| | | bu.real_name as realName,bu.avatar |
| | | from jczz_property_company_comment jpcc |
| | | left join blade_user bu on bu.id = jpcc.create_user |
| | | where jpcc.is_deleted = 0 |
| | | and jpcc.parent_id = 0 |
| | | <if test="propertyCompanyComment.propertyCompanyId!=null"> |
| | | and jpcc.property_company_id = #{propertyCompanyComment.propertyCompanyId} |
| | | </if> |
| | | </select> |
| | | |
| | | <!--自定义分页查询(递归)--> |
| | | <select id="selectPropertyCompanyCommentPageRec" parameterType="long" |
| | | resultMap="propertyCompanyCommentResultMap"> |
| | | select |
| | | jpcc.*, |
| | | bu.real_name as realName,bu.avatar |
| | | from jczz_property_company_comment jpcc |
| | | left join blade_user bu on bu.id = jpcc.create_user |
| | | where jpcc.is_deleted = 0 |
| | | and jpcc.parent_id = 0 |
| | | <if test="propertyCompanyComment.propertyCompanyId!=null"> |
| | | and jpcc.property_company_id = #{propertyCompanyComment.propertyCompanyId} |
| | | </if> |
| | | </select> |
| | | |
| | | <!--递归查询--> |
| | | <select id="selectPropertyCompanyCommentByParentId" |
| | | resultType="org.springblade.modules.property.vo.PropertyCompanyCommentVO"> |
| | | select |
| | | jpcc.*, |
| | | bu.real_name as realName,bu.avatar |
| | | from jczz_property_company_comment jpcc |
| | | left join blade_user bu on bu.id = jpcc.create_user |
| | | where jpcc.is_deleted = 0 |
| | | and jpcc.parent_id = #{id} |
| | | </select> |
| | | |
| | | </mapper> |
| New file |
| | |
| | | /* |
| | | * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. |
| | | * |
| | | * Redistribution and use in source and binary forms, with or without |
| | | * modification, are permitted provided that the following conditions are met: |
| | | * |
| | | * Redistributions of source code must retain the above copyright notice, |
| | | * this list of conditions and the following disclaimer. |
| | | * Redistributions in binary form must reproduce the above copyright |
| | | * notice, this list of conditions and the following disclaimer in the |
| | | * documentation and/or other materials provided with the distribution. |
| | | * Neither the name of the dreamlu.net developer nor the names of its |
| | | * contributors may be used to endorse or promote products derived from |
| | | * this software without specific prior written permission. |
| | | * Author: Chill 庄骞 (smallchill@163.com) |
| | | */ |
| | | package org.springblade.modules.property.mapper; |
| | | |
| | | import org.springblade.modules.property.entity.PropertyCompanyScoreEntity; |
| | | import org.springblade.modules.property.vo.PropertyCompanyScoreVO; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * 物业公司评分表 Mapper 接口 |
| | | * |
| | | * @author BladeX |
| | | * @since 2024-01-05 |
| | | */ |
| | | public interface PropertyCompanyScoreMapper extends BaseMapper<PropertyCompanyScoreEntity> { |
| | | |
| | | /** |
| | | * 自定义分页 |
| | | * |
| | | * @param page |
| | | * @param propertyCompanyScore |
| | | * @return |
| | | */ |
| | | List<PropertyCompanyScoreVO> selectPropertyCompanyScorePage(IPage page, PropertyCompanyScoreVO propertyCompanyScore); |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="org.springblade.modules.property.mapper.PropertyCompanyScoreMapper"> |
| | | |
| | | <!-- 通用查询映射结果 --> |
| | | <resultMap id="propertyCompanyScoreResultMap" type="org.springblade.modules.property.entity.PropertyCompanyScoreEntity"> |
| | | <result column="id" property="id"/> |
| | | <result column="property_company_id" property="propertyCompanyId"/> |
| | | <result column="score" property="score"/> |
| | | <result column="create_user" property="createUser"/> |
| | | <result column="create_time" property="createTime"/> |
| | | <result column="is_deleted" property="isDeleted"/> |
| | | </resultMap> |
| | | |
| | | |
| | | <select id="selectPropertyCompanyScorePage" resultMap="propertyCompanyScoreResultMap"> |
| | | select * from jczz_property_company_score where is_deleted = 0 |
| | | </select> |
| | | |
| | | |
| | | </mapper> |
| New file |
| | |
| | | /* |
| | | * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. |
| | | * |
| | | * Redistribution and use in source and binary forms, with or without |
| | | * modification, are permitted provided that the following conditions are met: |
| | | * |
| | | * Redistributions of source code must retain the above copyright notice, |
| | | * this list of conditions and the following disclaimer. |
| | | * Redistributions in binary form must reproduce the above copyright |
| | | * notice, this list of conditions and the following disclaimer in the |
| | | * documentation and/or other materials provided with the distribution. |
| | | * Neither the name of the dreamlu.net developer nor the names of its |
| | | * contributors may be used to endorse or promote products derived from |
| | | * this software without specific prior written permission. |
| | | * Author: Chill 庄骞 (smallchill@163.com) |
| | | */ |
| | | package org.springblade.modules.property.service; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import org.springblade.modules.property.entity.PropertyCompanyCommentEntity; |
| | | import org.springblade.modules.property.vo.PropertyCompanyCommentVO; |
| | | import org.springblade.core.mp.base.BaseService; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | |
| | | /** |
| | | * 物业公司评论表 服务类 |
| | | * |
| | | * @author BladeX |
| | | * @since 2024-01-05 |
| | | */ |
| | | public interface IPropertyCompanyCommentService extends IService<PropertyCompanyCommentEntity> { |
| | | |
| | | /** |
| | | * 自定义分页 |
| | | * |
| | | * @param page |
| | | * @param propertyCompanyComment |
| | | * @return |
| | | */ |
| | | IPage<PropertyCompanyCommentVO> selectPropertyCompanyCommentPage(IPage<PropertyCompanyCommentVO> page, PropertyCompanyCommentVO propertyCompanyComment); |
| | | |
| | | |
| | | /** |
| | | * 物业公司评论表 自定义新增或修改 |
| | | */ |
| | | boolean saveOrUpdatePropertyCompanyComment(PropertyCompanyCommentVO propertyCompanyComment); |
| | | } |
| New file |
| | |
| | | /* |
| | | * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. |
| | | * |
| | | * Redistribution and use in source and binary forms, with or without |
| | | * modification, are permitted provided that the following conditions are met: |
| | | * |
| | | * Redistributions of source code must retain the above copyright notice, |
| | | * this list of conditions and the following disclaimer. |
| | | * Redistributions in binary form must reproduce the above copyright |
| | | * notice, this list of conditions and the following disclaimer in the |
| | | * documentation and/or other materials provided with the distribution. |
| | | * Neither the name of the dreamlu.net developer nor the names of its |
| | | * contributors may be used to endorse or promote products derived from |
| | | * this software without specific prior written permission. |
| | | * Author: Chill 庄骞 (smallchill@163.com) |
| | | */ |
| | | package org.springblade.modules.property.service; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import org.springblade.modules.property.entity.PropertyCompanyScoreEntity; |
| | | import org.springblade.modules.property.vo.PropertyCompanyScoreVO; |
| | | import org.springblade.core.mp.base.BaseService; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | |
| | | /** |
| | | * 物业公司评分表 服务类 |
| | | * |
| | | * @author BladeX |
| | | * @since 2024-01-05 |
| | | */ |
| | | public interface IPropertyCompanyScoreService extends IService<PropertyCompanyScoreEntity> { |
| | | |
| | | /** |
| | | * 自定义分页 |
| | | * |
| | | * @param page |
| | | * @param propertyCompanyScore |
| | | * @return |
| | | */ |
| | | IPage<PropertyCompanyScoreVO> selectPropertyCompanyScorePage(IPage<PropertyCompanyScoreVO> page, PropertyCompanyScoreVO propertyCompanyScore); |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | /* |
| | | * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. |
| | | * |
| | | * Redistribution and use in source and binary forms, with or without |
| | | * modification, are permitted provided that the following conditions are met: |
| | | * |
| | | * Redistributions of source code must retain the above copyright notice, |
| | | * this list of conditions and the following disclaimer. |
| | | * Redistributions in binary form must reproduce the above copyright |
| | | * notice, this list of conditions and the following disclaimer in the |
| | | * documentation and/or other materials provided with the distribution. |
| | | * Neither the name of the dreamlu.net developer nor the names of its |
| | | * contributors may be used to endorse or promote products derived from |
| | | * this software without specific prior written permission. |
| | | * Author: Chill 庄骞 (smallchill@163.com) |
| | | */ |
| | | package org.springblade.modules.property.service.impl; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import org.apache.logging.log4j.util.Strings; |
| | | import org.springblade.core.secure.utils.AuthUtil; |
| | | import org.springblade.modules.property.entity.PropertyCompanyCommentEntity; |
| | | import org.springblade.modules.property.entity.PropertyCompanyScoreEntity; |
| | | import org.springblade.modules.property.service.IPropertyCompanyScoreService; |
| | | import org.springblade.modules.property.vo.PropertyCompanyCommentVO; |
| | | import org.springblade.modules.property.mapper.PropertyCompanyCommentMapper; |
| | | import org.springblade.modules.property.service.IPropertyCompanyCommentService; |
| | | import org.springblade.core.mp.base.BaseServiceImpl; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | /** |
| | | * 物业公司评论表 服务实现类 |
| | | * |
| | | * @author BladeX |
| | | * @since 2024-01-05 |
| | | */ |
| | | @Service |
| | | public class PropertyCompanyCommentServiceImpl extends ServiceImpl<PropertyCompanyCommentMapper, PropertyCompanyCommentEntity> implements IPropertyCompanyCommentService { |
| | | |
| | | @Autowired |
| | | private IPropertyCompanyScoreService propertyCompanyScoreService; |
| | | |
| | | @Override |
| | | public IPage<PropertyCompanyCommentVO> selectPropertyCompanyCommentPage(IPage<PropertyCompanyCommentVO> page, PropertyCompanyCommentVO propertyCompanyComment) { |
| | | if (null!=propertyCompanyComment.getIsRec()){ |
| | | // 递归查询 |
| | | return page.setRecords(baseMapper.selectPropertyCompanyCommentPageRec(page, propertyCompanyComment)); |
| | | } |
| | | return page.setRecords(baseMapper.selectPropertyCompanyCommentPage(page, propertyCompanyComment)); |
| | | } |
| | | |
| | | /** |
| | | * 物业公司评论表 自定义新增或修改 |
| | | */ |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public boolean saveOrUpdatePropertyCompanyComment(PropertyCompanyCommentVO propertyCompanyComment) { |
| | | boolean save = save(propertyCompanyComment); |
| | | // 更新评分 |
| | | updatePropertyCompanyScore(propertyCompanyComment); |
| | | // 返回 |
| | | return save; |
| | | } |
| | | |
| | | /** |
| | | * 更新评分 |
| | | * @param propertyCompanyComment |
| | | */ |
| | | public void updatePropertyCompanyScore(PropertyCompanyCommentVO propertyCompanyComment) { |
| | | // 查询当前的物业公司,当前人是否已经评分,如果已经评分,则更新,否则新增 |
| | | if (null!=propertyCompanyComment.getScore()){ |
| | | QueryWrapper<PropertyCompanyScoreEntity> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.eq("is_deleted",0).eq("create_user", AuthUtil.getUserId()) |
| | | .eq("property_company_id",propertyCompanyComment.getPropertyCompanyId()); |
| | | PropertyCompanyScoreEntity one = propertyCompanyScoreService.getOne(queryWrapper); |
| | | if (null!=one){ |
| | | one.setScore(propertyCompanyComment.getScore()); |
| | | // 更新 |
| | | propertyCompanyScoreService.updateById(one); |
| | | }else { |
| | | PropertyCompanyScoreEntity propertyCompanyScoreEntity = new PropertyCompanyScoreEntity(); |
| | | propertyCompanyScoreEntity.setScore(propertyCompanyComment.getScore()); |
| | | propertyCompanyScoreEntity.setPropertyCompanyId(propertyCompanyComment.getPropertyCompanyId()); |
| | | propertyCompanyScoreEntity.setCreateUser(AuthUtil.getUserId()); |
| | | // 新增 |
| | | propertyCompanyScoreService.save(propertyCompanyScoreEntity); |
| | | } |
| | | } |
| | | } |
| | | } |
| New file |
| | |
| | | /* |
| | | * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. |
| | | * |
| | | * Redistribution and use in source and binary forms, with or without |
| | | * modification, are permitted provided that the following conditions are met: |
| | | * |
| | | * Redistributions of source code must retain the above copyright notice, |
| | | * this list of conditions and the following disclaimer. |
| | | * Redistributions in binary form must reproduce the above copyright |
| | | * notice, this list of conditions and the following disclaimer in the |
| | | * documentation and/or other materials provided with the distribution. |
| | | * Neither the name of the dreamlu.net developer nor the names of its |
| | | * contributors may be used to endorse or promote products derived from |
| | | * this software without specific prior written permission. |
| | | * Author: Chill 庄骞 (smallchill@163.com) |
| | | */ |
| | | package org.springblade.modules.property.service.impl; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import org.springblade.modules.property.entity.PropertyCompanyScoreEntity; |
| | | import org.springblade.modules.property.vo.PropertyCompanyScoreVO; |
| | | import org.springblade.modules.property.mapper.PropertyCompanyScoreMapper; |
| | | import org.springblade.modules.property.service.IPropertyCompanyScoreService; |
| | | import org.springblade.core.mp.base.BaseServiceImpl; |
| | | import org.springframework.stereotype.Service; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | |
| | | /** |
| | | * 物业公司评分表 服务实现类 |
| | | * |
| | | * @author BladeX |
| | | * @since 2024-01-05 |
| | | */ |
| | | @Service |
| | | public class PropertyCompanyScoreServiceImpl extends ServiceImpl<PropertyCompanyScoreMapper, PropertyCompanyScoreEntity> implements IPropertyCompanyScoreService { |
| | | |
| | | @Override |
| | | public IPage<PropertyCompanyScoreVO> selectPropertyCompanyScorePage(IPage<PropertyCompanyScoreVO> page, PropertyCompanyScoreVO propertyCompanyScore) { |
| | | return page.setRecords(baseMapper.selectPropertyCompanyScorePage(page, propertyCompanyScore)); |
| | | } |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | /* |
| | | * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. |
| | | * |
| | | * Redistribution and use in source and binary forms, with or without |
| | | * modification, are permitted provided that the following conditions are met: |
| | | * |
| | | * Redistributions of source code must retain the above copyright notice, |
| | | * this list of conditions and the following disclaimer. |
| | | * Redistributions in binary form must reproduce the above copyright |
| | | * notice, this list of conditions and the following disclaimer in the |
| | | * documentation and/or other materials provided with the distribution. |
| | | * Neither the name of the dreamlu.net developer nor the names of its |
| | | * contributors may be used to endorse or promote products derived from |
| | | * this software without specific prior written permission. |
| | | * Author: Chill 庄骞 (smallchill@163.com) |
| | | */ |
| | | package org.springblade.modules.property.vo; |
| | | |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import org.springblade.modules.circle.vo.CircleCommentVO; |
| | | import org.springblade.modules.property.entity.PropertyCompanyCommentEntity; |
| | | import org.springblade.core.tool.node.INode; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * 物业公司评论表 视图实体类 |
| | | * |
| | | * @author BladeX |
| | | * @since 2024-01-05 |
| | | */ |
| | | @Data |
| | | @EqualsAndHashCode(callSuper = true) |
| | | public class PropertyCompanyCommentVO extends PropertyCompanyCommentEntity { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | private List<CircleCommentVO> children; |
| | | |
| | | /** |
| | | * 姓名 |
| | | */ |
| | | @ApiModelProperty("姓名") |
| | | private String realName; |
| | | |
| | | /** |
| | | * 头像 |
| | | */ |
| | | @ApiModelProperty("头像") |
| | | private String avatar; |
| | | |
| | | /** |
| | | * 是否递归查询 1:是 2:否 |
| | | */ |
| | | @ApiModelProperty("是否递归查询 1:是 2:否") |
| | | private Integer isRec; |
| | | |
| | | /** |
| | | * 评分 |
| | | */ |
| | | @ApiModelProperty("评分") |
| | | private Integer score; |
| | | |
| | | } |
| New file |
| | |
| | | /* |
| | | * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. |
| | | * |
| | | * Redistribution and use in source and binary forms, with or without |
| | | * modification, are permitted provided that the following conditions are met: |
| | | * |
| | | * Redistributions of source code must retain the above copyright notice, |
| | | * this list of conditions and the following disclaimer. |
| | | * Redistributions in binary form must reproduce the above copyright |
| | | * notice, this list of conditions and the following disclaimer in the |
| | | * documentation and/or other materials provided with the distribution. |
| | | * Neither the name of the dreamlu.net developer nor the names of its |
| | | * contributors may be used to endorse or promote products derived from |
| | | * this software without specific prior written permission. |
| | | * Author: Chill 庄骞 (smallchill@163.com) |
| | | */ |
| | | package org.springblade.modules.property.vo; |
| | | |
| | | import org.springblade.modules.property.entity.PropertyCompanyScoreEntity; |
| | | import org.springblade.core.tool.node.INode; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | |
| | | /** |
| | | * 物业公司评分表 视图实体类 |
| | | * |
| | | * @author BladeX |
| | | * @since 2024-01-05 |
| | | */ |
| | | @Data |
| | | @EqualsAndHashCode(callSuper = true) |
| | | public class PropertyCompanyScoreVO extends PropertyCompanyScoreEntity { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | } |
| New file |
| | |
| | | /* |
| | | * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. |
| | | * |
| | | * Redistribution and use in source and binary forms, with or without |
| | | * modification, are permitted provided that the following conditions are met: |
| | | * |
| | | * Redistributions of source code must retain the above copyright notice, |
| | | * this list of conditions and the following disclaimer. |
| | | * Redistributions in binary form must reproduce the above copyright |
| | | * notice, this list of conditions and the following disclaimer in the |
| | | * documentation and/or other materials provided with the distribution. |
| | | * Neither the name of the dreamlu.net developer nor the names of its |
| | | * contributors may be used to endorse or promote products derived from |
| | | * this software without specific prior written permission. |
| | | * Author: Chill 庄骞 (smallchill@163.com) |
| | | */ |
| | | package org.springblade.modules.property.wrapper; |
| | | |
| | | import org.springblade.core.mp.support.BaseEntityWrapper; |
| | | import org.springblade.core.tool.utils.BeanUtil; |
| | | import org.springblade.modules.property.entity.PropertyCompanyCommentEntity; |
| | | import org.springblade.modules.property.vo.PropertyCompanyCommentVO; |
| | | import java.util.Objects; |
| | | |
| | | /** |
| | | * 物业公司评论表 包装类,返回视图层所需的字段 |
| | | * |
| | | * @author BladeX |
| | | * @since 2024-01-05 |
| | | */ |
| | | public class PropertyCompanyCommentWrapper extends BaseEntityWrapper<PropertyCompanyCommentEntity, PropertyCompanyCommentVO> { |
| | | |
| | | public static PropertyCompanyCommentWrapper build() { |
| | | return new PropertyCompanyCommentWrapper(); |
| | | } |
| | | |
| | | @Override |
| | | public PropertyCompanyCommentVO entityVO(PropertyCompanyCommentEntity propertyCompanyComment) { |
| | | PropertyCompanyCommentVO propertyCompanyCommentVO = Objects.requireNonNull(BeanUtil.copy(propertyCompanyComment, PropertyCompanyCommentVO.class)); |
| | | |
| | | //User createUser = UserCache.getUser(propertyCompanyComment.getCreateUser()); |
| | | //User updateUser = UserCache.getUser(propertyCompanyComment.getUpdateUser()); |
| | | //propertyCompanyCommentVO.setCreateUserName(createUser.getName()); |
| | | //propertyCompanyCommentVO.setUpdateUserName(updateUser.getName()); |
| | | |
| | | return propertyCompanyCommentVO; |
| | | } |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | /* |
| | | * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. |
| | | * |
| | | * Redistribution and use in source and binary forms, with or without |
| | | * modification, are permitted provided that the following conditions are met: |
| | | * |
| | | * Redistributions of source code must retain the above copyright notice, |
| | | * this list of conditions and the following disclaimer. |
| | | * Redistributions in binary form must reproduce the above copyright |
| | | * notice, this list of conditions and the following disclaimer in the |
| | | * documentation and/or other materials provided with the distribution. |
| | | * Neither the name of the dreamlu.net developer nor the names of its |
| | | * contributors may be used to endorse or promote products derived from |
| | | * this software without specific prior written permission. |
| | | * Author: Chill 庄骞 (smallchill@163.com) |
| | | */ |
| | | package org.springblade.modules.property.wrapper; |
| | | |
| | | import org.springblade.core.mp.support.BaseEntityWrapper; |
| | | import org.springblade.core.tool.utils.BeanUtil; |
| | | import org.springblade.modules.property.entity.PropertyCompanyScoreEntity; |
| | | import org.springblade.modules.property.vo.PropertyCompanyScoreVO; |
| | | import java.util.Objects; |
| | | |
| | | /** |
| | | * 物业公司评分表 包装类,返回视图层所需的字段 |
| | | * |
| | | * @author BladeX |
| | | * @since 2024-01-05 |
| | | */ |
| | | public class PropertyCompanyScoreWrapper extends BaseEntityWrapper<PropertyCompanyScoreEntity, PropertyCompanyScoreVO> { |
| | | |
| | | public static PropertyCompanyScoreWrapper build() { |
| | | return new PropertyCompanyScoreWrapper(); |
| | | } |
| | | |
| | | @Override |
| | | public PropertyCompanyScoreVO entityVO(PropertyCompanyScoreEntity propertyCompanyScore) { |
| | | PropertyCompanyScoreVO propertyCompanyScoreVO = Objects.requireNonNull(BeanUtil.copy(propertyCompanyScore, PropertyCompanyScoreVO.class)); |
| | | |
| | | //User createUser = UserCache.getUser(propertyCompanyScore.getCreateUser()); |
| | | //User updateUser = UserCache.getUser(propertyCompanyScore.getUpdateUser()); |
| | | //propertyCompanyScoreVO.setCreateUserName(createUser.getName()); |
| | | //propertyCompanyScoreVO.setUpdateUserName(updateUser.getName()); |
| | | |
| | | return propertyCompanyScoreVO; |
| | | } |
| | | |
| | | |
| | | } |