public static function LoadAllWithCustomFields($strOrderBy = null, $strLimit = null, $objExpansionMap = null) { Category::ArrayQueryHelper($strOrderBy, $strLimit, $strLimitPrefix, $strLimitSuffix, $strExpandSelect, $strExpandFrom, $objExpansionMap, $objDatabase); // Setup QueryExpansion $objQueryExpansion = new QQueryExpansion(); if ($objExpansionMap) { try { Category::ExpandQuery('category', null, $objExpansionMap, $objQueryExpansion); } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } } $arrCustomFieldSql = CustomField::GenerateSql(6); $strQuery = sprintf(' SELECT %s `category`.`category_id` AS `category_id`, `category`.`short_description` AS `short_description`, `category`.`long_description` AS `long_description`, `category`.`image_path` AS `image_path`, `category`.`asset_flag` AS `asset_flag`, `category`.`inventory_flag` AS `inventory_flag`, `category`.`created_by` AS `created_by`, `category`.`creation_date` AS `creation_date`, `category`.`modified_by` AS `modified_by`, `category`.`modified_date` AS `modified_date` %s %s FROM `category` AS `category` %s %s WHERE 1=1 %s %s ', $strLimitPrefix, $objQueryExpansion->GetSelectSql(",\n\t\t\t\t\t", ",\n\t\t\t\t\t"), $arrCustomFieldSql['strSelect'], $objQueryExpansion->GetFromSql("", "\n\t\t\t\t\t"), $arrCustomFieldSql['strFrom'], $strOrderBy, $strLimitSuffix); //echo($strQuery); exit; $objDbResult = $objDatabase->Query($strQuery); return Category::InstantiateDbResult($objDbResult); }