programs_info/三资项目/删除前备份/apply/mapper/ApplyLxWorkExtendMapper.java

package com.idea.oa.apply.mapper;

import com.idea.oa.apply.model.inout.ApplyAddLxWorkIn;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.Map;

@Component
public interface ApplyLxWorkExtendMapper {

    @Select("SELECT flow_main.id AS flowMainId, frame_user.truename AS createdByString, apply_lx_work.* FROM flow_main LEFT JOIN apply_lx_work ON apply_lx_work.id = flow_main.form_id LEFT JOIN frame_user ON frame_user.id = apply_lx_work.created_by WHERE flow_main.id = #{flowMainId}")
    ApplyAddLxWorkIn getInfoByFlowMainId(String flowMainId);


    @Select("SELECT\n" +
            "\tflow_main_push.id AS flowMainPushId,\n" +
            "\tflow_main_push.flow_main_id AS flowMainId,\n" +
            "\tapply_lx_work.* \n" +
            "FROM\n" +
            "\tflow_main_push\n" +
            "\tLEFT JOIN apply_lx_work ON apply_lx_work.id = flow_main_push.form_id\n" +
            "WHERE\n" +
            "\tflow_main_push.id = #{flowMainPushId}")
    ApplyAddLxWorkIn getInfoByFlowMainPushId(String flowMainPushId);


}