一,前端传参数
/**
* 点击查询按钮 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')>=DATE_FORMAT(#{createTimeStart},'%Y-%m-%d')
AND DATE_FORMAT(users.create_time,'%Y-%m-%d')<=DATE_FORMAT(#{createTimeEnd},'%Y-%m-%d')
</if>
</select>