components_node/object-forms-fields-details.js
/**
     * Get form field 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 details according to search parameters.
Get form field details according to search parameters .
async recordDetailsGet(terminal = 0, returnType = 1)
    {
        try
        {
            this.resultsFormsFieldsDetails = await FunctionsDB.genericTableGet02(gSystemConfig.configSystemDBTableFormsFields, 
                                                                                this.arrSearchParameters, 
                                                                                "", 
                                                                                "", 
                                                                                FunctionsGeneric.tableFieldsQueryBuild01(gSystemConfig.configSystemDBTableFormsFields, "all", "string"), 
                                                                                1, 
                                                                                this.objSpecialParameters);
            this.tblFormsFieldsID = this.resultsFormsFieldsDetails[0].id;
            this.tblFormsFieldsIdForms = this.resultsFormsFieldsDetails[0].id_forms;
            this.tblFormsFieldsSortOrder = this.resultsFormsFieldsDetails[0].sort_order;
            this.tblFormsFieldsSortOrder_print = FunctionsGeneric.valueMaskRead(this.tblFormsFieldsSortOrder, gSystemConfig.configSystemCurrency, 3);
            this.tblFormsFieldsDateCreation = this.resultsFormsFieldsDetails[0].date_creation; 
            this.tblFormsFieldsDateTimezone = this.resultsFormsFieldsDetails[0].date_timezone;
            this.tblFormsFieldsDateEdit = this.resultsFormsFieldsDetails[0].date_edit;
            this.tblFormsFieldsFieldType = this.resultsFormsFieldsDetails[0].field_type; 
            this.tblFormsFieldsFieldType_print = ""; 
            switch(this.tblFormsFieldsFieldType)
            {
                case 1:
                    this.tblFormsFieldsFieldType_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "FormsFieldsFieldType1");
                    break;
                case 2:
                    this.tblFormsFieldsFieldType_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "FormsFieldsFieldType2");
                    break;
                case 3:
                    this.tblFormsFieldsFieldType_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "FormsFieldsFieldType3");
                    break;
                case 4:
                    this.tblFormsFieldsFieldType_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "FormsFieldsFieldType4");
                    break;
                case 5:
                    this.tblFormsFieldsFieldType_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "FormsFieldsFieldType5");
                    break;
                case 6:
                    this.tblFormsFieldsFieldType_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "FormsFieldsFieldType6");
                    break;
                case 7:
                    this.tblFormsFieldsFieldType_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "FormsFieldsFieldType7");
                    break;
                case 8:
                    this.tblFormsFieldsFieldType_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "FormsFieldsFieldType8");
                    break;
                case 9:
                    this.tblFormsFieldsFieldType_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "FormsFieldsFieldType9");
                    break;
                case 10:
                    this.tblFormsFieldsFieldType_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "FormsFieldsFieldType10");
                    break;
            }
            this.tblFormsFieldsFieldName = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsDetails[0].field_name, "db"); 
            this.tblFormsFieldsFieldNameFormatted = this.resultsFormsFieldsDetails[0].field_name_formatted; 
            this.tblFormsFieldsFieldInstructions = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsDetails[0].field_instructions, "db"); 
            this.tblFormsFieldsFieldSize = this.resultsFormsFieldsDetails[0].field_size; 
            this.tblFormsFieldsFieldHeight = this.resultsFormsFieldsDetails[0].field_height; 
            this.tblFormsFieldsFieldFilter = this.resultsFormsFieldsDetails[0].field_filter; 
            this.tblFormsFieldsInfoSmall1 = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsDetails[0].info_small1, "db");
            this.tblFormsFieldsInfoSmall1_edit = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsDetails[0].info_small1, "db");
            this.tblFormsFieldsInfoSmall2 = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsDetails[0].info_small2, "db");
            this.tblFormsFieldsInfoSmall2_edit = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsDetails[0].info_small2, "db");
            this.tblFormsFieldsInfoSmall3 = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsDetails[0].info_small3, "db");
            this.tblFormsFieldsInfoSmall3_edit = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsDetails[0].info_small3, "db");
            this.tblFormsFieldsInfoSmall4 = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsDetails[0].info_small4, "db");
            this.tblFormsFieldsInfoSmall4_edit = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsDetails[0].info_small4, "db");
            this.tblFormsFieldsInfoSmall5 = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsDetails[0].info_small5, "db");
            this.tblFormsFieldsInfoSmall5_edit = FunctionsGeneric.contentMaskRead(this.resultsFormsFieldsDetails[0].info_small5, "db");
            this.tblFormsFieldsActivation = this.resultsFormsFieldsDetails[0].activation;
            if(this.tblFormsFieldsActivation == 0)
            {
                this.tblFormsFieldsActivation_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "ItemActivation0");
            }
            if(this.tblFormsFieldsActivation == 1)
            {
                this.tblFormsFieldsActivation_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "ItemActivation1");
            }
            this.tblFormsFieldsRequired = this.resultsFormsFieldsDetails[0].required;
            if(this.tblFormsFieldsRequired == 0)
            {
                this.tblFormsFieldsRequired_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "FormsFieldsRequired0");
            }
            if(this.tblFormsFieldsRequired == 1)
            {
                this.tblFormsFieldsRequired_print = FunctionsGeneric.appLabelsGet(gSystemConfig.configLanguageBackend.appLabels, this.labelPrefix + "FormsFieldsRequired1");
            }
        }catch(asyncError){
            if(gSystemConfig.configDebug === true)
            {
                console.log(asyncError)
            }
        }finally{
        }
    }
async recordDetailsGet ( terminal = 0 , returnType = 1 ) { try { this . resultsFormsFieldsDetails = await FunctionsDB . genericTableGet02 ( gSystemConfig . configSystemDBTableFormsFields , this . arrSearchParameters , "" , "" , FunctionsGeneric . tableFieldsQueryBuild01 ( gSystemConfig . configSystemDBTableFormsFields , "all" , "string" ) , 1 , this . objSpecialParameters ) ; this . tblFormsFieldsID = this . resultsFormsFieldsDetails [ 0 ] . id ; this . tblFormsFieldsIdForms = this . resultsFormsFieldsDetails [ 0 ] . id_forms ; this . tblFormsFieldsSortOrder = this . resultsFormsFieldsDetails [ 0 ] . sort_order ; this . tblFormsFieldsSortOrder_print = FunctionsGeneric . valueMaskRead ( this . tblFormsFieldsSortOrder , gSystemConfig . configSystemCurrency , 3 ) ; this . tblFormsFieldsDateCreation = this . resultsFormsFieldsDetails [ 0 ] . date_creation ; this . tblFormsFieldsDateTimezone = this . resultsFormsFieldsDetails [ 0 ] . date_timezone ; this . tblFormsFieldsDateEdit = this . resultsFormsFieldsDetails [ 0 ] . date_edit ; this . tblFormsFieldsFieldType = this . resultsFormsFieldsDetails [ 0 ] . field_type ; this . tblFormsFieldsFieldType_print = "" ; switch ( this . tblFormsFieldsFieldType ) { case 1 : this . tblFormsFieldsFieldType_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "FormsFieldsFieldType1" ) ; break ; case 2 : this . tblFormsFieldsFieldType_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "FormsFieldsFieldType2" ) ; break ; case 3 : this . tblFormsFieldsFieldType_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "FormsFieldsFieldType3" ) ; break ; case 4 : this . tblFormsFieldsFieldType_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "FormsFieldsFieldType4" ) ; break ; case 5 : this . tblFormsFieldsFieldType_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "FormsFieldsFieldType5" ) ; break ; case 6 : this . tblFormsFieldsFieldType_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "FormsFieldsFieldType6" ) ; break ; case 7 : this . tblFormsFieldsFieldType_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "FormsFieldsFieldType7" ) ; break ; case 8 : this . tblFormsFieldsFieldType_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "FormsFieldsFieldType8" ) ; break ; case 9 : this . tblFormsFieldsFieldType_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "FormsFieldsFieldType9" ) ; break ; case 10 : this . tblFormsFieldsFieldType_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "FormsFieldsFieldType10" ) ; break ; } this . tblFormsFieldsFieldName = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsDetails [ 0 ] . field_name , "db" ) ; this . tblFormsFieldsFieldNameFormatted = this . resultsFormsFieldsDetails [ 0 ] . field_name_formatted ; this . tblFormsFieldsFieldInstructions = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsDetails [ 0 ] . field_instructions , "db" ) ; this . tblFormsFieldsFieldSize = this . resultsFormsFieldsDetails [ 0 ] . field_size ; this . tblFormsFieldsFieldHeight = this . resultsFormsFieldsDetails [ 0 ] . field_height ; this . tblFormsFieldsFieldFilter = this . resultsFormsFieldsDetails [ 0 ] . field_filter ; this . tblFormsFieldsInfoSmall1 = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsDetails [ 0 ] . info_small1 , "db" ) ; this . tblFormsFieldsInfoSmall1_edit = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsDetails [ 0 ] . info_small1 , "db" ) ; this . tblFormsFieldsInfoSmall2 = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsDetails [ 0 ] . info_small2 , "db" ) ; this . tblFormsFieldsInfoSmall2_edit = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsDetails [ 0 ] . info_small2 , "db" ) ; this . tblFormsFieldsInfoSmall3 = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsDetails [ 0 ] . info_small3 , "db" ) ; this . tblFormsFieldsInfoSmall3_edit = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsDetails [ 0 ] . info_small3 , "db" ) ; this . tblFormsFieldsInfoSmall4 = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsDetails [ 0 ] . info_small4 , "db" ) ; this . tblFormsFieldsInfoSmall4_edit = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsDetails [ 0 ] . info_small4 , "db" ) ; this . tblFormsFieldsInfoSmall5 = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsDetails [ 0 ] . info_small5 , "db" ) ; this . tblFormsFieldsInfoSmall5_edit = FunctionsGeneric . contentMaskRead ( this . resultsFormsFieldsDetails [ 0 ] . info_small5 , "db" ) ; this . tblFormsFieldsActivation = this . resultsFormsFieldsDetails [ 0 ] . activation ; if ( this . tblFormsFieldsActivation == 0 ) { this . tblFormsFieldsActivation_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "ItemActivation0" ) ; } if ( this . tblFormsFieldsActivation == 1 ) { this . tblFormsFieldsActivation_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "ItemActivation1" ) ; } this . tblFormsFieldsRequired = this . resultsFormsFieldsDetails [ 0 ] . required ; if ( this . tblFormsFieldsRequired == 0 ) { this . tblFormsFieldsRequired_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "FormsFieldsRequired0" ) ; } if ( this . tblFormsFieldsRequired == 1 ) { this . tblFormsFieldsRequired_print = FunctionsGeneric . appLabelsGet ( gSystemConfig . configLanguageBackend . appLabels , this . labelPrefix + "FormsFieldsRequired1" ) ; } } catch ( asyncError ) { if ( gSystemConfig . configDebug === true ) { console . log ( asyncError ) } } finally { } }
Get form field details according to search parameters.
Get form field 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 //this.tblFormsFieldsFieldName_edit = "";  //this.tblFormsFieldsFieldInstructions_edit = "";  //Debug. //console.log("this.arrSearchParameters=", this.arrSearchParameters)