时间的高级搜索

一，前端传参数

 /**
     * 点击查询按钮   conditionTime对象接受
     */
    JbrLogisticsLinesSiteInfo.search = function () {
        var queryData = {};
        queryData['siteName'] = $("#condition").val();
        queryData['conditionTime'] = $("#findTime").val();
        //根据roadId进行搜索查找

•         queryData['roadId'] = $("#roadName").val();

        console.log(queryData);
        table.reload(JbrLogisticsLinesSiteInfo.tableId, {
            where: queryData, page: {curr: 1}
        });
    };

二，controller解救获取数据信息！

 * 查询列表
 *
 * @soc        
 * @Date 2020-01-03    //拼接查询条件 String bTime = ""; String eTime = "";
 */
@ResponseBody
@RequestMapping("/list")
public LayuiPageInfo list(JbrLogisticsLinesSiteInfoParam jbrLogisticsLinesSiteInfoParam) {
    //拼接查询条件
    String bTime = "";
    String eTime = "";
    if (ToolUtil.isNotEmpty(jbrLogisticsLinesSiteInfoParam.getConditionTime())) {
        String[] split = jbrLogisticsLinesSiteInfoParam.getConditionTime().split(" - ");
        bTime = split[0];
        eTime = split[1];
    }
    jbrLogisticsLinesSiteInfoParam.setBTime(bTime);
    jbrLogisticsLinesSiteInfoParam.setETime(eTime);
    return this.jbrLogisticsLinesSiteInfoService.findPageBySpec(jbrLogisticsLinesSiteInfoParam);
}

 

三，业务层impl

@Override
public LayuiPageInfo findPageBySpec(JbrLogisticsLinesSiteInfoParam param){
    Page pageContext = getPageContext();
    IPage page = this.baseMapper.customPageList(pageContext, param);
    return LayuiPageFactory.createPageInfo(page);
}

四，mapper层处理

 

/**
 * 获取分页实体列表
 *
 * @author soc
 * @Date 2020-01-09
 */
Page<JbrLogisticsLinesSiteInfoResult> customPageList(@Param("page") Page page, @Param("paramCondition") JbrLogisticsLinesSiteInfoParam paramCondition);

 

五，xml的sql

<select id="customPageList" resultType="cn.stylefeng.guns.modular.operationsCenter.model.result.JbrLogisticsLinesSiteInfoResult" parameterType="cn.stylefeng.guns.modular.operationsCenter.model.params.JbrLogisticsLinesSiteInfoParam">
    select
    j.*,a.`name`  aName,b.`name`  bName,c.`name` cName,x.`r_title`  rTitle ,x.`road_num` roadNum,
    (SELECT site_name FROM jbr_logistics_lines_site_info WHERE id=j.transfer_site_id) AS transferSiteName
    from jbr_logistics_lines_site_info j
    left  join  jbr_area  a  on j.via_province_id=a.id
    left  join  jbr_area  b  on j.via_city_id=b.id
    left  join  jbr_area  c  on j.via_dis_id=c.id
    left  join  xg_road  x  on j.road_id=x.id
    where 1 = 1
    <if test="paramCondition.id != null and paramCondition.id != ''">
        and j.id like CONCAT('%',#{paramCondition.id},'%')
    </if>
    <if test="paramCondition.bTime != null and paramCondition.bTime != '' and paramCondition.eTime != null and paramCondition.eTime != ''">
        and (j.update_time between CONCAT(#{paramCondition.bTime},' 00:00:00') and CONCAT(#{paramCondition.eTime},' 23:59:59'))
    </if>
    <if test="paramCondition.roadId != null and paramCondition.roadId != ''">
        and j.road_id =#{paramCondition.roadId}
    </if>
    ORDER BY j.add_time desc
</select>

6，实体对象---添加属性字段

 //拼接查询条件
private String bTime ;
private String eTime ;

第二种方式：

实体对象增加属性字段：

   @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    private String createTimeStart;

    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    private String createTimeEnd;
 

2.1接口获取controller

实体增加对象信息

   @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    private String createTimeStart;

    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    private String createTimeEnd;

 

2.2业务层impl

/**
 * 获取所有用戶信息
 * @param search
 * @return
 */
@Override
public List<Users> seachAllUsers(UsersSearchByCondition search) {
    UsersSearchByCondition usersSearchByCondition = new UsersSearchByCondition();
    if(search.getUsername()!=null&&!"".equals(search.getUsername())){

        usersSearchByCondition.setUsername(search.getUsername());
    }
    if(search.getCreateTimeStart()!=null&&!"".equals(search.getCreateTimeStart())){

        usersSearchByCondition.setCreateTimeStart(search.getCreateTimeStart());
    }
    if(search.getCreateTimeEnd()!=null&&!"".equals(search.getCreateTimeEnd())){

        usersSearchByCondition.setCreateTimeEnd(search.getCreateTimeEnd());
    }

    List<Users> list = userDao.seachAllUsers(usersSearchByCondition);
    return list;
}

 

 

2.3sql的写法xml文件

<!--高级查询信息   create_time,token,code,iPhone,-->
<select id="seachAllUsers" resultMap="BaseResultMap"   resultType="com.thingo.whacrs.pojo.Users" parameterType="com.thingo.whacrs.pojo.UsersSearchByCondition">
    SELECT users.id,
    users.username,
    users.password,
    users.token,
    users.create_time,
    users.iPhone,
    users.userId,
    users.headpost,
    users.AppKey,
    users.AppSecret,
    users.indexCode
    FROM  users
    WHERE 1=1
    <if test="username!=null"> AND username LIKE concat('%',#{username},'%')</if>
    <if test="createTimeStart != null or createTimeEnd != null">
        AND DATE_FORMAT(users.create_time,'%Y-%m-%d')&gt;=DATE_FORMAT(#{createTimeStart},'%Y-%m-%d')
        AND DATE_FORMAT(users.create_time,'%Y-%m-%d')&lt;=DATE_FORMAT(#{createTimeEnd},'%Y-%m-%d')
    </if>
</select>