public static function bulk_delete($artefactids)
{
global $USER;
require_once 'group.php';
if (empty($artefactids)) {
return;
}
$idstr = join(',', array_map('intval', $artefactids));
db_begin();
// Get the size of all the files we're about to delete that belong to
// the user.
if ($group = group_current_group()) {
$totalsize = get_field_sql('
SELECT SUM(size)
FROM {artefact_file_files} f JOIN {artefact} a ON f.artefact = a.id
WHERE a.group = ? AND f.artefact IN (' . $idstr . ')', array($group->id));
} else {
$totalsize = get_field_sql('
SELECT SUM(size)
FROM {artefact_file_files} f JOIN {artefact} a ON f.artefact = a.id
WHERE a.owner = ? AND f.artefact IN (' . $idstr . ')', array($USER->get('id')));
}
// Get all fileids so that we can delete the files on disk
$filetodeleteids = get_column_sql('
SELECT fileid
FROM {artefact_file_files} aff1
WHERE artefact IN (' . $idstr . ')
GROUP BY fileid
HAVING COUNT(aff1.artefact) IN
(SELECT COUNT(aff2.artefact)
FROM {artefact_file_files} aff2
WHERE aff1.fileid = aff2.fileid)', null);
// The current rule is that file deletion should be logged in the artefact_log table
// only for group-owned files. To save time we will be slightly naughty here and
// log deletion for all these files if at least one is group-owned.
$log = (bool) count_records_select('artefact', 'id IN (' . $idstr . ') AND "group" IS NOT NULL');
delete_records_select('artefact_attachment', 'attachment IN (' . $idstr . ')');
delete_records_select('artefact_file_files', 'artefact IN (' . $idstr . ')');
parent::bulk_delete($artefactids, $log);
foreach ($filetodeleteids as $filetodeleteid) {
$file = get_config('dataroot') . self::get_file_directory($filetodeleteid) . '/' . $filetodeleteid;
if (is_file($file)) {
unlink($file);
}
}
if ($totalsize) {
if ($group) {
group_quota_remove($group->id, $totalsize);
} else {
$USER->quota_remove($totalsize);
$USER->commit();
}
}
db_commit();
}
public static function bulk_delete($artefactids)
{
global $USER;
if (empty($artefactids)) {
return;
}
$idstr = join(',', array_map('intval', $artefactids));
db_begin();
// Get the size of all the files we're about to delete that belong to
// the user.
$totalsize = get_field_sql('
SELECT SUM(size)
FROM {artefact_file_files} f JOIN {artefact} a ON f.artefact = a.id
WHERE a.owner = ? AND f.artefact IN (' . $idstr . ')', array($USER->get('id')));
// Get all fileids so that we can delete the files on disk
$fileids = get_records_select_assoc('artefact_file_files', 'artefact IN (' . $idstr . ')', array());
$fileidcounts = get_records_sql_assoc('
SELECT fileid, COUNT(fileid) AS fileidcount
FROM {artefact_file_files}
WHERE artefact IN (' . $idstr . ')
GROUP BY fileid', null);
// The current rule is that file deletion should be logged in the artefact_log table
// only for group-owned files. To save time we will be slightly naughty here and
// log deletion for all these files if at least one is group-owned.
$log = (bool) count_records_select('artefact', 'id IN (' . $idstr . ') AND "group" IS NOT NULL');
delete_records_select('artefact_attachment', 'attachment IN (' . $idstr . ')');
delete_records_select('artefact_file_files', 'artefact IN (' . $idstr . ')');
parent::bulk_delete($artefactids, $log);
foreach ($fileids as $r) {
// Delete the file on disk if there's only one artefact left pointing to it
if ($fileidcounts[$r->fileid]->fileidcount == 1) {
$file = get_config('dataroot') . self::get_file_directory($r->fileid) . '/' . $r->fileid;
if (is_file($file)) {
unlink($file);
}
}
$fileidcounts[$r->fileid]->fileidcount--;
}
if ($totalsize) {
$USER->quota_remove($totalsize);
$USER->commit();
}
db_commit();
}
