I hereby claim:
- I am josephleedy on github.
- I am josephleedy (https://keybase.io/josephleedy) on keybase.
- I have a public key ASD3B3sUSZ8YMhkpLFZUYp7Dg5UcKRRzUGJd1dF_0hpy5Qo
To claim this, I am signing this object:
<?php | |
/** @noinspection ALL */ | |
use Magento\Framework\App\Bootstrap; | |
use Magento\Framework\App\Http; | |
use Magento\Framework\App\ResourceConnection; | |
use Magento\Framework\App\State; | |
require_once '/var/www/html/app/bootstrap.php'; |
SELECT | |
DATE(so.created_at) AS 'Order Date', | |
fee.title AS 'Fee', | |
SUM(fee.base_value) AS 'Base Total Amount', | |
SUM(fee.value) AS 'Total Amount' | |
FROM custom_order_fees AS cof | |
JOIN JSON_TABLE( | |
cof.custom_fees, | |
'$' COLUMNS ( | |
NESTED PATH '$.*' COLUMNS ( |
I hereby claim:
To claim this, I am signing this object: