Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

Rev 1882 | Rev 1905 | Ir a la última revisión | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 1882 Rev 1904
Línea 7... Línea 7...
7 
use Laminas\Db\Adapter\AdapterInterface;
 7 
use Laminas\Db\Adapter\AdapterInterface;
8 
use Laminas\Db\Sql\Expression;
 8 
use Laminas\Db\Sql\Expression;
9 
use Laminas\Log\LoggerInterface;
 9 
use Laminas\Log\LoggerInterface;
10 
use LeadersLinked\Mapper\Common\MapperCommon;
 10 
use LeadersLinked\Mapper\Common\MapperCommon;
11 
use LeadersLinked\Model\Feed;
 11 
use LeadersLinked\Model\Feed;
- 
 
 12 
use LeadersLinked\Model\Topic;
12 
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
 13 
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
13 
use Laminas\Paginator\Paginator;
 14 
use Laminas\Paginator\Paginator;
14 
use Laminas\Db\ResultSet\HydratingResultSet;
 15 
use Laminas\Db\ResultSet\HydratingResultSet;
15 
use Laminas\Paginator\Adapter\DbSelect;
 16 
use Laminas\Paginator\Adapter\DbSelect;
- 
 
 17 
use LeadersLinked\Mapper\TopicMapper;
Línea 16... Línea 18...
16 
 
 18 
 
17 
class FeedMapper extends MapperCommon
 19 
class FeedMapper extends MapperCommon
18 
{
 20 
{
Línea 135... Línea 137...
135 
        $paginator->setCurrentPageNumber($page);
 137 
        $paginator->setCurrentPageNumber($page);
Línea 136... Línea 138...
136
138
137
139
- 
 
 140 
        return $paginator;
- 
 
 141 
    }
- 
 
 142 
    public function fetchFiveForoJoinTopic($topic_id)
- 
 
 143 
    {
- 
 
 144 
        $prototype = new Feed();
- 
 
 145 
        $select->from(['t' => TopicMapper::_TABLE]);
- 
 
 146 
        $select->join(['f' => self::_TABLE], 'f.topic_id = t.id', []);
- 
 
 147 
        $select->where->equalTo('f.topic_id', $topic_id);
- 
 
 148 
        $select->where->equalTo('f.status', Feed::STATUS_PUBLISHED);
- 
 
 149 
        $select->where->equalTo('t.type', Topic::TYPE_HPTGF);
- 
 
 150 
        $select->where->equalTo('t.status', Topic::STATUS_ACTIVE);
- 
 
 151
- 
 
 152 
        $select->order('added_on DESC');
- 
 
 153 
 
- 
 
 154 
        $hydrator   = new ObjectPropertyHydrator();
- 
 
 155 
        $resultset  = new HydratingResultSet($hydrator, $prototype);
- 
 
 156
- 
 
 157 
        $adapter = new DbSelect($select, $this->sql, $resultset);
- 
 
 158 
        $paginator = new Paginator($adapter);
- 
 
 159 
        $paginator->setItemCountPerPage(5);
- 
 
 160 
        $paginator->setCurrentPageNumber(1);
- 
 
 161
- 
 
 162
138 
        return $paginator;
 163 
        return $paginator;
139 
    }
 164 
    }
140 
    /**
 165 
    /**
141 
     *
 166 
     *
142 
     * @param int $shared_feed_id
 167 
     * @param int $shared_feed_id