Build a database driven application/website using perl and mysql database.

01) Website should have application login authentication with 2 methods (application login and ldap login) 02) Top frame should have logo provisioning on left side with website application name e.g. "CUSTOM TOOL" and show current logged username in some appropriate place 03) Bottom Status bar a) Version,Author/Owner Name etc (comes from database APP_CONFIG table) 04) Database Driven Menu. Sample data columns in table will be like(menu_id,menu_name(display),menu_url,parent_menu_id,is_new,is_enabled,role_id) It should handle at least 3 level and have facility to show new menu(some red star or red color "new" along with menu item). It will call either static html page or database driven report/form page. menu items will be restricted based on role of user like admin, reader, public page etc 05) Every page will check if logged user is admin or non-admin or public. Back button/link/image on appropriate pages to goback 1 page. some pages will be displayed only for admin. If non-admin user tries to go to that page it will give some appropriate message. some pages are public and does not need authentication. This also means home page is definately public. 06) All different types of files well organized.(.pl/.cgi in cgi-bin ,html in html,images in images, uploaded documents in upload, javscript, css etc in respective directory.) 07) Database tabular report - Everything read-only 08) Database tabular Report with edit image as first column. When clicked on edit image, it will open that particular record which can be updated/deleted. One or two column will have list of values that can selected and comes from database. Atleast One column will have date column. Calendar icon to open calendar and select datetime. 09) Master-Detail Database tabular report with plus sign on first column. When clicked on plus sign it should open detail record just below master record. There may be multiple detail records for each master record. Detail record background color and font color should be different then master. when clicked on plus sign of another master record, detail records for that master record should open. By default all master records are collapsed. Detail record should run asynchronously if possible so that it doesn't take time to generate master report page to enhance performance. 10) Database tabular report - It should accept 2-3 parameters (include date type param) and pull database report based on parameters. 11) Tabular form to insert/update/delete multiple records in database. 12) Dashboard of Charts Page with multiple charts(4-6) of same size. Data for chart will come from database. a) atleast 1 pie chart, 1 bar chart,1 line chart, 1 line chart with multiple series,1 bar chart with multiple series. b) when clicked on portion of value of chart, it should open detail database tabular report based on part/value selected (to show more details in tabular format). 13) Dashboard Report Its normal database report but color of cell will change automatically based on configuration of that column value in database Something like - values between 1 and 2 - its Green, Value between 3 and 5 - Amber, Value above 5 - Its red. each row will have about 4-5 columns and every column color of that particuler row can differ based on configuration. 14) Image gallary. when clicked on any image, it will be shown in full page size with some desc at bottom. 15) Digital Daily Diary This is something like basic blog but not with full functionality of blog. Dairy can be searched by date or text 16) Basic Library 17) Admin Module config application parameters,menus,users, upload images/files for image gallery/library. e) upload file and mark enable/disable for library. Note : Database designing help will be provided. Pls see attached file for more details.