Mercurial > hg > extraction-interface

view map/coordinates/map.php @ 2:da5309d54083

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
add missing books to sections as dummy entries for further modification. (1) Alter "Auto_increment" to 5190896 for sections table in database. (2) Finds missing books (using mysql OR _select_distinct() in add_missing_books_to_sections.php (3) Put the missing_books.csv in intermediate_results. and execute: add_missing_books_to_sections.php
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Fri, 23 Jan 2015 19:00:57 +0100
parents b12c99b7c3f0
children
line wrap: on
line source

<!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"/>
                <link href="map.css" type="text/css" rel="stylesheet"/>
                <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js" type="text/javascript"></script>
		<script src="https://code.jquery.com/ui/1.10.4/jquery-ui.js"></script>
		<link href="../../geotemco/css/platin.css" rel="stylesheet" type="text/css">
        	<script src="../../geotemco/platin.js"></script>
        	<script src="map.js"></script>
        </head>
        <body>
		
		<div class="container" id="overlayLoaderContainer"></div>
		<div class="container" id="listContainer">
<?php
$fileName="./map_input_files/list.csv";
if(isset($_GET['list'])&&$_GET['list']==176){
	$fileName="./map_input_files/list_176.csv";
}
$fp=fopen($fileName,"r");
while(!feof($fp)){
	$data=fgetcsv($fp,1000000);
	echo "<div class='book'>";
	echo "<div class='attr level1'>".$data[0]."</div>";
	echo "<div class='attr date'>".$data[1]."</div>";
	echo "<div class='attr title'>".$data[2]."</div>";
	echo "<div class='attr placeName'>".$data[3]."</div>";
	echo "<div class='attr bookId'>".$data[4]."</div>";
	echo "<div class='attr number'>".$data[5]."</div>";
	echo "<div class='coordinateList'>";
	for($i=0; $i<$data[5];$i++){
		$coor=fgetcsv($fp,1000000);
		echo "<div class='coordinate'><div class='x'>".$coor[0]."</div>, <div class='y'>".$coor[1]."</div></div>";
	}	
	echo "</div>";
	echo "</div>";
}

?>			
		</div>
		<div class="container" id="mapContainer"></div>

		<div class='defloater'></div>
	
		<div class="container" id="tableContainer"></div>
        </body>
</html>