Εμφάνιση των Latest Products μέσα στο Product Details.

Στο τέλος του αρχείου components/com_yagendooproductmanager/themes/yag_blueberry_etheme/productdetails/default.php

προσθέτουμε το patch:


<style>
div.recentProd {
width:20%;
border:1px solid #DEDEDE;
position:relative;
float:left;
min-height:300px;
text-align:center;
margin:10px 0px;
margin-right:45px;
}
div.recentImage{

text-align:center;

}
.recentTitle {
padding: 6px 5px 4px 16px ;
margin: 0px 0px 10px;
margin-bottom:15px;
min-height: 24px;
border-radius: 3px;
font-weight: bold;
border: 1px solid #D6D6D6;
color: #707070;
}
div.recentSKU {

text-align:center;
}

</style>

<?php $checkIfRel = $_SESSION["__vm"]["vmlastvisitedproductids"];

if(!empty($checkIfRel)) {
    echo '<h1 class="recentTitle">Last Visited Products</h1><div >';


    $maxcounter=1;

    foreach ($checkIfRel as $check) {
    if($maxcounter<9) {
        $db = JFactory::getDbo();

        $query="SELECT *,d.slug AS pslug,c.slug AS catslug FROM #__virtuemart_products as a LEFT JOIN uhhu_virtuemart_products_el_gr as d on a.virtuemart_product_id=d.virtuemart_product_id INNER JOIN #__virtuemart_product_categories as b ON a.virtuemart_product_id = b.virtuemart_product_id LEFT JOIN #__virtuemart_categories_el_gr AS c ON b.virtuemart_category_id=c.virtuemart_category_id WHERE a.virtuemart_product_id =". $check ." GROUP BY a.virtuemart_product_id ";
        $db->setQuery($query);

        $options=$db->loadObjectList();

            foreach ($options as $row) {
            $flag=false;
            $childid=$row->virtuemart_category_id;
            $hlink=$row->catslug;

            $mediaq= " SELECT file_url_thumb from #__virtuemart_medias where virtuemart_media_id = (SELECT virtuemart_media_id from #__virtuemart_product_medias where virtuemart_product_id=".$row->virtuemart_product_id ." LIMIT 1)";
            $db->setQuery($mediaq);
            $pimage=$db->loadResult();


            while ($flag==false) {
                $query2="SELECT category_parent_id from #__virtuemart_category_categories where category_child_id=" . $childid;
                $db->setQuery($query2);
                $options2=$db->loadResult();


                if(!empty($options2)) {
                    $query3="SELECT slug from #__virtuemart_categories_el_gr where virtuemart_category_id = " . $options2 ;
                    $db->setQuery($query3);
                    $catslug=$db->loadResult();

                    $hlink = '/' . $catslug . '/'. $hlink ;
                    $childid= $options2;
                }else {
                    $flag=true;
                    }






        }

        echo '<div class="recentProd"><a style="color:#909090;" href="index.php'.$hlink. '/' . $row->pslug . '-detail"  >';
        echo '<div class="recentImage"><img src="'.$pimage .'"/></br></div>';
        echo $row->product_name . '</a></br><span style="color:#909090;">Sku:'.$row->product_sku.'</span></div>';

        $maxcounter++;
        }



}
}


}

?>
</div>