Help me with pagination with query builder

Here is my model

PHP Code:

//* Get blog in admin
    public function getActiveBlogsInAdmin()
    {
        $table = $this->db->table('zd_blogs');
        $table->select('*');
        $table->join('zd_main_cats', 'zd_main_cats.main_cat_id = zd_blogs.blog_main_cat', 'left');
        $table->join('zd_users', 'zd_users.user_id = zd_blogs.blog_user', 'left');
        $table->where('zd_blogs.blog_status', 1);
        $table->where('zd_blogs.blog_deleted', 0);
        $table->orderBy('zd_blogs.blog_id', 'DESC');
        $query = $table->get();
        if($table->countAllResults() > 0)
        {
            return $query->getResult();
        }
        else
        {
            return FALSE;
        }
    } 


And here is my controller

PHP Code:

$blog = new BlogModel();

                //* Retrieve blogs
                $blogs = $blog->getActiveBlogsInAdmin();
                //$pages = $pager->makeLinks($page, $perPage, $total);
                return $this->smarty->view('blog/active.tpl', compact(
                    'blogs'
                )); 


I have over and over again read docs it could not give sample for query builder am totaly confuse. please any help is appreciated.

PHP Code:

public function postPaginate($where, $perPage = null, $group = 'default', $page = null, $segment = 0){

        $pager = Services::pager(null, null, false);

        $query = $this->db->table('cms_property')
                ->select('cms_property.*')
                ->select('cms_property_category.name as c_name, cms_property_category.slug as c_slug')
                ->select('cms_property_type.name as t_name')
                ->select('cms_property_area.name as a_name')
                ->select('cms_property_direction.name as d_name')
                ->where($where)
                ->join('cms_property_category', 'cms_property_category.id = cms_property.typeofhouse', 'left')
                ->join('cms_property_type', 'cms_property_type.id = cms_property.p_type', 'left')
                ->join('cms_property_area', 'cms_property_area.id = cms_property.location_area', 'left')
                ->join('cms_property_direction', 'cms_property_direction.id = cms_property.direction', 'left');

        if ($segment)
        {
            $pager->setSegment($segment);
        }

        $page = $page >= 1 ? $page : $pager->getCurrentPage($group);
        $this->pager = $pager->store($group, $page, $perPage, $query->get()->getNumRows(), $segment);
        $perPage     = $this->pager->getPerPage($group);
        $offset      = ($page - 1) * $perPage;

        return $this->limit($perPage, $offset)->get()->getResultArray();
    } 


This is my model function )