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.dto.statistics.ProcedurePlansPageModel;
|
import doumeemes.dao.business.dto.statistics.StatisticsPlanDataModel;
|
import doumeemes.dao.business.dto.statistics.WorkPlansPageModel;
|
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);
|
|
StatisticsPlanDataModel getPlansStaticticsData(QueryWorkPlansDTO workPlans);
|
|
List<WorkPlansPageModel> selectStatisticsList(QueryWorkPlansExtDTO param);
|
|
// @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);
|
//
|
|
}
|
