array_groupBy and show categories labels.

Hi, Zicky.

I've used the following code with success. It has the added benefit of not displaying a heading for categories that don't contain at least one record.

<?php $documentsByCategory = array_groupBy($documentsRecords, 'category', true); ?>
<?php foreach (getListOptions('documents', 'category') as $value => $label): ?>
<?php $documents = @$documentsByCategory[$value]; ?>
<?php if (!$documents) { continue; } // skip empty categories ?>

<h2><?php echo $label;?></h2>

<?php foreach ($documents as $document): ?>

<?php if ($document['document_pdf']): ?>
<?php foreach ($document['document_pdf'] as $index => $upload): ?>
<p><a href="<?php echo htmlencode($upload['urlPath']) ?><?php echo htmlencode($document['title']) ?></a></p>
<?php endforeach ?>
<?php endif ?>

<?php endif ?>
<?php endforeach ?>

<?php endforeach ?>

I'm hoping you'll be able to make something out of that. I believe I got assistance in the forum for this years ago, but can't locate the post.

Good luck!
Deborah

Hey Deborah,

No joy. I'm still unable to get it to work.

I copied and pasted your code, updated it to my field names but it wouldn't work. I think it has to do with the fact that my "categories" are a multi-value pillbox. I also tried quite a few various changes to the code you provided - but had no luck getting it to work.

Thanks for the suggestion. 

Zicky, sorry that didn't help, but you're probably on the right track re: multi-value categories being the challenge. I've not had experience with that yet.

I'll bow out now and look forward to a solution from another forum member or Interactive Tools.

~ Deborah

Hey Zicky,

This code should work for what you're looking to accomplish (with using a multi-value category field):

<?php 
foreach (getListOptions('documents', 'categories') as $value => $label) {
    echo '<h2>'.$label.'</h2>';
    foreach ($documentsRecords as $document) {
        if (($document['document']) && (in_array($value, explode("\t",$document['categories'])))) {
            foreach ($document['document'] as $index => $upload) {
                echo '<p><a href="'.htmlencode($upload['urlPath']).'">'.htmlencode($document['title']).'</a></p>';
            }
        }
    }
}
?>

Let me know how you make out.

Best,
Steve

Thanks Deborah & Steve,

Between your two suggestions I came up with something that works... though I wouldn't say it's clean. Basically your suggestions worked, but the code was still showing categories - even if an available category was not assigned to a document. So I wrote a little comparison to find it there's a match and if YES, then show the category. I then wrapped it in some CSS masonry columns.

<div class="masonry">
<?php $documentsGroupedRecords = array_groupBy($documentsRecords, 'categories', true); ?>
<?php foreach ($documentsGroupedRecords as $cats => $records): ?> 

    <div class="brick">
        
    <?php foreach (getListOptions('documents', 'categories') as $value => $label): ?>
        <?php if ($value == $cats): ?>
            <h2><?php echo $label; ?></h2>
        <?php endif; ?>
    <?php endforeach ?>
        
    <?php foreach ($records as $record): ?>
        <?php foreach ($record['document'] as $upload): ?>
            <?php $recordTitle = ucwords(strtolower($record['title'])); ?>

                <?php if($upload = (@$record['document'][0])){
                echo '<h5><a href="download.php?num='.$record['num'].'" >'.$recordTitle.'</a></h5>'; } ?>
    
        <?php endforeach; ?>
    <?php endforeach; ?>
        
    </div>
<?php endforeach ?>
</div>

Here's the CSS

/* @media screen based on Foundation 6 framework */
/* Small only */
@media screen and (max-width: 39.9375em) {
  .masonry {
    column-count: 1;
    column-gap: 1em;
  }
  .brick {
    display: inline-block;
    padding: 0 0 1em;
    width: 100%;
  }
}
/* Medium only */
@media screen and (min-width: 40em) and (max-width: 63.9375em) {
  .masonry {
    column-count: 2;
    column-gap: 1em;
  }
  .brick {
    display: inline-block;
    padding: 0 0 1em;
    width: 100%;
  }
}
/* Large and up */
@media screen and (min-width: 64em) {
  .masonry {
    column-count: 3;
    column-gap: 1em;
  }
  .brick {
    display: inline-block;
    padding: 0 0 1em;
    width: 100%;
  }
}

Thanks,

Zicky