Mediapool - externe Datei in den Medienpool synchronisieren about tricks HOT 3 CLOSED

$transferUploadFilesToMediaPool = static function(rex_media_category $mediaPoolCategory, rex_yform_manager_dataset $dataset) {
    $uploadFiles = [
        'file_1' => $dataset->getValue('file_1'),
        'file_2' => $dataset->getValue('file_2'),
        'file_3' => $dataset->getValue('file_3'),
        'file_4' => $dataset->getValue('file_4'),
    ];

    $moveFiles = [];
    foreach ($uploadFiles as $uploadDir => $uploadFile) {
        if ('' === $uploadFile) {
            continue;
        }

        $path = rex_path::pluginData('yform', 'manager', 'upload/'.$dataset->getTableName().'/'.$uploadDir.'/'.$dataset->getValue('id').'_'.$uploadFile);

        if (!file_exists($path)) {
            continue;
        }

        $data = [];
        $data['title'] = '';
        $data['category_id'] = $mediaPoolCategory->getId();
        $data['file'] = [
            'name' => $uploadFile,
            'path' => $path,
        ];

        try {
            $data = rex_media_service::addMedia($data, true);
            $moveFiles[] = $data['filename'];

            // addMedia verschiebt die Datei
            // Original erhalten lassen
            rex_file::copy(rex_path::media($data['filename']), $path);

        } catch (rex_api_exception $e) {
            throw new rex_functional_exception($e->getMessage());
        }
    }

    $sql = rex_sql::factory();
    $sql->setTable($dataset->getTableName());
    $sql->setWhere('id = :id', ['id' => $dataset->getId()]);
    $sql->setValue('files', implode(',', $moveFiles));

    if ($sql->update()) {
        return true;
    }

    return false;
};