<?php
	/* (C) DairyWindow 2012-2017 */

	require "inc/connect.php";
	require "inc/fade.php";

	if(isset($_POST['new_location']) && $_POST['new_location']!=""){
		//create new location

		/*
		[new_group] => 4
		[new_location] => new_loc
		[new_friendly] => descr
		[new_order] => 1
		*/

		$new_group      = clean($_POST['new_group'     ]);
		$new_location   = clean($_POST['new_location'  ]);
		$new_friendly   = clean($_POST['new_friendly'  ]);
		$new_order      = clean($_POST['new_order'     ]);
		$new_lat        = clean($_POST['new_lat'       ]);
		$new_lng        = clean($_POST['new_lng'       ]);
		$new_colour     = clean($_POST['new_colour'    ]);
		$new_point_type = clean($_POST['new_point_type']);
		$new_point_size = clean($_POST['new_size'      ]);

		$sql="
			# get all locations that are >= order, and add 1
			Select
				dw_location.locationID,
				dw_location.locationOrder
			From
				dw_location
			Where
				dw_location.locationGroup  = ? And
				dw_location.locationOrder >= ? And
				dw_location.locationSite   = ?
			Order By
				dw_location.locationOrder,
				dw_location.locationText
		";
		if(!$qrylocations = mysqli_prepared_query($link, $sql, "iii", array($new_group, $new_order, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		foreach($qrylocations as $location_row){
			$sql="
				UPDATE dw_location SET
					locationOrder  = ?
				WHERE locationID = ?
			";
			if(!savesql($link, $sql, "ii", array(($location_row['locationOrder']+1), $location_row['locationID']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		}

		$sql="
			# insert new location
			INSERT INTO dw_location             (locationGroup,  locationText, locationFriendly, locationOrder,   locationModUser  ,     locationSite    , locationActive, locationModDate, locationLat, locationLng, locationPointType, locationPointSize, locationColour)
			VALUES                              (        ?    ,          ?   ,         ?       ,         ?    ,           ?        ,             ?       ,         1     ,      now()     ,      ?     ,      ?     ,         ?        ,         ?        ,         ?     )
		";
		if(!savesql($link, $sql, "issiiiddiii", array(  $new_group , $new_location,   $new_friendly ,   $new_order , $_SESSION['userID'], $_SESSION['userSite']                                ,  $new_lat  ,   $new_lng ,   $new_point_type,   $new_point_size,    $new_colour), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
	}else{
		if(isset($_POST['edit_id']) && $_POST['edit_id']!="" && $_POST['edit_id']!=null){
			if(isset($_POST['edit_delete'])){
				//check for orphans before deleting
				$edit_id = clean($_POST['edit_id']);
				$sql="
					# See if there will be orphans after deletion
					Select *
					From dw_unit
					Where unitLocation = ?
				";
				if(!$qrylocationid = mysqli_prepared_query($link, $sql, "i", array($edit_id), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
				$num_rows = mysqli_prepared_num_rows($qrylocationid);
				if($num_rows > 0){
					//orhans exist
					$message['text'] = "There are ".number_format($num_rows)." samples that use this location, so you cannot delete it. You must delete the samples first";
					$message['type'] = "error";
				}else{
					//ok to delete
					$sql="
						# Delete location
						Delete from dw_location
						Where locationID = ? and locationSite = ?
					";
					if(!savesql($link, $sql, "ii", array($edit_id, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
				}
			}else{
				//edit existing location

				/*
				[edit_group] => 1
				[edit_location] => Final product
				[edit_friendly] => dssdsd
				[edit_order] => 1
				[edit_active] => 1
				[edit_reason] => L5
				[edit_order_old] => 1
				[edit_id] => 996
				*/

				//get values
				$edit_group      = clean($_POST['edit_group'     ]);
				$edit_location   = clean($_POST['edit_location'  ]);
				$edit_friendly   = clean($_POST['edit_friendly'  ]);
				$edit_order      = clean($_POST['edit_order'     ]);
				if(isset($_POST['edit_active'])) $edit_active = 1;
				else $edit_active = 0;
				$edit_reason     = clean($_POST['edit_reason'    ]);
				$edit_lat        = clean($_POST['edit_lat'       ]);
				$edit_lng        = clean($_POST['edit_lng'       ]);
				$edit_colour     = clean($_POST['edit_colour'    ]);
				$edit_point_type = clean($_POST['edit_point_type']);
				$edit_point_size = clean($_POST['edit_size'      ]);
				$edit_order_old  = clean($_POST['edit_order_old' ]);
				$edit_id         = clean($_POST['edit_id'        ]);

				if($edit_order_old != $edit_order){
					$sql="
						# update all the location orders +1
						Select
							dw_location.locationID,
							dw_location.locationOrder
						From
							dw_location
						Where
							dw_location.locationGroup  = ? And
							dw_location.locationOrder >  ? And
							dw_location.locationOrder <= ? And
							dw_location.locationSite   = ?
						Order By
							dw_location.locationOrder,
							dw_location.locationText
					";
					if(!$qrylocations = mysqli_prepared_query($link, $sql, "iiii", array($edit_group, $edit_order_old, $edit_order, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
					foreach($qrylocations as $location_row){
						$sql="
							UPDATE dw_location SET 
								locationOrder = ?
							WHERE locationID = ?
						";
						if(!savesql($link, $sql, "ii", array(($location_row['locationOrder']+1), $location_row['locationID']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
					}
				}

				$sql="
					# update this location
					UPDATE dw_location SET
						locationText       = ?,
						locationFriendly   = ?,
						locationGroup      = ?,
						locationActive     = ?,
						locationOrder      = ?,
						locationChangeCode = ?,
						locationLat        = ?,
						locationLng        = ?,
						locationPointType  = ?,
						locationPointSize  = ?,
						locationColour     = ?,
						locationModDate    = now(),
						locationModUser    = ?
					WHERE locationID     = ?
				";
				if(!savesql($link, $sql, "ssiiisddidi ii", array(
					$edit_location,
					$edit_friendly,
					$edit_group,
					$edit_active,
					$edit_order,
					$edit_reason,
					$edit_lat,
					$edit_lng,
					$edit_point_type,
					$edit_point_size,
					$edit_colour,

					$_SESSION['userID'],
					$edit_id
				), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
			}
		}
	}

	$title = "Location";
	require "inc/head.php";
	$menu = "location";
	require "inc/menu.php";

	if($debug) showdebug();
	$map_text = "";
?>

	<div id="topDIV" >
		<h1 class="text-center">
			<?php echo $title; ?>
			<button type="button" class="btn btn-primary" data-toggle="modal" data-target="#new_location_form" onclick="update_location_new(<?php if($debug) echo "1"; else echo "0"; ?>);" ><span class='glyphicon glyphicon-plus' aria-hidden='true'></span>&nbsp;Create new</button>
		</h1>
	</div>

	<div id="loading" ><img src="images/loading-small.gif" alt="Please wait. Loading..." width="111" height="156" style="margin-top:150px;" class="center-block"><br><div class="text-center"><img src='images/carregando.gif' width='16' height='16'>&nbsp;Please wait while loading...</div></div>

	<div id="main" class="panel-group col-md-3" role="tablist" aria-multiselectable="true" style="display:none;" >
		<?php
			$sql="
		# get location groups
		Select
			dw_locgroup.locGroupID,
			dw_locgroup.locGroupText
		From
			dw_locgroup Right Join
			dw_location
				On dw_locgroup.locGroupID = dw_location.locationGroup
		Where
			dw_location.locationSite = ?
		Group By
			dw_locgroup.locGroupID
		Order By
			dw_locgroup.locGroupOrder,
			dw_locgroup.locGroupText
	";

			if(!$group_query = mysqli_prepared_query($link, $sql, "i", array($_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
			$counter = 0;
			foreach($group_query as $group_row){
				?>
				<div class="panel panel-default" id="group<?php echo $group_row['locGroupID']; ?>">
					<div class="panel-heading" role="tab" id="heading<?php echo $group_row['locGroupID']; ?>">
						<h4 class="panel-title">
							<a class="headinfo" data-toggle="collapse" data-parent="#main" href="#collapse<?php echo $group_row['locGroupID']; ?>" aria-expanded="<?php if($counter==0) echo "true"; else echo "false"; ?>" aria-controls="collapse<?php echo $group_row['locGroupID']; ?>">
								<?php
									echo $group_row['locGroupText'];
									if($debug) echo " <small>[".$group_row['locGroupID']."]</small>";
								?>
							</a>
							<span style="display:none;" class="headid"><?php echo $group_row['locGroupID']; ?></span>
						</h4>
					</div>
					<div id="collapse<?php echo $group_row['locGroupID']; ?>" class="panel-collapse collapse <?php if($counter==0) echo "in"; ?>" role="tabpanel" aria-labelledby="heading<?php echo $group_row['locGroupID']; ?>">
						<div class="panel-body">
							<div id="main<?php echo $group_row['locGroupID']; ?>" class="container-fluid"  >
								<div class="table-responsive" id="divtable<?php echo $group_row['locGroupID']; ?>">
									<table class="table table-hover sorttable" id="table<?php echo $group_row['locGroupID']; ?>">
										<thead>
										<tr id="table_head<?php echo $group_row['locGroupID']; ?>" style="background-color:white;color:inherit;white-space:nowrap;">
											<th class="text-center th_location" id="th_location<?php  echo $group_row['locGroupID']; ?>">Location</th>
											<th style="display:none;"           id="th_location2<?php echo $group_row['locGroupID']; ?>">Location</th>
											<th style="display:none;"           id="th_friendly<?php  echo $group_row['locGroupID']; ?>">Description</th>
											<th style="display:none;"           id="th_friendly2<?php echo $group_row['locGroupID']; ?>">Description</th>
											<th style="display:none;"           id="th_lat<?php       echo $group_row['locGroupID']; ?>">Lat</th>
											<th style="display:none;"           id="th_lng<?php       echo $group_row['locGroupID']; ?>">Lng</th>
											<th style="display:none;"           id="th_point<?php     echo $group_row['locGroupID']; ?>">Point</th>
											<th style="display:none;"           id="th_size<?php      echo $group_row['locGroupID']; ?>">Size</th>
											<th style="display:none;"           id="th_colour<?php    echo $group_row['locGroupID']; ?>">Colour</th>
											<th style="display:none;"           id="th_order<?php     echo $group_row['locGroupID']; ?>">Order</th>
											<th style="display:none;"           id="th_mod<?php       echo $group_row['locGroupID']; ?>"><?php if($_SESSION['userLevel']==1 || $_SESSION['userLevel']=="1") echo "Modified by"; ?></th>
											<th style="display:none;"           id="th_id<?php        echo $group_row['locGroupID']; ?>">ID</th>
											<th style="display:none;"           id="th_active<?php    echo $group_row['locGroupID']; ?>">Active</th>
										
										</tr>
										</thead>
										<tbody class="sortable">
										<?php
											$sql="
											# sql for this location group
											Select
												dw_locgroup.locGroupText,
												dw_location.locationID,
												dw_location.locationText,
												dw_location.locationGroup,
												dw_location.locationFriendly,
												dw_location.locationActive,
												dw_location.locationModDate,
												dw_location.locationOrder,
												dw_location.locationLat,
												dw_location.locationLng,
												dw_location.locationColour,
												dw_location.locationPointType as locationPoint,
												dw_location.locationPointSize as locationSize,
												dw_change.changeText,
												dw_user.userFirst,
												dw_user.userLast
											From
												dw_change Right Join
												(dw_user Right Join
												(dw_locgroup Right Join
												dw_location
													On dw_locgroup.locGroupID = dw_location.locationGroup)
													On dw_user.userID         = dw_location.locationModUser)
													On dw_change.changeID     = dw_location.locationChangeCode
											Where
												dw_location.locationSite    = ? And
												dw_location.locationGroup   = ?
											Order By
												dw_location.locationActive Desc,
												dw_location.locationOrder,
												dw_location.locationText";
											if(!$location_query = mysqli_prepared_query($link, $sql, "ii", array($_SESSION['userSite'], $group_row['locGroupID']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
											$locationcount = 0;
											$footer = false;
											foreach($location_query as $location_row){
												if($location_row['locationLat'] != "" && $location_row['locationLat'] != null && $location_row['locationLng'] != "" && $location_row['locationLng'] != null && $location_row['locationActive'] == 1){
													//define colours
													switch($location_row['locationColour']){
														case 1:
															$colour = "red";
															break;
														case 2:
															$colour = "green";
															break;
														case 3:
															$colour = "orange";
															break;
														case 4:
															$colour = "yellow";
															break;
														case 5:
															$colour = "purple";
															break;
														case 6:
															$colour = "grey";
															break;
														case 7:
															$colour = "black";
															break;
														default:
															$colour = "blue";
													}
													if($location_row['locationPoint']==1){ //square
														$map_text .= "
														var square".$location_row['locationID']." = L.polygon(
															[
																[".($location_row['locationLat']-($location_row['locationSize']/100000)).", ".($location_row['locationLng']-($location_row['locationSize']/100000))."],
																[".($location_row['locationLat']-($location_row['locationSize']/100000)).", ".($location_row['locationLng']+($location_row['locationSize']/100000))."],
																[".($location_row['locationLat']+($location_row['locationSize']/100000)).", ".($location_row['locationLng']+($location_row['locationSize']/100000))."],
																[".($location_row['locationLat']+($location_row['locationSize']/100000)).", ".($location_row['locationLng']-($location_row['locationSize']/100000))."]
															],{color: '".$colour."', fillOpacity: 0.3}
														).addTo(dwmap);
													";
													}
													if($location_row['locationPoint']==2){ //circle
														$map_text .= "
														var circle".$location_row['locationID']." = L.circle([".$location_row['locationLat'].", ".$location_row['locationLng']."], {
															fillOpacity: 0.5,
															radius: ".$location_row['locationSize']."
														}).addTo(dwmap);
													";
													}
													$map_text .= "add_marker(".$location_row['locationLat'].", ".$location_row['locationLng'].", \"<div class='map_popup'><strong><a href='#".$location_row['locationID']."' data-toggle='modal' data-target='#edit_location_form' onclick='update_location_edit(".$location_row['locationID'].",".$location_row['locationGroup'].",".($debug?"1":"0").");'>".$location_row['locationText']."</a></strong>";
													if($location_row['locationFriendly']!=""){
														$map_text .= "<br>".$location_row['locationFriendly'];
													}
													/*
													switch($location_row['locationColour']){
														case 1:
															$colour = "red";
															break;
														case 2:
															$colour = "green";
															break;
														case 3:
															$colour = "orange";
															break;
														case 4:
															$colour = "yellow";
															break;
														case 5:
															$colour = "purple";
															break;
														case 6:
															$colour = "grey";
															break;
														case 7:
															$colour = "black";
															break;
														default:
															$colour = "blue";
													}
													*/
													$map_text .= "</div>\", 'icon_".$colour."');\r\n";
												}
												if(!$footer && $location_row['locationActive']==0){
													$footer = true;
													echo "</tbody><tfooter>";
												}
												?>
												<tr class="text-nowrap <?php if($location_row['locationActive']==0 || $location_row['locationActive']=='0') echo "text-muted"; ?>" id="location_<?php echo $location_row['locationID']; ?>" data-toggle="modal" data-target="#edit_location_form" onclick="update_location_edit(<?php echo $location_row['locationID'].", ".$group_row['locGroupID'].", "; if($debug) echo "1"; else echo "0"; ?>);">
													<td class="text-center th_location" id="td_location-<?php  echo $location_row['locationID']; ?>" ><?php if($location_row['locationActive']==0 || $location_row['locationActive']=='0') echo "<span class='strikethrough'>"; echo fade(clean($location_row['locationText'    ]),20, $bgcolour, $fgcolour); if($debug) echo " <small>[".$location_row['locationID']."]</small>"; if($location_row['locationActive']==0 || $location_row['locationActive']=='0') echo "</span>"; ?></td>
													<td style="display:none;"           id="td_location2_<?php echo $location_row['locationID']; ?>"  <?php if($location_row['locationActive']==1 || $location_row['locationActive']=='1') echo "class='item".$location_row['locationGroup']."'"; echo ">".$location_row['locationText'];                                                                                                                                                                                         ?></td>
													<td style="display:none;"           id="td_friendly_<?php  echo $location_row['locationID']; ?>" ><?php if($location_row['locationActive']==0 || $location_row['locationActive']=='0') echo "<span class='strikethrough'>"; echo fade(clean($location_row['locationFriendly']),30, $bgcolour, $fgcolour);                                                                      if($location_row['locationActive']==0 || $location_row['locationActive']=='0') echo "</span>"; ?></td>
													<td style="display:none;"           id="td_friendly2_<?php echo $location_row['locationID']; ?>" ><?php                                                                                                                     echo            $location_row['locationFriendly'];                                                                                                                                                                                                ?></td>
													<td style="display:none;"           id="td_lat_<?php       echo $location_row['locationID']; ?>" ><?php                                                                                                                     echo            $location_row['locationLat'     ];                                                                                                                                                                                                ?></td>
													<td style="display:none;"           id="td_lng_<?php       echo $location_row['locationID']; ?>" ><?php                                                                                                                     echo            $location_row['locationLng'     ];                                                                                                                                                                                                ?></td>
													<td style="display:none;"           id="td_point_<?php     echo $location_row['locationID']; ?>" ><?php                                                                                                                     echo            $location_row['locationPoint'   ];                                                                                                                                                                                                ?></td>
													<td style="display:none;"           id="td_size_<?php      echo $location_row['locationID']; ?>" ><?php                                                                                                                     echo            $location_row['locationSize'    ];                                                                                                                                                                                                ?></td>
													<td style="display:none;"           id="td_colour_<?php    echo $location_row['locationID']; ?>" ><?php                                                                                                                     echo            $location_row['locationColour'  ];                                                                                                                                                                                                ?></td>
													<td style="display:none;"           id="td_order_<?php     echo $location_row['locationID']; ?>"  <?php if($location_row['locationActive']==1 || $location_row['locationActive']=='1') echo "class='orders".$location_row['locationGroup']."'"; echo ">".$location_row['locationOrder'];                                                                                                                                                                                      ?></td>
													<td style="display:none;"           id="td_mod_<?php       echo $location_row['locationID']; ?>" title="<?php echo $location_row['changeText']; ?>" >
														<?php
															if($_SESSION['userLevel']==1 || $_SESSION['userLevel']=="1"){
																$fullname = $location_row['userFirst']." ".$location_row['userLast'];

																if($location_row['locationActive']==0 || $location_row['locationActive']=='0') echo "<span class='strikethrough'>";
																echo $fullname." ".date('j/n/y',strtotime($location_row['locationModDate']));
																if($location_row['locationActive']==0 || $location_row['locationActive']=='0') echo "</span>";
															}
														?>
													</td>
													<td style="display:none;"           id="td_id_<?php        echo $location_row['locationID']; ?>" ><?php                                                                                                                     echo            $location_row['locationID'];                                                                                                                                                                                                      ?></td>
													<td style="display:none;"           id="td_active_<?php    echo $location_row['locationID']; ?>" ><?php                                                                                                                     echo            $location_row['locationActive'];                                                                                                                                                                                                  ?></td>
												</tr>
												<?php
												if($location_row['locationActive']==1 || $location_row['locationActive']=='1') $locationcount++;
											}
											if($footer) echo "</tfooter>";
											else echo "</tbody>";
										?>

									</table>
								</div>
								<div class="text-nowrap text-muted text-center">
									<small><?php echo $locationcount." ".$group_row['locGroupText']; ?> locations</small>
								</div>
							</div>
						</div>
					</div>
				</div>
				<?php
				$counter++;
			}
		?>
	</div>

	<div style='display:none;'>
		<div id='site_map'       >images/<?php echo $_SESSION['userSite']."/"; if($_SESSION['site_map']=="") echo "company_logo.png"; else echo $_SESSION['site_map']; ?></div>
		<div id='latitude'       ><?php if($_SESSION['latitude'       ]==null || $_SESSION['latitude'       ]=="") echo "0"; else echo $_SESSION['latitude'       ]; ?></div>
		<div id='longitude'      ><?php if($_SESSION['longitude'      ]==null || $_SESSION['longitude'      ]=="") echo "0"; else echo $_SESSION['longitude'      ]; ?></div>
		<div id='site_map_left'  ><?php if($_SESSION['site_map_left'  ]==null || $_SESSION['site_map_left'  ]=="") echo "0"; else echo $_SESSION['site_map_left'  ]; ?></div>
		<div id='site_map_top'   ><?php if($_SESSION['site_map_top'   ]==null || $_SESSION['site_map_top'   ]=="") echo "0"; else echo $_SESSION['site_map_top'   ]; ?></div>
		<div id='site_map_right' ><?php if($_SESSION['site_map_right' ]==null || $_SESSION['site_map_right' ]=="") echo "0"; else echo $_SESSION['site_map_right' ]; ?></div>
		<div id='site_map_bottom'><?php if($_SESSION['site_map_bottom']==null || $_SESSION['site_map_bottom']=="") echo "0"; else echo $_SESSION['site_map_bottom']; ?></div>
	</div>

	<div class="col-md-9" role="main" id="map_container">
		<div id="map" style="width:100vw; height:100vh;"></div>
	</div>

	<div id="new_location_form" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="new_locationLabel" aria-hidden="true">
		<div class="modal-dialog">
			<div class="modal-content">
				<form class="container-fluid panel-info" method="post">
					<div class="modal-header">
						<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
						<h2 class="modal-title" id="new_locationLabel">New location details</h2>
					</div>
					<div class="modal-body">

						<div class="form-group">
							<label for="new_group" >Group</label>
							<?php
								$sql="
								# group for new location
								Select
									dw_locgroup.locGroupID,
									dw_locgroup.locGroupText
								From
									dw_locgroup
								Where
									dw_locgroup.locGroupID > ?
								Order By
									dw_locgroup.locGroupOrder,
									dw_locgroup.locGroupText
							";
								if(!$group_query = mysqli_prepared_query($link, $sql, "i", array(0), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
							?>
							<select name="new_group" id="new_group" class="form-control" onchange="update_location_new(<?php if($debug) echo "1"; else echo "0"; ?>);" >
								<?php
									foreach($group_query as $grouprow){
										echo "<option value='".$grouprow['locGroupID']."' ";
										if(isset($_POST['new_group']) && $_POST['new_group']==$grouprow['locGroupID']) echo "selected ";
										echo ">".$grouprow['locGroupText'];
										if($debug) echo " [".$grouprow['locGroupID']."]";
										echo "</option>";
									}
								?>
							</select>
						</div>

						<div class="form-group">
							<label for="new_location" >Location</label>
							<input type="text" class="form-control" id="new_location" name="new_location" placeholder="Location text" required >
						</div>

						<div class="form-group">
							<label for="new_friendly" >Description</label>
							<input type="text" class="form-control" id="new_friendly" name="new_friendly" placeholder="Description (optional)" >
						</div>

						<div class="form-group">
							<div class="col-sm-12" style="padding-left:0; padding-right:0">
								<label for="new_lat" >Position</label>
							</div>
							<div class="col-sm-6" style="padding-left:0;">
								<input type="number" class="form-control" id="new_lat" name="new_lat" placeholder="Latitude" step="0.00001" min="-360" max="360">
							</div>
							<div class="col-sm-6" style="padding-right:0;">
								<input type="number" class="form-control" id="new_lng" name="new_lng" placeholder="Longitude" step="0.00001" min="-360" max="360">
							</div>
						</div>

						<div class="form-group">
							<div class="col-sm-12" style="padding-left:0; padding-right:0">
								<label for="new_point_type" >Type</label>
							</div>
							<div class="col-sm-6" style="padding-left:0;">
								<select id="new_point_type" name="new_point_type" class="form-control">
									<option value="0" selected>Point</option>
									<option value="1">Square</option>
									<option value="2">Circle</option>
								</select>
							</div>
							<div class="col-sm-6" style="padding-right:0;">
								<input type="number" class="form-control" id="new_size" name="new_size" placeholder="Size" value="0" step="0.1" min="0" max="360">
							</div>
						</div>

						<div class="form-group">
							<label for="new_colour" >Colour</label>
							<select id="new_colour" name="new_colour" class="form-control">
								<?php
									$colours = array("Blue", "Red", "Green", "Orange", "Yellow", "Purple", "Grey", "Black");
									foreach($colours as $index=>$colour){
										echo "<option data-content=\"<span><img src='images/marker-".strtolower($colour).".png' width='12' height='20' style='vertical-align:middle'>&nbsp;".$colour."</span>\" data-thumbnail='images/marker-".strtolower($colour).".png' value='$index'>$colour</option>\n";
									}
								?>
							</select>
						</div>

						<div class="form-group">
							<label for="new_order" >Insert this location in the list <strong>after</strong></label>
							<select name="new_order" id="new_order" class="form-control" >
								<!-- list goes here, populated by /js/location.js -->
							</select>
						</div>
					
					</div>
					<div class="modal-footer">
						<button type="button" class="btn btn-default" data-dismiss="modal"><span class='glyphicon glyphicon-remove' aria-hidden='true'></span>&nbsp;Cancel</button>
						<button type="submit" class="btn btn-primary" id="new_location_button" onclick="please_wait('new_location_button');"><span class='glyphicon glyphicon-ok' aria-hidden='true'></span>&nbsp;Create</button>
					</div>
				</form>
			</div>
		</div>
	</div>

	<div id="edit_location_form" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="edit_locationLabel" aria-hidden="true">
		<div class="modal-dialog">
			<div class="modal-content">
				<div class="modal-header">
					<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
					<h2 class="modal-title" id="edit_locationLabel">Edit location details</h2>
				</div>
				<form class="container-fluid panel-info" method="post">
					<div class="modal-body">
						<div class="form-group">
							<label for="edit_group" >Group</label>
							<select name="edit_group" id="edit_group" class="form-control" onchange="update('edit_location_reason', 'L2');" >
								<!-- Groups will go here (location.js:generate_group_dropdown) -->
							</select>
						</div>
						<div class="form-group">
							<label for="edit_location" >Location</label>
							<input type="text" class="form-control" id="edit_location" name="edit_location" placeholder="Location text" onchange="update('edit_location_reason', 'L1');" required >
						</div>
						<div class="form-group">
							<label for="edit_friendly" >Description</label>
							<input type="text" class="form-control" id="edit_friendly" name="edit_friendly" placeholder="Description (optional)" onchange="update('edit_location_reason', 'L5');">
						</div>
						<div class="form-group">
							<div class="col-sm-12" style="padding-left:0; padding-right:0">
								<label for="edit_lat" >Position</label>
							</div>
							<div class="col-sm-6" style="padding-left:0;">
								<input type="number" class="form-control" id="edit_lat" name="edit_lat" placeholder="Latitude" step="0.00001" min="-360" max="360">
							</div>
							<div class="col-sm-6" style="padding-right:0;">
								<input type="number" class="form-control" id="edit_lng" name="edit_lng" placeholder="Longitude" step="0.00001" min="-360" max="360">
							</div>
						</div>
						<div class="form-group">
							<div class="col-sm-12" style="padding-left:0; padding-right:0">
								<label for="edit_point_type" >Type</label>
							</div>
							<div class="col-sm-6" style="padding-left:0;">
								<select id="edit_point_type" name="edit_point_type" class="form-control">
									<option value="0">Point</option>
									<option value="1">Square</option>
									<option value="2">Circle</option>
								</select>
							</div>
							<div class="col-sm-6" style="padding-right:0;">
								<input type="number" class="form-control" id="edit_size" name="edit_size" placeholder="Size" step="0.1" min="0" max="360">
							</div>
						</div>
						<div class="form-group">
							<label for="edit_colour" >Colour</label>
							<select id="edit_colour" name="edit_colour" class="form-control">
								<?php
									foreach($colours as $index=>$colour){
										echo "<option data-content=\"<span><img src='images/marker-".strtolower($colour).".png' width='12' height='20' style='vertical-align:middle'>&nbsp;".$colour."</span>\" data-thumbnail='images/marker-".strtolower($colour).".png' value='$index'>$colour</option>\n";
									}
								?>
							</select>
						</div>
						<div class="form-group">
							<label for="edit_order" >Reposition this location in the list <strong>after</strong></label>
							<select name="edit_order" id="edit_order" class="form-control" onchange="update('edit_location_reason', 'L3');">
								<!-- order list goes here -->
							</select>
						</div>
						<div class="form-group">
							<label for="edit_active" >Is the product <strong>active?</strong> </label>
							<input type="checkbox" data-toggle="toggle" id="edit_active" name="edit_active" data-onstyle="success" data-offstyle="default" data-on="Yes" data-off="No" value="1" onchange="update('edit_location_reason','L4');" >
						</div>

						<input type="<?php if($debug) echo "text"; else echo "hidden"; ?>" id="edit_location_reason" name="edit_reason" title="edit_location_reason">
						<input type="<?php if($debug) echo "text"; else echo "hidden"; ?>" id="edit_order_old" name="edit_order_old" title="edit_order_old">
						<input type="<?php if($debug) echo "text"; else echo "hidden"; ?>" id="edit_id" name="edit_id" title="edit_id">
					
					</div>
					<div class="modal-footer">
						<button type="submit" class="btn btn-danger" name="edit_delete" value="1"><span class="glyphicon glyphicon-trash" aria-hidden="true"></span>&nbsp;Delete</button>
						<button type="button" class="btn btn-default" data-dismiss="modal"><span class='glyphicon glyphicon-remove' aria-hidden='true'></span>&nbsp;Cancel</button>
						<button type="submit" class="btn btn-primary" id="edit_location_button" onclick="please_wait('edit_location_button');"><span class='glyphicon glyphicon-ok' aria-hidden='true'></span>&nbsp;Update</button>
					</div>
				</form>
			</div>
		</div>
	</div>

	<link rel="stylesheet" href="https://unpkg.com/leaflet@1.2.0/dist/leaflet.css" integrity="sha512-M2wvCLH6DSRazYeZRIm1JnYyh22purTM+FDB5CsyxtQJYeKq83arPe5wgbNmcFXGqiSH2XR8dT/fJISVA1r/zQ==" crossorigin="">
	<script src="https://unpkg.com/leaflet@1.2.0/dist/leaflet.js" integrity="sha512-lInM/apFSqyy1o6s89K4iQUKg6ppXEgsVxT35HbzUupEVRh2Eu9Wdl4tHj7dZO0s1uvplcYGmt3498TtHq+log==" crossorigin=""></script>
	<script src="js/location.js?v=2.2">/* Include JS specific to location.php (this file) */</script>

<?php
	if($map_text!="") echo "<script>".$map_text."</script>";

	if(isset($_GET['l']) && $_GET['l']!="" && $_GET['l']!=null){
		$sql="
			# see if it actualy exists
			Select
				dw_location.locationID
			From
				dw_location
			Where
				dw_location.locationID = ? And
				dw_location.locationSite = ?
		";
		if(!$qrylocationid = mysqli_prepared_query($link, $sql, "ii", array($_GET['l'], $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
		if(mysqli_prepared_num_rows($qrylocationid)==1){
			echo "
				<script>
					$('#edit_location_form').modal('show');
					update_location_edit(".clean($_GET['l']).", ".clean($_GET['g'])."); //locationid, groupid
				</script>
			";
		}
	}
	require "inc/footer.php";
?>