Neuron

4. Notice and Registration that reach Conditions of DIFFERENT SYSTEMS simultaneously.

 

            

Let us consider a mail that has a merchandise order in the body and client's number in the subject :

Subject: 578456545
product=XC4565
quantity = 100
[EOR]
 

 

and we have a temporary table with the following fields:

product, quantity, client, exist_sock, cust_acc_ok

 

the first three fields are completed with the content of the mail:

the customer account status is validated against a database custom table with a SQL sentence

 

select cust_acc_ok from clients  where client='578456545 AND cust_acc_ok  =1   

 

If the customer has his account ok (value 1), this will bring a record and the field cust_acc_ok of the temporary table will be completed.
There is also a Neuron input that is checking at this temporary table if there are all the necessary fields to create the order and the notification to the customer executing the SQL sentence:

 

select product, quantity, client , exist_stock , cust_acc_ok from temp where cust_acc_ok=1 AND exist_stock=1       (1)

 

exist_stock is a field that will be completed when an Neuron input that reads files says that product has stock.
When the condition is completed (1) it will insert a record that will create a mail at the output confirming client's order, in the following way:

Your order of 100 units of the product XC4565 had been registered and it will proceed to their delivery.

And a record is written at the comapny administration database so that the order follows its course.
.