/** * Gets all att. record from the connected device and no * sorting is applied. Returns only the new ones. * @return [type] [description] */ public function getAll() { if ($this->tad && $this->tad->is_alive()) { $data = $this->tad->get_att_log()->to_array(); $data = $data['Row']; // $device = Device::where('ip_address', $this->connected_device['ip_address'])->first(); $last_log = Log::where('device_id', $this->connected_device['device_id'])->orderBy('id', 'desc')->first(); $last_log_datetime = null; if ($last_log) { $last_log_datetime = Carbon::parse($last_log->datetime); } $return_data = []; $timestamp = Carbon::now()->toDateTimeString(); foreach ($data as $k => $v) { if ($last_log_datetime === null || $last_log_datetime->lt(Carbon::parse($data[$k]['DateTime']))) { $data[$k]['emp_id'] = $data[$k]['PIN']; unset($data[$k]['PIN']); $data[$k]['datetime'] = $data[$k]['DateTime']; unset($data[$k]['DateTime']); $data[$k]['verified'] = $data[$k]['Verified']; unset($data[$k]['Verified']); $data[$k]['status'] = $data[$k]['Status']; unset($data[$k]['Status']); $data[$k]['workcode'] = $data[$k]['WorkCode']; unset($data[$k]['WorkCode']); $data[$k]['device_id'] = $this->connected_device['device_id']; $data[$k]['created_at'] = $timestamp; $data[$k]['updated_at'] = $timestamp; array_push($return_data, $data[$k]); } } return $return_data; } }
public function getPointsAttribute() { $id = $this->attributes['id']; return Cache::remember("user_{$id}_points", 3, function () use($id) { $marketActions = Log::with('market')->whereFlag(true)->where('user_id', $id)->get()->sum('market.reward'); $otherActions = Log::where('user_id', $id)->whereFlag(true)->whereNull('market_item_id')->get()->sum('reward'); $reduced = $this->reduced->select('market.reward')->sum('market.reward'); return $marketActions + $otherActions - $reduced; }); }
public function process() { $transactionID = Input::get('transactionID'); $transaction = Transaction::where('transaction_id', '=', $transactionID)->first(); $logs = Log::where('transaction_id', '=', $transactionID)->get(); $recentLog = Log::where('transaction_id', '=', $transactionID)->orderBy('created_at', 'desc')->first(); if (Input::has('create')) { // Redirect to different route / URI return Redirect::route('superadmin/create_transaction')->with('transactionID', $transactionID); // Alternatively, you could process action 1 here } elseif (Input::has('update')) { // Process action 2 return Redirect::route('superadmin/update_transaction')->with('transaction', $transaction)->with('logs', $logs)->with('recentLog', $recentLog); } elseif (Input::has('out')) { // Process action 3 return Redirect::route('superadmin/out_transaction')->with('transaction', $transaction)->with('logs', $logs)->with('users', '')->with('recentLog', $recentLog); } }
/** * Show vehicle log from storage * Created by smartrahat Date: 21.11.2015 Time: 08:32PM * @param $id * @return \Illuminate\View\View */ public function vehicleLog($id) { $vehicle = Vehicles::findOrFail($id); $logs = Log::where('bid', $id)->orderBy('date', 'desc')->orderBy('id', 'desc')->get(); $title = 'Vehicle Log'; $repository = $this->repository; return view('vehicle.vehicleLog', compact('title', 'logs', 'vehicle', 'repository')); }
Route::get('/', 'Auth\\AuthController@getLogin'); // Authentication routes... Route::get('auth/login', 'Auth\\AuthController@getLogin'); Route::post('auth/login', 'Auth\\AuthController@postLogin'); // Registration routes... Route::get('auth/register', 'Auth\\AuthController@getRegister'); Route::post('auth/register', 'Auth\\AuthController@postRegister'); }); Route::get('auth/logout', 'Auth\\AuthController@getLogout'); Route::group(['middleware' => 'auth'], function () { Route::get('goal/create', 'GoalController@create'); Route::post('goal/store', 'GoalController@store'); Route::get('goal/{id}', ['uses' => 'GoalController@show', 'as' => 'showGoal']); Route::post('logs/store', function (Request $request) { $log = Log::create($request->all()); return $log; }); Route::get('/api/goal/{goal_id}/logs/', function ($goal_id) { return Log::where('goal_id', $goal_id)->orderBy('id', 'DESC')->get(); }); Route::post('todo/store', function (Request $request) { $todo = Todo::create($request->all()); return $todo; }); Route::get('/api/goal/{goal_id}/todos/', function ($goal_id) { return Todo::where('goal_id', $goal_id)->orderBy('id', 'DESC')->get(); }); Route::post('todo/update/{todo_id}', function (Request $request, $todo_id) { Todo::find($todo_id)->update(['done' => $request->input('done')]); }); });
public function employeeLog($id) { $title = 'Employee Log'; $employee = Employee::query()->findOrFail($id); $logs = Log::where('eid', $id)->orderBy('id', 'desc')->orderBy('id', 'desc')->get(); $repository = $this->repository; return view('employee.employeeLog', compact('title', 'logs', 'employee', 'repository')); }
/** * Show the form for creating a new resource. * * @param $id * @return Response */ public function userlogs($id) { return Log::where('user_id', $id)->orderBy('id', 'DESC')->get(); }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update($id, Request $request) { $transaction = Transaction::findOrFail($id); $authuser = Auth::user(); //Update transaction if (Input::has('update')) { $this->validate($request, ['remarks' => 'required']); $input = $request->all(); $transaction->fill($input)->save(); $transaction->status = "In process"; $transaction->save(); //Log $recentLog = Log::where('transaction_id', '=', $transaction->transaction_id)->orderBy('created_at', 'desc')->first(); $firstname = $authuser->firstname; $lastname = $authuser->lastname; $date = new DateTime(); Log::create(['transaction_id' => $transaction->transaction_id, 'processor_name' => $authuser->firstname . ' ' . $authuser->lastname, 'status' => 'In process', 'remarks' => $request['remarks'], 'date_received' => $date, 'date_released' => '', 'next_processor' => '-']); if ($authuser->user_type == "Processor") { return redirect('processor/process_transactions')->withMessage('success update'); } else { return redirect('superadmin/process_transactions')->withMessage('success update'); } } //Log out transaction if (Input::has('out')) { //Log //if processor of recent log is the auth user, update log $recentLog = Log::where('transaction_id', '=', $transaction->transaction_id)->orderBy('created_at', 'desc')->first(); $firstname = $authuser->firstname; $lastname = $authuser->lastname; $complete = Input::has('completed') ? true : false; //completed transaction should only be forwarded to customer or to '-' if ($complete) { $transaction->status = "Completed"; $transaction->save(); if ($request['next_processor'] != "Customer") { $nextprocessor = "-"; } else { $nextprocessor = $request['next_processor']; } //create log $date = new DateTime(); $recent_received = $recentLog->date_received; Log::create(['transaction_id' => $transaction->transaction_id, 'processor_name' => $authuser->firstname . ' ' . $authuser->lastname, 'remarks' => $request['remarks'], 'date_received' => $recent_received, 'date_released' => $date, 'status' => 'Completed', 'next_processor' => $nextprocessor]); } else { $nextprocessor = $request['next_processor']; $recent_released = $recentLog->date_released; if ($recentLog->status == 'Completed') { $transaction->status = "In process"; $transaction->save(); $date = new DateTime(); Log::create(['transaction_id' => $transaction->transaction_id, 'processor_name' => $authuser->firstname . ' ' . $authuser->lastname, 'status' => 'In process', 'remarks' => $request['remarks'], 'date_received' => $recent_released, 'date_released' => $date, 'next_processor' => $nextprocessor]); } else { //add date_released $date = new DateTime(); $recentLog->date_released = $date; $recentLog->remarks = $request['remarks']; $recentLog->next_processor = $nextprocessor; $recentLog->save(); } } if ($authuser->user_type == "Processor") { return redirect('processor/process_transactions')->withMessage('success out'); } else { return redirect('superadmin/process_transactions')->withMessage('success out'); } } }
/** * @param $id * @return \Illuminate\View\View */ public function clientLog($id) { $title = 'Client Log'; $client = Client::query()->findOrFail($id); if (Input::has('start') && Input::has('end')) { $start = Input::get('start'); $end = Input::get('end'); $logs = Log::where('cid', $id)->whereBetween('date', [$start, $end])->orderBy('date', 'desc')->orderBy('date', 'desc')->get(); } elseif (Input::has('start')) { $start = Input::get('start'); $logs = Log::where('cid', $id)->where('date', $start)->orderBy('date', 'desc')->orderBy('id', 'desc')->get(); } elseif (Input::has('end')) { $end = Input::get('end'); $logs = Log::where('cid', $id)->where('date', $end)->orderBy('date', 'desc')->orderBy('id', 'desc')->get(); } else { $logs = Log::where('cid', $id)->orderBy('date', 'desc')->orderBy('id', 'desc')->get(); } //$logs = Log::where('cid',$id)->orderBy('date','desc')->orderBy('id','desc')->get(); $repository = $this->repository; return view('client.clientLog', compact('title', 'logs', 'client', 'repository')); }