| | |
| | | wTransferDetail.setTransferId(wTransfer.getId()); |
| | | wTransferDetail.setOutDepartId(wTransfer.getOutDepartId()); |
| | | wTransferDetail.setOutWarehouseId(wTransfer.getOutWarehouseId()); |
| | | wTransferDetail.setOutLocationId(w.getOutLocationId()); |
| | | wTransferDetail.setInDepartId(wTransfer.getInDepartId()); |
| | | wTransferDetail.setInWarehouseId(wTransfer.getInWarehouseId()); |
| | | wTransferDetail.setInLcoationId(w.getInLocationId()); |
| | |
| | | FROM `system_login_log` s left join company c on s.COMPANY_ID = c.ID |
| | | <where> |
| | | s.COMPANY_ID is not null |
| | | and s.SUCCESS = 1 |
| | | and s.ORGIN is not null |
| | | <if test="dto.orgin != null"> |
| | | AND s.orgin = #{dto.orgin} |
| | | </if> |
| | | |
| | | <if test="dto.companyName != null and dto.companyName != ''"> |
| | | AND c.`NAME` LIKE CONCAT('%', #{dto.companyName}, '%') |
| | | </if> |