);
*/
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;
}
