Merge remote-tracking branch 'origin/hckx' into hckx
| | |
| | | @Excel(name = "不含税总价") |
| | | private BigDecimal taxExclusiveTotalPrice; |
| | | |
| | | /** |
| | | * 物品类型 |
| | | */ |
| | | private String itemType; |
| | | } |
| | |
| | | and dl.device_model like concat('%',#{deviceRepairDto.deviceModel},'%') |
| | | </if> |
| | | <if test="deviceRepairDto.status != null"> |
| | | and dl.status = #{deviceRepairDto.status} |
| | | and dr.status = #{deviceRepairDto.status} |
| | | </if> |
| | | <if test="deviceRepairDto.remark != null"> |
| | | and dr.remark like concat('%',#{deviceRepairDto.remark},'%') |
| | |
| | | t2.tax_exclusive_total_price, |
| | | t1.inbound_num, |
| | | t1.create_time, |
| | | t1.create_by |
| | | t1.create_by, |
| | | t2.item_type |
| | | from procurement_record_out t1 |
| | | left join custom_storage t2 on t2.id = t1.procurement_record_storage_id |
| | | <where> |
| | |
| | | <if test="qualityInspect.entryDateEnd != null and qualityInspect.entryDateEnd != '' "> |
| | | AND check_time <= DATE_FORMAT(#{qualityInspect.entryDateEnd},'%Y-%m-%d') |
| | | </if> |
| | | ORDER BY check_time DESC |
| | | </select> |
| | | <select id="qualityInspectExport" resultType="com.ruoyi.quality.pojo.QualityInspect"> |
| | | SELECT |