public function run()
{
// create default user asset
$asset = Asset::where('filename', '=', 'default.png')->first();
if ($asset == NULL) {
$asset = new Asset();
$asset->filename = 'default.png';
$asset->path = 'assets/content/users';
$asset->save();
}
$admin = Role::where('name', '=', 'Admin')->first();
// create default roles
if ($admin == NULL) {
$admin = new Role();
$admin->name = 'Admin';
$admin->save();
}
$adminUser = User::where('username', '=', 'admin')->first();
if ($adminUser != NULL) {
echo "Admin User Already Exsit";
} else {
$adminUser = new User();
$adminUser->username = '******';
$adminUser->email = '*****@*****.**';
$adminUser->password = '******';
$adminUser->password_confirmation = 'admin';
$adminUser->confirmation_code = md5(uniqid(mt_rand(), true));
if ($adminUser->save()) {
$adminUser->attachRole($admin);
echo "Admin User Created";
}
}
}
public function run()
{
$faker = Faker\Factory::create('es_AR');
DB::table('users')->delete();
//Creamos usuario generico inicial
$id = DB::table('users')->insertGetId(array('username' => 'admin', 'password' => App::make('hash')->make('admin'), 'email' => '*****@*****.**', 'nombre' => 'ADMINISTRADOR', 'apepat' => 'TEST', 'apemat' => '', 'confirmed' => true, 'created_at' => date("Y-m-d H:i:s"), 'updated_at' => date("Y-m-d H:i:s")));
$rol_id = Role::where(['name' => 'Administrador'])->first()->id;
DB::table('assigned_roles')->insert(array('user_id' => $id, 'role_id' => $rol_id));
foreach (range(1, 1500) as $idx) {
if ($idx % 10 == 0) {
echo ".";
}
if ($idx % 50 == 0) {
echo " ";
}
if ($idx % 100 == 0) {
echo "\n";
}
if ($idx % 500 == 0) {
echo "\n";
}
try {
DB::table('users')->insert(array('username' => str_ireplace(['á', 'é', 'í', 'ó', 'ú'], ['a', 'e', 'i', 'o', 'u'], mb_strtolower(str_replace(" ", "", $faker->userName))), 'password' => App::make('hash')->make($faker->word), 'email' => str_ireplace(['á', 'é', 'í', 'ó', 'ú'], ['a', 'e', 'i', 'o', 'u'], $faker->safeEmail), 'nombre' => mb_strtoupper($faker->firstName), 'apepat' => mb_strtoupper($faker->lastName), 'apemat' => mb_strtoupper($faker->lastName), 'confirmed' => true, 'created_at' => date("Y-m-d H:i:s"), 'updated_at' => date("Y-m-d H:i:s")));
} catch (Exception $e) {
//error_log($e->getMessage());
}
}
}
/**
* Stores new account
*
* @return Illuminate\Http\Response
*/
public function store()
{
$repo = App::make('UserRepository');
$user = $repo->signup(Input::all());
if ($user->id) {
try {
if (Config::get('confide::signup_email')) {
Mail::queueOn(Config::get('confide::email_queue'), Config::get('confide::email_account_confirmation'), compact('user'), function ($message) use($user) {
$message->to($user->email, $user->username)->subject(Lang::get('confide::confide.email.account_confirmation.subject'));
});
}
$role = Role::where('name', '=', 'admin')->first();
$user->roles()->attach($role->id);
$notice_msg = 'Su cuenta ha sido creada satisfactoriamente. Revisa tu correo';
return Redirect::action('UsersController@login')->with('notice', $notice_msg);
} catch (Exception $exc) {
$userReg = User::findOrFail($user->id);
$userReg->delete(['id']);
return Redirect::back()->with('error', 'Falló envío de correo, intente registrarse nuevamente');
}
} else {
$error = $user->errors()->all(':message');
return Redirect::back()->withInput(Input::except('password'))->with('error', $error);
}
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
// $inputs = Input::only(static::$createColumns);
// $rules = static::$createValidation;
$validator = Validator::make(Input::all(), User::$rules);
if ($validator->fails()) {
$messages = $validator->errors();
return Redirect::action('UsersController@create')->withInput(Input::except('password', 'password_confirmation'))->withErrors($messages);
// ->with('error', $error);
} else {
$repo = App::make('UserRepository');
$user = $repo->signup(Input::all());
if ($user->id) {
if (Config::get('confide::signup_email')) {
Mail::queueOn(Config::get('confide::email_queue'), Config::get('confide::email_account_confirmation'), compact('user'), function ($message) use($user) {
$message->to($user->email, $user->username)->subject(Lang::get('confide::confide.email.account_confirmation.subject'));
});
}
$userRole = Role::where('name', 'volunteer')->first();
$user->attachRole($userRole->id);
// $user->confirmed = true;
// $user->save();
// $result = Auth::attempt(['email' => $user->email, 'password' => Input::get('password')]);
return Redirect::action('UsersController@create2')->with('notice', Lang::get('confide::confide.alerts.account_created'));
} else {
$error = $user->errors()->all(':message');
// dd($error);
}
//
}
//closes else for validator-if
}
public function run()
{
DB::table('users')->delete();
$user = User::create(array('id' => 1, 'username' => 'admin', 'first_name' => 'Yamid', 'last_name' => 'Viloria Ortega', 'email' => '*****@*****.**', 'password' => Hash::make('1234'), 'created_at' => new DateTime(), 'updated_at' => new DateTime()));
$role = Role::where('name', '=', 'admin')->get()->first();
$user->attachRole($role);
}
public function run()
{
DB::table('permissions')->delete();
$roles = array();
$roles[0] = Role::where('name', '=', 'admin')->first()->id;
$roles[1] = Role::where('name', '=', 'moderator')->first()->id;
$resources = Resource::all();
$actions = array();
$actions[0] = Action::where('name', '=', 'manage')->first()->id;
/*
$actions[0] = Action::where('name','=','create')->first()->id;
$actions[1] = Action::where('name','=','read')->first()->id;
$actions[2] = Action::where('name','=','update')->first()->id;
$actions[3] = Action::where('name','=','delete')->first()->id
*/
$data = array();
foreach ($roles as $role) {
foreach ($resources as $resource) {
foreach ($actions as $action) {
$data[] = array('role_id' => $role, 'type' => $role == $roles[0] || $resource->name != 'role' && $resource->name != 'auth' ? 'allow' : 'deny', 'action_id' => $action, 'resource_id' => $resource->id);
}
}
}
DB::table('permissions')->insert($data);
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
if ($this->argument('name')) {
$name = trim($this->argument('name'));
$role = Role::where('name', '=', $name)->first();
if ($role) {
$this->info("Role '{$name}' already exists.");
exit;
}
$role = new Role();
$role->name = $name;
$role->save();
$this->info('Role saved successfully.');
} else {
$roles = Role::all();
$this->info('Existing Roles:');
foreach ($roles as $role) {
$this->info($role->name);
}
$continue = $this->ask("Would you still like to add a new role? (yes/no)");
if ('yes' === trim(strtolower($continue))) {
$name = $this->ask("What's the new role's name?");
$role = new Role();
$role->name = trim($name);
$role->save();
$this->info('Role saved successfully.');
}
}
}
public function run()
{
$admin = Role::where('name', '=', 'administrator')->first();
$perms = Permission::all();
$admin->perms()->sync(array_pluck($perms, 'id'));
$man = Role::where('name', '=', 'users manager')->first();
$perms = Permission::where('name', '=', 'manage_users')->orWhere('name', '=', 'delete_users')->get();
$man->perms()->sync(array_pluck($perms, 'id'));
$man = Role::where('name', '=', 'premium author')->first();
$perms = Permission::where('name', '=', 'manage_premium_casts')->orWhere('name', '=', 'manage_free_casts')->orWhere('name', '=', 'manage_series')->get();
$man->perms()->sync(array_pluck($perms, 'id'));
$man = Role::where('name', '=', 'author')->first();
$perms = Permission::where('name', '=', 'manage_free_casts')->orWhere('name', '=', 'manage_series')->get();
$man->perms()->sync(array_pluck($perms, 'id'));
$man = Role::where('name', '=', 'eraser')->first();
$perms = Permission::where('name', '=', 'delete_series')->orWhere('name', '=', 'delete_casts')->get();
$man->perms()->sync(array_pluck($perms, 'id'));
$man = Role::where('name', '=', 'premium user')->first();
$perms = Permission::where('name', '=', 'view_premium_casts')->orWhere('name', '=', 'view_free_casts')->get();
$man->perms()->sync(array_pluck($perms, 'id'));
$man = Role::where('name', '=', 'user')->first();
$perms = Permission::where('name', '=', 'view_free_casts')->get();
$man->perms()->sync(array_pluck($perms, 'id'));
$man = Role::where('name', '=', 'guest')->first();
$perms = Permission::where('name', '=', 'view_free_casts')->get();
$man->perms()->sync(array_pluck($perms, 'id'));
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
//1. Create Independent Sponsor role
$sponsorRole = Role::where('name', '=', 'Independent Sponsor')->first();
if (!$sponsorRole) {
$sponsorRole = new Role();
$sponsorRole->name = "Independent Sponsor";
$sponsorRole->save();
$this->info("Independent Sponsor role created.");
} else {
$this->info("Independent Sponsor role exists.");
}
//2. Add Independent Sponsor role to all Admins
$adminRole = Role::where('name', 'Admin')->first();
$admins = $adminRole->users()->get();
foreach ($admins as $admin) {
$this->info('--------------------------------------------------');
if ($admin->hasRole($sponsorRole->name)) {
$this->info($admin->email . " already set as Independent Sponsor");
} else {
$admin->attachRole($sponsorRole);
$this->info($admin->email . " set as " . $sponsorRole->name);
}
//3. Remove Admin role from non-admin users
$stayAdmin = strtolower(trim($this->ask("Keep " . $admin->email . " as an Admin? (yes/no)")));
if ($stayAdmin != 'yes') {
$admin->detachRole($adminRole);
$this->info("Removed Admin role from " . $admin->email);
} else {
$this->info($admin->email . " still set as an Admin.");
}
}
}
public function creating($user)
{
// generate activation key for the user being created
$user->activation_key = md5(uniqid(rand(), true));
// @TODO: use a Role repository
$role = \Role::where('name', 'member')->first();
$user->role()->associate($role);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$roles = $this->role->all();
if (Request::ajax()) {
$roles = Role::where('role', 'like', '%' . Input::get('term', '') . '%')->get(array('id', 'role'));
return $roles;
}
return View::make('roles.index', compact('roles'));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$roles = $this->role->paginate(Settings::getValue('TABLE_ELEMENTS'));
if (Request::ajax()) {
$roles = Role::where('role', 'like', '%' . Input::get('term', '') . '%')->get(array('id', 'role'));
return $roles;
}
return View::make('backend.roles.index', compact('roles'));
}
public function updateUser($id)
{
$user = User::find($id);
$data = Input::all();
$user->detachRoles($user->roles);
$user->update($data);
$user->attachRole(Role::where('name', $data['role'])->first());
return Redirect::back()->with('message', 'berhasil update user');
}
public static function isAdmin()
{
$role = Role::where('user_id', static::user()->id)->first();
if ($role->permission == 1) {
return true;
} else {
return false;
}
}
public static function getRoleId($rolename)
{
$role = Role::where('rolename', $rolename)->first();
if ($role) {
return $role->_id;
} else {
return false;
}
}
public function postAdd()
{
$rules = ['firstname' => 'required|min:2', 'lastname' => 'required|min:2', 'address' => 'required|min:5', 'phone' => 'required|min:7'];
if (!Auth::check()) {
array_push($rules, ['email' => 'required|email|unique:users']);
}
$validator = Validator::make(Input::all(), $rules);
if ($validator->fails()) {
return Redirect::to("checkout")->withErrors($validator)->withInput(Input::except(''));
} else {
if (Auth::check()) {
$user = User::find(Auth::user()->id);
} else {
$user = new User();
$user->email = Input::get('email');
$password = str_random(10);
$user->password = Hash::make($password);
}
$user->firstname = Input::get('firstname');
$user->lastname = Input::get('lastname');
$user->address = Input::get('address');
$user->phone = Input::get('phone');
if ($user->save()) {
$role = Role::where('name', '=', 'Customer')->first();
if (!$user->hasRole("Customer")) {
$user->roles()->attach($role->id);
}
$order = new Order();
$order->user_id = $user->id;
$order->status_id = OrderStatus::where('title', '=', 'Новый')->first()->id;
$order->comment = 'Телефон: <b>' . $user->phone . '</b><br>Адрес: <b>' . $user->address . '</b><br>Комментарий покупателя: ' . '<i>' . Input::get('comment') . '</i>';
if ($order->save()) {
$cart = Cart::content();
foreach ($cart as $product) {
$orderDetails = new OrderDetails();
$orderDetails->order_id = $order->id;
$orderDetails->product_id = $product->id;
$orderDetails->quantity = $product->qty;
$orderDetails->price = $product->price;
$orderDetails->save();
}
}
if (!Auth::check()) {
Mail::send('mail.registration', ['firstname' => $user->firstname, 'login' => $user->email, 'password' => $password, 'setting' => Config::get('setting')], function ($message) {
$message->to(Input::get('email'))->subject("Регистрация прошла успешно");
});
}
$orderId = $order->id;
Mail::send('mail.order', ['cart' => $cart, 'order' => $order, 'phone' => $user->phone, 'user' => $user->firstname . ' ' . $user->lastname], function ($message) use($orderId) {
$message->to(Input::get('email'))->subject("Ваша заявка №{$orderId} принята");
});
Cart::destroy();
return Redirect::to("checkout/thanks/spasibo-vash-zakaz-prinyat")->with('successcart', 'ok', ['cart' => $cart]);
}
}
}
public function index()
{
if (Auth::check()) {
$leaves = Leave::with('user')->get();
$role = Role::where('user_id', Auth::user()->id)->first();
return $this->view('dashboard/leave/index', ['leaves' => $leaves, 'role' => $role]);
} else {
return $response->redirect('/login', $code = 302);
}
}
/**
* Authorize roles and permissions.
* ================================================================
*
* Attach the given role name to this user.
*
* @param string $role_name The name of the role to attach.
* @return void
*/
public function attachRole($role_name)
{
$role = Role::where('name', '=', $role_name)->first();
if (isset($role)) {
$pivot = DB::table('user_roles')->where('user_id', '=', $this->id)->where('role_id', '=', $role->id) - get();
if (!isset($pivot)) {
DB::table('user_roles')->insert(array('role_id' => $role->id, 'user_id' => $this->id));
}
}
}
public function getAdmins()
{
$this->beforeFilter('admin');
$adminRole = Role::where('name', 'Admin')->first();
$admins = $adminRole->users()->get();
foreach ($admins as $admin) {
$admin->admin_contact();
}
return Response::json($admins);
}
public function vistaAsignarUsuarioPermiso()
{
$usuarios = Usuario::orderBy('nombre')->get();
$perfiles = Role::where('estado', 'A')->get();
$permisos = Permission::all();
$this->array_view['usuarios'] = $usuarios;
$this->array_view['perfiles'] = $perfiles;
$this->array_view['permisos'] = $permisos;
return View::make($this->folder_name . '.permiso.asignar-usuario-permiso', $this->array_view);
}
/**
* Creates a user from the provided user data
* @param array
* @return void
*/
private function createUser($userData)
{
$user = new User();
$user->username = $userData['username'];
$user->password = $userData['password'];
$role = Role::where('name', '=', $userData['role'])->first();
$user->role()->associate($role);
$user->save();
$this->users[$userData['username']] = $user;
}
public static function role($id)
{
$user = User::find($id);
$role = DB::table('assigned_roles')->where('user_id', $user->id)->first();
if (!$role) {
return false;
}
$roleName = Role::where('id', $role->role_id)->first();
return $roleName->name;
}
/**
* @test
*/
public function it_has_roles()
{
$user = User::find(1);
$this->assertTrue($user->hasRole('Admin'));
$this->assertTrue($user->hasRole('Editor'));
$this->assertTrue($user->hasRole('Blogger'));
$adminRole = Role::where('name', '=', 'Admin')->first();
$this->assertTrue($user->hasRole($adminRole));
$this->assertFalse($user->hasRole('Fisherman'));
}
public function assignContributors($contributor_github_ids)
{
$users = User::whereIn('github_id', $contributor_github_ids)->get();
$role = Role::where(['name' => $this->roleName])->first();
foreach ($users as $user) {
if ($user->roles()->count() > 0) {
continue;
}
$user->roles()->attach($role->id);
}
}
public function run()
{
DB::table('permissions')->delete();
$permissions = array(array('name' => 'manage_blogs', 'display_name' => 'manage blogs'), array('name' => 'manage_posts', 'display_name' => 'manage posts'), array('name' => 'manage_comments', 'display_name' => 'manage comments'), array('name' => 'manage_users', 'display_name' => 'manage users'), array('name' => 'manage_roles', 'display_name' => 'manage roles'), array('name' => 'post_comment', 'display_name' => 'post comment'));
DB::table('permissions')->insert($permissions);
DB::table('permission_role')->delete();
$role_id_admin = Role::where('name', '=', 'admin')->first()->id;
$permission_base = (int) DB::table('permissions')->first()->id - 1;
$permissions = array(array('role_id' => $role_id_admin, 'permission_id' => $permission_base + 1), array('role_id' => $role_id_admin, 'permission_id' => $permission_base + 2), array('role_id' => $role_id_admin, 'permission_id' => $permission_base + 3), array('role_id' => $role_id_admin, 'permission_id' => $permission_base + 4), array('role_id' => $role_id_admin, 'permission_id' => $permission_base + 5), array('role_id' => $role_id_admin, 'permission_id' => $permission_base + 6));
DB::table('permission_role')->insert($permissions);
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id)
{
$user = $this->user->findOrFail($id);
$roles = array();
foreach (explode(', ', Input::get('roles')) as $role_name) {
if ($role = Role::where('role', '=', $role_name)->first()) {
$roles[] = $role->id;
}
}
$user->roles()->sync($roles);
return Redirect::route('users.show', $id);
}
public function delete($request, $response)
{
if (Auth::check() && Auth::user()->id != $request->id) {
$u = User::findOrFail($request->id);
$role = Role::where('user_id', $u->id)->first();
$role->delete();
$u->delete();
return $response->redirect('/dashboard/show', $code = 302);
} else {
return $response->redirect('/login', $code = 302);
}
}
public function run()
{
DB::table('users')->delete();
$users = array(array('username' => 'admin', 'fullname' => 'Administrator', 'email' => '*****@*****.**', 'password' => Hash::make('admin'), 'confirmed' => 1, 'confirmation_code' => md5(microtime() . Config::get('app.key')), 'created_at' => new DateTime(), 'updated_at' => new DateTime()), array('username' => 'user', 'fullname' => 'User', 'email' => '*****@*****.**', 'password' => Hash::make('user'), 'confirmed' => 1, 'confirmation_code' => md5(microtime() . Config::get('app.key')), 'created_at' => new DateTime(), 'updated_at' => new DateTime()));
DB::table('users')->insert($users);
$user = User::where('username', '=', 'admin')->first();
$adminRole = Role::where('name', '=', 'admin')->first();
$user->attachRole($adminRole);
$user = User::where('username', '=', 'user')->first();
$userRole = Role::where('name', '=', 'user')->first();
$user->attachRole($userRole);
}
public function post_index()
{
// $this->data[$this->views] = Role::order_by('id', 'asc')->get();
// echo "Valor Buscado: ".Input::get('buscar');
$buscado = Input::get('buscar');
// $roles = Role::where('slug', 'LIKE', $buscado . '%')->order_by('id', 'asc')->paginate(PER_PAGE_MEDIUM);
//
// foreach ($roles->results as $rol){
// echo 'Rol encontrado ID: '.$rol->id . '<br />';
// }
$this->data[$this->views] = Role::where('slug', 'LIKE', $buscado . '%')->order_by('id', 'asc')->paginate(PER_PAGE_MEDIUM);
return View::make('admin.' . $this->views . '.index', $this->data);
}
public function run()
{
DB::table('users')->delete();
$user = User::create(array('id' => 1, 'full_name' => 'Fredy Mendoza vargas', 'position' => 'Estudiante', 'code' => 'T00022051', 'email' => '*****@*****.**', 'password' => Hash::make('12345')));
$role = Role::where('name', '=', 'user')->get()->first();
$user->attachRole($role);
$user2 = User::create(array('id' => 2, 'full_name' => 'pepito perez', 'position' => 'Administrativo', 'code' => 'T000123', 'email' => '*****@*****.**', 'password' => Hash::make('12345')));
$role2 = Role::where('name', '=', 'user')->get()->first();
$user2->attachRole($role2);
$user3 = User::create(array('id' => 3, 'full_name' => 'Administrador', 'position' => 'admin', 'code' => 'T000111', 'email' => '*****@*****.**', 'password' => Hash::make('12345')));
$role3 = Role::where('name', '=', 'admin')->get()->first();
$user3->attachRole($role3);
}
