LaravelH5pRepository::loadAddons() - Code Metrics - Inspection of "Update LaravelH5pRepository.php" - djoudi/Laravel-H5P - Measure and Improve Code Quality continuously with Scrutinizer

Completed
Push — master ( 61d47b...f50d69 )

by Abdelouahab
created 2019-07-21 20:22 UTC
LaravelH5pRepository::loadAddons() A

↳ Parent: LaravelH5pRepository
Complexity

Conditions	1
Paths	1
Size

Total Lines	1
Code Lines	0
Duplication

Lines	0
Ratio	0 %
Importance

Changes	1
Bugs	0	Features	0
Metric	Value
cc	1
eloc	0
c	1
b	0
f	0
nc	1
nop	0
dl	0
loc	1
rs	10
<?php

/*
 *
 * @Project        Laravel framework integration class
 * @Copyright      Djoudi
 * @Created        2018-2-20
 * @Filename       H5PLaravel.php
 * @Description
 *
 */

namespace Djoudi\LaravelH5p\Repositories;

use Carbon\Carbon;
use DB;
use Djoudi\LaravelH5p\Eloquents\H5pContent;
use Djoudi\LaravelH5p\Eloquents\H5pContentsLibrary;
use Djoudi\LaravelH5p\Eloquents\H5pContentsUserData;
use Djoudi\LaravelH5p\Eloquents\H5pLibrariesLibrary;
use Djoudi\LaravelH5p\Eloquents\H5pLibrary;
use Djoudi\LaravelH5p\Eloquents\H5pResult;
use Djoudi\LaravelH5p\Events\H5pEvent;
use Djoudi\LaravelH5p\Helpers\H5pHelper;
use GuzzleHttp\Client;
use H5PFrameworkInterface;
use Illuminate\Support\Facades\App;

class LaravelH5pRepository implements H5PFrameworkInterface
{
    public $_download_file = '';

    /**
     * Kesps track of messages for the user.
     *
     * @since 1.0.0
     *
     * @var array
     */
    protected $messages = ['error' => [], 'updated' => []];



     public function loadAddons();
     public function getLibraryConfig($libraries = NULL);  
     public function libraryHasUpgrade($library); 

    /**
     * Implements setErrorMessage.
     */
    public function setErrorMessage($message, $code = null)
    {
        if (H5pHelper::current_user_can('edit_h5p_contents')) {
            $this->messages['error'][] = $message;
        }
    }

    /**
     * Implements setInfoMessage.
     */
    public function setInfoMessage($message)
    {
        if (H5pHelper::current_user_can('edit_h5p_contents')) {
            $this->messages['updated'][] = $message;
        }
    }

    /**
     * Return the selected messages.
     *
     * @since 1.0.0
     *
     * @param string $type
     *
     * @return array
     */
    public function getMessages($type)
    {
        return isset($this->messages[$type]) ? $this->messages[$type] : null;
    }

    /**
     * Implements t.
     */
    public function t($message, $replacements = [])
    {
        // Insert !var as is, escape @var and emphasis %var.
        foreach ($replacements as $key => $replacement) {
            if ($key[0] === '@') {
//                $replacements[$key] = esc_html($replacement);
                $replacements[$key] = $replacement;
            } elseif ($key[0] === '%') {
//                $replacements[$key] = '<em>' . esc_html($replacement) . '</em>';
                $replacements[$key] = '<em>'.$replacement.'</em>';
            }
        }
        $message = preg_replace('/(!|@|%)[a-z0-9]+/i', '%s', $message);

        // Assumes that replacement vars are in the correct order.
        return vsprintf(trans($message), $replacements);
        return vsprintf(/** @scrutinizer ignore-type */ trans($message), $replacements);
    }

    /**
     * Helper.
     */
    private function getH5pPath()
    {
        return url('vendor/h5p/h5p-core/');
    }

    /**
     * Get the URL to a library file.
     */
    public function getLibraryFileUrl($libraryFolderName, $fileName)
    {
        return url('vendor/h5p/h5p-core/'.$libraryFolderName.'/'.$fileName);
    }

    /**
     * Implements getUploadedH5PFolderPath.
     */
    public function getUploadedH5pFolderPath()
    {
        static $dir;
        if (is_null($dir)) {
            $plugin = App::make('LaravelH5p');
            $dir = $plugin::$core->fs->getTmpPath();
        }

        return $dir;
    }

    /**
     * Implements getUploadedH5PPath.
     */
    public function getUploadedH5pPath()
    {
        static $path;
        if (is_null($path)) {
            $plugin = App::make('LaravelH5p');
            $path = $plugin::$core->fs->getTmpPath().'.h5p';
        }

        return $path;
    }

    /**
     * Implements getLibraryId.
     */
    public function getLibraryId($name, $majorVersion = null, $minorVersion = null)
    {
        $where = H5pLibrary::select()->where('name', $name);

        if ($majorVersion !== null) {
            $where->where('major_version', $majorVersion);
            if ($minorVersion !== null) {
                $where->where('minor_version', $minorVersion);
            }
        }

        $return = $where->orderBy('major_version', 'DESC')
            ->orderBy('minor_version', 'DESC')
            ->orderBy('patch_version', 'DESC')
            ->first();

        return $return === null ? false : $return->id;

    }

    /**
     * Implements isPatchedLibrary.
     */
    public function isPatchedLibrary($library)
    {
        if (defined('H5P_DEV') && H5P_DEV) {

            return true;
        }
        $operator = $this->isInDevMode() ? '<=' : '<';

        $return = DB::table('h5p_libraries')
            ->where('name', $library['machineName'])
            ->where('major_version', $library['majorVersion'])
            ->where('minor_version', $library['minorVersion'])
            ->where('patch_version', $operator, $library['patchVersion'])
            ->first();

        return $return !== null;
    }

    /**
     * Implements isInDevMode.
     */
    public function isInDevMode()
    {
        return config('laravel-h5p.H5P_DEV');
    }

    /**
     * Implements mayUpdateLibraries.
     */
    public function mayUpdateLibraries()
    {
        return H5pHelper::current_user_can('manage_h5p_libraries');
    }

    /**
     * Implements getLibraryUsage.
     */
    public function getLibraryUsage($id, $skipContent = false)
    {
        if ($skipContent) {
            $cotent = -1;

        } else {
            $result = DB::select('SELECT COUNT(distinct c.id) AS cnt FROM h5p_libraries l JOIN h5p_contents_libraries cl ON l.id = cl.library_id JOIN h5p_contents c ON cl.content_id = c.id WHERE l.id = ?', [$id]);
            $content = intval($result[0]->cnt);
        }

        return [
            'content'   => $content,

            'libraries' => intval(H5pLibrariesLibrary::where('required_library_id', $id)->count()),
        ];
    }

    /**
     * Implements saveLibraryData.
     */
    public function saveLibraryData(&$library, $new = true)
    {
        $preloadedJs = $this->pathsToCsv($library, 'preloadedJs');
        $preloadedCss = $this->pathsToCsv($library, 'preloadedCss');
        $dropLibraryCss = '';
        if (isset($library['dropLibraryCss'])) {
            $libs = [];
            foreach ($library['dropLibraryCss'] as $lib) {
                $libs[] = $lib['machineName'];
            }
            $dropLibraryCss = implode(', ', $libs);
        }
        $embedTypes = '';
        if (isset($library['embedTypes'])) {
            $embedTypes = implode(', ', $library['embedTypes']);
        }
        if (!isset($library['semantics'])) {
            $library['semantics'] = '';
        }
        if (!isset($library['fullscreen'])) {
            $library['fullscreen'] = 0;
        }
        if (!isset($library['tutorial_url'])) {
            $library['tutorial_url'] = '';
        }
        if (!isset($library['hasIcon'])) {
            $library['hasIcon'] = 0;
        }

        if ($new) {
            $library['libraryId'] = DB::table('h5p_libraries')->insertGetId([
                'name'             => $library['machineName'],
                'title'            => $library['title'],
                'major_version'    => $library['majorVersion'],
                'minor_version'    => $library['minorVersion'],
                'patch_version'    => $library['patchVersion'],
                'runnable'         => $library['runnable'],
                'fullscreen'       => $library['fullscreen'],
                'embed_types'      => $embedTypes,
                'preloaded_js'     => $preloadedJs,
                'preloaded_css'    => $preloadedCss,
                'drop_library_css' => $dropLibraryCss,
                'semantics'        => $library['semantics'],
                'tutorial_url'     => $library['tutorial_url'],
                'has_icon'         => $library['hasIcon'] ? 1 : 0,
            ]);
        } else {
            $library['libraryId'] = DB::table('h5p_libraries')
                ->where('id', $library['libraryId'])->update([
                'title'            => $library['title'],
                'patch_version'    => $library['patchVersion'],
                'runnable'         => $library['runnable'],
                'fullscreen'       => $library['fullscreen'],
                'embed_types'      => $embedTypes,
                'preloaded_js'     => $preloadedJs,
                'preloaded_css'    => $preloadedCss,
                'drop_library_css' => $dropLibraryCss,
                'semantics'        => $library['semantics'],
                'has_icon'         => $library['hasIcon'] ? 1 : 0,
            ]);
            $this->deleteLibraryDependencies($library['libraryId']);
        }

        // Log library successfully installed/upgraded
        event(new H5pEvent('library', ($new ? 'create' : 'update'), null, null, $library['machineName'], $library['majorVersion'].'.'.$library['minorVersion']));

        // Update languages
        DB::table('h5p_libraries_languages')
            ->where('library_id', $library['libraryId'])
            ->delete();

        if (isset($library['language'])) {
            foreach ($library['language'] as $languageCode => $translation) {
                DB::table('h5p_libraries_languages')->insert([
                    'library_id'    => $library['libraryId'],
                    'language_code' => $languageCode,
                    'translation'   => $translation,
                ]
                );
            }
        }
    }

    /**
     * Convert list of file paths to csv.
     *
     * @param array  $library
     *                        Library data as found in library.json files
     * @param string $key
     *                        Key that should be found in $libraryData
     *
     * @return string
     *                file paths separated by ', '
     */
    private function pathsToCsv($library, $key)
    {
        if (isset($library[$key])) {
            $paths = [];
            foreach ($library[$key] as $file) {
                $paths[] = $file['path'];
            }

            return implode(', ', $paths);
        }

        return '';
    }

    /**
     * Implements deleteLibraryDependencies.
     */
    public function deleteLibraryDependencies($id)
    {
        DB::table('h5p_libraries_libraries')->where('library_id', $id)->delete();
    }

    /**
     * Implements deleteLibrary.
     */
    public function deleteLibrary($library)
    {
        $plugin = App::make('LaravelH5p');

        // Delete library files
        $plugin::$core->deleteFileTree($this->getH5pPath().'/libraries/'.$library->name.'-'.$library->major_version.'.'.$library->minor_version);

        // Remove library data from database
        DB::table('h5p_libraries_libraries')->where('library_id', $library->id)->delete();
        DB::table('h5p_libraries_languages')->where('library_id', $library->id)->delete();
        DB::table('h5p_libraries')->where('id', $library->id)->delete();
    }

    /**
     * Implements saveLibraryDependencies.
     */
    public function saveLibraryDependencies($id, $dependencies, $dependencyType)
    {
        foreach ($dependencies as $dependency) {
            DB::insert('INSERT INTO h5p_libraries_libraries (library_id, required_library_id, dependency_type)
            SELECT ?, hl.id, ? FROM h5p_libraries hl WHERE
            name = ?
            AND major_version = ?
            AND minor_version = ?
            ON DUPLICATE KEY UPDATE dependency_type = ?', [$id, $dependencyType, $dependency['machineName'], $dependency['majorVersion'], $dependency['minorVersion'], $dependencyType]);
        }

//        DB::table('h5p_libraries_libraries')->insert($datas);
    }

    /**
     * Implements updateContent.
     */
    public function updateContent($entry, $contentMainId = null)
    {
        $content = [];
        $content['title'] = $entry['title'];
        $content['embed_type'] = $entry['embed_type'];
        $content['user_id'] = $entry['user_id'];
        $content['filtered'] = $entry['filtered'];
        $content['disable'] = $entry['disable'];
        $content['slug'] = $entry['slug'];
        $content['library_id'] = $entry['library']['libraryId'];
        $content['parameters'] = $entry['params'];

        if (!isset($entry['id'])) {
            $content['created_at'] = isset($entry['created_at']) ? $entry['created_at'] : Carbon::now();

            // Insert new content
            $return = H5pContent::create($content);
            $content['id'] = $return->id;
            $event_type = 'create';
        } else {
            $content['id'] = $entry['id'];
            $content['updated_at'] = isset($entry['updated_at']) ? $entry['updated_at'] : Carbon::now();

            H5pContent::where('id', $content['id'])->update($content);
            $event_type = 'update';
        }

        // Log content create/update/upload
        if (!empty($content['uploaded'])) {
            $event_type .= ' upload';
        }

        event(new H5pEvent('content', $event_type, $content['id'], $content['title'], $entry['library']['machineName'], $entry['library']['majorVersion'].'.'.$entry['library']['minorVersion']));

        return $content['id'];
    }

    /**
     * Implements insertContent.
     */
    public function insertContent($content, $contentMainId = null)
    {
        return $this->updateContent($content);
    }

    /**
     * Implement getWhitelist.
     */
    public function getWhitelist($isLibrary, $defaultContentWhitelist, $defaultLibraryWhitelist)
    {
        // TODO: Get this value from a settings page.
        $whitelist = $defaultContentWhitelist;
        if ($isLibrary) {
            $whitelist .= ' '.$defaultLibraryWhitelist;
        }

        return $whitelist;
    }

    /**
     * Implements copyLibraryUsage.
     */
    public function copyLibraryUsage($contentId, $copyFromId, $contentMainId = null)
    {
        DB::insert('INSERT INTO h5p_contents_libraries (content_id, library_id, dependency_type, weight, drop_css)
        SELECT ?,
        hcl.library_id,
        hcl.dependency_type,
        hcl.weight,
        hcl.drop_css
        FROM h5p_contents_libraries hcl WHERE hcl.content_id = ?', [$contentId, $copyFromId]);
    }

    /**
     * Implements deleteContentData.
     */
    public function deleteContentData($id)
    {
        H5pContent::where('id', $id)->delete();
        $this->deleteLibraryUsage($id);
        H5pResult::where('content_id', $id)->delete();
        H5pContentsUserData::where('content_id', $id)->delete();
    }

    /**
     * Implements deleteLibraryUsage.
     */
    public function deleteLibraryUsage($contentId)
    {
        H5pContentsLibrary::where('content_id', $contentId)->delete();
    }

    /**
     * Implements saveLibraryUsage.
     */
    public function saveLibraryUsage($contentId, $librariesInUse)
    {
        $dropLibraryCssList = [];
        foreach ($librariesInUse as $dependency) {
            if (!empty($dependency['library']['dropLibraryCss'])) {
                $dropLibraryCssList = array_merge($dropLibraryCssList, explode(', ', $dependency['library']['dropLibraryCss']));
            }
        }
        foreach ($librariesInUse as $dependency) {
            $dropCss = in_array($dependency['library']['machineName'], $dropLibraryCssList) ? 1 : 0;
            DB::table('h5p_contents_libraries')->insert([
                'content_id'      => strval($contentId),
                'library_id'      => $dependency['library']['libraryId'],
                'dependency_type' => $dependency['type'],
                'drop_css'        => $dropCss,
                'weight'          => $dependency['weight'],
            ]);
        }
    }

    /**
     * Implements loadLibrary.
     */
    public function loadLibrary($name, $majorVersion, $minorVersion)
    {
        $library = DB::table('h5p_libraries')
            ->select(['id as libraryId', 'name as machineName', 'title', 'major_version as majorVersion', 'minor_version as minorVersion', 'patch_version as patchVersion', 'embed_types as embedTypes', 'preloaded_js as preloadedJs', 'preloaded_css as preloadedCss', 'drop_library_css as dropLibraryCss', 'fullscreen', 'runnable', 'semantics', 'has_icon as hasIcon'])
            ->where('name', $name)
            ->where('major_version', $majorVersion)
            ->where('minor_version', $minorVersion)
            ->first();

        $return = json_decode(json_encode($library), true);

        $dependencies = DB::select('SELECT hl.name as machineName, hl.major_version as majorVersion, hl.minor_version as minorVersion, hll.dependency_type as dependencyType
        FROM h5p_libraries_libraries hll
        JOIN h5p_libraries hl ON hll.required_library_id = hl.id
        WHERE hll.library_id = ?', [$library->libraryId]);

        foreach ($dependencies as $dependency) {
            $return[$dependency->dependencyType.'Dependencies'][] = [
                'machineName'  => $dependency->machineName,
                'majorVersion' => $dependency->majorVersion,
                'minorVersion' => $dependency->minorVersion,
            ];
        }
        if ($this->isInDevMode()) {
            $semantics = $this->getSemanticsFromFile($return['machineName'], $return['majorVersion'], $return['minorVersion']);
            if ($semantics) {
                $return['semantics'] = $semantics;
            }
        }

        return $return;
    }

    private function getSemanticsFromFile($name, $majorVersion, $minorVersion)
    {
        $semanticsPath = $this->getH5pPath().'/libraries/'.$name.'-'.$majorVersion.'.'.$minorVersion.'/semantics.json';
        if (file_exists($semanticsPath)) {
            $semantics = file_get_contents($semanticsPath);
            if (!json_decode($semantics, true)) {
                $this->setErrorMessage($this->t('Invalid json in semantics for %library', ['%library' => $name]));
            }

            return $semantics;
        }

        return false;
    }

    /**
     * Implements loadLibrarySemantics.
     */
    public function loadLibrarySemantics($name, $majorVersion, $minorVersion)
    {
        if ($this->isInDevMode()) {
            $semantics = $this->getSemanticsFromFile($name, $majorVersion, $minorVersion);
        } else {
            $semantics = H5pLibrary::where('name', $name)
                ->where('major_version', $majorVersion)
                ->where('minor_version', $minorVersion)
                ->first();
//                    DB::select("SELECT semantics FROM h5p_libraries WHERE name = ? AND major_version = ? AND minor_version = ?", [$name, $majorVersion, $minorVersion]);
        }

        return $semantics === false ? null : $semantics->semantics;
    }

    /**
     * Implements alterLibrarySemantics.
     */
    public function alterLibrarySemantics(&$semantics, $name, $majorVersion, $minorVersion)
    {
        /*
         * Allows you to alter the H5P library semantics, i.e. changing how the
         * editor looks and how content parameters are filtered.
         *
         * @since 1.5.3
         *
         * @param object &$semantics
         * @param string $libraryName
         * @param int $libraryMajorVersion
         * @param int $libraryMinorVersion
         */
//        $this->alterLibrarySemantics($semantics, $name, $majorVersion, $minorVersion);
        //        do_action_ref_array('h5p_alter_library_semantics', array(&$semantics, $name, $majorVersion, $minorVersion));
    }

    /**
     * Implements loadContent.
     */
    public function loadContent($id)
    {
        $return = DB::select('SELECT
                hc.id
              , hc.title
              , hc.parameters AS params
              , hc.filtered
              , hc.slug AS slug
              , hc.user_id
              , hc.embed_type AS embedType
              , hc.disable
              , hl.id AS libraryId
              , hl.name AS libraryName
              , hl.major_version AS libraryMajorVersion
              , hl.minor_version AS libraryMinorVersion
              , hl.embed_types AS libraryEmbedTypes
              , hl.fullscreen AS libraryFullscreen
        FROM h5p_contents hc
        JOIN h5p_libraries hl ON hl.id = hc.library_id
        WHERE hc.id = ?', [$id]);

        return (array) array_shift($return);
    }

    /**
     * Implements loadContentDependencies.
     */
    public function loadContentDependencies($id, $type = null)
    {
        $query = 'SELECT hl.id
              , hl.name AS machineName
              , hl.major_version AS majorVersion
              , hl.minor_version AS minorVersion
              , hl.patch_version AS patchVersion
              , hl.preloaded_css AS preloadedCss
              , hl.preloaded_js AS preloadedJs
              , hcl.drop_css AS dropCss
              , hcl.dependency_type AS dependencyType
        FROM h5p_contents_libraries hcl
        JOIN h5p_libraries hl ON hcl.library_id = hl.id
        WHERE hcl.content_id = ?';

        $queryArgs = [$id];
        if ($type !== null) {
            $query .= ' AND hcl.dependency_type = ?';
            $queryArgs[] = $type;
        }
        $query .= ' ORDER BY hcl.weight';

        $entrys = DB::select($query, $queryArgs);
        $return = [];
        foreach ($entrys as $entry) {
            $return[] = (array) $entry;
        }

        return $return;
    }

    /**
     * Implements getOption().
     */
    public function getOption($name, $default = false)
    {
        if ($name === 'site_uuid') {
            $name = 'h5p_site_uuid'; // Make up for old core bug
        }

        return config('laravel-h5p.h5p_'.$name, $default);
    }

    /**
     * Implements setOption().
     */
    public function setOption($name, $value)
    {
        if ($name === 'site_uuid') {
            $name = 'h5p_site_uuid'; // Make up for old core bug
        }
        config(['laravel-h5p.h5p_'.$name => $value]);
    }

    /**
     * Convert variables to fit our DB.
     */
    private static function camelToString($input)
    {
        $input = preg_replace('/[a-z0-9]([A-Z])[a-z0-9]/', '_$1', $input);

        return strtolower($input);
    }

    /**
     * Implements setFilteredParameters().
     */
    public function updateContentFields($id, $fields)
    {
        $processedFields = [];
        foreach ($fields as $name => $value) {
            $processedFields[self::camelToString($name)] = $value;
        }
        DB::table('h5p_contents')->where('id', $id)->update($processedFields);
    }

    /**
     * Implements clearFilteredParameters().
     */
    public function clearFilteredParameters($library_id)
    {
        H5pContent::where('library_id', $library_id)->update(['filtered' => null]);
    }

    /**
     * Implements getNumNotFiltered().
     */
    public function getNumNotFiltered()
    {
        return H5pContent::where('filtered', '')->count();

    }

    /**
     * Implements getNumContent().
     */
    public function getNumContent($library_id, $skip = NULL)
    {
        return H5pContent::where('library_id', $library_id)->count();

    }

    /**
     * Library list to load from library menu
     * Implements loadLibraries.
     */
    public function loadLibraries()
    {
        $results = H5pLibrary::select([
            'id',
            'name',
            'title',
            'major_version',
            'minor_version',
            'patch_version',
            'runnable',
            'restricted', ])
            ->orderBy('title', 'ASC')
            ->orderBy('major_version', 'ASC')
            ->orderBy('minor_version', 'ASC')
            ->get();
        $libraries = [];
        foreach ($results as $library) {
            $libraries[$library->name][] = $library;
        }

        return $libraries;
    }

    /**
     * Implements getAdminUrl.
     */
    public function getAdminUrl()
    {
        return route('laravel-h5p.library');
    }

    /**
     * Implements getPlatformInfo.
     */
    public function getPlatformInfo()
    {
        $laravel = app();

        return [
            'name'       => 'laravel',
            'version'    => $laravel::VERSION,

            'h5pVersion' => config('laravel-h5p.h5p_version'),
        ];
    }

    /**
     * Implements fetchExternalData.
     */
    public function fetchExternalData($url, $data = null, $blocking = true, $stream = null)
    {
        @set_time_limit(0);
        /** @scrutinizer ignore-unhandled */ @set_time_limit(0);
        $options = [
            'timeout'  => !empty($blocking) ? 30 : 0.01,
            'stream'   => !empty($stream),
            'filename' => !empty($stream) ? $stream : false,
        ];

        $client = new Client();

        try {
            if ($data !== null) {
                // Post
                $options['body'] = $data;
                $response = $client->request('POST', $url, ['form_params' => $options]);
            } else {
                // Get
                if (empty($options['filename'])) {
                    // Support redirects
                    //                $response = wp_remote_get($url);
                    $response = $client->request('GET', $url);
                } else {
                    // Use safe when downloading files
                    //                $response = wp_safe_remote_get($url, $options);
                    $response = $client->request('GET', $url, $options);
                }
            }

            if ($response->getStatusCode() === 200) {
                return empty($response->getBody()) ? true : $response->getBody();

            } else {
                return;
            }
        } catch (RequestException $e) {
filter:
    dependency_paths: ["lib/*"]
            return false;
interface HasName {
    /** @return string */
    public function getName();
}

class Name {
    public $name;
}

class User implements HasName {
    /** @return string|Name */
    public function getName() {
        return new Name('foo'); // This is a violation of the ``HasName`` interface
                                // which only allows a string value to be returned.
    }
}
        }
    }

    /**
     * Implements setLibraryTutorialUrl.
     */
    public function setLibraryTutorialUrl($library_name, $url)
    {
        DB::table('h5p_libraries')->where('name', $library_name)->update(['tutorial_url' => $url]);
    }

    /**
     * Implements resetContentUserData.
     */
    public function resetContentUserData($contentId)
    {

        // Reset user datas for this content
        DB::table('h5p_contents_user_data')
            ->where('content_id', $contentId)
            ->where('invalidate', 1)
            ->update([
                'updated_at' => Carbon::now(),
                'data'       => 'RESET',
            ]);
    }

    /**
     * Implements isContentSlugAvailable.
     */
    public function isContentSlugAvailable($slug)
    {
        return DB::select("SELECT slug FROM h5p_contents WHERE slug = ':slug'", ['slub' => $slug]);
interface HasName {
    /** @return string */
    public function getName();
}

class Name {
    public $name;
}

class User implements HasName {
    /** @return string|Name */
    public function getName() {
        return new Name('foo'); // This is a violation of the ``HasName`` interface
                                // which only allows a string value to be returned.
    }
}
    }

    /**
     * Implements getLibraryContentCount.
     */
    public function getLibraryContentCount()
    {
        $count = [];
        // Find number of content per library
        $results = DB::select('SELECT l.name, l.major_version, l.minor_version, COUNT(*) AS count
        FROM h5p_contents c, h5p_libraries l
        WHERE c.library_id = l.id GROUP BY l.name, l.major_version, l.minor_version');
        // Extract results
        foreach ($results as $library) {
            $count[$library->name.' '.$library->major_version.'.'.$library->minor_version] = $library->count;
        }

        return $count;
    }

    /**
     * Implements getLibraryStats.
     */
    public function getLibraryStats($type)
    {
        $count = [];
        $results = DB::select('SELECT library_name AS name, library_version AS version, num FROM h5p_counters WHERE type = ?', [$type]);
        // Extract results
        foreach ($results as $library) {
            $count[$library->name.' '.$library->version] = $library->num;
        }

        return $count;
    }

    /**
     * Implements getNumAuthors.
     */
    public function getNumAuthors()
    {
        return DB::select('SELECT COUNT(DISTINCT user_id) FROM h5p_contents');
interface HasName {
    /** @return string */
    public function getName();
}

class Name {
    public $name;
}

class User implements HasName {
    /** @return string|Name */
    public function getName() {
        return new Name('foo'); // This is a violation of the ``HasName`` interface
                                // which only allows a string value to be returned.
    }
}
    }

    // Magic stuff not used, we do not support library development mode.
    public function lockDependencyStorage()
    {
    }

    public function unlockDependencyStorage()
    {
    }

    /**
     * Implements saveCachedAssets.
     */
    public function saveCachedAssets($key, $libraries)
    {
        foreach ($libraries as $library) {
            // TODO: Avoid errors if they already exists...
            DB::table('h5p_libraries_cachedassets')->insert(
                [
                    'library_id' => isset($library['id']) ? $library['id'] : $library['libraryId'],
                    'hash'       => $key,
                ]);
        }
    }

    /**
     * Implements deleteCachedAssets.
     */
    public function deleteCachedAssets($library_id)
    {

        // Get all the keys so we can remove the files
        $results = DB::select('SELECT hash FROM h5p_libraries_cachedassets WHERE library_id = ?', [$library_id]);
        // Remove all invalid keys
        $hashes = [];
        foreach ($results as $key) {
            $hashes[] = $key->hash;
            DB::table('h5p_libraries_cachedassets')->where('hash', $key->hash)->delete();
        }

        return $hashes;
    }

    /**
     * Implements afterExportCreated.
     */
    public function afterExportCreated($content, $filename)
    {
        $this->_download_file = storage_path('h5p/exports/'.$filename);
    }

    /**
     * Check if current user can edit H5P.
     *
     * @method currentUserCanEdit
     *
     * @param int $contentUserId
     *
     * @return bool
     */
    private static function currentUserCanEdit($contentUserId)

    {
        if (H5pHelper::current_user_can('edit_others_h5p_contents')) {
            return true;
        }

        return get_current_user_id() == $contentUserId;
        return /** @scrutinizer ignore-call */ get_current_user_id() == $contentUserId;
    }

    /**
     * Implements hasPermission.
     *
     * @method hasPermission
     *
     * @param H5PPermission $permission
     * @param int           $contentUserId
     *
     * @return bool
     */
    public function hasPermission($permission, $contentUserId = null)
    {
        switch ($permission) {
        case H5PPermission::DOWNLOAD_H5P:

        case H5PPermission::EMBED_H5P:
//                return self::currentUserCanEdit($contentUserId);
            return true;
        case H5PPermission::CREATE_RESTRICTED:
        case H5PPermission::UPDATE_LIBRARIES:
//                return H5pHelper::current_user_can('manage_h5p_libraries');
            return true;
        case H5PPermission::INSTALL_RECOMMENDED:
//                H5pHelper::current_user_can('install_recommended_h5p_libraries');
            return true;
        }

        return false;
    }

    /**
     * Replaces existing content type cache with the one passed in.
     *
     * @param object $contentTypeCache Json with an array called 'libraries'
     *                                 containing the new content type cache that should replace the old one.
     */
    public function replaceContentTypeCache($contentTypeCache)
    {
        // Replace existing content type cache
        DB::table('h5p_libraries_hub_cache')->truncate();

        foreach ($contentTypeCache->contentTypes as $ct) {
            // Insert into db
            DB::insert('INSERT INTO h5p_libraries_hub_cache (
                machine_name,
                major_version,
                minor_version,
                patch_version,
                h5p_major_version,
                h5p_minor_version,
                title,
                summary,
                description,
                icon,
                created_at,
                updated_at,
                is_recommended,
                popularity,
                screenshots,
                license,
                example,
                tutorial,
                keywords,
                categories,
                owner) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)', [
                $ct->id,
                $ct->version->major,
                $ct->version->minor,
                $ct->version->patch,
                $ct->coreApiVersionNeeded->major,
                $ct->coreApiVersionNeeded->minor,
                $ct->title,
                $ct->summary,
                $ct->description,
                $ct->icon,
                (new DateTime($ct->createdAt))->getTimestamp(),

                (new DateTime($ct->updatedAt))->getTimestamp(),
                $ct->isRecommended === true ? 1 : 0,
                $ct->popularity,
                json_encode($ct->screenshots),
                json_encode(isset($ct->license) ? $ct->license : []),
                $ct->example,
                isset($ct->tutorial) ? $ct->tutorial : '',
                json_encode(isset($ct->keywords) ? $ct->keywords : []),
                json_encode(isset($ct->categories) ? $ct->categories : []),
                $ct->owner, ]
            );
        }
    }
}

djoudi / Laravel-H5P

Push — master ( 61d47b...f50d69 )

LaravelH5pRepository::loadAddons() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
