query($queryKat);
while ($rowKat = $resultKat->fetch_assoc()) {
$kat_id = $rowKat['kat_id'];
$kat_sifra = $rowKat['sifra'];
$kat_naziv = $rowKat['naziv'];
$kat_aktivnost = $rowKat['aktivnost'];
$kat_permalink = $rowKat['permalink'];
$classes = "class=\"productItem " . ($activeKat == $kat_permalink ? "active" : "") . "\"";
$newKat = "";
if ($nivo < $maxNivo) {
$newKat = izpisiKategorije($mysqli, $trgovina, $kat_id, $nivo+1, $maxNivo, $activeKat);
}
$url = "/trgovina/".$kat_permalink."/";
$content .= "
".$kat_naziv."
".(strlen($newKat) > 0?"":"")."
";
}
return $content;
}
function createCrumbline($titles, $urls) {
$crumbline = ''.TXT0062.'';
$separator = '/';
if (count($titles) != count($urls) || count($urls) == 0 || count($titles) == 0) return $crumbline;
for ($i = 0; $i < count($titles); $i++) {
$crumbline = $crumbline.$separator.''.$titles[$i].'';
}
return $crumbline;
}
function displayPhoneNumbers($mysqli, $store) {
$store = $mysqli->escape_string($store);
$query = "SELECT number, type FROM shop_phones WHERE shop_id='".$store."'";
$content = "";
$result = $mysqli->query($query);
while ($row = $result->fetch_assoc()) {
$content .= "|".$row['type'].": ".$row['number'];
}
return $content;
}
$kategorija = isset($_GET["category"]) ? $_GET["category"] : -1;
$page = isset($_GET["page"]) ? $_GET["page"] : 1;
$sort_field = (isset($_GET["sort_field"]) ? $_GET["sort_field"] : "naziv");
$sort_direction = (isset($_GET["sort_direction"]) ? $_GET["sort_direction"] : "ASC");
$filter = (isset($_GET["filter"]) ? $_GET["filter"] : 'vse');
$search = (isset($_GET["search"]) ? stripcslashes($_GET["search"]) : '');
if (isset($_GET['content'])) {
if ($_GET['content'] == "cart" || $_GET['content'] == "delivery" || $_GET['content'] == "overview" ) {
$cartTitles = array();
$cartUrls = array();
switch($_GET['content']) {
case "confirmed":
array_push($cartTitles, TXT0195);
array_push($cartUrls, "/index.php?content=confirmed");
case "overview":
array_push($cartTitles, TXT0196);
array_push($cartUrls, "/index.php?content=overview");
case "delivery":
array_push($cartTitles, TXT0197);
array_push($cartUrls, "/index.php?content=delivery");
case "cart":
array_push($cartTitles, TXT0064);
array_push($cartUrls, "/index.php?content=cart");
}
$cartTitles = array_reverse($cartTitles);
$cartUrls = array_reverse($cartUrls);
$fullCrumb = createCrumbline($cartTitles, $cartUrls);
} else if ($_GET['content'] == "confirmed") {
$cartTitles = array();
$cartUrls = array();
array_push($cartTitles, TXT0195);
array_push($cartUrls, "/index.php?content=confirmed");
array_push($cartTitles, TXT0064);
array_push($cartUrls, "/index.php?content=cart");
$cartTitles = array_reverse($cartTitles);
$cartUrls = array_reverse($cartUrls);
$fullCrumb = createCrumbline($cartTitles, $cartUrls);
} else if ($_GET['content'] == "expired") {
$cartTitles = array();
$cartUrls = array();
array_push($cartTitles, TXT0198);
array_push($cartUrls, "/index.php?content=expired");
$fullCrumb = createCrumbline($cartTitles, $cartUrls);
} else if ($_GET['content'] == "profil") {
$cartTitles = array();
$cartUrls = array();
array_push($cartTitles, TXT0185);
array_push($cartUrls, "/index.php?content=profil");
$fullCrumb = createCrumbline($cartTitles, $cartUrls);
} else {
$queryContentTitle = "SELECT IFNULL(td.text, cm.title) title
FROM content_menus cm LEFT JOIN translations_data td ON (td.group_name = 'content_menus' AND td.doc_id = cm.id AND td.language_id = ".$_SESSION['languageId'].")
WHERE cm.id = ".$_GET['content'];
$resultContentTitle = $mysqli->query($queryContentTitle);
if ($resultContentTitle && $resultContentTitle->num_rows > 0) {
$rowContentTitle = $resultContentTitle->fetch_assoc();
$contentTitle = $rowContentTitle['title'];
}
}
}
if (isset($_GET['articleCategory'])) {
$cartTitles = array();
$cartUrls = array();
if (isset($_GET['article'])) {
if ($stmt = $mysqli->prepare("SELECT naziv FROM kategorije WHERE permalink = ? AND type = 'article';")) {
$stmt->bind_param('s', $_GET['articleCategory']);
if ($stmt->execute()) {
$stmt->bind_result($contentTitle);
$stmt->fetch();
}
$stmt->close();
}
$articlesTitles = array(TXT0063, $contentTitle);
$articlesUrls = array('/'.PER002.'/', '/'.PER002.'/'.$_GET['articleCategory']);
$fullCrumb = createCrumbline($articlesTitles, $articlesUrls);
} else if ($_GET['articleCategory'] != -1) {
if ($stmt = $mysqli->prepare("SELECT IFNULL(td.text,k.naziv) naziv, IFNULL(td.permalink,k.permalink), k1.naziv kat1_naziv, k1.permalink kat1_link, k2.naziv kat2_naziv, k2.permalink kat2_link, k3.naziv kat3_naziv, k3.permalink kat3_link
FROM kategorije k
LEFT JOIN translations_data td ON (td.group_name = 'kategorije' AND td.field = 'naziv' AND td.doc_id = k.kat_id AND td.language_id = ".$_SESSION['languageId'].")
LEFT JOIN kategorije k1 ON k.kat_id_nadr = k1.kat_id
LEFT JOIN kategorije k2 ON k1.kat_id_nadr = k2.kat_id
LEFT JOIN kategorije k3 ON k2.kat_id_nadr = k3.kat_id
WHERE IFNULL(td.permalink,k.permalink) = ? AND k.type = 'article';")) {
$stmt->bind_param('s', $_GET['articleCategory']);
if ($stmt->execute()) {
$stmt->bind_result($contentTitle, $contentPermalink, $parent1Title, $parent1Link, $parent2Title, $parent2Link, $parent3Title, $parent3Link);
$stmt->fetch();
}
$stmt->close();
}
$articlesTitles = array(TXT0063);
$articlesUrls = array('/'.PER002.'/');
if (strlen($parent3Title) > 0) {
array_push($articlesTitles, $parent3Title);
array_push($articlesUrls, '/'.PER002.'/'.$parent3Link);
}
if (strlen($parent2Title) > 0) {
array_push($articlesTitles, $parent2Title);
array_push($articlesUrls, '/'.PER002.'/'.$parent2Link);
}
if (strlen($parent1Title) > 0) {
array_push($articlesTitles, $parent1Title);
array_push($articlesUrls, '/'.PER002.'/'.$parent1Link);
}
array_push($articlesTitles, $contentTitle);
array_push($articlesUrls, '/'.PER002.'/'.$_GET['articleCategory']);
$fullCrumb = createCrumbline($articlesTitles, $articlesUrls);
} else {
/*$articlesTitles = array('Prispevki');
$articlesUrls = array('/prispevki/');
$fullCrumb = createCrumbline($articlesTitles, $articlesUrls);*/
echo "";
die();
}
}
if (isset($_GET['news'])) {
if ($_GET['news'] == 'arh') {
$contentTitle = TXT0055;
} else {
$queryContentTitle = "SELECT title FROM news WHERE permalink = '".$_GET['news']."' AND shop_id = '".$trgovina."'";
$resultContentTitle = $mysqli->query($queryContentTitle);
if ($resultContentTitle && $resultContentTitle->num_rows > 0) {
$rowContentTitle = $resultContentTitle->fetch_assoc();
$contentTitle = $rowContentTitle['title'];
}
}
}
/*$logoPath = "/urednik/uploads/trgovine/trg_id_".$trgovina."/logo";*/
$logoPath = "/files/".md5("trg_id_".$trgovina)."/logo";
if (file_exists($_SERVER['DOCUMENT_ROOT'].$logoPath.".jpg")) {
$logoPath .= ".jpg";
} else if ($_SERVER['DOCUMENT_ROOT'].file_exists($logoPath.".png")) {
$logoPath .= ".png";
} else {
$logoPath = "";
}
$logoWidth = $logoHeight = 0;
$logoDimensions = getimagesize($_SERVER['DOCUMENT_ROOT'].$logoPath);
if (isset($logoDimensions) && count($logoDimensions) > 0) {
$logoWidth = $logoDimensions[0];
$logoHeight = $logoDimensions[1];
}
unset($logoDimensions);
$setMargin = round(($logoHeight / 2) - 2);
?>