/**
* Remove any media files
*
* @param Application $application
* @return void
*/
public static function removeMedia(Application $application)
{
$uploadFolder = BASE_PATH . CONTENT_PATH . '/files';
$mediaLibrary = $application->module('phire-fields')->config()['media_library'];
if ($_POST && isset($_POST['rm_media']) && null !== $mediaLibrary && $application->isRegistered('phire-media')) {
$media = new \Phire\Media\Model\Media();
$fields = Table\Fields::findBy(['type' => 'file']);
$fieldIds = [];
foreach ($fields->rows() as $field) {
$fieldIds[$field->id] = $field->name;
}
foreach ($_POST['rm_media'] as $mid) {
$media->getById($mid);
if (isset($media->id) && !empty($media->file)) {
$sql = Table\FieldValues::sql();
$sql->select()->where('value LIKE :value');
$fv = Table\FieldValues::execute((string) $sql, ['value' => '%"' . $media->file . '"%']);
// Remove field value media files from EAV field table
if ($fv->count() > 0) {
if (file_exists($_SERVER['DOCUMENT_ROOT'] . $uploadFolder . '/' . $media->file)) {
unlink($_SERVER['DOCUMENT_ROOT'] . $uploadFolder . '/' . $media->file);
}
foreach ($fv->rows() as $val) {
$v = json_decode($val->value);
if (is_array($v) && in_array($media->file, $v)) {
$sql = Table\FieldValues::sql();
$sql->select()->where('field_id = :field_id')->where('model_id = :model_id')->where('value LIKE :value');
$f = Table\FieldValues::execute((string) $sql, ['field_id' => $val->field_id, 'model_id' => $val->model_id, 'value' => '%"' . $media->file . '"%']);
if (isset($f->field_id)) {
unset($v[array_search($media->file, $v)]);
if (count($v) > 0) {
$v = array_values($v);
$f->value = json_encode($v);
$f->save();
} else {
$f->delete();
}
}
} else {
$f = Table\FieldValues::findBy(['field_id' => $val->field_id, 'model_id' => $val->model_id, 'value' => '"' . $media->file . '"']);
$f->delete();
}
}
}
// Remove field value media files from field tables
foreach ($fieldIds as $fieldId => $fieldName) {
$fv = new Record();
$fv->setPrefix(DB_PREFIX)->setPrimaryKeys(['id'])->setTable('field_' . $fieldName);
$sql = $fv->getSql();
$sql->select()->where('value LIKE :value');
$fv->executeStatement($sql, ['value' => '%"' . $media->file . '"%']);
if ($fv->count() > 0) {
if (file_exists($_SERVER['DOCUMENT_ROOT'] . $uploadFolder . '/' . $media->file)) {
unlink($_SERVER['DOCUMENT_ROOT'] . $uploadFolder . '/' . $media->file);
}
foreach ($fv->rows() as $val) {
$f = new Record();
$f->setPrefix(DB_PREFIX)->setPrimaryKeys(['id'])->setTable('fields_' . $fieldName);
$f->findRecordById($val->id);
if (isset($f->id)) {
$f->delete();
}
}
}
}
}
}
}
}
