1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
declare(strict_types=1); |
4
|
|
|
|
5
|
|
|
namespace PhpCfdi\RfcLinc\DataGateway\Pdo; |
6
|
|
|
|
7
|
|
|
use PDO; |
8
|
|
|
use PDOStatement; |
9
|
|
|
use PhpCfdi\RfcLinc\DataGateway\RfcLogGatewayInterface; |
10
|
|
|
use PhpCfdi\RfcLinc\Domain\RfcLog; |
11
|
|
|
use PhpCfdi\RfcLinc\Domain\VersionDate; |
12
|
|
|
|
13
|
|
|
class RfcLogGateway extends AbstractPdoGateway implements RfcLogGatewayInterface |
14
|
|
|
{ |
15
|
3 |
|
public function eachByRfc(string $rfc) |
16
|
|
|
{ |
17
|
3 |
|
$stmt = $this->openStatementByRfc($rfc); |
18
|
3 |
|
while (false !== $values = $stmt->fetch(PDO::FETCH_ASSOC)) { |
19
|
3 |
|
yield $this->createRfcLogFromArray($values); |
20
|
|
|
} |
21
|
3 |
|
} |
22
|
|
|
|
23
|
1 |
|
public function byRfc(string $rfc): array |
24
|
|
|
{ |
25
|
1 |
|
$list = []; |
26
|
1 |
|
$stmt = $this->openStatementByRfc($rfc); |
27
|
1 |
|
while (false !== $values = $stmt->fetch(PDO::FETCH_ASSOC)) { |
28
|
1 |
|
$list[] = $this->createRfcLogFromArray($values); |
29
|
|
|
} |
30
|
1 |
|
return $list; |
31
|
|
|
} |
32
|
|
|
|
33
|
5 |
|
public function insert(RfcLog $rfcLog) |
34
|
|
|
{ |
35
|
|
|
$query = 'insert into rfclogs (version, rfc, action)' |
36
|
5 |
|
. ' values (:version, :rfc, :action);'; |
37
|
5 |
|
$this->executePrepared($query, [ |
38
|
5 |
|
'version' => $rfcLog->date()->timestamp(), |
39
|
5 |
|
'rfc' => $rfcLog->rfc(), |
40
|
5 |
|
'action' => $rfcLog->action(), |
41
|
5 |
|
], 'Cannot insert into rfc logs list'); |
42
|
5 |
|
} |
43
|
|
|
|
44
|
4 |
|
private function openStatementByRfc(string $rfc): PDOStatement |
45
|
|
|
{ |
46
|
|
|
$query = 'select version, rfc, action from rfclogs' |
47
|
4 |
|
. ' where (rfc = :rfc) order by version'; |
48
|
4 |
|
return $this->executePrepared($query, ['rfc' => $rfc], 'Cannot get logs from rfc list'); |
49
|
|
|
} |
50
|
|
|
|
51
|
4 |
|
private function createRfcLogFromArray(array $values): RfcLog |
52
|
|
|
{ |
53
|
4 |
|
return new RfcLog( |
54
|
4 |
|
VersionDate::createFromTimestamp((int) $values['version']), |
55
|
4 |
|
(string) $values['rfc'], |
56
|
4 |
|
(int) $values['action'] |
57
|
|
|
); |
58
|
|
|
} |
59
|
|
|
} |
60
|
|
|
|