View | Details | Raw Unified | Return to bug 24561
Collapse All | Expand All

(-)a/koha-tmpl/intranet-tmpl/prog/js/datatables.js (+92 lines)
Lines 502-504 function filterDataTable( table, column, term ){ Link Here
502
        table.search( term ).draw("page");
502
        table.search( term ).draw("page");
503
    }
503
    }
504
}
504
}
505
506
jQuery.fn.dataTable.ext.errMode = function(settings, note, message) {
507
    console.warn(message);
508
};
509
510
(function($) {
511
512
    $.fn.api = function(options) {
513
        var settings = null;
514
        if(options) {
515
            settings = $.extend(true, {}, dataTablesDefaults, {
516
                        'deferRender': true,
517
                        "paging": true,
518
                        'serverSide': true,
519
                        'searching': true,
520
                        'pagingType': 'full',
521
                        'ajax': {
522
                            'type': 'GET',
523
                            'cache': true,
524
                            'dataSrc': 'data',
525
                            'beforeSend': function(xhr, settings) {
526
                                this._xhr = xhr;
527
                                if(options.embed) {
528
                                    xhr.setRequestHeader('x-koha-embed', Array.isArray(options.embed)?options.embed.join(','):options.embed);
529
                                }
530
                                if(options.header_filter && options.query_parameters) {
531
                                    xhr.setRequestHeader('x-koha-query', options.query_parameters);
532
                                    delete options.query_parameters;
533
                                }
534
                            },
535
                            'dataFilter': function(data, type) {
536
                                var json = {data: JSON.parse(data)};
537
                                if(total = this._xhr.getResponseHeader('x-total-count')) {
538
                                    json.recordsTotal = total;
539
                                    json.recordsFiltered = total;
540
                                }
541
                                return JSON.stringify(json);
542
                            },
543
                            'data': function( data, settings ) {
544
                                var length = data.length;
545
                                var start  = data.start;
546
547
                                var dataSet = {
548
                                    _page: Math.floor(start/length) + 1,
549
                                    _per_page: length
550
                                };
551
552
                                var filter = data.search.value;
553
                                if (filter != '') {
554
                                    var query_parameters = settings.aoColumns
555
                                    .filter(function(col) {
556
                                        return col.bSearchable && typeof col.data == 'string'
557
                                    })
558
                                    .map(function(col) {
559
                                        var part = {};
560
                                        part[!col.data.includes('.')?'me.'+col.data:col.data] = {like: filter+'%'};
561
                                        return part;
562
                                    });
563
564
                                    if(query_parameters.length) {
565
                                        query_parameters = JSON.stringify(query_parameters.length === 1?query_parameters[0]:query_parameters);
566
                                        if(options.header_filter) {
567
                                            options.query_parameters = query_parameters;
568
                                        } else {
569
                                            dataSet.q = query_parameters;
570
                                        }
571
                                    }
572
573
                                    dataSet._match = 'starts_with';
574
                                } else {
575
                                    delete options.query_parameters;
576
                                }
577
578
                                if(options.columns) {
579
                                    var order = data.order;
580
                                    order.forEach(function (e,i) {
581
                                        var order_col      = e.column;
582
                                        var order_by       = options.columns[order_col].data;
583
                                        var order_dir      = e.dir == 'asc' ? '+' : '-';
584
                                        dataSet._order_by = order_dir + (!order_by.includes('.')?'me.'+order_by:order_by);
585
                                    });
586
                                }
587
588
                                return dataSet;
589
                            }
590
                        }
591
                    }, options);
592
        }
593
        return $(this).dataTable(settings);
594
    };
595
596
})(jQuery);
(-)a/koha-tmpl/opac-tmpl/bootstrap/js/datatables.js (-1 / +88 lines)
Lines 123-125 jQuery.extend( jQuery.fn.dataTableExt.sort, { Link Here
123
    });
123
    });
124
124
125
}());
125
}());
126
- 
126
127
(function($) {
128
129
    $.fn.api = function(options) {
130
        var settings = null;
131
        if(options) {
132
            settings = $.extend(true, {}, dataTablesDefaults, {
133
                        'deferRender': true,
134
                        "paging": true,
135
                        'serverSide': true,
136
                        'searching': true,
137
                        'pagingType': 'full',
138
                        'ajax': {
139
                            'type': 'GET',
140
                            'cache': true,
141
                            'dataSrc': 'data',
142
                            'beforeSend': function(xhr, settings) {
143
                                this._xhr = xhr;
144
                                if(options.embed) {
145
                                    xhr.setRequestHeader('x-koha-embed', Array.isArray(options.embed)?options.embed.join(','):options.embed);
146
                                }
147
                                if(options.header_filter && options.query_parameters) {
148
                                    xhr.setRequestHeader('x-koha-query', options.query_parameters);
149
                                    delete options.query_parameters;
150
                                }
151
                            },
152
                            'dataFilter': function(data, type) {
153
                                var json = {data: JSON.parse(data)};
154
                                if(total = this._xhr.getResponseHeader('x-total-count')) {
155
                                    json.recordsTotal = total;
156
                                    json.recordsFiltered = total;
157
                                }
158
                                return JSON.stringify(json);
159
                            },
160
                            'data': function( data, settings ) {
161
                                var length = data.length;
162
                                var start  = data.start;
163
164
                                var dataSet = {
165
                                    _page: Math.floor(start/length) + 1,
166
                                    _per_page: length
167
                                };
168
169
                                var filter = data.search.value;
170
                                if (filter != '') {
171
                                    var query_parameters = settings.aoColumns
172
                                    .filter(function(col) {
173
                                        return col.bSearchable && typeof col.data == 'string'
174
                                    })
175
                                    .map(function(col) {
176
                                        var part = {};
177
                                        part[!col.data.includes('.')?'me.'+col.data:col.data] = {like: filter+'%'};
178
                                        return part;
179
                                    });
180
181
                                    if(query_parameters.length) {
182
                                        query_parameters = JSON.stringify(query_parameters.length === 1?query_parameters[0]:query_parameters);
183
                                        if(options.header_filter) {
184
                                            options.query_parameters = query_parameters;
185
                                        } else {
186
                                            dataSet.q = query_parameters;
187
                                        }
188
                                    }
189
190
                                    dataSet._match = 'starts_with';
191
                                } else {
192
                                    delete options.query_parameters;
193
                                }
194
195
                                if(options.columns) {
196
                                    var order = data.order;
197
                                    order.forEach(function (e,i) {
198
                                        var order_col      = e.column;
199
                                        var order_by       = options.columns[order_col].data;
200
                                        var order_dir      = e.dir == 'asc' ? '+' : '-';
201
                                        dataSet._order_by = order_dir + (!order_by.includes('.')?'me.'+order_by:order_by);
202
                                    });
203
                                }
204
205
                                return dataSet;
206
                            }
207
                        }
208
                    }, options);
209
        }
210
        return $(this).dataTable(settings);
211
    };
212
213
})(jQuery);

Return to bug 24561