1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
 
class FacebookFeedScrapper{
  private $clientId;
  private $appSecret;
 
  //Access token from graph
  private $accessToken;
 
  //should be the client sdk
  private $fb;
 
  public function __construct($clientId, $appSecret){
    $this->clientId = $clientId;
    $this->appSecret = $appSecret;
 
    $this->accessToken = $this->getAccessToken();
    $this->fb = new \Facebook\Facebook([
      'app_id' => $this->clientId,
      'app_secret' => $this->appSecret,
      'default_graph_version' => 'v2.7'
    ]);
  }
 
  private function getAccessToken() {
    $url = "https://graph.facebook.com/oauth/access_token?client_id="
    . $this->clientId
    . "&client_secret=" 
    . $this->appSecret 
    . "&grant_type=client_credentials";
 
    $str = file_get_contents($url);
 
    return  str_replace ("access_token=", "", $str);
  }
 
  public function getFeed($id, $since){
    try {
      return $this->fb->get($id."/feed?since=".$since, $this->accessToken);
    } catch(\Facebook\Exceptions\FacebookResponseException $e) {
      throw new \Exception('Graph returned an error: ' . $e->getMessage());
    } catch(\Facebook\Exceptions\FacebookSDKException $e) {
      throw new \Exception('Facebook SDK returned an error: ' . $e->getMessage());
    }
  }
}

1
2
 
return $this->fb->get($id."/feed?since=".$since, $this->accessToken);

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
$feedScrapper = new FacebookFeedScrapper(
  "your-app-key", 
  "your-secret-key"
);
 
$groupId = “the-group-ID”;
 
try {
  $feeds = $feedScrapper->getFeed($groupId, date("Y-m-d", strtotime("-1 week +1 day")))->getDecodedBody()['data'];
} catch(\Exception $e) {
  throw new \Exception($e->getMessage());
}
 
echo "<pre>";
print_r($feeds);

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
 
<?php
require_once __DIR__ . '/vendor/autoload.php';
 
class FacebookFeedScrapper{
  private $clientId;
  private $appSecret;
 
  //Access token from graph
  private $accessToken;
 
  //should be the client sdk
  private $fb;
 
  public function __construct($clientId, $appSecret){
    $this->clientId = $clientId;
    $this->appSecret = $appSecret;
 
    $this->accessToken = $this->getAccessToken();
    $this->fb = new \Facebook\Facebook([
      'app_id' => $this->clientId,
      'app_secret' => $this->appSecret,
      'default_graph_version' => 'v2.7'
    ]);
  }
 
  //Get the Access token
  //@todo change this with some official api
  private function getAccessToken() {
    $url = "https://graph.facebook.com/oauth/access_token?client_id="
    . $this->clientId
    . "&client_secret=" 
    . $this->appSecret 
    . "&grant_type=client_credentials";
 
    $str = file_get_contents($url);
 
    return  str_replace ("access_token=", "", $str);
  }
 
  public function getFeeds($id, $since){
    try {
      return $this->fb->get($id."/feed?since=".$since, $this->accessToken);
    } catch(\Facebook\Exceptions\FacebookResponseException $e) {
      throw new \Exception('Graph returned an error: ' . $e->getMessage());
    } catch(\Facebook\Exceptions\FacebookSDKException $e) {
      throw new \Exception('Facebook SDK returned an error: ' . $e->getMessage());
    }
  }
}
 
$groupId = “the-group-ID”;
$feedScrapper = new FacebookFeedScrapper(
  "your-app-key", 
  "your-secret-key"
);
 
try {
  $feeds = $feedScrapper->getFeeds($groupId, date("Y-m-d", strtotime("-1 week +1 day")))->getDecodedBody()['data'];
} catch(\Exception $e) {
  throw new \Exception($e->getMessage());
}
 
echo "<pre>";
print_r($feeds);

php importFeed.php

1
2
3
4
5
6
7
8
9
$directions = [ 
    'knight' => [[2, 1],[2, -1],[-2, 1],[-2, -1],[1, 2],[-1,2],[1,-2],[-1,-2]], 
    // pour la lettre a par exemple
    //a b c
    //b a v
    //c a b
    'plus' => [[0, 1],[-1, 0],[0, -1],[1, 0]], 
    'plus_and_coin' => [[0, 1],[-1, 0],[0, -1],[1, 0],[1, 1],[-1, 1],[1, -1],[-1, -1]] 
];

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
 
<?php
 
/**
 * Copyright (c) <2015>, Ghali Ahmed<ghaliano2005@gmail.com>
 *
 * All rights reserved.
 * Redistribution and use in source and binary forms, with or without modification,
 * are permitted provided that the following conditions are met:
 * 1. Redistributions of source code must retain the above copyright notice,
 * this list of conditions and the following disclaimer.
 * 2. Redistributions in binary form must reproduce the above copyright notice,
 * this list of conditions and the following disclaimer in the documentation and/or
 * other materials provided with the distribution.
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
 * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
 * IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
 * INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
 * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
 * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * This class find similarity for given cel on 2D array
 * the search strategie can be easly modified with the given direction
 * @Exemple: when the given direction array is: [[0, 1],[-1, 0],[0, -1],[1, 0]]
 * the script will look recursively to the right, top, bottom, left, right of the given cel
 * @author Ghali Ahmed<ghaliano2005@gmail.com>
 * @version 1.0
 */
class MathMatrixHelper
{
    protected $atomes = [];
 
    protected $tile = [];
 
    protected $visited = [];
 
    protected $tileDim = 20;
 
    private $maxNest;
 
    /**
     * Direction to find friend cell
     */
    protected $directions = [];
 
    public function __construct($atomes, $directions, $tileDim)
    {
        $this->atomes = $atomes;
        $this->directions = $directions;
        $this->tileDim = $tileDim;
        $this->maxNest = ini_set('xdebug.max_nesting_level', 0);
        $this->init();
    }
 
    public function init()
    {
        $i = 0;
        while ($i < $this->tileDim) {
            $j = 0;
            $this->tile[$i] = [];
            while ($j < $this->tileDim) {
                $this->tile[$i][$j] = $this->atomes[array_rand($this->atomes)];
                $this->visited[$i][$j] = [];
                $j++;
            }
            $i++;
        }
    }
 
    public function getAllConnexion($i, $j, &$result = [])
    {
        foreach ($this->directions as $key => $direction) {
            $iTarget = $i + $direction[0];
            $jTarget = $j + $direction[1];
 
            if (isset($this->tile[$iTarget][$jTarget])) {
                if (($this->tile[$i][$j] == $this->tile[$iTarget][$jTarget])
                    && !isset($this->visited[$i][$j][$key])
                    && !isset($this->visited[$iTarget][$jTarget][$key])) {
                    $result[] = "$i:$j";
                    $this->visited[$i][$j][$key] = true;
 
                    $this->getAllConnexion($iTarget, $jTarget, $result);
                }
            }
        }
 
        return $result;
    }
 
    /**
     * Search for connexion in regular mode until there length reached the max value
     * @var $m x0
     * @var $n y0
     */
    public function getRegularConnexion($m, $n, $max, $onlyFirst=false) 
	{
		$result = [];
		$len = count($this->tile);
		foreach ($this->directions as $key => $direction) {
			if (!isset($result[$key])) {
				$result[$key] = [];
			} 
			for ($i = 0; $i < $len; $i++) {
				$iTarget = $m + $i*$direction[0];
				$jTarget = $n + $i*$direction[1];
					if ($this->tile[$m][$n] != @$this->tile[$iTarget][$jTarget]) {
					break;
				} else {
					$result[$key][] = "$iTarget:$jTarget";
					if ($onlyFirst && (count($result[$key]) == $max)) {
						return $result[$key];
					}
				}
			}
            if (!$onlyFirst && count($result[$key]) <$max) {
                $result[$key] = [];
            }
		};
 
		return $this->flatten($result);
	}
 
    /**
     * Print array like a matrix
     * and display connexion with special color
     */
    public function printTile($result, $m, $n)
    {
        $linePattern = "[%s]<br />";
        $itemPattern = "%s<span style='%s'>%s</span>";
        $output = "";
        for ($i = 0; $i<$this->tileDim; $i++) {
            $sep = '';
            $j = 0;
            $str = '';
            for ($j = 0; $j<$this->tileDim; $j++) {
                $in = in_array("$i:$j", $result);
                $from = $i == $m && $j == $n;
                $str .= sprintf($itemPattern, $sep, ($in ? 'color: red; font-weight: bold;' : '').($from ? 'border: 1px solid;' : ''), @$this->tile[$i][$j]);
                $sep = ',';
            }
            $output .= sprintf($linePattern, $str);
        }
 
        print '<pre>'.$output.'</pre>';
    }
 
    public function __destruct()
    {
        if (!empty($this->maxNest)) {
            ini_set('xdebug.max_nesting_level', $this->maxNest);
        }
    }
 
    /**
     * Thnaks to http://stackoverflow.com/users/28835/too-much-php
     * http://stackoverflow.com/questions/1319903/how-to-flatten-a-multidimensional-array
     */
    protected function flatten(array $array) 
    {
        $return = array();
        array_walk_recursive($array, function($a) use (&$return) { $return[] = $a; });
 
        return $return;
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
<?php
include('matrix.php');
 
$letters = ['a', 'b', 'c', 'd'];
$directions = [
	'knight' => [[2, 1],[2, -1],[-2, 1],[-2, -1],[1, 2],[-1,2],[1,-2],[-1,-2]],
	'plus' => [[0, 1],[-1, 0],[0, -1],[1, 0]],
	'plus_and_coin' => [[0, 1],[-1, 0],[0, -1],[1, 0],[1, 1],[-1, 1],[1, -1],[-1, -1]]
];
 
$strategie = 'plus_and_coin';
 
$matrix = new MathMatrixHelper($letters, $directions[$strategie], 20);
print '<b>getAllConnexion:</b><br>';
$startTime = microtime(true);
$result = $matrix->getAllConnexion(6, 6);
$matrix->printTile($result, 6, 6);
 
print '<b>getRegularConnexion:</b><br>';
$result = $matrix->getRegularConnexion(6, 6, 5, true);
$matrix->printTile($result, 6, 6);
$endTime = microtime(true);
echo "Execution time : " . ($endTime - $startTime) . " seconds<br/><br/>";

php bin/console generate:doctrine:form AppBundle:User

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
 
<?php
 
namespace AppBundle\Form;
 
use Symfony\Component\Form\AbstractType;
use Symfony\Component\Form\FormBuilderInterface;
use Symfony\Component\OptionsResolver\OptionsResolver;
 
class UserType extends AbstractType
{
    /**
     * @param FormBuilderInterface $builder
     * @param array $options
     */
    public function buildForm(FormBuilderInterface $builder, array $options)
    {
        $builder
            ->add('name')
        ;
    }
 
    /**
     * @param OptionsResolver $resolver
     */
    public function configureOptions(OptionsResolver $resolver)
    {
        $resolver->setDefaults(array(
            'data_class' => 'AppBundle\Entity\User'
        ));
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
use Symfony\Component\Form\Extension\Core\Type\TextType;
use AppBundle\Entity\User;
use AppBundle\Form\UserType;
   …….
   …….
    /**
     * @Route("/user/new", name="user_new")
     */
    public function newAction(Request $request)
    {
        $user = new User();
 
        $form = $this->createForm(UserType::class, $user);
 
        return $this->render('AppBundle:user:new.html.twig', array(
            'form' => $form->createView(),
        ));
    }

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
<div class="modal-header">
	<button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
	<h4 class="modal-title">Ajouter un utilisateur</h4>
</div>
 
<form method="post" action="{{path('user_create')}}" class="user-create-form">
	<div class="modal-body">
		{{form_widget(form)}}
	</div>
	<div class="modal-footer">
	    <button type="button" class="btn btn-default" data-dismiss="modal">fermer</button>
	    <button type="submit" class="btn btn-primary">Enregistrer</button>
	</div>
</form>
 
<script>
        $('.user-create-form').submit(function(e) {
                e.preventDefault();
            $(this).ajaxSubmit({
                dataType: 'json',
                success: function(result){
                        if (result.status == 'ok'){
                                userTable.ajax.reload();
                                $('#myModal').modal('hide');
                        }
                }
            });
            return false;
        }); 
</script>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
 
<html>
	<head>
		{%block css%}
		    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
 
		    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">
 
		    <link rel="stylesheet" href="https://cdn.datatables.net/1.10.6/css/jquery.dataTables.min.css" />
		    <link rel="stylesheet" href="https://cdn.datatables.net/1.10.12/css/dataTables.bootstrap.min.css" />
		    <style type="text/css">
 
                    </style>
		{% endblock %}
	</head>
</html>
 
<body cz-shortcut-listen="true">
    <nav class="navbar navbar-inverse navbar-fixed-top">
      <div class="container-fluid">
        <div class="navbar-header">
          <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
            <span class="sr-only">Toggle navigation</span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
          </button>
          <a class="navbar-brand" href="#">dataTable exemple</a>
        </div>
        {% block actions %}
        {% endblock %}
      </div>
    </nav>
 
    <div class="container-fluid">
      <div class="row">
        <div class="col-sm-12 main">
        	<br />
    			{% block body %}
    			{% endblock %}
          </div>
        </div>
      </div>
    </div>
 
    <!-- /.modal source code -->
    <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content"></div>
        </div>
    </div>
</body>
 
{% block javascript %}
    <script src="https://code.jquery.com/jquery-1.11.2.min.js"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
    <script src="https://cdn.datatables.net/1.10.6/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.10.12/js/dataTables.bootstrap.min.js"></script>
    <script type="text/javascript" src="http://malsup.github.io/min/jquery.form.min.js"></script>
{% endblock %}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
 
{% extends "AppBundle::base.html.twig" %}
 
{% block actions %}
    <ul class="nav navbar-nav navbar-right">
      <li><a class="btn btn-link user-add-btn" href="{{ path('user_new') }}"><i class="glyphicon glyphicon-plus"></i> Ajouter</a></li>
    </ul>
{% endblock %}
 
{% block body %}
    <h1 class="page-header">Liste des utilisateurs</h1>
    <table id="user-list" class="table table-striped"></table>
{% endblock %}
 
{% block javascript %}
    {{ parent() }}
 
    <script>
        var userTable;
        $(function() {
           //C'est le bouton qui affiche la popup, et charge aussi le formulaire dans cette dernière.
            $('.user-add-btn').click(function(e) {
                $.get(e.currentTarget.href, function(html){
                    $('#myModal .modal-content').html(html);
                    $('#myModal').modal('show');
                });
                e.preventDefault();
            });
 
              userTable = $('#user-list').DataTable({
                "processing": true,
                "serverSide": true,
                "ajax": "{{ path('user_paginate') }}",
                "sAjaxDataProp": "data",
                "pageLength": 10,
                "columns":[
                    {"data": "id"},
                    {"data": "name"},
                    {"data": "created_at"}
                ]
            });
        });
    </script>
{% endblock %}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
    /**
     * @Route("/user/create", name="user_create")
     */
    public function createAction(Request $request)
    {
        $user = new User();
 
        $form = $this->createForm(UserType::class, $user);
 
        $form->handleRequest($request);
 
        if ($form->isSubmitted() && $form->isValid()) {
            dump($form->getData());
            die;
        }
    }

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
 
<?php
 
namespace AppBundle\Entity;
 
use Doctrine\ORM\Mapping as ORM;
 
/**
 * User
 *
 * @ORM\Entity(repositoryClass="AppBundle\Repository\UserRepository")
 * @ORM\Table(name="users")
 */
class User
{
    /**
     * @var integer
     *
     * @ORM\Column(name="id", type="integer", nullable=false)
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="IDENTITY")
     */
    private $id;
 
    /**
     * @var string
     *
     * @ORM\Column(type="string")
     */
    private $name;
 
    /**
     * @var string
     *
     * @ORM\Column(type="datetime")
     */
    private $createdAt;
 
    public function __construct()
    {   
        $this->createdAt = new \dateTime('now');
    }
 
    public function getId() 
    {
        return $this->id;
    }
 
    public function getName() 
    {
        return $this->name;
    }
 
    public function getCreatedAt() 
    {
        return $this->createdAt;
    }
 
    public function setName($name) 
    {
        $this->name = $name;
 
        return $this;
    }
 
    public function setCreatedAt($createdAt) 
    {
        $this->createdAt = $createdAt;
 
        return $this;
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 
    /**
     * @Route("/user/create", name="user_create")
     */
    public function createAction(Request $request)
    {
        $user = new User();
 
        $form = $this->createForm(UserType::class, $user);
 
        $form->handleRequest($request);
 
        if ($form->isSubmitted() && $form->isValid()) {
            $em = $this->getDoctrine()->getManager();
            $em->persist($user);
            $em->flush();
 
            return new JsonResponse(['status' => 'ok']);
        } else {
            return new JsonResponse(['status' => 'ko']);
        }
    }

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
<?php
 
date_default_timezone_set('America/New_York');
$limit = intval($_GET['limit']);
 
// Find a randomDate between $start_date and $end_date
//from http://stackoverflow.com/questions/1972712/generate-random-date-between-two-dates-using-php
function randomDate($start_date, $end_date)
{
    // Convert to timetamps
    $min = strtotime($start_date);
    $max = strtotime($end_date);
 
    // Generate random number using above bounds
    $val = rand($min, $max);
 
    // Convert back to desired date format
    return date('Y-m-d H:i', $val);
}
 
//Sports categories
$groupsData = array(
	array("id" => 1, "content" => 'Football'),
	array("id" => 2, "content" => 'Handball'),
	array("id" => 3, "content" => 'Criquet'),
	array("id" => 4, "content" => 'Natation'),
	array("id" => 5, "content" => 'basketball'),
	array("id" => 6, "content" => 'Tenis de table'),
	array("id" => 7, "content" => 'Cyclisme'),
	array("id" => 8, "content" => 'F1')
);
 
//The same service return both groups and item
$result = array(
	"groups" => $groupsData,
	"items" => array() 
);
 
for ($i=0; $i<$limit; $i++) {
	$result['items'][] = [
		"id" => $i+1, 
		"group" => $groupsData[array_rand($groupsData)]['id'], 
		"content" => "Event".$i, 
		"start" => randomDate('2016-09-01', '2016-10-20')
	];
}
 
 
header('Content-Type: application/json');
echo json_encode($result);

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
var clusteriser = function(timeline){
	this.timeline = timeline;
 
	this.getDiffDate = function(date1, date2){
		var second=1000;
		var minute = second*60;
		var hour = minute*60;
		var day = hour*24;
		var month = day*31;
		var year = month*12;
 
		// Convert both dates to milliseconds
		var diff = date2.getTime() - date1.getTime();
 
		// Convert back to components and return
		return {
			years: Math.round(diff/year),
			months: Math.round(diff/month),
			days: Math.round(diff/day),
			hours: Math.round(diff/hour),
			minutes: Math.round(diff/minute)
		};
	}
 
	//Get the scale between two date
	//We can use the scale information from timeline api in order to know how to cluster data
	this.getScale = function(start, end) {	
		var diff = this.getDiffDate(start, end);
 
		if (diff.months > 12*2) {
			return 'year';
		}
		else if (diff.days >31) {
			return 'month';
		}
		else if (diff.hours >24) {
			return 'day';
		}
		else if (diff.minutes >60) {
			return 'hour';
		}
		else {
			return 'second';
		}
	}
 
	this.getClusters = function(dataItems){
		var timelineWindow = this.timeline.getWindow();
 
		var scale = this.getScale(timelineWindow.start, timelineWindow.end);
 
	    var group = _.toArray(_.groupBy(dataItems, 'group'));;
		var result = {};
 
		var formatByScale = {
			year: 'Y',
			month: 'Y-M',
			weekday: 'Y-M-week-W',
			day: 'Y-M-day-D',
			hour: 'Y-M-D-H',
			second: 'Y-M-D-H-m'
		};
 
		group.forEach(function(items, i){
			items.forEach(function(item, j){
				var index = moment(item.start).format(formatByScale[scale]) + '-group' + item.group;
 
				if (!result[index]){
					result[index] = {
						count: 1,
						items: [],
						group: item.group,
						start: item.start
					};
				}
 
				result[index].items.push(item);
				result[index].count++;
			})
		});
 
		return _.toArray(result);
	}
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
<!DOCTYPE HTML>
<html>
  <head>
    <title>Timeline | Clustering demo</title>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js"></script>
    <script src="http://underscorejs.org/underscore-min.js"></script>
    <script src="http://momentjs.com/downloads/moment.min.js"></script>
    <script src="http://visjs.org/dist/vis.js"></script>
    <script src="clusteriser.js"></script>
    <link href="http://visjs.org/dist/vis.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
* {
  font-size: 12px;
}
    </style>
  </head>
  <body>
    <button class="zoom" data-dir="1">Zomm in</button>
    <button class="zoom" data-dir="-1">Zoom out</button>
 
    <div id="visualization"></div>
 
    <script type="text/javascript">
      var timeline = false;
 
      $.getJSON('data.php?limit=1000', function(jsonResponse){
          var groups = jsonResponse['groups'];
          var items = jsonResponse['items'];
 
          if (!timeline){
            timeline = new vis.Timeline(
              document.getElementById('visualization'), 
              [], 
              groups, 
              {
                template: function (item) {
                  return item.count?("<span>"+item.count+" évenement"+((item.count>1)?'s':'')+"</span>"):item.content; 
 
                }
              }
            );
 
           var clusters = new clusteriser(timeline);
            timeline.setItems(clusters.getClusters(items));
 
            timeline.on('rangechanged', function(){
              timeline.setItems(clusters.getClusters(items));
            });          }
        }
      );
 
      $(".zoom").on("click", function(){
          var dir = $(this).data('dir');
          var range = timeline.getWindow();
          var interval = range.end - range.start;
 
          timeline.setWindow({
              start: range.start.valueOf() - interval * dir * 0.2,
              end:   range.end.valueOf()   + interval * dir * 0.2
          });
      })
 
    </script>
  </body>
</html>

{% set _is_rtl = app.request.getLocale() in ['ar', 'arc', 'bcc', 'bqi', 'ckb', 'dv', 'fa', 'glk', 'he', 'ku', 'mzn', 'pnb', 'ps', 'sd', 'ug', 'ur', 'yi'] %}

1
2
3
4
5
6
7
8
9
10
11
{% set stylesheets = admin_pool.getOption('stylesheets', []) %}
{% if _is_rtl %}
{% set stylesheets = stylesheets|merge(['bundles/mydemo/css/AdminLTE-rtl.css']) %}
{% endif %}
 
{% block stylesheets %}
    {% for stylesheet in stylesheets %}
        <link rel="stylesheet" href="{{ asset(stylesheet) }}">
    {% endfor %}
{% endblock %}
{% block body_attributes %}{{ parent() }} {{ _is_rtl?'dir="rtl"':'' }} {% endblock %}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<?php
 
namespace Acme\DemoBundle\Entity;
 
use Doctrine\ORM\Mapping as ORM;
 
/**
 * User
 *
 * @ORM\Entity(repositoryClass="Acme\DemoBundle\Repository\UserRepository")
 * @ORM\Table(name="users")
 */
class User
{
    /**
     * @var integer
     *
     * @ORM\Column(name="id", type="integer", nullable=false)
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="IDENTITY")
     */
    private $id;
 
    /**
     * @var string
     *
     * @ORM\Column(type="string")
     */
    private $name;
 
    /**
     * @var string
     *
     * @ORM\Column(type="datetime")
     */
    private $createdAt;
 
    public function __construct()
    {   
        $this->createdAt = new \dateTime('now');
    }
 
    public function getId() 
    {
        return $this->id;
    }
 
    public function getName() 
    {
        return $this->name;
    }
 
    public function getCreatedAt() 
    {
        return $this->createdAt;
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
{% extends "AcmeDemoBundle::layout.html.twig" %}
 
{% block head %}
{{ parent() }}
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.6/css/jquery.dataTables.min.css" />
<script src="https://code.jquery.com/jquery-1.11.2.min.js"></script>
<script src="https://cdn.datatables.net/1.10.6/js/jquery.dataTables.min.js"></script>
<script>
$(function() {
  $('#user-list').DataTable({
        "processing": true,
        "serverSide": true,
        "ajax": "{{ path('user_paginate') }}",
        "sAjaxDataProp": "data",
        "pageLength": 10,
        "columns":[
            {"data": "id"},
            {"data": "name"},
            {"data": "created_at"}
        ]
    });
});
</script>
{% endblock %}
 
{% block body %}
 
<table id="user-list">
    <thead>
        <tr>
            <th>ID</th>
            <th>Nom</th>
            <th>Crée le</th>
        </tr>
    </thead>
    <tbody>
    </tbody>
</table>
{% endblock %}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
<?php
 
namespace Acme\DemoBundle\Controller;
 
use Symfony\Bundle\FrameworkBundle\Controller\Controller;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
 
class UserController extends Controller
{
    /**
     * @Route("/list", name="user_list")
     */
    public function indexAction()
    {
        return  $this->render('AcmeDemoBundle:User:index.html.twig',array());  
    }
 
    /**
     * @Route("/paginate", name="user_paginate")
     */
    public function paginateAction(Request $request)
    {
        $length = $request->get('length');
        $length = $length && ($length!=-1)?$length:0;
 
        $start = $request->get('start');
        $start = $length?($start && ($start!=-1)?$start:0)/$length:0;
 
        $search = $request->get('search');
        $filters = [
            'query' => @$search['value']
        ];
 
        $users = $this->getDoctrine()->getRepository('AcmeDemoBundle:User')->search(
            $filters, $start, $length
        );
 
        $output = array(
            'data' => array(),
            'recordsFiltered' => count($this->getDoctrine()->getRepository('AcmeDemoBundle:User')->search($filters, 0, false)),
            'recordsTotal' => count($this->getDoctrine()->getRepository('AcmeDemoBundle:User')->search(array(), 0, false))
        );
 
        foreach ($users as $user) {
            $output['data'][] = [
                'id' => $user->getId(),
                'name' => $user->getName(),
                'created_at' => $user->getCreatedAt()->format('Y-m-d'),
            ];
        }
 
        return new Response(json_encode($output), 200, ['Content-Type' => 'application/json']);
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
<?php
namespace Acme\DemoBundle\Repository;
 
use Doctrine\ORM\EntityRepository;
 
class UserRepository extends EntityRepository
{
    public function search($data, $page = 0, $max = NULL, $getResult = true)
    {
        $qb = $this->_em->createQueryBuilder();
        $query = isset($data['query']) && $data['query']?$data['query']:null;
 
        $qb
            ->select('u')
            ->from('AcmeDemoBundle:User', 'u')
        ;
 
        if ($query) {
            $qb
                ->andWhere('u.name like :query')
                ->setParameter('query', "%".$query."%")
            ;
        }
 
        if ($max) {
            $preparedQuery = $qb->getQuery()
                ->setMaxResults($max)
                ->setFirstResult($page * $max)
            ;
        } else {
            $preparedQuery = $qb->getQuery();
        }
 
        return $getResult?$preparedQuery->getResult():$preparedQuery;
    }
}