[TYPO3-mvc] How to set the sort order for child objects (m-m relation)

[g4-lisz at tonarchiv.ch]

Hi Bernhard

Thanks for the code!

I was thinking about this, too. My first idea was to do the ordering 
with JS on the browser's side.
But both of this solutions are not really nice. And it will be quite 
slow compared with a DB sorting by indexed fields...

I'm still wondering if there's no way to overwrite the appropriate 
method to set the ordering. Meanwhile i will use your viewhelper.

Bye,
Till

On 04.08.2011 21:11, Bernhard Esders wrote:
> I solved this problem with a view helper.
> Not nice, but working.
>
> class Tx_Myextension_ViewHelpers_SortViewHelper extends 
> Tx_Fluid_Core_ViewHelper_AbstractTagBasedViewHelper {
>
>
>     private $orderBy;
>     private $order;
>
>     /**
>      * Sorts the given elements
>      *
>      * @param Tx_Extbase_Persistence_ObjectStorage $objects
>      * @param string $orderBy
>      * @param string $order
>      * @return Tx_Extbase_Persistence_ObjectStorage sortet Objects
>      * @api
>      */
>     public function render(Tx_Extbase_Persistence_ObjectStorage 
> $objects, $orderBy=NULL, $order=NULL) {
>
>         $this->orderBy = $orderBy;
>         $this->order = $order;
>
>         $sort_objects = $this->sortObjectStorage($objects);
>         return $sort_objects;
>     }
>
>
>     protected function sortObjectStorage($storage) {
>
>         $sorted = array();
>         foreach ($storage as $item) {
>             $sorted_array[] = $item;
>         }
>
>         usort($sorted_array,array($this,compare));
>
>         $sorted_storage = 
> $this->objectManager->get('Tx_Extbase_Persistence_ObjectStorage');
>         foreach ($sorted_array as $item) {
>             $sorted_storage->attach($item);
>         }
>
>         return $sorted_storage;
>     }
>
>     protected function compare($object1, $object2){
>
>         if ($this->getSortValue($object1) == 
> $this->getSortValue($object2)) {
>             return 0;
>         }
>         if ($this->order === 'ASC')
>             return ($this->getSortValue($object1) < 
> $this->getSortValue($object2)) ? -1 : 1;
>
>         return ($this->getSortValue($object1) > 
> $this->getSortValue($object2)) ? -1 : 1;
>     }
>
>     protected function getSortValue($object) {
>
>         if ($this->orderBy) {
>             $getter = 'get' . ucfirst($this->orderBy);
>         } else {
>             $getter = "getUid";
>         }
>
>         if (method_exists($object, $getter)) {
>             $value = $object->$getter();
>         } else if (is_object ($object)) {
>             $value = $object->$field;
>         } else if (is_array($object)) {
>             $value = $object[$field];
>         }
>
>         if ($value instanceof DateTime) {
>             $value = $value->getTimestamp();
>         }
>
>         return $value;
>     }
> }
>
> Am 04.08.2011 17:33, schrieb g4-lisz at tonarchiv.ch:
>> On 08/04/2011 04:30 PM, Werner Stotter wrote:
>>> hi,
>>>
>>> have you tried setting the 'sorting' in the TCA of ext_tables.php?
>>>
>>> in my case this helped
>>>
>>> greetings
>>> werner
>>>
>>>
>> Hi Werner
>>
>> Sadly this did not solve my problem.
>>
>> The issue is that the ordering property belongs to the next but one
>> table. In SQL this would be a SORTY BY a row of a secondary joined 
>> table:
>>
>> SELECT
>> h.name AS hospital_name
>> ,d.name AS disease_name
>> ,t.number AS disease_number
>> FROM
>> hospital h
>> JOIN
>> treatment t
>> ON
>> h.treatment=t.uid
>> JOIN
>> disease d
>> ON
>> t.disease=d.uid
>> ORDER BY
>> d.name
>> ;
>>
>> A 'foreign_table_where' => 'ORDER BY disease.name' statement in the
>> treatment table's TCA makes no sense because there is a 1:1 relation
>> between desease and treatment. In the hospital table's TCA i don't know
>> how to set the ordering by a property that belongs to the next but one
>> table...
>>
>> I think i have to set a SQL statement by my own, but at which place do i
>> define this $query?
>>
>> Thank you,
>> Till
>>
>>>
>>>
>>> Am 04.08.2011 15:44, schrieb g4-lisz at tonarchiv.ch:
>>>> On 30.07.2011 03:57, g4-lisz at tonarchiv.ch wrote:
>>>>> Hello all
>>>>>
>>>>> I'm writing an extension for the following domain (simplified):
>>>>>
>>>>> Entities: Hospitals, treatments
>>>>> Value Objects: disease
>>>>>
>>>>> Every hospital has several treatments. Every treatment has one 
>>>>> disease.
>>>>>
>>>>> Hospital is "aggregate root".
>>>>>
>>>>> A simple view which shows all treatments for a particular hospital
>>>>> could look like this:
>>>>>
>>>>> <f:for each="{hospital.treatments}" as="treatment">
>>>>> Disease: {treatment.disease.name} Treatments: {treatment.number}
>>>>> </f:for>
>>>>>
>>>>> I'd like to sort the results list by disease names.
>>>>>
>>>>> How can i achieve this?
>>>>>
>>>>> I know there's the possibility to set orderings for a query obejct.
>>>>>
>>>>> But in my case there's only one Repository for the aggregate root,
>>>>> namely "Hospitals". How to set orderings for subsidiary entities?
>>>>>
>>>>> Greetings,
>>>>> T
>>>> Really no one any idea?
>>>>
>>>> I think this is a quit common problem and there must be a common
>>>> solution?
>>>>
>>>> Any help will be much appreciated!
>>>
>>> _______________________________________________
>>> TYPO3-project-typo3v4mvc mailing list
>>> TYPO3-project-typo3v4mvc at lists.typo3.org
>>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-typo3v4mvc 
>>>
>>
>
> _______________________________________________
> TYPO3-project-typo3v4mvc mailing list
> TYPO3-project-typo3v4mvc at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-typo3v4mvc