The realization of the salary slip issuing function of WeChat public account + web background

Demand Source

First of all, I will briefly introduce the business scenarios and needs. The company has to pay employees salaries every month. Before paying salaries, employees need to confirm whether the salary slips are correct.In the past, the company's personnel was taken from an excel screenshot one by one and then contacted offline one by one.This greatly affects work efficiency.

Business Processes and Ideas

What we have is the salary excel file prepared by finance, and this table needs to be imported into the back-end database first. You can use easyexcel or poi here. The back-end of the company needs to scan the face through WeChat. Indeed, at this time, we can obtain the unionid of the user.The third-party unique ID and open_id user's unique identification in the official account, and then the employee follows the official account
Summary, the prerequisites are as follows:
1. Data source: excel file import background
2. User'sopen_id and union_id
3. Messages are sent to the official WeChat account of employees, and employees need to follow the official account

Implement screenshots and specific designs

Background data page (operation page)
The content of the salary slip is a database encrypted field, which is not displayed in the front end, but is stored in the database.The main functions are to import salary content, push official account template messages, and conditionally filter salary slips

Employees receive a notification from the WeChat official account
Send a message push, and the user will receive a template message push from the WeChat official account

Employee salary details
Here is a single query interface to get the employee's salary slip content from the database

The interface related to this function The above is the interface written by the individual to implement the business.Want to call me in the source code comment area