| | |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.example.erp.mapper.mm.MaterialInventoryMapper"> |
| | | |
| | | <resultMap id="selectMaterialOutboundDetail" type="com.example.erp.entity.mm.MaterialOutboundDetail" > |
| | | <id column="id" property="id"/> |
| | | <result column="material_outbound_id" property="materialOutboundId"/> |
| | | <result column="material_outbound_number" property="materialOutboundNumber"/> |
| | | <result column="inventory_id" property="inventoryId"/> |
| | | <result column="inventory_organization" property="inventoryOrganization"/> |
| | | <result column="material_code" property="materialCode"/> |
| | | <result column="material_name" property="materialName"/> |
| | | <result column="use_id" property="useId"/> |
| | | <result column="producer" property="producer"/> |
| | | <result column="unit" property="unit"/> |
| | | <result column="width" property="width"/> |
| | | <result column="height" property="height"/> |
| | | <result column="thickness" property="thickness"/> |
| | | <result column="outbound_quantity" property="outboundQuantity"/> |
| | | <result column="single_piece_area" property="singlePieceArea"/> |
| | | <result column="inventory_area" property="inventoryArea"/> |
| | | <result column="date_of_manufacture" property="dateOfManufacture"/> |
| | | <result column="remarks" property="remarks"/> |
| | | |
| | | <result column="material_requisition_personnel" property="materialOutbound.materialRequisitionPersonnel"/> |
| | | <result column="material_requisition_team" property="materialOutbound.materialRequisitionTeam"/> |
| | | <result column="order_id" property="materialOutbound.orderId"/> |
| | | <result column="outbound_type" property="materialOutbound.outboundType"/> |
| | | <result column="warehouse_manager" property="materialOutbound.warehouseManager"/> |
| | | <result column="material_requisition_date" property="materialOutbound.materialRequisitionDate"/> |
| | | <result column="reviewed" property="materialOutbound.reviewed"/> |
| | | <result column="reviewed_time" property="materialOutbound.reviewedTime"/> |
| | | |
| | | </resultMap> |
| | | |
| | | |
| | | |
| | | <select id="getSelectMaterialInventoryDate"> |