name: Cancel double opt-in activities if contact opted out
description: >
  Daily cron to cascade email unsubscribes to double opt-in statuses.
  Finds all contacts who have opted out and have completed double opt-in activities and cancels those activities.
command:
  echo '{"join":[["Contact AS target","INNER","ActivityContact",["target.record_type_id","=",3]]],"where":[["target.Communication.opt_in","=",0],["activity_type_id:name","=","Double Opt-In"],["status_id:name","=","Completed"]],"chain":{"cancel_double_opt_ins":["Activity","update",{"where":[["id","=","$id"]],"values":{"status_id:name":"Cancelled"}}]},"checkPermissions":0}' | /usr/local/bin/wmf-cv api4 -vv Activity.get --in=json
schedule: "30 20 * * *"
timeout: 5