ReportsController::_findAllDataTable() - Code Metrics - Inspection of "Update composer.json and .travis.yml" - phpmyadmin/error-reporting-server - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 667317...f33c3d )

by William

created 2019-07-01 23:01 UTC

ReportsController::_findAllDataTable() A

↳ Parent: ReportsController

Complexity

Conditions	3
Paths	3

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	8
CRAP Score	3

Importance

Changes

Metric	Value
dl	0
loc	14
ccs	8
cts	8
cp	1
rs	9.7998
c	0
b	0
f	0
cc	3
nc	3
nop	1
crap	3

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */

/**
 * Reports controller handling reports creation and rendering.
 *
 * phpMyAdmin Error reporting server
 * Copyright (c) phpMyAdmin project (https://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 (https://www.phpmyadmin.net/)
 * @license   https://opensource.org/licenses/mit-license.php MIT License
 *
 * @see      https://www.phpmyadmin.net/
 */

namespace App\Controller;

use App\Utility\Sanitize;
use Cake\Core\Configure;
use Cake\Log\Log;
use Cake\Http\Exception\NotFoundException;
use Cake\ORM\TableRegistry;

/**
 * Reports controller handling reports modification and rendering.
 */
class ReportsController extends AppController
{
    public $components = [
        'RequestHandler',
        'OrderSearch',
    ];

    public $helpers = [
        'Html',
        'Form',
        'Reports',
        'Incidents',
    ];
    public $uses = [
        '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_locations',
            $this->_findArrayList(
                $this->Reports->find()->select(['location'])
                    ->distinct(['location']),
                'location'
            )
        );
        $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', [
                'fields' => ['error_name'],
                'conditions' => ['error_name !=' => ''],
            ])->distinct(['error_name']), 'error_name')
        );
        $this->set('statuses', $this->Reports->status);
        $this->autoRender = true;
    }

    public function view($reportId)
    {
        if (! isset($reportId) || ! $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')->

                    findById($this->request->session()->read('Developer.id'))->all()->first();


        if ($current_developer) {
            TableRegistry::get('Notifications')->deleteAll(

                [
                    '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',
            'location' => 'location',
            'pma_version' => 'pma_version',
            'status' => 'status',
            'exception_type' => 'exception_type',
            'inci_count' => 'inci_count',
        ];

        $searchConditions = $this->OrderSearch->getSearchConditions($aColumns);
        $orderConditions = $this->OrderSearch->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
        // add incident count for related reports
        $dispRows = [];
        foreach ($rows as $row) {
            $row[5] = $this->Reports->status[$row[5]];
            $row[6] = (intval($row[6])) ? ('php') : ('js');
            $input_elem = "<input type='checkbox' name='reports[]' value='"
                . $row[0]
                . "'/>";

            $subquery_params_count = [
                'fields' => [
                    'report_id' => 'report_id',
                ],
            ];
            $subquery_count = TableRegistry::get('incidents')->find(

                'all',
                $subquery_params_count
            );

            $params_count = [
                'fields' => ['inci_count' => 'inci_count'],
                'conditions' => [
                    'related_to = ' . $row[0],
                ],
            ];

            $inci_count_related = $this->Reports->find('all', $params_count)->innerJoin(
                ['incidents' => $subquery_count],
                ['incidents.report_id = Reports.related_to']
            )->count();

            $row[7] += $inci_count_related;

            array_unshift($row, $input_elem);
            array_push($dispRows, $row);
        }

        $response = [
            '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)
    {
        // Only allow POST requests
        $this->request->allowMethod(['post']);

        $relatedTo = $this->request->getData('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 #'
                . $relatedTo,
            ['params' => ['class' => $flash_class]]
        );
        $this->redirect("/reports/view/$reportId");
    }

    public function unmark_related_to($reportId)
    {
        // Only allow POST requests
        $this->request->allowMethod(['post']);

        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.',
            ['params' => ['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 = null;

        if (array_key_exists($state, $this->Reports->status)) {
            $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.',
            ['params' => ['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.
     * @return void
     */
    public function mass_action()
    {
        $flash_class = 'alert alert-error';
        $state = $this->request->data['state'];

        $newState = null;
        if (array_key_exists($state, $this->Reports->status)) {
            $newState = $this->Reports->status[$state];
        }

        if (! $newState) {
            Log::write(
                'error',
                'ERRORED: Invalid param "state" in ReportsController::mass_action()',
                'alert'
            );
            $msg = 'ERROR: Invalid State!!';
        } elseif (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,
            ['params' => ['class' => $flash_class]]
        );
        $this->redirect('/reports/');
    }

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

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

        $relatedEntries = [];

        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);
    }

    protected function _findArrayList($results, $key)
    {
        $output = [];
        foreach ($results as $row) {
            $output[] = $row[$key];
        }

        return $output;
    }

    protected function _findAllDataTable($results)
    {
        $output = [];
        foreach ($results as $row) {
            $output_row = [];
            $row = $row->toArray();
            foreach ($row as $key => $value) {
                $output_row[] = $value;
            }
            $output[] = $output_row;
        }

        return $output;
    }
}


1			<?php
2			/* vim: set expandtab sw=4 ts=4 sts=4: */
3
4			/**
5			* Reports controller handling reports creation and rendering.
6			*
7			* phpMyAdmin Error reporting server
8			* Copyright (c) phpMyAdmin project (https://www.phpmyadmin.net/)
9			*
10			* Licensed under The MIT License
11			* For full copyright and license information, please see the LICENSE.txt
12			* Redistributions of files must retain the above copyright notice.
13			*
14			* @copyright Copyright (c) phpMyAdmin project (https://www.phpmyadmin.net/)
15			* @license https://opensource.org/licenses/mit-license.php MIT License
16			*
17			* @see https://www.phpmyadmin.net/
18			*/
19
20			namespace App\Controller;
21
22			use App\Utility\Sanitize;
23			use Cake\Core\Configure;
24			use Cake\Log\Log;
25			use Cake\Http\Exception\NotFoundException;
26			use Cake\ORM\TableRegistry;
27
28			/**
29			* Reports controller handling reports modification and rendering.
30			*/
31			class ReportsController extends AppController
32			{
33			public $components = [
34			'RequestHandler',
35			'OrderSearch',
36			];
37
38			public $helpers = [
39			'Html',
40			'Form',
41			'Reports',
42			'Incidents',
43			];
44			public $uses = [
45			'Incidents',
46			'Reports',
47			'Notifications',
48			'Developers',
49			];
50
51	1		public function index()
52			{
53	1		$this->Reports->recursive = -1;
54	1		$this->set(
55	1		'distinct_statuses',
56	1		$this->_findArrayList(
57	1		$this->Reports->find()->select(['status'])->distinct(['status']),
58	1		'status'
59			)
60			);
61	1		$this->set(
62	1		'distinct_locations',
63	1		$this->_findArrayList(
64	1		$this->Reports->find()->select(['location'])
65	1		->distinct(['location']),
66	1		'location'
67			)
68			);
69	1		$this->set(
70	1		'distinct_versions',
71	1		$this->_findArrayList($this->Reports->find()->select(['pma_version'])->distinct(['pma_version']), 'pma_version')
72			);
73	1		$this->set(
74	1		'distinct_error_names',
75	1		$this->_findArrayList($this->Reports->find('all', [
76	1		'fields' => ['error_name'],
77			'conditions' => ['error_name !=' => ''],
78	1		])->distinct(['error_name']), 'error_name')
79			);
80	1		$this->set('statuses', $this->Reports->status);
81	1		$this->autoRender = true;
82	1		}
83
84	1		public function view($reportId)
85			{
86	1		if (! isset($reportId) \|\| ! $reportId) {
87			throw new NotFoundException(__('Invalid Report'));
88			}
89	1		$report = $this->Reports->findById($reportId)->toArray();
90	1		if (! $report) {
91	1		throw new NotFoundException(__('Invalid Report'));
92			}
93
94	1		$this->set('report', $report);
95	1		$this->set('project_name', Configure::read('GithubRepoPath'));
96	1		$this->Reports->id = $reportId;
97	1		$this->set('incidents', $this->Reports->getIncidents()->toArray());
98	1		$this->set(
99	1		'incidents_with_description',
100	1		$this->Reports->getIncidentsWithDescription()
101			);
102	1		$this->set(
103	1		'incidents_with_stacktrace',
104	1		$this->Reports->getIncidentsWithDifferentStacktrace()
105			);
106	1		$this->set('related_reports', $this->Reports->getRelatedReports());
107	1		$this->set('status', $this->Reports->status);
108	1		$this->_setSimilarFields($reportId);
109
110			// if there is an unread notification for this report, then mark it as read
111	1		$current_developer = TableRegistry::get('Developers')->
			0 ignored issues – show Deprecated Code introduced 2018-04-18 14:37 UTC by Report Bug Copy Issue Report The method `Cake\ORM\TableRegistry::get()` has been deprecated with message: 3.6.0 Use \Cake\ORM\Locator\TableLocator::get() instead. This method has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the method will be removed from the class and what other method or class to use instead. Loading history...
112	1		findById($this->request->session()->read('Developer.id'))->all()->first();
			0 ignored issues – show Deprecated Code introduced 2018-12-05 19:45 UTC by Report Bug Copy Issue Report The method `Cake\Http\ServerRequest::session()` has been deprecated with message: 3.5.0 Use getSession() instead. The setter part will be removed. This method has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the method will be removed from the class and what other method or class to use instead. Loading history...
113
114	1		if ($current_developer) {
115	1		TableRegistry::get('Notifications')->deleteAll(
			0 ignored issues – show Deprecated Code introduced 2018-04-18 14:37 UTC by Report Bug Copy Issue Report The method `Cake\ORM\TableRegistry::get()` has been deprecated with message: 3.6.0 Use \Cake\ORM\Locator\TableLocator::get() instead. This method has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the method will be removed from the class and what other method or class to use instead. Loading history...
116			[
117	1		'developer_id' => $current_developer['Developer']['id'],
118	1		'report_id' => $reportId,
119			],
120	1		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...
121			);
122			}
123	1		}
124
125	1		public function data_tables()
126			{
127			$subquery_params = [
128			'fields' => [
129	1		'report_id' => 'report_id',
130			'inci_count' => 'COUNT(id)',
131			],
132			'group' => 'report_id',
133			];
134	1		$subquery = TableRegistry::get('incidents')->find('all', $subquery_params);
			0 ignored issues – show Deprecated Code introduced 2018-04-18 14:37 UTC by Report Bug Copy Issue Report The method `Cake\ORM\TableRegistry::get()` has been deprecated with message: 3.6.0 Use \Cake\ORM\Locator\TableLocator::get() instead. This method has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the method will be removed from the class and what other method or class to use instead. Loading history...
135
136			// override automatic aliasing, for proper usage in joins
137			$aColumns = [
138	1		'id' => 'id',
139			'error_name' => 'error_name',
140			'error_message' => 'error_message',
141			'location' => 'location',
142			'pma_version' => 'pma_version',
143			'status' => 'status',
144			'exception_type' => 'exception_type',
145			'inci_count' => 'inci_count',
146			];
147
148	1		$searchConditions = $this->OrderSearch->getSearchConditions($aColumns);
149	1		$orderConditions = $this->OrderSearch->getOrder($aColumns);
150
151			$params = [
152	1		'fields' => $aColumns,
153			'conditions' => [
154	1		$searchConditions,
155	1		'related_to is NULL',
156			],
157	1		'order' => $orderConditions,
158			];
159
160	1		$pagedParams = $params;
161	1		$pagedParams['limit'] = intval($this->request->query('iDisplayLength'));
			0 ignored issues – show Deprecated Code introduced 2017-03-12 05:11 UTC by Report Bug Copy Issue Report The method `Cake\Http\ServerRequest::query()` has been deprecated with message: 3.4.0 Use getQuery() or the PSR-7 getQueryParams() and withQueryParams() methods instead. This method has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the method will be removed from the class and what other method or class to use instead. Loading history...
162	1		$pagedParams['offset'] = intval($this->request->query('iDisplayStart'));
			0 ignored issues – show Deprecated Code introduced 2017-03-12 05:11 UTC by Report Bug Copy Issue Report The method `Cake\Http\ServerRequest::query()` has been deprecated with message: 3.4.0 Use getQuery() or the PSR-7 getQueryParams() and withQueryParams() methods instead. This method has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the method will be removed from the class and what other method or class to use instead. Loading history...
163
164	1		$rows = $this->_findAllDataTable(
165	1		$this->Reports->find('all', $pagedParams)->innerJoin(
166	1		['incidents' => $subquery],
167	1		['incidents.report_id = Reports.id']
168			)
169			);
170			//$rows = Sanitize::clean($rows);
171	1		$totalFiltered = $this->Reports->find('all', $params)->count();
172
173			// change exception_type from boolean values to strings
174			// add incident count for related reports
175	1		$dispRows = [];
176	1		foreach ($rows as $row) {
177	1		$row[5] = $this->Reports->status[$row[5]];
178	1		$row[6] = (intval($row[6])) ? ('php') : ('js');
179			$input_elem = "<input type='checkbox' name='reports[]' value='"
180	1		. $row[0]
181	1		. "'/>";
182
183			$subquery_params_count = [
184			'fields' => [
185	1		'report_id' => 'report_id',
186			],
187			];
188	1		$subquery_count = TableRegistry::get('incidents')->find(
			0 ignored issues – show Deprecated Code introduced 2018-04-18 14:37 UTC by Report Bug Copy Issue Report The method `Cake\ORM\TableRegistry::get()` has been deprecated with message: 3.6.0 Use \Cake\ORM\Locator\TableLocator::get() instead. This method has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the method will be removed from the class and what other method or class to use instead. Loading history...
189	1		'all',
190			$subquery_params_count
191			);
192
193			$params_count = [
194	1		'fields' => ['inci_count' => 'inci_count'],
195			'conditions' => [
196	1		'related_to = ' . $row[0],
197			],
198			];
199
200	1		$inci_count_related = $this->Reports->find('all', $params_count)->innerJoin(
201	1		['incidents' => $subquery_count],
202	1		['incidents.report_id = Reports.related_to']
203	1		)->count();
204
205	1		$row[7] += $inci_count_related;
206
207	1		array_unshift($row, $input_elem);
208	1		array_push($dispRows, $row);
209			}
210
211			$response = [
212	1		'iTotalRecords' => $this->Reports->find('all')->count(),
213	1		'iTotalDisplayRecords' => $totalFiltered,
214	1		'sEcho' => intval($this->request->query('sEcho')),
			0 ignored issues – show Deprecated Code introduced 2017-03-12 05:11 UTC by Report Bug Copy Issue Report The method `Cake\Http\ServerRequest::query()` has been deprecated with message: 3.4.0 Use getQuery() or the PSR-7 getQueryParams() and withQueryParams() methods instead. This method has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the method will be removed from the class and what other method or class to use instead. Loading history...
215	1		'aaData' => $dispRows
216			];
217	1		$this->autoRender = false;
218	1		$this->response->body(json_encode($response));
			0 ignored issues – show Deprecated Code introduced 2018-12-05 19:45 UTC by Report Bug Copy Issue Report The method `Cake\Http\Response::body()` has been deprecated with message: 3.4.0 Mutable response methods are deprecated. Use `withBody()`/`withStringBody()` and `getBody()` instead. This method has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the method will be removed from the class and what other method or class to use instead. Loading history...
219
220	1		return $this->response;
221			}
222
223	1		public function mark_related_to($reportId)
224			{
225			// Only allow POST requests
226	1		$this->request->allowMethod(['post']);
227
228	1		$relatedTo = $this->request->getData('related_to');
229	1		if (! $reportId
230	1		\|\| ! $relatedTo
231	1		\|\| $reportId == $relatedTo
232			) {
233			throw new NotFoundException(__('Invalid Report'));
234			}
235
236	1		$report = $this->Reports->get($reportId);
237	1		if (! $report) {
238			throw new NotFoundException(__('Invalid Report'));
239			}
240
241	1		$this->Reports->addToRelatedGroup($report, $relatedTo);
242
243	1		$flash_class = 'alert alert-success';
244	1		$this->Flash->default(
245			'This report has been marked the same as #'
246	1		. $relatedTo,
247	1		['params' => ['class' => $flash_class]]
248			);
249	1		$this->redirect("/reports/view/$reportId");
250	1		}
251
252	1		public function unmark_related_to($reportId)
253			{
254			// Only allow POST requests
255	1		$this->request->allowMethod(['post']);
256
257	1		if (! $reportId) {
258			throw new NotFoundException(__('Invalid Report'));
259			}
260
261	1		$report = $this->Reports->get($reportId);
262	1		if (! $report) {
263			throw new NotFoundException(__('Invalid Report'));
264			}
265
266	1		$this->Reports->removeFromRelatedGroup($report);
267
268	1		$flash_class = 'alert alert-success';
269	1		$this->Flash->default(
270	1		'This report has been marked as different.',
271	1		['params' => ['class' => $flash_class]]
272			);
273	1		$this->redirect("/reports/view/$reportId");
274	1		}
275
276	1		public function change_state($reportId)
277			{
278	1		if (! $reportId) {
279			throw new NotFoundException(__('Invalid Report'));
280			}
281
282	1		$report = $this->Reports->get($reportId);
283	1		if (! $report) {
284			throw new NotFoundException(__('Invalid Report'));
285			}
286
287	1		$state = $this->request->data['state'];
			0 ignored issues – show Deprecated Code introduced 2017-02-22 10:31 UTC by Report Bug Copy Issue Report The property `Cake\Http\ServerRequest::$data` has been deprecated with message: 3.4.0 This public property will be removed in 4.0.0. Use getData() instead. This property has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the property will be removed from the class and what other property to use instead. Loading history...
288	1		$newState = null;
289
290	1		if (array_key_exists($state, $this->Reports->status)) {
291	1		$newState = $this->Reports->status[$state];
292			}
293	1		if (! $newState) {
294	1		throw new NotFoundException(__('Invalid State'));
295			}
296	1		$report->status = $state;
297	1		$this->Reports->save($report);
298
299	1		$flash_class = 'alert alert-success';
300	1		$this->Flash->default(
301	1		'The state has been successfully changed.',
302	1		['params' => ['class' => $flash_class]]
303			);
304	1		$this->redirect("/reports/view/$reportId");
305	1		}
306
307			/**
308			* To carry out mass actions on Reports
309			* Currently only to change their statuses.
310			* Can be Extended for other mass operations as well.
311			* Expects an array of Report Ids as a POST parameter.
312			* @return void
313			*/
314	1		public function mass_action()
315			{
316	1		$flash_class = 'alert alert-error';
317	1		$state = $this->request->data['state'];
			0 ignored issues – show Deprecated Code introduced 2017-02-22 10:31 UTC by Report Bug Copy Issue Report The property `Cake\Http\ServerRequest::$data` has been deprecated with message: 3.4.0 This public property will be removed in 4.0.0. Use getData() instead. This property has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the property will be removed from the class and what other property to use instead. Loading history...
318	1		$newState = null;
319	1		if (array_key_exists($state, $this->Reports->status)) {
320	1		$newState = $this->Reports->status[$state];
321			}
322
323	1		if (! $newState) {
324	1		Log::write(
325	1		'error',
326	1		'ERRORED: Invalid param "state" in ReportsController::mass_action()',
327	1		'alert'
328			);
329	1		$msg = 'ERROR: Invalid State!!';
330	1		} elseif (count($this->request->data['reports']) == 0) {
			0 ignored issues – show Deprecated Code introduced 2017-02-22 10:31 UTC by Report Bug Copy Issue Report The property `Cake\Http\ServerRequest::$data` has been deprecated with message: 3.4.0 This public property will be removed in 4.0.0. Use getData() instead. This property has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the property will be removed from the class and what other property to use instead. Loading history...
331	1		$msg = 'No Reports Selected!! Please Select Reports and try again.';
332			} else {
333			$msg = "Status has been changed to '"
334	1		. $this->request->data['state']
			0 ignored issues – show Deprecated Code introduced 2017-02-22 10:31 UTC by Report Bug Copy Issue Report The property `Cake\Http\ServerRequest::$data` has been deprecated with message: 3.4.0 This public property will be removed in 4.0.0. Use getData() instead. This property has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the property will be removed from the class and what other property to use instead. Loading history...
335	1		. "' for selected Reports!";
336	1		$flash_class = 'alert alert-success';
337	1		foreach ($this->request->data['reports'] as $report_id) {
			0 ignored issues – show Deprecated Code introduced 2017-02-22 10:31 UTC by Report Bug Copy Issue Report The property `Cake\Http\ServerRequest::$data` has been deprecated with message: 3.4.0 This public property will be removed in 4.0.0. Use getData() instead. This property has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the property will be removed from the class and what other property to use instead. Loading history...
338	1		$report = $this->Reports->get($report_id);
339	1		if (! $report) {
340			Log::write(
341			'error',
342			'ERRORED: Invalid report_id in ReportsController::mass_action()',
343			'alert'
344			);
345			$msg = 'ERROR:Invalid Report ID:' . $report_id;
346			$flash_class = 'alert alert-error';
347			break;
348			}
349	1		$report->status = $state;
350	1		$this->Reports->save($report);
351			}
352			}
353
354	1		$this->Flash->default(
355	1		$msg,
356	1		['params' => ['class' => $flash_class]]
357			);
358	1		$this->redirect('/reports/');
359	1		}
360
361	1		protected function _setSimilarFields($id)
362			{
363	1		$this->Reports->id = $id;
364
365	1		$this->set('columns', TableRegistry::get('Incidents')->summarizableFields);
			0 ignored issues – show Deprecated Code introduced 2018-04-18 14:37 UTC by Report Bug Copy Issue Report The method `Cake\ORM\TableRegistry::get()` has been deprecated with message: 3.6.0 Use \Cake\ORM\Locator\TableLocator::get() instead. This method has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the method will be removed from the class and what other method or class to use instead. Loading history...
366	1		$relatedEntries = [];
367
368	1	View Code Duplication	foreach (TableRegistry::get('Incidents')->summarizableFields as $field) {
			0 ignored issues – show Deprecated Code introduced 2018-04-18 14:37 UTC by Report Bug Copy Issue Report The method `Cake\ORM\TableRegistry::get()` has been deprecated with message: 3.6.0 Use \Cake\ORM\Locator\TableLocator::get() instead. This method has been deprecated. The supplier of the class has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the method will be removed from the class and what other method or class to use instead. Loading history...
369			list($entriesWithCount, $totalEntries) =
370	1		$this->Reports->getRelatedByField($field, 25, true);
371	1		$relatedEntries[$field] = $entriesWithCount;
372	1		$this->set("${field}_distinct_count", $totalEntries);
373			}
374			//error_log(json_encode($relatedEntries));
375			$this->set('related_entries', $relatedEntries);
376			}
377
378			protected function _findArrayList($results, $key)
379			{
380	1		$output = [];
381	1		foreach ($results as $row) {
382	1		$output[] = $row[$key];
383			}
384
385	1		return $output;
386			}
387
388			protected function _findAllDataTable($results)
389			{
390	1		$output = [];
391	1		foreach ($results as $row) {
392	1		$output_row = [];
393	1		$row = $row->toArray();
394	1		foreach ($row as $key => $value) {
395	1		$output_row[] = $value;
396			}
397	1		$output[] = $output_row;
398			}
399
400	1		return $output;
401			}
402			}
403

phpmyadmin / error-reporting-server

Push — master ( 667317...f33c3d )

ReportsController::_findAllDataTable() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like