'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',
));
// a collection of our records
$recordSets = array(
'marketplace' => $marketplaceRecords,
'coupon' => $marketplace_couponsRecords,
'classified' => $marketplace_classifiedsRecords,
);
// index item records in recordSets by their titles
$rowsByTitle = array();
foreach ( $recordSets as $recordSetName => &$records ) {
foreach ( $records as &$record ) {
// skip processing records without a title
if ( strlen($record['title']) === 0 ) { continue; }
// lookup an existing row by this record's title or create a new one
if ( !array_key_exists($record['title'], $rowsByTitle) ) {
$rowsByTitle[ $record['title'] ] = array();
$rowsByTitle[ $record['title'] ][ 'title' ] =& $record['title'];
$rowsByTitle[ $record['title'] ][ '_link' ] =& $record['_link'];
$rowsByTitle[ $record['title'] ][ 'cats' ] = array();
}
$row =& $rowsByTitle[ $record['title'] ];
// add this record's cats to the row's existing cats
if ( $record['cats'] !== "" ) {
$recordCats = explode("\t", trim($record['cats'], "\t"));
$row['cats'] = array_unique(array_merge( $row['cats'], $recordCats ));
}
// create row-to-record reference keyed on recordSetName
$row[ $recordSetName ] =& $record;
}
}
// index categoryRecords by name
$categoryRecordsByTitle = array();
foreach ($categoryRecords as &$category) {
$category['rows'] = array();
$categoryRecordsByTitle[ $category['title'] ] =& $category;
}
// insert rows into categories
foreach ( $rowsByTitle as &$row ) {
foreach ( $row['cats'] as &$categoryName ) {
$categoryRecordsByTitle[ $categoryName ][ 'rows' ][] =& $row;
}
}
// strip categories with no rows
function testCategoryHasRows($category) {
return (count($category['rows']) > 0);
}
$nonEmptyCategories = array_filter($categoryRecordsByTitle, 'testCategoryHasRows');
?>
Category:
