if(!$orderby) $orderby = "priority";
if($desc) $orderby_query .= $orderby." DESC";
else $orderby_query .= $orderby." ASC";
function get_category($id_product_category) {
global $conn_local, $level, $before, $record_company, $url, $name, $last_id, $id_company;
$query_product_category = MySQL_Query("SELECT * FROM product_category WHERE id_company = '".$id_company."' AND id_product_category = '".$id_product_category."' AND machine_name = '".$url[$level+1]."' AND hidden = '0'", $conn_local);
while($record_product_category = mysql_fetch_array($query_product_category)) {
$name = $record_product_category[name];
$last_id = $record_product_category[id_product_category_sub];
$level++;
get_category($record_product_category[id_product_category_sub]);
$level--;
}
}
$level = 0;
get_category($id_cat_show);
$id_list = "id_product_category_sub = '".$last_id."'";
function get_id($id_product_category) {
global $conn_local, $level, $before, $record_company, $url, $name, $id_list, $id_company, $conn_local;
$query_product_category = MySQL_Query("SELECT * FROM product_category WHERE id_company = '".$id_company."' AND id_product_category = '".$id_product_category."' AND hidden = '0'", $conn_local);
while($record_product_category = mysql_fetch_array($query_product_category)) {
$id_list .= " OR id_product_category_sub = '".$record_product_category[id_product_category_sub]."'";
$level++;
get_id($record_product_category[id_product_category_sub]);
$level--;
}
}
if($last_id) get_id($last_id);
if(!$last_id) $id_list = 0;
$id_list = "(".$id_list.") AND hidden = '0' ";
if($store) {
// filter podla stavu skladu
if($record_web[store_id_company_branch]) {
if($record_web[store_id_company_branch] == -1) {
// len centralna pobocky
$id_list .= " AND (pieces > 0 OR storing = 0) ";
}
else {
// len ina ako centralna
$id_list .= " AND (((SELECT sum(pieces) FROM company_branch_store WHERE id_company_branch = '".$record_web[store_id_company_branch]."' AND id_product = p.id_product) - (SELECT sum(pieces) FROM product_reservation WHERE id_company_branch = '".$record_web[store_id_company_branch]."' AND id_product = p.id_product)) > 0 OR storing = 0) ";
}
}
else {
// vsetky poobcky
$id_list .= " AND (((p.pieces + if((SELECT sum(pieces) FROM company_branch_store WHERE id_product = p.id_product) != 0, (SELECT sum(pieces) FROM company_branch_store WHERE id_product = p.id_product), 0)) - IF((SELECT sum(pieces) FROM product_reservation WHERE id_product = p.id_product) != 0, (SELECT sum(pieces) FROM product_reservation WHERE id_product = p.id_product), 0)) > 0 OR storing = 0) ";
}
}
if(!$product) {
if(!$page) $page = 1;
$nastr = $record_web[products_per_page];
$start = ($page-1)*$nastr;
if(!$search_string) $query_product = MySQL_Query("SELECT count(*) pocet FROM product p WHERE ".$id_list." ORDER BY name", $conn_local);
if($search_string) $query_product = MySQL_Query("SELECT count(*) pocet FROM product p WHERE MATCH(name, note, part_number) AGAINST('".$search_string."' IN BOOLEAN MODE) OR id_product = '".str_replace("*", "", str_replace("+", "", str_replace("%20", " ", $search_string)))."'", $conn_local);
$record_product = mysql_fetch_array($query_product);
$spolu = $record_product[pocet];
/*
if($spolu) {
echo "
".popisok("zoradit-podla-ceny")."
";
echo "
".popisok("zoradit-podla-nazvu")."
";
if($store) echo "
";
else echo "
";
echo popisok("len-skladom")." ";
}
*/
$stran = (floor($spolu/$nastr)+1);
if(floor($spolu/$nastr) == $spolu/$nastr) $stran--;
if($stran > 1) {
echo "
";
for($i=1;$i<=$stran;$i++) {
$show_this = 1;
if($stran > 20) {
$show_this = 0;
if($i<=5) $show_this = 1;
if(($i+5)>$stran) $show_this = 1;
if(($i-3)<=$page && ($i+3)>=$page) $show_this = 1;
}
if(!$show_this && !$boldotdotdot) {
echo " ... ";
$boldotdotdot = 1;
}
if($show_this) {
if($i != $page) echo "
";
echo $i;
if($i != $page) echo "";
echo " ";
$boldotdotdot = 0;
}
}
echo "
";
}
$je_aspon_jeden = 0;
if(!$search_string) $query_product = MySQL_Query("SELECT * FROM product p WHERE ".$id_list." ORDER BY ".$orderby_query." LIMIT ".$start.", ".$nastr."", $conn_local);
if($search_string) $query_product = MySQL_Query("SELECT *, MATCH(name, note, part_number) AGAINST('".$search_string."' IN BOOLEAN MODE) as score FROM product p WHERE MATCH(name, note, part_number) AGAINST('".$search_string."' IN BOOLEAN MODE) OR id_product = '".str_replace("*", "", str_replace("+", "", str_replace("%20", " ", $search_string)))."' ORDER BY ".$orderby_query." LIMIT ".$start.", ".$nastr."", $conn_local);
while($record_product = mysql_fetch_array($query_product)) {
$je_aspon_jeden = 1;
}
$was_product = 0;
$kolko = 0;
if($je_aspon_jeden) {
echo "
";
if(!$search_string) $query_product = MySQL_Query("SELECT * FROM product p WHERE ".$id_list." ORDER BY ".$orderby_query." LIMIT ".$start.", ".$nastr."", $conn_local);
if($search_string) $query_product = MySQL_Query("SELECT *, MATCH(name, note, part_number) AGAINST('".$search_string."' IN BOOLEAN MODE) as score FROM product p WHERE MATCH(name, note, part_number) AGAINST('".$search_string."' IN BOOLEAN MODE) OR id_product = '".str_replace("*", "", str_replace("+", "", str_replace("%20", " ", $search_string)))."' ORDER BY ".$orderby_query." LIMIT ".$start.", ".$nastr."", $conn_local);
while($record_product = mysql_fetch_array($query_product)) {
$kolko++;
$was_product = 1;
echo "
";
$was = 0;
$query_product_file = MySQL_Query("SELECT * FROM product_file WHERE id_product = '".$record_product[id_product]."' LIMIT 1", $conn_local);
while($record_product_file = mysql_fetch_array($query_product_file)) {
$was = 1;
echo "";
}
echo " |
";
echo $record_product[name];
echo "
";
if($url[1] == "mangalicovy-program") {
if(fmod($kolko, 3) == 0) {
echo "
";
}
}
}
echo "
";
}
$content_found = 1;
//if(!$was_product) if($last_id) echo popisok("v-kategorii-sa-nenachadza-ziadny-produkt");
if($stran > 1) {
echo "
";
for($i=1;$i<=$stran;$i++) {
$show_this = 1;
if($stran > 20) {
$show_this = 0;
if($i<=5) $show_this = 1;
if(($i+5)>$stran) $show_this = 1;
if(($i-3)<=$page && ($i+3)>=$page) $show_this = 1;
}
if(!$show_this && !$boldotdotdot) {
echo " ... ";
$boldotdotdot = 1;
}
if($show_this) {
if($i != $page) echo "
";
echo $i;
if($i != $page) echo "";
echo " ";
$boldotdotdot = 0;
}
}
echo "
";
}
}
?>
Poličan saláma >< Pekelne pálivá salámaPišta klobása
Pišta klobása- trvanlivý tepelne neopracovaný mäsový výrobok
Zloženie: bravčové mäso 86%, hovädzie mäso 9%, voda, dusitanova soliaca zmes / soľ, konzervačná látka E 250, protihrudkujúca látka E535/ soľ max. 4,1% ,koreniny a extrakty korenín , dextróza , zvýrazňovače chuti E 621, E 635, antioxidant E 300, farbivo E 120, čerstvý cesnak.
Vhodné pre celiatikov- pre bezlepkovú diétu
Skladovať pri teplote od 2°C do 20 °C . Po narušení obalu uchovajte v chladničke a spotrebujte do 24 hodín.
Výrobok určený na priamu konzumáciu bez ďalšej tepelnej úpravy.
Spotrebujte do dátumu uvedenom na štítku.
Výživové hodnoty: kcal 448,30/100g ,kJ 1856,65 /100g
obsah tuku 38,9%, bielkoviny 22,45% , sacharidy 2,10%, soľ 4,13%
Výrobca: ERIK s.r.o. , prevádzka :Trstené pri Hornáde ,Košice 044 11