FuelPHP Forums

Well, I'm working on a project that will be using modules fairly heavily, and am trying to make module installations as simple as possible. One thing thing I'm running into now while extending Model queries from a module is changing the sort order. Here is an example

//model
$query = DB::select('id', 'name')->from('users')->order_by('name');

//module adds a new column to select from and wants to order by something other than name without having to rebuild the query
$query->select('order')->order_by('order');

//issue is, it still take in 'name' sorting before 'order' sorting

//need something to clear out the $_order_by var in the class - fully, 1 part or sections based of column name
// or an insert_(before/after) column name to change the ordering.. something like
$query->clear('order_by')

//or
$query->clear('order_by', 'name')

//or
$query->order_by_before('name', 'order')

I will probably be working on something like this soon for my personal project. My question: is this something other people would find valuable? If so I might spend some more time on it to make a commit. If you would find this useful and have any suggestions/input.. feel free to let me know.