package com.skyline.electricity.mapper;

import java.util.*;
import com.skyline.electricity.pojo.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import javax.sound.sampled.Line;

@Mapper
public interface DetectMapper
{
    @Select("SELECT * from fence where st_intersects(ST_GeomFromText('POINT(${lat} ${lon})'),	fenceposition) and status='enabled'" )
    List<FencePosition> checkInFence(String lon,String lat);

    @Select("SELECT * from fence_user where workid=#{workid} and userid=#{userid}" )
    Fence_User checkInAlert(String workid,String userid);

    void updateInfomation(Information information);

    String judge(final Map<Object, Object> map);
    
    void insertPoint(final PersonPosition route);
    
    List<String> getRoute(final String username);
    
    List<Wifi> getWifiInfo();
    
    List<Monitor> getMonitorInfo();
    
    List<DoorAccess> getDoorAccessInfo();
    
    void insertPolygon(final FencePosition fencePosition);
    
    FencePosition selectPolygon(final FencePosition fencePosition);
    
    void insertHp(final HistoryPosition historyPosition);
    
    List<HistoryPosition> getRouteByUserId(final String entityId, final String starttime, final String endtime);
    
    List<FencePosition> getFenceInfo(final String workId);
    
    int updateFenceInfo(final FencePosition fencePosition);
    
    void updateFenceById(final FencePosition fencePosition);
    
    String intersects(final Map<String, Object> map);
    
    int deleteFenceById(final String workId);
    
    int deleteFence();
    
    List<FencePosition> getFenceInfoByStatus();
    
    void changeFenceStatus(final String workId);
    
    int deleteDisabledFence();
    
    Information selectPosition(final String userId, final String workId);
    
    Information selectPositionDelay(final String userId, final String fenceId);
    
    void insertInfo(final Information information);
    
    void changeStatus(final String userId, final String workId);
    
    List<PersonPosition> getPositionById(final String userId);
    
    List<FencePosition> getFenceInfoById(final String workId);
    
    void setFenceEnabled(final String workId);
    
    void setFenceDisabled(final String workId);
    
    void setDisabled(final String workId);
    
    void setEnabled(final String workId);
    
    String transLocation(final String point);
    
    List<DeviceInfo> getDeviceInfo();
    
    DeviceInfo getDeviceInfoById(final String device_id);
    
    List<String> getDeviceId();
    
    List<DeviceKKS> getDeviceKKSInfo(final String device_id);
    
    List<MonitorInfo> getMonitorDeviceInfo();
    
    List<MonitorInfo> getMonitorDeviceInfoById(final String monitor_index);
    
    List<FencePosition> getFixedFenceInfo();
    
    void setFenceEnabledByStartTime(final String workId);
    
    List<FencePosition> getTempFenceInfo();
    
    void insertFencePersonRel(final List<Map<String, Object>> personlist);
    
    void delFencePersonRel(final String workid);
    
    List<Map<String, Object>> selectFencePersonRelByworkid(final String workid);
    
    void insertfixareaPersonRel(final List<Map<String, Object>> personlist);
    
    List<Map<String, Object>> selectAllfixedareaPerson();
    
    List<Map<String, Object>> selectAllfencePerson();
    
    List<FencePosition> selectFenceAndfixedYQArea();
    
    void insertPolygon_yq(final FencePosition fencePosition);
    
    FenceTemp selectFenceTemp(final String workId, final String userId);
    
    void insetFenceTemp(final FenceTemp ft);
    
    void updateFenceTemp(final String workId, final String newUserId);
    
    void deleteFenceTemp(final String workId);
    
    Information selectInformation(final String workId, final String userId);
    
    void delAllFencePersonRel();
    
    List<Map> selectPeopleInSecureCircle();
    
    List<Map> selectDepartDeputyDirectorByStaffid(final String userid);
    
    List<Map> selectWorkLeader(final String workid);
    
    void updateFenceAlarmCount(final String workid);
}