<!DOCTYPE html>
|
<html>
|
<head>
|
<meta charset="utf-8" />
|
<title>生产日计划导入</title>
|
<link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
|
<link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
|
<script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
|
<script src="../../../layuiadmin/layui/layui.js"></script>
|
<script src="../../../layuiadmin/Scripts/json2.js"></script>
|
<script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
|
<script src="../../../layuiadmin/Scripts/webConfig.js"></script>
|
<script src="../../../layuiadmin/PubCustom.js"></script>
|
<style>
|
.main-btn { /*头部主按钮*/
|
padding: 0 2px; /*调整按钮左右空隙大小*/
|
height: 30px;
|
line-height: 30px;
|
}
|
|
.btn-title {
|
font-size: 16px;
|
}
|
/* 防止下拉框的下拉列表被隐藏---必须设置--- */
|
.layui-table-cell {
|
overflow: visible !important;
|
}
|
/* 使得下拉框与单元格刚好合适 */
|
td .layui-form-select {
|
margin-top: -10px;
|
margin-left: -15px;
|
margin-right: -15px;
|
}
|
|
.layui-form-item .layui-inline {
|
margin-top: 5px;
|
margin-bottom: 5px;
|
margin-right: 0px;
|
}
|
|
.layui-form-label {
|
width: 25%;
|
}
|
</style>
|
</head>
|
<body>
|
<div class="layui-fluid" style="padding: 0;">
|
<div class="layui-card" style="padding: 2px;background-color: #efefef;">
|
<div class="layui-card-body" style="padding: 1px;">
|
<form class="layui-form" action="" lay-filter="formData" style="background-color:white;">
|
<div style="padding: 10px; ">
|
<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">导入</button>
|
<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Cancel" id="Cancel">退出</button>
|
<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="UpLoad" id="UpLoad">文件上传</button>
|
</div>
|
<div class="layui-tab" lay-filter="tab-POStockInBill">
|
<div class="layui-tab-content">
|
<!--基本信息-->
|
<div class="layui-tab-item layui-show">
|
<div class="layui-form-item" style="padding-top: 10px;">
|
<div class="layui-row">
|
<div class="layui-inline">
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 85px;">单据日期</label>
|
<div class="layui-input-block" style="margin-left: 120px;">
|
<input type="date" class="layui-input" lay-verify="HDate" name="HDate" id="HDate" style="padding-left: 75px;">
|
</div>
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 85px;">订单类型</label>
|
<div class="layui-input-block" style="margin-left: 120px; width: 185px;">
|
<select name="HProdORGID" id="HProdORGID" lay-verify="HProdORGID">
|
<option value="生产订单">生产订单</option>
|
<option value="委外订单">委外订单</option>
|
</select>
|
</div>
|
</div>
|
<!--<div class="layui-inline">
|
<div class="layui-inline">
|
<div class="layui-input-block" style="margin-left: 120px;">
|
<input type="file" class="layui-upload-form" lay-verify="file" name="file" id="file" style="padding-left: 75px;">
|
</div>
|
</div>
|
</div>-->
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
|
<table class="" id="mainTable" lay-filter="mainTable"></table>
|
<script type="text/html" id="toolbarDemo">
|
<div class="layui-btn-container">
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_AddNew"><i class="layui-icon layui-icon-file-b"></i>批量填充</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>删除行</button>
|
</div>
|
</script>
|
</form>
|
</div>
|
</div>
|
</div>
|
</body>
|
</html>
|
<script>
|
|
layui.config({
|
base: '../../../layuiadmin/' //静态资源所在路径
|
}).extend({
|
index: 'lib/index' //主入口模块
|
}).use(['index', 'form', 'laydate', 'table', 'element','upload'], function () {
|
|
//#region 公共变量
|
|
var $ = layui.$
|
, admin = layui.admin
|
, layer = layui.layer
|
, table = layui.table
|
, form = layui.form
|
, laydate = layui.laydate
|
, excel = layui.excel
|
, upload = layui.upload
|
, element = layui.element;
|
|
|
//#endregion
|
|
//#region 进入页面即加载
|
|
//初始化界面
|
set_ClearBill();
|
|
//#endregion
|
|
//#region 触发事件：包括form.on(){}格式的所有点击事件、选择事件等
|
|
//导入
|
form.on('submit(UpLoad)', function () {
|
var uploadInst = upload.render({
|
elem: '#UpLoad',
|
type: 'POST',
|
url: GetWEBURL() + '/JIT_DayPlanPlatFormImport/JIT_DayPlanPlatFormImport_DR',
|
accept: 'file', //普通文件
|
exts: 'xls|excel|xlsx', //导入表格
|
auto: false, //选择文件后不自动上传
|
before: function (obj) {
|
layer.load(); //上传loading
|
},
|
choose: function (obj) {// 选择文件回调
|
alert(obj)
|
var files = obj.pushFile();
|
var fileArr = Object.values(files);// 注意这里的数据需要是数组，所以需要转换一下
|
//console.debug(fileArr)
|
// 用完就清理掉，避免多次选中相同文件时出现问题
|
for (var index in files) {
|
if (files.hasOwnProperty(index)) {
|
delete files[index];
|
}
|
}
|
}, error: function () {
|
setTimeout(function () {
|
layer.msg("上传失败！", {
|
icon: 1
|
});
|
layer.closeAll(); //疯狂模式，关闭所有层
|
}, 1000);
|
}
|
});
|
})
|
|
|
//#endregion
|
|
//#region 此页面所有的方法
|
|
//#region 初始化界面
|
function set_ClearBill() {
|
//初始化时间
|
$("#HDate").val(Format(new Date(), "yyyy-MM-dd"));
|
//初始化表格
|
set_InitGrid();
|
}
|
|
//初始化表格
|
function set_InitGrid() {
|
table.render({
|
elem: '#mainTable'
|
, toolbar: '#toolbarDemo'
|
, height: 'full-50'
|
, page: true
|
, cellMinWidth: 90
|
, limit: 50
|
, limits: [50, 500, 5000, 20000]
|
, loading: false
|
, cols: [[
|
{ type: 'checkbox', fixed: 'left' }
|
, { field: 'hmainid', title: 'hmainid', hide: true }
|
, { field: '单据类型', title: '单据类型', width: 120 }
|
, { field: '日期', title: '要料日期' }
|
, { field: '单据号', title: '单据号' }
|
, { field: '单据状态', title: '单据状态' }
|
, { field: '表头备注', title: '表头备注' }
|
, { field: '退回人', title: '退回人' }
|
, { field: '退回日期', title: '退回日期' }
|
, { field: '审核人', title: '审核人' }
|
, { field: '审核日期', title: '审核日期' }
|
, { field: '制单人', title: '制单人' }
|
, { field: '制单日期', title: '制单日期' }
|
, { field: '修改人', title: '修改人' }
|
, { field: '修改日期', title: '修改日期' }
|
, { field: '关闭人', title: '关闭人' }
|
, { field: '关闭日期', title: '关闭日期' }
|
, { field: '关闭类型', title: '关闭类型' }
|
, { field: '作废人', title: '作废人' }
|
, { field: '作废日期', title: '作废日期' }
|
, { field: '主生产组织', title: '生产组织' }
|
, { field: '车间名称', title: '生产车间' }
|
, { field: '源单单号', title: '生产订单号' }
|
, { field: '数量', title: '数量' }
|
, { field: '计量单位', title: '计量单位' }
|
, { field: '物料名称', title: '物料名称' }
|
, { field: '物料代码', title: '物料代码' }
|
, { field: '规格型号', title: '规格型号' }
|
, { field: '工单生产日期', title: '工单生产日期' }
|
, { field: '延迟原因', title: '延迟原因' }
|
]]
|
});
|
}
|
|
|
//#endregion
|
|
});
|
|
</script>
|
