Question about vendor listing

-- HikaShop version -- : 2.6.3
-- HikaMarket version -- : 1.7.0
-- Joomla version -- : 3.4.5
-- PHP version -- : 5.5
-- Error-message(debug-mod must be tuned on) -- : none

hi

i created a hikamarket vendor listing menu. MY problem is that it displays all users even do they have not posted anything. i think it has something to do with my setting to simplified registration with password and vendor automatic creation.

is there a way not to display vendors who just registered and has not actually posted anything? or maybe not to display vendors who has not completed certain fields?

thanks

hi Jerome and thank you

i have been trying this but i cant move forward.

i always get this error

Warning

JInstaller: :Install: Can't find Joomla XML setup file.
×
Error

Unable to find install package

i attached the plugin i created, maybe you can point me to the right direction?

thank you

your right, thank you.

i got it to install but having this error

Unknown column 'vendor_products' in 'having clause' SQL=SELECT COUNT(vendor.vendor_id) FROM #__hikamarket_vendor AS vendor LEFT JOIN #__hikashop_product AS hkp ON hkp.product_vendor_id = vendor.vendor_id AND hkp.product_published = 1 and hkp.product_type = 'main' WHERE (vendor_published = 1) AND (vendor.vendor_id > 1) HAVING vendor_products > 0 ORDER BY vendor.vendor_id ASC

hi thanks jerome

the error is gone but no vendor is displaying even do vendors have products.

<?php
class plgHikamarketVendor_wproduct_only extends JPlugin {
          public function onBeforeVendorListingDisplay(&$view, &$sql_params) {
		$sql_params['join']['vendor_products'] = 'LEFT JOIN #__hikashop_product AS hkp ON hkp.product_vendor_id = vendor.vendor_id AND hkp.product_published = 1 and hkp.product_type = \'main\'';
		$sql_params['select']['vendor_products'] = 'COUNT(hkp.product_id) AS vendor_products'; 
		$sql_params['having']['vendor_products'] = 'vendor_products > 0';
	}
}

hi thank you

i tested this but it only displayed one vendor. it shows the main vendor

i tried to change WHERE (vendor_published = 1) to WHERE (vendor_published = 0) just to test it and it displayed the first vendor that is unpublished.

i dont know if it makes sense but it always displays the first vendor in the table

i tried to change hkp.product_type = 'main' to hkp.product_type = 'main categories' because i changed my category from main to main category but it still displays the main vendor which happens to be the first vendor in the table. One difference from setting 'main' to 'main category' is the vendor_products. for 'main' = 28 for 'main category' = 0.

what else could i check?

thanks

hi jerome

first of all thank you for your patience.

to make things clear please let me explain.

i changed the file components/com_hikamarket/views/vendormarket/view.html.php and it is attached here.
i created the plugin with the following codes

unfortunately its not working on my end.

it is only displaying one vendor

what i am requesting is to display vendors with products only

thanks

hi jerome,

again thank you

its working now but with a little bug. the plugin is now able to display all vendors that are with products. the only problem is when you choose to navigate using pagination.

when you use pagination and select the button to go to the last part of the record. what happens is everything or all records disappears.

please check this link link

i modified the plugin contents to this

<?php
/**
 * @package    HikaMarket for Joomla!
 * @version    1.7.2
 * @author     Obsidev S.A.R.L.
 * @copyright  (C) 2011-2016 OBSIDEV. All rights reserved.
 * @license    GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html
 */
defined('_JEXEC') or die('Restricted access');
?><?php

class plgHikamarketVendor_wproduct_only extends JPlugin {
          public function onBeforeVendorListingDisplay(&$view, &$sql_params) {
	

         $sql_params['join']['vendor_products'] = 'LEFT JOIN #__hikashop_product AS hkp ON hkp.product_vendor_id = vendor.vendor_id
AND hkp.product_published =1 AND hkp.product_type = \'main\'';

$sql_params['select']['vendor_products'] = 'COUNT(hkp.product_id) AS vendor_products ';
$sql_params['having']['vendor_products'] = 'vendor_products > 0 ';

$sql_params['group_by']['vendor_products'] = 'vendor.vendor_id';

}}

thank you jerome

i still cant get this to work.

can you tell me what the code should be?

i already tried to add $order but still dosnt work.

$db->setQuery('SELECT COUNT(vendor.vendor_id) FROM '.hikamarket::table('vendor').' AS vendor ' . $sql_joins . $filters . $order);