<?php if ( ! defined( 'ABSPATH' ) ) exit; // Exit if accessed directly ?>
<?php

// ====================================================
// Include the file that contains all the info
// ====================================================
include('settings.php');

// getting the page url for the settings page
$plugin_page_url = esc_url( menu_page_url( 'yydev-redirection', false ) );

// ====================================================
// Redirect the user the to main page
// if the data was not found
// ====================================================

    $secondary_page_id = intval(yydev_redirect_mysql_prep($_GET['id']));

    if( isset($secondary_page_id) && !empty($secondary_page_id) && is_numeric($secondary_page_id) ) {
        
        global $wpdb;
        $check_for_real_data_id = $wpdb->query("SELECT id FROM " . $yydev_redirect_table_name . " WHERE id = " . $secondary_page_id);
        
        if($check_for_real_data_id == 0) {

            $error_message = "The redirect id you were looking for was not found";
            $new_page_link = $plugin_page_url . "&error-message=" . urlencode($error_message);
            yydev_redirect_redirections_page($new_page_link);

        } // if($check_for_real_data_id < 1 ) {
    
    } else { // if( isset($secondary_page_id) && !empty($secondary_page_id) && is_numeric($secondary_page_id) ) {

        $error_message = "The redirect id you were looking for was not found";
        $new_page_link = $plugin_page_url . "&error-message=" . urlencode($error_message);
        yydev_redirect_redirections_page($new_page_link);

    } // } else { // if( isset($secondary_page_id) && !empty($secondary_page_id) && is_numeric($secondary_page_id) ) {


// ====================================================
// Removing the main Data if it was deleted
// ====================================================

if(isset($_GET['remove-form']) && isset($secondary_page_id) && !empty($secondary_page_id) ) {

    $check_content_id = $wpdb->query("SELECT * FROM " . $yydev_redirect_table_name . " WHERE id = " . $secondary_page_id);

    if($check_content_id > 0) {
        // if the data id exists on the database it will be removed
        
        $wpdb->delete( $yydev_redirect_table_name, array('id'=>$secondary_page_id) ); // removing main database info
        $wpdb->delete( $yydev_secondary_table_name, array('secondary_id'=>$secondary_page_id) ); // removing all sub database info

        $message = "The redirect id #" . $secondary_page_id . " was removed successfully";
        $new_page_link = $plugin_page_url . "&message=" . urlencode($message);
        yydev_redirect_redirections_page($new_page_link);
        
    } else { // if($check_content_id > 0) {
        
        $error_message = "The redirect id wasn't not found";
        $new_page_link = $plugin_page_url . "&error-message=" . urlencode($error_message);
        yydev_redirect_redirections_page($new_page_link);
        
    } // } else { // if($check_content_id > 0) {
    
} // if(isset($_GET['remove-form']) && isset($secondary_page_id) && !empty($secondary_page_id) ) {

// ====================================================
// Removing secondary form data if it was deleted
// ====================================================
    
    if( isset($_GET['remove-secondary-form']) && isset($_GET['secondary_id']) ) {
        
        $secondary_redirect_id = intval(yydev_redirect_mysql_prep($_GET['secondary_id']));

        $check_secondary_data_id = $wpdb->query("SELECT id FROM " . $yydev_secondary_table_name . " WHERE id = " . $secondary_redirect_id );
        
        if($check_secondary_data_id > 0) {
            // if the secondary data id exists on the database it will be removed
            
            $wpdb->delete( $yydev_secondary_table_name, array('id'=>$secondary_redirect_id) );

            $message = "The redirect was removed successfully";
            $new_page_link = $plugin_page_url . "&view=secondary&id=" . $secondary_page_id . "&message=" . urlencode($message);
            yydev_redirect_redirections_page($new_page_link);

        } else { // if($check_secondary_data_id > 0) {

            $error_message = "The redirect id was not found and not deleted";
            $new_page_link = $plugin_page_url . "&view=secondary&id=" . $secondary_page_id . "&error-message=" . urlencode($error_message);
            yydev_redirect_redirections_page($new_page_link);

        } // } else { // if($check_secondary_data_id > 0) {
        
    }  // if( isset($_GET['remove-secondary-form']) && isset($secondary_redirect_id) ) {

// ====================================================
// Add new secondary deta to the database
// ====================================================

if( isset($_POST['submit-new-secondary-deta']) && isset($secondary_page_id) && !empty($secondary_page_id)  ) {


    // Getting new position number
    $new_position = 1;
    $checking_first_position = $wpdb->get_results("SELECT * FROM " . $yydev_secondary_table_name . " WHERE secondary_id = " . $secondary_page_id . " ORDER BY position ASC limit 1");
    foreach($checking_first_position as $wordpress_position) {
        $new_position = $wordpress_position->position / 2;
    } // foreach($checking_first_position as $wordpress_position) {

    // incase there are a lot of data and the new position is 0
    // we will reorder all the options
    if( $new_position == 0 ) {

        $checking_redirect_positions = $wpdb->get_results("SELECT * FROM " . $yydev_secondary_table_name . " WHERE secondary_id = " . $secondary_page_id . " ORDER BY position ASC");
        $redirect_postion = 1;

        foreach($checking_redirect_positions as $wordpress_positions) {
            $this_redirect_id = $wordpress_positions->id;
            $wpdb->update( $yydev_secondary_table_name,array('position'=>$redirect_postion), array('id'=>$this_redirect_id), array('%f') );
            $redirect_postion++;
        } // foreach($checking_first_position as $wordpress_position) {

        $new_position = 0.5;

    } // if( $new_position == 0 ) {
        

    // If there is no error insert the info to the database
    $main_deta_id = intval( yydev_redirect_mysql_prep($secondary_page_id) );
    $request_url = yydev_redirect_mysql_prep( strtolower(esc_url_raw($_POST['request_url'])) );
    $destination_url = yydev_redirect_mysql_prep( esc_url_raw($_POST['destination_url']) );
    $redirect_type = yydev_redirect_mysql_prep( intval($_POST['redirect_type']) );
    $advertising_platform = yydev_redirect_mysql_prep( sanitize_text_field($_POST['advertising_platform']) );
    $new_data_position = yydev_redirect_mysql_prep( floatval($new_position) );

    // Checking if the data id exists
    $check_database_exists = $wpdb->query("SELECT id FROM " . $yydev_redirect_table_name . " where id = " . $main_deta_id);
            
    if($check_database_exists == 0 ) {
        $post_error_message = "The redirect id was not found";
    } // if($check_database_exists == 0 ) {
    
    if(empty($request_url) || empty($destination_url) ) {
        $post_error_message = "You mush fill both the Request URL and the Destination URL.";
    } // if(empty($request_url) || empty($destination_url) ) {

    // making sure the request url doesn't exists so it won't redirect the page twice
    $checking_if_request_already_exists = $wpdb->query("SELECT * FROM " . $yydev_secondary_table_name . " where request_url = '{$request_url}'");

    if($checking_if_request_already_exists > 0 ) {
        $post_error_message = "The request url is already exists please edit it instead of creating new one.";
    } // if($checking_if_request_already_exists == 0 ) {

    if( !isset($post_error_message) ) {

        // If the secondary data id exists it will add the new data
        $wpdb->insert( $yydev_secondary_table_name,
            array('secondary_id'=>$main_deta_id,
            'request_url'=>$request_url,
            'destination_url'=>$destination_url,
            'redirect_type'=>$redirect_type,
            'advertising_platform'=>$advertising_platform,
            'position'=>$new_data_position,
            ), array('%d', '%s', '%s', '%s', '%s', '%f') );
        
            // Creating page link and redirect the user the current page with the new data
            $new_detabase_id = $wpdb->insert_id;
            $message = "The new redirect was inserted successfully";

            $new_page_link = $plugin_page_url . "&view=secondary&id=" . $main_deta_id . "&message=" . urlencode($message);
            yydev_redirect_redirections_page($new_page_link);

    } // if( !isset($post_error_message) ) {
        

} // if( isset($_POST['submit-new-secondary-deta']) && isset($secondary_page_id) && !empty($secondary_page_id)  ) {

// ====================================================
// Update the secondary data if they are changed
// ====================================================

if( isset($_POST['update-secondary-deta']) ) {

    foreach( $_POST['form_id'] as $this_secondary_data_id) {

        // If there is no error insert the info to the database
        $main_deta_id = yydev_redirect_mysql_prep( intval($_POST['form_id'][$this_secondary_data_id]) );
        $request_url = yydev_redirect_mysql_prep( esc_url_raw(strtolower($_POST['request_url'][$this_secondary_data_id])) );
        $destination_url = yydev_redirect_mysql_prep( esc_url_raw($_POST['destination_url'][$this_secondary_data_id]) );
        $redirect_type = yydev_redirect_mysql_prep( intval($_POST['redirect_type'][$this_secondary_data_id]) );
        $redirects_amount = yydev_redirect_mysql_prep( intval($_POST['redirects_amount'][$this_secondary_data_id]) );
        $advertising_platform = yydev_redirect_mysql_prep( sanitize_text_field($_POST['advertising_platform'][$this_secondary_data_id]) );
        $position = yydev_redirect_mysql_prep( floatval($_POST['position'][$this_secondary_data_id]) );

        // Checking data id exists
        $check_database_exists = $wpdb->query("SELECT id FROM " . $yydev_secondary_table_name . " where id = " . $main_deta_id);

        if($check_database_exists == 0 ) {
            $post_error_message = "The redirect id was not found";
        } else { // if($check_database_exists < 1 ) {
        
            // If the database id exists it will add the new secondary data
            $wpdb->update( $yydev_secondary_table_name,
            array('request_url'=>$request_url,
            'destination_url'=>$destination_url,
            'redirect_type'=>$redirect_type,
            'advertising_platform'=>$advertising_platform,
            'position'=>$position,
            'redirects_amount'=>$redirects_amount,
            ), array('id'=>$main_deta_id), array('%s', '%s', '%s', '%s', '%f', '%d') );
        
            $success_message = "The redirect settings were updated successfully";

        } // } else { // if($check_database_exists < 1 ) {

    } // foreach( $_POST['form_id'] as $this_secondary_data_id) {
    
} // if( isset($_POST['update-secondary-deta']) ) {

// ====================================================
// Update the main database if it's changed
// ====================================================
    
if( isset($_POST['edit-main-database']) && isset($_POST['form_id']) && !empty($_POST['form_id']) ) {

        // If there is no error insert the info to the database
        $redirections_name = yydev_redirect_mysql_prep($_POST['redirections_name']);

        $redirections_slug = str_replace(" ", "_", strtolower(trim($redirections_name)));
        $redirections_slug = yydev_redirect_mysql_prep($redirections_slug);

        $main_deta_id = yydev_redirect_mysql_prep($_POST['form_id']);

        // Checking if the main database id exists
        $check_database_exists = $wpdb->query("SELECT id FROM " . $yydev_redirect_table_name . " where id = " . $main_deta_id);

        if($check_database_exists == 0 ) {
            $post_error_message = "The redirect id was not found";
        } else { // if($check_database_exists < 1 ) {
        
        // If the main database id exists it will update it
        $wpdb->update( $yydev_redirect_table_name,
            array('name'=>$redirections_name,
            'slug'=>$redirections_slug,
            ), array('id'=>$main_deta_id), array('%s', '%s') );

            // Creating page link and redirect the user the current page with the new data
            $new_detabase_id = $wpdb->insert_id;
            $message = "The redirect was updated successfully";

            $new_page_link = $plugin_page_url . "&view=secondary&id=" . $main_deta_id . "&message=" . urlencode($message);
            yydev_redirect_redirections_page($new_page_link);

        } // } else { // if($check_database_exists < 1 ) {
        
} // if( isset($_POST['edit-main-database']) && isset($_POST['form_id']) && !empty($_POST['form_id']) ) {
     
?>


<div class="wrap yydevelopment-redirecting <?php if(is_rtl()) {echo "yydevelopment-redirecting-rtl";} ?>">
    <h2 class="isplay-inline">Edit 301/302 Redirects <a class="go-back-button" href="<?php echo $plugin_page_url; ?>">Go Back</a></h2>
    

    <?php yydev_redirect_echo_message_if_exists(); ?>
    <?php yydev_redirect_echo_success_message_if_exists($success_message); ?>
    <?php yydev_redirect_echo_error_message_if_exists($post_error_message); ?>
    
    <div class="insert-new">
        
<?php

    $check_secondary_deta_id = $wpdb->get_row("SELECT * FROM " . $yydev_redirect_table_name . " WHERE id = " . $secondary_page_id );

?>
                
        <h4>Edit Redirect Settings</h4>
                
        <form class="edit-main-database" method="POST" action="">
           
            <span>Redirect ID: <?php echo $check_secondary_deta_id->id; ?></span>
            <br />
           
            <label for="redirections_name">Redirection Name:</label>
            <input type="text" id="redirections_name" class="redirections_name input-long" name="redirections_name" value="<?php echo yydev_redirect_html_value($check_secondary_deta_id->name); ?>" />

            <input type="hidden" name="form_id" class="form_id" value="<?php echo yydev_redirect_html_value($secondary_page_id); ?>" />
            
            <br /><br />

            <input type="submit" class="edit-main-database img_url_button" name="edit-main-database" value="Edit Redirect Settings" />
        </form>
    

    <form class="insert-form" method="POST" action="">
        
        <br /><br />
        <h2>Add Redirect</h2> 

                <div class="add_new_url_block">
                    <label for="request_url">Request URL: </label>
                    <input type="text" id="request_url" class="input-very-long" name="request_url" value="" /> 
                    <small>Example: /go/text/themes/</small>
                </div><!--add_new_url_block-->

                <div class="add_new_url_block">
                    <label for="destination_url">Destination URL: </label>
                    <input type="text" id="destination_url" class="input-very-long" name="destination_url" value="" /> 
                    <small>Example: /go/text/themes/, Example2: http://www.website.com,</small>
                </div><!--add_new_url_block-->

                <div class="add_new_url_block">
                    <label for="redirect_type">Redirection Type: </label>
                    <select name="redirect_type" id="redirect_type">
                    <option value="301">301 Permanent Redirect</option>
                    <option value="302">302 Temporary Redirect</option>
                    </select>
                </div><!--add_new_url_block-->

                <div class="advertising_platform">
                    <label for="advertising_platform">Advertising Platform: </label>
                    <input type="text" id="advertising_platform" class="input-very-long" name="advertising_platform" value="" /> 
                    <small>Examples: CJ, Impact, ClickBank, Amazon</small>
                </div><!--add_new_url_block-->

                <br />
                <input type="submit" name="submit-new-secondary-deta" class="button-cursor" value="Submit Redirect" />

    </form>

    
    <br /><br /><br />
    <h2>Edit Redirects</h2>     
    

    <div class="main-page-table">
    <form method="POST" action="">

        <table class="wp-list-table widefat fixed striped posts boxes-table redirect-table-th">
        <thead>
            <tr>
                <th style="width:80px;">ID</th>
                <th style="width:300px;">Request URL</th>
                <th style="width:300px;">Destination URL</th>
                <th style="width:150px;">Redirect Type</th>
                <th style="width:80px;">Redirects Amount</th>
                <th style="width:120px;">Advertising Platform</th>
                <th style="width:50px;">Position</th>
                <th style="width:50px;">Remove</th>
            </tr>
        </thead>
        
        <tbody id="the-list">
        
    <?php
        
    // ================================================
    // Echoing all the secondary data from the database 
    // ================================================
        
        $main_secondary_data_info = $wpdb->get_results("SELECT * FROM " . $yydev_secondary_table_name . " WHERE secondary_id = " . $secondary_page_id . " ORDER BY position ASC");
        
        // Echo there is no data found 
        if(empty($main_secondary_data_info)) {
    ?>
        <tr class="no-items"><td class="colspanchange" colspan="8">No. redirects found</td></tr>
    <?php     
        } // if(empty($main_secondary_data_info)) {
        
        
        $position_number = 1;
        foreach($main_secondary_data_info as $secondary_data_info) {

        $secondery_data_info_id = $secondary_data_info->id;;

    ?>
                
            <tr>
                
                <td><?php echo $position_number; ?></td>

                <td><input type="text" id="request_url" class="input-long direction: ltr;" name="request_url[<?php echo $secondery_data_info_id; ?>]" value="<?php echo yydev_redirect_html_value($secondary_data_info->request_url); ?>" /></td>

                <td><input type="text" id="destination_url" class="input-long direction: ltr;" name="destination_url[<?php echo $secondery_data_info_id; ?>]" value="<?php echo yydev_redirect_html_value($secondary_data_info->destination_url); ?>" /></td>

                <td>
                    <select name="redirect_type[<?php echo $secondery_data_info_id; ?>]">
                    <option value="301" <?php if( $secondary_data_info->redirect_type == "301") {echo "selected";} ?> >301 Permanent Redirect</option>
                        <option value="302" <?php if ($secondary_data_info->redirect_type == "302") {echo "selected";} ?> >302 Temporary Redirect</option>
                    </select>
                </td>

                <td><input type="text" id="redirects_amount" class="text_color shorter_input" name="redirects_amount[<?php echo $secondery_data_info_id; ?>]" value="<?php echo yydev_redirect_html_value($secondary_data_info->redirects_amount); ?>" /></td>

                <td><input type="text" id="advertising_platform" name="advertising_platform[<?php echo $secondery_data_info_id; ?>]" value="<?php echo $secondary_data_info->advertising_platform; ?>" /></td>

                <td><input type="text" id="position_<?php echo $secondery_data_info_id->id; ?>" class="text_color shorter_input" name="position[<?php echo $secondery_data_info_id; ?>]" value="<?php echo yydev_redirect_html_value($position_number); ?>" /></td>

                <td style="vertical-align:middle;">
                    <a class="remove-secondary-form-image" href="<?php echo $plugin_page_url . "&view=secondary&remove-secondary-form=1&id=" . $secondary_page_id . "&secondary_id=" . $secondary_data_info->id; ; ?>">
                        <img  src="<?php echo plugins_url( 'images/delete.png', dirname(__FILE__) ); ?>" alt="" />
                    
                    </a>
                </td>

                <input type="hidden" name="form_id[<?php echo $secondery_data_info_id; ?>]" value="<?php echo yydev_redirect_html_value($secondary_data_info->id); ?>" />

            </tr>
                

    <?php
        $position_number++;
        } // foreach($main_secondary_data_info as $secondary_data_info) {
        
    ?>

        </tbody>
        
        <tfoot>
            <tr>
                <th style="width:80px;">ID</th>
                <th style="width:300px;">Request URL</th>
                <th style="width:300px;">Destination URL</th>
                <th style="width:150px;">Redirect Type</th>
                <th style="width:80px;">Redirects Amount</th>
                <th style="width:120px;">Advertising Platform</th>
                <th style="width:50px;">Position</th>
                <th style="width:50px;">Remove</th>
            </tr>
        </tfoot>
        
        </table>
        </div><!--main-page-table-->


    <input type="submit" class="update-button" name="update-secondary-deta" value="Update Redirects">

</form>

</div><!--wrap-->