public function movimientosPorAlmacen(Request $request)
{
$desde = date_format(date_create($request->fechaDesde), "Y/m/d H:i:s");
$hasta = date_format(date_create($request->fechaHasta), "Y/m/d 23:59:99");
if ($request->rdOrigin == 'one') {
$origin_id[] = $request->origin;
} else {
$warehouses = Warehouse::select('id')->where('company_id', $request->companyList)->where('activity_id', $request->rdActivity)->get();
foreach ($warehouses as $warehouse) {
$origin_id[] = $warehouse->id;
}
}
if ($request->rdDestination == 'one') {
$destination_id[] = $request->destination;
} else {
$warehouses = Warehouse::select('id')->where('company_id', $request->companyList)->where('activity_id', $request->rdActivity)->get();
foreach ($warehouses as $warehouse) {
$destination_id[] = $warehouse->id;
}
}
$movements = Movement::where('created_at', '>=', $desde)->where('created_at', '<=', $hasta)->whereIn('origin_id', $origin_id)->whereIn('destination_id', $destination_id)->whereIn('status_id', [1, 2, 4])->get();
return view('reports.movimientosPorAlmacen', compact('movements'));
}
