Preface: Please the Great God to instruct the order review process how to design more efficient and reasonable, if can detail to table design more thanks.
System roles
Store sales, shop director, auditor, financial commissioner, the next single.
Process
Through the process
Store sales Input Order information > Submit > Store Audit > Auditor Review > Financial Review > The individual decides whether the order can be generated or returned.
return process
The store chief, the auditor, the finance, the order can return the orders which have already submitted the audit, only then approves to which step the role can return.
Now the system design pattern (feel stupid to die)
Now the system is to give the order a status field of 1 is not audited 2 is the store long audit analogy.
Then make the logic according to this, such as the financial Audit order list can only see status=3 orders.
Ask questions
This process audit how to design better.
Consider possible factors, such as the leader said not to be audited by the store manager, can effectively and safely remove an audit link.
Reply content:
Preface: Please the Great God to instruct the order review process how to design more efficient and reasonable, if can detail to table design more thanks.
System roles
Store sales, shop director, auditor, financial commissioner, the next single.
Process
Through the process
Store sales Input Order information > Submit > Store Audit > Auditor Review > Financial Review > The individual decides whether the order can be generated or returned.
return process
The store chief, the auditor, the finance, the order can return the orders which have already submitted the audit, only then approves to which step the role can return.
Now the system design pattern (feel stupid to die)
Now the system is to give the order a status field of 1 is not audited 2 is the store long audit analogy.
Then make the logic according to this, such as the financial Audit order list can only see status=3 orders.
Ask questions
This process audit how to design better.
Consider possible factors, such as the leader said not to be audited by the store manager, can effectively and safely remove an audit link.
Write a good document to indicate each audit corresponding ID is good, do not use the store long audit directly after the submission of struts to 3, and the previous database of the store length audit status is also set to the next audit status
It's better to make permission control, just like the Permissions menu.
Make a tick for each status of the order, and select the corresponding tick when setting the character. When the data is displayed, the corresponding SQL condition is easy to write.