doushan2811 2017-05-01 13:55
浏览 37
已采纳

在Eloquent查询中使用Carbon

Good day everyone,

I'm currently realising a system that lets colleagues fill in their worked hours and what they worked on. I save those into the database using a time_stamp (date) named in the table. Now I have been trying to get the values of the filled in registrations of last week (I created some dummy times). And I have been trying to use Carbon and the Eloquent query builder at the same time, and i'm completely stuck. Would anyone mind to help me out?

$currentDate = \Carbon\Carbon::now('GMT+2');

    $agoDate = $currentDate->subDays($currentDate->dayOfWeek)->subWeek();

    $weekly = Hoursregistration::pluck('date')->agoDate($currentDate);
    return $weekly;

Is the code that should pick up the dates from the db (which works). But when I try to put in the variables containing the carbon methods. It doesnt work and throw me a Method agoDate does not exist. (View: /var/www/clients/client0/web319/web/resources/views/hoursregistrations/index.blade.php) error.

I would love some help as this is crucial to my education (kind of in a tight spot rn.)

  • 写回答

1条回答 默认 最新

  • duandeng1824 2017-05-02 07:38
    关注

    As you ask for: all Hoursregistration records from 1 week ago until now

    // Current date + GMT(+2) as stated in your question
    $currentDate = Carbon::now('GMT+2');
    
    // Date exactly 1 week ago
    $agoDate = $currentDate->subDays($currentDate->dayOfWeek)->subWeek();
    
    // Records with date -between- two values
    // $weekly = Hoursregistration::whereBetween('date', [$agoDate, Carbon::now('GMT+2')])->get();
    
    // Or even simpler, all records where date is 'higher' than 1 week ago
    $weekly = Hoursregistration::where('date', '>', $agoDate)->get();
    
    // Getting the dates with the `pluck` method on the returned $weekly collection
    $dates = $weekly->pluck('date');
    
    return $weekly;
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 Spark加载本地pipelinemodel报错
  • ¥20 电脑鼠标键盘不好使了
  • ¥15 求糕手!用matlab求解目标规划模型🙏
  • ¥15 画出的分类图不对,求解答一下
  • ¥20 springboot和springcloud版本问题
  • ¥15 ps2手柄控制树莓派小车
  • ¥30 C#:vsto powerpoint的外接程序
  • ¥15 两个同维数组相比,不同位置、出现重复比无意义,而不同位置、不出现重复比,则有意义。把有意义的两个数组放入新的集合MK中。
  • ¥15 写一个可直接调用的函数,将32位有符号数转成另一个无符号的数
  • ¥15 CMAKE+VS2019+QT5.15.2组合进行二次编译