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);
//

}