<?php
/**
 * Created by PhpStorm.
 * User: Edgar
 * Date: 2/25/2019
 * Time: 8:57 AM
 */

namespace rednaoeasycalculationforms\core;

use rednaoeasycalculationforms\ajax\AIAjax;
use rednaoeasycalculationforms\ajax\EntriesAjax;
use rednaoeasycalculationforms\ajax\EntryUtilsAjax;
use rednaoeasycalculationforms\ajax\FormListAjax;
use rednaoeasycalculationforms\ajax\SettingsAjax;
use rednaoeasycalculationforms\ajax\SubmissionAjax;
use rednaoeasycalculationforms\blocks\BlockLoader;
use rednaoeasycalculationforms\core\db\core\DBManager;
use rednaoeasycalculationforms\core\Managers\HTMLSanitizer;
use rednaoeasycalculationforms\core\Managers\LogManager\LogManager;
use rednaoeasycalculationforms\core\Managers\TwigManager\TwigManager;
use rednaoeasycalculationforms\DTO\BuilderOptionsDTO;
use rednaoeasycalculationforms\pr\PRLoader;

class Loader extends PluginBase
{
    /** @var PRLoader */
    public $PRLoader = null;
    /** @var TwigManager */
    private $Twig;

    /** @var HTMLSanitizer */
    public $HTMLSanitizer;
    public $FORM_LIST_TABLE;
    public $FORM_LIST_TABLE_META;
    public $RECORDS_TABLE;
    public $RECORDS_DETAIL;
    public $RECORDS_FILES;
    public $RECORDS_META;
    public $LINKS;
    public $FIELD_TEMPLATE;
    public $Pr = null;

    public function __construct($filePath, $prefix, $dbVersion, $fileVersion)
    {
        LogManager::Initialize($this);

        $dbManager = new DBManager();
        $this->FIELD_TEMPLATE = $dbManager->GetPrefix() . $prefix . '_field_templates';
        $this->FORM_LIST_TABLE = $dbManager->GetPrefix() . $prefix . '_forms';
        $this->FORM_LIST_TABLE_META = $dbManager->GetPrefix() . $prefix . '_forms_meta';
        $this->RECORDS_TABLE = $dbManager->GetPrefix() . $prefix . '_records';
        $this->RECORDS_META = $dbManager->GetPrefix() . $prefix . '_records_meta';
        $this->RECORDS_DETAIL = $dbManager->GetPrefix() . $prefix . '_records_detail';
        $this->RECORDS_FILES = $dbManager->GetPrefix() . $prefix . '_records_files';
        $this->LINKS = $dbManager->GetPrefix() . $prefix . '_links';

        $me = $this;
        add_filter('rednao-easy-calculation-forms-get-loader', function () use ($me) {return $me;});
        add_filter('aio_load_field_translation_config', array($this, 'LoadFieldTranslationConfig'));
        add_action( 'admin_notices', array($this, 'ReviewNotice') );
        add_action('wp_ajax_aio_remind_me', array($this, 'RemindMeLater'));
        add_action('wp', array($this, 'StartScheduler'));
        add_action('wp_ajax_aio_dontshowagain', function () {
            update_option('rnaio_dont_show_again', 1);
            die();
        });

        \add_shortcode('rnformpreview', array($this, 'LoadFormPreview'));
        \add_shortcode('rnform', array($this, 'LoadForm'));

        parent::__construct($filePath, $prefix, $dbVersion, $fileVersion);
        require_once $this->DIR . 'core/FixedFieldFormatter.php';

        add_action( 'init', function () {
            if($this->IsPR())
            {
                new PRLoader($this);
            }
            load_plugin_textdomain( 'all-in-one-forms', false, dirname( plugin_basename( dirname(__FILE__) ) ) . '/languages/' );
        } );

        require_once realpath($this->DIR . 'Integration/RNECForms.php');

        add_action('admin_menu', function () {
            $this->AddMenu(__('AIO Forms', 'all-in-one-forms'), 'rednao_calculation_form', 'administrator', 'data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIyNC43Nzk2MSIgaGVpZ2h0PSIyMy40MzA1NSIgdmlld0JveD0iMCAwIDI0Ljc3OTYxIDIzLjQzMDU1Ij4NCiAgPHBhdGggZD0iTTE4LjIzOTk0LDYuNTcyNjhhMi4wODg3MSwyLjA4ODcxLDAsMCwwLTEuNzY2Ni4yMjA3QTIuMTAyNjcsMi4xMDI2NywwLDAsMCwxNS4zOTYxOSw4LjIyNGEzLjA5NDI1LDMuMDk0MjUsMCwwLDAsLjUxNTYyLDIuMTQ1NTEsMy4wNjg0NywzLjA2ODQ3LDAsMCwwLDEuNjExMzMsMS41MDU4NiwyLjA5NTM1LDIuMDk1MzUsMCwwLDAsMS43NzE0OS0uMTk1MzEsMi4wNzMxMSwyLjA3MzExLDAsMCwwLDEuMDUwMjktMS40Mjc3MywzLjEzMzczLDMuMTMzNzMsMCwwLDAtLjUxOTUzLTIuMTY5QTMuMDg0MjMsMy4wODQyMywwLDAsMCwxOC4yMzk5NCw2LjU3MjY4Wm02LjE2NDkyLDQuNjYzNTdMMTkuNTU4NzksMi4yODAwOGE0LjAxODI2LDQuMDE4MjYsMCwwLDAtNS40NDYtMS42MjE3MWwtMTEuODk2LDYuNDM3QTQuMDE3ODEsNC4wMTc4MSwwLDAsMCwuNTk1MTYsMTIuNTQxMzFsNC44NDYxOSw4Ljk1NjE3YTQuMDE3NzksNC4wMTc3OSwwLDAsMCw1LjQ0NTkzLDEuNjIxNThMMjIuNzgzMTUsMTYuNjgyM0E0LjAxODE1LDQuMDE4MTUsMCwwLDAsMjQuNDA0ODYsMTEuMjM2MjVaTTExLjcwNDc4LDE3LjUzNDU5LDEwLjE1NSwxNi4yNzk3MSw3LjMxOSwxNy45MTc0bC4zNDQ3MywxLjk1MDItMS41MTk1My44Nzc5M0w0LjgxMTcyLDEyLjA1NDEybDEuNTE0NjQtLjg3NSw2LjkzNyw1LjQ1NjA2Wm0yLjI3NDQyLTEuMzEzNDdMOS44ODM0OSw5LjEyNTQxbDEuNDMyNjItLjgyNjE3LDQuMDk1Nyw3LjA5NTdaTTIxLjk0NCwxMC40OTA2NWEzLjgxMjg3LDMuODEyODcsMCwwLDEtMS45Mzc1LDIuNDExMTMsMy44NDk1NSwzLjg0OTU1LDAsMCwxLTMuMDczNzMuNDg3Myw0LjIyODgxLDQuMjI4ODEsMCwwLDEtMi40NjkyNC0yLjExOTE0QTUuMjE5LDUuMjE5LDAsMCwxLDEzLjczNyw5LjI2MzExYTMuODc4NzQsMy44Nzg3NCwwLDAsMSwuMDk5MTItMS4zNTQ0OSwzLjE5NiwzLjE5NiwwLDAsMSwuNTQ4MzQtMS4xNjgsNC41MDc0Niw0LjUwNzQ2LDAsMCwxLDEuMzY3MTktMS4xNjMwOSwzLjg0Mjg4LDMuODQyODgsMCwwLDEsMy4wNzA4LS40NzY1Niw0LjMwNSw0LjMwNSwwLDAsMSwyLjUwMzQyLDIuMTYyMTFBNC4yOTI1OCw0LjI5MjU4LDAsMCwxLDIxLjk0NCwxMC40OTA2NVpNOS4wMDUwOCwxNS4zNSw2LjUwNzUyLDEzLjI4MTY2bC41NjIsMy4xODY1M1oiIHRyYW5zZm9ybT0idHJhbnNsYXRlKC0wLjExMDE2IC0wLjE3MzUxKSIgc3R5bGU9ImZpbGw6ICMwMTAxMDEiLz4NCjwvc3ZnPg0K', "rednaoeasycalculationforms\pages\FormList");
            if(!$this->IsPR())
            {
                $this->AddMenu(__('Entries (Little version)', 'all-in-one-forms'), 'rednao_entries_form', 'administrator', '', "rednaoeasycalculationforms\pages\Entries");

            }
            $this->AddMenu(__('Help/Documentation', "all-in-one-forms"), 'support', 'administrator', '', 'rednaoeasycalculationforms\pages\Help');

            $this->AddMenu(__('Settings', "all-in-one-forms"), 'rednao_calculation_form_settings', 'administrator', '', 'rednaoeasycalculationforms\pages\Settings');

        }, 1);

        add_filter('allinoneforms_get_ai_fields_description', array($this, 'GetAIFieldsDescription'));
        add_filter('allinoneforms_get_ai_fields_settings', array($this, 'GetAIFieldSettings'));

        new FormListAjax($this);
        new SubmissionAjax($this);
        new SettingsAjax($this);
        new EntryUtilsAjax($this);
        new EntriesAjax($this);
        new AIAjax($this);

    }

    public function GetAIFieldsDescription($fieldsDescriptions)
    {
        return array_merge($fieldsDescriptions, require $this->DIR . 'Managers/AIManagers/Descriptions/FieldsDescription.php');
    }

    public function GetAIFieldSettings($fieldsSettings)
    {
        return array_merge($fieldsSettings, require $this->DIR . 'Managers/AIManagers/Descriptions/SettingDescription.php');
    }

    public function StartScheduler()
    {
        require_once $this->DIR . 'Managers/SchedulerManager/SchedulerManager.php';
    }

    public function LoadFieldTranslationConfig($config) {
        return array_merge($config, require_once $this->DIR . 'Integration/FieldTranslationConfig.php');

    }

    public function RemindMeLater() {
        $currentStage = get_option('aio_review_stage', 0);
        update_option('aio_review_stage', $currentStage + 1);
    }

    public function ReviewNotice() {
        if(get_option('rnaio_dont_show_again', 0) == 1)
            return;
        $review = new ReviewHelper($this);
        $review->Start();

    }

    public function GetHTMLSanitizer() {
        if($this->HTMLSanitizer == null)
        {
            $this->HTMLSanitizer = new HTMLSanitizer($this);
        }
        return $this->HTMLSanitizer;
    }
    public function IsPR() {
        if($this->Pr == null)
            $this->Pr = apply_filters('allinoneforms_get_pr_loader', $this->Pr);

        return $this->Pr !== null;
    }

    public function CheckIfPDFAdmin() {
        if(!current_user_can('manage_options'))
        {
            die('Forbidden');
        }
    }

    /**
     * @return TwigManager
     */
    public function GetTwigManager($paths = [], $extensions = []) {

        if($this->Twig == null)
        {
            $this->Twig = new TwigManager($this, $paths, $extensions);
        }
        return $this->Twig;
    }

    public function OnCreateTable()
    {
        require_once(ABSPATH . 'wp-admin/includes/upgrade.php');

        global $wpdb;
        $charset_collate = $wpdb->get_charset_collate();

        $sql = "CREATE TABLE " . $this->LINKS . " (
        link_id int AUTO_INCREMENT,    
        reference VARCHAR(100) not null, 
        entry_id VARCHAR(100) NOT NULL,          
        date datetime NOT NULL,
        expiration_date datetime NOT NULL,
        options MEDIUMTEXT NOT NULL,
        PRIMARY KEY  (link_id),
        KEY reference (reference)
        ) {$charset_collate};";
        dbDelta($sql);

        $sql = "CREATE TABLE " . $this->FORM_LIST_TABLE . " (
        form_id int AUTO_INCREMENT,    
        creation_date datetime not null, 
        update_date datetime NOT NULL,          
        form_name VARCHAR(200) NOT NULL,
        element_options MEDIUMTEXT NOT NULL,
        client_form_options MEDIUMTEXT NOT NULL,
        server_options MEDIUMTEXT NOT NULL,
        emails MEDIUMTEXT Not null,
        extension_options MEDIUMTEXT Not null,
        dependencies MEDIUMTEXT,
        icons MEDIUMTEXT Not null,
        PRIMARY KEY  (form_id)
        ) {$charset_collate};";
        dbDelta($sql);

        $sql = "CREATE TABLE " . $this->FORM_LIST_TABLE_META . " (
        form_meta_id bigint AUTO_INCREMENT,
        form_id int,
        meta_name VARCHAR(200),
        meta_value longtext,
        PRIMARY KEY  (form_meta_id),
        KEY form_id_meta_name (form_id,meta_name)
        ) {$charset_collate};";
        dbDelta($sql);

        $sql = "CREATE TABLE " . $this->RECORDS_TABLE . " (
        entry_id int AUTO_INCREMENT,
        user_id VARCHAR(50),
        sequence int,
        formatted_sequence VARCHAR(50),
        form_id int,
        date datetime NOT NULL,
        data MEDIUMTEXT NOT NULL,
        ip VARCHAR(39),
        is_visible tinyint,
        status VARCHAR(50) NOT NULL,
        reference_id VARCHAR(100),
        meta_values MEDIUMTEXT,
        total decimal(19,4),
        quantity decimal(10,2),
        PRIMARY KEY  (entry_id),
        KEY sequence_number (sequence),
        KEY user_id (user_id),
        KEY date (date),
        KEY status (status),
        KEY reference_id (reference_id)                       
        ) {$charset_collate};";
        dbDelta($sql);

        $sql = "CREATE TABLE " . $this->RECORDS_META . " (
        entry_meta_id bigint AUTO_INCREMENT,
        entry_id int,
        meta_name VARCHAR(200),
        meta_value longtext,
        display_value longtext,
        display_label VARCHAR(400),
        data_type VARCHAR(20),
        is_visible tinyint,
        PRIMARY KEY  (entry_meta_id)
        ) {$charset_collate};";
        dbDelta($sql);

        $sql = "CREATE TABLE " . $this->RECORDS_DETAIL . " (
        entry_detail_id int AUTO_INCREMENT,
        form_id int,
        entry_id int,
        uniq_id int,
        type VARCHAR(30),
        field_id int NOT NULL,
        subtype varchar(200) NOT NULL,
        value MEDIUMTEXT NOT NULL,
        exvalue1 MEDIUMTEXT NOT NULL,
        exvalue2 MEDIUMTEXT NOT NULL,
        exvalue3 MEDIUMTEXT NOT NULL,
        exvalue4 MEDIUMTEXT NOT NULL,
        exvalue5 MEDIUMTEXT NOT NULL,
        exvalue6 MEDIUMTEXT NOT NULL,
        numericvalue DOUBLE,        
        numericvalue2 DOUBLE,
        datevalue DATETIME,
        datevalue2 DATETIME,
        unit_price decimal(19,4),
        total_field_price decimal(19,4),
        PRIMARY KEY  (entry_detail_id),
        KEY subtype (subtype),
        KEY entry_id (entry_id),
        KEY field_id (field_id),
        KEY numericvalue (numericvalue),   
        KEY numericvalue2 (numericvalue2),   
        KEY datevalue (datevalue),
        KEY datevalue2 (datevalue2),
        FULLTEXT KEY value (value),
        FULLTEXT KEY exvalue1 (exvalue1),
        FULLTEXT KEY exvalue2 (exvalue2),
        FULLTEXT KEY exvalue3 (exvalue3),
        FULLTEXT KEY exvalue4 (exvalue4),
        FULLTEXT KEY exvalue5 (exvalue5),
        FULLTEXT KEY exvalue6 (exvalue6)
        ) {$charset_collate};";
        dbDelta($sql);

        $sql = "CREATE TABLE " . $this->RECORDS_FILES . " (
        file_id int AUTO_INCREMENT,
        file_sequence_id bigint,
        entry_reference VARCHAR(100),
        file_reference VARCHAR(100),
        field_id int NOT NULL,
        field_file_id int NOT NULL,
        name VARCHAR(200) NOT NULL,
        physical_name VARCHAR(200) NOT NULL,
        expiration_date DATETIME,
        upload_date DATETIME,
        mime_type VARCHAR(127),
        file_type VARCHAR(20),
        PRIMARY KEY  (file_id),
        KEY file_sequence_id (file_sequence_id),
        KEY entry_reference (entry_reference),
        KEY file_reference (file_reference),
        KEY  field_file_id (field_file_id),
        KEY expiration_date (expiration_date)
        ) {$charset_collate};";
        dbDelta($sql);

        $sql = "CREATE TABLE " . $this->FIELD_TEMPLATE . " (
        template_id int AUTO_INCREMENT,    
        name VARCHAR(200) not null,
        options MEDIUMTEXT NOT NULL,
        PRIMARY KEY  (template_id)
        ) {$charset_collate};";
        dbDelta($sql);
    }

    public function CreateHooks()
    {
        new BlockLoader($this);
        add_filter('rednao-calculated-fields-get-additional-fields', array($this, 'GetAllFields'), 10, 5);
        \add_filter('allinoneforms_get_loader', array($this, 'GetLoader'));
        add_action('init', array($this, 'Init'));
    }

    public function GetLoader() {
        return $this;
    }

    public function Init() {
        if ( !current_user_can('edit_posts') && !current_user_can('edit_pages') ) {
            return;
        }

        register_post_type('rednao_forms_preview',
            array(
                'labels' => array(
                    'name' => __( 'Easy Calculation Forms Preview', 'all-in-one-forms' ),
                    'singular_name' => __( 'Easy Calculation Forms Preview', 'all-in-one-forms' )
                ),
                'public' => true,
                'show_ui' => false,
                'has_archive' => false,
            )
        );
    }

    public function GetAllFields($fields) {

        $fields[] = 'FBCheckBox';
        $fields[] = 'FBName';
        $fields[] = 'FBImage';
        $fields[] = 'FBRecaptcha';
        $fields[] = 'FBAddress';
        $fields[] = 'FBEmailField';
        $fields[] = 'FBDivider';
        $fields[] = 'FBDropDown';
        $fields[] = 'FBParagraph';
        $fields[] = 'FBSingleLabel';
        $fields[] = 'FBHTML';
        $fields[] = 'FBRadio';
        $fields[] = 'FBTextArea';
        $fields[] = 'FBTextField';
        $fields[] = 'FBNumericField';
        $fields[] = 'FBRatingField';
        $fields[] = 'FBTotalField';
        $fields[] = 'FBSubmitButton';
        $fields[] = 'FBRecaptcha';
        $fields[] = 'FBActionButton';
        $fields[] = 'FBHidden';
        $fields[] = 'FBSurvey';
        $fields[] = 'FBList';
        $fields[] = 'FBGroupPanel';
        $fields[] = 'FBFloatPanel';
        $fields[] = 'FBFile';
        $fields[] = 'FBRepeater';
        $fields[] = 'FBImagePicker';
        $fields[] = 'FBDatePicker';
        $fields[] = 'FBDateRange';
        $fields[] = 'FBMaskedField';
        $fields[] = 'FBColorPickerField';
        $fields[] = 'FBSlider';
        $fields[] = 'FBButtonCounter';
        $fields[] = 'FBButtonSelection';
        $fields[] = 'FBSwitch';
        $fields[] = 'FBSignature';
        $fields[] = 'FBColorSwatcher';
        $fields[] = 'FBTermOfService';
        $fields[] = 'FBGoogleMaps';
        $fields[] = 'FBTextualImage';

        return $fields;
    }

    public function LoadFormPreview($formId, $content) {
        $formOptions = null;
        if (!isset($_POST['_nonce']) && !isset($_GET['_nonce']))
        {
            echo __('Invalid Request', 'all-in-one-forms');
            return;
        }
        $nonce = '';

        if(isset($_POST['_nonce']))
            $nonce = \strval($_POST['_nonce']);
        if(isset($_GET['_nonce']))
            $nonce = \strval($_GET['_nonce']);

        if(!\wp_verify_nonce($nonce, 'rednaoeasycalculationforms_FormList'))
        {
            echo "Forbidden";
            return;
        }

        $formLoader = new Managers\FormLoader\FormLoader($this);
        if(isset($_POST['data']) && \is_scalar($_POST['data']))
        {

            $builderOptions = (new BuilderOptionsDTO())->Merge(json_decode(stripslashes($_POST['data'])));

            $formLoader->LoadForm($builderOptions);
            $formLoader->SetAsQuickPreview($nonce);
        }else if(isset($_GET['formid']))
        {
            $formId = \intval($_GET['formid']);
            if(!$formLoader->LoadFromId($formId))
            {
                echo esc_html__('Form not found', 'all-in-one-forms');
                return;
            }
        }

        $content = $formLoader->Load();

        return $content;

    }

    public function LoadForm($attr, $content) {

        $formLoader = new Managers\FormLoader\FormLoader($this);
        if(!$formLoader->LoadFromId($content)){
            echo esc_html__('Form not found', 'all-in-one-forms');
            return;
        }
        return $formLoader->Load();

    }
}