Source of file UpdateMyRecords.php
Size: 6,072 Bytes - Last Modified: 2021-12-23T10:41:25+00:00
/var/www/docs.ssmods.com/process/src/app/src/Tasks/Setup/UpdateMyRecords.php
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183 | <?php namespace Sunnysideup\EcommerceTest\Tasks\Setup; use Sunnysideup\EcommerceTest\Tasks\SetUpBase; use Page; use SilverStripe\Assets\Folder; use SilverStripe\Assets\Image; use SilverStripe\CMS\Model\SiteTree; use SilverStripe\Control\Director; use SilverStripe\Dev\BuildTask; // use ProductAttributeType; // use ProductAttributeValue; // use ProductVariation; use SilverStripe\ORM\ArrayList; use SilverStripe\ORM\DataObject; // use CombinationProduct; use SilverStripe\ORM\DataList; use SilverStripe\ORM\DB; use SilverStripe\Security\Group; // use EcommerceProductTag; // use ProductGroupWithTags; use SilverStripe\Security\Member; // use ComplexPriceObject; use SilverStripe\SiteConfig\SiteConfig; use SilverStripe\Versioned\Versioned; use Sunnysideup\Ecommerce\Model\Address\BillingAddress; use Sunnysideup\Ecommerce\Model\Address\ShippingAddress; use Sunnysideup\Ecommerce\Model\Config\EcommerceDBConfig; use Sunnysideup\Ecommerce\Model\Extensions\EcommerceRole; use Sunnysideup\Ecommerce\Model\Order; use Sunnysideup\Ecommerce\Model\ProductOrderItem; use Sunnysideup\Ecommerce\Pages\AccountPage; use Sunnysideup\Ecommerce\Pages\CartPage; use Sunnysideup\Ecommerce\Pages\CheckoutPage; use Sunnysideup\Ecommerce\Pages\OrderConfirmationPage; use Sunnysideup\Ecommerce\Pages\Product; use Sunnysideup\Ecommerce\Pages\ProductGroup; use Sunnysideup\Ecommerce\Pages\ProductGroupSearchPage; use Sunnysideup\Ecommerce\Tasks\EcommerceTaskCreateMemberGroups; use Sunnysideup\EcommerceDelivery\Model\PickUpOrDeliveryModifierOptions; use Sunnysideup\EcommerceDiscountCoupon\Model\DiscountCouponOption; use Sunnysideup\EcommerceTax\Model\GSTTaxModifierOptions; use Sunnysideup\EcommerceTest\Model\CompleteSetupRecord; class UpdateMyRecords extends SetUpBase { public function run() { $schema = DataObject::getSchema(); $array = [ [ 'T' => $schema->tableName(SiteConfig::class), 'F' => 'Title', 'V' => 'Silverstripe Ecommerce Demo', 'W' => '' ], [ 'T' => $schema->tableName(SiteConfig::class), 'F' => 'Tagline', 'V' => 'Built by Sunny Side Up', 'W' => '' ], // // [ // 'T' => $schema->tableName(SiteConfig::class), // 'F' => 'Theme', // 'V' => 'main', // 'W' => '' // ], [ 'T' => $schema->tableName(EcommerceDBConfig::class), 'F' => 'ShopClosed', 'V' => '0', 'W' => '' ], ['T' => $schema->tableName(EcommerceDBConfig::class), 'F' => 'ShopPricesAreTaxExclusive', 'V' => '0', 'W' => '' ], [ 'T' => $schema->tableName(EcommerceDBConfig::class), 'F' => 'ShopPhysicalAddress', 'V' => '<address>The Shop<br />1 main street<br />Coolville 123<br />Landistan</address>', 'W' => '' ], [ 'T' => $schema->tableName(EcommerceDBConfig::class), 'F' => 'ReceiptEmail', 'V' => '"Silverstrip E-comerce Demo" <sales@silverstripe-ecommerce.com>', 'W' => '' ], [ 'T' => $schema->tableName(EcommerceDBConfig::class), 'F' => 'PostalCodeURL', 'V' => 'http://tools.nzpost.co.nz/tools/address-postcode-finder/APLT2008.aspx', 'W' => '' ], [ 'T' => $schema->tableName(EcommerceDBConfig::class), 'F' => 'PostalCodeLabel', 'V' => 'Check Code', 'W' => '' ], [ 'T' => $schema->tableName(EcommerceDBConfig::class), 'F' => 'NumberOfProductsPerPage', 'V' => '5', 'W' => '' ], [ 'T' => $schema->tableName(EcommerceDBConfig::class), 'F' => 'OnlyShowProductsThatCanBePurchased', 'V' => '0', 'W' => '' ], [ 'T' => $schema->tableName(EcommerceDBConfig::class), 'F' => 'ProductsHaveWeight', 'V' => '1', 'W' => '' ], [ 'T' => $schema->tableName(EcommerceDBConfig::class), 'F' => 'ProductsHaveModelNames', 'V' => '1', 'W' => '' ], [ 'T' => $schema->tableName(EcommerceDBConfig::class), 'F' => 'ProductsHaveQuantifiers', 'V' => '1', 'W' => '' ], [ 'T' => $schema->tableName(EcommerceDBConfig::class), 'F' => 'ProductsAlsoInOtherGroups', 'V' => '1', 'W' => '' ], [ 'T' => $schema->tableName(EcommerceDBConfig::class), 'F' => 'EmailLogoID', 'V' => $this->getRandomImageID(), 'W' => '' ], [ 'T' => $schema->tableName(EcommerceDBConfig::class), 'F' => 'DefaultProductImageID', 'V' => $this->getRandomImageID(), 'W' => '' ], ]; foreach ($array as $innerArray) { if (isset($innerArray['W']) && $innerArray['W']) { $innerArray['W'] = ' WHERE ' . $innerArray['W']; } else { $innerArray['W'] = ''; } $T = $innerArray['T']; $F = $innerArray['F']; $V = $innerArray['V']; $W = $innerArray['W']; DB::query("UPDATE \"${T}\" SET \"${F}\" = '${V}' ${W}"); DB::alteration_message(" SETTING ${F} TO ${V} IN ${T} ${W} ", 'created'); } } } |