/home/joan/000www/repo/spirit/1.0/core/extensions/db/behaviors/paginate.php

Ir a la documentación de este archivo.

<?php
class Paginator {
        
        public static function paginate() {
                $params = Util::getParams(func_get_args());
                
                $page_number = isset($params['page']) ? $params['page'] : 1;
                $per_page = isset($params['per_page']) ? $params['per_page'] : 10;
                $start = $per_page*($page_number-1);
                
                $page = new stdClass();
                
                if(is_array($params[0])) {
                        $items = $params[0];
                        $n = count($items);
                        $page->items = array_slice($items, $start, $per_page);
                } else {
                
                        if(is_string($params[0])) {
                                $m = Util::camelcase($params[0]);
                                $model = ActiveRecord::get($m);
                        } else {
                                $model = $params[0];
                        }
                
                        $find_args = array();
                        $conditions = null;
                        if(isset($params['conditions'])) {
                                $conditions = $params['conditions'];
                        }elseif(isset($params[1])) {
                                $conditions = $params[1];
                        }
        
                        if(isset($params['columns'])) {
                                array_push($find_args, "columns: {$params['columns']}");
                        }
                        if(isset($params['join'])) {
                                array_push($find_args, "join: {$params['join']}");
                        }
                        if(isset($params['group'])) {
                                array_push($find_args, "group: {$params['group']}");
                        }
                        if(isset($params['having'])) {
                                array_push($find_args, "having: {$params['having']}");
                        }
                        if(isset($params['order'])) {
                                array_push($find_args, "order: {$params['order']}");
                        }
                        if(isset($params['distinct'])) {
                                array_push($find_args, "distinct: {$params['distinct']}");
                        }
                        if(isset($conditions)) {
                                array_push($find_args, $conditions);
                        }
                        
                        //$n = call_user_func_array(array($model, 'count'), $find_args);
                        $n = call_user_func_array(array($model, 'count'), $conditions);
                        
                        array_push($find_args, "offset: $start");
                        array_push($find_args, "limit: $per_page");
                        
                        $page->items = call_user_func_array(array($model, 'find'), $find_args);
                }
                
                $page->next = ($start + $per_page)<$n ? ($page_number+1) : false ;
                $page->prev = ($page_number>1) ? ($page_number-1) : false ;
                $page->current = $page_number;
                $page->total = ($n % $per_page) ? ((int)($n/$per_page) + 1):($n/$per_page);
                $page->count = $n;
                
                return $page;
        }
        
        public static function paginate_by_sql($model, $sql) {
                $params = Util::getParams(func_get_args());
                
                $page_number = isset($params['page']) ? $params['page'] : 1;
                $per_page = isset($params['per_page']) ? $params['per_page'] : 10;
                $start = $per_page*($page_number-1);
        
                if(is_string($params[0])) {
                        $m = Util::camelcase($params[0]);
                        $model = ActiveRecord::get($m);
                }
        
                $page = new stdClass();
        
                $n = $model->count_by_sql("SELECT COUNT(*) FROM ($sql) AS t");
                $page->items = $model->find_all_by_sql($model->limit($sql, "offset: $start", "limit: $per_page"));
        
                $page->next = ($start + $per_page)<$n ? ($page_number+1) : false ;
                $page->prev = ($page_number>1) ? ($page_number-1) : false ;
                $page->current = $page_number;
                $page->total = ($n % $per_page) ? ((int)($n/$per_page) + 1):($n/$per_page);
                $page->count = $n;
                
                return $page;
        }
}

---