From b28acfba24adf4f1d2b567d0e2d99c29bd8c6d03 Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期五, 07 六月 2024 13:50:53 +0800
Subject: [PATCH] 1
---
WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList.html | 491 +++++++++++++++++++++++++++++++++++++++++-------------
1 files changed, 373 insertions(+), 118 deletions(-)
diff --git a/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList.html b/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList.html
index 0984ac8..ba19f8f 100644
--- a/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList.html
+++ b/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList.html
@@ -31,9 +31,52 @@
<span>鏇村</span>
</div>
</div>
+
<div class="layui-inline">
- <label class="layui-form-label">璁㈠崟鐘舵��</label>
+ <label class="layui-form-label">璁㈠崟鍗曞彿</label>
+ <div class="layui-input-block" style="width:130px;">
+ <input type="text" class="layui-input" name="HBillNo" id="HBillNo">
+ </div>
+ </div>
+ <div class="layui-inline">
+ <label class="layui-form-label">鐗╂枡缂栫爜</label>
+ <div class="layui-input-block" style="width:130px;">
+ <input type="text" class="layui-input" name="HShortNumber" id="HShortNumber">
+ </div>
+ </div>
+ <div class="layui-inline" style="display:none">
+ <label class="layui-form-label">鏃х墿鏂欑紪鐮�</label>
<div class="layui-input-block">
+ <input type="text" class="layui-input" name="HOldMaterNumber" id="HOldMaterNumber">
+ </div>
+ </div>
+ <div class="layui-inline" style="display:none">
+ <label class="layui-form-label">鐗╂枡浠ｇ爜</label>
+ <div class="layui-input-block">
+ <input type="text" class="layui-input" name="HNumber" id="HNumber">
+ </div>
+ </div>
+ <div class="layui-inline">
+ <label class="layui-form-label">鐗╂枡鍚嶇О</label>
+ <div class="layui-input-block" style="width:130px;">
+ <input type="text" class="layui-input" name="HName" id="HName">
+ </div>
+ </div>
+ <div class="layui-inline">
+ <label class="layui-form-label">寮�濮嬫棩鏈�</label>
+ <div class="layui-input-block" style="width:100px;">
+ <input type="text" class="layui-input" name="HDate1" id="HDate1">
+ </div>
+ </div>
+ <div class="layui-inline">
+ <label class="layui-form-label">缁撴潫鏃ユ湡</label>
+ <div class="layui-input-block" style="width:100px;">
+ <input type="text" class="layui-input" name="HDate2" id="HDate2">
+ </div>
+ </div>
+ <div class="layui-inline">
+ <label class="layui-form-label">鐘舵��</label>
+ <div class="layui-input-block" style="width:120px">
<select name="HStatus" id="HStatus" lay-filter="">
<option value="" selected="">鍏ㄩ儴</option>
<option value="鏈‘璁�">鏈‘璁�</option>
@@ -43,30 +86,56 @@
</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">
+ <label class="layui-form-label">鍏抽棴鐘舵��</label>
+ <div class="layui-input-block" style="width:120px">
+ <select id="HClStatus" name="HClStatus" lay-filter="">
+ <option value="" selected>鍏ㄩ儴</option>
+ <option value="鏈叧闂�">鏈叧闂�</option>
+ <option value="宸插叧闂�">宸插叧闂�</option>
+ </select>
+ </div>
+ </div>
+ <!--鐟炵惇,鍑礉-->
+ <div class="layui-inline">
+ <label class="layui-form-label">涓氬姟鐘舵��</label>
+ <div class="layui-input-block" style="width:120px">
+ <select id="HIsClose" name="HIsClose" lay-filter="">
+ <option value="鍏ㄩ儴" selected>鍏ㄩ儴</option>
+ <option value="姝ｅ父">姝ｅ父</option>
+ <option value="涓氬姟鍏抽棴">涓氬姟鍏抽棴</option>
+ </select>
</div>
</div>
<div class="layui-inline">
- <label class="layui-form-label">鐗╂枡缂栫爜</label>
- <div class="layui-input-block">
- <input type="text" class="layui-input" name="HShortNumber" id="HShortNumber">
+ <label class="layui-form-label">鍐荤粨鐘舵��</label>
+ <div class="layui-input-block" style="width:120px">
+ <select id="HIsFreeze" name="HIsFreeze" lay-filter="">
+ <option value="鍏ㄩ儴" selected>鍏ㄩ儴</option>
+ <option value="姝ｅ父">姝ｅ父</option>
+ <option value="涓氬姟鍐荤粨">涓氬姟鍐荤粨</option>
+ </select>
</div>
</div>
<div class="layui-inline">
- <label class="layui-form-label">鐗╂枡浠ｇ爜</label>
- <div class="layui-input-block">
- <input type="text" class="layui-input" name="HNumber" id="HNumber">
+ <label class="layui-form-label">瀹屾垚鐘舵��</label>
+ <div class="layui-input-block" style="width:120px">
+ <select name="HFinishStatus" id="HFinishStatus" lay-filter="">
+ <option value="">鍏ㄩ儴</option>
+ <option value="鏈畬鎴�" selected="">鏈畬鎴�</option>
+ <option value="宸插畬鎴�">宸插畬鎴�</option>
+ </select>
</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="HName" id="HName">
+ <select id="HIsStop" name="HIsStop" lay-filter="">
+ <option value="鍏ㄩ儴">鍏ㄩ儴</option>
+ <option value="鏄�">鏄�</option>
+ <option value="鍚�" selected>鍚�</option>
+ </select>
</div>
</div>
-
<div class="layui-inline">
<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch">
<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
@@ -77,28 +146,6 @@
<label class="layui-form-label">瑙勬牸鍨嬪彿</label>
<div class="layui-input-block">
<input type="text" class="layui-input" name="HModel" id="HModel">
- </div>
- </div>
- <div class="layui-inline">
- <label class="layui-form-label">鍏抽棴鐘舵��</label>
- <div class="layui-input-block">
- <select id="HClStatus" name="HClStatus" lay-filter="">
- <option value="" selected>鍏ㄩ儴</option>
- <option value="鏈叧闂�">鏈叧闂�</option>
- <option value="宸插叧闂�">宸插叧闂�</option>
- </select>
- </div>
- </div>
- <div class="layui-inline">
- <label class="layui-form-label">寮�濮嬫棩鏈�</label>
- <div class="layui-input-block">
- <input type="text" class="layui-input" name="HDate1" id="HDate1">
- </div>
- </div>
- <div class="layui-inline">
- <label class="layui-form-label">缁撴潫鏃ユ湡</label>
- <div class="layui-input-block">
- <input type="text" class="layui-input" name="HDate2" id="HDate2">
</div>
</div>
<div class="layui-inline">
@@ -134,7 +181,6 @@
</select>
</div>
</div>
-
</div>
</div>
</div>
@@ -144,16 +190,21 @@
<table class="layui-hide" id="mainTable" lay-filter="mainTable"></table>
<script type="text/html" id="toolbarDemo">
<div class="layui-btn-container">
+ <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch">
+ <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
+ </button>
<!--<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" id="btn_reload" lay-submit="" 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-confirm" id="btn_confirm"><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"><i class="layui-icon layui-icon-close-fill"></i>椹冲洖</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-report" id="btn_report"><i class="layui-icon layui-icon-close-fill"></i>姹囨姤</button>
- <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>璇︽儏</button>
- <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-barcode"><i class="layui-icon layui-icon-file"></i>鐢熸垚鏉＄爜</button>-->
- <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>鐢熸垚閫佽揣鍗�</button>
- <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>閫�鍑�</button>
- <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>闅愯棌鍒楄缃�</button>
+ <button type="button" class="layui-btn layui-btn-sm" id="btn_details" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>璇︽儏</button>
+ <button type="button" class="layui-btn layui-btn-sm" id="btn_barcode" lay-event="btn-barcode"><i class="layui-icon layui-icon-file"></i>鐢熸垚鏉＄爜</button>
+ <button type="button" class="layui-btn layui-btn-sm" id="btn_generate" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>鐢熸垚閫佽揣鍗�</button>
+ <button type="button" class="layui-btn layui-btn-sm" id="btn_backData" lay-event="btn_backData"><i class="layui-icon layui-icon-add-1"></i>杩斿洖鏁版嵁</button>
+ <button type="button" class="layui-btn layui-btn-sm" id="btn_exit" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>閫�鍑�</button>
+ <button type="button" class="layui-btn layui-btn-sm" id="btn_HideColumn" lay-event="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>闅愯棌鍒楄缃�</button>
+ <button type="button" class="layui-btn layui-btn-sm" id="set_dao" lay-event="set_dao"><i class="layui-icon layui-icon-form"></i>瀵煎嚭</button>
</div>
</script>
</div>
@@ -161,10 +212,12 @@
</div>
</div>
<script src="../../layuiadmin/layui/layui.js" charset="utf-8"></script>
+ <script src="../../layuiadmin/Scripts/json2.js" type="text/javascript"></script>
+ <script src="../../layuiadmin/Scripts/jquery-1.4.1.js" type="text/javascript"></script>
<script src="../../../../Scripts/webConfig.js"></script>
<script>
var _cur_page = 1;
- var sql = " and 1=1";
+ var sql = "";
var options = document.getElementById('HStatus').children;
function getUrlVars() {
var vars = [], hash;
@@ -182,34 +235,20 @@
}
var params = getUrlVars();
var type = params[params[0]];
- switch (type) {
- case "UnConfirm":
- options[1].selected = true;
- sql += " and 鐘舵�� like ^^%鏈‘璁�%^^";
- //$("#HStatus").attr("disabled", true)
- break;
- case "ReConfirm":
- options[2].selected = true;
- sql += " and 鐘舵�� like ^^%宸茬‘璁�%^^";
- sql += " and 鏈叧鑱旀暟閲� > 0";
- break;
- case "ReBack":
- options[3].selected = true;
- sql += " and 鐘舵�� like ^^%宸查┏鍥�%^^";
- break;
- }
+
layui.config({
base: '../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰�
}).extend({
index: 'lib/index' //涓诲叆鍙ｆā鍧�
- }).use(['index', 'form', 'laydate', 'code', 'table', 'element', 'layer'], function () {
+ }).use(['index', 'form', 'laydate', 'code', 'table', 'element', 'layer','excel'], function () {
var $ = layui.$
, admin = layui.admin
, layer = layui.layer
, laydate = layui.laydate
, table = layui.table
, form = layui.form
- , element = layui.element;
+ , element = layui.element
+ , excel = layui.excel;
//甯歌鐢ㄦ硶
laydate.render({
elem: '#HDate1'
@@ -217,9 +256,46 @@
laydate.render({
elem: '#HDate2'
});
+
+ //涓嶉渶瑕佹樉绀虹殑瀛楁 鍙墿灞�
+ var titleData = ["HItemID", "HParentID", "鍗曟嵁鍙�", "鏃ユ湡", "鏁伴噺", "鐘舵��", "鍗曚綅", "閲戦"];
var option = [];
var HModName = "SRM_POOrderBillList";
+ var sqlWhere = "";
//#region 杩涘叆椤甸潰鏃㈠姞杞�
+ switch (type) {
+ case "UnConfirm":
+ options[1].selected = true;
+ sql += " and 鐘舵�� like ^^%鏈‘璁�%^^";
+ //$("#HStatus").attr("disabled", true)
+ break;
+ case "ReConfirm":
+ options[2].selected = true;
+ sql += " and 鐘舵�� like ^^%宸茬‘璁�%^^";
+ sql += " and 鏈叧鑱旀暟閲� > 0";
+ break;
+ case "ReBack":
+ options[3].selected = true;
+ sql += " and 鐘舵�� like ^^%宸查┏鍥�%^^";
+ break;
+ //case "AddRow":
+ // $("#HStatus").attr("disabled", "disabled");
+ // $("#HStatus").val('宸茬‘璁�');
+ // $("#HFinishStatus").attr("disabled", "disabled");
+ // form.render('select');
+ // sqlWhere += " and 鐘舵�� like ^^%宸茬‘璁�%^^";
+ // sqlWhere += " and 瀹屾垚鐘舵�� like ^^%" + $("#HFinishStatus").val() + "%^^";
+ // $('#btn_reload').addClass("layui-btn-disabled").attr("visibility", "hidden");
+ // $('#btn_confirm').addClass("layui-btn-disabled").attr("disabled", true);
+ // $('#btn_back').addClass("layui-btn-disabled").attr("disabled", true);
+ // $('#btn_report').addClass("layui-btn-disabled").attr("disabled", true);
+ // $('#btn_details').addClass("layui-btn-disabled").attr("disabled", true);
+ // $('#btn_barcode').addClass("layui-btn-disabled").attr("disabled", true);
+ // $('#btn_generate').addClass("layui-btn-disabled").attr("disabled", true);
+ // $('#set_dao').addClass("layui-btn-disabled").attr("disabled", true);
+ // break;
+ }
+
set_ClearBill();
//#region 姝ら〉闈㈡墍鏈夋柟娉�
function set_ClearBill() {
@@ -228,9 +304,9 @@
$("#HPURCHASEORGID").append(Organization);
form.render('select');
//鍒濆鍖栬〃鏍�
- set_InitGrid();
+ //set_InitGrid();
//鏄剧ず鍒楁暟鎹�
- DisPlay_HideColumn();
+ //DisPlay_HideColumn();
//鐩存帴鎵ц鍒楄〃绛涢�� 鍔犺浇鏁版嵁鍒扮綉鏍�
get_FastQuery(table, option)
}
@@ -238,36 +314,34 @@
//$("#HBeginDate").val("2022-03-14");
//$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
var columns = [
- { type: 'checkbox', fixed: 'left' }
+ { type: 'checkbox', fixed: 'left', totalRowText: '鍚堣' }
//{ type: 'radio', fixed: true }
, { field: 'sorderid', title: '搴忓彿', width: 80/*, fixed: true */ }
, { field: 'hmainid', title: 'hmainid', sort: true, /*fixed: true,*/ hide: true }
, { field: 'hsubid', title: 'hsubid', sort: true, /*fixed: true,*/ hide: true }
, { field: '鐘舵��', title: '鐘舵��', sort: true/*, fixed: true */ }
- //, { field: '鍙嶉鐘舵��', title: '鍙嶉鐘舵��', width: 100/*, fixed: true */}
+ , { field: '鍙嶉鐘舵��', title: '鍙嶉鐘舵��', width: 100/*, fixed: true */}
//, { field: '浼樺厛绾�', title: '浼樺厛绾�', width: 100/*, fixed: true */}
, { field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�', width: 150, sort: true/*, fixed: 'left' */ }
+ , { field: '璁″垝璺熻釜鍗曞彿', title: '璁″垝璺熻釜鍗曞彿', sort: true, hide: true }
+ , { field: '鑷畾涔夋爣璇�', title: '鑷畾涔夋爣璇�', width: 120 }
+ , { field: '閫佽揣鍦扮偣', title: '閫佽揣鍦扮偣', width: 120 }
+ , { field: '鍖呰鏍囪瘑', title: '鍖呰鏍囪瘑', width: 120 }
+ , { field: '鍞竴ID', title: '鍞竴ID', width: 120 }
+ //, { field: '鐗╂枡缂栫爜', title: '鐗╂枡缂栫爜', width: 120, sort: true }
+ , { field: '鐗╂枡浠ｇ爜', title: '鐗╂枡缂栫爜', width: 120, sort: true }
+ , { field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О', width: 120, sort: true }
+ , { field: '璁￠噺鍗曚綅', title: '璁￠噺鍗曚綅', width: 80, sort: true }
+ , { field: '鏁伴噺', title: '璁㈠崟鏁伴噺', sort: true }
+ , { field: '鎵撳嵃鏉＄爜鏁伴噺', title: '鎵撳嵃鏉＄爜鏁伴噺', sort: true }
+ , { field: '宸插彂璐ф暟閲�', title: '宸插彂璐ф暟閲�', sort: true, totalRow: true }
+ , { field: '鍙彂璐ф暟閲�', title: '鍙彂璐ф暟閲�', sort: true, totalRow: true}
+ , { field: '浜よ揣鍦扮偣', title: '浜よ揣鍦扮偣', sort: true }
+ , { field: '浜よ揣鏃ユ湡', title: '浜よ揣鏃ユ湡', width: 180, sort: true }
, { field: '鏃ユ湡', title: '鏃ユ湡', width: 120, sort: true/*, fixed: 'left' */ }
, { field: 'HSupID', title: 'HSupID', width: 180, hide: true }
, { field: '渚涘簲鍟�', title: '渚涘簲鍟�', width: 180, sort: true/*, fixed: 'left' */ }
- , { field: '璁″垝璺熻釜鍗曞彿', title: '璁″垝璺熻釜鍗曞彿', sort: true, hide: true }
- , { field: 'F_xbkf_Combo', title: '鑷畾涔夋爣璇�', width: 120 }
- , { field: 'FSHDD', title: '閫佽揣鍦扮偣', width: 120 }
- , { field: 'FStockInQty', title: '绱鍏ュ簱鏁伴噺', width: 120 }
- , { field: '鍖呰鏍囪瘑', title: '鍖呰鏍囪瘑', width: 120 }
- , { field: 'FMRBQTY', title: '绱閫�鏂欐暟閲�', width: 120 }
- , { field: 'FMRBQTY', title: '鍞竴鏍囪瘑', width: 120 }
- , { field: '鍞竴ID', title: '鍞竴ID', width: 120 }
- //, { field: '鐗╂枡缂栫爜', title: '鐗╂枡缂栫爜', width: 120, sort: true }
- , { field: '鐗╂枡浠ｇ爜', title: '鐗╂枡浠ｇ爜', width: 120, sort: true }
- , { field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О', width: 120, sort: true }
, { field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿', width: 120, sort: true }
- , { field: '璁￠噺鍗曚綅', title: '璁￠噺鍗曚綅', width: 80, sort: true }
- , { field: '鏁伴噺', title: '璁㈣揣鏁伴噺', sort: true }
- , { field: '浜よ揣鍦扮偣', title: '浜よ揣鍦扮偣', sort: true }
- , { field: '浜よ揣鏃ユ湡', title: '浜よ揣鏃ユ湡', width: 180, sort: true }
- , { field: '鍏宠仈鏁伴噺', title: '鍏宠仈鏁伴噺', sort: true }
- , { field: '鏈叧鑱旀暟閲�', title: '鏈叧鑱旀暟閲�', sort: true }
, { field: '鍓╀綑鍏ュ簱鏁伴噺', title: '鍓╀綑鍏ュ簱鏁伴噺', sort: true }
, { field: '鍓╀綑鏀舵枡鏁伴噺', title: '鍓╀綑鏀舵枡鏁伴噺', sort: true }
, { field: '鍏抽棴鐘舵��', title: '鍏抽棴鐘舵��', sort: true }
@@ -288,22 +362,12 @@
, totalRow: true
, limit: 500
, height: 'full-50'
- , cols: [columns]
+ //, cols: [columns]
, limits: [500, 5000, 20000]
, done: function (res, curr, count) {
}
};
- ////璁剧疆鍒楀
- //var colWidth = getColumnsWidth();
- //if (colWidth == "" || colWidth == []) {
-
- //}
- //else {
- // $.each(columns, function (x, m) {
- // m["width"] = colWidth[x];
- // });
- //}
}
//闅愯棌鍒楄缃�
function get_HideColumn() {
@@ -340,7 +404,6 @@
success: function (data1) {
if (data1.data.length != 0) {
var dataCol = [];//鏁版嵁搴撴煡璇㈠嚭鐨勫垪鏁版嵁
- var titleData = [];//涓嶉渶瑕佹樉绀虹殑瀛楁 鍙墿灞�
dataCol = data1.data[0].HGridString.split(',');
for (var i = 0; i < dataCol.length; i++) {
var dataCols = dataCol[i].split('|');
@@ -348,9 +411,18 @@
if (dataCols[1] == 1) {
option.cols[0][i + 1]["hide"] = true;
}
+ //鏄剧ず鍒�
+ if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
+ option.cols[0][i + 1]["hide"] = false;
+ }
+ //闅愯棌id
//璁剧疆鍒楀
if (dataCols[3] > 0) {
- option.cols[0][i + 1]["width"] = dataCols[3];
+ if (option.cols[0][i + 1]["field"] == '渚涘簲鍟嗕氦鏈熷洖澶�') {
+ option.cols[0][i + 1]["width"] = 120;
+ } else {
+ option.cols[0][i + 1]["width"] = dataCols[3];
+ }
}
//璁剧疆鍐呭瀛椾綋澶у皬
if (data1.data[0].HFontSize != 0) {
@@ -364,10 +436,7 @@
//} else {
// option.cols[0][i + 1]["width"] = "";
//}
- //鏄剧ず鍒�
- if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
- option.cols[0][i + 1]["hide"] = false;
- }
+
//瀛椾綋鎵�鍦ㄤ綅缃�(宸� 灞呬腑 鍙�)
switch (dataCols[2]) {
case "L":
@@ -381,7 +450,6 @@
break;
}
}
-
//鍙栨秷鍐荤粨鍒�
for (var i = 1; i < option.cols[0].length - 1; i++) {
if (option.cols[0][i]["fixed"] != null) {
@@ -414,17 +482,65 @@
var wait = layer.load();//閬僵
$.ajax({
type: "POST",
- url: GetWEBURL() + "GetPOOrderBill",
+ url: GetWEBURL() + "GetPOOrderBill", //H_p_SRM_POOrderBillList
async: true,
data: { "HSupNo": sessionStorage["HUserName"], "sqlWhere": sqlWhere },
- success: function (result) {
- if (result.Message == "鑾峰彇鎴愬姛") {
- option.data = result.data;
- table.render(option);
+ success: function (data1) {
+ if (data1.Message == "鑾峰彇鎴愬姛") {
+ var data = [];
+ var col = [];
+ //缁欑┖鐨勬暟缁勮祴鍊�
+ for (var key in data1.list) {
+ data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
+ }
+ //鍦ㄥ垪琛ㄥ乏杈规坊鍔犲嬀閫夋
+ col.push({ type: 'checkbox', fixed: 'left', totalRowText: '鍚堣' });
+ for (var i = 0; i < data.length; i++) {
+ // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
+ if ($.inArray(data[i].name, titleData) > -1) {
+ col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //闅愯棌id鍒�
+ }
+ else if (data[i].name.indexOf('id') > -1)
+ {
+ col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //id鍒�
+ }
+ else {
+ switch (data[i].Type) {
+ //int
+ case 'DateTime':
+ col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
+ break;
+ default:
+ if (data[i].name == '璁㈠崟鏁伴噺' || data[i].name == '宸插彂璐ф暟閲�' || data[i].name == '鏈彂璐ф暟閲�' || data[i].name == '鍓╀綑鏀舵枡鏁伴噺' || data[i].name == '鏈埌璐ф暟閲�' || data[i].name == '绱鏀舵枡鏁伴噺' || data[i].name == '鍓╀綑鍏ュ簱鏁伴噺' || data[i].name == '鍏ュ簱鏁伴噺') {
+ col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, totalRow: true });
+ } else if (data[i].name == '渚涘簲鍟嗕氦鏈熷洖澶�') {
+ col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: 'HSupSendGoodsDateRemark' });
+ } else {
+ col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
+ }
+ }
+ }
+ }
+ //鍔ㄦ�佹樉绀哄垪鍚�
+ option = {
+ elem: '#mainTable'
+ , toolbar: '#toolbarDemo'
+ , cols: [col]
+ , data: data1.data
+ , height: 'full-80'
+ ,totalRow: true
+ , page: true
+ , cellMinWidth: 90
+ , limit: 500
+ , limits: [50, 500, 5000, 20000]
+ }
+ table.render(option);
+ //鍒锋柊琛ㄦ牸鏁版嵁
+ DisPlay_HideColumn();
layer.close(wait);
} else {
layer.close(wait);
- layer.alert(result.Message, { icon: 5 });
+ layer.alert(data1.Message, { icon: 5 });
}
},
error: function (result) {
@@ -439,13 +555,17 @@
});
//鏌ヨ鏉′欢
function get_FastQuery(table, option) {
- var sqlWhere = " and 1=1 ";
+ var sqlWhere = "";
+ if ($("#HFinishStatus").val() != "")
+ sqlWhere += " and 瀹屾垚鐘舵�� like ^^%" + $("#HFinishStatus").val() + "%^^";
if ($("#HStatus").val() != "")
sqlWhere += " and 鐘舵�� like ^^%" + $("#HStatus").val() + "%^^";
if ($("#HBillNo").val() != "")
sqlWhere += " and 鍗曟嵁鍙� like ^^%" + $("#HBillNo").val() + "%^^";
if ($("#HShortNumber").val() != "")
sqlWhere += " and 鐗╂枡缂栫爜 like ^^%" + $("#HShortNumber").val() + "%^^";
+ if ($("#HOldMaterNumber").val() != "")
+ sqlWhere += " and 鏃х墿鏂欑紪鐮� like ^^%" + $("#HOldMaterNumber").val() + "%^^";
if ($("#HNumber").val() != "")
sqlWhere += " and 鐗╂枡浠ｇ爜 like ^^%" + $("#HNumber").val() + "%^^";
if ($("#HName").val() != "")
@@ -454,8 +574,8 @@
sqlWhere += " and 瑙勬牸鍨嬪彿 like ^^%" + $("#HModel").val() + "%^^";
if ($("#HClStatus").val() != "")
sqlWhere += " and 鍏抽棴鐘舵�� like ^^%" + $("#HClStatus").val() + "%^^";
- //if ($("#HPURCHASEORGID").val() != "")
- // sqlWhere += " and 閲囪喘缁勭粐 like ^^%" + $("#HPURCHASEORGID").val() + "%^^";
+ if ($("#HPURCHASEORGID").val() != "" && $("#HPURCHASEORGID option:selected").text() != "瀹夌憺闆嗗洟")
+ sqlWhere += " and HPURCHASEORGID = ^^" + $("#HPURCHASEORGID").val() + "^^";
if ($("#HDate1").val() != "") {
sqlWhere += " and 鏃ユ湡 >= ^^" + $("#HDate1").val() + "^^";
}
@@ -470,6 +590,32 @@
sqlWhere += " and 鏈叧鑱旀暟閲� > 0";
}
}
+ /*鐟炵惇*/
+ if ($("#HIsClose").val() != "") {
+ if ($("#HIsClose").val() == "姝ｅ父") {
+ sqlWhere += " and 涓氬姟鍏抽棴 = ^^姝ｅ父^^";
+ }
+ else if ($("#HIsClose").val() == "涓氬姟鍏抽棴") {
+ sqlWhere += " and 涓氬姟鍏抽棴 = ^^涓氬姟鍏抽棴^^";
+ }
+ }
+ if ($("#HIsFreeze").val() != "") {
+ if ($("#HIsFreeze").val() == "姝ｅ父") {
+ sqlWhere += " and 涓氬姟鍐荤粨 = ^^姝ｅ父^^";
+ }
+ else if ($("#HIsFreeze").val() == "涓氬姟鍐荤粨") {
+ sqlWhere += " and 涓氬姟鍐荤粨 = ^^涓氬姟鍐荤粨^^";
+ }
+ }
+ if ($("#HIsStop").val() != "") {
+ if ($("#HIsStop").val() == "鏄�") {
+ sqlWhere += " and 涓氬姟缁堟 = ^^涓氬姟缁堟^^";
+ }
+ else if ($("#HIsStop").val() == "鍚�") {
+ sqlWhere += " and 涓氬姟缁堟 = ^^姝ｅ父^^";
+ }
+ }
+
var Time = $("#Time").val();
if (Time > 0) {
var dd = new Date();
@@ -506,6 +652,42 @@
_cur_page = 1;
get_Display(sqlWhere);
}
+
+ //鐩戝惉鍗曞厓鏍间簨浠�
+ table.on('tool(mainTable)', function (obj) {
+ var data = obj.data;
+ if (obj.event === 'HSupSendGoodsDateRemark') {
+ layer.prompt({
+ formType: 2
+ , area: ['400px', '50px'] //鑷畾涔夋枃鏈煙瀹介珮
+ , title: '淇敼璁㈠崟鍙蜂负 銆� ' + data.鍗曟嵁鍙� + ' 銆� 锛岀墿鏂欎唬鐮佷负 銆� ' + data.鐗╂枡浠ｇ爜 + ' 銆� 鐨勪緵搴斿晢浜ゆ湡鍥炲'
+ , value: data.渚涘簲鍟嗕氦鏈熷洖澶�
+ }, function (value, index) {
+ layer.close(index);
+ //鏇存柊渚涘簲鍟嗕氦鏈熷洖澶�
+ $.ajax({
+ type: "GET",
+ url: GetWEBURL() + "Cg_Poorder/UpdateSupSendGoodsDateRemark",
+ async: false,
+ data: { "HInterID": data.hmainid, "HEntryID": data.hsubid, "HSupSendGoodsDateRemark": value},
+ success: function (result) {
+ if (result.code == 1) {
+ //鍚屾鏇存柊琛ㄦ牸鍜岀紦瀛樺搴旂殑鍊�
+ obj.update({
+ 渚涘簲鍟嗕氦鏈熷洖澶�: value
+ });
+ } else {
+ layer.alert(result.Message, { icon: 5 });
+ }
+ },
+ error: function (result) {
+ layer.alert(result.Message, { icon: 5 });
+ }
+ });
+ });
+ }
+ });
+
//澶村伐鍏锋爮浜嬩欢
table.on('toolbar(mainTable)', function (obj) {
var checkStatus = table.checkStatus(obj.config.id);
@@ -525,11 +707,28 @@
var checkStatus = table.checkStatus('mainTable')
, data = checkStatus.data;
_cur_page = $(".layui-laypage-em").next().html();
+
+ var HInterIDArr = "";
+ var HBillNoArr = "";
+ var HBillInter = "";
+
+ for (let i = 0; i < data.length; i++) {
+ HInterIDArr += data[i].hmainid.toString() + ",";
+ HBillNoArr += "'" + data[i].鍗曟嵁鍙�.toString() + "'" + ",";
+ HBillInter += data[i].鍗曟嵁鍙�.toString() + "@" + data[i].hmainid.toString() + ",";
+ }
+
+ HInterIDArr = HInterIDArr.substring(0, HInterIDArr.length - 1)//鍐呯爜
+ HBillNoArr = HBillNoArr.substring(0, HBillNoArr.length - 1)//鍗曟嵁鍙�
+ HBillInter = HBillInter.substring(0, HBillInter.length - 1)//鍗曟嵁鍙� + @ + 鍐呯爜鎷兼帴
+
+ var oData = JSON.stringify(HInterIDArr) + ";" + JSON.stringify(HBillInter) + ";" + sessionStorage["HUserName"];
+
layer.confirm('鏄惁纭鍗曟嵁?', { icon: 3, title: '鎻愮ず' }, function (index) {
$.ajax({
- type: "get",
+ type: "post",
url: GetWEBURL() + "POOrderAccept",
- data: { "HInterID": data[0]["hmainid"].toString(), "HBillNo": data[0]["鍗曟嵁鍙�"].toString(), "HUser": sessionStorage["HUserName"] },
+ data: { "oData": oData },
success: function (result) {
if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
layer.msg(result.Message, { icon: 1 });
@@ -611,6 +810,9 @@
layer.alert("璇烽�夋嫨鏁版嵁", { icon: 5 });
return;
}
+ if (data[0].瀹屾垚鐘舵�� == "宸插畬鎴�") {
+ return layer.msg('璁㈠崟宸插畬鎴愶紒')
+ }
ajaxLabelData = data;
//鏍规嵁閫変腑鐨勯噰璐鍗曪紝閲嶆柊浠庨噾铦朵簯鍚屾閲囪喘璁㈠崟鍏宠仈鏁伴噺杩囨潵銆傝�冭檻閲囪喘璁㈠崟鍒犻櫎鍜屽叧闂姸鎬侊紝鍚屾鐘舵��
var ids = "";
@@ -680,19 +882,21 @@
, anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚�
, content: ['../../views/SRM/SRM_POInStockBill_Edit.html?linterid=' + data[0].hmainid.toString() + '&lentryid=' + rows.toString() + '&lSourceBillType=1102', 'yes']
, resize: false
- //, cancel: function () {
- // $(".layui-btn").removeClass("layui-btn-disabled");
- //}
+ ,end: function () {
+ get_FastQuery(table, option)
+ }
})
}
break;
-
case 'btn-barcode':
var checkStatus = table.checkStatus('mainTable')
, data = checkStatus.data;
- //if (data[0].鏈敓鎴愭潯鐮佹暟閲� <= 0) {
- // layer.msg("閫変腑琛屽凡鐢熸垚鏉＄爜锛�", { icon: 5 });
- //}
+ if (data.length == 0) {
+ return layer.msg('璇烽�夋嫨鏁版嵁')
+ }
+ if (data[0].瀹屾垚鐘舵�� == "宸插畬鎴�") {
+ return layer.msg('璁㈠崟宸插畬鎴愶紒')
+ }
layer.open({
type: 2
, area: ['100%', '100%']
@@ -782,8 +986,59 @@
}
});
break;
+ case 'set_dao':
+ //鑾峰彇鍒楄〃鍒楁暟鎹簮
+ var ColName = [];
+ for (var i = 1; i < option.cols[0].length; i++) {
+ if (option.cols[0][i]["hide"] != true) {
+ ColName.push(option.cols[0][i]["field"]);
+ }
+ }
+ //缁戝畾鏁版嵁
+ var data = excel.filterExportData(option.data, ColName)
+
+ //璧嬪�间簬琛ㄥご鍒楀悕
+ var Title = [];
+ for (var i = 0; i < ColName.length; i++) {
+ Title.push("\"" + ColName[i] + "\":\"" + ColName[i] + "\"");
+ }
+ var TitleName = JSON.parse("{" + Title.toString() + "}");
+ data.unshift(TitleName);
+
+ //瀵煎嚭 sheet1 宸ヤ綔琛ㄥ悕
+ excel.exportExcel({
+ sheet1: data
+ }, '閲囪喘璁㈠崟鍒楄〃.xlsx', 'xlsx');
+ break;
+ case 'btn_backData':
+ var checkStatus = table.checkStatus('mainTable')
+ , data = checkStatus.data;
+ parent.GetPoorderValue(data);
+ var index = parent.layer.getFrameIndex(window.name);
+ parent.layer.close(index);
+ break;
};
});
+
+ //琛岀洃鍚簨浠�
+ table.on('row(mainTable)', function (obj) {
+ var flag = !obj.tr.find(':checkbox:first').prop('checked');
+ obj.tr.find(':checkbox').prop('checked', flag);
+ if (flag) {
+ obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //璁剧疆澶嶉�夋閫変腑鏍峰紡
+ $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//鏀瑰彉褰撳墠tr鑳屾櫙棰滆壊鍜屽瓧浣撻鑹�
+ } else {
+ obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//鍙栨秷澶嶉�夋閫変腑鏍峰紡
+ $(obj.tr.selector).attr({ "style": "background:" });//鍙栨秷褰撳墠tr棰滆壊
+ }
+ //mainTable 涓鸿〃鏍糏D 娉ㄦ剰姝ゅ濡傛灉ID涓嶆纭皢瀵艰嚧浣犲湪鐩戝惉澶嶉�夋鏃惰幏鍙栦笉鍒颁綘閫夋嫨鐨勬暟鎹紝鍓嶉潰鐨勫彧鏄坊鍔犳垨鍒犻櫎閫変腑鏈�変腑鏍峰紡浠ュ強璁剧疆鑳屾櫙鑹诧紝瀛椾綋棰滆壊
+ layui.each(table.cache.mainTable, function (i, l) {
+ if (obj.tr.index() == l.LAY_TABLE_INDEX) {
+ l.LAY_CHECKED = flag;
+ }
+ });
+ });
+
});
</script>
</body>
--
Gitblit v1.9.1