Making the Date fields go Orange/Red

[DanBrown]

Hi All,

I would like to know how to make the Date fields go orange/red when the date they are set to passes, just like the date fields in the call and meeting schedules.

I am using sugar 5.2.0k, and would like to implement this function on some custom date fields I have created.

Any assistance is much appreciated.

Thanks.

[mikesolomon]

Hi All,

I would like to know how to make the Date fields go orange/red when the date they are set to passes, just like the date fields in the call and meeting schedules.

I am using sugar 5.2.0k, and would like to implement this function on some custom date fields I have created.

Any assistance is much appreciated.

Thanks.

Look at modules/Tasks/Task.php

function get_list_view_data

[andopes]

Look at modules/Tasks/Task.php

function get_list_view_data

Actually you need to create a logic_hook process_record in order to implement that in an upgrade safe way.
But Mike is right, you can implement into logic_hook a similar code found on modules/Tasks/Task.php

Regards

[mikesolomon]

Actually you need to create a logic_hook process_record in order to implement that in an upgrade safe way.
But Mike is right, you can implement into logic_hook a similar code found on modules/Tasks/Task.php

Regards

Andre will doing it as a logic_hook also work for dashlets?

[andopes]

Andre will doing it as a logic_hook also work for dashlets?

Definitely!
The logic_hook process_record is called on Subpanels, Dashlets and ListView.

Cheers

[lachmac]

Look at modules/Tasks/Task.php

function get_list_view_data

Could you post the code snippet of rthe "logic hook" version? I have been trying this out, but unsuccesful, sofar...

Thanks!

[mikesolomon]

Could you post the code snippet of rthe "logic hook" version? I have been trying this out, but unsuccesful, sofar...

Thanks!

My logic_hook

<?php
require_once('data/SugarBean.php');
require_once('include/utils.php');

class zz_css_casePR {
	function zz_css_casePR (&$bean, $event, $arguments)
	{
	global $timedate;
	$date_db = $timedate->to_db_date($bean->target . ' 23:59');
		$today=date("Y-m-d");
		
		if( $date_db < $today && $bean->status == 'Open'){
			$bean->target = "<font class='overdueTask'>".$bean->target ."</font>";
		} 
		
		if( $date_db == $today && $bean->status == 'Open'){
			$bean->target= "<font class='todaysTask'>".$bean->target."</font>"; #amber
		}
	
	}
}
?>