| | |
| | | delete from structure_item_parameter where sample like concat('%',#{sample},'%') |
| | | </delete> |
| | | <select id="selectItemParameterList" resultType="com.yuanchu.mom.pojo.StructureItemParameter"> |
| | | select id, |
| | | select * from (select A.id, |
| | | inspection_item, |
| | | inspection_item_en, |
| | | inspection_item_subclass, |
| | |
| | | inspection_item_type, |
| | | checkout_number, |
| | | section, |
| | | create_user, |
| | | update_user, |
| | | create_time, |
| | | update_time, |
| | | A.create_user, |
| | | A.update_user, |
| | | A.create_time, |
| | | A.update_time, |
| | | method, |
| | | man_day, |
| | | bsm, |
| | |
| | | ask, |
| | | ask_tell, |
| | | inspection_item_class, |
| | | inspection_item_class_en |
| | | from structure_item_parameter |
| | | inspection_item_class_en, |
| | | code |
| | | from (select *, |
| | | CASE |
| | | WHEN INSTR(sample, ',') > 0 THEN |
| | | SUBSTRING_INDEX(SUBSTRING_INDEX(sample, '","', 1), '"', -1) |
| | | when sample = '[""]' then null |
| | | ELSE |
| | | TRIM(BOTH '["]' FROM SUBSTRING_INDEX(REPLACE(sample, '[["', ''), '"]]', 1)) |
| | | END AS samples |
| | | from structure_item_parameter) A |
| | | left join structure_test_object sto on samples = specimen_name |
| | | <if test="ew.customSqlSegment != null and ew.customSqlSegment != ''"> |
| | | ${ew.customSqlSegment} |
| | | </if> |
| | | </if>)B |
| | | order by CASE |
| | | WHEN code IS NULL THEN 1 |
| | | ELSE 0 |
| | | END, |
| | | CAST(code AS UNSIGNED) asc |
| | | </select> |
| | | |
| | | <resultMap id="getInsProductions" type="map"> |
| | |
| | | <result property="name" column="subclass"/> |
| | | </resultMap> |
| | | <select id="getInsProduction" resultMap="getInsProductions"> |
| | | select id, inspection_item, |
| | | case when inspection_item_subclass='' then inspection_item |
| | | select id, |
| | | inspection_item, |
| | | case |
| | | when inspection_item_subclass = '' then inspection_item |
| | | else inspection_item_subclass end as subclass |
| | | from structure_item_parameter |
| | | </select> |
| | | <select id="getItemTree" resultMap="itemDto"> |
| | | select sto.id sId,sto.specimen_name sName,p.id pId,p.name pName from structure_test_object sto |
| | | select sto.id sId, sto.specimen_name sName, p.id pId, p.name pName |
| | | from structure_test_object sto |
| | | left join product p on p.object_id = sto.id |
| | | </select> |
| | | |
| | |
| | | * 模æ¿åç§° |
| | | */ |
| | | @ApiModelProperty("模æ¿åç§°") |
| | | @ValueTableShow(1) |
| | | @ValueTableShow(2) |
| | | private String name; |
| | | |
| | | /** |
| | | * 夿³¨ |
| | | */ |
| | | @ApiModelProperty("夿³¨") |
| | | @ValueTableShow(2) |
| | | @ValueTableShow(3) |
| | | private String remark; |
| | | |
| | | /** |
| | |
| | | @ApiModelProperty("å建æ¶é´") |
| | | @TableField(fill = FieldFill.INSERT) |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @ValueTableShow(4) |
| | | @ValueTableShow(5) |
| | | private LocalDateTime createTime; |
| | | /** |
| | | * |
| | |
| | | @ApiModelProperty("ä¿®æ¹æ¶é´") |
| | | @TableField(fill = FieldFill.INSERT_UPDATE) |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @ValueTableShow(6) |
| | | @ValueTableShow(7) |
| | | private LocalDateTime updateTime; |
| | | |
| | | @ApiModelProperty("åå»ºç¨æ·") |
| | | @ValueTableShow(3) |
| | | @ValueTableShow(4) |
| | | @TableField(exist = false) |
| | | private String createUserName; |
| | | |
| | | @ApiModelProperty("æ´æ°ç¨æ·") |
| | | @ValueTableShow(5) |
| | | @ValueTableShow(6) |
| | | @TableField(exist = false) |
| | | private String updateUserName; |
| | | |
| | | /** |
| | | * 模æ¿ç¼å· |
| | | */ |
| | | @ApiModelProperty("模æ¿ç¼å·") |
| | | @ValueTableShow(1) |
| | | private String number; |
| | | } |
| | |
| | | |
| | | <select id="selectStandardTemplatePageList" resultType="com.yuanchu.mom.pojo.StandardTemplate"> |
| | | select * from ( |
| | | select st.id, st.name, remark, u2.name create_user_name, u3.name update_user_name, st.create_time, st.update_time |
| | | select st.id, st.name,st.number, remark, u2.name create_user_name, u3.name update_user_name, st.create_time, st.update_time |
| | | from standard_template st |
| | | left join user u2 on u2.id = st.create_user |
| | | left join user u3 on u3.id = st.update_user |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.controller; |
| | | |
| | | import io.swagger.annotations.Api; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | /** |
| | | * <p> |
| | | * 主管æå å端æ§å¶å¨ |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:39:36 |
| | | */ |
| | | @Api(tags = "绩æç®¡ç-人åèè¯") |
| | | @RestController |
| | | @RequestMapping("/evaluateCompetent") |
| | | public class EvaluateCompetentController { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.controller; |
| | | |
| | | import io.swagger.annotations.Api; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | /** |
| | | * <p> |
| | | * 人åèè¯ å端æ§å¶å¨ |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:32:45 |
| | | */ |
| | | @Api(tags = "绩æç®¡ç-人åèè¯") |
| | | @RestController |
| | | @RequestMapping("/evaluate") |
| | | public class EvaluateController { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.controller; |
| | | |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | /** |
| | | * <p> |
| | | * åå·¥äºè¯è¡¨ å端æ§å¶å¨ |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:39:45 |
| | | */ |
| | | @Api(tags = "绩æç®¡ç-人åèè¯") |
| | | @RestController |
| | | @RequestMapping("/evaluateGroup") |
| | | public class EvaluateGroupController { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.controller; |
| | | |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | /** |
| | | * <p> |
| | | * ç»é¿æå å端æ§å¶å¨ |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:39:56 |
| | | */ |
| | | @Api(tags = "绩æç®¡ç-人åèè¯") |
| | | @RestController |
| | | @RequestMapping("/evaluateLeader") |
| | | public class EvaluateLeaderController { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.mapper; |
| | | |
| | | import com.yuanchu.mom.pojo.EvaluateCompetent; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | |
| | | /** |
| | | * <p> |
| | | * 主管æå Mapper æ¥å£ |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:39:36 |
| | | */ |
| | | public interface EvaluateCompetentMapper extends BaseMapper<EvaluateCompetent> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.mapper; |
| | | |
| | | import com.yuanchu.mom.pojo.EvaluateGroup; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | |
| | | /** |
| | | * <p> |
| | | * åå·¥äºè¯è¡¨ Mapper æ¥å£ |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:39:45 |
| | | */ |
| | | public interface EvaluateGroupMapper extends BaseMapper<EvaluateGroup> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.mapper; |
| | | |
| | | import com.yuanchu.mom.pojo.EvaluateLeader; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | |
| | | /** |
| | | * <p> |
| | | * ç»é¿æå Mapper æ¥å£ |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:39:56 |
| | | */ |
| | | public interface EvaluateLeaderMapper extends BaseMapper<EvaluateLeader> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.mapper; |
| | | |
| | | import com.yuanchu.mom.pojo.Evaluate; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | |
| | | /** |
| | | * <p> |
| | | * 人åèè¯ Mapper æ¥å£ |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:32:45 |
| | | */ |
| | | public interface EvaluateMapper extends BaseMapper<Evaluate> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.pojo; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import java.io.Serializable; |
| | | |
| | | import com.yuanchu.mom.annotation.ValueTableShow; |
| | | import com.yuanchu.mom.common.OrderBy; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Getter; |
| | | import lombok.Setter; |
| | | |
| | | /** |
| | | * <p> |
| | | * 人åèè¯ |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:32:45 |
| | | */ |
| | | @Getter |
| | | @Setter |
| | | @ApiModel(value = "Evaluate对象", description = "人åèè¯") |
| | | public class Evaluate extends OrderBy implements Serializable { |
| | | |
| | | @TableId(value = "id", type = IdType.AUTO) |
| | | private Integer id; |
| | | |
| | | @ApiModelProperty("å¤é® å
³èç¨æ·id") |
| | | private Integer userId; |
| | | |
| | | @ValueTableShow(value = 1, name = "å·¥å·") |
| | | @TableField(exist = false,select = false) |
| | | private String account; |
| | | |
| | | @ValueTableShow(value = 2, name = "å§å") |
| | | @TableField(exist = false,select = false) |
| | | private String name; |
| | | |
| | | @ValueTableShow(value = 3, name = "åå·¥äºè¯") |
| | | @TableField(exist = false,select = false) |
| | | private Double groupTotal; |
| | | |
| | | @ValueTableShow(value = 4, name = "ç»é¿è¯å") |
| | | @TableField(exist = false,select = false) |
| | | private Double leaderTotal; |
| | | |
| | | @ValueTableShow(value = 5, name = "主管è¯å") |
| | | @TableField(exist = false,select = false) |
| | | private Double competentTotal; |
| | | |
| | | @ApiModelProperty("èè¯å¾å") |
| | | @ValueTableShow(6) |
| | | private Double score; |
| | | |
| | | @ApiModelProperty("èè¯ç级") |
| | | @ValueTableShow(7) |
| | | private String grade; |
| | | |
| | | @ApiModelProperty("æä»½") |
| | | private String month; |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.pojo; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.FieldFill; |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import java.io.Serializable; |
| | | import java.time.LocalDateTime; |
| | | |
| | | import com.yuanchu.mom.annotation.ValueTableShow; |
| | | import com.yuanchu.mom.common.OrderBy; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Getter; |
| | | import lombok.Setter; |
| | | |
| | | /** |
| | | * <p> |
| | | * 主管æå |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:39:36 |
| | | */ |
| | | @Getter |
| | | @Setter |
| | | @TableName("evaluate_competent") |
| | | @ApiModel(value = "EvaluateCompetent对象", description = "主管æå") |
| | | public class EvaluateCompetent extends OrderBy implements Serializable { |
| | | |
| | | |
| | | @TableId(value = "id", type = IdType.AUTO) |
| | | private Integer id; |
| | | |
| | | @ApiModelProperty("å¤é® å
³è人åèè¯è¡¨id") |
| | | private Integer evaluateId; |
| | | |
| | | @ValueTableShow(value = 1, name = "å§å") |
| | | @TableField(exist = false,select = false) |
| | | private String name; |
| | | |
| | | @TableField(fill = FieldFill.INSERT) |
| | | private LocalDateTime createTime; |
| | | |
| | | @TableField(fill = FieldFill.INSERT_UPDATE) |
| | | private LocalDateTime updateTime; |
| | | |
| | | @TableField(fill = FieldFill.INSERT) |
| | | private Integer createUser; |
| | | |
| | | @TableField(fill = FieldFill.INSERT_UPDATE) |
| | | private Integer updateUser; |
| | | |
| | | @ApiModelProperty("æè½æ°´å¹³") |
| | | @ValueTableShow(2) |
| | | private Double skill; |
| | | |
| | | @ApiModelProperty("æä»åå·¥") |
| | | @ValueTableShow(3) |
| | | private Double compliance; |
| | | |
| | | @ApiModelProperty("ç§¯ææ§") |
| | | @ValueTableShow(4) |
| | | private Double positive; |
| | | |
| | | @ApiModelProperty("5S-3å®") |
| | | @ValueTableShow(5) |
| | | private Double tidy; |
| | | |
| | | @ApiModelProperty("è§ç« å¶åº¦") |
| | | @ValueTableShow(6) |
| | | private Double discipline; |
| | | |
| | | @ApiModelProperty("å¢ç»åä½") |
| | | @ValueTableShow(7) |
| | | private Double solidarity; |
| | | |
| | | @ApiModelProperty("ææ¡ç§¯å") |
| | | @ValueTableShow(8) |
| | | private Double proposal; |
| | | |
| | | @ApiModelProperty("å¾å") |
| | | @ValueTableShow(9) |
| | | private Double total; |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.pojo; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.FieldFill; |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import java.io.Serializable; |
| | | import java.time.LocalDateTime; |
| | | |
| | | import com.yuanchu.mom.annotation.ValueTableShow; |
| | | import com.yuanchu.mom.common.OrderBy; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Getter; |
| | | import lombok.Setter; |
| | | |
| | | /** |
| | | * <p> |
| | | * åå·¥äºè¯è¡¨ |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:39:45 |
| | | */ |
| | | @Getter |
| | | @Setter |
| | | @TableName("evaluate_group") |
| | | @ApiModel(value = "EvaluateGroup对象", description = "åå·¥äºè¯è¡¨") |
| | | public class EvaluateGroup extends OrderBy implements Serializable { |
| | | |
| | | |
| | | @TableId(value = "id", type = IdType.AUTO) |
| | | private Integer id; |
| | | |
| | | @ApiModelProperty("å¤é® å
³è人åèè¯è¡¨id") |
| | | private Integer evaluateId; |
| | | |
| | | @ValueTableShow(value = 1, name = "å§å") |
| | | @TableField(exist = false,select = false) |
| | | private String name; |
| | | |
| | | @ApiModelProperty("åæ¶æ§") |
| | | @ValueTableShow(2) |
| | | private Double seasonable; |
| | | |
| | | @ApiModelProperty("åç¡®æ§") |
| | | @ValueTableShow(3) |
| | | private Double exact; |
| | | |
| | | @ApiModelProperty("æä½æè½") |
| | | @ValueTableShow(4) |
| | | private Double skill; |
| | | |
| | | @ApiModelProperty("设å¤ç»´æ¤") |
| | | @ValueTableShow(5) |
| | | private Double preserve; |
| | | |
| | | @ApiModelProperty("éµç« å®çºª") |
| | | @ValueTableShow(6) |
| | | private Double discipline; |
| | | |
| | | @ApiModelProperty("å¢ç»åä½") |
| | | @ValueTableShow(7) |
| | | private Double solidarity; |
| | | |
| | | @ApiModelProperty("5S-3å®") |
| | | @ValueTableShow(8) |
| | | private Double tidy; |
| | | |
| | | @ApiModelProperty("å¾å") |
| | | @ValueTableShow(9) |
| | | private Double total; |
| | | |
| | | @TableField(fill = FieldFill.INSERT) |
| | | private LocalDateTime createTime; |
| | | |
| | | @TableField(fill = FieldFill.INSERT_UPDATE) |
| | | private LocalDateTime updateTime; |
| | | |
| | | @TableField(fill = FieldFill.INSERT) |
| | | private Integer createUser; |
| | | |
| | | @TableField(fill = FieldFill.INSERT_UPDATE) |
| | | private Integer updateUser; |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.pojo; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.FieldFill; |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import java.io.Serializable; |
| | | import java.time.LocalDateTime; |
| | | |
| | | import com.yuanchu.mom.annotation.ValueTableShow; |
| | | import com.yuanchu.mom.common.OrderBy; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Getter; |
| | | import lombok.Setter; |
| | | |
| | | /** |
| | | * <p> |
| | | * ç»é¿æå |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:39:56 |
| | | */ |
| | | @Getter |
| | | @Setter |
| | | @TableName("evaluate_leader") |
| | | @ApiModel(value = "EvaluateLeader对象", description = "ç»é¿æå") |
| | | public class EvaluateLeader extends OrderBy implements Serializable { |
| | | |
| | | @TableId(value = "id", type = IdType.AUTO) |
| | | private Integer id; |
| | | |
| | | @ApiModelProperty("å¤é® å
³è人åèè¯è¡¨id") |
| | | private Integer evaluateId; |
| | | |
| | | @ValueTableShow(value = 1, name = "å§å") |
| | | @TableField(exist = false,select = false) |
| | | private String name; |
| | | |
| | | @TableField(fill = FieldFill.INSERT) |
| | | private LocalDateTime createTime; |
| | | |
| | | @TableField(fill = FieldFill.INSERT_UPDATE) |
| | | private LocalDateTime updateTime; |
| | | |
| | | @TableField(fill = FieldFill.INSERT) |
| | | private Integer createUser; |
| | | |
| | | @TableField(fill = FieldFill.INSERT_UPDATE) |
| | | private Integer updateUser; |
| | | |
| | | @ApiModelProperty("å·¥ä½è´£ä»»å¿") |
| | | @ValueTableShow(2) |
| | | private Double responsibility; |
| | | |
| | | @ApiModelProperty("æä»åå·¥") |
| | | @ValueTableShow(3) |
| | | private Double compliance; |
| | | |
| | | @ApiModelProperty("ç§¯ææ§") |
| | | @ValueTableShow(4) |
| | | private Double positive; |
| | | |
| | | @ApiModelProperty("å¢ç»åäº") |
| | | @ValueTableShow(5) |
| | | private Double solidarity; |
| | | |
| | | @ApiModelProperty("åæ¶æ§") |
| | | @ValueTableShow(6) |
| | | private Double seasonable; |
| | | |
| | | @ApiModelProperty("åç¡®æ§") |
| | | @ValueTableShow(7) |
| | | private Double exact; |
| | | |
| | | @ApiModelProperty("å¾å") |
| | | @ValueTableShow(8) |
| | | private Double total; |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.service; |
| | | |
| | | import com.yuanchu.mom.pojo.EvaluateCompetent; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | |
| | | /** |
| | | * <p> |
| | | * 主管æå æå¡ç±» |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:39:36 |
| | | */ |
| | | public interface EvaluateCompetentService extends IService<EvaluateCompetent> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.service; |
| | | |
| | | import com.yuanchu.mom.pojo.EvaluateGroup; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | |
| | | /** |
| | | * <p> |
| | | * åå·¥äºè¯è¡¨ æå¡ç±» |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:39:45 |
| | | */ |
| | | public interface EvaluateGroupService extends IService<EvaluateGroup> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.service; |
| | | |
| | | import com.yuanchu.mom.pojo.EvaluateLeader; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | |
| | | /** |
| | | * <p> |
| | | * ç»é¿æå æå¡ç±» |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:39:56 |
| | | */ |
| | | public interface EvaluateLeaderService extends IService<EvaluateLeader> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.service; |
| | | |
| | | import com.yuanchu.mom.pojo.Evaluate; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | |
| | | /** |
| | | * <p> |
| | | * 人åèè¯ æå¡ç±» |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:32:45 |
| | | */ |
| | | public interface EvaluateService extends IService<Evaluate> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.service.impl; |
| | | |
| | | import com.yuanchu.mom.pojo.EvaluateCompetent; |
| | | import com.yuanchu.mom.mapper.EvaluateCompetentMapper; |
| | | import com.yuanchu.mom.service.EvaluateCompetentService; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | /** |
| | | * <p> |
| | | * 主管æå æå¡å®ç°ç±» |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:39:36 |
| | | */ |
| | | @Service |
| | | public class EvaluateCompetentServiceImpl extends ServiceImpl<EvaluateCompetentMapper, EvaluateCompetent> implements EvaluateCompetentService { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.service.impl; |
| | | |
| | | import com.yuanchu.mom.pojo.EvaluateGroup; |
| | | import com.yuanchu.mom.mapper.EvaluateGroupMapper; |
| | | import com.yuanchu.mom.service.EvaluateGroupService; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | /** |
| | | * <p> |
| | | * åå·¥äºè¯è¡¨ æå¡å®ç°ç±» |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:39:45 |
| | | */ |
| | | @Service |
| | | public class EvaluateGroupServiceImpl extends ServiceImpl<EvaluateGroupMapper, EvaluateGroup> implements EvaluateGroupService { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.service.impl; |
| | | |
| | | import com.yuanchu.mom.pojo.EvaluateLeader; |
| | | import com.yuanchu.mom.mapper.EvaluateLeaderMapper; |
| | | import com.yuanchu.mom.service.EvaluateLeaderService; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | /** |
| | | * <p> |
| | | * ç»é¿æå æå¡å®ç°ç±» |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:39:56 |
| | | */ |
| | | @Service |
| | | public class EvaluateLeaderServiceImpl extends ServiceImpl<EvaluateLeaderMapper, EvaluateLeader> implements EvaluateLeaderService { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.yuanchu.mom.service.impl; |
| | | |
| | | import com.yuanchu.mom.pojo.Evaluate; |
| | | import com.yuanchu.mom.mapper.EvaluateMapper; |
| | | import com.yuanchu.mom.service.EvaluateService; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | /** |
| | | * <p> |
| | | * 人åèè¯ æå¡å®ç°ç±» |
| | | * </p> |
| | | * |
| | | * @author æ±èéµ·éç½ç»ç§ææéå
¬å¸ |
| | | * @since 2024-06-17 01:32:45 |
| | | */ |
| | | @Service |
| | | public class EvaluateServiceImpl extends ServiceImpl<EvaluateMapper, Evaluate> implements EvaluateService { |
| | | |
| | | } |
| | |
| | | <?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.yuanchu.mom.mapper.AuxiliaryCorrectionHoursMapper"> |
| | | |
| | | <!-- éç¨æ¥è¯¢æ å°ç»æ --> |
| | | <resultMap id="BaseResultMap" type="com.yuanchu.mom.pojo.AuxiliaryCorrectionHours"> |
| | | <id column="id" property="id" /> |
| | |
| | | </if> |
| | | </select> |
| | | <select id="selDepartLimsByName" resultType="java.lang.Integer"> |
| | | select id from department_lims where name LIKE CONCAT('%', #{departLims}, '%'); |
| | | select id |
| | | from department_lims |
| | | where name LIKE CONCAT('%', #{departLims}, '%'); |
| | | </select> |
| | | </mapper> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?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.yuanchu.mom.mapper.EvaluateCompetentMapper"> |
| | | |
| | | <!-- éç¨æ¥è¯¢æ å°ç»æ --> |
| | | <resultMap id="BaseResultMap" type="com.yuanchu.mom.pojo.EvaluateCompetent"> |
| | | <id column="id" property="id" /> |
| | | <result column="evaluate_id" property="evaluateId" /> |
| | | <result column="create_time" property="createTime" /> |
| | | <result column="update_time" property="updateTime" /> |
| | | <result column="create_user" property="createUser" /> |
| | | <result column="update_user" property="updateUser" /> |
| | | <result column="skill" property="skill" /> |
| | | <result column="compliance" property="compliance" /> |
| | | <result column="positive" property="positive" /> |
| | | <result column="tidy" property="tidy" /> |
| | | <result column="discipline" property="discipline" /> |
| | | <result column="solidarity" property="solidarity" /> |
| | | <result column="proposal" property="proposal" /> |
| | | <result column="total" property="total" /> |
| | | </resultMap> |
| | | |
| | | </mapper> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?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.yuanchu.mom.mapper.EvaluateGroupMapper"> |
| | | |
| | | <!-- éç¨æ¥è¯¢æ å°ç»æ --> |
| | | <resultMap id="BaseResultMap" type="com.yuanchu.mom.pojo.EvaluateGroup"> |
| | | <id column="id" property="id" /> |
| | | <result column="evaluate_id" property="evaluateId" /> |
| | | <result column="seasonable" property="seasonable" /> |
| | | <result column="exact" property="exact" /> |
| | | <result column="skill" property="skill" /> |
| | | <result column="preserve" property="preserve" /> |
| | | <result column="discipline" property="discipline" /> |
| | | <result column="solidarity" property="solidarity" /> |
| | | <result column="tidy" property="tidy" /> |
| | | <result column="total" property="total" /> |
| | | <result column="create_time" property="createTime" /> |
| | | <result column="update_time" property="updateTime" /> |
| | | <result column="create_user" property="createUser" /> |
| | | <result column="update_user" property="updateUser" /> |
| | | </resultMap> |
| | | |
| | | </mapper> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?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.yuanchu.mom.mapper.EvaluateLeaderMapper"> |
| | | |
| | | <!-- éç¨æ¥è¯¢æ å°ç»æ --> |
| | | <resultMap id="BaseResultMap" type="com.yuanchu.mom.pojo.EvaluateLeader"> |
| | | <id column="id" property="id" /> |
| | | <result column="evaluate_id" property="evaluateId" /> |
| | | <result column="create_time" property="createTime" /> |
| | | <result column="update_time" property="updateTime" /> |
| | | <result column="create_user" property="createUser" /> |
| | | <result column="update_user" property="updateUser" /> |
| | | <result column="responsibility" property="responsibility" /> |
| | | <result column="compliance" property="compliance" /> |
| | | <result column="positive" property="positive" /> |
| | | <result column="solidarity" property="solidarity" /> |
| | | <result column="seasonable" property="seasonable" /> |
| | | <result column="exact" property="exact" /> |
| | | <result column="total" property="total" /> |
| | | </resultMap> |
| | | |
| | | </mapper> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?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.yuanchu.mom.mapper.EvaluateMapper"> |
| | | |
| | | <!-- éç¨æ¥è¯¢æ å°ç»æ --> |
| | | <resultMap id="BaseResultMap" type="com.yuanchu.mom.pojo.Evaluate"> |
| | | <id column="id" property="id" /> |
| | | <result column="user_id" property="userId" /> |
| | | <result column="score" property="score" /> |
| | | <result column="grade" property="grade" /> |
| | | <result column="month" property="month" /> |
| | | </resultMap> |
| | | |
| | | </mapper> |
| | |
| | | public static String database_username = "root"; |
| | | public static String database_password= "123456"; |
| | | public static String author = "æ±èéµ·éç½ç»ç§ææéå
¬å¸"; |
| | | public static String model_name = "/inspect-server"; // å¦æä¸ºåå¸å¼å¡«å模ååç§°ï¼å¦æä¸æ¯åå¸å¼ä¸ºç©ºå³å¯ |
| | | public static String model_name = "/performance-server"; // å¦æä¸ºåå¸å¼å¡«å模ååç§°ï¼å¦æä¸æ¯åå¸å¼ä¸ºç©ºå³å¯ |
| | | public static String setParent = "com.yuanchu.mom"; // å
è·¯å¾ |
| | | public static void main(String[] args) { |
| | | String projectPath = System.getProperty("user.dir"); |