/** 前端搜尋時間 */
$.fn.dataTable.ext.search.push(
    function(settings, data, dataIndex) {
        let index = MAIN_TABLE.column("reportTime:name").index();
        let from = $("#sf-reportTime-min").val();
        let to = $("#sf-reportTime-max").val()
        if (from == "" && to == "") return true;
        var min = dayjs(from).unix();
        var max = dayjs(to).unix();
        var date = dayjs(data[index]).unix();
        if (!(Number.isNaN(min) && Number.isNaN(max)) && min <= date && max >= date) {
            return true;
        }
        if (min <= date && Number.isNaN(max)) return true;
        if (max >= date && Number.isNaN(min)) return true;
        return false;
    }
);
/** 前端搜尋 */
function frontEndSearch() {
    let imei = $("#sf-imei").val();
    if (imei) {
        //console.log("imei="+imei)
        MAIN_TABLE.column("imei:name").search(imei);
    }
    let projectName = $("#sf-hostId>option:selected").text();
    if (projectName && $("#sf-hostId").val()) {
        //console.log("projectName="+projectName)
        MAIN_TABLE.column("projectCode:name").search(projectName);
    }
    let groupName = $("#sf-groupName").val();
    if (groupName) {
        //console.log("groupName="+groupName)
        MAIN_TABLE.column("groupPath:name").search(groupName);
    }
    MAIN_TABLE.draw()
}

/** 前端搜尋還原 */
function frontEndClear() {
    $("[id^=sf-]").each(function() {
        this.value = '';
        this.checked = false;
    });
    MAIN_TABLE.search('').columns().search('').draw();
}

/** 使前端排序null與空白 last */
$.extend( $.fn.dataTable.ext.type.order, { 
	'date-pre' : function ( d ) {
	    return Date.parse( d ) || Infinity;
	},
	'string-pre' : function ( d ) {
	    return (!d||d=="")?"ZZZ":d;
	},
	"num" : function ( d ) {
	    return (!d||isNaN(d))?Infinity:d;
	},
	
});

let list = MAIN_TABLE.rows().data().toArray();