| | |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">业务终止</label> |
| | | <div class="layui-input-block"> |
| | | <select id="HIsStop" name="HIsStop" lay-filter=""> |
| | | <option value="全部">全部</option> |
| | | <option value="是">是</option> |
| | | <option value="否" selected>否</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> |
| | | </button> |
| | |
| | | var wait = layer.load();//遮罩 |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + "GetPOOrderBill", |
| | | url: GetWEBURL() + "GetPOOrderBill", //H_p_SRM_POOrderBillList |
| | | async: true, |
| | | data: { "HSupNo": sessionStorage["HUserName"], "sqlWhere": sqlWhere }, |
| | | success: function (data1) { |
| | |
| | | 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>", width: 200 }); |
| | | break; |
| | | default: |
| | | if (data[i].name == '订单数量' || data[i].name == '已发货数量' || data[i].name == '未发货数量') { |
| | | if (data[i].name == '订单数量' || data[i].name == '已发货数量' || data[i].name == '未发货数量' || data[i].name == '剩余收料数量' || data[i].name == '未到货数量' || 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 == '供应商交期回复') { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: 'HSupSendGoodsDateRemark' }); |
| | |
| | | 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() == "是") { |
| | |
| | | else if ($("#HIsFreeze").val() == "业务冻结") { |
| | | sqlWhere += " and 业务冻结 = ^^业务冻结^^"; |
| | | } |
| | | } |
| | | if ($("#HIsStop").val() != "") { |
| | | if ($("#HIsStop").val() == "是") { |
| | | sqlWhere += " and 业务终止 = ^^业务终止^^"; |
| | | } |
| | | else if ($("#HIsStop").val() == "否") { |
| | | sqlWhere += " and 业务终止 = ^^正常^^"; |
| | | } |
| | | } |
| | | |
| | | var Time = $("#Time").val(); |
| | | if (Time > 0) { |
| | | var dd = new Date(); |