Здравейте,
Някой може ли да ми помогне как да листна и подкатегориите, а не само първата категория в този код.
<div class="col-right sidebar col-md-3 col-sm-4 col-xs-12">
<?php
$db=JFactory::getDBO();
$sql_category="
SELECT vc.virtuemart_category_id, vc.category_name, cc.category_parent_id
FROM #__virtuemart_categories_en_gb AS vc, #__virtuemart_category_categories AS cc, #__virtuemart_categories AS vcc
WHERE cc.id = vc.virtuemart_category_id
AND vcc.virtuemart_category_id = vc.virtuemart_category_id
AND vcc.published = '1' and cc.category_parent_id='".$this->category->virtuemart_category_id."'";
$db->setQuery($sql_category);
if ($db->getErrorNum()) {
echo $db->getErrorMsg();
exit;
}
$category = $db->loadObjectList();
$document->addScript(JURI::base().'templates/vigoshop/js/jquery_accordion/jquery.akordeon.js');
if(!empty($category))
{?>
<div class="moduletable block block-category-nav">
<div class="block-title">
<strong><span>
<?php if($this->category->category_name!=NULL){ echo $this->category->category_name;} else { echo "Категории"; }?></span></strong>
</div>
<div class="block-content">
<div class="akordeon category-list">
<?php
foreach($category as $cat)
{
// echo "<br>"."Ctegory Parent Id : ".$cat->category_parent_id."<br>";
// echo "Category Id : ".$cat->virtuemart_category_id;
$sql_category_child="SELECT vc.virtuemart_category_id, vc.category_name, cc.category_parent_id
FROM #__virtuemart_categories_en_gb AS vc, #__virtuemart_category_categories AS cc, #__virtuemart_categories AS vcc
WHERE cc.id = vc.virtuemart_category_id
AND vcc.virtuemart_category_id = vc.virtuemart_category_id
AND vcc.published = '1' and cc.category_parent_id='".$cat->virtuemart_category_id."'";
$db->setQuery($sql_category_child);
if ($db->getErrorNum()) {
echo $db->getErrorMsg();
exit;
}
$category_child = $db->loadObjectList();
if(empty($category_child))
{
$cls_name="has-no-children";
}
else
{
$cls_name="";
}
?>
<div class="akordeon-item <?php echo $cls_name; ?>">
<div class="akordeon-item-head">
<div class="akordeon-item-head-container">
<div class="akordeon-heading">
<a href="index.php?option=com_virtuemart&view=category&virtuemart_category_id=<?php echo $cat->virtuemart_category_id;?>"><?php echo $cat->category_name; ?></a>
</div>
</div>
</div>
<?php
if(!empty($category_child))
{ ?>
<div class="akordeon-item-body">
<div class="akordeon-item-content">
<ul>
<?php
foreach($category_child as $cc)
{ // print_r($cc); ?>
<li>
<a href="index.php?option=com_virtuemart&view=category&virtuemart_category_id=<?php echo $cc->virtuemart_category_id;?>"><?php echo $cc->category_name; ?></a>
<?php /*?>echo "child_inner category : ".$child_inner->virtuemart_category_id." ".$child_inner->category_name."<br>"; <?php */?> </li>
<?php }
?>
</ul>
</div>
</div>
<?php } ?>
</div>
<?php }
?>
</div>
</div>
<script type="text/javascript">
jQuery(document).ready(function(){
jQuery('.akordeon.category-list').akordeon({ buttons: true, toggle: true });
});
</script>
</div>
