项目管理、车间管理、仓库管理 模块下的全部单据和单据列表； 单据有网格的 增加 合计行

zrg

2024-02-23 33430ec5f8f7bd181bbeea8d933285ef58a7980a

 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>
                                <div class="layui-inline" style="display:none;">
                                    <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" style="display:none;">
                                    <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" style="display:none;">
                                    <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
@@ -201,6 +231,24 @@
                get_FastQuery();
            });

            //行监听事件-单击
            table.on('row(mainTable)', function (obj) {
                var flag = !obj.tr.find(':checkbox:first').prop('checked');
                obj.tr.find(':checkbox').prop('checked', flag);
                if (flag) {
                    obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //设置复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//改变当前tr背景颜色和字体颜色
                } else {
                    obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//取消复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:" });//取消当前tr颜色
                }
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨æ„æ­¤å¤„如果ID不正确将导致你在监听复选框时获取不到你选择的数据，前面的只是添加或删除选中未选中样式以及设置背景色，字体颜色
                layui.each(table.cache.mainTable, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = flag;
                    }
                });
            });
            //#endregion

            //#region æ­¤é¡µé¢æ‰€æœ‰çš„方法
@@ -208,8 +256,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");
                var HEndDate = Format(new Date(new Date()).setHours(8, 0, 0, 0), "yyyy-MM-dd");
                laydate.render({
                    elem: '#HBeginDate',
                    type: 'date',
                    fullPanel: true
                    , format: 'yyyy-MM-dd'
                    , value: HBeginDate
                });
                laydate.render({
                    elem: '#HEndDate',
                    type: 'date',
                    fullPanel: true
                    , format: 'yyyy-MM-dd'
                    , 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 +286,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") + " 00:00:00";//下达日期 å¼€å§‹æ—¥æœŸ
                var HEndDate = Format(new Date(new Date()).setHours(8, 0, 0, 0), "yyyy-MM-dd") + " 00:00:00";//结束日期
                var HMaterNumber = $("#HMaterNumber").val();//物料代码
                var HBillNo = $("#HBillNo").val();          //单据号
                var HProductName = $("#HProductName").val();//产品名称
@@ -273,12 +339,12 @@
                    url: GetWEBURL() + "/ProdProcessEntryReport/ProdProcessEntryReport_DyeColor",
                    type: "GET",
                    async: false,
                    data: { "sWhere": sWhere,"sProcessNo":''},
                    data: { "sWhere": sWhere, "sProcessNo": '', "user": sessionStorage["HUserName"] },
                    //async: false,
                    success: function (data1) {

                        if (data1.count == 1) {

                            var totalArray = ["生产任务单数量", "白坯发布"];
                            var data = [];
                            var col = [];
                            //给空的数组赋值
@@ -286,10 +352,14 @@
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType});
                            }

                            
                            //在列表左边添加勾选框
                            col.push({ type: 'checkbox', fixed: 'left' });
                            for (var i = 0; i < data.length; i++) {
                                if ($.inArray(data[i].name, "") > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else if ($.inArray(data[i].name, totalArray) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 });
                                }
                                else if (data[i].ColName == '白坯发布') {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true });
@@ -333,7 +403,7 @@
                                    , { field: '规格型号', title: '规格型号', width: 160 }
                                    , { field: '业务员', title: '业务员', width: 160 }
                                    , { field: '客户', title: '客户', width: 160 }
                                    , { field: '生产任务单数量', title: '生产任务单数量', width: 200 }
                                    , { field: '生产任务单数量', title: '生产任务单数量', totalRow: true,width: 200 }
                                    , { field: '白坯发布', title: '白坯发布', width: 160, totalRow: true }
                                    , { field: '是否下推生成流转卡', title: '是否下推生成流转卡', width: 160 }
                                ]]
@@ -357,7 +427,7 @@
            //列明显示下拉框
            function ColFilter() {
                var Organization = '<option  value="0" selected="selected" ></option>';
                for (var i = 0; i < option.cols[0].length; i++) {
                for (var i = 1; i < option.cols[0].length; 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>';
                    }
@@ -374,13 +444,22 @@
                $.ajax({
                    url: GetWEBURL() + '/ProdProcessEntryReport/ProdProcessEntryReport_DyeColor',
                    type: "GET",
                    data: { "sWhere": sWhere, "sProcessNo": sProcessNo },
                    data: { "sWhere": sWhere, "sProcessNo": sProcessNo, "user": sessionStorage["HUserName"]  },
                    success: function (data1) {
                        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", " ");
                                }
                                if (data1.data[i].生产订单日期 != null) {
                                    data1.data[i].生产订单日期 = data1.data[i]["生产订单日期"].split("T")[0];
                                }
                            }

                            option.data = data1.data;
@@ -405,6 +484,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 +513,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") + " 00:00:00";//下达日期 å¼€å§‹æ—¥æœŸ
                } else {
                    HBeginDate = $("#HBeginDate").val() + " 00:00:00";//下达日期 å¼€å§‹æ—¥æœŸ
                }
                if (HEndDate == '') {
                    HEndDate = Format(new Date(new Date()).setHours(8, 0, 0, 0), "yyyy-MM-dd") + " 00:00:00";//结束日期
                } else {
                    HEndDate = $("#HEndDate").val() + " 00:00:00";//结束日期
                }

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

                var params = get_UrlVars();
                if (params[params[0]] != null && detailBar==0) {
                if (params[params[0]] != null && detailBar == 0) {
                    //汇总报表的生产订单号
                    HBillNo = params[params[0]];
                    //设置生产订单号标签
                    $("#HBillNo").val(HBillNo);

                    //设置时间为一个很大的值，默认搜索所有时间的明细
                    HBeginDate = "1900-01-01 00:00:00";
                    HEndDate = "2200-01-01 00:00:00";

                    
                    detailBar = 1;
                } else {
                    HBillNo = $("#HBillNo").val();          //单据号
@@ -483,8 +594,43 @@

            //重置过滤条件
            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");
                var HEndDate = Format(new Date(new Date()).setHours(8, 0, 0, 0), "yyyy-MM-dd");
                laydate.render({
                    elem: '#HBeginDate',
                    type: 'date',
                    fullPanel: true
                    , format: 'yyyy-MM-dd'
                    , value: HBeginDate
                });
                laydate.render({
                    elem: '#HEndDate',
                    type: 'date',
                    fullPanel: true
                    , format: 'yyyy-MM-dd'
                    , value: HEndDate
                });
                ////初始化时间
                //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 +647,7 @@
            //隐藏列设置
            function get_HideColumn() {
                var colName = "";
                for (var i = 1; i < option.cols[0].length - 1; i++) {
                for (var i = 1; i < option.cols[0].length; i++) {
                    colName += option.cols[0][i]["title"] + ",";
                }

@@ -540,7 +686,7 @@

                            dataCol = data1.data[0].HGridString.split(',');

                            for (var i = 0; i < option.cols[0].length - 2; i++) {
                            for (var i = 0; i < option.cols[0].length - 1; i++) {
                                if (dataCol[i]) {
                                    var dataCols = dataCol[i].split('|');
                                }