Shopware\DataGenerator\Resources\Orders::createSQL PHP Method

createSQL() private method

Constructs the actual inserts from the passed arrays
private createSQL ( $valueData ) : string
$valueData
return string
    private function createSQL($valueData)
    {
        $sql = array();
        $sql[] = "\n            INSERT INTO `s_order` (`id`,`ordernumber`, `userID`, `invoice_amount`, `invoice_amount_net`, `invoice_shipping`, `invoice_shipping_net`, `ordertime`, `status`, `cleared`, `paymentID`, `transactionID`, `comment`,  `customercomment`, `internalcomment`, `net`, `taxfree`, `partnerID`, `temporaryID`, `referer`, `cleareddate`, `trackingcode`, `language`, `dispatchID`, `currency`, `currencyFactor`, `subshopID`, `remote_addr` ) VALUES " . implode(",\n            ", $valueData['orderValues']) . ";";
        $sql[] = "\n            INSERT INTO `s_order_details` (`id`, `orderID`, `ordernumber`, `articleID`, `articleordernumber`, `price`, `quantity`, `name`, `status`, `shipped`, `shippedgroup`) VALUES\n            " . implode(",", $valueData['orderDetailValues']) . ";";
        $sql[] = "\n            INSERT INTO `s_order_billingaddress` (`userID`, `orderID`, `company`, `department`, `salutation`, `customernumber`, `firstname`, `lastname`, `street`, `zipcode`, `city`, `phone`, `countryID`, `stateID`) VALUES " . implode(" , ", $valueData['customerBillingValues']) . ";";
        $sql[] = "\n            INSERT INTO `s_order_shippingaddress` (`userID`, `orderID`, `company`, `department`, `salutation`, `firstname`, `lastname`, `street`, `zipcode`, `city`, `countryID`, `stateID`) VALUES " . implode(" , ", $valueData['customerShippingValues']) . ";";
        $sql[] = "\n            INSERT INTO `s_order_shippingaddress_attributes` (`id`, `shippingID`) VALUES " . implode(", ", $valueData['customerBillingAttributeValues']) . ";";
        $sql[] = "\n            INSERT INTO `s_order_billingaddress_attributes` (`id`, `billingID`) VALUES " . implode(", ", $valueData['customerBillingAttributeValues']) . ";";
        return $sql;
    }