CN113037617B - Collaborative statistical method, system, electronic equipment and storage medium in communication application - Google Patents
Collaborative statistical method, system, electronic equipment and storage medium in communication application Download PDFInfo
- Publication number
- CN113037617B CN113037617B CN202110388821.7A CN202110388821A CN113037617B CN 113037617 B CN113037617 B CN 113037617B CN 202110388821 A CN202110388821 A CN 202110388821A CN 113037617 B CN113037617 B CN 113037617B
- Authority
- CN
- China
- Prior art keywords
- information
- basic information
- acquiring
- cooperation
- employee
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L51/00—User-to-user messaging in packet-switching networks, transmitted according to store-and-forward or real-time protocols, e.g. e-mail
- H04L51/04—Real-time or near real-time messaging, e.g. instant messaging [IM]
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24554—Unary operations; Data partitioning operations
- G06F16/24556—Aggregation; Duplicate elimination
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L51/00—User-to-user messaging in packet-switching networks, transmitted according to store-and-forward or real-time protocols, e.g. e-mail
- H04L51/21—Monitoring or handling of messages
- H04L51/216—Handling conversation history, e.g. grouping of messages in sessions or threads
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L51/00—User-to-user messaging in packet-switching networks, transmitted according to store-and-forward or real-time protocols, e.g. e-mail
- H04L51/52—User-to-user messaging in packet-switching networks, transmitted according to store-and-forward or real-time protocols, e.g. e-mail for supporting social networking services
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L61/00—Network arrangements, protocols or services for addressing or naming
- H04L61/45—Network directories; Name-to-address mapping
- H04L61/4555—Directories for electronic mail or instant messaging
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Probability & Statistics with Applications (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Fuzzy Systems (AREA)
- Computing Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a collaborative statistical method, a system, electronic equipment and a storage medium in communication application, wherein the technical scheme of the method comprises the steps of gathering and de-duplicating employee information and organization information in enterprise-level instant communication application to obtain basic information of employees; obtaining external contact person information in the enterprise instant messaging application, and obtaining basic information of a client according to the external contact person information and the relationship between the external contact person and the staff; acquiring meeting information in the enterprise-level instant messaging application, and associating the meeting information to the employee basic information and the client basic information; and acquiring the cooperation detail data of the employee in the enterprise-level instant messaging application according to the employee basic information and the client basic information which are associated with the conference information and the communication record in the enterprise-level instant messaging application. The invention solves the problem that the conventional statistical arrangement of the staff cooperation data in the enterprise is lack of flexibility.
Description
Technical Field
The invention belongs to the field of data processing, and particularly relates to a collaborative statistical method and system in communication application, electronic equipment and a storage medium.
Background
Enterprise Wechat can produce a large amount of information interaction as the intercom software of numerous small-and-medium-sized enterprises every day, and the administrator should filter out useful information better, is convenient for the enterprise to master enterprise's inside developments and development. For example, by utilizing the communication information in the team, the manager reasonably arranges the time investment of the whole team on each project according to the data change condition of each week by counting the internal communication network, communication change, total communication times and the like, and the work content of each team member provides the decision basis of work management for the manager.
The traditional analysis and arrangement of structured data usually adopts a relational database mysql, but when the data is large, performance bottleneck can be generated, and when multiple data sources are input, multiple groups of foreign key associations need to be set, so that the calculation is troublesome and time-consuming. The offline analysis platform hive based on the distributed system hdfs has the advantages of distributed storage and calculation, is good at processing large data volume, is provided with an optimization mechanism, has rich operator functions, can customize the functions, enhances the development flexibility and shortens the development time.
Disclosure of Invention
The embodiment of the application provides a collaborative statistical method, a collaborative statistical system, electronic equipment and a storage medium in communication application, and aims to at least solve the problem that the statistical arrangement of employee collaborative data in an existing enterprise is lack of flexibility.
In a first aspect, an embodiment of the present application provides a collaborative statistics method in a communication application, including: acquiring employee information, namely acquiring basic employee information after gathering and de-duplicating employee information and organization information in enterprise-level instant messaging application; a client information acquisition step, namely acquiring external contact person information in the enterprise instant messaging application, and acquiring basic client information according to the external contact person information and the relationship between the external contact person and the staff; a conference detail calculation step, namely acquiring conference information in the enterprise-level instant messaging application and associating the conference information to the employee basic information and the client basic information; and a collaboration detail calculating step, namely acquiring collaboration detail data of the employee in the enterprise-level instant messaging application according to the employee basic information and the client basic information which are associated with the conference information and according to the communication record in the enterprise-level instant messaging application.
Preferably, the cooperation detail calculating step further includes: and a first cooperation statistics step, namely acquiring group communication records in the communication records, acquiring the staff basic information and the client basic information participating in the group communication, and performing aggregation statistics on the group communication records, the staff basic information and the client basic information to acquire one-to-many first cooperation detail data.
Preferably, the cooperation detail calculating step further comprises: and a second cooperation counting step, namely acquiring one-to-one communication record in the communication records, acquiring the employee basic information in the one-to-one communication, and counting and calculating second cooperation detail data according to the one-to-one communication record and the employee basic information.
Preferably, the cooperation detail calculating step further includes: and a collaboration detail aggregation step, namely acquiring team information including the superior-subordinate relationship of the staff according to the staff basic information, aggregating the first collaboration detail data and the second collaboration detail data according to the staff basic information, then associating the aggregated first collaboration detail data and the aggregated second collaboration detail data with the team information, and counting team collaboration detail data with the team as a dimensionality.
In a second aspect, an embodiment of the present application provides a system for collaborative statistics in communication application, which is applicable to the method for collaborative statistics in communication application, and includes: the employee information acquisition module is used for acquiring basic employee information after gathering and de-duplicating employee information and organization information in enterprise-level instant messaging application; the client information acquisition module is used for acquiring external contact person information in the enterprise instant messaging application and acquiring basic client information according to the external contact person information and the relationship between the external contact person and the staff; the conference detail calculation module is used for acquiring conference information in the enterprise-level instant messaging application and associating the conference information to the employee basic information and the client basic information; and the cooperation detail calculating module is used for acquiring cooperation detail data of the staff in the enterprise-level instant messaging application according to the staff basic information and the client basic information which are associated with the meeting information and the communication record in the enterprise-level instant messaging application.
In some embodiments, the collaboration detail calculating module further comprises: and the first collaboration statistical unit is used for acquiring group communication records in the communication records, acquiring the staff basic information and the client basic information participating in group communication, and aggregating and counting the group communication records, the staff basic information and the client basic information to acquire one-to-many first collaboration detail data.
In some embodiments, the collaboration detail calculating module further comprises: and the second collaboration statistical unit is used for acquiring one-to-one communication records in the communication records, acquiring the staff basic information in the one-to-one communication, and calculating second collaboration detail data according to the one-to-one communication records and the staff basic information.
In some embodiments, the collaboration detail calculating module further comprises: the cooperation detail aggregation unit is used for acquiring team information including the superior-subordinate relation of the staff according to the staff basic information, aggregating the first cooperation detail data and the second cooperation detail data according to the staff basic information, then associating the aggregated first cooperation detail data and the aggregated second cooperation detail data with the team information, and counting team cooperation detail data with the team as a dimensionality.
In a third aspect, an embodiment of the present application provides an electronic device, which includes a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor executes the computer program to implement a method for collaborative statistics in a communication application as described in the first aspect.
In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements a method for collaborative statistics in a communication application as described in the foregoing first aspect.
The invention can be applied to the field of data capability. Compared with the related art, the collaborative statistical method in the communication application has the idea of data hierarchical calculation, so that the calculation process is clearer, and the problem of repeated calculation of multiple data sources and the same index is effectively solved. The method has the advantages of high treatment efficiency and rapid calculation, can be based on the advantages of hive-line storage, high compression efficiency, multi-core parallel and rapid query in specific implementation, and can greatly improve the efficiency under a high-performance mapreduce calculation framework.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the application and together with the description serve to explain the application and not to limit the application. In the drawings:
FIG. 1 is a flow chart of a method of collaborative statistics in a communication application according to the present invention;
FIG. 2 is a flowchart illustrating the substeps of step S4 of FIG. 1;
FIG. 3 is a block diagram of a collaborative statistics system in a communication application according to the present invention;
FIG. 4 is a block diagram of an electronic device of the present invention;
in the above figures:
1. an employee information acquisition module; 2. a client information acquisition module; 3. a meeting detail calculating module; 4. a cooperation detail calculating module; 41. a first collaborative statistics unit; 42. a second collaborative statistics unit; 43. a collaboration detail aggregation unit; 60. a bus; 61. a processor; 62. a memory; 63. a communication interface.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be described and illustrated below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of and not restrictive on the broad application. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments provided in the present application without any inventive step are within the scope of protection of the present application.
It is obvious that the drawings in the following description are only examples or embodiments of the present application, and that it is also possible for a person skilled in the art to apply the present application to other similar contexts on the basis of these drawings without inventive effort. Moreover, it should be appreciated that in the development of any such actual implementation, as in any engineering or design project, numerous implementation-specific decisions must be made to achieve the developers' specific goals, such as compliance with system-related and business-related constraints, which may vary from one implementation to another.
Reference in the specification to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment can be included in at least one embodiment of the specification. The appearances of the phrase in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. Those of ordinary skill in the art will explicitly and implicitly appreciate that the embodiments described herein may be combined with other embodiments without conflict.
Unless defined otherwise, technical or scientific terms referred to herein shall have the ordinary meaning as understood by those of ordinary skill in the art to which this application belongs. Reference to "a," "an," "the," and similar words throughout this application are not to be construed as limiting in number, and may refer to the singular or the plural. The use of the terms "including," "comprising," "having," and any variations thereof herein, is meant to cover a non-exclusive inclusion; for example, a process, method, system, article, or apparatus that comprises a list of steps or modules (elements) is not limited to the listed steps or elements, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Embodiments of the invention are described in detail below with reference to the accompanying drawings:
fig. 1 is a flowchart of a cooperative statistical method in communication application according to the present invention, and referring to fig. 1, the cooperative statistical method in communication application according to the present invention includes the following steps:
in a specific implementation, the enterprise-level instant messaging application used in the embodiments of the present application is enterprise WeChat. In a specific implementation, data is obtained from enterprise WeChat and stored in a database, and the data exists in the database in the form of a table containing relationships.
S1: gathering and de-duplicating employee information and organization information in an enterprise-level instant messaging application to obtain basic employee information.
In specific implementation, the department member table and the employee table are acquired in the enterprise WeChat according to the data source ods database, and optionally, the acquired data can be up to the current day. Converting, cleaning and de-duplicating data in the department member table, and sequencing according to time to obtain the basic information of the department members at the latest time, including but not limited to name, mobile phone number, job number and mail information; optionally, the data in the employee table may be sorted by time to obtain other organization information of the latest time, including but not limited to job number, job level, post, superior id, and superior name. In specific implementation, the employee basic information including the content is further acquired through job number association and aggregation.
S2: and acquiring external contact person information in the enterprise instant messaging application, and acquiring basic information of a client according to the external contact person information and the relationship between the external contact person and the staff.
In specific implementation, according to the data source ods database, the external contact list, the external contact member list, and the employee client list including the mapping relationship between the employee and the client are obtained in the enterprise WeChat, and optionally, the obtained data may be up to the current day. In specific implementation, the three pieces of table data are converted, cleaned, deduplicated, sorted according to time, associated according to client id and fused with the three pieces of table information to obtain the client basic information containing the latest time of the client id, the client name, the client label and other contents.
S3: and acquiring meeting information in the enterprise-level instant messaging application, and associating the meeting information to the employee basic information and the client basic information.
In a specific implementation, all conference data sources are aggregated by taking personnel (staff or clients) as a dimension, and optionally, conference data sources in enterprise WeChat include but are not limited to mail conferences, enterprise WeChat video conferences, enterprise WeChat voice conferences and conference invitations. Firstly, a session content table, a session invitation information table and an audio archiving information table are converted and cleaned, a session id of the session content table is associated with the session invitation information table and the audio archiving information, and aggregation processing is carried out to obtain an enterprise wechat video conference, an enterprise wechat voice conference and conference invitation details. And the personnel id is associated to the client basic information table and the employee basic information table. Optionally, the staff id may be associated with a calendar table, and the staff meeting details are gathered, and optionally, the calendar table may be an office365 calendar table.
S4: and acquiring the cooperation detail data of the employee in the enterprise-level instant messaging application according to the employee basic information and the client basic information which are associated with the conference information and the communication record in the enterprise-level instant messaging application.
Optionally, fig. 2 is a flowchart illustrating a sub-step of step S4 in fig. 1, please refer to fig. 2:
s41: and acquiring group communication records in the communication records, acquiring the employee basic information and the client basic information participating in group communication, and aggregating and counting the group communication records, the employee basic information and the client basic information to acquire one-to-many first collaboration detail data.
In a specific implementation, the first collaboration detail data in this step is a person group collaboration detail data, that is, the one-to-many collaboration detail data is obtained by counting collaboration details of each group (including group chat and meeting) with collaboration property in the enterprise WeChat by using a person as a dimension for a time period, and optionally, the time period is 30 minutes. In specific implementation, a session content table with the group chat property in the enterprise WeChat is screened out, group chat cooperation details are counted according to association of group ids, internal group information and external group information, and then according to personnel ids, personnel meeting details are associated, and the aggregated result is the personnel group cooperation details.
S42: and acquiring one-to-one communication record in the communication records, acquiring the employee basic information in the one-to-one communication, and counting and calculating second cooperation detail data according to the one-to-one communication record and the employee basic information.
In specific implementation, the second collaboration detail data in this step is a person collaboration detail data, that is, one-to-one collaboration detail data, and the session content table, the mail information table, and the chat file table are obtained according to the data source ids, optionally, the data may be data ending to the current day, the data is converted and cleaned, the session id of the session content table is correlated, and the person is used as a dimension, chat, mail, and meeting information is summarized and calculated according to a time period, so as to obtain the person collaboration detail, optionally, the time period may be 30 minutes.
S43: acquiring team information including the upper-lower level relation of the staff according to the staff basic information, aggregating the first cooperation detail data and the second cooperation detail data according to the staff basic information, then associating the aggregated first cooperation detail data and the aggregated second cooperation detail data with the team information, and counting team cooperation detail data with the team as a dimension.
In the specific implementation, the personnel group cooperation details and the personnel cooperation details are collected, and are associated with the personnel id in the team member, so that statistics is respectively carried out according to the cooperation type and the cooperation period. And further acquiring a cooperation index with the dimension of the team, and optionally counting according to the day.
It should be noted that the steps illustrated in the above-described flow diagrams or in the flow diagrams of the figures may be performed in a computer system, such as a set of computer-executable instructions, and that, although a logical order is illustrated in the flow diagrams, in some cases, the steps illustrated or described may be performed in an order different than here.
The embodiment of the application provides a collaborative statistical system in communication application, which is suitable for the collaborative statistical method in communication application. As used below, the terms "unit," "module," and the like may implement a combination of software and/or hardware of predetermined functions. Although the means described in the embodiments below are preferably implemented in software, implementations in hardware or a combination of software and hardware are also possible and contemplated.
Fig. 3 is a block diagram of a collaborative statistics system in a communication application according to the present invention, please refer to fig. 3, which includes:
in a specific implementation, the enterprise-level instant messaging application used in the embodiments of the present application is enterprise WeChat. In a specific implementation, data is obtained from enterprise WeChat and stored in a database, and the data exists in the database in the form of a table containing relationships.
The employee information acquisition module 1: gathering and de-duplicating employee information and organization information in an enterprise-level instant messaging application to obtain basic employee information.
In a specific implementation, the department member table and the employee table are acquired in the enterprise WeChat according to the data source ods database, and optionally, the acquired data may be up to the current day. Converting, cleaning and de-duplicating data in the department member table, and sequencing according to time to obtain basic information of the department members at the latest time, including but not limited to names, mobile phone numbers, job numbers and mail information; optionally, the data in the employee table may be sorted by time to obtain other organization information of the latest time, including but not limited to job number, job level, post, superior id, and superior name. In specific implementation, the employee basic information containing the content is further obtained through job number association and aggregation.
The client information acquisition module 2: and acquiring the information of the external contact person in the enterprise instant messaging application, and acquiring basic information of a client according to the information of the external contact person and the relationship between the external contact person and the staff.
In specific implementation, according to the data source ods database, the external contact list, the external contact member list, and the employee client list including the mapping relationship between the employee and the client are obtained in the enterprise WeChat, and optionally, the obtained data may be up to the current day. In the specific implementation, the three pieces of table data are converted, cleaned, deduplicated and sorted according to time, and the three pieces of table information are associated and fused according to the client id to obtain the client basic information containing the client id, the client name, the client label and other contents at the latest time.
The meeting detail calculating module 3: and acquiring meeting information in the enterprise-level instant messaging application, and associating the meeting information to the employee basic information and the client basic information.
In a specific implementation, all conference data sources are aggregated by taking personnel (staff or clients) as a dimension, and optionally, conference data sources in enterprise WeChat include but are not limited to mail conferences, enterprise WeChat video conferences, enterprise WeChat voice conferences and conference invitations. Firstly, a session content table, a session invitation information table and an audio archiving information table are converted and cleaned, session id of the session content table is used for associating the session invitation information table with the audio archiving information, and aggregation processing is carried out to obtain enterprise wechat video conferences, enterprise wechat voice conferences and meeting invitation details. And the personnel id is associated to the client basic information table and the employee basic information table. Optionally, the person id may be associated with a calendar table, and the details of the person meeting are gathered, and optionally, the calendar table may be an office365 calendar table.
The cooperation detail calculating module 4: and acquiring the cooperation detail data of the employee in the enterprise-level instant messaging application according to the employee basic information and the client basic information which are associated with the conference information and the communication record in the enterprise-level instant messaging application.
Optionally, the cooperation detail calculating module 4 further includes:
the first cooperation statistical unit 41: and acquiring group communication records in the communication records, acquiring the employee basic information and the client basic information participating in the group communication, and aggregating and counting the group communication records, the employee basic information and the client basic information to acquire one-to-many first collaboration detail data.
In a specific implementation, the first collaboration detail data of the unit is a person group collaboration detail data, that is, one-to-many collaboration detail data, which is collaboration detail of each group (including group chat and meeting) with collaboration property in enterprise WeChat is counted by taking a person as a dimension for a time period, and optionally, the time period is 30 minutes. In specific implementation, a session content table with screened enterprise WeChat group chat properties is associated with internal group information and external group information according to a group id to further count group chat collaboration details, and then a personnel conference detail is associated according to the personnel id, and an aggregated result is the personnel group collaboration detail.
Second cooperation statistical unit 42: and acquiring one-to-one communication record in the communication records, acquiring the employee basic information in the one-to-one communication, and counting and calculating second cooperation detail data according to the one-to-one communication record and the employee basic information.
In specific implementation, the second collaboration detail data of the unit is a person collaboration detail data, that is, one-to-one collaboration detail data, and the session content table, the mail information table, and the chat file table are obtained according to the data source ids, optionally, the data may be data ending to the current day, the data is converted and cleaned, the session id of the session content table is correlated, and the person is used as a dimension, chat, mail, and meeting information is summarized and calculated according to a time period, so that the person collaboration detail is obtained, optionally, the time period may be 30 minutes.
Second cooperation statistical unit 43: acquiring team information including the upper-lower level relation of the staff according to the staff basic information, aggregating the first cooperation detail data and the second cooperation detail data according to the staff basic information, then associating the aggregated first cooperation detail data and the aggregated second cooperation detail data with the team information, and counting team cooperation detail data with the team as a dimension.
In the specific implementation, the personnel group cooperation details and the personnel cooperation details are collected, and are associated with the personnel id in the team member, so that statistics is respectively carried out according to the cooperation type and the cooperation period. And further acquiring a cooperation index with the dimension of the team, and optionally counting according to the day.
In addition, the collaborative statistics method in a communication application described in conjunction with fig. 1 may be implemented by an electronic device. Fig. 4 is a block diagram of an electronic device of the present invention.
The electronic device may comprise a processor 61 and a memory 62 in which computer program instructions are stored.
Specifically, the processor 61 may include a Central Processing Unit (CPU), or A Specific Integrated Circuit (ASIC), or may be configured to implement one or more Integrated circuits of the embodiments of the present Application.
The memory 62 may be used to store or cache various data files that need to be processed and/or used for communication, as well as possible computer program instructions that are executed by the processor 61.
The processor 61 reads and executes the computer program instructions stored in the memory 62 to implement the cooperative statistical method in any of the communication applications in the above embodiments.
In some of these embodiments, the electronic device may also include a communication interface 63 and a bus 60. As shown in fig. 4, the processor 61, the memory 62, and the communication interface 63 are connected via a bus 60 to complete communication therebetween.
The communication port 63 may be implemented with other components such as: the data communication is carried out among external equipment, image/data acquisition equipment, a database, external storage, an image/data processing workstation and the like.
The bus 60 includes hardware, software, or both to couple the components of the electronic device to one another. Bus 60 includes, but is not limited to, at least one of the following: data Bus (Data Bus), address Bus (Address Bus), control Bus (Control Bus), expansion Bus (Expansion Bus), and Local Bus (Local Bus). By way of example and not limitation, bus 60 may include an Accelerated Graphics Port (AGP) or other Graphics Bus, an Enhanced Industry Standard Architecture (EISA) Bus, a Front-Side Bus (FSB), a Hyper Transport (HT) Interconnect, an ISA (ISA) Bus, an InfiniBand (InfiniBand) Interconnect, a Low Pin Count (LPC) Bus, a memory Bus, a microchannel Architecture (MCA) Bus, a PCI (Peripheral Component Interconnect) Bus, a PCI-Express (PCI-X) Bus, a Serial Advanced Technology Attachment (SATA) Bus, a vlslave Bus, a Video Bus, or a combination of two or more of these suitable electronic buses. Bus 60 may include one or more buses, where appropriate. Although specific buses are described and shown in the embodiments of the application, any suitable buses or interconnects are contemplated by the application.
The electronic device may execute a collaborative statistics method in a communication application in the embodiment of the present application.
In addition, in combination with the collaborative statistical method in communication application in the foregoing embodiments, the embodiments of the present application may provide a computer-readable storage medium to implement the collaborative statistical method. The computer readable storage medium having stored thereon computer program instructions; the computer program instructions, when executed by a processor, implement a collaborative statistics method in any of the above-described embodiments.
And the aforementioned storage medium includes: a U-disk, a portable hard disk, a Read Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, an optical disk, or other various media capable of storing program codes.
The technical features of the embodiments described above may be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the embodiments described above are not described, but should be considered as being within the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, and these are all within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (6)
1. A method for collaborative statistics in a communication application, comprising:
acquiring employee information, namely acquiring basic employee information after gathering and de-duplicating employee information and organization information in enterprise-level instant messaging application;
a client information acquisition step, namely acquiring external contact person information in the enterprise-level instant messaging application, and acquiring basic client information according to the external contact person information and the relationship between the external contact person and the staff;
a conference detail calculation step, namely acquiring conference information in the enterprise-level instant messaging application and associating the conference information to the employee basic information and the client basic information;
a collaboration detail calculating step, namely acquiring collaboration detail data of the employee in the enterprise-level instant messaging application according to the employee basic information and the client basic information which are associated with the conference information and according to a communication record in the enterprise-level instant messaging application;
wherein the cooperation detail calculating step further comprises:
a first cooperation statistical step, namely acquiring group communication records in the communication records, acquiring the staff basic information and the client basic information participating in the group communication, and performing aggregation statistics on the group communication records, the staff basic information and the client basic information to acquire one-to-many first cooperation detail data;
and a second cooperation counting step, namely acquiring one-to-one communication record in the communication records, acquiring the employee basic information in the one-to-one communication, and counting and calculating second cooperation detail data according to the one-to-one communication record and the employee basic information.
2. The collaboration statistics method in messaging applications as claimed in claim 1, wherein the collaboration detail calculating step further comprises:
and a collaboration detail aggregation step, namely acquiring team information including the superior-subordinate relationship of the staff according to the staff basic information, aggregating the first collaboration detail data and the second collaboration detail data according to the staff basic information, then associating the aggregated first collaboration detail data and the aggregated second collaboration detail data with the team information, and counting team collaboration detail data with the team as a dimensionality.
3. A collaborative statistics system in a communication application, comprising:
the employee information acquisition module is used for acquiring basic employee information after gathering and de-duplicating employee information and organization information in enterprise-level instant messaging application;
the client information acquisition module acquires external contact information in the enterprise-level instant messaging application and acquires client basic information according to the external contact information and the relationship between the external contact and the staff;
the conference detail calculation module is used for acquiring the conference information in the enterprise-level instant messaging application and associating the conference information to the employee basic information and the client basic information;
the cooperation detail calculation module is used for acquiring cooperation detail data of the staff in the enterprise-level instant messaging application according to the staff basic information and the client basic information which are associated with the meeting information and the communication record in the enterprise-level instant messaging application;
wherein the cooperation detail calculating module further comprises:
the first collaboration statistical unit is used for acquiring group communication records in the communication records, acquiring the staff basic information and the client basic information participating in the group communication, and aggregating and counting the group communication records, the staff basic information and the client basic information to acquire one-to-many first collaboration detail data;
and the second cooperation statistical unit is used for acquiring one-to-one communication record in the communication records, acquiring the staff basic information in the one-to-one communication, and calculating second cooperation detail data according to the one-to-one communication record and the staff basic information.
4. The collaboration statistics system in a messaging application as in claim 3, wherein the collaboration detail computation module further comprises:
the cooperation detail aggregation unit is used for acquiring team information including the upper-lower level relation of the staff according to the staff basic information, aggregating the first cooperation detail data and the second cooperation detail data according to the staff basic information, then associating the aggregated first cooperation detail data and the aggregated second cooperation detail data with the team information, and counting team cooperation detail data with the team as a dimensionality.
5. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of collaborative statistics in a communication application according to any one of claims 1-2 when executing the computer program.
6. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out a method for collaborative statistics in a communication application according to any one of claims 1 to 2.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110388821.7A CN113037617B (en) | 2021-04-12 | 2021-04-12 | Collaborative statistical method, system, electronic equipment and storage medium in communication application |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110388821.7A CN113037617B (en) | 2021-04-12 | 2021-04-12 | Collaborative statistical method, system, electronic equipment and storage medium in communication application |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113037617A CN113037617A (en) | 2021-06-25 |
| CN113037617B true CN113037617B (en) | 2022-11-22 |
Family
ID=76456320
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110388821.7A Active CN113037617B (en) | 2021-04-12 | 2021-04-12 | Collaborative statistical method, system, electronic equipment and storage medium in communication application |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113037617B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114004487A (en) * | 2021-10-29 | 2022-02-01 | 北京明略昭辉科技有限公司 | Method and device for constructing data summarization model, electronic equipment and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102739565A (en) * | 2012-06-27 | 2012-10-17 | 用友软件股份有限公司 | System and method for associating business system with instant messaging |
| CN104052822A (en) * | 2014-06-27 | 2014-09-17 | 北京思特奇信息技术股份有限公司 | Enterprise address list and instant message group automatic synchronization method and system |
| CN104517208A (en) * | 2014-12-18 | 2015-04-15 | 四川联友电讯技术有限公司 | Group-based task cooperation method of enterprise mobile office system |
| CN104809003A (en) * | 2015-05-27 | 2015-07-29 | 张战 | Social design collaboration system |
| CN107633381A (en) * | 2011-10-05 | 2018-01-26 | 微软技术许可有限责任公司 | Multi-user and the cooperation of more equipment |
| US10805101B1 (en) * | 2019-12-21 | 2020-10-13 | Ringcentral, Inc. | Collaborative communications environment and automatic account creation thereof |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8782152B2 (en) * | 2012-03-07 | 2014-07-15 | International Business Machines Corporation | Providing a collaborative status message in an instant messaging system |
-
2021
- 2021-04-12 CN CN202110388821.7A patent/CN113037617B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107633381A (en) * | 2011-10-05 | 2018-01-26 | 微软技术许可有限责任公司 | Multi-user and the cooperation of more equipment |
| CN102739565A (en) * | 2012-06-27 | 2012-10-17 | 用友软件股份有限公司 | System and method for associating business system with instant messaging |
| CN104052822A (en) * | 2014-06-27 | 2014-09-17 | 北京思特奇信息技术股份有限公司 | Enterprise address list and instant message group automatic synchronization method and system |
| CN104517208A (en) * | 2014-12-18 | 2015-04-15 | 四川联友电讯技术有限公司 | Group-based task cooperation method of enterprise mobile office system |
| CN104809003A (en) * | 2015-05-27 | 2015-07-29 | 张战 | Social design collaboration system |
| US10805101B1 (en) * | 2019-12-21 | 2020-10-13 | Ringcentral, Inc. | Collaborative communications environment and automatic account creation thereof |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113037617A (en) | 2021-06-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11580504B2 (en) | Automatically detecting and storing digital data items associated with digital calendar items | |
| CN109471863B (en) | Information query method and device based on distributed database and electronic equipment | |
| US9002871B2 (en) | Method and system of mapreduce implementations on indexed datasets in a distributed database environment | |
| US8775464B2 (en) | Method and system of mapreduce implementations on indexed datasets in a distributed database environment | |
| CN110362544B (en) | Log processing system, log processing method, terminal and storage medium | |
| EP2506522A1 (en) | Method and device for pushing data | |
| US20190354514A1 (en) | Managing large scale association sets using optimized bit map representations | |
| JP2016530652A (en) | Interactive incident management system | |
| US20150074043A1 (en) | Distributed and open schema interactions management system and method | |
| CN109033404B (en) | Log data processing method, device and system | |
| CN109634951B (en) | Big data acquisition method, device, computer equipment and storage medium | |
| CN113037617B (en) | Collaborative statistical method, system, electronic equipment and storage medium in communication application | |
| CN107748753A (en) | It is a kind of based on double random extraction systems, method and device | |
| CN115858322A (en) | Log data processing method and device and computer equipment | |
| CN109597804B (en) | Customer merging method and device based on big data, electronic equipment and storage medium | |
| CN110727700A (en) | Method and system for integrating multi-source streaming data into transaction type streaming data | |
| CN110795423A (en) | Data extraction method for rapid cleaning and conversion | |
| CN111782886B (en) | Metadata management method and device | |
| US10296589B2 (en) | Grouping content based upon user activity | |
| CN103841001B (en) | social network information processing method and system | |
| CN109947702A (en) | Index structuring method and device, electronic equipment | |
| Bao et al. | Query optimization of massive social network data based on hbase | |
| CN113010382A (en) | Buried point data calculation method and device, storage medium and electronic equipment | |
| CN113077227B (en) | Method and device for processing chat quantity of enterprise information portal group and electronic equipment | |
| CN105550072B (en) | A kind of method and system of data backup |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |