'category',
));
list($marketplaceRecords, $marketplaceMetaData) = getRecords(array(
'tableName' => 'marketplace',
));
list($marketplace_couponsRecords, $marketplace_couponsMetaData) = getRecords(array(
'tableName' => 'marketplace_coupons',
));
list($marketplace_classifiedsRecords, $marketplace_classifiedsMetaData) = getRecords(array(
'tableName' => 'marketplace_classifieds',
));
// index marketplaceRecords by title
$marketplaceRecordsByTitle = array();
foreach ($marketplaceRecords as $marketplace) {
$marketplaceRecordsByTitle[ $marketplace['title'] ] = $marketplace;
}
// join data from marketplace_couponsRecords
foreach ($marketplace_couponsRecords as $marketplace_coupon) {
if ( isset($marketplaceRecordsByTitle[ $marketplace_coupon['title'] ]) ) {
$marketplaceRecordsByTitle[ $marketplace_coupon['title'] ]['coupon'] = $marketplace_coupon;
}
}
// join data from marketplace_classifiedsRecords
foreach ($marketplace_classifiedsRecords as $marketplace_classified) {
if ( isset($marketplaceRecordsByTitle[ $marketplace_classified['title'] ]) ) {
$marketplaceRecordsByTitle[ $marketplace_classified['title'] ]['classified'] = $marketplace_classified;
}
}
// index categoryRecords by name
$categoryRecordsByTitle = array();
foreach ($categoryRecords as $category) {
$category['marketplaces'] = array();
$categoryRecordsByTitle[ $category['title'] ] = $category;
}
foreach ($marketplaceRecordsByTitle as $marketplace) {
foreach (explode("\t", trim($marketplace['cats'], "\t")) as $catName) {
if ( !$catName ) { continue; }
$categoryRecordsByTitle[$catName]['marketplaces'][] = $marketplace;
}
}
function testCategoryHasMarketplaces($category) {
return (count($category['marketplaces']) > 0);
}
$nonEmptyCategories = array_filter($categoryRecordsByTitle, 'testCategoryHasMarketplaces');
?>
Category:
