package com.idea.oa.apply.mapper;

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

@Component
public interface ApplyOffWorkExtendMapper {
    @Select("SELECT flow_main_push.id AS flowMainPushId,frame_user.truename AS createdByString,flow_main_push.flow_main_id AS flowMainId,apply_off_work.*FROM flow_main_push LEFT JOIN apply_off_work ON apply_off_work.id=flow_main_push.form_id LEFT JOIN frame_user ON frame_user.id=apply_off_work.created_by WHERE flow_main_push.id=#{flowMainPushId}")
    ApplyOffWorkIn getInfoByFlowMainPushId(String flowMainPushId);
    @Select("SELECT flow_main.id AS flowMainId,frame_user.truename AS createdByString,apply_off_work.*FROM flow_main LEFT JOIN apply_off_work ON apply_off_work.id=flow_main.form_id LEFT JOIN frame_user ON frame_user.id=apply_off_work.created_by WHERE flow_main.id=#{flowMainId}")
    ApplyOffWorkIn getInfoByFlowMainId(String flowMainId);
}