mod_flexicontent - tri par champ date

case 'catorder': ...... break;

case 'catorder': if ($params->get('orderbycustomfieldid', 0) != 0) { if ($params->get('orderbycustomfieldint', 0) != 0) $int = ' + 0'; else $int =''; $filter_order = 'f.value'.$int; $filter_order_dir = $params->get('orderbycustomfielddir', 'ASC'); } $orderby = ' ORDER BY '.$filter_order.' '.$filter_order_dir; $orderby .= $filter_order!='i.title' ? ', i.title' : ''; // Order by title after default ordering $join_customordering = ''; if ($params->get('orderbycustomfieldid', 0) != 0) { $join_customordering = ' LEFT JOIN #__flexicontent_fields_item_relations AS f ON f.item_id = i.id AND f.field_id='.(int)$params->get('orderbycustomfieldid', 0); } break;

. $join_date

. $join_customordering

<field name="" type="separator" default="FLEXI_CUSTOM_ORDER" description="" level="level3" /> <field name="orderbycustomfieldid" type="fields" exclude_field_type="toolbar,file,image" isnotcore="1" default="0" label="FLEXI_PRIMARY_ORDER_CUSTOM_FIELD_ID" description="FLEXI_PRIMARY_ORDER_CUSTOM_FIELD_ID_DESC" /> <field name="orderbycustomfielddir" type="list" default="ASC" label="FLEXI_PRIMARY_ORDER_CUSTOM_FIELD_DIR" description="FLEXI_PRIMARY_ORDER_CUSTOM_FIELD_DIR_DESC" > <option value="ASC">FLEXI_ASC</option> <option value="DESC">FLEXI_DESC</option> </field> <field name="orderbycustomfieldint" type="list" default="0" label="FLEXI_PRIMARY_ORDERING_METHOD" description="FLEXI_PRIMARY_ORDERING_METHOD_DESC" > <option value="0">FLEXI_ALPHANUMERIC</option> <option value="1">FLEXI_NUMERIC</option> </field>

SELECT i.*, ie.*, ty.name AS typename, cr.rating_sum as rating_sum, cr.rating_count as rating_count, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, GROUP_CONCAT(rel.catid SEPARATOR ",") as itemcats FROM #__content AS i LEFT JOIN #__flexicontent_items_ext AS ie on ie.item_id = i.id LEFT JOIN #__flexicontent_types AS ty on ie.type_id = ty.id LEFT JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN #__categories AS c ON c.id = rel.catid LEFT JOIN #__content_rating AS cr ON cr.content_id = i.id WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2012-12-17 15:14:39' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2012-12-17 15:14:39' ) AND i.access <= 1 AND i.id <> 0 AND i.state IN ( 1, -5 ) GROUP BY i.id ORDER BY f.value ASC, i.title Unknown column 'f.value' in 'order clause' SQL=SELECT i.*, ie.*, ty.name AS typename, cr.rating_sum as rating_sum, cr.rating_count as rating_count, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, GROUP_CONCAT(rel.catid SEPARATOR ",") as itemcats FROM hpstl_content AS i LEFT JOIN hpstl_flexicontent_items_ext AS ie on ie.item_id = i.id LEFT JOIN hpstl_flexicontent_types AS ty on ie.type_id = ty.id LEFT JOIN hpstl_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN hpstl_categories AS c ON c.id = rel.catid LEFT JOIN hpstl_content_rating AS cr ON cr.content_id = i.id WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2012-12-17 15:14:39' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2012-12-17 15:14:39' ) AND i.access <= 1 AND i.id <> 0 AND i.state IN ( 1, -5 ) GROUP BY i.id ORDER BY f.value ASC, i.title LIMIT 0, 10