← All changes | includes/Core/Database/ReportsModel.php +77 -41 1.3 → 2.21.4 View file →

		@@ -1,11 +1,13 @@
1	1	<?php
	2	+
2	3	/**
3	4	* Provides Report Model Class
4	5	*/
	6	+
5	7	namespace BitCode\BitForm\Core\Database;
6	8
7		-use BitCode\BitForm\Core\Database\Model;
	9	+use WP_Error;
8	10
9	11	/**
10	12	*
11	13	*/
		@@ -10,50 +12,84 @@
10	12	*
11	13	*/
12	14	class ReportsModel extends Model
13	15	{
14		- protected static $table = 'bitforms_reports';
	16	+ protected static $table = 'bitforms_reports';
15	17
16		- public function validateReportFields($reportData, $fieldNames)
17		- {
18		- $reportDetails = [];
19		- switch ($reportData->type) {
20		- case 'table':
21		- $tableAction = "table_ac";
22		- $reportDetails = !is_string($reportData->details)? $reportData->details : json_decode($reportData->details);
23		- if (!empty($reportDetails->order)) {
24		- $initialOrder = $fieldNames;
25		- $columnOrder = $reportDetails->order;
26		- foreach ($reportDetails->order as $key => $value) {
27		- if (isset($initialOrder[$value])) {
28		- unset($initialOrder[$value]);
29		- } elseif (!isset($initialOrder[$value])) {
30		- unset($columnOrder[$key]);
31		- }
32		- }
33		- $columnOrder = array_values($columnOrder);
34		- if (!empty($initialOrder)) {
35		- foreach ($initialOrder as $name => $label) {
36		- $columnOrder[] = $name;
37		- }
38		- }
39		- $columnOrder[] = $tableAction;
40		- array_unshift($columnOrder, 'selection', 'sl');
41		- $reportDetails->order = $columnOrder;
	18	+ public function validateReportFields($reportData, $fieldNames)
	19	+ {
	20	+ $reportDetails = [];
	21	+ switch ($reportData->type) {
	22	+ case 'table':
	23	+ $tableAction = 'table_ac';
	24	+ $reportDetails = !is_string($reportData->details) ? $reportData->details : json_decode($reportData->details);
	25	+ if (!empty($reportDetails->order)) {
	26	+ $initialOrder = $fieldNames;
	27	+ $columnOrder = $reportDetails->order;
	28	+ foreach ($reportDetails->order as $key => $value) {
	29	+ if (isset($initialOrder[$value])) {
	30	+ unset($initialOrder[$value]);
	31	+ } elseif (!isset($initialOrder[$value])) {
	32	+ unset($columnOrder[$key]);
42	33	}
43		- if (!empty($reportDetails->hiddenColumns)) {
44		- $hiddenColumns = $reportDetails->hiddenColumns;
45		- foreach ($reportDetails->hiddenColumns as $key => $value) {
46		- if (!isset($fieldNames[$value]) && ($value !== 'sl' && $value !== 'selection' && $value !== 'table_ac')) {
47		- unset($hiddenColumns[$key]);
48		- }
49		- }
50		- $reportDetails->hiddenColumns = array_values($hiddenColumns);
	34	+ }
	35	+ $columnOrder = array_values($columnOrder);
	36	+ if (!empty($initialOrder)) {
	37	+ foreach ($initialOrder as $name => $label) {
	38	+ $columnOrder[] = $name;
51	39	}
52		- break;
53		-
54		- default:
55		- break;
	40	+ }
	41	+ $columnOrder[] = $tableAction;
	42	+ array_unshift($columnOrder, 'selection', 'sl');
	43	+ $reportDetails->order = $columnOrder;
56	44	}
57		- return $reportDetails;
	45	+ if (!empty($reportDetails->hiddenColumns)) {
	46	+ $hiddenColumns = $reportDetails->hiddenColumns;
	47	+ foreach ($reportDetails->hiddenColumns as $key => $value) {
	48	+ if (!isset($fieldNames[$value]) && ('sl' !== $value && 'selection' !== $value && 'table_ac' !== $value)) {
	49	+ unset($hiddenColumns[$key]);
	50	+ }
	51	+ }
	52	+ $reportDetails->hiddenColumns = array_values($hiddenColumns);
	53	+ }
	54	+ break;
	55	+
	56	+ default:
	57	+ break;
58	58	}
	59	+ return $reportDetails;
	60	+ }
	61	+
	62	+ public function bulkDelete(array $condition = null, $check_operator = null)
	63	+ {
	64	+ if (
	65	+ !\is_null($condition)
	66	+ && \is_array($condition)
	67	+ && array_keys($condition) !== range(0, count($condition) - 1)
	68	+ ) {
	69	+ $delete_condition = $condition;
	70	+ } else {
	71	+ return new WP_Error(
	72	+ 'deletion_error',
	73	+ __('At least 1 condition needed', 'bit-form')
	74	+ );
	75	+ }
	76	+ $formatted_conditions = $this->getFormatedCondition($delete_condition, $check_operator);
	77	+ if ($formatted_conditions) {
	78	+ $condition_to_check = $formatted_conditions['conditions'];
	79	+ $all_values = $formatted_conditions['values'];
	80	+ } else {
	81	+ $condition_to_check = null;
	82	+ return new WP_Error(
	83	+ 'deletion_error',
	84	+ __('At least 1 condition needed', 'bit-form')
	85	+ );
	86	+ }
	87	+ $result = $this->app_db->query(
	88	+ $this->app_db->prepare(
	89	+ "DELETE FROM $this->table_name $condition_to_check",
	90	+ $all_values
	91	+ )
	92	+ );
	93	+ return $this->getResult($result);
	94	+ }
59	95	}