employee/company management app/intranet site

This project received 42 bids from talented freelancers with an average bid price of $2607 USD.

Get free quotes for a project like this
Employer working
Project Budget
$1500 - $3000 USD
Total Bids
Project Description

The application needs to be able to do the following:

a page Add/Edit an employee database with the following fields:

(with an autoID)
employee name
employee surname
sex (1=male; 2=female
height (in cm)
nationality (Taiwanese, Japanese, chinese, north Korean, south Korean, hong kongese, other)
passport number
visa type (1=working holiday, dependant visa full work rights=2, PR/citizen=3, limited=4,other=5)
entry date
first visa start date (only applicable to working holiday visa, add/edit page must reflect this)
first visa end date (only applicable to working holiday visa)
second visa start date (only applicable to working holiday visa)
second visa end date (only applicable to working holiday visa)
Holiday visa term (1=first visa; 2=second visa;3=NA)
visa end date (via data entry, applicable when visa type not equal 1)
contact number
status of ABN application (Yes/no)
ABN number
bank of bank account
BSB of bank account
account number of bank account
place of work (as a ID with a link to a seperate table)
start employment date
hourly rate description
hourly rate (taken from the site tables-siterate, but with a textbox for other hourly rates)
place of stay (taken from houses table-houseID
weekly rent rate (entered via textbox)
status of bond payment (yes/no)
amount of bond payment (entered via text box)
status of issued equipment (yes/no)
equipment name1
equipment value1
paid for by1 (1=company; 2=employee)
equipment name2
equipment value2
paid for by2 (1=company; 2=employee)
equipment name3
equipment value3
paid for by3 (1=company; 2=employee)
equipment name4
equipment value4
paid for by4 (1=company; 2=employee)
vaccination status (yes/no)
future employment (yes/no)
employed (yes/no)
description of final position

a page that can Add/edit an worksites database with the following fields:

site name
site location
site rate 1
site rate 2
site rate 3
site rate 4
site rate 5
site rate 6
site rate 7
site rate 8
site rate 9

a worksite details pages

which displays the following information

the total number of employees employed at the site
a list of all employees (where employees name can be drilled down upon)
a list of all the houses assignment to the worksiteId (where the address can be drilled down upon)

a payment processing page that can do the following:

calculate an weekly wage from each worksiteId than each employeeID within worksiteID and would have the following fields for display and entry into a database table

full name
hours worked (from textbox)
calculated gross wage amount (rate x hours worked)
10% of gross wage amount displayed as 10% GST (Tax)
net wage (gross + 10 GST)
rent deductions
transport deductions
other deductions (with a text box for data entry)
total payment amount (gross wage + 10% GST - rent deductions - transport deductions - other deductions)
other payments

this data entry page must utilise an dataset for easier data entry, each payment must be entered into an payments database with the above fields as a minimum plus an additional transactionsID (autonumber) for each payment.

all payments of a given worksiteID must be made in one go within a single long webpage.

after all wage payments for given worksiteid is calculated, the webpage must generate a ABA file that complies with Australia banking accoication's format requirements see: [url removed, login to view]

only when each payment is marked paid on this page can each transaction be entered into the transactions database.


the employees database must also be able to generate a printable page close to the attached letter template
see: attached letter template

a invoice creation page where it has the following information:

the full name of the employee
the employee's ABN
an generated invoice number
an invoice date (based on date of creatation)
a list of transactions/payments with the employee in a list format
a gross total amount of all transactions (pre GST amount)
a 10% GST amount
a net amount (gross+GST)

a total amount of all deductions.

transaction database must also be able to generate a printable page close to the attached invoice template

See template

an employee applications tracking feature which includes:

a page that can add/edit a applicants with the following fields

applicant name
applicant surname
applicant mobile number
applicant email address
applicant referer (based on employee id)
applicant sex
applicant height
applicant passport number
appicant status (1 for seeking, 2 for employed, 3 terminated)

a page that can add/edit and a page that can then view a houses management database (display page will be grouped by the siteID) with the following fields:
houseID (autonumber)
rent amount per week
payment cycle (weekly=1/fortnightly=2/monthly=3)
rent due date(a dedicated page for recording rent payments (every rent payment recorded must update the rent due date in accordance with the rent payment cycle))
tenant1 (each tenant contains a employeeId, each employeeId is a hyperlink to the employee details pages)
realtor company name
realtor contact number
realtor fax number
realtor bank
realtor account name
realtor account number
realtor account bsb

the rent payments database must contain the following fields:

an autoID
the houseID
the payment amount
the payment date

the rent payments must contain the following:
the ability to record rent payment transactions, while also updating the rent due date field from the house table, a datalist which its populated on 2 conditions (droplists)
first dropdown list=list of all site names
second dropdown list (populated by selection of first dropdown) = all house address within a relevant siteID (the house address must be a hyperlink to a page with lists all rent payments associated with the relevant houseID

on the page that displays the houses database, add a link (with the address as the hyperlink) where it can drill down on the address to display all the householditems associated with the houseID

householditemsID (autonumber)
Category (number as ID)
4=bedside table
9=vcr/dvd player
11=stove electrice/gas small
purchased time

a page with the ability to add/edit and them view a car management database with the following fields
carId (autonumber)
car make
car model
car year
car purchase price
car insurance company
car policy number
car insurance cover start date
car insurance cover end date
car insurance cover cost
car insurance cover amount
car use location (siteID)


add a page for administering resignation of employees (edit employment status)
this page must display the following fields:

employee Full name
employee work site (worksites-siteID)
employee house of stay (houses-houseID)
employee start date
all equipment issued to employee where issued equipment=yes, status of paid for by=company
employee bond amount


the website must have a simple login feature

the front/home page after login must contain the following items
each dataset much contain a link to a relevant page

a dataset that displays a list of certain types of employees (taken from visa type field=working holiday) who have been employed 4.5 months or more, where future employment field = yes.

a dataset that displays all employees names (link to edit employees details page; employee name as hyperlink, where ABN status = no
A dataset that displays all the houses with rent due within 3 days (link to the dedicated rent payment page)
A dataset that displays all the cars with insurance policies within 2 weeks (link to edit insurance database page

an employee search/find feature (searches based on employee name, also from a dropdown list of worksites that then populates a datalist with employee names)

on the search results page, each returned search result must contain a link to the employees detailed information page, which contains all the information from the employees table, the name of the worksite the employee is employed at and all of the transaction for the given employee (displayed in a dataset) going back in selectable options of 3/6/12 months.

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