mark-volunteer-wednesdaypromo1.sh

#!/bin/bash

#ticket ID of bailing person

id=$1

# take argument of event ID and make all the orders in it attended and also completed

#update meta field
mysql -u root --password=`cat ~/bitnami_application_password` --database=bitnami_wordpress -se "UPDATE wp_postmeta as t, (SELECT order_id  FROM wp_order_product_customer_lookup where order_id=$id AND status='wc-processing' AND cc_attendance='pending') as temp SET meta_value='wednesdaypromo1' WHERE temp.order_id = t.post_id AND meta_key='cc_volunteer';" 

# set update order status
sudo wp wc shop_order update $id --status="on-hold" --user=1