/**
  * Update the specified pet in storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function update($id)
 {
     $pet = Pet::findOrFail($id);
     $data = Input::all();
     $data['user_id'] = Confide::user()->id;
     $validator = Validator::make($data, Pet::$rules);
     $response = [];
     $response['data'] = $data;
     if ($validator->fails()) {
         $response['success'] = false;
         $response['errors'] = $validator->errors();
         if (Request::ajax()) {
             return Response::json($response);
         } else {
             return Redirect::back()->withErrors($validator->errors());
         }
     }
     $pet->update($data);
     $response['success'] = true;
     $response['errors'] = [];
     if (Request::ajax()) {
         return Response::json($response);
     } else {
         return Redirect::action('UsersController@showProfile', Confide::user()->id);
     }
 }

 /**
  * @return $this
  */
 public function home()
 {
     if (Confide::User()) {
         $this->dsp->content = Confide::user()->getContent();
     }
     return View::make('dispatch')->with(['dsp' => $this->dsp]);
 }

 /**
  * @param $club_id
  * @return bool
  */
 public static function isExist($club_id)
 {
     $count = DB::table('userclubs')->where('user_id', '=', Confide::user()->id)->where('club_id', '=', $club_id)->count();
     if ($count == 0) {
         return false;
     }
     return true;
 }

 public function getlivrabileFactura($id_factura)
 {
     $ids = self::getIDsDepartamente(Confide::getDepartamenteUser());
     $sql = self::getlivrabileFacturateNefacturate($id_factura, true);
     $factura = self::getFactura($id_factura);
     $livrabile = DB::select($sql);
     return View::make('livrabile_factura.list')->with('livrabile', $livrabile)->with('factura', $factura);
 }

 public function getIndex()
 {
     $user = Confide::user();
     if (!$user->isStaff() && Patient::find($user->id) == null) {
         return Redirect::route('patient.create');
     } else {
         return View::make('home/index', compact('user'));
     }
 }

 /**
  * Provide an array of strings that map to valid roles.
  * @param array $roles
  * @return stdClass
  */
 public function validateRoles(array $roles)
 {
     $user = Confide::user();
     $roleValidation = new stdClass();
     foreach ($roles as $role) {
         $roleValidation->{$role} = empty($user) ? false : $user->hasRole($role);
     }
     return $roleValidation;
 }

 public function uploadUserImage()
 {
     $user = Confide::user();
     $user->img_path = $this->getAndMoveFile('file');
     if ($user->save()) {
         return Redirect::action('UsersController@show', $user->id);
     } else {
         throw new Exception("user image not updated!");
     }
 }

 public static function logAudit($entity, $action, $description)
 {
     $audit = new Audit();
     $audit->date = date('Y-m-d');
     $audit->description = $description;
     $audit->user = Confide::user()->username;
     $audit->entity = $entity;
     $audit->action = $action;
     $audit->save();
 }

 public function showAll()
 {
     $user = Confide::user();
     $patients = Patient::join('user', 'user.id', '=', 'patient.user_id')->get();
     if ($user->isStaff()) {
         return View::make('home.patient.show-all', compact('user', 'patients'));
     } else {
         return Redirect::route('home.index');
     }
 }

 public function createComment($conversation)
 {
     $user = Confide::user();
     $comment = new Comment();
     $comment->conversation_id = $conversation->id;
     $comment->user_id = $user->id;
     $comment->fill(Input::all());
     $comment->save();
     return Redirect::route('conversation.show', array($conversation->id));
 }

 public function getEditInvestitie($id)
 {
     $departamente = Confide::getDepartamenteUser();
     $tva = self::getCoteTVA();
     $imobil_class = new \Codecorner\Imobil\Controllers\ImobileController();
     $imobile = $imobil_class->getImobil();
     $cheltuieli = self::getCheltuieliSF();
     $investitie = DB::select("SELECT\n            investitie.id,\n            investitie.denumire,\n            investitie.cota_indiviza_spatii_locuit,\n            investitie.cota_indiviza_spatii_alta_destinatie,\n            investitie.finantare_nerambursabila_por,\n            investitie.cofinantare_ap_eligibil,\n            investitie.cofinantare_uat_eligibil,\n            investitie.cofinantare_ap_neeligibil_ad,\n            investitie.cofinantare_uat_neeligibil,\n            investitie.cofinantare_ap_neeligibil_sl,\n            investitie.id_imobil,\n            investitie.id_departament,\n            investitie.id_tva,\n            l.denumire AS localitate,\n            j.denumire AS judet,\n            i.adresa\n            FROM por12_investitie investitie\n            INNER JOIN imobil i ON i.id = investitie.id_imobil AND i.logical_delete = 0\n            LEFT OUTER JOIN judet j ON j.id_judet = i.id_judet AND j.logical_delete = 0\n            LEFT OUTER JOIN localitate l ON l.id_localitate = i.id_localitate AND l.logical_delete = 0\n            WHERE investitie.id = :id_investitie", array('id_investitie' => $id));
     return View::make('investitie_por_axa12.edit')->with('investitie', $investitie[0])->with('imobile', $imobile)->with('tva', $tva)->with('finantare_nerambursabila_por', 60)->with('cofinantare_ap_neeligibil_ad', 100)->with('departamente', self::object_to_array($departamente))->with('cheltuieli', $cheltuieli);
 }

 /**
  * Display a listing of notifications
  *
  * @return Response
  */
 public function index()
 {
     $data = Input::all();
     $pagination = Input::has('pagination') ? Input::get('pagination') : 10;
     // FILTRA RESULTADOS
     $notifications = Notification::where(function ($query) {
         switch (Input::get('view')) {
             case 'next':
                 // AGENDADAS
                 $query->where('date', '>', date('Y-m-d H:i:s'));
                 break;
             case 'all':
                 // $query->where( 'user_id', Confide::user()->id );
                 break;
             default:
                 // NÃO LIDAS
                 $query->where('date', '<', date('Y-m-d H:i:s'))->where('status', 0);
                 break;
         }
         if (Input::has('type')) {
             $query->where('type', Input::get('type'));
         }
         if (Input::has('owner_type')) {
             $query->where('owner_type', Input::get('owner_type'));
         }
         if (Input::has('owner_id')) {
             $query->where('owner_id', Input::get('owner_id'));
         }
         if (Input::has('order')) {
             $query->orderBy('date', Input::get('order'));
         }
     })->where('user_id', Confide::user()->id)->orderBy('date', Input::get('order', 'DESC'))->paginate($pagination);
     switch (Input::get('view', 'unread')) {
         case 'next':
             $labels['nothing'] = 'Nenhuma notificação agendada';
             break;
         case 'all':
             $labels['nothing'] = 'Nenhuma notificação ainda';
             break;
         default:
             // case 'unread'
             $labels['nothing'] = 'Nenhuma notificação não lida';
             break;
     }
     $labels['count_next'] = Notification::where('user_id', Confide::user()->id)->where('date', '>', date('Y-m-d H:i:s'))->count();
     $labels['count_all'] = Notification::where('user_id', Confide::user()->id)->count();
     $labels['count_unread'] = Notification::where('user_id', Confide::user()->id)->where('date', '<', date('Y-m-d H:i:s'))->where('status', false)->count();
     //$notifications->getCollection()->paginate( $pagination );//->paginate( $pagination ;
     if (Request::ajax()) {
         return View::make('notifications.panels.index', compact('notifications', 'labels'));
     } else {
         return View::make('notifications.index', compact('notifications', 'labels'));
     }
 }

 /**
  * @param string $backUrl
  * @param int $club_id
  * @return \Illuminate\Http\RedirectResponse
  */
 public function add($backUrl = 'home', $club_id = 0)
 {
     if ($club_id == 0) {
         return Redirect::route($backUrl);
     }
     $userclub = new Userclub();
     $userclub->user_id = Confide::user()->id;
     $userclub->club_id = $club_id;
     $userclub->save();
     return Redirect::route($backUrl);
 }

 public function __construct()
 {
     // Fetch the User object, or set it to false if not logged in
     if (Confide::User()) {
         $this->logged_in_user = Confide::User();
     } else {
         $this->logged_in_user = false;
     }
     View::share('logged_in_user', $this->logged_in_user);
     View::share('success_message', $this->success_message);
 }

 public function getBalance($wallet_id)
 {
     $balance = 0;
     if (!Auth::guest()) {
         $user = Confide::user();
         $balanceCoin = Balance::where('user_id', '=', $user->id)->where('wallet_id', '=', $wallet_id)->first();
         if (isset($balanceCoin->amount)) {
             $balance = $balanceCoin->amount;
         }
     }
     return $balance;
 }

 /**
  * @return string
  */
 public function beforeHome()
 {
     // Extend function home()
     if (!Confide::user()->isManager()) {
         return $this->dsp->content = $this->directory . ".nomanager";
     } else {
         if (!Confide::user()->isDomaine()) {
             return $this->dsp->content = $this->directory . ".nodomaine";
         }
     }
     // Sinon procedure Home normale
 }

 public function getCurrentOrdersUser($market_id, $user_id = '')
 {
     if (Auth::guest()) {
         return false;
     }
     $user = Confide::user();
     if ($user_id == '') {
         $user_id = $user->id;
     }
     $orders = Order::where('market_id', '=', $market_id)->where('user_id', '=', $user_id)->whereIn('status', $this->status_active)->orderBy('created_at', 'desc')->get();
     return $orders;
 }

 public function resetpassword($user)
 {
     if (!Confide::forgotPassword($user->email)) {
         if (!Api::make(array('error'))) {
             return Response::json(array('result' => 'error'));
         }
     } else {
         if (!Api::make(array('success'))) {
             return Response::json(array('result' => 'success'));
         }
     }
 }

 public function getSeriiFacturare()
 {
     $ids = self::getIDsDepartamente(Confide::getDepartamenteUser());
     $sql = "SELECT \n          sf.id,\n          sf.serie,\n          sf.numar,\n          sf.id_entitate,\n          ent.denumire AS entitate\n          FROM serie_factura sf\n          INNER JOIN entitate ent ON ent.id = sf.id_entitate AND ent.logical_delete = 0\n          WHERE ";
     if (!Entrust::can("administrare_platforma")) {
         /*$sql .= 
           " INNER JOIN departament d ON d.id_entitate = ent.id AND d.logical_delete = 0" .
           " AND d.id IN (" . $ids . ")";*/
         $sql .= " EXISTS(SELECT id FROM departament WHERE departament.id_entitate = sf.id_entitate AND departament.logical_delete = 0\n                    AND departament.id IN (" . $ids . ")) AND ";
     }
     $sql .= " sf.logical_delete = 0 ORDER BY ent.id, sf.serie";
     //dd($sql);
     $serii = DB::select($sql);
     return View::make('serii_facturare.list')->with('serii', $serii);
 }

 public static function submitApplication($data)
 {
     $member_id = array_get($data, 'member_id');
     $loanproduct_id = array_get($data, 'loanproduct_id');
     $member = Member::findorfail($member_id);
     $loanproduct = Loanproduct::findorfail($loanproduct_id);
     $application = new Loanaccount();
     $application->member()->associate($member);
     $application->loanproduct()->associate($loanproduct);
     $application->application_date = array_get($data, 'application_date');
     $application->amount_applied = array_get($data, 'amount_applied');
     $application->interest_rate = $loanproduct->interest_rate;
     $application->period = $loanproduct->period;
     $application->repayment_duration = array_get($data, 'repayment_duration');
     $application->save();
     Audit::logAudit(date('Y-m-d'), Confide::user()->username, 'loan application', 'Loans', array_get($data, 'amount_applied'));
 }