GemsTracker/gemstracker-library

View on GitHub
classes/Gems/Util/DbLookup.php

Summary

Maintainability
D
3 days
Test Coverage
F
33%

File DbLookup.php has 442 lines of code (exceeds 250 allowed). Consider refactoring.
Open

<?php

/**
 *
 * @package    Gems
Severity: Minor
Found in classes/Gems/Util/DbLookup.php - About 6 hrs to fix

    Function getSurveysForExport has a Cognitive Complexity of 35 (exceeds 5 allowed). Consider refactoring.
    Open

        public function getSurveysForExport($trackId = null, $roundDescription = null, $flat = false, $keepSourceInactive = false)
        {
            // Read some data from tables, initialize defaults...
            $select = $this->db->select();
    
    
    Severity: Minor
    Found in classes/Gems/Util/DbLookup.php - About 5 hrs to fix

    Cognitive Complexity

    Cognitive Complexity is a measure of how difficult a unit of code is to intuitively understand. Unlike Cyclomatic Complexity, which determines how difficult your code will be to test, Cognitive Complexity tells you how difficult your code will be to read and comprehend.

    A method's cognitive complexity is based on a few simple rules:

    • Code is not considered more complex when it uses shorthand that the language provides for collapsing multiple statements into one
    • Code is considered more complex for each "break in the linear flow of the code"
    • Code is considered more complex when "flow breaking structures are nested"

    Further reading

    Gems_Util_DbLookup has 32 functions (exceeds 20 allowed). Consider refactoring.
    Open

    class Gems_Util_DbLookup extends UtilAbstract
    {
        const SURVEY_ACTIVE          = 'active';
        const SURVEY_INACTIVE        = 'inactive';
        const SURVEY_SOURCE_INACTIVE = 'source inactive';
    Severity: Minor
    Found in classes/Gems/Util/DbLookup.php - About 4 hrs to fix

      The class Gems_Util_DbLookup has an overall complexity of 66 which is very high. The configured complexity threshold is 50.
      Open

      class Gems_Util_DbLookup extends UtilAbstract
      {
          const SURVEY_ACTIVE          = 'active';
          const SURVEY_INACTIVE        = 'inactive';
          const SURVEY_SOURCE_INACTIVE = 'source inactive';
      Severity: Minor
      Found in classes/Gems/Util/DbLookup.php by phpmd

      Method getSurveysForExport has 53 lines of code (exceeds 25 allowed). Consider refactoring.
      Open

          public function getSurveysForExport($trackId = null, $roundDescription = null, $flat = false, $keepSourceInactive = false)
          {
              // Read some data from tables, initialize defaults...
              $select = $this->db->select();
      
      
      Severity: Major
      Found in classes/Gems/Util/DbLookup.php - About 2 hrs to fix

        Function getDefaultGroup has a Cognitive Complexity of 12 (exceeds 5 allowed). Consider refactoring.
        Open

            public function getDefaultGroup()
            {
                $groups  = $this->getActiveStaffGroups();
                $roles   = $this->db->fetchPairs('SELECT ggp_role, ggp_id_group FROM gems__groups WHERE ggp_group_active=1 AND ggp_staff_members=1 ORDER BY ggp_name');
                $current = null;
        Severity: Minor
        Found in classes/Gems/Util/DbLookup.php - About 1 hr to fix

        Cognitive Complexity

        Cognitive Complexity is a measure of how difficult a unit of code is to intuitively understand. Unlike Cyclomatic Complexity, which determines how difficult your code will be to test, Cognitive Complexity tells you how difficult your code will be to read and comprehend.

        A method's cognitive complexity is based on a few simple rules:

        • Code is not considered more complex when it uses shorthand that the language provides for collapsing multiple statements into one
        • Code is considered more complex for each "break in the linear flow of the code"
        • Code is considered more complex when "flow breaking structures are nested"

        Further reading

        Function getRolesByPrivilege has a Cognitive Complexity of 6 (exceeds 5 allowed). Consider refactoring.
        Open

            public function getRolesByPrivilege($privilege)
            {
                $roles = array();
        
                if ($this->acl) {
        Severity: Minor
        Found in classes/Gems/Util/DbLookup.php - About 25 mins to fix

        Cognitive Complexity

        Cognitive Complexity is a measure of how difficult a unit of code is to intuitively understand. Unlike Cyclomatic Complexity, which determines how difficult your code will be to test, Cognitive Complexity tells you how difficult your code will be to read and comprehend.

        A method's cognitive complexity is based on a few simple rules:

        • Code is not considered more complex when it uses shorthand that the language provides for collapsing multiple statements into one
        • Code is considered more complex for each "break in the linear flow of the code"
        • Code is considered more complex when "flow breaking structures are nested"

        Further reading

        Function getCommTemplates has a Cognitive Complexity of 6 (exceeds 5 allowed). Consider refactoring.
        Open

            public function getCommTemplates($mailTarget = false)
            {
                static $data;
        
                if (! $data) {
        Severity: Minor
        Found in classes/Gems/Util/DbLookup.php - About 25 mins to fix

        Cognitive Complexity

        Cognitive Complexity is a measure of how difficult a unit of code is to intuitively understand. Unlike Cyclomatic Complexity, which determines how difficult your code will be to test, Cognitive Complexity tells you how difficult your code will be to read and comprehend.

        A method's cognitive complexity is based on a few simple rules:

        • Code is not considered more complex when it uses shorthand that the language provides for collapsing multiple statements into one
        • Code is considered more complex for each "break in the linear flow of the code"
        • Code is considered more complex when "flow breaking structures are nested"

        Further reading

        The method getSurveysForExport() has a Cyclomatic Complexity of 13. The configured cyclomatic complexity threshold is 10.
        Open

            public function getSurveysForExport($trackId = null, $roundDescription = null, $flat = false, $keepSourceInactive = false)
            {
                // Read some data from tables, initialize defaults...
                $select = $this->db->select();
        
        
        Severity: Minor
        Found in classes/Gems/Util/DbLookup.php by phpmd

        CyclomaticComplexity

        Since: 0.1

        Complexity is determined by the number of decision points in a method plus one for the method entry. The decision points are 'if', 'while', 'for', and 'case labels'. Generally, 1-4 is low complexity, 5-7 indicates moderate complexity, 8-10 is high complexity, and 11+ is very high complexity.

        Example

        // Cyclomatic Complexity = 11
        class Foo {
        1   public function example() {
        2       if ($a == $b) {
        3           if ($a1 == $b1) {
                        fiddle();
        4           } elseif ($a2 == $b2) {
                        fiddle();
                    } else {
                        fiddle();
                    }
        5       } elseif ($c == $d) {
        6           while ($c == $d) {
                        fiddle();
                    }
        7        } elseif ($e == $f) {
        8           for ($n = 0; $n < $h; $n++) {
                        fiddle();
                    }
                } else {
                    switch ($z) {
        9               case 1:
                            fiddle();
                            break;
        10              case 2:
                            fiddle();
                            break;
        11              case 3:
                            fiddle();
                            break;
                        default:
                            fiddle();
                            break;
                    }
                }
            }
        }

        Source https://phpmd.org/rules/codesize.html#cyclomaticcomplexity

        Similar blocks of code found in 3 locations. Consider refactoring.
        Open

            public function getPatientNr($respondentId, $organizationId)
            {
                $result = $this->db->fetchOne(
                        "SELECT gr2o_patient_nr FROM gems__respondent2org WHERE gr2o_id_user = ? AND gr2o_id_organization = ?",
                        array($respondentId, $organizationId)
        Severity: Major
        Found in classes/Gems/Util/DbLookup.php and 2 other locations - About 1 hr to fix
        classes/Gems/Util/DbLookup.php on lines 364..381
        classes/Gems/Util/DbLookup.php on lines 391..415

        Duplicated Code

        Duplicated code can lead to software that is hard to understand and difficult to change. The Don't Repeat Yourself (DRY) principle states:

        Every piece of knowledge must have a single, unambiguous, authoritative representation within a system.

        When you violate DRY, bugs and maintenance problems are sure to follow. Duplicated code has a tendency to both continue to replicate and also to diverge (leaving bugs as two similar implementations differ in subtle ways).

        Tuning

        This issue has a mass of 106.

        We set useful threshold defaults for the languages we support but you may want to adjust these settings based on your project guidelines.

        The threshold configuration represents the minimum mass a code block must have to be analyzed for duplication. The lower the threshold, the more fine-grained the comparison.

        If the engine is too easily reporting duplication, try raising the threshold. If you suspect that the engine isn't catching enough duplication, try lowering the threshold. The best setting tends to differ from language to language.

        See codeclimate-duplication's documentation for more information about tuning the mass threshold in your .codeclimate.yml.

        Refactorings

        Further Reading

        Similar blocks of code found in 3 locations. Consider refactoring.
        Open

            public function getRespondentIdAndName($patientId, $organizationId)
            {
                $output = $this->db->fetchRow(
                        "SELECT gr2o_id_user as id,
                            TRIM(CONCAT(
        Severity: Major
        Found in classes/Gems/Util/DbLookup.php and 2 other locations - About 1 hr to fix
        classes/Gems/Util/DbLookup.php on lines 337..354
        classes/Gems/Util/DbLookup.php on lines 364..381

        Duplicated Code

        Duplicated code can lead to software that is hard to understand and difficult to change. The Don't Repeat Yourself (DRY) principle states:

        Every piece of knowledge must have a single, unambiguous, authoritative representation within a system.

        When you violate DRY, bugs and maintenance problems are sure to follow. Duplicated code has a tendency to both continue to replicate and also to diverge (leaving bugs as two similar implementations differ in subtle ways).

        Tuning

        This issue has a mass of 106.

        We set useful threshold defaults for the languages we support but you may want to adjust these settings based on your project guidelines.

        The threshold configuration represents the minimum mass a code block must have to be analyzed for duplication. The lower the threshold, the more fine-grained the comparison.

        If the engine is too easily reporting duplication, try raising the threshold. If you suspect that the engine isn't catching enough duplication, try lowering the threshold. The best setting tends to differ from language to language.

        See codeclimate-duplication's documentation for more information about tuning the mass threshold in your .codeclimate.yml.

        Refactorings

        Further Reading

        Similar blocks of code found in 3 locations. Consider refactoring.
        Open

            public function getRespondentId($patientId, $organizationId)
            {
                $result = $this->db->fetchOne(
                        "SELECT gr2o_id_user FROM gems__respondent2org WHERE gr2o_patient_nr = ? AND gr2o_id_organization = ?",
                        array($patientId, $organizationId)
        Severity: Major
        Found in classes/Gems/Util/DbLookup.php and 2 other locations - About 1 hr to fix
        classes/Gems/Util/DbLookup.php on lines 337..354
        classes/Gems/Util/DbLookup.php on lines 391..415

        Duplicated Code

        Duplicated code can lead to software that is hard to understand and difficult to change. The Don't Repeat Yourself (DRY) principle states:

        Every piece of knowledge must have a single, unambiguous, authoritative representation within a system.

        When you violate DRY, bugs and maintenance problems are sure to follow. Duplicated code has a tendency to both continue to replicate and also to diverge (leaving bugs as two similar implementations differ in subtle ways).

        Tuning

        This issue has a mass of 106.

        We set useful threshold defaults for the languages we support but you may want to adjust these settings based on your project guidelines.

        The threshold configuration represents the minimum mass a code block must have to be analyzed for duplication. The lower the threshold, the more fine-grained the comparison.

        If the engine is too easily reporting duplication, try raising the threshold. If you suspect that the engine isn't catching enough duplication, try lowering the threshold. The best setting tends to differ from language to language.

        See codeclimate-duplication's documentation for more information about tuning the mass threshold in your .codeclimate.yml.

        Refactorings

        Further Reading

        Avoid excessively long variable names like $currentOrganizationId. Keep variable name length under 20.
        Open

                $currentOrganizationId = $this->loader->getCurrentUser()->getCurrentOrganizationId();
        Severity: Minor
        Found in classes/Gems/Util/DbLookup.php by phpmd

        LongVariable

        Since: 0.2

        Detects when a field, formal or local variable is declared with a long name.

        Example

        class Something {
            protected $reallyLongIntName = -3; // VIOLATION - Field
            public static function main( array $interestingArgumentsList[] ) { // VIOLATION - Formal
                $otherReallyLongName = -5; // VIOLATION - Local
                for ($interestingIntIndex = 0; // VIOLATION - For
                     $interestingIntIndex < 10;
                     $interestingIntIndex++ ) {
                }
            }
        }

        Source https://phpmd.org/rules/naming.html#longvariable

        Avoid variables with short names like $id. Configured minimum length is 3.
        Open

                        $id   = $surveyData['gsu_id_survey'];
        Severity: Minor
        Found in classes/Gems/Util/DbLookup.php by phpmd

        ShortVariable

        Since: 0.2

        Detects when a field, local, or parameter has a very short name.

        Example

        class Something {
            private $q = 15; // VIOLATION - Field
            public static function main( array $as ) { // VIOLATION - Formal
                $r = 20 + $this->q; // VIOLATION - Local
                for (int $i = 0; $i < 10; $i++) { // Not a Violation (inside FOR)
                    $r += $this->q;
                }
            }
        }

        Source https://phpmd.org/rules/naming.html#shortvariable

        There are no issues that match your filters.

        Category
        Status