public function edit(Player $player)
{
$users = ['' => ''] + User::lists('name', 'id')->all();
$teams = Team::lists('name', 'id');
$statuses = Player::$statuses;
return view('backend.players.edit')->with('player', $player)->with('users', $users)->with('teams', $teams)->with('statuses', $statuses);
}
public function run()
{
Question::truncate();
$faker = Faker\Factory::create();
$authorIds = User::lists('id');
for ($i = 0; $i < 10; $i++) {
Question::create(['desc' => $faker->sentence, 'type' => $faker->word, 'status' => $faker->randomElement(array(0, 1)), 'author_id' => $faker->randomElement($authorIds)]);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker::create();
$topics = c2a(Topic::lists('id'));
$users = c2a(User::lists('id'));
foreach (range(1, 100) as $index) {
Reply::create(['topic_id' => $faker->randomElement($topics), 'user_id' => $faker->randomElement($users), 'content' => $faker->sentence(100)]);
}
}
public function run()
{
News::truncate();
$faker = Faker\Factory::create();
$authorIds = User::lists('id');
for ($i = 0; $i < 10; $i++) {
News::create(['title' => $faker->word, 'desc' => $faker->sentence, 'image_url' => $faker->imageUrl($width = 640, $height = 480), 'share_url' => $faker->url, 'status' => $faker->randomElement(array(0, 1)), 'author_id' => $faker->randomElement($authorIds)]);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker::create();
$products = c2a(Product::lists('id'));
$users = c2a(User::lists('id'));
foreach (range(1, 20) as $index) {
Topic::create(['title' => $faker->sentence(6), 'slug' => $faker->name, 'product_id' => $faker->randomElement($products), 'user_id' => $faker->randomElement($users), 'keywords' => $faker->sentence, 'description' => $faker->sentence(10), 'content' => $faker->sentence(100), 'page_view_count' => rand(10, 3059), 'vote_count' => rand(0, 199), 'reply_count' => rand(0, 100)]);
}
}
public function run()
{
Comment::truncate();
$faker = Faker\Factory::create();
$userIds = User::lists('id');
$postIds = Post::lists('id');
for ($i = 0; $i < 10; $i++) {
Comment::create(['desc' => $faker->sentence, 'user_id' => $faker->randomElement($userIds), 'post_id' => $faker->randomElement($postIds), 'status' => $faker->randomElement(array(0, 1))]);
}
}
public function run()
{
$faker = Faker::create();
$users = App\Models\User::all()->lists('id')->toArray();
$userIds = App\Models\User::lists('id');
foreach (range(1, 20) as $index) {
$firstname = $faker->firstname;
$lastname = $faker->lastname;
$username = str_replace('.', '_', $faker->unique()->userName);
$profile = Profile::create(['user_id' => $faker->randomElement($userIds), 'confirmed' => $faker->boolean($chanceOfGettingTrue = 50), 'is_active' => $faker->boolean($chanceOfGettingTrue = 50), 'is_fake' => true, 'activated' => $faker->boolean($chanceOfGettingTrue = 50), 'published' => $faker->boolean($chanceOfGettingTrue = 50), 'is_active' => $faker->boolean($chanceOfGettingTrue = 50), 'is_employee' => $faker->boolean($chanceOfGettingTrue = 50), 'is_public' => $faker->boolean($chanceOfGettingTrue = 50), 'website' => $faker->domainName, 'company' => $faker->company, 'uuid' => $faker->uuid, 'facebook_username' => $username . '_facebook', 'twitter_username' => $username . '_twitter', 'instagram_username' => $username . '_instagram', 'githubid' => $username . '_github', 'skypeid' => $username . '_skype', 'linkedinurl' => 'http://www.linkedin.com', 'googleplusurl' => 'http://plus.google.com', 'facebookurl' => 'http://www.facebook.com', 'birth_date' => $faker->date($format = 'm-d-Y', $max = 'now'), 'dob_month' => $faker->numberBetween($min = 1, $max = 12), 'dob_day' => $faker->numberBetween($min = 1, $max = 30), 'dob_year' => $faker->numberBetween($min = 1980, $max = 2010), 'pic' => $faker->imageUrl(600, 600, 'people', true, 'Faker'), 'username' => $username, 'display_name' => $firstname . " " . $lastname, 'about_me' => $faker->paragraph($nbSentences = 3), 'phone' => $faker->phoneNumber, 'phone_type' => 'Home', 'position' => 'employee', 'supervisor' => 'jaren', 'employment_title' => 'random employee', 'employment_role' => 'to follow nathan around the office', 'employment_status' => 'active', 'gender' => $faker->randomElement($array = ['Male', 'Female']), 'note' => $faker->bs, 'user_api_key' => str_random(32), 'user_api_secret' => str_random(64), 'user_activation_key' => str_random(128), 'activation_code_id' => str_random(128), 'activation_code' => str_random(15), 'confirmation_code' => str_random(4), 'profile_activated_on' => $faker->dateTimeBetween($startDate = '-2 years', $endDate = 'now'), 'published_on' => $faker->dateTimeBetween($startDate = '-2 years', $endDate = 'now'), 'slug' => $faker->slug, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now()]);
}
}
/**
* Get the summary user statistics
*
* @return db resultset
*/
public static function getSummaryUserStatistics($from, $to, $userID = 0)
{
$params = array($from, $to, $from, $to, $from, $to, $from, $to, $from, $to);
$users = array();
$data = array();
if ($userID == 0) {
$users = User::lists('id');
} else {
$users[] = $userID;
}
foreach ($users as $user) {
$userData = DB::select("SELECT u.name, u.designation, \n\t\t\t\t\t\tcount(DISTINCT IF(u.id=t.created_by AND (t.time_created BETWEEN ? AND ?),t.id,NULL)) AS created, \n\t\t\t\t\t\tcount(DISTINCT IF(u.id=t.tested_by AND (t.time_completed BETWEEN ? AND ?),t.id,NULL)) AS tested, \n\t\t\t\t\t\tcount(DISTINCT IF(u.id=t.verified_by AND (t.time_verified BETWEEN ? AND ?),t.id,NULL)) AS verified, \n\t\t\t\t\t\tcount(DISTINCT IF(u.id=s.accepted_by AND (s.time_accepted BETWEEN ? AND ?),t.id,NULL)) AS specimen_registered, \n\t\t\t\t\t\tcount(DISTINCT IF(u.id=s.rejected_by AND (s.time_rejected BETWEEN ? AND ?),t.id,NULL)) AS specimen_rejected \n\t\t\t\t\tFROM tests AS t \n\t\t\t\t\t\tLEFT JOIN specimens AS s ON t.specimen_id = s.id \n\t\t\t\t\t\tLEFT JOIN visits AS v ON t.visit_id = v.id \n\t\t\t\t\t\tINNER JOIN patients AS p ON v.patient_id = p.id \n\t\t\t\t\t\tCROSS JOIN users AS u \n\t\t\t\t\t\tWHERE u.id = {$user}\n\t\t\t\t\t\tGROUP BY u.id\n\t\t\t\t\t\tORDER BY u.name", $params);
$data = array_merge($data, $userData);
}
return $data;
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
$users = User::lists('first_name', 'first_name');
return view('visitors.create', compact('users'));
}
| Here you may define all of your model factories. Model factories give
| you a convenient way to create models for testing and seeding your
| database. Just tell the factory how a default model should look.
|
*/
use App\Models\User;
use App\Models\Source;
use App\Models\Map;
$factory->define(App\Models\User::class, function (Faker\Generator $faker) {
return ['name' => $faker->name, 'email' => $faker->email, 'password' => bcrypt(str_random(10)), 'api_token' => str_random(60), 'remember_token' => str_random(10)];
});
$factory->define(App\Models\Setting::class, function (Faker\Generator $faker) {
return ['group' => $faker->randomElement(['general', 'mapbox', 'preferences']), 'key' => $faker->word, 'value' => $faker->sentence];
});
$factory->define(App\Models\Map::class, function (Faker\Generator $faker) {
$users = User::lists('id')->toArray();
$hash = "";
do {
$hash = str_random(4);
} while (Map::where("hash", "=", $hash)->first() instanceof Map);
return ['hash' => $hash, 'user_id' => $faker->randomElement($users), 'active' => $faker->boolean(75), 'visibility' => $faker->randomElement(['public', 'public', 'public', 'shared', 'shared', 'private']), 'name' => $faker->sentence(6), 'description' => $faker->paragraph(2), 'style' => $faker->randomElement(['cilv7wj9m00uxbim8zml4zdz3', 'cikedqlyp00bbkqlxe7kzopov']), 'longitude' => 4.390819, 'latitude' => 51.92696, 'zoom' => $faker->numberBetween(8, 10), 'pitch' => $faker->numberBetween(10, 50), 'bearing' => $faker->numberBetween(20, 180), 'views' => $faker->numberBetween(1, 1000), 'created_at' => $faker->dateTimeBetween('-2 year', '-6 months'), 'updated_at' => $faker->dateTimeBetween('-5 months', 'now')];
});
$factory->define(App\Models\Source::class, function (Faker\Generator $faker) {
$hash = "";
do {
$hash = str_random(4);
} while (Source::where("hash", "=", $hash)->first() instanceof Source);
return ['hash' => $hash, 'origin_type' => $faker->randomElement(['url', 'url', 'url', 'url', 'file', 'dropbox', 'gdrive']), 'origin_url' => $faker->randomElement([null, $faker->url]), 'origin_file' => $faker->randomElement([null, 'whatever.csv']), 'origin_format' => $faker->randomElement(['csv', 'geojson']), 'origin_size' => $faker->numberBetween(100000, 15000000), 'name' => $faker->sentence(2), 'description' => $faker->sentence(20), 'web' => 'https://schiedam.dataplatform.nl/dataset/' . $faker->slug, 'sync_status' => $faker->randomElement(['ready', 'ready', 'ready', 'ready', 'ready', 'queued', 'downloading', 'processing', 'disabled', 'disabled', 'error']), 'sync_interval' => $faker->randomElement(['never', 'onchange', 'hourly', 'daily', 'weekly', 'monthly', 'yearly']), 'synced_at' => $faker->dateTimeBetween('-1 month', '-1 day'), 'created_at' => $faker->dateTimeBetween('-2 year', '-6 months'), 'updated_at' => $faker->dateTimeBetween('-5 months', 'now')];
});
$factory->define(App\Models\Tag::class, function (Faker\Generator $faker) {
return ['name' => $faker->word];
/**
* Show the form for editing the specified Tracking.
*
* @param int $id
*
* @return Response
*/
public function edit($id)
{
$tracking = $this->trackingRepository->findWithoutFail($id);
$facings = Facing::lists('name', 'id');
$products = Product::lists('name', 'id');
$brands = Brand::lists('name', 'id');
$users = User::lists('name', 'id');
if (empty($tracking)) {
Flash::error('Tracking not found');
return redirect(route('trackings.index'));
}
return view('trackings.edit')->with('tracking', $tracking)->with('facings', $facings)->with('products', $products)->with('brands', $brands)->with('users', $users);
}
