Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

Rev 4113 | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 4113 Rev 4632
Línea 150... Línea 150...
150 
     * @param int $records_per_page
 150 
     * @param int $records_per_page
151 
     * @param string $order_field
 151 
     * @param string $order_field
152 
     * @param string $order_direction
 152 
     * @param string $order_direction
153 
     * @return Paginator
 153 
     * @return Paginator
154 
     */
 154 
     */
155 
    public function fetchAllDataTable($search, $page = 1, $records_per_page = 10, $order_field= 'name', $order_direction = 'ASC')
 155 
    public function fetchAllDataTableDefault($search, $page = 1, $records_per_page = 10, $order_field= 'name', $order_direction = 'ASC')
156 
    {
 156 
    {
157 
        $select = $this->sql->select();
 157 
        $select = $this->sql->select();
158 
        $select->columns(['id', 'uuid', 'name', 'status']);
 158 
        $select->columns(['id', 'uuid', 'name', 'status']);
159 
        $select->from(['c' => self::_TABLE]);
 159 
        $select->from(['c' => self::_TABLE]);
160 
        $select->join(['ct' => CompetencyTypeMapper::_TABLE], 'c.competency_type_id =  ct.id', ['type' => 'name']);
 160 
        $select->join(['ct' => CompetencyTypeMapper::_TABLE], 'c.competency_type_id =  ct.id', ['type' => 'name']);
161
- 
 
- 
 
 161 
        $select->where->isNull('c.company_id');
162 
        if($search) {
 162 
        if($search) {
163 
            $select->where->like('c.name', '%' . $search . '%')->or->like('ct.name', '%' . $search . '%');
 163 
            $select->where->like('c.name', '%' . $search . '%')->or->like('ct.name', '%' . $search . '%');
164 
        }
 164 
        }
- 
 
 165
- 
 
 166
165 
        $select->order($order_field . ' ' . $order_direction);
 167 
        $select->order($order_field . ' ' . $order_direction);
Línea 166... Línea 168...
166
168
Línea 167... Línea 169...
167 
        $resultset  = new HydratingResultSet();
 169 
        $resultset  = new HydratingResultSet();