Newer
Older
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
<?php
namespace SGalinski\SgMail\Updates;
/***************************************************************
* Copyright notice
*
* (c) sgalinski Internet Services (https://www.sgalinski.de)
*
* All rights reserved
*
* This script is part of the TYPO3 project. The TYPO3 project is
* free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 3 of the License, or
* (at your option) any later version.
*
* The GNU General Public License can be found at
* http://www.gnu.org/copyleft/gpl.html.
*
* This script is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* This copyright notice MUST APPEAR in all copies of the script!
***************************************************************/
use TYPO3\CMS\Core\Database\DatabaseConnection;
use TYPO3\CMS\Install\Updates\AbstractUpdate;
/**
* Update the correct sending times (if any)
*/
class UpdateSendingTimes extends AbstractUpdate {
/**
* @var string
*/
protected $title = 'Find all sent mails and set the sending time to the tstamp field';
/**
* @var \TYPO3\CMS\Extbase\Object\ObjectManager
*/
protected $objectManager;
/**
* @var array
*/
protected $table = 'tx_sgmail_domain_model_mail';
/**
* Checks whether updates are required.
*
* @param string &$description The description for the update
* @return bool Whether an update is required (TRUE) or not (FALSE)
*/
public function checkForUpdate(&$description) {
$description = 'Update the sending times if mails have been sent';
/** @var DatabaseConnection $databaseConnection */
$databaseConnection = $GLOBALS['TYPO3_DB'];
// are there site root columns differing from pids?
$where = 'sent = TRUE AND last_sending_time = 0';
$result = $databaseConnection->exec_SELECTquery('*', $this->table, $where);
if ($result->num_rows > 0) {
return TRUE;
}
return !(!FALSE || $this->isWizardDone());
}
/**
* Performs the according updates.
*
* @param array &$dbQueries Queries done in this update
* @param mixed &$customMessages Custom messages
* @return bool Whether everything went smoothly or not
*/
public function performUpdate(array &$dbQueries, &$customMessages) {
/** @var DatabaseConnection $databaseConnection */
$databaseConnection = $GLOBALS['TYPO3_DB'];
$dbQueries = [];
$where = 'sent = TRUE AND last_sending_time = 0';
$result = $databaseConnection->exec_SELECTquery('uid, tstamp', $this->table, $where)->fetch_all();
$dbQueries[] = $databaseConnection->debug_lastBuiltQuery;
/** @var array $result */
foreach ($result as $row) {
$where = 'uid = ' . $row[0];
$databaseConnection->exec_UPDATEquery($this->table, $where, ['last_sending_time' => $row[1]]);
$dbQueries[] = $databaseConnection->debug_lastBuiltQuery;
}
$this->markWizardAsDone();
return TRUE;
}
}