Proyectos de Subversion LeadersLinked - Services

Rev

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

Rev 283 Rev 333
Línea 159... Línea 159...
159 
                $dbSelect = new DbSelect($select, $this->adapter);
 159 
                $dbSelect = new DbSelect($select, $this->adapter);
160 
                $paginator = new Paginator($dbSelect);
 160 
                $paginator = new Paginator($dbSelect);
161 
                $paginator->setCurrentPageNumber($page ? $page : 1);
 161 
                $paginator->setCurrentPageNumber($page ? $page : 1);
162 
                $paginator->setItemCountPerPage(10);
 162 
                $paginator->setItemCountPerPage(10);
Línea 163... Línea 163...
163
163
Línea 164... Línea 164...
164 
                $storage = Storage::getInstance($this->config);
 164 
                $storage = Storage::getInstance($this->config, $this->adapter);
165
165
166 
                $records = $paginator->getCurrentItems();
 166 
                $records = $paginator->getCurrentItems();
167 
                $items = [];
 167 
                $items = [];
Línea 254... Línea 254...
254 
                if($search) {
 254 
                if($search) {
255 
                    $select->where->NEST->like('first_name', '%' . $search . '%')->or->like('last_name', '%' . $search . '%')->UNNEST;
 255 
                    $select->where->NEST->like('first_name', '%' . $search . '%')->or->like('last_name', '%' . $search . '%')->UNNEST;
256 
                }
 256 
                }
257 
                $select->order('first_name ASC, last_name ASC');
 257 
                $select->order('first_name ASC, last_name ASC');
Línea 258... Línea 258...
258
258
259 
                $storage = Storage::getInstance($this->config);
 259 
                $storage = Storage::getInstance($this->config, $this->adapter);
260 
                $records = $queryMapper->fetchAll($select);
 260 
                $records = $queryMapper->fetchAll($select);
261 
                $items = [];
 261 
                $items = [];
262 
                foreach($records as $record)
 262 
                foreach($records as $record)
263 
                {
 263 
                {
Línea 316... Línea 316...
316 
                if($search) {
 316 
                if($search) {
317 
                    $select->where->NEST->like('first_name', '%' . $search . '%')->or->like('last_name', '%' . $search . '%')->UNNEST;
 317 
                    $select->where->NEST->like('first_name', '%' . $search . '%')->or->like('last_name', '%' . $search . '%')->UNNEST;
318 
                }
 318 
                }
319 
                $select->order('first_name ASC, last_name ASC');
 319 
                $select->order('first_name ASC, last_name ASC');
Línea 320... Línea 320...
320
320
321 
                $storage = Storage::getInstance($this->config);
 321 
                $storage = Storage::getInstance($this->config, $this->adapter);
322 
                $records = $queryMapper->fetchAll($select);
 322 
                $records = $queryMapper->fetchAll($select);
323 
                $items = [];
 323 
                $items = [];
324 
                foreach($records as $record)
 324 
                foreach($records as $record)
325 
                {
 325 
                {
Línea 955... Línea 955...
955 
                }
 955 
                }
956 
                $select->order('first_name ASC, last_name ASC');
 956 
                $select->order('first_name ASC, last_name ASC');
Línea 957... Línea 957...
957
957
Línea 958... Línea 958...
958 
                //echo $select->getSqlString($this->adapter->platform); exit;
 958 
                //echo $select->getSqlString($this->adapter->platform); exit;
959
959
960 
                $storage = Storage::getInstance($this->config);
 960 
                $storage = Storage::getInstance($this->config, $this->adapter);
961 
                $records = $queryMapper->fetchAll($select);
 961 
                $records = $queryMapper->fetchAll($select);
962 
                $items = [];
 962 
                $items = [];
Línea 1156... Línea 1156...
1156 
                $paginator->setItemCountPerPage(12);
 1156 
                $paginator->setItemCountPerPage(12);
Línea 1157... Línea 1157...
1157
1157
1158
1158
1159 
                $items = [];
 1159 
                $items = [];
Línea 1160... Línea 1160...
1160 
                $records = $paginator->getCurrentItems();
 1160 
                $records = $paginator->getCurrentItems();
1161 
                $storage = Storage::getInstance($this->config);
 1161 
                $storage = Storage::getInstance($this->config, $this->adapter);
1162
1162