← All changes | includes/Core/Database/FormEntryMetaModel.php +198 -159 2.0 → 2.17.6 View file →

		@@ -5,16 +5,20 @@
5	5	*/
6	6
7	7	namespace BitCode\BitForm\Core\Database;
8	8
	9	+use BitCode\BitForm\Core\Util\FileHandler;
	10	+
9	11	/**
10	12	* Undocumented class
11	13	*/
12	14
13		-class FormEntryMetaModel extends Model {
	15	+class FormEntryMetaModel extends Model
	16	+{
14	17	protected static $table = 'bitforms_form_entrymeta';
15	18
16		- public function duplicateEntryMeta($data) {
	19	+ public function duplicateEntryMeta($data)
	20	+ {
17	21	$values[] = $data['duplicateID'];
18	22	$values[] = $data['entryID'];
19	23	$sql = "INSERT INTO $this->table_name (bitforms_form_entry_id,meta_key,meta_value)"
20	24	. ' SELECT %d as bitforms_form_entry_id,meta_key,meta_value'
		@@ -21,9 +25,10 @@
21	25	. " FROM `$this->table_name` WHERE bitforms_form_entry_id = %d";
22	26	return $this->execute($sql, $values)->getResult();
23	27	}
24	28
25		- public function update(array $data, array $condition) {
	29	+ public function update(array $data, array $condition)
	30	+ {
26	31	$entryID = $condition['bitforms_form_entry_id'];
27	32	if (empty($entryID)) {
28	33	return false;
29	34	}
		@@ -93,9 +98,10 @@
93	98	}
94	99	return $updatedData;
95	100	}
96	101
97		- public function validQueryCondition($conditions) {
	102	+ public function validQueryCondition($conditions)
	103	+ {
98	104	foreach ($conditions as $index => $condition) {
99	105	if (is_object($condition)) {
100	106	if (empty($condition->field) || empty($condition->logic) || empty($condition->val) && !in_array($condition->val, ['0', 0, 0.0], true)) {
101	107	unset($conditions[$index], $conditions[$index + 1]);
		@@ -104,9 +110,10 @@
104	110	}
105	111	return $conditions;
106	112	}
107	113
108		- public function sqlQryGenerateByFldCondition($conditions) {
	114	+ public function sqlQryGenerateByFldCondition($conditions)
	115	+ {
109	116	$dbHelper = new Helper();
110	117	$sql = '';
111	118
112	119	$dateQuery = $dbHelper->dateQueryList();
		@@ -121,10 +128,9 @@
121	128	$value = $dbHelper->strValueModifyByLogic($condition->logic, $condition->val);
122	129	}
123	130
124	131	$operator = $dbHelper->convertToSqlOperator($condition->logic);
125		-
126		- if (isset($dateQuery[$condition->val])) {
	132	+ if (!is_array($condition->val) && isset($dateQuery[$condition->val])) {
127	133	$sql .= $dbHelper->fieldQueryByDate($condition->field, $operator, $value, $condition->logic);
128	134	} else {
129	135	if (!is_int($value)) {
130	136	$value = "'" . $value . "'";
		@@ -139,9 +145,10 @@
139	145
140	146	return trim($sql);
141	147	}
142	148
143		- public function queryRecount($selectedMeta, $groupedCondition, $orderCondition, $all_values) {
	149	+ public function queryRecount($selectedMeta, $groupedCondition, $orderCondition, $all_values)
	150	+ {
144	151	$entry_table = $this->app_db->prefix . 'bitforms_form_entries';
145	152	$sql = 'SELECT count(*) as count FROM (';
146	153	$sql .= "SELECT $selectedMeta FROM `$this->table_name` em";
147	154	$sql .= " INNER JOIN $entry_table e on e.id = em.bitforms_form_entry_id ";
		@@ -150,9 +157,10 @@
150	157	$countResult = $this->execute($sql, $all_values)->getResult();
151	158	return $countResult[0]->count;
152	159	}
153	160
154		- public function selectedEntryMeta($formFields, $fieldCount) {
	161	+ public function selectedEntryMeta($formFields, $fieldCount)
	162	+ {
155	163	$all_values = [];
156	164	$formFieldsNames = [];
157	165	$metaChecker = 0;
158	166	$selectedMeta = '`bitforms_form_entry_id` as entry_id,';
		@@ -185,13 +193,13 @@
185	193	$selectedMeta .= ',';
186	194	}
187	195	//#unused code commented by me##
188	196	// if ( !empty( $filter['global'] ) ) {
189		- // $globalFilterString .= " `" . $fieldDetails['key'] . "` LIKE '%%" . $this->getFieldFormat( $filter['global'] ) . "%%' ";
190		- // if ( $metaChecker < $fieldCount ) {
191		- // $globalFilterString .= " OR ";
192		- // }
193		- // $globalFilterValues[] = $filter['global'];
	197	+ // $globalFilterString .= " `" . $fieldDetails['key'] . "` LIKE '%%" . $this->getFieldFormat( $filter['global'] ) . "%%' ";
	198	+ // if ( $metaChecker < $fieldCount ) {
	199	+ // $globalFilterString .= " OR ";
	200	+ // }
	201	+ // $globalFilterValues[] = $filter['global'];
194	202	// }
195	203	}
196	204
197	205	return [
		@@ -200,9 +208,10 @@
200	208	'all_values' => $all_values,
201	209	];
202	210	}
203	211
204		- public function groupedCondition($condition, $all_values, $fieldConditions) {
	212	+ public function groupedCondition($condition, $all_values, $fieldConditions)
	213	+ {
205	214	$isFldCondition = false;
206	215	$formattedCondition = $this->getFormatedCondition($condition);
207	216	if ($formattedCondition) {
208	217	$groupedCondition = $formattedCondition['conditions'] . 'GROUP BY
		@@ -214,40 +223,40 @@
214	223	//#unused code commented by me##
215	224	//$isRecount = false;
216	225
217	226	// if ( !empty( $filter['field'] ) ) {
218		- // $isRecount = true;
219		- // $filterFieldCount = count( $filter['field'] );
220		- // $filterFieldChecker = 0;
221		- // if ( $filterFieldCount > 0 ) {
222		- // $groupedCondition .= " HAVING ";
223		- // }
224		- // foreach ( $filter['field'] as $filterFieldKey => $filterFieldDetails ) {
225		- // $groupedCondition .= " `$filterFieldDetails->id` ='%%" . $this->getFieldFormat( $filterFieldDetails->value ) . "%%'";
226		- // $all_values[] = $filterFieldDetails->value;
227		- // if ( $filterFieldChecker < $filterFieldCount ) {
228		- // $groupedCondition .= " AND ";
229		- // }
230		- // }
	227	+ // $isRecount = true;
	228	+ // $filterFieldCount = count( $filter['field'] );
	229	+ // $filterFieldChecker = 0;
	230	+ // if ( $filterFieldCount > 0 ) {
	231	+ // $groupedCondition .= " HAVING ";
	232	+ // }
	233	+ // foreach ( $filter['field'] as $filterFieldKey => $filterFieldDetails ) {
	234	+ // $groupedCondition .= " `$filterFieldDetails->id` ='%%" . $this->getFieldFormat( $filterFieldDetails->value ) . "%%'";
	235	+ // $all_values[] = $filterFieldDetails->value;
	236	+ // if ( $filterFieldChecker < $filterFieldCount ) {
	237	+ // $groupedCondition .= " AND ";
	238	+ // }
	239	+ // }
231	240	// }
232	241
233	242	// if ( !empty( $filter['global'] ) && !empty( $globalFilterString ) && !empty( $globalFilterValues ) ) {
234		- // $isRecount = true;
235		- // if ( !empty( $filter['field'] ) ) {
236		- // $groupedCondition .= " AND (" . $globalFilterString . ") ";
237		- // } else {
238		- // $groupedCondition .= " HAVING $globalFilterString ";
239		- // }
240		- // $offset = 0;
241		- // $all_values = array_merge( $all_values, $globalFilterValues );
	243	+ // $isRecount = true;
	244	+ // if ( !empty( $filter['field'] ) ) {
	245	+ // $groupedCondition .= " AND (" . $globalFilterString . ") ";
	246	+ // } else {
	247	+ // $groupedCondition .= " HAVING $globalFilterString ";
	248	+ // }
	249	+ // $offset = 0;
	250	+ // $all_values = array_merge( $all_values, $globalFilterValues );
242	251	// }
243	252
244	253	// if ( !empty( $dateBetweenFilter ) && !empty( $dateBetweenFilter->start_date ) && !empty( $dateBetweenFilter->end_date ) ) {
245		- // if ( strpos( $groupedCondition, 'HAVING' ) !== false ) {
246		- // $groupedCondition .= " AND `__created_at` BETWEEN '" . $dateBetweenFilter->start_date . "' AND '" . $dateBetweenFilter->end_date . "' ";
247		- // } else {
248		- // $groupedCondition .= " HAVING `__created_at` BETWEEN '" . $dateBetweenFilter->start_date . "' AND '" . $dateBetweenFilter->end_date . "' ";
249		- // }
	254	+ // if ( strpos( $groupedCondition, 'HAVING' ) !== false ) {
	255	+ // $groupedCondition .= " AND `__created_at` BETWEEN '" . $dateBetweenFilter->start_date . "' AND '" . $dateBetweenFilter->end_date . "' ";
	256	+ // } else {
	257	+ // $groupedCondition .= " HAVING `__created_at` BETWEEN '" . $dateBetweenFilter->start_date . "' AND '" . $dateBetweenFilter->end_date . "' ";
	258	+ // }
250	259	// }
251	260
252	261	$sqlQryByFldCondtion = $this->sqlQryGenerateByFldCondition($fieldConditions);
253	262
		@@ -265,9 +274,10 @@
265	274	'isFldCondition' => $isFldCondition,
266	275	];
267	276	}
268	277
269		- public function orderCondition($formFieldsNames, $sortBy) {
	278	+ public function orderCondition($formFieldsNames, $sortBy)
	279	+ {
270	280	$orderCondition = null;
271	281	if (!empty($sortBy)) {
272	282	$sortableFieldCount = count($sortBy);
273	283	$sortableFieldChecker = 0;
		@@ -296,9 +306,10 @@
296	306	$orderCondition .= empty($orderCondition) ? ' ORDER BY `bitforms_form_entry_id` DESC ' : ',`bitforms_form_entry_id` DESC ';
297	307	return $orderCondition;
298	308	}
299	309
300		- public function isEntryMetaExist($conditions) {
	310	+ public function isEntryMetaExist($conditions)
	311	+ {
301	312	$existMetaData = $this->get(
302	313	[
303	314	'meta_key',
304	315	'meta_value',
		@@ -310,9 +321,10 @@
310	321	}
311	322	return false;
312	323	}
313	324
314		- public function getEntryMeta($formFields, $entries, $limit = null, $offset = null, $filter = null, $sortBy = null, $fieldConditions = null, $dateBetweenFilter = null) {
	325	+ public function getEntryMeta($formFields, $entries, $limit = null, $offset = null, $filter = null, $sortBy = null, $fieldConditions = null, $dateBetweenFilter = null)
	326	+ {
315	327	$entry_table = $this->app_db->prefix . 'bitforms_form_entries';
316	328	$fieldCount = count($formFields);
317	329	$getSelectedMetaFldValue = $this->selectedEntryMeta($formFields, $fieldCount);
318	330
		@@ -383,144 +395,171 @@
383	395	];
384	396	return $resultedEntries;
385	397	}
386	398
387		- private function csvInjectionPrevent($value) {
388		- $formula = ['=', '-', '+', '@', "\t", "\r"];
389		- $valueFilter = preg_replace('/[\]["]/i', '', $value);
390		- if (\in_array(substr($value, 0, 1), $formula, true)) {
391		- $valueFilter = "'" . trim($valueFilter);
392		- }
	399	+ public function getSingleEntryMeta($formFields, $entryId)
	400	+ {
	401	+ $entry_table = $this->app_db->prefix . 'bitforms_form_entries';
	402	+ $fieldCount = count($formFields);
	403	+ $getSelectedMetaFldValue = $this->selectedEntryMeta($formFields, $fieldCount);
	404	+ $selectedMeta = $getSelectedMetaFldValue['selected_meta'];
	405	+ $formFieldsNames = $getSelectedMetaFldValue['form_fields_names'];
	406	+ $all_values = $getSelectedMetaFldValue['all_values'];
	407	+ $condition['bitforms_form_entry_id'] = [$entryId];
	408	+ $group = $this->groupedCondition($condition, $all_values, []);
	409	+ $groupedCondition = $group['groupedCondition'];
	410	+ $all_values = $group['all_values'];
	411	+ $orderCondition = $this->orderCondition($formFieldsNames, null);
	412	+ $sql = "SELECT $selectedMeta FROM `$this->table_name` em";
	413	+ $sql .= " INNER JOIN $entry_table e on e.id = em.bitforms_form_entry_id ";
	414	+ $sql .= $groupedCondition . $orderCondition;
	415	+ $result = $this->execute($sql, $all_values)->getResult();
393	416
394		- return $valueFilter;
	417	+ if (is_wp_error($result)) {
	418	+ return [];
395	419	}
	420	+ return $result;
	421	+ }
396	422
397		- public function getExportEntry($formFields, $entries, $formId, $fieldLabels, $limit = null, $sortBy = null, $sortByField = null) {
398		- $entry_table = $this->app_db->prefix . 'bitforms_form_entries';
399		- $selectedEntryMeta = '`bitforms_form_entry_id` as entry_id,';
400		- $selectedEntryMeta .= "e.user_id as '__user_id',";
401		- $selectedEntryMeta .= "e.status as '__entry_status',";
402		- $selectedEntryMeta .= "e.user_ip as '__user_ip',";
403		- $selectedEntryMeta .= "e.user_location as '__user_location',";
404		- $selectedEntryMeta .= "e.user_device as '__user_device',";
405		- $selectedEntryMeta .= "e.referer as '__referer',";
406		- $selectedEntryMeta .= "e.created_at as '__created_at',";
407		- $selectedEntryMeta .= "e.updated_at as '__updated_at',";
408		- $metaChecker = 0;
	423	+ private function csvInjectionPrevent($value)
	424	+ {
	425	+ $formula = ['=', '-', '+', '@', "\t", "\r"];
	426	+ $valueFilter = preg_replace('/[\]["]/i', '', $value);
	427	+ if (\in_array(substr($value, 0, 1), $formula, true)) {
	428	+ $valueFilter = "'" . trim($valueFilter);
	429	+ }
409	430
410		- $entryInfo = ['__user_id', '__user_ip', /* '__user_location', */'__user_device',
411		- '__referer', '__created_at', '__updated_at'];
412		- $all_values = [];
413		- if ([] === $formFields) {
414		- $data = [
415		- 'count' => 0,
416		- 'entries' => [],
417		- ];
418		- wp_send_json_success($data, 200);
	431	+ return $valueFilter;
	432	+ }
	433	+
	434	+ public function getExportEntry($formFields, $entries, $formId, $fieldLabels, $limit = null, $sortBy = null, $sortByField = null)
	435	+ {
	436	+ $entry_table = $this->app_db->prefix . 'bitforms_form_entries';
	437	+ $selectedEntryMeta = '`bitforms_form_entry_id` as entry_id,';
	438	+ $selectedEntryMeta .= "e.user_id as '__user_id',";
	439	+ $selectedEntryMeta .= "e.status as '__entry_status',";
	440	+ $selectedEntryMeta .= "e.user_ip as '__user_ip',";
	441	+ $selectedEntryMeta .= "e.user_location as '__user_location',";
	442	+ $selectedEntryMeta .= "e.user_device as '__user_device',";
	443	+ $selectedEntryMeta .= "e.referer as '__referer',";
	444	+ $selectedEntryMeta .= "e.created_at as '__created_at',";
	445	+ $selectedEntryMeta .= "e.updated_at as '__updated_at',";
	446	+ $metaChecker = 0;
	447	+
	448	+ $entryInfo = ['__user_id', '__user_ip', /* '__user_location', */'__user_device',
	449	+ '__referer', '__created_at', '__updated_at'];
	450	+ $all_values = [];
	451	+ if ([] === $formFields) {
	452	+ $data = [
	453	+ 'count' => 0,
	454	+ 'entries' => [],
	455	+ ];
	456	+ wp_send_json_success($data, 200);
	457	+ }
	458	+ $fieldCount = count($formFields) - count(array_intersect($formFields, $entryInfo));
	459	+ $formFieldsNames = [];
	460	+ foreach ($formFields as $fldKey) {
	461	+ $formFieldsNames[] = $fldKey;
	462	+ if (in_array($fldKey, $entryInfo)) {
	463	+ continue;
419	464	}
420		- $fieldCount = count($formFields) - count(array_intersect($formFields, $entryInfo));
421		- $formFieldsNames = [];
422		- foreach ($formFields as $fldKey) {
423		- $formFieldsNames[] = $fldKey;
424		- if (in_array($fldKey, $entryInfo)) {
425		- continue;
426		- }
427		- $fieldFormat = $this->getFieldFormat($fldKey);
428		- $selectedEntryMeta .= "GROUP_CONCAT(
	465	+ $fieldFormat = $this->getFieldFormat($fldKey);
	466	+ $selectedEntryMeta .= "GROUP_CONCAT(
429	467	CASE
430	468	`meta_key`
431	469	WHEN '$fieldFormat' THEN `meta_value`
432	470	END
433	471	) AS '$fieldFormat'";
434		- $metaChecker += 1;
435		- $all_values[] = $fldKey;
436		- $all_values[] = $fldKey;
437		- if ($metaChecker < $fieldCount) {
438		- $selectedEntryMeta .= ',';
439		- }
	472	+ $metaChecker += 1;
	473	+ $all_values[] = $fldKey;
	474	+ $all_values[] = $fldKey;
	475	+ if ($metaChecker < $fieldCount) {
	476	+ $selectedEntryMeta .= ',';
440	477	}
441		- $entryIDs = [];
442		- foreach ($entries as $entryDetail) {
443		- $entryIDs[] = $entryDetail->id;
444		- }
445		- if (empty($entryIDs)) {
446		- return [
447		- 'count' => 0,
448		- 'entries' => [],
449		- ];
450		- }
451		- $condition['bitforms_form_entry_id'] = $entryIDs;
452		- $formattedCondition = $this->getFormatedCondition($condition);
453		- $groupedCondition = null;
454		- if ($formattedCondition) {
455		- $groupedCondition = $formattedCondition['conditions'] . ' GROUP BY
	478	+ }
	479	+ $entryIDs = [];
	480	+ foreach ($entries as $entryDetail) {
	481	+ $entryIDs[] = $entryDetail->id;
	482	+ }
	483	+ if (empty($entryIDs)) {
	484	+ return [
	485	+ 'count' => 0,
	486	+ 'entries' => [],
	487	+ ];
	488	+ }
	489	+ $condition['bitforms_form_entry_id'] = $entryIDs;
	490	+ $formattedCondition = $this->getFormatedCondition($condition);
	491	+ $groupedCondition = null;
	492	+ if ($formattedCondition) {
	493	+ $groupedCondition = $formattedCondition['conditions'] . ' GROUP BY
456	494	`bitforms_form_entry_id` ';
457		- $all_values = array_merge($all_values, $formattedCondition['values']);
458		- }
459		- $order = \is_null($sortBy) ? 'DESC ' : "$sortBy";
460		- $orderField = \is_null($sortByField) ? 'bitforms_form_entry_id' : "`$sortByField`";
	495	+ $all_values = array_merge($all_values, $formattedCondition['values']);
	496	+ }
	497	+ $order = 'DESC' === $sortBy ? 'DESC ' : 'ASC ';
	498	+ $orderField = \is_null($sortByField) ? 'bitforms_form_entry_id' : "`$sortByField`";
461	499
462		- $orderCondition = "ORDER BY $orderField $order ";
463		- if (!\is_null($limit)) {
464		- $limitInt = \intval($limit);
465		- $limit = " LIMIT $limitInt ";
466		- }
467		- $sql = "SELECT $selectedEntryMeta FROM `$this->table_name` em";
468		- $sql .= " INNER JOIN $entry_table e on e.id = em.bitforms_form_entry_id ";
469		- $sql .= $groupedCondition . $orderCondition . $limit;
	500	+ $orderCondition = "ORDER BY $orderField $order ";
	501	+ if (!\is_null($limit)) {
	502	+ $limitInt = \intval($limit);
	503	+ $limit = " LIMIT $limitInt ";
	504	+ }
	505	+ $sql = "SELECT $selectedEntryMeta FROM `$this->table_name` em";
	506	+ $sql .= " INNER JOIN $entry_table e on e.id = em.bitforms_form_entry_id ";
	507	+ $sql .= $groupedCondition . $orderCondition . $limit;
470	508
471		- $result = $this->execute($sql, $all_values)->getResult();
472		- $allData = [];
473		- $entry_id = 'entry_id';
474		- $users = get_users(['fields' => ['ID', 'display_name']]);
475		- $userNames = [];
476		- foreach ($users as $key => $value) {
477		- $userNames[$value->ID] = $value->display_name;
478		- }
479		- foreach ($result as $key => $value) {
480		- foreach ($formFieldsNames as $formFieldName) {
481		- $allData[$key]['entry_id'] = preg_replace('/[\]["]/i', '', $value->$entry_id);
482		- if ('__user_id' === $formFieldName && intval($value->$formFieldName) > 0) {
483		- $allData[$key][$formFieldName] = $userNames[$value->$formFieldName];
484		- } elseif ('__user_ip' === $formFieldName) {
485		- $allData[$key][$formFieldName] = long2ip($value->$formFieldName);
486		- } else {
487		- $allData[$key][$formFieldName] = preg_replace('/[\]["]/i', '', $value->$formFieldName);
488		- }
	509	+ $result = $this->execute($sql, $all_values)->getResult();
	510	+ $allData = [];
	511	+ $entry_id = 'entry_id';
	512	+ $users = get_users(['fields' => ['ID', 'display_name']]);
	513	+ $userNames = [];
	514	+ foreach ($users as $key => $value) {
	515	+ $userNames[$value->ID] = $value->display_name;
	516	+ }
	517	+ foreach ($result as $key => $value) {
	518	+ foreach ($formFieldsNames as $formFieldName) {
	519	+ $allData[$key]['entry_id'] = preg_replace('/[\]["]/i', '', $value->$entry_id);
	520	+ if ('__user_id' === $formFieldName && intval($value->$formFieldName) > 0) {
	521	+ $allData[$key][$formFieldName] = $userNames[$value->$formFieldName];
	522	+ } elseif ('__user_ip' === $formFieldName) {
	523	+ $allData[$key][$formFieldName] = long2ip((int)$value->$formFieldName);
	524	+ } else {
	525	+ $allData[$key][$formFieldName] = preg_replace('/[\]["]/i', '', $value->$formFieldName);
489	526	}
490	527	}
	528	+ }
491	529
492		- if (is_wp_error($result)) {
493		- wp_send_json_error('Internal server error', 500);
494		- } else {
495		- foreach ($fieldLabels as $field) {
496		- foreach ($allData as $index => $entry) {
497		- if (array_key_exists($field['key'], $entry) && 'file-up' === $field['type']) {
498		- $key = $field['key'];
499		- if (empty($entry[$key])) {
500		- continue;
	530	+ if (is_wp_error($result)) {
	531	+ wp_send_json_error('Internal server error', 500);
	532	+ } else {
	533	+ $downloadableFieldType = ['file-up', 'signature', 'advanced-file-up'];
	534	+ foreach ($fieldLabels as $field) {
	535	+ foreach ($allData as $index => $entry) {
	536	+ if (array_key_exists($field['key'], $entry) && in_array($field['type'], $downloadableFieldType, true)) {
	537	+ $key = $field['key'];
	538	+ if (empty($entry[$key])) {
	539	+ continue;
	540	+ }
	541	+ $_upload_dir = FileHandler::getEntriesFileUploadDir($formId, $entry['entry_id']);
	542	+ $imageArray = explode(',', $entry[$key]);
	543	+ if (is_array($imageArray)) {
	544	+ $fileData = [];
	545	+ foreach ($imageArray as $file) {
	546	+ $path = "bitforms/bitforms-file/?formID=$formId&entryID=" . $entry['entry_id'] . "&fileID=$file";
	547	+ if (file_exists($_upload_dir . DIRECTORY_SEPARATOR . $file)) {
	548	+ $fileData[] = site_url($path, null);
	549	+ }
501	550	}
502		- $_upload_dir = BITFORMS_UPLOAD_DIR . DIRECTORY_SEPARATOR . $formId . DIRECTORY_SEPARATOR . $entry['entry_id'];
503		- if (is_array(explode(',', $entry[$key]))) {
504		- $fileData = [];
505		- foreach (explode(',', $entry[$key]) as $file) {
506		- $uploadedFile = explode('_', $file);
507		- $path = "bitforms/bitforms-file/?formID=$formId&entryID=" . $entry['entry_id'] . "&fileID=$uploadedFile[0]";
508		- if (file_exists($_upload_dir . DIRECTORY_SEPARATOR . $uploadedFile[0])) {
509		- $fileData[] = site_url($path, null);
510		- }
511		- }
512		- $allData[$index][$key] = implode(',', $fileData);
513		- } else {
514		- $uploadedFile = explode('_', $entry[$key]);
515		- $path = "bitforms/bitforms-file/?formID=$formId&entryID=" . $entry['entry_id'] . '&fileID=' . $uploadedFile[0];
516		- if (file_exists($_upload_dir . DIRECTORY_SEPARATOR . $uploadedFile[0])) {
517		- $allData[$index][$key] = site_url($path, null);
518		- }
	551	+ $allData[$index][$key] = implode(',', $fileData);
	552	+ } else {
	553	+ $uploadedFile = explode('_', $entry[$key]);
	554	+ $path = "bitforms/bitforms-file/?formID=$formId&entryID=" . $entry['entry_id'] . '&fileID=' . $uploadedFile[0];
	555	+ if (file_exists($_upload_dir . DIRECTORY_SEPARATOR . $uploadedFile[0])) {
	556	+ $allData[$index][$key] = site_url($path, null);
519	557	}
520	558	}
521	559	}
522	560	}
523		- wp_send_json_success($allData, 200);
524	561	}
	562	+ wp_send_json_success($allData, 200);
525	563	}
	564	+ }
526	565	}