326171 Simple Demo Interface
N/A
Maksettu toimituksen yhteydessä
I am trying to make myself a simple-ish demo to test out auto-complete/display on a site using a few rules.
Basically I'll have a form with 5 or 6 text inputs, each one an Auto-Complete.
I'll have 5 or 6 corresponding tables, each 10-20 records on length. The tables will be in something of a Matrix as each will have correspondence to the other e.g. Table 1 / Record 1 will have a value for each of the other Tables e.g.
Table 1/ Record 1
Name
Table2Value=X
Table3Value=Y
etc
so the tables will link.
The tables themselves will also be hierarchical e.g
MainValue
SubValue
SubSubValue
I'll want to be able to place an AC, give it a display title and then have define which table to access for the AC
Additionally I'll want to be able to do a limiter on each AC based on the values in a prior AC so:
Input 1: AC from CarMake
Input 2: AC from Table CarModel Where CarModel_Make = Input1_CarMake
Ideally in fact each Auto-Complete will call all values from the defined table but sort using the above 'limiter'
User can enter more then one value. Ideally as they select it adds to the left as a checkbox
[Enter Value]
[Gre ]
Grey
Green
User Picks Green
[ ] [x] Green
and can add another color or remove green with the checkbox
Once user adds all values and hits 'Submit' that makes a new Inventory Record
***
Step 2 will be modifying those selections each of which come from the nested tables and can easily modify either way;
Table 1: MainValue>
Table 2: <SubValue>
Right arrow shows list of subvalues to select
<SubValueV
SubSubValue1
SubSubValue2
User selects SubSubValue 2
Table 1: MainValue>
Table 2: <SubSubValue2>
or from Table 1:
Main ValueV
SubValue1
SubValue2
User selects SubValue2
Table 1: <SubValue>
Table 2: <SubSubValue2>
or can go up a level using the left arrow (only one option of course)
Table2: SubValue <SubSubValue2>
Table 1: <SubValue>
Table 2: <SubValue>
and again
Table2: Value <SubValue>
Table 1: <SubValue>
Table 1: Value>
and of course on the top (or bottom) of the nest no arrows show.
***
Finally, there will be another table, let's call it Inventory which will have a # of Records with a Name and then a value from each of the tables e.g. (making up all these values as example)
Widget A
Table 1 (Color): Dark Blue
Table2 (City): New York
Widget B
Table 1 (Color): Blue
Table 2 (City): Istanbul
Widget C
Table 1 (Color): Red
Table 2 (City): Chicago
And these now display using the values from the selection shown before
Table 1: <Dark Blue> Widget A
Table 2: <Chicago> Widget C
and if the user now modifies the Table Seleciton
Table 1: Blue < Dark Blue>
the inventory updates
Table 1: Blue > Widget A
Widget B
Table 2: United States < Chicago>
Table 2: United States> Widget A
Widget C
__________________
Pretty straightforward, I should be able to name the tables/fields and define which AC calls what and what the "Where" is.
Doesn't have to be pretty, if you can do this with existing Ajax ACs and modify for me a bit that is fine too, just experimenting.
____
Ammendment
On the first part of the task Auto-Complete I will have ONE input that requires querying two tables in order let's call them Color and Type
[Enter Type]
So if user types 'Seda' they'll get 'Sedan'
In the next input I was going to put let's call it color:
[Enter Desired Colors]
and user can pick a # of colors
In this case though for type I'll allow user to pick color and type
[Blue Se ]
= Blue Sedan
[Black Lux ]
= Black Luxury Car
So the additional table becomes a prefix table to the value AND also assigns a value for the Color Table
When user does get to Color table if they've chosen one in the Type table e.g. Black Sedan
then that is already one selected value
[Enter Desired Colors] [x] Black
and user can enter more as per original description
______
Simple Text Search on Inventory (the ones I add with boxes and the ones I added as records manually)
Auto-Complete on All Tables
Also joins the two tables I previously mentioned so if user chose
[Black Luxury] in the AC with the two table query
but also added other colors in the Color AC (Grey, Green)
then the search would find Black Luxury, Grey Luxury, Green Luxury.
___
Projektin tunnus: #2071978