乔一报表调整

duhe

2024-08-20 ba7e9cfba610160cf14c0ac753699d00b62d4dcb

乔一报表调整

 WebTM/views/Ó¦ÊÕ¹ÜÀí/±¨±í·ÖÎö/Xs_SeOrderBarCodeInAndOutStockDetailReport.html

@@ -35,9 +35,19 @@
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;">销售订单号</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                    <div class="layui-input-block" style="margin-left: 120px;width:130px;">
                                        <input type="text" class="layui-input ForFilteringSchemes" name="HSeOrderBillNo" id="HSeOrderBillNo">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;">是否出库</label>
                                </div>
                                <div class="layui-inline">
                                    <select name="HIsOutStock" id="HIsOutStock" class="ForFilteringSchemes" lay-filter="HIsOutStock">
                                        <option value="" selected="selected" style="width:10px;"></option>
                                        <option value="是" style="width:10px;">是</option>
                                        <option value="否" style="width:10px;">否</option>
                                    </select>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
@@ -45,25 +55,25 @@
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>
                                <div class="layui-inline">
                                    <label class="layui-form-label">入库件数</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                    <div class="layui-input-block" style="margin-left: 120px;width:60px;">
                                        <input type="text" class="layui-input" name="SumHPieceQty_inStock" id="SumHPieceQty_inStock" disabled="disabled">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">入库米数合计</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                    <label class="layui-form-label">入库米数</label>
                                    <div class="layui-input-block" style="margin-left: 120px; width: 100px;">
                                        <input type="text" class="layui-input" name="SumHQty_inStock" id="SumHQty_inStock" disabled="disabled">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">出库件数</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                    <div class="layui-input-block" style="margin-left: 120px; width: 60px;">
                                        <input type="text" class="layui-input" name="SumHPieceQty_outStock" id="SumHPieceQty_outStock" disabled="disabled">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">出库米数合计</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                    <label class="layui-form-label">出库米数</label>
                                    <div class="layui-input-block" style="margin-left: 120px; width: 100px;">
                                        <input type="text" class="layui-input" name="SumHQty_outStock" id="SumHQty_outStock" disabled="disabled">
                                    </div>
                                </div>
@@ -372,7 +382,7 @@
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true });
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>" });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true });
@@ -420,9 +430,14 @@
            //快速过滤
            function get_FastQuery() {
                var HSeOrderBillNo = $("#HSeOrderBillNo").val();          //销售订单单据号
                var HIsOutStock = $("#HIsOutStock").val();          //是否出库

                if (HSeOrderBillNo != "") {
                    sWhere += " and é”€å”®è®¢å•å·='" + HSeOrderBillNo + "' ";
                    sWhere += " and é”€å”®è®¢å•å· like '%" + HSeOrderBillNo + "%' ";
                }

                if (HIsOutStock != "") {
                    sWhere += " and æ˜¯å¦å‡ºåº“ like '%" + HIsOutStock + "%' ";
                }

                //任意字段条件过滤 æ¡ä»¶æå–