lastInsertId();
}else{
//if this is an existing form, delete the previous unsaved form fields
//IMPORTANT: for multi users version, the query condition need to be adjusted
$query = "DELETE FROM `".MF_TABLE_PREFIX."form_elements` where form_id = ? AND element_status='2'";
$params = array($form_id);
mf_do_query($query,$params,$dbh);
//the ap_element_options table has "live" column, which has 3 possible values:
// 0 - the option is being deleted
// 1 - the option is active
// 2 - the option is currently being drafted, not being saved yet and will be deleted by edit_form.php if the form is being edited the next time
$query = "DELETE FROM `".MF_TABLE_PREFIX."element_options` where form_id = ? AND live='2'";
$params = array($form_id);
mf_do_query($query,$params,$dbh);
}
//get the HTML markup of the form
$markup = mf_display_raw_form($dbh,$form_id);
//get the properties for each form field
//get form data
$query = "select
form_name,
form_active,
form_description,
form_redirect,
form_redirect_enable,
form_success_message,
form_password,
form_unique_ip,
form_captcha,
form_captcha_type,
form_review,
form_resume_enable,
form_limit_enable,
form_limit,
form_language,
form_frame_height,
form_label_alignment,
form_lastpage_title,
form_schedule_enable,
form_schedule_start_date,
form_schedule_end_date,
form_schedule_start_hour,
form_schedule_end_hour,
form_submit_primary_text,
form_submit_secondary_text,
form_submit_primary_img,
form_submit_secondary_img,
form_submit_use_image,
form_page_total,
form_pagination_type,
form_review_primary_text,
form_review_secondary_text,
form_review_primary_img,
form_review_secondary_img,
form_review_use_image,
form_review_title,
form_review_description
from
".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 = new stdClass();
if(!empty($row)){
$form->id = $form_id;
$form->name = $row['form_name'];
$form->active = (int) $row['form_active'];
$form->description = $row['form_description'];
$form->redirect = $row['form_redirect'];
$form->redirect_enable = (int) $row['form_redirect_enable'];
$form->success_message = $row['form_success_message'];
$form->password = $row['form_password'];
$form->frame_height = $row['form_frame_height'];
$form->unique_ip = (int) $row['form_unique_ip'];
$form->captcha = (int) $row['form_captcha'];
$form->captcha_type = $row['form_captcha_type'];
$form->review = (int) $row['form_review'];
$form->resume_enable = (int) $row['form_resume_enable'];
$form->limit_enable = (int) $row['form_limit_enable'];
$form->limit = (int) $row['form_limit'];
$form->label_alignment = $row['form_label_alignment'];
$form->schedule_enable = (int) $row['form_schedule_enable'];
if(empty($row['form_language'])){
$form->language = 'english';
}else{
$form->language = $row['form_language'];
}
$form->schedule_start_date = $row['form_schedule_start_date'];
if(!empty($row['form_schedule_start_hour'])){
$form->schedule_start_hour = date('h:i:a',strtotime($row['form_schedule_start_hour']));
}else{
$form->schedule_start_hour = '';
}
$form->schedule_end_date = $row['form_schedule_end_date'];
if(!empty($row['form_schedule_end_hour'])){
$form->schedule_end_hour = date('h:i:a',strtotime($row['form_schedule_end_hour']));
}else{
$form->schedule_end_hour = '';
}
$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->page_total = (int) $row['form_page_total'];
$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'];
}
//get element options first and store it into array
$query = "select
element_id,
option_id,
`position`,
`option`,
option_is_default
from
".MF_TABLE_PREFIX."element_options
where
form_id = ? and live=1
order by
element_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'];
}
//get the last option id for each options and store it into array
//we need it when the user adding a new option, so that we could assign the last option id + 1
$query = "select
element_id,
max(option_id) as last_option_id
from
".MF_TABLE_PREFIX."element_options
where
form_id = ?
group by
element_id";
$params = array($form_id);
$sth = mf_do_query($query,$params,$dbh);
while($row = mf_do_fetch_result($sth)){
$element_id = $row['element_id'];
$last_option_id_lookup[$element_id] = $row['last_option_id'];
}
//get elements data
$element = array();
$query = "select
element_id,
element_title,
element_guidelines,
element_size,
element_is_required,
element_is_unique,
element_is_private,
element_type,
element_position,
element_default_value,
element_constraint,
element_css_class,
element_range_min,
element_range_max,
element_range_limit_by,
element_choice_columns,
element_choice_has_other,
element_choice_other_label,
element_time_showsecond,
element_time_24hour,
element_address_hideline2,
element_address_us_only,
element_date_enable_range,
element_date_range_min,
element_date_range_max,
element_date_enable_selection_limit,
element_date_selection_max,
element_date_disable_past_future,
element_date_past_future,
element_date_disable_weekend,
element_date_disable_specific,
element_date_disabled_list,
element_file_enable_type_limit,
element_file_block_or_allow,
element_file_type_list,
element_file_as_attachment,
element_file_enable_advance,
element_file_auto_upload,
element_file_enable_multi_upload,
element_file_max_selection,
element_file_enable_size_limit,
element_file_size_max,
element_submit_use_image,
element_submit_primary_text,
element_submit_secondary_text,
element_submit_primary_img,
element_submit_secondary_img,
element_page_title,
element_matrix_allow_multiselect,
element_matrix_parent_id
from
".MF_TABLE_PREFIX."form_elements
where
form_id = ? and element_status='1'
order by
element_position asc";
$params = array($form_id);
$sth = mf_do_query($query,$params,$dbh);
$j=0;
while($row = mf_do_fetch_result($sth)){
$element_id = $row['element_id'];
//lookup element options first
$option_id_array = array();
$element_options = array();
if(!empty($options_lookup[$element_id])){
$i=1;
foreach ($options_lookup[$element_id] as $option_id=>$data){
$element_options[$option_id] = new stdClass();
$element_options[$option_id]->position = $i;
$element_options[$option_id]->option = $data['option'];
$element_options[$option_id]->is_default = $data['option_is_default'];
$element_options[$option_id]->is_db_live = 1;
$option_id_array[$element_id][$i] = $option_id;
$i++;
}
}
//populate elements
$element[$j] = new stdClass();
$element[$j]->title = $row['element_title'];
$element[$j]->guidelines = $row['element_guidelines'];
$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]->default_value = $row['element_default_value'];
$element[$j]->constraint = $row['element_constraint'];
$element[$j]->css_class = $row['element_css_class'];
$element[$j]->range_min = (int) $row['element_range_min'];
$element[$j]->range_max = (int) $row['element_range_max'];
$element[$j]->range_limit_by = $row['element_range_limit_by'];
$element[$j]->choice_columns = (int) $row['element_choice_columns'];
$element[$j]->choice_has_other = (int) $row['element_choice_has_other'];
$element[$j]->choice_other_label = $row['element_choice_other_label'];
$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'];
$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]->submit_use_image = (int) $row['element_submit_use_image'];
$element[$j]->submit_primary_text = $row['element_submit_primary_text'];
$element[$j]->submit_secondary_text = $row['element_submit_secondary_text'];
$element[$j]->submit_primary_img = $row['element_submit_primary_img'];
$element[$j]->submit_secondary_img = $row['element_submit_secondary_img'];
$element[$j]->page_title = $row['element_page_title'];
$element[$j]->matrix_allow_multiselect = (int) $row['element_matrix_allow_multiselect'];
$element[$j]->matrix_parent_id = (int) $row['element_matrix_parent_id'];
if(!empty($element_options)){
$element[$j]->options = $element_options;
$element[$j]->last_option_id = $last_option_id_lookup[$element_id];
}else{
$element[$j]->options = '';
}
//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'];
$row_position = count($matrix_elements[$parent_id]) + 2;
$element_id = $row['element_id'];
$matrix_elements[$parent_id][$element_id] = new stdClass();
$matrix_elements[$parent_id][$element_id]->is_db_live = 1;
$matrix_elements[$parent_id][$element_id]->position = $row_position;
$matrix_elements[$parent_id][$element_id]->row_title = $row['element_title'];
$column_data = array();
$col_position = 1;
foreach ($element_options as $option_id=>$value){
$column_data[$option_id] = new stdClass();
$column_data[$option_id]->is_db_live = 1;
$column_data[$option_id]->position = $col_position;
$column_data[$option_id]->column_title = $value->option;
$col_position++;
}
$matrix_elements[$parent_id][$element_id]->column_data = $column_data;
//remove it from the main element array
$element[$j] = array();
unset($element[$j]);
$j--;
}
$j++;
}
//if this is multipage form, add the lastpage submit property into the element list
if($form->page_total > 1){
$element[$j]->id = 'lastpage';
$element[$j]->type = 'page_break';
$element[$j]->page_title = $form_lastpage_title;
$element[$j]->submit_primary_text = $form_submit_primary_text;
$element[$j]->submit_secondary_text = $form_submit_secondary_text;
$element[$j]->submit_primary_img = $form_submit_primary_img;
$element[$j]->submit_secondary_img = $form_submit_secondary_img;
$element[$j]->submit_use_image = $form_submit_use_image;
}
$jquery_data_code = '';
//build the json code for form fields
$all_element = array('elements' => $element);
foreach ($element as $data){
//if this is matrix element, attach the children data into options property and merge with current (matrix parent) options
if($data->type == 'matrix'){
$matrix_elements[$data->id][$data->id] = new stdClass();
$matrix_elements[$data->id][$data->id]->is_db_live = 1;
$matrix_elements[$data->id][$data->id]->position = 1;
$matrix_elements[$data->id][$data->id]->row_title = $data->title;
$column_data = array();
$col_position = 1;
foreach ($data->options as $option_id=>$value){
$column_data[$option_id] = new stdClass();
$column_data[$option_id]->is_db_live = 1;
$column_data[$option_id]->position = $col_position;
$column_data[$option_id]->column_title = $value->option;
$col_position++;
}
$matrix_elements[$data->id][$data->id]->column_data = $column_data;
$temp_array = array();
$temp_array = $matrix_elements[$data->id];
asort($temp_array);
$matrix_elements[$data->id] = array();
$matrix_elements[$data->id] = $temp_array;
$data->options = array();
$data->options = $matrix_elements[$data->id];
}
$field_settings = json_encode($data);
$jquery_data_code .= "\$('#li_{$data->id}').data('field_properties',{$field_settings});\n";
}
//build the json code for form settings
$json_form = json_encode($form);
$jquery_data_code .= "\$('#form_header').data('form_properties',{$json_form});\n";
$header_data =<<
EOT;
$current_nav_tab = 'manage_forms';
require('includes/header.php');
?>
EOT;
require('includes/footer.php');
?> 
