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

package com.idea.oa.apply.mapper;

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

import java.util.Map;

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

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



//    frame_user.posts,frame_post.post_name,frame_user.id,frame_user.truename,frame_user.department,sys_dept.dept_name as deptName
    @Select("SELECT frame_user.posts,frame_post.post_name as postName,frame_user.id,frame_user.truename,frame_user.department,sys_dept.dept_name as deptName  FROM frame_user LEFT JOIN sys_dept ON sys_dept.id=frame_user.department LEFT JOIN frame_post ON frame_post.id=frame_user.posts WHERE frame_user.id=#{userId}")
    Map<String, Object> getUserInfoByUserId(@Param("userId")  String userId);
    @Select("SELECT MAX(title) as maxnum FROM apply_payment_settle")
    String selectMaxNum();
}