Source of file AdvertisementController.php
Size: 1,536 Bytes - Last Modified: 2021-12-23T10:38:47+00:00
/var/www/docs.ssmods.com/process/src/src/Control/AdvertisementController.php
12345678910111213141516171819202122232425262728293031323334353637383940414243 | <?php namespace Sunnysideup\Advertisements\Control; use SilverStripe\CMS\Model\SiteTree; use SilverStripe\ORM\DB; use SilverStripe\Core\Config\Config; use Sunnysideup\Advertisements\Model\Advertisement; use SilverStripe\Control\Controller; class AdvertisementController extends Controller { private static $allowed_actions = array( "removealladvertisements" => "ADMIN", "deletealladvertisements" => "ADMIN" ); public function removealladvertisements($request) { $id = intval($request->param("ID"))-0; $page = SiteTree::get()->byID($id); if (!$page) { return "this page does not exist"; } DB::query("DELETE FROM SiteTree_Advertisements WHERE SiteTreeID = ".$id); DB::query("UPDATE SiteTree SET AdvertisementsFolderID = 0 WHERE SiteTree.ID = ".$id); DB::query("UPDATE SiteTree_Live SET AdvertisementsFolderID = 0 WHERE SiteTree_Live.ID = ".$id); return sprintf( _t("AdvertisementController.REMOVEDALL", 'Removed all %1$s from this page, please reload page to see results.'), Config::inst()->get(Advertisement::class, "plural_name") ); } public function deletealladvertisements($request) { DB::query("DELETE FROM \"Advertisement\""); return sprintf( _t("AdvertisementController.DELETEDALL", 'Deleted all %1$s from this website, please reload page to see results.'), Config::inst()->get(Advertisement::class, "plural_name") ); } } |