PHP PastTime::where Beispiele

Beispiel #1

Datei: User.php Projekt: urashima82/intranet

 public function getCoworkingTimeSpent($from, $to)
 {
     return PastTime::where('user_id', $this->id)->whereBetween('date_past', array($from, $to))->where('ressource_id', Ressource::TYPE_COWORKING)->select(DB::raw('sum((TIME_TO_SEC(past_times.time_end) - TIME_TO_SEC(past_times.time_start)) / 60) as amount'))->first()->amount;
 }