<?php
/**
 * The admin-specific database functionality of the plugin.
 *
 * PHP version 5
 *
 * This file is used to handle all database related functions.
 *
 * LICENSE: GPL-2.0+
 *
 * @category   Module
 * @package    Accu_Auto_Backup
 * @subpackage Accu_Auto_Backup/admin
 * @author     Dhanashree Inc <business@dhanashree.com>
 * @copyright  2018 Dhanashree Inc
 * @license    http://www.gnu.org/licenses/gpl-2.0.txt GPL License
 * @version    SVN: 1.0.0
 * @link       http://www.dhanashree.com/
 * @since      File available since Release 1.0.0
 */
// If this file is called directly, abort.
if (! defined('ABSPATH')) {
    exit; // Exit if accessed directly
}
if (!class_exists('Accu_Auto_Backup_Db_Functions')) {

    /**
     * The admin-specific database functionality of the plugin.
     *
     * PHP version 5
     *
     * This file is used to handle all database related functions.
     *
     * LICENSE: GPL-2.0+
     *
     * @category   Module
     * @package    Accu_Auto_Backup
     * @subpackage Accu_Auto_Backup/admin
     * @author     Dhanashree Inc <business@dhanashree.com>
     * @copyright  2018 Dhanashree Inc
     * @license    http://www.gnu.org/licenses/gpl-2.0.txt GPL License
     * @version    Release: 1.0.0
     * @link       http://www.dhanashree.com/
     * @since      File available since Release 1.0.0
     */
    class Accu_Auto_Backup_Db_Functions
    {
        protected $accu_tbl;

        /**
         * Constructor of DB Function.
         *
         * @global type $wpdb
         */
        public function __construct()
        {
            // create action to backup
            global $wpdb;

            $this->accu_tbl = $wpdb->prefix . 'accubackup';
        }

        /**
         * Get Single Row from Table
         *
         * @param type $backup_id Pass Backup ID of table
         *
         * @global type $wpdb
         * @return type
         */
        public function getSingleAccuBackupTbl($backup_id)
        {
            if (!is_null($backup_id) && '' !== $backup_id) {
                global $wpdb;

                $results = $wpdb->get_row("SELECT * FROM $this->accu_tbl WHERE backup_id = $backup_id", ARRAY_A);

                return $results;
            }
        }

        /**
         * Display Admin Notices
         *
         * @return null
         */
        public function accuBackupAdminNotice()
        {
            $screen = get_current_screen();

            if ($screen->id === 'tools_page_accu_auto_backup') {

                //-- check folder creations
                $this->checkDbDirectory();
            }
        }

        /**
         * Remove Single Backup - AJAX Call
         *
         * @return null
         */
        public function removeSingleBackupHandler()
        {
            if (1 === check_ajax_referer('accu_auto_backup', '_ajax_nonce')) {
                $bkp_id = (int) $_POST['id'];

                $get_data = $this->getSingleAccuBackupTbl($bkp_id);

                if ($get_data && is_array($get_data)) {
                    $get_file_path = ACCU_AUTO_BACKUP_DIR . $get_data['filename'];

                    try {
                        $this->deleteBackupFile($bkp_id, $get_file_path);
                    } catch (Exception $ex) {
                    }
                }
            }
            wp_die();
        }

        /**
         * Delete/Remove Database Backup - AJAX Call
         *
         * @return null
         */
        public function deleteSelectedHandler()
        {
            if (1 === check_ajax_referer('accu_auto_backup', '_ajax_nonce') && $_POST['action'] === 'delete_selected' && is_array($_POST['checked']) && null !== $_POST['checked']) {
                $checked_list = $_POST['checked'];
                if (count($checked_list) > 0) {
                    foreach ($checked_list as $key => $single_id) {
                        $bkp_id = $single_id;

                        $get_data = $this->getSingleAccuBackupTbl($bkp_id);

                        if ($get_data && is_array($get_data)) {
                            $fpath = ACCU_AUTO_BACKUP_DIR . $get_data['filename'];

                            $this->deleteBackupFile($bkp_id, $fpath);
                        }
                    }
                }
            }
            wp_die();
        }
        /**
         * Download Database Backup - AJAX Call
         *
         * @return null
         */
        public function downloadSelectedHandler()
        {
            if (1 === check_ajax_referer('accu_auto_backup', '_ajax_nonce') && $_POST['action'] === 'download_selected' && is_array($_POST['checked']) && null !== $_POST['checked']) {
                $checked_list = $_POST['checked'];
                if (count($checked_list) > 0) {
                    $zip_file_list = array();

                    foreach ($checked_list as $key => $single_id) {
                        $bkp_id = $single_id;

                        $get_data = $this->getSingleAccuBackupTbl($bkp_id);

                        if ($get_data && is_array($get_data)) {
                            $get_file_path = $get_data['dir'];

                            $file_name = $get_data['filename'];

                            //$this->deleteBackupFile($bkp_id, $get_file_path);

                            if (file_exists($get_file_path)) {
                                $zip_file_list[$single_id]['dir'] = $get_file_path;
                                $zip_file_list[$single_id]['filename'] = $file_name;
                            }
                        }
                    }
                    /**
                     *  Now create the zip file
                     */
                    if (isset($zip_file_list) && null !== $zip_file_list && is_array($zip_file_list)) {
                        $siteName = preg_replace('/[^A-Za-z0-9\_]/', '_', get_bloginfo('name'));

                        $ZipFileName = $siteName . '_' . Date('Y_m_d') . '_' . Time('H:M:S') . '_' . 'accu_auto_backup_collection' . '.zip';

                        $arcname = ACCU_AUTO_BACKUP_DIR . $ZipFileName;

                        if (class_exists('ZipArchive')) {
                            $zip = new ZipArchive;
                            if ($zip->open($arcname, ZipArchive::CREATE) === true) {
                                // Add file to the zip file
                                foreach ($zip_file_list as $key => $single_file_data) {
                                    $zip->addFile($single_file_data['dir'], $single_file_data['filename']);
                                }

                                $zip->close();
                            }
                        } else {
                            error_log('Class ZipArchive Not Present');
                        }
                    }
                }
            }
            wp_die();
        }

        /**
         * Add Backquote for database table name.
         *
         * @param type $a_name will be table name
         *
         * @return string
         */
        public function backquote($a_name)
        {
            if (!empty($a_name) && '*' != $a_name) {
                if (is_array($a_name)) {
                    $result = array();
                    foreach ($a_name as $key => $val) {
                        $result[$key] = '`' . $val . '`';
                    }
                    return $result;
                } else {
                    return '`' . $a_name . '`';
                }
            } else {
                return $a_name;
            }
        }

        /**
         * Will Remove Directrory Trailing Slashes
         *
         * @param type $string Direcotry Name
         *
         * @return related string
         */
        public function stripDirSlash($string)
        {
            return preg_replace('#/+(,|$)#', '$1', $string);
        }
        
        /**
         * Will Create Mysql Database Backup.
         *
         * @global type $wpdb
         * @return string
         */
        public function accuAutoBackupCreateMysqlBackup()
        {
            global $wpdb;
            /* BEGIN : Prevent saving backup plugin settings in the database dump */

            //delete_option('wp_db_backup_options');
            /* END : Prevent saving backup plugin settings in the database dump */
            $accu_db_exclude_table = array();
            $accu_db_exclude_table = get_option('accu_auto_backup_exclude_table');
            $tables = $wpdb->get_col('SHOW TABLES');
            $output = '';
            foreach ($tables as $table) {
                if (empty($accu_db_exclude_table) || (!(in_array($table, $accu_db_exclude_table)))) {
                    $result = $wpdb->get_results("SELECT * FROM {$table}", ARRAY_N);
                    $row_drop = 'DROP TABLE IF EXISTS ' . $table . ";\n";
                    $row2 = $wpdb->get_row('SHOW CREATE TABLE ' . $table, ARRAY_N);
                    $output .= "\n\n" . $row_drop . "\n\n" . $row2[1] . ";\n\n";
                    for ($i = 0; $i < count($result); $i++) {
                        $row = $result[$i];
                        $output .= 'INSERT INTO ' . $table . ' VALUES(';
                        for ($j = 0; $j < count($result[0]); $j++) {
                            $row[$j] = $wpdb->_real_escape($row[$j]);
                            $output .= (isset($row[$j])) ? '"' . $row[$j] . '"' : '""';
                            if ($j < (count($result[0]) - 1)) {
                                $output .= ',';
                            }
                        }
                        $output .= ");\n";
                    }
                    $output .= "\n";
                }
            }
            $wpdb->flush();
            /* BEGIN : Prevent saving backup plugin settings in the database dump */

            //add_option('wp_db_backup_options', $settings_backup);
            /* END : Prevent saving backup plugin settings in the database dump */
            return $output;
        }

        /**
         * Generate the archive file of backup.
         *
         * @return string uploaded path
         */
        public function accuAutoBackupCreateArchive()
        {

            /* Begin : Setup Upload Directory, Secure it and generate a random file name */

            $this->checkDbDirectory();

            $path_info = wp_upload_dir();

            $htassesText = '';

            fclose(fopen(ACCU_AUTO_BACKUP_DIR . 'index.html', 'w'));

            /* Begin : Generate SQL DUMP and save to file database.sql */
            $siteName = preg_replace('/[^A-Za-z0-9\_]/', '_', get_bloginfo('name'));

            $WPDBFileName = $siteName . '_' . Date('Y_m_d') . '_' . Time('H:M:S') . '_' . substr(md5(AUTH_KEY), 0, 7) . '_accu_auto_backup';

            $SQLfilename = $WPDBFileName . '.sql';

            $filename = $WPDBFileName . '.zip';

            /**
             * CREATE SQL **
             */
            $handle = fopen(ACCU_AUTO_BACKUP_DIR . $SQLfilename, 'w+');

            fwrite($handle, $this->accuAutoBackupCreateMysqlBackup());

            fclose($handle);

            $upload_path = array(
                'filename' => ($filename),
                'dir' => (ACCU_AUTO_BACKUP_DIR . $filename),
                'url' => (ACCU_AUTO_BACKUP_DIR_URL . $filename),
                'size' => 0,
            );

            $arcname = ACCU_AUTO_BACKUP_DIR . $WPDBFileName . '.zip';

            if (class_exists('ZipArchive')) {
                $zip = new ZipArchive;
                $zip->open($arcname, ZipArchive::CREATE);
                $zip->addFile(ACCU_AUTO_BACKUP_DIR . $SQLfilename, $SQLfilename);
                $zip->close();
            } else {
                error_log('Accu Auto Backup :  Class ZipArchive Not Present');
            }

            $logMessage = 'Database File Name :' . $filename;

            $upload_path['sqlfile'] = ACCU_AUTO_BACKUP_DIR . $SQLfilename;
            
            $upload_path['size'] = filesize($upload_path['sqlfile']);

            $accu_auto_backup_log = get_option('accu_auto_backup_log');

            if ($accu_auto_backup_log == 1) {
                $accu_db_exclude_table = get_option('accu_auto_backup_exclude_table');
                if (!empty($accu_db_exclude_table)) {
                    $logMessage .= '<br> Exclude Table : ' . implode(', ', $accu_db_exclude_table);
                }
                $upload_path['log'] = $logMessage;
            }
            @unlink(ACCU_AUTO_BACKUP_DIR . $SQLfilename);
            return $upload_path;
        }

        /**
         * Get list of table rows of accu table from database.
         *
         * @global type $wpdb
         * @return type
         */
        public function getAccuAutoBackupBackps()
        {
            global $wpdb;
            $results = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}accubackup WHERE 1 ORDER BY backup_id DESC", ARRAY_A);
            return $results;
        }

        /**
         * Get all rows of accu table from database - AJAX Call
         *
         * @global type $wpdb
         *
         * @return list
         */
        public function getAccuAutoBackupBackpsList()
        {
            global $wpdb;

            if (1 === check_ajax_referer('accu_auto_backup', '_ajax_nonce')) {
                $results = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}accubackup WHERE 1 ORDER BY backup_id DESC", ARRAY_A);

                if (isset($results)) {
                    $new_array = array();

                    foreach ($results as $key => $single_row) {
                        //$new_array []
                        $new_array [$key] = $single_row;
                    }
                }

                wp_send_json($new_array);
                ;
            }
            wp_die();
        }

        /**
         * Will Remove Database from Directory & Table.
         *
         * @param type $backup_id Backup ID from Table
         * @param type $dir       Directory Path
         *
         * @global type $wpdb
         *
         * @return null
         */
        public function deleteBackupFile($backup_id, $dir)
        {
            if (isset($backup_id) && isset($dir) && file_exists($dir)) {
                $delete_file = @unlink($dir);
                if (true === $delete_file) {
                    global $wpdb;
                    // Using where formatting.
                    try {
                        $wpdb->delete($this->accu_tbl, array('backup_id' => $backup_id), array('%d'));
                    } catch (Exception $e) {
                        $log_message = 'Exception (' . get_class($e) . ') occurred during deletion of backup : ' . $e->getMessage() . ' (Code: ' . $e->getCode() . ', line ' . $e->getLine() . ' in ' . $e->getFile() . ')';
                        error_log($log_message);
                    }
                    //put log
                }
            }
        }

        /**
         * Make the zip file and fire the backup archive event.
         *
         * @return string Reponse of all backup process.
         */
        public function accuAutoBackupBkpProcess()
        {

            //added in v.3.9.5
            $chk_cron_enable = get_option('accu_auto_backup_sc_auto_enabled');

            if (isset($chk_cron_enable) && $chk_cron_enable != 'yes') {
                return __('Cron is disabled,please enable cron from settings.', 'accu-auto-backup');
            }

            ini_set('max_execution_time', '5000');
            ini_set('max_input_time', '5000');
            ini_set('memory_limit', '1000M');
            set_time_limit(0);

            $details = $this->accuAutoBackupCreateArchive();

            if ('' == $details || null === $details) {
                return __('Backup create archive has error.', 'accu-auto-backup');
            }

            $options = array();

            $accu_auto_backup_log = get_option('accu_auto_backup_log');
            if ($accu_auto_backup_log == 1) {
                $logMessage = $details['log'];
            } else {
                $logMessage = '';
            }

            //REMOVE BACKUP ABOVE LIMIT
            $number_of_backups_limit = (int) get_option('accu_auto_backup_bkp_store_limit');

            if ($number_of_backups_limit !== 0) {
                $files = $this->getAccuAutoBackupBackps();
                if ($files) {
                    foreach ($files as $key => $file_list) {
                        if (++$key >= $number_of_backups_limit) {
                            $file_directory = ACCU_AUTO_BACKUP_DIR . $file_list['filename'];
                            $this->deleteBackupFile($file_list['backup_id'], $file_directory);
                        }
                    }
                }
            }

            $options[] = array(
                'date' => time(),
                'filename' => $details['filename'],
                'url' => $details['url'],
                'dir' => $details['dir'],
                'log' => $logMessage,
                'sqlfile' => $details['sqlfile'],
                'size' => $details['size'],
            );

            $db_tbl_insert = array(
                'filename' => $details['filename'],
                'log' => $logMessage,
                'size' => $details['size'],
                'date_added' => current_time('mysql', 1),
            );

            global $wpdb;

            try {
                $result = $wpdb->insert($this->accu_tbl, $db_tbl_insert);
            } catch (Exception $ex) {
                $log_message = 'Accu Auto Backp : Exception (' . get_class($ex) . ') occurred during create archive: ' . $ex->getMessage() . ' (Code: ' . $ex->getCode() . ', line ' . $ex->getLine() . ' in ' . $ex->getFile() . ')';
                return $log_message;
                error_log($logMessage);
            }

            update_option('accu_last_backup', current_time('timestamp', 1));

            //$args = array($details['filename'], $details['dir'], $logMessage, $details['size']);
            //return sprintf(__("Success! Accu Auto Backup successfully done at %s having file name %s and size %d on disk.",'accu_auto_backup'),current_time('timestamp'),$db_tbl_insert['filename'],(float)$db_tbl_insert['size']);
            $db_response = sprintf(__('Success! Accu Auto Backup successfully done on %1$s having file name %2$s and size %3$d on disk.', 'accu-auto-backup'), date('Y-m-d H:i:s', current_time('timestamp')), $db_tbl_insert['filename'], (float) $db_tbl_insert['size']);

            return $db_response;

            //do_action_ref_array('wp_db_backup_completed', array(&$args));
        }

        /**
         * Will Clear or Delete any unexcepted files in folder as well in table.
         *
         * @global type $wpdb
         * @return null
         */
        public function clearUndeletedBackups()
        {
            $options = $this->getAccuAutoBackupBackps();
            $newoptions = array();
            $backup_check_list = array('.htaccess', 'index.html');
            $deleteMessage = 'ACCU AUTO BACKUP : Deleted Files:';
            foreach ($options as $option) {
                $backup_check_list[] = $option['filename'];
            }
            $path_info = wp_upload_dir();
            $accu_backup_db_backup_path = ACCU_AUTO_BACKUP_DIR;

            $file_list = array();

            // Open a directory, and read its contents
            if (is_dir($accu_backup_db_backup_path)) {
                if ($dh = opendir($accu_backup_db_backup_path)) {
                    while (($file = readdir($dh)) !== false) {
                        $file_list[] = $file;
                        if (!(in_array($file, $backup_check_list))) {
                            if ($file == '.' || $file == '..') {
                                continue;
                            }
                            @unlink($accu_backup_db_backup_path . $file);
                            $deleteMessage .= ' ' . $file;
                        }
                    }
                    closedir($dh);
                }
                //error_log($deleteMessage);
            }

            /*             * ****
             *  Now check for exists in database and not in folder
             * *** */

            if (is_array($file_list) && is_dir($accu_backup_db_backup_path) && is_array($options) && is_array($backup_check_list)) {
                foreach ($options as $key => $single_file_info) {
                    if (!in_array($single_file_info['filename'], $file_list)) {
                        $backup_id = $single_file_info['backup_id'];
                        if (!empty($backup_id) && '' !== $backup_id) {
                            global $wpdb;
                            try {
                                $wpdb->delete($this->accu_tbl, array('backup_id' => $backup_id), array('%d'));
                            } catch (Exception $e) {
                                $log_message = 'Exception (' . get_class($e) . ') occurred during deletion of backup : ' . $e->getMessage() . ' (Code: ' . $e->getCode() . ', line ' . $e->getLine() . ' in ' . $e->getFile() . ')';
                                error_log($log_message);
                            }
                        }
                    }
                }
            }
        }

        /**
         * Will check and create default directory if not exists.
         *
         * @return null
         */
        public function checkDbDirectory()
        {
            $upload_dir = wp_upload_dir();

            $dir = ACCU_AUTO_BACKUP_DIR;

            if (false === is_dir($dir)) {
                wp_mkdir_p(ACCU_AUTO_BACKUP_DIR);

                @touch(ACCU_AUTO_BACKUP_DIR . 'index.html');
            }

            if (is_dir($dir) && !is_writable($dir)) {
                error_log('Accu Auto Backp : Error - Permission denied make sure you have write permission for folder writable.'); ?>
                <div class="notice notice-error is-dismissible display">
                    <h4><?php _e('Accu Auto Backup', 'accu-auto-backup'); ?></h4>
                    <p><?php printf(__('Error: Permission denied, make sure you have write permission for %s folder', 'accu-auto-backup'), $dir); ?> </p>
                </div>
                <?php
                return false;
            }
        }

        /**
         *  Formate file size according to size like KB, MB and GB.
         *
         * @param type $bytes     will have bytes
         * @param type $precision will check precision
         *
         * @return string formated size
         */
        public function accuAutoBackupFormatBytes($bytes, $precision = 2)
        {
            $units = array('B', 'KB', 'MB', 'GB', 'TB');
            $bytes = max($bytes, 0);
            $pow = floor(($bytes ? log($bytes) : 0) / log(1024));
            $pow = min($pow, count($units) - 1);
            $bytes /= pow(1024, $pow);
            return round($bytes, $precision) . ' ' . $units[$pow];
        }

        /**
         * Downlaod DB
         *
         * @param type $query_vars query string where
         *
         * @return null
         */
        public function downloadDb($query_vars)
        {
            if (isset($query_vars) && null !== $query_vars && '' !== $query_vars) {
                if (isset($query_vars['attachment']) && !empty($query_vars['attachment'])) {
                    //$get_query_string = explode("&",$query_vars['attachment']);
                }
            }
        }

        /**
         * Responsible for listing stored backups with Datatable.
         *
         * @return list of backups
         */
        public function listBackups()
        {
            $this->clearUndeletedBackups();

            $options = $this->getAccuAutoBackupBackps();

            $bulk_action = __('Bulk Actions', 'accu-auto-backup');
            $delete = __('Delete', 'accu-auto-backup');
            $download = __('Download', 'accu-auto-backup');
            $apply = __('Apply', 'accu-auto-backup');

            //$no = __("No.", 'accu-auto-backup');
            $heading_date = __('Date', 'accu-auto-backup');
            $size = __('Size', 'accu-auto-backup');
            $backup_file = __('Backup File', 'accu-auto-backup');
            $remove_file = __('Remove File', 'accu-auto-backup');

            $no_backup = __('No backups are currently available.', 'accu-auto-backup');

            //$nonce = wp_nonce_field('accu_auto_backup');
            //            echo "<pre>";
            //            print_r($options);
            //            echo "</pre>";
            //            exit();
            //var_dump(get_option('accu_auto_backup_backups'));
            if ($options) {
                echo '<h2 class="accu-screen-reader-text"> ' . __('List of database backups', 'accu-auto-backup') . '</h2> 
                  <div class="table-responsive">
                                <div id="dataTables-example_wrapper" class="dataTables_wrapper form-inline" role="grid">                               
                                
                                <div class="bult_action_div actions bulkactions">
                                    <select id="accu_list_bulk" >
                                        <option selected value="-1"> ' . $bulk_action . '</option>
                                        <option value="delete_selected">' . $delete . '</option>
                                        <!--<option value="download_selected">' . $download . '</option>--->
                                     </select>
                                     <input type="button" id="bulk_action_submit" class="button action" name="bulk_action_submit" value="' . $apply . '" />
                                </div>

                                <table class="wp-list-table widefat fixed striped pages" id="accu_backup_backups_list">
                                    <thead>';
                echo '<tr class="accu-bkp-header">';
                echo '<th  width="5%" class="nosort"><input name="select_all" class="accu_chk_select_all" value="1" type="checkbox"></th>';
                //echo '<th  width="5%" class="manage-column" scope="col"  style="text-align: center;">' . $no . '</th>';
                echo '<th class="manage-column" scope="col" width="25%">' . $heading_date . '</th>';
                //echo '<th class="manage-column" scope="col" width="5%"></th>';
                echo '<th class="manage-column" scope="col" width="10%">' . $size . '</th>';
                echo '<th class="manage-column nosort " scope="col" width="15%">' . $backup_file . '</th>';
                echo '<th class="manage-column nosort sorting_disabled" scope="col" width="15%">' . $remove_file . '</th>';
                //echo '<th class="manage-column" scope="col" width="15%"></th>';
                echo '</tr>';
                echo '</thead>';

                echo '<tfoot>';
                echo '<tr class="">';
                echo '<th  width="5%" class="nosort">&nbsp;</th>';
                //echo '<th  width="5%" class="manage-column" scope="col"  style="text-align: center;">' . $no . '</th>';
                echo '<th class="manage-column" scope="col" width="25%">' . $heading_date . '</th>';
                //echo '<th class="manage-column" scope="col" width="5%"></th>';
                echo '<th class="manage-column" scope="col" width="10%">' . $size . '</th>';
                echo '<th class="manage-column nosort " scope="col" width="15%">' . $backup_file . '</th>';
                echo '<th class="manage-column nosort sorting_disabled" scope="col" width="15%">' . $remove_file . '</th>';
                //echo '<th class="manage-column" scope="col" width="15%"></th>';
                echo '</tr>';
                echo '</tfoot>';

                echo '<tbody>';
                $count = 1;
                foreach ($options as $key => $option) {
                    $single_id = $option['backup_id'];
                    $backup_time = get_date_from_gmt($option['date_added'], 'H:i');
                    $backup_date = get_date_from_gmt($option['date_added'], 'jS, F Y');

                    //get_date_from_gmt(date( 'Y-m-d H:i:s',$this->get_backup_details('next')), 'D, F j, Y H:i');
                    //$accu_nonce = wp_create_nonce('accu_auto_backup');
                    //$download_link = admin_url('accu_backup_id='.$single_id.'&accu_nonce='.$accu_nonce);
                    $download_link = ACCU_AUTO_BACKUP_DIR_URL . $option['filename'];

                    echo '<tr ' . ((($count % 2) == 0) ? ' class="alternate"' : '') . '>';
                    echo '<td row_id="' . $single_id . '" class="check-column"><input type="checkbox" class="bkp_chkbx" value="' . $single_id . '"  /></td>';
                    //echo '<td style="text-align: center;">' . $count . '</td>';
                    echo '<td>' . $backup_date . '<br />' . $backup_time . '</td>';
                    //                    echo '<td class="wpdb_log">';
                    //                    if (!empty($option['log'])) {
                    //                        echo '<button id="popoverid" type="button" class="popoverid btn" data-toggle="popover" title="Log" data-content="' . $option['log'] . '"><span class="glyphicon glyphicon-list-alt" aria-hidden="true"></span></button>';
                    //                    }
                    //                    echo '</td>';
                    echo '<td>' . $this->accuAutoBackupFormatBytes($option['size']) . '</td>';
                    echo '<td>';
                    echo '<a class="accu-btn accu-btn-dwnld" href="' . $download_link . '" >';
                    echo '<span class="glyphicon glyphicon-download-alt"></span>' . __('Download', 'accu-auto-backup') . '</a></td>';
                    echo '<td><a  row_id="' . $single_id . '"  class="accu-btn accu-btn-remove" href="javascript:void();" class="btn btn-default"><span style="color:red" class="glyphicon glyphicon-trash"></span> Remove Backup<a/></td>';
                    echo '</tr>';
                    $count++;
                }
                echo '</tbody>';
                //$nonce;
                echo ' </table>     
                                </div>
                                  </div>';
            } else {
                echo '<p class="no-backup">' . $no_backup . '</p>';
            }
        }
    }
}