库存流水 合同 验收 台账 厂商 招标 中标 技术协议 列表根据时间倒序
|  |  |  | 
|---|
|  |  |  | 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> | 
|---|