ww_email processing
The ww_email table is used to generate any e-mail that needs to get sent. If the sales string processed contains an <email> tag, that information is transferred to the ww_email table when the sale is processed, assuming no errors are encountered. If an error is encountered, ww_email is populated if an <email_ex> tag is found (exception e-mail). The table is populated as follows at this point:
wwsale_id | Sale id of the ww_sales record |
sale_no | Sale number of the sale that has been completed |
email | XML information on the e-mail(s) to be sent |
result | Empty (is filled in after the record is forwarded) |
date_time | Date/time that the record is added |
fwd_status | 0 |
fwd_time | Empty |
ww_email records are “forwarded” after the sale is completed. This consists of any records in the ww_email table with a fwd_status less than 2 being made into e-mail. A check is performed on the ww_tix table to ensure that any records associated with the sale have been forwarded. If they have not, an error is generated, “WW_TIX records did not exist on server so email could not be sent.” E-mail can be configured to attach the PDFs to the e-mail itself (using the <pt_em> and/or <pf_em> tags in the e-mail). If they can’t be attached, an error is generated, “Unable to attach proper number of pdf(s).” If they are sent successfully, the record is marked with a fwd_status of 2; otherwise 5, and the Result field is populated with the problem.