YL
2021-08-19 eeded1aae4fe31610f36e1626d5e33ab499eaa4d
WebTM/views/ÖÊÁ¿¹ÜÀí/¼ìÑé·½°¸µ¥/QC_CheckProjectList.html
@@ -15,7 +15,7 @@
    <div class="layui-card layadmin-header">
        <div class="layui-breadcrumb" lay-filter="breadcrumb">
            <a lay-href="">主页</a>
        </div>
    </div>
@@ -34,7 +34,7 @@
                                        <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">
@@ -48,7 +48,7 @@
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="f_Query">
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                        <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                    </button>
                                </div>
@@ -62,8 +62,11 @@
                    <table class="layui-hide" id="mainTable" lay-filter="mainTable"></table>
                    <script type="text/html" id="toolbarDemo">
                        <div class="layui-btn-container">
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></i>编辑</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete"><i class="layui-icon layui-icon-form"></i>删除</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add" id="btn-Add" ><i class="layui-icon layui-icon-add-1"></i>新增</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit" id="btn-Edit"><i class="layui-icon layui-icon-edit"></i>编辑</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete" id="btn-Delete"><i class="layui-icon layui-icon-delete"></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>
                </div>
@@ -76,341 +79,291 @@
    <script src="../../../layuiadmin/Scripts/json2.js"></script>
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script>
        var _cur_page = 1;
        var sql = " ";
        //var options = document.getElementById('HStatus').children;
        function getUrlVars() {
            var vars = [], hash;
            var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');
            for (var i = 0; i < hashes.length; i++) {
                hash = hashes[i].split('=');
                vars.push(hash[0]);
                vars[hash[0]] = hash[1];
            }
            return vars;
        //获取页面跳转参数  //单据编辑状态: 1.无源单新增  Â 2.有源单新增  Â 3.编辑  4.浏览  5.变更
        var params = get_UrlVars();
        if (typeof (params[params[0]]) == "undefined") {
            var OperationType = 1;//操作类型
        }
        function f_alert(sMsg) {
            layer.alert(sMsg, { icon: 5 });
            //layer.open({
            //    type: 1
            //  , offset: 'auto' //具体配置参考:http://www.layui.com/doc/modules/layer.html#offset
            //  , id: 'layerDemo' //防止重复弹出
            //  , content: '<div style="padding: 20px 100px;">' + sMsg + '</div>'
            //  , shade: 0 //不显示遮罩
            //  , yes: function () {
            //      layer.closeAll();
            //  }
            //});
        }
        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({
            index: 'lib/index' //主入口模块
        }).use(['index', 'form', 'laydate', 'code', 'table', 'element', 'layer'], function () {
            //#region å…¬ç”¨å˜é‡
            var $ = layui.$
            , admin = layui.admin
            , layer = layui.layer
            , laydate = layui.laydate
            , table = layui.table
            , form = layui.form
            , element = layui.element;
            //常规用法
            laydate.render({
                elem: '#HDate1'
            });
            laydate.render({
                elem: '#HDate2'
            });
            //layui.code();
            RoadHBillNo(sql);
            layer.load(3)
            //方法级渲染
            table.render({
                elem: '#mainTable'
                , dateType: 'json'
                , colFilterRecord: true//是否开启字段筛选的记忆功能
                , data: []
                //  , url:  GetWEBURL()+'GetPOOrderBill'
                , toolbar: '#toolbarDemo' //开启头部工具栏,并为其绑定左侧模板
                , defaultToolbar: ['filter', 'exports', 'print']
                // , where: { msg: "", NowPage: 1, OnePage: 10 }
              , cellMinWidth: 100
              , cols: [[
                  { type: 'checkbox', fixed: 'left' }
                  , { field: 'hmainid', title: 'hmainid', sort: true, fixed: true, hide: true }
                  , { field: 'hsubid', title: 'hsubid' ,hide: true }
                  , { field: '日期', title: '日期', sort: true, width: 120 }
                  , { field: '单据号', title: '单据号', sort: true, width: 170 }
                  , { field: '表头备注 ', title: '表头备注', width: 105 }
                  , { field: '物料', title: '物料' }
                  , { field: '物料代码', title: '物料代码' }
                  , { field: '物料名称', title: '物料名称' }
                  , { field: '物料大类代码', title: '物料大类代码' }
                  , { field: '物料大类名称', title: '物料大类名称', width: 115 }
                  , { field: '单位代码', title: '单位代码', width: 115 }
                  , { field: '单位名称', title: '单位名称' }
                  , { field: '工序代码', title: '工序代码', width: 160 }
                  , { field: '工序名称', title: '工序名称', width: 160 }
                  , { field: '部门代码', title: '部门代码', width: 160 }
                  , { field: '部门名称', title: '部门名称', width: 160 }
                  , { field: '制单人', title: '制单人', width: 160 }
                  , { field: '制单日期', title: '制单日期', width: 160 }
                  , { field: '审核人', title: '审核人', width: 160 }
                  , { field: '审核日期', title: '审核日期', hide: true, width: 160 }
                  , { field: '修改人 ', title: '修改人', width: 215 }
                  , { field: '修改日期 ', title: '修改日期 ', width: 115 }
                  , { field: '关闭人', title: '关闭人' }
                  , { field: '关闭日期   ', title: '关闭日期', width: 100 }
                  , { field: '作废人', title: '作废人' }
                  , { field: '审核日期', title: '审核日期' }
                  , { field: '修改人 ', title: '修改人' }
                  , { field: '修改日期', title: '修改日期' }
                  , { field: '关闭人   ', title: '关闭人' }
                  , { field: '关闭日期', title: '关闭日期' }
                  , { field: '作废人', title: '作废人' }
                  , { field: '作废日期', title: '作废日期' }
                  , { field: '单据类型', title: '单据类型' }
                , admin = layui.admin
                , layer = layui.layer
                , laydate = layui.laydate
                , table = layui.table
                , form = layui.form
                , element = layui.element;
              ]]
                //, skin: 'row' //表格风格
                // , even: true
            , page: true //是否显示分页
            , limits: [10, 20, 50, 100]
            , limit: 50 //每页默认显示的数量
                //, height: 500
            , done: function (res, curr, count) {
                _cur_page = curr;
                layer.closeAll("loading");
            var sWhere = "";
            var option = [];
            //#endregion
            //#region è¿›å…¥é¡µé¢å³åŠ è½½
            //判断操作类型
            if (OperationType == 1) {//无源单
                //报工平台报检申请查看列表
                set_ClearBill();
            }
            });
            else {
                layer.alert("未知操作类型!", { icon: 5 });
            }
           //#endregion
            //#region è§¦å‘事件:包括form.on(){}格式的所有点击事件、选择事件等
            //头工具栏事件
            table.on('toolbar(mainTable)', function (obj) {
                var checkStatus = table.checkStatus(obj.config.id);
                switch (obj.event) {
                    case 'btn-getCheckData':
                        var data = checkStatus.data;
                        layer.alert(JSON.stringify(data));
                    //新增按钮
                    case 'btn-Add': set_AddNew();
                        break;
                    case 'btn-Edit':
                        var checkStatus = table.checkStatus('mainTable')
                       , data = checkStatus.data;
                        if (checkStatus.data.length === 1) {
                            var hID = data[0].hmainid.toString();
                            //if (AllowLoadData(sSubStr) != false) {//非空验证
                            layer.open({
                                type: 2
                                , area: ['100%', '100%']
                                , title: '编辑检验方案单'
                                , shade: 0.6 //遮罩透明度
                                , maxmin: true //允许全屏最小化
                                , anim: 0 //0-6的动画形式,-1不开启
                                , content: '../检验方案单/QC_Add_CheckProject.html?hID=' + hID
                                , resize: false
                                , cancel: function () {
                                    //$(".layui-btn").removeClass("layui-btn-disabled");
                                }
                            })
                        } else {
                            layer.msg('请选择一行数据编辑!');
                        }
                    //编辑按钮
                    case 'btn-Edit': set_ShowBill();
                        break;
                    case 'btn-Delete':
                        var checkStatus = table.checkStatus('mainTable')
                            , data = checkStatus.data;
                        if (checkStatus.data.length === 1)
                        {
                            var InterID = data[0].hmainid.toString();
                            //逻辑删除方法
                            $.ajax({
                                url: GetWEBURL() + 'DeltetQCCheckProject',
                                type: "GET",
                                data: { "HInterID": InterID },
                                success: function (result) {
                                    console.log('gouba' + result);
                                    if (result.count == 1) {
                                        layer.msg(result.Message, { icon: 1 }, function () {
                                            // å¾—到frame索引
                                            var index = layer.getFrameIndex(window.name);
                                            //关闭当前frame
                                            layer.close(index);
                                            //修改为功后刷新界面
                                            window.location.reload(); });
                                    } else {
                                        layer.alert(result.code + result.Message, { icon: 5 });
                                    }
                                }, error: function () {
                                    layer.alert("接口请求失败!", { icon: 5 });
                                }
                            });
                        }
                        else {
                            layer.msg('请选择一行数据删除!');
                        }
                    //删除按钮
                    case 'btn-Delete': set_DeleteBill();
                        break;
                    //审核按钮
                    case 'btn-Audit': set_CheckBill();
                        break;
                    //反审核按钮
                    case 'btn-DeAudit': set_AbandonCheck();
                        break;
                    //退出按钮
                    case 'btn_Exit': Pub_Close(1);
                        break;
                };
            });
            //查询
            form.on('submit(btnSearch)', function (data) {//查询
                get_FastQuery();
            });
            //#endregion
            ///加载显示数据
            function RoadHBillNo(sqlWhere) {
                where = sqlWhere;
            //初始化界面
            function set_ClearBill() {
                //初始化表格
                set_InitGrid();
                //查询
                get_Display(sWhere);
            }
            //初始化网格
            function set_InitGrid()
            {
                $("#HDate1").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
                $("#HDate2").val(Format(new Date(), "yyyy-MM-dd"));
                option = {
                    elem: '#mainTable'
                    , dateType: 'json'
                    , colFilterRecord: true//是否开启字段筛选的记忆功能
                    , toolbar: '#toolbarDemo' //开启头部工具栏,并为其绑定左侧模板
                    , defaultToolbar: ['filter', 'exports', 'print']
                    , cellMinWidth: 100
                    , height: 'full-50'
                    , page: true
                    , limits: [50, 500, 1000, 5000]
                    , cols: [[
                        { type: 'checkbox', fixed: 'left' }
                        , { field: 'hmainid', title: 'hmainid', sort: true, fixed: true, hide: true }
                        , { field: 'hsubid', title: 'hsubid', hide: true }
                        , { field: '日期', title: '日期', sort: true, width: 120 }
                        , { field: '单据号', title: '单据号', sort: true, width: 170 }
                        , { field: '表头备注 ', title: '表头备注', width: 105 }
                        , { field: '物料', title: '物料' }
                        , { field: '物料代码', title: '物料代码' }
                        , { field: '物料名称', title: '物料名称' }
                        , { field: '物料大类代码', title: '物料大类代码' }
                        , { field: '物料大类名称', title: '物料大类名称', width: 115 }
                        , { field: '单位代码', title: '单位代码', width: 115 }
                        , { field: '单位名称', title: '单位名称' }
                        , { field: '工序代码', title: '工序代码', width: 160 }
                        , { field: '工序名称', title: '工序名称', width: 160 }
                        , { field: '部门代码', title: '部门代码', width: 160 }
                        , { field: '部门名称', title: '部门名称', width: 160 }
                        , { field: '制单人', title: '制单人', width: 160 }
                        , { field: '制单日期', title: '制单日期', width: 160 }
                        , { field: '审核人', title: '审核人', width: 160 }
                        , { field: '审核日期', title: '审核日期', hide: true, width: 160 }
                        , { field: '修改人 ', title: '修改人', width: 215 }
                        , { field: '修改日期 ', title: '修改日期 ', width: 115 }
                        , { field: '关闭人', title: '关闭人' }
                        , { field: '关闭日期   ', title: '关闭日期', width: 100 }
                        , { field: '作废人', title: '作废人' }
                        , { field: '审核日期', title: '审核日期' }
                        , { field: '修改人 ', title: '修改人' }
                        , { field: '修改日期', title: '修改日期' }
                        , { field: '关闭人   ', title: '关闭人' }
                        , { field: '关闭日期', title: '关闭日期' }
                        , { field: '作废人', title: '作废人' }
                        , { field: '作废日期', title: '作废日期' }
                        , { field: '单据类型', title: '单据类型' }
                    ]]
                };
            }
            //查询
            function get_Display(sWhere) {
                var ajaxLoad = layer.load();
                //进入页面显示的缓存列表
                $.ajax({
                    type: "get",
                    url: GetWEBURL() +"/QC_Management/MES_QC_CheckProjectList_Json",
                    async: true,
                    data: { "sqlWhere": sqlWhere },//"HSupNo": sessionStorage["HUserName"],
                    url: GetWEBURL() + "/QC_Management/MES_QC_CheckProjectList_Json",
                    type: "GET",
                    data: { "sWhere": sWhere },
                    success: function (result) {
                        if (result.count == 1) {
                        ajaxReturnData = JSON.parse(JSON.stringify(result)).data;
                        table.reload('mainTable', {
                            data: ajaxReturnData
                            , height: 'full-10'
                            , page: {
                                curr: _cur_page //必须从第 1 é¡µå¼€å§‹
                            }
                            , loading: false
                            , done: function (index, res) {
                            }
                        });
                    } else {
                            layer.alert(result.code + result.Message, { icon: 5 });
                    }
                    },
                    error: function (result) {
                    layer.alert("接口请求失败!", { icon: 5 });
                            option.data = result.data;
                            table.render(option);
                            layer.close(ajaxLoad);
                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(result.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            };
            form.on('submit(f_Query)', function (data) {//查询
                var sqlWhere = " and 1=1 ";
                //if ($("#HStatus").val() != "")
                //    sqlWhere += " and çŠ¶æ€ like ^^%" + $("#HStatus").val() + "%^^";
                var HBillNo = $("#HBillNo").val();//单据号
                var HNumber = $("#HNumber").val();//物料代码
                var HName = $("#HName").val();//物料名称
                var HModel = $("#HModel").val();//规格型号
                var HDate1 = $("#HDate1").val();//开始日期
                var HDate2 = $("#HDate2").val();//结束日期
            }
                if (HBillNo)
                    sqlWhere += " and å•据号 like '%" + HBillNo+ "%'";
                if (HNumber)
                    sqlWhere += " and ç‰©æ–™ä»£ç  like '%" + HNumber + "%'";
                if (HName)
                    sqlWhere += " and ç‰©æ–™åç§° like '%" + HName + "%'";
                if (HModel)
                    sqlWhere += " and è§„格型号 like '%" + HModel + "%'";
                //if ($("#HClStatus").val() != "")
                //    sqlWhere += " and å…³é—­çŠ¶æ€ like ^^%" + $("#HClStatus").val() + "%^^";
                //if ($("#HPURCHASEORGID").val() != "")
                //    sqlWhere += " and é‡‡è´­ç»„织 like ^^%" + $("#HPURCHASEORGID").val() + "%^^";
            //#region å¿«é€Ÿè¿‡æ»¤
            function get_FastQuery() {
                var HBillNo = $("#HBillNo").val();
                var HDate1 = $("#HDate1").val();
                var HDate2 = $("#HDate2").val();
                if (HBillNo) {
                    sWhere += " and å•据号 like '%" + HBillNo + "%'";
                }
                if (HDate1) {
                    sqlWhere += " and æ—¥æœŸ >= '" + HDate1 + "'";
                    sWhere += " and CONVERT(varchar(100),日期, 23) >= '" + HDate1 + "'";
                }
                if (HDate2) {
                    sqlWhere += " and æ—¥æœŸ <= '" + HDate2 + "'";
                    sWhere += " and CONVERT(varchar(100),日期, 23) <= '" + HDate2 + "'";
                }
                //if ($("#HISGenerate").val() != "") {
                //    if ($("#HISGenerate").val() == "是")
                //    {
                //        sqlWhere += " and æœªå…³è”数量 <= 0";
                //    }
                //    else if ($("#HISGenerate").val() == "否") {
                //        sqlWhere += " and æœªå…³è”数量 > 0";
                //    }
                //}
                get_Display(sWhere);
                sWhere = "";//调用接口后清空sWhere缓存
            }
            //#endregion
            //新增
            function set_AddNew() {
                //页面层-自定义
                layer.open({
                    type: 2,
                    skin: 'layui-layer-rim', //加上边框
                    title: '新增检验方案',
                    closeBtn: 1,
                    shift: 2,
                    area: ['100%', '100%'],
                    maxmin: true,
                    content: '../检验方案单/QC_Add_CheckProject.html?OperationType=1&linterid=&HSouceBillType=',
                    end: function () {
                        //刷新页面,
                        location.reload();
                    },
                    success: function (layero, index) {
                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()));
                    }
                });
            }
            //编辑
            function set_ShowBill() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    var linterid = data[0].hmainid.toString();
                    var HBillStatus = data[0].HBillStatus.toString();
                    //if (AllowLoadData(sSubStr) != false) {//非空验证
                    layer.open({
                        type: 2
                        , area: ['100%', '100%']
                        , title: '编辑检验方案'
                        , closeBtn: 1
                        , shade: 0.6 //遮罩透明度
                        , maxmin: true //允许全屏最小化
                        , anim: 0 //0-6的动画形式,-1不开启
                        , content: '../检验方案单/QC_Add_CheckProject.html?OperationType=3&linterid=' + linterid + '&HSouceBillType='
                        , resize: false,
                        end: function () {
                            //刷新页面,
                            location.reload();
                        }
                        , cancel: function () {
                            //$(".layui-btn").removeClass("layui-btn-disabled");
                        }
                    })
                } else {
                    layer.msg('请选择一行数据编辑!');
                }
                dt = dd.getFullYear().toString();
                if (dd.getMonth() + 1 < 10) {
                    dt = dt + "-0" + (dd.getMonth() + 1).toString();
            }
            //删除
            function set_DeleteBill() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    var InterID = data[0].hmainid.toString();
                    var HBillStatus = data[0].HBillStatus.toString();
                    //逻辑删除方法
                    layer.confirm("确认要删除吗,删除后不能恢复", { title: "删除确认" }, function (index) {
                        $.ajax({
                            type: "GET",
                            url: GetWEBURL() + "Sc_MESBeginWorkBill/DeltetQCCheckProject", //方法所在页面和方法名
                            data: { "HInterID": InterID, "UserName": sessionStorage["HUserName"] },
                            success: function (result) {
                                if (result.count == 1) {
                                    layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
                                        // å¾—到frame索引
                                        var index = layer.getFrameIndex(window.name);
                                        //关闭当前frame
                                        layer.close(index);
                                        //修改为功后刷新界面
                                        window.location.reload();
                                    });
                                } else {
                                    layer.alert(result.code + result.Message, { icon: 5 });
                                }
                            }, error: function () {
                                layer.alert("接口请求失败!", { icon: 5 });
                            }
                        });
                    })
                }
                else {
                    dt = dt + "-0" + (dd.getMonth() + 1).toString();
                    layer.msg('请选择一行数据删除!');
                }
                if (dd.getDate() < 10) {
                    dt = dt + "-0" + dd.getDate().toString();
                }
                else {
                    dt = dt + "-" + dd.getDate().toString();
                }
                //if (Time != 8) {
                //    sqlWhere += " and äº¤è´§æ—¥æœŸ <= ^^" + dt + "^^";
                //}
                sql = sqlWhere;
                //从第一页开始
                _cur_page = 1;
                RoadHBillNo(sqlWhere);
            });
            var $ = layui.$, active = {
                f_Query: function () { //查询
            }
                },
                f_Qrjq: function () { //接受
            //审核
            function set_CheckBill() {
                },
                f_Bhjq: function () { //拒绝
            }
                },
                //JSreload: function () {
                //    var demoReload = $('#test-table-demoReload');
                //    //执行重载
                //    table.JSreload('test-table-reload', {
                //        page: {
                //            curr: 1 //重新从第 1 é¡µå¼€å§‹
                //        }
                //      , where: {
                //          key: {
                //              id: demoReload.val()
                //          }
                //      }
                //    });
                //}
            };
            $('.test-table-reload-btn .layui-btn').on('click', function () {
                var type = $(this).data('type');
                active[type] ? active[type].call(this) : '';
            });
            //反审核
            function set_AbandonCheck() {
            }
        });
    </script>
</body>