<?php
/*********************************************************************************************************
  "Ensemble" is the proprietary property of The Regents of the University of California ("The Regents.")

  Copyright (c) 2005-10 The Regents of the University of California, Davis campus. All Rights Reserved.

  Redistribution and use in source and binary forms, with or without modification, are permitted by
  nonprofit, research institutions for research use only, provided the conditions in the included
  license agreement are met.

  Refer to the file "ensemble_license.txt" for the license agreement,
  located in the top level directory of this distribution.

**********************************************************************************************************/
//Author: Stefan Tomic
//Janata Lab
//Center for Mind and Brain
//Developed for the Ensemble Project


require_once('../include/researcher_includes.php');
$_SESSION['editor_calling_page'] = $_SERVER['PHP_SELF'];

$SECONDS_PER_DAY = 3600 * 24;


$report_type = (isset($_POST['crit']))? $_POST['crit'] : "not_completed";
$time_window = (empty($_POST['num_days']) || !isset($_POST['num_days']))? 0 : $_POST['num_days'];
$sort_by = (isset($_POST['sort_by']))? $_POST['sort_by'] : "start_time";
$sort_order = (isset($_POST['sort_order']))? $_POST['sort_order'] : "descending";

$completed_selected_str = ($report_type == "completed")? "selected" : "";
$not_completed_selected_str = ($report_type == "not_completed")? "selected" : "";
$all_selected_str = ($report_type == "all")? "selected" : "";

$sort_by_starttime_selected = ($sort_by == "start_time")? "selected" : "";
$sort_by_completion_selected = ($sort_by == "completion_stat")? "selected" : "";
$sort_by_endtime_selected = ($sort_by == "end_time")? "selected" : "";
$sort_by_lastname_firstname_selected = ($sort_by == "last_name_first_name")? "selected" : "";
$sort_by_subject_id_selected = ($sort_by == "subject_id")? "selected" : "";

$sort_order_asc_selected = ($sort_order == "ascending")? "selected" : "";
$sort_order_desc_selected = ($sort_order == "descending")? "selected" : "";


//get start time criteria for sessions
// a value of 0 means no time criteria
if($time_window != 0) {
  $start_time_crit = date("Y-m-d H:i:s",time() - $SECONDS_PER_DAY * $time_window);
  $sql_time_crit = sprintf(" and date_time >= '%s' ",$start_time_crit);
 }
 else {
   $sql_time_crit = "";
 }
   
if($report_type == "completed") {
  $sql_completion = " and end_datetime is not null";
 }
elseif($report_type == "not_completed") {
  $sql_completion = " and end_datetime is null";
}
elseif($report_type == "all") {
  $sql_completion = "";
  
}


if($sort_order == "ascending")
  $sort_order_str = "asc";
elseif($sort_order == "descending")
  $sort_order_str = "desc";

switch($sort_by) {
 case "start_time":
   $sort_by_str = "order by date_time " . $sort_order_str;
   break;
 case "completion_stat":
   $sort_by_str = "order by is_completed " . $sort_order_str;
   break;
 case "end_time":
   $sort_by_str = "order by end_datetime " . $sort_order_str;
   break;
 case "last_name_first_name":
   $sort_by_str = "order by name_last_lower " . $sort_order_str . ",name_first_lower " . $sort_order_str;
   break;
 case "subject_id":
   $sort_by_str = "order by subject_id " . $sort_order_str;
 }

$enc_key = subinfo_encryption_key();
$sql_get_sessions = sprintf("select subject.subject_id as `subject_id`, aes_decrypt(`name_last`,'%s') as name_last,",$enc_key).
  sprintf(" lower(convert(aes_decrypt(`name_last`,'%s') using utf8)) as name_last_lower, ",$enc_key).
  sprintf(" lower(convert(aes_decrypt(`name_first`,'%s') using utf8)) as name_first_lower, ",$enc_key).
  sprintf(" aes_decrypt(`name_middle`,'%s') as name_middle, aes_decrypt(`name_first`,'%s') as name_first,",$enc_key,$enc_key).
  sprintf(" session.session_id, date_time, end_datetime, (end_datetime is not null) as `is_completed` from subject left join session using (subject_id) ").
  sprintf("where subject_id not like 'tmp_%%' and session.experiment_id = %d %s %s %s",
	  $_SESSION['editor_experiment_id'],$sql_completion,$sql_time_crit,$sort_by_str);

$get_sessions = mysql_query($sql_get_sessions) or report_error_form(mysql_error());
	
if(!isset($_POST['export_to_file'])) {

    ?>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title>Session Report</title>
    <style type="text/css">
    <!--
    @import url("../include/qei_stylesheet.css");
     -->
    </style>
	
    </head>
	
    <body>
    <?php

     printf("<table><tr><td>");
     printf("<h2>Session report for experiment \"%s\"</h2>",$_SESSION['editor_experiment_title']);
     printf("</td><td>");
     printf("<form name=\"export_data\" id=\"export_data\" method=POST action=\"%s\"><input type=\"button\" value=\"Print this page\" onClick=\"window.print()\" />",$_SERVER['PHP_SELF']);
     printf("<input type=hidden name=\"crit\" id=\"crit\" value=\"%s\">\n",$report_type);
     printf("<input type=hidden name=\"num_days\" id=\"num_days\" value=\"%s\">\n",$time_window);
     printf("<input type=hidden name=\"sort_by\" id=\"sort_by\" value=\"%s\">\n",$sort_by);
     printf("<input type=hidden name=\"sort_order\" id=\"sort_order\" value=\"%s\">\n",$sort_order);
     printf("<input type=\"submit\" name=\"export_to_file\" id=\"export_to_file\" value=\"Export to file\"></form>");
     printf("</td></tr></table>");
     printf("<h3>Report generated on %s</h3>",date("D, M j, g:i:s a"));
     printf("<form name=\"select_crit\" id=\"select_crit\" method=POST action=\"%s\">\n",$_SERVER['PHP_SELF']);
     printf("Report ");
     printf("<select name=\"crit\" id=\"crit\" onchange=\"document.forms.select_crit.submit()\">\n");
     printf("<option value=\"completed\" %s>completed</option>\n",$completed_selected_str);
     printf("<option value=\"not_completed\" %s>incomplete</option>\n",$not_completed_selected_str);
     printf("<option value=\"all\" %s>all</option>\n",$all_selected_str);
     printf("</select>\n");
     printf(" sessions initiated within the last ");
     printf("<input type=text size=3 name=\"num_days\" id=\"num_days\" value=%d onchange=\"document.forms.select_crit.submit()\">",$time_window);
     printf(" days (0 = no time limit)\n");
     printf("<br>Sort by \n");
     printf("<select name=\"sort_by\" id=\"sort_by\" onchange=\"document.forms.select_crit.submit()\">\n");
     printf("<option value=\"start_time\" %s>start time</option>\n",$sort_by_starttime_selected);
     printf("<option value=\"completion_stat\" %s>completed status</option>\n",$sort_by_completion_selected);
     printf("<option value=\"end_time\" %s>end time</option>\n",$sort_by_endtime_selected);
     printf("<option value=\"last_name_first_name\" %s>last name, first name</option>\n",$sort_by_lastname_firstname_selected);
     printf("<option value=\"subject_id\" %s>subject id</option>\n",$sort_by_subject_id_selected);
     printf("</select>\n");
     printf(" in ");
     printf("<select name=\"sort_order\" id=\"sort_order\" onchange=\"document.forms.select_crit.submit()\">\n");
     printf("<option value=\"ascending\" %s>ascending</option>",$sort_order_asc_selected);
     printf("<option value=\"descending\" %s>descending</option>",$sort_order_desc_selected);
     printf("</select>\n");
     printf(" order<br>");
     printf("<input type=\"submit\" name=\"Submit\" value=\"Submit\">\n");
     printf("</form>\n");
     
     print("<p>&nbsp;</p>\n");
     printf("<table border=1><tr><th>Subject ID</th><th>Last Name</th><th>First Name</th><th>Middle Name</th><th>Session ID</th><th>Start Time</th><th>End Time</th><th>Status</th></tr>\n");
 }
 else {
   $exp_stub = strtolower(str_replace(" ","_",$_SESSION['editor_experiment_title']));
   $date_stub = date("Ymd_His");
   $export_fname = sprintf("session_report_%s_%s.csv",$exp_stub,$date_stub);
   text_download_header($export_fname);
   printf("Subject ID,Last Name,First Name,Middle Name,Session ID,Start Time,End Time,Status\n");
 }

while($row_get_sessions = mysql_fetch_assoc($get_sessions)) {
  $compl_status = (($row_get_sessions['is_completed'])? "completed" : "not completed");


  if(!isset($_POST['export_to_file'])) {
    printf("<tr>");
    printf("<td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%d</td><td>%s</td><td>%s</td><td>%s</td>",
	   $row_get_sessions['subject_id'],$row_get_sessions['name_last'],
	   $row_get_sessions['name_first'],$row_get_sessions['name_middle'],
	   $row_get_sessions['session_id'],$row_get_sessions['date_time'],
	   $row_get_sessions['end_datetime'],$compl_status);
    print "</tr>";
  }
  else {
    printf("%s, %s, %s, %s, %d, %s, %s, %s\n",
	   $row_get_sessions['subject_id'],$row_get_sessions['name_last'],
	   $row_get_sessions['name_first'],$row_get_sessions['name_middle'],
	   $row_get_sessions['session_id'],$row_get_sessions['date_time'],
	   $row_get_sessions['end_datetime'],$compl_status);
  }
  
 }

if(!isset($_POST['export_to_file'])) {
  printf("</table><br>");
 }
  

?>