漏刻有时php集合layui动态表格翻页和搜索的代码分析

    @$branch_id = get_param('branch_id');
    if ($branch_id == "") {
      $branch_id = $_COOKIE["branch_id"];
    }
    @$major_id = explode(',', get_param('major_name'))[0];
    @$pool_able = $_GET['pool_able'];
    if ($pool_able == ""){
        $pool_able='0';
    }
    @$keys = get_param('keys');
    $page    = get_param('page');
    $page    = intval($page) == 0 ? 1 : intval($page);
    $pagenum = 30;
    $startI  = $page * $pagenum - $pagenum;
  //获取总记录;
  $sql_c = "select a.pool_id,a.member_id,a.branch_id,a.major_id,a.pool_address,a.pool_mask,a.pool_gateway,a.pool_able,b.major_id,b.major_name from " . $db->table('pool') . " AS a," . $db->table('category') . " AS b WHERE 1";
    $sql_c .= " AND a.major_id = b.major_id AND a.branch_id =" . $branch_id;
    if ($major_id != "") {
      $sql_c .= " AND a.major_id =" . $major_id;
    }
    if ($keys != "") {
      $sql_c .= " AND a.pool_address like '%" . $keys . "%'";
    }
    if ($pool_able != "") {
      $sql_c .= " AND a.pool_able =" . $pool_able;
    }
    $sql_c .= " ORDER BY a.pool_id ASC";
    $row_c = $db->queryall($sql);
    $count   = count($row_c);
    $pages   = getPages($count, $page, $pagenum);
    $sql = "select a.pool_id,a.member_id,a.branch_id,a.major_id,a.pool_address,a.pool_mask,a.pool_gateway,a.pool_able,b.major_id,b.major_name from " . $db->table('pool') . " AS a," . $db->table('category') . " AS b WHERE 1";
    $sql .= " AND a.major_id = b.major_id AND a.branch_id =" . $branch_id;
    if ($major_id != "") {
      $sql .= " AND a.major_id =" . $major_id;
    }
    if ($keys != "") {
      $sql .= " AND a.pool_address like '%" . $keys . "%'";
    }
    if ($pool_able != "") {
      $sql .= " AND a.pool_able =" . $pool_able;
    }
    $sql .= " ORDER BY a.pool_id ASC LIMIT " . $startI . ',' . $pagenumt;
    $row = $db->queryall($sql);