← All changes | includes/Core/Integration/Pods/PodsHandler.php +77 -54 2.0 → V3.3.2 View file →

		@@ -14,13 +14,17 @@
14	14
15	15	/**
16	16	* Provide functionality for POD integration
17	17	*/
18		-class PodsHandler {
	18	+class PodsHandler
	19	+{
19	20	private $_formID;
20	21	private $_wpdb;
21	22
22		- public function __construct($integrationID, $fromID) {
	23	+ public const BIT_FORMS_FILE_TYPE = ['file-up', 'advanced-file-up', 'signature'];
	24	+
	25	+ public function __construct($integrationID, $fromID)
	26	+ {
23	27	$this->_formID = $fromID;
24	28
25	29	global $wpdb;
26	30	$this->_wpdb = $wpdb;
		@@ -30,9 +34,10 @@
30	34	* Helps to register ajax function's with wp
31	35	*
32	36	* @return null
33	37	*/
34		- private function smartTagMappingValue($fieldMap) {
	38	+ private function smartTagMappingValue($fieldMap)
	39	+ {
35	40	$specialTagFieldValue = [];
36	41	$data = SmartTags::getPostUserData(true);
37	42	$specialTagFields = SmartTags::smartTagFieldKeys();
38	43
		@@ -46,9 +51,10 @@
46	51	}
47	52	return $specialTagFieldValue;
48	53	}
49	54
50		- private function podMappingField($integrationDetails, $podField, $formFields, $fieldValues, $entryID, $postID) {
	55	+ private function podMappingField($integrationDetails, $podField, $fieldValues, $entryID, $postID)
	56	+ {
51	57	$string_types = [
52	58	'text',
53	59	'textarea',
54	60	'radio',
		@@ -67,42 +73,53 @@
67	73	'time',
68	74	'datetime',
69	75	'datetime-local',
70	76	'url',
	77	+ 'currency',
71	78	];
	79	+
	80	+ $fieldValues = IntegrationHandler::formattedRepeaterValue($fieldValues);
	81	+
72	82	$fileUploadHandle = new WpFileHandler($this->_formID);
73	83	$podData = [];
74	84	foreach ($integrationDetails->pod_map as $fieldPair) {
75		- foreach ($podField as $pod) {
76		- foreach ($formFields as $field) {
77		- if (!empty($fieldPair->podFormField) && !empty($fieldPair->formField)) {
78		- if ($fieldPair->formField === $field['key'] && in_array($pod['type'], $string_types) && !empty($fieldValues[$fieldPair->formField])) {
79		- $podData[$fieldPair->podFormField] = $fieldValues[$fieldPair->formField];
80		- } elseif ($fieldPair->formField === $field['key'] && 'decision-box' === $field['type'] && 'boolean' === $pod['type']) {
81		- if (1 === (int) $fieldValues[$fieldPair->formField] || 0 === (int) $fieldValues[$fieldPair->formField]) {
82		- $podData[$fieldPair->podFormField] = $fieldValues[$fieldPair->formField];
	85	+ if (!empty($fieldPair->podFormField) && !empty($fieldPair->formField)) {
	86	+ $pod = $podField[$fieldPair->podFormField];
	87	+ if (in_array($pod['type'], $string_types) && !empty($fieldValues[$fieldPair->formField])) {
	88	+ if (1 === $pod['is_repeatable'] && is_array($fieldValues[$fieldPair->formField])) {
	89	+ // $repeaterValues = call_user_func_array('array_merge', array_map('array_values', $fieldValues[$fieldPair->formField]));
	90	+ $podData[$fieldPair->podFormField] = $fieldValues[$fieldPair->formField];
	91	+ } else {
	92	+ $podData[$fieldPair->podFormField] = $fieldValues[$fieldPair->formField];
	93	+ }
	94	+ }
	95	+ // elseif (isset($field['mul'], $field) && in_array($pod['type'], $string_types) && 'file-up' !== $field['type']) {
	96	+ // if (true === $field['mul'] && 'multi' === $pod['pick_format_type'] && !empty($fieldValues[$fieldPair->formField])) {
	97	+ // $podData[$fieldPair->podFormField] = explode(',', $fieldValues[$fieldPair->formField]);
	98	+ // } elseif (false === $field['mul'] && 'multi' === $pod['pick_format_type'] && !empty($fieldValues[$fieldPair->formField])) {
	99	+ // $podData[$fieldPair->podFormField] = $fieldValues[$fieldPair->formField];
	100	+ // }
	101	+ // }
	102	+ elseif ('file' === $pod['type']) {
	103	+ if (!empty($fieldValues[$fieldPair->formField])) {
	104	+ if ('multi' === $pod['file_format_type']) {
	105	+ $attachmentId = $fileUploadHandle->multiFileMoveWpMedia($entryID, $fieldValues[$fieldPair->formField], $postID);
	106	+ if (!empty($attachmentId)) {
	107	+ update_post_meta($postID, $fieldPair->podFormField, $attachmentId);
	108	+ update_post_meta($postID, '_pods_' . $fieldPair->podFormField, wp_json_encode($attachmentId));
83	109	}
84		- } elseif ($fieldPair->formField === $field['key'] && isset($field['mul'], $field) && in_array($pod['type'], $string_types) && 'file-up' !== $field['type']) {
85		- if (true === $field['mul'] && 'multi' === $pod['pick_format_type'] && !empty($fieldValues[$fieldPair->formField])) {
86		- $podData[$fieldPair->podFormField] = explode(',', $fieldValues[$fieldPair->formField]);
87		- } elseif (false === $field['mul'] && 'multi' === $pod['pick_format_type'] && !empty($fieldValues[$fieldPair->formField])) {
88		- $podData[$fieldPair->podFormField] = $fieldValues[$fieldPair->formField];
	110	+ } elseif ('single' === $pod['file_format_type']) {
	111	+ $attachmentData = [];
	112	+ if (!is_array($fieldValues[$fieldPair->formField])) {
	113	+ $fileArr = explode('/', $fieldValues[$fieldPair->formField]);
	114	+ $attachmentData[] = $fileArr[count($fileArr) - 1];
	115	+ } else {
	116	+ $attachmentData = $fieldValues[$fieldPair->formField];
89	117	}
90		- } elseif ($fieldPair->formField === $field['key'] && 'file-up' === $field['type'] && 'file' === $pod['type']) {
91		- if (!empty($fieldValues[$fieldPair->formField])) {
92		- if ('multi' === $pod['file_format_type']) {
93		- $attachmentId = $fileUploadHandle->multiFileMoveWpMedia($entryID, $fieldValues[$fieldPair->formField], $postID);
94		- if (!empty($attachmentId)) {
95		- update_post_meta($postID, $fieldPair->podFormField, $attachmentId);
96		- update_post_meta($postID, '_pods_' . $fieldPair->podFormField, json_encode($attachmentId));
97		- }
98		- } elseif ('single' === $pod['file_format_type']) {
99		- $attachmentId = $fileUploadHandle->singleFileMoveWpMedia($entryID, $fieldValues[$fieldPair->formField], $postID);
100		- if (!empty($attachmentId)) {
101		- update_post_meta($postID, $fieldPair->podFormField, $attachmentId);
102		- update_post_meta($postID, '_pods_' . $fieldPair->podFormField, json_encode($attachmentId));
103		- }
104		- }
	118	+ $attachmentId = $fileUploadHandle->singleFileMoveWpMedia($entryID, $attachmentData, $postID);
	119	+ if (!empty($attachmentId)) {
	120	+ update_post_meta($postID, $fieldPair->podFormField, $attachmentId);
	121	+ update_post_meta($postID, '_pods_' . $fieldPair->podFormField, wp_json_encode($attachmentId));
105	122	}
106	123	}
107	124	}
108	125	}
		@@ -110,9 +127,12 @@
110	127	}
111	128	return $podData;
112	129	}
113	130
114		- private function postFieldMapping($fieldData, $post_map, $formFields, $fieldValues, $postID, $entryID) {
	131	+ // formatted field values for repeater field
	132	+
	133	+ private function postFieldMapping($fieldData, $post_map, $formFields, $fieldValues, $postID, $entryID)
	134	+ {
115	135	$uploadFeatureImg = new WpFileHandler($this->_formID);
116	136	foreach ($post_map as $fieldPair) {
117	137	foreach ($formFields as $field) {
118	138	if (!empty($fieldPair->postFormField) && !empty($fieldPair->formField)) {
		@@ -117,9 +137,9 @@
117	137	foreach ($formFields as $field) {
118	138	if (!empty($fieldPair->postFormField) && !empty($fieldPair->formField)) {
119	139	if ($fieldPair->formField === $field['key'] && '_thumbnail_id' !== $fieldPair->postFormField) {
120	140	$fieldData[$fieldPair->postFormField] = $fieldValues[$fieldPair->formField];
121		- } elseif ($fieldPair->formField === $field['key'] && 'file-up' === $field['type'] && '_thumbnail_id' === $fieldPair->postFormField && !empty($fieldValues[$field['key']])) {
	141	+ } elseif ($fieldPair->formField === $field['key'] && in_array($field['type'], self::BIT_FORMS_FILE_TYPE) && '_thumbnail_id' === $fieldPair->postFormField && !empty($fieldValues[$field['key']])) {
122	142	if (!empty($fieldValues[$field['key']])) {
123	143	$uploadFeatureImg->uploadFeatureImg($fieldValues[$field['key']], $entryID, $postID);
124	144	}
125	145	}
		@@ -128,14 +148,15 @@
128	148	}
129	149	return $fieldData;
130	150	}
131	151
132		- public function execute(IntegrationHandler $integrationHandler, $integrationData, $fieldValues, $entryID, $logID) {
	152	+ public function execute(IntegrationHandler $integrationHandler, $integrationData, $fieldValues, $entryID, $logID)
	153	+ {
133	154	$integrationDetails = is_string($integrationData->integration_details) ? json_decode($integrationData->integration_details) : $integrationData->integration_details;
134	155	$fieldData = [];
135	156	$taxonomy = new WpFileHandler($integrationData->form_id);
136	157
137		- $formManger = new FormManager($integrationData->form_id);
	158	+ $formManger = FormManager::getInstance($integrationData->form_id);
138	159	$formFields = $formManger->getFields();
139	160	$allFields = pods($integrationDetails->post_type);
140	161	$podField = [];
141	162
		@@ -140,15 +161,19 @@
140	161	$podField = [];
141	162
142	163	foreach ($allFields->fields as $key => $field) {
143	164	$podField[$key]['type'] = $field['type'];
144		- $podField[$key]['pick_format_type'] = $field['options']['pick_format_type'];
145		- $podField[$key]['file_format_type'] = $field['options']['file_format_type'];
	165	+ // $podField[$key]['pick_format_type'] = $field['options']['pick_format_type'];
	166	+ // $podField[$key]['file_format_type'] = $field['options']['file_format_type'];
	167	+ $podField[$key]['pick_format_type'] = $field['pick_format_type'];
	168	+ $podField[$key]['file_format_type'] = $field['file_format_type'];
	169	+ $podField[$key]['is_repeatable'] = (int) $field['repeatable'];
146	170	}
147	171
148	172	$fieldData['comment_status'] = isset($integrationDetails->comment_status) ? $integrationDetails->comment_status : '';
149	173	$fieldData['post_status'] = isset($integrationDetails->post_status) ? $integrationDetails->post_status : '';
150	174	$fieldData['post_type'] = isset($integrationDetails->post_type) ? $integrationDetails->post_type : '';
	175	+
151	176	if (isset($integrationDetails->post_author) && 'logged_in_user' !== $integrationDetails->post_author) {
152	177	$fieldData['post_author'] = $integrationDetails->post_author;
153	178	} else {
154	179	$fieldData['post_author'] = get_current_user_id();
		@@ -154,10 +179,14 @@
154	179	$fieldData['post_author'] = get_current_user_id();
155	180	}
156	181
157	182	$exist_id = $fieldData['post_type'] . '_' . $entryID;
158		- $sql = "SELECT * FROM `{$this->_wpdb->prefix}bitforms_form_entrymeta` WHERE `meta_key`='$exist_id' ";
159		- $exist_post_id = $this->_wpdb->get_results($sql);
	183	+ $exist_post_id = $this->_wpdb->get_results(
	184	+ $this->_wpdb->prepare(
	185	+ "SELECT * FROM `{$this->_wpdb->prefix}bitforms_form_entrymeta` WHERE `meta_key`=%s",
	186	+ $exist_id
	187	+ )
	188	+ );
160	189	$taxanomyData = $taxonomy->taxonomyData($formFields, $fieldValues);
161	190
162	191	if ([] === $exist_post_id) {
163	192	$post_id = wp_insert_post(['post_title' => 'null', 'post_content' => 'null']);
		@@ -173,8 +202,9 @@
173	202	wp_set_post_terms($post_id, $taxanomy['value'], $taxanomy['term'], false);
174	203	}
175	204	}
176	205
	206	+ // Form entry meta insert; meta_key/meta_value required to map dynamic field data to Pods integration record.
177	207	$this->_wpdb->insert(
178	208	"{$this->_wpdb->prefix}bitforms_form_entrymeta",
179	209	[
180	210	'meta_key' => $fieldData['post_type'] . '_' . $entryID,
		@@ -184,19 +214,11 @@
184	214	);
185	215
186	216	$smartTagValue = $this->smartTagMappingValue($integrationDetails->pod_map);
187	217	$updatedPodValues = $fieldValues + $smartTagValue;
188		-
189		- $podData = $this->podMappingField($integrationDetails, $podField, $formFields, $updatedPodValues, $entryID, $post_id);
	218	+ $podData = $this->podMappingField($integrationDetails, $podField, $updatedPodValues, $entryID, $post_id);
190	219	foreach ($podData as $key => $data) {
191		- if (is_array($data)) {
192		- $count = count($data);
193		- for ($i = 0; $i < $count; $i++) {
194		- add_post_meta($post_id, $key, $data[$i]);
195		- }
196		- } else {
197		- add_post_meta($post_id, $key, $data);
198		- }
	220	+ add_post_meta($post_id, $key, $data);
199	221	}
200	222	} else {
201	223	if (!empty($taxanomyData)) {
202	224	foreach ($taxanomyData as $taxanomy) {
		@@ -202,9 +224,11 @@
202	224	foreach ($taxanomyData as $taxanomy) {
203	225	wp_set_post_terms($exist_post_id[0]->meta_value, $taxanomy['value'], $taxanomy['term'], false);
204	226	}
205	227	}
206		- $podData = $this->podMappingField($integrationDetails, $podField, $formFields, $fieldValues, $entryID, $exist_post_id[0]->meta_value);
	228	+
	229	+ $podData = $this->podMappingField($integrationDetails, $podField, $fieldValues, $entryID, $exist_post_id[0]->meta_value);
	230	+
207	231	foreach ($podData as $key => $data) {
208	232	if (is_array($data)) {
209	233	$count = count($data);
210	234	for ($i = 0; $i < $count; $i++) {
		@@ -209,15 +233,14 @@
209	233	$count = count($data);
210	234	for ($i = 0; $i < $count; $i++) {
211	235	delete_post_meta($exist_post_id[0]->meta_value, $key);
212	236	}
213		- for ($i = 0; $i < $count; $i++) {
214		- add_post_meta($exist_post_id[0]->meta_value, $key, $data[$i]);
215		- }
	237	+ add_post_meta($exist_post_id[0]->meta_value, $key, $data);
216	238	} else {
217	239	update_post_meta($exist_post_id[0]->meta_value, $key, $data);
218	240	}
219	241	}
	242	+
220	243	$updateData = $this->postFieldMapping($fieldData, $integrationDetails->post_map, $formFields, $fieldValues, $exist_post_id[0]->meta_value, $entryID);
221	244	$updateData['ID'] = $exist_post_id[0]->meta_value;
222	245	wp_update_post($updateData, true);
223	246	}