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