public function run() { $faker = Faker::create(); $bandera = 0; foreach (range(1, 100) as $index) { $fullName = $faker->name; $user = User::create(['usuario' => $faker->name, 'email' => $faker->email, 'password' => \Hash::make(123456), 'user_type' => 'usuario']); Persona::create(['id' => $user->id, 'dni' => $faker->buildingNumber, 'nombre' => $faker->name, 'apellidoP' => $faker->lastName, 'apellidoM' => $faker->lastName, 'direccion' => $faker->address, 'correo' => $faker->email, 'telefono' => $faker->phoneNumber, 'celular' => $faker->phoneNumber, 'foto' => 'asd', 'tipo' => 'Alumno', 'nivel' => $faker->randomElement(['Primaria', 'Secundaria']), 'grado' => $faker->randomElement(['1', '2', '3', '4', '5', '6']), 'seccion' => $faker->randomElement(['A', 'B', 'C']), 'estado' => true, 'apoderado_id' => $faker->randomElement([null, 1]), 'fotocheck_id' => $faker->randomElement([null, 1, 2, 3])]); $bandera++; } foreach (Persona::all() as $persona) { $valor = $persona->apoderado_id; if ($valor == null) { $persona->tipo = 'Apoderado'; $persona->nivel = null; $persona->grado = null; $persona->seccion = null; $persona->save(); } } }
$parameter = array(); $parameter['persona'] = $persona; $pdf = PDF::loadView('reportes/reportes', $parameter); return $pdf->stream(); }); Route::get('reportes/pruebas/{id}', ['as' => 'pruebaReporte', 'uses' => 'ReportesController@index']); Route::get('reportes', ['as' => 'frmReporte', 'uses' => 'ReportesController@frmReportes']); Route::post('reportes/deudas', ['as' => 'getDeudasByGradoAndSeccion', 'uses' => 'ReportesController@getDeudasByGradoAndSeccion']); Route::get('reportes/{nivel}-{grado}-{seccion}', ['as' => 'pdfReporte', 'uses' => 'ReportesController@pdfReporte']); //======================================== }); //para hacer el login Route::post('login', ['as' => 'login', 'uses' => 'AuthController@login']); Route::get('logout', ['as' => 'logout', 'uses' => 'AuthController@logout']); //====================================para probar - pruebas unitarias Route::get('prueba', ['as' => 'routePrueba']); Route::get('pruebaSelectAll/{var}', ['as' => 'pruebaSelect', 'uses' => 'PersonasController@selectPersona']); //Route::get('prueba/{id}',['as'=>'pruebaAsistencia','uses'=>'ReunionesController@pruebaselect']); Route::get('prueba/verDeudas/{criterio}', ['as' => 'pruebaverdeudas', 'uses' => 'MultasController@getPersonasbyMultas']); //Route::get('prueba/verDeudas/{id}',['as'=>'pruebaDeudas','uses'=>'MultasController@index']); //para probar excel Route::get('prueba/excel', function () { Excel::create('Laravel Excel', function ($excel) { $data = \SysCR\Entities\Persona::all(); $excel->sheet('Excel sheet', function ($sheet) use($data) { $sheet->fromArray($data); $sheet->setOrientation('landscape'); $sheet->freezeFirstRow(); }); })->export('xls'); });