private static function PHPExcel_Worksheet_AutoFilter::_filterTestInPeriodDateSet in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet/AutoFilter.php \PHPExcel_Worksheet_AutoFilter::_filterTestInPeriodDateSet()

* Test if cell date value is matches a set of values defined by a set of months * *

Parameters

mixed $cellValue: * @param mixed[] $monthSet * @return boolean

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet/AutoFilter.php, line 433

Class

PHPExcel_Worksheet_AutoFilter

PHPExcel_Worksheet_AutoFilter

Code

private static function _filterTestInPeriodDateSet($cellValue, $monthSet) {

  //	Blank cells are always ignored, so return a FALSE
  if ($cellValue == '' || $cellValue === NULL) {
    return FALSE;
  }
  if (is_numeric($cellValue)) {
    $dateValue = date('m', PHPExcel_Shared_Date::ExcelToPHP($cellValue));
    if (in_array($dateValue, $monthSet)) {
      return TRUE;
    }
  }
  return FALSE;
}