Web PHP program that can set formulas using certain Operators.

INPUT DATA As input data there is mysql “TABLE OF SIGNALS” with this fields: - Signal ID - Type of signal (1=Digital 2=Analog 3=Video) - Direction (1=Read Only 2=R/W) - Free (0=free, 1=jet assigned as result of a formula) And an ”OPERATORS TABLE” with this fields - Operator Name - Parameter Number - Parameter compatibility with signal type (bit string) An example of operator is SUM that give back the sum of it’s parameter. SUM can only operate over analog signal (no video, no digital). If the maximum parameter of sum operator is 3 (SUM (par1, par2, par3)) the “operator table” will have this records: SUM;1;3 (it say that parameter 1 of SUM can be only analog type, 3=0,1,0 (digital,analog,Video). SUM;2;3 (parameter 2 of SUM can be only analog type) SUM;3;3 (parameter 3 of SUM can be only analog type) PROGRAM I need to be able setting formulas of signals using operators. Lets start with an example. I’ll use Character “;” as field separator . EXAMPLE OF TABLE OF SIGNALS 10;2;1;0 (Signal #10, Type Analog, Direction “Read only”) 11;2;2;0 (Signal #12, Type Analog, Direction “R/W”) 12;2;2;0 (Signal #10, Type Analog, Direction “R/W”) 13;2;2;0 (Signal #10, Type Analog, Direction “R/W”) For example if I want to set this formula 13=SUM(10,11,c5). c5 mean that 5 is a value not an index. Step that the program must realize are: - Choose the output signal of the formula (Program has to show only writable and free signals) in this case signal number 13. - Choose an Operator - Choose the parameters of operator (for each parameter program must show only compatible type). In this case 10,11, c5. - Set the output String formula for example 13=SUM(10,11,c5). - Set the “Free” field of signal 13 (TABLE OF SIGNAL) =1 .13;2;2;0->13;2;2;1 I would like to have an HMI evironment thas is easy to use and understand. Graphical beautiful feature are welcome. OUTPUT Program must fill an “FORMULA TABLE” with this fields - Output signal - Step number - Step operator formula In the example we will have only one record in SIGNAL TABLE: 13;1;SUM(10,11,c5) (Signal #13, step #1, SUM(10,11,c5). THATS ALL It is easy but program must be able to manage formulas that have more steps. For example to set this formula (MUL= operator multipy – only analog parameters) 13=MUL(SUM(10,11) , SUM(11,12) , c5). First the user has to set SUM as a temporany variable , after he has to set MUL. The final FORMULA TABLE has to be 13; 1, SUM(10,11) (Signal #13, step #1, SUM(10,11). 13; 2, SUM(11,12) (Signal #13, step #2, MUL(10,11). 13; 3, MUL (V1, V2, c5) V1 mean temporary variable output of step1. I must be able to delete formulas, in that case all line in the table must be deleted and signal 13 has to come back "free". Before the Awaard i need a proposal of graphical interaction user interface GUI/HMI or i can send my proposal.