using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Collections;
using System.Web.UI.WebControls;

using CMS.ExtendedControls;
using CMS.FormControls;
using CMS.GlobalHelper;

public partial class CMSAdminControls_Basic_OrderByControl : FormEngineUserControl
{
    #region "Private variables"

    private List<ListItem> mColumns = new List<ListItem>();

    private List<OrderByRow> orderByRows = new List<OrderByRow>();

    private IList<string> mValues = null;

    private IList<int> mControlIdentifiers = null;

    // Control names
    private static string TXTCOLUMN_ID_PREFIX = "txtColumn";

    private static string DRPCOLUMN_ID_PREFIX = "drpColumn";

    private static string DRPDIRECTION_ID_PREFIX = "drpDirection";

    private static string LBLTHENBY_ID_PREFIX = "lblThenBy";

    private static string PNLORDERBY_ID_PREFIX = "pnlOrderBy";

    private static string SELECT_COLUMN = "##SELECTCOLUMN##";

    // Direction constants
    private static string ASC = "ASC";

    private static string DESC = "DESC";

    // JavaScript prefixes
    private static string SET_DIRECTION_TXT = "SetDirectionTxt";

    private static string SET_DIRECTION_DRP = "SetDirectionDrp";

    #endregion


    #region "Classes"

    /// <summary>
    /// Holds one 'ORDER BY' row.
    /// </summary>
    private class OrderByRow
    {
        /// <summary>
        /// Index of a row.
        /// </summary>
        public int Index
        {
            get;
            private set;
        }


        /// <summary>
        /// Label 'then by'.
        /// </summary>
        public LocalizedLabel ThenByLabel
        {
            get;
            private set;
        }


        /// <summary>
        /// Control for specifying column.
        /// </summary>
        public Control ColumnControl
        {
            get;
            private set;
        }


        /// <summary>
        /// Control for specifying sort direction.
        /// </summary>
        public DropDownList DirectionDropDown
        {
            get;
            private set;
        }


        /// <summary>
        /// Wrapping panel.
        /// </summary>
        public Panel Panel
        {
            get;
            private set;
        }


        /// <summary>
        /// String representation of sorting column value.
        /// </summary>
        public string Column
        {
            get
            {
                // Get column name based on current column control
                if (ColumnControl.GetType() == typeof(TextBox))
                {
                    TextBox txtColumn = ColumnControl as TextBox;
                    return txtColumn.Text.Trim();
                }
                else if (ColumnControl.GetType() == typeof(DropDownList))
                {
                    DropDownList drpColumn = ColumnControl as DropDownList;
                    return drpColumn.SelectedValue.Trim();
                }
                else
                {
                    return string.Empty;
                }
            }
            set
            {
                if (ColumnControl.GetType() == typeof(TextBox))
                {
                    TextBox txtColumn = ColumnControl as TextBox;
                    txtColumn.Text = value;
                }
                else if (ColumnControl.GetType() == typeof(DropDownList))
                {
                    DropDownList drpColumn = ColumnControl as DropDownList;
                    drpColumn.SelectedValue = value;
                }
            }
        }


        /// <summary>
        /// Default constructor for 'order by' row.
        /// </summary>
        /// <param name="index">Index of a row</param>
        /// <param name="thenByLabel">Label 'then by'</param>
        /// <param name="orderByControl">Control for specifying column</param>
        /// <param name="directionDropDown">Control for specifying sort direction</param>
        /// <param name="panel">Wrapping panel</param>
        public OrderByRow(int index, LocalizedLabel thenByLabel, Control orderByControl, DropDownList directionDropDown, Panel panel)
        {
            Index = index;
            ThenByLabel = thenByLabel;
            ColumnControl = orderByControl;
            DirectionDropDown = directionDropDown;
            Panel = panel;
        }
    }

    #endregion


    #region "Enumerations"

    /// <summary>
    /// Determines which control to use when selecting columns
    /// </summary>
    public enum SelectorMode
    {
        TextBox,
        DropDownList
    }

    #endregion


    #region "Properties"

    /// <summary>
    /// Mode the control is currently working in.
    /// </summary>
    public SelectorMode Mode
    {
        get;
        set;
    }


    /// <summary>
    /// Indicates if delayed reload should be used.
    /// If True reload data must be called externaly.
    /// </summary>
    public bool DelayedReload
    {
        get;
        set;
    }


    /// <summary>
    /// Gets or sets columns. When columns are specified, control switches to dropdown list mode 
    /// allowing user to select from specified columns instead of typing them in.
    /// </summary>
    public List<ListItem> Columns
    {
        get
        {
            return mColumns;
        }
        set
        {
            mColumns = value;
        }
    }


    /// <summary>
    /// Array of column control indexes.
    /// </summary>
    private IList<int> ControlIdentifiers
    {
        get
        {
            return mControlIdentifiers;
        }
    }


    /// <summary>
    /// Gets or sets the field value.
    /// </summary>
    public override object Value
    {
        get
        {
            string returnValue = null;
            IEnumerable<OrderByRow> rows = from row in orderByRows
                                           where ((row.Column != SELECT_COLUMN) && !String.IsNullOrEmpty(row.Column))
                                           group row by row.Column
                                           into groupedRows
                                           let rowRecord = groupedRows.First()
                                           select rowRecord;
            // For all rows where column is specified and is distinct
            foreach (OrderByRow row in rows)
            {
                Panel panel = row.Panel;

                if (panel != null)
                {
                    string text = row.Column;
                    // Get direction dropdown list control
                    DropDownList drpDirection = row.DirectionDropDown;
                    returnValue += text + " " + drpDirection.SelectedValue + ",";
                }
            }
            if (!string.IsNullOrEmpty(returnValue))
            {
                returnValue = returnValue.TrimEnd(',');
            }
            return returnValue;
        }
        set
        {
            string clauses = ValidationHelper.GetString(value, string.Empty);

            if (!string.IsNullOrEmpty(clauses))
            {
                Values = clauses.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
            }
            else
            {
                Values = null;
            }
        }
    }


    /// <summary>
    /// Array with values.
    /// </summary>
    private IList<string> Values
    {
        get
        {
            if (mValues == null)
            {
                return ValidationHelper.GetString(Value, string.Empty).Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
            }
            return mValues;
        }
        set
        {
            mValues = value;
        }
    }

    #endregion


    #region "Page events"

    public CMSAdminControls_Basic_OrderByControl()
    {

    }



    protected void Page_Load(object sender, EventArgs e)
    {
        if (!DelayedReload)
        {
            ReloadData();
        }
    }


    protected override void OnPreRender(EventArgs e)
    {
        base.OnPreRender(e);
        // Make final adjustments of controls
        RefreshControls();
    }

    #endregion


    #region "Control events"

    protected void txtBox_TextChanged(object sender, EventArgs e)
    {
        // jQuery script for cursor position
        string script = "jQuery('#" + ((TextBox)sender).ClientID + "').putCursorAtEnd()";
        ScriptHelper.RegisterStartupScript(this, typeof(string), "putCursorAtEnd", ScriptHelper.GetScript(script));
    }


    protected void drpOrderBy_SelectedIndexChanged(object sender, EventArgs e)
    {
        DropDownList drp = ((DropDownList)sender);
        vals[drp.ID] = drp.SelectedValue;
    }


    private Dictionary<string, string> vals
    {
        get
        {
            Dictionary<string, string> x = (Dictionary<string, string>)ViewState["vals"];
            if (x == null)
            {
                x = new Dictionary<string, string>();
                ViewState["vals"] = x;
            }
            return x;
        }
    }

    #endregion


    #region "Methods"

    /// <summary> 
    /// Reloads control
    /// </summary>
    public void ReloadData()
    {
        SetupControl();
    }


    /// <summary>
    /// Add controls for saved values.
    /// </summary>
    private void SetupControl()
    {
        if (StopProcessing)
        {
            // Do nothing
        }
        else
        {
            orderByRows.Clear();
            plcOrderBy.Controls.Clear();
            mControlIdentifiers = Array.ConvertAll<string, int>(hdnIndices.Value.Trim().Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries), new Converter<string, int>(StringToInt));
            hdnIndices.Value = string.Empty;
            int count = 0;

            if (ControlIdentifiers.Count > 0)
            {
                count = ControlIdentifiers.Count;

                // Generate controls with used indexes
                for (int i = 0; i < count; i++)
                {
                    AddRow(ControlIdentifiers[i], (i != 0));
                }
            }
            else
            {
                // Reload controls based on Value property
                if (Values != null)
                {
                    count = Values.Count;

                    // Add controls with saved values
                    for (int i = 0; i < count; i++)
                    {
                        string line = Values[i].Trim();
                        string[] valuesArray = line.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);

                        if (valuesArray.Length > 0)
                        {
                            string column = valuesArray[0];
                            string direction = (valuesArray.Length > 1) ? valuesArray[1] : ASC;
                            AddRow(i, column, direction, (i != 0));
                        }
                    }
                }
            }

            // Register JavaScripts
            ScriptHelper.RegisterJQuery(Page);
            // Register direction selectors
            StringBuilder sharedScript = new StringBuilder();
            sharedScript.Append(@"
function ", SET_DIRECTION_TXT, @"(txtColumnId)
{
    var txtColumn = $j('#' + txtColumnId);
    var drpDirection = $j(txtColumn).next();
    if(txtColumn.val() != '')
    {
        drpDirection.removeAttr('disabled');
    }
    else
    {
        drpDirection.attr('disabled', 'disabled');
    }
}
function ", SET_DIRECTION_DRP, @"(drpColumnId)
{
    var drpColumn = $j('#' + drpColumnId);
    var drpDirection = $j(drpColumn).next();
    if(drpColumn.val() != '", SELECT_COLUMN, @"')
    {
        drpDirection.removeAttr('disabled');
    }
    else
    {
        drpDirection.attr('disabled', 'disabled');
    }
}");
            // Register script for keeping focus and scroll position
            sharedScript.Append(@"
(function($j) {
jQuery.fn.putCursorAtEnd = function() {
return this.each(function() {
    $j(this).focus();
    if (this.setSelectionRange) {
        var len = $j(this).val().length * 2;
        this.setSelectionRange(len, len);
    }
    else {
        $j(this).val($j(this).val());
    }
    this.scrollTop = 999999;
});
};
})(jQuery);
window.orderBySelector = [];
");
            ScriptHelper.RegisterStartupScript(this, typeof(string), "orderBySelector", ScriptHelper.GetScript(sharedScript.ToString()));

            // Register function for automatic row addition
            StringBuilder controlScript = new StringBuilder();
            controlScript.Append(@"
jQuery('#", pnlUpdate.ClientID, @"').find('input[id*=" + ((Mode == SelectorMode.TextBox) ? TXTCOLUMN_ID_PREFIX : DRPCOLUMN_ID_PREFIX) + @"]').each(function(){
jQuery(this).keyup(function(){
var parentID = jQuery(this).parent('.orderBySelector').attr('id');
clearTimeout(window.orderBySelector[parentID]);
window.orderBySelector[parentID] = setTimeout('jQuery(\'#'+this.id+'\').trigger(\'change\')',500);
})
.keydown(function(){
var parentID = jQuery(this).parent('.orderBySelector').attr('id');
clearTimeout(window.orderBySelector[parentID]);
});
});");
            ScriptHelper.RegisterStartupScript(this, typeof(string), "orderBySelector" + ClientID, ScriptHelper.GetScript(controlScript.ToString()));
        }
    }


    /// <summary>
    /// Converts string to integer.
    /// </summary>
    /// <param name="value">Value to convert</param>
    /// <returns>Converted integer</returns>
    private int StringToInt(string value)
    {
        return ValidationHelper.GetInteger(value, 0);
    }


    /// <summary>
    /// Returns true if the returned value is valid.
    /// </summary>
    public override bool IsValid()
    {
        int i = 0;
        // Check errors in textbox
        foreach (OrderByRow row in orderByRows)
        {
            int index = row.Index;
            Panel panel = row.Panel;

            string text = row.Column;

            bool isLastRow = (orderByRows.IndexOf(row) == orderByRows.Count - 1);

            // Check whether entered value is an identifier
            if (!ValidationHelper.IsIdentifier(text) && !isLastRow)
            {
                LocalizedLabel lblError = new LocalizedLabel();
                lblError.ResourceString = "orderbycontrol.notidentifier";
                lblError.CssClass = "ErrorLabel";
                lblError.ID = "lblError" + index;
                panel.Controls.Add(lblError);
                i++;
            }
        }

        return (i == 0);
    }


    /// <summary>
    /// Gets actual controls values for return value.
    /// </summary>
    private void RefreshControls()
    {
        List<OrderByRow> rowsToRemove = new List<OrderByRow>();

        // For all rows
        for (int index = 0; index < orderByRows.Count; index++)
        {
            OrderByRow row = orderByRows[index];
            Panel panel = row.Panel;

            if (panel != null)
            {
                string text = row.Column;

                // If value is specified
                if (String.IsNullOrEmpty(text) || (text == SELECT_COLUMN))
                {
                    bool isFirstRow = orderByRows.IndexOf(row) == 0;
                    int nextRowIndex = index + 1;
                    // If there are more rows
                    if (isFirstRow && (orderByRows.Count > nextRowIndex))
                    {
                        OrderByRow nextRow = orderByRows[nextRowIndex];
                        Panel nextPanel = nextRow.Panel;
                        if (nextPanel != null)
                        {
                            // Remove 'then by' label
                            LocalizedLabel label = nextRow.ThenByLabel;
                            nextPanel.Controls.Remove(label);
                        }
                    }

                    // Remove row from controls collection
                    plcOrderBy.Controls.Remove(panel);
                    // Remove its index
                    hdnIndices.Value = hdnIndices.Value.Replace(row.Index + ";", string.Empty);
                    // Remove reference to the row
                    rowsToRemove.Add(row);
                }
            }
        }

        // Remove previously selected (empty) rows
        foreach (OrderByRow row in rowsToRemove)
        {
            orderByRows.Remove(row);
        }

        // Get first free row index
        int newRowIndex = 0;
        while (orderByRows.FirstOrDefault(row => row.Index == newRowIndex) != null)
        {
            newRowIndex++;
        }
        // If other clauses can be specified
        if (!((Mode == SelectorMode.DropDownList) && (orderByRows.Count >= Columns.Count)))
        {
            // Add new empty line
            AddRow(newRowIndex, (orderByRows.Count != 0));
        }
    }


    /// <summary>
    /// Adds textbox/dropdown list determining sort column, dropdown list determining sort direction and 'then by' label
    /// </summary>
    /// <param name="i">Index of a control</param>
    /// <param name="addThenBy">Whether to add 'then by' label</param>
    private void AddRow(int i, bool addThenBy)
    {
        AddRow(i, string.Empty, string.Empty, addThenBy);
    }


    /// <summary>
    /// Clones array of list items.
    /// </summary>
    /// <param name="items">List item array</param>
    /// <returns>Copied array of list items</returns>
    public ListItem[] CloneItems(ListItem[] items)
    {
        ListItem[] newItems = null;
        if (items != null)
        {
            newItems = new ListItem[items.Length];
            for (int i = 0; i < items.Length; i++)
            {
                ListItem item = items[i];
                newItems[i] = new ListItem(item.Text, item.Value);
            }
        }
        return newItems;
    }


    /// <summary>
    /// Adds textbox/dropdown list determining sort column, dropdown list determining sort direction and 'then by' label
    /// </summary>
    /// <param name="i">Index of a control</param>
    /// <param name="sortColumn">Sort column</param>
    /// <param name="sortDirection">Sort direction</param>
    /// <param name="addThenBy">Whether to add 'then by' label</param>
    private void AddRow(int i, string sortColumn, string sortDirection, bool addThenBy)
    {
        hdnIndices.Value += i + ";";

        Panel pnlOrderBy = new Panel();
        pnlOrderBy.ID = PNLORDERBY_ID_PREFIX + i;

        LocalizedLabel lblThenBy = null;
        if (addThenBy)
        {
            // Add 'Then by' label 
            lblThenBy = new LocalizedLabel();
            lblThenBy.ResourceString = "orderbycontrol.thenby";
            lblThenBy.CssClass = "ThenBy";
            lblThenBy.ID = LBLTHENBY_ID_PREFIX + i;
        }

        // Add non-breakable space
        LiteralControl ltlNbsp = new LiteralControl("&nbsp;");
        ltlNbsp.ID = "ltlNbsp" + i;

        // Add dropdown list for setting direction
        DropDownList drpDirection = new DropDownList();
        drpDirection.ID = DRPDIRECTION_ID_PREFIX + i;
        drpDirection.CssClass = "ShortDropDownList";
        drpDirection.Items.Add(new ListItem(GetString("general.ascending"), ASC));
        drpDirection.Items.Add(new ListItem(GetString("general.descending"), DESC));
        drpDirection.AutoPostBack = true;
        if (!String.IsNullOrEmpty(sortDirection))
        {
            // Set value
            drpDirection.SelectedValue = sortDirection;
        }

        Control orderByControl = null;
        switch (Mode)
        {
                // Add textbox for column name
            case SelectorMode.TextBox:
                TextBox txtColumn = new TextBox();
                txtColumn.ID = TXTCOLUMN_ID_PREFIX + i;
                txtColumn.CssClass = "SelectorTextBox";
                txtColumn.TextChanged += txtBox_TextChanged;
                txtColumn.AutoPostBack = true;

                if (!String.IsNullOrEmpty(sortColumn))
                {
                    // Set sorting column
                    txtColumn.Text = sortColumn;
                }
                orderByControl = txtColumn;
                break;

                // Add dropdown list for column selection
            case SelectorMode.DropDownList:
                DropDownList drpColumn = new DropDownList();
                drpColumn.ID = DRPCOLUMN_ID_PREFIX + i;
                drpColumn.CssClass = "ColumnDropDown";
                drpColumn.SelectedIndexChanged += drpOrderBy_SelectedIndexChanged;
                drpColumn.AutoPostBack = true;
                drpColumn.Items.Add(new ListItem(GetString("orderbycontrol.selectcolumn"), SELECT_COLUMN));
                drpColumn.Items.AddRange(CloneItems(Columns.ToArray()));
                if (!String.IsNullOrEmpty(sortColumn))
                {
                    // Set sorting column
                    drpColumn.SelectedValue = sortColumn;
                }
                orderByControl = drpColumn;
                break;
        }

        // Add controls to panel
        if (lblThenBy != null)
        {
            pnlOrderBy.Controls.Add(lblThenBy);
        }
        if (orderByControl != null)
        {
            pnlOrderBy.Controls.Add(orderByControl);
        }
        pnlOrderBy.Controls.Add(ltlNbsp);
        pnlOrderBy.Controls.Add(drpDirection);

        // Add panel to place holder
        plcOrderBy.Controls.Add(pnlOrderBy);

        // Setup enable/disable script for direction dropdown list
        if (orderByControl is TextBox)
        {
            (orderByControl as TextBox).Attributes.Add("onkeyup", SET_DIRECTION_TXT + "('" + orderByControl.ClientID + "')");
            ScriptHelper.RegisterStartupScript(this, typeof(string), "setEnabledTxt" + orderByControl.ClientID, ScriptHelper.GetScript("$j(document).ready(function() {" + SET_DIRECTION_TXT + "('" + orderByControl.ClientID + "');})"));
        }
        else if (orderByControl is DropDownList)
        {
            ScriptHelper.RegisterStartupScript(this, typeof(string), "setEnabledDrp" + orderByControl.ClientID, ScriptHelper.GetScript("$j(document).ready(function() {" + SET_DIRECTION_DRP + "('" + orderByControl.ClientID + "');})"));
        }

        // Add row to collection
        orderByRows.Add(new OrderByRow(i, lblThenBy, orderByControl, drpDirection, pnlOrderBy));
    }

    #endregion
}