| | |
| | | <label class="layui-form-label">关闭状态</label> |
| | | <div class="layui-input-block"> |
| | | <select id="HClStatus" name="HClStatus" lay-filter=""> |
| | | <option value="">全部</option> |
| | | <option value="未关闭" selected="">未关闭</option> |
| | | <option value="" selected>全部</option> |
| | | <option value="未关闭">未关闭</option> |
| | | <option value="已关闭">已关闭</option> |
| | | </select> |
| | | </div> |
| | |
| | | <label class="layui-form-label">交货时间</label> |
| | | <div class="layui-input-block"> |
| | | <select id="Time" name="Time" lay-filter=""> |
| | | <option value="0" selected>全部</option> |
| | | <option value="1">一周内交货</option> |
| | | <option value="2">二周内交货</option> |
| | | <option value="3">一月内交货</option> |
| | |
| | | <option value="5">三月内交货</option> |
| | | <option value="6">半年内交货</option> |
| | | <option value="7">一年内交货</option> |
| | | <option value="8" selected="">长期交货</option> |
| | | <option value="8">长期交货</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | |
| | | <label class="layui-form-label">采购组织</label> |
| | | <div class="layui-input-block"> |
| | | <select id="HPURCHASEORGID" name="HPURCHASEORGID" lay-filter=""> |
| | | <option value="">组织1</option> |
| | | <option value="">组织2</option> |
| | | <option value="">安瑞</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | |
| | | <label class="layui-form-label">是否已下推送货单</label> |
| | | <div class="layui-input-block"> |
| | | <select id="HISGenerate" name="HISGenerate" lay-filter=""> |
| | | <option value="全部">全部</option> |
| | | <option value="全部" selected>全部</option> |
| | | <option value="是">是</option> |
| | | <option value="否" selected="">否</option> |
| | | <option value="否">否</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | |
| | | <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-generate"><i class="layui-icon layui-icon-file"></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> |
| | | </div> |
| | | </script> |
| | |
| | | //{ checkbox: true, fixed: true } |
| | | { type: 'checkbox', fixed: 'left' } |
| | | //{ type: 'radio', fixed: true } |
| | | , { field: 'sorderid', title: '序号', width: 80, fixed: true } |
| | | , { field: 'hmainid', title: 'hmainid', sort: true, fixed: true, hide: true } |
| | | , { field: 'hsubid', title: 'hsubid', sort: true, fixed: true, hide: true } |
| | | , { field: '状态', title: '状态', sort: true, fixed: true } |
| | | , { field: '反馈状态', title: '反馈状态', width: 100, fixed: true } |
| | | , { field: '单据号', title: '单据号', width: 180, sort: true, fixed: 'left' } |
| | | , { field: '日期', title: '日期', width: 180, sort: true, fixed: 'left' } |
| | | , { field: '供应商', title: '供应商', width: 180, sort: true, fixed: 'left' } |
| | | , { field: 'sorderid', title: '序号', width: 80/*, fixed: true */} |
| | | , { field: 'hmainid', title: 'hmainid', sort: true, /*fixed: true,*/ hide: true } |
| | | , { field: 'hsubid', title: 'hsubid', sort: true, /*fixed: true,*/ hide: true } |
| | | , { field: '状态', title: '状态', sort: true/*, fixed: true */} |
| | | , { field: '反馈状态', title: '反馈状态', width: 100/*, fixed: true */} |
| | | , { field: '优先级', title: '优先级', width: 100/*, fixed: true */} |
| | | , { field: '单据号', title: '单据号', width: 180, sort: true/*, fixed: 'left' */} |
| | | , { field: '日期', title: '日期', width: 180, sort: true/*, fixed: 'left' */} |
| | | , { field: 'HSupID', title: 'HSupID', width: 180, hide: true } |
| | | , { field: '供应商', title: '供应商', width: 180, sort: true/*, fixed: 'left' */} |
| | | , { field: '计划跟踪单号', title: '计划跟踪单号', sort: true, hide: true } |
| | | , { field: '物料代码', title: '物料代码', width: 180, sort: true } |
| | | , { field: '物料名称', title: '物料名称', width: 180, sort: true } |
| | |
| | | var rows = ''; |
| | | var HEntry = ''; |
| | | for (var i = 0; i < data.length; i++) { |
| | | if (data[i]["未关联数量"] == 0) { |
| | | layer.msg("单据号:" + data[i]["单据号"] + "已全部生成送货单!", { icon: 5 }); |
| | | return; |
| | | } |
| | | if (data[i]["状态"] == "已确认") { |
| | | rows += data[i].hmainid.toString() + ',' + data[i].hsubid.toString() + ';'; |
| | | } |
| | |
| | | |
| | | |
| | | var Time = $("#Time").val(); |
| | | var dd = new Date(); |
| | | var dt; |
| | | switch (Time) { |
| | | case 1: dd = new Date(dd.setDate(dd.getDate() + 7)); |
| | | case 2: dd = new Date(dd.setDate(dd.getDate() + 14)); |
| | | case 3: dd = new Date(dd.setMonth(dd.getMonth() + 1)); |
| | | case 4: dd = new Date(dd.setMonth(dd.getMonth() + 2)); |
| | | case 5: dd = new Date(dd.setMonth(dd.getMonth() + 3)); |
| | | case 6: dd = new Date(dd.setMonth(dd.getMonth() + 6)); |
| | | case 7: dd = new Date(dd.setMonth(dd.getMonth() + 12)); |
| | | default: dd = new Date(dd.setDate(dd.getDate())); |
| | | } |
| | | dt = dd.getFullYear().toString(); |
| | | if (dd.getMonth() + 1 < 10) { |
| | | dt = dt + "-0" + (dd.getMonth() + 1).toString(); |
| | | } |
| | | else { |
| | | dt = dt + "-0" + (dd.getMonth() + 1).toString(); |
| | | } |
| | | if (dd.getDate() < 10) { |
| | | dt = dt + "-0" + dd.getDate().toString(); |
| | | } |
| | | else { |
| | | dt = dt + "-" + dd.getDate().toString(); |
| | | } |
| | | if (Time != 8) { |
| | | sqlWhere += " and 交货日期 <= ^^" + dt + "^^"; |
| | | if (Time > 0) { |
| | | var dd = new Date(); |
| | | var dt; |
| | | switch (Time) { |
| | | case 1: dd = new Date(dd.setDate(dd.getDate() + 7)); |
| | | case 2: dd = new Date(dd.setDate(dd.getDate() + 14)); |
| | | case 3: dd = new Date(dd.setMonth(dd.getMonth() + 1)); |
| | | case 4: dd = new Date(dd.setMonth(dd.getMonth() + 2)); |
| | | case 5: dd = new Date(dd.setMonth(dd.getMonth() + 3)); |
| | | case 6: dd = new Date(dd.setMonth(dd.getMonth() + 6)); |
| | | case 7: dd = new Date(dd.setMonth(dd.getMonth() + 12)); |
| | | default: dd = new Date(dd.setDate(dd.getDate())); |
| | | } |
| | | dt = dd.getFullYear().toString(); |
| | | if (dd.getMonth() + 1 < 10) { |
| | | dt = dt + "-0" + (dd.getMonth() + 1).toString(); |
| | | } |
| | | else { |
| | | dt = dt + "-0" + (dd.getMonth() + 1).toString(); |
| | | } |
| | | if (dd.getDate() < 10) { |
| | | dt = dt + "-0" + dd.getDate().toString(); |
| | | } |
| | | else { |
| | | dt = dt + "-" + dd.getDate().toString(); |
| | | } |
| | | if (Time != 8) { |
| | | sqlWhere += " and 交货日期 <= ^^" + dt + "^^"; |
| | | } |
| | | } |
| | | sql = sqlWhere; |
| | | //从第一页开始 |