|
|
|
|
if (strtoupper($lang)=='GR') { ?>
ΚΑΤΗΓΟΡΙΕΣ
} else { ?>
CATEGORIES
} ?>
|
|
if (strtoupper($lang)=='GR')
printDataset($lang,'categories', 'subcategories', '*', 'cat_order', 'cat_name', 'cat_id', $cat_id, 'sca_id', $sca_id, 'sca_name', 'class=subcategory', 'category.php', ' where cat_visible=0 ');
else
printDataset($lang,'categories', 'subcategories', '*', 'cat_order', 'cat_name_en', 'cat_id', $cat_id, 'sca_id', $sca_id, 'sca_name_en', 'class=subcategory', 'category.php', ' where cat_visible=0 ');
?>
|
$q="select * from categories where cat_visible=1";
$rs = $DB->execute("$q");
$n=$rs->RecordCount();
//echo '->' . $n . '';
if ($n>0) {
for ($i=0;$i<$n;$i++) {
if ($cat_id==$rs->fields['cat_id'])
$sel='_sel';
else $sel='';
if ($_REQUEST['tsel']!=null)
$tsel=$_REQUEST['tsel'];
?>
|
|
if ($cat_id==$rs->fields['cat_id']) {
?>
|
$tsel=$rs->fields['cat_name'].' :: '.printDataset($lang,'subcategories', null, '*', 'sca_order', 'sca_name', 'sca_id', $rs->fields['cat_id'], 'cat_id', $sca_id, null, 'class=subcategory', 'category.php', ' where cat_id=' . $rs->fields['cat_id']);
if (substr(trim($tsel),strlen(trim($tsel))-2,2)=='::')
$tsel = substr(trim($tsel),0,strlen(trim($tsel))-2);
?>
|
}
$rs->MoveNext();
}
}
?>
|
if (strtoupper($lang)=='GR')
searchModule('ΑΝΑΖΗΤΗΣΗ ΚΩΔΙΚΟΥ','Αποδοχή');
else
searchModule('SEARCH BY CODE','Submit');
?>
|
|
|
|
$q="select p.*, c.cat_descr, c.cat_descr_en from products p inner join categories c on c.cat_id=p.cat_id where UPPER(p.prd_code) like '" . strtoupper($pcode) . "%' order by prd_code";
$rs = $DB->execute("$q");
$n=$rs->RecordCount();
$col=0;
if (strtoupper($lang)=='GR')
$tsel = 'ΑΠΟΤΕΛΕΣΜΑΤΑ ΤΗΣ ΑΝΑΖΗΤΗΣΗΣ "' . $pcode . '"';
else
$tsel = 'SEARCH RESULTS FOR "' . $pcode . '"';
print '
';
print '' . $tsel . '
';
$q="select * from categories where cat_id=".$cat_id;
$r = $DB->execute("$q");
if (strtoupper($lang)=='GR')
if ($rs->fields['cat_descr']!=null) print $rs->fields['cat_descr'] . '
';
else
if ($rs->fields['cat_descr_en']!=null) print $rs->fields['cat_descr_en'] . '
';
for ($i=0;$i<$n;$i++) {
if ($rs->fields['photo_id']!=null) {
$obj = new lookupText('photos', 'photo_id', $rs->fields['photo_id'], 'photo_tpath', '', '');
$photoPath=$obj->getHtml();
} else $photoPath='images/noimg_100.jpg';
if (($photoPath!=null) && ($photoPath!='-') && ($photoPath!='')) {
list($width, $height) = getimagesize("$photoPath");
if ($height>85) {
$newheight=85;
$percent=$newheight/$height;
$newwidth = $width * $percent;
$height=85;
if ($newwidth<=85)
$lwidth=85;
$width=$newwidth;
?>
} else {
if ($width<=85)
$lwidth=85;
?>
}
}
$rs->MoveNext();
}
if ($n>36) {
?>
}
?>
|
|