PluginProbe
Bit Form – Contact Form, Payment Forms, Multi Step Forms, Calculator & Custom Form Builder / V3.0.3
Bit Form – Contact Form, Payment Forms, Multi Step Forms, Calculator & Custom Form Builder vV3.0.3
V-3.3.0 3.2.2 3.2.1 3.2.0 3.1.4 3.1.3 3.1.2 3.1.1 3.1.0 V3.0.3 V3.0.2 -3.0.1 V_3.0.0 1.1.1 1.1.8 1.2 1.3 1.4 1.4.18 1.5.2 1.9 2.0 2.10.0 2.10.1 2.10.2 All 137 releases
bit-form / includes / Admin / Form / AdminFormHandler.php

AdminFormHandler.php in Bit Form – Contact Form, Payment Forms, Multi Step Forms, Calculator & Custom Form Builder V3.0.3, at includes/Admin/Form/AdminFormHandler.php

2,866 lines 106.7 KB
No matching file
Up and down to move Enter to open Esc to close
Raw Download Zip
1 <?php
2
3 /**
4 * Handle Form Create,Update,delete Operation
5 *
6 */
7
8 namespace BitCode\BitForm\Admin\Form;
9
10 use BitCode\BitForm\Admin\Form\Template\TemplateProvider;
11 use BitCode\BitForm\Core\Database\EmailTemplateModel;
12 use BitCode\BitForm\Core\Database\FormEntryLogModel;
13 use BitCode\BitForm\Core\Database\FormEntryMetaModel;
14 use BitCode\BitForm\Core\Database\FormEntryModel;
15 use BitCode\BitForm\Core\Database\FormModel;
16 use BitCode\BitForm\Core\Database\IntegrationModel;
17 use BitCode\BitForm\Core\Database\PdfTemplateModel;
18 use BitCode\BitForm\Core\Database\ReportsModel;
19 use BitCode\BitForm\Core\Database\SuccessMessageModel;
20 use BitCode\BitForm\Core\Database\WorkFlowModel;
21 use BitCode\BitForm\Core\Integration\IntegrationHandler;
22 use BitCode\BitForm\Core\Messages\EmailTemplateHandler;
23 use BitCode\BitForm\Core\Messages\PdfTemplateHandler;
24 use BitCode\BitForm\Core\Messages\SuccessMessageHandler;
25 use BitCode\BitForm\Core\Migration\MigrationHelper;
26 use BitCode\BitForm\Core\Util\FileHandler;
27 use BitCode\BitForm\Core\Util\FormDuplicateHelper;
28 use BitCode\BitForm\Core\Util\HttpHelper;
29 use BitCode\BitForm\Core\Util\IpTool;
30 use BitCode\BitForm\Core\Util\Log;
31 use BitCode\BitForm\Core\Util\Utilities;
32 use BitCode\BitForm\Core\WorkFlow\WorkFlow;
33 use BitCode\BitForm\Core\WorkFlow\WorkFlowHandler;
34 use WP_Error;
35
36 class AdminFormHandler
37 {
38 private static $formModel;
39 private static $ipTool;
40
41 public function __construct()
42 {
43 static::$formModel = new FormModel();
44 static::$ipTool = new IpTool();
45 }
46
47 public function getTemplate($Request, $post)
48 {
49 $templateName = null;
50 $newFormId = null;
51 if (isset($post->template)) {
52 $templateName = $post->template;
53 $newFormId = $post->newFormId;
54 }
55
56 $templateProvider = new TemplateProvider();
57 $form_content_raw = $templateProvider->getTemplate($templateName, $newFormId);
58 if (!$form_content_raw) {
59 return new WP_Error('template_empty', __('Template not found, by this name: ', 'bit-form') . $templateName);
60 } else {
61 return wp_json_encode(
62 [
63 'id' => 0,
64 'form_content' => $form_content_raw,
65 ]
66 );
67 }
68 }
69
70 public function saveStyleSheet($styles, $sheetName)
71 {
72 $this->createFormStylesDirIfNotExists();
73
74 if (
75 file_exists(BITFORMS_CONTENT_DIR . DIRECTORY_SEPARATOR . 'form-styles')
76 && wp_is_writable(BITFORMS_CONTENT_DIR . DIRECTORY_SEPARATOR . 'form-styles')
77 ) {
78 $filePath = BITFORMS_CONTENT_DIR . DIRECTORY_SEPARATOR . 'form-styles' . DIRECTORY_SEPARATOR . $sheetName;
79 return FileHandler::writeFile($filePath, $styles);
80 }
81 return false;
82 }
83
84 public function saveLayoutStyleSheet($layout, $sheetName, $lay_row_height = 43)
85 {
86 $md_width = 600;
87 $sm_width = 400;
88 $lg_styles = '';
89 $md_styles = '';
90 $sm_styles = '';
91 for ($i = 0; $i < count($layout->lg); $i++) {
92 $fld = $layout->lg[$i];
93
94 if ($fld->w < 10) {
95 $lay_row_height = 43;
96 } else {
97 $lay_row_height = 2;
98 }
99
100 $class = $fld->i;
101 $lg_g_r_s = $fld->y + 1;
102 $lg_g_c_s = $fld->x + 1;
103 $lg_g_r_e = 1 !== $fld->y ? $fld->h + ($fld->y + 1) : 1;
104 $lg_g_c_e = ($fld->x + 1) + $fld->w;
105 $lg_g_r_span = $lg_g_r_e - $lg_g_r_s;
106 $lg_g_c_span = $lg_g_c_e - $lg_g_c_s;
107 $lg_min_height = $fld->h * $lay_row_height . 'px;';
108
109 $lg_styles .= ".$class { grid-area: $lg_g_r_s / $lg_g_c_s / $lg_g_r_e / $lg_g_c_e ; -ms-grid-row: $lg_g_r_s; -ms-grid-row-span: $lg_g_r_span; -ms-grid-column: $lg_g_c_s; -ms-grid-column-span: $lg_g_c_span; min-height: $lg_min_height; }";
110
111 $fld = $layout->md[$i];
112
113 $class = $fld->i;
114 $md_g_r_s = $fld->y + 1;
115 $md_g_c_s = $fld->x + 1;
116 $md_g_r_e = 1 !== $fld->y ? $fld->h + ($fld->y + 1) : 1;
117 $md_g_c_e = ($fld->x + 1) + $fld->w;
118 $md_g_r_span = $lg_g_r_e - $md_g_r_s;
119 $md_g_c_span = $lg_g_c_e - $md_g_c_s;
120 $md_min_height = $fld->h * $lay_row_height . 'px;';
121
122 $md_styles .= ".$class { grid-area: $md_g_r_s / $md_g_c_s / $md_g_r_e / $md_g_c_e ; -ms-grid-row: $md_g_r_s; -ms-grid-row-span: $md_g_r_span; -ms-grid-column: $md_g_c_s; -ms-grid-column-span: $md_g_c_span; min-height: $md_min_height; }";
123
124 $fld = $layout->sm[$i];
125
126 $class = $fld->i;
127 $sm_g_r_s = $fld->y + 1;
128 $sm_g_c_s = $fld->x + 1;
129 $sm_g_r_e = 1 !== $fld->y ? $fld->h + ($fld->y + 1) : 1;
130 $sm_g_c_e = ($fld->x + 1) + $fld->w;
131 $sm_g_r_span = $sm_g_r_e - $sm_g_r_s;
132 $sm_g_c_span = $sm_g_c_e - $sm_g_c_s;
133 $sm_min_height = $fld->h * $lay_row_height . 'px;';
134
135 $sm_styles .= ".$class { grid-area: $sm_g_r_s / $sm_g_c_s / $sm_g_r_e / $sm_g_c_e ; -ms-grid-row: $sm_g_r_s; -ms-grid-row-span: $sm_g_r_span; -ms-grid-column: $sm_g_c_s; -ms-grid-column-span: $sm_g_c_span; min-height: $sm_min_height; }";
136 }
137 $formStyle = "._frm-g{
138 display: grid;
139 display: -ms-grid;
140 grid-template-columns: repeat( 6 , minmax( 30px , 1fr ));
141 -ms-grid-columns: minmax( 30px , 1fr ) minmax( 30px , 1fr ) minmax( 30px , 1fr ) minmax( 30px , 1fr ) minmax( 30px , 1fr ) minmax( 30px , 1fr );
142 }
143 {$lg_styles}
144 @media only screen and (max-width:{$md_width}px) {
145 ._frm-g {grid-template-columns: repeat( 4 , minmax( 30px , 1fr ));-ms-grid-columns: minmax( 30px , 1fr ) minmax( 30px , 1fr ) minmax( 30px , 1fr ) minmax( 30px , 1fr );}
146 {$md_styles}
147 }
148 @media only screen and (max-width:{$sm_width}px) {
149 ._frm-g {grid-template-columns: repeat( 2 , minmax( 30px , 1fr ));-ms-grid-columns: minmax( 30px , 1fr ) minmax( 30px , 1fr );}
150 {$sm_styles}
151 }";
152
153 $this->createFormStylesDirIfNotExists();
154
155 if (
156 file_exists(BITFORMS_CONTENT_DIR . DIRECTORY_SEPARATOR . 'form-styles')
157 && wp_is_writable(BITFORMS_CONTENT_DIR . DIRECTORY_SEPARATOR . 'form-styles')
158 ) {
159 $filePath = BITFORMS_CONTENT_DIR . DIRECTORY_SEPARATOR . 'form-styles' . DIRECTORY_SEPARATOR . $sheetName;
160 return FileHandler::writeFile($filePath, $formStyle);
161 }
162 return false;
163 }
164
165 public function createFormStylesDirIfNotExists()
166 {
167 if (!file_exists(BITFORMS_UPLOAD_DIR)) {
168 wp_mkdir_p(BITFORMS_UPLOAD_DIR);
169 }
170 if (!file_exists(BITFORMS_CONTENT_DIR . DIRECTORY_SEPARATOR . 'form-styles')) {
171 wp_mkdir_p(BITFORMS_CONTENT_DIR . DIRECTORY_SEPARATOR . 'form-styles');
172 }
173 }
174
175 private function pdfFontDownload($fontName)
176 {
177 if (class_exists('\BitCode\BitFormPro\Admin\AppSetting\Pdf')) {
178 \BitCode\BitFormPro\Admin\AppSetting\Pdf::getInstance()->fontsDownload($fontName);
179 }
180 return false;
181 }
182
183 public function createNewForm($Request, $post)
184 {
185 // wp_send_json_success($post);
186 // exit;
187 if (!isset($post->form_id) || '' === $post->form_id) {
188 return new WP_Error('empty_form', __('Error Occurred, Please Reload', 'bit-form'));
189 }
190
191 $formManager = new AdminFormManager($post->form_id);
192 if ($formManager->isExist()) {
193 return new WP_Error('empty_form', __('Error Occurred, Please Reload', 'bit-form'));
194 }
195
196 if (isset($post->formStyle) && $post->formStyle) {
197 $sheetName = 'bitform-' . $post->form_id . '.css';
198 $this->saveStyleSheet($post->formStyle, $sheetName);
199 }
200
201 if (isset($post->layoutChanged) && $post->layoutChanged) {
202 $sheetName = 'bitform-layout-' . $post->form_id . '.css';
203 $rowHeight = (int) $post->rowHeight;
204 $this->saveLayoutStyleSheet($post->layout, $sheetName, $rowHeight);
205 }
206
207 $fields = wp_unslash($post->fields);
208 $fields = Helpers::replaceFieldsDefaultErrorMsg($fields);
209 // $fields = $post->fields;
210 $layout = wp_unslash($post->layout);
211 $nestedLayout = isset($post->nestedLayouts) ? wp_unslash($post->nestedLayouts) : (object) [];
212 $formInfo = wp_unslash($post->formInfo);
213 $form_name = wp_unslash($post->form_name);
214 $form_name = strlen($form_name) > 50 ? substr($form_name, 0, 50) : $form_name;
215 $formSettings = (object) wp_unslash($post->formSettings);
216 $atomic_class_map = isset($post->atomicClassMap) ? wp_unslash($post->atomicClassMap) : [];
217 $breakpointSize = wp_unslash($post->breakpointSize);
218 $style = $post->style;
219 $themeVars = $post->themeVars;
220 $themeColors = $post->themeColors;
221 $staticStyles = $post->staticStyles;
222 $workFlows = wp_unslash($post->workFlows);
223 $additional = wp_unslash($post->additional);
224 $reports = !empty($post->reports) ? $post->reports : (object) [];
225 $builderSettings = (object) isset($post->builderSettings) ? wp_unslash($post->builderSettings) : [];
226
227 $mailTem = $formSettings->mailTem;
228 $pdfTem = $formSettings->pdfTem;
229 $integrations = $formSettings->integrations;
230 $formPermissions = $formSettings->formPermissions;
231
232 $user_details = static::$ipTool->getUserDetail();
233 if (empty($fields) || empty($layout)) {
234 return new WP_Error(
235 'empty_form',
236 __('Can not save empty form.', 'bit-form')
237 );
238 }
239 if (strlen($form_name) > 50) {
240 return new WP_Error(
241 'empty_form',
242 __('Form Name Should Be Within 50 Characters', 'bit-form')
243 );
244 }
245 $form_content = [
246 'fields' => $fields,
247 'layout' => $layout,
248 'nestedLayout' => $nestedLayout,
249 'formInfo' => $formInfo,
250 ];
251
252 /* if (!empty($formSettings->submitBtn)) {
253 $form_content = array_merge($form_content, array('buttons' => $formSettings->submitBtn));
254 } */
255 if (!empty($formSettings->theme)) {
256 $form_content = array_merge($form_content, ['theme' => $formSettings->theme]);
257 }
258
259 if (!empty($formSettings->formPermissions)) {
260 $form_content = array_merge($form_content, ['formPermissions' => $formSettings->formPermissions]);
261 }
262
263 if (!empty($additional)) {
264 $form_content = array_merge($form_content, ['additional' => $additional]);
265 }
266 if (!empty($workFlows)) {
267 $workflows = is_string($workFlows) ? json_decode($workFlows) : $workFlows;
268 $workFlowExist = [];
269 foreach ($workflows as $index => $workFlow) {
270 if (in_array($workFlow->action_type, ['always', 'onload'])) {
271 $workFlowExist['onload'] = true;
272 }
273 if ('oninput' === $workFlow->action_type || ('always' === $workFlow->action_type && 'cond' === $workFlow->action_behaviour)) {
274 $workFlowExist['oninput'] = true;
275 }
276 }
277 $form_content = array_merge($form_content, ['workFlowExist' => $workFlowExist]);
278 }
279 $form_content = \wp_json_encode($form_content);
280
281 $builder_helper_state = (object) [
282 'style' => $style,
283 'staticStyles' => $staticStyles,
284 'breakpointSize' => $breakpointSize,
285 'themeVars' => $themeVars,
286 'themeColors' => $themeColors,
287 'builderSettings' => $builderSettings
288 ];
289 $atomic_class_map = \wp_json_encode($atomic_class_map);
290 $fdata = [
291 'id' => $post->form_id,
292 'form_content' => $form_content,
293 'builder_helper_state' => \wp_json_encode($builder_helper_state),
294 'atomic_class_map' => $atomic_class_map,
295 'generated_script_page_ids' => \wp_json_encode((object) []),
296 'user_id' => $user_details['id'],
297 'user_ip' => $user_details['ip'],
298 'user_device' => $user_details['device'],
299 'status' => 1,
300 'form_name' => $form_name,
301 'created_at' => $user_details['time'],
302 'updated_at' => $user_details['time'],
303 ];
304
305 $save_status = static::$formModel->insert($fdata);
306
307 if (is_wp_error($save_status)) {
308 return $save_status;
309 } elseif (!$save_status) {
310 return false;
311 } else {
312 FileHandler::createIndexFile(BITFORMS_UPLOAD_DIR . "/$save_status");
313 $formID = $save_status;
314 do_action('bitform_admin_form_changed');
315 $integartionIDForWorkflow = [];
316 // Confiramtion Message [start]
317 if (!empty($formSettings->confirmation->type->successMsg)) {
318 $successMessages = $formSettings->confirmation->type->successMsg;
319 $successMessageHandler = new SuccessMessageHandler($formID, $user_details);
320 foreach ($successMessages as $messageKey => $messageDetail) {
321 $savedID = $successMessageHandler->saveMessage($messageDetail);
322 if ($savedID) {
323 $msgIdx = empty($messageDetail->id) ? $messageKey : wp_json_encode(['id' => $messageDetail->id]);
324 $integartionIDForWorkflow['successMsg'][$msgIdx] = $savedID;
325 $messageDetail->id = $savedID;
326 $style = $this->updateSuccessMessageClassName($style, $messageKey, $savedID);
327 $atomic_class_map = $this->updateSuccessMessageClassName($atomic_class_map, $messageKey, $savedID);
328 }
329 }
330 $builder_helper_state = (object) [
331 'style' => $style,
332 'breakpointSize' => $breakpointSize,
333 'themeVars' => $themeVars,
334 'themeColors' => $themeColors,
335 'builderSettings' => $builderSettings
336 ];
337 $update_status = static::$formModel->update(
338 [
339 'builder_helper_state' => \wp_json_encode($builder_helper_state),
340 'atomic_class_map' => $atomic_class_map,
341 ],
342 [
343 'id' => $formID,
344 ]
345 );
346 if (is_wp_error($update_status)) {
347 return $update_status;
348 }
349 unset($formSettings->confirmation->type->successMsg);
350 }
351 // return $formSettings;
352 // Confiramtion Message [end] */
353 // Email Template [start]
354 if (!empty($mailTem)) {
355 $emailTemplateHandler
356 = new EmailTemplateHandler($formID, $user_details);
357 foreach ($mailTem as $templateKey => $templateDetail) {
358 $savedID = $emailTemplateHandler->saveTemplate($templateDetail);
359 if ($savedID) {
360 $tempIdx = empty($templateDetail->id) ? $templateKey : wp_json_encode(['id' => $templateDetail->id]);
361 $integartionIDForWorkflow['mailNotify'][$tempIdx] = $savedID;
362 }
363 }
364 }
365 // Email Template [end] */
366
367 // PDF Template [start]
368 if (!empty($pdfTem)) {
369 $pdfTemplateHandler = new PdfTemplateHandler($formID);
370 $workFlowString = '';
371 if (!empty($workFlows)) {
372 $workFlowString = wp_json_encode($workFlows);
373 }
374 foreach ($pdfTem as $templateDetail) {
375 $savedID = $pdfTemplateHandler->save($templateDetail);
376
377 $pdfSetting = $templateDetail->setting;
378
379 if (isset($pdfSetting->font->name) && !empty($pdfSetting->font->name)) {
380 $this->pdfFontDownload($pdfSetting->font->name);
381 }
382 if (!empty($workFlowString)) {
383 $workFlowString = str_replace('"pdfId":"{\"id\":\"' . $templateDetail->id . '\"}"', '"pdfId":"{\"id\":\"' . $savedID . '\"}"', $workFlowString);
384 }
385 }
386 if (!empty($workFlowString) && !empty($workFlows)) {
387 $workFlows = json_decode($workFlowString);
388 }
389 }
390 // PDF Template [end] */
391 //Integration [start] */
392 $integrationHandler = new IntegrationHandler($formID, $user_details);
393 if (!empty($formSettings->confirmation->type)) {
394 $allIntegrations = $formSettings->confirmation->type;
395 foreach ($allIntegrations as $integrationType => $integrationGroup) {
396 foreach ($integrationGroup as $singleIntegrationKey => $singleIntegrationDetail) {
397 if (empty($singleIntegrationDetail->details)) {
398 $integrationName = $singleIntegrationDetail->title;
399 unset($singleIntegrationDetail->title, $singleIntegrationDetail->id);
400
401 $integrationDetails = !is_string($singleIntegrationDetail) ?
402 wp_json_encode($singleIntegrationDetail) : $singleIntegrationDetail;
403 } else {
404 $integrationName = $singleIntegrationDetail->title;
405 $integrationDetails = !is_string($singleIntegrationDetail->details) ?
406 wp_json_encode($singleIntegrationDetail->details) : $singleIntegrationDetail->details;
407 }
408 $savedID = $integrationHandler->saveIntegration($integrationName, $integrationType, $integrationDetails, 'form');
409 $integIdx = empty($singleIntegrationDetail->id) ? $savedID : wp_json_encode(['id' => $singleIntegrationDetail->id]);
410 $integartionIDForWorkflow[$integrationType][$integIdx] = $savedID;
411 }
412 }
413 }
414 if (isset($formSettings->formAbandonment)) {
415 $formAbandonment = $formSettings->formAbandonment;
416
417 $integrationName = 'formAbandonment';
418 $integrationType = 'formAbandonment';
419 $abandonmentIntegDetails = wp_json_encode($formAbandonment);
420 $integrationHandler->saveIntegration($integrationName, $integrationType, $abandonmentIntegDetails, 'formAbandonment');
421 }
422 if (!empty($integrations)) {
423 foreach ($integrations as $singleIntegrationKey => $singleIntegrationDetail) {
424 $integrationName = $singleIntegrationDetail->name;
425 unset($singleIntegrationDetail->name);
426 $integrationType = $singleIntegrationDetail->type;
427 unset($singleIntegrationDetail->type);
428 $singleIntegrationDetailID = empty($singleIntegrationDetail->id) ? null : $singleIntegrationDetail->id;
429 unset($singleIntegrationDetail->id);
430 if (empty($singleIntegrationDetail->details)) {
431 $integrationDetails = !is_string($singleIntegrationDetail) ?
432 wp_json_encode($singleIntegrationDetail) : $singleIntegrationDetail;
433 } else {
434 $integrationDetails = !is_string($singleIntegrationDetail->details) ?
435 wp_json_encode($singleIntegrationDetail->details) : $singleIntegrationDetail->details;
436 }
437 $savedID = $integrationHandler->saveIntegration($integrationName, $integrationType, $integrationDetails, 'form');
438 $integIdx = empty($singleIntegrationDetailID) ? $singleIntegrationKey : wp_json_encode(['id' => $singleIntegrationDetailID]);
439 $integartionIDForWorkflow['integ'][$integIdx] = $savedID;
440 }
441 }
442 //Integrations [end]
443 //wrokFlows [start]
444 if (!empty($workFlows)) {
445 $workFlowHandler = new WorkFlowHandler($formID, $user_details);
446
447 foreach ($workFlows as $index => $workFlow) {
448 $savedID = $workFlowHandler->saveworkFlow($workFlow, $integartionIDForWorkflow, $index);
449 $newData['workflow'] = 1;
450 }
451
452 // $workflowCount = count($workFlows);
453 // while ($workflowCount) {
454 // $workFlow = $workFlows[--$workflowCount];
455 // $savedID = $workFlowHandler->saveworkFlow($workFlow, $integartionIDForWorkflow);
456 // $newData['workflow'] = 1;
457 // }
458 }
459 //wrokFlows [end]
460 $details = [
461 'report_name' => __('All Entries', 'bit-form'),
462 'hiddenColumns' => ['__user_id', '__user_ip', '__referer', '__user_device', '__created_at', '__updated_at'],
463 'pageSize' => 10,
464 'sortBy' => [],
465 'filters' => [],
466 'globalFilter' => '',
467 'order' => []
468 ];
469 $defaultReport = [
470 'type' => 'table',
471 'category' => 'form',
472 'context' => $formID,
473 'details' => wp_json_encode($details),
474 'isDefault' => (bool) 1,
475 'user_id' => $user_details['id'],
476 'user_ip' => $user_details['ip'],
477 'user_device' => $user_details['device'],
478 'created_at' => $user_details['time'],
479 'updated_at' => $user_details['time'],
480 ];
481 $reportsModel = new ReportsModel();
482 $saveReportId = $reportsModel->insert($defaultReport);
483
484 // }
485 $updated_data = $this->getAForm(['id' => $save_status], null);
486 if (!is_wp_error($saveReportId) && isset($updated_data['form_content'])) {
487 $updated_data['form_content']['report_id'] = $saveReportId;
488 $updated_data['form_content']['is_default'] = 1;
489 }
490 $updated_data['message'] = __('Form Saved successfully', 'bit-form');
491
492 return $updated_data;
493 }
494 }
495
496 public function updateForm($Request, $post)
497 {
498 // return ['checked dta'=>$post];
499 $formId = $post->id;
500 // get the builder_helper_state from the form
501 $builder_helper_state = self::$formModel->get(['builder_helper_state'], ['id' => $formId]);
502 $builder_helper_state = (!is_wp_error($builder_helper_state) && 1 === count($builder_helper_state) && isset($builder_helper_state[0]->builder_helper_state)) ? $builder_helper_state[0]->builder_helper_state : '{}';
503 $builder_helper_state = json_decode($builder_helper_state);
504 if (property_exists($post, 'breakpointSize')) {
505 $builder_helper_state->breakpointSize = $post->breakpointSize;
506 }
507 if (property_exists($post, 'style')) {
508 $builder_helper_state->style = $post->style;
509 }
510 if (property_exists($post, 'staticStyles')) {
511 $builder_helper_state->staticStyles = $post->staticStyles;
512 }
513 if (property_exists($post, 'themeVars')) {
514 $builder_helper_state->themeVars = $post->themeVars;
515 }
516 if (property_exists($post, 'themeColors')) {
517 $builder_helper_state->themeColors = $post->themeColors;
518 }
519 if (property_exists($post, 'builderSettings')) {
520 $builder_helper_state->builderSettings = $post->builderSettings;
521 }
522 if (property_exists($post, 'atomicClassMap')) {
523 $atomic_class_map = \wp_json_encode((object) $post->atomicClassMap);
524 }
525
526 if (property_exists($post, 'fields') && null !== $post->fields && property_exists($post, 'layout') && $post->layout) {
527 $fields = wp_unslash($post->fields);
528 $fields = Helpers::replaceFieldsDefaultErrorMsg($fields);
529 $layout = wp_unslash($post->layout);
530 $nestedLayout = wp_unslash($post->nestedLayouts);
531 $formInfo = wp_unslash($post->formInfo);
532 $formID = wp_unslash($post->id);
533 $form_name = wp_unslash($post->form_name);
534 $formSettings = wp_unslash($post->formSettings);
535 $workFlows = wp_unslash($post->workFlows);
536 $additional = wp_unslash($post->additional);
537 $reports = wp_unslash($post->currentReport);
538 }
539
540 $mailTem = $formSettings->mailTem;
541 $pdfTem = isset($formSettings->pdfTem) ? $formSettings->pdfTem : [];
542 $integrations = $formSettings->integrations;
543
544 $user_details = static::$ipTool->getUserDetail();
545
546 if (empty($fields) || empty($layout) || is_null($formID)) {
547 return new WP_Error('empty_form', 'Can not update empty form.');
548 }
549
550 $form_content = [
551 'fields' => $fields,
552 'layout' => $layout,
553 'nestedLayout' => $nestedLayout,
554 'formInfo' => $formInfo,
555 ];
556
557 if (isset($post->report_id)) {
558 $form_content['report_id'] = wp_unslash($post->report_id);
559 }
560
561 /* if (!empty($formSettings->submitBtn)) {
562 $form_content = array_merge($form_content, array('buttons' => $formSettings->submitBtn));
563 } */
564 if (!empty($formSettings->theme)) {
565 $form_content = array_merge($form_content, ['theme' => $formSettings->theme]);
566 }
567
568 if (!empty($formSettings->formPermissions)) {
569 $form_content = array_merge($form_content, ['formPermissions' => $formSettings->formPermissions]);
570 }
571 if (!empty($additional)) {
572 $form_content = array_merge($form_content, ['additional' => $additional]);
573 }
574 $integartionIDForWorkflow = [];
575 $newData['settingConfiramation'] = 0;
576 $newData['integation'] = 0;
577 $newData['mailTemplate'] = 0;
578 $newData['workflow'] = 0;
579 $newData['reports'] = 0;
580 $newData['pdfTemplate'] = 0;
581 // Confiramtion Message [start]
582 if (!empty($formSettings->confirmation->type->successMsg)) {
583 $successMessages = $formSettings->confirmation->type->successMsg;
584 $successMessageHandler
585 = new SuccessMessageHandler($formID, $user_details);
586 foreach ($successMessages as $messageKey => $messageDetail) {
587 if (empty($messageDetail->id)) {
588 $savedID = $successMessageHandler->saveMessage($messageDetail);
589 if ($savedID) {
590 $newData['settingConfiramation'] = 1;
591 $integartionIDForWorkflow['successMsg'][$messageKey] = $savedID;
592 $messageDetail->id = $savedID;
593 $builder_helper_state->style = $this->updateSuccessMessageClassName($builder_helper_state->style, $messageKey, $savedID);
594 if (isset($atomic_class_map)) {
595 $atomic_class_map = $this->updateSuccessMessageClassName($atomic_class_map, $messageKey, $savedID);
596 }
597 }
598 } else {
599 $successMessageHandler->updateMessage($messageDetail);
600 }
601 }
602 unset($formSettings->confirmation->type->successMsg);
603 }
604 // return $formSettings;
605 // Confirmation Message [end] */
606 // Email Template [start]
607 if (!empty($mailTem)) {
608 $emailTemplateHandler
609 = new EmailTemplateHandler($formID, $user_details);
610 foreach ($mailTem as $templateKey => $templateDetail) {
611 if (empty($templateDetail->id)) {
612 $savedID = $emailTemplateHandler->saveTemplate($templateDetail);
613 if (is_wp_error($savedID) && 'result_empty' === $savedID->get_error_code()) {
614 $newData['mailTemplate'] = 2;
615 } else {
616 $newData['mailTemplate'] = 1;
617 $integartionIDForWorkflow['mailTem'][$templateKey] = $savedID;
618 }
619 } else {
620 $emailTemplateHandler->updateTemplate($templateDetail);
621 }
622 }
623 }
624 // return $formSettings;
625 // Email Template [end] */
626 if (!empty($pdfTem)) {
627 $pdfTemplateHandler = new PdfTemplateHandler($formID);
628
629 foreach ($pdfTem as $templateKey => $templateDetail) {
630 if (isset($templateDetail->setting->font->name)) {
631 $this->pdfFontDownload($templateDetail->setting->font->name);
632 }
633
634 $savedID = $pdfTemplateHandler->saveOrUpdate($templateDetail);
635 if (is_wp_error($savedID) && 'result_empty' === $savedID->get_error_code()) {
636 $newData['pdfTemplate'] = 2;
637 } else {
638 $newData['pdfTemplate'] = 1;
639 $integartionIDForWorkflow['pdfTem'][$templateKey] = $savedID;
640 }
641 }
642 }
643 //Integration [start] */
644 $integrationHandler = new IntegrationHandler($formID, $user_details);
645 if (!empty($formSettings->confirmation->type)) {
646 $allIntegrations = $formSettings->confirmation->type;
647 foreach ($allIntegrations as $integrationType => $integrationGroup) {
648 foreach ($integrationGroup as $singleIntegrationKey => $singleIntegrationDetail) {
649 if (empty($singleIntegrationDetail->details)) {
650 $integrationName = $singleIntegrationDetail->title;
651 unset($singleIntegrationDetail->title);
652 $singleIntegrationDetailID = empty($singleIntegrationDetail->id) ? null : $singleIntegrationDetail->id;
653 unset($singleIntegrationDetail->id);
654 $integrationDetails = !is_string($singleIntegrationDetail) ?
655 wp_json_encode($singleIntegrationDetail) : $singleIntegrationDetail;
656 } else {
657 $singleIntegrationDetailID = empty($singleIntegrationDetail->id) ? null : $singleIntegrationDetail->id;
658 unset($singleIntegrationDetail->id);
659 $integrationName = $singleIntegrationDetail->title;
660 $integrationDetails = !is_string($singleIntegrationDetail->details) ?
661 wp_json_encode($singleIntegrationDetail->details) : $singleIntegrationDetail->details;
662 }
663 if (empty($singleIntegrationDetailID)) {
664 $savedID = $integrationHandler->saveIntegration($integrationName, $integrationType, $integrationDetails, 'form');
665 $newData['settingConfiramation'] = 1;
666 $integartionIDForWorkflow[$integrationType][$singleIntegrationKey] = $savedID;
667 } else {
668 $integrationHandler->updateIntegration($singleIntegrationDetailID, $integrationName, $integrationType, $integrationDetails, 'form');
669 }
670 }
671 }
672 }
673 if (!empty($integrations)) {
674 foreach ($integrations as $singleIntegrationKey => $singleIntegrationDetail) {
675 $integrationName = $singleIntegrationDetail->name;
676 unset($singleIntegrationDetail->name);
677 $integrationType = $singleIntegrationDetail->type;
678 unset($singleIntegrationDetail->type);
679 $singleIntegrationDetailID = empty($singleIntegrationDetail->id) ? null : $singleIntegrationDetail->id;
680 unset($singleIntegrationDetail->id);
681 if (empty($singleIntegrationDetail->details)) {
682 $integrationDetails = !is_string($singleIntegrationDetail) ?
683 wp_json_encode($singleIntegrationDetail) : $singleIntegrationDetail;
684 } else {
685 $integrationDetails = !is_string($singleIntegrationDetail->details) ?
686 wp_json_encode($singleIntegrationDetail->details) : $singleIntegrationDetail->details;
687 }
688 if (empty($singleIntegrationDetailID)) {
689 $savedID = $integrationHandler->saveIntegration($integrationName, $integrationType, $integrationDetails, 'form');
690 $integartionIDForWorkflow[$integrationType][$singleIntegrationKey] = $savedID;
691 if (is_wp_error($savedID) && 'result_empty' !== $savedID->get_error_code()) {
692 $newData['integation'] = 2;
693 } else {
694 $newData['integation'] = 1;
695 }
696 } else {
697 $integrationHandler->updateIntegration($singleIntegrationDetailID, $integrationName, $integrationType, $integrationDetails, 'form');
698 }
699 }
700 }
701 //Integrations [end]
702 //workFlows [start] */
703 $workFlowExist = [];
704 if (!empty($workFlows)) {
705 $workFlowHandler = new WorkFlowHandler($formID, $user_details);
706 // foreach ($workFlows as $workFlowIndex => $workFlow) {
707 $workflows = is_string($workFlows) ? json_decode($workFlows) : $workFlows;
708
709 foreach ($workflows as $index => $workFlow) {
710 if (in_array($workFlow->action_type, ['always', 'onload'])) {
711 $workFlowExist['onload'] = true;
712 }
713 if ('oninput' === $workFlow->action_type || ('always' === $workFlow->action_type && 'cond' === $workFlow->action_behaviour)) {
714 $workFlowExist['oninput'] = true;
715 }
716 // $integartionIDForWorkflow = apply_filters('bitform_filter_integration_id', $workFlow, $formID, $index);
717 if (empty($workFlow->id)) {
718 $savedID = $workFlowHandler->saveworkFlow($workFlow, $integartionIDForWorkflow, $index);
719 if (is_wp_error($savedID) && 'result_empty' !== $savedID->get_error_code()) {
720 $newData['workflow'] = 2;
721 } else {
722 $newData['workflow'] = 1;
723 }
724 } else {
725 $newData = $workFlowHandler->updateworkFlow($workFlow->id, $workFlow, $integartionIDForWorkflow, $index, $newData);
726 }
727 }
728 }
729 $form_content = array_merge($form_content, ['workFlowExist' => $workFlowExist]);
730 //wrokFlows [end]
731 //reports [start] */
732 if (!empty($reports)) {
733 $reportsModel = new ReportsModel();
734 $fieldNames = [];
735 foreach ($fields as $key => $field) {
736 if (!empty($field->lbl)) {
737 // $name = preg_replace('/[\`\~\!\@\#\$\'\.\s\?\+\-\*\&\|\/\\\!]/', '_', $field->lbl);
738 $fieldNames["$key"] = $field->lbl;
739 }
740 }
741
742 $fieldNames['__user_id'] = __('User', 'bit-form');
743 $fieldNames['__user_ip'] = __('IP address', 'bit-form');
744 // $fieldNames['__user_location'] = __('');
745 $fieldNames['__referer'] = __('Refer URL', 'bit-form');
746 $fieldNames['__user_device'] = __('Device', 'bit-form');
747 $fieldNames['__created_at'] = __('Created Time', 'bit-form');
748 $fieldNames['__updated_at'] = __('Modified Time', 'bit-form');
749
750 $reportIsDefault = null;
751 if (isset($form_content['report_id'])) {
752 $validDateReport = $reportsModel->validateReportFields($reports, $fieldNames);
753 if (isset($reports->isDefault)) {
754 $reportIsDefault = $reports->isDefault;
755 } else {
756 $reportIsDefault = 0;
757 }
758
759 $reportsModel->update(
760 [
761 'type' => 'table',
762 'category' => 'form',
763 'context' => $formID,
764 'details' => is_string($validDateReport) ? $validDateReport : wp_json_encode($validDateReport),
765 'isDefault' => (int) $reportIsDefault,
766 'user_id' => $user_details['id'],
767 'user_ip' => $user_details['ip'],
768 'user_device' => $user_details['device'],
769 'updated_at' => $user_details['time'],
770 ],
771 [
772 'id' => $form_content['report_id'],
773 ]
774 );
775 }
776 }
777 //reports [end]
778 //form abandonment [start]
779 if (!empty($formSettings->formAbandonment)) {
780 $formAbandonment = $formSettings->formAbandonment;
781 // search for existing form abandonment in integration table
782 $abandonmentInteg = $integrationHandler->getAllIntegration('formAbandonment', 'formAbandonment');
783 if (!is_wp_error($abandonmentInteg) && !empty($abandonmentInteg)) {
784 $abandonmentInteg = $abandonmentInteg[0];
785 }
786 if (isset($abandonmentInteg->id)) {
787 $abandonmentIntegID = $abandonmentInteg->id;
788 $abandonmentIntegDetails = wp_json_encode($formAbandonment);
789 $integrationHandler->updateIntegration($abandonmentIntegID, 'formAbandonment', 'formAbandonment', $abandonmentIntegDetails, 'formAbandonment');
790 } else {
791 $abandonmentIntegDetails = wp_json_encode($formAbandonment);
792 $integrationHandler->saveIntegration('formAbandonment', 'formAbandonment', $abandonmentIntegDetails, 'formAbandonment');
793 }
794 }
795 //form abandonment [end]
796 $form_content = wp_json_encode($form_content);
797 $updateData = [
798 'form_name' => $form_name,
799 'form_content' => $form_content,
800 'user_id' => $user_details['id'],
801 'user_ip' => $user_details['ip'],
802 'builder_helper_state' => \wp_json_encode((object) $builder_helper_state),
803 'generated_script_page_ids' => \wp_json_encode((object) []),
804 'user_device' => $user_details['device'],
805 'updated_at' => $user_details['time'],
806 ];
807 if (isset($atomic_class_map)) {
808 $updateData['atomic_class_map'] = $atomic_class_map;
809 }
810 $formUpdateVersion = get_option('bitform_form_update_version');
811 if (!$formUpdateVersion) {
812 $formUpdateVersion = 1;
813 } else {
814 $formUpdateVersion = (int) $formUpdateVersion + 1;
815 }
816 update_option('bitform_form_update_version', $formUpdateVersion);
817 do_action('bitform_admin_form_changed');
818
819 $update_status = static::$formModel->update(
820 $updateData,
821 [
822 'id' => $formID,
823 ]
824 );
825 if (is_wp_error($update_status)) {
826 return $update_status;
827 } elseif (!$update_status) {
828 return new WP_Error('empty_form', __('Form update failed.', 'bit-form'));
829 } else {
830 if (isset($post->deletedFldKey) && is_array($post->deletedFldKey)) {
831 $this->setEmptyMetaValue($post->deletedFldKey);
832 unset($post->deletedFldKey);
833 }
834
835 $updated_data = $this->getAForm(['id' => $formID], null);
836
837 if (0 === $newData['settingConfiramation'] && 0 === $newData['mailTemplate'] && 0 === $newData['integation'] && 0 === $newData['pdfTemplate']) {
838 unset($updated_data['formSettings']);
839 }
840 if (0 === $newData['integation']) {
841 unset($updated_data['integrations']);
842 } elseif (2 === $newData['integation']) {
843 $errorIN = '';
844 $errorIN .= empty($errorIN) ? 'integation' : ', integation';
845 }
846 if (0 === $newData['mailTemplate']) {
847 unset($updated_data['mailTem']);
848 } elseif (2 === $newData['mailTemplate']) {
849 $errorIN .= empty($errorIN) ? 'mailTemplate' : ', mailTemplate';
850 }
851 if (0 === $newData['pdfTemplate']) {
852 unset($updated_data['pdfTem']);
853 } elseif (2 === $newData['pdfTemplate']) {
854 $errorIN .= empty($errorIN) ? 'pdfTemplate' : ', pdfTemplate';
855 }
856 if (0 === $newData['workflow']) {
857 unset($updated_data['workFlows']);
858 } elseif (2 === $newData['workflow']) {
859 $errorIN .= empty($errorIN) ? 'workflow' : ', workflow';
860 }
861 if (2 === $newData['reports']) {
862 $errorIN .= empty($errorIN) ? 'reports' : ', reports';
863 }
864 if (!empty($errorIN)) {
865 /* translators: %s: comma-separated list of areas where error occurred */
866 $updated_data['message'] = sprintf(__('Error Occured in saving %s', 'bit-form'), $errorIN);
867 return new WP_Error('Form update Error.', $updated_data);
868 }
869 if (null !== $reportIsDefault) {
870 $updated_data['form_content']['is_default'] = $reportIsDefault;
871 }
872 $updated_data['message'] = __('Form updated successfully.', 'bit-form');
873 return $updated_data;
874 }
875 }
876
877 public function setEmptyMetaValue($fieldkeys)
878 {
879 global $wpdb;
880 // Placeholders and arguments built dynamically from $fieldkeys; count matches at runtime.
881 $placeholders = implode(',', array_fill(0, \count($fieldkeys), '%s'));
882 $wpdb->query($wpdb->prepare(
883 "UPDATE `{$wpdb->prefix}bitforms_form_entrymeta` SET meta_value = %s WHERE meta_key IN ($placeholders)",
884 '',
885 ...$fieldkeys
886 ));
887 }
888
889 public function changeFormStatus($Request, $post)
890 {
891 if (isset($Request['status']) && $Request['id']) {
892 $status = sanitize_text_field(wp_unslash($Request['status']));
893 $id = absint(wp_unslash($Request['id']));
894 } else {
895 $status = wp_unslash($post->status);
896 $id = wp_unslash($post->id);
897 }
898 $user_details = static::$ipTool->getUserDetail();
899 // return $post->fields;
900 $status = 'true' === $status || true === $status ? true : false;
901 if (!is_bool($status) || is_null($id)) {
902 // echo $status;
903 return new WP_Error('status_change', __('Form status change failed.', 'bit-form'));
904 }
905 $update_status = static::$formModel->update(
906 [
907 'user_id' => $user_details['id'],
908 'user_ip' => $user_details['ip'],
909 'user_device' => $user_details['device'],
910 'status' => $status ? 1 : 0,
911 'updated_at' => $user_details['time'],
912 ],
913 [
914 'id' => $id,
915 ]
916 );
917 if (is_wp_error($update_status)) {
918 return $update_status;
919 } elseif (!$update_status) {
920 return false;
921 } else {
922 return __('Form status changed successfully', 'bit-form');
923 }
924 }
925
926 public function changeBulkFormStatus($Request, $post)
927 {
928 if (isset($Request['status']) && $Request['formID']) {
929 $status = sanitize_text_field(wp_unslash($Request['status']));
930 $formID = array_map('absint', wp_unslash($Request['formID']));
931 } else {
932 $status = wp_unslash($post->status);
933 $formID = wp_unslash($post->formID);
934 }
935 $user_details = static::$ipTool->getUserDetail();
936 // return $post->fields;
937 $status = 'true' === $status || true === $status ? true : false;
938 if (!is_bool($status) || is_null($formID) || !is_array($formID)) {
939 // echo $status;
940 return new WP_Error('status_change', __('Form status change failed.', 'bit-form'));
941 }
942 $update_status = static::$formModel->bulkUpdate(
943 [
944 'user_id' => $user_details['id'],
945 'user_ip' => $user_details['ip'],
946 'user_device' => $user_details['device'],
947 'status' => $status ? 1 : 0,
948 'updated_at' => $user_details['time'],
949 ],
950 [
951 'id' => $formID,
952 ]
953 );
954 if (is_wp_error($update_status)) {
955 return $update_status;
956 } elseif (!$update_status) {
957 return false;
958 } else {
959 return __('Form status changed successfully', 'bit-form');
960 }
961 }
962
963 public function getAllForm()
964 {
965 global $wpdb;
966
967 // Direct query: table name interpolation only (no user input). $wpdb->prepare() cannot parameterize table names.
968 $allForms = $wpdb->get_results("SELECT forms.id,forms.entries as fm_entries,forms.form_name,forms.status,forms.views,forms.created_at,COUNT(entries.id) as entries
969 FROM `{$wpdb->prefix}bitforms_form` as forms
970 LEFT JOIN `{$wpdb->prefix}bitforms_form_entries` as entries ON forms.id = entries.form_id
971 GROUP BY forms.id");
972
973 if (is_wp_error($allForms)) {
974 return $allForms;
975 } elseif (!$allForms) {
976 return [];
977 } else {
978 return $allForms;
979 }
980 }
981
982 public function getAForm($Request, $post)
983 {
984 if (!empty($Request['id'])) {
985 $formID = absint(wp_unslash($Request['id']));
986 } else {
987 $formID = wp_unslash($post->id);
988 }
989 // return $post->fields;
990 if (is_null($formID)) {
991 return new WP_Error('empty_form', __('Form id is empty.', 'bit-form'));
992 }
993 $formManager = new AdminFormManager($formID);
994 if (!$formManager->isExist()) {
995 return new WP_Error('not_exists', __('Form is not exists.', 'bit-form'));
996 }
997 $form_content = $formManager->getFormContent();
998 $helper_states = $formManager->getFormHelperStates();
999 if ($formManager->isExist()) {
1000 $form_content_arr = [
1001 'layout' => $form_content->layout,
1002 'nestedLayout' => !empty($form_content->nestedLayout) ? $form_content->nestedLayout : (object) [],
1003 'formInfo' => !empty($form_content->formInfo) ? $form_content->formInfo : (object) ['formName' => $formManager->getFormName()],
1004 'fields' => $form_content->fields,
1005 'form_name' => $formManager->getFormName(),
1006 'workFlowExist' => $form_content->workFlowExist,
1007 'report_id' => isset($form_content->report_id) ? $form_content->report_id : null
1008 ];
1009 $successMessageHandler
1010 = new SuccessMessageHandler($formID);
1011 $successMessages = $successMessageHandler->getAllMessage();
1012 if (!is_wp_error($successMessages)) {
1013 foreach ($successMessages as $sucessMessagekey => $sucessMessagevalue) {
1014 $sucessMessagevalue->message_config = json_decode($sucessMessagevalue->message_config);
1015 $allConfirmation['type']['successMsg'][$sucessMessagekey] =
1016 [
1017 'id' => $sucessMessagevalue->id,
1018 'title' => $sucessMessagevalue->message_title,
1019 'msg' => $sucessMessagevalue->message_content,
1020 'config' => $sucessMessagevalue->message_config,
1021 ];
1022 }
1023 }
1024 $emailTemplateHandler
1025 = new EmailTemplateHandler($formID);
1026 $emailTemplates = $emailTemplateHandler->getAllTemplate();
1027 if (!is_wp_error($emailTemplates)) {
1028 foreach ($emailTemplates as $emailTemplatekey => $emailTemplatevalue) {
1029 $mailTem[] =
1030 [
1031 'id' => $emailTemplatevalue->id,
1032 'title' => $emailTemplatevalue->title,
1033 'sub' => $emailTemplatevalue->sub,
1034 'body' => $emailTemplatevalue->body,
1035 ];
1036 }
1037 }
1038 // get all pdf template
1039 $pdfTemplateHandler = new PdfTemplateHandler($formID);
1040 $pdfTemplates = $pdfTemplateHandler->getAll();
1041
1042 if (!is_wp_error($pdfTemplates)) {
1043 foreach ($pdfTemplates as $value) {
1044 $pdfTem[] =
1045 [
1046 'id' => $value->id,
1047 'title' => $value->title,
1048 'setting' => json_decode($value->setting),
1049 'body' => $value->body,
1050 ];
1051 }
1052 }
1053
1054 $integrationHandler = new IntegrationHandler($formID);
1055 $formIntegrations = $integrationHandler->getAllIntegration('form');
1056 if (!is_wp_error($formIntegrations)) {
1057 foreach ($formIntegrations as $integrationkey => $integrationValue) {
1058 if ('redirectPage' === $integrationValue->integration_type || 'webHooks' === $integrationValue->integration_type) {
1059 $integrationData = [
1060 'id' => $integrationValue->id,
1061 'title' => $integrationValue->integration_name,
1062 ];
1063 if (!empty($integrationValue->integration_details)) {
1064 $integration_details = (array) json_decode($integrationValue->integration_details);
1065 $integrationData = array_merge($integration_details, $integrationData);
1066 } else {
1067 $integration_details = [
1068 'url' => '',
1069 ];
1070 $integrationData = array_merge($integrationData, $integration_details);
1071 }
1072 $allConfirmation['type'][$integrationValue->integration_type][]
1073 = $integrationData;
1074 } else {
1075 $integrationData = [
1076 'id' => $integrationValue->id,
1077 'name' => $integrationValue->integration_name,
1078 'type' => $integrationValue->integration_type,
1079 ];
1080 $integrations[] = array_merge(
1081 $integrationData,
1082 is_string($integrationValue->integration_details) ?
1083 (array) json_decode($integrationValue->integration_details) :
1084 $integrationValue->integration_details
1085 );
1086 }
1087 }
1088 }
1089
1090 // get form abandonment integration if exist
1091 $formAbandonmentInteg = $integrationHandler->getAllIntegration('formAbandonment', 'formAbandonment');
1092 if (!is_wp_error($formAbandonmentInteg) && !empty($formAbandonmentInteg)) {
1093 $formAbandonmentInteg = $formAbandonmentInteg[0];
1094 if (!empty($formAbandonmentInteg->integration_details)) {
1095 $formAbandonment = json_decode($formAbandonmentInteg->integration_details);
1096 } else {
1097 $formAbandonment = (object) [];
1098 }
1099 } else {
1100 $formAbandonment = (object) [];
1101 }
1102
1103 $settingsContent = [
1104 'formName' => $formManager->getFormName(),
1105 'theme' => isset($form_content->theme) ? $form_content->theme : 'default',
1106 'formPermissions' => isset($form_content->formPermissions) ? $form_content->formPermissions : (object) [],
1107 // 'submitBtn' => $form_content->buttons,
1108 ];
1109
1110 if (!empty($allConfirmation)) {
1111 $confirmation = [
1112 'confirmation' => $allConfirmation,
1113 ];
1114 } else {
1115 $confirmation = [
1116 'confirmation' => ['type' => []],
1117 ];
1118 }
1119 $settingsContent = array_merge($settingsContent, $confirmation);
1120 if (!empty($integrations)) {
1121 $settingsContent = array_merge(
1122 $settingsContent,
1123 [
1124 'integrations' => $integrations,
1125 ]
1126 );
1127 } else {
1128 $settingsContent = array_merge(
1129 $settingsContent,
1130 [
1131 'integrations' => []
1132 ]
1133 );
1134 }
1135
1136 if (!empty($mailTem)) {
1137 $settingsContent = array_merge(
1138 $settingsContent,
1139 [
1140 'mailTem' => $mailTem,
1141 ]
1142 );
1143 } else {
1144 $settingsContent = array_merge(
1145 $settingsContent,
1146 [
1147 'mailTem' => []
1148 ]
1149 );
1150 }
1151
1152 if (!empty($pdfTem)) {
1153 $settingsContent = array_merge(
1154 $settingsContent,
1155 [
1156 'pdfTem' => $pdfTem,
1157 ]
1158 );
1159 } else {
1160 $settingsContent = array_merge(
1161 $settingsContent,
1162 [
1163 'pdfTem' => [],
1164 ]
1165 );
1166 }
1167
1168 if (!empty($formAbandonment)) {
1169 $settingsContent = array_merge(
1170 $settingsContent,
1171 [
1172 'formAbandonment' => $formAbandonment,
1173 ]
1174 );
1175 } else {
1176 $settingsContent = array_merge(
1177 $settingsContent,
1178 [
1179 'formAbandonment' => (object) [],
1180 ]
1181 );
1182 }
1183 $formSettings = [
1184 'formSettings' => $settingsContent,
1185 ];
1186 $data = [
1187 'id' => $formID,
1188 'form_name' => $formManager->getFormName(),
1189 'form_content' => $form_content_arr,
1190 'breakpointSize' => $helper_states->breakpointSize,
1191 'style' => $helper_states->style,
1192 'themeVars' => $helper_states->themeVars,
1193 'themeColors' => $helper_states->themeColors,
1194 'builderSettings' => $helper_states->builderSettings,
1195 'additional' => empty($form_content->additional) ? [
1196 'enabled' => [
1197 'blocked_ip' => false,
1198 'restrict_form' => false,
1199 'onePerIp' => false,
1200 ],
1201 'settings' => [
1202 'restrict_form' => [
1203 'day' => [],
1204 'date' => [
1205 'from' => null,
1206 'to' => null,
1207 ],
1208 'time' => [
1209 'from' => null,
1210 'to' => null,
1211 ],
1212 ],
1213 'entry_limit' => null,
1214 'blocked_ip' => [],
1215 ],
1216 ] : $form_content->additional,
1217 'created_at' => $formManager->getFormMetaData()['created_at'],
1218 'views' => $formManager->getFormMetaData()['views'],
1219 'entries' => $formManager->getFormMetaData()['entries'],
1220 'status' => $formManager->getFormMetaData()['status'],
1221 ];
1222 $data = array_merge($data, $formSettings);
1223 $workFlowHandler = new WorkFlowHandler($formID);
1224 $workFlows = ['workFlows' => $workFlowHandler->getAllworkFlow()];
1225 $data = array_merge($data, $workFlows);
1226 $reportsModel = new ReportsModel();
1227 $returnedReportData = $reportsModel->get(
1228 [
1229 'id',
1230 'details',
1231 'isDefault',
1232 'type',
1233 ],
1234 [
1235 'category' => 'form',
1236 'context' => $formID,
1237 ]
1238 );
1239
1240 if (!is_wp_error($returnedReportData)) {
1241 $fieldNames = [];
1242 foreach ($formManager->getFieldLabel() as $key => $field) {
1243 $fieldNames[$field['key']] = isset($field->lbl) ? $field->lbl : '';
1244 }
1245 if ($formManager->isGCLIDEnabled()) {
1246 $fieldNames['GCLID'] = 'GCLID';
1247 }
1248 foreach ($returnedReportData as $reportKey => $reportData) {
1249 $reportDetails = $reportsModel->validateReportFields($reportData, $fieldNames);
1250 if (!empty($reportDetails) && is_string($reportDetails)) {
1251 $returnedReportData[$reportKey]->details = json_decode($reportDetails);
1252 } elseif (!empty($reportDetails)) {
1253 $returnedReportData[$reportKey]->details = $reportDetails;
1254 } else {
1255 $returnedReportData[$reportKey]->details = [];
1256 }
1257 if ('1' === (string) $reportData->isDefault) {
1258 $returnedReportData[$reportKey]->details->report_name = __('All Entries', 'bit-form');
1259 }
1260 }
1261 $reports = ['reports' => $returnedReportData];
1262 $data = array_merge($data, $reports);
1263 }
1264
1265 $formFields = $formManager->getFieldLabel();
1266 $data = array_merge($data, ['Labels' => $formFields]);
1267
1268 return $data;
1269 }
1270 }
1271
1272 public function getAFormV1($Request, $post)
1273 {
1274 if (!empty($Request['id'])) {
1275 $formID = absint(wp_unslash($Request['id']));
1276 } else {
1277 $formID = wp_unslash($post->id);
1278 }
1279 // return $post->fields;
1280 if (is_null($formID)) {
1281 return new WP_Error('empty_form', __('Form id is empty.', 'bit-form'));
1282 }
1283 $formManager = new AdminFormManager($formID);
1284 if (!$formManager->isExist()) {
1285 return new WP_Error('not_exists', __('Form is not exists.', 'bit-form'));
1286 }
1287 $form_content = $formManager->getFormContent();
1288 if ($formManager->isExist()) {
1289 $form_content_arr = [
1290 'layout' => $form_content->layout,
1291 'fields' => $form_content->fields,
1292 'form_name' => $formManager->getFormName(),
1293 'workFlowExist' => $form_content->workFlowExist,
1294 'report_id' => isset($form_content->report_id) ? $form_content->report_id : null
1295 ];
1296 $successMessageHandler
1297 = new SuccessMessageHandler($formID);
1298 $successMessages = $successMessageHandler->getAllMessage();
1299 if (!is_wp_error($successMessages)) {
1300 foreach ($successMessages as $sucessMessagekey => $sucessMessagevalue) {
1301 $allConfirmation['type']['successMsg'][$sucessMessagekey] =
1302 [
1303 'id' => $sucessMessagevalue->id,
1304 'title' => $sucessMessagevalue->message_title,
1305 'msg' => $sucessMessagevalue->message_content,
1306 ];
1307 }
1308 }
1309 $emailTemplateHandler
1310 = new EmailTemplateHandler($formID);
1311 $emailTemplates = $emailTemplateHandler->getAllTemplate();
1312 if (!is_wp_error($emailTemplates)) {
1313 foreach ($emailTemplates as $emailTemplatekey => $emailTemplatevalue) {
1314 $mailTem[] =
1315 [
1316 'id' => $emailTemplatevalue->id,
1317 'title' => $emailTemplatevalue->title,
1318 'sub' => $emailTemplatevalue->sub,
1319 'body' => $emailTemplatevalue->body,
1320 ];
1321 }
1322 }
1323 $integrationHandler = new IntegrationHandler($formID);
1324 $formIntegrations = $integrationHandler->getAllIntegration('form');
1325 if (!is_wp_error($formIntegrations)) {
1326 foreach ($formIntegrations as $integrationkey => $integrationValue) {
1327 if ('redirectPage' === $integrationValue->integration_type || 'webHooks' === $integrationValue->integration_type) {
1328 $integrationData = [
1329 'id' => $integrationValue->id,
1330 'title' => $integrationValue->integration_name,
1331 ];
1332 if (!empty($integrationValue->integration_details)) {
1333 // var_dump(json_decode($integrationValue->integration_details));
1334 $integration_details = (array) json_decode($integrationValue->integration_details);
1335 $integrationData = array_merge($integration_details, $integrationData);
1336 } else {
1337 $integration_details = [
1338 'url' => '',
1339 ];
1340 $integrationData = array_merge($integrationData, $integration_details);
1341 }
1342 $allConfirmation['type'][$integrationValue->integration_type][]
1343 = $integrationData;
1344 } else {
1345 $integrationData = [
1346 'id' => $integrationValue->id,
1347 'name' => $integrationValue->integration_name,
1348 'type' => $integrationValue->integration_type,
1349 ];
1350 $integrations[] = array_merge(
1351 $integrationData,
1352 is_string($integrationValue->integration_details) ?
1353 (array) json_decode($integrationValue->integration_details) :
1354 $integrationValue->integration_details
1355 );
1356 }
1357 }
1358 }
1359 $settingsContent = [
1360 'formName' => $formManager->getFormName(),
1361 'theme' => $form_content->theme,
1362 // 'submitBtn' => $form_content->buttons,
1363 ];
1364
1365 if (!empty($allConfirmation)) {
1366 $confirmation = [
1367 'confirmation' => $allConfirmation,
1368 ];
1369 } else {
1370 $confirmation = [
1371 'confirmation' => ['type' => []],
1372 ];
1373 }
1374 $settingsContent = array_merge($settingsContent, $confirmation);
1375 if (!empty($integrations)) {
1376 $settingsContent = array_merge(
1377 $settingsContent,
1378 [
1379 'integrations' => $integrations,
1380 ]
1381 );
1382 } else {
1383 $settingsContent = array_merge(
1384 $settingsContent,
1385 [
1386 'integrations' => []
1387 ]
1388 );
1389 }
1390 if (!empty($mailTem)) {
1391 $settingsContent = array_merge(
1392 $settingsContent,
1393 [
1394 'mailTem' => $mailTem,
1395 ]
1396 );
1397 } else {
1398 $settingsContent = array_merge(
1399 $settingsContent,
1400 [
1401 'mailTem' => []
1402 ]
1403 );
1404 }
1405 $formSettings = [
1406 'formSettings' => $settingsContent,
1407 ];
1408 $data = [
1409 'id' => $formID,
1410 'form_name' => $formManager->getFormName(),
1411 'form_content' => $form_content_arr,
1412 'additional' => empty($form_content->additional) ? [
1413 'enabled' => [
1414 'blocked_ip' => false,
1415 'restrict_form' => false,
1416 'onePerIp' => false,
1417 ],
1418 'settings' => [
1419 'restrict_form' => [
1420 'day' => [],
1421 'date' => [
1422 'from' => null,
1423 'to' => null,
1424 ],
1425 'time' => [
1426 'from' => null,
1427 'to' => null,
1428 ],
1429 ],
1430 'entry_limit' => null,
1431 'blocked_ip' => [],
1432 ],
1433 ] : $form_content->additional,
1434 'created_at' => $formManager->getFormMetaData()['created_at'],
1435 'views' => $formManager->getFormMetaData()['views'],
1436 'entries' => $formManager->getFormMetaData()['entries'],
1437 'status' => $formManager->getFormMetaData()['status'],
1438 ];
1439 $data = array_merge($data, $formSettings);
1440 $workFlowHandler = new WorkFlowHandler($formID);
1441 $workFlows = ['workFlows' => $workFlowHandler->getAllworkFlowV1()];
1442 $data = array_merge($data, $workFlows);
1443 $reportsModel = new ReportsModel();
1444 $returnedReportData = $reportsModel->get(
1445 [
1446 'id',
1447 'details',
1448 'isDefault',
1449 'type',
1450 ],
1451 [
1452 'category' => 'form',
1453 'context' => $formID,
1454 ]
1455 );
1456
1457 if (!is_wp_error($returnedReportData)) {
1458 $fieldNames = [];
1459 foreach ($formManager->getFieldLabel() as $key => $field) {
1460 $fieldNames[$field['key']] = isset($field->lbl) ? $field->lbl : '';
1461 }
1462 if ($formManager->isGCLIDEnabled()) {
1463 $fieldNames['GCLID'] = 'GCLID';
1464 }
1465 foreach ($returnedReportData as $reportKey => $reportData) {
1466 $reportDetails = $reportsModel->validateReportFields($reportData, $fieldNames);
1467 if (!empty($reportDetails) && is_string($reportDetails)) {
1468 $returnedReportData[$reportKey]->details = json_decode($reportDetails);
1469 } elseif (!empty($reportDetails)) {
1470 $returnedReportData[$reportKey]->details = $reportDetails;
1471 } else {
1472 $returnedReportData[$reportKey]->details = [];
1473 }
1474 if ('1' === (string) $reportData->isDefault) {
1475 $returnedReportData[$reportKey]->details->report_name = __('All Entries', 'bit-form');
1476 }
1477 }
1478 $reports = ['reports' => $returnedReportData];
1479 $data = array_merge($data, $reports);
1480 }
1481
1482 $formFields = $formManager->getFieldLabel();
1483 $data = array_merge($data, ['Labels' => $formFields]);
1484
1485 return $data;
1486 }
1487 }
1488
1489 public function deleteAForm($Request, $post)
1490 {
1491 if (!empty($Request['id'])) {
1492 $formID = absint(wp_unslash($Request['id']));
1493 } else {
1494 $formID = wp_unslash($post->id);
1495 }
1496 if (is_null($formID)) {
1497 return new WP_Error('empty_form', __('Form id is empty.', 'bit-form'));
1498 }
1499
1500 if (!filter_var($formID, FILTER_VALIDATE_INT)) {
1501 return new WP_Error('invalid_form', __('Form id is invalid.', 'bit-form'));
1502 }
1503
1504 $delete_status = static::$formModel->delete(
1505 [
1506 'id' => $formID,
1507 ]
1508 );
1509 do_action('bitform_admin_form_changed');
1510
1511 $successMessageModel = new SuccessMessageModel();
1512 $deleteMsgStatus = $successMessageModel->delete(['form_id' => $formID]);
1513
1514 $emailTemplateModel = new EmailTemplateModel();
1515 $deleteTemplateStatus = $emailTemplateModel->delete(['form_id' => $formID]);
1516
1517 $pdfTemplateModel = new PdfTemplateModel();
1518 $deletePdfTemplateStatus = $pdfTemplateModel->delete(['form_id' => $formID]);
1519
1520 $integrationModel = new IntegrationModel();
1521 $deleteIntegrationStatus = $integrationModel->delete(['form_id' => $formID]);
1522
1523 $workFlowModel = new WorkFlowModel();
1524 $deleteworkFlowStatus = $workFlowModel->delete(['form_id' => $formID]);
1525
1526 $reportsModel = new ReportsModel();
1527 $deleteReportStatus = $reportsModel->delete(['context' => $formID]);
1528
1529 $formEntryModel = new FormEntryModel();
1530 $returnedEntries = $formEntryModel->get('id', ['form_id' => $formID]);
1531 $entries = [];
1532
1533 // checked namespace exist
1534 if (class_exists('\BitCode\BitFormPro\Admin\BfTable\Table')) {
1535 \BitCode\BitFormPro\Admin\BfTable\Table::deleteTableByFormId($formID);
1536 }
1537
1538 $fileHandler = new FileHandler();
1539 if (file_exists(BITFORMS_UPLOAD_DIR . DIRECTORY_SEPARATOR . $formID)) {
1540 $fileHandler->rmrf(BITFORMS_UPLOAD_DIR . DIRECTORY_SEPARATOR . $formID);
1541 }
1542 if (file_exists(BITFORMS_UPLOAD_DIR . DIRECTORY_SEPARATOR . $formID)) {
1543 $fileHandler->rmrf(BITFORMS_UPLOAD_DIR . DIRECTORY_SEPARATOR . $formID);
1544 }
1545 $formStylePath = BITFORMS_CONTENT_DIR . DIRECTORY_SEPARATOR . 'form-styles';
1546
1547 $formCssPath = $formStylePath . DIRECTORY_SEPARATOR . 'bitform-' . $formID . '.css';
1548 FileHandler::deleteIsFileExists($formCssPath);
1549
1550 $layoutCssPath = $formStylePath . DIRECTORY_SEPARATOR . 'bitform-layout-' . $formID . '.css';
1551 FileHandler::deleteIsFileExists($layoutCssPath);
1552
1553 $customCssPath = $formStylePath . DIRECTORY_SEPARATOR . 'bitform-custom-' . $formID . '.css';
1554 FileHandler::deleteIsFileExists($customCssPath);
1555
1556 $customJSPath = BITFORMS_CONTENT_DIR . DIRECTORY_SEPARATOR . 'form-scripts' . DIRECTORY_SEPARATOR . 'bitform-custom-' . $formID . '.js';
1557 FileHandler::deleteIsFileExists($customJSPath);
1558
1559 $conversationCssPath = $formStylePath . DIRECTORY_SEPARATOR . 'bitform-conversational-' . $formID . '.css';
1560 FileHandler::deleteIsFileExists($conversationCssPath);
1561
1562 return is_wp_error($delete_status) ? $delete_status : __('Form deleted successfully.', 'bit-form');
1563 }
1564
1565 public function deleteBlukForm($Request, $post)
1566 {
1567 if (!empty($Request['formID'])) {
1568 $formID = array_map('absint', wp_unslash($Request['formID']));
1569 } else {
1570 $formID = wp_unslash($post->formID);
1571 }
1572
1573 if (is_null($formID) || !is_array($formID)) {
1574 return new WP_Error('empty_form', __('Form id is empty.', 'bit-form'));
1575 }
1576
1577 if (!Helpers::checkIsIntArr($formID)) {
1578 return new WP_Error('invalid_form', __('Form id is invalid', 'bit-form'));
1579 }
1580
1581 $cssPath = BITFORMS_CONTENT_DIR . DIRECTORY_SEPARATOR . 'form-styles' . DIRECTORY_SEPARATOR;
1582 foreach ($formID as $id) {
1583 $formCssPath = $cssPath . 'bitform-' . $id . '.css';
1584 FileHandler::deleteIsFileExists($formCssPath);
1585
1586 $layoutPath = $cssPath . 'bitform-layout-' . $id . '.css';
1587 FileHandler::deleteIsFileExists($layoutPath);
1588
1589 $bitformCustomPath = $cssPath . 'bitform-' . $id . '-formid' . '.css';
1590 FileHandler::deleteIsFileExists($bitformCustomPath);
1591 }
1592 $delete_status = static::$formModel->bulkDelete(
1593 [
1594 'id' => $formID,
1595 ]
1596 );
1597 do_action('bitform_admin_form_changed');
1598
1599 if (is_wp_error($delete_status)) {
1600 wp_send_json_error($delete_status->get_error_message(), 400);
1601 }
1602
1603 $successMessageModel
1604 = new SuccessMessageModel();
1605 $deleteMsgStatus = $successMessageModel->bulkDelete(['form_id' => $formID]);
1606
1607 $emailTemplateModel = new EmailTemplateModel();
1608 $deleteTemplateStatus = $emailTemplateModel->bulkDelete(['form_id' => $formID]);
1609
1610 $pdfTemplateModel = new PdfTemplateModel();
1611 $deletePdfTemplateStatus = $pdfTemplateModel->bulkDelete(['form_id' => $formID]);
1612
1613 $integrationModel = new IntegrationModel();
1614 $deleteIntegrationStatus = $integrationModel->bulkDelete(['form_id' => $formID]);
1615
1616 $workFlowModel = new WorkFlowModel();
1617 $deleteworkFlowStatus = $workFlowModel->bulkDelete(['form_id' => $formID]);
1618
1619 $reportsModel = new ReportsModel();
1620 $deleteReportStatus = $reportsModel->bulkDelete(['context' => $formID]);
1621
1622 $formEntryModel = new FormEntryModel();
1623 $returnedEntries = $formEntryModel->get('id', ['form_id' => $formID]);
1624
1625 if (class_exists('\BitCode\BitFormPro\Admin\BfTable\Table')) {
1626 \BitCode\BitFormPro\Admin\BfTable\Table::deleteTableByBulkFormId($formID);
1627 }
1628
1629 $entries = [];
1630 foreach ($returnedEntries as $entryKey => $entryInfo) {
1631 if (!empty($entryInfo->id)) {
1632 $entries[] = $entryInfo->id;
1633 }
1634 }
1635 global $wpdb;
1636 $prefix = $wpdb->prefix;
1637 if (count($entries) > 0) {
1638 $deleteEntriesStatus = $formEntryModel->bulkDelete(
1639 [
1640 "`{$prefix}bitforms_form_entries`.`id`" => $entries,
1641 "`{$prefix}bitforms_form_entries`.`form_id`" => $formID,
1642 ]
1643 );
1644 }
1645
1646 // delete entry log and details; table name interpolation only — $wpdb->prepare() parameterizes the form_id value.
1647 $wpdb->query($wpdb->prepare(
1648 "DELETE em, e FROM `{$prefix}bitforms_form_log_details` AS em JOIN `{$prefix}bitforms_form_entry_log` AS e ON em.log_id = e.id WHERE e.form_id = %d",
1649 $formID
1650 ));
1651
1652 $fileHandler = new FileHandler();
1653 foreach ($formID as $fId) {
1654 if (file_exists(BITFORMS_UPLOAD_DIR . DIRECTORY_SEPARATOR . $fId)) {
1655 $fileHandler->rmrf(BITFORMS_UPLOAD_DIR . DIRECTORY_SEPARATOR . $fId);
1656 }
1657 }
1658
1659 return is_wp_error($delete_status) ? $delete_status : __('Forms deleted successfully.', 'bit-form');
1660 }
1661
1662 public function genarateNewLayoutNField($layout, $fields, $oldId, $newId)
1663 {
1664 $newField = (object) [];
1665 foreach ($layout->lg as $ind => $itm) {
1666 $fld_tmp = $fields->{$layout->lg[$ind]->i};
1667 $layout->lg[$ind]->i = str_replace("bf$oldId-", "bf$newId-", $layout->lg[$ind]->i);
1668 $layout->md[$ind]->i = str_replace("bf$oldId-", "bf$newId-", $layout->md[$ind]->i);
1669 $layout->sm[$ind]->i = str_replace("bf$oldId-", "bf$newId-", $layout->sm[$ind]->i);
1670 $newField->{$layout->lg[$ind]->i} = $fld_tmp;
1671 }
1672 return ['layout' => $layout, 'fields' => $newField];
1673 }
1674
1675 public function duplicateAForm($Request, $post)
1676 {
1677 $oldFormId = intval($post->id);
1678 $newFormId = intval($post->newFormId);
1679 if ($oldFormId < 1) {
1680 return new WP_Error('empty_form', __('Form id is empty.', 'bit-form'));
1681 }
1682
1683 $formManager = new AdminFormManager($oldFormId);
1684 if (!$formManager->isExist()) {
1685 return new WP_Error('empty_form', __('Form does not exists.', 'bit-form'));
1686 }
1687
1688 $duplicatedForm = $this->getAForm($Request, $post);
1689 $duplicatedForm['form_name'] = 'Duplicate of ' . $duplicatedForm['form_name'];
1690 $formData = FormDuplicateHelper::createReplica($duplicatedForm, $oldFormId, $newFormId);
1691
1692 /* echo wp_json_encode($formData);
1693 \wp_die(); */
1694 $duplicateResponse = $this->createNewForm(null, $formData);
1695
1696 if (!is_wp_error($duplicateResponse) || (is_wp_error($duplicateResponse) && 'result_empty' === $duplicateResponse->get_error_code())) {
1697 // duplicate stylesheet
1698 $style_dir = BITFORMS_CONTENT_DIR . DIRECTORY_SEPARATOR . 'form-styles' . DIRECTORY_SEPARATOR;
1699 // layout style copy
1700 $styleStr = FileHandler::readFile($style_dir . 'bitform-layout-' . $oldFormId . '.css');
1701 $newStyle = str_replace(".bf$oldFormId-", ".bf$newFormId-", $styleStr);
1702 FileHandler::writeFile($style_dir . "bitform-layout-$newFormId.css", $newStyle);
1703 // style copy
1704 $styleStr = FileHandler::readFile($style_dir . 'bitform-' . $oldFormId . '.css');
1705 $newStyle = str_replace("-$oldFormId", "-$newFormId", $styleStr);
1706 FileHandler::writeFile($style_dir . "bitform-$newFormId.css", $newStyle);
1707 $duplicatedForm = $this->getAForm(null, (object) ['id' => $newFormId]);
1708 $duplicatedForm['message'] = __('Form duplicated successfully', 'bit-form');
1709 return $duplicatedForm;
1710 }
1711 return $duplicateResponse;
1712 }
1713
1714 public function importAForm($post)
1715 {
1716 $oldFormId = !empty($post->formDetail->form_id) ? $post->formDetail->form_id : null;
1717 $newFormId = intval($post->newFormId);
1718 if (!$oldFormId || empty($post->formDetail->fields) || empty($post->formDetail->layout)) {
1719 return new WP_Error('invalid_form', __('Please import a valid json.', 'bit-form'));
1720 }
1721 $importtedForm = (array) $post->formDetail;
1722 $importtedForm['form_content']['fields'] = $importtedForm['fields'];
1723 $importtedForm['form_content']['layout'] = $importtedForm['layout'];
1724 $importtedForm['form_content']['nestedLayout'] = $importtedForm['nestedLayouts'];
1725 $importtedForm['form_content']['formInfo'] = $importtedForm['formInfo'];
1726 unset($importtedForm['fields'], $importtedForm['layout'], $importtedForm['nestedLayout'], $importtedForm['formInfo']);
1727 $formData = FormDuplicateHelper::createReplica((array) $importtedForm, $oldFormId, $newFormId);
1728
1729 if (!empty($importtedForm['rowHeight'])) {
1730 $formData->rowHeight = $importtedForm['rowHeight'];
1731 }
1732
1733 if (!empty($importtedForm['formStyle'])) {
1734 $formData->formStyle = str_replace("-$oldFormId", "-$newFormId", $importtedForm['formStyle']);
1735 $formData->layoutChanged = '-';
1736 }
1737 $importResponse = $this->createNewForm(null, $formData);
1738
1739 $customCode = [];
1740 // add custom js
1741 if (!empty($formData->customCode->customJs)) {
1742 $customJsPath = 'form-scripts';
1743 $fileName = 'bitform-custom-' . $newFormId . '.js';
1744 $customCode['JavaScript'] = $formData->customCode->customJs;
1745 Helpers::saveFile($customJsPath, $fileName, $formData->customCode->customJs, 'w');
1746 }
1747 // add custom css
1748 if (!empty($formData->customCode->customCss)) {
1749 $customCssPath = 'form-styles';
1750 $fileName = 'bitform-custom-' . $newFormId . '.css';
1751 $customCode['CSS'] = $formData->customCode->customCss;
1752 Helpers::saveFile($customCssPath, $fileName, $formData->customCode->customCss, 'w');
1753 }
1754 if (!is_wp_error($importResponse)) {
1755 $importResponse['customCode'] = $customCode;
1756 }
1757 if (!is_wp_error($importResponse) || (is_wp_error($importResponse) && 'result_empty' === $importResponse->get_error_code())) {
1758 $responseData = $this->getAForm(null, (object) ['id' => $newFormId]);
1759 $responseData['customCode'] = $customCode;
1760 $responseData['message'] = __('Form imported successfully.', 'bit-form');
1761 return $responseData;
1762 }
1763 return $importResponse;
1764 }
1765
1766 // public function exportAForm($Request) {
1767 // $oldFormId = intval($Request['id']);
1768 // if ($oldFormId < 1) {
1769 // return new WP_Error('empty_form', __('Form id is empty.', 'bit-form'));
1770 // }
1771 // $formManager = new AdminFormManager($oldFormId);
1772 // if (!$formManager->isExist()) {
1773 // return new WP_Error('empty_form', __('Form does not exists.', 'bit-form'));
1774 // }
1775
1776 // $newFormId = $oldFormId;
1777 // $duplicatedForm = $this->getAForm($Request, (object)['id' => $oldFormId]);
1778 // $formData = FormDuplicateHelper::createReplica($duplicatedForm, $oldFormId, $newFormId);
1779
1780 // $style_dir = BITFORMS_CONTENT_DIR . DIRECTORY_SEPARATOR . 'form-styles' . DIRECTORY_SEPARATOR;
1781 // $mainFormStyle = fopen($style_dir . 'bitform-' . $oldFormId . '.css', 'r');
1782 // $styleStr = fread($mainFormStyle, filesize($style_dir . 'bitform-' . $oldFormId . '.css'));
1783
1784 // $formData->formStyle = str_replace("-$oldFormId", "-$newFormId", $styleStr);
1785 // $formData->layoutChanged = '-';
1786 // $formData->rowHeight = FormDuplicateHelper::calcRowHeight($styleStr, $oldFormId);
1787
1788 // $formJson = wp_json_encode($formData);
1789 // header('Content-Type: application/force-download');
1790 // header('Content-Type: application/octet-stream');
1791 // header('Content-Type: application/download');
1792 // header('Content-Disposition: attachment; filename="bitform_export_' . $oldFormId . '.json"');
1793 // header('Content-Description: File Transfer');
1794 // header('Expires: 0');
1795 // header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
1796 // header('Pragma: public');
1797 // header('Content-Length: ' . strlen($formJson));
1798 // header('Content-Transfer-Encoding: binary ');
1799 // flush();
1800 // echo $formJson;
1801 // die();
1802 // }
1803
1804 public function exportAForm($Request, $post)
1805 {
1806 $oldFormId = intval($post->id);
1807 if ($oldFormId < 1) {
1808 return new WP_Error('empty_form', __('Form id is empty.', 'bit-form'));
1809 }
1810 $formManager = new AdminFormManager($oldFormId);
1811 if (!$formManager->isExist()) {
1812 return new WP_Error('empty_form', __('Form does not exists.', 'bit-form'));
1813 }
1814
1815 $newFormId = $oldFormId;
1816 $duplicatedForm = $this->getAForm($Request, (object) ['id' => $oldFormId]);
1817 $formData = FormDuplicateHelper::createReplica($duplicatedForm, $oldFormId, $newFormId);
1818 // for custom css
1819 $customCssPath = 'form-styles/bitform-custom-' . $newFormId . '.css';
1820 $cssPath = Helpers::generatePathDirOrFile($customCssPath);
1821 $customCssContain = Helpers::fileRead($cssPath);
1822 $formData->customCode = [];
1823 if ('' !== $customCssContain) {
1824 $formData->customCode['customCss'] = $customCssContain;
1825 }
1826 // for custom js
1827 $customJsPath = 'form-scripts/bitform-custom-' . $newFormId . '.js';
1828 $jsPath = Helpers::generatePathDirOrFile($customJsPath);
1829 $customJsContain = Helpers::fileRead($jsPath);
1830 if ('' !== $customJsContain) {
1831 $formData->customCode['customJs'] = $customJsContain;
1832 }
1833 return $formData;
1834 }
1835
1836 public function getFormEntryLabelAndCount($Request, $post)
1837 {
1838 if (!empty($Request['id'])) {
1839 $id = absint(wp_unslash($Request['id']));
1840 } else {
1841 $id = wp_unslash($post->id);
1842 }
1843 if (is_null($id)) {
1844 return new WP_Error('empty_form', __('Form id is empty.', 'bit-form'));
1845 }
1846 $formManager = new AdminFormManager($id);
1847 if (!$formManager->isExist()) {
1848 return new WP_Error('empty_form', __('Form does not exists.', 'bit-form'));
1849 }
1850 $formFields = $formManager->getFieldLabel();
1851 $formEntry = new FormEntryModel();
1852 $count = $formEntry->count(
1853 [
1854 'form_id' => $id,
1855 ]
1856 );
1857 $reportsModel = new ReportsModel();
1858 $returnedReportData = $reportsModel->get(
1859 [
1860 'id',
1861 'details',
1862 'isDefault',
1863 'type',
1864 ],
1865 [
1866 'category' => 'form',
1867 'context' => $id,
1868 ]
1869 );
1870 $labels = [];
1871 if (!is_wp_error($returnedReportData)) {
1872 $fieldNames = [];
1873 foreach ($formFields as $field) {
1874 $fieldNames[$field['key']] = $field['name'];
1875 $labels[$field['key']] = $field;
1876 }
1877 foreach ($returnedReportData as $reportKey => $reportData) {
1878 $reportDetails = $reportsModel->validateReportFields($reportData, $fieldNames);
1879 if (!empty($reportDetails) && is_string($reportDetails)) {
1880 $returnedReportData[$reportKey]->details = json_decode($reportDetails);
1881 } elseif (!empty($reportDetails)) {
1882 $returnedReportData[$reportKey]->details = $reportDetails;
1883 }
1884 }
1885 $response['reports'] = empty($returnedReportData) ? [] : $returnedReportData;
1886 }
1887
1888 $response['count'] = intval($count[0]->count);
1889 $response['Labels'] = $formFields;
1890 $response['fieldDetails'] = $labels;
1891 return $response;
1892 }
1893
1894 public function getFormEntry($Request, $post)
1895 {
1896 if (!empty($Request['id'])) {
1897 $id = absint(wp_unslash($Request['id']));
1898 $offset = isset($Request['offset']) ?
1899 wp_unslash($Request['offset']) : 0;
1900 $pageSize = isset($Request['pageSize']) ?
1901 wp_unslash($Request['pageSize']) : 10;
1902 $queryCondition = isset($Request['queryCondition']) ? wp_unslash($Request['queryCondition']) : ['form_id' => $id];
1903 } else {
1904 $id = wp_unslash($post->id);
1905 $conditions = isset($post->conditions) ? wp_unslash($post->conditions) : [];
1906 $dateBetweenFilter = isset($post->entriesFilterByDate) ? wp_unslash($post->entriesFilterByDate) : [];
1907 $offset = isset($post->offset) ? wp_unslash($post->offset) : 0;
1908 $sortBy = isset($post->sortBy) ? wp_unslash($post->sortBy) : null;
1909 $filters = isset($post->filters) ? wp_unslash($post->filters) : null;
1910 $globalFilter = isset($post->globalFilter) ? wp_unslash($post->globalFilter) : null;
1911 $pageSize = isset($post->pageSize) ?
1912 wp_unslash($post->pageSize) : 10;
1913 $queryCondition = isset($post->queryCondition) ? wp_unslash($post->queryCondition) : ['form_id' => $id];
1914 }
1915 if (is_null($id)) {
1916 return new WP_Error('empty_form', __('Form id is empty.', 'bit-form'));
1917 }
1918 $formManager = new AdminFormManager($id);
1919 if (!$formManager->isExist()) {
1920 return new WP_Error('empty_form', __('Form does not exists', 'bit-form'));
1921 }
1922 $formEntry = new FormEntryModel();
1923 $entries = $formEntry->get(
1924 'id',
1925 $queryCondition,
1926 null,
1927 null,
1928 'created_at',
1929 'DESC'
1930 );
1931 if (is_wp_error($entries)) {
1932 if ('result_empty' === $entries->get_error_code()) {
1933 return [
1934 'count' => 0,
1935 'entries' => [],
1936 ];
1937 }
1938 return $entries;
1939 }
1940 $filter['field'] = $filters;
1941 $filter['global'] = $globalFilter;
1942
1943 $formFields = $formManager->getFieldLabel(true);
1944 $fieldDetails = $formManager->getFields();
1945
1946 $entryMeta = new FormEntryMetaModel();
1947 $formEntries = $entryMeta->getEntryMeta($formFields, $entries, $pageSize, $offset, $filter, $sortBy, $conditions, $dateBetweenFilter);
1948 $customFieldHandler = new CustomFieldHandler();
1949 $formEntries = $customFieldHandler->updatedEntries($formEntries, $fieldDetails);
1950 return $formEntries;
1951 }
1952
1953 public function getSingleEntry($formId, $entryId)
1954 {
1955 $formManager = new AdminFormManager($formId);
1956 if (!$formManager->isExist()) {
1957 return new WP_Error('empty_form', __('Form does not exists', 'bit-form'));
1958 }
1959
1960 $formFields = $formManager->getFieldLabel(true);
1961 $fieldDetails = $formManager->getFields();
1962 $entryMeta = new FormEntryMetaModel();
1963 // $formEntry = new FormEntryModel();
1964
1965 $entries = $entryMeta->getSingleEntryMeta($formFields, $entryId);
1966
1967 if (!is_wp_error($entries)) {
1968 return $entries[0];
1969 }
1970 return new WP_Error('entry_not_fonud', __('Entry Not Found!', 'bit-form'));
1971
1972 // $customFieldHandler = new CustomFieldHandler();
1973 // $formEntries = $customFieldHandler->updatedEntries($formEntries, $fieldDetails);
1974 // return $formEntries;
1975 }
1976
1977 public function getEntriesForReport($Request, $post)
1978 {
1979 if (!empty($Request['id'])) {
1980 $id = absint(wp_unslash($Request['id']));
1981 $offset = isset($Request['offset']) ?
1982 wp_unslash($Request['offset']) : null;
1983 $pageSize = isset($Request['pageSize']) ?
1984 wp_unslash($Request['pageSize']) : null;
1985 } else {
1986 $id = wp_unslash($post->id);
1987 $conditions = isset($post->conditions) ? wp_unslash($post->conditions) : [];
1988 $dateBetweenFilter = isset($post->entriesFilterByDate) ? wp_unslash($post->entriesFilterByDate) : [];
1989 $offset = isset($post->offset) ? wp_unslash($post->offset) : null;
1990 $sortBy = isset($post->sortBy) ? wp_unslash($post->sortBy) : null;
1991 $filters = isset($post->filters) ? wp_unslash($post->filters) : null;
1992 $globalFilter = isset($post->globalFilter) ? wp_unslash($post->globalFilter) : null;
1993 $pageSize = isset($post->pageSize) ?
1994 wp_unslash($post->pageSize) : null;
1995 }
1996 if (is_null($id)) {
1997 return new WP_Error('empty_form', __('Form id is empty.', 'bit-form'));
1998 }
1999 $formManager = new AdminFormManager($id);
2000 if (!$formManager->isExist()) {
2001 return new WP_Error('empty_form', __('Form does not exists', 'bit-form'));
2002 }
2003
2004 $formEntry = new FormEntryModel();
2005 $entries = $formEntry->get(
2006 'id',
2007 [
2008 'form_id' => $id,
2009 ],
2010 null,
2011 null,
2012 'created_at',
2013 'DESC'
2014 );
2015 if (is_wp_error($entries)) {
2016 if ('result_empty' === $entries->get_error_code()) {
2017 return [
2018 'count' => 0,
2019 'entries' => [],
2020 ];
2021 }
2022 return $entries;
2023 }
2024 $filter['field'] = $filters;
2025 $filter['global'] = $globalFilter;
2026
2027 $formFields = $formManager->getFieldLabel(true);
2028 $fieldDetails = $formManager->getFields();
2029
2030 $entryMeta = new FormEntryMetaModel();
2031 $formEntries = $entryMeta->getEntryMeta($formFields, $entries, $pageSize, $offset, $filter, $sortBy, $conditions, $dateBetweenFilter);
2032 $customFieldHandler = new CustomFieldHandler();
2033 $formEntries = $customFieldHandler->updatedEntries($formEntries, $fieldDetails);
2034 $formEntries['entries'] = Helpers::filterNullEntries($formEntries['entries']);
2035 return $formEntries;
2036 }
2037
2038 public function getExportEntry($post)
2039 {
2040 $formId = wp_unslash($post->formId);
2041 $fileFormate = isset($post->fileFormate) ? wp_unslash($post->fileFormate) : null;
2042 $limit = isset($post->limit) ? wp_unslash($post->limit) : null;
2043 $entryCondition = isset($post->filter) ? wp_unslash($post->filter) : null;
2044 $sortBy = isset($post->sort) ? wp_unslash($post->sort) : 'ASC';
2045 $sortByField = isset($post->sortField) ? wp_unslash($post->sortField) : 'bitforms_form_entry_id';
2046 $formFields = json_decode($post->selectedField);
2047 if (is_null($formId)) {
2048 return new WP_Error('empty_form', __('Form id is empty.', 'bit-form'));
2049 }
2050 $formManager = new AdminFormManager($formId);
2051 $fieldLabels = $formManager->getFieldLabel(true);
2052 if (!$formManager->isExist()) {
2053 return new WP_Error('empty_form', __('Form does not exists', 'bit-form'));
2054 }
2055
2056 $formEntry = new FormEntryModel();
2057 $entries = $formEntry->get(
2058 'id',
2059 [
2060 'form_id' => $formId,
2061 ],
2062 null,
2063 null,
2064 'created_at',
2065 'DESC'
2066 );
2067 if (is_wp_error($entries)) {
2068 if ('result_empty' === $entries->get_error_code()) {
2069 return [
2070 'count' => 0,
2071 'entries' => [],
2072 ];
2073 }
2074 return $entries;
2075 }
2076 $entryMeta = new FormEntryMetaModel();
2077 $filter = [];
2078 $formEntries = $entryMeta->getExportEntry($formFields, $entries, $formId, $fieldLabels, $limit, $sortBy, $sortByField, $offset, $entryCondition);
2079 return $formEntries;
2080 }
2081
2082 public function deleteBlukFormEntries($Request, $post)
2083 {
2084 if (!empty($Request['formID'])) {
2085 $formID = absint(wp_unslash($Request['formID']));
2086 $entries = array_map('absint', wp_unslash($Request['entries']));
2087 } else {
2088 $formID = wp_unslash($post->formID);
2089 $entries = wp_unslash($post->entries);
2090 }
2091 if (is_null($formID) || !is_array($entries) || 0 === count($entries)) {
2092 return new WP_Error('empty_form', __('Invalid Form ID or Entries ID.', 'bit-form'));
2093 }
2094
2095 if (!filter_var($formID, FILTER_VALIDATE_INT)) {
2096 return new WP_Error('invalid_form', __('Form id is invalid.', 'bit-form'));
2097 }
2098
2099 if (!Helpers::checkIsIntArr($entries)) {
2100 return new WP_Error('invalid_entries', __('Entries id is invalid', 'bit-form'));
2101 }
2102
2103 $formManager = new AdminFormManager($formID);
2104 if (!$formManager->isExist()) {
2105 return new WP_Error('empty_form', __('Form does not exist.', 'bit-form'));
2106 }
2107 $workFlowRunHelper = new WorkFlow($formID);
2108
2109 $workFlowreturnedOnDelete = $workFlowRunHelper->executeOnDelete(
2110 $formManager,
2111 $formID,
2112 $entries
2113 );
2114
2115 if (isset($workFlowreturnedOnDelete['entries'])) {
2116 if (0 === count($workFlowreturnedOnDelete['entries'])) {
2117 return ['message' => __('Entry Deletetion prevented by workflow', 'bit-form')];
2118 } elseif (count($workFlowreturnedOnDelete['entries']) === count($entries)) {
2119 $message = __('Entry Deleted successfully', 'bit-form');
2120 } else {
2121 $result['prevented'] = array_diff($entries, $workFlowreturnedOnDelete['entries']);
2122 $entries = $workFlowreturnedOnDelete['entries'];
2123 $message = __('Entry Deleted successfully, Some prevented by workflow', 'bit-form');
2124 }
2125 } else {
2126 $message = __('Entry Deleted successfully', 'bit-form');
2127 }
2128 global $wpdb;
2129 $prefix = $wpdb->prefix;
2130 $formEntryModel = new FormEntryModel();
2131 $delete_status = $formEntryModel->bulkDelete(
2132 [
2133 "`{$prefix}bitforms_form_entries`.`id`" => $entries,
2134 "`{$prefix}bitforms_form_entries`.`form_id`" => $formID,
2135 ]
2136 );
2137 if (file_exists(BITFORMS_UPLOAD_DIR . DIRECTORY_SEPARATOR . $formID)) {
2138 $fileHandler = new FileHandler();
2139 foreach ($entries as $enrtyKey => $entryID) {
2140 $fileEntries = $fileHandler->getEntriesFileUploadDir($formID, $entryID);
2141 if (file_exists($fileEntries)) {
2142 $fileHandler->rmrf($fileEntries);
2143 }
2144 }
2145 }
2146 $count = $formEntryModel->count(
2147 [
2148 'form_id' => $formID,
2149 ]
2150 );
2151 $formManager->resetSubmissionCount(intval($count[0]->count));
2152 if (is_wp_error($delete_status)) {
2153 return new WP_Error('entry_not_exists', __('Form entry deletion failed.', 'bit-form'));
2154 }
2155 $result['message'] = $message;
2156 return $result;
2157 }
2158
2159 public function duplicateFormEntry($Request, $post)
2160 {
2161 if (!empty($Request['formID'])) {
2162 $formID = absint(wp_unslash($Request['formID']));
2163 $entries = array_map('absint', wp_unslash($Request['entries']));
2164 } else {
2165 $formID = wp_unslash($post->formID);
2166 $entries = wp_unslash($post->entries);
2167 }
2168 if (is_null($formID) || !is_array($entries) || empty($entries)) {
2169 return new WP_Error('empty_form', __('Form id or entries id is invalid', 'bit-form'));
2170 }
2171
2172 if (!filter_var($formID, FILTER_VALIDATE_INT)) {
2173 return new WP_Error('invalid_form', __('Form id is invalid', 'bit-form'));
2174 }
2175
2176 if (!Helpers::checkIsIntArr($entries)) {
2177 return new WP_Error('invalid_entries', __('Entries id is invalid', 'bit-form'));
2178 }
2179
2180 $formManager = new AdminFormManager($formID);
2181 if (!$formManager->isExist()) {
2182 return new WP_Error('empty_form', __('Form does not exist', 'bit-form'));
2183 }
2184 $formEntryModel = new FormEntryModel();
2185 $entryMeta = new FormEntryMetaModel();
2186 $user_details = static::$ipTool->getUserDetail();
2187 $total_entries = count($entries);
2188 $duplicate_count = 0;
2189 $test = '';
2190 $fileHandler = new FileHandler();
2191 $result = [];
2192 foreach ($entries as $entryIndex => $entryID) {
2193 $duplicatedEntryId = $formEntryModel->insert(
2194 [
2195 'form_id' => $formID,
2196 'user_id' => $user_details['id'],
2197 'user_ip' => $user_details['ip'],
2198 'user_device' => $user_details['device'],
2199 'referer' => 'duplicate of #' . $entryID,
2200 'status' => 1,
2201 'created_at' => $user_details['time'],
2202 ]
2203 );
2204 if ($duplicatedEntryId) {
2205 $duplicate_status = $entryMeta->duplicateEntryMeta(
2206 [
2207 'duplicateID' => $duplicatedEntryId,
2208 'entryID' => $entryID,
2209 ]
2210 );
2211 if ($duplicate_status) {
2212 $result['details'][$entryID] = $duplicatedEntryId;
2213 $duplicate_count = $duplicate_count + 1;
2214 if (file_exists(FileHandler::getEntriesFileUploadDir($formID, $entryID))) {
2215 $fileHandler->cpyr(
2216 FileHandler::getEntriesFileUploadDir($formID, $entryID),
2217 FileHandler::getEntriesFileUploadDir($formID, $duplicatedEntryId)
2218 );
2219 }
2220 }
2221 }
2222 }
2223
2224 $count = $formEntryModel->count(
2225 [
2226 'form_id' => $formID,
2227 ]
2228 );
2229 $formManager->resetSubmissionCount(intval($count[0]->count));
2230 $result['message'] = 1 === count($entries) ? __('Entry Duplicated successfully', 'bit-form') : __('Entries Duplicated successfully', 'bit-form');
2231 return ($total_entries === $duplicate_count) ? $result : false;
2232 }
2233
2234 public function editFormEntry($Request, $post)
2235 {
2236 if (!empty($Request['formID'])) {
2237 $formID = absint(wp_unslash($Request['formID']));
2238 $entryID = absint(wp_unslash($Request['entryID']));
2239 } else {
2240 $formID = wp_unslash($post->formID);
2241 $entryID = wp_unslash($post->entryID);
2242 }
2243 if (is_null($formID) || is_null($entryID)) {
2244 return new WP_Error('empty_form', __('Form id or entries id is invalid', 'bit-form'));
2245 }
2246
2247 $formManager = new AdminFormManager($formID);
2248 if (!$formManager->isExist()) {
2249 return new WP_Error('empty_form', __('Form does not exist', 'bit-form'));
2250 }
2251 $formEntryModel = new FormEntryModel();
2252 $entryMeta = new FormEntryMetaModel();
2253
2254 $formEntry = $formEntryModel->get(
2255 '*',
2256 [
2257 'form_id' => $formID,
2258 'id' => $entryID,
2259 ]
2260 );
2261
2262 if (!$formEntry) {
2263 return new WP_Error('empty_form', __('Form entries does not exist.', 'bit-form'));
2264 }
2265 $formEntryMeta = $entryMeta->get(
2266 [
2267 'meta_key',
2268 'meta_value',
2269 ],
2270 [
2271 'bitforms_form_entry_id' => $entryID,
2272 ]
2273 );
2274 $entries = [];
2275 foreach ($formEntryMeta as $key => $value) {
2276 $entries[$value->meta_key] = $value->meta_value;
2277 }
2278 $formContent = $formManager->getFormContent();
2279 $fieldsKey = $formManager->getFieldsKey();
2280 $form_fields = $formContent->fields;
2281 $layout = $formContent->layout;
2282 foreach ($form_fields as $key => $value) {
2283 // $field_name = preg_replace('/[\`\~\!\@\#\$\'\.\s\?\+\-\*\&\|\/\\!]/', '_', $value->lbl);
2284 if (isset($entries[$key])) {
2285 $form_fields->{$key}->val = $entries[$key];
2286 $form_fields->{$key}->name = $key;
2287 }
2288 }
2289 $workFlowRunHelper = new WorkFlow($formID);
2290 $workFlowreturnedOnLoad = $workFlowRunHelper->executeOnLoad(
2291 'edit',
2292 $form_fields
2293 );
2294 $workFlowreturnedOnUserInput = $workFlowRunHelper->executeOnUserInput(
2295 'edit',
2296 $form_fields
2297 );
2298 if (!empty($workFlowreturnedOnLoad['fields'])) {
2299 $form_fields = $workFlowreturnedOnLoad['fields'];
2300 }
2301 $formData = [
2302 'layout' => $layout,
2303 'fields' => $form_fields,
2304 'conditional' => !empty($workFlowreturnedOnUserInput['conditional']) ? $workFlowreturnedOnUserInput['conditional'] : false,
2305 'fieldToCheck' => !empty($workFlowreturnedOnUserInput['fieldToCheck']) ? $workFlowreturnedOnUserInput['fieldToCheck'] : false,
2306 'fieldToChange' => !empty($workFlowreturnedOnUserInput['fieldToChange']) ? $workFlowreturnedOnUserInput['fieldToChange'] : false,
2307 'fieldsKey' => $fieldsKey,
2308 ];
2309 return $formData;
2310 }
2311
2312 public function updateFormEntry($Request, $post)
2313 {
2314 if (isset($Request['formID'], $Request['entryID'])) {
2315 $formID = absint(wp_unslash($Request['formID']));
2316 $entryID = absint(wp_unslash($Request['entryID']));
2317 unset($Request['action'], $Request['formID'], $Request['entryID']);
2318 }
2319 $formManager = new AdminFormManager($formID);
2320 $formManager->fieldNameReplaceOfPost();
2321 // Called from AdminAjax handler; nonce already verified at AJAX entry before dispatch.
2322 $updatedValue = is_array($post) ? $post : wp_unslash($_POST);
2323
2324 if (is_null($updatedValue) || !is_array($updatedValue)) {
2325 return new WP_Error('empty_data', __('Failed to update, Data is empty.', 'bit-form'));
2326 }
2327
2328 if (is_null($formID) || is_null($entryID)) {
2329 return new WP_Error('empty_data', __('Invalid Form ID or entries ID.', 'bit-form'));
2330 }
2331
2332 if (!$formManager->isExist()) {
2333 return new WP_Error('empty_data', __('Form does not exist.', 'bit-form'));
2334 }
2335 return $formManager->updateFormEntry($updatedValue, $formID, $entryID);
2336 }
2337
2338 public function getLogHistory($Request, $post)
2339 {
2340 if (!empty($Request['formID'])) {
2341 $formID = absint(wp_unslash($Request['formID']));
2342 $entryID = absint(wp_unslash($Request['entryID']));
2343 } else {
2344 $formID = wp_unslash($post->formID);
2345 $entryID = wp_unslash($post->entryID);
2346 }
2347
2348 if (is_null($formID) || is_null($entryID)) {
2349 return new WP_Error('empty_form', __('Invalid Form ID or Entries ID.', 'bit-form'));
2350 }
2351
2352 $formManager = new AdminFormManager($formID);
2353 if (!$formManager->isExist()) {
2354 return new WP_Error('empty_form', __('Form does not exist.', 'bit-form'));
2355 }
2356 $formLogModel = new FormEntryLogModel();
2357
2358 $log_history = $formLogModel->geLogHistory($formID, $entryID);
2359 return $log_history;
2360 }
2361
2362 public function importDataStore($Request, $post)
2363 {
2364 if (!empty($Request['formID'])) {
2365 $formID = absint(wp_unslash($Request['formID']));
2366 } else {
2367 $formID = wp_unslash($post->formID);
2368 }
2369 if (is_null($formID)) {
2370 return new WP_Error('empty_form', __('Invalid Form id or entries id.', 'bit-form'));
2371 }
2372 }
2373
2374 public function getAllWPPages($Request, $post)
2375 {
2376 $pages = get_pages(['post_status' => 'publish', 'sort_column' => 'post_date', 'sort_order' => 'desc']);
2377 $allPages = [];
2378 foreach ($pages as $pageKey => $pageDetails) {
2379 // $allPages[$pageKey]['title'] = $pageDetails->post_title;
2380 // $allPages[$pageKey]['url'] = get_page_link($pageDetails->ID);
2381 $allPages[] = (object) [
2382 'title' => $pageDetails->post_title,
2383 'url' => get_page_link($pageDetails->ID)
2384 ];
2385 }
2386 return $allPages;
2387 }
2388
2389 public function deleteAIntegration($Request, $post)
2390 {
2391 if (!empty($Request['formID']) && !empty($Request['id'])) {
2392 $formID = absint(json_decode(wp_unslash($Request['formID'])));
2393 $id = absint(wp_unslash($Request['id']));
2394 } else {
2395 $formID = wp_unslash($post->formID);
2396 $id = wp_unslash($post->id);
2397 }
2398 if ($formID < 0 || empty($id)) {
2399 return new WP_Error('empty_form', 'Invalid Form ID or Integration ID.');
2400 }
2401
2402 $integrationHandler = new IntegrationHandler($formID);
2403 $delete_status = $integrationHandler->deleteIntegration($id);
2404 if (is_wp_error($delete_status)) {
2405 return $delete_status;
2406 }
2407
2408 return [
2409 'message' => __('Integration deleted', 'bit-form'),
2410 ];
2411 }
2412
2413 public function deleteSuccessMessage($Request, $post)
2414 {
2415 if (!empty($Request['formID']) && !empty($Request['id'])) {
2416 $formID = absint(json_decode(wp_unslash($Request['formID'])));
2417 $id = absint(wp_unslash($Request['id']));
2418 } else {
2419 $formID = wp_unslash($post->formID);
2420 $id = wp_unslash($post->id);
2421 }
2422 if (empty($formID) || empty($id)) {
2423 return new WP_Error('empty_form', 'Invalid Form ID or Message ID.');
2424 }
2425 $successMessageHandler
2426 = new SuccessMessageHandler($formID);
2427 $delete_status = $successMessageHandler->deleteMessage($id);
2428 if (is_wp_error($delete_status)) {
2429 return $delete_status;
2430 }
2431 return [
2432 'message' => __('Message deleted', 'bit-form'),
2433 ];
2434 }
2435
2436 public function deleteAWorkflow($Request, $post)
2437 {
2438 if (!empty($Request['formID']) && !empty($Request['id'])) {
2439 $formID = absint(json_decode(wp_unslash($Request['formID'])));
2440 $id = absint(wp_unslash($Request['id']));
2441 } else {
2442 $formID = wp_unslash($post->formID);
2443 $id = wp_unslash($post->id);
2444 }
2445 if (empty($formID) || empty($id)) {
2446 return new WP_Error('empty_form', 'Invalid Form ID or Workflow ID.');
2447 }
2448 $workFlowHandler = new WorkFlowHandler($formID);
2449 $delete_status = $workFlowHandler->deleteworkFlow($id);
2450 if (is_wp_error($delete_status)) {
2451 return $delete_status;
2452 }
2453 return [
2454 'message' => __('workflow deleted', 'bit-form'),
2455 ];
2456 }
2457
2458 public function deleteAMailTemplate($Request, $post)
2459 {
2460 if (!empty($Request['formID']) && !empty($Request['id'])) {
2461 $formID = absint(json_decode(wp_unslash($Request['formID'])));
2462 $id = absint(wp_unslash($Request['id']));
2463 } else {
2464 $formID = wp_unslash($post->formID);
2465 $id = wp_unslash($post->id);
2466 }
2467 if (empty($formID) || empty($id)) {
2468 return new WP_Error('empty_form', 'Invalid Form ID or Email Template ID.');
2469 }
2470 $emailTemplateHandler = new EmailTemplateHandler($formID);
2471 $delete_status = $emailTemplateHandler->deleteTemplate($id);
2472 if (is_wp_error($delete_status)) {
2473 return $delete_status;
2474 }
2475 return [
2476 'message' => __('Email Template deleted', 'bit-form'),
2477 ];
2478 }
2479
2480 public function duplicateAMailTemplate($Request, $post)
2481 {
2482 if (!empty($Request['formID']) && !empty($Request['id'])) {
2483 $formID = absint(json_decode(wp_unslash($Request['formID'])));
2484 $id = absint(wp_unslash($Request['id']));
2485 } else {
2486 $formID = wp_unslash($post->formID);
2487 $id = wp_unslash($post->id);
2488 }
2489 if (empty($formID) || empty($id)) {
2490 return new WP_Error('empty_form', 'Invalid Form ID or Email Template ID.');
2491 }
2492
2493 if (false === filter_var($id, FILTER_VALIDATE_INT)) {
2494 return new WP_Error('empty_form', 'Invalid Email Template ID.');
2495 }
2496
2497 if (false === filter_var($formID, FILTER_VALIDATE_INT)) {
2498 return new WP_Error('empty_form', 'Invalid Form ID.');
2499 }
2500
2501 $emailTemplateHandler = new EmailTemplateHandler($formID);
2502 $duplicate_status = $emailTemplateHandler->duplicateTemplate($id);
2503 if (is_wp_error($duplicate_status)) {
2504 return $duplicate_status;
2505 }
2506 return [
2507 'message' => __('Email Template duplicated', 'bit-form'),
2508 ];
2509 }
2510
2511 public function setAllFormsReport($Request, $post)
2512 {
2513 $reports = empty($post->reports) ? null : wp_unslash($post->reports);
2514 if (empty($reports)) {
2515 return new WP_Error('empty_report_prefs', 'Report data is Empty, nothing to save or update.');
2516 }
2517 if (!empty($reports)) {
2518 $reportsModel = new ReportsModel();
2519 $user_details = static::$ipTool->getUserDetail();
2520 foreach ($reports as $reportIndex => $report) {
2521 if (empty($report->id)) {
2522 $reportSaveSatus = $reportsModel->insert(
2523 [
2524 'type' => 'table',
2525 'category' => 'app',
2526 'context' => 'allForm',
2527 'details' => is_string($report->details) ? $report->details : wp_json_encode($report->details),
2528 'isDefault' => 1,
2529 'user_id' => $user_details['id'],
2530 'user_ip' => $user_details['ip'],
2531 'user_device' => $user_details['device'],
2532 'created_at' => $user_details['time'],
2533 'updated_at' => $user_details['time'],
2534 ]
2535 );
2536 $newData['reports'] = 1;
2537 } else {
2538 $reportSaveSatus = $reportsModel->update(
2539 [
2540 'type' => 'table',
2541 'category' => 'app',
2542 'context' => 'allForm',
2543 'details' => is_string($report->details) ? $report->details : wp_json_encode($report->details),
2544 'isDefault' => 1,
2545 'user_id' => $user_details['id'],
2546 'user_ip' => $user_details['ip'],
2547 'user_device' => $user_details['device'],
2548 'updated_at' => $user_details['time'],
2549 ],
2550 [
2551 'id' => $report->id,
2552 ]
2553 );
2554 }
2555 }
2556 }
2557 if (is_wp_error($reportSaveSatus)) {
2558 if ('result_empty' === $reportSaveSatus->get_error_code()) {
2559 return new WP_Error('empty_report_prefs', 'Nothing to save or update');
2560 }
2561 return new WP_Error('error_report_prefs', 'Error occured in saving reports');
2562 }
2563 $returnedReportData = $reportsModel->get(
2564 [
2565 'id',
2566 'details',
2567 'isDefault',
2568 'category',
2569 'context',
2570 ],
2571 [
2572 'category' => 'app',
2573 'context' => 'allForm',
2574 ]
2575 );
2576 if (!is_wp_error($returnedReportData)) {
2577 foreach ($returnedReportData as $reportKey => $reportData) {
2578 if (isset($reportData->details) && is_string($reportData->details)) {
2579 $returnedReportData[$reportKey]->details = json_decode($reportData->details);
2580 }
2581 }
2582 $reports = $returnedReportData;
2583 }
2584 return [
2585 'message' => __('Report preferrences saved successfully', 'bit-form'),
2586 'reports' => empty($reports) ? [] : $reports,
2587 ];
2588 }
2589
2590 public function savegReCaptcha($Request, $post)
2591 {
2592 $reCaptcha = $post->reCaptcha;
2593
2594 if (is_null($reCaptcha)) {
2595 return new WP_Error('empty_gcaptchdetails', __('g-ReCAPTCHA details is empty', 'bit-form'));
2596 }
2597 if (is_string($reCaptcha) && !empty(json_decode($reCaptcha)->id)) {
2598 $reCaptcha = json_decode($reCaptcha);
2599 $integrationID = $reCaptcha->id;
2600 unset($reCaptcha->id);
2601 } else {
2602 $integrationID = $reCaptcha->id;
2603 unset($reCaptcha->id);
2604 }
2605 $reCaptcha = wp_json_encode($reCaptcha);
2606
2607 // $integrationName = 'google reCaptcha';
2608 $integrationName = $post->integrationName;
2609
2610 // $integrationType = 'v2' === $post->version ? 'gReCaptcha' : 'gReCaptchaV3';
2611 $integrationType = $post->integrationType;
2612
2613 $integrationDetails = $reCaptcha;
2614 $user_details = static::$ipTool->getUserDetail();
2615 $integrationHandler = new IntegrationHandler(0, $user_details);
2616 $response = [];
2617 if (empty($integrationID)) {
2618 $captchaSaveStatus = $integrationHandler->saveIntegration($integrationName, $integrationType, $integrationDetails, 'app');
2619 $response['id'] = $captchaSaveStatus;
2620 $response['message'] = __('reCAPTCHA saved successfully', 'bit-form');
2621 } else {
2622 $captchaSaveStatus = $integrationHandler->updateIntegration($integrationID, $integrationName, $integrationType, $integrationDetails, 'app');
2623 $response['message'] = __('reCAPTCHA updated successfully', 'bit-form');
2624 }
2625
2626 if (is_wp_error($captchaSaveStatus)) {
2627 return $captchaSaveStatus;
2628 }
2629 return $response;
2630 }
2631
2632 public function savePaymentSetting($Request, $post)
2633 {
2634 if (isset($post->paySetting)) {
2635 $paySetting = $post->paySetting;
2636 }
2637 if (is_null($paySetting)) {
2638 return new WP_Error('empty_gcaptchdetails', __('Setting details is empty', 'bit-form'));
2639 }
2640 if (is_string($paySetting)) {
2641 $paySetting = json_decode($paySetting);
2642 }
2643
2644 $canSave = null;
2645 switch ($paySetting->type) {
2646 case 'PayPal':
2647 $canSave = $this->addWebhookToPaypal($paySetting);
2648 break;
2649 case 'Razorpay':
2650 $canSave = true;
2651 break;
2652 case 'Stripe':
2653 $canSave = $this->addWebhookToStripe($paySetting);
2654 break;
2655 case 'Mollie':
2656 $canSave = true;
2657 break;
2658 default:
2659 $canSave = null;
2660 }
2661 if (is_null($canSave)) {
2662 return new WP_Error('stripe', __('Please re-check your Client ID & Secret', 'bit-form'));
2663 }
2664 $integrationID = null;
2665 if (isset($paySetting->id)) {
2666 $integrationID = $paySetting->id;
2667 unset($paySetting->id);
2668 }
2669 $integrationName = $paySetting->name;
2670 $integrationType = 'payments';
2671 $paySetting = wp_json_encode($paySetting);
2672 $integrationDetails = $paySetting;
2673 $user_details = static::$ipTool->getUserDetail();
2674 $integrationHandler = new IntegrationHandler(0, $user_details);
2675 $response = [];
2676 if (empty($integrationID)) {
2677 $paymentSaveStatus = $integrationHandler->saveIntegration($integrationName, $integrationType, $integrationDetails, 'app');
2678 $response['id'] = $paymentSaveStatus;
2679 $response['message'] = __('Payment setting saved successfully', 'bit-form');
2680 } else {
2681 $paymentSaveStatus = $integrationHandler->updateIntegration($integrationID, $integrationName, $integrationType, $integrationDetails, 'app');
2682 $response['message'] = __('Payment setting updated successfully', 'bit-form');
2683 }
2684
2685 if (is_wp_error($paymentSaveStatus)) {
2686 return $paymentSaveStatus;
2687 }
2688 return $response;
2689 }
2690
2691 private function addWebhookToPaypal($paySetting)
2692 {
2693 $transaction_mode = $paySetting->mode;
2694 $clientId = $paySetting->clientID;
2695 $clientSecret = $paySetting->clientSecret;
2696 $base_url = 'sandbox' === $transaction_mode ? 'https://api-m.sandbox.paypal.com' : 'https://api.paypal.com';
2697 // get all webhooks
2698 $webhooks_url = $base_url . '/v1/notifications/webhooks';
2699 $webhooks_headers = [
2700 'Content-Type' => 'application/json',
2701 'Authorization' => 'Basic ' . base64_encode($clientId . ':' . $clientSecret)
2702 ];
2703 $webhook_url = get_rest_url() . 'bitform/v1/payments/paypal';
2704 // adding webhook
2705 $data = [
2706 'url' => $webhook_url,
2707 'event_types' => [
2708 [
2709 'name' => 'CHECKOUT.ORDER.APPROVED'
2710 ]
2711 ]
2712 ];
2713 $webhook_response = HttpHelper::post($webhooks_url, wp_json_encode($data), $webhooks_headers);
2714 if (is_wp_error($webhook_response) || $webhook_response->error) {
2715 return null;
2716 }
2717 return true;
2718 }
2719
2720 private function addWebhookToStripe($paySetting)
2721 {
2722 $clientSecret = $paySetting->clientSecret;
2723
2724 $create_webhook_url = 'https://api.stripe.com/v1/webhook_endpoints';
2725 $headers = [
2726 'Content-Type' => 'application/x-www-form-urlencoded',
2727 'Authorization' => "Bearer $clientSecret",
2728 ];
2729
2730 $webhook_url = get_rest_url() . 'bitform/v1/payments/stripe';
2731
2732 $apiResponse = HttpHelper::get($create_webhook_url, '', $headers);
2733
2734 if (isset($apiResponse->error)) {
2735 return null;
2736 }
2737 $webhookList = $apiResponse->data;
2738 $webhook_already_exist = false;
2739
2740 foreach ($webhookList as $webhook) {
2741 if ($webhook->url === $webhook_url) {
2742 $webhook_already_exist = true;
2743 break;
2744 }
2745 }
2746
2747 $data = [
2748 'enabled_events[]' => 'payment_intent.succeeded',
2749 'url' => $webhook_url,
2750 ];
2751
2752 if (!$webhook_already_exist) {
2753 $webhook_response = HttpHelper::post($create_webhook_url, $data, $headers);
2754 if (is_wp_error($webhook_response) || (isset($webhook_response->error) && $webhook_response->error)) {
2755 Log::debug_log(['Stripe webhook creation failed' => $webhook_response]);
2756 return null;
2757 }
2758 }
2759 return true;
2760 }
2761
2762 public function builerHelperState($formId)
2763 {
2764 $data = static::$formModel->get(
2765 ['id', 'builder_helper_state'],
2766 ['id' => $formId]
2767 );
2768
2769 if (!is_wp_error($data)) {
2770 foreach ($data as $key => $value) {
2771 if (isset($value->builder_helper_state) && is_string($value->builder_helper_state)) {
2772 $data[$key]->builder_helper_state = json_decode($value->builder_helper_state);
2773 }
2774 }
2775 }
2776
2777 return $data;
2778 }
2779
2780 public function updateGeneratedScriptPageIds()
2781 {
2782 $updateData = [
2783 'generated_script_page_ids' => \wp_json_encode((object) []),
2784 ];
2785 $update_status = static::$formModel->update(
2786 $updateData,
2787 [
2788 'status' => 1
2789 ]
2790 );
2791 if (is_wp_error($update_status)) {
2792 return $update_status;
2793 } elseif (!$update_status) {
2794 return new WP_Error('empty_form', __('Form update failed.', 'bit-form'));
2795 } else {
2796 return true;
2797 }
2798 }
2799
2800 public function replaceAllFormsErrorMessagesByGlobalMessages()
2801 {
2802 try {
2803 $formModel = new FormModel();
2804 $allForms = $formModel->get(['id', 'form_content']);
2805
2806 foreach ($allForms as $form) {
2807 // Decode form_content JSON to stdClass
2808 $formContent = \json_decode($form->form_content);
2809 $fields = $formContent->fields ?? null;
2810 // If decode fails, skip to next
2811 if (!$fields) {
2812 Log::debug_log("Form ID {$form->id}: invalid JSON in form_content");
2813 continue;
2814 }
2815
2816 // Replace default error messages using your helper
2817 $updatedFields = Helpers::replaceFieldsDefaultErrorMsg($fields);
2818
2819 $formContent->fields = $updatedFields;
2820 // Encode back to JSON
2821 $updatedContent = \json_encode($formContent);
2822
2823 if (false === $updatedContent) {
2824 Log::debug_log("Form ID {$form->id}: JSON encoding failed");
2825 continue;
2826 }
2827 // Update form content in DB
2828 $formModel->update(
2829 ['form_content' => $updatedContent], // data to update
2830 ['id' => $form->id] // condition for update
2831 );
2832 }
2833 } catch (\Exception $e) {
2834 Log::debug_log([
2835 'message' => 'Error in updateAllFormsErrorMessagesWithGlobalMessages',
2836 'error' => $e->getMessage(),
2837 ]);
2838 }
2839 }
2840
2841 public function updateSuccessMessageClassName($str, $msgIdx, $msgId)
2842 {
2843 $TEMP_CONF_ID = '_tmp_' . $msgIdx . '_conf_id';
2844 return str_replace($TEMP_CONF_ID, $msgId, $str);
2845 }
2846
2847 public function startMigrationProcess()
2848 {
2849 Utilities::duplicateDbTable('form', 'form_v1');
2850 Utilities::duplicateDbTable('workflows', 'workflows_v1');
2851 Utilities::duplicateDbTable('success_messages', 'success_messages_v1');
2852 MigrationHelper::duplicateV1StyleFiles();
2853 $all_forms = $this->getAllForm();
2854 $v1FormContents = [];
2855 $defaultStyleClass = MigrationHelper::getBitformDefaultStyleClass();
2856 foreach ($all_forms as $form) {
2857 $formContents = $this->getAFormV1(['id' => $form->id], ['id' => $form->id]);
2858 $v1FormContents[] = $formContents;
2859 FrontEndScriptGenerator::saveCssFile("{$form->id}", $defaultStyleClass);
2860 FrontEndScriptGenerator::saveCssFile("{$form->id}-formid", $defaultStyleClass);
2861 }
2862 set_transient('bitforms_v1_form_contents', $v1FormContents);
2863 update_option('bitforms_migrating_to_v2', true);
2864 }
2865 }
2866