Proyectos de Subversion Moodle

<?php

// This file is part of Moodle - http://moodle.org/

//

// 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/>.

/**

 * User evidence competency persistent.

 *

 * This represent the many to many relationship between evidence of prior

 * learning and competencies.

 *

 * @package    core_competency

 * @copyright  2015 Frédéric Massart - FMCorz.net

 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later

 */

namespace core_competency;

defined('MOODLE_INTERNAL') || die();

use stdClass;

use lang_string;

/**

 * User evidence competency persistent class.

 *

 * @package    core_competency

 * @copyright  2015 Frédéric Massart - FMCorz.net

 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later

 */

class user_evidence_competency extends persistent {

    const TABLE = 'competency_userevidencecomp';

    /**

     * Return the definition of the properties of this model.

     *

     * @return array

     */

    protected static function define_properties() {

        return array(

            'userevidenceid' => array(

                'type' => PARAM_INT

            ),

            'competencyid' => array(

                'type' => PARAM_INT,

            ),

        );

    }

    /**

     * Validate competency ID.

     *

     * @param  int $value ID.

     * @return true|lang_string

     */

    protected function validate_competencyid($value) {

        if (!competency::record_exists($value)) {

            return new lang_string('invaliddata', 'error');

        }

        return true;

    }

    /**

     * Validate user evidence ID.

     *

     * @param  int $value ID.

     * @return true|lang_string

     */

    protected function validate_userevidenceid($value) {

        if (!user_evidence::record_exists($value)) {

            return new lang_string('invaliddata', 'error');

        }

        return true;

    }

    /**

     * Get competencies by user evidence ID.

     *

     * @param  int $userevidenceid The user evidence ID.

     * @return competency[]

     */

    public static function get_competencies_by_userevidenceid($userevidenceid) {

        global $DB;

        $sql = "SELECT c.*

                  FROM {" . self::TABLE . "} uec

                  JOIN {" . competency::TABLE . "} c

                    ON uec.userevidenceid = ?

                   AND uec.competencyid = c.id

              ORDER BY c.shortname";

        $competencies = array();

        $records = $DB->get_recordset_sql($sql, array($userevidenceid));

        foreach ($records as $record) {

            $competencies[] = new competency(0, $record);

        }

        $records->close();

        return $competencies;

    }

    /**

     * Get user competencies by user evidence ID.

     *

     * @param  int $userevidenceid The user evidence ID.

     * @return user_competency[]

     */

    public static function get_user_competencies_by_userevidenceid($userevidenceid) {

        global $DB;

        $sql = "SELECT uc.*

                  FROM {" . user_competency::TABLE . "} uc

                  JOIN {" . self::TABLE . "} uec

                    ON uc.competencyid = uec.competencyid

                  JOIN {" . user_evidence::TABLE . "} ue

                    ON uec.userevidenceid = ue.id

                   AND uc.userid = ue.userid

                   AND ue.id = ?

              ORDER BY uc.id ASC";

        $usercompetencies = array();

        $records = $DB->get_recordset_sql($sql, array($userevidenceid));

        foreach ($records as $record) {

            $usercompetencies[] = new user_competency(0, $record);

        }

        $records->close();

        return $usercompetencies;

    }

    /**

     * Get a relation.

     *

     * This does not perform any validation on the data passed. If the relation exists in the database

     * then it is loaded in a the model, if not then it is up to the developer to save the model.

     *

     * @param int $userevidenceid

     * @param int $competencyid

     * @return template_cohort

     */

    public static function get_relation($userevidenceid, $competencyid) {

        global $DB;

        $params = array(

            'userevidenceid' => $userevidenceid,

            'competencyid' => $competencyid

        );

        $relation = new static(null, (object) $params);

        if ($record = $DB->get_record(static::TABLE, $params)) {

            $relation->from_record($record);

        }

        return $relation;

    }

    /**

     * Delete evidences using competencies.

     *

     * @param array $competencyids Array of competencies ids.

     * @return bool Return true if the delete was successful.

     */

    public static function delete_by_competencyids($competencyids) {

        global $DB;

        if (empty($competencyids)) {

            return true;

        }

        list($insql, $params) = $DB->get_in_or_equal($competencyids);

        return $DB->delete_records_select(self::TABLE, "competencyid $insql", $params);

    }

}