https://wpdatatables.com/wp-content/cache/min/1/wp-content/plugins…/wpdatatables/wdt.funcs.js?ver=1790755046

1jQuery(document).ready(function($){var wdtDateFormat=getMomentWdtDateFormat();var wdtTimeFormat=getMomentWdtTimeFormat();jQuery('.wdt-preload-layer').animateFadeOut();if(typeof wpdatatables_functions_strings!=='undefined'){$.fn.DataTable.defaults.oLanguage.sInfo=wpdatatables_functions_strings.sInfo_functions;$.fn.DataTable.defaults.oLanguage.sSearch=wpdatatables_functions_strings.sSearch_functions;$.fn.DataTable.defaults.oLanguage.lengthMenu=wpdatatables_functions_strings.lengthMenu_functions;$.fn.DataTable.defaults.oLanguage.sEmptyTable=wpdatatables_functions_strings.sEmptyTable_functions;$.fn.DataTable.defaults.oLanguage.sInfoEmpty=wpdatatables_functions_strings.sInfoEmpty_functions;$.fn.DataTable.defaults.oLanguage.sInfoFiltered=wpdatatables_functions_strings.sInfoFiltered_functions;$.fn.DataTable.defaults.oLanguage.sInfoPostFix=wpdatatables_functions_strings.sInfoPostFix_functions;$.fn.DataTable.defaults.oLanguage.sInfoThousands=wpdatatables_functions_strings.sInfoThousands_functions;$.fn.DataTable.defaults.oLanguage.sLengthMenu=wpdatatables_functions_strings.sLengthMenu_functions;$.fn.DataTable.defaults.oLanguage.sProcessing=wpdatatables_functions_strings.sProcessing_functions;$.fn.DataTable.defaults.oLanguage.sZeroRecords=wpdatatables_functions_strings.sZeroRecords_functions;$.fn.DataTable.defaults.oLanguage.oPaginate=wpdatatables_functions_strings.oPaginate_functions;$.fn.DataTable.defaults.oLanguage.oAria=wpdatatables_functions_strings.oAria_functions}
2if(typeof($.fn.dataTableExt)!=='undefined'){$.fn.dataTableExt.errMode='throw';$.fn.dataTableExt.oApi.fnFilterClear=function(oSettings){oSettings.oPreviousSearch.sSearch="";if(typeof oSettings.aanFeatures.f!='undefined'){var n=oSettings.aanFeatures.f;for(var i=0,iLen=n.length;i<iLen;i++){$('input',n[i]).val('')}}
3for(var i=0,iLen=oSettings.aoPreSearchCols.length;i<iLen;i++){oSettings.aoPreSearchCols[i].sSearch=""}
4oSettings.oApi._fnReDraw(oSettings)};$.extend($.fn.dataTableExt.oSort,{"formatted-num-pre":function(a){if($(a).text()!=''){a=$(a).text()}
5a=(a==="-"||a==="")?0:a.replace(/[^\d\-\.]/g,"");if(a!=-1&&a!=""){while(a.indexOf('.')!=-1){a=a.replace(".","")}
6a=a.replace(',','.')}
7return parseFloat(a)},"formatted-num-asc":function(a,b){return a-b},"formatted-num-desc":function(a,b){return b-a},"statuscol-pre":function(a){a=$(a).find('div.percents').text();return parseFloat(a)},"statuscol-asc":function(a,b){return a-b},"statuscol-desc":function(a,b){return b-a},"date-custom-pre":function(date){return wdtPrepareDate(date,wdtDateFormat,wdtTimeFormat)},"time-custom-pre":function(time){return wdtPrepareTime(time,wdtTimeFormat)}});$.fn.dataTableExt.oApi.fnGetColumnIndex=function(oSettings,sCol){var cols=oSettings.aoColumns;for(var x=0,xLen=cols.length;x<xLen;x++){if((typeof(cols[x].sTitle)=='string')&&(cols[x].sTitle.toLowerCase()==sCol.toLowerCase())){return x}}
8return-1};$.fn.dataTableExt.aTypes.unshift(function(sData){"use strict";if(/^([0-2]?\d|3[0-1])-(jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec)-\d{4}/i.test(sData)){return'date-dd-mmm-yyyy'}
9return null});$.fn.dataTableExt.oSort['date-dd-mmm-yyyy-asc']=function(a,b){"use strict";var ordA=wdtCustomDateDDMMMYYYYToOrd(a),ordB=wdtCustomDateDDMMMYYYYToOrd(b);return(ordA<ordB)?-1:((ordA>ordB)?1:0)};$.fn.dataTableExt.oSort['date-dd-mmm-yyyy-desc']=function(a,b){"use strict";var ordA=wdtCustomDateDDMMMYYYYToOrd(a),ordB=wdtCustomDateDDMMMYYYYToOrd(b);return(ordA<ordB)?1:((ordA>ordB)?-1:0)}}
10$('body').on('focus','.wdt-datepicker',function(){var isHandsonTable=$(this).parent('.handsontableInputHolder').length
11if(!isHandsonTable){var wpTableDescription=$(this).closest('.wdt-constructor-default-value').length||$(this).closest('.wpDataTableFilterSection').length||$(this).closest('.modal-body').length||$(this).closest('.wdt-editing-enabled-block').length||$(this).closest('.wdt-filter-default-value-from-block').length||$(this).closest('.wdt-filter-default-value-to-block').length||$(this).closest('.wdt-conditional-formatting-rule').length?'':JSON.parse(jQuery('#'+$(this).parents('table').data().describedBy).val());var filterElem='none';if($(this).closest('.wpDataTableFilterSection').length==0&&$(this).closest('.modal-body').length==0&&$(this).closest('.wdt-constructor-default-value').length==0&&$(this).closest('.wdt-editing-enabled-block').length==0&&$(this).closest('.wdt-filter-default-value-from-block').length==0&&$(this).closest('.wdt-filter-default-value-to-block').length==0&&$(this).closest('.wdt-conditional-formatting-rule').length==0){if(wpTableDescription.dataTableParams.fixedColumns||wpTableDescription.dataTableParams.fixedHeader.header){filterElem=wpTableDescription.renderFilter==="header"?'th':'td'}}}
12moment.locale(wpdatatables_frontend_strings.wdt_locale_language);$(this).datetimepicker({format:wdtDateFormat,showClear:!0,keepOpen:!1,useCurrent:!1,locale:wpdatatables_frontend_strings.wdt_locale_language,}).off('dp.show').on('dp.show',function(){$(this).parent().find('div.bootstrap-datetimepicker-widget').addClass('wdt-datetimepicker-modal');if(!_.contains(['MM/Y','MMM Y','Y'],wdtDateFormat)){wdtAddDatePlaceholders($(this))}
13if(!isHandsonTable){showDateTimePickerForFixedHeaderAndColumns($(this),filterElem,0)}}).on('dp.hide',function(){if(!isHandsonTable){hidePickerForFixedHeaderAndColumns($(this))}})});

13$('body').on('focus','.wdt-timepicker',function(){var isHandsonTable=$(this).parent('.handsontableInputHolder').length
14if(!isHandsonTable){var wpTableDescription=$(this).closest('.wdt-constructor-default-value').length||$(this).closest('.wpDataTableFilterSection').length||$(this).closest('.modal-body').length||$(this).closest('.wdt-editing-enabled-block').length||$(this).closest('.wdt-filter-default-value-from-block').length||$(this).closest('.wdt-filter-default-value-to-block').length||$(this).closest('.wdt-conditional-formatting-rule').length?'':JSON.parse(jQuery('#'+$(this).parents('table').data().describedBy).val());var filterElem='none';if($(this).closest('.wpDataTableFilterSection').length==0&&$(this).closest('.modal-body').length==0&&$(this).closest('.wdt-constructor-default-value').length==0&&$(this).closest('.wdt-editing-enabled-block').length==0&&$(this).closest('.wdt-filter-default-value-from-block').length==0&&$(this).closest('.wdt-filter-default-value-to-block').length==0&&$(this).closest('.wdt-conditional-formatting-rule').length==0){if(wpTableDescription.dataTableParams.fixedColumns||wpTableDescription.dataTableParams.fixedHeader.header){filterElem=wpTableDescription.renderFilter==="header"?'th':'td'}}}
15$(this).datetimepicker({format:wdtTimeFormat,showClear:!0,keepOpen:!0,useCurrent:!1}).off('dp.show').on('dp.show',function(){$(this).parent().find('div.bootstrap-datetimepicker-widget').addClass('wdt-datetimepicker-modal');if(!isHandsonTable){showDateTimePickerForFixedHeaderAndColumns($(this),filterElem,1)}}).on('dp.hide',function(){if(!isHandsonTable){hidePickerForFixedHeaderAndColumns($(this))}})});$('body').on('focus','.wdt-datetimepicker',function(){var isHandsonTable=$(this).parent('.handsontableInputHolder').length
16if(!isHandsonTable){var wpTableDescription=$(this).closest('.wdt-constructor-default-value').length||$(this).closest('.wpDataTableFilterSection').length||$(this).closest('.modal-body').length||$(this).closest('.wdt-editing-enabled-block').length||$(this).closest('.wdt-filter-default-value-from-block').length||$(this).closest('.wdt-filter-default-value-to-block').length||$(this).closest('.wdt-conditional-formatting-rule').length?'':JSON.parse(jQuery('#'+$(this).parents('table').data().describedBy).val());var filterElem='none';if($(this).closest('.wpDataTableFilterSection').length==0&&$(this).closest('.modal-body').length==0&&$(this).closest('.wdt-constructor-default-value').length==0&&$(this).closest('.wdt-editing-enabled-block').length==0&&$(this).closest('.wdt-filter-default-value-from-block').length==0&&$(this).closest('.wdt-filter-default-value-to-block').length==0&&$(this).closest('.wdt-conditional-formatting-rule').length==0){if(wpTableDescription.dataTableParams.fixedColumns||wpTableDescription.dataTableParams.fixedHeader.header){filterElem=wpTableDescription.renderFilter==="header"?'th':'td'}}}
17$(this).datetimepicker({format:wdtDateFormat+' '+wdtTimeFormat,showClear:!0,keepOpen:!0,useCurrent:!1}).off('dp.show').on('dp.show',function(){$(this).parent().find('div.bootstrap-datetimepicker-widget').addClass('wdt-datetimepicker-modal');if(!_.contains(['MM/Y','MMM Y','Y'],wdtDateFormat)){wdtAddDatePlaceholders($(this))}
18if(!isHandsonTable){showDateTimePickerForFixedHeaderAndColumns($(this),filterElem,0)}}).on('dp.hide',function(){if(!isHandsonTable){hidePickerForFixedHeaderAndColumns($(this))}})})});var wdtCustomDateDDMMMYYYYToOrd=function(date){"use strict";var dateParts=date.split(/-/);return(dateParts[2]*10000)+(jQuery.inArray(dateParts[1].toUpperCase(),["JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"])*100)+dateParts[0]};function wdtValidateURL(textval){var regex=/^([a-z]([a-z]|\d|\+|-|\.)*):(\/\/(((([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(%[\da-f]{2})|[!\$&'\(\)\*\+,;=]|:)*@)?((\[(|(v[\da-f]{1,}\.(([a-z]|\d|-|\.|_|~)|[!\$&'\(\)\*\+,;=]|:)+))\])|((\d|[1-9]\d|1\d\d|2[0-4]\d|25[0-5])\.(\d|[1-9]\d|1\d\d|2[0-4]\d|25[0-5])\.(\d|[1-9]\d|1\d\d|2[0-4]\d|25[0-5])\.(\d|[1-9]\d|1\d\d|2[0-4]\d|25[0-5]))|(([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(%[\da-f]{2})|[!\$&'\(\)\*\+,;=])*)(:\d*)?)(\/(([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(%[\da-f]{2})|[!\$&'\(\)\*\+,;=]|:|@)*)*|(\/((([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(%[\da-f]{2})|[!\$&'\(\)\*\+,;=]|:|@)+(\/(([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(%[\da-f]{2})|[!\$&'\(\)\*\+,;=]|:|@)*)*)?)|((([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(%[\da-f]{2})|[!\$&'\(\)\*\+,;=]|:|@)+(\/(([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(%[\da-f]{2})|[!\$&'\(\)\*\+,;=]|:|@)*)*)|((([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(%[\da-f]{2})|[!\$&'\(\)\*\+,;=]|:|@)){0})(\?((([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(%[\da-f]{2})|[!\$&'\(\)\*\+,;=]|:|@)|[\uE000-\uF8FF]|\/|\?)*)?(\#((([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(%[\da-f]{2})|[!\$&'\(\)\*\+,;=]|:|@)|\/|\?)*)?(||.*)?$/i;return regex.test(textval)}
19function wdtPrepareDate(date,wdtDateFormat,wdtTimeFormat){var format=wdtDateFormat+' '+wdtTimeFormat;if(date=="")return'';return moment(date,format).valueOf()}
20function wdtPrepareTime(time,wdtTimeFormat){return moment(time,wdtTimeFormat).valueOf()}
21function wdtValidateEmail(email){var regex=/^([a-zA-Z0-9_.+-])+\@(([a-zA-Z0-9-])+\.)+([a-zA-Z0-9]{2,4})+(||.*)?$/;return regex.test(email)}
22function wdtRandString(n){if(!n){n=5}
23var text='';var possible='ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz';for(var i=0;i<n;i++){text+=possible.charAt(Math.floor(Math.random()*possible.length))}
24return text}
25function wdtFormatNumber(n,c,d,t){c=isNaN(c=Math.abs(c))?2:c,d=d==undefined?".":d,t=t==undefined?",":t,s=n<0?"-":"",i=parseInt(n=Math.abs(+n||0).toFixed(c))+"",j=(j=i.length)>3?j%3:0;return s+(j?i.substr(0,j)+t:"")+i.substr(j).replace(/(\d{3})(?=\d)/g,"$1"+t)+(c?d+Math.abs(n-i).toFixed(c).slice(2):"")}
26function wdtUnformatNumber(number,thousandsSeparator,decimalsSeparator,isFloat){if(typeof isFloat=='undefined'){isFloat=!1}
27var return_string=String(number).replace(new RegExp('\\'+thousandsSeparator,'g'),'');if(isFloat&&decimalsSeparator==','){return_string=return_string.replace(new RegExp('\\'+decimalsSeparator),'.')}
28return return_string}
29function wdtCalculateColumnSum(columnData,thousandsSeparator){if(columnData.length>0){if(thousandsSeparator=='.'){var sum=columnData.reduce(function(a,b){return parseFloat(a)+parseFloat(b.replace(/\./g,'').replace(',','.'))},0)}else{sum=columnData.reduce(function(a,b){return parseFloat(a)+parseFloat(b.replace(/\,/g,''))},0)}}else{sum=0}
30return parseFloat(sum)}
31function wdtCalculateColumnMin(columnData,thousandsSeparator){if(columnData.length>0){var min='';if(thousandsSeparator=='.'){if(columnData.length==1){min=parseFloat(typeof(columnData[0])=='number'?columnData[0]:columnData[0].replace(/\./g,'').replace(',','.'))}else{min=columnData.reduce(function(a,b){return parseInt(typeof(a)=='number'?a:a.replace(/\./g,''))<=parseInt(b.replace(/\./g,''))?parseFloat(typeof(a)=='number'?a:a.replace(/\./g,'').replace(',','.')):parseFloat(b.replace(/\./g,'').replace(',','.'))})}}else{min=columnData.reduce(function(a,b){return parseInt(typeof(a)=='number'?a:a.replace(/\,/g,''))<=parseInt(b.replace(/\,/g,''))?parseFloat(typeof(a)=='number'?a:a.replace(/\,/g,'')):parseFloat(b.replace(/\,/g,''))})}}else{min=0}
32return min}
33function wdtCalculateColumnMax(columnData,thousandsSeparator){if(columnData.length>0){var max='';if(thousandsSeparator=='.'){if(columnData.length==1){max=parseFloat(typeof(columnData[0])=='number'?columnData[0]:columnData[0].replace(/\./g,'').replace(',','.'))}else{max=columnData.reduce(function(a,b){return parseInt(typeof(a)=='number'?a:a.replace(/\./g,''))>=parseInt(b.replace(/\./g,''))?parseFloat(typeof(a)=='number'?a:a.replace(/\./g,'').replace(',','.')):parseFloat(b.replace(/\./g,'').replace(',','.'))})}}else{max=columnData.reduce(function(a,b){return parseInt(typeof(a)=='number'?a:a.replace(/\,/g,''))>=parseInt(b.replace(/\,/g,''))?parseFloat(typeof(a)=='number'?a:a.replace(/\,/g,'')):parseFloat(b.replace(/\,/g,''))})}}else{max=0}
34return max}
35function wdtFormatNumberByColumnType(number,columnType,columnDecimalPlaces,generalDecimalPlaces,decimalSeparator,thous

35andsSeparator){var numStr='';if(columnType=='int'){numStr=wdtFormatNumber(number,0,decimalSeparator,thousandsSeparator)}else{if(columnDecimalPlaces!=-1){numStr=wdtFormatNumber(number,columnDecimalPlaces,decimalSeparator,thousandsSeparator)}else{numStr=wdtFormatNumber(number,generalDecimalPlaces,decimalSeparator,thousandsSeparator)}}
36return numStr}
37function wdtFillPossibleValuesList(distValues){if(jQuery('#wdt-column-values-list').tagsinput('items').length>0){jQuery('#wdt-possible-values-merge-list-modal').modal('show');jQuery('.wdt-merge-possible-values').click(function(e){e.preventDefault();e.stopImmediatePropagation();var oldListValues=jQuery.extend([],jQuery('#wdt-column-values-list').tagsinput('items'));var mergedValues=jQuery.merge(oldListValues,distValues);jQuery('#wdt-column-values-list').tagsinput('removeAll');mergedValues.sort();mergedValues=jQuery.unique(mergedValues);jQuery('#wdt-column-values-list').tagsinput('add',mergedValues.join('|'));jQuery('#wdt-possible-values-merge-list-modal').modal('hide')});jQuery('.wdt-replace-possible-values').click(function(e){e.preventDefault();e.stopImmediatePropagation();jQuery('#wdt-column-values-list').tagsinput('removeAll');distValues.sort();jQuery('#wdt-column-values-list').tagsinput('add',distValues.join('|'));jQuery('#wdt-possible-values-merge-list-modal').modal('hide')})}else{distValues.sort();jQuery('#wdt-column-values-list').tagsinput('add',distValues.join('|'))}}
38function wdtAddDatePlaceholders(input){if(input.hasClass("formatting-rule-cell-value")){jQuery('.wpdt-conditional-message .alert').addClass('hidden');var datePlaceholders='<div class="col-sm-12 text-center p-b-15">'+'<button class="btn btn-primary p-5 btn-xs wdt-date-placeholder wdt-today-placeholder" data-toggle="tooltip" data-placement="top" title="By settings %TODAY% placeholder, cell value will be compared with today\'s date.">%TODAY%</button> '+'<button class="btn btn-primary p-5 btn-xs wdt-date-placeholder wdt-last-week-placeholder" data-toggle="tooltip" data-placement="top" title="By settings %LAST_WEEK% placeholder, cell value will be compared with last week\'s date.">%LAST_WEEK%</button> '+'<button class="btn btn-primary p-5 btn-xs wdt-date-placeholder wdt-this-week-placeholder" data-toggle="tooltip" data-placement="top" title="By settings %THIS_WEEK% placeholder, cell value will be compared with this week\'s date.">%THIS_WEEK%</button> '+'<button class="btn btn-primary p-5 btn-xs wdt-date-placeholder wdt-next-week-placeholder" data-toggle="tooltip" data-placement="top" title="By settings %NEXT_WEEK% placeholder, cell value will be compared with next week\'s date.">%NEXT_WEEK%</button> '+'<button class="btn btn-primary p-5 btn-xs wdt-date-placeholder wdt-last-30-days-placeholder" data-toggle="tooltip" data-placement="top" title="By settings %LAST_30_DAYS% placeholder, cell value will be compared with last 30 days.">%LAST_30_DAYS%</button> '+'<button class="btn btn-primary p-5 btn-xs wdt-date-placeholder wdt-last-month-placeholder" data-toggle="tooltip" data-placement="top" title="By settings %LAST_MONTH% placeholder, cell value will be compared with last month.">%LAST_MONTH%</button> '+'<button class="btn btn-primary p-5 btn-xs wdt-date-placeholder wdt-this-month-placeholder" data-toggle="tooltip" data-placement="top" title="By settings %THIS_MONTH% placeholder, cell value will be compared with this month.">%THIS_MONTH%</button> '+'<button class="btn btn-primary p-5 btn-xs wdt-date-placeholder wdt-next-month-placeholder" data-toggle="tooltip" data-placement="top" title="By settings %NEXT_MONTH% placeholder, cell value will be compared with next month.">%NEXT_MONTH%</button> '+'</div>';jQuery('.datepicker').closest("ul.list-unstyled").append(datePlaceholders);if(typeof jQuery.fn.wdtBootstrapTooltip!=='undefined'){jQuery('.wdt-date-placeholder').wdtBootstrapTooltip()}
39jQuery('.wdt-today-placeholder').click(function(){jQuery(this).closest('.form-group').find('.formatting-rule-cell-value').val('%TODAY%').data("DateTimePicker").hide()})
40jQuery('.wdt-last-week-placeholder').click(function(){jQuery(this).closest('.form-group').find('.formatting-rule-cell-value').val('%LAST_WEEK%').data("DateTimePicker").hide();jQuery('.wpdt-conditional-message .alert').removeClass('hidden')})
41jQuery('.wdt-this-week-placeholder').click(function(){jQuery(this).closest('.form-group').find('.formatting-rule-cell-value').val('%THIS_WEEK%').data("DateTimePicker").hide();jQuery('.wpdt-conditional-message .alert').removeClass('hidden')})
42jQuery('.wdt-next-week-placeholder').click(function(){jQuery(this).closest('.form-group').find('.formatting-rule-cell-value').val('%NEXT_WEEK%').data("DateTimePicker").hide();jQuery('.wpdt-conditional-message .alert').removeClass('hidden')})
43jQuery('.wdt-last-30-days-placeholder').click(function(){jQuery(this).closest('.form-group').find('.formatting-rule-cell-value').val('%LAST_30_DAYS%').data("DateTimePicker").hide();jQuery('.wpdt-conditional-message .alert').removeClass('hidden')})
44jQuery('.wdt-last-month-placeholder').click(function(){jQuery(this).closest('.form-group').find('.formatting-rule-cell-value').val('%LAST_MONTH%').data("DateTimePicker").hide();jQuery('.wpdt-conditional-message .alert').removeClass('hidden')})
45jQuery('.wdt-this-month-placeholder').click(function(){jQuery(this).closest('.form-group').find('.formatting-rule-cell-value').val('%THIS_MONTH%').data("DateTimePicker").hide();jQuery('.wpdt-conditional-message .alert').removeClass('hidden')});jQuery('.wdt-next-month-placeholder').click(function(){jQuery(this).closest('.form-group').find('.formatting-rule-cell-value').val('%NEXT_MONTH%').data("DateTimePicker").hide();jQuery('.wpdt-conditional-message .alert').removeClass('hidden')})
46jQuery('.formatting-rule-cell-value.wdt-datepicker').on('dp.hide',function(e){e.stopImmediatePropagation();if(jQuery.inArray(jQuery(this).closest('.wdt-conditional-formatting-rule').find('.formatting-rule-cell-value').val(),['%LAST_WEEK%','%THIS_WEEK%','%NEXT_WEEK%','%LAST_30_DAYS%','%LAST_MONTH%','%NEXT_MONTH%','%THIS_MONTH%'])===-1){jQuery(this).closest('.wdt-conditional-formatting-rule').find('.formatting-rule-if-clause').prop('disabled',!1).selectpicker('val','lt')}else{jQuery(this).closest('.wdt-conditional-formatting-rule').find('.formatting-rule-if-clause').prop('disabled',!0).selectpicker('val','')}});jQuery('.formatting-rule-cell-value.wdt-datetimepicker').on('dp.hide',function(e){e.stopImmediatePropagation();if(jQuery.inArray(jQuery(this).closest('.wdt-conditional-formatting-rule').find('.formatting-rule-cell-value').val(),['%LAST_WEEK%','%THIS_WEEK%','%NEXT_WEEK%','%LAST_30_DAYS%','%LAST_MONTH%','%NEXT_MONTH%','%THIS_MONTH%'])===-1){jQuery(this).closest('.wdt-conditional-formatting-rule').find('.formatting-rule-if-clause').prop('disabled',!1).selectpicker('val','lt')}else{jQuery(this).closest('.wdt-conditional-formatting-rule').find('.formatting-rule-if-clause').prop('disabled',!0).selectpicker('val','')}})}}
47function showDateTimePickerForFixedHeaderAndColumns(dateData,filterElem,timePicker){var topPos='auto',leftPos='auto',bottomPos='auto',rightPos='auto';var leftOffset=50;var leftOffset2=100;if(dateData.closest('.wdtscroll').length&&dateData.parents('table').length!=0){if(dateData.parents('table').hasClass('fixedHeader-floating')){jQuery('.dtfh-floatingparenthead').css('height',dateData.parents('table')[1].offsetHeight);dateData.closest('th').css('z-index',5)}
48if(filterElem=='th'){if(dateData.parents('table').hasClass('fixedHeader-floating')&&(dateData.closest(filterElem).hasClass('dtfc-fixed-left')||dateData.closest(filterElem).hasClass('dtfc-fixed-right'))){if(timePicker){leftOffset=20;leftOffset2=55}
49leftPos=dateData.closest('th').hasClass('dtfc-fixed-left')?dateData.offset().left-dateData.closest('.wdtscroll').offset().left-parseInt(dateData.closest('th').css('padding-left'),10)+dateData.closest('.wdtscroll').scrollLeft()+'px':dateData.closest('th').nextAll().length!=0?dateData.offset().left-dateData.closest('.wdtscroll').offset().left-parseInt(dateData.closest('th').css('padding-left'),10)+dateData.closest('.wdtscroll').scrollLeft()-leftOffset+'px':dateData.offset().left-dateData.closest('.wdtscroll').offset().left-parseInt(dateData.closest('th').css('padding-left'),10)+dateData.closest('.wdtscroll').scrollLeft()-leftOffset2+'px'
50topPos=dateData.closest('th').height()-dateData.height()+parseInt(dateData.closest('th').css('padding-top'),10)+'px'
51dateData.closest('th').css('position','');dateData.closest('th').css('z-index',5)}else if(dateData.closest('th').hasClass('dtfc-fixed-left')||dateData.closest('th').hasClass('dtfc-fixed-right')){leftPos=dateData.offset().left-dateData.closest('.wdtscroll').offset().left-parseInt(dateData.closest('th').css('padding-left'),10)+'px'
52topPos=dateData.closest('th').height()+dateData.height()+parseInt(dateData.closest('th').css('padding-top'),10)+'px'
53dateData.closest('th').css('position','');dateData.closest('th').css('z-index',5)}else{leftPos=!dateData.parents('table').hasClass('fixedHeader-floating')?dateData.offset().left-dateData.closest('.wdtscroll').offset().left+'px':dateData.closest('th').nextAll().length!=0?'auto':dateData.offset().left-dateData.closest('.wdtscroll').offset().left-parseInt(dateData.closest('th').css('padding-left'),10)+dateData.closest('.wdtscroll').scrollLeft()-leftOffset2+'px'}}else if(filterElem=='td'){if(dateData.closest('td').hasClass('dtfc-fixed-left')){if(timePicker){leftPos=dateData.closest('td').prevAll().length<=1?0+'px':dateData.offset().left-dateData.closest('.wdtscroll').offset().left-20+'px'}else{leftPos=dateData.offset().left-dateData.closest('.wdtscroll').offset().left-parseInt(dateData.closest('td').css('padding-left'),10)+'px'}
54bottomPos=0+'px'
55dateData.closest('td').css('position','');dateData.closest('td').css('z-index',5)}else if(dateData.closest('td').hasClass('dtfc-fixed-right')){if(timePicker){leftPos=dateData.closest('td').prevAll().length<=1?0+'px':dateData.offset().left-dateData.closest('.wdtscroll').offset().left-20+'px'}else{rightPos=dateData.closest('td').nextAll().length<=1?5+'px':dateData.closest('.wdtscroll').offset().left+'px'}

56bottomPos=parseInt(jQuery(".bootstrap-datetimepicker-widget").css('bottom'),10)-dateData.height()+'px'
57dateData.closest('td').css('position','');dateData.closest('td').css('z-index',5)}else{leftPos=dateData.offset().left-dateData.closest('.wdtscroll').offset().left+'px';bottomPos='auto'}}else{leftPos=dateData.offset().left-dateData.closest('.wdtscroll').offset().left+'px';topPos='auto'
58bottomPos='auto';rightPos='auto'}
59jQuery(".bootstrap-datetimepicker-widget").css('inset',topPos+' '+rightPos+' '+bottomPos+' '+leftPos)}else{jQuery(".bootstrap-datetimepicker-widget").css('inset',topPos+' '+rightPos+' '+bottomPos+' '+leftPos);jQuery('.dtfh-floatingparenthead').css('overflow','visible')}}
60function hidePickerForFixedHeaderAndColumns(dateData){if(dateData.parents('table').hasClass('fixedHeader-floating')){jQuery('.dtfh-floatingparenthead').css({"height":"max-content"});dateData.closest('th').css('z-index',4)}
61if(dateData.closest('th').hasClass('dtfc-fixed-left')||dateData.closest('th').hasClass('dtfc-fixed-right')){dateData.closest('th').css('position','sticky');dateData.closest('th').css('z-index',4)}
62if(dateData.closest('td').hasClass('dtfc-fixed-left')||dateData.closest('td').hasClass('dtfc-fixed-right')){dateData.closest('td').css('position','sticky');dateData.closest('td').css('z-index',4)}}
63function getMomentWdtDateFormat(){return wpdatatables_settings.wdtDateFormat.replace(/[DdMmYyFj]/g,function(match){switch(match){case 'D':return'ddd';case 'd':return'DD';case 'M':return'MMM';case 'm':return'MM';case 'Y':return'Y';case 'y':return'YY';case 'F':return'MMMM';case 'j':return'DD';default:return match}})}
64function getMomentWdtTimeFormat(){return wpdatatables_settings.wdtTimeFormat.replace('H','HH').replace('i','mm')}
65function searchQueryString(key){key=key.replace(/[*+?^$.\[\]{}()|\\\/]/g,"\\$&");var match=location.search.match(new RegExp("[?&]"+key+"=([^&]+)(&|$)"));return match&&decodeURIComponent(match[1].replace(/\+/g," "))}
66function removeURLParameter(url,parameter){let urlParts=url.split('?')
67if(urlParts.length>=2){let prefix=encodeURIComponent(parameter)+'='
68let pars=urlParts[1].split(/[&;]/g)
69for(let i=pars.length;i-->0;){if(pars[i].lastIndexOf(prefix,0)!==-1){pars.splice(i,1)}}
70url=urlParts[0]+(pars.length>0?'?'+pars.join('&'):'')
71return url}else{return url}}
72function getAllUrlParams(url){var queryString=url?url.split('?')[1]:window.location.search.slice(1);var params={};if(queryString){var pairs=queryString.split('&');for(var i=0;i<pairs.length;i++){var pair=pairs[i].split('=');var key=decodeURIComponent(pair[0]);var value=decodeURIComponent(pair[1]||'');if(params[key]){if(Array.isArray(params[key])){params[key].push(value)}else{params[key]=[params[key],value]}}else{params[key]=value}}}
73return params}
74function createAceEditor(selector){if(jQuery('#'+selector).length){var aceEditorGlobal;var aceEditorFunc=function(e){if(aceEditorGlobal.getValue().length>0){if(selector=='wdt-custom-css'){wpdatatable_plugin_config.setCustomCss(aceEditorGlobal.getValue())}else if(selector=='wdt-custom-js'){wpdatatable_plugin_config.setCustomJs(aceEditorGlobal.getValue())}else if(selector=='wdt-table-custom-css'){wpdatatable_config.setTableCustomCss(aceEditorGlobal.getValue())}else if(selector=='wdt-mysql-query'){wpdatatable_config.setContent(aceEditorGlobal.getValue())}}else{if(selector=='wdt-custom-css'){wpdatatable_plugin_config.setCustomCss('')}else if(selector=='wdt-custom-js'){wpdatatable_plugin_config.setCustomJs('')}else if(selector=='wdt-table-custom-css'){wpdatatable_config.setTableCustomCss('')}else if(selector=='wdt-mysql-query'){wpdatatable_config.setContent('')}}};aceEditorGlobal=ace.edit(selector);aceEditorGlobal.$blockScrolling=Infinity;if(selector=='wdt-custom-css'||selector=='wdt-table-custom-css'){aceEditorGlobal.getSession().setMode("ace/mode/css");aceEditorGlobal.setTheme("ace/theme/monokai")}else if(selector=='wdt-custom-js'){aceEditorGlobal.getSession().setMode("ace/mode/javascript");aceEditorGlobal.setTheme("ace/theme/monokai")}else if(selector=='wdt-mysql-query'){aceEditorGlobal.getSession().setMode("ace/mode/sql");aceEditorGlobal.setTheme("ace/theme/idle_fingers")}
75aceEditorGlobal.on('change',_.throttle(aceEditorFunc,3000));aceEditorGlobal.on('blur',aceEditorFunc)}

76if(typeof aceEditorGlobal!=='undefined'){setTimeout(aceEditorGlobal.on("input",function(){var stringData;var shouldShow=!aceEditorGlobal.session.getValue().length;var node=aceEditorGlobal.renderer.emptyMessageNode;switch(selector){case 'wdt-custom-js':stringData='JS';break;case 'wdt-custom-css':stringData='CSS';break;case 'wdt-table-custom-css':stringData='table CSS. \n * \n *  You can use selector only for this table like \n * \n *  table.wpDataTable.wpDataTableID-'+wpdatatable_config.id+' { \n *    //Your custom code  \n *  }';break;case 'wdt-mysql-query':stringData='SQL query';break}
77if(!shouldShow&&node){aceEditorGlobal.renderer.scroller.removeChild(aceEditorGlobal.renderer.emptyMessageNode);aceEditorGlobal.renderer.emptyMessageNode=null}else if(shouldShow&&!node){node=aceEditorGlobal.renderer.emptyMessageNode=document.createElement("div");node.textContent="/** \n *  Here you can insert custom "+stringData+" \n */"
78node.className="ace_emptyMessage"
79node.style.padding="0 9px"
80node.style.position="absolute"
81node.style.zIndex=9
82node.style.opacity=0.5
83aceEditorGlobal.renderer.scroller.appendChild(node)}}),100)}}
84function typeNameInDatabaseForSelectedType(possibleValueInput){let type;switch(possibleValueInput){case 'input':case 'hidden':type='VARCHAR';break;case 'memo':type='TEXT';if((typeof constructedTableData!=='undefined'&&constructedTableData.connection_type=='mssql')||(jQuery('#w

84dt-table-connection').length&&jQuery('#wdt-table-connection').data('vendor')=='mssql')){type='VARCHAR'}
85break;case 'select':case 'multiselect':case 'link':case 'image':case 'email':case 'file':type='VARCHAR';break;case 'int':type='INT';break;case 'float':type='DECIMAL';break;case 'date':type='DATE';break;case 'datetime':type='DATETIME';break;case 'time':type='TIME';break;default:type='VARCHAR';break}
86return type}
87function typeValueInDBFromTypeInDB(typeValue){let type;switch(typeValue){case 'VARCHAR':type='255';break;case 'DECIMAL':type='16,4';break;case 'SMALLINT':case 'TINYINT':type='1';break;case 'MEDIUMINT':case 'BIGINT':case 'INT':type='11';break;case 'DATE':typeValue='';break;case 'DATETIME':typeValue='';break;case 'TIME':typeValue='';break;default:type='';break}
88return type}
89function typeValueInDBFromWpcolumnType(possibleValueInput){let typeValue;switch(possibleValueInput){case 'input':case 'hidden':typeValue='255';break;case 'memo':typeValue='';if((typeof constructedTableData!=='undefined'&&constructedTableData.connection_type=='mssql')||(jQuery('#w

89dt-table-connection').length&&jQuery('#wdt-table-connection').data('vendor')=='mssql')){typeValue='8000'}
90break;case 'select':case 'multiselect':case 'link':case 'image':case 'email':case 'file':typeValue='2000';break;case 'int':typeValue='11';break;case 'float':typeValue='16,4';break;case 'date':typeValue='';break;case 'datetime':typeValue='';break;case 'time':typeValue='';break;default:typeValue='';break}
91return typeValue}