<body>
<div data-role="popup" id="popupBasic"></div>
<div id="audio-wrap">
<audio id="alert" src="<?php
echo base_url();
?>
assets/audio/alert.mp3" type="audio/mpeg" autobuffer controls></audio>
</div>
<!-- Login -->
<div data-role="page" id="login-page">
<div data-theme="b" data-role="header">
<h3>
<?php
echo ci_config('app_name_');
?>
</h3>
</div>
<div data-role="content">
<div style=" text-align:center">
<img style="width: 96px; height: 96px" src="<?php
echo base_url();
?>
assets/images/logo.png">
</div>
<form id="login-form" action="" method="POST">
<div data-role="fieldcontain">
<label for="username">
?>
assets/js/jquery-1.10.2.min.js"></script>
<script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=true"></script>
<script src="<?php
echo base_url();
?>
assets/js/komira.js"></script>
<script>
var lang = '<?php
echo current_lang();
?>
';
var verification_interval = <?php
echo ci_config('verification_interval');
?>
;
</script>
</head>
<body>
<!-- body content here -->
<div class="row">
<div class="large-6 large-centered columns"><h2 class="centered-text"><?php
echo $this->config->item('app_name');
?>
</h2></div>
</div>
function get_sos($id, $lat, $lng)
{
$sql = " SELECT *, (acos(sin(radians({$lat})) * sin(radians(latitud)) + ";
$sql .= " cos(radians({$lat})) * cos(radians(latitud)) * ";
$sql .= " cos(radians({$lng}) - radians(longitud))) * 6378) as distancia ";
$sql .= " from agente ";
$sql .= " where id<>{$id} and fecha_sos > ( CURRENT_TIMESTAMP( ) - INTERVAL 60 SECOND ) ";
$sql .= " HAVING distancia < " . ci_config('distance_call_sos');
$sql .= " ORDER BY distancia LIMIT 1 ";
$sol = $this->db->query($sql)->result();
if (!count($sol)) {
return null;
}
return $sol[0];
}
