1 | <?php |
||||
2 | |||||
3 | namespace LeKoala\SimpleJobs; |
||||
4 | |||||
5 | use Exception; |
||||
6 | use SilverStripe\ORM\DB; |
||||
7 | use SilverStripe\ORM\DataList; |
||||
8 | use SilverStripe\ORM\DataObject; |
||||
9 | use SilverStripe\Security\Member; |
||||
10 | use SilverStripe\Security\Permission; |
||||
11 | |||||
12 | /** |
||||
13 | * A simple class to schedule function calls |
||||
14 | * They will be picked up by the SimpleJobsController automatically |
||||
15 | * and run if the RunDate is below current time |
||||
16 | * |
||||
17 | * We only run one task each call to avoid excessive usages |
||||
18 | * Expect some delays if you have many tasks! |
||||
19 | * |
||||
20 | * @property ?string $Name |
||||
21 | * @property ?string $Task |
||||
22 | * @property bool|int $Processed |
||||
23 | * @property bool|int $Failed |
||||
24 | * @property ?string $ErrorMessage |
||||
25 | * @property int $TimeToExecute |
||||
26 | * @property int $CallsCount |
||||
27 | * @property int $SuccessCalls |
||||
28 | * @property int $ErrorCalls |
||||
29 | * @property ?string $RunDate |
||||
30 | * @property int $OwnerID |
||||
31 | * @method \SilverStripe\Security\Member Owner() |
||||
32 | * @mixin \SilverStripe\Assets\Shortcodes\FileLinkTracking |
||||
33 | * @mixin \SilverStripe\Assets\AssetControlExtension |
||||
34 | * @mixin \SilverStripe\CMS\Model\SiteTreeLinkTracking |
||||
35 | * @mixin \SilverStripe\Versioned\RecursivePublishable |
||||
36 | * @mixin \SilverStripe\Versioned\VersionedStateExtension |
||||
37 | */ |
||||
38 | class SimpleTask extends DataObject |
||||
39 | { |
||||
40 | |||||
41 | /** |
||||
42 | * @var string |
||||
43 | */ |
||||
44 | private static $singular_name = 'Scheduled Task'; |
||||
0 ignored issues
–
show
introduced
by
![]() |
|||||
45 | |||||
46 | /** |
||||
47 | * @var string |
||||
48 | */ |
||||
49 | private static $plural_name = 'Scheduled Tasks'; |
||||
0 ignored issues
–
show
|
|||||
50 | |||||
51 | /** |
||||
52 | * @var string |
||||
53 | */ |
||||
54 | private static $table_name = 'SimpleTask'; // When using namespace, specify table name |
||||
0 ignored issues
–
show
|
|||||
55 | |||||
56 | /** |
||||
57 | * @var array<string, string> |
||||
58 | */ |
||||
59 | private static $db = [ |
||||
0 ignored issues
–
show
|
|||||
60 | 'Name' => 'Varchar(191)', |
||||
61 | 'Task' => 'Text', |
||||
62 | 'Processed' => 'Boolean', |
||||
63 | 'Failed' => 'Boolean', |
||||
64 | 'ErrorMessage' => 'Varchar(191)', |
||||
65 | 'TimeToExecute' => 'Int', |
||||
66 | 'CallsCount' => 'Int', |
||||
67 | 'SuccessCalls' => 'Int', |
||||
68 | 'ErrorCalls' => 'Int', |
||||
69 | "RunDate" => "Datetime", |
||||
70 | ]; |
||||
71 | |||||
72 | /** |
||||
73 | * @var array<string, class-string> |
||||
0 ignored issues
–
show
|
|||||
74 | */ |
||||
75 | private static $has_one = [ |
||||
0 ignored issues
–
show
|
|||||
76 | 'Owner' => Member::class, |
||||
77 | ]; |
||||
78 | |||||
79 | /** |
||||
80 | * @var string |
||||
81 | */ |
||||
82 | private static $default_sort = "RunDate DESC"; |
||||
0 ignored issues
–
show
|
|||||
83 | |||||
84 | /** |
||||
85 | * @var array<string> |
||||
86 | */ |
||||
87 | private static $summary_fields = [ |
||||
0 ignored issues
–
show
|
|||||
88 | 'Created', |
||||
89 | 'Name', |
||||
90 | 'Processed', |
||||
91 | 'Failed', |
||||
92 | 'TimeToExecute' |
||||
93 | ]; |
||||
94 | |||||
95 | public function canView($member = null, $context = []) |
||||
0 ignored issues
–
show
The parameter
$context is not used and could be removed.
(
Ignorable by Annotation
)
If this is a false-positive, you can also ignore this issue in your code via the
This check looks for parameters that have been defined for a function or method, but which are not used in the method body. ![]() |
|||||
96 | { |
||||
97 | return Permission::check('CMS_ACCESS_SimpleJobsAdmin', 'any', $member); |
||||
98 | } |
||||
99 | |||||
100 | public function canEdit($member = null, $context = []) |
||||
0 ignored issues
–
show
The parameter
$context is not used and could be removed.
(
Ignorable by Annotation
)
If this is a false-positive, you can also ignore this issue in your code via the
This check looks for parameters that have been defined for a function or method, but which are not used in the method body. ![]() |
|||||
101 | { |
||||
102 | return Permission::check('CMS_ACCESS_SimpleJobsAdmin', 'any', $member); |
||||
103 | } |
||||
104 | |||||
105 | public function canCreate($member = null, $context = []) |
||||
106 | { |
||||
107 | return Permission::check('CMS_ACCESS_SimpleJobsAdmin', 'any', $member); |
||||
108 | } |
||||
109 | |||||
110 | public function canDelete($member = null) |
||||
111 | { |
||||
112 | return Permission::check('CMS_ACCESS_SimpleJobsAdmin', 'any', $member); |
||||
113 | } |
||||
114 | |||||
115 | /** |
||||
116 | * @return void |
||||
117 | */ |
||||
118 | protected function onBeforeWrite() |
||||
119 | { |
||||
120 | parent::onBeforeWrite(); |
||||
121 | |||||
122 | // Run asap by default |
||||
123 | if (!$this->RunDate) { |
||||
124 | $this->RunDate = date('Y-m-d H:i:s'); |
||||
125 | } |
||||
126 | |||||
127 | $this->CallsCount = count($this->getTaskDetails()); |
||||
128 | } |
||||
129 | |||||
130 | /** |
||||
131 | * An array of entries |
||||
132 | * @return array<string, mixed> |
||||
133 | */ |
||||
134 | public function getTaskDetails() |
||||
135 | { |
||||
136 | if ($this->Task) { |
||||
137 | $result = json_decode($this->Task, true); |
||||
138 | if ($result) { |
||||
139 | return $result; |
||||
140 | } |
||||
141 | } |
||||
142 | return []; |
||||
143 | } |
||||
144 | |||||
145 | /** |
||||
146 | * @return DataList|SimpleTask[] |
||||
147 | */ |
||||
148 | public static function getTasksThatNeedToRun() |
||||
149 | { |
||||
150 | $time = date('Y-m-d H:i:s'); |
||||
151 | return SimpleTask::get()->where("Processed = 0 AND RunDate <= '$time'"); |
||||
152 | } |
||||
153 | |||||
154 | /** |
||||
155 | * @return SimpleTask|null |
||||
156 | */ |
||||
157 | public static function getNextTaskToRun() |
||||
158 | { |
||||
159 | /** @var SimpleTask|null $task */ |
||||
160 | $task = self::getTasksThatNeedToRun()->sort('RunDate ASC')->limit(1)->first(); |
||||
161 | return $task; |
||||
162 | } |
||||
163 | |||||
164 | /** |
||||
165 | * Append to the list of things to do for this class |
||||
166 | * |
||||
167 | * @param DataObject $class |
||||
168 | * @param string $method |
||||
169 | * @param array<mixed> $params |
||||
170 | * @return array<mixed> |
||||
171 | */ |
||||
172 | public function addToTask(DataObject $class, $method, $params = []) |
||||
173 | { |
||||
174 | $details = $this->getTaskDetails(); |
||||
175 | |||||
176 | // If no name is set, assume the first method call to be the task |
||||
177 | if (!$this->Name) { |
||||
178 | $this->Name = $method; |
||||
179 | } |
||||
180 | // If no owner is set, assume that the member is the owner |
||||
181 | if (!$this->OwnerID && $class instanceof Member) { |
||||
182 | $this->OwnerID = $class->ID; |
||||
183 | } |
||||
184 | |||||
185 | // Task details contain one entry per thing to do in a task |
||||
186 | // A task can do multiple calls |
||||
187 | $details[] = [ |
||||
188 | 'class' => get_class($class), |
||||
189 | 'id' => $class->ID, |
||||
190 | 'function' => $method, |
||||
191 | 'parameters' => $params |
||||
192 | ]; |
||||
193 | |||||
194 | $json = json_encode($details); |
||||
195 | if ($json) { |
||||
196 | $this->Task = $json; |
||||
197 | } |
||||
198 | return $details; |
||||
199 | } |
||||
200 | |||||
201 | /** |
||||
202 | * @return bool |
||||
203 | */ |
||||
204 | public function process() |
||||
205 | { |
||||
206 | if ($this->Processed) { |
||||
207 | throw new Exception("Already processed"); |
||||
208 | } |
||||
209 | |||||
210 | // If there was not enough time, mark the task as processed anyway |
||||
211 | // to avoid calling it again next time |
||||
212 | $this->Processed = true; |
||||
213 | $this->Failed = true; |
||||
214 | $this->ErrorMessage = "Task did not complete"; |
||||
215 | $this->write(); |
||||
216 | |||||
217 | $st = time(); |
||||
218 | |||||
219 | $conn = DB::get_conn(); |
||||
220 | $conn->transactionStart(); |
||||
221 | |||||
222 | $success = $errors = 0; |
||||
223 | try { |
||||
224 | $details = $this->getTaskDetails(); |
||||
225 | |||||
226 | foreach ($details as $entry) { |
||||
227 | /** @var class-string $class */ |
||||
228 | $class = $entry['class'] ?? ''; |
||||
229 | /** @var int $id */ |
||||
230 | $id = $entry['id']; |
||||
231 | /** @var string $function */ |
||||
232 | $function = $entry['function']; |
||||
233 | /** @var array<mixed> $parameters */ |
||||
234 | $parameters = $entry['parameters']; |
||||
235 | |||||
236 | $inst = DataObject::get_by_id($class, $id); |
||||
237 | |||||
238 | $callable = [$inst, $function]; |
||||
239 | if (!is_callable($callable)) { |
||||
240 | throw new Exception("Not callable $function"); |
||||
241 | } |
||||
242 | if ($inst) { |
||||
243 | $result = call_user_func_array($callable, $parameters); |
||||
244 | if ($result !== false) { |
||||
245 | $success++; |
||||
246 | } else { |
||||
247 | $errors++; |
||||
248 | } |
||||
249 | } |
||||
250 | } |
||||
251 | $this->Failed = false; |
||||
252 | $this->ErrorMessage = ''; |
||||
253 | } catch (Exception $ex) { |
||||
254 | $this->Failed = true; |
||||
255 | $this->ErrorMessage = $ex->getMessage(); |
||||
256 | } |
||||
257 | |||||
258 | $et = time(); |
||||
259 | $tt = $et - $st; |
||||
260 | |||||
261 | $this->SuccessCalls = $success; |
||||
262 | $this->ErrorCalls = $errors; |
||||
263 | $this->TimeToExecute = $tt; |
||||
264 | $this->write(); |
||||
265 | |||||
266 | $conn->transactionEnd(); |
||||
267 | |||||
268 | return $this->Failed; |
||||
269 | } |
||||
270 | } |
||||
271 |