Example #1
0
 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/*"));
 }
Example #2
0
 public function getDataEnterpricing($id)
 {
     if (Input::get('type') == 'credit') {
         $id = CreditRequest::find($id)->user_id;
     }
     $user = User::find($id);
     return ['user' => $user, 'type' => Input::get('type'), 'routes' => ['enable' => Input::get('enable'), 'disable' => Input::get('disable')]];
 }
 public function saveCredit($id)
 {
     $data = $this->prepareData($this->data);
     $credit = CreditRequest::where('user_id', '=', $id);
     $data = ["value" => $data["creditValue"]];
     $credit->update($data);
     return true;
 }
 public function verificatorCredit($id)
 {
     $credit = CreditRequest::where('user_id', $id)->first();
     $locations = Location::where('id', $credit->location)->first();
     $variables = General_variables::all();
     $data = $this->prepareData($this->data);
     $message = [];
     $countCredit = 0;
     if ($variables[0]->value < $data['data_credit']) {
         $countCredit++;
     } else {
         $message = $message + ['data_credit' => 'no superado datacredito'];
     }
     if ($variables[1]->value < $data['data_monthly']) {
         $countCredit++;
     } else {
         $message = $message + ['data_monthly' => 'no superado datos mensuales'];
     }
     if ($variables[2]->value < $data['value_monthly']) {
         $countCredit++;
     } else {
         $message = $message + ['value_monthly' => 'no superado el valor mensual'];
     }
     if ($variables[2]->value < $data['value_monthly']) {
         $countCredit++;
     } else {
         $message = $message + ['value_monthly' => 'no superado el valor mensual'];
     }
     if (isset($data['reference1']) or isset($data['reference2'])) {
         $countCredit++;
     } else {
         $message = $message + ['reference' => 'no tienen ninguna referencia confirmada'];
     }
     if (isset($data['files'])) {
         $countCredit++;
     } else {
         $message = $message + ['files' => 'Los archivos no estan correctos'];
     }
     if (strtolower($locations->name) == "medellin") {
         if ($data['fenalco'] > 0) {
             $countCredit++;
         } else {
             $message = $message + ['fenalco' => 'Fenalco no fue superado'];
         }
         if ($countCredit == 7) {
             return ['return' => true];
         } else {
             return $message + ['accept' => '1'];
         }
     } else {
         if ($countCredit == 6) {
             return ['return' => true];
         } else {
             return $message + ['accept' => '1'];
         }
     }
 }
Example #5
0
 public function delete($id)
 {
     $credit = CreditRequest::where('point', $id)->first();
     if ($credit) {
         return Redirect::route('point')->with('message_error', 'el punto de venta no se puede eliminar por que esta siendo utilizado');
     }
     $point = Point::find($id);
     $point->delete();
     return Redirect::route('point')->with('message', 'el punto de venta se elimino exitosamente');
 }
 private function setData($identification)
 {
     $extracts = Extract::where("nit", $identification)->orderBy('id', 'DESC')->get();
     if ($extracts) {
         $user = User::whereRaw("roles_id = 4 and identification_card = {$identification}")->first();
         $minPay = ExcelDaily::where("cedula", $identification)->get();
         $quota = CreditRequest::where('user_id', $user->id)->first();
         $day = explode('-', date("y-m-d"));
         $q = $quota ? $quota->value : 300000;
         $this->data = ['user' => $user, 'day' => $day, 'extracts' => $extracts, 'quota' => intval($q), 'minPay' => $minPay, 'months' => $this->getMonths()];
         return true;
     }
     return false;
 }
Example #7
0
 private function exportUsers()
 {
     $users = User::where('roles_id', '>=', '4')->select('id', 'roles_id', 'card as Tarjeta', 'identification_card as Cedula', 'name as Nombre1', 'second_name as Nombre2', 'last_name as Apellido1', 'second_last_name as Apellido2', 'email as Email', 'mobile_phone as Celular', 'location as Ciudad', 'created_at as Fecha de creación')->orderBy('roles_id', 'DESC')->get();
     foreach ($users as $key => $user) {
         $credit = CreditRequest::where('user_id', $user->id)->first();
         $users[$key]['Referencia1'] = $credit ? $credit->name_reference : null;
         $users[$key]['Tel_Referencia1'] = $credit ? $credit->phone_reference : null;
         $users[$key]['Referencia2'] = $credit ? $credit->name_reference2 : null;
         $users[$key]['Tel_Referencia2'] = $credit ? $credit->phone_reference2 : null;
         $users[$key]['Ciudad'] = $user->Ciudad ? Location::find($user->Ciudad)->name : 'Sin región';
         $users[$key]['Tienda'] = $credit ? Point::find($credit->point)['name'] : 'Sin punto';
         $users[$key]['Cupo_Credito'] = $credit ? $credit->value : null;
         $users[$key]['Emprend'] = $user->roles_id == 5 ? 'Si' : 'No';
         $users[$key]['¿Empr. credito?'] = $credit && $user->roles_id == 5 ? 'Si' : $user->roles_id == 5 ? 'No' : 'N/A';
         $users[$key]['Nombre referido'] = $user->roles_id == 5 ? $user['referred_name'] : 'N/A';
         $users[$key]['Cedula referido'] = $user->roles_id == 5 ? $user['referred_document'] : 'N/A';
     }
     return $users;
 }
 protected function creditRegister()
 {
     $input = Input::all();
     $rules = $this->getRules(true);
     $validator = $this->validate($input, $rules);
     if ($validator->fails()) {
         return Redirect::back()->withErrors($validator)->withInput()->with(['isCredit' => true]);
     }
     $user = $this->createUser($input);
     $user->hasCredit = 1;
     $user->save();
     $creditRequest = CreditRequest::create($input);
     $creditRequest->files = $input['files'];
     $creditRequest->user_id = $user['id'];
     $creditRequest->priority = 2;
     $creditRequest->location = $input['location'];
     $creditRequest->point = $input['point'];
     $creditRequest->save();
     return Redirect::route('enterprisingRegister')->with(['message' => "Te has registrado satisfactoriamente. Espera aprobación", 'isCredit' => true]);
 }
Example #9
0
 public function saveCredit($files, $user)
 {
     $data = $this->prepareData($this->data);
     if ($user) {
         $priority = Role::where('id', '=', $user->roles_id)->first();
         $priority = $priority->priority;
         $this->entity->responsible = $user->id;
         $credit = CreditRequest::where('user_id', '=', $user->id)->first();
         if ($credit) {
             return ["message" => "no puedes solicitar mas creditos"] + ["role" => false];
         }
     } else {
         $priority = 0;
     }
     $user = new User($data);
     $user->roles_id = 4;
     $user->save();
     $this->entity->priority = $priority;
     $this->entity->files = $files;
     $this->entity->fill($this->prepareData($this->data));
     $user->CreditRequest()->save($this->entity);
     return ["message" => "la solicitud de credito fue enviada"] + ["role" => true];
 }
Example #10
0
 public static function notify()
 {
     if (Auth::user()->roles_id == 3) {
         $user = Auth::user();
         $credits = CreditRequest::whereRaw('notify = 0 and state = "" and location = ' . $user->location);
         return $credits->count();
     }
 }
Example #11
0
 public function showState()
 {
     $user = Auth::user();
     $credit = CreditRequest::where('user_id', $user->id)->first();
     $extracts = Extract::where('nit', $user->identification_card)->get();
     $vencidos = 0;
     $debe = 0;
     foreach ($extracts as $extract) {
         $vencidos += intval($extract->dias_vencidos);
         $debe += intval($extract->saldo_credito_diferido);
     }
     return View::make('front.state', compact('extracts', 'vencidos', 'debe', 'user', 'credit'));
 }