php - 将 SQL 查询转换为 Laravel 5.2？

Question

谁能帮我如何将 SQL 查询转换为 Larvel 5.2

第一个查询(当月)

SELECT 
    * 
FROM 
    customer_allocations 
WHERE 
    YEAR(date) = YEAR(NOW()) AND MONTH(date) = MONTH(NOW());

第二个查询(本周)

SELECT 
    * 
FROM 
    customer_allocations 
WHERE 
    WEEKOFYEAR(date) = WEEKOFYEAR(NOW());

第三个查询(当天)

SELECT 
    * 
FROM 
    customer_allocations 
WHERE 
    YEAR(date) = YEAR(NOW()) AND 
    MONTH(date) = MONTH(NOW()) AND 
    DAY(date) = DAY(NOW());

这些 SQL 查询在 phpmyadmin 中成功运行，但我想在 laravel 中实现，任何人都可以帮助我。

我尝试转换这些查询，但在这行代码上收到错误消息:

CustomerAllocation::where([YEAR('date'),'=',YEAR(NOW()),MONTH('date'),'=',
                            MONTH(NOW())])->get();

这是错误:

Call to undefined function "App\Http\Controllers\YEAR()"

Answer 1

改变

CustomerAllocation::where([YEAR('date'),'=',YEAR(NOW()),MONTH('date'),'=',MONTH(NOW())])->get()

至

CustomerAllocation::whereRaw("YEAR(date) = YEAR(NOW())")->whereRaw("MONTH(date) = MONTH(NOW())")->get()

在您想要检查自定义条件的地方使用 whereRaw()，就像您想做的那样。