Note: database views and stored procedures are developed and tested for you.
1)Start responsive php web application code from scratch using these tools (PHP 7.0, MySql, Laravel framework 5.2, standard twitter bootstrap for UI).
2)Web app must be responsive, testing will be done on mobiles, ipads and normal desktops.
3)Login screen – pass user_id and password to sproc_sec_login stored procedure. Login will always have two parts owner@demo. First part is user id to be passed to login stored procedure. By default php app to connect to sama_msater db and get actual db connection info from sama_login_info table by filtering on second part of login that is @demo. Hence php app to connect to a given database and then invoke login stored procedure. HENCE php code to change the db connection settings as per login name. BUT sama_master db connection is static. Sample login screen http://samaitgroup.com/html/html/login.html
4)provide logout facility, call stored procedure sproc_sec_logout
5)Develop dynamic top right horizontal tabs and left vertical menu. Horizontal tabs and vertical menu items differ from user to user. Data for tabs and menu items will be available as returned result set from sproc_sec_login stored procedure.
6)Tabs and menu developed to look similar to http://samaitgroup.com/html/html/fiscal-year.html. Here ''admin'', ''school'', ''username'' are tabs. Security, SMS, Manage School, Student and Fee are called menu groups. And then you have individual screen link under each menu group. Do not develop static tab links and menu links, it depends on what you get back from login stored procedure. More importantly, each tab to dispaly their own menu groups. Do not display all menu groups to all tabs.
7)Develop fiscal year listing screen , should match 100% to http://samaitgroup.com/html/html/fiscal-year.html. Use bootstarp controls only. Enable search and pagination as shown in this link. Use view_org_fiscal_year_detail database view to get data for the grid.
8)Add new fiscal year record screen to look like http://samaitgroup.com/html/html/fiscal-year-addnew.html. Pass parameters to sproc_org_fiscal_year_dml_ins stored procedure to insert a new row. Provide ability to select multiple facilities from drop down and pass multiple facility ids to stored proc as comma seperated imput parameter.
9)Edit fiscal year screen to look like http://samaitgroup.com/html/html/fiscal-year-edit.html. Pass parameters to sproc_org_fiscal_year_dml_upd stored procedure to update the row. Previously multi selected facilities in drop down to stay intact, pass multi facility id as done in insert stored proc. Prefer to use check box type drop down.
10)use sproc_org_fiscal_year_dml_del stored procedure to delete a row.
11)Perform client side validation - fiscal year name, start date and end date are mandatory.
1)Database tables are already designed for you. Stored procedures and views are already developed for you, means you call the stored proc and pass required parameters for performing select, insert, update and delete operations.
2)Attached is sample sql script to invoke login, select, insert, update and delete operations