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);
}