Firemní profil | Technický týdeník

'."\n"; $ret .= ''."\n"; $ret .= ''."\n"; $ret .= '

'."\n"; if($zobrazitZnacky) { $sql = 'SELECT '.DB_PREFIX.'moto_znacka.id_moto_znacka, '.DB_PREFIX.'moto_znacka.nazev, '.DB_PREFIX.'moto_znacka.url FROM '.DB_PREFIX.'moto_znacka WHERE '.DB_PREFIX.'moto_znacka.active_state = 1 ORDER BY '.DB_PREFIX.'moto_znacka.priorita DESC, '.DB_PREFIX.'moto_znacka.nazev ASC'; if($res = $db->get_results($sql)) { $ret .= '

'."\n"; foreach ($res as $rec) { $ret .= '

'."\n"; $ret .= '

'.$rec->nazev.'

'."\n"; $ret .= '

zobrazit modely

'."\n"; $ret .= '

'."\n"; }; $ret .= '

'."\n"; } } return $ret; } function vypis_katalog($box, $znacka = '') { global $db, $html, $cache, $form, $ciselnik; // hiearchie $hiearchie = $html->params['hiearchie']; // orezana hiearchie for($i = 0; $i < 4; $i++) { if(!$hiearchie[$i]) { unset($hiearchie[$i]); } } $sqlWhere = array(); $filtry = $ciselnik['katalog_filtr']; $filtry['katalog_rok'] = ''; $filtry['fulltext'] = ''; $filtry['moto_znacka_id'] = 0; $filtry['moto_model_id'] = 0; $filtry['objem_do'] = ''; if(isset($znacka->id_moto_znacka)) // vypis znacky { $_REQUEST['moto_znacka_id'] = $znacka->id_moto_znacka; $_REQUEST['odeslat'] = true; $zobrazitZnacky = false; } /* echo '

';
    print_r($_REQUEST);
    print_r($_SESSION['web']['filtr']);
    echo '

'; */ if(isset($_REQUEST['odeslat'])) { $zobrazitZnacky = false; $sqlWhere[] = ' AND TRUE'; foreach($filtry as $key => $value) { if(isset($_REQUEST[$key]) AND !empty($_REQUEST[$key])) { $_SESSION['web']['filtr'][$key] = $_REQUEST[$key]; switch ($key) { case 'fulltext': if($_REQUEST[$key] != $value) { $search = get_lower($db->escape($_REQUEST[$key])); $sqlWhere[] = ' AND ( LOWER('.DB_PREFIX.'katalog_polozka.nazev) LIKE \'%'.$search.'%\' OR LOWER('.DB_PREFIX.'katalog_polozka.text) LIKE \'%'.$search.'%\' OR LOWER('.DB_PREFIX.'katalog_polozka.specifikace) LIKE \'%'.$search.'%\' ) '; }; break; case 'objem_do': $sqlWhere[] = ' AND '.DB_PREFIX.'katalog_polozka.katalog_objem <= '.intval($_REQUEST[$key]).''; break; default: if(in_array($key,$ciselnik['checkBoxFiltr'])) { if(is_array($_REQUEST[$key]) AND count($_REQUEST[$key])) { $sqlWhere[] = ' AND '.DB_PREFIX.'katalog_polozka.'.$key.' IN('.implode(',',$_REQUEST[$key]).')'; } } else { $sqlWhere[] = ' AND '.DB_PREFIX.'katalog_polozka.'.$key.' IN('.intval($_REQUEST[$key]).')'; } break; }; } else { // vymazani hodnoty $_SESSION['web']['filtr'][$key] = $value; }; }; $_SESSION['web']['filtr']['sqlwhere'] = $sqlWhere; }; $ret = ''; $ret .= ' '."\n"; $ret .= '

'."\n"; $ret .= ''."\n"; $zobrazitZnacky = false; $ret .= getFilter($zobrazitZnacky); //echo $_SESSION['web']['filtr']['sqlwhere']; //if(count($_SESSION['web']['filtr']['sqlwhere'])) if(true) { // pocet polozek pro strankovani $pocet_polozek = 18; $sql = 'SELECT '.DB_PREFIX.'katalog_polozka.*, '.DB_PREFIX.'box.url AS kategorie_url FROM '.DB_PREFIX.'katalog_polozka JOIN '.DB_PREFIX.'box ON '.DB_PREFIX.'katalog_polozka.box_id = '.DB_PREFIX.'box.id_box WHERE '.DB_PREFIX.'katalog_polozka.active_state IN (1) AND '.DB_PREFIX.'katalog_polozka.box_id = '.$box->id_box.''; if(isset($_SESSION['web']['filtr']['sqlwhere']) AND count($_SESSION['web']['filtr']['sqlwhere'])) { $sql .= implode(' ',$_SESSION['web']['filtr']['sqlwhere']); } $sql .= ' ORDER BY '.DB_PREFIX.'katalog_polozka.priorita DESC, '.DB_PREFIX.'katalog_polozka.cas_vlozeni DESC'; $pocet_polozek_celkem = $db->get_var('SELECT COUNT(id_katalog_polozka) AS pocet FROM ('.$sql.') AS vypis_list'); // strankovani if(isset($_REQUEST['page']) && $_REQUEST['page'] > 1) { $sql .= ' LIMIT '.$pocet_polozek.' OFFSET '.((intval($_REQUEST['page']) * $pocet_polozek) - $pocet_polozek); // dalsi stranky bez hlavniho clanku $box->vypis = 0; } else { $sql .= ' LIMIT '.$pocet_polozek.' OFFSET 0'; }; //$ret .= '

'.$html->params['drobky'].'

'."\n"; //echo $sql; if($result = $db->get_results($sql)) { include(WEB_DIRECTORY.'katalog/katalog-vypis-1.php'); } else { $ret .= '

Nebyla nalezena žádná položka.

'."\n"; }; }; $ret .= '

'; return $ret; }; ?> Firemní profil | Technický týdeník