Print

Style Sheets






.Edit Form Basics (as of Version 11.12.29)


The Edit Form is comprised of 4 Elements each in their own DIV .



Menu
Actions
Form
Status

These Elements can be moved or resized to suit your Application

Each element is controlled by its own nuBuilder Style (HTML CSS Class).

.nuMenu
.nuActions
.nuForm
.nuStatus



(The configuration above allows for better use of wider monitors and more menu options)

Running the SQL below will setup Edit Forms with a Horizontal Menu

DELETE FROM zzsys_style_property
WHERE ssp_zzsys_style_id IN (
SELECT zzsys_style_id FROM zzsys_style
WHERE sst_class IN ('.nuMenu','.nuMenu ul li','.nuStatus','.nuAction','.nuForm'));
 
DELETE FROM zzsys_style
WHERE sst_class IN ('.nuMenu','.nuMenu ul li','.nuStatus','.nuAction','.nuForm');
 
INSERT INTO `zzsys_style` (`zzsys_style_id`, `sst_class`, `sst_description`, `sst_custom`) VALUES
('14ee8324a3527c', '.nuMenu', 'DIV surrounding Form Tabs', '1'),
('14ee0509986438', '.nuMenu ul li', '', '1'),
('14ef2b10c7d2dc', '.nuStatus', 'Status bar of Form', '1'),
('14ef3ae93cb41f', '.nuAction', 'DIV surrounding Action Buttons', '1'),
('14ef3bc342619f', '.nuForm', 'DIV surrounding Editable Objects', '1');
 
INSERT INTO `zzsys_style_property` (`zzsys_style_property_id`, `ssp_property_name`, `ssp_property_value`, `ssp_zzsys_style_id`) VALUES
('14ee050998b66f', 'font-size', '12px', '14ee0509986438'),
('14ee82a0331eec', 'padding', '0px 15px 0px 15px', '14ee0509986438'),
('14ee82a0333965', 'float', 'left', '14ee0509986438'),
('14ee82a0335754', 'height', '20px', '14ee0509986438'),
('14ee8324a39a61', 'top', '70px', '14ee8324a3527c'),
('14ee8331f6cde0', 'left', '12px', '14ee8324a3527c'),
('14ee0509989b17', 'font-family', 'tahoma', '14ee0509986438'),
('14ef2b10c8228e', 'position', 'absolute', '14ef2b10c7d2dc'),
('14ef2b10c842c3', 'top', '600px', '14ef2b10c7d2dc'),
('14ef2b10c863d1', 'left', '12px', '14ef2b10c7d2dc'),
('14ef2b10c883cc', 'width', '968px', '14ef2b10c7d2dc'),
('14ef2b10c8a364', 'height', '20px', '14ef2b10c7d2dc'),
('14ef2b3cfc1a62', 'font-size', '10px', '14ef2b10c7d2dc'),
('14ef3e686663d9', 'color', 'white', '14ee0509986438'),
('14ef2b5092b7be', 'color', 'black', '14ef2b10c7d2dc'),
('14ef3ae93cfc19', 'top', '20px', '14ef3ae93cb41f'),
('14ef3ae93d1eba', 'left', '165px', '14ef3ae93cb41f'),
('14ef3ae93d408a', 'width', '660px', '14ef3ae93cb41f'),
('14ef3ae93d6334', 'height', '40px', '14ef3ae93cb41f'),
('14ef3aea5b3565', 'text-align', 'center', '14ef3ae93cb41f'),
('14ef3b17a61a8f', 'width', '968px', '14ee8324a3527c'),
('14ef3b2cc94867', 'height', '20px', '14ee8324a3527c'),
('14ef3b54560539', 'overflow', 'hidden', '14ee8324a3527c'),
('14ef3bc342a98b', 'top', '90px', '14ef3bc342619f'),
('14ef3bc342cb86', 'left', '12px', '14ef3bc342619f'),
('14ef3bc342ed60', 'width', '968px', '14ef3bc342619f'),
('14ef3bc3430ed9', 'height', '512px', '14ef3bc342619f'),
('14ef3bc3433098', 'border-style', 'none solid none solid', '14ef3bc342619f'),
('14ef3bc56ea24e', 'border-width', '2px', '14ef3bc342619f'),
('14ef3bddad919a', 'border-style', 'solid solid none solid', '14ee8324a3527c'),
('14ef3bdfe150ee', 'border-width', '2px', '14ee8324a3527c'),
('14ef3be5eaccc6', 'border-style', 'none solid solid solid', '14ef2b10c7d2dc'),
('14ef3be5eaeec2', 'border-width', '2px', '14ef2b10c7d2dc'),
('14ef3e55ab9b3e', 'padding', '4px 0px 0px 0px', '14ef2b10c7d2dc'),
('14ef3d5ceae101', 'border-color', 'black', '14ee8324a3527c');




Running the SQL below will setup Edit Forms with a Vertical Menu

DELETE FROM zzsys_style_property
WHERE ssp_zzsys_style_id IN (
SELECT zzsys_style_id FROM zzsys_style
WHERE sst_class IN ('.nuMenu','.nuMenu ul li','.nuStatus','.nuAction','.nuForm'));
 
DELETE FROM zzsys_style
WHERE sst_class IN ('.nuMenu','.nuMenu ul li','.nuStatus','.nuAction','.nuForm');
 
 
INSERT INTO `zzsys_style` (`zzsys_style_id`, `sst_class`, `sst_description`, `sst_custom`) VALUES
('14ef2b10c7d2dc', '.nuStatus', 'Status bar of Form', '1'),
('14ee0509986438', '.nuMenu ul li', '', '1'),
('14ee8324a3527c', '.nuMenu', 'DIV surrounding Form Tabs', '1'),
('14ef3bc342619f', '.nuForm', 'DIV surrounding Editable Objects', '1'),
('14ef3ae93cb41f', '.nuAction', 'DIV surrounding Action Buttons', '1');
 
 
 
INSERT INTO `zzsys_style_property` (`zzsys_style_property_id`, `ssp_property_name`, `ssp_property_value`, `ssp_zzsys_style_id`) VALUES
('14ef3be5eaccc6', 'border-style', 'solid solid solid none', '14ef2b10c7d2dc'),
('14ef3bdfe150ee', 'border-width', '2px', '14ee8324a3527c'),
('14ef3bddad919a', 'border-style', 'solid none solid solid ', '14ee8324a3527c'),
('14ef3bc56ea24e', 'border-width', '2px', '14ef3bc342619f'),
('14ef3bc3433098', 'border-style', 'solid solid none none', '14ef3bc342619f'),
('14ef3bc3430ed9', 'height', '512px', '14ef3bc342619f'),
('14ef3bc342ed60', 'width', '970px', '14ef3bc342619f'),
('14ef3bc342cb86', 'left', '112px', '14ef3bc342619f'),
('14ef3bc342a98b', 'top', '90px', '14ef3bc342619f'),
('14ef3b54560539', 'overflow', 'hidden', '14ee8324a3527c'),
('14ef3b2cc94867', 'height', '534px', '14ee8324a3527c'),
('14ef3b17a61a8f', 'width', '100px', '14ee8324a3527c'),
('14ef3aea5b3565', 'text-align', 'center', '14ef3ae93cb41f'),
('14ef3ae93d6334', 'height', '40px', '14ef3ae93cb41f'),
('14ef3ae93d408a', 'width', '660px', '14ef3ae93cb41f'),
('14ef3ae93d1eba', 'left', '265px', '14ef3ae93cb41f'),
('14ee0509989b17', 'font-family', 'tahoma', '14ee0509986438'),
('14ef2b10c8228e', 'position', 'absolute', '14ef2b10c7d2dc'),
('14ef3ae93cfc19', 'top', '20px', '14ef3ae93cb41f'),
('14ef2b5092b7be', 'color', 'black', '14ef2b10c7d2dc'),
('14ef3e686663d9', 'color', 'white', '14ee0509986438'),
('14ef2b3cfc1a62', 'font-size', '10px', '14ef2b10c7d2dc'),
('14ef2b10c8a364', 'height', '20px', '14ef2b10c7d2dc'),
('14ef2b10c883cc', 'width', '970px', '14ef2b10c7d2dc'),
('14ef2b10c863d1', 'left', '112px', '14ef2b10c7d2dc'),
('14ef2b10c842c3', 'top', '600px', '14ef2b10c7d2dc'),
('14ee8324a39a61', 'top', '90px', '14ee8324a3527c'),
('14ee8331f6cde0', 'left', '10px', '14ee8324a3527c'),
('14ee82a0335754', 'height', '20px', '14ee0509986438'),
('14ee050998b66f', 'font-size', '10px', '14ee0509986438'),
('14ee82a0331eec', 'padding', '3px 0px 3px 0px', '14ee0509986438'),
('14ee82a0333965', 'float', 'left', '14ee0509986438'),
('14ef3be5eaeec2', 'border-width', '2px', '14ef2b10c7d2dc'),
('14ef3e55ab9b3e', 'padding', '4px 0px 0px 0px', '14ef2b10c7d2dc'),
('14ef3d5ceae101', 'border-color', 'black', '14ee8324a3527c'),
('14efbd77f7b15c', 'width', '100px', '14ee0509986438');



.Browse Form Basics (as of Version 12.01.09)


The Browse Form is comprised of 2 Elements each in their own DIV.
Search
Browse

The Browse Form is controlled by nuBuilder Styles (HTML CSS Class).

.nuSearch
.nuBrowse
.nuSelectedRow
.nuUnselectedRow




If you have a previous version you will need to run the following sql..


DELETE FROM `zzsys_activity` WHERE `zzsys_activity_id` = '14c8dc47abd6e9';
 
INSERT INTO `zzsys_activity` (`zzsys_activity_id`, `sat_all_type`, `sat_all_code`, `sat_all_description`, `sat_all_group`, `sat_all_zzsys_form_id`, `sat_report_data_file`,
 `sat_report_data_code`, `sat_report_display_file`, `sat_report_display_code`, `sat_report_page_length`, `sat_report_display_type`, `sat_export_data_file`, 
`sat_export_data_code`, `sat_export_delimiter`, `sat_export_header`, `sat_export_use_quotes`, `sat_procedure_file`, `sat_procedure_code`, `sys_added`, `sys_changed`, `sys_user_id`) VALUES
('14c8dc47abd6e9', 'procedure', 'WIZARDFORM', 'Wizard for creating a form', 'setup', '14c8dc4aec9b4f', NULL, '', NULL, '', 0, '0', NULL, '', '', '', '', NULL,
 '$TN               = ''#TableName#'';
 $PK               = ''#PrimaryKey#'';
$formID           = uniqid(''1'');\r\n
//======================================
//         add form 
//======================================\r\n
$insertForm       = "INSERT INTO zzsys_form (zzsys_form_id, sfo_name, sfo_title, ";
$insertForm      .= "sfo_access_without_login, sfo_close_after_save, ";
$insertForm      .= "sfo_refresh_after_save, sfo_sql, sfo_table, ";
$insertForm      .= "sfo_primary_key, sfo_add_button, sfo_save_button, ";
$insertForm      .= "sfo_delete_button, sfo_clone_button, sfo_close_button) ";
$insertForm      .= "VALUES (''$formID'', ''(Wizard) $TN'', ''$TN'', ''0'', ''0'', ''1'', ";
$insertForm      .= "''SELECT * FROM $TN'', ''$TN'', ''$PK'', ''1'', ''1'', ''1'', ''1'', ''0'');";\r\n
//print 
$insertForm . ''<br/>'';\r\nnuRunQuery($insertForm);\r\n
//======================================
//         add browse columns 
//======================================
$insertColumns       = "";
$order               = 10;
$t = nuRunQuery(''SELECT #BrowseColumns# FROM #BrowseColumns#'');
while($r=db_fetch_row($t)){
   $fname            = $r[0];
   $ID               = uniqid(''1'');
	$order            = $order + 10;\r\n  
	$insertColumns   .= "INSERT INTO zzsys_browse ";
	$insertColumns   .= "(zzsys_browse_id, sbr_zzsys_form_id, sbr_title, ";
	$insertColumns   .= "sbr_display, sbr_align, ";
	$insertColumns   .= "sbr_searchable, sbr_sort, sbr_sortable, ";
	$insertColumns   .= "sbr_visible, sbr_order, sbr_width) VALUES (";
	$insertColumns   .= "''$ID'', ''$formID'', ''$fname'', ''$fname'', ";
	$insertColumns   .= "''l'', ''1'', ''$fname'', ''1'', ''1'', $order, 100);";\r\n 
	nuRunQuery($insertColumns);\r\n   $insertColumns   = '''';
}\r\n
//print 
$insertColumns;\r\n
//======================================
//         add objects 
//======================================
$insertObject        = "";
$column              = 10;
$order               = 10;\r\n
$t = nuRunQuery(''SELECT #SelectedFieldNames# FROM #SelectedFieldNames#'');
while($r=db_fetch_row($t)){
	$fname            = $r[0];  
	$ID               = uniqid(''1'');
	if($order         > 100){
		$column      = $column + 10;
		$order       = 10;
	}else{
		$order       = $order + 10;
	}
	$insertObject    .= "INSERT INTO zzsys_object ";
	$insertObject    .= "(zzsys_object_id, sob_zzsys_form_id, sob_all_title, ";
	$insertObject    .= "sob_all_name, sob_all_column_number, sob_all_order_number, ";
	$insertObject    .= "sob_all_tab_title, sob_all_tab_number, sob_all_type, ";
	$insertObject    .= "sob_all_clone, sob_text_align, sob_text_length) ";
	$insertObject    .= "VALUES (''$ID'', ''$formID'', ''$fname'', ''$fname'', ''$column'', ";
	$insertObject    .= " ''$order'', ''Main'', ''10'', ''text'', ''1'', ''l'', ''10'');";
	nuRunQuery($insertObject);
	$insertObject   = '''';
}\r\n
$ID                  = uniqid(''1'');\r\n
$insertObject       .= "INSERT INTO zzsys_object (sob_button_zzsys_form_id, ";
$insertObject       .= "zzsys_object_id, sob_zzsys_form_id, sob_all_title, ";
$insertObject       .= "sob_all_name, sob_all_column_number, sob_all_order_number, ";
$insertObject       .= "sob_all_tab_title, sob_all_tab_number, sob_all_type, sob_button_left, ";
$insertObject       .= "sob_button_top, sob_all_clone, sob_text_align, sob_button_length, sob_all_admin_only) ";
$insertObject       .= "VALUES ( ''$formID'', ''$ID'', ''index'', ''$TN (wizard)'', ''$TN'', ''10'', ";
$insertObject       .= " ''10'', ''Wizard'', ''1000'', ''button'', ''0'', ''0'', ''10'', ''0'', ''10'' ,''0'');";\r\n
//print 
$insertObject;
nuRunQuery($insertObject);\r\n
$string             = "<br/><br/>A Form and its Objects have now been created, ";
$string            .= "along with a Button to open this Form.<br/>";
$string            .= "This Button, called <font color=''red''>$TN</font>, is found ";
$string            .= "on the Index Form under a Tab called Wizard<br/>";
$string            .= "(The Index Form will need to be refreshed for this Button to appear)";
print "<table align=''center''><tr align=''center''><td align=''center''>
$string</td></tr></table>";', '2010-09-13 15:58:10', '2012-01-05 13:42:59', 'globeadmin');
 
DELETE FROM `zzsys_object` WHERE `zzsys_object_id` = '14f0247a001c92';
 
INSERT INTO `zzsys_object` (`zzsys_object_id`, `sob_zzsys_form_id`, `sob_all_access_key`, `sob_all_admin_only`, `sob_all_class`, `sob_all_clone`, `sob_all_column_number`,
`sob_all_display_condition`, `sob_all_name`, `sob_all_sql_run_before_display`, `sob_all_start_cursor`, `sob_all_on_blur`, `sob_all_on_change`, `sob_all_on_double_click`,
`sob_all_on_focus`, `sob_all_on_key_press`, `sob_all_tool_tip`, `sob_all_order_number`, `sob_all_tab_number`, `sob_all_tab_title`, `sob_all_title`, `sob_all_type`,
`sob_all_comment`, `sob_button_admin_only`, `sob_button_display_condition`, `sob_button_left`, `sob_button_length`, `sob_button_top`, `sob_button_skip_browse_record_id`,
`sob_button_zzsys_form_id`, `sob_button_image_on_mouse_up`, `sob_button_image_on_mouse_down`, `sob_display_align`, `sob_button_browse_filter`, `sob_display_format`,
`sob_display_length`, `sob_display_sql`, `sob_dropdown_default_value_sql`, `sob_dropdown_length`, `sob_dropdown_no_blanks`, `sob_dropdown_no_duplicates`,
`sob_dropdown_read_only`, `sob_dropdown_sql`, `sob_graph_sql`, `sob_graph_zzsys_graph_id`, `sob_graph_query_string`, `sob_graph_code`, `sob_hidden_default_value`,
`sob_html_code`, `sob_inarray_default_value_sql`, `sob_inarray_length`, `sob_inarray_no_blanks`, `sob_inarray_no_duplicates`, `sob_inarray_read_only`, `sob_inarray_sql`,
`sob_listbox_height`, `sob_listbox_length`, `sob_listbox_button_style`, `sob_listbox_sql`, `sob_lookup_button_length`, `sob_lookup_code_class`, `sob_lookup_code_field`,
`sob_lookup_code_length`, `sob_lookup_default_value_sql`, `sob_lookup_description_class`, `sob_lookup_description_field`, `sob_lookup_description_length`, `sob_lookup_sql`,
`sob_lookup_load_zzsysform_id`, `sob_lookup_zzsysform_id`, `sob_lookup_id_field`, `sob_lookup_javascript`, `sob_lookup_no_blanks`, `sob_lookup_no_description`,
`sob_lookup_no_duplicates`, `sob_lookup_read_only`, `sob_lookup_autocomplete`, `sob_password_length`, `sob_password_no_blanks`, `sob_subform_blank_rows`,
`sob_subform_delete_box`, `sob_subform_foreign_key`, `sob_subform_height`, `sob_subform_left`, `sob_subform_primary_key`, `sob_subform_read_only`, `sob_subform_selected_row_color`, 
`sob_subform_sql`, `sob_subform_table`, `sob_subform_title_height`, `sob_subform_top`, `sob_subform_width`, `sob_subform_odd_background_color`, `sob_subform_even_background_color`,
`sob_text_align`, `sob_text_date_button_length`, `sob_text_default_value_sql`, `sob_text_format`, `sob_text_length`, `sob_text_mask`, `sob_text_no_blanks`,
`sob_text_no_duplicates`, `sob_text_password`, `sob_text_read_only`, `sob_text_total`, `sob_textarea_height`, `sob_textarea_default_value_sql`, `sob_textarea_length`,
`sob_textarea_no_blanks`, `sob_textarea_read_only`, `sob_words_length`, `sys_setup`, `sys_added`, `sys_changed`, `sys_user_id`) VALUES
('14f0247a001c92', 'form', '', '0', '', '1', 10, '', 'sfo_row_height', '', '', '', '', '', '', '', '', 10, 110, 'Browse', 'Row Pixel Height', 'text',
'', NULL, NULL, 0, 0, 0, '', '', NULL, NULL, '', '', NULL, 0, '', '', 8, '', '', '', 'SELECT zzsys_style_id, sst_class FROM zzsys_style ORDER BY sst_class',
NULL, '', NULL, '', NULL, '', '', 0, '', '', NULL, '', 0, 0, NULL, '', NULL, '', '', 0, '', '', '', 0, NULL, '', '', '', '', '', '', '', '', '', NULL, NULL,
0, '', '', 0, 0, '', '', '', '', '', 0, 0, 0, '', '', 'r', NULL, '', '0', 2, NULL, '', '', '', '', NULL, '', '', 0, '', '', 0, '1', '2012-01-03 10:41:12',
'2012-01-06 11:31:29', 'globeadmin');
 
ALTER TABLE `zzsys_form` CHANGE `sfo_row_height` INT NOT NULL;
 
ALTER TABLE `zzsys_form` ADD `sfo_row_zzsys_style_id` INT NULL DEFAULT '0' AFTER `sfo_row_height` ;
 
DELETE  FROM zzsys_object WHERE sob_zzsys_form_id = 'object' AND sob_all_tab_title = 'Inarray';
 
DELETE  FROM `zzsys_list` WHERE `sli_name` = 'fieldtype' AND `sli_option` = 'Inarray';
 
UPDATE zzsys_browse SET sbr_width = '240' WHERE zzsys_browse_id = '1455393203f20c' ;
 
DELETE FROM `zzsys_object` WHERE `sob_zzsys_form_id` LIKE 'object' AND `sob_all_title` LIKE 'Autocomplete';
 
 
INSERT INTO `zzsys_style` (`zzsys_style_id`, `sst_class`, `sst_description`, `sst_custom`) VALUES
 
('14f011afcf056d', '.nuBrowse', 'DIV surrounding Browse rows', '1'),
 
('14f022598ba89b', '.nuSearch', 'DIV surroundingSearch and Buttons', '1'),
 
('14f037c6573fb2', '.nuSelectedRow', 'Selected Rows on Browse Form', '1'),
 
('14f035e836a52e', '.nuUnselectedRow', 'Unselected Rows on Browse Form', '1');
 
 
 
INSERT INTO `zzsys_style_property` (`zzsys_style_property_id`, `ssp_property_name`, `ssp_property_value`, `ssp_zzsys_style_id`) VALUES
 
('14f036064f32cd', 'background-color', 'blue', '14f011afcf056d'),
 
('14f011afd00bb4', 'border-width', '4px', '14f011afcf056d'),
 
('14f0380be76186', 'border-style', 'solid', '14f011afcf056d'),
 
('14f036382559bb', 'color', 'white', '14f011afcf056d'),
 
('14f013b1a0c1ef', 'width', '1000px', '14f011afcf056d'),
 
('14f011afd0a180', 'left', '10px', '14f011afcf056d'),
 
('14f011afd0c4ab', 'top', '30px', '14f011afcf056d'),
 
('14f013cc2b5a02', 'height', '600px', '14f011afcf056d'),
 
('14f01232115651', 'overflow', 'hidden', '14f011afcf056d'),
 
('14f0391e35ac25', 'font-family', 'tahoma', '14f011afcf056d'),
 
('14f03924fd80dc', 'font-size', '12px', '14f011afcf056d'),
 
('14f0f667dad999', 'border-color', 'red', '14f011afcf056d'),
 
('14f022598c352b', 'left', '100px', '14f022598ba89b'),
 
('14f022598c56e5', 'top', '5px', '14f022598ba89b'),
 
('14f039a0a95ef5', 'family-font', 'tahoma', '14f022598ba89b'),
 
('14f035e837116c', 'font-family', 'tahoma', '14f035e836a52e'),
 
('14f035e83754ba', 'color', 'black', '14f035e836a52e'),
 
('14f035e837763a', 'background-color', 'lightblue', '14f035e836a52e'),
 
('14f035e8373329', 'font-size', '12px', '14f035e836a52e'),
 
('14f037c657f6b5', 'font-size', '12px', '14f037c6573fb2'),
 
('14f037c657d47f', 'background-color', 'blue', '14f037c6573fb2'),
 
('14f037c657b155', 'color', 'white', '14f037c6573fb2'),
 
('14f037c6578cbd', 'font-family', 'tahoma', '14f037c6573fb2');




Other Styles used in nuBuilder


nuBuilder has a number of default Styles.

Although each Object in nuBuilder can also have their own style.

There are a number of standard Styles used by nuBuilder, they are :



.actionButton

This style affects the Form Action Buttons such as Save, Delete, Clone and the Search screen button as Search and Add.





.browsematch

This highlights the text matched with that in the Search Field as well as text passed by the pFilter parameter of openBrowse(pFormID, pFilter, pPrefix, pSession, pFormSession) (the Default Filter for Browse Screen of a Button Object)




.button

This style affects the Buttons on the Index Screen.




Lookup


.lookupcode affects the first field in a Lookup Object, which is called the Code field.

.lookupdesc affects the second field in a Lookup Object, which is called the Description field.




.objects

This style affects all Objects by default except buttons.






.searchcolour

This style affects the Search Field on the Search Screen.


.selected

This style affects the font and background settings for Edit Screens. If a screen has tabs, then this style affects the selected one.




.unselected

This style affects the font and background settings for Edit Screens. If a screen has tabs, this style affects the one that is not selected.


.words

This style affects the font and colour of Word objects.





Created by: steven. Last Modification: Tuesday 14 of February, 2012 09:55:03 CST by admin.