_user_details = $user_details; } public function getAIntegration($integrationID, $integrationCategory = null, $integrationType = null) { $conditions = [ 'form_id' => static::$_formID, 'id' => $integrationID, ]; if (!is_null($integrationType)) { $conditions = array_merge($conditions, ['integration_type' => $integrationType]); } if (!is_null($integrationCategory)) { $conditions = array_merge($conditions, ['category' => $integrationCategory]); } return static::$_integrationModel->get( [ 'id', 'integration_name', 'integration_type', 'integration_details', 'form_id', ], $conditions ); } public function getAllIntegration($integrationCategory = null, $integrationType = null, $status = null, $id = null) { $conditions = [ 'form_id' => static::$_formID, ]; if (!is_null($integrationType)) { $conditions = array_merge($conditions, ['integration_type' => $integrationType]); } if (!is_null($integrationCategory)) { $conditions = array_merge($conditions, ['category' => $integrationCategory]); } if (!is_null($status)) { $conditions = array_merge($conditions, ['status' => 1]); } if (!is_null($id)) { $conditions = array_merge($conditions, ['id' => $id]); } return static::$_integrationModel->get( [ 'id', 'form_id', 'integration_name', 'integration_type', 'integration_details', 'status', ], $conditions ); } public function getIntegrationWithoutFormId($integrationCategory = null, $integrationType = null, $status = null, $id = null) { $conditions = []; if (!is_null($integrationType)) { $conditions = array_merge($conditions, ['integration_type' => $integrationType]); } if (!is_null($integrationCategory)) { $conditions = array_merge($conditions, ['category' => $integrationCategory]); } if (!is_null($status)) { $conditions = array_merge($conditions, ['status' => 1]); } if (!is_null($id)) { $conditions = array_merge($conditions, ['id' => $id]); } return static::$_integrationModel->get( [ 'id', 'form_id', 'integration_name', 'integration_type', 'integration_details', 'status', ], $conditions ); } public function saveIntegration($integrationName, $integrationType, $integrationDetails, $integrationCategory, $status = null) { if (null === $status) { $status = 1; } return static::$_integrationModel->insert( [ 'integration_name' => $integrationName, 'integration_type' => $integrationType, 'integration_details' => $integrationDetails, 'category' => $integrationCategory, 'form_id' => static::$_formID, 'user_id' => $this->_user_details['id'], 'user_ip' => $this->_user_details['ip'], 'status' => $status, 'created_at' => $this->_user_details['time'], 'updated_at' => $this->_user_details['time'], ] ); } public function updateIntegration($integrationID, $integrationName, $integrationType, $integrationDetails, $integrationCategory, $status = null) { if (null === $status) { $status = 1; } return static::$_integrationModel->update( [ 'integration_name' => $integrationName, 'integration_type' => $integrationType, 'integration_details' => $integrationDetails, 'category' => $integrationCategory, 'form_id' => static::$_formID, 'user_id' => $this->_user_details['id'], 'user_ip' => $this->_user_details['ip'], 'status' => $status, 'updated_at' => $this->_user_details['time'], ], [ 'id' => $integrationID, ] ); } public function duplicateAllInAForm($oldFormId) { $integCols = ['integration_name', 'integration_type', 'integration_details', 'category', 'form_id', 'user_id', 'user_ip', 'status', 'created_at', 'updated_at']; $integDupData = [ 'integration_name', 'integration_type', 'integration_details', 'category', static::$_formID, $this->_user_details['id'], $this->_user_details['ip'], 'status', $this->_user_details['time'], $this->_user_details['time'], ]; return static::$_integrationModel->duplicate($integCols, $integDupData, ['form_id' => $oldFormId]); } public function deleteIntegration($integrationID) { return static::$_integrationModel->delete( [ 'id' => $integrationID, 'form_id' => static::$_formID, ] ); } public static function replaceFieldWithValue($dataToReplaceField, $fieldValues) { if (empty($dataToReplaceField)) { return false; } if (is_string($dataToReplaceField)) { $dataToReplaceField = static::replaceFieldWithValueHelper($dataToReplaceField, $fieldValues); } elseif (is_array($dataToReplaceField)) { foreach ($dataToReplaceField as $field => $value) { if (is_array($value) && 1 === count($value)) { $dataToReplaceField[$field] = static::replaceFieldWithValueHelper($value[0], $fieldValues); } elseif (is_array($value)) { $dataToReplaceField[$field] = static::replaceFieldWithValue($value, $fieldValues); } else { $dataToReplaceField[$field] = static::replaceFieldWithValueHelper($value, $fieldValues); } } } return $dataToReplaceField; } private static function replaceFieldWithValueHelper($stringToReplaceField, $fieldValues) { if (empty($stringToReplaceField)) { return $stringToReplaceField; } $fieldPattern = '/\${\w[^ ${}]*}/'; preg_match_all($fieldPattern, $stringToReplaceField, $matchedField); $uniqueFieldsInStr = array_unique($matchedField[0]); foreach ($uniqueFieldsInStr as $key => $value) { $fieldName = substr($value, 2, strlen($value) - 3); if (isset($fieldValues[$fieldName])) { $stringToReplaceField = is_string($fieldValues[$fieldName]) ? str_replace($value, $fieldValues[$fieldName], $stringToReplaceField) : wp_json_encode($fieldValues[$fieldName]); } } return $stringToReplaceField; } public static function updatedHiddenFieldValue($formID) { $hiddenFields = []; $frontendFormManger = new FrontendFormManager($formID); if ($frontendFormManger->isHoneypotActive()) { $str = '_bitform' . '_' . $formID . '_' . time() . '_'; $honpotToken = Helpers::honeypotEncryptedToken($str); $hiddenFields[] = [ 'name' => 'b_h_t', 'value' => $honpotToken ]; } $csrfTokens = Helpers::csrfEecrypted(); $hiddenFields[] = [ 'name' => 't_identity', 'value' => $csrfTokens['t_identity'], ]; $hiddenFields[] = [ 'name' => 'csrf', 'value' => $csrfTokens['csrf'] ]; return $hiddenFields; } public static function maybeSetCronForIntegration($workFlowReturnedData, $opType) { $responseData = []; $entryId = $workFlowReturnedData['triggerData']['entryID']; $responseData['entry_id'] = $entryId; if (isset($workFlowReturnedData['message'])) { $formID = $workFlowReturnedData['triggerData']['formID']; $responseData['message'] = $workFlowReturnedData['message']; $responseData['hidden_fields'] = self::updatedHiddenFieldValue($formID); $responseData['msg_id'] = isset($workFlowReturnedData['msg_id']) ? $workFlowReturnedData['msg_id'] : 0; if (isset($workFlowReturnedData['msg_duration'])) { $responseData['msg_duration'] = $workFlowReturnedData['msg_duration']; } } if (isset($workFlowReturnedData['redirectPage'])) { $responseData['redirectPage'] = $workFlowReturnedData['redirectPage']; } if ('update' === $opType && isset($workFlowReturnedData['updatedData'])) { $responseData['updatedData'] = $workFlowReturnedData['updatedData']; } if (!isset($workFlowReturnedData['triggerData'])) { return $responseData; } $triggerData = $workFlowReturnedData['triggerData']; $trnasientData = get_transient("bitform_trigger_transient_{$entryId}"); $trnasientData = is_string($trnasientData) ? json_decode($trnasientData) : $trnasientData; if(!empty($trnasientData['fields'])){ $workFlowReturnedData['fields'] = array_merge($workFlowReturnedData['fields'], $trnasientData['fields']); } if (function_exists('fastcgi_finish_request') || !wp_doing_ajax()) { if (!headers_sent()) { header('Connection: close'); $contentType = wp_doing_ajax() || defined('REST_REQUEST') ? 'application/json' : 'text/html'; header('Content-Type: ' . $contentType . '; charset=' . get_option('blog_charset')); status_header(200); $response = [ 'success' => true, 'data' => $responseData, ]; } ob_start(); echo wp_doing_ajax() || defined('REST_REQUEST') ? wp_json_encode($response) : $workFlowReturnedData['message']; ob_end_flush(); flush(); session_write_close(); if (isset($workFlowReturnedData['integrationRun']) && !$workFlowReturnedData['integrationRun']) { $entryModel = new FormEntryModel(); $updatedStatus = $entryModel->update( [ 'status' => 2, ], [ 'form_id' => $triggerData['formID'], 'id' => $triggerData['entryID'], ] ); if (!is_wp_error($updatedStatus)) { if ($workFlowReturnedData['dflt_template']) { $triggerData['fields'] = $workFlowReturnedData['fields']; do_action('bf_double_optin_confirmation', $workFlowReturnedData['integrationDetails'], $triggerData); } elseif (isset($triggerData['dblOptin'])) { foreach ($triggerData['dblOptin'] as $value) { MailNotifier::notify($value, $triggerData['formID'], $triggerData['fields'], $triggerData['entryID'], true, $triggerData['logID']); } } } if (function_exists('fastcgi_finish_request')) { fastcgi_finish_request(); } if (defined('REST_REQUEST') || wp_doing_ajax()) { die; } return $workFlowReturnedData; } if (isset($triggerData['mail'])) { $formManager = new AdminFormManager($triggerData['formID']); $formContent = $formManager->getFormContent(); $submitted_fields = $formContent->fields; $fieldValueForMail = FieldValueHandler::formatFieldValueForMail($submitted_fields, $workFlowReturnedData['fields']); foreach ($triggerData['mail'] as $value) { MailNotifier::notify($value, $triggerData['formID'], $fieldValueForMail, $triggerData['entryID']); } } do_action('bitforms_exec_integrations', $triggerData['integrations'], $workFlowReturnedData['fields'], $triggerData['formID'], $triggerData['entryID'], $triggerData['logID']); if (function_exists('fastcgi_finish_request')) { fastcgi_finish_request(); } if (defined('REST_REQUEST') || wp_doing_ajax()) { die; } return $workFlowReturnedData; } $entryID = $triggerData['entryID']; if (isset($workFlowReturnedData['cron']) && $workFlowReturnedData['cron'] && !isset($triggerData['mail']) && isset($workFlowReturnedData['integrationRun']) && $workFlowReturnedData['integrationRun']) { $eventScheuled = wp_schedule_single_event(time(), 'bitforms_exec_integrations', [$triggerData['integrations'], $workFlowReturnedData['fields'], $triggerData['formID'], $triggerData['entryID'], $triggerData['logID']]); $scheduleTime = wp_next_scheduled('bitforms_exec_integrations', [$triggerData['integrations'], $workFlowReturnedData['fields'], $triggerData['formID'], $triggerData['entryID'], $triggerData['logID']]); $responseData['cron'] = get_site_url(null, "/wp-cron.php?doing_wp_cron&{$scheduleTime}"); } elseif (!empty($triggerData['integrations']) || !empty($triggerData['mail']) || isset($workFlowReturnedData['integrationRun']) && !$workFlowReturnedData['integrationRun']) { $triggerData['fields'] = $workFlowReturnedData['fields']; if (!$workFlowReturnedData['integrationRun'] && isset($workFlowReturnedData['integrationDetails'])) { $triggerData['dbl_opt_donf'] = $workFlowReturnedData['integrationDetails']; $triggerData['dbl_opt_dflt_template'] = $workFlowReturnedData['dflt_template']; $triggerData['integrationRun'] = $workFlowReturnedData['integrationRun']; } set_transient("bitform_trigger_transient_{$entryID}", $triggerData, HOUR_IN_SECONDS); $entryLog = new FormEntryLogModel(); $queueuEntry = $entryLog->log_history_insert( [ 'log_id' => $triggerData['logID'], 'integration_id' => 0, 'api_type' => wp_json_encode(['type' => 'trigger', 'type_name' => 'Workflow', 'on' => $opType]), 'response_type' => 'queued', 'response_obj' => json_encode(['status' => 'queued']), 'created_at' => current_time('mysql'), ] ); $responseData['cronNotOk'] = [ $triggerData['entryID'], $triggerData['logID'], $queueuEntry, ]; } return $responseData; } }