); */ if (isAdmin()) { $parent = ''; } elseif (isManager() or isGridManager()) { $parent = 'AND needy.user_parent = ' . CUSER; /*elseif(isGridManager()) : $children = array(); foreach(listData('users', 'user_acctype = 1 AND user_active = 1 AND user_parent = '.CUSER) as $child) $children[] = 'needy.user_parent = '.$child['user_id']; $parent = 'AND (('.implode(' OR ', $children).') OR needy.user_parent_ta = '.CUSER.')';*/ } getSort('need_id'); $where = 'SELECT need_id, need_name, cat_name, user_fname, user_lname, user_orgname, need_expires, need_desc, need_regdate, a.deleted AS deleted FROM (SELECT need_id, need_name, cat_name, need_type, need_needy, need_expires, need_desc, need_regdate, needs.deleted AS deleted FROM needs LEFT JOIN cats ON needs.need_cat = cats.cat_id WHERE needs.need_type=' . subpage() . ' AND needs.need_full=0) a LEFT JOIN needy ON a.need_needy = needy.user_id WHERE a.need_type=' . subpage() . ' ' . $parent . ' ORDER BY ' . $getsort . $getorder; /* $sortby = array(0 => 'need_id', 1 => 'need_name', 2 => 'cat_name', 3 => 'user_fname', 4 => 'user_lname', 5 => 'user_orgname', 6 => 'need_regdate');*/ formatTable(listData(false, false, pageNum(), $where), $tablefields, $tablehead, $sortby, true, 'nomargin'); pagination(countData(false, false, $where)); $poreikis = array(1 => 'darbo', 2 => 'daikto'); ?> <br><br> <a href="?p=editneed&type=<?php echo subpage(); ?> &subp=<?php echo subpage(); ?> "><i class="fa fa-asterisk"></i> Sukurti <?php echo $poreikis[subpage()]; ?> poreikį</a>
function page_navigation($range = 10) { global $paged, $wp_query; $range = ceil($range / 2) * 2; if (!$max_page) { $max_page = $wp_query->max_num_pages; } if ($max_page > 1) { if (!$paged) { $paged = 1; } function pageNum($range, $max_page, $paged) { if ($max_page > $range) { if ($paged < $range) { for ($i = 1; $i <= $range; $i++) { $page_num[$i] = $i; } } elseif ($paged >= $max_page - $range / 2) { for ($i = $max_page - $range + 1; $i <= $max_page; $i++) { $page_num[$i] = $i; } } elseif ($paged >= $range && $paged < $max_page - $range / 2) { for ($i = $paged - $range / 2 + 1; $i <= $paged + $range / 2; $i++) { $page_num[$i] = $i; } } } else { for ($i = 1; $i <= $max_page; $i++) { $page_num[$i] = $i; } } return $page_num; } $page_num = pageNum($range, $max_page, $paged); echo '<div class="page-nav"><span class="total-page">' . sprintf(__('共有%s页', 'enterprise-themes'), $max_page) . '</span>'; if ($paged != 1) { echo '<a href="' . get_pagenum_link(1) . '" class="first-page">' . __('首页', 'enterprise-themes') . '</a>'; } previous_posts_link(__('上一页', 'enterprise-themes')); foreach ($page_num as $num) { echo '<a href="' . get_pagenum_link($num) . '"'; if ($num == $paged) { echo ' class="current-page"'; } echo '>' . $num . '</a>'; } next_posts_link(__('下一页', 'enterprise-themes')); if ($paged != $max_page) { echo '<a href="' . get_pagenum_link($max_page) . '" class="last-page">' . __('末页', 'enterprise-themes') . '</a>'; } echo '</div>'; } }
} ?> </select> <input class="search" type="text" name="s" value="<?php echo isset($_GET['s']) ? $_GET['s'] : ''; ?> " /> <input type="submit" value="Rodyti" /> </form> <ul class="poreikiailist"> <?php $where = "SELECT need_id, need_name, cat_name, cat_id, user_city, need_regdate, a.deleted AS deleted FROM (SELECT need_id, need_name, cat_name, cat_id, need_type, need_needy, need_regdate, needs.deleted AS deleted FROM needs INNER JOIN cats ON needs.need_cat = cats.cat_id WHERE needs.need_type = {$fbsite} AND needs.need_full=0 AND needs.need_expires > NOW() AND needs.deleted = 0 {$filterCat}) a INNER JOIN needy ON a.need_needy = needy.user_id WHERE a.need_type = {$fbsite} {$filterCity} {$filterStok} {$srch} ORDER BY need_id DESC"; $c = 0; if (pageNum() != 0) { foreach (listData(false, false, pageNum(), $where, 15) as $pdata) { echo '<li>'; echo '<a href="/poreikiai/id/' . $pdata['need_id'] . '">'; echo '<div class="icon" style="background-image: url(/img/c' . $pdata['cat_id'] . '.png);"></div>'; echo '<div class="name">' . $pdata['need_name'] . '</div>'; echo '<div class="city">' . $citiesList[$pdata['user_city']] . '</div>'; echo '</a>'; echo '</li>'; $c++; } } if ($c == 0) { err('Nerastas nė vienas poreikis'); } ?> </ul>
<?php $page_id = isset($_GET['blogid']) ? $_GET['blogid'] : false; $page_site = 1; if ($page_id) { $pagerow = getRow('pages', "page_id = {$page_id} AND (page_site = {$page_site} OR page_site = 2) AND deleted = 0 AND page_published < NOW()"); if (!$pagerow) { err('Naujiena neegzistuoja'); return; } } else { $where = "SELECT * FROM pages WHERE page_type = 1 AND (page_site = {$page_site} OR page_site = 2) AND deleted = 0 AND page_published < NOW() ORDER BY page_published DESC"; echo '<ul>'; foreach (listData(false, false, pageNum(), $where) as $key => $data) { echo '<li><a href="/naujienos/' . $data['page_id'] . '">' . $data['page_name'] . '</a></li>'; } echo '</ul>'; pagination2(countData(false, false, $where), 10, 'naujienos/psl'); return; } if ($pagerow) { echo '<h2>' . $pagerow['page_name'] . '</h2>'; echo $pagerow['page_content']; }
function pagination($count, $perpage = 10) { if (isset($_GET['pp']) and $_GET['pp'] > 10 and $_GET['pp'] <= 1000) { $perpage = (int) $_GET['pp']; } if ($count > $perpage) { if (isset($_POST['smsearch']) or isset($_GET['s'])) { $getsm = '&s=' . (!empty($_POST['smsearch']) ? $_POST['smsearch'] : (!empty($_GET['s']) ? $_GET['s'] : NULL)); } else { $getsm = ''; } $pages = ceil($count / $perpage); $adj = 3; $pbl = $pages - 1; $parameters = preg_replace("/([?&])page=\\w+(&|\$)/", "\$2", $_SERVER['QUERY_STRING']); $parameters = preg_replace('/([?&])s=[^&]+(&|$)/', '$2', $parameters); $parp = isset($_GET['p']) ? '<input type="hidden" name="p" value="' . $_GET['p'] . '">' : ''; $parsubp = isset($_GET['subp']) ? '<input type="hidden" name="subp" value="' . $_GET['subp'] . '">' : ''; $parsrch = isset($_GET['srch']) ? '<input type="hidden" name="srch" value="' . $_GET['srch'] . '">' : ''; $parrikiuoti = isset($_GET['rikiuoti']) ? '<input type="hidden" name="rikiuoti" value="' . $_GET['rikiuoti'] . '">' : ''; $partvarka = isset($_GET['tvarka']) ? '<input type="hidden" name="tvarka" value="' . $_GET['tvarka'] . '">' : ''; $ppops = array(10, 20, 50, 100, 200, 500, 1000, 2000); $ppoptions = ''; foreach ($ppops as $ppop) { $ppoptions .= '<option ' . ((isset($_GET['pp']) and $_GET['pp'] == $ppop) ? 'selected="selected"' : '') . ' value=' . $ppop . '>' . $ppop . '</option>'; } $pag = '<div class="pagination-div">Puslapis <i><strong>' . pageNum() . '</strong></i> iš <i>' . $pages . '</i>, rodoma po <form class="inline" action="" method="GET">' . $parp . $parsubp . $parsrch . $parrikiuoti . $partvarka . '<select style="width: 65px;" name="pp">' . $ppoptions . '</select> <input type="submit" value="Pakeisti" /></form> </div>'; $pag .= '<ul class="pagination">'; if ($pages < 7 + $adj * 2) { for ($i = 1; $i <= $pages; $i++) { if ($i == pageNum()) { $class = ' class="current" '; } else { $class = ''; } $pag .= '<li ' . $class . ' style="margin: 5px 2px;"><a href="/index.php?' . $parameters . $getsm . '&page=' . $i . '">' . $i . '</a></li>'; } } else { if ($pages > 5 + $adj * 2) { if (pageNum() < 1 + $adj * 2) { for ($i = 1; $i < 4 + $adj * 2; $i++) { if ($i == pageNum()) { $class = ' class="current" '; } else { $class = ''; } $pag .= '<li ' . $class . ' style="margin: 5px 2px;"><a href="/index.php?' . $parameters . $getsm . '&page=' . $i . '">' . $i . '</a></li>'; } $pag .= '<li style="margin: 5px 2px;" class="dots"><a>...</a></li>'; $pag .= '<li style="margin: 5px 2px;"><a href="/index.php?' . $parameters . $getsm . '&page=' . $pbl . '">' . $pbl . '</a></li>'; $pag .= '<li style="margin: 5px 2px;"><a href="/index.php?' . $parameters . $getsm . '&page=' . $pages . '">' . $pages . '</a></li>'; } else { if ($pages - $adj * 2 > pageNum() && pageNum() > $adj * 2) { $pag .= '<li style="margin: 5px 2px;"><a href="/index.php?' . $parameters . $getsm . '&page=1">1</a></li>'; $pag .= '<li style="margin: 5px 2px;"><a href="/index.php?' . $parameters . $getsm . '&page=2">2</a></li>'; $pag .= '<li style="margin: 5px 2px;" class="dots"><a>...</a></li>'; for ($i = pageNum() - $adj; $i <= pageNum() + $adj; $i++) { if ($i == pageNum()) { $class = ' class="current" '; } else { $class = ''; } $pag .= '<li ' . $class . ' style="margin: 5px 2px;"><a href="/index.php?' . $parameters . $getsm . '&page=' . $i . '">' . $i . '</a></li>'; } $pag .= '<li style="margin: 5px 2px;" class="dots"><a>...</a></li>'; $pag .= '<li style="margin: 5px 2px;"><a href="/index.php?' . $parameters . $getsm . '&page=' . $pbl . '">' . $pbl . '</a></li>'; $pag .= '<li style="margin: 5px 2px;"><a href="/index.php?' . $parameters . $getsm . '&page=' . $pages . '">' . $pages . '</a></li>'; } else { $pag .= '<li style="margin: 5px 2px;"><a href="/index.php?' . $parameters . $getsm . '&page=1">1</a></li>'; $pag .= '<li style="margin: 5px 2px;"><a href="/index.php?' . $parameters . $getsm . '&page=2">2</a></li>'; $pag .= '<li style="margin: 5px 2px;" class="dots"><a>...</a></li>'; for ($i = $pages - (2 + $adj * 2); $i <= $pages; $i++) { if ($i == pageNum()) { $class = ' class="current" '; } else { $class = ''; } $pag .= '<li ' . $class . ' style="margin: 5px 2px;"><a href="/index.php?' . $parameters . $getsm . '&page=' . $i . '">' . $i . '</a></li>'; } } } } } $pag .= '</ul>'; echo $pag; } return false; }
function pagination2($count, $perpage = 10, $rew) { if ($count > $perpage) { if (isset($_POST['smsearch']) or isset($_GET['s'])) { $getsm = '&s=' . (!empty($_POST['smsearch']) ? $_POST['smsearch'] : (!empty($_GET['s']) ? $_GET['s'] : NULL)); } else { $getsm = ''; } $pages = ceil($count / $perpage); $adj = 3; $pbl = $pages - 1; $pag = '<div class="pagination-div">Puslapis <i><strong>' . pageNum() . '</strong></i> iš <i>' . $pages . '</i></div>'; $pag .= '<ul class="pagination">'; $parameters = preg_replace("/([?&])page=\\w+(&|\$)/", "\$2", $_SERVER['QUERY_STRING']); $parameters = preg_replace('/([?&])s=[^&]+(&|$)/', '$2', $parameters); if ($pages < 7 + $adj * 2) { for ($i = 1; $i <= $pages; $i++) { if ($i == pageNum()) { $class = ' class="current" '; } else { $class = ''; } $pag .= '<li ' . $class . ' style="margin: 5px 2px;"><a href="/' . $rew . '/' . $i . '">' . $i . '</a></li>'; } } else { if ($pages > 5 + $adj * 2) { if (pageNum() < 1 + $adj * 2) { for ($i = 1; $i < 4 + $adj * 2; $i++) { if ($i == pageNum()) { $class = ' class="current" '; } else { $class = ''; } $pag .= '<li ' . $class . ' style="margin: 5px 2px;"><a href="/' . $rew . '/' . $i . '">' . $i . '</a></li>'; } $pag .= '<li style="margin: 5px 2px;" class="dots"><a>...</a></li>'; $pag .= '<li style="margin: 5px 2px;"><a href="/' . $rew . '/' . $pbl . '">' . $pbl . '</a></li>'; $pag .= '<li style="margin: 5px 2px;"><a href="/' . $rew . '/' . $pages . '">' . $pages . '</a></li>'; } else { if ($pages - $adj * 2 > pageNum() && pageNum() > $adj * 2) { $pag .= '<li style="margin: 5px 2px;"><a href="/' . $rew . '/1">1</a></li>'; $pag .= '<li style="margin: 5px 2px;"><a href="/' . $rew . '/2">2</a></li>'; $pag .= '<li style="margin: 5px 2px;" class="dots"><a>...</a></li>'; for ($i = pageNum() - $adj; $i <= pageNum() + $adj; $i++) { if ($i == pageNum()) { $class = ' class="current" '; } else { $class = ''; } $pag .= '<li ' . $class . ' style="margin: 5px 2px;"><a href="/' . $rew . '/' . $i . '">' . $i . '</a></li>'; } $pag .= '<li style="margin: 5px 2px;" class="dots"><a>...</a></li>'; $pag .= '<li style="margin: 5px 2px;"><a href="/' . $rew . '/' . $pbl . '">' . $pbl . '</a></li>'; $pag .= '<li style="margin: 5px 2px;"><a href="/' . $rew . '/' . $pages . '">' . $pages . '</a></li>'; } else { $pag .= '<li style="margin: 5px 2px;"><a href="/' . $rew . '/1">1</a></li>'; $pag .= '<li style="margin: 5px 2px;"><a href="/' . $rew . '/2">2</a></li>'; $pag .= '<li style="margin: 5px 2px;" class="dots"><a>...</a></li>'; for ($i = $pages - (2 + $adj * 2); $i <= $pages; $i++) { if ($i == pageNum()) { $class = ' class="current" '; } else { $class = ''; } $pag .= '<li ' . $class . ' style="margin: 5px 2px;"><a href="/' . $rew . '/' . $i . '">' . $i . '</a></li>'; } } } } } $pag .= '</ul>'; echo $pag; } return false; }