← All changes | includes/Core/Database/ReportsModel.php +74 -72 1.9 → 2.21.4 View file →

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