EcommerceTaskMigration::orderTax_45() - Code Metrics - Inspection of "MINOR: improving getBuyable function so it will ge..." - sunnysideup/silverstripe-ecommerce - Measure and Improve Code Quality continuously with Scrutinizer

Completed
Push — master ( f71c82...1db67b )

unknown
created 2018-06-25 03:00 UTC
EcommerceTaskMigration::orderTax_45() B

↳ Parent: EcommerceTaskMigration
Complexity

Conditions	9
Paths	9
Size

Total Lines
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	9
dl	0
loc	45
rs	7.6444
c	0
b	0
f	0
nc	9
nop	0
<?php


/**
 * @description: migrates older versions of e-commerce to the latest one.
 * This has been placed here rather than in the individual classes for the following reasons:
 * - not to clog up individual classes
 * - to get a complete overview in one class
 * - to be able to run parts and older and newer version without having to go through several clases to retrieve them
 *
 * @authors: Nicolaas [at] Sunny Side Up .co.nz
 * @package: ecommerce
 * @sub-package: tasks
 * @inspiration: Silverstripe Ltd, Jeremy
 * @todo: change methods to simple names f10, f20, etc... and then allow individual ones to be run.
 * @todo: 200 + 210 need attention.
 **/
class EcommerceTaskMigration extends BuildTask
namespace YourVendor;

class YourClass { }
{
    protected $limit = 300;

    protected $start = 0;

    protected $retrieveInfoOnly = false;

    protected $title = 'Ecommerce Migration';

    protected $description = '
        Migrates all the data from the oldest version of e-commerce to the current one.
        Any obsolete fields will be renamed like this: _obsolete_MyField, but not deleted.
    ';

    protected $listOfMigrationTasks = array(
        'shopMemberToMemberTableMigration_10',
        'moveItemToBuyable_20',
        'productVersionToOrderItem_25',
        'productIDToBuyableID_26',
        'amountToCalculatedTotal_27',
        'currencyToMoneyFields_30',
        'orderShippingCost_40',
        'orderTax_45',
        'orderShippingAddress_50',
        'orderBillingAddress_51',
        'memberBillingAddress_52',
        'moveOrderStatus_60',
        'fixBadOrderStatus_68',
        'updateProductGroups_110',
        'setFixedPriceForSubmittedOrderItems_120',
        'moveSiteConfigToEcommerceDBConfig_140',
        'addClassNameToOrderItems_150',
        'addTermsAndConditionsMessage_160',
        'mergeUncompletedOrderForOneMember_170',
        'updateFullSiteTreeSortFieldForAllProducts_180',
        'updateOrderStatusLogSequentialOrderNumber_190',
        'resaveAllPRoducts_200',
        'resaveAllPRoductsVariations_210',
        'addConfirmationPage_250',
        'cleanupImages_260',
        'addNewPopUpManager_280',
        'addCurrencyCodeIDToOrders_290',
        'MovePaymentToEcommercePayment_300',
        'ecommercetaskupgradepickupordeliverymodifier_310',
        'ecommercetaskupgradepickupordeliverymodifier_320',
        'removemobilephones_330',
        'theEnd_9999',
    );

    public function run($request)
// Bad
class Router
{
    public function generate($path)
    {
        return $_SERVER['HOST'].$path;
    }
}

// Better
class Router
{
    private $host;

    public function __construct($host)
    {
        $this->host = $host;
    }

    public function generate($path)
    {
        return $this->host.$path;
    }
}

class Controller
{
    public function myAction(Request $request)
    {
        // Instead of
        $page = isset($_GET['page']) ? intval($_GET['page']) : 1;

        // Better (assuming you use the Symfony2 request)
        $page = $request->query->get('page', 1);
    }
}
    {
        set_time_limit(1200);
        increase_memory_limit_to(-1);
        $nextGetStatement = '';
        //can we do the next step?
        //IN general yes, but if the current one is not finished yet, then we do it again.
        $canDoNext = true;
        if (isset($_REQUEST['limit'])) {
            $this->limit = intval($_REQUEST['limit']);
        }
        if (isset($_REQUEST['start'])) {
            $this->start = intval($_REQUEST['start']);
        }

        //what is the current step?
        $currentMethod = isset($_REQUEST['action']) ? $_REQUEST['action'] : '';
        if (in_array($currentMethod, $this->listOfMigrationTasks)) {

            //are we doing the same one for a different limti?
            if ($this->start) {
                $this->DBAlterationMessageNow('this task is broken down into baby steps - we are now starting at .... '.$this->start.' processing '.$this->limit, 'created');
            }
            $nextLimit = $this->$currentMethod();
            if ($canDoNext && $nextLimit) {
                $canDoNext = false;
                //NEXT OPTION 1: do again with new limit
                $nextGetStatement = '?action='.$currentMethod.'&start='.$nextLimit;
                $nextDescription = 'run next batch ...';
            }
        }

        if ($canDoNext && !$nextGetStatement) {
            //NEXT OPTION 2: start from the beginning
            $nextGetStatement = '?fullmigration=1&action='.$this->listOfMigrationTasks[0];
            $nextDescription = "Start Migration by clicking on <i>'Next'</i> (this link) until all tasks have been completed.";
        }
        //retrieve data...
        $this->retrieveInfoOnly = true;
        $html = '';
        $createListOfActions = false;
        if (!$currentMethod) {
            $createListOfActions = true;
        }
        if ($createListOfActions) {
            $html .= '
            <p>Always make a backup of your database before running any migration tasks.</p>
            <ul>';
        }
        foreach ($this->listOfMigrationTasks as $key => $task) {
            $explanation = $this->$task();
            $explanation = str_replace(array('<h1>', '</h1>', '<p>', '</p>'), array('<strong>', '</strong>: ', '<span style="color: grey;">', '</span>'), $explanation);
            if ($task == $currentMethod) {
                if ($canDoNext) {
                    $keyPlusOne = $key + 1;
                    if (isset($this->listOfMigrationTasks[$keyPlusOne]) && isset($_REQUEST['fullmigration'])) {
                        //NEXT OPTION 3: next action!
                        $action = $this->listOfMigrationTasks[$keyPlusOne];
                        $nextGetStatement = '?action='.$action;
                        $nextDescription = $this->$action();
                        $nextDescription = str_replace(array('<h1>', '</h1>', '<p>', '</p>'), array('<strong>', '</strong>: ', '<span style="color: grey;">', '</span>'), $nextDescription);
                    } else {
                        //NEXT OPTION 4: we have done all of them - no more next option...
                        $nextGetStatement = '';
                        $nextDescription = '';
                    }
                }
            }
            if ($createListOfActions) {
                $html .=  '<li><a href="/dev/ecommerce/ecommercetaskmigration/?action='.$task."\">$explanation </a></li>";
            }
        }
        if ($createListOfActions) {
            $html .= '</ul>';
        }
        if ($nextGetStatement) {
            $nextLink = '/dev/ecommerce/ecommercetaskmigration/'.$nextGetStatement;
            if (isset($_REQUEST['fullmigration'])) {
                $nextLink .= '&fullmigration=1';
            }
            echo "
                <hr style=\"margin-top: 50px;\"/>
                <h3><a href=\"$nextLink\">NEXT: $nextDescription</a></h3>";
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
            if ($currentMethod) {
                echo "
                <div style=\"width: 400px; height: 20px; padding-top: 20px; font-size: 11px; background: url(/ecommerce/images/loading.gif) no-repeat top left transparent\">
                    Next step, if any - will load automatically in ten seconds.
                </div>
                <script type=\"text/javascript\">
                    var t = window.setTimeout(
                        function(){
                            window.location = '$nextLink';
                        },
                        500
                    );
                </script>
                <hr style=\"margin-bottom: 500px;\"/>
            ";
            }
        }
        echo $html;
    }

    /**
     * Returns true if the table and field (within this table) exist.
     * Otherwise it returns false.
     *
     * @param string - $field - name of the field to be tested
     * @param string - $table - name of the table to be tested
     *
     * @return bool
     */
    protected function hasTableAndField($table, $field)
    {
        $db = DB::getConn();

        if ($db->hasTable($table)) {

            $fieldArray = $db->fieldList($table);

            if (isset($fieldArray[$field])) {
                return true;
            }
        }

        return false;
    }

    /**
     * Returns true if the table and field (within this table) exist.
     * Otherwise it returns false.
     *
     * @param string - $field - name of the field to be tested
     * @param string - $table - name of the table to be tested
     *
     * @return bool

     */
    protected function makeFieldObsolete($table, $field, $format = '')

    {
        if ($this->hasTableAndField($table, $field)) {
            $db = DB::getConn();

            $db->dontRequireField($table, $field);

            $this->DBAlterationMessageNow("removed $field from $table", 'deleted');
        } else {
            $this->DBAlterationMessageNow("ERROR: could not find $field in $table so it could not be removed", 'deleted');
        }
        if ($this->hasTableAndField($table, $field)) {
            $this->DBAlterationMessageNow("ERROR: tried to remove $field from $table but it still seems to be there", 'deleted');
        }
    }

    protected function shopMemberToMemberTableMigration_10()
    {
        $explanation = '
            <h1>10. ShopMember to Member</h1>
            <p>In the first version of e-commerce we had the ShopMember class, then we moved this data to Member.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        if ($this->hasTableAndField('ShopMember', 'ID')) {
            $exist = DB::query("SHOW TABLES LIKE 'ShopMember'")->numRecords();
            if ($exist > 0) {
                DB::query("
                    UPDATE \"Member\", \"ShopMember\"
                    SET
                        \"Member\".\"ClassName\" = 'Member',
                        \"Member\".\"Address\" = \"ShopMember\".\"Address\",
                        \"Member\".\"AddressLine2\" = \"ShopMember\".\"AddressLine2\",
                        \"Member\".\"City\" = \"ShopMember\".\"City\",
                        \"Member\".\"State\" = \"ShopMember\".\"State\",
                        \"Member\".\"Country\" = \"ShopMember\".\"Country\",
                        \"Member\".\"Notes\" = \"ShopMember\".\"Notes\"
                    WHERE \"Member\".\"ID\" = \"ShopMember\".\"ID\"
                ");
                $this->DBAlterationMessageNow('Successfully migrated ShopMember To Member.', 'created');
            } else {
                $this->DBAlterationMessageNow('No need to migrate ShopMember To Member because it does not have any records.');
            }
            DB::query('DROP TABLE "ShopMember";');
        } else {
            $this->DBAlterationMessageNow('There is no need to migrate the ShopMember table.');
        }
    }

    protected function moveItemToBuyable_20()
    {
        $explanation = '
            <h1>20. Move ItemID to Buyable</h1>
            <p>Move the Product ID in OrderItem as ItemID to a new field called BuyableID.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        if ($this->hasTableAndField('OrderItem', 'ItemID')) {
            DB::query('
                UPDATE "OrderItem"
                SET "OrderItem"."BuyableID" = "OrderItem"."ItemID"
                WHERE "BuyableID" = 0 OR "BuyableID" IS NULL
            ');
            $this->makeFieldObsolete('OrderItem', 'ItemID');
            $this->DBAlterationMessageNow('Moved ItemID to BuyableID in OrderItem', 'created');
        } else {
            $this->DBAlterationMessageNow('There is no need to move from ItemID to BuyableID');
        }
    }

    protected function productVersionToOrderItem_25()
    {
        $explanation = '
            <h1>25. ProductVersion to Version</h1>
            <p>Move the product version in the Product_OrderItem table to the OrderItem table.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $table = 'LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL';
        if ($this->hasTableAndField('Product_OrderItem', 'ProductVersion')) {
            $table = 'Product_OrderItem';
        } elseif ($this->hasTableAndField('_obsolete_Product_OrderItem', 'ProductVersion')) {
            $table = '_obsolete_Product_OrderItem';
        }
        if ($this->hasTableAndField($table, 'ProductVersion')) {
            DB::query("
                UPDATE \"OrderItem\", \"$table\"
                    SET \"OrderItem\".\"Version\" = \"$table\".\"ProductVersion\"
                WHERE \"OrderItem\".\"ID\" = \"$table\".\"ID\"
            ");
            $this->makeFieldObsolete('Product_OrderItem', 'ProductVersion');
            $this->DBAlterationMessageNow('Migrating Product_OrderItem.ProductVersion to OrderItem.Version.', 'created');
        } else {
            $this->DBAlterationMessageNow('There is no need to migrate Product_OrderItem.ProductVersion to OrderItem.Version.');
        }
    }

    protected function productIDToBuyableID_26()
    {
        $explanation = '
            <h1>26. ProductID to to BuyableID</h1>
            <p>Move the product ID saved as Product_OrderItem.ProductID to OrderItem.BuyableID.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $table = 'LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL';
        if ($this->hasTableAndField('Product_OrderItem', 'ProductID')) {
            $table = 'Product_OrderItem';
        } elseif ($this->hasTableAndField('_obsolete_Product_OrderItem', 'ProductID')) {
            $table = '_obsolete_Product_OrderItem';
        }
        if ($this->hasTableAndField($table, 'ProductID')) {
            DB::query("
                UPDATE \"OrderItem\"
                    INNER JOIN \"$table\"
                        ON \"OrderItem\".\"ID\" = \"$table\".\"ID\"
                SET \"OrderItem\".\"BuyableID\" = \"$table\".\"ProductID\"
                WHERE \"BuyableID\" = 0 OR \"BuyableID\" IS NULL
            ");
            $this->makeFieldObsolete('Product_OrderItem', 'ProductID');
            $this->DBAlterationMessageNow('Migrating Product_OrderItem.ProductID to OrderItem.BuyableID', 'created');
        } else {
            $this->DBAlterationMessageNow('There is no need to migrate Product_OrderItem.ProductID to OrderItem.BuyableID');
        }
        if ($this->hasTableAndField($table, 'ProductVersion')) {
            DB::query("
                UPDATE \"OrderItem\"
                    INNER JOIN \"$table\"
                        ON \"OrderItem\".\"ID\" = \"$table\".\"ID\"
                SET \"OrderItem\".\"Version\" = \"$table\".\"ProductVersion\"
                WHERE \"BuyableID\" = 0 OR \"BuyableID\" IS NULL
            ");
            $this->makeFieldObsolete('Product_OrderItem', 'ProductID');
            $this->DBAlterationMessageNow('Migrating Product_OrderItem.ProductVersion to OrderItem.Version', 'created');
        } else {
            $this->DBAlterationMessageNow('There is no need to migrate Product_OrderItem.ProductVersion to OrderItem.Version');
        }
        // we must check for individual database types here because each deals with schema in a none standard way
        //can we use Table::has_field ???

        if ($this->hasTableAndField('ProductVariation_OrderItem', 'ProductVariationVersion')) {
            DB::query('
                UPDATE "OrderItem", "ProductVariation_OrderItem"
                    SET "OrderItem"."Version" = "ProductVariation_OrderItem"."ProductVariationVersion"
                WHERE "OrderItem"."ID" = "ProductVariation_OrderItem"."ID"
            ');
            $this->makeFieldObsolete('ProductVariation_OrderItem', 'ProductVariationVersion');
            $this->DBAlterationMessageNow('Migrating ProductVariation_OrderItem.ProductVariationVersion to OrderItem.Version', 'created');
        } else {
            $this->DBAlterationMessageNow('No need to migrate ProductVariation_OrderItem.ProductVariationVersion');
        }
        if (class_exists('ProductVariation_OrderItem')) {
            if ($this->hasTableAndField('ProductVariation_OrderItem', 'ProductVariationID')) {
                DB::query("
                    UPDATE \"OrderItem\", \"ProductVariation_OrderItem\"
                        SET \"OrderItem\".\"BuyableID\" = \"ProductVariation_OrderItem\".\"ProductVariationID\",
                                \"OrderItem\".\"BuyableClassName\" = 'ProductVariation'
                    WHERE \"OrderItem\".\"ID\" = \"ProductVariation_OrderItem\".\"ID\"
                ");
                $this->makeFieldObsolete('ProductVariation_OrderItem', 'ProductVariationID');
                $this->DBAlterationMessageNow('Migrating ProductVariation_OrderItem.ProductVariationID to OrderItem.BuyableID and adding BuyableClassName = ProductVariation', 'created');
            } else {
                $this->DBAlterationMessageNow('No need to migrate ProductVariation_OrderItem.ProductVariationID');
            }
        } else {
            $this->DBAlterationMessageNow('There are not ProductVariations in this project');
        }
    }

    protected function amountToCalculatedTotal_27()
    {
        $explanation = '
            <h1>27. Move OrderModifier.Amount to OrderAttribute.CalculatedTotal</h1>
            <p>Move the amount of the modifier in the OrderModifier.Amount field to the OrderAttribute.CalculatedTotal field.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        if ($this->hasTableAndField('OrderModifier', 'Amount')) {
            DB::query('
                UPDATE "OrderModifier"
                    INNER JOIN "OrderAttribute"
                        ON "OrderAttribute"."ID" = "OrderModifier"."ID"
                SET "OrderAttribute"."CalculatedTotal" = "OrderModifier"."Amount"
                WHERE "OrderAttribute"."CalculatedTotal" IS NULL OR "OrderAttribute"."CalculatedTotal" = 0
            ');
            $this->makeFieldObsolete('OrderModifier', 'Amount');
            $this->DBAlterationMessageNow('Moved OrderModifier.Amount to OrderAttribute.CalculatedTotal', 'created');
        } else {
            $this->DBAlterationMessageNow('There is no need to move OrderModifier.Amount to OrderAttribute.CalculatedTotal');
        }
    }

    protected function currencyToMoneyFields_30()
    {
        $explanation = '
            <h1>30. Currency to Money Fields</h1>
            <p>Move the Payment Amount in the Amount field to a composite DB field (AmountAmount + AmountCurrency) </p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        if ($this->hasTableAndField('Payment', 'Amount')) {
            //ECOMMERCE PAYMENT *************************
            DB::query('
                UPDATE "Payment"
                SET "AmountAmount" = "Amount"
                WHERE
                    "Amount" > 0
                    AND (
                        "AmountAmount" IS NULL OR "AmountAmount" = 0
                    )
            ');
            $countAmountChanges = DB::affectedRows();

            if ($countAmountChanges) {
                $this->DBAlterationMessageNow("Updated Payment.Amount field to 2.4 - $countAmountChanges rows updated", 'edited');
            }
        } else {
            $this->DBAlterationMessageNow('There is no need to move Payment.Amount to Payment.AmountAmount');
        }
        if ($this->hasTableAndField('Payment', 'Currency')) {
            DB::query("
                UPDATE \"Payment\"
                SET \"AmountCurrency\" = \"Currency\"
                WHERE
                    \"Currency\" <> ''
                    AND \"Currency\" IS NOT NULL
                    AND (
                        \"AmountCurrency\" IS NULL
                        OR \"AmountCurrency\" = ''
                    )
            ");
            $countCurrencyChanges = DB::affectedRows();

            if ($countCurrencyChanges) {
                $this->DBAlterationMessageNow("Updated Payment.Currency field to 2.4  - $countCurrencyChanges rows updated", 'edited');
            }
            if ($countAmountChanges != $countCurrencyChanges) {
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
                $this->DBAlterationMessageNow('Potential error in Payment fields update to 2.4, please review data', 'deleted');
            }
        } else {
            $this->DBAlterationMessageNow('There is no need to move Payment.Currency to Payment.AmountCurrency');
        }
    }

    protected function orderShippingCost_40()
    {
        $explanation = '
            <h1>40. Order Shipping Cost</h1>
            <p>Move the shipping cost in the order to its own modifier.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        if ($this->hasTableAndField('Order', 'Shipping') && $this->hasTableAndField('Order', 'HasShippingCost')) {
            $orders = Order::get()
                ->where('"HasShippingCost" = 1 AND "Shipping" IS NOT NULL')
                ->limit($this->limit, $this->start);
            if ($orders->count()) {
                foreach ($orders as $order) {
                    $modifier1 = new SimpleShippingModifier();
                    $modifier1->CalculatedTotal = $shipping < 0 ? abs($shipping) : $shipping;

                    $modifier1->TableValue = $shipping < 0 ? abs($shipping) : $shipping;
                    $modifier1->OrderID = $id;

                    $modifier1->TableTitle = 'Delivery';
                    $modifier1->write();
                    $this->DBAlterationMessageNow(' ------------- Added shipping cost.', 'created');
                }

                return $this->start + $this->limit;
            } else {
                $this->DBAlterationMessageNow('There are no orders with HasShippingCost =1 and Shipping IS NOT NULL.');
            }
            $this->makeFieldObsolete('Order', 'HasShippingCost', 'tinyint(1)');
            $this->makeFieldObsolete('Order', 'Shipping', 'decimal(9,2)');
        } else {
            $this->DBAlterationMessageNow('No need to update shipping cost.');
        }

        return 0;
    }

    protected function orderTax_45()
    {
        $explanation = '
            <h1>45. Order Added Tax</h1>
            <p>Move the tax in the order to its own modifier.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        if ($this->hasTableAndField('Order', 'AddedTax')) {
            $this->DBAlterationMessageNow('Moving Order.AddedTax to Modifier.', 'created');
            $orders = Order::get()
                ->where('"AddedTax" > 0')
                ->limit($this->limit, $this->start);
            if ($orders->count()) {
                foreach ($orders as $order) {
                    $id = $order->ID;
                    $hasShippingCost = DB::query("SELECT \"AddedTax\" FROM \"Order\" WHERE \"ID\" = '$id'")->value();
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
                    $addedTax = DB::query("SELECT \"AddedTax\" FROM \"Order\" WHERE \"ID\" = '$id'")->value();
                    if ($addedTax != null && $addedTax > 0) {
                        $modifier1 = new FlatTaxModifier();
                        $modifier1->CalculatedTotal = $addedTax < 0 ? abs($addedTax) : $addedTax;
                        $modifier1->TableValue = $addedTax < 0 ? abs($addedTax) : $addedTax;
                        $modifier1->OrderID = $id;
                        $modifier1->TableTitle = 'Tax';
                        $modifier1->write();
                        $this->DBAlterationMessageNow(' ------------- Added tax.', 'created');
                    } else {
                        $this->DBAlterationMessageNow(' ------------- No need to add tax even though field is present');
                    }
                }

                return $this->start + $this->limit;
            } else {
                $this->DBAlterationMessageNow('There are no orders with a AddedTax field greater than zero.');
            }
            $this->makeFieldObsolete('Order', 'AddedTax');
        } else {
            $this->DBAlterationMessageNow('No need to update taxes.');
        }

        return 0;
    }

    protected function orderShippingAddress_50()
    {
        $explanation = '
            <h1>50. Order Shipping Address</h1>
            <p>Move a shipping address from within Order to its own class.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        if ($this->hasTableAndField('Order', 'ShippingAddress')) {
            if ($this->hasTableAndField('Order', 'UseShippingAddress')) {
                $orders = Order::get()
                    ->where('"UseShippingAddress" = 1 AND "ShippingAddress"."ID" IS NULL')
                    ->leftJoin('ShippingAddress', '"Order"."ShippingAddressID" = "ShippingAddress"."ID"')
                    ->limit($this->limit, $this->start);
                if ($orders->count()) {
                    foreach ($orders as $order) {
                        if (!$order->ShippingAddressID) {
                            $obj = ShippingAddress::create();
                            if (isset($order->ShippingName)) {
                                $obj->ShippingName = $order->ShippingName;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->ShippingAddress)) {
                                $obj->ShippingAddress = $order->ShippingAddress;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->ShippingAddress2)) {
                                $obj->ShippingAddress2 = $order->ShippingAddress2;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->ShippingCity)) {
                                $obj->ShippingCity = $order->ShippingCity;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->ShippingPostalCode)) {
                                $obj->ShippingPostalCode = $order->ShippingPostalCode;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->ShippingState)) {
                                $obj->ShippingState = $order->ShippingState;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->ShippingCountry)) {
                                $obj->ShippingCountry = $order->ShippingCountry;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->ShippingPhone)) {
                                $obj->ShippingPhone = $order->ShippingPhone;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->ShippingHomePhone)) {
                                $obj->ShippingPhone .= $order->ShippingHomePhone;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->ShippingMobilePhone)) {
                                $obj->ShippingMobilePhone = $order->ShippingMobilePhone;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            $obj->OrderID = $order->ID;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            $obj->write();
                            $order->ShippingAddressID = $obj->ID;
                            $order->write();
                        } else {
                            $this->DBAlterationMessageNow('Strange contradiction occurred in Order with ID'.$order->ID, 'deleted');
                        }
                    }

                    return $this->start + $this->limit;
                } else {
                    $this->DBAlterationMessageNow('No orders need adjusting even though they followed the old pattern.');
                }
                $this->makeFieldObsolete('Order', 'ShippingName');
                $this->makeFieldObsolete('Order', 'ShippingAddress');
                $this->makeFieldObsolete('Order', 'ShippingAddress2');
                $this->makeFieldObsolete('Order', 'ShippingCity');
                $this->makeFieldObsolete('Order', 'ShippingPostalCode');
                $this->makeFieldObsolete('Order', 'ShippingState');
                $this->makeFieldObsolete('Order', 'ShippingCountry');
                $this->makeFieldObsolete('Order', 'ShippingPhone');
                $this->makeFieldObsolete('Order', 'ShippingHomePhone');
                $this->makeFieldObsolete('Order', 'ShippingMobilePhone');
            } else {
                $this->DBAlterationMessageNow('There is no UseShippingAddress field even though there is a ShippingAddress Field - this is an issue.', 'deleted');
            }
        } else {
            $this->DBAlterationMessageNow('Orders do not have the shipping address to migrate.');
        }

        return 0;
    }

    protected function orderBillingAddress_51()
    {
        $explanation = '
            <h1>51. Order Billing Address</h1>
            <p>Move the billing address from the order to its own class.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        if ($this->hasTableAndField('Order', 'Address')) {
            if ($this->hasTableAndField('Order', 'City')) {
                $orders = Order::get()
                    ->where('"BillingAddress"."ID" = 0 OR "BillingAddress"."ID" IS NULL')
                    ->leftJoin('BillingAddress', '"Order"."BillingAddressID" = "BillingAddress"."ID"')
                    ->limit($this->limit, $this->start);
                if ($orders->count()) {
                    foreach ($orders as $order) {
                        if (!$order->BillingAddressID) {
                            $obj = BillingAddress::create();
                            if (isset($order->Email)) {
                                $obj->BillingEmail = $order->Email;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->Surname)) {
                                $obj->BillingSurname = $order->Surname;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->FirstName)) {
                                $obj->BillingFirstName = $order->FirstName;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->Address)) {
                                $obj->BillingAddress = $order->Address;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->AddressLine2)) {
                                $obj->BillingAddress2 = $order->AddressLine2;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->Address2)) {
                                $obj->BillingAddress2 .= $order->Address2;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->City)) {
                                $obj->BillingCity = $order->City;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->PostalCode)) {
                                $obj->BillingPostalCode = $order->PostalCode;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->State)) {
                                $obj->BillingState = $order->State;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->Country)) {
                                $obj->BillingCountry = $order->Country;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->Phone)) {
                                $obj->BillingPhone = $order->Phone;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->HomePhone)) {
                                $obj->BillingPhone .= $order->HomePhone;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            if (isset($order->MobilePhone)) {
                                $obj->BillingMobilePhone = $order->MobilePhone;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            }
                            $obj->OrderID = $order->ID;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                            $obj->write();
                            $order->BillingAddressID = $obj->ID;
                            $order->write();
                        } else {
                            $this->DBAlterationMessageNow('Strange contradiction occurred in Order with ID'.$order->ID, 'deleted');
                        }
                    }

                    return $this->start + $this->limit;
                } else {
                    $this->DBAlterationMessageNow('No orders need adjusting even though they followed the old pattern.');
                }
                $this->makeFieldObsolete('Order', 'Email');
                $this->makeFieldObsolete('Order', 'FirstName');
                $this->makeFieldObsolete('Order', 'Surname');
                $this->makeFieldObsolete('Order', 'Address');
                $this->makeFieldObsolete('Order', 'Address2');
                $this->makeFieldObsolete('Order', 'City');
                $this->makeFieldObsolete('Order', 'PostalCode');
                $this->makeFieldObsolete('Order', 'State');
                $this->makeFieldObsolete('Order', 'Country');
                $this->makeFieldObsolete('Order', 'Phone');
                $this->makeFieldObsolete('Order', 'HomePhone');
                $this->makeFieldObsolete('Order', 'MobilePhone');
            } else {
                $this->DBAlterationMessageNow('There is no UseBillingAddress field even though there is a BillingAddress Field - this is an issue.', 'deleted');
            }
        } else {
            $this->DBAlterationMessageNow('Orders do not have the Billing address to migrate.');
        }

        return 0;
    }

    protected function memberBillingAddress_52()
    {
        $explanation = '
            <h1>52. Member Billing Address</h1>
            <p>Move address details in the member table to its own class (billingaddress)</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        if ($this->hasTableAndField('Member', 'Address')) {
            if ($this->hasTableAndField('Member', 'City')) {
                $orders = Order::get()
                    ->where('"MemberID" > 0')
                    ->leftJoin('BillingAddress', '"Order"."BillingAddressID" = "BillingAddress"."ID"')
                    ->limit($this->limit, $this->start);
                if ($orders->count()) {
                    foreach ($orders as $order) {
                        $member = Member::get()->byID($order->MemberID);
                        if ($member) {
                            if ($obj = $order->BillingAddress()) {
                                $this->DBAlterationMessageNow('Order (id = '.$order->ID.') already has a billing address');
                            //do nothing
                            } else {
                                $this->DBAlterationMessageNow('Order (id = '.$order->ID.') now gets its own billing address...');
                                $obj = BillingAddress::create();
                            }
                            if (isset($member->Email) && !$obj->Email) {
                                $obj->Email = $member->Email;
                            }
                            if (isset($member->FirstName) && !$obj->FirstName) {
                                $obj->FirstName = $member->FirstName;
                            }
                            if (isset($member->Surname) && !$obj->Surname) {
                                $obj->Surname = $member->Surname;
                            }
                            if (isset($member->Address) && !$obj->Address) {
                                $obj->Address = $member->Address;
                            }
                            if (isset($member->AddressLine2) && !$obj->Address2) {
                                $obj->Address2 = $member->AddressLine2;
                            }
                            if (isset($member->City) && !$obj->City) {
                                $obj->City = $member->City;
                            }
                            if (isset($member->PostalCode) && !$obj->PostalCode) {
                                $obj->PostalCode = $member->PostalCode;
                            }
                            if (isset($member->State) && !$obj->State) {
                                $obj->State = $member->State;
                            }
                            if (isset($member->Country) && !$obj->Country) {
                                $obj->Country = $member->Country;
                            }
                            if (isset($member->Phone) && !$obj->Phone) {
                                $obj->Phone = $member->Phone;
                            }
                            if (isset($member->HomePhone) && !$obj->HomePhone) {
                                $obj->HomePhone .= $member->HomePhone;
                            }
                            if (isset($member->MobilePhone) && !$obj->MobilePhone) {
                                $obj->MobilePhone = $member->MobilePhone;
                            }
                            $obj->OrderID = $order->ID;
                            $obj->write();
                            $this->DBAlterationMessageNow('Updated Order #'.$order->ID.' with Member details', 'created');
                            DB::query('Update "Order" SET "BillingAddressID" = '.$obj->ID.' WHERE "Order".ID = '.$order->ID);
                        } else {
                            $this->DBAlterationMessageNow('There is no member associated with this order '.$order->ID, 'deleted');
                        }
                    }

                    return $this->start + $this->limit;
                } else {
                    $this->DBAlterationMessageNow('No orders need adjusting even though they followed the old pattern.');
                }
            } else {
                $this->DBAlterationMessageNow('There is no Address2 field, but there is an Address field in Member - this might be an issue.', 'deleted');
            }
        } else {
            $this->DBAlterationMessageNow('Members do not have a billing address to migrate.');
        }

        return 0;
    }

    protected function moveOrderStatus_60()
    {
        $explanation = '
            <h1>60. Move Order Status</h1>
            <p>Moving order status from the enum field to Order Step.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        if ($this->hasTableAndField('Order', 'Status')) {
            // 2) Cancel status update
            $orders = Order::get()
                ->filter(array('Status' => 'Cancelled'))
                ->limit($this->limit, $this->start);
            if ($orders->count()) {
                foreach ($orders as $order) {
                    $order->CancelledByID = $admin->ID;

                    $order->write();
                    $this->DBAlterationMessageNow('The order which status was \'Cancelled\' have been successfully changed to the status \'AdminCancelled\'', 'created');
                }

                return $this->start + $this->limit;
            } else {
                $this->DBAlterationMessageNow('There are no orders that are cancelled');
            }
            $rows = DB::query('SELECT "ID", "Status" FROM "Order"');
            if ($rows) {
                $cartObject = null;
                $unpaidObject = null;
                $paidObject = null;
                $sentObject = null;
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
                $adminCancelledObject = null;
                $memberCancelledObject = null;
                foreach ($rows as $row) {
                    switch ($row['Status']) {
                        case 'Cart':
                            if (!$cartObject) {
                                $cartObject = DataObject::get_one(
                                    'OrderStep',
                                    array('Code' => 'CREATED'),
                                    $cacheDataObjectGetOne = false
                                );
                                if ($cartObject) {
if (rand(1, 6) > 3) {
//print "Check failed";
} else {
    print "Check succeeded";
}
                                    //do nothing
                                } else {
                                    $this->DBAlterationMessageNow('Creating default steps', 'created');
                                    singleton('OrderStep')->requireDefaultRecords();
                                }
                            }
                            $cartObject = DataObject::get_one(
                                'OrderStep',
                                array('Code' => 'CREATED'),
                                $cacheDataObjectGetOne = false
                            );
                            if ($cartObject) {
                                DB::query('UPDATE "Order" SET "StatusID" = '.$cartObject->ID.' WHERE "Order"."ID" = '.$row['ID'].' AND ("StatusID" = 0 OR "StatusID" IS NULL)');
                            } else {
                                $this->DBAlterationMessageNow('Could not find CREATED status', 'deleted');
                            }
                            break;
                        case 'Query':
                        case 'Unpaid':
                            if (!$unpaidObject) {
                                $unpaidObject = DataObject::get_one(
                                    'OrderStep',
                                    array('Code' => 'SUBMITTED'),
                                    $cacheDataObjectGetOne = false
                                );
                                if ($unpaidObject) {
if (rand(1, 6) > 3) {
//print "Check failed";
} else {
    print "Check succeeded";
}
                                    //do nothing
                                } else {
                                    $this->DBAlterationMessageNow('Creating default steps', 'created');
                                    singleton('OrderStep')->requireDefaultRecords();
                                }
                            }
                            $unpaidObject = DataObject::get_one(
                                'OrderStep',
                                array('Code' => 'SUBMITTED'),
                                $cacheDataObjectGetOne = false
                            );
                            if ($unpaidObject) {
                                DB::query('UPDATE "Order" SET "StatusID" = '.$unpaidObject->ID.' WHERE "Order"."ID" = '.$row['ID'].' AND ("StatusID" = 0 OR "StatusID" IS NULL)');
                            } else {
                                $this->DBAlterationMessageNow('Could not find SUBMITTED status', 'deleted');
                            }
                            break;
                        case 'Processing':
                        case 'Paid':
                            if (!$paidObject) {
                                $paidObject = DataObject::get_one(
                                    'OrderStep',
                                    array('Code' => 'PAID'),
                                    $cacheDataObjectGetOne = false
                                );
                                if ($paidObject) {
if (rand(1, 6) > 3) {
//print "Check failed";
} else {
    print "Check succeeded";
}
                                    //do nothing
                                } else {
                                    $this->DBAlterationMessageNow('Creating default steps', 'created');
                                    singleton('OrderStep')->requireDefaultRecords();
                                }
                            }
                            $paidObject = DataObject::get_one(
                                'OrderStep',
                                array('Code' => 'PAID'),
                                $cacheDataObjectGetOne = false
                            );
                            if ($paidObject) {
                                DB::query('UPDATE "Order" SET "StatusID" = '.$paidObject->ID.' WHERE "Order"."ID" = '.$row['ID'].' AND ("StatusID" = 0 OR "StatusID" IS NULL)');
                                $this->DBAlterationMessageNow('Updating to PAID status', 'created');
                            } else {
                                $this->DBAlterationMessageNow('Could not find new status', 'deleted');
                            }
                            break;
                        case 'Sent':
                        case 'Complete':
                            //CHECK PAID VS SENT!
                            if (!$paidObject) {
                                $sentObject = DataObject::get_one(
                                    'OrderStep',
                                    array('Code' => 'SENT'),
                                    $cacheDataObjectGetOne = false
                                );
                                if ($sentObject) {
if (rand(1, 6) > 3) {
//print "Check failed";
} else {
    print "Check succeeded";
}
                                    //do nothing
                                } else {
                                    $this->DBAlterationMessageNow('Creating default steps', 'created');
                                    singleton('OrderStep')->requireDefaultRecords();
                                }
                            }
                            $sentObject = DataObject::get_one(
                                'OrderStep',
                                array('Code' => 'SENT'),
                                $cacheDataObjectGetOne = false
                            );
                            if ($sentObject) {
                                $this->DBAlterationMessageNow('Updating to SENT status', 'created');
                                DB::query('UPDATE "Order" SET "StatusID" = '.$sentObject->ID.' WHERE "Order"."ID" = '.$row['ID'].' AND ("StatusID" = 0 OR "StatusID" IS NULL)');
                            } elseif ($archivedObject = DataObject::get_one('OrderStep', array('Code' => 'ARCHIVED'), $cacheDataObjectGetOne = false)) {
                                $this->DBAlterationMessageNow('Updating to ARCHIVED status', 'created');
                                DB::query('UPDATE "Order" SET "StatusID" = '.$archivedObject->ID.' WHERE "Order"."ID" = '.$row['ID'].' AND ("StatusID" = 0 OR "StatusID" IS NULL)');
                            } else {
                                $this->DBAlterationMessageNow('Could not find new status', 'deleted');
                            }
                            break;
                        case 'AdminCancelled':
                            if (!$adminCancelledObject) {
                                $adminCancelledObject = DataObject::get_one(
                                    'OrderStep',
                                    array('Code' => 'SENT'),
                                    $cacheDataObjectGetOne = false
                                );
                                if ($adminCancelledObject) {
if (rand(1, 6) > 3) {
//print "Check failed";
} else {
    print "Check succeeded";
}
                                    //do nothing
                                } else {
                                    singleton('OrderStep')->requireDefaultRecords();
                                }
                            }
                            $adminID = Member::currentUserID();
                            if (!$adminID) {
                                $adminID = 1;
                            }
                            $this->DBAlterationMessageNow('Updating to Admin Cancelled', 'created');
                            DB::query('UPDATE "Order" SET "StatusID" = '.$adminCancelledObject->ID.', "CancelledByID" = '.$adminID.' WHERE "Order"."ID" = '.$row['ID'].' AND ("StatusID" = 0 OR "StatusID" IS NULL)');
                            break;
                        case 'MemberCancelled':
                            if (!$memberCancelledObject) {
                                $memberCancelledObject = DataObject::get_one(
                                    'OrderStep',
                                    array('Code' => 'SENT'),
                                    $cacheDataObjectGetOne = false
                                );
                                if ($memberCancelledObject) {
if (rand(1, 6) > 3) {
//print "Check failed";
} else {
    print "Check succeeded";
}
                                    //do nothing
                                } else {
                                    singleton('OrderStep')->requireDefaultRecords();
                                }
                            }
                            $this->DBAlterationMessageNow('Updating to MemberCancelled', 'created');
                            DB::query('UPDATE "Order" SET "StatusID" = '.$memberCancelledObject->ID.', "CancelledByID" = "MemberID" WHERE "Order"."ID" = '.$row['ID'].' AND ("StatusID" = 0 OR "StatusID" IS NULL)');
                            break;
                        default:
                            $this->DBAlterationMessageNow('Unexpected status', 'deleted');
                    }
                }
            } else {
                $this->DBAlterationMessageNow('No orders could be found.');
            }
            $this->makeFieldObsolete('Order', 'Status');
        } else {
            $this->DBAlterationMessageNow('There is no Status field in the Order Table.');
        }

        return 0;
    }

    protected function fixBadOrderStatus_68()
    {
        $explanation = '
            <h1>68. Fix Bad Order Status</h1>
            <p>Fixing any orders with an StatusID that is not in use...</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $firstOption = DataObject::get_one('OrderStep', null, $cacheDataObjectGetOne = false);
        if ($firstOption) {
            $badOrders = Order::get()
                ->where('"StatusID" = 0 OR "StatusID" IS NULL OR "OrderStep"."ID" IS NULL')
                ->leftJoin('OrderStep', '"Order"."StatusID" = "OrderStep"."ID"')
                ->limit($this->limit, $this->start);
            if ($badOrders->count()) {
                foreach ($badOrders as $order) {
                    if ($order->TotalItems() > 0) {
                        DB::query('UPDATE "Order" SET "StatusID" = '.$firstOption->ID.' WHERE "Order"."ID" = '.$order->ID);
                        $this->DBAlterationMessageNow('No order status for order number #'.$order->ID." reverting to: $firstOption->Name.", 'error');
                    }
                }

                return $this->start + $this->limit;
            } else {
                $this->DBAlterationMessageNow('There are no orders with incorrect order status.');
            }
        } else {
            $this->DBAlterationMessageNow('No first order step.', 'error');
        }

        return 0;
    }

    protected function updateProductGroups_110()
    {
        $explanation = "
            <h1>110. Update Product Groups: </h1>
            <p>Set the product groups 'show products' to the default.</p>
        ";
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $checkIfAnyLevelsAreSetAtAll = DB::query('SELECT COUNT(ID) FROM "ProductGroup" WHERE "LevelOfProductsToShow" <> 0 AND "LevelOfProductsToShow" IS NOT NULL')->value();
        $productGroupDefaults = Config::inst()->get('ProductGroup', 'defaults');
        if ($checkIfAnyLevelsAreSetAtAll == 0 && $productGroupDefaults['LevelOfProductsToShow'] != 0) {
            //level of products to show
            DB::query(
                '
                UPDATE "ProductGroup"
                SET "LevelOfProductsToShow" = '.$productGroupDefaults['LevelOfProductsToShow'].'
                WHERE "LevelOfProductsToShow" = 0 OR "LevelOfProductsToShow" IS NULL '
            );
            DB::query(
                '
                UPDATE "ProductGroup_Live"
                SET "LevelOfProductsToShow" = '.$productGroupDefaults['LevelOfProductsToShow'].'
                WHERE "LevelOfProductsToShow" = 0 OR "LevelOfProductsToShow"  IS NULL '
            );
            $this->DBAlterationMessageNow("resetting product 'show' levels", 'created');
            //default sort order
            DB::query(
                '
                UPDATE "ProductGroup"
                SET "DefaultSortOrder" = '.$productGroupDefaults['DefaultSortOrder']."
                WHERE \"DefaultSortOrder\" = 0 OR  \"DefaultSortOrder\" = '' OR  \"DefaultSortOrder\" IS NULL "
            );
            DB::query(
                '
                UPDATE "ProductGroup_Live"
                SET "DefaultSortOrder" = '.$productGroupDefaults['DefaultSortOrder']."
                WHERE \"DefaultSortOrder\" = 0 OR  \"DefaultSortOrder\" = '' OR  \"DefaultSortOrder\" IS NULL "
            );
            $this->DBAlterationMessageNow('resetting product default sort order', 'created');
            //default filter
            DB::query(
                '
                UPDATE "ProductGroup"
                SET "DefaultFilter" = '.$productGroupDefaults['DefaultFilter']."
                WHERE \"DefaultFilter\" = 0 OR  \"DefaultFilter\" = '' OR  \"DefaultFilter\" IS NULL "
            );
            DB::query(
                '
                UPDATE "ProductGroup_Live"
                SET "DefaultFilter" = '.$productGroupDefaults['DefaultFilter']."
                WHERE \"DefaultFilter\" = 0 OR  \"DefaultFilter\" = '' OR  \"DefaultFilter\" IS NULL "
            );
            $this->DBAlterationMessageNow('resetting product default filter', 'created');
        } else {
            $this->DBAlterationMessageNow("there is no need for resetting product 'show' levels");
        }

        return 0;
    }

    protected function setFixedPriceForSubmittedOrderItems_120()
    {
        $explanation = '
            <h1>120. Set Fixed Price for Submitted Order Items: </h1>
            <p>Migration task to fix the price for submitted order items.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        if ($this->hasTableAndField('OrderModifier', 'CalculationValue')) {
            DB::query(
                '
                UPDATE "OrderAttribute"
                INNER JOIN "OrderModifier"
                    ON "OrderAttribute"."ID" = "OrderModifier"."ID"
                SET "OrderAttribute"."CalculatedTotal" = "OrderModifier"."CalculationValue"
                WHERE "OrderAttribute"."CalculatedTotal" = 0'
            );
            $this->makeFieldObsolete('OrderModifier', 'CalculationValue');
            $this->DBAlterationMessageNow('Moving values from OrderModifier.CalculationValue to OrderAttribute.CalculatedTotal', 'created');
        } else {
            $this->DBAlterationMessageNow('There is no need to move values from OrderModifier.CalculationValue to OrderAttribute.CalculatedTotal');
        }
        /////////////////////////////////
        ///////// We should not include the code below
        ///////// Because it may affect past orders badly.
        /////////////////////////////////
        /////////////////////////////////
        return;
        $orderItems = Order::get()
function fx() {
    try {
        doSomething();
        return true;
    }
    catch (\Exception $e) {
        return false;
    }

    return false;
}
            ->where('"Quantity" <> 0 AND "OrderAttribute"."CalculatedTotal" = 0')
            ->sort('"Created" ASC')
            ->limit($this->limit, $this->start);
        $count = 0;
        if ($orderItems->count()) {
            foreach ($orderItems as $orderItem) {
                if ($orderItem->Order()) {
                    if ($orderItem->Order()->IsSubmitted()) {
                        //TO DO: WHAT THE HELL IS THAT (true)
                        $unitPrice = $orderItem->UnitPrice($recalculate = true);
                        if ($unitPrice) {
                            $orderItem->CalculatedTotal = $unitPrice * $orderItem->Quantity;
                            $orderItem->write();
                            ++$count;
                            $this->DBAlterationMessageNow('RECALCULATING: '.$orderItem->UnitPrice($recalculate = true).' * '.$orderItem->Quantity.' = '.$orderItem->CalculatedTotal.' for OrderItem #'.$orderItem->ID, 'created');
                        }
                    } else {
                        $this->DBAlterationMessageNow('OrderItem is part of not-submitted order.');
                    }
                } else {
                    $this->DBAlterationMessageNow('OrderItem does not have an order! (OrderItemID: '.$orderItem->ID.')', 'deleted');
                }
            }
        } else {
            $this->DBAlterationMessageNow('All order items have a calculated total....');
        }
        if ($count) {
            $this->DBAlterationMessageNow("Fixed price for all submmitted orders without a fixed one - affected: $count order items", 'created');
        }

        return 0;
    }

    protected function moveSiteConfigToEcommerceDBConfig_140()
    {
        $explanation = '
            <h1>140. Move Site Config fields to Ecommerce DB Config</h1>
            <p>Moving the general config fields from the SiteConfig to the EcommerceDBConfig.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $fields = array(
            'ShopClosed',
            'ShopPricesAreTaxExclusive',
            'ShopPhysicalAddress',
            'ReceiptEmail',
            'PostalCodeURL',
            'PostalCodeLabel',
            'NumberOfProductsPerPage',
            'OnlyShowProductsThatCanBePurchased',
            'ProductsHaveWeight',
            'ProductsHaveModelNames',
            'ProductsHaveQuantifiers',
            'ProductsAlsoInOtherGroups',
            //"ProductsHaveVariations",
            'EmailLogoID',
            'DefaultProductImageID',
        );
        $ecomConfig = DataObject::get_one('EcommerceDBConfig', null, $cacheDataObjectGetOne = false);
        if (!$ecomConfig) {
            $ecomConfig = EcommerceDBConfig::create();
            $ecomConfig->write();
        }
        $sc = SiteConfig::current_site_config();
        if ($ecomConfig && $sc) {
            foreach ($fields as $field) {
                if ($this->hasTableAndField('SiteConfig', $field)) {
                    if (!$this->hasTableAndField('EcommerceDBConfig', $field)) {
                        $this->DBAlterationMessageNow("Could not find EcommerceDBConfig.$field - this is unexpected!", 'deleted');
                    } else {
                        $this->DBAlterationMessageNow("Migrated SiteConfig.$field", 'created');
                        $ecomConfig->$field = DB::query("SELECT \"$field\" FROM \"SiteConfig\" WHERE \"ID\" = ".$sc->ID)->value();
                        $ecomConfig->write();
                        $this->makeFieldObsolete('SiteConfig', $field);
                    }
                } else {
                    $this->DBAlterationMessageNow("SiteConfig.$field has been moved");
                }
            }
        } else {
            $this->DBAlterationMessageNow('ERROR: SiteConfig or EcommerceDBConfig are not available', 'deleted');
        }

        return 0;
    }

    public function addClassNameToOrderItems_150()
    {
        $explanation = '
            <h1>150. Add a class name to all buyables.</h1>
            <p>ClassNames used to be implied, this is now saved as OrderItem.BuyableClassName.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $rows = DB::query("
            SELECT \"OrderAttribute\".\"ID\", \"ClassName\"
            FROM \"OrderAttribute\"
                INNER JOIN \"OrderItem\" ON \"OrderItem\".\"ID\" = \"OrderAttribute\".\"ID\"
            WHERE \"BuyableClassName\" = '' OR \"BuyableClassName\" IS NULL;
        ");
        if ($rows) {
            foreach ($rows as $row) {
                $orderItemPostFix = '_OrderItem';
                $id = $row['ID'];
                $className = str_replace($orderItemPostFix, '', $row['ClassName']);
                if (class_exists($className) && ClassInfo::is_subclass_of($className, 'DataObject')) {

                    DB::query("
                        UPDATE \"OrderItem\"
                        SET \"BuyableClassName\" = '$className'
                        WHERE \"ID\" = $id;
                    ");
                    $this->DBAlterationMessageNow("Updating Order.BuyableClassName ( ID = $id ) to $className.", 'created');
                } else {
                    $this->DBAlterationMessageNow("Order Item with ID = $id does not have a valid class name. This needs investigation.", 'deleted');
                }
            }
        } else {
            $this->DBAlterationMessageNow('No order items could be found that need updating.');
        }

        return 0;
    }

    public function addTermsAndConditionsMessage_160()
    {
        $explanation = '
            <h1>160. Add checkout message TermsAndConditionsMessage message.</h1>
            <p>Adds TermsAndConditionsMessage if there is a terms page.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $checkoutPage = DataObject::get_one('CheckoutPage', null, $cacheDataObjectGetOne = false);
        if ($checkoutPage) {
            if ($checkoutPage->TermsPageID) {
                if (!$checkoutPage->TermsAndConditionsMessage) {
                    $checkoutPageDefaults = Config::inst()->get('CheckoutPage', 'defaults');
                    $checkoutPage->TermsAndConditionsMessage = $checkoutPageDefaults['TermsAndConditionsMessage'];
                    $checkoutPage->writeToStage('Stage');
                    $checkoutPage->publish('Stage', 'Live');
                    $this->DBAlterationMessageNow('Added TermsAndConditionsMessage', 'created');
                } else {
                    $this->DBAlterationMessageNow('There was no need to add a terms and conditions message because there was already a message.');
                }
            } else {
                $this->DBAlterationMessageNow('There was no need to add a terms and conditions message because there is no terms and conditions page.');
            }
        } else {
            $this->DBAlterationMessageNow('There was no need to add a terms and conditions message because there is no checkout page', 'deleted');
        }

        return 0;
    }

    public function mergeUncompletedOrderForOneMember_170()
    {
        $explanation = '
            <h1>170. Merge uncompleted orders into one.</h1>
            <p>Merges uncompleted orders by the same user into one.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $orders = Order::get()
            ->filter(array('MemberID:GreaterThan' => 0))
            ->sort(array(
                'MemberID' => 'ASC',
                '"Order"."Created"' => 'DESC',
            ))
            ->innerJoin('Member', '"Order"."MemberID" = "Member"."ID"')
            ->limit($this->limit, $this->start);
        $count = 0;
        $previousOrderMemberID = 0;
        $lastOrderFromMember = null;
        if ($orders->count()) {
            foreach ($orders as $order) {
                //crucial ONLY for non-submitted orders...
                if ($order->IsSubmitted()) {
                    //do nothing!
                    ++$count;
                } else {
                    $memberID = $order->MemberID;
                    //recurring member
                    if ($previousOrderMemberID == $memberID && $lastOrderFromMember) {
                        $this->DBAlterationMessageNow('We have a duplicate order for a member: '.$order->Member()->Email, 'created');
                        $orderAttributes = OrderAttribute::get()
                            ->filter(array('OrderID' => $order->ID));
                        if ($orderAttributes->count()) {
                            foreach ($orderAttributes as $orderAttribute) {
                                $this->DBAlterationMessageNow('Moving attribute #'.$orderAttribute->ID, 'created');
                                DB::query('UPDATE "OrderAttribute" SET "OrderID" = '.$lastOrderFromMember->ID.' WHERE "ID" = '.$orderAttribute->ID);
                            }
                        } else {
                            $this->DBAlterationMessageNow('There are no attributes for this order');
                        }
                        $orderStatusLogs = OrderStatusLog::get()->filter(array('OrderID' => $order->ID));
                        if ($orderStatusLogs->count()) {
                            foreach ($orderStatusLogs as $orderStatusLog) {
                                $this->DBAlterationMessageNow('Moving order status log #'.$orderStatusLog->ID, 'created');
                                DB::query('UPDATE "OrderStatusLog" SET "OrderID" = '.$lastOrderFromMember->ID.' WHERE "ID" = '.$orderStatusLog->ID);
                            }
                        } else {
                            $this->DBAlterationMessageNow('There are no order status logs for this order');
                        }
                        $orderEmailRecords = OrderEmailRecord::get()->filter(array('OrderID' => $order->ID));
                        if ($orderEmailRecords->count()) {
                            foreach ($orderEmailRecords as $orderEmailRecord) {
                                DB::query('UPDATE "OrderEmailRecord" SET "OrderID" = '.$lastOrderFromMember->ID.' WHERE "ID" = '.$orderEmailRecord->ID);
                                $this->DBAlterationMessageNow('Moving email #'.$orderEmailRecord->ID, 'created');
                            }
                        } else {
                            $this->DBAlterationMessageNow('There are no emails for this order.');
                        }
                    }
                    //new member
                    else {
                        $previousOrderMemberID = $order->MemberID;
                        $lastOrderFromMember = $order;
                        $this->DBAlterationMessageNow('Found last order from member.');
                    }
                    if ($order->BillingAddressID && !$lastOrderFromMember->BillingAddressID) {
                        $this->DBAlterationMessageNow('Moving Billing Address.');
                        DB::query('UPDATE "Order" SET "BillingAddressID" = '.$order->BillingAddressID.' WHERE "ID" = '.$lastOrderFromMember->ID);
                        DB::query('UPDATE "BillingAddress" SET "OrderID" = '.$lastOrderFromMember->ID.' WHERE "ID" = '.$order->BillingAddressID);
                    }
                    if ($order->ShippingAddressID && !$lastOrderFromMember->ShippingAddressID) {
                        $this->DBAlterationMessageNow('Moving Shipping Address.');
                        DB::query('UPDATE "Order" SET "ShippingAddressID" = '.$order->ShippingAddressID.' WHERE "ID" = '.$lastOrderFromMember->ID);
                        DB::query('UPDATE "ShippingAddress" SET "OrderID" = '.$lastOrderFromMember->ID.' WHERE "ID" = '.$order->ShippingAddressID);
                    }
                    $order->delete();
                }
            }
            $this->DBAlterationMessageNow("Ignored $count Orders that have already been submitted.");

            return $this->start + $this->limit;
        } else {
            $this->DBAlterationMessageNow('There were no orders at all to work through.');
        }

        return 0;
    }

    public function updateFullSiteTreeSortFieldForAllProducts_180()
    {
        $explanation = '
            <h1>180. Set starting value Product.FullSiteTreeSort Field.</h1>
            <p>Sets a starting value for a new field: FullSiteTreeSortField.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        //level 10
        $task = new EcommerceTaskCleanupProducts();
        $task->setDeleteFirst(false);
        $task->run(null);
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);

        return 0;
    }

    public function updateOrderStatusLogSequentialOrderNumber_190()
    {
        $explanation = '
            <h1>190. Set sequential order numbers</h1>
            <p>Prepopulates old orders for OrderStatusLog_Submitted.SequentialOrderNumber.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $submittedOrdersLog = OrderStatusLog_Submitted::get()
            ->sort('Created', 'ASC')
            ->limit($this->limit, $this->start);
        $changes = 0;
        if ($submittedOrdersLog->count()) {
            foreach ($submittedOrdersLog as $submittedOrderLog) {
                $old = $submittedOrderLog->SequentialOrderNumber;
                $submittedOrderLog->write();
                $new = $submittedOrderLog->SequentialOrderNumber;
                if ($old != $new) {
                    ++$changes;
                    $this->DBAlterationMessageNow('Changed the SequentialOrderNumber for order #'.$submittedOrderLog->OrderID." from $old to $new ");
                }
            }
            if (!$changes) {
                $this->DBAlterationMessageNow('There were no changes in any of the OrderStatusLog_Submitted.SequentialOrderNumber fields.');
            }

            return $this->start + $this->limit;
        } else {
            $this->DBAlterationMessageNow('There are no logs to update.');
        }

        return 0;
    }

    public function resaveAllPRoducts_200()
    {
        $explanation = '
            <h1>200. Resave All Products to update the FullName and FullSiteTreeSort Field</h1>
            <p>Saves and PUBLISHES all the products on the site. You may need to run this task several times.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $count = 0;
        $products = Product::get()
            ->where("\"FullName\" = '' OR \"FullName\" IS NULL")
            ->sort('ID', 'ASC')
            ->limit($this->limit, $this->start);
        if ($products->count()) {
            foreach ($products as $product) {
                ++$count;
                $product->writeToStage('Stage');
                $product->publish('Stage', 'Live');
                $this->DBAlterationMessageNow('Saving Product '.$product->Title);
            }

            return $this->start + $this->limit;
        } else {
            $this->DBAlterationMessageNow('No products to update.');
        }

        return 0;
    }

    public function resaveAllPRoductsVariations_210()
    {
        $explanation = '
            <h1>210. Resave All Product Variations to update the FullName and FullSiteTreeSort Field</h1>
            <p>Saves all the product variations on the site. You may need to run this task several times.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $count = 0;
        if (class_exists('ProductVariation')) {
            ProductVariation::get()
                ->where("\"FullName\" = '' OR \"FullName\" IS NULL")
                ->sort('ID', 'ASC')
                ->limit($this->limit, $this->start);
            if ($variations->count()) {
                foreach ($variations as $variation) {

                    ++$count;
                    $variation->write();
                    $this->DBAlterationMessageNow('Saving Variation '.$variation->getTitle());
                }

                return $this->start + $this->limit;
            } else {
                $this->DBAlterationMessageNow('No product variations to update.');
            }
        } else {
            $this->DBAlterationMessageNow('There are not ProductVariations in this project');
        }

        return 0;
    }

    public function addConfirmationPage_250()
    {
        $explanation = '
            <h1>250. Add Confirmation Page</h1>
            <p>Creates a checkout page and order confirmation page in case they do not exist.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $checkoutPage = DataObject::get_one('CheckoutPage', null, $cacheDataObjectGetOne = false);
        if (!$checkoutPage) {
            $checkoutPage = new CheckoutPage();
            $this->DBAlterationMessageNow('Creating a CheckoutPage', 'created');
        } else {
            $this->DBAlterationMessageNow('No need to create a CheckoutPage Page');
        }
        if ($checkoutPage) {
            $checkoutPage->HasCheckoutSteps = 1;
            $checkoutPage->writeToStage('Stage');
            $checkoutPage->publish('Stage', 'Live');
            $orderConfirmationPage = DataObject::get_one('OrderConfirmationPage', null, $cacheDataObjectGetOne = false);
            if ($orderConfirmationPage) {
                $this->DBAlterationMessageNow('No need to create an Order Confirmation Page');
            } else {
                $orderConfirmationPage = new OrderConfirmationPage();
                $orderConfirmationPage->ParentID = $checkoutPage->ID;
                $orderConfirmationPage->writeToStage('Stage');
                $orderConfirmationPage->publish('Stage', 'Live');
                $this->DBAlterationMessageNow('Creating an Order Confirmation Page', 'created');
            }
        } else {
            $this->DBAlterationMessageNow('There is no CheckoutPage available', 'deleted');
        }

        return 0;
    }

    public function cleanupImages_260()
    {
        $explanation = '
            <h1>260. Cleanup Images</h1>
            <p>Checks the class name of all product images and makes sure they exist.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $task = new EcommerceTaskProductImageReset();
        $task->run(null);
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);

        return 0;
    }

    public function addNewPopUpManager_280()
    {
        $explanation = '
            <h1>280. Add new pop-up manager</h1>
            <p>Replaces a link to a JS Library in the config file</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $oldJSLibrary = 'ecommerce/thirdparty/simpledialogue_fixed/jquery.simpledialog.0.1.js';
        $newJSLibrary = 'ecommerce/thirdparty/colorbox/jquery.colorbox-min.js';
        $fileArray = Config::inst()->get('EcommerceConfig', 'folder_and_file_locations');
        if ($fileArray && count($fileArray)) {
            foreach ($fileArray as $folderAndFileLocationWithoutBase) {
$collection = json_decode($data, true);
if ( ! is_array($collection)) {
    throw new \RuntimeException('$collection must be an array.');
}

foreach ($collection as $item) { /** ... */ }
                if ($folderAndFileLocationWithoutBase != 'ecommerce/_config/ecommerce.yml') {
                    $folderAndFileLocationWithBase = Director::baseFolder().'/'.$folderAndFileLocationWithoutBase;
                    if (file_exists($folderAndFileLocationWithBase)) {
                        $fp = @fopen($folderAndFileLocationWithBase, 'r');
                        if ($fp) {
                            $oldContent = fread($fp, filesize($folderAndFileLocationWithBase));
                            $newContent = str_replace($oldJSLibrary, $newJSLibrary, $oldContent);
                            if ($oldContent != $newContent) {
                                fclose($fp);
                                $fp = fopen($folderAndFileLocationWithBase, 'w+');
                                if (fwrite($fp, $newContent)) {
                                    $this->DBAlterationMessageNow("file updated from $oldJSLibrary to $newJSLibrary in  $folderAndFileLocationWithoutBase", 'created');
                                } else {
                                    $this->DBAlterationMessageNow("Could NOT update from $oldJSLibrary to $newJSLibrary in  $folderAndFileLocationWithoutBase");
                                }
                                fclose($fp);
                            } else {
                                $this->DBAlterationMessageNow("There is no need to update $folderAndFileLocationWithBase");
                            }
                        } else {
                            $this->DBAlterationMessageNow("it seems that $folderAndFileLocationWithBase - does not have the right permission, please change manually.", 'deleted');
                        }
                    } else {
                        $this->DBAlterationMessageNow("Could not find $folderAndFileLocationWithBase - even though it is referenced in EcommerceConfig::\$folder_and_file_locations", 'deleted');
                    }
                } else {
                    $this->DBAlterationMessageNow('There is no need to replace the ecommerce default file: ecommerce/_config/ecommerce.yml', 'created');
                }
            }
        } else {
            $this->DBAlterationMessageNow('Could not find any config files (most usual place: mysite/_config/ecommerce.yml)', 'deleted');
        }

        return 0;
    }

    public function addCurrencyCodeIDToOrders_290()
    {
        $explanation = '
            <h1>290. Add Curenccy to Orders</h1>
            <p>Sets all currencies to the default currency for all orders without a currency.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $ordersWithoutCurrencyCount = Order::get()->filter(array('CurrencyUsedID' => 0))->count();
        if ($ordersWithoutCurrencyCount) {
            $currencyID = EcommerceCurrency::default_currency_id();
            DB::query("UPDATE \"Order\" SET \"CurrencyUsedID\" = $currencyID WHERE \"CurrencyUsedID\" = 0");
            $this->DBAlterationMessageNow("All orders ($ordersWithoutCurrencyCount) have been set a currency value.", 'changed');
        }

        return 0;
    }

    public function MovePaymentToEcommercePayment_300()
    {
        $explanation = '
            <h1>300. Migrating Payment to EcommercePayment</h1>
            <p>We move the data from Payment to EcommercePayment.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $db = DB::getConn();

        $table = 'Payment';
        if ($db->hasTable('_obsolete_Payment') && !$db->hasTable('Payment')) {

            $table = '_obsolete_Payment';
            $this->DBAlterationMessageNow('The table Payment has been moved to _obsolete_Payment. We are using _obsolete_Payment to fix things...', 'deleted');
        }
        DB::query(
            '
            INSERT IGNORE INTO EcommercePayment(
                `ID`,
                `ClassName`,
                `Created`,
                `LastEdited`,
                `Status`,
                `AmountAmount`,
                `AmountCurrency`,
                `Message`,
                `IP`,
                `ProxyIP`,
                `OrderID`,
                `ExceptionError`,
                `PaidByID`
            )
            SELECT
                    `ID`,
                    `ClassName`,
                    `Created`,
                    `LastEdited`,
                    `Status`,
                    IF(`AmountAmount` > 0, `AmountAmount`, `Amount`),
                    IF(`AmountCurrency` <> \'\', `AmountCurrency`, `Currency`),
                    `Message`,
                    `IP`,
                    `ProxyIP`,
                    `OrderID`,
                    `ExceptionError`,
                    `PaidByID`
                FROM '.$table.''
        );
        $this->DBAlterationMessageNow('Moving Payment to Ecommerce Payment', 'created');

        return 0;
    }

    public function ecommercetaskupgradepickupordeliverymodifier_310()
    {
        $explanation = '
            <h1>310.Upgrade Pick Up of Delivery Modifier</h1>
            <p>Fixing data in this modifier if it exists.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        if (class_exists('EcommerceTaskUpgradePickUpOrDeliveryModifier') && $this->hasTableAndField('PickUpOrDeliveryModifier', 'PickupOrDeliveryType')) {
            $obj = EcommerceTaskUpgradePickUpOrDeliveryModifier::create();
            $obj->run(null);
        }

        return 0;
    }

    public function ecommercetaskupgradepickupordeliverymodifier_320()
    {
        $explanation = '
            <h1>320. Removing empty Order Items</h1>
            <p>Removes all the order items without a buyable.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $orderItems = OrderItem::get()->filter(array('BuyableID' => 0));
        $count = $orderItems->count();
        if ($count > 0) {
            $style = 'deleted';
        } else {
            $style = 'created';
        }
        $this->DBAlterationMessageNow('There are '.$count.' items that should be removed', $style);
        foreach ($orderItems as $orderItem) {
            $this->DBAlterationMessageNow('Deleting order item with ID: '.$orderItem->ID, 'deleted');
            $orderItem->delete();
        }

        return 0;
    }

    public function removemobilephones_330()
    {
        $explanation = '
            <h1>323. Removing mobile phones</h1>
            <p>Move all Billing and Shipping Address Mobile Phone Entries to Phone.</p>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }
        $this->DBAlterationMessageNow('Moving Mobile Phone to Phone in Billing Address', 'created');
        DB::query("UPDATE BillingAddress SET Phone = MobilePhone WHERE Phone = '' OR Phone IS NULL;");

        $this->DBAlterationMessageNow('Moving Mobile Phone to Phone in Shipping Address', 'created');
        DB::query("UPDATE ShippingAddress SET ShippingPhone = ShippingMobilePhone WHERE ShippingPhone = '' OR ShippingPhone IS NULL;");

        $this->DBAlterationMessageNow('Merging Mobile Phone and Phone in Billing Address', 'created');
        DB::query("UPDATE BillingAddress SET Phone = CONCAT(Phone, ' ', MobilePhone) WHERE Phone <> '' AND Phone IS NOT NULL AND MobilePhone <> '' AND MobilePhone IS NOT NULL;");

        $this->DBAlterationMessageNow('Merging Mobile Phone and Phone in Shipping Address', 'created');
        DB::query("UPDATE ShippingAddress SET ShippingPhone = CONCAT(ShippingPhone, ' ', ShippingMobilePhone) WHERE ShippingPhone <> '' AND ShippingPhone IS NOT NULL AND ShippingMobilePhone <> '' AND ShippingMobilePhone IS NOT NULL;");

        //remove fields
        $this->DBAlterationMessageNow('Making obsolete: BillingAddress.MobilePhone', 'deleted');
        $this->makeFieldObsolete('BillingAddress', 'MobilePhone');

        $this->DBAlterationMessageNow('Making obsolete: ShippingAddress.ShippingMobilePhone', 'deleted');
        $this->makeFieldObsolete('ShippingAddress', 'ShippingMobilePhone');

        return 0;
    }

    public function theEnd_9999()
    {
        $explanation = '
            <h1>9999. Migration Completed</h1>
        ';
        if ($this->retrieveInfoOnly) {
            return $explanation;
        } else {
            echo $explanation;
        }

        return 0;
    }

    public function DBAlterationMessageNow($message, $style = '')
    {
        DB::alteration_message($message, $style);
        ob_end_flush();
        ob_start();
    }
}

Push — master ( f71c82...1db67b )

EcommerceTaskMigration::orderTax_45() B

Complexity

Size

Duplication

Importance

Available Fixes

Available Fixes

sunnysideup / silverstripe-ecommerce

Push — master ( f71c82...1db67b )

EcommerceTaskMigration::orderTax_45() B

Complexity

Size

Duplication

Importance

Available Fixes

Available Fixes

Duplication Side-by-Side

Filter issues like
