Source of file ElementContentOld.php
Size: 1,197 Bytes - Last Modified: 2021-12-23T10:59:26+00:00
/var/www/docs.ssmods.com/process/src/tests/ElementContentOld.php
1234567891011121314151617181920212223242526272829303132333435363738394041424344 | <?php use SilverStripe\Dev\TestOnly; use SilverStripe\ORM\Queries\SQLInsert; use SilverStripe\ORM\Queries\SQLSelect; use SilverStripe\ORM\Queries\SQLUpdate; /** * add Elemental v1 Style field to the ElementContent element * * Class ElementContentStyleExtension */ class ElementContentOld extends BaseElement { private static $db = [ 'HTML' => 'HTMLText', 'Style' => 'Varchar' ]; public function onAfterWrite() { //copy data to ElementContentTable $entryExists = SQLSelect::create() ->setFrom('ElementContent') ->setWhere(['ID' => $this->ID]) ->execute() ->first(); if (!$entryExists) { SQLInsert::create() ->setInto('ElementContent') ->setAssignments(['ID' => $this->ID, 'Style' => $this->Style, 'HTML' => $this->HTML]) ->execute(); } if ($entryExists) { SQLUpdate::create() ->setFrom('ElementContent') ->setWhere(['ID' => $this->ID]) ->setAssignments(['Style' => $this->Style, 'HTML' => $this->HTML]) ->execute(); } } } |