system_integrity_incomplete_attachments.php

<?php
error_reporting(E_ALL);
if ((php_sapi_name() != 'cli')) trigger_error("You can only run this script from the command line\n", E_USER_ERROR);

$SYSTEM_ROOT = (isset($_SERVER['argv'][1])) ? $_SERVER['argv'][1] : '';
if (empty($SYSTEM_ROOT)) {
    echo "ERROR: You need to supply the path to the System Root as the first argument\n";
    exit();
}

if (!is_dir($SYSTEM_ROOT) || !is_readable($SYSTEM_ROOT.'/core/include/init.inc')) {
    echo "ERROR: Path provided doesn't point to a Matrix installation's System Root. Please provide correct path and try again.\n";
    exit();
}

$ACTION = (isset($_SERVER['argv'][2])) ? $_SERVER['argv'][2] : '';
$ACTION = ltrim($ACTION, '-');
if (empty($ACTION) || ($ACTION != 'fix' && $ACTION != 'check')) {
    echo "ERROR: No action specified\n";
    exit();
}//end if

// Define what the script will do later
$CORRECT = FALSE;
if ($ACTION == 'fix') {
    $CORRECT = TRUE;
}//end if

require_once $SYSTEM_ROOT.'/core/include/init.inc';
if (ini_get('memory_limit') != '-1') ini_set('memory_limit', '-1');

$count = 0;
$count_rm = 0;
$count_2 = 0;
$count_rm_2 = 0;

$form_assetids = $GLOBALS['SQ_SYSTEM']->am->getTypeAssetIds('form', FALSE);
foreach ($form_assetids as $assetid) {
    $asset = $GLOBALS['SQ_SYSTEM']->am->getAsset($assetid);
    $complete_link   = $GLOBALS['SQ_SYSTEM']->am->getLink($assetid, SQ_LINK_TYPE_2, 'folder', TRUE, 'submissions_folder');
    $path  = $asset->data_path;
    $path .= '/incomplete_attachments';
    $files = list_dirs($path);
    foreach ($files as $file) {
        if ((strpos($file, 's') === 0) && (assert_valid_assetid(substr($file, 1), '', TRUE, FALSE))) {
            // This is an incomplete submission, so check if the submission is still valid
            $incomplete_submission_assetid = substr($file, 1);
            $incomplete_submission = $GLOBALS['SQ_SYSTEM']->am->getAsset($incomplete_submission_assetid, '', TRUE);
            if (is_null($incomplete_submission)) {
                // Report only
                echo 'Form #'.$assetid.' still has some incomplete attachment directories for non-existent Submission #'.$incomplete_submission_assetid.'.';
                $count++;
                if ($CORRECT) {
                    // Remove the dir, not needed
                    echo ' Removing.';
                    delete_directory($path.'/'.$file);
                    $count_rm++;
                    echo ' Done.';
                }//end if
                echo "\n";
            } else {
                $parents = $GLOBALS['SQ_SYSTEM']->am->getParents($incomplete_submission_assetid, 'folder', TRUE, NULL, NULL, TRUE, 1, 1);
                if (!empty($complete_link) && !empty($parents) && array_key_exists($complete_link['minorid'], $parents)){
                    echo 'Form #'.$assetid.' still has some incomplete attachment directories for completed Submission #'.$incomplete_submission_assetid.'.';
                    $count_2++;
                    if ($CORRECT) {
                        // Remove the dir, not needed
                        echo ' Removing.';
                        delete_directory($path.'/'.$file);
                        $count_rm_2++;
                        echo ' Done.';
                    }//end if
                    echo "\n";
                }
                $GLOBALS['SQ_SYSTEM']->am->forgetAsset($incomplete_submission, TRUE);
            }//end if
            unset($incomplete_submission);
        }//end if
    }//end foreach
    $GLOBALS['SQ_SYSTEM']->am->forgetAsset($asset, TRUE);
    unset($asset);
}//end foreach

echo "Incomplete attachment directories for non-existent submissions found:    ".$count."\n";
echo "Incomplete attachment directories for non-existent submissions deleted:  ".$count_rm."\n";
echo "Incomplete attachment directories for completed submissions found:    ".$count_2."\n";
echo "Incomplete attachment directories for completed submissions deleted:  ".$count_rm_2."\n";
echo "All done!\n";
?>