OwlCyberSecurity - MANAGER
Edit File: ImporterExporter.php
<?php namespace WPCoder\Dashboard; defined( 'ABSPATH' ) || exit; use WPCoder\WPCoder; class ImporterExporter { private $settings; public static function form_export(): void { ?> <form method="post"> <p></p> <p> <?php submit_button( __( 'Export All Data', 'wpcoder' ), 'secondary', 'submit', false ); ?> <?php wp_nonce_field( WPCoder::PREFIX . '_nonce', WPCoder::PREFIX . '_export_data' ); ?> </p> </form> <?php } public static function form_import(): void { ?> <form method="post" enctype="multipart/form-data" action=""> <p> <span class="wowp-file"> <input type="file" name="import_file" accept="*.json"/> </span> </p> <p> <label> <input type="checkbox" name="wowp_import_update" value="1"> <?php esc_attr_e( 'Update item if item already exists.' . 'wpcoder' ); ?> </label> </p> <p> <?php submit_button( __( 'Import', 'wpcoder' ), 'secondary', 'submit', false ); ?> <?php wp_nonce_field( WPCoder::PREFIX . '_nonce', WPCoder::PREFIX . '_import_data' ); ?> </p> </form> <?php } public static function import_data(): void { if ( self::get_file_extension( $_FILES['import_file']['name'] ) != 'json' ) { wp_die( __( 'Please upload a valid .json file', 'wpcoder' ), __( 'Error', 'wpcoder' ), [ 'response' => 400 ] ); } $import_file = $_FILES['import_file']['tmp_name']; $settings = json_decode( file_get_contents( $import_file ), false ); $columns = DBManager::get_columns(); $update = ! empty( $_POST['wowp_import_update'] ) ? '1' : ''; foreach ( $settings as $key => $val ) { $data = []; $formats = []; foreach ( $columns as $column ) { $name = $column->Field; $data[ $name ] = ! empty( $val->$name ) ? $val->$name : ''; if ( $name === 'id' || $name === 'status' || $name === 'mode' ) { $formats[] = '%d'; } else { $formats[] = '%s'; } } $check_row = DBManager::check_row( $data['id'] ); if ( ! empty( $update ) && ! empty( $check_row ) ) { $where = [ 'id' => absint( $data['id'] ), ]; $index = array_search( 'id', array_keys( $data ), true ); unset( $data['id'], $formats[ $index ] ); DBManager::update( $data, $where, $formats ); } elseif ( ! empty( $check_row ) ) { $index = array_search( 'id', array_keys( $data ), true ); unset( $data['id'], $formats[ $index ] ); DBManager::insert( $data, $formats ); } else { DBManager::insert( $data, $formats ); } } $redirect_link = add_query_arg( [ 'page' => WPCoder::SLUG, ], admin_url( 'admin.php' ) ); wp_safe_redirect( $redirect_link ); exit; } private static function get_file_extension( $str ) { $parts = explode( '.', $str ); return end( $parts ); } public static function export_item($id = 0, $action = '') { $page = isset( $_GET['page'] ) ? sanitize_text_field( $_GET['page'] ) : ''; $action = isset( $_GET['action'] ) ? sanitize_text_field( $_GET['action'] ) : $action; $id = isset( $_GET['id'] ) ? absint( $_GET['id'] ) : $id; if ( ( $page !== WPCoder::SLUG ) || ( $action !== 'export' ) || empty( $id ) ) { return false; } $data = DBManager::get_data_by_id( $id ); if ( ! $data ) { return false; } $name = trim( $data->title ); $name = str_replace( ' ', '-', $name ); $file_name = $name . '-database-' . date( 'm-d-Y' ) . '.json'; self::export( $file_name, [ $data ] ); return true; } public static function export_data(): bool { $file_name = WPCoder::SHORTCODE . '-database-' . date( 'm-d-Y' ) . '.json'; $data = DBManager::get_all_data(); if ( empty( $data ) ) { return false; } self::export( $file_name, $data ); return true; } private static function export( $file_name, $data ): void { ignore_user_abort( true ); nocache_headers(); header( 'Content-Type: application/json; charset=utf-8' ); header( 'Content-Disposition: attachment; filename=' . $file_name ); header( "Expires: 0" ); echo json_encode( $data ); exit; } }