Calulating time difference when I view a custom record

[chrislynch8]

Hi,

I am creating a new custom module. It will be used to keep track of server we have in a DC and what Clients are using them. I have an online date and the offline date should be 4 weeks later. I want a field "Weeks Online" that will show the number of weeks it has been online for.

How can I calulated this without editing the record. I have both dates filled in and only what to show the difference in the detail view. So a user clicks on the record and the "Weeks Online" field is updated?

Is there a logic hook that will execute when I click on the detail view or will a custom view.detail.php be required?

Rgds
Chris

[kbrill]

We need to know what version of SugarCRM you are running, CE or PRO/ENT

[sugarcane]

Based on what you are describing I would go with a custom view.detail.php and then push a value into the detailview metadata file.

[chrislynch8]

We need to know what version of SugarCRM you are running, CE or PRO/ENT

Hi Ken,

I'm running 5.2.0k Pr.

Rgds
Chris

[chrislynch8]

So I created a custom view.detail.php and I have code it that worked perfectly when testing in a logic hook. I getting the week number of one date and now and calulating the number of weeks from that..

 if(!empty($this->bean->fdc_date_online_one))
{
$week_online = date("W",strtotime($this->bean->fdc_date_online_one));
$week_now = date("W",time());
if($week_now < $week_online)
{
$weeks_online = ((52 - $week_online) + $week_now);
$this->bean->fdc_weeks_online_c = $weeks_onine;
}
$weeks_online = $week_now-  $week_online;
$this->bean->fdc_weeks_online_c = $weeks_onine; 
  

When the had the above code in a Logic Code it was giving me the Week Number of fdc_date_online_one. But in the detail view it is returning 01 for any date but it is returning the correct weel number of $week_now..

Any ideas of why this is happening?

Rgds
Chris

[chrislynch8]

Have it working but I would like some feed back on the way the dates are handle using the bean

I was getting my date field using $this->bean->fdc_date_online_one. This would return 14/04/2010. I was then trying to get the Week Number from that using date("W",strtomtime($this->bean->fdc_date_online_one)) this always returned 01 because the date function was seeing my dated as 1970-01-01

I had to query the database to get the fdc_date_online_one value which would return 2010-04-14, I then used date("W",strtotime($row['fdc_date_online_one'])) and this returned the correct Week Number

Is there a way I can use the bean to get the date in the format it is in the Database? It would see to be more efficient than having to query the database everytime I want to pull out a date value?

Thing is that when I used a Logic Hook the Bean method returned the correct date?


In a Logic Hook $bean->fdc_date_online_one returns the date in the DB Format Y-m-d
In the Detail View $this->bean->fdc_date_online_one return the date in the users date format d/m/Y

Rgds
Chris

[prince.pandey7]

hi can anyone help me in calculating date difference in week .... between current date and date created .....