ec_email_product_notification

ec_email_product_notification   db   order_id

This proc sends notifications for any products in the order that require it.

Source code:

  if { [ad_ssl_available_p] } {
    set order_link "[ec_secure_url]/admin/ecommerce/orders/one.tcl?[export_url_vars order_id]"
  } else {
    set order_link "[ec_insecure_url]/admin/ecommerce/orders/one.tcl?[export_url_vars order_id]"
  }

  set selection [ns_db select $db "
  select ep.email_on_purchase_list, ep.product_name
  from ec_items ei, ec_products ep
  where ei.product_id = ep.product_id
  and ei.order_id = $order_id
  group by ep.email_on_purchase_list, ep.product_name
  "]

  while {[ns_db getrow $db $selection]} {
    set_variables_after_query
    ec_sendmail_from_service $email_on_purchase_list [ad_system_owner] "An order for $product_name" "
A order for $product_name has been placed at [ad_system_name].

The order can be viewed at:

$order_link
"
  }