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')]);
}
