<?php
defined('ABSPATH') || defined('DUPXABSPATH') || exit;
/** IDE HELPERS */
/* @var $GLOBALS['DUPX_AC'] DUPX_ArchiveConfig */
/* @var $state DUPX_InstallerState */

$state             = $GLOBALS['DUPX_STATE'];
$is_standard_mode  = $state->mode == DUPX_InstallerMode::StandardInstall;
$is_overwrite_mode = ($state->mode == DUPX_InstallerMode::OverwriteInstall && $GLOBALS['DUPX_AC']->installSiteOverwriteOn);

if ($is_standard_mode) {

    $ovr_dbhost = NULL;
    $ovr_dbname = NULL;
    $ovr_dbuser = NULL;
    $ovr_dbpass = NULL;

    $dbhost = $GLOBALS['DUPX_AC']->dbhost;
    $dbname = $GLOBALS['DUPX_AC']->dbname;
    $dbuser = $GLOBALS['DUPX_AC']->dbuser;
    $dbpass = $GLOBALS['DUPX_AC']->dbpass;

    $dbFormDisabledString = '';
} else {
    $wpConfigPath       = "{$GLOBALS['DUPX_ROOT']}/wp-config.php";
    $outerWPConfigPath  = dirname($GLOBALS['DUPX_ROOT'])."/wp-config.php";
    require_once($GLOBALS['DUPX_INIT'].'/lib/config/class.wp.config.tranformer.php');
    $config_transformer = file_exists($wpConfigPath) ? new DupLiteWPConfigTransformer($wpConfigPath) : new DupLiteWPConfigTransformer($outerWPConfigPath);

    function dupxGetDbConstVal($constName)
    {
        if ($GLOBALS['config_transformer']->exists('constant', $constName)) {
            $configVal = $GLOBALS['config_transformer']->get_value('constant', $constName);
            $constVal  = htmlspecialchars($configVal);
        } else {
            $constVal = '';
        }
        return $constVal;
    }
    $ovr_dbhost = dupxGetDbConstVal('DB_HOST');
    $ovr_dbname = dupxGetDbConstVal('DB_NAME');
    $ovr_dbuser = dupxGetDbConstVal('DB_USER');
    $ovr_dbpass = dupxGetDbConstVal('DB_PASSWORD');

    $dbhost = '';
    $dbname = '';
    $dbuser = '';
    $dbpass = '';
}
?>

<!-- =========================================
BASIC PANEL -->
<div class="hdr-sub1 toggle-hdr" data-type="toggle" data-target="#s2-db-basic">
    <a href="javascript:void(0)"><i class="fa fa-minus-square"></i>Setup</a>
</div>
<div id="s2-db-basic" class="dupx-panel-area">
    <div class="hdr-sub3">Database Connection</div>
    
    <?php if ($is_overwrite_mode) : ?>
        <div id="s2-db-basic-overwrite" class="gray-panel" >
            <b style='color:maroon'>Ready to connect to existing sites database? </b><br/>
            <div class="warn-text">
                The existing sites database settings should have been applied below.  If you want to connect to this database and replace all its data then keep these values.
                To use different database settings click the 'Reset button' to clear the values.  To apply the current sites database use the 'Apply Button'.
                <br/><br/>

                <i><i class="fas fa-exclamation-triangle fa-sm"></i> Warning: Please note that reusing an existing site's database will <u>overwrite</u> all of its data. If you're not 100% sure about
                    using these database settings, then create a new database and use the new credentials instead.</i>
            </div>

            <div class="btn-area">
                <input id="overwrite-btn-apply" type="button" value="Apply" class="overwrite-btn" onclick="DUPX.checkOverwriteParameters()">
                <input id="overwrite-btn-reset" type="button" value="Reset" class="overwrite-btn" onclick="DUPX.resetParameters()">
            </div>
        </div>
    <?php endif; ?>
    <table class="dupx-opts">
        <tr>
            <td>Action:</td>
            <td>
                <select name="dbaction" id="dbaction">
                    <?php if ($is_standard_mode) : ?>
                        <option value="create">Create New Database</option>
                    <?php endif; ?>
                    <option value="empty" selected>Remove All Data</option>
                    <option value="null" disabled="disabled">Backup and Rename Existing Tables (Pro Only)</option>
                    <option value="null" disabled="disabled">Manual SQL Execution (Pro Only)</option>
                </select>
            </td>
        </tr>
        <tr>
            <td>Host:</td>
            <td><input type="text" name="dbhost" id="dbhost" required="true" value="<?php echo htmlspecialchars($dbhost); ?>" placeholder="localhost" /></td>
        </tr>
        <tr>
            <td>Database:</td>
            <td>
                <input type="text" name="dbname" id="dbname" required="true" value="<?php echo htmlspecialchars($dbname); ?>"  placeholder="new or existing database name"  />
                <div class="s2-warning-emptydb">
                    Warning: The selected 'Action' above will remove <u>all data</u> from this database!
                </div>
                <div class="s2-warning-renamedb">
                    Notice: The selected 'Action' will rename <u>all existing tables</u> from the database name above with a prefix '<?php echo DUPX_U::esc_html($GLOBALS['DB_RENAME_PREFIX']); ?>'.
                    The prefix is only applied to existing tables and not the new tables that will be installed.
                </div>
                <div class="s2-warning-manualdb">
                    Notice: The 'Manual SQL execution' action will prevent the SQL script in the archive from running. The database above should already be
                    pre-populated with data which will be updated in the next step. No data in the database will be modified until after Step 3 runs.
                </div>
            </td>
        </tr>
        <tr><td>User:</td><td><input type="text" name="dbuser" id="dbuser" required="true" value="<?php echo DUPX_U::esc_attr($dbuser); ?>" placeholder="valid database username" /></td></tr>
        <tr>
            <td>Password:</td>
            <td>
                <?php
                DUPX_U_Html::inputPasswordToggle('dbpass', 'dbpass', array(), array(
                    'placeholder' => 'valid database user password',
                    'value'       => $dbpass
                ));
                ?>
            </td>
        </tr>
    </table>
</div>
<br/>


<?php if (!$is_dbtest_mode) : ?>
    <!-- =========================================
    OPTIONS -->
    <div class="hdr-sub1 toggle-hdr" id="s2-opts-hdr-basic" data-type="toggle" data-target="#s2-opts-basic">
        <a href="javascript:void(0)"><i class="fa fa-plus-square"></i>Options</a>
    </div>
    <div id="s2-opts-basic" class="s2-opts hdr-sub1-area dupx-panel-area" style="display:none;">
        <div class="help-target">
            <?php DUPX_View_Funcs::helpIconLink('step2'); ?>
        </div>
        <div class="hdr-sub3">Database Configuration</div>
        <table class="dupx-opts dupx-advopts dupx-advopts-space">
            <tr>
                <td>Legacy:</td>
                <td><input type="checkbox" name="dbcollatefb" id="dbcollatefb" value="1" /> <label for="dbcollatefb">Apply legacy collation fallback support for unknown collations types</label></td>
            </tr>
            <tr>
                <td>Spacing:</td>
                <td><input type="checkbox" name="dbnbsp" id="dbnbsp" value="1" /> <label for="dbnbsp">Fix non-breaking space characters</label></td>
            </tr>
            <tr>
                <td style="vertical-align:top">Mode:</td>
                <td>
                    <input type="radio" name="dbmysqlmode" id="dbmysqlmode_1" checked="true" value="DEFAULT"/> <label for="dbmysqlmode_1">Default</label> &nbsp;
                    <input type="radio" name="dbmysqlmode" id="dbmysqlmode_2" value="DISABLE"/> <label for="dbmysqlmode_2">Disable</label> &nbsp;
                    <input type="radio" name="dbmysqlmode" id="dbmysqlmode_3" value="CUSTOM"/> <label for="dbmysqlmode_3">Custom</label> &nbsp;
                    <div id="dbmysqlmode_3_view" style="display:none; padding:5px">
                        <input type="text" name="dbmysqlmode_opts" value="" /><br/>
                        <small>Separate additional <?php
                            DUPX_View_Funcs::helpLink('step2', 'sql modes');
                            ?> with commas &amp; no spaces.<br/>
                            Example: <i>NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE,...</i>.</small>
                    </div>
                </td>
            </tr>
        </table>

        <table class="dupx-opts dupx-advopts">
            <tr>
                <td style="width:130px">Objects:</td>
                <td><input type="checkbox" name="dbobj_views" id="dbobj_views" checked="true" /><label for="dbobj_views">Enable View Creation</label></td>
            </tr>
            <tr>
                <td></td>
                <td><input type="checkbox" name="dbobj_procs" id="dbobj_procs" checked="true" /><label for="dbobj_procs">Enable Stored Procedure Creation</label></td>
            </tr>
            <tr>
                <td></td>
                <td><input type="checkbox" name="dbobj_funcs" id="dbobj_funcs" checked="true" /><label for="dbobj_funcs">Enable Function Creation</label></td>
            </tr>
            <tr>
                <td></td>
                <td><input type="checkbox" name="db_remove_definer" id="db_remove_definer"/><label for="db_remove_definer">Remove DEFINER from CREATE queries</label></td>
            </tr>
            <tr>
                <td>Charset:</td>
                <td>
                    <input type="text" name="dbcharset" id="dbcharset" value="<?php echo DUPX_U::esc_attr($_POST['dbcharset']); ?>" /> 
                </td>
            </tr>
            <tr>
                <td>Collation: </td>
                <td>
                    <input type="text" name="dbcollate" id="dbcollate" value="<?php echo DUPX_U::esc_attr($_POST['dbcollate']); ?>" />
                </td>
            </tr>
        </table>
    </div><br/>
<?php endif; ?>



<!-- =========================================
BASIC: DB VALIDATION -->
<div class="hdr-sub1 toggle-hdr" data-type="toggle" data-target="#s2-dbtest-area-basic">
    <a href="javascript:void(0)"><i class="fa fa-minus-square"></i>Validation</a>
</div>

<div id="s2-dbtest-area-basic" class="s2-dbtest-area hdr-sub1-area">
    <div id="s2-dbrefresh-basic">
        <a href="javascript:void(0)" onclick="DUPX.testDBConnect()"><i class="fa fa-sync"></i> Retry Test</a>
    </div>
    <div style="clear:both"></div>
    <div id="s2-dbtest-hb-basic" class="s2-dbtest-hb">
        <div class="message">
              <b><i class="far fa-check-circle"></i> Please validate database setup by clicking the 'Test Database' button.</b><br/>
              <i>This test checks to make sure the database is ready for install.</i>
        </div>
    </div>
</div>

<br/><br/><br/>
<br/><br/><br/>

<div class="footer-buttons">
    <?php if ($is_dbtest_mode) : ?>
        <div style="text-align: center; font-size:11px; margin-top: -20px">
            <button id="s2-dbtest-btn-basic" type="button" onclick="DUPX.testDBConnect()" class="default-btn" /><i class="fas fa-database fa-sm"></i> Test Database</button>
            <br/><br/>
            Notice: This a database only connection view.<br/>  
            To continue with the install, close this browser window/tab.
        </div>
    <?php else : ?>
        <button id="s2-dbtest-btn-basic" type="button" onclick="DUPX.testDBConnect()" class="default-btn" /><i class="fas fa-database fa-sm"></i> Test Database</button>
        <button id="s2-next-btn-basic" type="button" onclick="DUPX.confirmDeployment()" class="default-btn disabled" disabled="true"
            title="The 'Test Database' connectivity requirements must pass to continue with install!">
        Next <i class="fa fa-caret-right"></i>
    </button>
<?php endif; ?>
</div>

<script>
    /**
     *  Bacic Action Change  */
    DUPX.basicDBActionChange = function ()
    {
        var action = $('#dbaction').val();
        $('#s2-basic-pane .s2-warning-manualdb').hide();
        $('#s2-basic-pane .s2-warning-emptydb').hide();
        $('#s2-basic-pane .s2-warning-renamedb').hide();
        switch (action) {
            case 'create':
                break;
            case 'empty':
                $('#s2-basic-pane .s2-warning-emptydb').show(300);
                break;
            case 'rename':
                $('#s2-basic-pane .s2-warning-renamedb').show(300);
                break;
            case 'manual':
                $('#s2-basic-pane .s2-warning-manualdb').show(300);
                break;
        }
    };

//DOCUMENT INIT
    $(document).ready(function ()
    {
        $("#dbaction").on("change", DUPX.basicDBActionChange);
        DUPX.basicDBActionChange();

        $("input[name=dbmysqlmode]").click(function () {
            ($(this).val() == 'CUSTOM')
                    ? $('#dbmysqlmode_3_view').show()
                    : $('#dbmysqlmode_3_view').hide();
        });

        //state = 'enabled', 'disable', 'toggle'
        DUPX.basicDBToggleImportMode = function (state)
        {
            state = typeof state !== 'undefined' ? state : 'enabled';
            var $inputs = $("#s2-db-basic").find("input[type=text]");

            switch (state) {
                case 'readonly':
                    $inputs.each(function () {
                        $(this).attr('readonly', true).css('border', 'none');
                    });
                    break;
                case 'enable':
                    $inputs.each(function () {
                        $(this).removeAttr('readonly').css('border', '1px solid silver');
                    });
                    break;
                case 'toggle':
                    var readonly = $('input#dbhost').is('[readonly]');
                    if (readonly) {
                        $inputs.each(function () {
                            $(this).removeAttr('readonly').css('border', '1px solid silver');
                        });
                    } else {
                        $inputs.each(function () {
                            $(this).attr('readonly', true).css('border', 'none');
                        });
                    }
                    break;
            }
        }

        DUPX.checkOverwriteParameters = function (dbhost, dbname, dbuser, dbpass)
        {
            $("#dbhost").val(<?php echo "'{$ovr_dbhost}'" ?>);
            $("#dbname").val(<?php echo "'{$ovr_dbname}'" ?>);
            $("#dbuser").val(<?php echo "'{$ovr_dbuser}'" ?>);
            $("#dbpass").val(<?php echo "'{$ovr_dbpass}'" ?>);
            DUPX.basicDBToggleImportMode('readonly');
            $("#s2-db-basic-setup").show();
        }

        DUPX.fillInPlaceHolders = function ()
        {
            $("#dbhost").attr('placeholder', <?php echo "'{$ovr_dbhost}'" ?>);
            $("#dbname").attr('placeholder', <?php echo "'{$ovr_dbname}'" ?>);
            $("#dbuser").attr('placeholder', <?php echo "'{$ovr_dbuser}'" ?>);
            $("#dbpass").attr('placeholder', <?php echo "'{$ovr_dbpass}'" ?>);
        }

        DUPX.resetParameters = function ()
        {
            $("#dbhost").val('').attr('placeholder', 'localhost');
            $("#dbname").val('').attr('placeholder', 'new or existing database name');
            $("#dbuser").val('').attr('placeholder', 'valid database user name');
            $("#dbpass").val('').attr('placeholder', 'valid database user password');
            DUPX.basicDBToggleImportMode('enable');
        }

<?php if ($is_overwrite_mode) : ?>
            DUPX.fillInPlaceHolders();
            $('#overwrite-btn-apply').click();
<?php endif; ?>

    });
</script>
