shared_categories.php

<?php
// This file is part of Exabis Eportfolio (extension for Moodle)
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle.  If not, see <http://www.gnu.org/licenses/>.
// (c) 2016 GTN - Global Training Network GmbH <office@gtn-solutions.com>.

require_once(__DIR__ . '/inc.php');

use block_exaport\globals as g;
use function block_exaport\common\print_error;

$courseid = required_param('courseid', PARAM_INT);
$sort = optional_param('sort', 'user', PARAM_TEXT);
$action = optional_param('action', 'list', PARAM_TEXT);

if ($sort == 'mystudents' && !block_exaport_user_can_see_artifacts_of_students()) {
    $sort = 'user';
}

require_login($courseid);

$context = context_system::instance();
require_capability('block/exaport:use', $context);

if (empty($CFG->block_exaport_enable_shared_categories)) {
    print_error('areaisdisabled', 'block_exaport');
}

$url = '/blocks/exaport/shared_categories.php';
$PAGE->set_url($url, ['courseid' => $courseid]);


block_exaport_add_iconpack();
block_exaport_init_js_css();

$parsedsort = block_exaport_parse_sort($sort, array('user', 'category', 'mystudents'));
if ($parsedsort[0] == 'category') {
    $sqlsort = " ORDER BY c.name, u.lastname, u.firstname";
    if (strcmp($CFG->dbtype, "sqlsrv") == 0) {
        $sqlsort = " ORDER BY cast(c.name AS varchar(max)), u.lastname, u.firstname";
    }
} else {
    $sqlsort = " ORDER BY u.lastname, u.firstname, c.name";
    if (strcmp($CFG->dbtype, "sqlsrv") == 0) {
        $sqlsort = " ORDER BY u.lastname, u.firstname, cast(c.name AS varchar(max))";
    }
}

// Categories for user groups.
$usercats = block_exaport_get_group_share_categories($USER->id);

$categorycolumns = g::$DB->get_column_names_prefixed('block_exaportcate', 'c');
$categories = block_exaport_get_shared_categories($categorycolumns, $usercats, $sqlsort);

if ($CFG->block_exaport_copy_category_to_my && $action == 'copy') {
    $categoryid = optional_param('categoryid', 0, PARAM_INT);

    // Check if category can be accessed.
    if (!isset($categories[$categoryid])) {
        throw new moodle_exception('category not found');
    }

    $category = \block_exaport\copy_category_to_myself($categoryid);
    $returnurl = $CFG->wwwroot . '/blocks/exaport/view_items.php?courseid=' . $courseid . '&categoryid=' . $category->id;
    redirect($returnurl);
    exit;
}

block_exaport_print_header("shared_categories");

function exaport_print_structures($categories, $parsedsort) {
    global $CFG, $courseid, $COURSE, $OUTPUT, $DB;

    // $courses = exaport_get_shareable_courses_with_users('shared_views');
    $courses = exaport_get_shareable_courses_with_users('shared_categories');
    $sort = $parsedsort[0];

    $mainstructuregroups = array(
        'thiscourse' => array(),
        'othercourses' => array(),
    );
    if (isset($courses[$COURSE->id])) {
        if ($sort == 'mystudents') {
            $students = block_exaport_get_students_for_teacher();
            if (count($students) > 0) {
                foreach ($students as $studentid => $student) {
                    if (in_array($COURSE->id, $student->courseids)) {
                        $mainstructuregroups['thiscourse'][$studentid] = $student;
                    } else {
                        $mainstructuregroups['othercourses'][$studentid] = $student;
                    }
                }
            }
        } else {
            $useridsinthiscourse = array_keys($courses[$COURSE->id]->users);
            foreach ($categories as $structure) {
                // if (in_array($structure->userid, $useridsinthiscourse)) {
                if ($COURSE->id == $structure->courseid) {
                    $mainstructuregroups['thiscourse'][] = $structure;
                } else {
                    $mainstructuregroups['othercourses'][] = $structure;
                }
            }
        }
    } else {
        if ($sort == 'mystudents') {
            $students = block_exaport_get_students_for_teacher();
            $mainstructuregroups['othercourses'] = $students;
        } else {
            $mainstructuregroups['othercourses'] = $categories;
        }
    }
    if ($courses) {
        echo '<span style="padding-right: 20px;">' . get_string('course') .
            ': <select id="block-exaport-courses" url="shared_categories.php?courseid=%courseid%&sort=' . $sort . '">';
        // Print empty line for access to all cources in one list
        echo '<option value="1" ' . ($COURSE->id == 1 ? ' selected="selected"' : '') . '></option>';

        foreach ($courses as $c) {
            echo '<option value="' . $c->id . '"' . ($c->id == $COURSE->id ? ' selected="selected"' : '') . '>' . $c->fullname . '</option>';
        }
        echo '</select></span>';
    }

    // Print.
    if (block_exaport_user_can_see_artifacts_of_students()) {
        echo '<span class="mystudents_link">';
        if ($sort == 'mystudents') {
            echo "<a href=\"{$CFG->wwwroot}/blocks/exaport/shared_categories.php?courseid=$courseid&amp;sort=user\">" .
                get_string('show_sharedbyuser', 'block_exaport') . "</a>&nbsp;";
        } else {
            echo "<a href=\"{$CFG->wwwroot}/blocks/exaport/shared_categories.php?courseid=$courseid&amp;sort=mystudents\">" .
                get_string('show_mystudents', 'block_exaport') . "</a>&nbsp;";
        }
        echo '</span>';
    }
    if ($categories && $sort != 'mystudents') {
        echo get_string('sortby') . ': ';
        echo "<a href=\"{$CFG->wwwroot}/blocks/exaport/shared_categories.php?courseid=$courseid&amp;sort=user\"" .
            ($sort == 'user' ? ' style="font-weight: bold;"' : '') . ">" . get_string('user') . "</a> | ";
        echo "<a href=\"{$CFG->wwwroot}/blocks/exaport/shared_categories.php?courseid=$courseid&amp;sort=category\"" .
            ($sort == 'category' ? ' style="font-weight: bold;"' : '') . ">" . get_string('category', 'block_exaport') . "</a>";
    }
    echo '</div>';

    foreach ($mainstructuregroups as $mainstructuregroupid => $mainstructuregroup) {
        if (empty($mainstructuregroup) && ($mainstructuregroupid != 'thiscourse')) {
            // Don't print if no structures.
            continue;
        }

        // Header.
        echo '<h2>' . get_string($mainstructuregroupid, 'block_exaport') . '</h2>';

        if (empty($mainstructuregroup)) {
            // Print for this course only.
            echo get_string("nothingstructureshared", "block_exaport");
            continue;
        }

        switch ($sort) {
            case 'mystudents':
                // $students = block_exaport_get_students_for_teacher();
                if (count($mainstructuregroup) > 0) {
                    $table = new html_table();
                    $table->width = "100%";
                    $table->size = array('1%', '40%', '40%', '20%');
                    $table->align = array('left', 'left', 'left', 'centre');
                    $table->head = array(
                        '',
                        get_string('user'),
                        block_exaport_get_string('enrolled_courses', 'block_exaport'),
                        '',
                    );
                    $table->data = array();
                    foreach ($mainstructuregroup as $user) {
                        $relatedcources = '<div class="related_cources">' . implode(', ', $user->courses) . '</div>';
                        $link = '<a href="' . $CFG->wwwroot . '/blocks/exaport/view_items.php?courseid=' . $courseid . '&type=sharedstudent&userid=' .
                            $user->id . '&categoryid=0">
                                        <img src="pix/folder_32.png" /><br />' . get_string("browseportfolio", "block_exaport") . '</a>';
                        $table->data[] = array(
                            $OUTPUT->user_picture($user, array("courseid" => $courseid)),
                            fullname($user),
                            $relatedcources,
                            $link,
                        );
                    }
                } else {
                    echo get_string("nothingstructureshared", "block_exaport");
                }
                echo html_writer::table($table);
                break;
            case 'user':
                // Group by user.
                $categoriesbyuser = array();
                foreach ($mainstructuregroup as $structure) {
                    if (!isset($categoriesbyuser[$structure->userid])) {
                        $categoriesbyuser[$structure->userid] = array(
                            'user' => $DB->get_record('user', array("id" => $structure->userid)),
                            'structures' => array(),
                        );
                    }

                    $categoriesbyuser[$structure->userid]['structures'][] = $structure;
                }

                foreach ($categoriesbyuser as $item) {
                    $curuser = $item['user'];

                    $table = new html_table();
                    $table->width = "100%";
                    // $table->size = array('40%', '20%', '20%', '20%'); // with copying
                    $table->size = array('40%', '30%', '30%'); // without copying
                    $table->head = array(
                        block_exaport_get_string('category'),
                        block_exaport_get_string("sharedwith"),
                        '',
                        '',
                    );
                    $table->data = array();

                    foreach ($item['structures'] as $structure) {
                        $structurecontent = '<div class="structure_head"><span class="structure_header">';
                        $structurecontent .= $structure->name;
                        $structurecontent .= '</span></div>';
                        $structurecontent .= '<div class="structure_content">';
                        $structurecontent .= block_exaport_get_structure_content($structure->id);
                        $structurecontent .= '</div>';
                        $link = '<a href="' . $CFG->wwwroot . '/blocks/exaport/view_items.php?courseid=' . $courseid . '&type=shared&userid=' .
                            $structure->userid . '&categoryid=' . $structure->id . '">'
                            . block_exaport_fontawesome_icon('folder-open', 'regular', 2, [], [], [], '', [], [], [], ['exaport-items-category-middle'])
                            //                                            .'<img src="pix/folder_32.png" />'
                            . get_string("browsecategory", "block_exaport") . '</a>';
                        $link2 = '';
                        if ($CFG->block_exaport_copy_category_to_my) {
                            $link2 = '<a href="shared_categories.php?courseid=' . $courseid . '&action=copy&categoryid=' . $structure->id . '">
                                                <img src="pix/folder_new_32.png" /><br />' . get_string("copycategory", "block_exaport") .
                                '</a>';
                        }
                        $t_data = array(
                            $structurecontent,
                            block_exaport_get_shared_with_text($structure, 'categories'),
                            $link,
                        );
                        if ($link2) {
                            $t_data[] = $link2;
                        }
                        $table->data[] = $t_data;
                    }

                    echo '<div class="view-group">';
                    echo '<div class="header view-group-header" style="align: right">';
                    echo '<span class="view-group-pic">' . $OUTPUT->user_picture($curuser, array('link' => false)) . '</span>';
                    echo '<span class="view-group-title">' . fullname($curuser) . ' (' . count($item['structures']) . ') </span>';
                    echo '</div>';

                    echo '<div class="view-group-content">';
                    echo html_writer::table($table);
                    echo '</div>';

                    echo '</div>';
                }
                break;
            default:
                $table = new html_table();
                $table->width = "100%";
                // $table->size = array('1%', '20%', '20%', '20%', '20%', '20%'); // with copying
                $table->size = array('1%', '25%', '25%', '25%', '25%'); // without copying
                $table->head = array(
                    '',
                    get_string('user'),
                    block_exaport_get_string('category'),
                    block_exaport_get_string("sharedwith"),
                    '',
                    '',
                );
                $table->data = array();

                foreach ($mainstructuregroup as $structure) {
                    $curuser = $DB->get_record('user', array("id" => $structure->userid));
                    $structurecontent = '<div class="structure_head"><span class="structure_header">' . $structure->name . '</span></div>';
                    $structurecontent .= '<div class="structure_content">' . block_exaport_get_structure_content($structure->id) . '</div>';
                    $link = '<a href="' . $CFG->wwwroot . '/blocks/exaport/view_items.php?courseid=' . $courseid . '&type=shared&userid=' .
                        $structure->userid . '&categoryid=' . $structure->id . '">'
                        . block_exaport_fontawesome_icon('folder-open', 'regular', 2, [], [], [], '', [], [], [], ['exaport-items-category-middle'])
                        //                                        .'<img src="pix/folder_32.png" />'
                        . get_string("browsecategory", "block_exaport") . '</a>';
                    $link2 = '';
                    if ($CFG->block_exaport_copy_category_to_my) {
                        $link2 = '<a href="shared_categories.php?courseid=' . $courseid . '&action=copy&categoryid=' . $structure->id . '">
                                        <img src="pix/folder_new_32.png" /><br />' . get_string("copycategory", "block_exaport") . '</a>';
                    }
                    $t_data = array(
                        $OUTPUT->user_picture($curuser, array("courseid" => $courseid)),
                        fullname($curuser),
                        $structurecontent,
                        block_exaport_get_shared_with_text($structure, 'categories'),
                        $link,
                    );
                    if ($link2) {
                        $t_data[] = $link2;
                    }
                    $table->data[] = $t_data;
                }
                echo html_writer::table($table);
        }
    }
}

// List shared structures.
echo "<div class='block_eportfolio_center'>\n";
echo '<div style="padding-bottom: 20px;">';
$students = block_exaport_get_students_for_teacher();
if (!$categories && count($students) == 0) {
    echo get_string("nothingstructureshared", "block_exaport");
} else {
    exaport_print_structures($categories, $parsedsort);
}

echo "</div>";
echo block_exaport_wrapperdivend();
echo block_exaport_print_footer();

function block_exaport_get_shared_with_text($structure, $target = '') {
    global $DB;
    static $js_code = null;
    $shared = "";
    if ($js_code === null) {
        if ($target == 'categories') {
            $js_code = '
                <script>
                function toggleUsersList(elId) {
                    var x = document.getElementById(elId);
                    if (x.style.display === "none") {
                        x.style.display = "block";
                    } else {
                        x.style.display = "none";
                    };
                    return false;
                }
                </script>
            ';
            $shared .= $js_code;
        }
    }

    if ($structure->cnt_shared_groups == 1) {
        $shared .= block_exaport_get_string('sharedwith_group');
    } else if ($structure->cnt_shared_groups > 1) {
        $shared .= block_exaport_get_string('sharedwith_group_cnt', $structure->cnt_shared_groups);
        if ($target == 'categories') {
            $shared .= '&nbsp;(<a onClick="return toggleUsersList(\'groupList' . $structure->id . '\')" href="">';
            $shared .= block_exaport_get_string('list');
            $shared .= '</a>)';
            // add list of shared users
            $sharedgroups = $DB->get_records_sql(
                'SELECT c.*
                FROM {block_exaportcatgroupshar} cgmm
                LEFT JOIN {cohort} c ON c.id = cgmm.groupid
                WHERE cgmm.catid = ?
                ORDER BY c.name',
                [$structure->id]
            );
            $shared .= '<ul class="exaport-shared-list" style="display: none;" id="groupList' . $structure->id . '">';
            foreach ($sharedgroups as $group) {
                $shared .= '<li>' . $group->name . '</li>';
            }
            $shared .= '</ul>';
        }
    } else if ($structure->shareall) {
        $shared .= block_exaport_get_string('sharedwith_shareall');
    } else if ($structure->cnt_shared_users > 1) {
        $shared .= block_exaport_get_string('sharedwith_user_cnt', $structure->cnt_shared_users);
        if ($target == 'categories') {
            $shared .= '&nbsp;(<a onClick="return toggleUsersList(\'usersList' . $structure->id . '\')" href="">';
            $shared .= block_exaport_get_string('list');
            $shared .= '</a>)';
            // add list of shared users
            $sharedusers = $DB->get_records_sql(
                'SELECT u.*
                FROM {block_exaportcatshar} csmm
                LEFT JOIN {user} u ON u.id = csmm.userid
                WHERE csmm.catid = ?
                ORDER BY u.firstname, u.lastname',
                [$structure->id]
            );
            $shared .= '<ul class="exaport-shared-list" style="display: none;" id="usersList' . $structure->id . '">';
            foreach ($sharedusers as $user) {
                $shared .= '<li>' . fullname($user) . '</li>';
            }
            $shared .= '</ul>';
        }
    } else if ($structure->cnt_shared_users) {
        $shared .= block_exaport_get_string('sharedwith_onlyme');
    }
    return $shared;
}

// Shared structure as a tree.
function block_exaport_get_structure_content($categoryid) {
    global $DB;
    $content = '<ul>';
    $currcat = $DB->get_records("block_exaportcate", array('pid' => $categoryid));
    foreach ($currcat as $id => $category) {
        $content .= '<li>' . $category->name . '</li>';
        $content .= block_exaport_get_structure_content($id);
    }
    $content .= '</ul>';
    return $content;
}

function rek_category_select_setup($outercategories, $entryname, $categories) {
    global $DB, $USER;
    foreach ($outercategories as $curcategory) {
        $categories[$curcategory->id] = $entryname . format_string($curcategory->name);
        $name = $entryname . format_string($curcategory->name);

        $conditions = array("userid" => $USER->id, "pid" => $curcategory->id);
        $innercategories = $DB->get_records_select("block_exaportcate", "userid = ? AND pid = ?", $conditions, "name asc");
        if ($innercategories) {
            $categories = rek_category_select_setup($innercategories, $name . ' &rArr; ', $categories);
        }
    }
    return $categories;
}

?>