<?php
/*
Plugin Name: Paris 2024
Description: Paris 2024 olimpiyatları için oluşturulan sayfanın yayın ve yönetim eklentisi.
Version: 1.0
Author: TurkTicaret.NET
*/

//error_reporting(E_ALL);
//ini_set('display_errors', 1);

$turkticaret_prefix = '/';
// Yönlendirme kuralı index.php?cpage=paratriatlon sayfasında içeriğimizi yayınlıyoruz
// bunu da turkticaret_custom_page_template() metodu ile yapıyoruz
// bu sayfayı da rewrite rule ekleyerek " /paratriatlon " sayfasına yönlendiriyoruz
// function turkticaret_add_custom_rewrite_rule()
// {
//     add_rewrite_rule(
//         '^paris2024/?',
//         'index.php?cpage=paris2024',
//         'top'
//     );
// }


/*
function turkticaret_add_custom_rewrite_rule()
{
    add_rewrite_rule(
        '^musabakalar/paris-2024-paralimpik-oyunlari/?',
        'index.php?cpage=paris2024',
        'top'
    );
    add_rewrite_rule(
        '^/?$',
        'index.php?cpage=paris2024',
        'top'
    );
}
function turkticaret_flush_rewrite_rules()
{
    flush_rewrite_rules();
    turkticaret_add_custom_rewrite_rule();
}
add_action('init', 'turkticaret_flush_rewrite_rules');

// cpage query parameter ekleme
function turkticaret_add_custom_query_vars($vars)
{
    $vars[] = 'cpage';
    return $vars;
}
add_filter('query_vars', 'turkticaret_add_custom_query_vars');
*/

// HTML Sayfa burada render ediliyor
function turkticaret_custom_page_template()
{
    global $wp_query;
    $file = plugin_dir_path(__FILE__) . 'assets/index.php';

    $request_uri = $_SERVER['REQUEST_URI'];
    $parsed_url = parse_url($request_uri);
    $path = isset($parsed_url['path']) ? trim($parsed_url['path'], '/') : '';

    if ($path == 'blog' || $path == 'blog/musabakalar/paris-2024-paralimpik-oyunlari') {
        if (file_exists($file)) {
            // wordpress veritabanı erişimi için aldık
            require_once(dirname(dirname(dirname(plugin_dir_path(__FILE__)))) . '/wp-load.php');
            // veritabanı nesnesi
            global $wpdb;

            $sum_sporcu = [];
            // Toplam sporcu sayısı
            //$table_name = $wpdb->prefix . 'tmpk_sportspage';
            //$results = $wpdb->get_results("SELECT COUNT(*) as cnt FROM $table_name;");
            $sum_sporcu[] = 94;
            //$sum_sporcu[] = $results[0]->cnt;

            // Kadın sporcu sayısı
            //$table_name = $wpdb->prefix . 'tmpk_sportspage';
            //$results = $wpdb->get_results("SELECT COUNT(*) as cnt FROM $table_name WHERE gender=0;");
            $sum_sporcu[] = 48;
            //$sum_sporcu[] = $results[0]->cnt;

            // Erkek sporcu sayısı
            // = $wpdb->prefix . 'tmpk_sportspage';
            //$results = $wpdb->get_results("SELECT COUNT(*) as cnt FROM $table_name WHERE gender=1;");
            $sum_sporcu[] = 46;
            //$sum_sporcu[] = $results[0]->cnt;

            $table_name = $wpdb->prefix . 'tmpk_sportspage';
            $sporcular = $wpdb->get_results("SELECT * FROM $table_name");

            $table_name = $wpdb->prefix . 'tmpk_tesisler';
            $tesisler = $wpdb->get_results("SELECT * FROM $table_name");

            // Hakkında sayfası
            $table_name = $wpdb->prefix . 'tmpk_aboutpage';
            $about_page = $wpdb->get_row("SELECT * FROM $table_name WHERE id = 1");
            $about_content = $about_page ? $about_page->content : '';
            
            
            if($path=='blog'){
                echo 'BURASI ANASAYFA';
            }
            
            include($file);
            exit; // Sayfa çıktıktan sonra WordPress akışını durdurun
        } else {
            wp_die('404 Not Found');
        }
    }

}
add_action('template_redirect', 'turkticaret_custom_page_template');


function tmpk_add_admin_menu()
{
    // Ana menüyü ekle
    add_menu_page(
        'Paris 2024',
        'Paris 2024',
        'manage_options',
        'tmpk_plugin',
        'turkticaret_plugin_page',
        'dashicons-admin-generic',
        20
    );

    // Alt menüyü ekle
    add_submenu_page(
        'tmpk_plugin',
        'Sporcular',
        'Sporcular',
        'manage_options',
        'tmpk_sportspage',
        'turkticaret_sports_page'
    );

    // Alt menüyü ekle
    add_submenu_page(
        'tmpk_plugin',
        'Tesisler',
        'Tesisler',
        'manage_options',
        'tmpk_tesislerpage',
        'turkticaret_tesisler_page'
    );

    // Alt menüyü ekle
    add_submenu_page(
        'tmpk_plugin',
        'Hakkında',
        'Hakkında',
        'manage_options',
        'tmpk_aboutpage',
        'turkticaret_about_page'
    );

}
add_action('admin_menu', 'tmpk_add_admin_menu');

// Ana menü sayfasının içeriğini göster
function turkticaret_plugin_page()
{
    ?>
    <div class="wrap">
        <h1>TMPK Plugin Ana Sayfa</h1>
        <p>Burada TMPK Plugin ile ilgili genel bilgiler yer alacak.</p>
    </div>
    <?php
}

// Sporcu ekleme sayfası ve işlemleri
function turkticaret_sports_page()
{
    global $turkticaret_prefix;
    ?>
    <div class="wrap">
        <h1>Sporcular</h1>
        <form method="post" enctype="multipart/form-data">
            <table class="form-table">
                <tr>
                    <th scope="row">Sporcu Resmi</th>
                    <td><input type="file" name="sport_image" accept="image/*"></td>
                </tr>
                <tr>
                    <th scope="row">Adı Soyadı</th>
                    <td><input type="text" name="sport_name" required></td>
                </tr>
                <tr>
                    <th scope="row">Bağlantı Linki</th>
                    <td><input type="text" name="sport_baglanti"></td>
                </tr>
                <tr>
                    <th scope="row">Cinsiyet</th>
                    <td>
                        <label><input type="radio" name="sport_gender" value="0" required> Kadın</label><br>
                        <label><input type="radio" name="sport_gender" value="1" required> Erkek</label>
                    </td>
                </tr>
                <tr>
                    <th scope="row">Sıra</th>
                    <td><input type="text" name="sport_sira" value="1" required></td>
                </tr>
            </table>
            <?php submit_button('Sporcu Ekle'); ?>
        </form>

        <?php
        // Form gönderildiyse işleme
        if ($_SERVER['REQUEST_METHOD'] === 'POST' && !empty($_FILES['sport_image']['name']) && !empty($_POST['sport_name'])) {
            $image = $_FILES['sport_image'];
            $name = sanitize_text_field($_POST['sport_name']);
            $gender = intval($_POST['sport_gender']);
            $sira = intval($_POST['sport_sira']);
            $baglanti = $_POST['sport_baglanti'];

            // Resmi yükle
            $upload_dir = wp_upload_dir();
            $target_dir = plugin_dir_path(__FILE__) . 'assets/uploads/';
            if (!file_exists($target_dir)) {
                mkdir($target_dir, 0755, true);
            }
            $target_file = $target_dir . basename($image['name']);
            move_uploaded_file($image['tmp_name'], $target_file);

            $split_path = explode('/wp-content', $target_file, 2);
            if (isset($split_path[1])) {
                $target_file = $turkticaret_prefix . 'wp-content' . $split_path[1];
            }

            // Sporcu bilgilerini veritabanına kaydet
            global $wpdb;
            $table_name = $wpdb->prefix . 'tmpk_sportspage';
            $wpdb->insert($table_name, array(
                'name' => $name,
                'image' => $target_file,
                'gender' => $gender,
                'baglanti' => $baglanti,
                'sira' => $sira
            ));

            echo '<div class="updated"><p>Sporcu eklendi.</p></div>';
        }

        // Sporcuları listele
        global $wpdb;
        $table_name = $wpdb->prefix . 'tmpk_sportspage';
        $sports = $wpdb->get_results("SELECT * FROM $table_name order by sira asc");

        if ($sports) {
            echo '<h2>Sporcular</h2>';
            echo '<table class="wp-list-table widefat fixed">';
            echo '<thead><tr><th>Resim</th><th>Adı Soyadı</th><th>Bağlantı</th><th>Cinsiyet</th><th>Sıra</th><th>Sil</th><th>Düzenle</th></tr></thead>';
            echo '<tbody>';
            foreach ($sports as $sport) {
                $gender_text = $sport->gender == 0 ? 'Kadın' : 'Erkek';
                echo '<tr>';
                echo '<td><img src="' . esc_url($sport->image) . '" width="100"></td>';
                echo '<td>' . esc_html($sport->name) . '</td>';
                echo '<td>' . esc_html($sport->baglanti) . '</td>';
                echo '<td>' . esc_html($gender_text) . '</td>';
                echo '<td>' . esc_html($sport->sira) . '</td>';
                echo '<td><a href="' . wp_nonce_url(admin_url('admin-post.php?action=delete_sport&sport_id=' . $sport->id), 'delete_sport') . '">Sil</a></td>';
                echo '<td><a href="' . admin_url('admin.php?page=edit_sport&sport_id=' . $sport->id) . '">Düzenle</a></td>';

                echo '</tr>';
            }
            echo '</tbody>';
            echo '</table>';
        }
}

// Tesisler
// Tesisler ekleme sayfası ve işlemleri
function turkticaret_tesisler_page()
{
    global $turkticaret_prefix;
    ?>
        <div class="wrap">
            <h1>Tesisler</h1>
            <form method="post" enctype="multipart/form-data">
                <table class="form-table">
                    <!-- <tr>
                        <th scope="row">Tesis Resmi</th>
                        <td><input type="file" name="tesis_image" accept="image/*"></td>
                    </tr> -->
                    <tr>
                        <th scope="row">Görsel Linki</th>
                        <td><input type="text" name="tesis_image" required></td>
                    </tr>
                    <tr>
                        <th scope="row">Adı</th>
                        <td><input type="text" name="tesis_name" required></td>
                    </tr>
                    <tr>
                        <th scope="row">Bağlantı</th>
                        <td><input type="text" name="tesis_glink" required></td>
                    </tr>
                    <tr>
                        <th scope="row">Sıra</th>
                        <td><input type="text" name="tesis_sira" value="1" required></td>
                    </tr>
                </table>
                <?php submit_button('Tesis Ekle'); ?>
            </form>

            <?php
            // Form gönderildiyse işleme
            if ($_SERVER['REQUEST_METHOD'] === 'POST' && /*!empty($_FILES['tesis_image']['name']) &&*/ !empty($_POST['tesis_name'])) {
                // $image = $_FILES['tesis_image'];
                $image = sanitize_text_field($_POST['tesis_image']);
                $name = sanitize_text_field($_POST['tesis_name']);
                $glink = esc_url_raw($_POST['tesis_glink']);
                $sira = sanitize_text_field($_POST['tesis_sira']);


                // Resmi yükle
                // $upload_dir = wp_upload_dir();
                // $target_dir = plugin_dir_path(__FILE__) . 'assets/uploads/';
                // if (!file_exists($target_dir)) {
                //     mkdir($target_dir, 0755, true);
                // }
                // $target_file = $target_dir . basename($image['name']);
                // move_uploaded_file($image['tmp_name'], $target_file);
        
                // $split_path = explode('/wp-content', $target_file, 2);
                // if (isset($split_path[1])) {
                //     $target_file = $turkticaret_prefix . 'wp-content' . $split_path[1];
                // }
        
                // Tesis bilgilerini veritabanına kaydet
                global $wpdb;
                $table_name = $wpdb->prefix . 'tmpk_tesisler';
                $wpdb->insert($table_name, array(
                    'name' => $name,
                    // 'image' => $target_file,
                    'image' => $image,
                    'glink' => $glink,
                    'sira' => $sira
                ));

                echo '<div class="updated"><p>Tesis eklendi.</p></div>';
            }

            // Tesisleri listele
            global $wpdb;
            $table_name = $wpdb->prefix . 'tmpk_tesisler';
            $facilities = $wpdb->get_results("SELECT * FROM $table_name");

            if ($facilities) {
                echo '<h2>Tesisler</h2>';
                echo '<table class="wp-list-table widefat fixed">';
                echo '<thead><tr><th>Görsel</th><th>Adı</th><th>Bağlantı</th><th>Sıra</th><th>Sil</th><th>Düzenle</th></tr></thead>';

                echo '<tbody>';
                foreach ($facilities as $facility) {
                    echo '<tr>';
                    echo '<td><img src="' . esc_url($facility->image) . '" width="100"></td>';
                    echo '<td>' . esc_html($facility->name) . '</td>';
                    echo '<td><a href="' . esc_url($facility->glink) . '" target="_blank">Bağlantı</a></td>';
                    echo '<td>' . esc_html($facility->sira) . '</td>';
                    echo '<td><a href="' . wp_nonce_url(admin_url('admin-post.php?action=delete_facility&facility_id=' . $facility->id), 'delete_facility') . '">Sil</a></td>';
                    echo '<td><a href="' . admin_url('admin.php?page=edit_facility&facility_id=' . $facility->id) . '">Düzenle</a></td>';
                    echo '</tr>';
                }
                echo '</tbody>';
                echo '</table>';
            }
}

function turkticaret_about_page()
{
    global $turkticaret_prefix;

    wp_enqueue_script('tab-lib', 'https://atakanargn.github.io/prodseen-tab-library/js/prs-tab.min.js', array('jquery'), null, true);


    // Process the form submission
    if ($_SERVER['REQUEST_METHOD'] === 'POST') {
        $content = wp_kses_post($_POST['about_content']);

        // Save to the database
        global $wpdb;
        $table_name = $wpdb->prefix . 'tmpk_aboutpage';

        // Update existing content or insert new
        if ($wpdb->get_var("SELECT COUNT(*) FROM $table_name WHERE id = 1") > 0) {
            $wpdb->update($table_name, array('content' => $content), array('id' => 1));
        } else {
            $wpdb->insert($table_name, array('content' => $content));
        }

        echo '<div class="updated"><p>Hakkında sayfası güncellendi.</p></div>';
    }

    ?>
            <div class="wrap">
                <h1>Hakkında</h1>

                <?php
                // Retrieve existing content
                global $wpdb;
                $table_name = $wpdb->prefix . 'tmpk_aboutpage';
                $about_page = $wpdb->get_row("SELECT * FROM $table_name WHERE id = 1");
                $content = $about_page ? $about_page->content : '';
                ?>
                <style>
                    /* Genel Stil */
body {
    font-family: Arial, sans-serif;
}

/* Editör Container */
.editor-container {
    display: flex;
    gap: 16px;
}

/* Editör Header */
.editor-header {
    margin-bottom: 8px;
}

.editor-label {
    font-weight: bold;
    font-size: 18px;
}

/* Editör Butonları */
.editor-buttons {
    margin-bottom: 8px;
    display: flex;
    flex-wrap: wrap;
    gap: 8px;
}

.editor-buttons button {
    background-color: #007cba;
    color: #fff;
    border: none;
    padding: 8px 16px;
    font-size: 14px;
    cursor: pointer;
    border-radius: 4px;
    transition: background-color 0.3s ease;
}

.editor-buttons button:hover {
    background-color: #005a87;
}

/* Editör Textarea */
.editor-textarea {
    width: 100%;
    height: 500px;
    padding: 8px;
    border: 1px solid #ccc;
    border-radius: 4px;
    font-family: Arial, sans-serif;
    font-size: 14px;
    box-sizing: border-box;
}

/* Render Preview */
.editor-preview {
    border: 2px solid #ccc;
    background: #f9f9f9;
    padding: 16px;
    height: 500px;
    overflow-y: auto;
    border-radius: 4px;
    box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
}

.col-5 {
    flex: 1;
    max-width: 41.6%;
}

.col-7 {
    flex: 1;
    max-width: 58.3%;
}

.row{
    display: flex;
}
                </style>
                <ul class="prs-tab">
                    <li to="tab1">Editor</li>
                    <li to="tab2">Resim yükle</li>
                </ul>
                <div class="prs-tabs" id="tab1">
                    <div class="editor-container">
                        <div class="editor-header">
                            <label for="_editor" class="editor-label">Hakkında İçeriği</label>
                        </div>
                        <form method="post" class="editor-form">
                            <div class="row">
                                <div class="col-5">
                                    <div class="editor-buttons">
                                        <button type="button" onclick="wrapText('b')">Kalın</button>
                                        <button type="button" onclick="wrapText('i')">İtalik</button>
                                        <button type="button" onclick="wrapText('strike')">Üstü Çizili</button>
                                        <button type="button" onclick="wrapText('u')">Altı Çizili</button>
                                        <button type="button" onclick="wrapText('h1')">Başlık 1</button>
                                        <button type="button" onclick="wrapText('h2')">Başlık 2</button>
                                        <button type="button" onclick="wrapText('ul')">Madde İşaretli Liste</button>
                                        <button type="button" onclick="wrapText('ol')">Numaralı Liste</button>
                                        <button type="button" onclick="wrapText('blockquote')">Alıntı</button>
                                        <button type="button" onclick="wrapText('code')">Kod</button>
                                        <button type="button" onclick="wrapText('a')">Bağlantı</button>
                                        <button type="button" id="uploadImageButton">Resim Yükle</button>
                                    </div>
                                    <textarea id="_editor" name="about_content" class="editor-textarea" onkeyup="turkticaret_renderPreview(this);"><?php echo $content; ?></textarea>
                                </div>
                                <div class="col-7">
                                    <div class="editor-preview" id="renderPreview">
                                        <?php echo $content; ?>
                                    </div>
                                </div>
                            </div>
                            <?php submit_button('Kaydet'); ?>
                        </form>
                    </div>
                </div>


                <div class="prs-tabs" id="tab2">
                    <?php
                    if (!current_user_can('upload_files')) {
                        wp_die(__('Sorry, you are not allowed to upload files.'));
                    }

                    wp_enqueue_script('plupload-handlers');

                    $post_id = 0;
                    if (isset($_REQUEST['post_id'])) {
                        $post_id = absint($_REQUEST['post_id']);
                        if (!get_post($post_id) || !current_user_can('edit_post', $post_id)) {
                            $post_id = 0;
                        }
                    }

                    if ($_POST) {
                        if (isset($_POST['html-upload']) && !empty($_FILES)) {
                            check_admin_referer('media-form');
                            // Upload File button was clicked.
                            $upload_id = media_handle_upload('async-upload', $post_id);
                            if (is_wp_error($upload_id)) {
                                wp_die($upload_id);
                            }
                        }
                        wp_redirect(admin_url('upload.php'));
                        exit;
                    }

                    $title = __('Upload New Media');
                    ?>
                    <div class="wrap">
                        <h1><?php echo esc_html($title); ?></h1>

                        <form enctype="multipart/form-data" method="post" action="<?php echo esc_url(admin_url('media-new.php')); ?>" class="<?php echo esc_attr($form_class); ?>" id="file-form">

                            <?php media_upload_form(); ?>

                            <script type="text/javascript">
                                var post_id = <?php echo absint($post_id); ?>, shortform = 3;
                            </script>
                            <input type="hidden" name="post_id" id="post_id" value="<?php echo absint($post_id); ?>" />
                            <?php wp_nonce_field('media-form'); ?>
                            <div id="media-items" class="hide-if-no-js"></div>
                        </form>
                    </div>
                </div>
            </div>

            <script>
                function turkticaret_renderPreview(_el) {
                    document.getElementById('renderPreview').innerHTML = _el.value;
                }

                var tabs;
                document.addEventListener("DOMContentLoaded", () => {
                    tabs = new ProdseenTab();
                });

                function wrapText(tag) {
                    var textarea = document.getElementById('_editor');
                    var start = textarea.selectionStart;
                    var end = textarea.selectionEnd;
                    var selectedText = textarea.value.substring(start, end);
                    var beforeText = textarea.value.substring(0, start);
                    var afterText = textarea.value.substring(end, textarea.value.length);

                    var openTag = '<' + tag + '>';
                    var closeTag = '</' + tag + '>';

                    // Handle special cases for link and code
                    if (tag === 'a') {
                        var url = prompt('Bağlantı URL\'sini girin:');
                        if (url) {
                            textarea.value = beforeText + '<a href="' + url + '">' + selectedText + '</a>' + afterText;
                        }
                    } else if (tag === 'code') {
                        textarea.value = beforeText + '<code>' + selectedText + '</code>' + afterText;
                    } else {
                        textarea.value = beforeText + openTag + selectedText + closeTag + afterText;
                    }

                    textarea.selectionStart = start;
                    textarea.selectionEnd = end + openTag.length + closeTag.length;
                    document.getElementById('renderPreview').innerHTML = document.getElementById('_editor').value;
                }
            </script>

            <?php
}

// Sporcu silme işlemini yönet
function turkticaret_delete_sport()
{
    if (!isset($_GET['sport_id']) || !current_user_can('manage_options')) {
        wp_die('Yetkisiz işlem');
    }

    global $wpdb;
    $table_name = $wpdb->prefix . 'tmpk_sportspage';
    $sport_id = intval($_GET['sport_id']);

    // Silme işlemini yap
    $wpdb->delete($table_name, array('id' => $sport_id));

    // Başarı mesajı
    wp_redirect(admin_url('admin.php?page=tmpk_sportspage'));
    exit;
}
add_action('admin_post_delete_sport', 'turkticaret_delete_sport');

// Sporcu düzenleme işlemini yönet
function turkticaret_edit_sport()
{
    global $wpdb;

    // Check for nonce and validate the request
    if (!isset($_POST['_wpnonce']) || !wp_verify_nonce($_POST['_wpnonce'], 'edit_sport')) {
        wp_die('Güvenlik kontrolü başarısız!');
    }

    // Validate and sanitize input data
    $sport_id = isset($_POST['sport_id']) ? intval($_POST['sport_id']) : 0;
    $name = sanitize_text_field($_POST['sport_name']);
    $gender = intval($_POST['sport_gender']);
    $baglanti = sanitize_text_field($_POST['sport_baglanti']);
    $sira = sanitize_text_field($_POST['sport_sira']);

    // Initialize image path
    $image_path = '';

    // Handle image upload if a new image is provided
    if (!empty($_FILES['sport_image']['name'])) {
        $image = $_FILES['sport_image'];

        // Define the target directory for uploads
        $upload_dir = wp_upload_dir();
        $target_dir = plugin_dir_path(__FILE__) . 'assets/uploads/';

        // Create the directory if it doesn't exist
        if (!file_exists($target_dir)) {
            mkdir($target_dir, 0755, true);
        }

        // Move the uploaded file to the target directory
        $target_file = $target_dir . basename($image['name']);
        move_uploaded_file($image['tmp_name'], $target_file);

        // Adjust the file path to be relative to the wp-content directory
        $split_path = explode('/wp-content', $target_file, 2);
        if (isset($split_path[1])) {
            $image_path = 'wp-content' . $split_path[1];
        }
    } else {
        // If no new image is uploaded, retain the current image path
        $table_name = $wpdb->prefix . 'tmpk_sportspage';
        $current_image = $wpdb->get_var($wpdb->prepare("SELECT image FROM $table_name WHERE id = %d", $sport_id));
        $image_path = $current_image;
    }

    // Update the database record
    $table_name = $wpdb->prefix . 'tmpk_sportspage';
    $wpdb->update(
        $table_name,
        array(
            'name' => $name,
            'image' => $image_path,
            'gender' => $gender,
            'baglanti' => $baglanti,
            'sira' => $sira
        ),
        array('id' => $sport_id)
    );

    // Redirect back to the sports list page
    wp_redirect(admin_url('admin.php?page=tmpk_sportspage'));
    exit;
}

add_action('admin_post_edit_sport', 'turkticaret_edit_sport');

function show_edit_sport_form()
{
    global $wpdb;

    $sport_id = isset($_GET['sport_id']) ? intval($_GET['sport_id']) : 0;
    $table_name = $wpdb->prefix . 'tmpk_sportspage';
    $sport = $wpdb->get_row($wpdb->prepare("SELECT * FROM $table_name WHERE id = %d", $sport_id));

    if ($sport) {
        ?>
                <h2>Sporcuyu Düzenle</h2>
                <form method="post" action="<?php echo admin_url('admin-post.php?action=edit_sport'); ?>" enctype="multipart/form-data">
                    <input type="hidden" name="sport_id" value="<?php echo esc_attr($sport->id); ?>">
                    <?php wp_nonce_field('edit_sport'); ?>
                    <table class="form-table">
                        <tr>
                            <th scope="row">Mevcut Sporcu Resmi</th>
                            <td>
                                <?php if ($sport->image): ?>
                                    <img src="<?php echo esc_url(home_url($sport->image)); ?>" width="100">
                                <?php else: ?>
                                    <p>Resim yüklenmemiş.</p>
                                <?php endif; ?>
                            </td>
                        </tr>
                        <tr>
                            <th scope="row">Yeni Sporcu Resmi</th>
                            <td><input type="file" name="sport_image" accept="image/*"></td>
                        </tr>
                        <tr>
                            <th scope="row"><label for="sport_name">Adı Soyadı</label></th>
                            <td><input type="text" name="sport_name" value="<?php echo esc_attr($sport->name); ?>" class="regular-text"></td>
                        </tr>
                        <tr>
                            <th scope="row"><label for="sport_baglanti">Bağlantı</label></th>
                            <td><input type="text" name="sport_baglanti" value="<?php echo esc_attr($sport->baglanti); ?>" class="regular-text"></td>
                        </tr>
                        <tr>
                            <th scope="row"><label for="sport_gender">Cinsiyet</label></th>
                            <td>
                                <select name="sport_gender">
                                    <option value="0" <?php selected($sport->gender, 0); ?>>Kadın</option>
                                    <option value="1" <?php selected($sport->gender, 1); ?>>Erkek</option>
                                </select>
                            </td>
                        </tr>
                        <tr>
                            <th scope="row"><label for="sport_sira">Sıra</label></th>
                            <td><input type="text" name="sport_sira" value="<?php echo esc_attr($sport->sira); ?>" class="regular-text"></td>
                        </tr>
                    </table>
                    <p class="submit">
                        <input type="submit" class="button-primary" value="Kaydet">
                    </p>
                </form>
                <?php
    } else {
        echo '<p>Sporcu bulunamadı.</p>';
    }
}
add_action('admin_menu', function () {
    add_submenu_page(null, 'Sporcuyu Düzenle', 'Sporcuyu Düzenle', 'manage_options', 'edit_sport', 'show_edit_sport_form');
});


// Tesis silme işlemini yönet
function turkticaret_delete_facility()
{
    if (!isset($_GET['facility_id']) || !current_user_can('manage_options')) {
        wp_die('Yetkisiz işlem');
    }

    global $wpdb;
    $table_name = $wpdb->prefix . 'tmpk_tesisler';
    $facility_id = intval($_GET['facility_id']);

    // Silme işlemini yap
    $wpdb->delete($table_name, array('id' => $facility_id));

    // Başarı mesajı
    wp_redirect(admin_url('admin.php?page=tmpk_tesisler'));
    exit;
}
add_action('admin_post_delete_sport', 'turkticaret_delete_sport');

// Tesis düzenleme işlemini yönet
function turkticaret_edit_facility()
{
    global $wpdb;

    // Check for nonce and validate the request
    if (!isset($_POST['_wpnonce']) || !wp_verify_nonce($_POST['_wpnonce'], 'edit_facility')) {
        wp_die('Güvenlik kontrolü başarısız!');
    }

    // Validate and sanitize input data
    $facility_id = isset($_POST['facility_id']) ? intval($_POST['facility_id']) : 0;
    $image = sanitize_text_field($_POST['facility_image']);
    $name = sanitize_text_field($_POST['facility_name']);
    $baglanti = sanitize_text_field($_POST['facility_baglanti']);
    $sira = sanitize_text_field($_POST['facility_sira']);

    // Initialize image path
    // $image_path = '';

    // // Handle image upload if a new image is provided
    // if (!empty($_FILES['facility_image']['name'])) {
    //     $image = $_FILES['facility_image'];

    //     // Define the target directory for uploads
    //     $upload_dir = wp_upload_dir();
    //     $target_dir = plugin_dir_path(__FILE__) . 'assets/uploads/';

    //     // Create the directory if it doesn't exist
    //     if (!file_exists($target_dir)) {
    //         mkdir($target_dir, 0755, true);
    //     }

    //     // Move the uploaded file to the target directory
    //     $target_file = $target_dir . basename($image['name']);
    //     move_uploaded_file($image['tmp_name'], $target_file);

    //     // Adjust the file path to be relative to the wp-content directory
    //     $split_path = explode('/wp-content', $target_file, 2);
    //     if (isset($split_path[1])) {
    //         $image_path = 'wp-content' . $split_path[1];
    //     }
    // } else {
    //     // If no new image is uploaded, retain the current image path
    //     $table_name = $wpdb->prefix . 'tmpk_facilityspage';
    //     $current_image = $wpdb->get_var($wpdb->prepare("SELECT image FROM $table_name WHERE id = %d", $facility_id));
    //     $image_path = $current_image;
    // }

    // Update the database record
    $table_name = $wpdb->prefix . 'tmpk_tesisler';
    $wpdb->update(
        $table_name,
        array(
            'name' => $name,
            // 'image' => $image_path,
            'image' => $image,
            'baglanti' => $baglanti,
            'sira' => $sira
        ),
        array('id' => $facility_id)
    );

    // Redirect back to the facilitys list page
    wp_redirect(admin_url('admin.php?page=tmpk_tesislerpage'));
    exit;
}
add_action('admin_post_edit_facility', 'turkticaret_edit_facility');

function show_edit_facility_form()
{
    global $wpdb;

    $facility_id = isset($_GET['facility_id']) ? intval($_GET['facility_id']) : 0;
    $table_name = $wpdb->prefix . 'tmpk_tesisler';
    $facility = $wpdb->get_row($wpdb->prepare("SELECT * FROM $table_name WHERE id = %d", $facility_id));

    if ($facility) {
        ?>
                <h2>Tesisi Düzenle</h2>
                <form method="post" action="<?php echo admin_url('admin-post.php?action=edit_facility'); ?>" enctype="multipart/form-data">
                    <input type="hidden" name="facility_id" value="<?php echo esc_attr($facility->id); ?>">
                    <?php wp_nonce_field('edit_facility'); ?>
                    <table class="form-table">
                        <tr>
                            <th scope="row">Mevcut Tesis Resmi</th>
                            <td>
                                <?php if ($facility->image): ?>
                                    <img src="<?php echo esc_url($facility->image); ?>" width="100">
                                <?php else: ?>
                                    <p>Resim yüklenmemiş.</p>
                                <?php endif; ?>
                            </td>
                        </tr>
                        <tr>
                            <th scope="row">Yeni Tesis Resmi</th>
                            <!-- <td><input type="file" name="facility_image" accept="image/*"></td> -->
                            <td><input type="text" name="facility_image" class="regular-text"></td>
                        </tr>
                        <tr>
                            <th scope="row"><label for="facility_name">Tesis Adı</label></th>
                            <td><input type="text" name="facility_name" value="<?php echo esc_attr($facility->name); ?>" class="regular-text"></td>
                        </tr>
                        <tr>
                            <th scope="row"><label for="facility_baglanti">Bağlantı</label></th>
                            <td><input type="text" name="facility_baglanti" value="<?php echo esc_attr($facility->baglanti); ?>" class="regular-text"></td>
                        </tr>
                        <tr>
                            <th scope="row"><label for="facility_sira">Sıra</label></th>
                            <td><input type="text" name="facility_sira" value="<?php echo esc_attr($facility->sira); ?>" class="regular-text"></td>
                        </tr>
                    </table>
                    <p class="submit">
                        <input type="submit" class="button-primary" value="Kaydet">
                    </p>
                </form>
                <?php
    } else {
        echo '<p>Tesis bulunamadı.</p>';
    }
}
add_action('admin_menu', function () {
    add_submenu_page(null, 'Tesisi Düzenle', 'Tesisi Düzenle', 'manage_options', 'edit_facility', 'show_edit_facility_form');
});

// Plugin etkinleştirildiğinde burası çalışacaktır
function turkticaret_paris_plugin_activate()
{
    global $wpdb;
    require_once(ABSPATH . 'wp-admin/includes/upgrade.php');

    // Sporcuları sekmesi
    $table_name = $wpdb->prefix . 'tmpk_sportspage';
    $charset_collate = $wpdb->get_charset_collate();
    $sql = "CREATE TABLE $table_name (
        id mediumint(9) NOT NULL AUTO_INCREMENT,
        name varchar(255) NOT NULL,
        image varchar(255) NOT NULL,
        baglanti varchar(255),
        sira int,
        gender int NOT NULL,
        PRIMARY KEY  (id)
    ) $charset_collate;";
    dbDelta($sql);

    // Hakkında sekmesi
    $table_name = $wpdb->prefix . 'tmpk_aboutpage';
    $sql = "CREATE TABLE $table_name (
        id mediumint(9) NOT NULL AUTO_INCREMENT,
        content TEXT NOT NULL,
        PRIMARY KEY  (id)
    ) $charset_collate;";
    dbDelta($sql);

    // Tesisler sekmesi
    $table_name = $wpdb->prefix . 'tmpk_tesisler';
    $sql = "CREATE TABLE $table_name (
        id mediumint(9) NOT NULL AUTO_INCREMENT,
        name varchar(255) NOT NULL,
        image varchar(255) NOT NULL,
        glink varchar(255) NOT NULL,
        PRIMARY KEY  (id)
    ) $charset_collate;";
    dbDelta($sql);
}
register_activation_hook(__FILE__, 'turkticaret_paris_plugin_activate');

// Plugin devredışı bırakılınca yapılan işlemler
function turkticaret_paris_plugin_deactivate()
{
    global $wpdb;

    // Sporcuları tablosunu sil
    // $table_name = $wpdb->prefix . 'tmpk_sportspage';
    // $sql = "DROP TABLE IF EXISTS $table_name;";
    // $wpdb->query($sql);

    // Hakkında tablosunu sil
    // $table_name = $wpdb->prefix . 'tmpk_aboutpage';
    /// $sql = "DROP TABLE IF EXISTS $table_name;";
    // $wpdb->query($sql);

    // Tesisler tablosunu sil
    // $table_name = $wpdb->prefix . 'tmpk_tesisler';
    // $sql = "DROP TABLE IF EXISTS $table_name;";
    // $wpdb->query($sql);

    flush_rewrite_rules();
}
register_deactivation_hook(__FILE__, 'turkticaret_paris_plugin_deactivate');
?>