PHP Model_ProductProperty::getAllProductProperty Examples

Example #1

File: post.php Project: vietlethanh/oceo

//$district = $_pgR['ds'];
$keyword = $_pgR['kw'];
$manu = $_pgR['manu'];
$properties = $_pgR['property'];
$filterProperty = '';
foreach ($properties as $key => $info) {
    //echo $key;
    if ($info) {
        $filterProperty .= '(GROUP_CONCAT(\'&&\',propertyid, propertyvalue,\'&&\') LIKE \'%&&' . $key . $info . '&&%\') And ';
    }
}
if ($filterProperty) {
    $filterProperty = global_common::cutLast($filterProperty, 4);
    $filterProperty = '1=1 GROUP BY productid HAVING ' . $filterProperty;
    //echo $filterProperty;
    $productProperties = $objProductProperty->getAllProductProperty(0, global_mapping::ProductID, $filterProperty);
    $productIDs = global_common::getArrayColumn($productProperties, global_mapping::ProductID);
    $productInIDs = global_common::convertToQueryIN($productIDs);
}
$search = '';
$_arrCategories = $objArticleType->getAllArticleType(0, null, '`ParentID`=0', 'Level');
//echo $catID;
$cat = $objArticleType->getArticleTypeByID($catID);
//print_r($cat);
$_currentParentCatID = $catID;
if ($cat) {
    $_currentParentCatID = $cat[global_mapping::ParentID];
    $search = '`' . global_mapping::CatalogueID . '` = ' . $catID . ' ';
}
if ($city) {
    if ($search) {