Design & built android app for my client database
The Main Idea and Features
1- The Main Data Area (Clients’ data area): We should have all our clients in one big boll with the main data like:-
2- Groups:- Under this master data we can create groups and inside this group we can insert clients from the main data Area or can add new client, 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 (Activities):- 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
6- Notification center:- create a custom notification for a user, this user can custom the notification that he need
7- Barcode :- Generate a unique barcode for every client and can design and print a business card for any client including the barcode, also able to read this barcode in the PC (using barcode reader) or by phone (using the the mobile camera) to find all client data and recording the attendance in any service (activity) in any group.
8- 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.
9- 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.)
10- Users:- The admin have the power to create users and give the different authorities like
11- 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.
12- 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.
13- 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. (May be by polyline or select box above any client shown in the map…etc.)
14- Direct Call, SMS, WhatsApp or Viber: - after make a kind of filter, the ability to call or sms direct from the program.
15- Make a Tasks:- make a tasks (maybe after doing any kind of a filter) for example :- a time frame for the next visit for each user to visit a specific clients
16- Chat Feature: - ability to have a chat between two or more users.
18- High Security
20- The Source Code: - Should be delivered to the system admin.
21- Preferred:- Android Studio + PHP + MySQL