Pagination Problems

Thanks... though this is how I have all of my (long-time already) operational Pagination working, and as mentioned, it works great.

The problem I have is that, to save on a stupid amount of mostly unused indices in the database, I want to do something like this (also the complex calculations would be difficult/impossible to do in a query):

Code:

function myQuery()
{   $sql = "your simple index-based query here";
    $this->db->query($sql);

    // apply user-defined filters that don't rely on an index
    // + custom complex calculations on the query results

    return the filtered/calculated results; // and have Pagination still work
}

Basically, I'd like to be able to have Pagination work with an array of processed data - either from inside a Model (which is where most of the Pagination appears to be embedded), or somehow from inside a Controller.

Update:

I was hopeful when I found the set() method in Model.php (which takes an array as an argument), however, on closer inspection I find it’s only used for 'input' and not for generating results/'output' in methods like paginate().

I see that the HTML Table Class works in a manner close to what I’m looking for, and does accept a user-defined array as an input… however, it doesn’t appear to support pagination.

There is also callback functionality… where one can set up a trigger to do something with the data that has been found…

Code:

$eventData = $this->trigger('afterFind', $eventData);

...though I’ve not come across any documentation detailing its use (to be fair, it’s probably pretty simple to work out without any documentation)... however, in my case, this still looks a bit of pain to implement and if there is a way to somehow get it done from my existing (processed) array, it would be a lot easier.