/
tracking.class.Controller.php
executable file
·130 lines (128 loc) · 6.72 KB
/
tracking.class.Controller.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
<?php
session_start();
require 'tracking.class.Conexion.php';
require 'tracking.class.View.php';
include 'tracking.class.Confirmation.email.php';
class Controller{
private $pdo;
private $model;
private $usu;
private $fecha;
function recoger($usu){
$modelo=new Conexion();
$pdo=$modelo->conectar();
if(!$pdo){
die('could not connect' . PDO_error());
}else{
echo "estamos en recoger";echo "<br>";
//**********************esta select orginal********************
$recoger=$pdo->query("SELECT * FROM `tracking` WHERE `id_usuario`='$usu'");
//(SELECT * FROM `tracking` WHERE DATE(`fecha`) = '$alternate' and `id_usuario`='$usu');
//*****************************************************************
$recoger->execute();
$result= $recoger->fetchAll(PDO::FETCH_ASSOC);
//print_r($result);
$mostro=new View();
$mostro->mostrar($result);
}
}
function insertar($model){
$timezone = date_default_timezone_get();
$date = date('m/d/Y h:i:s a', time());
$date = date('Y-m-d H:i:s');
//$pdo=new PDO('mysql:host=localhost;dbname=TEST','root','internet80');
$modelo=new Conexion();
$pdo=$modelo->conectar();
if(!$pdo){
die('could not connect' . PDO_error());
}else{
$insert=$pdo->query("INSERT INTO `tracking`(`id_usuario`, `latitude`, `longitude`, `fecha`) VALUES ('$model->_usuario','$model->_latitude','$model->_longitude','$date');");
//if($insert){echo "echo"};
}
}
function recogerconfecha($usu,$fecha){
$modelo=new Conexion();
$pdo=$modelo->conectar();
// $pdo=new PDO('mysql:host=localhost;dbname=TEST','root','internet80');
if(!$pdo){
die('could not connect' . PDO_error());
}else{echo "estamos en recoge fecha"; echo "<br>";
//echo "<input type='button' value='delete ALL' "; echo "<br>";
echo '<td>'."<a href=tracking.class.php?action=callfunction&id=".$usu."&fecha=".$fecha."><input type='button' value='delete ALL'></a>".'</td>';
//*********************esta select con la fecha*******************
// idea hay q pasar en el metodo la variable $alternate !!!!!!!!!!!!!!!!!!!!!!111
$recoger=$pdo->query("SELECT * FROM `tracking` WHERE DATE(`fecha`) = '$fecha' and `id_usuario`='$usu'");
///******************************************************************
$recoger->execute();
$result= $recoger->fetchAll(PDO::FETCH_ASSOC);
$mostro=new View();
$mostro->mostrar($result);
}
}
function delete($id){
$modelo=new Conexion();
$pdo=$modelo->conectar();
if(!$pdo){
die('could not connect'.PDO_error());
}else{
$delete=$pdo->query("DELETE FROM `tracking` WHERE `id_tracking`='$id'");
$delete->execute();
echo "la fila se elimono corectamente";
}
}
function deleteconfecha($usu,$fecha){
echo "estamos en deleteconfecha";echo "<br>";
echo $usu;echo "<br>";
echo $fecha;
$modelo=new Conexion();
$pdo=$modelo->conectar();
if(!$pdo){
die('could not connect'.PDO_error());
}else{
$deleteconfecha=$pdo->query("DELETE FROM `tracking` WHERE `id_usuario`='$usu' and `fecha` BETWEEN '$fecha 00:00:00.00' AND '$fecha 23:59:59.999'");
$deleteconfecha->execute();
if($deleteconfecha){echo "se borro todo corectamente";
}
}
}
function crearusuario($log,$nom,$pass,$ema){
$modelo=new Conexion();
$pdo=$modelo->conectar();
if(!$pdo){
die('could not connect'.PDO_error());
}else{
$key = $nom . $ema . date('mY');
$key = md5($key);
echo $key;
$crearusu=$pdo->query("INSERT INTO `TEST`.`users` (`id`, `login`, `nombre`, `password`, `email`, `active`)
VALUES (NULL, '$log', '$nom', '$pass', '$ema', UNHEX('0'));");
echo "<br>";
$userid= $pdo->lastInsertId();
$confirm = $pdo->query("INSERT INTO `confirm` VALUES(NULL,'$userid','$key','$ema')");
}
if($crearusu&&$confirm){
$con_email=new Confirmation();
$confirmation=$con_email->email_confirm($nom,$key,$ema);
header("location: tracking.login.html");}
}
function login($log,$pass){
$modelo=new Conexion();
$pdo=$modelo->conectar();
if(!$pdo){
die('could not connect'.PDO_error());
}else{
$searchusu=$pdo->query("select * from users where password='$pass' AND login='$log' and `active`=1");
$searchusu->execute();
$result=$searchusu->fetchAll(PDO::FETCH_ASSOC);
if ($result) {
$_SESSION['login_user']=$log;
// Initializing Session
header("location: tracking.class.php"); // Redirecting To Other Page
} else {header("location: index.php"); echo "false";
// $error = "Username or Password is invalid";
}
}
}
function extract(){ header("location: map.html");}
}
?>