\n"; // Load array of properties for this layout and its groups. $grparr = array(); getLayoutProperties('GCA', $grparr); $fres = sqlStatement("SELECT * FROM layout_options " . "WHERE form_id = 'GCA' AND uor > 0 " . "ORDER BY group_id, seq"); $last_group = ''; $cell_count = 0; $item_count = 0; $display_style = 'block'; while ($frow = sqlFetchArray($fres)) { $this_group = $frow['group_id']; $titlecols = $frow['titlecols']; $datacols = $frow['datacols']; $data_type = $frow['data_type']; $field_id = $frow['field_id']; $list_id = $frow['list_id']; $currvalue = ''; if ($frow['edit_options'] == 'H') { // This data comes from static history if (isset($shrow[$field_id])) { $currvalue = $shrow[$field_id]; } } else { if (isset($pprow[$field_id])) { $currvalue = $pprow[$field_id]; } } // Handle a data category (group) change. if (strcmp($this_group, $last_group) != 0) { end_group(); $group_seq = 'gca' . substr($this_group, 0, 1); $group_name = $grparr[$this_group]['grp_title']; $last_group = $this_group; echo "
" . text(xl_layout_label($group_name)) . "\n"; echo "

\n"; echo " \n"; $display_style = 'none'; } // Handle starting of a new row. if (($titlecols > 0 && $cell_count >= $CPR) || $cell_count == 0) { end_row(); echo " "; } if ($item_count == 0 && $titlecols == 0) { $titlecols = 1; } // Handle starting of a new label cell. if ($titlecols > 0) { end_cell(); echo "

"; $cell_count += $titlecols; } ++$item_count; echo ""; if ($frow['title']) { echo (text(xl_layout_label($frow['title'])) . ":"); } else { echo " "; } echo ""; // Handle starting of a new data cell. if ($datacols > 0) { end_cell(); echo "

0) { echo " style='padding-left:5pt'"; } echo ">"; $cell_count += $datacols; } ++$item_count; if ($frow['edit_options'] == 'H') { echo generate_display_field($frow, $currvalue); } else { generate_form_field($frow, $currvalue); } } end_group(); echo "\n"; } function issue_ippf_con_newtype() { echo " var condisp = (aitypes[index] == 4) ? '' : 'none';\n"; echo " document.getElementById('ippf_con').style.display = condisp;\n"; } function issue_ippf_con_save($issue) { $sets = "id = '" . add_escape_custom($issue) . "'"; $fres = sqlStatement("SELECT * FROM layout_options " . "WHERE form_id = 'CON' AND uor > 0 AND field_id != '' AND edit_options != 'H' " . "ORDER BY group_id, seq"); while ($frow = sqlFetchArray($fres)) { $field_id = $frow['field_id']; $value = get_layout_form_value($frow); $sets .= ", " . add_escape_custom($field_id) . " = '" . add_escape_custom($value) . "'"; } // This replaces the row if its id exists, otherwise inserts it. sqlStatement("REPLACE INTO lists_ippf_con SET $sets"); } function issue_ippf_con_form($issue, $thispid) { global $pprow, $item_count, $cell_count, $last_group; $shrow = getHistoryData($thispid); if ($issue) { $pprow = sqlQuery("SELECT * FROM lists_ippf_con WHERE id = ?", array($issue)); } else { $pprow = array(); } echo "

\n"; // Load array of properties for this layout and its groups. $grparr = array(); getLayoutProperties('CON', $grparr); $fres = sqlStatement("SELECT * FROM layout_options " . "WHERE form_id = 'CON' AND uor > 0 " . "ORDER BY group_id, seq"); $last_group = ''; $cell_count = 0; $item_count = 0; $display_style = 'block'; while ($frow = sqlFetchArray($fres)) { $this_group = $frow['group_id']; $titlecols = $frow['titlecols']; $datacols = $frow['datacols']; $data_type = $frow['data_type']; $field_id = $frow['field_id']; $list_id = $frow['list_id']; $currvalue = ''; if ($frow['edit_options'] == 'H') { // This data comes from static history if (isset($shrow[$field_id])) { $currvalue = $shrow[$field_id]; } } else { if (isset($pprow[$field_id])) { $currvalue = $pprow[$field_id]; } } // Handle a data category (group) change. if (strcmp($this_group, $last_group) != 0) { end_group(); $group_seq = 'con' . substr($this_group, 0, 1); $group_name = $grparr[$this_group]['grp_title']; $last_group = $this_group; echo "
" . text($group_name) . "\n"; echo "

"; $cell_count += $titlecols; } ++$item_count; echo ""; if ($frow['title']) { echo text($frow['title']) . ":"; } else { echo " "; } echo ""; // Handle starting of a new data cell. if ($datacols > 0) { end_cell(); echo "