| | |
| | | <resultMap id="gdSupplyDemandAuditAttachmentVOResultMap" type="org.sxkj.gd.orderdata.vo.GdSupplyDemandAuditAttachmentVO" extends="gdSupplyDemandAuditAttachmentResultMap"> |
| | | <result column="file_url" property="fileUrl"/> |
| | | <result column="file_size" property="fileSize"/> |
| | | <result column="file_original_name" property="fileOriginalName"/> |
| | | </resultMap> |
| | | |
| | | |
| | |
| | | select |
| | | audit_attachment.*, |
| | | attach.link as file_url, |
| | | round(attach.attach_size / 1024 / 1024, 2) as file_size |
| | | round(attach.attach_size / 1024 / 1024, 2) as file_size, |
| | | attach.original_name as file_original_name |
| | | from ja_gd_supply_demand_audit_attachment audit_attachment |
| | | left join blade_attach attach on attach.id = audit_attachment.attach_id and attach.is_deleted = 0 |
| | | <where> |