/** * Initialize the DeleteModel class */ public function init() { try { parent::init(); } catch (Exception $e) { throw new Exception('Une erreur est survenue durant le chargement du module: ' . $e->getMessage()); } try { $pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION; $this->db = new PDO('mysql:host=' . _HOST_ . ';dbname=' . _DATABASE_, _LOGIN_, _PASSWORD_, $pdo_options); $this->db->exec('SET NAMES utf8'); } catch (Exception $e) { throw new Exception('Connexion à la base de données impossible: ' . $e->getMessage()); } }
function existingrg($rg = null) { $this->load->model('VisitorModel'); $visitor = new VisitorModel(); if ($visitor->searchforrg($rg)) { return false; } return true; }
public function save() { if ($this->isLogged()) { $page = $this->getPage(); $this->load->model('LendingModel'); $lending = new LendingModel(); $this->load->model('VisitorModel'); $visitor = new VisitorModel(); $this->load->model('FlowModel'); $flow = new FlowModel(); $lendingdata['id'] = null; $lendingdata['datehour'] = date("y/m/d H:i"); $lendingdata['cabinet'] = $this->input->get('cabinet'); $lendingdata['visitor'] = $this->input->get('visitor'); $lendingdata['status'] = true; $flowdata['id'] = null; $flowdata['datehour'] = date("y/m/d H:i"); $flowdata['visitor'] = $lendingdata['visitor']; if ($lendingdata['visitor']) { $inactive = $visitor->search($lendingdata['visitor']); if ($inactive['status'] == false) { $savefail = array("class" => "danger", "message" => "O visitante selecionado está desativado no sistema."); $data['savefail'] = $savefail; $this->session->set_userdata('id', null); $this->session->set_userdata('datehour', null); $this->session->set_userdata('visitor', null); $this->session->set_userdata('visitor_name', null); $this->session->set_userdata('visitor_cpf', null); $this->session->set_userdata('visitor_rg', null); $this->session->set_userdata('visitor_phone', null); $this->session->set_userdata('visitor_status', false); $this->load->view('template/user/header', $page); $this->load->view('user/newloan', $data); $this->load->view('template/public/footer'); return false; } } else { $savefail = array("class" => "danger", "message" => "Nenhum visitante foi selecionado."); $data['savefail'] = $savefail; $this->session->set_userdata('id', null); $this->session->set_userdata('datehour', null); $this->session->set_userdata('visitor', null); $this->session->set_userdata('visitor_name', null); $this->session->set_userdata('visitor_cpf', null); $this->session->set_userdata('visitor_rg', null); $this->session->set_userdata('visitor_phone', null); $this->session->set_userdata('visitor_status', false); $this->load->view('template/user/header', $page); $this->load->view('user/newloan', $data); $this->load->view('template/public/footer'); return false; } $aux = $lending->activelist(); $blocked = false; $nkey = null; foreach ($aux as $verify) { if ($verify->visitor == $lendingdata['visitor']) { $nkey = $verify->cabinet; $blocked = true; } } if (!$blocked) { if ($lending->save($lendingdata)) { if ($flow->save($flowdata)) { redirect(base_url('cabinet')); } else { return false; } } else { return false; } } else { $savefail = array("class" => "danger", "message" => "O visitante selecionado já possui um empréstimo. Armário:" . $nkey); $data['savefail'] = $savefail; $this->session->set_userdata('id', null); $this->session->set_userdata('datehour', null); $this->session->set_userdata('visitor', null); $this->session->set_userdata('visitor_name', null); $this->session->set_userdata('visitor_cpf', null); $this->session->set_userdata('visitor_rg', null); $this->session->set_userdata('visitor_phone', null); $this->session->set_userdata('visitor_status', false); $this->load->view('template/user/header', $page); $this->load->view('user/newloan', $data); $this->load->view('template/public/footer'); return false; } } }
public function select($visitor = null) { if ($this->isLogged()) { $page = $this->getPage(); $this->load->model('VisitorModel'); $visitormd = new VisitorModel(); switch ($this->session->userdata('role')) { case '1': $this->load->view('public/norole'); break; case '2': $aux = $visitormd->search($visitor); $this->load->view('template/user/header', $page); $visitorarray = array('visitor_name' => $aux['name'], 'visitor_cpf' => $aux['cpf'], 'visitor_rg' => $aux['rg'], 'visitor_phone' => $aux['phone'], 'visitor_status' => true); $this->session->set_userdata('visitor', $aux['id']); $this->session->set_userdata($visitorarray); $this->load->view('user/newentrance'); break; } $this->load->view('template/public/footer'); } }