Difference between revisions of "SAM V2:customization"
Jump to navigation
Jump to search
Line 72: | Line 72: | ||
<pre>alter table disabilities add column evaluator_name varchar(50) … </pre> | <pre>alter table disabilities add column evaluator_name varchar(50) … </pre> | ||
Or you could use the MySQL workbench to alter the table | Or you could use the MySQL workbench to alter the table. | ||
2. In the disability subdirectory, you will need to modify the programs add.php, edit.php, and view.php to handle the new evaluator_name field. | |||
3. In add.php, you would add a table row for the new field with 2 table columns, one for the label, and one for the input of the value for evaluator_name. |
Revision as of 13:54, 17 May 2011
Since SAM V2 is open-source software, it is easily customized with a working knowledge of HTML, PHP, MySQL, and the SAM source code/database structure.
Tables Names and Directory Structure
Table Name | Subdirectory Name | |
---|---|---|
Student | students | student |
Disabilities | disabilities | disability |
Accommodations | accommodations | accommodation |
Consents | consent_types | consent |
Referrals | referrals | referral |
Case Notes | case_notes | case |
Tasks | tasks | task |
Documentation | documentation | doc |
Tests | tests | test |
Class Schedules | class_schedules | schedule |
Orders | orders | order |
How to Add a Field to a Table and Form
1. Add the field to the underlying table in MySQL. For example, to add a field called Evaluator Name to the disabilities table, you would execute a SQL statement similar to:
alter table disabilities add column evaluator_name varchar(50) …
Or you could use the MySQL workbench to alter the table.
2. In the disability subdirectory, you will need to modify the programs add.php, edit.php, and view.php to handle the new evaluator_name field.
3. In add.php, you would add a table row for the new field with 2 table columns, one for the label, and one for the input of the value for evaluator_name.