function excelUpload(element, url, cityId) {
    // 加载提示
    var loadingMsg = layer.msg('数据导入中,请稍候...', {
        icon: 16,
        scrollbar: false,
        time: 0,
        shade: [0.01, '#393D49']
    });
    //④创建一个formData对象
    var formData = new FormData();
    //⑤获取传入元素的val
    var name = $(element).val();
    //⑥获取files
    var files = $(element)[0].files[0];
    //⑦将name 和 files 添加到formData中，键值对形式
    formData.append("file", files);
    formData.append("name", name);
    formData.append("cityName", cityId);
    formData.append("token", token);
    $.ajax({
        url: url,
        type: 'POST',
        headers: {
            "encrypt": sm3(JSON.stringify(formData))
        },
        data: formData,
        dataType: 'json',
        processData: false,// ⑧告诉jQuery不要去处理发送的数据
        contentType: false, // ⑨告诉jQuery不要去设置Content-Type请求头
        beforeSend: function () {
        },
        success: function (result) {
            layer.close(loadingMsg);
            $(element).val("");
            if (result.success) {
                layer.confirm(result.msg, {
                    btn: ['确认', '关闭'] //按钮
                    ,
                    cancel: function (index, layero) {
                        //取消操作，点击右上角的X
                    }
                }, function () {
                    //是
                    query();
                    layer.closeAll();
                }, function () {
                    //否
                    query();
                });
            } else {
                showModal(result);
            }
        },
        error: function (result) {
            layer.close(loadingMsg);
            $(element).val("");
            $.dialog({title: '提示', content: result.msg});
        }
    });
}

function excelUpload2(element, element2, url, proId, id) {
    //④创建一个formData对象
    var formData = new FormData();
    //⑤获取传入元素的val
    var name = $(element).val();
    var names = $(element2).val();
    //⑥获取files
    var files = $(element)[0].files[0];
    var files2 = $(element2)[0].files[0];
    //⑦将name 和 files 添加到formData中，键值对形式
    formData.append("file", files);
    formData.append("file2", files2);
    formData.append("name", name);
    formData.append("names", names);
    formData.append("proId", proId);
    formData.append("id", id);
    $.ajax({
        url: url,
        type: 'POST',
        headers: {
            "encrypt": sm3(JSON.stringify(formData))
        },
        data: formData,
        dataType: 'json',
        processData: false,// ⑧告诉jQuery不要去处理发送的数据
        contentType: false, // ⑨告诉jQuery不要去设置Content-Type请求头
        beforeSend: function () {
        },
        success: function (result) {
            $(element).val("");
            if (result.success) {
                layer.confirm(result.msg, {
                    btn: ['确认', '关闭'] //按钮
                    ,
                    cancel: function (index, layero) {
                        //取消操作，点击右上角的X
                    }
                }, function () {
                    //是
                    var index = parent.layer.getFrameIndex(window.name); //先得到当前 iframe层的索引
                    parent.layer.close(index); //再执行关闭
                    window.parent.location.reload();
                }, function () {
                    //否
                });
            } else {
                showModal(result);
            }
        },
        error: function (result) {
            $(element).val("");
            $.dialog({title: '提示', content: result.msg});
        }
    });
}

// 违章依据
function excelUpload3(element, voiTypeId, url) {
    // 导入提示
    let loadingMsg = layer.msg('数据导入中,请稍候...', {icon: 16, scrollbar: false, time: 0});
    //④创建一个formData对象
    let formData = new FormData();
    //⑤获取传入元素的val
    //⑥获取files
    let files = $(element)[0].files[0];
    //⑦将name 和 files 添加到formData中，键值对形式
    formData.append("file", files);
    formData.append("voiTypeId", voiTypeId);
    $.ajax({
        headers: {
            "encrypt": sm3(JSON.stringify({
                voiTypeId: voiTypeId
            }))
        },
        url: url,
        type: 'POST',
        data: formData,
        dataType: 'json',
        processData: false,// ⑧告诉jQuery不要去处理发送的数据
        contentType: false, // ⑨告诉jQuery不要去设置Content-Type请求头
        beforeSend: function () {
        },
        success: function (result) {
            layer.close(loadingMsg);
            $(element).val("");
            if (result.success) {
                reloadData();
                layer.msg('导入成功', {icon: 1});
            } else {
                showModal2(result);
            }
        },
        error: function (result) {
            layer.close(loadingMsg);
            $(element).val("");
            $.dialog({title: '提示', content: result.msg});
        }
    });
}

function excelUpload4(element, url) {
    // 导入提示
    let loadingMsg = layer.msg('数据导入中,请稍候...', {icon: 16, scrollbar: false, time: 0});
    //④创建一个formData对象
    let formData = new FormData();
    //⑤获取传入元素的val
    //⑥获取files
    let files = $(element)[0].files[0];
    //⑦将name 和 files 添加到formData中，键值对形式
    formData.append("file", files);
    $.ajax({
        headers: {
            "encrypt": sm3(JSON.stringify({}))
        },
        url: url,
        type: 'POST',
        data: formData,
        dataType: 'json',
        processData: false,// ⑧告诉jQuery不要去处理发送的数据
        contentType: false, // ⑨告诉jQuery不要去设置Content-Type请求头
        beforeSend: function () {
        },
        success: function (result) {
            layer.close(loadingMsg);
            $(element).val("");

            if (result.code === 200) {
                layer.msg('导入成功', {icon: 1});
                reloadData();
                top.reloadHomeData(2);
            } else {
                layer.msg('导入失败，请检查数据是否有误！', {icon: 2});
            }
        },
        error: function (result) {
            layer.close(loadingMsg);
            $(element).val("");
            $.dialog({title: '提示', content: result.msg});
        }
    });
}

// 工程管理数据导入
function excelUpload5(element, voiTypeId, url) {
    // 导入提示
    let loadingMsg = layer.msg('数据导入中,请稍候...', {icon: 16, scrollbar: false, time: 0});
    //④创建一个formData对象
    let formData = new FormData();
    //⑤获取传入元素的val
    //⑥获取files
    let files = $(element)[0].files[0];
    //⑦将name 和 files 添加到formData中，键值对形式
    formData.append("file", files);
    $.ajax({
        headers: {
            "encrypt": sm3(JSON.stringify({}))
        },
        url: url,
        type: 'POST',
        data: formData,
        dataType: 'json',
        processData: false,// ⑧告诉jQuery不要去处理发送的数据
        contentType: false, // ⑨告诉jQuery不要去设置Content-Type请求头
        beforeSend: function () {
        },
        success: function (result) {
            layer.close(loadingMsg);
            $(element).val("");
            if (result.success) {
                reloadData(pageType);
            } else {
                showModal2(result);
            }
        },
        error: function (result) {
            layer.close(loadingMsg);
            $(element).val("");
            $.dialog({title: '提示', content: result.msg});
        }
    });
}

function showModal(result) {
    if (result.status == 1000) {
        $.dialog({title: '提示', content: result.msg});
        return;
    }
    $('#myModal_edit').modal('hide');
    var tableStr = "<table class='table table-striped'>";
    tableStr = tableStr
        + "<thead>"
        + "<tr>"
        + "<th style='width: 50px;text-align:center;'>序号</th>"
        + "<th style='width: 80px;text-align:center;'>行号</th>"
        + "<th style='width: 80px;text-align:center;'>列名</th>"
        + "<th style='width: 150px;text-align:center;'>错误值</th>"
        + "<th style='text-align:center;'>错误信息</th>"
        + "</tr>"
        + "</thead>";
    for (var i = 0; i < result.data.length; i++) {
        if (result.data[i].storePhone == "" || typeof (result.data[i].storePhone) == "undefined") {
            result.data[i].storePhone = "无";
        }
        tableStr = tableStr + "<tbody>"
            + "<tr>"
            + "<td style='text-align:center'>" + (i + 1) + "</td>"
            + "<td style='text-align:center'>" + result.data[i].errorRow + "</td>"
            + "<td style='text-align:center'>" + result.data[i].errorLine + "</td>"
            + "<td style='text-align:center'>" + result.data[i].errorData + "</td>"
            + "<td style='text-align:center'>" + result.data[i].errorMsg + "</td>"
            + "</tr>"
            + "</tbody>";
    }
    tableStr = tableStr + "</table>";
    $("#tableAjax").html(tableStr);
    $('#myModal_edit').modal('show');
}

function showModal2(result) {
    if (result.status == 1000) {
        $.dialog({title: '提示', content: result.msg});
        return;
    }
    $('#myModal_edit').modal('hide');
    let tableStr = "<table class='table table-striped confirm-table'>"
        + "<thead>"
        + "<tr style='background-color:#F0F0F0'>"
        + "<td style='width: 80px;'>序号</td>"
        + "<td style='width: 120px;'>行号</td>"
        + "<td style='width: 200px;'>列名</td>"
        + "<td style='width: 200px;'>错误值</td>"
        + "<td>错误信息</td>"
        + "</tr>"
        + "</thead>"
        + "<tbody>";
    let html = '';
    for (var i = 0; i < result.data.length; i++) {
        html += "<tr>"
            + "<td style='width: 80px;'>" + (i + 1) + "</td>"
            + "<td style='width: 120px;'>" + result.data[i].errorRow + "</td>"
            + "<td style='width: 200px;'>" + result.data[i].errorLine + "</td>"
            + "<td style='width: 200px;'>" + result.data[i].errorData + "</td>"
            + "<td>" + result.data[i].errorMsg + "</td>"
            + "</tr>";
    }

    tableStr += html + "</tbody></table>";
    $("#tableAjax").empty().append(tableStr);
    $('#myModal_edit').modal('show');
}

function excelUpload6(element, url, cityId) {
    // 加载提示
    var loadingMsg = layer.msg('数据导入中,请稍候...', {
        icon: 16,
        scrollbar: false,
        time: 0,
        shade: [0.01, '#393D49']
    });
    //④创建一个formData对象
    var formData = new FormData();
    //⑤获取传入元素的val
    var name = $(element).val();
    //⑥获取files
    var files = $(element)[0].files[0];
    //⑦将name 和 files 添加到formData中，键值对形式
    formData.append("file", files);
    formData.append("name", name);
    formData.append("cityName", cityId);
    formData.append("token", token);
    $.ajax({
        url: url,
        type: 'POST',
        headers: {
            "encrypt": sm3(JSON.stringify(formData))
        },
        data: formData,
        dataType: 'json',
        processData: false,// ⑧告诉jQuery不要去处理发送的数据
        contentType: false, // ⑨告诉jQuery不要去设置Content-Type请求头
        beforeSend: function () {
        },
        success: function (result) {
            layer.close(loadingMsg);
            $(element).val("");
            if (result.code === 200) {
                layer.confirm(result.msg, {
                    btn: ['确认', '关闭'] //按钮
                    ,
                    cancel: function (index, layero) {
                        //取消操作，点击右上角的X
                    }
                }, function () {
                    //是
                    query();
                    layer.closeAll();
                }, function () {
                    //否
                    query();
                });
            } else {
                layer.msg(result.msg, {icon: 2})
            }
        },
        error: function (result) {
            layer.close(loadingMsg);
            $(element).val("");
            $.dialog({title: '提示', content: result.msg});
        }
    });
}

function excelUpload7(element, url) {
    // 导入提示
    let loadingMsg = layer.msg('数据导入中,请稍候...', {icon: 16, scrollbar: false, time: 0});
    //④创建一个formData对象
    let formData = new FormData();
    //⑤获取传入元素的val
    //⑥获取files
    let files = $(element)[0].files[0];
    //⑦将name 和 files 添加到formData中，键值对形式
    formData.append("file", files);
    $.ajax({
        headers: {
            "encrypt": sm3(JSON.stringify({}))
        },
        url: url,
        type: 'POST',
        data: formData,
        dataType: 'json',
        processData: false,// ⑧告诉jQuery不要去处理发送的数据
        contentType: false, // ⑨告诉jQuery不要去设置Content-Type请求头
        beforeSend: function () {
        },
        success: function (result) {
            layer.close(loadingMsg);
            $(element).val("");
            if (result.success) {
                query();
                layer.msg('导入成功', {icon: 1});
            } else {
                showModal2(result);
            }
        },
        error: function (result) {
            layer.close(loadingMsg);
            $(element).val("");
            $.dialog({title: '提示', content: result.msg});
        }
    });
}

function excelUpload8(element,proNo, url) {
    // 导入提示
    let loadingMsg = layer.msg('数据导入中,请稍候...', {icon: 16, scrollbar: false, time: 0});
    //④创建一个formData对象
    let formData = new FormData();
    //⑤获取传入元素的val
    //⑥获取files
    let files = $(element)[0].files[0];
    //⑦将name 和 files 添加到formData中，键值对形式
    formData.append("file", files);
    formData.append("proNo", proNo);
    $.ajax({
        headers: {
            "encrypt": sm3(JSON.stringify({}))
        },
        url: url,
        type: 'POST',
        data: formData,
        dataType: 'json',
        processData: false,// ⑧告诉jQuery不要去处理发送的数据
        contentType: false, // ⑨告诉jQuery不要去设置Content-Type请求头
        beforeSend: function () {
        },
        success: function (result) {
            layer.close(loadingMsg);
            $(element).val("");
            if (result.success) {
                reloadData();
                layer.msg('导入成功', {icon: 1});
            } else {
                showModal2(result);
            }
        },
        error: function (result) {
            layer.close(loadingMsg);
            $(element).val("");
            $.dialog({title: '提示', content: result.msg});
        }
    });
}

function excelUpload9(element,type, url) {
    // 导入提示
    let loadingMsg = layer.msg('数据导入中,请稍候...', {icon: 16, scrollbar: false, time: 0});
    //④创建一个formData对象
    let formData = new FormData();
    //⑤获取传入元素的val
    //⑥获取files
    let files = $(element)[0].files[0];
    //⑦将name 和 files 添加到formData中，键值对形式
    formData.append("file", files);
    formData.append("type", type);
    $.ajax({
        headers: {
            "encrypt": sm3(JSON.stringify({}))
        },
        url: url,
        type: 'POST',
        data: formData,
        dataType: 'json',
        processData: false,// ⑧告诉jQuery不要去处理发送的数据
        contentType: false, // ⑨告诉jQuery不要去设置Content-Type请求头
        beforeSend: function () {
        },
        success: function (result) {
            layer.close(loadingMsg);
            $(element).val("");
            if (result.success) {
                reloadData();
                layer.msg('导入成功', {icon: 1});
            } else {
                showModal2(result);
            }
        },
        error: function (result) {
            layer.close(loadingMsg);
            $(element).val("");
            $.dialog({title: '提示', content: result.msg});
        }
    });
}