public static function getDatatable() { $id = Session::get('user_id'); $first_day = date("Y-m-01"); $last_day = date("Y-m-t"); $today = date("Y-m-d"); /* MONTH user consumption*/ $monthUserConsumption = WaterRegister::where('state', '=', 'Mendoza')->where('user_id', '=', $id)->whereBetween('date', [$first_day, $last_day])->sum('value'); /* MONTH city consumption total and average lts/hour*/ $user = User::select(['city_id'])->with('state', 'city')->where('id', $id)->first(); $cityConsumption = WaterRegister::select(DB::raw('sum(value) as total, avg(value) as avg'))->where('city', '=', $user->city->name)->whereBetween('date', [$first_day, $last_day])->groupBy('city')->get(); $cityTotalConsumption = $cityConsumption[0]->total; $cityAverage = $cityConsumption[0]->avg; /*current consumption and liters per hour (DAY)*/ $consumption = WaterRegister::where('date', '=', $today)->where('user_id', '=', $id)->sum('value'); $consumptionPerHour = $consumption / 60; /*water price*/ $waterPrice = WaterPrice::select('price')->active()->get(); /*water bill*/ $price = $waterPrice[0]->price; $liters = WaterRegister::where('date', '=', $today)->where('user_id', '=', $id)->sum('value'); $bill = $liters * $price; $aux = new stdClass(); $aux->monthUserConsumption = $monthUserConsumption; $aux->cityTotalConsumption = $cityTotalConsumption; $aux->cityAverage = $cityAverage; $aux->consumptionPerHour = $consumptionPerHour; $aux->consumption = $consumption; $aux->waterPrice = $price; $aux->bill = $bill; $data = [collect($aux)]; $datatable = Datatables::of(collect($data)); return $datatable->make(true); }
private function query() { $users = User::select("users.*"); $users->leftJoin('people', 'users.person_id', '=', 'people.id'); if (Auth::check() && !Auth::user()->active_contact->isE80()) { $users->leftJoin('company_person', 'company_person.person_id', '=', 'people.id'); $users->where("company_person.company_id", "=", Auth::user()->active_contact->company_id); } return $users; }
public static function getDatatable() { $users = User::select(['id', 'name', 'lastname', 'state_id', 'city_id'])->with('state', 'city')->get(); foreach ($users as $user) { $user->state_name = $user->state->name; $user->city_name = $user->city->name; } $datatable = Datatables::of($users); $datatable->addColumn('actions', '<a href="{{ URL::to(\'users/\' . $id.\'/edit\') }}" class="btn btn-default" title="Editar" ><i class="fa fa-edit"></i></a> <a href="#deleteModal" class="mb-xs mt-xs mr-xs modal-with-zoom-anim btn btn-danger delete-link" data-href="{{ URL::to(\'users/\' . $id) }}" title="Eliminar" ><i class="fa fa-trash"></i></a>'); return $datatable->make(true); }
public function run() { $comment_list = ['看見麥兜總召的格局', '所以我說那個醬汁呢', '李嚴,你怎麼帥成這樣', '那些年,子洋的粉色泡泡', '刁難哥奇遇記', '轉角遇到典型的政大資管人', '喔~問題來了', '你這樣不Work', '資管迎新茶會 5/22 商院101 熱血開踢', '5/13 科技組晚上上課有演講者,歡迎到場', 'Hakuna Matata', '老王的五十個案子', '杰哥的衣服Queue', '中央資管,我愛你們全部', '阿~我們就全班宅男啊', '我都參考貝克漢穿搭耶', '這個大叔是哪來的', '現在放棄的話,就可以放暑假了', '潮水退了就知道誰沒穿褲子', '聽完周老師這番話,全資管系都驚呆了', '左手寫詩,右手寫程式', '啊不就好棒棒', '吃吃看,你吃一口就知道了', '德國拳王倒下去,莎拉布萊曼照唱 Time to say goodbye', '面對現實,不然現實就面對你', '棉被再怎麼抖都會有灰塵', '務必冷靜理性透徹,暫時把好惡丟到河流另一邊去', '怕熱就不要進廚房', '拿破崙說 由馴鹿所領導的獅子軍團 就在也不是獅子軍團', '甜甜圈~', '在非洲,每六十秒,就有一分鐘過去', '當你的左臉被人打,那你的左臉就會痛', '英國研究 生日過越多的人就越老', '當蝴蝶在南半球拍了兩下翅膀,牠就會稍微飛高一點點', '我買了130元的高級鵝肉飯']; //echo count($comment_list); $user_list = User::select('id')->lists('id'); //echo var_dump($user_list); foreach ($user_list as $user_key => $user_value) { $app_ran_list = App::orderByRaw("RAND()")->take(35)->lists('id'); foreach ($app_ran_list as $app_key => $app_value) { User_App_Comment::create(['u_id' => $user_value, 'a_id' => $app_value, 'comment' => $comment_list[$app_key]]); } } }
public function anyData() { $canUpdateUser = auth()->user()->can('update-user'); $users = User::select(['id', 'name', 'email', 'work_number']); return Datatables::of($users)->addColumn('namelink', function ($users) { return '<a href="users/' . $users->id . '" ">' . $users->name . '</a>'; })->add_column('edit', ' <a href="{{ route(\'users.edit\', $id) }}" class="btn btn-success" >Edit</a>')->add_column('delete', ' <form action="{{ route(\'users.destroy\', $id) }}" method="POST"> <input type="hidden" name="_method" value="DELETE"> <input type="submit" name="submit" value="Delete" class="btn btn-danger" onClick="return confirm(\'Are you sure?\')""> {{csrf_field()}} </form>')->make(true); }
/** * Get all comments of a user, paginated * * @param $user_id * * @param Request $request * * @return array */ public function userComments($user_id, Request $request) { // get limit $limit = $request->get('limit') ?: 5; $limit = $limit > 5 ? 5 : $limit; try { // Get user $user = User::select('user_id', 'username', 'created_at')->findOrFail($user_id); // Get comments of user, paginated $comments = $user->comments()->select('comment_id', 'comment', 'created_at')->paginate($limit); } catch (ModelNotFoundException $e) { return ResponseHelper::write(404, 1001, 'The requested user does not exist.'); } // Get transformer for user and user comments $userTransformer = new UserTransformer(); $commentTransformer = new UserCommentTransformer(); // Return transformed user and comments return ResponseHelper::withPaginationData(['user' => $userTransformer->transform($user->toArray()), 'comments' => $commentTransformer->transformCollection($comments->toArray()['data'])], $comments); }
public static function openid_grant($email, $token) { $user = User::select('users.*')->where('email', '=', $email)->join('user_openids', 'user_openids.user_id', '=', 'users.id')->where('access_token', '=', $token)->where('expires_at', '>', Carbon::now())->first(); return $user ? "user:{$user->id}" : false; }
/** * Gets All users for datatables * @return Array json Users */ public function getusers() { $users = User::select(array('users.id', 'users.email', 'users.permissions', 'users.last_login', 'users.created_at')); return Datatables::of($users)->add_column('actions', ' <center> <a href="{{ URL::route(\'admin.edituser\', array($id) )}}" class="btn btn-info btn-mini"><i class="icon-edit icon-white"></i> Edit </a>')->make(); }
public function postUsers(Request $request) { $outputMessage = array(); if ($request->has('action')) { switch ($request->get('action')) { case 'new': $email = $request->get('email'); $password = $request->get('password'); $firstname = $request->get('firstname'); $lastname = $request->get('lastname'); //$groupName = $request->get('group'); $groupID = $request->get('group'); try { $user = Sentry::register(array('email' => $email, 'first_name' => $firstname, 'last_name' => $lastname, 'password' => $password, 'activated' => true)); if ($user) { $outputMessage[] = array("type" => "success", "msg" => "User created successfuly."); if ($groupID == 1) { $group = Sentry::findGroupByName('user'); $user->addGroup($group); $outputMessage[] = array("type" => "alert", "msg" => "The God is unique.User is added to User group ;)"); } else { $group = Sentry::findGroupById($groupID); if ($group) { $user->addGroup($group); $outputMessage[] = array("type" => "success", "msg" => "User added to " . $group->name . " successfuly"); } else { $group = Sentry::findGroupByName('user'); $user->addGroup($group); $outputMessage[] = array("type" => "alert", "msg" => "Group " . $group->name . " not found.User is added to User group ;)"); } } } } catch (\Cartalyst\Sentry\Users\LoginRequiredException $e) { $outputMessage[] = array("type" => "alert", "msg" => "Login field is required."); } catch (\Cartalyst\Sentry\Users\PasswordRequiredException $e) { $outputMessage[] = array("type" => "alert", "msg" => "Login field is required."); } catch (\Cartalyst\Sentry\Users\UserExistsException $e) { $outputMessage[] = array("type" => "alert", "msg" => "User with this login already exists."); } catch (\Cartalyst\Sentry\Groups\GroupNotFoundException $e) { $outputMessage[] = array("type" => "alert", "msg" => "Group was not found."); } break; } } $groups = Sentry::findAllGroups(); $users = User::select(array('id', 'first_name', 'last_name', 'email'))->paginate(20); return view('admin.users')->with('users', $users)->with('groups', $groups)->with('messages', $outputMessage); }
Route::get('/', 'MemberController@managementAccount'); //view Route::get('/changepassword', 'MemberController@viewChangePassword'); Route::get('/changename', 'MemberController@viewName'); Route::get('/change-email', 'MemberController@viewEmail'); Route::get('/permissions', 'MemberController@allMember'); //- send data Route::post('/changePassword/{id}', 'MemberController@changePassword'); Route::post('/changeName/{id}', 'MemberController@changeName'); Route::post('/changeEmail/{id}', 'MemberController@changeEmail'); }); Route::post('/addManager', 'MemberController@addManager'); Route::post('/delManager', 'MemberController@delManager'); //------------------------------------------------------------Auto Route::get('/autocomplete/member', function () { $user = Models\User::select('id', 'email', 'name')->where('level_id', '!=', 1)->get(); $allUser = []; $allUser['users'] = $user; return Response::json($user); }); //--------------------------------------------------------------------------------------- // Authentication routes... Route::get('auth/login', 'Auth\\AuthController@getLogin'); Route::post('auth/login', 'Auth\\AuthController@postLogin'); Route::get('auth/logout', 'Auth\\AuthController@getLogout'); // Registration routes... Route::get('auth/register', 'Auth\\AuthController@getRegister'); Route::post('auth/register', 'Auth\\AuthController@postRegister'); // use for @break in blade Blade::extend(function ($value) { return preg_replace('/(\\s*)@(break|continue)(\\s*)/', '$1<?php $2; ?>$3', $value);
}); }); $app->get('/comments', function (Request $request) { $comments = App\Models\Comment::orderBy('created_at', 'desc')->with('author')->get(); $ids = $comments->lists('user_id')->unique()->sort()->values(); $authors = App\Models\User::select('id', 'nickname')->whereIn('id', $ids)->get(); return response()->json($comments)->header('Access-Control-Allow-Origin', '*'); }); $app->post('/comments', function (Request $request) { $author = App\Models\User::findOrFail($request->input('user_id')); $author->comments()->create(['text' => $request->input('text')]); $comments = App\Models\Comment::orderBy('created_at', 'desc')->with('author')->get()->all(); return response($comments)->header('Access-Control-Allow-Origin', '*'); }); $app->get('/users', function (Request $request) { $users = App\Models\User::select('id', 'nickname')->get(); return response()->json($users)->header('Access-Control-Allow-Origin', '*'); }); $app->group(['middleware' => 'auth'], function ($app) { $app->post('/conversations', function (Request $request) { $user = Auth::user(); $conversations = $user->conversations()->withoutUser($user->id)->messagesCount()->get(); $conversations = $conversations->each(function ($item) { $item['user'] = $item['users']->first(); unset($item['users']); return $item; }); return response(['success' => true, 'conversations' => $conversations])->header('Access-Control-Allow-Origin', '*'); }); $app->post('/conversations/last_id', function (Request $request) { $conv_id = Auth::user()->messages()->orderBy('created_at', 'desc')->first()->conversation_id;
/** * Function Remove * Process Delete the Brand Data * * @return \Illuminate\Http\JsonResponse */ public function onDelete() { $id = Input::get('id'); $Model = \App\Models\User::select(['id'])->where('id', $id)->first(); if ($Model) { \App\Models\User::where('id', $id)->delete(); $param['message'] = Lang::get('message.has deleted'); $param['error'] = false; } else { $param['message'] = Lang::get('message.has error'); $param['error'] = true; } return json_encode($param); }
/** * Return JSON response with a list of user details for the getIndex() view. * * @author [A. Gianotto] [<*****@*****.**>] * @since [v1.6] * @see UsersController::getIndex() method that consumed this JSON response * @return string JSON */ public function getDatatable(Request $request, $status = null) { if (Input::has('offset')) { $offset = e(Input::get('offset')); } else { $offset = 0; } if (Input::has('limit')) { $limit = e(Input::get('limit')); } else { $limit = 50; } if (Input::get('sort') == 'name') { $sort = 'first_name'; } else { $sort = e(Input::get('sort')); } $users = User::select(array('users.id', 'users.employee_num', 'users.email', 'users.username', 'users.location_id', 'users.manager_id', 'users.first_name', 'users.last_name', 'users.created_at', 'users.notes', 'users.company_id', 'users.deleted_at', 'users.activated'))->with('assets', 'accessories', 'consumables', 'licenses', 'manager', 'groups', 'userloc', 'company', 'throttle'); $users = Company::scopeCompanyables($users); switch ($status) { case 'deleted': $users = $users->withTrashed()->Deleted(); break; } if (Input::has('search')) { $users = $users->TextSearch(Input::get('search')); } $order = Input::get('order') === 'asc' ? 'asc' : 'desc'; switch (Input::get('sort')) { case 'manager': $users = $users->OrderManager($order); break; case 'location': $users = $users->OrderLocation($order); break; default: $allowed_columns = ['last_name', 'first_name', 'email', 'username', 'employee_num', 'assets', 'accessories', 'consumables', 'licenses', 'groups', 'activated', 'created_at']; $sort = in_array($sort, $allowed_columns) ? $sort : 'first_name'; $users = $users->orderBy($sort, $order); break; } $userCount = $users->count(); $users = $users->skip($offset)->take($limit)->get(); $rows = array(); foreach ($users as $user) { $group_names = ''; $inout = ''; $actions = '<nobr>'; foreach ($user->groups as $group) { $group_names .= '<a href="' . config('app.url') . '/admin/groups/' . $group->id . '/edit" class="label label-default">' . $group->name . '</a> '; } if (!is_null($user->deleted_at)) { if (Gate::allows('users.delete')) { $actions .= '<a href="' . route('restore/user', $user->id) . '" class="btn btn-warning btn-sm"><i class="fa fa-share icon-white"></i></a> '; } } else { if (Gate::allows('users.delete')) { if ($user->accountStatus() == 'suspended') { $actions .= '<a href="' . route('unsuspend/user', $user->id) . '" class="btn btn-default btn-sm"><span class="fa fa-clock-o"></span></a> '; } } if (Gate::allows('users.edit')) { $actions .= '<a href="' . route('update/user', $user->id) . '" class="btn btn-warning btn-sm"><i class="fa fa-pencil icon-white"></i></a> '; $actions .= '<a href="' . route('clone/user', $user->id) . '" class="btn btn-info btn-sm"><i class="fa fa-clone"></i></a>'; } if (Gate::allows('users.delete')) { if (Auth::user()->id !== $user->id && !config('app.lock_passwords')) { $actions .= '<a data-html="false" class="btn delete-asset btn-danger btn-sm" data-toggle="modal" href="' . route('delete/user', $user->id) . '" data-content="Are you sure you wish to delete this user?" data-title="Delete ' . htmlspecialchars($user->first_name) . '?" onClick="return false;"><i class="fa fa-trash icon-white"></i></a> '; } else { $actions .= ' <span class="btn delete-asset btn-danger btn-sm disabled"><i class="fa fa-trash icon-white"></i></span>'; } } else { $actions .= 'foo'; } } $actions .= '</nobr>'; $rows[] = array('id' => $user->id, 'checkbox' => $status != 'deleted' ? '<div class="text-center hidden-xs hidden-sm"><input type="checkbox" name="edit_user[' . e($user->id) . ']" class="one_required"></div>' : '', 'name' => '<a title="' . e($user->fullName()) . '" href="../admin/users/' . e($user->id) . '/view">' . e($user->fullName()) . '</a>', 'email' => $user->email != '' ? '<a href="mailto:' . e($user->email) . '" class="hidden-md hidden-lg">' . e($user->email) . '</a>' . '<a href="mailto:' . e($user->email) . '" class="hidden-xs hidden-sm"><i class="fa fa-envelope"></i></a>' . '</span>' : '', 'username' => e($user->username), 'location' => $user->userloc ? e($user->userloc->name) : '', 'manager' => $user->manager ? '<a title="' . e($user->manager->fullName()) . '" href="users/' . e($user->manager->id) . '/view">' . e($user->manager->fullName()) . '</a>' : '', 'assets' => $user->assets->count(), 'employee_num' => e($user->employee_num), 'licenses' => $user->licenses->count(), 'accessories' => $user->accessories->count(), 'consumables' => $user->consumables->count(), 'groups' => $group_names, 'notes' => e($user->notes), 'created_at' => $user->created_at != '' ? e($user->created_at->format('F j, Y h:iA')) : '', 'activated' => $user->activated == '1' ? '<i class="fa fa-check"></i>' : '<i class="fa fa-times"></i>', 'actions' => $actions ? $actions : '', 'companyName' => is_null($user->company) ? '' : e($user->company->name)); } $data = array('total' => $userCount, 'rows' => $rows); return $data; }
public function getUserJson(\Illuminate\Http\Request $request) { $users = User::select('id', 'name', 'email', 'mobile')->paginate(10); return $users->toJson(); }
public function index() { $data = User::select('nguoidung_id', 'tendaydu', 'email', 'diachi', 'sodienthoai', 'tencongty', 'masothue', 'gioitinh', 'terms')->get()->toArray(); // $orderCount = Order::count(); return view('backend.user.list', compact('data')); }
public function index() { $articles = User::select(['id', 'username', 'email', 'admin', 'confirmed', 'created_at'])->whereNull('deleted_at')->paginate(10); return view('admin.user.index')->with('users', $articles); }
/** * Process datatables ajax request. * * @return \Illuminate\Http\JsonResponse */ public function anyData() { return Datatables::of(User::select('*'))->make(true); }
/** * @param Request $request * @param Response $response * @return object * Принимаем ajax запрос из списка групп id, отправляем список учеников в группе * */ public function getUsers(Request $request, Response $response) { if ($request->ajax()) { $id = $request->get('id'); $query = User::select(['name', 'surname'])->where('group', '=', $id)->get(); $param = (object) ['idNameSelect' => 'users', 'url' => 'user', 'prop' => ['name', 'surname']]; return $response->json([$query, $param]); } }
public function getAllUsersWithDepartments() { return User::select(array('users.name', 'users.id', DB::raw('CONCAT(users.name, " (", departments.name, ")") AS full_name')))->join('department_user', 'users.id', '=', 'department_user.user_id')->join('departments', 'department_user.department_id', '=', 'departments.id')->pluck('full_name', 'id'); }
public static function showCitiesDaysConsumptionGraph() { //todos las ciudades en el dia $today = date("Y-m-d"); $id = Session::get('user_id'); $user = User::select(['state_id'])->with('state')->where('id', $id)->first(); $state = $user->state->name; $consumers = DB::table('water_registers')->select('city', DB::raw('sum(value) as total'))->where('date', '=', $today)->where('state', '=', $state)->orderBy('total', 'desc')->groupBy('city')->get(); //Google charts JSON's format $cols = [["label" => "Departamentos", "type" => "string"], ["label" => "Consumo", "type" => "number"]]; $aux = []; $param1 = []; $param2 = []; $param3 = []; $param4 = []; $cell = []; $rows = []; $cell['cols'] = $cols; foreach ($consumers as $key => $value) { $param1['v'] = $consumers[$key]->city; $param2['v'] = $consumers[$key]->total; $rows['c'] = [$param1, $param2]; $param3[] = $rows; $cell['rows'] = $param3; } return response()->json($cell); }