/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$list = User::whereNull('u_invite_code')->orWhere('u_invite_code', '=', '')->get();
foreach ($list as $key => $user) {
$user->u_invite_code = $user->getInviteCode();
$user->save();
}
Schema::create('log_user_invite_codes', function ($table) {
$table->increments('id');
$table->integer('inviter_id');
$table->integer('u_id');
$table->decimal('amount');
$table->timestamp('created_at');
});
}
public function testSubquery()
{
$users = User::where('title', 'admin')->orWhere(function ($query) {
$query->where('name', 'Tommy Toe')->orWhere('name', 'Error');
})->get();
$this->assertEquals(5, count($users));
$users = User::where('title', 'user')->where(function ($query) {
$query->where('age', 35)->orWhere('name', 'like', '%harry%');
})->get();
$this->assertEquals(2, count($users));
$users = User::where('age', 35)->orWhere(function ($query) {
$query->where('title', 'admin')->orWhere('name', 'Error');
})->get();
$this->assertEquals(5, count($users));
$users = User::whereNull('deleted_at')->where('title', 'admin')->where(function ($query) {
$query->where('age', '>', 15)->orWhere('name', 'Harry Hoe');
})->get();
$this->assertEquals(3, $users->count());
$users = User::whereNull('deleted_at')->where(function ($query) {
$query->where('name', 'Harry Hoe')->orWhere(function ($query) {
$query->where('age', '>', 15)->where('title', '<>', 'admin');
});
})->get();
$this->assertEquals(5, $users->count());
}
function admin_get_users()
{
$token = $_SERVER['Authorization'];
extract($_GET);
$admin = __get_auth_admin($token);
$result = array();
if ($admin == NULL) {
$result['success'] = 'false';
$result['message'] = 'You are not authorized';
} else {
$total = User::count();
$users = User::whereNull('deleted_at');
if (isset($search)) {
$users = $users->where('email', 'like', "%{$search}%")->orWhere('full_name', 'like', "%{$search}%")->orWhere('phone', 'like', '%' . $search . '%');
$total = $users->count();
}
if (!isset($per)) {
$per = 20;
}
if (isset($page)) {
$users->skip(($page - 1) * $per);
}
$users->take($per);
$result['success'] = 'true';
$result['users'] = $users->get();
$result['total'] = $total;
}
echo json_encode($result);
}
public function testWhereNull()
{
$users = User::whereNull('age')->get();
$this->assertEquals(1, count($users));
}
public function usersListAwaiting()
{
$sortby = Input::get('sortby');
$order = Input::get('order');
$controller = 'usersListAwaiting';
if ($sortby && $order) {
$users = User::whereNull('users.invested_date')->where('users.role', '=', '2')->where('users.investor', '!=', 1)->join('user_money_info', 'users.id', '=', 'user_money_info.id')->orderBy($sortby, $order)->get();
} else {
$users = User::whereNull('users.invested_date')->where('users.role', '=', '2')->where('users.investor', '!=', 1)->join('user_money_info', 'users.id', '=', 'user_money_info.id')->get();
}
return View::make('backend.admin.userslist', ['users' => $users, 'controller' => $controller, 'sortby' => $sortby, 'order' => $order]);
}
