liuxiaolong
2019-05-09 0d1d88cdb668e75ea8609417ac18ae19947e9525
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
package com.basic.x01.location.mapper;
 
import java.util.List;
import java.util.Map;
 
import org.apache.ibatis.annotations.Param;
 
import com.basic.x01.location.model.TbLocDevice;
import com.basic.x01.location.model.TbLocPosition;
import com.basic.x01.location.model.TbLocTransfer;
import com.basic.x01.system.model.TbSchoolClass;
import com.basic.x01.system.model.TbSchoolStudent;
 
public interface LocationMapper {
    int checkSchoolAccessKey(String schoolId, String accessKey);
    
    TbLocTransfer getSchoolTransferDevice(String schoolId, int transferId);
    
    List<TbLocDevice> getLocDeviceListBySchoolIdTransferId(String schoolId, int transferId);
    
    List<TbLocPosition> getLocPositionListBySchoolId(String schoolId);
    
    TbSchoolStudent getStudentBySchoolIdLocCardNo(String schoolId, String locCardNo);
    
    TbLocPosition getLocPositionBySchoolIdPositionId(String schoolId, int positionId);
    
    TbSchoolClass getSchoolClassBySchoolIdClassId(String schoolId, String classId);
    
    int insertTbLocLog(@Param("stu") TbSchoolStudent stu, 
            @Param("pos") TbLocPosition pos,
            @Param("cls") TbSchoolClass cls,
            @Param("locTime") String locTime, 
            @Param("locType") String locType);
    
    List<Map<String,Object>> getLocLogList(Map<String,Object> param);
    
    List<String> getValidCardNoList(String schoolId);
 
    void insertForm_sign(@Param("id") String id,@Param("create_by") String create_by,@Param("create_date") String create_date,@Param("update_by") String update_by,@Param("update_date") String update_date,@Param("remarks") String remarks,@Param("del_flag") String del_falg,@Param("sign_time") String sign_time,@Param("sign_card_id") String sign_card_id,@Param("sign_type") int sign_type,@Param("location_id") int location_id);
}