Hello I was able to show a vendor's photo using this code. Here I have a problem with the ID of the vendor.
<?php
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->from($db->quoteName('#__hikamarket_vendor'));
$query->select($db->quoteName(array('vendor_image')));
$db->setQuery($query);
$vendor = $db->loadObjectList();
foreach($vendor as $vendor){
$vendor_image = null;
$imageHelper = hikamarket::get('shop.helper.image');
if(!empty($vendor->vendor_image))
$vendor_image = $imageHelper->getThumbnail($vendor->vendor_image, array(100,100), array());
if(empty($vendor_image) || !$vendor_image->success)
$vendor_image = $imageHelper->getThumbnail($this->config->get('default_vendor_image', ''), array(100,100), array('default' => true), true);
}
?>
<img src="<?php echo @$vendor_image->url; ?>" alt=""/>
But for the vendor vote I will need some help. This is the code I use. I found the code to extract the database but there is some problem.
<?php
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query = 'SELECT vote.vote_id, vote.vote_type, vote.vote_ref_id, vendor.vendor_id, vendor.vendor_average_score as `average_score`, vendor.vendor_total_vote as `total_vote` '.
' FROM '.hikamarket::table('vendor').' as vendor '.
' INNER JOIN '.hikamarket::table('shop.vote').' AS vote ON (vote.vote_ref_id = vendor.vendor_id AND vote.vote_type = '.$db->Quote('vendor').') '.
' WHERE vote.vote_id IN ('.implode(',', $elements).')';
$db->setQuery($query);
$vote = $db->loadObjectList();
foreach($vote as $vote){
$voteParams = new HikaParameter();
$voteParams->set('vote_type', 'vendor');
$voteParams->set('vote_ref_id', $this->row->vendor_id);
$js = '';
echo hikamarket::getLayout('shop.vote', 'mini', $voteParams, $js);
}
?>