From 5b88dc22365c5b7610962284dbbeb0e4a21c7afe Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期一, 25 十一月 2024 11:27:25 +0800
Subject: [PATCH] 付款单增加页签,采购订单分页

---
 WebTM/views/采购管理/采购订单/Cg_POOrderBillList.html |  158 +++++++++++++++++++++++++++----
 WebTM/views/采购管理/付款单/YF_PayMentBill.html      |  123 +++++++++++++-----------
 2 files changed, 201 insertions(+), 80 deletions(-)

diff --git "a/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\344\273\230\346\254\276\345\215\225/YF_PayMentBill.html" "b/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\344\273\230\346\254\276\345\215\225/YF_PayMentBill.html"
index ca24214..7d1c6c2 100644
--- "a/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\344\273\230\346\254\276\345\215\225/YF_PayMentBill.html"
+++ "b/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\344\273\230\346\254\276\345\215\225/YF_PayMentBill.html"
@@ -33,7 +33,8 @@
                         <h1 style="text-align: center; padding: 10px 0;"><b>浠樻鍗�</b></h1>
                         <ul class="layui-tab-title" lay-filter="tab-all">
                             <li lay-id="1" style="padding:1px;" class="layui-this">鍩烘湰淇℃伅</li>
-                            <li lay-id="2" style="padding:1px;">鍏朵粬淇℃伅</li>
+                            <li lay-id="2" style="padding:1px;">鍒跺崟淇℃伅</li>
+                            <li lay-id="2" style="padding:1px;">鍏跺畠淇℃伅</li>
                         </ul>
                         <div class="layui-tab-content">
                             <!--鍩烘湰淇℃伅-->
@@ -75,56 +76,12 @@
                                         </div>
                                     </div>
                                     <div class="layui-row">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">甯佸埆<label style="color:red"> * </label></label>
-                                            <div class="layui-input-inline">
-                                                <input type="text" name="HCurName" id="HCurName" class="layui-input" value="" style="float: left; width: 150px; background-color: #efefef4d;" readonly>
-                                                <input type="hidden" name="HCurID" id="HCurID" class="layui-input" value="0" style="float:left;width:150px;">
-                                                <button type="button" lay-submit="" class="layui-btn" lay-filter="HCurList" style="width:40px;">
-                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
-                                                </button>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">姹囩巼<label style="color:red"> * </label></label>
-                                            <div class="layui-input-inline">
-                                                <input class="layui-input" name="HExRate" id="HExRate" autocomplete="off" value="0" style="background-color: #efefef4d;" readonly>
-                                            </div>
-                                        </div>
                                         <div class="layui-inline" style="width:900px;">
                                             <label class="layui-form-label">涓氬姟鍗曚綅<label style="color:red"> * </label></label>
                                             <div class="layui-input-inline" style="width:750px;">
                                                 <input type="text" name="HSupName" id="HSupName" class="layui-input" value="" style="float: left; width: 475px; background-color: #efefef4d;" readonly>
                                                 <input type="hidden" name="HSupID" id="HSupID" class="layui-input" value="0" style="float:left;width:150px;">
                                                 <button type="button" lay-submit="" class="layui-btn" lay-filter="HSupList" style="width:40px;">
-                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
-                                                </button>
-                                            </div>
-                                        </div>
-                                    </div>
-                                    <div class="layui-row">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">缁撶畻鏂瑰紡</label>
-                                            <div class="layui-input-inline">
-                                                <input type="text" name="HSSName" id="HSSName" class="layui-input" value="" style="float: left; width: 150px; background-color: #efefef4d;" readonly>
-                                                <input type="hidden" name="HSSID" id="HSSID" class="layui-input" value="0" style="float:left;width:150px;">
-                                                <button type="button" lay-submit="" class="layui-btn" lay-filter="HSSList" style="width:40px;">
-                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
-                                                </button>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">缁撶畻鍙�</label>
-                                            <div class="layui-input-inline">
-                                                <input class="layui-input" name="HSSNum" id="HSSNum" autocomplete="off">
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline" style="width:900px;">
-                                            <label class="layui-form-label">缁撶畻鍗曚綅<label style="color:red"> * </label></label>
-                                            <div class="layui-input-inline" style="width:750px;">
-                                                <input type="text" name="HAccSupName" id="HAccSupName" class="layui-input" value="" style="float: left; width: 475px; background-color: #efefef4d;" readonly>
-                                                <input type="hidden" name="HAccSupID" id="HAccSupID" class="layui-input" value="0" style="float:left;width:150px;">
-                                                <button type="button" lay-submit="" class="layui-btn" lay-filter="HAccSupList" style="width:40px;">
                                                     <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
                                                 </button>
                                             </div>
@@ -145,12 +102,6 @@
                                             <label class="layui-form-label">閾惰璐﹀彿</label>
                                             <div class="layui-input-inline">
                                                 <input class="layui-input" name="HBankNo" id="HBankNo" style="background-color: #efefef4d;" autocomplete="off" readonly>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">鍐呴儴璁㈠崟鍙�</label>
-                                            <div class="layui-input-inline">
-                                                <input class="layui-input" name="HInnerBillNo" id="HInnerBillNo" autocomplete="off" style="background-color: #efefef4d;" readonly>
                                             </div>
                                         </div>
                                         <div class="layui-inline">
@@ -183,12 +134,6 @@
                                             <label class="layui-form-label">鎶樻墸鍚庨噾棰�<label style="color:red"> * </label></label>
                                             <div class="layui-input-inline">
                                                 <input class="layui-input" name="HRelSumMoney" value="0" id="HRelSumMoney" autocomplete="off" style="background-color: #efefef4d;" readonly>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">璐㈠姟鏃ユ湡</label>
-                                            <div class="layui-input-inline">
-                                                <input type="date" class="layui-input" lay-verify="HAccDate" name="HAccDate" id="HAccDate" style="padding-left: 80px;">
                                             </div>
                                         </div>
                                     </div>
@@ -234,6 +179,70 @@
                                 </div>
                             </div>
                             <!--鍏朵粬淇℃伅-->
+                            <div class="layui-tab-item">
+                                <div class="layui-form-item">
+                                    <div class="layui-row">
+                                        <div class="layui-inline">
+                                            <label class="layui-form-label">甯佸埆<label style="color:red"> * </label></label>
+                                            <div class="layui-input-inline">
+                                                <input type="text" name="HCurName" id="HCurName" class="layui-input" value="" style="float: left; width: 150px; background-color: #efefef4d;" readonly>
+                                                <input type="hidden" name="HCurID" id="HCurID" class="layui-input" value="0" style="float:left;width:150px;">
+                                                <button type="button" lay-submit="" class="layui-btn" lay-filter="HCurList" style="width:40px;">
+                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
+                                                </button>
+                                            </div>
+                                        </div>
+                                        <div class="layui-inline">
+                                            <label class="layui-form-label">姹囩巼<label style="color:red"> * </label></label>
+                                            <div class="layui-input-inline">
+                                                <input class="layui-input" name="HExRate" id="HExRate" autocomplete="off" value="0" style="background-color: #efefef4d;" readonly>
+                                            </div>
+                                        </div>
+                                        <div class="layui-inline">
+                                            <label class="layui-form-label">鍐呴儴璁㈠崟鍙�</label>
+                                            <div class="layui-input-inline">
+                                                <input class="layui-input" name="HInnerBillNo" id="HInnerBillNo" autocomplete="off" style="background-color: #efefef4d;" readonly>
+                                            </div>
+                                        </div>
+                                    </div>
+                                    <div class="layui-row">
+                                        <div class="layui-inline">
+                                            <label class="layui-form-label">缁撶畻鏂瑰紡</label>
+                                            <div class="layui-input-inline">
+                                                <input type="text" name="HSSName" id="HSSName" class="layui-input" value="" style="float: left; width: 150px; background-color: #efefef4d;" readonly>
+                                                <input type="hidden" name="HSSID" id="HSSID" class="layui-input" value="0" style="float:left;width:150px;">
+                                                <button type="button" lay-submit="" class="layui-btn" lay-filter="HSSList" style="width:40px;">
+                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
+                                                </button>
+                                            </div>
+                                        </div>
+                                        <div class="layui-inline">
+                                            <label class="layui-form-label">缁撶畻鍙�</label>
+                                            <div class="layui-input-inline">
+                                                <input class="layui-input" name="HSSNum" id="HSSNum" autocomplete="off">
+                                            </div>
+                                        </div>
+                                        <div class="layui-inline" style="width:900px;">
+                                            <label class="layui-form-label">缁撶畻鍗曚綅<label style="color:red"> * </label></label>
+                                            <div class="layui-input-inline" style="width:750px;">
+                                                <input type="text" name="HAccSupName" id="HAccSupName" class="layui-input" value="" style="float: left; width: 475px; background-color: #efefef4d;" readonly>
+                                                <input type="hidden" name="HAccSupID" id="HAccSupID" class="layui-input" value="0" style="float:left;width:150px;">
+                                                <button type="button" lay-submit="" class="layui-btn" lay-filter="HAccSupList" style="width:40px;">
+                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
+                                                </button>
+                                            </div>
+                                        </div>
+                                    </div>
+                                    <div class="layui-row">
+                                        <div class="layui-inline">
+                                            <label class="layui-form-label">璐㈠姟鏃ユ湡</label>
+                                            <div class="layui-input-inline">
+                                                <input type="date" class="layui-input" lay-verify="HAccDate" name="HAccDate" id="HAccDate" style="padding-left: 80px;">
+                                            </div>
+                                        </div>
+                                    </div>
+                                </div>
+                            </div>
                             <!--鍒跺崟淇℃伅-->
                             <div class="layui-tab-item">
                                 <div class="layui-form-item">
diff --git "a/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\351\207\207\350\264\255\350\256\242\345\215\225/Cg_POOrderBillList.html" "b/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\351\207\207\350\264\255\350\256\242\345\215\225/Cg_POOrderBillList.html"
index bf4197b..2feca0e 100644
--- "a/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\351\207\207\350\264\255\350\256\242\345\215\225/Cg_POOrderBillList.html"
+++ "b/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\351\207\207\350\264\255\350\256\242\345\215\225/Cg_POOrderBillList.html"
@@ -108,18 +108,18 @@
                                         </div>
                                     </div>
                                     <!--<div class="layui-inline">
-            <label class="layui-form-label">涓氬姟鍛�</label>
-            <div class="layui-input-block" style="width:190px;">
-                <select name="HEmpName" lay-filter="HEmpName" id="HEmpName">
-                    <option value="">鍏ㄩ儴</option>
-                    <option value="鏉庣編闇�">鏉庣編闇�</option>
-                    <option value="寰愬阀涔�">寰愬阀涔�</option>
-                    <option value="鏃舵枃浠�">鏃舵枃浠�</option>
-                    <option value="姹熸闃�">姹熸闃�</option>
-                    <option value="鏄撴柊绾�">鏄撴柊绾�</option>
-                </select>
-            </div>
-        </div>-->
+                    <label class="layui-form-label">涓氬姟鍛�</label>
+                    <div class="layui-input-block" style="width:190px;">
+                        <select name="HEmpName" lay-filter="HEmpName" id="HEmpName">
+                            <option value="">鍏ㄩ儴</option>
+                            <option value="鏉庣編闇�">鏉庣編闇�</option>
+                            <option value="寰愬阀涔�">寰愬阀涔�</option>
+                            <option value="鏃舵枃浠�">鏃舵枃浠�</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">
@@ -131,11 +131,11 @@
                                         </div>
                                     </div>
                                     <!--<div class="layui-inline">
-            <label class="layui-form-label">鍙嶉鐘舵��</label>
-            <div class="layui-input-block">
-                <input type="text" class="layui-input" name="HXTFKStatus" id="HXTFKStatus" style="width:190px;">
-            </div>
-        </div>-->
+                    <label class="layui-form-label">鍙嶉鐘舵��</label>
+                    <div class="layui-input-block">
+                        <input type="text" class="layui-input" name="HXTFKStatus" id="HXTFKStatus" style="width:190px;">
+                    </div>
+                </div>-->
                                     <div class="layui-inline">
                                         <label class="layui-form-label">鐗╂枡缂栫爜</label>
                                         <div class="layui-input-block">
@@ -276,6 +276,7 @@
                             </div>
                         </div>
                         <table class="" id="mainTable" lay-filter="mainTable"></table>
+                        <div id="page" style="position: relative; bottom: 0;"></div>
                         <script type="text/html" id="toolbarDemo">
                             <div class="layui-btn-container" id="toolbarDemo_ButtonSet">
                                 <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add" id="Add"><i class="layui-icon layui-icon-file-b"></i>鏂板</button>
@@ -347,7 +348,8 @@
             var Name = "MouldProdInHouseCellWidth";
             var HModName = "Cg_POOrderBillList";
         var HBillType = "1102";
-
+            var page = 1;//鍒嗛〉鏁版嵁
+            var size = 50;
             //#region 銆愬姩鎬佽幏鍙栨ā鍧楀悕绉般��
             var HModuleType = "1102";
             //閫氳繃鍗曟嵁绫诲瀷锛屼粠鏁版嵁搴撳姩鎬佽幏鍙栧崟鎹ā鍧楀懡鍚�,寮曠敤js鏂囦欢 PageTitle.js
@@ -503,6 +505,11 @@
             //閲嶇疆鎸夐挳
             form.on('submit(btnReSearch)', function (data) {
                 set_ClearQuery();
+                if (page != 1) {
+                    $("#page a:eq(1)").get(0).click();//鐐瑰嚮鍒嗛〉鏍忕涓�椤�
+                } else {
+                    get_FastQuery();
+                }
             });
 
             table.on('tool(mainTable)' , function (obj) {
@@ -576,7 +583,11 @@
 
             //鏌ヨ鎸夐挳
             form.on('submit(btnSearch)', function (data) {
-                get_FastQuery(table, option,2);
+                if (page != 1) {
+                    $("#page a:eq(1)").get(0).click();//鐐瑰嚮鍒嗛〉鏍忕涓�椤�
+                } else {
+                    get_FastQuery(table, option, 2);
+                }
             });
 
             //琛ㄥご淇℃伅閮ㄩ棬寮圭獥
@@ -855,11 +866,11 @@
                     elem: '#mainTable'
                     , toolbar: '#toolbarDemo'
                     , height: 'full-50'
-                    , page: true
+                    , page: false
                     , totalRow: true
                     , cellMinWidth: 90
                     , limit: 50
-                    , limits: [50, 500, 5000, 20000]
+                    //, limits: [50, 500, 5000, 20000]
                     , cols: [[
                         { type: 'checkbox', fixed: 'left', totalRowText: '鍚堣' }
                         ,{ field: 'hmainid', title: 'hmainid', sort: true, hide: true }
@@ -961,6 +972,28 @@
                         soulTable.render(this);
                     }
                 };
+                optionPage = {
+                    elem: 'page', //娉ㄦ剰锛岃繖閲岀殑 page 鏄� ID锛屼笉鐢ㄥ姞 # 鍙�
+                    count: 10000, //鏁版嵁鎬绘暟锛屼粠鏈嶅姟绔緱鍒�
+                    limit: 50,
+                    limits: [50, 500, 1000, 2000],
+                    layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'],
+                    jump: function (obj, first) {
+                        //console.log(obj)
+                        //obj鍖呭惈浜嗗綋鍓嶅垎椤电殑鎵�鏈夊弬鏁帮紝姣斿锛�
+                        //console.log(obj.curr); //寰楀埌褰撳墠椤碉紝浠ヤ究鍚戞湇鍔$璇锋眰瀵瑰簲椤电殑鏁版嵁銆�
+                        //console.log(obj.limit); //寰楀埌姣忛〉鏄剧ず鐨勬潯鏁�
+
+                        //棣栨涓嶆墽琛�
+                        if (!first) {
+                            //do something
+                            page = obj.curr;
+                            size = obj.limit;
+                            get_FastQuery();
+                        }
+                    }
+                }
+                laypage.render(optionPage);
                 ////璁剧疆鍒楀
                 //var colWidth = getColumnsWidth();
                 //if (colWidth == "" || colWidth == []) {
@@ -1064,6 +1097,86 @@
                     }
                 });
             }
+
+            //#region 鍒嗛〉鏌ヨ
+            function get_DisplayPage(sWhere) {
+                var ajaxLoad = layer.load();
+                $.ajax({
+                    url: GetWEBURL() + '/Cg_POOrderBill/page',
+                    type: "GET",
+                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "page": page, "size": size },
+                    success: function (data1) {
+                        option.limit = size;//鏀瑰彉琛ㄦ牸椤靛ぇ灏�
+                        if (data1.code == 1) {
+                            optionPage.count = data1.count;//鏀瑰彉鍒楄〃鏁版嵁鎬绘暟
+                            var data = [];//鍒楀瓧娈垫暟鎹�
+                            var col = [];
+                            var totalArray = ["鏁伴噺", "鍏宠仈鏁伴噺", "鏈叧鑱旀暟閲�", "鎵撳嵃鏉$爜鏁伴噺", "鏈墦鍗版潯鐮佹暟閲�", "瀹炴敹鏁伴噺", "閲戦"];
+                            //缁欑┖鐨勬暟缁勮祴鍊�
+                            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 ($.inArray(data[i].name, totalArray) > -1) { //璁$畻鍒�
+                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 });
+                                } else if (data[i].name == '鍗曟嵁鍙�') {//娣诲姞瓒呴摼鎺�
+                                    col.push({
+                                        field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: '鍗曟嵁鍙�', templet: function (d) {
+                                            return '<span style="color: blue;">' + d.鍗曟嵁鍙� + '</span>'
+                                        }, style: 'cursor: pointer;'
+                                    });
+                                } else if (data[i].name == '褰撳墠瀹℃牳椤圭洰') {//娣诲姞瓒呴摼鎺�
+                                    col.push({
+                                        field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: '褰撳墠瀹℃牳椤圭洰', templet: function (d) {
+                                            return '<span style="color: blue;">' + d.褰撳墠瀹℃牳椤圭洰 + '</span>'
+                                        }, style: 'cursor: pointer;'
+                                    });
+                                } 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 == "琛屽叧闂棩鏈�" ? "琛屽叧闂汉" : data[i].name) + " ==''?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 200 });
+                                            break;
+                                        default:
+                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
+                                    }
+                                }
+                            }
+
+                            option.cols = [col];
+                            option.data = data1.data;
+                            laypage.render(optionPage);
+                            //鍒锋柊琛ㄦ牸鏁版嵁
+                            DisPlay_HideColumn();
+
+                            //鍒锋柊鎸夐挳鏄剧ず
+                            var set_HideButton_ID = "toolbarDemo_ButtonSet";                    //闇�瑕佽缃殑鎸夐挳鐨勭埗绾ц妭鐐圭殑id
+                            var HBillType = "1102";
+                            Display_HideButton(set_HideButton_ID, HBillType, HModName, sessionStorage["HUserName"]);
+                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
+                                ColFilter();
+                            }
+                            layer.close(ajaxLoad);
+                            //layer.alert("鏌ヨ鎴愬姛", { icon: 1 });
+                        } else {
+                            //option.data = [[]]
+                            //table.render(option);
+                            layer.close(ajaxLoad);
+                            layer.alert(data1.code + data1.Message, { icon: 5 });
+                        }
+                    }, error: function () {
+                        layer.close(ajaxLoad);
+                        layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+                    }
+                });
+            }
+            //#endregion
 
             //鏂板
             function set_AddNew() {
@@ -2302,7 +2415,7 @@
                 //娣诲姞鏌ヨ鏉′欢锛屾牴鎹綋鍓嶇櫥褰曠敤鎴峰叧鑱旇亴鍛樿繑鍥炴暟鎹�
                 //sWhere += " and HUserID =" + sessionStorage["Czybm"]
                 var index = layer.load(0);
-                get_Display(sWhere);
+                get_DisplayPage(sWhere);
                 //璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
                 sWhere = "";
             }
@@ -2335,7 +2448,6 @@
                 $("select[name='HFeedback']").val("");
                 form.render('select');
                 sWhere = "";
-                get_Display(sWhere);
             }
             //閲嶆柊鍚屾鎸夐挳
             function set_ResCnz() {

--
Gitblit v1.9.1