<?php
/**
 * Plugin Name: Underwriting Team Manager
 * Version: 1.0
 * Author: Tenzing Communications, Inc.
 * Description: Manage a broker list from Commonwell active directory.
 */

if (!class_exists('WP_List_Table')) {
    require_once(ABSPATH . 'wp-admin/includes/class-wp-list-table.php');
}

class CommonwellBrokerListManager extends WP_List_Table
{
    /** Class constructor */
    public function __construct()
    {
        parent::__construct(
            [
                'singular' => __('Broker', 'tz'), //singular name of the listed records
                'plural'   => __('Brokers', 'tz'), //plural name of the listed records
                'ajax'     => false //does this table support ajax?
            ]
        );
    }

    /**
     * Retrieve broker data from the database
     *
     * @param int $per_page
     * @param int $page_number
     *
     * @return mixed
     */
    public static function get_broker_list($per_page = 5, $page_number = 1)
    {
        global $wpdb;
        $sql = "SELECT * FROM {$wpdb->prefix}broker_list";
        if (!empty($_REQUEST['orderby'])) {
            $sql .= ' ORDER BY ' . esc_sql($_REQUEST['orderby']);
            $sql .= !empty($_REQUEST['order']) ? ' ' . esc_sql($_REQUEST['order']) : ' ASC';
        }
        $sql    .= " LIMIT $per_page";
        $sql    .= ' OFFSET ' . ($page_number - 1) * $per_page;
        $result = $wpdb->get_results($sql, 'ARRAY_A');

        return $result;
    }


    /**
     * Delete a customer record.
     *
     * @param int $id customer ID
     */
    public static function delete_broker($id)
    {
        global $wpdb;
        $wpdb->delete(
            "{$wpdb->prefix}broker_list",
            ['ID' => $id],
            ['%d']
        );
    }

    /**
     * Returns the count of records in the database.
     *
     * @return null|string
     */
    public static function record_count()
    {
        global $wpdb;
        $sql = "SELECT COUNT(*) FROM {$wpdb->prefix}broker_list";

        return $wpdb->get_var($sql);
    }

    /** Text displayed when no customer data is available */
    public function no_items()
    {
        _e('No broker found.', 'tz');
    }

    /**
     * Render a column when no column specific method exist.
     *
     * @param array  $item
     * @param string $column_name
     *
     * @return mixed
     */
    public function column_default($item, $column_name)
    {
        switch ($column_name) {
            case 'id':
            case 'broker_org_name':
            case 'broker_id':
            case 'group_name_in_ad':
            case 'group_id':
                return $item[$column_name];
            default:
                return print_r($item, true);
        }
    }

    /**
     * Render the bulk edit checkbox
     *
     * @param array $item
     *
     * @return string
     */
    function column_cb($item)
    {
        return sprintf(
            '<input type="checkbox" name="bulk-delete[]" value="%s" />',
            $item['id']
        );
    }

    /**
     * Method for name column
     *
     * @param array $item an array of DB data
     *
     * @return string
     */
    function column_broker_org_name($item)
    {
        $delete_nonce = wp_create_nonce('tz_delete_broker');
        $edit_nonce   = wp_create_nonce('tz_edit_broker');
		

        $title   = '<strong>' . $item['broker_org_name'] . '</strong>';
        $actions = [
            'delete' => sprintf(
                '<a href="?page=%s&action=%s&broker=%s&_wpnonce=%s">Delete</a>',
                esc_attr($_REQUEST['page']),
                'delete',
                absint($item['id']),
                $delete_nonce
            ),
            'edit'   => sprintf(
                '<a href="?page=%s&action=%s&broker=%s&_wpnonce=%s">Edit</a>',
                esc_attr($_REQUEST['page']),
                'edit',
                absint($item['id']),
                $edit_nonce
            ),

        ];

        return $title . $this->row_actions($actions);
    }

    /**
     *  Associative array of columns
     *
     * @return array
     */
    function get_columns()
    {
        $columns = [
            'cb'               => '<input type="checkbox" />',
            'broker_org_name'  => __('Broker Org Name', 'tz'),
            'broker_id'        => __('Broker ID', 'tz'),
            'group_name_in_ad' => __('Group Name in AD', 'tz')
        ];

        return $columns;
    }

    /**
     * Columns to make sortable.
     *
     * @return array
     */
    public function get_sortable_columns()
    {
        $sortable_columns = array(
            'broker_org_name'  => array('broker_org_name', true),
            'broker_id'        => array('broker_id', false),
            'group_name_in_ad' => array('group_name_in_ad', false)
        );

        return $sortable_columns;
    }

    /**
     * Returns an associative array containing the bulk action
     *
     * @return array
     */
    public function get_bulk_actions()
    {
        $actions = [
            'bulk-delete' => 'Delete'
        ];

        return $actions;
    }

    public function column_group_name_in_ad($item)
    {
        return $item['group_name_in_ad'] . ' : ' . $item['group_id'];
    }

    /**
     * Handles data query and filter, sorting, and pagination.
     */
    public function prepare_items()
    {
        $this->_column_headers = $this->get_column_info();
        /** Process bulk action */
        $this->process_bulk_action();
        $per_page     = $this->get_items_per_page('broker_list_per_page', 5);
        $current_page = $this->get_pagenum();
        $total_items  = self::record_count();
        $this->set_pagination_args(
            [
                'total_items' => $total_items, //WE have to calculate the total number of items
                'per_page'    => $per_page //WE have to determine how many items to show on a page
            ]
        );
        $this->items = self::get_broker_list($per_page, $current_page);
    }

    public function process_bulk_action()
    {
        //Detect when a bulk action is being triggered...
        if ('delete' === $this->current_action()) {
            // In our file that handles the request, verify the nonce.
            $nonce = esc_attr($_REQUEST['_wpnonce']);
            if (!wp_verify_nonce($nonce, 'tz_delete_broker')) {
                die('Go get a life script kiddies');
            } else {
                self::delete_broker(absint($_GET['broker']));
                // esc_url_raw() is used to prevent converting ampersand in url to "#038;"
                // add_query_arg() return the current url
                wp_redirect(esc_url_raw(remove_query_arg('action')));
                //                exit;
            }
        }
        // If the delete bulk action is triggered
        if ((isset($_POST['action']) && $_POST['action'] == 'bulk-delete')
            || (isset($_POST['action2']) && $_POST['action2'] == 'bulk-delete')
        ) {
            $delete_ids = esc_sql($_POST['bulk-delete']);
            // loop over the array of record IDs and delete them
            foreach ($delete_ids as $id) {
                self::delete_broker($id);
            }
            // esc_url_raw() is used to prevent converting ampersand in url to "#038;"
            // add_query_arg() return the current url
            wp_redirect(esc_url_raw(add_query_arg()));
            //            exit;
        }
    }

    /**
     * Generate the table rows
     *
     * @since 3.1.0
     * @access public
     */
    public function display_rows()
    {
        if (isset($_POST['s']) && $_POST['s'] != '') {
            foreach ($this->items as $item) {
                if (preg_grep('/' . $_POST['s'] . '/i', $item)) {
                    $this->single_row($item);
                } else {
                    continue;
                }
            }
        } else {
            foreach ($this->items as $item) {
                $this->single_row($item);
            }
        }
    }

    /**
     * Display the search box.
     *
     * @since 3.1.0
     * @access public
     *
     * @param string $text The search button text
     * @param string $input_id The search input id
     */
    public function search_box($text, $input_id)
    {
        if (empty($_REQUEST['s']) && !$this->has_items()) {
            return;
        }

        $input_id = $input_id . '-search-input';

        if (!empty($_REQUEST['orderby'])) {
            echo '<input type="hidden" name="orderby" value="' . esc_attr($_REQUEST['orderby']) . '" />';
        }
        if (!empty($_REQUEST['order'])) {
            echo '<input type="hidden" name="order" value="' . esc_attr($_REQUEST['order']) . '" />';
        }
        if (!empty($_REQUEST['post_mime_type'])) {
            echo '<input type="hidden" name="post_mime_type" value="' . esc_attr($_REQUEST['post_mime_type']) . '" />';
        }
        if (!empty($_REQUEST['detached'])) {
            echo '<input type="hidden" name="detached" value="' . esc_attr($_REQUEST['detached']) . '" />';
        }
        ?>
        <p class="search-box">
            <label class="screen-reader-text" for="<?php echo $input_id ?>"><?php echo $text; ?>:</label>
            <input type="search" id="<?php echo $input_id ?>" name="s" value="<?php _admin_search_query(); ?>" />
            <?php submit_button($text, 'button', false, false, array('id' => 'search-submit')); ?>
        </p>
        <?php
    }

}

class TZ_Plugin
{
    // class instance
    static $instance;
    // customer WP_List_Table object
    public $brokerListManagerObj;

    // class constructor
    public function __construct()
    {
        add_filter('set-screen-option', [__CLASS__, 'set_screen'], 10, 3);
        add_action('admin_menu', [$this, 'plugin_menu']);
    }

    public static function set_screen($status, $option, $value)
    {
        return $value;
    }

    public function plugin_menu()
    {
        $hook = add_menu_page(
            'Underwriting Teams',
            'Underwriting Teams',
            'manage_options',
            'commonwell_broker_list_manager',
            [$this, 'plugin_settings_page']
        );
        add_action("load-$hook", [$this, 'screen_option']);

        // Add sub pages
        add_submenu_page(
            'commonwell_broker_list_manager',
            'Assign New Underwriting Team',
            'Assign Underwriting Team',
            'manage_options',
            'add_new_broker',
            array($this, 'add_new_broker_page')
        );
    }

    public function add_new_broker_page()
    {
        global $wpdb;
        $isSuccess = false;

        // Is submitted?
        if (isset($_POST['submit'])) {
            // Update Broker Info
			$brokerList = get_option('broker_list') ? unserialize(get_option('broker_list')) : [];
			$key = array_search($_POST['broker_id'], array_column($brokerList, 'broker_id'));
            $result = $wpdb->insert(
                "{$wpdb->prefix}broker_list",
                [
                    'broker_id' => $_POST['broker_id'],
                    'broker_org_name' => $brokerList[$key]['brokerage'],
                    'group_name_in_ad' => $_POST['group_name_in_ad'],
                    'group_id' => $_POST['group_id']
                ]
            );

            if($result) {
                $isSuccess = true;
            }
			
        print('<script>window.location.href="admin.php?page=commonwell_broker_list_manager"</script>');
 		exit;
        }

        // Get group from Commonwell AD
        $groups = GraphServiceAccessHelper::getFeed('groups');
        $groupIds = $wpdb->get_col("SELECT group_id FROM {$wpdb->prefix}broker_list");
		        
        $brokerList = get_option('broker_list') ? unserialize(get_option('broker_list')) : [];

        // Check if the group objectId exists.
        $groupList = array_filter($groups, function($group) use($groupIds) {
            $inArray = in_array($group->objectId, $groupIds);
            return !$inArray;
        });

        ?>
        <style>
            #poststuff form input[type="text"] {
                width : 100%;
            }
        </style>
        <div class="wrap">
            <h2>Underwriting Team Manager</h2>
            <div id="poststuff">
                <div id="post-body" class="metabox-holder columns-2">
                    <div id="post-body-content">
                        <div class="meta-box-sortables ui-sortable">
                            <h3>Assign Underwriting Team</h3>
                            <?php if (isset($_POST['submit']) && $isSuccess) : ?>
                                <div id="message" class="updated notice notice-success is-dismissible">
                                    <p>Assigned Underwriting Team</p>
                                    <button type="button" class="notice-dismiss"><span class="screen-reader-text">Dismiss this notice.</span>
                                    </button>
                                </div>
                            <?php endif; ?>
                            <form method="post" id="new-broker-form">
                                <table class="wp-list-table widefat fixed striped">
                                    <tbody>
                              
                                     <tr>
                                      <td>
                                            <label for="broker_id">Broker ID: </label>
                                        </td>
                                        <td>
                                      
                                        <select name="broker_id" id="broker_id" required>
                                                <option value=""> -- Broker -- </option>
                                                <?php
                                                foreach ($brokerList as $broker) { ?>
                                                
                                                    <option value="<?php echo $broker['broker_id'] ?>" data-group-id="<?php echo $broker['broker_id'];?>"> <?php echo $broker['brokerage']; ?></option>
                                                <?php } ?>
                                            </select>
                                                </td>
                                    <tr>
                                        <td>
                                            <label for="group_name_in_ad">Group Name in AD: </label>
                                        </td>
                                        <td>
                                            <select name="group_name_in_ad" id="group_name_in_ad" required>
                                                <option value=""> -- Group Name -- </option>
                                                <?php
                                                foreach ($groupList as $group) { ?>
                                                    <option value="<?php echo trim($group->displayName); ?>" data-group-id="<?php echo trim($group->objectId);?>"> <?php echo $group->displayName; ?></option>
                                                <?php } ?>
                                            </select>
                                        </td>
                                    </tr>
                                    </tbody>
                                </table>
                                <input type="hidden" name="group_id" id="group_id" value=""/>

                                <br class="clear">
                                <input type="submit" name="submit" id="submit"
                                       class="button button-primary button-large" value="Submit">
                            </form>
                            <script>
                                (function($) {
                                    var $newBrokerForm = $('#new-broker-form');
                                    var $groupDropdown = $newBrokerForm.find('#group_name_in_ad');
                                    var $groupId = $('#group_id');

                                    $groupDropdown.on('change', setGroupId).trigger('change');

                                    function setGroupId(e) {
                                        var objectId = e.target.selectedOptions[0].dataset.groupId;
                                        $groupId.val(objectId);
                                    }
                                })(jQuery);
                            </script>
                        </div>
                    </div>
                </div>
                <br class="clear">
            </div>
        </div>
        <?php
    }

    /**
     * Plugin settings page
     */
    public function plugin_settings_page()
    {
        // Broker edit action
        ?>
        <?php if (isset($_GET['action']) && $_GET['action'] === 'edit') : ?>
        <?php
        global $wpdb;

        $isSuccess     = false;
        $id            = isset($_GET['broker']) ?  $_GET['broker'] : '';

        // Is submitted?
        if (isset($_POST['submit'])) {
            // Update Broker Info
			$brokerList = get_option('broker_list') ? unserialize(get_option('broker_list')) : [];
			$key = array_search($_POST['broker_id'], array_column($brokerList, 'broker_id'));
			
            $result = $wpdb->update(
                "{$wpdb->prefix}broker_list",
                [
                    'broker_id' => $_POST['broker_id'],
                    'broker_org_name' => $brokerList[$key]['brokerage'],
                    'group_name_in_ad' => $_POST['group_name_in_ad'],
                    'group_id' => $_POST['group_id']

                ],
                ['id' => $id]
            );

            if($result) {
                $isSuccess = true;
				
        

			}
		print('<script>window.location.href="admin.php?page=commonwell_broker_list_manager"</script>');
 		exit;
				
				
          
        }

        $currentBroker = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}broker_list WHERE id={$id}", ARRAY_A)[0];
        $currentBrokerGroupName = $currentBroker['group_name_in_ad'];
        $currentBrokerGroupId = $currentBroker['group_id'];
		$currentBrokerId = $currentBroker['broker_id'];
	

        // Get group from Commonwell AD
        $groups = GraphServiceAccessHelper::getFeed('groups');
        $groupIds = $wpdb->get_col("SELECT group_id FROM {$wpdb->prefix}broker_list");

        // Check if the group objectId exists.
        $groupList = array_filter($groups, function($group) use($groupIds, $currentBrokerGroupId) {
            $inArray = in_array($group->objectId, $groupIds);
            return !$inArray || ($group->objectId === $currentBrokerGroupId);
        });
		// Get group from Commonwell AD
       
        
        $brokerList = get_option('broker_list') ? unserialize(get_option('broker_list')) : [];
       
	
        ?>
        <style>
            #poststuff form input[type="text"] {
                width : 100%;
            }
        </style>
        <div class="wrap">
            <h2>Underwriting Team Manager</h2>
            <div id="poststuff">
                <div id="post-body" class="metabox-holder columns-2">
                    <div id="post-body-content">
                        <div class="meta-box-sortables ui-sortable">
                            <h3>Edit Assigned Underwriting Team</h3>
                            <?php if (isset($_POST['submit']) && $isSuccess) : ?>
                                <div id="message" class="updated notice notice-success is-dismissible">
                                    <p>Assigned Underwriting Team edited.</p>
                                    <button type="button" class="notice-dismiss"><span class="screen-reader-text">Dismiss this notice.</span>
                                    </button>
                                </div>
                            <?php endif; ?>
                            <form method="post" id="edit-broker-form" action="">
                                <table class="wp-list-table widefat fixed striped">
                                    <tbody>
                       
                                        <td>
                                            <label for="broker_id">Broker ID: </label>
                                        </td>
                                        <td>
                                      
                                        <select name="broker_id" id="broker_id" required>
                                                <option value=""> -- Broker -- </option>
                                                <?php
                                                foreach ($brokerList as $broker) { ?>
                                                    <?php
													
       
                                                    $isSelected = $broker['broker_id'] === $currentBrokerId ? 'selected' : '';
                                                    ?>
                                                    <option <?php echo $isSelected; ?> value="<?php echo $broker['broker_id'] ?>" data-group-id="<?php echo $broker['broker_id'];?>"> <?php echo $broker['brokerage']; ?></option>
                                                <?php } ?>
                                            </select>
                                                </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            <label for="group_name_in_ad">Group Name in AD: </label>
                                        </td>
                                        <td>
                                            <select name="group_name_in_ad" id="group_name_in_ad" required>
                                                <option value=""> -- Group Name -- </option>
                                                <?php
                                                foreach ($groupList as $group) { ?>
                                                    <?php
                                                    $isSelected = $group->displayName === $currentBrokerGroupName ? 'selected' : '';
                                                    ?>
                                                    <option <?php echo $isSelected; ?> value="<?php echo $group->displayName ?>" data-group-id="<?php echo $group->objectId;?>"> <?php echo $group->displayName; ?></option>
                                                <?php } ?>
                                            </select>
                                        </td>
                                    </tr>
                                    </tbody>
                                </table>
                                <input type="hidden" name="group_id" id="group_id" value=""/>

                                <br class="clear">
                                <input type="submit" name="submit" id="submit"
                                       class="button button-primary button-large" value="Submit">
                            </form>

                            <script>
                                (function($) {
                                    var $editBrokerForm = $('#edit-broker-form');
                                    var $groupDropdown = $editBrokerForm.find('#group_name_in_ad');
                                    var $groupId = $('#group_id');

                                    $groupDropdown.on('change', setGroupId).trigger('change');

                                    function setGroupId(e) {
                                        var objectId = e.target.selectedOptions[0].dataset.groupId;
                                        $groupId.val(objectId);
                                    }
                                })(jQuery);
                            </script>
                        </div>
                    </div>
                </div>
                <br class="clear">
            </div>
        </div>
    <?php else : ?>
        <div class="wrap">
            <h2>Underwriting Team Manager</h2>
            <div id="poststuff">
                <div id="post-body" class="metabox-holder columns-2">
                    <div id="post-body-content">
                        <div class="meta-box-sortables ui-sortable">
                            <h3 style="margin-bottom: 0;">Underwriting Teams<a href="/wp-admin/admin.php?page=add_new_broker"
                                                                     class="page-title-action">Assign Underwriting Team</a></h3>
                            <form method="post">
                                <?php
                                $this->brokerListManagerObj->prepare_items();
                                $this->brokerListManagerObj->search_box('search', 'search_id');
                                $this->brokerListManagerObj->display(); ?>
                            </form>
                        </div>
                    </div>
                </div>
                <br class="clear">
            </div>
        </div>
    <?php endif; ?>
        <?php
    }

    /**
     * Screen options
     */
    public function screen_option()
    {
        $option = 'per_page';
        $args   = [
            'label'   => 'Broker List Manager',
            'default' => 5,
            'option'  => 'broker_list_per_page'
        ];
        add_screen_option($option, $args);
        $this->brokerListManagerObj = new CommonwellBrokerListManager();
    }

    /** Singleton instance */
    public static function get_instance()
    {
        if (!isset(self::$instance)) {
            self::$instance = new self();
        }

        return self::$instance;
    }
}

add_action(
    'plugins_loaded',
    function () {
        TZ_Plugin::get_instance();
    }
);