chenhaozhe
8 天以前 cfa35ff1f39c2a7b69d624d45f8e05591f3375d4
WebTM/views/PublicPage/HSourceReportHtml.html
@@ -42,13 +42,7 @@
                                            <!--动态渲染车间-->
                                        </select>
                                    </div>
                                </div>
                                <!--<div class="layui-inline">
                                    <label class="layui-form-label">部门</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HDeptName" id="HDeptName" style="width:190px;">
                                    </div>
                                </div>-->
                                </div>
                                <div class="layui-inline" id="HProcExchBillNoHidden" style="display:none;">
                                    <label class="layui-form-label">流转卡号</label>
                                    <div class="layui-input-block">
@@ -84,11 +78,11 @@
                                            <label class="layui-form-label">状态</label>
                                            <div class="layui-input-block">
                                                <select name="HBillStatus" id="HBillStatus" lay-verify="" lay-search class="layui-input ForFilteringSchemes">
                                                    <option value="">请选择</option>
                                                    <option value="" selected>请选择</option>
                                                    <option value="计划">计划</option>
                                                    <option value="计划确认">计划确认</option>
                                                    <option value="下达">下达</option>
                                                    <option value="开工" selected>开工</option>
                                                    <option value="开工" >开工</option>
                                                    <option value="完工">完工</option>
                                                    <option value="结案">结案</option>
                                                    <option value="结算">结算</option>
@@ -112,8 +106,8 @@
                                                <label class="layui-form-label">是否排产</label>
                                                <div class="layui-input-block">
                                                    <select name="HIsScheduling" id="HIsScheduling" lay-verify="" lay-search class="layui-input ForFilteringSchemes">
                                                        <option value="">请选择</option>
                                                        <option value="已排产" selected>已排产</option>
                                                        <option value="" selected>请选择</option>
                                                        <option value="已排产">已排产</option>
                                                        <option value="未排产">未排产</option>
                                                    </select>
                                                </div>
@@ -156,15 +150,6 @@
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="set_SaveScheme" id="set_SaveScheme"><i class="layui-icon layui-icon-template"></i>保存方案</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="set_ReadScheme" id="set_ReadScheme"><i class="layui-icon layui-icon-set"></i>读取方案</button>
                                <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="set_AddNew"><i class="layui-icon layui-icon-add-1"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-edit"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload" style="display:none;"><i class="layui-icon layui-icon-refresh"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-confirm" id="btn_confirm" style="display:none;"><i class="layui-icon layui-icon-ok-circle"></i>确认</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back" id="btn_back" style="display:none;"><i class="layui-icon layui-icon-close-fill"></i>驳回</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details" style="display:none;"><i class="layui-icon layui-icon-form"></i>详情</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate" style="display:none;"><i class="layui-icon layui-icon-file"></i>生成送货单</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit" style="display:none;"><i class="layui-icon layui-icon-return"></i>退出</button>-->
                            </div>
                        </script>
@@ -380,7 +365,7 @@
                        $("#HProcExchBillNoHidden").show();
                        HModName = "ProductInBill_1202";
                        break;
                    case '采购入库':
                    case '采购入库单':
                        HModName = "POStockInBill_1201";
                        break;
                    case '销售退货':
@@ -391,6 +376,12 @@
                        break;
                    case '工序流转卡':
                        HModName = "ProcessExchangeBill_3772";
                        break;
                    case '销售出库单':
                        HModName = "SellOutBill_1205";
                        break;
                    case '领料出库单':
                        HModName = "MateOutBill_1204";
                        break;
                }
                //初始查询
@@ -619,6 +610,21 @@
                        }
                        return sWhere;
                        break;
                    case "采购入库单":
                        if (HBillNo) {
                            sWhere += " and 单据号 like '%" + HBillNo + "%'";
                        }
                        if (PartNumber) {
                            sWhere += " and 物料代码 like '%" + PartNumber + "%'";
                        }
                        if (PartName) {
                            sWhere += " and 物料名称 like '%" + PartName + "%'";
                        }
                        if (HDeptName && HDeptName != 0) {
                            sWhere += " and HDeptID = '" + HDeptName + "'";
                        }
                        return sWhere;
                        break;
                    case '退货通知单':
                        return sWhere;
                        break;
@@ -651,6 +657,36 @@
                        }
                        return sWhere;
                        break;
                    case "销售出库单":
                        if (HBillNo) {
                            sWhere += " and 单据号 like '%" + HBillNo + "%'";
                        }
                        if (PartNumber) {
                            sWhere += " and 物料代码 like '%" + PartNumber + "%'";
                        }
                        if (PartName) {
                            sWhere += " and 物料名称 like '%" + PartName + "%'";
                        }
                        if (HDeptName && HDeptName != 0) {
                            sWhere += " and HDeptID = '" + HDeptName + "'";
                        }
                        return sWhere;
                        break;
                    case "领料出库单":
                        if (HBillNo) {
                            sWhere += " and 单据号 like '%" + HBillNo + "%'";
                        }
                        if (PartNumber) {
                            sWhere += " and 物料代码 like '%" + PartNumber + "%'";
                        }
                        if (PartName) {
                            sWhere += " and 物料名称 like '%" + PartName + "%'";
                        }
                        if (HDeptName && HDeptName != 0) {
                            sWhere += " and HDeptID = '" + HDeptName + "'";
                        }
                        return sWhere;
                        break;
                }
            }