package doumeemes.dao.business;

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 org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @author 江蹄蹄
 * @since 2023/07/24 15:33
 */
public interface WorkPlansMapper extends BaseMapper<WorkPlans> {


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




}