I would like you to help me to make a quotation for a modification in one PHP software.
In my country, the Invoice numbering is restricted to a range from an initial number to a final number range that will be also limited by a range of period of time. Also, ate the beginning of the invoice number we need to add a Fixed number that is provided by the government. The system does not have to process any invoice or send an error message if the invoice actual number is bigger that final number range or is out of the period of time.
In addition there is a special code that the government stablish for every business: Depending of the kind of company or business it call: CAI, REF and so on and after this they give a Very long code to be printed in the head of the Invoice. This is a Char (50) field.
So I need you to help me with this:
1. This is a PHP script that work with MySql.
2. The filed to add in the database are:
All this field are going to be introduced in the configuration section: Please, see attachment Figure 1:
In the attachment Figure 2 and Figure 3 you will be able to see an example of the field to Add. (Just to have and idea)
3. The Invoice Number in the Invoice Bill (attachment figure 4) will the joint of: Pre_number_code & Invoice_actual_number (NOT TO NUMERICALLY add the fields, it is just part I + part II in one field)
4. The other 2 fields In the Figure 3 attch have to be added in the Invoice printout.
5. The system will work with many users at the same time, so the invoice number has to be unique. (To lock the field in the moment an invoice is generated and actualized in the data base.