Simple function to enable sorting on the model

simplesort.php

<?php
class AppModel extends Model {
    public function sort($ids, $orderField = 'order') {
        if ($ids && is_array($ids)) {
            $count = count($ids);

            $query = array();

            $query[] = "UPDATE `{$this->table}`";
            $query[] = "SET `{$orderField}` = CASE `{$this->primaryKey}`";

            for ($i = 0; $i < $count; $i++) {
                $position = $i + 1;
                $query[] = "WHEN {$ids[$i]} THEN {$position}";
            }

            $query[] = "END";
            $query[] = "WHERE `{$this->primaryKey}` IN (";
            $query[] = implode(", ", $ids);
            $query[] = ")";

            return $this->query(implode(" ", $query));
        }

        return false;
    }
}