From wiki.ginstr.com
Revision as of 09:20, 6 April 2020 by Danijel (talk | contribs) (ACTION MESSAGES)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Dropdown database autocomplete text

Widget is represented by a label and dropdown below label. When user types suggestions are shown. Data that is saved to database is of datatype "text".

Widget id, ${gbamID}:

dropdownAutoCompleteText

Back to GBAM widgets table

Datatypes

Value is stored from widget to database as text datatype.

Predefined user data

PreLoaded

Properties panel

User will configure this data in properties panels of selected widget:

GENERAL
VALIDATIONS
    <columnText required="true|false"></columnText>
ACTION
  • "dropdown items", ${dropdownItemsList} = ${<item>${dropdownListItem}</item>} - repeats to how many dropdown items were entered by user
  • ${dropdownListItem} - single "dropdown items" item entered by user
ACTION MESSAGES
  • "message in case of missing read rights", is $defaultApp resource ${$noReadRightsToast}, if we override then it has to be formed {@string/${widgetID}NoReadRightsToast} - message which appears when user has no read rights to load widget data
DATABASE
  • "is part of database", checkbox option by default is set as checked. When checked database column is created for this widget.
  • "additional ginstr web column settings":
  • "align text", radio button options with values: "left", "middle", "right", add to configuration.xml:
<columnText>
    <horizontalAlignment>left|center|right</horizontalAlignment>
</columnText>
  • "list of allowed values" array with list of allowed values, add to configuration.xml:
<columnText>
  <valuesList>
    <value>val1</value>
    <value>val2</value>
  </valuesList>
</columnText>
  • "pattern", add to configuration.xml:
<columnText>
    <pattern errorMessage="invalidTextTableValue">[0-9A-Z]{3}</pattern>
</columnText>
  • "related unique columns", add to configuration.xml:
<columnText>
    <uniqueInsideList>
        <reference>
          <table>refTableId1</table>
          <column>refColumnField1</column>
        </reference>
        <reference>
          <table>refTableId2</table>
          <column>refColumnField2</column>
        </reference>
    </uniqueInsideList>
</columnText>

Code snippets

GBAM Code Variables

Variables which are used in code snippet below but not defined in user modifiable inputs.

Common widget code

<com.ginstr.widgets.GnTextView
    android:id="@+id/${widgetID}_label"
    android:layout_width="match_parent"
    android:layout_height="wrap_content"
    android:text="@string/${widgetID}"
    gn:style="@style/dropdownAutoCompleteText_label" />

<com.ginstr.widgets.GnAutoCompleteTextView
    android:id="@+id/${widgetID}_input"
    android:layout_width="match_parent"
    android:layout_height="wrap_content"
    gn:s_sourceType="database"
    gn:completionThreshold="1"
    gn:allowNonSelectedItems="true"
    gn:s_hint="@string/${widgetID}Hint"
    gn:dataType="text"
    gn:act_beforeLoad="
        [gn:act_if]|[[gn:act_hasTableRights]|[${widgetID}!=R]--
            [gn:act_toast]|[@string/${$noReadRightsToast}];
            [gn:act_break]|[]],
	[gn:act_rawQueryToWidgets]|[${widgetID},${widgetID}_input;${widgetID};@+id/${widgetID}_input]"
    gn:style="@style/dropdownAutoCompleteText_input"/>

strings.xml

Lines to be added for each language.

<string name="${widgetID}">${widgetLabel}</string>
<string name="${widgetID}Hint">${widgetHint}</string>
<string name="${widgetID}_table">${widgetLabel}</string>
<string name="${widgetID}_column">${widgetLabel}</string>

internal widget layout

This widget has internal structure widget_en_autocompletetextview.xml


queries.xml

Add to queries.xml :

    <query
        id="${widgetID}_input" 
        columns="${screenLabelGenerated}_${widgetLabelGenerated}"/>

configuration.xml

Table configuration for add to configuration.xml node <configuration>:

<tables>
    <table id="${widgetID}" name="${widgetID}_table">
        <columnText id="${widgetID}" name="${widgetID}_column" />
    </table>
</tables>

data for data.xml

  • ${numberIncrement} - Starts from 1. Take biggest row id and increment by 1.
  • ${dropdownItemsListRows} - based on user entered data into "dropdown items", repeat for each user entered item:
<row id="${numberIncrement}">
    <column id="${widgetID}">
        <value>${dropdownListItem}</value>
    </column>			
</row>
  • ${dropdownListItem} must comply with RULES

Data configuration for add to data.xml node tables:

<tables>
	<table id="${widgetID}">
		${dropdownItemsListRows}
	</tables>
</predefinedAppData>