This is a database and a web page for a strata management system consisting of all the relevant information and various functionalities required to smoothly operate a strata management company.
- @Jiadi Luo (@jiaidl)
- @Lavika Singh
- @Gurseerat Singh Brar
XAMPP server is a server with PHP, MySql And Apache, it allows us to use a single application to control these features. Download it here: https://www.apachefriends.org/download.html
Go to admin https:/localhost/phpmyadmin/ At this point the "root" user don’t have any password so first we have to update the password for root user:
-
Go to User Accounts Tab
-
Click on "Change password"
-
Enter the new password as "root" in the fields and click on "Go" button
-
Go the file explorer where we have installed XAMPP server, find a folder Name "phpMyAdmin" under it, in this folder locate the file
config.inc
and open it -
Find the password field in
config.inc
and enter the value root in it
To test that php is running fine in our system.
-
Write the code below
<?php phpinfo(); ?>
-
Save it as phpinfo.php and put it in the
htdocs
folder under xampp installation directory. -
Go to https://localhost/phpinfo.php, If the image like below will show then our setup is running properly
Connect MYSQL database in PHP Create a new database in our MySql database so we can connect it.
-
Open the Admin Panel for MySql or use the url to open it in browser https://localhost/phpmyadmin/
-
Now click on Database tab. In database name enter ZAGI and click on "Create" button (this will create a new database named ZAGI)
We have created a simple database and a web page for a strata management system consisting of all the relevant information and various functionalities required to smoothly operate a strata management company.
The first glance of our web page depicts different user roles corresponding to the entities in our database along with access to information regarding all the undertaken properties and the teams managing them.
When clicking into the target role, it allows the user to choose their role (Owner, Strata Manager, Staff and Company Owner) and perform actions such as edit, deletion or insertion.
When the role of the owner is selected, it depicts the list of current owners along with their names, phone numbers and email. Scrolling towards the bottom of the page, you can also see a separate table listing council meetings.
In case of an event of buying or selling of a property, the information of the owners can be changed or deleted, and new owners can be added to the list.
Clicking on the ‘Detail’ button for any owner directs the user to a new web page consisting of information regarding the Council Meetings that they have held, including details like the Meeting ID, location, duration, and the outcome of the meeting. It is further linked with the property table to verify the owners of each property.
In order to view detailed information about any property undertaken by the company, we click on the property role on the web page.
It shows the list of all properties as well as their names, propertyID and the location. It is linked with the Strata Management Company and the owner table; hence this enables us to easily check which company is managing a particular property and the respective owners of each property.
As you scroll down to the bottom of the page, you can see all properties are categorised into commercial or residential.
The list of the Commercial properties shows the Commercial Name and their permission numbers along with the property name and the property ID.
The list of Residential properties gives extra information about the restricted building size and the yard area along with the property name and its ID.
Moreover, each property has its financial statements and repair events that have been carried out in the past or are in progress along with details of the expenses, budget and the contractor responsible for the repairs.
Two separate tables are also listed in the Property Page with all different GUI interface drop down buttons showing the statistics for the statements (Summary on status, Property with all completed statements, Property with summary below average, and Property with negative summary) and events (Property with avg event cost > avg event budget, Property with more than one event, and Property with all completed events).
Furthermore, in case any property is demolished, or a new property is constructed, we can add or delete the property information accordingly. Moreover, in the event of the property being transferred to a different company, we can update the company information as well.
In addition, there is a ‘Detail’ button provided alongside each property on the list. Clicking on this detail button shows four tables displaying all the relevant information of a particular property collectively at one convenient web page. You can view the details of the financial statements, repair events, property name, location and category the property falls under commercial or residential.
Clicking on the Strata Management Company role shows all the Company names with their Ids and addresses.
The “Detail” button will guide the user to a new page providing access to the list of properties managed by each of them (with the GUI button “Summary” showing the statistics of the properties) and also their company owners.
Strata Companies can be deleted and inserted or any information for the existing ones regarding their name and address can be updated.
Clicking on the Company Owner role displays the names of all the company Owners and their respective Company’s RegisterID and phone number.
As you scroll down, you can also see a separate table listing all the Strata Companies. We can add or delete any Company Owner or change any information for an existing owner.
Clicking on the ‘Detail’ button for any company owner directs the user to a new web page consisting of information regarding the respective companies that they own including details like the company ID, company name, and address. It is further linked with the strata manager table to verify the managers that this company owner has supervised.
On choosing the role of Strata Manager, a list of strata managers appears showing their respective names, phone numbers and Licence numbers.
Since it is linked with the Strata Management Company table, we can also see the Company ID where the Strata Managers work.
In addition, we can also edit, delete, or insert details for any Strata Manager such as their name, contact information or the company they are/will be working for.
As you scroll down, the Strata Manager table is linked with the Staff table; thereby displaying a list of staff members with their name, SIN, phone number, training status and evaluation of their performance in the company.
Further at the bottom, the strata managers can also view details of the council meetings for the purpose of monitoring. In this way they can easily keep track of when the meetings were held and by which owners, what is the status of the meetings and whether the notice for certain meetings have been announced or not.
The table below allowing managers to choose different owners and to check owners’ information.
There is also a ‘Detail’ button alongside every strata manager. Clicking on it separately shows detailed information on another web page regarding the staff members (name, phone number, training status and evaluation) that the particular manager has been training and the council meetings (date, location, duration, meetingID and status) that is being monitored.
The staff table lists all the staff members (excluding managers) working in the strata company with information of their name, phone number and SIN.
As any employee resigns or new employees are hired, the staff information can be updated, added and deleted accordingly.
Certain staff members are further sorted by roles into "Accountants" and "Contractors". Clicking on their respective buttons directs you to their web page with further additional information about staff in both these roles.