On 2009-11-12 16:08, Task-By Christian Lathion wrote:
If your script detects a modification of the rate (part 2 of this task), send an email to rates@unappel.ch. The email will trigger the rates update procedure.
If there were successive modifications (i.e. different i_rate values in the billing which are greater than your stored value), the script must send several separated emails.
Your script must retrieve all the rate parameters (preference, price, effective date, etc.) from the billing, formatted in an easily understandable way for processing. If this is not complicated, you could instead create an Excel file which contains the new rate ready for upload. Study this part (Excel PHP module) and ask me for the precise format of the Excel to generate (it would be different for verizon and colt).
If it is not stored already, you'll need the vendor names to format your email (id is not sufficient since further processing is manual).
Add this to an existing php script, or advise if this implies too many modifications requiring a separate script.