';
//poradnik poc. pismen pojmu
$out.='';
foreach($chars as $k=>$v) {
$out.=' ';
}
$out.='
';
//TOP pojmy
$top_c=GetTopConception();
$out.='';
foreach($top_c as $k=>$v) {
$url='/informace/vyklad-pojmu/'.$v['urlid'].'/';
$out.='
'.$v['s_pojem'].'';
}
$out.='
';
//END top Pojmy
foreach($chars as $k=>$v) {
$pojmy=GetConceptionsForChar($v);
if(!$pojmy) continue;
$out.='';
foreach($pojmy as $k=>$v) {
$url='/informace/vyklad-pojmu/'.$v['urlid'].'/';
$out.='
'.$v['s_pojem'].'';
}
$out.='
';
}
$out.='';
return $out;
}
function renderSlovnikLeftMenu() {
global $db;
$chars=GetChars();
$out='';
//poradnik poc. pismen pojmu
$out.='';
foreach($chars as $k=>$v) {
$out.=' ';
}
$out.='
';
//TOP pojmy
$top_c=GetTopConception();
$out.='';
foreach($top_c as $k=>$v) {
$url='/informace/vyklad-pojmu/'.$v['urlid'].'/';
$out.='
'.$v['s_pojem'].'';
}
$out.='
';
//END top Pojmy
foreach($chars as $k=>$v) {
$pojmy=GetConceptionsForChar($v);
if(!$pojmy) continue;
$out.='';
foreach($pojmy as $k=>$v) {
$url='/informace/vyklad-pojmu/'.$v['urlid'].'/';
$out.='
'.$v['s_pojem'].'';
}
$out.='
';
}
return $out;
}
function GetChars() {
global $db;
$dbSQL = "SELECT DISTINCT(char_id) FROM contentSystem.slovnik WHERE b_deleted=0";
$dbRes = mysqli_query($db, $dbSQL);
while($row = @mysqli_fetch_array($dbRes)) {
$ret[]=$row['char_id'];
}
return $ret;
}
/*
* Vrati TOP pojmy zo slovnika
*/
function GetTopConception() {
global $db;
$dbSQL = "SELECT * FROM contentSystem.slovnik WHERE b_top=1 AND b_deleted=0";
$dbRes = mysqli_query($db, $dbSQL);
while($row = @mysqli_fetch_array($dbRes)) {
$ret[$row['id']]=$row;
}
return $ret;
}
/*
* Vrati TOP pojmy zo slovnika
*/
function GetConceptionsForChar($char) {
global $db;
$dbSQL = "SELECT * FROM contentSystem.slovnik WHERE char_id='".$char."' AND b_deleted=0";
$dbRes = mysqli_query($db, $dbSQL);
while($row = @mysqli_fetch_array($dbRes)) {
$ret[$row['id']]=$row;
}
return $ret;
}
/*
* Vrati pojem na zaklade urlid
*/
function GetConception($urlid) {
global $db;
$dbSQL = "SELECT * FROM contentSystem.slovnik WHERE urlid='".$urlid."' AND b_deleted=0";
$dbRes = mysqli_query($db, $dbSQL);
$row = @mysqli_fetch_array($dbRes);
return $row;
}
function RenderConception($urlid) {
$row=GetConception($urlid);
if(!$row) return '';
$out='';
$out.='
'.$row['s_pojem'].'
';
$out.=$row['s_vyklad'];
$out.='';
return $out;
}
/*
* vysklada zoznam boxuk pre hlavni pojmy
*/
function RenderTopConceptionsBox() {
$top_pojmy=GetTopConception();
if(!$top_pojmy) return '';
$out='';
foreach($top_pojmy as $k=>$v) {
$out.='';
$out.='
'.$v['s_pojem'].'
';
$out.=$v['s_vyklad'];
$out.='';
}
return $out;
}
/*
* Vysklada seznam boxu pro dane pocatecni pismeno
*/
function RenderConceptionBox($char_id,$not_urlid=null) {
$top_pojmy=GetConceptionsForChar($char_id);
if(!$top_pojmy) return '';
$out='';
foreach($top_pojmy as $k=>$v) {
if(!is_null($not_urlid) && $v['urlid']==$not_urlid) continue; //pokial chceme nejaky pojem preskocit
$out.='';
$out.='
'.$v['s_pojem'].'
';
$out.=$v['s_vyklad'];
$out.='';
}
return $out;
}
?>