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 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗
  • ¥15 钢筋实图交点识别,机器视觉代码
  • ¥15 如何在Linux系统中,但是在window系统上idea里面可以正常运行?(相关搜索:jar包)
  • ¥50 400g qsfp 光模块iphy方案
  • ¥15 两块ADC0804用proteus仿真时,出现异常
  • ¥15 关于风控系统,如何去选择
  • ¥15 这款软件是什么?需要能满足我的需求
  • ¥15 SpringSecurityOauth2登陆前后request不一致