Database design and link to site
$250-750 USD
Thanh toán khi bàn giao
I need to design a comprehensive database that will have the following features and will intergrate within the website for member login and sign up to include payment processing with digital contracts. See below for a full list of what I have come up with.
I’d love for it to be done in using a system like Caspio or something similar that is easy to manage and run analytics on the data.
Information and functions that need to be accomplished
-their membership information
-First and Last name
-Address
-Cell Phone #
-Email Alert subscriptions
-their profile picture
-allow them to see different things within the website based on user access level
-Admin
-Can see everything on the website and in the database
-Can edit everything in the database and on the website
-Manager
-Can see all content on the website
-Can see almost all content in the database except user private information such as credit
card numbers, userpaswords,
-Can see and do everything users below can see and do
-Can suspend user account access for roles below manager level
-Manage user roles below manager
-CANNOT promote user to the same level as oneself
-Escalate Support tickets to Admin Level
-Support Tech
-Can see support tickets
-Answer Support tickets
-Close Support tickets
-Query Database
-Merge Records
-Escalate support tickets to Manager level
-Manage Membership Status on member accounts
-Office Staff
-Query Database
-Suspend a Member account
-More permissions later to be determined
-Active Member
-Can see all available discounts and services to members
-Can query vendor database by type of service aka vehicle maintenance, legal services,
health, dental, vision, telecommunications, restaurants, also the query should be able
to be filtered by their GEO location or address
-InActive Member
-Can see all vendors that are signed up with the The company but is unable to see the discounts provided to our members
-Payment Hold
-Can see all vendors that are signed up with the Company but is unable to see the discounts provided to our members but at the top of every page is a thick red banner that reads ACCOUNT ON HOLD FOR FAILED PAYMENT
Also the database needs to have a lookup page for vendors to be able to authenticate a members active status by typing in the membership ID and then the vendor code and clicking verify
We would also want this database to be able to house all vendors and a description of their services all in a table of course so that one column can show the normal price that vendor charges and then the next column can show either a set dollar amount for the services the vendor provides or a discount percentage. The discount or set dollar amount for services the vendor provides would need to be hidden from public view unless the person viewing is signed in with a member login and also has a member status of active.
I would also like the database to be able to securely store the members payment method and have an auto billing method set up for membership renewal.
I would also like this database to be mobile friendly so we can link it into a mobile app to be developed later
What is the best solution for all of what I just described
ID dự án: #15432099
Về dự án
Được trao cho:
I am a caspio developer. I did similar project here https://www.freelancer.com/projects/php/Caspio-Developer/ I am an experienced Database Programmer and willing to assist you with this project Relevant Skills and Exp Thêm