jqueryExamples/paging.js at master · SoccerField24x7/jqueryExamples · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
$(document).ready(function() {
    $('#coach-list').DataTable({
        "order": [ 2, "asc" ],
        "pageLength": "100",
    });
});

function saveOrder(pageid, order) {
    var url = '/admin/setsort';

    $.ajax({
        type: 'GET',
        url: url + '/' + pageid + '/' + order,
        data: '',
        async: true,
        success: function ( data ) {
            var response = $.parseJSON(data);
            console.log(response);
            if(typeof response.error != 'undefined') {
                alert(response.error);
            } else {
                console.log(response.Message);
            }
        },
        error: function (request, status, error) {
            alert(request.responseText);
        }
    });
}

$(".moveup").click(function(){
    /* take a snapshot of what's where */
    var this_page_id = $(this).closest('tr').children('td:first').text();
    var this_order = $(this).closest('tr').children('td:nth-child(3)').text();
    var prev_page_id = $(this).closest('tr').prev().children('td:first').text();
    var prev_order = $(this).closest('tr').prev().children('td:nth-child(3)').text();

    /* set the display values - the database values will actually be set later */
    $(this).closest('tr').children('td:nth-child(3)').text(prev_order);
    $(this).closest('tr').prev().children('td:nth-child(3)').text(this_order);

    /* actually move the row now */
    $(this).parents('tr').prev().before($(this).parents("tr"));

    /* now save the page movement to the database */
    saveOrder(this_page_id, prev_order);
    saveOrder(prev_page_id, this_order);

});

$(".movedown").click(function(){

    var this_page_id = $(this).closest('tr').children('td:first').text();
    var this_order = $(this).closest('tr').children('td:nth-child(3)').text();
    var next_page_id = $(this).closest('tr').next().children('td:first').text();
    var next_order = $(this).closest('tr').next().children('td:nth-child(3)').text();

    $(this).closest('tr').children('td:nth-child(3)').text(next_order);
    $(this).closest('tr').prev().children('td:nth-child(3)').text(this_order);

    $(this).parents("tr").next().after($(this).parents("tr"));

    /* now save the page movement to the database */
    saveOrder(this_page_id, next_order);
    saveOrder(next_page_id, this_order);
});