| | |
| | | @GetMapping("/listInfo") |
| | | @ApiOperationSupport(order = 2) |
| | | @ApiOperation(value = "分页", notes = "传入assessmentScore") |
| | | public R<IPage<Map>> listInfo(AssessmentScoreVO assessmentScore, Query query) { |
| | | public R<IPage<AssessmentScoreVO>> listInfo(AssessmentScoreVO assessmentScore, Query query) { |
| | | return R.data(assessmentScoreService.selectAssessmentScoreInfoPage(Condition.getPage(query), assessmentScore)); |
| | | } |
| | | |
| | | @GetMapping("/listGroupByTask/{type}/{taskId}") |
| | | @ApiOperation(value = "后台考核任务考核结果", notes = "传入要查询的任务id") |
| | | public R listGroupByTask(@ApiIgnore @PathVariable Integer type,@PathVariable Long taskId, Query query, AssessmentScoreVO assessmentScore) { |
| | | // QueryWrapper<AssessmentScoreEntity> setEntityQueryWrapper = new QueryWrapper<>(); |
| | | // setEntityQueryWrapper.select("id,assessment_task_id,be_id,score_user_id,SUM(weight*score_val*0.01) as score_val,type"); |
| | | // setEntityQueryWrapper.eq("type", type); |
| | | // setEntityQueryWrapper.eq("assessment_task_id",taskId); |
| | | // setEntityQueryWrapper.groupBy("be_id"); |
| | | // IPage<AssessmentScoreEntity> pages = assessmentScoreService.page(Condition.getPage(query),setEntityQueryWrapper); |
| | | |
| | | assessmentScore.setType(type); |
| | | assessmentScore.setAssessmentTaskId(taskId); |
| | | |
| | |
| | | */ |
| | | package org.springblade.modules.assessment.mapper; |
| | | |
| | | import org.springblade.modules.assessment.entity.AssessmentScoreEntity; |
| | | import org.springblade.modules.assessment.vo.AssessmentScoreVO; |
| | | import org.springblade.modules.assessment.excel.AssessmentScoreExcel; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.baomidou.mybatisplus.core.conditions.Wrapper; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.springblade.modules.assessment.entity.AssessmentScoreEntity; |
| | | import org.springblade.modules.assessment.excel.AssessmentScoreExcel; |
| | | import org.springblade.modules.assessment.vo.AssessmentScoreVO; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * 考核评分 Mapper 接口 |
| | |
| | | */ |
| | | List<AssessmentScoreVO> selectAssessmentScorePage(IPage page, AssessmentScoreVO assessmentScore); |
| | | |
| | | List<Map> selectAssessmentScoreInfoPage(IPage page, AssessmentScoreVO assessmentScore); |
| | | List<AssessmentScoreVO> selectAssessmentScoreInfoPage(IPage page, AssessmentScoreVO assessmentScore); |
| | | |
| | | List<AssessmentScoreEntity> selectAssessmentScoreGroupByBeidPage(IPage page, AssessmentScoreVO assessmentScore); |
| | | |
| | |
| | | <result column="is_deleted" property="isDeleted"/> |
| | | </resultMap> |
| | | |
| | | <resultMap id="assessmentScoreResultInfoMap" type="java.util.Map"> |
| | | <resultMap id="assessmentScoreResultInfoMap" type="org.springblade.modules.assessment.vo.AssessmentScoreVO"> |
| | | <result column="id" property="id"/> |
| | | <result column="tenant_id" property="tenantId"/> |
| | | <result column="assessment_task_id" property="assessmentTaskId"/> |
| | |
| | | <if test="assessmentScore.assessmentTaskId != null and assessmentScore.assessmentTaskId != ''"> |
| | | and a.assessment_task_id = #{assessmentScore.assessmentTaskId} |
| | | </if> |
| | | <if test="assessmentScore.type != null and assessmentScore.type != ''"> |
| | | <if test="assessmentScore.type != null"> |
| | | and a.type = #{assessmentScore.type} |
| | | </if> |
| | | <if test="assessmentScore.userName != null and assessmentScore.userName != ''"> |
| | |
| | | package org.springblade.modules.assessment.service; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.Wrapper; |
| | | import org.springblade.modules.assessment.entity.AssessmentScoreEntity; |
| | | import org.springblade.modules.assessment.vo.AssessmentScoreVO; |
| | | import org.springblade.modules.assessment.excel.AssessmentScoreExcel; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.springblade.core.mp.base.BaseService; |
| | | import org.springblade.modules.assessment.entity.AssessmentScoreEntity; |
| | | import org.springblade.modules.assessment.excel.AssessmentScoreExcel; |
| | | import org.springblade.modules.assessment.vo.AssessmentScoreVO; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * 考核评分 服务类 |
| | |
| | | */ |
| | | IPage<AssessmentScoreVO> selectAssessmentScorePage(IPage<AssessmentScoreVO> page, AssessmentScoreVO assessmentScore); |
| | | |
| | | IPage<Map> selectAssessmentScoreInfoPage(IPage<Map> page, AssessmentScoreVO assessmentScore); |
| | | IPage<AssessmentScoreVO> selectAssessmentScoreInfoPage(IPage<AssessmentScoreVO> page, AssessmentScoreVO assessmentScore); |
| | | IPage<AssessmentScoreEntity> selectAssessmentScoreGroupByBeidPage(IPage<AssessmentScoreEntity> page, AssessmentScoreVO assessmentScore); |
| | | |
| | | |
| | |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * 考核评分 服务实现类 |
| | |
| | | } |
| | | |
| | | @Override |
| | | public IPage<Map> selectAssessmentScoreInfoPage(IPage<Map> page, AssessmentScoreVO assessmentScore) { |
| | | public IPage<AssessmentScoreVO> selectAssessmentScoreInfoPage(IPage<AssessmentScoreVO> page, AssessmentScoreVO assessmentScore) { |
| | | return page.setRecords(baseMapper.selectAssessmentScoreInfoPage(page, assessmentScore)); |
| | | } |
| | | |