乔一：客户手工抄包报表，分为根据单据汇总、查看抄包明细 两个报表

duhe

2025-09-03 3e6afd4ea4b6ad3afc9313377e35633776fe15e6

 WebTM/views/Ó¦ÊÕ¹ÜÀí/±¨±í·ÖÎö/Xs_CusShouGongChaoBaoReport.html

@@ -29,16 +29,16 @@
                                        <span>更多</span>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">开始日期</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input ForFilteringSchemes" id="HDate" style="width:190px;">
                                <div class="layui-form layui-inline" style="width:200px;">
                                    <label class="layui-form-label" style="width:35px;">日期</label>
                                    <div class="layui-input-block" style="position:relative; left:-45px;">
                                        <input type="text" class="layui-input ForFilteringSchemes" id="HDate" placeholder="yyyy-MM-dd HH:mm:ss" style="width:140px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">结束日期</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input ForFilteringSchemes" id="HDate1" style="width:190px;">
                                <div class="layui-inline" style="width:200px;">
                                    <label class="layui-form-label" style="width:5px;">-</label>
                                    <div class="layui-input-block" style="position:relative; left:-70px;">
                                        <input type="text" class="layui-input ForFilteringSchemes" id="HDate1" placeholder="yyyy-MM-dd HH:mm:ss" style="width:140px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
@@ -304,9 +304,23 @@

            //#region åˆå§‹åŒ–界面
            function set_ClearBill() {
                //根据日期间隔设置开始时间与结束时间
                $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 7), "yyyy-MM-dd"));
                $("#HDate1").val(Format(new Date(), "yyyy-MM-dd"));
                //初始化时间
                var HDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh");
                var HDate1 = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh");
                laydate.render({
                    elem: '#HDate',
                    type: 'datetime',
                    fullPanel: true
                    , format: 'yyyy-MM-dd HH'
                    , value: HDate
                });
                laydate.render({
                    elem: '#HDate1',
                    type: 'datetime',
                    fullPanel: true
                    , format: 'yyyy-MM-dd HH'
                    , value: HDate1
                });

                //初始化表格
                set_InitGrid();
@@ -409,8 +423,18 @@

            //#region å¿«é€Ÿè¿‡æ»¤
            function get_FastQuery(number) {
                var HDate = $("#HDate").val();//开始日期
                var HDate1 = $("#HDate1").val();//结束日期
                var HDate = $("#HDate").val();      //开始日期
                var HDate1 = $("#HDate1").val();    //结束日期
                if (HDate == '') {
                    HDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//下达日期 å¼€å§‹æ—¥æœŸ
                } else {
                    HDate = $("#HDate").val() + ":00:00";                                                                           //下达日期 å¼€å§‹æ—¥æœŸ
                }
                if (HDate1 == '') {
                    HDate1 = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";                         //结束日期
                } else {
                    HDate1 = $("#HDate1").val() + ":00:00";                                                                         //结束日期
                }

                var HCusName = $("#HCusName").val();
                var HMaterNumber = $("#HMaterNumber").val();
@@ -513,7 +537,7 @@
                //根据用户过滤用户关联客户的记录
                sWhere += getSWhereByHUser();

                var sql = "select * from h_v_Xs_CusShouGongChaoBaoReport where 1=1 " + sWhere + " order by æ—¥æœŸ desc,HCusID,HMaterID";
                var sql = "select * from h_v_Xs_CusShouGongChaoBaoReport where 1=1 " + sWhere + " order by å®¡æ ¸æ—¥æœŸ desc,HCusID,HMaterID";

                get_Display(sql);
                sWhere = "";//调用接口后清空sWhere缓存
@@ -522,9 +546,23 @@

            //#region é‡ç½®è¿‡æ»¤æ¡ä»¶æ–¹æ³•
            function set_ClearQuery() {
                //根据日期间隔设置开始时间与结束时间
                $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 7), "yyyy-MM-dd"));
                $("#HDate1").val(Format(new Date(), "yyyy-MM-dd"));
                //初始化时间
                var HDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(8, 0, 0, 0), "yyyy-MM-dd hh");
                var HDate1 = Format(new Date(new Date()).setHours(8, 0, 0, 0), "yyyy-MM-dd hh");
                laydate.render({
                    elem: '#HDate',
                    type: 'datetime',
                    fullPanel: true
                    , format: 'yyyy-MM-dd HH'
                    , value: HDate
                });
                laydate.render({
                    elem: '#HDate1',
                    type: 'datetime',
                    fullPanel: true
                    , format: 'yyyy-MM-dd HH'
                    , value: HDate1
                });
                $("#HCusName").val("");//
                $("#HMatrNumber").val("");
                $("#HMaterName").val("");