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'; |
||
45 | |||
46 | /** |
||
47 | * @var string |
||
48 | */ |
||
49 | private static $plural_name = 'Scheduled Tasks'; |
||
50 | |||
51 | /** |
||
52 | * @var string |
||
53 | */ |
||
54 | private static $table_name = 'SimpleTask'; // When using namespace, specify table name |
||
55 | |||
56 | /** |
||
57 | * @var array<string, string> |
||
58 | */ |
||
59 | private static $db = [ |
||
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
Documentation
Bug
introduced
by
![]() |
|||
74 | */ |
||
75 | private static $has_one = [ |
||
76 | 'Owner' => Member::class, |
||
77 | ]; |
||
78 | |||
79 | /** |
||
80 | * @var string |
||
81 | */ |
||
82 | private static $default_sort = "RunDate DESC"; |
||
83 | |||
84 | /** |
||
85 | * @var array<string> |
||
86 | */ |
||
87 | private static $summary_fields = [ |
||
88 | 'Created', |
||
89 | 'Name', |
||
90 | 'Processed', |
||
91 | 'Failed', |
||
92 | 'TimeToExecute' |
||
93 | ]; |
||
94 | |||
95 | public function canView($member = null, $context = []) |
||
96 | { |
||
97 | return Permission::check('CMS_ACCESS_SimpleJobsAdmin', 'any', $member); |
||
98 | } |
||
99 | |||
100 | public function canEdit($member = null, $context = []) |
||
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 |