库存流水 合同 验收 台账 厂商 招标 中标 技术协议 列表根据时间倒序
| | |
| | | wrapper.eq(contract.getType()!=null,Contract::getType,contract.getType()); |
| | | wrapper.like(StringUtils.isNotEmpty(contract.getName()),Contract::getName,contract.getName()); |
| | | wrapper.like(StringUtils.isNotEmpty(contract.getNumber()),Contract::getNumber,contract.getNumber()); |
| | | wrapper.orderByDesc(Contract::getCreateTime); |
| | | return R.ok(contractService.page(page, wrapper)); |
| | | } |
| | | |
| | |
| | | LambdaQueryWrapper<DeviceLeasingLedger> wrapper = Wrappers.lambdaQuery(); |
| | | wrapper.eq(StrUtil.isNotBlank(deviceLeasingLedger.getContractCode()),DeviceLeasingLedger::getContractCode,deviceLeasingLedger.getContractCode()); |
| | | wrapper.eq(StrUtil.isNotBlank(deviceLeasingLedger.getLedgerCode()),DeviceLeasingLedger::getLedgerCode,deviceLeasingLedger.getLedgerCode()); |
| | | return R.ok(deviceLeasingLedgerService.page(page, wrapper)); |
| | | wrapper.orderByDesc(DeviceLeasingLedger::getCreateTime); |
| | | return R.ok(deviceLeasingLedgerService.page(page, wrapper)); |
| | | } |
| | | |
| | | |
| | |
| | | LambdaQueryWrapper<DeviceManufacturer> wrapper = Wrappers.lambdaQuery(); |
| | | wrapper.like(StrUtil.isNotBlank(deviceManufacturer.getManufacturerCategory()),DeviceManufacturer::getManufacturerCategory,deviceManufacturer.getManufacturerCategory()); |
| | | wrapper.like(StrUtil.isNotBlank(deviceManufacturer.getManufacturerName()),DeviceManufacturer::getManufacturerName,deviceManufacturer.getManufacturerName()); |
| | | return R.ok(deviceManufacturerService.page(page, wrapper)); |
| | | wrapper.orderByDesc(DeviceManufacturer::getCreateTime); |
| | | return R.ok(deviceManufacturerService.page(page, wrapper)); |
| | | } |
| | | |
| | | |
| | |
| | | public R getPurchaseTendrOrderPage(@ParameterObject Page page, @ParameterObject PurchaseTendrOrderEntity purchaseTendrOrder) { |
| | | LambdaQueryWrapper<PurchaseTendrOrderEntity> wrapper = Wrappers.lambdaQuery(); |
| | | wrapper.like(StringUtils.isNotEmpty(purchaseTendrOrder.getPurchasePlanCode()),PurchaseTendrOrderEntity::getPurchasePlanCode,purchaseTendrOrder.getPurchasePlanCode()); |
| | | wrapper.orderBy(true,false, PurchaseTendrOrderEntity::getCreateTime); |
| | | wrapper.orderByDesc(PurchaseTendrOrderEntity::getCreateTime); |
| | | return R.ok(purchaseTendrOrderService.page(page, wrapper)); |
| | | } |
| | | |
| | |
| | | LambdaQueryWrapper<PurchaseWinningLetterEntity> wrapper = Wrappers.lambdaQuery(); |
| | | wrapper.like(StringUtils.isNotEmpty(purchaseWinningLetter.getPurchasePlanCode()), PurchaseWinningLetterEntity::getPurchasePlanCode,purchaseWinningLetter.getPurchasePlanCode()); |
| | | wrapper.like(StringUtils.isNotEmpty(purchaseWinningLetter.getWinningCode()), PurchaseWinningLetterEntity::getWinningCode,purchaseWinningLetter.getWinningCode()); |
| | | wrapper.orderBy(true,false, PurchaseWinningLetterEntity::getCreateTime); |
| | | wrapper.orderByDesc(PurchaseWinningLetterEntity::getCreateTime); |
| | | return R.ok(purchaseWinningLetterService.page(page, wrapper)); |
| | | } |
| | | |
| | |
| | | <if test="queryDTO.deviceName != null and queryDTO.deviceName !=''"> |
| | | and d.name like CONCAT('%', #{queryDTO.deviceName}, '%') |
| | | </if> |
| | | order by dta.create_time desc |
| | | </select> |
| | | |
| | | </mapper> |
| | |
| | | <if test="queryDTO.deviceName != null and queryDTO.deviceName !=''"> |
| | | and d.name like CONCAT('%', #{queryDTO.deviceName}, '%') |
| | | </if> |
| | | order by ifw.create_time desc |
| | | </select> |
| | | </mapper> |
| | |
| | | <if test="queryDTO.releaseCode != null and queryDTO.releaseCode !=''"> |
| | | and rn.release_code like CONCAT('%', #{queryDTO.releaseCode}, '%') |
| | | </if> |
| | | order by |
| | | rn.create_time |
| | | desc |
| | | </select> |
| | | </mapper> |