I have a SQL table (tbl_badge) which have around 100 columns like primary_key,user_key,First_Name, Last_Name column 1, column 2, column 3, column 4...etc. I have to create a badge admin setting page with in 6 bag lines (master columns of tbl_setting_bage) by choose some of columns from the table (tbl_badge) . So I want to give this right (UI page with drag and drop columns ) to each and every admin user who can design badge setting (it means position of columns, no. of total taken clolumns, total no of columns in a single badge line etc) according to his/her choice, and settings will save in a database table.
Here are the badge admin setting and badge end user UI which i want.
Admin Bag Setting table (tbl_setting_bage) View-
Badge Line 1 - {column 1} {column 3} {column 4}
Badge Line 2 - {column 2}
Badge Line 3 - {column 8}
.
Badge Line 6 - {First_Name} {Last_Name}
if I get save above these settings in a table (tbl_setting_bage) then eaisly I can design and fetch for end user UI
Final End User Report UI will be like which I can take from above tables (setting_bage & tbl_badge)-
{badge Line 1},
Title : {badge Line 2}
Address : some text {badge Line 3}
some text {bag line 4}
...........
Phone :{badge Line 5}
From : {badge Line 6}