| | |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | | private LocalDate deliveryDate; |
| | | |
| | | //是否发货(台账页面颜色控制) |
| | | private Boolean isFh; |
| | | } |
| | |
| | | public interface ProductOrderMapper extends BaseMapper<ProductOrder> { |
| | | |
| | | IPage<ProductOrderDto> pageProductOrder(Page page, @Param("c") ProductOrderDto productOrder); |
| | | /** |
| | | * 根据订单ID查询工单报工 |
| | | */ |
| | | ProductOrderDto productMainByOrderId(@Param("c") ProductOrder productOrder); |
| | | |
| | | List<ProcessRoute> listProcessRoute(@Param("productModelId") Long productModelId); |
| | | |
| | |
| | | /** |
| | | * 销售台账产品id(sales_ledger_product) |
| | | */ |
| | | @ApiModelProperty(value = "销售台账产品id") |
| | | private Long saleLedgerProductId; |
| | | |
| | | /** |
| | | * 销售台账产品id(sales_ledger_product) |
| | | * 产品规格id |
| | | */ |
| | | @ApiModelProperty(value = "销售台账产品id") |
| | | @ApiModelProperty(value = "产品规格id") |
| | | private Long productModelId; |
| | | |
| | | /** |
| | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.ruoyi.framework.aspectj.lang.annotation.Excel; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | | |
| | |
| | | @TableField(fill = FieldFill.INSERT) |
| | | private Long tenantId; |
| | | |
| | | |
| | | @ApiModelProperty(value ="是否质检") |
| | | private Boolean isQuality; |
| | | |
| | | |
| | |
| | | private Integer deliveryDaysDiff; |
| | | |
| | | @TableField(exist = false) |
| | | //是否发货(台账页面颜色控制) |
| | | private Boolean isFh; |
| | | } |
| | | |
| | |
| | | </if> |
| | | </where> |
| | | </select> |
| | | <select id="productMainByOrderId" resultType="com.ruoyi.production.dto.ProductOrderDto"> |
| | | select po.*, |
| | | pwo.work_order_no, |
| | | pwo.report_work, |
| | | pwo.status, |
| | | pwo.quantity, |
| | | pwo.plan_quantity |
| | | from product_order po |
| | | left join product_work_order pwo on po.id = pwo.product_order_id |
| | | where po.id = #{c.id} |
| | | </select> |
| | | <select id="listProcessRoute" resultType="com.ruoyi.production.pojo.ProcessRoute"> |
| | | select pr.* |
| | | from process_route pr |