public static function showLogs($request)
{
$categories = Category::all();
if (Request::has('filter')) {
$date_filter = explode(' - ', $request->get('filter'));
$deviceLogs = DeviceLog::with(['owner', 'device', 'user'])->whereBetween('created_at', [$date_filter[0], $date_filter[1]])->paginate(25);
$deviceLogs->setPath('report');
}
return view('device_log.report', compact('deviceLogs', 'categories'));
}
public static function fetch_history($category_slug)
{
$json = [];
$category = Category::whereSlug($category_slug)->first();
$device_logs = DeviceLog::all();
foreach ($device_logs as $device_log) {
if ($device_log->device->category_id == $category->id) {
$json[] = ['device_slug' => $device_log->device->slug, 'device_name' => $device_log->device->name, 'owner_slug' => $device_log->owner->slug, 'owner_name' => $device_log->owner->fullName(), 'user_slug' => $device_log->user->id, 'assigned_by' => $device_log->user->name, 'action' => $device_log->action, 'date_assigned' => date('m/d/Y h:i A', strtotime($device_log->created_at))];
}
}
return json_encode($json);
}
public static function disassocLog($id)
{
$device = Device::find($id);
$device_log = new DeviceLog();
$device_log->owner_id = $device->owner_id;
$device_log->device_id = $id;
$device_log->user_id = \Auth::user()->id;
$device_log->action = "DISASSOCIATE";
$device_log->save();
$owner_id = $device_log->owner_id;
$owner = Owner::find($owner_id);
$device->owner_id = 0;
$device->save();
return redirect()->back()->with('success_msg', $device->name . ' was DISASSOCIATED to ' . $owner->fullName())->with('message_label', 'alert-success');
}
public function fetchDispatches($id)
{
$json = array();
$device_logs = DeviceLog::where('owner_id', $id)->get();
foreach ($device_logs as $device_log) {
$json[] = ['device_id' => $device_log->device_id, 'device_name' => $device_log->device->name, 'created_at' => date('M d, Y h:i:s A', strtotime($device_log->created_at)), 'action' => $device_log->action, 'device_slug' => $device_log->device->slug, 'user' => $device_log->user->name, 'user_id' => $device_log->user->id];
}
return json_encode($json);
}
public function showReport(Request $request)
{
$show_log = DeviceLog::showLogs($request);
return $show_log;
}
