ReportsController::_findAllDataTable() - Code Metrics - Inspection of "Merge pull request #114 from devenbansod/fix_flash..." - phpmyadmin/error-reporting-server - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( b2e27a...34e86d )

by Michal

created 2016-01-22 08:47 UTC

ReportsController::_findAllDataTable() A

↳ Parent: ReportsController

Complexity

Conditions	3
Paths	3

Size

Total Lines	12
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	10
CRAP Score	3

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
c	1
b	0
f	0
dl	0
loc	12
ccs	10
cts	10
cp	1
rs	9.4285
cc	3
eloc	9
nc	3
nop	1
crap	3

<?php
/* vim: set noexpandtab sw=2 ts=2 sts=2: */
namespace App\Controller;

use App\Controller\AppController;
use App\Utility\Sanitize;
use Cake\Core\Configure;
use Cake\Log\Log;
use Cake\ORM\Table;
use Cake\ORM\TableRegistry;
use Cake\Network\Exception\NotFoundException;
/**
 * Reports controller handling reports creation and rendering
 *
 * phpMyAdmin Error reporting server
 * Copyright (c) phpMyAdmin project (http://www.phpmyadmin.net)
 *
 * Licensed under The MIT License
 * For full copyright and license information, please see the LICENSE.txt
 * Redistributions of files must retain the above copyright notice.
 *
 * @copyright     Copyright (c) phpMyAdmin project (http://www.phpmyadmin.net)
 * @package       Server.Controller
 * @link          http://www.phpmyadmin.net
 * @license       http://www.opensource.org/licenses/mit-license.php MIT License
 */

/**
 * Reports controller handling reports modification and rendering
 *
 * @package       Server.Controller
 */
class ReportsController extends AppController {

	public $components = array('RequestHandler');

	public $helpers = array('Html', 'Form', 'Reports', 'Incidents');
	public $uses = array('Incidents', 'Reports', 'Notifications', 'Developers');

	public function index() {
		$this->Reports->recursive = -1;
		$this->set('distinct_statuses',
			$this->_findArrayList($this->Reports->find()->select(['status'])->distinct(['status']),
			'status')
		);
		$this->set('distinct_versions',
			$this->_findArrayList($this->Reports->find()->select(['pma_version'])->distinct(['pma_version']), 'pma_version')
		);
		$this->set('distinct_error_names',
			$this->_findArrayList($this->Reports->find('all', array(
				'fields' => array('error_name'),
				'conditions' => array('error_name !=' => ''),
			))->distinct(['error_name']), 'error_name')
		);
		$this->set('statuses', $this->Reports->status);
        $this->autoRender = true;
	}

	public function view($reportId) {
		if (!$reportId) {
			throw new NotFoundException(__('Invalid Report'));
		}
		$report = $this->Reports->findById($reportId)->toArray();
		if (!$report) {
			throw new NotFoundException(__('Invalid Report'));
		}

		$this->set('report', $report);
		$this->set('project_name', Configure::read('GithubRepoPath'));
		$this->Reports->id = $reportId;
		$this->set('incidents', $this->Reports->getIncidents()->toArray());
		$this->set('incidents_with_description',
            $this->Reports->getIncidentsWithDescription());
		$this->set('incidents_with_stacktrace',
				$this->Reports->getIncidentsWithDifferentStacktrace());
		$this->set('related_reports', $this->Reports->getRelatedReports());
		$this->set('status', $this->Reports->status);
		$this->_setSimilarFields($reportId);

		// if there is an unread notification for this report, then mark it as read
		$current_developer = TableRegistry::get('Developers')->
class ParentClass {
    private $data = array();

    public function __call($method, array $args) {
        if (0 === strpos($method, 'get')) {
            return $this->data[strtolower(substr($method, 3))];
        }

        throw new \LogicException(sprintf('Unsupported method: %s', $method));
    }
}

/**
 * If this class knows which fields exist, you can specify the methods here:
 *
 * @method string getName()
 */
class SomeClass extends ParentClass { }
					findById($this->request->session()->read('Developer.id'))->all()->first();
		//$current_developer = Sanitize::clean($current_developer);
		if ($current_developer) {
			TableRegistry::get('Notifications')->deleteAll(
				array('developer_id' => $current_developer['Developer']['id'],
					'report_id' => $reportId
				),
				false

			);
		}
	}

	public function data_tables() {
		$subquery_params = [
			'fields' => [
				'report_id' => 'report_id',
				'inci_count' => 'COUNT(id)'
				],
			'group' => 'report_id'
		];
		$subquery = TableRegistry::get('incidents')->find('all', $subquery_params);

		// override automatic aliasing, for proper usage in joins
		$aColumns = [
			'id' => 'id',
			'error_name' => 'error_name',
			'error_message' => 'error_message',
			'pma_version' => 'pma_version',
			'status' => 'status',
			'exception_type' => 'exception_type',
			'inci_count' => 'inci_count'
		];

		$searchConditions = $this->_getSearchConditions($aColumns);
		$orderConditions = $this->_getOrder($aColumns);

		$params = [
			'fields' => $aColumns,
			'conditions' => [
					$searchConditions,
					'related_to is NULL'
				],
			'order' => $orderConditions,
		];

		$pagedParams = $params;
		$pagedParams['limit'] = intval($this->request->query('iDisplayLength'));
		$pagedParams['offset'] = intval($this->request->query('iDisplayStart'));

		$rows = $this->_findAllDataTable(
			$this->Reports->find('all', $pagedParams)->innerJoin(
				['incidents' => $subquery], ['incidents.report_id = Reports.id']
			)
		);
		//$rows = Sanitize::clean($rows);
		$totalFiltered = $this->Reports->find('all', $params)->count();

		// change exception_type from boolean values to strings
		$dispRows = array();
		foreach($rows as $row) {
			$row[4] = $this->Reports->status[$row[4]];
			$row[5] = (intval($row[5]))?('php'):('js');
			$input_elem = "<input type='checkbox' name='reports[]' value='"
				. $row[0]
				. "'/>";
			array_unshift($row, $input_elem);
			array_push($dispRows, $row);
		}
		$response = array(
			'iTotalRecords' => $this->Reports->find('all')->count(),
			'iTotalDisplayRecords' => $totalFiltered,
			'sEcho' => intval($this->request->query('sEcho')),
			'aaData' => $dispRows
		);
		$this->autoRender = false;
		$this->response->body(json_encode($response));
        return $this->response;
	}

	public function mark_related_to($reportId) {
		$relatedTo = $this->request->query("related_to");
		if (!$reportId
			|| !$relatedTo
			|| $reportId == $relatedTo
		) {
			throw new NotFoundException(__('Invalid Report'));
		}

		$report = $this->Reports->get($reportId);
		if (!$report) {
			throw new NotFoundException(__('Invalid Report'));
		}

		$this->Reports->addToRelatedGroup($report, $relatedTo);

		$flash_class = "alert alert-success";
		$this->Flash->default("This report has been marked the same as #"
class ParentClass {
    private $data = array();

    public function __call($method, array $args) {
        if (0 === strpos($method, 'get')) {
            return $this->data[strtolower(substr($method, 3))];
        }

        throw new \LogicException(sprintf('Unsupported method: %s', $method));
    }
}

/**
 * If this class knows which fields exist, you can specify the methods here:
 *
 * @method string getName()
 */
class SomeClass extends ParentClass { }
				. $relatedTo,
				array("params" => array("class" => $flash_class)));
		$this->redirect("/reports/view/$reportId");
	}

	public function unmark_related_to($reportId) {
		if (!$reportId) {
			throw new NotFoundException(__('Invalid Report'));
		}

		$report = $this->Reports->get($reportId);
		if (!$report) {
			throw new NotFoundException(__('Invalid Report'));
		}

		$this->Reports->removeFromRelatedGroup($report);

		$flash_class = "alert alert-success";
		$this->Flash->default("This report has been marked as different.",
class ParentClass {
    private $data = array();

    public function __call($method, array $args) {
        if (0 === strpos($method, 'get')) {
            return $this->data[strtolower(substr($method, 3))];
        }

        throw new \LogicException(sprintf('Unsupported method: %s', $method));
    }
}

/**
 * If this class knows which fields exist, you can specify the methods here:
 *
 * @method string getName()
 */
class SomeClass extends ParentClass { }
			array("params" => array("class" => $flash_class)));
		$this->redirect("/reports/view/$reportId");
	}

	public function change_state($reportId) {
		if (!$reportId) {
			throw new NotFoundException(__('Invalid Report'));
		}

		$report = $this->Reports->get($reportId);
		if (!$report) {
			throw new NotFoundException(__('Invalid Report'));
		}

		$state = $this->request->data['state'];
		$newState = $this->Reports->status[$state];
		if (!$newState) {
			throw new NotFoundException(__('Invalid State'));
		}
        $report->status = $state;
		$this->Reports->save($report);

		$flash_class = "alert alert-success";
		$this->Flash->default("The state has been successfully changed.",
class ParentClass {
    private $data = array();

    public function __call($method, array $args) {
        if (0 === strpos($method, 'get')) {
            return $this->data[strtolower(substr($method, 3))];
        }

        throw new \LogicException(sprintf('Unsupported method: %s', $method));
    }
}

/**
 * If this class knows which fields exist, you can specify the methods here:
 *
 * @method string getName()
 */
class SomeClass extends ParentClass { }
			array("params" => array("class" => $flash_class)));
		$this->redirect("/reports/view/$reportId");
	}

	/**
	 * To carry out mass actions on Reports
	 * Currently only to change their statuses.
	 * Can be Extended for other mass operations as well.
	 * Expects an array of Report Ids as a POST parameter.
	 *
	 */
	public function mass_action()
	{
		$flash_class = "alert alert-error";
		$state = $this->request->data['state'];
		$newState = $this->Reports->status[$state];
		if (!$newState) {
			Log::write(
				'error',
				'ERRORED: Invalid param "state" in ReportsController::mass_action()',
				'alert'
			);
			$msg = "ERROR: Invalid State!!";
		} else if (count($this->request->data['reports']) == 0) {
			$msg = "No Reports Selected!! Please Select Reports and try again.";
		} else {
			$msg = "Status has been changed to '"
				. $this->request->data['state']
				. "' for selected Reports!";
			$flash_class = "alert alert-success";
			foreach($this->request->data['reports'] as $report_id)
			{
				$report = $this->Reports->get($report_id);
				if (!$report) {
					Log::write(
						'error',
						'ERRORED: Invalid report_id in ReportsController::mass_action()',
						'alert'
					);
					$msg = "ERROR:Invalid Report ID:" . $report_id;
					$flash_class = "alert alert-error";
					break;
				}
                $report->status = $state;
				$this->Reports->save($report);
			}
		}

		$this->Flash->default($msg,
class ParentClass {
    private $data = array();

    public function __call($method, array $args) {
        if (0 === strpos($method, 'get')) {
            return $this->data[strtolower(substr($method, 3))];
        }

        throw new \LogicException(sprintf('Unsupported method: %s', $method));
    }
}

/**
 * If this class knows which fields exist, you can specify the methods here:
 *
 * @method string getName()
 */
class SomeClass extends ParentClass { }
			array("params" => array("class" => $flash_class)));
		$this->redirect("/reports/");
	}

## HELPERS
	protected function _setSimilarFields($id) {
		$this->Reports->id = $id;

		$this->set('columns', TableRegistry::get('Incidents')->summarizableFields);
		$relatedEntries = array();

		foreach (TableRegistry::get('Incidents')->summarizableFields as $field) {
			list($entriesWithCount, $totalEntries) =
					$this->Reports->getRelatedByField($field, 25, true);
			$relatedEntries[$field] = $entriesWithCount;
			$this->set("${field}_distinct_count", $totalEntries);
		}
        //error_log(json_encode($relatedEntries));
		$this->set("related_entries", $relatedEntries);
	}

	/**
	 * Indexes are +1'ed because first column is of checkboxes
	 * and hence it should be ingnored.
	 * @param string[] $aColumns
	 */
	protected function _getSearchConditions($aColumns) {
		$searchConditions = array('OR' => array());
		$keys = array_keys($aColumns);

		if ( $this->request->query('sSearch') != "" ) {
			for ( $i = 0; $i < count($aColumns); $i++ ) {
for ($i=0; $i<count($array); $i++) { // calls count() on each iteration
}

// Better
for ($i=0, $c=count($array); $i<$c; $i++) { // calls count() just once
}
				if ($this->request->query('bSearchable_' . ($i+1)) == "true") {
					$searchConditions['OR'][] = array($aColumns[$keys[$i]] . " LIKE" =>
							"%" . $this->request->query('sSearch') . "%");
				}
			}
		}

		/* Individual column filtering */
		for ( $i = 0; $i < count($aColumns); $i++ ) {
for ($i=0; $i<count($array); $i++) { // calls count() on each iteration
}

// Better
for ($i=0, $c=count($array); $i<$c; $i++) { // calls count() just once
}
			if ($this->request->query('sSearch_' . ($i+1)) != '') {
				$searchConditions[] = array($aColumns[$keys[$i]] . " LIKE" =>
						$this->request->query('sSearch_' . ($i+1)));
			}
		}
		return $searchConditions;
	}

	/**
	 * @param string[] $aColumns
	 */
	protected function _getOrder($aColumns) {
		if ( $this->request->query('iSortCol_0') != null ) {
			$order = [];
			//Seems like we need to sort with only one column each time, so no need to loop
			$sort_column_index = intval($this->request->query('iSortCol_0'));

			$keys = array_keys($aColumns);

			if ($sort_column_index > 0 && $this->request->query('bSortable_' . $sort_column_index) == "true") {
				$order[$aColumns[$keys[$sort_column_index - 1]]] = $this->request->query('sSortDir_0');
			}
			return $order;
		} else {
			return null;
		}
	}
    protected function _findArrayList($results, $key) {
        $output = array();
		foreach ($results as $row) {
			$output[] = $row[$key];
		}
		return $output;
    }
    protected function _findAllDataTable($results) {
		$output = array();
		foreach ($results as $row) {
			$output_row = array();
            $row = $row->toArray();
			foreach ($row as $key => $value) {
				$output_row[] = $value;
			}
			$output[] = $output_row;
		}
		return $output;
	}
}


1		<?php
2		/* vim: set noexpandtab sw=2 ts=2 sts=2: */
3		namespace App\Controller;
4
5		use App\Controller\AppController;
6		use App\Utility\Sanitize;
7		use Cake\Core\Configure;
8		use Cake\Log\Log;
9		use Cake\ORM\Table;
10		use Cake\ORM\TableRegistry;
11		use Cake\Network\Exception\NotFoundException;
12		/**
13		* Reports controller handling reports creation and rendering
14		*
15		* phpMyAdmin Error reporting server
16		* Copyright (c) phpMyAdmin project (http://www.phpmyadmin.net)
17		*
18		* Licensed under The MIT License
19		* For full copyright and license information, please see the LICENSE.txt
20		* Redistributions of files must retain the above copyright notice.
21		*
22		* @copyright Copyright (c) phpMyAdmin project (http://www.phpmyadmin.net)
23		* @package Server.Controller
24		* @link http://www.phpmyadmin.net
25		* @license http://www.opensource.org/licenses/mit-license.php MIT License
26		*/
27
28		/**
29		* Reports controller handling reports modification and rendering
30		*
31		* @package Server.Controller
32		*/
33		class ReportsController extends AppController {
34
35		public $components = array('RequestHandler');
36
37		public $helpers = array('Html', 'Form', 'Reports', 'Incidents');
38		public $uses = array('Incidents', 'Reports', 'Notifications', 'Developers');
39
40	1	public function index() {
41	1	$this->Reports->recursive = -1;
42	1	$this->set('distinct_statuses',
43	1	$this->_findArrayList($this->Reports->find()->select(['status'])->distinct(['status']),
44	1	'status')
45	1	);
46	1	$this->set('distinct_versions',
47	1	$this->_findArrayList($this->Reports->find()->select(['pma_version'])->distinct(['pma_version']), 'pma_version')
48	1	);
49	1	$this->set('distinct_error_names',
50	1	$this->_findArrayList($this->Reports->find('all', array(
51	1	'fields' => array('error_name'),
52	1	'conditions' => array('error_name !=' => ''),
53	1	))->distinct(['error_name']), 'error_name')
54	1	);
55	1	$this->set('statuses', $this->Reports->status);
56	1	$this->autoRender = true;
57	1	}
58
59	1	public function view($reportId) {
60	1	if (!$reportId) {
61		throw new NotFoundException(__('Invalid Report'));
62		}
63	1	$report = $this->Reports->findById($reportId)->toArray();
64	1	if (!$report) {
65	1	throw new NotFoundException(__('Invalid Report'));
66		}
67
68	1	$this->set('report', $report);
69	1	$this->set('project_name', Configure::read('GithubRepoPath'));
70	1	$this->Reports->id = $reportId;
71	1	$this->set('incidents', $this->Reports->getIncidents()->toArray());
72	1	$this->set('incidents_with_description',
73	1	$this->Reports->getIncidentsWithDescription());
74	1	$this->set('incidents_with_stacktrace',
75	1	$this->Reports->getIncidentsWithDifferentStacktrace());
76	1	$this->set('related_reports', $this->Reports->getRelatedReports());
77	1	$this->set('status', $this->Reports->status);
78	1	$this->_setSimilarFields($reportId);
79
80		// if there is an unread notification for this report, then mark it as read
81	1	$current_developer = TableRegistry::get('Developers')->
		0 ignored issues – show Documentation Bug introduced 2015-12-24 09:14 UTC by Report Bug Copy Issue Report The method `findById` does not exist on `object<Cake\ORM\Table>`? Since you implemented `__call`, maybe consider adding a @method annotation. If you implement `__call` and you know which methods are available, you can improve IDE auto-completion and static analysis by adding a @method annotation to the class. This is often the case, when `__call` is implemented by a parent class and only the child class knows which methods exist: class ParentClass { private $data = array(); public function __call($method, array $args) { if (0 === strpos($method, 'get')) { return $this->data[strtolower(substr($method, 3))]; } throw new \LogicException(sprintf('Unsupported method: %s', $method)); } } /** * If this class knows which fields exist, you can specify the methods here: * * @method string getName() */ class SomeClass extends ParentClass { } Loading history...
82	1	findById($this->request->session()->read('Developer.id'))->all()->first();
83		//$current_developer = Sanitize::clean($current_developer);
84	1	if ($current_developer) {
85	1	TableRegistry::get('Notifications')->deleteAll(
86	1	array('developer_id' => $current_developer['Developer']['id'],
87		'report_id' => $reportId
88	1	),
89		false
		0 ignored issues – show Unused Code introduced 2015-12-24 09:14 UTC by Report Bug Copy Issue Report The call to `Table::deleteAll()` has too many arguments starting with `false`. This check compares calls to functions or methods with their respective definitions. If the call has more arguments than are defined, it raises an issue. If a function is defined several times with a different number of parameters, the check may pick up the wrong definition and report false positives. One codebase where this has been known to happen is Wordpress. In this case you can add the `@ignore` PhpDoc annotation to the duplicate definition and it will be ignored. Loading history...
90	1	);
91	1	}
92	1	}
93
94	1	public function data_tables() {
95		$subquery_params = [
96		'fields' => [
97	1	'report_id' => 'report_id',
98		'inci_count' => 'COUNT(id)'
99	1	],
100		'group' => 'report_id'
101	1	];
102	1	$subquery = TableRegistry::get('incidents')->find('all', $subquery_params);
103
104		// override automatic aliasing, for proper usage in joins
105		$aColumns = [
106	1	'id' => 'id',
107	1	'error_name' => 'error_name',
108	1	'error_message' => 'error_message',
109	1	'pma_version' => 'pma_version',
110	1	'status' => 'status',
111	1	'exception_type' => 'exception_type',
112		'inci_count' => 'inci_count'
113	1	];
114
115	1	$searchConditions = $this->_getSearchConditions($aColumns);
116	1	$orderConditions = $this->_getOrder($aColumns);
117
118		$params = [
119	1	'fields' => $aColumns,
120		'conditions' => [
121	1	$searchConditions,
122		'related_to is NULL'
123	1	],
124	1	'order' => $orderConditions,
125	1	];
126
127	1	$pagedParams = $params;
128	1	$pagedParams['limit'] = intval($this->request->query('iDisplayLength'));
129	1	$pagedParams['offset'] = intval($this->request->query('iDisplayStart'));
130
131	1	$rows = $this->_findAllDataTable(
132	1	$this->Reports->find('all', $pagedParams)->innerJoin(
133	1	['incidents' => $subquery], ['incidents.report_id = Reports.id']
134	1	)
135	1	);
136		//$rows = Sanitize::clean($rows);
137	1	$totalFiltered = $this->Reports->find('all', $params)->count();
138
139		// change exception_type from boolean values to strings
140	1	$dispRows = array();
141	1	foreach($rows as $row) {
142	1	$row[4] = $this->Reports->status[$row[4]];
143	1	$row[5] = (intval($row[5]))?('php'):('js');
144		$input_elem = "<input type='checkbox' name='reports[]' value='"
145	1	. $row[0]
146	1	. "'/>";
147	1	array_unshift($row, $input_elem);
148	1	array_push($dispRows, $row);
149	1	}
150		$response = array(
151	1	'iTotalRecords' => $this->Reports->find('all')->count(),
152	1	'iTotalDisplayRecords' => $totalFiltered,
153	1	'sEcho' => intval($this->request->query('sEcho')),
154		'aaData' => $dispRows
155	1	);
156	1	$this->autoRender = false;
157	1	$this->response->body(json_encode($response));
158	1	return $this->response;
159		}
160
161		public function mark_related_to($reportId) {
162		$relatedTo = $this->request->query("related_to");
163		if (!$reportId
164		\|\| !$relatedTo
165		\|\| $reportId == $relatedTo
166		) {
167		throw new NotFoundException(__('Invalid Report'));
168		}
169
170		$report = $this->Reports->get($reportId);
171		if (!$report) {
172		throw new NotFoundException(__('Invalid Report'));
173		}
174
175		$this->Reports->addToRelatedGroup($report, $relatedTo);
176
177		$flash_class = "alert alert-success";
178		$this->Flash->default("This report has been marked the same as #"
		0 ignored issues – show Documentation Bug introduced 2016-01-20 19:39 UTC by Report Bug Copy Issue Report The method `default` does not exist on `object<Cake\Controller\Component\FlashComponent>`? Since you implemented `__call`, maybe consider adding a @method annotation. If you implement `__call` and you know which methods are available, you can improve IDE auto-completion and static analysis by adding a @method annotation to the class. This is often the case, when `__call` is implemented by a parent class and only the child class knows which methods exist: class ParentClass { private $data = array(); public function __call($method, array $args) { if (0 === strpos($method, 'get')) { return $this->data[strtolower(substr($method, 3))]; } throw new \LogicException(sprintf('Unsupported method: %s', $method)); } } /** * If this class knows which fields exist, you can specify the methods here: * * @method string getName() */ class SomeClass extends ParentClass { } Loading history...
179		. $relatedTo,
180		array("params" => array("class" => $flash_class)));
181		$this->redirect("/reports/view/$reportId");
182		}
183
184		public function unmark_related_to($reportId) {
185		if (!$reportId) {
186		throw new NotFoundException(__('Invalid Report'));
187		}
188
189		$report = $this->Reports->get($reportId);
190		if (!$report) {
191		throw new NotFoundException(__('Invalid Report'));
192		}
193
194		$this->Reports->removeFromRelatedGroup($report);
195
196		$flash_class = "alert alert-success";
197		$this->Flash->default("This report has been marked as different.",
		0 ignored issues – show Documentation Bug introduced 2016-01-20 19:39 UTC by Report Bug Copy Issue Report The method `default` does not exist on `object<Cake\Controller\Component\FlashComponent>`? Since you implemented `__call`, maybe consider adding a @method annotation. If you implement `__call` and you know which methods are available, you can improve IDE auto-completion and static analysis by adding a @method annotation to the class. This is often the case, when `__call` is implemented by a parent class and only the child class knows which methods exist: class ParentClass { private $data = array(); public function __call($method, array $args) { if (0 === strpos($method, 'get')) { return $this->data[strtolower(substr($method, 3))]; } throw new \LogicException(sprintf('Unsupported method: %s', $method)); } } /** * If this class knows which fields exist, you can specify the methods here: * * @method string getName() */ class SomeClass extends ParentClass { } Loading history...
198		array("params" => array("class" => $flash_class)));
199		$this->redirect("/reports/view/$reportId");
200		}
201
202		public function change_state($reportId) {
203		if (!$reportId) {
204		throw new NotFoundException(__('Invalid Report'));
205		}
206
207		$report = $this->Reports->get($reportId);
208		if (!$report) {
209		throw new NotFoundException(__('Invalid Report'));
210		}
211
212		$state = $this->request->data['state'];
213		$newState = $this->Reports->status[$state];
214		if (!$newState) {
215		throw new NotFoundException(__('Invalid State'));
216		}
217		$report->status = $state;
218		$this->Reports->save($report);
219
220		$flash_class = "alert alert-success";
221		$this->Flash->default("The state has been successfully changed.",
		0 ignored issues – show Documentation Bug introduced 2016-01-20 19:39 UTC by Report Bug Copy Issue Report The method `default` does not exist on `object<Cake\Controller\Component\FlashComponent>`? Since you implemented `__call`, maybe consider adding a @method annotation. If you implement `__call` and you know which methods are available, you can improve IDE auto-completion and static analysis by adding a @method annotation to the class. This is often the case, when `__call` is implemented by a parent class and only the child class knows which methods exist: class ParentClass { private $data = array(); public function __call($method, array $args) { if (0 === strpos($method, 'get')) { return $this->data[strtolower(substr($method, 3))]; } throw new \LogicException(sprintf('Unsupported method: %s', $method)); } } /** * If this class knows which fields exist, you can specify the methods here: * * @method string getName() */ class SomeClass extends ParentClass { } Loading history...
222		array("params" => array("class" => $flash_class)));
223		$this->redirect("/reports/view/$reportId");
224		}
225
226		/**
227		* To carry out mass actions on Reports
228		* Currently only to change their statuses.
229		* Can be Extended for other mass operations as well.
230		* Expects an array of Report Ids as a POST parameter.
231		*
232		*/
233		public function mass_action()
234		{
235		$flash_class = "alert alert-error";
236		$state = $this->request->data['state'];
237		$newState = $this->Reports->status[$state];
238		if (!$newState) {
239		Log::write(
240		'error',
241		'ERRORED: Invalid param "state" in ReportsController::mass_action()',
242		'alert'
243		);
244		$msg = "ERROR: Invalid State!!";
245		} else if (count($this->request->data['reports']) == 0) {
246		$msg = "No Reports Selected!! Please Select Reports and try again.";
247		} else {
248		$msg = "Status has been changed to '"
249		. $this->request->data['state']
250		. "' for selected Reports!";
251		$flash_class = "alert alert-success";
252		foreach($this->request->data['reports'] as $report_id)
253		{
254		$report = $this->Reports->get($report_id);
255		if (!$report) {
256		Log::write(
257		'error',
258		'ERRORED: Invalid report_id in ReportsController::mass_action()',
259		'alert'
260		);
261		$msg = "ERROR:Invalid Report ID:" . $report_id;
262		$flash_class = "alert alert-error";
263		break;
264		}
265		$report->status = $state;
266		$this->Reports->save($report);
267		}
268		}
269
270		$this->Flash->default($msg,
		0 ignored issues – show Documentation Bug introduced 2016-01-20 19:39 UTC by Report Bug Copy Issue Report The method `default` does not exist on `object<Cake\Controller\Component\FlashComponent>`? Since you implemented `__call`, maybe consider adding a @method annotation. If you implement `__call` and you know which methods are available, you can improve IDE auto-completion and static analysis by adding a @method annotation to the class. This is often the case, when `__call` is implemented by a parent class and only the child class knows which methods exist: class ParentClass { private $data = array(); public function __call($method, array $args) { if (0 === strpos($method, 'get')) { return $this->data[strtolower(substr($method, 3))]; } throw new \LogicException(sprintf('Unsupported method: %s', $method)); } } /** * If this class knows which fields exist, you can specify the methods here: * * @method string getName() */ class SomeClass extends ParentClass { } Loading history...
271		array("params" => array("class" => $flash_class)));
272		$this->redirect("/reports/");
273		}
274
275		## HELPERS
276	1	protected function _setSimilarFields($id) {
277	1	$this->Reports->id = $id;
278
279	1	$this->set('columns', TableRegistry::get('Incidents')->summarizableFields);
280	1	$relatedEntries = array();
281
282	1	foreach (TableRegistry::get('Incidents')->summarizableFields as $field) {
283		list($entriesWithCount, $totalEntries) =
284	1	$this->Reports->getRelatedByField($field, 25, true);
285	1	$relatedEntries[$field] = $entriesWithCount;
286	1	$this->set("${field}_distinct_count", $totalEntries);
287	1	}
288		//error_log(json_encode($relatedEntries));
289		$this->set("related_entries", $relatedEntries);
290		}
291
292		/**
293		* Indexes are +1'ed because first column is of checkboxes
294		* and hence it should be ingnored.
295		* @param string[] $aColumns
296		*/
297		protected function _getSearchConditions($aColumns) {
298	1	$searchConditions = array('OR' => array());
299	1	$keys = array_keys($aColumns);
300
301	1	if ( $this->request->query('sSearch') != "" ) {
302	1	for ( $i = 0; $i < count($aColumns); $i++ ) {
		0 ignored issues – show Performance Best Practice introduced 2016-01-20 19:39 UTC by Report Bug Copy Issue Report It seems like you are calling the size function `count()` as part of the test condition. You might want to compute the size beforehand, and not on each iteration. If the size of the collection does not change during the iteration, it is generally a good practice to compute it beforehand, and not on each iteration: for ($i=0; $i<count($array); $i++) { // calls count() on each iteration } // Better for ($i=0, $c=count($array); $i<$c; $i++) { // calls count() just once } Loading history...
303	1	if ($this->request->query('bSearchable_' . ($i+1)) == "true") {
304	1	$searchConditions['OR'][] = array($aColumns[$keys[$i]] . " LIKE" =>
305	1	"%" . $this->request->query('sSearch') . "%");
306	1	}
307	1	}
308	1	}
309
310		/* Individual column filtering */
311	1	for ( $i = 0; $i < count($aColumns); $i++ ) {
		0 ignored issues – show Performance Best Practice introduced 2016-01-20 19:39 UTC by Report Bug Copy Issue Report It seems like you are calling the size function `count()` as part of the test condition. You might want to compute the size beforehand, and not on each iteration. If the size of the collection does not change during the iteration, it is generally a good practice to compute it beforehand, and not on each iteration: for ($i=0; $i<count($array); $i++) { // calls count() on each iteration } // Better for ($i=0, $c=count($array); $i<$c; $i++) { // calls count() just once } Loading history...
312	1	if ($this->request->query('sSearch_' . ($i+1)) != '') {
313	1	$searchConditions[] = array($aColumns[$keys[$i]] . " LIKE" =>
314	1	$this->request->query('sSearch_' . ($i+1)));
315	1	}
316	1	}
317	1	return $searchConditions;
318		}
319
320		/**
321		* @param string[] $aColumns
322		*/
323		protected function _getOrder($aColumns) {
324	1	if ( $this->request->query('iSortCol_0') != null ) {
325	1	$order = [];
326		//Seems like we need to sort with only one column each time, so no need to loop
327	1	$sort_column_index = intval($this->request->query('iSortCol_0'));
328
329	1	$keys = array_keys($aColumns);
330
331	1	if ($sort_column_index > 0 && $this->request->query('bSortable_' . $sort_column_index) == "true") {
332		$order[$aColumns[$keys[$sort_column_index - 1]]] = $this->request->query('sSortDir_0');
333		}
334	1	return $order;
335		} else {
336	1	return null;
337		}
338		}
339		protected function _findArrayList($results, $key) {
340	1	$output = array();
341	1	foreach ($results as $row) {
342	1	$output[] = $row[$key];
343	1	}
344	1	return $output;
345		}
346		protected function _findAllDataTable($results) {
347	1	$output = array();
348	1	foreach ($results as $row) {
349	1	$output_row = array();
350	1	$row = $row->toArray();
351	1	foreach ($row as $key => $value) {
352	1	$output_row[] = $value;
353	1	}
354	1	$output[] = $output_row;
355	1	}
356	1	return $output;
357		}
358		}
359

phpmyadmin / error-reporting-server

Push — master ( b2e27a...34e86d )

ReportsController::_findAllDataTable() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like