\n"; $returnText .= "\n\n\n\n
\n"; if ($mode == "edit") { $returnText .= " " . getLanguageText('TEXT-ADD-FIELD') . " \n"; } // Show form header if (strlen($form['form_title'])) { $form_title = nl2br($form['form_title']); $returnText .= "
$form_title
\n"; } // Show form description if (strlen($form['form_description'])) { $form_description = nl2br($form['form_description']); $returnText .= "
$form_description
\n"; } // Get form fields $query = "SELECT * FROM custom_form_field WHERE school_num = $school_num AND form_num = $form_num ORDER BY sequence"; $fields = db_query($query); if (db_num_rows($fields)) { if ($mode == "edit") $returnText .= "
    \n"; $count = 0; while ($field = db_fetch_assoc($fields)) { extract($field); $field_num = $record_num; // Format field tooltip $title = ""; if ($field_type != 'Form-Description' && strlen($field_tooltip) || $field_required == 'Y') { $field_title = "$field_prompt:
    "; $field_tooltip = str_replace('"',""",$field_tooltip); if ($field_required == 'Y') { if (strlen($field_tooltip)) $field_tooltip .= "
    \n - "; $field_tooltip .= "" . getLanguageText('TEXT-REQUIRED') . ""; } $title = "title=\"$field_title$field_tooltip\""; } // Clear the required_flag $required_flag = ""; if ($mode == "edit") $returnText .= "
  • \n"; $field_name = preg_replace("/[^a-z_-]/",'',strtolower(str_replace(' ','_',$field_prompt))); $field_prompt = "$field_prompt"; switch ($field_type) { case 'Text': default: $classes = "form-field text-field"; if ($field_required == 'Y') { $classes .= " text-required"; $required_flag = "*"; } $returnText .= "
    "; if ($mode == 'edit') { $returnText .= ""; $returnText .= ""; } $returnText .= "
    \n"; $returnText .= "$required_flag\n"; $returnText .= "
    \n"; break; case 'Date': $classes = "form-field date-field"; if ($field_required == 'Y') { $classes .= " text-required"; $required_flag = "*"; } $returnText .= "
    "; if ($mode == 'edit') $returnText .= ""; $returnText .= "
    \n"; $returnText .= "$required_flag\n"; $returnText .= "
    \n"; break; case 'Date-Picker': $classes = "form-field date-monthyear-field"; if ($field_required == 'Y') { $classes .= " text-required"; $required_flag = "*"; } $returnText .= "
    "; if ($mode == 'edit') $returnText .= ""; $returnText .= "
    \n"; $returnText .= "$required_flag\n"; $returnText .= "
    \n"; break; case 'Datetime': $classes = "form-field datetime-field"; if ($field_required == 'Y') { $classes .= " text-required"; $required_flag = "*"; } $returnText .= "
    "; if ($mode == 'edit') $returnText .= ""; $returnText .= "
    \n"; $returnText .= "$required_flag\n"; $returnText .= "
    \n"; break; case 'Textarea': $classes = "form-field textarea-field"; $returnText .= "
    "; if ($mode == 'edit') $returnText .= ""; $returnText .= "
    \n"; $returnText .= "\n"; $returnText .= "
    \n"; break; case 'Radio': case 'RadioYN': $classes = "form-field radio-field"; // Setup options for radio buttons if ($field_type == 'RadioYN') $options = array('Yes','No'); else { $options = array(); $query = "SELECT option_text FROM custom_form_field_option " . "WHERE school_num = $school_num AND form_num = $form_num AND field_num = $field_num ORDER BY sequence"; $results = db_query($query); while ($row = db_fetch_assoc($results)) { $options[] = $row['option_text']; } } $returnText .= "
    "; if ($mode == 'edit') $returnText .= ""; $returnText .= "
    \n"; for ($i = 0; $i < count($options); $i++) { $field_option = $options[$i]; // Format the prompt attribute $attr = str_replace('"',""",$field_prompt); $field_id = $field_name . "_" . str_replace(' ','_',$field_option); $checked = ""; if ($field_default == $field_option) $checked = "checked='checked'"; $returnText .= "  "; $returnText .= "  "; } $returnText .= "
    \n"; break; case 'Checkbox': $classes = "form-field checkbox-field"; $returnText .= "
    "; if ($mode == 'edit') $returnText .= ""; $returnText .= ""; $returnText .= " "; $returnText .= "
    \n"; break; case 'Select': $classes = "form-field select-field"; // Get options for select box $options = array(); $query = "SELECT option_text FROM custom_form_field_option " . "WHERE school_num = $school_num AND form_num = $form_num AND field_num = $field_num ORDER BY sequence"; $results = db_query($query); while ($row = db_fetch_assoc($results)) { $options[] = $row['option_text']; } $returnText .= "
    "; if ($mode == 'edit') $returnText .= ""; $returnText .= "
    \n"; $returnText .= "\n"; $returnText .= "
    \n"; break; case 'Select-Range': $classes = "form-field select-field"; // Get options for select box $options = array(); if ($number1 < $number2) { for ($i = $number1; $i <= $number2; $i++) $options[] = $i; } else { for ($i = $number1; $i >= $number2; $i--) $options[] = $i; } $returnText .= "
    "; if ($mode == 'edit') $returnText .= ""; $returnText .= "
    \n"; $returnText .= "\n"; $returnText .= "
    \n"; break; case 'Form-Spacer': $returnText .= "
    "; if ($mode == "edit") { $returnText .= ""; $returnText .= getLanguageText('TEXT-FORM-SPACER'); } $returnText .= "
    \n"; break; case 'Form-Title': $returnText .= "
    "; if ($mode == 'edit') $returnText .= ""; $returnText .= "

    $field_prompt

    \n"; $returnText .= "
    \n"; break; case 'Form-Description': $returnText .= "
    "; if ($mode == 'edit') $returnText .= ""; $returnText .= "

    $field_tooltip

    \n"; $returnText .= "
    \n"; break; case 'Form-Start-Fieldset': if ($mode == "edit") { $returnText .= "
    "; $returnText .= ""; $returnText .= ""; $returnText .= getLanguageText('TEXT-START-FORM-FIELDSET') . ": $field_prompt"; $returnText .= "
    \n"; } if ($mode == "process") { $returnText .= "
    "; $returnText .= "$field_prompt:\n"; } break; case 'Form-End-Fieldset': if ($mode == "edit") { $parent_title = db_getVal("SELECT field_prompt FROM custom_form_field WHERE school_num = $school_num AND record_num = $child_of_num"); $returnText .= "
    "; $returnText .= getLanguageText('TEXT-END-FORM-FIELDSET') . ": $parent_title"; $returnText .= "
    \n"; } if ($mode == "process") { $returnText .= "
    "; } break; } if ($mode == "edit") $returnText .= "
    • \n"; $count++; } $returnText .= "
\n"; } // Display form submit button $returnText .= "
\n"; $returnText .= "
\n"; $returnText .= "\n"; $returnText .= "
\n"; // Show form footer $form_footer = ""; if (strlen($form['form_footer'])) { $form_footer = nl2br($form['form_footer']); $returnText .= "
$form_footer
\n"; } if ($mode == "edit") { $returnText .= " " . getLanguageText('TEXT-ADD-FIELD') . " \n"; } $returnText .= "
\n"; $returnText .= "\n"; include "$webdir/include/jquery.dynamic-forms.php"; return($returnText); } ?>