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 |
var query_parameters = settings.aoColumns |
554 |
.filter(function(col) { |
555 |
return col.bSearchable && typeof col.data == 'string' && (data.columns[col.idx].search.value != '' || filter != '') |
556 |
}) |
557 |
.map(function(col) { |
558 |
var part = {}; |
559 |
part[!col.data.includes('.')?'me.'+col.data:col.data] = {like: (data.columns[col.idx].search.value != '' ? data.columns[col.idx].search.value : filter)+'%'}; |
560 |
return part; |
561 |
}); |
562 |
|
563 |
if(query_parameters.length) { |
564 |
query_parameters = JSON.stringify(query_parameters.length === 1?query_parameters[0]:query_parameters); |
565 |
if(options.header_filter) { |
566 |
options.query_parameters = query_parameters; |
567 |
} else { |
568 |
dataSet.q = query_parameters; |
569 |
delete options.query_parameters; |
570 |
} |
571 |
} else { |
572 |
delete options.query_parameters; |
573 |
} |
574 |
|
575 |
dataSet._match = 'starts_with'; |
576 |
|
577 |
if(options.columns) { |
578 |
var order = data.order; |
579 |
order.forEach(function (e,i) { |
580 |
var order_col = e.column; |
581 |
var order_by = options.columns[order_col].data; |
582 |
var order_dir = e.dir == 'asc' ? '+' : '-'; |
583 |
dataSet._order_by = order_dir + (!order_by.includes('.')?'me.'+order_by:order_by); |
584 |
}); |
585 |
} |
586 |
|
587 |
return dataSet; |
588 |
} |
589 |
} |
590 |
}, options); |
591 |
} |
592 |
return $(this).dataTable(settings); |
593 |
}; |
594 |
|
595 |
})(jQuery); |