public function crea_utenti()
{
// cancello tabelle
DB::table('post_statusname')->delete();
DB::table('statusname_user')->delete();
DB::table('mediafile_post')->delete();
DB::table('categoryname_post')->delete();
DB::table('post_tag')->delete();
DB::table('relateds')->delete();
DB::table('posts')->delete();
DB::table('categorynames')->update(array('parent_id' => NULL));
DB::table('categorynames')->delete();
DB::table('statusnames')->delete();
DB::table('statustypes')->delete();
DB::table('tags')->delete();
DB::table('mediafiles')->delete();
DB::table('mediatypes')->delete();
DB::table('users_data')->delete();
DB::table('users')->delete();
DB::table('persistences')->delete();
DB::table('activations')->delete();
DB::table('reminders')->delete();
DB::table('role_users')->delete();
DB::table('roles')->delete();
DB::table('throttle')->delete();
// STATUS TYPES
$status_type = new Statustype();
$status_type->type = Config::get('constants.STATUS_TYPE_POST');
$status_type->slug = Str::slug(Config::get('constants.STATUS_TYPE_POST'));
$status_type->save();
$status_type1 = new Statustype();
$status_type1->type = Config::get('constants.STATUS_TYPE_USER');
$status_type1->slug = Str::slug(Config::get('constants.STATUS_TYPE_USER'));
$status_type1->save();
// STATUS NAMES
$status_name = new Statusname();
$status_name->name = Config::get('constants.STATUS_POST_INATTESAMODERAZIONE');
$status_name->slug = Str::slug(Config::get('constants.STATUS_POST_INATTESAMODERAZIONE'));
$status_name->statustype_id = Statustype::where('type', Config::get('constants.STATUS_TYPE_POST'))->first()->id;
$status_name->save();
$status_name1 = new Statusname();
$status_name1->name = Config::get('constants.STATUS_POST_INATTESAPUBBLICAZIONE');
$status_name1->slug = Str::slug(Config::get('constants.STATUS_POST_INATTESAPUBBLICAZIONE'));
$status_name1->statustype_id = Statustype::where('type', Config::get('constants.STATUS_TYPE_POST'))->first()->id;
$status_name1->save();
$status_name2 = new Statusname();
$status_name2->name = Config::get('constants.STATUS_POST_PUBBLICATO');
$status_name2->slug = Str::slug(Config::get('constants.STATUS_POST_PUBBLICATO'));
$status_name2->statustype_id = Statustype::where('type', Config::get('constants.STATUS_TYPE_POST'))->first()->id;
$status_name2->save();
$status_name3 = new Statusname();
$status_name3->name = Config::get('constants.STATUS_USER_INATTESAATTIVAZIONE');
$status_name3->slug = Str::slug(Config::get('constants.STATUS_USER_INATTESAATTIVAZIONE'));
$status_name3->statustype_id = Statustype::where('type', Config::get('constants.STATUS_TYPE_USER'))->first()->id;
$status_name3->save();
$status_name4 = new Statusname();
$status_name4->name = Config::get('constants.STATUS_USER_ATTIVATO');
$status_name4->slug = Str::slug(Config::get('constants.STATUS_USER_ATTIVATO'));
$status_name4->statustype_id = Statustype::where('type', Config::get('constants.STATUS_TYPE_USER'))->first()->id;
$status_name4->save();
$status_name5 = new Statusname();
$status_name5->name = Config::get('constants.STATUS_USER_BANNATO');
$status_name5->slug = Str::slug(Config::get('constants.STATUS_USER_BANNATO'));
$status_name5->statustype_id = Statustype::where('type', Config::get('constants.STATUS_TYPE_USER'))->first()->id;
$status_name5->save();
// MEDIA TYPES
$media_type = new Mediatype();
$media_type->name = Config::get('constants.MEDIA_TYPE_IMGJPG');
$media_type->slug = Str::slug(Config::get('constants.MEDIA_TYPE_IMGJPG'));
$media_type->ext = Config::get('constants.MEDIA_TYPE_IMGJPG_EXT');
$media_type->save();
$media_type1 = new Mediatype();
$media_type1->name = Config::get('constants.MEDIA_TYPE_IMGGIF');
$media_type1->slug = Str::slug(Config::get('constants.MEDIA_TYPE_IMGGIF'));
$media_type1->ext = Config::get('constants.MEDIA_TYPE_IMGGIF_EXT');
$media_type1->save();
$media_type2 = new Mediatype();
$media_type2->name = Config::get('constants.MEDIA_TYPE_IMGPNG');
$media_type2->slug = Str::slug(Config::get('constants.MEDIA_TYPE_IMGPNG'));
$media_type2->ext = Config::get('constants.MEDIA_TYPE_IMGPNG_EXT');
$media_type2->save();
$media_type3 = new Mediatype();
$media_type3->name = Config::get('constants.MEDIA_TYPE_IMGBMP');
$media_type3->slug = Str::slug(Config::get('constants.MEDIA_TYPE_IMGBMP'));
$media_type3->ext = Config::get('constants.MEDIA_TYPE_IMGBMP_EXT');
$media_type3->save();
$media_type4 = new Mediatype();
$media_type4->name = Config::get('constants.MEDIA_TYPE_IMGTIFF');
$media_type4->slug = Str::slug(Config::get('constants.MEDIA_TYPE_IMGTIFF'));
$media_type4->ext = Config::get('constants.MEDIA_TYPE_IMGTIFF_EXT');
$media_type4->save();
$media_type5 = new Mediatype();
$media_type5->name = Config::get('constants.MEDIA_TYPE_PDF');
$media_type5->slug = Str::slug(Config::get('constants.MEDIA_TYPE_PDF'));
$media_type5->ext = Config::get('constants.MEDIA_TYPE_PDF_EXT');
$media_type5->save();
$media_type6 = new Mediatype();
$media_type6->name = Config::get('constants.MEDIA_TYPE_MPG');
$media_type6->slug = Str::slug(Config::get('constants.MEDIA_TYPE_MPG'));
$media_type6->ext = Config::get('constants.MEDIA_TYPE_MPG_EXT');
$media_type6->save();
$media_type7 = new Mediatype();
$media_type7->name = Config::get('constants.MEDIA_TYPE_MP3');
$media_type7->slug = Str::slug(Config::get('constants.MEDIA_TYPE_MP3'));
$media_type7->ext = Config::get('constants.MEDIA_TYPE_MP3_EXT');
$media_type7->save();
// CATEGORIES
$categories = new Categoryname();
$categories->name = 'Storia';
$categories->slug = Str::slug('Storia');
$categories->parent_id = null;
$categories->save();
$categories1 = new Categoryname();
$categories1->name = 'Scienza';
$categories1->slug = Str::slug('Scienza');
$categories1->parent_id = null;
$categories1->save();
$categories2 = new Categoryname();
$categories2->name = 'Tecnologia';
$categories2->slug = Str::slug('Tecnologia');
$categories2->parent_id = null;
$categories2->save();
$categories3 = new Categoryname();
$categories3->name = 'Storia della scienza';
$categories3->slug = Str::slug('Storia della scienza');
$categories3->parent_id = Categoryname::where('name', 'Storia')->first()->id;
$categories3->save();
$categories4 = new Categoryname();
$categories4->name = 'Fisica';
$categories4->slug = Str::slug('Fisica');
$categories4->parent_id = Categoryname::where('name', 'Scienza')->first()->id;
$categories4->save();
$categories5 = new Categoryname();
$categories5->name = 'Chimica';
$categories5->slug = Str::slug('Chimica');
$categories5->parent_id = Categoryname::where('name', 'Scienza')->first()->id;
$categories5->save();
// creo utente
$credentials = ['email' => '*****@*****.**', 'password' => 'password'];
$user = Sentinel::registerAndActivate($credentials);
echo "<pre>";
print_r($user);
echo "</pre>";
}
public function run()
{
// STATUS TYPES
$status_type = new Statustype();
$status_type->type = Config::get('constants.STATUS_TYPE_POST');
$status_type->slug = Str::slug(Config::get('constants.STATUS_TYPE_POST'));
$status_type->save();
$status_type1 = new Statustype();
$status_type1->type = Config::get('constants.STATUS_TYPE_USER');
$status_type1->slug = Str::slug(Config::get('constants.STATUS_TYPE_USER'));
$status_type1->save();
// STATUS NAMES
$status_name = new Statusname();
$status_name->name = Config::get('constants.STATUS_POST_INATTESAMODERAZIONE');
$status_name->slug = Str::slug(Config::get('constants.STATUS_POST_INATTESAMODERAZIONE'));
$status_name->statustype_id = Statustype::where('type', Config::get('constants.STATUS_TYPE_POST'))->first()->id;
$status_name->save();
$status_name1 = new Statusname();
$status_name1->name = Config::get('constants.STATUS_POST_INATTESAPUBBLICAZIONE');
$status_name1->slug = Str::slug(Config::get('constants.STATUS_POST_INATTESAPUBBLICAZIONE'));
$status_name1->statustype_id = Statustype::where('type', Config::get('constants.STATUS_TYPE_POST'))->first()->id;
$status_name1->save();
$status_name2 = new Statusname();
$status_name2->name = Config::get('constants.STATUS_POST_PUBBLICATO');
$status_name2->slug = Str::slug(Config::get('constants.STATUS_POST_PUBBLICATO'));
$status_name2->statustype_id = Statustype::where('type', Config::get('constants.STATUS_TYPE_POST'))->first()->id;
$status_name2->save();
$status_name3 = new Statusname();
$status_name3->name = Config::get('constants.STATUS_USER_INATTESAATTIVAZIONE');
$status_name3->slug = Str::slug(Config::get('constants.STATUS_USER_INATTESAATTIVAZIONE'));
$status_name3->statustype_id = Statustype::where('type', Config::get('constants.STATUS_TYPE_USER'))->first()->id;
$status_name3->save();
$status_name4 = new Statusname();
$status_name4->name = Config::get('constants.STATUS_USER_ATTIVATO');
$status_name4->slug = Str::slug(Config::get('constants.STATUS_USER_ATTIVATO'));
$status_name4->statustype_id = Statustype::where('type', Config::get('constants.STATUS_TYPE_USER'))->first()->id;
$status_name4->save();
$status_name5 = new Statusname();
$status_name5->name = Config::get('constants.STATUS_USER_BANNATO');
$status_name5->slug = Str::slug(Config::get('constants.STATUS_USER_BANNATO'));
$status_name5->statustype_id = Statustype::where('type', Config::get('constants.STATUS_TYPE_USER'))->first()->id;
$status_name5->save();
// MEDIA TYPES
$media_type = new Mediatype();
$media_type->name = Config::get('constants.MEDIA_TYPE_IMGJPG');
$media_type->slug = Str::slug(Config::get('constants.MEDIA_TYPE_IMGJPG'));
$media_type->ext = Config::get('constants.MEDIA_TYPE_IMGJPG_EXT');
$media_type->save();
$media_type1 = new Mediatype();
$media_type1->name = Config::get('constants.MEDIA_TYPE_IMGGIF');
$media_type1->slug = Str::slug(Config::get('constants.MEDIA_TYPE_IMGGIF'));
$media_type1->ext = Config::get('constants.MEDIA_TYPE_IMGGIF_EXT');
$media_type1->save();
$media_type2 = new Mediatype();
$media_type2->name = Config::get('constants.MEDIA_TYPE_IMGPNG');
$media_type2->slug = Str::slug(Config::get('constants.MEDIA_TYPE_IMGPNG'));
$media_type2->ext = Config::get('constants.MEDIA_TYPE_IMGPNG_EXT');
$media_type2->save();
$media_type3 = new Mediatype();
$media_type3->name = Config::get('constants.MEDIA_TYPE_IMGBMP');
$media_type3->slug = Str::slug(Config::get('constants.MEDIA_TYPE_IMGBMP'));
$media_type3->ext = Config::get('constants.MEDIA_TYPE_IMGBMP_EXT');
$media_type3->save();
$media_type4 = new Mediatype();
$media_type4->name = Config::get('constants.MEDIA_TYPE_IMGTIFF');
$media_type4->slug = Str::slug(Config::get('constants.MEDIA_TYPE_IMGTIFF'));
$media_type4->ext = Config::get('constants.MEDIA_TYPE_IMGTIFF_EXT');
$media_type4->save();
$media_type5 = new Mediatype();
$media_type5->name = Config::get('constants.MEDIA_TYPE_PDF');
$media_type5->slug = Str::slug(Config::get('constants.MEDIA_TYPE_PDF'));
$media_type5->ext = Config::get('constants.MEDIA_TYPE_PDF_EXT');
$media_type5->save();
$media_type6 = new Mediatype();
$media_type6->name = Config::get('constants.MEDIA_TYPE_MPG');
$media_type6->slug = Str::slug(Config::get('constants.MEDIA_TYPE_MPG'));
$media_type6->ext = Config::get('constants.MEDIA_TYPE_MPG_EXT');
$media_type6->save();
$media_type7 = new Mediatype();
$media_type7->name = Config::get('constants.MEDIA_TYPE_MP3');
$media_type7->slug = Str::slug(Config::get('constants.MEDIA_TYPE_MP3'));
$media_type7->ext = Config::get('constants.MEDIA_TYPE_MP3_EXT');
$media_type7->save();
// CATEGORIES
$categories = new Categoryname();
$categories->name = 'Storia';
$categories->slug = Str::slug('Storia');
$categories->parent_id = null;
$categories->save();
$categories1 = new Categoryname();
$categories1->name = 'Scienza';
$categories1->slug = Str::slug('Scienza');
$categories1->parent_id = null;
$categories1->save();
$categories2 = new Categoryname();
$categories2->name = 'Tecnologia';
$categories2->slug = Str::slug('Tecnologia');
$categories2->parent_id = null;
$categories2->save();
$categories3 = new Categoryname();
$categories3->name = 'Storia della scienza';
$categories3->slug = Str::slug('Storia della scienza');
$categories3->parent_id = Categoryname::where('name', 'Storia')->first()->id;
$categories3->save();
$categories4 = new Categoryname();
$categories4->name = 'Fisica';
$categories4->slug = Str::slug('Fisica');
$categories4->parent_id = Categoryname::where('name', 'Scienza')->first()->id;
$categories4->save();
$categories5 = new Categoryname();
$categories5->name = 'Chimica';
$categories5->slug = Str::slug('Chimica');
$categories5->parent_id = Categoryname::where('name', 'Scienza')->first()->id;
$categories5->save();
}