From 0fefbf7fbfb6a3ecec330ee7bdb369894249bd80 Mon Sep 17 00:00:00 2001 From: jitendrapurohit Date: Fri, 8 Jan 2016 18:53:08 +0530 Subject: [PATCH] warning fixes --- CRM/Report/Form.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/CRM/Report/Form.php b/CRM/Report/Form.php index 777b75a9ff..c3a2cb6f84 100644 --- a/CRM/Report/Form.php +++ b/CRM/Report/Form.php @@ -4482,12 +4482,13 @@ LEFT JOIN civicrm_contact {$field['alias']} ON {$field['alias']}.id = {$this->_a } } - /* + /** * CRM-17793 - Alter DateTime section header to group by date from the datetime field. * @param $tempTable * @param $columnName */ public function alterSectionHeaderForDateTime($tempTable, $columnName) { + // add new column with date value for the datetime field $tempQuery = "ALTER TABLE {$tempTable} ADD COLUMN {$columnName}_date VARCHAR(128)"; CRM_Core_DAO::executeQuery($tempQuery); $updateQuery = "UPDATE {$tempTable} SET {$columnName}_date = date({$columnName})"; -- 2.25.1