var pageSize = 5;//生产部--开始
functionajaxPageFactory() {var total =getAjaxPageTotalFactory();
$("#Pagination").pagination(total, {
callback: handlePaginationClickFactory,
prev_text:'上一页', //“前一页”分页按钮上显示的文字 字符串参数,可选,默认是"Prev"
next_text: '下一页', //“下一页”分页按钮上显示的文字 字符串参数,可选,默认是"Next"
items_per_page: pageSize,//每页显示的条目数 可选参数,默认是10
num_display_entries: 3, //连续分页主体部分显示的分页条目数 可选参数,默认是10
num_edge_entries: 1 //两侧显示的首尾分页的条目数 可选参数,默认是0
});
}functionhandlePaginationClickFactory(new_page_index, pagination_container) {var sFactoryName = $('#sFactoryName').val();var conName = $('#sConName').val();
$.ajax({
type:"post",
url:"/notice/send/ajaxFactoryPage",
data: {
pageNumber: (new_page_index * pageSize), //页码偏移量
pageSize: pageSize, //每页容量
factoryName: sFactoryName,
conName: conName
},
async:false,
dataType:"json",
success:function(ObjData) {var lists =ObjData.records;var checkes = "";
$("#pagination-data-factory").empty();for (var i = 0; i < lists.length; i++) {
checkes+= '
'checkes+= '';checkes+= '
' + lists[i].factoryName + '';checkes+= '
' + lists[i].province + lists[i].city + lists[i].country + '';checkes+= '
' + lists[i].addr + '';checkes+= '
' + lists[i].conName + '';checkes+= '
'}$('#pagination-data-factory').html(checkes);
}
})return false;
}functiongetAjaxPageTotalFactory() {varre_total;var sFactoryName = $('#sFactoryName').val();var conName = $('#sConName').val();
$.ajax({
type:"post",
url:"/notice/send/ajaxFactoryPage",
data: {
pageNumber: 0, //页码偏移量
pageSize: pageSize, //每页容量
factoryName: sFactoryName,
conName: conName
},
async:false,
dataType:"json",
success:function(ObjData) {
re_total=ObjData.total;
}
})returnre_total;
}functiongetFactory() {
$("#detailModelTwo").modal('show');
ajaxPageFactory();
}functionsearchAjaxFactory() {
ajaxPageFactory();
}functionquedingFactory() {var factoryId = "";var factoryName = "";
$("#pagination-data-factory").find('input[type="checkbox"][name="check_info"]:checked').each(function(i) {var checked_info_id = $(this).val();var factoryNameTemp = this.parentNode.nextSibling.innerHTML;
factoryId+= checked_info_id + ",";
factoryName+= factoryNameTemp + ",";
});
$('#factoryName').val(factoryName);
$('#factoryId').val(factoryId);
$("#detailModelTwo").modal('hide');
}//生产部--结束
SELECT
info.id AS 'id' ,
info.name AS 'name',
info.type AS 'type',
info.account_holder AS 'holder' ,
info.account_bank AS 'bank',
info.account AS 'nativePlace'
FROM account_info info
where 1=1 and info.del_flag =0
and info.type in ('1','2','3')
and info.name like concat('%',#{accountName},'%')
order by info.name
LIMIT #{pageNumber},#{pageSize}
SELECT
count(0) as total
FROM account_info info
where 1=1 and info.del_flag =0
and info.type in ('1','2','3')
and info.name like concat('%',#{accountName},'%')
order by info.name
@RequestMapping(value = "searchAccountList")
@ResponseBody
public Map searchAccountList(HttpServletRequest request, int pageNumber, int pageSize, String accountName, Model model) {
Map returnMap = new HashMap();
// String accountName = request.getParameter("accountName");
List> viewList = accountInfoService.searchModelAccountList(pageNumber, pageSize, accountName);
int total = accountInfoService.searchModelAccountListCount(accountName);
returnMap.put("accountList", viewList);
returnMap.put("accountListTotal", total);
return returnMap;
}