FolderManager::createFolder()

Complexity

Conditions	35
Paths	241

Size

Total Lines	189
Code Lines	122

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    private function createFolder($params, $parentFolderData)
    {
        extract($params);
        extract($parentFolderData);
        
        if (
            (int) $isPersonal === 1
            || (int) $user_is_admin === 1
            || ((int) $user_is_manager === 1 || (int) $user_can_manage_all_users === 1)
            || (isset($SETTINGS['enable_user_can_create_folders']) === true
                && (int) $SETTINGS['enable_user_can_create_folders'] == 1)
            || ((int) $user_can_create_root_folder && null !== $user_can_create_root_folder && (int) $user_can_create_root_folder === 1)
        ) {
            //create folder
            DB::insert(
                prefixTable('nested_tree'),
                array(
                    'parent_id' => $parent_id,
                    'title' => $title,
                    'personal_folder' => null !== $isPersonal ? $isPersonal : 0,
                    'renewal_period' => isset($duration) === true && (int) $duration !== 0 ? $duration : 0,
                    'bloquer_creation' => isset($create_auth_without) === true && (int) $create_auth_without === 1 ? '1' : $parentBloquerCreation,
                    'bloquer_modification' => isset($edit_auth_without) === true && (int) $edit_auth_without === 1 ? '1' : $parentBloquerModification,
                    'fa_icon' => empty($icon) === true ? TP_DEFAULT_ICON : $icon,
                    'fa_icon_selected' => empty($icon_selected) === true ? TP_DEFAULT_ICON_SELECTED : $icon_selected,
                    'categories' => '',
                )
            );
            $newId = DB::insertId();
    
            //Add complexity
            DB::insert(
                prefixTable('misc'),
                array(
                    'type' => 'complex',
                    'intitule' => $newId,
                    'valeur' => $complexity,
                    'created_at' => time(),
                )
            );
    
            // ensure categories are set
            handleFoldersCategories(
                [$newId]
            );
    
            // Update timestamp
            DB::update(
                prefixTable('misc'),
                array(
                    'valeur' => time(),
                    'updated_at' => time(),
                ),
                'type = %s AND intitule = %s',
                'timestamp',
                'last_folder_change'
            );
    
            // Load tree
            $tree = new NestedTree(prefixTable('nested_tree'), 'id', 'parent_id', 'title');
    
            // rebuild tree
            $tree->rebuild();
    
    
            // --> build json tree if not Admin
            if ($user_is_admin === 0) {
                // Get path
                $path = '';
                $tree_path = $tree->getPath(0, false);
                foreach ($tree_path as $fld) {
                    $path .= empty($path) === true ? $fld->title : '/'.$fld->title;
                }
                $new_json = [
                    "path" => $path,
                    "id" => $newId,
                    "level" => count($tree_path),
                    "title" => $title,
                    "disabled" => 0,
                    "parent_id" => $parent_id,
                    "perso" => $isPersonal,
                    "is_visible_active" => 0,
                ];
    
                // update cache_tree
                $cache_tree = DB::queryfirstrow(
                    'SELECT increment_id, folders, visible_folders
                    FROM ' . prefixTable('cache_tree').' WHERE user_id = %i',
                    (int) $user_id
                );
                if (empty($cache_tree) === true) {
                    DB::insert(
                        prefixTable('cache_tree'),
                        array(
                            'user_id' => $user_id,
                            'folders' => json_encode($newId),
                            'visible_folders' => json_encode($new_json),
                            'timestamp' => time(),
                            'data' => '[{}]',
                        )
                    );
                } else {
                    $a_folders = is_null($cache_tree['folders']) === true ? [] : json_decode($cache_tree['folders'], true);
                    array_push($a_folders, $newId);
                    $a_visible_folders = is_null($cache_tree['visible_folders']) === true || empty($cache_tree['visible_folders']) === true ? [] : json_decode($cache_tree['visible_folders'], true);
                    array_push($a_visible_folders, $new_json);
                    DB::update(
                        prefixTable('cache_tree'),
                        array(
                            'folders' => json_encode($a_folders),
                            'visible_folders' => json_encode($a_visible_folders),
                            'timestamp' => time(),
                        ),
                        'increment_id = %i',
                        (int) $cache_tree['increment_id']
                    );
                }
            }
            // <-- end - build json tree
    
            // Create expected groups access rights based upon option selected
            if (
                isset($SETTINGS['subfolder_rights_as_parent']) === true
                && (int) $SETTINGS['subfolder_rights_as_parent'] === 1
            ) {
                //If it is a subfolder, then give access to it for all roles that allows the parent folder
                $rows = DB::query('SELECT role_id, type FROM ' . prefixTable('roles_values') . ' WHERE folder_id = %i', $parent_id);
                foreach ($rows as $record) {
                    //add access to this subfolder
                    DB::insert(
                        prefixTable('roles_values'),
                        array(
                            'role_id' => $record['role_id'],
                            'folder_id' => $newId,
                            'type' => $record['type'],
                        )
                    );
                }
            } elseif ((int) $user_is_admin !== 1) {
                // If not admin and no option enabled
                // then provide expected rights based upon user's roles
                foreach (array_unique(explode(';', $user_roles)) as $role) {
                    if (empty($role) === false) {
                        DB::insert(
                            prefixTable('roles_values'),
                            array(
                                'role_id' => $role,
                                'folder_id' => $newId,
                                'type' => $access_rights,
                            )
                        );
                    }
                }
            }
    
            // if parent folder has Custom Fields Categories then add to this child one too
            $rows = DB::query('SELECT id_category FROM ' . prefixTable('categories_folders') . ' WHERE id_folder = %i', $parent_id);
            foreach ($rows as $record) {
                //add CF Category to this subfolder
                DB::insert(
                    prefixTable('categories_folders'),
                    array(
                        'id_category' => $record['id_category'],
                        'id_folder' => $newId,
                    )
                );
            }
    
            // clear cache cache for each user that have at least one similar role as the current user
            $usersWithSimilarRoles = empty($user_roles) === false  ? getUsersWithRoles(
                explode(";", $user_roles)
            ) : [];
            foreach ($usersWithSimilarRoles as $user) {
                // delete cache tree
                DB::delete(
                    prefixTable('cache_tree'),
                    'user_id = %i',
                    $user
                );
            }
            return array(
                'error' => false,
                'newId' => $newId,
            );
    
        } else {
            return array(
                'error' => true,
                'newId' => $newId,
            );
}