Changeset 1991387
- Timestamp:
- 12/11/2018 04:17:53 AM (7 years ago)
- Location:
- nubuilder-forte/trunk
- Files:
-
- 4 edited
-
nubuilder-forte.php (modified) (3 diffs)
-
nubuilder-include.php (modified) (1 diff)
-
nubuilder4.sql (modified) (2 diffs)
-
readme.txt (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
nubuilder-forte/trunk/nubuilder-forte.php
r1990306 r1991387 2 2 /** 3 3 * @package nubuilder-forte 4 * @version 1. 04 * @version 1.1 5 5 */ 6 6 … … 10 10 Description: nuBuilder is a low-code, open-source application builder. Build reports and forms using Wordpress tables and any other table created in your Wordpress database. 11 11 Author: nuSoftware 12 Version: 1. 012 Version: 1.1 13 13 Text Domain: nubuilder-forte 14 14 */ … … 116 116 $top = $validated_short_code_attributes[NU_SHORT_CODE_TOP] . 'px'; 117 117 $left = $validated_short_code_attributes[NU_SHORT_CODE_LEFT] . 'px'; 118 $style = "style=' overflow:hidden;top:$top;left:$left;border-style:hidden;border-width:0px;border-color:lightgrey;width:$width;height:$height'";118 $style = "style='position:absolute;overflow:hidden;top:$top;left:$left;border-style:hidden;border-width:0px;border-color:lightgrey;width:$width;height:$height'"; 119 119 $result = "<iframe id='nubuilder4_iframe' $style scrolling='no' src='$iframe_url'></iframe>"; 120 120 -
nubuilder-forte/trunk/nubuilder-include.php
r1990310 r1991387 3 3 if (basename(__FILE__) === basename($_SERVER['SCRIPT_NAME']) ) die('error no: 101 - permission denied'); 4 4 5 define('NU_BUILD', '1.1. 0.2018');5 define('NU_BUILD', '1.1.1.2018'); 6 6 define('NU_PRODUCTION_MODE', true); 7 7 define('NU_USE_APACHE_ERROR_LOG', false); -
nubuilder-forte/trunk/nubuilder4.sql
r1990306 r1991387 267 267 LOCK TABLES `zzzzsys_form` WRITE; 268 268 /*!40000 ALTER TABLE `zzzzsys_form` DISABLE KEYS */; 269 INSERT INTO `zzzzsys_form` VALUES ('nuhome','launch','nuhome','Home','','','',0,0,'','\n\nnuAttachButtonImage(\'run_php\',\'RP\');\nnuAttachButtonImage(\'run_setup\',\'SET\');\nnuAttachButtonImage(\'form_button\',\'F\');\nnuAttachButtonImage(\'run_lang\',\'TR\');\nnuAttachButtonImage(\'run_report\',\'RR\');\nnuAttachButtonImage(\'user_home\',\'UH\');\nnuAttachButtonImage(\'run_user\',\'U\');\nnuAttachButtonImage(\'run_file\',\'FILE\');\nnuAttachButtonImage(\'edit_php\',\'P\');\nnuAttachButtonImage(\'edit_report\',\'R\');\nnuAttachButtonImage(\'run_access\',\'KEY\');\nnuAttachButtonImage(\'run_fast_form\',\'FF\');\nnuAttachButtonImage(\'run_format\',\'FMT\');\nnuAttachButtonImage(\'run_fast_report\',\'FR\');\nnuAttachButtonImage(\'object_button\',\'OB\');\nnuAttachButtonImage(\'run_sql\',\'SQL\');\nnuAttachButtonImage(\'run_chart\',\'CH\');\nnuAttachButtonImage(\'open_database\',\'DB\');\nnuAttachButtonImage(\'system_update\',\'SU\');\n\n\n$(\'.nuActionButton\').hide();\n\n$(\'#user_home\').addClass(\'nuUserHomeButton\');\n\n$(\'#open_database\')\n.attr(\'title\', \'PHPMyAdmin\')\n//.click(function(){\n// window.open(\'nupmalogin.php\');\n//});\n\n\n$(\'#run_php\')\n.css(\'text-align\', \'left\')\n.css(\'padding\', \'0px 0px 0px 35px\')\n.css(\'background-size\', \'30px\')\n.css(\'background-repeat\', \'no-repeat\');\n\nnuGetStartingTab();\n'),('nubrowse','subform','nubrowse','Browse Columns','zzzzsys_browse','zzzzsys_browse_id','',0,5,'SELECT * FROM zzzzsys_browse\nORDER BY sbr_order\n','$(\'#nuSearchButton\').remove();\n$(\'#nuSearchField\').remove();\n$(\'#nuPrintButton\').remove();\n\nnuSetTitle($(\'#sbr_title\').val());\n\nvar pid = parent.nuFORM.getCurrent().record_id;\n\nif(nuFORM.getCurrent().record_id == -1){\n $(\'#sbr_zzzzsys_form_id\').val(pid).change();\n}\n'),('nutab','browse','nutab','Form Tab','zzzzsys_tab','zzzzsys_tab_id','',0,0,'SELECT * FROM zzzzsys_tab\nJOIN zzzzsys_form ON zzzzsys_form_id = syt_zzzzsys_form_id\nORDER BY syt_order','\n$(\"[data-nu-column=\'3\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n'),('nuobject','browseedit','nuobject','Object','zzzzsys_object','zzzzsys_object_id','',0,0,'SELECT * FROM zzzzsys_object\nJOIN #TABLE_ID# ON zzzzsys_object_id = theid\nJOIN zzzzsys_tab ON zzzzsys_tab_id = sob_all_zzzzsys_tab_id\nJOIN zzzzsys_form ON zzzzsys_form_id = syt_zzzzsys_form_id \n','\n$(\'#add_total\').css(\'overflow-y\',\'scroll\').css(\'background-color\',\'#ebebeb\');\n\n$(\'#zzzzsys_event_sfsev_javascript\').attr(\'id\',\'jsfuntitle\');\n$(\'#sob_calc_formula\').addClass(\'nuCalculatorCurrency\').css(\'font-size\', 12);\n$(\'#sob_all_display_condition\').addClass(\'sql\');\n$(\'#sob_all_default_value_sql\').addClass(\'sql\');\n$(\'#sob_display_sql\').addClass(\'sql\');\n$(\'#sob_select_sql\').addClass(\'sql\');\n$(\'#sob_lookup_php\').addClass(\'php\');\n$(\'#sob_lookup_javascript\').addClass(\'js\');\n$(\'#sob_input_javascript\').addClass(\'js\');\n$(\'#sob_html_javascript\').addClass(\'js\');\n$(\'#sob_html_code\').addClass(\'html\');\n$(\"[id$=\'sev_javascript\']\").addClass(\'js\');\n$(\"#title_zzzzsys_event_sfsev_javascript\").removeClass(\'js\');\n\n$(\'#nuTab8\').click(function(){nuTestChart();});\n\nnuAttachButtonImage(\'icon\', \'LUJS\');\nnuAttachButtonImage(\'ab_event\',\'AB\');\nnuAttachButtonImage(\'di_sql\',\'SQL\');\nnuAttachButtonImage(\'se_sql\',\'SQL\');\n\n$(\'#sob_lookup_javascript\')\n.css(\'padding\', \'3px 3px 3px 3px\')\n\n$(\'#viewflowchart\')\n.css(\'padding\', \'46px 0px 0px 3px\')\n.css(\'text-align\', \'left\')\n.css(\'background-size\', \'75px\')\n\n\nif($(\'#zzzzsys_event_sf000sev_event\').val() != \'\'){\n $(\'#nuTab10\').css(\'font-weight\', \'bold\');\n}\n\n\nif(nuFORM.getCurrent().record_id == -1){\n \n $(\'#sob_all_top\').val(0).change();\n $(\'#sob_all_left\').val(0).change();\n $(\'#sob_all_height\').val(0).change();\n $(\'#sob_all_width\').val(0).change();\n $(\'#sob_all_validate\').val(0).change();\n $(\'#sob_all_access\').val(0).change();\n $(\'#sob_all_align\').val(\'left\').change();\n $(\'#sob_all_cloneable\').val(1).change();\n \n nuHasNotBeenEdited();\n}\n\nvar v = $(\'#sob_input_type\').val();\n\nif(nuFormType() == \'edit\'){\n \n nuShowInputJS(v);\n nuHideCalcObjects();\n nuSetTitle($(\'#sob_all_id\').val());\n nuPopulateHTML();\n \n}\n\nvar filter = String(window.filter).split(\'|\');\n\nif(filter[0] == \'fromfastform\'){\n \n $(\'#nuDeleteButton\').remove();\n $(\'#nuCloneButton\').remove();\n $(\'#nuSaveButton\').remove();\n $(\'#sob_all_id\').val(filter[1]).addClass(\'nuHighlight\');\n $(\'#sob_all_label\').val(filter[2]).addClass(\'nuHighlight\');\n \n}\n\n\n\n$(\'.js\').dblclick(function() {nuOpenAce(\'Javascript\', this.id);});\n$(\'.sql\').dblclick(function() {nuOpenAce(\'SQL\', this.id);});\n$(\'.html\').dblclick(function() {nuOpenAce(\'HTML\', this.id);});\n$(\'.php\').dblclick(function() {nuOpenAce(\'PHP\', this.id);});\n\nnuObjectColor();\n\n$(\"[data-nu-column=\'0\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\nnuHide(\'sob_input_format\');\n\nvar sit = $(\'#sob_input_type\').val();\n\nif(sit == \'nuDate\' || sit == \'nuNumber\'){\n nuShow(\'sob_input_format\');\n}\n\nif(sit == \'nuScroll\'){\n nuShow(\'sob_input_javascript\');\n}else{\n nuHide(\'sob_input_javascript\');\n}\n\nnuGetStartingTab();\n\nfunction nuTestChart(){\n \n var g = $(\'#sob_html_chart_type\').val();\n var t = $(\'#sob_all_type\').val();\n \n if(g == \'\' || t != \'html\'){$(\'#google_chart\').html(\'\');return;}\n \n var c = \'ComboChart\';\n var t = $(\'#sob_html_title\').val();\n var x = $(\'#sob_html_vertical_label\').val();\n var y = $(\'#sob_html_horizontal_label\').val();\n var l = \'bars\';\n var s = false;\n var a = [\n [\'Month\', \'Shane\', \'Dave\', \'Adam\', \'Paul\', \'Chris\'],\n [\'2004\', 100, 200, 300, 400, 500],\n [\'2005\', 165, 238, 322, 498, 550],\n [\'2006\', 165, 938, 522, 998, 450],\n [\'2007\', 135, 1120, 599, 1268, 288]\n ];\n \n if(g == \'p\') {c = \'PieChart\';}\n if(g == \'l\') {l = \'lines\';}\n if(g == \'bh\') {c = \'BarChart\';}\n if(g == \'bhs\') {c = \'BarChart\';}\n if(g == \'bs\') {s = true;}\n if(g == \'bhs\') {s = true;}\n\n nuChart(\'google_chart\', c, a, t, x, y, l, s);\n\n}\n\n\n\n\n\nfunction nuObjectColor(){\n \n $(\'.nuValidate\').removeClass(\'nuValidate\');\n\n var e = $(\'#sob_all_type\').hasClass(\'nuEdited\');\n var o = [];\n\n o[\'run\'] = 1;\n o[\'display\'] = 2;\n o[\'select\'] = 3;\n o[\'lookup\'] = 4;\n o[\'subform\'] = 5;\n o[\'image\'] = 6;\n o[\'input\'] = 7;\n o[\'html\'] = 8;\n o[\'calc\'] = 9;\n \n\n $(\'#sob_all_type\').removeClass();\n \n if(e){ //-- keep class if edited\n $(\'#sob_all_type\').addClass(\'nuEdited\');\n }\n \n $(\'#sob_all_type\').addClass(\'nu_\'+$(\'#sob_all_type\').val());\n \n $(\"#sob_all_type > option\").each(function() {\n $(this).addClass(\'nu_\'+this.value);\n });\n \n $(\"#sob_input_type > option\").each(function() {\n $(this).addClass(\'input_\'+this.value);\n });\n \n var t = o[$(\'#sob_all_type\').val()];\n \n $(\"[id^=\'nuTab\']\").removeClass(\'nuRelatedTab\');\n \n for(var i = 1 ; i < o.length ; i++){\n $(\'#nuTab\' + i).removeClass(\'nuRelatedTab\');\n }\n \n $(\'#nuTab0\').addClass(\'nuRelatedTab\');\n $(\'#nuTab\' + t).addClass(\'nuRelatedTab\');\n \n} \n\n\nfunction nuAddToFormula(e){\n \n var fld = e.target.innerHTML;\n var frm = $(\'#sob_calc_formula\').val();\n \n if(fld == \'Clear\'){\n \n $(\'#sob_calc_formula\')\n .val(\'\')\n .addClass(\'nuEdited\');\n return;\n \n }\n\n $(\'#sob_calc_formula\')\n .addClass(\'nuEdited\')\n .val(frm + fld);\n \n nuHasBeenEdited();\n \n}\n\nfunction nuShowInputJS(t){\n\n nuHide(\'sob_input_format\');\n nuHide(\'sob_input_count\');\n nuHide(\'sob_input_javascript\');\n \n if(t == \'nuScroll\'){\n nuShow(\'sob_input_javascript\');\n }\n\n if(t == \'nuAutoNumber\'){\n \n nuShow(\'sob_input_count\');\n $(\'#sob_input_javascript\').val(\'\').change();\n \n }\n\n if(t == \'nuDate\' || t == \'nuNumber\'){\n \n nuShow(\'sob_input_format\');\n\n $(\'#sob_input_format\').children().each(function(index) {\n \n $(this).show();\n \n if($(this).val()[0] == \'D\' && t != \'nuDate\') {$(this).hide();}\n if($(this).val()[0] == \'N\' && t != \'nuNumber\') {$(this).hide();}\n \n });\n \n }\n \n}\n\n\nfunction nuHideCalcObjects(){\n\n var f = $(\'#sob_all_zzzzsys_form_id\').val();\n\n $(\'#add_total\').children().each(function(index) {\n\n\n if($(this).val() != f){\n $(this).hide();\n }\n if($(this).text() == $(\'#sob_all_id\').val()){\n $(this).hide();\n }\n\n });\n \n}\n\n\nfunction nuAddCalcObject(t){\n \n var f = $(\'#sob_calc_formula\').val();\n var i = $(t).attr(\'data-nu-ids\');\n var s = f + \"nuTotal(\'\" + i + \"\')\";\n \n if(i == \'\'){return;}\n\n $(\'#sob_calc_formula\')\n .addClass(\'nuEdited\')\n .val(s);\n\n $(\'#add_total\').val(\'\');\n \n nuHasBeenEdited();\n \n}\n\n\nfunction nuPopulateHTML(){\n\n var o = nuCalcObjects();\n var a = [];\n\n for(var i = 0 ; i < o.length ; i++){\n \n var ids = String(o[i].ids);\n var ty = o[i].type;\n var id = String(o[i].ids).split(\'.\');\n var sp = \' \';\n\n if(id.length == 1){\n a.push(\'<tr><td><div title=\"\'+ty+\'\" style=\"overflow:hidden;width:314px;text-align:left;padding:2px\" onclick=\"nuAddCalcObject(this);\" class=\"nuCalculatorButton nu_\' + o[i].type + \'\" data-nu-ids=\"\' + ids + \'\">\' + ids + \'</div></td></tr>\');\n }else{\n \n var h = \'<span title=\"subform\" class=\"nu_subform\">\' + id[0] + \'</span>.<span title=\"\'+ty+\'\" class=\"nu_input\" style=\"padding:7px 5px 7px 5px\">\' + id[1] + sp.repeat(200) + \'</span>\';\n a.push(\'<tr><td><div style=\"overflow:hidden;width:314px;text-align:left;padding:2px\" onclick=\"nuAddCalcObject(this);\" class=\"nuCalculatorButton nu_subform\" data-nu-ids=\"\' + ids + \'\">\' + h + \'</div></td></tr>\');\n \n }\n \n }\n\n $(\'#add_total\').html(\'<table>\' + a.join(\'\') + \'</table>\');\n\n}\n\n\n'),('nufflaunch','launch','nufflaunch','Form Builder','','','',0,0,'SELECT * FROM zzzzsys_form','\n$(\"[id$=\'ff_browse\']\").hide();\n$(\'#title_obj_sfff_browse\').show();\n$(\'#ffwrd\').css({\'font-size\' : 14, \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\n$(\'#wrdaddable\').css({\'font-size\' : 14, \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\n$(\'.nuActionButton\').hide();\n$(\'#nuTab0\').remove();\n$(\'#fastform_type\').focus();\n\nnuSetFK();\n\nnuAddActionButton(\'nuRunPHPHidden\', \'Build Fast Form\', \'nuRunPHPHidden(\"RUNFF\")\');\n\n$(\"#fastform_type > option\").each(function() {\n $(this).addClass(\'nu_\' + this.value);\n});\n\nfunction nuFormColor(){\n\n var t = String($(\'#fastform_type\').val());\n \n $(\'#fastform_type\').removeClass();\n $(\'#fastform_type\').addClass(\'nu_\'+$(\'#fastform_type\').val());\n \n if(t == \'launch\'){\n \n $(\'#fastform_table\').hide();\n $(\'#label_fastform_table\').hide();\n\n }else{\n $(\'#fastform_table\').show();\n $(\'#label_fastform_table\').show();\n }\n \n \n if(t == \'browse\' || t == \'browseedit\'){\n \n $(\"[id$=\'ff_browse\']:checkbox\").each(function(index){\n \n var fld = \'#\' + this.id.substr(0, 6) + nuPad3(index + 1) + \'ff_field\';\n\n if($(fld).length == 1){\n $(this).show();\n }\n \n });\n \n }else{\n $(\"[id$=\'ff_browse\']:checkbox\").hide();\n }\n\n nuSetFK();\n\n}\n\n\nfunction nuSetFFTable(){\n \n var v = $(\'#fastform_table\').val();\n\n if(nuFORM.getTables().indexOf(v) == -1){\n \n $(\"[data-nu-field=\'ff_field\']\")\n .removeClass(\'input_nuScroll\')\n .removeClass(\'nuScroll\');\n\n }else{\n \n $(\"[data-nu-field=\'ff_field\']\")\n .addClass(\'input_nuScroll\')\n .addClass(\'nuScroll\');\n\n }\n\n $(\"#title_obj_sfff_field\")\n .removeClass(\'input_nuScroll\')\n .removeClass(\'nuScroll\');\n \n var l = $(\"[id$=\'ff_browse\']\").length-2;\n \n $(\'#obj_sf\' + nuPad3(l) + \'ff_browse\').hide();\n\n nuSetFK();\n \n}\n\n\nfunction nuSetFK(){\n \n $(\'#fastform_fk\').hide();\n $(\'#label_fastform_fk\').hide();\n\n var v = $(\'#fastform_table\').val();\n\n if(v != \'\' && nuFORM.getTables().indexOf(v) == -1 && $(\'#fastform_type\').val() == \'subform\'){\n \n $(\'#fastform_fk\').show().focus();\n $(\'#label_fastform_fk\').show();\n\n }\n \n}\n\n\nfunction nuShowFFO(e){\n \n var t = $(\'#\' + e.target.id).attr(\'data-nu-prefix\');\n var i = $(\'#\' + t + \'ff_id\').val();\n var l = $(\'#\' + t + \'ff_label\').val();\n var f = $(\'#\' + t + \'ff_field\').val();\n var fff = \'fromfastform|\' + f + \'|\' + l;\n\n nuPopup(\'nuobject\', i, fff);\n\n}\n\nfunction nuFocusFFObject(e){\n\n var p = $(e.target).attr(\'data-nu-prefix\');\n \n if($(\'#\' + p + \'ff_id\').val() == \'\'){\n $(\'#fastform_table\').focus();\n }\n \n}\n\n\n\n\nfunction nuMoveFF(){\n \n var i = $(\'#new_id\').val();\n\n nuPopup(i, -2);\n\n}\n\nfunction nuCreateSQLPrefix(){\n \n var p = $(\'#fastform_prefix\');\n var t = $(\'#fastform_table\');\n \n p.val(String(t.val()).substr(0, 3));\n \n}\n\n\nfunction nuBeforeSave(){\n \n var table = $(\'#fastform_table\').val();\n var type = String($(\'#fastform_type\').val());\n var browse = type.substr(0, 6) == \'browse\';\n\n if(table == \'\' && type != \'launch\'){\n \n nuMessage([\'Table Name cannot be left blank..\']);\n \n return false;\n\n }\n \n if(type == \'\'){\n \n nuMessage([\'Must select <b>Form Type</b>...\']);\n \n return false;\n\n }\n \n if(browse){\n \n if($(\"[data-nu-field=\'ff_browse\']:checked\").length == 0){\n \n nuMessage([\'At least 1 Browse needs to be checked..\']);\n \n return false;\n \n }\n \n }\n\n var v = $(\'#fastform_table\').val();\n var t = $(\'#fastform_type\').val();\n var f = $(\'#fastform_fk\').val();\n\n if(v != \'\' && nuFORM.getTables().indexOf(v) == -1 && t == \'subform\' && f == \'\'){\n \n nuMessage([\'<b>Foreign Key Field Name</b> cannot be left blank...\']);\n \n return false;\n\n }\n \n var a = [];\n \n for(var i = 0 ; i < nuSubformObject(\'obj_sf\').rows.length ; i++){\n a.push(nuSubformObject(\'obj_sf\').rows[i][2]);\n }\n\n\n if(f != \'\' && a.indexOf(f) > -1 && t == \'subform\'){\n \n nuMessage([\'<b>Foreign Key Field Name</b> is already used...\']);\n \n return false;\n\n }\n \n\n\n\n\n \n \n if(!nuValidColumn()){\n return false;\n }\n\n return true;\n \n}\n\n\nfunction nuValidColumn(){\n \n var tn = $(\'#fastform_table\').val();\n \n if(nuFORM.getTables().indexOf(tn) == -1){return true;}\n \n var sf = nuSubformObject(\'obj_sf\');\n \n for(var i = 0 ; i < sf.rows.length ; i++){\n \n if(sf.rows[i][4] == 1 && sf.deleted[i] != 1){ //-- ticked column checkbox\n \n var valid = nuFORM.tableSchema[tn].names.indexOf(sf.rows[i][2]) //-- fieldname\n \n if(valid == -1){\n \n nuMessage([\'Invalid column name <b>\' + sf.rows[i][2] + \'</b>\']);\n \n return false;\n \n }\n }\n \n }\n \n return true;\n\n}\n\n\nfunction nuSelectFFObjects(e){\n \n var classes = e.target.className.split(\' \');\n var id = e.target.id;\n var rowno = nuPad3($(\"[id^=\'obj_sf\'][id$=\'ff_label\']\", document).length-1);\n var rowsuf = nuPad2(rowno);\n var sfrow = \'#obj_sf\' + rowno;\n var h = String(e.target.innerHTML).split(\':\');\n \n $(sfrow + \'ff_label\')\n .val(h[h.length-1] + rowsuf)\n .addClass(classes[1])\n .change();\n\n $(sfrow + \'ff_field\')\n .val(\'field\' + rowsuf)\n .change();\n\n $(sfrow + \'ff_id\')\n .val(id)\n .change();\n \n var nb = [\'Word\', \'Subform\', \'Image\', \'HTML\', \'Display\', \'Input:file\', \'Input:button\', \'Select:multiselect\'].indexOf(e.target.innerHTML); \n\n if(nb == -1){\n $(sfrow + \'ff_browse\').show();\n }else{\n $(sfrow + \'ff_browse\').remove();\n }\n \n $(\'#fastform_type\').change();\n\n}\n\n\n\n'),('nuevent','edit','nuevent','Object Events','zzzzsys_event','zzzzsys_event_id','',0,0,'SELECT * FROM zzzzsys_event',''),('nuaccess','browseedit','nuaccess','Access Levels','zzzzsys_access','zzzzsys_access_id','',0,0,'SELECT * FROM zzzzsys_access\nORDER BY sal_code\n','nuSetTitle($(\'#sal_code\').val());'),('nunonsystemform','edit','nunonsystemform','nuBuilder non-System Form','zzzzsys_form','zzzzsys_form_id','',0,0,'SELECT * FROM zzzzsys_form\nWHERE ((zzzzsys_form_id NOT LIKE \'nu%\' AND sfo_type != \'subform\')\nOR zzzzsys_form_id IN (\'nuaccess\', \'nuuser\', \'nulaunchdates\', \'nutranslate\', \'nupassword\', \'nufile\', \'nuuserhome\', \'nublank\', \'nurunreport\'))\nORDER BY sfo_code','$(\"[data-nu-column=\'0\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\n'),('nuaccessforms','edit','nuaccessforms','Accessible Forms','zzzzsys_access_form','zzzzsys_access_form_id','',0,0,'SELECT * FROM zzzzsys_access_form\nLEFT JOIN zzzzsys_form ON zzzzsys_form_id = slf_zzzzsys_form_id\nORDER BY sfo_code\n',''),('nuuser','browseedit','nuuser','User','zzzzsys_user','zzzzsys_user_id','',0,15,'SELECT * \nFROM zzzzsys_user \nLEFT JOIN zzzzsys_access ON zzzzsys_access_id = sus_zzzzsys_access_id\nORDER BY sus_name',''),('nubuildreport','browseedit','nubuildreport','Build Report','zzzzsys_report','zzzzsys_report_id','',0,0,'SELECT * FROM zzzzsys_report\nLEFT JOIN zzzzsys_form ON zzzzsys_form_id = sre_zzzzsys_form_id','\n$(\'#sre_layout\').addClass(\'nuEdited\'); \n\nnuAttachButtonImage(\'open_builder\',\'RD\');\n\n\nfunction nuPickTableType(){\n \n var i = $(\'#sre_zzzzsys_php_id\').val();\n \n var f = \'\';\n var r = \'\';\n \n if(i.substr(0,10) == \'PROCEDURE:\'){\n \n f = \'nuphp\';\n r = i.substr(10);\n \n }\n \n if(i == \'\'){\n \n nuMessage([nuTranslate(\'Table selected must be an SQL or Procedure\')]);\n return;\n\n }\n \n if(i.substr(0,6) == \'TABLE:\'){\n \n nuMessage(nuTranslate([\'To edit a table go to the Database Button\']));\n return;\n\n }\n \n if(i.substr(0,4) == \'SQL:\'){\n \n f = \'nuselect\';\n r = i.substr(4);\n\n }\n \n nuPopup(f,r);\n \n}\n'),('nuphp','browseedit','nuphp','Build Procedure','zzzzsys_php','zzzzsys_php_id','',0,0,'SELECT * FROM zzzzsys_php\nLEFT JOIN zzzzsys_form ON zzzzsys_form_id = sph_zzzzsys_form_id\nWHERE (sph_system != \'1\' || sph_system IS NULL)\nORDER BY sph_code\n','\nwindow.nuImages = parent.nuImages;\n\n$(\'#sph_php\')\n.addClass(\'php\')\n.dblclick(function() {\n nuOpenAce(\'PHP\', this.id);\n})\n\n\nwindow.nuHelp = \'Procedures\';\n\nif(window.filter == \'justphp\'){\n\n nuHelp = \'Functions\';\n var ev = [];\n ev[\'BB\'] = \'Before Browse\';\n ev[\'BE\'] = \'Before Edit\';\n ev[\'BS\'] = \'Before Save\';\n ev[\'AS\'] = \'After Save\';\n ev[\'BD\'] = \'Before Delete\';\n ev[\'AD\'] = \'After Delete\';\n ev[\'AB\'] = \'After Browse\';\n \n var suf = nuFORM.getCurrent().record_id.substr(-2);\n var e = ev[suf];\n var f = $(\'#sfo_description\', window.parent.document).val();\n\n if(e == \'After Browse\'){\n var f = $(\'#sob_all_label\', window.parent.document).val();\n }\n\n nuAttachButtonImage(\'icon\', suf);\n \n $(\'#sph_php\')\n .css(\'padding\', \'3px 3px 3px 3px\')\n .css(\'top\', \'40px\')\n .css(\'height\', \'200px\')\n .css(\'left\', \'90px\')\n .focus()\n\n \n $(\'#wiki\')\n .css(\'left\', \'670px\')\n\n $(\'#nu_bc_0\').html(\'<b>\' + e + \'</b> for : \' + f);\n $(\'#sph_code\').val(nuFORM.getCurrent().record_id).change();\n $(\'#sph_description\').val(\'System PHP\').change();\n $(\'#sph_system\').val(\'1\').change();\n $(\'#label_sph_php\').css(\'top\', \'40px\').css(\'left\', \'20px\');\n $(\'.nuSaveButtonEdited\').removeClass(\'nuSaveButtonEdited\');\n \n nuHide(\'sph_code\');\n nuHide(\'sph_description\');\n nuHide(\'sph_zzzzsys_form_id\');\n nuHide(\'sph_group\');\n nuHide(\'sph_system\');\n nuHide(\'sph_run\');\n\n nuSetTitle(e);\n \n}else{\n nuSetTitle($(\'#sph_code\').val());\n}\n\nnuHasNotBeenEdited();\n\n\n'),('nublank','launch','nublank','Blank','','','',0,0,'','\nnuSetTitle(nuFORM.getCurrent().run_description);\n'),('nuaccessgroup','subform','nuaccessgroup','Groups Access Level','zzzzsys_user_group_access_level','zzzzsys_user_group_access_level_id','',0,0,'SELECT * FROM zzzzsys_user_group_access_level',''),('nurunlist','browse','nurunlist','Run Form, Report or Procedure','zzzzsys_run_list','id','',0,0,'SELECT * FROM zzzzsys_run_list','\n$(\"[data-nu-column=\'nucolumn000\']\").each(function() {\n\n $(this).addClass(\'nu_\'+this.innerHTML);\n\n});'),('nudebug','browseedit','nudebug','nuDebug Entries','zzzzsys_debug','zzzzsys_debug_id','',21,15,'SELECT * FROM zzzzsys_debug\nORDER BY zzzzsys_debug_id DESC','\n$(\'#deb_message\')\n .css(\'font-size\', 10)\n .css(\'background-color\', \'#FFEEA6\')\n .prop(\'readonly\', true)\n .dblclick(function() {\n nuOpenAce(\'Text\', this.id);\n });\n\n\n\n\n\n$(\'#delete_option\').val(0);\n$(\'#nuAddButton\').remove();\n$(\'#nuOptions\').remove();\n\nvar mess = String($(\'#deb_message\').val());\nvar i = mess.indexOf(\'<br>\');\nvar m = mess.substr(i + 6);\nvar t = mess.substr(0,i);\n\nnuSetTitle(mess.substr(0, i))\n\n$(\'#nuTab0\').remove();\n\n$(\'#nuBreadcrumb1\')\n.css(\'text-align\', \'center\')\n.css(\'width\', \'95%\')\n.css(\'color\', \'black\')\n.css(\'padding\', \'5px\')\n.html(t + \' :: \' + nuWhen($(\'#deb_added\').val()))\n.appendTo(\"#nuTabHolder\");\n\n$(\'#deb_message\').val(m);\n\n\n$(\"[data-nu-column=\'1\']\").each(function( index ) {\n \n if($(this).html().trim() != \'\'){\n \n var nunow = Date.now();\n var nuhtm = nuWhen(Number($(this).html()));\n \n $(this).html(nuhtm);\n \n }\n \n});\n\nif(nuFORM.getCurrent().record_id != \'\'){\n\n $(\'.nuActionButton\').remove();\n nuAddActionButton(\'Delete\');\n nuAddActionButton(\'DeleteAll\',\'Delete All\', \'nuDeleteAllAction()\');\n\n}else{\n nuAddActionButton(\'DeleteAll\',\'Delete All\', \'nuDeleteAllAction()\');\n}\n\n'),('nuaccessreport','browseedit','nuaccessreport','Access To Procedures','zzzzsys_access_php','zzzzsys_access_php_id','',0,0,'SELECT * \nFROM zzzzsys_access_php\nJOIN zzzzsys_php ON zzzzsys_php_id = slp_zzzzsys_php_id\nORDER BY sph_code',''),('nuaccesslevelreport','browseedit','nuaccesslevelreport','Access To Report','zzzzsys_access_report','zzzzsys_access_report_id','',0,0,'SELECT * \nFROM zzzzsys_access_report\nJOIN zzzzsys_report ON zzzzsys_report_id = sre_zzzzsys_report_id\nORDER BY sre_code',''),('nurunreport','browseedit','nurunreport','Run Report','zzzzsys_report','zzzzsys_report_id','',0,0,'SELECT * FROM zzzzsys_report\nLEFT JOIN zzzzsys_form ON zzzzsys_form_id = sre_zzzzsys_form_id','\nnuSetTitle(nuFORM.getCurrent().run_description);\n\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\nfunction nuSelectBrowse(e){\n \n var r = $(\'#\' + e.target.id).attr(\'data-nu-row\');\n var f = $(\'#nucell_\' + r + \'_0\').html();\n var p = $(\'#\' + e.target.id).attr(\'data-nu-primary-key\');\n\n nuGetReport(f, p);\n \n}\n\n'),('nurunphp','browseedit','nurunphp','Run Procedure','zzzzsys_php','zzzzsys_php_id','',0,0,'SELECT * FROM zzzzsys_php\nJOIN zzzzsys_form ON zzzzsys_form_id = sph_zzzzsys_form_id\nWHERE (sph_system != \'1\' || sph_system IS NULL)\nORDER BY sph_code','\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\nfunction nuSelectBrowse(e){\n\n var r = $(\'#\' + e.target.id).attr(\'data-nu-row\');\n var p = $(\'#nucell_\' + r + \'_0\').html();\n var f = $(\'#\' + e.target.id).attr(\'data-nu-primary-key\');\n\n nuGetPHP(p, f);\n\n}\n\n'),('nulaunchdates','launch','nulaunchdates','Between 2 Dates','','','',0,0,'','\nnuSetTitle(nuFORM.getCurrent().run_description);'),('nutimezone','browse','nutimezone','Time Zone','zzzzsys_timezone','zzzzsys_timezone_id','',0,0,'SELECT * \nFROM zzzzsys_timezone\nORDER BY stz_timezone',''),('nusetup','edit','nusetup','Setup','zzzzsys_setup','zzzzsys_setup_id','',0,0,'','$(\'#set_header\').addClass(\'html\');\n \n$(\'.html\').dblclick(function() {\n nuOpenAce(\'HTML\', this.id);\n});\n\n'),('nutranslate','browseedit','nutranslate','Translation','zzzzsys_translate','zzzzsys_translate_id','',0,0,'SELECT * \nFROM zzzzsys_translate\nORDER BY trl_language, trl_english',''),('nupassword','edit','nupassword','Change Password','zzzzsys_user','zzzzsys_user_id','',0,0,'SELECT * FROM zzzzsys_user\nJOIN zzzzsys_user_group ON sus_zzzzsys_user_group_id = zzzzsys_user_group_id\nORDER BY sus_name','$(\'#nuTab0\').hide();'),('nusample','launch','nusample','Default Fast Form Objects','','','',0,0,'','//$(\'#nuBreadcrumbHolder\').remove();\n$(\'#nuActionHolder\').remove();\n//$(\'#nuTabHolder\').remove();\n\n$(\'#nuOptions\').hide();\n\n$(\'#inputtextsample\').val(\'text\');\n$(\'#inputnumbersample\').val(4);\n$(\'#inputnunumbersample\').val(\'$ 1,234.56\');\n$(\'#inputnudatesample\').val(\'20-Apr-2017\');\n$(\'#inputnuscrollsample\').val(\'East\');\n$(\'#calcsample\').val(\'$ 1,238.56\');\n\n$(\'#selectsample\').val(1);\n$(\'#selectmultiselectsample\').val(0);\n$(\'#textareasample\').val(\"text-area blah blah blah blah \");\n\n$(\"[id^=\'label\']\").addClass(\'nu_input\').css({width:120, left:10, \'text-align\':\'center\'});\n\n$(\'#label_imagesample\').addClass(\'nu_image\').removeClass(\'nu_input\');\n$(\'#label_textareasample\').addClass(\'nu_textarea\').removeClass(\'nu_input\');\n$(\'#label_displaysample\').addClass(\'nu_display\').removeClass(\'nu_input\');\n$(\'#label_htmlsample\').addClass(\'nu_html\').removeClass(\'nu_input\');\n$(\'#label_calcsample\').addClass(\'nu_calc\').removeClass(\'nu_input\');\n$(\'#label_selectsample\').addClass(\'nu_select\').removeClass(\'nu_input\');\n$(\'#label_selectmultiselectsample\').addClass(\'nu_select\').removeClass(\'nu_input\');\n$(\'#label_lookupsample\').addClass(\'nu_lookup\').removeClass(\'nu_input\');\n$(\'#labelword\').addClass(\'nu_word\').removeClass(\'nu_input\');\n$(\'#label_subformsample\').addClass(\'nu_subform\').removeClass(\'nu_input\').css({left:10});\n\n$(\"[id^=\'label\']\")\n.addClass(\'nuCalculatorButton\')\n.removeClass(\'nuWord\')\n.css({\'height\':30, \'width\':220})\n\n\n\n\n'),('nufastformobjects','subform','nufastformobjects','Fast Form Objects','zzzzsys_debug','zzzzsys_debug_id','',0,0,'SELECT count()* FROM zzzzsys_debug',''),('nucalcobjects','browse','nucalcobjects','Calc values On This Form And Its Subforms','#TABLE_ID#','thevalue','',0,4,'SELECT * FROM #TABLE_ID#','\nwindow.nuBrowseFunction = \'nuSelectCalcField\';\n\nfunction nuSelectCalcField(e){\n\n var row = e.target.id.substr(0,8);\n var fld = $(\'#\' + row + \'003\').html();\n var frm = $(\'#sob_calc_formula\', parent.window.document).val();\n\n $(\'#sob_calc_formula\', parent.window.document)\n .val(frm + \'nuTotal(\"\' + fld + \'\")\')\n .trigger(\'change\');\n\n}\n\n'),('nuformat','browseedit','nuformat','Input Formats','zzzzsys_format','zzzzsys_format_id','',0,0,'SELECT * FROM zzzzsys_format','\n$(\'#nucalculator\').css(\'border\',\'none\');\n$(\'#currencysign\').hide().addClass(\'nuCalculatorCurrency\').val(\'$\');\n$(\'#currencydecimals\').hide().addClass(\'nuCalculatorCurrency\').val(\'2\');\n$(\'#srm_format\').addClass(\'nuReadonly nuCalculatorCurrency\').css(\'font-size\', 12);\n$(\'.nuWord\').css(\'font-style\', \'bold\');\n\nnuSetFormatType();\n\n\nfunction nuAddToFormat(e){\n \n var v = String(e.target.innerHTML);\n \n if(v == \'Space\'){v = \' \';}\n \n if($(\'#srm_type\').val() == \'Date\'){\n \n $(\'#srm_format\')\n .val($(\'#srm_format\').val() + v)\n .change();\n \n }else{\n \n var c = String($(\'#currencysign\').val()).trim();\n var d = String(Number($(\'#currencydecimals\').val()));\n \n d = d == \'NaN\' ? 0 : Number(d);\n v = d == 0 ? v.substr(0, v.length - 1) : v;\n \n $(\'#srm_format\')\n .val(c + \' \' + v + String(0).repeat(d))\n .change();\n \n }\n \n}\n\n\nfunction nuSetFormatType(a){\n\n $(\'#format_title\').hide();\n $(\'#nucalculator\').hide();\n $(\'#currencysign\').hide();\n $(\'#currencydecimals\').hide();\n $(\'.date\').hide();\n $(\'.number\').hide();\n\n if(arguments.length == 1){\n $(\'#srm_format\').val(\'\');\n }\n \n if($(\'#srm_type\').val() == \'Date\'){\n $(\'.date\').show();\n }\n \n if($(\'#srm_type\').val() == \'Number\'){\n \n $(\'#currencysign\').show();\n $(\'#currencydecimals\').show();\n $(\'.number\').show();\n\n }\n\n $(\'#format_title\').show();\n $(\'#nucalculator\').show();\n \n}\n\n\n\n'),('nuformatcurrency','edit','nuformatcurrency','Format Currency','zzzzsys_format','zzzzsys_format_id','',0,0,'','$(\'#sign\').focus();\n\n\n$(\'#nuActionHolder\').remove();\n$(\'#nuBreadcrumbHolder\').remove();\n$(\'#nuTabHolder\').remove();\n\n\n\n\n\nfunction nuCreateCurrencyFormat(){\n console.log(\'in nuCreateCurrencyFormat()\');\n}\n'),('nuform','browseedit','nuform','nuBuilder Form','zzzzsys_form','zzzzsys_form_id','',0,0,'SELECT * FROM zzzzsys_form\nINNER JOIN #TABLE_ID# ON zzzzsys_form_id = theid\nORDER BY sfo_code\n','$(\'#title_zzzzsys_tab_sfsyt_help\').attr(\'id\', \'help_title\');\n$(\"[id$=\'syt_help\']\").addClass(\'js\');\nnuAttachButtonImage(\'previewbrowse\',\'PB\');\nnuAttachButtonImage(\'previewedit\',\'PE\');\nnuAttachButtonImage(\'bb_event\',\'BB\');\nnuAttachButtonImage(\'be_event\',\'BE\');\nnuAttachButtonImage(\'bs_event\',\'BS\');\nnuAttachButtonImage(\'as_event\',\'AS\');\nnuAttachButtonImage(\'bd_event\',\'BD\');\nnuAttachButtonImage(\'ad_event\',\'AD\');\nnuAttachButtonImage(\'icon\',\'JS\');\nnuAttachButtonImage(\'br_sql\',\'SQL\');\n\n$(\'#sfo_javascript\')\n.css(\'padding\', \'3px 3px 3px 3px\')\n\n\n$(\'#user_home\')\n.css({\n \'color\' : \'white\',\n \'font-size\' : 13,\n \'display\' : \'inline\',\n \'border-style\' : \'solid\',\n \'height\' : 30,\n \'font-size\' : 16,\n \'text-shadow\' : \'0 1px 2px #9AB973\',\n \'border-color\' : \'#9AB973\',\n \'border-width\' : \'0px 0px 1px 0px\',\n \'background-color\' : \'#88cb51\'\n});\n\n\n$(\'#sfo_javascript\').addClass(\'js\');\n$(\'#sfo_browse_sql\').addClass(\'sql\')\n.css(\'font-size\', 10)\n\nnuSetTitle($(\'#sfo_table\').val());\n\n$(\'.js\')\n.dblclick(function() {\n nuOpenAce(\'Javascript\', this.id);\n});\n\n$(\'.sql\').dblclick(function() {\n nuOpenAce(\'SQL\', this.id);\n});\n\n$(\'.html\')\n.dblclick(function() {\n nuOpenAce(\'HTML\', this.id);\n});\n\n\nif(window.filter == \'justjs\'){\n \n $(\'#nuDeleteButton\').remove();\n $(\'#nuCloneButton\').remove();\n $(\'#nuTab0\').remove();\n $(\'#nuTab1\').remove();\n $(\'#nuTab2\').click();\n $(\'#nuTab2\').remove();\n \n nuSetTitle($(\'#sfo_description\').val());\n \n}\n\n\nfunction nuFormColor(){\n\n var t = String($(\'#sfo_type\').val());\n\n var pb = \'previewbrowse\';\n var pe = \'previewedit\';\n\n var bb = \'bb_event\';\n var be = \'be_event\';\n var bs = \'bs_event\';\n var as = \'as_event\';\n var bd = \'bd_event\';\n var ad = \'ad_event\';\n \n if(t == \'browse\'){\n \n nuDisable(pe);\n\n nuDisable(be);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n\n }\n \n if(t == \'edit\'){\n \n nuDisable(pb);\n nuDisable(bb);\n \n }\n\n if(t == \'launch\'){\n \n nuDisable(pb);\n nuDisable(bb);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n\n }\n \n if(t == \'subform\'){\n \n nuDisable(pb);\n nuDisable(bb);\n nuDisable(be);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n nuDisable(\'sfo_javascript\');\n \n }\n\n if(nuFORM.getCurrent().record_id == \'nuuserhome\'){\n // nuDisable(\'sfo_javascript\');\n }\n \n var h = $(\'#sfo_type\').addClass(\'nuEdited\');\n var o = [];\n o[\'browse\'] = [0,1,2];\n o[\'edit\'] = [0,2];\n o[\'browseedit\'] = [0,1,2];\n o[\'launch\'] = [0,2];\n o[\'subform\'] = [0,1];\n \n $(\'#sfo_type\').removeClass();\n $(\'#sfo_type\').addClass(\'nu_\'+$(\'#sfo_type\').val());\n \n if(h){\n $(\'#sfo_type\').addClass(\'nuEdited\');\n }\n \n $(\"#sfo_type > option\").each(function() {\n $(this).addClass(\'nu_\'+this.value);\n });\n\n for(var i = 0 ; i < 7 ; i++){\n $(\'#nuTab\' + i).removeClass(\'nuRelatedTab\');\n }\n var t = o[$(\'#sfo_type\').val()];\n\n if(t !== undefined){\n \n for(var i = 0 ; i < t.length ; i++){\n $(\'#nuTab\' + t[i]).addClass(\'nuRelatedTab\'); \n }\n \n }\n \n}\n\nnuFormColor();\n\n$(\"[data-nu-column=\'0\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\ndefault_description();\n\nfunction nuEventList(){\n \n if($(\'sob_all_type\').val() == \'subform\'){\n return [\'onchange\',\'onadd\'];\n }else{\n return [\'onblur\',\'onchange\',\'onfocus\',\'onkeydown\'];\n }\n \n}\n\nfunction default_description(){\n \n var s = \'zzzzsys_browse_sf\';\n var r = nuSubformObject(s).rows.length - 1;\n var o = \'#\' + s + nuPad3(r) + \'sbr_title\';\n var d = \'Something\';\n\n $(o).val(d);\n\n}\n\n\n'),('nufile','browseedit','nufile','Stored Files','zzzzsys_file','zzzzsys_file_id','',150,3,'SELECT * FROM zzzzsys_file\nORDER BY sfi_code','\nnuSetNoSearchColumns([2,3]);\n\n$(\'[data-nu-column=\"0\"]\').each(function( index ) {\n\n var code = \'#nucell_\' + index + \'_\';\n window.nuImages[$(code + \'0\').text()] = $(code + \'2\').text();\n \n});\n\n\n\nif(nuFormType() == \'browse\'){\n nuShowBrowseImages()\n}else{\n nuShowFile();\n}\n\n\n\n\nfunction nuBeforeSave(){\n\n var f = $(\'#sfi_json_file\').val();\n \n if(f != \'\'){\n \n $(\'#sfi_json\')\n .val(f)\n .change();\n \n }\n \n return true;\n\n}\n\n\nfunction nuShowFile(){\n \n var j = $(\'#sfi_json\').val();\n \n nuEmbedObject(j, \'view_image\');\n \n}\n\n\nfunction nuShowBrowseImages(){\n\n $(\'[data-nu-column=\"0\"]\').each(function( index ) {\n \n var p = $(this).attr(\'id\');\n var r = String(p).split(\'_\')[1];\n var i = \"nucell_\" + r + \"_2\";\n var e = \"nucell_\" + r + \"_3\";\n var h = $(\'#\' + i).html();\n\n if(h != \'\' && h !== undefined){\n \n nuEmbedObject(h, e, 140, 140);\n\n }\n \n });\n\n}\n\n'),('nuselect','browseedit','nuselect','SQL Builder','zzzzsys_select','zzzzsys_select_id','',0,0,'SELECT * FROM zzzzsys_select \nWHERE (sse_system != 1 || sse_system IS NULL)\nORDER BY sse_description ASC\n\n','\nif(nuIsNewRecord()){\n $(\'#sse_edit\').val(0);\n}\n\n$(\"#sse_edit option[value=\'\']\").remove();\n\n$(\'#sse_sql\')\n.css(\'font-size\', 10)\n.addClass(\'sql\')\n.dblclick(function() {\n nuOpenAce(\'SQL\', this.id);\n});\n\n$(\'#label_sse_sql\').remove();\n\nnuSetSFCB();\n\nif(window.filter == \'justsql\'){\n\n var sid = String(nuFORM.getCurrent().record_id);\n var from = sid.substring(sid.length-2);\n var targ = \'#sfo_browse_sql\';\n\n $(\'#nuDeleteButton\').remove();\n $(\'#nuCloneButton\').remove();\n $(\'#sse_description\').val(sid);\n \n nuHide(\'sse_description\');\n \n if(nuFORM.getCurrent().record_id != -1){\n \n $(\'#nuSaveButton\').hide();\n \n if(from == \'BR\'){\n nuAddActionButton(\'SaveToTextarea\', \'Copy to Form Browse SQL\', \'nuCopySQL(\"sfo_browse_sql\")\');\n }\n \n if(from == \'SE\'){\n nuAddActionButton(\'SaveToTextarea\', \'Copy to Select Object SQL\', \'nuCopySQL(\"sob_select_sql\")\');\n }\n \n\n if(from == \'DI\'){\n nuAddActionButton(\'SaveToTextarea\', \'Copy to Display Object SQL\', \'nuCopySQL(\"sob_display_sql\")\');\n }\n \n }\n\n}\n\n\n\nnuSetTitle($(\'#sal_code\').val());\n\n$(\'#sse_sql\')\n.css({\n \'white-space\' : \'nowrap\',\n \'overflow-x\' : \'scroll\',\n})\n\nnuWhereClauses();\n\n\nfunction nuCopySQL(targ){\n \n var s = $(\'#sse_sql\').val();\n \n parent.$(\'#\' + targ).val(s).change();\n \n parent.$(\'#dialogClose\').click();\n\n}\n\n\nfunction nuTempPHP(){\n \n var p = [];\n \n p.push(\'\');\n p.push(\'$sql = \"\');\n p.push(\'\');\n p.push(\'CREATE TABLE #TABLE_ID#\');\n p.push($(\'#sse_sql\').val());\n p.push(\'\');\n p.push(\'\";\');\n p.push(\'\');\n p.push(\"nuRunQuery($sql);\");\n p.push(\'\');\n nuMessage(p);\n// $(\"#nuAlertDiv\").css(\'text-align\', \'left\')\n $(\"#nuMessageDiv\").css(\'text-align\', \'left\')\n\n}\n\nfunction nuBeforeSave(){\n \n $(\'#sqlframe\')[0].contentWindow.nuSQL.buildSQL();\n return true;\n \n}\n\n\n\n\nfunction nuWhereClauses(){\n\n $(\"[id$=\'ssc_type\']select\").each(function(index){\n \n var p = $(this).attr(\'data-nu-prefix\');\n var t = $(this).val();\n \n if(t == 2 || t == 3){\n \n if($(\'#\' + p + \'ssc_sort\').val() == \'\'){\n $(\'#\' + p + \'ssc_sort\').val(\'ASC\');\n }\n \n $(\'#\' + p + \'ssc_clause\').hide();\n $(\'#\' + p + \'ssc_sort\').show();\n \n }else{\n \n $(\'#\' + p + \'ssc_clause\').show();\n $(\'#\' + p + \'ssc_sort\').hide();\n \n }\n\n });\n\n}\n\n\nfunction nuWhereClausesold(){\n\n $(\"[id$=\'ssc_type\']select\").each(function(index){\n \n var p = $(this).attr(\'data-nu-prefix\');\n var t = $(this).val();\n \n if(t == 2 || t == 3){\n \n if($(\'#\' + p + \'ssc_sort\').val() == \'\'){\n $(\'#\' + p + \'ssc_sort\').val(\'ASC\');\n }\n \n $(\'#\' + p + \'ssc_clause\').hide();\n $(\'#\' + p + \'ssc_sort\').show();\n \n }else{\n \n $(\'#\' + p + \'ssc_clause\').show();\n $(\'#\' + p + \'ssc_sort\').hide();\n \n }\n\n });\n\n}\n\n\nfunction nuAddSQLTable(e){\n \n var s = $(\'#sqlframe\')[0].contentWindow.nuSQL;\n \n s.addBox(e.target.value);\n e.target.value = \'\';\n s.buildSQL();\n\n}\n\n\nfunction nuSFCB(){\n \n nuWhereClauses();\n $(\'#sqlframe\')[0].contentWindow.nuSQL.buildSQL();\n\n}\n\n\nfunction nuSetSFCB(){\n \n $(\'.nuSubformCheckbox.zzzzsys_select_clause\')\n .click(function(){\n nuSFCB();\n });\n \n}\n\n\n\nfunction nuResizeSQL(){\n\n if($(\'#sqlframe\').css(\'height\') == \'470px\'){\n $(\'#sqlframe\').css(\'height\', 180);\n }else{\n $(\'#sqlframe\').css(\'height\', 470);\n }\n \n}\n\n\n'),('nulaunchable','browse','nulaunchable','Launchable Forms','zzzzsys_form','zzzzsys_form_id','',0,0,'SELECT * FROM zzzzsys_form\nWHERE sfo_type IN (\'edit\', \'browseedit\', \'launch\')\nAND (\n SUBSTRING(zzzzsys_form_id, 1, 2) != \'nu\'\n OR zzzzsys_form_id = \'nublank\'\n OR zzzzsys_form_id = \'nuuserhome\'\n )\nORDER BY sfo_code\n','$(\'#sfo_breadcrumb_title\').addClass(\'sql\');\n$(\'#sfo_browse_sql\').addClass(\'sql\');\n$(\'#sfo_javascript\').addClass(\'js\');\n\nnuSetTitle($(\'#sfo_table\').val());\n\n$(\'.js\').dblclick(function() {\n nuOpenAce(\'Javascript\', this.id);\n});\n\n$(\'.sql\').dblclick(function() {\n nuOpenAce(\'SQL\', this.id);\n});\n\n$(\'.html\').dblclick(function() {\n nuOpenAce(\'HTML\', this.id);\n});\n\n$(\'.php\').dblclick(function() {\n nuOpenAce(\'PHP\', this.id);\n});\n\nif(window.filter == \'justjs\'){\n \n $(\'#nuDeleteButton\').remove();\n $(\'#nuCloneButton\').remove();\n $(\'#nuTab0\').remove();\n $(\'#nuTab1\').remove();\n $(\'#nuTab2\').click();\n $(\'#nuTab2\').remove();\n \n nuSetTitle($(\'#sfo_description\').val());\n \n}\n\n\n\nfunction nuFormColor(){\n\n var t = String($(\'#sfo_type\').val());\n\n var pb = \'previewbrowse\';\n var pe = \'previewedit\';\n\n var bb = \'bb_event\';\n var be = \'be_event\';\n var bs = \'bs_event\';\n var as = \'as_event\';\n var bd = \'bd_event\';\n var ad = \'ad_event\';\n \n if(t == \'browse\'){\n \n nuDisable(pe);\n\n nuDisable(be);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n\n }\n \n if(t == \'edit\'){\n \n nuDisable(pb);\n nuDisable(bb);\n \n }\n\n if(t == \'launch\'){\n \n nuDisable(pb);\n nuDisable(bb);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n\n }\n \n if(t == \'subform\'){\n \n nuDisable(pb);\n nuDisable(bb);\n nuDisable(be);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n nuDisable(\'sfo_javascript\');\n \n }\n\n var h = $(\'#sfo_type\').addClass(\'nuEdited\');\n var o = [];\n o[\'browse\'] = [0,1,2];\n o[\'edit\'] = [0,2];\n o[\'browseedit\'] = [0,1,2];\n o[\'launch\'] = [0,2];\n o[\'subform\'] = [0,1];\n \n $(\'#sfo_type\').removeClass();\n $(\'#sfo_type\').addClass(\'nu_\'+$(\'#sfo_type\').val());\n \n if(h){\n $(\'#sfo_type\').addClass(\'nuEdited\');\n }\n \n $(\"#sfo_type > option\").each(function() {\n $(this).addClass(\'nu_\'+this.value);\n });\n\n for(var i = 0 ; i < 7 ; i++){\n $(\'#nuTab\' + i).removeClass(\'nuRelatedTab\');\n }\n var t = o[$(\'#sfo_type\').val()];\n\n if(t !== undefined){\n \n for(var i = 0 ; i < t.length ; i++){\n $(\'#nuTab\' + t[i]).addClass(\'nuRelatedTab\'); \n }\n \n }\n \n}\n\nnuFormColor();\n\n//nuBuildSubformArray(\'zzzzsys_tab_sf\');\n//nuBuildSubformArray(\'zzzzsys_browse_sf\');\n\n$(\"[data-nu-column=\'nucolumn000\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n\n\nfunction nuEventList(){\n \n if($(\'sob_all_type\').val() == \'subform\'){\n return [\'onchange\',\'onadd\'];\n }else{\n return [\'onblur\',\'onchange\',\'onfocus\',\'onkeydown\'];\n }\n \n}\n\n\n'),('nuclause','subform','nuclause','Select Clauses','zzzzsys_select_clause','zzzzsys_select_clause_id','',0,0,'SELECT * FROM zzzzsys_select_clause\nORDER BY ssc_type, ssc_order',''),('nubuildtable','browse','nubuildtable','PHP or SELECT or TABLE','zzzzsys_report_data','id','nuselect',0,0,'SELECT * FROM zzzzsys_report_data',''),('nuuserhome','launch','nuuserhome','Home','','','',0,0,'',''),('nufrlaunch','launch','nufrlaunch','Fast Report','','','',0,0,'SELECT * FROM Launch Form 0','\n$(\'#wrdaddable\').css({\'font-size\' : 14, \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\n$(\'#frwrd\').css({\'font-size\' : 14, \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\n$(\'#nufr\').css(\'text-align\', \'left\').css(\'padding\', \'3px\');\n$(\'#list\').addClass(\'nuScroll\').removeClass(\'nuReadonly\');\n\n$(\'.nuActionButton\').hide();\nnuAddActionButton(\'nuRunPHPHidden\', \'Build Fast Report\', \'nuRunPHPHidden(\"RUNFR\")\');\n\n\nfunction nuAddReportField(t){\n\n var f = nuPad3($(\"[data-nu-label=\'Field Name\']\").length - 1);\n\n $(\'#fast_report_sf\' + f + \'field\').val($(t).html()).change();\n $(\'#fast_report_sf\' + f + \'width\').val(100).change();\n $(\'#fast_report_sf\' + f + \'sum\').val(\'no\').change();\n $(\'#fast_report_sf\' + f + \'title\').val($(t).html()).change().select();\n \n}\n\n\nfunction nuBeforeSave(){\n \n if($(\'#table\').val() == \'\'){\n \n nuMessage([\'<b>Table Data</b>\', \'Cannot be left blank...\'])\n return false;\n \n }\n \n \n if($(\'#orderby\').val() == \'\'){\n \n nuMessage([\'<b>Order By</b>\', \'Cannot be left blank...\'])\n return false;\n \n }\n \n nuBuildFastReport();\n \n return true;\n \n}\n\n'),('nufastreportobjects','subform','nufastreportobjects','Fast Report Objects','zzzzsys_debug','zzzzsys_debug_id','',0,0,'SELECT count(*) FROM zzzzsys_debug',''),('nusamplesubformform','launch','nusamplesubformform','Sample Subform Form','','','',0,0,'SELECT * FROM Launch Form 0',''),('nulaunchform','edit','nulaunchform','nuBuilder non-System Form','zzzzsys_form','zzzzsys_form_id','',0,0,'SELECT * FROM zzzzsys_form\nWHERE sfo_type != \'subform\' AND zzzzsys_form_id != \'nuhome\'\nORDER BY sfo_code\n','$(\"[data-nu-column=\'0\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\n'),('nutablookup','browse','nutablookup','Form Tab Lookup','zzzzsys_tab','zzzzsys_tab_id','',0,0,'SELECT * FROM zzzzsys_tab\nJOIN zzzzsys_form ON zzzzsys_form_id = syt_zzzzsys_form_id\nJOIN #TABLE_ID# ON zzzzsys_form_id = theid\nORDER BY syt_order','\n$(\"[data-nu-column=\'3\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\n');269 INSERT INTO `zzzzsys_form` VALUES ('nuhome','launch','nuhome','Home','','','',0,0,'','\n\nnuAttachButtonImage(\'run_php\',\'RP\');\nnuAttachButtonImage(\'run_setup\',\'SET\');\nnuAttachButtonImage(\'form_button\',\'F\');\nnuAttachButtonImage(\'run_lang\',\'TR\');\nnuAttachButtonImage(\'run_report\',\'RR\');\nnuAttachButtonImage(\'user_home\',\'UH\');\nnuAttachButtonImage(\'run_user\',\'U\');\nnuAttachButtonImage(\'run_file\',\'FILE\');\nnuAttachButtonImage(\'edit_php\',\'P\');\nnuAttachButtonImage(\'edit_report\',\'R\');\nnuAttachButtonImage(\'run_access\',\'KEY\');\nnuAttachButtonImage(\'run_fast_form\',\'FF\');\nnuAttachButtonImage(\'run_format\',\'FMT\');\nnuAttachButtonImage(\'run_fast_report\',\'FR\');\nnuAttachButtonImage(\'object_button\',\'OB\');\nnuAttachButtonImage(\'run_sql\',\'SQL\');\nnuAttachButtonImage(\'run_chart\',\'CH\');\nnuAttachButtonImage(\'open_database\',\'DB\');\nnuAttachButtonImage(\'system_update\',\'SU\');\n\n\n$(\'.nuActionButton\').hide();\n\n$(\'#user_home\').addClass(\'nuUserHomeButton\');\n\n$(\'#open_database\')\n.attr(\'title\', \'PHPMyAdmin\')\n//.click(function(){\n// window.open(\'nupmalogin.php\');\n//});\n\n\n$(\'#run_php\')\n.css(\'text-align\', \'left\')\n.css(\'padding\', \'0px 0px 0px 35px\')\n.css(\'background-size\', \'30px\')\n.css(\'background-repeat\', \'no-repeat\');\n\nnuGetStartingTab();\n'),('nubrowse','subform','nubrowse','Browse Columns','zzzzsys_browse','zzzzsys_browse_id','',0,5,'SELECT * FROM zzzzsys_browse\nORDER BY sbr_order\n','$(\'#nuSearchButton\').remove();\n$(\'#nuSearchField\').remove();\n$(\'#nuPrintButton\').remove();\n\nnuSetTitle($(\'#sbr_title\').val());\n\nvar pid = parent.nuFORM.getCurrent().record_id;\n\nif(nuFORM.getCurrent().record_id == -1){\n $(\'#sbr_zzzzsys_form_id\').val(pid).change();\n}\n'),('nutab','browse','nutab','Form Tab','zzzzsys_tab','zzzzsys_tab_id','',0,0,'SELECT * FROM zzzzsys_tab\nJOIN zzzzsys_form ON zzzzsys_form_id = syt_zzzzsys_form_id\nORDER BY syt_order','\n$(\"[data-nu-column=\'3\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n'),('nuobject','browseedit','nuobject','Object','zzzzsys_object','zzzzsys_object_id','',0,0,'SELECT * FROM zzzzsys_object\nJOIN #TABLE_ID# ON zzzzsys_object_id = theid\nJOIN zzzzsys_tab ON zzzzsys_tab_id = sob_all_zzzzsys_tab_id\nJOIN zzzzsys_form ON zzzzsys_form_id = syt_zzzzsys_form_id \n','\n$(\'#add_total\').css(\'overflow-y\',\'scroll\').css(\'background-color\',\'#ebebeb\');\n\n$(\'#zzzzsys_event_sfsev_javascript\').attr(\'id\',\'jsfuntitle\');\n$(\'#sob_calc_formula\').addClass(\'nuCalculatorCurrency\').css(\'font-size\', 12);\n$(\'#sob_all_display_condition\').addClass(\'sql\');\n$(\'#sob_all_default_value_sql\').addClass(\'sql\');\n$(\'#sob_display_sql\').addClass(\'sql\');\n$(\'#sob_select_sql\').addClass(\'sql\');\n$(\'#sob_lookup_php\').addClass(\'php\');\n$(\'#sob_lookup_javascript\').addClass(\'js\');\n$(\'#sob_input_javascript\').addClass(\'js\');\n$(\'#sob_html_javascript\').addClass(\'js\');\n$(\'#sob_html_code\').addClass(\'html\');\n$(\"[id$=\'sev_javascript\']\").addClass(\'js\');\n$(\"#title_zzzzsys_event_sfsev_javascript\").removeClass(\'js\');\n\n$(\'#nuTab8\').click(function(){nuTestChart();});\n\nnuAttachButtonImage(\'icon\', \'LUJS\');\nnuAttachButtonImage(\'ab_event\',\'AB\');\nnuAttachButtonImage(\'di_sql\',\'SQL\');\nnuAttachButtonImage(\'se_sql\',\'SQL\');\n\n$(\'#sob_lookup_javascript\')\n.css(\'padding\', \'3px 3px 3px 3px\')\n\n$(\'#viewflowchart\')\n.css(\'padding\', \'46px 0px 0px 3px\')\n.css(\'text-align\', \'left\')\n.css(\'background-size\', \'75px\')\n\n\nif($(\'#zzzzsys_event_sf000sev_event\').val() != \'\'){\n $(\'#nuTab10\').css(\'font-weight\', \'bold\');\n}\n\n\nif(nuFORM.getCurrent().record_id == -1){\n \n $(\'#sob_all_top\').val(0).change();\n $(\'#sob_all_left\').val(0).change();\n $(\'#sob_all_height\').val(0).change();\n $(\'#sob_all_width\').val(0).change();\n $(\'#sob_all_validate\').val(0).change();\n $(\'#sob_all_access\').val(0).change();\n $(\'#sob_all_align\').val(\'left\').change();\n $(\'#sob_all_cloneable\').val(1).change();\n \n nuHasNotBeenEdited();\n}\n\nvar v = $(\'#sob_input_type\').val();\n\nif(nuFormType() == \'edit\'){\n \n nuShowInputJS(v);\n nuHideCalcObjects();\n nuSetTitle($(\'#sob_all_id\').val());\n nuPopulateHTML();\n \n}\n\nvar filter = String(window.filter).split(\'|\');\n\nif(filter[0] == \'fromfastform\'){\n \n $(\'#nuDeleteButton\').remove();\n $(\'#nuCloneButton\').remove();\n $(\'#nuSaveButton\').remove();\n $(\'#sob_all_id\').val(filter[1]).addClass(\'nuHighlight\');\n $(\'#sob_all_label\').val(filter[2]).addClass(\'nuHighlight\');\n \n}\n\n\n\n$(\'.js\').dblclick(function() {nuOpenAce(\'Javascript\', this.id);});\n$(\'.sql\').dblclick(function() {nuOpenAce(\'SQL\', this.id);});\n$(\'.html\').dblclick(function() {nuOpenAce(\'HTML\', this.id);});\n$(\'.php\').dblclick(function() {nuOpenAce(\'PHP\', this.id);});\n\nnuObjectColor();\n\n$(\"[data-nu-column=\'0\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\nnuHide(\'sob_input_format\');\n\nvar sit = $(\'#sob_input_type\').val();\n\nif(sit == \'nuDate\' || sit == \'nuNumber\'){\n nuShow(\'sob_input_format\');\n}\n\nif(sit == \'nuScroll\'){\n nuShow(\'sob_input_javascript\');\n}else{\n nuHide(\'sob_input_javascript\');\n}\n\nnuGetStartingTab();\n\nfunction nuTestChart(){\n \n var g = $(\'#sob_html_chart_type\').val();\n var t = $(\'#sob_all_type\').val();\n \n if(g == \'\' || t != \'html\'){$(\'#google_chart\').html(\'\');return;}\n \n var c = \'ComboChart\';\n var t = $(\'#sob_html_title\').val();\n var x = $(\'#sob_html_vertical_label\').val();\n var y = $(\'#sob_html_horizontal_label\').val();\n var l = \'bars\';\n var s = false;\n var a = [\n [\'Month\', \'Shane\', \'Dave\', \'Adam\', \'Paul\', \'Chris\'],\n [\'2004\', 100, 200, 300, 400, 500],\n [\'2005\', 165, 238, 322, 498, 550],\n [\'2006\', 165, 938, 522, 998, 450],\n [\'2007\', 135, 1120, 599, 1268, 288]\n ];\n \n if(g == \'p\') {c = \'PieChart\';}\n if(g == \'l\') {l = \'lines\';}\n if(g == \'bh\') {c = \'BarChart\';}\n if(g == \'bhs\') {c = \'BarChart\';}\n if(g == \'bs\') {s = true;}\n if(g == \'bhs\') {s = true;}\n\n nuChart(\'google_chart\', c, a, t, x, y, l, s);\n\n}\n\n\n\n\n\nfunction nuObjectColor(){\n \n $(\'.nuValidate\').removeClass(\'nuValidate\');\n\n var e = $(\'#sob_all_type\').hasClass(\'nuEdited\');\n var o = [];\n\n o[\'run\'] = 1;\n o[\'display\'] = 2;\n o[\'select\'] = 3;\n o[\'lookup\'] = 4;\n o[\'subform\'] = 5;\n o[\'image\'] = 6;\n o[\'input\'] = 7;\n o[\'html\'] = 8;\n o[\'calc\'] = 9;\n \n\n $(\'#sob_all_type\').removeClass();\n \n if(e){ //-- keep class if edited\n $(\'#sob_all_type\').addClass(\'nuEdited\');\n }\n \n $(\'#sob_all_type\').addClass(\'nu_\'+$(\'#sob_all_type\').val());\n \n $(\"#sob_all_type > option\").each(function() {\n $(this).addClass(\'nu_\'+this.value);\n });\n \n $(\"#sob_input_type > option\").each(function() {\n $(this).addClass(\'input_\'+this.value);\n });\n \n var t = o[$(\'#sob_all_type\').val()];\n \n $(\"[id^=\'nuTab\']\").removeClass(\'nuRelatedTab\');\n \n for(var i = 1 ; i < o.length ; i++){\n $(\'#nuTab\' + i).removeClass(\'nuRelatedTab\');\n }\n \n $(\'#nuTab0\').addClass(\'nuRelatedTab\');\n $(\'#nuTab\' + t).addClass(\'nuRelatedTab\');\n \n} \n\n\nfunction nuAddToFormula(e){\n \n var fld = e.target.innerHTML;\n var frm = $(\'#sob_calc_formula\').val();\n \n if(fld == \'Clear\'){\n \n $(\'#sob_calc_formula\')\n .val(\'\')\n .addClass(\'nuEdited\');\n return;\n \n }\n\n $(\'#sob_calc_formula\')\n .addClass(\'nuEdited\')\n .val(frm + fld);\n \n nuHasBeenEdited();\n \n}\n\nfunction nuShowInputJS(t){\n\n nuHide(\'sob_input_format\');\n nuHide(\'sob_input_count\');\n nuHide(\'sob_input_javascript\');\n \n if(t == \'nuScroll\'){\n nuShow(\'sob_input_javascript\');\n }\n\n if(t == \'nuAutoNumber\'){\n \n nuShow(\'sob_input_count\');\n $(\'#sob_input_javascript\').val(\'\').change();\n \n }\n\n if(t == \'nuDate\' || t == \'nuNumber\'){\n \n nuShow(\'sob_input_format\');\n\n $(\'#sob_input_format\').children().each(function(index) {\n \n $(this).show();\n \n if($(this).val()[0] == \'D\' && t != \'nuDate\') {$(this).hide();}\n if($(this).val()[0] == \'N\' && t != \'nuNumber\') {$(this).hide();}\n \n });\n \n }\n \n}\n\n\nfunction nuHideCalcObjects(){\n\n var f = $(\'#sob_all_zzzzsys_form_id\').val();\n\n $(\'#add_total\').children().each(function(index) {\n\n\n if($(this).val() != f){\n $(this).hide();\n }\n if($(this).text() == $(\'#sob_all_id\').val()){\n $(this).hide();\n }\n\n });\n \n}\n\n\nfunction nuAddCalcObject(t){\n \n var f = $(\'#sob_calc_formula\').val();\n var i = $(t).attr(\'data-nu-ids\');\n var s = f + \"nuTotal(\'\" + i + \"\')\";\n \n if(i == \'\'){return;}\n\n $(\'#sob_calc_formula\')\n .addClass(\'nuEdited\')\n .val(s);\n\n $(\'#add_total\').val(\'\');\n \n nuHasBeenEdited();\n \n}\n\n\nfunction nuPopulateHTML(){\n\n var o = nuCalcObjects();\n var a = [];\n\n for(var i = 0 ; i < o.length ; i++){\n \n var ids = String(o[i].ids);\n var ty = o[i].type;\n var id = String(o[i].ids).split(\'.\');\n var sp = \' \';\n\n if(id.length == 1){\n a.push(\'<tr><td><div title=\"\'+ty+\'\" style=\"overflow:hidden;width:314px;text-align:left;padding:2px\" onclick=\"nuAddCalcObject(this);\" class=\"nuCalculatorButton nu_\' + o[i].type + \'\" data-nu-ids=\"\' + ids + \'\">\' + ids + \'</div></td></tr>\');\n }else{\n \n var h = \'<span title=\"subform\" class=\"nu_subform\">\' + id[0] + \'</span>.<span title=\"\'+ty+\'\" class=\"nu_input\" style=\"padding:7px 5px 7px 5px\">\' + id[1] + sp.repeat(200) + \'</span>\';\n a.push(\'<tr><td><div style=\"overflow:hidden;width:314px;text-align:left;padding:2px\" onclick=\"nuAddCalcObject(this);\" class=\"nuCalculatorButton nu_subform\" data-nu-ids=\"\' + ids + \'\">\' + h + \'</div></td></tr>\');\n \n }\n \n }\n\n $(\'#add_total\').html(\'<table>\' + a.join(\'\') + \'</table>\');\n\n}\n\n\n'),('nufflaunch','launch','nufflaunch','Form Builder','','','',0,0,'SELECT * FROM zzzzsys_form','\n$(\"[id$=\'ff_browse\']\").hide();\n$(\'#title_obj_sfff_browse\').show();\n$(\'#ffwrd\').css({\'font-size\' : 14, \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\n$(\'#wrdaddable\').css({\'font-size\' : 14, \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\n$(\'.nuActionButton\').hide();\n$(\'#nuTab0\').remove();\n$(\'#fastform_type\').focus();\n\nnuSetFK();\n\nnuAddActionButton(\'nuRunPHPHidden\', \'Build Fast Form\', \'nuRunPHPHidden(\"RUNFF\")\');\n\n$(\"#fastform_type > option\").each(function() {\n $(this).addClass(\'nu_\' + this.value);\n});\n\nfunction nuFormColor(){\n\n var t = String($(\'#fastform_type\').val());\n \n $(\'#fastform_type\').removeClass();\n $(\'#fastform_type\').addClass(\'nu_\'+$(\'#fastform_type\').val());\n \n if(t == \'launch\'){\n \n $(\'#fastform_table\').hide();\n $(\'#label_fastform_table\').hide();\n\n }else{\n $(\'#fastform_table\').show();\n $(\'#label_fastform_table\').show();\n }\n \n \n if(t == \'browse\' || t == \'browseedit\'){\n \n $(\"[id$=\'ff_browse\']:checkbox\").each(function(index){\n \n var fld = \'#\' + this.id.substr(0, 6) + nuPad3(index + 1) + \'ff_field\';\n\n if($(fld).length == 1){\n $(this).show();\n }\n \n });\n \n }else{\n $(\"[id$=\'ff_browse\']:checkbox\").hide();\n }\n\n nuSetFK();\n\n}\n\n\nfunction nuSetFFTable(){\n \n var v = $(\'#fastform_table\').val();\n\n if(nuFORM.getTables().indexOf(v) == -1){\n \n $(\"[data-nu-field=\'ff_field\']\")\n .removeClass(\'input_nuScroll\')\n .removeClass(\'nuScroll\');\n\n }else{\n \n $(\"[data-nu-field=\'ff_field\']\")\n .addClass(\'input_nuScroll\')\n .addClass(\'nuScroll\');\n\n }\n\n $(\"#title_obj_sfff_field\")\n .removeClass(\'input_nuScroll\')\n .removeClass(\'nuScroll\');\n \n var l = $(\"[id$=\'ff_browse\']\").length-2;\n \n $(\'#obj_sf\' + nuPad3(l) + \'ff_browse\').hide();\n\n nuSetFK();\n \n}\n\n\nfunction nuSetFK(){\n \n $(\'#fastform_fk\').hide();\n $(\'#label_fastform_fk\').hide();\n\n var v = $(\'#fastform_table\').val();\n\n if(v != \'\' && nuFORM.getTables().indexOf(v) == -1 && $(\'#fastform_type\').val() == \'subform\'){\n \n $(\'#fastform_fk\').show().focus();\n $(\'#label_fastform_fk\').show();\n\n }\n \n}\n\n\nfunction nuShowFFO(e){\n \n var t = $(\'#\' + e.target.id).attr(\'data-nu-prefix\');\n var i = $(\'#\' + t + \'ff_id\').val();\n var l = $(\'#\' + t + \'ff_label\').val();\n var f = $(\'#\' + t + \'ff_field\').val();\n var fff = \'fromfastform|\' + f + \'|\' + l;\n\n nuPopup(\'nuobject\', i, fff);\n\n}\n\nfunction nuFocusFFObject(e){\n\n var p = $(e.target).attr(\'data-nu-prefix\');\n \n if($(\'#\' + p + \'ff_id\').val() == \'\'){\n $(\'#fastform_table\').focus();\n }\n \n}\n\n\n\n\nfunction nuMoveFF(){\n \n var i = $(\'#new_id\').val();\n\n nuPopup(i, -2);\n\n}\n\nfunction nuCreateSQLPrefix(){\n \n var p = $(\'#fastform_prefix\');\n var t = $(\'#fastform_table\');\n \n p.val(String(t.val()).substr(0, 3));\n \n}\n\n\nfunction nuBeforeSave(){\n \n var table = $(\'#fastform_table\').val();\n var type = String($(\'#fastform_type\').val());\n var browse = type.substr(0, 6) == \'browse\';\n\n if(table == \'\' && type != \'launch\'){\n \n nuMessage([\'Table Name cannot be left blank..\']);\n \n return false;\n\n }\n \n if(type == \'\'){\n \n nuMessage([\'Must select <b>Form Type</b>...\']);\n \n return false;\n\n }\n \n if(browse){\n \n if($(\"[data-nu-field=\'ff_browse\']:checked\").length == 0){\n \n nuMessage([\'At least 1 Browse needs to be checked..\']);\n \n return false;\n \n }\n \n }\n\n var v = $(\'#fastform_table\').val();\n var t = $(\'#fastform_type\').val();\n var f = $(\'#fastform_fk\').val();\n\n if(v != \'\' && nuFORM.getTables().indexOf(v) == -1 && t == \'subform\' && f == \'\'){\n \n nuMessage([\'<b>Foreign Key Field Name</b> cannot be left blank...\']);\n \n return false;\n\n }\n \n var a = [];\n \n for(var i = 0 ; i < nuSubformObject(\'obj_sf\').rows.length ; i++){\n a.push(nuSubformObject(\'obj_sf\').rows[i][2]);\n }\n\n\n if(f != \'\' && a.indexOf(f) > -1 && t == \'subform\'){\n \n nuMessage([\'<b>Foreign Key Field Name</b> is already used...\']);\n \n return false;\n\n }\n \n\n\n\n\n \n \n if(!nuValidColumn()){\n return false;\n }\n\n return true;\n \n}\n\n\nfunction nuValidColumn(){\n \n var tn = $(\'#fastform_table\').val();\n \n if(nuFORM.getTables().indexOf(tn) == -1){return true;}\n \n var sf = nuSubformObject(\'obj_sf\');\n \n for(var i = 0 ; i < sf.rows.length ; i++){\n \n if(sf.rows[i][4] == 1 && sf.deleted[i] != 1){ //-- ticked column checkbox\n \n var valid = nuFORM.tableSchema[tn].names.indexOf(sf.rows[i][2]) //-- fieldname\n \n if(valid == -1){\n \n nuMessage([\'Invalid column name <b>\' + sf.rows[i][2] + \'</b>\']);\n \n return false;\n \n }\n }\n \n }\n \n return true;\n\n}\n\n\nfunction nuSelectFFObjects(e){\n \n var classes = e.target.className.split(\' \');\n var id = e.target.id;\n var rowno = nuPad3($(\"[id^=\'obj_sf\'][id$=\'ff_label\']\", document).length-1);\n var rowsuf = nuPad2(rowno);\n var sfrow = \'#obj_sf\' + rowno;\n var h = String(e.target.innerHTML).split(\':\');\n \n $(sfrow + \'ff_label\')\n .val(h[h.length-1] + rowsuf)\n .addClass(classes[1])\n .change();\n\n $(sfrow + \'ff_field\')\n .val(\'field\' + rowsuf)\n .change();\n\n $(sfrow + \'ff_id\')\n .val(id)\n .change();\n \n var nb = [\'Word\', \'Subform\', \'Image\', \'HTML\', \'Display\', \'Input:file\', \'Input:button\', \'Select:multiselect\'].indexOf(e.target.innerHTML); \n\n if(nb == -1){\n $(sfrow + \'ff_browse\').show();\n }else{\n $(sfrow + \'ff_browse\').remove();\n }\n \n $(\'#fastform_type\').change();\n\n}\n\n\n\n'),('nuevent','edit','nuevent','Object Events','zzzzsys_event','zzzzsys_event_id','',0,0,'SELECT * FROM zzzzsys_event',''),('nuaccess','browseedit','nuaccess','Access Levels','zzzzsys_access','zzzzsys_access_id','',0,0,'SELECT * FROM zzzzsys_access\nORDER BY sal_code\n','nuSetTitle($(\'#sal_code\').val());'),('nunonsystemform','edit','nunonsystemform','nuBuilder non-System Form','zzzzsys_form','zzzzsys_form_id','',0,0,'SELECT * FROM zzzzsys_form\nWHERE ((zzzzsys_form_id NOT LIKE \'nu%\' AND sfo_type != \'subform\')\nOR zzzzsys_form_id IN (\'nuaccess\', \'nuuser\', \'nulaunchdates\', \'nutranslate\', \'nupassword\', \'nufile\', \'nuuserhome\', \'nublank\', \'nurunreport\'))\nORDER BY sfo_code','$(\"[data-nu-column=\'0\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\n'),('nuaccessforms','edit','nuaccessforms','Accessible Forms','zzzzsys_access_form','zzzzsys_access_form_id','',0,0,'SELECT * FROM zzzzsys_access_form\nLEFT JOIN zzzzsys_form ON zzzzsys_form_id = slf_zzzzsys_form_id\nORDER BY sfo_code\n',''),('nuuser','browseedit','nuuser','User','zzzzsys_user','zzzzsys_user_id','',0,15,'SELECT * \nFROM zzzzsys_user \nLEFT JOIN zzzzsys_access ON zzzzsys_access_id = sus_zzzzsys_access_id\nORDER BY sus_name',''),('nubuildreport','browseedit','nubuildreport','Build Report','zzzzsys_report','zzzzsys_report_id','',0,0,'SELECT * FROM zzzzsys_report\nLEFT JOIN zzzzsys_form ON zzzzsys_form_id = sre_zzzzsys_form_id','\n$(\'#sre_layout\').addClass(\'nuEdited\'); \n\nnuAttachButtonImage(\'open_builder\',\'RD\');\n\n\nfunction nuPickTableType(){\n \n var i = $(\'#sre_zzzzsys_php_id\').val();\n \n var f = \'\';\n var r = \'\';\n \n if(i.substr(0,10) == \'PROCEDURE:\'){\n \n f = \'nuphp\';\n r = i.substr(10);\n \n }\n \n if(i == \'\'){\n \n nuMessage([nuTranslate(\'Table selected must be an SQL or Procedure\')]);\n return;\n\n }\n \n if(i.substr(0,6) == \'TABLE:\'){\n \n nuMessage(nuTranslate([\'To edit a table go to the Database Button\']));\n return;\n\n }\n \n if(i.substr(0,4) == \'SQL:\'){\n \n f = \'nuselect\';\n r = i.substr(4);\n\n }\n \n nuPopup(f,r);\n \n}\n'),('nuphp','browseedit','nuphp','Build Procedure','zzzzsys_php','zzzzsys_php_id','',0,0,'SELECT * FROM zzzzsys_php\nLEFT JOIN zzzzsys_form ON zzzzsys_form_id = sph_zzzzsys_form_id\nWHERE (sph_system != \'1\' || sph_system IS NULL)\nORDER BY sph_code\n','\nwindow.nuImages = parent.nuImages;\n\n$(\'#sph_php\')\n.addClass(\'php\')\n.dblclick(function() {\n nuOpenAce(\'PHP\', this.id);\n})\n\n\nwindow.nuHelp = \'Procedures\';\n\nif(window.filter == \'justphp\'){\n\n nuHelp = \'Functions\';\n var ev = [];\n ev[\'BB\'] = \'Before Browse\';\n ev[\'BE\'] = \'Before Edit\';\n ev[\'BS\'] = \'Before Save\';\n ev[\'AS\'] = \'After Save\';\n ev[\'BD\'] = \'Before Delete\';\n ev[\'AD\'] = \'After Delete\';\n ev[\'AB\'] = \'After Browse\';\n \n var suf = nuFORM.getCurrent().record_id.substr(-2);\n var e = ev[suf];\n var f = $(\'#sfo_description\', window.parent.document).val();\n\n if(e == \'After Browse\'){\n var f = $(\'#sob_all_label\', window.parent.document).val();\n }\n\n nuAttachButtonImage(\'icon\', suf);\n \n $(\'#sph_php\')\n .css(\'padding\', \'3px 3px 3px 3px\')\n .css(\'top\', \'40px\')\n .css(\'height\', \'200px\')\n .css(\'left\', \'90px\')\n .focus()\n\n \n $(\'#wiki\')\n .css(\'left\', \'670px\')\n\n $(\'#nu_bc_0\').html(\'<b>\' + e + \'</b> for : \' + f);\n $(\'#sph_code\').val(nuFORM.getCurrent().record_id).change();\n $(\'#sph_description\').val(\'System PHP\').change();\n $(\'#sph_system\').val(\'1\').change();\n $(\'#label_sph_php\').css(\'top\', \'40px\').css(\'left\', \'20px\');\n $(\'.nuSaveButtonEdited\').removeClass(\'nuSaveButtonEdited\');\n \n nuHide(\'sph_code\');\n nuHide(\'sph_description\');\n nuHide(\'sph_zzzzsys_form_id\');\n nuHide(\'sph_group\');\n nuHide(\'sph_system\');\n nuHide(\'sph_run\');\n\n nuSetTitle(e);\n \n}else{\n nuSetTitle($(\'#sph_code\').val());\n}\n\nnuHasNotBeenEdited();\n\n\n'),('nublank','launch','nublank','Blank','','','',0,0,'','\nnuSetTitle(nuFORM.getCurrent().run_description);\n'),('nuaccessgroup','subform','nuaccessgroup','Groups Access Level','zzzzsys_user_group_access_level','zzzzsys_user_group_access_level_id','',0,0,'SELECT * FROM zzzzsys_user_group_access_level',''),('nurunlist','browse','nurunlist','Run Form, Report or Procedure','zzzzsys_run_list','id','',0,0,'SELECT * FROM zzzzsys_run_list','\n$(\"[data-nu-column=\'nucolumn000\']\").each(function() {\n\n $(this).addClass(\'nu_\'+this.innerHTML);\n\n});'),('nudebug','browseedit','nudebug','nuDebug Entries','zzzzsys_debug','zzzzsys_debug_id','',21,15,'SELECT * FROM zzzzsys_debug\nORDER BY zzzzsys_debug_id DESC','\n$(\'#deb_message\')\n .css(\'font-size\', 10)\n .css(\'background-color\', \'#FFEEA6\')\n .prop(\'readonly\', true)\n .dblclick(function() {\n nuOpenAce(\'Text\', this.id);\n });\n\n\n\n\n\n$(\'#delete_option\').val(0);\n$(\'#nuAddButton\').remove();\n$(\'#nuOptions\').remove();\n\nvar mess = String($(\'#deb_message\').val());\nvar i = mess.indexOf(\'<br>\');\nvar m = mess.substr(i + 6);\nvar t = mess.substr(0,i);\n\nnuSetTitle(mess.substr(0, i))\n\n$(\'#nuTab0\').remove();\n\n$(\'#nuBreadcrumb1\')\n.css(\'text-align\', \'center\')\n.css(\'width\', \'95%\')\n.css(\'color\', \'black\')\n.css(\'padding\', \'5px\')\n.html(t + \' :: \' + nuWhen($(\'#deb_added\').val()))\n.appendTo(\"#nuTabHolder\");\n\n$(\'#deb_message\').val(m);\n\n\n$(\"[data-nu-column=\'1\']\").each(function( index ) {\n \n if($(this).html().trim() != \'\'){\n \n var nunow = Date.now();\n var nuhtm = nuWhen(Number($(this).html()));\n \n $(this).html(nuhtm);\n \n }\n \n});\n\nif(nuFORM.getCurrent().record_id != \'\'){\n\n $(\'.nuActionButton\').remove();\n nuAddActionButton(\'Delete\');\n nuAddActionButton(\'DeleteAll\',\'Delete All\', \'nuDeleteAllAction()\');\n\n}else{\n nuAddActionButton(\'DeleteAll\',\'Delete All\', \'nuDeleteAllAction()\');\n}\n\n'),('nuaccessreport','browseedit','nuaccessreport','Access To Procedures','zzzzsys_access_php','zzzzsys_access_php_id','',0,0,'SELECT * \nFROM zzzzsys_access_php\nJOIN zzzzsys_php ON zzzzsys_php_id = slp_zzzzsys_php_id\nORDER BY sph_code',''),('nuaccesslevelreport','browseedit','nuaccesslevelreport','Access To Report','zzzzsys_access_report','zzzzsys_access_report_id','',0,0,'SELECT * \nFROM zzzzsys_access_report\nJOIN zzzzsys_report ON zzzzsys_report_id = sre_zzzzsys_report_id\nORDER BY sre_code',''),('nurunreport','browseedit','nurunreport','Run Report','zzzzsys_report','zzzzsys_report_id','',0,0,'SELECT * FROM zzzzsys_report\nLEFT JOIN zzzzsys_form ON zzzzsys_form_id = sre_zzzzsys_form_id','\nnuSetTitle(nuFORM.getCurrent().run_description);\n\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\nfunction nuSelectBrowse(e){\n \n var r = $(\'#\' + e.target.id).attr(\'data-nu-row\');\n var f = $(\'#nucell_\' + r + \'_0\').html();\n var p = $(\'#\' + e.target.id).attr(\'data-nu-primary-key\');\n\n nuGetReport(f, p);\n \n}\n\n'),('nurunphp','browseedit','nurunphp','Run Procedure','zzzzsys_php','zzzzsys_php_id','',0,0,'SELECT * FROM zzzzsys_php\nJOIN zzzzsys_form ON zzzzsys_form_id = sph_zzzzsys_form_id\nWHERE (sph_system != \'1\' || sph_system IS NULL)\nORDER BY sph_code','\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\nfunction nuSelectBrowse(e){\n\n var r = $(\'#\' + e.target.id).attr(\'data-nu-row\');\n var p = $(\'#nucell_\' + r + \'_0\').html();\n var f = $(\'#\' + e.target.id).attr(\'data-nu-primary-key\');\n\n nuGetPHP(p, f);\n\n}\n\n'),('nulaunchdates','launch','nulaunchdates','Between 2 Dates','','','',0,0,'','\nnuSetTitle(nuFORM.getCurrent().run_description);'),('nutimezone','browse','nutimezone','Time Zone','zzzzsys_timezone','zzzzsys_timezone_id','',0,0,'SELECT * \nFROM zzzzsys_timezone\nORDER BY stz_timezone',''),('nusetup','edit','nusetup','Setup','zzzzsys_setup','zzzzsys_setup_id','',0,0,'','$(\'#set_header\').addClass(\'html\');\n \n$(\'.html\').dblclick(function() {\n nuOpenAce(\'HTML\', this.id);\n});\n\n'),('nutranslate','browseedit','nutranslate','Translation','zzzzsys_translate','zzzzsys_translate_id','',0,0,'SELECT * \nFROM zzzzsys_translate\nORDER BY trl_language, trl_english',''),('nupassword','edit','nupassword','Change Password','zzzzsys_user','zzzzsys_user_id','',0,0,'SELECT * FROM zzzzsys_user\nJOIN zzzzsys_user_group ON sus_zzzzsys_user_group_id = zzzzsys_user_group_id\nORDER BY sus_name','$(\'#nuTab0\').hide();'),('nusample','launch','nusample','Default Fast Form Objects','','','',0,0,'','//$(\'#nuBreadcrumbHolder\').remove();\n$(\'#nuActionHolder\').remove();\n//$(\'#nuTabHolder\').remove();\n\n$(\'#nuOptions\').hide();\n\n$(\'#inputtextsample\').val(\'text\');\n$(\'#inputnumbersample\').val(4);\n$(\'#inputnunumbersample\').val(\'$ 1,234.56\');\n$(\'#inputnudatesample\').val(\'20-Apr-2017\');\n$(\'#inputnuscrollsample\').val(\'East\');\n$(\'#calcsample\').val(\'$ 1,238.56\');\n\n$(\'#selectsample\').val(1);\n$(\'#selectmultiselectsample\').val(0);\n$(\'#textareasample\').val(\"text-area blah blah blah blah \");\n\n$(\"[id^=\'label\']\").addClass(\'nu_input\').css({width:120, left:10, \'text-align\':\'center\'});\n\n$(\'#label_imagesample\').addClass(\'nu_image\').removeClass(\'nu_input\');\n$(\'#label_textareasample\').addClass(\'nu_textarea\').removeClass(\'nu_input\');\n$(\'#label_displaysample\').addClass(\'nu_display\').removeClass(\'nu_input\');\n$(\'#label_htmlsample\').addClass(\'nu_html\').removeClass(\'nu_input\');\n$(\'#label_calcsample\').addClass(\'nu_calc\').removeClass(\'nu_input\');\n$(\'#label_selectsample\').addClass(\'nu_select\').removeClass(\'nu_input\');\n$(\'#label_selectmultiselectsample\').addClass(\'nu_select\').removeClass(\'nu_input\');\n$(\'#label_lookupsample\').addClass(\'nu_lookup\').removeClass(\'nu_input\');\n$(\'#labelword\').addClass(\'nu_word\').removeClass(\'nu_input\');\n$(\'#label_subformsample\').addClass(\'nu_subform\').removeClass(\'nu_input\').css({left:10});\n\n$(\"[id^=\'label\']\")\n.addClass(\'nuCalculatorButton\')\n.removeClass(\'nuWord\')\n.css({\'height\':30, \'width\':220})\n\n\n\n\n'),('nufastformobjects','subform','nufastformobjects','Fast Form Objects','zzzzsys_debug','zzzzsys_debug_id','',0,0,'SELECT count()* FROM zzzzsys_debug',''),('nucalcobjects','browse','nucalcobjects','Calc values On This Form And Its Subforms','#TABLE_ID#','thevalue','',0,4,'SELECT * FROM #TABLE_ID#','\nwindow.nuBrowseFunction = \'nuSelectCalcField\';\n\nfunction nuSelectCalcField(e){\n\n var row = e.target.id.substr(0,8);\n var fld = $(\'#\' + row + \'003\').html();\n var frm = $(\'#sob_calc_formula\', parent.window.document).val();\n\n $(\'#sob_calc_formula\', parent.window.document)\n .val(frm + \'nuTotal(\"\' + fld + \'\")\')\n .trigger(\'change\');\n\n}\n\n'),('nuformat','browseedit','nuformat','Input Formats','zzzzsys_format','zzzzsys_format_id','',0,0,'SELECT * FROM zzzzsys_format','\n$(\'#nucalculator\').css(\'border\',\'none\');\n$(\'#currencysign\').hide().addClass(\'nuCalculatorCurrency\').val(\'$\');\n$(\'#currencydecimals\').hide().addClass(\'nuCalculatorCurrency\').val(\'2\');\n$(\'#srm_format\').addClass(\'nuReadonly nuCalculatorCurrency\').css(\'font-size\', 12);\n$(\'.nuWord\').css(\'font-style\', \'bold\');\n\nnuSetFormatType();\n\n\nfunction nuAddToFormat(e){\n \n var v = String(e.target.innerHTML);\n \n if(v == \'Space\'){v = \' \';}\n \n if($(\'#srm_type\').val() == \'Date\'){\n \n $(\'#srm_format\')\n .val($(\'#srm_format\').val() + v)\n .change();\n \n }else{\n \n var c = String($(\'#currencysign\').val()).trim();\n var d = String(Number($(\'#currencydecimals\').val()));\n \n d = d == \'NaN\' ? 0 : Number(d);\n v = d == 0 ? v.substr(0, v.length - 1) : v;\n \n $(\'#srm_format\')\n .val(c + \' \' + v + String(0).repeat(d))\n .change();\n \n }\n \n}\n\n\nfunction nuSetFormatType(a){\n\n $(\'#format_title\').hide();\n $(\'#nucalculator\').hide();\n $(\'#currencysign\').hide();\n $(\'#currencydecimals\').hide();\n $(\'.date\').hide();\n $(\'.number\').hide();\n\n if(arguments.length == 1){\n $(\'#srm_format\').val(\'\');\n }\n \n if($(\'#srm_type\').val() == \'Date\'){\n $(\'.date\').show();\n }\n \n if($(\'#srm_type\').val() == \'Number\'){\n \n $(\'#currencysign\').show();\n $(\'#currencydecimals\').show();\n $(\'.number\').show();\n\n }\n\n $(\'#format_title\').show();\n $(\'#nucalculator\').show();\n \n}\n\n\n\n'),('nuformatcurrency','edit','nuformatcurrency','Format Currency','zzzzsys_format','zzzzsys_format_id','',0,0,'','$(\'#sign\').focus();\n\n\n$(\'#nuActionHolder\').remove();\n$(\'#nuBreadcrumbHolder\').remove();\n$(\'#nuTabHolder\').remove();\n\n\n\n\n\nfunction nuCreateCurrencyFormat(){\n console.log(\'in nuCreateCurrencyFormat()\');\n}\n'),('nuform','browseedit','nuform','nuBuilder Form','zzzzsys_form','zzzzsys_form_id','',0,0,'SELECT * FROM zzzzsys_form\nINNER JOIN #TABLE_ID# ON zzzzsys_form_id = theid\nORDER BY sfo_code\n','$(\'#title_zzzzsys_tab_sfsyt_help\').attr(\'id\', \'help_title\');\n$(\"[id$=\'syt_help\']\").addClass(\'js\');\nnuAttachButtonImage(\'previewbrowse\',\'PB\');\nnuAttachButtonImage(\'previewedit\',\'PE\');\nnuAttachButtonImage(\'bb_event\',\'BB\');\nnuAttachButtonImage(\'be_event\',\'BE\');\nnuAttachButtonImage(\'bs_event\',\'BS\');\nnuAttachButtonImage(\'as_event\',\'AS\');\nnuAttachButtonImage(\'bd_event\',\'BD\');\nnuAttachButtonImage(\'ad_event\',\'AD\');\nnuAttachButtonImage(\'icon\',\'JS\');\nnuAttachButtonImage(\'br_sql\',\'SQL\');\n\n$(\'#sfo_javascript\')\n.css(\'padding\', \'3px 3px 3px 3px\')\n\n\n$(\'#user_home\')\n.css({\n \'color\' : \'white\',\n \'font-size\' : 13,\n \'display\' : \'inline\',\n \'border-style\' : \'solid\',\n \'height\' : 30,\n \'font-size\' : 16,\n \'text-shadow\' : \'0 1px 2px #9AB973\',\n \'border-color\' : \'#9AB973\',\n \'border-width\' : \'0px 0px 1px 0px\',\n \'background-color\' : \'#88cb51\'\n});\n\n\n$(\'#sfo_javascript\').addClass(\'js\');\n$(\'#sfo_browse_sql\').addClass(\'sql\')\n.css(\'font-size\', 10)\n\nnuSetTitle($(\'#sfo_table\').val());\n\n$(\'.js\')\n.dblclick(function() {\n nuOpenAce(\'Javascript\', this.id);\n});\n\n$(\'.sql\').dblclick(function() {\n nuOpenAce(\'SQL\', this.id);\n});\n\n$(\'.html\')\n.dblclick(function() {\n nuOpenAce(\'HTML\', this.id);\n});\n\n\nif(window.filter == \'justjs\'){\n \n $(\'#nuDeleteButton\').remove();\n $(\'#nuCloneButton\').remove();\n $(\'#nuTab0\').remove();\n $(\'#nuTab1\').remove();\n $(\'#nuTab2\').click();\n $(\'#nuTab2\').remove();\n \n nuSetTitle($(\'#sfo_description\').val());\n \n}\n\n\nfunction nuFormColor(){\n\n var t = String($(\'#sfo_type\').val());\n\n var pb = \'previewbrowse\';\n var pe = \'previewedit\';\n\n var bb = \'bb_event\';\n var be = \'be_event\';\n var bs = \'bs_event\';\n var as = \'as_event\';\n var bd = \'bd_event\';\n var ad = \'ad_event\';\n \n if(t == \'browse\'){\n \n nuDisable(pe);\n\n nuDisable(be);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n\n }\n \n if(t == \'edit\'){\n \n nuDisable(pb);\n nuDisable(bb);\n \n }\n\n if(t == \'launch\'){\n \n nuDisable(pb);\n nuDisable(bb);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n\n }\n \n if(t == \'subform\'){\n \n nuDisable(pb);\n nuDisable(bb);\n nuDisable(be);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n nuDisable(\'sfo_javascript\');\n \n }\n\n if(nuFORM.getCurrent().record_id == \'nuuserhome\'){\n // nuDisable(\'sfo_javascript\');\n }\n \n var h = $(\'#sfo_type\').addClass(\'nuEdited\');\n var o = [];\n o[\'browse\'] = [0,1,2];\n o[\'edit\'] = [0,2];\n o[\'browseedit\'] = [0,1,2];\n o[\'launch\'] = [0,2];\n o[\'subform\'] = [0,1];\n \n $(\'#sfo_type\').removeClass();\n $(\'#sfo_type\').addClass(\'nu_\'+$(\'#sfo_type\').val());\n \n if(h){\n $(\'#sfo_type\').addClass(\'nuEdited\');\n }\n \n $(\"#sfo_type > option\").each(function() {\n $(this).addClass(\'nu_\'+this.value);\n });\n\n for(var i = 0 ; i < 7 ; i++){\n $(\'#nuTab\' + i).removeClass(\'nuRelatedTab\');\n }\n var t = o[$(\'#sfo_type\').val()];\n\n if(t !== undefined){\n \n for(var i = 0 ; i < t.length ; i++){\n $(\'#nuTab\' + t[i]).addClass(\'nuRelatedTab\'); \n }\n \n }\n \n}\n\nnuFormColor();\n\n$(\"[data-nu-column=\'0\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\ndefault_description();\n\nfunction nuEventList(){\n \n if($(\'sob_all_type\').val() == \'subform\'){\n return [\'onchange\',\'onadd\'];\n }else{\n return [\'onblur\',\'onchange\',\'onfocus\',\'onkeydown\'];\n }\n \n}\n\nfunction default_description(){\n \n var s = \'zzzzsys_browse_sf\';\n var r = nuSubformObject(s).rows.length - 1;\n var o = \'#\' + s + nuPad3(r) + \'sbr_title\';\n var d = \'Something\';\n\n $(o).val(d);\n\n}\n\n\n'),('nufile','browseedit','nufile','Stored Files','zzzzsys_file','zzzzsys_file_id','',150,3,'SELECT * FROM zzzzsys_file\nORDER BY sfi_code','\nnuSetNoSearchColumns([2,3]);\n\n$(\'[data-nu-column=\"0\"]\').each(function( index ) {\n\n var code = \'#nucell_\' + index + \'_\';\n window.nuImages[$(code + \'0\').text()] = $(code + \'2\').text();\n \n});\n\n\n\nif(nuFormType() == \'browse\'){\n nuShowBrowseImages()\n}else{\n nuShowFile();\n}\n\n\n\n\nfunction nuBeforeSave(){\n\n var f = $(\'#sfi_json_file\').val();\n \n if(f != \'\'){\n \n $(\'#sfi_json\')\n .val(f)\n .change();\n \n }\n \n return true;\n\n}\n\n\nfunction nuShowFile(){\n \n var j = $(\'#sfi_json\').val();\n \n nuEmbedObject(j, \'view_image\');\n \n}\n\n\nfunction nuShowBrowseImages(){\n\n $(\'[data-nu-column=\"0\"]\').each(function( index ) {\n \n var p = $(this).attr(\'id\');\n var r = String(p).split(\'_\')[1];\n var i = \"nucell_\" + r + \"_2\";\n var e = \"nucell_\" + r + \"_3\";\n var h = $(\'#\' + i).html();\n\n if(h != \'\' && h !== undefined){\n \n nuEmbedObject(h, e, 140, 140);\n\n }\n \n });\n\n}\n\n'),('nuselect','browseedit','nuselect','SQL Builder','zzzzsys_select','zzzzsys_select_id','',0,0,'SELECT * FROM zzzzsys_select \nWHERE (sse_system != 1 || sse_system IS NULL)\nORDER BY sse_description ASC\n\n','\nif(nuIsNewRecord()){\n $(\'#sse_edit\').val(0);\n}\n\n$(\"#sse_edit option[value=\'\']\").remove();\n\n$(\'#sse_sql\')\n.css(\'font-size\', 10)\n.addClass(\'sql\')\n.dblclick(function() {\n nuOpenAce(\'SQL\', this.id);\n});\n\n$(\'#label_sse_sql\').remove();\n\nnuSetSFCB();\n\nif(window.filter == \'justsql\'){\n\n var sid = String(nuFORM.getCurrent().record_id);\n var from = sid.substring(sid.length-2);\n var targ = \'#sfo_browse_sql\';\n\n $(\'#nuDeleteButton\').remove();\n $(\'#nuCloneButton\').remove();\n $(\'#sse_description\').val(sid);\n \n nuHide(\'sse_description\');\n \n if(nuFORM.getCurrent().record_id != -1){\n \n $(\'#nuSaveButton\').hide();\n \n if(from == \'BR\'){\n nuAddActionButton(\'SaveToTextarea\', \'Copy to Form Browse SQL\', \'nuCopySQL(\"sfo_browse_sql\")\');\n }\n \n if(from == \'SE\'){\n nuAddActionButton(\'SaveToTextarea\', \'Copy to Select Object SQL\', \'nuCopySQL(\"sob_select_sql\")\');\n }\n \n\n if(from == \'DI\'){\n nuAddActionButton(\'SaveToTextarea\', \'Copy to Display Object SQL\', \'nuCopySQL(\"sob_display_sql\")\');\n }\n \n }\n\n}\n\n\n\nnuSetTitle($(\'#sal_code\').val());\n\n$(\'#sse_sql\')\n.css({\n \'white-space\' : \'nowrap\',\n \'overflow-x\' : \'scroll\',\n})\n\nnuWhereClauses();\n\n\nfunction nuCopySQL(targ){\n \n var s = $(\'#sse_sql\').val();\n \n parent.$(\'#\' + targ).val(s).change();\n \n parent.$(\'#dialogClose\').click();\n\n}\n\n\nfunction nuTempPHP(){\n \n var p = [];\n \n p.push(\'\');\n p.push(\'$sql = \"\');\n p.push(\'\');\n p.push(\'CREATE TABLE #TABLE_ID#\');\n p.push($(\'#sse_sql\').val());\n p.push(\'\');\n p.push(\'\";\');\n p.push(\'\');\n p.push(\"nuRunQuery($sql);\");\n p.push(\'\');\n nuMessage(p);\n// $(\"#nuAlertDiv\").css(\'text-align\', \'left\')\n $(\"#nuMessageDiv\").css(\'text-align\', \'left\')\n\n}\n\nfunction nuBeforeSave(){\n \n $(\'#sqlframe\')[0].contentWindow.nuSQL.buildSQL();\n return true;\n \n}\n\n\n\n\nfunction nuWhereClauses(){\n\n $(\"[id$=\'ssc_type\']select\").each(function(index){\n \n var p = $(this).attr(\'data-nu-prefix\');\n var t = $(this).val();\n \n if(t == 2 || t == 3){\n \n if($(\'#\' + p + \'ssc_sort\').val() == \'\'){\n $(\'#\' + p + \'ssc_sort\').val(\'ASC\');\n }\n \n $(\'#\' + p + \'ssc_clause\').hide();\n $(\'#\' + p + \'ssc_sort\').show();\n \n }else{\n \n $(\'#\' + p + \'ssc_clause\').show();\n $(\'#\' + p + \'ssc_sort\').hide();\n \n }\n\n });\n\n}\n\n\nfunction nuWhereClausesold(){\n\n $(\"[id$=\'ssc_type\']select\").each(function(index){\n \n var p = $(this).attr(\'data-nu-prefix\');\n var t = $(this).val();\n \n if(t == 2 || t == 3){\n \n if($(\'#\' + p + \'ssc_sort\').val() == \'\'){\n $(\'#\' + p + \'ssc_sort\').val(\'ASC\');\n }\n \n $(\'#\' + p + \'ssc_clause\').hide();\n $(\'#\' + p + \'ssc_sort\').show();\n \n }else{\n \n $(\'#\' + p + \'ssc_clause\').show();\n $(\'#\' + p + \'ssc_sort\').hide();\n \n }\n\n });\n\n}\n\n\nfunction nuAddSQLTable(e){\n \n var s = $(\'#sqlframe\')[0].contentWindow.nuSQL;\n \n s.addBox(e.target.value);\n e.target.value = \'\';\n s.buildSQL();\n\n}\n\n\nfunction nuSFCB(){\n \n nuWhereClauses();\n $(\'#sqlframe\')[0].contentWindow.nuSQL.buildSQL();\n\n}\n\n\nfunction nuSetSFCB(){\n \n $(\'.nuSubformCheckbox.zzzzsys_select_clause\')\n .click(function(){\n nuSFCB();\n });\n \n}\n\n\n\nfunction nuResizeSQL(){\n\n if($(\'#sqlframe\').css(\'height\') == \'470px\'){\n $(\'#sqlframe\').css(\'height\', 180);\n }else{\n $(\'#sqlframe\').css(\'height\', 470);\n }\n \n}\n\n\n'),('nulaunchable','browse','nulaunchable','Launchable Forms','zzzzsys_form','zzzzsys_form_id','',0,0,'SELECT * FROM zzzzsys_form\nWHERE sfo_type IN (\'edit\', \'browseedit\', \'launch\')\nAND (\n SUBSTRING(zzzzsys_form_id, 1, 2) != \'nu\'\n OR zzzzsys_form_id = \'nublank\'\n OR zzzzsys_form_id = \'nuuserhome\'\n )\nORDER BY sfo_code\n','$(\'#sfo_breadcrumb_title\').addClass(\'sql\');\n$(\'#sfo_browse_sql\').addClass(\'sql\');\n$(\'#sfo_javascript\').addClass(\'js\');\n\nnuSetTitle($(\'#sfo_table\').val());\n\n$(\'.js\').dblclick(function() {\n nuOpenAce(\'Javascript\', this.id);\n});\n\n$(\'.sql\').dblclick(function() {\n nuOpenAce(\'SQL\', this.id);\n});\n\n$(\'.html\').dblclick(function() {\n nuOpenAce(\'HTML\', this.id);\n});\n\n$(\'.php\').dblclick(function() {\n nuOpenAce(\'PHP\', this.id);\n});\n\nif(window.filter == \'justjs\'){\n \n $(\'#nuDeleteButton\').remove();\n $(\'#nuCloneButton\').remove();\n $(\'#nuTab0\').remove();\n $(\'#nuTab1\').remove();\n $(\'#nuTab2\').click();\n $(\'#nuTab2\').remove();\n \n nuSetTitle($(\'#sfo_description\').val());\n \n}\n\n\n\nfunction nuFormColor(){\n\n var t = String($(\'#sfo_type\').val());\n\n var pb = \'previewbrowse\';\n var pe = \'previewedit\';\n\n var bb = \'bb_event\';\n var be = \'be_event\';\n var bs = \'bs_event\';\n var as = \'as_event\';\n var bd = \'bd_event\';\n var ad = \'ad_event\';\n \n if(t == \'browse\'){\n \n nuDisable(pe);\n\n nuDisable(be);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n\n }\n \n if(t == \'edit\'){\n \n nuDisable(pb);\n nuDisable(bb);\n \n }\n\n if(t == \'launch\'){\n \n nuDisable(pb);\n nuDisable(bb);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n\n }\n \n if(t == \'subform\'){\n \n nuDisable(pb);\n nuDisable(bb);\n nuDisable(be);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n nuDisable(\'sfo_javascript\');\n \n }\n\n var h = $(\'#sfo_type\').addClass(\'nuEdited\');\n var o = [];\n o[\'browse\'] = [0,1,2];\n o[\'edit\'] = [0,2];\n o[\'browseedit\'] = [0,1,2];\n o[\'launch\'] = [0,2];\n o[\'subform\'] = [0,1];\n \n $(\'#sfo_type\').removeClass();\n $(\'#sfo_type\').addClass(\'nu_\'+$(\'#sfo_type\').val());\n \n if(h){\n $(\'#sfo_type\').addClass(\'nuEdited\');\n }\n \n $(\"#sfo_type > option\").each(function() {\n $(this).addClass(\'nu_\'+this.value);\n });\n\n for(var i = 0 ; i < 7 ; i++){\n $(\'#nuTab\' + i).removeClass(\'nuRelatedTab\');\n }\n var t = o[$(\'#sfo_type\').val()];\n\n if(t !== undefined){\n \n for(var i = 0 ; i < t.length ; i++){\n $(\'#nuTab\' + t[i]).addClass(\'nuRelatedTab\'); \n }\n \n }\n \n}\n\nnuFormColor();\n\n//nuBuildSubformArray(\'zzzzsys_tab_sf\');\n//nuBuildSubformArray(\'zzzzsys_browse_sf\');\n\n$(\"[data-nu-column=\'nucolumn000\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n\n\nfunction nuEventList(){\n \n if($(\'sob_all_type\').val() == \'subform\'){\n return [\'onchange\',\'onadd\'];\n }else{\n return [\'onblur\',\'onchange\',\'onfocus\',\'onkeydown\'];\n }\n \n}\n\n\n'),('nuclause','subform','nuclause','Select Clauses','zzzzsys_select_clause','zzzzsys_select_clause_id','',0,0,'SELECT * FROM zzzzsys_select_clause\nORDER BY ssc_type, ssc_order',''),('nubuildtable','browse','nubuildtable','PHP or SELECT or TABLE','zzzzsys_report_data','id','nuselect',0,0,'SELECT * FROM zzzzsys_report_data',''),('nuuserhome','launch','nuuserhome','Home','','','',0,0,'',''),('nufrlaunch','launch','nufrlaunch','Fast Report','','','',0,0,'SELECT * FROM Launch Form 0','\n$(\'#wrdaddable\').css({\'font-size\' : 14, \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\n$(\'#frwrd\').css({\'font-size\' : 14, \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\n$(\'#nufr\').css(\'text-align\', \'left\').css(\'padding\', \'3px\');\n$(\'#list\').addClass(\'nuScroll\').removeClass(\'nuReadonly\');\n\n$(\'.nuActionButton\').hide();\nnuAddActionButton(\'nuRunPHPHidden\', \'Build Fast Report\', \'nuRunPHPHidden(\"RUNFR\")\');\n\n\nfunction nuAddReportField(t){\n\n var f = nuPad3($(\"[data-nu-label=\'Field Name\']\").length - 1);\n\n $(\'#fast_report_sf\' + f + \'field\').val($(t).html()).change();\n $(\'#fast_report_sf\' + f + \'width\').val(100).change();\n $(\'#fast_report_sf\' + f + \'sum\').val(\'no\').change();\n $(\'#fast_report_sf\' + f + \'title\').val($(t).html()).change().select();\n \n}\n\n\nfunction nuBeforeSave(){\n \n if($(\'#table\').val() == \'\'){\n \n nuMessage([\'<b>Table Data</b>\', \'Cannot be left blank...\'])\n return false;\n \n }\n \n \n if($(\'#orderby\').val() == \'\'){\n \n nuMessage([\'<b>Order By</b>\', \'Cannot be left blank...\'])\n return false;\n \n }\n \n nuBuildFastReport();\n \n return true;\n \n}\n\n'),('nufastreportobjects','subform','nufastreportobjects','Fast Report Objects','zzzzsys_debug','zzzzsys_debug_id','',0,0,'SELECT count(*) FROM zzzzsys_debug',''),('nusamplesubformform','launch','nusamplesubformform','Sample Subform Form','','','',0,0,'SELECT * FROM Launch Form 0',''),('nulaunchform','edit','nulaunchform','nuBuilder non-System Form','zzzzsys_form','zzzzsys_form_id','',0,0,'SELECT * FROM zzzzsys_form\nWHERE sfo_type = \'launch\' AND zzzzsys_form_id != \'nuhome\'\nORDER BY sfo_code\n','$(\"[data-nu-column=\'0\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\n'),('nutablookup','browse','nutablookup','Form Tab Lookup','zzzzsys_tab','zzzzsys_tab_id','',0,0,'SELECT * FROM zzzzsys_tab\nJOIN zzzzsys_form ON zzzzsys_form_id = syt_zzzzsys_form_id\nJOIN #TABLE_ID# ON zzzzsys_form_id = theid\nORDER BY syt_order','\n$(\"[data-nu-column=\'3\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\n'); 270 270 /*!40000 ALTER TABLE `zzzzsys_form` ENABLE KEYS */; 271 271 UNLOCK TABLES; … … 689 689 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 690 690 691 -- Dump completed on 2018-12-1 0 12:26:57691 -- Dump completed on 2018-12-11 14:42:10 -
nubuilder-forte/trunk/readme.txt
r1990310 r1991387 13 13 nuBuilder is the world's best: open-source, low-code application and report builder. 14 14 15 == Description == 16 15 17 Using nuBuilder Forte with Wordpress will enable you to build your own custom reports and forms to manage your data. 16 18 17 == Description == 18 19 nuBuilder enables you to make any application that want or need with the least amount of effort and the least amount of learning. 19 nuBuilder enables you to make any application that you want or need with the least amount of effort and the least amount of learning. 20 20 21 21 nuBuilder Forte is the 4th version of nuBuilder. A browser-based tool created by nuSoftware for developing web-based database applications. … … 28 28 * Update 29 29 * Delete 30 31 = SUPPORT = 32 To help continue development and support for this free plugin please consider [making a donation.](https://www.nubuilder.com/#donate "making a donation") Your donation will help encourage the plugin’s continued development and better support for users. 30 33 31 34 = Alternative to MS-Access =
Note: See TracChangeset
for help on using the changeset viewer.