protected function formatCsvCell($row, $header)
{
if (($header == 'from' || $header == 'to' || $header == 'urt' || $header == 'notify_time') && $row) {
if (!empty($row["tzoffset"])) {
// TODO change this to regex; move it to utils
$tzoffset = $row['tzoffset'];
$sign = substr($tzoffset, 0, 1);
$hours = substr($tzoffset, 1, 2);
$minutes = substr($tzoffset, 3, 2);
$time = $hours . ' hours ' . $minutes . ' minutes';
if ($sign == "-") {
$time .= ' ago';
}
$timsetamp = strtotime($time, $row['urt']->sec);
$zend_date = new Zend_Date($timsetamp);
$zend_date->setTimezone('UTC');
return $zend_date->toString("d/M/Y H:m:s") . $row['tzoffset'];
} else {
$zend_date = new Zend_Date($row[$header]->sec);
return $zend_date->toString("d/M/Y H:m:s");
}
} else {
return parent::formatCsvCell($row, $header);
}
}
