Wallogit.com
2017 © Pedro Peláez
Take your Periscope SQL and generate MySQL statements.
periscopedata.com is a powerful and useful tool for generating reports, but sometimes I want to put what I write in Periscope to use elsewhere. This package allows you to write once but generate MySQL statements with filters and daterange within PHP., (*1)
You bet..., (*2)
use Fulfillment\periscopeToMySQL\periscopeToMySQL;
$args = [
'dateStart' => "2016-01-01",
'dateEnd' => "2016-03-11",
'Warehouse' => "1,2,3",
'State' => "GA",
];
$sql = 'SELECT
[yourFirstTable.aDate:est] AS aDate,
yourSecondTable.part2
FROM
yourFirstTable
JOIN yourSecondTable ON yourFirstTable.id = yourSecondTable.id
WHERE
[yourFirstTable.recordedOn=daterange:est]
AND [yourFirstTable.warehouse=Warehouse]
AND [yourSecondTable.state=State]';
$sql = periscopeToMySQL::fillTemplate($sql, $args);
WARNING: this project is still in development, (*3)
composer require fulfillment/periscope-to-mysql
"require": {
"fulfillment/periscope-to-mysql": "dev-master"
}
"repositories": [
{
"type": "path",
"url": "../periscope-to-mysql"
}
],
"require": {
"fulfillment/periscope-to-mysql": "dev-master"
}
Feel free, time zone support may be a good place to start., (*4)