package com.ltkj.tduck.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler;
import com.ltkj.tduck.domain.UserFormDataEntity;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 表单表单数据(FormResult)表数据库访问层
 *
 * @author smalljop
 * @since 2020-11-23 14:09:21
 */
public interface UserFormDataMapper extends BaseMapper<UserFormDataEntity> {

    /**
     * 查询表单字段值是否存在
     * @param formKey 表单key
     * @param field 字段
     * @param value 值
     * @return 是否存在
     */
    @Select("SELECT COUNT(id) FROM fm_user_form_data WHERE form_key = #{formKey} AND JSON_EXTRACT(original_data, '$.\"${field}\"') = #{value}")
    Long selectOriginalDataValueCount(@Param("formKey") String formKey, @Param("field") String field, @Param("value") Object value);


    /**
     * 查询表单数据
     * @param sql sql
     * @return
     */
    @Results(id="queryRowsResultMap",
            value = {
                    @Result(property = "originalData", column = "original_data",typeHandler = JacksonTypeHandler.class),
                    @Result(property = "wxUserInfo", column = "wx_user_info",typeHandler = JacksonTypeHandler.class)})
    @Select("${sql}")
    List<UserFormDataEntity> selectRowsBySql(@Param("sql") String sql);


    /**
     * 查询表单数据条数
     * @param sql
     * @return
     */
    @Select("${sql}")
    Long selectCountBySql(@Param("sql") String sql);

}