Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /*
- Just edit everything below to set everything up for your server. Else, don't touch the script
- unless you know what you're doing.
- */
- define('MYSQL_BOTH',MYSQLI_BOTH);
- define('MYSQL_NUM',MYSQLI_NUM);
- define('MYSQL_ASSOC',MYSQLI_ASSOC);
- header('Content-type:application/json;charset=utf-8');
- $host = "localhost"; //The host of your SQL server. Usually localhost
- $user = "admin_info"; //The user of your SQL server.
- $password = "Carloselpeor1"; //The password to the user of your SQL server.
- $database = "admin_info"; //Your GunBound database name
- /* Parametros */
- /* estatico */
- $opt = $_GET['opt'];
- $link = new mysqli($host,$user,$password,$database); //mysql_connect($host,$user,$password);
- $link->set_charset("utf8");
- if(!$link){ mysql_error(); die();}
- /* Se realizan todas las consultas aqui*/
- $regid = $link->real_escape_string(stripslashes($_GET['login']));
- $regpass = $link->real_escape_string(stripslashes($_GET['password']));
- /* 1 = updateLocation(); -- 99 = updateLogin(); -- 90 = disconcect() */
- if ($opt == 9){
- //mb_internal_encoding('UTF-8');
- $login = $link->real_escape_string(stripslashes($_GET['login']));
- $password = $link->real_escape_string(stripslashes($_GET['password']));
- $login = mb_strtolower($login, 'UTF-8');
- $result = "SELECT count(id) as existe FROM empleado WHERE login = '$login' AND PASSWORD = '$password'";
- $runsql = $link->query($result);//$mysql_query($sql);
- $infosql = mysqli_fetch_array($runsql, MYSQL_ASSOC);
- //die(implode("|",$infosql));
- $count = $infosql['existe'];
- if($count>0){
- $getID = "SELECT id FROM empleado WHERE login = '$login' AND PASSWORD = '$password'";
- $runsql = $link->query($getID);//$mysql_query($sql);
- $infosql = mysqli_fetch_array($runsql, MYSQL_ASSOC);
- $checkid = $infosql['id'];
- $consulta = "UPDATE `admin_info`.`empleado` SET `estado`='1' WHERE `id`='$checkid'";
- $runsql = $link->query($consulta);
- $response = array(
- 'id' => $checkid,
- 'message' => 'ok'
- );
- die(json_encode($response));
- //die(implode("|",$checkid));
- } else {
- $response = array(
- 'id' => 0,
- 'message' => 'Datos incorrectos'
- );
- die(json_encode($response));
- }
- }
- if ($opt == 1){//Se actualiza la ubicacion del empleado
- $id = $link->real_escape_string(stripslashes($_GET['id']));
- $latitud = $link->real_escape_string(stripslashes($_GET['latitud']));
- $longitud = $link->real_escape_string(stripslashes($_GET['longitud']));
- $consulta = "UPDATE `admin_info`.`movil` SET `latitud`='$latitud', `longitud`='$longitud' WHERE `idTaxista`='$id'";
- $runsql = $link->query($consulta);//$mysql_query($sql);
- //$infosql = mysqli_fetch_array($runsql, MYSQL_ASSOC);
- $response = array(
- 'estado' => 'ok'
- );
- die(json_encode($response));
- }
- if ($opt == 90){// El empleado ha apagado el aparato
- $id = $link->real_escape_string(stripslashes($_GET['id']));
- $consulta = "UPDATE `admin_info`.`empleado` SET `estado`='0' WHERE `id`='$id'";
- $runsql = $link->query($consulta);//$mysql_query($sql);
- //$infosql = mysqli_fetch_array($runsql, MYSQL_ASSOC);
- $response = array(
- 'estado' => 'off'
- );
- die(json_encode($response));
- }
- if ($opt == 5) {//Guardar Viaje
- $id = $link->real_escape_string(stripslashes($_GET['id']));
- $latitudInicio = $link->real_escape_string(stripslashes($_GET['latitudInicio']));
- $longitudInicio = $link->real_escape_string(stripslashes($_GET['longitudInicio']));
- $latitudFin = $link->real_escape_string(stripslashes($_GET['latitudFin']));
- $longitudFin = $link->real_escape_string(stripslashes($_GET['longitudFin']));
- $consulta = "INSERT INTO `admin_info`.`bitacora` (`id`, `latitudInicio`, `longitudInicio`, `latitudFin`, `longitudFin`) VALUES ('$id', '$latitudInicio', '$longitudInicio', '$latitudFin', '$longitudFin')";
- $runsql = $link->query($consulta);//$mysql_query($sql);
- //$infosql = mysqli_fetch_array($runsql, MYSQL_ASSOC);
- $response = array(
- 'estado' => 'ok'
- );
- die(json_encode($response));
- }
- if ($opt == 3) {//Corregir reconexion
- $id = $link->real_escape_string(stripslashes($_GET['id']));
- $estado = $link->real_escape_string(stripslashes($_GET['estado']));
- $consulta = "UPDATE `admin_info`.`empleado` SET `estado`='$estado' WHERE `id`='$id'";
- $runsql = $link->query($consulta);//$mysql_query($sql);
- //$infosql = mysqli_fetch_array($runsql, MYSQL_ASSOC);
- $response = array(
- 'estado' => 'ok'
- );
- die(json_encode($response));
- }
- if ($opt == 2){//Se pide auxilio
- $id = $link->real_escape_string(stripslashes($_GET['id']));
- $latitud = $link->real_escape_string(stripslashes($_GET['latitud']));
- $longitud = $link->real_escape_string(stripslashes($_GET['longitud']));
- $consulta = "INSERT INTO `admin_info`.`auxilio` (`id`, `latitud`, `longitud`) VALUES ('$id', '$latitud', '$longitud')";
- $runsql = $link->query($consulta);//$mysql_query($sql);
- $consulta = "UPDATE `admin_info`.`empleado` SET `icono`='https://i.imgur.com/IdaKTDs.png?1' WHERE `id`='$id'";
- $runsql = $link->query($consulta);//$mysql_query($sql);
- //$infosql = mysqli_fetch_array($runsql, MYSQL_ASSOC);
- /*
- Lista de Iconos
- Normal: https://i.imgur.com/3O18sMg.png?1
- Auxilio: https://i.imgur.com/IdaKTDs.png?1
- */
- /* WhatsApp API */
- $INSTANCE_ID = '18'; // TODO: Replace it with your gateway instance ID here
- $CLIENT_ID = "underbolivia@gmail.com"; // TODO: Replace it with your Forever Green client ID here
- $CLIENT_SECRET = "145a581793ee447298bb4ed8760588bf";
- $headers = array(
- 'Content-Type: application/json',
- 'X-WM-CLIENT-ID: '.$CLIENT_ID,
- 'X-WM-CLIENT-SECRET: '.$CLIENT_SECRET
- );
- $url = 'http://api.whatsmate.net/v3/whatsapp/single/image/message/' . $INSTANCE_ID;
- $ch = curl_init($url);
- curl_setopt($ch, CURLOPT_POST, 1);
- curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
- curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
- $getIcon = "SELECT img, nombres, apellidos, telefono from empleado WHERE id = '$id'";
- $rsql = $link->query($getIcon);//$mysql_query($sql);
- $isql = mysqli_fetch_array($rsql, MYSQL_ASSOC);
- $icono = $isql['img'];
- $myNombres = $isql['nombres'].' '.$isql['apellidos'];
- $myTelefono = $isql['telefono'];
- //echo $icono;
- //echo $myNombres;
- $pathToImage = "https://lefitel.site/img/empleado/".$icono;
- //echo $pathToImage;
- $imageData = file_get_contents($pathToImage);
- $base64Image = base64_encode($imageData);
- //echo $base64Image;
- /* Send Data*/
- $consulta = "SELECT telefono FROM empleado WHERE estado = '1'";
- $resultado = $link->query($consulta);
- while ($row = $resultado->fetch_assoc()) {
- $postData = array(
- 'number' => '+591'.$row["telefono"], // TODO: Specify the recipient's number here. NOT the gateway number
- 'image' => $base64Image,
- 'caption' => '¡¡Necesito tu ayuda!!, abajo esta mi ubicacion. Mi numero de telefono es: '.$myTelefono.' Mi nombre es: '.$myNombres.' Mi ubicacion: http://www.google.com/maps/place/'.$latitud.','.$longitud
- /*'message' => 'http://www.google.com/maps/place/'.$latitud.','.$longitud*/
- );
- curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($postData));
- $response = curl_exec($ch);
- /*echo "Response: ".$response." Se envio al numero: ".$row["telefono"];*/
- }
- //$link->close();
- //echo "Response: ".$response;
- curl_close($ch);
- $response = array(
- 'estado' => 'ok'
- );
- die(json_encode($response));
- }
- if ($opt == 8){//Se actualiza icono
- $id = $link->real_escape_string(stripslashes($_GET['id']));
- $consulta = "UPDATE `admin_info`.`empleado` SET `icono`='https://i.imgur.com/3O18sMg.png?1' WHERE `id`='$id'";
- $runsql = $link->query($consulta);
- $response = array(
- 'estado' => 'ok'
- );
- die(json_encode($response));
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement