function is_scrollTop(communicationCenter) {
    // 滚动到容器底部
    communicationCenter.scrollTop = communicationCenter.scrollHeight;
}
// (空状态)查询区域加载 
function isEmpty(data, tableId) {
    console.log(data);
    if (data.rows.length <= 0) {
        let pager = tableId.datagrid('getPanel').find('.datagrid-view2 .datagrid-body');
        // console.log(pager);
        // 创建一个 img 元素
        var imgElement = $('<img>');
        // 应用 CSS 样式
        imgElement.css({
            position: 'absolute',
            top: '50%',
            left: '50%',
            transform: 'translate(-50%,-50%)',  // 注意修正此处的语法错误
            // 其他样式可以根据需要添加
        });
        // 设置 img 元素的属性
        let route = '/public/img/EmptyBlue.png'
        imgElement.attr('src', route);  // 设置图片的路径
        // 将 img 元素添加到 pager 元素中
        pager.append(imgElement);
    }
}
// 查询区域加载(遮罩层01)
/**
 * 
 * @param {*隐藏和显示block,none} data 
 * @param {*tableId的Id动态的生成} tableId 
 * @param {*主要在FindData、筛选条件(回车事件)中使用延迟加载}
 */
function HiddenDisplay(data, tableId) {
    let id = 'mask' + tableId[0].id.toString() //动态查找table下的遮罩层
    var div = document.querySelector('#' + id)
    if (div != null) {
        if (data == 'block') {
            return div.style.display = 'flex'
        } else if (data == 'none') {
            return div.style.display = 'none'
        }
    } else {
        return
    }
}

// 遮罩层html(放置ShowDbGrid函数中初始化遮罩层元素，(遮罩层01)
/**
 * @param {*table的ID,使每个table的下面动态的生成ID} tableId 
 */
function MaskLayer(tableId) {
    //设定动画
    var style = document.createElement("style");
    style.innerHTML = `
            @keyframes spin {
                0% {
                    transform: rotate(0deg);
                }
                100% {
                    transform: rotate(360deg);
                }
            }
        `;
    document.head.appendChild(style);
    //jquery


    let id = 'mask' + tableId[0].id.toString()    //动态生成遮罩层id（通过mask+table的id生成）
    // 
    // 创建遮罩层和加载动画的div元素
    var mask = $("<div>").addClass("mask").attr("id", id)
        .css({
            position: "fixed",
            top: 0,
            left: 0,
            width: "100%",
            height: "100%",
            // marginTop: "5.7%",
            display: "flex", // 设置为 flex 布局
            justifyContent: "center", // 水平居中
            alignItems: "center", // 垂直居中
            backgroundColor: "rgba(0, 0, 0, 0.38)",
            display: "none"
        });
    // 创建加载动画元素
    var spinner = $("<div>").addClass("loading-spinner")
        .css({
            width: "40px",
            height: "40px",
            border: "4px solid #f3f3f3",
            borderTop: "4px solid #3498db",
            borderRadius: "50%",
            animation: "spin 1s linear infinite"
        });
    // 将加载动画元素添加到遮罩层中
    mask.append(spinner);
    // 
    // 在目标元素后面添加遮罩层
    tableId.after(mask);
}


//过滤条件组件
/**
 * @param {下拉框table中表头中的筛选的信息}datagridTitle
 * @param {ShowDbGrid中filterId里的属性parent:table所设置的toolbar名称和下面div所包裹的id}Newid
 * @param {ShowDbGrid中filterId里的属性filterFalse设置是否显示过滤框}filterFalse
 */
function filterNew(datagridTitle, id, Newid, filterFalse, btnFalse) {
    // 
    // 
    if (filterFalse == undefined) { //判断之前控件中没有加入到这个属性，或者忘记添加而添加的属性（已使用到属性则不影响）
        filterFalse = true
    }
    // 
    if (!$('#div' + Newid).length > 0) {


        // var existingFilter = $("#" + Newid);
        // if (existingFilter.length > 0) {
        //     // 如果过滤器已存在，先移除旧元素
        //     existingFilter.remove();
        // }
        var relationdatas1 = [
            // { value: '0', text: '请选择', selected: true, },
            { value: '1', text: '包含', },
            { value: '2', text: '等于' },
            { value: '3', text: '不等于' },
            { value: '4', text: '大于' },
            { value: '5', text: '小于' },
        ]
        var filteDiv = $("<div>");
        filteDiv.css({
            width: "100%",
            display: filterFalse ? 'block' : 'none'
        })
        filteDiv.attr("id", "div" + Newid)  //必须创建id（解析和渲染DOM使用）
        //字段框（数根据表头的字段获取来判断）
        var dept = $("<input>").addClass("easyui-combobox")
            .css({
                width: "15%",
                // height: "30px",
            })
        dept.attr("name", "dept")
        dept.attr("id", "cc" + Newid);
        dept.attr("data-options", "valueField:'field', textField:'value',editable:false"); //每次初始化都会对应这table表头的信息
        //条件框 （根据字段框具体要筛选什么数据）
        var dept1 = $("<input>")
        dept1.addClass("easyui-combobox")
        dept1.css({
            width: "15%",
            // height: "30px",
        })
        dept1.attr("name", "dept" + Newid)
        dept1.attr("id", "dd" + Newid);
        // dept1.attr("labelWidth","20%")
        dept1.attr("data-options", "valueField:'value', textField:'text',editable:false"); //每次初始化都会对应这table表头的信息
        // <input id="MES_FilterInput" class="easyui-textbox" type="text" style="width:100px;">
        var dept2 = $("<input>") //输入框回车事件
        dept2.addClass("easyui-textbox")
        dept2.attr("id", "qq" + Newid)

        dept2.css({
            width: "15%",
            marginLeft: "1%"
        })
        dept2.attr("type", "text")

        var dept4 = $("<label>")
        dept4.attr("id", "pp" + Newid)
        dept4.css({
            // fontSize: "10%",
            lineHeight: "5%",
            color: $.cookie('themId') == 1 ? "#fff3f3" : "#000000",
            marginLeft: "1%"
        })
        dept4.html('检索: ')
        var dept5 = $("<input>") //键盘按下抬起触发当前页面筛选过滤框
        dept5.addClass("easyui-textbox")
        dept5.attr("id", "ss" + Newid)
        dept5.css({
            // height:"",
            width: "20%",
            marginLeft: "1%"
        })
        dept5.attr("type", "text")
        // filteDiv.append(mask);
        filteDiv.append(dept);
        filteDiv.append(dept1);
        filteDiv.append(dept2);
        // filteDiv.append(dept3);
        if (btnFalse == undefined || btnFalse) {
            filteDiv.append(dept4);
            filteDiv.append(dept5);
        }

        $("#" + Newid).append(filteDiv);  // 判断动态生成id根据每个不同的table而 （获取table标签后面的标签（平级））
        $.parser.parse("#div" + Newid); //解析某个具体节点，上面则编写或增加需要的DOM，则重新渲染DOM，而要操作DOM则在后面进行操作 （注:全部的控件所被所包裹的父元素指定不同的动态id，否则会导致动态创建过滤器的函数被多次调用会一些不生效的事件）
        $('#cc' + Newid).combobox('loadData', datagridTitle)
        $('#cc' + Newid).combobox('setValue', datagridTitle[0])
        $('#dd' + Newid).combobox('loadData', relationdatas1)
        $('#dd' + Newid).combobox('setValue', relationdatas1[0])

    }
}


//过滤条件
/**
 * @param {每个table下div中唯一的id}Newid
 * 
 * **/
function filterWindos(Newid) {
    if (!$('#myWindow' + Newid).length > 0) {
        var container = $("<div></div>").attr("id", "myWindow" + Newid);
        $("body").append(container); //使用动态生成窗口，确保窗口容器元素已经存在于 DOM 中
        // 初始化 Window 窗口
        $("#myWindow" + Newid).window({
            width: '30%',
            height: '45%',
            padding: '10px',
            color: '#cccccc',
            title: '条件过滤',
            draggable: true,
            resizable: true,
            closed: true,
            inline: true,
            collapsible: true,
            minimizable: false,
            maximizable: false,
            modal: true
            // 其他属性和事件...
        });
        let filteTable = $("<table>") //数据表
        filteTable.attr("id", "filtertt" + Newid)
        filteTable.css({
            width: "100%"
        })
        let filteSo = $("<div>") //功能父元素
        filteSo.attr("id", "diltertb" + Newid)
        filteSo.css({
            height: 'auto',
            float: 'right'
        })
        container.append(filteTable)
        container.append(filteSo)
        //添加
        let filteSo_add = $("<a>").addClass("easyui-linkbutton").addClass("filterAdd").html('添加')
        filteSo_add.attr("id", "filterAdd" + Newid)
        filteSo_add.attr("data-options", "iconCls:'icon iconfont icon-tianjia',plain:'true'")
        filteSo_add.href = "javascript:void(0)"
        //重置
        let filteSo_reset = $("<a>").addClass("easyui-linkbutton").addClass("filterReset").html('重置')
        filteSo_reset.attr("id", "filterReset" + Newid)
        filteSo_reset.attr("data-options", "iconCls:'icon iconfont icon-shuaxin',plain:'true'")
        filteSo_reset.href = "javascript:void(0)"
        //查询
        let filteSo_save = $("<a>").addClass("easyui-linkbutton").addClass("filterSave").html('查询')
        filteSo_save.attr("id", "filterSave" + Newid)
        filteSo_save.attr("data-options", "iconCls:'icon iconfont icon-baocun1',plain:'true'")
        filteSo_save.href = "javascript:void(0)"
        //退出
        let filteSo_exit = $("<a>").addClass("easyui-linkbutton").addClass("filterExit").html('退出')
        filteSo_exit.attr("id", "filterExit" + Newid)
        filteSo_exit.attr("data-options", "iconCls:'icon iconfont icon-guanji',plain:'true'")
        filteSo_exit.href = "javascript:void(0)"

        filteSo.append(filteSo_add)
        filteSo.append(filteSo_reset)
        filteSo.append(filteSo_save)
        filteSo.append(filteSo_exit)
        $.parser.parse("#diltertb" + Newid)
        $.parser.parse("#filtertt" + Newid)
        // $.parser.parse('#myWindow')
    }

}



//李 使用中 查询数据
/**
 * 
 * @param {*数据表名} AttributeName 
 * @param {*自定义查询条件} dataFilter 
 * @param {*当前页码} currentPageNum 
 * @param {*当前页码记录数} pageSize 
 * @param {*外部查询条件} otherDatas 
 * @param {*数据查询顺序} asc 
 * @returns 返回查询数据结果
 */
function NewfuzzyQueryFilters(AttributeName, dataFilter, currentPageNum, pageSize, otherDatas, asc) {

    try {
        if (asc == undefined || asc == '')
            asc = 'IKEY asc'
        let data = { orderby: asc, rows: [] };
        if (otherDatas != undefined) {
            for (let i = 0; i < otherDatas.rows.length; i++) {
                let obj = otherDatas.rows[i][AttributeName]

                let keys = Object.keys(obj)
                let contains_IN = false;
                for (var j = 0; j < keys.length; j++) {

                    if (keys[j].includes("_IN")) {
                        contains_IN = true;
                        break;
                    }
                }
                if (contains_IN) { //判断条件语句中是否包含带有IN语句放置最前面
                    data.rows.unshift(otherDatas.rows[i]); //IN放置最前

                } else {
                    data.rows.push(otherDatas.rows[i]);

                }
                // data.rows.push(otherDatas.rows[i]);
            }
        }
        if (dataFilter != undefined) {
            for (var l = 0; l < dataFilter.length; l++) {
                let trFilter = {};
                trFilter[AttributeName] = dataFilter[l];
                data.rows.push(trFilter)
            }
        }
        if (otherDatas == undefined && dataFilter == undefined || data.rows.length <= 0) {
            let ds = {};
            ds[AttributeName] = {};
            data.rows.push(ds);
        }

        if (isNaN(pageSize))
            pageSize = 200;
        if (isNaN(currentPageNum) || currentPageNum == 0)
            currentPageNum = 1;     
        // 
        const dbdatas = GetPages(data, currentPageNum, pageSize);
        return dbdatas
    } catch (error) {
        // return HiddenDisplay('none','table_iteminformation')
    }
}
//李 使用中 自定义条件
/**
 * 
 * @param {*自定义查询条件的dbgrid数据} getRows 
 * @returns 返回自定交查询条件
 */
function NewfiltersDataPack(getRows) {
    var Allfilter = [];
    for (let i = 0; i < getRows.length; i++) {
        const f_like = getRows[i].columnName + "_LIKE";
        let filterValue = getRows[i].filterValue;
        if (getRows[i].status != undefined) {
            for (obj in getRows[i].status) {
                if (getRows[i].status[obj] == filterValue) {
                    filterValue = obj;
                    break;
                }
            }
        }
        switch (getRows[i].relation) {
            case ("1"): //包含
                var filterDatas = {};
                filterDatas[getRows[i].columnName] = "%" + filterValue + "%";
                filterDatas[f_like] = ' like ';
                Allfilter.push(filterDatas);
                break;
            case ("2"):
                var filterDatas = {};
                filterDatas[getRows[i].columnName] = filterValue;
                Allfilter.push(filterDatas);
                break;
            case ("3"):
                var filterDatas = {};
                filterDatas[getRows[i].columnName] = filterValue;
                filterDatas[f_like] = ' <> ';
                Allfilter.push(filterDatas);
                break;
            case ("4"):
                var filterDatas = {};
                filterDatas[getRows[i].columnName] = filterValue;
                filterDatas[f_like] = ' > ';
                Allfilter.push(filterDatas);
                break;
            case ("5"):
                var filterDatas = {};
                filterDatas[getRows[i].columnName] = filterValue;
                filterDatas[f_like] = ' < ';
                Allfilter.push(filterDatas);
                break;
        }
    }
    return Allfilter;
}


/**
 * 只用于产品追踪的查询功能
 * @param {*} oldfdlist //
 * @param {*} oldotherDatas 
 */
var barcodeikey = "";

function ShowDbGrid(tableId, filterId, showdbgridDatas, otherData, orderby) {
    MaskLayer(tableId)
    //console.log(filterId.pageIndex);
    var PageList = [10, 200, 500, 1000, 1500, 2000];
    var pageSize
    if (filterId.pageIndex == undefined) {
        pageSize = PageList[3];
    } else {
        pageSize = PageList[filterId.pageIndex];
    }

    var currentPageNum = 1;
    var datagridTitle;
    var f, f2, f3, tableName = filterId.tableName,
        id = filterId.id;
    var otherDatas = {};
    var oldfdlist,
        oldotherDatas = {};
    var datalist = new Array();
    otherDatas = otherData;
    datagridTitle = loadDatagridTitle(tableId, id);

    filterNew(datagridTitle, id, filterId.parent, filterId.filterFalse, filterId.filterBtn) //   

    filterWindos(filterId.parent)
    function loadDatagridTitle(tableId, id) {
        let lans = $.cookie("language");
        //获取表格标题
        var datagridTitle = new Array();
        var fields = tableId.datagrid('getColumnFields');
        var titles = '';
        var isSum = false;
        var dtfield = [];
        tableId.datagrid('options').remoteSort = false;
        for (var i = 0; i < fields.length; i++) {
            // 
            var option = tableId.datagrid('getColumnOption', fields[i]);
            // 
            if (option.hasOwnProperty('sum') && option.sum == true) {
                isSum = true;
                dtfield.push(option.field);
            }
            option.sortable = true;
            if (option.dataType == 'Number' || option.dataType == 'float') {
                option.sorter = function (a, b) {
                    return parseFloat(a) > parseFloat(b) ? 1 : -1;
                };
            }
            titles = '';
            var obj = document.getElementById(option.id);
            // 
            if (obj != null && obj != undefined) {
                titles = obj.innerText;
            } else {
                titles = option.title;
            }
            option.title = titles;
            // 
            if (option.field != "checkItem" && option.hidden != true && option.isFilter == true) //过滤勾选框和隐藏列
            {
                datagridTitle.push({ field: option.field, value: titles, status: option.isStatus });
            }
        }

        tableId.datagrid({
            onLoadSuccess: function (data) {
                // tableId.datagrid('loading');
                if (isSum) {
                    // 
                    if (tableId.datagrid('options').isSum == false) {
                        footers = {};
                        let ALl_QTY = 0
                        for (let d = 0; d < dtfield.length; ++d) {
                            footers[dtfield[d]] = 0;
                        }
                        for (let i = 0; i < data.rows.length; ++i) {
                            for (let d = 0; d < dtfield.length; ++d) {
                                // //console.log(data.rows[i]);
                                footers[dtfield[d]] += (parseFloat(data.rows[i][dtfield[d]]));
                                if (dtfield[d] == 'ALL_PRICE') {
                                    // //console.log(data.rows[i][dtfield[d]]);
                                    // //console.log(footers[dtfield[d]]);
                                    // //console.log((parseFloat(data.rows[i]['QTY']) * parseFloat(data.rows[i]['PRICE'])).toFixed(2)); 
                                    ALl_QTY += parseFloat((parseFloat(data.rows[i]['QTY']) * parseFloat(data.rows[i]['PRICE'])).toFixed(2))

                                    // //console.log(((data.rows[i][QTY] * data.rows[i][PRICE]).toFixed(2)));
                                    // footers[dtfield[d]] += ((data.rows[i][QTY] * data.rows[i][PRICE]).toFixed(2));   
                                }
                                // //console.log(data.rows[i]);
                            }
                        }
                        // //console.log(ALl_QTY.toFixed(2));
                        // //console.log(footers);
                        footers.PURCHASE_ORDER = ''
                        footers.CONTRACT_FILE_NAME = ''
                        footers.PAYMENT_FILE_NAME = ''
                        footers.ALL_PRICE = ALl_QTY.toFixed(2)
                        tableId.datagrid('reloadFooter', [footers]);
                        tableId.datagrid('options').isSum = true;
                    }
                    // 

                    // let isBe = false;
                    // let mIndex = -1;
                    // let insertRow = { isSum: true };
                    // for (let d = 0; d < dtfield.length; ++d)
                    //     insertRow[dtfield[d]] = 0;
                    // for (let i = 0; i < data.rows.length; ++i) {
                    //     if (data.rows[i].hasOwnProperty('isSum') && data.rows[i]['isSum']) { isBe = true; mIndex = i; break; }
                    //     for (let d = 0; d < dtfield.length; ++d) {
                    //         if (insertRow.hasOwnProperty(dtfield[d]))
                    //             insertRow[dtfield[d]] += parseFloat(data.rows[i][dtfield[d]]);
                    //         else
                    //             insertRow[dtfield[d]] = parseFloat(data.rows[i][dtfield[d]]);
                    //     }
                    // }
                    // if (data.rows.length > 0 && !isBe) {
                    //     tableId.datagrid('insertRow', { index: data.rows.length, row: insertRow });
                    //     tableId.datagrid('freezeRow', data.rows.length - 1);//insertRow
                    //     
                    // }
                    // else if (isBe)
                    //     tableId.datagrid('freezeRow', mIndex);
                }
                // tableId.datagrid('loaded');
                // 
            },
        })
        lans='chs'
        console.log(lans,filterId.isshowexport)
        if(filterId.isshowexport){
            tableId.datagrid('getPager').pagination({
                pageList: PageList,
                pageSize: pageSize,
                buttons: [{
                    // iconCls: 'icon iconfont icon-daochu', id: 'curExport',
                    text: lans == 'chs' ? '当页导出' : (lans == 'cht' ? '當頁匯出' : 'Current page export'),
                    handler: function () { //当页导出
                        console.log(filterId);
                        let f = $('#cc' + filterId.parent).combobox('getValue')
                        let f2 = $('#dd' + filterId.parent).combobox('getValue')
                        let f3 = $('#qq' + filterId.parent).textbox('getValue')
                        let dlist = getFilter(f, f2, f3);
                        let options = tableId.datagrid('getPager').pagination('options');
                        let curPage = options.pageNumber,
                            pSize = options.pageSize;
                        tablesToExcel(tableId.datagrid('options').columns[0], tableName, curPage, curPage, dlist, pSize, otherDatas, orderby, filterId.condition);
                    }
                },
                {
                    text: lans == 'chs' ? '全部导出' : (lans == 'cht' ? '全部匯出' : 'Export all'),
                    handler: function () { //全部导出
                        console.log(filterId);
                        let f = $('#cc' + filterId.parent).combobox('getValue')
                        let f2 = $('#dd' + filterId.parent).combobox('getValue')
                        let f3 = $('#qq' + filterId.parent).textbox('getValue')
                        let dlist = getFilter(f, f2, f3);
                        let options = tableId.datagrid('getPager').pagination('options');
                        let total = options.total,
                            max = Math.ceil(total / options.pageSize),
                            pSize = options.pageSize;
                        tablesToExcel(tableId.datagrid('options').columns[0], tableName, 1, max, dlist, pSize, otherDatas, orderby, filterId.condition);
                    }
                }
                ],
                showRefresh: false,
                onSelectPage: function (pageNumber, pageSizes) {
                    //console.log('触发on');
                    let dataFilter = tableId.datagrid('options').dataFilter;
                    if (dataFilter == undefined)
                        dataFilter = [];
                    let datas = NewfuzzyQueryFilters(tableName, dataFilter, pageNumber, pageSizes, otherDatas, orderby);
                    tableId.datagrid('options').oldDatas = datas;
                    tableId.datagrid('options').dataFilter = dataFilter; //返回自定义条件
                    tableId.datagrid('options').otherDatas = otherDatas; //返回外部自定义条件
                    tableId.datagrid('options').isSum = false;
                    showdbgridDatas(tableId, datas, dataFilter);
                }
            })
        }      

        //加载入过滤栏
        $("#filtration_language" + id + "").combobox({
            valueField: 'field',
            textField: 'value',
            data: datagridTitle,
            onLoadSuccess: function () {
                var setCombobx = $("#filtration_language" + id + "");
                var setCombobx1 = $("#select_language" + id + "");
                var language = $.cookie("language");
                if (language == 'chs') {
                    setCombobx1.combobox("select", "请选择");
                    setCombobx.combobox("select", '请选择');
                } else if (language == 'eng') {
                    setCombobx1.combobox("select", "please select");
                    setCombobx.combobox("select", 'please select');
                } else if (language == 'cht') {
                    setCombobx1.combobox("select", "請選擇");
                    setCombobx.combobox("select", '請選擇');
                }
            },
            onShowPanel: function () {
                if (filterStatus == false) {
                    datagridTitle = loadDatagridTitle(tableId, id);
                    loadFiltertt(datagridTitle);
                    filterStatus = true;
                }
            },
            onSelect: function (re) {
                // 
            }
        })
        return datagridTitle;
    }
    /**
     * 
     * @param {*字段} f 
     * @param {*条件} f2 
     * @param {*值} f3 
     * @returns 返回条件字符串
     */
    function getFilter(f, f2, f3) {
        var f4;
        //包含关系
        let dlist = [];
        let filter = {};
        if ((f2 == "1" || f2 == "包含") && f3 != '') {
            // if (f3.substring(0, 2) == '20')
            // filter[f] = f3 + '%';
            // else
            filter[f] = '%' + f3 + '%';
            filter[f + '_LIKE'] = ' like '
            f4 = "%" + f3 + "%";

        } else if ((f2 == "2" || f2 == "等于") && f3 != '') {
            filter[f] = f3;

        } else if ((f2 == "3" || f2 == "不等于") && f3 != '') {
            f4 = "<>" + f3;
            filter[f] = f3;
            filter[f + '_LIKE'] = ' <> '

        } else if ((f2 == "4" || f2 == "大于") && f3 != '') {
            f4 = ">" + f3 + "";
            filter[f] = f3;
            filter[f + '_LIKE'] = ' > '

        } else if ((f2 == "5" || f2 == "小于") && f3 != '') {
            f4 = "<" + f3 + "";
            filter[f] = f3;
            filter[f + '_LIKE'] = ' < '

        }
        if (!$.isEmptyObject(filter))
            dlist.push(filter)
        let dlists;
        if (filterStatus) {
            let $filtertt = $("#filtertt" + filterId.parent);
            dlists = NewfiltersDataPack($filtertt.datagrid('getRows'));
        }
        if (dlists != undefined) {
            for (let i = 0; i < dlists.length; i++)
                dlist.push(dlists[i]);
        }

        return dlist;
    }

    function unnormal() {
        //序号，客户序号 取FView_products_backData的数据
        var ikeylist = []
        var ypbackikey = "";

        function search_customer_sn() {
            //1
            var table = {};
            if (f == "CUSTOMER_SN")
                table[tableName] = oldfdlist[0]
            else
                for (var key in oldfdlist[0]) {
                    // 
                    table[tableName] = { CUSTOMER_SN: oldfdlist[0][key] }
                }
            ypbackikey = "";
            barcodeikey = "";
            var dataii = { rows: [table] };
            var dataiis = GetDatas(dataii)
            if (dataiis.total > 0) {
                for (var ii = 0; ii < dataiis.total; ii++) {
                    function addikey(yCUSTOMER_SN) {
                        let tbl = {}
                        tbl[tableName] = { RUNCARD: yCUSTOMER_SN }
                        var d = { rows: [tbl] };
                        var s = GetDatas(d)
                        if (s.total > 0) {
                            {
                                for (var k = 0; k < s.total; k++) {
                                    ypbackikey += "," + s.rows[k].IKEY
                                    barcodeikey += "," + s.rows[k].BARCODE_IKEY;
                                    if (s.rows[k].CUSTOMER_SN != "" && s.rows[k].CUSTOMER_SN != undefined)
                                        addikey(s.rows[k].CUSTOMER_SN)
                                }
                            }
                        }
                    }

                    function findikey(datas) {
                        for (var i = 0; i < datas.total; i++) {
                            ypbackikey += "," + datas.rows[i].IKEY;
                            barcodeikey += "," + datas.rows[i].BARCODE_IKEY;
                            // 
                            if (datas.rows[i].CUSTOMER_SN != "" && datas.rows[i].CUSTOMER_SN != undefined)
                                addikey(datas.rows[i].CUSTOMER_SN)
                        }
                    }

                    if (ypbackikey != "")
                        ypbackikey += "," + dataiis.rows[ii].IKEY;
                    else
                        ypbackikey = dataiis.rows[ii].IKEY;
                    if (barcodeikey != "")
                        barcodeikey += "," + dataiis.rows[ii].BARCODE_IKEY;
                    else
                        barcodeikey = dataiis.rows[ii].BARCODE_IKEY;
                    let tbl = {}

                    //2
                    tbl[tableName] = { RUNCARD: dataiis.rows[ii].CUSTOMER_SN }
                    var data = { rows: [tbl] };
                    var datas = GetDatas(data)

                    if (datas.total > 0) {
                        findikey(datas)
                    } else {
                        tbl[tableName] = { CUSTOMER_SN: dataiis.rows[ii].RUNCARD }
                        data = { rows: [tbl] };
                        datas = GetDatas(data);
                        // 
                        if (datas.total > 0) {
                            findikey(datas)
                        } else {
                            //3
                            tbl[tableName] = { RUNCARD: dataiis.rows[ii].RUNCARD }
                            data = { rows: [tbl] };
                            datas = GetDatas(data)
                            if (datas.total > 0)
                                findikey(datas)
                        }
                    };
                }
            };
        }
        if (f == "RUNCARD") {
            var table = {};
            table[tableName] = oldfdlist[0]
            ypbackikey = "";
            barcodeikey = "";
            var dataii = { rows: [table] };

            var dataiis = GetDatas(dataii)

            if (dataiis.total > 0) {
                for (var ii = 0; ii < dataiis.total; ii++) {
                    function addikeyF(yCUSTOMER_SN) {
                        let tbl = {}
                        tbl[tableName] = { RUNCARD: yCUSTOMER_SN }
                        var d = { rows: [tbl] };
                        var s = GetDatas(d)
                        if (s.total > 0) {
                            {
                                for (var k = 0; k < s.total; k++) {
                                    ypbackikey += "," + s.rows[k].IKEY
                                    barcodeikey += "," + s.rows[k].BARCODE_IKEY;
                                    if (s.rows[k].CUSTOMER_SN != "" && s.rows[k].CUSTOMER_SN != undefined)
                                        addikeyF(s.rows[k].CUSTOMER_SN)
                                }
                            }
                        }
                    };

                    if (ypbackikey != "")
                        ypbackikey += "," + dataiis.rows[ii].IKEY;
                    else
                        ypbackikey = dataiis.rows[ii].IKEY;
                    if (barcodeikey != "")
                        barcodeikey += "," + dataiis.rows[ii].BARCODE_IKEY;
                    else
                        barcodeikey = dataiis.rows[ii].BARCODE_IKEY;

                    if (dataiis.rows[ii].CUSTOMER_SN == "" || dataiis.rows[ii].CUSTOMER_SN == undefined)
                        continue;
                    //摸CUSTOMER_SN
                    addikeyF(dataiis.rows[ii].CUSTOMER_SN);
                }
                for (var ii = 0; ii < dataiis.total; ii++) {
                    function findikeyF(datas) {
                        for (var i = 0; i < datas.total; i++) {
                            ypbackikey += "," + datas.rows[i].IKEY
                            barcodeikey += "," + datas.rows[i].BARCODE_IKEY;
                            let tbl = {}
                            if (datas.rows[i].CUSTOMER_SN == "" || datas.rows[i].CUSTOMER_SN == undefined)
                                continue;
                            tbl[tableName] = { RUNCARD: datas.rows[i].CUSTOMER_SN }
                            var dt = { rows: [tbl] };
                            var ds = GetDatas(dt)
                            if (ds.total > 0) {
                                {
                                    for (var j = 0; j < ds.total; j++) {
                                        ypbackikey += "," + ds.rows[j].IKEY
                                        barcodeikey += "," + ds.rows[j].BARCODE_IKEY;
                                        if (ds.rows[j].CUSTOMER_SN != "" && ds.rows[j].CUSTOMER_SN != undefined)
                                            addikeyF(ds.rows[j].CUSTOMER_SN)
                                        break;
                                    }
                                }
                            }
                        }
                    }
                    if (dataiis.rows[ii].CUSTOMER_SN == "" || dataiis.rows[ii].CUSTOMER_SN == undefined) {
                        let tbl = {}
                        tbl[tableName] = { CUSTOMER_SN: dataiis.rows[ii].RUNCARD } //摸RUNCARD
                        let data = { rows: [tbl] };
                        let datas = GetDatas(data)
                        if (datas.total > 0) {
                            findikeyF(datas)
                        }
                        break;
                    }
                }
            } else {
                search_customer_sn();
            }
        } else
            if (f == "CUSTOMER_SN") {
                search_customer_sn();
            }
        // 
        if (barcodeikey != "") {
            var vdcs = { rows: [{ FView_wip_dip_customer_snData: { DIP_RUNCARD_IKEY_IN: barcodeikey } }] }
            var vdcss = GetDatas(vdcs)
            //
            if (vdcss.total > 0) {
                for (var i = 0; i < vdcss.rows.length; i++) {
                    var vback = { rows: [{ FView_products_backData: { BARCODE_IKEY: vdcss.rows[i]['BARCODE_IKEY'] } }] }
                    var vbacks = GetDatas(vback)
                    if (vbacks.rows.length > 0)
                        ypbackikey += "," + vbacks.rows[0].IKEY
                }
            }
        }
        if (ypbackikey != "")
            ikeylist.push({ IKEY_IN: ypbackikey });
        // 
        if ($.isEmptyObject(ikeylist))
            ikeylist = [{ IKEY: "-1" }]
        return ikeylist
    }

    function itemFilter(f, f2, f3, tableName) {
        try {
            // 
            // tableId.datagrid("loading");
            let dlist = getFilter(f, f2, f3);
            var datas = NewfuzzyQueryFilters(tableName, dlist, currentPageNum, pageSize, otherDatas, orderby);
            // datas = JSON.parse(datas);
            // const { total, rows } = datas;        
            tableId.datagrid('options').oldDatas = datas;
            tableId.datagrid('options').dataFilter = dlist; //返回自定义条件
            tableId.datagrid('options').otherDatas = otherDatas; //返回外部自定义条件
            tableId.datagrid('options').isSum = false;
            showdbgridDatas(tableId, datas, dlist);
            isEmpty(datas, tableId)
            return datas
        } catch (error) {

        }
    }
    /*
    //检索
    $('#MES_retrieval' + id + '').textbox('textbox').keydown(function (e) {
        f = $("#filtration_language" + id + "").combobox('getValue')
        f2 = $("#select_language" + id + "").combobox('getValue');
        f3 = $("#MES_FilterInput" + id + "").textbox('getValue');

        function doSearch(q, _data, searchList) {
            tableId.datagrid('loadData', []);
            if (q == "") {
                tableId.datagrid('loadData', itemFilter(f, f2, f3, tableName));
                return;
            }
            var rows = [];
            $.each(_data.rows, function (i, obj) {
                for (var p in searchList) {
                    var v = obj[searchList[p]];
                    if (!!v && v.toString().indexOf(q) >= 0) {
                        rows.push(obj);
                        break;
                    }
                }
            });
            if (rows.length == 0) {
                tableId.datagrid('loadData', []);
                return;
            }
            tableId.datagrid('loadData', rows);
        }
        var value = $("#MES_retrieval" + id + "").textbox('getValue');
        var rows = tableId.datagrid('getRows');
        var data = { total: rows.length, rows: rows };
        var datagridField = [];
        for (let i = 0; i < datagridTitle.length; i++) {
            datagridField[i] = datagridTitle[i].field;
        }
        if ((e || event).keyCode == 13) {
            doSearch(value, data, datagridField);
        }
    });
    */
    //新检索
    $("#ss" + filterId.parent).textbox({
        inputEvents: $.extend({}, $.fn.textbox.defaults.inputEvents, {
            keyup: function (event) {

                if (tableId.datagrid('options').oldDatas == undefined)
                    tableId.datagrid('options').oldDatas = tableId.datagrid('getData');
                var value = $("#ss" + filterId.parent).next().children().val();
                var datagridField = [];
                for (let i = 0; i < datagridTitle.length; i++) {
                    datagridField[i] = datagridTitle[i].field;
                }
                doSearch(value, tableId.datagrid('options').oldDatas, datagridField)

                function doSearch(q, _data, searchList) {
                    tableId.datagrid('options').isSum = false;
                    tableId.datagrid('loadData', []);
                    if (q == "") {
                        tableId.datagrid('options').isSum = false;
                        tableId.datagrid('loadData', tableId.datagrid('options').oldDatas);
                        return;
                    }
                    var rows = [];
                    $.each(_data.rows, function (i, obj) {
                        for (var p in searchList) {
                            var v = obj[searchList[p]];
                            if (!!v && v.toString().indexOf(q) >= 0) {
                                rows.push(obj);
                                break;
                            }
                        }
                    });
                    if (rows.length == 0) {
                        tableId.datagrid('options').isSum = false;
                        tableId.datagrid('loadData', []);
                        let obj = { rows: rows }
                        isEmpty(obj, tableId)
                        return;
                    }
                    tableId.datagrid('options').isSum = false;
                    tableId.datagrid('loadData', rows);
                }
            }
        })
    });

    // $("#MES_FilterInput" + id + "").textbox('textbox').keydown(function (e) {

    $('#qq' + filterId.parent).textbox('textbox').keydown(function (e) {
        if ((e || event).keyCode == 13) {
            HiddenDisplay('block', tableId)
            setTimeout(function () {
                // f = $("#filtration_language" + id + "").combobox('getValue')
                // f2 = $("#select_language" + id + "").combobox('getValue');
                // f3 = $("#MES_FilterInput" + id + "").textbox('getValue');

                let f = $('#cc' + filterId.parent).combobox('getValue')
                let f2 = $('#dd' + filterId.parent).combobox('getValue')
                let f3 = $('#qq' + filterId.parent).textbox('getValue')
                let ds = $('#cc' + filterId.parent).combobox('getData')
                let txt = $('#cc' + filterId.parent).combobox('getText')
                // let ds = $("#filtration_language" + id + "").combobox('getData');
                // let txt = $("#filtration_language" + id + "").combobox('getText');
                let selects;
                for (let i = 0; i < ds.length; i++) {
                    if (ds[i].value == txt) {
                        selects = ds[i].status;
                        break;
                    }
                }
                if (selects != null) {
                    for (obj in selects) {
                        if (selects[obj] == f3) {
                            f3 = obj;
                            break;
                        }
                    }
                }
                itemFilter(f, f2, f3, tableName);
                e.keyCode = 0; //屏蔽回车键
                e.returnValue = false;
                HiddenDisplay('none', tableId)
            }, 15)

        }
    })
    /**
     * 
     * @param {*外部查询条件} otherdDate 
     * @param {*自定义查询条件} dataFilter 
     */
    function FindData(otherdDate, dataFilter, mOrderby) {
        HiddenDisplay('block', tableId)
        setTimeout(function () {
            // f = $("#filtration_language" + id + "").combobox('getValue')
            // f2 = $("#select_language" + id + "").combobox('getValue');
            // f3 = $("#MES_FilterInput" + id + "").textbox('getValue');
            let f = $('#cc' + filterId.parent).combobox('getValue')
            let f2 = $('#dd' + filterId.parent).combobox('getValue')
            let f3 = $('#qq' + filterId.parent).textbox('getValue')
            otherDatas = otherdDate;
            datalist = dataFilter;
            // let ds = $("#filtration_language" + id + "").combobox('getData');
            // let txt = $("#filtration_language" + id + "").combobox('getText')
            let ds = $('#cc' + filterId.parent).combobox('getData')
            let txt = $('#cc' + filterId.parent).combobox('getText')
            let selects;
            for (let i = 0; i < ds.length; i++) {
                if (ds[i].value == txt) {
                    selects = ds[i].status;
                    break;
                }
            }
            if (selects != null) {
                for (obj in selects) {
                    if (selects[obj] == f3) {
                        f3 = obj;
                        break;
                    }
                }
            }
            if (tableId.datagrid('options').pagination) {
                pageSize = tableId.datagrid('getPager').pagination('options').pageSize;
                if (isNaN(pageSize))
                    pageSize = 200;
            }
            if (mOrderby == undefined)
                orderby = 'IKEY asc'
            else
                orderby = mOrderby;
            // 
            itemFilter(f, f2, f3, tableName);
            HiddenDisplay('none', tableId)
        }, 10);
    }
    var filterStatus = false;

    // $("#ee"+filterId.parent).click(function () {
    //     
    //     $("#item_filter_window" + id + "").window('open');
    //     $("#item_filter_window" + id + "").window('hcenter');
    //     if (filterStatus == false) {
    //         datagridTitle = loadDatagridTitle(tableId, id);
    //         loadFiltertt(datagridTitle);
    //         filterStatus = true;
    //     }
    // })
    $("#ee" + filterId.parent).click(function () {
        $("#myWindow" + filterId.parent).window('open');
        $("#myWindow" + filterId.parent).window('hcenter');
        if (filterStatus == false) {
            datagridTitle = loadDatagridTitle(tableId, id);
            loadFiltertt(datagridTitle);
            filterStatus = true;
        }
    })
    function Clear() {
        $("#MES_FilterInput" + id + "").textbox('setValue', "");
        $('#MES_retrieval' + id + '').textbox('setValue', "");
    }
    function RestTableName(mTableName) {
        tableName = mTableName;
        // filterId.showdb();
    }
    return { FindData: FindData, Clear: Clear, RestTableName: RestTableName };
    // return { FindData: FindData, Clear: Clear };
}

function myBrowser() {
    var userAgent = navigator.userAgent; //取得浏览器的userAgent字符串
    var isOpera = userAgent.indexOf("Opera") > -1; //判断是否Opera浏览器
    var isIE = userAgent.indexOf("compatible") > -1 &&
        userAgent.indexOf("MSIE") > -1 && !isOpera; //判断是否IE浏览器
    var isEdge = userAgent.indexOf("Edge") > -1; //判断是否IE的Edge浏览器
    var isFF = userAgent.indexOf("Firefox") > -1; //判断是否Firefox浏览器
    var isSafari = userAgent.indexOf("Safari") > -1 &&
        userAgent.indexOf("Chrome") == -1; //判断是否Safari浏览器
    var isChrome = userAgent.indexOf("Chrome") > -1 &&
        userAgent.indexOf("Safari") > -1; //判断Chrome浏览器
    var is360 = userAgent.indexOf("360") > -1;

    if (isIE) {
        var reIE = new RegExp("MSIE (\\d+\\.\\d+);");
        reIE.test(userAgent);
        var fIEVersion = parseFloat(RegExp["$1"]);
        if (fIEVersion == 7) {
            return "IE7";
        } else if (fIEVersion == 8) {
            return "IE8";
        } else if (fIEVersion == 9) {
            return "IE9";
        } else if (fIEVersion == 10) {
            return "IE10";
        } else if (fIEVersion == 11) {
            return "IE11";
        } else {
            return "0";
        } //IE版本过低
        return "IE";
    }
    if (isOpera) {
        return "Opera";
    }
    if (isEdge) {
        return "Edge";
    }
    if (isFF) {
        return "Firefox";
    }
    if (isSafari) {
        return "Safari";
    }
    if (isChrome) {
        return "Chrome";
    }
    if (is360) {
        return "360";
    }
}
printDate = function (value) {
    var date = new Date(value);
    var year = date.getFullYear().toString();
    var month = (date.getMonth() + 1);
    var day = date.getDate().toString();
    var hour = date.getHours().toString();
    var minutes = date.getMinutes().toString();
    var seconds = date.getSeconds().toString();
    if (month < 10) {
        month = "0" + month;
    }
    if (day < 10) {
        day = "0" + day;
    }
    if (hour < 10) {
        hour = "0" + hour;
    }
    if (minutes < 10) {
        minutes = "0" + minutes;
    }
    if (seconds < 10) {
        seconds = "0" + seconds;
    }
    return year + "/" + month + "/" + day + " " + hour + ":" + minutes;
}
/**
 * 过滤栏自定义日期弹框里面的日期选择框用到
 * @param {*日期} date 
 * @returns 返回:yyyy-MM-dd
 */
function myDateformatter(date) {
    var y = date.getFullYear();
    var m = date.getMonth() + 1;
    var d = date.getDate();;
    return y + '-' + (m < 10 ? ('0' + m) : m) + '-' + (d < 10 ? ('0' + d) : d);
}

function DateForMatter(date) {
    var y = date.getFullYear();
    var m = date.getMonth() + 1;
    return y + '-' + m;
}

function DateForMatterYear(date) {
    var y = date.getFullYear();
    return y;
}

function myDateformattertime(date) {
    var y = date.getFullYear();
    var m = date.getMonth() + 1;
    var d = date.getDate();
    var h = date.getHours();
    var min = date.getMinutes();
    var s = date.getSeconds();
    return y + '-' + (m < 10 ? ('0' + m) : m) + '-' + (d < 10 ? ('0' + d) : d) + ' ' + (h < 10 ? ('0' + h) : h) + ':' + (min < 10 ? ('0' + min) : min) + ':' + (s < 10 ? ('0' + s) : s);
}

/**
 * 过滤栏自定义日期弹框里面的日期选择框用到
 * @param {*日期} mdata 
 * @returns 返回日期
 */
function myDateparser(mdata) {
    if (!mdata) return new Date();
    var s1 = (mdata.split(' '));
    var ss = s1[0].split('-');
    var y = parseInt(ss[0], 10);
    var m = parseInt(ss[1], 10);
    var d = parseInt(ss[2], 10);;
    if (!isNaN(y) && !isNaN(m) && !isNaN(d)) {
        return new Date(y, m - 1, d);
    } else {
        return new Date();
    }
}

function myparserTime(s) {
    if (!s) return new Date();
    var s1 = (s.split(' '));
    var ss = s1[0].split('-');
    var ss1 = s1[1].split(":");
    var y = parseInt(ss[0], 10);
    var m = parseInt(ss[1], 10);
    var d = parseInt(ss[2], 10);
    var h = parseInt(ss1[0], 10);
    var min = parseInt(ss1[1], 10);
    var se = parseInt(ss1[2], 10);
    if (!isNaN(y) && !isNaN(m) && !isNaN(d)) {
        return new Date(y, m - 1, d, h, min, se);
    } else {
        return new Date();
    }
}
/**
 * @param {*传入日期} mDate 
 * @returns 返回日期 格式为:yyyy-MM-dd hh:mm:ss 
 * 日前为显示dbgrid日期转换格式
 */
Time_format = function (mDate) {
    let result = '';
    if (mDate != '' && mDate != undefined) {
        var date = new Date(mDate);
        console.log(date);
        
        var year = date.getFullYear().toString();
        var month = (date.getMonth() + 1);
        var day = date.getDate().toString();
        var hour = date.getHours().toString();
        var minutes = date.getMinutes().toString();
        var seconds = date.getSeconds().toString();
        if (month < 10) {
            month = "0" + month;
        }
        if (day < 10) {
            day = "0" + day;
        }
        if (hour < 10) {
            hour = "0" + hour;
        }
        if (minutes < 10) {
            minutes = "0" + minutes;
        }
        if (seconds < 10) {
            seconds = "0" + seconds;
        }
        if (mDate.toString().search('GMT') != -1) {
            result = year + "-" + month + "-" + day + " " + hour + ":" + minutes + ":" + seconds;
        } else if (mDate.toString() == '') {
            result = ' ';
        } else {
            result = year + "-" + month + "-" + day + " " + hour + ":" + minutes + ":" + seconds;
        }
    }
    return result;
}
/**
 * @param {*传入日期} mDate 
 * @returns 返回日期 格式为:yyyy-MM-dd
 * 日期转换格式
 */
myformatter_Date = function (mDate) {
    let result = '';
    if (mDate != '' && mDate != undefined) {
        var date = new Date(mDate);
        var year = date.getFullYear().toString();
        var month = (date.getMonth() + 1);
        var day = date.getDate().toString();
        var hour = date.getHours().toString();
        var minutes = date.getMinutes().toString();
        var seconds = date.getSeconds().toString();
        if (month < 10) {
            month = "0" + month;
        }
        if (day < 10) {
            day = "0" + day;
        }
        if (hour < 10) {
            hour = "0" + hour;
        }
        if (minutes < 10) {
            minutes = "0" + minutes;
        }
        if (seconds < 10) {
            seconds = "0" + seconds;
        }
        if (mDate.toString().search('GMT') != -1) {
            result = year + "-" + month + "-" + day + " ";
        } else if (mDate.toString() == '') {
            result = ' ';
        } else {
            result = year + "-" + month + "-" + day + " ";
        }
    }
    return result;
}
/**
 * 
 * @param {*在传入日期基础上添加天数,如果不传入值，即为(undefined)则不添加、减天数} mAddDay 
 * @param {*传入日期,如果不传入值,即为(undefined)取当前日期} mDate 
 * @param {*返回日期格式,默认为:yyyy-MM-dd} mFormat
 * @returns 返回格式为:yyyy-MM-dd
 */
function getDatePlus(mAddDay, mDate, mFormat) {
    let result = '';
    let date;
    if (mDate != undefined)
        date = new Date(mDate);
    else
        date = new Date();
    if (mAddDay == undefined)
        mAddDay = 0;
    date.setDate(date.getDate() + Number(mAddDay));
    let year = date.getFullYear().toString();
    let month = (date.getMonth() + 1);
    let day = date.getDate().toString();
    let hour = date.getHours().toString();
    let minutes = date.getMinutes().toString();
    let seconds = date.getSeconds().toString();
    let Mseconds = date.getMilliseconds().toString();
    if (month < 10)
        month = "0" + month;
    if (day < 10)
        day = "0" + day;
    if (hour < 10)
        hour = "0" + hour;
    if (minutes < 10)
        minutes = "0" + minutes;
    if (seconds < 10)
        seconds = "0" + seconds;
    if (mFormat == undefined) //默认格式
        result = year + "-" + month + "-" + day;
    else if (mFormat == 'yyyy-MM-dd hh:mm:ss')
        result = year + "-" + month + "-" + day + " " + hour + ":" + minutes + ":" + seconds;
    else if (mFormat == 'yyyy-MM-dd hh:mm:ss.zzz')
        result = year + "-" + month + "-" + day + " " + hour + ":" + minutes + ":" + seconds + "." + Mseconds;
    else if (mFormat == 'yyyy-MM-dd hh:mm')
        result = year + "-" + month + "-" + day + " " + hour + ":" + minutes;
    else if (mFormat == 'yyyy-MM-dd hh')
        result = year + "-" + month + "-" + day + " " + hour;
    else if (mFormat == 'yyyy-MM-dd')
        result = year + "-" + month + "-" + day;
    else if (mFormat == 'yyyy-MM')
        result = year + "-" + month;
    else if (mFormat == 'yyyy')
        result = year;
    else if (mFormat == 'MM')
        result = month;
    else if (mFormat == 'MM-dd')
        result = month + "-" + day;
    else if (mFormat == 'dd')
        result = day;
    return result;
}
/** 
 * @param {*value 当前日期基础上添加、减天数} value 
 * @returns 返回天数后的日期 格式为：yyyy-MM-dd hh:mm:ss
 * 目前多为保存数据是取当前日期时间
 */
function timescopePlus(AddDay) {
    if (AddDay == undefined)
        AddDay = 0;
    var date = new Date();
    date.setDate(date.getDate() + Number(AddDay));
    var year = date.getFullYear().toString();
    var month = (date.getMonth() + 1);
    var day = date.getDate().toString();
    var hour = date.getHours().toString();
    var minutes = date.getMinutes().toString();
    var seconds = date.getSeconds().toString();
    if (month < 10) {
        month = "0" + month;
    }
    if (day < 10) {
        day = "0" + day;
    }
    if (hour < 10) {
        hour = "0" + hour;
    }
    if (minutes < 10) {
        minutes = "0" + minutes;
    }
    if (seconds < 10) {
        seconds = "0" + seconds;
    }
    return year + "-" + month + "-" + day + " " + hour + ":" + minutes + ":" + seconds;
}
/**
 * 
 * @param {*传入日期} dt 
 * @returns 返回周别
 */
function getWeekNum(dt) {
    let d1 = new Date(dt),
        d2 = new Date(dt);
    d2.setMonth(0);
    d2.setDate(1);
    let rq = d1 - d2;
    let days = Math.ceil(rq / (24 * 60 * 60 * 1000));
    let num = Math.ceil(days / 7);
    return num;
}

//上传文件 转Hex
function stringToHex(str) {
    var val = "";
    for (var i = 0; i < str.length; i++) {
        let hex = str.charCodeAt(i).toString(16);
        if (hex.length < 2)
            hex = '0' + hex;
        if (val == "")
            val = hex;
        else
            val += hex;
    }
    return val;
}
function HexToString(hexString) {
    // 将十六进制字符串转换为字节数组
    var bytes = [];
    for (var i = 0; i < hexString.length; i += 2) {
        bytes.push(parseInt(hexString.substr(i, 2), 16));
    }

    // 创建一个新的 Uint8Array 对象
    var uint8Array = new Uint8Array(bytes);

    // 将字节数组解码为中文字符串
    var decoder = new TextDecoder('utf-8');
    var string = decoder.decode(uint8Array);
    return string;
}
//上传文件 转Hex
function base64ToHex(base64) {
    var raw = atob(base64);
    var HEX = '';
    for (i = 0; i < raw.length; i++) {
        var _hex = raw.charCodeAt(i).toString(16)
        HEX += (_hex.length == 2 ? _hex : '0' + _hex);
    }
    return HEX;
}

//按时间获取单号编号
function getSpecialNo() {
    var date = new Date();
    date.setDate(date.getDate());
    var year = date.getFullYear().toString();
    var month = (date.getMonth() + 1);
    var day = date.getDate().toString();
    var hour = date.getHours().toString();
    var minutes = date.getMinutes().toString();
    var seconds = date.getSeconds().toString();
    var Mseconds = date.getMilliseconds().toString();
    if (month < 10) {
        month = "0" + month;
    }
    if (day < 10) {
        day = "0" + day;
    }
    if (hour < 10) {
        hour = "0" + hour;
    }
    if (minutes < 10) {
        minutes = "0" + minutes;
    }
    if (seconds < 10) {
        seconds = "0" + seconds;
    }
    return year + month + day + hour + minutes + seconds + Mseconds;
}

/**
 * 
 * @param {*表头列属性} options 
 * @param {*数据表名} tableName 
 * @param {*总页数} maxPage 
 * @param {*查询条件} dlist 
 * @param {*当前页记录数} pageSize 
 * @param {*外部查询条件} otherDatas 
 * @param {*数据查询顺序} orderby 
 */
function tablesToExcel(options, tableName, curPage, maxPage, dlist, pageSize, otherDatas, orderby, condition) {
    try {
        if (maxPage <= 0 || maxPage == undefined)
            throw getShowMessage('PUBLIC-0020:无数据导出');
        var uri = 'data:application/vnd.ms-excel;base64,',
            tmplWorkbookXML = '<?xml version="1.0"?><?mso-application progid="Excel.Sheet"?><Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">' +
                '<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><Author>Axel Richter</Author><Created>{created}</Created></DocumentProperties>' +
                '<Styles>' +
                '<Style ss:ID="Currency"><NumberFormat ss:Format="Currency"></NumberFormat></Style>' +
                '<Style ss:ID="Date"><NumberFormat ss:Format="Medium Date"></NumberFormat></Style>' +
                '</Styles>' +
                '{worksheets}</Workbook>',
            tmplWorksheetXML = '<Worksheet ss:Name="{nameWS}"><Table>{rows}</Table></Worksheet>',
            tmplCellXML = '<Cell{attributeStyleID}{attributeFormula}><Data ss:Type="{nameType}">{data}</Data></Cell>',
            base64 = function (s) { return window.btoa(unescape(encodeURIComponent(s))) },
            format = function (s, c) { return s.replace(/{(\w+)}/g, function (m, p) { return c[p]; }) }
        var ctx = "";
        var workbookXML = "";
        var worksheetsXML = "";
        var rowsXML = "";
        for (; curPage <= maxPage; curPage++) {
            let d = NewfuzzyQueryFilters(tableName, dlist, curPage, pageSize, otherDatas, orderby, condition == undefined ? false : condition);
            //表头
            rowsXML += '<Row>';
            for (let c = 0; c < options.length; c++) {
                let files = options[c],
                    titles = '';
                if (files.field == 'checkItem' || files.hidden == true || (files.hasOwnProperty('isExport') && !files.isExport))
                    continue;
                let obj = document.getElementById(files.id);
                if (obj != null && obj != undefined) {
                    titles = obj.innerText;
                } else {
                    titles = files.title;
                }
                ctx = { attributeStyleID: '', attributeFormula: '', nameType: 'String', data: titles };
                rowsXML += format(tmplCellXML, ctx);
            }
            rowsXML += '</Row>'

            for (let r = 0; r < d.rows.length; r++) {
                let rs = d.rows[r];
                rowsXML += '<Row>';
                for (let c = 0; c < options.length; c++) {
                    let files = options[c];
                    if (files.field == 'checkItem' || files.hidden == true || (files.hasOwnProperty('isExport') && !files.isExport))
                        continue;
                    ctx = { attributeStyleID: '', attributeFormula: '', nameType: files.dataType == 'DateTime' ? 'String' : (files.dataType == undefined ? 'String' : files.dataType), data: files.dataType == 'DateTime' ? Time_format(rs[files.field]) : (files.isStatus == undefined ? rs[files.field] : files.isStatus[rs[files.field]]) };
                    rowsXML += format(tmplCellXML, ctx);
                }
                rowsXML += '</Row>'
            }
            ctx = { rows: rowsXML, nameWS: getShowMessage('PUBLIC-0019:第' + curPage + '页', curPage) || 'Sheet' + curPage };
            worksheetsXML += format(tmplWorksheetXML, ctx);
            rowsXML = "";
        }

        ctx = { created: (new Date()).getTime(), worksheets: worksheetsXML };
        workbookXML = format(tmplWorkbookXML, ctx);
        var link = document.createElement("A");
        link.href = uri + base64(workbookXML);
        link.download = getShowMessage('PUBLIC-0021:导出') || 'Workbook.xls';
        link.target = '_blank';
        document.body.appendChild(link);
        link.click();
        document.body.removeChild(link);
    } catch (error) {
        $.messager.alert(getShowMessage('MSGTITLE:提示'), error);
    }


}

/**
 * 
 * @param {*dbgrid} tableId 
 * @param {*dbgridtoolid} toolId 
 * @param {*模板id} id 
 * @param {*默认按tableid表头取列值:undefined;0:以excel表格列取值} fixHeard
 * @param {*传入table的field-->[],取最后数组值延申table的field}field
 */
function ImportTemplate(tableId, toolId, id, fixHeard, field) {
    var opt = tableId.datagrid('options');
    if (opt.IsAppend != undefined && opt.IsAppend == true) return;
    var importData = { id: id, Import: getShowMessage('PUBLIC-0023:导入文件'), };
    $(template('ImportExcel', importData)).appendTo(toolId);
    $.parser.parse(toolId);
    $('#ImportExcel' + id).click(function () {
        $('#ImportFile' + id).trigger('click');
    })
    var reader = new FileReader();
    $('#ImportFile' + id).change(function () {
        let btnopts = $('#ImportExcel' + id).linkbutton('options');
        let ImportFile = document.getElementById('ImportFile' + id);
        let cols = opt.columns[0],
            rds = [],
            tds = [];
        if (ImportFile.files.length <= 0) {
            tableId.datagrid('loadData', { rows: [] });
            return;
        }
        if (!/\.(xls|xlsx)$/.test(ImportFile.files[0].name.toLowerCase())) {
            ImportFile.files[0].name = '';
            $('#ImportFile' + id)[0].value = '';
            tableId.datagrid('loadData', { rows: [] });
            $.messager.alert(getShowMessage('MSGTITLE:提示'), getShowMessage('PUBLIC-0022:请导入excle格式文档'));
            return;
        }
        if (fixHeard == 0 && field.length <= 0) {
            $.messager.alert(getShowMessage('MSGTITLE:提示'), getShowMessage('PUBLIC-0024:field不允许传空'));
            return;
        }
        let file = ImportFile.files[0]; //获取文件流
        reader.readAsBinaryString(file);
        //readAsText->读取文件内容(记事本); readAsDataURL(file)->异步读取文件内容，结果用data:url的字符串形式表示(上传文件用)
        //readAsBinaryString->异步按字节读取文件内容，结果为文件的二进制串
        //readAsArrayBuffer(file)->结果用ArrayBuffer对象表示
        reader.onload = function (evt) { //读取完文件之后会回来这里
            let data = evt.target.result;
            let workbook = XLSX.read(data, { type: 'binary' });
            // let persons = [];
            // for (sheet in workbook.Sheets) {
            //     if (workbook.Sheets.hasOwnProperty(sheet)) {
            //         persons = persons.concat(XLSX.utils.sheet_to_json(workbook.Sheets[sheet]));
            //         console.log(persons);
            //     }
            // }
            //XLSX.utils.sheet_to_csv(workbook.Sheets[sheetName]); excel转成csv文本格式,分隔符为 ,
            //XLSX.utils.sheet_to_json(workbook.Sheets[sheetName], { head: 0, defval: '' });excel转成json格式
            //XLSX.utils.sheet_to_txt(workbook.Sheets[sheetName]); excel转成txt文本格式,分隔符为 tab
            let isSpan = {},
                title = [];
            if (btnopts.loca_dll == undefined || btnopts.loca_dll == null || btnopts.loca_dll == '') {
                workbook.SheetNames.forEach(sheetName => {
                    let sheet = XLSX.utils.sheet_to_txt(workbook.Sheets[sheetName]).split(/\n/g);
                    if (fixHeard == undefined) {
                        // sheet = XLSX.utils.sheet_to_json(workbook.Sheets[sheetName]);
                        for (let i = 0; i < sheet.length; i++) {
                            if (sheet[i] == '')
                                continue;

                            let col = 0,
                                ds = {},
                                span = false,
                                colValue = sheet[i].split(/\t/g);
                            for (let r = 0; r < colValue.length; r++) {
                                if (i == 0) //去除表头
                                    continue;
                                span = false;
                                if (col >= cols.length)
                                    break;
                                if (cols[col].isSpan != undefined && cols[col].isSpan == true) {
                                    span = true;
                                    if (colValue[r] != '')
                                        isSpan[cols[col].field] = colValue[r];
                                }
                                //isSpan：是否合并列,是合并列并设为true
                                ds[cols[col].field] = colValue[r] == '' ? (span == true ? isSpan[cols[col].field] : colValue[r]) : colValue[r];
                                col++;
                            }
                            // for (let obj in sheet[i]) {
                            //     // if (obj == '__rowNum__')//行号
                            //     //     continue;
                            //     span = false;
                            //     if (col >= cols.length)
                            //         break;
                            //     if (cols[col].isSpan != undefined && cols[col].isSpan == true) {
                            //         span = true;
                            //         if (sheet[i][obj] != '')
                            //             isSpan[cols[col].field] = sheet[i][obj];
                            //     }
                            //     //isSpan：是否合并列,是合并列并设为true
                            //     ds[cols[col].field] = sheet[i][obj] == '' ? (span == true ? isSpan[cols[col].field] : sheet[i][obj]) : sheet[i][obj];
                            //     col++;
                            // }
                            if (i != 0)
                                rds.push(ds);
                        }
                    } else if (fixHeard == 0) {
                        let sheet1 = XLSX.utils.sheet_to_json(workbook.Sheets[sheetName]);
                        // console.log(sheet1);
                        for (let i = 0; i < sheet1.length; ++i) {
                            if (sheet1[i] == '')
                                continue;
                            let r = 0;
                            let rs = {};
                            for (let key in sheet1[i]) {
                                if (i == 0) {
                                    if (title.indexOf(key) == -1 && key != '')
                                        title.push(key);
                                }
                                let h = r == 0 ? field[0] : field[field.length - 1] + (r + 1).toString();
                                rs[h] = sheet1[i][key];
                                r++;
                            }
                            rds.push(rs);
                        }
                        /*
                        for (let i = 0; i < sheet.length; i++) {
                            if (sheet[i] == '')
                                continue;
                            let row = sheet[i].split(/\t/g), ds = {};
                            for (let r = 0; r < row.length; r++) {
                                if (i == 0) {
                                    if (title.indexOf(row[r]) == -1 && row[r] != '')
                                        title.push(row[r]);
                                }
                                else {
                                    let h = r == 0 ? field[0] : field[field.length - 1] + (r + 1).toString();
                                    ds[h] = row[r];
                                }
                            }
                            if (i != 0)
                                rds.push(ds);
                        }*/
                    }
                });
            }
            else {//以绑定js 去解析文档内容
                let s = document.createElement("script");
                s.src = "../../assets/locationDll/" + btnopts.loca_dll;//.js
                if (document.all) {
                    s.onreadystatechange = function () {
                        if (this.readyState == "loaded" || this.readyState == "complete") { }
                    }
                } else { s.onload = function () { } }
                document.head.appendChild(s);

                setTimeout(() => {
                    rds = rds.concat(importMount(workbook, tableId));
                }, 50);
            }
            if (fixHeard == 0) {
                let titles = [];
                for (let t = 0; t < title.length; t++) {
                    if (t == 0)
                        titles.push({ field: field[0], title: title[0], align: 'center', width: '20%', });
                    else
                        titles.push({ field: field[field.length - 1] + (t + 1).toString(), title: title[t], align: 'center', width: '20%', });
                }
                tableId.datagrid({ columns: [titles] });
            }
            setTimeout(() => {
                tableId.datagrid('loadData', rds);
                ImportFile.files[0].name = '';
                $('#ImportFile' + id)[0].value = '';
            }, 100);
        }
    })
    if (!opt.hasOwnProperty('IsAppend'))
        opt['IsAppend'] = true;
}