This may not be the best place to ask this question but I have been told by TASK UK that the code we put in place should work. The code is very simple.
SUMMARY
We want to have delayed delivery on purchased tickets with our PAH delivery method. We want the tickets delivered just under 48 hours before the performance date. Since our members purchase several performances in an order,, we do not want all tickets for all performances purchased delivered in one email in one PDF. We want tickets for each performance delivered 48 hours in advance of the performance date. We used the Sydney Opera's house solution for delayed delivery and modified. We are disabling the print_ind on in the TX_PERF_PKG_MOS table to control whether tickets can be printed for a performance on a particular day
DETAIL
We use a scheduled SQL job to run the code to change the print_ind in TX_PERF_PKG_MOS and delivery in T_ORDER. After two hours we run code to change everything back to its original values.
We have successfully tested that PAHT works with the delivery method set up for Delayed Delivery.
We have tested that the changes are correctly being made to the TX_PERF_PKG_MOS and T_ORDER tables.
We get the ticket for the first performance in the order but in the days that follow we get no other tickets even though there are performances in the order for the future subsequent dates.
We are getting a log reporting a faulty date format error yet I am not sure it is related as it occurs when no order have a PAH delivery method attached to them.
We have checked the config file to ensure orders in the past has the correct value.
The sli_status on the unprinted tickets is 3 (seated, paid).
If anyone knows of anything else that can be interfering, please advise
Thank you
Roberta Harrill
National Theatre, London