Difference between revisions of "SAM V2:customization"

From AMACWiki
Jump to: navigation, search
(How to Add a Field to a Table and Form)
(Blanked the page)
 
(26 intermediate revisions by one other user not shown)
Line 1: Line 1:
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 border="1">
 
<tr>
 
<th>&nbsp;</th>
 
<th>Table Name</th>
 
<th>Subdirectory Name</th>
 
</tr>
 
<tr>
 
<td>Student</td>
 
<td>students</td>
 
<td>student</td>
 
</tr>
 
<tr>
 
<td>Disabilities</td>
 
<td>disabilities</td>
 
<td>disability</td>
 
</tr>
 
<tr>
 
<td>Accommodations</td>
 
<td>accommodations</td>
 
<td>accommodation</td>
 
</tr>
 
<tr>
 
<td>Consents</td>
 
<td>consent_types</td>
 
<td>consent</td>
 
</tr>
 
<tr>
 
<td>Referrals</td>
 
<td>referrals</td>
 
<td>referral</td>
 
</tr>
 
<tr>
 
<td>Case Notes</td>
 
<td>case_notes</td>
 
<td>case</td>
 
</tr>
 
<tr>
 
<td>Tasks</td>
 
<td>tasks</td>
 
<td>task</td>
 
</tr>
 
<tr>
 
<td>Documentation</td>
 
<td>documentation</td>
 
<td>doc</td>
 
</tr>
 
<tr>
 
<td>Tests</td>
 
<td>tests</td>
 
<td>test</td>
 
</tr>
 
<tr>
 
<td>Class Schedules</td>
 
<td>class_schedules</td>
 
<td>schedule</td>
 
</tr>
 
<tr>
 
<td>Orders</td>
 
<td>orders</td>
 
<td>order</td>
 
</tr>
 
</table>
 
 
==How to Add a Field to a Table and Form==
 
 
===Step 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:
 
 
<pre>alter table disabilities add column evaluator_name varchar(50) … </pre>
 
 
Or you could use the MySQL workbench to alter the table using the GUI tools.
 

Latest revision as of 10:50, 19 May 2015