employee/company management app/intranet site

AWARDED
Bids
42
Avg Bid (USD)
$2607
Project Budget (USD)
$1500 - $3000

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)
DOB
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
email
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)
deductions
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
notes
----

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

AutoID
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

employeeID
worksiteID
full name
rate
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: http://www.bluechilli.com/software/apps/cemtex-aba-file/aba-file-format.html.

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)
address
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)
tenant2
tenant3
tenant4
tenant5
tenant6
tenant7
tenant8
tenant9
tenant10
tenant11
tenant12
tenant13
tenant14
tenant15
tenant16
tenant17
tenant18
tenant19
tenant20
)
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)
(
1=bed
2=mattress
3=wardrobe
4=bedside table
5=table
6=chair
7=cabinet
8=tv
9=vcr/dvd player
10=toaster
11=stove electrice/gas small
12=microwave
13=kettle
14=other
)
shortdescription
purchased time
houseID

----
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:

emplyoeeID
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.

Skills required:
C# Programming, HTML, MySQL, PHP, Website Design
Additional Files: letter+template.docx tax+invoice+template.docx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 3500
in 30 days
$ 6000
in 55 days
$ 3000
in 40 days
$ 3000
in 45 days
$ 2885
in 40 days
$ 2200
in 35 days
$ 3500
in 40 days
Hire STARSOFT333
$ 3000
in 65 days
Hire ajaxdevman
$ 3000
in 50 days
Hire outsourcedev
$ 2800
in 15 days