我在数据库中有一些使用加密形式的字段。 我想在条件中使用该加密字段。 是否可以使用 where条件和 laravel 中的加密表字段?
此代码已在模型中。
$wherecondition = "";
$title = 0;
$employees = employee::select('*');
$wherecondition = $employees->where('delFlg',0)
->where('resign_id',0)
->where(Crypt::decrypt('title'),$title);
// here title is encrypt form on table
// here $title is a fix variable
$employees = $wherecondition;
$employees = $employees->orderBy($request->employeesort,$request->sortOrder)
->paginate($request->plimit);