Script for managing maintenance work in apartment complexes

In summary, this is a simple script that we will be looking to build upon every couple of months with new features and will offer ongoing work. The script (if script is appropriate wording) displays all of the properties per portfolio or account of GMJ maintenance. Each portfolio will have it’s own user name and password to log in with and display the properties and all of the property data (see attached excel spreadsheet for data fields (Apt#, Unit Type, Move-Out Date, Ready for Move in, Date Re-Rented, Move In Date). The script will continue to grow over time so we are looking for an ongoing relationship to assist us in continuing to build it. Please see the ATTACHED excel spreadsheet for an example of what we need to become web based. Phase 1 Features Needed: A professional looking login screen with the company logo. The user id and password will determine which set of properties are displayed at log in, the attached spreadsheet is an example of one account and it’s necessary data to be stored in a database and will have an assigned user and password. There will be a separate user and password for a second account to start out, upon entering this user and password a different set of properties will be displayed. The will be a master admin panel that will set up new accounts, assign a user and password and set up all of the properties within that account that can be edited when users log in.¬ Upon logging into the script the interface will somewhat mirror the attached Excel spreadsheet with the ability to edit all of the fields for any of the properties. There will be a few buttons at the top of the page that allow a user to: Edit an existing property unit Submit a New Entry Delete an existing entry If a user clicks edit an existing property, they will be brought to a screen that has a drop down menu of all of properties within their account (i.e. A Street, Cass Street, College West), once the properties is chosen from the first drop down menu, a second menu to the right will be populated with all of the Apt #’s in that property. The user will then choose which apt # they wish to edit and click an edit button. This will bring up all of the data on that specific apt # and allow the user to edit any of the fields (Unit Type, Move-Out Date, Ready for Move in, Date Re-Rented, Move In Date). Upon submittal the user will be prompted with a confirmation window that they can cancel out of or submit the changes. We will need a time stamp field or someway to show when each property was updated. If a user clicks submit a new entry they will be able to add a new property and assign it to the specific account it goes under in the master list (i.e. A Street, Cass Street, College West). They will be able to from this entry populate all of the fields (Apt#, Unit Type, Move-Out Date, Ready for Move in, Date Re-Rented, Move In Date)