employee/company management app/intranet site

  • Status Closed
  • Budget $1500 - $3000 USD
  • Total Bids 42

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.

Get free quotes for a project like this

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