Automatically upload new data to the database as soon as it is available

Question

Requirement: Implement automatic uploading of data as soon as the database has data

Explanation of requirement: I have done a hospital electronic hair bleaching project before. The requirement is like this. After the outpatient fee office checks out, the database will appear. The patient's payment information is then uploaded to the provincial tax platform to generate an electronic payment. What we did before was that when there was a new payment, it was displayed on the page. The charging personnel clicked to upload, and the data was uploaded. Now they think it is too busy and it is troublesome to go to the click to upload. I asked if it can be done as soon as possible. If there is new payment data, the program will automatically detect it and upload it automatically. But to retain the function of manual click upload, you can choose to upload automatically, or you can choose not to upload automatically and manually click and generate it yourself.

Answer 1

Just write a queue and execute it automatically

Answer 2

Write an upload script, then use Linux to do a regular task, and execute it when the time comes