package com.idea.oa.flow2.mapper; import com.idea.oa.flow2.model.in.FlowMainCcVo; import org.apache.ibatis.annotations.Select; import org.springframework.stereotype.Component; import java.util.List; @Component public interface FlowMainCcExtendMapper { @Select("SELECT frame_user.truename AS NAME,flow_main_cc.*FROM flow_main_cc LEFT JOIN frame_user ON frame_user.id=flow_main_cc.cc_user WHERE flow_main_id=#{flowMainId} GROUP BY flow_main_cc.cc_user") List selectVoByFlowMainId(String flowMainId); }