TrainingHolder_Controller::MonthlyCourses() - Code Metrics - sunnysideup/silverstripe-traininglistingsandsignup - Measure and Improve Code Quality continuously with Scrutinizer

TrainingHolder_Controller::MonthlyCourses() C
last analyzed 2018-03-20 01:36 UTC

↳ Parent: TrainingHolder_Controller

Complexity

Conditions	7
Paths	8

Size

Total Lines	36
Code Lines	21

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	36
rs	6.7272
c	0
b	0
f	0
cc	7
eloc	21
nc	8
nop	0

<?php


class TrainingHolder extends Page
namespace YourVendor;

class YourClass { }
{
    private static $icon = "mysite/images/treeicons/TrainingHolder";


    //parents and children in sitetree
    private static $allowed_children = array("TrainingPage"); //can also be "none";

    private static $default_child = "TrainingPage";


    public function canCreate($member = null)
    {
        return TrainingHolder::get()->count() ? false: true;
    }

    public function canDelete($member = null)
    {
        return false;
    }

    public function getCMSFields()

    {
        $fields = parent::getCMSFields();
        return $fields;
    }
}

class TrainingHolder_Controller extends Page_Controller
namespace YourVendor;

class YourClass { }
{

    /**
     *
     * @return ArrayList
     */
    public function MonthlyCourses()
    {
        $results = new ArrayList();

        $stage = Versioned::current_stage();
        $suffix = (!$stage || $stage == 'Stage') ? "" : "_$stage";

        $sqlResults = DB::query("
			SELECT DISTINCT MONTH(\"Date\") AS \"Month\", YEAR(\"Date\") AS \"Year\"
			FROM \"SiteTree$suffix\" NATURAL JOIN \"TrainingPage$suffix\"
			WHERE \"ParentID\" = ".$this->ID." AND \"Date\" > CONVERT_TZ(now(),'+00:00','+13:00')
			ORDER BY \"Year\" DESC, \"Month\" ASC;"
        );

        if ($sqlResults) {
            foreach ($sqlResults as $sqlResult) {
                $month = (isset($sqlResult['Month'])) ? (int) $sqlResult['Month'] : 1;
                $year = ($sqlResult['Year']) ? (int) $sqlResult['Year'] : date('Y');

                $date = DBField::create_field('Date', array(
                'Day' => 1,
                'Month' => $month,
                'Year' => $year
            ));


                $results->push(new ArrayData(array(
                'Date' => $date,
                'Courses' => TrainingPage::get()
                    ->filter(array("ShowInMenus" => 1))
                    ->where(" MONTH(\"TrainingPage\".\"Date\") = $month AND YEAR(\"TrainingPage\".\"Date\") = $year")
            )));
            }
        }
        return $results;
    }
}


1			<?php
			0 ignored issues – show Coding Style introduced 2017-01-03 01:37 UTC by Report Bug Copy Issue Report File has mixed line endings; this may cause incorrect results Loading history...
2
3			class TrainingHolder extends Page
			0 ignored issues – show Coding Style Compatibility introduced 2017-01-03 01:37 UTC by Report Bug Copy Issue Report PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions. You can fix this by adding a namespace to your class: namespace YourVendor; class YourClass { } When choosing a vendor namespace, try to pick something that is not too generic to avoid conflicts with other libraries. Loading history...
4			{
5			private static $icon = "mysite/images/treeicons/TrainingHolder";
			0 ignored issues – show Unused Code introduced 2017-01-03 01:37 UTC by Report Bug Copy Issue Report The property `$icon` is not used and could be removed. This check marks private properties in classes that are never used. Those properties can be removed. Loading history...
6
7			//parents and children in sitetree
8			private static $allowed_children = array("TrainingPage"); //can also be "none";
			0 ignored issues – show Unused Code introduced 2017-01-03 01:37 UTC by Report Bug Copy Issue Report The property `$allowed_children` is not used and could be removed. This check marks private properties in classes that are never used. Those properties can be removed. Loading history...
9			private static $default_child = "TrainingPage";
			0 ignored issues – show Unused Code introduced 2017-01-03 01:37 UTC by Report Bug Copy Issue Report The property `$default_child` is not used and could be removed. This check marks private properties in classes that are never used. Those properties can be removed. Loading history...
10
11			public function canCreate($member = null)
12			{
13			return TrainingHolder::get()->count() ? false: true;
14			}
15
16			public function canDelete($member = null)
17			{
18			return false;
19			}
20
21			public function getCMSFields()
			0 ignored issues – show Documentation introduced 2018-02-21 04:23 UTC by Report Bug Copy Issue Report The return type could not be reliably inferred; please add a `@return` annotation. Our type inference engine in quite powerful, but sometimes the code does not provide enough clues to go by. In these cases we request you to add a `@return` annotation as described here. Loading history...
22			{
23			$fields = parent::getCMSFields();
24			return $fields;
25			}
26			}
27
28			class TrainingHolder_Controller extends Page_Controller
			0 ignored issues – show Coding Style Compatibility introduced 2017-01-03 01:37 UTC by Report Bug Copy Issue Report PSR1 recommends that each class should be in its own file to aid autoloaders. Having each class in a dedicated file usually plays nice with PSR autoloaders and is therefore a well established practice. If you use other autoloaders, you might not want to follow this rule. Loading history... Coding Style Compatibility introduced 2017-01-03 01:37 UTC by Report Bug Copy Issue Report PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions. You can fix this by adding a namespace to your class: namespace YourVendor; class YourClass { } When choosing a vendor namespace, try to pick something that is not too generic to avoid conflicts with other libraries. Loading history...
29			{
30
31			/**
32			*
33			* @return ArrayList
34			*/
35			public function MonthlyCourses()
36			{
37			$results = new ArrayList();
38
39			$stage = Versioned::current_stage();
40			$suffix = (!$stage \|\| $stage == 'Stage') ? "" : "_$stage";
41
42			$sqlResults = DB::query("
43			SELECT DISTINCT MONTH(\"Date\") AS \"Month\", YEAR(\"Date\") AS \"Year\"
44			FROM \"SiteTree$suffix\" NATURAL JOIN \"TrainingPage$suffix\"
45			WHERE \"ParentID\" = ".$this->ID." AND \"Date\" > CONVERT_TZ(now(),'+00:00','+13:00')
46			ORDER BY \"Year\" DESC, \"Month\" ASC;"
47			);
48
49			if ($sqlResults) {
50			foreach ($sqlResults as $sqlResult) {
51			$month = (isset($sqlResult['Month'])) ? (int) $sqlResult['Month'] : 1;
52			$year = ($sqlResult['Year']) ? (int) $sqlResult['Year'] : date('Y');
53
54			$date = DBField::create_field('Date', array(
55			'Day' => 1,
56			'Month' => $month,
57			'Year' => $year
58			));
59
60
61			$results->push(new ArrayData(array(
62			'Date' => $date,
63			'Courses' => TrainingPage::get()
64			->filter(array("ShowInMenus" => 1))
65			->where(" MONTH(\"TrainingPage\".\"Date\") = $month AND YEAR(\"TrainingPage\".\"Date\") = $year")
66			)));
67			}
68			}
69			return $results;
70			}
71			}
72

sunnysideup / silverstripe-traininglistingsandsignup

TrainingHolder_Controller::MonthlyCourses() C last analyzed 2018-03-20 01:36 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

TrainingHolder_Controller::MonthlyCourses() C
last analyzed 2018-03-20 01:36 UTC