README

重要声明

如果您在使用 SQL 查询时遇到错误，我们建议使用 mariadb 数据库。该组件使用复杂的 SQL 查询，在此情况下 mariadb 比 mysql 更好。

安装

1) //-- 在您的项目 composer.json 中添加以下内容 --//

"require": {
    // ...
    "beberlei/DoctrineExtensions": "dev-master",
    "gkratz/analyticbundle": "dev-master"
}

2) //-- 在您的 app/AppKernel.php 中激活组件 --//

new Gkratz\AnalyticBundle\GkratzAnalyticBundle(),
new Ob\HighchartsBundle\ObHighchartsBundle(),
new Knp\Bundle\PaginatorBundle\KnpPaginatorBundle(),
new Lexik\Bundle\FormFilterBundle\LexikFormFilterBundle(),

3) //-- 在终端中输入以下命令并安装后，验证 vendor 文件夹中是否存在 beberlei 文件夹。如果没有，输入以下命令：php composer update beberlei/DoctrineExtensions --//

php composer update gkratz/analyticbundle

4) //-- 创建一个空的 AppBundle:Analytic 实体，具有受保护的 id 并继承自 \Gkratz\AnalyticBundle\Model\Analytic --//

<?php

namespace AppBundle\Entity;

use Doctrine\ORM\Mapping as ORM;
use Gkratz\AnalyticBundle\Model\Analytic as BaseAnalytic;

/**
 * Analytic
 *
 * @ORM\Table(name="analytic")
 * @ORM\Entity(repositoryClass="AppBundle\Repository\AnalyticRepository")
 */
class Analytic extends BaseAnalytic
{
    /**
     * @var int
     *
     * @ORM\Column(name="id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected $id;

    /**
     * Get id
     *
     * @return int
     */
    public function getId()
    {
        return $this->id;
    }

    public function __construct()
    {
        parent::__construct();
    }
}

5) //-- 输入以下命令 --//

php bin/console doctrine:generate:entities App
php bin/console doctrine:schema:update --force

6) //-- 更新您的前端控制器 --// //-- 仅使用 render() 方法渲染视图，而不是 renderView() --//

<?php

namespace AppBundle\Controller;

use Gkratz\AnalyticBundle\Controller\GKratzAnalyticController;

class DefaultController extends GKratzAnalyticController
{
    // ...
}

7) //-- 在 app/config/config.yml 中插入配置 --//

# Twig Configuration
twig:
    # ...
    form_themes:
        - LexikFormFilterBundle:Form:form_div_layout.html.twig

# Doctrine Configuration
doctrine:
    # ...
    orm:
        # ...
        dql:
            datetime_functions:
                month: DoctrineExtensions\Query\Mysql\Month
                year: DoctrineExtensions\Query\Mysql\Year
                day: DoctrineExtensions\Query\Mysql\Day
                dayofweek: DoctrineExtensions\Query\Mysql\DayOfWeek

# KNPPaginatorBundle Configuration
knp_paginator:
    default_options:
        distinct: false
    template:
        pagination: KnpPaginatorBundle:Pagination:twitter_bootstrap_v3_pagination.html.twig

使用方法

1) //-- 在任何控制器的任何操作中，给您的视图提供一个图表 --//

$oneYearPerBrowser = $this->get('gkratz_analytic_charts')->oneYearPerBrowser();

return $this->render('default/analytics.html.twig', array(
            'oneYearPerBrowser' => $oneYearPerBrowser
            )
);

2) //-- 在您的视图中，定义区域并在导入 jquery 之后导入 js (必要) --//

<div id="oneYearPerBrowser" class="myGCharts"></div>
<script type="text/javascript" src="{{ asset('bundles/gkratzanalytic/js/myChart.js') }}">
</script>
<script type="text/javascript">
    {{ chart(oneYearPerBrowser) }}
</script>

使用组件的完整表格和页面（如演示截图所示）

1) 更新您的 app/config/routing.yml

GkratzAnalytic:
    resource: "@GkratzAnalyticBundle/Controller/"
    type:     annotation
    prefix:   /

2) 确保在 config.yml 中的这一行取消注释以启用翻译（在 'FR' 和 'EN' 中可用）

framework:
    translator:      { fallbacks: ["%locale%"] }

3) 访问您的网站/analytics 页面

覆盖

- you can change the number of items per page in the
  vendor\gkratz\analyticbundle\Gkratz\AnalyticBundle\Constants\Constants.php file

- you can change the prefix of routes in bundle routing in your routing.yml file

- you can define an access control in your security.yml file
  ie: access_control:
          - { path: ^/analytics/, roles: ROLE_ADMIN }

- you can insert translations for your desired language or override existing translations
  in a well formatted messages.{{ lang}}.xliff in your app\Resources\translations folder
  original files: vendor\gkratz\analyticbundle\Gkratz\AnalyticBundle\Resources\translations
  (clean the cache to see effect)

- you can override the html files like copying it in a
  app\Resources\GkratzAnalyticBundle\views\default directory and extending your layout.
  You need to rename the gkratz block for your case and you need to get the js files.

所有图表

// one year per new or returning visitor
$oneYearPerUser = $this->get('gkratz_analytic_charts')->oneYearPerUser();
<div id="oneYearPerUser" class="myGCharts"></div>
{{ chart(oneYearPerUser) }}

// one year per country
$oneYearPerCountry = $this->get('gkratz_analytic_charts')->oneYearPerCountry();
<div id="oneYearPerCountry" class="myGCharts"></div>
{{ chart(oneYearPerCountry) }}

// one year per city
$oneYearPerCity = $this->get('gkratz_analytic_charts')->oneYearPerCity();
<div id="oneYearPerCity" class="myGCharts"></div>
{{ chart(oneYearPerCity) }}

// one year per language
$oneYearPerLanguage = $this->get('gkratz_analytic_charts')->oneYearPerLanguage();
<div id="oneYearPerLanguage" class="myGCharts"></div>
{{ chart(oneYearPerLanguage) }}

// one year per browser
$oneYearPerBrowser = $this->get('gkratz_analytic_charts')->oneYearPerBrowser();
<div id="oneYearPerBrowser" class="myGCharts"></div>
{{ chart(oneYearPerBrowser) }}

// one year per pages views
$oneYearPerPage = $this->get('gkratz_analytic_charts')->oneYearPerPage();
<div id="oneYearPerPage" class="myGCharts"></div>
{{ chart(oneYearPerPage) }}

// one year pages views
$oneYearPages = $this->get('gkratz_analytic_charts')->oneYearPages();
<div id="oneYearPages" class="myGCharts"></div>
{{ chart(oneYearPages) }}

// 7 days by new or returning visitor
$sevenDaysPerUser = $this->get('gkratz_analytic_charts')->sevenDaysPerUser();
<div id="sevenDaysPerUser" class="myGCharts"></div>
{{ chart(sevenDaysPerUser) }}

// 7 days per country
$sevenDaysPerCountry = $this->get('gkratz_analytic_charts')->sevenDaysPerCountry();
<div id="sevenDaysPerCountry" class="myGCharts"></div>
{{ chart(sevenDaysPerCountry) }}

// 7 days per city
$sevenDaysPerCity = $this->get('gkratz_analytic_charts')->sevenDaysPerCity();
<div id="sevenDaysPerCity" class="myGCharts"></div>
{{ chart(sevenDaysPerCity) }}

// 7 days per language
$sevenDaysPerLanguage = $this->get('gkratz_analytic_charts')->sevenDaysPerLanguage();
<div id="sevenDaysPerLanguage" class="myGCharts"></div>
{{ chart(sevenDaysPerLanguage) }}

// 7 days per browser
$sevenDaysPerBrowser = $this->get('gkratz_analytic_charts')->sevenDaysPerBrowser();
<div id="sevenDaysPerBrowser" class="myGCharts"></div>
{{ chart(sevenDaysPerBrowser) }}

// 7 days per pages views
$sevenDaysPerPage = $this->get('gkratz_analytic_charts')->sevenDaysPerPage();
<div id="sevenDaysPerPage" class="myGCharts"></div>
{{ chart(sevenDaysPerPage) }}

// 7 days pages views
$sevenDaysPages = $this->get('gkratz_analytic_charts')->sevenDaysPages();
<div id="sevenDaysPages" class="myGCharts"></div>
{{ chart(sevenDaysPages) }}

// pie one year per country
$pieOneYearPerCountry = $this->get('gkratz_analytic_charts')->pieOneYearPerCountry();
<div id="pieOneYearPerCountry" class="myGCharts"></div>
{{ chart(pieOneYearPerCountry) }}

// pie one year per city
$pieOneYearPerCity = $this->get('gkratz_analytic_charts')->pieOneYearPerCity();
<div id="pieOneYearPerCity" class="myGCharts"></div>
{{ chart(pieOneYearPerCity) }}

// pie one year per language
$pieOneYearPerLanguage = $this->get('gkratz_analytic_charts')->pieOneYearPerLanguage();
<div id="pieOneYearPerLanguage" class="myGCharts"></div>
{{ chart(pieOneYearPerLanguage) }}

// pie one year per browser
$pieOneYearPerBrowser = $this->get('gkratz_analytic_charts')->pieOneYearPerBrowser();
<div id="pieOneYearPerBrowser" class="myGCharts"></div>
{{ chart(pieOneYearPerBrowser) }}

// pie one year per page
$pieOneYearPerPage = $this->get('gkratz_analytic_charts')->pieOneYearPerPage();
<div id="pieOneYearPerPage" class="myGCharts"></div>
{{ chart(pieOneYearPerPage) }}

// pie one week per country
$pieOneWeekPerCountry = $this->get('gkratz_analytic_charts')->pieOneWeekPerCountry();
<div id="pieOneWeekPerCountry" class="myGCharts"></div>
{{ chart(pieOneWeekPerCountry) }}

// pie one week per city
$pieOneWeekPerCity = $this->get('gkratz_analytic_charts')->pieOneWeekPerCity();
<div id="pieOneWeekPerCity" class="myGCharts"></div>
{{ chart(pieOneWeekPerCity) }}

// pie one week per language
$pieOneWeekPerLanguage = $this->get('gkratz_analytic_charts')->pieOneWeekPerLanguage();
<div id="pieOneWeekPerLanguage" class="myGCharts"></div>
{{ chart(pieOneWeekPerLanguage) }}

// pie one week per browser
$pieOneWeekPerBrowser = $this->get('gkratz_analytic_charts')->pieOneWeekPerBrowser();
<div id="pieOneWeekPerBrowser" class="myGCharts"></div>
{{ chart(pieOneWeekPerBrowser) }}

// pie one week per page
$pieOneWeekPerPage = $this->get('gkratz_analytic_charts')->pieOneWeekPerPage();
<div id="pieOneWeekPerPage" class="myGCharts"></div>
{{ chart(pieOneWeekPerPage) }}