feat(stock): 新增入库单创建人名称字段
- 在 StockInventoryDto 中添加 createUserName 属性
- 修改 StockInventoryMapper.xml,关联 sys_user 表获取创建人昵称
- 更新查询语句,增加 create_user_name 字段映射
- 关联 stock_in_record 与 sys_user 表,确保创建人信息正确获取
| | |
| | | * 单价(元)/件 |
| | | */ |
| | | private String taxInclusiveUnitPrice; |
| | | |
| | | private String createUserName; |
| | | } |
| | |
| | | pm.height, |
| | | pm.box_num, |
| | | pm. dollar_price, |
| | | pm.tax_inclusive_unit_price |
| | | pm.tax_inclusive_unit_price, |
| | | <!-- si.create_by--> |
| | | t2.nick_name as create_user_name |
| | | from stock_inventory si |
| | | left join product_model pm on si.product_model_id = pm.id |
| | | left join product p on pm.product_id = p.id |
| | | left join stock_in_record t1 on t1.product_model_id = si.product_model_id |
| | | left join sys_user t2 on t1.create_user = t2.user_id |
| | | where si.id = #{id} |
| | | </select> |
| | | |