Stored Procedure Trigger for Invoices by cfactory

we need a stored procedure + trigger to do the following. attached is the table layout trigger on update user_trans when approve changes from 0 to 1 or paypal_approve changes from 0 to 1 or google_approve… (Budget: $30-250, Jobs: MySQL)