智云MES-UI前端
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
1
zrg
2025-12-03 5b155f18c496a8f5d2572cf03d9f5ff22014dc13 
 WebTM/views/Éú²ú¹ÜÀí/ÈýÉýÅŲú/JIT_DayPlanPlatForm.html


@@ -2,13 +2,13 @@


<html>


<head>


    <meta charset="utf-8" />


    <title>生产计划排产</title>


    <title>三升生产计划排产</title>


    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">


    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">


    <link rel="stylesheet" href="../../../layuiadmin/ext/soulTable.css" media="all">


    <script src="../../../layuiadmin/layui/layui.js"></script>


    <script src="../../../layuiadmin/Scripts/json2.js"></script>


    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>


    <!--<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/PubCustom.js"></script>


    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>


@@ -17,24 +17,26 @@


</head>


<body>


    <div class="layui-fluid">


        <div class="layui-col-md12">


        <div class="layui-col-md13">


            <div class="layui-card" style="padding: 1px">


                <div class="layui-card-body" style="padding: 1px;">


                    <form class="layui-form" action="" lay-filter="component-form-group">


                        <div style="padding: 10px; ">


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="ExcelImport" id="ExcelImport">Excel导入</button>


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="ExcelDateImport" id="ExcelDateImport">交期导入</button>


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnICMOBill" id="btnICMOBill">生产订单选单</button>


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnAddICMO" id="btnAddICMO">添加订单</button>


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">保存</button>


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnReady" id="btnReady">准备</button>


                            <!--<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnReady" id="btnReady">准备</button>-->


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnProPC" id="btnProPC">排产</button>


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnLock" id="btnLock">锁定</button>


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlock" id="btnUnlock">解锁</button>


                            <!--<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnLock" id="btnLock">锁定</button>


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlock" id="btnUnlock">解锁</button>-->


                            <!--<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnLockRequest" id="btnLock">锁定申请</button>


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlockRequest" id="btnUnlock">解锁申请</button>-->


                            <!--<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnLockOrder" id="btnLockOrder">锁定工单</button>


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlockOrder" id="btnUnlockOrder">解锁工单</button>-->


    <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlockRequest" id="btnUnlock">解锁申请</button>-->


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnLockOrder" id="btnLockOrder">锁定工单</button>


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlockOrder" id="btnUnlockOrder">解锁工单</button>


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnCompleteSetAnalysis" id="btnCompleteSetAnalysis">齐套分析</button>


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnYLYS" id="btnYLYS">要料运算</button>


                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnTLYS" id="btnTLYS">提料运算</button>


                            <!--<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btn_Calculate" id="btn_Calculate">欠料运算</button>-->


                            <!--<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnRoutEdit" id="btnRoutEdit">工艺路线</button>-->


@@ -248,10 +250,10 @@


                            </div>


                        </div>


                        <div id="HProgressBar"></div>


                        <div class="layui-row" style="padding:10px 0">


                        <div class="layui-row" style="padding:0px 0">


                            <table class="" id="mainTable" lay-filter="mainTable"></table>


                        </div>


                        <div class="resizable-container layui-tab layui-tab-card" style="margin-top:40px;">


                        <div class="resizable-container layui-tab layui-tab-card" style="margin-top: 40px; display: none;">


                            <ul class="layui-tab-title">


                                <li class="layui-this">生产订单</li>


                                <li>缺料分析</li>


@@ -301,22 +303,23 @@


                        <script type="text/html" id="toolbarDemo">


                            <div class="layui-btn-container">


                                <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="set_BatchFill"><i class="layui-icon layui-icon-file-b"></i>批量填充</button>


                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>编辑</button>-->


    <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>编辑</button>-->


                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-CopyLine"><i class="layui-icon layui-icon-form"></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="set_MoverUp"><i class="layui-icon layui-icon-delete"></i>上移</button>


                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_MoverDown"><i class="layui-icon layui-icon-delete"></i>下移</button>


                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Priority"><i class="layui-icon layui-icon-delete"></i>优先级</button>


                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ReadyAsc"><i class="layui-icon layui-icon-delete"></i>准备排序</button>


                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ReadyWorkQty"><i class="layui-icon layui-icon-delete"></i>准备(同步产能)</button>


                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Souce"><i class="layui-icon layui-icon-delete"></i>选产线</button>


                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Emp"><i class="layui-icon layui-icon-delete"></i>选操作工</button>


                                <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="set_Emp"><i class="layui-icon layui-icon-delete"></i>选操作工</button>-->


                                <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" lay-event="set_Routing"><i class="layui-icon layui-icon-form"></i>工艺路线</button>


                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Calendar"><i class="layui-icon layui-icon-form"></i>工厂日历</button>


                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导出</button>


                            </div>


                        </script>


                        <script type="text/html" id="toolbarDemo2">


                        <!--<script type="text/html" id="toolbarDemo2">


                            <div class="layui-btn-container">


                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Arrangement"><i class="layui-icon layuiiconform"></i>排产</button>


                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn_ICMO"><i class="layui-icon layuiiconform"></i>列设置</button>


@@ -328,7 +331,7 @@


                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn_Material"><i class="layui-icon layuiiconform"></i>列设置</button>


                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Close"><i class="layui-icon layui-icon-logout"></i>退出</button>


                            </div>


                        </script>


                        </script>-->


                    </form>


                </div>


            </div>


@@ -347,7 +350,8 @@


        base: '../../../layuiadmin/' //静态资源所在路径


    }).extend({


        index: 'lib/index', //主入口模块


    }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util', 'soulTable','jquery'], function () {


        soulTable: 'soulTable'


    }).use(['index', 'form', 'table', 'element', 'laydate', 'util', 'soulTable','jquery'], function () {


        //#region å…¬ç”¨å˜é‡




        var $ = layui.$


@@ -356,7 +360,6 @@


            , table = layui.table


            , form = layui.form


            , laydate = layui.laydate


            , excel = layui.excel


            , soulTable = layui.soulTable


            , element = layui.element;


        var ins;


@@ -427,25 +430,29 @@


                return layer.msg("拆单数量不能为0!");


            }




            if (SumHQty > (parseInt(obj.data["计划数量"]))) {


            if (SumHQty > (parseInt(obj.data["计划数量"])) && obj.field == "拆单数量") {


                obj.update({


                    "拆单数量": "0"


                    "拆单数量": $(this).prev().text()


                });


                


                obj.tr.find('td[data-field=拆单数量] input').val($(this).prev().text());  // è¿™å¥ä»£ç æ˜¯å¿…要的更新显示内容


                


                return layer.msg("拆单数量大于订单数量!");


            }




            var NowDate = obj.field;


            if (dateHQty > (parseInt(obj.data["计划数量"]))) {


            if (dateHQty > (parseInt(obj.data["拆单数量"]))) {


                obj.update({


                    "日计划数量总量": dateHQty - obj.value,


                    [NowDate]: 0


                });


                return layer.msg("排产数量大于订单数量!")


                obj.tr.find(`td[data-field=${NowDate}] input`).val(0);  // è¿™å¥ä»£ç æ˜¯å¿…要的更新显示内容


                return layer.msg("排产数量大于拆单数量!")


            }




            if (Date.parse(obj.field) > Date.parse(obj.data.计划结束日期)) {


                return layer.msg("排产日期超出计划结束日期!");


            }


            //if (Date.parse(obj.field) > Date.parse(obj.data.计划结束日期)) {


            //    return layer.msg("排产日期超出计划结束日期!");


            //}






            //修改数据


@@ -583,6 +590,29 @@


                case 'set_ReadyAsc':


                    set_ReadyAsc();


                    break;


                //准备同步产能


                case 'set_ReadyWorkQty':


                    layer.confirm('你确定要执行操作吗，请先确保排产数据已保存？', {


                        btn: ['确定', '取消'] //按钮


                        , btn1: function (index, layero) {


                            // 1. èŽ·å–“确定”按钮并添加加载动画


                            var confirmBtn = $(layero).find('.layui-layer-btn0'); // ç¡®å®šæŒ‰é’®


                            confirmBtn.html('<i class="layui-icon layui-icon-loading layui-anim layui-anim-rotate"></i> å¤„理中...');


                            confirmBtn.prop('disabled', true);


                            if (data.length <= 0) {


                                layer.msg("请选择数据")


                                layer.close(index);


                            } else {


                                setTimeout(function () {


                                    get_btnReady(data);


                                    layer.close(index);


                                }, 5); // å»¶è¿Ÿæ‰§è¡Œç¡®ä¿æŒ‰é’®å›¾æ ‡æ¸²æŸ“完


                            }


                            


                            


                        }


                    })


                    break;


                //选产线


                case 'set_Souce':


                    set_Souce(data);


@@ -644,7 +674,10 @@


        form.on('submit(ExcelImport)', function () {


            btnExcelImport();


        });




        //完工导入


        form.on('submit(ExcelDateImport)', function () {


            btnExcelDateImport();


        });


        //保存


        form.on('submit(btnSave)', function (data) {


            var HWorkShopID = $("#HWorkShopID").val();//生产车间


@@ -721,7 +754,16 @@


                })


            }


        })




        //要料运算


        form.on('submit(btnYLYS)', function (data) {


            layer.confirm('你确定要执行操作吗，请先确保排产数据已保存？', {


                btn: ['确定', '取消'] //按钮


                , btn1: function (index, layero) {


                    get_btnYLYS();


                    layer.close(index);


                }


            })


        })


        //提料运算


        form.on('submit(btnTLYS)', function (data) {


            if (set_ModCheck("Sc_WorkBillSortBill_tlys") == true) {


@@ -1011,10 +1053,10 @@


            var ajaxLoad = layer.load();


            //进入页面显示的缓存列表


            $.ajax({


                url: GetWEBURL() + '/Gy_Department/list',


                url: GetWEBURL() + '/Gy_Department/cx',


                type: "GET",


                async: false,


                data: { "sWhere": "and HItemID = " + HWorkShopID, "user": sessionStorage["HUserName"], "Organization": sessionStorage["Organization"] },


                data: { "HInterID": HWorkShopID },


                success: function (data1) {


                    if (data1.count == 1) {


                        $("#HWorkShopID").val(HWorkShopID);


@@ -1046,8 +1088,9 @@


            Organ();


            //初始化表格


            set_InitGrid();


            get_FastQuery(1);


            get_FastQuery_ICMO();


            get_FastQuery(2);


            //生产订单查询


            /*get_FastQuery_ICMO();*/


        }


        //#region åˆå§‹åŒ–下拉列表 æŽ’产时间


        function setSelect_HArrangeProductDayQty() {


@@ -1058,8 +1101,8 @@


            var lastDay = new Date(year, month, 0).getDate();               //当月最后一天


            var thisDay = new Date().getDay();                              //当天是本月第几天




            var valueList = [7, lastDay - thisDay+1,31,40];


            var titleList = ["7天", "本月","31天","40天"];


            var valueList = [7,30,40,50,60,70,80,90,100];


            var titleList = ["7天","30天","40天","50天","60天","70天","80天","90天","100天"];




            var HArrangeProductDayQty_ArrayList = '';


            for (var i = 0; i < valueList.length; i++) {


@@ -1068,9 +1111,10 @@




            $("#HArrangeProductDayQty").empty();


            $("#HArrangeProductDayQty").append(HArrangeProductDayQty_ArrayList);


            form.render('select');


            




            $("#HArrangeProductDayQty").val("40");


            form.render('select');


        }


        //#endregion




@@ -1130,6 +1174,9 @@


                    return DayColor(d[Format(myDate.getTime() + 9 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 9 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 9 * oneday, 'yyyy-MM-dd'));


                }


            })//0








            columns.push({


                field: Format(myDate.getTime() + 10 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 10 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 10 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 10 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 10 * oneday, 'yyyy-MM-dd'));


@@ -1180,6 +1227,10 @@


                    return DayColor(d[Format(myDate.getTime() + 19 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 19 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 19 * oneday, 'yyyy-MM-dd'));


                }


            })//0










            columns.push({


                field: Format(myDate.getTime() + 20 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 20 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 20 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 20 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 20 * oneday, 'yyyy-MM-dd'));


@@ -1230,6 +1281,10 @@


                    return DayColor(d[Format(myDate.getTime() + 29 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 29 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 29 * oneday, 'yyyy-MM-dd'));


                }


            })//0










            columns.push({


                field: Format(myDate.getTime() + 30 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 30 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 30 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 30 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 30 * oneday, 'yyyy-MM-dd'));


@@ -1250,10 +1305,6 @@


                    return DayColor(d[Format(myDate.getTime() + 33 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 33 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 33 * oneday, 'yyyy-MM-dd'));


                }


            })//0










            columns.push({


                field: Format(myDate.getTime() + 34 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 34 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 34 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 34 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 34 * oneday, 'yyyy-MM-dd'));


@@ -1264,37 +1315,34 @@


                    return DayColor(d[Format(myDate.getTime() + 35 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 35 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 35 * oneday, 'yyyy-MM-dd'));


                }


            })//0




            columns.push({


                field: Format(myDate.getTime() + 36 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 36 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 36 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 36 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 36 * oneday, 'yyyy-MM-dd'));


                }


            })//0




            columns.push({


                field: Format(myDate.getTime() + 37 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 37 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 37 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 37 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 37 * oneday, 'yyyy-MM-dd'));


                }


            })//0




            columns.push({


                field: Format(myDate.getTime() + 38 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 38 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 38 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 38 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 38 * oneday, 'yyyy-MM-dd'));


                }


            })//0




            columns.push({


                field: Format(myDate.getTime() + 39 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 39 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 39 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 39 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 39 * oneday, 'yyyy-MM-dd'));


                }


            })//0








            columns.push({


                field: Format(myDate.getTime() + 40 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 40 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 40 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 40 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 40 * oneday, 'yyyy-MM-dd'));


                }


            })//0




            columns.push({


                field: Format(myDate.getTime() + 41 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 41 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 41 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 41 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 41 * oneday, 'yyyy-MM-dd'));


@@ -1340,13 +1388,273 @@


                    return DayColor(d[Format(myDate.getTime() + 49 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 49 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 49 * oneday, 'yyyy-MM-dd'));


                }


            })//0










            columns.push({


                field: Format(myDate.getTime() + 50 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 50 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 50 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 50 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 50 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            


            columns.push({


                field: Format(myDate.getTime() + 51 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 51 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 51 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 51 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 51 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 52 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 52 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 52 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 52 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 52 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 53 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 53 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 53 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 53 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 53 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 54 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 54 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 54 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 54 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 54 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 55 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 55 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 55 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 55 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 55 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 56 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 56 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 56 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 56 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 56 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 57 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 57 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 57 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 57 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 57 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 58 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 58 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 58 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 58 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 58 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 59 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 59 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 59 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 59 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 59 * oneday, 'yyyy-MM-dd'));


                }


            })//0








            columns.push({


                field: Format(myDate.getTime() + 60 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 60 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 60 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 60 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 60 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 61 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 61 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 61 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 61 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 61 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 62 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 62 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 62 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 62 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 62 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 63 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 63 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 63 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 63 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 63 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 64 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 64 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 64 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 64 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 64 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 65 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 65 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 65 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 65 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 65 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 66 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 66 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 66 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 66 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 66 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 67 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 67 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 67 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 67 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 67 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 68 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 68 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 68 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 68 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 68 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 69 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 69 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 69 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 69 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 69 * oneday, 'yyyy-MM-dd'));


                }


            })//0










            columns.push({


                field: Format(myDate.getTime() + 70 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 70 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 70 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 70 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 70 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 71 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 71 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 71 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 71 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 71 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 72 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 72 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 72 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 72 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 72 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 73 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 73 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 73 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 73 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 73 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 74 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 74 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 74 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 74 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 74 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 75 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 75 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 75 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 75 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 75 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 76 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 76 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 76 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 76 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 76 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 77 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 77 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 77 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 77 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 77 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 78 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 78 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 78 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 78 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 78 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 79 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 79 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 79 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 79 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 79 * oneday, 'yyyy-MM-dd'));


                }


            })//0








            columns.push({


                field: Format(myDate.getTime() + 80 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 80 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 80 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 80 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 80 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 81 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 81 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 81 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 81 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 81 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 82 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 82 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 82 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 82 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 82 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 83 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 83 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 83 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 83 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 83 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 84 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 84 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 84 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 84 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 84 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 85 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 85 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 85 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 85 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 85 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 86 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 86 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 86 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 86 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 86 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 87 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 87 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 87 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 87 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 87 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 88 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 88 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 88 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 88 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 88 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 89 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 89 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 89 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 89 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 89 * oneday, 'yyyy-MM-dd'));


                }


            })//0








            columns.push({


                field: Format(myDate.getTime() + 90 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 90 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 90 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 90 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 90 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 91 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 91 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 91 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 91 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 91 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 92 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 92 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 92 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 92 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 92 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 93 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 93 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 93 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 93 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 93 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 94 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 94 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 94 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 94 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 94 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 95 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 95 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 95 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 95 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 95 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 96 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 96 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 96 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 96 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 96 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 97 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 97 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 97 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 97 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 97 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 98 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 98 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 98 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 98 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 98 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            columns.push({


                field: Format(myDate.getTime() + 99 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 99 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {


                    return DayColor(d[Format(myDate.getTime() + 99 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 99 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 99 * oneday, 'yyyy-MM-dd'));


                }


            })//0


            return columns;


        }


        //#endregion


@@ -1386,19 +1694,19 @@


            columns.push({ field: '销售订单号', title: '销售订单号', width: 150, filter: true, sort: true});


            columns.push({ field: '生产订单号', title: '生产订单号', width: 150, style: 'background-color: #f9f9f9;', filter: true, sort: true });


            columns.push({ field: '客户订单号', title: '客户订单号', width: 150, style: 'background-color: #f9f9f9;', filter: true, sort: true });


            columns.push({ field: '生产组织', title: '生产组织', width: 150, filter: true, sort: true });


            columns.push({ field: '生产组织', title: '生产组织', width: 150, sort: true });


            columns.push({ field: '物料代码', title: '物料编码', width: 150, filter: true, sort: true});


            columns.push({ field: '物料名称', title: '物料名称', width: 150, filter: true, sort: true});


            columns.push({ field: '规格型号', title: '规格型号', width: 150, filter: true, sort: true });


            columns.push({ field: '小时产能', title: '小时产能', width: 150, edit: 'text', filter: true, sort: true });


            columns.push({ field: '销售订单数量', title: '销售订单数量', width: 150, filter: true, sort: true });//0


            //0


            columns.push({ field: '计划数量', title: '生产订单数量', width: 150, filter: true, sort: true });//0


            columns.push({ field: '日计划数量总量', title: '日计划数量总量', width: 150, filter: true, sort: true });//0


            columns.push({ field: '今日之前日计划数量', title: '今日之前日计划数量', width: 150 });//0


            columns.push({ field: '生产订单日期', title: '生产订单日期', width: 150, templet: "<div>{{d.生产订单日期 ==null ?'':layui.util.toDateString(d.生产订单日期, 'yyyy-MM-dd')}}</div>", filter: true, sort: true });


            columns.push({ field: '计划开始日期', title: '预计开工日期', width: 150, templet: "<div>{{d.计划开始日期 ==null ?'':layui.util.toDateString(d.计划开始日期, 'yyyy-MM-dd')}}</div>", filter: true, sort: true });


            


            columns.push({ field: '计划结束日期', title: '计划结束日期', width: 150, templet: "<div>{{d.计划结束日期 ==null ?'':layui.util.toDateString(d.计划结束日期, 'yyyy-MM-dd')}}</div>", event: "HPlanEndDate", filter: true, sort: true });


            columns.push({ field: '订单可排数量', title: '订单可排数量', width: 150, filter: true, sort: true});


            columns.push({ field: '订单可排数量', title: '订单可排数量', width: 150, sort: true});


            columns.push({ field: '拆单数量', title: '拆单数量', width: 150, edit: 'text', filter: true, sort: true });


            columns.push({ field: '昨日数量', title: '昨日数量', filter: true, sort: true });


            columns.push({ field: '优先级', title: '优先级', width: 150, edit: 'text', filter: true, sort: true });


@@ -1410,12 +1718,12 @@


            for (var i = 0; i < HArrangeProductDayQty; i++) {


                columns.push(dateColumns[i]);//0


            }




            columns.push({ field: '计划开始日期', title: '预计开工日期', width: 150, templet: "<div>{{d.计划开始日期 ==null ?'':layui.util.toDateString(d.计划开始日期, 'yyyy-MM-dd')}}</div>", filter: true, sort: true });


            columns.push({ field: '生产订单明细行号', title: '生产订单明细行号', width: 150 });


            columns.push({ field: 'T31', title: 'T31', width: 70 });//0


            columns.push({ field: '订单类型', title: '订单类型', width: 150 });


            columns.push({ field: '生产订单单据类型', title: '源单订单单据类型', width: 150 });


            columns.push({ field: '业务状态', title: '业务状态', width: 150 });


            columns.push({ field: '业务状态', title: '业务状态', width: 150, filter: true, sort: true  });


            columns.push({ field: '产线入库数量', title: '产线入库数量', width: 150 });


            columns.push({ field: '未排数量', title: '可排数量', width: 150 });


            columns.push({ field: '订单等级', title: '订单等级', width: 150 });


@@ -1425,6 +1733,7 @@


            columns.push({ field: '生产周期', title: '生产周期', width: 150 });


            columns.push({ field: '最迟开工日期', title: '最迟开工日期', width: 150, templet: "<div>{{d.最迟开工日期 =='' ?'':layui.util.toDateString(d.最迟开工日期, 'yyyy-MM-dd')}}</div>" });


            columns.push({ field: '最迟完工日期', title: '最迟完工日期', width: 150, templet: "<div>{{d.最迟完工日期 =='' ?'':layui.util.toDateString(d.最迟完工日期, 'yyyy-MM-dd')}}</div>" });


            columns.push({ field: '销售订单数量', title: '销售订单数量', width: 150, sort: true });


            columns.push({ field: '生产车间', title: '生产车间', width: 150 });


            columns.push({ field: '源单主内码', title: '源单主内码', width: 150 });


            columns.push({ field: '源单子内码', title: '源单子内码', width: 150 });


@@ -1444,17 +1753,43 @@


            columns.push({ field: 'HEmpID', title: 'HEmpID', hide: true });


            columns.push({ field: '拆单汇报数量', title: '拆单汇报数量', width: 150, edit: 'text' });


            columns.push({ field: '锁定工单', title: '锁定工单', width: 150, filter: true });//0


            columns.push({ fixed: 'right', title: '操作', toolbar: '#barDemo' });


            columns.push({ fixed: 'right', field: '操作', title: '操作', toolbar: '#barDemo' });


            option_columns = columns;


            option = {


                elem: '#mainTable'


                , toolbar: '#toolbarDemo'


                , height: 'full-120'


                , title: "计划报表"


                , height: 'full-175'


                , page: false


                , cellMinWidth: 90


                , cols: [columns]


                , limit: Number.MAX_VALUE//默认显示全部


                , even: true


                , limit: 5000//默认显示全部


                , contextmenu: {


                    // è¡¨æ ¼å†…容右键菜单配置


                    body: [


                        {


                            name: '复制',


                            icon: 'layui-icon layui-icon-template',


                            click: function (obj) {


                                soulTable.copy(obj.text)


                                layer.msg('复制成功！')


                            }


                        },


                        {


                            name: '行-蓝色',


                            click: function (obj) {


                                obj.trElem.css('background', '#01AAED')


                            }


                        },


                        {


                            name: '红色',


                            click: function (obj) {


                                obj.elem.css('color', 'red')


                            }


                        }


                    ]


                }


                , even: true//行拖拽


                , rowDrag: {/*trigger: 'row',*/


                    done: function (obj) {


                        // å®Œæˆæ—¶ï¼ˆæ¾å¼€æ—¶ï¼‰è§¦å‘


@@ -1483,17 +1818,17 @@


                }


                , done: function (res, page, count) {


                    soulTable.render(this);


                    $('.layui-table thead').on('click', 'th', function () {


                        // èŽ·å–点击的表头的 field å€¼


                        var field = $(this).data('field');


                        set_InitGrid1(field);


                        sWhere = {


                            HORGID: sessionStorage["OrganizationID"]


                            , HBEGINDATE: field


                            , HENDDATE: field


                        }


                        //get_Display_3(JSON.stringify(sWhere));


                    });


                    //$('.layui-table thead').on('click', 'th', function () {


                    //    // èŽ·å–点击的表头的 field å€¼


                    //    var field = $(this).data('field');


                    //    set_InitGrid1(field);


                    //    sWhere = {


                    //        HORGID: sessionStorage["OrganizationID"]


                    //        , HBEGINDATE: field


                    //        , HENDDATE: field


                    //    }


                    //    //get_Display_3(JSON.stringify(sWhere));


                    //});


                    //res.data.forEach(function (item, index) {


                    //    if (data1.data.DataColor != undefined) {


                    //        var sj = data1.data.DataColor;


@@ -1512,6 +1847,8 @@


                    //})


                }


            }




            table.render(option);


        }




        //缺料分析表格数据


@@ -1548,7 +1885,7 @@


            $.ajax({


                url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillList',


                type: "GET",


                async: false,


                async: true,


                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },


                success: function (data1) {


                    if (data1.count == 1) {


@@ -1562,12 +1899,8 @@


                        }


                        layer.close(ajaxLoad);


                        if (HinterID_S.length > 0) {


                            get_Display_1(HinterID_S);


                            get_Display_2(HinterID_S)


                        }




                        if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {


                            ColFilter();


                            /*get_Display_1(HinterID_S);*/


                            get_Display_2(HinterID_S);


                        }




                    } else {


@@ -1587,7 +1920,7 @@


            $.ajax({


                url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHinterIDList',


                type: "GET",


                async: false,


                async: true,


                data: { "sWhere": HinterID_S.toString(),"num":1 },


                success: function (data1) {


                    if (data1.count == 1) {


@@ -1653,7 +1986,7 @@


            $.ajax({


                url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHinterIDList',


                type: "GET",


                async: false,


                async: true,


                data: { "sWhere": HinterID_S.toString(), "num": 2 },


                success: function (data1) {


                    if (data1.count == 1) {


@@ -1760,7 +2093,22 @@


                , area: ['100%', '100%']


                , title: 'Excel导入'


                , shift: 0//弹出动画


                , content: '../生产计划平台/JIT_DayPlanPlatFormImport.html?OperationType=1'


                , content: '../三升排产/JIT_DayPlanPlatFormImport_SS_Sec.html?OperationType=1'


                , end: function () {


                    //刷新页面,


                    location.reload();


                }


            })


        }


        //Excel完工日期导入


        function btnExcelDateImport() {


            layer.open({


                type: 2


                , skin: 'layui-layer-rim' //加上边框


                , area: ['100%', '100%']


                , title: '交期导入'


                , shift: 0//弹出动画


                , content: '../三升排产/JIT_DayPlanPlatFormImport_SS.html?OperationType=1'


                , end: function () {


                    //刷新页面,


                    location.reload();


@@ -2084,7 +2432,33 @@


                }


            });


        }




        //要料运算


        function get_btnYLYS() {


            sWhere = {


                HProdORGID: $("#HProdORGID").val()


                , HWorkShopID: $("#HWorkShopID").val()


            }


            sWhere = JSON.stringify(sWhere);


            var ajaxLoad = layer.load();


            $.ajax({


                url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/JIT_YLYS',


                type: "GET",


                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },


                success: function (data1) {


                    if (data1.count == 1) {


                        get_FastQuery(2);


                        layer.msg(data1.Message);


                        layer.close(ajaxLoad);


                    } else {


                        layer.close(ajaxLoad);


                        layer.alert(data1.Message, { icon: 5 });


                    }


                }, error: function () {


                    layer.close(ajaxLoad);


                    layer.alert("接口请求失败!", { icon: 5 });


                }


            });


        }


        //提料运算


        function get_btnTLYS() {


            if ($("#HWorkShopID").val() == 0) {


@@ -2258,10 +2632,10 @@






        //准备


        function get_btnReady() {


            var data = table.cache["mainTable"];


        function get_btnReady(data) {


            /*var data = table.cache["mainTable"];*/


            var HTotalDataList = [[]];




            var ajaxData;


            var index = 0;


            var countEveryGroup = 50;


            for (var i = 0; i < data.length; i++) {


@@ -2269,7 +2643,8 @@


                    return layer.msg("请先进行保存!!")


                }


                if (isNaN(data[i]["HSourceID"])) {


                    return layer.msg("选择生产资源!!")


                    data[i]["HSourceID"] = 0


                    /*return layer.msg("选择生产资源!!")*/


                }




                if ((index / countEveryGroup).toFixed(0)*1 == HTotalDataList.length) {


@@ -2289,22 +2664,26 @@




                HICOMNum = HTotalDataList[t];


                $.ajax({


                    url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/ReadyData',


                    url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/ReadyData_SS',


                    async: false,


                    type: "GET",


                    data: { "SWhere": HICOMNum.toString() },


                    success: function (data1) {


                        if (data1.count == 1) {


                            ajaxData = data1.data;


                            for (var i = 0; i < data1.data.length; i++) {


                                for (var j = 0; j < option.data.length; j++) {


                                    if (data1.data[i]["HICMOInterID"] == option.data[j]["HICMOInterID"] && data1.data[i]["HICMOEntryID"] == option.data[j]["HICMOEntryID"]) {


                                        option.data[j]["小时产能"] = data1.data[i]["小时产能"];


                                        option.data[j]["HSourceID"] = data1.data[i]["HSourceID"];


                                        option.data[j]["生产资源"] = data1.data[i]["生产资源"];


                                        option.data[j]["生产周期"] = data1.data[i]["生产周期"];


                                        option.data[j]["开工余量"] = data1.data[i]["开工余量"];


                                        option.data[j]["最迟开工日期"] = data1.data[i]["最迟开工日期"];


                                        option.data[j]["最迟完工日期"] = data1.data[i]["最迟完工日期"];


                                        option.data[j]["订单需求数量"] = data1.data[i]["订单需求数量"];


                                        option.data[j]["订单交货期"] = data1.data[i]["订单交货期"] < "2020-01-01 0:00:00" ? "1900-01-01" : data1.data[i]["订单交货期"];




                                        break;


                                    }


                                }


@@ -2354,10 +2733,10 @@


            }




            table.render(option);


            set_Priority();


            data = table.cache["mainTable"];


            for (var i = 0; i < data.length; i++) {


                if (parseFloat(data[i]["小时产能"]) == 0 || parseFloat(data[i]["小时产能"]) == null || parseFloat(data[i]["小时产能"]) == undefined) {


            /*set_Priority();*/


            /*data = table.cache["mainTable"];*/


            for (var i = 0; i < ajaxData.length; i++) {


                if (parseFloat(ajaxData[i]["小时产能"]) == 0 || parseFloat(ajaxData[i]["小时产能"]) == null || parseFloat(ajaxData[i]["小时产能"]) == undefined) {


                    msg += "第" + (i + 1) + '行，小时产能未设置，请核对数据。' + '</br>' + '1.物料未添加工艺路线' + '</br>' + '2.工艺路线中未设置小时产能' + '</br>' + '3.生产资源未设置单班工时' + '</br>' + '4.生产资源中绑定工作中心与工艺路线中设置的工作中心不一致';


                }


            }


@@ -2470,7 +2849,8 @@


                        HPlanDay = data1.data[0].DayNum;




                    } else {


                        layer.alert(data1.code + data1.Message, { icon: 5 });


                        //layer.alert(data1.code + data1.Message, { icon: 5 });去掉无用提示


                        


                    }


                }, error: function () {


                    layer.alert("接口请求失败!", { icon: 5 });


@@ -2478,7 +2858,7 @@


            });




            //根据车间删除没有锁定的数据


            var sql = "delete from Sc_WorkBillSortBillSub where HMasterDate>=convert(varchar(10) ,DATEADD(DAY," + HPlanDay + ",GETDATE()),20) and HInterID in(select  HInterID from Sc_WorkBillSortBillMain where HWorkShopID=" + HWorkShopID + " and HLockOrder != 1 )";


            var sql = "delete from Sc_WorkBillSortBillSub where HMasterDate>=convert(varchar(10) ,DATEADD(DAY," + HPlanDay + ",GETDATE()),20) and HInterID in(select  HInterID from Sc_WorkBillSortBillMain where HWorkShopID=" + HWorkShopID + " and HLockOrder != 1 ) or HMasterDate < CAST(GETDATE() AS DATE)";


            $.ajax({


                url: GetWEBURL() + '/Gy_SOPBillList/UpDelSQL',


                type: "GET",


@@ -2518,11 +2898,14 @@


                        SDSum += TableData[i][option.cols[0][j].field];


                    }


                }




                //跳过 é”å®šå·¥å•


                if (option.data[i].锁定工单 == "是") {


                    continue;


                }


                //找到本任务单 å¯ç”¨ç”Ÿäº§èµ„源


                lMainID = option.data[i]["HICMOInterID"];


                sICMOBillNo = option.data[i]["生产订单号"];


                dEndDate = Format(option.data[i]["最迟完工日期"], 'yyyy/MM/dd');


                dEndDate = Format(option.data[i]["计划结束日期"], 'yyyy/MM/dd');


                sProdTimes = option.data[i]["生产周期"];


                sPlanQty = option.data[i]["拆单数量"];


                lHGroupID = option.data[i]["HGroupID"];


@@ -2643,8 +3026,10 @@


                                    iRow = i + 1;


                                    //将数据排到网格中


                                    SetInfoToGrid(option, dsSub, null, (iRow - 1), iLeftQty, sWorkQty, false, HPlanDay);




                                    set_AddNew1(option.data[i]);


                                    //若工单被锁定了跳过保存内容


                                    if (option.data[i]["锁定工单"] == "否") {


                                        set_AddNew1(option.data[i]);


                                    }


                                }


                                bFind = true;


                            }


@@ -3244,13 +3629,21 @@


            layer.confirm('你确定要执行优先级操作吗？', {


                btn: ['确定', '取消'] //按钮


                , btn1: function (index, layero) {


                    // 1. èŽ·å–“确定”按钮并添加加载动画


                    var confirmBtn = $(layero).find('.layui-layer-btn0'); // ç¡®å®šæŒ‰é’®


                    confirmBtn.html('<i class="layui-icon layui-icon-loading layui-anim layui-anim-rotate"></i> å¤„理中...');


                    confirmBtn.prop('disabled', true);


                    var data = table.cache["mainTable"];


                    for (var i = 0; i < data.length; i++) {


                        data[i]["优先级"] = ((i + 1) * 5);


                    }


                    option.data = data;


                    table.render(option);


                    layer.close(index);


                    setTimeout(function () {


                        table.reload('mainTable', { data: data });


                        layer.close(index);


                    }, 5); // å»¶è¿Ÿæ‰§è¡Œç¡®ä¿æŒ‰é’®å›¾æ ‡æ¸²æŸ“完


                    


                    


                }


            })


        }


@@ -3260,6 +3653,10 @@


            layer.confirm('你确定要执行排序操作吗？', {


                btn: ['确定', '取消'] //按钮


                , btn1: function (index, layero) {


                    // 1. èŽ·å–“确定”按钮并添加加载动画


                    var confirmBtn = $(layero).find('.layui-layer-btn0'); // ç¡®å®šæŒ‰é’®


                    confirmBtn.html('<i class="layui-icon layui-icon-loading layui-anim layui-anim-rotate"></i> å¤„理中...');


                    confirmBtn.prop('disabled', true);


                    if (option.data.length != 0) {


                        for (var i = 0; i < option.data.length - 1; i++) {


                            for (var j = 0; j < option.data.length - i - 1; j++) {


@@ -3290,12 +3687,16 @@


                                }


                            }


                        }


                        table.render(option);


                        setTimeout(function () {


                            table.reload('mainTable', { data: option.data });


                            layer.close(index);


                        }, 5); // å»¶è¿Ÿæ‰§è¡Œç¡®ä¿æŒ‰é’®å›¾æ ‡æ¸²æŸ“完


                    }


                    else {


                        return layer.msg("无数据!")


                        layer.close(index);


                    }


                    layer.close(index);


                    


                }


            })


            


@@ -3321,10 +3722,14 @@


                        var iframeWindow = window["layui-layer-iframe" + index];//获取弹框页面


                        var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//获取选中的数据




                        if (checkStatus.data.length != 1) {


                        if (checkStatus.data.length == 1) {


                            OptionData[0] = checkStatus.data[0];


                        } else if (checkStatus.data.length == 0) {


                            //等于0时清空生产资源


                            OptionData[0] = { "HItemID": 0, "生产资源名称": "" };


                        } else {


                            return layer.msg("请选择一条数据");


                        }


                        OptionData[0] = checkStatus.data[0];


                        layer.close(index);//关闭弹窗


                    }


                    , end: function () {


@@ -3334,7 +3739,8 @@


                                if (num >= data.length) {


                                    break;


                                }


                                if (option.data[i]["LAY_CHECKED"] == true) {


                                if ($.grep(data, function (item) {


                                    return item.hmainid === option.data[i].hmainid;}).length > 0) {


                                    option.data[i]["HSourceID"] = OptionData[0].HItemID;


                                    option.data[i]["生产资源"] = OptionData[0].生产资源名称;


                                    num += 1;


@@ -3413,7 +3819,7 @@


                    if (parseFloat(table.cache["mainTable"][i]["拆单数量"]) == 0) {


                        return layer.msg("第" + (i + 1) + "行,拆产数量有误,请重新输入!");


                    }


                    if (parseFloat(table.cache["mainTable"][i]["拆单数量"]) - parseFloat(table.cache["mainTable"][i]["拆单汇报数量"]) < parseFloat(table.cache["mainTable"][i]["日计划数量总量"])) { // - å·²æ±‡æŠ¥æ•°é‡


                    if (parseFloat(table.cache["mainTable"][i]["拆单数量"]) > parseFloat(table.cache["mainTable"][i]["计划数量"])) { // - å·²æ±‡æŠ¥æ•°é‡


                        return layer.msg("第" + (i + 1) + "行,排产数量超出订单数量!");


                    }


                    table.cache["mainTable"][i].LAY_TABLE_INDEX = i;


@@ -3852,7 +4258,6 @@


                            , limit: 200


                            , cellMinWidth: 90


                        }


                        table.render(option2);




                        //刷新表格数据


                        DisPlay_HideColumn_ICMO();


@@ -4101,6 +4506,7 @@


            $.ajax({


                url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',


                type: "GET",


                async: false,


                data: { "HModName": HModName + "Main", "user": sessionStorage["HUserName"] },


                success: function (data1) {


                    if (data1.data.length != 0) {


@@ -4171,9 +4577,9 @@


                                option2.cols[0][i + 1]["fixed"] = "left";


                            }


                        }


                        table.render(option2);


                        /*table.render(option2);*/


                    } else {


                        table.render(option2);


                        /*table.render(option2);*/


                    }


                }, error: function () {


                    layer.alert("接口请求失败!", { icon: 5 });


@@ -4280,20 +4686,6 @@


            })


        }




        //列明显示下拉框


        function ColFilter() {


            var Organization = '<option  value="0" selected="selected" ></option>';


            for (var i = 2; i < option.cols[0].length - 1; i++) {


                if (option.cols[0][i].hide != true) {


                    Organization += '<option  style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';


                }


            }


            $("#ColName").empty();


            $("#ColName").append(Organization);$("#ColName1").empty();


            $("#ColName1").append(Organization);$("#ColName2").empty();


            $("#ColName2").append(Organization);


            form.render('select');


        }


        //#endregion


        //以上是layui模块


    });