";
$results = searchVendor($keyword);
//echo "找到".$results['hits']['total']."筆記錄... ";
$nVendorNum = $results['hits']['total'];
$db = JFactory::getDBO();
GOTO SKIPDB;
//廠商
$vendorGroupid = CivilUser::getGroupid("廠商會員");
$sql = "
SELECT DISTINCT usergroup.group_id AS `VIPGroup`,usergroup2.group_id AS `HighGroup`,vendor.*
FROM civil_vendor_management_vendorinfo AS vendor
LEFT JOIN civil_vendor_management_products AS product ON vendor.id=product.vendorid
LEFT JOIN civil_user_usergroup_map AS usergroup ON vendor.juserid=usergroup1.user_id AND usergroup1.group_id = '$vendorGroupid'
WHERE vendor.state = 1
AND (vendor.companyname LIKE '%". $keywordEX[0] ."%' OR vendor.unifiedbusno = '". $keywordEX[0] ."' OR vendor.business LIKE '%". $keywordEX[0] ."%' OR (product.state=1 AND product.productname LIKE '%". $keywordEX[0] ."%') ";
for($i=1; $isetQuery($sql);
$results = $db->loadObjectList();
$nVendorNum = count($results);
SKIPDB:
echo "
";
//職缺
$sql = "SELECT * FROM `civil_js_job_jobs` WHERE title LIKE '%".$_GET["search"]."%'";
$db->setQuery($sql);
$results = $db->loadObjectList();
echo "
";
}
}
if($_GET["type"]=="market" AND isset($_GET["search"]))
{
$keyword = '\'%'.$_GET["search"].'%\'';
$db = JFactory::getDBO();
$sql = "SELECT DISTINCT vendorid,product.id,companyname,productname,productpicture FROM civil_vendor_management_products AS product, civil_vendor_management_vendorinfo AS vendor , civil_categories AS b ".
"WHERE vendor.id = product.vendorid ".
"AND extension ='com_vendor_management' ".
"AND product.state=1 AND vendor.state=1 ".
"AND productname LIKE $keyword ";
//如果有類別就只搜尋類別內的
if (isset($_GET["class"]) AND $_GET["class"]!='')
{
$sql .= "AND `parent_id` = ".$_GET['class']." AND (`category01`=b.`id` OR `category02`=b.`id` OR `category03`=b.`id` OR `category04`=b.`id` OR `category05`=b.`id` OR `category06`=b.`id` OR `category07`=b.`id` OR `category08`=b.`id` OR `category09`=b.`id` OR `category10`=b.`id`) AND vendor.state=1 AND companyname!='' AND b.published=1";
}
else if (isset($_GET["result"]) AND $_GET["result"]!='')
{
$sql .= "AND (category01 = ".$_GET['result']." OR category02 = ".$_GET['result']." OR category03 = ".$_GET['result']." OR category04 = ".$_GET['result']." OR category05 = ".$_GET['result']." OR category06 = ".$_GET['result']." OR category07 = ".$_GET['result']." OR category08 = ".$_GET['result']." OR category09 = ".$_GET['result']." OR category10 = ".$_GET['result'].")";
}
//如果有city就搜尋city
if(isset($_GET["city"]) AND $_GET["city"]!="")
{
$citykeyword = '\'%'.$_GET["city"].'%\'';
$sql .= "AND vendor.companycity LIKE $citykeyword";
}
$sql .= " ORDER BY vendorid";
$db->setQuery($sql);
$results = $db->loadObjectList();
if(count($results)>=1)
{
foreach ($results as $row) :
echo "";
echo "
";
$vendorGroupid = CivilUser::getGroupid("廠商會員");
$sql=" SELECT A.* FROM `civil_vendor_management_products` A
LEFT JOIN `civil_user_usergroup_map` B ON A.`created_by`= B.`user_id`
LEFT JOIN `civil_vendor_management_vendorinfo` C ON A.`vendorid`= C.`id`
WHERE B.`group_id` = '$vendorGroupid'
AND A.state=1 AND C.state=1
ORDER BY RAND() LIMIT 4";
$db->setQuery($sql);
$results = $db->loadObjectList();
if(count($results)>=1)
{
foreach ($results as $row) :
echo "";
echo "