+
+ // Set expiry date to 6 weeks + delivery date
+ // or 2 weeks + required date. Stuff with an
+ // explicit required date should expire quickly the
+ // required date has been missed.
+ $sql = "UPDATE ".TB_PREF."sales_order_details
+ SET expiry_date = if(required_date is null, hold_until_date + INTERVAL 6 WEEK,
+ required_date + INTERVAL 2 WEEK)
+ WHERE expiry_date is null";
+ db_query($sql);