programs_info/保障房管理系统/更新前备份一下/oa/flow2/mapper/FlowMainCcExtendMapper.java

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<FlowMainCcVo> selectVoByFlowMainId(String flowMainId);
}