/**
* This is used on the Edit Submission pages to show the list of email templates which can be emailed
* for the submission-View.
*
* @param integer $form_id
* @param integer $view_id
* @return array
*/
function ft_get_edit_submission_email_templates($form_id, $view_id)
{
global $g_table_prefix;
// a bit complicated, but all this query does is return those templates that are specified to be
// displayed for ALL views, or for those that have been mapped to this specific View
$query = mysql_query("\r\n SELECT et.email_id\r\n FROM {$g_table_prefix}email_templates et\r\n WHERE et.email_status = 'enabled' AND\r\n et.form_id = {$form_id} AND\r\n (et.include_on_edit_submission_page = 'all_views' OR\r\n (et.include_on_edit_submission_page = 'specific_views'\r\n AND EXISTS\r\n (SELECT *\r\n FROM {$g_table_prefix}email_template_edit_submission_views etesv\r\n WHERE et.email_id = etesv.email_id AND\r\n etesv.view_id = {$view_id})\r\n )\r\n )\r\n ") or die(mysql_error());
$email_info = array();
while ($row = mysql_fetch_assoc($query)) {
$email_id = $row["email_id"];
$email_info[] = ft_get_email_template($email_id);
}
extract(ft_process_hook_calls("end", compact("view_id", "email_info"), array("email_info")), EXTR_OVERWRITE);
return $email_info;
}
<?php
$email_id = ft_load_field("email_id", "email_id", "");
if (isset($request["update_email_template"])) {
list($g_success, $g_message) = ft_update_email_template($email_id, $request);
}
$form_info = ft_get_form($form_id);
$form_fields = ft_get_form_fields($form_id);
$columns = ft_get_form_column_names($form_id);
$template_info = ft_get_email_template($email_id);
$event_trigger_arr = explode(",", $template_info["email_event_trigger"]);
$template_info["email_event_trigger"] = $event_trigger_arr;
$clients = $form_info["client_info"];
$admin_info = ft_get_admin_info();
$edit_email_tab = isset($_SESSION["ft"]["inner_tabs"]["edit_email_template"]) ? $_SESSION["ft"]["inner_tabs"]["edit_email_template"] : 1;
if (isset($request["edit_email_template"])) {
$edit_email_tab = $request["edit_email_template"];
}
$form_has_file_upload_field = ft_check_form_has_file_upload_field($form_id);
$file_field_text = $form_has_file_upload_field ? $LANG["text_file_field_placeholders_info"] : "";
// values for the test email subpage
$num_submissions = ft_get_submission_count($form_id);
$test_email_format = ft_load_field("test_email_format", "test_email_format");
$test_email_recipient = ft_load_field("test_email_recipient", "test_email_recipient", $admin_info["email"]);
$test_email_data_source = ft_load_field("test_email_data_source", "test_email_data_source", "random_submission");
$test_email_submission_id = ft_load_field("test_email_submission_id", "test_email_submission_id", "");
$views = ft_get_views($form_id);
$filtered_views = array();
$selected_edit_submission_views = array();
$selected_when_sent_views = array();
foreach ($views["results"] as $view) {
