项目用layui-soul-table与php搭配,需求是加入下拉菜单切换年份显示不同表格内容,切换显示数据都正常也没有报错,但就是layui-soul-table的筛选功能失效了,总是显示的是没有切换前默认的数据内容,默认数据是由后端data.php生成json,切换年份数据是前台下拉菜单把年份值传给后端select_year.php生成json数据。
#####
前台部分:
$("#searchBtn").on('click',function(){
var val = $("#year_searchReload").val();
console.log(val);
// 重载数据
table.reload('myTable', {
url: '../datatables/select_year.php'
,where: {
year:val
}
});
return false;
})
select_year.php部分:
@$year = $_GET['year'];
$sql3 = "SELECT count(*) FROM gkquery_lqk WHERE year = '$year'";
$sql = "select id,xm,year,ksh,zkzh,zxmc,pcmc,gxmc,zymc,xz,lqfsmc,zf from gkquery_lqk WHERE year = '$year' order by year LIMIT $start,$pageSize";
$result = $conn->query($sql);
@$result3 = mysqli_query($conn,$sql3);
$rows3 = mysqli_fetch_row($result3);
$rowCount = $rows3[0];
while ($row = $result->fetch_assoc()) {
$row = array(
"id" => $row['id'],
"xm" => $row['xm'],
"year" => $row['year'],
"ksh" => $row['ksh'],
"zkzh" => $row['zkzh'],
"zxmc" => $row['zxmc'],
"pcmc" => $row['pcmc'],
"gxmc" => $row['gxmc'],
"zymc" => $row['zymc'],
"xz" => $row['xz'],
"lqfsmc" => $row['lqfsmc'],
"zf" => $row['zf']
);
$array[]=$row;
$output = array("code"=> 0, "msg"=> "", "count"=>$rowCount,"data"=>$array);
}
$conn->close();
echo json_encode( $output,JSON_UNESCAPED_UNICODE );
切换年份后前台表格数据确实是切换对了,但是用筛选功能时条件里的数据却还是切换前默认的数据,二者不一致导至筛选失效。
我觉得问题应该还是后端回传数据后重载表格没有清除之前默认的数据筛选条件,但我js不熟不会写这个地方,希望指点一下。
想要结果就是切换年份后显示的数据能正常筛选。