| | |
|---|
| | | public R<Page<MwCollectRecord>> collecttotal2(@DateTimeFormat(iso = DateTimeFormat.ISO.DATE)LocalDate date,@RequestParam Integer pageNum, @RequestParam Integer pageSize) { |
|---|
| | | SysUser sysUser = SecurityUtils.getLoginUser().getUser(); |
|---|
| | | SysUser byId = userService.getById(sysUser.getUserId()); |
|---|
| | | Page<MwCollectRecord> page = collectRecordService.lambdaQuery().eq(date!=null,MwCollectRecord::getCollectTime,date).eq(MwCollectRecord::getDepartmentId, byId.getDepartmentId()).orderByDesc(MwCollectRecord::getCollectTime).page(Page.of(pageNum, pageSize)); |
|---|
| | | Page<MwCollectRecord> page = collectRecordService.lambdaQuery() |
|---|
| | | .eq(MwCollectRecord::getCollectTime, DateUtils.toDate(date)) |
|---|
| | | .eq(MwCollectRecord::getDepartmentId, byId.getDepartmentId()) |
|---|
| | | .orderByDesc(MwCollectRecord::getCollectTime) |
|---|
| | | .page(Page.of(pageNum, pageSize)); |
|---|
| | | return R.ok(page); |
|---|
| | | } |
|---|
| | | |
|---|
| | |
|---|
| | | SELECT BOX_NUMBER as boxNumber,WASTE_TYPE_STR as wasteTypeStr,WASTE_TYPE as wasteType,COUNT(1) as num ,sum(WEIGHT) as weight,MAX(COLLECT_TIME) as lastTime from MEDICAL_WASTE.MW_COLLECT_RECORD |
|---|
| | | <where> |
|---|
| | | STATUS = 1 AND DEPARTMENT_ID = #{departmentId} |
|---|
| | | <if test="boxNumber != null and boxNumber != ''"> |
|---|
| | | and BOX_NUMBER like concat('%',#{boxNumber},'%') |
|---|
| | | </if> |
|---|
| | | </where> |
|---|
| | | GROUP BY BOX_ID |
|---|
| | | </select> |
|---|
