<?php

/**
 * @inheritdoc
 */
class CRM_PivotCache_GroupActivity extends CRM_PivotCache_AbstractGroup {

  public function __construct($name = NULL, $source = NULL) {
    parent::__construct('Activity', $source);
  }

  /**
   * @inheritdoc
   */
  protected function customizeQuery(CRM_PivotReport_DAO_PivotReportCache $queryObject, $page, array $params) {
    if (!empty($params['keyvalue_from'])) {
      $whereStartDate = CRM_Core_DAO::createSQLFilter(
        // Remove the unique suffix added to the path.
        'LEFT(path, LENGTH(path) - 14)',
        array(
          '>=' => $this->getPath(substr($params['keyvalue_from'], 0, 10), $page, FALSE),
        ),
        'String'
      );

      $queryObject->whereAdd($whereStartDate);
    }

    if (!empty($params['keyvalue_to'])) {
      $whereEndDate = CRM_Core_DAO::createSQLFilter(
      // Remove the unique suffix added to the path.
        'LEFT(path, LENGTH(path) - 14)',
        array(
          '<=' => $this->getPath(substr($params['keyvalue_to'], 0, 10), 999999, FALSE),
        ),
        'String'
      );

      $queryObject->whereAdd($whereEndDate);
    }
  }
}