File Manager

X7ROOT File Manager

Current Path: /home/katmhsmi/public_html/wp-content/plugins/fluentformpro/src/Components/ChainedSelect

home / katmhsmi / public_html / wp-content / plugins / fluentformpro / src / Components / ChainedSelect /

📁 ..
📄 .htaccess(420 B)
📄 ChainedSelect.php(7.95 KB)
📄 ChainedSelectDataSourceManager.php(8.5 KB)

Editing: ChainedSelectDataSourceManager.php

<?php

namespace FluentFormPro\Components\ChainedSelect;

if (!defined('ABSPATH')) {
    exit; // Exit if accessed directly.
}

use Exception;
use FluentForm\App\Modules\Form\Form;
use FluentForm\App\Modules\Form\FormFieldsParser;

class ChainedSelectDataSourceManager
{
    protected  $app = null;

public function __construct($app)
    {
        $this->app = $app;
    }

public function saveDataSource($csvParser)
    {
        try {
            $request = $this->app->request;
            $type = $request->get('type');
            $formId = $request->get('form_id');
            $metaKey = $request->get('meta_key');

// if ($url = $request->get('url')) {
            //     $this->validateUrl($url);
            //     $name = basename($url);
            //     $data = file_get_contents($url);
            // } else {
            //     if ($request->files('file')) {
            //         $file = $request->files('file')['file'];
            //         $name = $_FILES['file']['name'];
            //         $data = $file->getContents();
            //     }
            // }

if ($request->files('file')) {
                $file = $request->files('file')['file'];
                $name = $_FILES['file']['name'];
                $data = $file->getContents();
            }

if (!isset($data) || !$data) {
                throw new Exception('Oops! Something went wrong.', 400);
            }

$csvParser->load_data($data);

$result = $csvParser->parse($csvParser->find_delimiter());

if (is_array($result) && count($result)) {
                // $this->saveFieldoptions($result, $formId, $metaKey);

if ($this->saveFile($file, $formId, $metaKey)) {
                    return wp_send_json_success([
                        // 'url' => $url,
                        'url' => '',
                        'name' => $type === 'file' ? $name : '',
                        'headers' => $result[0],
                        'type' => $type,
                        'meta_key' => $metaKey
                    ]);
                }
            }

throw new Exception('Oops! Something went wrong.', 400);

} catch (Exception $e) {
            wp_send_json_error(['message' => $e->getMessage()], $e->getCode());
        }
    }

protected function formatOptions($options)
    {
        $headers = array_shift($options);

$headers = array_map('trim', $headers);

foreach ($options as $key => $option) {
            $options[$key] = @array_combine($headers, $option);
        }

return array_filter($options);
    }

protected function saveFile($file, $formId, $metaKey)
    {
        $fileArray = $file->toArray();

$path = wp_upload_dir()['basedir'].FLUENTFORM_UPLOAD_DIR;

if (!is_dir($path)) {
            mkdir($path, 0755);
            file_put_contents(
                wp_upload_dir()['basedir'].FLUENTFORM_UPLOAD_DIR.'/.htaccess',
                file_get_contents(FLUENTFORMPRO_DIR_PATH.'src/Stubs/htaccess.stub')
            );
        }

$target = $path . '/' . $metaKey . '_' . $formId . '.csv';

if (move_uploaded_file($fileArray['tmp_name'], $target)) {
            return $target;
        }
    }

public function deleteDataSource()
    {
        $request = $this->app->request;

$formId = $request->get('form_id');
        
        $name = $request->get('name');
        
        $metaKey = $request->get('meta_key');

$path = wp_upload_dir()['basedir'].FLUENTFORM_UPLOAD_DIR;

$target = $path . '/' . $metaKey . '_' . $formId . '.csv';
        
        $this->maybeDeleteDataSource($formId, $name, $metaKey, $target);

wp_send_json_success([
            'message' => 'Data source deleted successfully.',
            'headers' => ['Parent', 'Child', 'Grand Child']
        ]);

// wpFluent()->table('fluentform_form_meta')
        //     ->where('meta_key', $metaKey)
        //     ->where('form_id', $formId)
        //     ->delete();

// wp_send_json_success([
        //     'message' => 'Data source deleted successfully.',
        //     'headers' => ['Parent', 'Child', 'Grand Child']
        // ]);
    }

protected function maybeDeleteDataSource($formId, $name, $metaKey, $target)
    {
        $form = (new Form($this->app))->fetchForm($formId);
        
        $fields = FormFieldsParser::getFields($form);

$chainedSelects = array_filter($fields, function($field) {
            return $field->element == 'chained_select';
        });

$currentField = array_filter($chainedSelects, function($field) use ($name) {
            return $field->attributes->name == $name;
        });

$currentField = reset($currentField);

if (count($chainedSelects) == 1) {
            file_exists($target) && @unlink($target);
        } else {
            $metaKeys = array_map(function($field) {
                return $field->settings->data_source->meta_key;
            }, $chainedSelects);

if (count(array_intersect($metaKeys, [$metaKey])) < 2) {
                file_exists($target) && @unlink($target);
            } 
        }

if ($currentField) {
            return $this->updateCurrentField($currentField, $form, $formId);
        }
    }

protected function updateCurrentField($currentField, $form, $formId)
    {
        $formFields = json_decode($form->form_fields, true);

$currentField->settings->data_source = [
            'url' => '',
            'name' => '',
            'headers' => ['Parent', 'Child', 'Grand Child'],
            'type' => 'file',
            'meta_key' => null
        ];

foreach ($formFields['fields'] as $key => $field) {
            if ($field['attributes']['name'] == $currentField->attributes->name) {
                $formFields['fields'][$key] = $currentField;
            }
        }

wpFluent()->table('fluentform_forms')->where('id', $formId)->update([
            'form_fields' => json_encode($formFields)
        ]);
    }

public function getOptionsForNextField($csvParser)
    {
        $result = [];

$options = $this->formatOptions($this->getOptions($csvParser));
        
        if (@$_REQUEST['filter_options'] == 'all') {
            return $this->sendAllOptions($options);
        }

foreach ($options as $option) {
            $statuses = [];

foreach ($_REQUEST['params'] as $param) {
                $statuses[] = $option[$param['key']] == $param['value'];
            }

if (count(array_filter($statuses)) == count($statuses)) {
                $result[] = $option;
            }
        }

$response = array_unique(
            array_column($result, $_REQUEST['target_field'])
        );

wp_send_json_success(array_combine($response, $response));
    }

protected function sendAllOptions($options)
    {
        $keys = array_keys($_REQUEST['keys']);
        
        $keysToMatch = [$keys[0] => $_REQUEST['keys'][$keys[0]]];
        
        foreach ($keys as $index => $key) {
            if ($index == 0) {
                $result[$key] = array_values(array_unique(
                    array_column($options, $key)
                ));
            } else {
                $result[$key] = $this->getNextMatchingOptions(
                    $keysToMatch, $key, $options, $result
                );
                
                $nextKey = next($keys);
                $keysToMatch = array_merge(
                    $keysToMatch, [$nextKey => $_REQUEST['keys'][$nextKey]]
                );
            }
        }

wp_send_json($result, 200);
    }

protected function getNextMatchingOptions($keysToMatch, $targetKey, $options, $result)
    {
        foreach ($options as $option) {
            if ($keysToMatch === array_intersect_key($option, $keysToMatch)) {
                if (!in_array($option[$targetKey], $result[$targetKey])) {
                    $result[$targetKey][] = $option[$targetKey];
                }
            }
        }

return $result[$targetKey];
    }

protected function getOptions($csvParser)
    {
        // $name = $_REQUEST['name'];
        
        $metaKey = $_REQUEST['meta_key'];

$formId = intval($_REQUEST['form_id']);

$path = wp_upload_dir()['basedir'].FLUENTFORM_UPLOAD_DIR . '/';

// $file = $path . '/chained_select_' . $name . '_' . $formId . '.csv';

$file = $path . $metaKey . '_' . $formId . '.csv';

$csvParser->load_data($data = file_get_contents($file));

return $csvParser->parse($csvParser->find_delimiter());
    }
}

X7ROOT File Manager

Editing: ChainedSelectDataSourceManager.php

Upload File

Create Folder