/**
* @return User
*/
public function getUser($gitterId)
{
$formatRelations = function (HasMany $query) {
return $query->orderBy('created_at', 'desc');
};
return User::query()->with(['karma' => $formatRelations, 'thanks' => $formatRelations, 'achievements' => $formatRelations])->where('gitter_id', $gitterId)->first();
}
public static function attempt($credentials)
{
$user = User::query();
foreach ($credentials as $field => $value) {
if ($field != 'password') {
$user->where($field, $value);
}
}
$user = $user->first();
// Bad Email
if (!$user) {
$_SESSION['ALERT'] = alert('Oh Snap!', 'No accounts found with that email address...', 'error');
return false;
}
// Bad Password
if ($user->password != encrypt($credentials['password'])) {
$_SESSION['ALERT'] = alert('Oh Snap!', 'That doesn\'t look like the right password...', 'error');
return false;
}
// Not Verified
if (!$user->verified) {
// Send Verification Email (Always)
static::sendVerifyToken($user->email);
$_SESSION['ALERT'] = alert("Housekeeping!", "We're trying to make sure we have a way to contact all of our players. You should have received an email at {$user->email} with a link to confirm you account. If you did not receive this email, please contact us at <a href='mailto:" . $_ENV['SUPPORT_EMAIL'] . "'>" . $_ENV['SUPPORT_EMAIL'] . "</a>.", "info");
return false;
}
// All Set!
$_SESSION['user'] = $user;
return true;
}
public function search($input)
{
$query = User::query();
$columns = Schema::getColumnListing('users');
$attributes = array();
foreach ($columns as $attribute) {
$attributes[$attribute] = null;
if (isset($input[$attribute]) and !empty($input[$attribute])) {
$query->where($attribute, $input[$attribute]);
$attributes[$attribute] = $input[$attribute];
}
}
/*
** Filter
*/
$this->filter($input, $query);
/*
** Get count
*/
$total = $query->count();
/*
** Pagination
*/
$this->pagination($input, $query);
/*
** Order
*/
$this->order($input, $query);
return [$query->get(), $attributes, 'total' => $total];
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
dd($request['products']);
$products = $request['products'];
$user_id = \Auth::user()->id;
$this->validate($request, ['street2' => 'required|max:255|string', 'house_nr2' => 'required|max:255|string', 'postalcode2' => 'required|max:255|string', 'city2' => 'required|max:255|string']);
\App\User::query()->where('id', $user_id)->update(array('street2' => $request['street2'], 'house_nr2' => $request['house_nr2'], 'postalcode2' => $request['postalcode2'], 'city2' => $request['city2']));
return Redirect::action('PagesController@pay', compact('products'));
}
public function displayRevisions()
{
if (!empty($this->revisions)) {
$html = '<h2>Revision History</h2>';
$revisions = $this->revisions;
foreach ($revisions as $revision) {
$html .= '<p>Revised By ' . User::query()->find($revision->user_id)->firstName . ' ' . User::query()->find($revision->user_id)->lastName . ' On ' . date('F d, Y, g:ia', strtotime($revision->created_at));
}
}
return $html;
}
public function automate($email, $slugs = [])
{
$user = User::query()->where('email', $email)->first();
foreach ($slugs as $slug) {
$taskExemption = new TaskExemption();
$task = Task::query()->where('slug', $slug)->first();
$taskExemption->user_id = $user->id;
$taskExemption->task_id = $task->id;
$taskExemption->save();
}
}
/**
* Register any application services.
*
* @return void
*/
public function register()
{
$this->app->singleton('App\\Contracts\\Storages\\CategoryStorageContract', function () {
return new CategoryStorage(Category::query());
});
$this->app->singleton('App\\Contracts\\Storages\\ItemStorageContract', function () {
return new ItemStorage(Item::query());
});
$this->app->singleton('App\\Contracts\\Storages\\UserStorageContract', function () {
return new UserStorageProxy(new UserStorage(User::query()));
});
}
public function index()
{
// キーワード受け取り
$keyword = \Input::get('keyword');
// クエリ生成
$query = User::query();
if (!empty($keyword)) {
$query->where('email', 'like', '%' . $keyword . '%')->orWhere('name', 'like', '%' . $keyword . '%');
}
$users = $query->orderBy('id', 'asc')->paginate(10);
return view('user.index', compact('users', 'keyword'));
}
public function getExample4()
{
$grid = new Grid((new GridConfig())->setDataProvider(new EloquentDataProvider(User::query()))->setName('example_grid4')->setPageSize(15)->setColumns([(new FieldConfig())->setName('id')->setLabel('ID')->setSortable(true)->setSorting(Grid::SORT_ASC), (new FieldConfig())->setName('name')->setLabel('Name')->setCallback(function ($val) {
return "<span class='glyphicon glyphicon-user'></span>{$val}";
})->setSortable(true)->addFilter((new FilterConfig())->setOperator(FilterConfig::OPERATOR_LIKE)), (new FieldConfig())->setName('email')->setLabel('Email')->setSortable(true)->setCallback(function ($val) {
$icon = '<span class="glyphicon glyphicon-envelope"></span> ';
return '<small>' . $icon . HTML::link("mailto:{$val}", $val) . '</small>';
})->addFilter((new FilterConfig())->setOperator(FilterConfig::OPERATOR_LIKE)), (new FieldConfig())->setName('phone_number')->setLabel('Phone')->setSortable(true)->addFilter((new FilterConfig())->setOperator(FilterConfig::OPERATOR_LIKE)), (new FieldConfig())->setName('country')->setLabel('Country')->setSortable(true), (new FieldConfig())->setName('company')->setLabel('Company')->setSortable(true)->addFilter((new FilterConfig())->setOperator(FilterConfig::OPERATOR_LIKE)), (new FieldConfig())->setName('birthday')->setLabel('Birthday')->setSortable(true), (new FieldConfig())->setName('posts_count')->setLabel('Posts')->setSortable(true), (new FieldConfig())->setName('comments_count')->setLabel('Comments')->setSortable(true)])->setComponents([(new THead())->setComponents([new ColumnHeadersRow(), (new FiltersRow())->addComponents([(new RenderFunc(function () {
return HTML::style('js/daterangepicker/daterangepicker-bs3.css') . HTML::script('js/moment/moment-with-locales.js') . HTML::script('js/daterangepicker/daterangepicker.js') . "<style>\n .daterangepicker td.available.active,\n .daterangepicker li.active,\n .daterangepicker li:hover {\n color:black !important;\n font-weight: bold;\n }\n </style>";
}))->setRenderSection('filters_row_column_birthday'), (new DateRangePicker())->setName('birthday')->setRenderSection('filters_row_column_birthday')->setDefaultValue(['1990-01-01', date('Y-m-d')])]), (new OneCellRow())->setRenderSection(RenderableRegistry::SECTION_END)->setComponents([new RecordsPerPage(), new ColumnsHider(), (new CsvExport())->setFileName('my_report' . date('Y-m-d')), new ExcelExport(), (new HtmlTag())->setContent('<span class="glyphicon glyphicon-refresh"></span> Filter')->setTagName('button')->setRenderSection(RenderableRegistry::SECTION_END)->setAttributes(['class' => 'btn btn-success btn-sm'])])]), (new TFoot())->setComponents([new TotalsRow(['posts_count', 'comments_count']), (new TotalsRow(['posts_count', 'comments_count']))->setFieldOperations(['posts_count' => TotalsRow::OPERATION_AVG, 'comments_count' => TotalsRow::OPERATION_AVG]), (new OneCellRow())->setComponents([new Pager(), (new HtmlTag())->setAttributes(['class' => 'pull-right'])->addComponent(new ShowingRecords())])])]));
$grid = $grid->render();
return view('demo.default', compact('grid'));
}
public function getData()
{
$draw = Input::get('draw');
if (Input::get('order') && Input::get('columns')) {
$columns = Input::get('columns');
$sort_cri = Input::get('order');
if ($sort_cri[0]) {
$sort_field = $columns[$sort_cri[0]['column']]['data'];
$sort_order = $sort_cri[0]['dir'];
}
}
$length = Input::get('length');
$start = Input::get('start');
$search_fields_or_search_text = Input::get('searchFields');
if (isset($limitFrom) && isset($rec_per_page) && isset($search_fields_or_search_text)) {
if (is_array($search_fields_or_search_text)) {
$usertotal_search_query = User::query();
$userdata_search_query = User::query();
foreach ($search_fields_or_search_text as $search_field => $search_value) {
$totalUsers = $usertotal_search_query->where($search_field, 'LIKE', '%' . $search_value . '%');
$users = $userdata_search_query->where($search_field, 'LIKE', '%' . $search_value . '%');
}
$totalUsers = $usertotal_search_query->count();
$users = $userdata_search_query->skip($limitFrom)->take($rec_per_page)->get();
} else {
$user_fields = \Schema::getColumnListing('users');
$usertotal_search_query = User::query();
$userdata_search_query = User::query();
foreach ($user_fields as $user_field) {
$totalUsers = $usertotal_search_query->orWhere($user_field, 'LIKE', '%' . $search_fields_or_search_text . '%');
$users = $userdata_search_query->orWhere($user_field, 'LIKE', '%' . $search_fields_or_search_text . '%');
}
$totalUsers = $usertotal_search_query->count();
$users = $userdata_search_query->skip($limitFrom)->take($rec_per_page)->get();
}
} else {
if (isset($start) && isset($length) && isset($sort_field) && isset($sort_order)) {
$totalUsers = User::count();
$users = User::orderBy($sort_field, $sort_order)->skip($start)->take($length)->get();
} else {
if (isset($start) && isset($length)) {
$totalUsers = User::count();
$users = User::skip($start)->take($length)->get();
} else {
$totalUsers = User::count();
$users = User::all();
}
}
}
return ['draw' => (int) $draw, 'recordsFiltered' => $totalUsers, 'recordsTotal' => $totalUsers, 'data' => $users];
}
private function my_query(Request $request, array $fields)
{
$query = User::query();
foreach ($fields as $field) {
if ($request->has($field)) {
if ($field == 'id' || $field == 'status') {
$query->where($field, '=', trim($request->{$field}));
} else {
$query->where($field, 'like', '%' . trim($request->{$field}) . '%');
}
}
}
return $query->orderBy('id', 'desc');
}
public function getIndex()
{
$stats = array();
$stats['accounts_pending_approval'] = User::query()->pending()->count();
// TODO: unify 'Y'/'N'/0/1
$stats['nominations_pending_review'] = Household::where('draft', 'N')->where('reviewed', 0)->count();
$stats['nominations_approved'] = Household::where('reviewed', 1)->count();
$stats['nominations_reviewed'] = Household::where('approved', 1)->count();
$stats['children_approved'] = Household::where('reviewed', 1)->join('child', 'child.household_id', '=', 'household.id')->count();
$stats['children_reviewed'] = Household::where('household.approved', 1)->join('child', 'child.household_id', '=', 'household.id')->count();
$stats['children_pending'] = Household::where('household.reviewed', 0)->where('household.draft', 'N')->join('child', 'child.household_id', '=', 'household.id')->count();
$stats['drafts'] = Household::query()->draft()->count();
$stats['orgs'] = DB::table('household')->select('affiliation.type', DB::raw('count(case when household.approved = 1 then 1 else null end) as approved'), DB::raw('count(case when household.reviewed = 1 then 1 else null end) as reviewed'), DB::raw('count(case when household.draft = "N" and household.reviewed = 0 then 1 else null end) as pending'))->join('users', 'users.id', '=', 'household.nominator_user_id')->join('affiliation', 'affiliation.id', '=', 'users.affiliation_id')->groupBy('affiliation.type')->get();
return view('admin.dashboard.index', $stats);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index(Request $request)
{
$this->validate($request, ['search' => 'string|max:20']);
$query = User::query();
if ($request->has('search')) {
$search = $request->input('search');
$query->where('name', 'like', $search . '%')->orWhere('email', 'like', $search . '%');
}
$users = $query->paginate(15);
if ($request->wantsJSON()) {
return response()->json($users->toArray(), 200);
} else {
return view('pages.user.index', ['users' => $users]);
}
}
public function printCustomer($id)
{
$si = ServiceEstimate::query()->find($id);
$user = $si->user;
$inspectedByFirst = $user->firstName;
$inspectedByLast = $user->lastName;
if (!empty($si->authid)) {
$authUser = User::query()->find($si->authid);
$authFirst = $authUser->firstName;
$authLast = $authUser->lastName;
return PDF::loadView('pages.serviceestimate.formPrintCustomer', ['si' => $si, 'inspectedByFirst' => $inspectedByFirst, 'inspectedByLast' => $inspectedByLast, 'authFirst' => $authFirst, 'authLast' => $authLast])->stream();
} else {
return PDF::loadView('pages.serviceestimate.formPrintCustomer', ['si' => $si, 'inspectedByFirst' => $inspectedByFirst, 'inspectedByLast' => $inspectedByLast])->stream();
}
}
public function user(Request $request)
{
$query = User::query();
if ($request->has('role')) {
$query->where('role', $request->input('role'));
}
if ($request->has('name')) {
$query->where('name', 'like', '%' . $request->input('name') . '%');
}
if ($request->has('email')) {
$query->where('email', 'like', '%' . $request->input('email') . '%');
}
$users = $query->orderBy('id', 'desc')->paginate(100);
return view('pages.admin.user', ['users' => $users]);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//検索キーワード受け取り
$keyword = Input::get('keyword');
//page受け取り
$page = Input::get('page');
//クエリ生成
$query = User::query();
//もしkeywordがあったら
if (!empty($keyword)) {
$query->where('email', 'like', '%' . $keyword . '%')->orWhere('name', 'like', '%' . $keyword . '%');
}
//検索実行（検索条件は和となる）
$users = $query->orderBy('id', 'desc')->paginate(10);
//reteurn
return view('admin.users.index')->with('users', $users)->with('keyword', $keyword)->with('page', $page);
}
public function getData()
{
$sort_field = Input::get('sortField');
$sort_order = Input::get('sortOrder');
$rec_per_page = Input::get('recPerPage');
$current_page = Input::get('currentPage');
$limitFrom = ($current_page - 1) * $rec_per_page;
$search_fields_or_search_text = Input::get('searchFields');
if (isset($limitFrom) && isset($rec_per_page) && isset($search_fields_or_search_text)) {
if (is_array($search_fields_or_search_text)) {
$usertotal_search_query = User::query();
$userdata_search_query = User::query();
foreach ($search_fields_or_search_text as $search_field => $search_value) {
$totalUsers = $usertotal_search_query->where($search_field, 'LIKE', '%' . $search_value . '%');
$users = $userdata_search_query->where($search_field, 'LIKE', '%' . $search_value . '%');
}
$totalUsers = $usertotal_search_query->count();
$users = $userdata_search_query->skip($limitFrom)->take($rec_per_page)->get();
} else {
$user_fields = \Schema::getColumnListing('users');
$usertotal_search_query = User::query();
$userdata_search_query = User::query();
foreach ($user_fields as $user_field) {
$totalUsers = $usertotal_search_query->orWhere($user_field, 'LIKE', '%' . $search_fields_or_search_text . '%');
$users = $userdata_search_query->orWhere($user_field, 'LIKE', '%' . $search_fields_or_search_text . '%');
}
$totalUsers = $usertotal_search_query->count();
$users = $userdata_search_query->skip($limitFrom)->take($rec_per_page)->get();
}
} else {
if (isset($limitFrom) && isset($rec_per_page) && isset($sort_field) && isset($sort_order)) {
$totalUsers = User::count();
$users = User::orderBy($sort_field, $sort_order)->skip($limitFrom)->take($rec_per_page)->get();
} else {
if (isset($limitFrom) && isset($rec_per_page)) {
$totalUsers = User::count();
$users = User::skip($limitFrom)->take($rec_per_page)->get();
} else {
$totalUsers = User::count();
$users = User::all();
}
}
}
return ['userCount' => $totalUsers, 'users' => $users];
}
public function getIndex()
{
$user = Auth::user();
//取得會員清單
$amountPerPage = 50;
//搜尋
$userQuery = User::query();
if (Input::has('q')) {
$q = Input::get('q');
//模糊匹配
$q = '%' . $q . '%';
//搜尋：信箱、暱稱、註解
$userQuery->where(function ($query) use($q) {
$query->where('email', 'like', $q)->orWhere('nickname', 'like', $q);
});
}
$totalCount = $userQuery->count();
$userList = $userQuery->paginate($amountPerPage);
return view('user.list')->with('userList', $userList)->with('amountPerPage', $amountPerPage)->with('totalCount', $totalCount);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$query = User::query();
if (Input::query('keyword')) {
$query->where('name', 'like', '%' . Input::query('keyword') . '%');
}
$page = Input::query('page') ? Input::query('page') : 1;
$per_page = Input::query('per_page') ? Input::query('per_page') : false;
$list_total = $query->count();
if ($per_page) {
$query->skip(($page - 1) * $per_page)->take($per_page);
$list_start = ($page - 1) * $per_page + 1;
$list_end = ($page - 1) * $per_page + $per_page;
if ($list_end > $list_total) {
$list_end = $list_total;
}
} else {
$list_start = 1;
$list_end = $list_total;
}
$results = $query->get();
return response($results)->header('Items-Total', $list_total)->header('Items-Start', $list_start)->header('Items-End', $list_end);
}
/**
* Get the query object to be processed by datatables.
*
* @return \Illuminate\Database\Query\Builder|\Illuminate\Database\Eloquent\Builder
*/
public function query()
{
$users = User::query();
return $this->applyScopes($users);
}
<?php
use App\User;
/*
|--------------------------------------------------------------------------
| Application Routes
|--------------------------------------------------------------------------
|
| Here is where you can register all of the routes for an application.
| It is a breeze. Simply tell Lumen the URIs it should respond to
| and give it the Closure to call when that URI is requested.
|
*/
$app->get('/', function () use($app) {
return $app->welcome();
});
$app->get('/users', function () {
return User::all();
});
$app->get('/user/{id}', function ($id) use($app) {
$user = User::query()->findOrFail($id);
return $user;
});
/**
* Display a listing of the resource.
*
* @author MS
* @return \Illuminate\View\View
*/
public function index()
{
$users = User::query();
$this->limitToMerchant($users);
return $this->standardIndexAction($users, 'user.index', 'users', ['merchant_id' => $this->fetchAssociateFilterValues($users, 'merchant')]);
}
public function searchPending(Request $request)
{
$search = trim($request->input("search")["value"] ?: "", " ,");
$start = $request->input("start") ?: 0;
$length = $request->input("length") ?: 25;
$columns = $request->input("columns");
$order = $request->input("order");
$users = User::query()->select("users.*", "affiliation.type", "affiliation.name")->join("affiliation", "affiliation.id", "=", "users.affiliation_id")->where("name_last", "LIKE", "{$search}%")->pending()->orderBy($columns[$order[0]["column"]]["name"], $order[0]["dir"]);
$count = $users->count();
$users = $users->take($length)->skip($start)->get()->toArray();
return $this->dtResponse($request, $users, $count);
}
/**
* Retrieve a user by their unique identifier.
*
* @param mixed $identifier
* @return \Illuminate\Contracts\Auth\Authenticatable|null
*/
public function retrieveById($identifier)
{
return User::query()->where('ID', $identifier)->first();
//UserID
}
/**
* Обрабатываем стандартный и расширенный поиск для категории "Техника и мебель"
*/
public function getStuffQuery(Request $request)
{
$auctions = Auction::query();
$auctions = $auctions->where('category', '=', $request->category);
if ($request->lot_type) {
$auctions = $auctions->where('lot_type', '=', $request->lot_type);
}
if ($request->region) {
$auctions = $auctions->where('region', '=', $request->region);
}
if ($request->title) {
$auctions = $auctions->where('title', 'like', '%' . $request->title . '%')->orWhere('id', '=', $request->title);
}
if ($request->city) {
$auctions = $auctions->where('city', 'like', '%' . $request->city . '%');
}
if ($request->lot_DebtorName) {
$auctions = $auctions->where('lot_DebtorName', 'like', '%' . $request->lot_DebtorName . '%');
}
if ($request->lot_EDRPOU) {
$auctions = $auctions->where('lot_EDRPOU', '=', $request->lot_EDRPOU);
}
if ($request->property_type) {
$auctions = $auctions->whereIn('property_type', $request->property_type);
}
if ($request->price_from) {
$auctions = $auctions->where('starting_price', '<=', $request->price_from);
}
if ($request->price_to) {
$auctions = $auctions->where('starting_price', '<=', $request->price_to);
}
if ($request->date_start) {
$auctions = $auctions->where('data_start', '>=', Carbon::parse($request->date_start)->format('Y-m-d'));
}
if ($request->date_end) {
$auctions = $auctions->where('date_end', '<=', Carbon::parse($request->date_end)->format('Y-m-d'));
}
if ($request->lot_number) {
$auctions = $auctions->where('id', '=', $request->lot_number);
}
if ($request->lot_user) {
$searchTerms = explode(' ', $request->lot_user);
$query = User::query();
foreach ($searchTerms as $searchTerm) {
$query->where(function ($q) use($searchTerm) {
$q->where('first_name', 'like', '%' . $searchTerm . '%')->orWhere('last_name', 'like', '%' . $searchTerm . '%')->orWhere('legal_entity', 'like', '%' . $searchTerm . '%');
});
}
$users = $query->get();
// Массив для ID обнаруженных пользователей
$users_id = [];
// Если есть пользователи, соответствующие запросу
if ($users->count() > 0) {
// Перебираем каждого пользователя
foreach ($users as $user) {
// Добавляем ID пользователя в массив $users_id
array_push($users_id, $user->id);
}
}
// Применяем фильтрацию по совпадению с ID в массиве $users_id
$auctions = $auctions->whereIn('user', $users_id);
}
if ($request->stuff_brand) {
$auctions = $auctions->where('stuff_brand', '=', $request->stuff_brand);
}
if ($request->stuff_model) {
$auctions = $auctions->where('stuff_model', '=', $request->stuff_model);
}
if ($request->stuff_year) {
$auctions = $auctions->where('stuff_year', '=', $request->stuff_year);
}
if ($request->stuff_diagonal) {
$auctions = $auctions->where('stuff_diagonal', '=', $request->stuff_diagonal);
}
$auctions = $auctions->paginate(10);
$categories = Cat::roots()->get();
$currentCategory = Cat::find($request->category);
return view('auction.search', ['auctions' => $auctions, 'categories' => $categories, 'currentCategory' => $currentCategory, 'request' => $request]);
}
public function index()
{
// Don't select all fields to keep password hash and tokens private
$Users = \App\User::query()->select(["id", "name_first", "name_last", "rank", "phone", "affiliation_id", "email", "created_at", "updated_at"])->paginate(5);
return $Users;
}
/**
* Поиск по зарегистрированным пользователям
*/
public function searchUsers(Request $request)
{
$query = App\User::query();
$what = $request->s;
if ($request->group) {
$query = $query->where('user_group', '=', $request->group);
}
if ($request->s) {
$query = $query->orWhere('first_name', 'like', '%' . $what . '%')->orWhere('last_name', 'like', '%' . $what . '%')->orWhere('middle_name', 'like', '%' . $what . '%')->orWhere('email', 'like', '%' . $what . '%')->orWhere('phone', 'like', '%' . $what . '%')->orWhere('id', '=', $what);
}
$query = $query->get();
return view('dashboard.users.search', ['what' => $what, 'query' => $query, 'request' => $request]);
}
/**
* @param $username
* @param array $with
* @return mixed
*/
public function findByUsername($username, $with = [])
{
$query = $this->model->query();
$query->where('username', $username)->orWhere('email', $username)->with($with);
return $query->first();
}
