Merge branch 'master' of http://10.153.19.25:10101/r/ERP_override
# Conflicts:
# north-glass-erp/.idea/dataSources.local.xml
# north-glass-erp/.idea/dataSources/165c5447-d19a-4aaf-af5f-cee92ae696c2.xml
# north-glass-erp/.idea/workspace.xml
# north-glass-erp/src/main/resources/mapper/sd/Product.xml
| | |
| | | @TableId(type = IdType.AUTO) |
| | | |
| | | private Long id; |
| | | private Integer deliveryState; |
| | | private Integer stockState; |
| | | private String deliveryId; |
| | | private String project; |
| | | private String customerName; |
| | | private LocalDate deliveryDate; |
| | | private String payMethod; |
| | | private LocalDate payDate; |
| | | private String salaManId; |
| | | private String salaMan; |
| | | private String createrId; |
| | | private String creator; |
| | | private String contacts; |
| | | private String contactNumber; |
| | | private String deliveryAddress; |
| | | private String orderId; |
| | | private Integer orderNumber; |
| | | private Integer inventory ; |
| | | private Double actualSignalArea; |
| | | private Double area; |
| | | private Integer quantity; |
| | | private Double money; |
| | | private String remarks; |
| | | private LocalDate createTime; |
| | | private Integer quantityAvailable; |
| | | private String warehouseNumber; |
| | | private LocalDate storageRegion; |
| | | private Integer status; |
| | | private LocalDate enterStorageTime; |
| | | private String remark; |
| | | private LocalDate updateTime; |
| | | private Order order; |
| | | private Customer customer; |
| | | private LocalDate endTime; |
| | | |
| | | } |
New file |
| | |
| | | package com.example.erp.entity.mm; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import lombok.Data; |
| | | |
| | | import java.time.LocalDate; |
| | | |
| | | @Data |
| | | public class FinishedOperateLog { |
| | | @TableId(type = IdType.AUTO) |
| | | |
| | | private Long id; |
| | | private String operationOrderNumber; |
| | | private Long productNumber; |
| | | private Integer operationNumber ; |
| | | private String operateType; |
| | | private String operator; |
| | | private LocalDate operateTime; |
| | | |
| | | |
| | | } |
New file |
| | |
| | | package com.example.erp.mapper.mm; |
| | | |
| | | import com.example.erp.entity.mm.FinishedGoodsInventory; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import java.util.List; |
| | | |
| | | @Mapper |
| | | public interface FinishedGoodsInventoryMapper { |
| | | List<FinishedGoodsInventory> defaultProduct(@Param("offset") Integer offset, @Param("pageSize") Integer pageSize); |
| | | } |
New file |
| | |
| | | package com.example.erp.mapper.mm; |
| | | |
| | | import com.example.erp.entity.mm.FinishedOperateLog; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import java.util.List; |
| | | |
| | | @Mapper |
| | | public interface FinishedOperateLogMapper { |
| | | List<FinishedOperateLog> defaultProduct(@Param("offset") Integer offset, @Param("pageSize") Integer pageSize); |
| | | } |
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="com.example.erp.mapper.sd.ProductMapper"> |
| | | <select id="defaultProduct"> |
| | | select |
| | | a.id, |
| | | prodID, |
| | | product, |
| | | glassType, |
| | | typeName, |
| | | totalThickness, |
| | | thickness, |
| | | Query, |
| | | remarks, |
| | | state, |
| | | creator, |
| | | date(a.createTime) as 'createTime', |
| | | updateTime |
| | | from |
| | | product as a |
| | | left join basic_glass_type bgt on bgt.typeID = a.glassType |
| | | |
| | | order by id desc |
| | | limit #{offset},#{pageSize} |
| | | ; |
| | | </select> |
| | | </mapper> |
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="com.example.erp.mapper.sd.ProductMapper"> |
| | | <select id="defaultProduct"> |
| | | select |
| | | a.id, |
| | | prodID, |
| | | product, |
| | | glassType, |
| | | typeName, |
| | | totalThickness, |
| | | thickness, |
| | | Query, |
| | | remarks, |
| | | state, |
| | | creator, |
| | | date(a.createTime) as 'createTime', |
| | | updateTime |
| | | from |
| | | product as a |
| | | left join basic_glass_type bgt on bgt.typeID = a.glassType |
| | | |
| | | order by id desc |
| | | limit #{offset},#{pageSize} |
| | | ; |
| | | </select> |
| | | </mapper> |
| | |
| | | <mapper namespace="com.example.erp.mapper.sd.ProductMapper"> |
| | | <resultMap id="productmap" type="com.example.erp.entity.sd.Product" > |
| | | <id column="id" property="id"/> |
| | | <<<<<<< HEAD |
| | | <result column="product_name" property="productName"/> |
| | | ======= |
| | | <result column="product" property="product"/> |
| | | >>>>>>> 2bf272a9d41a2b6c67910b23371af9537a9153a5 |
| | | <result column="total_thickness" property="totalThickness"/> |
| | | <result column="thickness" property="thickness"/> |
| | | <result column="query" property="query"/> |
| | |
| | | <result column="creator" property="creator"/> |
| | | <result column="create_time" property="createTime"/> |
| | | <result column="update_time" property="updateTime"/> |
| | | <<<<<<< HEAD |
| | | <association property="basicGlassType" javaType="com.example.erp.entity.sd.BasicGlassType"> |
| | | <result column="type_id" property="typeID"/> |
| | | ======= |
| | | <association property="glassType" javaType="com.example.erp.entity.sd.GlassType"> |
| | | <result column="type_id" property="typeId"/> |
| | | >>>>>>> 2bf272a9d41a2b6c67910b23371af9537a9153a5 |
| | | <result column="type_name" property="typeName"/> |
| | | </association> |
| | | <!--<result column="g_typeId" property="glassTypes.typeId"/> |
| | |
| | | </resultMap> |
| | | |
| | | <select id="defaultProduct" resultMap="productmap"> |
| | | <<<<<<< HEAD |
| | | select a.id as id, |
| | | a.product_name, |
| | | a.total_thickness, |
| | |
| | | and date(a.create_time) regexp #{product.createTime} |
| | | </if> |
| | | </where> |
| | | ======= |
| | | select a.id as id, |
| | | a.product, |
| | | a.total_thickness, |
| | | a.thickness, |
| | | a.query, |
| | | a.remarks, |
| | | a.state, |
| | | a.creator, |
| | | date(a.create_time) as create_time, |
| | | a.update_time as update_time, |
| | | bgt.type_id as type_id, |
| | | bgt.type as type |
| | | from product as a |
| | | left join glass_type bgt on bgt.type_id = a.type_id |
| | | >>>>>>> 2bf272a9d41a2b6c67910b23371af9537a9153a5 |
| | | |
| | | order by id desc |
| | | limit #{offset},#{pageSize} |