GSoC/GCI Archive
Google Code-in 2012 The Fedora Project

Task A09 – Implement Interface and Logic for tbl_Reimbused_Method

completed by: angad

mentors: bckurera

Design an interface with controllers (No need of formatting with CSS just use controllers).

Form Title : Add New Reimbursement Type

1.  Field Name - Method Type

1.  Value – String of 50 characters with only alphabetic characters.

2.  Field Name – Description

1.  Value – String with 100 max.

3.  Field Name – Valid Till

1.  Value – Date (yyyy/mm/dd)

4.  Field Name – Valid From

1.  Value – Date (yyyy/mm/dd)

5.  Field Name – Account

1.  Value – Integer max 5 digits

6.  Field Name – Remarks

1.  Value – Text

Then refer to for the tbl_Reimbused_Method table. Using PHP develop a script that fetch entered values from the designed interface and store in tbl_Reimbused_Method table. Data validation should be performed in both interface level and script level.

Valid Till and Valid From should be in above format on the form but in the script it should be converted to PHP timestamp and store which is a INT 10 value after conversion.