doc/create_table_production_product_main.sql
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,36 @@ drop table if exists production_product_main; create table production_product_main ( id bigint auto_increment primary key, product_no varchar(255) not null comment 'æ¥å·¥åå·', user_id bigint not null comment 'æ¥å·¥ç¨æ·id', work_order_id bigint not null comment 'å·¥åid', status int not null comment 'ç¶æ 0 å¾ æ¥å·¥ 1 å¾ ç¡®è®¤', create_time datetime null comment 'å½å ¥æ¶é´', tenant_id bigint not null comment 'ç§æ·id' ); drop table if exists production_product_output; create table production_product_output ( id bigint auto_increment primary key, product_main_id bigint not null comment 'æ¥å·¥åid', product_model_id bigint not null comment '产åid', quantity numeric(16, 4) not null comment 'æ°é', create_time datetime null comment 'å½å ¥æ¶é´', tenant_id bigint not null comment 'ç§æ·id' ); drop table if exists production_product_input; create table production_product_input ( id bigint auto_increment primary key, product_main_id bigint not null comment 'æ¥å·¥åid', product_model_id bigint not null comment '产åid', quantity numeric(16, 4) not null comment 'æ°é', create_time datetime null comment 'å½å ¥æ¶é´', tenant_id bigint not null comment 'ç§æ·id' ) src/main/java/com/ruoyi/production/controller/ProductionProductMainController.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,24 @@ package com.ruoyi.production.controller; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.ruoyi.framework.web.domain.R; import com.ruoyi.production.dto.ProductionProductMainDto; import com.ruoyi.production.pojo.ProductionProductMain; import com.ruoyi.production.service.ProductionProductMainService; import io.swagger.annotations.Api; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; @RequestMapping("productionProductMain") @RestController @Api(value = "ç产æ¥å·¥") public class ProductionProductMainController { private ProductionProductMainService productionProductMainService; @GetMapping("page") public R page(Page<ProductionProductMainDto> page, ProductionProductMainDto productionProductMainDto) { return R.ok(); } } src/main/java/com/ruoyi/production/dto/ProductionProductMainDto.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,8 @@ package com.ruoyi.production.dto; import com.ruoyi.production.pojo.ProductionProductMain; import lombok.Data; @Data public class ProductionProductMainDto extends ProductionProductMain { } src/main/java/com/ruoyi/production/mapper/ProductionProductInputMapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,9 @@ package com.ruoyi.production.mapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.ruoyi.production.pojo.ProductionProductInput; import org.apache.ibatis.annotations.Mapper; @Mapper public interface ProductionProductInputMapper extends BaseMapper<ProductionProductInput> { } src/main/java/com/ruoyi/production/mapper/ProductionProductMainMapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,12 @@ package com.ruoyi.production.mapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.ruoyi.production.pojo.ProductionProductMain; import org.apache.ibatis.annotations.Mapper; import javax.annotation.ManagedBean; @Mapper public interface ProductionProductMainMapper extends BaseMapper<ProductionProductMain> { } src/main/java/com/ruoyi/production/mapper/ProductionProductOutputMapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,9 @@ package com.ruoyi.production.mapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.ruoyi.production.pojo.ProductionProductOutput; import org.apache.ibatis.annotations.Mapper; @Mapper public interface ProductionProductOutputMapper extends BaseMapper<ProductionProductOutput> { } src/main/java/com/ruoyi/production/pojo/ProductionProductInput.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,33 @@ package com.ruoyi.production.pojo; import com.baomidou.mybatisplus.annotation.FieldFill; import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.math.BigDecimal; import java.time.LocalDateTime; @Data public class ProductionProductInput { @TableId private Long id; @ApiModelProperty(value = "æ¥å·¥id") private Long productionProductId; @ApiModelProperty(value = "产åid") private Long productModelId; @ApiModelProperty(value = "æ°é") private BigDecimal quantity; @ApiModelProperty(value = "å建æ¶é´") private LocalDateTime createTime; @ApiModelProperty(value = "ç§æ·ID") @TableField(fill = FieldFill.INSERT) private Long tenantId; } src/main/java/com/ruoyi/production/pojo/ProductionProductMain.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,35 @@ package com.ruoyi.production.pojo; import com.baomidou.mybatisplus.annotation.FieldFill; import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.time.LocalDateTime; @Data public class ProductionProductMain { @TableId private Long id; @ApiModelProperty(value = "æ¥å·¥åå·") private String productNo; @ApiModelProperty(value = "æ¥å·¥äººåid") private Long userId; @ApiModelProperty(value = "å·¥åid") private String workOrderId; @ApiModelProperty(value = "æ¥å·¥ç¶æ") private Integer status; @ApiModelProperty(value = "å建æ¶é´") private LocalDateTime createTime; @ApiModelProperty(value = "ç§æ·ID") @TableField(fill = FieldFill.INSERT) private Long tenantId; } src/main/java/com/ruoyi/production/pojo/ProductionProductOutput.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,33 @@ package com.ruoyi.production.pojo; import com.baomidou.mybatisplus.annotation.FieldFill; import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.math.BigDecimal; import java.time.LocalDateTime; @Data public class ProductionProductOutput { @TableId private Long id; @ApiModelProperty(value = "æ¥å·¥id") private Long productionProductId; @ApiModelProperty(value = "产åid") private Long productModelId; @ApiModelProperty(value = "æ°é") private BigDecimal quantity; @ApiModelProperty(value = "å建æ¶é´") private LocalDateTime createTime; @ApiModelProperty(value = "ç§æ·ID") @TableField(fill = FieldFill.INSERT) private Long tenantId; } src/main/java/com/ruoyi/production/service/ProductionProductMainService.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,7 @@ package com.ruoyi.production.service; import com.baomidou.mybatisplus.extension.service.IService; import com.ruoyi.production.pojo.ProductionProductMain; public interface ProductionProductMainService extends IService<ProductionProductMain> { } src/main/java/com/ruoyi/production/service/impl/ProductionProductMainServiceImpl.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,12 @@ package com.ruoyi.production.service.impl; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.ruoyi.production.mapper.ProductionProductMainMapper; import com.ruoyi.production.pojo.ProductionProductMain; import com.ruoyi.production.service.ProductionProductMainService; import org.springframework.stereotype.Service; @Service public class ProductionProductMainServiceImpl extends ServiceImpl<ProductionProductMainMapper, ProductionProductMain> implements ProductionProductMainService { } src/main/resources/mapper/production/ProductionProductInputMapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,6 @@ <?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.ruoyi.production.mapper.ProductionProductInputMapper"> </mapper> src/main/resources/mapper/production/ProductionProductMainMapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,6 @@ <?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.ruoyi.production.mapper.ProductionProductMainMapper"> </mapper> src/main/resources/mapper/production/ProductionProductOutputMapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,6 @@ <?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.ruoyi.production.mapper.ProductionProductOutputMapper"> </mapper>