| |

VerySource

 Forgot password?
 Register
Search
View: 21|Reply: 7

Discussion: How to design a complete plate for receiving and sending notifications?

[Copy link]

1

Threads

4

Posts

5

Credits

Newbie

Rank: 1

Credits
5

 China

Post time: 2020-2-21 13:00:01
| Show all posts |Read mode
As the title, I want to be a complete section for receiving and sending notifications. There are many departments within the entire website, and there are groups within the departments. Notifications can be sent to all departments, only to department leaders, or only to groups. Changhe department leaders can also be notices within the department (only people within the department can see), or they can only be issued to someone. After receiving the notification, the person receiving the notification should be prompted accordingly, and do not use a similar form of email. How to design a reasonable one?
Reply

Use magic Report

1

Threads

11

Posts

8

Credits

Newbie

Rank: 1

Credits
8

 China

Post time: 2020-5-2 16:30:01
| Show all posts
First, there must be an organizational structure management, such as
01 Head Office
0101 Department 1
010101 User A
010102 User B
0102 Department 2
010201 User C
...

When sending a message, each Msg corresponds to an organization structure number, such as 0101, which means that department 1 can be read by everyone, if the number is 010102, it means that only user B can read.

After a user logs in, he can determine all the notifications he can see through the LIKE statement according to his node number. For example, for user B, the SQL query statement is:
SELECT * FROM Message WHERE
       msgNo LIKE '010102%' OR msgNo = '0101' OR msgNo = '01 '
ORDER BY msgDate

Understand! !
Reply

Use magic Report

1

Threads

4

Posts

5

Credits

Newbie

Rank: 1

Credits
5

 China

 Author| Post time: 2020-5-4 23:30:01
| Show all posts
Then I want to send a message to certain people (not just one person). How do I construct the message number?
Reply

Use magic Report

1

Threads

11

Posts

8

Credits

Newbie

Rank: 1

Credits
8

 China

Post time: 2020-5-25 18:15:01
| Show all posts
Then a special table records the allowable reading structure number corresponding to each piece of information, such as:
msgID deptNo
1 010102
1 010103
1 0102
1 0104
2 0102
2 0103
Reply

Use magic Report

1

Threads

4

Posts

5

Credits

Newbie

Rank: 1

Credits
5

 China

 Author| Post time: 2020-5-31 16:00:01
| Show all posts
Then this is almost the same as the mail system. Ha ha, it ’s not that I ’m embarrassed by you. It ’s the customer ’s request to us. I really do n’t know of any way.
Reply

Use magic Report

0

Threads

9

Posts

8

Credits

Newbie

Rank: 1

Credits
8

 China

Post time: 2020-6-1 17:00:01
| Show all posts
Reply

Use magic Report

0

Threads

9

Posts

8

Credits

Newbie

Rank: 1

Credits
8

 China

Post time: 2020-6-1 17:15:04
| Show all posts
养狗的上帝
-------------------------------------------------- -----
This structure feels good.
msgID deptNo
1 0101; 0102; 0104 01, 02, 04 Department
2 01; everyone sees
3 010102; 010103; 0104; several people and a certain department.
Reply

Use magic Report

1

Threads

4

Posts

5

Credits

Newbie

Rank: 1

Credits
5

 China

 Author| Post time: 2020-6-3 11:30:02
| Show all posts
What I thought before was to create a table to store the notification title, content, etc., and then create a table to add everyone, and there is a field to specifically record the notification ID, and then the notification sent to the corresponding in the next table The ID of the notification is added to the field of the notification ID of the person's record. The IDs are separated by commas. The customer says that this is in the form of an email and cannot do this! The above buddies think the same as I think. Seek all methods except this one! Oh, everyone help!
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list