4 文件已复制
18 文件已重命名
8个文件已添加
12个文件已删除
1个文件已修改
New file |
| | |
| | | package com.dy.pmsGlobal.daoSta; |
| | | |
| | | import com.dy.pmsGlobal.pojoSta.StaAssemblyWorkHistory; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | | * @author User |
| | | * @description 针对表【sta_assembly_work_history(生产线生产任务认领表)】的数据库操作Mapper |
| | | * @createDate 2024-06-19 14:21:17 |
| | | * @Entity com.dy.pmsGlobal.pojoSta.StaAssemblyWorkHistory |
| | | */ |
| | | @Mapper |
| | | public interface StaAssemblyWorkHistoryMapper { |
| | | |
| | | int deleteByPrimaryKey(Long id); |
| | | |
| | | int insert(StaAssemblyWorkHistory record); |
| | | |
| | | int insertSelective(StaAssemblyWorkHistory record); |
| | | |
| | | StaAssemblyWorkHistory selectByPrimaryKey(Long id); |
| | | |
| | | int updateByPrimaryKeySelective(StaAssemblyWorkHistory record); |
| | | |
| | | int updateByPrimaryKey(StaAssemblyWorkHistory record); |
| | | |
| | | } |
New file |
| | |
| | | package com.dy.pmsGlobal.daoSta; |
| | | |
| | | import com.dy.pmsGlobal.pojoSta.StaAssemblyWorkLast; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | | * @author User |
| | | * @description 针对表【sta_assembly_work_last(生产线生产任务认领表)】的数据库操作Mapper |
| | | * @createDate 2024-06-19 14:21:17 |
| | | * @Entity com.dy.pmsGlobal.pojoSta.StaAssemblyWorkLast |
| | | */ |
| | | @Mapper |
| | | public interface StaAssemblyWorkLastMapper { |
| | | |
| | | int deleteByPrimaryKey(Long id); |
| | | |
| | | int insert(StaAssemblyWorkLast record); |
| | | |
| | | int insertSelective(StaAssemblyWorkLast record); |
| | | |
| | | StaAssemblyWorkLast selectByPrimaryKey(Long id); |
| | | |
| | | int updateByPrimaryKeySelective(StaAssemblyWorkLast record); |
| | | |
| | | int updateByPrimaryKey(StaAssemblyWorkLast record); |
| | | |
| | | } |
New file |
| | |
| | | package com.dy.pmsGlobal.daoSta; |
| | | |
| | | import com.dy.pmsGlobal.pojoSta.StaDevOpsTaskClaimInfo; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | | * @author User |
| | | * @description 针对表【sta_dev_ops_task_claim_info(安装运维任务认领表)】的数据库操作Mapper |
| | | * @createDate 2024-06-19 14:21:17 |
| | | * @Entity com.dy.pmsGlobal.pojoSta.StaDevOpsTaskClaimInfo |
| | | */ |
| | | @Mapper |
| | | public interface StaDevOpsTaskClaimInfoMapper { |
| | | |
| | | int deleteByPrimaryKey(Long id); |
| | | |
| | | int insert(StaDevOpsTaskClaimInfo record); |
| | | |
| | | int insertSelective(StaDevOpsTaskClaimInfo record); |
| | | |
| | | StaDevOpsTaskClaimInfo selectByPrimaryKey(Long id); |
| | | |
| | | int updateByPrimaryKeySelective(StaDevOpsTaskClaimInfo record); |
| | | |
| | | int updateByPrimaryKey(StaDevOpsTaskClaimInfo record); |
| | | |
| | | } |
New file |
| | |
| | | package com.dy.pmsGlobal.daoSta; |
| | | |
| | | import com.dy.pmsGlobal.pojoSta.StaDeviceLast; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | | * @author User |
| | | * @description 针对表【sta_device_last(设备最新状态表)】的数据库操作Mapper |
| | | * @createDate 2024-06-19 14:21:17 |
| | | * @Entity com.dy.pmsGlobal.pojoSta.StaDeviceLast |
| | | */ |
| | | @Mapper |
| | | public interface StaDeviceLastMapper { |
| | | |
| | | int deleteByPrimaryKey(Long id); |
| | | |
| | | int insert(StaDeviceLast record); |
| | | |
| | | int insertSelective(StaDeviceLast record); |
| | | |
| | | StaDeviceLast selectByPrimaryKey(Long id); |
| | | |
| | | int updateByPrimaryKeySelective(StaDeviceLast record); |
| | | |
| | | int updateByPrimaryKey(StaDeviceLast record); |
| | | |
| | | } |
New file |
| | |
| | | package com.dy.pmsGlobal.daoSta; |
| | | |
| | | import com.dy.pmsGlobal.pojoSta.StaDeviceLife; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | | * @author User |
| | | * @description 针对表【sta_device_life(设备生命周期表)】的数据库操作Mapper |
| | | * @createDate 2024-06-19 14:21:17 |
| | | * @Entity com.dy.pmsGlobal.pojoSta.StaDeviceLife |
| | | */ |
| | | @Mapper |
| | | public interface StaDeviceLifeMapper { |
| | | |
| | | int deleteByPrimaryKey(Long id); |
| | | |
| | | int insert(StaDeviceLife record); |
| | | |
| | | int insertSelective(StaDeviceLife record); |
| | | |
| | | StaDeviceLife selectByPrimaryKey(Long id); |
| | | |
| | | int updateByPrimaryKeySelective(StaDeviceLife record); |
| | | |
| | | int updateByPrimaryKey(StaDeviceLife record); |
| | | |
| | | } |
New file |
| | |
| | | package com.dy.pmsGlobal.daoSta; |
| | | |
| | | import com.dy.pmsGlobal.pojoSta.StaDeviceProductionLog; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | | * @author User |
| | | * @description 针对表【sta_device_production_log(设备生产日志表)】的数据库操作Mapper |
| | | * @createDate 2024-06-19 14:21:17 |
| | | * @Entity com.dy.pmsGlobal.pojoSta.StaDeviceProductionLog |
| | | */ |
| | | @Mapper |
| | | public interface StaDeviceProductionLogMapper { |
| | | |
| | | int deleteByPrimaryKey(Long id); |
| | | |
| | | int insert(StaDeviceProductionLog record); |
| | | |
| | | int insertSelective(StaDeviceProductionLog record); |
| | | |
| | | StaDeviceProductionLog selectByPrimaryKey(Long id); |
| | | |
| | | int updateByPrimaryKeySelective(StaDeviceProductionLog record); |
| | | |
| | | int updateByPrimaryKey(StaDeviceProductionLog record); |
| | | |
| | | } |
New file |
| | |
| | | package com.dy.pmsGlobal.daoSta; |
| | | |
| | | import com.dy.pmsGlobal.pojoSta.StaRepairInfo; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | | * @author User |
| | | * @description 针对表【sta_repair_info】的数据库操作Mapper |
| | | * @createDate 2024-06-19 14:21:17 |
| | | * @Entity com.dy.pmsGlobal.pojoSta.StaRepairInfo |
| | | */ |
| | | @Mapper |
| | | public interface StaRepairInfoMapper { |
| | | |
| | | int deleteByPrimaryKey(Long id); |
| | | |
| | | int insert(StaRepairInfo record); |
| | | |
| | | int insertSelective(StaRepairInfo record); |
| | | |
| | | StaRepairInfo selectByPrimaryKey(Long id); |
| | | |
| | | int updateByPrimaryKeySelective(StaRepairInfo record); |
| | | |
| | | int updateByPrimaryKey(StaRepairInfo record); |
| | | |
| | | } |
New file |
| | |
| | | package com.dy.pmsGlobal.daoSta; |
| | | |
| | | import com.dy.pmsGlobal.pojoSta.StaWipSnEx; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | | * @author User |
| | | * @description 针对表【sta_wip_sn_ex(设备关联表)】的数据库操作Mapper |
| | | * @createDate 2024-06-19 14:21:17 |
| | | * @Entity com.dy.pmsGlobal.pojoSta.StaWipSnEx |
| | | */ |
| | | @Mapper |
| | | public interface StaWipSnExMapper { |
| | | |
| | | int deleteByPrimaryKey(Long id); |
| | | |
| | | int insert(StaWipSnEx record); |
| | | |
| | | int insertSelective(StaWipSnEx record); |
| | | |
| | | StaWipSnEx selectByPrimaryKey(Long id); |
| | | |
| | | int updateByPrimaryKeySelective(StaWipSnEx record); |
| | | |
| | | int updateByPrimaryKey(StaWipSnEx record); |
| | | |
| | | } |
File was renamed from pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoWo/WoAssemblyWorkLast.java |
| | |
| | | package com.dy.pmsGlobal.pojoWo; |
| | | package com.dy.pmsGlobal.pojoSta; |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | |
| | | |
| | | /** |
| | | * 生产线生产任务认领表 |
| | | * @TableName wo_assembly_work_last |
| | | * @TableName sta_assembly_work_history |
| | | */ |
| | | @Data |
| | | public class WoAssemblyWorkLast implements Serializable { |
| | | public class StaAssemblyWorkHistory implements Serializable { |
| | | /** |
| | | * |
| | | */ |
| | |
| | | if (getClass() != that.getClass()) { |
| | | return false; |
| | | } |
| | | WoAssemblyWorkLast other = (WoAssemblyWorkLast) that; |
| | | StaAssemblyWorkHistory other = (StaAssemblyWorkHistory) that; |
| | | return (this.getId() == null ? other.getId() == null : this.getId().equals(other.getId())) |
| | | && (this.getUserId() == null ? other.getUserId() == null : this.getUserId().equals(other.getUserId())) |
| | | && (this.getLineId() == null ? other.getLineId() == null : this.getLineId().equals(other.getLineId())) |
copy from pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoWo/WoAssemblyWorkLast.java
copy to pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoSta/StaAssemblyWorkLast.java
File was copied from pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoWo/WoAssemblyWorkLast.java |
| | |
| | | package com.dy.pmsGlobal.pojoWo; |
| | | package com.dy.pmsGlobal.pojoSta; |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | |
| | | |
| | | /** |
| | | * 生产线生产任务认领表 |
| | | * @TableName wo_assembly_work_last |
| | | * @TableName sta_assembly_work_last |
| | | */ |
| | | @Data |
| | | public class WoAssemblyWorkLast implements Serializable { |
| | | public class StaAssemblyWorkLast implements Serializable { |
| | | /** |
| | | * |
| | | */ |
| | |
| | | if (getClass() != that.getClass()) { |
| | | return false; |
| | | } |
| | | WoAssemblyWorkLast other = (WoAssemblyWorkLast) that; |
| | | StaAssemblyWorkLast other = (StaAssemblyWorkLast) that; |
| | | return (this.getId() == null ? other.getId() == null : this.getId().equals(other.getId())) |
| | | && (this.getUserId() == null ? other.getUserId() == null : this.getUserId().equals(other.getUserId())) |
| | | && (this.getLineId() == null ? other.getLineId() == null : this.getLineId().equals(other.getLineId())) |
File was renamed from pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoWo/WoDevOpsTaskClaimInfo.java |
| | |
| | | package com.dy.pmsGlobal.pojoWo; |
| | | package com.dy.pmsGlobal.pojoSta; |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | |
| | | |
| | | /** |
| | | * 安装运维任务认领表 |
| | | * @TableName wo_dev_ops_task_claim_info |
| | | * @TableName sta_dev_ops_task_claim_info |
| | | */ |
| | | @Data |
| | | public class WoDevOpsTaskClaimInfo implements Serializable { |
| | | public class StaDevOpsTaskClaimInfo implements Serializable { |
| | | /** |
| | | * |
| | | */ |
| | |
| | | if (getClass() != that.getClass()) { |
| | | return false; |
| | | } |
| | | WoDevOpsTaskClaimInfo other = (WoDevOpsTaskClaimInfo) that; |
| | | StaDevOpsTaskClaimInfo other = (StaDevOpsTaskClaimInfo) that; |
| | | return (this.getId() == null ? other.getId() == null : this.getId().equals(other.getId())) |
| | | && (this.getUserId() == null ? other.getUserId() == null : this.getUserId().equals(other.getUserId())) |
| | | && (this.getPlanId() == null ? other.getPlanId() == null : this.getPlanId().equals(other.getPlanId())) |
File was renamed from pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoWo/WoDeviceLast.java |
| | |
| | | package com.dy.pmsGlobal.pojoWo; |
| | | package com.dy.pmsGlobal.pojoSta; |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | |
| | | |
| | | /** |
| | | * 设备最新状态表 |
| | | * @TableName wo_device_last |
| | | * @TableName sta_device_last |
| | | */ |
| | | @Data |
| | | public class WoDeviceLast implements Serializable { |
| | | public class StaDeviceLast implements Serializable { |
| | | /** |
| | | * |
| | | */ |
| | |
| | | if (getClass() != that.getClass()) { |
| | | return false; |
| | | } |
| | | WoDeviceLast other = (WoDeviceLast) that; |
| | | StaDeviceLast other = (StaDeviceLast) that; |
| | | return (this.getId() == null ? other.getId() == null : this.getId().equals(other.getId())) |
| | | && (this.getEquipNo() == null ? other.getEquipNo() == null : this.getEquipNo().equals(other.getEquipNo())) |
| | | && (this.getPlanId() == null ? other.getPlanId() == null : this.getPlanId().equals(other.getPlanId())) |
copy from pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoWo/WoDeviceProductionLog.java
copy to pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoSta/StaDeviceLife.java
File was copied from pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoWo/WoDeviceProductionLog.java |
| | |
| | | package com.dy.pmsGlobal.pojoWo; |
| | | package com.dy.pmsGlobal.pojoSta; |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | import lombok.Data; |
| | | |
| | | /** |
| | | * 设备生产日志表 |
| | | * @TableName wo_device_production_log |
| | | * 设备生命周期表 |
| | | * @TableName sta_device_life |
| | | */ |
| | | @Data |
| | | public class WoDeviceProductionLog implements Serializable { |
| | | public class StaDeviceLife implements Serializable { |
| | | /** |
| | | * |
| | | */ |
| | |
| | | private String currNode; |
| | | |
| | | /** |
| | | * |
| | | * 下一节点 |
| | | */ |
| | | private String nextNode; |
| | | |
| | |
| | | private Integer result; |
| | | |
| | | /** |
| | | * |
| | | * 维修节点返回的错误码 |
| | | */ |
| | | private String errorCode; |
| | | |
| | |
| | | if (getClass() != that.getClass()) { |
| | | return false; |
| | | } |
| | | WoDeviceProductionLog other = (WoDeviceProductionLog) that; |
| | | StaDeviceLife other = (StaDeviceLife) that; |
| | | return (this.getId() == null ? other.getId() == null : this.getId().equals(other.getId())) |
| | | && (this.getEquipNo() == null ? other.getEquipNo() == null : this.getEquipNo().equals(other.getEquipNo())) |
| | | && (this.getPlanId() == null ? other.getPlanId() == null : this.getPlanId().equals(other.getPlanId())) |
File was renamed from pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoWo/WoDeviceProductionLog.java |
| | |
| | | package com.dy.pmsGlobal.pojoWo; |
| | | package com.dy.pmsGlobal.pojoSta; |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | |
| | | |
| | | /** |
| | | * 设备生产日志表 |
| | | * @TableName wo_device_production_log |
| | | * @TableName sta_device_production_log |
| | | */ |
| | | @Data |
| | | public class WoDeviceProductionLog implements Serializable { |
| | | public class StaDeviceProductionLog implements Serializable { |
| | | /** |
| | | * |
| | | */ |
| | |
| | | if (getClass() != that.getClass()) { |
| | | return false; |
| | | } |
| | | WoDeviceProductionLog other = (WoDeviceProductionLog) that; |
| | | StaDeviceProductionLog other = (StaDeviceProductionLog) that; |
| | | return (this.getId() == null ? other.getId() == null : this.getId().equals(other.getId())) |
| | | && (this.getEquipNo() == null ? other.getEquipNo() == null : this.getEquipNo().equals(other.getEquipNo())) |
| | | && (this.getPlanId() == null ? other.getPlanId() == null : this.getPlanId().equals(other.getPlanId())) |
File was renamed from pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoWo/WoRepairInfo.java |
| | |
| | | package com.dy.pmsGlobal.pojoWo; |
| | | package com.dy.pmsGlobal.pojoSta; |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | |
| | | |
| | | /** |
| | | * |
| | | * @TableName wo_repair_info |
| | | * @TableName sta_repair_info |
| | | */ |
| | | @Data |
| | | public class WoRepairInfo implements Serializable { |
| | | public class StaRepairInfo implements Serializable { |
| | | /** |
| | | * |
| | | */ |
| | |
| | | if (getClass() != that.getClass()) { |
| | | return false; |
| | | } |
| | | WoRepairInfo other = (WoRepairInfo) that; |
| | | StaRepairInfo other = (StaRepairInfo) that; |
| | | return (this.getId() == null ? other.getId() == null : this.getId().equals(other.getId())) |
| | | && (this.getEquipNo() == null ? other.getEquipNo() == null : this.getEquipNo().equals(other.getEquipNo())) |
| | | && (this.getFromNode() == null ? other.getFromNode() == null : this.getFromNode().equals(other.getFromNode())) |
File was renamed from pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoWo/WoWipSnEx.java |
| | |
| | | package com.dy.pmsGlobal.pojoWo; |
| | | package com.dy.pmsGlobal.pojoSta; |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | |
| | | |
| | | /** |
| | | * 设备关联表 |
| | | * @TableName wo_wip_sn_ex |
| | | * @TableName sta_wip_sn_ex |
| | | */ |
| | | @Data |
| | | public class WoWipSnEx implements Serializable { |
| | | public class StaWipSnEx implements Serializable { |
| | | /** |
| | | * |
| | | */ |
| | |
| | | if (getClass() != that.getClass()) { |
| | | return false; |
| | | } |
| | | WoWipSnEx other = (WoWipSnEx) that; |
| | | StaWipSnEx other = (StaWipSnEx) that; |
| | | return (this.getId() == null ? other.getId() == null : this.getId().equals(other.getId())) |
| | | && (this.getDeviceNo() == null ? other.getDeviceNo() == null : this.getDeviceNo().equals(other.getDeviceNo())) |
| | | && (this.getProductId() == null ? other.getProductId() == null : this.getProductId().equals(other.getProductId())) |
| | |
| | | other: |
| | | webPort: 12348 |
| | | idSuffix: 5 |
| | | work: |
| | | station: |
| | | webPort: 12349 |
| | | idSuffix: 6 |
| | | file: |
File was renamed from pms-parent/pms-global/src/main/resources/mapper/WoAssemblyWorkHistoryMapper.xml |
| | |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.dy.pmsGlobal.daoWo.WoAssemblyWorkHistoryMapper"> |
| | | <mapper namespace="com.dy.pmsGlobal.daoSta.StaAssemblyWorkHistoryMapper"> |
| | | |
| | | <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoWo.WoAssemblyWorkHistory"> |
| | | <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkHistory"> |
| | | <id property="id" column="id" jdbcType="BIGINT"/> |
| | | <result property="userId" column="user_id" jdbcType="BIGINT"/> |
| | | <result property="lineId" column="line_id" jdbcType="BIGINT"/> |
| | |
| | | <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap"> |
| | | select |
| | | <include refid="Base_Column_List" /> |
| | | from wo_assembly_work_history |
| | | from sta_assembly_work_history |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </select> |
| | | |
| | | <delete id="deleteByPrimaryKey" parameterType="java.lang.Long"> |
| | | delete from wo_assembly_work_history |
| | | delete from sta_assembly_work_history |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </delete> |
| | | <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoWo.WoAssemblyWorkHistory" useGeneratedKeys="true"> |
| | | insert into wo_assembly_work_history |
| | | <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkHistory" useGeneratedKeys="true"> |
| | | insert into sta_assembly_work_history |
| | | ( id,user_id,line_id |
| | | ,station_id,plan_id,process_id |
| | | ,node_id,dt,status |
| | |
| | | ,#{startTime,jdbcType=TIMESTAMP},#{endTime,jdbcType=TIMESTAMP},#{assistants,jdbcType=VARCHAR} |
| | | ) |
| | | </insert> |
| | | <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoWo.WoAssemblyWorkHistory" useGeneratedKeys="true"> |
| | | insert into wo_assembly_work_history |
| | | <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkHistory" useGeneratedKeys="true"> |
| | | insert into sta_assembly_work_history |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">id,</if> |
| | | <if test="userId != null">user_id,</if> |
| | |
| | | <if test="assistants != null">#{assistants,jdbcType=VARCHAR},</if> |
| | | </trim> |
| | | </insert> |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoWo.WoAssemblyWorkHistory"> |
| | | update wo_assembly_work_history |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkHistory"> |
| | | update sta_assembly_work_history |
| | | <set> |
| | | <if test="userId != null"> |
| | | user_id = #{userId,jdbcType=BIGINT}, |
| | |
| | | </set> |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </update> |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoWo.WoAssemblyWorkHistory"> |
| | | update wo_assembly_work_history |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkHistory"> |
| | | update sta_assembly_work_history |
| | | set |
| | | user_id = #{userId,jdbcType=BIGINT}, |
| | | line_id = #{lineId,jdbcType=BIGINT}, |
copy from pms-parent/pms-global/src/main/resources/mapper/WoAssemblyWorkHistoryMapper.xml
copy to pms-parent/pms-global/src/main/resources/mapper/StaAssemblyWorkLastMapper.xml
File was copied from pms-parent/pms-global/src/main/resources/mapper/WoAssemblyWorkHistoryMapper.xml |
| | |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.dy.pmsGlobal.daoWo.WoAssemblyWorkHistoryMapper"> |
| | | <mapper namespace="com.dy.pmsGlobal.daoSta.StaAssemblyWorkLastMapper"> |
| | | |
| | | <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoWo.WoAssemblyWorkHistory"> |
| | | <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkLast"> |
| | | <id property="id" column="id" jdbcType="BIGINT"/> |
| | | <result property="userId" column="user_id" jdbcType="BIGINT"/> |
| | | <result property="lineId" column="line_id" jdbcType="BIGINT"/> |
| | |
| | | <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap"> |
| | | select |
| | | <include refid="Base_Column_List" /> |
| | | from wo_assembly_work_history |
| | | from sta_assembly_work_last |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </select> |
| | | |
| | | <delete id="deleteByPrimaryKey" parameterType="java.lang.Long"> |
| | | delete from wo_assembly_work_history |
| | | delete from sta_assembly_work_last |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </delete> |
| | | <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoWo.WoAssemblyWorkHistory" useGeneratedKeys="true"> |
| | | insert into wo_assembly_work_history |
| | | <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkLast" useGeneratedKeys="true"> |
| | | insert into sta_assembly_work_last |
| | | ( id,user_id,line_id |
| | | ,station_id,plan_id,process_id |
| | | ,node_id,dt,status |
| | |
| | | ,#{startTime,jdbcType=TIMESTAMP},#{endTime,jdbcType=TIMESTAMP},#{assistants,jdbcType=VARCHAR} |
| | | ) |
| | | </insert> |
| | | <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoWo.WoAssemblyWorkHistory" useGeneratedKeys="true"> |
| | | insert into wo_assembly_work_history |
| | | <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkLast" useGeneratedKeys="true"> |
| | | insert into sta_assembly_work_last |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">id,</if> |
| | | <if test="userId != null">user_id,</if> |
| | |
| | | <if test="assistants != null">#{assistants,jdbcType=VARCHAR},</if> |
| | | </trim> |
| | | </insert> |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoWo.WoAssemblyWorkHistory"> |
| | | update wo_assembly_work_history |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkLast"> |
| | | update sta_assembly_work_last |
| | | <set> |
| | | <if test="userId != null"> |
| | | user_id = #{userId,jdbcType=BIGINT}, |
| | |
| | | </set> |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </update> |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoWo.WoAssemblyWorkHistory"> |
| | | update wo_assembly_work_history |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkLast"> |
| | | update sta_assembly_work_last |
| | | set |
| | | user_id = #{userId,jdbcType=BIGINT}, |
| | | line_id = #{lineId,jdbcType=BIGINT}, |
File was renamed from pms-parent/pms-global/src/main/resources/mapper/WoDevOpsTaskClaimInfoMapper.xml |
| | |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.dy.pmsGlobal.daoWo.WoDevOpsTaskClaimInfoMapper"> |
| | | <mapper namespace="com.dy.pmsGlobal.daoSta.StaDevOpsTaskClaimInfoMapper"> |
| | | |
| | | <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoWo.WoDevOpsTaskClaimInfo"> |
| | | <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoSta.StaDevOpsTaskClaimInfo"> |
| | | <id property="id" column="id" jdbcType="BIGINT"/> |
| | | <result property="userId" column="user_id" jdbcType="BIGINT"/> |
| | | <result property="planId" column="plan_id" jdbcType="BIGINT"/> |
| | |
| | | <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap"> |
| | | select |
| | | <include refid="Base_Column_List" /> |
| | | from wo_dev_ops_task_claim_info |
| | | from sta_dev_ops_task_claim_info |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </select> |
| | | |
| | | <delete id="deleteByPrimaryKey" parameterType="java.lang.Long"> |
| | | delete from wo_dev_ops_task_claim_info |
| | | delete from sta_dev_ops_task_claim_info |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </delete> |
| | | <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoWo.WoDevOpsTaskClaimInfo" useGeneratedKeys="true"> |
| | | insert into wo_dev_ops_task_claim_info |
| | | <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDevOpsTaskClaimInfo" useGeneratedKeys="true"> |
| | | insert into sta_dev_ops_task_claim_info |
| | | ( id,user_id,plan_id |
| | | ,dt,status) |
| | | values (#{id,jdbcType=BIGINT},#{userId,jdbcType=BIGINT},#{planId,jdbcType=BIGINT} |
| | | ,#{dt,jdbcType=TIMESTAMP},#{status,jdbcType=TINYINT}) |
| | | </insert> |
| | | <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoWo.WoDevOpsTaskClaimInfo" useGeneratedKeys="true"> |
| | | insert into wo_dev_ops_task_claim_info |
| | | <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDevOpsTaskClaimInfo" useGeneratedKeys="true"> |
| | | insert into sta_dev_ops_task_claim_info |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">id,</if> |
| | | <if test="userId != null">user_id,</if> |
| | |
| | | <if test="status != null">#{status,jdbcType=TINYINT},</if> |
| | | </trim> |
| | | </insert> |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoWo.WoDevOpsTaskClaimInfo"> |
| | | update wo_dev_ops_task_claim_info |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoSta.StaDevOpsTaskClaimInfo"> |
| | | update sta_dev_ops_task_claim_info |
| | | <set> |
| | | <if test="userId != null"> |
| | | user_id = #{userId,jdbcType=BIGINT}, |
| | |
| | | </set> |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </update> |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoWo.WoDevOpsTaskClaimInfo"> |
| | | update wo_dev_ops_task_claim_info |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoSta.StaDevOpsTaskClaimInfo"> |
| | | update sta_dev_ops_task_claim_info |
| | | set |
| | | user_id = #{userId,jdbcType=BIGINT}, |
| | | plan_id = #{planId,jdbcType=BIGINT}, |
File was renamed from pms-parent/pms-global/src/main/resources/mapper/WoDeviceLastMapper.xml |
| | |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.dy.pmsGlobal.daoWo.WoDeviceLastMapper"> |
| | | <mapper namespace="com.dy.pmsGlobal.daoSta.StaDeviceLastMapper"> |
| | | |
| | | <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoWo.WoDeviceLast"> |
| | | <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoSta.StaDeviceLast"> |
| | | <id property="id" column="id" jdbcType="BIGINT"/> |
| | | <result property="equipNo" column="equip_no" jdbcType="VARCHAR"/> |
| | | <result property="planId" column="plan_id" jdbcType="VARCHAR"/> |
| | |
| | | <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap"> |
| | | select |
| | | <include refid="Base_Column_List" /> |
| | | from wo_device_last |
| | | from sta_device_last |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </select> |
| | | |
| | | <delete id="deleteByPrimaryKey" parameterType="java.lang.Long"> |
| | | delete from wo_device_last |
| | | delete from sta_device_last |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </delete> |
| | | <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoWo.WoDeviceLast" useGeneratedKeys="true"> |
| | | insert into wo_device_last |
| | | <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLast" useGeneratedKeys="true"> |
| | | insert into sta_device_last |
| | | ( id,equip_no,plan_id |
| | | ,station_id,curr_node,next_node |
| | | ,status,result,error_code |
| | |
| | | ,#{updatedDate,jdbcType=TIMESTAMP},#{updatedBy,jdbcType=VARCHAR},#{inStationTime,jdbcType=TIMESTAMP} |
| | | ) |
| | | </insert> |
| | | <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoWo.WoDeviceLast" useGeneratedKeys="true"> |
| | | insert into wo_device_last |
| | | <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLast" useGeneratedKeys="true"> |
| | | insert into sta_device_last |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">id,</if> |
| | | <if test="equipNo != null">equip_no,</if> |
| | |
| | | <if test="inStationTime != null">#{inStationTime,jdbcType=TIMESTAMP},</if> |
| | | </trim> |
| | | </insert> |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoWo.WoDeviceLast"> |
| | | update wo_device_last |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLast"> |
| | | update sta_device_last |
| | | <set> |
| | | <if test="equipNo != null"> |
| | | equip_no = #{equipNo,jdbcType=VARCHAR}, |
| | |
| | | </set> |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </update> |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoWo.WoDeviceLast"> |
| | | update wo_device_last |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLast"> |
| | | update sta_device_last |
| | | set |
| | | equip_no = #{equipNo,jdbcType=VARCHAR}, |
| | | plan_id = #{planId,jdbcType=VARCHAR}, |
File was renamed from pms-parent/pms-global/src/main/resources/mapper/WoDeviceProductionLogMapper.xml |
| | |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.dy.pmsGlobal.daoWo.WoDeviceProductionLogMapper"> |
| | | <mapper namespace="com.dy.pmsGlobal.daoSta.StaDeviceLifeMapper"> |
| | | |
| | | <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoWo.WoDeviceProductionLog"> |
| | | <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoSta.StaDeviceLife"> |
| | | <id property="id" column="id" jdbcType="BIGINT"/> |
| | | <result property="equipNo" column="equip_no" jdbcType="VARCHAR"/> |
| | | <result property="planId" column="plan_id" jdbcType="VARCHAR"/> |
| | |
| | | <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap"> |
| | | select |
| | | <include refid="Base_Column_List" /> |
| | | from wo_device_production_log |
| | | from sta_device_life |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </select> |
| | | |
| | | <delete id="deleteByPrimaryKey" parameterType="java.lang.Long"> |
| | | delete from wo_device_production_log |
| | | delete from sta_device_life |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </delete> |
| | | <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoWo.WoDeviceProductionLog" useGeneratedKeys="true"> |
| | | insert into wo_device_production_log |
| | | <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLife" useGeneratedKeys="true"> |
| | | insert into sta_device_life |
| | | ( id,equip_no,plan_id |
| | | ,station_id,curr_node,next_node |
| | | ,in_line_time,status,result |
| | |
| | | ,#{updatedDate,jdbcType=TIMESTAMP},#{updatedBy,jdbcType=VARCHAR},#{claimId,jdbcType=BIGINT} |
| | | ,#{repairId,jdbcType=BIGINT}) |
| | | </insert> |
| | | <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoWo.WoDeviceProductionLog" useGeneratedKeys="true"> |
| | | insert into wo_device_production_log |
| | | <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLife" useGeneratedKeys="true"> |
| | | insert into sta_device_life |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">id,</if> |
| | | <if test="equipNo != null">equip_no,</if> |
| | |
| | | <if test="repairId != null">#{repairId,jdbcType=BIGINT},</if> |
| | | </trim> |
| | | </insert> |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoWo.WoDeviceProductionLog"> |
| | | update wo_device_production_log |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLife"> |
| | | update sta_device_life |
| | | <set> |
| | | <if test="equipNo != null"> |
| | | equip_no = #{equipNo,jdbcType=VARCHAR}, |
| | |
| | | </set> |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </update> |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoWo.WoDeviceProductionLog"> |
| | | update wo_device_production_log |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLife"> |
| | | update sta_device_life |
| | | set |
| | | equip_no = #{equipNo,jdbcType=VARCHAR}, |
| | | plan_id = #{planId,jdbcType=VARCHAR}, |
copy from pms-parent/pms-global/src/main/resources/mapper/WoDeviceProductionLogMapper.xml
copy to pms-parent/pms-global/src/main/resources/mapper/StaDeviceProductionLogMapper.xml
File was copied from pms-parent/pms-global/src/main/resources/mapper/WoDeviceProductionLogMapper.xml |
| | |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.dy.pmsGlobal.daoWo.WoDeviceProductionLogMapper"> |
| | | <mapper namespace="com.dy.pmsGlobal.daoSta.StaDeviceProductionLogMapper"> |
| | | |
| | | <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoWo.WoDeviceProductionLog"> |
| | | <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoSta.StaDeviceProductionLog"> |
| | | <id property="id" column="id" jdbcType="BIGINT"/> |
| | | <result property="equipNo" column="equip_no" jdbcType="VARCHAR"/> |
| | | <result property="planId" column="plan_id" jdbcType="VARCHAR"/> |
| | |
| | | <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap"> |
| | | select |
| | | <include refid="Base_Column_List" /> |
| | | from wo_device_production_log |
| | | from sta_device_production_log |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </select> |
| | | |
| | | <delete id="deleteByPrimaryKey" parameterType="java.lang.Long"> |
| | | delete from wo_device_production_log |
| | | delete from sta_device_production_log |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </delete> |
| | | <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoWo.WoDeviceProductionLog" useGeneratedKeys="true"> |
| | | insert into wo_device_production_log |
| | | <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceProductionLog" useGeneratedKeys="true"> |
| | | insert into sta_device_production_log |
| | | ( id,equip_no,plan_id |
| | | ,station_id,curr_node,next_node |
| | | ,in_line_time,status,result |
| | |
| | | ,#{updatedDate,jdbcType=TIMESTAMP},#{updatedBy,jdbcType=VARCHAR},#{claimId,jdbcType=BIGINT} |
| | | ,#{repairId,jdbcType=BIGINT}) |
| | | </insert> |
| | | <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoWo.WoDeviceProductionLog" useGeneratedKeys="true"> |
| | | insert into wo_device_production_log |
| | | <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceProductionLog" useGeneratedKeys="true"> |
| | | insert into sta_device_production_log |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">id,</if> |
| | | <if test="equipNo != null">equip_no,</if> |
| | |
| | | <if test="repairId != null">#{repairId,jdbcType=BIGINT},</if> |
| | | </trim> |
| | | </insert> |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoWo.WoDeviceProductionLog"> |
| | | update wo_device_production_log |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceProductionLog"> |
| | | update sta_device_production_log |
| | | <set> |
| | | <if test="equipNo != null"> |
| | | equip_no = #{equipNo,jdbcType=VARCHAR}, |
| | |
| | | </set> |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </update> |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoWo.WoDeviceProductionLog"> |
| | | update wo_device_production_log |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceProductionLog"> |
| | | update sta_device_production_log |
| | | set |
| | | equip_no = #{equipNo,jdbcType=VARCHAR}, |
| | | plan_id = #{planId,jdbcType=VARCHAR}, |
File was renamed from pms-parent/pms-global/src/main/resources/mapper/WoRepairInfoMapper.xml |
| | |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.dy.pmsGlobal.daoWo.WoRepairInfoMapper"> |
| | | <mapper namespace="com.dy.pmsGlobal.daoSta.StaRepairInfoMapper"> |
| | | |
| | | <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoWo.WoRepairInfo"> |
| | | <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoSta.StaRepairInfo"> |
| | | <id property="id" column="id" jdbcType="BIGINT"/> |
| | | <result property="equipNo" column="equip_no" jdbcType="VARCHAR"/> |
| | | <result property="fromNode" column="from_node" jdbcType="VARCHAR"/> |
| | |
| | | <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap"> |
| | | select |
| | | <include refid="Base_Column_List" /> |
| | | from wo_repair_info |
| | | from sta_repair_info |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </select> |
| | | |
| | | <delete id="deleteByPrimaryKey" parameterType="java.lang.Long"> |
| | | delete from wo_repair_info |
| | | delete from sta_repair_info |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </delete> |
| | | <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoWo.WoRepairInfo" useGeneratedKeys="true"> |
| | | insert into wo_repair_info |
| | | <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaRepairInfo" useGeneratedKeys="true"> |
| | | insert into sta_repair_info |
| | | ( id,equip_no,from_node |
| | | ,repair_reason,to_node,repair_by |
| | | ,repair_time,create_time,create_by |
| | |
| | | ,#{repairTime,jdbcType=TIMESTAMP},#{createTime,jdbcType=TIMESTAMP},#{createBy,jdbcType=BIGINT} |
| | | ) |
| | | </insert> |
| | | <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoWo.WoRepairInfo" useGeneratedKeys="true"> |
| | | insert into wo_repair_info |
| | | <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaRepairInfo" useGeneratedKeys="true"> |
| | | insert into sta_repair_info |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">id,</if> |
| | | <if test="equipNo != null">equip_no,</if> |
| | |
| | | <if test="createBy != null">#{createBy,jdbcType=BIGINT},</if> |
| | | </trim> |
| | | </insert> |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoWo.WoRepairInfo"> |
| | | update wo_repair_info |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoSta.StaRepairInfo"> |
| | | update sta_repair_info |
| | | <set> |
| | | <if test="equipNo != null"> |
| | | equip_no = #{equipNo,jdbcType=VARCHAR}, |
| | |
| | | </set> |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </update> |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoWo.WoRepairInfo"> |
| | | update wo_repair_info |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoSta.StaRepairInfo"> |
| | | update sta_repair_info |
| | | set |
| | | equip_no = #{equipNo,jdbcType=VARCHAR}, |
| | | from_node = #{fromNode,jdbcType=VARCHAR}, |
File was renamed from pms-parent/pms-global/src/main/resources/mapper/WoWipSnExMapper.xml |
| | |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.dy.pmsGlobal.daoWo.WoWipSnExMapper"> |
| | | <mapper namespace="com.dy.pmsGlobal.daoSta.StaWipSnExMapper"> |
| | | |
| | | <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoWo.WoWipSnEx"> |
| | | <resultMap id="BaseResultMap" type="com.dy.pmsGlobal.pojoSta.StaWipSnEx"> |
| | | <id property="id" column="id" jdbcType="VARCHAR"/> |
| | | <result property="deviceNo" column="device_no" jdbcType="VARCHAR"/> |
| | | <result property="productId" column="product_id" jdbcType="INTEGER"/> |
| | |
| | | <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap"> |
| | | select |
| | | <include refid="Base_Column_List" /> |
| | | from wo_wip_sn_ex |
| | | from sta_wip_sn_ex |
| | | where id = #{id,jdbcType=VARCHAR} |
| | | </select> |
| | | |
| | | <delete id="deleteByPrimaryKey" parameterType="java.lang.Long"> |
| | | delete from wo_wip_sn_ex |
| | | delete from sta_wip_sn_ex |
| | | where id = #{id,jdbcType=VARCHAR} |
| | | </delete> |
| | | <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoWo.WoWipSnEx" useGeneratedKeys="true"> |
| | | insert into wo_wip_sn_ex |
| | | <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaWipSnEx" useGeneratedKeys="true"> |
| | | insert into sta_wip_sn_ex |
| | | ( id,device_no,product_id |
| | | ,product_name,product_no,create_time |
| | | ,create_by) |
| | |
| | | ,#{productName,jdbcType=VARCHAR},#{productNo,jdbcType=VARCHAR},#{createTime,jdbcType=TIMESTAMP} |
| | | ,#{createBy,jdbcType=VARCHAR}) |
| | | </insert> |
| | | <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoWo.WoWipSnEx" useGeneratedKeys="true"> |
| | | insert into wo_wip_sn_ex |
| | | <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaWipSnEx" useGeneratedKeys="true"> |
| | | insert into sta_wip_sn_ex |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">id,</if> |
| | | <if test="deviceNo != null">device_no,</if> |
| | |
| | | <if test="createBy != null">#{createBy,jdbcType=VARCHAR},</if> |
| | | </trim> |
| | | </insert> |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoWo.WoWipSnEx"> |
| | | update wo_wip_sn_ex |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.dy.pmsGlobal.pojoSta.StaWipSnEx"> |
| | | update sta_wip_sn_ex |
| | | <set> |
| | | <if test="deviceNo != null"> |
| | | device_no = #{deviceNo,jdbcType=VARCHAR}, |
| | |
| | | </set> |
| | | where id = #{id,jdbcType=VARCHAR} |
| | | </update> |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoWo.WoWipSnEx"> |
| | | update wo_wip_sn_ex |
| | | <update id="updateByPrimaryKey" parameterType="com.dy.pmsGlobal.pojoSta.StaWipSnEx"> |
| | | update sta_wip_sn_ex |
| | | set |
| | | device_no = #{deviceNo,jdbcType=VARCHAR}, |
| | | product_id = #{productId,jdbcType=INTEGER}, |
File was renamed from pms-parent/pms-web-work/pom.xml |
| | |
| | | |
| | | <packaging>jar</packaging> |
| | | <groupId>com.dy</groupId> |
| | | <artifactId>pms-web-work</artifactId> |
| | | <artifactId>pms-web-station</artifactId> |
| | | <version>1.0.0</version> |
| | | <name>pms-web-work</name> |
| | | <name>pms-web-station</name> |
| | | <description>免登录模块</description> |
| | | |
| | | |
File was renamed from pms-parent/pms-web-work/src/main/java/com/dy/pmsWork/PmsWorkApplication.java |
| | |
| | | package com.dy.pmsWork; |
| | | package com.dy.pmsStation; |
| | | |
| | | import org.mybatis.spring.annotation.MapperScan; |
| | | import org.springframework.boot.SpringApplication; |
| | |
| | | |
| | | @SpringBootApplication |
| | | @EnableAspectJAutoProxy |
| | | @ComponentScan(basePackages = {"com.dy.common", "com.dy.pmsGlobal", "com.dy.pmsWork"}) |
| | | @ComponentScan(basePackages = {"com.dy.common", "com.dy.pmsGlobal", "com.dy.pmsStation"}) |
| | | @MapperScan(basePackages={"com.dy.pmsGlobal.dao*"}) |
| | | public class PmsWorkApplication { |
| | | public class PmsStationApplication { |
| | | public static void main(String[] args) { |
| | | SpringApplication.run(PmsWorkApplication.class, args); |
| | | SpringApplication.run(PmsStationApplication.class, args); |
| | | } |
| | | } |
File was renamed from pms-parent/pms-web-work/src/main/java/com/dy/pmsWork/assemblyStep/AssemblyStepCtrl.java |
| | |
| | | package com.dy.pmsWork.assemblyStep; |
| | | package com.dy.pmsStation.assemblyStep; |
| | | |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
File was renamed from pms-parent/pms-web-work/src/main/java/com/dy/pmsWork/workOrder/WorkOrderCtrl.java |
| | |
| | | package com.dy.pmsWork.workOrder; |
| | | package com.dy.pmsStation.workOrder; |
| | | |
| | | import com.dy.common.webUtil.BaseResponse; |
| | | import com.dy.common.webUtil.BaseResponseUtils; |
File was renamed from pms-parent/pms-web-work/src/main/resources/application.yml |
| | |
| | | |
| | | #web服务端口,tomcat默认是8080 |
| | | server: |
| | | port: ${pms.work.webPort} |
| | | port: ${pms.station.webPort} |
| | | servlet: |
| | | context-path: /work #web访问上下文路径 |
| | | context-path: /station #web访问上下文路径 |
| | | context-parameters: |
| | | #GenerateIdSetSuffixListener中应用,取值范围是0-99 |
| | | idSuffix: ${pms.work.idSuffix} |
| | | idSuffix: ${pms.station.idSuffix} |
| | | #ConfigListener中应用 |
| | | #configFileNames: config-global.xml,config-demo.xml |
File was renamed from pms-parent/pms-web-work/src/main/resources/log4j2.yml |
| | |
| | | value: ./logs |
| | | #日志文件存储名称 |
| | | - name: project.name |
| | | value: pmsWork |
| | | value: pmsStation |
| | | |
| | | #定义输出器,可以输出到控制台和文件. |
| | | Appenders: |