<?php
if (!defined('WPINC')) {
    die;
}

global $wpdb;
$tb = $wpdb->prefix . Wt_Import_Export_For_Woo_Product_Basic::$template_tb;
// phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared,WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
$val = $wpdb->get_results("SELECT * FROM $tb ORDER BY id DESC", ARRAY_A);
// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
$pre_saved_templates = ($val ? $val : array());
if (!empty($pre_saved_templates)):
    ?>


    <style>
        .wt_ier_template_list_table {
            width: 50%;
            border-spacing: 0px;
            border-collapse: collapse;
            margin-top: 15px;
        }
        .wt_ier_template_list_table th {
            padding: 5px 5px;
            background: #f9f9f9;
            color: #333;
            text-align: center;
            border: solid 1px #e1e1e1;
            font-weight: bold;
        }
        .wt_ier_template_list_table td {
            padding: 5px 5px;
            background: #fff;
            color: #000;
            text-align: center;
            border: solid 1px #e1e1e1;
        }
    </style>
    <div class="wt-ier-import-export-templates">
        <h3><?php esc_html_e('Import export pre-saved templates', 'product-import-export-for-woo'); ?></h3>
        <div class="wt_ier_template_list_table_data">
        <table class="wt_ier_template_list_table">
            <thead>
                <tr>
                    <th style="width:50px;">#</th>
                    <th><?php esc_html_e('Name', 'product-import-export-for-woo'); ?></th>
                    <th><?php esc_html_e('Item', 'product-import-export-for-woo'); ?></th>
                    <th><?php esc_html_e('Type', 'product-import-export-for-woo'); ?></th>
                    <th><?php esc_html_e('Action', 'product-import-export-for-woo'); ?></th>                                
                </tr>
            </thead>
            <tbody>
                <?php
                $num = 1;
                foreach ($pre_saved_templates as $key => $value):
                    ?>
                    <tr data-row-id="<?php echo absint($value['id']); ?>">
                        <td><?php echo esc_html($num); ?></td>                                    
                        <td><?php echo esc_html($value['name']); ?></td>
                        <td><?php echo esc_html($value['item_type']); ?></td>
                        <td><?php echo esc_html($value['template_type']); ?></td>
                        <td><button data-id="<?php echo absint($value['id']); ?>" title="<?php esc_attr_e('Delete', 'product-import-export-for-woo'); ?>" class="button button-secondary wt_ier_delete_template"><span><?php esc_html_e('Delete', 'product-import-export-for-woo'); ?></span></button></td>
                    </tr>           
                    <?php
                    $num++;
                endforeach;
                ?>
            </tbody>
        </table>
        </div>
    </div>
<?php endif; ?>