From 50cfdcba360dcb17f88c42ce3a51d09a9670ce65 Mon Sep 17 00:00:00 2001 From: Sashi20 Date: Wed, 13 May 2020 21:27:54 +0530 Subject: Pass to email address to email templates --- code_approval.inc | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/code_approval.inc b/code_approval.inc index ce3c565..b4e1862 100755 --- a/code_approval.inc +++ b/code_approval.inc @@ -1731,6 +1731,18 @@ function codable_examples_approval_form($form, &$form_state) function codable_examples_approval_form_submit($form, &$form_state){ global $user; + $proposal_id = $form_state['values']['proposal_id']; + $query = db_select('textbook_companion_preference'); + $query->fields('textbook_companion_preference'); + $query->condition('proposal_id', $proposal_id); + $result = $query->execute(); + $preference_data = $result->fetchObject(); + $query = db_select('textbook_companion_proposal'); + $query->fields('textbook_companion_proposal'); + $query->condition('id', $preference_data->proposal_id); + $result = $query->execute(); + $proposal_data = $result->fetchObject(); + $user_data = user_load($proposal_data->uid); $ex_data = $form_state['values']; if ($ex_data['status_of_codable_example'] == "0") { /*db_query("UPDATE {textbook_companion_example} SET approval_status = 1, approver_uid = %d, approval_date = %d WHERE id = %d", $user->uid, time(), $ex_data['example_id']);*/ -- cgit