Database with many changes

Question

Database with many changes

Asked 6 years, 10 months ago

Viewed 51 times

0

Situation

I’m making a system for a drug store. The Customer can enter the pharmacy and pick up products only from the gonad and pass directly to the cashier, or can pass the counter and pick up only the antibiotic at the counter with pharmacist, or can also go through the counter and the gonad and then pass the cash.

When the customer passes by the counter to pick up an antibiotic with bull, he gets a commands with a number, and the head number is tied to the antibiotic he caught with the pharmacist.

If the customer picks up a product in the gonad, the product will not be placed in charge, he can pass the product straight into the box.

When the customer passes the box, whoever is in the box puts the number of the command (if you have it) that will display the products taken on the counter plus the products taken on the gonad (if you have it). Once the purchase is complete, the system deletes the command data.

My Problem

command constantly varies the stored data. Does it pay to store the command data in Mysql? Or is there a way to pass this change in a more efficient way by reducing the changes in Mysql? What would be the best method?

I was thinking that it would be very nice if I had an array to store these products in the command, and if I had a way to pass this array between the counter computer and the cashier computer.

I am open to suggestions, which language would be the most appropriate? What should I use? What is the method?

Additional Information

It is being developed using HTML, JS, PHP and Mysql.
Will be hosted on an Ubuntu Server

2

have to store in the bank yes, this is also known as pre-sale, and if your status is under PAF-ECF legislation, you have to keep the items in the pre-sale open for 2 days (unless mistaken), and then issue the items on the ECF and cancel the sale. If you do not have PAF-ECF, but easy, you will always need to store in the bank

– Rovann Linhalis

2017/08/29 at 22:24
In this situation, the website is used as the store’s internal system. The command is a kind of pre-sale, but lasts only a maximum of one day, since the person does not take the command home.

– Renato Junior

2017/08/30 at 00:07
What is done with the command ? Commission , control or something ? It may be a process problem.I think it speaks of a physical purchase , no ?

– Motta

2017/08/30 at 01:06
@Motta A Commando has a number. The products with revenue are placed in a separate bag and the products within that bag are registered relative to the number of the commander.

– Renato Junior

2017/08/30 at 02:37
My question is: !?

– Motta

2017/08/30 at 11:17
Yes, the command number is an ID. The command has registered products related to the command ID. It works like a normal pharmacy.

– Renato Junior

2017/08/30 at 13:22

Show 1 more comment

1 answer

Browser other questions tagged php javascript mysql sql

You are not signed in. Login or sign up in order to post.

by Anderson Santos • **475** points · Answer 1 · 2017-08-30T00:11:03+00:00

If this is the only problem, you can create a communication system between computers with AJAX and save via cookie in browser. But I recommend you use the bank to store for ease and also because of the persistence that is higher, for you to send and receive the data AJAX would need all computers networked, if some computer "drives" then data would be lost, which would not happen with the database. If the client also wants a system for another platform, it would be much easier to implement later with the server already working all right...