划扣新增接口添加对比照片记录

ANDRU-PC\Andru

2021-12-13 51ec88a224ad7472078b27665e85b8a28a8507dc

划扣新增接口添加对比照片记录

 phi_platform_common/src/main/java/com/hx/phip/dao/mapper/ComparePhotoRecordMapper.java

New file
@@ -0,0 +1,35 @@
package com.hx.phip.dao.mapper;

import java.util.List;
import java.util.Map;
import com.hx.mybatisTool.SqlSentence;
import com.hx.phiappt.model.ComparePhotoRecord;

public interface ComparePhotoRecordMapper {
    /**新增，返回主键*/
    int insert(ComparePhotoRecord comparePhotoRecord);
    /**查询条数*/
    int selectCount(SqlSentence sqlSentence);
    /**查询条数*/
    int selectCountSql(SqlSentence sqlSentence);
    /**查询列表，返回实体类的List*/
    List<ComparePhotoRecord> selectList(SqlSentence sqlSentence);
    /**查询列表，返回Map的List*/
    List<Map<String,Object>> selectListMap(SqlSentence sqlSentence);
    /**查询，返回单个实体*/
    ComparePhotoRecord selectOne(SqlSentence sqlSentence);
    /**查询，返回单个map*/
    Map<String,Object> selectOneMap(SqlSentence sqlSentence);
    /**查询，返回实体类没有大数据的*/
    ComparePhotoRecord selectOneByKey(Object object);
    /**查询，返回实体类有大数据的*/
    ComparePhotoRecord selectOneByKeyBlob(Object object);
    /**更新，返回更新数量*/
    int updateWhere(SqlSentence sqlSentence);
    /**更新，返回更新数量*/
    int updateAll(ComparePhotoRecord comparePhotoRecord);
    /**删除，返回删除数量*/
    int deleteWhere(SqlSentence sqlSentence);
    /**删除，返回删除数量*/
    int deleteById(Object object);
}

 phi_platform_common/src/main/java/com/hx/phip/dao/mapper/ComparePhotoRecordPicturesMapper.java

New file
@@ -0,0 +1,35 @@
package com.hx.phip.dao.mapper;

import java.util.List;
import java.util.Map;
import com.hx.mybatisTool.SqlSentence;
import com.hx.phiappt.model.ComparePhotoRecordPictures;

public interface ComparePhotoRecordPicturesMapper {
    /**新增，返回主键*/
    int insert(ComparePhotoRecordPictures comparePhotoRecordPictures);
    /**查询条数*/
    int selectCount(SqlSentence sqlSentence);
    /**查询条数*/
    int selectCountSql(SqlSentence sqlSentence);
    /**查询列表，返回实体类的List*/
    List<ComparePhotoRecordPictures> selectList(SqlSentence sqlSentence);
    /**查询列表，返回Map的List*/
    List<Map<String,Object>> selectListMap(SqlSentence sqlSentence);
    /**查询，返回单个实体*/
    ComparePhotoRecordPictures selectOne(SqlSentence sqlSentence);
    /**查询，返回单个map*/
    Map<String,Object> selectOneMap(SqlSentence sqlSentence);
    /**查询，返回实体类没有大数据的*/
    ComparePhotoRecordPictures selectOneByKey(Object object);
    /**查询，返回实体类有大数据的*/
    ComparePhotoRecordPictures selectOneByKeyBlob(Object object);
    /**更新，返回更新数量*/
    int updateWhere(SqlSentence sqlSentence);
    /**更新，返回更新数量*/
    int updateAll(ComparePhotoRecordPictures comparePhotoRecordPictures);
    /**删除，返回删除数量*/
    int deleteWhere(SqlSentence sqlSentence);
    /**删除，返回删除数量*/
    int deleteById(Object object);
}

 phi_platform_common/src/main/resources/mapper/ComparePhotoRecordMapper.xml

New file
@@ -0,0 +1,86 @@
<?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">
<!-- namespace:该mapper.xml映射文件的 唯一标识 -->
<mapper namespace="com.hx.phip.dao.mapper.ComparePhotoRecordMapper">

    <!-- 整个实体类修改，表字段=实体类字段-->
    <sql id="Update_Column_All">
        <trim prefixOverrides=",">
            ,userId = #{userId},projectId = #{projectId},projectFrequency = #{projectFrequency},type = #{type},remark = #{remark},deductionProjectId = #{deductionProjectId},deductionSingleId = #{deductionSingleId},isDel = #{isDel},createTime = #{createTime}
        </trim>
    </sql>
	 
    <!--  后续通过  namespace.id-->
    <!--parameterType:输入参数的类型
    resultType：查询返回结果值的类型  ，返回类型  -->
    <insert id="insert" parameterType="com.hx.phiappt.model.ComparePhotoRecord">
        <selectKey keyProperty="id" resultType="String" order="BEFORE">
               select replace(uuid(),'-','') from dual
        </selectKey>
        insert into compare_photo_record (id,userId,projectId,projectFrequency,type,remark,deductionProjectId,deductionSingleId,isDel,createTime)  values (#{id},#{userId},#{projectId},#{projectFrequency},#{type},#{remark},#{deductionProjectId},#{deductionSingleId},#{isDel},#{createTime})
    </insert>

    <select id="selectList" resultType="com.hx.phiappt.model.ComparePhotoRecord" parameterType="com.hx.mybatisTool.SqlSentence" >
        ${sqlSentence}
    </select>

    <select id="selectListMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" >
            ${sqlSentence}
    </select>

    <select id="selectOne" resultType="com.hx.phiappt.model.ComparePhotoRecord" parameterType="com.hx.mybatisTool.SqlSentence" >
        ${sqlSentence}
    </select>

    <select id="selectOneMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" >
            ${sqlSentence}
    </select>

    <select id="selectCount" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" >
            select
                COUNT(*)
            from compare_photo_record
                WHERE ${sqlSentence}
    </select>

    <select id="selectCountSql" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" >
            ${sqlSentence}
     </select>

    <select id="selectOneByKey" resultType="com.hx.phiappt.model.ComparePhotoRecord" parameterType="java.lang.Object" >
        select 
            id,userId,projectId,projectFrequency,type,remark,deductionProjectId,deductionSingleId,isDel,createTime
        from compare_photo_record
        WHERE id = #{value}
    </select>

    <select id="selectOneByKeyBlob" resultType="com.hx.phiappt.model.ComparePhotoRecord" parameterType="java.lang.Object" >
        select 
            id,userId,projectId,projectFrequency,type,remark,deductionProjectId,deductionSingleId,isDel,createTime
        from compare_photo_record
        WHERE id = #{value}
    </select>

    <update id="updateWhere" parameterType="com.hx.mybatisTool.SqlSentence">
        update
            compare_photo_record
        SET ${sqlSentence}
    </update>

    <update id="updateAll" parameterType="com.hx.phiappt.model.ComparePhotoRecord">
        update compare_photo_record
            SET <include refid="Update_Column_All"/>
        WHERE id = #{id}
    </update>

    <delete id="deleteWhere"  parameterType="com.hx.mybatisTool.SqlSentence">
        delete from compare_photo_record WHERE ${sqlSentence}
    </delete>

    <delete id="deleteById"  parameterType="java.lang.Object">
        delete from compare_photo_record WHERE id = #{value}
    </delete>
	
</mapper>

 phi_platform_common/src/main/resources/mapper/ComparePhotoRecordPicturesMapper.xml

New file
@@ -0,0 +1,86 @@
<?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">
<!-- namespace:该mapper.xml映射文件的 唯一标识 -->
<mapper namespace="com.hx.phip.dao.mapper.ComparePhotoRecordPicturesMapper">

    <!-- 整个实体类修改，表字段=实体类字段-->
    <sql id="Update_Column_All">
        <trim prefixOverrides=",">
            ,comparePhotoRecordId = #{comparePhotoRecordId},type = #{type},imgUrl = #{imgUrl},isShow = #{isShow},isDel = #{isDel},createTime = #{createTime}
        </trim>
    </sql>
	 
    <!--  后续通过  namespace.id-->
    <!--parameterType:输入参数的类型
    resultType：查询返回结果值的类型  ，返回类型  -->
    <insert id="insert" parameterType="com.hx.phiappt.model.ComparePhotoRecordPictures">
        <selectKey keyProperty="id" resultType="String" order="BEFORE">
               select replace(uuid(),'-','') from dual
        </selectKey>
        insert into compare_photo_record_pictures (id,comparePhotoRecordId,type,imgUrl,isShow,isDel,createTime)  values (#{id},#{comparePhotoRecordId},#{type},#{imgUrl},#{isShow},#{isDel},#{createTime})
    </insert>

    <select id="selectList" resultType="com.hx.phiappt.model.ComparePhotoRecordPictures" parameterType="com.hx.mybatisTool.SqlSentence" >
        ${sqlSentence}
    </select>

    <select id="selectListMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" >
            ${sqlSentence}
    </select>

    <select id="selectOne" resultType="com.hx.phiappt.model.ComparePhotoRecordPictures" parameterType="com.hx.mybatisTool.SqlSentence" >
        ${sqlSentence}
    </select>

    <select id="selectOneMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" >
            ${sqlSentence}
    </select>

    <select id="selectCount" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" >
            select
                COUNT(*)
            from compare_photo_record_pictures
                WHERE ${sqlSentence}
    </select>

    <select id="selectCountSql" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" >
            ${sqlSentence}
     </select>

    <select id="selectOneByKey" resultType="com.hx.phiappt.model.ComparePhotoRecordPictures" parameterType="java.lang.Object" >
        select 
            id,comparePhotoRecordId,type,imgUrl,isShow,isDel,createTime
        from compare_photo_record_pictures
        WHERE id = #{value}
    </select>

    <select id="selectOneByKeyBlob" resultType="com.hx.phiappt.model.ComparePhotoRecordPictures" parameterType="java.lang.Object" >
        select 
            id,comparePhotoRecordId,type,imgUrl,isShow,isDel,createTime
        from compare_photo_record_pictures
        WHERE id = #{value}
    </select>

    <update id="updateWhere" parameterType="com.hx.mybatisTool.SqlSentence">
        update
            compare_photo_record_pictures
        SET ${sqlSentence}
    </update>

    <update id="updateAll" parameterType="com.hx.phiappt.model.ComparePhotoRecordPictures">
        update compare_photo_record_pictures
            SET <include refid="Update_Column_All"/>
        WHERE id = #{id}
    </update>

    <delete id="deleteWhere"  parameterType="com.hx.mybatisTool.SqlSentence">
        delete from compare_photo_record_pictures WHERE ${sqlSentence}
    </delete>

    <delete id="deleteById"  parameterType="java.lang.Object">
        delete from compare_photo_record_pictures WHERE id = #{value}
    </delete>
	
</mapper>

 phi_platform_user/src/main/java/com/hx/phip/deduction/controller/DeductionController.java

@@ -28,7 +28,7 @@
    /**
     * 划扣记录
     */
    @PostMapping("/add")
    @RequestMapping(value = "/add", method = RequestMethod.POST)
    public void orderAdd(HttpServletRequest request, DeductionDto deductionDto) {
        // 校验参数
        checkParam(deductionDto);

 phi_platform_user/src/main/java/com/hx/phip/deduction/service/impl/DeductionSingleServiceImpl.java

@@ -3,6 +3,7 @@
import javax.annotation.Resource;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.hx.common.dao.CommonDao;
import com.hx.phiappt.common.DeductionSingleConstants;
import com.hx.phiappt.common.OrderGoodsConstants;
@@ -298,7 +299,27 @@

            //处理治疗图片信息
            if(StringUtils.isEmpty(deductionDto.getComparePhotoRecordJson())){

                List<ComparePhotoRecordPictures> comparePhotoRecordPicturesList = JSONArray.parseArray(deductionDto.getComparePhotoRecordJson(), ComparePhotoRecordPictures.class);
                if( comparePhotoRecordPicturesList != null && comparePhotoRecordPicturesList.size() > 0) {
                    ComparePhotoRecord comparePhotoRecord = new ComparePhotoRecord();
                    comparePhotoRecord.setUserId(deductionSingle.getUserId());
                    comparePhotoRecord.setProjectId(deductionProject.getProjectId());
                    comparePhotoRecord.setProjectFrequency(0);
                    comparePhotoRecord.setDeductionProjectId(deductionProject.getId());
                    comparePhotoRecord.setDeductionSingleId(deductionSingle.getId());
                    int insert = commonDao.insert(ComparePhotoRecordMapper.class, comparePhotoRecord);
                    if (insert != 1) {
                        throw new TipsException("新增治疗图片类型记录失败！");
                    }else{
                        comparePhotoRecordPicturesList.forEach(comparePhotoRecordPictures -> {
                            comparePhotoRecordPictures.setComparePhotoRecordId(comparePhotoRecord.getId());
                            if(StringUtils.isEmpty(comparePhotoRecordPictures.getImgUrl())){
                                throw new PlatTipsException(PlatformCode.ERROR_PARAMETER_NULL,"治疗图片类型不能未空！");
                            }
                            commonDao.insert(ComparePhotoRecordPicturesMapper.class,comparePhotoRecordPictures);
                        });
                    }
                }
            }
        }else{
            throw new PlatTipsException(PlatformCode.ERROR_TIPS,"商品划扣还在开发中！");

 phi_platform_user/src/main/java/com/hx/phip/service/ComparePhotoRecordPicturesService.java

New file
@@ -0,0 +1,33 @@
package com.hx.phip.service;

import com.hx.phiappt.model.ComparePhotoRecordPictures;
import com.hx.mybatisTool.SqlSentence;
import java.util.List;
import java.util.Map;

public interface ComparePhotoRecordPicturesService {

    int selectCount(SqlSentence sqlSentence);

    void insert(ComparePhotoRecordPictures comparePhotoRecordPictures);

    List<ComparePhotoRecordPictures> selectList(SqlSentence sqlSentence);

    List<Map<String,Object>> selectListMap(SqlSentence sqlSentence);

    ComparePhotoRecordPictures selectOne(SqlSentence sqlSentence);

    Map<String,Object> selectOneMap(SqlSentence sqlSentence);

    ComparePhotoRecordPictures selectOneByKey(Object object);

    ComparePhotoRecordPictures selectOneByKeyBlob(Object object);
    
    void updateAll(ComparePhotoRecordPictures comparePhotoRecordPictures);

    void updateWhere(SqlSentence sqlSentence);
    
    void deleteOne(String delId);


}

 phi_platform_user/src/main/java/com/hx/phip/service/ComparePhotoRecordService.java

New file
@@ -0,0 +1,33 @@
package com.hx.phip.service;

import com.hx.phiappt.model.ComparePhotoRecord;
import com.hx.mybatisTool.SqlSentence;
import java.util.List;
import java.util.Map;

public interface ComparePhotoRecordService {

    int selectCount(SqlSentence sqlSentence);

    void insert(ComparePhotoRecord comparePhotoRecord);

    List<ComparePhotoRecord> selectList(SqlSentence sqlSentence);

    List<Map<String,Object>> selectListMap(SqlSentence sqlSentence);

    ComparePhotoRecord selectOne(SqlSentence sqlSentence);

    Map<String,Object> selectOneMap(SqlSentence sqlSentence);

    ComparePhotoRecord selectOneByKey(Object object);

    ComparePhotoRecord selectOneByKeyBlob(Object object);
    
    void updateAll(ComparePhotoRecord comparePhotoRecord);

    void updateWhere(SqlSentence sqlSentence);
    
    void deleteOne(String delId);


}

 phi_platform_user/src/main/java/com/hx/phip/service/impl/ComparePhotoRecordPicturesServiceImpl.java

New file
@@ -0,0 +1,101 @@
package com.hx.phip.service.impl;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.hx.exception.TipsException;
import com.hx.phip.dao.mapper.ComparePhotoRecordPicturesMapper;
import com.hx.phiappt.model.ComparePhotoRecordPictures;
import com.hx.phip.service.ComparePhotoRecordPicturesService;
import com.hx.mybatisTool.SqlSentence;
import java.util.List;
import java.util.Map;

@Transactional
@Service
public class ComparePhotoRecordPicturesServiceImpl implements ComparePhotoRecordPicturesService {

    @Resource
    private ComparePhotoRecordPicturesMapper comparePhotoRecordPicturesMapper;

    /**查询列表*/
    @Override
    public List<ComparePhotoRecordPictures> selectList(SqlSentence sqlSentence) {
        return comparePhotoRecordPicturesMapper.selectList(sqlSentence);
    }

    /**查询列表*/
    @Override
    public List<Map<String,Object>> selectListMap(SqlSentence sqlSentence) {
        return comparePhotoRecordPicturesMapper.selectListMap(sqlSentence);
    }

    /**查询单个*/
    @Override
    public ComparePhotoRecordPictures selectOne(SqlSentence sqlSentence) {
        return comparePhotoRecordPicturesMapper.selectOne(sqlSentence);
    }

    /**查询单个*/
    @Override
    public Map<String,Object> selectOneMap(SqlSentence sqlSentence) {
        return comparePhotoRecordPicturesMapper.selectOneMap(sqlSentence);
    }

    /**查询单个，大数据不拿取*/
    @Override
    public ComparePhotoRecordPictures selectOneByKey(Object object) {
        return comparePhotoRecordPicturesMapper.selectOneByKey(object);
    }

    /**查询单个，大数据拿取*/
    @Override
    public ComparePhotoRecordPictures selectOneByKeyBlob(Object object) {
        return comparePhotoRecordPicturesMapper.selectOneByKeyBlob(object);
    }

    /**新增*/
    @Override
    public void insert(ComparePhotoRecordPictures comparePhotoRecordPictures) {
        int count = comparePhotoRecordPicturesMapper.insert(comparePhotoRecordPictures);
        if(count != 1) {
            throw new TipsException("新增失败！");
        }
    }

    /**修改*/
    @Override
    public void updateAll(ComparePhotoRecordPictures comparePhotoRecordPictures) {
        int count = comparePhotoRecordPicturesMapper.updateAll(comparePhotoRecordPictures);
        if(count!=1) {
            throw new TipsException("保存失败！");
        }
    }

    /**修改*/
    @Override
    public void updateWhere(SqlSentence sqlSentence) {
        int count = comparePhotoRecordPicturesMapper.updateWhere(sqlSentence);
        if(count!=1) {
            throw new TipsException("保存失败！");
        }
    }
	
    /**删除一个*/
    @Override
    public void deleteOne(String delId) {
        int count = comparePhotoRecordPicturesMapper.deleteById(delId);
        if(count!=1) {
            throw new TipsException("删除失败！");
        }
    }

    /**查询条数*/
    @Override
    public int selectCount(SqlSentence sqlSentence) {
        int count = comparePhotoRecordPicturesMapper.selectCount(sqlSentence);
        return count;
    }
}

 phi_platform_user/src/main/java/com/hx/phip/service/impl/ComparePhotoRecordServiceImpl.java

New file
@@ -0,0 +1,101 @@
package com.hx.phip.service.impl;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.hx.exception.TipsException;
import com.hx.phip.dao.mapper.ComparePhotoRecordMapper;
import com.hx.phiappt.model.ComparePhotoRecord;
import com.hx.phip.service.ComparePhotoRecordService;
import com.hx.mybatisTool.SqlSentence;
import java.util.List;
import java.util.Map;

@Transactional
@Service
public class ComparePhotoRecordServiceImpl implements ComparePhotoRecordService {

    @Resource
    private ComparePhotoRecordMapper comparePhotoRecordMapper;

    /**查询列表*/
    @Override
    public List<ComparePhotoRecord> selectList(SqlSentence sqlSentence) {
        return comparePhotoRecordMapper.selectList(sqlSentence);
    }

    /**查询列表*/
    @Override
    public List<Map<String,Object>> selectListMap(SqlSentence sqlSentence) {
        return comparePhotoRecordMapper.selectListMap(sqlSentence);
    }

    /**查询单个*/
    @Override
    public ComparePhotoRecord selectOne(SqlSentence sqlSentence) {
        return comparePhotoRecordMapper.selectOne(sqlSentence);
    }

    /**查询单个*/
    @Override
    public Map<String,Object> selectOneMap(SqlSentence sqlSentence) {
        return comparePhotoRecordMapper.selectOneMap(sqlSentence);
    }

    /**查询单个，大数据不拿取*/
    @Override
    public ComparePhotoRecord selectOneByKey(Object object) {
        return comparePhotoRecordMapper.selectOneByKey(object);
    }

    /**查询单个，大数据拿取*/
    @Override
    public ComparePhotoRecord selectOneByKeyBlob(Object object) {
        return comparePhotoRecordMapper.selectOneByKeyBlob(object);
    }

    /**新增*/
    @Override
    public void insert(ComparePhotoRecord comparePhotoRecord) {
        int count = comparePhotoRecordMapper.insert(comparePhotoRecord);
        if(count != 1) {
            throw new TipsException("新增失败！");
        }
    }

    /**修改*/
    @Override
    public void updateAll(ComparePhotoRecord comparePhotoRecord) {
        int count = comparePhotoRecordMapper.updateAll(comparePhotoRecord);
        if(count!=1) {
            throw new TipsException("保存失败！");
        }
    }

    /**修改*/
    @Override
    public void updateWhere(SqlSentence sqlSentence) {
        int count = comparePhotoRecordMapper.updateWhere(sqlSentence);
        if(count!=1) {
            throw new TipsException("保存失败！");
        }
    }
	
    /**删除一个*/
    @Override
    public void deleteOne(String delId) {
        int count = comparePhotoRecordMapper.deleteById(delId);
        if(count!=1) {
            throw new TipsException("删除失败！");
        }
    }

    /**查询条数*/
    @Override
    public int selectCount(SqlSentence sqlSentence) {
        int count = comparePhotoRecordMapper.selectCount(sqlSentence);
        return count;
    }
}