adrian-lorenc / piwik-pro-reporting-api

PHP客户端库,用于查询Piwik Pro Reporting API。

1.0.0-alpha1 2023-06-08 14:56 UTC

This package is auto-updated.

Last update: 2024-09-08 20:08:52 UTC


README

描述

允许查询以下资源

安装

可以使用Composer安装此项目。运行composer require adrian-lorenc/piwik-pro-reporting-api或将以下内容添加到您的composer.json中

{
  "require": {
    "adrian-lorenc/piwik-pro-reporting-api": "dev-develop"
  }
}

用法

<?php

require '../vendor/autoload.php';

use PiwikPro\ReportingApi\Client;
use PiwikPro\ReportingApi\Query\DirectQuery;
use PiwikPro\ReportingApi\Query\Model\Column;
use PiwikPro\ReportingApi\Query\Model\Date;
use PiwikPro\ReportingApi\Query\Model\Direction;
use PiwikPro\ReportingApi\Query\Model\ColumnCondition;
use PiwikPro\ReportingApi\Query\Model\ColumnOperator;
use PiwikPro\ReportingApi\Query\Model\Condition;
use PiwikPro\ReportingApi\Query\Model\Filter;
use PiwikPro\ReportingApi\Query\Model\LogicalOperator;

$client = Client::create(
    'https://xyz.piwik.pro',
    'client_id',
    'client_secret'
);

$dateFrom = new Date(new DateTime('01/01/2021'));
$dateTo = new Date(new DateTime('03/30/2021'));

$columnCondition = new ColumnCondition(ColumnOperator::not_empty, null);
$condition = new Condition('goal_uuid', $columnCondition);

$filter = (new Filter(LogicalOperator::or))
    ->addCondition($condition);

$filterContainer = (new Filter(LogicalOperator::and))
    ->addFilter($filter);

$query = (new DirectQuery('website_id'))
    ->addColumn(new Column('goal_uuid'))
    ->addColumn(new Column('goal_conversions'))
    ->addColumn(new Column('goal_revenue', 'sum'))
    ->setLimit(10)
    ->setOffset(0)
    ->setDateFrom($dateFrom)
    ->setDateTo($dateTo)
    ->setFilter($filterContainer)
    ->addOrderBy(2, Direction::ASC);

echo '<pre>';
echo 'Requested serialized query:' . "\n";
var_dump(json_encode($query, JSON_PRETTY_PRINT));
echo "\n" . '--------------------------------------------------' . "\n";
echo 'Service response:' . "\n";
var_dump(json_decode($client->request($query)->getBody()->getContents()));
echo '</pre>';