[Change request to #3353] <Clients page view>

[Yuliia-Fliorko]

As an administrator, I want to see the list of clients, so that I can plan cooperation with them

Assumptions & Constraints

n/a

Preconditions

User is logged in as administrator

The administrator navigates to Admin Cabinet

Business rules

Only administrators with access should be able to view Admin Cabinet

The clients list should contain only registered clients who made at least 1 order

Acceptance Criteria

The administrator clicks on the tab “Клієнти” and a table with clients data is displayed. All fields are disabled

Column name	Field type	Requirements
Ім‘я клієнта	Text	Client’s name and surname. Alphabetic and special characters “‘“ (apostrophe), “-“ (hyphen), “ “ (space) are supported.
Телефон	Number	Phone number in format +38XXXXXXXXXX
E-mail	Text	Client’s e-mail
Дата реєстрації в системі	Date	Date, when the client registered in the system. DD/MM/YYYY
Дата останнього замовлення	Date	Date of client’s last order in format DD/MM/YYYY
К-сть замовлень	Number	Integers. Total quantity of client’s orders(>=0).
Порушення	Number	Integers. Max 2 characters. Total quantity of client’s violations. If client has no violations, this field should be empty
Баланс бонусного рахунку	Currency	Balance of client’s bonuses account. Flout number with 2 digits displayed in format XX.XX грн  E.g 500.00 грн
Clients status	Enum (active/inactive)	1) Clients with inactive status cannot make any orders. 2) Clients with inactive status cannot log in back to the system. If a user with status inactive tries to log in, then the system shows a message :  “Your profile is deleted. Please call us to restore your profile.”

2. The administrator can change the column width. Minimum column width is 12 characters.

When the data in the string is more than column width, the end of the string should be truncated and 3 dots at the end of the string should appear. When the header is wider than column width, it should be displayed in two lines

By clicking on the truncated string, a popup window with the full data is shown. When the admin clicks outside this pop-up, it should be closed.

The admin may change the order of column by dragging it

Infinity scroll to navigate the table up and down should be implemented

The total quantity of clients should be displayed above the table in format К-сть клієнтів: ХХХ ос.

The admin should have a possibility to Export to excel the table (described in user story [UBS Admin Cabinet] Export to Excel #2539)

Mockup:

to be added

Out of scope

Filtering

Sorting

Epic link

E.g.: Epic #2195

Labels to be added

"User story", Correspondind Functionality (e.g. User), Priority ("pri: "), "Corresponding Epic"