[Admin Gen] Order in Many-to-Many List

Prev		Next

http://www.symfony-project.org/forum/index.php?t=msg&th=5880

Hi,

How to present content of the Many-to-Many List in the order that I want?

Using the book as an example, http://www.symfony-project.org/book/trunk/14-Generators#Many-to-Many%20Relationships

Listing 14-30 shows how to handle many-to-many relationships with a through_class parameter. Based on my reading, I should change it to something like:

edit:
  fields:
    article_author: { type: admin_double_list, params: through_class=ArticleAuthor peer_method=getSortedByName }

And in ArticleAuthorPeer class implement a method getSortedByName, something like:

// return staff list in the order of First name, Last name
public static function getSortedByName() {
    $c = new Criteria();
    $c->addAscendingOrderByColumn(ArticleAuthorPeer::FIRST_NAME);
    $c->addAscendingOrderByColumn(ArticleAuthorPeer::LAST_NAME);
    return ArticleAuthorPeer::doSelect($c);
}

But the problem is, ArticleAuthorPeer::doSelect don't have the ArticleAuthorPeer::FIRST_NAME, ArticleAuthorPeer::LAST_NAME fields. To use those fields, I should use doSelectJoinAuthor method, but what it returns is not comply with what the peer_method requires. So,….?

Please help

[Admin Gen] Order in Many-to-Many List

peer_method doesn't work with many to many controls.

I recently asked the same question on the mailing list and got this reply which worked for me….

You can override doSelect in your peer class [in the AuthorPeer class]:

public static function doSelect(Criteria $criteria, $con = null)
{

// by default order by name
/// getOrderByColumns()

if(count($criteria->getOrderByColumns()) == 0)
{
        $criteria->addAscendingOrderByColumn(self::NAME);
}

        return self::populateObjects(self::doSelectRS($criteria, $con));
}

flat stanley

[Admin Gen] Order in Many-to-Many List

> > You can override doSelect in your peer class
>
> Could you elaborate a bit more please? Sorry to be dense, here are my
> confusions.
>
> By peer class, I guess it's the peer class of the table that holds the
> Many-to-Many List. I.e., the ArticleAuthor. If so,
>
> However, the Many-to-Many table only contains 3 fields, id of its own, and
> ids for the link. In your example, how can you sort by name then?

In your example, you have articles and authors.

So, for instance, you might choose to use the "admin_check_list" control in the admin module for articles. When you edit an article, you can assign authors to it by selecting the check boxes but the list of authors will be ordered by id. If you want the list in alphabetical order, you can override the doSelect function in the AuthorPeer class to return the results ordered by name, if no other order has been assigned. (as is shown in the example from my previous post).

documented on: 05 April 2007, Jonathan, aka, flat stanley

Sort entries in an admin_double_list in admin generator

http://www.symfony-project.org/forum/index.php?t=msg&th=6950

Well, I had to use a special select for the AllObjects list of admin_double_list and so I modified symfony the following way to support a peer_method param for admin_double_list…

I would like to see my changes in PEAR/symfony/addon/propel/sfPropelManyToMany.class.php and PEAR/symfony/addon/propel/sfPropelManyToMany.class.php to be included in symfony.

-- xpuc 17 July 2007

I've implemented the patch and attached it under the ticket #1633 in the symfony trac. (see http://trac.symfony-project.org/trac/ticket/1633)

I don't know if fabien decides to merge it, though.

documented on: 18 July 2007, JanBlaha