| | |
| | | platItemId: '行号', |
| | | unit: '单位', |
| | | targetWarehouseId: "仓库", |
| | | sourceWarehouseId: "发货组织", |
| | | sourceWarehouseId: "建议调出仓", |
| | | stockOrgName: "发货组织", |
| | | platWorkCode: '计划跟踪号', |
| | | spec: '规格', |
| | | }, |
| | |
| | | <TextField source="platItemId" label="table.field.outStockItem.platItemId" key="platItemId" />, //行号 |
| | | <TextField source="matnrCode" label="table.field.outStockItem.matnrCode" key="matnrCode" />, //物料编码 |
| | | <TruncatedTextField source="maktx" label="table.field.outStockItem.maktx" key="maktx" maxLength={20} />, //物料名称 |
| | | <TextField source="splrBatch" label="table.field.outStockItem.splrBatch" key="splrBatch" />, //批次 |
| | | <TextField source="batch" label="table.field.outStockItem.splrBatch" key="batch" />, //批次 |
| | | <TextField source="spec" label="table.field.outStockItem.spec" key="spec" />, //规格 |
| | | <TextField source="purUnit" label="table.field.outStockItem.purUnit" key="purUnit" />, //单位 |
| | | <NumberField source="anfme" label="table.field.outStockItem.anfme" key="anfme" />, //应收数量 |
| | |
| | | * @returns {Array} 尾部列数组 |
| | | */ |
| | | export const getLastColumns = () => [ |
| | | <ReferenceField source="updateBy" label="common.field.updateBy" reference="user" link={false} sortable={false} key="updateBy"> |
| | | <TextField source="nickname" /> |
| | | </ReferenceField>, |
| | | <DateField source="updateTime" label="common.field.updateTime" showTime key="updateTime" />, |
| | | <ReferenceField source="createBy" label="common.field.createBy" reference="user" link={false} sortable={false} key="createBy"> |
| | | <TextField source="nickname" /> |
| | | </ReferenceField>, |
| | | <DateField source="createTime" label="common.field.createTime" showTime key="createTime" />, |
| | | ]; |
| | | |
| | | export const getOutOrderItemLastColumns = () => [ |
| | | <TextField source="stockOrgName" label="table.field.outStockItem.stockOrgName" key="stockOrgName" />, //发货组织 |
| | | <ReferenceField source="updateBy" label="common.field.updateBy" reference="user" link={false} sortable={false} key="updateBy"> |
| | | <TextField source="nickname" /> |
| | | </ReferenceField>, |
| | |
| | | return [ |
| | | ...getOutOrderItemFullBaseColumns(), |
| | | ...getOutOrderItemBaseColumns(), |
| | | ...getLastColumns() |
| | | ...getOutOrderItemLastColumns() |
| | | ]; |
| | | }; |
| | | |
| | |
| | | preferenceKey='asnOrderItem' |
| | | bulkActionButtons={false} |
| | | rowClick={(id, resource, record) => false} |
| | | omit={['id', 'orderId', 'poDetlId', 'matnrId', 'spec', 'model', 'purQty', 'purUnit', 'qrcode', 'trackCode', 'splrCode', 'projectCode', 'createBy', 'createTime']} |
| | | omit={['id', 'orderId', 'poDetlId', 'matnrId', 'spec', 'model', 'purQty', 'purUnit', 'qrcode', 'trackCode', 'splrCode', 'projectCode', 'createBy', 'createTime', 'sourceWarehouseId']} |
| | | > |
| | | {columns.map((column) => column)} |
| | | </StyledDatagrid>} |
| | |
| | | private String saleUserName; |
| | | private String customerId; |
| | | private String customerName; |
| | | private String stockOrgName; |
| | | } |
| | |
| | | <select id="queryFullOutOrderWithPaging" resultType="com.vincent.rsf.server.manager.entity.OutOrderAndItem"> |
| | | SELECT mi.id, mo.po_code, mo.type, sd.label as wkType$, sale_org_name, sale_user_name, business_time, |
| | | customer_id, customer_name, plat_work_code, plat_item_id, matnr_code, maktx, batch, stock_unit, |
| | | mi.anfme, mi.qty, source_warehouse_id, mi.update_by, mi.update_time |
| | | mi.anfme, mi.qty, stock_org_name, mi.update_by, mi.update_time |
| | | FROM man_asn_order_item mi |
| | | LEFT JOIN man_asn_order mo ON mi.order_id = mo.id AND mo.tenant_id = mi.tenant_id |
| | | LEFT JOIN sys_dict_data sd ON sd.dict_type_id = 27 and mo.wk_type = sd.`value` AND sd.tenant_id = mo.tenant_id |