MES-WEB-LayUI.git

parent: 831ee5eb | 补丁 | 提交 | ignore whitespace

yangle

2023-12-22 9cf675865b67bc94ee6c97c2fb61b9ef2e825f6a

逆向追溯查询报表
质量追溯查询报表

3个文件已修改

	WebTM/views/index.html	4 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/views/车间管理/单品过站/BadQueryReport.html	341 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/views/车间管理/单品过站/RetrospectiveQueryReport.html	507 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 WebTM/views/index.html

@@ -606,8 +606,8 @@
                                        <dd><a lay-href="è½¦é´ç®¡ç/ååè¿ç«/Cj_ProcessItemBGA.html">å·¥åºååè¿ä¿®å°</a></dd>
                                        <!--<dd><a lay-href="è½¦é´ç®¡ç/ååè¿ç«/Cj_ProcessItemBGA_PJGH.html">å·¥åºååè¿ä¿®å°(éä»¶æ´æ¢)</a></dd>-->
                                        <dd><a lay-href="è½¦é´ç®¡ç/ååè¿ç«/Sc_SourceLineRepairBillList.html">è¿ä¿®è®°å½åè¡¨</a></dd>
                                        <dd><a lay-href="è½¦é´ç®¡ç/ååè¿ç«/RetrospectiveQueryReport.html">åæ ¼è¿½æº¯æ¥è¯¢æ¥è¡¨</a></dd>
                                        <dd><a lay-href="è½¦é´ç®¡ç/ååè¿ç«/BadQueryReport.html">ä¸è¯è¿½æº¯æ¥è¯¢æ¥è¡¨</a></dd>
                                        <dd><a lay-href="è½¦é´ç®¡ç/ååè¿ç«/RetrospectiveQueryReport.html">è´¨éè¿½æº¯æ¥è¯¢</a></dd>
                                        <dd><a lay-href="è½¦é´ç®¡ç/ååè¿ç«/BadQueryReport.html">éåè¿½æº¯æ¥è¯¢æ¥è¡¨</a></dd>
                                    </dl>
                                </dd>
                            </dl>

 WebTM/views/³µ¼ä¹ÜÀí/µ¥Æ·¹ýÕ¾/BadQueryReport.html

@@ -2,7 +2,7 @@
<html>
<head>
    <meta charset="utf-8" />
    <title>ä¸è¯è¿½æº¯æ¥è¯¢æ¥è¡¨</title>
    <title>éåè¿½æº¯æ¥è¯¢æ¥è¡¨</title>
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/layui/layui.js"></script>
@@ -26,21 +26,27 @@
                                    </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="HICMOBillNo" id="HICMOBillNo" value="">
                                        <input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber" value="">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 76px;">äº§åæ¡ç </label>
                                    <label class="layui-form-label">ç©æåç§°</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HBardCode" id="HBardCode" value="">
                                        <input type="text" class="layui-input" name="HMaterName" id="HMaterName" value="" style="background-color: #efefef4d;" readonly>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">æµè½¬å¡å·</label>
                                    <label class="layui-form-label" style="width: 76px;">è§æ ¼åå·</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HProcExchBillNo" id="HProcExchBillNo" value="">
                                        <input type="text" class="layui-input" name="HMaterModel" id="HMaterModel" value="" style="background-color: #efefef4d;" readonly>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">æ¹æ¬¡å·</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HBatchNo" id="HBatchNo">
                                    </div>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
@@ -81,10 +87,41 @@
                                </div>
                            </div>
                        </div>
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <script type="text/html" id="toolbarDemo">
                        <div class="layui-tab layui-tab-card">
                            <ul class="layui-tab-title">
                                <li class="layui-this">æµè½¬å¡æ¸å</li>
                                <li>äº§åç ç»å®æ¸å</li>
                                <li>åºå¥åºè®°å½</li>
                                <!--<li>ç¸å³åºåæ¸å</li>-->
                            </ul>
                            <div class="layui-tab-content">
                                <div class="layui-tab-item layui-show">
                                    <!--æµè½¬å¡æ¸å-->
                                    <table class="layui-hide" id="mainTable1" lay-filter="mainTable1"></table>
                                </div>
                                <div class="layui-tab-item">
                                    <!--äº§åç ç»å®æ¸å-->
                                    <table class="layui-hide" id="mainTable2" lay-filter="mainTable2"></table>
                                </div>
                                <div class="layui-tab-item">
                                    <!--åºå¥åºè®°å½-->
                                    <table class="layui-hide" id="mainTable3" lay-filter="mainTable3"></table>
                                </div>
                                <div class="layui-tab-item">
                                    <!--ç¸å³åºåæ¸å-->
                                    <table class="layui-hide" id="mainTable4" lay-filter="mainTable4"></table>
                                </div>
                            </div>
                        </div>

                        <script type="text/html" id="toolbarDemo1">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>åè®¾ç½®</button>
                            </div>
                        </script>
                        <script type="text/html" id="toolbarDemo5">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn5"><i class="layui-icon layui-icon-form"></i>åè®¾ç½®</button>
                            </div>
                        </script>
                    </form>
@@ -112,8 +149,14 @@
            , laydate = layui.laydate
            , soulTable = layui.soulTable
        var sWhere = "";
        var option = [];
        var HModName = "BadQueryReport";
        var option1 = [];
        var option2 = [];
        var option3 = [];
        var option4 = [];
        var option5 = [];
        var option6 = [];
        var option7 = [];
        var HModName = "RetrospectiveQueryReport";
        var titleData = ["HInterID", "HEntryID", "HBadReasonID", "HSourceInterID", "HSourceEntryID"];//åè¡¨ä¸éè¦æ¾ç¤ºçåæ®µ å¯æ©å±

        //#endregion
@@ -130,7 +173,7 @@
        //#region è§¦åäºä»¶ï¼åæ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç

        // å¤´å·¥å·æ äºä»¶
        table.on('toolbar(mainTable)', function (obj) {
        table.on('toolbar(mainTable1)', function (obj) {
            switch (obj.event) {
                //åè®¾ç½®
                case 'set_HideColumn': get_HideColumn();
@@ -152,15 +195,15 @@
            //æ¥è¯¢
            get_FastQuery();
        }

        // æ¥è¯¢
        function get_Display(sWhere) {
        // æµè½¬å¡æ¸å
        function get_Display1(sWhere) {

            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/Cj_SingleStation/BadQueryReport',
                url: GetWEBURL() + '/Cj_SingleStation/Sc_ProcessExchangeBillMainList',
                type: "GET",
                data: { "HBardCode": $("#HBardCode").val(), "HProcExchBillNo": $("#HProcExchBillNo").val(), "HICMOBillNo": $("#HICMOBillNo").val(), "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                async: false,
                data: { "HMaterNumber": $("#HMaterNumber").val(), "HBatchNo": $("#HBatchNo").val(), "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.count == 1) {
                        var data = [];
@@ -189,9 +232,9 @@
                        }

                        //å¨ææ¾ç¤ºåå
                        option = {
                            elem: '#mainTable'
                            , toolbar: '#toolbarDemo'
                        option1 = {
                            elem: '#mainTable1'
                            , toolbar: '#toolbarDemo1'
                            , cols: [col]
                            , data: data1.data
                            , height: 800
@@ -204,7 +247,12 @@
                                soulTable.render(this);
                            }
                        }
                        table.render(option);
                        table.render(option1);
                        if ($("#HBardCode").val() != "" && data1.data.length != 0) {
                            $("#HICMOBillNo").val(data1.data[0]["çäº§è®¢åå·"]);
                            $("#HProcExchBillNo").val(data1.data[0]["æµè½¬å¡"]);
                        }


                        //å·æ°è¡¨æ ¼æ°æ®
                        DisPlay_HideColumn();
@@ -225,8 +273,203 @@
            });
        }

        // äº§åç ç»å®æ¸å
        function get_Display2(sWhere) {

            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/Cj_SingleStation/HBardcodeList',
                type: "GET",
                async: false,
                data: { "HMaterNumber": $("#HMaterNumber").val(), "HBatchNo": $("#HBatchNo").val(), "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.count == 1) {
                        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' });
                        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 {
                                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 HH:mm:ss')}}</div>", width: 180 });
                                        break;
                                    default:
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 150 });
                                }
                            }
                        }

                        //å¨ææ¾ç¤ºåå
                        option2 = {
                            elem: '#mainTable2'
                            , toolbar: '#toolbarDemo1'
                            , cols: [col]
                            , data: data1.data
                            , height: 800
                            , page: true
                            , totalRow: true
                            , cellMinWidth: 90
                            , limit: 50
                            , limits: [50, 500, 5000, 20000]
                            , done: function (res, curr, count) {
                                soulTable.render(this);
                            }
                        }
                        table.render(option2);
                        if ($("#HBardCode").val() != "" && data1.data.length != 0) {
                            $("#HICMOBillNo").val(data1.data[0]["çäº§è®¢åå·"]);
                            $("#HProcExchBillNo").val(data1.data[0]["æµè½¬å¡"]);
                        }


                        //å·æ°è¡¨æ ¼æ°æ®
                        DisPlay_HideColumn();

                        if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                            ColFilter();
                        }

                        layer.close(ajaxLoad);
                    } else {
                        layer.close(ajaxLoad);
                        layer.alert(data1.code + data1.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.close(ajaxLoad);
                    layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
                }
            });
        }

        //åºå¥åºè®°å½
        function get_Display3(sWhere) {

            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/Cj_SingleStation/BardCodeOutInList',
                type: "GET",
                async: false,
                data: { "HMaterNumber": $("#HMaterNumber").val(), "HBatchNo": $("#HBatchNo").val(), "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.count == 1) {
                        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' });
                        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 {
                                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 HH:mm:ss')}}</div>", width: 180 });
                                        break;
                                    default:
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 150 });
                                }
                            }
                        }

                        //å¨ææ¾ç¤ºåå
                        option3 = {
                            elem: '#mainTable3'
                            , toolbar: '#toolbarDemo3'
                            , cols: [col]
                            , data: data1.data
                            , height: 800
                            , page: true
                            , totalRow: true
                            , cellMinWidth: 90
                            , limit: 50
                            , limits: [50, 500, 5000, 20000]
                            , done: function (res, curr, count) {
                                soulTable.render(this);
                            }
                        }
                        table.render(option3);
                        layer.close(ajaxLoad);
                    } else {
                        layer.close(ajaxLoad);
                        layer.alert(data1.code + data1.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.close(ajaxLoad);
                    layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
                }
            });
        }

        //ç¸å³åºåæ¸å
        function get_Display4(sWhere) {
            var sWhere = " and HMaterSN='" + HBardcode + "'";

            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/Cj_SingleStation/Sc_SourceLineRepairBillSub_MaterList',
                type: "GET",
                async: false,
                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.count == 1) {
                        //å¨ææ¾ç¤ºåå
                        option4 = {
                            elem: '#mainTable4'
                            , toolbar: '#toolbarDemo4'
                            , cols: [[
                                { type: 'checkbox', fixed: 'left' }
                                , { type: 'numbers', title: 'åºå·' }
                                , { field: 'HICMOBillNo', title: 'çäº§è®¢å' }
                                , { field: 'HDate', title: 'æ¥æ' }
                                , { field: 'HMaterNumber', title: 'éä»¶ç©æç¼ç ' }
                                , { field: 'HMaterName', title: 'éä»¶ç©æåç§°' }
                                , { field: 'HBarCode', title: 'éä»¶SNç ' }
                                , { field: 'HMaterSN', title: 'äº§åSNç ' }

                            ]]
                            , data: data1.data
                            , height: 800
                            , page: true
                            , totalRow: true
                            , cellMinWidth: 90
                            , limit: 50
                            , limits: [50, 500, 5000, 20000]
                            , done: function (res, curr, count) {
                                soulTable.render(this);
                            }
                        }
                        table.render(option4);
                        layer.close(ajaxLoad);
                    } else {
                        layer.close(ajaxLoad);
                        layer.alert(data1.code + data1.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.close(ajaxLoad);
                    layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
                }
            });
        }

        // å¿«éè¿æ»¤
        function get_FastQuery() {

            var ColName = $("#ColName").val();//å¤éæ¡
            var Comparator = $("#Comparator").val()
            var ColContent = $("#ColContent").val();
@@ -253,7 +496,13 @@
                com = " and (" + ColName + " " + com + ")";
            }

            get_Display(sWhere);
            sWhere += com;

            get_Display1(sWhere);//æµè½¬å¡æ¸å
            get_Display2(sWhere);//äº§åç ç»å®æ¸å
            get_Display3(sWhere);//åºå¥åºè®°å½
            //get_Display4(HBardCode);//ç¸å³åºåæ¸å

            sWhere = "";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
        }

@@ -261,8 +510,8 @@
        function get_HideColumn() {
            var colName = "";
            var contentUrl = "";
            for (var i = 1; i < option.cols[0].length - 1; i++) {
                colName += option.cols[0][i]["title"] + ",";
            for (var i = 1; i < option1.cols[0].length - 1; i++) {
                colName += option1.cols[0][i]["title"] + ",";
            }
            var urlStr = window.document.location.pathname;//è·åæä»¶è·¯å¾
            var urlLen = urlStr.split('/');
@@ -307,50 +556,50 @@

                        dataCol = data1.data[0].HGridString.split(',');

                        for (var i = 0; i < option.cols[0].length - 2; i++) {
                        for (var i = 0; i < option1.cols[0].length - 2; i++) {
                            var dataCols = dataCol[i].split('|');
                            //éèå
                            if (dataCols[1] == 1) {
                                option.cols[0][i + 1]["hide"] = true;
                                option1.cols[0][i + 1]["hide"] = true;
                            }
                            //è®¾ç½®åå®½
                            if (dataCols[3] > 0) {
                                option.cols[0][i + 1]["width"] = dataCols[3];
                                option1.cols[0][i + 1]["width"] = dataCols[3];
                            }
                            //è®¾ç½®åå®¹åä½å¤§å°
                            if (data1.data[0].HFontSize != 0) {
                                option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                                option1.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                            } else {
                                option.cols[0][i + 1]["style"] = "font-size:100%";
                                option1.cols[0][i + 1]["style"] = "font-size:100%";
                            }
                            //è®¾ç½®åå®½
                            //if (data1.data[0].HColumnWidth != 0) {
                            //    option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
                            //    option1.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
                            //} else {
                            //    option.cols[0][i + 1]["width"] = "";
                            //    option1.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;
                            if (dataCols[1] == 0 && $.inArray(option1.cols[0][i + 1]["title"], titleData) == -1) {
                                option1.cols[0][i + 1]["hide"] = false;
                            }
                            //åä½æå¨ä½ç½®(å·¦ å±ä¸ å³)
                            switch (dataCols[2]) {
                                case "L":
                                    option.cols[0][i + 1]["align"] = "left";
                                    option1.cols[0][i + 1]["align"] = "left";
                                    break;
                                case "M":
                                    option.cols[0][i + 1]["align"] = "center";
                                    option1.cols[0][i + 1]["align"] = "center";
                                    break;
                                case "R":
                                    option.cols[0][i + 1]["align"] = "right";
                                    option1.cols[0][i + 1]["align"] = "right";
                                    break;
                            }
                        }

                        //åæ¶å»ç»å
                        for (var i = 1; i < option.cols[0].length - 1; i++) {
                            if (option.cols[0][i]["fixed"] != null) {
                                option.cols[0][i]["fixed"] = null;
                        for (var i = 1; i < option1.cols[0].length - 1; i++) {
                            if (option1.cols[0][i]["fixed"] != null) {
                                option1.cols[0][i]["fixed"] = null;
                            }
                            else {
                                break;
@@ -359,15 +608,15 @@
                        //å»ç»å
                        if (data1.data[0].HFixCols != 0) {
                            for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
                                if ($.inArray(option1.cols[0][i + 1]["title"], titleData) != -1) {
                                    data1.data[0].HFixCols += 1;
                                }
                                option.cols[0][i + 1]["fixed"] = "left";
                                option1.cols[0][i + 1]["fixed"] = "left";
                            }
                        }
                        table.render(option);
                        table.render(option1);
                    } else {
                        table.render(option);
                        table.render(option1);
                    }
                }, error: function () {
                    layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
@@ -378,9 +627,9 @@
        // åææ¾ç¤ºä¸ææ¡
        function ColFilter() {
            var Organization = '<option  value="0" selected="selected" ></option>';
            for (var i = 1; i < option.cols[0].length; i++) {
                if (option.cols[0][i].hide != true) {
                    Organization += '<option  style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
            for (var i = 1; i < option1.cols[0].length; i++) {
                if (option1.cols[0][i].hide != true) {
                    Organization += '<option  style="color:blue;" value="' + option1.cols[0][i].field + '">' + option1.cols[0][i].field + '</option>';
                }
            }
            $("#ColName").empty();

 WebTM/views/³µ¼ä¹ÜÀí/µ¥Æ·¹ýÕ¾/RetrospectiveQueryReport.html

@@ -2,7 +2,7 @@
<html>
<head>
    <meta charset="utf-8" />
    <title>åæ ¼è¿½æº¯æ¥è¯¢æ¥è¡¨</title>
    <title>è´¨éè¿½æº¯æ¥è¯¢æ¥è¡¨</title>
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/layui/layui.js"></script>
@@ -28,7 +28,7 @@
                                <div class="layui-inline">
                                    <label class="layui-form-label">çäº§è®¢åå·</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HICMOBillNo" id="HICMOBillNo"  value="">
                                        <input type="text" class="layui-input" name="HICMOBillNo" id="HICMOBillNo" value="">
                                    </div>
                                </div>
                                <div class="layui-inline">
@@ -40,7 +40,7 @@
                                <div class="layui-inline">
                                    <label class="layui-form-label">æµè½¬å¡å·</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HProcExchBillNo" id="HProcExchBillNo"  value="">
                                        <input type="text" class="layui-input" name="HProcExchBillNo" id="HProcExchBillNo">
                                    </div>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
@@ -49,7 +49,7 @@
                                <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" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin-top:10px;margin-left:5%;">
                                       

                                    </div>
                                    <div class="layui-row" style="margin-top: 10px; margin-bottom: 10px ">
                                        <div class="layui-inline">
@@ -81,10 +81,56 @@
                                </div>
                            </div>
                        </div>
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <script type="text/html" id="toolbarDemo">
                        <div class="layui-tab layui-tab-card">
                            <ul class="layui-tab-title">
                                <li class="layui-this">è¿åºç«è®°å½</li>
                                <li>ä¸è¯æ±æ¥è®°å½</li>
                                <li>å·¥èºåæ°è®°å½</li>
                                <li>éä»¶æ¸å</li>
                                <li>è¿ä¿®è®°å½</li>
                                <li>éä»¶åæ´è®°å½</li>
                                <!--<li>åºå¥åºè®°å½</li>-->
                            </ul>
                            <div class="layui-tab-content">
                                <div class="layui-tab-item layui-show">
                                    <!--è¿åºç«è®°å½-->
                                    <table class="layui-hide" id="mainTable2" lay-filter="mainTable2"></table>
                                </div>
                                <div class="layui-tab-item">
                                    <!--ä¸è¯æ±æ¥è®°å½-->
                                    <table class="layui-hide" id="mainTable5" lay-filter="mainTable5"></table>
                                </div>
                                <div class="layui-tab-item">
                                    <!--å·¥èºåæ°è®°å½-->
                                    <table class="layui-hide" id="mainTable7" lay-filter="mainTable7"></table>
                                </div>
                                <div class="layui-tab-item">
                                    <!--éä»¶æ¸å-->
                                    <table class="layui-hide" id="mainTable3" lay-filter="mainTable3"></table>
                                </div>
                                <div class="layui-tab-item">
                                    <!--è¿ä¿®è®°å½-->
                                    <table class="layui-hide" id="mainTable6" lay-filter="mainTable6"></table>
                                </div>
                                <div class="layui-tab-item">
                                    <!--éä»¶åæ´è®°å½-->
                                    <table class="layui-hide" id="mainTable4" lay-filter="mainTable4"></table>
                                </div>
                                <div class="layui-tab-item">
                                    <!--åºå¥åºè®°å½-->
                                    <table class="layui-hide" id="mainTable1" lay-filter="mainTable1"></table>
                                </div>
                            </div>
                        </div>

                        <script type="text/html" id="toolbarDemo1">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>åè®¾ç½®</button>
                            </div>
                        </script>
                        <script type="text/html" id="toolbarDemo5">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn5"><i class="layui-icon layui-icon-form"></i>åè®¾ç½®</button>
                            </div>
                        </script>
                    </form>
@@ -112,7 +158,13 @@
            , laydate = layui.laydate
            , soulTable = layui.soulTable
        var sWhere = "";
        var option = [];
        var option1 = [];
        var option2 = [];
        var option3 = [];
        var option4 = [];
        var option5 = [];
        var option6 = [];
        var option7 = [];
        var HModName = "RetrospectiveQueryReport";
        var titleData = ["HInterID", "HEntryID", "HBadReasonID", "HSourceInterID", "HSourceEntryID"];//åè¡¨ä¸éè¦æ¾ç¤ºçåæ®µ å¯æ©å±

@@ -130,7 +182,7 @@
        //#region è§¦åäºä»¶ï¼åæ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç

        // å¤´å·¥å·æ äºä»¶
        table.on('toolbar(mainTable)', function (obj) {
        table.on('toolbar(mainTable2)', function (obj) {
            switch (obj.event) {
                //åè®¾ç½®
                case 'set_HideColumn': get_HideColumn();
@@ -138,6 +190,34 @@
            };
        });

        table.on('row(mainTable2)', function (obj) {
            var HBardcode = obj.data["æ¡ç "];
            get_Display3(HBardcode);//éä»¶æ¸å
            get_Display6(HBardcode);//è¿ä¿®è®°å½
            get_Display7(HBardcode);//å·¥èºåæ°
        })

        table.on('row(mainTable5)', function (obj) {
            var HBardcode = obj.data["æ¡ç "];
            get_Display3(HBardcode);//éä»¶æ¸å
            get_Display6(HBardcode);//è¿ä¿®è®°å½
            get_Display7(HBardcode);//å·¥èºåæ°
        })

        table.on('row(mainTable6)', function (obj) {
            var HBardcode = obj.data["SNç "];
            get_Display4(HBardcode);//éä»¶åæ´è®°å½
        })


        table.on('toolbar(mainTable5)', function (obj) {
            switch (obj.event) {
                //åè®¾ç½®
                case 'set_HideColumn5': get_HideColumn5();
                    break;
            };
        });
    
        //æ¥è¯¢æé®
        form.on('submit(btnSearch)', function (data) {//éæ©ä»ä½
            get_FastQuery();
@@ -153,13 +233,210 @@
            get_FastQuery();
        }

        // æ¥è¯¢
        function get_Display(sWhere) {
        // è¿åºç«æ¥è¯¢
        function get_Display2(sWhere) {

            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/Cj_SingleStation/RetrospectiveQueryReport',
                url: GetWEBURL() + '/Cj_SingleStation/EntryAndExitRecords',
                type: "GET",
                async: false,
                data: { "HBardCode": $("#HBardCode").val(), "HProcExchBillNo": $("#HProcExchBillNo").val(), "HICMOBillNo": $("#HICMOBillNo").val(), "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.count == 1) {
                        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' });
                        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 {
                                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 HH:mm:ss')}}</div>", width: 180 });
                                        break;
                                    default:
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 150 });
                                }
                            }
                        }

                        //å¨ææ¾ç¤ºåå
                        option2 = {
                            elem: '#mainTable2'
                            , toolbar: '#toolbarDemo1'
                            , cols: [col]
                            , data: data1.data
                            , height: 800
                            , page: true
                            , totalRow: true
                            , cellMinWidth: 90
                            , limit: 50
                            , limits: [50, 500, 5000, 20000]
                            , done: function (res, curr, count) {
                                soulTable.render(this);
                            }
                        }
                        table.render(option2);
                        //if ($("#HBardCode").val() != "" && data1.data.length != 0) {
                        //    $("#HICMOBillNo").val(data1.data[0]["çäº§è®¢åå·"]);
                        //    $("#HProcExchBillNo").val(data1.data[0]["æµè½¬å¡"]);
                        //}
                     

                        //å·æ°è¡¨æ ¼æ°æ®
                        DisPlay_HideColumn();

                        if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                            ColFilter();
                        }

                        layer.close(ajaxLoad);
                    } else {
                        layer.close(ajaxLoad);
                        layer.alert(data1.code + data1.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.close(ajaxLoad);
                    layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
                }
            });
        }

        //éä»¶æ¸å
        function get_Display3(HBardcode) {

            var sWhere = " and äº§åæ¡ç ='" + HBardcode + "'";

            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/Sc_AssemblyBill/list1',
                type: "GET",
                async: false,
                data: { "sWhere": sWhere },
                success: function (data1) {
                    if (data1.count == 1) {
                        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' });
                        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 {
                                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 HH:mm:ss')}}</div>", width: 180 });
                                        break;
                                    default:
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 150 });
                                }
                            }
                        }

                        //å¨ææ¾ç¤ºåå
                        option3 = {
                            elem: '#mainTable3'
                            , toolbar: '#toolbarDemo3'
                            , cols: [col]
                            , data: data1.data
                            , height: 800
                            , page: true
                            , totalRow: true
                            , cellMinWidth: 90
                            , limit: 50
                            , limits: [50, 500, 5000, 20000]
                            , done: function (res, curr, count) {
                                soulTable.render(this);
                            }
                        }
                        table.render(option3);
                        layer.close(ajaxLoad);
                    } else {
                        layer.close(ajaxLoad);
                        layer.alert(data1.code + data1.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.close(ajaxLoad);
                    layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
                }
            });
        }

        //éä»¶åæ´è®°å½
        function get_Display4(HBardcode) {
            var sWhere = " and HMaterSN='" + HBardcode + "'";

            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/Cj_SingleStation/Sc_SourceLineRepairBillSub_MaterList',
                type: "GET",
                async: false,
                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.count == 1) {
                        //å¨ææ¾ç¤ºåå
                        option4 = {
                            elem: '#mainTable4'
                            , toolbar: '#toolbarDemo4'
                            , cols: [[
                                { type: 'checkbox', fixed: 'left' }
                                , { type: 'numbers', title: 'åºå·' }
                                , { field: 'HICMOBillNo', title: 'çäº§è®¢å' }
                                , { field: 'HDate', title: 'æ¥æ' }
                                , { field: 'HMaterNumber', title: 'éä»¶ç©æç¼ç ' }
                                , { field: 'HMaterName', title: 'éä»¶ç©æåç§°' }
                                , { field: 'HBarCode', title: 'éä»¶SNç ' }
                                , { field: 'HMaterSN', title: 'äº§åSNç ' }

                            ]]
                            , data: data1.data
                            , height: 800
                            , page: true
                            , totalRow: true
                            , cellMinWidth: 90
                            , limit: 50
                            , limits: [50, 500, 5000, 20000]
                            , done: function (res, curr, count) {
                                soulTable.render(this);
                            }
                        }
                        table.render(option4);
                        layer.close(ajaxLoad);
                    } else {
                        layer.close(ajaxLoad);
                        layer.alert(data1.code + data1.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.close(ajaxLoad);
                    layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
                }
            });
        }

        //ä¸è¯æ±æ¥è®°å½
        function get_Display5(sWhere) {

            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/Cj_SingleStation/BadQueryReport',
                type: "GET",
                async: false,
                data: { "HBardCode": $("#HBardCode").val(), "HProcExchBillNo": $("#HProcExchBillNo").val(), "HICMOBillNo": $("#HICMOBillNo").val(), "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.count == 1) {
@@ -190,8 +467,8 @@

                        //å¨ææ¾ç¤ºåå
                        option = {
                            elem: '#mainTable'
                            , toolbar: '#toolbarDemo'
                            elem: '#mainTable5'
                            , toolbar: '#toolbarDemo5'
                            , cols: [col]
                            , data: data1.data
                            , height: 800
@@ -206,13 +483,147 @@
                        }
                        table.render(option);

                        //å·æ°è¡¨æ ¼æ°æ®
                        DisPlay_HideColumn();
                        ////å·æ°è¡¨æ ¼æ°æ®
                        //DisPlay_HideColumn();

                        if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                            ColFilter();
                        //if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                        //    ColFilter();
                        //}

                        layer.close(ajaxLoad);
                    } else {
                        layer.close(ajaxLoad);
                        layer.alert(data1.code + data1.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.close(ajaxLoad);
                    layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
                }
            });
        }

        //è¿ä¿®è®°å½
        function get_Display6(HBardcode) {

            var sWhere = " and SNç ='" + HBardcode + "'";

            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/Cj_SingleStation/ProcessItemRepair',
                type: "GET",
                async: false,
                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.count == 1) {
                        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' });
                        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 {
                                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 HH:mm:ss')}}</div>", width: 180 });
                                        break;
                                    default:
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 150 });
                                }
                            }
                        }

                        //å¨ææ¾ç¤ºåå
                        option6 = {
                            elem: '#mainTable6'
                            , toolbar: '#toolbarDemo6'
                            , cols: [col]
                            , data: data1.data
                            , height: 800
                            , page: true
                            , totalRow: true
                            , cellMinWidth: 90
                            , limit: 50
                            , limits: [50, 500, 5000, 20000]
                            , done: function (res, curr, count) {
                                soulTable.render(this);
                            }
                        }
                        table.render(option6);
                        layer.close(ajaxLoad);
                    } else {
                        layer.close(ajaxLoad);
                        layer.alert(data1.code + data1.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.close(ajaxLoad);
                    layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
                }
            });
        }

        //å·¥èºåæ°
        function get_Display7(HBardcode) {

            var sWhere = " and æ¡ç ='" + HBardcode + "'";

            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/Cj_SingleStation/ProcessParameters',
                type: "GET",
                async: false,
                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.count == 1) {
                        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' });
                        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 {
                                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 HH:mm:ss')}}</div>", width: 180 });
                                        break;
                                    default:
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 150 });
                                }
                            }
                        }

                        //å¨ææ¾ç¤ºåå
                        option7 = {
                            elem: '#mainTable7'
                            , toolbar: '#toolbarDemo7'
                            , cols: [col]
                            , data: data1.data
                            , height: 800
                            , page: true
                            , totalRow: true
                            , cellMinWidth: 90
                            , limit: 50
                            , limits: [50, 500, 5000, 20000]
                            , done: function (res, curr, count) {
                                soulTable.render(this);
                            }
                        }
                        table.render(option7);
                        layer.close(ajaxLoad);
                    } else {
                        layer.close(ajaxLoad);
@@ -227,10 +638,12 @@

        // å¿«éè¿æ»¤
        function get_FastQuery() {
            var HBardCode = $("#HBardCode").val();
        
            var ColName = $("#ColName").val();//å¤éæ¡
            var Comparator = $("#Comparator").val()
            var ColContent = $("#ColContent").val();

          
            var com = "";
            if (ColName != 0 && Comparator != 0) {
                switch (Comparator) {
@@ -253,7 +666,15 @@
                com = " and (" + ColName + " " + com + ")";
            }

            get_Display(sWhere);
            get_Display2(sWhere);
            get_Display5(sWhere);
            if (HBardCode != "") {
                get_Display3(HBardCode);//éä»¶æ¸å
                get_Display6(HBardCode);//è¿ä¿®è®°å½
                get_Display7(HBardCode);//å·¥èºåæ°
                get_Display4(HBardCode);//éä»¶åæ´è®°å½
            }
         
            sWhere = "";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
        }

@@ -261,8 +682,8 @@
        function get_HideColumn() {
            var colName = "";
            var contentUrl = "";
            for (var i = 1; i < option.cols[0].length - 1; i++) {
                colName += option.cols[0][i]["title"] + ",";
            for (var i = 1; i < option2.cols[0].length - 1; i++) {
                colName += option2.cols[0][i]["title"] + ",";
            }
            var urlStr = window.document.location.pathname;//è·åæä»¶è·¯å¾
            var urlLen = urlStr.split('/');
@@ -307,50 +728,50 @@

                        dataCol = data1.data[0].HGridString.split(',');

                        for (var i = 0; i < option.cols[0].length - 2; i++) {
                        for (var i = 0; i < option2.cols[0].length - 2; i++) {
                            var dataCols = dataCol[i].split('|');
                            //éèå
                            if (dataCols[1] == 1) {
                                option.cols[0][i + 1]["hide"] = true;
                                option2.cols[0][i + 1]["hide"] = true;
                            }
                            //è®¾ç½®åå®½
                            if (dataCols[3] > 0) {
                                option.cols[0][i + 1]["width"] = dataCols[3];
                                option2.cols[0][i + 1]["width"] = dataCols[3];
                            }
                            //è®¾ç½®åå®¹åä½å¤§å°
                            if (data1.data[0].HFontSize != 0) {
                                option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                                option2.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                            } else {
                                option.cols[0][i + 1]["style"] = "font-size:100%";
                                option2.cols[0][i + 1]["style"] = "font-size:100%";
                            }
                            //è®¾ç½®åå®½
                            //if (data1.data[0].HColumnWidth != 0) {
                            //    option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
                            //    option2.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
                            //} else {
                            //    option.cols[0][i + 1]["width"] = "";
                            //    option2.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;
                            if (dataCols[1] == 0 && $.inArray(option2.cols[0][i + 1]["title"], titleData) == -1) {
                                option2.cols[0][i + 1]["hide"] = false;
                            }
                            //åä½æå¨ä½ç½®(å·¦ å±ä¸ å³)
                            switch (dataCols[2]) {
                                case "L":
                                    option.cols[0][i + 1]["align"] = "left";
                                    option2.cols[0][i + 1]["align"] = "left";
                                    break;
                                case "M":
                                    option.cols[0][i + 1]["align"] = "center";
                                    option2.cols[0][i + 1]["align"] = "center";
                                    break;
                                case "R":
                                    option.cols[0][i + 1]["align"] = "right";
                                    option2.cols[0][i + 1]["align"] = "right";
                                    break;
                            }
                        }

                        //åæ¶å»ç»å
                        for (var i = 1; i < option.cols[0].length - 1; i++) {
                            if (option.cols[0][i]["fixed"] != null) {
                                option.cols[0][i]["fixed"] = null;
                        for (var i = 1; i < option2.cols[0].length - 1; i++) {
                            if (option2.cols[0][i]["fixed"] != null) {
                                option2.cols[0][i]["fixed"] = null;
                            }
                            else {
                                break;
@@ -359,15 +780,15 @@
                        //å»ç»å
                        if (data1.data[0].HFixCols != 0) {
                            for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
                                if ($.inArray(option2.cols[0][i + 1]["title"], titleData) != -1) {
                                    data1.data[0].HFixCols += 1;
                                }
                                option.cols[0][i + 1]["fixed"] = "left";
                                option2.cols[0][i + 1]["fixed"] = "left";
                            }
                        }
                        table.render(option);
                        table.render(option2);
                    } else {
                        table.render(option);
                        table.render(option2);
                    }
                }, error: function () {
                    layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
@@ -378,9 +799,9 @@
        // åææ¾ç¤ºä¸ææ¡
        function ColFilter() {
            var Organization = '<option  value="0" selected="selected" ></option>';
            for (var i = 1; i < option.cols[0].length; i++) {
                if (option.cols[0][i].hide != true) {
                    Organization += '<option  style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
            for (var i = 1; i < option2.cols[0].length; i++) {
                if (option2.cols[0][i].hide != true) {
                    Organization += '<option  style="color:blue;" value="' + option2.cols[0][i].field + '">' + option2.cols[0][i].field + '</option>';
                }
            }
            $("#ColName").empty();

			@@ -606,8 +606,8 @@
			<dd><a lay-href="è½¦é´ç®¡ç/ååè¿ç«/Cj_ProcessItemBGA.html">å·¥åºååè¿ä¿®å°</a></dd>
			<!--<dd><a lay-href="è½¦é´ç®¡ç/ååè¿ç«/Cj_ProcessItemBGA_PJGH.html">å·¥åºååè¿ä¿®å°(éä»¶æ´æ¢)</a></dd>-->
			<dd><a lay-href="è½¦é´ç®¡ç/ååè¿ç«/Sc_SourceLineRepairBillList.html">è¿ä¿®è®°å½åè¡¨</a></dd>
			<dd><a lay-href="è½¦é´ç®¡ç/ååè¿ç«/RetrospectiveQueryReport.html">åæ ¼è¿½æº¯æ¥è¯¢æ¥è¡¨</a></dd>
			<dd><a lay-href="è½¦é´ç®¡ç/ååè¿ç«/BadQueryReport.html">ä¸è¯è¿½æº¯æ¥è¯¢æ¥è¡¨</a></dd>
			<dd><a lay-href="è½¦é´ç®¡ç/ååè¿ç«/RetrospectiveQueryReport.html">è´¨éè¿½æº¯æ¥è¯¢</a></dd>
			<dd><a lay-href="è½¦é´ç®¡ç/ååè¿ç«/BadQueryReport.html">éåè¿½æº¯æ¥è¯¢æ¥è¡¨</a></dd>
			</dl>
			</dd>
			</dl>

			@@ -2,7 +2,7 @@
			<html>
			<head>
			<meta charset="utf-8" />
			<title>ä¸è¯è¿½æº¯æ¥è¯¢æ¥è¡¨</title>
			<title>éåè¿½æº¯æ¥è¯¢æ¥è¡¨</title>
			<link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
			<link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
			<script src="../../../layuiadmin/layui/layui.js"></script>
			@@ -26,21 +26,27 @@
			</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="HICMOBillNo" id="HICMOBillNo" value="">
			<input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber" value="">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 76px;">äº§åæ¡ç </label>
			<label class="layui-form-label">ç©æåç§°</label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="HBardCode" id="HBardCode" value="">
			<input type="text" class="layui-input" name="HMaterName" id="HMaterName" value="" style="background-color: #efefef4d;" readonly>
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">æµè½¬å¡å·</label>
			<label class="layui-form-label" style="width: 76px;">è§æ ¼åå·</label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="HProcExchBillNo" id="HProcExchBillNo" value="">
			<input type="text" class="layui-input" name="HMaterModel" id="HMaterModel" value="" style="background-color: #efefef4d;" readonly>
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">æ¹æ¬¡å·</label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="HBatchNo" id="HBatchNo">
			</div>
			</div>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
			@@ -81,10 +87,41 @@
			</div>
			</div>
			</div>
			<table class="" id="mainTable" lay-filter="mainTable"></table>
			<script type="text/html" id="toolbarDemo">
			<div class="layui-tab layui-tab-card">
			<ul class="layui-tab-title">
			<li class="layui-this">æµè½¬å¡æ¸å</li>
			<li>äº§åç ç»å®æ¸å</li>
			<li>åºå¥åºè®°å½</li>
			<!--<li>ç¸å³åºåæ¸å</li>-->
			</ul>
			<div class="layui-tab-content">
			<div class="layui-tab-item layui-show">
			<!--æµè½¬å¡æ¸å-->
			<table class="layui-hide" id="mainTable1" lay-filter="mainTable1"></table>
			</div>
			<div class="layui-tab-item">
			<!--äº§åç ç»å®æ¸å-->
			<table class="layui-hide" id="mainTable2" lay-filter="mainTable2"></table>
			</div>
			<div class="layui-tab-item">
			<!--åºå¥åºè®°å½-->
			<table class="layui-hide" id="mainTable3" lay-filter="mainTable3"></table>
			</div>
			<div class="layui-tab-item">
			<!--ç¸å³åºåæ¸å-->
			<table class="layui-hide" id="mainTable4" lay-filter="mainTable4"></table>
			</div>
			</div>
			</div>

			<script type="text/html" id="toolbarDemo1">
			<div class="layui-btn-container">
			<button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>åè®¾ç½®</button>
			</div>
			</script>
			<script type="text/html" id="toolbarDemo5">
			<div class="layui-btn-container">
			<button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn5"><i class="layui-icon layui-icon-form"></i>åè®¾ç½®</button>
			</div>
			</script>
			</form>
			@@ -112,8 +149,14 @@
			, laydate = layui.laydate
			, soulTable = layui.soulTable
			var sWhere = "";
			var option = [];
			var HModName = "BadQueryReport";
			var option1 = [];
			var option2 = [];
			var option3 = [];
			var option4 = [];
			var option5 = [];
			var option6 = [];
			var option7 = [];
			var HModName = "RetrospectiveQueryReport";
			var titleData = ["HInterID", "HEntryID", "HBadReasonID", "HSourceInterID", "HSourceEntryID"];//åè¡¨ä¸éè¦æ¾ç¤ºçåæ®µ å¯æ©å±

			//#endregion
			@@ -130,7 +173,7 @@
			//#region è§¦åäºä»¶ï¼åæ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç

			// å¤´å·¥å·æ äºä»¶
			table.on('toolbar(mainTable)', function (obj) {
			table.on('toolbar(mainTable1)', function (obj) {
			switch (obj.event) {
			//åè®¾ç½®
			case 'set_HideColumn': get_HideColumn();
			@@ -152,15 +195,15 @@
			//æ¥è¯¢
			get_FastQuery();
			}

			// æ¥è¯¢
			function get_Display(sWhere) {
			// æµè½¬å¡æ¸å
			function get_Display1(sWhere) {

			var ajaxLoad = layer.load();
			$.ajax({
			url: GetWEBURL() + '/Cj_SingleStation/BadQueryReport',
			url: GetWEBURL() + '/Cj_SingleStation/Sc_ProcessExchangeBillMainList',
			type: "GET",
			data: { "HBardCode": $("#HBardCode").val(), "HProcExchBillNo": $("#HProcExchBillNo").val(), "HICMOBillNo": $("#HICMOBillNo").val(), "sWhere": sWhere, "user": sessionStorage["HUserName"] },
			async: false,
			data: { "HMaterNumber": $("#HMaterNumber").val(), "HBatchNo": $("#HBatchNo").val(), "sWhere": sWhere, "user": sessionStorage["HUserName"] },
			success: function (data1) {
			if (data1.count == 1) {
			var data = [];
			@@ -189,9 +232,9 @@
			}

			//å¨ææ¾ç¤ºåå
			option = {
			elem: '#mainTable'
			, toolbar: '#toolbarDemo'
			option1 = {
			elem: '#mainTable1'
			, toolbar: '#toolbarDemo1'
			, cols: [col]
			, data: data1.data
			, height: 800
			@@ -204,7 +247,12 @@
			soulTable.render(this);
			}
			}
			table.render(option);
			table.render(option1);
			if ($("#HBardCode").val() != "" && data1.data.length != 0) {
			$("#HICMOBillNo").val(data1.data[0]["çäº§è®¢åå·"]);
			$("#HProcExchBillNo").val(data1.data[0]["æµè½¬å¡"]);
			}


			//å·æ°è¡¨æ ¼æ°æ®
			DisPlay_HideColumn();
			@@ -225,8 +273,203 @@
			});
			}

			// äº§åç ç»å®æ¸å
			function get_Display2(sWhere) {

			var ajaxLoad = layer.load();
			$.ajax({
			url: GetWEBURL() + '/Cj_SingleStation/HBardcodeList',
			type: "GET",
			async: false,
			data: { "HMaterNumber": $("#HMaterNumber").val(), "HBatchNo": $("#HBatchNo").val(), "sWhere": sWhere, "user": sessionStorage["HUserName"] },
			success: function (data1) {
			if (data1.count == 1) {
			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' });
			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 {
			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 HH:mm:ss')}}</div>", width: 180 });
			break;
			default:
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 150 });
			}
			}
			}

			//å¨ææ¾ç¤ºåå
			option2 = {
			elem: '#mainTable2'
			, toolbar: '#toolbarDemo1'
			, cols: [col]
			, data: data1.data
			, height: 800
			, page: true
			, totalRow: true
			, cellMinWidth: 90
			, limit: 50
			, limits: [50, 500, 5000, 20000]
			, done: function (res, curr, count) {
			soulTable.render(this);
			}
			}
			table.render(option2);
			if ($("#HBardCode").val() != "" && data1.data.length != 0) {
			$("#HICMOBillNo").val(data1.data[0]["çäº§è®¢åå·"]);
			$("#HProcExchBillNo").val(data1.data[0]["æµè½¬å¡"]);
			}


			//å·æ°è¡¨æ ¼æ°æ®
			DisPlay_HideColumn();

			if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
			ColFilter();
			}

			layer.close(ajaxLoad);
			} else {
			layer.close(ajaxLoad);
			layer.alert(data1.code + data1.Message, { icon: 5 });
			}
			}, error: function () {
			layer.close(ajaxLoad);
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}

			//åºå¥åºè®°å½
			function get_Display3(sWhere) {

			var ajaxLoad = layer.load();
			$.ajax({
			url: GetWEBURL() + '/Cj_SingleStation/BardCodeOutInList',
			type: "GET",
			async: false,
			data: { "HMaterNumber": $("#HMaterNumber").val(), "HBatchNo": $("#HBatchNo").val(), "sWhere": sWhere, "user": sessionStorage["HUserName"] },
			success: function (data1) {
			if (data1.count == 1) {
			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' });
			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 {
			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 HH:mm:ss')}}</div>", width: 180 });
			break;
			default:
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 150 });
			}
			}
			}

			//å¨ææ¾ç¤ºåå
			option3 = {
			elem: '#mainTable3'
			, toolbar: '#toolbarDemo3'
			, cols: [col]
			, data: data1.data
			, height: 800
			, page: true
			, totalRow: true
			, cellMinWidth: 90
			, limit: 50
			, limits: [50, 500, 5000, 20000]
			, done: function (res, curr, count) {
			soulTable.render(this);
			}
			}
			table.render(option3);
			layer.close(ajaxLoad);
			} else {
			layer.close(ajaxLoad);
			layer.alert(data1.code + data1.Message, { icon: 5 });
			}
			}, error: function () {
			layer.close(ajaxLoad);
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}

			//ç¸å³åºåæ¸å
			function get_Display4(sWhere) {
			var sWhere = " and HMaterSN='" + HBardcode + "'";

			var ajaxLoad = layer.load();
			$.ajax({
			url: GetWEBURL() + '/Cj_SingleStation/Sc_SourceLineRepairBillSub_MaterList',
			type: "GET",
			async: false,
			data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
			success: function (data1) {
			if (data1.count == 1) {
			//å¨ææ¾ç¤ºåå
			option4 = {
			elem: '#mainTable4'
			, toolbar: '#toolbarDemo4'
			, cols: [[
			{ type: 'checkbox', fixed: 'left' }
			, { type: 'numbers', title: 'åºå·' }
			, { field: 'HICMOBillNo', title: 'çäº§è®¢å' }
			, { field: 'HDate', title: 'æ¥æ' }
			, { field: 'HMaterNumber', title: 'éä»¶ç©æç¼ç ' }
			, { field: 'HMaterName', title: 'éä»¶ç©æåç§°' }
			, { field: 'HBarCode', title: 'éä»¶SNç ' }
			, { field: 'HMaterSN', title: 'äº§åSNç ' }

			]]
			, data: data1.data
			, height: 800
			, page: true
			, totalRow: true
			, cellMinWidth: 90
			, limit: 50
			, limits: [50, 500, 5000, 20000]
			, done: function (res, curr, count) {
			soulTable.render(this);
			}
			}
			table.render(option4);
			layer.close(ajaxLoad);
			} else {
			layer.close(ajaxLoad);
			layer.alert(data1.code + data1.Message, { icon: 5 });
			}
			}, error: function () {
			layer.close(ajaxLoad);
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}

			// å¿«éè¿æ»¤
			function get_FastQuery() {

			var ColName = $("#ColName").val();//å¤éæ¡
			var Comparator = $("#Comparator").val()
			var ColContent = $("#ColContent").val();
			@@ -253,7 +496,13 @@
			com = " and (" + ColName + " " + com + ")";
			}

			get_Display(sWhere);
			sWhere += com;

			get_Display1(sWhere);//æµè½¬å¡æ¸å
			get_Display2(sWhere);//äº§åç ç»å®æ¸å
			get_Display3(sWhere);//åºå¥åºè®°å½
			//get_Display4(HBardCode);//ç¸å³åºåæ¸å

			sWhere = "";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			}

			@@ -261,8 +510,8 @@
			function get_HideColumn() {
			var colName = "";
			var contentUrl = "";
			for (var i = 1; i < option.cols[0].length - 1; i++) {
			colName += option.cols[0][i]["title"] + ",";
			for (var i = 1; i < option1.cols[0].length - 1; i++) {
			colName += option1.cols[0][i]["title"] + ",";
			}
			var urlStr = window.document.location.pathname;//è·åæä»¶è·¯å¾
			var urlLen = urlStr.split('/');
			@@ -307,50 +556,50 @@

			dataCol = data1.data[0].HGridString.split(',');

			for (var i = 0; i < option.cols[0].length - 2; i++) {
			for (var i = 0; i < option1.cols[0].length - 2; i++) {
			var dataCols = dataCol[i].split('\|');
			//éèå
			if (dataCols[1] == 1) {
			option.cols[0][i + 1]["hide"] = true;
			option1.cols[0][i + 1]["hide"] = true;
			}
			//è®¾ç½®åå®½
			if (dataCols[3] > 0) {
			option.cols[0][i + 1]["width"] = dataCols[3];
			option1.cols[0][i + 1]["width"] = dataCols[3];
			}
			//è®¾ç½®åå®¹åä½å¤§å°
			if (data1.data[0].HFontSize != 0) {
			option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
			option1.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
			} else {
			option.cols[0][i + 1]["style"] = "font-size:100%";
			option1.cols[0][i + 1]["style"] = "font-size:100%";
			}
			//è®¾ç½®åå®½
			//if (data1.data[0].HColumnWidth != 0) {
			// option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
			// option1.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
			//} else {
			// option.cols[0][i + 1]["width"] = "";
			// option1.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;
			if (dataCols[1] == 0 && $.inArray(option1.cols[0][i + 1]["title"], titleData) == -1) {
			option1.cols[0][i + 1]["hide"] = false;
			}
			//åä½æå¨ä½ç½®(å·¦ å±ä¸ å³)
			switch (dataCols[2]) {
			case "L":
			option.cols[0][i + 1]["align"] = "left";
			option1.cols[0][i + 1]["align"] = "left";
			break;
			case "M":
			option.cols[0][i + 1]["align"] = "center";
			option1.cols[0][i + 1]["align"] = "center";
			break;
			case "R":
			option.cols[0][i + 1]["align"] = "right";
			option1.cols[0][i + 1]["align"] = "right";
			break;
			}
			}

			//åæ¶å»ç»å
			for (var i = 1; i < option.cols[0].length - 1; i++) {
			if (option.cols[0][i]["fixed"] != null) {
			option.cols[0][i]["fixed"] = null;
			for (var i = 1; i < option1.cols[0].length - 1; i++) {
			if (option1.cols[0][i]["fixed"] != null) {
			option1.cols[0][i]["fixed"] = null;
			}
			else {
			break;
			@@ -359,15 +608,15 @@
			//å»ç»å
			if (data1.data[0].HFixCols != 0) {
			for (var i = 0; i < data1.data[0].HFixCols; i++) {
			if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
			if ($.inArray(option1.cols[0][i + 1]["title"], titleData) != -1) {
			data1.data[0].HFixCols += 1;
			}
			option.cols[0][i + 1]["fixed"] = "left";
			option1.cols[0][i + 1]["fixed"] = "left";
			}
			}
			table.render(option);
			table.render(option1);
			} else {
			table.render(option);
			table.render(option1);
			}
			}, error: function () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			@@ -378,9 +627,9 @@
			// åææ¾ç¤ºä¸ææ¡
			function ColFilter() {
			var Organization = '<option value="0" selected="selected" ></option>';
			for (var i = 1; i < option.cols[0].length; i++) {
			if (option.cols[0][i].hide != true) {
			Organization += '<option style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
			for (var i = 1; i < option1.cols[0].length; i++) {
			if (option1.cols[0][i].hide != true) {
			Organization += '<option style="color:blue;" value="' + option1.cols[0][i].field + '">' + option1.cols[0][i].field + '</option>';
			}
			}
			$("#ColName").empty();