<?php
ob_clean();
/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
add_action('admin_menu', 'register_my_admin_payonline_menu');

function register_my_admin_payonline_menu() {
    add_menu_page('payonline menu', 'Payonline List', 'manage_options', 'payonline_list', 'payonline_list', 'dashicons-list-view');
    add_submenu_page('list_email_template', __('View Payment Detail', 'apbookgc'), __('View Payment Detail', 'apbookgc'), 'manage_options', 'view_payonline_detail', 'view_payonline_detail');
}

function view_payonline_detail() {

    if (isset($_REQUEST['action']) && $_REQUEST['action'] == "view" && !empty($_REQUEST['payment_id']) && is_numeric($_REQUEST['payment_id'])):
        global $wpdb;

        $table_name = $wpdb->prefix . "payment_response";
        $all_payment_list_data = $wpdb->get_results("SELECT * FROM  " . $table_name . " WHERE `id`=" . $_REQUEST['payment_id'], ARRAY_A);
        $all_data = $all_payment_list_data[0];
        ?>
        <div class="wrap">
            <h2>Payment  Details <a class="add-new-h2" href="<?php echo admin_url("admin.php?page=payonline_list") ?>"> Back to List</a></h2>
            <table class="wp-list-table widefat fixed striped pages" >
                <?php foreach ($all_data as $key => $value) { ?>
                    <tr>
                        <th><?php echo ucfirst(str_replace("_", " ", $key)); ?></th>
                        <?php
                        if ($key == "response"): $get_all_res_data = unserialize($value);
                            $get_all_res_data = array_filter($get_all_res_data);
                            ?>
                            <td>
                                <table>
                                    <?php foreach ($get_all_res_data as $res_key => $res_value): ?>
                                        <tr>
                                            <th><?php echo ucfirst($res_key); ?></th>
                                            <td><?php echo $res_value; ?></td>
                                        </tr>
                                    <?php endforeach; ?>
                                </table>
                            </td>
                        <?php else: ?>
                            <td><?php echo $value; ?></td>
                        <?php endif; ?>
                    </tr>
                <?php } ?>

            </table>
        </div>
        <?php
    endif;
}

//Search
if (isset($_GET['submitted']) && $_GET['submitted'] == true &&
        isset($_GET['post_nonce_field']) &&
        wp_verify_nonce($_GET['post_nonce_field'], 'post_nonce') &&
        $_GET['category_search_submit'] == "Search Name") {
    global $wpdb;
    $get_search_package = trim(esc_attr($_GET['s']));
    $table_name = $wpdb->prefix . "payment_response";
    if (isset($_GET["paged"])) {
        $page = $_GET["paged"];
    } else {
        $page = 1;
    };
    wp_redirect(admin_url("admin.php?page=payonline_list") . '&s=' . $_GET['s'] . '&paged=' . $page);
    exit();
    ///print_R($_GET);
}

function payonline_list() {
    /**
     *
     */
    global $wpdb;
    if (isset($_GET["paged"]) && $_GET['page'] == "payonline_list") {
        $page = $_GET["paged"];
    } else {
        $page = 1;
    };
    $num_rec_per_page = 10;                                                                           //Pagination LImit
    $start_from = ($page - 1) * $num_rec_per_page;

    //Delete
    if (isset($_GET['action']) && !empty($_GET['action']) && (($_GET['action'] == 'delete_payment') || ($_GET['action'] == 'Bulk Delete'))) {

        $table_name = $wpdb->prefix . "payment_response";
        $ids = isset($_REQUEST['payment_id']) ? $_REQUEST['payment_id'] : array();
        if (is_array($ids))
            $ids = implode(',', $ids);

        if (!empty($ids)) {
            $wpdb->query("DELETE FROM $table_name WHERE id IN($ids)");
            $wpdb->query("DELETE FROM wp_vyo_address WHERE member_id IN($ids)");
        }
    }





    /** search * */
    if (isset($_GET['s']) && !empty($_GET['s']) && $_GET['page'] == "payonline_list") {

        $search_text = trim(esc_attr($_GET['s']));
        $table_name = $wpdb->prefix . "payment_response";
        $all_payment_list = $wpdb->get_results("SELECT * FROM  " . $table_name . " WHERE `customer_name` LIKE '%" . $search_text . "%' LIMIT " . $start_from . "," . $num_rec_per_page, ARRAY_A);
    } else {
        $table_name = $wpdb->prefix . "payment_response";
        $all_payment_list = $wpdb->get_results('SELECT * FROM  ' . $table_name . " LIMIT " . $start_from . "," . $num_rec_per_page, ARRAY_A);
    }
    if (isset($_GET['action']) && !empty($_GET['action']) && (($_GET['filter_by'] == 'status_pending'))) {
        $table_name = $wpdb->prefix . "payment_response";
        $all_payment_list = $wpdb->get_results("SELECT * FROM  " . $table_name . " WHERE `payment_status` =  'pending'  LIMIT " . $start_from . "," . $num_rec_per_page, ARRAY_A);
    }
    if (isset($_GET['action']) && !empty($_GET['action']) && (($_GET['filter_by'] == 'status_completed'))) {
        $table_name = $wpdb->prefix . "payment_response";
        $all_payment_list = $wpdb->get_results("SELECT * FROM  " . $table_name . " WHERE `payment_status` =  'completed'  LIMIT " . $start_from . "," . $num_rec_per_page, ARRAY_A);
    }
    ?>
    <style>
        .widefat th.sortable, .widefat th.sorted {
            padding: 10px;
        }
    </style>
    <div class="wrap">
        <h2>Pay - Online Payment List</h2>
        <!-- form started -->
        <form id="package-filter" name="package-filter" method="get" action="<?php echo admin_url("admin.php?page=payonline_list"); ?>" >
            <!---- search box --->

            <div class="tablenav top">
                <div class="alignleft actions bulkactions">
                    <label class="screen-reader-text" for="bulk-action-selector-top">Select bulk action</label>
                    <select coupon_id="bulk-action-selector-top" name="action">
                        <option selected="selected" value="-1">Bulk Actions</option>
                        <option value="delete_payment">Delete</option>
                    </select>
                    <input type="submit" value="Delete all"  name="payment_form" class="button action" id="doaction">
                </div>
                <div class="alignleft actions">
                    <label for="filter-by-date" class="screen-reader-text">Filter by date</label>
                    <select name="filter_by" id="filter-by-date">
                        <option selected="selected" value="-1">Filter By</option>
                        <option value="status_pending">Pending Status</option>
                        <option value="status_completed">Completed Status</option>
                    </select>
                    <input type="submit" name="filter_action" id="post-query-submit" class="button" value="Filter">
                </div>
                <p class="search-box">
                    <label for="post-search-input" class="screen-reader-text">Search Name :</label>
                    <input type="text" value="<?php echo (isset($_GET['s']) && !empty($_GET['s'])) ? $_GET['s'] : ""; ?>" name="s" category_template_id="post-search-input">
                    <input type="submit" value="Search Name" name="category_search_submit" class="button-primary" id="search-submit">
                </p>
            </div>

            <!--- end of search box -->
            <table class="wp-list-table widefat fixed striped users">
                <thead>
                    <tr>
                        <th style="" class="manage-column column-cb check-column" coupon_id="cb" scope="col">

                            <label for="cb-select-all-1" class="screen-reader-text">Select All</label>
                            <input id="cb-select-all-1" type="checkbox">
                        </th>
                        <th style="" class="manage-column column-username sortable desc" coupon_id="username" scope="col">
                            <span>Name</span>

                        </th>
                        <th style="" class="manage-column column-username sortable desc" coupon_id="username" scope="col">
                            <span>Invoice No</span>

                        </th>
                        <th style="" class="manage-column column-username sortable desc" coupon_id="username" scope="col">
                            <span>Invoice Amount</span>

                        </th>
                        <th style="" class="manage-column column-username sortable desc" coupon_id="username" scope="col">
                            <span>Payment Status</span>

                        </th>
                        <th style="" class="manage-column column-username sortable desc" coupon_id="username" scope="col">
                            <span>State</span>

                        </th>
                        <th style="" class="manage-column column-username sortable desc" coupon_id="username" scope="col">
                            <span>Zip code</span>
                        </th>
                        <th style="" class="manage-column column-username sortable desc" coupon_id="username" scope="col">
                            <span>Date of Transaction</span>
                        </th>
                    </tr>
                </thead>
                <tbody data-wp-lists="list:user" coupon_id="the-list">
                    <?php
                    //echo 'SELECT * FROM  '.$table_name." ORDER BY `id` ASC LIMIT ".$start_from.",".$num_rec_per_page;
                    //echo 'SELECT * FROM  '.$table_name." ORDER BY `id` ASC LIMIT ".$start_from, $num_rec_per_page;
                    if (count($all_payment_list) > 0 && is_array($all_payment_list)):
                        foreach ($all_payment_list as $id => $payonline_list_array) {
                            $get_responses = unserialize($payonline_list_array['response']);
                            ?>
                            <tr coupon_id="user-1">
                                <th class="check-column" scope="row">
                                    <label for="user_1" class="screen-reader-text">Select admin</label>
                                    <input id="cb-select-9" type="checkbox" name="payment_id[]" value="<?php echo $payonline_list_array['id']; ?>">

                                <td class="username column-username">
                                    <strong>
                                        <a href="<?php echo admin_url("admin.php?page=view_payonline_detail&action=view&payment_id=" . $payonline_list_array['id']); ?>"><?php echo $payonline_list_array['customer_name']; ?></a>
                                    </strong>
                                    <br>
                                    <div class="row-actions">
                                        <span class="edit"><a href="<?php echo admin_url("admin.php?page=view_payonline_detail&action=view&payment_id=" . $payonline_list_array['id']); ?>">View</a></span>
                                        <span class="trash"> |  <a class="submitdelete" href="<?php echo admin_url("admin.php?page=payonline_list&action=delete_payment&payment_id=" . $payonline_list_array['id']); ?>">Delete</a> </span>
                                    </div>
                                </td>
                                <td class="username column-username">
                                    <strong>
                                        <?php echo $payonline_list_array['invoice']; ?>
                                    </strong>
                                </td>
                                <td class="username column-username">
                                    <strong>
                                        <?php echo $payonline_list_array['invoice_amount']; ?>
                                    </strong>
                                </td>
                                <td class="username column-username">
                                    <strong>
                                        <?php echo ucfirst($payonline_list_array['payment_status']); ?>
                                    </strong>
                                </td>
                                <td class="username column-username">
                                    <strong>
                                        <?php echo $payonline_list_array['state']; ?>
                                    </strong>
                                </td>
                                <td class="username column-username">
                                    <strong>
                                        <?php echo $payonline_list_array['zip']; ?>
                                    </strong>
                                </td>
                                <td class="username column-username">
                                    <strong>
                                        <?php echo $payonline_list_array['date_of_transaction']; ?>
                                    </strong>
                                </td>
                            </tr>
                            <?php
                        }
                    else:
                        ?>
                        <tr coupon_id="user-1">
                            <th class="check-column" scope="row" colspan="8">
                    <h5 align="center">No record found</h5>
                    </th>
                    </tr>
                <?php
                endif;
                ?>
                <!--- pagination ---->
                <?php
                /** search * */
                $search_query = '';

                if (isset($_GET['s']) && !empty($_GET['s']) && $_GET['page'] == "payonline_list") {
                    $search_text = trim(esc_attr($_GET['s']));
                    $table_name = $wpdb->prefix . "payment_response";
                    $all_payment_list_data = $wpdb->get_results("SELECT * FROM  " . $table_name . " WHERE `customer_name` LIKE '%" . $search_text . "%' GROUP BY `id` ORDER BY `id` ASC", ARRAY_A);
                } else {
                    $table_name = $wpdb->prefix . "payment_response";
                    $all_payment_list_data = $wpdb->get_results('SELECT * FROM  ' . $table_name . " GROUP BY `id` ORDER BY `id` ASC", ARRAY_A);
                }
                $total_records = count($all_payment_list_data);  //count number of records
                $total_pages = ceil($total_records / $num_rec_per_page);
                // $total_pages=1;
                ///  echo 'total pages '.$total_pages;
                echo '<div class="tablenav top"><div class="tablenav-pages"><span class="pagination-links">';
                echo "<a  class='prev-page first-page' href=" . admin_url("admin.php?page=payonline_list") . "&paged=1" . ">" . '«' . "</a> "; // Goto 1st page
                for ($i = 1; $i <= $total_pages; $i++) {
                    echo "<a href=" . admin_url("admin.php?page=payonline_list") . "&paged=" . $i . $search_query . ">" . $i . "</a> ";
                };
                echo "<a class='next-page' href=" . admin_url("admin.php?page=payonline_list") . "&paged=" . $total_pages . ">" . '»' . "</a> "; // Goto last page
                echo "</span></div></div>";
                ?>
                <!-- end of pagination-->
                </tbody>
            </table>
            <?php wp_nonce_field('post_nonce', 'post_nonce_field'); ?>
            <input type="hidden" name="submitted" category_template_id="submitted" value="true" />
            <input type="hidden" name="page" category_template_id="submitted" value="payonline_list" />
        </form>
        <!-- end of form -->
        <script type="text/javascript">
            jQuery('.submitdelete').on('click', function (e) {
                confirm_del = confirm('Are You Sure to Delete');
                if (confirm_del) {
                    return true;
                } else {
                    e.preventDefault();
                }
            });
        </script>
    </div>

    <?php
    /*
     *
     */
}