vivek kuamr

vivek kuamr

  • NA
  • 79
  • 520

Design a badge setting dynamically by admin for end users

Jul 21 2017 2:41 AM

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}