Artigo

Atualizar artigo

Título:

Slug:

Conteúdo:

<p>CRUD para gerenciar currículos na Medeiros Corporation Inc. Abaixo, segue o guia passo a passo para a implementação desse sistema:</p>

<h3>Estrutura do Projeto</h3>

<h4>Estrutura de Arquivos:</h4>
<pre>library-system
├── src
│   ├── Controller
│   │   ├── ResumeController.php
│   ├── Model
│   │   ├── Resume.php
│   ├── View
│   │   ├── ResumeView.php
│   ├── Service
│   │   ├── ResumeService.php
├── public
│   └── index.php
├── config
│   └── database.php
├── vendor
└── composer.json
</pre>

<h3>1. Modelo (Model)</h3>
<p><code>src/Model/Resume.php</code></p>
<pre><code><?php

namespace LibrarySystem\Model;

class Resume {
    private $id_resume;
    private $collaborator_id;
    private $education;
    private $experience;
    private $skills;

// Getters and Setters
    public function getIdResume() {
        return $this->id_resume;
    }

public function setIdResume($id) {
        $this->id_resume = (int)$id; // Sanitização
    }

public function getCollaboratorId() {
        return $this->collaborator_id;
    }

public function setCollaboratorId($id) {
        $this->collaborator_id = (int)$id; // Sanitização
    }

public function getEducation() {
        return $this->education;
    }

public function setEducation($education) {
        $this->education = htmlspecialchars(strip_tags($education)); // Sanitização
    }

public function getExperience() {
        return $this->experience;
    }

public function setExperience($experience) {
        $this->experience = htmlspecialchars(strip_tags($experience)); // Sanitização
    }

public function getSkills() {
        return $this->skills;
    }

public function setSkills($skills) {
        $this->skills = htmlspecialchars(strip_tags($skills)); // Sanitização
    }
}</code></pre>

<h3>2. Visualização (View)</h3>
<p><code>src/View/PositionView.php</code></p>
<pre><code>html
/html</code></pre>

<h3>3. Controlador (Controller)</h3>
<p><code>src/Controller/ResumeController.php</code></p>
<pre><code><?php

namespace LibrarySystem\Controller;

use LibrarySystem\Model\Resume;
use LibrarySystem\Service\ResumeService;

class ResumeController {
    private $resumeService;

public function __construct($dbConnection) {
        $this->resumeService = new ResumeService($dbConnection);
    }

public function create() {
        if ($_SERVER['REQUEST_METHOD'] === 'POST') {
            $resume = new Resume();
            $resume->setCollaboratorId($_POST['collaborator_id']);
            $resume->setEducation($_POST['education']);
            $resume->setExperience($_POST['experience']);
            $resume->setSkills($_POST['skills']);
            $this->resumeService->createResume($resume);
            header('Location: /resumes');
        }
    }

public function read() {
        $resumes = $this->resumeService->getAllResumes();
        include '../src/View/ResumeView.php';
    }

public function update($id) {
        if ($_SERVER['REQUEST_METHOD'] === 'POST') {
            $resume = new Resume();
            $resume->setIdResume($id);
            $resume->setCollaboratorId($_POST['collaborator_id']);
            $resume->setEducation($_POST['education']);
            $resume->setExperience($_POST['experience']);
            $resume->setSkills($_POST['skills']);
            $this->resumeService->updateResume($resume);
            header('Location: /resumes');
        } else {
            $resume = $this->resumeService->getResume($id);
            include '../src/View/ResumeView.php';
        }
    }

public function delete($id) {
        $this->resumeService->deleteResume($id);
        header('Location: /resumes');
    }
}</code></pre>

<h3>4. Serviço (Service)</h3>
<p><code>src/Service/ResumeService.php</code></p>
<pre><code><?php

namespace LibrarySystem\Service;

use LibrarySystem\Model\Resume;

class ResumeService {
    private $db;

public function __construct($dbConnection) {
        $this->db = $dbConnection;
    }

public function createResume(Resume $resume) {
        $stmt = $this->db->prepare("INSERT INTO resumes (collaborator_id, education, experience, skills) VALUES (:collaborator_id, :education, :experience, :skills)");
        $stmt->bindValue(':collaborator_id', $resume->getCollaboratorId());
        $stmt->bindValue(':education', $resume->getEducation());
        $stmt->bindValue(':experience', $resume->getExperience());
        $stmt->bindValue(':skills', $resume->getSkills());
        return $stmt->execute();
    }

public function getAllResumes() {
        $stmt = $this->db->query("SELECT * FROM resumes");
        return $stmt->fetchAll(\PDO::FETCH_ASSOC);
    }

public function getResume($id) {
        $stmt = $this->db->prepare("SELECT * FROM resumes WHERE id_resume = :id");
        $stmt->bindValue(':id', (int)$id);
        $stmt->execute();
        return $stmt->fetch(\PDO::FETCH_ASSOC);
    }

public function updateResume(Resume $resume) {
        $stmt = $this->db->prepare("UPDATE resumes SET collaborator_id = :collaborator_id, education = :education, experience = :experience, skills = :skills WHERE id_resume = :id");
        $stmt->bindValue(':collaborator_id', $resume->getCollaboratorId());
        $stmt->bindValue(':education', $resume->getEducation());
        $stmt->bindValue(':experience', $resume->getExperience());
        $stmt->bindValue(':skills', $resume->getSkills());
        $stmt->bindValue(':id', $resume->getIdResume());
        return $stmt->execute();
    }

public function deleteResume($id) {
        $stmt = $this->db->prepare("DELETE FROM resumes WHERE id_resume = :id");
        $stmt->bindValue(':id', (int)$id);
        return $stmt->execute();
    }
}</code></pre>

<h3>5. Configuração do Banco de Dados</h3>
<p>Verifique se a conexão com o banco de dados está configurada corretamente em <strong>config/database.php</strong>.</p>

<h3>6. Roteamento</h3>
<p>Implemente o roteamento em <strong>public/index.php</strong> para chamar os métodos corretos do controlador de acordo com as requisições.</p>

<h3>Considerações Finais</h3>
<p>Este CRUD para gerenciamento de currículos segue as melhores práticas de sanitização, encapsulamento e um design orientado a objetos. Adapte e expanda conforme necessário para atender às necessidades específicas da Medeiros Corporation Inc.</p>

Autor:

Status:

Voltar