fix: 优化
1.修改用印管理返回的申请人
2.采购增加入库数量字段
| | |
| | | // 可用数量 quantity - returnQuality |
| | | @TableField(exist = false) |
| | | private BigDecimal availableQuality; |
| | | // 入库数量 |
| | | @TableField(exist = false) |
| | | private BigDecimal inputQuantity; |
| | | @Schema(description = "创建用户") |
| | | @TableField(fill = FieldFill.INSERT) |
| | | private Integer createUser; |
| | |
| | | <select id="listPage" resultType="com.ruoyi.collaborativeApproval.dto.SealApplicationManagementDTO"> |
| | | SELECT |
| | | sam.*, |
| | | su.user_name AS create_user_name, |
| | | su.nick_name AS create_user_name, |
| | | |
| | | GROUP_CONCAT(DISTINCT d.dept_name ORDER BY d.dept_id SEPARATOR ',') AS department, |
| | | |
| | |
| | | WHEN IFNULL(t4.approved_stock_in_num, 0) <= 0 THEN '待入库' |
| | | WHEN IFNULL(t4.approved_stock_in_num, 0) >= IFNULL(T1.quantity, 0) THEN '完全入库' |
| | | ELSE '入库中' |
| | | END AS stock_in_approval_status |
| | | END AS stock_in_approval_status, |
| | | IFNULL(t4.approved_stock_in_num, 0) as input_quantity |
| | | FROM |
| | | sales_ledger_product T1 |
| | | LEFT JOIN ( |