控制器Laravel，筛选器数据用户验证表
控制器Laravel，筛选器数据用户验证表
提问于 2021-11-17 12:28:53
在MySQL中，我有几个用户数据，我需要与登录到系统的用户自动过滤数据。以下是控制器中的一部分代码：
//executa a query
$lista = Ponto::with('name')->where('name', Auth::name() )
->get();(MySql)表弹出框/结构：
id
name
cpf
cargo
data_inicial
hora_inicial
ref_hora_inicial
ref_hora_final
data_final
hora_final
created_at
updated_at
28
Arecelino Soares
012.213.564-80
Motorista
2021-11-18
16:22
17:12
17:12
2021-11-30
22:30
2021-11-09 19:23:55
2021-11-16 12:34:30
77
Robison Santos
132.321.432-43
Motorista
2021-11-16
12:57
NULL
NULL
NULL
NULL
2021-11-16 15:55:09
2021-11-16 15:55:09补充:表Laravel，用户数据
回答 1
Stack Overflow用户
发布于 2021-11-23 19:39:10
我设法做到了这一点，但它不再过滤表单中的日期？
$lista =$lista：：where(‘name’，Auth::user()->name)->get()；
public function dados(Request $request)
{
if ($request->input('data_inicial')) {
$data['data_inicial'] = $request->input('data_inicial');
$request->session()->put('data_inicial', $request->input('data_inicial'));
} elseif ($request->session()->has('data_inicial')) {
$data['data_inicial'] = $request->session()->get('data_inicial');
} else {
$data['data_inicial'] = null;
}
if ($request->input('geral')) {
$request->session()->forget('data_inicial');
$data['data'] = null;
}
$date = $data['data_inicial'];
$lista = Ponto::
when($date, function ($query, $date) {
return $query->where('data_inicial', $date);
})
->orderBy('data_inicial', 'DESC')->get();
$lista = Ponto::where('name', Auth::user()->name)->get();
$data['lista'] = $lista;
foreach ($lista as $item) {
if ($item->data_inicial) {
$dd = explode("-", $item->data_inicial);
$ddc = $dd[2] . "/" . $dd[1] . "/" . $dd[0];
$item->data_inicial = $ddc;
}
if ($item->data_final) {
$dd = explode("-", $item->data_final);
$ddc = $dd[2] . "/" . $dd[1] . "/" . $dd[0];
$item->data_final = $ddc;
}
}
return view('dados', $data);
}页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/70004431
复制相关文章
相似问题
腾讯云开发者
