PHP
Each of the purple diamonds represents PHP code that can be run in nuBuilder Forte and when.
eg. You might add this in AS - After Save of an invoice Browse and Edit Form.
<source lang="php">
$s = "UPDATE stock SET sto_units = sto_units - '$units' WHERE stock_id = '$stock_id';"
nuRunQuery($s);
</source>
db_fetch_array
$object = db_fetch_array($object1)
Parameters
$object1 : nuRunQuery() result.
Return Value
$object : PDO object.
Description
A function for looping through the result of a SELECT query returned from nuRunQuery.
Example
$s = "SELECT in_death_name FROM member WHERE nickname = 'bob'";
$t = nuRunQuery($s);
while($r = db_fetch_array($t)){
nuDebug('His name is ' . $r['in_death_name']);
}
[0]: His name is Robert Paulson
Also See :
db_field_names, db_fetch_row, db_fetch_object, db_num_rows, nuRunQuery
db_fetch_object
$object = db_fetch_object($object1)
Parameters
$object1 : nuRunQuery() result.
Return Value
$object : PDO object
Description
A function for looping through the result of a SELECT query returned from nuRunQuery.
Example
$s = "SELECT in_death_name FROM member WHERE nickname = 'bob'";
$t = nuRunQuery($s);
while($r = db_fetch_object($t)){
nuDebug('His name is ' . $r->in_death_name);
}
[0]: His name is Robert Paulson
Also See :
db_field_names, db_fetch_array, db_fetch_row, db_num_rows, nuRunQuery
db_fetch_row
$object = db_fetch_row($object1)
Parameters
$object1 : nuRunQuery() result.
Return Value
$object : PDO object.
Description
A function for looping through the result of a SELECT query returned from nuRunQuery.
Example
$s = "SELECT in_death_name FROM member WHERE nickname = 'bob'";
$t = nuRunQuery($s);
while($r = db_fetch_row($t)){
nuDebug('His name is ' . $r[0]);
}
[0]: His name is Robert Paulson
Also See :
db_field_names, db_fetch_array, db_fetch_object, db_num_rows, nuRunQuery
db_field_names
$array = db_field_names($string1)
Parameters
$string1 : Database table name.
Return Value
$array : Field names.
Description
Returns an array of field names from a database table.
Example
$a = db_field_names('customer');
nuDebug($a);
[0]: Array
(
[0] => customer_id
[1] => cus_name
[2] => cus_phone
[3] => cus_address
)
Also See :
db_fetch_array, db_fetch_object, db_fetch_row, db_num_rows
db_num_rows
$integer = db_num_rows($object1)
Parameters
$object1 : PDO object.
Return Value
$integer : Number of records returned.
Description
The number of records in the result from nuRunQuery.
Example
$s = "SELECT * FROM customer"; $t = nuRunQuery($s); nuDebug(db_num_rows($t);
[0]: 3453
Also See :
db_field_names, db_fetch_array, db_fetch_object, db_fetch_row, nuRunQuery
nuAddJavascript
nuAddJavascript($string1)
Parameters
$string1 : Javascript code.
Return Value
Description
Adds Javascript to the beginning of a Form's Javascript before it is run.
Example
$j = "console.log('Who's a good computer?');
nuAddJavascript($j);
Also See :
Before Browse, Before Edit
nuDebug
nuDebug($anytype1, $anytype2..)
Parameters
$anytypes : string, object or array.
Return Value
Description
This function takes multiple parameters and creates a record that can be viewed by clicking nuDebug Results in the Options menu.
Each nuDebug record's first line will explain when or why it was created. There are 3 types...
- Procedure - 2017-11-03 06:52:02 - Procedure ABC line 1
- Event - 2017-11-03 06:58:08 - Before Edit of Form nuhome line 5
- SQL Error - 2017-11-03 06:58:09 - SQL Error in nuRunQuery
Example
$s = 'Hello world'; $a = [1,2,3,4]; $o = ['name' => 'Bob', 'phone' => '555 123456']; nuDebug($s, $a, $o); nuAddJavascript($j);
[0] : Hello world
[1] : Array
(
[0] => 1
[1] => 2
[2] => 3
[3] => 4
)
[2] : Array
(
[name] => Bob
[phone] => 555 123456
)
Also See :
Before Browse, Before Edit, Before Save,After Save, Before Delete, After Delete
nuDisplayError
nuDisplayError($string1)
Parameters
$string1 : error message.
Return Value
Description
This function adds an error message that will stop the Edit Form from saving or deleting the current record but will then display all generated error messages.
If any error messages are created in Before Save or Before Delete the current record will not be saved or deleted. eg.
- No messages - Continue to Save or Delete record.
- One or more messages - No not Save or Delete record.
If any messages are created in After Save or After Delete the current record will be saved or deleted and will display this message once saved.
(The green Yes or red No elements in the flowchart below.)
Example
nuDisplayError('That did not work!');
Also See :
Before Save, Before Delete, nuMessage
nuHash
$array = nuHash()
Parameters
Return Value
$array : list of Hash Cookies.
Description
Returns a list of Hash Cookies available to use in PHP.
Example
nuDebug(nuHash());
[0] : Array
(
[USER_ID] => globeadmin
[USER_GROUP_ID] =>
[HOME_ID] =>
[GLOBAL_ACCESS] => 1
[invoice_id] => s14919516899490
[inv_company_id] =>
[inv_number] => 53
[inv_total] => 215.3
[inv_date] => 2017-03-19 00:00:00
[record_id] => s14919516899490
[title] => Invoice
[call_type] => getlookupid
[iframe] => 0
[lookup_id] =>
[object_id] => s14967319482165
[page_number] => 0
[password] =>
[rows] => 20
[row_height] => 25
[session_id] => s15001161980910
[sort] => -1
[sort_direction] => desc
[subforms] => 0
[username] =>
[user_id] => globeadmin
[58a08a1abc4782c] => s14919516899490
[FORM_ID] => 58a08a1abc4782c
[PREVIOUS_RECORD_ID] => s14919516899490
[RECORD_ID] => s14919516899490
[form_id] => 58a08a1abc4782c
[redirect_form_id] => 58a08a1abc4782c
[browse_sql] =>
[browse_rows] =>
[pages] => 0
[prefix] =>
[primary_key] => 57295aa5660f48b
[inv_gst] => 0
[inv_gst2] => 0
[test] =>
[SUBFORM_ID] => s14967319482165
[ID] => 57295aa5660f48b
[CODE] =>
[nuFORMdata] =>
[TABLE_ID] => ___nu15969f4ed5b744___
[SESSION_ID] => s15001161980910
[data] =>
[LOOKUP_RECORD_ID] => 57295aa5660f48b
)
Also See :
nuDebug()
nuHasNewRecordID
$boolean = nuHasNewRecordID()
Parameters
Return Value
$boolean : yes or no.
Description
Matches #PREVIOUS_RECORD_ID# with #RECORD_ID# and returns true or false.
So that the user can tell if a record is being cloned or saved for the first time.
Example
if(nuHasNewRecordID()){
nuUpdateCounter($r->zzzzsys_object_id);
}
Also See :
nuGetFormProperties
$object = nuGetFormProperties($string1)
Parameters
$string1 = Primary Key
Return Value
$object : Form record.
Description
Returns a Form record as an object.
Example
nuDebug(nuGetFormProperties('nuuser'));
[0] : stdClass Object
(
[zzzzsys_form_id] => nuuser
[sfo_type] => browseedit
[sfo_code] => nuuser
[sfo_description] => User
[sfo_table] => zzzzsys_user
[sfo_primary_key] => zzzzsys_user_id
[sfo_browse_redirect_form_id] =>
[sfo_browse_row_height] => 0
[sfo_browse_rows_per_page] => 15
[sfo_browse_sql] => SELECT *
FROM zzzzsys_user
LEFT JOIN zzzzsys_access ON zzzzsys_access_id = sus_zzzzsys_access_id
ORDER BY sus_name
[sfo_javascript] =>
)
Also See :
nuID
$string = nuID()
Parameters
Return Value
$string : random string.
Description
Creates a string from
- s - Because it was created on the server.
- 1502690897383 - Date.now().
- 1012 - An incrementing number looping between 1000 and 9999.
Example
nuDebug(nuID());
[0] : s14998774211012
Also See :
nuTT, nuID
Before Save,After Save
nuJavascriptCallback
nuJavascriptCallback($string1)
Parameters
$string : Javascript Code
Return Value
Description
Runs after nuRunPHPHidden() has returned from the server.
Example
$js = " nuMessage(['<h1>It worked!</h1>']); "; nuJavascriptCallback($js);
Also See :
nuRunPHPHidden()
nuLookupRecord
$object = nuLookupRecord()
Parameters
Return Value
$object : every field from the selected (Browse Form's) record.
Description
Returns all fields from a selected Lookup record.
Example
nuDebug(nuLookupRecord()->ID); //-- the id of the chosen Lookup record. nuDebug(nuLookupRecord()); //-- all fields from then chosen Lookup's record - as well as ID.
[0] : 5a67739f464cd96
[1] : stdClass Object
(
[company_id] => 58ade54dac2128b
[com_code] => 777
[com_name] => 7 Up
[com_business_id] => 568a00c77f8f709
[com_company_id] =>
[com_color_id] => 568ef5a6968322b#nuSep#568ef920846a089
[com_age] => 3
[com_notes] =>
[com_test] =>
)
Also See :
After Browse, nuSetFormValue
nuProcedure
$string = nuProcedure($string1)
Parameters
$string1 : Procedure Code
Return Value
$string : PHP Code with all Hash Cookies replaced
Description
Returns PHP code from a Procedure with all Hash Cookies replaced, ready to eval().
Example
$p = nuProcedure('HW');
eval($p);
Also See :
Before Browse,
After Browse,
Before Edit,
Before Save,
After Save,
Before Delete,
After Delete
nuReturnNewRecord
nuReturnNewRecord($string1 = -1)
Parameters
$string1 : record_id (if left blank this will return a blank record.)
Return Value
Description
When placed in the After Save Event, this sets the Edit Form to the record passed by $string1, ready for editing.
Example
nuReturnNewRecord();
or
nuReturnNewRecord('5a72a0fce65fea2');
Also See :
After Save
nuRunQuery
$object = nuRunQuery($string1);
Parameters
$string1 : SQL query.
Return Value
$object : PDO object.
Description
Runs an SQL query and returns an Object (for SELECT Statements).
This Object can be used by db_fetch_object, db_fetch_array, db_fetch_row, db_num_rows
Example
$s = "SELECT * FROM customer WHERE customer_id = '#LOOKUP_RECORD_ID#'
";
$t = nuRunQuery($s);
$r = db_fetch_object($t);
nuSetFormValue('inv_address', $r->cus_address);
Also See :
db_fetch_object, db_fetch_array, db_fetch_row, db_num_rows
nuSetFormValue
nuSetFormValue($string1, $string2);
Parameters
$string1 = id of nuBuilder Object on current Edit Form. $string2 = value used to update $string1's Object.
Return Value
Description
Updates an Object on an Edit Form After Browse after a Lookup value is chosen.
Example
$lu = nuLookupRecord();
nuSetFormValue('inv_address1', $lu->cus_address1);
nuSetFormValue('inv_address2', $lu->cus_address2);
nuSetFormValue('inv_address3', $lu->cus_address3);
Also See :
After Browse, nuLookupRecord
nuSubformObject
$object = nuSubformObject($string1)
Parameters
$string1 : Subform id **Passing an empty string will return the main Edit Form as a Subform object.
Return Value
$object : subform properties
Description
Returns a PHP object that can be looped through.
All Subform values in this object will have any formatting removed. eg $ 1,234.50 will be 1234.5
Example
nuDebug(nuSubformObject('invoice_item_sf'));
[0] : stdClass Object
(
[id] => invoice_item
[foreign_key] => ite_invoice_id
[primary_key] => invoice_item_id
[object_id] => 58a09180222faae
[table] => invoice_item
[action] => save
[rows] => Array
(
[0] => Array
(
[0] => s14941671441215
[1] => 6
[2] => thing1
[3] => 3
[4] => 18
[5] => 0
)
[1] => Array
(
[0] => s14998769369058
[1] => 4
[2] => thing2
[3] => 2
[4] => 8
[5] => 0
)
[2] => Array
(
[0] => -1
[1] =>
[2] =>
[3] =>
[4] =>
[5] => 1
)
)
[edited] => Array
(
[0] => Array
(
[0] => 0
[1] => 0
[2] => 0
[3] => 0
[4] => 0
[5] => 0
)
[1] => Array
(
[0] => 0
[1] => 0
[2] => 0
[3] => 0
[4] => 0
[5] => 0
)
[2] => Array
(
[0] => 0
[1] => 0
[2] => 0
[3] => 0
[4] => 0
[5] => 0
)
)
[deleted] => Array
(
[0] => 0
[1] => 0
[2] => 1
)
[fields] => Array
(
[0] => ID
[1] => ite_units
[2] => ite_thing
[3] => ite_unit_price
[4] => ite_total
[5] => nuDelete
)
)
Also See :
nuSubformObject
nuTT
$string = nuTT()
Parameters
Return Value
$string : name for temp table.
Description
Creates a unique ID starting with __nu.
Example
$tmp = nuTT(); $s = "CREATE TABLE $t SELECT * FROM customer"; nuRunQuery($tmp);
Also See :
nuID
nuUser
$object = nuUser()
Parameters
Return Value
$object : object containing User details
Description
Returns all the information from the zzzzsys_user table for the current, logged in User.
Example
nuDebug(nuUser());
[0] : stdClass Object
(
[zzzzsys_user_id] => 5a62ebae2a6994b
[sus_zzzzsys_access_id] => 5a62eb4e09ffd46
[sus_language] =>
[sus_name] => Robert
[sus_email] => bob@fclub.com
[sus_login_name] => bob
[sus_login_password] => c81e728d9d4c2f636f067f89cc14862c
)
Also See :