components_node/object-forms-fields-options-details.js
/**
     * Get form field options details according to search parameters.
     * @param {*} terminal 0 - backend | 1 - frontend
     * @param {*} returnType 1 - array | 3 - Json Object | 10 - html
     * @returns {json}
     */
Get form field options details according to search parameters.
Get form field options details according to search parameters .
async recordDetailsGet(terminal = 0, returnType = 1)
    {
        try
        {
            this.resultsFormsFieldsOptionsDetails = await FunctionsDB.genericTableGet02(gSystemConfig.configSystemDBTableFormsFieldsOptions, 
                                                                                        this.arrSearchParameters, 
                                                                                        "", 
                                                                                        "", 
                                                                                        FunctionsGeneric.tableFieldsQueryBuild01(gSystemConfig.configSystemDBTableFormsFieldsOptions, "all", "string"), 
                                                                                        1, 
                                                                                        this.objSpecialParameters);
            this.tblFormsFieldsOptionsID = this.resultsFormsFieldsOptionsDetails[0].id;
            this.tblFormsFieldsOptionsIdFormsFields = this.resultsFormsFieldsOptionsDetails[0].id_forms_fields;
            this.tblFormsFieldsOptionsSortOrder = this.resultsFormsFieldsOptionsDetails[0].sort_order;
            this.tblFormsFieldsOptionsSortOrder_print = FunctionsGeneric.valueMaskRead(this.tblFormsFieldsOptionsSortOrder, gSystemConfig.configSystemCurrency, 3);
            this.tblFormsFieldsOptionsDateCreation = this.resultsFormsFieldsOptionsDetails[0].date_creation; 
            this.tblFormsFieldsOptionsDateTimezone = this.resultsFormsFieldsOptionsDetails[0].date_timezone;
            this.tblFormsFieldsOptionsDateEdit = this.resultsFormsFieldsOptionsDetails[0].date_edit;
            this.tblFormsFieldsOptionsOptionName = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsOptionsDetails[0].option_name, "db"); 
            this.tblFormsFieldsOptionsOptionNameFormatted = this.resultsFormsFieldsOptionsDetails[0].option_name_formatted ; 
            this.tblFormsFieldsOptionsConfigSelection = this.resultsFormsFieldsOptionsDetails[0].config_selection; 
            this.tblFormsFieldsOptionsConfigSelection_print = ""; 
            switch(this.tblFormsFieldsOptionsConfigSelection)
            {
                case 0:
                    this.tblFormsFieldsOptionsConfigSelection_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "FormsFieldsOptionsConfigSelection0");
                    break;
                case 1:
                    this.tblFormsFieldsOptionsConfigSelection_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "FormsFieldsOptionsConfigSelection1");
                    break;
            }
            this.tblFormsFieldsOptionsInfoSmall1 = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsOptionsDetails[0].info_small1, "db");
            this.tblFormsFieldsOptionsInfoSmall1_edit = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsOptionsDetails[0].info_small1, "db");
            this.tblFormsFieldsOptionsInfoSmall2 = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsOptionsDetails[0].info_small2, "db");
            this.tblFormsFieldsOptionsInfoSmall2_edit = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsOptionsDetails[0].info_small2, "db");
            this.tblFormsFieldsOptionsInfoSmall3 = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsOptionsDetails[0].info_small3, "db");
            this.tblFormsFieldsOptionsInfoSmall3_edit = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsOptionsDetails[0].info_small3, "db");
            this.tblFormsFieldsOptionsInfoSmall4 = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsOptionsDetails[0].info_small4, "db");
            this.tblFormsFieldsOptionsInfoSmall4_edit = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsOptionsDetails[0].info_small4, "db");
            this.tblFormsFieldsOptionsInfoSmall5 = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsOptionsDetails[0].info_small5, "db");
            this.tblFormsFieldsOptionsInfoSmall5_edit = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsOptionsDetails[0].info_small5, "db");
            this.tblFormsFieldsOptionsImageMain = this.resultsFormsFieldsOptionsDetails[0].image_main; 
            this.tblFormsFieldsOptionsActivation = this.resultsFormsFieldsOptionsDetails[0].activation;
            if(this.tblFormsFieldsOptionsActivation == 0)
            {
                this.tblFormsFieldsOptionsActivation_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "ItemActivation0");
            }
            if(this.tblFormsFieldsOptionsActivation == 1)
            {
                this.tblFormsFieldsOptionsActivation_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "ItemActivation1");
            }
        }catch(asyncError){
            if(gSystemConfig.configDebug === true)
            {
                console.log(asyncError)
            }
        }finally{
        }
    }
async recordDetailsGet ( terminal = 0 , returnType = 1 ) { try { this . resultsFormsFieldsOptionsDetails = await FunctionsDB . genericTableGet02 ( gSystemConfig . configSystemDBTableFormsFieldsOptions , this . arrSearchParameters , "" , "" , FunctionsGeneric . tableFieldsQueryBuild01 ( gSystemConfig . configSystemDBTableFormsFieldsOptions , "all" , "string" ) , 1 , this . objSpecialParameters ) ; this . tblFormsFieldsOptionsID = this . resultsFormsFieldsOptionsDetails [ 0 ] . id ; this . tblFormsFieldsOptionsIdFormsFields = this . resultsFormsFieldsOptionsDetails [ 0 ] . id_forms_fields ; this . tblFormsFieldsOptionsSortOrder = this . resultsFormsFieldsOptionsDetails [ 0 ] . sort_order ; this . tblFormsFieldsOptionsSortOrder_print = FunctionsGeneric . valueMaskRead ( this . tblFormsFieldsOptionsSortOrder , gSystemConfig . configSystemCurrency , 3 ) ; this . tblFormsFieldsOptionsDateCreation = this . resultsFormsFieldsOptionsDetails [ 0 ] . date_creation ; this . tblFormsFieldsOptionsDateTimezone = this . resultsFormsFieldsOptionsDetails [ 0 ] . date_timezone ; this . tblFormsFieldsOptionsDateEdit = this . resultsFormsFieldsOptionsDetails [ 0 ] . date_edit ; this . tblFormsFieldsOptionsOptionName = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsOptionsDetails [ 0 ] . option_name , "db" ) ; this . tblFormsFieldsOptionsOptionNameFormatted = this . resultsFormsFieldsOptionsDetails [ 0 ] . option_name_formatted ; this . tblFormsFieldsOptionsConfigSelection = this . resultsFormsFieldsOptionsDetails [ 0 ] . config_selection ; this . tblFormsFieldsOptionsConfigSelection_print = "" ; switch ( this . tblFormsFieldsOptionsConfigSelection ) { case 0 : this . tblFormsFieldsOptionsConfigSelection_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "FormsFieldsOptionsConfigSelection0" ) ; break ; case 1 : this . tblFormsFieldsOptionsConfigSelection_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "FormsFieldsOptionsConfigSelection1" ) ; break ; } this . tblFormsFieldsOptionsInfoSmall1 = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsOptionsDetails [ 0 ] . info_small1 , "db" ) ; this . tblFormsFieldsOptionsInfoSmall1_edit = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsOptionsDetails [ 0 ] . info_small1 , "db" ) ; this . tblFormsFieldsOptionsInfoSmall2 = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsOptionsDetails [ 0 ] . info_small2 , "db" ) ; this . tblFormsFieldsOptionsInfoSmall2_edit = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsOptionsDetails [ 0 ] . info_small2 , "db" ) ; this . tblFormsFieldsOptionsInfoSmall3 = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsOptionsDetails [ 0 ] . info_small3 , "db" ) ; this . tblFormsFieldsOptionsInfoSmall3_edit = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsOptionsDetails [ 0 ] . info_small3 , "db" ) ; this . tblFormsFieldsOptionsInfoSmall4 = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsOptionsDetails [ 0 ] . info_small4 , "db" ) ; this . tblFormsFieldsOptionsInfoSmall4_edit = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsOptionsDetails [ 0 ] . info_small4 , "db" ) ; this . tblFormsFieldsOptionsInfoSmall5 = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsOptionsDetails [ 0 ] . info_small5 , "db" ) ; this . tblFormsFieldsOptionsInfoSmall5_edit = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsOptionsDetails [ 0 ] . info_small5 , "db" ) ; this . tblFormsFieldsOptionsImageMain = this . resultsFormsFieldsOptionsDetails [ 0 ] . image_main ; this . tblFormsFieldsOptionsActivation = this . resultsFormsFieldsOptionsDetails [ 0 ] . activation ; if ( this . tblFormsFieldsOptionsActivation == 0 ) { this . tblFormsFieldsOptionsActivation_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "ItemActivation0" ) ; } if ( this . tblFormsFieldsOptionsActivation == 1 ) { this . tblFormsFieldsOptionsActivation_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "ItemActivation1" ) ; } } catch ( asyncError ) { if ( gSystemConfig . configDebug === true ) { console . log ( asyncError ) } } finally { } }
Get form field options details according to search parameters.
Get form field options details according to search parameters .
//terminal: 0 - backend | 1 - frontend //returnType: 1 - array | 3 - Json Object | 10 - html /**/ //Define values. //format: yyyy-mm-dd hh:MM:ss or yyyy-mm-dd //Debug. //console.log("this.resultsFormsFieldsOptionsDetails[0]=", this.resultsFormsFieldsOptionsDetails[0]); //console.log("this.tblFormsFieldsOptionsInfoSmall1=", this.tblFormsFieldsOptionsInfoSmall1); //console.log("this.tblFormsFieldsOptionsInfoSmall1_edit=", this.tblFormsFieldsOptionsInfoSmall1_edit); //console.log("this.arrSearchParameters=", this.arrSearchParameters);