StatsMonthlyStats::execute()

Complexity

Conditions	6
Paths	3

Size

Total Lines	137
Code Lines	98

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	42

Importance

Changes	2
Bugs	1	Features	0

<?php
	protected function execute()
	{
		$qb = new QueryBrowser();

		$query = <<<SQL
SELECT
    COUNT(DISTINCT id) AS 'Requests Closed',
    YEAR(timestamp) AS 'Year',
    MONTHNAME(timestamp) AS 'Month'
FROM log
WHERE action LIKE 'Closed%'
GROUP BY EXTRACT(YEAR_MONTH FROM timestamp)
ORDER BY YEAR(timestamp) , MONTH(timestamp) ASC;
SQL;

		$out = $qb->executeQueryToTable($query);

		global $showGraphs;
		if ($showGraphs == 1) {
			global $filepath;
			require_once($filepath . 'graph/pChart/pChart.class');
			require_once($filepath . 'graph/pChart/pData.class');

			$queries = array();

			$queries[] = array(
					'query' => <<<SQL
SELECT
    COUNT(DISTINCT id) AS 'y',
    CONCAT(YEAR(timestamp), '/', MONTHNAME(timestamp)) AS 'x'
FROM log
WHERE action LIKE 'Closed%'
  AND YEAR(timestamp) != 0
GROUP BY EXTRACT(YEAR_MONTH FROM timestamp)
ORDER BY YEAR(timestamp) , MONTH(timestamp) ASC;
SQL
					,
					'series' => "All closed requests by month"
				);
			$queries[] = array(
					'query' => <<<SQL
SELECT
    COUNT(DISTINCT id) AS 'y',
    CONCAT(YEAR(timestamp), '/', MONTHNAME(timestamp)) AS 'x'
FROM log
WHERE action LIKE 'Closed 0'
  AND YEAR(timestamp) != 0
GROUP BY EXTRACT(YEAR_MONTH FROM timestamp)
ORDER BY YEAR(timestamp) , MONTH(timestamp) ASC;
SQL
					,
					'series' => "Dropped requests by month"
				);

			$query = gGetDb()->query("SELECT id, name FROM emailtemplate WHERE active = '1';");
			if (!$query) {
				die("Query error.");

Using exit here is not recommended.

			}

			foreach ($query->fetchAll(PDO::FETCH_ASSOC) as $row) {
				$id = $row['id'];
				$name = $row['name'];
				$queries[] = array(
					'query' => <<<SQL
SELECT
    COUNT(DISTINCT id) AS 'y',
    CONCAT(YEAR(timestamp), '/', MONTHNAME(timestamp)) AS 'x'
FROM log
WHERE action LIKE 'Closed $id'
  AND YEAR(timestamp) != 0
GROUP BY EXTRACT(YEAR_MONTH FROM timestamp)
ORDER BY YEAR(timestamp) , MONTH(timestamp) ASC;
SQL
					,
					'series' => "$name requests by month"
				);
			}

			$queries[] = array(
					'query' => <<<SQL
SELECT
    COUNT(DISTINCT id) AS 'y',
    CONCAT(YEAR(timestamp), '/', MONTHNAME(timestamp)) AS 'x'
FROM log
WHERE action = 'Closed custom-y'
  AND YEAR(timestamp) != 0
GROUP BY EXTRACT(YEAR_MONTH FROM timestamp)
ORDER BY YEAR(timestamp) , MONTH(timestamp) ASC;
SQL
					,
					'series' => "Custom created requests by month"
				);
			$queries[] = array(
					'query' => <<<SQL
SELECT
    COUNT(DISTINCT id) AS 'y',
    CONCAT(YEAR(timestamp), '/', MONTHNAME(timestamp)) AS 'x'
FROM log
WHERE action = 'Closed custom-n'
  AND YEAR(timestamp) != 0
GROUP BY EXTRACT(YEAR_MONTH FROM timestamp)
ORDER BY YEAR(timestamp) , MONTH(timestamp) ASC;
SQL
					,
					'series' => "Custom not created requests by month"
				);

			global $availableRequestStates;
			foreach ($availableRequestStates as $state) {
				$queries[] = array(
					'query' => <<<SQL
SELECT
    COUNT(DISTINCT id) AS 'y',
    CONCAT(YEAR(timestamp), '/', MONTHNAME(timestamp)) AS 'x'
FROM log
WHERE action LIKE 'Deferred to {$state["defertolog"]}'
  AND YEAR(timestamp) != 0
GROUP BY EXTRACT(YEAR_MONTH FROM timestamp)
ORDER BY YEAR(timestamp) , MONTH(timestamp) ASC;
SQL
					,
					'series' => "Requests deferred to " . $state['deferto'] . " by month"
				);
			}

			global $baseurl;
			foreach ($this->createClosuresGraph($queries) as $i) {

				$out .= '<img src="' . $baseurl . '/render/' . $i[0] . '" alt="' . $i[1] . '"/>';
			}

		}
		else {
			$out .= BootstrapSkin::displayAlertBox("Graph drawing is currently disabled.", "alert-info", "", false, false, true);
		}

		return $out;
	}