PHP 프레임워크 Symfony를 사용하여 효율적인 CRM 시스템 개발

composer create-project symfony/website-skeleton crm

php bin/console doctrine:mapping:convert annotation ./src/Entity --from-database --force

<?php
namespace AppEntity;
use DoctrineORMMapping as ORM;
/**
* @ORMEntity(repositoryClass="AppRepositoryCustomerRepository")
* @ORMTable(name="customer")
*/
class Customer
{
/**
* @ORMId
* @ORMGeneratedValue
* @ORMColumn(type="integer")
*/
private $id;
/**
* @ORMColumn(type="string", length=255)
*/
private $name;
public function getId(): ?int
{
return $this->id;
}
public function getName(): ?string
{
return $this->name;
}
public function setName(string $name): self
{
$this->name = $name;
return $this;
}
}

php bin/console make:user

php bin/console doctrine:schema:update --force

namespace AppController;
use SymfonyBundleFrameworkBundleControllerAbstractController;
use SymfonyComponentHttpFoundationRequest;
use SymfonyComponentRoutingAnnotationRoute;
use SymfonyComponentSecurityHttpAuthenticationAuthenticationUtils;
class LoginController extends AbstractController
{
/**
* @Route("/login", name="app_login")
*/
public function login(AuthenticationUtils $authenticationUtils): Response
{
$error = $authenticationUtils->getLastAuthenticationError();
$lastUsername = $authenticationUtils->getLastUsername();
return $this->render('login.html.twig', [
'last_username' => $lastUsername,
'error' => $error,
]);
}
}

<?php
namespace AppEntity;
use DoctrineORMMapping as ORM;
/**
* @ORMEntity(repositoryClass="AppRepositoryCustomerRepository")
* @ORMTable(name="customer")
*/
class Customer
{
/**
* @ORMId
* @ORMGeneratedValue
* @ORMColumn(type="integer")
*/
private $id;
/**
* @ORMColumn(type="string", length=255)
*/
private $name;
/**
* @ORMColumn(type="string", length=255, nullable=true)
*/
private $address;
/**
* @ORMColumn(type="string", length=255, nullable=true)
*/
private $email;
/**
* @ORMColumn(type="string", length=255, nullable=true)
*/
private $phone;
public function getId(): ?int
{
return $this->id;
}
public function getName(): ?string
{
return $this->name;
}
public function setName(string $name): self
{
$this->name = $name;
return $this;
}
public function getAddress(): ?string
{
return $this->address;
}
public function setAddress(?string $address): self
{
$this->address = $address;
return $this;
}
public function getEmail(): ?string
{
return $this->email;
}
public function setEmail(?string $email): self
{
$this->email = $email;
return $this;
}
public function getPhone(): ?string
{
return $this->phone;
}
public function setPhone(?string $phone): self
{
$this->phone = $phone;
return $this;
}
}

namespace AppController;
use AppEntityCustomer;
use SymfonyBundleFrameworkBundleControllerAbstractController;
use SymfonyComponentHttpFoundationRequest;
use SymfonyComponentHttpFoundationResponse;
use SymfonyComponentRoutingAnnotationRoute;
class CustomerController extends AbstractController
{
/**
* @Route("/customer/list", name="customer_list")
*/
public function list(): Response
{
$customers = $this->getDoctrine()
->getRepository(Customer::class)
->findAll();
return $this->render('customer_list.html.twig', [
'customers' => $customers,
]);
}
}

{% extends 'base.html.twig' %}
{% block title %}Customers{% endblock %}
{% block body %}
<h2>Customers</h2>
<table class="table">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Address</th>
<th>Email</th>
<th>Phone</th>
</tr>
</thead>
<tbody>
{% for customer in customers %}
<tr>
<td>{{ customer.id }}</td>
<td>{{ customer.name }}</td>
<td>{{ customer.address }}</td>
<td>{{ customer.email }}</td>
<td>{{ customer.phone }}</td>
</tr>
{% endfor %}
</tbody>
</table>
{% endblock %}