display_import.lib.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 *
 * @package PhpMyAdmin
 */
if (! defined('PHPMYADMIN')) {
    exit;
}

/**
 *
 */
require_once './libraries/file_listing.lib.php';
require_once './libraries/plugin_interface.lib.php';
require_once './libraries/display_import_ajax.lib.php';

/* Scan for plugins */
$import_list = PMA_getPlugins(
    "import",
    'libraries/plugins/import/',
    $import_type
);

/* Fail if we didn't find any plugin */
if (empty($import_list)) {
    PMA_Message::error(
        __(
            'Could not load import plugins, please check your installation!'
        )
    )->display();
    exit;
}
?>

<iframe id="import_upload_iframe" name="import_upload_iframe" width="1" height="1" style="display: none;"></iframe>
<div id="import_form_status" style="display: none;"></div>
<div id="importmain">
    <img src="<?php echo $GLOBALS['pmaThemeImage'];?>ajax_clock_small.gif" width="16" height="16" alt="ajax clock" style="display: none;" />
    <script type="text/javascript">
        //<![CDATA[
        $( function() {
            // add event when user click on "Go" button
            $('#buttonGo').bind('click', function() {
                $('#upload_form_form').css("display", "none"); // hide form
                $('#upload_form_status').css("display", "inline"); // show progress bar
                $('#upload_form_status_info').css("display", "inline"); // - || -
<?php
if ($_SESSION[$SESSION_KEY]["handler"] != "UploadNoplugin") {
    ?>
                var finished = false;
                var percent  = 0.0;
                var total    = 0;
                var complete = 0;
                var original_title = parent && parent.document ? parent.document.title : false;
                var import_start;

                var perform_upload = function () {
                    new $.getJSON(
                    'import_status.php?id=<?php echo $upload_id ; ?>&<?php echo PMA_generate_common_url(); ?>',
                    {},
                    function(response) {
                        finished = response.finished;
                        percent = response.percent;
                        total = response.total;
                        complete = response.complete;

                        if (total==0 && complete==0 && percent==0) {
                            $('#upload_form_status_info').html('<img src="<?php echo $GLOBALS['pmaThemeImage'];?>ajax_clock_small.gif" width="16" height="16" alt="ajax clock" /> <?php echo PMA_jsFormat(__('The file being uploaded is probably larger than the maximum allowed size or this is a known bug in webkit based (Safari, Google Chrome, Arora etc.) browsers.'), false); ?>');
                            $('#upload_form_status').css("display", "none");
                        } else {
                            var now = new Date();
                            now = Date.UTC(
                                now.getFullYear(), now.getMonth(), now.getDate(),
                                now.getHours(), now.getMinutes(), now.getSeconds())
                                + now.getMilliseconds() - 1000;
                            var statustext = $.sprintf('<?php echo PMA_escapeJsString(__('%s of %s')); ?>',
                                formatBytes(complete, 1, PMA_messages.strDecimalSeparator),
                                formatBytes(total, 1, PMA_messages.strDecimalSeparator)
                            );

                            if ($('#importmain').is(':visible')) {
                                // show progress UI
                                $('#importmain').hide();
                                $('#import_form_status')
                                    .html('<div class="upload_progress"><div class="upload_progress_bar_outer"><div class="percentage"></div><div id="status" class="upload_progress_bar_inner"><div class="percentage"></div></div></div><div><img src="<?php echo $GLOBALS['pmaThemeImage'];?>ajax_clock_small.gif" width="16" height="16" alt="ajax clock" /> <?php echo PMA_jsFormat(__('Uploading your import file...'), false); ?></div><div id="statustext"></div></div>')
                                    .show();
                                import_start = now;
                            }
                            else if (percent > 9 || complete > 2000000) {
                                // calculate estimated time
                                var used_time = now - import_start;
                                var seconds = parseInt(((total - complete) / complete) * used_time / 1000);
                                var speed = $.sprintf('<?php echo PMA_jsFormat(__('%s/sec.'), false); ?>'
                                    , formatBytes(complete / used_time * 1000, 1, PMA_messages.strDecimalSeparator));

                                var minutes = parseInt(seconds / 60);
                                seconds %= 60;
                                var estimated_time;
                                if (minutes > 0) {
                                    estimated_time = '<?php echo PMA_jsFormat(__('About %MIN min. %SEC sec. remaining.'), false); ?>'
                                        .replace('%MIN', minutes).replace('%SEC', seconds);
                                }
                                else {
                                    estimated_time = '<?php echo PMA_jsFormat(__('About %SEC sec. remaining.'), false); ?>'
                                        .replace('%SEC', seconds);
                                }

                                statustext += '<br />' + speed + '<br /><br />' + estimated_time;
                            }

                            var percent_str = Math.round(percent) + '%';
                            $('#status').animate({width: percent_str}, 150);
                            $('.percentage').text(percent_str);

                            // show percent in window title
                            if (original_title !== false) {
                                parent.document.title = percent_str + ' - ' + original_title;
                            }
                            else {
                                document.title = percent_str + ' - ' + original_title;
                            }
                            $('#statustext').html(statustext);
                        } // else

                        if (finished == true) {
                            if (original_title !== false) {
                                parent.document.title = original_title;
                            }
                            else {
                                document.title = original_title;
                            }
                            $('#importmain').hide();
                            $('#import_form_status')
                                .html('<img src="<?php echo $GLOBALS['pmaThemeImage'];?>ajax_clock_small.gif" width="16" height="16" alt="ajax clock" /> <?php echo PMA_jsFormat(__('The file is being processed, please be patient.'), false); ?> ')
                                .show();
                            $('#import_form_status').load('import_status.php?message=true&<?php echo PMA_generate_common_url(); ?>'); // loads the message, either success or mysql error
                            <?php
                            // reload the left sidebar when the import is finished
                            $GLOBALS['reload'] = true;
                            ?>

                        } // if finished
                        else {
                            setTimeout(perform_upload, 1000);
                        }
                    });
                }
                setTimeout(perform_upload, 1000);

    <?php
} else { // no plugin available
    ?>
                $('#upload_form_status_info').html('<img src="<?php echo $GLOBALS['pmaThemeImage'];?>ajax_clock_small.gif" width="16" height="16" alt="ajax clock" /> <?php echo PMA_jsFormat(__('Please be patient, the file is being uploaded. Details about the upload are not available.'), false) . PMA_Util::showDocu('faq', 'faq2-9'); ?>');
                        $('#upload_form_status').css("display", "none");
    <?php
} // else
?>
                    }); // onclick
                }); // domready
                //]]>
    </script>
    <form action="import.php" method="post" enctype="multipart/form-data"
        name="import"<?php
if ($_SESSION[$SESSION_KEY]["handler"] != "UploadNoplugin") {
    echo ' target="import_upload_iframe"';
}
if ($GLOBALS['cfg']['AjaxEnable']) {
    echo ' class="ajax"';
}
?>>
    <input type="hidden" name="<?php
        echo $_SESSION[$SESSION_KEY]["handler"]::getIdKey();
    ?>" value="<?php echo $upload_id ; ?>" />

    <?php
if ($import_type == 'server') {
    echo PMA_generate_common_hidden_inputs('', '', 1);
} elseif ($import_type == 'database') {
    echo PMA_generate_common_hidden_inputs($db, '', 1);
} else {
    echo PMA_generate_common_hidden_inputs($db, $table, 1);
}
echo '    <input type="hidden" name="import_type" value="' . $import_type . '" />'."\n";
    ?>

    <div class="exportoptions" id="header">
        <h2>
            <?php echo PMA_Util::getImage('b_import.png', __('Import')); ?>
            <?php
if ($import_type == 'server') {
    echo __('Importing into the current server');
} elseif ($import_type == 'database') {
    printf(__('Importing into the database "%s"'), htmlspecialchars($db));
} else {
    printf(__('Importing into the table "%s"'), htmlspecialchars($table));
}?>
        </h2>
    </div>

    <div class="importoptions">
        <h3><?php echo __('File to Import:'); ?></h3>
        <?php
// zip, gzip and bzip2 encode features
$compressions = array();

if ($cfg['GZipDump'] && @function_exists('gzopen')) {
    $compressions[] = 'gzip';
}
if ($cfg['BZipDump'] && @function_exists('bzopen')) {
    $compressions[] = 'bzip2';
}
if ($cfg['ZipDump'] && @function_exists('zip_open')) {
    $compressions[] = 'zip';
}
// We don't have show anything about compression, when no supported
if ($compressions != array()) {
    echo '<div class="formelementrow" id="compression_info">';
    printf(__('File may be compressed (%s) or uncompressed.'), implode(", ", $compressions));
    echo '<br />';
    echo __('A compressed file\'s name must end in <b>.[format].[compression]</b>. Example: <b>.sql.zip</b>');
    echo '</div>';
}?>

        <div class="formelementrow" id="upload_form">
        <?php
if ($GLOBALS['is_upload'] && !empty($cfg['UploadDir'])) { ?>
            <ul>
            <li>
                <input type="radio" name="file_location" id="radio_import_file" />
                <?php
    echo PMA_Util::getBrowseUploadFileBlock($max_upload_size);
                ?>
            </li>
            <li>
                <input type="radio" name="file_location" id="radio_local_import_file" />
                <?php
    echo PMA_Util::getSelectUploadFileBlock($import_list, $cfg['UploadDir']);
                ?>
            </li>
            </ul>
        <?php
} elseif ($GLOBALS['is_upload']) {
    $uid = uniqid('');
    echo PMA_Util::getBrowseUploadFileBlock($max_upload_size);
} elseif (!$GLOBALS['is_upload']) {
    PMA_Message::notice(__('File uploads are not allowed on this server.'))->display();
} elseif (!empty($cfg['UploadDir'])) {
    echo PMA_Util::getSelectUploadFileBlock($import_list, $cfg['UploadDir']);
} // end if (web-server upload directory)
?>
        </div>

       <div class="formelementrow" id="charaset_of_file">
        <?php // charset of file
if ($GLOBALS['PMA_recoding_engine'] != PMA_CHARSET_NONE) {
    echo '<label for="charset_of_file">' . __('Character set of the file:') . '</label>';
    reset($cfg['AvailableCharsets']);
    echo '<select id="charset_of_file" name="charset_of_file" size="1">';
    foreach ($cfg['AvailableCharsets'] as $temp_charset) {
        echo '<option value="' . htmlentities($temp_charset) .  '"';
        if ((empty($cfg['Import']['charset']) && $temp_charset == 'utf-8')
            || $temp_charset == $cfg['Import']['charset']
        ) {
            echo ' selected="selected"';
        }
        echo '>' . htmlentities($temp_charset) . '</option>';
    }
    echo ' </select><br />';
} else {
    echo '<label for="charset_of_file">' . __('Character set of the file:') . '</label>' . "\n";
    echo PMA_generateCharsetDropdownBox(PMA_CSDROPDOWN_CHARSET, 'charset_of_file', 'charset_of_file', 'utf8', false);
} // end if (recoding)
        ?>
        </div>
    </div>
    <div class="importoptions">
        <h3><?php echo __('Partial Import:'); ?></h3>

        <?php
if (isset($timeout_passed) && $timeout_passed) {
    echo '<div class="formelementrow">' . "\n";
    echo '<input type="hidden" name="skip" value="' . $offset . '" />';
    echo sprintf(__('Previous import timed out, after resubmitting will continue from position %d.'), $offset) . '';
    echo '</div>' . "\n";
}
        ?>
        <div class="formelementrow">
            <input type="checkbox" name="allow_interrupt" value="yes"
                   id="checkbox_allow_interrupt" <?php echo PMA_pluginCheckboxCheck('Import', 'allow_interrupt'); ?>/>
            <label for="checkbox_allow_interrupt"><?php echo __('Allow the interruption of an import in case the script detects it is close to the PHP timeout limit. <i>(This might be a good way to import large files, however it can break transactions.)</i>'); ?></label><br />
        </div>

        <?php
if (! (isset($timeout_passed) && $timeout_passed)) {
        ?>
        <div class="formelementrow">
            <label for="text_skip_queries"><?php echo __('Number of rows to skip, starting from the first row:'); ?></label>
            <input type="text" name="skip_queries" value="<?php echo PMA_pluginGetDefault('Import', 'skip_queries');?>" id="text_skip_queries" />
        </div>
            <?php
} else {
    // If timeout has passed,
    // do not show the Skip dialog to avoid the risk of someone
    // entering a value here that would interfere with "skip"
    ?>
        <input type="hidden" name="skip_queries" value="<?php echo PMA_pluginGetDefault('Import', 'skip_queries');?>" id="text_skip_queries" />
            <?php
}
        ?>
    </div>

    <div class="importoptions">
        <h3><?php echo __('Format:'); ?></h3>
        <?php echo PMA_pluginGetChoice('Import', 'format', $import_list); ?>
        <div id="import_notification"></div>
    </div>

    <div class="importoptions" id="format_specific_opts">
        <h3><?php echo __('Format-Specific Options:'); ?></h3>
        <p class="no_js_msg" id="scroll_to_options_msg">Scroll down to fill in the options for the selected format and ignore the options for other formats.</p>
        <?php echo PMA_pluginGetOptions('Import', $import_list); ?>
    </div>
        <div class="clearfloat"></div>
    <?php
// Encoding setting form appended by Y.Kawada
if (function_exists('PMA_set_enc_form')) { ?>
        <div class="importoptions" id="kanji_encoding">
            <h3><?php echo __('Encoding Conversion:'); ?></h3>
            <?php echo PMA_set_enc_form('            '); ?>
        </div>
    <?php
}
echo "\n";
    ?>
    <div class="importoptions" id="submit">
        <input type="submit" value="<?php echo __('Go'); ?>" id="buttonGo" />
    </div>
</form>
</div>