| | |
| | | @ApiModelProperty(value = "销售台账id") |
| | | private Long salesLedgerId; |
| | | |
| | | @ApiModelProperty(value = "销售台账产品id") |
| | | private Long salesLedgerProductId; |
| | | |
| | | @TableField(exist = false) |
| | | @ApiModelProperty(value = "销售合同号") |
| | | @Excel(name = "销售合同号") |
| | |
| | | * 数量 |
| | | */ |
| | | private BigDecimal quantity; |
| | | |
| | | private String productCategory; |
| | | private String specificationModel; |
| | | } |
| | |
| | | <if test="req.salesContractNo != null and req.salesContractNo != ''"> |
| | | AND sl.sales_contract_no LIKE CONCAT('%',#{req.salesContractNo},'%') |
| | | </if> |
| | | <if test="req.productCategory != null and req.productCategory != ''"> |
| | | AND slp.product_category LIKE CONCAT('%',#{req.productCategory},'%') |
| | | </if> |
| | | <if test="req.shippingCarNumber != null and req.shippingCarNumber != ''"> |
| | | AND s.shipping_car_number LIKE CONCAT('%',#{req.shippingCarNumber},'%') |
| | | </if> |