| 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
Loading history...
|
|||
| 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 |