Sorting a related records output in an arbitrary order

Hi Jerry,
I'm still going through your question.

I'm not sure if this is a bug or a misunderstanding on my part, but was this a typo?

<?php if (!empty($listen_liveRecord['performer'])): ?>
<span class="alt_text_font"><br>
Information About The Performers For This Concert Will Be Available Soon.</span>
<?php else: ?>
<?php foreach ($listen_liveRecord['performers'] as $performer): ?>
<span class="alt_heading_font">FEATURING:</span>

You can see the first part of the code block says 

<?php if (!empty($listen_liveRecord['performer'])): ?>

but  a few lines below you have

<?php foreach ($listen_liveRecord['performers'] as $performer): ?>

Can you point me to where I can get the Related Record plugin? I haven't seen or used that plugin yet.

Hello Carl, 

Nice to meet you (virtually)...

Yes it's a typo, but just in the post. It should be 'performers'.

You can download the plugin from http://www.thecmsbcookbook.com/downloads/relatedRecordLookupFunctions.zip

I''s an oldie but goodie from Chris Waddel. 

I also set up an account for you on my CMSB cookbook that I've been putting together for the past dozen or so years.

I've sent you an email at what I think is your email address with login credentials.

If you don't get it, reach out to me by email and I'll get them to you.

Thanks for looking at this,

Jerry Kornbluth

Hi Jerry,
I have all the files you sent me. Try this and let me know if this solves everything:

                <?php foreach ($listen_liveRecord['performers'] as $performer): ?>
                <span class="alt_heading_font">FEATURING TEST:</span>
                
                </td>
            </tr><tr><td colspan="2"><hr class="active" /></td></tr>
            <?php break ?>
                <?php endforeach ?>
            <!-- BEGIN PERFORMER LISTING CODE -->
            <?php
                $lineup_order = array_column($listen_liveRecord['performers'], 'concert_lineup_order');
                array_multisort($lineup_order, SORT_DESC, $listen_liveRecord['performers']);
                    foreach ($listen_liveRecord['performers'] as $performer): ?>

If you're wondering what I did, I used the PHP function array_column to fetch the values from the array and then I performed an array_multisort on the array. The two lines I added to your file starts at line 190. The only changes I made to your code is here:

                $lineup_order = array_column($listen_liveRecord['performers'], 'concert_lineup_order');
                array_multisort($lineup_order, SORT_DESC, $listen_liveRecord['performers']);

Hi Carl,

Thanks for your insights on this, but I’m still a bit confused (nothing new I’m afraid).

I made the changes you suggested to indexA.php, but the lineup order that shows under ‘Featuring Test’ is nothing like the sample lineup order in the pilllbox (beta) field in the Sept 6, listen-live record, (although it does, for some reason, match the lineup text that was entered above that in white). I even tried commenting out the old orderBy in the list records call.

Must be something I don’t understand, could I ask you to take another quick look?

I've attached the latest indexA.php file in case you see something I missed.

Thanks,

Jerry Kornbluth

For the Featuring Test section, I had added code that sorted the results based on the order you had defined for the concert lineup order numbers, and it was sorted highest to lowest. What's the difference between the Featuring test and Featuring in terms of how you want it to show up? Without the code I created and added yesterday, the Featuring Test at least was displaying the results in the same order as the pillbox results.

Hey Carl,

I moved the foreach to before your code and it seems to work (file attached), however I seem to have an issue inserting musicians into the pillbox in the show lineup order for a particular show.

I'm not sure I'm describing this correctly, but...

When the musicians listings themselves are sorted in last_name, first_name, group_name order, the order in the pillbox pull down list field list is sorted that way, which makes it convenient to find a specific musician in the pull down.(preferred)

However, when I try to insert a name into the listen_live record pillbox in show lineup order, they only appear in the pillbox in alphabetical last_name, first_name, group_name order.

When I remove the sorting from the musicians_listings, the the order in the pillbox pull down list field is in record number order, which makes it very difficult to find a specific musician in the pull down, and I'm still having difficulty entering the musicians in show lineup order. (they don't seem to show in either record number order or alphabetical order)

Or, maybe I just don't know how to reorder entries in a pillbox field or enter new 'pills' in a specific place in the field...

Any thoughts? 

Thanks,

Jerry Kornbluth

When you want to re-sort pillbox values or add values in a specific place in the pillbox, the only way you can do this is to manually remove all the items up until the spot you want to place the item, and then re-added everything you just removed. Perhaps we can look into doing this more intuitively by dragging and dropping in a future update of CMSB.