test_broken_sort_order.inc

<?php
class Test_Broken_Sort_Order
{


    public static function getName()
    {
        return 'Broken Sort Order Test';

    }//end getName()


    public static function getDescription()
    {
        return 'A test to find any broken sort order on the links table';

    }//end getDescription()


    public static function test(&$messages, &$errors)
    {
        $status = TRUE;

        // Find the maximum sort order and count the links
        $sql = 'SELECT majorid, MAX(sort_order) AS max, count(*) AS count FROM sq_ast_lnk WHERE majorid IN (SELECT DISTINCT majorid FROM sq_ast_lnk) GROUP BY majorid';
        $results = MatrixDAL::executeSqlAssoc($sql);
        if (!empty($results)) {
            $count = 0;
            foreach ($results as $result) {
                if (($result['max'] + 1) != ($result['count'])) {
                    $status = FALSE;
                    $errors[] = 'The Asset #'.$result['majorid'].' has '.$result['count'].' assets underneath, but the sort order finishes at '.$result['max'];
                    $count++;
                }//end if
            }//end foreach
            if (!$status && !empty($count)) {
                $messages[] = 'There are '.$count.' broken sort orders found on the system';
            }//end if
        }//end if

        return $status;

    }//end test()

}//end class
?>