| | |
| | | <span>更多</span> |
| | | </div> |
| | | </div> |
| | | |
| | | |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">单据号</label> |
| | | <div class="layui-input-block"> |
| | | <label class="layui-form-label">订单单号</label> |
| | | <div class="layui-input-block" style="width:130px;"> |
| | | <input type="text" class="layui-input" name="HBillNo" id="HBillNo"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">物料编码</label> |
| | | <div class="layui-input-block"> |
| | | <div class="layui-input-block" style="width:130px;"> |
| | | <input type="text" class="layui-input" name="HShortNumber" id="HShortNumber"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <div class="layui-inline" style="display:none"> |
| | | <label class="layui-form-label">旧物料编码</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HOldMaterNumber" id="HOldMaterNumber"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <div class="layui-inline" style="display:none"> |
| | | <label class="layui-form-label">物料代码</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HNumber" id="HNumber"> |
| | |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">物料名称</label> |
| | | <div class="layui-input-block"> |
| | | <div class="layui-input-block" style="width:130px;"> |
| | | <input type="text" class="layui-input" name="HName" id="HName"> |
| | | </div> |
| | | </div> |
| | | |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">开始日期</label> |
| | | <div class="layui-input-block" style="width:100px;"> |
| | | <input type="text" class="layui-input" name="HDate1" id="HDate1"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">结束日期</label> |
| | | <div class="layui-input-block" style="width:100px;"> |
| | | <input type="text" class="layui-input" name="HDate2" id="HDate2"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">状态</label> |
| | | <div class="layui-input-block" style="width:120px"> |
| | | <select name="HStatus" id="HStatus" lay-filter=""> |
| | | <option value="" selected="">全部</option> |
| | | <option value="未确认">未确认</option> |
| | | <option value="已确认">已确认</option> |
| | | <option value="已驳回">已驳回</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">关闭状态</label> |
| | | <div class="layui-input-block" style="width:120px"> |
| | | <select id="HClStatus" name="HClStatus" lay-filter=""> |
| | | <option value="" selected>全部</option> |
| | | <option value="未关闭">未关闭</option> |
| | | <option value="已关闭">已关闭</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <!--瑞琪,凯贝--> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">业务状态</label> |
| | | <div class="layui-input-block" style="width:120px"> |
| | | <select id="HIsClose" name="HIsClose" lay-filter=""> |
| | | <option value="全部" selected>全部</option> |
| | | <option value="正常">正常</option> |
| | | <option value="业务关闭">业务关闭</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">冻结状态</label> |
| | | <div class="layui-input-block" style="width:120px"> |
| | | <select id="HIsFreeze" name="HIsFreeze" lay-filter=""> |
| | | <option value="全部" selected>全部</option> |
| | | <option value="正常">正常</option> |
| | | <option value="业务冻结">业务冻结</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">完成状态</label> |
| | | <div class="layui-input-block" style="width:120px"> |
| | | <select name="HFinishStatus" id="HFinishStatus" lay-filter=""> |
| | | <option value="">全部</option> |
| | | <option value="未完成" selected="">未完成</option> |
| | | <option value="已完成">已完成</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | |
| | | <label class="layui-form-label">规格型号</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HModel" id="HModel"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">关闭状态</label> |
| | | <div class="layui-input-block"> |
| | | <select id="HClStatus" name="HClStatus" lay-filter=""> |
| | | <option value="" selected>全部</option> |
| | | <option value="未关闭">未关闭</option> |
| | | <option value="已关闭">已关闭</option> |
| | | </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="HDate1" id="HDate1"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">结束日期</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HDate2" id="HDate2"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">订单状态</label> |
| | | <div class="layui-input-block"> |
| | | <select name="HStatus" id="HStatus" lay-filter=""> |
| | | <option value="" selected="">全部</option> |
| | | <option value="未确认">未确认</option> |
| | | <option value="已确认">已确认</option> |
| | | <option value="已驳回">已驳回</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">完成状态</label> |
| | | <div class="layui-input-block"> |
| | | <select name="HFinishStatus" id="HFinishStatus" lay-filter=""> |
| | | <option value="">全部</option> |
| | | <option value="未完成" selected="">未完成</option> |
| | | <option value="已完成">已完成</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <!--瑞琪--> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">业务关闭</label> |
| | | <div class="layui-input-block"> |
| | | <select id="HIsClose" name="HIsClose" lay-filter=""> |
| | | <option value="全部" selected>全部</option> |
| | | <option value="是">是</option> |
| | | <option value="否">否</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | |
| | | <table class="layui-hide" id="mainTable" lay-filter="mainTable"></table> |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container"> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | | <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>预览</button>--> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>刷新</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" id="btn_reload" lay-submit="" lay-event="btn-reload"><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"><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"><i class="layui-icon layui-icon-close-fill"></i>驳回</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-report" id="btn_report"><i class="layui-icon layui-icon-close-fill"></i>汇报</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>详情</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-barcode"><i class="layui-icon layui-icon-file"></i>生成条码</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>生成送货单</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>隐藏列设置</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_dao"><i class="layui-icon layui-icon-form"></i>导出</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" id="btn_details" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>详情</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" id="btn_barcode" lay-event="btn-barcode"><i class="layui-icon layui-icon-file"></i>生成条码</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" id="btn_generate" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>生成送货单</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" id="btn_backData" lay-event="btn_backData"><i class="layui-icon layui-icon-add-1"></i>返回数据</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" id="btn_exit" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" id="btn_HideColumn" lay-event="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>隐藏列设置</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" id="set_dao" lay-event="set_dao"><i class="layui-icon layui-icon-form"></i>导出</button> |
| | | </div> |
| | | </script> |
| | | </div> |
| | |
| | | </div> |
| | | </div> |
| | | <script src="../../layuiadmin/layui/layui.js" charset="utf-8"></script> |
| | | <script src="../../layuiadmin/Scripts/json2.js" type="text/javascript"></script> |
| | | <script src="../../layuiadmin/Scripts/jquery-1.4.1.js" type="text/javascript"></script> |
| | | <script src="../../../../Scripts/webConfig.js"></script> |
| | | <script> |
| | | var _cur_page = 1; |
| | |
| | | } |
| | | var params = getUrlVars(); |
| | | var type = params[params[0]]; |
| | | switch (type) { |
| | | case "UnConfirm": |
| | | options[1].selected = true; |
| | | sql += " and 状态 like ^^%未确认%^^"; |
| | | //$("#HStatus").attr("disabled", true) |
| | | break; |
| | | case "ReConfirm": |
| | | options[2].selected = true; |
| | | sql += " and 状态 like ^^%已确认%^^"; |
| | | sql += " and 未关联数量 > 0"; |
| | | break; |
| | | case "ReBack": |
| | | options[3].selected = true; |
| | | sql += " and 状态 like ^^%已驳回%^^"; |
| | | break; |
| | | } |
| | | |
| | | layui.config({ |
| | | base: '../../layuiadmin/' //静态资源所在路径 |
| | | }).extend({ |
| | |
| | | laydate.render({ |
| | | elem: '#HDate2' |
| | | }); |
| | | |
| | | //不需要显示的字段 可扩展 |
| | | var titleData = ["HItemID", "HParentID"]; |
| | | var titleData = ["HItemID", "HParentID", "单据号", "日期", "数量", "状态", "单位", "金额"]; |
| | | var option = []; |
| | | var HModName = "SRM_POOrderBillList"; |
| | | var sqlWhere = ""; |
| | | //#region 进入页面既加载 |
| | | switch (type) { |
| | | case "UnConfirm": |
| | | options[1].selected = true; |
| | | sql += " and 状态 like ^^%未确认%^^"; |
| | | //$("#HStatus").attr("disabled", true) |
| | | break; |
| | | case "ReConfirm": |
| | | options[2].selected = true; |
| | | sql += " and 状态 like ^^%已确认%^^"; |
| | | sql += " and 未关联数量 > 0"; |
| | | break; |
| | | case "ReBack": |
| | | options[3].selected = true; |
| | | sql += " and 状态 like ^^%已驳回%^^"; |
| | | break; |
| | | //case "AddRow": |
| | | // $("#HStatus").attr("disabled", "disabled"); |
| | | // $("#HStatus").val('已确认'); |
| | | // $("#HFinishStatus").attr("disabled", "disabled"); |
| | | // form.render('select'); |
| | | // sqlWhere += " and 状态 like ^^%已确认%^^"; |
| | | // sqlWhere += " and 完成状态 like ^^%" + $("#HFinishStatus").val() + "%^^"; |
| | | // $('#btn_reload').addClass("layui-btn-disabled").attr("visibility", "hidden"); |
| | | // $('#btn_confirm').addClass("layui-btn-disabled").attr("disabled", true); |
| | | // $('#btn_back').addClass("layui-btn-disabled").attr("disabled", true); |
| | | // $('#btn_report').addClass("layui-btn-disabled").attr("disabled", true); |
| | | // $('#btn_details').addClass("layui-btn-disabled").attr("disabled", true); |
| | | // $('#btn_barcode').addClass("layui-btn-disabled").attr("disabled", true); |
| | | // $('#btn_generate').addClass("layui-btn-disabled").attr("disabled", true); |
| | | // $('#set_dao').addClass("layui-btn-disabled").attr("disabled", true); |
| | | // break; |
| | | } |
| | | |
| | | set_ClearBill(); |
| | | //#region 此页面所有方法 |
| | | function set_ClearBill() { |
| | |
| | | //隐藏id |
| | | //设置列宽 |
| | | if (dataCols[3] > 0) { |
| | | if (option.cols[0][i + 1]["field"] == '回复交期') { |
| | | if (option.cols[0][i + 1]["field"] == '供应商交期回复') { |
| | | option.cols[0][i + 1]["width"] = 120; |
| | | } else { |
| | | option.cols[0][i + 1]["width"] = dataCols[3]; |
| | |
| | | default: |
| | | if (data[i].name == '订单数量' || data[i].name == '已发货数量' || data[i].name == '未发货数量') { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, totalRow: true }); |
| | | } else if (data[i].name == '回复交期') { |
| | | } else if (data[i].name == '供应商交期回复') { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: 'HSupSendGoodsDateRemark' }); |
| | | } else { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 }); |
| | |
| | | if ($("#HPURCHASEORGID").val() != "" && $("#HPURCHASEORGID option:selected").text() != "安瑞集团") |
| | | sqlWhere += " and HPURCHASEORGID = ^^" + $("#HPURCHASEORGID").val() + "^^"; |
| | | if ($("#HDate1").val() != "") { |
| | | sqlWhere += " and 日期 >= ^^" + $("#HDate1").val() + "^^"; |
| | | sqlWhere += " and 采购日期 >= ^^" + $("#HDate1").val() + "^^"; |
| | | } |
| | | if ($("#HDate2").val() != "") { |
| | | sqlWhere += " and 日期 <= ^^" + $("#HDate2").val() + "^^"; |
| | | sqlWhere += " and 采购日期 <= ^^" + $("#HDate2").val() + "^^"; |
| | | } |
| | | if ($("#HISGenerate").val() != "") { |
| | | if ($("#HISGenerate").val() == "是") { |
| | |
| | | } |
| | | /*瑞琪*/ |
| | | if ($("#HIsClose").val() != "") { |
| | | if ($("#HIsClose").val() == "是") { |
| | | sqlWhere += " and 业务关闭 = ^^已关闭^^"; |
| | | if ($("#HIsClose").val() == "正常") { |
| | | sqlWhere += " and 业务关闭 = ^^正常^^"; |
| | | } |
| | | else if ($("#HIsClose").val() == "否") { |
| | | sqlWhere += " and 业务关闭 = ^^未关闭^^"; |
| | | else if ($("#HIsClose").val() == "业务关闭") { |
| | | sqlWhere += " and 业务关闭 = ^^业务关闭^^"; |
| | | } |
| | | } |
| | | if ($("#HIsFreeze").val() != "") { |
| | | if ($("#HIsFreeze").val() == "正常") { |
| | | sqlWhere += " and 业务冻结 = ^^正常^^"; |
| | | } |
| | | else if ($("#HIsFreeze").val() == "业务冻结") { |
| | | sqlWhere += " and 业务冻结 = ^^业务冻结^^"; |
| | | } |
| | | } |
| | | var Time = $("#Time").val(); |
| | |
| | | layer.prompt({ |
| | | formType: 2 |
| | | , area: ['400px', '50px'] //自定义文本域宽高 |
| | | , title: '修改订单号为 【 ' + data.单据号 + ' 】 ,物料代码为 【 ' + data.物料代码 + ' 】 的回复交期' |
| | | , value: data.回复交期 |
| | | , title: '修改订单号为 【 ' + data.单据号 + ' 】 ,物料代码为 【 ' + data.物料代码 + ' 】 的供应商交期回复' |
| | | , value: data.供应商交期回复 |
| | | }, function (value, index) { |
| | | layer.close(index); |
| | | //更新回复交期 |
| | | //更新供应商交期回复 |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "Cg_Poorder/UpdateSupSendGoodsDateRemark", |
| | |
| | | if (result.code == 1) { |
| | | //同步更新表格和缓存对应的值 |
| | | obj.update({ |
| | | 回复交期: value |
| | | 供应商交期回复: value |
| | | }); |
| | | } else { |
| | | layer.alert(result.Message, { icon: 5 }); |
| | |
| | | error: function (result) { |
| | | layer.alert(result.Message, { icon: 5 }); |
| | | } |
| | | }); |
| | | }); |
| | | }); |
| | | } |
| | | }); |
| | |
| | | sheet1: data |
| | | }, '采购订单列表.xlsx', 'xlsx'); |
| | | break; |
| | | case 'btn_backData': |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | parent.GetPoorderValue(data); |
| | | var index = parent.layer.getFrameIndex(window.name); |
| | | parent.layer.close(index); |
| | | break; |
| | | }; |
| | | }); |
| | | |
| | | //行监听事件 |
| | | table.on('row(mainTable)', function (obj) { |
| | | var flag = !obj.tr.find(':checkbox:first').prop('checked'); |
| | | obj.tr.find(':checkbox').prop('checked', flag); |
| | | if (flag) { |
| | | obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //设置复选框选中样式 |
| | | $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//改变当前tr背景颜色和字体颜色 |
| | | } else { |
| | | obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//取消复选框选中样式 |
| | | $(obj.tr.selector).attr({ "style": "background:" });//取消当前tr颜色 |
| | | } |
| | | //mainTable 为表格ID 注意此处如果ID不正确将导致你在监听复选框时获取不到你选择的数据,前面的只是添加或删除选中未选中样式以及设置背景色,字体颜色 |
| | | layui.each(table.cache.mainTable, function (i, l) { |
| | | if (obj.tr.index() == l.LAY_TABLE_INDEX) { |
| | | l.LAY_CHECKED = flag; |
| | | } |
| | | }); |
| | | }); |
| | | |
| | | }); |
| | | </script> |
| | | </body> |