111

k94314517

2023-08-11 081102af72c623e9b7da1d69cf71e486c7842d43

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
38
39
40
41
42
43
44
45
package doumeemes.dao.ext;
 
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import doumeemes.dao.business.model.WorkPlans;
import doumeemes.dao.business.vo.WorkPlansVO;
import doumeemes.dao.ext.dto.QueryWorkPlansDTO;
import doumeemes.dao.ext.vo.WorkPlansExtListVO;
import doumeemes.dao.ext.dto.QueryWorkPlansExtDTO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
 
import java.util.List;
 
public interface WorkPlansExtMapper extends BaseMapper<WorkPlans> {
 
    /**
     * 管理页面查询
     * @author 江蹄蹄
     * @since 2023/07/27 13:53
     */
    List<WorkPlansExtListVO> selectList(QueryWorkPlansExtDTO dto);
 
 
 
    List<WorkPlansVO> getWorkPlansVOPage(QueryWorkPlansDTO dto);
 
    WorkPlansVO getWorkPlansVODetail(QueryWorkPlansDTO dto);
 
//    @Select(" SELECT" +
//            " `a`.*, mmodel.CODE as materialCode, mmodel.NAME as materialName , fmodel.NAME as factoryName,usermodel.REALNAME as userName , usermodel.mobile as userMobile " +
//            " FROM `work_plans` `a`" +
//            " LEFT JOIN `department` `dmodel` ON a.DEPART_ID=dmodel.ID" +
//            " LEFT JOIN `material_distribute` `mdmodel` ON a.MATERIAL_ID=mdmodel.ID" +
//            " LEFT JOIN `material` `mmodel` ON mdmodel.MATERIAL_ID=mmodel.ID " +
//            "  LEFT JOIN `department` `fmodel` ON a.FACTORY_ID=fmodel.ID" +
//            " LEFT JOIN `unit` `umodel` ON a.UNIT_ID=umodel.ID" +
//            " LEFT JOIN `system_user` `usermodel` ON a.USER_ID=usermodel.ID  " +
//            " ${ew.customSqlSegment} ")
//    IPage<WorkPlansVO> getWorkPlansVOPage(IPage<WorkPlansVO> page, @Param(Constants.WRAPPER) Wrapper wrapper);
//
 
}