1
wtt
2025-12-29 3425237a2b54ca28fc3e3c5f7c35a7fbef4e15fa
WebTM/views/ÏîÄ¿¹ÜÀí/¹¤³ÌÏîÄ¿/PM_ProjectEndBillMainList.html
@@ -86,6 +86,60 @@
                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent">
                                        </div>
                                    </div>
                                    <div class="layui-row" style="margin-top:5px">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
                                                <select name="ColName1" id="ColName1" lay-filter="ColName1" style="width:190px;">
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <select name="Comparator1" id="Comparator1" lay-filter="Comparator1" style="width:190px;">
                                                <option value="0" selected="selected"></option>
                                                <option value="=">=</option>
                                                <option value=">=">>=</option>
                                                <option value=">">></option>
                                                <option value="<="><=</option>
                                                <option value="<"><</option>
                                                <option value="<>"><></option>
                                                <option value="7">包含</option>
                                                <option value="8">左包含</option>
                                                <option value="9">右包含</option>
                                                <option value="10">不包含</option>
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input" value="" name="ColContent1" id="ColContent1">
                                        </div>
                                    </div>
                                    <div class="layui-row" style="margin-top:5px">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
                                                <select name="ColName2" id="ColName2" lay-filter="ColName2" style="width:190px;">
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <select name="Comparator2" id="Comparator2" lay-filter="Comparator2" style="width:190px;">
                                                <option value="0" selected="selected"></option>
                                                <option value="=">=</option>
                                                <option value=">=">>=</option>
                                                <option value=">">></option>
                                                <option value="<="><=</option>
                                                <option value="<"><</option>
                                                <option value="<>"><></option>
                                                <option value="7">包含</option>
                                                <option value="8">左包含</option>
                                                <option value="9">右包含</option>
                                                <option value="10">不包含</option>
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input" value="" name="ColContent2" id="ColContent2">
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
@@ -272,6 +326,33 @@
            });
            //#endregion
            form.on('tool(maintable)', function (obj) {
                var data = obj.data;
                if (obj.event == '单据号') {
                    var a = data[i].hmainid.toString();
                    layer.open({
                        Type: 2,
                        area:['80%','80%'],
                        title: '编辑' + HPageTitle,
                        closeBtn: 1,
                        maxmin: true,
                        shade: 0.6,
                        anim: 0,
                        content: '../../项目管理/工程项目/PM_ProjectEndBillMain.html?OperationType=3&linterid=' + linterid + '&HSouceBillType=',
                        resize: false,
                        end: function () {
                                get_FastQuery(table, option);
                            }
                        , cancel: function () {
                        }
                    })
                }
            })
            //#endregion
            //#region æœ¬é¡µé¢æ‰€æœ‰è¢«è°ƒç”¨çš„æ–¹æ³•
@@ -304,7 +385,7 @@
                    , totalRow: true
                    //, cellMinWidth: 90
                    , limit: 50
                    , limits: [50, 500, 5000, 50000]
                    , limits: [50, 500, 5000, 20000]
                    , done: function (res, curr, count) {
                        soulTable.render(this);
                    }
@@ -326,6 +407,8 @@
                        if (data1.count == 1) {
                            var data = [];
                            var col = [];
                            var tolalArray=[];
                            //给空的数组赋值
                            for (var key in data1.list) {
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
@@ -335,6 +418,11 @@
                            for (var i = 0; i < data.length; i++) {
                                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, tolalArray)>-1) {
                                    col.push({ filed: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 150 });
                                } else if (data[i].name == '单据号') {
                                    col.push({ filed: data[i].id, title: data[i].name ,align: 'center', sort: true, width: 150, event:'单据号' })
                                }
                               
                                else {
@@ -353,6 +441,23 @@
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                    }
                                }
                            }
                            option = {
                                elem: '#mainTable'                    // ä½¿ç”¨#mainTable作为表格的DOM元素
                                , toolbar: '#toolbarDemo'                //加载tolbardemo这个表格
                                , cols: [col]                            // é¡µé¢æ˜¾ç¤º
                                , data: data1.data                        //  è¡¨æ ¼æ•°æ®
                                , height: 800                           //表格高度为800
                                , page: true                            // å¼€å¯åˆ†é¡µ
                                , totalRow: true                               // æ˜¯å¦æ˜¾ç¤ºåˆè®¡è¡Œ
                                , cellMinWidth: 90                      // å•元格最小宽度
                                , limit: 50                               // é»˜è®¤æ¯é¡µæ˜¾ç¤ºçš„æ¡æ•°
                                , limits: [50, 500, 5000, 20000]               // å¯é€‰çš„æ¯é¡µæ˜¾ç¤ºæ¡æ•°
                                //res从服务器返回的数据  curr当前页码显示当前页码数据  count:这通常表示数据的总条数 åˆ†é¡µæŽ§ä»¶
                                , done: function (res, curr, count) {       // å›žè°ƒè°ƒç”¨æ˜¾ç¤ºå½“前页码数据和数据总条数
                                    soulTable.render(this);              // å¦‚æžœsoulTable.render是用于重新渲染表格的   é‡æ–°æ¸²æŸ“表格
                                }
                            }
                            option.cols = [col];
@@ -393,6 +498,13 @@
                var Comparator = $("#Comparator").val()
                var ColContent = $("#ColContent").val();
                var ColName1 = $("#ColName1").val();//复选框
                var Comparator1 = $("#Comparator1").val()
                var ColContent1 = $("#ColContent1").val();
                var ColName2 = $("#ColName2").val();//复选框
                var Comparator2 = $("#Comparator2").val()
                var ColContent2 = $("#ColContent2").val();
                if (ColName != 0 && Comparator != 0) {
                    var com = "";
                    switch (Comparator) {
@@ -413,6 +525,48 @@
                            break;
                    }
                    sWhere += " and " + ColName + " " + com;
                }
                if (ColName1 != 0 && Comparator1 != 0) {
                    var com1 = "";
                    switch (Comparator1) {
                        case "7":
                            com1 = "like'%" + ColContent1 + "%'";
                            break;
                        case "8":
                            com1 = "like'%" + ColContent1 + "'";
                            break;
                        case "9":
                            com1 = "like'" + ColContent1 + "%'";
                            break;
                        case "10":
                            com1 = "not like'%" + ColContent1 + "%'";
                            break;
                        default:
                            com1 = "" + Comparator1 + "'" + ColContent1 + "'";
                            break;
                    }
                    sWhere += " and " + ColName1 + " " + com1;
                }
                if (ColName2 != 0 && Comparator2 != 0) {
                    var com2 = "";
                    switch (Comparator2) {
                        case "7":
                            com2 = "like'%" + ColContent2 + "%'";
                            break;
                        case "8":
                            com2 = "like'%" + ColContent2 + "'";
                            break;
                        case "9":
                            com2 = "like'" + ColContent2 + "%'";
                            break;
                        case "10":
                            com2 = "not like'%" + ColContent2 + "%'";
                            break;
                        default:
                            com2 = "" + Comparator + "'" + ColContent + "'";
                            break;
                    }
                    sWhere += " and " + ColName2 + " " + com2;
                }
                
                if (HBillNo) {
@@ -437,7 +591,12 @@
                $("#HName").val("");
                $("#HReceiveEmp").val("");
                $("#HBillStatus").val("");
                $("#ColContent2").val("");
                $("#ColName2").val("0");
                $("#Comparator2").val("0");
                $("#ColContent1").val("");
                $("#ColName1").val("0");
                $("#Comparator1").val("0");
                $("#ColContent").val("");
                $("#ColName").val("0");
                $("#Comparator").val("0");
@@ -748,8 +907,7 @@
                        if (data1.data.length != 0) {
                            var dataCol = [];//数据库查询出的列数据
                            //var titleData = ["单据ID", "HMouldID", "hsubid", "HManagerID", "源单主内码", "源单子内码"];//不需要显示的字段 å¯æ‰©å±•
                            //var titleData = ["单据ID", "HMouldID", "hsubid", "HManagerID", "源单主内码", "源单子内码"];//不需要显示的字段 å¯æ‰©å±•   var titleData = ["HInterID", "HBillStatus", "HProjectID", "HPMTeamID", "HPMEmpID", "HWorkEmpID", "HCusID", "HManagerID", "HOrgID", "HEntryID","HTestEmp"];
                            dataCol = data1.data[0].HGridString.split(',');
                            for (var i = 0; i < option.cols[0].length - 1; i++) {
@@ -820,8 +978,7 @@
                })
            }
            //#endregion
            //#region ä»»æ„å­—段过滤:列名显示下拉框
            //#region åˆ—明显示下拉框
            function ColFilter() {
                var Organization = '<option  value="0" selected="selected" ></option>';
                for (var i = 1; i < option.cols[0].length; i++) {
@@ -831,6 +988,10 @@
                }
                $("#ColName").empty();
                $("#ColName").append(Organization);
                $("#ColName1").empty();
                $("#ColName1").append(Organization);
                $("#ColName2").empty();
                $("#ColName2").append(Organization);
                form.render('select');
            }
            //#endregion