Proyectos de Subversion Moodle

Rev

Rev 509 | Ir a la última revisión | Autoría | Comparar con el anterior | Ultima modificación | Ver Log | 

<?php
defined('MOODLE_INTERNAL') || die();

use core_completion\progress;

global $CFG;
require_once $CFG->libdir  . '/externallib.php';
require_once $CFG->dirroot . '/course/classes/category.php';
require_once $CFG->dirroot . '/blocks/moodleblock.class.php';
require_once $CFG->dirroot . '/blocks/course_list/block_course_list.php';

class block_cursos_recientes_ajax_external extends \external_api
{
    public static function get_listado_de_cursos_recientes_parameters()
    {
        return new \external_function_parameters([
            'category_id' => new \external_value(PARAM_INT, 'Categoría de los Cursos', VALUE_DEFAULT, 0),
            'search_text' => new \external_value(PARAM_ALPHANUM, 'Palabra de busqueda', VALUE_DEFAULT, ' '),
        ]);
    }

    public static function get_listado_de_cursos_recientes($category_id, $search_text)
    {

        /*
        [
        'category_id' => $category_id,
        'search_text' => $search_text,
        ] = self::validate_parameters(self::execute_parameters(), [
            'category_id' => $category_id,
            'search_text' => $search_text
        ]);
        */

        global $USER, $DB, $CFG, $OUTPUT, $PAGE;


        $userid = $USER->id;
        $url_noimage =  $CFG->wwwroot . '/theme/' . $PAGE->theme->name . '/pix/coursenoimage.jpg';

        $courses = [];
        $courselist = array();


        $mycourses = enrol_get_users_courses($userid);

        $courselist = array();
        foreach ($mycourses as $course) {
            if (!$course->visible) {
                continue;
            }


            if ($search_text) {
                if (stripos($course->fullname, $search_text) === false) {
                    continue;
                }
            }

            if ($category_id) {
                if ($category_id != $course->category) {
                    continue;
                }
            }

            $category = $DB->get_record('course_categories', array('id' => $course->category, 'visible' => 1));
            if (!$category) {
                continue;
            }


            if ($course instanceof stdClass) {
                $courseInList = new core_course_list_element($course);
            }
            $image = $url_noimage;
            foreach ($courseInList->get_course_overviewfiles() as $file) {
                $isimage = $file->is_valid_image();
                $image = file_encode_url("{$CFG->wwwroot}/pluginfile.php", '/' . $file->get_contextid() . '/' . $file->get_component() . '/' . $file->get_filearea() . $file->get_filepath() . $file->get_filename(), !$isimage);
                if (!$isimage) {
                    $image = $url_noimage;
                }
            }

            $lastaccess = null;
            $sql = "select timecreated  from {logstore_standard_log} where courseid  = :courseid and userid  = :userid " .
                "  and eventname  = '\\\\core\\\\event\\\\course_viewed' order by id desc limit 1 ";

            $timecreated = $DB->get_field_sql($sql,  array('courseid' => $course->id, 'userid' => $userid));
            if ($timecreated) {

                $lastaccess = date('d/m/Y h:i a', $timecreated);
            }



            $miProgreso = number_format(progress::get_course_progress_percentage($course), 2); // Progreso por curso


            $first_section = 0;
            $sections = $DB->get_records('course_sections', ['course' => $course->id], 'section ASC', 'id,name,section,sequence,visible');

            foreach ($sections as $section) {
                if (!empty($section->section)) {
                    $first_section = $section->id;
                    break;
                }
            }
            $course_context = context_course::instance($course->id);
            $roles = get_user_roles($course_context, $USER->id, true);

            $completion_edit_curso = false;
            foreach ($roles as $role) {
                if ($role->shortname == 'companydepartmentmanager' || $role->shortname == 'companycoursenoneditor') {
                    $completion_edit_curso  = true;
                    break;
                }
            }

            if (has_capability('moodle/course:manageactivities', $course_context, $USER->id) || has_capability('moodle/course:viewhiddenactivities', $course_context, $USER->id) || $completion_edit_curso) {
                $editurl = $CFG->wwwroot . '/course/view.php?id=' . $course->id . '&notifyeditingon=1';

                //$editurl = $CFG->wwwroot . '/course/edit.php?id=' . $course->id;
            } else {
                $editurl = '';
            }



            $modules = get_fast_modinfo($course->id)->get_cms();



            $linkurl = '';
            foreach ($modules as $module) {




                //print "!".$module->uservisible ."||". $module->is_stealth() ."||". $module->url ."||". $module->section."<br>";
                if (!$module->uservisible || $module->is_stealth() || empty($module->url) || empty($module->section)) {
                    continue;
                }

                if ($module->section == $first_section || $completion_edit_curso) {





                    $linkurl =  new moodle_url($module->url, array('forceview' => 1));
                    //print_r($linkurl);
                    //var_dump($linkurl);
                    break;
                }
            }
            /*
            if( $completion_edit_curso){
                $linkurl = $CFG->wwwroot . '/course/view.php?id=' . $course->id;
            }*/

            $summary = trim(strip_tags($course->summary));

            if (empty($summary)) {
                $summary = `<p></p>`;
            } else if (strlen($summary) > 80) {

                $summary =  substr($summary, 0, 80) . '...';
            }

            $courses[] = [

                'coursecategory' => $category->name,
                'courseimage' => $image,
                'enddate' => $course->enddate,
                'fullname' => $course->fullname,
                'fullnamedisplay' => get_course_display_name_for_list($course),
                'hasprogress' => true,
                'hidden' => false,
                'id' => $course->id,
                'idnumber' => $course->idnumber,
                'isfavourite' => false,
                'progress' => $miProgreso,
                'shortname' => $course->shortname,
                'showshortname' => false,
                'startdate' => $course->startdate,
                'summary' =>  $summary,
                'summaryformat' => $course->summaryformat,
                'timeaccess' => $lastaccess,
                'viewurl' => $linkurl,
                'editurl' => $editurl,
                'visible' => true,

            ];
        }

        $data = [
            'courses' => $courses
        ];

        $cards = $OUTPUT->render_from_template('block_cursos_recientes_ajax/cards', $data);


        return json_encode(['success' => true, 'search_text' => $search_text, 'category_id' => $category_id,  'cards' => $cards]);
    }

    public static function get_listado_de_cursos_recientes_returns()
    {
        return new \external_value(PARAM_RAW, 'The updated JSON output');
    }

    public static function get_cursos_catalogo_parameters()
    {
        return new \external_function_parameters([
            'category_id' => new \external_value(PARAM_INT, 'Categoría de los Cursos', VALUE_DEFAULT, 0),
            'search_text' => new \external_value(PARAM_ALPHANUM, 'Palabra de busqueda', VALUE_DEFAULT, ' '),
        ]);
    }

    public static function get_cursos_catalogo($category_id, $search_text)
    {


        global $USER, $DB, $CFG, $OUTPUT, $PAGE;



        $userid = $USER->id;
        $url_noimage =  $CFG->wwwroot . '/theme/' . $PAGE->theme->name . '/pix/coursenoimage.jpg';

        $is_admin = false;
        $admins = get_admins();
        foreach ($admins as $admin) {
            if ($USER->id == $admin->id) {
                $is_admin = true;
                break;
            }
        }

        $all_categories = [];
        $records = $DB->get_records('course_categories', ['visible' => 1], 'sortorder, name');
        foreach ($records as $record) {
            $all_categories[$record->id] = $record;
        }


        $categories_ids = [];
        $category_filter_active = false;
        if ($category_id) {
            $category_filter_active = true;

            $recordLevel0 = $DB->get_record('course_categories', ['id' => $category_id]);


            if ($recordLevel0) {
                array_push($categories_ids, $recordLevel0->id);



                $recordsLevel1 = $DB->get_records('course_categories', ['visible' => 1, 'parent' => $recordLevel0->id]);

                foreach ($recordsLevel1 as $recordLevel1) {

                    array_push($categories_ids, $recordLevel1->id);

                    $recordsLevel2 = $DB->get_records('course_categories', ['visible' => 1, 'parent' => $recordLevel1->id]);
                    foreach ($recordsLevel2 as $recordLevel2) {
                        array_push($categories_ids, $recordLevel2->id);

                        $recordsLevel3 = $DB->get_records('course_categories', ['visible' => 2, 'parent' => $recordLevel2->id]);
                        foreach ($recordsLevel3 as $recordLevel3) {
                            array_push($categories_ids, $recordLevel3->id);
                        }
                    }
                }
            }
        }



        $course_ids                 = [];
        $course_category_ids        = [];
        $courseAvailableForAutoRol  = [];


        if ($is_admin) {
            $mycourses = get_courses();
        } else {
            $mycourses  = enrol_get_users_courses($USER->id);
        }



        foreach ($mycourses as $course) {
            if (!$course->visible) {
                continue;
            }

            if ($search_text) {
                if (stripos($course->fullname, $search_text) === false) {
                    continue;
                }
            }


            if ($category_filter_active) {
                if (!in_array($course->category, $categories_ids)) {
                    continue;
                }
            }


            array_push($course_ids, $course->id);
        }

        $courses_with_autoenrol  = $DB->get_records('enrol', ['enrol' => 'self', 'status' => 0]);
        foreach ($courses_with_autoenrol as $course_with_autoenrol) {
            $course = get_course($course_with_autoenrol->courseid);
            if (!$course->visible) {
                continue;
            }

            if ($search_text) {
                if (stripos($course_with_autoenrol->fullname, $search_text) === false) {
                    continue;
                }
            }

            if ($category_filter_active) {
                if (!in_array($course->category, $categories_ids)) {
                    continue;
                }
            }

            array_push($course_ids, $course->id);
            array_push($courseAvailableForAutoRol, $course->id);
        }






        $courses = [];
        foreach ($course_ids as $course_id) {
            $course = get_course($course_id);

            if ($course instanceof stdClass) {
                $coreCourseList = new core_course_list_element($course);
            }

            if (!in_array($course->category, $course_category_ids)) {


                array_push($course_category_ids, $course->category);
            }


            $image = $url_noimage;
            foreach ($coreCourseList->get_course_overviewfiles() as $file) {
                $isimage = $file->is_valid_image();
                $image = file_encode_url("{$CFG->wwwroot}/pluginfile.php", '/' . $file->get_contextid() . '/' . $file->get_component() . '/' . $file->get_filearea() . $file->get_filepath() . $file->get_filename(), !$isimage);
                if (!$isimage) {
                    $image = $url_noimage;
                }
            }

            $lastaccess = null;
            $sql = "select timecreated  from {logstore_standard_log} where courseid  = :courseid and userid  = :userid " .
                "  and eventname  = '\\\\core\\\\event\\\\course_viewed' order by id desc limit 1 ";

            $timecreated = $DB->get_field_sql($sql,  array('courseid' => $course->id, 'userid' => $userid));
            if ($timecreated) {

                $lastaccess = date('d/m/Y h:i a', $timecreated);
            }

            $first_section = 0;
            $sections = $DB->get_records('course_sections', ['course' => $course->id], 'section ASC', 'id,name,section,sequence,visible');

            foreach ($sections as $section) {
                if (!empty($section->section)) {
                    $first_section = $section->id;
                    break;
                }
            }

            $course_context = context_course::instance($course->id);
            $roles = get_user_roles($course_context, $USER->id, true);

            $completion_edit_curso = false;
            foreach ($roles as $role) {
                if ($role->shortname == 'companydepartmentmanager' || $role->shortname == 'companycoursenoneditor') {
                    $completion_edit_curso  = true;
                    break;
                }
            }

            if (has_capability('moodle/course:manageactivities', $course_context, $USER->id) || has_capability('moodle/course:viewhiddenactivities', $course_context, $USER->id) || $completion_edit_curso) {
                $editurl = $CFG->wwwroot . '/course/view.php?id=' . $course->id . '&notifyeditingon=1';
            } else {
                $editurl = '';
            }


            $modules = get_fast_modinfo($course->id)->get_cms();

            $linkurl = '';
            foreach ($modules as $module) {
                if (!$module->uservisible || $module->is_stealth() || empty($module->url) || empty($module->section)) {
                    continue;
                }

                if ($module->section == $first_section || $completion_edit_curso) {
                    $linkurl =  new moodle_url($module->url, array('forceview' => 1));
                    break;
                }
            }

            $summary = trim(strip_tags($course->summary));

            if (empty($summary)) {
                $summary = '<p></p>';
            } else if (strlen($summary) > 80) {

                $summary =  substr($summary, 0, 80) . '...';
            }

            if (empty($editurl) && in_array($course->id, $courseAvailableForAutoRol)) {
                $autoenrol = 'yes';
            } else {
                $autoenrol = '';
            }


            $category = $all_categories[$course->category];
            if ($category->parent) {
                $categoryParent = $all_categories[$category->parent];
                if ($categoryParent) {
                    $categoryName = $categoryParent->name . ' / ' . $category->name;
                } else {
                    $categoryName = $category->name;
                }
            } else {
                $categoryName =  $category->name;
            }
            if (strlen($categoryName) > 40) {

                $categoryName =  substr($categoryName, 0, 40) . '...';
            }


            // echo '<pre>';
            // echo '$categoryName = ' . $categoryName . ' $course->category = ' . $course->category;
            // echo '</pre>';


            array_push($courses, [
                'courseid' => $course->id,
                'coursecategory' => $categoryName,
                'courseimage' => $image,
                'enddate' => $course->enddate,
                'fullname' => $course->fullname,
                'fullnamedisplay' => get_course_display_name_for_list($course),
                'hidden' => false,
                'id' => $course->id,
                'idnumber' => $course->idnumber,
                'isfavourite' => false,
                'shortname' => $course->shortname,
                'showshortname' => false,
                'startdate' => $course->startdate,
                'summary' =>  $summary,
                'summaryformat' => $course->summaryformat,
                'timeaccess' => $lastaccess,
                'viewurl' => $linkurl,
                'editurl' => $editurl,
                'autoenrol' => $autoenrol,
                'visible' => true,
            ]);
        }

        usort($courses, function ($a, $b) {
            return $a['fullname'] <=> $b['fullname'];
        });




        $categories = [];
        foreach ($course_category_ids as $course_category_id) {
            $category = $all_categories[$course_category_id];
            if ($category) {
                array_push($categories, ['id' => $category->id, 'name' => $category->name]);
            }
        }





        $data = [
            'courses' => $courses
        ];

        $cards = $OUTPUT->render_from_template('block_cursos_catalogo_ajax/cards', $data);

        $data = [
            'categories' => $categories
        ];

        $badges = $OUTPUT->render_from_template('block_cursos_catalogo_ajax/badges', $data);


        return json_encode(['success' => true, 'search_text' => $search_text, 'category_id' => $category_id,  'cards' => $cards, 'badges' => $badges]);
    }


    public static function get_cursos_catalogo_returns()
    {
        return new \external_value(PARAM_RAW, 'The updated JSON output');
    }
}