import React from 'react'; import {Select, Spin, Input, Table, Button, DatePicker, Tabs} from 'antd'; import ajax from 'jquery/src/ajax/xhr.js'; import $ from 'jquery/src/ajax'; import './report.less'; import { post } from '../../../dataDic.js'; import {ChooseList} from "../../order/orderNew/chooseList"; const TabPane = Tabs.TabPane; const DiurnalStatisticsOne = React.createClass({ loadData(totalArr) { let total=totalArr; this.setState({ loading: true }); $.ajax({ method: "get", dataType: "json", crossDomain: false, url: globalConfig.context + "/api/admin/report/sales/marketingStatistics", data: { type:'0', depId:this.state.superId,//部门机构 }, success: function(data) { let thedata = data.data; let theArr = []; if(!thedata) { if(data.error && data.error.length) { message.warning(data.error[0].message); }; thedata = {}; } else { thedata.map(function(item, index) { let nub=index+1; theArr.push({ key: index, theNumber:false, nub:nub, id: item.id, name:item.name,//员工姓名 departmentId:item.departmentId,//部门ID departmentName:item.departmentName,//部门名称 departmentManagerName:item.departmentManagerName,//部门负责人名称 roleName:item.roleName, //职位权限 privateCustomersCount:item.privateCustomersCount,// 部门客户数 dailyTelNo:item.dayTelNo,//日电话量 dailyVisitNo:item.dayVisitNo,//日外拜量 dailyFollowNo:item.dayFollowNo,//日营销总量 dailyAVG:parseFloat(item.dayAVG).toFixed(2),//日人均营销量 weekTelNo:item.weeklyTelNo,//周电话量 weekFollowNo:item.weeklyFollowNo,//周总量 weekVisitNo:item.weeklyVisitNo,//周外拜量 monthsTelNo:item.monthTelNo,//月电话量 monthsFollowNo:item.monthFollowNo,//月总量 monthsVisitNo:item.monthVisitNo,//月外拜量 annualTelNo:item.yearTelNo,//年电话量 annualFollowNo:item.yearFollowNo,//年总量 annualVisitNo:item.yearVisitNo,//年外拜量 }) }) } if(theArr.length){ theArr.push( { key:9999999, theNumber:true, name:'合计', privateCustomersCount:total.privateCustomersCount,// 私有客户数 dailyTelNo:total.dayTelNo,//日电话量 dailyVisitNo:total.dayVisitNo,//日外拜量 dailyFollowNo:total.dayFollowNo,//日营销总量 dailyAVG:parseFloat(total.dailyAVG).toFixed(2),//日人均营销量 weekTelNo:total.weeklyTelNo,//周电话量 weekFollowNo:total.weeklyFollowNo,//周总量 weekVisitNo:total.weeklyVisitNo,//周外拜量 monthsTelNo:total.monthTelNo,//月电话量 monthsFollowNo:total.monthFollowNo,//月总量 monthsVisitNo:total.monthVisitNo,//月外拜量 annualTelNo:total.yearTelNo,//年电话量 annualFollowNo:total.yearFollowNo,//年总量 annualVisitNo:total.yearVisitNo,//年外拜量 } ) } this.setState({ dataSource: theArr, }) }.bind(this), }).always(function() { this.setState({ loading: false }); }.bind(this)); }, totalData() { this.setState({ loading: true }); $.ajax({ method: "get", dataType: "json", crossDomain: false, url: globalConfig.context + "/api/admin/report/sales/countMarketingStatistics", data: { type:'0', depId:this.state.superId,//部门机构 }, success: function(data) { let thedata = data.data; let theArr = []; if(!thedata) { if(data.error && data.error.length) { message.warning(data.error[0].message); }; thedata = {}; } this.loadData(thedata); this.selectSuperId(); }.bind(this), }).always(function() { this.setState({ loading: false }); }.bind(this)); }, //时间选择 selTime(value,index){ this.setState({ Dtime:value, selTime:index }) }, //获取上级组织 selectSuperId() { this.state.data = [] $.ajax({ method: "get", dataType: "json", crossDomain: false, url: globalConfig.context + "/api/admin/organization/selectSuperId", data:{ }, success: function (data) { let theArr = []; let theId=[];//用于保存上级组织的ID和名称 let thedata=data.data; if (!thedata) { if (data.error && data.error.length) { message.warning(data.error[0].message); }; thedata = {}; }; var contactIds=[]; for(var i=0;i{theData.name} ); theId.push( [theData.id,theData.name] ); }; this.setState({ SuperArr:thedata, contactsOption: theArr, theId: theId, orderStatusOptions:data.data, }); }.bind(this), }).always(function () { this.setState({ loading: false }); }.bind(this)); }, //判断浏览器类型 getExplorer() { var explorer = window.navigator.userAgent; //ie if(explorer.indexOf("MSIE") >= 0) { return 'ie'; } //firefox else if(explorer.indexOf("Firefox") >= 0) { return 'Firefox'; } //Chrome else if(explorer.indexOf("Chrome") >= 0) { return 'Chrome'; } //Opera else if(explorer.indexOf("Opera") >= 0) { return 'Opera'; } //Safari else if(explorer.indexOf("Safari") >= 0) { return 'Safari'; } }, //导出为exel表格 tabExel() { var table = document.querySelector('#daochu1'); var idTmr; //debugger; //整个表格拷贝到EXCEL中 if(this.getExplorer() == 'ie') { var curTbl = document.getElementById(tableid); var oXL = new ActiveXObject("Excel.Application"); //创建AX对象excel var oWB = oXL.Workbooks.Add(); //获取workbook对象 var xlsheet = oWB.Worksheets(1); //激活当前sheet var sel = document.body.createTextRange(); sel.moveToElementText(curTbl); //把表格中的内容移到TextRange中 sel.select(); //全选TextRange中内容 sel.execCommand("Copy"); //复制TextRange中内容 xlsheet.Paste(); //粘贴到活动的EXCEL中 oXL.Visible = true; //设置excel可见属性 try { var fname = oXL.Application.GetSaveAsFilename("Excel.xls", "Excel Spreadsheets (*.xls), *.xls"); } catch(e) { print("Nested catch caught " + e); } finally { oWB.SaveAs(fname); oWB.Close(savechanges = false); //xls.visible = false; oXL.Quit(); oXL = null; //结束excel进程,退出完成 //window.setInterval("Cleanup();",1); idTmr = window.setInterval("Cleanup();", 1); } } else { this.tableToExcel(table,this.getExplorer()); } function Cleanup() { window.clearInterval(idTmr); CollectGarbage(); } }, tableToExcel(table,name) { var uri = 'data:application/vnd.ms-excel;base64,', template = '{table}
', base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }, format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) } if(!table.nodeType) table = document.getElementById(table); var ctx = { worksheet: name || 'Worksheet', table: table.innerHTML }; window.location.href = uri + base64(format(template, ctx)) }, getInitialState() { return { selectedRowKeys: [], selectedRows: [], loading: false, visible: false, showDesc: false, timeState:false, Dtime:undefined, selTime:'', columns: [ { title: '序号', dataIndex: 'nub', width:50, key: 'nub', fixed:false, render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } },{ title: '姓名', width:100, fixed:false, dataIndex: 'name', key: 'name', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:4 }, } } } }, { title: '部门', dataIndex: 'departmentName', key: 'departmentName', width:230, fixed:false, render:(text,record)=>{ if(!record.theNumber){ return text//&&text.length>6?{text.substr(0,6)+'…'}:text }else{ return { children: text, props: { colSpan:0 }, } } } },{ title: '职位', width:100, fixed:false, dataIndex: 'roleName', key: 'roleName', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } }, { title: '私有客户数', width:100, fixed:false, dataIndex: 'privateCustomersCount', key: 'privateCustomersCount', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:1 }, } } } },{ title: '今日营销', children: [ { title: '营销总量(所有)', width:100, dataIndex: 'dailyFollowNo', key: 'nudailyFollowNom', sorter: (a, b) => a.dailyFollowNo - b.dailyFollowNo, sorterOrder:'ascend' },{ title: '电话量', width:80, dataIndex: 'dailyTelNo', key: 'dailyTelNo', sorter: (a, b) => a.dailyTelNo - b.dailyTelNo, },{ title: '外拜量', width:80, dataIndex: 'dailyVisitNo', key: 'dailyVisitNo', sorter: (a, b) => a.dailyVisitNo - b.dailyVisitNo, } ], }, { title: '周营销累计', children: [ { title: '周营销总量(所有)', width:110, dataIndex: 'weekFollowNo', key: 'weekFollowNo', sorter: (a, b) => a.weekFollowNo - b.weekFollowNo, },{ title: '电话量', width:80, dataIndex: 'weekTelNo', key: 'weekTelNo', sorter: (a, b) => a.weekTelNo - b.weekTelNo, },{ title: '外拜量', width:80, dataIndex: 'weekVisitNo', key: 'weekVisitNo', sorter: (a, b) => a.weekVisitNo - b.weekVisitNo, } ], },{ title: '月营销累计', children: [ { title: '月营销总量(所有)', width:110, dataIndex: 'monthsFollowNo', key: 'monthsFollowNo', sorter: (a, b) => a.monthsFollowNo - b.monthsFollowNo, },{ title: '电话量', width:80, dataIndex: 'monthsTelNo', key: 'monthsTelNo', sorter: (a, b) => a.monthsTelNo - b.monthsTelNo, },{ title: '外拜量', width:80, dataIndex: 'monthsVisitNo', key: 'monthsVisitNo', sorter: (a, b) => a.monthsVisitNo - b.monthsVisitNo, } ], },{ title: '年营销累计', children: [ { title: '年营销总量(所有)', width:110, dataIndex: 'annualFollowNo', key: 'annualFollowNo', sorter: (a, b) => a.annualFollowNo - b.annualFollowNo, },{ title: '电话量', width:80, dataIndex: 'annualTelNo', key: 'annualTelNo', sorter: (a, b) => a.annualTelNo - b.annualTelNo, },{ title: '外拜量', width:80, dataIndex: 'annualVisitNo', key: 'annualVisitNo', sorter: (a, b) => a.annualVisitNo - b.annualVisitNo, } ], } ], dataSource: [], }; }, search() { this.totalData() }, reset() { this.state.superId = undefined;//部门机构清零 this.totalData(); }, changeList(arr) { const newArr = []; this.state.columns.forEach(item => { arr.forEach(val => { if (val === item.title) { newArr.push(item); } }); }); this.setState({ changeList: newArr }); }, componentWillMount() { this.totalData(); let times=new Date(); let nowTime=times.getFullYear()+'年'+(times.getMonth()+1)+'月'+times.getDate()+'日'; this.setState({ Nowtime:nowTime }) }, render() { let departmentArr = this.state.departmentArr || []; return(

客户营销统计表(员工)

部门机构 :
{this.state.timeState?this.state.txtTime:this.state.Nowtime} 客户营销统计表(员工)
) } }); export default DiurnalStatisticsOne;