Model Thread Extending ?

[arms]

Excuse if this seems really basic

I've extend the thread model (with reference to this: http://xenforo.com/community/threads/need-to-join-table-with-xf_thread-can-i.21557/#post-272533)

I've used:

  class PGArms_Model_Thread extends XFCP_PGArms_Model_Thread
{
     
    public function prepareThreadFetchOptions(array $fetchOptions)
      {
    // CALL ORIGINAL
        $threadFetchOptions = parent::prepareThreadFetchOptions($fetchOptions);
     // ADD YOUR OWN JOINS Left join table 
        if(!empty($fetchOptions['join']) )
        {
            $threadFetchOptions['selectFields'] .= ',
                dates.start_date, dates.closing_date';
            $threadFetchOptions['joinTables'] .= '
                LEFT JOIN pg_dates AS dates ON
                (thread.thread_id = dates.thread_id)';
        }            
        return $threadFetchOptions;
    }
}

Which works, and is picking up extra fields.

BUT, how do i get this to only run only within specified nodes? Or doesn't it really have an impact due to the left join?

 

[truonglv]

In case condition you should added: $conditions['node_id'] = $specialNodeId

 

[arms]

In case condition you should added: $conditions['node_id'] = $specialNodeId

So I need to Extend prepareThreadConditions also?

 

[truonglv]

So I need to Extend prepareThreadConditions also?

No. This function already You can using that

$conditions = array(
'node_id' => $specialNodeId
);

 

[arms]

Not sure where to add $conditions.
public function prepareThreadFetchOptions(array $conditions, array $fetchOptions) isn't valid.

I've tried:

class PGArms_Model_Thread extends XFCP_PGArms_Model_Thread
{
      public function prepareThreadFetchOptions(array $fetchOptions)
      {
    // CALL ORIGINAL
        $threadFetchOptions = parent::prepareThreadFetchOptions($fetchOptions);
        $options = XenForo_Application::get('options');

        if('thread.node_id' == $options->MyForumChooser[0])
            {
        // ADD YOUR OWN JOINS Left join table
            if(!empty($fetchOptions['join']) )
                {
                    $threadFetchOptions['selectFields'] .= ',
                        dates.start_date, dates.closing_date';
                    $threadFetchOptions['joinTables'] .= '
                        LEFT JOIN pg_dates AS dates ON
                        (thread.thread_id = dates.thread_id)';
                }
            }         
        return $threadFetchOptions;
    }
}

 

[Daniel Hood]

Extend:

XenForo_Thread_Model::prepareThreadConditions(array $conditions, array &$fetchOptions)

 

[truonglv]

Not sure where to add $conditions.
public function prepareThreadFetchOptions(array $conditions, array $fetchOptions) isn't valid.

I've tried:

class PGArms_Model_Thread extends XFCP_PGArms_Model_Thread
{
      public function prepareThreadFetchOptions(array $fetchOptions)
      {
    // CALL ORIGINAL
        $threadFetchOptions = parent::prepareThreadFetchOptions($fetchOptions);
        $options = XenForo_Application::get('options');

        if('thread.node_id' == $options->MyForumChooser[0])
            {
        // ADD YOUR OWN JOINS Left join table
            if(!empty($fetchOptions['join']) )
                {
                    $threadFetchOptions['selectFields'] .= ',
                        dates.start_date, dates.closing_date';
                    $threadFetchOptions['joinTables'] .= '
                        LEFT JOIN pg_dates AS dates ON
                        (thread.thread_id = dates.thread_id)';
                }
            }        
        return $threadFetchOptions;
    }
}

As I said "This is existing on xenForo". Example code:

$coditions = array(
        'node_id' => $specialNodeId
    );
    $fetchOptions = array(
        // your code for join
    );
   
    $threads = $this->getModelFromCache('XenForo_Model_Thread')->getThreads($coditions, $fetchOptions);