494 lines
16 KiB
JavaScript
494 lines
16 KiB
JavaScript
|
|
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});
|
|||
|
|
}
|
|||
|
|
});
|
|||
|
|
}
|