test_dead_assets.inc

<?php
class Test_Dead_Assets
{


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

    }//end getName()


    public static function getDescription()
    {
        return 'A test to check for dead assets in the link table in Matrix';

    }//end getDescription()


    public static function test(&$messages, &$errors)
    {
        $status = TRUE;
        $minor_sql = 'SELECT minorid FROM sq_ast_lnk WHERE minorid NOT IN (select assetid FROM sq_ast) AND linkid <> 1';
        $minor_result = MatrixDAL::executeSqlAssoc($minor_sql);

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

        if (!empty($minor_result)) {
            $status = FALSE;
            foreach ($minor_result as $result) {
                $errors[] = 'Asset #'.$result.' was not found on the system';
            }//end foreach
        }//end if
        $major_sql = 'SELECT majorid FROM sq_ast_lnk WHERE majorid NOT IN (SELECT assetid FROM sq_ast) AND linkid <> 1';
        $major_result = MatrixDAL::executeSqlAssoc($major_sql);

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

        if (!empty($major_result)) {
            $status = FALSE;
            foreach ($major_result as $result) {
                $errors[] = 'Asset #'.$result.' was not found on the system';
            }//end foreach
        }//end if
        
        if (!$status) {
            $count = count($minor_result) + count($major_result);
            $messages[] = 'There are '.$count.' dead asset(s) on the system';
        }//end if
        
        return $status;

    }//end test()

}//end class
?>