import React from 'react'; import { Select, Spin, Input, Table, Button ,DatePicker, Form , Tabs , Switch,message} from 'antd'; import ajax from 'jquery/src/ajax/xhr.js'; import $ from 'jquery/src/ajax'; import './report.less'; import { post,taskStatus,publishStatus } from '../../../dataDic.js'; import moment from 'moment'; import {ChooseList} from "../orderNew/chooseList"; const TabPane = Tabs.TabPane; const DiurnalStatistics = React.createClass({ loadData(timeTypes) { this.setState({ loading: true, timeTypes:timeTypes }); $.ajax({ method: "get", dataType: "json", crossDomain: false, url: globalConfig.context + "/api/admin/report/technicalDepStatistics", data: { type:'1', timeType:this.state.releaseDate[0]?4:timeTypes, startTime: this.state.releaseDate[0], endTime: this.state.releaseDate[1], depId:this.state.superId,//部门机构 taskStatus:this.state.taskStatus,//任务状态 publishStatus:this.state.publishStatus,//公示状态 }, 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, orderDep: item.orderDep,//订单部门 signTotalAmount:item.signTotalAmount,//项目签单金额 signTime:item.signTime,//签单日期 contractNo:item.contractNo,//合同编号 orderRemarks:item.orderRemarks, //订单留言 contacts:item.contacts,//企业联系人 contactMobile:item.contactMobile,//联系人电话 commodityName:item.commodityName,//任务名称 taskDistributionTime:item.taskDistributionTime,//派单时间 dutyDep:item.dutyDep, //任务责任部门 dutyName:item.dutyName,//任务责任人 dutyContactMobile:item.dutyContactMobile,//责任人联系电话 taskStatus:item.taskStatus,//任务状态 finishTime:item.finishTime, //完成时间 taskComment:item.taskComment,//任务说明 publishStatus:item.publishStatus, //公示状态 publishTime:item.publishTime,//公示时间 salesmanName:item.salesmanName, //营销员 orgName:item.orgName,//公司名称 }) }) } this.setState({ dataSource: theArr, }) }.bind(this), }).always(function() { this.setState({ loading: false }); }.bind(this)); }, totalData(timeTypes) { this.setState({ loading: true }); $.ajax({ method: "get", dataType: "json", crossDomain: false, url: globalConfig.context + "/api/admin/report/sales/countsometimeMarketingStatistics", data: { type:'1', timeType:this.state.releaseDate[0]?4:timeTypes, startTime: this.state.releaseDate[0], endTime: this.state.releaseDate[1], 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(timeTypes) 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('#daochu'); 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 { releaseDate: [], selectedRowKeys: [], selectedRows: [], loading: false, visible: false, showDesc: false, timeState:false, weekColor:true, monthColor:false, quarterColor:false, yearColor:false, Dtime:undefined, timeTypes:0, 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: '公司名称', dataIndex: 'orgName', key: 'orgName', width:100, fixed:false, render:(text,record)=>{ if(!record.theNumber){ return text//&&text.length>6?{text.substr(0,6)+'…'}:text }else{ return { children: text, props: { colSpan:3 }, } } } }, { title: '订单部门', fixed:false, width:100, dataIndex: 'orderDep', key: 'orderDep', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } }, { title: '项目签单金额', fixed:false, dataIndex: 'signTotalAmount', key: 'signTotalAmount', sorter: (a, b) => a.signTotalAmount - b.signTotalAmount, render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:1 }, } } } }, { title: '签单日期', fixed:false, width:50, dataIndex: 'signTime', key: 'signTime', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } }, { title: '合同编号', fixed:false, dataIndex: 'contractNo', key: 'contractNo', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } },{ title: '订单留言', fixed:false, width:200, dataIndex: 'orderRemarks', key: 'orderRemarks', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } },{ title: '企业联系人', fixed:false, dataIndex: 'contacts', key: 'contacts', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } },{ title: '联系人电话', fixed:false, dataIndex: 'contactMobile', key: 'contactMobile', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } },{ title: '任务名称', fixed:false, dataIndex: 'commodityName', key: 'commodityName', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } },{ title: '派单时间', fixed:false, dataIndex: 'taskDistributionTime', key: 'taskDistributionTime', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } },{ title: '部门', fixed:false, dataIndex: 'dutyDep', key: 'dutyDep', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } },{ title: '负责人', fixed:false, dataIndex: 'dutyName', key: 'dutyName', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } },{ title: '负责人电话', fixed:false, dataIndex: 'dutyContactMobile', key: 'dutyContactMobile', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } },{ title: '任务状态', fixed:false, dataIndex: 'taskStatus', key: 'taskStatus', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } },{ title: '项目完成时间', fixed:false, dataIndex: 'finishTime', key: 'finishTime', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } },{ title: '任务说明', fixed:false, width:200, dataIndex: 'taskComment', key: 'taskComment', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } },{ title: '公示状态', fixed:false, dataIndex: 'publishStatus', key: 'publishStatus', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } },{ title: '公示时间', fixed:false, dataIndex: 'publishTime', key: 'publishTime', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:0 }, } } } }, { title: '营销员', fixed:false, dataIndex: 'salesmanName', key: 'salesmanName', render:(text,record)=>{ if(!record.theNumber){ return text }else{ return { children: text, props: { colSpan:1 }, } } } } ], dataSource: [], }; }, search() { this.loadData(this.state.timeTypes); }, reset() { this.state.superId = undefined;//部门机构清零 this.state.taskStatus= undefined;//任务状态 this.state.publishStatus= undefined;//公示状态 this.loadData(0) this.setState({ order:"false", weekColor:true, monthColor:false, quarterColor:false, yearColor:false }) }, week(){ this.state.releaseDate[0] = undefined;//开始时间清零 this.state.releaseDate[1] = undefined;//结束时间清零 this.loadData(0); this.setState({ weekColor:true, monthColor:false, quarterColor:false, yearColor:false }) }, month(){ this.state.releaseDate[0] = undefined;//开始时间清零 this.state.releaseDate[1] = undefined;//结束时间清零 this.loadData(1); this.setState({ weekColor:false, monthColor:true, quarterColor:false, yearColor:false }) }, quarter(){ this.state.releaseDate[0] = undefined;//开始时间清零 this.state.releaseDate[1] = undefined;//结束时间清零 this.loadData(2); this.setState({ weekColor:false, monthColor:false, quarterColor:true, yearColor:false }) }, year(){ this.state.releaseDate[0] = undefined;//开始时间清零 this.state.releaseDate[1] = undefined;//结束时间清零 this.loadData(3); this.setState({ weekColor:false, monthColor:false, quarterColor:false, yearColor:true }) }, //重构排序 tabChange(pagination,filter,sorter){ console.log(pagination) console.log(sorter) }, componentWillMount() { //this.loadData(); this.totalData(0); let times=new Date(); let nowTime=times.getFullYear()+'年'+(times.getMonth()+1)+'月'+times.getDate()+'日'; this.setState({ Nowtime:nowTime }) }, changeList(arr) { const newArr = []; this.state.columns.forEach(item => { arr.forEach(val => { if (val === item.title) { newArr.push(item); } }); }); this.setState({ changeList: newArr }); }, render() { const { RangePicker } = DatePicker; let departmentArr = this.state.departmentArr || []; return(

订单统计报表

部门机构 :
起止时间: { this.setState({ releaseDate: dataString }); }} />
{/*
订单统计报表
*/}
) } }); export default DiurnalStatistics;