public function Usuarios($action = null)
{
if (isset($action)) {
if ($action == "create") {
$data = User::firstOrCreate(Input::except("_token", "_user"));
return $respuesta = array('Record' => $data, 'Result' => "OK");
}
if ($action == "edit") {
User::where("id", Input::get("id"))->update(Input::except("_token", "id", "_user"));
return $respuesta = array('Record' => User::find(Input::get('id')), 'Result' => "OK");
}
if ($action == "remove") {
User::where('id', Input::get("id"))->delete();
return '{"Result":"OK"}';
}
if ($action == "list") {
$Records = User::get();
$respuesta = array('Records' => $Records, 'Result' => "OK");
return json_encode($respuesta);
}
if ($action == "empresas") {
$nulos = DB::table('empresas')->select(DB::raw("'NO POSEE' as DisplayText, NULL as Value"));
$respuesta = DB::table('empresas')->select("nombre as DisplayText", "id as Value")->union($nulos)->orderby('value', 'asc')->distinct()->get();
return "var opciones=" . json_encode($respuesta);
}
}
}
public function testGet()
{
$users = User::get();
$this->assertEquals(3, $users->count());
$users = User::where('id', '>', 1)->get();
$this->assertEquals(2, $users->count());
// test chunk
User::chunk(2, function ($users) {
foreach ($users as $user) {
$this->assertInternalType('int', $user->id);
}
});
User::chunk(1, function ($users) {
$this->assertInstanceOf('Illuminate\\Support\\Collection', $users);
});
// test find with query builder
$user = User::where('id', '>', 1)->find(1);
$this->assertNull($user);
$user = User::where('id', '>', 1)->find(2);
$this->assertEquals(2, $user->id);
// test first without query builder
$user = User::first();
$this->assertInstanceOf('App\\User', $user);
// test retrieving aggregates
$max_id = User::max('id');
$this->assertGreaterThanOrEqual(3, $max_id);
$count = User::count();
$this->assertGreaterThanOrEqual(3, $count);
$sum = User::sum('id');
$this->assertGreaterThanOrEqual(6, $sum);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker::create();
foreach (Team::get() as $te) {
RelationTeUs::create(['team_id' => $te->id, 'user_coach_id' => $faker->numberBetween(1, count(User::get())), 'user_coach_aux_id' => $faker->numberBetween(1, count(User::get())), 'user_coordinador_id' => $faker->numberBetween(1, count(User::get())), 'user_cap_id' => $faker->numberBetween(1, count(User::get())), 'user_int2_id' => $faker->numberBetween(1, count(User::get())), 'user_int3_id' => $faker->numberBetween(1, count(User::get())), 'user_int4_id' => $faker->numberBetween(1, count(User::get()))]);
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$titulo = 'Usuarios';
$users = User::get();
//dd($users);
return view('painel.tables', compact('users', 'titulo'));
}
function user()
{
$data = User::get();
// print_r($data);
// die;
return view('user.home')->with('users', $data);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//
$users = User::get();
$heading = 'User Management';
return view('admin.users', array('users' => $users, 'heading' => $heading));
}
public function userPosts()
{
$posts = \App\Posts::where('user_id', '=', \Auth::user()->id)->orderBy("created_at", "desc")->get();
$search_info = "";
$data = array('posts' => $posts, 'search_info' => \Auth::user()->name . '\'s posts', 'users' => \App\User::get());
return view('home')->with($data);
}
/**
* Display users management view.
*
* @return \Illuminate\Http\Response
*/
public function users()
{
$users = User::all()->count();
$requests = collect(Invitation::where('status', 1)->orWhere('status', 2)->orWhere('status', 4)->get());
$lastest_users = User::get()->take(7);
return view('sys/pages/users/view-all')->with(['users' => $users, 'requests' => $requests->count(), 'latest_users' => $lastest_users]);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
if (Request::isMethod('get')) {
$this->data['items'] = User::get();
return view('pages.user.index', $this->data);
} elseif (Request::isMethod('post')) {
}
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$rodeos = Rodeos::paginate(10);
//print_r($animales); die();
$potreros = Potreros::get()->all();
$users = User::get()->all();
return view('rodeos.index', ['rodeos' => $rodeos, 'potreros' => $potreros, 'users' => $users]);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index($id)
{
$this->data['users'] = User::get();
$this->data['artikel'] = Artikel::where('kategori_id', '=', $id)->get();
$this->data['kategori'] = Kategori::find($id);
$this->data['id_kategori'] = $id;
return view('admin.article.manage', $this->data);
}
public function run()
{
$faker = Faker::create();
$users = User::get();
#Category
foreach (range(1, 20) as $void) {
Log::create(['user_id' => $users->random(1)->id, 'type' => $faker->text(10), 'source_id' => $faker->numberBetween(50, 1000000), 'details' => $faker->text(50)]);
}
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
$users = User::get();
// Get all the current users and associate them with manchester (MCR).
foreach ($users as $user) {
$user->city_id = null;
$user->save();
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker\Factory::create();
$users = User::get()->lists('id')->all();
$products = Product::get()->lists('id')->all();
foreach (range(1, 30) as $index) {
Bid::create(['amount' => $faker->randomNumber(), 'user_id' => $faker->randomElement($users), 'product_id' => $faker->randomElement($products)]);
}
}
public function checkout()
{
if (\Auth::guest()) {
return redirect('auth/login');
}
$shoppingCarts = customer_item::where('customer_id', '=', \Auth::user()->id)->get();
// get all selected shopping cart product from customer_items table
$users = User::get();
return view('Pages.checkout', compact('users', 'shoppingCarts'));
}
public function run()
{
$faker = Faker::create();
$actions = ActionType::get();
$users = User::get();
#Category
foreach (range(1, 20) as $void) {
Comment::create(['user_id' => $users->random(1)->id, 'action_type_id' => $actions->random(1)->id, 'source_id' => $faker->numberBetween(50, 1000000), 'comment' => $faker->text(50)]);
}
}
public function getUsuarios(Request $request)
{
$users = User::get();
$view = View::make('adminSuper.usuariosComunes')->with(['users' => $users]);
if ($request->ajax()) {
$sections = $view->renderSections();
$response = Response::json(['success' => true, 'data' => $sections['usuarios']], 200);
} else {
$response = $view;
}
return $response;
}
public function view($projectId)
{
$param['pageNo'] = 1;
$param['projectId'] = $projectId;
$param['tasks'] = TaskModel::where('project_id', $projectId)->orderBy('sequence')->paginate(10);
$param['users'] = UserModel::get();
$param['projectId'] = $projectId;
if (Session::has('alert')) {
$param['alert'] = Session::get('alert');
}
return View::make('company.project.view')->with($param);
}
public function boollogin()
{
$Inputdata = array("username" => Input::get("username"), "password" => Input::get("password"));
foreach (User::get() as $user) {
if (strtolower($user->acc) == strtolower($Inputdata["username"]) && $user->pass == $Inputdata["password"]) {
Session::put("login", "true");
Session::put("nameuser", $user->name);
return true;
}
}
Session::put("login", "false");
return false;
}
public function index()
{
$tab = 'dashboard';
$users = User::get();
$usersCount = $users->count();
$activeUsers = $users->where('active', 1)->count();
$inactiveUsers = $usersCount - $activeUsers;
$roles = Role::get();
$rolesCount = $roles->count();
$usersWithRole = DB::table('role_user')->count();
$permissionsCount = Permission::get()->count();
return view('admin.dashboard', compact('tab', 'usersCount', 'activeUsers', 'inactiveUsers', 'rolesCount', 'usersWithRole', 'permissionsCount'));
}
public function sharing($id)
{
$entry = FileRecord::where('id', '=', $id)->firstOrFail();
$rawSharing = (array) json_decode($entry->sharing);
$docType = $entry->doc_type_id;
$users = User::get();
$sharedUsers = (array) $rawSharing['users'];
$departments = Department::get();
$sharedDepartments = (array) $rawSharing['departments'];
$editors = (array) json_decode($entry->user_editor);
$mass = $rawSharing['mass'];
return view('modals.sharingModal')->with('sharedUsers', $sharedUsers)->with('editors', $editors)->with('docType', $docType)->with('users', $users)->with('departments', $departments)->with('sharedDepartments', $sharedDepartments)->with('mass', $mass)->with('id', $id);
}
public function newUser(CreateUserRequest $request)
{
$input = $request->all();
User::create($input);
if (Session::get('errors') == "") {
$errorCode = 0;
$errorMessage = null;
}
\Session::flash('key', $input['_token']);
$id = User::get()->where('UserName', $input['UserName'])->where('Password', $input['Password']);
$showId = last(array_flatten($id))['id'];
return $array = ['ErrorCode' => $errorCode, 'ErrorMessage' => $errorMessage, 'Data' => ['UserId' => $showId, 'SessionId' => Session::get('key'), 'UserName' => $input['UserName']]];
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('users', function (Blueprint $table) {
$table->string('slug')->nullable();
});
// Get records from old column.
$users = User::get();
// Get all the old users first and last name and smush them together into a username
foreach ($users as $user) {
$first_name = $user->name_first;
$last_name = $user->name_last;
$user->username = $first_name . ' ' . $last_name;
$user->save();
}
}
public function run()
{
$faker = Faker::create();
$users = User::get()->toArray();
foreach ($users as $user) {
//dd($user);
foreach (range(1, 10) as $void) {
$sender_id = $user['id'];
while ($sender_id == $user['id']) {
$sender_id = $faker->randomElement($users)['id'];
}
Notice::create(['user_id' => $user['id'], 'sender_id' => $sender_id, 'source_id' => $faker->numberBetween(50, 1000000), 'title' => $faker->text(50), 'message' => $faker->text(150), 'status' => $faker->randomElement(['read', 'unread', 'new']), 'type' => $faker->randomElement(['info', 'danger', 'warning', 'success'])]);
}
}
}
public function home(Content $content, Ticket $ticket, User $user, Application $application, BusinessUnit $businessUnit)
{
//FIND USERS WITH SUBMITTED TICKETS
$users_with_tickets = User::has('tickets')->get();
//USERS WHO ARE NOT ADMIN
$non_admin_users = $user->notAdmin()->get();
$admin_users = $user->admins()->get();
$tickets_all = $ticket->all()->count();
$tickets_c = $ticket->completed()->get()->count();
$prj_brief_records = $content->latest()->brief()->get();
$prj_notes_records = $content->latest()->notes()->get();
$status_records = $content->latest()->status()->get();
$applications = $application->get();
$users = $user->get();
return view('pages.home', compact('prj_notes_records', 'status_records', 'tickets_c', 'tickets_all', 'users_with_tickets', 'applications', 'non_admin_users', 'admin_users', 'users'));
}
public function run()
{
$faker = Faker::create();
$users = User::get();
$products = Product::get();
for ($i = 0; $i < 10; $i++) {
$user = $users->random(1);
$status = $faker->randomElement(['open', 'paid', 'pending', 'installed', 'cancelled']);
$order = Order::create(['user_id' => $user->id, 'status' => $status, 'end_date' => $status == 'installed' || $status == 'cancelled' ? $faker->dateTime() : null]);
$random = $faker->numberBetween(1, 2);
for ($y = 0; $y < $random; $y++) {
$product = $products->random(1);
OrderDetail::create(['order_id' => $order->id, 'product_id' => $product->id, 'price' => $product->price, 'quantity' => 1]);
}
}
}
/**
* return json user
*/
public function getUsers($id)
{
if ($id == "pm") {
$idus = UserGroup::distinct()->where("group_id", "=", 6)->orWhere("group_id", "=", 11)->groupBy('user_id')->get(array("user_id"));
$user = array();
foreach ($idus as $key) {
array_push($user, User::get(array("fullname", "id"))->find($key['user_id']));
}
return json_encode($user);
} else {
$i = UserGroup::distinct()->where('group_id', '<>', 11)->groupBy('user_id')->get();
$u = array();
foreach ($i as $key) {
array_push($u, User::get(array("fullname", "id"))->find($key['user_id']));
}
return json_encode($u);
}
}
public function EV3()
{
$faker = Faker::create();
$data = CombatRound::where('challenge_id', '=', 1)->get();
foreach ($data as $d) {
$score1 = $faker->numberBetween($min = 2, $max = 3);
$score2 = $faker->numberBetween($min = 2, $max = 3);
if ($score1 == 3 && $score2 == 3) {
$score1 = $score1 - 1;
}
if ($score1 == 2 && $score2 == 2) {
$score2 = $score2 + 1;
}
if ($score1 > $score2) {
$win = $d['versus_one'];
} else {
if ($score2 > $score1) {
$win = $d['versus_two'];
}
}
Sumo::create(['combat_id' => $d['id'], 'team_id_win' => $win, 'team_id_one' => $d['versus_one'], 'scort_team_one' => $score1, 'firm_team_one' => $faker->numberBetween($min = 1, $max = count(User::get())), 'team_id_two' => $d['versus_two'], 'scort_team_two' => $score2, 'firm_team_two' => $faker->numberBetween($min = 1, $max = count(User::get()))]);
}
}
* Institucional
*/
Route::get('termos', function () {
return view('site.termos');
});
Route::get('newsletter', function () {
return view('site.mail');
});
Route::get('privacidade', function () {
return view('site.privacidade');
});
/**
* API
*/
Route::get('api/users', ['middleware' => 'cors', function () {
return \Response::json(\App\User::get(), 200);
}]);
Route::get('api/markers', ['middleware' => 'cors', function () {
return \Response::json(\App\Mark::get(), 200);
}]);
Route::post('api/markers', ['middleware' => 'cors', function () {
return \Response::json(\App\Mark::get(), 200);
}]);
Route::get('api/contributors', ['middleware' => 'cors', function () {
return \Response::json(\App\Contributor::get(), 200);
}]);
Route::get('api/posts', ['middleware' => 'cors', function () {
return \Response::json(\App\Posts::get(), 200);
}]);
Route::get('api/news', ['middleware' => 'cors', function () {
return \Response::json(\App\Posts::get(), 200);
public function edit($id)
{
return view('playthrough.edit', ['players' => User::get(['id', 'nickname', 'profile_photo']), 'games' => Game::get(['id', 'name', 'photo']), 'playthrough' => Playthrough::find($id), 'p_id' => $id]);
}
