Closed

455393 Existing site replication and database import

This project is now closed with a project budget of N/A.

Get free quotes for a project like this
Employer working
Project Budget
N/A
Project Description

Objective:
Replicate the site [url removed, login to view] and import existing data into the new site. OurChildSafe is an Amber Alert Registry. Users create profiles of their children, including bio data, pictures, medical information, and emergency contacts. User then answers a questionairre/survey of each child. This questionaire was co-created with law enforcement officials to gather all pertinent information needed in case of an emergency.

The Purpose of the site is have information gathered and ready for emergency personel (law enforcement, emergency rooms, etc). Law enforcement can then access all the gathered data and critical information immediately by logging on to the users account. This saves them literal hours of gathering information at the site/scene of the emergency.

Current system is a customization of Joomla base code. We would like to move away from an open-source CMS and have our own secure software built using current coding technologies and abilities (LAMP+AJAX mostly).

Requirements:
1 - Sign-up Process and billing:
1a - Ability to set annual price per sign-up (currently $[url removed, login to view])
1b - Ability to automatically charge users credit cards on their annual registration date.
1c - Ability to set annual price per add-on child (currently $[url removed, login to view])
1c1 - Ability to add additional children after sign-up for the set annual child price. User's will be charged one-time for the current price of adding on a child, then their annual recurring bill amount will be adjusted to reflect the addition. (For example, a user signs-up in February for their one child at $24.95. They then have an addition to the family in September and add a child to the account. They would be charged $[url removed, login to view] for the addition in September when they add the child to the account, then when they get re-billed for their recurring charge in February of the following year, the bill amount will be $[url removed, login to view]).
1d - Full transaction history will be available within the account.
1e - User needs the ability to disable an child's profile should a natural event (death in the family (god forbid), divorce, child
1f - All credit card transactions must be PCI compliant (we work with [url removed, login to view] as our merchant)
2 - Account maintenance:
2a - Users can add additional maintainers of the account (parents, step-parents, and guardians)
2a1 - Maintainers of the account can add or edit information about the child.
2b - Users can add or edit information of each child.
2c - DESIRED (not current function): Users create a guest password for the account. This is what will be given to emergency personnel who can then view a profile card, but not edit user information.
3 - Email management. Our current ESP is Constant Contact. We need emails for the following:
3a - Email sent to parents and guardians on their child(s) birthday('s).
3b - Monthly newsletters.
3c - Transactional emails (Account created, account renewed, account cancelled, new child added, new guardian added, etc).
3d - Seasonal Emails (back to school, holidays, summer break, etc).
3e - Marketing emails (as needed. Partnership announcements, specials for members, etc).
We are very familiar with email messaging. What we are looking for from a developer would be a tie-in to our ESP through an API call for the triggered events. We'll handle the templating and management of the ESP account.
4 - Information Back Ups. Along with redundant back-ups from our host, we'd like to schedule full data back-ups for the following:
4a - Individual account back-ups. Maintain a log of changes for each user account and allow a user to revert to old data in case of user error.
4b - System wide back-ups. Build a daily back-up of the database and all web files and have them stored on a remote FTP server.
5 - Help Ticket System: Provide users the ability to communicate with customer service through their account by utilizing a help-ticket system. This can be an existing open source solution, provided it can be used securely within the user's account and not allow confidential data outside of the main system.
6 - UCL:
1 - Customer Service Representitive
A - Ability to add or disable user (customer) accounts (but not delete).
B - Ability to add or edit user data (changes will be logged, and user can revert if needed).
C - Ability to add or edit child data (changes will be logged, and user can revert if needed).
D - Ability to view and respond to help tickets.
E - Ability to charge users for membership fees, change credit card information, or refund to card.
F - Ability to email child bio to any email address.
2 - Managers
A - All the abilities of the CSR, plus:
B - Ability to add, disable CSR accounts
3 - Administrators
A - All the abilities of a Manager, plus:
B - Ability to add, disable Managers
C - Ability to add, disable Administrators
7 - CMS:
We'd like the ability to post articles, news/press releases, and blog posts. This can be done with a SIMPLE third party solution such as Wordpress, but the theme must be the same template as the rest of the OCS site and tie into the OCS navigation.
8 - Reports (preset time frames for reporting: Today, Yesterday, This week, Last Week, Month To Date, Last Month, This Quarter, Last Quarter, Year To Date, Each Year, Total Lifetime, and user select start and end dates for report)
A - Membership activity:
1 - Count all new accounts and revenue
2 - Count all cancellations
3 - Count total child records
4 - Count all accounts accessed by maintainers
4a - Count all accounts accessed by guess password
5 - Count all accounts updates
6 - Count all in-active accounts (not accessed or updated)
B - Revenue reports
1 - Count all successful credit card charges, minus sales commissions from third party affiliate reporting software.

Design requirements: We are open to new website design suggestions during the rebuild of the site. Site must look current and trendy.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online