tasks assignment email - date = GMT

[mikesolomon]

When a task is assigned to a user sugar sends an email

The date & time on the email is in GMT

Is there any way to change this so it reports in local time?

[andopes]

Hi, Mike

It is possible.

If you take a look at the function set_notification_body in the modules/Tasks/Task.php you will see it set the GMT date time in the notification email.
You can define a controller for the Task which defines the bean to be called in the save process.
You can create a new class which extends the Task and override that function converting the date and time to local time.

Cheers

[mikesolomon]

Hi, Mike

It is possible.

If you take a look at the function set_notification_body in the modules/Tasks/Task.php you will see it set the GMT date time in the notification email.
You can define a controller for the Task which defines the bean to be called in the save process.
You can create a new class which extends the Task and override that function converting the date and time to local time.

Cheers

Andre thanks

I've done a quick fix in Tasks.php

$query = "SELECT CONVERT_TZ(date_due,'GMT','GB') AS duedate from tasks where id = '$this->id'";
$result =$this->db->query($query,true, $app_strings['ERR_CREATING_FIELDS']);
$row = $this->db->fetchByAssoc($result);
		
$xtpl->assign("TASK_SUBJECT", $task->name);
//MFH #13507
$xtpl->assign("TASK_PRIORITY", (isset($task->priority)?$app_list_strings['task_priority_dom'][$task->priority]:""));
#$xtpl->assign("TASK_DUEDATE", $task->date_due . " " . $task->time_due); #MJS CHANGE
$xtpl->assign("TASK_DUEDATE", $row['duedate']); #MJS CHANGE

Now I just need a way of making it upgrade safe

Also where is the template for the email held?

[andopes]

Hi Mike.

Take a look at my previous post:

You can define a controller for the Task which defines the bean to be called in the save process.
You can create a new class which extends the Task and override that function converting the date and time to local time.

This suggestion is the upgrade safe solution.
If you don't know how to do this, please let me know.

Cheers

[mikesolomon]

Andre

Thanks

Nope don't know how to do it

[andopes]

Hi Mike.

This is the content of the controller:

 require_once('include/MVC/Controller/SugarController.php');
require_once('modules/Tasks/CustomTask.php');
 
class TaskController extends SugarController {
    function action_save() {
        $this->bean = new CustomTask();
        $this->bean->save(!empty($this->bean->notify_on_save));
    }
} 
  

The class CustomTask will override the function the perform the necessary changes.

Cheers

[mikesolomon]

Hi Mike.

This is the content of the controller:

 require_once('include/MVC/Controller/SugarController.php');
require_once('modules/Tasks/CustomTask.php');
 
class TaskController extends SugarController {
    function action_save() {
        $this->bean = new CustomTask();
        $this->bean->save(!empty($this->bean->notify_on_save));
    }
} 
  

The class CustomTask will override the function the perform the necessary changes.

Cheers

Andre

Sorry still confused

Does this code go into a new file?

If so where should it go and what should it be called

[mikesolomon]

Hi Mike.

This is the content of the controller:

 require_once('include/MVC/Controller/SugarController.php');
require_once('modules/Tasks/CustomTask.php');
 
class TaskController extends SugarController {
    function action_save() {
        $this->bean = new CustomTask();
        $this->bean->save(!empty($this->bean->notify_on_save));
    }
} 
  

The class CustomTask will override the function the perform the necessary changes.

Cheers

Can anyone tell me where this code should go?

[andopes]

Hi Mike.

This code is the content of the file to be created: custom/modules/Tasks/controller.php

The CustomTask class is a class which extends Task.
This class will override the method adjust the GMT date.
You need to create this class too.

Cheers

[mikesolomon]

Hi Mike.

This code is the content of the file to be created: custom/modules/Tasks/controller.php

The CustomTask class is a class which extends Task.
This class will override the method adjust the GMT date.
You need to create this class too.

Cheers

Andre thanks

I had just created it as you posted this

Getting an error message Fatal error: Call to a member function setup() on a non-object in /srv/www/ivycrm_dev/include/MVC/Controller/ControllerFactory.php on line 59

Probably something I have done wrong

Thanks again for all the help