public function fire()
{
$dir = $_SERVER['DOCUMENT_ROOT'] . "public/toUpload/";
try {
Excel::filter('chunk')->load($dir . 'data.xlsx')->chunk(250, function ($reader) {
foreach ($reader->toArray() as $data) {
$user = User::where('identification_card', $data['cedula'])->first();
if (!$user) {
$user = User::create(['identification_card' => $data['cedula'], 'name' => $data['nombre'], 'user_name' => str_replace(' ', '.', $data['nombre']), 'email' => $data['email'] ? $data['email'] : 'Sin registro', 'address' => $data['direccion'] ? $data['direccion'] : 'Sin registro', 'residency_city' => $data['ciudad'] ? $data['ciudad'] : 'Sin registro', 'phone' => $data['tel1'] ? $data['tel1'] : 'Sin registro', 'mobile_phone' => $data['tel2'] ? $data['tel2'] : 'Sin registro', 'document_type' => 0, 'roles_id' => 4]);
}
$credit = CreditRequest::where('user_id', intval($user->id))->first();
if (!$credit) {
$c = new CreditRequest();
$c->user_id = intval($user->id);
$c->value = intval($data['limitecredito']);
$c->state = 1;
$c->location = 3;
$c->responsible = 18;
$c->save();
} else {
$credit->value = $data['limitecredito'];
$credit->save();
}
}
});
echo $message = "El archivo se ha guardado en la base de datos.";
} catch (Exception $e) {
echo $message = "No se ha guardar . Intenta subirlo de nuevo.";
}
Mail::send('emails.excel', ['msn' => $message], function ($m) use($message) {
$m->to('*****@*****.**', 'Creditos Lilipink')->subject('Archivos actualizados');
});
array_map('unlink', glob($_SERVER['DOCUMENT_ROOT'] . "/toUpload/*"));
}
public function run()
{
$faker = Faker::create();
Role::Create(['name' => 'superAdmin']);
Role::Create(['name' => 'admin']);
Role::Create(['name' => 'POS']);
Role::Create(['name' => 'register']);
foreach (range(1, 10) as $i) {
$nameExtend = $faker->name;
$nameExtend = explode(' ', $nameExtend);
$name = array_shift($nameExtend);
$last_name = implode(" ", $nameExtend);
User::create(['name' => $name, 'last_name' => $last_name, 'user_name' => $faker->userName, 'email' => $faker->email, 'password' => \Hash::make(123456), 'roles_id' => $faker->randomElement([1, 2, 3]), 'location' => '1']);
}
}
private function createUser($input)
{
$user = User::create($input);
$user->user_name = str_replace(' ', '.', $input['name'] . '.' . $input['last_name']);
$user->roles_id = 5;
$user->birth_city = $input['instead_expedition'];
$user->whereIsWorking = $input['whereIsWorking'];
$user->isWorking = $input['isWorking'];
$user->save();
return $user;
}
