{source 0}
getQuery(true);
$pageLimit = 20;
error_reporting(E_ALL);
try{
$pp = isset($_GET["pp"]) ? ((int)$_GET["pp"] * $pageLimit) : 0;
}catch(Exception $e){
echo $e->getMessage();
}
$query -> select(" * ");
$query -> from ("#__k2_items");
$query -> innerJoin("javna_nabava_addon ON javna_nabava_addon.itemid = #__k2_items.id");
$query -> where(" `catid` = 21 and `published` = 1 and `trash` = 0 ");
$query -> order("publish_up DESC");
$query -> setLimit($pageLimit,$pp);
$db -> setQuery( (string) $query );
$rows = $db -> loadAssocList();
$query = $db->getQuery(true);
$query -> select("COUNT(*)");
$query -> from ("#__k2_items");
$query -> innerJoin("javna_nabava_addon ON javna_nabava_addon.itemid = #__k2_items.id");
$query -> where(" `catid` = 3");
$db -> setQuery( (string) $query );
$count = $db -> loadAssocList()[0]["COUNT(*)"];
$pgs = ceil($count / $pageLimit);
$cpg = floor($pp / $pageLimit);
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;
}
}
?>
" rel="stylesheet" />
{/source}
Naziv
Datum početka
Datum završetka
Status postupka
format('d.m.Y');
?>
format('d.m.Y');
?>
toUnix() < JFactory::getDate() -> toUnix()){
?>ZavršenPonovljenU tijeku
Dokumenti za preuzimanje:
-
getQuery(true);
$query -> select(" * ");
$query -> from ("#__k2_attachments");
$query -> where(" itemID = ".$row["itemid"]);
$query -> order("id ASC");
$db -> setQuery( (string) $query );
$attach = $db -> loadAssocList();
foreach($attach as $at){
$url = JURI::root() . 'media/k2/attachments/' .$at["filename"] ;
?>
- ">
5 ? (5 + $cpg) : $pgs;
for($i = max(0,$cpg - 5) ; $i < $morePgs;$i++){
if(isset($_GET["pp"])){
$act_link = removeQueryParam($act_link,"pp");
unset($_GET["pp"]);
}
$query = parse_url($act_link, PHP_URL_QUERY);
if ($query) {
$url = $act_link . '&pp=' . $i;
} else {
$url = $act_link . '?pp=' . $i;
}
?>
">