test_orphan_assets.inc

<?php
class Test_Orphan_Assets
{


    public static function getName()
    {
        return 'Orphaned Assets Test';

    }//end getName()


    public static function getDescription()
    {
        return 'A test to check for orphaned assets in Matrix';

    }//end getDescription()


    public static function test(&$messages, &$errors)
    {
        $status = TRUE;
        $sql = 'SELECT assetid FROM sq_ast WHERE assetid NOT IN (SELECT minorid AS assetid FROM sq_ast_lnk WHERE link_type < 8)';
        $results = MatrixDAL::executeSqlAssoc($sql);
        if (!empty($results)) {

            foreach ($results as $index => $result) {
                $results[$index] = $result['assetid'];
            }
            $results = array_unique($results);

            $status = FALSE;
            $messages[] = 'There are '.count($results).' orphaned asset(s) on the system';
            foreach ($results as $asset) {
                $errors[] = 'Asset #'.$asset.' is orphaned on the system';
            }//end foreach
        }//end if

        return $status;

    }//end test()

}//end class
?>