commit | author | age
|
a13080
|
1 |
<?php |
F |
2 |
namespace App\Models; |
|
3 |
|
|
4 |
use PDO; |
|
5 |
use Framework\Model; |
|
6 |
class Contact extends Model { |
|
7 |
//protected ?string $table = "product"; |
|
8 |
|
|
9 |
public function controlloSpamEmail(string $email, ): bool { |
|
10 |
$spam = false; |
|
11 |
$query = "SELECT email, dtm_richiesta FROM Contact WHERE email = '$email' AND dtm_richiesta BETWEEN DATE_SUB(NOW(), INTERVAL 1 DAY) AND NOW();"; |
|
12 |
$connection = $this->database->getConnection(); |
|
13 |
|
|
14 |
$result = $connection->query($query); |
|
15 |
|
|
16 |
$rowcount = count($result->fetchAll(PDO::FETCH_ASSOC)); |
|
17 |
var_dump($rowcount); |
|
18 |
|
|
19 |
|
|
20 |
if ($rowcount > 0) { |
|
21 |
$spam = true; |
|
22 |
} |
|
23 |
|
|
24 |
return $spam; |
|
25 |
} |
|
26 |
protected function validate(array $data): void { |
|
27 |
|
|
28 |
if(empty($data["email"])) { |
|
29 |
$this->addError("email","email is required"); |
|
30 |
} |
|
31 |
if(empty($data["telefono"])) { |
|
32 |
$this->addError("telefono","cell number is required"); |
|
33 |
} |
|
34 |
if($this->controlloSpamEmail($data["email"])) { |
|
35 |
$this->addError("spam", "non puoi mandare la stessa mail, aspetta un pò di tempo"); |
|
36 |
} |
|
37 |
} |
|
38 |
|
|
39 |
|
|
40 |
|
|
41 |
} |