Yii2 datetime difference calculation between two dates and inserting the difference in db

Question

There are 3 fields in task table-> expected_start_datetime,expected_end_datetime,time_allocated While creating a task expected start and end datetime is selected and saved in the records.

What I am trying to do is to find the difference between the two dates in hours and minutes and save the value inside the "time_allocated" while creating the task and later on the update or view page use/display the time allocated value from the records.

Trying something like this in the task controller action create

$diff = ((strtotime($model->expected_start_datetime) - strtotime($model->expected_end_datetime)) / (60 * 60 * 24));

        $model->time_allocated = $model->time_allocated + $diff;

evaluate the date difference before inserting data – dod29 Jun 14 '16 at 08:26 — dod29, Jun 14 '16 at 08:26

Jalali · Accepted Answer · 2016-06-14T11:57:33.647

1

in your model you should be override beforeSave function like this:

            public function beforeSave($insert) {

                $diff =strtotime($this->expected_end_datetime)-strtotime($this->expected_start_datetime);
                $hours= floor($diff/(60*60));
                $mins= floor(($diff-($hours*60*60))/60);

                $this->time_allocated=$hours.':'.sprintf("%02d",$mins);
                return parent::beforeSave($insert);
            }

edited Jun 14 '16 at 11:57

answered Jun 14 '16 at 08:37

Jalali

596
4
19

one thing more it display as 04.55 what if want it show something like 04 hour and 55 minutes? – deepak Jun 14 '16 at 08:46
you can use explode for that – Jalali Jun 14 '16 at 09:05
it saves as 14hour and 25minutes in DB.I mean is it a good practice to save it like this in the db? – deepak Jun 14 '16 at 09:28
No, the best thing is to using Unix Timestamp in your db and for displaying use some codes similar these codes – Jalali Jun 14 '16 at 09:34
even if I am using your earlier approach the time difference I am getting is always wrong – deepak Jun 14 '16 at 10:28
can you explain more by an example – Jalali Jun 14 '16 at 11:03
added screenshot of the wrong difference I am getting by using this $this->time_allocated =date('H:i',(strtotime($this->expected_end_datetime)-strtotime($this->expected_start_datetime))); – deepak Jun 14 '16 at 11:09
you have something on this? – deepak Jun 14 '16 at 11:40
1

+1 for using beforeSave.. Btw, if you are having trouble with validation, override beforeValidate instead of beforeSave – Gogol Jun 16 '16 at 11:29

Yii2 datetime difference calculation between two dates and inserting the difference in db

1 Answers1