← All changes | includes/Core/Database/FormEntryMetaModel.php +482 -434 1.9 → 2.16.2 View file →

		@@ -9,507 +9,555 @@
9	9	/**
10	10	* Undocumented class
11	11	*/
12	12
13		-use BitCode\BitForm\Core\Database\Helper;
14		-use BitCode\BitForm\Core\Database\Model;
	13	+class FormEntryMetaModel extends Model
	14	+{
	15	+ protected static $table = 'bitforms_form_entrymeta';
15	16
16		-class FormEntryMetaModel extends Model {
17		- protected static $table = 'bitforms_form_entrymeta';
	17	+ public function duplicateEntryMeta($data)
	18	+ {
	19	+ $values[] = $data['duplicateID'];
	20	+ $values[] = $data['entryID'];
	21	+ $sql = "INSERT INTO $this->table_name (bitforms_form_entry_id,meta_key,meta_value)"
	22	+ . ' SELECT %d as bitforms_form_entry_id,meta_key,meta_value'
	23	+ . " FROM `$this->table_name` WHERE bitforms_form_entry_id = %d";
	24	+ return $this->execute($sql, $values)->getResult();
	25	+ }
18	26
19		- public function duplicateEntryMeta($data) {
20		- $values[] = $data['duplicateID'];
21		- $values[] = $data['entryID'];
22		- $sql = "INSERT INTO $this->table_name (bitforms_form_entry_id,meta_key,meta_value)"
23		- . " SELECT %d as bitforms_form_entry_id,meta_key,meta_value"
24		- . " FROM `$this->table_name` WHERE bitforms_form_entry_id = %d";
25		- return $this->execute($sql, $values)->getResult();
	27	+ public function update(array $data, array $condition)
	28	+ {
	29	+ $entryID = $condition['bitforms_form_entry_id'];
	30	+ if (empty($entryID)) {
	31	+ return false;
26	32	}
27		-
28		- public function update(array $data, array $condition) {
29		- $entryID = $condition['bitforms_form_entry_id'];
30		- if (empty($entryID)) {
31		- return false;
32		- }
33		- $formEntryMeta = $this->get(
34		- array(
35		- 'meta_key',
36		- 'meta_value',
37		- ),
38		- array(
39		- 'bitforms_form_entry_id' => $entryID,
40		- )
	33	+ $formEntryMeta = $this->get(
	34	+ [
	35	+ 'meta_key',
	36	+ 'meta_value',
	37	+ ],
	38	+ [
	39	+ 'bitforms_form_entry_id' => $entryID,
	40	+ ]
	41	+ );
	42	+ $oldEntries = [];
	43	+ foreach ($formEntryMeta as $oldKey => $oldValue) {
	44	+ $oldEntries[$oldValue->meta_key] = $oldValue->meta_value;
	45	+ }
	46	+ $updatedData = [];
	47	+ $oldEntriesKey = array_keys($oldEntries);
	48	+ foreach ($data as $upKey => $upValue) {
	49	+ $updatedData[$upKey] = is_string($upValue) ?
	50	+ $upValue :
	51	+ wp_json_encode($upValue);
	52	+ if (!\in_array($upKey, $oldEntriesKey)) {
	53	+ $this->insert(
	54	+ [
	55	+ 'bitforms_form_entry_id' => $entryID,
	56	+ 'meta_key' => $upKey,
	57	+ 'meta_value' => $updatedData[$upKey],
	58	+ ]
41	59	);
42		- $oldEntries = array();
43		- foreach ($formEntryMeta as $oldKey => $oldValue) {
44		- $oldEntries[$oldValue->meta_key] = $oldValue->meta_value;
45		- }
46		- $updatedData = array();
47		- $oldEntriesKey = array_keys($oldEntries);
48		- foreach ($data as $upKey => $upValue) {
49		- $updatedData[$upKey] = is_string($upValue) ?
50		- $upValue :
51		- wp_json_encode($upValue);
52		- if (!\in_array($upKey, $oldEntriesKey)) {
53		- $this->insert(
54		- array(
55		- 'bitforms_form_entry_id' => $entryID,
56		- 'meta_key' => $upKey,
57		- 'meta_value' => $updatedData[$upKey],
58		- )
59		- );
60		- unset($data[$upKey]);
61		- }
62		- }
63		- if (empty($data)) {
64		- return $updatedData;
65		- }
66		- $checkCondition = $this->checkCondition($condition);
67		- if (is_wp_error($checkCondition)) {
68		- return $checkCondition;
69		- }
70		- $case_part = ' ';
71		- $all_values = array();
72		- $condition['meta_key'] = array_keys($data);
73		- foreach ($data as $key => $value) {
74		- $value = is_string($value) ? $value : wp_json_encode($value);
75		- $case_part .= "
	60	+ unset($data[$upKey]);
	61	+ }
	62	+ }
	63	+ if (empty($data)) {
	64	+ return $updatedData;
	65	+ }
	66	+ $checkCondition = $this->checkCondition($condition);
	67	+ if (is_wp_error($checkCondition)) {
	68	+ return $checkCondition;
	69	+ }
	70	+ $case_part = ' ';
	71	+ $all_values = [];
	72	+ $condition['meta_key'] = array_keys($data);
	73	+ foreach ($data as $key => $value) {
	74	+ $value = is_string($value) ? $value : wp_json_encode($value);
	75	+ $case_part .= "
76	76	WHEN '$key' THEN " . $this->getFieldFormat($value);
77		- $all_values[] = $value;
78		- }
79		- $formattedCondition = $this->getFormatedCondition($condition);
80		- if ($formattedCondition) {
81		- $condition_to_check = $formattedCondition['conditions'];
82		- $all_values = array_merge($all_values, $formattedCondition['values']);
83		- } else {
84		- $condition_to_check = null;
85		- }
	77	+ $all_values[] = $value;
	78	+ }
	79	+ $formattedCondition = $this->getFormatedCondition($condition);
	80	+ if ($formattedCondition) {
	81	+ $condition_to_check = $formattedCondition['conditions'];
	82	+ $all_values = array_merge($all_values, $formattedCondition['values']);
	83	+ } else {
	84	+ $condition_to_check = null;
	85	+ }
86	86
87		- $sql = "UPDATE $this->table_name
	87	+ $sql = "UPDATE $this->table_name
88	88	SET meta_value = ( CASE meta_key
89	89	$case_part
90	90	END
91	91	)";
92		- $sql .= " " . $condition_to_check;
93		- $status = $this->execute($sql, $all_values)->getResult();
94		- if (is_wp_error($status) && $status->get_error_code() !== 'result_empty') {
95		- return $status;
96		- }
97		- return $updatedData;
	92	+ $sql .= ' ' . $condition_to_check;
	93	+ $status = $this->execute($sql, $all_values)->getResult();
	94	+ if (is_wp_error($status) && 'result_empty' !== $status->get_error_code()) {
	95	+ return $status;
98	96	}
	97	+ return $updatedData;
	98	+ }
99	99
100		- public function validQueryCondition($conditions) {
101		- foreach ($conditions as $index => $condition) {
102		- if (is_object($condition)) {
103		- if (empty($condition->field) || empty($condition->logic) || empty($condition->val) && !in_array($condition->val, ['0', 0, 0.0], TRUE)) {
104		- unset($conditions[$index]);
105		- unset($conditions[$index + 1]);
106		- }
107		- }
	100	+ public function validQueryCondition($conditions)
	101	+ {
	102	+ foreach ($conditions as $index => $condition) {
	103	+ if (is_object($condition)) {
	104	+ if (empty($condition->field) || empty($condition->logic) || empty($condition->val) && !in_array($condition->val, ['0', 0, 0.0], true)) {
	105	+ unset($conditions[$index], $conditions[$index + 1]);
108	106	}
109		- return $conditions;
	107	+ }
110	108	}
	109	+ return $conditions;
	110	+ }
111	111
112		- public function sqlQryGenerateByFldCondition($conditions) {
113		- $dbHelper = new Helper();
114		- $sql = '';
	112	+ public function sqlQryGenerateByFldCondition($conditions)
	113	+ {
	114	+ $dbHelper = new Helper();
	115	+ $sql = '';
115	116
116		- $dateQuery = $dbHelper->dateQueryList();
	117	+ $dateQuery = $dbHelper->dateQueryList();
117	118
118		- $validCondtions = $this->validQueryCondition($conditions);
	119	+ $validCondtions = $this->validQueryCondition($conditions);
119	120
120		- foreach ($validCondtions as $condition) {
121		- if (is_object($condition)) {
122		- if (is_array($condition->val)) {
123		- $value = $dbHelper->arrValueModifyByLogic($condition->logic, $condition->val);
124		- } else {
125		- $value = $dbHelper->strValueModifyByLogic($condition->logic, $condition->val);
126		- }
	121	+ foreach ($validCondtions as $condition) {
	122	+ if (is_object($condition)) {
	123	+ if (is_array($condition->val)) {
	124	+ $value = $dbHelper->arrValueModifyByLogic($condition->logic, $condition->val);
	125	+ } else {
	126	+ $value = $dbHelper->strValueModifyByLogic($condition->logic, $condition->val);
	127	+ }
127	128
128		- $operator = $dbHelper->convertToSqlOperator($condition->logic);
	129	+ $operator = $dbHelper->convertToSqlOperator($condition->logic);
	130	+ if (!is_array($condition->val) && isset($dateQuery[$condition->val])) {
	131	+ $sql .= $dbHelper->fieldQueryByDate($condition->field, $operator, $value, $condition->logic);
	132	+ } else {
	133	+ if (!is_int($value)) {
	134	+ $value = "'" . $value . "'";
	135	+ }
129	136
130		- if (isset($dateQuery[$condition->val])) {
131		- $sql .= $dbHelper->fieldQueryByDate($condition->field, $operator, $value, $condition->logic);
132		- } else {
133		- if (!is_int($value)) {
134		- $value = "'" . $value . "'";
135		- }
	137	+ $sql .= "`$condition->field` $operator $value";
	138	+ }
	139	+ } else {
	140	+ $sql .= ' ' . $condition;
	141	+ }
	142	+ }
136	143
137		- $sql .= "`$condition->field` $operator $value";
138		- }
139		- } else {
140		- $sql .= ' ' . $condition;
141		- }
142		- }
	144	+ return trim($sql);
	145	+ }
143	146
144		- return trim($sql);
	147	+ public function queryRecount($selectedMeta, $groupedCondition, $orderCondition, $all_values)
	148	+ {
	149	+ $entry_table = $this->app_db->prefix . 'bitforms_form_entries';
	150	+ $sql = 'SELECT count(*) as count FROM (';
	151	+ $sql .= "SELECT $selectedMeta FROM `$this->table_name` em";
	152	+ $sql .= " INNER JOIN $entry_table e on e.id = em.bitforms_form_entry_id ";
	153	+ $sql .= $groupedCondition . $orderCondition;
	154	+ $sql .= ') as retrievedData';
	155	+ $countResult = $this->execute($sql, $all_values)->getResult();
	156	+ return $countResult[0]->count;
	157	+ }
145	158
146		- }
	159	+ public function selectedEntryMeta($formFields, $fieldCount)
	160	+ {
	161	+ $all_values = [];
	162	+ $formFieldsNames = [];
	163	+ $metaChecker = 0;
	164	+ $selectedMeta = '`bitforms_form_entry_id` as entry_id,';
	165	+ $selectedMeta .= "e.user_id as '__user_id',";
	166	+ $selectedMeta .= "e.user_ip as '__user_ip',";
	167	+ $selectedMeta .= "e.status as '__entry_status',";
	168	+ $selectedMeta .= "e.user_location as '__user_location',";
	169	+ $selectedMeta .= "e.user_device as '__user_device',";
	170	+ $selectedMeta .= "e.referer as '__referer',";
	171	+ $selectedMeta .= "e.created_at as '__created_at',";
	172	+ $selectedMeta .= "e.updated_at as '__updated_at'";
147	173
148		- public function queryRecount($selectedMeta, $groupedCondition, $orderCondition, $all_values) {
149		- $entry_table = $this->app_db->prefix . 'bitforms_form_entries';
150		- $sql = "SELECT count(*) as count FROM (";
151		- $sql .= "SELECT $selectedMeta FROM `$this->table_name` em";
152		- $sql .= " INNER JOIN $entry_table e on e.id = em.bitforms_form_entry_id ";
153		- $sql .= $groupedCondition . $orderCondition;
154		- $sql .= ") as retrievedData";
155		- $countResult = $this->execute($sql, $all_values)->getResult();
156		- return $countResult[0]->count;
	174	+ if ($fieldCount > 0) {
	175	+ $selectedMeta .= ',';
157	176	}
158	177
159		- public function selectedEntryMeta($formFields, $fieldCount) {
160		- $all_values = [];
161		- $formFieldsNames = [];
162		- $metaChecker = 0;
163		- $selectedMeta = "`bitforms_form_entry_id` as entry_id,";
164		- $selectedMeta .= "e.user_id as '__user_id',";
165		- $selectedMeta .= "e.user_ip as '__user_ip',";
166		- $selectedMeta .= "e.status as '__entry_status',";
167		- $selectedMeta .= "e.user_location as '__user_location',";
168		- $selectedMeta .= "e.user_device as '__user_device',";
169		- $selectedMeta .= "e.referer as '__referer',";
170		- $selectedMeta .= "e.created_at as '__created_at',";
171		- $selectedMeta .= "e.updated_at as '__updated_at'";
172		-
173		- if ($fieldCount > 0) {
174		- $selectedMeta .= ",";
175		- }
176		-
177		- foreach ($formFields as $fieldDetails) {
178		- $fieldFormat = $this->getFieldFormat($fieldDetails['key']);
179		- $selectedMeta .= "GROUP_CONCAT(
	178	+ foreach ($formFields as $fieldDetails) {
	179	+ $fieldFormat = $this->getFieldFormat($fieldDetails['key']);
	180	+ $selectedMeta .= "GROUP_CONCAT(
180	181	CASE
181	182	`meta_key`
182	183	WHEN '$fieldFormat' THEN `meta_value`
183	184	END
184	185	) AS '$fieldFormat'";
185		- $metaChecker += 1;
186		- $all_values[] = $fieldDetails['key'];
187		- $all_values[] = $fieldDetails['key'];
188		- $formFieldsNames[] = $fieldDetails['key'];
189		- if ($metaChecker < $fieldCount) {
190		- $selectedMeta .= ",";
191		- }
192		- ##unused code commented by me##
193		- // if ( !empty( $filter['global'] ) ) {
194		- // $globalFilterString .= " `" . $fieldDetails['key'] . "` LIKE '%%" . $this->getFieldFormat( $filter['global'] ) . "%%' ";
195		- // if ( $metaChecker < $fieldCount ) {
196		- // $globalFilterString .= " OR ";
197		- // }
198		- // $globalFilterValues[] = $filter['global'];
199		- // }
200		- }
	186	+ $metaChecker += 1;
	187	+ $all_values[] = $fieldDetails['key'];
	188	+ $all_values[] = $fieldDetails['key'];
	189	+ $formFieldsNames[] = $fieldDetails['key'];
	190	+ if ($metaChecker < $fieldCount) {
	191	+ $selectedMeta .= ',';
	192	+ }
	193	+ //#unused code commented by me##
	194	+ // if ( !empty( $filter['global'] ) ) {
	195	+ // $globalFilterString .= " `" . $fieldDetails['key'] . "` LIKE '%%" . $this->getFieldFormat( $filter['global'] ) . "%%' ";
	196	+ // if ( $metaChecker < $fieldCount ) {
	197	+ // $globalFilterString .= " OR ";
	198	+ // }
	199	+ // $globalFilterValues[] = $filter['global'];
	200	+ // }
	201	+ }
201	202
202		- return [
203		- 'selected_meta' => $selectedMeta,
204		- 'form_fields_names' => $formFieldsNames,
205		- 'all_values' => $all_values,
206		- ];
	203	+ return [
	204	+ 'selected_meta' => $selectedMeta,
	205	+ 'form_fields_names' => $formFieldsNames,
	206	+ 'all_values' => $all_values,
	207	+ ];
	208	+ }
207	209
	210	+ public function groupedCondition($condition, $all_values, $fieldConditions)
	211	+ {
	212	+ $isFldCondition = false;
	213	+ $formattedCondition = $this->getFormatedCondition($condition);
	214	+ if ($formattedCondition) {
	215	+ $groupedCondition = $formattedCondition['conditions'] . 'GROUP BY
	216	+ `bitforms_form_entry_id` ';
	217	+ $all_values = array_merge($all_values, $formattedCondition['values']);
	218	+ } else {
	219	+ $groupedCondition = null;
208	220	}
	221	+ //#unused code commented by me##
	222	+ //$isRecount = false;
209	223
210		- public function groupedCondition($condition, $all_values, $fieldConditions) {
211		- $isFldCondition = false;
212		- $formattedCondition = $this->getFormatedCondition($condition);
213		- if ($formattedCondition) {
214		- $groupedCondition = $formattedCondition['conditions'] . "GROUP BY
215		- `bitforms_form_entry_id` ";
216		- $all_values = array_merge($all_values, $formattedCondition['values']);
217		- } else {
218		- $groupedCondition = null;
219		- }
220		- ##unused code commented by me##
221		- //$isRecount = false;
	224	+ // if ( !empty( $filter['field'] ) ) {
	225	+ // $isRecount = true;
	226	+ // $filterFieldCount = count( $filter['field'] );
	227	+ // $filterFieldChecker = 0;
	228	+ // if ( $filterFieldCount > 0 ) {
	229	+ // $groupedCondition .= " HAVING ";
	230	+ // }
	231	+ // foreach ( $filter['field'] as $filterFieldKey => $filterFieldDetails ) {
	232	+ // $groupedCondition .= " `$filterFieldDetails->id` ='%%" . $this->getFieldFormat( $filterFieldDetails->value ) . "%%'";
	233	+ // $all_values[] = $filterFieldDetails->value;
	234	+ // if ( $filterFieldChecker < $filterFieldCount ) {
	235	+ // $groupedCondition .= " AND ";
	236	+ // }
	237	+ // }
	238	+ // }
222	239
223		- // if ( !empty( $filter['field'] ) ) {
224		- // $isRecount = true;
225		- // $filterFieldCount = count( $filter['field'] );
226		- // $filterFieldChecker = 0;
227		- // if ( $filterFieldCount > 0 ) {
228		- // $groupedCondition .= " HAVING ";
229		- // }
230		- // foreach ( $filter['field'] as $filterFieldKey => $filterFieldDetails ) {
231		- // $groupedCondition .= " `$filterFieldDetails->id` ='%%" . $this->getFieldFormat( $filterFieldDetails->value ) . "%%'";
232		- // $all_values[] = $filterFieldDetails->value;
233		- // if ( $filterFieldChecker < $filterFieldCount ) {
234		- // $groupedCondition .= " AND ";
235		- // }
236		- // }
237		- // }
	240	+ // if ( !empty( $filter['global'] ) && !empty( $globalFilterString ) && !empty( $globalFilterValues ) ) {
	241	+ // $isRecount = true;
	242	+ // if ( !empty( $filter['field'] ) ) {
	243	+ // $groupedCondition .= " AND (" . $globalFilterString . ") ";
	244	+ // } else {
	245	+ // $groupedCondition .= " HAVING $globalFilterString ";
	246	+ // }
	247	+ // $offset = 0;
	248	+ // $all_values = array_merge( $all_values, $globalFilterValues );
	249	+ // }
238	250
239		- // if ( !empty( $filter['global'] ) && !empty( $globalFilterString ) && !empty( $globalFilterValues ) ) {
240		- // $isRecount = true;
241		- // if ( !empty( $filter['field'] ) ) {
242		- // $groupedCondition .= " AND (" . $globalFilterString . ") ";
243		- // } else {
244		- // $groupedCondition .= " HAVING $globalFilterString ";
245		- // }
246		- // $offset = 0;
247		- // $all_values = array_merge( $all_values, $globalFilterValues );
248		- // }
	251	+ // if ( !empty( $dateBetweenFilter ) && !empty( $dateBetweenFilter->start_date ) && !empty( $dateBetweenFilter->end_date ) ) {
	252	+ // if ( strpos( $groupedCondition, 'HAVING' ) !== false ) {
	253	+ // $groupedCondition .= " AND `__created_at` BETWEEN '" . $dateBetweenFilter->start_date . "' AND '" . $dateBetweenFilter->end_date . "' ";
	254	+ // } else {
	255	+ // $groupedCondition .= " HAVING `__created_at` BETWEEN '" . $dateBetweenFilter->start_date . "' AND '" . $dateBetweenFilter->end_date . "' ";
	256	+ // }
	257	+ // }
249	258
250		- // if ( !empty( $dateBetweenFilter ) && !empty( $dateBetweenFilter->start_date ) && !empty( $dateBetweenFilter->end_date ) ) {
251		- // if ( strpos( $groupedCondition, 'HAVING' ) !== false ) {
252		- // $groupedCondition .= " AND `__created_at` BETWEEN '" . $dateBetweenFilter->start_date . "' AND '" . $dateBetweenFilter->end_date . "' ";
253		- // } else {
254		- // $groupedCondition .= " HAVING `__created_at` BETWEEN '" . $dateBetweenFilter->start_date . "' AND '" . $dateBetweenFilter->end_date . "' ";
255		- // }
256		- // }
	259	+ $sqlQryByFldCondtion = $this->sqlQryGenerateByFldCondition($fieldConditions);
257	260
258		- $sqlQryByFldCondtion = $this->sqlQryGenerateByFldCondition($fieldConditions);
	261	+ if (!empty($sqlQryByFldCondtion)) {
	262	+ $isFldCondition = true;
	263	+ if (false !== strpos($groupedCondition, 'HAVING')) {
	264	+ $groupedCondition .= ' AND (' . $sqlQryByFldCondtion . ') ';
	265	+ } else {
	266	+ $groupedCondition .= ' HAVING (' . $sqlQryByFldCondtion . ') ';
	267	+ }
	268	+ }
	269	+ return [
	270	+ 'groupedCondition' => $groupedCondition,
	271	+ 'all_values' => $all_values,
	272	+ 'isFldCondition' => $isFldCondition,
	273	+ ];
	274	+ }
259	275
260		- if (!empty($sqlQryByFldCondtion)) {
261		- $isFldCondition = true;
262		- if (strpos($groupedCondition, 'HAVING') !== false) {
263		- $groupedCondition .= " AND (" . $sqlQryByFldCondtion . ") ";
264		- } else {
265		- $groupedCondition .= " HAVING (" . $sqlQryByFldCondtion . ") ";
266		- }
267		-
	276	+ public function orderCondition($formFieldsNames, $sortBy)
	277	+ {
	278	+ $orderCondition = null;
	279	+ if (!empty($sortBy)) {
	280	+ $sortableFieldCount = count($sortBy);
	281	+ $sortableFieldChecker = 0;
	282	+ if ($sortableFieldCount > 0) {
	283	+ $orderCondition .= ' ORDER BY ';
	284	+ }
	285	+ $orderList = '';
	286	+ foreach ($sortBy as $sortableFieldKey => $sortableFieldDetails) {
	287	+ // $orderCondition .=" ".$this->getFieldFormat($sortableFieldDetails->id);
	288	+ $sortableFieldChecker += 1;
	289	+ if (in_array($sortableFieldDetails->id, $formFieldsNames)) {
	290	+ $orderList .= " `$sortableFieldDetails->id` ";
	291	+ $orderFollow = $sortableFieldDetails->desc ? ' DESC ' : ' ASC ';
	292	+ $orderList .= ' ' . $orderFollow;
	293	+ if ($sortableFieldChecker < $sortableFieldCount) {
	294	+ $orderList .= ', ';
	295	+ }
268	296	}
269		- return [
270		- 'groupedCondition' => $groupedCondition,
271		- 'all_values' => $all_values,
272		- 'isFldCondition' => $isFldCondition,
273		- ];
	297	+ }
	298	+ if (empty($orderList)) {
	299	+ $orderCondition = null;
	300	+ } else {
	301	+ $orderCondition .= $orderList;
	302	+ }
274	303	}
	304	+ $orderCondition .= empty($orderCondition) ? ' ORDER BY `bitforms_form_entry_id` DESC ' : ',`bitforms_form_entry_id` DESC ';
	305	+ return $orderCondition;
	306	+ }
275	307
276		- public function orderCondition($formFieldsNames, $sortBy) {
277		- $orderCondition = null;
278		- if (!empty($sortBy)) {
279		- $sortableFieldCount = count($sortBy);
280		- $sortableFieldChecker = 0;
281		- if ($sortableFieldCount > 0) {
282		- $orderCondition .= " ORDER BY ";
283		- }
284		- $orderList = '';
285		- foreach ($sortBy as $sortableFieldKey => $sortableFieldDetails) {
286		- // $orderCondition .=" ".$this->getFieldFormat($sortableFieldDetails->id);
287		- $sortableFieldChecker += 1;
288		- if (in_array($sortableFieldDetails->id, $formFieldsNames)) {
289		- $orderList .= " `$sortableFieldDetails->id` ";
290		- $orderFollow = $sortableFieldDetails->desc ? ' DESC ' : ' ASC ';
291		- $orderList .= " " . $orderFollow;
292		- if ($sortableFieldChecker < $sortableFieldCount) {
293		- $orderList .= ", ";
294		- }
295		- }
296		- }
297		- if (empty($orderList)) {
298		- $orderCondition = null;
299		- } else {
300		- $orderCondition .= $orderList;
301		- }
302		- }
303		- $orderCondition .= empty($orderCondition) ? " ORDER BY `bitforms_form_entry_id` DESC " : ",`bitforms_form_entry_id` DESC ";
304		- return $orderCondition;
	308	+ public function isEntryMetaExist($conditions)
	309	+ {
	310	+ $existMetaData = $this->get(
	311	+ [
	312	+ 'meta_key',
	313	+ 'meta_value',
	314	+ ],
	315	+ $conditions
	316	+ );
	317	+ if (!is_wp_error($existMetaData) && count($existMetaData) > 0) {
	318	+ return true;
305	319	}
	320	+ return false;
	321	+ }
306	322
307		- public function getEntryMeta($formFields, $entries, $limit = null, $offset = null, $filter = null, $sortBy = null, $fieldConditions = null) {
308		- $entry_table = $this->app_db->prefix . 'bitforms_form_entries';
309		- $fieldCount = count($formFields);
310		- $getSelectedMetaFldValue = $this->selectedEntryMeta($formFields, $fieldCount);
	323	+ public function getEntryMeta($formFields, $entries, $limit = null, $offset = null, $filter = null, $sortBy = null, $fieldConditions = null, $dateBetweenFilter = null)
	324	+ {
	325	+ $entry_table = $this->app_db->prefix . 'bitforms_form_entries';
	326	+ $fieldCount = count($formFields);
	327	+ $getSelectedMetaFldValue = $this->selectedEntryMeta($formFields, $fieldCount);
311	328
312		- $selectedMeta = $getSelectedMetaFldValue['selected_meta'];
313		- $formFieldsNames = $getSelectedMetaFldValue['form_fields_names'];
314		- $all_values = $getSelectedMetaFldValue['all_values'];
315		- $entryIDs = array();
316		- $entryCount = count($entries);
317		- // $paginateEntry = empty($sortBy) && empty($filter['field']) && empty($filter['global']);
318		- // $entries = $paginateEntry ? array_slice($entries, $offset, $limit) : $entries;
319		- $paginateEntry = false;
320		- foreach ($entries as $entryDetail) {
321		- $entryIDs[] = $entryDetail->id;
322		- }
323		- if (empty($entryIDs)) {
324		- return array(
325		- 'count' => 0,
326		- 'entries' => [],
327		- );
328		- }
329		- $condition['bitforms_form_entry_id'] = $entryIDs;
330		- $group = $this->groupedCondition($condition, $all_values, $fieldConditions);
331		- $groupedCondition = $group['groupedCondition'];
332		- $all_values = $group['all_values'];
333		- $isFldCondition = $group['isFldCondition'];
334		- $orderCondition = $this->orderCondition($formFieldsNames, $sortBy);
	329	+ $selectedMeta = $getSelectedMetaFldValue['selected_meta'];
	330	+ $formFieldsNames = $getSelectedMetaFldValue['form_fields_names'];
	331	+ $all_values = $getSelectedMetaFldValue['all_values'];
	332	+ $entryIDs = [];
	333	+ $entryCount = count($entries);
	334	+ // $paginateEntry = empty($sortBy) && empty($filter['field']) && empty($filter['global']);
	335	+ // $entries = $paginateEntry ? array_slice($entries, $offset, $limit) : $entries;
	336	+ $paginateEntry = false;
	337	+ foreach ($entries as $entryDetail) {
	338	+ $entryIDs[] = $entryDetail->id;
	339	+ }
	340	+ if (empty($entryIDs)) {
	341	+ return [
	342	+ 'count' => 0,
	343	+ 'entries' => [],
	344	+ ];
	345	+ }
	346	+ $condition['bitforms_form_entry_id'] = $entryIDs;
	347	+ $group = $this->groupedCondition($condition, $all_values, $fieldConditions);
	348	+ $groupedCondition = $group['groupedCondition'];
	349	+ $all_values = $group['all_values'];
	350	+ $isFldCondition = $group['isFldCondition'];
	351	+ $orderCondition = $this->orderCondition($formFieldsNames, $sortBy);
335	352
336		- $paginate = null;
337		- if (!\is_null($limit)) {
338		- $limit = \intval($limit);
339		- $paginate .= " LIMIT $limit ";
340		- }
341		- if (!\is_null($offset)) {
342		- $offset = \intval($offset);
343		- $paginate .= " OFFSET $offset ";
344		- }
345		- $sql = "SELECT $selectedMeta FROM `$this->table_name` em";
346		- $sql .= " INNER JOIN $entry_table e on e.id = em.bitforms_form_entry_id ";
347		- $sql .= $groupedCondition . $orderCondition . $paginate;
348		- $result = $this->execute($sql, $all_values)->getResult();
349		- if (is_wp_error($result)) {
350		- return array(
351		- 'count' => $paginateEntry ? $entryCount : 0,
352		- 'entries' => [],
353		- 'error' => $result->get_error_message()
354		- );
355		- }
356		- if ($isFldCondition) {
357		- $condition['bitforms_form_entry_id'] = $entryIDs;
358		- $group = $this->groupedCondition($condition, $all_values, $fieldConditions);
359		- $all_values = $group['all_values'];
360		- $entryCount = $this->queryRecount($selectedMeta, $group['groupedCondition'], $orderCondition, $all_values);
361		- }
362		- $resultedEntries = array(
363		- 'count' => $entryCount,
364		- 'entries' => $result,
365		- );
366		- return $resultedEntries;
	353	+ $paginate = null;
	354	+ if (!\is_null($limit)) {
	355	+ $limit = \intval($limit);
	356	+ $paginate .= " LIMIT $limit ";
367	357	}
	358	+ if (!\is_null($offset)) {
	359	+ $offset = \intval($offset);
	360	+ $paginate .= " OFFSET $offset ";
	361	+ }
	362	+ $sql = "SELECT $selectedMeta FROM `$this->table_name` em";
	363	+ $sql .= " INNER JOIN $entry_table e on e.id = em.bitforms_form_entry_id ";
	364	+ if ($dateBetweenFilter) {
	365	+ $startDate = $dateBetweenFilter->start_date;
	366	+ $endDate = $dateBetweenFilter->end_date;
	367	+ if ($startDate && $endDate) {
	368	+ $sql .= " AND DATE(e.created_at) BETWEEN '$startDate' AND '$endDate' ";
	369	+ } elseif ($startDate) {
	370	+ $sql .= " AND DATE(e.created_at) >= '$startDate' ";
	371	+ } elseif ($endDate) {
	372	+ $sql .= " AND DATE(e.created_at) <= '$endDate' ";
	373	+ }
	374	+ }
	375	+ $sql .= $groupedCondition . $orderCondition . $paginate;
	376	+ $result = $this->execute($sql, $all_values)->getResult();
	377	+ if (is_wp_error($result)) {
	378	+ return [
	379	+ 'count' => $paginateEntry ? $entryCount : 0,
	380	+ 'entries' => [],
	381	+ 'error' => $result->get_error_message()
	382	+ ];
	383	+ }
	384	+ if ($isFldCondition) {
	385	+ $condition['bitforms_form_entry_id'] = $entryIDs;
	386	+ $group = $this->groupedCondition($condition, $all_values, $fieldConditions);
	387	+ $all_values = $group['all_values'];
	388	+ $entryCount = $this->queryRecount($selectedMeta, $group['groupedCondition'], $orderCondition, $all_values);
	389	+ }
	390	+ $resultedEntries = [
	391	+ 'count' => $entryCount,
	392	+ 'entries' => $result,
	393	+ ];
	394	+ return $resultedEntries;
	395	+ }
368	396
369		- private function csvInjectionPrevent($value)
370		- {
371		- $formula= ['=', '-', '+', '@', "\t", "\r"];
372		- $valueFilter = preg_replace('/[\]["]/i', '', $value);
373		- if (\in_array(substr($value, 0, 1), $formula, true)) {
374		- $valueFilter = "'".trim($valueFilter);
375		- }
	397	+ public function getSingleEntryMeta($formFields, $entryId)
	398	+ {
	399	+ $entry_table = $this->app_db->prefix . 'bitforms_form_entries';
	400	+ $fieldCount = count($formFields);
	401	+ $getSelectedMetaFldValue = $this->selectedEntryMeta($formFields, $fieldCount);
	402	+ $selectedMeta = $getSelectedMetaFldValue['selected_meta'];
	403	+ $formFieldsNames = $getSelectedMetaFldValue['form_fields_names'];
	404	+ $all_values = $getSelectedMetaFldValue['all_values'];
	405	+ $condition['bitforms_form_entry_id'] = [$entryId];
	406	+ $group = $this->groupedCondition($condition, $all_values, []);
	407	+ $groupedCondition = $group['groupedCondition'];
	408	+ $all_values = $group['all_values'];
	409	+ $orderCondition = $this->orderCondition($formFieldsNames, null);
	410	+ $sql = "SELECT $selectedMeta FROM `$this->table_name` em";
	411	+ $sql .= " INNER JOIN $entry_table e on e.id = em.bitforms_form_entry_id ";
	412	+ $sql .= $groupedCondition . $orderCondition;
	413	+ $result = $this->execute($sql, $all_values)->getResult();
376	414
377		- return $valueFilter;
	415	+ if (is_wp_error($result)) {
	416	+ return [];
378	417	}
	418	+ return $result;
	419	+ }
379	420
	421	+ private function csvInjectionPrevent($value)
	422	+ {
	423	+ $formula = ['=', '-', '+', '@', "\t", "\r"];
	424	+ $valueFilter = preg_replace('/[\]["]/i', '', $value);
	425	+ if (\in_array(substr($value, 0, 1), $formula, true)) {
	426	+ $valueFilter = "'" . trim($valueFilter);
	427	+ }
380	428
381		- public function getExportEntry($formFields, $entries, $formId, $fieldLabels, $fileFormate, $limit = null, $sortBy = null, $sortByField = null) {
382		- $entry_table = $this->app_db->prefix . 'bitforms_form_entries';
383		- $selectedEntryMeta = "`bitforms_form_entry_id` as entry_id,";
384		- $selectedEntryMeta .= "e.user_id as '__user_id',";
385		- $selectedEntryMeta .= "e.status as '__entry_status',";
386		- $selectedEntryMeta .= "e.user_ip as '__user_ip',";
387		- $selectedEntryMeta .= "e.user_location as '__user_location',";
388		- $selectedEntryMeta .= "e.user_device as '__user_device',";
389		- $selectedEntryMeta .= "e.referer as '__referer',";
390		- $selectedEntryMeta .= "e.created_at as '__created_at',";
391		- $selectedEntryMeta .= "e.updated_at as '__updated_at',";
392		- $metaChecker = 0;
	429	+ return $valueFilter;
	430	+ }
393	431
394		- $entryInfo = ['__user_id', '__user_ip', /* '__user_location', */'__user_device',
395		- '__referer', '__created_at', '__updated_at'];
396		- $all_values = array();
397		- if ($formFields == []) {
398		- $data = array(
399		- 'count' => 0,
400		- 'entries' => [],
401		- );
402		- wp_send_json_success($data, 200);
403		- }
404		- $fieldCount = count($formFields) - count(array_intersect($formFields, $entryInfo));
405		- $formFieldsNames = array();
406		- foreach ($formFields as $fldKey) {
407		- $formFieldsNames[] = $fldKey;
408		- if (in_array($fldKey, $entryInfo)) {
409		- continue;
410		- }
411		- $fieldFormat = $this->getFieldFormat($fldKey);
412		- $selectedEntryMeta .= "GROUP_CONCAT(
	432	+ public function getExportEntry($formFields, $entries, $formId, $fieldLabels, $limit = null, $sortBy = null, $sortByField = null)
	433	+ {
	434	+ $entry_table = $this->app_db->prefix . 'bitforms_form_entries';
	435	+ $selectedEntryMeta = '`bitforms_form_entry_id` as entry_id,';
	436	+ $selectedEntryMeta .= "e.user_id as '__user_id',";
	437	+ $selectedEntryMeta .= "e.status as '__entry_status',";
	438	+ $selectedEntryMeta .= "e.user_ip as '__user_ip',";
	439	+ $selectedEntryMeta .= "e.user_location as '__user_location',";
	440	+ $selectedEntryMeta .= "e.user_device as '__user_device',";
	441	+ $selectedEntryMeta .= "e.referer as '__referer',";
	442	+ $selectedEntryMeta .= "e.created_at as '__created_at',";
	443	+ $selectedEntryMeta .= "e.updated_at as '__updated_at',";
	444	+ $metaChecker = 0;
	445	+
	446	+ $entryInfo = ['__user_id', '__user_ip', /* '__user_location', */'__user_device',
	447	+ '__referer', '__created_at', '__updated_at'];
	448	+ $all_values = [];
	449	+ if ([] === $formFields) {
	450	+ $data = [
	451	+ 'count' => 0,
	452	+ 'entries' => [],
	453	+ ];
	454	+ wp_send_json_success($data, 200);
	455	+ }
	456	+ $fieldCount = count($formFields) - count(array_intersect($formFields, $entryInfo));
	457	+ $formFieldsNames = [];
	458	+ foreach ($formFields as $fldKey) {
	459	+ $formFieldsNames[] = $fldKey;
	460	+ if (in_array($fldKey, $entryInfo)) {
	461	+ continue;
	462	+ }
	463	+ $fieldFormat = $this->getFieldFormat($fldKey);
	464	+ $selectedEntryMeta .= "GROUP_CONCAT(
413	465	CASE
414	466	`meta_key`
415	467	WHEN '$fieldFormat' THEN `meta_value`
416	468	END
417	469	) AS '$fieldFormat'";
418		- $metaChecker += 1;
419		- $all_values[] = $fldKey;
420		- $all_values[] = $fldKey;
421		- if ($metaChecker < $fieldCount) {
422		- $selectedEntryMeta .= ",";
423		- }
424		- }
425		- $entryIDs = array();
426		- foreach ($entries as $entryDetail) {
427		- $entryIDs[] = $entryDetail->id;
428		- }
429		- if (empty($entryIDs)) {
430		- return array(
431		- 'count' => 0,
432		- 'entries' => [],
433		- );
434		- }
435		- $condition['bitforms_form_entry_id'] = $entryIDs;
436		- $formattedCondition = $this->getFormatedCondition($condition);
437		- $groupedCondition = null;
438		- if ($formattedCondition) {
439		- $groupedCondition = $formattedCondition['conditions'] . " GROUP BY
440		- `bitforms_form_entry_id` ";
441		- $all_values = array_merge($all_values, $formattedCondition['values']);
442		- }
443		- $order = \is_null($sortBy) ? "DESC " : "$sortBy";
444		- $orderField = \is_null($sortByField) ? "bitforms_form_entry_id" : "`$sortByField`";
	470	+ $metaChecker += 1;
	471	+ $all_values[] = $fldKey;
	472	+ $all_values[] = $fldKey;
	473	+ if ($metaChecker < $fieldCount) {
	474	+ $selectedEntryMeta .= ',';
	475	+ }
	476	+ }
	477	+ $entryIDs = [];
	478	+ foreach ($entries as $entryDetail) {
	479	+ $entryIDs[] = $entryDetail->id;
	480	+ }
	481	+ if (empty($entryIDs)) {
	482	+ return [
	483	+ 'count' => 0,
	484	+ 'entries' => [],
	485	+ ];
	486	+ }
	487	+ $condition['bitforms_form_entry_id'] = $entryIDs;
	488	+ $formattedCondition = $this->getFormatedCondition($condition);
	489	+ $groupedCondition = null;
	490	+ if ($formattedCondition) {
	491	+ $groupedCondition = $formattedCondition['conditions'] . ' GROUP BY
	492	+ `bitforms_form_entry_id` ';
	493	+ $all_values = array_merge($all_values, $formattedCondition['values']);
	494	+ }
	495	+ $order = 'DESC' === $sortBy ? 'DESC ' : 'ASC ';
	496	+ $orderField = \is_null($sortByField) ? 'bitforms_form_entry_id' : "`$sortByField`";
445	497
446		- $orderCondition = "ORDER BY $orderField $order ";
447		- if (!\is_null($limit)) {
448		- $limitInt = \intval($limit);
449		- $limit = " LIMIT $limitInt ";
450		- }
451		- $sql = "SELECT $selectedEntryMeta FROM `$this->table_name` em";
452		- $sql .= " INNER JOIN $entry_table e on e.id = em.bitforms_form_entry_id ";
453		- $sql .= $groupedCondition . $orderCondition . $limit;
	498	+ $orderCondition = "ORDER BY $orderField $order ";
	499	+ if (!\is_null($limit)) {
	500	+ $limitInt = \intval($limit);
	501	+ $limit = " LIMIT $limitInt ";
	502	+ }
	503	+ $sql = "SELECT $selectedEntryMeta FROM `$this->table_name` em";
	504	+ $sql .= " INNER JOIN $entry_table e on e.id = em.bitforms_form_entry_id ";
	505	+ $sql .= $groupedCondition . $orderCondition . $limit;
454	506
455		- $result = $this->execute($sql, $all_values)->getResult();
456		- $allData = [];
457		- $entry_id = "entry_id";
458		- $users = get_users(['fields' => ['ID', 'display_name']]);
459		- $userNames = [];
460		- foreach ($users as $key => $value) {
461		- $userNames[$value->ID] = $value->display_name;
	507	+ $result = $this->execute($sql, $all_values)->getResult();
	508	+ $allData = [];
	509	+ $entry_id = 'entry_id';
	510	+ $users = get_users(['fields' => ['ID', 'display_name']]);
	511	+ $userNames = [];
	512	+ foreach ($users as $key => $value) {
	513	+ $userNames[$value->ID] = $value->display_name;
	514	+ }
	515	+ foreach ($result as $key => $value) {
	516	+ foreach ($formFieldsNames as $formFieldName) {
	517	+ $allData[$key]['entry_id'] = preg_replace('/[\]["]/i', '', $value->$entry_id);
	518	+ if ('__user_id' === $formFieldName && intval($value->$formFieldName) > 0) {
	519	+ $allData[$key][$formFieldName] = $userNames[$value->$formFieldName];
	520	+ } elseif ('__user_ip' === $formFieldName) {
	521	+ $allData[$key][$formFieldName] = long2ip((int)$value->$formFieldName);
	522	+ } else {
	523	+ $allData[$key][$formFieldName] = preg_replace('/[\]["]/i', '', $value->$formFieldName);
462	524	}
463		- foreach ($result as $key => $value) {
464		- foreach ($formFieldsNames as $formFieldName) {
465		- $allData[$key]['entry_id'] = preg_replace('/[\]["]/i', '', $value->$entry_id);
466		- if ($formFieldName === '__user_id' && intval($value->$formFieldName) > 0) {
467		- $allData[$key][$formFieldName] = $userNames[$value->$formFieldName];
468		- } elseif ($formFieldName === '__user_ip') {
469		- $allData[$key][$formFieldName] = long2ip($value->$formFieldName);
470		- } else {
471		- $allData[$key][$formFieldName] = preg_replace('/[\]["]/i', '', $value->$formFieldName);
472		- }
473		- if (is_string($value->$formFieldName) && in_array($fileFormate, ['csv', 'xlsx', 'xls'])) {
474		- $allData[$key][$formFieldName] = $this->csvInjectionPrevent($value->$formFieldName);
475		- }
	525	+ }
	526	+ }
476	527
477		-
	528	+ if (is_wp_error($result)) {
	529	+ wp_send_json_error('Internal server error', 500);
	530	+ } else {
	531	+ $downloadableFieldType = ['file-up', 'signature', 'advanced-file-up'];
	532	+ foreach ($fieldLabels as $field) {
	533	+ foreach ($allData as $index => $entry) {
	534	+ if (array_key_exists($field['key'], $entry) && in_array($field['type'], $downloadableFieldType, true)) {
	535	+ $key = $field['key'];
	536	+ if (empty($entry[$key])) {
	537	+ continue;
478	538	}
479		- }
480		-
481		- if (is_wp_error($result)) {
482		- wp_send_json_error('Internal server error', 500);
483		- } else {
484		- foreach ($fieldLabels as $field) {
485		- foreach ($allData as $index => $entry) {
486		- if (array_key_exists($field['key'], $entry) && $field['type'] == 'file-up') {
487		- $key = $field['key'];
488		- if (empty($entry[$key])) {
489		- continue;
490		- }
491		- $_upload_dir = BITFORMS_UPLOAD_DIR . DIRECTORY_SEPARATOR . $formId . DIRECTORY_SEPARATOR . $entry['entry_id'];
492		- if (is_array(explode(",", $entry[$key]))) {
493		- $fileData = array();
494		- foreach (explode(",", $entry[$key]) as $file) {
495		- $uploadedFile= explode("_", $file);
496		- $path = "bitforms/bitforms-file/?formID=$formId&entryID=" . $entry['entry_id'] . "&fileID=$uploadedFile[0]";
497		- if (file_exists($_upload_dir . DIRECTORY_SEPARATOR . $uploadedFile[0])) {
498		- $fileData[] = site_url($path, null);
499		- }
500		- }
501		- $allData[$index][$key] = implode(',', $fileData);
502		- } else {
503		- $uploadedFile= explode("_", $entry[$key]);
504		- $path = "bitforms/bitforms-file/?formID=$formId&entryID=" . $entry['entry_id'] . "&fileID=" . $uploadedFile[0];
505		- if (file_exists($_upload_dir . DIRECTORY_SEPARATOR . $uploadedFile[0])) {
506		- $allData[$index][$key] = site_url($path, null);
507		- }
508		- }
509		- }
	539	+ $_upload_dir = BITFORMS_UPLOAD_DIR . DIRECTORY_SEPARATOR . $formId . DIRECTORY_SEPARATOR . $entry['entry_id'];
	540	+ $imageArray = explode(',', $entry[$key]);
	541	+ if (is_array($imageArray)) {
	542	+ $fileData = [];
	543	+ foreach ($imageArray as $file) {
	544	+ $path = "bitforms/bitforms-file-$formId/?formID=$formId&entryID=" . $entry['entry_id'] . "&fileID=$file";
	545	+ if (file_exists($_upload_dir . DIRECTORY_SEPARATOR . $file)) {
	546	+ $fileData[] = site_url($path, null);
510	547	}
	548	+ }
	549	+ $allData[$index][$key] = implode(',', $fileData);
	550	+ } else {
	551	+ $uploadedFile = explode('_', $entry[$key]);
	552	+ $path = "bitforms/bitforms-file-$formId/?formID=$formId&entryID=" . $entry['entry_id'] . '&fileID=' . $uploadedFile[0];
	553	+ if (file_exists($_upload_dir . DIRECTORY_SEPARATOR . $uploadedFile[0])) {
	554	+ $allData[$index][$key] = site_url($path, null);
	555	+ }
511	556	}
512		- wp_send_json_success($allData, 200);
	557	+ }
513	558	}
	559	+ }
	560	+ wp_send_json_success($allData, 200);
514	561	}
	562	+ }
515	563	}