Administrative database system
$50-500 USD
Bezahlt bei Lieferung
Background:
We are a small starting Dutch company (currently only 2 of us working part-time) that helps independent professionals (our customers) increase their sales via the internet. Regular HTML/CSS, SEO and marketing are our forte, Database and PHP coding unfortunately aren't. That's where you hopefully come in.
Project
We are looking for someone to develop an online administrative system/database in which our customers every week submit the number of sales we have managed to realize for them in that specific week, which could/should automatically lead to invoice generation for their specific sales number and an e-mail with this invoice of ours being send to them.
In a bit more detail. this system should meet the following requirements:
Core functions:
- Separate user accounts with unique logins;
- Possibility to add customers/users via an admin page;
- Automated e-mail sending, e.g. at the end of every week my customers should receive a simple email with the link to the database login-pagina saying its time for them to fill out the weekly form;
- When logged in, users should see their own personalized page (i.e. their name displayed) and be able to get:
an overview of which weeks they still have to submit.
if clicked on an "open" week, they should see the simple form where they tell how many customers they have received through us, and be able to press a "submit" button that saves this information into the database.
an overview of past invoices with the ability to download them.
- When a customer hasnt filled out the form of a respective week more than 7 days later, they should automatically get a reminder email;
- The possibility for the admin-user to see statistics and customer reports, e.g. selecting a number of weeks and seeing per customer the number of sales realized and their totals. I.e. using various filters simultaneously;
- For the admin to see an overview of which users/customers have not yet filled in certain week forms.
- And ofcourse: be secure
Additional features:
- Automated monthly invoice generation based on the amount of sales customers/users have had from us, as per their weekly submitted forms. (Parsing monthly total into a pre-exisiting MS Word-document??)
- Automated montly sending of this invoice-file to the specific user.
- Users and admin should be able to see past invoices and be able to download these.
- Related to the invoice generation: the possibility to set different prices per customer segment. Also, the possibility for the admin to change these prices.
- When the customer submits the weekform, the time and date of submitting the form are also saved and shown in their overview.
- When a new customer/user is added by the admin, he will automatically get an email with his login details and the link to the login-page.
- The possibility of making a backup of the database (and to put it back, e.g. upload the database-file, in case something went wrong).
- Users should preferably see a number of tabs (or just links to separate pages) once logged in: e.g. a "homepage" tab in which the "open week forms" can be seen", a tab with previous week forms, a tab with invoices, etc.
- This is because after say 2 years, I don't want customers to see all 100+ weekforms.
- We should be able to edit certain HTML/CSS properties of the system.
Despite (or because of?) the rather detailed brief above, we think this is actually a relatively easy task for professionals. We look forward to seeing your quotations.
Projekt-ID: #4684859
Über das Projekt
28 Freelancer bieten im Durchschnitt $557 für diesen Job
Dear Sir, We would love to get this opportunity of working with you. We can assure you that we will provide you with a very nice website. Regards NetzPro
I'm bidding to get the core functions done inclusive of the intuitive UI for both front-end and back-end, for the additional request, it's possible and will have to quote more. Hoping to hear from you. Thanks!
Dear Sir, we have lot of experience. We are interested and ready to start straight away. We will deliver you the best if you give us a chance. Please let us know if you need any more information. Thanks
Hi, I have read your requirements and I am very confident to do this project from start till end. I can guarantee complete satisfaction if you select me to execute this project. Please check your private message board. Mehr
Respected Sir, First of all thanks for taking time to read our initial post. We have checked your initial project requirement and wants to discuss further more via Freelancer Message board. Thanks ExpertonPHP !!
Hello, I am understood and would love to working with you. Please check pmb for more information. All the best, Steve.
Hi RAW85, I have a lots of experience in database/backend system like this project. I also worked on similar projects like yours. Let me help you. Thanks, Quan.
Hi! I have experience with creating PHP/MySQL administration interfaces and i would like to work on your project. I have a few questions about it, please read the private message.
Certified IT Professionals with 10+ years of experience in delivering enterprise class web solutions, intranets, portals and business workflow solutions to clients worldwide. Please review the PMB for more information.
Hi, I gone through your instruction carefully. pls. check PMB for more details. Thanks, Gr8light
Dear Client, I have 6 years of experience in software engineering. I am expert in Zend PHP, Codeigniter PHP, jQuery, HTML5, CSS, Ajax. I have similar applications successfully. Please check my customer's review for th Mehr
Hi, I have good command over designing. Expert hands in HTML 5 and CSS 3 & responsive web designs. I am good at PSD to HTML jobs too. I am the winner of the design contest in freelancer. I would like to be invi Mehr
As I found you just need a simple website to interact your customers. A dashboard can help you to make it better and simpler. PHP built-in email sender is a good way to manage automatic email sending.
I already did such projects before with invoice details and invoice system in javascript which is very efficient but in ASP.net C# Iam asp.net developer for over than 2 years and looking forward to create such system Mehr