package com.sincere.haikangface.dao;

import com.sincere.haikangface.bean.*;
import com.sincere.haikangface.bean.face.DeviceAuthRecord;
import com.sincere.haikangface.bean.test.SaveStudentBak;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface UserDao {

    @Select("select Top(1) student_num from SZ_V_School_Student where student_id = #{student_id} and role_state = 1")
    String getStudent_Num(@Param("student_id") String student_id);

    @Insert("insert into TK_Question (Question,Qtype,Answer,CorrectAnswer,Analysis,State,Intime,ExamineFlag,ExamineUserId, " +
            "CreateUserId,SubjectId,SuggestionTime,DifficulteId,KnowledgeId,TestId,ChapterId,\n" +
            "GradeId,SourceId,OrderId,SId,StemId,AutomaticCorrection,SchoolId) values(#{Question},#{Qtype},#{Answer},#{CorrectAnswer},#{Analysis}" +
            ",#{State},#{Intime},#{ExamineFlag},#{ExamineUserId},#{CreateUserId},#{SubjectId},#{SuggestionTime},#{DifficulteId},#{KnowledgeId},#{TestId}" +
            ",#{ChapterId},#{GradeId},#{SourceId},#{OrderId},#{SId},#{StemId},#{AutomaticCorrection},#{SchoolId})")
    int insertTK(@Param("Question") String Question, @Param("Qtype") String Qtype, @Param("Answer") String Answer, @Param("CorrectAnswer") String CorrectAnswer,
                 @Param("Analysis") String Analysis, @Param("State") String State, @Param("Intime") String Intime, @Param("ExamineFlag") String ExamineFlag, @Param("ExamineUserId") String ExamineUserId,
                 @Param("CreateUserId") String CreateUserId, @Param("SubjectId") String SubjectId, @Param("SuggestionTime") String SuggestionTime, @Param("DifficulteId") String DifficulteId,
                 @Param("KnowledgeId") String KnowledgeId, @Param("TestId") String TestId, @Param("ChapterId") String ChapterId, @Param("GradeId") String GradeId, @Param("SourceId") String SourceId,
                 @Param("OrderId") String OrderId, @Param("SId") String SId, @Param("StemId") String StemId, @Param("AutomaticCorrection") String AutomaticCorrection, @Param("SchoolId") String SchoolId);

    @Select("select school_name from SZ_School where school_id = #{schoolid}")
    String getSchoolName(@Param("schoolid") String schoolid);


    @Select("select Top(1) * from SZ_V_School_Student where studentcode = #{studentcode} and school_id = #{schoolId}")
    StudentBean getStudentWithstudentcode(@Param("studentcode") String studentcode, @Param("schoolId") String schoolId);

    @Select("select Top(1)*\n" +
            "from SZ_V_School_Teacher\n" +
            "where num = #{num} and school_id = #{schoolId}")
    StudentBean getTeacherWithstudentcode(@Param("num") String num, @Param("schoolId") String schoolId);

    @Select("select top(1) school_id from SZ_Attendance where clint_id = #{devId}")
    String getSchoolIdWithDevId(@Param("devId") String devId);

    @Insert("insert into CW_StuTemperatureReocrd values (#{UserId},#{StudentId},#{Name},#{ClassId},#{ClassName},#{Temperature},#{Type},#{SchoolId},#{Intime})")
    void addWGTem(@Param("UserId") String UserId, @Param("StudentId") String StudentId, @Param("Name") String Name, @Param("ClassId") String ClassId,
                  @Param("ClassName") String ClassName, @Param("Temperature") String Temperature, @Param("Type") String Type, @Param("SchoolId") String SchoolId, @Param("Intime") String Intime);

    @Select("select Top(1) studentcode from SZ_V_School_Student where student_num = #{num}")
    String getStudentCode(@Param("num") String num);

    @Select("select Top(1) * from SZ_V_School_Teacher where user_id = #{userId} and teacher_num<>''")
    TeacherBean getTeacherWithUserId(@Param("userId") String userId);

    @Select("select Top(1) * from SZ_V_School_Teacher where user_id = #{userId}")
    TeacherBean getTeacherWithUserId1(@Param("userId") String userId);


    List<String> getStudentWiSidAndSex(@Param("schoolId") String schoolId, @Param("sexs") List<String> sexs);

    List<String> getStudentCard(@Param("schoolId") int schoolId , @Param("studentType") int studentType, @Param("sex") List<Integer> sex);

    List<String> getDeviceRoomRelation(@Param("clint_id") String clint_id);

    void insertBaiduFaceRecorder(BaiduFaceRecorder baiduFaceRecorder);

    @Select("select top(1) num from SZ_V_School_Teacher where teacher_num=#{num}")
    String getTeaNumWithCard(@Param("num") String num);

    @Select("select clint_id from SZ_Attendance where clint_type in(8,9,10) and school_id = #{schoolId}")
    List<String> getKBDevices(@Param("schoolId") String schoolId);

    /**************************************** add by xuquan **************************************/
    DeviceAuthRecord getAuthRecord(Integer authId);

    Integer getAuthRecordBySchoolId(@Param("schoolId") Integer schoolId, @Param("studentType") Integer studentType,@Param("status") Integer status);

    void insertAuthRecord(DeviceAuthRecord record);

    void deleteAuthRecord(@Param("id") Integer authId);

    void updateAuthRecord(@Param("id") Integer authId, @Param("grantState") Integer grantState);

    @Select("select clint_type from SZ_Attendance where clint_id = #{deviceId}")
    Integer getClintTypeByDeviceId(@Param("deviceId") String deviceId);

    List<StudentBean> getStudentBySchoolId(@Param("schoolId") Integer schoolId);

    List<StudentBean> getTeacherBySchoolId(@Param("schoolId") Integer schoolId);

    List<StudentBean> getStudentList(@Param("schoolId") Integer schoolId,
                                     @Param("studentType")Integer studentType,
                                     @Param("sex") List<Integer> sex);

    List<StudentBean> getStudentCardGroup(@Param("schoolId") Integer schoolId,
                                          @Param("studentType")Integer studentType,
                                          @Param("sexList") List<Integer> sexList,
                                          @Param("groupId")Integer groupId);

    List<StudentBean> getStudentByClassId(@Param("schoolId") int schoolId,
                                          @Param("studentType") Integer studentType,
                                          @Param("classIds") List<String> classIds,
                                          @Param("sexList") List<String> sexList);

    List<String> getDeviceIds(@Param("schoolId") Integer schoolId,@Param("deviceId") String deviceId);

    void updateUser(@Param("userId") String userId,@Param("face") String face);

    List<String> queryStudentIdList(@Param("schoolId") Integer schoolId,@Param("roomId")Integer roomId);

    @Select(" select top 1* from SZ_V_School_Student where student_id = #{student_id}")
    StudentBean getStudentWithid(@Param("student_id") String student_id);

    StudentBean getStudentByUserId(@Param("userId") String userId,@Param("schoolId") Integer schoolId);

    StudentBean getTeacherByUserId(@Param("userId") String userId,@Param("schoolId") Integer schoolId);

    StudentBean getStudentWithCard(@Param("card") String card,@Param("schoolId") Integer schoolId);

    StudentBean getTeacherWithCard(@Param("teacher_num") String teacher_num,@Param("schoolId") Integer schoolId);

    void insertCard(UpdateCardBean bean);

    List<Integer> getRoomBySchoolId(@Param("schoolId") Integer schoolId,@Param("groupId") Integer groupId);

    List<StudentBean> getStudentByRoomIds(@Param("schoolId") Integer schoolId,@Param("pIdList") List<Integer> pIdList);

    /***找回已毕业的数据***/
    List<StudentBean> getTestVsByKeyword(@Param("schoolId") int schoolId,
                                         @Param("keyword") String keyword,
                                         @Param("sexList") List<Integer> sexList,
                                         @Param("studentType")Integer studentType);
}