GHSCPartyBuild/src/main/java/com/ghsc/partybuild/mapper/SHYKCQuery.java

package com.ghsc.partybuild.mapper;

import com.ghsc.partybuild.vo.shyk.MeetingDemocracyReviewVo;
import com.ghsc.partybuild.vo.shyk.MeetingMonthTotalVo;
import com.ghsc.partybuild.vo.shyk.MeetingTargetVo;
import com.ghsc.partybuild.vo.shyk.MeetingTypeVo;
import org.apache.ibatis.annotations.Param;

import java.util.HashMap;
import java.util.List;

/**
 * 三会一课
 *
 * @author pj
 */
public interface SHYKCQuery {

    /**
     * 查询会议
     *
     * @param partyCode
     * @param meetingName
     * @param meetingAddress
     * @param beginTime
     * @param endTime
     * @param shykStatus
     * @param shykType
     * @param userId
     * @param myMeeting      我的会议（0或1，1 则查询自己参与的会议）]
     * @param day
     * @param page
     * @param rows
     * @return
     */
    List<HashMap<String, Object>> selectMeetingList(@Param("partyCode") String partyCode, @Param("meetingName") String meetingName, @Param("meetingAddress") String meetingAddress,
                                                    @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("shykStatus") Integer shykStatus, @Param("shykType") List<Integer> shykType,
                                                    @Param("userId") String userId, @Param("myMeeting") Integer myMeeting,
                                                    @Param("day") String day, @Param("page") Integer page, @Param("rows") Integer rows, @Param("ssdzzdm") String ssdzzdm);

    /**
     * 选择议题
     *
     * @param meetingId
     * @param shykType
     * @return
     */
    List<HashMap<String, Object>> selectTopicModelListOfChoose(@Param("meetingId") String meetingId, @Param("shykType") Integer shykType);

    /**
     * 会议成员
     *
     * @param meetingId
     * @return
     */
    List<HashMap<String, Object>> selectMeetingUserList(@Param("meetingId") String meetingId);

    List<MeetingDemocracyReviewVo> selectMeetingDemocracyReviewList(@Param("meetingId") String meetingId);

    List<MeetingTypeVo> selectMeetingTypeList(@Param("meetingId") String meetingId);

    /**
     * 会议议题
     *
     * @param meetingId
     * @return
     */
    List<HashMap<String, Object>> selectMeetingTopicList(@Param("meetingId") String meetingId);

    /**
     * 删除会议成员
     *
     * @param meetingId
     * @return
     */
    int deteteMeetingUser(@Param("meetingId") String meetingId);

    /**
     * 删除会议民主评议成员
     *
     * @param meetingId
     * @return
     */
    int deteteMeetingDemocracyreview(@Param("meetingId") String meetingId);

    int deteteMeetingType(@Param("meetingId") String meetingId);

    /**
     * 删除会议议题
     *
     * @param meetingId
     * @return
     */
    int deleteMeetingTopic(@Param("meetingId") String meetingId);

    /**
     * 删除会议决议
     *
     * @param meetingId
     * @return
     */
    int deleteMeetingDecision(@Param("meetingId") String meetingId);

    /**
     * 删除会议
     *
     * @param meetingId
     * @return
     */
    int deleteMeeting(@Param("meetingId") String meetingId);

    /**
     * 查询历史会议地址
     *
     * @param userId
     * @return
     */
    List<HashMap<String, Object>> selectHistoryAddressList(String userId);


    /**
     * 统计三会一课
     *
     * @param year
     * @param quarter
     * @param dzzdm
     * @param zzfbType
     * @param ssdzzdm
     * @return
     */
    List<HashMap<String, Object>> selectMeetingTotalList(@Param("year") int year, @Param("quarter") int quarter,
                                                         @Param("dzzdm") String dzzdm, @Param("zzfbType") Integer zzfbType, @Param("ssdzzdm") String ssdzzdm);

    /**
     * 会议计划
     *
     * @param dzzdm
     * @param zzfbType
     * @return
     */
    List<HashMap<String, Object>> selectPartyPlanList(@Param("dzzdm") String dzzdm, @Param("zzfbType") Integer zzfbType);


    /**
     * 计划列表
     *
     * @param dzzdm
     * @param ssdzzdm
     * @return
     */
    List<HashMap<String, Object>> selectPlanList(@Param("dzzdm") String dzzdm, @Param("ssdzzdm") String ssdzzdm);


    /**
     * 我的会议
     *
     * @param userCode
     * @param beginTime
     * @param endTime
     * @param day
     * @param isEvaluate     是否已评价
     * @param shykType
     * @param meetingName
     * @param meetingAddress
     * @param partyCode
     * @return
     */
    List<HashMap<String, Object>> selectMyMeetingList(@Param("userCode") String userCode, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("day") String day, @Param("isEvaluate") Integer isEvaluate, @Param("shykType") Integer shykType, @Param("meetingName") String meetingName,
                                                      @Param("meetingAddress") String meetingAddress, @Param("partyCode") String partyCode);


    /**
     * 会议统计
     *
     * @param dzzdm
     * @param year
     * @param quarter
     * @param month1_bt
     * @param month1_et
     * @param month2_bt
     * @param month2_et
     * @param month3_bt
     * @param month3_et
     * @return
     */
    List<HashMap<String, Object>> selectMeetingTotalNew(@Param("dzzdm") String dzzdm, @Param("year") Integer year, @Param("quarter") Integer quarter, @Param("month1_bt") String month1_bt, @Param("month1_et") String month1_et,
                                                        @Param("month2_bt") String month2_bt, @Param("month2_et") String month2_et,
                                                        @Param("month3_bt") String month3_bt, @Param("month3_et") String month3_et);


    /**
     * 会议评价项信息
     *
     * @param meetingUserId
     * @return
     */
    List<HashMap<String, Object>> selectMeetingEvaluateProjectList(@Param("meetingUserId") String meetingUserId);

    /**
     * 删除评分项
     *
     * @param userevaluateId
     * @return
     */
    int deleteMeetingEvaluateProject(String userevaluateId);

    List<HashMap<String, Object>> selectMeetingListByApp(@Param("dzzdm") String dzzdm, @Param("userId") String userId, @Param("type") Integer type, @Param("shykTypeList") List<String> shykTypeList, @Param("title") String title, @Param("startDate") String startDate,
                                                         @Param("endDate") String endDate);


    List<HashMap<String, Object>> selectMeetingPlanTotalList(@Param("dzzdm") String dzzdm, @Param("dzzdmSearch") String dzzdmSearch, @Param("year") Integer year, @Param("quarter") Integer quarter, @Param("month") Integer month);

    List<HashMap<String, Object>> selectMyMeetingListForApp(@Param("userId") String userId);

    List<MeetingTargetVo> selectMeetingTargetList();

    List<MeetingMonthTotalVo> selectMeetingMonthTotalList(@Param("partyCode") String partyCode, @Param("year") Integer year);

}