iPVisitCounterType.php

Aller à la documentation de ce fichier.

<?php
class iPVisitCounterType extends eZWorkflowEventType
{
    const WORKFLOW_TYPE_STRING = "ipediatrevisitcounter";

    public function __construct()
    {
        parent::__construct(
            iPVisitCounterType::WORKFLOW_TYPE_STRING,
            'Update Visit Stats'
        );
    }

    public function execute( $process, $event )
    {
        $parameters = $process->attribute('parameter_list');
        $node_id    = $parameters['node_id'];

        $ini    = eZINI::instance();
        $user   = $ini->variable('DatabaseSettings', 'User');
        $passwd = $ini->variable('DatabaseSettings', 'Password');
        $host   = $ini->variable('DatabaseSettings', 'Server');
        $dbname = $ini->variable('DatabaseSettings', 'Database');

        $q =  ezcDbFactory::create( "mysql://{$user}:{$passwd}@{$host}/{$dbname}" )->createInsertQuery();

        $q->insertInto( 'ipediatre_visits' )
            ->set( 'node_id', $q->bindValue( $node_id ) )
            ->set( 'date', $q->bindValue( time() ) )
            ->set( 'session_id', $q->bindValue( session_id() ) );

        $stmt = $q->prepare();
        $stmt->execute();

        return eZWorkflowType::STATUS_ACCEPTED;
    }
}