<!DOCTYPE html>
|
<html xmlns="http://www.w3.org/1999/xhtml">
|
<head>
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
<title>产量汇报单列表</title>
|
<meta name="renderer" content="webkit">
|
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
|
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
|
<link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
|
<link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
|
<style>
|
.layui-form-select .layui-input {
|
padding-right: 15px;
|
cursor: pointer;
|
}
|
|
</style>
|
<script src="../../../layuiadmin/layui/layui.js"></script>
|
|
</head>
|
<body>
|
<div class="layui-fluid">
|
<div class="layui-col-md12">
|
<div class="layui-card" style="padding: 1px">
|
<div class="layui-card-header">
|
<button type="button" class="layui-btn" lay-submit="" lay-filter="Delete"><i class="layui-icon layui-icon-add"></i>删除</button>
|
<button type="button" class="layui-btn" lay-submit="" lay-filter="AskReport"><i class="layui-icon layui-icon-add"></i>申请检验</button>
|
<button type="button" class="layui-btn" lay-submit="" lay-filter="Exit"><i class="layui-icon layui-icon-add"></i>退出</button>
|
<span style="margin:0 30%;font-size:24px;font-weight:bold;">产量汇报</span>
|
</div>
|
<div class="layui-card-body" style="padding: 1px;">
|
|
<form class="layui-form" action="" lay-filter="component-form-group">
|
<div class="layui-collapse">
|
<div class="layui-colla-item">
|
<div class="layui-colla-title layui-inline">
|
<div class="layui-inline">
|
<span>更多</span>
|
</div>
|
</div>
|
|
<div class="layui-inline">
|
<label class="layui-form-label">开始日期</label>
|
<div class="layui-input-block">
|
<input type="date" class="layui-input" id="HDate" style="width:190px;">
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label">结束日期</label>
|
<div class="layui-input-block">
|
<input type="date" class="layui-input" id="HDate1" style="width:190px;">
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label">单据号</label>
|
<div class="layui-input-block">
|
<input type="text" class="layui-input" name="HBillNo" id="HBillNo" style="width:190px;">
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label">物料信息</label>
|
<div class="layui-input-block">
|
<input type="text" class="layui-input" name="Part" id="Part" style="width:190px;">
|
</div>
|
</div>
|
|
<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
|
<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
|
</button>
|
<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>
|
<div class="layui-colla-content">
|
<div class="layui-inline">
|
<div class="layui-inline">
|
<span>其他条件></span>
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label">生产资源</label>
|
<div class="layui-input-block">
|
<input type="text" class="layui-input" name="Source" id="Source" style="width:190px;">
|
</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="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>预览</button>-->
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add"><i class="layui-icon layui-icon-add-1"></i>新增</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-edit"></i>编辑</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete"><i class="layui-icon layui-icon-delete"></i>删除</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Audit"><i class="layui-icon layui-icon-radio"></i>审核</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeAudit"><i class="layui-icon layui-icon-circle"></i>反审核</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload" style="display:none;"><i class="layui-icon layui-icon-refresh"></i>刷新</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-confirm" id="btn_confirm" style="display:none;"><i class="layui-icon layui-icon-ok-circle"></i>确认</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back" id="btn_back" style="display:none;"><i class="layui-icon layui-icon-close-fill"></i>驳回</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details" style="display:none;"><i class="layui-icon layui-icon-form"></i>详情</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate" style="display:none;"><i class="layui-icon layui-icon-file"></i>生成送货单</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit" style="display:none;"><i class="layui-icon layui-icon-return"></i>退出</button>
|
|
|
</div>
|
</script>
|
</form>
|
</div>
|
</div>
|
</div>
|
</div>
|
<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>
|
//获取参数
|
var workcode = ""; //工单号
|
var HSourceID = ""; //资源ID
|
|
function getUrlVars() {
|
var vars = [], hash;
|
var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');
|
for (var i = 0; i < hashes.length; i++) {
|
hash = hashes[i].split('=');
|
vars.push(hash[0]);
|
vars[hash[0]] = hash[1];
|
}
|
return vars;
|
}
|
|
var params = getUrlVars();
|
var hID = params[params[0]];//编辑查看
|
var Type = params[params[1]];//单据编辑状态: 1.无源单新增 2.有源单新增 3.编辑 4.浏览 5.变更
|
|
var edit = function (data) {
|
workcode = data[0].workcode;
|
HSourceID = data[0].HSourceID;
|
HSourceName = data[0].HSourceName;
|
}
|
|
layui.config({
|
base: '../../../layuiadmin/' //静态资源所在路径
|
}).extend({
|
index: 'lib/index', //主入口模块
|
}).use(['index', 'form', 'table', 'element', 'laypage','laydate'], function () {
|
var $ = layui.$
|
, admin = layui.admin
|
, layer = layui.layer
|
, table = layui.table
|
, form = layui.form
|
, element = layui.element
|
, laypage = layui.laypage
|
, laydate = layui.laydate
|
|
var sWhere = "";
|
|
var option = {
|
elem: '#mainTable'
|
,height: 'full-50'
|
, page: true
|
,cellMinWidth: 90
|
, cols: [[
|
{ type: 'checkbox', fixed: 'left' }
|
, { field: 'hmainid', title: 'hmainid', sort: true, hide: true, width: 200}
|
, { field: 'HDate', title: '日期', width: 160,templet: "<div>{{d.日期 ==null ?'':layui.util.toDateString(d.日期, 'yyyy-MM-dd')}}</div>"}
|
, { field: 'HBillNo', title: '单据号', width: 200}
|
, { field: 'HBillType', title: '单据类型', width: 200 }
|
, { field: 'HICMOBillNo', title: '生产订单号', width: 200 }
|
, { field: 'HICMOInterID', title: '生产订单主ID', width: 200, hide: true}
|
, { field: 'HICMOEntryID', title: '生产订单子ID', width: 200, hide: true}
|
, { field: 'HSourceBillNo', title: '源单单号', width: 200 }
|
, { field: 'HSourceInterID', title: '源单主内码', width: 200, hide: true}
|
, { field: 'HSourceEntryID', title: '源单子内码', width: 200, hide: true}
|
, { field: 'HSourceBillType', title: '源单类型', width: 200 }
|
, { field: 'HMaterID', title: '产品ID', width: 200, hide: true}
|
, { field: 'HMaterCode', title: '产品代码', width: 200 }
|
, { field: 'HMaterName', title: '产品名称', width: 200 }
|
, { field: 'HMaterSpec', title: '产品规格', width: 200 }
|
, { field: 'HQty', title: '汇报数量', width: 200 }
|
, { field: 'HSourceID', title: '生产资源ID', width: 200, hide: true}
|
, { field: 'HSourceCode', title: '生产资源代码', width: 200 }
|
, { field: 'HSourceName', title: '生产资源', width: 200 }
|
, { field: 'HGroupID', title: '生产班组ID', width: 200, hide: true}
|
, { field: 'HGroupCode', title: '生产班组代码', width: 200 }
|
, { field: 'HGroupName', title: '生产班组名称', width: 200 }
|
, { field: 'HWorkManID', title: '操作员ID', width: 200, hide: true}
|
, { field: 'HWorkManName', title: '操作员', width: 200 }
|
, { field: 'HMaker', title: '制单人', width: 200 }
|
, { field: 'HMakeDate', title: '制单日期', width: 160, templet: "<div>{{d.日期 ==null ?'':layui.util.toDateString(d.日期, 'yyyy-MM-dd')}}</div>" }
|
, { field: 'HReportType', title: '汇报类型', width: 200 }
|
]]
|
};
|
var index = layer.load(0, { shade: false });
|
|
//有源单新增
|
if (Type != 2)
|
{
|
sWhere = " where a.HSourceID='" + HSourceID + "' and a.HICMOBillNo='" + workcode + "'";
|
//进入页面显示的缓存列表
|
$.ajax({
|
url: GetWEBURL() + '/Sc_MESBeginWorkBill/GetMESProductReportBillList',
|
type: "GET",
|
data: { "sWhere": sWhere },
|
success: function (data1) {
|
if (data1.count == 1) {
|
option.data = data1.data;
|
table.render(option);
|
layer.close(index);
|
} else {
|
layer.close(index);
|
layer.alert(data1.code + data1.Message, { icon: 5 });
|
}
|
}, error: function () {
|
layer.close(index);
|
layer.alert("接口请求失败!", { icon: 5 });
|
}
|
});
|
}
|
|
|
//删除按钮
|
form.on('submit(Delete)', function (data)
|
{
|
var checkStatus = table.checkStatus('mainTable')
|
, data = checkStatus.data;
|
if (checkStatus.data.length === 1) {
|
var InterID = data[0].hmainid.toString();
|
//逻辑删除方法
|
layer.confirm("确认要删除吗,删除后不能恢复", { title: "删除确认" }, function (index) {
|
$.ajax({
|
type: "GET",
|
url: GetWEBURL() + "Sc_ICMOReportBill/DeltetICMOReportBill", //方法所在页面和方法名
|
data: { "HInterID": InterID },
|
success: function (result) {
|
if (result.count == 1) {
|
layer.msg(result.Message, { time: 1 * 2000, icon: 1 });
|
table.reload('mainTable', {
|
page: {
|
curr:1 //重新从第一页开始
|
}
|
})
|
return false;
|
|
} else {
|
layer.alert(result.code + result.Message, { icon: 5 });
|
return false;
|
}
|
}, error: function () {
|
layer.alert("接口请求失败!", { icon: 5 });
|
return false;
|
}
|
});
|
})
|
}
|
else {
|
layer.msg('请选择一行数据删除!');
|
}
|
})
|
|
//重置按钮
|
form.on('submit(btnReSearch)', function (data) {
|
$("#HDate").val("");//开始日期
|
$("#HDate1").val("");//结束日期
|
$("#HBillNo").val("");
|
$("#Part").val("");
|
$("#Source").val("");
|
});
|
|
//查询按钮
|
form.on('submit(btnSearch)', function (data) {
|
var HDate = $("#HDate").val();//开始日期
|
var HDate1 = $("#HDate1").val();//结束日期
|
var HBillNo = $("#HBillNo").val(); //单据号
|
var Part = $("#Part").val(); //物料信息
|
var Source = $("#Source").val(); //资源
|
if (HDate) {
|
sWhere += " and CONVERT(varchar(100),a.HDate, 23) >= '" + HDate + "'";
|
}
|
if (HDate1) {
|
sWhere += " and CONVERT(varchar(100),a.HDate, 23) <= '" + HDate1 + "'";
|
}
|
if (HBillNo) {
|
sWhere += " and a.HBillNo like '%" + HBillNo + "%'";
|
}
|
if (Part) {
|
sWhere += " and concat(m.HNumber,m.HName,m.HModel) like '%" + Part + "%'";
|
}
|
if (Source) {
|
sWhere += " and s.HName like '%" + Dept + "%'";
|
}
|
$.ajax({
|
//url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum",
|
url: GetWEBURL() + '/Sc_ICMOReportBill/list',
|
type: "GET",
|
data: { "sWhere": sWhere },
|
success: function (data1) {
|
if (data1.count == 1) {
|
option.data = data1.data;
|
table.render(option);
|
layer.alert("查询成功", { icon: 1 });
|
} else {
|
layer.alert(data1.code + data1.Message, { icon: 5 });
|
}
|
}, error: function () {
|
layer.alert("接口请求失败!", { icon: 5 });
|
}
|
});
|
sWhere = "";//调用接口后清空sWhere缓存
|
});
|
//以上是layui模块
|
});
|
|
|
|
|
</script>
|
|
</body>
|
</html>
|