erp/Web/ECharts/OldCustomer.aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/ErpView.master" AutoEventWireup="true" CodeFile="OldCustomer.aspx.cs" Inherits="ECharts_OldCustomer" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
    <script type="text/javascript" >
        //查询按钮
        function searchFn() {
            var form = new mini.Form("#ctl00_f_all");
            var data = form.getData(true, false);
            var s = data;
            if (s.assigndate1 == "" || s.assigndate2 == "") {
                s.assigndate1 = getCurDate();
                s.assigndate2 = getCurDate();
            }
            grid.load({
                org: s.customerorg, date1: s.date1, date2: s.date2
            });
        }

        function onSearchCheckedChanged(e) {
            var btn = e.sender;
            var checked = btn.getChecked();
            var text = btn.getText();
            var form = new mini.Form("#ctl00_f_all");
            var data = form.getData(true, false);
            var s = data;

            if (checked) {
                var stime = "";
                var etime = "";
                var timearr = [];
                if (text == "本日") {
                    var day = getCurDate();
                    timearr.push(day);
                    timearr.push(day);
                }
                else if (text == "本周") {
                    timearr = getWeekStartAndEnd();
                }
                else if (text == "本月") {
                    timearr = getMonthStartAndEnd();
                }
                stime = timearr[0];
                etime = timearr[1];
                console.log(text, stime, etime)
                grid.load({
                    shopname: s.shop, designer: s.design, order_area: s.order_area, org: s.designerorg, date1: stime, date2: etime, UpDate1: s.UpDate1, UpDate2: s.UpDate2
                });
            }

            mini.get("aSearchMonth").setChecked(false);
            mini.get("aSearchDay").setChecked(false);
            mini.get("aSearchWeek").setChecked(false);
        }

        //查询本日
        function onSearchToday() {
            var form = new mini.Form("#ctl00_f_all");
            var data = form.getData(true, false);
            var s = data;
            var DateType = "Today";
            grid.load({
                shopname: s.shop, designer: s.designer, order_area: s.order_area, org: s.designerorg, dateType: DateType
            });
        }
        //查询本周
        function onSearchThisWeek() {
            var form = new mini.Form("#ctl00_f_all");
            var data = form.getData(true, false);
            var s = data;
            var DateType = "Week";
            grid.load({
                shopname: s.shop, designer: s.designer, order_area: s.order_area, org: s.designerorg, dateType: DateType
            });
        }
        //查询本月
        function onSearchThisMonth() {
            var form = new mini.Form("#ctl00_f_all");
            var data = form.getData(true, false);
            var s = data;
            var DateType = "Month";
            grid.load({
                shopname: s.shop, designer: s.designer, order_area: s.order_area, org: s.designerorg, dateType: DateType
            });
        }

        //清除查询内容
        function clearFn() {
            //$("#ctl00_f_all").find("input").val("");
            var form = new mini.Form("#ctl00_f_all");
            form.clear();

            mini.get("aSearchMonth").setChecked(false);
            mini.get("aSearchDay").setChecked(false);
            mini.get("aSearchWeek").setChecked(false);
        }
        function onDrawSummaryCell(e) {
            var result = e.result;
            var rdata = result.data;
            //console.log("result:", result);
            var totalPayment = 0;
            var allOrder = 0;
            var wait = 0;
            var designing = 0;
            var finish = 0;
            var rateAp = 0;
            var payPrice = 0;
            for (var item of rdata) {
                totalPayment += parseFloat(item.Amount);
                allOrder += parseInt(item.AllOrder);
                wait += parseInt(item.WaitDesign);
                designing += parseInt(item.Designing);
                finish += parseInt(item.DesignFinish);
                rateAp += parseFloat(item.FinalizationRate);

                payPrice += parseFloat(item.PayPrice);
            }
            var grid = e.sender;
            totalPayment = Math.floor(totalPayment * 100) / 100;
            rateAp = Math.floor(rateAp/rdata.length * 100) / 100;
            //客户端汇总计算
            if (e.field == "Amount") {
                var s = "<span style='color:Brown;'>"
                s += "合计:" + totalPayment
                    + "</span>";
                e.cellHtml = s;
            }
            else if (e.field == "AllOrder") {
                var s = "<span style='color:Brown;'>"
                s += "合计:" + allOrder
                    + "</span>";
                e.cellHtml = s;
            }
            else if (e.field == "WaitDesign") {
                var s = "<span style='color:Brown;'>"
                s += "合计:" + wait
                    + "</span>";
                e.cellHtml = s;
            }
            else if (e.field == "Designing") {
                var s = "<span style='color:Brown;'>"
                s += "合计:" + designing
                    + "</span>";
                e.cellHtml = s;
            }
            else if (e.field == "DesignFinish") {
                var s = "<span style='color:Brown;'>"
                s += "合计:" + finish
                    + "</span>";
                e.cellHtml = s;
            }
            else if (e.field == "FinalizationRate") {
                var s = "<span style='color:Brown;'>"
                s += "平均:" + rateAp
                    + "</span>";
                e.cellHtml = s;
            }
            else if (e.field == "PayPrice") {
                var s = "<span style='color:Brown;'>"
                s += "合计:" + payPrice
                    + "</span>";
                e.cellHtml = s;
            }
        }


    </script>        
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="btn" runat="Server">
    <a class="mini-button mini-button-primary" iconcls="icon-folder" onclick="exportFn()">导出</a>
</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="content" runat="Server">
    <div class="mini-fit">
        <div id="m_grid" class="mini-datagrid" sortMode="client"  style="width: 100%; height: 100%;" showemptytext="true" showPager="false" showSummaryRow="false" ondrawsummarycell="onDrawSummaryCell" 
            emptytext="暂无记录，请选择部门" url="../handler/sync.ashx?t=get_customer_oldcustomer">
            <div property="columns">               
                <div type="indexcolumn" width="20"></div>
                <div type="checkcolumn" width="20"></div>
                <div field="CustomerTb" width="60" align="center" headeralign="center">客服</div> 
                <div field="ocount" dataType="int" width="60" align="center" headeralign="center" allowSort="true">老客户</div>
                <div field="omore" dataType="int" width="60" align="center" headeralign="center" allowSort="true">老客户买多</div>
                <div field="per" dataType="string" width="60" align="center" headeralign="center">买多率</div>
            </div>
        </div>
    </div>
</asp:Content>