New data base for our client (android + web)

The New data base for our Servant

System base

Web + android phones

The Main Idea and Features

1- The Main Data Area: We should have all our clients in one big boll with the main data like:-

(ID, First Name, Middle name , Last Name, Family name, DoB, Mobile #1, Mobile #2, Phone #, Pic, location map, Address (Country, Town, Area, Sub area, Street, Building, Floor #, Flat #,…etc.)

2- Groups:- Under this master data we can create groups ( with name , location, description, icon, admin for this group, Themes, …etc) and inside this group we can insert clients from the main data Area or can add new client (and this new client will add automatically to the main data area) also he can add new columns than the columns in the main data area , and this column can be any kind of data (text, #, tel, address, Yes, No, location map…etc.)

3- Group Services:- under any group we can create a service like:-

a. A visiting reports (name of visitor, data of visit, client name, kind of visit (visit in home, visit in work, phone call, sms,…etc., comments) and have the power to edit, add, delete columns…etc.)

b. A meeting report:- (name of day, date of meeting, name of clients, pic, comments…etc.)

4- Link clients:- the ability to link some clients with a kind of relation (father, mother , son , daughter, Brother, sister, teacher, supervisor, master, Host, …etc. – the admin can add new kind of relation or modify / delete…etc.) and show this link in a column in the Main Data Area and all groups if required.

5- Search Engine (Filter):- advance search engine with multi-cell value, the filter should have the power to search in all columns in (the main data area + Groups + Group Services, ..etc. + Linked clients) and have the ability to select some of the filter result, create new group from the filter, create a group service, send sms, import to phone contact (and ability to add prefix or suffix to any column), Make a Global Change (like to move them from one group to another, edit any column, add prefix or suffix to any column, …etc.)

6- Notification center:- create a custom notification for a user, this user can custom the notification that he need (i.e. notification when a client didn’t attend a meeting, or when client didn’t been visited for a specific time,….etc.)

7- Reports:- create and custom reports from (the main data area + Groups + Group Services, ..etc. + Linked clients) and export it in word, excel, PDF, access, data base,…etc.

8- Import/Export:- after make a filter, can export in word, excel, PDF, access, data base,…etc., also can import excel, database, access,..etc inside our system. Including all the data the need to be shown as well as pics and location maps (by X,Y or Google map Link ,..etc.)

9- Users:- The admin have the power to create users and give the different authorities like (create groups, modify groups, show some groups and hide other, give the power inside any groups, create users inside a group with limit authority, data entry or modify, hide or show some columns, modify or view only,…etc., can import or export data or not, )

10- Import or Export to the phone contacts:- the ability to export a list of clients after filter to the phone with specific data and ability to add prefix or suffix to the data before export, import some contacts from phone to the data base.

11- Open Google Map:- (In Mobile or PC ) the ability after make a filter to show the selected clients in a google map with location and my location and can select Go To feature to visit a client.

12- Select clients In Google Map:- (In Mobile or PC ) the ability after show the selected clients in a google map to select some of them by area and make a global change on them. (maybe by polyline or select bix above any client shown in the map…etc.)

13- Direct Call or SMS:- after make a kind of filter, the ability to call or sms direct from the program.

14- Make a Tasks:- make a tasks (maybe after a kind of filter) for some users linked with clients. (i.e. for a time frame for the next visit for each user to visit a specific clients)

15- Log:- make a system log for any change or modify in the program, shown to the admin.

16- Offline and Sync:- Can work offline using a backup folder and make Sync when online, any conflict should be reported to the admin and the admin only can solve the conflict.

17- High Security:- use a certified security system to ensure the system safety.

18- Self-Manage:- The System should be simple and can be managed completely by a non-developed user.

19- The Source Code:- Should be delivered to the system admin

HTML Mobile App Development

Project ID: #13584070

About the project