-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpoligonos.php
136 lines (128 loc) · 5.21 KB
/
poligonos.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
<?php
session_start();
$userid = @$_SESSION["uid"];
if($userid==""){
header("Location: /");
exit;
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
<title>Poligonos / Servitrans</title>
<!-- Bootstrap -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/style.css" rel="stylesheet">
<link rel="stylesheet" href="css/font-awesome.min.css">
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
<style>
#map-container { min-height: 755px; height: 100%;}
</style>
</head>
<body>
<!-- Fixed navbar -->
<!--<nav class="navbar navbar-default navbar-fixed-top" style="background-color:#008175;color:#97BE0D;">-->
<?php include("menu.php"); ?>
<div class="container">
<div class="page-header" style="margin-top:0;">
<h3 style="margin-top:0;">Geocercas <small>Administración de geocercas</small></h3>
</div>
<div class="row">
<div class="col-md-12">
<div class="panel panel-default">
<div class="panel-heading clearfix">
<div class="btn-group pull-right">
<!--<a href="#" class="btn btn-default btn-sm">Ver Detalle</a>-->
</div>
<!--<h3 class="panel-title" style="padding-top:5px;">-->
<h3 class="panel-title">
Poligonos
</h3>
</div>
<div class="panel-body">
<table class="table table-hover" style="font-size: 100%;">
<thead>
<tr>
<th style="width: 10px;">ID</th>
<th>Nombre</th>
<th style="width: 70px;">Tipo</th>
<th style="width: 70px;">
<div class="btn-group" role="group">
<button type="button" class="btn btn-primary dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
Acciones
<span class="caret"></span>
</button>
<ul class="dropdown-menu">
<li><a href="javascript:window.open('./crear_poligono.php','verPoligono','width=900, height=720');">Nuevo</a></li>
</ul>
</div>
</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$username="root";
$password="r1r7C1h6ZG4ZVWF";
$database="traccar";
$locations = array();
$link = mysqli_connect("sscl-db-instance.chapmhehekr9.us-east-1.rds.amazonaws.com",$username,$password) or die(mysqli_error());
mysqli_select_db($link, $database) or die(mysqli_error());
$q = "SELECT id, name, tipo FROM traccar.geofences ORDER BY name;";
$resultado = mysqli_query($link, $q) or die(mysqli_error());
while ($row = mysqli_fetch_array($resultado)) {
if($row["tipo"]==1){
$row["tipo"] = "Ruta";
}
if($row["tipo"]==2){
$row["tipo"] = "Base";
}
if($row["tipo"]==3){
$row["tipo"] = "Relleno o Vertedero";
}
?>
<tr>
<td style="vertical-align: middle;" nowrap><?php echo $row["id"];?></td>
<td style="vertical-align: middle;" nowrap><?php echo utf8_encode($row["name"]);?></td>
<td style="vertical-align: middle;" nowrap><?php echo $row["tipo"];?></td>
<td style="vertical-align: middle;">
<div class="btn-group" role="group">
<button type="button" class="btn btn-primary dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
Acciones
<span class="caret"></span>
</button>
<ul class="dropdown-menu">
<li><a href="javascript:window.open('./ver_poligono.php?pid=<?php echo $row["id"];?>','verPoligono','width=900, height=720');">Mapa</a></li>
</ul>
</div>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div> <!-- /container -->
<footer class="footer">
<div class="container">
<p class="text-muted" style="color: #008175;">Sistema de Rastreo 1.0 / Servitrans / Cumsensu / 2016 © Todos los derechos reservados</p>
</div>
</footer>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.2/jquery.min.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="js/bootstrap.min.js"></script>
</body>
</html>