erp/Web/ECharts/DesignRate.aspx

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

<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({
                shopname: s.shop, designer: s.design, order_area: s.order_area, org: s.designerorg, date1: s.assigndate1, date2: s.assigndate2, UpDate1: s.UpDate1, UpDate2: s.UpDate2
            });
        }

        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, dateType: text
                });
            }

            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;
            }
        }
        function onFinalizationRate(e) {
            var record = e.record;
            var FinalizationRate = record.FinalizationRate;
            if (FinalizationRate == '0') {
                var html = "<div style=\"display:flex;flex-direction:column;\">";
                html += ("<div>" + 0 + "</div>");
                html += "</div>";
                return html;
            }
            var total = 0 ? "0%" : (Math.round(FinalizationRate / record.FinalizationRateSum * 10000) / 100.00) + "%";
            var html = "<div style=\"display:flex;flex-direction:column;\">";
            html += ("<div>" + total + "</div>");
            html += "</div>";
            return html;
        }
        function onAvgWeekRate(e) {
            var record = e.record;
            var AvgWeekRate = record.AvgWeekRate;
            if (AvgWeekRate == '0') {
                var html = "<div style=\"display:flex;flex-direction:column;\">";
                html += ("<div>" + 0 + "</div>");
                html += "</div>";
                return html;
            }
            var total = 0 ? "0%" : (Math.round(AvgWeekRate / record.AvgWeekRateSum * 10000) / 100.00) + "%";
            var html = "<div style=\"display:flex;flex-direction:column;\">";
            html += ("<div>" + total + "</div>");
            html += "</div>";
            return html;
        }
        function onAvgRate(e) {
            var record = e.record;
            var AvgRate = record.AvgRate;
            if (AvgRate == '0') {
                var html = "<div style=\"display:flex;flex-direction:column;\">";
                html += ("<div>" + 0 + "</div>");
                html += "</div>";
                return html;
            }
            var total = 0 ? "0%" : (Math.round(AvgRate / record.AvgRateSum * 10000) / 100.00) + "%";
            var html = "<div style=\"display:flex;flex-direction:column;\">";
            html += ("<div>" + total + "</div>");
            html += "</div>";
            return html;
        }
        function gettingData() {
            postAjax("new_Designer_Rate", "", function (data) {

            });
        }
    </script>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="btn" runat="Server">
    <a class="mini-button mini-button-primary" iconcls="icon-folder" onclick="exportFn()">导出</a>
    <a class="mini-button mini-button-primary" onclick="gettingData()">获取当日数据</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" showsummaryrow="true" showpager="false" showsummaryrow="false" ondrawsummarycell="onDrawSummaryCell"
            emptytext="暂无记录，请选择部门" url="../handler/sync.ashx?t=get_erp_designer_gather_rate2">
            <div property="columns">
                <div type="indexcolumn" width="20"></div>
                <div type="checkcolumn" width="20"></div>
                <div field="name" width="60" align="center" headeralign="center">设计师</div>
                <div field="sumPlyAmount" datatype="float" width="60" align="center" headeralign="center">总金额</div>
                <div field="refundPayment" datatype="float" width="60" align="center" headeralign="center">退款金额</div>
                <div field="designPayment" datatype="float" width="60" align="center" headeralign="center">定稿金额</div>
                <div field="sumNum" datatype="int" width="60" align="center" headeralign="center">总数量（拆分合并后）</div>
                <%--<div field="waitSum" datatype="int" width="60" align="center" headeralign="center">总单量</div>--%>
                <div field="WaitDesign" datatype="int" width="60" align="center" headeralign="center">待设计</div>
                <div field="Designing" datatype="int" width="60" align="center" headeralign="center">设计中</div>
                <div field="DesignFinish" datatype="int" width="60" align="center" headeralign="center">设计完成</div>
                <%-- <div field="PayPrice" dataType="int" width="60" align="center" headeralign="center" allowSort="true">奖励金额</div>--%>
                <%--<div field="FinalizationRateSum" dataType="string" width="60" align="center"headeralign="center"   >本日指派</div>--%>
                <%-- <div field="AvgWeekRateSum" dataType="string" width="60" align="center"headeralign="center" >本周指派</div>--%>
                <%-- <div field="AvgRateSum" dataType="string" width="60" align="center"headeralign="center" >本月指派</div>--%>
                <div field="AllOrder" datatype="string" width="60" align="center" headeralign="center">当日指派</div>
                <div field="FinalizationRate" datatype="string" width="60" align="center" headeralign="center">当日完成</div>
                <div field="onFinalizationRateSum" datatype="string" width="60" align="center" headeralign="center">定稿率</div>
                <div field="toRefundDesign" datatype="string" width="60" align="center" headeralign="center">退款率</div>
                <div field="onAvgWeekRate" datatype="string" width="60" align="center" headeralign="center">周定稿率</div>
                <div field="onAvgRate" datatype="string" width="60" align="center" headeralign="center">月定稿率</div>
                <div field="designTime" datatype="string" width="60" align="center" headeralign="center">上传文件</div>
                <div field="days" width="60" dateformat="yyyy-MM-dd HH:mm" align="center" headeralign="center">时间</div>
            </div>
        </div>
    </div>
</asp:Content>