Zatvoreni natječaji

getQuery(true); $pageLimit = 10; $pp = isset($_GET["pp"]) ? ((int)$_GET["pp"] * $pageLimit) : 0; $query -> select(" nol2.datum_pocetka as datum_pocetka , nol2.datum_zavrsetka as datum_zavrsetka, a.title as title,a1.filename as filename, b.title as odluka_title, b1.filename as odluka_filename"); $query -> from ("#__k2_items AS a"); $query -> innerJoin("#__natjecaji_odluke_linkovi as nol2 ON nol2.natjecaj_id = a.id"); $query -> innerJoin("#__k2_attachments AS a1 ON a1.itemID = a.id"); $query -> innerJoin("#__k2_items AS b ON b.id = nol2.odluka_id"); $query -> innerJoin("#__k2_attachments AS b1 ON b1.itemID = b.id"); $query -> where(" a.catid = 2 AND (SELECT COUNT(*) FROM #__natjecaji_odluke_linkovi as nol WHERE nol.natjecaj_id = a.id) > 0"); $query -> order("datum_zavrsetka DESC"); $query -> setLimit($pageLimit,$pp); $db -> setQuery( (string) $query ); $rows = $db -> loadAssocList(); $query = $db->getQuery(true); $query -> select("COUNT(*)"); $query -> from ("#__k2_items as a"); $query -> innerJoin("#__natjecaji_odluke_linkovi as nol ON nol.natjecaj_id = a.id"); $query -> innerJoin("#__k2_attachments ON #__k2_attachments.itemID = a.id"); $query -> where(" `catid` = 2 AND (SELECT COUNT(*) FROM #__natjecaji_odluke_linkovi AS nol2 WHERE nol2.natjecaj_id = a.id) > 0"); $db -> setQuery( (string) $query ); $count = $db -> loadAssocList()[0]["COUNT(*)"]; $pgs = ceil($count / $pageLimit); $cpg = floor($pp / $pageLimit); $actual_link = JURI::base(); function unparse_url($parsed_url) { $scheme = isset($parsed_url['scheme']) ? $parsed_url['scheme'] . '://' : ''; $host = isset($parsed_url['host']) ? $parsed_url['host'] : ''; $port = isset($parsed_url['port']) ? ':' . $parsed_url['port'] : ''; $user = isset($parsed_url['user']) ? $parsed_url['user'] : ''; $pass = isset($parsed_url['pass']) ? ':' . $parsed_url['pass'] : ''; $pass = ($user || $pass) ? "$pass@" : ''; $path = isset($parsed_url['path']) ? $parsed_url['path'] : ''; $query = isset($parsed_url['query']) ? '?' . $parsed_url['query'] : ''; $fragment = isset($parsed_url['fragment']) ? '#' . $parsed_url['fragment'] : ''; return "$scheme$user$pass$host$port$path$query$fragment"; } function removeQueryParam($url, $param_to_remove) { $parsed = parse_url($url); if ($parsed && isset($parsed['query'])) { $parsed['query'] = implode('&', array_filter(explode('&', $parsed['query']), function($param) use ($param_to_remove) { return explode('=', $param)[0] !== $param_to_remove; })); if ($parsed['query'] === '') unset($parsed['query']); return unparse_url($parsed); } else { return $url; } } ?>