public function news(Request $request)
{
if ($request->isMethod('POST')) {
// News::create($request->except('_token'));
// read image from temporary file
$file = $request->file('imagePrev');
$img = Image::make($file->getRealPath());
$nameFile = $file->getClientOriginalName();
// resize image
$img->fit(263, 263);
// save image
$img->save("images/" . $nameFile);
News::create(['text' => $request->input('editor1'), 'header' => $request->input('header'), 'picture' => "images/" . $nameFile]);
// switch ( $request->input('type') ) {
// case 'insert':
// News::create($request->except('_token'));
// break;
// case 'update':
// News::find( $request->input('id') )->update([
// 'header' => $request->input('header'),
// 'text' => $request->input('editor1'),
// ]);
// break;
// }
}
if ($request->isMethod('GET')) {
$item = News::find($request->input('remove'));
if ($item) {
$item->delete();
}
}
$news = News::orderBy('created_at', 'DESC')->paginate(15);
return view('admin/news', ['news' => $news]);
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(NewsRequest $request)
{
$input = Input::all();
$tags = explode(',', $input['tags']);
$slug = strtolower(implode('-', explode(' ', $input['title'])));
$slug = str_replace('?', '', $slug);
$slug = str_replace('/', '', $slug);
$slug = str_replace('\\', '', $slug);
if (News::where('slug', $slug)->first()) {
return Response::json([0 => 'Deze titel is al gebruikt bij een ander artikel.'], HttpCode::Conflict);
}
$input['slug'] = $slug;
$input['content'] = str_replace("\n", '', $input['content']);
// remove line endings
$input['content'] = str_replace("\r", '', $input['content']);
// remove line endings
$article = News::create($input);
if (Auth::user()->hasOnePrivelege(['Moderator', 'Administrator'])) {
$article->state = Input::get('publish') == "true" ? 1 : 0;
} else {
$article->state = 1;
}
foreach ($tags as $tag) {
$article->tag($tag);
}
$article->save();
return Response::json([0 => 'Nieuws artikel aangemaakt, klik <a href="/news/' . $slug . '">hier</a> om het te bekijken.'], HttpCode::Ok);
}
public function run()
{
$faker = Faker\Factory::create();
for ($i = 0; $i < 20; $i++) {
\App\News::create(['title' => $faker->unique()->sentence(4), 'date' => $faker->dateTimeThisCentury, 'published' => $faker->boolean(), 'text' => $faker->paragraph(5)]);
}
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$u = User::create(['first_name' => 'test', 'last_name' => 'test', 'email' => '*****@*****.**', 'level' => 1]);
$u2 = User::create(['first_name' => 'test2', 'last_name' => 'test2', 'email' => '*****@*****.**', 'level' => 1]);
$u3 = User::create(['first_name' => 'test3', 'last_name' => 'test3', 'email' => '*****@*****.**', 'level' => 2]);
$e1 = Event::create(['name' => 'test event', 'user_id' => 3, 'slug' => 'test-event-1', 'date' => '2016-10-17', 'start' => '18:00:00', 'end' => '5:00:00']);
$e2 = Event::create(['name' => 'test event', 'user_id' => 1, 'slug' => 'test-event-2', 'date' => '2016-08-22', 'start' => '19:00:00', 'end' => '5:00:00']);
Event::create(['name' => 'test event', 'user_id' => 2, 'slug' => 'test-event-3', 'date' => '2017-01-07', 'start' => '18:00:00', 'end' => '5:00:00']);
$p1 = Playlist::create(['name' => 'Playlist principale !']);
$p2 = Playlist::create(['name' => 'The Playlist !']);
$p3 = Playlist::create(['name' => 'Playlist secondaire']);
Playlist::create(['name' => 'The Playlist !']);
$p1->styles()->sync([1, 2, 3]);
$p2->styles()->sync([1, 4]);
$p3->styles()->sync([1, 3, 5, 7]);
$e1->playlists()->sync([1, 3]);
$e2->playlists()->sync([2]);
Comment::create(['event_id' => 2, 'user_id' => 2, 'content' => 'Sooo goooood']);
Comment::create(['event_id' => 3, 'user_id' => 2, 'content' => 'Sooo goooood :D']);
Comment::create(['event_id' => 2, 'user_id' => 3, 'content' => 'Sooo goooood !!!']);
Video::create(['url' => '7l48bfQuJeE', 'artist' => 'Chill Bump', 'name' => 'Lost In The Sound', 'tags' => 'chill bump lost in the sound']);
Video::create(['url' => 'XxdPJvhQaMU', 'artist' => 'Chill Bump', 'name' => 'Water boycotter', 'tags' => 'chill bump water boycotter']);
Video::create(['url' => 'kWXAYDQ_K7k', 'artist' => 'Chill Bump', 'name' => 'The Memo', 'tags' => 'chill bump the memo']);
$pivot1 = $p1->videos()->sync([1, 3]);
$pivot2 = $p2->videos()->sync([2]);
$pivot3 = $p3->videos()->sync([1, 2, 3]);
News::create(['title' => 'news test', 'content' => 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. ', 'user_id' => 2, 'slug' => 'text-news-1']);
News::create(['title' => 'news test 2', 'content' => 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. ', 'user_id' => 3, 'slug' => 'text-news-2']);
Article::create(['title' => 'Article test 1', 'content' => 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. ', 'user_id' => 2, 'slug' => 'text-article-1']);
Article::create(['title' => 'Article test 2', 'content' => 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. ', 'user_id' => 3, 'slug' => 'text-article-2', 'event_id' => 2]);
}
/**
* @param \App\Http\Requests\CreateNewsRequest $request
* @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View
*/
public function store(CreateNewsRequest $request)
{
News::create($request->all());
$news = News::orderBy('updated_at', 'desc')->get();
session()->flash('flash_message', 'Je artikel is succesvol toegevoegd');
return view('news.index', compact('news'));
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
$input = Input::all();
$validation = Validator::make($input, News::$news_rules);
if ($validation->passes()) {
if (Input::get('types') == 'news') {
$image = Input::file('coverImage');
$extension = $image->getClientOriginalExtension();
$filename = sha1(time() . time()) . ".{$extension}";
$upload_success = \Image::make($image)->resize(\Config::get('image.news_image_width'), \Config::get('image.news_image_height'))->save(\Config::get('image.news_image') . $filename);
} elseif (Input::get('types') == 'development') {
$image = Input::file('coverImage');
$extension = $image->getClientOriginalExtension();
$filename = sha1(time() . time()) . ".{$extension}";
$upload_success = \Image::make($image)->save(\Config::get('image.news_image') . $filename);
}
if ($upload_success) {
News::create(array('types' => Input::get('types'), 'author' => Input::get('author'), 'content' => Input::get('content'), 'title' => Input::get('title'), 'coverImage' => $filename));
return Redirect::to('admin/newsList');
}
} else {
$error = $validation->errors()->first();
return Redirect::to('news/create')->withInput(Input::all())->with(compact('error'));
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker::create();
foreach (range(1, 30) as $index) {
News::create(['user_id' => '1', 'title' => $faker->sentence(4), 'url' => $faker->slug(3), 'content' => $faker->paragraphs(8, true), 'metatitle' => '', 'metakeywords' => '', 'metadesc' => '', 'created_at' => Carbon::now(), 'updated_at' => Carbon::now(), 'published_at' => Carbon::now()]);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('cars')->delete();
for ($i = 0; $i < count($this->items); $i++) {
$row = array_combine(['title', 'text', 'image'], $this->items[$i]) + ['published_at' => Carbon::now()];
News::create($row);
}
}
/**
* Copies over all the news from the ATLauncher's API into our database.
*
* @return void
*/
public function run()
{
DB::table('news')->delete();
$atl_news = json_decode(file_get_contents('https://api.atlauncher.com/v1/news'))->data;
foreach ($atl_news as $news) {
News::create(array('title' => $news->title, 'comments' => $news->comments, 'link' => $news->link, 'published_at' => $news->published_at, 'content' => $news->content));
}
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
$news = Input::all();
if (!$news['published_at']) {
$news['published_at'] = Carbon::now();
}
News::create($news);
return redirect('/')->withSuccess("'Новина додана успішно!'");
}
public function insert()
{
$entry = array('id' => Input::get('id'), 'name' => strtolower(Input::get('name')), 'title' => Input::get('title'), 'body' => Input::get('body'), 'image' => Input::get('image'), 'author_id' => Input::get('author_id'));
if (isset($entry)) {
News::create($entry);
return \Redirect::route('news')->with('success', $entry['title'] . ' added succesfully!');
} else {
return \Redirect::route('add_news', array($entry['id']))->with('error', 'Failed to add, invalid credentials.');
}
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$this->validate($request, ['title' => 'required']);
$input = $request->all();
$input['published_at'] = $input['published_at'] ?: Carbon::now();
$item = News::create($input);
$item->saveImage($item, $request);
Flash::success("Запись - {$item->id} сохранена");
return redirect(route('admin.news.index'));
}
public function create()
{
$aNewsData = Input::get('news');
$validator = Validator::make($aNewsData, ['title' => 'required|max:255', 'content' => 'required', 'state' => 'in:created,visible,deleted']);
if ($validator->fails()) {
$aRet = ['success' => 'false', 'errors' => $validator->errors()];
} elseif ($oNews = News::create($aNewsData)) {
$aRet = ['success' => 'true'];
} else {
$aRet = ['success' => 'false'];
}
return response()->json($aRet);
}
/**
* Store a newly created resource in storage.
*
* @param \App\Http\Requests\NewsRequest $request
* @return \Illuminate\Http\Response
*/
public function store(Requests\NewsRequest $request)
{
$departmentId = auth()->user()->department_id;
if ($request->has('department_id') && $this->systemAdmin) {
$departmentId = $request->get('department_id');
}
DB::transaction(function () use($departmentId, $request) {
$news = News::create(['department_id' => $departmentId, 'active' => $request->get('active'), 'sort' => $request->get('sort')]);
$langs = [];
foreach (LaravelLocalization::getSupportedLocales() as $short => $locale) {
$langs[] = ['lang_id' => dbTrans($short), 'title' => $request->get('title_' . $short), 'description' => $request->get('description_' . $short)];
}
$news->langs()->createMany($langs);
});
return redirect(action('Admin\\NewsController@index'))->with('success', 'saved');
}
public function store(Request $request)
{
//dd($request->all());
$user = $this->user;
$this->validate($request, ['title' => 'required', 'content' => 'required', 'status' => 'required | in:0,1']);
if ($request->hasFile('image')) {
$this->validate($request, ['image' => 'mimes:jpeg,jpg,bmp,png | max:1024']);
$imageName = $this->uploadImage($request->file('image'));
} else {
$imageName = null;
}
$news = News::create(['title' => $request->input('title'), 'content' => $request->input('content'), 'status' => $request->input('status'), 'user_id' => $user->id, 'image' => $imageName]);
/*
* Register Tags
*/
$selected = $this->registerTags($request);
//آی دی های تگ های جدید
$news->tags()->sync($selected);
Flash::success(trans('messages.newsCreated'));
return redirect()->back();
}
/**
* Create a news item
* @param Request $request
* @return REDIRECT A view of the post
*/
public function store(Request $request)
{
if (!Auth::check() || !Auth::user()->is_admin) {
return response(view('errors.403', ['error' => $this->errorMessages['incorrect_permissions']]), 403);
}
$data = $request->only(['mce_0', 'mce_1', 'tags', 'featured_image']);
// Validate all input
$validator = Validator::make($data, ['mce_0' => 'required', 'mce_1' => 'required', 'featured_image' => 'image|sometimes']);
if ($validator->fails()) {
// If validation fails, redirect back to
// registration form with errors
return Redirect::back()->withErrors($validator)->withInput();
}
if ($request->hasFile('featured_image')) {
$data['featured_image'] = MediaController::uploadImage($request->file('featured_image'), time(), $directory = "news_images", $bestFit = true, $fitDimensions = [1920, 1080]);
}
$data['title'] = $data['mce_0'];
$data['content'] = $data['mce_1'];
$news = News::create($data);
return Redirect::route('news.show', ['id' => $news->id]);
}
public function postAdd(Request $request)
{
$news = $request->all();
$file = $request->file('image');
$rand = str_random();
if ($request->hasFile('image')) {
$images['name'] = $rand . '_' . $file->getClientOriginalName();
$images['original_name'] = $file->getClientOriginalName();
$images['description'] = "News";
$images['type'] = $file->getClientOriginalExtension();
$images['img_type'] = "news";
$images = File::create($images);
$file->move('assets/images/news', $rand . '_' . $file->getClientOriginalName());
$news['image_id'] = $images->id;
} else {
return "error upload";
}
$news = News::create($news);
$news->slug = str_slug($news->name . '-' . $news->id, '-');
$news->save();
return redirect()->action('Admin\\NewsController@getIndex')->with('success', 'add');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
News::create($request->all());
return redirect('admin-area/news');
}
/**
* Store a newly created news in storage.
*
* @param CreateNewsRequest|Request $request
*/
public function store(CreateNewsRequest $request)
{
$request = $this->saveFiles($request);
News::create($request->all());
return redirect()->route('admin.news.index');
}
public function run()
{
DB::table('news')->delete();
News::create(['title' => 'Test Artikel1', 'content' => 'Dit is een test artikel dat geen gebruik maakt van html tags! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Fugiat vitae, quibusdam eius deserunt, consequuntur possimus hic voluptatum incidunt soluta temporibus quam architecto sint ad animi vel aperiam assumenda debitis. Quae.', 'slug' => 'test-artikel1']);
News::create(['title' => 'Test Artikel2', 'content' => '<span style="color: red;">Dit artikel</span> maakt gebruikt van <h3>tags.</h3>', 'slug' => 'test-artikel2']);
}
public function run()
{
$xls = 'database/seeds/seeder.xlsm';
$book = Excel::load($xls, 'UTF-8')->all();
foreach ($book as $sheet) {
if ($sheet->getTitle() === 'categories') {
Category::truncate();
foreach ($sheet as $row) {
$category = Category::create(['id' => $row->id, 'parent_id' => $row->parent_id, 'level' => $row->level, 'type' => $row->type, 'menutype' => $row->menutype, 'title' => $row->title, 'sef' => $row->sef, 'class' => $row->class, 'body' => $row->body, 'image' => $row->image, 'metatitle' => $row->metatitle, 'metakey' => $row->metakey, 'metadesc' => $row->metadesc]);
}
}
if ($sheet->getTitle() === 'furnitura') {
Furnitura::truncate();
foreach ($sheet as $row) {
if (!empty($row->category_id)) {
$menu = Furnitura::create(['id' => $row->id, 'category_id' => $row->category_id, 'cat2_id' => $row->cat2_id, 'title' => $row->title, 'sef' => $row->sef, 'introtext' => $row->introtext, 'fulltext' => $row->fulltext, 'artikul' => $row->artikul, 'otdelka' => $row->otdelka, 'pcs' => $row->pcs, 'description' => $row->description, 'metatitle' => $row->metatitle, 'metakey' => $row->metakey, 'metadesc' => $row->metadesc, 'hits' => $row->hits]);
}
}
}
if ($sheet->getTitle() === 'links') {
Link::truncate();
foreach ($sheet as $row) {
if (!empty($row->category_id)) {
$menu = Link::create(['category_id' => $row->category_id, 'title' => $row->title, 'url' => $row->url, 'description' => $row->description, 'version' => $row->version, 'metatitle' => $row->metatitle, 'metakey' => $row->metakey, 'metadesc' => $row->metadesc, 'hits' => $row->hits]);
}
}
}
if ($sheet->getTitle() === 'news') {
News::truncate();
foreach ($sheet as $row) {
if (!empty($row->category_id)) {
$menu = News::create(['category_id' => $row->category_id, 'title' => $row->title, 'sef' => $row->sef, 'introtext' => $row->introtext, 'fulltext' => $row->fulltext, 'image' => $row->image, 'metatitle' => $row->metatitle, 'metakey' => $row->metakey, 'metadesc' => $row->metadesc, 'hits' => $row->hits, 'created_at' => $row->created_at]);
}
}
}
if ($sheet->getTitle() === 'steklo') {
Page::truncate();
foreach ($sheet as $row) {
if (!empty($row->category_id)) {
$menu = Page::create(['category_id' => $row->category_id, 'title' => $row->title, 'sef' => $row->sef, 'introtext' => $row->introtext, 'fulltext' => $row->fulltext, 'image' => $row->image, 'metatitle' => $row->metatitle, 'metakey' => $row->metakey, 'metadesc' => $row->metadesc, 'hits' => $row->hits]);
}
}
}
if ($sheet->getTitle() === 'uslugi') {
Uslugi::truncate();
foreach ($sheet as $row) {
if (!empty($row->category_id)) {
$menu = Uslugi::create(['category_id' => $row->category_id, 'title' => $row->title, 'sef' => $row->sef, 'introtext' => $row->introtext, 'fulltext' => $row->fulltext, 'image' => $row->image, 'metatitle' => $row->metatitle, 'metakey' => $row->metakey, 'metadesc' => $row->metadesc, 'hits' => $row->hits]);
}
}
}
if ($sheet->getTitle() === 'faq') {
Faq::truncate();
foreach ($sheet as $row) {
if (!empty($row->category_id)) {
$menu = Faq::create(['category_id' => $row->category_id, 'title' => $row->title, 'sef' => $row->sef, 'introtext' => $row->introtext, 'fulltext' => $row->fulltext, 'image' => $row->image, 'metatitle' => $row->metatitle, 'metakey' => $row->metakey, 'metadesc' => $row->metadesc, 'hits' => $row->hits]);
}
}
}
if ($sheet->getTitle() === 'objects') {
Object::truncate();
foreach ($sheet as $row) {
if (!empty($row->category_id)) {
$menu = Object::create(['category_id' => $row->category_id, 'title' => $row->title, 'sef' => $row->sef, 'introtext' => $row->introtext, 'fulltext' => $row->fulltext, 'image' => $row->image, 'metatitle' => $row->metatitle, 'metakey' => $row->metakey, 'metadesc' => $row->metadesc, 'hits' => $row->hits]);
}
}
}
}
}
/**
* Création d'une news en DB
*/
public function store(NewsRequest $request)
{
News::create($request->only('name', 'slug', 'content'));
return redirect(action('NewsController@index'))->with('success', 'La news à bien été créée');
}
/**
* Store a newly created resource in storage.
*
* @param NewsRequest $request
* @return Response
*/
public function store(NewsRequest $request)
{
News::create($request->all());
\Flash::success('Nieuwsartikel gepubliceerd');
return redirect('admin/news');
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
// Create departement : "autre"
Department::create(['name' => 'Autre', 'short_name' => 'PeiP']);
// Create departement : DI
Department::create(['name' => 'Département Informatique', 'short_name' => 'DI']);
// Create departement : DMS
Department::create(['name' => 'Département Mécanique', 'short_name' => 'DMS']);
// Create user : Admin (lvl 3)
User::create(['first_name' => 'Admin', 'last_name' => 'Admin', 'email' => 'admin@admin', 'school_year' => 0, 'department_id' => 1, 'password' => bcrypt('admincmt'), 'level_id' => 4, 'slug' => 'admin-admin-2']);
// Create user : Teacher (lvl 2)
User::create(['first_name' => 'Teacher', 'last_name' => 'Teacher', 'email' => 'teacher@teacher', 'school_year' => 0, 'department_id' => 1, 'password' => bcrypt('teachercmt'), 'level_id' => 3, 'slug' => 'teacher-teacher-3']);
// Create user : band_creator (lvl 1)
User::create(['first_name' => 'Band', 'last_name' => 'Creator', 'email' => 'band@creator', 'school_year' => 0, 'department_id' => 1, 'password' => bcrypt('membercmt'), 'level_id' => 2, 'slug' => 'band-creator-5,']);
// Create user : Member (lvl 0)
User::create(['first_name' => 'Member', 'last_name' => 'Member', 'email' => 'member@member', 'school_year' => 0, 'department_id' => 1, 'password' => bcrypt('membercmt'), 'level_id' => 1, 'slug' => 'member-member-4']);
// Create Article 'Cours de guitare'
Article::create(['title' => 'Cours de guitare', 'subtitle' => 'Article concernant le cours de guitare', 'content' => '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam purus tortor, efficitur ut iaculis ut,
tincidunt vel elit. Morbi malesuada ipsum eu fermentum consequat. Duis aliquam, massa et bibendum
facilisis, nulla nibh ultricies ante, a rutrum augue tellus quis erat. Curabitur aliquam ipsum gravida,
interdum mauris non, blandit justo. Donec non mollis orci, a accumsan ligula. Nullam quis sapien elementum
neque egestas lacinia</p>', 'user_id' => 2, 'slug' => 'cours-de-guitare-1', 'category_id' => 3, 'validated' => 1]);
// Create Article 'Cours de piano'
Article::create(['title' => 'Cours de piano', 'subtitle' => 'Article concernant le cours de piano', 'content' => '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam purus tortor, efficitur ut iaculis ut,
tincidunt vel elit. Morbi malesuada ipsum eu fermentum consequat. Duis aliquam, massa et bibendum
facilisis, nulla nibh ultricies ante, a rutrum augue tellus quis erat. Curabitur aliquam ipsum gravida,
interdum mauris non, blandit justo. Donec non mollis orci, a accumsan ligula. Nullam quis sapien elementum
neque egestas lacinia</p>', 'user_id' => 3, 'slug' => 'cours-de-piano-2', 'category_id' => 3, 'validated' => 1]);
// Create guitar course
Course::create(['name' => 'Cours de guitare', 'day' => 1, 'start' => '18:30:00', 'end' => '20:00:00', 'infos' => 'Cours de guitare du lundi soir.', 'slug' => 'cours-de-guitare-lundi-1', 'instrument_id' => 2, 'article_id' => 1, 'user_id' => 2]);
// Create piano course
Course::create(['name' => 'Cours de piano', 'day' => 3, 'start' => '18:30:00', 'end' => '20:00:00', 'infos' => 'Cours de piano du mardi soir.', 'slug' => 'cours-de-piano-mardi-2', 'instrument_id' => 3, 'article_id' => 2, 'user_id' => 3]);
// Create Band 'The Band'
Band::create(['name' => 'The Band', 'infos' => 'premier groupe de test', 'user_id' => 1, 'validated' => 1, 'slug' => 'the-band-1', 'article_id' => 2]);
// Create band 'Second Band'
Band::create(['name' => 'Second Band', 'infos' => 'deuxieme groupe de test', 'user_id' => 2, 'validated' => 1, 'slug' => 'second-band-2', 'article_id' => 1]);
// Create News 'test news'
News::create(['title' => 'test news', 'content' => '<p>Contenu de la première news de test</p>', 'user_id' => 1, 'slug' => 'test-news-1']);
// Create News 'test second news'
News::create(['title' => 'test seconde news', 'content' => '<p>Contenu de la deuxieme news de test</p>', 'user_id' => 2, 'slug' => 'test-seconde-news-1']);
// Create announcement 'test d'une annonce'
Announcement::create(['user_id' => 1, 'title' => 'test d\'une annonce', 'slug' => 'test-annonce-1', 'validated' => 1, 'subject' => 'Annonce pour tester', 'category_id' => 1, 'content' => '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque in malesuada leo.
Suspendisse ut dapibus urna. Nunc mattis velit vel varius luctus. Fusce ornare arcu nec odio
egestas, et lacinia sapien laoreet. Maecenas odio dui, fringilla non sapien euismod, volutpat
porta sapien. Suspendisse mauris quam, maximus quis tempus non, feugiat in tellus. Sed non quam aliquet,
sollicitudin risus nec, mollis turpis. Donec interdum tincidunt efficitur. Nam efficitur enim a leo
pellentesque, venenatis sollicitudin lacus suscipit. Ut eu nunc eget lacus vehicula gravida. Fusce
vitae ante bibendum, maximus nisl quis, lacinia metus. In pharetra placerat lacus, sed fringilla ex
imperdiet vel. Nulla mollis risus tellus, a ultricies tellus tempor cursus. Quisque viverra nunc ipsum,
a ullamcorper dui porttitor eu. Suspendisse nec nunc ut mi dignissim ultrices.</p>
<p>In libero sem, dictum in venenatis sit amet, dictum id quam. Aliquam id ligula luctus,
lobortis felis eget, sollicitudin nulla. Suspendisse tempus aliquet volutpat. Integer lacinia
sem ac libero faucibus cursus. Morbi mauris massa, interdum vel placerat sit amet, rutrum eget
turpis. Mauris convallis semper sem, eu pharetra tortor sagittis non. Praesent auctor justo nulla,
in rhoncus ipsum porta ut. Mauris bibendum fringilla accumsan. Proin bibendum eros eros. Aliquam
vulputate, nisi vitae tristique lacinia, leo risus volutpat augue, vel ultricies lorem urna vitae erat.
Vestibulum varius, libero eget sollicitudin luctus, lacus massa molestie purus, quis blandit felis sem at dui.</p>']);
// Create announcement 'test d'une seconde annonce'
Announcement::create(['user_id' => 2, 'content' => '<p>contenu de la deuxieme annonce</p>', 'title' => 'test d\'une seconde annonce', 'slug' => 'test-seconde-annonce-2', 'validated' => 1, 'subject' => 'Deuxieme annonce pour tester', 'category_id' => 1]);
// Create announcement unvalidated
Announcement::create(['user_id' => 3, 'content' => '<p>azre</p>', 'title' => 'azr', 'slug' => 'test-annonce-invalidee-3', 'validated' => 0, 'subject' => 'Annonce invalidée pour tester', 'category_id' => 1]);
// Create comment on announcement #1
Comment::create(['announcement_id' => 1, 'user_id' => 1, 'content' => '<p>Nam efficitur enim a leo pellentesque, venenatis sollicitudin lacus suscipit. Ut eu
nunc eget lacus vehicula gravida. Fusce vitae ante bibendum, maximus nisl quis, lacinia metus.
In pharetra placerat lacus, sed fringilla ex imperdiet vel. Nulla mollis risus tellus, a ultricies
tellus tempor cursus. Quisque viverra nunc ipsum, a ullamcorper dui porttitor eu. Suspendisse nec
nunc ut mi dignissim ultrices.</p>
<p>In libero sem, dictum in venenatis sit amet, dictum id quam. Aliquam id ligula luctus,
lobortis felis eget, sollicitudin nulla. Suspendisse tempus aliquet volutpat. Integer
lacinia sem ac libero faucibus cursus.</p>']);
// Create comment on announcement #1
Comment::create(['announcement_id' => 1, 'user_id' => 2, 'content' => '<p>In libero sem, dictum in venenatis sit amet, dictum id quam. Aliquam id ligula luctus,
lobortis felis eget, sollicitudin nulla. Suspendisse tempus aliquet volutpat. Integer
lacinia sem ac libero faucibus cursus.</p>
<p>Nam efficitur enim a leo pellentesque, venenatis sollicitudin lacus suscipit. Ut eu
nunc eget lacus vehicula gravida. Fusce vitae ante bibendum, maximus nisl quis, lacinia metus.
In pharetra placerat lacus, sed fringilla ex imperdiet vel. Nulla mollis risus tellus, a ultricies
tellus tempor cursus. Quisque viverra nunc ipsum, a ullamcorper dui porttitor eu. Suspendisse nec
nunc ut mi dignissim ultrices.</p>']);
// Create comment on announcement #2
Comment::create(['announcement_id' => 2, 'user_id' => 1, 'content' => '<p>commentaire annonce 2</p>']);
// Create Article 'premier article'
Article::create(['title' => 'premier article', 'subtitle' => 'test d\'un premier article', 'content' => '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam purus tortor, efficitur ut iaculis ut,
tincidunt vel elit. Morbi malesuada ipsum eu fermentum consequat. Duis aliquam, massa et bibendum
facilisis, nulla nibh ultricies ante, a rutrum augue tellus quis erat. Curabitur aliquam ipsum gravida,
interdum mauris non, blandit justo. Donec non mollis orci, a accumsan ligula. Nullam quis sapien elementum
neque egestas lacinia</p>', 'user_id' => 1, 'slug' => 'premier-article-3', 'category_id' => 2, 'validated' => 1]);
// Create Article 'deuxieme article'
Article::create(['title' => 'deuxieme article', 'subtitle' => 'test d\'un deuxieme article', 'content' => '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam purus tortor, efficitur ut iaculis ut,
tincidunt vel elit. Morbi malesuada ipsum eu fermentum consequat. Duis aliquam, massa et bibendum
facilisis, nulla nibh ultricies ante, a rutrum augue tellus quis erat. Curabitur aliquam ipsum gravida,
interdum mauris non, blandit justo. Donec non mollis orci, a accumsan ligula. Nullam quis sapien elementum
neque egestas lacinia</p>', 'user_id' => 2, 'slug' => 'deuxieme-article-4', 'category_id' => 1]);
// Create Event 'concert de The Band'
Event::create(['location' => '23 avenue de la Team Musique', 'day' => 6, 'start' => '18:00:00', 'end' => '00:00:00', 'infos' => 'infos du premier event', 'name' => 'Concert de The Band', 'slug' => 'concert-the-band', 'user_id' => 1, 'date' => '2016-03-27', 'article_id' => 1]);
// Create Event 'concert de ouf'
Event::create(['location' => '186 avenue de la Team Musique', 'day' => 5, 'start' => '17:00:00', 'end' => '23:00:00', 'infos' => 'infos du deuxieme event', 'name' => 'Concert de ouf', 'slug' => 'concert-de-ouf', 'user_id' => 2, 'date' => '2016-04-12', 'article_id' => 2]);
// Associate Band 1 to Event 1
BandEvent::create(['band_id' => 1, 'event_id' => 1]);
// Associate band 1 to event 2
BandEvent::create(['band_id' => 1, 'event_id' => 2]);
// Associate band 2 to event 2
BandEvent::create(['band_id' => 2, 'event_id' => 2]);
// Associate Members to Bands
BandUser::create(['user_id' => 1, 'band_id' => 1, 'instrument_id' => 1]);
BandUser::create(['user_id' => 2, 'band_id' => 1, 'instrument_id' => 2]);
BandUser::create(['user_id' => 3, 'band_id' => 1, 'instrument_id' => 3]);
BandUser::create(['user_id' => 2, 'band_id' => 2, 'instrument_id' => 5]);
BandUser::create(['user_id' => 3, 'band_id' => 2, 'instrument_id' => 10]);
// Associate Users to Courses as Students
CourseUser::create(['user_id' => '1', 'course_id' => 1, 'validated' => 1, 'level' => 0]);
CourseUser::create(['user_id' => '3', 'course_id' => 1, 'validated' => 1, 'level' => 0]);
CourseUser::create(['user_id' => '1', 'course_id' => 2, 'validated' => 1, 'level' => 0]);
CourseUser::create(['user_id' => '4', 'course_id' => 2, 'validated' => 0, 'level' => 0]);
// Associate Users to Courses as Teachers
CourseUser::create(['user_id' => '3', 'course_id' => 1, 'validated' => 1, 'level' => 1]);
CourseUser::create(['user_id' => '2', 'course_id' => 1, 'validated' => 1, 'level' => 1]);
CourseUser::create(['user_id' => '2', 'course_id' => 2, 'validated' => 1, 'level' => 1]);
CourseUser::create(['user_id' => '4', 'course_id' => 1, 'validated' => 0, 'level' => 1]);
// Course Modification tests
CourseModification::create(['author_id' => 1, 'user_id' => 1, 'course_id' => 1, 'value' => 0]);
CourseModification::create(['author_id' => 2, 'user_id' => 2, 'course_id' => 1, 'value' => 1]);
CourseModification::create(['author_id' => 1, 'user_id' => 3, 'course_id' => 2, 'value' => 2]);
CourseModification::create(['author_id' => 3, 'user_id' => 2, 'course_id' => 2, 'value' => 3]);
}
public function updateNewsAction()
{
News::where('is_imported', '=', '1')->delete();
$url = "http://rybaksverdlovsk.at.ua/news/rss/";
$rss = simplexml_load_file($url);
foreach ($rss->channel->item as $item) {
$namespaces = $item->getNameSpaces(true);
News::create(array('title' => $item->title, 'description' => $item->description, 'content' => $item->children($namespaces['content'])->encoded, 'created_at' => strtotime($item->pubDate)));
}
return redirect()->back();
}
public function run()
{
DB::table('news')->delete();
News::create(['title' => '9.25 更新内容', 'ship' => '110,102,103,36,37,405', 'equip' => '148,149', 'quest' => '1056,1057,1058,2050,2051,2052,4019,6019', 'content' => '更新完后建议重新启动App\\n\\n1、更新舰船：\\n【翔鹤改二】']);
}
public function run()
{
DB::table('news')->delete();
News::create(['alias' => 'news-1', 'title' => 'news 1', 'text' => 'Нвоости Простота в работе. Мы приложили много усилий, чтобы работать на нашей бирже копирайтинга было максимально легко и удобно. Интуитивно понятный интерфейс, постоянное совершенствование функционала и подробный FAQ помогут в работе начинающим и обеспечат комфорт постоянным пользователям сервиса TEXT.RU.
Гарантии и безопасность. Биржа копирайтинга TEXT.RU предоставляет гарантии как заказчикам, так и исполнителям. Заказчик получает качественный текст, а исполнитель — оплату за свою работу при условии отличного выполнения. Для разрешения конфликтных ситуаций предусмотрен Арбитраж. ', 'active' => true]);
News::create(['alias' => 'news-2', 'title' => 'news 2', 'text' => 'старости Простота в работе. Мы приложили много усилий, чтобы работать на нашей бирже копирайтинга было максимально легко и удобно. Интуитивно понятный интерфейс, постоянное совершенствование функционала и подробный FAQ помогут в работе начинающим и обеспечат комфорт постоянным пользователям сервиса TEXT.RU.
Гарантии и безопасность. Биржа копирайтинга TEXT.RU предоставляет гарантии как заказчикам, так и исполнителям. Заказчик получает качественныйтекст, а исполнитель — оплату за свою работу при условии отличного выполнения. Для разрешения конфликтных ситуаций предусмотрен Арбитраж. ', 'active' => true]);
News::create(['alias' => 'news-1', 'title' => 'news 1', 'text' => 'Нвоости Простота в работе. Мы приложили много усилий, чтобы работать на нашей бирже копирайтинга было максимально легко и удобно. Интуитивно понятный интерфейс, постоянное совершенствование функционала и подробный FAQ помогут в работе начинающим и обеспечат комфорт постоянным пользователям сервиса TEXT.RU.
Гарантии и безопасность. Биржа копирайтинга TEXT.RU предоставляет гарантии как заказчикам, так и исполнителям. Заказчик получает качественный текст, а исполнитель — оплату за свою работу при условии отличного выполнения. Для разрешения конфликтных ситуаций предусмотрен Арбитраж. ', 'active' => true]);
News::create(['alias' => 'news-2', 'title' => 'news 2', 'text' => 'старости Простота в работе. Мы приложили много усилий, чтобы работать на нашей бирже копирайтинга было максимально легко и удобно. Интуитивно понятный интерфейс, постоянное совершенствование функционала и подробный FAQ помогут в работе начинающим и обеспечат комфорт постоянным пользователям сервиса TEXT.RU.
Гарантии и безопасность. Биржа копирайтинга TEXT.RU предоставляет гарантии как заказчикам, так и исполнителям. Заказчик получает качественныйтекст, а исполнитель — оплату за свою работу при условии отличного выполнения. Для разрешения конфликтных ситуаций предусмотрен Арбитраж. ', 'active' => true]);
}
$news = News::all();
return response()->json($news);
});
$app->post('/news', function (Request $request) {
if (!Auth::check()) {
return redirect('/login');
}
$rules = ['title' => 'required|max:256', 'ship' => 'array', 'quest' => 'array', 'content' => 'max:1024', 'equip' => 'array'];
$validator = Validator::make($request->all(), $rules);
if ($validator->fails()) {
return redirect('/')->withErrors($validator);
}
$ship = $request->input('ship') ? join(',', $request->input('ship')) : '';
$quest = $request->input('quest') ? join(',', $request->input('quest')) : '';
$equip = $request->input('equip') ? join(',', $request->input('equip')) : '';
News::create(['title' => $request->input('title'), 'ship' => $ship, 'equip' => $equip, 'quest' => $quest, 'content' => $request->input('content')]);
$successMessage = '新闻创建成功';
return redirect('/')->withSuccess($successMessage);
});
$app->post('/news/{id}', function ($id, Request $request) {
if (!Auth::check()) {
return redirect('/login');
}
$rules = ['title' => 'required|max:256', 'ship' => 'array', 'quest' => 'array', 'content' => 'max:1024', 'equip' => 'array'];
$validator = Validator::make($request->all(), $rules);
if ($validator->fails()) {
return redirect('/')->withErrors($validator);
}
$ship = $request->input('ship') ? join(',', $request->input('ship')) : '';
$quest = $request->input('quest') ? join(',', $request->input('quest')) : '';
$equip = $request->input('equip') ? join(',', $request->input('equip')) : '';
public function postAddNews(AddNieuws $request)
{
$input = $request->all();
News::create($input);
return redirect('nieuws');
}
public function run()
{
DB::table('news')->delete();
News::create(['title' => 'Testtitle 1', 'content' => 'Testcontent 1', 'state' => 'visible']);
}
