SCRIPTCASE MACROS

The sc_actionbar_clicked_state() macro makes it possible for the developer to retrieve the current state of the button at the time of clicking the ajax button on the action bar.

This way you can validate the current state of the button and change it according to your business rule.

This macro is exclusive for using the ajax event of the action bar button.

Examples

Example: Identification of the current state of the button in the ajax event, to change the state when clicking.

if (sc_actionbar_clicked_state() == 'pending') {

    sc_actionbar_state('ajax_btn', 'sent');

} else {

    sc_actionbar_state('ajax_btn', 'pending');

}

Example: Example for viewing the current value of the button.

echo sc_actionbar_clicked_state();

Disables the action bar button, making it unavailable for clicking.

This macro can be used for any type of button (link or ajax) on the action bar.

Parameter definition

Examples

Example 1: Basic macro usage

sc_actionbar_disable("link_detalhe");

Example 2: Disabling the link button to the order detail if there are no items in the order.

// Example created in the onRecord event of the grid using the order and orderdetail table
// If there are no items in the order, the button will be disabled

$query = "SELECT count(*) FROM OrderDetails WHERE OrderID = ". {OrderID};
sc_lookup(ds, $query);

if ({ds[0][0]} == 0) {

    //Exemplo de utilização da macro sc_actionbar_disable
    sc_actionbar_disable("button_name");

} else { 

    sc_actionbar_enable("button_name");
 
}

Enables the action bar button, making it available for clicking.

This macro can be used for any type of button (link or ajax) on the action bar.

Parameter definition

Examples

Example 1: Basic macro usage

sc_actionbar_enable("button_name");

Example 2: Enabling the link button to the order detail if there is any record to be displayed.

// Example created in the onRecord event of the grid using the order table and orderdetail table
// If there are no items ordered in the measurement, the button will be disabled

$query = "SELECT count(*) FROM OrderDetails WHERE OrderID =" . {OrderID};
sc_lookup(ds, $query);

if ({ds[0][0]} <> 0) {

    //Example of using the sc_actionbar_enable macro
    sc_actionbar_enable("button_name");

} else {

    sc_actionbar_disable("button_name");

}

This macro hides the button created on the action bar, which can be displayed again with the sc_actionbar_show macro.

This macro can be used with any type of button (link or ajax) created in the action bar.

Parameter definition

Exemplos

Example 1: Basic macro usage

sc_actionbar_show("button_name");

Example 2: Showing the order detail link button if there are any records to show.

// Example created in the onRecord event of the query using the order and orderdetail table
// If there are no items in the order, the detail link button will be hidden.

$query = "SELECT count(*) FROM OrderDetails WHERE OrderID =" . {OrderID};
sc_lookup(ds, $query);

if ({ds[0][0]} == 0) {

     //Example of using the macro sc_actionbar_hide
     sc_actionbar_hide("button_name");

} else {

     sc_actionbar_show("button_name");

}

This macro displays the action bar button, hidden using the sc_actionbar_hide macro

This macro can be used for any type of button (link or ajax) on the action bar.

Parameter definition

Exemplos

Example 1: Basic macro usage

sc_actionbar_show("button_name");

Example 2: Showing the order detail link button if there are any records to show.

// Example created in the onRecord event of the query using the order and orderdetail table
// If there are no items in the order, the button will not be displayed

$query = "SELECT count(*) FROM OrderDetails WHERE OrderID =" . {OrderID};
sc_lookup(ds, $query);

if ({ds[0][0]} <> 0) {

    //Exemplo de utilização da macro sc_actionbar_enable
    sc_actionbar_show("button_name");

} else {

    sc_actionbar_hide("button_name");

}

This macro allows you to change the current state of the action bar button through.

To use the button's, ajax event, we recommend using this macro together with sc_actionbar_clicked_state(); that makes it possible to recover the current state of the button.

Definition of Parameters

Examples

Example - Changing the ajax_btn button state between pending and sent in the button's onclick event.

if (sc_actionbar_clicked_state() == 'pending') {

        sc_actionbar_state('ajax_btn', 'sent');

} else {

        sc_actionbar_state('ajax_btn', 'pending');

}

Example - Changing the state of the ajax_btn button between pending and sent, and storing the change in the base in the email_sent field.

if (sc_actionbar_clicked_state() == 'pending') {

	$update = "update orders set email_sent = 'S' WHERE orderid =". {orderid};
	sc_exec_sql($update);
        sc_actionbar_state('ajax_btn', 'sent');

} else {

	$update = "update orders set email_sent = 'N' WHERE orderid =". {orderid};
	sc_exec_sql($update);
        sc_actionbar_state('ajax_btn', 'pending');

}

Example - Display of the state of the ajax_btn button according to the value stored in the email_sent ield in the onRecord event of the Grid application.

if ({email_sent} == 'S') {

    sc_actionbar_state('ajax_btn', 'sent');

} else {

    sc_actionbar_state('ajax_btn', 'pending');

}

Watch a tutorial

This macro allows the execution of JavaScript methods called from some events from form, control, and calendar applications.

To use this macro you need to create a javascript method in the Programming settings.

This macro receives two parameters:

The firs parameter (required) receive the javascript method name.
The second (optional) receive an array with the method parameters on it.


Examples:

Ex. 1: Method javascript without parameters:
sc_ajax_javascript('method_name');
sc_ajax_javascript('sum');

Ex. 2: Method javascript with a parameter:
sc_ajax_javascript('method_name', array("parameter"));


Ex. 3: Method javascript with two parameters:
sc_ajax_javascript('method_name', array("param1","param2"));

Example using global variables:
sc_ajax_javascript('sum', array([num1],[num2]));

Watch a tutorial

This macro allows the application to show customizable messages. Its use is restricted to AJAX events of Form/Control applications.

This macro is only available in applications with AJAX support.

Table2: Message Parameters String

Example 01

sc_ajax_message ("Message", "Title", "timeout=0");

Example 02: Using Toast

sc_ajax_message ("Client", "Title", "toast=Y&toasto_pos=center-start&type=success");

To display the message using Toast, this option must be enabled in the application interface.

This macro is used especially in Ajax events of a Grid application with the purpose of reloading the Grid data (refresh).

Ex:

sc_ajax_refresh();

Watch a tutorial

This macro sends a message in the alert style of Javascript (Sweetalert) or Sweetalert2.

Ps  

To display the message using a sweetalert2 library, the Use SweetAlert option must be enabled in the application where the macro will be used.  

This option can be enabled in the application's configuration menu. To access the click on: Application> Configuration the option is in the Notification Settings block

Check below the parameters supported by the macro:

• Message: Mandatory parameter that contains the message that will be displayed.
• $array: This parameter is optional when using the macro, more mandatory when we want to use Sweetalert2.
  When used, it expects to receive an array with Sweetalert2's settings.

Check the list of configurations accepted by Sweetalert2 in this macro:

Check below the examples of use of the macro:

E.g.: Message using Sweetalert
sc_alert("This is an alert message!!");

E.g.: Message using Sweetalert2

$params = array(
'title' => 'Title',
'type' => 'success',
'timer' => '2000',
'showConfirmButton' => false,
'position' => 'bottom-end',
'toast' => true
);

sc_alert("Inserted successfully!", $params);

This macro is used to download the files stored in the Storage services available in Scriptcase, they are: Google Drive, DropBox and Amazon S3.

First of all, it is necessary to create the keys to use these APIs, either for use with the macro or through the tool interface.

See below for how to obtain the credentials for each of them.

• Click here to learn how to get Google Drive credentials
• Click here to learn how to get DropBox credentials
• Click here to learn how to get Amazon S3 credentials

See the list of parameters below.

Using the macro with profile

The use of the macro with a profile requires the prior creation of the same.

Click here to see how to create a profile on each of the available storage APIs.

The profile contains the data to use the desired API, thus, when using a profile in the macro, it is not necessary to use the settings parameter.

The profile parameter accepts only the name of the profile created, for the dynamic use of the macro, it will be necessary to use the settings parameters.

Example of using the macro with the profile.

sc_api_download([
  'profile' => 'myApi',
  'file' => {file}, 
  'destination' => {destination},
]);

Using the macro with settings parameter

The array with the access credentials that must be passed in the settings parameter varies according to the API used.

See below how to use this parameter according to each of the available APIs.

When using the settings parameter in the configuration in the macro, it is not necessary to inform a profile.

Using The Macro With Settings - Google Drive API

First, we must have the credentials for using the Google Drive API in hand, click here to learn how to obtain them.

After configuring the credentials, see below all the values of the array that must be passed in the settings parameter using the Google Drive API.

All values below are mandatory when using the settings parameter

Examples when using the macro in Google Drive implementing the parameter settings 

sc_api_download([
  'settings' => [
    'app_name' => {appname},
    'gateway' => 'google_drive',
    'json_oauth' => {jsonoauth},
    'auth_code' => {authcode},
    'token_code' => {tokencode},
  ],
'file' => {files},
'destination' => {destination},
]);

Using A Macro With Settings - Dropbox

First, we must have the credentials for using the Google Drive API in hand, click here to learn how to obtain them.

After configuring the credentials, see below all the values of the array that must be passed in the settings parameter using the Dropbox API.

All values below are mandatory when using the settings parameter

Examples when using the macro in Dropbox implementing the parameter settings 

sc_api_download([
  'settings' => [
    'gateway' => 'dropbox',
    'api_key' => {apikey},
    'api_secret' => {apisecret},
    'access_token' => {accesstoken},
  ],
'file' => {file},
'destination' => {destination},
]);

Using The Macro With Settings - Amazon S3

First, we must have the credentials for using the Amazon S3 STORAGE API in hand, click here to learn how to obtain them.

After configuring the credentials, see below all the values of the array that must be passed in the settings parameter using the Amazon S3 API.

All values below are mandatory when using the settings parameter]

Examples when using the macro in Amazon S3 implementing the parameter settings 

sc_api_download([
'settings' => [
'app_name' => 'scriptcase',
    'gateway' => 'S3',
    'api_key' => {apikey},
    'api_secret' => {apisecret},
    'region' => {api_region},
    'bucket' => {api_bucket},
  ],
'file' => {file},
'destination' => {destination},
]);

1. app_name - Receive the app_name, available in your api configuration. This parameter accepts strings or variable.
2. json_oauth - Receive the content of the json file, this file is available for download in your api settings. This parameter accepts strings or variable.

For more usage and example information visit our knowledge base article: How to generate the auth code and token code

This macro is used to upload files to the cloud using the Google, Amazon and DropBox Storage APIs.

First of all, it is necessary to create the keys for using the API, either with the macro or in the fields interface.

• Click here to learn how to get Google Drive credentials
• Click here to learn how to get DropBox credentials
• Click here to learn how to get Amazon S3 credentials

After obtaining the credentials, proceed with the macro configuration.

See the list of parameters below.

As seen above, the settings parameter receives an array with the access credentials for the API used.

This parameter should be used only when we have not defined a profile in the Tools> API menu

Each API has its own settings for the settings parameter, see below how each should be configured. 

Using the macro with profile

The use of the macro with a profile requires the prior creation of the same.

Click here to see how to create a profile on each of the available storage APIs.

The profile contains the data to use the desired API, thus, when using a profile in the macro, it is not necessary to use the settings parameter.

The profile parameter accepts only the name of the profile created, for the dynamic use of the macro, it will be necessary to use the settings parameters.

Example of using the macro with the profile.

sc_api_upload([
   'profile' => 'profile_name',
   'file' => {file},
   'parents' => 'folder_name',
]);

Using the macro with settings parameter

The array with the access credentials that must be passed in the settings parameter varies according to the API used.

See below how to use this parameter according to each of the available APIs.

When using the settings parameter in the configuration in the macro, it is not necessary to inform a profile.

Using the macro with settings - Google Drive API

First, we must have the credentials for using the Google Drive API in hand, click here to learn how to obtain them.

After configuring the credentials, see below all the values of the array that must be passed in the settings parameter using the Google Drive API.

All values below are mandatory when using the settings parameter

Examples when using the macro in Google Drive implementing the parameter settings 

sc_api_upload([
   'settings' => [
       'app_name' => 'scriptcase',
       'gateway' => 'google_drive',
       'json_oauth' => '',
       'auth_code' => '',
       'token_code' => '',
   ],
   'file' => {file},
   'parents' => '',
]);

Using a macro with settings - Dropbox

First, we must have the credentials for using the Google Drive API in hand, click here to learn how to obtain them.

After configuring the credentials, see below all the values of the array that must be passed in the settings parameter using the Dropbox API.

All values below are mandatory when using the settings parameter

Examples when using the macro in Dropbox implementing the parameter settings 

sc_api_upload([
   'settings' => [
       'app_name' => 'scriptcase',
       'gateway' => 'dropbox',
       'api_key' => '',
       'api_secret' => '',
       'access_token' => '',
   ],
   'file' => {file},
   'parents' => '',
]);

Using the macro with settings - Amazon S3

First, we must have the credentials for using the Amazon S3 STORAGE API in hand, click here to learn how to obtain them.

After configuring the credentials, see below all the values of the array that must be passed in the settings parameter using the Amazon S3 API.

All values below are mandatory when using the settings parameter

Examples when using the macro in Amazon S3 implementing the parameter settings 

sc_api_upload([
   'settings' => [
       'app_name' => 'scriptcase',
       'gateway'  => 'S3',
       'api_key' => '',
       'api_secret' => '',
       'region' => '',
       'bucket' => '',
   ],
   'file' => {file},
   'parents' => '',
]);

Watch a tutorial

This macro allows modifying the property of the application. The user can determine if a Form will start in insert mode, or a Grid starts by the filter, etc.

This macro must be used by one application to modify the properties of another application.

Properties for Form applications

Property for Grid applications

Property for all applications

Ex. 1: Forces the "my_form" application to start in the addition mode.
sc_apl_conf("my_form", "start", "new");

Ex. 2: Doesn't allow the "my_form" application make addition of new registers.
sc_apl_conf("my_form", "add", "off");

Ex. 3: Sets "my_field" on the application "my_form" (readonly attribute) to "true" dinamically.
sc_apl_conf("my_form", "field_display_off", "my_field");

Ex. 4: Shows "my_field" on the application "my_form" dinamically.
sc_apl_conf("my_form", "field_display_on", "my_field");

Ex. 5: Forces the "my_grid" application to start by filter.
sc_apl_conf("my_grid", "start", "filter");

Ex. 6: Forces the "my_grid" application to show 20 lines.
sc_apl_conf("my_grid", "rows", "20");

Ex. 7: Hides "my_field" on the application "my_form" dinamically.
sc_apl_conf("my_form", "field_display_off", "my_field");

Ex. 8: Use the button on the toolbar menu.
if ({sc_menu_item} == "btn_1")
{
sc_apl_conf("form_customer", "start", "new");
}

Watch a tutorial

This macro allows that the user defines in your initial application what will happen when the application lost the session.

The macro has the following parameters:

Apl: Here it is necessary to inform which application the macro will redirect after lost the session.

Type: Here we will inform the redirecting type that will occur. There are two types:

• R: The application will only redirect to the initial application.
• M: Will be shown a message before the redirecting.

Example: In a login application defined as the initial application, we can define that this application will redirect to himself.
sc_apl_default("app_login","R")

Watch a tutorial

Used to control security access. These macros activate/deactivate the applications that a user has access to.

Application: Is the name or the variable that contains the name of the application to be activated/deactivated.
Status: Is the value or variable that contains the value to be attributed to the application. The values are: "on" to activate and "off" to deactivate.

Ex. 1:
sc_apl_status ('atu_cad', 'off');


Ex. 2:
sc_apl_status ({var_name_appl}, {var_status});

Watch a tutorial

Adds an item to a menu application dynamically.

It is only possible to use this macro when there is an array created before by the macro sc_appmenu_create.

Ex. 1: Creates a menu named menu_main.
sc_appmenu_create('menu_main');


Ex. 2: Adds a on the menu_main the the item_1 named Category.
sc_appmenu_add_item('menu_main','item_1','','Category','');


Ex. 3: Adds a on the menu_main (item_2) the item_1 name Category linked to the form_category passing a few parameters.
sc_appmenu_add_item('menu_main','item_2','item_1','Category Form','form_category','param1=value;param2=value');

Watch a tutorial

This macro starts or uses an array for a dynamic montage of a menu application. You must be informed or you will not apply the menu as a parameter.

This macro should be used in events of control or not event onload of the menu.

Ex. 1:
sc_appmenu_create ('menu_main');

Watch a tutorial

This macro should be used in events of control or not event onload of the menu.

Ex. 1:
sc_appmenu_create ('menu_main');

Check if a menu item exists and return a true or false value.

Ex. 1:

if(sc_appmenu_exist_item('menu_main', 'item_2')){

sc_appmenu_update_item('menu_main','item_2','item_1','Category Form','form_category');

}
else{

sc_appmenu_add_item('menu_main','item_2','item_1','Category Form','form_category');

}

Watch a tutorial

This macro dynamically removes a menu item.

To use this macro it is necessary to execute the macro sc_appmenu_create before.

Ex. 1:
sc_appmenu_remove_item('menu_main','item_2');

Watch a tutorial

This macro resets the array used in the dynamic creation of a menu application.

This macro is expecting the menu application name as the single parameter.

Ex. 1:
sc_appmenu_reset('menu_main');

Watch a tutorial

Updates an application menu item dynamically

It is only possible to use this macro when there is an array created before by the macro sc_appmenu_create.

It is only possible to use this macro on items created before by the macro sc_appmenu_add_item.

Ex. 1:
sc_appmenu_update_item('menu_main','item_2','item_1','Category Form','form_category');

Watch a tutorial

This macro starts a set of transactions in the database.

For the use of this macro you need to have a transactional database.

In form applications, the events (onAfterInsert, onAfterUpdate, onAfterDelete, onBeforeInsert, onBeforeUpdate or onBeforeDelete) are automatically protected by a transaction control, since the connection is the same of the application.

In the other cases, if the user need to make a transaction control, must begin with this macro and finish with the sc_commit_trans() macro to confirm the updates or sc_rollback_trans() to cancel the transactions.

The "connection" parameter is optional, necessary only if the command is executed in a different connection from the actual application.

Watch a tutorial

Dynamically determines the display fields of a specific block.

By default, all the blocks are displayed ("on" condition).

Ex. 1:
if ({type_customeri} == "personal")
{
sc_block_display(company, off);
}
else
{
sc_block_display(personal, off);
}

Ex 2: Using a local variable as second parameter

$var = "off";

sc_block_display(company, $var);

Obs: In grids, this macro only works with "slide" orientation.

Watch a tutorial

Available when the "Copy" button is clicked. It can be tested and used inside the ScriptCase events, allowing specific programming in run time.

Ex. 1:

if (sc_btn_copy)

{

sc_message("Record copied successfully!");

}

Watch a tutorial

Available when the "Delete" button is clicked. It can be tested and used inside the ScriptCase events, allowing specific programming in run time.

Ex. 1:
if (sc_btn_delete)
{
sc_error_message("Unable to delete this record");
}

Watch a tutorial

This macro is used to disable or enable buttons from a Menu application.

Ex:

sc_btn_disable('btn_2', 'off');

Watch a tutorial

This macro is intended to dynamically enable or disable a toolbar button.

It has two required parameters:

Name of Grid buttons

Name of Form buttons

Name of Control Buttons

Example: Enabling delete button only for admin user

if ( [user_login] == 'admin' ) {

    sc_btn_disabled('delete', 'on');

} else {

    sc_btn_disabled('delete', 'off');

}

Watch a tutorial

Activate toolbars buttons on the application in execution time.

Button_Name: Is the variable name that contains the name of the button to be activated/deactivated.

Buttons Name (Grid):

group displays the "Group By" button in the grid.

Buttons Name (Form):

Buttons Name (Control):

OBS. Remember that the button's name must be lowercase.

Ex. 1:
sc_btn_display ('new', 'off');

Ex. 2: Using a local variable as second paramenter

$var = "off";
sc_btn_display ('new', $var);

Ex. 3: If we use variables or fields ({Fields} or [Global_Variables]) as parameters its not allowed the use of the quotes or single quotes.
sc_btn_display ({variavle_button}, 'off');

Watch a tutorial

Available when the "Add" button is clicked. It can be tested and used inside the ScriptCase events, allowing specific Programmation in run time.

Ex. 1:
if (sc_btn_insert)
{
sc_message("Record inserted successfully");

}

Watch a tutorial

This macro is used to dynamically change the label of the buttons, whether they are created by the developer or Scriptcase's own.

For this, it is necessary to inform two mandatory parameters, 'btn_name' and 'new_label'.

Click here and see examples of using the macro.

Nombre de los botones de cuadrícula

Name of Form buttons

Name of Control Buttons

Exemplo: Parameter with string

sc_btn_label('update', 'Atualizar Registro');

Example: Parâmetro com lang

sc_btn_label("update", {lang_btn_label});

Example:Parameter with Global variable

[btn_name] = "update";
[label] = "update";
sc_btn_label([btn_name], [label]);

Example: Parameter with local variable

$btn_name = "update";
$label= "update";
sc_btn_label($btn_name, $label);

Watch a tutorial

Available when the "Add New" button is clicked. It can be tested and used inside the ScriptCase events, allowing specific programming in run time.

Ex. 1:
if (sc_btn_new)
{
{My_Date} = date('Y/m/d');
}

Watch a tutorial

Available when the "Save" button is clicked. It can be tested and used inside the ScriptCase events, allowing specific programming in run time.

Ex. 1:
if (sc_btn_update)
{
sc_error_message("Record updated successfully");
}

Watch a tutorial

Calculate verifier (checksum) digits.

Ex. 1:
sc_calc_dv({my_dv}, {my_rest}, 1234567, 11, 98765432, 1);
Parcels calculation: 7x2= 14 ; 6x3=18 ; 5x4=20 ; 4x5=20 ; 3x6=18 ; 2x7=14 ; 1x8=8
Parcels sum : 14 + 18 + 20 + 20 + 18 + 14 + 8 = 112
Rest of the division of 112 / 11 = 2
Digit: 11 - 2 = 9

Ex. 2:
sc_calc_dv({my_dv}, {my_rest}, 1234567, 10, 12, 2);
Parcels calculation: 7x2= 14 ; 6x1=6 ; 5x2=10 ; 4x1=4 ; 3x2=6 ; 2x1=2 ; 1x2=2
Parcels sum: 1 + 4 + 6 + 1 + 0 + 4 + 6 + 2 + 2 = 26
Rest of the division of 26 / 10 = 6
Digit: 10 - 6 = 4

It allows us to use Scriptcase built-in APIs. We currently offer integration with the Mandrill and Amazon SES APIs.

This macro has two parameters:

Example 1 - Parameter $arr_settings, array with the API information

$settings = array( 'settings' => ['gateway' => 'mandrill', 'api_key'=> {api_key}] );

$mandrill = sc_call_api('', $settings);

Example 2 - Sending email using mandrill.

$txt_no_tags = strip_tags({msg});

$arr_merge = array(
                 'name'  => '',
                 'type'  => 'to',
                 'email' => 'exemplo@exemplo.com'
             );

$var_config = array( 'settings' => ['gateway' => 'mandrill', 'api_key'=> {api_key}] );

$mandrill = sc_call_api('', $var_config);
$var_msg = array(
               'from_email'                     => {from_email},
               'from_name'                      => {from_name},
                'html'                          => {msg},
                'text'                          => $txt_no_tags,
                'to'                            => array($arr_merge),              
                'subject'                       => {subject},
                'important'                     => true,            
                'auto_text'                     => null,
                'auto_html'                     => null,
                'inline_css'                    => null,
                'metadata'                      => array('website' => 'www.scriptcase.net')
    );

$async = false;
$retorno = $mandrill->messages->send($var_msg, $async);

Example 3 - Sending SMS using clickatell.

$var_config     = array( 
  'message'     => [
    'to'      => {sms_to},
    'message'     => {sms_txt},
    ],
    'settings'    => [
    'gateway'   => {gateway},
    'auth_token'  => {auth_token},
    ] 
);

sc_send_sms($var_config);

Example 4 - Using the macro with PagSeguro

  $arr_settings = [
            'gateway' => 'pagseguro',
            'environment' => 'sandbox',
            'auth_email' => 'exemplo@gmail.com',
            'auth_token' => '72AE21503DDA4840BE1DC7945F6D1CE1'
                 ];
sc_call_api('',$arr_settings);

Example 5 - Using the macro with PayPal

  $arr_settings = [
            'gateway' => 'paypal',
            'environment' => 'sandbox',
            'auth_email' => 'exemplo@gmail.com',
            'auth_token' => '72AE21503DDA4840BE1DC7945F6D1CE1'
                 ];
sc_call_api('',$arr_settings);

Dynamically controls whether the captcha/recaptcha configured in the application is displayed.

To use the macro, the application must be previously configured with the resource.

Example

if ( $_SERVER['REMOTE_ADDR'] == '127.0.0.1' ) {

    sc_captcha_display("on");

} else {

    sc_captcha_display("off");

Watch a tutorial

This macro is used to check if the field name has been changed.

Ex. 1:
if (sc_changed({my_field}))
{
Echo "Field have been changed";
}

Watch a tutorial

This macro dynamically change the application connections

Ex. 1: To change the connections:

sc_change_connection("Old_Concection01", "New_Connection01" ; "Old_Concection02", "New_Connection02");

Allows to change more then one application/connection in one command. Multiple connections can be passed as parameters that must be separated by a ";".

Ex. 2: Using variables:

sc_change_connection([Global_Connetion], [Test_Connection]);

The changes take effect in the following applications.

Ex. 3: Changing the application main connection

sc_change_connection({Password}, [Test] ; "My_Connection", [Global_Connection]);

The changes take effect in the following applications.

Ex. 4: To delete the exchange:

To recover your previous settings you can use the sc_reset_change_connection(); macro

This macro allows changing CSS attributes of application fields.

Parameter List

Example

Example of changing the font color and using the attribute sc_badge

switch({taskstatus}) {
	case 'COMPLETED':
		sc_change_css('color', '#dcfce7', 'taskstatus');
		sc_change_css('sc_badge', 'green', 'taskstatus');
		break;
		
	case 'IN-PROGRESS':
		sc_change_css('color', '#1e40af', 'taskstatus');
		sc_change_css('sc_badge', 'blue', 'taskstatus');
		break;
		
	case 'NOT-STARTED':
		sc_change_css('color', '#991b1b', 'taskstatus');
		sc_change_css('sc_badge', 'red', 'taskstatus');
		break;
}

Example of the macro with css attribute:

switch({taskstatus}) {
	case 'COMPLETED':
		sc_change_css('color', '#166534', 'taskstatus');
		sc_change_css('background-color', '#dcfce7', 'taskstatus');
		sc_change_css('padding-right', '0.6em', 'taskstatus');
		sc_change_css('padding-left', '0.6em', 'taskstatus');
		sc_change_css('border-radius', '14px', 'taskstatus');
		sc_change_css('font-weight', 'bold', 'taskstatus');
		sc_change_css('width', 'fit-content', 'taskstatus');
		sc_change_css('display', 'block', 'taskstatus');
		sc_change_css('padding-top', '0.2em', 'taskstatus');
		sc_change_css('padding-bottom', '0.2em', 'taskstatus');
		sc_change_css('font-size', '60%', 'taskstatus');
		sc_change_css('margin', '10%', 'taskstatus');
		break;
		
	case 'IN-PROGRESS':
		sc_change_css('color', '#1e40af', 'taskstatus');
		sc_change_css('background-color', '#dbeafe', 'taskstatus');
		sc_change_css('padding-right', '0.6em', 'taskstatus');
		sc_change_css('padding-left', '0.6em', 'taskstatus');
		sc_change_css('border-radius', '14px', 'taskstatus');
		sc_change_css('font-weight', 'bold', 'taskstatus');
		sc_change_css('width', 'fit-content', 'taskstatus');
		sc_change_css('display', 'block', 'taskstatus');
		sc_change_css('padding-top', '0.2em', 'taskstatus');
		sc_change_css('padding-bottom', '0.2em', 'taskstatus');
		sc_change_css('font-size', '60%', 'taskstatus');
		sc_change_css('margin', '10%', 'taskstatus');
		break;
		
	case 'NOT-STARTED':
		sc_change_css('color', '#991b1b', 'taskstatus');
		sc_change_css('background-color', '#fee2e2', 'taskstatus');
		sc_change_css('padding-right', '0.6em', 'taskstatus');
		sc_change_css('padding-left', '0.6em', 'taskstatus');
		sc_change_css('border-radius', '14px', 'taskstatus');
		sc_change_css('font-weight', 'bold', 'taskstatus');
		sc_change_css('width', 'fit-content', 'taskstatus');
		sc_change_css('display', 'block', 'taskstatus');
		sc_change_css('padding-top', '0.2em', 'taskstatus');
		sc_change_css('padding-bottom', '0.2em', 'taskstatus');
		sc_change_css('font-size', '60%', 'taskstatus');
		sc_change_css('margin', '10%', 'taskstatus');
		break;
}

Watch a tutorial

This macro is used to confirm a transaction set in the database.

In form applications, there are events that perform transactions with the database (Ex: onAfterInsert, onAfterUpdate, onAfterDelete, onBeforeInsert, onBeforeUpdate, onBeforeDelete, etc...).
The transaction control of these events is done by Scriptcase itself if the connection provided is the same as the application.
However, if the user has to perform any type of redirection in these events, it is necessary to use the macro sc_commit_trans before the redirect to secure the transactions previously performed.

Ex: onAfterUpdate - Using redirection after update a record:

sc_commit_trans();


sc_redir('grid_main');

The "connection" parameter is optional, being necessary only if the command is executed in a different database specified to the application.

Watch a tutorial

This macro returns a string resulting from a definition of two or more values Can be used in the lookup of fields or events together with the macros sc_lookup() and sc_select()

Makes concat formatting according to your database.

Ex. 1: Use(Editing Lookup):

SELECT field1, sc_concat(field2,' - ',field3) FROM table

Ex. 2: Using the macro with sc_lookup:

sc_lookup(Dataset,"SELECT field1,sc_concat(field2, ' - ' ,field3) FROM table");

Watch a tutorial

This macro is used to confirm that the action must be really executed, preventing mistakes.

Valid only in the PHP programming code that runs when called through a toolbar button.

Parameter

This macro has only one parameter, which is the confirmation message that will be displayed.

Example:
sc_confirm("Do you really wish to execute this action??");

Related Links
See a practical example of how to use the sc_confirm macro

Watch a tutorial

La conexión editada solo estará disponible en la próxima aplicación.

1º Parameter: Connection name to be edited.

2º Parameter: Array of items containing the connection information to be edited. Check out the indices of the array:

Note:Is not required to use all the indices in the array, we can pass only the required ones.

Example:

$arr_conn = array();

$arr_conn['user'] = "admin2";
$arr_conn['password'] = "admin2pass";
$arr_conn['database'] = "sc_samples2";

sc_connection_edit("sc_connection", $arr_conn);

Watch a tutorial

When used, the macro creates a new connection with the information inserted in its parameters. This connection is available throughout the current session Scriptcase and ceases to exist when the session is closed.

The new connection will only be available in the next application.

1º Parameter: Connection name.

Note: If there is a connection created within the Scriptcase with the same name, this macro has no effect. Connections created within the Scriptcase prevail. If you want to edit an existing connection, see the documentation for the macro sc_connection_edit.

2º Parameter: Array of items containing the connection information. Check out the indices of the array:

Note: It is required that all items are filled, with the exception of items ['persistent'] and ['encoding'].

See below the driver's list:

Example:

$arr_conn = array();

$arr_conn['drive'] = "mysqlt";
$arr_conn['server'] = "127.0.0.1";
$arr_conn['user'] = "root";
$arr_conn['password'] = "pass123";
$arr_conn['database'] = "sc_samples";
$arr_conn['persistent'] = "Y";
$arr_conn['encoding'] = "utf8";

sc_connection_new("new_conn_mysql", $arr_conn);

Watch a tutorial

This macro has the aim to calculate the increment or decrement of dates. For its use are necessary some parameters as follows:

Ex. 1:
{birthdate} = sc_date({birthdate}, "dd/mm/yyyy", "+", 30, 0, 0);

Ex. 2:
$new_date = sc_date({birthdate}, "yyyy-mm-dd", "-", 15, 3, 2);

Ex. 3:
{inclusion_dt} = sc_date(date('Ymd'), "yyyymmdd", "-", 0, 1, 1);

OBS: To be certified of the date format, before use the function, try it in any event:
echo "form_date =". {name of the field date};

Watch a tutorial

This macro converts the date field passed as a parameter with an input format to another field with an output format.

Check below the list of parameters for this macro and the accepted values.

For more information on the data strings consult the PHP Manual

Ex. 1: Converts the date from"dd/mm/yyyy" format to the "yyyymmdd" format.

{field_date} = sc_date_conv({field_date}, "dd/mm/aaaa", "aaaammdd");

Ex. 2: Converts the date from the database native format to "dd/mm/yyyy" format.

{field_date} = sc_date_conv({field_date}, "db_format", "dd/mm/aaaa");

Ex. 3: Converts the date from the "dd/mm/yyyy" format to the Database native format(db_format).

{field_date} = sc_date_conv({field_date}, "dd/mm/aaaa", "db_format");

Ex. 4: Converting the date from the database's native format (db_format) to the regional setting format (sc_format_region)

{field_date} = sc_date_conv({field_date},"db_format","sc_format_region");

Ex. 5: Converting the date from the "yyyy-mm-dd" to the regional Setting format (sc_format_region)

{field_date} = sc_date_conv({field_date},"aaaa-mm-dd","sc_format_region");

Watch a tutorial

Calculates the difference between two dates (passed as parameters) in days.

Ex. 1:
{amount_days} = sc_date_dif({date1}, "aaaa-mm-dd", {date2}, "mm/dd/aaaa");

Ex. 2:
{amount_days} = sc_date_dif("2000-05-01", "aaaa-mm-dd", "04/21/2004", "mm/dd/aaaa");
{amount_days} would be equal to -1451 (days)

Note: Formats can be different but must be in days, months and years.

Watch a tutorial

Calculates the difference between two dates (passed as parameters) returning the number of days, months, and years.

The result is returned in an array structure, where index 0 have the number of days, index 1 has the number of months and the index 2 have the number of years.

Ex. 1:
$diferences = sc_date_dif_2 ({date1}, "yyyy-mm-dd", {date2}, "mm/dd/yyyy", 1);
{dif_days} = $diferences[0];
{dif_months} = $diferences[1];
{dif_years} = $diferences[2];

Ex. 2:
$diferences = sc_date_dif_2 ("2000-05-01", "yyyy-mm-dd", "04/21/2004", "mm/dd/yyyy", 1);
$diferences[0] = 20 (days)
$diferences[1] = 11 (months)
$diferences[2] = 3 (years)

Ex. 3: Using the option 2
$diferences = sc_date_dif_2 ("2000-05-01", "yyyy-mm-dd", "04/21/2004", "mm/dd/yyyy", 2);
$diferences[0] = 21 (days)
$diferences[1] = 11 (months)
$diferences[2] = 3 (years).

Note: Formats between the two dates can be different but it must have days, months and years. You also need to know the internal format being returned for the macro to work correctly.

Watch a tutorial

This macro checks if a date field is empty.

Ex. 1:
if (sc_date_empty({my_date}) )
{
sc_error_message("Invalid Date");
}

Watch a tutorial

This macro returns the encrypted field or variable to its original value.

Ex. 1: Using a local variable:
{my_field} = sc_decode($field_crypt);

Ex. 2: Using an user variable:
$my_var = sc_decode($field_crypt);

Note: Scriptcase's owner, Netmake, isn't responsible by the cryptography algorithm integrity (it is an open-source algorithm)

Watch a tutorial

Returns the field or variable with the content encrypted.

Ex. 1: Encrypting a local variable:
$field_crypt = sc_encode({my_field});

Ex. 2: Encrypting an user variable:
$field_crypt = sc_encode($my_var);

Note: Netmake isn't responsible by the encrypting algorithm integrity, (The algorithm provided is open source).

Watch a tutorial

This variable returns a string with a database error message, which occurs by trying to exclude a record.

It is used when there is a need to treat these messages.

Like for example, in case of database validations via triggers or procedures that they return messages.

Ex. 1: Content of the variable {sc_error_delete}, returning an error message generated by database trigger using

MsSQL.“[Microsoft] [ODBC SQL Server Driver] [SQL Server] You can't erase this register.”

Note: To access the database return error, sees the macro "sc_error_continue".

Watch a tutorial

The use of this macro results in the interruption of the application.
This way, any processing that will be executed after the use of the Marco or is being executed at the moment will be interrupted.
Here you can see an example of the macro's use.

This macro should be used after the macro
sc_error_message();

This macro can be used in two ways: Without parameters sc_error_exit(); that just interrupts the application or informing one URL/application that the user will redirect when the error is shown.

 

When we inform one destiny application or URL and the Target parameter is not informed the _self will be used as default.

Ex. 1: Show only an error message.

sc_error_message('Error message!');
sc_error_exit();

Ex. 2: Show an error message and an "OK" button to redirect to the URL informed.

sc_error_message('Error message');
sc_error_exit(http://www.mysite.com);

Ex. 3: Show an error message and an "OK" button to redirect to the application informed.

sc_error_message('Error message');
sc_error_exit(my_application, "_blank");

Watch a tutorial

This variable returns a string with the database error, that occurs when adding a record. It is used when is needed to treat these messages. For example, in the case of database validations via triggers or procedures that returns a message.

Ex. 1: Variable {sc_erro_insert}, returning an error message generated by database trigger the using MS SQL

“[Microsoft] [ODBC SQL Server Driver] [SQL Server] You cannot add this record.”

Note: To access the return of the database error, see the macro "sc_error_continue".

Watch a tutorial

This macro generates an error message or error messages.

In "Form and Control" applications, the messages are presented together with other error messages found in the application, except when using the "sc_error_exit" macro.

In "Grid and Menu" applications the messages only will be presented through the "sc_error_exit" macro.

Ex. 1:
if ({discount} > 0.10 && [glo_usr] == 'operator')
{
sc_error_message("Discounting of " . {discount} . " above of the allowed one");
}

In this example, if the value in the discount field is over 0.10 and the user try to add or save this record, the operation is finished and the error message is presented. The command must finish with ");" (close parentheses and semicolon) used as a delimiter for the macro interpreter.

Watch a tutorial

This variable returns a string with a database error message that occurs when updating a record. It is used when there is a need to customize these messages. For example, in the case of database validations via triggers or procedures that return message.

Ex. 1: Variable {sc_error_update}, returning an error message generate by a database trigger using MS SQL.

“[Microsoft][ODBC SQL Server Driver][SQL Server] You can't update this record.”

Note: To have access to the return of database error see the macro "sc_error_continue".

This macro allows to condition the circumstances thats the SQL commands are executed.

The "Connection" parameter is optional. Required only, if the command is executed in a database different from the application.

Ex. 1:
if (sc_after_delete) {
sc_exec_sql("delete from mytable where key = {key_ant}");
}

Watch a tutorial

This macro can be used in the ScriptCase events and created a button and may return values/processes after the execution.

This option is only valid for Form and Control Applications.

Watch a tutorial

This macro is used to change/restore a grid field text color dynamically.

Ex. 1: Change the grid text field “customer_id” color.
sc_field_color ("customerid", "#33FF66");


Ex. 2: Change the "value_order” field text color, if the value is greater that 1000. Otherwise, use the default color.
if ({value_order} > 1000)
{
sc_field_color ("value_order", "#33FF66");
}
else
{
sc_field_color ("value_order", "");
}