<?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.

**********************************************************************************************************/
require_once('../include/researcher_includes.php');

//create datetime string
if($_POST['set_expiration'] == 'F')
	$expiration_datetime = "";
else
	$expiration_datetime = date("Y-m-d H:i:s",mktime($_POST['ticket_expiration_hour'],0,0,$_POST['ticket_expiration_month'],$_POST['ticket_expiration_day'],$_POST['ticket_expiration_year']));

$sql_get_next_id = "show table status like 'ticket'";
$get_next_id = mysql_query($sql_get_next_id) or die(mysql_error());
$result_get_next_id = mysql_fetch_assoc($get_next_id);
$next_ticket_id = $result_get_next_id['Auto_increment'];

$sql_get_experiment_info = sprintf("select * from experiment where experiment_id = %d",$_SESSION['editor_experiment_id']);
$get_experiment_info = mysql_select($sql_get_experiment_info);
$response_table = $get_experiment_info['response_table'];


$ticket_values = "";
for($iticket = 1; $iticket <= $_POST['num_tickets']; $iticket++) {
	//create a string in the format <ticket_id><response_table name><experiment_id> and hash it using md5 to create the ticket code
	$unencrypted_string = $next_ticket_id.$response_table.$_SESSION['editor_experiment_id'];
	$encrypted_string = md5($unencrypted_string);
	$ticket_values .= sprintf("(%s,%s,%s,%s)",						
						GetSQLValueString($encrypted_string,"text"),
						GetSQLValueString($_SESSION['editor_experiment_id'],"int"),
						GetSQLValueString($_POST['ticket_type'],"text"),
						GetSQLValueString($expiration_datetime,"date"));
	($iticket < $_POST['num_tickets']) ? $ticket_values.=',' : NULL ;
	$next_ticket_id++;

}


$sql_create_ticket = sprintf("insert into ticket (ticket_code, experiment_id, type, expiration_datetime) values %s",$ticket_values);

$gen_ticket_success = mysql_insert($sql_create_ticket);

?>