明细报表时间组件异常问题解决

black-goat-me

2023-05-25 93dca0da863ede36d5d1ccf1ed01f516ed6339fd

 WebTM/views/³µ¼ä¹ÜÀí/±¨±í·ÖÎö/Kf_ProdProcessEntryReport_DyeColor.html

@@ -34,42 +34,72 @@
                                    </div>
                                </div>
                                <!--<div class="layui-inline">
                                    <label class="layui-form-label">状态</label>
                                    <div class="layui-input-block" style="margin-left: 120px;width: 184px;">
                                        <select name="HState" lay-verify="HState" id="HState">
                                            <option value="0" selected="selected">全部</option>
                                            <option value="1">未开工</option>
                                            <option value="3">已入库</option>
                                        </select>
                                    </div>
                                </div>-->
                                <div class="layui-inline">
        <label class="layui-form-label">状态</label>
        <div class="layui-input-block" style="margin-left: 120px;width: 184px;">
            <select name="HState" lay-verify="HState" id="HState">
                <option value="0" selected="selected">全部</option>
                <option value="1">未开工</option>
                <option value="3">已入库</option>
            </select>
        </div>
    </div>-->
                                <div class="layui-form layui-inline" style="position:relative;top:10px;">
                                    <label class="layui-form-label">日期</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input" id="HBeginDate" style="width:190px;">
                                    <div class="layui-form-item  layui-inline">
                                        <div class="layui-inline">
                                            <div class="layui-input-inline">
                                                <input type="text" class="layui-input" id="HBeginDate" placeholder="yyyy-MM-dd HH:mm:ss">
                                            </div>
                                        </div>
                                    </div>
                                    <div class="layui-form-item  layui-inline">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">-</label>
                                            <div class="layui-input-inline">
                                                <input type="text" class="layui-input" id="HEndDate" placeholder="yyyy-MM-dd HH:mm:ss">
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">-</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input" id="HEndDate" style="width:190px;">
                                    </div>
                                </div>
                                <!--<div class="layui-inline">
        <label class="layui-form-label">日期</label>
        <div class="layui-input-block">
            <input type="date" class="layui-input" id="HBeginDate" style="width:190px;">
        </div>
    </div>-->
                                <!--<div class="layui-inline">
        <label class="layui-form-label">-</label>
        <div class="layui-input-block">
            <input type="date" class="layui-input" id="HEndDate" style="width:190px;">
        </div>
    </div>-->
                                <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>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>
                                <div class="layui-inline">
                                    <label class="layui-form-label">合计公斤数</label>
                                    <label class="layui-form-label">白坯发布合计公斤数</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <input type="text" class="layui-input" name="SumHMaterOutQty" id="SumHMaterOutQty" disabled="disabled">
                                    </div>
                                </div>
                                <!--<div class="layui-inline">
                                    <div style="padding-left: 10px;">
                                        <input type="checkbox" name="checkWRuku" id="checkWRuku" lay-skin="primary" lay-filter="checkWRuku" title="未下推及已入库">
                                <div class="layui-inline">
                                    <label class="layui-form-label">染厂出站合计公斤数</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <input type="text" class="layui-input" name="SumDyeColorOut" id="SumDyeColorOut" disabled="disabled">
                                    </div>
                                </div>-->
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">差额</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <input type="text" class="layui-input" name="SumCompare" id="SumCompare" disabled="disabled">
                                    </div>
                                </div>
                                <!--<div class="layui-inline">
        <div style="padding-left: 10px;">
            <input type="checkbox" name="checkWRuku" id="checkWRuku" lay-skin="primary" lay-filter="checkWRuku" title="未下推及已入库">
        </div>
    </div>-->
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin-top:10px;">
                                        <!--其他条件-->
@@ -167,7 +197,7 @@
            //查询条件
            var sWhere = "";
            var option = [];
            var HModName = "MaterOutSumReport_Cloth";
            var HModName = "ProdProcessEntryReport_DyeColor";

            var detailBar = 0;       //用于汇总报表查看明细报表，当为0时显示明细汇总报表对应明细报表。
            //#endregion
@@ -208,8 +238,26 @@
            //初始化界面
            function set_ClearBill() {
                //初始化时间
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 10), "yyyy-MM-dd"));//开始日期
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//结束日期
                var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(8, 0, 0, 0), "yyyy-MM-dd hh");
                var HEndDate = Format(new Date(new Date()).setHours(8, 0, 0, 0), "yyyy-MM-dd hh");
                laydate.render({
                    elem: '#HBeginDate',
                    type: 'datetime',
                    fullPanel: true
                    , format: 'yyyy-MM-dd HH'
                    , value: HBeginDate
                });
                laydate.render({
                    elem: '#HEndDate',
                    type: 'datetime',
                    fullPanel: true
                    , format: 'yyyy-MM-dd HH'
                    , value: HEndDate
                });

                ////初始化时间
                //$("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 10), "yyyy-MM-dd"));//开始日期
                //$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//结束日期
                //初始化表格
                set_InitGrid();
                //加载数据到网格
@@ -220,8 +268,8 @@

            //初始化表格
            function set_InitGrid() {
                var HBeginDate = $("#HBeginDate").val();//下达日期 å¼€å§‹æ—¥æœŸ
                var HEndDate = $("#HEndDate").val();//结束日期
                var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(8, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//下达日期 å¼€å§‹æ—¥æœŸ
                var HEndDate = Format(new Date(new Date()).setHours(8, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//结束日期
                var HMaterNumber = $("#HMaterNumber").val();//物料代码
                var HBillNo = $("#HBillNo").val();          //单据号
                var HProductName = $("#HProductName").val();//产品名称
@@ -379,8 +427,14 @@
                        if (data1.count == 1) {
                            //调整日期格式：显示 å¹´æœˆæ—¥ å’Œ æ—¶
                            for (var i = 0; i < data1.data.length; i++) {
                                data1.data[i].工艺单日期 = data1.data[i]["工艺单日期"].split(":")[0] + ':' + data1.data[i]["工艺单日期"].split(":")[1];
                                data1.data[i].工艺单日期 = data1.data[i]["工艺单日期"].replace("T", " ");
                                if (data1.data[i].染厂出站日期 != null) {
                                    data1.data[i].染厂出站日期 = data1.data[i]["染厂出站日期"].split(":")[0] + ':' + data1.data[i]["染厂出站日期"].split(":")[1];
                                    data1.data[i].染厂出站日期 = data1.data[i]["染厂出站日期"].replace("T", " ");
                                }
                                if (data1.data[i].白坯发布日期 != null) {
                                    data1.data[i].白坯发布日期 = data1.data[i]["白坯发布日期"].split(":")[0] + ':' + data1.data[i]["白坯发布日期"].split(":")[1];
                                    data1.data[i].白坯发布日期 = data1.data[i]["白坯发布日期"].replace("T", " ");
                                }
                            }

                            option.data = data1.data;
@@ -405,6 +459,17 @@
                            }
                            $("#SumHMaterOutQty").val(sumHMaterOutQty);

                            //计算染厂出站合计公斤数
                            var sumDyeColorOut = 0;
                            for (var i = 0; i < data1.data.length; i++) {
                                sumDyeColorOut += data1.data[i]["染厂"];
                            }
                            $("#SumDyeColorOut").val(sumDyeColorOut);

                            //计算差额
                            var sumCompare = sumHMaterOutQty - sumDyeColorOut;
                            $("#SumCompare").val(sumCompare);

                            layer.close(wait);
                        } else {
                            $("#SumHMaterOutQty").val("");
@@ -423,6 +488,18 @@
            function get_FastQuery() {
                var HBeginDate = $("#HBeginDate").val();//下达日期 å¼€å§‹æ—¥æœŸ
                var HEndDate = $("#HEndDate").val();//结束日期

                if (HBeginDate == '') {
                    HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(8, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//下达日期 å¼€å§‹æ—¥æœŸ
                } else {
                    HBeginDate = $("#HBeginDate").val() + ":00:00";//下达日期 å¼€å§‹æ—¥æœŸ
                }
                if (HEndDate == '') {
                    HEndDate = Format(new Date(new Date()).setHours(8, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//结束日期
                } else {
                    HEndDate = $("#HEndDate").val() + ":00:00";//结束日期
                }

                var HMaterNumber = $("#HMaterNumber").val();//物料代码
                var HBillNo = $("#HBillNo").val();          //单据号
                var HProductName = $("#HProductName").val();//产品名称
@@ -483,8 +560,26 @@

            //重置过滤条件
            function set_ClearQuery() {
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//开始日期
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//结束日期
                //初始化时间
                var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(8, 0, 0, 0), "yyyy-MM-dd hh");
                var HEndDate = Format(new Date(new Date()).setHours(8, 0, 0, 0), "yyyy-MM-dd hh");
                laydate.render({
                    elem: '#HBeginDate',
                    type: 'datetime',
                    fullPanel: true
                    , format: 'yyyy-MM-dd HH'
                    , value: HBeginDate
                });
                laydate.render({
                    elem: '#HEndDate',
                    type: 'datetime',
                    fullPanel: true
                    , format: 'yyyy-MM-dd HH'
                    , value: HEndDate
                });

                //$("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//开始日期
                //$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//结束日期
                $("#HMaterNumber").val("");
                $("#HBillNo").val("");
                $("#HProductName").val("");
@@ -501,7 +596,7 @@
            //隐藏列设置
            function get_HideColumn() {
                var colName = "";
                for (var i = 1; i < option.cols[0].length - 1; i++) {
                for (var i = 0; i < option.cols[0].length; i++) {
                    colName += option.cols[0][i]["title"] + ",";
                }