erp/Web/ECharts/PlaceGather.aspx

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

<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;
            grid.load({
                date1: s.placedate1, date2: s.placedate2
            });
            mini.get("supplier_grid").load({
                date1: s.placedate1, date2: s.placedate2
            });
        }

        function exportAfterFn(id) {
            let grid = mini.get(id);
            let extname = "";
            extname = extname == "" ? "下单部每日下单数据" : extname
            if (grid == null) {
                alert("无法导出");
                return;
            }
            let columns = grid.columns;
            function getColumns(columns) {
                let cols = [];
                let h = "";
                for (let i = 0; i < columns.length; i++) {
                    let column = columns[i];
                    //if (!column.visible || column.header == undefined) {
                    //    continue;
                    //}
                    if (column.header == undefined || column.header == "#") {
                        continue;
                    }
                    if (typeof column.header == "function") continue;
                    if (column.header.indexOf("<") != -1) h = column.header.toString().substring(0, column.header.indexOf("<"));
                    else h = column.header.toString();
                    h = h.replace(/ /g, "");
                    //if (i == 1) alert(h);
                    //alert(column.header);
                    //var col = { header: h, field: column.field, type: column.type, visible: column.visible };
                    let col = { header: h, field: column.field, type: column.type, width: column.width, visible: true };
                    if (column.columns) {
                        col.columns = getColumns(column.columns);
                    }
                    cols.push(col);
                }
                return cols;
            }
            columns = getColumns(columns);
            let type = "";
            let sel_row = grid.getSelecteds();
            if (grid.multiSelect && sel_row.length > 0 || grid.url == "" || grid.showPager == false) {
                type = "bexcel";
            }
            else type = grid.url == "" ? "bexcel" : "excel";
            downLoad(grid, GetPrePath() + "/Reports/comExports.aspx", { extname: extname, url: encodeURIComponent(grid.url), type: type, columns: columns }, function () {
                //alert("导出成功");
            });
        }
        function downLoad(grid, url, fields, callback) {

            //创建Form
            var submitfrm = document.createElement("form");
            submitfrm.action = url;
            submitfrm.method = "post";
            submitfrm.target = "_blank";
            document.body.appendChild(submitfrm);

            if (fields) {

                for (var p in fields) {
                    var input = mini.append(submitfrm, "<input type='hidden' name='" + p + "'>");
                    var v = fields[p];
                    if (typeof v != "string") v = mini.encode(v);
                    input.value = v;
                }
            }
            if (grid == null) {
                alert("无法导出");
                return;
            }
            var parms = grid._dataSource.loadParams;
            for (var item in parms) {
                if (parms[item] == undefined || parms[item] == null) continue;
                mini.append(submitfrm, "<input type='hidden' name='" + item + "' value=\"" + parms[item] + "\">");
            }

            var sel_row = grid.getSelecteds();
            if (grid.multiSelect && sel_row.length > 0) {
                mini.append(submitfrm, "<input type='hidden' name='hExData' value='" + mini.encode(sel_row) + "'>");
            } else {
                if (grid.url == undefined || grid.url == "" || grid.showPager == false) {
                    //ame = 'hExData' value = '" + mini.encode(grid.data)
                    mini.append(submitfrm, "<input type='hidden' name='hExData' value='" + mini.encode(grid.data) + "'>");
                }
            }

            if (mini.get("txtSdate") != null && mini.get("txtSdate").getText() != "") {
                mini.append(submitfrm, "<input type='hidden' name='hExSdate' value=\"" + mini.get("txtSdate").getText() + "\">");
            }
            if (mini.get("txtEdate") != null && mini.get("txtEdate").getText() != "") {
                mini.append(submitfrm, "<input type='hidden' name='hExEdate' value=\"" + mini.get("txtEdate").getText() + "\">");
            }



            //mini.append()
            submitfrm.submit();
            setTimeout(function () {
                submitfrm.parentNode.removeChild(submitfrm);
                if (callback) callback();
            }, 1000);
        }

        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="exportAfterFn('supplier_grid')">导出</a>
</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="content" runat="Server">
    <div class="mini-fit">
        <div id="supplier_grid" class="mini-datagrid" sortmode="client" style="width: 100%; height: 50%;" showemptytext="true" showpager="false" showsummaryrow="false" ondrawsummarycell="onDrawSummaryCell"
            emptytext="暂无记录" url="../handler/sync.ashx?t=get_place_order_data">
            <div property="columns">
                <div field="ProductName" width="60" align="center" headeralign="center">品类</div>
                <div field="SupplierName" width="60" align="center" headeralign="center">车间</div>
                <div field="dayDev" width="60" align="center" headeralign="center">当天出货的下单数量</div>
                <div field="dayTotal" width="60" align="center" headeralign="center">当天下单总数量</div>
                <div field="payTotal" width="60" align="center" headeralign="center">金额5百以上单量</div>
                <div field="today" width="60" align="center" headeralign="center">当天出货</div>
                <div field="unusua" width="60" align="center" headeralign="center">异常单</div>
                <div field="unusua_reson" width="60" visible="false" align="center" headeralign="center">异常原因</div>
            </div>
        </div>
         <a class="mini-button mini-button-primary" iconcls="icon-folder" onclick="exportFn()">导出</a>
        <div id="m_grid" class="mini-datagrid" sortmode="client" style="width: 100%; height: 50%;" showemptytext="true" showpager="false" showsummaryrow="false" ondrawsummarycell="onDrawSummaryCell"
            emptytext="暂无记录" url="../handler/sync.ashx?t=get_erp_place_gather">
            <div property="columns">
                <div type="indexcolumn" width="20"></div>
                <div type="checkcolumn" width="20"></div>
                <div field="DesignerName" width="60" align="center" headeralign="center">下单员</div>
                <div field="AllOrder" datatype="int" width="60" align="center" headeralign="center" allowsort="true">总数量</div>

            </div>
        </div>
    </div>
</asp:Content>