From c4e556a509b7fd8084a4aee8f4221158bac6cd3a Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期一, 25 三月 2024 13:11:56 +0800
Subject: [PATCH] 设备负荷分析表
---
WebTM/views/生产工序管理/工序计划单/Sc_ProcessPlanList.html | 729 ++++++++++++++++++++++++++++++++++++++++---------------
1 files changed, 522 insertions(+), 207 deletions(-)
diff --git "a/WebTM/views/\347\224\237\344\272\247\345\267\245\345\272\217\347\256\241\347\220\206/\345\267\245\345\272\217\350\256\241\345\210\222\345\215\225/Sc_ProcessPlanList.html" "b/WebTM/views/\347\224\237\344\272\247\345\267\245\345\272\217\347\256\241\347\220\206/\345\267\245\345\272\217\350\256\241\345\210\222\345\215\225/Sc_ProcessPlanList.html"
index 114d5fa..7616995 100644
--- "a/WebTM/views/\347\224\237\344\272\247\345\267\245\345\272\217\347\256\241\347\220\206/\345\267\245\345\272\217\350\256\241\345\210\222\345\215\225/Sc_ProcessPlanList.html"
+++ "b/WebTM/views/\347\224\237\344\272\247\345\267\245\345\272\217\347\256\241\347\220\206/\345\267\245\345\272\217\350\256\241\345\210\222\345\215\225/Sc_ProcessPlanList.html"
@@ -1,7 +1,7 @@
锘�<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
-<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
+ <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">
@@ -9,7 +9,13 @@
<link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
<link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
<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>
+ <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
+ <script src="../../../layuiadmin/soulTable.slim.js"></script>
+
</head>
<body>
<div class="layui-fluid">
@@ -27,36 +33,67 @@
<div class="layui-inline">
<label class="layui-form-label">寮�濮嬫棩鏈�</label>
<div class="layui-input-block">
- <input type="date" class="layui-input" id="HDate">
+ <input type="date" class="layui-input" id="HBeginDate" 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">
+ <input type="date" class="layui-input" id="HEndDate" style="width:190px;">
</div>
</div>
- <!--<div class="layui-inline">
- <label class="layui-form-label">璁㈠崟璺熻釜鍙�</label>
+ <div class="layui-inline">
+ <label class="layui-form-label">鍗曟嵁鍙�</label>
<div class="layui-input-block">
- <input type="text" class="layui-input" name="HOrderProcNO" id="HOrderProcNO">
+ <input type="text" class="layui-input" name="HBillNo" id="HBillNo" style="width:190px;">
</div>
- </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>
+ <label class="layui-form-label">閮ㄩ棬</label>
+ <div class="layui-input-block">
+ <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;">
</div>
</div>
<div class="layui-inline">
- <label class="layui-form-label">鍗曟嵁鍙�</label>
+ <label class="layui-form-label">鐗╂枡浠ｇ爜</label>
<div class="layui-input-block">
- <input type="text" class="layui-input" name="WorkCenter" id="WorkCenter">
+ <input type="text" class="layui-input" name="MaterialCode" id="MaterialCode" style="width:190px;">
+ </div>
+ </div>
+ <!--<hr />-->
+ <div class="layui-inline">
+ <label class="layui-form-label">鐗╂枡鍚嶇О</label>
+ <div class="layui-input-block">
+ <input type="text" class="layui-input" name="MaterialName" id="MaterialName" 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="SpecificationModel" id="SpecificationModel" 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="HSourceBillNo" id="HSourceBillNo" 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="Warehouse" id="Warehouse" 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="Hmaker" id="Hmaker" style="width:190px;">
</div>
</div>
</div>
@@ -65,10 +102,17 @@
<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-reload"><i class="layui-icon layui-icon-refresh"></i>鍒锋柊</button>-->
- <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Pushdown"><i class="layui-icon layui-icon-form"></i>涓嬫帹</button>
- <button type="button" class="layui-btn layui-btn-sm" lay-event="add"><i class="layui-icon"></i>娣诲姞</button>
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Pushdown"><i class="layui-icon layui-icon-form"></i>涓嬫帹娲惧伐鍗�</button>
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-PushdownWWorder"><i class="layui-icon layui-icon-form"></i>涓嬫帹濮斿宸ュ崟</button>
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add"><i class="layui-icon layui-icon-file-b"></i>鏂板</button>
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></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="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>鍒锋柊</button>
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></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-view"><i class="layui-icon layui-icon-tips"></i>棰勮</button>
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print"><i class="layui-icon layui-icon-print"></i>鎵撳嵃</button>
</div>
</script>
@@ -79,247 +123,518 @@
</div>
<script type="text/html" id="barDemo">
- <a class="layui-btn layui-btn-xs" lay-event="edit">缂栬緫</a>
- <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">鍒犻櫎</a>
-</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>
+ <a class="layui-btn layui-btn-xs" lay-event="edit">缂栬緫</a>
+ <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">鍒犻櫎</a>
+ </script>
<script>
layui.config({
base: '../../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰�
}).extend({
index: 'lib/index', //涓诲叆鍙ｆā鍧�
- }).use(['index', 'form', 'table', 'element', 'laypage','laydate'], function () {
+ }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate','soulTable'], function () {
+
+ //#region 鍏叡鍙橀噺
+
var $ = layui.$
- , admin = layui.admin
- , layer = layui.layer
- , table = layui.table
- , form = layui.form
- , element = layui.element
- , laypage = layui.laypage
- , laydate = layui.laydate
+ , admin = layui.admin
+ , layer = layui.layer
+ , table = layui.table
+ , form = layui.form
+ , element = layui.element
+ , laypage = layui.laypage
+ , laydate = layui.laydate
+ , soulTable = layui.soulTable
//var sWhere = " 浜у搧浠ｇ爜 = 'BX0002'";
var sWhere = "";
+ var option = [];
+ //#endregion
- var option = {
- elem: '#mainTable'
- , toolbar: '#toolbarDemo'
- ,height: 'full-50'
- , page: true
- ,cellMinWidth: 90
- , cols: [[
- { type: 'checkbox' }
- //{ field: 'hmainid', title: 'hmainid', sort: true, width: 165 }
- , { field: 'HInterID', title: 'HInterID', sort: true, fixed: true, hide: true }
- ,{ field: 'HDate', title: '鏃ユ湡', sort: true, width: 120 }
- , { field: 'HBillNo', title: '鍗曟嵁鍙�', sort: true, width: 170 }
- //, { field: 'HBillStatus ', title: '鍗曟嵁鐘舵��', width: 105 }
- , { field: 'HICMOBillNo', title: '浠诲姟鍗曞彿' }
- ////, { field: 'hunitid', title: 'hunitid' }
- , { field: 'HMaterID ', title: '浜у搧ID ', width: 115 }
- , { field: 'HMaterNumber', title: '浜у搧浠ｇ爜' }
- ////, { field: 'hempid', title: 'hempid' }
- , { field: 'HUnitID', title: '鍗曚綅ID', width: 100 }
- , { field: 'HUnitNumber', title: '鍗曚綅浠ｇ爜' }
- , { field: 'HPlanQty', title: '璁″垝鏁伴噺' }
- , { field: 'HPlanBeginDate', title: '璁″垝寮�宸ユ棩鏈�' }
- , { field: 'HPlanEndDate', title: '璁″垝瀹屽伐鏃ユ湡' }
- ////, { field: 'HCenterID', title: 'HCenterID' }
- , { field: 'HExplanation', title: '鎽樿' }
- , { field: 'HRemark ', title: '澶囨敞' }
- ////, { field: 'hbomid', title: 'hbomid' }
- , { field: 'HInnerBillNo', title: '鍐呴儴鍗曟嵁鍙�' }
- , { field: 'HSupID', title: '濮斿鍔犲伐鍗曚綅' }
- , { field: 'HMarker', title: '妫�楠屼汉' }
- , { field: 'HBacker', title: '閫�鍥炰汉' }
- , { field: 'HBackDate', title: '閫�鍥炴棩鏈�' }
- , { field: 'HChecker', title: '瀹℃牳浜�' }
- , { field: 'HCheckDate', title: '瀹℃牳鏃ユ湡' }
- , { field: 'HMaker', title: '鍒跺崟浜�' }
- , { field: 'HMakeDate', title: '鍒跺崟鏃ユ湡' }
- , { field: 'HUpDater', title: '淇敼浜�' }
- , { field: 'HUpDateDate', title: '淇敼鏃ユ湡' }
- , { field: 'HCloseMan', title: '鍏抽棴浜�' }
- , { field: 'HCloseDate', title: '鍏抽棴鏃ユ湡' }
- , { field: 'HCloseType', title: '鍏抽棴绫诲瀷' }
- ////, { field: 'hsubid', title: 'hsubid' }
- , { field: 'HDeleteMan', title: '浣滃簾浜�' }
- , { field: 'HDeleteDate', 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: '璁″垝璺熻釜鍙�' }
- //,{fixed: 'right', title:'鎿嶄綔', toolbar: '#barDemo', width:150}
- ]]
- };
+ //#region 鍒濆鍖栫晫闈�
+ set_ClearBill();
+ //#endregion
-
-//鐩戝惉琛屽伐鍏蜂簨浠�
- //table.on('tool(mainTable)', function(obj){
- // var data = obj.data;
- // //console.log(obj)
- // if(obj.event == 'del'){
- // layer.confirm('鐪熺殑鍒犻櫎琛屼箞', function(index){
- // obj.del();
- // layer.close(index);
- // });
- // } else if(obj.event == 'edit'){
- // layer.prompt({
- // formType: 2
- // ,value: data.HDate
- // }, function(value, index){
- // obj.update({
- // HDate: value
- // });
- // layer.close(index);
- // });
- // //layer.alert('鎴戞槸缂栬緫涓�');
- // }
- //});
+ //#region 瑙﹀彂浜嬩欢锛氬寘鎷琭orm.on(){}鏍煎紡鐨勬墍鏈夌偣鍑讳簨浠躲�侀�夋嫨浜嬩欢绛�
+
//澶村伐鍏锋爮浜嬩欢
table.on('toolbar(mainTable)', function (obj) {
var checkStatus = table.checkStatus(obj.config.id);
switch (obj.event) {
+ //涓嬫帹娲惧伐鍗�
case 'btn-Pushdown':
var checkStatus = table.checkStatus('mainTable')
- , data = checkStatus.data;
+ , data = checkStatus.data;
ajaxLabelData = data;
var rows = '';
var HEntry = '';
- if (checkStatus.data.length < 1)
- {
+ for (var i = 0; i < data.length; i++) {
+ rows += data[i].hmainid.toString() + ',';
+ }
+
+ if (checkStatus.data.length < 1) {
layer.msg('璇烽�夋嫨涓�琛屾暟鎹笅鎺�');
- } else
- {
-
- //椤甸潰灞�
- layer.open({
- type: 2 //Page灞傜被鍨�
- ,area: ['100%', '100%']
- ,title: '鏂板娲惧伐鍗�'
- ,shade: 0.6 //閬僵閫忔槑搴�
- ,maxmin: false //鍏佽鍏ㄥ睆鏈�灏忓寲
- , anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚�
- , content: ['../宸ュ簭娲惧伐鍗�/Sc_Add_ProcessSendWork.html?HInterID=' + data[0].HInterID.toString(),'yes']
- , resize: false
- , cancel: function () {
- //$(".layui-btn").removeClass("layui-btn-disabled");
- }
-
- });
-
+ } else {
+
+ //椤甸潰灞�
+ layer.open({
+ type: 2 //Page灞傜被鍨�
+ , area: ['100%', '100%']
+ , title: '鏂板娲惧伐鍗�'
+ , shade: 0.6 //閬僵閫忔槑搴�
+ , maxmin: false //鍏佽鍏ㄥ睆鏈�灏忓寲
+ , anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚�
+ , content: ['../宸ュ簭娲惧伐鍗�/Sc_Add_ProcessSendWork.html?HInterID=' + data[0].hmainid.toString() + '&lentryid=' + rows.toString().substring(0, rows.length - 1), '&PlanBeginDate=' + data[0].璁″垝寮�宸ユ棩鏈�.toString(), '&PlanEndDate=' + data[0].璁″垝瀹屽伐鏃ユ湡.toString(), 'yes']
+ , resize: false
+ , cancel: function () {
+ //$(".layui-btn").removeClass("layui-btn-disabled");
+ }
+ });
}
break;
- case 'add':
- layer.msg('娣诲姞');
- break;
- case '':
- layer.msg('');
- break;
+ //娣诲姞
+ case 'btn-Add':
+ //椤甸潰灞�-鑷畾涔�
+ layer.open({
+ type: 2,
+ skin: 'layui-layer-rim', //鍔犱笂杈规
+ title: '宸ュ簭璁″垝鍗�',
+ closeBtn: 1,
+ shift: 2,
+ area: ['100%', '100%'],
+ maxmin: true,
+ content: '../../鐢熶骇宸ュ簭绠＄悊/宸ュ簭璁″垝鍗�/Sc_ProcessPlanEdit.html?OperationType=1&linterid=0&HSouceBillType=0&linteridSub=-1',
+ end: function () {
+ //鍒锋柊椤甸潰,
+ location.reload();
+ },
+ success: function (layero, index) {
+ }
+ });
+ break;
+ //缂栬緫
+ case 'btn-Edit':
+ //鑾峰彇涓籭d浠ュ強瀛愰『搴廼d
+ var linterid = checkStatus.data[0].hmainid;
+ var linteridSub = checkStatus.data[0].hsubid;
+
+ //椤甸潰灞�-鑷畾涔�
+ layer.open({
+ type: 2,
+ skin: 'layui-layer-rim', //鍔犱笂杈规
+ title: '宸ュ簭璁″垝鍗�',
+ closeBtn: 1,
+ shift: 2,
+ area: ['100%', '100%'],
+ maxmin: true,
+ content: '../../鐢熶骇宸ュ簭绠＄悊/宸ュ簭璁″垝鍗�/Sc_ProcessPlanEdit.html?OperationType=3&linterid=' + linterid + '&HSouceBillType=0&linteridSub=' + linteridSub,
+ end: function () {
+ //鍒锋柊椤甸潰,
+ location.reload();
+ },
+ success: function (layero, index) {
+
+ }
+ });
+ break;
+ //涓嬫帹濮斿宸ュ崟
+ case 'btn-PushdownWWorder':
+ var checkStatus = table.checkStatus('mainTable')
+ , data = checkStatus.data;
+ ajaxLabelData = data;
+ var rows = '';
+ var HEntry = '';
+ for (var i = 0; i < data.length; i++) {
+ rows += data[i].hmainid.toString() + ',';
+ }
+ if (checkStatus.data.length < 1) {
+ layer.msg('璇烽�夋嫨涓�琛屾暟鎹笅鎺�');
+ } else {
+
+ //椤甸潰灞�
+ layer.open({
+ type: 2 //Page灞傜被鍨�
+ , area: ['100%', '100%']
+ , title: '鏂板濮斿宸ュ崟'
+ , shade: 0.6 //閬僵閫忔槑搴�
+ , maxmin: false //鍏佽鍏ㄥ睆鏈�灏忓寲
+ , anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚�
+ , content: ['../濮斿宸ュ崟/WW__Add_EntrustWorkOrderBill.html?HInterID=' + data[0].hmainid.toString() + '&lentryid=' + rows.toString().substring(0, rows.length - 1), 'yes']
+ , resize: false
+ , cancel: function () {
+ //$(".layui-btn").removeClass("layui-btn-disabled");
+ }
+ });
+ }
+ break;
+ //瀹℃牳
+ case 'btn-Audit': set_AuditBill();
+ break;
+ //鍙嶅鏍�
+ case 'btn-DeAudit': set_DeAuditBill();
+ break;
+ //鍒犻櫎
+ case 'btn-Delete': set_DeleteBill();
+ break;
};
});
- //杩涘叆椤甸潰鏄剧ず鐨勭紦瀛樺垪琛�
- var index0 = layer.load(0, { shade: false });
- $.ajax({
- //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum",
- url: GetWEBURL() + '/Sc_ProcessMangement/MES_Sc_ProcessPlanMain_Json',
- type: "GET",
- data: { "sWhere": sWhere },
- success: function (data1) {
- if (data1.count == 1) {
- option.data = data1.data;
- table.render(option);
- layer.close(index0);
- } else {
- layer.close(index0);
- layer.alert(data1.code + data1.Message, { icon: 5 });
- }
- }, error: function () {
- layer.close(index0);
- layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
- }
- });
-
//閲嶇疆鎸夐挳
form.on('submit(btnReSearch)', function (data) {
- $("#HDate").val("");//寮�濮嬫棩鏈�
- $("#HDate1").val("");//缁撴潫鏃ユ湡
- $("#HOrderProcNO").val("");//璁㈠崟璺熻釜鍙�
- $("#WorkCenter").val("");//鍗曟嵁鍙�
- $("#btnSearch").click();
+ //娓呯┖杩囨护鏉′欢
+ set_ClearQuery();
});
//鏌ヨ鎸夐挳
- form.on('submit(btnSearch)', function (data) {//閫夋嫨浠撲綅
- var HDate = $("#HDate").val();//寮�濮嬫棩鏈�
- var HDate1 = $("#HDate1").val();//缁撴潫鏃ユ湡
- var HOrderProcNO = $("#HOrderProcNO").val();//璁㈠崟璺熻釜鍙�
- var WorkCenter = $("#WorkCenter").val();//鍗曟嵁鍙�
- if (HDate) {
- sWhere += " and HDate >= '" + HDate + "'";
- }
- if (HDate1) {
- sWhere += " and HDate <= '" + HDate1 + "'";
- }
- if (HOrderProcNO) {
- sWhere += " and 璁㈠崟璺熻釜鍙� like '%" + HOrderProcNO + "%'";
- }
- if (WorkCenter) {
- sWhere += " and HBillNo like '%" + WorkCenter + "%'";
- }
- var index = layer.load(0, { shade: false });
+ form.on('submit(btnSearch)', function (data) {
+ get_FastQuery();
+ });
+ //#endregion
+
+ //#region 姝ら〉闈㈡墍鏈夌殑鏂规硶
+ // 鍒濆鍖栫晫闈�
+ function set_ClearBill() {
+ //鍒濆鍖栬〃鏍�
+ set_InitGrid();
+ //鏌ヨ
+ get_Display(sWhere);
+ //鍒濆鍖栨棩鏈�
+ $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
+ $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
+ }
+
+ //鍒濆鍖栬〃鏍�
+ function set_InitGrid() {
+ option = {
+ elem: '#mainTable'
+ , toolbar: '#toolbarDemo'
+ , height: 'full-50'
+ , page: true
+ , cellMinWidth: 90
+ , limit: 50
+ , totalRow: true
+ , limits: [50, 500, 5000, 20000]
+ , done: function (res, curr, count) {
+ soulTable.render(this);
+ }
+ , cols: [[
+ { type: 'checkbox' }
+ //{ field: 'hmainid', title: 'hmainid', sort: true, width: 165 }
+ , { field: 'hmainid', title: 'hmainid', sort: true, fixed: true, hide: true }
+ , { field: '鏃ユ湡', title: '鏃ユ湡', sort: true, width: 120, templet: "<div>{{d.鏃ユ湡 ==null ?'':layui.util.toDateString(d.鏃ユ湡, 'yyyy-MM-dd')}}</div>"}
+ , { field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�', sort: true, width: 170 }
+ , {
+ field: '鍗曟嵁绫诲瀷', title: '鍗曟嵁绫诲瀷', width: 200, sort: true, templet: function (d) {
+ switch (d.鍗曟嵁绫诲瀷) {
+ case 3715:
+ return "宸ュ簭璁″垝鍗�"
+ break;
+ case 3718:
+ return "宸ュ簭杩斿伐鍗�"
+ break;
+ default:
+ return d.HBillStatus
+ }
+ }
+ }
+ //, { field: 'HBillStatus ', title: '鍗曟嵁鐘舵��', width: 105 }
+ , { field: 'HMaterID', title: 'HMaterID', hide: true, sort: true }
+ ////, { field: 'hunitid', title: 'hunitid' , sort: true}
+ , { field: '鐗╂枡浠ｇ爜', title: '鐗╂枡浠ｇ爜 ', width: 115, sort: true }
+ , { field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О', sort: true }
+ ////, { field: 'hempid', title: 'hempid' , sort: true}
+ , { field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿', width: 100, sort: true }
+ , { field: 'HUnitNumber', title: '鍗曚綅浠ｇ爜', sort: true }
+ , { field: '鍗曚綅', title: '鍗曚綅', sort: true }
+ , { field: 'hunitid', title: 'hunitid', hide: true, sort: true }
+ , { field: '璁￠噺鍗曚綅浠ｇ爜', title: '璁￠噺鍗曚綅浠ｇ爜', sort: true }
+ ////, { field: 'HCenterID', title: 'HCenterID' , sort: true}
+ , { field: '璁￠噺鍗曚綅', title: '璁￠噺鍗曚綅', sort: true }
+ , { field: '鐢熶骇鏁伴噺', title: '鐢熶骇鏁伴噺', totalRow: true, sort: true }
+ ////, { field: 'hbomid', title: 'hbomid' , sort: true}
+ , { field: '璁″垝寮�宸ユ棩鏈�', title: '璁″垝寮�宸ユ棩鏈�', templet: "<div>{{d.璁″垝寮�宸ユ棩鏈� ==null ?'':layui.util.toDateString(d.璁″垝寮�宸ユ棩鏈�, 'yyyy-MM-dd')}}</div>", sort: true }
+ , { field: '璁″垝瀹屽伐鏃ユ湡', title: '璁″垝瀹屽伐鏃ユ湡', templet: "<div>{{d.璁″垝瀹屽伐鏃ユ湡 ==null ?'':layui.util.toDateString(d.璁″垝瀹屽伐鏃ユ湡, 'yyyy-MM-dd')}}</div>", sort: true }
+ , { field: '鎽樿', title: '鎽樿', sort: true }
+ , { field: '琛ㄥご澶囨敞', title: '琛ㄥご澶囨敞', sort: true }
+ , { field: '鍐呴儴鍗曟嵁鍙�', title: '鍐呴儴鍗曟嵁鍙�', sort: true }
+ , { field: 'hicmointerid', title: 'hicmointerid', hide: true, sort: true }
+ , { field: '浠诲姟鍗曞彿', title: '浠诲姟鍗曞彿', sort: true }
+ , { field: '鍒跺崟浜�', title: '鍒跺崟浜�', sort: true }
+ , { field: '鍒跺崟鏃ユ湡', title: '鍒跺崟鏃ユ湡', templet: "<div>{{d.鍒跺崟鏃ユ湡 ==null ?'':layui.util.toDateString(d.鍒跺崟鏃ユ湡, 'yyyy-MM-dd')}}</div>", sort: true }
+ , { field: '瀹℃牳浜�', title: '瀹℃牳浜�', sort: true }
+ , { field: '瀹℃牳鏃ユ湡', title: '瀹℃牳鏃ユ湡', templet: "<div>{{d.瀹℃牳鏃ユ湡 ==null ?'':layui.util.toDateString(d.瀹℃牳鏃ユ湡, 'yyyy-MM-dd')}}</div>", sort: true }
+ , { field: '淇敼浜�', title: '淇敼浜�', sort: true }
+ , { field: '淇敼鏃ユ湡', title: '淇敼鏃ユ湡', templet: "<div>{{d.淇敼鏃ユ湡 ==null ?'':layui.util.toDateString(d.淇敼鏃ユ湡, 'yyyy-MM-dd')}}</div>", sort: true }
+ , { field: '鍏抽棴浜�', title: '鍏抽棴浜�', sort: true }
+ ////, { field: 'hsubid', title: 'hsubid' , sort: true}
+ , { field: '鍏抽棴鏃ユ湡', title: '鍏抽棴鏃ユ湡', templet: "<div>{{d.鍏抽棴鏃ユ湡 ==null ?'':layui.util.toDateString(d.鍏抽棴鏃ユ湡, 'yyyy-MM-dd')}}</div>", sort: true }
+ , { field: '鍏抽棴绫诲瀷', title: '鍏抽棴绫诲瀷', sort: true }
+ , { field: '浣滃簾浜�', title: '浣滃簾浜�', sort: true }
+ , { field: '浣滃簾鏃ユ湡', title: '浣滃簾鏃ユ湡', templet: "<div>{{d.浣滃簾鏃ユ湡 ==null ?'':layui.util.toDateString(d.浣滃簾鏃ユ湡, 'yyyy-MM-dd')}}</div>", sort: true }
+ , { field: 'hsubid', title: 'hsubid', fixed: true, hide: true, sort: true }
+ , { field: '宸ュ簭璁″垝鍗曞彿', title: '宸ュ簭璁″垝鍗曞彿', sort: true }
+ , { field: '宸ュ簭鍙�', title: '宸ュ簭鍙�', sort: true }
+ , { field: 'hprocid', title: 'hprocid', hide: true, sort: true }
+ , { field: '宸ュ簭浠ｇ爜', title: '宸ュ簭浠ｇ爜', sort: true }
+ , { field: '宸ュ簭', title: '宸ュ簭', sort: true }
+ , { field: '鍔犲伐璇存槑', title: '鍔犲伐璇存槑', sort: true }
+ , { field: '寮�宸ュ浐澶�', title: '寮�宸ュ浐澶�', sort: true }
+ , { field: '寮�宸ュ浐鏁�', title: '寮�宸ュ浐鏁�', sort: true }
+ , { field: 'HCenterID', title: 'HCenterID', hide: true, sort: true }
+ , { field: '宸ヤ綔涓績浠ｇ爜', title: '宸ヤ綔涓績浠ｇ爜', sort: true }
+ , { field: '宸ヤ綔涓績', title: '宸ヤ綔涓績', sort: true }
+ , { field: 'HDeptID', title: 'HDeptID', hide: true, sort: true }
+ , { field: '鍔犲伐杞﹂棿浠ｇ爜', title: '鍔犲伐杞﹂棿浠ｇ爜', sort: true }
+ , { field: '鍔犲伐杞﹂棿', title: '鍔犲伐杞﹂棿', sort: true }
+ , { field: 'HGroupID', title: 'HGroupID', hide: true, sort: true }
+ , { field: '鐝粍浠ｇ爜', title: '鐝粍浠ｇ爜', sort: true }
+ , { field: '鐝粍鍚嶇О', title: '鐝粍鍚嶇О', sort: true }
+ , { field: 'HWorkerID', title: 'HWorkerID', hide: true, sort: true }
+ , { field: '鎿嶄綔鍛樹唬鐮�', title: '鎿嶄綔鍛樹唬鐮�', sort: true }
+ , { field: '鎿嶄綔鍛�', title: '鎿嶄綔鍛�', sort: true }
+ , { field: 'HSourceID', title: 'HSourceID', hide: true, sort: true }
+ , { field: '璧勬簮浠ｇ爜', title: '璧勬簮浠ｇ爜', sort: true }
+ , { field: '鐢熶骇璧勬簮', title: '鐢熶骇璧勬簮', sort: true }
+ , { field: '璁″垝鏁伴噺', title: '璁″垝鏁伴噺', totalRow: true,sort: true }
+ , { field: '鍏宠仈鏁伴噺', title: '鍏宠仈鏁伴噺', totalRow: true, sort: true }
+ , { field: '鏃堕棿鍗曚綅', title: '鏃堕棿鍗曚綅', sort: true }
+ , { field: '璁″垝鍔犲伐鏃堕棿', title: '璁″垝鍔犲伐鏃堕棿', sort: true }
+ , { field: '宸ュ簭璁″垝寮�宸ユ棩鏈�', title: '宸ュ簭璁″垝寮�宸ユ棩鏈�', templet: "<div>{{d.宸ュ簭璁″垝寮�宸ユ棩鏈� ==null ?'':layui.util.toDateString(d.宸ュ簭璁″垝寮�宸ユ棩鏈�, 'yyyy-MM-dd')}}</div>", sort: true }
+ , { field: '宸ュ簭璁″垝瀹屽伐鏃ユ湡', title: '宸ュ簭璁″垝瀹屽伐鏃ユ湡', templet: "<div>{{d.宸ュ簭璁″垝瀹屽伐鏃ユ湡 ==null ?'':layui.util.toDateString(d.宸ュ簭璁″垝瀹屽伐鏃ユ湡, 'yyyy-MM-dd')}}</div>", sort: true }
+ , { field: '鍑嗗鏃堕棿', title: '鍑嗗鏃堕棿', sort: true }
+ , { field: '鎺掗槦鏃堕棿', title: '鎺掗槦鏃堕棿', sort: true }
+ , { field: '杞Щ鏃堕棿', title: '杞Щ鏃堕棿', sort: true }
+ , { field: '琛ㄤ綋澶囨敞', title: '琛ㄤ綋澶囨敞', sort: true }
+ , { field: '鎵规', title: '鎵规', sort: true }
+ , { field: '婧愬崟涓诲唴鐮�', title: '婧愬崟涓诲唴鐮�', sort: true }
+ , { field: '婧愬崟瀛愬唴鐮�', title: '婧愬崟瀛愬唴鐮�', sort: true }
+ , { field: '婧愬崟鍗曞彿', title: '婧愬崟鍗曞彿', sort: true }
+ , { field: '婧愬崟绫诲瀷', title: '婧愬崟绫诲瀷', sort: true }
+ , { field: '閿�鍞鍗曚富ID', title: '閿�鍞鍗曚富ID', hide: true, sort: true }
+ , { field: '閿�鍞鍗曞瓙ID', title: '閿�鍞鍗曞瓙ID', hide: true, sort: true }
+ , { field: '閿�鍞鍗曞彿', title: '閿�鍞鍗曞彿', sort: true }
+ , { field: 'HBillType', title: 'HBillType', hide: true, sort: true }
+ , { field: 'HBillSubType', title: 'HBillSubType', sort: true }
+ , { field: 'HQtyDecimal', title: 'HQtyDecimal', sort: true }
+ , { field: 'HPriceDecimal', title: 'HPriceDecimal', sort: true }
+
+ //,{fixed: 'right', title:'鎿嶄綔', toolbar: '#barDemo', width:150}
+ ]]
+ };
+ }
+
+ //杩涘叆椤甸潰鏄剧ず鐨勭紦瀛樺垪琛�
+ function get_Display(sWhere) {
+ var index0 = layer.load(0, { shade: false });
$.ajax({
+ //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum",
url: GetWEBURL() + '/Sc_ProcessMangement/MES_Sc_ProcessPlanMain_Json',
type: "GET",
- data: { "sWhere": sWhere },
+ data: { "sWhere": sWhere, "user": sessionStorage["HUserName"]},
success: function (data1) {
if (data1.count == 1) {
option.data = data1.data;
table.render(option);
- layer.close(index);
- layer.alert("鏌ヨ鎴愬姛", { icon: 1 });
+ layer.close(index0);
} else {
- layer.close(index);
+ layer.close(index0);
layer.alert(data1.code + data1.Message, { icon: 5 });
}
}, error: function () {
- layer.close(index);
+ layer.close(index0);
layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
}
});
+ }
+
+ // 閲嶇疆杩囨护鏉′欢
+ function set_ClearQuery() {
+ $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
+ $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
+ $("#HBillNo").val("");//鍗曟嵁鍙�
+ $("#HDeptID").val("");//閮ㄩ棬
+ $("#MaterialCode").val("");//鐗╂枡浠ｇ爜
+ $("#MaterialName").val("");//鐗╂枡鍚嶇О
+ $("#SpecificationModel").val("");//瑙勬牸鍨嬪彿
+ $("#HSourceBillNo").val("");//婧愬崟鍗曞彿
+ //$("#Warehouse").val("");//浠撳簱
+ $("#Hmaker").val("");//鍒跺崟浜�
+
+ sWhere = "";
+ }
+
+ // 蹇�熻繃婊�
+ function get_FastQuery() {
+ var HDate = $("#HBeginDate").val();//寮�濮嬫棩鏈�
+ var HDate1 = $("#HEndDate").val();//缁撴潫鏃ユ湡
+ var HBillNo = $("#HBillNo").val();//鍗曟嵁鍙�
+ var HDeptID = $("#HDeptID").val();//閮ㄩ棬
+ var MaterialCode = $("#MaterialCode").val();//鐗╂枡浠ｇ爜
+ var MaterialName = $("#MaterialName").val();//鐗╂枡鍚嶇О
+ var SpecificationModel = $("#SpecificationModel").val();//瑙勬牸鍨嬪彿
+ var HSourceBillNo = $("#HSourceBillNo").val();//婧愬崟鍗曞彿
+ //var Warehouse = $("#Warehouse").val();//浠撳簱
+ var Hmaker = $("#Hmaker").val();//鍒跺崟浜�
+
+ if (HDate) {
+ sWhere += " and CONVERT(varchar(100),鏃ユ湡, 23) >= '" + HDate + "'";
+ }
+ if (HDate1) {
+ sWhere += " and CONVERT(varchar(100),鏃ユ湡, 23) <= '" + HDate1 + "'";
+ }
+ if (HBillNo) {
+ sWhere += " and 鍗曟嵁鍙� like '%" + HBillNo + "%'";
+ }
+ if (HDeptID) {
+ sWhere += " and 鍔犲伐杞﹂棿 like '%" + HDeptID + "%'";
+ }
+ if (MaterialCode) {
+ sWhere += " and 鐗╂枡浠ｇ爜 like '%" + MaterialCode + "%'";
+ }
+ if (MaterialName) {
+ sWhere += " and 鐗╂枡鍚嶇О like '%" + MaterialName + "%'";
+ }
+ if (SpecificationModel) {
+ sWhere += " and 瑙勬牸鍨嬪彿 like '%" + SpecificationModel + "%'";
+ }
+ if (HSourceBillNo) {
+ sWhere += " and 婧愬崟鍗曞彿 like '%" + HSourceBillNo + "%'";
+ }
+ //if (Warehouse) {
+ // sWhere += " and 鍙戣揣浠撳簱 like '%" + Warehouse + "%'";
+ //}
+ if (Hmaker) {
+ sWhere += " and 鍒跺崟浜� like '%" + Hmaker + "%'";
+ }
+ get_Display(sWhere);
sWhere = "";//璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
- });
+ }
+ //瀹℃牳
+ function set_AuditBill() {
+ var Checkstatus = table.checkStatus("mainTable");
- //laydate.render({
- // elem: '#HDate'
- // , type: 'datetime'
- // , trigger: 'click'
- // , format:'yyyy-MM-dd HH:mm'
- //});
+ if (Checkstatus.data.length != 1) {
+ return layer.msg("璇烽�夋嫨涓�鏉℃暟鎹�");
+ }
+ else {
+ var HInterID = Checkstatus.data[0].hmainid;//鑾峰彇id
+ var HBillStatus = Checkstatus.data[0].HBillStatus;//鑾峰彇瀹℃牳鐘舵��
+ if (HBillStatus != "1") {
+ return layer.msg("褰撳墠鍗曟嵁涓嶄负鏈鏍哥姸鎬�!鏃犳硶瀹℃牳");
+ }
+ else {
+ $.ajax({
+ url: GetWEBURL() + "/Sc_ProcessMangement/CheckDeOAuditBill" //鏂规硶鎵�鍦ㄦ帶鍒跺櫒鍜屾柟娉曞悕
+ , type: "GET"
+ , data: { "HInterID": HInterID, "IsAudit": 0, "CurUserName": sessionStorage["HUserName"] }
+ , success: function (result) {
+ if (result.count == 1) {
+ layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
+ // 寰楀埌frame绱㈠紩
+ var index = layer.getFrameIndex(window.name);
+ //鍏抽棴褰撳墠frame
+ layer.close(index);
+ //淇敼涓哄姛鍚庡埛鏂扮晫闈�
+ set_ClearBill();
+ });
+ } else {
+ layer.alert(result.code + result.Message, { icon: 5 });
+ }
+ }, error: function () {
+ layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+ }
+ })
+ }
+ }
+ }
- //浠ヤ笂鏄痩ayui妯″潡
+ //鍙嶅鏍�
+ function set_DeAuditBill() {
+ var Checkstatus = table.checkStatus("mainTable");
+
+ if (Checkstatus.data.length != 1) {
+ return layer.msg("璇烽�夋嫨涓�鏉℃暟鎹�");
+ }
+ else {
+ var HInterID = Checkstatus.data[0].hmainid;//鑾峰彇id
+ var HBillStatus = Checkstatus.data[0].HBillStatus;//鑾峰彇瀹℃牳鐘舵��
+
+ if (HBillStatus == "1") {
+ return layer.msg("褰撳墠鍗曟嵁涓烘湭瀹℃牳鐘舵��!鏃犳硶鍙嶅鏍�");
+ }
+ else {
+ $.ajax({
+ url: GetWEBURL() + "/Sc_ProcessMangement/CheckDeOAuditBill" //鏂规硶鎵�鍦ㄦ帶鍒跺櫒鍜屾柟娉曞悕
+ , type: "GET"
+ , data: { "HInterID": HInterID, "IsAudit": 1, "CurUserName": sessionStorage["HUserName"] }
+ , success: function (result) {
+ if (result.count == 1) {
+ layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
+ // 寰楀埌frame绱㈠紩
+ var index = layer.getFrameIndex(window.name);
+ //鍏抽棴褰撳墠frame
+ layer.close(index);
+ //淇敼涓哄姛鍚庡埛鏂扮晫闈�
+ set_ClearBill();
+ });
+ } else {
+ layer.alert(result.code + result.Message, { icon: 5 });
+ }
+ }, error: function () {
+ layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+ }
+ })
+ }
+ }
+ }
+
+ //鍒犻櫎
+ function set_DeleteBill() {
+ var checkstatus = table.checkStatus("mainTable");
+
+ if (checkstatus.data.length != 1) {
+ return layer.msg("璇烽�夋嫨涓�鏉℃暟鎹�!")
+ }
+ else {
+ layer.confirm("鏄惁纭鍒犻櫎?", {
+ btn: ["纭畾", "鍙栨秷"]
+ , btn1: function () {
+
+ var ModRightNameDelete = "Sc_ProcessPlan_Drop";//鍒犻櫎鏉冮檺
+ var HInterID = checkstatus.data[0].hmainid;
+
+ $.ajax({
+ url: GetWEBURL() + '/Sc_ProcessMangement/DeleteProcessBill'
+ , type: "GET"
+ , data: { "HInterID": HInterID, "User": sessionStorage["HUserName"], "ModRightNameDelete": ModRightNameDelete }
+ , success: function (result) {
+
+ if (result.count == 1) {
+ layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
+ // 寰楀埌frame绱㈠紩
+ var index = layer.getFrameIndex(window.name);
+ //鍏抽棴褰撳墠frame
+ layer.close(index);
+ //淇敼涓哄姛鍚庡埛鏂扮晫闈�
+ window.location.reload();
+ ////閲嶈浇tree
+ //tree.reload('treeDepartment', {});
+ });
+ } else {
+ layer.alert(result.code + result.Message, { icon: 5 });
+ }
+ }
+ })
+
+ }
+ })
+ }
+ }
+
+ //#endregion
+
});
-
-
-
-
</script>
</body>
--
Gitblit v1.9.1