Use JavaScript to order some dates [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 11 years ago.

Improve this question

I have a WordPress plugin "Ultimate WPQSF" which is outputting a drop down list on the front end of my site but as far as I can tell I can not choose to order this list by date.

On the front end it is outputting the following drop down list

<select id="tdp-0" name="taxo[0][term]">
    <option value="august-2013">August 2013</option>
    <option value="august-2014">August 2014</option>
    <option value="december-2013">December 2013</option>
    <option value="march_2014">March 2014</option>
    <option value="may-2014">May 2014</option>
</select>

What I want to do with this is pull the data from these options and order is by date then input it back into the select in the new order which would be the latest date first (August 2014). The desired outcome after processing it would be as follows

<select id="tdp-0" name="taxo[0][term]">
    <option value="august-2014">August 2014</option>
    <option value="may-2014">May 2014</option>
    <option value="march_2014">March 2014</option>
    <option value="december-2013">December 2013</option>
    <option value="august-2013">August 2013</option>
</select>

I know a bit of jQuery and JavaScript but not enough to do something this advanced. Any advice would be appreciated.

Convert them into JavaScript date objects. Then sort them by date and format them as strings again. — Blazemonger
– Blazemonger, Commented Aug 12, 2014 at 15:23
Alternatively, store the dates as self-sorting strings: "20140801" instead of "august-2014". — Blazemonger
– Blazemonger, Commented Aug 12, 2014 at 15:24
And to get the list into strings: stackoverflow.com/a/3051100/728393 — DanielST
– DanielST, Commented Aug 12, 2014 at 15:25

DannyThunder · Accepted Answer · 2014-08-12 16:29:45Z

Dont know if it is a typo with march_2014, if not, you have to alter the code to handle both - and _

JSFiddle: http://jsfiddle.net/6xde9500/

//For adding capitalaizing the first letter-function to strings
String.prototype.capitalize = function() {
    return this.charAt(0).toUpperCase() + this.slice(1);
}

myMonths = ["january", "february", "march", "april", "may", "june", "july", "august", "september", "october", "november", "december"];

//Array that hold date objects
dateArray = new Array();

//Create date objects
function getDateObject(value){   

    montAndYear = value.split("-");

    date = new Date();

    //Set year and month 
    date.setYear(montAndYear[1]);

    //Since the months are stored by name, get the proper value from the myMoths array
    date.setMonth(myMonths.indexOf(montAndYear[0]));

    return date;
}

function updateSelection(){
    $("#tdp-0")
        .find('option')
        .remove()
        .end();

    for(i = 0; i < dateArray.length; i++){

        month = myMonths[dateArray[i].getMonth()];
        year = dateArray[i].getFullYear();

        $("#tdp-0").append('<option value="'+month+'-'+year+'">'+ month.capitalize() + ' ' + year +'</option>');

        if(i == 0){
            $("#tdp-0").val(month+'-'+year);
        }
    }
}

//Get all the values and sorts them
$("#tdp-0 option").each(function(){
    dateArray.push(getDateObject($(this).val()));
}).promise().done(function(){

    dateArray.sort(function(a,b){
        return a>b ? -1 : a<b ? 1 : 0;
    });

    updateSelection();
});

Collectives™ on Stack Overflow

Use JavaScript to order some dates [closed]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related