· 6 years ago · Jul 04, 2019, 07:16 PM
1function edit(event){
2 start = event.start.format('YYYY-MM-DD');
3 if(event.end){
4 end = event.end.format('YYYY-MM-DD');
5 }else{
6 end = start;
7 }
8
9 id = event.id;
10 titulo = event.title;
11 Event = [];
12 Event[0] = id;
13 Event[1] = start;
14 Event[2] = end;
15 Event[3] = titulo;
16
17
18 $.ajax({
19 url: 'editEventDate.php',
20 type: "POST",
21 data: {Event:Event},
22 success: function(rep) {
23 if(rep == 'OK'){
24
25 swal({
26 position: 'top-end',
27 type: 'success',
28 title: 'modificado correctamente',
29 showConfirmButton: false,
30 timer: 1500
31 });
32
33
34 }
35
36<?
37 require_once('clases/bdd.php');
38
39 require ("scripts/scriptValidaSession.php");
40 require ("clases/ticket.class.php");
41 require ("clases/baseDatos.class.php");
42 require ("clases/usuario.class.php");
43 require ("PHPMailer/class.phpmailer.php");
44
45 $conexion = new baseDatos();
46
47 if ($conexion->connect_errno) {
48
49 echo "Fallo la conexion: ".$conexion->connect_error;
50 }
51
52 $usuario = new Usuario();
53
54 $consulta = $usuario->searchUser($conexion, $_SESSION['ticket_id']);
55
56 $resultado = $consulta->fetch_array(MYSQLI_ASSOC);
57
58 $ticket = new Ticket();
59
60 $ticket->setIdUsuario($_SESSION['ticket_id']);
61
62
63 if (isset($_POST['Event'][0]) && isset($_POST['Event'][1]) && isset($_POST['Event'][2]) && isset($_POST['Event'][3])){
64
65
66 $id = $_POST['Event'][0];
67 $start = $_POST['Event'][1];
68 $end = $_POST['Event'][2];
69 $titulo = $_POST['Event'][3];
70
71
72
73 $sql = "UPDATE events SET start = '$start', end = '$end' WHERE id = $id ";
74
75
76 $query = $bdd->prepare( $sql );
77 if ($query == false) {
78 print_r($bdd->errorInfo());
79 die ('Erreur prepare');
80 }
81 $sth = $query->execute();
82 if ($sth == false) {
83 print_r($query->errorInfo());
84 die ('Erreur execute');
85 }else{
86 die ('OK');
87 }
88
89 $mail = new PHPMailer(); // create a new object
90 $mail->IsSMTP(); // enable SMTP
91 $mail->SMTPDebug = 0; // debugging: 1 = errors and messages, 2 = messages only
92 $mail->SMTPAuth = true; // authentication enabled
93 $mail->SMTPSecure = 'tls'; // secure transfer enabled REQUIRED for GMail
94 $mail->Host = "smtp.gmail.com"; //ultima
95 $mail->Port = 587;// or 465
96 $mail->IsHTML(true);
97 $mail->Username = "@gmail.com"; //ultima
98 $mail->Password = "."; //ultima
99 $mail->SetFrom("@gmail.com","Sistemas"); //ultima
100 $mail->Subject = "Atencion! se ha modificado la hora del evento: ".$_POST['title'];
101 $mail->Body = "
102
103 <div style="width: 800px;height: ".(350+(strlen($_POST['observacion'])/6))."px;border: 1px solid #ddd;border-radius:6px;">
104
105 <div style="width: 770px;height: 20px;margin-top: 0; margin-bottom: 0; font-size: 20px; color: inherit;color: #333;
106 background-color: #f5f5f5;
107 border-color: #ddd;padding: 10px 15px;
108 border-bottom: 1px solid transparent;
109 border-top-left-radius: 3px;
110 border-top-right-radius: 3px;">
111
112 <strong>Evento modificado</strong>
113
114 </div>
115
116 <div style="border-top: 1px solid #ddd;padding: 15px;background:white;">
117
118 Hola equipo, soy <strong>".$resultado['personaNombre']." ".$resultado['apellido']."</strong>,<br> Les informo sobre un cambio en la hora del evento , aqui la info:
119
120 <table style="border-collapse: collapse;width: 100%;margin-bottom: 20px;">
121
122
123 <tr>
124 <th style="background-color: #fff;text-align: left;padding-top:5px;">Hora del evento</th>
125 <td style="background-color: #fff;text-align: left;padding-top:5px;">".$_POST['hora']."</td>
126 </tr>
127
128 </table>
129 Muchas gracias por su apoyo :)
130 </div>
131
132 </div>";
133
134
135 $mail->CharSet = 'UTF-8';
136 $mail->AddAddress("@gmail.com");// es la direccion de correo a donde enviamos una copia de lo ocurrido
137 $mail->Send();
138
139 }
140 //header('Location: '.$_SERVER['HTTP_REFERER']);
141
142 ?>