feat(procurement): 入库/出库/库存列表按入库时间倒序排序
| | |
| | | and t1.product_model_id = #{req.productModelId} |
| | | </if> |
| | | </where> |
| | | order by t1.create_time DESC, t1.id DESC |
| | | </select> |
| | | <select id="list" resultType="com.ruoyi.procurementrecord.dto.ProcurementPageDto"> |
| | | select |
| | |
| | | specificationModel, |
| | | unit |
| | | order by |
| | | (t3.supplier_name IS NULL) DESC, |
| | | t3.supplier_name ASC |
| | | max(t1.create_time) DESC |
| | | </select> |
| | | <select id="listCopy" resultType="com.ruoyi.procurementrecord.dto.ProcurementPageDtoCopy"> |
| | | select |
| | |
| | | and t1.create_time like concat('%',#{req.timeStr},'%') |
| | | </if> |
| | | </where> |
| | | order by t1.create_time DESC, t1.id DESC |
| | | </select> |
| | | <select id="list" resultType="com.ruoyi.procurementrecord.dto.ProcurementRecordOutPageDto"> |
| | | select |