intec/tracker

dev-master 2018-04-23 13:27 UTC

Requires

• intec/session: dev-master
• intec/simple-router: dev-master

MIT

• Márcio Dias

README

Biblioteca em php para rastreio de navegação de usuários.

Como utilizar

Definir variáveis de ambiente

<?php
putenv('MODE=dev');

putenv('DB_TRACKER_HOST=localhost');
putenv('DB_TRACKER_NAME=tracker_db');
putenv('DB_TRACKER_USER=root');
putenv('DB_TRACKER_PASS=root');
putenv('DB_TRACKER_CHARSET=utf8mb4');

Criar tabelas

CREATE TABLE client_info (
    id int auto_increment primary key,
    session_id varchar(100) not null,
    ip varchar(30) default null,
    server_name varchar(100) default null,
    server_port int default null,
    server_request_uri varchar(300) default null,
    server_software varchar(100) default null,
    request_method varchar(20) default null,
    http_cookie varchar(1000) default null,
    user_agent varchar(200) default null,
    remote_addr varchar(100) default null,
    remote_port varchar(100) default null,
    session_values varchar(300) default null,
    reg_date timestamp not null default CURRENT_TIMESTAMP
);

CREATE TABLE adwords (
	id int auto_increment primary key,
    session_id varchar(100) not null,
    campaignid varchar(255) default null,
    adgroupid varchar(255) default null,
    feeditemid varchar(255) default null,
    targetid varchar(255) default null,
    loc_physical_ms varchar(255) default null,
    matchtype varchar(255) default null,
    network varchar(255) default null,
    device varchar(255) default null,
    devicemodel varchar(255) default null,
    keyword varchar(255) default null,
    placement varchar(255) default null,
    adposition varchar(255) default null,
    reg_date timestamp not null default CURRENT_TIMESTAMP
);

create table mouse_move (
  	id int auto_increment primary key,
  	session_id varchar(100) not null,
  	x int not null,
  	y int not null,
  	element varchar(300) not null,
    screen varchar(100) default null,
    height int default null,
    width int default null,
    pathname varchar(300) default null,
    contentId varchar(300) default null,
    reg_date timestamp not null default CURRENT_TIMESTAMP
);

alter table client_info modify column server_request_uri varchar(1000);

Adicionar o middleware no EntryPoint do projeto. Ex:

// index.php
// Rastreio de ações do usuário
SimpleRouter::setDefaultMiddlewares([function($request) {
    TrackerMiddleware::userTracker($request);
}]);

Rotas específicas (rastreio do mouse e heatmap)

// index.php
// Rotas do Tracker, adicione após o método SimpleRouter::setRoutes
SimpleRouter::addRoutes(TrackerRouteContainer::getRoutes());