Changeset 203

Timestamp:

06/30/08 21:27:26 (6 months ago)

Author:

llaumgui

Message:

fetch topic en place ;-)

Location:

ez_publish/ezfluxbb/trunk

Files:

• classes/ezfluxbb.php (modified) (1 diff)
• classes/ezfluxbbfetchfonctions.php (modified) (1 diff)
• modules/ezfluxbb/function_definition.php (modified) (3 diffs)

ez_publish/ezfluxbb/trunk/classes/ezfluxbb.php

@@ -189 +189 @@
         }
 
+        
+
+        /**
+         * Récupération des informations sur des topics
+         * 
+         * @author Guillaume Kulakowski <guillaume_AT_llaumgui_DOT_com>
+         * @since 1.0
+         * 
+         * @return array
+         */
+        public function getTopics( $params )
+        {
+                $db             = eZFluxBBDB::instance();
+                
+                                
+                $topics         = $db->arrayQuery(      'SELECT t.id topic_id, t.poster, t.subject, t.num_replies, p.id post_id, p.message ' .
+                                                                                'FROM '.$this->fluxBBConfig['db_prefix'].'topics t ' .
+                                                                                /* TODO : Rendre la jointure paramÚtrable */
+                                                                                        'LEFT JOIN '.$this->fluxBBConfig['db_prefix'].'posts p ON (p.topic_id=t.id AND t.posted = p.posted) ' .
+                                                                                'WHERE forum_id ' . $params['forum_id'] . ' ' .
+                                                                                'ORDER BY ' . $params['sort_by'] .' ' .
+                                                                                'LIMIT ' . $params['offset'] . ', ' . $params['limit']);
+
+                return $topics;
+        }
+        
+        
+        
 }       //EOC
  

ez_publish/ezfluxbb/trunk/classes/ezfluxbbfetchfonctions.php

@@ -100 +100 @@
          * @return array
          */
-        function fetchTopics()
+        function fetchTopics( $forum_id_filter_type, $forum_id_filter_array, $limit, $offset, $sort_by )
         {
-                //$eZFluxBB             = eZFluxBB::instance();
-                //$currentUser  = $eZFluxBB->getCurrentUserInfo();
-                //print_r($currentUser);
+                $sortingString          = 't.posted';
+                $sortOrder                      = true; // true is ascending
+                $sortingForum_id        = 'IN';
                 
-                $result                 = array( 'result' => array( ) );
-                return $result;
+                /* Sort_by */
+                if ( is_array($sort_by) )
+                {
+                        if ( array_key_exists(0, $sort_by) && !empty($sort_by[0]) )
+                {
+                        $sortingString  = $sort_by[0];
+                }
+                if ( array_key_exists(1, $sort_by) && is_bool($sort_by[1]) ) 
+                {
+                        $sortOrder              = $sort_by[1];
+                }
+                }
+                else
+                {
+                if ( !empty($sort_by ) )
+                {
+                        $sortingString = $sort_by;
+                }
+                
+        }
+                $sortingOrder   = $sortOrder ? ' ASC' : ' DESC';
+                
+                /* $forum_id */
+        if ( $forum_id_filter_type == 'exclude' )
+        {
+                $sortingForum_id        = 'NOT IN';
+        }
+        if ( is_array( $forum_id_filter_array ) )
+        {
+                $sortingForum_id        .= ' (' . implode( ', ', $forum_id_filter_array) . ')';
+        }
+        else
+        {
+                $sortingForum_id        .= ' (' . $forum_id_filter_array . ')';
+        }
+                                
+                $eZFluxBB               = eZFluxBB::instance();
+                $params                 = array(        'forum_id'                                      => $sortingForum_id,
+                                                                        'limit'                                         => $limit,
+                                                                        'offset'                                        => $offset,
+                                                                        'sort_by'                                       => $sortingString . ' ' . $sortingOrder );
+                
+                $topics                 = $eZFluxBB->getTopics( $params );
+
+                return array( 'result' => $topics );
         }
 }

ez_publish/ezfluxbb/trunk/modules/ezfluxbb/function_definition.php

@@ -84 +84 @@
                                 'type'     => 'string',
                                 'required' => false,
-                                'default'  => false
+                                'default'  => 'include'
                 ),
                 array(  'name'     => 'forum_id_filter_array',
-                                'type'     => 'string',
+                                'type'     => 'mixed',
                                 'required' => false,
                                 'default'  => false
@@ -96 +96 @@
                                 'default'  => 20
                 ),
-                array(  'name'     => 'sort_by',
-                                'type'     => 'array',
-                                'required' => false,
-                                'default'  => array( 'last_post', false )
-                ),
                 array(  'name'     => 'offset',
                                 'type'     => 'integer',
@@ -106 +101 @@
                                 'default'  => 0
                 ),
+                array(  'name'     => 'sort_by',
+                                'type'     => 'array',
+                                'required' => false,
+                                'default'  => array( 't.posted', false )
+                ),
         )
 );