SkillRelProfileModel::getSkillsByProfile() - Code Metrics - Inspection of "psalm: add skills libs" - chamilo/chamilo-lms - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 18111a...f46ab8 )

by Julito

created 2021-06-01 07:44 UTC

SkillRelProfileModel::getSkillsByProfile() A

↳ Parent: SkillRelProfileModel

Complexity

Conditions	3
Paths	2

Size

Total Lines	12
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	3
eloc	7
c	1
b	0
f	0
nc	2
nop	1
dl	0
loc	12
rs	10

<?php

/* For licensing terms, see /license.txt */

class SkillRelProfileModel extends Model
{
    public $columns = ['id', 'skill_id', 'profile_id'];

    /**
     * Constructor.
     */
    public function __construct()
    {
        $this->table = Database::get_main_table(TABLE_MAIN_SKILL_REL_PROFILE);
        $this->tableProfile = Database::get_main_table(TABLE_MAIN_SKILL_PROFILE);
    }

    /**
     * @param int $profileId
     *
     * @return array
     */
    public function getSkillsByProfile($profileId)
    {
        $profileId = (int) $profileId;
        $skills = $this->get_all(['where' => ['profile_id = ? ' => $profileId]]);
        $return = [];
        if (!empty($skills)) {
            foreach ($skills as $skill_data) {
                $return[] = $skill_data['skill_id'];
            }
        }

        return $return;
    }

    /**
     * This function is for getting profile info from profile_id.
     *
     * @param int $profileId
     *
     * @return array
     */
    public function getProfileInfo($profileId)
    {
        $profileId = (int) $profileId;
        $sql = "SELECT * FROM $this->table p
                INNER JOIN $this->tableProfile pr
                ON (pr.id = p.profile_id)
                WHERE p.profile_id = ".$profileId;
        $result = Database::query($sql);
        $profileData = Database::fetch_array($result, 'ASSOC');

        return $profileData;
    }
}


1			<?php
2
3			/* For licensing terms, see /license.txt */
4
5			class SkillRelProfileModel extends Model
6			{
7			public $columns = ['id', 'skill_id', 'profile_id'];
8
9			/**
10			* Constructor.
11			*/
12			public function __construct()
13			{
14			$this->table = Database::get_main_table(TABLE_MAIN_SKILL_REL_PROFILE);
15			$this->tableProfile = Database::get_main_table(TABLE_MAIN_SKILL_PROFILE);
16			}
17
18			/**
19			* @param int $profileId
20			*
21			* @return array
22			*/
23			public function getSkillsByProfile($profileId)
24			{
25			$profileId = (int) $profileId;
26			$skills = $this->get_all(['where' => ['profile_id = ? ' => $profileId]]);
27			$return = [];
28			if (!empty($skills)) {
29			foreach ($skills as $skill_data) {
30			$return[] = $skill_data['skill_id'];
31			}
32			}
33
34			return $return;
35			}
36
37			/**
38			* This function is for getting profile info from profile_id.
39			*
40			* @param int $profileId
41			*
42			* @return array
43			*/
44			public function getProfileInfo($profileId)
45			{
46			$profileId = (int) $profileId;
47			$sql = "SELECT * FROM $this->table p
48			INNER JOIN $this->tableProfile pr
49			ON (pr.id = p.profile_id)
50			WHERE p.profile_id = ".$profileId;
51			$result = Database::query($sql);
52			$profileData = Database::fetch_array($result, 'ASSOC');
53
54			return $profileData;
55			}
56			}
57

chamilo / chamilo-lms

Push — master ( 18111a...f46ab8 )

SkillRelProfileModel::getSkillsByProfile() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like