public function grid(Request $request) { if ($request->ajax() && $request->exists('req')) { $req = json_decode($request->get('req')); $perPage = $req->page->perPage; $from = $perPage * ($req->page->currentPage - 1); //--< to get users from company $query = User::distinct(); if (!is_null($req->sort)) { foreach ($req->sort as $key => $value) { $query->orderBy($key, $value); } } if (!is_null($req->filter)) { foreach ($req->filter as $key => $value) { switch ($value->operator) { case 'IsEqualTo': $query->where($key, '=', $value->operand1); break; case 'IsNotEqualTo': $query->where($key, '<>', $value->operand1); break; case 'StartWith': $query->where($key, 'LIKE', $value->operand1 . '%'); break; case 'Contains': $query->where($key, 'LIKE', '%' . $value->operand1 . '%'); break; case 'DoesNotContains': $query->where($key, 'NOT LIKE', '%' . $value->operand1 . '%'); break; case 'EndsWith': $query->where($key, 'LIKE', '%' . $value->operand1); break; case 'Between': $query->whereBetween($key, array($value->operand1, $value->operand2)); break; } } } $total = $query->count(); $query->take($perPage)->skip($from); $data = $query->get(['users.id as users.id', 'users.name as users.name', 'users.email as users.email', 'users.mobile as users.mobile', 'users.description as users.description', 'users.created_at as users.created_at', 'users.updated_at as users.updated_at']); $totalPage = ceil($total / $perPage); $countDataPerPage = count($data); $page = array("currentPage" => $req->page->currentPage, "lastPage" => $totalPage, "total" => $total, "from" => $from + 1, "count" => $countDataPerPage, "perPage" => $perPage); $result = ['data' => $data, 'page' => $page]; // dd($result); return json_encode($result, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES); } }
/** * Create a new user instance after a valid registration. * * @param array $data * @return User */ protected function create(array $data) { return User::create(['name' => $data['name'], 'email' => $data['email'], 'password' => bcrypt($data['password'])]); }
public function run() { \StartPoint\User::updateOrCreate(['id' => 1, 'email' => '*****@*****.**', 'name' => 'admin', 'password' => bcrypt('123456')]); }