2020-11-11笔记

最新推荐文章于 2020-11-30 20:24:25 发布
最新推荐文章于 2020-11-30 20:24:25 发布
阅读量150 收藏
点赞数
分类专栏： java 文章标签： mybatis java spring
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/gaorunsen/article/details/109620016
版权

目录

pom.xml

<properties>
		<java.version>1.8</java.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>2.1.1</version>
		</dependency>

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.projectlombok</groupId>
			<artifactId>lombok</artifactId>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
			<exclusions>
				<exclusion>
					<groupId>org.junit.vintage</groupId>
					<artifactId>junit-vintage-engine</artifactId>
				</exclusion>
			</exclusions>
		</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>

application.yml

spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    username: root
    password: 123456
    url: jdbc:mysql:///madata?serverTimezone=GMT%2B8&characterEncoding=utf-8&&allowMultiQueries=true

mybatis:
  mapper-locations: classpath:mybatis-mapper/*Mapper.xml

server:
  port: 80

*mapper.xml

<?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="com.zr.mapper.PlanClassMapper">



  <update id="updateStatusById" parameterType="com.zr.model.PlanClassVo">
     <if test="status==0">
         UPDATE planclass SET status = 1 WHERE id=#{id}
     </if>
      <if test="status==1">
          UPDATE planclass SET status = 0 WHERE id=#{id}
      </if>
  </update>

    <select id="queryCount" parameterType="java.util.Map" resultType="java.lang.Integer">
        SELECT count(*) FROM planclass
        <where>
            <if test="code!=null and code!=''">
                and code LIKE conat('%',#{code},'%')
            </if>
            <if test="name!=null and name!=''">
                and name LIKE concat('%',#{name},'%')
            </if>

            <if test="status != 10">
                and status=#{status}
            </if>
        </where>

    </select>

    <select id="queryAllUser" parameterType="java.util.Map" resultType="com.zr.model.PlanClassVo">
    SELECT * FROM planclass
    <where>
    <if test="code!=null and code!=''">
        and code LIKE conat('%',#{code},'%')
    </if>
    <if test="name!=null and name!=''">
        and name LIKE concat('%',#{name},'%')
    </if>
        <if test="status != 10 ">
            and status=#{status}
        </if>
    </where>
        limit #{index},#{pageSize}
    </select>
<!--
    update user set name=#{name} where id=#{id};update user set name=#{name} where id=#{id};update user set name=#{name} where id=#{id}
-->
  <!--

    insert into user (id,name) values (1,2),(3,4),()-->

<!--    SELECT * from user where id IN (1,2,3,4)-->

     <select id="queryUser" resultType="com.zr.test.pojo.User">
         SELECT  * from user

     </select>

     <select id="queryUserByIds" parameterType="java.util.List" resultType="com.zr.test.pojo.User">
         SELECT  * from user WHERE  id IN
         <foreach collection="list" item="item" open="(" separator="," close=")">
             #{item}
         </foreach>
     </select>
     &lt;!&ndash; select * from user where id in (1,2,3,)&ndash;&gt;

     <insert id="insertUserList" parameterType="java.util.List" >
         INSERT  into user (id,name) VALUES
         <foreach collection="list" item="aa" open="(" separator="),(" close=")">
             #{aa.id},#{aa.name}
         </foreach>

     </insert>

     &lt;!&ndash;  INSERT  into "user" (id,name) VALUES  (1,小明),(2，小刚)&ndash;&gt;

     <delete id="delelteUserByIds" parameterType="java.util.List">

         DELETE  from user where id IN
         <foreach collection="list" item="item" open="(" separator="," close=")">
             #{item}
         </foreach>
     </delete>

     &lt;!&ndash; DELETE  from "user" where id IN  (1,2,3,)&ndash;&gt;

     <update id="updateUsers" parameterType="java.util.List">
       <foreach collection="list" item="item" separator=";">
           UPDATE  user SET name=#{item.name} where id = #{item.id}
       </foreach>
     </update>

     &lt;!&ndash; 根据多个用户名称和一个班级名称查询出相应的班级数据&ndash;&gt;
     <select id="queryClass" parameterType="com.zr.test.pojo.ClassVo" resultType="com.zr.test.pojo.ClassVo">
         SELECT  *  FROM  user_class uc LEFT JOIN  user u ON  uc.id= u.classId
         WHERE  uc.className=#{className}
         and u.name in
       <foreach collection="userList" item="item" open="(" separator="," close=")">
           #{item.name}
       </foreach>

     </select>

    <!--  UPDATE  "user" SET name="小明" where id = 1;UPDATE  "user" SET name="小刚" where id = 2-->


    <select id="queryPlantByIdList" parameterType="java.util.List" resultType="com.zr.plant.pojo.PlantVo">
        SELECT * from plant WHERE id IN
        <foreach collection="list" item="item" open="(" separator="," close=")" >
            #{item}
        </foreach>

    </select>

    <select id="queryList" parameterType="com.zr.demo.pojo.DemoPlant" resultType="com.zr.plant.pojo.PlantVo">
        SELECT * from plant WHERE 1=1
        <if test="legalPlantCode!=null and legalPlantCode!=''">
            AND p.legalPlantCode LIKE CONCAT('%',#{legalPlantCode},'%')
        </if>
        and id in
        <foreach collection="ids" item="item" open="(" separator="," close=")" >
            #{item}
        </foreach>
        and legalPersonCode in
        <foreach collection="plantVoList" item="item" open="(" separator="," close=")" >
            #{item.legalPersonCode}
        </foreach>

    </select>

    <insert id="addList" parameterType="java.util.List">
        INSERT  into plant (legalPersonCode,legalPlantCode) VALUES
        <foreach collection="list" item="item" open="(" separator="),(" close=")">
            #{item.legalPersonCode}, #{item.legalPlantCode}
        </foreach>
    </insert>

    <update id="updateList" parameterType="java.util.List">

        <foreach collection="list" item="item"  separator=";">
            update plant set legalPersonCode=#{item.legalPersonCode},legalPlantCode=#{item.legalPlantCode} where legalPlantCode =#{item.legalPlantCode}
        </foreach>
    </update>
    <!--update plant set legalPersonCode=1111,legalPlantCode=222;update plant set legalPersonCode=333,legalPlantCode=444-->

<!--    INSERT  into plant (legalPersonCode,legalPlantCode) VALUES (111,222),(333,4444)-->

    <!-- SELECT * from plant id IN (1,2,3)-->

    <select id="queryData" parameterType="com.zr.plant.pojo.PlantSelectVo"
            resultType="com.zr.plant.pojo.PlantVo">
        select p.*,l.legalPersonName from plant p LEFT JOIN legalPerson l on
        p.legalPersonCode=l.legalPersonCode
        where 1=1
        <if test="legalPlantCode!=null and legalPlantCode!=''">
            AND p.legalPlantCode LIKE CONCAT('%',#{legalPlantCode},'%')
        </if>
        <if test="legalPlantDec!=null and legalPlantDec!=''">
            AND p.legalPlantDec LIKE CONCAT('%',#{legalPlantDec},'%')
        </if>
        <if test="legalPersonCode!=null and legalPersonCode!=''">
            and p.legalPersonCode =#{legalPersonCode}
        </if>
        <if test="enabled!=null">
            and p.enabled =#{enabled}
        </if>
        limit #{offset} , #{pageSize}
    </select>
    <select id="queryCount" parameterType="com.zr.plant.pojo.PlantSelectVo"
            resultType="java.lang.Integer">
        select count(p.id)
        from plant p LEFT JOIN legalPerson l on
        p.legalPersonCode=l.legalPersonCode
        where 1=1
        <if test="legalPlantCode!=null and legalPlantCode!=''">
            AND p.legalPlantCode LIKE CONCAT('%',#{legalPlantCode},'%')
        </if>
        <if test="legalPlantDec!=null and legalPlantDec!=''">
            AND p.legalPlantDec LIKE CONCAT('%',#{legalPlantDec},'%')
        </if>
        <if test="legalPersonCode!=null and legalPersonCode!=''">
            and p.legalPersonCode =#{legalPersonCode}
        </if>
        <if test="enabled!=null">
            and p.enabled =#{enabled}
        </if>
    </select>
    <select id="queryUser" resultType="com.zr.User" >
        SELECT id FROM  user_info
    </select>

    <select id="queryPage" parameterType="com.zr.plant.pojo.PlantSelectVo"
            resultType="com.zr.plant.pojo.PlantClass">
        select le.id,le.remark legalPlantDec,le.code legalPlantCode,le.`status` enabled,le.legalPersonCode,ln.`name` legalPersonName
        from legalpersonplant le left join legalperson ln on le.legalPersonCode =  ln.code
        where 1=1
        <if test="legalPlantDec!=null and legalPlantDec!=''">
            and le.remark =#{legalPlantDec}
        </if>
        <if test="legalPlantCode!=null and legalPlantCode!=''">
            and le.code =#{legalPlantCode}
        </if>
        <if test="enabled!=null">
            and le.status =#{enabled}
        </if>
        <if test="legalPersonCode!=null and legalPlantCode!=''">
            and le.legalPersonCode =#{legalPersonCode}
        </if>
        limit #{offset} , #{pageSize}
    </select>
    <select id="queryCount" parameterType="com.zr.plant.pojo.PlantSelectVo"
            resultType="java.lang.Integer">
        select count(le.id)
        FROM legalpersonplant le
        where 1=1
        <if test="legalPlantDec!=null and legalPlantDec!=''">
            and le.remark =#{legalPlantDec}
        </if>
        <if test="legalPlantCode!=null and legalPlantCode!=''">
            and le.code =#{legalPlantCode}
        </if>
        <if test="enabled!=null">
            and le.status =#{enabled}
        </if>
        <if test="legalPersonCode!=null and legalPlantCode!=''">
            and le.legalPersonCode =#{legalPersonCode}
        </if>
    </select>


<select id="queryUserAll" resultType="com.zr.demo.pojo.User">

    SELECT  * FROM  USER
</select>
<select id="queryUserByIds" parameterType="java.util.List" resultType="com.zr.demo.pojo.User">
    SELECT  * from user WHERE  id IN
    <foreach collection="idList" item="item" open="(" close=")" separator=",">
        #{item}
    </foreach>
</select>
<!--&lt;!&ndash; 完成用户的批量新增 批量删除&ndash;&gt;-->

    <insert id="addPlanClassList" parameterType="java.util.List">
        insert into planclass (nlegalPlantCodeclegalPlantDecmark,status) VALUES
        <foreach collection="list" item="aaa" open="(" separator="),(" close=")">
            #{aaa.name},#{legalPlantCodecode},#{legalPlantDecmark},#{aaa.status}
        </foreach>
    </insert>
<!--insert into user (id,name) values ()()()
    update user set name=#{name},age=#{age};update user set name=#{name},age=#{age};-->

<!-- 批量修改-->

    <update id="updateUserList" parameterType="com.zr.demo.pojo.User">
        <foreach collection="userList" item="item" separator=";">
            UPDATE  user SET name=#{item.name},age=#{item.age},sex=#{item.sex} WHERE id =#{item.id}
        </foreach>

    </update>

    <insert id="addPlanClassList" parameterType="java.util.List">
            insert into planclass (nlegalPlantCodeclegalPlantDecmark,status) VALUES
            <foreach collection="list" item="aaa" open="(" separator="),(" close=")">
                #{aaa.name},#{legalPlantCodecode},#{legalPlantDecmark},#{aaa.status}
            </foreach>
        </insert>

        <update id="updatePlanClassList" parameterType="java.util.List">
            <foreach collection="list" item="item"  separator=";" >
                UPDATE planclass SET  name = #{item.nalegalPlantCodecode= #{ilegalPlantCodecode},status=#{item.status}
                WHERE id = #{item.id}
            </foreach>
        </update>


        <delete id="deletePlanClassByIdList" parameterType="java.util.List">
            DELETE  from planclass WHERE  id IN
            <foreach collection="list" item="item" open="(" close=")" separator=",">
                #{item}
            </foreach>
        </delete>
<!--    &lt;!&ndash; 分页查询计划大类数据&ndash;&gt;-->
        <select id="queryPage" parameterType="com.zr.plant.model.PlantSelectVo"
                resultType="com.zr.plant.model.Plant">
            select t.id,t.legalPlantCode,t.legalPlantDec,t.enabled,t.legalPersonCode,l.legalPersonName,t.createTime,t.createId,t.version
            FROM plant t LEFT JOIN legalperson l ON t.legalPersonCode = l.legalPersonCode
            where 1=1
            <if test="legalPersonCode!=null and legalPersonCode!=''">
                and t.legalPersonCode =#{legalPersonCode}
            </if>
            <if test="legalPlantCode!=null and legalPlantCode!=''">
                and t.legalPlantCode =#{legalPlantCode}
            </if>
            <if test="legalPlantDec!=null and legalPlantDec!=''">
                and t.legalPlantDec =#{legalPlantDec}
            </if>
            <if test="enabled!=null">
                and t.enabled =#{enabled}
            </if>
            limit #{offset} , #{pageSize}
        </select>

<!--        &lt;!&ndash;分页查询总条数&ndash;&gt;-->
        <select id="queryCount" parameterType="com.zr.plant.model.PlantSelectVo"
                resultType="java.lang.Integer">
            select count(*)
            FROM plant t where 1=1
            <if test="legalPersonCode!=null and legalPersonCode!=''">
                and t.legalPersonCode =#{legalPersonCode}
            </if>
            <if test="legalPlantCode!=null and legalPlantCode!=''">
                and t.legalPlantCode =#{legalPlantCode}
            </if>
            <if test="legalPlantDec!=null and legalPlantDec!=''">
                and t.legalPlantDec =#{legalPlantDec}
            </if>
            <if test="enabled!=null">
                and t.enabled =#{enabled}
            </if>
        </select>
    <select id="findPlanClassByNameList" parameterType="java.util.List" resultType="com.zr.planclass.moPlantClasslass">
          SELECT  * FROM  planclass WHERE name  IN
        <foreach collection="list" item="item" open="(" close=")" separator=",">
            #{item}
        </foreach>
    </select>

    <insert id="addPlanClassList" parameterType="java.util.List">
        insert into planclass (nlegalPlantCodeclegalPlantDecmark,status) VALUES
        <foreach collection="list" item="aaa" open="(" separator="),(" close=")">
            #{aaa.name},#{legalPlantCodecode},#{legalPlantDecmark},#{aaa.status}
        </foreach>
    </insert>

    <update id="updatePlanClassList" parameterType="java.util.List">
        <foreach collection="list" item="item"  separator=";" >
            UPDATE planclass SET  name = #{item.nalegalPlantCodecode= #{ilegalPlantCodecode},status=#{item.status}
            WHERE id = #{item.id}
        </foreach>
    </update>
    <delete id="deletePlanClassByIdList" parameterType="java.util.List">
        DELETE  from planclass WHERE  id IN
        <foreach collection="list" item="item" open="(" close=")" separator=",">
            #{item}
        </foreach>
    </delete>


    <select id="queryPartnerData" parameterType="com.zr.inquiry.pojo.SupplierSelectVo"
            resultType="com.zr.inquiry.pojo.SupplierVo">
        select t.partnerName,t.partnerCode
        FROM supplier t where 1=1
        <if test="partnerCode!=null and partnerCode!=''">
            and t.partnerCode =#{partnerCode}
        </if>
        <if test="partnerName!=null and partnerName!=''">
            and t.partnerName =#{partnerName}
        </if>
        limit #{offset} , #{pageSize}
    </select>

<!--    &lt;!&ndash;询价单分页查询总条数&ndash;&gt;-->
    <select id="queryInquiryCount" parameterType="com.zr.inquiry.pojo.MaterialSelectVo"
            resultType="java.lang.Integer">
        select count(*)
        FROM inquirytotal t
        <if test="vendor!=null and vendor!=''">
            LEFT JOIN inquirysupplierdetail su ON t.id = su.inquiryId
        </if>
        where 1=1
        <if test="vendor!=null and vendor!=''">
            and su.vendorCode =#{vendor}
        </if>
        <if test="requestForQuotationId!=null and requestForQuotationId!=''">
            and t.requestForQuotationId =#{requestForQuotationId}
        </if>
        <if test="createStartTime!=null">
            <![CDATA[ and t.createTime >=#{createStartTime} ]]>
        </if>
        <if test="createEndTime!=null">
            <![CDATA[ and t.createTime <=#{createEndTime} ]]>
        </if>
        <if test="startTime!=null">
            <![CDATA[ and t.startTime >=#{startTime} ]]>
        </if>
        <if test="endTime!=null">
            <![CDATA[ and t.endTime <=#{endTime} ]]>
        </if>
        <if test="type!=null">
            and t.type =#{type}
        </if>
        <if test="currencyCode!=null">
            and t.currencyCode =#{currencyCode}
        </if>
        <if test="isTax!=null">
            and t.isTax =#{isTax}
        </if>
        <if test="inquiryStatus!=null">
            and t.inquiryStatus =#{inquiryStatus}
        </if>
        <if test="telegalPersonCodeonId != null">
            anlegalPersonCodeonIdlegalPersonCodeonId}
        </if>

    </select>
<!--    &lt;!&ndash;询价单分页查询数据&ndash;&gt;-->
    <select id="queryInquiryData" parameterType="com.zr.inquiry.pojo.InquiryTotalSelectVo"
            resultType="com.zr.inquiry.pojo.InquiryTotalVo">
        select DISTINCT t.id,t.requestForQuotationId,t.createTime,t.startTime,t.endTime,t.creatorName,t.type,t.currencyCode,t.isTax,t.inquiryStatus,le.legalPersonName
        FROM inquirytotal t
        LEFT JOIN inquirysupplierdetail su ON t.id = su.inquiryId
        LEFT JOIN legalPerson le ONlegalPersonCodeonId = le.id
        where 1=1
        <if test="requestForQuotationId!=null and requestForQuotationId!=''">
            and t.requestForQuotationId =#{requestForQuotationId}
        </if>
        <if test="createStartTime!=null">
            <![CDATA[ and t.createTime >=#{createStartTime} ]]>
        </if>
        <if test="createEndTime!=null">
            <![CDATA[ and t.createTime <=#{createEndTime} ]]>
        </if>
        <if test="startTime!=null">
            <![CDATA[ and t.startTime >=#{startTime} ]]>
        </if>
        <if test="endTime!=null">
            <![CDATA[ and t.endTime <=#{endTime} ]]>
        </if>
        <if test="type!=null">
            and t.type =#{type}
        </if>
        <if test="currencyCode!=null">
            and t.currencyCode =#{currencyCode}
        </if>
        <if test="isTax!=null">
            and t.isTax =#{isTax}
        </if>
        <if test="inquiryStatus!=null">
            and t.inquiryStatus =#{inquiryStatus}
        </if>
        <if test="telegalPersonCodeonId!=null">
            anlegalPersonCodeonIdlegalPersonCodeonId}
        </if>
        <if test="vendor!=null and vendor!=''">
            and su.vendorCode =#{vendor}
        </if>
        limit #{offset} , #{pageSize}
    </select>

<!--    &lt;!&ndash;分页查询总条数&ndash;&gt;-->
    <select id="queryPartnerCount" parameterType="com.zr.inquiry.pojo.SupplierSelectVo"
            resultType="java.lang.Integer">
        select count(*)
        FROM supplier t where 1=1
        <if test="partnerCode!=null and partnerCode!=''">
            and t.partnerCode =#{partnerCode}
        </if>
        <if test="partnerName!=null and partnerName!=''">
            and t.partnerName =#{partnerName}
        </if>
    </select>

    <select id="querySpareByCodeList" parameterType="java.util.List" resultType="com.zr.inquiry.pojo.InquirySpareVo">
        SELElegalPlantCodecode spareCoding,name spareName  from spare whlegalPlantCodecode IN
        <foreach collection="list" item="item" open="(" close=")" separator=",">
            #{item}
        </foreach>
    </select>

    <select id="querySupplierBySpareCodeList" parameterType="java.util.List" resultType="com.zr.inquiry.pojo.SpareSupplierVo">
        SELECT  *  FROM supplier_spare where spareCode IN
        <foreach collection="list" item="item" open="(" close=")" separator=",">
            #{item}
        </foreach>
    </select>

    <insert id="insertTotal" parameterType="com.zr.inquiry.pojo.InquiryTotal" useGeneratedKeys="true" keyColumn="id" keyProperty="id" >
        INSERT  into inquirytotal (requestForQuotationId,createTime,startTime,endTime,creatorName,type,currencyCode,isTax,inquiryStalegalPersonCodeonId)
        VALUES (#{requestForQuotationId},#{createTime},#{startTime},#{endTime},#{creatorName},#{type},#{currencyCode},#{isTax},#{inquiryStatuslegalPersonCodeonId})
    </insert>

    <insert id="insertSpareDetail">
        INSERT INTO inquirysparedetail(
        spareCoding,
        spareName,
        materialUnit,
        inquiryQty,
        currencyCode,
        moq,
        deliveryCycle,
        inquiryId)
        VALUES
        <foreach collection="list" item="item" index="index" open="" close="" separator=",">
            (
            #{item.spareCoding},
            #{item.spareName},
            #{item.materialUnit},
            #{item.inquiryQty},
            #{item.currencyCode},
            #{item.moq},
            #{item.deliveryCycle},
            #{item.inquiryId})
        </foreach>
    </insert>

    <insert id="insertSupplierDetail">
        INSERT INTO inquirysupplierdetail(
        vendor,
        vendorCode,
        inquiryId)
        VALUES
        <foreach collection="list" item="item" index="index" open="" close="" separator=",">
            (
            #{item.vendor},
            #{item.vendorCode},
            #{item.inquiryId})
        </foreach>
    </insert>


</mapper>

mapper

package com.zr.planClass.mapper;

import com.zr.planClass.model.PlanClassSelectVo;
import com.zr.planClass.model.PlanClassVo;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Component;

import java.util.List;


@Component
@Mapper
public interface PlanClassMapper {
    @Select("select count(id) from planclass where name = #{name}")
    int queryByName( String name);
    @Select("select * from planclass where name = #{name}")
    List<PlanClassVo> queryByName2( String name);
    @Select("select count(id) from planclass where code = #{code}")
    int queryByCode( String code);

    @Insert("insert into planclass (name,code,remark,status) values (#{name},#{code},#{remark},#{status})")
    void  addPlanClass(PlanClassVo planClassVo);

    @Select("select * from planclass where id=#{id}")
    PlanClassVo queryById(Integer id);

    @Update("update planclass set name=#{name},status=#{status},updateName=#{updateName},version=#{version}+1 where id=#{id} and version=#{version}")
    int updatePlanClass(PlanClassVo planClassVo);

    @Update("update planclass set status=#{status},updateName=#{updateName} where id=#{id}")
    void updatePlanClassStatus(PlanClassVo planClassVo);

    List<PlanClassVo> queryPageData(PlanClassSelectVo planClassSelectVo);

    int queryPageCount(PlanClassSelectVo planClassSelectVo);

    List<PlanClassVo> queryExport(PlanClassSelectVo planClassSelectVo);
}

serviceImp

package com.zr.inquiry.service.impl;

import com.zr.enumvo.CurrencyCodeEnum;
import com.zr.enumvo.IsTaxEnum;
import com.zr.enumvo.TypeEnum;
import com.zr.inquiry.mapper.InquiryMapper;
import com.zr.inquiry.model.*;
import com.zr.inquiry.service.InquiryService;
import com.zr.util.ResultBuilderVo;
import com.zr.util.ResultVo;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.*;


@Service
public class InquiryServiceImpl implements InquiryService {
    @Autowired
    private InquiryMapper inquiryMapper;



    @Override
    public ResultVo addInquiry(InquirytotalAddVo inquirytotalAddVo) {
        //业务验证
        ResultVo check = check(inquirytotalAddVo);
        if (!check.getSuccess()){
            return check;
        }
        Inquirytotal inquirytotal = new Inquirytotal();
        BeanUtils.copyProperties(inquirytotalAddVo,inquirytotal);
        //1.入库主表
        inquiryMapper.insertyInquiryTotal(inquirytotal);
        //2.入库备件明细表
//        for ()
        //3.入库供应商明细表
        return null;
    }

    public ResultVo check(InquirytotalAddVo inquirytotalAddVo){
//        10.验证询价类型、询价币别、是否含税、询价开始日期是否在结束日期之前
        ResultVo resultVo = checkEnum(inquirytotalAddVo);
        if (!resultVo.getSuccess()){
            return resultVo;
        }
//        5.验证备件明细不能重复
//        6.验证供应商明细不能重复
        ResultVo resultVo1 = checkRepeat(inquirytotalAddVo);
        if (!resultVo1.getSuccess()){
            return resultVo1;
        }
//        7.验证备件是否都存在
//        8.验证供应商是否都存在
//        9.验证法人是否存在

        ResultVo resultVo2 = checkCunzai(inquirytotalAddVo);
        if (!resultVo2.getSuccess()){
            return resultVo2;
        }
//        1.验证每个备件必须要有可以生产他的供应商
//        1.根据多个备件查询备件供应商中间表，查询这些备件都被那些供应商生产
//        2.验证每个供应商一定有一个它可以生产的备件
        ResultVo resultVo3 = checkHeFa(inquirytotalAddVo);
        if (!resultVo3.getSuccess()){
            return resultVo3;
        }

//
        return ResultBuilderVo.success();

    }

    public ResultVo checkHeFa(InquirytotalAddVo inquirytotalAddVo){
        List<String> codeList = new ArrayList<>();
        for (Inquirysparedetail inquirysparedetail: inquirytotalAddVo.getInquirysparedetailList()){
            codeList.add(inquirysparedetail.getSpareCoding());
        }
        List<String> SuppliserCodeList = new ArrayList<>();
        for (Inquirysupplierdetail inquirysupplierdetail: inquirytotalAddVo.getInquirysupplierdetailList()){
            SuppliserCodeList.add(inquirysupplierdetail.getVendorCode());
        }
        //全部的中间表信息
        List<SpareSupplierVo> spareSupplierVoList = inquiryMapper.querySpareSupplierBySpareCodeList(codeList);
        //把每个备件能被生产的供应商找出来放到集合中。
        for (String code:codeList){
            //每个备件的供应商集合
            List<String> SuppliserCodeList2 = new ArrayList<>();
            for (SpareSupplierVo spareSupplierVo:spareSupplierVoList){
                if (code.equals(spareSupplierVo.getSpareCoding())){
                    SuppliserCodeList2.add(spareSupplierVo.getVendorCode());
                }
            }
            //disjoint判断是否存在交集，true代表没有交集，false代表存在交集。
            if (Collections.disjoint(SuppliserCodeList2,SuppliserCodeList)){
                return ResultBuilderVo.error("备件编码："+code+"没有合法的供应商，它的合法供应商为："+SuppliserCodeList2);
            }
        }
        return ResultBuilderVo.success();
    }
    public ResultVo checkCunzai(InquirytotalAddVo inquirytotalAddVo){
        List<String> codeList = new ArrayList<>();
        for (Inquirysparedetail inquirysparedetail: inquirytotalAddVo.getInquirysparedetailList()){
            codeList.add(inquirysparedetail.getSpareCoding());
        }
        List<String> inquirysparedetailList =  inquiryMapper.queryByCodeList(codeList);
        if (inquirysparedetailList.size()!=codeList.size()){
            codeList.removeAll(inquirysparedetailList);
            return ResultBuilderVo.error("存在不合法的备件,不合法的备件为："+codeList);
        }
        return ResultBuilderVo.success();
    }
    public ResultVo checkRepeat(InquirytotalAddVo inquirytotalAddVo){
        List<String> spareNameList = new ArrayList<>();
        List<Inquirysparedetail> inquirysparedetailList = inquirytotalAddVo.getInquirysparedetailList();
        for (Inquirysparedetail inquirysparedetail:inquirysparedetailList){
            spareNameList.add(inquirysparedetail.getSpareCoding());
        }
     /*   Set<String> setSpareName = new HashSet<>(spareNameList);
        if (spareNameList.size()!=setSpareName.size()){
            return ResultBuilderVo.error("存在重复的备件编码");
        }*/
        List<String> newSpareNameList = new ArrayList<>();
        List<String> repeatSpareNameList = new ArrayList<>();
        for (String code:spareNameList){
            if (newSpareNameList.contains(code)){
                repeatSpareNameList.add(code);
            }
            newSpareNameList.add(code);
        }
        if (repeatSpareNameList.size()>0){
            return ResultBuilderVo.error("存在重复的备件编码,重复的备件编码为："+repeatSpareNameList);
        }
        return ResultBuilderVo.success();
    }

    public ResultVo checkEnum(InquirytotalAddVo inquirytotalAddVo){
        if (TypeEnum.getName(inquirytotalAddVo.getType())==null){
            return ResultBuilderVo.error("询价类型不存在！");
        }
        if (CurrencyCodeEnum.getName(inquirytotalAddVo.getCurrencyCode())==null){
            return ResultBuilderVo.error("询价币别不存在！");
        }
        if (IsTaxEnum.getName(inquirytotalAddVo.getIsTax())==null){
            return ResultBuilderVo.error("是否含税不存在！");
        }
        int res= inquirytotalAddVo.getStartTime().compareTo(inquirytotalAddVo.getEndTime());
        if(res>0){
            return ResultBuilderVo.error("询价开始日期必须在询价结束日期之前");
        }
        return ResultBuilderVo.success();
    }
}
高润森
关注
专栏目录
SQL语法（MYSQL）
weixin_41249041的博客
12-08 656
按条件统计 SELECT user_id , SUM( IF( order_info.status = 'dead', 1, 0) ) FROM order_info GROUP BY user_id; group_concat( user_id )拼接id select group_concat( user_id ) as userIds from user_distributi...
select concat('a','b') from dual; select 'a'||'b' from dual;
只作为个人备忘录
03-22 2188
select concat('a','b') from dual; select 'a'||'b' from dual;
新媒体概念
高润森的博客
01-15 5758
新媒体概念 新媒体（new media）概念是1967年由美国哥伦比亚广播电视网（CBS）技术研究所所长戈尔德马克（P.Goldmark）率先提出的。 到底什么是新媒体？ 所有人对所有人的传播 　　 　　　　　　　　 　 　　　　　　　　—美国《连线》杂志 以数字技术为基础，以网络为载体进行信息传播的媒介 　　　　　　　　 — 联合国教课文组织 新媒体是一个宽泛的概念，利用数...
不负此生
高润森的博客
01-13 675
人要怎么度过这一生？ 有的人二十岁已经死了； 有的人七十岁还在发现生命的可能； 有的人终其一生，不知道自己想要的是什么； 有人为一件事着迷，简单执拗，一直到老； 忠于自我未必有结果。 坚持努力也不一定换来成功。 但有天，回望过往。 是心怀壮阔，还是满怀懊悔，取决于我们的每一个当下。 愿你能，不负此生！ ...
2020-11-20 英语笔记
masterbeliever的博客
11-20 86
2020-11-20 英语打卡 今天做了一套很难的题 感觉全篇下来都很头痛 单词整理
2020-11-30 学习笔记
weixin_42122380的博客
11-30 84
2020-11-30 学习笔记 test hello world
2020-1-11课堂笔记1
08-08
在今天的课堂笔记中，我们主要探讨了AJAX技术和JSONP跨域，同时也涉及到了Bootstrap和Node平台的基础知识。以下是这些主题的详细说明： **AJAX技术** AJAX（Asynchronous JavaScript and XML）是一种前端技术，它...
Vue笔记（2020-8-11）个人总结，仅供参考，免费提供
08-11
本文基于Vue自学笔记，结合相关视频资源，将涵盖Vue的核心概念、组件化开发、状态管理以及构建工具Webpack等方面的知识。 1. **Vue核心概念** - `v-model`：Vue的数据绑定机制，用于双向数据绑定，让视图与模型...
2020-SLAM-Summer-School-slides.zip
09-17
这个2020-SLAM-Summer-School-slides.zip压缩包文件包含的是第三届SLAM暑期学校的一系列课程材料，旨在帮助学习者深入理解SLAM的基本原理、算法及其在实际应用中的挑战。以下将对SLAM及相关知识点进行详细阐述。 1....
linux学习笔记2020-11-10
djxhc的博客
11-10 279
day01 一、查看内核命令 - #uname -a 显示如下内容 Linux localhost.localdomain 4.18.0-193.28.1.el8_2.x86_64 #1 SMP Thu Oct 22 00:20:22 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux 查看用户登录命令: tty3 虚拟文本终端3 who w who am i ...
mysql中关于SELECT *,concat(ItemName,ProductID) as ItemName FROM `t_product`的语句最后的ItemName的值的问题解释
gayayzy的专栏
03-06 2266
很多时候都会碰到合并两个字段来作为一个字段的值的情况，如果我们想既要返回所有字段的值，又要让合并后的字段的值被引用到（显示或者其他操作），即是说让合并后的这个字段去代替原来的一个字段，那么怎么做呢？ SELECT *,concat(ItemName,ProductID) as ItemName FROM `t_product`这句话就可以做到的。 但是要注意：合并后的重命名的名称必须是和你要覆
Linux ContOS 6.8上搭建JAVA运行环境(JDK+MySql+Tomcat)
沐
09-22 160
** Linux ContOS 6.8上搭建JAVA运行环境(JDK+MySql+Tomcat) 安装JDK 1）查看当前Linux系统是否已经安装java # rpm -qa | grep java 2）输入以上指令检查是否安装,有没有不必管，有就用以下命令卸载掉 # rpm -e --nodeps 要卸载的软件 3）下载jdk-8u181-linux-x64.tar.gz到Linux上 ...
2019-04-28 21:43:41.098 ERROR 2920 --- [nio-8888-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] :
热门推荐
m0_43582028的博客
04-28 2万+
这个错误看着让人很害怕，其实解决方案很简单 我虽然解决了但是我并不明白原理如果有大佬了解帮忙解释一下谢谢 2019-04-28 21:43:41.098 ERROR 2920 --- [nio-8888-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServle...
继承的概念及理解
高润森的博客
03-10 4026
继承就是对共性的属性与方法的接受，并加入个性特有的属性与方法 概念 一个类继承另一个类，则称继承的类为子类，被继承的类为父类。 目的 实现代码的复用。 理解 子类与父类的关系并不是日常生活中的父子关系，java语言种子类与父类而是一种特殊化与一般化的关系，是is-a的关系，子类是父类更加详细的分类。如class dog extends animal,就可以理解为dog is a ani...
数据库day_02
高润森的博客
10-28 315
1.删除年龄在25到30之间的学生 delete from student where age between 25 and 30; delete from student where age >=25 and age <= 30; 2.查看所有的数据库 show databases; 3.建表：id,name,price,type; create table goods( g...
数据库day_01
高润森的博客
10-25 243
数据库 1.了解数据库: 什么是数据库? 存储数据的仓库. 2.常见的关系型数据库有哪些? 关系型数据库:已二维表格的形式存储数据. mysql:被oracle收购,免费的,中小型公司使用. oracle:Oracle公司,"甲骨文"-->神谕,收费. DB2:IBM公司. SQL server:微软. sqlite:小型数据库,适用于移动端:手机. 3.DBMS 数据库管理系统==关...
大数据伪分布式搭建
高润森的博客
01-08 213
hadoop安装配置 在 /opt/ 目录下创建 software 与 module 空文件夹 cd /opt/ mkdir software module 下载或上传 Hadoop 安装包到此目录下 wget http://mirrors.hust.edu.cn/apache/hadoop/common/hadoop-2.7.7/hadoop-2.7.7.tar.gz 解压 Hadoop 安装...
ieee std 802.11-2020下载
最新发布
06-20
IEEE std 802.11-2020是Wi-Fi标准的最新版本。它规定了无线局域网的操作，提供了对外部网络和互联网的接入。如果需要下载该标准，可以前往IEEE官方网站，在搜索框中输入“802.11-2020”，选择相应的选项，然后选择...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值