AjhPlanScheduleDataMapper.java
2.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
package com.skua.modules.ajh.mapper;
import java.util.List;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.skua.modules.ajh.vo.AjhPlanScheduleDataVO;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import com.skua.modules.ajh.entity.AjhPlanScheduleData;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
/**
* 经营方案数据表
*/
public interface AjhPlanScheduleDataMapper extends BaseMapper<AjhPlanScheduleData> {
@Select("select d.depart_name , s1.config_name 'workItermName', s2.config_name 'workContent' ,s1.complete_time 'complete_time1',s1.responsibler 'responsibler1' ,s2.complete_time 'complete_time2',s2.responsibler 'responsibler12',sd.* " +
" from ajh_plan_schedule_data sd " +
" left join ajh_plan_schedule_config s1 on s1.id = sd.config_level1 " +
" left join ajh_plan_schedule_config s2 on s2.id = sd.config_level2 " +
" left join sys_depart d on sd.factory_id = d.id ${ew.customSqlSegment}")
IPage<AjhPlanScheduleDataVO> queryPageList(Page page, @Param(Constants.WRAPPER) QueryWrapper queryWrapper);
@Select("select d.depart_name , s1.config_name 'workItermName', s2.config_name 'workContent' ,s1.complete_time 'complete_time1',s1.responsibler 'responsibler1' ,s2.complete_time 'complete_time2',s2.responsibler 'responsibler12',sd.* " +
" from ajh_plan_schedule_data sd " +
" left join ajh_plan_schedule_config s1 on s1.id = sd.config_level1 " +
" left join ajh_plan_schedule_config s2 on s2.id = sd.config_level2 " +
" left join sys_depart d on sd.factory_id = d.id ${ew.customSqlSegment}")
List<AjhPlanScheduleDataVO> queryByList(@Param(Constants.WRAPPER) QueryWrapper queryWrapper);
void delById(@Param("factoryId") String factoryId, @Param("dateTime")String dateTime);
}