| | |
|---|
| | | |
|---|
| | | param.setCompanyId(ContextUtil.getCompanyId()); |
|---|
| | | queryWrapper.eq("company_id", param.getCompanyId()); |
|---|
| | | |
|---|
| | | //库区检索 |
|---|
| | | if (StringUtils.isNotBlank(param.getDeptId())) { |
|---|
| | | queryWrapper.eq("dept_id", param.getDeptId()); |
|---|
| | | } |
|---|
| | | //仓库检索 |
|---|
| | | if (StringUtils.isNotBlank(param.getDepotId())) { |
|---|
| | | queryWrapper.eq("depot_id", param.getDepotId()); |
|---|
| | | } |
|---|
| | | // 收储公司检索 |
|---|
| | | if (StringUtils.isNotBlank(param.getKey())) { |
|---|
| | | queryWrapper.apply("dept_id IN (SELECT dept_id FROM sys_dept WHERE parent_id = {0})", param.getKey()); |
|---|
| | | } |
|---|
| | | //抓拍时间检索 |
|---|
| | | if (param.getStart() != null && param.getEnd() != null) { |
|---|
| | | queryWrapper.between("time", param.getStart(), param.getEnd()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | queryWrapper.orderByDesc("create_time"); |
|---|
| | | |
|---|
| | | return queryWrapper; |
|---|
