I hereby claim:
- I am CyberSecutor on github.
- I am cybersecutor (https://keybase.io/cybersecutor) on keybase.
- I have a public key whose fingerprint is A840 EE0A 9641 8244 8D07 6127 AF2C 3985 5EAF 7336
To claim this, I am signing this object:
I hereby claim:
To claim this, I am signing this object:
<?php | |
class Engine | |
{ | |
private $pk; | |
public function __construct(int $pk) | |
{ | |
$this->pk = $pk; | |
} |
use magento; | |
########################################################## | |
# PRODUCTS | |
########################################################## | |
DELETE FROM `catalog_product_bundle_option`; | |
DELETE FROM `catalog_product_bundle_option_value`; | |
DELETE FROM `catalog_product_bundle_selection`; | |
DELETE FROM `catalog_product_entity_datetime`; | |
DELETE FROM `catalog_product_entity_decimal`; |
-- Sets the timezone for the current session. | |
SET time_zone = '+02:00'; | |
-- Orders Per Year -- | |
SELECT period_date as year, order_count, gross_revenue, ROUND(gross_revenue / order_count, 2) AS gross_aov | |
FROM ( | |
SELECT | |
COUNT(*) AS order_count, | |
ROUND(SUM(base_grand_total), 2) AS gross_revenue, | |
DATE_FORMAT(o.created_at, '%Y') AS period_date |