/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
//create lab submissions
for ($i = 1; $i <= 10; $i++) {
App\Submission::create(['name' => 'Lab ' . $i, 'due_date' => Carbon\Carbon::createFromDate(2016, rand(8, 12), rand(1, 30)), 'total' => rand(10, 30), 'evaluation_id' => 3, 'active' => true, 'bonus' => false]);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
//
DB::table('cewas')->insert(['cewa_name' => 'CT112233', 'cewa_level' => '1', 'cewa_description' => 'Do this and do that', 'cewa_submitted_date' => Carbon\Carbon::createFromDate(2014, 5, 1)->toDateTimeString(), 'cewa_start_date' => Carbon\Carbon::createFromDate(2014, 5, 6)->toDateTimeString(), 'cewa_end_date' => Carbon\Carbon::createFromDate(2014, 5, 11)->toDateTimeString()]);
DB::table('cewas')->insert(['cewa_name' => 'CT112244', 'cewa_level' => '3', 'cewa_description' => 'Build this and destroy that', 'cewa_submitted_date' => Carbon\Carbon::createFromDate(2014, 5, 11)->toDateTimeString(), 'cewa_start_date' => Carbon\Carbon::createFromDate(2014, 5, 16)->toDateTimeString(), 'cewa_end_date' => Carbon\Carbon::createFromDate(2014, 5, 21)->toDateTimeString()]);
DB::table('cewas')->insert(['cewa_name' => 'CT112255', 'cewa_level' => '1', 'cewa_description' => 'Go there and watch this', 'cewa_submitted_date' => Carbon\Carbon::createFromDate(2014, 5, 21)->toDateTimeString(), 'cewa_start_date' => Carbon\Carbon::createFromDate(2014, 5, 26)->toDateTimeString(), 'cewa_end_date' => Carbon\Carbon::createFromDate(2014, 6, 11)->toDateTimeString()]);
}
public function run()
{
$news_repo = app(NewsRepositoryInterface::class);
// we remove all the files in the config folder
$files = glob(storage_path('app/news/*'));
foreach ($files as $file) {
if (is_file($file)) {
unlink($file);
}
}
// we create the folder if it doesn't exist
if (!is_dir($storage_path = storage_path('app/news'))) {
if (!is_dir($path = storage_path('app'))) {
mkdir($path);
}
mkdir($path . '/news');
}
// we insert the news page content
$file_name = ImageManager::optimizeAndResize(database_path('seeds/files/news/una_news.jpg'), config('image.news.background_image.name'), 'jpg', config('image.news.storage_path'), config('image.news.background_image.sizes'), false);
$inputs = ['title' => 'Les actualités du club Université Nantes Aviron (UNA)', 'description' => "## Vie du club & actualités sportives\r\n\r\nA partir de cette page, suivez les actualités du club Université Nantes Aviron (UNA).\r\nRésultats sportifs, annonces d'événements, compte-rendus de déplacements ou autres annonces diverses...\r\nNe perdez pas une miette de la vie du club !", 'background_image' => $file_name];
file_put_contents(storage_path('app/news/content.json'), json_encode($inputs));
// we create the news
$news = $news_repo->create(['author_id' => app(UserRepositoryInterface::class)->where('last_name', 'LORENT')->first()->id, 'category_id' => config('news.category_key.club'), 'key' => "rentree-2015-3-sessions-de-portes-ouvertes-a-l-una", 'title' => "Rentrée 2015 : 3 sessions de portes-ouvertes à l'UNA", 'meta_title' => 'Rentrée 2015 : portes-ouvertes', 'meta_description' => null, 'meta_keywords' => 'club, université, nantes, aviron, portes, ouvertes, rentree, 2015, sportive', 'released_at' => Carbon\Carbon::createFromDate(2015, 9, 1)->hour(17)->minute(33), 'content' => "Vous ne savez pas quel sport choisir cette année ? \r\nVous pensez à l'aviron sans n'avoir jamais osé vous lancer ? \r\nLe club Université Nantes vous convie à ses portes-ouvertes, l'occasion rêvée de vous essayer gratuitement à notre sport ! \r\n## C'est quand ? \r\nNous vous accueillons les samedis 12 septembre, 19 septembre et 10 octobre, de 10h à 17h, sans interuption. Nous misons naturellement sur des journées ensoleillées pour vous accueillir de la plus agréable des manières, cependant n'ayez crainte si quelques gouttes de pluie font leur apparition, la pratique demeure possible. \r\n## Le programme ? \r\nDes initiations gratuites pour toute la famille (à partir de 10 ans), encadrée par nos professionnels et bénévoles ! Vous vous familiariserez avec la planche à ramer, une embarcation pour débutants qui permet de découvrir le mouvement et les premières sensations de l'aviron. Pas de panique, la planche à ramer est (quasiment) insubmersible ! \r\n## Découvrez le club Université Nantes Aviron (UNA) ! \r\nL'UNA est LE club d'aviron universitaire de Nantes. Nous accueillons à la fois un public d'étudiants à l'Université de Nantes ou dans les écoles supérieures nantaises, mais également des plus jeunes à l'Ecole d'Aviron (entre 10 et 18 ans), ainsi que des moins jeunes (population d'actifs, quelque soit l'age ou le type de pratique). \r\nPour en savoir plus, rendez-vous sur notre [présentation du club](../#una 'Présentation du club'). \r\n\r\nEt pour toute question, n'hésitez pas, [contactez-nous](#contact 'Contactez-nous') ! \r\nA bientôt au club Université Nantes Aviron", 'active' => false]);
// we optimize and resize the news image
$file_name = \ImageManager::optimizeAndResize(database_path('seeds/files/news/news_po_una_september.jpg'), $news->imageName('image'), 'jpg', $news->storagePath(), $news->availableSizes('image'), false);
$news->image = $file_name;
$news->save();
// we create the news
$news = $news_repo->create(['author_id' => app(UserRepositoryInterface::class)->where('last_name', 'LORENT')->first()->id, 'category_id' => config('news.category_key.club'), 'key' => "lancement-du-nouveau-site-internet-de-l-una", 'title' => "Lancement du nouveau site Internet de l'UNA !", 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => 'club, université, nantes, aviron, nouveau, site, internet, web', 'released_at' => Carbon\Carbon::createFromDate(2016, 5, 6)->hour(10)->minute(00), 'content' => "## Bienvenue sur notre nouveau site Internet !\r\nNous vous souhaitons la bienvenue sur le **nouveau site Internet du club Université Nantes Aviron (UNA)**.\r\nNous sommes heureux de vous présenter notre nouvel outil, vecteur de nos futures communication et qui permettra à tous d'accéder de manière plus facile et efficace à toutes les informations concernant l'UNA.\r\n## Toutes vos informations accessibles en ligne\r\nA travers notre nouveau site, consultez régulièrement nos [actualités sportive ou nouveautés à propos de la vie du club](../../actualites), qui seront automatiquement relayées sur nos réseaux sociaux ([Facebook](https://www.facebook.com/UniversiteNantesAviron), [Twitter](https://twitter.com/unaclub), [Google+](https://plus.google.com/+Univ-nantes-avironFr)). Découvrez également l'[historique du club](../../page/historique), l'[équipe dirigeante](../../equipe-dirigeante) de notre structure, nos [statuts associatifs](../../page/statuts), ainsi que notre [règlement intérieur](../../page/reglement-interieur). Enfin, prenez connaissance de nos [tarifs d'inscription](../../inscription), consultez nos [créneaux horaires](../../horaires) et assurez vous de rester informés de nos événements grâce à notre [calendrier](../../calendrier).\r\n## L'UNA dans votre poche\r\nDe design dit \"Responsive\", ce site **s'adapte à la taille de votre terminal** et vous permet d'accéder à toutes les pages et fonctionnalités proposées depuis vos smartphones, tablettes, ordinateurs portables ou de bureau. Grâce à cela, gardez un oeil sur le club Université Nantes Aviron (UNA), que vous soyiez en déplacement ou à la maison.\r\n## Une plateforme évolutive et collaborative\r\nLoin d'être un outil figé, le site du club Université Nantes Aviron (UNA) se veut **évolutif et à l'écoute de ses utilisateurs**. Il s'agit d'un outil fait par l'UNA et pour l'UNA. C'est ainsi que les actualités, par exemple, seront régulièrement rédigées par une équipe de rédacteurs qui ne sont autres que des rameurs du club. De plus, de nouvelles fonctionnalités telles qu'une page mettant en avant le palmares de l'UNA, un nouveau système de souscription de licence en ligne, une boutique du club en ligne, ... sont autant de fonctionnalités déjà sur le feu !\r\nNous n'en disons pas plus et vous laissons découvrir par vous même notre nouveau site.\r\nVous avez une question, vous souhaitez en savoir plus sur le club ? N'hésitez pas, [contactez-nous](../../#contact) !\r\nA bientôt au club Université Nantes Aviron (UNA).", 'active' => true]);
// we optimize and resize the news image
$file_name = \ImageManager::optimizeAndResize(database_path('seeds/files/news/news_una_new_website.jpg'), $news->imageName('image'), 'jpg', $news->storagePath(), $news->availableSizes('image'), false);
$news->image = $file_name;
$news->save();
}
public function __clone()
{
$this->id = null;
$this->maestro = false;
$this->publicado = false;
$this->desde = Carbon\Carbon::createFromDate(1111, 1, 1);
$this->hasta = null;
$this->exists = false;
}
function display_regdate($user)
{
if ($user->user_regdate < Carbon\Carbon::createFromDate(2008, 1, 1)) {
return trans("users.show.first_members");
}
return trans("users.show.joined_at", ["date" => $user->user_regdate->formatLocalized("%B %Y")]);
}
function display_regdate($user)
{
if ($user->user_regdate < Carbon\Carbon::createFromDate(2008, 1, 1)) {
return trans('users.show.first_members');
}
return trans('users.show.joined_at', ['date' => $user->user_regdate->formatLocalized('%B %Y')]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('goats')->insert(array(array('type' => 'G', 'parent_id' => null, 'description' => 'Transform Communities', 'complete' => false, 'priority' => 0, 'goal_type' => 'B', 'due_date' => null, 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => null, 'success_measure' => null), array('type' => 'G', 'parent_id' => null, 'description' => 'Evolve our digital environment', 'complete' => false, 'priority' => 0, 'goal_type' => 'B', 'due_date' => null, 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => null, 'success_measure' => null), array('type' => 'G', 'parent_id' => null, 'description' => 'Act as a catalyst for learning, discovery and creating', 'complete' => false, 'priority' => 0, 'goal_type' => 'B', 'due_date' => null, 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => null, 'success_measure' => null), array('type' => 'G', 'parent_id' => null, 'description' => 'Transition the way we do business', 'priority' => 0, 'complete' => false, 'goal_type' => 'B', 'due_date' => null, 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => null, 'success_measure' => null), array('type' => 'O', 'parent_id' => 1, 'description' => 'We identify and meet community needs', 'complete' => false, 'priority' => 1, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2016, 1, 1), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => null, 'success_measure' => null), array('type' => 'A', 'parent_id' => 5, 'description' => 'Review public computing needs and develop strategies to meet those needs', 'priority' => 3, 'complete' => true, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 3, 1), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 1, 'success_measure' => 'Achieve an 90% satisfaction rating; Increase computer usage by 20%'), array('type' => 'T', 'parent_id' => 6, 'description' => 'Implement approved recommendations from the 2015 Public Computing Report', 'priority' => 2, 'complete' => true, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 3, 1), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 6, 'description' => 'Hire more people to help upgrade LibOnline to the latest version (4.9)', 'complete' => true, 'priority' => 3, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 6, 12), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 3, 'success_measure' => null), array('type' => 'T', 'parent_id' => 6, 'complete' => false, 'description' => 'Pay wireless bill', 'priority' => 1, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2016, 5, 3), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 4, 'success_measure' => null), array('type' => 'O', 'parent_id' => 1, 'description' => 'We reduce barriers to accessing library services', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2016, 7, 4), 'budget' => 10000, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => null, 'success_measure' => null), array('type' => 'A', 'parent_id' => 10, 'description' => 'Establish a fine-free day to take place every second year', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2016, 5, 2), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 5, 'success_measure' => null), array('type' => 'T', 'parent_id' => 11, 'description' => 'Provide planning assistance to the Customer Payments team to implement the necessary changes to support a fine-free day', 'priority' => 1, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2016, 7, 6), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 1, 'success_measure' => null), array('type' => 'A', 'parent_id' => 10, 'description' => 'Extend literacy van services to underserved communities in Edmonton and surrounding areas', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 6, 1), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => 'Increased use and knowledge of EPL services in underserved communities'), array('type' => 'T', 'parent_id' => 13, 'description' => 'Aid in the selection, purchase, and configuration of equipment for the fourth literacy van', 'priority' => 1, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2015, 7, 6), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 3, 'success_measure' => 'Equipment purchased, configured, and deployed'), array('type' => 'O', 'parent_id' => 2, 'description' => 'The ease of use and integration of content is praised by customers', 'priority' => 3, 'complete' => true, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 6, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => null, 'success_measure' => null), array('type' => 'A', 'parent_id' => 15, 'description' => 'Implement a single point of discovery for EPL content', 'priority' => 2, 'complete' => true, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 5, 'success_measure' => 'Achieve an 90% satisfaction rating with services and content'), array('type' => 'T', 'parent_id' => 16, 'description' => 'Liaise with Sirsi Dynix to support CMA\'s Single Sign On (SSO) project', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => 'SSO is implemented'), array('type' => 'G', 'parent_id' => null, 'description' => 'IT Services Goals', 'priority' => 2, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'O', 'parent_id' => 18, 'description' => 'Test Windows 10 in EPL\'s environment and develop a deployment plan ', 'priority' => 1, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'O', 'parent_id' => 19, 'description' => 'Mobile Device Management (MDM) documentation and roll out', 'priority' => 2, 'complete' => true, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'G', 'parent_id' => null, 'description' => 'Events Team Goals', 'priority' => 2, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 1, 'success_measure' => null), array('type' => 'G', 'parent_id' => null, 'description' => 'Human Resources Goals', 'priority' => 2, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 3, 'success_measure' => null), array('type' => 'G', 'parent_id' => null, 'description' => 'Financial Services Goals Goals', 'priority' => 2, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 4, 'success_measure' => null), array('type' => 'G', 'parent_id' => null, 'description' => 'Marketing Goals', 'priority' => 2, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 5, 'success_measure' => null), array('type' => 'G', 'parent_id' => null, 'description' => 'Fund Development Goals', 'priority' => 2, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 6, 'success_measure' => null), array('type' => 'G', 'parent_id' => null, 'description' => 'Collection Management and Access Goals', 'priority' => 2, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 7, 'success_measure' => null), array('type' => 'G', 'parent_id' => null, 'description' => 'School Aged Services (SAS) Team Goals', 'priority' => 2, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 8, 'success_measure' => null), array('type' => 'G', 'parent_id' => null, 'description' => 'Community-Led Team Goals', 'priority' => 2, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 9, 'success_measure' => null), array('type' => 'G', 'parent_id' => null, 'description' => 'Foundational Programming Team Goals', 'priority' => 2, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 10, 'success_measure' => null), array('type' => 'G', 'parent_id' => null, 'description' => 'Membership Services Team Goals', 'priority' => 2, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 11, 'success_measure' => null), array('type' => 'G', 'parent_id' => null, 'description' => 'Discovery Team Goals', 'priority' => 2, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 12, 'success_measure' => null), array('type' => 'O', 'parent_id' => 3, 'description' => 'act as a catalyst for learning, discovering and creating', 'priority' => 2, 'complete' => true, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 2, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'A', 'parent_id' => 32, 'description' => 'Develop an Open Data policy that includes how we will use and share our own data; participate in Edmonton\'s Open Data community and support data literacy initiatives.', 'priority' => 2, 'complete' => true, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 2, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 33, 'description' => 'Release more EPL open data to City of Edmonton open data portal.', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'O', 'parent_id' => 3, 'description' => 'EPL is a staff of learners confident in their abilities to assist customers', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'A', 'parent_id' => 35, 'description' => 'Review technology needs to provide services and implement strategies to meet them', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 36, 'description' => 'Support the ILS team\'s implementation of Mobile Circ', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 36, 'description' => 'Purchase new iPad kits for each branch currently without one per budget request', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 36, 'description' => 'Purchase laptop kits for each branch currently without one per budget request', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 36, 'description' => 'In collaboration with DLI, select equipment to replace aging Makerspace equipment', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 36, 'description' => 'Implement a regular "What\'s up with that?" style blog post by IT to enhance staff understanding of technology', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 36, 'description' => 'Stabilize and standardize the display board environment', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'O', 'parent_id' => 4, 'description' => 'We have transformed our approach to service delivery and use of physical spaces', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'A', 'parent_id' => 43, 'description' => 'Complete reviews to ensure ongoing improvement of interlibrary loans, custodial, service point operations, and others. ', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 44, 'description' => 'Compare IT\'s current ticketing sytems against demos of inexpensive, focused ticketing systems to determine if a migration can and should occur.', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 44, 'description' => 'Conduct a literature review of Help Desk best practices to determine how EPL\'s processes can be improved', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 44, 'description' => 'Create an Internal Service Level Agreement document outlining IT\'s processes and commitments to its customers', 'priority' => 2, 'complete' => false, 'goal_type' => 'B', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 20, 'description' => 'Create internal documentation for each profile (i.e. Early literacy and Mini-makerspace) applied to EPL iPads by EPL\'s Mobile Device Management software', 'priority' => 2, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 20, 'description' => 'Develop and implement an implementation plan for rolling EPL\'s Mobile Device Management tool out to all pre-existing kit iPads', 'priority' => 2, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 20, 'description' => 'Complete a cost/benefit analysis of using EPL\'s MDM to secure manager iPads', 'priority' => 2, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2017, 1, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 19, 'description' => 'Develop a test plan to determine if EPL is ready to move to Windows 10', 'priority' => 1, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 19, 'description' => 'Determine the budget implications of upgrading to Windows 10', 'priority' => 1, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null), array('type' => 'T', 'parent_id' => 19, 'description' => 'Develop a deployment/upgrade plan to migrate to Windows 10 if appropriate', 'priority' => 1, 'complete' => false, 'goal_type' => 'D', 'due_date' => Carbon\Carbon::createFromDate(2018, 8, 7), 'budget' => 0, 'created_at' => Carbon\Carbon::now(), 'updated_at' => Carbon\Carbon::now(), 'bid' => 1, 'department_id' => 2, 'success_measure' => null)));
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
/**
* Create 10 events
*/
$featuredCount = 0;
//no more than 4
for ($i = 0; $i < 10; $i++) {
if ($featuredCount < 4) {
$featured = rand(0, 1);
if ($featured == 1) {
$featuredCount += 1;
}
} else {
$featured = 0;
}
$year = 2016;
$month = rand(5, 12);
$startDate = rand(8, 28);
$endDate = $startDate + 2;
$closingDate = $startDate - 7;
$statuses = array('unpublished', 'published', 'published', 'published');
$status = $statuses[array_rand($statuses, 1)];
$late = array_rand(array(0, 1), 1);
$lateFee = 0;
if ($late == 1) {
$lateFee = rand(0, 10);
}
$reg = array_rand(array(0, 1), 1);
$regFee = 0;
if ($reg == 1) {
$regFee = rand(0, 10);
}
$event_id = DB::table('events')->insertGetId(['user_id' => 1, 'name' => 'Awesome event ' . $i, 'slug' => Str::slug('Awesome event ' . $i), 'description' => 'This is the event description.', 'postcode' => 'YO24 4QP', 'startDate' => Carbon\Carbon::createFromDate($year, $month, $startDate, 'Europe/London'), 'endDate' => Carbon\Carbon::createFromDate($year, $month, $endDate, 'Europe/London'), 'closingDate' => Carbon\Carbon::createFromDate($year, $month, $closingDate, 'Europe/London'), 'paypal' => '*****@*****.**', 'status' => $status, 'lateEntries' => $late, 'lateEntriesFee' => $lateFee, 'registration' => $reg, 'registrationFee' => $regFee, 'featured' => $featured, 'currency' => 'GBP', 'imageFilename' => $i . ".jpg"]);
//Create between 5-15 competitions
for ($j = 0; $j < rand(5, 15); $j++) {
$comp_id = DB::table('competitions')->insertGetId(['event_id' => $event_id, 'name' => 'Competition ' . $j, 'description' => 'This is the competition description.', 'fee' => rand(5, 25)]);
//Create 1-3 details
$numDetails = rand(1, 3);
for ($k = 0; $k < $numDetails; $k++) {
$hour = rand(0, 23);
$minutes = array('00', '15', '30', '45');
$minute = $minutes[array_rand($minutes, 1)];
$max = rand(5, 25);
$detail_id = DB::table('details')->insertGetId(['competition_id' => $comp_id, 'name' => 'Qualification ' . $k, 'max' => $max, 'dateTime' => Carbon\Carbon::create($year, $month, $startDate, $hour, $minute, '00', 'Europe/London')]);
}
}
//we've created competitions and details for this event. now do some entries
$event = Event::findOrFail($event_id);
foreach ($event->competitions()->get() as $competition) {
$users = User::all()->keyBy('id');
$users->forget(1);
$details = $competition->details()->get();
$detail = $details->random();
for ($e = 0; $e < rand(1, 20); $e++) {
$user = $users->random();
DB::table('entries')->insert(['user_id' => $user->id, 'event_id' => $event_id, 'competition_id' => $competition->id, 'detail_id' => $detail->id, 'transaction_id' => null, 'user_lastname' => $user->lastname, 'paymentStatus' => 'paid']);
$users->forget($user->id);
$detail = $details->random();
}
}
}
}
public function getLedgerSummary($corporationID)
{
if (!\Auth::isSuperUser()) {
if (!in_array($corporationID, Session::get('valid_keys')) && !\Auth::hasAccess('wallet_manager')) {
App::abort(404);
}
}
// Get the month/year data
$available_dates = DB::table('corporation_walletjournal')->select(DB::raw('DISTINCT(MONTH(date)) AS month, YEAR(date) AS year'))->where('corporationID', $corporationID)->orderBy(DB::raw('year, month'), 'desc')->get();
// Parse the available dates and sort the array
$ledger_dates = array();
foreach ($available_dates as $date) {
$ledger_dates[] = Carbon\Carbon::createFromDate($date->year, $date->month)->toDateString();
}
arsort($ledger_dates);
// Get some data for the global ledger prepared
// Current Corporation Wallet Balances
$wallet_balances = DB::table('corporation_accountbalance')->join('corporation_corporationsheet_walletdivisions', 'corporation_accountbalance.accountKey', '=', 'corporation_corporationsheet_walletdivisions.accountKey')->where('corporation_corporationsheet_walletdivisions.corporationID', $corporationID)->where('corporation_accountbalance.corporationID', $corporationID)->get();
$wallet_balances_total = 0;
foreach ($wallet_balances as $div) {
$wallet_balances_total += $div->balance;
}
// The overall corporation ledger. We will loop over the wallet divisions
// and get the ledger calculated for each
$ledgers = array();
foreach (EveCorporationCorporationSheetWalletDivisions::where('corporationID', $corporationID)->get() as $division) {
$ledgers[$division->accountKey] = array('divisionName' => $division->description, 'ledger' => DB::table('corporation_walletjournal')->select('refTypeName', DB::raw('sum(`amount`) `total`'))->leftJoin('eve_reftypes', 'corporation_walletjournal.refTypeID', '=', 'eve_reftypes.refTypeID')->where('corporation_walletjournal.accountKey', $division->accountKey)->where('corporation_walletjournal.corporationID', $corporationID)->groupBy('corporation_walletjournal.refTypeID')->orderBy('refTypeName')->get(), 'total' => DB::table('corporation_walletjournal')->select(DB::raw('sum(`amount`) `total`'))->where('corporation_walletjournal.accountKey', $division->accountKey)->where('corporation_walletjournal.corporationID', $corporationID)->pluck('total'));
}
// Tax contributions
$bounty_tax = DB::table('corporation_walletjournal')->select('ownerID2', 'ownerName2', DB::raw('SUM(corporation_walletjournal.amount) total'))->leftJoin('eve_reftypes', 'corporation_walletjournal.refTypeID', '=', 'eve_reftypes.refTypeID')->whereIn('corporation_walletjournal.refTypeID', array(17, 85))->where('corporation_walletjournal.corporationID', $corporationID)->groupBy('corporation_walletjournal.ownerName2')->orderBy('total', 'desc')->get();
$mission_tax = DB::table('corporation_walletjournal')->select('ownerID2', 'ownerName2', DB::raw('SUM(corporation_walletjournal.amount) total'))->leftJoin('eve_reftypes', 'corporation_walletjournal.refTypeID', '=', 'eve_reftypes.refTypeID')->whereIn('corporation_walletjournal.refTypeID', array(33, 34))->where('corporation_walletjournal.corporationID', $corporationID)->groupBy('corporation_walletjournal.ownerName2')->orderBy('total', 'desc')->get();
$pi_tax = DB::table('corporation_walletjournal')->select('ownerID1', 'ownerName1', DB::raw('SUM(corporation_walletjournal.amount) total'))->leftJoin('eve_reftypes', 'corporation_walletjournal.refTypeID', '=', 'eve_reftypes.refTypeID')->whereIn('corporation_walletjournal.refTypeID', array(96, 97, 98))->where('corporation_walletjournal.corporationID', $corporationID)->groupBy('corporation_walletjournal.ownerName1')->orderBy('total', 'desc')->get();
$incursions_tax = DB::table('corporation_walletjournal')->select('ownerID2', 'ownerName2', DB::raw('SUM(corporation_walletjournal.amount) total'))->leftJoin('eve_reftypes', 'corporation_walletjournal.refTypeID', '=', 'eve_reftypes.refTypeID')->where('corporation_walletjournal.refTypeID', 99)->where('corporation_walletjournal.ownerName1', "CONCORD")->where('corporation_walletjournal.corporationID', $corporationID)->groupBy('corporation_walletjournal.ownerName2')->orderBy('total', 'desc')->get();
return View::make('corporation.ledger.ledger')->with('corporationID', $corporationID)->with('ledger_dates', $ledger_dates)->with('wallet_balances', $wallet_balances)->with('ledgers', $ledgers)->with('bounty_tax', $bounty_tax)->with('mission_tax', $mission_tax)->with('pi_tax', $pi_tax)->with('incursions_tax', $incursions_tax)->with('wallet_balances_total', $wallet_balances_total);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('business_plans')->insert(array(array('start' => Carbon\Carbon::createFromDate(2014, 1, 1, 'America/Edmonton'), 'end' => Carbon\Carbon::createFromDate(2016, 12, 31, 'America/Edmonton'))));
}
