<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.api.systemDataBigScreen.dao.LilinDataPushDao">

    <select id="findClientSecretByClientId" parameterType="java.lang.String" resultType="java.lang.String">
        select client_secret from lilin_attestation
        where client_id = #{clientId}
    </select>

    <insert id="pushAccessControlRecord" parameterType="com.api.model.systemDataBigScreen.LilinAccessControlRecord">
        insert into lilin_access_control_record(
            neigh_no,
            card_type,
            card_no,
            use_type,
            device_no,
            head_no,
            is_unlock,
            event_time,
            event_id,
            account_id
        )values (
            #{neighNo},
            #{cardType},
            #{cardNo},
            #{useType},
            #{deviceNo},
            #{headNo},
            #{isUnlock},
            #{eventTime},
            #{eventId},
            #{accountId}
        )
    </insert>

</mapper>