Name: hgtr
Owner: NMDP/Be The Match Bioinformatics Research
Description: null
Created: 2015-07-31 18:16:49.0
Updated: 2015-08-06 21:02:30.0
Pushed: 2015-08-20 19:00:02.0
Homepage: null
Size: 9096
Language: PHP
GitHub Committers
| User | Most Recent Commit | # Commits |
|---|
Other Committers
| User | Most Recent Commit | # Commits |
|---|
A php web application with forms for entering metadata on genotyping tests and kits for histoimmunogenetics. The forms then generate xml files similar to the standard from the NCBI Genetic Testing Registry (GTR).
Table of Contents
General installation process
Step-by-step Guide
Tested and working on Windows 7 with
WampServer 2.5:
| PHP | Apache | MySQL | |——–|——–|——–| | 5.5.12 | 2.4.9 | 5.6.17 |
create database gtrsource gtrsqldump.sqlcd C:\wamp\www\application\configmd developmentxcopy config.php developmentxcopy database.php developmentconfig\database.php
'username' => 'root',
'database' => 'gtr',
Hostname should already be localhost and there is no password.
config.php
Tested and working on Linux Mint Cinnamon 17.2 Rafaela with
XAMPP 5.5.27 (XAMPP is cross compatible with Linux, OS X, and Windows):
| PHP | Apache | MySQL | |——–|———–|——–| | 5.5.27 | 2.4.16 | 5.6.25 |
su for this session, or else you may have to re-enter commands with sudo if permission deniedear htdocs, clone into it (<url> is the git url to the right on GitHub page)
d login to MySQL Server
$ cd /opt/lampp
$ rm -rfv htdocs && mkdir htdocs
$ cd htdocs
$ git clone
mysql> create database if not exists gtr; mysql> use gtr; mysql> source /opt/lampp/htdocs/database/gtrsqldump.sql; mysql> exit;
$ cd /opt/lampp/htdocs/HGTR/application/config $ mkdir development $ cp config.php development $ cp database.php development $ cd development $ nano database.php
ano, edit the file, updating the following two values as shown below
sername' => 'root',
atabase' => 'gtr',
name should already be 'localhost' and there is no password.
following nano commands will save and exit: `^O`, `Enter`, `^X`
$ nano config.php
ano, edit the file, updating the base url as below
onfig['base_url'] = 'http://localhost/HGTR';
following nano commands will save and exit: `^O`, `Enter`, `^X`
start XAMPP
en browser to 'localhost/HGTR'
OS X
be completed later]
tructure
# Filesystem
R](HGTR) directory is the root directory for the web files. This implementation is being run on an AWS Elastic Beanstalk, which deploys it as a
application, so it does not reveal other directories and only cares about this one root directory. On your local development, you can use an Apache server where the contents of the HGTR
ctory are typically placed within the 'www' or 'htdocs' directory of a server.
# Database
abase](database) contains a SQL file that will construct all the tables and populate them with the data needed. A MySQL database was used and the SQL file will run cleanly when executed on a MySQL Database.
can name your database whatever you want, but you must edit your database.php to reflect this database name.
evelopment and Deployment
specific instructions on setting up a local development are [above](#installation). If you fork this repository, you should create a 'development' directory within the [config directory](HGTR/application/config). In here, copy [config.php](HGTR/application/config/config.php) and [database.php](HGTR/application/config/database.php) and in your local development, CodeIgniter will use the configuration settings found within this folder, while GitHub will ignore that directory when you commit (it is in the .gitignore already).
onfig.php, you will set such things as the base_url. CodeIgniter will try to auto-guess this or it will load 'localhost' if it cannot guess correctly or if you are working locally.
atabase.php you will configure your database connection here.
he main 'config' directory, routes.php is where you can redefine your default controller if you wish to do so.
ot put any login credentials or private information into the files within the main 'config' directory, as a copy on GitHub would be public.
he implementation of this website, the local development is configured from within the '/development' directory and the production deployment is handling the configuration on the server. This repository is directly linked to our Jenkin's server, which writes over the config files with its own, and deploys its build to Amazon. This server is also listening for commits to the base master branch. Any push to it will initiate a new build on Jenkins automatically. This means the website is automatically updated whenever the repository is updated.
nderstanding the code
site was written in PHP on the [CodeIgniter Web Framework](http://codeigniter.com).
Igniter is a PHP Framework that is loosely based on MVC (Models-Views-Controllers) or sometimes argued as PAC (Presentation-Abstraction-Control)
MVC
CodeIgniter's site:
separates application logic from presentation. It permits your web page to contain minimal scripting since the presentation is separate from the PHP scripting.
**Model** represents your data structures. Typically your model classes will contain functions that help you retrieve, insert, and update information in your database.
**View** is the information that is being presented to a user. A View will normally be a web page, but in CodeIgniter, a view can also be a page fragment like a header or footer. It can also be an RSS page, or any other type of 'page'.
**Controller** serves as an intermediary between the Model, the View, and any other resources needed to process the HTTP request and generate a web page."
C](images/MVC.png)
dels can be found [here](HGTR/application/models)
ews can be found [here](HGTR/application/views)
ntrollers can be found [here](HGTR/application/controllers)
of the files within the above directories are PHP, so any other languages, such as HTML or SQL, are wrapped within these php files.
r libraries or filetypes used to help construct the views, such as javascript, css, or images, can be stored within the assets directory [here](HGTR/assets)
Walk-Through
w is a walk-through of a typical use-case of the website and how the components of the framework interact.
# Home Page
mepage](images/homepage.png)
er visits the site home page. This loads the default controller, which is [controllers/Home.php](HGTR/application/controllers/Home.php). Remember, this is defined as the default controller in
fig/routes.php](HGTR/application/config/routes.php). You can view the controller file to see that it is loading views to produce a response to display to the client. It is loading [views/home.php](HGTR/application/views/home.php) and the [views/footer.php](HGTR/application/views/footer.php).
results in this home page on the user display:
mepage screenshot](images/homepage_screenshot.png)
# Kit Form
rm_selection](images/form_selection.png)
he user chooses the default selection for the form, a kit, and clicks continue this will redirect the page to the kit form. The selection in the drop-down is being sent as a form POST when the user clicks 'CONTINUE'. The form submit action is to POST to a specific URI, base_url/index.php/form. This tells the server to load the controller named Form, found at [controllers/Form.php](HGTR/application/controllers/Form.php). This controller takes the data posted from the selection
hat it can determine how to respond. If kit is selected, this loads the kit form. It does this by loading views for the [views/header.php](HGTR/application/views/header.php), the form itself found at [views/kit_form.php](HGTR/application/views/kit_form.php) and the [views/footer.php](HGTR/applications/views/footer.php).
results in this kit form page on the user display:
t_form](images/kit_form_screenshot.png)
e are drop-down fields in this form that are being configured by the javascript file for the page, found in [assets/js/views-js/kit_form.js](HGTR/assets/js/views-js/kit_form.js). This is using [Selectize](http://brianreavis.github.io/selectize.js/) to turn text-input fields into drop-down fields with search and 'other' input capabilities. The data is being populated by Ajax requests for the data. Within the javascript file, there are requests to specific URIs that
controllers to respond with JSON data that the models queried from the database.
ax](images/ajax.png)
same javascript file also has jQuery functions to respond to button clicks on the '+' symbols for repeating form sections. The function will append an HTML template, update IDs with a count, and reapply Selectize configuration and data population. The same functions will also rename some input field names to POST them as separate arrays to the controller.
# XML Download
form has a 'Download XML File' button as seen below. It will not process until the form has passed validation from the [jQuery Validation Plugin](http://jqueryvalidation.org/). Any restrictions such as required fields, minimum
acter count, maximum entries, etc. can be enforced within the kit_form.js file as a validation rule. New functions may also be written too for any special requirements.
wnload button](images/download_xml_button.png)
button is the form submission that takes the action to POST the form data to the [controllers/Kit_xml.php](HGTR/application/controllers/Kit_xml.php).
ild xml](images/build_xml.png)
controller takes all the POST data from the form, and uses it in building an
document. There are some calls to the [Kit_model](HGTR/application/models/Kit_model.php) to return a Gene ID from a given gene symbol, or to check if a possible input was user defined. For the latter, this will be used for any field
allows user input. The function will check each input for that field and see if it exists in the database. This is necessary, because if it does not exist, the value is not simply placed as the element text. By the GTR schema, a user
estion value is placed in the attribute, and for all such inputs the element text is 'Other'.
values are fixed for this XML document build. This controller is where any edits or updates need to be made for such fixed values. It is also where new fields or changes to the schema need to be reflected. At the end of the document build, the XML document is saved to a string which is named and a PHP function forces a download of the XML file to the client's machine. No views are loaded, the page does not redirect, the button submit action will POST to this controller
builds the document and downloads it in place.
Additional Libraries and Packages
[jQuery](https://jquery.com/) library is loaded for the dynamic functionality of many pages.
tstrap](http://getbootstrap.com/) is being used to make quick work of formatting and styling the site. The site uses the boostrap theme css, as well as the required boostrap css and js files.
ons, icons, and some images are from [Font Awesome](http://fortawesome.github.io/Font-Awesome/).
drop-down menus are being populated with data through Ajax calls that return data from the database. The drop-downs are then being constructed by [Selectize](http://brianreavis.github.io/selectize.js/).
form will not allow a file to be downloaded until certain rules are met. This is being enforced with [jQuery Validation Plugin](http://jqueryvalidation.org/).
ating sections are using jQuery functions to append a templated HTML section that in some places will update the ID and Name with a count so functions can be reapplied or separate arrays can be POSTed with similar, but different,
es.
External Sources
files without LGPL headers within [/HGTR](HGTR), excluding [/HGTR/assets](HGTR/assets) are part of the original CodeIgniter Web Framework 3.0 under the MIT License.