<?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');
include_once($questionnaire_dir."admin/editor_check_post.php");

$_SESSION['editor_calling_page'] = $_SERVER['PHP_SELF'];
$_SESSION['editor_title'] = "Experiment Editor";


$validfields = TRUE;

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "add_experiment")) {

  $addExpRequiredInfo = (editor_check_post($_POST['experiment_title'],"Experiment Title","string",$_SERVER['PHP_SELF'],FALSE) &&
  				  editor_check_post($_POST['response_table'],"Response Table","nbstring",$_SERVER['PHP_SELF'],FALSE));

  if($addExpRequiredInfo) {
  		$resp_encrypted = (isset($_POST['encrypted_resp_table']) && ($_POST['encrypted_resp_table'] == 'Yes'))? 'T' : 'F';
		$start_date = sprintf("20%s-%s-%s",$_POST['start_year'],$_POST['start_month'],$_POST['start_day']);
		$insertSQL = sprintf("INSERT INTO experiment (start_date, experiment_title, experiment_description, response_table, encrypted_response_table) VALUES (%s, %s, %s, %s, %s)",
						   GetSQLValueString($start_date, "date"),
						   GetSQLValueString($_POST['experiment_title'], "text"),
						   GetSQLValueString($_POST['experiment_description'], "text"),
						   GetSQLValueString($_POST['response_table'],"text"),
						   GetSQLValueString($resp_encrypted,"text"));
	
		mysql_select_db($database_researcher, $researcher);
		$Result1 = mysql_query($insertSQL, $researcher) or die(mysql_error());
		$_SESSION['editor_experiment_id'] = mysql_insert_id($researcher);
		
	 //add all required forms to experiment_x_form
	  $sql_required_forms = sprintf("insert into experiment_x_form (experiment_id,form_id,form_order,form_handler) values ");
	  for($fidx = 0; $fidx < sizeof($required_form_ids); $fidx++) {
		$sql_required_forms .= sprintf("(%d,%d,%d,'%s')",$_SESSION['editor_experiment_id'],$required_form_ids[$fidx],($fidx+1),$required_form_handlers[$fidx]);
		($fidx != (sizeof($required_form_ids)-1) ) ? $sql_required_forms .= "," : NULL;
	  }
	
	  mysql_insert($sql_required_forms);
	
	  include_once('generate_tickets.php');
	
	
  } //if($validfields)
  
}

//handle setting of experiment parameters (params field in experiment table)
if(isset($_POST['set_exp_params'])) {
  foreach($_POST as $key=>$val) {
    if(array_key_exists($key,$EXPERIMENT_PARAMS)) {
      $submitParams[$key] = $val;
    }
  }
  set_experiment_params($submitParams);
 }


if(isset($_POST['set_exp_lang'])) {

	$sql_set_language = sprintf("update experiment set language='%s' where experiment_id = %d",$_POST['language'],$_SESSION['editor_experiment_id']);
	mysql_update($sql_set_language);

}

if((isset($_POST['duplicate_experiment_name']))) {

	$addExpRequiredInfo = (editor_check_post($_POST['duplicate_experiment_name'],"Experiment Title","string",$_SERVER['PHP_SELF'],FALSE) &&
  				  editor_check_post($_POST['response_table'],"Response Table","nbstring",$_SERVER['PHP_SELF'],FALSE));

	if($addExpRequiredInfo) {
		$sql_duplicate_experiment = sprintf("insert into experiment (experiment_title,response_table) values(%s,%s)",
			GetSQLValueString($_POST['duplicate_experiment_name'],"text"),GetSQLValueString($_POST['response_table'],"text"));
		mysql_insert($sql_duplicate_experiment);
		$duplicate_experiment_id = mysql_insert_id();
		$sql_duplicate_experiment_forms = sprintf("insert into experiment_x_form select %d,form_id,form_order,form_handler,goto,`repeat`,`condition`,condition_matlab,stimulus_matlab, break_loop_button, break_loop_button_text ",$duplicate_experiment_id).
										  sprintf("from experiment_x_form where experiment_id = %d",$_SESSION['editor_experiment_id']);
		mysql_insert($sql_duplicate_experiment_forms);
	}	
	
}

//create a new response table if an experiment was created or duplicated
if((isset($_POST['duplicate_experiment_name']) || (isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "add_experiment")) && $addExpRequiredInfo) {
		$create_response_table = sprintf("CREATE TABLE %s.%s ( `response_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,",
									$database_researcher,$_POST['response_table'])
			. ' `response_order` int( 10 ) unsigned NOT NULL default \'0\','
			. ' `date_time` datetime default NULL ,'
			. (($_POST['encrypted_resp_table'] == 'Yes')? ' `response_text` blob default NULL ,' : ' `response_text` text default NULL ,')
			. (($_POST['encrypted_resp_table'] == 'Yes')? ' `response_enum` blob default NULL ,' : ' `response_enum` bigint( 20 ) unsigned default NULL ,')
			. ' `question_id` int( 10 ) unsigned default NULL,'
			. ' `form_question_num` smallint( 5 ) unsigned default NULL,'
			. ' `question_iteration` tinyint( 4 ) unsigned default NULL,'
			. ' `subquestion` tinyint( 4 ) unsigned default NULL,'
			. ' `trial_id` int( 10 ) unsigned default NULL ,'
			. ' `stimulus_id` int( 10 ) unsigned default NULL ,'
			. ' `form_id` int( 10 ) unsigned NOT NULL default \'0\','
			. ' `form_order` int( 5 ) unsigned NOT NULL default \'0\','
			. ' `session_id` int( 10 ) unsigned NOT NULL default \'0\','
			. ' `subject_id` varchar( 50 ) NOT NULL default \'\','
			. ' `experiment_id` int( 10 ) unsigned NOT NULL default \'0\','
			. ' `misc_info` text default NULL ,'
			. ' `decline`  enum(\'T\',\'F\') NOT NULL default \'F\','
			. ' PRIMARY KEY ( `response_id` ) ) ENGINE = InnoDB PACK_KEYS =0'
			. ' ';
		mysql_query($create_response_table,$researcher) or die(mysql_error());
}


if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "experiment_selector")) {
	$_SESSION['editor_experiment_id'] = $_POST['experiment_id'];

	//get experiment title and store this in a session variable
	$sql_get_experiment_title = sprintf("select experiment_title from experiment where experiment_id = %d",$_SESSION['editor_experiment_id']);
	$get_experiment_title = mysql_select($sql_get_experiment_title);
	$_SESSION['editor_experiment_title'] = $get_experiment_title['experiment_title'];
}

if(isset($_POST['experiment_lock'])) {

	$experiment_locked = (isset($_POST['lock_flag']))? 'T' : 'F';
	$play_question_audio = (isset($_POST['audio_flag']))? 'T' : 'F';
	$sql_lock_experiment = sprintf("update experiment set locked = %s, play_question_audio = %s where experiment_id = %d",
		GetSQLValueString($experiment_locked,"text"),GetSQLValueString($play_question_audio,"text"),$_SESSION['editor_experiment_id']);
	mysql_update($sql_lock_experiment);

}

?>

<?php if($validfields) { ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/html4/frameset.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Experiment Editor</title>
</head>

<frameset cols="350,150">
  <frame src="experiment_form_list.php" name="Experiment Form List" frameborder="no" noresize marginwidth="10">
  <frame src="experiment_selector.php" name="Experiment Selector" noresize>
</frameset>
<noframes><body>
</body></noframes>
</html>
<?php } //if($validfields) ?>