| | |
| | | <!--动态渲染车间--> |
| | | </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"> |
| | |
| | | <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> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <div class="layui-inline" id="ICMOFilter_SPickMtrlStatus"> |
| | | <label class="layui-form-label">领料状态</label> |
| | | <div class="layui-input-block"> |
| | | <select name="HPickMtrlStatus" id="HSPickMtrlStatus" lay-verify="" lay-search class="layui-input ForFilteringSchemes"> |
| | |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">过滤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName" id="ColName" lay-filter="ColName" class="ForFilteringSchemes" style="width:190px;"> |
| | | </select> |
| | | <div class="layui-row" style="margin-top:5px;margin-left:40px;"> |
| | | <div class="layui-inline" id="ICMOFilter_IsScheduling"> |
| | | <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="" selected>请选择</option> |
| | | <option value="已排产">已排产</option> |
| | | <option value="未排产">未排产</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator" id="Comparator" lay-filter="Comparator" class="ForFilteringSchemes" 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 ForFilteringSchemes" value="" name="ColContent" id="ColContent"> |
| | | <div class="layui-row" style="margin-top:5px;margin-left:40px;"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">过滤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName" id="ColName" lay-filter="ColName" class="ForFilteringSchemes" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator" id="Comparator" lay-filter="Comparator" class="ForFilteringSchemes" 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 ForFilteringSchemes" value="" name="ColContent" id="ColContent"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <table class="" id="layTable" lay-filter="layTable"></table> |
| | |
| | | <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> |
| | |
| | | |
| | | //#endregion |
| | | |
| | | //隐藏过滤字段 |
| | | if (HSouceBillType != "生产订单") { |
| | | document.getElementById("ICMOFilter_SPickMtrlStatus").style.display = "none"; |
| | | document.getElementById("ICMOFilter_IsScheduling").style.display = "none"; |
| | | document.getElementById("ICMOFilter_SPickMtrlStatus").style.visibility = 'hidden'; |
| | | document.getElementById("ICMOFilter_IsScheduling").style.visibility = 'hidden'; |
| | | } |
| | | |
| | | //#region 进入页面即加载 |
| | | //初始化表单插件 |
| | | //set_InitFrom(); |
| | |
| | | } |
| | | else if (OperationType == 3) {//有源单 |
| | | //get_FastQuery(HSouceBillType); |
| | | set_ClearBill(sWhere, HSouceBillType); |
| | | //查询当前登录用户有没有在当前模块设置默认过滤方案 |
| | | get_DefaultModule(); |
| | | set_ClearBill(sWhere, HSouceBillType); |
| | | } |
| | | else { |
| | | layer.alert("未知操作类型!", { icon: 5 }); |
| | | } |
| | | |
| | | |
| | | //#endregion |
| | | |
| | | //#region 触发事件:包括form.on(){}格式的所有点击事件、选择事件等 |
| | |
| | | $("#HProcExchBillNoHidden").show(); |
| | | HModName = "ProductInBill_1202"; |
| | | break; |
| | | case '采购入库': |
| | | case '采购入库单': |
| | | HModName = "POStockInBill_1201"; |
| | | break; |
| | | case '销售退货': |
| | |
| | | break; |
| | | case '工序流转卡': |
| | | HModName = "ProcessExchangeBill_3772"; |
| | | break; |
| | | case '销售出库单': |
| | | HModName = "SellOutBill_1205"; |
| | | break; |
| | | case '领料出库单': |
| | | HModName = "MateOutBill_1204"; |
| | | break; |
| | | } |
| | | //初始查询 |
| | |
| | | , page: true //开启分页 |
| | | , totalRow: false //开启合计 |
| | | , cellMinWidth: 120 |
| | | , height: 520 |
| | | , limit: 50 //一页能够显示的最大数目 |
| | | , height: 'full-50' |
| | | , limit: 500 //一页能够显示的最大数目 |
| | | , limits: [50, 500, 5000, 20000] |
| | | , method: 'get' //提交方式 |
| | | , layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'] |
| | |
| | | if ($("#HBillStatus").val() != "") { |
| | | sWhere += " and 状态 = '" + $("#HBillStatus").val() + "'"; |
| | | } |
| | | if ($("#HSPickMtrlStatus").val() != "") { |
| | | sWhere += " and 领料状态 = '" + $("#HSPickMtrlStatus").val() + "'"; |
| | | //判断客户 |
| | | if (sessionStorage["Organization"] == "九菱电机") { |
| | | if ($("#HSPickMtrlStatus").val() != "") { |
| | | sWhere += " and 领料状态 = '" + $("#HSPickMtrlStatus").val() + "'"; |
| | | } |
| | | if ($("#HIsScheduling").val() != "") { |
| | | sWhere += $("#HIsScheduling").val() == "未排产" ? "and 是否排产 = ''" : " and 是否排产 = '" + $("#HIsScheduling").val() + "'"; |
| | | } |
| | | } |
| | | |
| | | return sWhere; |
| | | break; |
| | | case '生产汇报单': |
| | |
| | | if (HDeptName && HDeptName != 0) { |
| | | sWhere += " and HDeptID = '" + HDeptName + "'"; |
| | | } |
| | | if (HProcExchBillNo!="") { |
| | | if (HProcExchBillNo != "") { |
| | | sWhere += " and 流转卡号 like '" + HProcExchBillNo + "%'"; |
| | | } |
| | | 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; |
| | | 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; |
| | | case "领料出库单": |
| | | if (HBillNo) { |
| | | sWhere += " and 单据号 like '%" + HBillNo + "%'"; |
| | | } |
| | |
| | | |
| | | |
| | | //执行查询方法 |
| | | get_FastQuery(HSouceBillType); |
| | | //get_FastQuery(HSouceBillType); |
| | | set_ClearBill(sWhere, HSouceBillType); |
| | | form.render("select"); |
| | | } else { |
| | | //当前用户没有设置默认的过滤方案 |
| | |
| | | document.getElementById("HFilterScheme_Now").style.display = "none"; |
| | | //执行查询方法 |
| | | get_FastQuery(HSouceBillType); |
| | | set_ClearBill(sWhere, HSouceBillType); |
| | | form.render("select"); |
| | | } |
| | | }, error: function () { |
| | |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | //#endregion |
| | | |
| | | </script> |
| | | |