batch_import_file.php

<?php
require 'lib/global.php';
$imported=FALSE;
$errors=array();

if(isset($_POST['submit'])) {
	// Check user
	//$USER->validateUser($_POST['user_hash']);
	//if($USER->auth>1) {
	// Batch import can only be done by managers and admins
	// Import from file
	//$filename=filter_var($_POST['filename'],FILTER_SANITIZE_STRING);

	$mimes = array('application/vnd.ms-excel','text/plain','text/csv','text/tsv');

	if(in_array($_FILES['batch_file']['type'],$mimes)){
		// Go through each plate/position pair (one per line) and validate plate name and position
		if(($handle=fopen('temp/'.$filename,"r"))!==FALSE) {
			$verified=array();
			while($line=fgetcsv($_FILES['batch_file']['tmp_name'],1000,',')) {
				$plate=parseQuery($line[0]);
				$position=parsePosition($line[1]);
				if($plate['name']) {
					if($position['type']='position') {
						// Plate and position ok, add to verified list
						$rack=getRack($position['rack_id']);
						if(!$rack['error']) {
							$verified[]=$line;
						} else {
							// Invalid position
						}
					} else {
						// Invalid position barcode
					}
				} else {
					// This does not seem to be a valid plate barcode
				}
			}
		} else {
			// Could not open file
			$ALERTS->setAlert('Could not open file','error');
		}
	} else {
		// Not a CSV
		$ALERTS->setAlert('File type must be CSV','error');
	}
	
	// -----------------------
	// IMPORT TO DB
	if(($handle=fopen('temp/'.$filename,"r"))!==FALSE) {
		// Read data from file
		$rack_id=FALSE;
		while(($data=fgetcsv($handle,1000,","))!==FALSE) {
			$position=parsePosition($data[1]);
			if(!$rack_id) {
				$rack_id=$position['rack_id'];
			}
			
			if($rack_id==$position['rack_id']) {
				$plate=parseQuery($data[0]);
				if($plate['name']) {
					$addplate=plateAdd($plate['name'],$data[1],$USER->data['user_email'],$filename);
					if($addplate['error']) {
						$errors[]=array('message' => 'Could not add plate '.$data[0].' to position '.$data[1].': '.$addplate['error'], 'data' => $data);
					}
				} else {
					$errors[]=array('message' => 'Invalid plate name: '.$data[0].', plate not added to position '.$data[1], 'data' => $data);
				}
			} else {
				$errors[]=array('message' => 'Could not add plate '.$data[0].' to position '.$data[1].'. Plates can only be batch imported in 1 rack at a time.', 'data' => $data);
			}
		}
		fclose($handle);
		// Delete temp file
		unlink('temp/'.$filename);
		$imported=TRUE;
	} else {
		// Could not open file
		$ALERTS->setAlert('Could not open file','error');
	}
	//} else {
		// Not authorized
	//	$ALERTS->setAlert('Not authorized','warning');
	//}
}

if($imported) {
	// Plate data has been imported
	$rack=getRack($rack_id);
	$table=new htmlTable('Rack '.$rack['data']['rack_name'].' in '.$rack['storage']['storage_name'],array('class' => 'rack'));
	$table->addData(parseRackLayout($rack['layout']));

	$card=new zurbCard();
	$card->divider('Plates imported from file: '.$filename);
	$card->section('Please verify rack layout below and make sure to check any reported errors');

	$html=$card->render();
	$html.=$table->render();
	
	// Report errors after submit
	if(count($errors)) {
		$ALERTS->setAlert('Import generated errors','warning');
		$html.='<div class="alert callout">Please check the following errors!</div>';
		foreach($errors as $error) {
			$html.=$error['message'].'<br>';
		}
	}
	
	$html.='<br><a href="batch_import.php?uid='.$USER->data['uid'].'" class="button"><i class="fi-arrow-up"></i> Import again</a>';
} else {
	// New import
	if(isset($_GET['uid'])) {
		if($user=$USER->getUser($_GET['uid'])) {
			// Batch import is only allowed for managers and admins
			if($user['user_auth']>1) {
				$card=new zurbCard();
				$card->divider('Batch import of plates from CSV-file');
				$card->section('Format file with plate ID and rack position separated with comma, one per line. <strong>Use with caution!</strong>');
				$html=$card->render();
				
				$theform=new htmlForm('batch_import.php');
				
				$theform->addInput(FALSE,array('type' => 'hidden', 'name' => 'uid', 'value' => $_GET['uid']));
				$theform->addInput(FALSE,array('type' => 'hidden', 'name' => 'filename', 'value' => $filename));
				//$theform->addInput('Scan plate/position',array('type' => 'text', 'name' => 'batch_data', 'value' => '', 'id' => 'batch_data', 'autocomplete' => 'off'));
				$theform->addInput('Upload CSV-file',array('type' => 'file', 'name' => 'batch_file', 'id' => 'batch_file'));
				//$theform->addInput("Operator (scan your personal barcode to import)",array("type" => "password", "name" => "user_hash", "value" => "", "required" => "", "id" => "user_hash", "autocomplete" => "off"));
				$theform->addInput(FALSE,array('type' => 'submit', 'name' => 'submit', 'value' => 'Upload and verify', 'class' => 'button'));
				$html.=$theform->render();
				$html.='<div id="batch_message" class="primary callout">Please select file</div>';
				$html.='<div id="batch_list"></div>';
			} else {
				$html='<p>Not authorized</p>';
			}
		} else {
			$html='<p>User does not exist</p>';
		}
	} else {
		$html='<p>No user selected</p>';
	}
}



// Render Page
//=================================================================================================
?>

<!doctype html>
<html class="no-js" lang="en" dir="ltr">

<head>
	<meta charset="utf-8">
	<meta http-equiv="x-ua-compatible" content="ie=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<title>PlateJuggler</title>
	<link rel="stylesheet" href="css/foundation.css">
	<link rel="stylesheet" href="css/app.css">
	<link rel="stylesheet" href="css/icons/foundation-icons.css" />
</head>

<body>
<?php require '_menu.php'; ?>

<div class="row">
<br>
<div class="large-12 columns">
<?php echo $html; ?>
</div>
</div>

<script src="js/vendor/jquery.js"></script>
<script src="js/vendor/what-input.js"></script>
<script src="js/vendor/foundation.js"></script>
<script src="js/app.js"></script>
</body>

</html>