SQLSTATE[HY000]：一般错误: 2031 (SQL: select * from `work_permits` `user_id` = ?)使用龙骨

Question

我有错误，请帮助我如何解决这个问题？谢谢。

请检查错误

https://flareapp.io/share/LPdjyyz5

控制器

public function permitBranch(Request $request, $permitbranchId){
   // current date
   $date = date("Y/m/d");
   $userId = User::where('mf_branch_id', $permitbranchId)->pluck('id');
    
   $permit_report = WorkPermit::where('user_id', $userId)->get();
   $data = [
      'permitReports' => $permit_report,
      'date' => $date,
   ];
       
   return  view('cms.report.work_permit_report_list', $data);
}

Answer 1

实际上，您是通过使用pluck传递数组的。

   $userId = User::where('mf_branch_id', $permitbranchId)->pluck('id');

它像这样返回数组(键是项的索引)。自动递增值)：

[
    1 => "name1",
    2 => "name2",
    .
    .
    .
    100 => "name100"
]

如果您正在获取单个记录，或者它的多个ID在这里使用whereIn，请使用first()来尝试它。

 $permit_report = WorkPermit::whereIn('user_id', $userId)->get();

若单记录

     $userId = User::where('mf_branch_id', $permitbranchId)->firstOrFail();
     $permit_report = WorkPermit::where('user_id', $userId->id)->get();

Answer 2

方法返回一个数组，更改代码：

$userId = User::where('mf_branch_id', $permitbranchId)->firstOrFail();
    
$permit_report = WorkPermit::where('user_id', $userId->id)->get();