Application System
From BPSBR_Wiki
Contents |
Application System Overview
- Version 1 of the application system has become antiquated. It used a flat methodology, where forms and data were defined in a database table. This then translated into single records in the master database tables for each stored field. This made generic processing easy and expandable and reduced code changes. Unfortunately, this method has trouble with optimization and has a big performance hit as the database grows beyond 1000 virtual records (approx. 90,000 rows.)
- Version 2 added search functionality and used a more relational database, this version never left beta.
- Version 3 was a redesign of the database structure to be more "shelter" oriented. This was to be the formal replacement. This version is abandoned due to the need to move off of Version 1 quickly. (we moved to a bigger, faster server instead)
- Version 4 will be designed to mimic Version 1 but include relationional database methodogies to increase speed and performance along with feature enhancements.
- Version 5, one word, AJAX.
Version 4 Requirements
Required features for Version 4:
- All features available in Version 1
- Email notifications (to volunteer and applicant)
- Archiving
- Applications: Adoption, Volunteer, Surrender, Intake, Vet
- Search functionality
- Mass email based upon search results
- Search terms:
- Name
- City
- Breed
- Specific Dog
- Comments
- Vet (allow to do reference check on multiple, based upon same vet)
- Contract Generation
- Pull data and allow SOME changes by volunteer (eg. story text)
- Multiple stored contracts (in database)
- Work queues
- Email attachment to applications
- Object oriented design
- Convert surrender to intake
- Auto subscribe adopters/volunteers to mailing lists (from summary list? detail page?)
- Archive applications from summary page
- Lock applications from archiving
- Flags, eg. Vet Check Approved, Home Check Approved, etc.
Optional features for Version 4:
- Dog intake integrated into stories (removal of PagEd)?
- Doc imaging integration
- Linking to site userid/password to allow applicatant to update/reactivate application
- Create applications on behalf of user
- Shelter management features?
- Able to integrate into multiple platforms? (new portal?)
- Application verification checklists?
- Risk scoring?
- Is there a way that on the new application database version we could put in a field that we can click on multiple applications to archive them, or multiple apps to email about a particular dog, etc.?
- I'm also thinking of coming up with an email for fosters to use as a canned template to send out to people who requested their dog's breed/size/age, etc., but it would be nice if they had the ability to select a bunch of apps to just click a button and send mail to.
- When a volunteer searches or reviews an application, allow to "email" the application to another volunteer. (Perhaps part of work queues?)
Other
[21:06] wishfulthinkin66: Hi I was wondering something about teh intakes.. [21:08] wishfulthinkin66: if you can add like something that says Reminders: then the due dates of everything like interceptor/advantix/DHLPP boosters / deworming.. either for everyone to see or not jsut the volunteers like you have the cost on the intake,,,,
