MES-WEB-LayUI.git

parent: f7b58980 | 补丁 | 提交 | ignore whitespace

duhe

2024-07-10 1df38c9e76a48e446e433e1f86f5f0442c53f686

销售排行报表

2个文件已修改

1个文件已添加

	WebTM/Properties/PublishProfiles/JFTM.pubxml.user	9 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/WebTM.csproj	1 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/views/应收管理/报表分析/Xs_SellOutMoneyRangeReport.html	611 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 WebTM/Properties/PublishProfiles/JFTM.pubxml.user

@@ -18,10 +18,10 @@
      <publishTime>01/28/2016 14:22:24</publishTime>
    </File>
    <File Include="bin/WebTM.dll">
      <publishTime>07/10/2024 14:02:42</publishTime>
      <publishTime>07/10/2024 15:01:41</publishTime>
    </File>
    <File Include="bin/WebTM.pdb">
      <publishTime>07/10/2024 14:02:42</publishTime>
      <publishTime>07/10/2024 15:01:41</publishTime>
    </File>
    <File Include="HtmlPage1.html">
      <publishTime>04/11/2023 16:34:42</publishTime>
@@ -1611,7 +1611,7 @@
      <publishTime>12/15/2023 16:23:31</publishTime>
    </File>
    <File Include="views/index_QiaoYi.html">
      <publishTime>07/10/2024 14:06:34</publishTime>
      <publishTime>07/10/2024 14:48:39</publishTime>
    </File>
    <File Include="views/IpadIndex.html">
      <publishTime>07/08/2024 08:51:25</publishTime>
@@ -3698,6 +3698,9 @@
    <File Include="views/åºæ¶ç®¡ç/æ¥è¡¨åæ/Xs_CusBalanceReport_HIsUsingBalanceEntry.html">
      <publishTime>03/26/2024 16:28:56</publishTime>
    </File>
    <File Include="views/åºæ¶ç®¡ç/æ¥è¡¨åæ/Xs_SellOutMoneyRangeReport.html">
      <publishTime>07/10/2024 15:32:58</publishTime>
    </File>
    <File Include="views/åºæ¶ç®¡ç/æ¥è¡¨åæ/YS_ContactBalReport.html">
      <publishTime>03/28/2024 12:19:04</publishTime>
    </File>

 WebTM/WebTM.csproj

@@ -355,6 +355,7 @@
    <Content Include="views\åºç¡èµæ\åºç¡èµæ\Gy_Maintain_Excel.html" />
    <Content Include="views\åºç¡èµæ\åºç¡èµæ\Gy_DotCheck_Excel.html" />
    <Content Include="views\åºç¡èµæ\çäº§åºç¡èµæ\Gy_Process_Excel.html" />
    <Content Include="views\åºæ¶ç®¡ç\æ¥è¡¨åæ\Xs_SellOutMoneyRangeReport.html" />
    <Content Include="views\æ¨¡æ²»å·ç®¡ç\å¨å·æ¥è¡¨\Sc_MouldResumeCheckQuery.html" />
    <Content Include="views\æ¨¡æ²»å·ç®¡ç\å¨å·ç¹æ£è§ç¨å\Sc_MouldDotCheckRuleBillList_PDA.html" />
    <Content Include="views\æ¨¡æ²»å·ç®¡ç\æ¨¡å·å¶ä»å¥åºå\Sc_MouldOtherInBillList_PDA.html" />

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

New file
@@ -0,0 +1,611 @@
ï»¿<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>ä¸è¯åå åææ¥è¡¨</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.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/webConfig.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <script src='../../../layuiadmin/lib/extend/echarts.min.js'></script>
    <style type="text/css">
        input.layui-input.layui-unselect {
            padding-right: 0;
        }
    </style>
</head>
<body>
    <div class="layui-fluid">
        <div class="layui-col-md12">
            <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 class="layui-collapse">
                            <div class="layui-colla-item">
                                <div class="layui-colla-title layui-inline">
                                    <div class="layui-inline">
                                        <span>æ´å¤</span>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;">å¹´</label>
                                    <div class="layui-input-block" style="margin-left: 120px; width: 85px;">
                                        <select name="HYear" id="HYear" lay-verify="HYear">
                                            <!--å¨ææ¸²æå¹´ä»½-->
                                        </select>
                                    </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-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin-top:10px;">
                                        <!--å¶ä»æ¡ä»¶-->
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div>
                            <div style="width:99.5%;height:calc(70vh);margin-top:10px;">
                                <div id="histogram" style="width:65%;height:calc(70vh);float:left">

                                </div>
                                <div id="PieChart" style="width:34%;height:calc(70vh);float:left;margin-left:5px;">

                                </div>
                            </div>
                            <div style="width:99%;height:calc(50vh);">
                                <table class="" id="mainTable" lay-filter="mainTable"></table>
                            </div>
                        </div>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <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>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>éèåè®¾ç½®</button>
                            </div>
                        </script>
                    </form>
                </div>
            </div>
        </div>
    </div>

    <script>

        layui.config({
            base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
        }).extend({
            index: 'lib/index', //ä¸»å¥å£æ¨¡å
        }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () {

            //#region å¬å±åé
            var $ = layui.$
                , admin = layui.admin
                , layer = layui.layer
                , table = layui.table
                , form = layui.form
                , element = layui.element
                , laypage = layui.laypage
                , laydate = layui.laydate
                , util = layui.util
            //æ¥è¯¢æ¡ä»¶
            var sWhere = "";
            var option = [];
            var HModName = "Xs_SellOutMoneyRangeReport";

            var ins;                        //ç¨äºå¯¼åºexcel
            //#endregion

            //#region è¿å¥é¡µé¢æ¢å è½½

            //åå§åçé¢
            set_ClearBill();
            //#endregion

            //#region ãå¾å½¢ã
            function set_Graphics() {
                //#region ãæ±ç¶å¾ã
                var app = {};
                var chartDom = document.getElementById('histogram');
                var myChart = echarts.init(chartDom);
                var option_ZZT;
                //#region [æ±ç¶å¾å¸å±æ ·å¼]
                const posList = [
                    'left',
                    'right',
                    'top',
                    'bottom',
                    'inside',
                    'insideTop',
                    'insideLeft',
                    'insideRight',
                    'insideBottom',
                    'insideTopLeft',
                    'insideTopRight',
                    'insideBottomLeft',
                    'insideBottomRight'
                ];
                app.configParameters = {
                    rotate: {
                        min: -90,
                        max: 90
                    },
                    align: {
                        options: {
                            left: 'left',
                            center: 'center',
                            right: 'right'
                        }
                    },
                    verticalAlign: {
                        options: {
                            top: 'top',
                            middle: 'middle',
                            bottom: 'bottom'
                        }
                    },
                    position: {
                        options: posList.reduce(function (map, pos) {
                            map[pos] = pos;
                            return map;
                        }, {})
                    },
                    distance: {
                        min: 0,
                        max: 100
                    }
                };
                app.config = {
                    rotate: 90,
                    align: 'left',
                    verticalAlign: 'middle',
                    position: 'insideBottom',
                    distance: 15,
                    onChange: function () {
                        const labelOption = {
                            rotate: app.config.rotate,
                            align: app.config.align,
                            verticalAlign: app.config.verticalAlign,
                            position: app.config.position,
                            distance: app.config.distance
                        };
                        myChart.setOption({
                            series: [
                                {
                                    label: labelOption
                                },
                                {
                                    label: labelOption
                                },
                                {
                                    label: labelOption
                                },
                                {
                                    label: labelOption
                                }
                            ]
                        });
                    }
                };
                const labelOption = {
                    show: true,
                    position: 'top'
                };
                //#endregion

                //æ±ç¶å¾ç»å®æ°æ®
                var HCusName = [];//å®¢æ·åç§°
                var HJanuary = []; //ä¸æä»½æ°æ®
                var HFebruary = []; //äºæä»½æ°æ®
                var HMarch = []; //ä¸æä»½æ°æ®
                var HApril = []; //åæä»½æ°æ®
                var HMay = []; //äºæä»½æ°æ®
                var HJune = []; //åæä»½æ°æ®
                var HJuly = []; //ä¸æä»½æ°æ®
                var HAugust = []; //å«æä»½æ°æ®
                var HSeptember = []; //ä¹æä»½æ°æ®
                var HOctober = []; //åæä»½æ°æ®
                var HNovember = []; //åä¸æä»½æ°æ®
                var HDecember = []; //åäºæä»½æ°æ®
                var HAllYear = [];  //å¨å¹´æ°æ®
                var HQty1 = option.data.length;//æ±ç¶å¾æ ¹æ®åè®¡éåºæåºæ¾ç¤ºånæ¡æ°æ®
                for (let i = 0; i < HQty1; i++) {
                    HCusName.push(option.data[i].ä¸å¡å);
                    HJanuary.push(option.data[i]['1æ']);
                    HFebruary.push(option.data[i]['2æ']);
                    HMarch.push(option.data[i]['3æ']);
                    HApril.push(option.data[i]['4æ']);
                    HMay.push(option.data[i]['5æ']);
                    HJune.push(option.data[i]['6æ']);
                    HJuly.push(option.data[i]['7æ']);
                    HAugust.push(option.data[i]['8æ']);
                    HSeptember.push(option.data[i]['9æ']);
                    HOctober.push(option.data[i]['10æ']);
                    HNovember.push(option.data[i]['11æ']);
                    HDecember.push(option.data[i]['12æ']);
                    HAllYear.push(option.data[i]['åè®¡']);
                }
                option_ZZT = {
                    tooltip: {
                        trigger: 'axis',
                        axisPointer: {
                            type: 'shadow'
                        }
                    },
                    legend: {
                        data: ['å¨å¹´éå®é¢åº¦']
                    },
                    toolbox: {
                        show: true,
                        orient: 'vertical',
                        left: 'right',
                        top: 'center',
                        feature: {
                            mark: { show: true },
                            dataView: { show: true, readOnly: false },
                            magicType: { show: true, type: ['line', 'bar', 'stack'] },
                            restore: { show: true },
                            saveAsImage: { show: true }
                        }
                    },
                    xAxis: [
                        {
                            type: 'category',
                            axisTick: { show: true },
                            data: HCusName
                        }
                    ],
                    yAxis: [
                        {
                            type: 'value'
                        }
                    ],
                    series: [
                        {
                            name: 'å¨å¹´éå®é¢åº¦',
                            type: 'bar',
                            barGap: 0,
                            label: labelOption,
                            emphasis: {
                                focus: 'series'
                            },
                            data: HAllYear
                        }
                    ]
                };
                option_ZZT && myChart.setOption(option_ZZT);
                //#endregion

                //#region ãé¥¼å¾ã
                var chartDom = document.getElementById('PieChart');
                var myChart = echarts.init(chartDom);
                var option_BT;
                var HQty2 = option.data.length;//é¥¼ç¶å¾æ ¹æ®åè®¡éåºæåºæ¾ç¤ºånæ¡æ°æ®

                var option_BT_XData = [];
                for (let i = 0; i < HQty2; i++) {
                    option_BT_XData.push({ value: option.data[i][(Number(new Date().getMonth()) + Number(1)) + "æ"], name: option.data[i].ä¸å¡å });
                }

                option_BT = {
                    title: {
                        text: $("#HYear").val() + 'å¹´' + (Number(new Date().getMonth()) + Number(1)) + 'æä»½éå®é¢åå¸å¾',
                        left: 'center'
                    },
                    tooltip: {
                        trigger: 'item'
                    },
                    legend: {
                        top: 'bottom'
                    },
                    series: [
                        {
                            name: 'éå®é¢åº¦',
                            type: 'pie',
                            radius: '50%',
                            data: option_BT_XData,
                            emphasis: {
                                itemStyle: {
                                    shadowBlur: 10,
                                    shadowOffsetX: 0,
                                    shadowColor: 'rgba(0, 0, 0, 0.5)'
                                }
                            }
                        }
                    ]
                };

                option_BT && myChart.setOption(option_BT);
            //#endregion
            }

            //#region ç¹å»äºä»¶åæ¬on formäºä»¶ç
            //å¤´å·¥å·æ äºä»¶
            table.on('toolbar(mainTable)', function (obj) {
                switch (obj.event) {
                    //å¯¼åºexcel
                    case 'get_export':
                        get_Export();
                        break;
                    //éåº
                    case 'btn-exit': Pub_Close(2);
                        break;
                    //éèåè®¾ç½®
                    case 'HideColumn':
                        get_HideColumn();
                        break;
                };
            });
            //éç½®æé®
            form.on('submit(btnReSearch)', function (data) {
                set_ClearQuery();
            });

            //æ¥è¯¢æé®
            form.on('submit(btnSearch)', function (data) {
                get_FastQuery();
            });
            //#endregion

            //#region æ¤é¡µé¢ææçæ¹æ³

            //åå§åçé¢
            function set_ClearBill() {
                Year();
                //åå§åæ¥æ
                //åå§åæ¶é´
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
                //åå§åè¡¨æ ¼
                set_InitGrid();
                //å è½½æ°æ®å°ç½æ ¼
                get_FastQuery();
                //DisPlay_HideColumn();
                set_Graphics();
            }

            //åå§åè¡¨æ ¼
            function set_InitGrid() {
                //option = {
                //    elem: '#mainTable'
                //    , toolbar: '#toolbarDemo'
                //    , cellMinWidth: 120
                //    , limit: Number.MAX_VALUE // æ°æ®è¡¨æ ¼é»è®¤å¨é¨æ¾ç¤º
                //    , height: 'full-70'
                //};
                option = {
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , height: 'full-320'
                    , page: true
                    , totalRow: true
                    , cellMinWidth: 90
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]

                }
            }

            //å¹´
            function Year() {
                var yyyy = new Date().getFullYear();
                var YearOption = "";
                for (var i = 0; i <= 10; i++) {
                    YearOption += '<option  style="color:blue;" value="' + (yyyy - 5 + i) + '">' + (yyyy - 5 + i) + '</option>';
                }
                $("#HYear").append(YearOption);
                $("#HYear").val(yyyy)
                form.render('select');
            }

            //å è½½ç½æ ¼
            function get_Display(sWhere) {
                sWhere = $("#HYear").val();
                var wait = layer.load();//é®ç½©
                $.ajax({
                    url: GetWEBURL() + '/MaterOutEntryReport/Xs_SellOutMoneyRangeReport',
                    type: "GET",
                    async: false,
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        var col = [];
                        if (data1.count == 1) {
                            var data = [];
                            //ç»ç©ºçæ°ç»èµå¼
                            for (var key in data1.list) {
                                data.push({ "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                            }
                            col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'æ±æ»' });
                            //å¤ææ¯å¦æ¯çº¯è±æ
                            var patrn = new RegExp("[\u4E00-\u9FA5]+");
                            for (var i = 0; i < data.length; i++) {
                                if (!patrn.test(data[i].name)) {
                                    col.push({ field: data[i].name, title: data[i].name, hide: true }); //éèå
                                }
                                else {
                                    switch (data[i].Type) {
                                        case 'DateTime':
                                            col.push({ field: data[i].name, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 120 });
                                            break;
                                        default:
                                            col.push({ field: data[i].name, title: data[i].name, align: 'center', sort: true, totalRow: true , width: 120 });
                                    }
                                }
                            }

                            option.cols = [col];
                            option.data = data1.data;

                            ins = table.render(option);
                            layer.close(wait);
                        } else {
                            layer.close(wait);
                            layer.alert(data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(wait);
                        layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
                    }
                });
            }

            //å¿«éè¿æ»¤
            function get_FastQuery() {
                var HBeginDate = $("#HBeginDate").val();
                var HEndDate = $("#HEndDate").val();

                sWhere = "'" + HBeginDate + "','" + HEndDate + "'";

                get_Display(sWhere);
                //è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
                sWhere = "";
                set_Graphics();
            }

            //#region å¯¼åºExecel
            function get_Export() {
                var ModRightNameCheck = "Xs_SellOutMoneyRangeReport_ExportExcel";

                //é»è¾å®¡æ ¸æ¹æ³
                $.ajax({
                    type: "GET",
                    url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å
                    data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
                    success: function (result) {
                        if (result.count == 1) {
                            table.exportFile(ins.config.id, option.data, "xls");
                        } else {
                            layer.alert("å½åæ¨¡åæ²¡æå¯¼åºæé!", { icon: 5 });
                        }
                    }, error: function () {
                        layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
                    }
                });
            }
            //#endregion

            //éç½®è¿æ»¤æ¡ä»¶
            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"));
                sWhere = " ";
                get_FastQuery();
            }

            //éèåè®¾ç½®
            function get_HideColumn() {
                var colName = "";
                for (var i = 1; i < option.cols[0].length - 1; i++) {
                    colName += option.cols[0][i]["title"] + ",";
                }

                colName = encodeURI(colName.substring(0, colName.length - 1));//å¯¹ URI è¿è¡ç¼ç 
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //å ä¸è¾¹æ¡
                    , title: "éèåè®¾ç½®"  //æ é¢
                    , closeBtn: 1  //çªä½å³ä¸è§å³é ç æ ·å¼
                    , shift: 2 //å¼¹åºå¨ç»
                    , area: ["50%", "90%"] //çªä½å¤§å°
                    , maxmin: true //è®¾ç½®æå¤§æå°æé®æ¯å¦æ¾ç¤º
                    , content: ['../../åºç¡èµæ/éèåè®¾ç½®/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "yes"]
                    , btn: ["ç¡®å®", "åæ¶"]
                    , btn1: function (index, laero) {
                        //å·æ°è¡¨æ ¼æ°æ®
                        DisPlay_HideColumn();
                        //æ´æ°è¡¨æ ¼ç¼åçæ°æ®
                        layer.close(index);//å³éå¼¹çª
                    }
                })
            }

            //æ¾ç¤ºåæ°æ®
            function DisPlay_HideColumn() {
                $.ajax({
                    url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                    type: "GET",
                    data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.data.length != 0) {

                            var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ®
                            var titleData = [];//ä¸éè¦æ¾ç¤ºçåæ®µ å¯æ©å±

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

                            for (var i = 0; i < option.cols[0].length - 2; i++) {
                                var dataCols = dataCol[i].split('|');
                                //éèå
                                if (dataCols[1] == 1) {
                                    option.cols[0][i + 1]["hide"] = true;
                                }
                                //è®¾ç½®åå®¹åä½å¤§å°
                                if (data1.data[0].HFontSize != 0) {
                                    option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                                } else {
                                    option.cols[0][i + 1]["style"] = "font-size:100%";
                                }
                                //è®¾ç½®åå®½
                                if (dataCols[3] > 0) {
                                    option.cols[0][i + 1]["width"] = dataCols[3];
                                }
                                //æ¾ç¤ºå
                                if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
                                    option.cols[0][i + 1]["hide"] = false;
                                }
                                //åä½æå¨ä½ç½®(å·¦ å±ä¸ å³)
                                switch (dataCols[2]) {
                                    case "L":
                                        option.cols[0][i + 1]["align"] = "left";
                                        break;
                                    case "M":
                                        option.cols[0][i + 1]["align"] = "center";
                                        break;
                                    case "R":
                                        option.cols[0][i + 1]["align"] = "right";
                                        break;
                                }
                            }

                            //åæ¶å»ç»å
                            for (var i = 1; i < option.cols[0].length - 1; i++) {
                                if (option.cols[0][i]["fixed"] != null) {
                                    option.cols[0][i]["fixed"] = null;
                                }
                                else {
                                    break;
                                }
                            }
                            //å»ç»å
                            if (data1.data[0].HFixCols != 0) {
                                for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                    if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
                                        data1.data[0].HFixCols += 1;
                                    }
                                    option.cols[0][i + 1]["fixed"] = "left";
                                }
                            }
                            table.render(option);
                        } else {
                            table.render(option);
                        }
                    }, error: function () {
                        layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
                    }
                })
            }

            //#endregion
        });
    </script>
</body>
</html>

			@@ -18,10 +18,10 @@
			<publishTime>01/28/2016 14:22:24</publishTime>
			</File>
			<File Include="bin/WebTM.dll">
			<publishTime>07/10/2024 14:02:42</publishTime>
			<publishTime>07/10/2024 15:01:41</publishTime>
			</File>
			<File Include="bin/WebTM.pdb">
			<publishTime>07/10/2024 14:02:42</publishTime>
			<publishTime>07/10/2024 15:01:41</publishTime>
			</File>
			<File Include="HtmlPage1.html">
			<publishTime>04/11/2023 16:34:42</publishTime>
			@@ -1611,7 +1611,7 @@
			<publishTime>12/15/2023 16:23:31</publishTime>
			</File>
			<File Include="views/index_QiaoYi.html">
			<publishTime>07/10/2024 14:06:34</publishTime>
			<publishTime>07/10/2024 14:48:39</publishTime>
			</File>
			<File Include="views/IpadIndex.html">
			<publishTime>07/08/2024 08:51:25</publishTime>
			@@ -3698,6 +3698,9 @@
			<File Include="views/åºæ¶ç®¡ç/æ¥è¡¨åæ/Xs_CusBalanceReport_HIsUsingBalanceEntry.html">
			<publishTime>03/26/2024 16:28:56</publishTime>
			</File>
			<File Include="views/åºæ¶ç®¡ç/æ¥è¡¨åæ/Xs_SellOutMoneyRangeReport.html">
			<publishTime>07/10/2024 15:32:58</publishTime>
			</File>
			<File Include="views/åºæ¶ç®¡ç/æ¥è¡¨åæ/YS_ContactBalReport.html">
			<publishTime>03/28/2024 12:19:04</publishTime>
			</File>

			@@ -355,6 +355,7 @@
			<Content Include="views\åºç¡èµæ\åºç¡èµæ\Gy_Maintain_Excel.html" />
			<Content Include="views\åºç¡èµæ\åºç¡èµæ\Gy_DotCheck_Excel.html" />
			<Content Include="views\åºç¡èµæ\çäº§åºç¡èµæ\Gy_Process_Excel.html" />
			<Content Include="views\åºæ¶ç®¡ç\æ¥è¡¨åæ\Xs_SellOutMoneyRangeReport.html" />
			<Content Include="views\æ¨¡æ²»å·ç®¡ç\å¨å·æ¥è¡¨\Sc_MouldResumeCheckQuery.html" />
			<Content Include="views\æ¨¡æ²»å·ç®¡ç\å¨å·ç¹æ£è§ç¨å\Sc_MouldDotCheckRuleBillList_PDA.html" />
			<Content Include="views\æ¨¡æ²»å·ç®¡ç\æ¨¡å·å¶ä»å¥åºå\Sc_MouldOtherInBillList_PDA.html" />

New file
			@@ -0,0 +1,611 @@
			ï»¿<!DOCTYPE html>
			<html>
			<head>
			<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
			<title>ä¸è¯åå åææ¥è¡¨</title>
			<meta name="renderer" content="webkit">
			<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
			<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
			<link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
			<link rel="stylesheet" href="../../../layuiadmin/style/admin.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/webConfig.js"></script>
			<script src="../../../layuiadmin/PubCustom.js"></script>
			<script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
			<script src='../../../layuiadmin/lib/extend/echarts.min.js'></script>
			<style type="text/css">
			input.layui-input.layui-unselect {
			padding-right: 0;
			}
			</style>
			</head>
			<body>
			<div class="layui-fluid">
			<div class="layui-col-md12">
			<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 class="layui-collapse">
			<div class="layui-colla-item">
			<div class="layui-colla-title layui-inline">
			<div class="layui-inline">
			<span>æ´å¤</span>
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 85px;">å¹´</label>
			<div class="layui-input-block" style="margin-left: 120px; width: 85px;">
			<select name="HYear" id="HYear" lay-verify="HYear">
			<!--å¨ææ¸²æå¹´ä»½-->
			</select>
			</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-colla-content" style="padding: 0px; margin-left: 6%;">
			<div class="layui-row" style="margin-top:10px;">
			<!--å¶ä»æ¡ä»¶-->
			</div>
			</div>
			</div>
			</div>
			<div>
			<div style="width:99.5%;height:calc(70vh);margin-top:10px;">
			<div id="histogram" style="width:65%;height:calc(70vh);float:left">

			</div>
			<div id="PieChart" style="width:34%;height:calc(70vh);float:left;margin-left:5px;">

			</div>
			</div>
			<div style="width:99%;height:calc(50vh);">
			<table class="" id="mainTable" lay-filter="mainTable"></table>
			</div>
			</div>
			<script type="text/html" id="toolbarDemo">
			<div class="layui-btn-container">
			<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>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>éèåè®¾ç½®</button>
			</div>
			</script>
			</form>
			</div>
			</div>
			</div>
			</div>

			<script>

			layui.config({
			base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
			}).extend({
			index: 'lib/index', //ä¸»å¥å£æ¨¡å
			}).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () {

			//#region å¬å±åé
			var $ = layui.$
			, admin = layui.admin
			, layer = layui.layer
			, table = layui.table
			, form = layui.form
			, element = layui.element
			, laypage = layui.laypage
			, laydate = layui.laydate
			, util = layui.util
			//æ¥è¯¢æ¡ä»¶
			var sWhere = "";
			var option = [];
			var HModName = "Xs_SellOutMoneyRangeReport";

			var ins; //ç¨äºå¯¼åºexcel
			//#endregion

			//#region è¿å¥é¡µé¢æ¢å è½½

			//åå§åçé¢
			set_ClearBill();
			//#endregion

			//#region ãå¾å½¢ã
			function set_Graphics() {
			//#region ãæ±ç¶å¾ã
			var app = {};
			var chartDom = document.getElementById('histogram');
			var myChart = echarts.init(chartDom);
			var option_ZZT;
			//#region [æ±ç¶å¾å¸å±æ ·å¼]
			const posList = [
			'left',
			'right',
			'top',
			'bottom',
			'inside',
			'insideTop',
			'insideLeft',
			'insideRight',
			'insideBottom',
			'insideTopLeft',
			'insideTopRight',
			'insideBottomLeft',
			'insideBottomRight'
			];
			app.configParameters = {
			rotate: {
			min: -90,
			max: 90
			},
			align: {
			options: {
			left: 'left',
			center: 'center',
			right: 'right'
			}
			},
			verticalAlign: {
			options: {
			top: 'top',
			middle: 'middle',
			bottom: 'bottom'
			}
			},
			position: {
			options: posList.reduce(function (map, pos) {
			map[pos] = pos;
			return map;
			}, {})
			},
			distance: {
			min: 0,
			max: 100
			}
			};
			app.config = {
			rotate: 90,
			align: 'left',
			verticalAlign: 'middle',
			position: 'insideBottom',
			distance: 15,
			onChange: function () {
			const labelOption = {
			rotate: app.config.rotate,
			align: app.config.align,
			verticalAlign: app.config.verticalAlign,
			position: app.config.position,
			distance: app.config.distance
			};
			myChart.setOption({
			series: [
			{
			label: labelOption
			},
			{
			label: labelOption
			},
			{
			label: labelOption
			},
			{
			label: labelOption
			}
			]
			});
			}
			};
			const labelOption = {
			show: true,
			position: 'top'
			};
			//#endregion

			//æ±ç¶å¾ç»å®æ°æ®
			var HCusName = [];//å®¢æ·åç§°
			var HJanuary = []; //ä¸æä»½æ°æ®
			var HFebruary = []; //äºæä»½æ°æ®
			var HMarch = []; //ä¸æä»½æ°æ®
			var HApril = []; //åæä»½æ°æ®
			var HMay = []; //äºæä»½æ°æ®
			var HJune = []; //åæä»½æ°æ®
			var HJuly = []; //ä¸æä»½æ°æ®
			var HAugust = []; //å«æä»½æ°æ®
			var HSeptember = []; //ä¹æä»½æ°æ®
			var HOctober = []; //åæä»½æ°æ®
			var HNovember = []; //åä¸æä»½æ°æ®
			var HDecember = []; //åäºæä»½æ°æ®
			var HAllYear = []; //å¨å¹´æ°æ®
			var HQty1 = option.data.length;//æ±ç¶å¾æ ¹æ®åè®¡éåºæåºæ¾ç¤ºånæ¡æ°æ®
			for (let i = 0; i < HQty1; i++) {
			HCusName.push(option.data[i].ä¸å¡å);
			HJanuary.push(option.data[i]['1æ']);
			HFebruary.push(option.data[i]['2æ']);
			HMarch.push(option.data[i]['3æ']);
			HApril.push(option.data[i]['4æ']);
			HMay.push(option.data[i]['5æ']);
			HJune.push(option.data[i]['6æ']);
			HJuly.push(option.data[i]['7æ']);
			HAugust.push(option.data[i]['8æ']);
			HSeptember.push(option.data[i]['9æ']);
			HOctober.push(option.data[i]['10æ']);
			HNovember.push(option.data[i]['11æ']);
			HDecember.push(option.data[i]['12æ']);
			HAllYear.push(option.data[i]['åè®¡']);
			}
			option_ZZT = {
			tooltip: {
			trigger: 'axis',
			axisPointer: {
			type: 'shadow'
			}
			},
			legend: {
			data: ['å¨å¹´éå®é¢åº¦']
			},
			toolbox: {
			show: true,
			orient: 'vertical',
			left: 'right',
			top: 'center',
			feature: {
			mark: { show: true },
			dataView: { show: true, readOnly: false },
			magicType: { show: true, type: ['line', 'bar', 'stack'] },
			restore: { show: true },
			saveAsImage: { show: true }
			}
			},
			xAxis: [
			{
			type: 'category',
			axisTick: { show: true },
			data: HCusName
			}
			],
			yAxis: [
			{
			type: 'value'
			}
			],
			series: [
			{
			name: 'å¨å¹´éå®é¢åº¦',
			type: 'bar',
			barGap: 0,
			label: labelOption,
			emphasis: {
			focus: 'series'
			},
			data: HAllYear
			}
			]
			};
			option_ZZT && myChart.setOption(option_ZZT);
			//#endregion

			//#region ãé¥¼å¾ã
			var chartDom = document.getElementById('PieChart');
			var myChart = echarts.init(chartDom);
			var option_BT;
			var HQty2 = option.data.length;//é¥¼ç¶å¾æ ¹æ®åè®¡éåºæåºæ¾ç¤ºånæ¡æ°æ®

			var option_BT_XData = [];
			for (let i = 0; i < HQty2; i++) {
			option_BT_XData.push({ value: option.data[i][(Number(new Date().getMonth()) + Number(1)) + "æ"], name: option.data[i].ä¸å¡å });
			}

			option_BT = {
			title: {
			text: $("#HYear").val() + 'å¹´' + (Number(new Date().getMonth()) + Number(1)) + 'æä»½éå®é¢åå¸å¾',
			left: 'center'
			},
			tooltip: {
			trigger: 'item'
			},
			legend: {
			top: 'bottom'
			},
			series: [
			{
			name: 'éå®é¢åº¦',
			type: 'pie',
			radius: '50%',
			data: option_BT_XData,
			emphasis: {
			itemStyle: {
			shadowBlur: 10,
			shadowOffsetX: 0,
			shadowColor: 'rgba(0, 0, 0, 0.5)'
			}
			}
			}
			]
			};

			option_BT && myChart.setOption(option_BT);
			//#endregion
			}

			//#region ç¹å»äºä»¶åæ¬on formäºä»¶ç
			//å¤´å·¥å·æ äºä»¶
			table.on('toolbar(mainTable)', function (obj) {
			switch (obj.event) {
			//å¯¼åºexcel
			case 'get_export':
			get_Export();
			break;
			//éåº
			case 'btn-exit': Pub_Close(2);
			break;
			//éèåè®¾ç½®
			case 'HideColumn':
			get_HideColumn();
			break;
			};
			});
			//éç½®æé®
			form.on('submit(btnReSearch)', function (data) {
			set_ClearQuery();
			});

			//æ¥è¯¢æé®
			form.on('submit(btnSearch)', function (data) {
			get_FastQuery();
			});
			//#endregion

			//#region æ¤é¡µé¢ææçæ¹æ³

			//åå§åçé¢
			function set_ClearBill() {
			Year();
			//åå§åæ¥æ
			//åå§åæ¶é´
			$("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
			$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
			//åå§åè¡¨æ ¼
			set_InitGrid();
			//å è½½æ°æ®å°ç½æ ¼
			get_FastQuery();
			//DisPlay_HideColumn();
			set_Graphics();
			}

			//åå§åè¡¨æ ¼
			function set_InitGrid() {
			//option = {
			// elem: '#mainTable'
			// , toolbar: '#toolbarDemo'
			// , cellMinWidth: 120
			// , limit: Number.MAX_VALUE // æ°æ®è¡¨æ ¼é»è®¤å¨é¨æ¾ç¤º
			// , height: 'full-70'
			//};
			option = {
			elem: '#mainTable'
			, toolbar: '#toolbarDemo'
			, height: 'full-320'
			, page: true
			, totalRow: true
			, cellMinWidth: 90
			, limit: 50
			, limits: [50, 500, 5000, 20000]

			}
			}

			//å¹´
			function Year() {
			var yyyy = new Date().getFullYear();
			var YearOption = "";
			for (var i = 0; i <= 10; i++) {
			YearOption += '<option style="color:blue;" value="' + (yyyy - 5 + i) + '">' + (yyyy - 5 + i) + '</option>';
			}
			$("#HYear").append(YearOption);
			$("#HYear").val(yyyy)
			form.render('select');
			}

			//å è½½ç½æ ¼
			function get_Display(sWhere) {
			sWhere = $("#HYear").val();
			var wait = layer.load();//é®ç½©
			$.ajax({
			url: GetWEBURL() + '/MaterOutEntryReport/Xs_SellOutMoneyRangeReport',
			type: "GET",
			async: false,
			data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
			success: function (data1) {
			var col = [];
			if (data1.count == 1) {
			var data = [];
			//ç»ç©ºçæ°ç»èµå¼
			for (var key in data1.list) {
			data.push({ "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
			}
			col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'æ±æ»' });
			//å¤ææ¯å¦æ¯çº¯è±æ
			var patrn = new RegExp("[\u4E00-\u9FA5]+");
			for (var i = 0; i < data.length; i++) {
			if (!patrn.test(data[i].name)) {
			col.push({ field: data[i].name, title: data[i].name, hide: true }); //éèå
			}
			else {
			switch (data[i].Type) {
			case 'DateTime':
			col.push({ field: data[i].name, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 120 });
			break;
			default:
			col.push({ field: data[i].name, title: data[i].name, align: 'center', sort: true, totalRow: true , width: 120 });
			}
			}
			}

			option.cols = [col];
			option.data = data1.data;

			ins = table.render(option);
			layer.close(wait);
			} else {
			layer.close(wait);
			layer.alert(data1.Message, { icon: 5 });
			}
			}, error: function () {
			layer.close(wait);
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}

			//å¿«éè¿æ»¤
			function get_FastQuery() {
			var HBeginDate = $("#HBeginDate").val();
			var HEndDate = $("#HEndDate").val();

			sWhere = "'" + HBeginDate + "','" + HEndDate + "'";

			get_Display(sWhere);
			//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			sWhere = "";
			set_Graphics();
			}

			//#region å¯¼åºExecel
			function get_Export() {
			var ModRightNameCheck = "Xs_SellOutMoneyRangeReport_ExportExcel";

			//é»è¾å®¡æ ¸æ¹æ³
			$.ajax({
			type: "GET",
			url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å
			data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
			success: function (result) {
			if (result.count == 1) {
			table.exportFile(ins.config.id, option.data, "xls");
			} else {
			layer.alert("å½åæ¨¡åæ²¡æå¯¼åºæé!", { icon: 5 });
			}
			}, error: function () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}
			//#endregion

			//éç½®è¿æ»¤æ¡ä»¶
			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"));
			sWhere = " ";
			get_FastQuery();
			}

			//éèåè®¾ç½®
			function get_HideColumn() {
			var colName = "";
			for (var i = 1; i < option.cols[0].length - 1; i++) {
			colName += option.cols[0][i]["title"] + ",";
			}

			colName = encodeURI(colName.substring(0, colName.length - 1));//å¯¹ URI è¿è¡ç¼ç
			layer.open({
			type: 2
			, skin: "layui-layer-rim" //å ä¸è¾¹æ¡
			, title: "éèåè®¾ç½®" //æ é¢
			, closeBtn: 1 //çªä½å³ä¸è§å³é ç æ ·å¼
			, shift: 2 //å¼¹åºå¨ç»
			, area: ["50%", "90%"] //çªä½å¤§å°
			, maxmin: true //è®¾ç½®æå¤§æå°æé®æ¯å¦æ¾ç¤º
			, content: ['../../åºç¡èµæ/éèåè®¾ç½®/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "yes"]
			, btn: ["ç¡®å®", "åæ¶"]
			, btn1: function (index, laero) {
			//å·æ°è¡¨æ ¼æ°æ®
			DisPlay_HideColumn();
			//æ´æ°è¡¨æ ¼ç¼åçæ°æ®
			layer.close(index);//å³éå¼¹çª
			}
			})
			}

			//æ¾ç¤ºåæ°æ®
			function DisPlay_HideColumn() {
			$.ajax({
			url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
			type: "GET",
			data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
			success: function (data1) {
			if (data1.data.length != 0) {

			var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ®
			var titleData = [];//ä¸éè¦æ¾ç¤ºçåæ®µ å¯æ©å±

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

			for (var i = 0; i < option.cols[0].length - 2; i++) {
			var dataCols = dataCol[i].split('\|');
			//éèå
			if (dataCols[1] == 1) {
			option.cols[0][i + 1]["hide"] = true;
			}
			//è®¾ç½®åå®¹åä½å¤§å°
			if (data1.data[0].HFontSize != 0) {
			option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
			} else {
			option.cols[0][i + 1]["style"] = "font-size:100%";
			}
			//è®¾ç½®åå®½
			if (dataCols[3] > 0) {
			option.cols[0][i + 1]["width"] = dataCols[3];
			}
			//æ¾ç¤ºå
			if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
			option.cols[0][i + 1]["hide"] = false;
			}
			//åä½æå¨ä½ç½®(å·¦ å±ä¸ å³)
			switch (dataCols[2]) {
			case "L":
			option.cols[0][i + 1]["align"] = "left";
			break;
			case "M":
			option.cols[0][i + 1]["align"] = "center";
			break;
			case "R":
			option.cols[0][i + 1]["align"] = "right";
			break;
			}
			}

			//åæ¶å»ç»å
			for (var i = 1; i < option.cols[0].length - 1; i++) {
			if (option.cols[0][i]["fixed"] != null) {
			option.cols[0][i]["fixed"] = null;
			}
			else {
			break;
			}
			}
			//å»ç»å
			if (data1.data[0].HFixCols != 0) {
			for (var i = 0; i < data1.data[0].HFixCols; i++) {
			if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
			data1.data[0].HFixCols += 1;
			}
			option.cols[0][i + 1]["fixed"] = "left";
			}
			}
			table.render(option);
			} else {
			table.render(option);
			}
			}, error: function () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			})
			}

			//#endregion
			});
			</script>
			</body>
			</html>