function mf_display_form($dbh, $form_id, $form_params = array()) { global $mf_lang; //parameters mapping if (isset($form_params['page_number'])) { $page_number = $form_params['page_number']; } else { $page_number = 1; } if (isset($form_params['populated_values'])) { $populated_values = $form_params['populated_values']; } else { $populated_values = array(); } if (isset($form_params['error_elements'])) { $error_elements = $form_params['error_elements']; } else { $error_elements = array(); } if (isset($form_params['custom_error'])) { $custom_error = $form_params['custom_error']; } else { $custom_error = ''; } if (isset($form_params['edit_id'])) { $edit_id = (int) $form_params['edit_id']; } else { $edit_id = 0; } if (isset($form_params['integration_method'])) { //valid values are empty string, 'iframe' or 'php' $integration_method = $form_params['integration_method']; } else { $integration_method = ''; } if (!empty($form_params['machform_path'])) { $machform_path = $form_params['machform_path']; } else { $machform_path = ''; } if (!empty($form_params['machform_data_path'])) { $machform_data_path = $form_params['machform_data_path']; } else { $machform_data_path = ''; } $mf_settings = mf_get_settings($dbh); //if there is custom error, don't show other errors if (!empty($custom_error)) { $error_elements = array(); } //get form properties data $query = "SELECT \r\n\t\t\t\t\t\t form_name,\r\n\t\t\t\t\t\t form_description,\r\n\t\t\t\t\t\t form_redirect,\r\n\t\t\t\t\t\t form_success_message,\r\n\t\t\t\t\t\t form_password,\r\n\t\t\t\t\t\t form_unique_ip,\r\n\t\t\t\t\t\t form_frame_height,\r\n\t\t\t\t\t\t form_has_css,\r\n\t\t\t\t\t\t form_active,\r\n\t\t\t\t\t\t form_captcha,\r\n\t\t\t\t\t\t form_captcha_type,\r\n\t\t\t\t\t\t form_review,\r\n\t\t\t\t\t\t form_label_alignment,\r\n\t\t\t\t\t\t form_language,\r\n\t\t\t\t\t\t form_page_total,\r\n\t\t\t\t\t\t form_lastpage_title,\r\n\t\t\t\t\t\t form_submit_primary_text,\r\n\t\t\t\t\t\t form_submit_secondary_text,\r\n\t\t\t\t\t\t form_submit_primary_img,\r\n\t\t\t\t\t\t form_submit_secondary_img,\r\n\t\t\t\t\t\t form_submit_use_image,\r\n\t\t\t\t\t\t form_pagination_type,\r\n\t\t\t\t\t\t form_review_primary_text,\r\n\t\t\t\t\t\t form_review_secondary_text,\r\n\t\t\t\t\t\t form_review_primary_img,\r\n\t\t\t\t\t\t form_review_secondary_img,\r\n\t\t\t\t\t\t form_review_use_image,\r\n\t\t\t\t\t\t form_review_title,\r\n\t\t\t\t\t\t form_review_description,\r\n\t\t\t\t\t\t form_resume_enable,\r\n\t\t\t\t\t\t form_theme_id,\r\n\t\t\t\t\t\t payment_show_total,\r\n\t\t\t\t\t\t payment_total_location,\r\n\t\t\t\t\t\t payment_enable_merchant,\r\n\t\t\t\t\t\t payment_currency,\r\n\t\t\t\t\t\t payment_price_type,\r\n\t\t\t\t\t\t payment_price_amount,\r\n\t\t\t\t\t\t form_limit_enable,\r\n\t\t\t\t\t\t form_limit,\r\n\t\t\t\t\t\t form_schedule_enable,\r\n\t\t\t\t\t\t form_schedule_start_date,\r\n\t\t\t\t\t\t form_schedule_end_date,\r\n\t\t\t\t\t\t form_schedule_start_hour,\r\n\t\t\t\t\t\t form_schedule_end_hour\r\n\t\t\t\t FROM \r\n\t\t\t\t \t " . MF_TABLE_PREFIX . "forms \r\n\t\t\t\t WHERE \r\n\t\t\t\t \t form_id = ?"; $params = array($form_id); $sth = mf_do_query($query, $params, $dbh); $row = mf_do_fetch_result($sth); //check for non-existent or currently drafted forms if (empty($row) || $row['form_active'] != 1) { die('This is not valid form URL.'); } $form = new stdClass(); $form->id = $form_id; $form->name = $row['form_name']; $form->description = $row['form_description']; $form->redirect = $row['form_redirect']; $form->success_message = $row['form_success_message']; $form->password = $row['form_password']; $form->frame_height = $row['form_frame_height']; $form->unique_ip = $row['form_unique_ip']; $form->has_css = $row['form_has_css']; $form->active = $row['form_active']; $form->captcha = $row['form_captcha']; $form->captcha_type = $row['form_captcha_type']; $form->review = $row['form_review']; $form->label_alignment = $row['form_label_alignment']; $form->page_total = $row['form_page_total']; $form->lastpage_title = $row['form_lastpage_title']; $form->submit_primary_text = $row['form_submit_primary_text']; $form->submit_secondary_text = $row['form_submit_secondary_text']; $form->submit_primary_img = $row['form_submit_primary_img']; $form->submit_secondary_img = $row['form_submit_secondary_img']; $form->submit_use_image = (int) $row['form_submit_use_image']; $form->pagination_type = $row['form_pagination_type']; $form->review_primary_text = $row['form_review_primary_text']; $form->review_secondary_text = $row['form_review_secondary_text']; $form->review_primary_img = $row['form_review_primary_img']; $form->review_secondary_img = $row['form_review_secondary_img']; $form->review_use_image = (int) $row['form_review_use_image']; $form->review_title = $row['form_review_title']; $form->review_description = $row['form_review_description']; $form->resume_enable = $row['form_resume_enable']; $form->theme_id = (int) $row['form_theme_id']; $form->payment_show_total = (int) $row['payment_show_total']; $form->payment_total_location = $row['payment_total_location']; $form->payment_enable_merchant = (int) $row['payment_enable_merchant']; if ($form->payment_enable_merchant < 1) { $form->payment_enable_merchant = 0; } $form->payment_currency = $row['payment_currency']; $form->payment_price_type = $row['payment_price_type']; $form->payment_price_amount = $row['payment_price_amount']; $form->limit_enable = (int) $row['form_limit_enable']; $form->limit = (int) $row['form_limit']; $form->schedule_enable = (int) $row['form_schedule_enable']; $form->schedule_start_date = $row['form_schedule_start_date']; $form->schedule_end_date = $row['form_schedule_end_date']; $form->schedule_start_hour = $row['form_schedule_start_hour']; $form->schedule_end_hour = $row['form_schedule_end_hour']; $form->language = trim($row['form_language']); if (!empty($form->language)) { mf_set_language($form->language); } if (empty($error_elements)) { $form->is_error = 0; } else { $form->is_error = 1; } if (!empty($edit_id)) { $form->active = 1; } if ($form->page_total == 1) { //if this form has review enabled and user are having $_SESSION['review_id'], then populate the form with that values if (!empty($form->review) && !empty($_SESSION['review_id']) && empty($populated_values)) { $entry_params = array(); $entry_params['machform_data_path'] = $machform_data_path; $populated_values = mf_get_entry_values($dbh, $form_id, $_SESSION['review_id'], true, $entry_params); } elseif (!empty($form->review) && !empty($_SESSION['review_id']) && !empty($populated_values)) { //if form review enabled and there is some validation error, the uploaded files needs to be displayed $entry_params = array(); $entry_params['machform_data_path'] = $machform_data_path; $populated_file_values = mf_get_entry_values($dbh, $form_id, $_SESSION['review_id'], true, $entry_params); } } else { //if this is multipage form, always populate the fields $session_id = session_id(); //if there is form resume key, load the record from ap_form_x table to ap_form_x_review table if (!empty($_SESSION['mf_form_resume_key'][$form_id])) { $resume_key = $_SESSION['mf_form_resume_key'][$form_id]; //first delete existing record within review table $query = "DELETE from `" . MF_TABLE_PREFIX . "form_{$form_id}_review` where session_id=? or resume_key=?"; $params = array($session_id, $resume_key); mf_do_query($query, $params, $dbh); //copy data from ap_form_x table to ap_form_x_review table $query = "SELECT * FROM `" . MF_TABLE_PREFIX . "form_{$form_id}` WHERE resume_key=?"; $params = array($resume_key); $sth = mf_do_query($query, $params, $dbh); $row = mf_do_fetch_result($sth); $columns = array(); foreach ($row as $column_name => $column_data) { if ($column_name != 'id') { $columns[] = $column_name; } } if (empty($columns)) { //invalid resume_key given, display error message $custom_error = 'Invalid Link! <br/>Please open the complete URL to resume your saved progress.'; } else { $columns_joined = implode("`,`", $columns); $columns_joined = '`' . $columns_joined . '`'; //copy data from main table $query = "INSERT INTO `" . MF_TABLE_PREFIX . "form_{$form_id}_review`({$columns_joined}) SELECT {$columns_joined} from `" . MF_TABLE_PREFIX . "form_{$form_id}` WHERE resume_key=?"; $params = array($resume_key); mf_do_query($query, $params, $dbh); $query = "UPDATE `" . MF_TABLE_PREFIX . "form_{$form_id}_review` set session_id=? WHERE resume_key=?"; $params = array($session_id, $resume_key); mf_do_query($query, $params, $dbh); for ($i = 1; $i <= $form->page_total; $i++) { $_SESSION['mf_form_loaded'][$form_id][$i] = true; } unset($_SESSION['mf_form_resume_key'][$form_id]); } } $query = "SELECT `id` from `" . MF_TABLE_PREFIX . "form_{$form_id}_review` where session_id=?"; $params = array($session_id); $sth = mf_do_query($query, $params, $dbh); $row = mf_do_fetch_result($sth); //we need to check mf_form_loaded to make sure default values of fields are being loaded on the first view of the form if (empty($populated_values) && !empty($_SESSION['mf_form_loaded'][$form_id][$page_number])) { $entry_params = array(); $entry_params['machform_data_path'] = $machform_data_path; $populated_values = mf_get_entry_values($dbh, $form_id, $row['id'], true, $entry_params); } else { //if there is some validation error, the uploaded files needs to be displayed $entry_params = array(); $entry_params['machform_data_path'] = $machform_data_path; $populated_file_values = mf_get_entry_values($dbh, $form_id, $row['id'], true, $entry_params); } } //get price definitions for fields, if the merchant feature is enabled if (!empty($form->payment_enable_merchant)) { $query = "select \r\n\t\t\t\t\t\t\telement_id,\r\n\t\t\t\t\t\t\toption_id,\r\n\t\t\t\t\t\t\t`price` \r\n\t\t\t\t\t from \r\n\t\t\t\t\t \t\t`" . MF_TABLE_PREFIX . "element_prices` \r\n\t\t\t\t\t where \r\n\t\t\t\t\t \t\tform_id=? \r\n\t\t\t\t order by \r\n\t\t\t\t \t\t\telement_id,option_id asc"; $params = array($form_id); $sth = mf_do_query($query, $params, $dbh); while ($row = mf_do_fetch_result($sth)) { $element_prices_array[$row['element_id']][$row['option_id']] = $row['price']; } } //get elements data //get element options first and store it into array $query = "SELECT \r\n\t\t\t\t\t\telement_id,\r\n\t\t\t\t\t\toption_id,\r\n\t\t\t\t\t\t`position`,\r\n\t\t\t\t\t\t`option`,\r\n\t\t\t\t\t\toption_is_default \r\n\t\t\t\t FROM \r\n\t\t\t\t \t" . MF_TABLE_PREFIX . "element_options \r\n\t\t\t\t where \r\n\t\t\t\t \t\tform_id = ? and live=1 \r\n\t\t\t\torder by \r\n\t\t\t\t\t\telement_id asc,`position` asc"; $params = array($form_id); $sth = mf_do_query($query, $params, $dbh); while ($row = mf_do_fetch_result($sth)) { $element_id = $row['element_id']; $option_id = $row['option_id']; $options_lookup[$element_id][$option_id]['position'] = $row['position']; $options_lookup[$element_id][$option_id]['option'] = $row['option']; $options_lookup[$element_id][$option_id]['option_is_default'] = $row['option_is_default']; if (isset($element_prices_array[$element_id][$option_id])) { $options_lookup[$element_id][$option_id]['price_definition'] = $element_prices_array[$element_id][$option_id]; } } $matrix_elements = array(); //get elements data $element = array(); if ($page_number === 0) { //if page_number is 0, display all pages (this is being used on edit_entry page) $page_number_clause = ''; $params = array($form_id); } else { $page_number_clause = 'and element_page_number = ?'; $params = array($form_id, $page_number); } $query = "SELECT \r\n\t\t\t\t\t\telement_id,\r\n\t\t\t\t\t\telement_title,\r\n\t\t\t\t\t\telement_guidelines,\r\n\t\t\t\t\t\telement_size,\r\n\t\t\t\t\t\telement_is_required,\r\n\t\t\t\t\t\telement_is_unique,\r\n\t\t\t\t\t\telement_is_private,\r\n\t\t\t\t\t\telement_type,\r\n\t\t\t\t\t\telement_position,\r\n\t\t\t\t\t\telement_default_value,\r\n\t\t\t\t\t\telement_constraint,\r\n\t\t\t\t\t\telement_choice_has_other,\r\n\t\t\t\t\t\telement_choice_other_label,\r\n\t\t\t\t\t\telement_choice_columns,\r\n\t\t\t\t\t\telement_time_showsecond, \r\n\t\t\t\t\t\telement_time_24hour,\r\n\t\t\t\t\t\telement_address_hideline2,\r\n\t\t\t\t\t\telement_address_us_only,\r\n\t\t\t\t\t\telement_date_enable_range,\r\n\t\t\t\t\t\telement_date_range_min,\r\n\t\t\t\t\t\telement_date_range_max,\r\n\t\t\t\t\t\telement_date_enable_selection_limit,\r\n\t\t\t\t\t\telement_date_selection_max,\r\n\t\t\t\t\t\telement_date_disable_past_future,\r\n\t\t\t\t\t\telement_date_past_future,\r\n\t\t\t\t\t\telement_date_disable_weekend,\r\n\t\t\t\t\t\telement_date_disable_specific,\r\n\t\t\t\t\t\telement_date_disabled_list,\r\n\t\t\t\t\t\telement_file_enable_type_limit,\r\n\t\t\t\t\t\telement_file_block_or_allow,\r\n\t\t\t\t\t\telement_file_type_list,\r\n\t\t\t\t\t\telement_file_as_attachment,\r\n\t\t\t\t\t\telement_file_enable_advance,\r\n\t\t\t\t\t\telement_file_auto_upload,\r\n\t\t\t\t\t\telement_file_enable_multi_upload,\r\n\t\t\t\t\t\telement_file_max_selection,\r\n\t\t\t\t\t\telement_file_enable_size_limit,\r\n\t\t\t\t\t\telement_file_size_max,\r\n\t\t\t\t\t\telement_matrix_allow_multiselect,\r\n\t\t\t\t\t\telement_matrix_parent_id,\r\n\t\t\t\t\t\telement_range_min,\r\n\t\t\t\t\t\telement_range_max,\r\n\t\t\t\t\t\telement_range_limit_by,\r\n\t\t\t\t\t\telement_css_class\r\n\t\t\t\t\tFROM \r\n\t\t\t\t\t\t" . MF_TABLE_PREFIX . "form_elements \r\n\t\t\t\t WHERE \r\n\t\t\t\t \t\tform_id = ? and element_status='1' {$page_number_clause} and element_type <> 'page_break'\r\n\t\t\t\tORDER BY \r\n\t\t\t\t\t\telement_position asc"; $sth = mf_do_query($query, $params, $dbh); $j = 0; $has_calendar = false; //assume the form doesn't have calendar, so it won't load calendar.js $has_advance_uploader = false; $has_guidelines = false; while ($row = mf_do_fetch_result($sth)) { $element[$j] = new stdClass(); $element_id = $row['element_id']; //lookup element options first if (!empty($options_lookup[$element_id])) { $element_options = array(); $i = 0; foreach ($options_lookup[$element_id] as $option_id => $data) { $element_options[$i] = new stdClass(); $element_options[$i]->id = $option_id; $element_options[$i]->option = $data['option']; $element_options[$i]->is_default = $data['option_is_default']; $element_options[$i]->is_db_live = 1; if (isset($data['price_definition'])) { $element_options[$i]->price_definition = $data['price_definition']; } $i++; } } //populate elements $element[$j]->title = nl2br($row['element_title']); $element[$j]->guidelines = $row['element_guidelines']; if (!empty($row['element_guidelines']) && $row['element_type'] != 'section' && $row['element_type'] != 'matrix') { $has_guidelines = true; } $element[$j]->size = $row['element_size']; $element[$j]->is_required = $row['element_is_required']; $element[$j]->is_unique = $row['element_is_unique']; $element[$j]->is_private = $row['element_is_private']; $element[$j]->type = $row['element_type']; $element[$j]->position = $row['element_position']; $element[$j]->id = $row['element_id']; $element[$j]->is_db_live = 1; $element[$j]->form_id = $form_id; $element[$j]->choice_has_other = (int) $row['element_choice_has_other']; $element[$j]->choice_other_label = $row['element_choice_other_label']; $element[$j]->choice_columns = (int) $row['element_choice_columns']; $element[$j]->time_showsecond = (int) $row['element_time_showsecond']; $element[$j]->time_24hour = (int) $row['element_time_24hour']; $element[$j]->address_hideline2 = (int) $row['element_address_hideline2']; $element[$j]->address_us_only = (int) $row['element_address_us_only']; $element[$j]->date_enable_range = (int) $row['element_date_enable_range']; $element[$j]->date_range_min = $row['element_date_range_min']; $element[$j]->date_range_max = $row['element_date_range_max']; $element[$j]->date_enable_selection_limit = (int) $row['element_date_enable_selection_limit']; $element[$j]->date_selection_max = (int) $row['element_date_selection_max']; $element[$j]->date_disable_past_future = (int) $row['element_date_disable_past_future']; $element[$j]->date_past_future = $row['element_date_past_future']; $element[$j]->date_disable_weekend = (int) $row['element_date_disable_weekend']; $element[$j]->date_disable_specific = (int) $row['element_date_disable_specific']; $element[$j]->date_disabled_list = $row['element_date_disabled_list']; $element[$j]->file_enable_type_limit = (int) $row['element_file_enable_type_limit']; $element[$j]->file_block_or_allow = $row['element_file_block_or_allow']; $element[$j]->file_type_list = $row['element_file_type_list']; $element[$j]->file_as_attachment = (int) $row['element_file_as_attachment']; $element[$j]->file_enable_advance = (int) $row['element_file_enable_advance']; if (!empty($element[$j]->file_enable_advance)) { $has_advance_uploader = true; } $element[$j]->file_auto_upload = (int) $row['element_file_auto_upload']; $element[$j]->file_enable_multi_upload = (int) $row['element_file_enable_multi_upload']; $element[$j]->file_max_selection = (int) $row['element_file_max_selection']; $element[$j]->file_enable_size_limit = (int) $row['element_file_enable_size_limit']; $element[$j]->file_size_max = (int) $row['element_file_size_max']; $element[$j]->matrix_allow_multiselect = (int) $row['element_matrix_allow_multiselect']; $element[$j]->matrix_parent_id = (int) $row['element_matrix_parent_id']; $element[$j]->upload_dir = $mf_settings['upload_dir']; $element[$j]->range_min = $row['element_range_min']; $element[$j]->range_max = $row['element_range_max']; $element[$j]->range_limit_by = $row['element_range_limit_by']; $element[$j]->css_class = $row['element_css_class']; $element[$j]->machform_path = $machform_path; $element[$j]->machform_data_path = $machform_data_path; //this data came from db or form submit //being used to display edit form or redisplay form with errors and previous inputs //this should be optimized in the future, only pass necessary data, not the whole array $element[$j]->populated_value = $populated_values; //set prices for price-enabled field if ($row['element_type'] == 'money' && isset($element_prices_array[$row['element_id']][0])) { $element[$j]->price_definition = 0; } //if there is file upload type, set form enctype to multipart if ($row['element_type'] == 'file') { $form_enc_type = 'enctype="multipart/form-data"'; //if this is single page form with review enabled or multipage form if (!empty($form->review) && !empty($_SESSION['review_id']) && !empty($populated_file_values) || $form->page_total > 1 && !empty($populated_file_values)) { //populate the default value for uploaded files, when validation error occured //make sure to keep the file token if exist if (!empty($populated_values['element_' . $row['element_id']]['file_token'])) { $populated_file_values['element_' . $row['element_id']]['file_token'] = $populated_values['element_' . $row['element_id']]['file_token']; } $element[$j]->populated_value = $populated_file_values; } if (!empty($edit_id) && $_SESSION['mf_logged_in'] === true) { //if this is edit_entry page $element[$j]->is_edit_entry = true; } } if (!empty($error_elements[$element[$j]->id])) { $element[$j]->is_error = 1; $element[$j]->error_message = $error_elements[$element[$j]->id]; } $element[$j]->default_value = htmlspecialchars($row['element_default_value']); $element[$j]->constraint = $row['element_constraint']; if (!empty($element_options)) { $element[$j]->options = $element_options; } else { $element[$j]->options = ''; } //check for calendar type if ($row['element_type'] == 'date' || $row['element_type'] == 'europe_date') { $has_calendar = true; //if the field has date selection limit, we need to do query to existing entries and disable all date which reached the limit if (!empty($row['element_date_enable_selection_limit']) && !empty($row['element_date_selection_max'])) { $sub_query = "select \r\n\t\t\t\t\t\t\t\t\t\tselected_date \r\n\t\t\t\t\t\t\t\t\tfrom (\r\n\t\t\t\t\t\t\t\t\t\t\tselect \r\n\t\t\t\t\t\t\t\t\t\t\t\t date_format(element_{$row['element_id']},'%m/%d/%Y') as selected_date,\r\n\t\t\t\t\t\t\t\t\t\t\t\t count(element_{$row['element_id']}) as total_selection \r\n\t\t\t\t\t\t\t\t\t\t from \r\n\t\t\t\t\t\t\t\t\t\t \t " . MF_TABLE_PREFIX . "form_{$form_id} \r\n\t\t\t\t\t\t\t\t\t\t where \r\n\t\t\t\t\t\t\t\t\t\t \t status=1 and element_{$row['element_id']} is not null \r\n\t\t\t\t\t\t\t\t\t\t group by \r\n\t\t\t\t\t\t\t\t\t\t \t\t element_{$row['element_id']}\r\n\t\t\t\t\t\t\t\t\t\t ) as A\r\n\t\t\t\t\t\t\t\t where \r\n\t\t\t\t\t\t\t\t\t\t A.total_selection >= ?"; $params = array($row['element_date_selection_max']); $sub_sth = mf_do_query($sub_query, $params, $dbh); $current_date_disabled_list = array(); $current_date_disabled_list_joined = ''; while ($sub_row = mf_do_fetch_result($sub_sth)) { $current_date_disabled_list[] = $sub_row['selected_date']; } $current_date_disabled_list_joined = implode(',', $current_date_disabled_list); if (!empty($element[$j]->date_disable_specific)) { //add to existing disable date list if (empty($element[$j]->date_disabled_list)) { $element[$j]->date_disabled_list = $current_date_disabled_list_joined; } else { $element[$j]->date_disabled_list .= ',' . $current_date_disabled_list_joined; } } else { //'disable specific date' is not enabled, we need to override and enable it from here $element[$j]->date_disable_specific = 1; $element[$j]->date_disabled_list = $current_date_disabled_list_joined; } } } //if the element is a matrix field and not the parent, store the data into a lookup array for later use when rendering the markup if ($row['element_type'] == 'matrix' && !empty($row['element_matrix_parent_id'])) { $parent_id = $row['element_matrix_parent_id']; $el_position = $row['element_position']; $matrix_elements[$parent_id][$el_position]['title'] = $element[$j]->title; $matrix_elements[$parent_id][$el_position]['id'] = $element[$j]->id; $matrix_child_option_id = ''; foreach ($element_options as $value) { $matrix_child_option_id .= $value->id . ','; } $matrix_child_option_id = rtrim($matrix_child_option_id, ','); $matrix_elements[$parent_id][$el_position]['children_option_id'] = $matrix_child_option_id; //remove it from the main element array $element[$j] = array(); unset($element[$j]); $j--; } $j++; } //add captcha if enabled //on multipage form, captcha should be displayed on the last page only if (!empty($form->captcha) && empty($edit_id)) { if ($form->page_total == 1 || $form->page_total == $page_number) { $element[$j] = new stdClass(); $element[$j]->type = 'captcha'; $element[$j]->captcha_type = $form->captcha_type; $element[$j]->form_id = $form_id; $element[$j]->is_private = 0; if (!empty($error_elements['element_captcha'])) { $element[$j]->is_error = 1; $element[$j]->error_message = $error_elements['element_captcha']; } } } //generate html markup for each element $container_class = ''; $all_element_markup = ''; foreach ($element as $element_data) { if ($element_data->is_private && empty($edit_id)) { //don't show private element on live forms continue; } //if this is matrix field, build the children data from $matrix_elements array if ($element_data->type == 'matrix') { $element_data->matrix_children = $matrix_elements[$element_data->id]; } $all_element_markup .= call_user_func('mf_display_' . $element_data->type, $element_data); } if (!empty($custom_error)) { $form->error_message = <<<EOT \t\t\t<li id="error_message"> \t\t\t\t\t<h3 id="error_message_title">{$custom_error}</h3> \t\t\t</li>\t EOT; } elseif (!empty($error_elements)) { $form->error_message = <<<EOT \t\t\t<li id="error_message"> \t\t\t\t\t<h3 id="error_message_title">{$mf_lang['error_title']}</h3> \t\t\t\t\t<p id="error_message_desc">{$mf_lang['error_desc']}</p> \t\t\t</li>\t EOT; } //if this form is using custom theme and not on edit entry page if (!empty($form->theme_id) && empty($edit_id)) { //get the field highlight color for the particular theme $query = "SELECT \r\n\t\t\t\t\t\t\thighlight_bg_type,\r\n\t\t\t\t\t\t\thighlight_bg_color,\r\n\t\t\t\t\t\t\tform_shadow_style,\r\n\t\t\t\t\t\t\tform_shadow_size,\r\n\t\t\t\t\t\t\tform_shadow_brightness,\r\n\t\t\t\t\t\t\tform_button_type,\r\n\t\t\t\t\t\t\tform_button_text,\r\n\t\t\t\t\t\t\tform_button_image,\r\n\t\t\t\t\t\t\ttheme_has_css \r\n\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t" . MF_TABLE_PREFIX . "form_themes \r\n\t\t\t\t\t WHERE \r\n\t\t\t\t\t \t\ttheme_id = ?"; $params = array($form->theme_id); $sth = mf_do_query($query, $params, $dbh); $row = mf_do_fetch_result($sth); $form_shadow_style = $row['form_shadow_style']; $form_shadow_size = $row['form_shadow_size']; $form_shadow_brightness = $row['form_shadow_brightness']; $theme_has_css = (int) $row['theme_has_css']; //if the theme has css file, make sure to refer to that file //otherwise, generate the css dynamically if (!empty($theme_has_css)) { $theme_css_link = '<link rel="stylesheet" type="text/css" href="' . $machform_path . $mf_settings['data_dir'] . '/themes/theme_' . $form->theme_id . '.css" media="all" />'; } else { $theme_css_link = '<link rel="stylesheet" type="text/css" href="' . $machform_path . 'css_theme.php?theme_id=' . $form->theme_id . '" media="all" />'; } if ($row['highlight_bg_type'] == 'color') { $field_highlight_color = $row['highlight_bg_color']; } else { //if the field highlight is using pattern instead of color, set the color to empty string $field_highlight_color = ''; } //get the css link for the fonts $font_css_markup = mf_theme_get_fonts_link($dbh, $form->theme_id); //get the form shadow classes if (!empty($form_shadow_style) && $form_shadow_style != 'disabled') { preg_match_all("/[A-Z]/", $form_shadow_style, $prefix_matches); //this regex simply get the capital characters of the shadow style name //example: RightPerspectiveShadow result to RPS and then being sliced to RP $form_shadow_prefix_code = substr(implode("", $prefix_matches[0]), 0, -1); $form_shadow_size_class = $form_shadow_prefix_code . ucfirst($form_shadow_size); $form_shadow_brightness_class = $form_shadow_prefix_code . ucfirst($form_shadow_brightness); if (empty($integration_method)) { //only display shadow if the form is not being embedded using any method $form_container_class = $form_shadow_style . ' ' . $form_shadow_size_class . ' ' . $form_shadow_brightness_class; } } //get the button text/image setting if (empty($form->review)) { if ($row['form_button_type'] == 'text') { $submit_button_markup = '<input id="submit_form" class="button_text" type="submit" name="submit_form" value="' . $row['form_button_text'] . '" />'; } else { $submit_button_markup = '<input class="submit_img_primary" type="image" alt="Submit" id="submit_form" name="submit_form" src="' . $row['form_button_image'] . '" />'; } } else { $submit_button_markup = '<input id="submit_form" class="button_text" type="submit" name="submit_form" value="' . $mf_lang['continue_button'] . '" />'; } } else { //if the form doesn't have any theme being applied $field_highlight_color = '#FFF7C0'; if (empty($integration_method)) { $form_container_class = 'WarpShadow WLarge WNormal'; //default shadow } else { $form_container_class = ''; //dont show any shadow when the form being embedded } if (empty($form->review)) { $submit_button_markup = '<input id="submit_form" class="button_text" type="submit" name="submit_form" value="' . $mf_lang['submit_button'] . '" />'; } else { $submit_button_markup = '<input id="submit_form" class="button_text" type="submit" name="submit_form" value="' . $mf_lang['continue_button'] . '" />'; } } //display edit_id if there is any, this is being called on edit_entry.php page if (!empty($edit_id)) { $edit_markup = "<input type=\"hidden\" name=\"edit_id\" value=\"{$edit_id}\" />\n"; $submit_button_markup = '<input id="submit_form" class="button_text" type="submit" name="submit_form" value="Save Changes" />'; } else { $edit_markup = ''; } //check for specific form css, if any, use it instead if ($form->has_css) { $css_dir = $mf_settings['data_dir'] . "/form_{$form_id}/css/"; } if (!empty($form->password) && empty($_SESSION['user_authenticated'])) { //if form require password and password hasn't set yet $show_password_form = true; } elseif (!empty($form->password) && !empty($_SESSION['user_authenticated']) && $_SESSION['user_authenticated'] != $form_id) { //if user authenticated but not for this form $show_password_form = true; } else { //user authenticated for this form, or no password required $show_password_form = false; } if ($show_password_form) { $submit_button_markup = '<input id="submit_form" class="button_text" type="submit" name="submit_form" value="' . $mf_lang['submit_button'] . '" />'; } //default markup for single page form submit button $button_markup = <<<EOT \t\t<li id="li_buttons" class="buttons"> \t\t\t <input type="hidden" name="form_id" value="{$form->id}" /> \t\t\t {$edit_markup} \t\t\t <input type="hidden" name="submit_form" value="1" /> \t\t\t <input type="hidden" name="page_number" value="{$page_number}" /> \t\t\t\t{$submit_button_markup} \t\t</li> EOT; //check for form limit rule $form_has_maximum_entries = false; if (!empty($form->limit_enable)) { $query = "select count(*) total_row from " . MF_TABLE_PREFIX . "form_{$form_id} where `status`=1"; $params = array(); $sth = mf_do_query($query, $params, $dbh); $row = mf_do_fetch_result($sth); $total_entries = $row['total_row']; if ($total_entries >= $form->limit) { $form_has_maximum_entries = true; } } //check for automatic scheduling limit, if enabled if (!empty($form->schedule_enable)) { $schedule_start_time = strtotime($form->schedule_start_date . ' ' . $form->schedule_start_hour); $schedule_end_time = strtotime($form->schedule_end_date . ' ' . $form->schedule_end_hour); $current_time = strtotime(date("Y-m-d H:i:s")); if (!empty($schedule_start_time)) { if ($current_time < $schedule_start_time) { $form->active = 0; } } if (!empty($schedule_end_time)) { if ($current_time > $schedule_end_time) { $form->active = 0; } } } if (empty($form->active) || $form_has_maximum_entries) { //if form is not active, don't show the fields $form_desc_div = ''; $all_element_markup = ''; $button_markup = ''; $ul_class = 'class="password"'; if ($form_has_maximum_entries) { $inactive_message = $mf_lang['form_limited']; } else { $inactive_message = $mf_lang['form_inactive']; } $custom_element = <<<EOT \t\t\t<li> \t\t\t\t<h2>{$inactive_message}</h2> \t\t\t</li> EOT; } elseif ($show_password_form) { //don't show form description if this page is password protected and user not authenticated $form_desc_div = ''; $all_element_markup = ''; $custom_element = <<<EOT \t\t\t<li> \t\t\t\t<h2>{$mf_lang['form_pass_title']}</h2> \t\t\t\t<div> \t\t\t\t<input type="password" value="" class="text" name="password" id="password" /> \t\t\t\t<label for="password" class="desc">{$mf_lang['form_pass_desc']}</label> \t\t\t\t</div> \t\t\t</li> EOT; $ul_class = 'class="password"'; } else { if (!empty($form->name) || !empty($form->description)) { $form->description = nl2br($form->description); $form_desc_div = <<<EOT \t\t<div class="form_description"> \t\t\t<h2>{$form->name}</h2> \t\t\t<p>{$form->description}</p> \t\t</div> EOT; } } if (!$has_guidelines) { $container_class .= " no_guidelines"; } if ($integration_method == 'iframe') { $html_class_tag = 'class="embed"'; } if ($has_calendar) { $calendar_init = '<script type="text/javascript" src="' . $machform_path . 'js/datepick/jquery.datepick.js"></script>' . "\n" . '<script type="text/javascript" src="' . $machform_path . 'js/datepick/jquery.datepick.ext.js"></script>' . "\n" . '<link type="text/css" href="' . $machform_path . 'js/datepick/smoothness.datepick.css" rel="stylesheet" />'; } else { $calendar_init = ''; } //if the form has multiple pages //display the pagination header if ($form->page_total > 1 && $show_password_form === false) { //build pagination header based on the selected type. possible values: //steps - display multi steps progress //percentage - display progress bar with percentage //disabled - disabled $page_breaks_data = array(); $page_title_array = array(); //get page titles $query = "SELECT \r\n\t\t\t\t\t\t\telement_page_title,\r\n\t\t\t\t\t\t\telement_page_number,\r\n\t\t\t\t\t\t\telement_submit_use_image,\r\n\t\t\t\t\t\t element_submit_primary_text,\r\n\t\t\t\t\t\t\telement_submit_secondary_text,\r\n\t\t\t\t\t\t\telement_submit_primary_img,\r\n\t\t\t\t\t\t\telement_submit_secondary_img \r\n\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t" . MF_TABLE_PREFIX . "form_elements\r\n\t\t\t\t\t WHERE\r\n\t\t\t\t\t\t\tform_id = ? and element_status = 1 and element_type = 'page_break'\r\n\t\t\t\t\tORDER BY \r\n\t\t\t\t\t \t\telement_page_number asc"; $params = array($form_id); $sth = mf_do_query($query, $params, $dbh); while ($row = mf_do_fetch_result($sth)) { $temp_page_number = $row['element_page_number']; $page_breaks_data[$temp_page_number]['use_image'] = $row['element_submit_use_image']; $page_breaks_data[$temp_page_number]['primary_text'] = $row['element_submit_primary_text']; $page_breaks_data[$temp_page_number]['secondary_text'] = $row['element_submit_secondary_text']; $page_breaks_data[$temp_page_number]['primary_img'] = $row['element_submit_primary_img']; $page_breaks_data[$temp_page_number]['secondary_img'] = $row['element_submit_secondary_img']; $page_title_array[] = $row['element_page_title']; } //add the last page buttons info into the array for easy lookup $page_breaks_data[$form->page_total]['use_image'] = $form->submit_use_image; $page_breaks_data[$form->page_total]['primary_text'] = $form->submit_primary_text; $page_breaks_data[$form->page_total]['secondary_text'] = $form->submit_secondary_text; $page_breaks_data[$form->page_total]['primary_img'] = $form->submit_primary_img; $page_breaks_data[$form->page_total]['secondary_img'] = $form->submit_secondary_img; if ($form->pagination_type == 'steps') { $page_titles_markup = ''; $i = 1; foreach ($page_title_array as $page_title) { if ($i == $page_number) { $ap_tp_num_active = ' ap_tp_num_active'; $ap_tp_text_active = ' ap_tp_text_active'; } else { $ap_tp_num_active = ''; $ap_tp_text_active = ''; } $page_titles_markup .= '<td align="center"><span id="page_num_' . $i . '" class="ap_tp_num' . $ap_tp_num_active . '">' . $i . '</span><span id="page_title_' . $i . '" class="ap_tp_text' . $ap_tp_text_active . '">' . $page_title . '</span></td><td align="center" class="ap_tp_arrow">></td>' . "\n"; $i++; } //add the last page title into the pagination header markup if ($i == $page_number) { $ap_tp_num_active = ' ap_tp_num_active'; $ap_tp_text_active = ' ap_tp_text_active'; } else { $ap_tp_num_active = ''; $ap_tp_text_active = ''; } $page_titles_markup .= '<td align="center"><span id="page_num_' . $i . '" class="ap_tp_num' . $ap_tp_num_active . '">' . $i . '</span><span id="page_title_' . $i . '" class="ap_tp_text' . $ap_tp_text_active . '">' . $form->lastpage_title . '</span></td>'; //if form review enabled, we need to add the pagination header if (!empty($form->review)) { $i++; $page_titles_markup .= '<td align="center" class="ap_tp_arrow">></td><td align="center"><span id="page_num_' . $i . '" class="ap_tp_num">' . $i . '</span><span id="page_title_' . $i . '" class="ap_tp_text">' . $form->review_title . '</span></td>'; } $pagination_header = <<<EOT \t\t\t<li id="pagination_header" class="li_pagination"> \t\t\t <table class="ap_table_pagination" width="100%" border="0" cellspacing="0" cellpadding="0"> \t\t\t <tr> \t\t\t \t{$page_titles_markup} \t\t\t </tr> \t\t\t</table> \t\t\t</li> EOT; } else { if ($form->pagination_type == 'percentage') { $page_total = count($page_title_array) + 1; if (!empty($form->review)) { $page_total++; } $percent_value = round($page_number / $page_total * 100); if ($percent_value == 100) { //it's not make sense to display 100% when the form is not really submitted yet $percent_value = 99; } if (!empty($form->review)) { if ($page_total - 1 == $page_number) { //if this is last page of the form $current_page_title = $form->lastpage_title; } else { $current_page_title = $page_title_array[$page_number - 1]; } } else { if ($page_total == $page_number) { //if this is last page of the form $current_page_title = $form->lastpage_title; } else { $current_page_title = $page_title_array[$page_number - 1]; } } $page_number_title = sprintf($mf_lang['page_title'], $page_number, $page_total); $pagination_header = <<<EOT \t\t\t<li id="pagination_header" class="li_pagination" title="Click to edit"> \t\t\t <h3 id="page_title_{$page_number}">{$page_number_title} - {$current_page_title}</h3> \t\t\t\t<div class="mf_progress_container"> \t\t\t \t<div id="mf_progress_percentage" class="mf_progress_value" style="width: {$percent_value}%"><span>{$percent_value}%</span></div> \t\t\t\t</div> \t\t\t</li> EOT; } else { $pagination_header = ''; } } //build the submit buttons markup if (empty($edit_id)) { if (empty($page_breaks_data[$page_number]['use_image'])) { //if using text buttons as submit if ($page_number > 1) { $button_secondary_markup = '<input class="button_text btn_secondary" type="submit" id="submit_secondary" name="submit_secondary" value="' . $page_breaks_data[$page_number]['secondary_text'] . '" />'; } $button_markup = <<<EOT \t\t\t<li id="li_buttons" class="buttons"> \t\t\t\t <input type="hidden" name="form_id" value="{$form->id}" /> \t\t\t\t {$edit_markup} \t\t\t\t <input type="hidden" name="submit_form" value="1" /> \t\t\t\t <input type="hidden" name="page_number" value="{$page_number}" /> \t\t\t\t\t<input class="button_text btn_primary" type="submit" id="submit_primary" name="submit_primary" value="{$page_breaks_data[$page_number]['primary_text']}" /> \t\t\t\t\t{$button_secondary_markup} \t\t\t</li> EOT; } else { //if using images as submit if ($page_number > 1) { $button_secondary_markup = '<input class="submit_img_secondary" type="image" alt="Previous" id="submit_secondary" name="submit_secondary" src="' . $page_breaks_data[$page_number]['secondary_img'] . '" />'; } $button_markup = <<<EOT \t\t\t<li id="li_buttons" class="buttons"> \t\t\t\t <input type="hidden" name="form_id" value="{$form->id}" /> \t\t\t\t {$edit_markup} \t\t\t\t <input type="hidden" name="submit_form" value="1" /> \t\t\t\t <input type="hidden" name="page_number" value="{$page_number}" /> \t\t\t\t \t<input class="submit_img_primary" type="image" alt="Continue" id="submit_primary" name="submit_primary" src="{$page_breaks_data[$page_number]['primary_img']}" /> \t\t\t\t\t{$button_secondary_markup} \t\t\t</li> EOT; } } else { //if there is edit_id, then this is edit_entry page, display a standard button $button_markup = <<<EOT \t\t\t<li id="li_buttons" class="buttons"> \t\t\t\t <input type="hidden" name="form_id" value="{$form->id}" /> \t\t\t\t {$edit_markup} \t\t\t\t <input type="hidden" name="submit_form" value="1" /> \t\t\t\t <input type="hidden" name="page_number" value="{$page_number}" /> \t\t\t\t\t<input class="button_text btn_primary" type="submit" id="submit_primary" name="submit_primary" value="Save Changes" /> \t\t\t</li> EOT; } } if ($has_advance_uploader) { if (!empty($machform_path)) { $mf_path_script = <<<EOT <script type="text/javascript"> var __machform_path = '{$machform_path}'; </script> EOT; } $advance_uploader_js = <<<EOT <script type="text/javascript" src="{$machform_path}js/uploadify/swfobject.js"></script> <script type="text/javascript" src="{$machform_path}js/uploadify/jquery.uploadify.js"></script> <script type="text/javascript" src="{$machform_path}js/jquery.jqplugin.min.js"></script> {$mf_path_script} EOT; } if ($integration_method == 'iframe') { $auto_height_js = <<<EOT <script type="text/javascript" src="{$machform_path}js/jquery.ba-postmessage.min.js"></script> <script type="text/javascript"> \$(function(){ \t\$.postMessage({mf_iframe_height: \$('body').outerHeight(true)}, '*', parent ); }); </script> EOT; } //if the form has resume enabled and this is multi page form (single page form doesn't have resume option) if (!empty($form->resume_enable) && $form->page_total > 1) { if (!empty($error_elements['element_resume_email'])) { $li_resume_email_style = ''; $li_resume_error_message = "<p class=\"error\">{$error_elements['element_resume_email']}</p>"; $li_resume_class = 'class="error"'; $li_resume_checked = 'checked="checked"'; $li_resume_button_status = 1; } else { $li_resume_email_style = 'style="display: none"'; $li_resume_error_message = ''; $li_resume_class = ''; $li_resume_checked = ''; $li_resume_button_status = 0; } $form_resume_markup = <<<EOT \t\t\t<li id="li_resume_checkbox"> \t\t\t<div> \t\t\t\t<span><input type="checkbox" value="1" class="element checkbox" name="element_resume_checkbox" id="element_resume_checkbox" {$li_resume_checked}> \t\t\t\t\t<label for="element_resume_checkbox" class="choice">{$mf_lang['resume_checkbox_title']}</label> \t\t\t\t</span> \t\t\t</div> \t\t\t</li> \t\t\t<li id="li_resume_email" {$li_resume_class} {$li_resume_email_style} data-resumebutton="{$li_resume_button_status}" data-resumelabel="{$mf_lang['resume_submit_button_text']}"> \t\t\t\t<label for="element_resume_email" class="description">{$mf_lang['resume_email_input_label']}</label> \t\t\t\t<div> \t\t\t\t\t<input type="text" value="{$populated_values['element_resume_email']}" class="element text medium" name="element_resume_email" id="element_resume_email"> \t\t\t\t</div><p id="guide_resume_email" class="guidelines"><small>{$mf_lang['resume_guideline']}</small></p> {$li_resume_error_message} \t\t\t</li> EOT; } //if the form has enabled merchant support and set the total payment to be displayed if (!empty($form->payment_enable_merchant) && !empty($form->payment_show_total)) { $currency_symbol = '$'; switch ($form->payment_currency) { case 'USD': $currency_symbol = '$'; break; case 'EUR': $currency_symbol = '€'; break; case 'GBP': $currency_symbol = '£'; break; case 'AUD': $currency_symbol = 'A$'; break; case 'CAD': $currency_symbol = 'C$'; break; case 'JPY': $currency_symbol = '¥'; break; case 'THB': $currency_symbol = '฿'; break; case 'HUF': $currency_symbol = 'Ft'; break; case 'CHF': $currency_symbol = 'CHF'; break; case 'CZK': $currency_symbol = 'Kč'; break; case 'SEK': $currency_symbol = 'kr'; break; case 'DKK': $currency_symbol = 'kr'; break; case 'PHP': $currency_symbol = '$'; break; case 'MYR': $currency_symbol = 'RM'; break; case 'PLN': $currency_symbol = 'zł'; break; case 'BRL': $currency_symbol = 'R$'; break; case 'HKD': $currency_symbol = 'HK$'; break; case 'MXN': $currency_symbol = 'Mex$'; break; case 'TWD': $currency_symbol = 'NT$'; break; case 'TRY': $currency_symbol = 'TL'; break; } if ($form->payment_price_type == 'variable') { //if this is multipage form, we need to get the total selected price from other pages if ($form->page_total > 1) { $other_page_total_payment = (double) mf_get_payment_total($dbh, $form_id, $session_id, $page_number); $other_page_total_data_tag = 'data-basetotal="' . $other_page_total_payment . '"'; } else { $other_page_total_data_tag = 'data-basetotal="0"'; } } elseif ($form->payment_price_type == 'fixed') { $other_page_total_data_tag = 'data-basetotal="' . $form->payment_price_amount . '"'; } $payment_total_markup = <<<EOT \t\t\t<li class="total_payment" {$other_page_total_data_tag}> \t\t\t\t<span> \t\t\t\t\t<h3>{$currency_symbol}<var>0</var></h3> \t\t\t\t\t<h5>{$mf_lang['payment_total']}</h5> \t\t\t\t</span> \t\t\t</li> EOT; if ($form->payment_total_location == 'top') { $payment_total_markup_top = $payment_total_markup; } else { if ($form->payment_total_location == 'bottom') { $payment_total_markup_bottom = $payment_total_markup; } else { if ($form->payment_total_location == 'top-bottom' || $form->payment_total_location == 'all') { $payment_total_markup_top = $payment_total_markup; $payment_total_markup_bottom = $payment_total_markup; } } } } if (empty($mf_settings['disable_machform_link'])) { $powered_by_markup = 'Powered by MachForm'; } else { $powered_by_markup = ''; } //if advanced form code being used, display the form without body container if ($integration_method == 'php') { $container_class .= " integrated"; if (!empty($edit_id)) { $view_css_markup = '<link rel="stylesheet" type="text/css" href="css/edit_entry.css" media="all" />'; } else { $view_css_markup = "<link rel=\"stylesheet\" type=\"text/css\" href=\"{$machform_path}{$css_dir}view.css\" media=\"all\" />"; } $form_markup = <<<EOT {$view_css_markup} {$theme_css_link} {$font_css_markup} <style> html{ \tbackground: none repeat scroll 0 0 transparent; \tbackground-color: transparent; } </style> <script type="text/javascript" src="{$machform_path}js/jquery.min.js"></script> <script type="text/javascript" src="{$machform_path}js/jquery-ui/ui/jquery.effects.core.js"></script> <script type="text/javascript" src="{$machform_path}view.js"></script> {$advance_uploader_js} {$calendar_init} <div id="main_body" class="{$container_class}"> \t<div id="form_container"> \t \t\t<h1><a>{$form->name}</a></h1> \t\t<form id="form_{$form->id}" class="appnitro {$form->label_alignment}" {$form_enc_type} method="post" data-highlightcolor="{$field_highlight_color}" action="#main_body"> \t\t\t{$form_desc_div}\t\t\t\t\t\t \t\t\t<ul {$ul_class}> \t\t\t{$pagination_header} \t\t\t{$payment_total_markup_top} \t\t\t{$form->error_message} \t\t\t{$all_element_markup} \t\t\t{$custom_element} \t\t\t{$payment_total_markup_bottom} \t\t\t{$form_resume_markup} \t\t\t{$button_markup} \t\t\t</ul> \t\t</form>\t \t\t<div id="footer"> \t\t\t{$powered_by_markup} \t\t</div> \t</div>\t </div> EOT; } else { $form_markup = <<<EOT <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html {$html_class_tag} xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>{$form->name}</title> <link rel="stylesheet" type="text/css" href="data/form_default/css/view.css" media="all" /> {$theme_css_link} {$font_css_markup} <script type="text/javascript" src="{$machform_path}js/jquery.min.js"></script> <script type="text/javascript" src="{$machform_path}js/jquery-ui/ui/jquery.effects.core.js"></script> <script type="text/javascript" src="{$machform_path}view.js"></script> {$advance_uploader_js} {$calendar_init} {$auto_height_js} </head> <body id="main_body" class="{$container_class}"> \t \t<div id="form_container" class="{$form_container_class}"> \t \t\t<h1><a>{$form->name}</a></h1> \t\t<form id="form_{$form->id}" class="appnitro {$form->label_alignment}" {$form_enc_type} method="post" data-highlightcolor="{$field_highlight_color}" action="#main_body"> \t\t\t{$form_desc_div}\t\t\t\t\t\t \t\t\t<ul {$ul_class}> \t\t\t{$pagination_header} \t\t\t{$payment_total_markup_top} \t\t\t{$form->error_message} \t\t\t{$all_element_markup} \t\t\t{$custom_element} \t\t\t{$payment_total_markup_bottom} \t\t\t{$form_resume_markup} \t\t\t{$button_markup} \t\t\t</ul> \t\t</form>\t \t\t<div id="footer"> \t\t\t{$powered_by_markup} \t\t</div> \t</div> \t \t</body> </html> EOT; } return $form_markup; }
$form_params['custom_error'] = $custom_error; $form_params['edit_id'] = $input_array['edit_id']; $form_params['integration_method'] = 'php'; $form_params['page_number'] = 0; //display all pages (if any) as a single page $form_markup = mf_display_form($dbh, $input_array['form_id'], $form_params); } } } else { //otherwise, display the form with the values //set session value to override password protected form $_SESSION['user_authenticated'] = $form_id; //set session value to bypass unique checking $_SESSION['edit_entry']['form_id'] = $form_id; $_SESSION['edit_entry']['entry_id'] = $entry_id; $form_values = mf_get_entry_values($dbh, $form_id, $entry_id); $form_params = array(); $form_params['populated_values'] = $form_values; $form_params['edit_id'] = $entry_id; $form_params['integration_method'] = 'php'; $form_params['page_number'] = 0; //display all pages (if any) as a single page $form_markup = mf_display_form($dbh, $form_id, $form_params); } $header_data = <<<EOT <link type="text/css" href="js/jquery-ui/themes/base/jquery.ui.all.css" rel="stylesheet" /> <link rel="stylesheet" type="text/css" href="css/entry_print.css" media="print"> EOT; $current_nav_tab = 'manage_forms'; require 'includes/header.php'; ?>
function mf_send_notification($dbh, $form_id, $entry_id, $to_emails, $email_param) { $from_name = $email_param['from_name']; $from_email = $email_param['from_email']; $subject = $email_param['subject']; $content = $email_param['content']; $as_plain_text = $email_param['as_plain_text']; //if set to 'true' the email content will be a simple plain text $target_is_admin = $email_param['target_is_admin']; //if set to 'false', the download link for uploaded file will be removed //get settings first $mf_settings = mf_get_settings($dbh); //get data for the particular entry id if ($target_is_admin === false) { $options['strip_download_link'] = true; } $options['strip_checkbox_image'] = true; $options['machform_base_path'] = $email_param['machform_base_path']; //the path to machform $entry_details = mf_get_entry_details($dbh, $form_id, $entry_id, $options); //populate field values to template variables $i = 0; foreach ($entry_details as $data) { $template_variables[$i] = '{element_' . $data['element_id'] . '}'; $template_values[$i] = $data['value']; if ($data['element_type'] == 'textarea') { $template_values[$i] = nl2br($data['value']); } elseif ($data['element_type'] == 'file') { if ($target_is_admin === false) { $template_values[$i] = strip_tags($data['value']); } else { $template_values[$i] = strip_tags($data['value'], '<a><br/>'); } } else { $template_values[$i] = $data['value']; } $i++; } $entry_values = mf_get_entry_values($dbh, $form_id, $entry_id); //get template variables for some complex fields (name and address) $query = "select \r\n\t\t\t\t\t\t element_id,\r\n\t\t\t\t\t\t element_type \r\n\t\t\t\t from\r\n\t\t\t\t \t `" . MF_TABLE_PREFIX . "form_elements` \r\n\t\t\t\t where \r\n\t\t\t\t \t form_id=? and \r\n\t\t\t\t \t element_type != 'section' and \r\n\t\t\t\t \t element_status=1 and\r\n\t\t\t\t \t element_type in('simple_name','simple_name_wmiddle','name','name_wmiddle','address')\r\n\t\t\t\t order by \r\n\t\t\t\t \t\t element_position asc"; $params = array($form_id); $sth = mf_do_query($query, $params, $dbh); while ($row = mf_do_fetch_result($sth)) { $element_id = $row['element_id']; $element_type = $row['element_type']; if ('simple_name' == $element_type) { $total_sub_field = 2; } else { if ('simple_name_wmiddle' == $element_type) { $total_sub_field = 3; } else { if ('name' == $element_type) { $total_sub_field = 4; } else { if ('name_wmiddle' == $element_type) { $total_sub_field = 5; } else { if ('address' == $element_type) { $total_sub_field = 6; } } } } } for ($j = 1; $j <= $total_sub_field; $j++) { $template_variables[$i] = '{element_' . $element_id . '_' . $j . '}'; $template_values[$i] = $entry_values['element_' . $element_id . '_' . $j]['default_value']; $i++; } } //get entry timestamp $query = "select date_created,ip_address from `" . MF_TABLE_PREFIX . "form_{$form_id}` where id=?"; $params = array($entry_id); $sth = mf_do_query($query, $params, $dbh); $row = mf_do_fetch_result($sth); $date_created = $row['date_created']; $ip_address = $row['ip_address']; //get form name $query = "select form_name\tfrom `" . MF_TABLE_PREFIX . "forms` where form_id=?"; $params = array($form_id); $sth = mf_do_query($query, $params, $dbh); $row = mf_do_fetch_result($sth); $form_name = $row['form_name']; $template_variables[$i] = '{date_created}'; $template_values[$i] = $date_created; $i++; $template_variables[$i] = '{ip_address}'; $template_values[$i] = $ip_address; $i++; $template_variables[$i] = '{form_name}'; $template_values[$i] = $form_name; $i++; $template_variables[$i] = '{entry_no}'; $template_values[$i] = $entry_id; $i++; $template_variables[$i] = '{form_id}'; $template_values[$i] = $form_id; //compose {entry_data} based on 'as_plain_text' preferences $email_body = ''; $files_to_attach = array(); if (!$as_plain_text) { //compose html format $email_body = '<table width="100%" border="0" cellspacing="0" cellpadding="0" style="font-family:Lucida Grande,Tahoma,Arial,Verdana,sans-serif;font-size:12px;text-align:left">' . "\n"; $toggle = false; $j = 0; foreach ($entry_details as $data) { //0 should be displayed, empty string don't if ((empty($data['value']) || $data['value'] == ' ') && $data['value'] !== 0 && $data['value'] !== '0') { continue; } //skip pagebreak if ($data['label'] == 'mf_page_break' && $data['value'] == 'mf_page_break') { continue; } if ($toggle) { $toggle = false; $row_style = 'style="background-color:#F3F7FB"'; } else { $toggle = true; $row_style = ''; } if ($data['element_type'] == 'textarea') { $data['value'] = nl2br($data['value']); } elseif ($data['element_type'] == 'file') { if ($target_is_admin === false) { $data['value'] = strip_tags($data['value']); } else { $data['value'] = strip_tags($data['value'], '<a><br/>'); $data['value'] = str_replace(' ', '', $data['value']); //if there is file to be attached if (!empty($data['filedata'])) { foreach ($data['filedata'] as $file_info) { $files_to_attach[$j]['filename_path'] = $file_info['filename_path']; $files_to_attach[$j]['filename_value'] = $file_info['filename_value']; $j++; } } } } $email_body .= "<tr {$row_style}>\n"; $email_body .= '<td width="40%" style="border-bottom:1px solid #DEDEDE;padding:5px 10px;"><strong>' . $data['label'] . '</strong> </td>' . "\n"; $email_body .= '<td width="60%" style="border-bottom:1px solid #DEDEDE;padding:5px 10px;">' . $data['value'] . '</td>' . "\n"; $email_body .= '</tr>' . "\n"; $i++; } $email_body .= "</table>\n"; } else { $money_symbols = array('¥', '£', '€', '฿', 'Kč', 'zł', '﷼'); $money_plain = array('¥', '£', '€', '฿', 'Kč', 'zł', '﷼'); //compose text format foreach ($entry_details as $data) { //0 should be displayed, empty string don't if ((empty($data['value']) || $data['value'] == ' ') && $data['value'] !== 0 && $data['value'] !== '0') { continue; } $data['value'] = str_replace('<br />', "\n", $data['value']); if ($data['element_type'] == 'textarea' || $data['element_type'] == 'matrix') { $data['value'] = trim($data['value'], "\n"); $email_body .= "{$data['label']}: \n" . $data['value'] . "\n\n"; } elseif ($data['element_type'] == 'checkbox' || $data['element_type'] == 'address') { $email_body .= "{$data['label']}: \n" . $data['value'] . "\n\n"; } elseif ($data['element_type'] == 'file') { $data['value'] = strip_tags($data['value']); $data['value'] = str_replace(' ', "\n- ", $data['value']); $email_body .= "{$data['label']}: {$data['value']}\n"; } elseif ($data['element_type'] == 'money') { $data['value'] = str_replace($money_symbols, $money_plain, $data['value']); $email_body .= "{$data['label']}: {$data['value']} \n\n"; } elseif ($data['element_type'] == 'url') { $data['value'] = strip_tags($data['value']); $email_body .= "{$data['label']}: {$data['value']} \n\n"; } else { $email_body .= "{$data['label']}: {$data['value']} \n\n"; } } } $i = count($template_variables); $template_variables[$i] = '{entry_data}'; $template_values[$i] = $email_body; //create the mail transport if (!empty($mf_settings['smtp_enable'])) { $s_transport = Swift_SmtpTransport::newInstance($mf_settings['smtp_host'], $mf_settings['smtp_port']); if (!empty($mf_settings['smtp_secure'])) { $s_transport->setEncryption('tls'); } if (!empty($mf_settings['smtp_auth'])) { $s_transport->setUsername($mf_settings['smtp_username']); $s_transport->setPassword($mf_settings['smtp_password']); } } else { $s_transport = Swift_MailTransport::newInstance(); //use PHP mail() transport } //create mailer instance $s_mailer = Swift_Mailer::newInstance($s_transport); if (file_exists($mf_settings['upload_dir'] . "/form_{$form_id}/files")) { Swift_Preferences::getInstance()->setCacheType('disk')->setTempDir($mf_settings['upload_dir'] . "/form_{$form_id}/files"); } //create the message //parse from_name template if (!empty($from_name)) { $from_name = str_replace($template_variables, $template_values, $from_name); $from_name = str_replace(' ', '', $from_name); //decode any html entity $from_name = html_entity_decode($from_name, ENT_QUOTES); } else { $from_name = 'MachForm'; } //parse from_email_address template if (!empty($from_email)) { $from_email = str_replace($template_variables, $template_values, $from_email); } else { $domain = str_replace('www.', '', $_SERVER['SERVER_NAME']); $from_email = "no-reply@{$domain}"; } //parse subject template if (!empty($subject)) { $subject = str_replace($template_variables, $template_values, $subject); $subject = str_replace(' ', '', $subject); } else { if ($target_is_admin) { $subject = utf8_encode("{$form_name} [#{$entry_id}]"); } else { $subject = utf8_encode("{$form_name} - Receipt"); } } //decode any html entity $subject = html_entity_decode($subject, ENT_QUOTES); //parse content template $email_content = str_replace($template_variables, $template_values, $content); if (!$as_plain_text) { //html type //add footer if (empty($mf_settings['disable_machform_link'])) { $email_content .= "<br /><br /><br /><br /><br /><b style=\"font-family:Lucida Grande,Tahoma,Arial,Verdana,sans-serif;font-size:12px\">Powered by MachForm</b>"; } //enclose with container div $email_content = '<div style="font-family:Lucida Grande,Tahoma,Arial,Verdana,sans-serif;font-size:12px">' . $email_content . '</div>'; } $to_emails = str_replace(' ', '', str_replace($template_variables, $template_values, $to_emails)); if (!empty($to_emails)) { $email_address = explode(',', $to_emails); } if (!empty($email_address)) { if (!$as_plain_text) { $email_content_type = 'text/html'; } else { $email_content_type = 'text/plain'; } $s_message = Swift_Message::newInstance()->setCharset('utf-8')->setMaxLineLength(1000)->setSubject($subject)->setFrom(array($from_email => $from_name))->setSender($from_email)->setReturnPath($from_email)->setTo($email_address)->setBody($email_content, $email_content_type); //attach files, if any if (!empty($files_to_attach)) { foreach ($files_to_attach as $file_data) { $s_message->attach(Swift_Attachment::fromPath($file_data['filename_path'])->setFilename($file_data['filename_value'])); } } //send the message $send_result = $s_mailer->send($s_message); if (empty($send_result)) { echo "Error sending email!"; } } }
function mf_send_notification($dbh, $form_id, $entry_id, $to_emails, $email_param) { global $mf_hook_emails; global $mf_lang; $from_name = $email_param['from_name']; $from_email = $email_param['from_email']; $subject = $email_param['subject']; $content = $email_param['content']; $as_plain_text = $email_param['as_plain_text']; //if set to 'true' the email content will be a simple plain text $target_is_admin = $email_param['target_is_admin']; //if set to 'false', the download link for uploaded file will be removed $check_hook_file = $email_param['check_hook_file']; //get settings first $mf_settings = mf_get_settings($dbh); //get data for the particular entry id if ($target_is_admin === false) { $options['strip_download_link'] = false; //as of v3, receipt email should display download link } $options['strip_checkbox_image'] = true; $options['machform_path'] = $email_param['machform_base_path']; //the path to machform $entry_details = mf_get_entry_details($dbh, $form_id, $entry_id, $options); //if the form has payment enabled, get the payment details //start getting payment details ----------------------- $query = "select \r\n\t\t\t\t\t payment_enable_merchant,\r\n\t\t\t\t\t payment_merchant_type,\r\n\t\t\t\t\t payment_price_type,\r\n\t\t\t\t\t payment_price_amount,\r\n\t\t\t\t\t payment_currency,\r\n\t\t\t\t\t payment_ask_billing,\r\n\t\t\t\t\t payment_ask_shipping\r\n\t\t\t from \r\n\t\t\t \t " . MF_TABLE_PREFIX . "forms \r\n\t\t\t where \r\n\t\t\t \t form_id = ?"; $params = array($form_id); $sth = mf_do_query($query, $params, $dbh); $row = mf_do_fetch_result($sth); if (!empty($row)) { $payment_enable_merchant = (int) $row['payment_enable_merchant']; if ($payment_enable_merchant < 1) { $payment_enable_merchant = 0; } $payment_price_amount = (double) $row['payment_price_amount']; $payment_merchant_type = $row['payment_merchant_type']; $payment_price_type = $row['payment_price_type']; $form_payment_currency = strtoupper($row['payment_currency']); $payment_ask_billing = (int) $row['payment_ask_billing']; $payment_ask_shipping = (int) $row['payment_ask_shipping']; } if (!empty($payment_enable_merchant)) { $query = "SELECT \r\n\t\t\t\t\t\t\t`payment_id`,\r\n\t\t\t\t\t\t\t date_format(payment_date,'%e %b %Y - %r') payment_date, \r\n\t\t\t\t\t\t\t`payment_status`, \r\n\t\t\t\t\t\t\t`payment_fullname`, \r\n\t\t\t\t\t\t\t`payment_amount`, \r\n\t\t\t\t\t\t\t`payment_currency`, \r\n\t\t\t\t\t\t\t`payment_test_mode`,\r\n\t\t\t\t\t\t\t`payment_merchant_type`, \r\n\t\t\t\t\t\t\t`status`, \r\n\t\t\t\t\t\t\t`billing_street`, \r\n\t\t\t\t\t\t\t`billing_city`, \r\n\t\t\t\t\t\t\t`billing_state`, \r\n\t\t\t\t\t\t\t`billing_zipcode`, \r\n\t\t\t\t\t\t\t`billing_country`, \r\n\t\t\t\t\t\t\t`same_shipping_address`, \r\n\t\t\t\t\t\t\t`shipping_street`, \r\n\t\t\t\t\t\t\t`shipping_city`, \r\n\t\t\t\t\t\t\t`shipping_state`, \r\n\t\t\t\t\t\t\t`shipping_zipcode`, \r\n\t\t\t\t\t\t\t`shipping_country`\r\n\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t" . MF_TABLE_PREFIX . "form_payments\r\n\t\t\t\t\t WHERE\r\n\t\t\t\t\t \t\tform_id = ? and record_id = ? and `status` = 1\r\n\t\t\t\t\tORDER BY\r\n\t\t\t\t\t\t\tpayment_date DESC\r\n\t\t\t\t\t LIMIT 1"; $params = array($form_id, $entry_id); $sth = mf_do_query($query, $params, $dbh); $row = mf_do_fetch_result($sth); $payment_id = $row['payment_id']; $payment_date = $row['payment_date']; $payment_status = $row['payment_status']; $payment_fullname = $row['payment_fullname']; $payment_amount = (double) $row['payment_amount']; $payment_currency = strtoupper($row['payment_currency']); $payment_test_mode = (int) $row['payment_test_mode']; $payment_merchant_type = $row['payment_merchant_type']; $billing_street = htmlspecialchars(trim($row['billing_street'])); $billing_city = htmlspecialchars(trim($row['billing_city'])); $billing_state = htmlspecialchars(trim($row['billing_state'])); $billing_zipcode = htmlspecialchars(trim($row['billing_zipcode'])); $billing_country = htmlspecialchars(trim($row['billing_country'])); $same_shipping_address = (int) $row['same_shipping_address']; if (!empty($same_shipping_address)) { $shipping_street = $billing_street; $shipping_city = $billing_city; $shipping_state = $billing_state; $shipping_zipcode = $billing_zipcode; $shipping_country = $billing_country; } else { $shipping_street = htmlspecialchars(trim($row['shipping_street'])); $shipping_city = htmlspecialchars(trim($row['shipping_city'])); $shipping_state = htmlspecialchars(trim($row['shipping_state'])); $shipping_zipcode = htmlspecialchars(trim($row['shipping_zipcode'])); $shipping_country = htmlspecialchars(trim($row['shipping_country'])); } if (!empty($billing_street) || !empty($billing_city) || !empty($billing_state) || !empty($billing_zipcode) || !empty($billing_country)) { $billing_address = "{$billing_street}<br />{$billing_city}, {$billing_state} {$billing_zipcode}<br />{$billing_country}"; } if (!empty($shipping_street) || !empty($shipping_city) || !empty($shipping_state) || !empty($shipping_zipcode) || !empty($shipping_country)) { $shipping_address = "{$shipping_street}<br />{$shipping_city}, {$shipping_state} {$shipping_zipcode}<br />{$shipping_country}"; } if (!empty($row)) { $payment_has_record = true; } else { //if the entry doesn't have any record within ap_form_payments table //we need to calculate the total amount $payment_has_record = false; $payment_status = "unpaid"; if ($payment_price_type == 'variable') { $payment_amount = (double) mf_get_payment_total($dbh, $form_id, $entry_id, 0, 'live'); } else { if ($payment_price_type == 'fixed') { $payment_amount = $payment_price_amount; } } $payment_currency = $form_payment_currency; } if (!$as_plain_text) { switch ($payment_currency) { case 'USD': $currency_symbol = '$'; break; case 'EUR': $currency_symbol = '€'; break; case 'GBP': $currency_symbol = '£'; break; case 'AUD': $currency_symbol = '$'; break; case 'CAD': $currency_symbol = '$'; break; case 'JPY': $currency_symbol = '¥'; break; case 'THB': $currency_symbol = '฿'; break; case 'HUF': $currency_symbol = 'Ft'; break; case 'CHF': $currency_symbol = 'CHF'; break; case 'CZK': $currency_symbol = 'Kč'; break; case 'SEK': $currency_symbol = 'kr'; break; case 'DKK': $currency_symbol = 'kr'; break; case 'NOK': $currency_symbol = 'kr'; break; case 'PHP': $currency_symbol = '$'; break; case 'MYR': $currency_symbol = 'RM'; break; case 'PLN': $currency_symbol = 'zł'; break; case 'BRL': $currency_symbol = 'R$'; break; case 'HKD': $currency_symbol = '$'; break; case 'MXN': $currency_symbol = 'Mex$'; break; case 'TWD': $currency_symbol = 'NT$'; break; case 'TRY': $currency_symbol = 'TL'; break; case 'NZD': $currency_symbol = '$'; break; case 'SGD': $currency_symbol = '$'; break; default: $currency_symbol = ''; break; } } else { switch ($payment_currency) { case 'USD': $currency_symbol = '$'; break; case 'EUR': $currency_symbol = '€'; break; case 'GBP': $currency_symbol = '£'; break; case 'AUD': $currency_symbol = '$'; break; case 'CAD': $currency_symbol = '$'; break; case 'JPY': $currency_symbol = '¥'; break; case 'THB': $currency_symbol = '฿'; break; case 'HUF': $currency_symbol = 'Ft'; break; case 'CHF': $currency_symbol = 'CHF'; break; case 'CZK': $currency_symbol = 'Kč'; break; case 'SEK': $currency_symbol = 'kr'; break; case 'DKK': $currency_symbol = 'kr'; break; case 'NOK': $currency_symbol = 'kr'; break; case 'PHP': $currency_symbol = '$'; break; case 'MYR': $currency_symbol = 'RM'; break; case 'PLN': $currency_symbol = 'zł'; break; case 'BRL': $currency_symbol = 'R$'; break; case 'HKD': $currency_symbol = '$'; break; case 'MXN': $currency_symbol = '$'; break; case 'TWD': $currency_symbol = '$'; break; case 'TRY': $currency_symbol = 'TL'; break; case 'NZD': $currency_symbol = '$'; break; case 'SGD': $currency_symbol = '$'; break; default: $currency_symbol = ''; break; } } $total_payment_amount = $currency_symbol . $payment_amount . ' ' . $payment_currency; $total_entry_details = count($entry_details); //blank row for separator if (!$as_plain_text) { $entry_details[$total_entry_details]['value'] = ' '; $entry_details[$total_entry_details]['label'] = ' '; } else { $entry_details[$total_entry_details]['value'] = ''; $entry_details[$total_entry_details]['label'] = ''; } //get total amount $total_entry_details++; $entry_details[$total_entry_details]['value'] = $total_payment_amount; $entry_details[$total_entry_details]['label'] = $mf_lang['payment_total']; //get payment status $total_entry_details++; if (!empty($payment_test_mode)) { $entry_details[$total_entry_details]['value'] = strtoupper($payment_status) . ' (TEST mode)'; } else { $entry_details[$total_entry_details]['value'] = strtoupper($payment_status); } $entry_details[$total_entry_details]['label'] = $mf_lang['payment_status']; if ($payment_has_record) { //get payment id $total_entry_details++; $entry_details[$total_entry_details]['value'] = $payment_id; $entry_details[$total_entry_details]['label'] = $mf_lang['payment_id']; //get payment date $total_entry_details++; $entry_details[$total_entry_details]['value'] = $payment_date; $entry_details[$total_entry_details]['label'] = $mf_lang['payment_date']; //blank row for separator $total_entry_details++; if (!$as_plain_text) { $entry_details[$total_entry_details]['value'] = ' '; $entry_details[$total_entry_details]['label'] = ' '; } else { $entry_details[$total_entry_details]['value'] = ''; $entry_details[$total_entry_details]['label'] = ''; } //get full name $total_entry_details++; $entry_details[$total_entry_details]['value'] = htmlspecialchars($payment_fullname, ENT_QUOTES); $entry_details[$total_entry_details]['label'] = $mf_lang['payment_fullname']; //get billing address if (!empty($payment_ask_billing) && !empty($billing_address)) { $total_entry_details++; $entry_details[$total_entry_details]['value'] = $billing_address; $entry_details[$total_entry_details]['label'] = $mf_lang['payment_billing']; } //get shipping address if (!empty($payment_ask_shipping) && !empty($shipping_address)) { $total_entry_details++; $entry_details[$total_entry_details]['value'] = $shipping_address; $entry_details[$total_entry_details]['label'] = $mf_lang['payment_shipping']; } } } //end payment enable merchant //end getting payment details ----------------------- //populate field values to template variables $i = 0; foreach ($entry_details as $data) { $template_variables[$i] = '{element_' . $data['element_id'] . '}'; $template_values[$i] = $data['value']; if ($data['element_type'] == 'textarea' && !$as_plain_text) { $template_values[$i] = nl2br($data['value']); } elseif ($data['element_type'] == 'file') { if (!$as_plain_text) { $template_values[$i] = strip_tags($data['value'], '<a><br/>'); } else { $template_values[$i] = strip_tags($data['value']); $template_values[$i] = str_replace(' ', "\n- ", $template_values[$i]); } } elseif ($data['element_type'] == 'signature') { //skip the signature, we will construct the value later below continue; } else { $template_values[$i] = $data['value']; } $i++; } $entry_values = mf_get_entry_values($dbh, $form_id, $entry_id); //get template variables for some complex fields (name and address) $query = "select \r\n\t\t\t\t\t\t element_id,\r\n\t\t\t\t\t\t element_type \r\n\t\t\t\t from\r\n\t\t\t\t \t `" . MF_TABLE_PREFIX . "form_elements` \r\n\t\t\t\t where \r\n\t\t\t\t \t form_id=? and \r\n\t\t\t\t \t element_type != 'section' and \r\n\t\t\t\t \t element_status=1 and\r\n\t\t\t\t \t element_type in('simple_name','simple_name_wmiddle','name','name_wmiddle','address')\r\n\t\t\t\t order by \r\n\t\t\t\t \t\t element_position asc"; $params = array($form_id); $sth = mf_do_query($query, $params, $dbh); while ($row = mf_do_fetch_result($sth)) { $element_id = $row['element_id']; $element_type = $row['element_type']; if ('simple_name' == $element_type) { $total_sub_field = 2; } else { if ('simple_name_wmiddle' == $element_type) { $total_sub_field = 3; } else { if ('name' == $element_type) { $total_sub_field = 4; } else { if ('name_wmiddle' == $element_type) { $total_sub_field = 5; } else { if ('address' == $element_type) { $total_sub_field = 6; } } } } } for ($j = 1; $j <= $total_sub_field; $j++) { $template_variables[$i] = '{element_' . $element_id . '_' . $j . '}'; $template_values[$i] = $entry_values['element_' . $element_id . '_' . $j]['default_value']; $i++; } } //get entry timestamp $query = "select date_created,ip_address from `" . MF_TABLE_PREFIX . "form_{$form_id}` where id=?"; $params = array($entry_id); $sth = mf_do_query($query, $params, $dbh); $row = mf_do_fetch_result($sth); $date_created = $row['date_created']; $ip_address = $row['ip_address']; //get form name $query = "select form_name\tfrom `" . MF_TABLE_PREFIX . "forms` where form_id=?"; $params = array($form_id); $sth = mf_do_query($query, $params, $dbh); $row = mf_do_fetch_result($sth); $form_name = $row['form_name']; $template_variables[$i] = '{date_created}'; $template_values[$i] = $date_created; $i++; $template_variables[$i] = '{ip_address}'; $template_values[$i] = $ip_address; $i++; $template_variables[$i] = '{form_name}'; $template_values[$i] = $form_name; $i++; $template_variables[$i] = '{entry_no}'; $template_values[$i] = $entry_id; $i++; $template_variables[$i] = '{form_id}'; $template_values[$i] = $form_id; //populate template variables for payment details if (!empty($total_payment_amount)) { $i++; $template_variables[$i] = '{total_amount}'; $template_values[$i] = $total_payment_amount; } if (!empty($payment_status)) { $i++; $template_variables[$i] = '{payment_status}'; if (!empty($payment_test_mode)) { $template_values[$i] = strtoupper($payment_status) . ' (TEST mode)'; } else { $template_values[$i] = strtoupper($payment_status); } } if (!empty($payment_id)) { $i++; $template_variables[$i] = '{payment_id}'; $template_values[$i] = $payment_id; } if (!empty($payment_date)) { $i++; $template_variables[$i] = '{payment_date}'; $template_values[$i] = $payment_date; } if (!empty($payment_fullname)) { $i++; $template_variables[$i] = '{payment_fullname}'; $template_values[$i] = $payment_fullname; } if (!empty($billing_address)) { if ($as_plain_text) { $billing_address = str_replace('<br />', "\n", $billing_address); } $i++; $template_variables[$i] = '{billing_address}'; $template_values[$i] = $billing_address; } if (!empty($shipping_address)) { if ($as_plain_text) { $shipping_address = str_replace('<br />', "\n", $shipping_address); } $i++; $template_variables[$i] = '{shipping_address}'; $template_values[$i] = $shipping_address; } //compose {entry_data} based on 'as_plain_text' preferences $email_body = ''; $files_to_attach = array(); if (!$as_plain_text) { //compose html format $email_body = '<table width="100%" border="0" cellspacing="0" cellpadding="0" style="font-family:Lucida Grande,Tahoma,Arial,Verdana,sans-serif;font-size:12px;text-align:left">' . "\n"; $toggle = false; $j = 0; foreach ($entry_details as $data) { //0 should be displayed, empty string don't if ((empty($data['value']) || $data['value'] == ' ') && $data['value'] !== 0 && $data['value'] !== '0' && $data['element_type'] !== 'section') { continue; } //skip pagebreak if ($data['label'] == 'mf_page_break' && $data['value'] == 'mf_page_break') { continue; } if ($toggle) { $toggle = false; $row_style = 'style="background-color:#F3F7FB"'; } else { $toggle = true; $row_style = ''; } if ($data['element_type'] == 'textarea') { $data['value'] = nl2br($data['value']); } elseif ($data['element_type'] == 'file') { if ($target_is_admin === false) { $data['value'] = strip_tags($data['value'], '<a><br/>'); $data['value'] = str_replace(' ', '', $data['value']); } else { $data['value'] = strip_tags($data['value'], '<a><br/>'); $data['value'] = str_replace(' ', '', $data['value']); //if there is file to be attached if (!empty($data['filedata'])) { foreach ($data['filedata'] as $file_info) { $files_to_attach[$j]['filename_path'] = $file_info['filename_path']; $files_to_attach[$j]['filename_value'] = $file_info['filename_value']; $j++; } } } } elseif ($data['element_type'] == 'signature') { $element_id = $data['element_id']; $signature_hash = md5($data['value']); //encode the long query string for more readibility $q_string = base64_encode("form_id={$form_id}&id={$entry_id}&el=element_{$element_id}&hash={$signature_hash}"); if (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off') { $ssl_suffix = 's'; } else { $ssl_suffix = ''; } if (!empty($email_param['machform_base_path'])) { //if the form is called from advanced form code $data['value'] = '<a href="' . $email_param['machform_base_path'] . 'signature.php?q=' . $q_string . '">View Signature</a>'; } else { $data['value'] = '<a href="http' . $ssl_suffix . '://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . '/signature.php?q=' . $q_string . '">View Signature</a>'; } //construct template variables $template_variables[$i] = '{element_' . $data['element_id'] . '}'; $template_values[$i] = $data['value']; $i++; } if ($data['element_type'] == 'section') { if (!empty($data['label']) && !empty($data['value']) && $data['value'] != ' ') { $section_separator = '<br/>'; } else { $section_separator = ''; } $section_break_content = '<span><strong>' . nl2br($data['label']) . '</strong></span>' . $section_separator . '<span>' . nl2br($data['value']) . '</span>'; $email_body .= "<tr {$row_style}>\n"; $email_body .= '<td width="100%" colspan="2" style="border-bottom:1px solid #DEDEDE;padding:5px 10px;">' . $section_break_content . '</td>' . "\n"; $email_body .= '</tr>' . "\n"; } else { $email_body .= "<tr {$row_style}>\n"; $email_body .= '<td width="40%" style="border-bottom:1px solid #DEDEDE;padding:5px 10px;"><strong>' . $data['label'] . '</strong></td>' . "\n"; $email_body .= '<td width="60%" style="border-bottom:1px solid #DEDEDE;padding:5px 10px;">' . $data['value'] . '</td>' . "\n"; $email_body .= '</tr>' . "\n"; } $i++; } $email_body .= "</table>\n"; } else { $money_symbols = array('¥', '£', '€', '฿', 'Kč', 'zł', '﷼'); $money_plain = array('¥', '£', '€', '฿', 'Kč', 'zł', '﷼'); //compose text format foreach ($entry_details as $data) { $data['value'] = htmlspecialchars_decode($data['value'], ENT_QUOTES); //0 should be displayed, empty string don't if ((empty($data['value']) || $data['value'] == ' ') && $data['value'] !== 0 && $data['value'] !== '0') { continue; } //skip pagebreak if ($data['label'] == 'mf_page_break' && $data['value'] == 'mf_page_break') { continue; } $data['value'] = str_replace('<br />', "\n", $data['value']); if ($data['element_type'] == 'textarea' || $data['element_type'] == 'matrix') { $data['value'] = trim($data['value'], "\n"); $email_body .= "{$data['label']}: \n" . $data['value'] . "\n\n"; } elseif ($data['element_type'] == 'section') { $data['value'] = trim($data['value'], "\n"); $email_body .= "{$data['label']} \n" . $data['value'] . "\n\n"; } elseif ($data['element_type'] == 'checkbox' || $data['element_type'] == 'address') { $email_body .= "{$data['label']}: \n" . $data['value'] . "\n\n"; } elseif ($data['element_type'] == 'file') { $data['value'] = strip_tags($data['value']); $data['value'] = str_replace(' ', "\n- ", $data['value']); $email_body .= "{$data['label']}: {$data['value']}\n"; //if there is file to be attached if (!empty($data['filedata'])) { foreach ($data['filedata'] as $file_info) { $files_to_attach[$j]['filename_path'] = $file_info['filename_path']; $files_to_attach[$j]['filename_value'] = $file_info['filename_value']; $j++; } } } elseif ($data['element_type'] == 'money') { $data['value'] = str_replace($money_symbols, $money_plain, $data['value']); $email_body .= "{$data['label']}: {$data['value']} \n\n"; } elseif ($data['element_type'] == 'url') { $data['value'] = strip_tags($data['value']); $email_body .= "{$data['label']}: {$data['value']} \n\n"; } elseif ($data['element_type'] == 'signature') { $element_id = $data['element_id']; $signature_hash = md5($data['value']); //encode the long query string for more readibility $q_string = base64_encode("form_id={$form_id}&id={$entry_id}&el=element_{$element_id}&hash={$signature_hash}"); if (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off') { $ssl_suffix = 's'; } else { $ssl_suffix = ''; } if (!empty($email_param['machform_base_path'])) { //if the form is called from advanced form code $data['value'] = $email_param['machform_base_path'] . 'signature.php?q=' . $q_string; } else { $data['value'] = 'http' . $ssl_suffix . '://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . '/signature.php?q=' . $q_string; } $email_body .= "{$data['label']}: {$data['value']} \n\n"; //construct template variables $template_variables[$i] = '{element_' . $data['element_id'] . '}'; $template_values[$i] = $data['value']; $i++; } else { $email_body .= "{$data['label']}: {$data['value']} \n\n"; } } } $i = count($template_variables); $template_variables[$i] = '{entry_data}'; $template_values[$i] = $email_body; //create the mail transport if (!empty($mf_settings['smtp_enable'])) { $s_transport = Swift_SmtpTransport::newInstance($mf_settings['smtp_host'], $mf_settings['smtp_port']); if (!empty($mf_settings['smtp_secure'])) { $s_transport->setEncryption('tls'); } if (!empty($mf_settings['smtp_auth'])) { $s_transport->setUsername($mf_settings['smtp_username']); $s_transport->setPassword($mf_settings['smtp_password']); } } else { $s_transport = Swift_MailTransport::newInstance(); //use PHP mail() transport } //create mailer instance $s_mailer = Swift_Mailer::newInstance($s_transport); if (file_exists($mf_settings['upload_dir'] . "/form_{$form_id}/files") && is_writable($mf_settings['upload_dir'] . "/form_{$form_id}/files")) { Swift_Preferences::getInstance()->setCacheType('disk')->setTempDir($mf_settings['upload_dir'] . "/form_{$form_id}/files"); } else { Swift_Preferences::getInstance()->setCacheType('array'); } //create the message //parse from_name template if (!empty($from_name)) { $from_name = str_replace($template_variables, $template_values, $from_name); $from_name = str_replace(' ', '', $from_name); //decode any html entity $from_name = html_entity_decode($from_name, ENT_QUOTES); if (empty($from_name)) { if (!empty($mf_settings['default_from_name'])) { $from_name = $mf_settings['default_from_name']; } else { $from_name = 'MachForm'; } } } else { if (!empty($mf_settings['default_from_name'])) { $from_name = $mf_settings['default_from_name']; } else { $from_name = 'MachForm'; } } //parse from_email_address template if (!empty($from_email)) { $from_email = str_replace($template_variables, $template_values, $from_email); if (empty($from_email)) { if (!empty($mf_settings['default_from_email'])) { $from_email = $mf_settings['default_from_email']; } else { $domain = str_replace('www.', '', $_SERVER['SERVER_NAME']); $from_email = "no-reply@{$domain}"; } } } else { if (!empty($mf_settings['default_from_email'])) { $from_email = $mf_settings['default_from_email']; } else { $domain = str_replace('www.', '', $_SERVER['SERVER_NAME']); $from_email = "no-reply@{$domain}"; } } //parse subject template if (!empty($subject)) { $subject = str_replace($template_variables, $template_values, $subject); $subject = str_replace(' ', '', $subject); } else { if ($target_is_admin) { $subject = utf8_encode("{$form_name} [#{$entry_id}]"); } else { $subject = utf8_encode("{$form_name} - Receipt"); } } //decode any html entity $subject = html_entity_decode($subject, ENT_QUOTES); //parse content template $email_content = str_replace($template_variables, $template_values, $content); if (!$as_plain_text) { //html type //add footer if (empty($mf_settings['disable_machform_link'])) { $email_content .= "<br /><br /><br /><br /><br /><b style=\"font-family:Lucida Grande,Tahoma,Arial,Verdana,sans-serif;font-size:12px\">Powered by <a href=\"http://www.appnitro.com\">MachForm</a></b>"; } //enclose with container div $email_content = '<div style="font-family:Lucida Grande,Tahoma,Arial,Verdana,sans-serif;font-size:12px">' . $email_content . '</div>'; } $to_emails = str_replace(' ', '', str_replace($template_variables, $template_values, $to_emails)); if (!empty($to_emails)) { $email_address = explode(',', $to_emails); } if (!empty($email_address)) { if (!$as_plain_text) { $email_content_type = 'text/html'; } else { $email_content_type = 'text/plain'; } //check for hook file (currently being used to set the destination email based on dropdown/radio button/checkboxes selection) if ($check_hook_file === true) { $hook_emails = $mf_hook_emails[$form_id]; if (!empty($hook_emails)) { $hook_element_id = $hook_emails['element_id']; //get the field type of this element_id $query = "select element_type from " . MF_TABLE_PREFIX . "form_elements where form_id=? and element_id=? and element_status=1"; $params = array($form_id, $hook_element_id); $sth = mf_do_query($query, $params, $dbh); $row = mf_do_fetch_result($sth); if ($row['element_type'] == 'checkbox') { //get all selected checkboxes $query = "select \r\n\t\t\t\t\t\t\t\t\t\toption_id,\r\n\t\t\t\t\t\t\t\t\t\t`option` option_title \r\n\t\t\t\t\t\t\t\t\tfrom \r\n\t\t\t\t\t\t\t\t\t\t" . MF_TABLE_PREFIX . "element_options \r\n\t\t\t\t\t\t\t\t where \r\n\t\t\t\t\t\t\t\t \t\tform_id=? and element_id=? and live=1 \r\n\t\t\t\t\t\t\t\torder by \r\n\t\t\t\t\t\t\t\t\t\toption_id asc"; $params = array($form_id, $hook_element_id); $sth = mf_do_query($query, $params, $dbh); $checkbox_element_names_array = array(); while ($row = mf_do_fetch_result($sth)) { $checkbox_hook_lookup[$row['option_id']] = $row['option_title']; $checkbox_element_names_array[] = 'element_' . $hook_element_id . '_' . $row['option_id']; } $checkbox_element_names_joined = implode(',', $checkbox_element_names_array); $query = "select {$checkbox_element_names_joined} from " . MF_TABLE_PREFIX . "form_{$form_id} where `id`=?"; $params = array($entry_id); $sth = mf_do_query($query, $params, $dbh); $row = mf_do_fetch_result($sth); $selected_checkbox_array = array(); foreach ($checkbox_hook_lookup as $option_id => $option_title) { if (!empty($row['element_' . $hook_element_id . '_' . $option_id])) { $selected_checkbox_array[] = $option_title; } } if (!empty($selected_checkbox_array)) { $email_address = array(); foreach ($selected_checkbox_array as $selected_option_title) { $selected_hook_email = $mf_hook_emails[$form_id][$selected_option_title]; if (!empty($selected_hook_email)) { $temp_email_address = explode(",", $selected_hook_email); } $email_address = array_merge($email_address, (array) $temp_email_address); } } } else { $query = "select \r\n\t\t\t\t\t\t\t\t\t\tB.`option` selected_value \r\n\t\t\t\t\t\t\t\t\tfrom \r\n\t\t\t\t\t\t\t\t\t\t" . MF_TABLE_PREFIX . "form_{$form_id} A left join " . MF_TABLE_PREFIX . "element_options B \r\n\t\t\t\t\t\t\t\t\t on \r\n\t\t\t\t\t\t\t\t\t B.form_id=? and A.element_{$hook_element_id}=B.option_id and B.live=1 and B.element_id=?\r\n\t\t\t\t\t\t\t\t\twhere \r\n\t\t\t\t\t\t\t\t\t\tA.`id`=?"; $params = array($form_id, $hook_element_id, $entry_id); $sth = mf_do_query($query, $params, $dbh); $row = mf_do_fetch_result($sth); $selected_value = $row['selected_value']; $selected_hook_email = $mf_hook_emails[$form_id][$selected_value]; if (!empty($selected_hook_email)) { $email_address = explode(",", $selected_hook_email); } } } } array_walk($email_address, 'mf_trim_value'); $s_message = Swift_Message::newInstance()->setCharset('utf-8')->setMaxLineLength(1000)->setSubject($subject)->setFrom(array($from_email => $from_name))->setSender($from_email)->setReturnPath($from_email)->setTo($email_address)->setBody($email_content, $email_content_type); //attach files, if any if (!empty($files_to_attach)) { foreach ($files_to_attach as $file_data) { $s_message->attach(Swift_Attachment::fromPath($file_data['filename_path'])->setFilename($file_data['filename_value'])); } } //send the message $send_result = $s_mailer->send($s_message); if (empty($send_result)) { echo "Error sending email!"; } } }