CN110365498B

CN110365498B - Group new construction and message interaction method and system

Info

Publication number: CN110365498B
Application number: CN201910579635.4A
Authority: CN
Inventors: 邹争
Original assignee: Wuhan Guangzhi Information Technology Co ltd
Current assignee: Wuhan Guangzhi Information Technology Co ltd
Priority date: 2019-06-28
Filing date: 2019-06-28
Publication date: 2021-07-06
Anticipated expiration: 2039-06-28
Also published as: CN110365498A

Abstract

The invention relates to a group new-establishment and message interaction method and a system, which comprises the steps of establishing a first member table, a second member table, a group table and a group detailed table; creating a group according to a creation information packet sent by a first terminal held by one of first members in a first member table, the first member table, a second member table, a group table and a group detail table; respectively sending group messages to first terminals held by other first members and second terminals held by all second members in the group according to a group message packet sent by a first terminal held by one of the first members in the group; and creating a group message receiving table according to the condition that the first terminal held by each first member and the second terminal held by each second member in the group respectively read the group message, and acquiring a message interaction result according to the group message receiving table. The invention not only ensures the instantaneity and accuracy of message delivery, but also accurately and clearly reads the message feedback of the group members and obtains the message interaction result.

Description

Group new construction and message interaction method and system

Technical Field

The invention relates to the technical field of group information, in particular to a group reestablishment and message interaction method and system.

Background

Group functionality is one of the common and important functions in instant messaging applications. In actual use, a user in a group can send communication information to a server corresponding to an instant messaging application program, and the server forwards the received communication information to other users in the group, so that all users in the group can obtain the communication information sent by the user. Therefore, group functions such as check-in and card-punching, notification issuing, interaction and the like are used in many application scenarios, and some related web pages, APPs and applets are produced for these applications, typically with a nailed APP.

However, in these existing applications, the group creation method is to add people with the same characteristics or the same category into the group by the creator, and then check in and check out, issue notification, and exchange interaction are performed in the group. However, based on such a method for creating a new group and interacting messages, the instantaneity and accuracy of message delivery need to be improved, and the creator only knows the total number of people who check in and print a card, or only knows the successful issuance of a notification, or only knows the content of successful message delivery, but cannot receive the specific message feedback of the group members, that is, cannot obtain the message interaction result, for example, cannot know which members print a card or do not print a card, or cannot know which members read a notification or a group message, and the like.

And knowing the specific message feedback of the group members, acquiring the message interaction result, which is vital to the management of the group and can promote the group to operate better, thereby being beneficial to the large-scale use of the group functions.

Disclosure of Invention

The technical problem to be solved by the present invention is to provide a method and a system for group creation and message interaction, which can realize instant message sending and message receiving among members in a group, ensure the instant message sending and accuracy, accurately obtain the message feedback of the group members, obtain the message interaction result, and really realize point-to-point message interaction.

The technical scheme for solving the technical problems is as follows:

a group new building and message interaction method comprises the following steps:

the server creates at least four data tables; the at least four data tables at least comprise a first member table, a second member table, a group table and a group detail table, wherein the first member table comprises a plurality of first members, and the second member table comprises a plurality of second members;

the server creates a group according to a creation information packet sent by a first terminal held by one of the first members in the first member table and the first member table, the second member table, the group table and the group detail table; wherein the group comprises at least one first member and at least one second member;

the server respectively sends group messages to first terminals held by other first members in the group and second terminals held by all second members in the group according to a group message packet sent by a first terminal held by one first member in the group;

and the server respectively reads the group message according to the condition that the first terminal held by each first member in the group and the second terminal held by each second member in the group, creates a group message receiving table and acquires a message interaction result according to the group message receiving table.

The invention has the beneficial effects that: the server adds at least one first member (in the first member table) and at least one second member (in the second member table) which need to be added to the created group respectively according to a created information packet sent by a first terminal held by the first member and the first member table, the second member table, the group table and the group detail table based on the created four data tables including the first member table, the second member table, the group table and the group detail table, so as to realize new group creation; the server sends the group message to terminals held by other members in the newly-built group according to the group message packet sent by the first terminal held by one of the first members in the group and also according to the first member table, the second member table, the group table and the group detail table, namely the first terminals held by the other first members and the second terminals held by all the second members, so as to realize the sending and receiving of the instant group message; finally, the server creates a group message receiving table according to the situation that the first terminal held by each first member and the second terminal held by each second member in the group respectively read the group messages, and the situation that each member reads the group messages can be counted according to the group message receiving table; the group may further include a plurality (more than one) of first members, any one of the first members may create the group, send and receive the group message, and the first member creating the group and the first member receiving and sending the group message may be the same person or may not be the same person.

The group creation and message interaction method of the invention not only ensures the instantaneity and accuracy of message delivery, but also can clearly master whether each member reads the sent group message, namely accurately and clearly reads the message feedback of the group members, obtains the message interaction result, really realizes point-to-point message interaction, and can promote the group to operate better, thereby being beneficial to the large-scale use of group functions.

On the basis of the technical scheme, the invention can be further improved as follows:

further: the specific steps of creating at least four of the data tables at least comprise:

configuring a first primary key ID for the first member table and configuring a second primary key ID for the second member table;

allocating a first identification field for identifying identity to each first member in the first member table, and allocating a second identification field for identifying identity to each second member in the second member table;

the group table is respectively associated with the group detail table, the first member table and the second member table, the group detail table is respectively associated with the first member table and the second member table, and at least an association relationship between the group table and the first member table and the second member table is recorded in the group detail table.

The beneficial effects of the further scheme are as follows: the first identification field is distributed to each first member in the first member table, is used for identifying the identity of each first member, and has uniqueness; the first primary key ID configured for the first member table and the second primary key ID configured for the second member table are both incremental primary key IDs, and the query effect of the database can be ensured and improved, so that the first member needing to be added into the group can be conveniently searched according to the first member table subsequently through the ID of the type and the first identification field, and the second member needing to be added into the group can be conveniently searched according to the first member table subsequently through the ID of the type and the second identification field; the group table is respectively associated with the group detail table, the first member table and the second member table, the group detail table is respectively associated with the first member table and the second member table, and the group detail table records the association relationship between the group table and the first member table and the second member table, so that on one hand, each newly-built group is respectively associated with the corresponding first member and second member, thereby being convenient for realizing that members with different identity attributes can be planned by different groups, on the other hand, after a subsequent newly-built group is created, the group message is immediately and accurately sent to each member in the newly-built group, and the condition of reading the group message is fed back; the first identification field and the second identification field can be in any form, such as numbers, school numbers, job numbers and the like; the association between the data tables is in the prior art, for example, the association is performed through the foreign key ID, which is not described in detail again.

Further: the creation information packet at least comprises the first primary key ID, the second primary key ID and the group name which are selected by one first member in the first member table through a first terminal;

the specific steps of creating the group include:

searching a first identification field corresponding to at least one first member in the first member table according to the first primary key ID; searching a second identification field corresponding to at least one second member in the second member table according to the second primary key ID;

inserting the group name into the group table, and generating a group ID corresponding to the group name;

and respectively inserting the group ID and all the searched first identification fields and all the searched second identification fields into the group detail table, and creating the group according to the group detail table.

The beneficial effects of the further scheme are as follows: the first main key ID, the second main key ID and the group name are selected (or input) by a first member through a front-end interface of a first terminal, and a first identification field corresponding to each first member needing to be added into the newly-built group and a second identification field corresponding to each second member needing to be added into the newly-built group are respectively found in a first member table and a second member table respectively through the first main key ID and the second main key ID, so that the corresponding first member and the second member are added into the newly-built group; and then inserting the group name selected or input by the first member into the group table, generating a group ID corresponding to the group name, respectively inserting the group ID and all the first identification fields and all the second identification fields which are correspondingly searched into the group detailed table, and creating a group, so that the group information can be ensured to be immediately and accurately sent and received and the information interaction result can be accurately obtained according to the association relationship of each data table and the association relationship of the first identification fields, the second identification fields and the group ID.

Further: the group message packet at least comprises the group name and the message content selected by one first member in the group through a first terminal;

the specific step of sending the group message includes:

acquiring the group ID corresponding to the group name according to the group name;

searching all first identification fields and all second identification fields corresponding to the group ID in the group detail table according to the group ID;

and calling a message interface, respectively sending the message content to first terminals held by first members corresponding to each first identification field corresponding to the group ID according to each first identification field corresponding to the group ID, and respectively sending the message content to second terminals held by second members corresponding to each second identification field corresponding to the group ID according to each second identification field corresponding to the group ID.

The beneficial effects of the further scheme are as follows: in the process of creating the group, the group name and the group ID have a corresponding relationship, and the group ID has uniqueness, so that the corresponding group can be searched in the group detail table, and since the group ID has a corresponding relationship with all the first identification fields and all the second identification fields corresponding to the group ID (namely all the first members and all the second members included in the group), all the first identification fields and all the second identification fields corresponding to the group ID can be searched in the group message table, so that the group message can be sent to the first terminals held by the first members corresponding to the group ID according to each first identification field, and the group message can be sent to the second terminals held by the second members corresponding to the group ID according to each second identification field; the group message is sent through the steps, so that the instantaneity and the accuracy of message delivery can be obviously improved.

Further: the group message receiving table at least comprises a one-to-one corresponding third identification field for identifying the condition that the first terminal held by each first member in the group respectively reads the group message, or a one-to-one corresponding third identification field for identifying the condition that the second terminal held by each second member in the group respectively reads the group message, and the group message receiving table is respectively associated with the first member table and the second member table;

the specific steps of obtaining the message interaction result comprise:

when a first terminal held by any first member in the group reads the group message, calling the message interface to acquire a first identification field corresponding to the first member corresponding to the first terminal and change the value of a third identification field corresponding to the first terminal, and/or when a second terminal held by any second member in the group reads the group message, calling the message interface to acquire a second identification field corresponding to the second member corresponding to the second terminal and change the value of the third identification field corresponding to the second terminal;

and acquiring the message interaction result according to the values of the first identification fields corresponding to all the first members in the group one to one, the values of the third identification fields corresponding to the first terminals supported by all the first members in the group one to one, the values of the second identification fields corresponding to all the second members in the group one to one and the values of the third identification fields corresponding to the second terminals supported by all the second members in the group one to one.

The beneficial effects of the further scheme are as follows: the group message receiving table records a third identification field for identifying a case where the first terminal held by each first member and the second terminal held by each second member in the group read the group message, when any one of the first terminals and/or any one of the second terminals read the group message, the value of the corresponding third identification field is changed, the group message receiving table records the changed value, thereby facilitating counting the total number of persons reading the group message according to the value of each changed third identification field, and at the same time, since the group message receiving table is respectively associated with the first member table and the second cost table, the value of each third identification field corresponds to one of the first identification field or the second identification field, it is thus possible to determine which first member or second member has read the group message in particular from the value of the third identification field; through the steps, the feedback result of the reading condition of the group message, namely the message interaction result, can be accurately obtained, so that the point-to-point message interaction is really realized, the better operation of the group can be promoted, and the large-scale use of the group function is facilitated; the third identification field may be in any form, for example, an "is receive" field, and when the first terminal corresponding to any first member and/or the second terminal corresponding to any second member read the group message, and the value of the "is receive" field corresponding to the first terminal and/or the second terminal changes from 0 to 1, it can be known explicitly which member in the group read the group message according to the case that the field value is 0 or 1.

According to another aspect of the present invention, a group creation and message interaction system is provided, which includes a server, at least one first terminal and at least one second terminal, where the at least one first terminal and the at least one second terminal are both in communication connection with the server;

the server comprises a data table creating module, a receiving module, a group creating module, a sending module and an interaction result acquiring module;

the data table creating module is used for creating at least four data tables; the at least four data tables at least comprise a first member table, a second member table, a group table and a group detail table, wherein the first member table comprises a plurality of first members, and the second member table comprises a plurality of second members;

the receiving module is used for receiving a creation information packet sent by a first terminal held by one of the first members in the first member table;

the group creating module is used for creating a group according to the creating information packet and the first member table, the second member table, the group table and the group detail table; wherein the group comprises at least one first member and at least one second member;

the receiving module is further configured to receive a group message packet sent by a first terminal held by one of the first members in the group;

the sending module is used for respectively sending group messages to the first terminals held by the other first members in the group and the second terminals held by all the second members in the group according to the group message packet;

the data table creating module is further configured to create a group message receiving table according to a situation that the first terminal held by each first member in the group and the second terminal held by each second member in the group respectively read the group message;

the interactive result acquisition module is used for acquiring a message interactive result according to the group message receiving table;

the first terminal is held by a first member in the first member table, and is used for sending the creation information packet, sending the group message packet, and receiving the group message;

the second terminal is held by a second member in the second member table and is used for receiving the group message.

The invention has the beneficial effects that: the server comprises a data table creating module, a receiving module, a group creating module, a sending module and an interaction result acquiring module, and is based on four data tables created by the data packet creating module, wherein the four data tables comprise a first member table, a second member table, a group table and a group detail table; a receiving module of the server receives a group message packet sent by a first terminal held by one first member in the group, and a sending module sends the group message to terminals held by other members in the newly-built group, namely the first terminals held by the other first members and second terminals held by all second members, according to the first member table, the second member table, the group table and the group detail table, so as to realize the sending and receiving of the instant group message; finally, the interaction result acquisition module of the server creates a group message receiving table according to the condition that the first terminal held by each first member in the group and the second terminal held by each second member in the group read the group messages respectively, and can count the condition that each member reads the group messages according to the group message receiving table;

the group new establishment and message interaction system not only ensures the instantaneity and accuracy of message delivery, but also can clearly master whether each member reads the sent group message, namely accurately and clearly reads the message feedback of the group members to obtain the message interaction result, really realizes point-to-point message interaction, and can promote the group to better operate, thereby being beneficial to the large-scale use of group functions.

further: the data table creation module is specifically configured to:

The beneficial effects of the further scheme are as follows: the first primary key ID and the second primary key ID configured by the data table creating module are both incremental primary key IDs, and can ensure and improve the query effect of the database, so that the first member needing to be added into the group can be conveniently searched according to the first member table subsequently through the ID of the type and the first identification field, and the second member needing to be added into the group can be conveniently searched according to the first member table subsequently through the ID of the type and the second identification field; the group table is respectively associated with the group detail table, the first member table and the second member table, the group detail table is respectively associated with the first member table and the second member table, and the group detail table records the association relationship between the group table and the first member table and the second member table, so that on one hand, each newly-built group is respectively associated with the corresponding first member and the second member, thereby being convenient for realizing that members with different identity attributes can be planned by different groups, on the other hand, after a subsequent newly-built group is created, the group message is immediately and accurately sent to each member in the newly-built group, and the condition of reading the group message is fed back.

the group creation module is specifically configured to:

The beneficial effects of the further scheme are as follows: the group creation module finds a first identification field corresponding to each first member needing to be added into the newly-built group one by one in the first member table and finds a second identification field corresponding to each second member needing to be added into the newly-built group one by one in the second member table through the first main key ID and the second main key ID respectively, so that the first member and the second member which correspond to each other are added into the newly-built group; and then inserting the group name selected or input by the first member into the group table, generating a group ID corresponding to the group name, respectively inserting the group ID and all the first identification fields and all the second identification fields which are correspondingly searched into the group detailed table, and creating a group, so that the group information can be ensured to be immediately and accurately sent and received and the information interaction result can be accurately obtained according to the association relationship of each data table and the association relationship of the first identification fields, the second identification fields and the group ID.

the sending module is specifically configured to:

The beneficial effects of the further scheme are as follows: the sending module can search the corresponding group in the group detail table, and can search all the first identification fields and all the second identification fields corresponding to the group ID in the group message table because the group ID has corresponding relations with all the first identification fields and all the second identification fields (namely all the first members and all the second members contained in the group), thereby being convenient for sending the group message to the first terminal held by the corresponding first member according to each first identification field and sending the group message to the second terminal held by the corresponding second member according to each second identification field, and being capable of obviously improving the instant and accuracy of message delivery.

Further: the group message receiving table at least comprises a one-to-one corresponding third identification field for identifying the condition that the first terminal supported by each first member in the group respectively reads the group message, or a one-to-one corresponding third identification field for identifying the condition that the second terminal supported by each second member in the group respectively reads the group message, and the group message receiving table is respectively associated with the first member table and the second member table;

the interaction result obtaining module is specifically configured to:

The beneficial effects of the further scheme are as follows: the group message receiving table records a third identification field for identifying a case where the first terminal held by each first member and the second terminal held by each second member in the group read the group message, when any one of the first terminals and/or any one of the second terminals read the group message, the value of the corresponding third identification field is changed, the group message receiving table records the changed value, thereby facilitating counting the total number of persons reading the group message according to the value of each changed third identification field, and at the same time, since the group message receiving table is respectively associated with the first member table and the second cost table, the value of each third identification field corresponds to one of the first identification field or the second identification field, it is thus possible to determine which first member or second member has read the group message in particular from the value of the third identification field; the interactive result acquisition module can accurately acquire the feedback result of the reading condition of the group message, namely the message interactive result, thereby really realizing point-to-point message interaction, promoting better group operation and being beneficial to large-scale group function use.

Drawings

FIG. 1 is a schematic flow chart of a group creation and message interaction method according to the present invention;

FIG. 2 is a flowchart illustrating the creation of at least four data tables according to one embodiment of the present invention;

FIG. 3 is a schematic diagram illustrating a process of creating a group according to an embodiment of the present invention;

FIG. 4 is a schematic diagram of an operation interface for creating a group according to an embodiment of the present invention;

fig. 5 is a flowchart illustrating a group message sending process according to an embodiment of the present invention;

fig. 6 is a schematic flow chart illustrating a process of obtaining a message interaction result according to a first embodiment of the present invention;

fig. 7 is a schematic structural diagram of a group creation and message interaction system according to the present invention.

Detailed Description

The principles and features of this invention are described below in conjunction with the following drawings, which are set forth by way of illustration only and are not intended to limit the scope of the invention.

The present invention will be described with reference to the accompanying drawings.

In an embodiment, as shown in fig. 1, a group creation and message interaction method includes the following steps:

s1: the server creates at least four data tables; the at least four data tables at least comprise a first member table, a second member table, a group table and a group detail table, wherein the first member table comprises a plurality of first members, and the second member table comprises a plurality of second members;

s2: the server creates a group according to a creation information packet sent by a first terminal held by one of the first members in the first member table and the first member table, the second member table, the group table and the group detail table; wherein the group comprises at least one first member and at least one second member;

s3: the server respectively sends group messages to first terminals held by other first members in the group and second terminals held by all second members in the group according to a group message packet sent by a first terminal held by one first member in the group;

s4: and the server respectively reads the group message according to the condition that the first terminal held by each first member in the group and the second terminal held by each second member in the group, creates a group message receiving table and acquires a message interaction result according to the group message receiving table.

Based on the created four data tables including the first member table, the second member table, the group table and the group detail table, the server can add at least a first member (in the first member table) and at least a second member (in the second member table) to be added to the created group according to the first member table, the second member table, the group table and the group detail table according to the created information packet sent by the first terminal held by the first member, so as to realize new group creation; the server sends the group message to terminals held by other members in the newly-built group according to the group message packet sent by the first terminal held by one of the first members in the group and also according to the first member table, the second member table, the group table and the group detail table, namely the first terminals held by the other first members and the second terminals held by all the second members, so as to realize the sending and receiving of the instant group message; finally, the server creates a group message receiving table according to the situation that the first terminal held by each first member and the second terminal held by each second member in the group respectively read the group messages, and the situation that each member reads the group messages can be counted according to the group message receiving table;

the group creation and message interaction method of the embodiment not only ensures the instantaneity and accuracy of message delivery, but also can clearly master whether each member reads the sent group message, namely accurately and clearly reads the message feedback of the group members, obtains the message interaction result, really realizes point-to-point message interaction, and can promote the group to operate better, thereby being beneficial to the large-scale use of group functions.

Specifically, the group creation and message interaction method of the embodiment is applied to a WeChat applet for attendance check in a school, wherein a first member table is a teacher table, a second member table is a student table, and correspondingly, a first terminal is a teacher end and a second terminal is a student end; specifically, the group of this embodiment includes a teacher and a plurality of students, the sending creation packet and the group message packet are both operated by the teacher through the front-end interface of the held teacher, and after the teacher sends the group message, the front-end interface of the teacher also displays the group message sent by the teacher, and each student in the group receives and reads the group message through the held student.

Preferably, as shown in fig. 2, in S1, the specific steps of creating at least four data tables at least include:

s101: configuring a first primary key ID for the first member table and configuring a second primary key ID for the second member table;

s102: allocating a first identification field for identifying identity to each first member in the first member table, and allocating a second identification field for identifying identity to each second member in the second member table;

The first identification field distributed to each first member in the first member table is used for identifying the identity of each first member and has uniqueness, and similarly, the second identification field is used for identifying the identity of each second member and also has uniqueness; the first primary key ID configured by the first member table and the second primary key ID configured by the second member table are both incremental primary key IDs, and the query effect of the database can be ensured and improved, so that the first member needing to be added into the group can be conveniently searched according to the first member table subsequently through the ID of the type and the first identification field, and the second member needing to be added into the group can be conveniently searched according to the first member table subsequently through the ID of the type and the second identification field; the group table is respectively associated with the group detail table, the first member table and the second member table, the group detail table is respectively associated with the first member table and the second member table, and the group detail table records the association relationship between the group table and the first member table and the second member table, so that on one hand, each newly-built group is respectively associated with the corresponding first member and second member, thereby being convenient for realizing that members with different identity attributes can be planned by different groups, on the other hand, after a subsequent newly-built group is created, the group message is immediately and accurately sent to each member in the newly-built group, and the condition of reading the group message is fed back; the association between the data tables is in the prior art, for example, the association is performed through the foreign key ID, which is not described in detail again.

Specifically, in this embodiment, a first primary key ID is configured for the teacher table, a second primary key ID is configured for the student table, a unique identity-identifying work number, such as T2019010101, is assigned to each teacher in the teacher table, a unique identity-identifying student number, such as S2019010101, is assigned to each student in the student table, and all the work numbers and all the student numbers are not repeated. The method is applied to the WeChat applet, so that the job number and the WeChat openid of each teacher are recorded in a teacher table, and the student number and the WeChat openid of each student are recorded in a student table, wherein when the teacher logs in the WeChat applet through a teacher end, the corresponding WeChat openid is recorded in the teacher table, when the student logs in the WeChat applet through a student end, the corresponding WeChat openid is recorded in the student table, and the WeChat openid is the prior art, has uniqueness and is not repeated in detail.

Specifically, in the present embodiment, the group table is respectively associated with the group detail table, the teacher table and the student table, the group detail table is respectively associated with the teacher table and the student table, and at least an association relationship between the group table and the teacher table and an association relationship between the group table and the student table are recorded in the group detail table.

Preferably, the creation information packet at least includes the first primary key ID, the second primary key ID and the group name selected by one of the first members in the first member table through the first terminal;

as shown in fig. 3, in S2, the specific step of creating the group includes:

s201: searching a first identification field corresponding to at least one first member in the first member table according to the first primary key ID; searching a second identification field corresponding to at least one second member in the second member table according to the second primary key ID;

s202: inserting the group name into the group table, and generating a group ID corresponding to the group name;

s203: and respectively inserting the group ID and all the searched first identification fields and all the searched second identification fields into the group detail table, and creating the group according to the group detail table.

The first main key ID, the second main key ID and the group name are selected (or input) by a first member through a front-end interface of a first terminal, and a first identification field corresponding to each first member needing to be added into the newly-built group and a second identification field corresponding to each second member needing to be added into the newly-built group are respectively found in a first member table and a second member table respectively through the first main key ID and the second main key ID, so that the corresponding first member and the second member are added into the newly-built group; and then inserting the group name selected or input by the first member into the group table, generating a group ID corresponding to the group name, inserting the group ID and all the first identification fields and all the second identification fields which are correspondingly searched into the group detailed table, and creating and obtaining a group, so that the group information can be ensured to be immediately and accurately sent and received and the information interaction result can be accurately obtained according to the association relationship of each data table and the association relationship of the first identification fields, the second identification fields and the group ID.

Specifically, as shown in the schematic view of the operation interface shown in fig. 4, in this embodiment, the teacher submits the selected or input information through the first primary key ID (i.e., the corresponding teacher table), the second primary key ID (i.e., the corresponding student table) and the group name selected by the teacher end, and the information further includes the number of the group persons, the group creation time, and the like, and the teacher end packages all the submitted information into a creation information packet and sends the creation information packet to the server; the server searches a corresponding teacher work number in a corresponding teacher table according to the first main key ID, searches a corresponding student number in a corresponding student table according to the second main key ID, inserts the group name into a group table to generate a corresponding group ID, inserts all the searched teacher work numbers, all the searched student numbers and the group ID into a group detailed table, and creates a group consistent with the group name according to the group detailed table; more specifically, the group in this embodiment includes one teacher, and therefore one teacher job number is searched.

Preferably, the group message packet at least includes the group name and message content selected by one first member in the group through a first terminal;

as shown in fig. 5, in S3, the specific step of sending the group message includes:

s301: acquiring the group ID corresponding to the group name according to the group name;

s302: searching all first identification fields and all second identification fields corresponding to the group ID in the group detail table according to the group ID;

s303: and calling a message interface, respectively sending the message content to first terminals held by first members corresponding to each first identification field corresponding to the group ID according to each first identification field corresponding to the group ID, and respectively sending the message content to second terminals held by second members corresponding to each second identification field corresponding to the group ID.

In the process of creating the group, the group name and the group ID have a corresponding relationship, and the group ID has uniqueness, so that a corresponding group can be searched in the group detail table, and all the first identification fields and all the second identification fields corresponding to the group ID can be searched in the group message table because the group ID has a corresponding relationship with all the first identification fields and all the second identification fields, thereby facilitating the subsequent sending of the group message to the first terminals held by the corresponding first members according to each first identification field and the sending of the group message to the second terminals held by the corresponding second members according to each second identification field; the group message is sent through the steps, so that the instantaneity and the accuracy of message delivery can be obviously improved.

Specifically, in this embodiment, when a teacher selects a group name through a teacher end, a group message is filled in, the group name and the group message are packaged into a group message packet and then sent and stored in a server, when the server obtains a corresponding group ID according to the group name, and then finds all teacher employee numbers and all student numbers according to the group ID, meanwhile, since the teacher table also records the WeChat openid of the teacher and the student tables also record the WeChat openid of the students, and the teacher table and the student tables are respectively associated with a group detailed table, the server calls a WeChat template message interface to send the group message to the teacher end and the student end; when a teacher logs in the WeChat applet through a teacher end or a student end, a link program in a click message can present a message list related to the user by judging the WeChat openid of the user, and then the corresponding group message can be received and read by clicking a message entry and entering a message detail page.

Preferably, the group message receiving table at least includes a one-to-one third identification field for identifying a situation that the first terminal held by each first member in the group respectively reads the group message, or a one-to-one third identification field for identifying a situation that the second terminal held by each second member in the group respectively reads the group message, and the group message receiving table is associated with the first member table and the second member table respectively;

as shown in fig. 6, in S4, the specific step of obtaining the message interaction result includes:

s401: when a first terminal held by any first member in the group reads the group message, calling the message interface to acquire the first identification field corresponding to the first member corresponding to the first terminal and change the value of the third identification field corresponding to the first terminal, and/or when a second terminal held by any second member in the group reads the group message, calling the message interface to acquire the second identification field corresponding to the second member corresponding to the second terminal and change the value of the third identification field corresponding to the second terminal;

s402: and acquiring the message interaction result according to the values of the first identification fields corresponding to all the first members in the group one to one, the values of the third identification fields corresponding to the first terminals supported by all the first members in the group one to one, the values of the second identification fields corresponding to all the second members in the group one to one and the values of the third identification fields corresponding to the second terminals supported by all the second members in the group one to one.

The group message receiving table records a third identification field for identifying a case where the first terminal held by each first member and the second terminal held by each second member in the group read the group message, when any one of the first terminals and/or any one of the second terminals read the group message, the value of the corresponding third identification field is changed, the group message receiving table records the changed value, thereby facilitating counting the total number of persons reading the group message according to the value of each changed third identification field, and at the same time, since the group message receiving table is respectively associated with the first member table and the second cost table, the value of each third identification field corresponds to one of the first identification field or the second identification field, it is thus possible to determine which first member or second member has read the group message in particular from the value of the third identification field; through the steps, the feedback result of the reading condition of the group message, namely the message interaction result, can be accurately obtained, so that the point-to-point message interaction is really realized, the better operation of the group can be promoted, and the large-scale use of the group function is facilitated.

Specifically, the third identification field in this embodiment is an "is receive" field, and when any one of the first terminals and/or any one of the second terminals reads the group message, the value of the corresponding "is receive" field is changed from 0 to 1; when a teacher logs in the WeChat applet through a teacher end or a student end, the teacher clicks a link program in the message, and a message list related to the user is presented by judging the WeChat openid of the user, then clicking the message entry to enter a message detail page to receive and read the corresponding group message, the WeChat applet calls a server message interface, the calling carries the teacher's job number and the corresponding WeChat openid, or the student's school number and the WeChat openid, and changes the value of the "is receive" field corresponding thereto from 0 to 1, and therefore, the number of members reading the group message can be counted according to the total number of changes, and according to the school number corresponding to the value of the field of changing the is receive, which students read the group message can be accurately known, and/or, according to the work number corresponding to the value of the field of 'is receive', which teachers read the group message can be accurately known.

Specifically, the group message may be a check-in notification, a notice, or an interactive message. For example, when the group message is a sign-in notification, it is clear how many students sign in, which students are already signed in, and which students are absent, by counting the value of the "is receive" field.

Embodiment two, as shown in fig. 7, a group creation and message interaction system applied to the group creation and message interaction system of embodiment one includes a server, at least one first terminal and at least one second terminal, where the at least one first terminal and the at least one second terminal are respectively in communication connection with the server;

the receiving module is used for receiving a creation information packet sent by a first terminal held by one of the first members in the first member table; wherein the group comprises at least one first member and at least one second member;

the group creating module is used for creating a group according to the creating information packet and the first member table, the second member table, the group table and the group detail table;

the data table creating module is further configured to create a group message receiving table according to a situation that the first terminal held by each first member in the group and the second terminal held by each second member in the group read the group message;

Preferably, the data table creating module is specifically configured to:

the group creation module is specifically configured to:

the sending module is specifically configured to:

the interaction result obtaining module is specifically configured to:

The server comprises a data table creating module, a receiving module, a group creating module, a sending module and an interaction result acquiring module, and is based on four data tables created by the data packet creating module, wherein the four data tables comprise a first member table, a second member table, a group table and a group detail table; a receiving module of the server receives a group message packet sent by a first terminal held by one first member in the group, and a sending module sends the group message to terminals held by other members in the newly-built group, namely the first terminals held by the other first members and second terminals held by all second members, according to the first member table, the second member table, the group table and the group detail table, so as to realize the sending and receiving of the instant group message; finally, the interaction result acquisition module of the server creates a group message receiving table according to the condition that the first terminal held by each first member in the group and the second terminal held by each second member in the group read the group messages respectively, and can count the condition that each member reads the group messages according to the group message receiving table;

the group creation and message interaction system of the embodiment not only ensures the instantaneity and accuracy of message delivery, but also can clearly master whether each member reads the sent group message, namely accurately and clearly reads the message feedback of the group members, obtains the message interaction result, really realizes point-to-point message interaction, and can promote the group to operate better, thereby being beneficial to the large-scale use of group functions.

Specifically, the first terminal in this embodiment is a teacher terminal, and the second terminal is a student terminal.

For details of the group creation and message interaction method in this embodiment, refer to the detailed description of the first embodiment and fig. 1 to 6, which are not described herein again.

The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.

Claims

1. A group new establishment and message interaction method is characterized by comprising the following steps:

the server respectively reads the situation of the group message according to a first terminal held by each first member in the group and a second terminal held by each second member in the group, creates a group message receiving table and obtains a message interaction result according to the group message receiving table;

the specific steps of creating at least four of the data tables at least comprise:

the group table is respectively associated with the group detail table, the first member table and the second member table, the group detail table is respectively associated with the first member table and the second member table, and at least the association relationship between the group table and the first member table and the second member table is recorded in the group detail table; the group message receiving table at least comprises a one-to-one corresponding third identification field for identifying the condition that the first terminal held by each first member in the group respectively reads the group message, or a one-to-one corresponding third identification field for identifying the condition that the second terminal held by each second member in the group respectively reads the group message, and the group message receiving table is respectively associated with the first member table and the second member table;

the creation information packet at least comprises the first primary key ID, the second primary key ID and the group name which are selected by one first member in the first member table through a first terminal;

the specific steps of creating the group include:

2. The method according to claim 1, wherein the group message packet at least includes the group name and message content selected by a first member in the group via a first terminal;

the specific step of sending the group message includes:

3. The group new creating and message interacting method of claim 2, wherein the specific step of obtaining the message interaction result comprises:

4. A group reestablishment and message interaction system is characterized by comprising a server, at least one first terminal and at least one second terminal, wherein the at least one first terminal and the at least one second terminal are in communication connection with the server respectively;

the second terminal is held by a second member in the second member table and is used for receiving the group message;

the data table creation module is specifically configured to:

the group creation module is specifically configured to:

5. The group creation and message interaction system of claim 4 wherein the group message packet includes at least the group name and message content selected by a first member of the group via a first terminal;

the sending module is specifically configured to:

calling a message interface, respectively sending the message content to first terminals held by first members corresponding to each first identification field corresponding to the group ID according to each first identification field corresponding to the group ID, and respectively sending the message content to second terminals held by second members corresponding to each second identification field corresponding to the group ID according to each second identification field corresponding to the group ID.

6. The group creation and message interaction system of claim 5, wherein the interaction result obtaining module is specifically configured to:

and acquiring the message interaction result according to the first identification fields corresponding to all the first members in the group one to one, the values of the third identification fields corresponding to the first terminals supported by all the first members in the group one to one, and the values of the second identification fields corresponding to all the first members in the group one to one and the values of the third identification fields corresponding to the second terminals supported by all the second members in the group one to one.