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