Horse (foal) weighting system

Cerrado Publicado Aug 24, 2009 Pagado a la entrega
Cerrado Pagado a la entrega

This is a new web based application to track weights of horses against each other and a theoretical best curve.

## Deliverables

Please provide your quote for priority 1 as a bid

and send the additional cost for priority 2 in a PM

(priority 2 might not happen, or not too soon, but if you

win the project we get the second half done with you as well if it happens)

The application must run on Linux, PostgreSQL is preferred,

but MySQL is fine as well. You can pick between PHP (clean templating -

separating code logic from representation is a must) or

Ruby on Rails implementation.

PLEASE READ THIS CAREFULLY and estimate realistically.

BIDDERS NOT READING THE DETAILS ARE GOING TO BE EXCLUDED.

**Horse weighing system**

In stage one there are three administrative levels

1. Senior level

2. Farm level

3. Owner level (priority 2)

*Priority 1 (to be completed before the owner level)*

**Senior level**

This level is able to

1. Set up a farm ??" provide each farm with username and password. Details required are ;

Farm name, farm address, contact person, email address, phone number, fax number,

1. Set up stallions (also known as sires). A text box.

**Farm level**

At this level the farm will ;

1. set up the mares on the system.

1. set up owners on the system. Owners details required are - firstname, surname email. Can use excel spreadsheet to upload owners details

1. set up foals on the system

1. input the weight of each foal at regular intervals

*Set up mares (dams) Mare details are as follows ;*

* *Name of mare (eg Black Beauty)*

* *Studbook ID number (microchip ID)*

* *Select owners name. (selected from pull down menu. Owners name added at farm administrator level.) There can be more than one owner per mare.*

* *Sire of mare, (not selected from pull down menu just entered into text box)*

* *Dam of mare,*

* *year of birth of mare,*

* *place of birth,*

* *colour of mare,*

* *description (optional) free text box*

* *can upload photo of mare.*

* *can upload pedigree of mare(word doc or pdf)*

*Set up owners on the system. Owners details required are - firstname, surname email. Can use excel /or to make the implementation easier Coma Separated Value file/ spreadsheet to upload owners details*

Set up foals on the system

Before the start of each breeding season the farm can set up a foal for each mare

The farm selects a mare from the list of mares they have entered.

Clicks on ‘Add a foal’ the form contains the following

* *Year of birth from pull down menu they select the year eg 2009*

* *Name of dam (pre populated with the name of the dam = name of mare)*

* *Name of sire (selected from pull down list. This is the list of sires added at the senior admin level.*

* *LSD (last service date)They use a pop up calendar to select the date.*

* *Date of foaling (select the date the foal was born from a pop up calendar)*

* *Stud book ID (when available)*

* *Weight of foal (this is pre populated at 52kg.*

* *Description of foal (free text box)*

* *Comments about foaling (free text box)*

* *Owners of the foal (a foal can have more than one owner and an owner can have more than one foals even on different farms, so n-m relationship between the foal and the owner table has to be handled)*

Regarding horses it is also important to note, that horses can change owners, however the data about their historical weight gain is confidential, so if the horse is transferred to another farm which participates in this system permission should be granted by the Senior level to see historical data, if this permission is not granted only data from the point of purchase should be available to the new farm/owner(s). Same goes for the owners, so the system should keep historical track of time lines and associated farm + owner(s) of the animal.

*input the weight of each foal at regular intervals*

At regular intervals the farm will weigh each foal. The farm (or senior level) enters the date of weighing and the foal’s weight on that day.

To make it easy, the farm can click on a button ‘Add foal weights’.

A list of mares appears (with foals that have been born that year)

The farmer can add the date the weighing took place at the top of the page. This populates the date for all the foals in the list. There should be the capability for the farm to edit the date of weighing for each foal after pre-population.

Next to each mare is a box to enter the weight of the foal on that date.

The farmer clicks submit and the data is recorded.

There is also a comment box next to each mare. This comment box can be edited at a later date. For example ‘27/11/08 weight dropped, foal contracted a virus’. These comments can appear by mouse over each data point in a graph.

The farm can add an image of the foal at each weighing.

*input the weight of each foal at regular intervals*

The system calculates the weight at ‘x’ number of days old for each foal. The number of days old is the date of weighing ??" date of foaling.

The system calculates the average daily weight gain since the last date of weighing.

The system calculates the average daily weight gain since date of foaling.

We will supply existing data from our current database, tables are going to be provided as separate CSV files with data model structure. A simple import script should be written which loads these files into the new SQL database created with this system.

Graphs

A graph is produced that shows the foal’s weight gain over time. This can be compared to the normal average (data supplied) which is presented on the same graph. Its preferred to use the Open Flash Chart project or similar 3rd party application, you can roll your own, but it must be robust, user friendly and functionally to meet all requirements.

X axis = number of days old

Y axis = weight

A graph to present an average daily weight gain since birth and since last weighing.

A theoretical average daily weight gain is included in this graph.

For each graph the user can click to see the raw data.

*Other graphs*

* A foal’s weight gain compared to foals from same dam from previous years.

* A foal’s weight gain compared to an average of all foals on the same farm.

* A foal’s weight gain compared to an average of all foals in the system by the same sire. (This is the stallion that is added at the senior admin level)

Regarding any graph where there is a time axis a user friendly interface should assist the user to “zoom?? (change between) all data, 1year, 6 months, 4 months and 2 months

Please note that it is important that the graphs can be printed

so there has to be an option for PDF output

All HTML/CSS work should be done for all screens, we will supply a verbal design guideline and some minimal graphics (banner on top)

Source code should be well commented and a brief (not bloated, but covering all

necessary areas eg. data-model, function and object descriptions, architectural)

practical developer documentation should be supplied in grammatically correct English

**Owner level** (priority 2)

Please note, even if this is not going to be implemented upfront,

the system should be designed in a way that it is easy to extend

into this direction and a developer documentation has to be provided

with clear directions how to do it.

The farm being able to provide each owner with a username and password to access the graphs of their foals.

They can view images of the foal if available. Kind of like a mini face book for horses.

It will include the capability for farms to email owners when their foal page has been updated.

Any questions let me know...

JavaScript PHP XML

Nº del proyecto: #2849258

Sobre el proyecto

11 propuestas Proyecto remoto Activo Sep 15, 2009

11 freelancers están ofertando un promedio de $1659 por este trabajo

allenjonessl

See private message.

$5100 USD en 21 días
(192 comentarios)
8.1
oneclickdevelop

See private message.

$1275 USD en 21 días
(111 comentarios)
6.7
eztechsystems

See private message.

$2040 USD en 21 días
(14 comentarios)
6.1
webhighway

See private message.

$2125 USD en 21 días
(10 comentarios)
4.8
petrovanstervw

See private message.

$595 USD en 21 días
(10 comentarios)
4.4
digicorpinf

See private message.

$1700 USD en 21 días
(2 comentarios)
4.5
technologies77

See private message.

$2422.5 USD en 21 días
(4 comentarios)
3.8
masamunewos

See private message.

$425 USD en 21 días
(6 comentarios)
3.5
busmaster

See private message.

$850 USD en 21 días
(1 comentario)
2.2
leokorndorfer

See private message.

$1020 USD en 21 días
(0 comentarios)
0.0
customcodevw

See private message.

$701.25 USD en 21 días
(1 comentario)
0.0