Reply To: Orderby title instead of foreach

• neverything

• September 24, 2013 at 9:31 pm

Ok I think I figured out a solution for you to test. First we need to loop through the while( has_sub_field( 'schede_prodotti' ) ) and prepare the data for furhter use in $ids and $files. Next we use these arrays containing the $post->IDs from the relationship field and the $files from the other fields in the repeater and prepare our data to get out.

Here is the code:

<?php if ( get_field( 'schede_prodotti' ) ): ?>
<table class="product-list simple-list">
    <?php

        $ids   = array(); // Empty array for the $post->IDs from the relationship fields
        $files = array(); // Empty array for the files from the repeater fields

        while( has_sub_field( 'schede_prodotti' ) ):

            /**
             * Get the IDs
             *
             * Returns an array of the IDs of the posts
             * selected using the Relationship field.
             *
             * @var array
             */
            $id    = get_sub_field( 'relazione_prodotti' );
            $ids[] = $id[0]; // We need the first array of the return value of the relationship field

            /**
             * Get the files
             *
             * Store the files under the $post->ID from the relationship field
             * and use the field name for reference.
             *
             * @var $array
             */
            $files[$id[0]]['scheda_tecnica'] = get_sub_field('scheda_tecnica');
            $files[$id[0]]['scheda_di_sicurezza'] = get_sub_field('scheda_di_sicurezza');

        endwhile; // has_sub_field( 'schede_prodotti' )

        if ( $ids ) : // Check if we have $ids from the posts.

            /**
             * Prepare the get_posts arguments
             *
             * With the 'orderby' => 'ttile' we accomplish the goal of having the
             * products ordered by name instead of drag and drop.
             *
             * @see http://codex.wordpress.org/Template_Tags/get_posts#Parameters
             * @var array
             */
            $args = array(
                'post__in'  => $ids,        // Use the ids from above
                'order'     => 'ASC',       // Order
                'orderby'   => 'title',     // Field to order the posts by
                'post_type' => 'prodotti'   // The custom post type you use
            );

            /**
             * Query the Posts
             *
             * @var array
             */
            $posts = get_posts( $args );

            if ( $posts ) : // Check if we have $posts

                foreach ( $posts as $post ) : setup_postdata( $post ); ?>
                    <tr>
                        <td class="title">
                            <span><?php the_title(); ?></span>
                        </td>
                        <td>
                            <a href="<?php echo $files[$post->ID]['scheda_tecnica']; ?>" class="notifiche" data-tipo="Scheda Tecnica">Scarica la Scheda Tecnica</a>
                        </td>
                        <td>
                            <a href="<?php echo $files[$post->ID]['scheda_di_sicurezza']; ?>" class="notifiche" data-tipo="Scheda di Sicurezza">Scarica la Scheda di Sicurezza</a>
                        </td>
                    </tr><?php

                endforeach; // ( $posts as $post )
                wp_reset_postdata();

            endif; // ( $posts )
        endif; // ( $ids )
    ?>
</table>
<?php endif; // get_field( 'schede_prodotti' ) ?>

And again I updated the Gist for better readability: https://gist.github.com/neverything/6573468

Let me know if this works now with the sorting of the titles.