Installation

Install

• Build LAMP or WIMP environment.
• Place the files and subfolder from html/ into your web server's directory.
  • On Debian. this was /var/www/html/.
• Place the files from code/ into a shared directory where the system can run the code.
  • On our server. we used /usr/share/eacjr/code.
• Run the SQL scripts from sql/ on your MySQL server to create the database.
• Create a user account for EACJR code to connect to the MySQL database.
• Install PHPMailer.
• Complete the System Variables setup. (see below)
• Complete the Cron Jobs setup. (see below)

Use

• Place CSV file with patient data and clinician data in input_data/.
• Run push2portal.php to load the csv data into the MySQL database.
• Surf to your portal website and login with default administrator user.
  • Default user: [email protected] Default pass: ChangeMe1!
  • You will be required to change the Admin password. DO THIS NOW!
• Go to Administration > View User List.
• Add a unique administrative user.
• Logout of default administrator user and back in as your unique administrative user.
• Disable the default administrator user.
• Add study committee members/jury pool users.
• Go to Administration > View study information.
• Add study.
  • Move desired users into the study.
  • Note: These users should only be committee members, not a non-voting Admin or principal investigator.
• View status as needed.
• View reports as needed.

System Variables

You will need to set the following variables before the portal functions correctly.

in datacon.php (located in two folders, html/ and code/)

• $MySqlHostName = "SQL HOST HERE";
• $MySqlUserName = "SQL USER HERE";
• $MySqlPassWord = "SQL PASSWORD HERE";
• $MySqlDataBase = "jury_room";
• $mail_sig = "PORTAL NAME HERE FOR USE IN MAIL SIG AND SUBJECT LINES";
• $mail_password = "EMAIL PASSWORD HERE";
• $mail_username = "EMAIL@EMAIL";
• $mail_host = "MAIL HOST GOES HERE";
• $host_url = "URL FOR PORTAL GOES HERE";
• $options = [ 'cost' => NUMBER GOES HERE ]; // used for hashing on PHP < 7.0
• $secret = "reCAPTCHA SECRET CODE GOES HERE";
• $sitekey = "reCAPTCHA SITE KEY GOES HERE";

commonfunctions.php

• $logger_email = "LOGVIEWER EMAIL ADDRESS HERE";
• $mail_password = "EMAIL PASSWORD HERE";
• $mail_username = "EMAIL USERNAME HERE";
• $mail_host = "MAIL HOST GOES HERE";
• $mail_sig = "PORTAL NAME HERE FOR USE IN MAIL SIG AND SUBJECT LINES";

Cron jobs

• code/phase-check.php
  • This checks for quorum and consensus from the committee votes.
  • In testing, this ran every 5 minutes; in production, it ran once a week.
• code/email-check.php
  • This sends committee members an email reminder to complete tasks.
  • In testing and production, it ran once a week (about an hour after the phase-check.php job).
• code/racetrack_update.php
  • This scans the database and updates the racetrack displays.
  • In testing and production, it ran every 5 minutes.