View source
<?php
namespace Drupal\statistics\Plugin\migrate\destination;
use Drupal\Core\Database\Connection;
use Drupal\Core\Plugin\ContainerFactoryPluginInterface;
use Drupal\migrate\Plugin\migrate\destination\DestinationBase;
use Drupal\migrate\Plugin\MigrationInterface;
use Drupal\migrate\Row;
use Symfony\Component\DependencyInjection\ContainerInterface;
class NodeCounter extends DestinationBase implements ContainerFactoryPluginInterface {
protected $connection;
public function __construct(array $configuration, $plugin_id, $plugin_definition, MigrationInterface $migration, Connection $connection) {
parent::__construct($configuration, $plugin_id, $plugin_definition, $migration);
$this->connection = $connection;
}
public static function create(ContainerInterface $container, array $configuration, $plugin_id, $plugin_definition, MigrationInterface $migration = NULL) {
return new static($configuration, $plugin_id, $plugin_definition, $migration, $container
->get('database'));
}
public function getIds() {
return [
'nid' => [
'type' => 'integer',
],
];
}
public function fields() {
return [
'nid' => $this
->t('The ID of the node to which these statistics apply.'),
'totalcount' => $this
->t('The total number of times the node has been viewed.'),
'daycount' => $this
->t('The total number of times the node has been viewed today.'),
'timestamp' => $this
->t('The most recent time the node has been viewed.'),
];
}
public function import(Row $row, array $old_destination_id_values = []) {
$nid = $row
->getDestinationProperty('nid');
$daycount = $row
->getDestinationProperty('daycount');
$totalcount = $row
->getDestinationProperty('totalcount');
$timestamp = $row
->getDestinationProperty('timestamp');
$this->connection
->merge('node_counter')
->key('nid', $nid)
->fields([
'daycount' => $daycount,
'totalcount' => $totalcount,
'timestamp' => $timestamp,
])
->expression('daycount', '[daycount] + :daycount', [
':daycount' => $daycount,
])
->expression('totalcount', '[totalcount] + :totalcount', [
':totalcount' => $totalcount,
])
->expression('timestamp', 'CASE WHEN [timestamp] > :timestamp1 THEN [timestamp] ELSE :timestamp2 END', [
':timestamp1' => $timestamp,
':timestamp2' => $timestamp,
])
->execute();
return [
$row
->getDestinationProperty('nid'),
];
}
}